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

[Charlie Clark]

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