2007-12-12 00:19:24,099 INFO sqlalchemy.pool.QueuePool.0x..90 Created
new connection <connection object at 0xda9bd0; dsn: 'dbname=df
host=localhost user=grey password=xxxxxxxx', closed: 0>
2007-12-12 00:19:24,099 INFO sqlalchemy.pool.QueuePool.0x..90
Connection <connection object at 0xda9bd0; dsn: 'dbname=df
host=localhost user=grey password=xxxxxxxx', closed: 0> checked out
from pool
2007-12-12 00:31:08,901 INFO sqlalchemy.pool.QueuePool.0x..90 Created
new connection <connection object at 0x180cad8; dsn: 'dbname=df
host=localhost user=grey password=xxxxxxxx', closed: 0>
repeated 15 times
"""TimeoutError: QueuePool limit of size 5 overflow 10 reached,
connection timed out, timeout 30"""
298 times
another traceback :
Thread-2:
Traceback (most recent call last):
File "threading.py", line 442, in __bootstrap
self.run()
File "./camper.py", line 120, in run
walk(s, theone, root)
File "./camper.py", line 77, in walk
stuff =
s.query(Path).select_from(f_table).filter(Path.c.user_id==theone.id).filter(Path.c.path==relpath).first()
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py",
line 701, in first
ret = list(self[0:1])
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py",
line 730, in __iter__
return self._execute_and_instances(context)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py",
line 733, in _execute_and_instances
result = self.session.execute(querycontext.statement,
params=self._params, mapper=self.mapper,
instance=self._refresh_instance)
File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/session.py",
line 528, in execute
return self.__connection(engine,
close_with_result=True).execute(clause, params or {})
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 795, in execute
return Connection.executors[c](self, object, multiparams, params)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 846, in execute_clauseelement
return self._execute_compiled(elem.compile(dialect=self.dialect,
column_keys=keys, inline=len(params) > 1), distilled_params=params)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 858, in _execute_compiled
self.__execute_raw(context)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 870, in __execute_raw
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 886, in _cursor_execute
raise exceptions.DBAPIError.instance(statement, parameters, e)
ProgrammingError: (ProgrammingError) Wrong byte sequence, encoding
"UTF8": 0xd4f0
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
'SELECT fs_file.id AS fs_file_id, fs_file.user_id AS fs_file_user_id,
fs_file.path AS fs_file_path, fs_file.ls AS fs_file_ls \nFROM fs_file
\nWHERE fs_file.user_id = %(fs_file_user_id_1)s AND fs_file.path = %
(fs_file_path_1)s ORDER BY fs_file.id \n LIMIT 1 OFFSET
0' {'fs_file_user_id_1': 7, 'fs_file_path_1': '/incoming/
\xd0\x90\xd0\xba\xd0\xb0\xd0\xb4\xd0\xb5\xd0\xbc\xd0\xb8\xd1\x8f
\xd0\xbf\xd1\x81\xd0\xb8\xd1\x85\xd0\xbe\xd0\xbb\xd0\xbe
\xd0\xb3\xd0\xb8\xd0\xb8/3/\xd4\xf0\xe0\xed\xea\xeb \xcb\xee\xe3\xee
\xf2\xe5\xf0\xe0\xef\xe8\xff'}
db = create_engine("postgres:...")
In thread:
if not metadata.is_bound():
metadata.bind = db
s = create_session(bind=db)
s.begin()
...
s.commit()
s.clear()
s.close()
Have no adea where to dig. All strings that I'm passing to db is
unicode.
Btw, there's another problem: application opening maximum allowed
files, so
other services is dying. And I'm suspecting sqlalchemy, because
there's only
one place in my code where file is opening, followed with file.close()
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
