pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: failed to re-find parent key in "pk_ep07"
5+ messages / 4 participants
[nested] [flat]
* ERROR: failed to re-find parent key in "pk_ep07"
@ 2007-10-25 02:31 Otniel Michael <otmic_ie@yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Otniel Michael @ 2007-10-25 02:31 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ERROR: failed to re-find parent key in "pk_ep07"
@ 2007-10-25 04:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: Otniel Michael <otmic_ie@yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2007-10-25 04:45 UTC (permalink / raw)
To: Otniel Michael <otmic_ie@yahoo.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ERROR: failed to re-find parent key in "pk_ep07"
@ 2007-10-25 08:26 Otniel Michael <otmic_ie@yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Otniel Michael @ 2007-10-25 08:26 UTC (permalink / raw)
To: pgsql-sql
Note: forwarded message attached.
--
"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
OC. I will try to upgrade the postgres. What version that can fix this problem? Postgres 8.2.5? Postgres 8.1?
Now, i use postgres 8.0.3, what effect when i upgrade the postgres version?
I heared that i should check my sql? In postgres 8.0.3 show as warning, in postgres 8.1 as error?
Thanks.
Tom Lane <tgl@sss.pgh.pa.us> wrote: Otniel Michael 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
--
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ERROR: failed to re-find parent key in "pk_ep07"
@ 2007-10-25 08:42 Gregory Stark <stark@enterprisedb.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Gregory Stark @ 2007-10-25 08:42 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Otniel Michael <otmic_ie@yahoo.com>; pgsql-sql
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ERROR: failed to re-find parent key in "pk_ep07"
@ 2007-10-25 08:50 Filip Rembiałkowski <plk.zuber@gmail.com>
parent: Otniel Michael <otmic_ie@yahoo.com>
0 siblings, 0 replies; 5+ messages in thread
From: Filip Rembiałkowski @ 2007-10-25 08:50 UTC (permalink / raw)
To: Otniel Michael <otmic_ie@yahoo.com>; +Cc: pgsql-sql
2007/10/25, Otniel Michael <otmic_ie@yahoo.com>:
> OC. I will try to upgrade the postgres. What version that can fix this
> problem? Postgres 8.2.5? Postgres 8.1?
>
> Now, i use postgres 8.0.3, what effect when i upgrade the postgres version?
> I heared that i should check my sql? In postgres 8.0.3 show as warning, in
> postgres 8.1 as error?
>
If you can afford some testing time, try with the very latest stable
version (8.2.5 at the moment).
If you can't, just take the last patchlevel from 8.0.x series - the
upgrade is seamless
(just backup - stop the server - replace binaries - start servar )
Detrailed upgrade procedures are described either in manual or
somewhere on the net.
cheers
--
Filip Rembiałkowski
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-10-25 08:50 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-25 02:31 ERROR: failed to re-find parent key in "pk_ep07" Otniel Michael <otmic_ie@yahoo.com>
2007-10-25 04:45 ` Re: ERROR: failed to re-find parent key in "pk_ep07" Tom Lane <tgl@sss.pgh.pa.us>
2007-10-25 08:42 ` Re: ERROR: failed to re-find parent key in "pk_ep07" Gregory Stark <stark@enterprisedb.com>
2007-10-25 08:26 Re: ERROR: failed to re-find parent key in "pk_ep07" Otniel Michael <otmic_ie@yahoo.com>
2007-10-25 08:50 ` Re: ERROR: failed to re-find parent key in "pk_ep07" Filip Rembiałkowski <plk.zuber@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox