[Zope] MySQL & lost server connections

Paulo Eduardo Neves neves@inf.puc-rio.br
Tue, 01 Jun 1999 20:37:57 -0300


Ty Sarna wrote:
> 
> 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.
> 
> 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.

My simplest fix to this was to put wget as a cron job to request a page
every 10 min.:-) Yes, the requested page must access the DB.

I had to upgrade latter to be able to do an outer join, but the cron jot
is still there.

regards,
--
Paulo Eduardo Neves
mailto:neves@inf.puc-rio.br
PUC-Rio de Janeiro