Re: [Zope-DB] ZPsycopgDA looses db connection

2005-11-22 Thread Dieter Maurer
Ulrich Wisser wrote at 2005-11-22 13:25 +0100: >I have a very strange error. From time to time ZPsycopgDA will loose the >connection to the database (used as authentication source). Subsequently >Zope does still answer requests, but no authentication is possible and >all requests are answered wi

Re: [Zope-DB] insert failing without raising exception: postgresql, psycopg

2005-11-22 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2005-11-22 03:27 -0800: >Problem: > Database inserts that worked previously are now failing, > without raising exceptions! I expect that something in your application catches exceptions. To verify this, I would add logging to "ZPsycopgDA" (indeed, I did in o

[Zope-DB] ZPsycopgDA looses db connection

2005-11-22 Thread Ulrich Wisser
Hi, I have a very strange error. From time to time ZPsycopgDA will loose the connection to the database (used as authentication source). Subsequently Zope does still answer requests, but no authentication is possible and all requests are answered with an error 403 (forbidden). I have a Zpsyc

Re: [Zope-DB] insert failing without raising exception: postgresql, psycopg

2005-11-22 Thread Charlie Clark
On 2005-11-22 at 12:27:42 [+0100], [EMAIL PROTECTED] wrote: > > Though the insert is failing, a sequence column in the target table is > apparently being incremented by the failing insert. (I deduce this > from the fact that subsequent Z SQL test inserts show sequence gap > of 12 after each fail

[Zope-DB] insert failing without raising exception: postgresql, psycopg

2005-11-22 Thread freeman
Problem: Database inserts that worked previously are now failing, without raising exceptions! Request: Help! Production Environment: zope-2.7.4, postgresql-7.4.3p2, psycopg-1.1.15, OpenBSD 3.7. Duplicated under test environment: zope 2.7.4, postgresql 8.0.