[Zope] Z PyGreSQL problems with a python product

[Hannu Krosing]

John Morton wrote:
> 
> I'm working on a python product (under 2.1.4) that calls a ZSQL method
> when it's added, to store most of it's properties in a database using
> a ZPyGreSQL connection. It's add method looks like this:
> 
---------
> 
>   Sorry, a Zope error occurred.
> 
>   Traceback (innermost last):
>     File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module
>     File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 179, in publish
>     File /usr/lib/zope/lib/python/Zope/__init__.py, line 180, in zpublisher_exception_hook
>     File /usr/lib/zope/lib/python/ZODB/Transaction.py, line 180, in begin
>     File /usr/lib/zope/lib/python/ZODB/Transaction.py, line 155, in abort
>     File /usr/lib/zope/lib/python/Shared/DC/ZRDB/THUNK.py, line 115, in abort
>     File /usr/lib/zope/lib/python/Products/ZPyGreSQLDA/db.py, line 117, in _abort
>   ValueError: PQsendQuery() -- There is no connection to the backend.
> 
> And from that point on, until I close and open the database
> connection, I get this message when testing any ZSQL method that uses
> the same connection.
> 
> Any idea as to what's going on?

Most likely you send a query that kills your backend ;(

ZPyGreSQL does not re-connect automatically.



--------------
Hannu