[08:17:30.961] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [08:17:31.351] dumping /tmp/cores/postgres.7924.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:17:31.489] [New LWP 100133] [08:17:31.581] Core was generated by `postgres: postgres regression [local] MERGE'. [08:17:31.581] Program terminated with signal SIGABRT, Aborted. [08:17:31.581] Sent by thr_kill() from pid 7924 and user 1003. [08:17:31.581] #0 0x000000082a804dca in thr_kill () from /lib/libc.so.7 [08:17:32.207] [08:17:32.207] Thread 1 (LWP 100133): [08:17:32.207] #0 0x000000082a804dca in thr_kill () from /lib/libc.so.7 [08:17:32.207] No symbol table info available. [08:17:32.207] #1 0x000000082a77d6f4 in raise () from /lib/libc.so.7 [08:17:32.207] No symbol table info available. [08:17:32.207] #2 0x000000082a82ebc9 in abort () from /lib/libc.so.7 [08:17:32.207] No symbol table info available. [08:17:32.207] #3 0x0000000000a47c57 in ExceptionalCondition (conditionName=, fileName=0x36f9a0 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [08:17:32.207] No locals. [08:17:32.207] #4 0x0000000000732260 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8210d1e50, materialize=, shouldFree=shouldFree@entry=0x8210d1e16) at ../src/backend/executor/execTuples.c:1737 [08:17:32.207] No locals. [08:17:32.207] #5 0x00000000006f8868 in ExecIRDeleteTriggers (estate=estate@entry=0x83593f100, relinfo=relinfo@entry=0x83593f6b0, slot=slot@entry=0x8210d1e50) at ../src/backend/commands/trigger.c:2832 [08:17:32.207] trigger = [08:17:32.207] oldtuple = [08:17:32.207] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8451e8660, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [08:17:32.207] trigdesc = 0x83593f8c0 [08:17:32.207] newtuple = 0x0 [08:17:32.207] i = 0 [08:17:32.207] should_free = false [08:17:32.207] #6 0x0000000000757487 in ExecMergeMatched (context=0x8210d1ef0, resultRelInfo=0x83593f6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [08:17:32.207] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [08:17:32.207] relaction = 0x841d2ead8 [08:17:32.207] commandType = CMD_DELETE [08:17:32.207] result = TM_Ok [08:17:32.207] l__state = {l = 0x841d2f098, i = 0} [08:17:32.207] mtstate = 0x83593f4a0 [08:17:32.207] newslot = 0x0 [08:17:32.207] rslot = 0x0 [08:17:32.207] estate = 0x18725 [08:17:32.207] mergeActions = [08:17:32.207] econtext = 0x841d2e108 [08:17:32.207] epqstate = 0x83593f588 [08:17:32.207] actionStates = 0x841d2f098 [08:17:32.207] l = [08:17:32.207] isNull = [08:17:32.207] lmerge_matched = [08:17:32.207] __error = [08:17:32.207] l__state = [08:17:32.207] updateCxt = [08:17:32.207] relaction = [08:17:32.207] commandType = [08:17:32.207] result = [08:17:32.207] __error = [08:17:32.207] resultRelationDesc = [08:17:32.207] lockmode = [08:17:32.207] inputslot = [08:17:32.207] epqslot = [08:17:32.207] was_matched = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] #7 ExecMerge (context=0x8210d1ef0, resultRelInfo=0x83593f6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [08:17:32.207] matched = [08:17:32.207] rslot = 0x0 [08:17:32.207] #8 ExecModifyTable (pstate=0x83593f4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [08:17:32.207] context = {mtstate = 0x83593f4a0, epqstate = 0x83593f588, estate = 0x83593f100, planSlot = 0x841d2cc28, tmfd = {ctid = {ip_blkid = {bi_hi = 7984, bi_lo = 8461}, ip_posid = 8}, xmax = 1104341352, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x841d5bf38} [08:17:32.207] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [08:17:32.207] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x841c93118} [08:17:32.207] node = 0x83593f4a0 [08:17:32.207] estate = 0x83593f100 [08:17:32.207] operation = CMD_MERGE [08:17:32.207] resultRelInfo = 0x83593f6b0 [08:17:32.207] subplanstate = 0x835940df0 [08:17:32.207] slot = [08:17:32.207] tupleid = 0x0 [08:17:32.207] oldtuple = 0x0 [08:17:32.207] oldSlot = [08:17:32.207] #9 0x000000000072c29b in ExecProcNodeFirst (node=0x83593f4a0) at ../src/backend/executor/execProcnode.c:464 [08:17:32.207] No locals. [08:17:32.207] #10 0x000000000072458a in ExecProcNode (node=0x83593f4a0) at ../src/include/executor/executor.h:274 [08:17:32.207] No locals. [08:17:32.207] #11 ExecutePlan (estate=0x83593f100, planstate=0x83593f4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83579c710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [08:17:32.207] current_tuple_count = [08:17:32.207] slot = [08:17:32.207] #12 standard_ExecutorRun (queryDesc=0x835831448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [08:17:32.207] estate = 0x83593f100 [08:17:32.207] oldcontext = 0x83579c400 [08:17:32.207] operation = CMD_MERGE [08:17:32.207] dest = 0x83579c710 [08:17:32.207] sendTuples = true [08:17:32.207] #13 0x000000000072443f in ExecutorRun (queryDesc=0x18725, queryDesc@entry=0x835831448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [08:17:32.207] No locals. [08:17:32.207] #14 0x00000000008f69ef in ProcessQuery (plan=0x841d5b820, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8210d2128) at ../src/backend/tcop/pquery.c:160 [08:17:32.207] queryDesc = 0x835831448 [08:17:32.207] #15 0x00000000008f5f8d in PortalRunMulti (portal=portal@entry=0x835864100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83579c710, altdest=0xb37920 , qc=qc@entry=0x8210d2128) at ../src/backend/tcop/pquery.c:1286 [08:17:32.207] pstmt = 0x841d5b820 [08:17:32.207] stmtlist_item__state = {l = 0x841d600d8, i = 0} [08:17:32.207] active_snapshot_set = true [08:17:32.207] stmtlist_item = 0x841d600f0 [08:17:32.207] #16 0x00000000008f5a7c in FillPortalStore (portal=portal@entry=0x835864100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:17:32.207] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:17:32.207] treceiver = 0x83579c710 [08:17:32.207] #17 0x00000000008f57d0 in PortalRun (portal=portal@entry=0x835864100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x841d60128, altdest=altdest@entry=0x841d60128, qc=0x8210d2260) at ../src/backend/tcop/pquery.c:763 [08:17:32.207] _local_sigjmp_buf = {{_sjb = {9394031, 35257799128, 34914247000, 34914247232, 34914247008, 12057320, 12025104, 35257729280, 7112098687, 35257737472, 3565847, 34359738368}}} [08:17:32.207] _save_exception_stack = 0x8210d2330 [08:17:32.207] _save_context_stack = 0x0 [08:17:32.207] _do_rethrow = false [08:17:32.207] saveTopTransactionResourceOwner = 0x8358751d8 [08:17:32.207] saveTopTransactionContext = 0x83579a000 [08:17:32.207] saveActivePortal = 0x0 [08:17:32.207] saveResourceOwner = 0x8358751d8 [08:17:32.207] savePortalContext = 0x0 [08:17:32.207] saveMemoryContext = 0x83579a000 [08:17:32.207] result = [08:17:32.207] nprocessed = [08:17:32.207] #18 0x00000000008f46db in exec_simple_query (query_string=query_string@entry=0x83578e100 "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:1274 [08:17:32.207] cmdtaglen = [08:17:32.207] snapshot_set = [08:17:32.207] per_parsetree_context = 0x0 [08:17:32.207] plantree_list = [08:17:32.207] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:17:32.207] parsetree = 0x841cfca28 [08:17:32.207] commandTag = CMDTAG_MERGE [08:17:32.207] cmdtagname = [08:17:32.207] querytree_list = [08:17:32.207] portal = 0x835864100 [08:17:32.207] format = 0 [08:17:32.207] receiver = 0x841d60128 [08:17:32.207] parsetree_item__state = {l = 0x841cfe2f0, i = 0} [08:17:32.207] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [08:17:32.207] dest = DestRemote [08:17:32.207] was_logged = [08:17:32.207] oldcontext = 0x83579a000 [08:17:32.207] parsetree_list = 0x841cfe2f0 [08:17:32.207] use_implicit_block = false [08:17:32.207] parsetree_item = 0x841cfe308 [08:17:32.207] save_log_statement_stats = [08:17:32.207] #19 0x00000000008f24c4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [08:17:32.207] query_string = 0x83578e100 "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"... [08:17:32.207] input_message = {data = 0x83578e100 "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} [08:17:32.207] firstchar = [08:17:32.207] local_sigjmp_buf = {{_sjb = {9378192, 34914247472, 34914247432, 34914248032, 12066056, 12012528, 8192, 8388608, 72057628952167295, 0, 0, 34359738369}}} [08:17:32.207] send_ready_for_query = false [08:17:32.207] idle_in_transaction_timeout_enabled = false [08:17:32.207] idle_session_timeout_enabled = false [08:17:32.207] #20 0x00000000008ed229 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [08:17:32.207] bsdata = [08:17:32.207] #21 0x0000000000849fc2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8210d3070 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8210d2fb8) at ../src/backend/postmaster/launch_backend.c:265 [08:17:32.207] pid = [08:17:32.207] #22 0x000000000084e7e1 in BackendStartup (client_sock=0x8210d2fb8) at ../src/backend/postmaster/postmaster.c:3593 [08:17:32.207] startup_data = {canAcceptConnections = CAC_OK} [08:17:32.207] bn = 0x83579a1c8 [08:17:32.207] pid = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] save_errno = [08:17:32.207] __error = [08:17:32.207] __error = [08:17:32.207] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [08:17:32.207] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "\0200\r!\b\000\000\000\330\305M*\b\000\000\000\v\000\000\000\000\000\000\000\016FN*\b", '\000' , "P0\r!\b\000\000\000\224\235\204\000\000\000\000\000`0\r!\b", '\000' }, salen = 16}} [08:17:32.207] i = 0 [08:17:32.207] now = [08:17:32.207] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 711908452, events = 8, fd = 554509824, user_data = 0x8210d2790}, {pos = 563966984, events = 8, fd = 32, user_data = 0x8210d2780}, {pos = -1891845484, events = 3867, fd = 563937288, user_data = 0x8219d0408}, {pos = 563939336, events = 8, fd = 563940360, user_data = 0x8219d4008}, {pos = 563954696, events = 8, fd = 563955720, user_data = 0x8219d4c08}, {pos = 563957768, events = 8, fd = 563958792, user_data = 0x8219d5808}, {pos = 563960840, events = 8, fd = 563961864, user_data = 0x8219d6408}, {pos = 563963912, events = 8, fd = 563964936, user_data = 0x8219d7008}, {pos = 563966984, events = 8, fd = -1, user_data = 0x82a8c52e0}, {pos = 554510064, events = 8, fd = 713499049, user_data = 0x0}, {pos = 4096, events = 0, fd = -580452790, user_data = 0x82a8c57e8}, {pos = 891329504, events = 8, fd = 160, user_data = 0x0}, {pos = 872218768, events = 8, fd = 554510272, user_data = 0x82a85092c}, {pos = 4096, events = 0, fd = 711924068, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 563993144, user_data = 0x800000001}, {pos = 563966984, events = 8, fd = 711837912, user_data = 0x8210d2848}, {pos = 554509824, events = 8, fd = 32, user_data = 0x82a6edc64}, {pos = 563966984, events = 8, fd = 563993144, user_data = 0x0}, {pos = 2625, events = 0, fd = 554510384, user_data = 0xf1b8f3cb645}, {pos = 711924068, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 563993144, events = 8, fd = 1, user_data = 0x8219d7408}, {pos = 897048576, events = 8, fd = 1, user_data = 0x83577e194}, {pos = 0, events = 0, fd = 554510336, user_data = 0x82a4e3c0c}, {pos = 1, events = 0, fd = 897048576, user_data = 0x8210d2830}, {pos = 709766836, events = 8, fd = 713650528, user_data = 0x82a897160 }, {pos = 712020160, events = 8, fd = 563966984, user_data = 0x8210d2910}, {pos = -1891847124, events = 3867, fd = 872218768, user_data = 0x800000001}, {pos = -1891847506, events = 3867, fd = 12240, user_data = 0x8210d2838}, {pos = 554510608, events = 8, fd = 897755112, user_data = 0x8210d2e80}, {pos = -1891766640, events = 3867, fd = 563966984, user_data = 0x8210d037f}, {pos = 713307548, events = 8, fd = 563937288, user_data = 0x0}, {pos = 563966984, events = 8, fd = 12240, user_data = 0x82a6cd000}, {pos = 1964368, events = 0, fd = 713650528, user_data = 0x82a6edc64}, {pos = 15616, events = 0, fd = 554511792, user_data = 0x8210d2980}, {pos = 712581518, events = 8, fd = 713689144, user_data = 0x8210d2944}, {pos = 897492442, events = 8, fd = 554511792, user_data = 0x8210d2980}, {pos = 712672773, events = 8, fd = 554510658, user_data = 0x8210d2db0}, {pos = 554511792, events = 8, fd = 0, user_data = 0x6dca9efddd66fe4a}, {pos = 554511792, events = 8, fd = 897492440, user_data = 0x8210d2e80}, {pos = 713689144, events = 8, fd = 0, user_data = 0x8210d2df0}, {pos = 712673037, events = 8, fd = 0, user_data = 0x0}, {pos = 554512160, events = 8, fd = 897492440, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1891818487, events = 3867, fd = 554511064, user_data = 0x82a6edc64}, {pos = 2503, events = 0, fd = -1891818487, user_data = 0x8210d2af8}, {pos = 711908452, events = 8, fd = 2758, user_data = 0x82a6e7120}, {pos = 554510968, events = 8, fd = 563966984, user_data = 0x8210d2af8}, {pos = 711880992, events = 8, fd = 554511072, user_data = 0xf1b8f3cd465}, {pos = 0, events = 0, fd = 0, user_data = 0x82a8b90f0}, {pos = 711841104, events = 8, fd = 0, user_data = 0x0}, {pos = 713718192, events = 8, fd = -1891818487, user_data = 0x8210d2b88}, {pos = 711908452, events = 8, fd = 2924, user_data = 0x82a6e73b8}, {pos = 554511112, events = 8, fd = 563966984, user_data = 0x8210d2b88}, {pos = 711881656, events = 8, fd = 554511216, user_data = 0xf1b8f3cd465}, {pos = 563990584, events = 8, fd = 2671913, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 563966984, events = 8, fd = 711841104, user_data = 0x8210d2e48}, {pos = 563966984, events = 8, fd = 554511656, user_data = 0x1e}, {pos = 711845088, events = 8, fd = 554511384, user_data = 0x8219dc248}, {pos = 554511832, events = 8, fd = 554511360, user_data = 0xf1b8f3d1da3}, {pos = 563990584, events = 8, fd = 2695368, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 563990584, user_data = 0x1}} [08:17:32.207] last_touch_time = 1712045674 [08:17:32.207] last_lockfile_recheck_time = 1712045674 [08:17:32.207] nevents = 1 [08:17:32.207] #24 0x000000000084c0b6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8210d35b8) at ../src/backend/postmaster/postmaster.c:1372 [08:17:32.207] userDoption = [08:17:32.207] listen_addr_saved = false [08:17:32.207] output_config_variable = [08:17:32.207] opt = [08:17:32.207] status = [08:17:32.207] #25 0x0000000000787255 in main (argc=8, argv=0x8210d35b8) at ../src/backend/main/main.c:197 [08:17:32.207] do_check_root = [08:17:32.219] [08:17:32.219] [08:17:32.219] [08:17:32.282] dumping /tmp/cores/postgres.8715.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:17:32.411] [New LWP 100139] [08:17:32.479] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [08:17:32.479] Program terminated with signal SIGABRT, Aborted. [08:17:32.479] Sent by thr_kill() from pid 8715 and user 1003. [08:17:32.479] #0 0x000000082aededca in thr_kill () from /lib/libc.so.7 [08:17:33.102] [08:17:33.102] Thread 1 (LWP 100139): [08:17:33.102] #0 0x000000082aededca in thr_kill () from /lib/libc.so.7 [08:17:33.102] No symbol table info available. [08:17:33.102] #1 0x000000082ae576f4 in raise () from /lib/libc.so.7 [08:17:33.102] No symbol table info available. [08:17:33.102] #2 0x000000082af08bc9 in abort () from /lib/libc.so.7 [08:17:33.102] No symbol table info available. [08:17:33.102] #3 0x0000000000a47c57 in ExceptionalCondition (conditionName=, fileName=0x36f9a0 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [08:17:33.102] No locals. [08:17:33.102] #4 0x0000000000732260 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820f233e0, materialize=, shouldFree=shouldFree@entry=0x820f233a6) at ../src/backend/executor/execTuples.c:1737 [08:17:33.102] No locals. [08:17:33.102] #5 0x00000000006f8868 in ExecIRDeleteTriggers (estate=estate@entry=0x8352cc100, relinfo=relinfo@entry=0x8352cc6b0, slot=slot@entry=0x820f233e0) at ../src/backend/commands/trigger.c:2832 [08:17:33.102] trigger = [08:17:33.102] oldtuple = [08:17:33.102] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x842ca53f0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [08:17:33.102] trigdesc = 0x8352cc8c0 [08:17:33.102] newtuple = 0x0 [08:17:33.102] i = 0 [08:17:33.102] should_free = false [08:17:33.102] #6 0x0000000000757487 in ExecMergeMatched (context=0x820f23480, resultRelInfo=0x8352cc6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [08:17:33.102] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [08:17:33.102] relaction = 0x842dac218 [08:17:33.102] commandType = CMD_DELETE [08:17:33.102] result = TM_Ok [08:17:33.102] l__state = {l = 0x842dac7d8, i = 0} [08:17:33.102] mtstate = 0x8352cc4a0 [08:17:33.102] newslot = 0x0 [08:17:33.102] rslot = 0x0 [08:17:33.102] estate = 0x1872b [08:17:33.102] mergeActions = [08:17:33.102] econtext = 0x842dab848 [08:17:33.102] epqstate = 0x8352cc588 [08:17:33.102] actionStates = 0x842dac7d8 [08:17:33.102] l = [08:17:33.102] isNull = [08:17:33.102] lmerge_matched = [08:17:33.102] __error = [08:17:33.102] l__state = [08:17:33.102] updateCxt = [08:17:33.102] relaction = [08:17:33.102] commandType = [08:17:33.102] result = [08:17:33.102] __error = [08:17:33.102] resultRelationDesc = [08:17:33.102] lockmode = [08:17:33.102] inputslot = [08:17:33.102] epqslot = [08:17:33.102] was_matched = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] #7 ExecMerge (context=0x820f23480, resultRelInfo=0x8352cc6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [08:17:33.102] matched = [08:17:33.102] rslot = 0x0 [08:17:33.102] #8 ExecModifyTable (pstate=0x8352cc4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [08:17:33.102] context = {mtstate = 0x8352cc4a0, epqstate = 0x8352cc588, estate = 0x8352cc100, planSlot = 0x842daa368, tmfd = {ctid = {ip_blkid = {bi_hi = 13504, bi_lo = 8434}, ip_posid = 8}, xmax = 1121632424, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x842dd9138} [08:17:33.102] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [08:17:33.102] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8352d6118} [08:17:33.102] node = 0x8352cc4a0 [08:17:33.102] estate = 0x8352cc100 [08:17:33.102] operation = CMD_MERGE [08:17:33.102] resultRelInfo = 0x8352cc6b0 [08:17:33.102] subplanstate = 0x8352cddf0 [08:17:33.102] slot = [08:17:33.102] tupleid = 0x0 [08:17:33.102] oldtuple = 0x0 [08:17:33.102] oldSlot = [08:17:33.102] #9 0x000000000072c29b in ExecProcNodeFirst (node=0x8352cc4a0) at ../src/backend/executor/execProcnode.c:464 [08:17:33.102] No locals. [08:17:33.102] #10 0x000000000072458a in ExecProcNode (node=0x8352cc4a0) at ../src/include/executor/executor.h:274 [08:17:33.102] No locals. [08:17:33.102] #11 ExecutePlan (estate=0x8352cc100, planstate=0x8352cc4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x835159b10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [08:17:33.102] current_tuple_count = [08:17:33.102] slot = [08:17:33.102] #12 standard_ExecutorRun (queryDesc=0x8351db448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [08:17:33.102] estate = 0x8352cc100 [08:17:33.102] oldcontext = 0x835159800 [08:17:33.102] operation = CMD_MERGE [08:17:33.102] dest = 0x835159b10 [08:17:33.102] sendTuples = true [08:17:33.102] #13 0x000000000072443f in ExecutorRun (queryDesc=0x1872b, queryDesc@entry=0x8351db448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [08:17:33.102] No locals. [08:17:33.102] #14 0x00000000008f69ef in ProcessQuery (plan=0x842dd8a20, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820f236b8) at ../src/backend/tcop/pquery.c:160 [08:17:33.102] queryDesc = 0x8351db448 [08:17:33.102] #15 0x00000000008f5f8d in PortalRunMulti (portal=portal@entry=0x8351bb100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x835159b10, altdest=0xb37920 , qc=qc@entry=0x820f236b8) at ../src/backend/tcop/pquery.c:1286 [08:17:33.102] pstmt = 0x842dd8a20 [08:17:33.102] stmtlist_item__state = {l = 0x842ddd2d8, i = 0} [08:17:33.102] active_snapshot_set = true [08:17:33.102] stmtlist_item = 0x842ddd2f0 [08:17:33.102] #16 0x00000000008f5a7c in FillPortalStore (portal=portal@entry=0x8351bb100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:17:33.102] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:17:33.102] treceiver = 0x835159b10 [08:17:33.102] #17 0x00000000008f57d0 in PortalRun (portal=portal@entry=0x8351bb100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x842ddd328, altdest=altdest@entry=0x842ddd328, qc=0x820f237f0) at ../src/backend/tcop/pquery.c:763 [08:17:33.102] _local_sigjmp_buf = {{_sjb = {9394031, 35251085272, 34912483048, 34912483280, 34912483056, 12057320, 12025104, 35250745600, 7112098687, 35250753792, 3565847, 34359738368}}} [08:17:33.102] _save_exception_stack = 0x820f238c0 [08:17:33.102] _save_context_stack = 0x0 [08:17:33.102] _do_rethrow = false [08:17:33.102] saveTopTransactionResourceOwner = 0x83520dfd8 [08:17:33.102] saveTopTransactionContext = 0x83512e000 [08:17:33.102] saveActivePortal = 0x0 [08:17:33.102] saveResourceOwner = 0x83520dfd8 [08:17:33.102] savePortalContext = 0x0 [08:17:33.102] saveMemoryContext = 0x83512e000 [08:17:33.102] result = [08:17:33.102] nprocessed = [08:17:33.102] #18 0x00000000008f46db in exec_simple_query (query_string=query_string@entry=0x835122100 "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:1274 [08:17:33.102] cmdtaglen = [08:17:33.102] snapshot_set = [08:17:33.102] per_parsetree_context = 0x0 [08:17:33.102] plantree_list = [08:17:33.102] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:17:33.102] parsetree = 0x842d79528 [08:17:33.102] commandTag = CMDTAG_MERGE [08:17:33.102] cmdtagname = [08:17:33.102] querytree_list = [08:17:33.102] portal = 0x8351bb100 [08:17:33.102] format = 0 [08:17:33.102] receiver = 0x842ddd328 [08:17:33.102] parsetree_item__state = {l = 0x842d7adf0, i = 0} [08:17:33.102] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [08:17:33.102] dest = DestRemote [08:17:33.102] was_logged = [08:17:33.102] oldcontext = 0x83512e000 [08:17:33.102] parsetree_list = 0x842d7adf0 [08:17:33.102] use_implicit_block = false [08:17:33.102] parsetree_item = 0x842d7ae08 [08:17:33.102] save_log_statement_stats = [08:17:33.102] #19 0x00000000008f24c4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [08:17:33.102] query_string = 0x835122100 "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"... [08:17:33.102] input_message = {data = 0x835122100 "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} [08:17:33.102] firstchar = [08:17:33.102] local_sigjmp_buf = {{_sjb = {9378192, 34912483520, 34912483480, 34912484080, 12066056, 12012528, 8192, 8388608, 72057628950397823, 0, 0, 34359738369}}} [08:17:33.102] send_ready_for_query = false [08:17:33.102] idle_in_transaction_timeout_enabled = false [08:17:33.102] idle_session_timeout_enabled = false [08:17:33.102] #20 0x00000000008ed229 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [08:17:33.102] bsdata = [08:17:33.102] #21 0x0000000000849fc2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820f24600 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f24548) at ../src/backend/postmaster/launch_backend.c:265 [08:17:33.102] pid = [08:17:33.102] #22 0x000000000084e7e1 in BackendStartup (client_sock=0x820f24548) at ../src/backend/postmaster/postmaster.c:3593 [08:17:33.102] startup_data = {canAcceptConnections = CAC_OK} [08:17:33.102] bn = 0x83512e268 [08:17:33.102] pid = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] save_errno = [08:17:33.102] __error = [08:17:33.102] __error = [08:17:33.102] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [08:17:33.102] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "\240E\362 \b\000\000\000\3305Q*\b\000\000\000\v\000\000\000\000\000\000\000\016\266Q*\b", '\000' , "\340E\362 \b\000\000\000\224\235\204\000\000\000\000\000\360E\362 \b", '\000' }, salen = 16}} [08:17:33.102] i = 0 [08:17:33.102] now = [08:17:33.102] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 719092836, events = 8, fd = 552745872, user_data = 0x820f23d20}, {pos = 553620488, events = 8, fd = 32, user_data = 0x820f23d10}, {pos = 1339533972, events = 1623, fd = 553590792, user_data = 0x820ff2408}, {pos = 553592840, events = 8, fd = 553593864, user_data = 0x820ff6008}, {pos = 553608200, events = 8, fd = 553609224, user_data = 0x820ff6c08}, {pos = 553611272, events = 8, fd = 553612296, user_data = 0x820ff7808}, {pos = 553614344, events = 8, fd = 553615368, user_data = 0x820ff8408}, {pos = 553617416, events = 8, fd = 553618440, user_data = 0x820ff9008}, {pos = 553620488, events = 8, fd = 553640072, user_data = 0x820f23e98}, {pos = 552746176, events = 8, fd = 1339559331, user_data = 0x0}, {pos = 2568498, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 553644088, events = 8, fd = 1, user_data = 0x820ff9408}, {pos = 719000744, events = 8, fd = 552746904, user_data = 0x820ff9408}, {pos = 552746160, events = 0, fd = 719108452, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 553646648, user_data = 0x1}, {pos = 553620488, events = 8, fd = 719022296, user_data = 0x820f23dd8}, {pos = 552745872, events = 8, fd = 32, user_data = 0x82adc7c64}, {pos = 553620488, events = 8, fd = 553646648, user_data = 0x0}, {pos = 2625, events = 0, fd = 552746432, user_data = 0x6574fd7a645}, {pos = 719108452, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 553646648, events = 8, fd = 1, user_data = 0x820ff9408}, {pos = 890314752, events = 8, fd = 1, user_data = 0x835112194}, {pos = 0, events = 0, fd = 552746384, user_data = 0x82a51ac0c}, {pos = 1, events = 0, fd = 890314752, user_data = 0x820f23dc0}, {pos = 709992116, events = 8, fd = 720834912, user_data = 0x82af71160 }, {pos = 719204544, events = 8, fd = 553620488, user_data = 0x820f23ea0}, {pos = 1339532332, events = 1623, fd = 553619464, user_data = 0x800000001}, {pos = 1339531950, events = 1623, fd = 12240, user_data = 0x820f23dc8}, {pos = 552746656, events = 8, fd = 891111400, user_data = 0x820f24410}, {pos = 1339612816, events = 1623, fd = 553620488, user_data = 0x820f2037f}, {pos = 720491698, events = 8, fd = 553590792, user_data = 0x0}, {pos = 553620488, events = 8, fd = 12240, user_data = 0x82ada7000}, {pos = 1964368, events = 0, fd = 720834912, user_data = 0x82adc7c64}, {pos = 15616, events = 0, fd = 552747840, user_data = 0x820f23f10}, {pos = 719765902, events = 8, fd = 720873528, user_data = 0x820f23ed4}, {pos = 890766810, events = 8, fd = 552747840, user_data = 0x820f23f10}, {pos = 719857157, events = 8, fd = 552746706, user_data = 0x820f24340}, {pos = 552747840, events = 8, fd = 0, user_data = 0xad4a60428d684fd3}, {pos = 552747840, events = 8, fd = 890766808, user_data = 0x820f24410}, {pos = 720873528, events = 8, fd = 0, user_data = 0x820f24380}, {pos = 719857421, events = 8, fd = 0, user_data = 0x0}, {pos = 552748208, events = 8, fd = 890766808, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1339560969, events = 1623, fd = 552747112, user_data = 0x82adc7c64}, {pos = 2503, events = 0, fd = 1339560969, user_data = 0x820f24088}, {pos = 719092836, events = 8, fd = 2758, user_data = 0x82adc1120}, {pos = 552747016, events = 8, fd = 553620488, user_data = 0x820f24088}, {pos = 719065376, events = 8, fd = 552747120, user_data = 0x6574fd7c465}, {pos = 0, events = 0, fd = 0, user_data = 0x82af930f0}, {pos = 719025488, events = 8, fd = 0, user_data = 0x0}, {pos = 720902576, events = 8, fd = 1339560969, user_data = 0x820f24118}, {pos = 719092836, events = 8, fd = 2924, user_data = 0x82adc13b8}, {pos = 552747160, events = 8, fd = 553620488, user_data = 0x820f24118}, {pos = 719066040, events = 8, fd = 552747264, user_data = 0x6574fd7c465}, {pos = 553644088, events = 8, fd = 2671913, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 553620488, events = 8, fd = 719025488, user_data = 0x820f243d8}, {pos = 553620488, events = 8, fd = 552747704, user_data = 0x1e}, {pos = 719029472, events = 8, fd = 552747432, user_data = 0x820ffe248}, {pos = 552747880, events = 8, fd = 552747408, user_data = 0x6574fd80da3}, {pos = 553644088, events = 8, fd = 2695368, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 553644088, user_data = 0x1}} [08:17:33.102] last_touch_time = 1712045676 [08:17:33.102] last_lockfile_recheck_time = 1712045676 [08:17:33.102] nevents = 1 [08:17:33.102] #24 0x000000000084c0b6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f24b40) at ../src/backend/postmaster/postmaster.c:1372 [08:17:33.102] userDoption = [08:17:33.102] listen_addr_saved = false [08:17:33.102] output_config_variable = [08:17:33.102] opt = [08:17:33.102] status = [08:17:33.102] #25 0x0000000000787255 in main (argc=4, argv=0x820f24b40) at ../src/backend/main/main.c:197 [08:17:33.102] do_check_root = [08:17:33.113] [08:17:33.113] [08:17:33.113] [08:17:33.177] dumping /tmp/cores/postgres.14434.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:17:33.309] [New LWP 100122] [08:17:33.378] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [08:17:33.378] Program terminated with signal SIGABRT, Aborted. [08:17:33.378] Sent by thr_kill() from pid 14434 and user 1003. [08:17:33.378] #0 0x000000082ca5bdca in thr_kill () from /lib/libc.so.7 [08:17:33.999] [08:17:33.999] Thread 1 (LWP 100122): [08:17:33.999] #0 0x000000082ca5bdca in thr_kill () from /lib/libc.so.7 [08:17:33.999] No symbol table info available. [08:17:33.999] #1 0x000000082c9d46f4 in raise () from /lib/libc.so.7 [08:17:33.999] No symbol table info available. [08:17:33.999] #2 0x000000082ca85bc9 in abort () from /lib/libc.so.7 [08:17:33.999] No symbol table info available. [08:17:33.999] #3 0x0000000000a47c57 in ExceptionalCondition (conditionName=, fileName=0x36f9a0 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [08:17:33.999] No locals. [08:17:33.999] #4 0x0000000000732260 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82163b770, materialize=, shouldFree=shouldFree@entry=0x82163b736) at ../src/backend/executor/execTuples.c:1737 [08:17:33.999] No locals. [08:17:33.999] #5 0x00000000006f8868 in ExecIRDeleteTriggers (estate=estate@entry=0x835358100, relinfo=relinfo@entry=0x8353586b0, slot=slot@entry=0x82163b770) at ../src/backend/commands/trigger.c:2832 [08:17:33.999] trigger = [08:17:33.999] oldtuple = [08:17:33.999] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83530cd68, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [08:17:33.999] trigdesc = 0x8353588c0 [08:17:33.999] newtuple = 0x0 [08:17:33.999] i = 0 [08:17:33.999] should_free = false [08:17:33.999] #6 0x0000000000757487 in ExecMergeMatched (context=0x82163b810, resultRelInfo=0x8353586b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [08:17:33.999] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [08:17:33.999] relaction = 0x83c256a58 [08:17:33.999] commandType = CMD_DELETE [08:17:33.999] result = TM_Ok [08:17:33.999] l__state = {l = 0x83c257018, i = 0} [08:17:33.999] mtstate = 0x8353584a0 [08:17:33.999] newslot = 0x0 [08:17:33.999] rslot = 0x0 [08:17:33.999] estate = 0x1871a [08:17:33.999] mergeActions = [08:17:33.999] econtext = 0x83c256088 [08:17:33.999] epqstate = 0x835358588 [08:17:33.999] actionStates = 0x83c257018 [08:17:33.999] l = [08:17:33.999] isNull = [08:17:33.999] lmerge_matched = [08:17:33.999] __error = [08:17:33.999] l__state = [08:17:33.999] updateCxt = [08:17:33.999] relaction = [08:17:33.999] commandType = [08:17:33.999] result = [08:17:33.999] __error = [08:17:33.999] resultRelationDesc = [08:17:33.999] lockmode = [08:17:33.999] inputslot = [08:17:33.999] epqslot = [08:17:33.999] was_matched = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] #7 ExecMerge (context=0x82163b810, resultRelInfo=0x8353586b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [08:17:33.999] matched = [08:17:33.999] rslot = 0x0 [08:17:33.999] #8 ExecModifyTable (pstate=0x8353584a0) at ../src/backend/executor/nodeModifyTable.c:4067 [08:17:33.999] context = {mtstate = 0x8353584a0, epqstate = 0x835358588, estate = 0x835358100, planSlot = 0x83c254ba8, tmfd = {ctid = {ip_blkid = {bi_hi = 7637, bi_lo = 312}, ip_posid = 12640}, xmax = 4, cmax = 0, traversed = false}, cpUpdateReturningSlot = 0x82163b970} [08:17:33.999] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [08:17:33.999] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83537c118} [08:17:33.999] node = 0x8353584a0 [08:17:33.999] estate = 0x835358100 [08:17:33.999] operation = CMD_MERGE [08:17:33.999] resultRelInfo = 0x8353586b0 [08:17:33.999] subplanstate = 0x835359df0 [08:17:33.999] slot = [08:17:33.999] tupleid = 0x0 [08:17:33.999] oldtuple = 0x0 [08:17:33.999] oldSlot = [08:17:33.999] #9 0x000000000072c29b in ExecProcNodeFirst (node=0x8353584a0) at ../src/backend/executor/execProcnode.c:464 [08:17:33.999] No locals. [08:17:33.999] #10 0x000000000072458a in ExecProcNode (node=0x8353584a0) at ../src/include/executor/executor.h:274 [08:17:33.999] No locals. [08:17:33.999] #11 ExecutePlan (estate=0x835358100, planstate=0x8353584a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x835344710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [08:17:33.999] current_tuple_count = [08:17:33.999] slot = [08:17:33.999] #12 standard_ExecutorRun (queryDesc=0x83526d448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [08:17:33.999] estate = 0x835358100 [08:17:33.999] oldcontext = 0x835344400 [08:17:33.999] operation = CMD_MERGE [08:17:33.999] dest = 0x835344710 [08:17:33.999] sendTuples = true [08:17:33.999] #13 0x000000083862b963 in pgss_ExecutorRun (queryDesc=0x83526d448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [08:17:33.999] _local_sigjmp_buf = {{_sjb = {35305732402, 12057320, 34919922024, 34919922192, 35251475528, 34919922032, 1, 1, 35252405119, 35251475528, 12066048, 34359738368}}} [08:17:33.999] _save_exception_stack = 0x82163bb30 [08:17:33.999] _save_context_stack = 0x0 [08:17:33.999] _do_rethrow = false [08:17:33.999] #14 0x0000000000724438 in ExecutorRun (queryDesc=0x1871a, queryDesc@entry=0x83526d448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [08:17:33.999] No locals. [08:17:33.999] #15 0x00000000008f69ef in ProcessQuery (plan=0x83c23f058, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82163baf8) at ../src/backend/tcop/pquery.c:160 [08:17:33.999] queryDesc = 0x83526d448 [08:17:33.999] #16 0x00000000008f5f8d in PortalRunMulti (portal=portal@entry=0x83524f100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x835344710, altdest=0xb37920 , qc=qc@entry=0x82163baf8) at ../src/backend/tcop/pquery.c:1286 [08:17:33.999] pstmt = 0x83c23f058 [08:17:33.999] stmtlist_item__state = {l = 0x83c243910, i = 0} [08:17:33.999] active_snapshot_set = true [08:17:33.999] stmtlist_item = 0x83c243928 [08:17:33.999] #17 0x00000000008f5a7c in FillPortalStore (portal=portal@entry=0x83524f100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:17:33.999] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:17:33.999] treceiver = 0x835344710 [08:17:33.999] #18 0x00000000008f57d0 in PortalRun (portal=portal@entry=0x83524f100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83c243960, altdest=altdest@entry=0x83c243960, qc=0x82163bc30) at ../src/backend/tcop/pquery.c:763 [08:17:33.999] _local_sigjmp_buf = {{_sjb = {9394031, 35251684248, 34919922472, 34919922704, 34919922480, 12057320, 12025104, 35251351808, 7112098687, 35251360000, 3565847, 34359738368}}} [08:17:33.999] _save_exception_stack = 0x82163bd00 [08:17:33.999] _save_context_stack = 0x0 [08:17:33.999] _do_rethrow = false [08:17:33.999] saveTopTransactionResourceOwner = 0x8352a0398 [08:17:33.999] saveTopTransactionContext = 0x8351c0000 [08:17:33.999] saveActivePortal = 0x0 [08:17:33.999] saveResourceOwner = 0x8352a0398 [08:17:33.999] savePortalContext = 0x0 [08:17:33.999] saveMemoryContext = 0x8351c0000 [08:17:33.999] result = [08:17:33.999] nprocessed = [08:17:33.999] #19 0x00000000008f46db in exec_simple_query (query_string=query_string@entry=0x8351b4100 "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:1274 [08:17:33.999] cmdtaglen = [08:17:33.999] snapshot_set = [08:17:33.999] per_parsetree_context = 0x0 [08:17:33.999] plantree_list = [08:17:33.999] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:17:33.999] parsetree = 0x83c1f5de8 [08:17:33.999] commandTag = CMDTAG_MERGE [08:17:33.999] cmdtagname = [08:17:33.999] querytree_list = [08:17:33.999] portal = 0x83524f100 [08:17:33.999] format = 0 [08:17:33.999] receiver = 0x83c243960 [08:17:33.999] parsetree_item__state = {l = 0x83c1f76b0, i = 0} [08:17:33.999] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [08:17:33.999] dest = DestRemote [08:17:33.999] was_logged = [08:17:33.999] oldcontext = 0x8351c0000 [08:17:33.999] parsetree_list = 0x83c1f76b0 [08:17:33.999] use_implicit_block = false [08:17:33.999] parsetree_item = 0x83c1f76c8 [08:17:33.999] save_log_statement_stats = [08:17:33.999] #20 0x00000000008f24c4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [08:17:33.999] query_string = 0x8351b4100 "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"... [08:17:33.999] input_message = {data = 0x8351b4100 "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} [08:17:33.999] firstchar = [08:17:33.999] local_sigjmp_buf = {{_sjb = {9378192, 34919922944, 34919922904, 34919923504, 12066056, 12012528, 8192, 8388608, 72057628957803391, 0, 0, 1}}} [08:17:33.999] send_ready_for_query = false [08:17:33.999] idle_in_transaction_timeout_enabled = false [08:17:33.999] idle_session_timeout_enabled = false [08:17:33.999] #21 0x00000000008ed229 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [08:17:33.999] bsdata = [08:17:33.999] #22 0x0000000000849fc2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82163ca40 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82163c988) at ../src/backend/postmaster/launch_backend.c:265 [08:17:33.999] pid = [08:17:33.999] #23 0x000000000084e7e1 in BackendStartup (client_sock=0x82163c988) at ../src/backend/postmaster/postmaster.c:3593 [08:17:33.999] startup_data = {canAcceptConnections = CAC_OK} [08:17:33.999] bn = 0x8351c0538 [08:17:33.999] pid = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] save_errno = [08:17:33.999] __error = [08:17:33.999] __error = [08:17:33.999] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [08:17:33.999] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "\340\311c!\b\000\000\000\330%;+\b\000\000\000\v\000\000\000\000\000\000\000\016\246;+\b", '\000' , " \312c!\b\000\000\000\224\235\204\000\000\000\000\0000\312c!\b", '\000' }, salen = 16}} [08:17:33.999] i = 0 [08:17:33.999] now = [08:17:33.999] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 572072968, user_data = 0x0}, {pos = 560185680, events = 8, fd = -2063246700, user_data = 0x82218b008}, {pos = 572044296, events = 8, fd = 572045320, user_data = 0x82218bc08}, {pos = 572059656, events = 8, fd = 572060680, user_data = 0x82218f808}, {pos = 572062728, events = 8, fd = 572063752, user_data = 0x822190408}, {pos = 572065800, events = 8, fd = 572066824, user_data = 0x822191008}, {pos = 572068872, events = 8, fd = 572069896, user_data = 0x822191c08}, {pos = 572071944, events = 8, fd = 572072968, user_data = 0x822197088}, {pos = 560186072, events = 8, fd = 560185584, user_data = 0x251a8505bda3}, {pos = 572072968, events = 8, fd = 2568498, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 572096568, user_data = 0x1}, {pos = 572072968, events = 8, fd = 747824296, user_data = 0x82163c3d8}, {pos = 572072968, events = 8, fd = 560185552, user_data = 0x27307c}, {pos = 560186144, events = 8, fd = 747932004, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 572099128, user_data = 0x251a00000001}, {pos = 572072968, events = 8, fd = 747845848, user_data = 0x82163c218}, {pos = 560185280, events = 8, fd = 33, user_data = 0x82c944c64}, {pos = 572072968, events = 8, fd = 572099128, user_data = 0x0}, {pos = 2625, events = 0, fd = 560185856, user_data = 0x251a85055645}, {pos = 747932004, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 572099128, events = 8, fd = 1, user_data = 0x822192408}, {pos = 890912768, events = 8, fd = 1, user_data = 0x8351a4194}, {pos = 0, events = 0, fd = 560185808, user_data = 0x82b3b9c0c}, {pos = 1, events = 0, fd = 890912768, user_data = 0x82163c200}, {pos = 725323444, events = 8, fd = 749658464, user_data = 0x82caee160 }, {pos = 748028096, events = 8, fd = 572072968, user_data = 0x82163c2e0}, {pos = -2063248340, events = 9498, fd = 80627796, user_data = 0x1}, {pos = -2063248722, events = 9498, fd = 12240, user_data = 0x82163c208}, {pos = 560186080, events = 8, fd = 891709416, user_data = 0x82163c850}, {pos = -2063167856, events = 9498, fd = 572072968, user_data = 0x82163037f}, {pos = 749315250, events = 8, fd = 560186384, user_data = 0x251a00000000}, {pos = 572072968, events = 8, fd = 12240, user_data = 0x82c924000}, {pos = 1964368, events = 0, fd = 749658464, user_data = 0x82c944c64}, {pos = 15616, events = 0, fd = 560187264, user_data = 0x82163c350}, {pos = 748589454, events = 8, fd = 749697080, user_data = 0x82163c314}, {pos = 891364826, events = 8, fd = 560187264, user_data = 0x82163c350}, {pos = 748680709, events = 8, fd = 560186130, user_data = 0x82163c780}, {pos = 560187264, events = 8, fd = 0, user_data = 0xf06d316001381dd5}, {pos = 560187264, events = 8, fd = 891364824, user_data = 0x82163c850}, {pos = 749697080, events = 8, fd = 0, user_data = 0x82163c7c0}, {pos = 748680973, events = 8, fd = 0, user_data = 0x0}, {pos = 560187632, events = 8, fd = 891364824, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2063219703, user_data = 0x82163c498}, {pos = 747916388, events = 8, fd = 2503, user_data = 0x251a8505c409}, {pos = 560186552, events = 8, fd = 747916388, user_data = 0xac6}, {pos = 747888928, events = 8, fd = 560186424, user_data = 0x822192408}, {pos = 560186552, events = 8, fd = 747888928, user_data = 0x82163c4a0}, {pos = -2063240091, events = 9498, fd = 0, user_data = 0x800000000}, {pos = 560186512, events = 8, fd = 747849040, user_data = 0x0}, {pos = 0, events = 0, fd = 560186480, user_data = 0x251a8505c409}, {pos = 560186696, events = 8, fd = 747916388, user_data = 0xb6c}, {pos = 747889592, events = 8, fd = 560186568, user_data = 0x822192408}, {pos = 560186696, events = 8, fd = 747889592, user_data = 0x82163c530}, {pos = -2063240091, events = 9498, fd = 572096568, user_data = 0x28c529}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 572072968, user_data = 0x82c934550}, {pos = 560187416, events = 8, fd = 572072968, user_data = 0x2163c6f8}, {pos = 31, events = 0, fd = 0, user_data = 0x82163c5d8}, {pos = 572094344, events = 8, fd = 560187304, user_data = 0x82163c5c0}, {pos = -2063221341, events = 9498, fd = 572096568, user_data = 0x2920c8}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822198038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [08:17:33.999] last_touch_time = 1712045698 [08:17:33.999] last_lockfile_recheck_time = 1712045698 [08:17:33.999] nevents = 1 [08:17:33.999] #25 0x000000000084c0b6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82163cf80) at ../src/backend/postmaster/postmaster.c:1372 [08:17:33.999] userDoption = [08:17:33.999] listen_addr_saved = false [08:17:33.999] output_config_variable = [08:17:33.999] opt = [08:17:33.999] status = [08:17:33.999] #26 0x0000000000787255 in main (argc=4, argv=0x82163cf80) at ../src/backend/main/main.c:197 [08:17:33.999] do_check_root =