Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash
Date
Msg-id CAMsr+YECMHZghxwOCwFz+JXL-qXRpAc2p2FTRE3YnrBtjZ-GhQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash
List pgsql-hackers
On 19 July 2017 at 20:26, Neha Sharma <neha.sharma@enterprisedb.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

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: [HACKERS] <> join selectivity estimate question
Next
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables