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