have you ever tried #sudo /etc/init.d/apache2 stop #sudo /etc/init.d/apache2 start
if this does not work, use this: http://www.web2pyslices.com/slice/show/1356/setup-web2pyapachesslmod-wsgipostgresql-in-few-seconds Ovidio Marinho Falcao Neto Web Developer [email protected] [email protected] ITJP - itjp.net.br 83 8826 9088 - Oi 83 9334 0266 - Claro Brasil 2012/7/8 Osman Masood <[email protected]> > > 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! >
