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

Yikes! I already done a reindexing of the table as there where locks that were holding back some jobs that needed to finished. But in case the problem should appear again we will take a copy of the actual data file.

Anyway, the case must regarded as solved. Put shortly, reindex the table/index.

By the way thanks for all the effort you put into making PostgreSQL such a marvelous database manager!

// John

> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org [mailto:pgsql-bugs-
> owner(at)postgresql(dot)org] On Behalf Of Magnus Hagander
> Sent: den 22 april 2008 13:58
> To: John Parnefjord
> Cc: pgsql-bugs(at)postgresql(dot)org; Tom Lane
> Subject: Re: [BUGS] ERROR: failed to re-find parent key in
> "sl_seqlog_idx" for deletion target
>
> John Parnefjord wrote:
> > > Please copy out the files as requested in that email - I'm sure Tom
> > > is still interested in debugging it to find the issue. After that,
> > > try a REINDEX to see if it solves your problem.
> >
> > Ok, see the snippets below. I just cut them from the PgAdminIII
> > interface. Drop me a mail if you need more info.
>
> Ok, misunderstandment. What's needed are the actual data files, not the
> definition of the tables. That is, the files under $PGDATA that
> contains the table and it's indexes.
>
> Can't send those on-list, they're too large, but if you can put
> together a .tar.gz for someone to look at. Before you send it, we'll
> want to check with Tom that he's still interested in looking at it :-)
>
>
> > > And while you're at it, you guys should be at 8.2.7, not 8.2.4.. :-
> P
> >
> > Yes, you're right. But as we are trying out tsearch2 for full text
> > searching it might just as well be a good idea to go straight to 8.3
> > during the summer.
>
> Probably, yes.
>
>
> //Magnus
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs