Re: "stuck spinlock"

On Dec 12, 2013, at 6:41 PM, Andres Freund <andres@2ndquadrant.com> wrote:

> Christophe: are there any "unusual" ERROR messages preceding the crash,
> possibly some minutes before?

Interestingly, each spinlock PANIC is *followed*, about one minute later (+/- five seconds) by a "canceling statement
dueto statement timeout" on that exact query.  The queries vary enough in text that it is unlikely to be a coincidence. 

There are a *lot* of "canceling statement due to statement timeout" messages, which is interesting, because:

postgres=# show statement_timeout;statement_timeout
-------------------0
(1 row)

--
-- Christophe Pettus  xof@thebuild.com