Re: Rows missing from table despite FK constraint

On 7 Jan 2010, at 11:12, Konrad Garus wrote:

> Hello,
>
> We use PG 8.3. We use pg_dump and pg_restore overnight to create
> ...

You seem to have lost the actual data, not the index entries pointing to it, or a sequential scan (eg. pg_dump) would still have found your rows.

> Do you have any ideas on how it could possibly happen? What research
> could help find the root cause and fix the database?

What kind of file-system is the affected table on? - and while we're at it, what OS/Distribution and version? Is your data on some kind of RAID array? If so, what type (hardware/software, RAID type)?

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.

Bad memory is another typical cause of corruption, but not likely in your case.

And of course there could be a bug in PG; are you up to date on the minor versions?

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.

!DSPAM:737,4b47130010732637119309!