From: | chris(dot)bainbridge(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13893: PANIC: stuck spinlock |
Date: | 2016-01-27 20:31:19 |
Message-ID: | 20160127203119.2537.78623@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13893
Logged by: Chris Bainbridge
Email address: chris(dot)bainbridge(at)gmail(dot)com
PostgreSQL version: 9.4.5
Operating system: Debian Jessie
Description:
Sometimes on system shutdown postgresql hangs and the log shows:
PANIC: stuck spinlock (0x7f6089f088e0) detected at
/build/postgresql-9.4-CPUoxi/postgresql-9.4-9.4.5/build/../src/backend/storage/buffer/bufmgr.c:1292
or
2016-01-27 19:17:37 GMT [3351-1] PANIC: stuck spinlock (0x7f1de51dc8e0)
detected at
/build/postgresql-9.4-CPUoxi/postgresql-9.4-9.4.5/build/../src/backend/storage/buffer/bufmgr.c:1705
Which causes systemd to hang:
Jan 27 19:16:33 debian postgresql(at)9(dot)4-main[4959]: pg_ctl: server does not
shut down
Jan 27 19:16:33 debian systemd[1]: postgresql(at)9(dot)4-main(dot)service: control
process exited, code=exited status=1
Jan 27 19:17:37 debian systemd[1]: postgresql(at)9(dot)4-main(dot)service: main process
exited, code=exited, status=1/FAILURE
Jan 27 19:17:37 debian systemd[1]: Stopped PostgreSQL Cluster 9.4-main.
Jan 27 19:17:37 debian systemd[1]: Unit postgresql(at)9(dot)4-main(dot)service entered
failed state.
Jan 27 19:17:37 debian systemd[1]: Stopping system-postgresql.slice.
Sometimes the shutdown continues after a timeout, other times it seems to
hang indefinitely, sysrq-l shows postgres process as
http://imgur.com/kRAtvxw (Linux 4.4 kernel)
A similar bug was reported by another user a few months ago also for 9.4:
http://www.postgresql.org/message-id/20150810204319.2695.22673@wrigleys.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Sinha, Amitava | 2016-01-27 21:22:27 | Is Windows Posready 2009 XP operating system supported? |
Previous Message | Tom Lane | 2016-01-27 16:11:29 | Re: BUG #13892: SELECT FALSE = FALSE = TRUE; error |