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"

Thanks before.

Note : EP07 is name of tables.


--
"He who is quick to become angry will commit folly, and a crafty man is hated"


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

"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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org