Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id AB4C69FB24D for ; Tue, 10 Jul 2007 12:03:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 31353-03-3 for ; Tue, 10 Jul 2007 12:03:34 -0300 (ADT) X-Greylist: delayed 00:59:59.682183 by SQLgrey-1.7.4 Received: from mmp1.nems.noaa.gov (mmp1.nems.noaa.gov [140.90.121.156]) by postgresql.org (Postfix) with ESMTP id DB16F9FB2CF for ; Tue, 10 Jul 2007 12:03:33 -0300 (ADT) Received: from [204.227.103.140] by mmp1.nems.noaa.gov (Sun Java System Messaging Server 6.2-2.05 (built Apr 28 2005)) with ESMTPSA id <0JKY00ERZV1PYM40@mmp1.nems.noaa.gov> for pgsql-admin@postgresql.org; Tue, 10 Jul 2007 10:03:28 -0400 (EDT) Date: Tue, 10 Jul 2007 09:03:25 -0500 From: Juliann Meyer Subject: vacuumdb problem v7.4.8 To: pgsql-admin@postgresql.org Message-id: <469391AD.3030206@noaa.gov> Organization: Missouri Basin River Forecast Center MIME-version: 1.0 Content-type: multipart/mixed; boundary="Boundary_(ID_FHwir3n+Bl3Sg7w+XouUHA)" User-Agent: Thunderbird 2.0.0.4 (Windows/20070604) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/85 X-Sequence-Number: 26066 This is a multi-part message in MIME format. --Boundary_(ID_FHwir3n+Bl3Sg7w+XouUHA) Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT Have 14 systems scattered across the country where... hardware is identical, all run linux OS RHE4.0 with postgresql v7.4.8. The hardware is about 4 years old and is scheduled for replacement sometime next year. The database structure is identical on each system, the difference is in the data that is stored within each database, as it varies from site to site and the amount of data varies as well, so no two databases are exactly the same size or contains the same data. Every system runs a "vacuum analyze" 2 to 3 times per day on this database and a nightly cron job does a pg_dump of the database. One site is getting errors with the "vacuum analyze" so it basically fails and similar error then occurs when the nightly backups is run. The error in the vacuum's logfile looks like this: INFO: vacuuming "public.pecrsep" vacuumdb: vacuuming of database "adb_ob72orn" failed: ERROR: could not read block 18658 of relation "pecrsep_time_ind": Input/output error The Elec. Technicians at first thought it was an issue with one of the hard drives, but a very thorough check of the hardware has eliminated this possibility. So far they have tried re-installing everything as if its the first time from scratch on the existing hardware with no success. As a last resort, the hardware was replaced with a spare (similar age) and everything installed from scratch. The database and related apps ran fine for about a week and then the same type of error occurred again with vacuumdb and pg_dump and it appears to be occurring with the same database table. At this point, we don't know what else to try, and the problem hasn't occurred anywhere else (fortunately). Does anyone have any idea what this error means and how to fix it. Any suggestions, ideas, etc would be greatly appreciated. Julie Meyer --Boundary_(ID_FHwir3n+Bl3Sg7w+XouUHA) Content-type: text/x-vcard; charset=utf-8; name=julie.meyer.vcf Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=julie.meyer.vcf begin:vcard fn:A. Juliann Meyer org:National Weather Service;Missouri Basin River Forecast Center adr;dom:;;;Pleasant Hill;MO;64080 email;internet:julie.meyer@noaa.gov title:Sr. Hydrologist - Data Systems x-mozilla-html:FALSE version:2.1 end:vcard --Boundary_(ID_FHwir3n+Bl3Sg7w+XouUHA)--