Hi Brian, On Wed, Aug 1, 2012 at 10:21 PM, Brian McNally <bmcnally@xxxxxx> 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@xxxxxx> 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@xxxxxxxxx Skype: gray-hemp Phone: +79160686204 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
