Re: [Zope-DB] dealing with dropped database connections

2006-01-22 Thread martin f krafft
also sprach Seth Gottlieb [EMAIL PROTECTED] [2006.01.18.1523 +0100]:
 You might also consider using SQLRelay.  I wrote some blog posts talking 
 about connecting to a relational database.  There might be some useful 
 information there:
 
 http://contenthere.blogspot.com/2005/12/zoracle-part-i-problem.html
 http://contenthere.blogspot.com/2005/12/zoracle-part-ii-solution.html
 http://contenthere.blogspot.com/2005/12/zoracle-part-iii-connecting-zope-to.html

These are very interesting. However, with SQLRelay, I am still bound
to use SQLRelayDA for Zope, and as Charlie postulated that stale
database connections are in part due to Zope's DA framework,
I wonder how using SQLRelay would address the problem; if the
connection to the SQLRelay server is lost, Zope would similarly hang
itself up, wouldn't it?

Or do you recommend running SQLRelay on the Zope server? How does
SQLRelay then manage a connection that is stale?

Thanks,

-- 
martin;  (greetings from the heart of the sun.)
  \ echo mailto: !#^.*|tr * mailto:; [EMAIL PROTECTED]
 
invalid/expired pgp (sub)keys? use subkeys.pgp.net as keyserver!
spamtraps: [EMAIL PROTECTED]
 
women who want to be equal to men lack ambition.
  -- timothy leary


signature.asc
Description: Digital signature (GPG/PGP)
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope-DB] dealing with dropped database connections

2006-01-22 Thread Seth Gottlieb
I would try having the SQLRelay listener on the Zope server and see what that
does.

--Seth

martin f krafft ([EMAIL PROTECTED]) wrote:

 also sprach Seth Gottlieb [EMAIL PROTECTED] [2006.01.18.1523 +0100]:
  You might also consider using SQLRelay.  I wrote some blog posts talking
  about connecting to a relational database.  There might be some useful
  information there:
 
  http://contenthere.blogspot.com/2005/12/zoracle-part-i-problem.html
  http://contenthere.blogspot.com/2005/12/zoracle-part-ii-solution.html
  http://contenthere.blogspot.com/2005/12/zoracle-part-iii-connecting-zope-to.html

 These are very interesting. However, with SQLRelay, I am still bound
 to use SQLRelayDA for Zope, and as Charlie postulated that stale
 database connections are in part due to Zope's DA framework,
 I wonder how using SQLRelay would address the problem; if the
 connection to the SQLRelay server is lost, Zope would similarly hang
 itself up, wouldn't it?

 Or do you recommend running SQLRelay on the Zope server? How does
 SQLRelay then manage a connection that is stale?

 Thanks,

 --
 martin;  (greetings from the heart of the sun.)
    echo mailto: !#^.*|tr * mailto:; [EMAIL PROTECTED]

 invalid/expired pgp (sub)keys? use subkeys.pgp.net as keyserver!
 spamtraps: [EMAIL PROTECTED]

 women who want to be equal to men lack ambition.
   -- timothy leary


___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope-DB] dealing with dropped database connections

2006-01-22 Thread Maciej Wisniowski

 These are very interesting. However, with SQLRelay, I am still bound
 to use SQLRelayDA for Zope, and as Charlie postulated that stale
 database connections are in part due to Zope's DA framework,
 I wonder how using SQLRelay would address the problem; if the
 connection to the SQLRelay server is lost, Zope would similarly hang


itself up, wouldn't it?


With SQLRelay you have SQLRelay client (in this case Zope DA),
that connects to SQLRelay listener that is connected to database.
When the network connection to the database is broken then
listener becomes disconnected, but when you have some queries
from the client (Zope DA) then those reach SQLRelay listener
and become hung (in wait state) till connection becomes operational
again (im not sure but this may cause all zope threads to be busy
and Zope won't be responding). There were some questions about this
recently on sqlrelay-discussion.

-
Maciej Wisniowski
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


Re: [Zope-DB] dealing with dropped database connections

2006-01-18 Thread Charlie Clark

martin f krafft wrote:

Hi,

a client of mine complains about dropped database connections
(SybaseDA), which wreak havoc. For instance, if the network goes
down for a while, the DA is left in an irrecoverable state.

Short of a regular wget to the manage interface to restart the DA,
what can be done? Is this something about SybaseDA (which is no
longer maintained), or a common problem?

What would you advise, short of hunting down the problem and fixing
it?


This problem is common to all ZopeDA's connected to network data 
sources.  You might want to try using our mxODBCZopeDA with the option 
Connect on demand which often helps in these situations. However, a 
lot depends on how your data source and driver are configured as the 
stale connection is often serialised even though it has been lost.


Charlie
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


[Zope-DB] dealing with dropped database connections

2006-01-17 Thread martin f krafft
Hi,

a client of mine complains about dropped database connections
(SybaseDA), which wreak havoc. For instance, if the network goes
down for a while, the DA is left in an irrecoverable state.

Short of a regular wget to the manage interface to restart the DA,
what can be done? Is this something about SybaseDA (which is no
longer maintained), or a common problem?

What would you advise, short of hunting down the problem and fixing
it?

-- 
martin;  (greetings from the heart of the sun.)
  \ echo mailto: !#^.*|tr * mailto:; [EMAIL PROTECTED]
 
invalid/expired pgp (sub)keys? use subkeys.pgp.net as keyserver!
spamtraps: [EMAIL PROTECTED]
 
the surest way to corrupt a youth is to instruct him to hold in
 higher esteem those who think alike than those who think
 differently.
  -- friedrich nietzsche


signature.asc
Description: Digital signature (GPG/PGP)
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db