[Zope] ZPsycopgDA dropping connections?

[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:

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-----