SQL Bad Query

Known bugs reported by PacsOne users
Post Reply
don1673
Posts:12
Joined:Sat Jan 21, 2006 1:17 am
SQL Bad Query

Post by don1673 » Thu May 29, 2008 8:24 pm

Hello,

My PacsOne Server with version 6.1.1 was running fine for 2 months, and now it keep stop working more often, and every time happen like that only way I can do is restart the server?
And here the log was show me the error.
Thanks for your help.
Don.

Thu May 29 09:01:36 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT * FROM dbjob LEFT JOIN applentity ON dbjob.aetitle=applentity.title WHERE (dbjob.aetitle LIKE '_%') AND dbjob.status='submitted' AND dbjob.schedule=-1 ORDER BY dbjob.priority DESC LIMIT 20;]: Lost connection to MySQL server during query
Thu May 29 09:01:38 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT title,maxsessions FROM applentity ORDER BY priority DESC]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:39 2008 ERROR - EXECUTE: SQL Bad Query [UPDATE dbjob SET schedule=-1 WHERE schedule=9 AND status='submitted';]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:40 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT * FROM cronjob;]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:41 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT * FROM autopurge WHERE enable=1;]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:42 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT uid FROM postroute LIMIT 20;]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:43 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT * FROM config;]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:46 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT * FROM dbjob LEFT JOIN applentity ON dbjob.aetitle=applentity.title WHERE (dbjob.aetitle LIKE '_%') AND dbjob.status='submitted' AND dbjob.schedule=-1 ORDER BY dbjob.priority DESC LIMIT 20;]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:47 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT title,maxsessions FROM applentity ORDER BY priority DESC]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:48 2008 ERROR - EXECUTE: SQL Bad Query [UPDATE dbjob SET schedule=-1 WHERE schedule=9 AND status='submitted';]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:49 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT * FROM cronjob;]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:50 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT * FROM autopurge WHERE enable=1;]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:52 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT uid FROM postroute LIMIT 20;]: Can't connect to MySQL server on 'localhost' (10061)
Thu May 29 09:01:53 2008 ERROR - RUNQUERY: SQL Bad Query [SELECT * FROM config;]: Can't connect to MySQL server on 'localhost' (10061)

pacsone
Site Admin
Posts:3149
Joined:Tue Sep 30, 2003 2:47 am

Post by pacsone » Thu May 29, 2008 8:34 pm

These errors mean the MySQL daemon/service has stopped or crashed and PacsOne could no longer connect to it. Try restarting MySQL service and the errors should disappear.

don1673
Posts:12
Joined:Sat Jan 21, 2006 1:17 am

Post by don1673 » Thu May 29, 2008 9:44 pm

Can I upgrade Mysql from current ver 4.1.15 to ver 5.0.24a and my ibdata1 won't get hurt?

Thanks.
Don.

pacsone
Site Admin
Posts:3149
Joined:Tue Sep 30, 2003 2:47 am

Post by pacsone » Fri May 30, 2008 2:26 am

There should be standard procedures for upgrading MySQL from 4.1.15 to 5.0.x, and you can search the MySQL documentation on upgrade instructions.

Post Reply