Thread: Corrupt database?

Corrupt database?

From
David Welton
Date:
[ please CC replies to me. ]

Hi, I've been experiencing some 'interesting' behaviour, and I'd like
to check and see if it's anything anyone else has dealt with.

I am running Postgres 6.3.2 on an IRIX 6.2 box, interfacing with PHP.

The errors seem a bit odd, and not related to anything I have been
directly doing to the db, so I'm at a loss as to what they could be
indicitave of.. file corruption?

I'll list as many of them as I can get it to spit out:

Warning: PostgresSQL query failed: ERROR: init_fcache: Cache lookup
failed for procedure 1070 in ....
QUERY: select fullname, type, id, ord from models where shortname =
'eclc' order by ord

This query works fine from psql.

Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId:
user "htpmit1" is not in "pg_shadow" in .....

Even though:

 select * from pg_shadow;
usename
|usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd|valuntil
--------+--------+-----------+--------+--------+---------+------+----------------------------
....
htpmit1 |     101|f          |t       |f       |t        |      |
....

and it works just fine next time I run the same page..

Warning: PostgresSQL query failed: ERROR: type id lookup of 705 failed
in ...

QUERY: select fullname, type, id, ord from models where shortname =
'eclc' order by ord

Another wierd one...

Warning: Unable to connect to PostgresSQL server: ERROR: cannot open
segment 1 of relation pg_class_relname in ...

I also got one about pg_type_oid_index not being a btree.

So.. I'm quite confused, and any help would be most appreciated it.

Thanks,
--
David Welton                          http://www.efn.org/~davidw

    Debian GNU/Linux - www.debian.org