Re: 8.4.0 data loss / HOT-related bug - Mailing list pgsql-bugs

From Greg Stark
Subject Re: 8.4.0 data loss / HOT-related bug
Date
Msg-id 407d949e0908210955n7deb2946p3257ab21e30e0054@mail.gmail.com
Whole thread Raw
In response to Re: 8.4.0 data loss / HOT-related bug  (Radoslaw Zielinski <radek@pld-linux.org>)
Responses Re: 8.4.0 data loss / HOT-related bug
List pgsql-bugs
2009/8/21 Radoslaw Zielinski <radek@pld-linux.org>:
> Greg Stark <gsstark@mit.edu> [2009-08-21 18:03]:
>> On Fri, Aug 21, 2009 at 4:04 PM, Radoslaw Zielinski<radek@pld-linux.org>=
 wrote:
>>> This particular row currently has last_modified=3D"2009-08-11", but tab=
le_log
>>> says it has been updated on "2009-08-12" -- so, data loss.
>
>> These are all very low transaction ids. you say it was a week of
>> production before this happened?
>
> Upgraded around:
> =A0$ rpm -q postgresql --qf '%{INSTALLTIME}' | xargs perl -le 'print~~loc=
altime shift'
> =A0Fri Aug =A07 10:06:44 2009

Is this, perchance, new hardware? Did you test the memory in it?

Do you have other records that have "disappeared"?

--=20
greg
http://mit.edu/~gsstark/resume.pdf

pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????
Next
From: Radoslaw Zielinski
Date:
Subject: Re: 8.4.0 data loss / HOT-related bug