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

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 (view raw or flat)
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

pgsql-admin by date

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

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