Re: Memory/Performance issue: server closed the connection

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Pieter-Jan Savat <pieterjan(dot)savat(at)barclab(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Memory/Performance issue: server closed the connection
Date: 2005-10-27 02:47:28
Message-ID: 20051027024728.GA32007@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Oct 12, 2005 at 11:18:02 +0200,
Pieter-Jan Savat <pieterjan(dot)savat(at)barclab(dot)com> wrote:
>
>
> Tom Lane wrote:
>
> >Pieter-Jan Savat <pieterjan(dot)savat(at)barclab(dot)com> writes:
> >
> >
> >>2005-10-11 17:22:28 CEST (postgres(at)TheCore) [2005-10-11 17:08:49 CEST]
> >>PANIC: right sibling's left-link doesn't match
> >>
> >>
> >
> >You've got a corrupt btree index. Try reindexing that table.
> >
> > regards, tom lane
> >
> >
> You were right, thanks.
>
> But of course this is not something I would like to see in my production
> database. Do you have
> an idea what could be the cause of my corrupt index?

This is probably hardware related. In particular using IDE drives with
write caching turned on can cause problems if your server loses power.
Not using ECC memory is another source of potential trouble.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dario 2005-10-27 21:45:36 Re: excluding a table from pg_dump
Previous Message acemeicn 2005-10-27 02:02:59 Re: a error about PostgreSQL7.3.4's Log setting