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?
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 |