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

Charlie Clark charlie at egenix.com
Tue Mar 6 16:09:11 CET 2007


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



More information about the egenix-users mailing list