Lots of stuck queries after upgrade to 9.4

From: Spiros Ioannou <sivann(at)inaccess(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Lots of stuck queries after upgrade to 9.4
Date: 2015-07-19 21:49:09
Message-ID: CACKh8C-tDjQUceMQeG3BUSHS5AA35SjvCD6HgRm-Vj7x5rXmeQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We upgraded to 9.4.4 from 8.4 We have tried 9.3.x in the past with success.
Unfortunately in 9.4 gets stuck 2-3 times a week.

Lots of queries seem stuck, that is they have waiting:false. Queries can be
COMMIT or INSERT.
No blocking locks seem to exist.
strace reveals that all stuck processes they are in semop
semop(2064417, {{0, -1, 0}}, 1^C <unfinished ...>

ipcs reveals no shortage of semaphores..

Please any ideas very welcome, our service now in a very sad state..

*Spiros Ioannou IT Manager, inAccesswww.inaccess.com
<http://www.inaccess.com>M: +30 6973-903808T: +30 210-6802-358*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Spiros Ioannou 2015-07-19 21:50:20 Re: Lots of stuck queries after upgrade to 9.4
Previous Message pbj 2015-07-19 21:27:07 Problem building both Python 2 and 3 into Postgres 9.4.4?