Skip site navigation (1) Skip section navigation (2)

Re: BUG #6450: PQexec stuck.

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <vipul(dot)patel(at)elitecore(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6450: PQexec stuck.
Date: 2012-02-09 17:03:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
<vipul(dot)patel(at)elitecore(dot)com> wrote:
> some time call of create table is stuck which is called by PQexec.
What locks and blocking do you see when this happens?'
Have you considered getting an explicit lock with NOWAIT at the
start of your transaction, to test whether you can currently acquire
the rights to proceed?
> in current stat the PQexec will stuck till anyone not vacume and
> reindexing the DB.
I've never seen such a situation.  Are you sure that's really
needed, as opposed to something that just takes long enough that the
issue has cleared by the time you're finished with these steps?

In response to


pgsql-bugs by date

Next:From: John R PierceDate: 2012-02-09 18:44:13
Subject: Re: BUG #6451: problem while installing gridsql
Previous:From: Duncan RanceDate: 2012-02-09 15:07:09
Subject: Re: BUG #6425: Bus error in slot_deform_tuple

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group