Re: [GENERAL] Possible data corruption with Postgres 7.4.8

2006-03-13 Thread Eric B. Ridge
On Mar 13, 2006, at 11:12 PM, Tom Lane wrote: The relation-extension race condition could explain recently-added tuples simply disappearing, though if it happened in more than one table you'd have to assume that the race condition window got hit more than once. The slru race condition is eve

Re: [GENERAL] Possible data corruption with Postgres 7.4.8

2006-03-13 Thread Tom Lane
"Eric B. Ridge" <[EMAIL PROTECTED]> writes: > Does anyone here have any kind of explanation other than bad hardware? Well, there are several data-corruption bugs fixed between 7.4.8 and 7.4.12, though whether any of them explains your symptoms is difficult to say: 2005-11-02 19:23 tgl *

[GENERAL] Possible data corruption with Postgres 7.4.8

2006-03-13 Thread Eric B. Ridge
First off, let me make clear that I blame the strange data corruption problem we encountered today on our hardware raid controller -- some versions of its firmware are known-to-be-buggy and cause the raid set to "drop" off, and we've encountered this problem in the past on this particular s