Can you please open a ticket about this? On Thursday, 9 October 2014 23:15:14 UTC-5, Babu Annamalai wrote: > > 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 calls 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 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 that, 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.
