Re: [Sqlrelay-discussion] Re: ZSQLRelayDA and freeing connections

[Maciej W. <mac...@co...>]

Hi!

We are using Zope 2.7.x and Zope 2.8.1 with SQLRelay 0.36.4
on Linux with Oracle and we didn't ecountered such problems.
We also have connections set to 3.

Maybe try to install DeadlockDebugger product for Zope and see
what it's threads are doing when it's "hanged".

-- 
Maciej Wisniowski

Jean Lagarde napisał(a):

> Oh yeah, I can make as many queries as I want using sqlrsh, so it 
> seems that the sqlrelay machinery is itself OK.
>
> -- Jean
>
> Jean Lagarde wrote:
>
>> Hi all,
>>
>> sqlrelay-0.35, Zope 2.7, Python 2.3, FreeBSD 5.0, FreeTDS
>>
>> I've got everything working up to this point: I can execute test 
>> queries, or run ZSQL methods, but only up to the "connections" 
>> parameter in the sqlrelay.conf file. For example, if connections="3", 
>> I can call the same ZSQL method three times, and the fourth time, 
>> Zope hangs until I run sqlr-stop and restart. Once I stop sqlrelay, 
>> the query that was hanging Zope returns with "failed to get cursor 
>> id". I went as far as checking that _finish() in db.py does seem to 
>> successfully call close() in PySQLRDB, but somehow I guess the 
>> previous connections/cursors aren't freed?
>>
>> Any ideas?
>>
>> Cheers,
>>
>> Jean
>>
>>
>>
>
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle 
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing 
> & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>