Jason Leach wrote:
I'm having a problem with Z Psycopg.  From time to time (quite often)
it looses the connection with the database and I get:
   Site Error
   An error was encountered while publishing this resource.
   Error Type: OperationalError
   Error Value: no connection to the server

Then I have to login then close and open the connection.  It then
works for a while before bailing again.

Does anyone know what would be causing this?

Zope Version (Zope 2.7.3-0, python 2.3.4, linux2)
Python Version 2.3.4 (#1, Oct 13 2004, 21:44:19) [GCC 2.95.4 20011002
(Debian prerelease)]
And ZPsycopg is version 1.11

Not sure, but I can report seeing the same thing on a different setup

        FreeBSD 4.8
        Zope 2.7.5
        Python 2.3.5
        psycopg 1.1.18 (linked to PostgreSQL 8.0.1 client library)

        (PostgreSQL server is also 8.0.1, but on FreeBSD 5.2.1)

On the very same machine I also have

        Zope 2.6.1
        Python 2.1.3
        psysopg 1.0.6 (linked to an older PostgreSQL 7.2 client library)

running simultaneously, connecting to the very same DBs, but it hasn't had the same connection problems.

I was wondering if it might be something with psycopg and the new pgsql 8.0.1 library. What pgsql client lib is you psycopg linked to?

Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to