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

Re: BUG #6450: PQexec stuck.

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 (view raw or flat)
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
>
>


In response to

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2012-02-10 13:18:04
Subject: Re: BUG #6450: PQexec stuck.
Previous:From: Denish PatelDate: 2012-02-09 22:51:58
Subject: Re: BUG #6433: Pg Admin Cant open

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