Yes, I have an app and did a 5 connection pool. It seems MySQL by default closes connections every 8 hours. Therefore, if nobody accesses the app overnight, it dies.
I know other things that use connection pools like Openfire XMPP server poll it quite regularly to keep it open. I don't know if that is necessary. Perhaps catch the exception, try a reconnect, and raise if that fails? For now I'm working around it by disabling the connection pool. Regards, Kevin On Feb 22, 11:16 pm, mdipierro <[email protected]> wrote: > Sorry my collection is very slow... > > It cannot b predicted when a connection fail so if it fails in between > a trasaction, i.e. when serving a request, it will generate a ticket > but it should do so only once since this connection will be discared > (not recycled) and a new one will be placed in the pool. > > Please tell me more about this problem. Do you get it occasionally or > repeatedly? What is the pattern? > > On Feb 21, 8:17 pm, Kevin Bowling <[email protected]> wrote: > > > 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.
