postgres 8.2.6 core dump when initialising.

From: Darren Reed <darrenr+postgres(at)fastmail(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgres 8.2.6 core dump when initialising.
Date: 2008-04-14 05:52:08
Message-ID: 4802F108.2090709@fastmail.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Baudrion Philippe 2008-04-14 08:58:41 Re: Retore Postgres DB without dump
Previous Message Tom Lane 2008-04-13 02:46:06 Re: Slow pg_dump