The following bug has been logged on the website:
Bug reference: 13558
Logged by: Ismael Bezerra
Email address: ismaelbezerra@gmail.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?
