BUG #13558: PANIC: stuck spinlock

From: ismaelbezerra(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13558: PANIC: stuck spinlock
Date: 2015-08-10 20:43:19
Message-ID: 20150810204319.2695.22673@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: 13558
Logged by: Ismael Bezerra
Email address: ismaelbezerra(at)gmail(dot)com
PostgreSQL version: 9.4.1
Operating system: CentOS release 6.6 (Final)
Description:

Hello,

My database restarted with the following error in the log:
PANIC: stuck spinlock (0x7f0921ac2b00) detected at bufmgr.c: 1291
LOG: CheckPointer process (PID 12343) was terminated by signal 6: Aborted
LOG: terminating any other active server processes
LOG: archiver process (PID 12347) exited with exit code 1

What can this be? It is a Bug?

PostgreSQL settings

listen_addresses = '*'
max_connections = 600
shared_buffers = 165GB
datestyle = 'iso, mdy'
lc_messages = 'C'
lc_monetary = 'C'
lc_numeric = 'C'
lc_time = 'C'
default_text_search_config = 'pg_catalog.portuguese'
hot_standby = on
archive_mode = on
temp_tablespaces = temp_tbls
#archive_command = 'cp %p /u02/pg_backup/arch_pg/%f && gzip
/u02/pg_backup/arch_pg/%f'
archive_command='gzip -c %p > /u02/pg_backup/arch_pg/%f.gz'
archive_timeout = 90
wal_level = hot_standby
max_wal_senders = 3
wal_keep_segments = 30
max_standby_archive_delay = 360s
max_standby_streaming_delay = 360s
stats_temp_directory = '/dev/shm'
effective_cache_size = 165GB
work_mem = 128MB
maintenance_work_mem = 128MB
checkpoint_completion_target = 0.9
max_stack_depth = 9000
autovacuum = on
checkpoint_timeout = 3600
checkpoint_segments = 3096
huge_pages = on

Version Kernel: 2.6.32-504.16.2.el6.x86_64 # 1 SMP Wed Apr 22 06:48:29 UTC
2015 x86_64 x86_64 x86_64 GNU / Linux

Total Memory: 189GB

That error may be the one that presents the log?

Browse pgsql-bugs by date

  From Date Subject
Next Message maciek 2015-08-10 22:31:14 BUG #13559: WAL replay stuck after DROP VIEW
Previous Message Dmitri Bourlatchkov 2015-08-10 15:57:31 Re: [BUGS] PostgreSQL 9.4.4 Solaris 10 i386 download links point to Sparc binaries