Thursday, September 25, 2008

Re: [ADMIN] missing chunk number 0 for toast value

"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> On Thu, Sep 25, 2008 at 10:09 AM, BJ Taylor
> <btaylor@propertysolutions.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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

No comments: