BUG #18055: logical decoding core on AllocateSnapshotBuilder()
От
PG Bug reporting form
Тема
BUG #18055: logical decoding core on AllocateSnapshotBuilder()
Дата
Msg-id
18055-ab3beed9f4b7b7d6@postgresql.org
Список
Дерево обсуждения
BUG #18055: logical decoding core on AllocateSnapshotBuilder() PG Bug reporting form <noreply@postgresql.org>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() ocean_li_996 <ocean_li_996@163.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila <amit.kapila16@gmail.com>
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila <amit.kapila16@gmail.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila <amit.kapila16@gmail.com>
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Masahiko Sawada <sawada.mshk@gmail.com>
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Andres Freund <andres@anarazel.de>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila <amit.kapila16@gmail.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Andres Freund <andres@anarazel.de>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila <amit.kapila16@gmail.com>
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila <amit.kapila16@gmail.com>
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila <amit.kapila16@gmail.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Amit Kapila <amit.kapila16@gmail.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Masahiko Sawada <sawada.mshk@gmail.com>
Re: BUG #18055: logical decoding core on AllocateSnapshotBuilder() Andres Freund <andres@anarazel.de>
RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re:RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder() ocean_li_996 <ocean_li_996@163.com>
The following bug has been logged on the website: Bug reference: 18055 Logged by: ocean li Email address: ocean_li_996@163.com PostgreSQL version: 11.9 Operating system: centos7 5.10.84 x86_64 Description: For testing logical decoding module, *pg_logical_slot_get_changes* function is used. Sometimes i got an core whose stack was like that: ==> #0 0x00007f744a7b9277 in raise () from /lib64/libc.so.6 #1 0x00007f744a7ba968 in abort () from /lib64/libc.so.6 #2 0x00000000010edd37 in ExceptionalCondition (conditionName=0x17e2b58 "!(NInitialRunningXacts == 0 && InitialRunningXacts == ((void *)0))", errorType=0x17e2b45 "FailedAssertion", fileName=0x17e2b39 "snapbuild.c", lineNumber=381) at assert.c:46 #3 0x0000000000e60b46 in AllocateSnapshotBuilder (reorder=0x551ea98, xmin_horizon=0, start_lsn=1267160216, need_full_snapshot=false) at snapbuild.c:381 #4 0x0000000000e50f70 in StartupDecodingContext (output_plugin_options=0x0, start_lsn=1267160216, xmin_horizon=0, need_full_snapshot=false, fast_forward=false, read_page=0xe53023 , prepare_write=0xe52df6 , do_write=0xe52e24 , update_progress=0x0) at logical.c:191 #5 0x0000000000e518b8 in CreateDecodingContext (start_lsn=1267160216, output_plugin_options=0x0, fast_forward=false, read_page=0xe53023 , prepare_write=0xe52df6 , do_write=0xe52e24 , update_progress=0x0) at logical.c:486 #6 0x0000000000e53735 in pg_logical_slot_get_changes_guts (fcinfo=0x7ffcd879e3d0, confirm=true, binary=false) at logicalfuncs.c:259 #7 0x0000000000e53b1c in pg_logical_slot_get_changes (fcinfo=0x7ffcd879e3d0) at logicalfuncs.c:393 #8 0x00000000010ff89e in FunctionCallInvokeCheckSPL (fcinfo=0x7ffcd879e3d0) at fmgr.c:2262 ... ==> And in level #3 of stack above, NInitialRunningXacts is 2 and InitialRunningXacts is not NULL observed in one of cores. Using of NInitialRunningXacts and InitialRunningXacts are clear. Currently, the core, as far as i know, maybe caused by this way: an ERROR raised when calling *pg_logical_slot_get_changes_guts* function. The code part of PG_CATCH() doses not reset NInitialRunningXacts and InitialRunningXacts. Then, calling pg_logical_slot_get_changes_guts again, the core may occur. Unfortunately, I couldn't find a minimal reproduction case. However, I observed an *ERROR: canceling statement due to statement timeout* logged before each core occurred. (For some reason, I can't provide the information of log)
В списке pgsql-bugs по дате отправления
От: Thomas Munro
Дата:
От: ocean_li_996
Дата: