| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Spiros Ioannou <sivann(at)inaccess(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
| Subject: | Re: Lots of stuck queries after upgrade to 9.4 |
| Date: | 2015-07-20 11:22:42 |
| Message-ID: | 20150720112242.GZ5520@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2015-07-20 13:06:51 +0200, Alvaro Herrera wrote:
> 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.
Hm. The problem seems to be the WaitXLogInsertionsToFinish() call in
XLogFlush().
Spiros, I guess you have commit_delay enabled? If so, does disabling it
"fix" the issue?
Regards,
Andres
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pbj | 2015-07-20 11:23:07 | Re: Problem building both Python 2 and 3 into Postgres 9.4.4? |
| Previous Message | Alvaro Herrera | 2015-07-20 11:06:51 | Re: Lots of stuck queries after upgrade to 9.4 |