From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Failed to re-find parent key |
Date: | 2005-03-22 14:54:59 |
Message-ID: | 9325.1111503299@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> What does the error message
> failed to re-find parent key in "tablename_pkey"
> mean? This happens reproducibly during VACUUM on a certain table.
If it happens during vacuum (not vacuum full) then it must be coming
from _bt_pagedel, and it means that _bt_pagedel could not find the
parent-level btree entry for the page it wants to remove from the index.
> Would REINDEX fix it? Anything else we should check?
REINDEX would fix it, but it would be interesting to find out what the
actual cause is. I think we've seen one or two similar reports
previously in 7.4.*, but there's never been enough info to track
it down. Any chance of going in with a debugger, or capturing a
tarball image of the database for someone else to look at?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-03-22 14:57:13 | Re: Failed to re-find parent key |
Previous Message | Peter Eisentraut | 2005-03-22 11:31:55 | Failed to re-find parent key |