Re: Lost rows/data corruption? - Mailing list pgsql-general

From Marco Colombo
Subject Re: Lost rows/data corruption?
Date
Msg-id Pine.LNX.4.61.0502151458430.18326@Megathlon.ESI
Whole thread Raw
In response to Re: Lost rows/data corruption?  ("Andrew Hall" <temp02@bluereef.com.au>)
List pgsql-general
On Tue, 15 Feb 2005, Andrew Hall wrote:

>
>
>>> It sounds like a mess, all right.  Do you have a procedure to follow to
>>> replicate this havoc?  Are you sure there's not a hardware problem
>>> underlying it all?
>>>
>>> regards, tom lane
>>>
>
> We haven't been able to isolate what causes it but it's unlikely to be
> hardware as it happens on quite a few of our customer's boxes. We also use
> XFS on linux 2.6 as a file system, so the FS should be fairly tolerant to
> power-outages. Any ideas as to how I might go about isolating this? Have you
> heard any other reports of this kind and suggested remedies?

Are you running with fsync = off? and did the hosts experience any
power-outage recently?

.TM.
--
       ____/  ____/   /
      /      /       /            Marco Colombo
     ___/  ___  /   /              Technical Manager
    /          /   /             ESI s.r.l.
  _____/ _____/  _/               Colombo@ESI.it

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Trading off large objects (arrays, large strings,
Next
From: Ruben Oliveira
Date:
Subject: problem with dots in order by