[13:41:46.247] src/tools/ci/cores_backtrace.sh linux /tmp/cores [13:41:46.461] dumping /tmp/cores/postgres-6-24879.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:41:46.719] [New LWP 24879] [13:41:46.719] [13:41:46.719] This GDB supports auto-downloading debuginfo from the following URLs: [13:41:46.719] [13:41:46.719] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:41:46.719] Debuginfod has been disabled. [13:41:46.719] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:41:46.840] [Thread debugging using libthread_db enabled] [13:41:46.840] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:41:46.840] Core was generated by `postgres: old_node: postgres regression [local] MERGE '. [13:41:46.840] Program terminated with signal SIGABRT, Aborted. [13:41:46.840] #0 0x00007fe78c0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:47.839] [13:41:47.839] Thread 1 (Thread 0x7fe78bfd3f00 (LWP 24879)): [13:41:47.839] #0 0x00007fe78c0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:47.839] No symbol table info available. [13:41:47.839] #1 0x00007fe78c05afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:47.839] No symbol table info available. [13:41:47.839] #2 0x00007fe78c045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:47.839] No symbol table info available. [13:41:47.839] #3 0x000056552d9cf64f in ExceptionalCondition (conditionName=conditionName@entry=0x56552dc1cac5 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x56552dc40f38 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:41:47.839] No locals. [13:41:47.839] #4 0x000056552d37e2ab in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fff81ecde60, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fff81ecdcff) at ../src/backend/executor/execTuples.c:1737 [13:41:47.839] No locals. [13:41:47.839] #5 0x000056552d30223c in ExecIRDeleteTriggers (estate=estate@entry=0x56553074b510, relinfo=relinfo@entry=0x56553074bac0, slot=slot@entry=0x7fff81ecde60) at ../src/backend/commands/trigger.c:2841 [13:41:47.839] trigger = 0x56553074bd20 [13:41:47.839] oldtuple = [13:41:47.839] trigdesc = 0x56553074bcd0 [13:41:47.839] newtuple = 0x0 [13:41:47.839] should_free = false [13:41:47.839] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7fe7809b4450, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:41:47.839] i = 0 [13:41:47.839] #6 0x000056552d3db1a8 in ExecMergeMatched (context=0x7fff81ecde80, resultRelInfo=resultRelInfo@entry=0x56553074bac0, tupleid=0x0, oldtuple=0x7fff81ecde60, canSetTag=true, matched=matched@entry=0x7fff81ecde0f) at ../src/backend/executor/nodeModifyTable.c:3043 [13:41:47.839] relaction = 0x56553084f490 [13:41:47.839] commandType = CMD_DELETE [13:41:47.839] result = TM_Ok [13:41:47.839] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:41:47.839] l__state = [13:41:47.839] mtstate = 0x56553074b8b0 [13:41:47.839] mergeActions = 0x56553074bbd0 [13:41:47.839] actionStates = 0x56553084fa50 [13:41:47.839] newslot = 0x0 [13:41:47.839] rslot = 0x0 [13:41:47.839] estate = 0x56553074b510 [13:41:47.839] econtext = 0x56553084eaa0 [13:41:47.839] isNull = false [13:41:47.839] epqstate = 0x56553074b998 [13:41:47.839] l = [13:41:47.839] __func__ = "ExecMergeMatched" [13:41:47.839] lmerge_matched = [13:41:47.839] #7 0x000056552d3dbd66 in ExecMerge (context=context@entry=0x7fff81ecde80, resultRelInfo=resultRelInfo@entry=0x56553074bac0, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fff81ecde60, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [13:41:47.839] rslot = 0x0 [13:41:47.839] matched = true [13:41:47.839] #8 0x000056552d3dd52b in ExecModifyTable (pstate=0x56553074b8b0) at ../src/backend/executor/nodeModifyTable.c:4133 [13:41:47.839] node = 0x56553074b8b0 [13:41:47.839] context = {mtstate = 0x56553074b8b0, epqstate = 0x56553074b998, estate = 0x56553074b510, planSlot = 0x56553084ce88, tmfd = {ctid = {ip_blkid = {bi_hi = 46096, bi_lo = 12404}, ip_posid = 22101}, xmax = 765535601, cmax = 22101, traversed = 16}, cpUpdateReturningSlot = 0x56552da12571 } [13:41:47.839] estate = 0x56553074b510 [13:41:47.839] operation = CMD_MERGE [13:41:47.839] resultRelInfo = 0x56553074bac0 [13:41:47.839] subplanstate = 0x56553074c1f0 [13:41:47.839] slot = [13:41:47.839] oldSlot = [13:41:47.839] tuple_ctid = {ip_blkid = {bi_hi = 12414, bi_lo = 22101}, ip_posid = 0} [13:41:47.839] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x5655307ae158} [13:41:47.839] oldtuple = 0x7fff81ecde60 [13:41:47.839] tupleid = 0x0 [13:41:47.839] __func__ = "ExecModifyTable" [13:41:47.839] #9 0x000056552d3707f7 in ExecProcNodeFirst (node=0x56553074b8b0) at ../src/backend/executor/execProcnode.c:469 [13:41:47.839] No locals. [13:41:47.839] #10 0x000056552d35bcf5 in ExecProcNode (node=node@entry=0x56553074b8b0) at ../src/include/executor/executor.h:278 [13:41:47.839] No locals. [13:41:47.839] #11 0x000056552d35beaa in ExecutePlan (estate=estate@entry=0x56553074b510, planstate=0x56553074b8b0, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x5655307d02c0, execute_once=true) at ../src/backend/executor/execMain.c:1641 [13:41:47.839] slot = [13:41:47.839] current_tuple_count = 0 [13:41:47.839] #12 0x000056552d35dc22 in standard_ExecutorRun (queryDesc=0x5655307cd538, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:358 [13:41:47.839] estate = 0x56553074b510 [13:41:47.839] operation = CMD_MERGE [13:41:47.839] dest = 0x5655307d02c0 [13:41:47.839] sendTuples = [13:41:47.839] oldcontext = 0x5655307cffb0 [13:41:47.839] __func__ = "standard_ExecutorRun" [13:41:47.839] #13 0x000056552d35de55 in ExecutorRun (queryDesc=queryDesc@entry=0x5655307cd538, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:299 [13:41:47.839] No locals. [13:41:47.839] #14 0x000056552d7433a0 in ProcessQuery (plan=plan@entry=0x5655307e2e88, sourceText=0x565530646ad0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x5655307d02c0, qc=qc@entry=0x7fff81ece0b0) at ../src/backend/tcop/pquery.c:160 [13:41:47.839] queryDesc = 0x5655307cd538 [13:41:47.839] #15 0x000056552d744fd5 in PortalRunMulti (portal=portal@entry=0x5655306c9720, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5655307d02c0, altdest=0x56552df4a0c0 , qc=qc@entry=0x7fff81ece0b0) at ../src/backend/tcop/pquery.c:1278 [13:41:47.839] pstmt = 0x5655307e2e88 [13:41:47.839] stmtlist_item__state = [13:41:47.839] active_snapshot_set = true [13:41:47.839] stmtlist_item = 0x5655307e2fb0 [13:41:47.839] #16 0x000056552d745527 in FillPortalStore (portal=portal@entry=0x5655306c9720, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [13:41:47.839] treceiver = 0x5655307d02c0 [13:41:47.839] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:41:47.839] __func__ = "FillPortalStore" [13:41:47.839] #17 0x000056552d745af8 in PortalRun (portal=portal@entry=0x5655306c9720, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5655307e2fe8, altdest=altdest@entry=0x5655307e2fe8, qc=0x7fff81ece290) at ../src/backend/tcop/pquery.c:763 [13:41:47.839] _save_exception_stack = 0x7fff81ece340 [13:41:47.839] _save_context_stack = 0x0 [13:41:47.839] _local_sigjmp_buf = {{__jmpbuf = {0, 5352390059460711828, 94923884631840, 94923886249536, 94923884631840, 94923886249464, 1806754079472145812, 5352449483275556244}, __mask_was_saved = 0, __saved_mask = {__val = {94923837744497, 94923884095952, 112, 4, 94923837748914, 2179785247, 4, 94923886249464, 112, 163, 94923884631840, 94923886249536, 94923886249512, 94923886249464, 94923837836117, 1}}}} [13:41:47.839] _do_rethrow = [13:41:47.839] result = [13:41:47.839] nprocessed = [13:41:47.839] saveTopTransactionResourceOwner = 0x5655306868d8 [13:41:47.839] saveTopTransactionContext = 0x5655306da700 [13:41:47.839] saveActivePortal = 0x0 [13:41:47.839] saveResourceOwner = 0x5655306868d8 [13:41:47.839] savePortalContext = 0x0 [13:41:47.839] saveMemoryContext = 0x5655306da700 [13:41:47.839] __func__ = "PortalRun" [13:41:47.839] #18 0x000056552d73eea5 in exec_simple_query (query_string=query_string@entry=0x565530646ad0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [13:41:47.839] cmdtaglen = 5 [13:41:47.839] snapshot_set = [13:41:47.839] per_parsetree_context = 0x0 [13:41:47.839] plantree_list = 0x5655307e2f98 [13:41:47.839] parsetree = 0x5655308545f8 [13:41:47.839] commandTag = [13:41:47.839] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:41:47.839] querytree_list = [13:41:47.839] portal = 0x5655306c9720 [13:41:47.839] receiver = 0x5655307e2fe8 [13:41:47.839] format = 0 [13:41:47.839] cmdtagname = [13:41:47.839] parsetree_item__state = [13:41:47.839] dest = DestRemote [13:41:47.839] oldcontext = 0x5655306da700 [13:41:47.839] parsetree_list = 0x565530854628 [13:41:47.839] parsetree_item = 0x565530854640 [13:41:47.839] save_log_statement_stats = false [13:41:47.839] was_logged = true [13:41:47.839] use_implicit_block = false [13:41:47.839] msec_str = "\360\344\354\201\377\177\000\000wS\237-UV\000\000 \343\354\201\377\177\000\000\026\001\000\000\000\000\000" [13:41:47.839] __func__ = "exec_simple_query" [13:41:47.839] #19 0x000056552d74197e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [13:41:47.839] query_string = 0x565530646ad0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [13:41:47.839] firstchar = [13:41:47.839] input_message = {data = 0x565530646ad0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [13:41:47.839] local_sigjmp_buf = {{__jmpbuf = {94923850267224, 5352455978231846292, 4, 140735373174000, 140735373174144, 140735373174148, 1806754079358899604, 5352449485618075028}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94923883826768, 14336, 94923850261312, 94923884353680, 140735373174144, 94923837748462, 0, 9, 2, 94923850267232, 94923883826768, 94923850261312, 140735373174000, 140735373174144, 140735373174148}}}} [13:41:47.839] send_ready_for_query = false [13:41:47.839] idle_in_transaction_timeout_enabled = false [13:41:47.839] idle_session_timeout_enabled = false [13:41:47.839] __func__ = "PostgresMain" [13:41:47.839] #20 0x000056552d737aa0 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:41:47.839] bsdata = [13:41:47.839] #21 0x000056552d5f0420 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff81ece49c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff81ece4f0) at ../src/backend/postmaster/launch_backend.c:274 [13:41:47.839] pid = [13:41:47.839] #22 0x000056552d5f5ecc in BackendStartup (client_sock=client_sock@entry=0x7fff81ece4f0) at ../src/backend/postmaster/postmaster.c:3415 [13:41:47.839] bn = 0x56553067bac8 [13:41:47.839] pid = [13:41:47.839] startup_data = {canAcceptConnections = CAC_OK} [13:41:47.839] __func__ = "BackendStartup" [13:41:47.839] #23 0x000056552d5f642e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [13:41:47.839] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\002\214\347\177\000\000\264\345\354\201\377\177\000\000\312\300\232\215\347\177\000\000>\004\000\000\000\000\000\000\260\227\003\214\347\177\000\000\240\337\\\215\347\177\000\000\270\345\354\201\377\177\000\000\264\345\354\201\377\177\000\000\000\000\000\000\000\000\000\000P\345\354\201\377\177\000\000\232[|,UV\000\000\370Fx,UV\000\000\200\346\354\201\377\177\000\000x\346\354\201\377\177\000\000\225[\362\001\000\000\000", __ss_align = 140632471602336}, salen = 2}} [13:41:47.839] i = 0 [13:41:47.839] now = [13:41:47.839] last_lockfile_recheck_time = 1725889079 [13:41:47.839] last_touch_time = 1725889079 [13:41:47.839] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7fe78d9d62e0}, {pos = -2115181064, events = 0, fd = 0, user_data = 0x7fe78d9d6668}, {pos = 746347418, events = 22101, fd = -1919064472, user_data = 0x7fe78c838630}, {pos = -1919065376, events = 32743, fd = 2090263927, user_data = 0x7fff81ece700}, {pos = -1919235512, events = 32743, fd = 15, user_data = 0x7fe78c838630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1919065376, events = 32743, fd = -2115180936, user_data = 0x7fff81ece680}, {pos = -1919064472, events = 32743, fd = 0, user_data = 0x565530675408}, {pos = 812077800, events = 22101, fd = 812077249, user_data = 0x7fe700000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7fe78c02e020}, {pos = -1923293280, events = 32743, fd = 812078088, user_data = 0x7fff81ecea70}, {pos = 812049256, events = 22101, fd = 812078320, user_data = 0x565530675408}, {pos = -1919065376, events = 32743, fd = 438, user_data = 0x56552df69db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x565530646ae8}, {pos = -1919209794, events = 32743, fd = 1, user_data = 0x0}, {pos = -1945968608, events = 32743, fd = -1945162304, user_data = 0x7fff81eceae0}, {pos = -2115179840, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1919200838, user_data = 0x0}, {pos = -1945440988, events = 32743, fd = 0, user_data = 0x56552e5f5400 }, {pos = 2, events = 0, fd = 7, user_data = 0x565530608ef0}, {pos = 0, events = 0, fd = -1945934648, user_data = 0x7fe78c09c880 }, {pos = -1946337864, events = 32743, fd = 8096, user_data = 0x100007f00000002}, {pos = -1945407865, events = 32743, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1944118176, events = 32743, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x565530608ef0}, {pos = -1945404918, events = 32743, fd = 1663923061, user_data = 0x565530608ef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffff0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x7f0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x692e6928c14c2a00}, {pos = -1944132128, events = 32743, fd = -328, user_data = 0x0}, {pos = 812077480, events = 22101, fd = 1024, user_data = 0x5655306751a8}, {pos = -2115179656, events = 32767, fd = -1945403745, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 22741, events = 0, fd = -328, user_data = 0x0}, {pos = 811887336, events = 22101, fd = -1945161773, user_data = 0x7fff81eceb78}, {pos = 765618917, events = 22101, fd = 778058256, user_data = 0x56552da155a2 }, {pos = 812077280, events = 22101, fd = 811887056, user_data = 0x5655306750e0}, {pos = -1945413909, events = 32743, fd = 0, user_data = 0x56552da2720c }, {pos = 812077280, events = 1, fd = 765621077, user_data = 0x5655306469d0}, {pos = -1051973120, events = 1764649256, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1945490767, user_data = 0x7fe78c0a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1051973120, user_data = 0x56553061e100}, {pos = -1051973120, events = 1764649256, fd = 11, user_data = 0x692e6928c14c2a00}, {pos = 0, events = 0, fd = -1945783751, user_data = 0x1}, {pos = 761200925, events = 22101, fd = 4194304, user_data = 0x56552da15436 }, {pos = 811720960, events = 22101, fd = 811887056, user_data = 0x56553061e100}, {pos = 1, events = 0, fd = 0, user_data = 0x56552da2720c }, {pos = 811720960, events = 22101, fd = 765621077, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x56552d428a6b }, {pos = 0, events = 0, fd = 759356843, user_data = 0xb}, {pos = 761222074, events = 22101, fd = 774470896, user_data = 0x565530647378}} [13:41:47.839] nevents = 1 [13:41:47.839] __func__ = "ServerLoop" [13:41:47.839] #24 0x000056552d5f7ba4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x565530604d60) at ../src/backend/postmaster/postmaster.c:1346 [13:41:47.839] opt = [13:41:47.839] status = [13:41:47.839] userDoption = [13:41:47.839] listen_addr_saved = false [13:41:47.839] output_config_variable = [13:41:47.839] __func__ = "PostmasterMain" [13:41:47.839] #25 0x000056552d438e47 in main (argc=4, argv=0x565530604d60) at ../src/backend/main/main.c:197 [13:41:47.839] do_check_root = [13:41:47.875] -e [13:41:47.875] [13:41:47.875] [13:41:47.941] dumping /tmp/cores/postgres-6-24405.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:41:48.192] [New LWP 24405] [13:41:48.192] [13:41:48.192] This GDB supports auto-downloading debuginfo from the following URLs: [13:41:48.192] [13:41:48.192] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:41:48.192] Debuginfod has been disabled. [13:41:48.192] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:41:48.296] [Thread debugging using libthread_db enabled] [13:41:48.296] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:41:48.296] Core was generated by `postgres: postgres regression [local] MERGE '. [13:41:48.296] Program terminated with signal SIGABRT, Aborted. [13:41:48.296] #0 0x00007f8125ea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:49.268] [13:41:49.268] Thread 1 (Thread 0x7f8123e2cf00 (LWP 24405)): [13:41:49.268] #0 0x00007f8125ea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:49.268] No symbol table info available. [13:41:49.268] #1 0x00007f8125e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:49.268] No symbol table info available. [13:41:49.268] #2 0x00007f8125e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:49.268] No symbol table info available. [13:41:49.268] #3 0x000055857524e64f in ExceptionalCondition (conditionName=conditionName@entry=0x55857549bac5 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x5585754bff38 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:41:49.268] No locals. [13:41:49.268] #4 0x0000558574bfd2ab in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffc524c3910, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffc524c37af) at ../src/backend/executor/execTuples.c:1737 [13:41:49.268] No locals. [13:41:49.268] #5 0x0000558574b8123c in ExecIRDeleteTriggers (estate=estate@entry=0x558577231340, relinfo=relinfo@entry=0x5585772318f0, slot=slot@entry=0x7ffc524c3910) at ../src/backend/commands/trigger.c:2841 [13:41:49.268] trigger = 0x558577231b50 [13:41:49.268] oldtuple = [13:41:49.268] trigdesc = 0x558577231b00 [13:41:49.268] newtuple = 0x0 [13:41:49.268] should_free = false [13:41:49.268] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f811a419eb0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:41:49.268] i = 0 [13:41:49.268] #6 0x0000558574c5a1a8 in ExecMergeMatched (context=0x7ffc524c3930, resultRelInfo=resultRelInfo@entry=0x5585772318f0, tupleid=0x0, oldtuple=0x7ffc524c3910, canSetTag=true, matched=matched@entry=0x7ffc524c38bf) at ../src/backend/executor/nodeModifyTable.c:3043 [13:41:49.268] relaction = 0x5585772d1110 [13:41:49.268] commandType = CMD_DELETE [13:41:49.268] result = TM_Ok [13:41:49.268] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:41:49.268] l__state = [13:41:49.268] mtstate = 0x5585772316e0 [13:41:49.268] mergeActions = 0x558577231a00 [13:41:49.268] actionStates = 0x5585772d16d0 [13:41:49.268] newslot = 0x0 [13:41:49.268] rslot = 0x0 [13:41:49.268] estate = 0x558577231340 [13:41:49.268] econtext = 0x5585772d0720 [13:41:49.268] isNull = false [13:41:49.268] epqstate = 0x5585772317c8 [13:41:49.268] l = [13:41:49.268] __func__ = "ExecMergeMatched" [13:41:49.268] lmerge_matched = [13:41:49.268] #7 0x0000558574c5ad66 in ExecMerge (context=context@entry=0x7ffc524c3930, resultRelInfo=resultRelInfo@entry=0x5585772318f0, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffc524c3910, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [13:41:49.268] rslot = 0x0 [13:41:49.268] matched = true [13:41:49.268] #8 0x0000558574c5c52b in ExecModifyTable (pstate=0x5585772316e0) at ../src/backend/executor/nodeModifyTable.c:4133 [13:41:49.268] node = 0x5585772316e0 [13:41:49.268] context = {mtstate = 0x5585772316e0, epqstate = 0x5585772317c8, estate = 0x558577231340, planSlot = 0x5585772ceb08, tmfd = {ctid = {ip_blkid = {bi_hi = 4672, bi_lo = 30499}, ip_posid = 21893}, xmax = 1965626737, cmax = 21893, traversed = 64}, cpUpdateReturningSlot = 0x558575291571 } [13:41:49.268] estate = 0x558577231340 [13:41:49.268] operation = CMD_MERGE [13:41:49.268] resultRelInfo = 0x5585772318f0 [13:41:49.268] subplanstate = 0x558577232020 [13:41:49.268] slot = [13:41:49.268] oldSlot = [13:41:49.268] tuple_ctid = {ip_blkid = {bi_hi = 30509, bi_lo = 21893}, ip_posid = 0} [13:41:49.268] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x558577292a68} [13:41:49.268] oldtuple = 0x7ffc524c3910 [13:41:49.268] tupleid = 0x0 [13:41:49.268] __func__ = "ExecModifyTable" [13:41:49.268] #9 0x0000558574bef7f7 in ExecProcNodeFirst (node=0x5585772316e0) at ../src/backend/executor/execProcnode.c:469 [13:41:49.268] No locals. [13:41:49.268] #10 0x0000558574bdacf5 in ExecProcNode (node=node@entry=0x5585772316e0) at ../src/include/executor/executor.h:278 [13:41:49.268] No locals. [13:41:49.268] #11 0x0000558574bdaeaa in ExecutePlan (estate=estate@entry=0x558577231340, planstate=0x5585772316e0, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x5585772b43b0, execute_once=true) at ../src/backend/executor/execMain.c:1641 [13:41:49.268] slot = [13:41:49.268] current_tuple_count = 0 [13:41:49.268] #12 0x0000558574bdcc22 in standard_ExecutorRun (queryDesc=0x5585772b85a8, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:358 [13:41:49.268] estate = 0x558577231340 [13:41:49.268] operation = CMD_MERGE [13:41:49.268] dest = 0x5585772b43b0 [13:41:49.268] sendTuples = [13:41:49.268] oldcontext = 0x5585772b40a0 [13:41:49.268] __func__ = "standard_ExecutorRun" [13:41:49.268] #13 0x0000558574bdce55 in ExecutorRun (queryDesc=queryDesc@entry=0x5585772b85a8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:299 [13:41:49.268] No locals. [13:41:49.268] #14 0x0000558574fc23a0 in ProcessQuery (plan=plan@entry=0x5585772ddb38, sourceText=0x558577129b40 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x5585772b43b0, qc=qc@entry=0x7ffc524c3b60) at ../src/backend/tcop/pquery.c:160 [13:41:49.268] queryDesc = 0x5585772b85a8 [13:41:49.268] #15 0x0000558574fc3fd5 in PortalRunMulti (portal=portal@entry=0x5585771ac0e0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5585772b43b0, altdest=0x5585757c90c0 , qc=qc@entry=0x7ffc524c3b60) at ../src/backend/tcop/pquery.c:1278 [13:41:49.268] pstmt = 0x5585772ddb38 [13:41:49.268] stmtlist_item__state = [13:41:49.268] active_snapshot_set = true [13:41:49.268] stmtlist_item = 0x5585772ddc60 [13:41:49.268] #16 0x0000558574fc4527 in FillPortalStore (portal=portal@entry=0x5585771ac0e0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [13:41:49.268] treceiver = 0x5585772b43b0 [13:41:49.268] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:41:49.268] __func__ = "FillPortalStore" [13:41:49.268] #17 0x0000558574fc4af8 in PortalRun (portal=portal@entry=0x5585771ac0e0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5585772ddc98, altdest=altdest@entry=0x5585772ddc98, qc=0x7ffc524c3d40) at ../src/backend/tcop/pquery.c:763 [13:41:49.268] _save_exception_stack = 0x7ffc524c3df0 [13:41:49.268] _save_context_stack = 0x0 [13:41:49.268] _local_sigjmp_buf = {{__jmpbuf = {0, -3726986045803492963, 94031717253344, 94031718381312, 94031717253344, 94031718381240, -7442938132768781923, -3726990018291725923}, __mask_was_saved = 0, __saved_mask = {__val = {94031684638065, 94031716719168, 112, 4, 94031684642482, 1380728015, 4, 94031718381240, 112, 163, 94031717253344, 94031718381312, 94031718381288, 94031718381240, 94031684729685, 1}}}} [13:41:49.268] _do_rethrow = [13:41:49.268] result = [13:41:49.268] nprocessed = [13:41:49.268] saveTopTransactionResourceOwner = 0x558577168d98 [13:41:49.268] saveTopTransactionContext = 0x5585771bdcf0 [13:41:49.268] saveActivePortal = 0x0 [13:41:49.268] saveResourceOwner = 0x558577168d98 [13:41:49.268] savePortalContext = 0x0 [13:41:49.268] saveMemoryContext = 0x5585771bdcf0 [13:41:49.268] __func__ = "PortalRun" [13:41:49.268] #18 0x0000558574fbdea5 in exec_simple_query (query_string=query_string@entry=0x558577129b40 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [13:41:49.268] cmdtaglen = 5 [13:41:49.268] snapshot_set = [13:41:49.268] per_parsetree_context = 0x0 [13:41:49.268] plantree_list = 0x5585772ddc48 [13:41:49.268] parsetree = 0x5585772bf6b8 [13:41:49.268] commandTag = [13:41:49.268] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:41:49.268] querytree_list = [13:41:49.268] portal = 0x5585771ac0e0 [13:41:49.268] receiver = 0x5585772ddc98 [13:41:49.268] format = 0 [13:41:49.268] cmdtagname = [13:41:49.268] parsetree_item__state = [13:41:49.268] dest = DestRemote [13:41:49.268] oldcontext = 0x5585771bdcf0 [13:41:49.268] parsetree_list = 0x5585772bf6e8 [13:41:49.268] parsetree_item = 0x5585772bf700 [13:41:49.268] save_log_statement_stats = false [13:41:49.268] was_logged = false [13:41:49.268] use_implicit_block = false [13:41:49.268] msec_str = "\240?LR\374\177\000\000wC'u\205U\000\000\320=LR\374\177\000\000\026\001\000\000\000\000\000" [13:41:49.268] __func__ = "exec_simple_query" [13:41:49.268] #19 0x0000558574fc097e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [13:41:49.268] query_string = 0x558577129b40 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [13:41:49.268] firstchar = [13:41:49.268] input_message = {data = 0x558577129b40 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [13:41:49.268] local_sigjmp_buf = {{__jmpbuf = {94031697160792, -3726992041914431075, 4, 140721689214880, 140721689215024, 140721689215028, -7442938132965914211, -3726990016066647651}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94031716449856, 15616, 94031697154880, 94031716973904, 140721689215024, 94031684642030, 0, 9, 2, 94031697160800, 94031716449856, 94031697154880, 140721689214880, 140721689215024, 140721689215028}}}} [13:41:49.268] send_ready_for_query = false [13:41:49.268] idle_in_transaction_timeout_enabled = false [13:41:49.268] idle_session_timeout_enabled = false [13:41:49.268] __func__ = "PostgresMain" [13:41:49.268] #20 0x0000558574fb6aa0 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:41:49.268] bsdata = [13:41:49.268] #21 0x0000558574e6f420 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc524c3f4c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc524c3fa0) at ../src/backend/postmaster/launch_backend.c:274 [13:41:49.268] pid = [13:41:49.268] #22 0x0000558574e74ecc in BackendStartup (client_sock=client_sock@entry=0x7ffc524c3fa0) at ../src/backend/postmaster/postmaster.c:3415 [13:41:49.268] bn = 0x558577152298 [13:41:49.268] pid = [13:41:49.268] startup_data = {canAcceptConnections = CAC_OK} [13:41:49.268] __func__ = "BackendStartup" [13:41:49.268] #23 0x0000558574e7542e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [13:41:49.268] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "LR\374\177\000\0004@LR\374\177", '\000' , "\232K\004t\205U\000\000\3706\000t\205U\000\000\000ALR\374\177\000\000\370@LR\374\177\000\000\225[\362\001\000\000\000\000\240t\310&\201\177\000\000+", '\000' , "\257J\004t\205U\000\000h\206v'\201\177\000\0000v\310&\201\177\000", __ss_align = 140192689586912}, salen = 2}} [13:41:49.268] i = 0 [13:41:49.268] now = [13:41:49.268] last_lockfile_recheck_time = 1725889076 [13:41:49.268] last_touch_time = 1725889076 [13:41:49.268] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1946438554, events = 21893, fd = 662079080, user_data = 0x7f8126c87630}, {pos = 662078176, events = 32641, fd = 2090263927, user_data = 0x7ffc524c4180}, {pos = 661908040, events = 32641, fd = 15, user_data = 0x7f8126c87630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 662078176, events = 32641, fd = 1380729080, user_data = 0x7ffc524c4100}, {pos = 662079080, events = 32641, fd = 0, user_data = 0x558577129c00}, {pos = 1965948181, events = 21893, fd = 32768, user_data = 0x1}, {pos = 1997715776, events = 21893, fd = -1, user_data = 0x7f8125e2e020}, {pos = 657850272, events = 32641, fd = 1997891544, user_data = 0x5585771566b8}, {pos = 1997899985, events = 21893, fd = 661933758, user_data = 0x1}, {pos = 662078176, events = 32641, fd = 438, user_data = 0x5585757e8db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x558577129c00}, {pos = 661933758, events = 32641, fd = 1, user_data = 0x0}, {pos = 635625504, events = 32641, fd = 636431808, user_data = 0x10}, {pos = 1380730224, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 661942714, user_data = 0x0}, {pos = 636153124, events = 32641, fd = 0, user_data = 0x558575e74400 }, {pos = 2, events = 0, fd = 7, user_data = 0x5585770ebee0}, {pos = 1962220555, events = 21893, fd = 1997917547, user_data = 0x558574f55844 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x558577129c00}, {pos = 661933758, events = 32641, fd = 1, user_data = 0x0}, {pos = 635659464, events = 32641, fd = 636078208, user_data = 0x41e}, {pos = 636186605, events = 32641, fd = 2, user_data = 0x5585771554a0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 637475936, events = 32641, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x32786f482d737365}, {pos = 168446830, events = 874520608, fd = 822763892, user_data = 0x30340a3637303938}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1965626737, events = 21893, fd = 1997893824, user_data = 0x7f8125eb56eb}, {pos = 637458912, events = 32641, fd = 636096878, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x74d19bfa10b91600}, {pos = 637461984, events = 32641, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1997890936, user_data = 0x558575291e34 }, {pos = 1997890736, events = 21893, fd = 3, user_data = 0x0}, {pos = 22098, events = 0, fd = -328, user_data = 0x0}, {pos = 1997708288, events = 21893, fd = 636432339, user_data = 0x7ffc524c4628}, {pos = 1965710053, events = 21893, fd = 1978149392, user_data = 0x5585752945a2 }, {pos = 1997890736, events = 21893, fd = 1997707840, user_data = 0x5585771564b0}, {pos = 636180542, events = 32641, fd = 0, user_data = 0x5585752a620c }, {pos = 1997890736, events = 1, fd = 1965712213, user_data = 0x558577129a40}, {pos = 280565248, events = 1959894010, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 636103345, user_data = 0x7f8125ea14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 280565248, user_data = 0x558577101170}, {pos = 280565248, events = 1959894010, fd = 11, user_data = 0x74d19bfa10b91600}, {pos = 0, events = 0, fd = 635810361, user_data = 0x1}, {pos = 1961292061, events = 21893, fd = 4194304, user_data = 0x558575294436 }, {pos = 1997541744, events = 21893, fd = 1997707840, user_data = 0x558577101170}, {pos = 1, events = 0, fd = 0, user_data = 0x5585752a620c }, {pos = 1997541744, events = 21893, fd = 1965712213, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x558574ca7a6b }, {pos = 0, events = 0, fd = 1959447979, user_data = 0xb}, {pos = 1961313210, events = 21893, fd = 1974562032, user_data = 0x55857712a418}} [13:41:49.268] nevents = 1 [13:41:49.268] __func__ = "ServerLoop" [13:41:49.268] #24 0x0000558574e76ba4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5585770e7da0) at ../src/backend/postmaster/postmaster.c:1346 [13:41:49.268] opt = [13:41:49.268] status = [13:41:49.268] userDoption = [13:41:49.268] listen_addr_saved = false [13:41:49.268] output_config_variable = [13:41:49.268] __func__ = "PostmasterMain" [13:41:49.268] #25 0x0000558574cb7e47 in main (argc=8, argv=0x5585770e7da0) at ../src/backend/main/main.c:197 [13:41:49.268] do_check_root = [13:41:49.305] -e [13:41:49.305] [13:41:49.305] [13:41:49.372] dumping /tmp/cores/postgres-6-31465.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:41:49.629] [New LWP 31465] [13:41:49.629] [13:41:49.629] This GDB supports auto-downloading debuginfo from the following URLs: [13:41:49.629] [13:41:49.629] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:41:49.629] Debuginfod has been disabled. [13:41:49.629] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:41:49.734] [Thread debugging using libthread_db enabled] [13:41:49.734] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:41:49.734] Core was generated by `postgres: primary: postgres regression [local] MERGE '. [13:41:49.734] Program terminated with signal SIGABRT, Aborted. [13:41:49.734] #0 0x00007fb161aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:50.710] [13:41:50.710] Thread 1 (Thread 0x7fb1619dbf00 (LWP 31465)): [13:41:50.710] #0 0x00007fb161aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:50.710] No symbol table info available. [13:41:50.710] #1 0x00007fb161a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:50.710] No symbol table info available. [13:41:50.710] #2 0x00007fb161a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:41:50.710] No symbol table info available. [13:41:50.710] #3 0x00005578db24964f in ExceptionalCondition (conditionName=conditionName@entry=0x5578db496ac5 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x5578db4baf38 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:41:50.710] No locals. [13:41:50.710] #4 0x00005578dabf82ab in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fff19513d10, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fff19513baf) at ../src/backend/executor/execTuples.c:1737 [13:41:50.710] No locals. [13:41:50.710] #5 0x00005578dab7c23c in ExecIRDeleteTriggers (estate=estate@entry=0x5578dce81fa0, relinfo=relinfo@entry=0x5578dce82550, slot=slot@entry=0x7fff19513d10) at ../src/backend/commands/trigger.c:2841 [13:41:50.710] trigger = 0x5578dce827b0 [13:41:50.710] oldtuple = [13:41:50.710] trigdesc = 0x5578dce82760 [13:41:50.710] newtuple = 0x0 [13:41:50.710] should_free = false [13:41:50.710] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7fb15d4df5d8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:41:50.710] i = 0 [13:41:50.710] #6 0x00005578dac551a8 in ExecMergeMatched (context=0x7fff19513d30, resultRelInfo=resultRelInfo@entry=0x5578dce82550, tupleid=0x0, oldtuple=0x7fff19513d10, canSetTag=true, matched=matched@entry=0x7fff19513cbf) at ../src/backend/executor/nodeModifyTable.c:3043 [13:41:50.710] relaction = 0x5578dcfd8c50 [13:41:50.710] commandType = CMD_DELETE [13:41:50.710] result = TM_Ok [13:41:50.710] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:41:50.710] l__state = [13:41:50.710] mtstate = 0x5578dce82340 [13:41:50.710] mergeActions = 0x5578dce82660 [13:41:50.710] actionStates = 0x5578dcfd9210 [13:41:50.710] newslot = 0x0 [13:41:50.710] rslot = 0x0 [13:41:50.710] estate = 0x5578dce81fa0 [13:41:50.710] econtext = 0x5578dcfd8260 [13:41:50.710] isNull = false [13:41:50.710] epqstate = 0x5578dce82428 [13:41:50.710] l = [13:41:50.710] __func__ = "ExecMergeMatched" [13:41:50.710] lmerge_matched = [13:41:50.710] #7 0x00005578dac55d66 in ExecMerge (context=context@entry=0x7fff19513d30, resultRelInfo=resultRelInfo@entry=0x5578dce82550, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fff19513d10, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [13:41:50.710] rslot = 0x0 [13:41:50.710] matched = true [13:41:50.710] #8 0x00005578dac5752b in ExecModifyTable (pstate=0x5578dce82340) at ../src/backend/executor/nodeModifyTable.c:4133 [13:41:50.710] node = 0x5578dce82340 [13:41:50.710] context = {mtstate = 0x5578dce82340, epqstate = 0x5578dce82428, estate = 0x5578dce81fa0, planSlot = 0x5578dcfd6648, tmfd = {ctid = {ip_blkid = {bi_hi = 35520, bi_lo = 56573}, ip_posid = 21880}, xmax = 3707646888, cmax = 21880, traversed = 5}, cpUpdateReturningSlot = 0x5578dcfe33a8} [13:41:50.710] estate = 0x5578dce81fa0 [13:41:50.710] operation = CMD_MERGE [13:41:50.710] resultRelInfo = 0x5578dce82550 [13:41:50.710] subplanstate = 0x5578dce82c80 [13:41:50.710] slot = [13:41:50.710] oldSlot = [13:41:50.710] tuple_ctid = {ip_blkid = {bi_hi = 56573, bi_lo = 21880}, ip_posid = 0} [13:41:50.710] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x5578dcf9a5d8} [13:41:50.710] oldtuple = 0x7fff19513d10 [13:41:50.710] tupleid = 0x0 [13:41:50.710] __func__ = "ExecModifyTable" [13:41:50.710] #9 0x00005578dabea7f7 in ExecProcNodeFirst (node=0x5578dce82340) at ../src/backend/executor/execProcnode.c:469 [13:41:50.710] No locals. [13:41:50.710] #10 0x00005578dabd5cf5 in ExecProcNode (node=node@entry=0x5578dce82340) at ../src/include/executor/executor.h:278 [13:41:50.710] No locals. [13:41:50.710] #11 0x00005578dabd5eaa in ExecutePlan (estate=estate@entry=0x5578dce81fa0, planstate=0x5578dce82340, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x5578dcfb5ef0, execute_once=true) at ../src/backend/executor/execMain.c:1641 [13:41:50.710] slot = [13:41:50.710] current_tuple_count = 0 [13:41:50.710] #12 0x00005578dabd7c22 in standard_ExecutorRun (queryDesc=queryDesc@entry=0x5578dcfba908, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:358 [13:41:50.710] estate = 0x5578dce81fa0 [13:41:50.710] operation = CMD_MERGE [13:41:50.710] dest = 0x5578dcfb5ef0 [13:41:50.710] sendTuples = [13:41:50.710] oldcontext = 0x5578dcfb5be0 [13:41:50.710] __func__ = "standard_ExecutorRun" [13:41:50.710] #13 0x00007fb15f63d813 in pgss_ExecutorRun (queryDesc=0x5578dcfba908, direction=ForwardScanDirection, count=0, execute_once=) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [13:41:50.710] _save_exception_stack = 0x7fff19514110 [13:41:50.710] _save_context_stack = 0x0 [13:41:50.710] _local_sigjmp_buf = {{__jmpbuf = {93977591916808, -4148025437123736470, 93977590295280, 93977591897840, 0, 0, -4148025437855642518, -4110716966835155862}, __mask_was_saved = 0, __saved_mask = {__val = {2147483647, 93977591897840, 0, 0, 93977561410389, 0, 1, 0, 93977554466606, 93977591916808, 93977573841504, 93977591897056, 140399786321868, 93977591916808, 0, 93977590295280}}}} [13:41:50.710] _do_rethrow = false [13:41:50.710] #14 0x00005578dabd7e48 in ExecutorRun (queryDesc=queryDesc@entry=0x5578dcfba908, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:297 [13:41:50.710] No locals. [13:41:50.710] #15 0x00005578dafbd3a0 in ProcessQuery (plan=plan@entry=0x5578dcfe65a0, sourceText=0x5578dce2eaf0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x5578dcfb5ef0, qc=qc@entry=0x7fff19514070) at ../src/backend/tcop/pquery.c:160 [13:41:50.710] queryDesc = 0x5578dcfba908 [13:41:50.710] #16 0x00005578dafbefd5 in PortalRunMulti (portal=portal@entry=0x5578dceb0030, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5578dcfb5ef0, altdest=0x5578db7c40c0 , qc=qc@entry=0x7fff19514070) at ../src/backend/tcop/pquery.c:1278 [13:41:50.710] pstmt = 0x5578dcfe65a0 [13:41:50.710] stmtlist_item__state = [13:41:50.710] active_snapshot_set = true [13:41:50.710] stmtlist_item = 0x5578dcfe66c8 [13:41:50.710] #17 0x00005578dafbf527 in FillPortalStore (portal=portal@entry=0x5578dceb0030, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [13:41:50.710] treceiver = 0x5578dcfb5ef0 [13:41:50.710] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:41:50.710] __func__ = "FillPortalStore" [13:41:50.710] #18 0x00005578dafbfaf8 in PortalRun (portal=portal@entry=0x5578dceb0030, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5578dcfe6700, altdest=altdest@entry=0x5578dcfe6700, qc=0x7fff19514250) at ../src/backend/tcop/pquery.c:763 [13:41:50.710] _save_exception_stack = 0x7fff19514300 [13:41:50.710] _save_context_stack = 0x0 [13:41:50.710] _local_sigjmp_buf = {{__jmpbuf = {0, -7827032359440184214, 93977590825008, 93977592510128, 93977590825008, 93977592510056, -4148025437117445014, -7827036787009352598}, __mask_was_saved = 0, __saved_mask = {__val = {93977561318769, 93977590295024, 112, 4, 93977561323186, 424755679, 4, 93977592510056, 112, 163, 93977590825008, 93977592510128, 93977592510104, 93977592510056, 93977561410389, 1}}}} [13:41:50.710] _do_rethrow = [13:41:50.710] result = [13:41:50.710] nprocessed = [13:41:50.710] saveTopTransactionResourceOwner = 0x5578dce6f4f0 [13:41:50.710] saveTopTransactionContext = 0x5578dcec2460 [13:41:50.710] saveActivePortal = 0x0 [13:41:50.710] saveResourceOwner = 0x5578dce6f4f0 [13:41:50.710] savePortalContext = 0x0 [13:41:50.710] saveMemoryContext = 0x5578dcec2460 [13:41:50.710] __func__ = "PortalRun" [13:41:50.710] #19 0x00005578dafb8ea5 in exec_simple_query (query_string=query_string@entry=0x5578dce2eaf0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1284 [13:41:50.710] cmdtaglen = 5 [13:41:50.710] snapshot_set = [13:41:50.710] per_parsetree_context = 0x0 [13:41:50.710] plantree_list = 0x5578dcfe66b0 [13:41:50.710] parsetree = 0x5578dd04b668 [13:41:50.710] commandTag = [13:41:50.710] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:41:50.710] querytree_list = [13:41:50.710] portal = 0x5578dceb0030 [13:41:50.710] receiver = 0x5578dcfe6700 [13:41:50.710] format = 0 [13:41:50.710] cmdtagname = [13:41:50.710] parsetree_item__state = [13:41:50.710] dest = DestRemote [13:41:50.710] oldcontext = 0x5578dcec2460 [13:41:50.710] parsetree_list = 0x5578dd04b698 [13:41:50.710] parsetree_item = 0x5578dd04b6b0 [13:41:50.710] save_log_statement_stats = false [13:41:50.710] was_logged = true [13:41:50.710] use_implicit_block = false [13:41:50.710] msec_str = "\260DQ\031\377\177\000\000w\363&\333xU\000\000\340BQ\031\377\177\000\000\026\001\000\000\000\000\000" [13:41:50.710] __func__ = "exec_simple_query" [13:41:50.710] #20 0x00005578dafbb97e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [13:41:50.710] query_string = 0x5578dce2eaf0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [13:41:50.710] firstchar = [13:41:50.710] input_message = {data = 0x5578dce2eaf0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [13:41:50.710] local_sigjmp_buf = {{__jmpbuf = {93977573841496, -7827038747017048982, 4, 140733618144432, 140733618144576, 140733618144580, -4148025437180359574, -7827036789217653654}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 93977590544864, 0, 168, 93977561323288, 0, 10, 2, 93977573841504, 93977590025872, 93977573835584, 140733618144432, 140733618144576, 140733618144580}}}} [13:41:50.710] send_ready_for_query = false [13:41:50.710] idle_in_transaction_timeout_enabled = false [13:41:50.710] idle_session_timeout_enabled = false [13:41:50.710] __func__ = "PostgresMain" [13:41:50.710] #21 0x00005578dafb1aa0 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:41:50.710] bsdata = [13:41:50.710] #22 0x00005578dae6a420 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff1951445c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff195144b0) at ../src/backend/postmaster/launch_backend.c:274 [13:41:50.710] pid = [13:41:50.710] #23 0x00005578dae6fecc in BackendStartup (client_sock=client_sock@entry=0x7fff195144b0) at ../src/backend/postmaster/postmaster.c:3415 [13:41:50.710] bn = 0x5578dce5b388 [13:41:50.710] pid = [13:41:50.710] startup_data = {canAcceptConnections = CAC_OK} [13:41:50.710] __func__ = "BackendStartup" [13:41:50.710] #24 0x00005578dae7042e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [13:41:50.710] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\242a\261\177\000\000tEQ\031\377\177\000\000\31208c\261\177\000\000>\004\000\000\000\000\000\000\260\227\243a\261\177\000\000\240O\372b\261\177\000\000xEQ\031\377\177\000\000tEQ\031\377\177\000\000\000\000\000\000\000\000\000\000\020EQ\031\377\177\000\000\232\373\003\332xU\000\000\370\346\377\331xU\000\000@FQ\031\377\177\000\0008FQ\031\377\177\000\000\225[\362\001\000\000\000", __ss_align = 93977590467344}, salen = 2}} [13:41:50.710] i = 0 [13:41:50.710] now = [13:41:50.710] last_lockfile_recheck_time = 1725889107 [13:41:50.710] last_touch_time = 1725889107 [13:41:50.710] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7fb1633ad2e0}, {pos = 424756664, events = 0, fd = 0, user_data = 0x7fb1633ad668}, {pos = -637273190, events = 21880, fd = 1664800360, user_data = 0x7fb162f2b630}, {pos = 1664799456, events = 32689, fd = 2090263927, user_data = 0x7fff195146c0}, {pos = 1664629320, events = 32689, fd = 15, user_data = 0x7fb162f2b630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1664799456, events = 32689, fd = 424756792, user_data = 0x7fff19514640}, {pos = 1664800360, events = 32689, fd = 0, user_data = 0x5578dce5a3a8}, {pos = -588930424, events = 21880, fd = -588912335, user_data = 0x7fb100000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7fb161a2e020}, {pos = 1660571552, events = 32689, fd = -588930136, user_data = 0x7fff19514a30}, {pos = -588912168, events = 21880, fd = -588910240, user_data = 0x5578dce5a3a8}, {pos = 1664799456, events = 32689, fd = 438, user_data = 0x5578db7e3db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x5578dce30930}, {pos = 1664655038, events = 32689, fd = 1, user_data = 0x0}, {pos = 1638064160, events = 32689, fd = 1638870464, user_data = 0x7fff19514aa0}, {pos = 424757888, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1664663994, user_data = 0x0}, {pos = 1638591780, events = 32689, fd = 0, user_data = 0x5578dbe6f400 }, {pos = 2, events = 0, fd = 7, user_data = 0x5578dcdf0f30}, {pos = 0, events = 0, fd = 1638098120, user_data = 0x7fb161a9c880 }, {pos = 1637727672, events = 32689, fd = 8096, user_data = 0x100007f00000002}, {pos = 1638625261, events = 32689, fd = 2, user_data = 0x5578dce639a0}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 1639914592, events = 32689, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x5578dcdf0f30}, {pos = 1638627850, events = 32689, fd = 1769300525, user_data = 0x5578dcdf0f30}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3430332f0a202020}, {pos = 1634618890, events = 1600742241, fd = 0, user_data = 0x0}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 1660077376, user_data = 0x7fb162f2ca80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x84b797470427e400}, {pos = 1639900640, events = 32689, fd = -328, user_data = 0x0}, {pos = -588930744, events = 21880, fd = 1024, user_data = 0x5578dce5a148}, {pos = 424758072, events = 32767, fd = 1638629023, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 29272, events = 0, fd = -328, user_data = 0x0}, {pos = -589100752, events = 21880, fd = 1638870995, user_data = 0x7fff19514b38}, {pos = -618001691, events = 21880, fd = -605562352, user_data = 0x5578db28f5a2 }, {pos = -588930944, events = 21880, fd = -589108752, user_data = 0x5578dce5a080}, {pos = 1638619198, events = 32689, fd = 0, user_data = 0x5578db2a120c }, {pos = -588930944, events = 1, fd = -617999531, user_data = 0x5578dce2e9f0}, {pos = 69723136, events = 2226624327, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1638542001, user_data = 0x7fb161aa14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 69723136, user_data = 0x5578dce06120}, {pos = 69723136, events = 2226624327, fd = 11, user_data = 0x84b797470427e400}, {pos = 0, events = 0, fd = 1638249017, user_data = 0x1}, {pos = -622419683, events = 21880, fd = 4194304, user_data = 0x5578db28f436 }, {pos = -589274848, events = 21880, fd = -589108752, user_data = 0x5578dce06120}, {pos = 1, events = 0, fd = 0, user_data = 0x5578db2a120c }, {pos = -589274848, events = 21880, fd = -617999531, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5578daca2a6b }, {pos = 0, events = 0, fd = -624263765, user_data = 0xb}, {pos = -622398534, events = 21880, fd = -609149712, user_data = 0x5578dce2f3a8}} [13:41:50.710] nevents = 1 [13:41:50.710] __func__ = "ServerLoop" [13:41:50.710] #25 0x00005578dae71ba4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5578dcdecd90) at ../src/backend/postmaster/postmaster.c:1346 [13:41:50.710] opt = [13:41:50.710] status = [13:41:50.710] userDoption = [13:41:50.710] listen_addr_saved = false [13:41:50.710] output_config_variable = [13:41:50.710] __func__ = "PostmasterMain" [13:41:50.710] #26 0x00005578dacb2e47 in main (argc=4, argv=0x5578dcdecd90) at ../src/backend/main/main.c:197 [13:41:50.710] do_check_root =