I need some advice to prevent these errors. I am experiencing the following issues w/ my project:
1. CherryPy: TimeoutError [Fri Feb 01 08:31:22 2008] [error] File "/var/lib/python-support/python2.5/cherrypy/_cprequest.py", line 511, in run [Fri Feb 01 08:31:22 2008] [error] raise cherrypy.TimeoutError() [Fri Feb 01 08:31:22 2008] [error] TimeoutError 2. SQLAlchemy: IndexError, OperationalError [Fri Feb 01 08:36:23 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 657, in __getitem__ [Fri Feb 01 08:36:23 2008] [error] return list(self[item:item+1])[0] [Fri Feb 01 08:36:23 2008] [error] IndexError: list index out of range [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/engine/strategies.py", line 80, in connect [Fri Feb 01 11:32:01 2008] [error] raise exceptions.DBAPIError.instance(None, None, e) [Fri Feb 01 11:32:01 2008] [error] OperationalError: (OperationalError) (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") None None 3. mod_wsgi: Exception mod_wsgi (pid=18122): Exception occurred within WSGI script '/var/local/braydon/wsgi_bridge.py'. 4. Apache: segment fault [Fri Feb 01 11:32:02 2008] [notice] seg fault or similar nasty error detected in the parent process ----- The /var/log/apache2/error.log: [Fri Feb 01 08:31:22 2008] [error] [01/Feb/2008:08:31:22] Traceback (most recent call last): [Fri Feb 01 08:31:22 2008] [error] File "/var/lib/python-support/python2.5/cherrypy/_cpwsgi.py", line 126, in __init__ [Fri Feb 01 08:31:22 2008] [error] response = self.request.run(meth, path, qs, rproto, headers, rfile) [Fri Feb 01 08:31:22 2008] [error] File "/var/lib/python-support/python2.5/cherrypy/_cprequest.py", line 511, in run [Fri Feb 01 08:31:22 2008] [error] raise cherrypy.TimeoutError() [Fri Feb 01 08:31:22 2008] [error] TimeoutError [Fri Feb 01 08:31:22 2008] [error] [Fri Feb 01 08:36:23 2008] [error] [01/Feb/2008:08:36:23] HTTP Traceback (most recent call last): [Fri Feb 01 08:36:23 2008] [error] File "/var/lib/python-support/python2.5/cherrypy/_cprequest.py", line 551, in respond [Fri Feb 01 08:36:23 2008] [error] cherrypy.response.body = self.handler() [Fri Feb 01 08:36:23 2008] [error] File "/var/lib/python-support/python2.5/cherrypy/_cpdispatch.py", line 24, in __call__ [Fri Feb 01 08:36:23 2008] [error] return self.callable(*self.args, **self.kwargs) [Fri Feb 01 08:36:23 2008] [error] File "/var/local/braydon/sparrow/http.py", line 43, in default [Fri Feb 01 08:36:23 2008] [error] return render(args, kwargs, location_st) [Fri Feb 01 08:36:23 2008] [error] File "/var/local/braydon/sparrow/templates.py", line 354, in render [Fri Feb 01 08:36:23 2008] [error] return render_skeleton(location, location_st, kwargs) [Fri Feb 01 08:36:23 2008] [error] File "/var/local/braydon/sparrow/templates.py", line 259, in render_skeleton [Fri Feb 01 08:36:23 2008] [error] body, cmds_array = compile_templates(location, kwargs) [Fri Feb 01 08:36:23 2008] [error] File "/var/local/braydon/sparrow/templates.py", line 191, in compile_templates [Fri Feb 01 08:36:23 2008] [error] doc = get_uri(location) [Fri Feb 01 08:36:23 2008] [error] File "/var/local/braydon/sparrow/uri.py", line 31, in get_uri [Fri Feb 01 08:36:23 2008] [error] selected = db.session.query(TemplateRelation).filter_by(location=uri)[0] [Fri Feb 01 08:36:23 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 657, in __getitem__ [Fri Feb 01 08:36:23 2008] [error] return list(self[item:item+1])[0] [Fri Feb 01 08:36:23 2008] [error] IndexError: list index out of range [Fri Feb 01 08:36:23 2008] [error] [Fri Feb 01 08:36:23 2008] [error] [01/Feb/2008:08:36:23] HTTP [Fri Feb 01 08:36:23 2008] [error] Request Headers: [Fri Feb 01 08:36:23 2008] [error] IF-MODIFIED-SINCE: Fri, 01 Feb 2008 05:31:22 GMT [Fri Feb 01 08:36:23 2008] [error] USER-AGENT: Feedfetcher-Google; (+http://www.google.com/feedfetcher.html; 1 subscribers; feed-id=5933957592327069039) [Fri Feb 01 08:36:23 2008] [error] CONNECTION: Keep-alive [Fri Feb 01 08:36:23 2008] [error] Remote-Addr: 209.85.238.10 [Fri Feb 01 08:36:23 2008] [error] HOST: braydon.com [Fri Feb 01 08:36:23 2008] [error] ACCEPT: */* [Fri Feb 01 08:36:23 2008] [error] ACCEPT-ENCODING: gzip [Fri Feb 01 08:36:23 2008] [error] 209.85.238.10 - - [01/Feb/2008:08:36:23] "GET /?feed=rss2 HTTP/1.1" 500 1906 "" "" [Fri Feb 01 11:31:59 2008] [notice] caught SIGTERM, shutting down [Fri Feb 01 11:32:01 2008] [error] [01/Feb/2008:11:32:01] HTTP Traceback (most recent call last): [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/cherrypy/_cprequest.py", line 551, in respond [Fri Feb 01 11:32:01 2008] [error] cherrypy.response.body = self.handler() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/cherrypy/_cpdispatch.py", line 24, in __call__ [Fri Feb 01 11:32:01 2008] [error] return self.callable(*self.args, **self.kwargs) [Fri Feb 01 11:32:01 2008] [error] File "/var/local/braydon/sparrow/http.py", line 42, in default [Fri Feb 01 11:32:01 2008] [error] db.start_engine() [Fri Feb 01 11:32:01 2008] [error] File "/var/local/braydon/sparrow/database.py", line 70, in start_engine [Fri Feb 01 11:32:01 2008] [error] Database.db = get_database(settings.database) [Fri Feb 01 11:32:01 2008] [error] File "/var/local/braydon/sparrow/database.py", line 56, in get_database [Fri Feb 01 11:32:01 2008] [error] db.connection = db.engine.connect() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 1223, in connect [Fri Feb 01 11:32:01 2008] [error] return Connection(self, **kwargs) [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 540, in __init__ [Fri Feb 01 11:32:01 2008] [error] self.__connection = connection or engine.raw_connection() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 1278, in raw_connection [Fri Feb 01 11:32:01 2008] [error] return self.pool.unique_connection() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 135, in unique_connection [Fri Feb 01 11:32:01 2008] [error] return _ConnectionFairy(self).checkout() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 306, in __init__ [Fri Feb 01 11:32:01 2008] [error] rec = self._connection_record = pool.get() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 173, in get [Fri Feb 01 11:32:01 2008] [error] return self.do_get() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 593, in do_get [Fri Feb 01 11:32:01 2008] [error] con = self.create_connection() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 138, in create_connection [Fri Feb 01 11:32:01 2008] [error] return _ConnectionRecord(self) [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 201, in __init__ [Fri Feb 01 11:32:01 2008] [error] self.connection = self.__connect() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 264, in __connect [Fri Feb 01 11:32:01 2008] [error] connection = self.__pool._creator() [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/sqlalchemy/engine/strategies.py", line 80, in connect [Fri Feb 01 11:32:01 2008] [error] raise exceptions.DBAPIError.instance(None, None, e) [Fri Feb 01 11:32:01 2008] [error] OperationalError: (OperationalError) (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") None None [Fri Feb 01 11:32:01 2008] [error] [Fri Feb 01 11:32:01 2008] [error] [01/Feb/2008:11:32:01] HTTP [Fri Feb 01 11:32:01 2008] [error] Request Headers: [Fri Feb 01 11:32:01 2008] [error] IF-MODIFIED-SINCE: Fri, 01 Feb 2008 05:31:22 GMT [Fri Feb 01 11:32:01 2008] [error] USER-AGENT: Feedfetcher-Google; (+http://www.google.com/feedfetcher.html; 1 subscribers; feed-id=5933957592327069039) [Fri Feb 01 11:32:01 2008] [error] CONNECTION: Keep-alive [Fri Feb 01 11:32:01 2008] [error] Remote-Addr: 209.85.238.10 [Fri Feb 01 11:32:01 2008] [error] HOST: braydon.com [Fri Feb 01 11:32:01 2008] [error] ACCEPT: */* [Fri Feb 01 11:32:01 2008] [error] ACCEPT-ENCODING: gzip [Fri Feb 01 11:32:01 2008] [error] 209.85.238.10 - - [01/Feb/2008:11:32:01] "GET /?feed=rss2 HTTP/1.1" 500 3029 "" "" [Fri Feb 01 11:32:01 2008] [error] [01/Feb/2008:11:32:01] Traceback (most recent call last): [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/cherrypy/_cpwsgi.py", line 126, in __init__ [Fri Feb 01 11:32:01 2008] [error] response = self.request.run(meth, path, qs, rproto, headers, rfile) [Fri Feb 01 11:32:01 2008] [error] File "/var/lib/python-support/python2.5/cherrypy/_cprequest.py", line 511, in run [Fri Feb 01 11:32:01 2008] [error] raise cherrypy.TimeoutError() [Fri Feb 01 11:32:01 2008] [error] TimeoutError [Fri Feb 01 11:32:01 2008] [error] [Fri Feb 01 11:32:01 2008] [error] [client 209.85.238.10] mod_wsgi (pid=18122): Exception occurred within WSGI script '/var/local/braydon/wsgi_bridge.py'. [Fri Feb 01 11:32:01 2008] [error] [client 209.85.238.10] IOError: client connection closed [Fri Feb 01 11:32:02 2008] [notice] seg fault or similar nasty error detected in the parent process --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---