Hi,
I'm running web2py from an Apache server (in production), and it
occasionally shuts down, i.e. fails to connect to the DAL until Apache is
reset with 'sudo service apache2 restart'. The version of web2py is:
Version 2.0.0 (2012-05-16 18:23:15) dev
Running on Apache/2.2.14 (Ubuntu)
Here's the traceback:
TRACEBACK
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/main.py", line 538, in wsgibase
session._try_store_on_disk(request, response)
File "/home/www-data/web2py/gluon/globals.py", line 649, in _try_store_on_disk
cPickle.dump(dict(self), response.session_file)
File "/home/V_ENVS/Web2py/lib/python2.6/copy_reg.py", line 74, in _reduce_ex
getstate = self.__getstate__
File "/home/www-data/web2py/gluon/dal.py", line 6918, in __getattr__
self.__allocate()
File "/home/www-data/web2py/gluon/dal.py", line 6911, in __allocate
self._record = self._table[int(self)]
File "/home/www-data/web2py/gluon/dal.py", line 7186, in __getitem__
return self._db(self._id == key).select(limitby=(0,1)).first()
File "/home/www-data/web2py/gluon/dal.py", line 8189, in select
return adapter.select(self.query,fields,attributes)
File "/home/www-data/web2py/gluon/dal.py", line 1410, in select
rows = response(sql)
File "/home/www-data/web2py/gluon/dal.py", line 1400, in response
self.execute(sql)
File "/home/www-data/web2py/gluon/dal.py", line 1489, in execute
return self.log_execute(*a, **b)
File "/home/www-data/web2py/gluon/dal.py", line 1483, in log_execute
ret = self.cursor.execute(*a, **b)
File "/home/www-data/web2py/gluon/contrib/pymysql/cursors.py", line 108, in
execute
self.errorhandler(self, exc, value)
File "/home/www-data/web2py/gluon/contrib/pymysql/connections.py", line 184,
in defaulterrorhandler
raise errorclass, errorvalue
InterfaceError: (0, '')
Any idea about what's going on? Thanks for all the help guys!
