[Zope-DB] diconnecting

Matthew T. Kromer matt@zope.com
Thu, 27 Dec 2001 15:05:45 -0500

Sadly, what a Zope DA thinks of as being "connected" is usually woefully 
incorrect.  In fact, the only thing "connected" means is that the 
database WAS connected, not that it is.

The DA is supposed to perform a reconnect if the database goes down, but 
it only changes the "connected" state if it can't reconnect to the 
remote end.

So instead, what the problem would appear to be is that the DA isn't 
properly closing and reopening the connection when it fails.  What DA 
are you using?

On Thursday, December 27, 2001, at 01:33 PM, D. Rick Anderson wrote:

> I'm having a problem with our database connections dropping when a 
> database
> server is rebooted or the network is interupted. What sucks is that it
> still shows as being connected in Zope. The only way I know that it 
> isn't
> is either by trying something on the web site that uses the database 
> server
> or by doing a test on the connection. I can get the connection back by
> closing the connection and then opening it again, but that's only if I'm
> aware that it's down. Is there some way to prevent this? Can Zope
> automatically re-open a connection somehow? 5 out of our 7 database 
> servers
> are on the other end of a 62 mile T1 and if it goes down, I need Zope to
> bring the connection back up when the line comes back up. Can this be 
> done?
> Thanks,
> Rick
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db