From: | Sergey Konoplev <sergey(dot)konoplev(at)postgresql-consulting(dot)com> |
---|---|
To: | Brian McNally <bmcnally(at)uw(dot)edu> |
Cc: | raghu ram <raghuchennuru(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Problem running "ALTER TABLE...", ALTER TABLE waiting |
Date: | 2012-08-02 12:57:10 |
Message-ID: | CAL_0b1vnaN0y9uDLgjznebxRfwy1TU4ZPE8kvPTr+JLvDy8cyw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Brian,
On Wed, Aug 1, 2012 at 10:21 PM, Brian McNally <bmcnally(at)uw(dot)edu> wrote:
> I was able to upgrade Postgres to 9.0.8 today and the ALTER TABLE... command
> still hangs. Stracing the hung PID doesn't reveal much:
>
> [root(at)gvsdb-dev ~]# strace -fp 13107
> Process 13107 attached - interrupt to quit
> semop(843382828, 0x7fffd9671ab0, 1
>
> ps still shows the same waiting process:
>
> postgres 13107 13067 0 11:14 ? 00:00:00 postgres: postgres exomeSNP
> [local] ALTER TABLE waiting
Can you attach to the hanging process with gdb and show a backtrace?
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD
>
> --
> Brian McNally
>
>
> On 07/20/2012 12:06 AM, Sergey Konoplev wrote:
>>
>> On Fri, Jul 20, 2012 at 10:42 AM, Brian McNally <bmcnally(at)uw(dot)edu> wrote:
>>>
>>> Thanks for the help. I don't get any results from that query either
>>> though.
>>
>>
>> Okay, it looks like a bug for me.
>>
>> What I would do is to upgrade Pg to the latest minor release 9.0.8.
>> Probably this issue has already been solved.
>>
>> If it will not help run strace -p <hanging_pid> and show its output.
>>
>>
>
--
Sergey Konoplev
a database architect, software developer at PostgreSQL-Consulting.com
http://www.postgresql-consulting.com
Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Lanitz | 2012-08-02 15:08:58 | How to don't update sequence on rollback of a transaction |
Previous Message | dinesh kumar | 2012-08-02 12:30:00 | Re: Threads With Libpq |