I just found out that my the script that launches my web server doesn't launch correctly the python virtualenv that I had setup. I was using a very old version of sqlobjects(0.10.3) and of mysqldb.

I just fixed this, and will now wait for the next freeze to happen (if it ever happens again)...

Thanks for your great support.

On Tue, Dec 4, 2012 at 6:47 PM, Oleg Broytman <phd@phdru.name> wrote:
Hi! Pity to listen you have problems.

On Tue, Dec 04, 2012 at 01:02:52PM +0100, Sophana K <sophana78@gmail.com> wrote:
> Since about one year ago (maybe more...), from time to time (about every
> week/month), the python process completely freezes under high load.

   It'd be helpful to find a version of SO that doesn't freeze.
Unfortunately it requires to rollback your code and to run a lot of

> Reading the code, I don't understand the call path from dbConnection to the
> SqlHub.

   There shouldn't be any path -- you use sqlhub as the connection:

class MyClass(SQLObject):
    _connection = sqlhub # Actually, this is the default

sqlhub.threadConnection = connectionFromURI('...')

   Sqlhub's __get__ and __set__ methods return the real connection.

> How is the connection pool managed?

   You can see the code at dbconnection.py stared at the line 332: class
DBAPI, method getConnection. You can explicitly disable the pool by
setting dbConnection._pool = None.

> Is it thread safe?

   Should be. The pool is protected by _poolLock. Does something in the
code trigger your suspicions?

     Oleg Broytman            http://phdru.name/            phd@phdru.name
           Programmers don't die, they just GOSUB without RETURN.

LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
sqlobject-discuss mailing list