on 9/14/01 7:12 AM, Geir Bækholt at geirh@funcom.com wrote:
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? 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.