Postgres Pro
Downloads
Home   >   mailing lists

Lots of stuck queries after upgrade to 9.4 - Mailing list pgsql-general

From Spiros Ioannou
Subject Lots of stuck queries after upgrade to 9.4
Date
Msg-id CACKh8C-tDjQUceMQeG3BUSHS5AA35SjvCD6HgRm-Vj7x5rXmeQ@mail.gmail.com
Whole thread Raw
Responses Re: Lots of stuck queries after upgrade to 9.4  (Spiros Ioannou <sivann@inaccess.com>)
Re: Lots of stuck queries after upgrade to 9.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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, inAccess
www.inaccess.com

M: +30 6973-903808
T: +30 210-6802-358

pgsql-general by date:

Previous
From: pbj@cmicdo.com
Date:
Subject: Problem building both Python 2 and 3 into Postgres 9.4.4?
Next
From: Spiros Ioannou
Date:
Subject: Re: Lots of stuck queries after upgrade to 9.4