Hi
I've been using sqlobject without problems on my home centos4 machine.
When trying on the centos4 dedicated server, my webware appserver keeps on giving the error message below.
What I don't understand, is that I can access the mysql database without any problems, even from another python process with sqlobject.
I think this is a mysqldb issue, but can anyone tell me how to detect and reinitialize such failure?
File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/sresults.py", line 189, in count [edit]
count = self.accumulate('COUNT(*)')
File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/sresults.py", line 173, in accumulate [edit]
return conn.accumulateSelect(self, *expressions)
File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/dbconnection.py", line 391, in accumulateSelect [edit]
val = self.queryOne(q)
File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/dbconnection.py", line 358, in queryOne [edit]
return self._runWithConnection(self._queryOne, s)
File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/dbconnection.py", line 229, in _runWithConnection [edit]
val = meth(conn, *args)
File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/dbconnection.py", line 351, in _queryOne [edit]
self._executeRetry(conn, c, s)
File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/mysql/mysqlconnection.py", line 66, in _executeRetry [edit]
return cursor.execute(query)
File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 163, in execute [edit]
File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 35, in defaulterrorhandler [edit]
OperationalError: (2006, 'MySQL server has gone away')