From: Marc Mitchell <marcm@eisolution.com>
To: pgsql-admin@postgresql.org
Subject: Row data corruption under 7.3.5
Date: Mon, 1 Mar 2004 12:35:07 -0600
Message-ID: <004101c3ffbb$ebce29f0$7201050a@MarcM8500> (raw)
In-Reply-To: <Pine.LNX.4.44.0403011750590.25446-100000@emo.org.tr>
We are running a highly transaction-intensive application in the
following environment:
Postgres Version 7.3.5 built off the source tree, not RPMs
Operating System: Red Hat Enterprise Linux AS (v 2.1)
Kernel: 2.4.9-e.34smp
Hardware: Dell PE 2600-Dual 2.8 Ghz Xeon w/2GB RAM and Dual 36GB Mirrors
using PERC RAID
The same problem has occurred on at least three separate occasions on 3
different tables and manifests itself through the following error while
performing "COPY TABLE" commands:
ERROR: MemoryContextAlloc: invalid request size 4294967293 lost
synchronization with server, resetting connection
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?
Marc Mitchell - Senior Application Architect
Enterprise Information Solutions, Inc.
Downers Grove, IL 60515
marcm@eisolution.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: marcm@eisolution.com
Subject: Re: Row data corruption under 7.3.5
In-Reply-To: <004101c3ffbb$ebce29f0$7201050a@MarcM8500>
References: <Pine.LNX.4.44.0403011750590.25446-100000@emo.org.tr> <004101c3ffbb$ebce29f0$7201050a@MarcM8500>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox