Hi Martin, I'm back :)
Martin Bartosch wrote:
we were having DB problems when recreating the OpenSSL index.txt file, Oracle would complain about "too many open cursors". After looking at the code I found out that the DBI module caches the STH handles for DB connections in a private array, but only the last value of this array is actually used. The remaining entries seem to allocate a DB handle each, which leads to problems at least for the Oracle DB implementation. Locally I removed the code from the DBI module and replaced the STH caching with one single member variable which works properly for me, as far as I can tell.
The problem is that we use the cache for queries which include integer checks like "notbefore >= 200512030500". This overflows the cache and is a general memory leak. It is already fixed in the HEAD. I don't know about the 0.9.2 version
Question: should I check in the fix to CVS head and 0.9.2 branch?
You can commit it for the 0.9.2 version but please don't commit it to the CVS HEAD release because the HEAD checks the query before it caches the query.
Michael -- _______________________________________________________________ Michael Bell Humboldt-Universitaet zu Berlin Tel.: +49 (0)30-2093 2482 ZE Computer- und Medienservice Fax: +49 (0)30-2093 2704 Unter den Linden 6 [EMAIL PROTECTED] D-10099 Berlin _______________________________________________________________
smime.p7s
Description: S/MIME Cryptographic Signature
