From: Tom Lane <tgl@sss.pgh.pa.us>
To: Chris Hoover <revoohc@sermonaudio.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Help requeted with abend.
Date: Tue, 08 Jun 2004 14:10:58 -0400
Message-ID: <4624.1086718258@sss.pgh.pa.us> (raw)
In-Reply-To: <40C5EE86.8050509@sermonaudio.com>
References: <40C5EE86.8050509@sermonaudio.com>
"Chris Hoover" <revoohc@sermonaudio.com> writes:
> I just tried to pg_dump a db of mine and recieved the following abend.
> Can someone please give me some guidance as to what is going on? I just
> created the db yesturday as part of a db migration plan.
> pg_dump: ERROR: MemoryContextAlloc: invalid request size 4294967293
This looks like a corrupted-data problem, specifically a variable-length
field whose length word contains a ridiculous value.
Probably the first thing to do is determine exactly where the bad data
is. You can eliminate columns if you can select them successfully, and
then home in on the row location by seeing where a "SELECT LIMIT n" fails.
People also sometimes use pg_filedump to look at clobbered data --- if
you search the archives for threads mentioning pg_filedump, you'll find
more detail about this sort of thing than I feel like going into right
now.
It would of course be interesting to find out how the data got
corrupted, but the first step is to gather evidence...
regards, tom lane
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: tgl@sss.pgh.pa.us, revoohc@sermonaudio.com
Subject: Re: Help requeted with abend.
In-Reply-To: <4624.1086718258@sss.pgh.pa.us>
References: <40C5EE86.8050509@sermonaudio.com> <4624.1086718258@sss.pgh.pa.us>
* 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