http://dev.mysql.com/doc/refman/5.7/en/gone-away.html
probably a timeout. Check the mysql.conf for timeout
On Saturday, 6 February 2016 13:32:36 UTC-6, Alexandru Asimionese wrote:
>
> Hi folks, an error like this, everything worked fine, and suddenly
>
> Traceback (most recent call last):
> File "/home/awsmarkets/webapps/web2pyuwsgi/web2py/gluon/main.py", line 543,
> in wsgibase
> BaseAdapter.close_all_instances('rollback')
> File "/home/awsmarkets/webapps/web2pyuwsgi/web2py/gluon/dal/connection.py",
> line 44, in close_all_instances
> db._adapter.close(action)
> File "/home/awsmarkets/webapps/web2pyuwsgi/web2py/gluon/dal/connection.py",
> line 24, in close
> getattr(self, action)()
> File
> "/home/awsmarkets/webapps/web2pyuwsgi/web2py/gluon/dal/adapters/base.py",
> line 1273, in rollback
> return self.connection.rollback()
> OperationalError: (2006, 'MySQL server has gone away')
>
>
> What usually cause this kind of errors?
>
> mysql> show processlist;
>
> | 17827742 | awsm | web510.webfaction.com:55760 | dbname | Sleep | 460 | |
> NULL | 0 | 0 |
> | 17828079 | awsm | web510.webfaction.com:57747 | dbname | Sleep | 9260 |
> | NULL | 0 | 0 |
> | 17830940 | awsm | web510.webfaction.com:48686 | dbname | Sleep | 9038 |
> | NULL | 0 | 0 |
> | 17830952 | awsm | web510.webfaction.com:48791 | dbname | Sleep | 9038 |
> | NULL | 0 | 0 |
> | 17846550 | awsm | web510.webfaction.com:50815 | dbname | Sleep | 6823 |
> | NULL | 0 | 0 |
> | 17846720 | awsm | web510.webfaction.com:52148 | dbname | Sleep | 6823 |
> | NULL | 0 | 0 |
> | 17846738 | awsm | web510.webfaction.com:52274 | dbname | Sleep | 6692 |
> | NULL | 0 | 0 |
> | 17847860 | awsm | web510.webfaction.com:59410 | dbname | Sleep | 6691 |
> | NULL | 0 | 0 |
> | 17847881 | awsm | web510.webfaction.com:59507 | dbname | Sleep | 6643 |
> | NULL | 0 | 0 |
> | 17848157 | awsm | web510.webfaction.com:33349 | dbname | Sleep | 6643 |
> | NULL | 0 | 0
>
> .... ....
>
> #30
> Appears its not closing connection
>
>
> db = DAL('mysql://awsm:>[email protected]/dbname',
> pool_size=8,
> check_reserved=['mysql'],
> lazy_tables=True,
> migrate=False)
>
>
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
