From: | Konrad Garus <konrad(dot)garus(at)gmail(dot)com> |
---|---|
To: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Rows missing from table despite FK constraint |
Date: | 2010-01-08 11:43:48 |
Message-ID: | 6645f6441001080343l23a95320l104ddbe556e34dce@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/1/8 Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>:
> 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.
I agree.
> 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)?
It's ext3 on a hardware RAID1. The array is in perfect condition,
according to its diag tool. The OS is Ubuntu 8.04. The exact PG
version is 8.3.8.
> 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.
--
Konrad Garus
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2010-01-08 11:46:59 | Re: Server name in psql prompt |
Previous Message | Glyn Astill | 2010-01-08 11:30:50 | Re: Server name in psql prompt |