Re: [Zope] ZPsycopgDA dropping connections?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 20 Apr 2005 03:23 pm, Richard Jones wrote: Has anyone else seen ZPsycopgDA just lose its connection? I just looked in Shared/DC/ZRDB/Connection.py If the connection string is empty (which is quite valid for my setup, as it turns out) then the DA won't connect automatically. It won't even try. Could this be considered a bug, or am I missing something obvious? Richard -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFCZe/vrGisBEHG6TARAlfdAJ0ajEyBaGgTMMH+0bjL3NXv0g/UaQCeMDvD oJ1HMFf0yhXhE8OwQSzwFYI= =cmtl -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZPsycopgDA dropping connections?
Richard Jones wrote: I just looked in Shared/DC/ZRDB/Connection.py If the connection string is empty (which is quite valid for my setup, as it turns out) then the DA won't connect automatically. It won't even try. Could this be considered a bug, or am I missing something obvious? Most of Shared/DC/ZRDB/Connection.py could be considered a bug ;-) But yeah, this one might not be a total bitch to fix, unlike everything else in there... cheers, Chris -- Simplistix - Content Management, Zope Python Consulting - http://www.simplistix.co.uk ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] ZPsycopgDA dropping connections?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Has anyone else seen ZPsycopgDA just lose its connection? I've got two ZEO clients set up to use it, and every now and then one of them (the primary) just up and loses its connection. There doesn't appear to be any message in the log file *except* for the message saying that the connection's not active: 2005-04-20T14:35:46 INFO(0) ZEC:/var/cache/cgzope/zope-8000/cmain-main-1.zec flipping cache files. new current = 1 - -- 2005-04-20T14:53:25 INFO(0) ZEC:/var/cache/cgzope/zope-8000/cmain-main-0.zec flipping cache files. new current = 0 - -- 2005-04-20T14:58:11 ERROR(200) SiteError http://laurastein.cgpublisher.com/CGPublisher Traceback (most recent call last): File /home/cgzope/prod/Zope/lib/python/ZPublisher/Publish.py, line 92, in publish File /home/cgzope/prod/Zope/lib/python/ZPublisher/BaseRequest.py, line 259, in traverse File /home/cgzope/prod/Zope/lib/python/ZPublisher/BeforeTraverse.py, line 104, in __call__ File /home/cgzope/prod/Zope/lib/python/ZPublisher/BeforeTraverse.py, line 144, in __call__ File /home/cgzope/prod/Products/CookieCrumbler/CookieCrumbler.py, line 217, in __call__ attempt = self.modifyRequest(req, resp) File /home/cgzope/prod/Products/CGPublisher/SessionCookieCrumbler.py, line 55, in modifyRequest creds = req.SESSION.get(key,None) File /home/cgzope/prod/Zope/lib/python/ZPublisher/HTTPRequest.py, line 1218, in __getattr__ File /home/cgzope/prod/Zope/lib/python/ZPublisher/HTTPRequest.py, line 1178, in get File /home/cgzope/prod/Products/ZSQLSessionDataManager/ZSQLSessionDataManager .py, line 100, in getSessionData return self._getSessionDataObject(key) File /home/cgzope/prod/Products/ZSQLSessionDataManager/ZSQLSessionDataManager .py, line 233, in _getSessionDataObject c = self._getSessionDataConnection() File /home/cgzope/prod/Products/ZSQLSessionDataManager/ZSQLSessionDataManager .py, line 250, in _getSessionDataConnection return self.restrictedTraverse(self.obpath)() File /home/cgzope/prod/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 173, in __call__ BadRequest: The database connection is not connected - -- (apologies for the wrapping, of course) Any ideas? Richard -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFCZedirGisBEHG6TARAo6WAJ98cBlOZqoZ62Amg0zreDkTPFiyAQCeJGla gmhpp4lXn2wjFb6PnPkF3cI= =8g/U -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZPsycopgDA dropping connections?
Hi, Am Mittwoch, den 20.04.2005, 15:23 +1000 schrieb Richard Jones: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Has anyone else seen ZPsycopgDA just lose its connection? I've got two ZEO clients set up to use it, and every now and then one of them (the primary) just up and loses its connection. There doesn't appear to be any message in the log file *except* for the message saying that the connection's not active: I remember there was a thread in the mailinglist about the new version of ZPsycopgDA not automatically reconnecting after loosing connection. So instead of the previous versions you now see the fact the connections are dropped. The reason for dropping the connection in the first place often lay in the inproper configuration of a intermediate firewall (see tcp session timeout there) Regards Tino ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )