Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1678464FC31 for ; Thu, 25 Sep 2008 16:34:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88060-04 for ; Thu, 25 Sep 2008 16:34:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 8804764FC01 for ; Thu, 25 Sep 2008 16:34:39 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m8PJYZnf023097; Thu, 25 Sep 2008 15:34:35 -0400 (EDT) To: "Scott Marlowe" cc: "BJ Taylor" , pgsql-admin@postgresql.org Subject: Re: missing chunk number 0 for toast value In-reply-to: References: <3d78fcfd0809241132y14a832cai8b32bc32e936699e@mail.gmail.com> <10862.1222287999@sss.pgh.pa.us> <3d78fcfd0809241446j326110c4p9907e04dbd10106b@mail.gmail.com> <5723.1222349048@sss.pgh.pa.us> <3d78fcfd0809250909h148daba8k2ad29e176d9a06fd@mail.gmail.com> Comments: In-reply-to "Scott Marlowe" message dated "Thu, 25 Sep 2008 13:04:34 -0600" Date: Thu, 25 Sep 2008 15:34:35 -0400 Message-ID: <23096.1222371275@sss.pgh.pa.us> From: Tom Lane 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: 200809/310 X-Sequence-Number: 30403 "Scott Marlowe" writes: > On Thu, Sep 25, 2008 at 10:09 AM, BJ Taylor > wrote: >> PANIC: right sibling's left-link doesn't match: block 175337 links to >> 243096 instead of expected 29675 in index "dbmail_headervalue_3" >> STATEMENT: INSERT INTO dbmail_headervalue (headername_id, physmessage_id, >> headervalue) VALUES (4,12335778,'from [76.13.13.25] by >> n6.bullet.mail.ac4.yahoo.com with NNFMP; 25 Sep 2008 04:01:36 -0000') >> LOG: server process (PID 13888) was terminated by signal 6: Aborted >> LOG: terminating any other active server processes >> WARNING: terminating connection because of crash of another server process > Tom, does postgres generate abort signal? Or would this be an external signal? Yeah, we call abort() after reporting a PANIC error, so as to get a core dump. regards, tom lane