postgres 8.2.6 core dump when initialising. - Mailing list pgsql-admin

From Darren Reed
Subject postgres 8.2.6 core dump when initialising.
Date
Msg-id 4802F108.2090709@fastmail.net
Whole thread Raw
Responses Re: postgres 8.2.6 core dump when initialising.
List pgsql-admin
Some minutes after doing a live reindex of all my tables,
I started to get these messages:
ERROR:  could not open relation with OID 16461
...for every table(!)

So I shutdown...

LOG:  received smart shutdown request
LOG:  shutting down
LOG:  database system is shut down

And reboot....

LOG:  database system was shut down at 2008-04-13 22:38:35 PDT
LOG:  checkpoint record is at 2/8F9B5C14
LOG:  redo record is at 2/8F9B5C14; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/669090; next OID: 24651
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system is ready
LOG:  server process (PID 19944) was terminated by signal 11
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2008-04-13 22:38:38 PDT
LOG:  checkpoint record is at 2/8F9B5C14
LOG:  redo record is at 2/8F9B5C14; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/669090; next OID: 24651
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  record with zero length at 2/8F9B5C5C
LOG:  redo is not required
LOG:  database system is ready
LOG:  server process (PID 25402) was terminated by signal 11
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2008-04-13 22:38:51 PDT
LOG:  checkpoint record is at 2/8F9B5C5C
LOG:  redo record is at 2/8F9B5C5C; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/669090; next OID: 24651
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  record with zero length at 2/8F9B5CA4
LOG:  redo is not required
LOG:  database system is ready
LOG:  server process (PID 13888) was terminated by signal 11
LOG:  terminating any other active server processes
...

 /usr/pkg/bin/psql --version
psql (PostgreSQL) 8.2.6
contains support for command-line editing

Program terminated with signal 11, Segmentation fault.
#0  0x0829845c in RelationCacheInitializePhase2 () at relcache.c:2400
2400                    LOAD_CRIT_INDEX(TriggerRelidNameIndexId);
(gdb) where
#0  0x0829845c in RelationCacheInitializePhase2 () at relcache.c:2400
#1  0x082ac19c in InitPostgres (dbname=0x83ba450 "postgres",
    username=0x83c1428 "postgres") at postinit.c:459
#2  0x0820b533 in PostgresMain (argc=4, argv=0x83c1458,
    username=0x83c1428 "postgres") at postgres.c:3143
#3  0x081dc572 in BackendRun (port=0x83bc800) at postmaster.c:2934
#4  0x081dbb7e in BackendStartup (port=0x83bc800) at postmaster.c:2561
#5  0x081d985c in ServerLoop () at postmaster.c:1214
#6  0x081d9292 in PostmasterMain (argc=3, argv=0xbfbfeb34) at
postmaster.c:966
#7  0x08187989 in main (argc=3, argv=0xbfbfeb34) at main.c:188
(gdb) p status
$1 = {hashp = 0x8, curBucket = 2, curEntry = 0x8360777}
(gdb) p idhentry
$2 = (RelIdCacheEnt *) 0x836b168
(gdb) p oldcxt
$3 = (MemoryContext) 0x83de258
(gdb) p needNewCacheFile
$4 = 1 '\001'
(gdb) p ird
$5 = (Relation) 0x0
(gdb) p *oldcxt
$1 = {type = T_AllocSetContext, methods = 0x8372de0, parent = 0x83c4080,
  firstchild = 0x0, nextchild = 0x83de1d0,
  name = 0x83de2b4 "TopTransactionContext"}
(gdb) p *idhentry
$2 = {reloid = 137801832, reldesc = 0xbbbed200}

How to fix this?


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow pg_dump
Next
From: Baudrion Philippe
Date:
Subject: Re: Retore Postgres DB without dump