Thread: ERROR: failed to re-find parent key in "pk_ep07"

ERROR: failed to re-find parent key in "pk_ep07"

From
Otniel Michael
Date:
When i was vacuum the database, the vacuum if failed. And I get this error. Any ideas an to fix this?<br /><br
/>          <span style="color: rgb(128, 128, 255); font-weight: bold;">ERROR:  failed to re-find parent key in
"pk_ep07"</span><br/><br />Thanks before.<br /><br />Note : EP07 is name of tables.<br /><br /><br /><div
style="text-align:center;"><span style="color: rgb(0, 128, 255); font-style: italic;">-- </span><br style="color:
rgb(0,128, 255); font-style: italic;" /><span style="color: rgb(0, 128, 255); font-style: italic;">"He who is quick to
becomeangry will commit folly, and a crafty man is hated" </span><br /></div><p>
__________________________________________________<br/>Do You Yahoo!?<br />Tired of spam? Yahoo! Mail has the best spam
protectionaround <br />http://mail.yahoo.com  

Re: ERROR: failed to re-find parent key in "pk_ep07"

From
Tom Lane
Date:
Otniel Michael <otmic_ie@yahoo.com> writes:
> When i was vacuum the database, the vacuum if failed. And I get this error. Any ideas an to fix this?
>            ERROR:  failed to re-find parent key in "pk_ep07"

Update to a newer PG version, possibly?  This symptom has been seen
before...
        regards, tom lane


Re: ERROR: failed to re-find parent key in "pk_ep07"

From
Gregory Stark
Date:
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Otniel Michael <otmic_ie@yahoo.com> writes:
>> When i was vacuum the database, the vacuum if failed. And I get this error. Any ideas an to fix this?
>>            ERROR:  failed to re-find parent key in "pk_ep07"
>
> Update to a newer PG version, possibly?  This symptom has been seen
> before...

It was fixed in these bug-fix releases: 7.4.15, 8.0.10, and 8.1.6 which were
released on August 1st of this year. There have actually been 3 to 4 more
bug-fix releases since those too.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com