there seems to be more going on there, but perhaps are all side effects of the same thing:
http://www.sqlalchemy.org/trac/wiki/FAQ#MySQLserverhasgoneawaypsycopg.InterfaceError:connectionalreadyclosed or otherwise your mysql client is not able to connect at all. braydon fuller wrote: > 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 -~----------~----~----~----~------~----~------~--~---