Skip site navigation (1) Skip section navigation (2)

Re: missing chunk number 0 for toast value

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "BJ Taylor" <btaylor(at)propertysolutions(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: missing chunk number 0 for toast value
Date: 2008-09-25 19:34:35
Message-ID: 23096.1222371275@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Thu, Sep 25, 2008 at 10:09 AM, BJ Taylor
> <btaylor(at)propertysolutions(dot)com> 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

In response to

pgsql-admin by date

Next:From: Tena SakaiDate: 2008-09-25 19:42:53
Subject: postgres at reboot
Previous:From: Calvin HomDate: 2008-09-25 19:08:47
Subject: postgres at reboot

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group