Environment: Ubuntu 12.04; Web2py 2.9.11-stable
Let me describe the problem as below:
- We use 2 DAL instance talking to 2 different databases, each with a
connection pool of 10
- We make many frequent DAL calls using both the DAL connections which
results in many objects in the connection pool
- At some point, web2py starts throwing an OperationalError with MySQL
server has gone away when closing a connection. The stack trace is as below:
S'Traceback (most recent call last):\n File “.../app/gluon/main.py", line
543, in wsgibase\n BaseAdapter.close_all_instances(\'rollback\')\n File
“.../app/gluon/dal.py", line 611, in close_all_instances\n
db._adapter.close(action)\n File “.../app/gluon/dal.py", line 591, in
close\n getattr(self, action)()\n File “…/app/gluon/dal.py", line 1922,
in rollback\n return self.connection.rollback()\nOperationalError:
(2006, \'MySQL server has gone away\')\n'
This made the whole app very unstable with error tickets occurring almost
for every action.
We had tried wrapping all our DAL with exception handlers for this error
but we were unable to get this sorted. Eventually, the only way I could fix
this is to put an exception handler around the the code block which is
throwing the error as below:
# added this to line 611 in dal.py
try:
db._adapter.close(action)
except:
pass
Note this, this error is reproducible in older versions of web2py as well.
I would like to bring this forward to the group for further action on the
same.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
