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: