Re: semop hanging - Postgres 9.4.4 - Mailing list pgsql-admin

From Michał Nowak
Subject Re: semop hanging - Postgres 9.4.4
Date
Msg-id 5672ef1616eef3.56064279@wp.pl
Whole thread Raw
In response to semop hanging - Postgres 9.4.4  (Michał Nowak <minowack@wp.pl>)
List pgsql-admin
Hello,

Thanks for all replies.


> The perf top output suggests the possibility of a corrupted index,
> causing an endless loop.


Yes! Rebuilding indexes solves problem for this table. :)

But after 20h problem is back on another table. First table has about 2m records, second has only 200k.



> There is a bug fix in 9.4.5 which can cause a deadlock on
> lightweight locking.


I've just upgraded to 9.4.5 and hope that helps. I'll keep you posted.


Best Regards,
Michal




pgsql-admin by date:

Previous
From: CN
Date:
Subject: Re: feature request: pg_restore renaming target schema
Next
From: clingareddy@vsoftcorp.com
Date:
Subject: How to move data folder to another mount pount