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

From Andrew Hall
Subject Re: Lost rows/data corruption?
Date
Msg-id 00b101c5131d$5a7259b0$5001010a@bluereef.local
Whole thread Raw
In response to Lost rows/data corruption?  ("Andrew Hall" <temp02@bluereef.com.au>)
Responses Re: Lost rows/data corruption?
Re: Lost rows/data corruption?
List pgsql-general

>> 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?


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: random record from small set
Next
From: Tom Lane
Date:
Subject: Re: Lost rows/data corruption?