[21:47:56.716] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [21:47:57.100] dumping /tmp/cores/postgres.8830.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [21:47:57.256] [New LWP 101828] [21:47:57.358] Core was generated by `postgres: postgres regression [local] MERGE'. [21:47:57.358] Program terminated with signal SIGABRT, Aborted. [21:47:57.358] Sent by thr_kill() from pid 8830 and user 1003. [21:47:57.358] #0 0x000000082cf3c41a in thr_kill () from /lib/libc.so.7 [21:47:58.084] [21:47:58.084] Thread 1 (LWP 101828): [21:47:58.084] #0 0x000000082cf3c41a in thr_kill () from /lib/libc.so.7 [21:47:58.084] No symbol table info available. [21:47:58.084] #1 0x000000082ceb5e64 in raise () from /lib/libc.so.7 [21:47:58.084] No symbol table info available. [21:47:58.084] #2 0x000000082cf666f9 in abort () from /lib/libc.so.7 [21:47:58.084] No symbol table info available. [21:47:58.084] #3 0x0000000000a8f9b5 in ExceptionalCondition (conditionName=0x2d1a1d "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:47:58.084] No locals. [21:47:58.084] #4 0x000000000077254f in ExecFetchSlotHeapTuple (slot=0x8210036d0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [21:47:58.084] No locals. [21:47:58.084] #5 0x0000000000737017 in ExecIRDeleteTriggers (estate=estate@entry=0x838357100, relinfo=relinfo@entry=0x8383576b0, slot=slot@entry=0x8210036d0) at ../src/backend/commands/trigger.c:2842 [21:47:58.084] trigger = [21:47:58.084] oldtuple = [21:47:58.084] should_free = false [21:47:58.084] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8471c4de0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:47:58.084] trigdesc = 0x8383578c0 [21:47:58.084] newtuple = 0x0 [21:47:58.084] i = 0 [21:47:58.084] #6 0x0000000000797727 in ExecMergeMatched (context=0x821003778, resultRelInfo=0x8383576b0, tupleid=0x0, oldtuple=0x8210036d0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [21:47:58.084] result = TM_Ok [21:47:58.084] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:47:58.084] relaction = 0x844f158a0 [21:47:58.084] commandType = CMD_DELETE [21:47:58.084] l__state = {l = 0x844fe14f8, i = 0} [21:47:58.084] mtstate = 0x8383574a0 [21:47:58.084] newslot = 0x0 [21:47:58.084] rslot = 0x0 [21:47:58.084] estate = 0x838357100 [21:47:58.084] mergeActions = [21:47:58.084] econtext = 0x844fe0598 [21:47:58.084] epqstate = 0x838357588 [21:47:58.084] actionStates = 0x844fe14f8 [21:47:58.084] l = [21:47:58.084] isNull = [21:47:58.084] lmerge_matched = [21:47:58.084] __error = [21:47:58.084] l__state = [21:47:58.084] result = [21:47:58.084] updateCxt = [21:47:58.084] relaction = [21:47:58.084] commandType = [21:47:58.084] __error = [21:47:58.084] resultRelationDesc = [21:47:58.084] lockmode = [21:47:58.084] inputslot = [21:47:58.084] epqslot = [21:47:58.084] was_matched = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] #7 ExecMerge (context=0x821003778, resultRelInfo=0x8383576b0, tupleid=0x0, oldtuple=0x8210036d0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [21:47:58.084] matched = [21:47:58.084] rslot = 0x0 [21:47:58.084] #8 ExecModifyTable (pstate=0x8383574a0) at ../src/backend/executor/nodeModifyTable.c:4133 [21:47:58.084] context = {mtstate = 0x8383574a0, epqstate = 0x838357588, estate = 0x838357100, planSlot = 0x844fde998, tmfd = {ctid = {ip_blkid = {bi_hi = 62512, bi_lo = 17657}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8383576b0} [21:47:58.084] tuple_ctid = {ip_blkid = {bi_hi = 11848, bi_lo = 14388}, ip_posid = 8} [21:47:58.084] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8383d9118} [21:47:58.084] node = 0x8383574a0 [21:47:58.084] estate = 0x838357100 [21:47:58.084] operation = CMD_MERGE [21:47:58.084] resultRelInfo = 0x8383576b0 [21:47:58.084] subplanstate = 0x838358db0 [21:47:58.084] slot = [21:47:58.084] tupleid = 0x0 [21:47:58.084] oldtuple = 0x8210036d0 [21:47:58.084] oldSlot = [21:47:58.084] #9 0x000000000076471b in ExecProcNode (node=0x8383574a0) at ../src/include/executor/executor.h:278 [21:47:58.084] No locals. [21:47:58.084] #10 ExecutePlan (estate=0x838357100, planstate=0x8383574a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x8383a4b10, execute_once=) at ../src/backend/executor/execMain.c:1653 [21:47:58.084] current_tuple_count = 0 [21:47:58.084] slot = [21:47:58.084] #11 standard_ExecutorRun (queryDesc=0x8383b9448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [21:47:58.084] estate = 0x838357100 [21:47:58.084] oldcontext = 0x8383a4800 [21:47:58.084] operation = CMD_MERGE [21:47:58.084] dest = 0x8383a4b10 [21:47:58.084] sendTuples = true [21:47:58.084] #12 0x000000000093a59f in ProcessQuery (plan=0x844f9ed18, sourceText=, params=0x0, queryEnv=0x0, dest=0x8383a4b10, qc=0x821003978) at ../src/backend/tcop/pquery.c:160 [21:47:58.084] queryDesc = 0x8383b9448 [21:47:58.084] #13 0x0000000000939b3d in PortalRunMulti (portal=portal@entry=0x8382d2100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x8383a4b10, altdest=0xb819f0 , qc=qc@entry=0x821003978) at ../src/backend/tcop/pquery.c:1287 [21:47:58.084] pstmt = 0x844f9ed18 [21:47:58.084] stmtlist_item__state = {l = 0x844fa35d0, i = 0} [21:47:58.084] active_snapshot_set = true [21:47:58.084] stmtlist_item = 0x844fa35e8 [21:47:58.084] #14 0x000000000093964c in FillPortalStore (portal=portal@entry=0x8382d2100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:47:58.084] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:47:58.084] treceiver = 0x8383a4b10 [21:47:58.084] #15 0x00000000009393bb in PortalRun (portal=portal@entry=0x8382d2100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x844fa3620, altdest=altdest@entry=0x844fa3620, qc=0x821003ab0) at ../src/backend/tcop/pquery.c:763 [21:47:58.084] _local_sigjmp_buf = {{_sjb = {9671517, 35302220032, 34913401256, 34913401488, 34913401264, 35302240256, 12331880, 12365208, 35302212479, 35301347584, 4294967984, 0}}} [21:47:58.084] _save_exception_stack = 0x821003b80 [21:47:58.084] _save_context_stack = 0x0 [21:47:58.084] _do_rethrow = false [21:47:58.084] saveTopTransactionResourceOwner = 0x8382e4a18 [21:47:58.084] saveTopTransactionContext = 0x8382d7000 [21:47:58.084] saveActivePortal = 0x0 [21:47:58.084] saveResourceOwner = 0x8382e4a18 [21:47:58.084] savePortalContext = 0x0 [21:47:58.084] saveMemoryContext = 0x8382d7000 [21:47:58.084] result = [21:47:58.084] nprocessed = [21:47:58.084] #16 0x0000000000938282 in exec_simple_query (query_string=query_string@entry=0x8381fd100 "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 [21:47:58.084] cmdtaglen = 5 [21:47:58.084] snapshot_set = [21:47:58.084] per_parsetree_context = 0x0 [21:47:58.084] plantree_list = [21:47:58.084] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:47:58.084] format = 0 [21:47:58.084] parsetree = 0x844f549e8 [21:47:58.084] commandTag = [21:47:58.084] cmdtagname = [21:47:58.084] querytree_list = [21:47:58.084] portal = 0x8382d2100 [21:47:58.084] receiver = 0x844fa3620 [21:47:58.084] parsetree_item__state = {l = 0x844f562b0, i = 0} [21:47:58.084] msec_str = "\000\000\000\000\b", '\000' , "\201\354\355f\000\000\000\000\025\372\204\232;o", [21:47:58.084] dest = DestRemote [21:47:58.084] was_logged = [21:47:58.084] oldcontext = 0x8382d7000 [21:47:58.084] parsetree_list = 0x844f562b0 [21:47:58.084] use_implicit_block = false [21:47:58.084] parsetree_item = 0x844f562c8 [21:47:58.084] save_log_statement_stats = [21:47:58.084] #17 0x0000000000935ef3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [21:47:58.084] query_string = 0x8381fd100 "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"... [21:47:58.084] input_message = {data = 0x8381fd100 "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} [21:47:58.084] firstchar = [21:47:58.084] local_sigjmp_buf = {{_sjb = {9655206, 34913401728, 34913401688, 34913402272, 12373944, 1, 8192, 8388608, 34913387391, 0, 0, 1}}} [21:47:58.084] send_ready_for_query = false [21:47:58.084] idle_in_transaction_timeout_enabled = false [21:47:58.084] idle_session_timeout_enabled = false [21:47:58.084] #18 0x00000000009306e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [21:47:58.084] bsdata = [21:47:58.084] #19 0x000000000088a837 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8210048c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821004800) at ../src/backend/postmaster/launch_backend.c:274 [21:47:58.084] pid = [21:47:58.084] #20 0x000000000088ebf8 in BackendStartup (client_sock=0x821004800) at ../src/backend/postmaster/postmaster.c:3415 [21:47:58.084] startup_data = {canAcceptConnections = CAC_OK} [21:47:58.084] bn = 0x8382090d8 [21:47:58.084] pid = [21:47:58.084] __error = [21:47:58.084] save_errno = [21:47:58.084] __error = [21:47:58.084] __error = [21:47:58.084] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [21:47:58.084] 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\357\0378\b", '\000' , "`H\000!\b\000\000\000h\245\364+\b\000\000\000\v\000\000\000\000\000\000\000^/\365+\b", '\000' , "\240H\000!\b\000\000\000䥈\000\000\000\000\000\260H\000!\b", '\000' }, salen = 16}} [21:47:58.084] i = 0 [21:47:58.084] now = [21:47:58.084] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 753798274, events = 8, fd = 0, user_data = 0x8210047b0}, {pos = 942007768, events = 8, fd = 553666112, user_data = 0x0}, {pos = 0, events = 0, fd = -1765222716, user_data = 0x20c1c7b6f30a}, {pos = 752965536, events = 8, fd = 753036664, user_data = 0x8210042c8}, {pos = 553665344, events = 8, fd = 553665224, user_data = 0x20c1c7b6f30a}, {pos = 752944008, events = 8, fd = 753036664, user_data = 0x8210042f8}, {pos = 553665392, events = 8, fd = 553665272, user_data = 0x82ce1f194}, {pos = 565122056, events = 8, fd = 753004948, user_data = 0x821004360}, {pos = -944331718, events = 8385, fd = 754827312, user_data = 0x1}, {pos = 553665424, events = 8, fd = -944311542, user_data = 0x82ce08858}, {pos = 753036664, events = 8, fd = 553665384, user_data = 0x8210043e0}, {pos = 553665384, events = 8, fd = 752999692, user_data = 0x821af1408}, {pos = 752999692, events = 8, fd = 553665488, user_data = 0x20c1c7b6a43a}, {pos = 553665528, events = 8, fd = 553665976, user_data = 0x8210043e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3077583275, fd = 565145656, user_data = 0x800000001}, {pos = 565122056, events = 8, fd = 752944008, user_data = 0x821af6288}, {pos = 752912472, events = 8, fd = 565122056, user_data = 0x821004468}, {pos = 553666088, events = 8, fd = 553665616, user_data = 0x20c1c7b6eca2}, {pos = 2700919, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 565145656, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 553666344, user_data = 0x21af1408}, {pos = 553666160, events = 8, fd = 553665760, user_data = 0x1}, {pos = 553666088, events = 8, fd = 32, user_data = 0x8210044d0}, {pos = -944313741, events = 8385, fd = 553666032, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821af7038}, {pos = 1, events = 8, fd = 565122056, user_data = 0x82ce08858}, {pos = 553666344, events = 8, fd = 553666160, user_data = 0x8210044e0}, {pos = 0, events = 0, fd = 565092360, user_data = 0x20}, {pos = 553666144, events = 8, fd = -944338201, user_data = 0x821aea008}, {pos = 565093384, events = 8, fd = 565094408, user_data = 0x821aeac08}, {pos = 565108744, events = 8, fd = 565109768, user_data = 0x821aee808}, {pos = 565111816, events = 8, fd = 565112840, user_data = 0x821aef408}, {pos = 565114888, events = 8, fd = 565115912, user_data = 0x821af0008}, {pos = 565117960, events = 8, fd = 565118984, user_data = 0x821af0c08}, {pos = 565121032, events = 8, fd = 565122056, user_data = 0x821af1808}, {pos = 565124104, events = 8, fd = 565125128, user_data = 0x821af2408}, {pos = 565127176, events = 8, fd = 565128200, user_data = 0x821af3008}, {pos = 565130248, events = 8, fd = 565131272, user_data = 0x821af3c08}, {pos = 565137416, events = 8, fd = 565138440, user_data = 0x821af5808}, {pos = 565140488, events = 8, fd = 565092360, user_data = 0x293677}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821af7038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 553666344, events = 8, fd = 553665760, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 565145656, user_data = 0x1}, {pos = 565092360, events = 8, fd = 313, user_data = 0x821004710}, {pos = -944339473, events = 8385, fd = 2700919, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565145656, user_data = 0x1}, {pos = 565122056, events = 8, fd = 941543424, user_data = 0x1}, {pos = 941543828, events = 8, fd = 0, user_data = 0x8210046e0}, {pos = 737486188, events = 8, fd = 1, user_data = 0x8381ed000}, {pos = 553666320, events = 8, fd = 737482498, user_data = 0x82cf3a170 }, {pos = 12298976, events = 0, fd = 754164080, user_data = 0x821af1408}, {pos = 553666544, events = 8, fd = -944340002, user_data = 0x83820b800}, {pos = 1, events = 0, fd = -944340386, user_data = 0x821aea008}, {pos = 553666328, events = 8, fd = 553666544, user_data = 0x1c20}, {pos = 941616896, events = 8, fd = -944260720, user_data = 0x0}, {pos = 553649023, events = 8, fd = 8104791, user_data = 0x8210047a0}, {pos = 737444880, events = 8, fd = 754827312, user_data = 0x82cfde310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8210047d0}, {pos = 737487773, events = 8, fd = 941543424, user_data = 0x1af6}, {pos = 553666608, events = 8, fd = 737454330, user_data = 0x0}, {pos = 0, events = 0, fd = -1765222716, user_data = 0x0}} [21:47:58.084] last_touch_time = 1726868599 [21:47:58.084] last_lockfile_recheck_time = 1726868599 [21:47:58.084] nevents = 1 [21:47:58.084] #22 0x000000000088ca15 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821004e10) at ../src/backend/postmaster/postmaster.c:1346 [21:47:58.084] userDoption = [21:47:58.084] listen_addr_saved = [21:47:58.084] output_config_variable = [21:47:58.084] opt = [21:47:58.084] status = [21:47:58.084] #23 0x00000000007c783c in main (argc=8, argv=0x821004e10) at ../src/backend/main/main.c:197 [21:47:58.084] do_check_root = [21:47:58.100] [21:47:58.100] [21:47:58.100] [21:47:58.169] dumping /tmp/cores/postgres.9003.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:47:58.304] [New LWP 100106] [21:47:58.380] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [21:47:58.380] Program terminated with signal SIGABRT, Aborted. [21:47:58.380] Sent by thr_kill() from pid 9003 and user 1003. [21:47:58.380] #0 0x000000082a15e41a in thr_kill () from /lib/libc.so.7 [21:47:59.076] [21:47:59.076] Thread 1 (LWP 100106): [21:47:59.076] #0 0x000000082a15e41a in thr_kill () from /lib/libc.so.7 [21:47:59.076] No symbol table info available. [21:47:59.076] #1 0x000000082a0d7e64 in raise () from /lib/libc.so.7 [21:47:59.076] No symbol table info available. [21:47:59.076] #2 0x000000082a1886f9 in abort () from /lib/libc.so.7 [21:47:59.076] No symbol table info available. [21:47:59.076] #3 0x0000000000a8f9b5 in ExceptionalCondition (conditionName=0x2d1a1d "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:47:59.076] No locals. [21:47:59.076] #4 0x000000000077254f in ExecFetchSlotHeapTuple (slot=0x8210f1830, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [21:47:59.076] No locals. [21:47:59.076] #5 0x0000000000737017 in ExecIRDeleteTriggers (estate=estate@entry=0x832cbe100, relinfo=relinfo@entry=0x832cbe6b0, slot=slot@entry=0x8210f1830) at ../src/backend/commands/trigger.c:2842 [21:47:59.076] trigger = [21:47:59.076] oldtuple = [21:47:59.076] should_free = false [21:47:59.076] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83d704b10, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:47:59.076] trigdesc = 0x832cbe8c0 [21:47:59.076] newtuple = 0x0 [21:47:59.076] i = 0 [21:47:59.076] #6 0x0000000000797727 in ExecMergeMatched (context=0x8210f18d8, resultRelInfo=0x832cbe6b0, tupleid=0x0, oldtuple=0x8210f1830, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [21:47:59.076] result = TM_Ok [21:47:59.076] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:47:59.076] relaction = 0x83d7c6ea0 [21:47:59.076] commandType = CMD_DELETE [21:47:59.076] l__state = {l = 0x83d897f78, i = 0} [21:47:59.076] mtstate = 0x832cbe4a0 [21:47:59.076] newslot = 0x0 [21:47:59.076] rslot = 0x0 [21:47:59.076] estate = 0x832cbe100 [21:47:59.076] mergeActions = [21:47:59.076] econtext = 0x83d897018 [21:47:59.076] epqstate = 0x832cbe588 [21:47:59.076] actionStates = 0x83d897f78 [21:47:59.076] l = [21:47:59.076] isNull = [21:47:59.076] lmerge_matched = [21:47:59.076] __error = [21:47:59.076] l__state = [21:47:59.076] result = [21:47:59.076] updateCxt = [21:47:59.076] relaction = [21:47:59.076] commandType = [21:47:59.076] __error = [21:47:59.076] resultRelationDesc = [21:47:59.076] lockmode = [21:47:59.076] inputslot = [21:47:59.076] epqslot = [21:47:59.076] was_matched = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] #7 ExecMerge (context=0x8210f18d8, resultRelInfo=0x832cbe6b0, tupleid=0x0, oldtuple=0x8210f1830, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [21:47:59.076] matched = [21:47:59.076] rslot = 0x0 [21:47:59.076] #8 ExecModifyTable (pstate=0x832cbe4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [21:47:59.076] context = {mtstate = 0x832cbe4a0, epqstate = 0x832cbe588, estate = 0x832cbe100, planSlot = 0x83d895418, tmfd = {ctid = {ip_blkid = {bi_hi = 23920, bi_lo = 15749}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x832cbe6b0} [21:47:59.076] tuple_ctid = {ip_blkid = {bi_hi = 49872, bi_lo = 15823}, ip_posid = 8} [21:47:59.076] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x832b52118} [21:47:59.076] node = 0x832cbe4a0 [21:47:59.076] estate = 0x832cbe100 [21:47:59.076] operation = CMD_MERGE [21:47:59.076] resultRelInfo = 0x832cbe6b0 [21:47:59.076] subplanstate = 0x832cbfdb0 [21:47:59.076] slot = [21:47:59.076] tupleid = 0x0 [21:47:59.076] oldtuple = 0x8210f1830 [21:47:59.076] oldSlot = [21:47:59.076] #9 0x000000000076471b in ExecProcNode (node=0x832cbe4a0) at ../src/include/executor/executor.h:278 [21:47:59.076] No locals. [21:47:59.076] #10 ExecutePlan (estate=0x832cbe100, planstate=0x832cbe4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x832b3c310, execute_once=) at ../src/backend/executor/execMain.c:1653 [21:47:59.076] current_tuple_count = 0 [21:47:59.076] slot = [21:47:59.076] #11 standard_ExecutorRun (queryDesc=0x832c14c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [21:47:59.076] estate = 0x832cbe100 [21:47:59.076] oldcontext = 0x832b3c000 [21:47:59.076] operation = CMD_MERGE [21:47:59.076] dest = 0x832b3c310 [21:47:59.076] sendTuples = true [21:47:59.076] #12 0x000000000093a59f in ProcessQuery (plan=0x83d855658, sourceText=, params=0x0, queryEnv=0x0, dest=0x832b3c310, qc=0x8210f1ad8) at ../src/backend/tcop/pquery.c:160 [21:47:59.076] queryDesc = 0x832c14c48 [21:47:59.076] #13 0x0000000000939b3d in PortalRunMulti (portal=portal@entry=0x832ba6100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x832b3c310, altdest=0xb819f0 , qc=qc@entry=0x8210f1ad8) at ../src/backend/tcop/pquery.c:1287 [21:47:59.076] pstmt = 0x83d855658 [21:47:59.076] stmtlist_item__state = {l = 0x83d859f10, i = 0} [21:47:59.076] active_snapshot_set = true [21:47:59.076] stmtlist_item = 0x83d859f28 [21:47:59.076] #14 0x000000000093964c in FillPortalStore (portal=portal@entry=0x832ba6100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:47:59.076] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:47:59.076] treceiver = 0x832b3c310 [21:47:59.076] #15 0x00000000009393bb in PortalRun (portal=portal@entry=0x832ba6100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83d859f60, altdest=altdest@entry=0x83d859f60, qc=0x8210f1c10) at ../src/backend/tcop/pquery.c:763 [21:47:59.076] _local_sigjmp_buf = {{_sjb = {9671517, 35210813696, 34914376456, 34914376688, 34914376464, 35210829824, 12331880, 12365208, 35210789759, 35210141952, 4294967984, 0}}} [21:47:59.076] _save_exception_stack = 0x8210f1ce0 [21:47:59.076] _save_context_stack = 0x0 [21:47:59.076] _do_rethrow = false [21:47:59.076] saveTopTransactionResourceOwner = 0x832bf5118 [21:47:59.076] saveTopTransactionContext = 0x832baa000 [21:47:59.076] saveActivePortal = 0x0 [21:47:59.076] saveResourceOwner = 0x832bf5118 [21:47:59.076] savePortalContext = 0x0 [21:47:59.076] saveMemoryContext = 0x832baa000 [21:47:59.076] result = [21:47:59.076] nprocessed = [21:47:59.076] #16 0x0000000000938282 in exec_simple_query (query_string=query_string@entry=0x832b02100 "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 [21:47:59.076] cmdtaglen = 5 [21:47:59.076] snapshot_set = [21:47:59.076] per_parsetree_context = 0x0 [21:47:59.076] plantree_list = [21:47:59.076] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:47:59.076] format = 0 [21:47:59.076] parsetree = 0x83d804d28 [21:47:59.076] commandTag = [21:47:59.076] cmdtagname = [21:47:59.076] querytree_list = [21:47:59.076] portal = 0x832ba6100 [21:47:59.076] receiver = 0x83d859f60 [21:47:59.076] parsetree_item__state = {l = 0x83d8065f0, i = 0} [21:47:59.076] msec_str = "\000\000\000\000\b", '\000' , "\203\354\355f\000\000\000\000e\001N\201\002\332Pk" [21:47:59.076] dest = DestRemote [21:47:59.076] was_logged = [21:47:59.076] oldcontext = 0x832baa000 [21:47:59.076] parsetree_list = 0x83d8065f0 [21:47:59.076] use_implicit_block = false [21:47:59.076] parsetree_item = 0x83d806608 [21:47:59.076] save_log_statement_stats = [21:47:59.076] #17 0x0000000000935ef3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [21:47:59.076] query_string = 0x832b02100 "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"... [21:47:59.076] input_message = {data = 0x832b02100 "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} [21:47:59.076] firstchar = [21:47:59.076] local_sigjmp_buf = {{_sjb = {9655206, 34914376928, 34914376888, 34914377472, 12373944, 1, 8192, 8388608, 34914370431, 0, 0, 1}}} [21:47:59.076] send_ready_for_query = false [21:47:59.076] idle_in_transaction_timeout_enabled = false [21:47:59.076] idle_session_timeout_enabled = false [21:47:59.076] #18 0x00000000009306e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [21:47:59.076] bsdata = [21:47:59.076] #19 0x000000000088a837 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8210f2a24 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8210f2960) at ../src/backend/postmaster/launch_backend.c:274 [21:47:59.076] pid = [21:47:59.076] #20 0x000000000088ebf8 in BackendStartup (client_sock=0x8210f2960) at ../src/backend/postmaster/postmaster.c:3415 [21:47:59.076] startup_data = {canAcceptConnections = CAC_OK} [21:47:59.076] bn = 0x832b0e448 [21:47:59.076] pid = [21:47:59.076] __error = [21:47:59.076] save_errno = [21:47:59.076] __error = [21:47:59.076] __error = [21:47:59.076] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [21:47:59.076] 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>\2602\b", '\000' , "\300)\017!\b\000\000\000h\205\311)\b\000\000\000\v\000\000\000\000\000\000\000^\017\312)\b", '\000' , "*\017!\b\000\000\000䥈\000\000\000\000\000\020*\017!\b", '\000' }, salen = 16}} [21:47:59.076] i = 0 [21:47:59.076] now = [21:47:59.076] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 705703042, events = 8, fd = 0, user_data = 0x8210f2910}, {pos = 850830808, events = 8, fd = 554641312, user_data = 0x0}, {pos = 0, events = 0, fd = -870005231, user_data = 0x35083710930a}, {pos = 704870304, events = 8, fd = 704941432, user_data = 0x8210f2428}, {pos = 554640544, events = 8, fd = 554640424, user_data = 0x35083710930a}, {pos = 704848776, events = 8, fd = 704941432, user_data = 0x8210f2458}, {pos = 554640592, events = 8, fd = 554640472, user_data = 0x82a041194}, {pos = 565199880, events = 8, fd = 704909716, user_data = 0x8210f24c0}, {pos = 923812922, events = 13576, fd = 706732080, user_data = 0x1}, {pos = 554640624, events = 8, fd = 923833098, user_data = 0x82a02a858}, {pos = 704941432, events = 8, fd = 554640584, user_data = 0x8210f2540}, {pos = 554640584, events = 8, fd = 704904460, user_data = 0x821b04408}, {pos = 704904460, events = 8, fd = 554640688, user_data = 0x35083710443a}, {pos = 554640728, events = 8, fd = 554641176, user_data = 0x8210f2540}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2239865372, fd = 565223480, user_data = 0x800000001}, {pos = 565199880, events = 8, fd = 704848776, user_data = 0x821b09288}, {pos = 704817240, events = 8, fd = 565199880, user_data = 0x8210f25c8}, {pos = 554641288, events = 8, fd = 554640816, user_data = 0x350837108ca2}, {pos = 2700919, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 565223480, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554641544, user_data = 0x21b04408}, {pos = 554641360, events = 8, fd = 554640960, user_data = 0x1}, {pos = 554641288, events = 8, fd = 32, user_data = 0x8210f2630}, {pos = 923830899, events = 13576, fd = 554641232, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821b0a038}, {pos = 1, events = 8, fd = 565199880, user_data = 0x82a02a858}, {pos = 554641544, events = 8, fd = 554641360, user_data = 0x8210f2640}, {pos = 0, events = 0, fd = 565170184, user_data = 0x20}, {pos = 554641344, events = 8, fd = 923806439, user_data = 0x821afd008}, {pos = 565171208, events = 8, fd = 565172232, user_data = 0x821afdc08}, {pos = 565186568, events = 8, fd = 565187592, user_data = 0x821b01808}, {pos = 565189640, events = 8, fd = 565190664, user_data = 0x821b02408}, {pos = 565192712, events = 8, fd = 565193736, user_data = 0x821b03008}, {pos = 565195784, events = 8, fd = 565196808, user_data = 0x821b03c08}, {pos = 565198856, events = 8, fd = 565199880, user_data = 0x821b04808}, {pos = 565201928, events = 8, fd = 565202952, user_data = 0x821b05408}, {pos = 565205000, events = 8, fd = 565206024, user_data = 0x821b06008}, {pos = 565208072, events = 8, fd = 565209096, user_data = 0x821b06c08}, {pos = 565215240, events = 8, fd = 565216264, user_data = 0x821b08808}, {pos = 565218312, events = 8, fd = 565170184, user_data = 0x293677}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821b0a038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554641544, events = 8, fd = 554640960, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 565223480, user_data = 0x1}, {pos = 565170184, events = 8, fd = 313, user_data = 0x8210f2870}, {pos = 923805167, events = 13576, fd = 2700919, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565223480, user_data = 0x1}, {pos = 565199880, events = 8, fd = 850337792, user_data = 0x1}, {pos = 850338196, events = 8, fd = 0, user_data = 0x8210f2840}, {pos = 701105516, events = 8, fd = 1, user_data = 0x832af2000}, {pos = 554641520, events = 8, fd = 701101826, user_data = 0x82a15c170 }, {pos = 12298976, events = 0, fd = 706068848, user_data = 0x821b04408}, {pos = 554641744, events = 8, fd = 923804638, user_data = 0x832b10800}, {pos = 1, events = 0, fd = 923804254, user_data = 0x821afd008}, {pos = 554641528, events = 8, fd = 554641744, user_data = 0x1c20}, {pos = 850411200, events = 8, fd = 923883920, user_data = 0x0}, {pos = 554632063, events = 8, fd = 8104791, user_data = 0x8210f2900}, {pos = 701064208, events = 8, fd = 706732080, user_data = 0x82a200310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8210f2930}, {pos = 701107101, events = 8, fd = 850337792, user_data = 0x1ae4}, {pos = 554641808, events = 8, fd = 701073658, user_data = 0x0}, {pos = 0, events = 0, fd = -870005231, user_data = 0x0}} [21:47:59.076] last_touch_time = 1726868599 [21:47:59.076] last_lockfile_recheck_time = 1726868599 [21:47:59.076] nevents = 1 [21:47:59.076] #22 0x000000000088ca15 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8210f2f78) at ../src/backend/postmaster/postmaster.c:1346 [21:47:59.076] userDoption = [21:47:59.076] listen_addr_saved = [21:47:59.076] output_config_variable = [21:47:59.076] opt = [21:47:59.076] status = [21:47:59.076] #23 0x00000000007c783c in main (argc=4, argv=0x8210f2f78) at ../src/backend/main/main.c:197 [21:47:59.076] do_check_root = [21:47:59.090] [21:47:59.090] [21:47:59.090] [21:47:59.162] dumping /tmp/cores/postgres.15256.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:47:59.297] [New LWP 100126] [21:47:59.377] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [21:47:59.377] Program terminated with signal SIGABRT, Aborted. [21:47:59.377] Sent by thr_kill() from pid 15256 and user 1003. [21:47:59.377] #0 0x000000082a38741a in thr_kill () from /lib/libc.so.7 [21:48:00.074] [21:48:00.074] Thread 1 (LWP 100126): [21:48:00.074] #0 0x000000082a38741a in thr_kill () from /lib/libc.so.7 [21:48:00.074] No symbol table info available. [21:48:00.074] #1 0x000000082a300e64 in raise () from /lib/libc.so.7 [21:48:00.074] No symbol table info available. [21:48:00.074] #2 0x000000082a3b16f9 in abort () from /lib/libc.so.7 [21:48:00.074] No symbol table info available. [21:48:00.074] #3 0x0000000000a8f9b5 in ExceptionalCondition (conditionName=0x2d1a1d "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:48:00.074] No locals. [21:48:00.074] #4 0x000000000077254f in ExecFetchSlotHeapTuple (slot=0x821b033e0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [21:48:00.074] No locals. [21:48:00.074] #5 0x0000000000737017 in ExecIRDeleteTriggers (estate=estate@entry=0x833ded100, relinfo=relinfo@entry=0x833ded6b0, slot=slot@entry=0x821b033e0) at ../src/backend/commands/trigger.c:2842 [21:48:00.074] trigger = [21:48:00.074] oldtuple = [21:48:00.074] should_free = false [21:48:00.074] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83a794628, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:48:00.074] trigdesc = 0x833ded8c0 [21:48:00.074] newtuple = 0x0 [21:48:00.074] i = 0 [21:48:00.074] #6 0x0000000000797727 in ExecMergeMatched (context=0x821b03488, resultRelInfo=0x833ded6b0, tupleid=0x0, oldtuple=0x821b033e0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [21:48:00.074] result = TM_Ok [21:48:00.074] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:48:00.074] relaction = 0x8369b9ee0 [21:48:00.074] commandType = CMD_DELETE [21:48:00.074] l__state = {l = 0x836b28f78, i = 0} [21:48:00.074] mtstate = 0x833ded4a0 [21:48:00.074] newslot = 0x0 [21:48:00.074] rslot = 0x0 [21:48:00.074] estate = 0x833ded100 [21:48:00.074] mergeActions = [21:48:00.074] econtext = 0x836b28018 [21:48:00.074] epqstate = 0x833ded588 [21:48:00.074] actionStates = 0x836b28f78 [21:48:00.074] l = [21:48:00.074] isNull = [21:48:00.074] lmerge_matched = [21:48:00.074] __error = [21:48:00.074] l__state = [21:48:00.074] result = [21:48:00.074] updateCxt = [21:48:00.074] relaction = [21:48:00.074] commandType = [21:48:00.074] __error = [21:48:00.074] resultRelationDesc = [21:48:00.074] lockmode = [21:48:00.074] inputslot = [21:48:00.074] epqslot = [21:48:00.074] was_matched = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] #7 ExecMerge (context=0x821b03488, resultRelInfo=0x833ded6b0, tupleid=0x0, oldtuple=0x821b033e0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [21:48:00.074] matched = [21:48:00.074] rslot = 0x0 [21:48:00.074] #8 ExecModifyTable (pstate=0x833ded4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [21:48:00.074] context = {mtstate = 0x833ded4a0, epqstate = 0x833ded588, estate = 0x833ded100, planSlot = 0x836b26418, tmfd = {ctid = {ip_blkid = {bi_hi = 15758, bi_lo = 10808}, ip_posid = 8}, xmax = 159, cmax = 0, traversed = 244}, cpUpdateReturningSlot = 0xdab14541cc4a9878} [21:48:00.074] tuple_ctid = {ip_blkid = {bi_hi = 13488, bi_lo = 8624}, ip_posid = 8} [21:48:00.074] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x833e81118} [21:48:00.074] node = 0x833ded4a0 [21:48:00.074] estate = 0x833ded100 [21:48:00.074] operation = CMD_MERGE [21:48:00.074] resultRelInfo = 0x833ded6b0 [21:48:00.074] subplanstate = 0x833deedb0 [21:48:00.074] slot = [21:48:00.074] tupleid = 0x0 [21:48:00.074] oldtuple = 0x821b033e0 [21:48:00.074] oldSlot = [21:48:00.074] #9 0x000000000076471b in ExecProcNode (node=0x833ded4a0) at ../src/include/executor/executor.h:278 [21:48:00.074] No locals. [21:48:00.074] #10 ExecutePlan (estate=0x833ded100, planstate=0x833ded4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x833db3f10, execute_once=) at ../src/backend/executor/execMain.c:1653 [21:48:00.074] current_tuple_count = 0 [21:48:00.074] slot = [21:48:00.074] #11 standard_ExecutorRun (queryDesc=0x833e83448, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:364 [21:48:00.074] estate = 0x833ded100 [21:48:00.074] oldcontext = 0x833db3c00 [21:48:00.074] operation = CMD_MERGE [21:48:00.074] dest = 0x833db3f10 [21:48:00.074] sendTuples = true [21:48:00.074] #12 0x000000083776b961 in pgss_ExecutorRun (queryDesc=0x833e83448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1024 [21:48:00.074] _local_sigjmp_buf = {{_sjb = {35290265905, 1, 34924934584, 34924934752, 12365208, 34924934592, 1, 35230594120, 34924921727, 7828241, 35229978624, 34359738368}}} [21:48:00.074] _save_exception_stack = 0x821b03770 [21:48:00.074] _save_context_stack = 0x0 [21:48:00.074] _do_rethrow = false [21:48:00.074] #13 0x000000000093a59f in ProcessQuery (plan=0x83a5c67c0, sourceText=, params=0x0, queryEnv=0x0, dest=0x833db3f10, qc=0x821b03738) at ../src/backend/tcop/pquery.c:160 [21:48:00.074] queryDesc = 0x833e83448 [21:48:00.074] #14 0x0000000000939b3d in PortalRunMulti (portal=portal@entry=0x833d55100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x833db3f10, altdest=0xb819f0 , qc=qc@entry=0x821b03738) at ../src/backend/tcop/pquery.c:1287 [21:48:00.074] pstmt = 0x83a5c67c0 [21:48:00.074] stmtlist_item__state = {l = 0x83a5cb078, i = 0} [21:48:00.074] active_snapshot_set = true [21:48:00.074] stmtlist_item = 0x83a5cb090 [21:48:00.074] #15 0x000000000093964c in FillPortalStore (portal=portal@entry=0x833d55100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:48:00.074] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:48:00.074] treceiver = 0x833db3f10 [21:48:00.074] #16 0x00000000009393bb in PortalRun (portal=portal@entry=0x833d55100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83a5cb0c8, altdest=altdest@entry=0x83a5cb0c8, qc=0x821b03870) at ../src/backend/tcop/pquery.c:763 [21:48:00.074] _local_sigjmp_buf = {{_sjb = {9671517, 35229356288, 34924935016, 34924935248, 34924935024, 35229450240, 12331880, 12365208, 35229336447, 35228676352, 4294967984, 0}}} [21:48:00.074] _save_exception_stack = 0x821b03940 [21:48:00.074] _save_context_stack = 0x0 [21:48:00.074] _do_rethrow = false [21:48:00.074] saveTopTransactionResourceOwner = 0x833da3598 [21:48:00.074] saveTopTransactionContext = 0x833d6c000 [21:48:00.074] saveActivePortal = 0x0 [21:48:00.074] saveResourceOwner = 0x833da3598 [21:48:00.074] savePortalContext = 0x0 [21:48:00.074] saveMemoryContext = 0x833d6c000 [21:48:00.074] result = [21:48:00.074] nprocessed = [21:48:00.074] #17 0x0000000000938282 in exec_simple_query (query_string=query_string@entry=0x833caf100 "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 [21:48:00.074] cmdtaglen = 5 [21:48:00.074] snapshot_set = [21:48:00.074] per_parsetree_context = 0x0 [21:48:00.074] plantree_list = [21:48:00.074] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:48:00.074] format = 0 [21:48:00.074] parsetree = 0x836a9b8e8 [21:48:00.074] commandTag = [21:48:00.074] cmdtagname = [21:48:00.074] querytree_list = [21:48:00.074] portal = 0x833d55100 [21:48:00.074] receiver = 0x83a5cb0c8 [21:48:00.074] parsetree_item__state = {l = 0x836a9d1b0, i = 0} [21:48:00.074] msec_str = "\000\000\000\000\b", '\000' , "\251\354\355f\000\000\000\000E\345\037M\005\231\207\267" [21:48:00.074] dest = DestRemote [21:48:00.074] was_logged = [21:48:00.074] oldcontext = 0x833d6c000 [21:48:00.074] parsetree_list = 0x836a9d1b0 [21:48:00.074] use_implicit_block = false [21:48:00.074] parsetree_item = 0x836a9d1c8 [21:48:00.074] save_log_statement_stats = [21:48:00.074] #18 0x0000000000935ef3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [21:48:00.074] query_string = 0x833caf100 "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"... [21:48:00.074] input_message = {data = 0x833caf100 "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} [21:48:00.074] firstchar = [21:48:00.074] local_sigjmp_buf = {{_sjb = {9655206, 34924935488, 34924935448, 34924936032, 12373944, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [21:48:00.074] send_ready_for_query = false [21:48:00.074] idle_in_transaction_timeout_enabled = false [21:48:00.074] idle_session_timeout_enabled = false [21:48:00.074] #19 0x00000000009306e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [21:48:00.074] bsdata = [21:48:00.074] #20 0x000000000088a837 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821b04684 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821b045c0) at ../src/backend/postmaster/launch_backend.c:274 [21:48:00.074] pid = [21:48:00.074] #21 0x000000000088ebf8 in BackendStartup (client_sock=0x821b045c0) at ../src/backend/postmaster/postmaster.c:3415 [21:48:00.074] startup_data = {canAcceptConnections = CAC_OK} [21:48:00.074] bn = 0x833cbb448 [21:48:00.074] pid = [21:48:00.074] __error = [21:48:00.074] save_errno = [21:48:00.074] __error = [21:48:00.074] __error = [21:48:00.074] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [21:48:00.074] 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 = " \374\3123\b", '\000' , " F\260!\b\000\000\000h\365\356(\b\000\000\000\v\000\000\000\000\000\000\000^\177\357(\b", '\000' , "`F\260!\b\000\000\000䥈\000\000\000\000\000pF\260!\b", '\000' }, salen = 16}} [21:48:00.074] i = 0 [21:48:00.074] now = [21:48:00.074] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 707968130, events = 8, fd = 0, user_data = 0x821b04570}, {pos = 869365208, events = 8, fd = 565199872, user_data = 0x0}, {pos = -785870070, events = 822, fd = 707135392, user_data = 0x82a271d78}, {pos = 565198968, events = 8, fd = 565199088, user_data = 0x821b04078}, {pos = -785870070, events = 822, fd = 707113864, user_data = 0x82a271d78}, {pos = 565199016, events = 8, fd = 565199136, user_data = 0x821b040a8}, {pos = 707174804, events = 8, fd = 574501896, user_data = 0x82a26a194}, {pos = 565199120, events = 8, fd = -785890246, user_data = 0x821b040b0}, {pos = 686740496, events = 8, fd = 708997168, user_data = 0x336d128930a}, {pos = 707082328, events = 8, fd = 707206520, user_data = 0x821b04118}, {pos = 565199248, events = 8, fd = 565199128, user_data = 0x82a268d0c}, {pos = 574501896, events = 8, fd = 707169548, user_data = 0x821b04180}, {pos = -785890246, events = 822, fd = 565199272, user_data = 0x821b04378}, {pos = 565199248, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8223e9038}, {pos = 1, events = 3669050689, fd = 574501896, user_data = 0x82a25b388}, {pos = 574523336, events = 8, fd = 0, user_data = 0x0}, {pos = 565199384, events = 8, fd = 565199848, user_data = 0x821b04200}, {pos = -785871710, events = 822, fd = 2700919, user_data = 0x6d68b}, {pos = 2090263927, events = 3669050689, fd = 574525496, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821b044e8}, {pos = 574501896, events = 3, fd = 565199920, user_data = 0x8223e8828}, {pos = 656, events = 0, fd = 565199848, user_data = 0x821b04218}, {pos = 565199488, events = 8, fd = -785872101, user_data = 0x821b043b0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 574525496, events = 8, fd = 1, user_data = 0x8223e3408}, {pos = 707082328, events = 8, fd = 565200104, user_data = 0x821b04430}, {pos = 565199504, events = 8, fd = 0, user_data = 0x8223dc008}, {pos = 33, events = 0, fd = 565199904, user_data = 0x336d1282ae7}, {pos = 574472200, events = 8, fd = 574473224, user_data = 0x8223dc808}, {pos = 574475272, events = 8, fd = 574488584, user_data = 0x8223e0408}, {pos = 574490632, events = 8, fd = 574491656, user_data = 0x8223e1008}, {pos = 574493704, events = 8, fd = 574494728, user_data = 0x8223e1c08}, {pos = 574496776, events = 8, fd = 574497800, user_data = 0x8223e2808}, {pos = 574499848, events = 8, fd = 574500872, user_data = 0x8223e3408}, {pos = 574502920, events = 8, fd = 574503944, user_data = 0x8223e4008}, {pos = 574505992, events = 8, fd = 574507016, user_data = 0x8223e4c08}, {pos = 574509064, events = 8, fd = 574510088, user_data = 0x8223e5808}, {pos = 574512136, events = 8, fd = 574517256, user_data = 0x8223e7408}, {pos = 574519304, events = 8, fd = 574520328, user_data = 0x8223ea408}, {pos = 910985000, events = 0, fd = 574472200, user_data = 0x293677}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8223e9038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 565200104, events = 8, fd = 565199504, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 574525496, user_data = 0x1}, {pos = 574472200, events = 8, fd = 313, user_data = 0x821b044d0}, {pos = -785898001, events = 822, fd = 2700919, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 574525496, user_data = 0x1}, {pos = 574501896, events = 8, fd = 868872192, user_data = 0x1}, {pos = 868872596, events = 8, fd = 0, user_data = 0x821b044a0}, {pos = 686781804, events = 8, fd = 1, user_data = 0x833c9f000}, {pos = 565200080, events = 8, fd = 686778114, user_data = 0x82a385170 }, {pos = 12298976, events = 0, fd = 708333936, user_data = 0x8223e3408}, {pos = 565200304, events = 8, fd = -785898530, user_data = 0x833cbd800}, {pos = 1, events = 0, fd = -785898914, user_data = 0x8223dc008}, {pos = 565200088, events = 8, fd = 565200304, user_data = 0x1c20}, {pos = 868940832, events = 8, fd = -785819248, user_data = 0x0}, {pos = 565183359, events = 8, fd = 8104791, user_data = 0x821b04560}, {pos = 686740496, events = 8, fd = 708997168, user_data = 0x82a429310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821b04590}, {pos = 686783389, events = 8, fd = 868872192, user_data = 0x33a8}, {pos = 565200368, events = 8, fd = 686749946, user_data = 0x0}, {pos = 0, events = 0, fd = -867526536, user_data = 0x0}} [21:48:00.074] last_touch_time = 1726868633 [21:48:00.074] last_lockfile_recheck_time = 1726868633 [21:48:00.074] nevents = 1 [21:48:00.074] #23 0x000000000088ca15 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821b04bd8) at ../src/backend/postmaster/postmaster.c:1346 [21:48:00.074] userDoption = [21:48:00.074] listen_addr_saved = [21:48:00.074] output_config_variable = [21:48:00.074] opt = [21:48:00.074] status = [21:48:00.074] #24 0x00000000007c783c in main (argc=4, argv=0x821b04bd8) at ../src/backend/main/main.c:197 [21:48:00.074] do_check_root =