Re: Strange database corruption with PostgreSQL 7.4.x o

Hello Scott!

Thank you for the quick answer. I'll try to check our hardware which is a
Compaq DL380 G4 with a batteyr buffered write cache on our raid controller.
As the system is running stable at all i think it's not the cpu or memory.
At moment i tend more to a bad disk or SCSI controller but even with that i
don't get any message in my logs...
Any ideas how i could check the hardware?

Best regards,
Matthias

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Scott Marlowe
> Sent: Wednesday, September 20, 2006 2:56 PM
> To: Matthias(dot)Pitzl(at)izb(dot)de
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Strange database corruption with
> PostgreSQL 7.4.x on
>
>
> On Wed, 2006-09-20 at 14:34 +0200, Matthias(dot)Pitzl(at)izb(dot)de wrote:
> > Hello!
> >
> > We're running the latest release of PostgreSQL 7.4.13 on a
> Debian Sarge
> > machine. Postgres has been compiled by oureselves.
> > We have a pretty big database running on this machine, it
> has about 6.4 GB
> > approximately. One table contains about 55 million rows.
> > Into this table we insert about 500000 rows each day. Our
> problem is that
> > without any obvious reason the database gets corrupt. The
> messages we get
> > are:
> > invalid page header in block 437702 of relation "xxxx"
> > We already have tried out some other versions of 7.4. On
> another machine
> > running Debian Woody with PotgreSQL 7.4.10 we don't have
> any problems.
> > Kernels are 2.4.33 on the Sarge machine, 2.4.28 on the
> Woody machine. Both
> > are SMP kernels.
> > Does anyone of you perhaps have some hints what's going wrong here?
>
> Most likely causes in these cases tends to be, bad memory, bad hard
> drive, bad cpu, bad RAID / IDE / SCSI controller, loss of power when
> writing to IDE drives / RAID controllers with cache with no battery
> backup.
>
> I.e. check your hardware.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>