X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5E70252871 for ; Tue, 14 Jun 2005 08:12:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26163-10 for ; Tue, 14 Jun 2005 11:12:12 +0000 (GMT) Received: from fmmailgate05.web.de (fmmailgate05.web.de [217.72.192.243]) by svr1.postgresql.org (Postfix) with ESMTP id D2C0F52809 for ; Tue, 14 Jun 2005 08:12:11 -0300 (ADT) Received: by fmmailgate05.web.de (8.12.10/8.12.10/webde Linux 0.7) with SMTP id j5EBBY29016826 for ; Tue, 14 Jun 2005 13:12:13 +0200 Received: from [131.188.30.122] by freemailng0205.web.de with HTTP; Tue, 14 Jun 2005 13:12:13 +0200 Date: Tue, 14 Jun 2005 13:12:13 +0200 Message-Id: <141218891@web.de> MIME-Version: 1.0 From: Vilinski Vladimir To: pgsql-sql@postgresql.org Subject: WHY transaction waits for another transaction? Precedence: fm-user Organization: http://freemail.web.de/ Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/233 X-Sequence-Number: 21834 Hallo I'm porting one Oracle Application to Postgres. This Programm uses "long living" Transactions. During the execution of transaction Nr:10295 (PID:18430) one new transacti= on with Nr:10339 (PID:18431) starts, that writes one record into the table. But th= is new transaction never stops, because it tries to set one ShareLock to its parrent transaction Nr:10295.=20 My problem is, how can i found out - WHY the second transaction waits for end of first transaction=3F=20 Is there a tool for analyzing such deadlocks=3F pg=5Flock output relation database transacti pid mode granted 251553 251331 18430 AccessShareLock t 251553 251331 18430 RowExclusiveLock t 251487 251331 18430 AccessShareLock t 251487 251331 18430 RowShareLock t 251487 251331 18430 RowExclusiveLock t 251492 251331 18430 AccessShareLock t 251494 251331 18431 AccessShareLock t 251434 251331 18434 AccessShareLock t 251407 251331 18431 AccessShareLock t 251434 251331 18430 AccessShareLock t 251429 251331 18430 AccessShareLock t 251548 251331 18430 AccessShareLock t 251548 251331 18430 RowExclusiveLock t 251575 251331 18430 AccessShareLock t 251458 251331 18430 AccessShareLock t 251524 251331 18434 AccessShareLock t 10293 18434 ExclusiveLock t 251482 251331 18430 AccessShareLock t 251482 251331 18430 RowShareLock t 251492 251331 18431 AccessShareLock t 251577 251331 18431 AccessShareLock t 251477 251331 18431 AccessShareLock t 251567 251331 18431 AccessShareLock t 251417 251331 18431 AccessShareLock t 251492 251331 18434 AccessShareLock t 1247 251331 18431 AccessShareLock t 16839 251331 18438 AccessShareLock t 251494 251331 18430 AccessShareLock t 251494 251331 18430 RowShareLock t 251494 251331 18430 RowExclusiveLock t 251434 251331 18431 AccessShareLock t 251553 251331 18431 AccessShareLock t 251494 251331 18434 AccessShareLock t 251392 251331 18431 AccessShareLock t 251472 251331 18430 AccessShareLock t 251472 251331 18430 RowShareLock t 251526 251331 18431 AccessShareLock t 251577 251331 18430 AccessShareLock t 251482 251331 18431 AccessShareLock t 251482 251331 18431 RowShareLock t 251472 251331 18431 AccessShareLock t 251472 251331 18431 RowShareLock t 251472 251331 18431 RowExclusiveLock t 251487 251331 18434 AccessShareLock t 251553 251331 18434 AccessShareLock t 251407 251331 18430 AccessShareLock t 251407 251331 18430 RowShareLock t 10381 18438 ExclusiveLock t 251487 251331 18431 AccessShareLock t 251487 251331 18431 RowShareLock t 251487 251331 18431 RowExclusiveLock t 251509 251331 18430 AccessShareLock t 251386 251331 18431 AccessShareLock t 251394 251331 18430 AccessShareLock t 10339 18431 ExclusiveLock t 251407 251331 18434 AccessShareLock t 10295 18430 ExclusiveLock t 251422 251331 18430 AccessShareLock t 10295 18431 ShareLock f =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F Mit der Gruppen-SMS von WEB.DE FreeMail k=F6nnen Sie eine SMS an alle=20 Freunde gleichzeitig schicken: http://freemail.web.de/features/=3Fmc=3D021179