RE: BUG #18369: logical decoding core on AssertTXNLsnOrder()

Поиск
Список
Период
Сортировка
От Hayato Kuroda (Fujitsu)
Тема RE: BUG #18369: logical decoding core on AssertTXNLsnOrder()
Дата
Msg-id TYCPR01MB12077573479C5A2471BDE8065F5232@TYCPR01MB12077.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: BUG #18369: logical decoding core on AssertTXNLsnOrder()  (Alexander Lakhin <exclusion@gmail.com>)
Ответы Re: BUG #18369: logical decoding core on AssertTXNLsnOrder()  (Alexander Lakhin <exclusion@gmail.com>)
Список pgsql-bugs

Dear Alexander,

 

I also ran your script after applying patches on REL_14_STABLE, but I got another failure.

I have not analyzed yet so I share the result as-is.

Was I missing something?


```

#0  0x00007f4f033de387 in raise () from /lib64/libc.so.6

#1  0x00007f4f033dfa78 in abort () from /lib64/libc.so.6

#2  0x0000000000b08152 in ExceptionalCondition (conditionName=0xcc8228 "prev_first_lsn < cur_txn->first_lsn",

    errorType=0xcc8024 "FailedAssertion", fileName=0xcc8070 "reorderbuffer.c", lineNumber=916) at assert.c:69

#3  0x00000000008e01ad in AssertTXNLsnOrder (rb=0x19a95c0) at reorderbuffer.c:916

#4  0x00000000008dfae8 in ReorderBufferTXNByXid (rb=0x19a95c0, xid=1753, create=true, is_new=0x0, lsn=37430336,

    create_as_top=true) at reorderbuffer.c:669

#5  0x00000000008e3e04 in ReorderBufferAddNewTupleCids (rb=0x19a95c0, xid=1753, lsn=37430336, node=..., tid=..., cmin=1,

    cmax=4294967295, combocid=4294967295) at reorderbuffer.c:3200

#6  0x00000000008e9018 in SnapBuildProcessNewCid (builder=0x19af5f0, xid=1754, lsn=37430336, xlrec=0x197db38)

    at snapbuild.c:823

#7  0x00000000008d2616 in DecodeHeap2Op (ctx=0x1999550, buf=0x7ffcc39d7310) at decode.c:470

#8  0x00000000008d1df5 in LogicalDecodingProcessRecord (ctx=0x1999550, record=0x1999910) at decode.c:150

#9  0x00000000008d9782 in pg_logical_slot_get_changes_guts (fcinfo=0x19874b0, confirm=true, binary=false)

    at logicalfuncs.c:296

#10 0x00000000008d98b7 in pg_logical_slot_get_changes (fcinfo=0x19874b0) at logicalfuncs.c:365

#11 0x0000000000740001 in ExecMakeTableFunctionResult (setexpr=0x1985a38, econtext=0x19858f0, argContext=0x1987390,

    expectedDesc=0x19ae898, randomAccess=false) at execSRF.c:234

#12 0x000000000075be2b in FunctionNext (node=0x19856d8) at nodeFunctionscan.c:95

#13 0x000000000074184a in ExecScanFetch (node=0x19856d8, accessMtd=0x75bd7a <FunctionNext>,

    recheckMtd=0x75c175 <FunctionRecheck>) at execScan.c:132

#14 0x00000000007418eb in ExecScan (node=0x19856d8, accessMtd=0x75bd7a <FunctionNext>, recheckMtd=0x75c175 <FunctionRecheck>)

    at execScan.c:198

#15 0x000000000075c1bf in ExecFunctionScan (pstate=0x19856d8) at nodeFunctionscan.c:270

#16 0x000000000073db6e in ExecProcNodeFirst (node=0x19856d8) at execProcnode.c:464

#17 0x00000000007322ac in ExecProcNode (node=0x19856d8) at ../../../src/include/executor/executor.h:260

#18 0x0000000000734b36 in ExecutePlan (estate=0x19854a0, planstate=0x19856d8, use_parallel_mode=false, operation=CMD_SELECT,

    sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x19c2008, execute_once=true) at execMain.c:1551

#19 0x0000000000732916 in standard_ExecutorRun (queryDesc=0x1975860, direction=ForwardScanDirection, count=0,

    execute_once=true) at execMain.c:361

--Type <RET> for more, q to quit, c to continue without paging--

#20 0x0000000000732744 in ExecutorRun (queryDesc=0x1975860, direction=ForwardScanDirection, count=0, execute_once=true)

    at execMain.c:305

#21 0x000000000097c752 in PortalRunSelect (portal=0x191dd40, forward=true, count=0, dest=0x19c2008) at pquery.c:921

#22 0x000000000097c411 in PortalRun (portal=0x191dd40, count=9223372036854775807, isTopLevel=true, run_once=true,

    dest=0x19c2008, altdest=0x19c2008, qc=0x7ffcc39d7b00) at pquery.c:765

#23 0x00000000009760d8 in exec_simple_query (

    query_string=0x18bb7a0 "SELECT data FROM pg_logical_slot_get_changes('isolation_slot_5', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0');") at postgres.c:1213

#24 0x000000000097a5eb in PostgresMain (argc=1, argv=0x7ffcc39d7d90, dbname=0x18e5c28 "regress_5",

    username=0x18e5c08 "hayato") at postgres.c:4513

#25 0x00000000008b58b6 in BackendRun (port=0x18dd880) at postmaster.c:4540

#26 0x00000000008b5232 in BackendStartup (port=0x18dd880) at postmaster.c:4262

#27 0x00000000008b16ff in ServerLoop () at postmaster.c:1748

#28 0x00000000008b0fd1 in PostmasterMain (argc=5, argv=0x18b6200) at postmaster.c:1420

#29 0x00000000007b16f8 in main (argc=5, argv=0x18b6200) at main.c:209

```

 

Best Regards,

Hayato Kuroda

FUJITSU LIMITED

https://www.fujitsu.com/

 

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18376: pg_upgrade fails trying to restore privileges on retired function pg_start_backup and pg_stop_backup
Следующее
От: Ronan Dunklau
Дата:
Сообщение: Re: FSM Corruption (was: Could not read block at end of the relation)