Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C1CB42E0031 for ; Wed, 27 Feb 2008 02:39:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 87542-01 for ; Wed, 27 Feb 2008 02:39:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from out3.smtp.messagingengine.com (out3.smtp.messagingengine.com [66.111.4.27]) by postgresql.org (Postfix) with ESMTP id 9203A2E0030 for ; Wed, 27 Feb 2008 02:39:35 -0400 (AST) Received: from compute1.internal (compute1.internal [10.202.2.41]) by out1.messagingengine.com (Postfix) with ESMTP id 9C9BAA25E2; Wed, 27 Feb 2008 01:39:34 -0500 (EST) Received: from heartbeat2.messagingengine.com ([10.202.2.161]) by compute1.internal (MEProxy); Wed, 27 Feb 2008 01:39:34 -0500 X-Sasl-enc: /sgp4BRm2XnqjnXyytCJU86gi/0sMT4upFXypak23DK8 1204094374 Received: from [192.168.1.235] (76-191-150-176.dsl.dynamic.sonic.net [76.191.150.176]) by mail.messagingengine.com (Postfix) with ESMTPSA id 0A7B721BF7; Wed, 27 Feb 2008 01:39:33 -0500 (EST) Message-ID: <47C50590.2000104@fastmail.net> Date: Tue, 26 Feb 2008 22:39:12 -0800 From: Darren Reed User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Tom Lane CC: Shoaib Mir , pgsql-admin@postgresql.org Subject: Re: How to reindex when unable to open relation? References: <47C3AE1F.2010804@fastmail.net> <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> In-Reply-To: <14210.1204090477@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200802/365 X-Sequence-Number: 28439 Tom Lane wrote: > Darren Reed 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