1 = "noah";'})
self.assert_(content.startswith("<QueryResults>"))
threads = []
for i in range(20):
thread = BridgeRequest()
thread.start()
threads.append(thread)
for thread in threads:
thread.join()
I get a bunch of errors like this on the server:
Traceback (most recent call last):
File "/Library/Python/2.5/site-packages/web.py-0.23-py2.5.egg/web/
webapi.py", line 312, in wsgifunc
result = func()
File "/Library/Python/2.5/site-packages/web.py-0.23-py2.5.egg/web/
request.py", line 131, in <lambda>
func = lambda: handle(inp, fvars)
File "/Library/Python/2.5/site-packages/web.py-0.23-py2.5.egg/web/
request.py", line 61, in handle
return tocall(*([x and urllib.unquote(x) for x in args] + fna))
File "/Users/dusty/Code/lightspeed-server-gitsvn/server/auth.py",
line 122, in wrapper
username = authenticateUser()
File "/Users/dusty/Code/lightspeed-server-gitsvn/server/auth.py",
line 58, in authenticateUser
result = database.engine.execute("SELECT * FROM user WHERE
username=?", username)
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/engine/base.py", line 1210, in execute
connection = self.contextual_connect(close_with_result=True)
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/engine/base.py", line 1238, in contextual_connect
return self.Connection(self, self.pool.connect(),
close_with_result=close_with_result, **kwargs)
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/pool.py", line 161, in connect
return _ConnectionFairy(self).checkout()
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/pool.py", line 323, in __init__
rec = self._connection_record = pool.get()
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/pool.py", line 180, in get
return self.do_get()
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/pool.py", line 674, in do_get
return self.create_connection()
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/pool.py", line 141, in create_connection
return _ConnectionRecord(self)
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/pool.py", line 217, in __init__
self.connection = self.__connect()
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/pool.py", line 280, in __connect
connection = self.__pool._creator()
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.5.0rc2-
py2.5.egg/sqlalchemy/engine/strategies.py", line 80, in connect
raise exc.DBAPIError.instance(None, None, e)
ProgrammingError: (ProgrammingError) The database specified has not
been started or can not be found. Your action has been aborted. None
None
I don't think ALL the concurrent requests are throwing this error, but
most of them are. I can't imagine why the NullPool couldn't connect to
the database in multithreaded requests but it has no problem doing so
if the requests are sent consecutively.
I get the same error if I use SingletonThreadPool or StaticPool.
I thought the problem might be in the connection method for the custom
pyOpenBase utility, but from the looks of the exception its not even
getting that far.
Am I overlooking something painfully obvious? Does anyone have any
ideas as to how I can get around one or more of these errors?
Thanks for any insight,
Dusty
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
