I get the following error. I have a 5 connection pool in my DAL
connection line. Shouldn't the DAL keep the connection alive or at
least mark it dead and reestablish or use another connection rather
than throwing an error 500?
Traceback (most recent call last):
File "gluon/restricted.py", line 173, in restricted
exec ccode in environment
File "/var/www/x/web2py/applications/conman/models/db.py", line 4,
in <module>
db=DAL("mysql://a:b...@localhost/c", pool_size=5)
File "gluon/sql.py", line 3764, in DAL
return SQLDB(uri, pool_size=pool_size, folder=folder,
db_codec=db_codec, check_reserved=check_reserved)
File "gluon/sql.py", line 929, in __init__
self._execute('SET FOREIGN_KEY_CHECKS=1;')
File "gluon/sql.py", line 928, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
File "/usr/lib/python2.6/site-packages/MySQLdb/cursors.py", line
173, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line
36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (2006, 'MySQL server has gone away')
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.