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 sup****t 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 (****t=0x83bc800) at postmaster.c:2934
#4 0x081dbb7e in BackendStartup (****t=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?
--
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
|
