[Zope-DB] diconnecting

D. Rick Anderson ruger@comnett.net
Thu, 27 Dec 2001 12:35:54 -0800 (PST)


ZODBCDA on Windows 2000 with Zope 2.4.3 connecting to Sybase SQL Anywhere 
6.0.3 on Novell 5.1

We also have a RH 7.1 box connecting to Oracle 8.1.6 on Novell 5.1. I just 
tested it and it doesn't seem to have this problem indicating that the 
problem lies with that ZODBCDA.

What can be done?

Thanks,

Rick

> 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