ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target

From: John Parnefjord <John(dot)Parnefjord(at)ki(dot)se>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target
Date: 2008-04-22 06:53:07
Message-ID: 5EAE1B1C2C2FF94C8A9ABE2781842D5D1286CA9F3C@cbs-exch.kib.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi!

Hope anyone can shed some light on this. I was struck by the following error 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 parent 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 that 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 PostgreSQL 8.2.4 x86_64 server running on Debian that triggers the error.

Thank in advance!
// John

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Zdenek Kotala 2008-04-22 07:57:09 Re: BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument
Previous Message Boldinov 2008-04-22 04:54:35 BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument