Re: Lots of stuck queries after upgrade to 9.4

Spiros Ioannou wrote:
> Hi Tom,
> thank you for your input. The DB was stuck again, I attach all logs and
> stack traces.
>
> A stack trace from a COMMIT, an INSERT, an UPDATE, the wal writer, the
> writer, and a sequence.
>
> Stracing the commit was stuck at: semop(3145761, {{12, -1, 0}}, 1

Hmm, isn't this an indication of problems in the WAL insertion logic?
Looks to me like there are deadlocks using lwlocks.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services