BUG #6352: Getting signal 7: Bus error

Started by Nonameover 14 years ago2 messagesbugs
Jump to latest
#1Noname
sebas@metasite.net

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

#2Kevin Grittner
Kevin.Grittner@wicourts.gov
In reply to: Noname (#1)
Re: BUG #6352: Getting signal 7: Bus error

<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