X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CB52BD1E9BE for ; Fri, 2 Apr 2004 10:32:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 56843-09 for ; Fri, 2 Apr 2004 06:32:09 -0400 (AST) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by svr1.postgresql.org (Postfix) with SMTP id 5A93DD1B4B6 for ; Fri, 2 Apr 2004 06:32:05 -0400 (AST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Fri Apr 02 12:32:05 2004 +0200 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id MAA04720 for ; Fri, 2 Apr 2004 12:32:05 +0200 (METDST) From: Christoph Haller Message-Id: <200404021032.MAA07447@rodos> Subject: BEGIN-cascade blocks application To: pgsql-interfaces@postgresql.org Date: Fri, 02 Apr 2004 12:32:04 METDST X-Mailer: Elm [revision: 212.4] X-Virus-Scanned: by amavisd-new at postgresql.org X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char 9C hex) in message header 'Received' Received: \234by rodos.fzk.de... ^ X-Archive-Number: 200404/2 X-Sequence-Number: 4823 It's PostgreSQL 7.3.4 on hppa-hp-hpux10.20, compiled by GCC 2.8.1 I'm having a ported monitoring application using the libpq interface. After running well for several hours it surprisingly stopped without any error condition. The application was blocked completely. After re-start it worked as expected. I've turned on statement logging to find out about the last one being processed. It was BEGIN; WARNING: BEGIN: already a transaction in progress It was the last of a cascade of duplicate BEGINs, and the only reason I could see for the application being blocked was this cascade. I eliminated those duplicates and now the application runs without any stops. Was it my fault? From reading the manual I was not aware firing duplicate BEGINs (ok, there were probably several thousand, but not uncommitted) could have such an drastic effect. Regards, Christoph