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

Re: [Condor-users] QUILL - errors in the log



what version of postgresql? what platform
(Linux/Windows/Solaris/etc...)? have you done, createlang plpgsql
<dbname> ?






On Thu, Dec 16, 2010 at 9:16 AM, Santanu Das <santanu@xxxxxxxxxxxxxxxxx> wrote:
> Hi there,
>
> Does anyone know how to fix the problem PostgreSQL/Quill problem I described
> below?
>
> Cheers,
> Santanu
>
>
> On 13/12/10 14:18, Santanu Das wrote:
>
> Dear all,
>
> I'm running Quill for couple of days now; found these error in log on the
> submit host:
>
>
> 12/13 10:59:44 ******** Start of Polling Job Queue Log ********
> 12/13 10:59:44 JOB QUEUE POLLING RESULT: INIT
> 12/13 10:59:44 [SQL EXECUTION ERROR2] ERROR:  date/time field value out of
> range: "11/26/2010 19:08:27 GMT"
> LINE 1: ...eSize) VALUES ('serv07.cam', 43752, '11/26/201...
>                                                              ^
> HINT:  Perhaps you need a different "datestyle" setting.
>
> 12/13 10:59:44 [SQL: INSERT INTO ClusterAds_Horizontal (scheddname,
> cluster_id, QDate, Owner, RemoteWallClockTime, RemoteUserCpu, JobUniverse,
> Cmd, JobPrio, ImageSize) VALUES ('serv07.hep.phy.cam.a
> c.uk', 43752, '11/26/2010 19:08:27 GMT', 'pltatl16', 0.000000, 0.000000, 5,
> '/home/pltatl16/.globus/.gass_cache/local/md5/31/25cdaa08f20acf080884b2696a1e64/md5/b1/2f96acf830f807d32e0e712d415129/dat
> a', 0, 47)]
> 12/13 10:59:44 JobQueueCollection::loadAd - ERROR [SQL] INSERT INTO
> ClusterAds_Horizontal (scheddname, cluster_id, QDate, Owner,
> RemoteWallClockTime, RemoteUserCpu, JobUniverse, Cmd, JobPrio, Image
> Size) VALUES ('serv07.cam', 43752, '11/26/2010 19:08:27 GMT', 'pltatl16',
> 0.000000, 0.000000, 5,
> '/home/pltatl16/.globus/.gass_cache/local/md5/31/25cdaa08f20acf080884b2696a1e64/md5/b1
> /2f96acf830f807d32e0e712d415129/data', 0, 47)
> 12/13 10:59:44 >>>>>>>> Fail: Polling Job Queue Log <<<<<<<<
> 12/13 10:59:44 ******** Start of Polling Event Log ********
> 12/13 10:59:44 [SQL EXECUTION ERROR2] ERROR:  date/time field value out of
> range: "12/13/2010 00:00:04 GMT"
> LINE 1: ...bs_Horizontal_History SET EnteredCurrentStatus = ('12/13/201...
>                                                              ^
> HINT:  Perhaps you need a different "datestyle" setting.
>
> 12/13 10:59:44 [SQL: UPDATE Jobs_Horizontal_History SET EnteredCurrentStatus
> = ('12/13/2010 00:00:04 GMT') WHERE scheddname = 'serv07.cam' and
> scheddbirthdate = 1290088364 and cluster
> _id = 174773 and proc_id = 0]
> 12/13 10:59:44 Executing Statement --- Error
> 12/13 10:59:44 sql = UPDATE Jobs_Horizontal_History SET EnteredCurrentStatus
> = ('12/13/2010 00:00:04 GMT') WHERE scheddname = 'serv07.cam' and
> scheddbirthdate = 1290088364 and cluster
> _id = 174773 and proc_id = 0
> 12/13 10:59:44 [SQL EXECUTION ERROR2] ERROR:  date/time field value out of
> range: "12/13/2010 10:59:44 GMT"
> LINE 1: ...schedd_sql.log.copy', 'serv07.cam', '12/13/201...
>                                                              ^
> HINT:  Perhaps you need a different "datestyle" setting.
>
> 12/13 10:59:44 [SQL: INSERT INTO Error_Sqllogs (LogName, Host, LastModified,
> ErrorSql, LogBody, ErrorMessage) VALUES
> ('/home/condorr/log/schedd_sql.log.copy', 'serv07.cam', '12/13/201
> 0 10:59:44 GMT', 'UPDATE Jobs_Horizontal_History SET EnteredCurrentStatus =
> (''12/13/2010 00:00:04 GMT'') WHERE scheddname = ''serv07.cam'' and
> scheddbirthdate = 1290088364 and cluste
> r_id = 174773 and proc_id = 0', '', '')]
> 12/13 10:59:44 Executing Statement --- Error
> 12/13 10:59:44 sql = INSERT INTO Error_Sqllogs (LogName, Host, LastModified,
> ErrorSql, LogBody, ErrorMessage) VALUES
> ('/home/condorr/log/schedd_sql.log.copy', 'serv07.cam', '12/13/201
> 0 10:59:44 GMT', 'UPDATE Jobs_Horizontal_History SET EnteredCurrentStatus =
> (''12/13/2010 00:00:04 GMT'') WHERE scheddname = ''serv07.cam'' and
> scheddbirthdate = 1290088364 and cluste
> r_id = 174773 and proc_id = 0', '', '')
> 12/13 10:59:44 >>>>>>>> Fail: Polling Event Log <<<<<<<<
> 12/13 10:59:44 ******** Start of Polling XML Log ********
> 12/13 10:59:44 ********* End of Polling XML Log *********
> 12/13 10:59:44 ++++++++ Sending Quill ad to collector ++++++++
> 12/13 10:59:44 ++++++++ Sent Quill ad to collector ++++++++
>
>
> Does anyone know what am I doing wrong here? From the PostgreSQL docs, it
> doesn't accept the first value without an explicit datestyle setting for the
> current version. Does anyone know a fix?
>
> Cheers,
> Santanu
>
>
>
>
>
>
> _______________________________________________
> Condor-users mailing list
> To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with a
> subject: Unsubscribe
> You can also unsubscribe by visiting
> https://lists.cs.wisc.edu/mailman/listinfo/condor-users
>
> The archives can be found at:
> https://lists.cs.wisc.edu/archive/condor-users/
>
>
> _______________________________________________
> Condor-users mailing list
> To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with a
> subject: Unsubscribe
> You can also unsubscribe by visiting
> https://lists.cs.wisc.edu/mailman/listinfo/condor-users
>
> The archives can be found at:
> https://lists.cs.wisc.edu/archive/condor-users/
>
>