Обсуждение: 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:=20=20=20=20=20=20=20=20

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 =3D 20

shared_buffers =3D 13288MB
temp_buffers =3D 128MB
max_prepared_transactions =3D 25

work_mem =3D 2048MB
maintenance_work_mem =3D 32MB
max_stack_depth =3D 8MB

max_files_per_process =3D 1000=20=20

fsync =3D on
synchronous_commit =3D off
wal_sync_method =3D fsync
full_page_writes =3D off
wal_buffers =3D 512MB
wal_writer_delay =3D 2000ms
checkpoint_segments =3D 50

Container has 16384MB RAM

kernel values:

kernel.shmmni =3D 655360
kernel.shmall =3D 20971520
kernel.shmmax =3D 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