Re: [Condor-users] quill issue

["Manjunath Shankar" <manjunath.shankar@xxxxxxxxx>]

Hi,

 

I tried to configure Quill for my setup. Somehow the following error has been written to the log and the table Horizontal_history is always empty. I did check the database and I see that the column is present. Can someone let me know the reason for this problem and what can be done to fix this.

 

 

8/8 22:07:29 ******************************************************
8/8 22:07:29 ** condor_quill.exe (CONDOR_QUILL) STARTING UP
8/8 22:07:29 ** C:\Condor\bin\condor_quill.exe
8/8 22:07:29 ** $CondorVersion: 6.8.5 May 17 2007 $
8/8 22:07:29 ** $CondorPlatform: INTEL-WINNT50 $
8/8 22:07:29 ** PID = 6076
8/8 22:07:29 ** Log last touched time unavailable (No such file or directory)
8/8 22:07:29 ******************************************************
8/8 22:07:29 Using config source: C:\Condor\condor_config
8/8 22:07:29 Using local config sources:
8/8 22:07:29    C:\Condor/condor_config.local
8/8 22:07:29 DaemonCore: Command Socket at < 192.168.0.103:3234>
8/8 22:07:29 main_init() called
8/8 22:07:29 configuring quill options from config file
8/8 22:07:29 Using Job Queue File C:\Condor/spool/job_queue.log
8/8 22:07:29 Using Database IpAddress = 192.168.0.103:5432
8/8 22:07:29 Using Database Name = Quill
8/8 22:07:29 Using Database Connection Information: host=192.168.0.103 port=5432 user=quillwriter dbname=Quill8/8 22:07:29 Using Polling Period = 10
8/8 22:07:29 Using Purge History Duration = 180 days
8/8 22:07:29 Using History Cleaning Interval = 24 hours
8/8 22:07:29 Using PostgreSQL version 80204
8/8 22:07:29 Schema Check OK!
8/8 22:07:29 Schema Version Check OK!
8/8 22:07:30 ******** Start of Probing Job Queue Log File ********
8/8 22:07:30 === Current Probing Information ===
8/8 22:07:30 fsize: 85  mtime: 1186636049
8/8 22:07:30 first log entry: 44 CreationTimestamp 1185739473
8/8 22:07:30 POLLING RESULT: COMPRESSED
8/8 22:07:30 Reading from file C:\Condor/spool/job_queue.log.43
8/8 22:07:30 End reading from file C:\Condor/spool/job_queue.log.43
8/8 22:07:30 ********* End of Probing Job Queue Log File *********
8/8 22:07:30 ++++++++ Sending schedd ad to collector ++++++++
8/8 22:07:30 ++++++++ Sent schedd ad to collector ++++++++
8/8 22:07:34 Starting purge of old History rows
8/8 22:07:34 [SQL EXECUTION ERROR2] ERROR:  column "EnteredHistoryTable" does not exist at character 85

8/8 22:07:34 [SQL: DELETE FROM History_Vertical WHERE cid IN (SELECT cid FROM History_Horizontal WHERE "EnteredHistoryTable" < timestamp with time zone 'now' - interval '180 days');]
8/8 22:07:34 [QUILL] Purge History Rows --- ERROR
8/8 22:07:34  ERROR:  column "EnteredHistoryTable" does not exist at character 85
 

 

Regards,

 

Manjunath Shankar.