pg_dump failes due to invalid memory request

From: "Morgan Kita" <mkita(at)verseon(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: pg_dump failes due to invalid memory request
Date: 2005-09-02 04:06:12
Message-ID: 08B420FF5BF7BC42A064212C2EB768801C10C0@neutron.verseon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I just tried to call pg_dump for my database this evening, and it fails on one of my tables.
The error it gives in the log is:
ERROR: invalid memory alloc request size 3221230573

So at this point what do I do?

What I have done:
I reindexed the table sucessfully, and it made no difference.
I tried grabbing all the rows around the last row that was sucessfully dumped through a select statment. That worked sucessfully.

How do I test/fix this?
I am assuming something is corrupted but I am not sure how to figure out what. I have had nothing in the logs to indicate a corruption. Now the only thing I can think of is that this particular table has 2 custom data types that are both toastable. I am guessing that number indicates a bad header value at the beginning of one of the custom data types.

Please help!

Thanks,
Morgan

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-09-02 04:18:07 Re: pg_dump failes due to invalid memory request
Previous Message me 2005-09-02 02:48:33 Re: triggers: how to check if a field changed?