[12:06:29.355] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [12:06:29.738] dumping /tmp/cores/postgres.8314.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [12:06:29.875] [New LWP 101756] [12:06:29.961] Core was generated by `postgres: postgres regression [local] MERGE'. [12:06:29.961] Program terminated with signal SIGABRT, Aborted. [12:06:29.961] Sent by thr_kill() from pid 8314 and user 1003. [12:06:29.961] #0 0x000000082c05741a in thr_kill () from /lib/libc.so.7 [12:06:30.675] [12:06:30.675] Thread 1 (LWP 101756): [12:06:30.675] #0 0x000000082c05741a in thr_kill () from /lib/libc.so.7 [12:06:30.675] No symbol table info available. [12:06:30.675] #1 0x000000082bfd0e64 in raise () from /lib/libc.so.7 [12:06:30.675] No symbol table info available. [12:06:30.675] #2 0x000000082c0816f9 in abort () from /lib/libc.so.7 [12:06:30.675] No symbol table info available. [12:06:30.675] #3 0x0000000000a8acc5 in ExceptionalCondition (conditionName=0x2d0889 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [12:06:30.675] No locals. [12:06:30.675] #4 0x000000000076e2bf in ExecFetchSlotHeapTuple (slot=0x8216d6710, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [12:06:30.675] No locals. [12:06:30.675] #5 0x0000000000732f77 in ExecIRDeleteTriggers (estate=estate@entry=0x832b9b100, relinfo=relinfo@entry=0x832b9b6b0, slot=slot@entry=0x8216d6710) at ../src/backend/commands/trigger.c:2841 [12:06:30.675] trigger = [12:06:30.675] oldtuple = [12:06:30.675] should_free = false [12:06:30.675] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x835538748, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [12:06:30.675] trigdesc = 0x832b9b8c0 [12:06:30.675] newtuple = 0x0 [12:06:30.675] i = 0 [12:06:30.675] #6 0x0000000000793497 in ExecMergeMatched (context=0x8216d67b8, resultRelInfo=0x832b9b6b0, tupleid=0x0, oldtuple=0x8216d6710, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [12:06:30.675] result = TM_Ok [12:06:30.675] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [12:06:30.675] relaction = 0x8356881f8 [12:06:30.675] commandType = CMD_DELETE [12:06:30.675] l__state = {l = 0x8356887b8, i = 0} [12:06:30.675] mtstate = 0x832b9b4a0 [12:06:30.675] newslot = 0x0 [12:06:30.675] rslot = 0x0 [12:06:30.675] estate = 0x832b9b100 [12:06:30.675] mergeActions = [12:06:30.675] econtext = 0x835687828 [12:06:30.675] epqstate = 0x832b9b588 [12:06:30.675] actionStates = 0x8356887b8 [12:06:30.675] l = [12:06:30.675] isNull = [12:06:30.675] lmerge_matched = [12:06:30.675] __error = [12:06:30.675] l__state = [12:06:30.675] result = [12:06:30.675] updateCxt = [12:06:30.675] relaction = [12:06:30.675] commandType = [12:06:30.675] __error = [12:06:30.675] resultRelationDesc = [12:06:30.675] lockmode = [12:06:30.675] inputslot = [12:06:30.675] epqslot = [12:06:30.675] was_matched = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] #7 ExecMerge (context=0x8216d67b8, resultRelInfo=0x832b9b6b0, tupleid=0x0, oldtuple=0x8216d6710, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [12:06:30.675] matched = [12:06:30.675] rslot = 0x0 [12:06:30.675] #8 ExecModifyTable (pstate=0x832b9b4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [12:06:30.675] context = {mtstate = 0x832b9b4a0, epqstate = 0x832b9b588, estate = 0x832b9b100, planSlot = 0x835613c30, tmfd = {ctid = {ip_blkid = {bi_hi = 10400, bi_lo = 13675}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x832b9b6b0} [12:06:30.675] tuple_ctid = {ip_blkid = {bi_hi = 57888, bi_lo = 13936}, ip_posid = 8} [12:06:30.675] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835569118} [12:06:30.675] node = 0x832b9b4a0 [12:06:30.675] estate = 0x832b9b100 [12:06:30.675] operation = CMD_MERGE [12:06:30.675] resultRelInfo = 0x832b9b6b0 [12:06:30.675] subplanstate = 0x832b9cdf0 [12:06:30.675] slot = [12:06:30.675] tupleid = 0x0 [12:06:30.675] oldtuple = 0x8216d6710 [12:06:30.675] oldSlot = [12:06:30.675] #9 0x000000000076052b in ExecProcNode (node=0x832b9b4a0) at ../src/include/executor/executor.h:278 [12:06:30.675] No locals. [12:06:30.675] #10 ExecutePlan (estate=0x832b9b100, planstate=0x832b9b4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x832b89b10, execute_once=) at ../src/backend/executor/execMain.c:1641 [12:06:30.675] current_tuple_count = 0 [12:06:30.675] slot = [12:06:30.675] #11 standard_ExecutorRun (queryDesc=0x832b90448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [12:06:30.675] estate = 0x832b9b100 [12:06:30.675] oldcontext = 0x832b89800 [12:06:30.675] operation = CMD_MERGE [12:06:30.675] dest = 0x832b89b10 [12:06:30.675] sendTuples = true [12:06:30.675] #12 0x0000000000935e7f in ProcessQuery (plan=0x8356b2188, sourceText=, params=0x0, queryEnv=0x0, dest=0x832b89b10, qc=0x8216d69b8) at ../src/backend/tcop/pquery.c:160 [12:06:30.675] queryDesc = 0x832b90448 [12:06:30.675] #13 0x000000000093541d in PortalRunMulti (portal=portal@entry=0x832aba100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x832b89b10, altdest=0xb7c820 , qc=qc@entry=0x8216d69b8) at ../src/backend/tcop/pquery.c:1287 [12:06:30.675] pstmt = 0x8356b2188 [12:06:30.675] stmtlist_item__state = {l = 0x8356b6a40, i = 0} [12:06:30.675] active_snapshot_set = true [12:06:30.675] stmtlist_item = 0x8356b6a58 [12:06:30.675] #14 0x0000000000934f2c in FillPortalStore (portal=portal@entry=0x832aba100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [12:06:30.675] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:06:30.675] treceiver = 0x832b89b10 [12:06:30.675] #15 0x0000000000934c9b in PortalRun (portal=portal@entry=0x832aba100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8356b6a90, altdest=altdest@entry=0x8356b6a90, qc=0x8216d6af0) at ../src/backend/tcop/pquery.c:763 [12:06:30.675] _local_sigjmp_buf = {{_sjb = {9653309, 35209847040, 34920557032, 34920557264, 34920557040, 35209867264, 12310472, 12343800, 35209806719, 35208974592, 4294967984, 0}}} [12:06:30.675] _save_exception_stack = 0x8216d6bc0 [12:06:30.675] _save_context_stack = 0x0 [12:06:30.675] _do_rethrow = false [12:06:30.675] saveTopTransactionResourceOwner = 0x832acc418 [12:06:30.675] saveTopTransactionContext = 0x832abf000 [12:06:30.675] saveActivePortal = 0x0 [12:06:30.675] saveResourceOwner = 0x832acc418 [12:06:30.675] savePortalContext = 0x0 [12:06:30.675] saveMemoryContext = 0x832abf000 [12:06:30.675] result = [12:06:30.675] nprocessed = [12:06:30.675] #16 0x0000000000933b62 in exec_simple_query (query_string=query_string@entry=0x8329e5100 "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 [12:06:30.675] cmdtaglen = 5 [12:06:30.675] snapshot_set = [12:06:30.675] per_parsetree_context = 0x0 [12:06:30.675] plantree_list = [12:06:30.675] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:06:30.675] format = 0 [12:06:30.675] parsetree = 0x8356595a8 [12:06:30.675] commandTag = [12:06:30.675] cmdtagname = [12:06:30.675] querytree_list = [12:06:30.675] portal = 0x832aba100 [12:06:30.675] receiver = 0x8356b6a90 [12:06:30.675] parsetree_item__state = {l = 0x83565ae70, i = 0} [12:06:30.675] msec_str = "\000\000\000\000\b", '\000' , "\273\206\341f\000\000\000\000?\323u\342\344\215\332", [12:06:30.675] dest = DestRemote [12:06:30.675] was_logged = [12:06:30.675] oldcontext = 0x832abf000 [12:06:30.675] parsetree_list = 0x83565ae70 [12:06:30.675] use_implicit_block = false [12:06:30.675] parsetree_item = 0x83565ae88 [12:06:30.675] save_log_statement_stats = [12:06:30.675] #17 0x00000000009318d0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [12:06:30.675] query_string = 0x8329e5100 "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"... [12:06:30.675] input_message = {data = 0x8329e5100 "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} [12:06:30.675] firstchar = [12:06:30.675] local_sigjmp_buf = {{_sjb = {9637222, 34920557504, 34920557464, 34920558048, 12352536, 1, 8192, 8388608, 34920530815, 0, 0, 1}}} [12:06:30.675] send_ready_for_query = false [12:06:30.675] idle_in_transaction_timeout_enabled = false [12:06:30.675] idle_session_timeout_enabled = false [12:06:30.675] #18 0x000000000092c0a9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:06:30.675] bsdata = [12:06:30.675] #19 0x0000000000886237 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8216d7904 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8216d7840) at ../src/backend/postmaster/launch_backend.c:274 [12:06:30.675] pid = [12:06:30.675] #20 0x000000000088a5f8 in BackendStartup (client_sock=0x8216d7840) at ../src/backend/postmaster/postmaster.c:3415 [12:06:30.675] startup_data = {canAcceptConnections = CAC_OK} [12:06:30.675] bn = 0x8329f13a8 [12:06:30.675] pid = [12:06:30.675] __error = [12:06:30.675] save_errno = [12:06:30.675] __error = [12:06:30.675] __error = [12:06:30.675] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [12:06:30.675] 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 = "\000o\2362\b", '\000' , "\240xm!\b\000\000\000h\245\321)\b\000\000\000\v\000\000\000\000\000\000\000^/\322)\b", '\000' , "\340xm!\b\000\000\000\344_\210\000\000\000\000\000\360xm!\b", '\000' }, salen = 16}} [12:06:30.675] i = 0 [12:06:30.675] now = [12:06:30.675] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 738180226, events = 8, fd = 0, user_data = 0x8216d77f0}, {pos = 849634776, events = 8, fd = 560821888, user_data = 0x0}, {pos = 0, events = 0, fd = -972754385, user_data = 0xba7a52730a}, {pos = 737347488, events = 8, fd = 737418616, user_data = 0x8216d7308}, {pos = 560821120, events = 8, fd = 560821000, user_data = 0xba7a52730a}, {pos = 737325960, events = 8, fd = 737418616, user_data = 0x8216d7338}, {pos = 560821168, events = 8, fd = 560821048, user_data = 0x82bf3a194}, {pos = 569865224, events = 8, fd = 737386900, user_data = 0x8216d73a0}, {pos = 2052203578, events = 186, fd = 739209264, user_data = 0x1}, {pos = 560821200, events = 8, fd = 2052223754, user_data = 0x82bf23858}, {pos = 737418616, events = 8, fd = 560821160, user_data = 0x8216d7420}, {pos = 560821160, events = 8, fd = 737381644, user_data = 0x821f77408}, {pos = 737381644, events = 8, fd = 560821264, user_data = 0xba7a52243a}, {pos = 560821304, events = 8, fd = 560821752, user_data = 0x8216d7420}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 4208713557, fd = 569888824, user_data = 0x800000001}, {pos = 569865224, events = 8, fd = 737325960, user_data = 0x821f7c288}, {pos = 737294424, events = 8, fd = 569865224, user_data = 0x8216d74a8}, {pos = 560821864, events = 8, fd = 560821392, user_data = 0xba7a526ca2}, {pos = 2699918, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 569888824, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 560822120, user_data = 0x21f77408}, {pos = 560821936, events = 8, fd = 560821536, user_data = 0x1}, {pos = 560821864, events = 8, fd = 32, user_data = 0x8216d7510}, {pos = 2052221555, events = 186, fd = 560821808, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821f7d038}, {pos = 1, events = 8, fd = 569865224, user_data = 0x82bf23858}, {pos = 560822120, events = 8, fd = 560821936, user_data = 0x8216d7520}, {pos = 0, events = 0, fd = 569835528, user_data = 0x20}, {pos = 560821920, events = 8, fd = 2052197095, user_data = 0x821f70008}, {pos = 569836552, events = 8, fd = 569837576, user_data = 0x821f70c08}, {pos = 569851912, events = 8, fd = 569852936, user_data = 0x821f74808}, {pos = 569854984, events = 8, fd = 569856008, user_data = 0x821f75408}, {pos = 569858056, events = 8, fd = 569859080, user_data = 0x821f76008}, {pos = 569861128, events = 8, fd = 569862152, user_data = 0x821f76c08}, {pos = 569864200, events = 8, fd = 569865224, user_data = 0x821f77808}, {pos = 569867272, events = 8, fd = 569868296, user_data = 0x821f78408}, {pos = 569870344, events = 8, fd = 569871368, user_data = 0x821f79008}, {pos = 569873416, events = 8, fd = 569874440, user_data = 0x821f79c08}, {pos = 569880584, events = 8, fd = 569881608, user_data = 0x821f7b808}, {pos = 569883656, events = 8, fd = 569835528, user_data = 0x29328e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821f7d038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 560822120, events = 8, fd = 560821536, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 569888824, user_data = 0x1}, {pos = 569835528, events = 8, fd = 313, user_data = 0x8216d7750}, {pos = 2052195823, events = 186, fd = 2699918, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 569888824, user_data = 0x1}, {pos = 569865224, events = 8, fd = 849170432, user_data = 0x1}, {pos = 849170836, events = 8, fd = 0, user_data = 0x8216d7720}, {pos = 701637996, events = 8, fd = 1, user_data = 0x8329d5000}, {pos = 560822096, events = 8, fd = 701634306, user_data = 0x82c055170 }, {pos = 12277568, events = 0, fd = 738546032, user_data = 0x821f77408}, {pos = 560822320, events = 8, fd = 2052195294, user_data = 0x8329f3800}, {pos = 1, events = 0, fd = 2052194910, user_data = 0x821f70008}, {pos = 560822104, events = 8, fd = 560822320, user_data = 0x1c20}, {pos = 849243904, events = 8, fd = 2052274576, user_data = 0x0}, {pos = 560792447, events = 8, fd = 8087767, user_data = 0x8216d77e0}, {pos = 701596688, events = 8, fd = 739209264, user_data = 0x82c0f9310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8216d7810}, {pos = 701639581, events = 8, fd = 849170432, user_data = 0x18cc}, {pos = 560822384, events = 8, fd = 701606138, user_data = 0x0}, {pos = 0, events = 0, fd = -972754385, user_data = 0x0}} [12:06:30.675] last_touch_time = 1726056112 [12:06:30.675] last_lockfile_recheck_time = 1726056112 [12:06:30.675] nevents = 1 [12:06:30.675] #22 0x0000000000888415 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8216d7e58) at ../src/backend/postmaster/postmaster.c:1346 [12:06:30.675] userDoption = [12:06:30.675] listen_addr_saved = [12:06:30.675] output_config_variable = [12:06:30.675] opt = [12:06:30.675] status = [12:06:30.675] #23 0x00000000007c35bc in main (argc=8, argv=0x8216d7e58) at ../src/backend/main/main.c:197 [12:06:30.675] do_check_root = [12:06:30.690] [12:06:30.690] [12:06:30.690] [12:06:30.761] dumping /tmp/cores/postgres.8540.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:06:30.888] [New LWP 101681] [12:06:30.954] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [12:06:30.954] Program terminated with signal SIGABRT, Aborted. [12:06:30.954] Sent by thr_kill() from pid 8540 and user 1003. [12:06:30.954] #0 0x000000082b78841a in thr_kill () from /lib/libc.so.7 [12:06:31.641] [12:06:31.641] Thread 1 (LWP 101681): [12:06:31.641] #0 0x000000082b78841a in thr_kill () from /lib/libc.so.7 [12:06:31.641] No symbol table info available. [12:06:31.641] #1 0x000000082b701e64 in raise () from /lib/libc.so.7 [12:06:31.641] No symbol table info available. [12:06:31.641] #2 0x000000082b7b26f9 in abort () from /lib/libc.so.7 [12:06:31.641] No symbol table info available. [12:06:31.641] #3 0x0000000000a8acc5 in ExceptionalCondition (conditionName=0x2d0889 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [12:06:31.641] No locals. [12:06:31.641] #4 0x000000000076e2bf in ExecFetchSlotHeapTuple (slot=0x82109b7d0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [12:06:31.641] No locals. [12:06:31.641] #5 0x0000000000732f77 in ExecIRDeleteTriggers (estate=estate@entry=0x835ee7100, relinfo=relinfo@entry=0x835ee76b0, slot=slot@entry=0x82109b7d0) at ../src/backend/commands/trigger.c:2841 [12:06:31.641] trigger = [12:06:31.641] oldtuple = [12:06:31.641] should_free = false [12:06:31.641] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x837b9e750, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [12:06:31.641] trigdesc = 0x835ee78c0 [12:06:31.641] newtuple = 0x0 [12:06:31.641] i = 0 [12:06:31.641] #6 0x0000000000793497 in ExecMergeMatched (context=0x82109b878, resultRelInfo=0x835ee76b0, tupleid=0x0, oldtuple=0x82109b7d0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [12:06:31.641] result = TM_Ok [12:06:31.641] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [12:06:31.641] relaction = 0x837cddeb8 [12:06:31.641] commandType = CMD_DELETE [12:06:31.641] l__state = {l = 0x837cde478, i = 0} [12:06:31.641] mtstate = 0x835ee74a0 [12:06:31.641] newslot = 0x0 [12:06:31.641] rslot = 0x0 [12:06:31.641] estate = 0x835ee7100 [12:06:31.641] mergeActions = [12:06:31.641] econtext = 0x837cdd4e8 [12:06:31.641] epqstate = 0x835ee7588 [12:06:31.641] actionStates = 0x837cde478 [12:06:31.641] l = [12:06:31.641] isNull = [12:06:31.641] lmerge_matched = [12:06:31.641] __error = [12:06:31.641] l__state = [12:06:31.641] result = [12:06:31.641] updateCxt = [12:06:31.641] relaction = [12:06:31.641] commandType = [12:06:31.641] __error = [12:06:31.641] resultRelationDesc = [12:06:31.641] lockmode = [12:06:31.641] inputslot = [12:06:31.641] epqslot = [12:06:31.641] was_matched = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] #7 ExecMerge (context=0x82109b878, resultRelInfo=0x835ee76b0, tupleid=0x0, oldtuple=0x82109b7d0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [12:06:31.641] matched = [12:06:31.641] rslot = 0x0 [12:06:31.641] #8 ExecModifyTable (pstate=0x835ee74a0) at ../src/backend/executor/nodeModifyTable.c:4133 [12:06:31.641] context = {mtstate = 0x835ee74a0, epqstate = 0x835ee7588, estate = 0x835ee7100, planSlot = 0x837c5fff0, tmfd = {ctid = {ip_blkid = {bi_hi = 20384, bi_lo = 14284}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x835ee76b0} [12:06:31.641] tuple_ctid = {ip_blkid = {bi_hi = 13456, bi_lo = 17371}, ip_posid = 8} [12:06:31.641] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835ef3118} [12:06:31.641] node = 0x835ee74a0 [12:06:31.641] estate = 0x835ee7100 [12:06:31.641] operation = CMD_MERGE [12:06:31.641] resultRelInfo = 0x835ee76b0 [12:06:31.641] subplanstate = 0x835ee8df0 [12:06:31.641] slot = [12:06:31.641] tupleid = 0x0 [12:06:31.641] oldtuple = 0x82109b7d0 [12:06:31.641] oldSlot = [12:06:31.641] #9 0x000000000076052b in ExecProcNode (node=0x835ee74a0) at ../src/include/executor/executor.h:278 [12:06:31.641] No locals. [12:06:31.641] #10 ExecutePlan (estate=0x835ee7100, planstate=0x835ee74a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x835d74f10, execute_once=) at ../src/backend/executor/execMain.c:1641 [12:06:31.641] current_tuple_count = 0 [12:06:31.641] slot = [12:06:31.641] #11 standard_ExecutorRun (queryDesc=0x835d7cc48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [12:06:31.641] estate = 0x835ee7100 [12:06:31.641] oldcontext = 0x835d74c00 [12:06:31.641] operation = CMD_MERGE [12:06:31.641] dest = 0x835d74f10 [12:06:31.641] sendTuples = true [12:06:31.641] #12 0x0000000000935e7f in ProcessQuery (plan=0x837cc4888, sourceText=, params=0x0, queryEnv=0x0, dest=0x835d74f10, qc=0x82109ba78) at ../src/backend/tcop/pquery.c:160 [12:06:31.641] queryDesc = 0x835d7cc48 [12:06:31.641] #13 0x000000000093541d in PortalRunMulti (portal=portal@entry=0x835dc3100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x835d74f10, altdest=0xb7c820 , qc=qc@entry=0x82109ba78) at ../src/backend/tcop/pquery.c:1287 [12:06:31.641] pstmt = 0x837cc4888 [12:06:31.641] stmtlist_item__state = {l = 0x837cc9140, i = 0} [12:06:31.641] active_snapshot_set = true [12:06:31.641] stmtlist_item = 0x837cc9158 [12:06:31.641] #14 0x0000000000934f2c in FillPortalStore (portal=portal@entry=0x835dc3100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [12:06:31.641] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:06:31.641] treceiver = 0x835d74f10 [12:06:31.641] #15 0x0000000000934c9b in PortalRun (portal=portal@entry=0x835dc3100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x837cc9190, altdest=altdest@entry=0x837cc9190, qc=0x82109bbb0) at ../src/backend/tcop/pquery.c:763 [12:06:31.641] _local_sigjmp_buf = {{_sjb = {9653309, 35263361280, 34914024104, 34914024336, 34914024112, 35263377408, 12310472, 12343800, 35263349631, 35262689536, 4294967984, 0}}} [12:06:31.641] _save_exception_stack = 0x82109bc80 [12:06:31.641] _save_context_stack = 0x0 [12:06:31.641] _do_rethrow = false [12:06:31.641] saveTopTransactionResourceOwner = 0x835e13018 [12:06:31.641] saveTopTransactionContext = 0x835dc7000 [12:06:31.641] saveActivePortal = 0x0 [12:06:31.641] saveResourceOwner = 0x835e13018 [12:06:31.641] savePortalContext = 0x0 [12:06:31.641] saveMemoryContext = 0x835dc7000 [12:06:31.641] result = [12:06:31.641] nprocessed = [12:06:31.641] #16 0x0000000000933b62 in exec_simple_query (query_string=query_string@entry=0x835d1f100 "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 [12:06:31.641] cmdtaglen = 5 [12:06:31.641] snapshot_set = [12:06:31.641] per_parsetree_context = 0x0 [12:06:31.641] plantree_list = [12:06:31.641] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:06:31.641] format = 0 [12:06:31.641] parsetree = 0x837c7cf68 [12:06:31.641] commandTag = [12:06:31.641] cmdtagname = [12:06:31.641] querytree_list = [12:06:31.641] portal = 0x835dc3100 [12:06:31.641] receiver = 0x837cc9190 [12:06:31.641] parsetree_item__state = {l = 0x837c7e830, i = 0} [12:06:31.641] msec_str = "\000\000\000\000\b", '\000' , "\275\206\341f\000\000\000\000O\006EB\2118\235", [12:06:31.641] dest = DestRemote [12:06:31.641] was_logged = [12:06:31.641] oldcontext = 0x835dc7000 [12:06:31.641] parsetree_list = 0x837c7e830 [12:06:31.641] use_implicit_block = false [12:06:31.641] parsetree_item = 0x837c7e848 [12:06:31.641] save_log_statement_stats = [12:06:31.641] #17 0x00000000009318d0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [12:06:31.641] query_string = 0x835d1f100 "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"... [12:06:31.641] input_message = {data = 0x835d1f100 "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} [12:06:31.641] firstchar = [12:06:31.641] local_sigjmp_buf = {{_sjb = {9637222, 34914024576, 34914024536, 34914025120, 12352536, 1, 8192, 8388608, 34913977215, 0, 0, 1}}} [12:06:31.641] send_ready_for_query = false [12:06:31.641] idle_in_transaction_timeout_enabled = false [12:06:31.641] idle_session_timeout_enabled = false [12:06:31.641] #18 0x000000000092c0a9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:06:31.641] bsdata = [12:06:31.641] #19 0x0000000000886237 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82109c9c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82109c900) at ../src/backend/postmaster/launch_backend.c:274 [12:06:31.641] pid = [12:06:31.641] #20 0x000000000088a5f8 in BackendStartup (client_sock=0x82109c900) at ../src/backend/postmaster/postmaster.c:3415 [12:06:31.641] startup_data = {canAcceptConnections = CAC_OK} [12:06:31.641] bn = 0x835d2b128 [12:06:31.641] pid = [12:06:31.641] __error = [12:06:31.641] save_errno = [12:06:31.641] __error = [12:06:31.641] __error = [12:06:31.641] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [12:06:31.641] 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 = "\300\016\3225\b", '\000' , "`\311\t!\b\000\000\000h\345j*\b\000\000\000\v\000\000\000\000\000\000\000^ok*\b", '\000' , "\240\311\t!\b\000\000\000\344_\210\000\000\000\000\000\260\311\t!\b", '\000' }, salen = 16}} [12:06:31.641] i = 0 [12:06:31.641] now = [12:06:31.641] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 728943746, events = 8, fd = 0, user_data = 0x82109c8b0}, {pos = 903378392, events = 8, fd = 554288960, user_data = 0x0}, {pos = 0, events = 0, fd = -1840769569, user_data = 0xcb337ea930a}, {pos = 728111008, events = 8, fd = 728182136, user_data = 0x82109c3c8}, {pos = 554288192, events = 8, fd = 554288072, user_data = 0xcb337ea930a}, {pos = 728089480, events = 8, fd = 728182136, user_data = 0x82109c3f8}, {pos = 554288240, events = 8, fd = 554288120, user_data = 0x82b66b194}, {pos = 561775624, events = 8, fd = 728150420, user_data = 0x82109c460}, {pos = 938099770, events = 3251, fd = 729972784, user_data = 0x1}, {pos = 554288272, events = 8, fd = 938119946, user_data = 0x82b654858}, {pos = 728182136, events = 8, fd = 554288232, user_data = 0x82109c4e0}, {pos = 554288232, events = 8, fd = 728145164, user_data = 0x8217c0408}, {pos = 728145164, events = 8, fd = 554288336, user_data = 0xcb337ea443a}, {pos = 554288376, events = 8, fd = 554288824, user_data = 0x82109c4e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2079053687, fd = 561799224, user_data = 0x800000001}, {pos = 561775624, events = 8, fd = 728089480, user_data = 0x8217c5288}, {pos = 728057944, events = 8, fd = 561775624, user_data = 0x82109c568}, {pos = 554288936, events = 8, fd = 554288464, user_data = 0xcb337ea8ca2}, {pos = 2699918, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 561799224, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554289192, user_data = 0x217c0408}, {pos = 554289008, events = 8, fd = 554288608, user_data = 0x1}, {pos = 554288936, events = 8, fd = 32, user_data = 0x82109c5d0}, {pos = 938117747, events = 3251, fd = 554288880, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8217c6038}, {pos = 1, events = 8, fd = 561775624, user_data = 0x82b654858}, {pos = 554289192, events = 8, fd = 554289008, user_data = 0x82109c5e0}, {pos = 0, events = 0, fd = 561745928, user_data = 0x20}, {pos = 554288992, events = 8, fd = 938093287, user_data = 0x8217b9008}, {pos = 561746952, events = 8, fd = 561747976, user_data = 0x8217b9c08}, {pos = 561762312, events = 8, fd = 561763336, user_data = 0x8217bd808}, {pos = 561765384, events = 8, fd = 561766408, user_data = 0x8217be408}, {pos = 561768456, events = 8, fd = 561769480, user_data = 0x8217bf008}, {pos = 561771528, events = 8, fd = 561772552, user_data = 0x8217bfc08}, {pos = 561774600, events = 8, fd = 561775624, user_data = 0x8217c0808}, {pos = 561777672, events = 8, fd = 561778696, user_data = 0x8217c1408}, {pos = 561780744, events = 8, fd = 561781768, user_data = 0x8217c2008}, {pos = 561783816, events = 8, fd = 561784840, user_data = 0x8217c2c08}, {pos = 561790984, events = 8, fd = 561792008, user_data = 0x8217c4808}, {pos = 561794056, events = 8, fd = 561745928, user_data = 0x29328e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8217c6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554289192, events = 8, fd = 554288608, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 561799224, user_data = 0x1}, {pos = 561745928, events = 8, fd = 313, user_data = 0x82109c810}, {pos = 938092015, events = 3251, fd = 2699918, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 561799224, user_data = 0x1}, {pos = 561775624, events = 8, fd = 902885376, user_data = 0x1}, {pos = 902885780, events = 8, fd = 0, user_data = 0x82109c7e0}, {pos = 711681388, events = 8, fd = 1, user_data = 0x835d0f000}, {pos = 554289168, events = 8, fd = 711677698, user_data = 0x82b786170 }, {pos = 12277568, events = 0, fd = 729309552, user_data = 0x8217c0408}, {pos = 554289392, events = 8, fd = 938091486, user_data = 0x835d2d800}, {pos = 1, events = 0, fd = 938091102, user_data = 0x8217b9008}, {pos = 554289176, events = 8, fd = 554289392, user_data = 0x1c20}, {pos = 902958784, events = 8, fd = 938170768, user_data = 0x0}, {pos = 554238847, events = 8, fd = 8087767, user_data = 0x82109c8a0}, {pos = 711640080, events = 8, fd = 729972784, user_data = 0x82b82a310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82109c8d0}, {pos = 711682973, events = 8, fd = 902885376, user_data = 0x194f}, {pos = 554289456, events = 8, fd = 711649530, user_data = 0x0}, {pos = 0, events = 0, fd = -1840769569, user_data = 0x0}} [12:06:31.641] last_touch_time = 1726056113 [12:06:31.641] last_lockfile_recheck_time = 1726056113 [12:06:31.641] nevents = 1 [12:06:31.641] #22 0x0000000000888415 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82109cf18) at ../src/backend/postmaster/postmaster.c:1346 [12:06:31.641] userDoption = [12:06:31.641] listen_addr_saved = [12:06:31.641] output_config_variable = [12:06:31.641] opt = [12:06:31.641] status = [12:06:31.641] #23 0x00000000007c35bc in main (argc=4, argv=0x82109cf18) at ../src/backend/main/main.c:197 [12:06:31.641] do_check_root = [12:06:31.655] [12:06:31.655] [12:06:31.655] [12:06:31.724] dumping /tmp/cores/postgres.14503.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:06:31.851] [New LWP 101814] [12:06:31.919] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [12:06:31.919] Program terminated with signal SIGABRT, Aborted. [12:06:31.919] Sent by thr_kill() from pid 14503 and user 1003. [12:06:31.919] #0 0x00000008295eb41a in thr_kill () from /lib/libc.so.7 [12:06:32.609] [12:06:32.609] Thread 1 (LWP 101814): [12:06:32.609] #0 0x00000008295eb41a in thr_kill () from /lib/libc.so.7 [12:06:32.609] No symbol table info available. [12:06:32.609] #1 0x0000000829564e64 in raise () from /lib/libc.so.7 [12:06:32.609] No symbol table info available. [12:06:32.609] #2 0x00000008296156f9 in abort () from /lib/libc.so.7 [12:06:32.609] No symbol table info available. [12:06:32.609] #3 0x0000000000a8acc5 in ExceptionalCondition (conditionName=0x2d0889 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [12:06:32.609] No locals. [12:06:32.609] #4 0x000000000076e2bf in ExecFetchSlotHeapTuple (slot=0x820bde0f0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [12:06:32.609] No locals. [12:06:32.609] #5 0x0000000000732f77 in ExecIRDeleteTriggers (estate=estate@entry=0x83313f100, relinfo=relinfo@entry=0x83313f6b0, slot=slot@entry=0x820bde0f0) at ../src/backend/commands/trigger.c:2841 [12:06:32.609] trigger = [12:06:32.609] oldtuple = [12:06:32.609] should_free = false [12:06:32.609] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8331604b8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [12:06:32.609] trigdesc = 0x83313f8c0 [12:06:32.609] newtuple = 0x0 [12:06:32.609] i = 0 [12:06:32.609] #6 0x0000000000793497 in ExecMergeMatched (context=0x820bde198, resultRelInfo=0x83313f6b0, tupleid=0x0, oldtuple=0x820bde0f0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [12:06:32.609] result = TM_Ok [12:06:32.609] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [12:06:32.609] relaction = 0x834f34938 [12:06:32.609] commandType = CMD_DELETE [12:06:32.609] l__state = {l = 0x834f34ef8, i = 0} [12:06:32.609] mtstate = 0x83313f4a0 [12:06:32.609] newslot = 0x0 [12:06:32.609] rslot = 0x0 [12:06:32.609] estate = 0x83313f100 [12:06:32.609] mergeActions = [12:06:32.609] econtext = 0x834f33f68 [12:06:32.609] epqstate = 0x83313f588 [12:06:32.609] actionStates = 0x834f34ef8 [12:06:32.609] l = [12:06:32.609] isNull = [12:06:32.609] lmerge_matched = [12:06:32.609] __error = [12:06:32.609] l__state = [12:06:32.609] result = [12:06:32.609] updateCxt = [12:06:32.609] relaction = [12:06:32.609] commandType = [12:06:32.609] __error = [12:06:32.609] resultRelationDesc = [12:06:32.609] lockmode = [12:06:32.609] inputslot = [12:06:32.609] epqslot = [12:06:32.609] was_matched = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] #7 ExecMerge (context=0x820bde198, resultRelInfo=0x83313f6b0, tupleid=0x0, oldtuple=0x820bde0f0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [12:06:32.609] matched = [12:06:32.609] rslot = 0x0 [12:06:32.609] #8 ExecModifyTable (pstate=0x83313f4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [12:06:32.609] context = {mtstate = 0x83313f4a0, epqstate = 0x83313f588, estate = 0x83313f100, planSlot = 0x833109170, tmfd = {ctid = {ip_blkid = {bi_hi = 32142, bi_lo = 10590}, ip_posid = 8}, xmax = 147, cmax = 0, traversed = 228}, cpUpdateReturningSlot = 0xe5bb085e799d402a} [12:06:32.609] tuple_ctid = {ip_blkid = {bi_hi = 57792, bi_lo = 8381}, ip_posid = 8} [12:06:32.609] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834e20118} [12:06:32.609] node = 0x83313f4a0 [12:06:32.609] estate = 0x83313f100 [12:06:32.609] operation = CMD_MERGE [12:06:32.609] resultRelInfo = 0x83313f6b0 [12:06:32.609] subplanstate = 0x833140df0 [12:06:32.609] slot = [12:06:32.609] tupleid = 0x0 [12:06:32.609] oldtuple = 0x820bde0f0 [12:06:32.609] oldSlot = [12:06:32.609] #9 0x000000000076052b in ExecProcNode (node=0x83313f4a0) at ../src/include/executor/executor.h:278 [12:06:32.609] No locals. [12:06:32.609] #10 ExecutePlan (estate=0x83313f100, planstate=0x83313f4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x8331b3310, execute_once=) at ../src/backend/executor/execMain.c:1641 [12:06:32.609] current_tuple_count = 0 [12:06:32.609] slot = [12:06:32.609] #11 standard_ExecutorRun (queryDesc=0x8331bd448, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [12:06:32.609] estate = 0x83313f100 [12:06:32.609] oldcontext = 0x8331b3000 [12:06:32.609] operation = CMD_MERGE [12:06:32.609] dest = 0x8331b3310 [12:06:32.609] sendTuples = true [12:06:32.609] #12 0x0000000834348961 in pgss_ExecutorRun (queryDesc=0x8331bd448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [12:06:32.609] _local_sigjmp_buf = {{_sjb = {35235596593, 1, 34909053640, 34909053808, 12343800, 34909053648, 1, 35217200200, 34908996479, 7811201, 35216683008, 34359738368}}} [12:06:32.609] _save_exception_stack = 0x820bde480 [12:06:32.609] _save_context_stack = 0x0 [12:06:32.609] _do_rethrow = false [12:06:32.609] #13 0x0000000000935e7f in ProcessQuery (plan=0x834f569b0, sourceText=, params=0x0, queryEnv=0x0, dest=0x8331b3310, qc=0x820bde448) at ../src/backend/tcop/pquery.c:160 [12:06:32.609] queryDesc = 0x8331bd448 [12:06:32.609] #14 0x000000000093541d in PortalRunMulti (portal=portal@entry=0x8330a7100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x8331b3310, altdest=0xb7c820 , qc=qc@entry=0x820bde448) at ../src/backend/tcop/pquery.c:1287 [12:06:32.609] pstmt = 0x834f569b0 [12:06:32.609] stmtlist_item__state = {l = 0x834f5b268, i = 0} [12:06:32.609] active_snapshot_set = true [12:06:32.609] stmtlist_item = 0x834f5b280 [12:06:32.609] #15 0x0000000000934f2c in FillPortalStore (portal=portal@entry=0x8330a7100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [12:06:32.609] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:06:32.609] treceiver = 0x8331b3310 [12:06:32.609] #16 0x0000000000934c9b in PortalRun (portal=portal@entry=0x8330a7100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x834f5b2b8, altdest=altdest@entry=0x834f5b2b8, qc=0x820bde580) at ../src/backend/tcop/pquery.c:763 [12:06:32.609] _local_sigjmp_buf = {{_sjb = {9653309, 35216060672, 34909054072, 34909054304, 34909054080, 35216154624, 12310472, 12343800, 35216032639, 35215380736, 4294967984, 0}}} [12:06:32.609] _save_exception_stack = 0x820bde650 [12:06:32.609] _save_context_stack = 0x0 [12:06:32.609] _do_rethrow = false [12:06:32.609] saveTopTransactionResourceOwner = 0x8330f5398 [12:06:32.609] saveTopTransactionContext = 0x8330be000 [12:06:32.609] saveActivePortal = 0x0 [12:06:32.609] saveResourceOwner = 0x8330f5398 [12:06:32.609] savePortalContext = 0x0 [12:06:32.609] saveMemoryContext = 0x8330be000 [12:06:32.609] result = [12:06:32.609] nprocessed = [12:06:32.609] #17 0x0000000000933b62 in exec_simple_query (query_string=query_string@entry=0x833001100 "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 [12:06:32.609] cmdtaglen = 5 [12:06:32.609] snapshot_set = [12:06:32.609] per_parsetree_context = 0x0 [12:06:32.609] plantree_list = [12:06:32.609] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:06:32.609] format = 0 [12:06:32.609] parsetree = 0x834f0ea68 [12:06:32.609] commandTag = [12:06:32.609] cmdtagname = [12:06:32.609] querytree_list = [12:06:32.609] portal = 0x8330a7100 [12:06:32.609] receiver = 0x834f5b2b8 [12:06:32.609] parsetree_item__state = {l = 0x834f10330, i = 0} [12:06:32.609] msec_str = "\000\000\000\000\b", '\000' , "\340\206\341f\000\000\000\000\207\310\347\373\277j\035 " [12:06:32.609] dest = DestRemote [12:06:32.609] was_logged = [12:06:32.609] oldcontext = 0x8330be000 [12:06:32.609] parsetree_list = 0x834f10330 [12:06:32.609] use_implicit_block = false [12:06:32.609] parsetree_item = 0x834f10348 [12:06:32.609] save_log_statement_stats = [12:06:32.609] #18 0x00000000009318d0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [12:06:32.609] query_string = 0x833001100 "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"... [12:06:32.609] input_message = {data = 0x833001100 "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} [12:06:32.609] firstchar = [12:06:32.609] local_sigjmp_buf = {{_sjb = {9637222, 34909054544, 34909054504, 34909055088, 12352536, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [12:06:32.609] send_ready_for_query = false [12:06:32.609] idle_in_transaction_timeout_enabled = false [12:06:32.609] idle_session_timeout_enabled = false [12:06:32.609] #19 0x000000000092c0a9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:06:32.609] bsdata = [12:06:32.609] #20 0x0000000000886237 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820bdf394 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820bdf2d0) at ../src/backend/postmaster/launch_backend.c:274 [12:06:32.609] pid = [12:06:32.609] #21 0x000000000088a5f8 in BackendStartup (client_sock=0x820bdf2d0) at ../src/backend/postmaster/postmaster.c:3415 [12:06:32.609] startup_data = {canAcceptConnections = CAC_OK} [12:06:32.609] bn = 0x83300d6c8 [12:06:32.609] pid = [12:06:32.609] __error = [12:06:32.609] save_errno = [12:06:32.609] __error = [12:06:32.609] __error = [12:06:32.609] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [12:06:32.609] 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 = " \034\0003\b", '\000' , "0\363\275 \b\000\000\000h%\004)\b\000\000\000\v\000\000\000\000\000\000\000^\257\004)\b", '\000' , "p\363\275 \b\000\000\000\344_\210\000\000\000\000\000\200\363\275 \b", '\000' }, salen = 16}} [12:06:32.609] i = 0 [12:06:32.609] now = [12:06:32.609] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 693697666, events = 8, fd = 0, user_data = 0x820bdf280}, {pos = 856069592, events = 8, fd = 549318928, user_data = 0x0}, {pos = -1523199222, events = 4292, fd = 692864928, user_data = 0x8294d5d78}, {pos = 549318024, events = 8, fd = 549318144, user_data = 0x820bded88}, {pos = -1523199222, events = 4292, fd = 692843400, user_data = 0x8294d5d78}, {pos = 549318072, events = 8, fd = 549318192, user_data = 0x820bdedb8}, {pos = 692904340, events = 8, fd = 562856968, user_data = 0x8294ce194}, {pos = 549318176, events = 8, fd = -1523219398, user_data = 0x820bdedc0}, {pos = 688129040, events = 8, fd = 694726704, user_data = 0x10c4a535d30a}, {pos = 692811864, events = 8, fd = 692936056, user_data = 0x820bdee28}, {pos = 549318304, events = 8, fd = 549318184, user_data = 0x8294ccd0c}, {pos = 562856968, events = 8, fd = 692899084, user_data = 0x820bdee90}, {pos = -1523219398, events = 4292, fd = 549318328, user_data = 0x820bdf088}, {pos = 549318304, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8218ce038}, {pos = 1, events = 3854239838, fd = 562856968, user_data = 0x8294bf388}, {pos = 562878408, events = 8, fd = 0, user_data = 0x0}, {pos = 549318440, events = 8, fd = 549318904, user_data = 0x820bdef10}, {pos = -1523200862, events = 4292, fd = 2699918, user_data = 0x6d68b}, {pos = 2090263927, events = 3854239838, fd = 562880568, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820bdf1f8}, {pos = 562856968, events = 3, fd = 549318976, user_data = 0x8218cd828}, {pos = 656, events = 0, fd = 549318904, user_data = 0x820bdef28}, {pos = 549318544, events = 8, fd = -1523201253, user_data = 0x820bdf0c0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 562880568, events = 8, fd = 1, user_data = 0x8218c8408}, {pos = 692811864, events = 8, fd = 549319160, user_data = 0x820bdf140}, {pos = 549318560, events = 8, fd = 0, user_data = 0x8218c1008}, {pos = 33, events = 0, fd = 549318960, user_data = 0x10c4a5356ae7}, {pos = 562827272, events = 8, fd = 562828296, user_data = 0x8218c1808}, {pos = 562830344, events = 8, fd = 562843656, user_data = 0x8218c5408}, {pos = 562845704, events = 8, fd = 562846728, user_data = 0x8218c6008}, {pos = 562848776, events = 8, fd = 562849800, user_data = 0x8218c6c08}, {pos = 562851848, events = 8, fd = 562852872, user_data = 0x8218c7808}, {pos = 562854920, events = 8, fd = 562855944, user_data = 0x8218c8408}, {pos = 562857992, events = 8, fd = 562859016, user_data = 0x8218c9008}, {pos = 562861064, events = 8, fd = 562862088, user_data = 0x8218c9c08}, {pos = 562864136, events = 8, fd = 562865160, user_data = 0x8218ca808}, {pos = 562867208, events = 8, fd = 562872328, user_data = 0x8218cc408}, {pos = 562874376, events = 8, fd = 562875400, user_data = 0x8218cf408}, {pos = 111867000, events = 0, fd = 562827272, user_data = 0x29328e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8218ce038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 549319160, events = 8, fd = 549318560, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 562880568, user_data = 0x1}, {pos = 562827272, events = 8, fd = 313, user_data = 0x820bdf1e0}, {pos = -1523227153, events = 4292, fd = 2699918, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 562880568, user_data = 0x1}, {pos = 562856968, events = 8, fd = 855576576, user_data = 0x1}, {pos = 855576980, events = 8, fd = 0, user_data = 0x820bdf1b0}, {pos = 688170348, events = 8, fd = 1, user_data = 0x832ff1000}, {pos = 549319136, events = 8, fd = 688166658, user_data = 0x8295e9170 }, {pos = 12277568, events = 0, fd = 694063472, user_data = 0x8218c8408}, {pos = 549319360, events = 8, fd = -1523227682, user_data = 0x83300f800}, {pos = 1, events = 0, fd = -1523228066, user_data = 0x8218c1008}, {pos = 549319144, events = 8, fd = 549319360, user_data = 0x1c20}, {pos = 855645216, events = 8, fd = -1523148400, user_data = 0x0}, {pos = 549258111, events = 8, fd = 8087767, user_data = 0x820bdf270}, {pos = 688129040, events = 8, fd = 694726704, user_data = 0x82968d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820bdf2a0}, {pos = 688171933, events = 8, fd = 855576576, user_data = 0x3124}, {pos = 549319424, events = 8, fd = 688138490, user_data = 0x0}, {pos = 0, events = 0, fd = 2040348714, user_data = 0x0}} [12:06:32.609] last_touch_time = 1726056146 [12:06:32.609] last_lockfile_recheck_time = 1726056146 [12:06:32.609] nevents = 1 [12:06:32.609] #23 0x0000000000888415 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820bdf8e8) at ../src/backend/postmaster/postmaster.c:1346 [12:06:32.609] userDoption = [12:06:32.609] listen_addr_saved = [12:06:32.609] output_config_variable = [12:06:32.609] opt = [12:06:32.609] status = [12:06:32.609] #24 0x00000000007c35bc in main (argc=4, argv=0x820bdf8e8) at ../src/backend/main/main.c:197 [12:06:32.609] do_check_root =