[egenix-users] mxODBC Zope DA and Linux Zope -- Connections not being disconnected

[David Krosel]

Hello,

21? I thought I would try for a high and safe number :)

When the problem occurs again, I will provide a snap-shot, but I couldn't 
find any errors in the Zope log.

Under the Zope mxODBC configuration screen, there is a note that "Under 
heavy load, closing the connection may not result in the physical 
connections to get freed. This is due to the multi-threaded nature of Zope."

Can this be related to my problem, even without the load?

Regards,
David


----- Original Message ----- 
From: "Charlie Clark" <charlie at egenix.com>
To: "David Krosel" <david.krosel at maxxian.com>; <egenix-users at egenix.com>
Sent: Tuesday, March 06, 2007 10:09 AM
Subject: Re: [egenix-users] mxODBC Zope DA and Linux Zope -- Connections not 
being disconnected


Am 06.03.2007, 15:57 Uhr, schrieb David Krosel <david.krosel at maxxian.com>:

> Hello all,
>  Even under very low load, Zope runs out of connections after about 30 
> days and the next database request ends in a db-error. I need to restart 
> Zope each time. I only have 1-2 users per day using the system.
>  My configuration is as follows:
> ------------------------------
> mxODBC Zope DA 1.0.10
> Zope 2.7.7
> Pool size = 21
> Number Zope threads = 21
> Linux Centos 4.3
>  The ODBC is configured for:
> -----------------------------
> MySql 4.1.x on the local server
> Threading=0

A pool size of 21 and 21 Zope threads seems excessive. Why have you gone
for such a high number? We really need the full traceback of the error as
we do not expect it to be in mxODBC. Have you run an ODBC trace?

Charlie