why is counting records "select count(*) ...." crashing your mysql
database? It seems to me the problem is not the web2py version.
On Jun 2, 7:03 pm, drayco <antrod...@gmail.com> 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 <mdipie...@cs.depaul.edu> 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 <antrod...@gmail.com> 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.
