[Zope] Re: DCO2 beta 5 problem.

[Matthew T. Kromer]

on 9/14/01 7:12 AM, Geir B=E6kholt at geirh@funcom.com wrote:

> Hi
>=20
> 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..
>=20
> 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.
>=20
> 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.
>=20
> 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...
>=20
> Anyone experienced anything similar?
> Any thoughts on possible reasons or fixes ?

I've had a number of reports of this; and am looking in to why the adapter
might be lingering.  Generally, the DA tries to close the connection
whenever it errors and reopen it; this may be broken.