REINDEX "is not a btree"

REINDEX "is not a btree"

am 03.07.2009 16:24:45 von Vanessa Lopez

--Apple-Mail-19--111569927
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

Hello!

I got into a situation I don't know how the get out ..
First, I could not access to my biggest database in postgre anymore
because it suddenly gave the error (after long time working with no
problems)

>>>> ERROR: could not open relation 1663/392281/530087: No such file
>>>> or directory

After trying with several backups with no success, I did a vacuum and
I tried to REINDEX the database (in the standalone back-end).

Unfortunately the process was interrupted, and when I tried to start
postgres again I got the error:

'SQL select * from pg_database order by datname failed : index
"pg_authid_rolname_index" is not a btree"

I connected as a standalone mode again to REINDEX the database:
pg_ctl stop -D /data/pgsql/data
/usr/bin/postgres -D /data/pgsql/data dbpedia_infoboxes
REINDEX database dbpedia_infoboxes

The REINDEX was successful this time but I was still having the "is
not a btree" problem, so I tried again with:
pg_ctl stop -D /data/pgsql/data
/usr/bin/postgres -D /data/pgsql/data dbpedia_infoboxes
REINDEX SYSTEM dbpedia_infoboxes

The process finish, but I was still having the "is not a btree" problem.
And even more, now not only the same problem "is not a btree" is still
there, but also I can not connect in the standalone mode anymore:

bash-3.2$ /usr/bin/postgres -D /data/pgsql/data dbpedia_infoboxes
FATAL: index "pg_database_datname_index" is not a btree
(I tried with other databases as well and the same)

I don't know much about postgre, I have no clue what else I can do.
Please, please any help is very very much appreciated I have lots of
databases and months of work in postgre (also lots of backups for the
data in /data) but I don't know how to make postgres to work again.
(it is working in unix red hat).

Millions of thanks in advance, solving this problem is crucial for me.
Vanessa
--Apple-Mail-19--111569927
Content-Type: text/html;
charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

-webkit-line-break: after-white-space; ">Hello!


I got into =
a situation I don't know how the get out ..
First, I could not =
access to my biggest database in postgre anymore because it suddenly =
gave the error (after long time working with no =
problems)

type=3D"cite">
ERROR: =
could not open relation 1663/392281/530087: No such file or =
directory

v>After trying with several backups with no success, I did a vacuum and =
I tried to REINDEX the database (in the standalone =
back-end). 

Unfortunately the process was =
interrupted, and when I tried to start postgres again  I got the =
error:

'SQL select * from pg_database order by =
datname failed : index "pg_authid_rolname_index" is not a =
btree"

I connected as a standalone mode again =
to REINDEX the database: 
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal =
normal normal 12px/normal Helvetica; ">pg_ctl stop -D =
/data/pgsql/data
margin-bottom: 0px; margin-left: 0px; font: normal normal normal =
15px/normal Helvetica; ">/usr/bin/postgres -D /data/pgsql/data =
dbpedia_infoboxes  
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal =
normal normal 15px/normal Helvetica; ">REINDEX database =
dbpedia_infoboxes
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal =
normal normal 12px/normal Helvetica; ">
0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: =
normal normal normal 15px/normal Helvetica; ">The REINDEX was successful =
this time but I was still having the "is not a btree" problem, so I =
tried again with: 
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal =
normal normal 15px/normal Helvetica; "> style=3D"font-size: medium; ">
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal =
normal normal 12px/normal Helvetica; ">pg_ctl stop -D =
/data/pgsql/data
margin-bottom: 0px; margin-left: 0px; font: normal normal normal =
15px/normal Helvetica; ">/usr/bin/postgres -D /data/pgsql/data =
dbpedia_infoboxes  
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal =
normal normal 15px/normal Helvetica; ">REINDEX SYSTEM =
dbpedia_infoboxes

The =
process finish, but I was still having the "is not a btree" =
problem. 
And even more, now not only the same problem =
"is not a btree" is still there, but also I can not connect in the =
standalone mode anymore: 

bash-3.2$ =
/usr/bin/postgres -D /data/pgsql/data =
dbpedia_infoboxes
FATAL:  index =
"pg_database_datname_index" is not a btree
(I tried with =
other databases as well and the same)

I don't =
know much about postgre, I have no clue what else I can =
do. 
Please, please any help is very very much =
appreciated I have lots of databases and months of work in postgre (also =
lots of backups for the data in /data) but I don't know how to make =
postgres to work again.
 (it is working in unix red =
hat).

Millions of thanks in advance, =
solving this problem is crucial for =
me.
Vanessa
=

--Apple-Mail-19--111569927--