X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 00F1D9FB1C7 for ; Wed, 5 Jul 2006 17:49:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 13691-09 for ; Wed, 5 Jul 2006 17:49:28 -0300 (ADT) X-Greylist: delayed 00:30:12.971318 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 40DFE9FB1C1 for ; Wed, 5 Jul 2006 17:49:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from chene.DIT.UMontreal.CA (chene.DIT.UMontreal.CA [132.204.246.20]) by svr4.postgresql.org (Postfix) with ESMTP id 277D95AF024 for ; Wed, 5 Jul 2006 20:19:10 +0000 (GMT) Received: from mail.lexum.umontreal.ca (gw-mail.LEXUM.UMontreal.CA [132.204.136.52]) by chene.DIT.UMontreal.CA (8.13.7/8.13.7) with ESMTP id k65KIt3N013251 for ; Wed, 5 Jul 2006 16:18:55 -0400 Received: from [192.168.4.171] ([::ffff:192.168.4.171]) (AUTH: PLAIN mederyf, SSL: TLSv1/SSLv3,256bits,AES256-SHA) by mail.lexum.umontreal.ca with esmtp; Wed, 05 Jul 2006 16:12:39 -0400 id 00003EF5.44AC1D37.000074C5 Message-ID: <44AC1EAE.9030305@lexum.umontreal.ca> Date: Wed, 05 Jul 2006 16:18:54 -0400 From: FM User-Agent: Thunderbird 1.5.0.4 (X11/20060516) MIME-Version: 1.0 To: Mailing List Postgres-Admin Subject: corruption since 7.4.13 update ? Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-NAI-Spam-Score: 0 X-NAI-Spam-Rules: 0 Rules triggered X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/29 X-Sequence-Number: 22275 Hello, I'e got a very strange (scary) problem. Look at that : itu_test-# \d ERROR: cache lookup failed for relation 1024 itu_test=# \q [user@varese ~]$ psql -h pisa itu_test itu_test=# \d ERROR: cache lookup failed for relation 1024 itu_test=# select * from zones; zone_id | code | region_id ---------+------+----------- 1 | can | 1 (1 row) itu_test=# \d zones; ERROR: cache lookup failed for relation 1024 itu_test=# drop table zones cascade; NOTICE: drop cascades to constraint fk894f2383638e21c5 on table zones_localized NOTICE: drop cascades to constraint fk2f1483ad638e21c5 on table resources_zones NOTICE: drop cascades to constraint fk6ca02e89638e21c5 on table regulator_zones NOTICE: drop cascades to constraint fkfe5f0292638e21c5 on table regulators DROP TABLE itu_test=# \d ERROR: cache lookup failed for relation 1024 itu_test=# VACUUM ANALYZE; ERROR: could not open segment 1 of relation "pg_class_oid_index" (target block 1702494308): No such file or directory itu_test=# REINDEX DATABASE itu_test; NOTICE: table "pg_class" was reindexed (...) NOTICE: table "pg_language" was reindexed ERROR: could not read block 81235 of relation "pg_largeobject": Input/output error itu_test=# \d ERROR: cache lookup failed for relation 1024 itu_test=# reindex table pg_class; REINDEX itu_test=# VACUUM ANALYZE; WARNING: relation "pg_class" TID 12638/1: OID is invalid (...) WARNING: relation "pg_class" TID 12638/24: OID is invalid ERROR: cannot compare arrays of different element types itu_test=# \d List of relations Schema | Name | Type | Owner --------+------------------------------+----------+---------- public | categories | table | soft_itu (...) public | zones_localized | table | soft_itu (51 rows)