| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Spiros Ioannou <sivann(at)inaccess(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Lots of stuck queries after upgrade to 9.4 |
| Date: | 2015-07-19 22:01:49 |
| Message-ID: | 533.1437343309@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Spiros Ioannou <sivann(at)inaccess(dot)com> writes:
> 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 ...>
Stack traces of the stuck processes might help determine what's going on.
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
Please try to capture traces for both the COMMIT and INSERT cases,
as they're almost certainly different.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amitabh Kant | 2015-07-20 03:59:22 | Re: Upgrade postgres cluster on FreeBSD using pg_upgrade |
| Previous Message | Tom Lane | 2015-07-19 21:54:04 | Re: Problem building both Python 2 and 3 into Postgres 9.4.4? |