Re: Problem running "ALTER TABLE...", ALTER TABLE waiting

Hi Brian,

On Wed, Aug 1, 2012 at 10:21 PM, Brian McNally <bmcnally@uw.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@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@uw.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.ru@gmail.com Skype: gray-hemp Phone: +79160686204