I have a turbogears (1.0b1) project, proxied by Apache 2 (through url rewriting), which behaves strangely after running for about a day or so. Requesting any page whose template or controller function uses the database model (SQLObject + MySQL) causes the CherryPy traceback below. Pages which make no use of the database continue to be served perfectly. If I restart the server, everything works fine again, until some hours later, when the database-driven pages once again stop working.
Any ideas what's going on? I searched this group and found someone who seemed to have the same problem back in May: http://groups.google.com/group/turbogears/browse_thread/thread/1fa623091084c93e/ea3abb80207e6294?lnk=gst&q=InterfaceError&rnum=2#ea3abb80207e6294 http://groups.google.com/group/turbogears/browse_thread/thread/97d80c2aaa2cc07a/85a4b55c1938a2bc?lnk=gst&q=InterfaceError&rnum=3#85a4b55c1938a2bc But if he ever figured it out, he didn't mention how. Here's the traceback: The server encountered an unexpected condition which prevented it from fulfilling the request. Page handler: <bound method Root.people of <clml.controllers.Root object at 0x2aaaaddfd490>> Traceback (most recent call last): File "/usr/lib/python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/cherrypy/_cphttptools.py", line 105, in _run self.main() File "/usr/lib/python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/cherrypy/_cphttptools.py", line 254, in main body = page_handler(*virtual_path, **self.params) File "<string>", line 3, in people File "/usr/lib64/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/controllers.py", line 326, in expose output = database.run_with_transaction( File "<string>", line 5, in run_with_transaction File "/usr/lib64/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/database.py", line 246, in so_rwt retval = func(*args, **kw) File "<string>", line 5, in _expose File "/usr/lib64/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/controllers.py", line 343, in <lambda> mapping, fragment, args, kw))) File "/usr/lib64/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/controllers.py", line 367, in _execute_func output = errorhandling.try_call(func, *args, **kw) File "/usr/lib64/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/errorhandling.py", line 71, in try_call return func(self, *args, **kw) File "/home/max/projects/clml_www/clml_www-TRUNK/clml/clml/controllers.py", line 35, in people people = list(Person.select(Person.q.job=="Lab Director")) + \ File "/usr/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1860-py2.4.egg/sqlobject/sresults.py", line 155, in __iter__ return iter(list(self.lazyIter())) File "/usr/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1860-py2.4.egg/sqlobject/sresults.py", line 163, in lazyIter return conn.iterSelect(self) File "/usr/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1860-py2.4.egg/sqlobject/dbconnection.py", line 775, in iterSelect select, keepConnection=True))) File "/usr/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1860-py2.4.egg/sqlobject/dbconnection.py", line 704, in __init__ self.dbconn._executeRetry(self.rawconn, self.cursor, self.query) File "/usr/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1860-py2.4.egg/sqlobject/mysql/mysqlconnection.py", line 76, in _executeRetry return cursor.execute(query) File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 137, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler raise errorclass, errorvalue InterfaceError: (0, '') --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
