BUG #6352: Getting signal 7: Bus error
The following bug has been logged on the website:
Bug reference: 6352
Logged by: Sebastian
Email address: sebas@metasite.net
PostgreSQL version: 8.4.9
Operating system: CentOS 5.7 on OpenVz (2.6.32-042stab044.11)
Description:
When trying to import dump getting this:
LOG: server process (PID 30683) was terminated by signal 7: Bus error
LOG: terminating any other active server processes
postgresql.conf settings:
max_connections = 20
shared_buffers = 13288MB
temp_buffers = 128MB
max_prepared_transactions = 25
work_mem = 2048MB
maintenance_work_mem = 32MB
max_stack_depth = 8MB
max_files_per_process = 1000
fsync = on
synchronous_commit = off
wal_sync_method = fsync
full_page_writes = off
wal_buffers = 512MB
wal_writer_delay = 2000ms
checkpoint_segments = 50
Container has 16384MB RAM
kernel values:
kernel.shmmni = 655360
kernel.shmall = 20971520
kernel.shmmax = 175726755840
<sebas@metasite.net> wrote:
PostgreSQL version: 8.4.9
Operating system: CentOS 5.7 on OpenVz (2.6.32-042stab044.11)
LOG: server process (PID 30683) was terminated by signal 7: Bus
error
LOG: terminating any other active server processes
We've had a few reports like this lately, all on VMs. Here is one
where a solution was found:
http://archives.postgresql.org/pgsql-bugs/2011-12/msg00024.php
This is most likely a bug in OpenVz, not PostgreSQL.
-Kevin