| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg 8.4 crashing. |
| Date: | 2010-09-24 02:57:09 |
| Message-ID: | AANLkTi=p=2u5L-62LvOGfgR0oqjkUhTF=92e2p2QW=pn@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 23, 2010 at 2:17 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
>> I've got a problem with pg 8.4.4 crashing with a sig 6 abort due to a
>> panic on failing to add a right sibling in an index. Log output:
>
>> PANIC: failed to add item to the right sibling in index "logged_in_uid"
>> STATEMENT: INSERT INTO logged_in ...
>
> If you can apply this patch:
> http://archives.postgresql.org/pgsql-committers/2010-08/msg00365.php
> it should tell you which index page is causing the problem. Then
> please dump that page with pg_filedump and send it in.
Patch applied. This crash happens on average about once a day.
Happened twice yesterday, but hasn't happened today. I'll report back
when / if it does it again.
--
To understand recursion, one must first understand recursion.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-09-24 04:01:34 | Re: Nested literal parsing rules? |
| Previous Message | Maciek Sakrejda | 2010-09-24 01:24:18 | Re: Nested literal parsing rules? |