Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash
Дата
Msg-id CAMsr+YECMHZghxwOCwFz+JXL-qXRpAc2p2FTRE3YnrBtjZ-GhQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash  (Craig Ringer <craig@2ndquadrant.com>)
Ответы Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash  (Neha Sharma <neha.sharma@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: [HACKERS] <> join selectivity estimate question
Следующее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables