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

Поиск
Список
Период
Сортировка
От John Parnefjord
Тема ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target
Дата
Msg-id 5EAE1B1C2C2FF94C8A9ABE2781842D5D1286CA9F3C@cbs-exch.kib.local
обсуждение исходный текст
Ответы Re: ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target  (Magnus Hagander <magnus@hagander.net>)
Список 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 по дате отправления:

Предыдущее
От: "Boldinov"
Дата:
Сообщение: BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument
Следующее
От: Zdenek Kotala
Дата:
Сообщение: Re: BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument