And I didn't need to restart apache because I had more than 6 user's
simultaneously.
With previous versions of web2py, I only obtained every hour without
use of application
Traceback (most recent call last):
File "gluon/restricted.py", line 178, in restricted
exec ccode in environment
File "/home/drayco/webapps/seccion36/web2py/applications/init/models/
db.py", line 16, in <module>
db=SQLDB('mysql://xxx:[email protected]/xxx',pool_size=10)
File "gluon/sql.py", line 933, in __init__
self._execute('SET FOREIGN_KEY_CHECKS=1;')
File "gluon/sql.py", line 932, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 35,
in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (2006, 'MySQL server has gone away')
But we only need to recall and everything works well
On Jun 2, 7:16 pm, drayco <[email protected]> wrote:
> One of my user told me that He sent in 2 times new registers, and he
> didn't obtain answer.
>
> In previous versions of web2py, I never got this error.
>
> On Jun 2, 7:03 pm, drayco <[email protected]> wrote:
>
> > Thank's a lot Dr. Massimo
>
> > do you use apache? Yes
> > mod_wsgi? Yes
> > do you use the built-in web server? No
> > do you see memory leaks? No
> > do you have web2py cron or on off? No
>
> > This is the firts error:
>
> > Traceback (most recent call last):
> > File "gluon/restricted.py", line 178, in restricted
> > exec ccode in environment
> > File "/home/drayco/webapps/seccion36/web2py/applications/init/
> > controllers/default.py", line 134, in <module>
> > File "gluon/globals.py", line 96, in <lambda>
> > self._caller = lambda f: f()
> > File "gluon/tools.py", line 2036, in f
> > return action(*a, **b)
> > File "/home/drayco/webapps/seccion36/web2py/applications/init/
> > controllers/default.py", line 101, in crea_benef
> > return dict(form=crud.create(db.benefs2, next=URL(r=request,
> > f='benefs2_regist'),onaccept=update_benef2))
> > File "gluon/tools.py", line 2623, in create
> > deletable=False,
> > File "gluon/tools.py", line 2567, in update
> > onvalidation=onvalidation, keepvalues=keepvalues):
> > File "gluon/sqlhtml.py", line 870, in accepts
> > onvalidation,
> > File "gluon/html.py", line 1328, in accepts
> > status = self._traverse(status)
> > File "gluon/html.py", line 456, in _traverse
> > newstatus = c._traverse(status) and newstatus
> > File "gluon/html.py", line 456, in _traverse
> > newstatus = c._traverse(status) and newstatus
> > File "gluon/html.py", line 456, in _traverse
> > newstatus = c._traverse(status) and newstatus
> > File "gluon/html.py", line 456, in _traverse
> > newstatus = c._traverse(status) and newstatus
> > File "gluon/html.py", line 463, in _traverse
> > newstatus = self._validate()
> > File "gluon/html.py", line 1120, in _validate
> > (value, errors) = validator(value)
> > File "gluon/validators.py", line 413, in __call__
> > if self.dbset(field == value).count():
> > File "gluon/sql.py", line 3224, in count
> > return self.select('count(*)')[0]._extra['count(*)']
> > File "gluon/sql.py", line 3096, in select
> > rows = response(query)
> > File "gluon/sql.py", line 3091, in response
> > db._execute(query)
> > File "gluon/sql.py", line 932, in <lambda>
> > self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> > File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 166, in
> > execute
> > self.errorhandler(self, exc, value)
> > File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 35,
> > in defaulterrorhandler
> > raise errorclass, errorvalue
> > OperationalError: (1053, 'Server shutdown in progress')
>
> > And 1 second after:
>
> > Traceback (most recent call last):
> > File "gluon/main.py", line 435, in wsgibase
> > BaseAdapter.close_all_instances(BaseAdapter.rollback)
> > File "gluon/sql.py", line 754, in close_all_instances
> > action(instance)
> > File "gluon/sql.py", line 1350, in rollback
> > self._connection.rollback()
> > OperationalError: (2006, 'MySQL server has gone away')
>
> > On Jun 2, 6:47 pm, mdipierro <[email protected]> wrote:
>
> > > Try
>
> > >http://web2py.com/examples/static/1.77.3/web2py_src.zip
>
> > > some version are there and some not. Those obviously buggy have been
> > > deleted.
>
> > > Anyway, I'd like to understand the problem.
> > > do you use apache? mod_wsgi?
> > > do you use the built-in web server?
> > > do you see memory leaks?
> > > do you have web2py cron or on off?
>
> > > Massimo
>
> > > On Jun 2, 6:06 pm, drayco <[email protected]> wrote:
>
> > > > Where can I download web2py 1.77.3?
>
> > > > Because my application that's run in webfaction, with MySQL and web2py
> > > > 1.78.3 needs to restart 4 times at day?
>
> > > > And MySql rollback today, and I obtained a error that's say "server in
> > > > process to shutdown"
>
> > > > With web2py 1.77.3 and 1.66.5 I didn't need to do that action.
>
>
