terminated by signal 6 problem

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

Responses

Browse pgsql-hackers by date

  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?