ERROR: invalid memory alloc request size, and others

From: Jonathan Hedstrom <jhedstrom(at)desc(dot)org>
To: pgsql-general(at)postgresql(dot)org
Cc: Ken Tanzer <ktanzer(at)desc(dot)org>
Subject: ERROR: invalid memory alloc request size, and others
Date: 2007-01-09 19:38:15
Message-ID: 45A3EF27.1020300@desc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We recently upgraded from 8.1.4 to 8.2.0 on Fedora Core 6, and are now
seeing a few rather ominous-looking messages.

The problem started with this one, during an update involving a rather
complex view:

ERROR: invalid memory alloc request size 1174405120

Then, when attempting to re-run the same update statement:

PANIC: cannot abort transaction 8682091, it was already committed

and then again:

PANIC: right sibling's left-link doesn't match

I ran reindex on the tables in question, which fixed the problem in the
short term and allowed the update to complete, but then I got the memory
allocation error and these overnight:

ERROR: invalid page header in block 3362 of relation
"index_clin_dal_staff_id"
ERROR: invalid page header in block 2325 of relation "index_clin_dal_batch"

I will gladly provide additional information to help track down and
hopefully solve this problem, but at this point I'm not sure what else
to include.

Any help would be much appreciated.

Thanks,
Jonathan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2007-01-09 19:50:31 index creation on 7.3
Previous Message Joe Conway 2007-01-09 19:28:53 Re: Array constructor requires one argument