Thanks for the response! Actually, the problem was fixed by updating mod_wsgi from 2.8 to 3.3 (the latest version). I'm using Ubuntu, BTW.
Thanks On Sunday, July 8, 2012 4:55:51 PM UTC-7, Ovidio Marinho wrote: > > 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! >> > > --
