Hello Guys,

 

I'm receiving errors in my application on a fairly regular basis now and I'm
not sure how to begin solving it.

 

Please find attached a backtrace for the error. It seems that its struggling
to connect to the MySQL server, however I get this after the application has
been running and querying the database for some time.

 

Any ideas what might be causing this? I'd appreciate your thoughts. The code
which throws the error is a very simple query(some_object).get(id)

 

Cheers all,

 

Heston


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

  File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 414, 
in get
    return self._get(key, ident)
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 1211, 
in _get
    return q.all()[0]
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 985, 
in all
    return list(self)
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 1073, 
in __iter__
    return self._execute_and_instances(context)
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/query.py", line 1076, 
in _execute_and_instances
    result = self.session.execute(querycontext.statement, params=self._params, 
mapper=self._mapper_zero_or_none(), _state=self._refresh_state)
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/session.py", line 750, 
in execute
    return self.__connection(engine, close_with_result=True).execute(
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/session.py", line 717, 
in __connection
    return self.transaction._connection_for_bind(engine)
  File "/var/lib/python-support/python2.5/sqlalchemy/orm/session.py", line 326, 
in _connection_for_bind
    conn = bind.contextual_connect()
  File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 
1247, in contextual_connect
    return self.Connection(self, self.pool.connect(), 
close_with_result=close_with_result, **kwargs)
  File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 161, in 
connect
    return _ConnectionFairy(self).checkout()
  File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 321, in 
__init__
    rec = self._connection_record = pool.get()
  File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 180, in get
    return self.do_get()
  File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 618, in 
do_get
    con = self.create_connection()
  File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 141, in 
create_connection
    return _ConnectionRecord(self)
  File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 217, in 
__init__
    self.connection = self.__connect()
  File "/var/lib/python-support/python2.5/sqlalchemy/pool.py", line 280, in 
__connect
    connection = self.__pool._creator()
  File "/var/lib/python-support/python2.5/sqlalchemy/engine/strategies.py", 
line 80, in connect
    raise exc.DBAPIError.instance(None, None, e)
OperationalError: (OperationalError) (2002, "Can't connect to local MySQL 
server through socket '/var/run/mysqld/mysqld.sock' (2)") None None

Reply via email to