| From: | Konrad Garus <konrad(dot)garus(at)gmail(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Rows missing from table despite FK constraint |
| Date: | 2010-01-07 13:31:47 |
| Message-ID: | 6645f6441001070531p2d8b6cdp9c5d2d78b864e565@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2010/1/7 Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>:
> If that's really the case, it sounds like curruption.
>
> Is there anything in the server logs?
I'm pretty sure it is corruption. With FK in place I don't see any
other way how it would be possible.
The log is too large to read through, but I haven't spotted anything
suspicious (searching by table name, grepping for error and vacuum,
quick scan from when the state was consistent until when it was not).
Also, reindex on the master table did not help.
Is there anything I could do on logs or the database that could help
diagnose the issue?
--
Konrad Garus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2010-01-07 13:47:42 | Re: Rows missing from table despite FK constraint |
| Previous Message | Albe Laurenz | 2010-01-07 13:23:49 | Re: Rows missing from table despite FK constraint |