[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] ERROR:  failed to re-find parent key in "sl_seqlog_idx"
From:       John Parnefjord <John.Parnefjord () ki ! se>
Date:       2008-04-22 14:53:47
Message-ID: 5EAE1B1C2C2FF94C8A9ABE2781842D5D1286CAA015 () cbs-exch ! kib ! local
[Download RAW message or body]

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@postgresql.org [mailto:pgsql-bugs-
> owner@postgresql.org] On Behalf Of Magnus Hagander
> Sent: den 22 april 2008 13:58
> To: John Parnefjord
> Cc: pgsql-bugs@postgresql.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[prev in list] [next in list] [prev in thread] [next in thread]