[Zope] MySQL & lost server connections

Ty Sarna tsarna@endicor.com
28 May 1999 21:36:21 GMT


In article <Pine.LNX.3.96.990528114433.18413B-100000@taos.kavi.com>,
John Eikenberry  <jae@kavi.com> wrote:
> 
> Basically, it looks like I'm losing my connection from Zope to the MySQL
> database. While the site remains busy, it stays connected, but if there's
> a long dead period the connection goes away.
> 
> Both Zope and MySQL are running on the same BSDI 3.1 machine. Its
> Zope-1.10.2 and MySQL-3.21.33b. Is there anything I can do to fix this?

I believe newer versions of libmysqlclient (which may require a newer
server) will reconnect transparently if the server closes the connection
on timeout. Upgrading may be the simplest fix.