Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 66D379FB706 for ; Mon, 12 Feb 2007 14:49:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 47444-05-3 for ; Mon, 12 Feb 2007 14:49:40 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 7ABDD9FB762 for ; Mon, 12 Feb 2007 14:47:54 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1341957ugf for ; Mon, 12 Feb 2007 10:47:52 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=uNEJt4yVAMkrN5IlWxHlCki/fJizGT9/bzhWRu6UfeqzBZjy92fLAZL/6PF0ewUqoTCir6edlG7NfdSIgk9xYONEAiTHHmqDywoLOMO8gfbaiAP1sRV1YBjAW6ETs8PkK++e7uYMQ2RbZhaHtShHm/k7aeNBL2lKKF8iG2877GQ= Received: by 10.66.225.1 with SMTP id x1mr12723234ugg.1171306072137; Mon, 12 Feb 2007 10:47:52 -0800 (PST) Received: by 10.66.217.13 with HTTP; Mon, 12 Feb 2007 10:47:51 -0800 (PST) Message-ID: <55c095e90702121047x1c66b098xbcf0d308195ff584@mail.gmail.com> Date: Mon, 12 Feb 2007 15:47:51 -0300 From: "Ezequias Rodrigues da Rocha" To: "Richard Huxton" Subject: Re: [SQL] Deadlock on transaction Cc: "Scott Marlowe" , pgsql-sql@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <45D0B565.9060402@archonet.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_80065_28216323.1171306071795" References: <55c095e90702120943v2909044eo91445b0eda3958c7@mail.gmail.com> <1171302488.3565.15.camel@state.g2switchworks.com> <55c095e90702121008u6d3d27c0m16e52d63f97c3e7d@mail.gmail.com> <45D0B565.9060402@archonet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.524 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/163 X-Sequence-Number: 24628 ------=_Part_80065_28216323.1171306071795 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 2007/2/12, Richard Huxton : > > Ezequias Rodrigues da Rocha wrote: > > I mean really deadlock. Other transactions can't access the database > until > > the main transaction is complete. A question: > > > > PostgreSQL doesn't permit multiple transactions concurrently ? > > PG has quite good concurrency behaviour. And "can't access the database" > isn't anything to do with locking - clients should still be able to log > in. > > We'll need more details: > 1. How do you know this is a deadlock? You haven't shown us what's in > pg_locks, but I assume you've identified the problem there. I knew becouse my Delphi application reports it to me. If there is anything in pg_log I could see it to you. 2. What data are you loading, to what tables? Simple data but allways with the same username (does it make any difference ?) 3. Are there any foreign-keys or triggers we would need to know about? No. Ps: When I do not use transactions the connections does not lock to other users. > -- > Richard Huxton > Archonet Ltd > --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_80065_28216323.1171306071795 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

2007/2/12, Richard Huxton <dev@archonet.com>: Ezequias Rodrigues da Rocha wrote:
> I mean really deadlock. Other tr= ansactions can't access the database until
> the main transaction= is complete. A question:
>
> PostgreSQL doesn't permit mul= tiple transactions concurrently ?

PG has quite good concurrency behaviour. And "can't access= the database"
isn't anything to do with locking - clients shou= ld still be able to log in.

We'll need more details:
1. How d= o you know this is a deadlock? You haven't shown us what's in
pg_locks, but I assume you've identified the problem there.

I knew becouse my Delphi application reports it to me. If the= re is anything in pg_log I could see it to you.

2. What data are you loading, to what tables?

Simple d= ata but allways with the same username (does it make any difference ?)
=

3. Are there any foreign-keys or triggers we would need to know about?

No.

Ps: When I do not use transactions the connections does n= ot lock to other users.
--
=    Richard Huxton
   Archonet Ltd



--
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
&nb= sp;            =             &nb= sp;        Atenciosamente (Sincerel= y)
           &nb= sp;            = Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditadurasThe worst of democracies is still better than the better of dictatorships=
http://ezequiasrocha.blo= gspot.com/ ------=_Part_80065_28216323.1171306071795--