[Zope] DCO2 beta 5 problem.

Geir Bækholt Geir Bækholt <geirh@funcom.com>
Fri, 14 Sep 2001 13:12:11 +0200


Hi

We're having a weird problem with the DCO2 beta5 adapter:
It seems like it leaves connections open, creating new ones as it
pleases, gradually leaving more connection open , though inactive..

Zope doesn't report anything wrong, although if we check Oracle, the
number of open (inactive) connections to the Zope seem to grow at a
steady pace, and in about a day and a half we reach the maximum number
of open connections (400), and need to kill them off by hand.

We can find no connection to specific method calls doing this, and it
only happens when using the DCO2 through Zope with ZsqlMethods. No
problem when using it directly through Python.

We are currently only using it for a simple news-publishing system,
but will soon have to escalate it to Authentication and other
intensive applications, - so obviously we fear for the stability of
our system if the number of connections should grow at a much
faster pace...

Anyone experienced anything similar=3F
Any thoughts on possible reasons or fixes =3F

--=20
Geir B=E6kholt                   web-developer/zopatista
geirh@funcom.com             funcom oslo | webdev-team

            <!-- PGPid : 0x90B47B20 -->