Re: [Condor-users] Quill and condor 7.0.0

[Michela Thiémard <michela.thiemard@xxxxxxx>]

Erik Paulson wrote:
> On Wed, Feb 20, 2008 at 05:36:53PM +0100, Michela Thi?mard wrote:
>   
> > Alain Roy wrote:
> >     
> > > > Does anybody successfully use quill on condor 7.0.0?
> > > >
> > > > I still can't correctly use it on a rhel4 cluster.
> > > >     
> > > >         
> > > Can you be specific about what problems you are having?
> > >   
> > >       
> > Essentially, the postgresql database is never populated and 
> > condor_history returns a Segmentation fault.
> >
> > You can find more details on my quill configuration here
> > https://lists.cs.wisc.edu/archive/condor-users/2008-February/msg00055.shtml
> >
> > Thanks
> >
> > Michela
> >
> >     
>
> What does the Quill log say during this time period? What does the
> schedd_sql.log look like?
>   

The schedd_sql.log and  sql.log files are empty :-( and Quill log says:

2/21 09:15:30 ******** Start of Polling Job Queue Log ********
2/21 09:15:30 Get JobQueue Polling Information
2/21 09:15:30 SQL Query = SELECT last_file_mtime, last_file_size, 
last_next_cmd_offset, last_cmd_offset, last_cmd_type, last_cmd_key, 
last_cmd_mytype, last_cmd_targettype, last_cmd_name, last_cmd_value from 
JobQueuePollingInfo where scheddname = 'ditexsrv5.epfl.ch'
2/21 09:15:30 === Current Probing Information ===
2/21 09:15:30 fsize: 37440              mtime: 1203529285
2/21 09:15:30 first log entry: 68 CreationTimestamp 1169803565
2/21 09:15:30 JOB QUEUE POLLING RESULT: NO CHANGE
2/21 09:15:30 ********* End of Polling Job Queue Log *********
2/21 09:15:30 ******** Start of Polling Event Log ********
2/21 09:15:30 ********* End of Polling Event Log *********
2/21 09:15:30 SQL COMMAND: UPDATE currencies SET lastupdate = '2/21/2008 
09:15:0 CET' WHERE datasource = 'ditexsrv5.epfl.ch'
2/21 09:15:30 SQL COMMAND: COMMIT TRANSACTION
2/21 09:15:30 ******** Start of Polling XML Log ********
2/21 09:15:30 ********* End of Polling XML Log *********
2/21 09:15:30 ++++++++ Sending Quill ad to collector ++++++++
2/21 09:15:30 Trying to update collector <128.178.109.21:9618>
2/21 09:15:30 Attempting to send update via UDP to collector 
ditexsrv4.epfl.ch <128.178.109.21:9618>
2/21 09:15:30 ++++++++ Sent Quill ad to collector ++++++++
2/21 09:15:33 Getting monitoring info for pid 4397
2/21 09:15:40 ******** Start of Polling Job Queue Log ********
2/21 09:15:40 Get JobQueue Polling Information
2/21 09:15:40 SQL Query = SELECT last_file_mtime, last_file_size, 
last_next_cmd_offset, last_cmd_offset, last_cmd_type, last_cmd_key, 
last_cmd_mytype, last_cmd_targettype, last_cmd_name, last_cmd_value from 
JobQueuePollingInfo where scheddname = 'ditexsrv5.epfl.ch'
2/21 09:15:40 === Current Probing Information ===
2/21 09:15:40 fsize: 37440              mtime: 1203529285
2/21 09:15:40 first log entry: 68 CreationTimestamp 1169803565
2/21 09:15:40 JOB QUEUE POLLING RESULT: NO CHANGE
2/21 09:15:40 ********* End of Polling Job Queue Log *********



But, the log files of postgresql are full of

WARNING:  there is no transaction in progress

I found on postgresql forum that it could mean that a commit or an abort 
was typed unnecessarily...


Michela