Re: [SQLObject] freezes with multi-threading ?

[Sophana K <sop...@gm...>]

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 <ph...@ph...> wrote:

> Hi! Pity to listen you have problems.
>
> On Tue, Dec 04, 2012 at 01:02:52PM +0100, Sophana K <sop...@gm...>
> 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/            ph...@ph...
>            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
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>