From: | Vipul Patel <vipul(dot)patel(at)elitecore(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6450: PQexec stuck. |
Date: | 2012-02-10 08:24:35 |
Message-ID: | 4F34D443.6010104@elitecore.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
I don't understand why " CREATE TABLE " Need to lock.
CREATE TABLE Statement gose Hang state, whether it is execute by any
client using (PQexec) or Standard "psql".
Regards,
Vipul Patel.
On Thursday 09 February 2012 10:33 PM, Kevin Grittner wrote:
> <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?
>
> http://wiki.postgresql.org/wiki/Lock_Monitoring'
>
> 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?
>
> -Kevin
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2012-02-10 13:18:04 | Re: BUG #6450: PQexec stuck. |
Previous Message | Denish Patel | 2012-02-09 22:51:58 | Re: BUG #6433: Pg Admin Cant open |