From: | strk <strk(at)keybit(dot)net> |
---|---|
To: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: ERROR: Index pg_toast_8443892_index is not a btree |
Date: | 2003-12-08 16:23:03 |
Message-ID: | 20031208172303.A57240@freek.keybit.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
JanWieck wrote:
> strk wrote:
>
> > I get the following error when vacuuming a db or inserting
> > a big value in a column of a toastable datatype (GEOMETRY).
> >
> > ERROR: Index pg_toast_8443892_index is not a btree
> >
> > My last action has been killing a psql that was getting
> > mad about receiving too much input and beeping as hell
> > (readline issue ?).
>
> You must have killed a lot more than your psql frontend to get that as a
> result.
really... I hit ^C at the psql terminal and
kill -9 <psql_pid>
The only other reason I can thing about is the data type text
input function screwing pg internal pointers...
>
> >
> > After that, I put the insert query I was trying to feed to
> > psql in a file and sourced it... Bump! that error appeared.
> >
> > psql:B:477: ERROR: Index pg_toast_8443892_index is not a btree
> >
> > Line 477 is EOF...
> >
> > Vacuum does not solve this (as you can see in the first error message)
> >
> > Do you have any hint about how to fix this ?
>
> Try "reindex table <tablename>". If you really only lost that btree
> index, that should do.
gis=# reindex table test; -- this is the table I was trying to insert into
WARNING: table "test" wasn't reindexed
REINDEX
gis=# reindex table pg_toast_8443892; -- this was an assuption I made
ERROR: Relation "pg_toast_8443892" does not exist
gis=# vacuum;
ERROR: Index pg_toast_8443892_index is not a btree
gis=#
Where could this pg_toast_8443892_index reference be found ?
--strk;
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-12-08 16:29:28 | Re: CVS HEAD compile failure |
Previous Message | Jan Wieck | 2003-12-08 16:03:09 | Re: ERROR: Index pg_toast_8443892_index is not a btree |