Re: 8.4.0 data loss / HOT-related bug

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: 8.4.0 data loss / HOT-related bug
Дата
Msg-id 407d949e0908210955n7deb2946p3257ab21e30e0054@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 8.4.0 data loss / HOT-related bug  (Radoslaw Zielinski <radek@pld-linux.org>)
Ответы Re: 8.4.0 data loss / HOT-related bug  (Radoslaw Zielinski <radek@pld-linux.org>)
Список 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 по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????
Следующее
От: Radoslaw Zielinski
Дата:
Сообщение: Re: 8.4.0 data loss / HOT-related bug