Backend crashe with signal 11 wher restoring big database. - Mailing list pgsql-bugs

Your name        :    Krok
Your email address    :    krok@void.ru


System Configuration
---------------------
  Architecture        : Dual PIII-500

  Operating System    : FreeBSD 4.7-RELEASE-p7

  PostgreSQL version    : PostgreSQL-7.3.2

  Compiler used        : gcc 2.95.4


Please enter a FULL description of your problem:
------------------------------------------------

When restoring large database (there are several tables with >1'000'000 rows and somthing about 50 tables with
1'000-10'000rows) using cat <dump_file> | psql -U psql, backend crashes and there are messages in logs : 

Mar 25 15:14:08 frost postgres[338]: [14] LOG:  server process (pid 64665) was terminated by signal 11
Mar 25 15:14:08 frost postgres[338]: [15] LOG:  terminating any other active server processes
Mar 25 15:14:08 frost postgres[338]: [16] LOG:  all server processes terminated; reinitializing shared memory and
semaphores
Mar 25 15:14:08 frost postgres[64921]: [17] LOG:  database system was interrupted at 2003-03-25 15:13:01 MSK
Mar 25 15:14:08 frost postgres[64921]: [18] LOG:  checkpoint record is at 11/451E6D80
Mar 25 15:14:08 frost postgres[64921]: [19] LOG:  redo record is at 11/450304A0; undo record is at 0/0; shutdown FALSE
Mar 25 15:14:08 frost postgres[64921]: [20] LOG:  next transaction id: 94286227; next oid: 2959327
Mar 25 15:14:08 frost postgres[64921]: [21] LOG:  database system was not properly shut down; automatic recovery in
progress
Mar 25 15:14:08 frost postgres[64921]: [22] LOG:  redo starts at 11/450304A0
Mar 25 15:14:10 frost postgres[64921]: [23] LOG:  ReadRecord: record with zero length at 11/4585EB20
Mar 25 15:14:10 frost postgres[64921]: [24] LOG:  redo done at 11/4585EAFC
Mar 25 15:14:15 frost postgres[64921]: [25] LOG:  recycled transaction log file 0000001100000044
Mar 25 15:14:15 frost postgres[64921]: [26] LOG:  database system is ready


My configuration is :

------

max_connections = 256
superuser_reserved_connections = 2

shared_buffers = 4096           # 2*max_connections, min 16, typically 8KB each
max_fsm_relations = 100 # min 10, fsm is free space map, ~40 bytes
max_fsm_pages = 10000           # min 1000, fsm is free space map, ~6 bytes
max_locks_per_transaction = 64  # min 10
wal_buffers = 128               # min 4, typically 8KB each

sort_mem = 8192         # min 64, size in KB
vacuum_mem = 65536              # min 1024, size in KB

checkpoint_segments = 1 # in logfile segments, min 1, 16MB each
checkpoint_timeout = 3600       # range 30-3600, in seconds
commit_delay = 1000             # range 0-100000, in microseconds
commit_siblings = 5             # range 1-1000
wal_debug = 0

effective_cache_size = 16384

show_parser_stats = false
show_planner_stats = false
show_executor_stats = false
show_statement_stats = false

stats_start_collector = true
stats_reset_on_server_start = true
stats_command_string = true
stats_row_level = true
stats_block_level = true

------

Dual PIII-500, 782MB, SCSI


Thanks.

With best regards,
Krok.