From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | terminated by signal 6 problem |
Date: | 2004-08-10 22:50:31 |
Message-ID: | 41195137.7020209@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I was sent a log file for a production system that has received several
ABORT signals while under heavy load. Here's a snippet from the logs:
-----------
LOG: recycled transaction log file "0000000A0000004B"
LOG: recycled transaction log file "0000000A0000004D"
LOG: recycled transaction log file "0000000A0000004E"
LOG: recycled transaction log file "0000000A0000004F"
WARNING: specified item offset is too large
CONTEXT: COPY cymi_transaction_data, line 174: "3448545602 62365 39 4 0.00"
PANIC: failed to add item to the page for "pk_transaction_data"
CONTEXT: COPY cymi_transaction_data, line 174: "3448545602 62365 39 4 0.00"
STATEMENT: COPY cymi_transaction_data FROM STDIN;
LOG: server process (PID 11667) was terminated by signal 6
LOG: terminating any other active server processe
-----------
The server information as I was given it:
Sun server V250, 1 GHz Processor, 1 GB RAM, 4 x 72GB
I'm requesting more data -- not yet clear whether I can get a core dump
or even if postgres is compiled with debug symbols on that machine.
The "WARNING: specified item offset is too large" seems to happen each
time there is an ABORT, leading me to think it might be bad RAM.
Any thoughts or specific data requests? I can send the full log off-list
if needed.
Thanks,
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2004-08-10 23:03:38 | Re: Add Missing From? |
Previous Message | Tom Lane | 2004-08-10 22:46:43 | Re: Why is WIN 1250 client only? |