Thread: Corrupted Database

Hi!

We have the same problem like this user:
http://archives.postgresql.org/pgsql-bugs/2002-12/msg00103.php

But our System is a very stable SuSE Linux 8.1 box with Postgres 7.3.2. The
problem is, that nearly once a week the database gets corrupted. Typical
problems are failing pg_dumps of certain tables. When I look into this table
there are entries with oid=3D0 or two entries with the same oid.

Often there are overlong tuples with a lot of garbage in it. When I'm lucky=
 I
can delete them and everything works fine for the next few days.

The log says for example

PANIC:  open of /usr/local/pgsql/data/pg_clog/0419 failed: No such file or
directory

or

ERROR:  MemoryContextAlloc: invalid request size 4294967277

We have the same installations on other computers and have no problem at al=
l.
If it is a hardware problem as Mr. Tom Lane suggests how can I track it dow=
n?

Thanks for your help!

wiwo

--
Digital Concepts
Ideen-Konzepte-L=F6sungen
Wolfgang.Winkler@digital-concepts.com
www.digital-concepts.com
Mobil: +43 699 / 20 88 13 51
B=FCro: +43 732 / 77 27 27

-------------------------------------------------------