[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Condor-users] Quill SQL logs contain empty CurrentTime field



I've tried to set up a small Condor grid running on version 7.6.2 , populated with both Windows 7 and Ubuntu 10.04 clients. The master is running a custom build of 7.6.2 on Scientific Linux 6
For Quill I enabled postgresql support and such. It's connecting just fine, and some stuff gets written to the database just fine.
I see entries being made in the various .sql logs , however when Quill tries to put some of the data into the database I see the following errors :


08/13/11 09:37:42 ******** Start of Polling Job Queue Log ********
08/13/11 09:37:42 JOB QUEUE POLLING RESULT: NO CHANGE
08/13/11 09:37:42 ********* End of Polling Job Queue Log *********
08/13/11 09:37:42 ******** Start of Polling Event Log ********
08/13/11 09:37:42 [SQL EXECUTION ERROR2] ERROR:  syntax error at or near ")"
LINE 1: ...0#1313219940', 'user001@xxxxxxxxxxxx', 3275, time(), 'WRK000...
                                                             ^
08/13/11 09:37:42 [SQL: INSERT INTO Matches (machine_id, match_time, proc_id, GlobalJobId, username, cluster_id, CurrentTime, scheddname) VALUES ('slot1@xxxxxxxxxxxxxxxxxxxx', '8/13/2011 09:27:59 CEST', 0, 'WRK0009.domain.local#3275.0#1313219940', 'user001@xxxxxxxxxxxx', 3275, time(), 'WRK0009.domain.local')]
08/13/11 09:37:42 Executing Statement --- Error
08/13/11 09:37:42 sql = INSERT INTO Matches (machine_id, match_time, proc_id, GlobalJobId, username, cluster_id, CurrentTime, scheddname) VALUES ('slot1@xxxxxxxxxxxxxxxxxxxx', '8/13/2011 09:27:59 CEST', 0, 'WRK0009.domain.local#3275.0#1313219940', 'user001@xxxxxxxxxxxx', 3275, time(), 'WRK0009.domain.local')
08/13/11 09:37:42 >>>>>>>> Fail: Polling Event Log <<<<<<<<
08/13/11 09:37:42 ******** Start of Polling XML Log ********
08/13/11 09:37:42 ********* End of Polling XML Log *********
08/13/11 09:37:42 ++++++++ Sending Quill ad to collector ++++++++
08/13/11 09:37:42 ++++++++ Sent Quill ad to collector ++++++++

It happens with jobs submitted from both Windows and Linux clients: the CurrentTime field doesn't contain a valid number, instead it contains the string "time()" which seems to indicate  a problem with logging the current time at the moment of submission of the job. All machines use NTP so clocks are in sync.
Going through Google and the mailing archives didn't bring any results so I'm hoping somebody here can help me out.
Thanks in advance,
--
Jan-Albert van Ree


Jan-Albert van Ree
Linux System Administrator
MSuG MARIN Support Group
E mailto:J.A.v.Ree@xxxxxxxx
T +31 317 49 35 48

MARIN
2, Haagsteeg, P.O. Box 28, 6700 AA Wageningen, The Netherlands
T +31 317 49 39 11, F , I www.marin.nl