Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5, pg 9.0.3

From: Lutz Steinborn <l(dot)steinborn(at)4c-ag(dot)de>
To: psycopg(at)postgresql(dot)org
Subject: Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5, pg 9.0.3
Date: 2012-08-03 13:33:40
Message-ID: 20120803153340.7fc8524d5a38e459f2f68907@4c-ag.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hi,

it is impossible to INSERT or UPDATE with ZSQL from external methods. The first
statement after a INSERT/UPDATE ends with an ROLLBACK.

Example:
2012-08-03 14:58:16.821 CEST [14542][501bca30.38ce][0] pre2(at)4com20110627_utf8
LOG: statement: BEGIN
2012-08-03 14:58:16.821 CEST [14542][501bca30.38ce][0]
pre2(at)4com20110627_utf8 LOG: duration: 0.021 ms
2012-08-03 14:58:16.821 CEST [14542][501bca30.38ce][0] pre2(at)4com20110627_utf8
LOG: statement: update ADRE set modified_at= '120803145816', modified_by_user=
'l.steinborn@', modified_by_meth= 'update_IndiAdre', mail1 =
'l(dot)steinborn(at)4c-ag(dot)de', /* Individuum.py (3) */ FirstName = 'Lutz', Last_entry
= '0001~000000000000' /* Serge.py (1) */ where login = '*******' AND password =
'******' AND Mail1 = 'l(dot)steinborn(at)4c-ag(dot)de'
2012-08-03 14:58:16.822 CEST [14542] [501bca30.38ce][0] pre2(at)4com20110627_utf8
LOG: duration: 0.273 ms
2012-08-03 14:58:16.823 CEST [14542][501bca30.38ce][0] pre2(at)4com20110627_utf8
LOG: statement: SHOW default_transaction_isolation
2012-08-03 14:58:16.823 CEST [14542] [501bca30.38ce][0] pre2(at)4com20110627_utf8
LOG: duration: 0.034 ms
2012-08-03 14:58:16.823 CEST [14542][501bca30.38ce][0] pre2(at)4com20110627_utf8
LOG: statement: ROLLBACK

Any idea whats going on?

--
Lutz

Responses

Browse psycopg by date

  From Date Subject
Next Message Richard Harley 2012-08-03 13:42:04 Re: Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5, pg 9.0.3
Previous Message Alan Etkin 2012-07-30 11:53:28 Re: error after installing on CentOS 5.8 with source