From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | Neha Sharma <neha(dot)sharma(at)enterprisedb(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [TRAP: FailedAssertion] causing server to crash |
Date: | 2017-07-20 05:53:32 |
Message-ID: | CAMsr+YECMHZghxwOCwFz+JXL-qXRpAc2p2FTRE3YnrBtjZ-GhQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> On 19 July 2017 at 20:26, Neha Sharma <neha(dot)sharma(at)enterprisedb(dot)com>
> wrote:
>
>> Hi,
>>
>> I am getting FailedAssertion while executing the attached
>> script.However,I am not able to produce the core dump for the same,the
>> script runs in background and takes around a day time to produce the
>> mentioned error.
>>
>> "TRAP: FailedAssertion("!(TransactionIdPrecedesOrEquals(oldestXact,
>> ShmemVariableCache->oldestXid))", File: "clog.c", Line: 683)
>> 2017-07-19 01:16:51.973 GMT [27873] LOG: server process (PID 28084) was
>> terminated by signal 6: Aborted
>> 2017-07-19 01:16:51.973 GMT [27873] DETAIL: Failed process was running:
>> autovacuum: VACUUM pg_toast.pg_toast_13029 (to prevent wraparound)"
>>
>
>
What are the starting conditions of your postgres instance? Does your
script assume a newly initdb'd instance with no custom configuration? If
not, what setup steps/configuration precede your script run?
> well short of the 2-million mark.
>
Er, billion.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Ashutosh Bapat | 2017-07-20 06:05:43 | Re: Partition-wise join for join between (declaratively) partitioned tables |
Previous Message | Thomas Munro | 2017-07-20 05:34:51 | Re: <> join selectivity estimate question |