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
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 |