[Zope-DB] 3114, 'ORA-03114: not connected to ORACLE'
jabramson at wgen.net
Wed Oct 6 12:39:50 EDT 2004
We have a mechanism dealing with this:
1 - a python script in zope that uses a given DCO2 connection to ask oracle (select 'OK' from dual)
2 - a mon process that requests this py script by URL every n minutes
3 - if the reponse is not 'OK' from the URL call, retry after n seconds
4 - if n retries fail, we restart zope summarily.
step 4 is necessary because it seems once the pool, or a connection in the pool, has gone sour, there's no manage_ option that really makes everything fine again.
We are 100% certain our database isn't flaking, many other users/systems connected and they do not complain. The connection pool just doesn't seem to keep itself in a happy/healthy state all the time. But this mon solution works very well for us.
Admittedly, I haven't tried Chris' branch of DCO2 to see if it works better there.
> -----Original Message-----
> From: Matthew T. Kromer [mailto:matt at bane.mi.org]
> Sent: Tuesday, October 05, 2004 8:44 AM
> To: Dario Lopez-Kästen
> Cc: zope-db at zope.org
> Subject: Re: [Zope-DB] 3114, 'ORA-03114: not connected to ORACLE'
> Just a FYI, Chris Withers has a branch of DCOracle2 which may
> feature better behavior when the database connection drops.
> On Oct 5, 2004, at 1:49 AM, Dario Lopez-Kästen wrote:
> > Remy Pinsonnault wrote:
> >> Dieter, what do you mean had died?
> >> Four other applications are connected to the same Oracle Server
> >> (written in
> >> ASP, Java, Oracle Developer, PowerBuilder) and their
> connection did
> >> not went
> >> down as DCOracle2 did...
> > we experience the same problem. I still ahve not seen a pattern to
> > this. Things that have changed from before we had this problem:
> > New version of Zope (2.6-series), new OS (RH AS 3.0),
> latest DCOracle2
> > from CVS. Exaclty the 3 cor components of a site :-P.
> > Which means that we ought to start comparing versions.
> > NB: We have no problems with the Oracle Servers, it is just
> the Zope
> > client that dies.
> > /dario
> > --
> > --
> > Dario Lopez-Kästen, IT Systems & Services Chalmers
> University of Tech.
> > _______________________________________________
> > Zope-DB mailing list
> > Zope-DB at zope.org
> > http://mail.zope.org/mailman/listinfo/zope-db
> Zope-DB mailing list
> Zope-DB at zope.org
More information about the Zope-DB