Re: Row data corruption under 7.3.5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc Mitchell" <marcm(at)eisolution(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Row data corruption under 7.3.5
Date: 2004-03-01 20:05:37
Message-ID: 8337.1078171537@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Marc Mitchell" <marcm(at)eisolution(dot)com> writes:
> In each case, by examining the copy table output up to the point where
> it errors out, a single row could be identified that contained corrupted
> char/varchar values but could be queried using primary key or numeric
> lookups. We've been able to work around the issue by deleting the row
> and manually re-inserting it based on values determined from a previous
> backup. Note that in each case, it has been determined that the corrupt
> row existed without a problem earlier as it could be found in old
> backups. Thus the rows seem to get into the table ok but got wacked at
> some future point in time.

> Any ideas on what's causing this?

Hardware problems possibly? You might try running memtest86 or some
such.

It would be good to take note of the exact bit pattern of the
corruption, if you can match up correct and corrupted versions of the
rows.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Louie Kwan 2004-03-01 21:09:24 SYSDATE in PostgreSQL !?
Previous Message Peter Eisentraut 2004-03-01 18:40:38 Re: PostgreSQL and phppgadmin woody backports