[SQLObject] mysql connection losses

[Victor Ng <vn...@ma...>]

I'm getting the following error in my application using SQLObject 0.5.1 
and MySQL.

Any ideas on how to work around this problem?  I'd like to be able to 
set an expiry option on the connection pool so that connections will 
only be used 'N' number of times before they get closed and discarded.

   16912   File 
"/usr/local/lib/python2.3/site-packages/SQLObject/Join.py", line 104, 
in performJoin
   16913     inst.id)
   16914   File 
"/usr/local/lib/python2.3/site-packages/SQLObject/DBConnection.py", 
line 328, in _SO_selectJoin
   16915     return self.queryAll("SELECT %s FROM %s WHERE %s = %s" %
   16916   File 
"/usr/local/lib/python2.3/site-packages/SQLObject/DBConnection.py", 
line 136, in queryAll
   16917     return self._runWithConnection(self._queryAll, s)
   16918   File 
"/usr/local/lib/python2.3/site-packages/SQLObject/DBConnection.py", 
line 72, in _runWithConnection
   16919     val = meth(conn, *args)
   16920   File 
"/usr/local/lib/python2.3/site-packages/SQLObject/DBConnection.py", 
line 129, in _queryAll
   16921     c.execute(s)
   16922   File 
"/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py", line 61, 
in execute
   16923     r = self._query(query)  16924   File 
"/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py", line 168, 
in _query  16925     rowcount = self._BaseCursor__do_query(q)
   16926   File 
"/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py", line 112, 
in __do_query
   16927     db.query(q)
   16928 OperationalError: (2013, 'Lost connection to MySQL server 
during query')