Re: [SQLObject] select() causes SQLObject + webware application to die
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Scott R. <sc...@to...> - 2004-03-02 23:13:40
|
David and Ian: Yes, (as you'll see in my mail that arrived the same time yours did) it looks like a thread concurrency issue. If I turn on debugging, the threading test survives many additional threads, but will die eventually. (David, 32 kills it very handily.) Whether because of some serialization that gets forced during printing, because it slows the process down enough to avoid contention, or some third issue, I can't say. Here is a sample run, with 32 threads. Sometimes it lasts for 30-40 queries, sometimes (as seen here) only 3.... $ python Main/TestPage.py 1:Dummy-1/Select : SELECT person.id, person.email, person.firstname, person.lastname FROM person WHERE (person.email = 'xxx') LIMIT 1 1:Dummy-2/Select : SELECT person.id, person.email, person.firstname, person.lastname FROM person WHERE (person.email = 'xxx') LIMIT 1 1:Dummy-3/Select : SELECT person.id, person.email, person.firstname, person.lastname FROM person WHERE (person.email = 'xxx') LIMIT 1 Killed What next? |