From: Darren Reed <darrenr+postgres@fastmail.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Shoaib Mir <shoaibmir@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to reindex when unable to open relation?
Date: Tue, 26 Feb 2008 22:39:12 -0800
Message-ID: <47C50590.2000104@fastmail.net> (raw)
In-Reply-To: <14210.1204090477@sss.pgh.pa.us>
References: <47C3AE1F.2010804@fastmail.net>
<bf54be870802252233o5d7aa387o2c1eac2fcd2ae9fe@mail.gmail.com>
<47C3E88B.8070803@fastmail.net>
<2862.1204040458@sss.pgh.pa.us>
<47C4F178.1050102@fastmail.net>
<14002.1204089578@sss.pgh.pa.us>
<47C4F353.4040304@fastmail.net>
<14210.1204090477@sss.pgh.pa.us>
Tom Lane wrote:
> Darren Reed <darrenr+postgres@fastmail.net> writes:
> >>> How do I know which files those are?
> >>
> >> find $PGDATA -name pg_internal.init
>
> > Doesn't exist.
>
> Sucks to be you, then :-(
>
> I'm curious though exactly where the failure is, because there's not
> much in RelationCacheInitializePhase2 that looks like it could crash,
> other than the init-file reading (I assume load_relcache_init_file
> got inlined into RelationCacheInitializePhase2). Do you want to try
> rebuilding the backend with --enable-debug so we can get a better
> traceback?
>
#0 0x08298378 in RelationCacheInitializePhase2 () at relcache.c:2394
2394 LOAD_CRIT_INDEX(AttributeRelidNumIndexId);
(gdb) where
#0 0x08298378 in RelationCacheInitializePhase2 () at relcache.c:2394
#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=0xbfbfeb14) at
postmaster.c:966
#7 0x08187989 in main (argc=3, argv=0xbfbfeb14) at main.c:188
(gdb) p ird
$1 = (Relation) 0x0
(gdb) p oldcxt
$2 = (MemoryContext) 0x83de258
(gdb) p needNewCacheFile
$3 = 1 '\001'
(gdb) p status
$4 = {hashp = 0x8, curBucket = 2, curEntry = 0x8360777}
(gdb) p idhentry
$5 = (RelIdCacheEnt *) 0x836b168
Darren
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: darrenr+postgres@fastmail.net, tgl@sss.pgh.pa.us, shoaibmir@gmail.com
Subject: Re: How to reindex when unable to open relation?
In-Reply-To: <47C50590.2000104@fastmail.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox