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 <kevin.bowl...@gmail.com> 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 web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
