Corrupt database?
От | David Welton |
---|---|
Тема | Corrupt database? |
Дата | |
Msg-id | 19981005112928.B6685@gate.cks.com обсуждение исходный текст |
Список | pgsql-general |
[ 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
В списке pgsql-general по дате отправления: