Re: Rows missing from table despite FK constraint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Konrad Garus <konrad(dot)garus(at)gmail(dot)com>
Cc: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, pgsql-general(at)postgresql(dot)org
Subject: Re: Rows missing from table despite FK constraint
Date: 2010-01-08 13:55:01
Message-ID: 4533.1262958901@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Konrad Garus <konrad(dot)garus(at)gmail(dot)com> writes:
> 2010/1/8 Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>:
>> I get the impression the data you lost and the data around it hasn't been written to in a long time; it wouldn't surprise me if your problem would have been caused by a bad sector on a disk, but that depends on how reliable your storage is set up to be.

> You are correct about the first point. It's a write-only table with
> thousands of inserts daily, and the lost rows were written 7 months
> ago.

Do you know that the rows disappeared recently?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2010-01-08 13:57:32 Re: Server name in psql prompt
Previous Message Filip Rembiałkowski 2010-01-08 13:48:23 Re: [GENERAL] pg.dropped