[02:14:22.755] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [02:14:23.103] dumping /tmp/cores/postgres.7938.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:14:23.231] [New LWP 101722] [02:14:23.320] Core was generated by `postgres: postgres regression [local] MERGE'. [02:14:23.320] Program terminated with signal SIGABRT, Aborted. [02:14:23.320] Sent by thr_kill() from pid 7938 and user 1003. [02:14:23.320] #0 0x000000082d04841a in thr_kill () from /lib/libc.so.7 [02:14:23.913] [02:14:23.913] Thread 1 (LWP 101722): [02:14:23.913] #0 0x000000082d04841a in thr_kill () from /lib/libc.so.7 [02:14:23.913] No symbol table info available. [02:14:23.913] #1 0x000000082cfc1e64 in raise () from /lib/libc.so.7 [02:14:23.913] No symbol table info available. [02:14:23.913] #2 0x000000082d0726f9 in abort () from /lib/libc.so.7 [02:14:23.913] No symbol table info available. [02:14:23.913] #3 0x0000000000a90b25 in ExceptionalCondition (conditionName=0x2d1b90 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [02:14:23.913] No locals. [02:14:23.913] #4 0x0000000000772caf in ExecFetchSlotHeapTuple (slot=0x8213ab0c8, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [02:14:23.913] No locals. [02:14:23.913] #5 0x0000000000737657 in ExecIRDeleteTriggers (estate=estate@entry=0x8377b9100, relinfo=relinfo@entry=0x8377b96b0, slot=slot@entry=0x8213ab0c8) at ../src/backend/commands/trigger.c:2842 [02:14:23.913] trigger = [02:14:23.913] oldtuple = [02:14:23.913] should_free = false [02:14:23.913] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x838dbf470, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [02:14:23.913] trigdesc = 0x8377b98c0 [02:14:23.913] newtuple = 0x0 [02:14:23.913] i = 0 [02:14:23.913] #6 0x0000000000797f74 in ExecMergeMatched (context=0x8213ab158, resultRelInfo=0x8377b96b0, tupleid=0x0, oldtuple=0x8213ab0c8, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3082 [02:14:23.913] result = TM_Ok [02:14:23.913] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [02:14:23.913] relaction = 0x838eb9c60 [02:14:23.913] commandType = CMD_DELETE [02:14:23.913] l__state = {l = 0x838f774f8, i = 0} [02:14:23.913] lockedtid = [02:14:23.913] mtstate = 0x8377b94a0 [02:14:23.913] newslot = 0x0 [02:14:23.913] rslot = 0x0 [02:14:23.913] estate = 0x8377b9100 [02:14:23.913] mergeActions = [02:14:23.913] econtext = 0x838f76598 [02:14:23.913] epqstate = 0x8377b9588 [02:14:23.913] actionStates = 0x838f774f8 [02:14:23.913] l = [02:14:23.913] isNull = [02:14:23.913] lmerge_matched = [02:14:23.913] __error = [02:14:23.913] l__state = [02:14:23.913] result = [02:14:23.913] updateCxt = [02:14:23.913] relaction = [02:14:23.913] commandType = [02:14:23.913] __error = [02:14:23.913] resultRelationDesc = [02:14:23.913] lockmode = [02:14:23.913] inputslot = [02:14:23.913] epqslot = [02:14:23.913] was_matched = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] #7 ExecMerge (context=0x8213ab158, resultRelInfo=0x8377b96b0, tupleid=0x0, oldtuple=0x8213ab0c8, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [02:14:23.913] matched = true [02:14:23.913] rslot = 0x0 [02:14:23.913] #8 ExecModifyTable (pstate=0x8377b94a0) at ../src/backend/executor/nodeModifyTable.c:4197 [02:14:23.913] context = {mtstate = 0x8377b94a0, epqstate = 0x8377b9588, estate = 0x8377b9100, planSlot = 0x838f74998, tmfd = {ctid = {ip_blkid = {bi_hi = 19248, bi_lo = 14579}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8377b96b0} [02:14:23.913] tuple_ctid = {ip_blkid = {bi_hi = 38584, bi_lo = 14203}, ip_posid = 8} [02:14:23.913] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83783b118} [02:14:23.913] node = 0x8377b94a0 [02:14:23.913] estate = 0x8377b9100 [02:14:23.913] operation = CMD_MERGE [02:14:23.913] resultRelInfo = 0x8377b96b0 [02:14:23.913] subplanstate = 0x8377badb0 [02:14:23.913] slot = [02:14:23.913] tupleid = 0x0 [02:14:23.913] oldtuple = 0x8213ab0c8 [02:14:23.913] tuplock = [02:14:23.913] oldSlot = [02:14:23.913] #9 0x0000000000764e0b in ExecProcNode (node=0x8377b94a0) at ../src/include/executor/executor.h:278 [02:14:23.913] No locals. [02:14:23.913] #10 ExecutePlan (estate=0x8377b9100, planstate=0x8377b94a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x837807310, execute_once=) at ../src/backend/executor/execMain.c:1659 [02:14:23.913] current_tuple_count = 0 [02:14:23.913] slot = [02:14:23.913] #11 standard_ExecutorRun (queryDesc=0x83781b448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [02:14:23.913] estate = 0x8377b9100 [02:14:23.913] oldcontext = 0x837807000 [02:14:23.913] operation = CMD_MERGE [02:14:23.913] dest = 0x837807310 [02:14:23.913] sendTuples = true [02:14:23.913] #12 0x000000000093b47f in ProcessQuery (plan=0x838f34418, sourceText=, params=0x0, queryEnv=0x0, dest=0x837807310, qc=0x8213ab358) at ../src/backend/tcop/pquery.c:160 [02:14:23.913] queryDesc = 0x83781b448 [02:14:23.913] #13 0x000000000093aa1d in PortalRunMulti (portal=portal@entry=0x837734100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x837807310, altdest=0xb82bd0 , qc=qc@entry=0x8213ab358) at ../src/backend/tcop/pquery.c:1287 [02:14:23.913] pstmt = 0x838f34418 [02:14:23.913] stmtlist_item__state = {l = 0x838f38cd0, i = 0} [02:14:23.913] active_snapshot_set = true [02:14:23.913] stmtlist_item = 0x838f38ce8 [02:14:23.913] #14 0x000000000093a52c in FillPortalStore (portal=portal@entry=0x837734100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [02:14:23.913] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:14:23.913] treceiver = 0x837807310 [02:14:23.913] #15 0x000000000093a29b in PortalRun (portal=portal@entry=0x837734100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x838f38d20, altdest=altdest@entry=0x838f38d20, qc=0x8213ab490) at ../src/backend/tcop/pquery.c:763 [02:14:23.913] _local_sigjmp_buf = {{_sjb = {9675325, 35290038528, 34917233544, 34917233776, 34917233552, 35290058752, 12340552, 12373880, 35290022783, 35289166080, 4294967984, 0}}} [02:14:23.913] _save_exception_stack = 0x8213ab560 [02:14:23.913] _save_context_stack = 0x0 [02:14:23.913] _do_rethrow = false [02:14:23.913] saveTopTransactionResourceOwner = 0x837746f98 [02:14:23.913] saveTopTransactionContext = 0x837739000 [02:14:23.913] saveActivePortal = 0x0 [02:14:23.913] saveResourceOwner = 0x837746f98 [02:14:23.913] savePortalContext = 0x0 [02:14:23.913] saveMemoryContext = 0x837739000 [02:14:23.913] result = [02:14:23.913] nprocessed = [02:14:23.913] #16 0x0000000000939162 in exec_simple_query (query_string=query_string@entry=0x83765f100 "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 [02:14:23.913] cmdtaglen = 5 [02:14:23.913] snapshot_set = [02:14:23.913] per_parsetree_context = 0x0 [02:14:23.913] plantree_list = [02:14:23.913] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:14:23.913] format = 0 [02:14:23.913] parsetree = 0x838eef428 [02:14:23.913] commandTag = [02:14:23.913] cmdtagname = [02:14:23.913] querytree_list = [02:14:23.913] portal = 0x837734100 [02:14:23.913] receiver = 0x838f38d20 [02:14:23.913] parsetree_item__state = {l = 0x838ef0cf0, i = 0} [02:14:23.913] msec_str = "\000\000\000\000\b", '\000' , "\016q\363f\000\000\000\000@\223O\332`\2125=" [02:14:23.913] dest = DestRemote [02:14:23.913] was_logged = [02:14:23.913] oldcontext = 0x837739000 [02:14:23.913] parsetree_list = 0x838ef0cf0 [02:14:23.913] use_implicit_block = false [02:14:23.913] parsetree_item = 0x838ef0d08 [02:14:23.913] save_log_statement_stats = [02:14:23.913] #17 0x0000000000936dd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [02:14:23.913] query_string = 0x83765f100 "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"... [02:14:23.913] input_message = {data = 0x83765f100 "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} [02:14:23.913] firstchar = [02:14:23.913] local_sigjmp_buf = {{_sjb = {9659014, 34917234016, 34917233976, 34917234560, 12382616, 1, 8192, 8388608, 34917188479, 0, 0, 1}}} [02:14:23.913] send_ready_for_query = false [02:14:23.913] idle_in_transaction_timeout_enabled = false [02:14:23.913] idle_session_timeout_enabled = false [02:14:23.913] #18 0x00000000009315b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:14:23.913] bsdata = [02:14:23.913] #19 0x000000000088b147 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8213ac2a4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8213ac1e0) at ../src/backend/postmaster/launch_backend.c:274 [02:14:23.913] pid = [02:14:23.913] #20 0x000000000088f518 in BackendStartup (client_sock=0x8213ac1e0) at ../src/backend/postmaster/postmaster.c:3420 [02:14:23.913] startup_data = {canAcceptConnections = CAC_OK} [02:14:23.913] bn = 0x83766b178 [02:14:23.913] pid = [02:14:23.913] __error = [02:14:23.913] save_errno = [02:14:23.913] __error = [02:14:23.913] __error = [02:14:23.913] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [02:14:23.913] 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\017f7\b", '\000' , "@\302:!\b\000\000\000h\365J+\b\000\000\000\v\000\000\000\000\000\000\000^\177K+\b", '\000' , "\200\302:!\b\000\000\000\364\256\210\000\000\000\000\000\220\302:!\b", '\000' }, salen = 16}} [02:14:23.913] i = 0 [02:14:23.913] now = [02:14:23.913] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 754896002, events = 8, fd = 0, user_data = 0x8213ac190}, {pos = 929826264, events = 8, fd = 557498400, user_data = 0x0}, {pos = 0, events = 0, fd = -252590189, user_data = 0x5543f57d30a}, {pos = 754063264, events = 8, fd = 754134392, user_data = 0x8213abca8}, {pos = 557497632, events = 8, fd = 557497512, user_data = 0x5543f57d30a}, {pos = 754041736, events = 8, fd = 754134392, user_data = 0x8213abcd8}, {pos = 557497680, events = 8, fd = 557497560, user_data = 0x82cf2b194}, {pos = 565220360, events = 8, fd = 754102676, user_data = 0x8213abd40}, {pos = 1062700090, events = 1364, fd = 755925040, user_data = 0x1}, {pos = 557497712, events = 8, fd = 1062720266, user_data = 0x82cf14858}, {pos = 754134392, events = 8, fd = 557497672, user_data = 0x8213abdc0}, {pos = 557497672, events = 8, fd = 754097420, user_data = 0x821b09408}, {pos = 754097420, events = 8, fd = 557497776, user_data = 0x5543f57843a}, {pos = 557497816, events = 8, fd = 557498264, user_data = 0x8213abdc0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1442429785, fd = 565243960, user_data = 0x800000001}, {pos = 565220360, events = 8, fd = 754041736, user_data = 0x821b0e288}, {pos = 754010200, events = 8, fd = 565220360, user_data = 0x8213abe48}, {pos = 557498376, events = 8, fd = 557497904, user_data = 0x5543f57cca2}, {pos = 2701457, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 565243960, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 557498632, user_data = 0x21b09408}, {pos = 557498448, events = 8, fd = 557498048, user_data = 0x1}, {pos = 557498376, events = 8, fd = 32, user_data = 0x8213abeb0}, {pos = 1062718067, events = 1364, fd = 557498320, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821b0f038}, {pos = 1, events = 8, fd = 565220360, user_data = 0x82cf14858}, {pos = 557498632, events = 8, fd = 557498448, user_data = 0x8213abec0}, {pos = 0, events = 0, fd = 565190664, user_data = 0x20}, {pos = 557498432, events = 8, fd = 1062693607, user_data = 0x821b02008}, {pos = 565191688, events = 8, fd = 565192712, user_data = 0x821b02c08}, {pos = 565207048, events = 8, fd = 565208072, user_data = 0x821b06808}, {pos = 565210120, events = 8, fd = 565211144, user_data = 0x821b07408}, {pos = 565213192, events = 8, fd = 565214216, user_data = 0x821b08008}, {pos = 565216264, events = 8, fd = 565217288, user_data = 0x821b08c08}, {pos = 565219336, events = 8, fd = 565220360, user_data = 0x821b09808}, {pos = 565222408, events = 8, fd = 565223432, user_data = 0x821b0a408}, {pos = 565225480, events = 8, fd = 565226504, user_data = 0x821b0b008}, {pos = 565228552, events = 8, fd = 565229576, user_data = 0x821b0bc08}, {pos = 565235720, events = 8, fd = 565236744, user_data = 0x821b0d808}, {pos = 565238792, events = 8, fd = 565190664, user_data = 0x293891}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821b0f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557498632, events = 8, fd = 557498048, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 565243960, user_data = 0x1}, {pos = 565190664, events = 8, fd = 313, user_data = 0x8213ac0f0}, {pos = 1062692335, events = 1364, fd = 2701457, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565243960, user_data = 0x1}, {pos = 565220360, events = 8, fd = 929361920, user_data = 0x1}, {pos = 929362324, events = 8, fd = 0, user_data = 0x8213ac0c0}, {pos = 726365548, events = 8, fd = 1, user_data = 0x83764f000}, {pos = 557498608, events = 8, fd = 726361858, user_data = 0x82d046170 }, {pos = 12303552, events = 0, fd = 755261808, user_data = 0x821b09408}, {pos = 557498832, events = 8, fd = 1062691806, user_data = 0x83766d800}, {pos = 1, events = 0, fd = 1062691422, user_data = 0x821b02008}, {pos = 557498616, events = 8, fd = 557498832, user_data = 0x1c20}, {pos = 929435392, events = 8, fd = 1062771088, user_data = 0x0}, {pos = 557450111, events = 8, fd = 8107111, user_data = 0x8213ac180}, {pos = 726324240, events = 8, fd = 755925040, user_data = 0x82d0ea310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8213ac1b0}, {pos = 726367133, events = 8, fd = 929361920, user_data = 0x1752}, {pos = 557498896, events = 8, fd = 726333690, user_data = 0x0}, {pos = 0, events = 0, fd = -252590189, user_data = 0x0}} [02:14:23.914] last_touch_time = 1727230211 [02:14:23.914] last_lockfile_recheck_time = 1727230211 [02:14:23.914] nevents = 1 [02:14:23.914] #22 0x000000000088d335 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8213ac7f8) at ../src/backend/postmaster/postmaster.c:1351 [02:14:23.914] userDoption = [02:14:23.914] listen_addr_saved = [02:14:23.914] output_config_variable = [02:14:23.914] opt = [02:14:23.914] status = [02:14:23.914] #23 0x00000000007c814c in main (argc=8, argv=0x8213ac7f8) at ../src/backend/main/main.c:197 [02:14:23.914] do_check_root = [02:14:23.925] [02:14:23.925] [02:14:23.925] [02:14:23.988] dumping /tmp/cores/postgres.7994.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:14:24.108] [New LWP 101693] [02:14:24.173] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [02:14:24.173] Program terminated with signal SIGABRT, Aborted. [02:14:24.173] Sent by thr_kill() from pid 7994 and user 1003. [02:14:24.173] #0 0x000000082d82c41a in thr_kill () from /lib/libc.so.7 [02:14:24.750] [02:14:24.750] Thread 1 (LWP 101693): [02:14:24.750] #0 0x000000082d82c41a in thr_kill () from /lib/libc.so.7 [02:14:24.750] No symbol table info available. [02:14:24.750] #1 0x000000082d7a5e64 in raise () from /lib/libc.so.7 [02:14:24.750] No symbol table info available. [02:14:24.750] #2 0x000000082d8566f9 in abort () from /lib/libc.so.7 [02:14:24.750] No symbol table info available. [02:14:24.750] #3 0x0000000000a90b25 in ExceptionalCondition (conditionName=0x2d1b90 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [02:14:24.750] No locals. [02:14:24.750] #4 0x0000000000772caf in ExecFetchSlotHeapTuple (slot=0x821af81b8, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [02:14:24.750] No locals. [02:14:24.750] #5 0x0000000000737657 in ExecIRDeleteTriggers (estate=estate@entry=0x837d9c100, relinfo=relinfo@entry=0x837d9c6b0, slot=slot@entry=0x821af81b8) at ../src/backend/commands/trigger.c:2842 [02:14:24.750] trigger = [02:14:24.750] oldtuple = [02:14:24.750] should_free = false [02:14:24.750] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x844d06860, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [02:14:24.750] trigdesc = 0x837d9c8c0 [02:14:24.750] newtuple = 0x0 [02:14:24.750] i = 0 [02:14:24.750] #6 0x0000000000797f74 in ExecMergeMatched (context=0x821af8248, resultRelInfo=0x837d9c6b0, tupleid=0x0, oldtuple=0x821af81b8, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3082 [02:14:24.750] result = TM_Ok [02:14:24.750] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [02:14:24.750] relaction = 0x844dd36e0 [02:14:24.750] commandType = CMD_DELETE [02:14:24.750] l__state = {l = 0x844e91278, i = 0} [02:14:24.750] lockedtid = [02:14:24.750] mtstate = 0x837d9c4a0 [02:14:24.750] newslot = 0x0 [02:14:24.750] rslot = 0x0 [02:14:24.750] estate = 0x837d9c100 [02:14:24.750] mergeActions = [02:14:24.750] econtext = 0x844e90318 [02:14:24.750] epqstate = 0x837d9c588 [02:14:24.750] actionStates = 0x844e91278 [02:14:24.750] l = [02:14:24.750] isNull = [02:14:24.750] lmerge_matched = [02:14:24.750] __error = [02:14:24.750] l__state = [02:14:24.750] result = [02:14:24.750] updateCxt = [02:14:24.750] relaction = [02:14:24.750] commandType = [02:14:24.750] __error = [02:14:24.750] resultRelationDesc = [02:14:24.750] lockmode = [02:14:24.750] inputslot = [02:14:24.750] epqslot = [02:14:24.750] was_matched = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] #7 ExecMerge (context=0x821af8248, resultRelInfo=0x837d9c6b0, tupleid=0x0, oldtuple=0x821af81b8, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [02:14:24.750] matched = true [02:14:24.750] rslot = 0x0 [02:14:24.750] #8 ExecModifyTable (pstate=0x837d9c4a0) at ../src/backend/executor/nodeModifyTable.c:4197 [02:14:24.750] context = {mtstate = 0x837d9c4a0, epqstate = 0x837d9c588, estate = 0x837d9c100, planSlot = 0x844e8e718, tmfd = {ctid = {ip_blkid = {bi_hi = 42864, bi_lo = 17636}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x837d9c6b0} [02:14:24.750] tuple_ctid = {ip_blkid = {bi_hi = 50872, bi_lo = 14297}, ip_posid = 8} [02:14:24.750] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x837c30118} [02:14:24.750] node = 0x837d9c4a0 [02:14:24.750] estate = 0x837d9c100 [02:14:24.750] operation = CMD_MERGE [02:14:24.750] resultRelInfo = 0x837d9c6b0 [02:14:24.750] subplanstate = 0x837d9ddb0 [02:14:24.750] slot = [02:14:24.750] tupleid = 0x0 [02:14:24.750] oldtuple = 0x821af81b8 [02:14:24.750] tuplock = [02:14:24.750] oldSlot = [02:14:24.750] #9 0x0000000000764e0b in ExecProcNode (node=0x837d9c4a0) at ../src/include/executor/executor.h:278 [02:14:24.750] No locals. [02:14:24.750] #10 ExecutePlan (estate=0x837d9c100, planstate=0x837d9c4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x837d86710, execute_once=) at ../src/backend/executor/execMain.c:1659 [02:14:24.750] current_tuple_count = 0 [02:14:24.750] slot = [02:14:24.750] #11 standard_ExecutorRun (queryDesc=0x837c3dc48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [02:14:24.750] estate = 0x837d9c100 [02:14:24.750] oldcontext = 0x837d86400 [02:14:24.750] operation = CMD_MERGE [02:14:24.750] dest = 0x837d86710 [02:14:24.750] sendTuples = true [02:14:24.750] #12 0x000000000093b47f in ProcessQuery (plan=0x844e4a058, sourceText=, params=0x0, queryEnv=0x0, dest=0x837d86710, qc=0x821af8448) at ../src/backend/tcop/pquery.c:160 [02:14:24.750] queryDesc = 0x837c3dc48 [02:14:24.750] #13 0x000000000093aa1d in PortalRunMulti (portal=portal@entry=0x837c84100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x837d86710, altdest=0xb82bd0 , qc=qc@entry=0x821af8448) at ../src/backend/tcop/pquery.c:1287 [02:14:24.750] pstmt = 0x844e4a058 [02:14:24.750] stmtlist_item__state = {l = 0x844e4e910, i = 0} [02:14:24.750] active_snapshot_set = true [02:14:24.750] stmtlist_item = 0x844e4e928 [02:14:24.750] #14 0x000000000093a52c in FillPortalStore (portal=portal@entry=0x837c84100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [02:14:24.750] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:14:24.750] treceiver = 0x837d86710 [02:14:24.750] #15 0x000000000093a29b in PortalRun (portal=portal@entry=0x837c84100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x844e4e960, altdest=altdest@entry=0x844e4e960, qc=0x821af8580) at ../src/backend/tcop/pquery.c:763 [02:14:24.750] _local_sigjmp_buf = {{_sjb = {9675325, 35295609088, 34924889208, 34924889440, 34924889216, 35295625216, 12340552, 12373880, 35295593343, 35294937344, 4294967984, 0}}} [02:14:24.750] _save_exception_stack = 0x821af8650 [02:14:24.750] _save_context_stack = 0x0 [02:14:24.750] _do_rethrow = false [02:14:24.750] saveTopTransactionResourceOwner = 0x837cd3e18 [02:14:24.750] saveTopTransactionContext = 0x837c88000 [02:14:24.750] saveActivePortal = 0x0 [02:14:24.750] saveResourceOwner = 0x837cd3e18 [02:14:24.750] savePortalContext = 0x0 [02:14:24.750] saveMemoryContext = 0x837c88000 [02:14:24.750] result = [02:14:24.750] nprocessed = [02:14:24.750] #16 0x0000000000939162 in exec_simple_query (query_string=query_string@entry=0x837be0100 "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 [02:14:24.750] cmdtaglen = 5 [02:14:24.750] snapshot_set = [02:14:24.750] per_parsetree_context = 0x0 [02:14:24.750] plantree_list = [02:14:24.750] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:14:24.750] format = 0 [02:14:24.750] parsetree = 0x844e09268 [02:14:24.750] commandTag = [02:14:24.750] cmdtagname = [02:14:24.750] querytree_list = [02:14:24.750] portal = 0x837c84100 [02:14:24.750] receiver = 0x844e4e960 [02:14:24.750] parsetree_item__state = {l = 0x844e0ab30, i = 0} [02:14:24.750] msec_str = "\000\000\000\000\b", '\000' , "\016q\363f\000\000\000\000\202\325F\2539\244\212g" [02:14:24.750] dest = DestRemote [02:14:24.750] was_logged = [02:14:24.750] oldcontext = 0x837c88000 [02:14:24.750] parsetree_list = 0x844e0ab30 [02:14:24.750] use_implicit_block = false [02:14:24.750] parsetree_item = 0x844e0ab48 [02:14:24.750] save_log_statement_stats = [02:14:24.750] #17 0x0000000000936dd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [02:14:24.750] query_string = 0x837be0100 "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"... [02:14:24.750] input_message = {data = 0x837be0100 "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} [02:14:24.750] firstchar = [02:14:24.750] local_sigjmp_buf = {{_sjb = {9659014, 34924889680, 34924889640, 34924890224, 12382616, 1, 8192, 8388608, 34924856191, 0, 0, 1}}} [02:14:24.750] send_ready_for_query = false [02:14:24.750] idle_in_transaction_timeout_enabled = false [02:14:24.750] idle_session_timeout_enabled = false [02:14:24.750] #18 0x00000000009315b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:14:24.750] bsdata = [02:14:24.750] #19 0x000000000088b147 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821af9394 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821af92d0) at ../src/backend/postmaster/launch_backend.c:274 [02:14:24.750] pid = [02:14:24.750] #20 0x000000000088f518 in BackendStartup (client_sock=0x821af92d0) at ../src/backend/postmaster/postmaster.c:3420 [02:14:24.750] startup_data = {canAcceptConnections = CAC_OK} [02:14:24.750] bn = 0x837bec088 [02:14:24.750] pid = [02:14:24.750] __error = [02:14:24.750] save_errno = [02:14:24.750] __error = [02:14:24.750] __error = [02:14:24.750] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [02:14:24.750] 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\036\2767\b", '\000' , "0\223\257!\b\000\000\000h\245\031.\b\000\000\000\v\000\000\000\000\000\000\000^/\032.\b", '\000' , "p\223\257!\b\000\000\000\364\256\210\000\000\000\000\000\200\223\257!\b", '\000' }, salen = 16}} [02:14:24.750] i = 0 [02:14:24.750] now = [02:14:24.750] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 935626200, events = 8, fd = 565154064, user_data = 0x0}, {pos = 0, events = 0, fd = 419005029, user_data = 0x19b03930530a}, {pos = 762337184, events = 8, fd = 762408312, user_data = 0x821af8d98}, {pos = 565153296, events = 8, fd = 565153176, user_data = 0x19b03930530a}, {pos = 762315656, events = 8, fd = 762408312, user_data = 0x821af8dc8}, {pos = 565153344, events = 8, fd = 565153224, user_data = 0x82d70f194}, {pos = 580924424, events = 8, fd = 762376596, user_data = 0x821af8e30}, {pos = 959448122, events = 6576, fd = 764198960, user_data = 0x1}, {pos = 565153376, events = 8, fd = 959468298, user_data = 0x82d6f8858}, {pos = 762408312, events = 8, fd = 565153336, user_data = 0x821af8eb0}, {pos = 565153336, events = 8, fd = 762371340, user_data = 0x822a03408}, {pos = 762371340, events = 8, fd = 565153440, user_data = 0x19b03930043a}, {pos = 565153480, events = 8, fd = 565153928, user_data = 0x821af8eb0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2473389679, fd = 580948024, user_data = 0x800000001}, {pos = 580924424, events = 8, fd = 762315656, user_data = 0x822a08288}, {pos = 762284120, events = 8, fd = 580924424, user_data = 0x821af8f38}, {pos = 565154040, events = 8, fd = 565153568, user_data = 0x19b039304ca2}, {pos = 2701457, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 580948024, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 565154296, user_data = 0x22a03408}, {pos = 565154112, events = 8, fd = 565153712, user_data = 0x1}, {pos = 565154040, events = 8, fd = 32, user_data = 0x821af8fa0}, {pos = 959466099, events = 6576, fd = 565153984, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822a09038}, {pos = 1, events = 8, fd = 580924424, user_data = 0x82d6f8858}, {pos = 565154296, events = 8, fd = 565154112, user_data = 0x821af8fb0}, {pos = 0, events = 0, fd = 580894728, user_data = 0x20}, {pos = 565154096, events = 8, fd = 959441639, user_data = 0x8229fc008}, {pos = 580895752, events = 8, fd = 580896776, user_data = 0x8229fcc08}, {pos = 580911112, events = 8, fd = 580912136, user_data = 0x822a00808}, {pos = 580914184, events = 8, fd = 580915208, user_data = 0x822a01408}, {pos = 580917256, events = 8, fd = 580918280, user_data = 0x822a02008}, {pos = 580920328, events = 8, fd = 580921352, user_data = 0x822a02c08}, {pos = 580923400, events = 8, fd = 580924424, user_data = 0x822a03808}, {pos = 580926472, events = 8, fd = 580927496, user_data = 0x822a04408}, {pos = 580929544, events = 8, fd = 580930568, user_data = 0x822a05008}, {pos = 580932616, events = 8, fd = 580933640, user_data = 0x822a05c08}, {pos = 580939784, events = 8, fd = 580940808, user_data = 0x822a07808}, {pos = 580942856, events = 8, fd = 580894728, user_data = 0x293891}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822a09038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 565154296, events = 8, fd = 565153712, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 580948024, user_data = 0x1}, {pos = 580894728, events = 8, fd = 313, user_data = 0x821af91e0}, {pos = 959440367, events = 6576, fd = 2701457, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 580948024, user_data = 0x1}, {pos = 580924424, events = 8, fd = 935133184, user_data = 0x1}, {pos = 935133588, events = 8, fd = 0, user_data = 0x821af91b0}, {pos = 773465452, events = 8, fd = 1, user_data = 0x837bd0000}, {pos = 565154272, events = 8, fd = 773461762, user_data = 0x82d82a170 }, {pos = 12303552, events = 0, fd = 763535728, user_data = 0x822a03408}, {pos = 565154496, events = 8, fd = 959439838, user_data = 0x837bee800}, {pos = 1, events = 0, fd = 959439454, user_data = 0x8229fc008}, {pos = 565154280, events = 8, fd = 565154496, user_data = 0x1c20}, {pos = 935206592, events = 8, fd = 959519120, user_data = 0x0}, {pos = 565117823, events = 8, fd = 8107111, user_data = 0x821af9270}, {pos = 773424144, events = 8, fd = 764198960, user_data = 0x82d8ce310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821af92a0}, {pos = 773467037, events = 8, fd = 935133184, user_data = 0x1781}, {pos = 565154560, events = 8, fd = 773433594, user_data = 0x0}, {pos = 0, events = 0, fd = 419005029, user_data = 0x0}} [02:14:24.750] last_touch_time = 1727230211 [02:14:24.750] last_lockfile_recheck_time = 1727230211 [02:14:24.750] nevents = 1 [02:14:24.750] #22 0x000000000088d335 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821af98e0) at ../src/backend/postmaster/postmaster.c:1351 [02:14:24.750] userDoption = [02:14:24.750] listen_addr_saved = [02:14:24.750] output_config_variable = [02:14:24.750] opt = [02:14:24.750] status = [02:14:24.750] #23 0x00000000007c814c in main (argc=4, argv=0x821af98e0) at ../src/backend/main/main.c:197 [02:14:24.750] do_check_root = [02:14:24.763] [02:14:24.763] [02:14:24.763] [02:14:24.826] dumping /tmp/cores/postgres.13987.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:14:24.947] [New LWP 101643] [02:14:25.015] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [02:14:25.015] Program terminated with signal SIGABRT, Aborted. [02:14:25.015] Sent by thr_kill() from pid 13987 and user 1003. [02:14:25.015] #0 0x000000082b58d41a in thr_kill () from /lib/libc.so.7 [02:14:25.628] [02:14:25.628] Thread 1 (LWP 101643): [02:14:25.628] #0 0x000000082b58d41a in thr_kill () from /lib/libc.so.7 [02:14:25.628] No symbol table info available. [02:14:25.628] #1 0x000000082b506e64 in raise () from /lib/libc.so.7 [02:14:25.628] No symbol table info available. [02:14:25.628] #2 0x000000082b5b76f9 in abort () from /lib/libc.so.7 [02:14:25.628] No symbol table info available. [02:14:25.628] #3 0x0000000000a90b25 in ExceptionalCondition (conditionName=0x2d1b90 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [02:14:25.628] No locals. [02:14:25.628] #4 0x0000000000772caf in ExecFetchSlotHeapTuple (slot=0x8217cb308, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [02:14:25.628] No locals. [02:14:25.628] #5 0x0000000000737657 in ExecIRDeleteTriggers (estate=estate@entry=0x8357c7100, relinfo=relinfo@entry=0x8357c76b0, slot=slot@entry=0x8217cb308) at ../src/backend/commands/trigger.c:2842 [02:14:25.628] trigger = [02:14:25.628] oldtuple = [02:14:25.628] should_free = false [02:14:25.628] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83af20760, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [02:14:25.628] trigdesc = 0x8357c78c0 [02:14:25.628] newtuple = 0x0 [02:14:25.628] i = 0 [02:14:25.628] #6 0x0000000000797f74 in ExecMergeMatched (context=0x8217cb398, resultRelInfo=0x8357c76b0, tupleid=0x0, oldtuple=0x8217cb308, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3082 [02:14:25.628] result = TM_Ok [02:14:25.628] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [02:14:25.628] relaction = 0x83af57b60 [02:14:25.628] commandType = CMD_DELETE [02:14:25.628] l__state = {l = 0x83b0ce9b8, i = 0} [02:14:25.628] lockedtid = [02:14:25.628] mtstate = 0x8357c74a0 [02:14:25.628] newslot = 0x0 [02:14:25.628] rslot = 0x0 [02:14:25.628] estate = 0x8357c7100 [02:14:25.628] mergeActions = [02:14:25.628] econtext = 0x83b0cda58 [02:14:25.628] epqstate = 0x8357c7588 [02:14:25.628] actionStates = 0x83b0ce9b8 [02:14:25.628] l = [02:14:25.628] isNull = [02:14:25.628] lmerge_matched = [02:14:25.628] __error = [02:14:25.628] l__state = [02:14:25.628] result = [02:14:25.628] updateCxt = [02:14:25.628] relaction = [02:14:25.628] commandType = [02:14:25.628] __error = [02:14:25.628] resultRelationDesc = [02:14:25.628] lockmode = [02:14:25.628] inputslot = [02:14:25.628] epqslot = [02:14:25.628] was_matched = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] #7 ExecMerge (context=0x8217cb398, resultRelInfo=0x8357c76b0, tupleid=0x0, oldtuple=0x8217cb308, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2823 [02:14:25.628] matched = true [02:14:25.628] rslot = 0x0 [02:14:25.628] #8 ExecModifyTable (pstate=0x8357c74a0) at ../src/backend/executor/nodeModifyTable.c:4197 [02:14:25.628] context = {mtstate = 0x8357c74a0, epqstate = 0x8357c7588, estate = 0x8357c7100, planSlot = 0x83b0cbe58, tmfd = {ctid = {ip_blkid = {bi_hi = 40334, bi_lo = 11096}, ip_posid = 8}, xmax = 113, cmax = 0, traversed = 226}, cpUpdateReturningSlot = 0x8122d34d2bb8e8f8} [02:14:25.628] tuple_ctid = {ip_blkid = {bi_hi = 10015, bi_lo = 0}, ip_posid = 0} [02:14:25.628] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835861118} [02:14:25.628] node = 0x8357c74a0 [02:14:25.628] estate = 0x8357c7100 [02:14:25.628] operation = CMD_MERGE [02:14:25.628] resultRelInfo = 0x8357c76b0 [02:14:25.628] subplanstate = 0x8357c8db0 [02:14:25.628] slot = [02:14:25.628] tupleid = 0x0 [02:14:25.628] oldtuple = 0x8217cb308 [02:14:25.628] tuplock = [02:14:25.628] oldSlot = [02:14:25.628] #9 0x0000000000764e0b in ExecProcNode (node=0x8357c74a0) at ../src/include/executor/executor.h:278 [02:14:25.628] No locals. [02:14:25.628] #10 ExecutePlan (estate=0x8357c7100, planstate=0x8357c74a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x835820710, execute_once=) at ../src/backend/executor/execMain.c:1659 [02:14:25.628] current_tuple_count = 0 [02:14:25.628] slot = [02:14:25.628] #11 standard_ExecutorRun (queryDesc=0x835852448, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:364 [02:14:25.628] estate = 0x8357c7100 [02:14:25.628] oldcontext = 0x835820400 [02:14:25.628] operation = CMD_MERGE [02:14:25.628] dest = 0x835820710 [02:14:25.628] sendTuples = true [02:14:25.628] #12 0x0000000837338961 in pgss_ExecutorRun (queryDesc=0x835852448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1024 [02:14:25.628] _local_sigjmp_buf = {{_sjb = {35285862705, 1, 34921559240, 34921559408, 12373880, 34921559248, 1, 35257656392, 34921513855, 7830129, 35257085952, 34359738368}}} [02:14:25.628] _save_exception_stack = 0x8217cb680 [02:14:25.628] _save_context_stack = 0x0 [02:14:25.628] _do_rethrow = false [02:14:25.628] #13 0x000000000093b47f in ProcessQuery (plan=0x83b084b80, sourceText=, params=0x0, queryEnv=0x0, dest=0x835820710, qc=0x8217cb648) at ../src/backend/tcop/pquery.c:160 [02:14:25.628] queryDesc = 0x835852448 [02:14:25.628] #14 0x000000000093aa1d in PortalRunMulti (portal=portal@entry=0x835734100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x835820710, altdest=0xb82bd0 , qc=qc@entry=0x8217cb648) at ../src/backend/tcop/pquery.c:1287 [02:14:25.628] pstmt = 0x83b084b80 [02:14:25.628] stmtlist_item__state = {l = 0x83b089438, i = 0} [02:14:25.628] active_snapshot_set = true [02:14:25.628] stmtlist_item = 0x83b089450 [02:14:25.628] #15 0x000000000093a52c in FillPortalStore (portal=portal@entry=0x835734100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [02:14:25.628] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:14:25.628] treceiver = 0x835820710 [02:14:25.628] #16 0x000000000093a29b in PortalRun (portal=portal@entry=0x835734100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83b089488, altdest=altdest@entry=0x83b089488, qc=0x8217cb780) at ../src/backend/tcop/pquery.c:763 [02:14:25.628] _local_sigjmp_buf = {{_sjb = {9675325, 35256484096, 34921559672, 34921559904, 34921559680, 35256578048, 12340552, 12373880, 35256468351, 35255804160, 4294967984, 0}}} [02:14:25.628] _save_exception_stack = 0x8217cb850 [02:14:25.628] _save_context_stack = 0x0 [02:14:25.628] _do_rethrow = false [02:14:25.628] saveTopTransactionResourceOwner = 0x83577a8d8 [02:14:25.628] saveTopTransactionContext = 0x83574b000 [02:14:25.628] saveActivePortal = 0x0 [02:14:25.628] saveResourceOwner = 0x83577a8d8 [02:14:25.628] savePortalContext = 0x0 [02:14:25.628] saveMemoryContext = 0x83574b000 [02:14:25.628] result = [02:14:25.628] nprocessed = [02:14:25.628] #17 0x0000000000939162 in exec_simple_query (query_string=query_string@entry=0x83568e100 "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 [02:14:25.628] cmdtaglen = 5 [02:14:25.628] snapshot_set = [02:14:25.628] per_parsetree_context = 0x0 [02:14:25.628] plantree_list = [02:14:25.628] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:14:25.628] format = 0 [02:14:25.628] parsetree = 0x83b040ee8 [02:14:25.628] commandTag = [02:14:25.628] cmdtagname = [02:14:25.628] querytree_list = [02:14:25.628] portal = 0x835734100 [02:14:25.628] receiver = 0x83b089488 [02:14:25.628] parsetree_item__state = {l = 0x83b0427b0, i = 0} [02:14:25.628] msec_str = "\000\000\000\000\b", '\000' , ",q\363f\000\000\000\000ʽ\252[\356\342s\245" [02:14:25.628] dest = DestRemote [02:14:25.628] was_logged = [02:14:25.628] oldcontext = 0x83574b000 [02:14:25.628] parsetree_list = 0x83b0427b0 [02:14:25.628] use_implicit_block = false [02:14:25.628] parsetree_item = 0x83b0427c8 [02:14:25.628] save_log_statement_stats = [02:14:25.628] #18 0x0000000000936dd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [02:14:25.628] query_string = 0x83568e100 "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"... [02:14:25.628] input_message = {data = 0x83568e100 "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} [02:14:25.628] firstchar = [02:14:25.628] local_sigjmp_buf = {{_sjb = {9659014, 34921560144, 34921560104, 34921560688, 12382616, 1, 8192, 8388608, 895, 0, 0, 1}}} [02:14:25.628] send_ready_for_query = false [02:14:25.628] idle_in_transaction_timeout_enabled = false [02:14:25.628] idle_session_timeout_enabled = false [02:14:25.628] #19 0x00000000009315b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:14:25.628] bsdata = [02:14:25.628] #20 0x000000000088b147 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8217cc594 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8217cc4d0) at ../src/backend/postmaster/launch_backend.c:274 [02:14:25.628] pid = [02:14:25.628] #21 0x000000000088f518 in BackendStartup (client_sock=0x8217cc4d0) at ../src/backend/postmaster/postmaster.c:3420 [02:14:25.628] startup_data = {canAcceptConnections = CAC_OK} [02:14:25.628] bn = 0x83569a3f8 [02:14:25.628] pid = [02:14:25.628] __error = [02:14:25.628] save_errno = [02:14:25.628] __error = [02:14:25.628] __error = [02:14:25.628] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [02:14:25.628] 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 = " \354h5\b", '\000' , "0\305|!\b\000\000\000hu\025*\b\000\000\000\v\000\000\000\000\000\000\000^\377\025*\b", '\000' , "p\305|!\b\000\000\000\364\256\210\000\000\000\000\000\200\305|!\b", '\000' }, salen = 16}} [02:14:25.628] i = 0 [02:14:25.628] now = [02:14:25.628] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 726867074, events = 8, fd = 0, user_data = 0x8217cc480}, {pos = 896493016, events = 8, fd = 561824528, user_data = 0x0}, {pos = 1422373642, events = 7912, fd = 726034336, user_data = 0x82b477d78}, {pos = 561823624, events = 8, fd = 561823744, user_data = 0x8217cbf88}, {pos = 1422373642, events = 7912, fd = 726012808, user_data = 0x82b477d78}, {pos = 561823672, events = 8, fd = 561823792, user_data = 0x8217cbfb8}, {pos = 726073748, events = 8, fd = 564565000, user_data = 0x82b470194}, {pos = 561823776, events = 8, fd = 1422353466, user_data = 0x8217cbfc0}, {pos = 706040848, events = 8, fd = 727896112, user_data = 0x1ee854c7b30a}, {pos = 725981272, events = 8, fd = 726105464, user_data = 0x8217cc028}, {pos = 561823904, events = 8, fd = 561823784, user_data = 0x82b46ed0c}, {pos = 564565000, events = 8, fd = 726068492, user_data = 0x8217cc090}, {pos = 1422353466, events = 7912, fd = 561823928, user_data = 0x8217cc288}, {pos = 561823904, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821a6f038}, {pos = 1, events = 2166543181, fd = 564565000, user_data = 0x82b461388}, {pos = 564586440, events = 8, fd = 0, user_data = 0x0}, {pos = 561824040, events = 8, fd = 561824504, user_data = 0x8217cc110}, {pos = 1422372002, events = 7912, fd = 2701457, user_data = 0x6d68b}, {pos = 2090263927, events = 2166543181, fd = 564588600, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8217cc3f8}, {pos = 564565000, events = 3, fd = 561824576, user_data = 0x821a6e828}, {pos = 656, events = 0, fd = 561824504, user_data = 0x8217cc128}, {pos = 561824144, events = 8, fd = 1422371611, user_data = 0x8217cc2c0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 564588600, events = 8, fd = 1, user_data = 0x821a69408}, {pos = 725981272, events = 8, fd = 561824760, user_data = 0x8217cc340}, {pos = 561824160, events = 8, fd = 0, user_data = 0x821a62008}, {pos = 33, events = 0, fd = 561824560, user_data = 0x1ee854c74ae7}, {pos = 564535304, events = 8, fd = 564536328, user_data = 0x821a62808}, {pos = 564538376, events = 8, fd = 564551688, user_data = 0x821a66408}, {pos = 564553736, events = 8, fd = 564554760, user_data = 0x821a67008}, {pos = 564556808, events = 8, fd = 564557832, user_data = 0x821a67c08}, {pos = 564559880, events = 8, fd = 564560904, user_data = 0x821a68808}, {pos = 564562952, events = 8, fd = 564563976, user_data = 0x821a69408}, {pos = 564566024, events = 8, fd = 564567048, user_data = 0x821a6a008}, {pos = 564569096, events = 8, fd = 564570120, user_data = 0x821a6ac08}, {pos = 564572168, events = 8, fd = 564573192, user_data = 0x821a6b808}, {pos = 564575240, events = 8, fd = 564580360, user_data = 0x821a6d408}, {pos = 564582408, events = 8, fd = 564583432, user_data = 0x821a70408}, {pos = 476845000, events = 0, fd = 564535304, user_data = 0x293891}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821a6f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 561824760, events = 8, fd = 561824160, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 564588600, user_data = 0x1}, {pos = 564535304, events = 8, fd = 313, user_data = 0x8217cc3e0}, {pos = 1422345711, events = 7912, fd = 2701457, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564588600, user_data = 0x1}, {pos = 564565000, events = 8, fd = 896000000, user_data = 0x1}, {pos = 896000404, events = 8, fd = 0, user_data = 0x8217cc3b0}, {pos = 706082156, events = 8, fd = 1, user_data = 0x83567e000}, {pos = 561824736, events = 8, fd = 706078466, user_data = 0x82b58b170 }, {pos = 12303552, events = 0, fd = 727232880, user_data = 0x821a69408}, {pos = 561824960, events = 8, fd = 1422345182, user_data = 0x83569c800}, {pos = 1, events = 0, fd = 1422344798, user_data = 0x821a62008}, {pos = 561824744, events = 8, fd = 561824960, user_data = 0x1c20}, {pos = 896068640, events = 8, fd = 1422424464, user_data = 0x0}, {pos = 561775487, events = 8, fd = 8107111, user_data = 0x8217cc470}, {pos = 706040848, events = 8, fd = 727896112, user_data = 0x82b62f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8217cc4a0}, {pos = 706083741, events = 8, fd = 896000000, user_data = 0x300e}, {pos = 561825024, events = 8, fd = 706050298, user_data = 0x0}, {pos = 0, events = 0, fd = 733538552, user_data = 0x0}} [02:14:25.628] last_touch_time = 1727230242 [02:14:25.628] last_lockfile_recheck_time = 1727230242 [02:14:25.628] nevents = 1 [02:14:25.628] #23 0x000000000088d335 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8217ccae0) at ../src/backend/postmaster/postmaster.c:1351 [02:14:25.628] userDoption = [02:14:25.628] listen_addr_saved = [02:14:25.628] output_config_variable = [02:14:25.628] opt = [02:14:25.628] status = [02:14:25.628] #24 0x00000000007c814c in main (argc=4, argv=0x8217ccae0) at ../src/backend/main/main.c:197 [02:14:25.628] do_check_root =