Skip site navigation (1) Skip section navigation (2)

Re: 8.4.0 data loss / HOT-related bug

From: Radoslaw Zielinski <radek(at)pld-linux(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Greg Stark <gsstark(at)mit(dot)edu>
Subject: Re: 8.4.0 data loss / HOT-related bug
Date: 2009-08-21 16:38:30
Message-ID: 20090821163830.GA2645@bzium (view raw or flat)
Thread:
Lists: pgsql-bugs
Greg Stark <gsstark(at)mit(dot)edu> [2009-08-21 18:03]:
> On Fri, Aug 21, 2009 at 4:04 PM, Radoslaw Zielinski<radek(at)pld-linux(dot)org> wrote:
>> This particular row currently has last_modified="2009-08-11", but table_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:
  $ rpm -q postgresql --qf '%{INSTALLTIME}' | xargs perl -le 'print~~localtime shift'
  Fri Aug  7 10:06:44 2009

The first mention of the error in the app's output:
  [info] *** Request 5532 (0.008/s) [7283] [Wed Aug 19 13:06:35 2009] ***

User has reported "disappearing rows" at 12 Aug 2009, 16:58.

> How did you migrate your data? Was it a normal pg_dump restore? Or did
> you do anything funny with slony or pg_migrate?

Plain regular dump/restore (from text dump).  There's no slony or
anything on this database except for table_log and the trigger to update
last_modified.

In case it might be relevant: locale C, encoding utf8.

-- 
Radosław Zieliński <radek(at)pld-linux(dot)org>

In response to

Responses

pgsql-bugs by date

Next:From: Radoslaw ZielinskiDate: 2009-08-21 16:40:44
Subject: Re: 8.4.0 data loss / HOT-related bug
Previous:From: Greg StarkDate: 2009-08-21 16:38:17
Subject: Re: 8.4.0 data loss / HOT-related bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group