[ 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