Re: [Zope] Problem with Z Psycopg

2005-04-06 Thread Lutz Steinborn
Hi, try to ask frederico [EMAIL PROTECTED] the maintainer zpsycopg/da directly. We use postgresql 8.0.1 and psycopg 1.1.18 with out this problems. best regards Lutz On Mon, 4 Apr 2005 15:15:17 -0700 Jason Leach [EMAIL PROTECTED] wrote: I'm having a problem with Z Psycopg. From time to time

Re: [Zope] Problem with Z Psycopg

2005-04-06 Thread Barry Pederson
Jeff Gentry wrote: On Tue, 5 Apr 2005, Dieter Maurer wrote: Usually, this means that the postgres server process died... I did run into something recently where the local firewall was killing the connection to the DB server due to a timeout, so one of the local admin types wrote a small zsql

Re: [Zope] Problem with Z Psycopg

2005-04-05 Thread Garth B.
I have the same problem, but I eventually corrected it, by forcibly closing the connection each time prior to running the queries. Fortunately, my scenario uses page caching to reduce the number of hits to the db so the additional effort of reopening the connection is neglible. I'd sure like to

Re: [Zope] Problem with Z Psycopg

2005-04-05 Thread Barry Pederson
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

Re: [Zope] Problem with Z Psycopg

2005-04-05 Thread Dieter Maurer
Jason Leach wrote at 2005-4-4 15:15 -0700: 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

Re: [Zope] Problem with Z Psycopg

2005-04-05 Thread Dieter Maurer
Barry Pederson wrote at 2005-4-4 22:15 -0500: ... 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

Re: [Zope] Problem with Z Psycopg

2005-04-05 Thread Jeff Gentry
On Tue, 5 Apr 2005, Dieter Maurer 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

Re: [Zope] Problem with Z Psycopg

2005-04-05 Thread Barry Pederson
Dieter Maurer wrote: Jason Leach wrote at 2005-4-4 15:15 -0700: 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

[Zope] Problem with Z Psycopg

2005-04-04 Thread Jason Leach
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

Re: [Zope] Problem with Z Psycopg

2005-04-04 Thread Barry Pederson
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