Re: pg_clog woes with 7.3.2 - Episode 2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_clog woes with 7.3.2 - Episode 2
Date
Msg-id 18323.1050506542@sss.pgh.pa.us
Whole thread Raw
In response to pg_clog woes with 7.3.2 - Episode 2  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-hackers
"Dave Page" <dpage@vale-housing.co.uk> writes:
> One initdb and reload later (it's a new system, the old is still running
> OK), and the error comes back again, only this time Tom finds the
> corruption is in a couple of pages. Memtest86 again shows no errors, but
> eventually badblocks did, but only when I used a destructive read write
> test.

> So, the disk goes back to Seagate, and is replaced with another
> identical one, and a similar problem reoccurs (logs below) :-(. I
> haven't run badblocks yet as it takes a fair while, but wanted to find
> out if anyone thought this could be an OS issue or something else.
> Previously I've been using the 2.4.19 Linux kernel, however this machine
> is 2.4.20 (Slackware Linux 9). The SCSI adaptor is an Adaptec 29160, and
> the disks are 34Gb Seagate Cheetah X15's.

How annoying.  My bet would be on the SCSI adaptor being the problem.
Or you could have a cabling issue --- SCSI is not as bad as IDE, but
it's still finicky, esp w.r.t. termination.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] First draft of new FE/BE protocol spec posted for comments
Next
From: Rob Butler
Date:
Subject: Re: cross-db queries (was Are we losing momentum?)