ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target - Mailing list pgsql-bugs

From John Parnefjord
Subject ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target
Date
Msg-id 5EAE1B1C2C2FF94C8A9ABE2781842D5D1286CA9F3C@cbs-exch.kib.local
Whole thread Raw
Responses Re: ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target
List pgsql-bugs
Hi!

Hope anyone can shed some light on this. I was struck by the following erro=
r in the slony log but I believe it's not a slony error, rather that slony =
triggers an error in PostgreSQL. The error message is:

cleanupThread: vacuum  analyze sl_seqlog; - ERROR:  failed to re-find paren=
t key in "sl_seqlog_idx" for deletion target

I've tried to find some posts about it and I could only find one post where=
 Tom states that reindexing should do the trick, but there is no answer tha=
t reindexing did solve the case. The post is here:
http://archives.postgresql.org/pgsql-bugs/2007-08/msg00035.php

Well, it is supposed to have been fixed to version 8.2, but it's a PostgreS=
QL 8.2.4 x86_64 server running on Debian that triggers the error.

Thank in advance!
// John

pgsql-bugs by date:

Previous
From: "Boldinov"
Date:
Subject: BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument
Next
From: Zdenek Kotala
Date:
Subject: Re: BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument