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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: John Parnefjord <John(dot)Parnefjord(at)ki(dot)se>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target
Date: 2008-04-22 11:58:14
Message-ID: 20080422135814.419e580b@mha-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John Parnefjord 2008-04-22 14:53:47 Re: ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target
Previous Message John Parnefjord 2008-04-22 10:53:39 Re: ERROR: failed to re-find parent key in "sl_seqlog_idx" for deletion target