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 <p...@phdru.name> wrote:
> Hi! Pity to listen you have problems.
>
> On Tue, Dec 04, 2012 at 01:02:52PM +0100, Sophana K <sophan...@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
> experiments.
>
> > 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.
> --
> Oleg Broytman http://phdru.name/ p...@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
> http://p.sf.net/sfu/logmein_12329d2d
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
------------------------------------------------------------------------------
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
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
