Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 3EC03B5D80A for ; Mon, 25 Jul 2011 12:00:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 76750-09 for ; Mon, 25 Jul 2011 15:00:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenhts1.nrc.ca (nrccenhts1.nrc.ca [132.246.15.88]) by mail.postgresql.org (Postfix) with ESMTP id 62180B5D803 for ; Mon, 25 Jul 2011 12:00:52 -0300 (ADT) Received: from NRCWSTHCM1.NRC.CA (132.246.216.66) by nrccenhts1.nrc.ca (132.246.15.88) with Microsoft SMTP Server (TLS) id 8.1.436.0; Mon, 25 Jul 2011 11:00:49 -0400 Received: from [132.246.194.17] (132.246.216.202) by WSTMAIL.NRC.CA (132.246.216.66) with Microsoft SMTP Server (TLS) id 8.1.436.0; Mon, 25 Jul 2011 08:00:48 -0700 Message-ID: <4E2D8520.1020203@nrc-cnrc.gc.ca> Date: Mon, 25 Jul 2011 08:00:48 -0700 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: PG 9.0.1 database errors Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201107/183 X-Sequence-Number: 37962 Hello Gurus, One of our Pg ver 9.0.1 on RHES 5-64 bits server crashed this weekend, we restarted the db and start seeing the following error, we can't see any disks error in OS error log related to this crashed, no software changes to the system so far I would like to get more info about the error and what's the workaround to fix the issue: ERROR: invalid byte sequence for encoding "UTF8": 0xff 2011-07-25 07:23:45 PDT[23250]:[2-1]STATEMENT: COPY irod.r_data_main (data_id, coll_id, data_name, data_repl_num, data_version, data_type_name, data_size, resc_group_name, resc_name, data_path, data_owner_name, data_owner_zone, data_is_dirty, data_status, data_checksum, data_expiry_ts, data_map_id, data_mode, r_comment, create_ts, modify_ts) TO stdout; 2011-07-25 07:26:05 PDT[31080]:[1-1]LOG: incomplete startup packet 2011-07-25 07:27:24 PDT[935]:[1-1]ERROR: invalid page header in block 5665176 of relation pg_tblspc/16390/PG_9.0_201008051/16393/16453 2011-07-25 07:27:24 PDT[935]:[2-1]CONTEXT: automatic vacuum of table "ICAT.irod.r_data_main" Thank you Isabella -- ----------------------------------------------------------- Isabella A. Ghiurea Isabella.Ghiurea@nrc-cnrc.gc.ca Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Institute of Astrophysics 5071 West Saanich Road, Victoria BC V9E 2E7, Canada Phone: 250 363-3446 fax: 250 363-0045