[02:42:24.441] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [02:42:24.782] dumping /tmp/cores/postgres.7911.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:42:24.905] [New LWP 101719] [02:42:24.990] Core was generated by `postgres: postgres regression [local] MERGE'. [02:42:24.990] Program terminated with signal SIGABRT, Aborted. [02:42:24.990] Sent by thr_kill() from pid 7911 and user 1003. [02:42:24.990] #0 0x000000082a72741a in thr_kill () from /lib/libc.so.7 [02:42:25.626] [02:42:25.626] Thread 1 (LWP 101719): [02:42:25.626] #0 0x000000082a72741a in thr_kill () from /lib/libc.so.7 [02:42:25.626] No symbol table info available. [02:42:25.626] #1 0x000000082a6a0e64 in raise () from /lib/libc.so.7 [02:42:25.626] No symbol table info available. [02:42:25.626] #2 0x000000082a7516f9 in abort () from /lib/libc.so.7 [02:42:25.626] No symbol table info available. [02:42:25.626] #3 0x0000000000a8c125 in ExceptionalCondition (conditionName=0x2d18c9 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [02:42:25.626] No locals. [02:42:25.626] #4 0x000000000076f4ff in ExecFetchSlotHeapTuple (slot=0x820cfc1d0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [02:42:25.626] No locals. [02:42:25.626] #5 0x00000000007341b7 in ExecIRDeleteTriggers (estate=estate@entry=0x8331b0100, relinfo=relinfo@entry=0x8331b06b0, slot=slot@entry=0x820cfc1d0) at ../src/backend/commands/trigger.c:2841 [02:42:25.626] trigger = [02:42:25.626] oldtuple = [02:42:25.626] should_free = false [02:42:25.626] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8402c3f28, 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:42:25.626] trigdesc = 0x8331b08c0 [02:42:25.626] newtuple = 0x0 [02:42:25.626] i = 0 [02:42:25.626] #6 0x00000000007946d7 in ExecMergeMatched (context=0x820cfc278, resultRelInfo=0x8331b06b0, tupleid=0x0, oldtuple=0x820cfc1d0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [02:42:25.626] result = TM_Ok [02:42:25.626] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [02:42:25.626] relaction = 0x83f8866a0 [02:42:25.626] commandType = CMD_DELETE [02:42:25.626] l__state = {l = 0x83f94d0b8, i = 0} [02:42:25.626] mtstate = 0x8331b04a0 [02:42:25.626] newslot = 0x0 [02:42:25.626] rslot = 0x0 [02:42:25.626] estate = 0x8331b0100 [02:42:25.626] mergeActions = [02:42:25.626] econtext = 0x83f94c158 [02:42:25.626] epqstate = 0x8331b0588 [02:42:25.626] actionStates = 0x83f94d0b8 [02:42:25.626] l = [02:42:25.626] isNull = [02:42:25.626] lmerge_matched = [02:42:25.626] __error = [02:42:25.626] l__state = [02:42:25.626] result = [02:42:25.626] updateCxt = [02:42:25.626] relaction = [02:42:25.626] commandType = [02:42:25.626] __error = [02:42:25.626] resultRelationDesc = [02:42:25.626] lockmode = [02:42:25.626] inputslot = [02:42:25.626] epqslot = [02:42:25.626] was_matched = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] #7 ExecMerge (context=0x820cfc278, resultRelInfo=0x8331b06b0, tupleid=0x0, oldtuple=0x820cfc1d0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [02:42:25.626] matched = [02:42:25.626] rslot = 0x0 [02:42:25.626] #8 ExecModifyTable (pstate=0x8331b04a0) at ../src/backend/executor/nodeModifyTable.c:4133 [02:42:25.626] context = {mtstate = 0x8331b04a0, epqstate = 0x8331b0588, estate = 0x8331b0100, planSlot = 0x83f94a558, tmfd = {ctid = {ip_blkid = {bi_hi = 3824, bi_lo = 16399}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8331b06b0} [02:42:25.626] tuple_ctid = {ip_blkid = {bi_hi = 40528, bi_lo = 13081}, ip_posid = 8} [02:42:25.626] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83322e118} [02:42:25.626] node = 0x8331b04a0 [02:42:25.626] estate = 0x8331b0100 [02:42:25.626] operation = CMD_MERGE [02:42:25.626] resultRelInfo = 0x8331b06b0 [02:42:25.626] subplanstate = 0x8331b1db0 [02:42:25.626] slot = [02:42:25.626] tupleid = 0x0 [02:42:25.626] oldtuple = 0x820cfc1d0 [02:42:25.626] oldSlot = [02:42:25.626] #9 0x000000000076176b in ExecProcNode (node=0x8331b04a0) at ../src/include/executor/executor.h:278 [02:42:25.626] No locals. [02:42:25.626] #10 ExecutePlan (estate=0x8331b0100, planstate=0x8331b04a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x833064710, execute_once=) at ../src/backend/executor/execMain.c:1641 [02:42:25.626] current_tuple_count = 0 [02:42:25.626] slot = [02:42:25.626] #11 standard_ExecutorRun (queryDesc=0x833232448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [02:42:25.626] estate = 0x8331b0100 [02:42:25.626] oldcontext = 0x833064400 [02:42:25.626] operation = CMD_MERGE [02:42:25.626] dest = 0x833064710 [02:42:25.626] sendTuples = true [02:42:25.626] #12 0x00000000009370af in ProcessQuery (plan=0x8400f07d8, sourceText=, params=0x0, queryEnv=0x0, dest=0x833064710, qc=0x820cfc478) at ../src/backend/tcop/pquery.c:160 [02:42:25.626] queryDesc = 0x833232448 [02:42:25.626] #13 0x000000000093664d in PortalRunMulti (portal=portal@entry=0x83312b100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x833064710, altdest=0xb7dd30 , qc=qc@entry=0x820cfc478) at ../src/backend/tcop/pquery.c:1287 [02:42:25.626] pstmt = 0x8400f07d8 [02:42:25.626] stmtlist_item__state = {l = 0x8400f5090, i = 0} [02:42:25.626] active_snapshot_set = true [02:42:25.626] stmtlist_item = 0x8400f50a8 [02:42:25.626] #14 0x000000000093615c in FillPortalStore (portal=portal@entry=0x83312b100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [02:42:25.626] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:42:25.626] treceiver = 0x833064710 [02:42:25.626] #15 0x0000000000935ecb in PortalRun (portal=portal@entry=0x83312b100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8400f50e0, altdest=altdest@entry=0x8400f50e0, qc=0x820cfc5b0) at ../src/backend/tcop/pquery.c:763 [02:42:25.626] _local_sigjmp_buf = {{_sjb = {9657965, 35216601344, 34910225576, 34910225808, 34910225584, 35216621568, 12316296, 12349624, 35216556927, 35215728896, 4294967984, 0}}} [02:42:25.626] _save_exception_stack = 0x820cfc680 [02:42:25.626] _save_context_stack = 0x0 [02:42:25.626] _do_rethrow = false [02:42:25.626] saveTopTransactionResourceOwner = 0x83313d118 [02:42:25.626] saveTopTransactionContext = 0x833130000 [02:42:25.626] saveActivePortal = 0x0 [02:42:25.626] saveResourceOwner = 0x83313d118 [02:42:25.626] savePortalContext = 0x0 [02:42:25.626] saveMemoryContext = 0x833130000 [02:42:25.626] result = [02:42:25.626] nprocessed = [02:42:25.626] #16 0x0000000000934d92 in exec_simple_query (query_string=query_string@entry=0x833056100 "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:42:25.626] cmdtaglen = 5 [02:42:25.626] snapshot_set = [02:42:25.626] per_parsetree_context = 0x0 [02:42:25.626] plantree_list = [02:42:25.626] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:42:25.626] format = 0 [02:42:25.626] parsetree = 0x83f8c56e8 [02:42:25.626] commandTag = [02:42:25.626] cmdtagname = [02:42:25.626] querytree_list = [02:42:25.626] portal = 0x83312b100 [02:42:25.626] receiver = 0x8400f50e0 [02:42:25.626] parsetree_item__state = {l = 0x83f8c6fb0, i = 0} [02:42:25.626] msec_str = "\000\000\000\000\b", '\000' , "\236\353\350f\000\000\000\000N\016\312H\211VP\276" [02:42:25.626] dest = DestRemote [02:42:25.626] was_logged = [02:42:25.626] oldcontext = 0x833130000 [02:42:25.626] parsetree_list = 0x83f8c6fb0 [02:42:25.626] use_implicit_block = false [02:42:25.626] parsetree_item = 0x83f8c6fc8 [02:42:25.626] save_log_statement_stats = [02:42:25.626] #17 0x0000000000932b00 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [02:42:25.626] query_string = 0x833056100 "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:42:25.626] input_message = {data = 0x833056100 "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:42:25.626] firstchar = [02:42:25.626] local_sigjmp_buf = {{_sjb = {9641878, 34910226048, 34910226008, 34910226592, 12358360, 1, 8192, 8388608, 34910176127, 0, 0, 1}}} [02:42:25.626] send_ready_for_query = false [02:42:25.626] idle_in_transaction_timeout_enabled = false [02:42:25.626] idle_session_timeout_enabled = false [02:42:25.626] #18 0x000000000092d2d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:42:25.626] bsdata = [02:42:25.626] #19 0x0000000000887457 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820cfd3c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820cfd300) at ../src/backend/postmaster/launch_backend.c:274 [02:42:25.626] pid = [02:42:25.626] #20 0x000000000088b818 in BackendStartup (client_sock=0x820cfd300) at ../src/backend/postmaster/postmaster.c:3415 [02:42:25.626] startup_data = {canAcceptConnections = CAC_OK} [02:42:25.626] bn = 0x833062498 [02:42:25.626] pid = [02:42:25.626] __error = [02:42:25.626] save_errno = [02:42:25.626] __error = [02:42:25.626] __error = [02:42:25.626] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [02:42:25.626] 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\177\0053\b", '\000' , "`\323\317 \b\000\000\000h\005l)\b\000\000\000\v\000\000\000\000\000\000\000^\217l)\b", '\000' , "\240\323\317 \b\000\000\000\004r\210\000\000\000\000\000\260\323\317 \b", '\000' }, salen = 16}} [02:42:25.626] i = 0 [02:42:25.626] now = [02:42:25.626] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 855924736, events = 8, fd = 695015056, user_data = 0x14}, {pos = 550489504, events = 8, fd = 694979179, user_data = 0xad8ec0 }, {pos = 10, events = 524288, fd = 0, user_data = 0x800000000}, {pos = 550489536, events = 8, fd = 550490416, user_data = 0x20cfcdc8}, {pos = 6019, events = 0, fd = 11, user_data = 0x833057f00}, {pos = 0, events = 0, fd = 0, user_data = 0x820cfd360}, {pos = -1757, events = 32767, fd = 694978864, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 550490960, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 6019, user_data = 0x820cfd360}, {pos = 0, events = 0, fd = 582, user_data = 0xb}, {pos = 855998208, events = 8, fd = 0, user_data = 0x0}, {pos = 12, events = 1769491, fd = 712823280, user_data = 0x3b003b00000005}, {pos = 2, events = 0, fd = 712149242, user_data = 0x43}, {pos = 582, events = 0, fd = 550490952, user_data = 0x3b}, {pos = 800, events = 0, fd = 65538, user_data = 0x20001}, {pos = 895, events = 0, fd = 0, user_data = 0x0}, {pos = 8064, events = 196607, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x4a}, {pos = 862525222, events = 1901292572, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 831291680, user_data = 0x0}, {pos = 550490496, events = 8, fd = 320, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x14}, {pos = 1, events = 6019, fd = 1003, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0} , {pos = 0, events = 0, fd = 855924736, user_data = 0x1783}, {pos = 550490928, events = 8, fd = 694946042, user_data = 0x0}, {pos = 0, events = 0, fd = -1398454744, user_data = 0x0}} [02:42:25.626] last_touch_time = 1726540692 [02:42:25.626] last_lockfile_recheck_time = 1726540692 [02:42:25.626] nevents = 1 [02:42:25.626] #22 0x0000000000889635 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820cfd918) at ../src/backend/postmaster/postmaster.c:1346 [02:42:25.626] userDoption = [02:42:25.626] listen_addr_saved = [02:42:25.626] output_config_variable = [02:42:25.626] opt = [02:42:25.626] status = [02:42:25.626] #23 0x00000000007c47fc in main (argc=8, argv=0x820cfd918) at ../src/backend/main/main.c:197 [02:42:25.626] do_check_root = [02:42:25.638] [02:42:25.638] [02:42:25.638] [02:42:25.698] dumping /tmp/cores/postgres.8063.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:42:25.812] [New LWP 100609] [02:42:25.873] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [02:42:25.873] Program terminated with signal SIGABRT, Aborted. [02:42:25.873] Sent by thr_kill() from pid 8063 and user 1003. [02:42:25.873] #0 0x000000082b88f41a in thr_kill () from /lib/libc.so.7 [02:42:26.483] [02:42:26.483] Thread 1 (LWP 100609): [02:42:26.483] #0 0x000000082b88f41a in thr_kill () from /lib/libc.so.7 [02:42:26.483] No symbol table info available. [02:42:26.483] #1 0x000000082b808e64 in raise () from /lib/libc.so.7 [02:42:26.483] No symbol table info available. [02:42:26.483] #2 0x000000082b8b96f9 in abort () from /lib/libc.so.7 [02:42:26.483] No symbol table info available. [02:42:26.483] #3 0x0000000000a8c125 in ExceptionalCondition (conditionName=0x2d18c9 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [02:42:26.483] No locals. [02:42:26.483] #4 0x000000000076f4ff in ExecFetchSlotHeapTuple (slot=0x820ed11a0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [02:42:26.483] No locals. [02:42:26.483] #5 0x00000000007341b7 in ExecIRDeleteTriggers (estate=estate@entry=0x8345c5100, relinfo=relinfo@entry=0x8345c56b0, slot=slot@entry=0x820ed11a0) at ../src/backend/commands/trigger.c:2841 [02:42:26.483] trigger = [02:42:26.483] oldtuple = [02:42:26.483] should_free = false [02:42:26.483] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x841329130, 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:42:26.483] trigdesc = 0x8345c58c0 [02:42:26.483] newtuple = 0x0 [02:42:26.483] i = 0 [02:42:26.483] #6 0x00000000007946d7 in ExecMergeMatched (context=0x820ed1248, resultRelInfo=0x8345c56b0, tupleid=0x0, oldtuple=0x820ed11a0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [02:42:26.483] result = TM_Ok [02:42:26.483] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [02:42:26.483] relaction = 0x8413fba60 [02:42:26.483] commandType = CMD_DELETE [02:42:26.483] l__state = {l = 0x8414b8f78, i = 0} [02:42:26.483] mtstate = 0x8345c54a0 [02:42:26.483] newslot = 0x0 [02:42:26.483] rslot = 0x0 [02:42:26.483] estate = 0x8345c5100 [02:42:26.483] mergeActions = [02:42:26.483] econtext = 0x8414b8018 [02:42:26.483] epqstate = 0x8345c5588 [02:42:26.483] actionStates = 0x8414b8f78 [02:42:26.483] l = [02:42:26.483] isNull = [02:42:26.483] lmerge_matched = [02:42:26.483] __error = [02:42:26.483] l__state = [02:42:26.483] result = [02:42:26.483] updateCxt = [02:42:26.483] relaction = [02:42:26.483] commandType = [02:42:26.483] __error = [02:42:26.483] resultRelationDesc = [02:42:26.483] lockmode = [02:42:26.483] inputslot = [02:42:26.483] epqslot = [02:42:26.483] was_matched = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] #7 ExecMerge (context=0x820ed1248, resultRelInfo=0x8345c56b0, tupleid=0x0, oldtuple=0x820ed11a0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [02:42:26.483] matched = [02:42:26.483] rslot = 0x0 [02:42:26.483] #8 ExecModifyTable (pstate=0x8345c54a0) at ../src/backend/executor/nodeModifyTable.c:4133 [02:42:26.483] context = {mtstate = 0x8345c54a0, epqstate = 0x8345c5588, estate = 0x8345c5100, planSlot = 0x8414b6418, tmfd = {ctid = {ip_blkid = {bi_hi = 6640, bi_lo = 16723}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8345c56b0} [02:42:26.483] tuple_ctid = {ip_blkid = {bi_hi = 35392, bi_lo = 17597}, ip_posid = 8} [02:42:26.483] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8345aa118} [02:42:26.483] node = 0x8345c54a0 [02:42:26.483] estate = 0x8345c5100 [02:42:26.483] operation = CMD_MERGE [02:42:26.483] resultRelInfo = 0x8345c56b0 [02:42:26.483] subplanstate = 0x8345c6db0 [02:42:26.483] slot = [02:42:26.483] tupleid = 0x0 [02:42:26.483] oldtuple = 0x820ed11a0 [02:42:26.483] oldSlot = [02:42:26.483] #9 0x000000000076176b in ExecProcNode (node=0x8345c54a0) at ../src/include/executor/executor.h:278 [02:42:26.483] No locals. [02:42:26.483] #10 ExecutePlan (estate=0x8345c5100, planstate=0x8345c54a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x834461310, execute_once=) at ../src/backend/executor/execMain.c:1641 [02:42:26.483] current_tuple_count = 0 [02:42:26.483] slot = [02:42:26.483] #11 standard_ExecutorRun (queryDesc=0x834469c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [02:42:26.483] estate = 0x8345c5100 [02:42:26.483] oldcontext = 0x834461000 [02:42:26.483] operation = CMD_MERGE [02:42:26.483] dest = 0x834461310 [02:42:26.483] sendTuples = true [02:42:26.483] #12 0x00000000009370af in ProcessQuery (plan=0x8415312d8, sourceText=, params=0x0, queryEnv=0x0, dest=0x834461310, qc=0x820ed1448) at ../src/backend/tcop/pquery.c:160 [02:42:26.483] queryDesc = 0x834469c48 [02:42:26.483] #13 0x000000000093664d in PortalRunMulti (portal=portal@entry=0x8344b0100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x834461310, altdest=0xb7dd30 , qc=qc@entry=0x820ed1448) at ../src/backend/tcop/pquery.c:1287 [02:42:26.483] pstmt = 0x8415312d8 [02:42:26.483] stmtlist_item__state = {l = 0x841535b90, i = 0} [02:42:26.483] active_snapshot_set = true [02:42:26.483] stmtlist_item = 0x841535ba8 [02:42:26.483] #14 0x000000000093615c in FillPortalStore (portal=portal@entry=0x8344b0100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [02:42:26.483] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:42:26.483] treceiver = 0x834461310 [02:42:26.483] #15 0x0000000000935ecb in PortalRun (portal=portal@entry=0x8344b0100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x841535be0, altdest=altdest@entry=0x841535be0, qc=0x820ed1580) at ../src/backend/tcop/pquery.c:763 [02:42:26.483] _local_sigjmp_buf = {{_sjb = {9657965, 35237069056, 34912146552, 34912146784, 34912146560, 35237085184, 12316296, 12349624, 35237069695, 35236397312, 4294967984, 0}}} [02:42:26.483] _save_exception_stack = 0x820ed1650 [02:42:26.483] _save_context_stack = 0x0 [02:42:26.483] _do_rethrow = false [02:42:26.483] saveTopTransactionResourceOwner = 0x8344f7918 [02:42:26.483] saveTopTransactionContext = 0x8344b4000 [02:42:26.483] saveActivePortal = 0x0 [02:42:26.483] saveResourceOwner = 0x8344f7918 [02:42:26.483] savePortalContext = 0x0 [02:42:26.483] saveMemoryContext = 0x8344b4000 [02:42:26.483] result = [02:42:26.483] nprocessed = [02:42:26.483] #16 0x0000000000934d92 in exec_simple_query (query_string=query_string@entry=0x83440c100 "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:42:26.483] cmdtaglen = 5 [02:42:26.483] snapshot_set = [02:42:26.483] per_parsetree_context = 0x0 [02:42:26.483] plantree_list = [02:42:26.483] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:42:26.483] format = 0 [02:42:26.483] parsetree = 0x841430ca8 [02:42:26.483] commandTag = [02:42:26.483] cmdtagname = [02:42:26.483] querytree_list = [02:42:26.483] portal = 0x8344b0100 [02:42:26.483] receiver = 0x841535be0 [02:42:26.483] parsetree_item__state = {l = 0x841432570, i = 0} [02:42:26.483] msec_str = "\000\000\000\000\b", '\000' , "\240\353\350f\000\000\000\000\216\037\211\030\t\235_\022" [02:42:26.483] dest = DestRemote [02:42:26.483] was_logged = [02:42:26.483] oldcontext = 0x8344b4000 [02:42:26.483] parsetree_list = 0x841432570 [02:42:26.483] use_implicit_block = false [02:42:26.483] parsetree_item = 0x841432588 [02:42:26.483] save_log_statement_stats = [02:42:26.483] #17 0x0000000000932b00 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [02:42:26.483] query_string = 0x83440c100 "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:42:26.483] input_message = {data = 0x83440c100 "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:42:26.483] firstchar = [02:42:26.483] local_sigjmp_buf = {{_sjb = {9641878, 34912147024, 34912146984, 34912147568, 12358360, 1, 8192, 8388608, 34912142207, 0, 0, 1}}} [02:42:26.483] send_ready_for_query = false [02:42:26.483] idle_in_transaction_timeout_enabled = false [02:42:26.483] idle_session_timeout_enabled = false [02:42:26.483] #18 0x000000000092d2d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:42:26.483] bsdata = [02:42:26.483] #19 0x0000000000887457 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820ed2394 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820ed22d0) at ../src/backend/postmaster/launch_backend.c:274 [02:42:26.483] pid = [02:42:26.483] #20 0x000000000088b818 in BackendStartup (client_sock=0x820ed22d0) at ../src/backend/postmaster/postmaster.c:3415 [02:42:26.483] startup_data = {canAcceptConnections = CAC_OK} [02:42:26.483] bn = 0x834418588 [02:42:26.483] pid = [02:42:26.483] __error = [02:42:26.483] save_errno = [02:42:26.483] __error = [02:42:26.483] __error = [02:42:26.483] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [02:42:26.483] 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\336@4\b", '\000' , "0#\355 \b\000\000\000h\265\272)\b\000\000\000\v\000\000\000\000\000\000\000^?\273)\b", '\000' , "p#\355 \b\000\000\000\004r\210\000\000\000\000\000\200#\355 \b", '\000' }, salen = 16}} [02:42:26.483] i = 0 [02:42:26.483] now = [02:42:26.483] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 730020994, events = 8, fd = 0, user_data = 0x820ed2280}, {pos = 877086168, events = 8, fd = 552411408, user_data = 0x0}, {pos = 0, events = 0, fd = 966661375, user_data = 0xd3d38e7330a}, {pos = 729188256, events = 8, fd = 729259384, user_data = 0x820ed1d98}, {pos = 552410640, events = 8, fd = 552410520, user_data = 0xd3d38e7330a}, {pos = 729166728, events = 8, fd = 729259384, user_data = 0x820ed1dc8}, {pos = 552410688, events = 8, fd = 552410568, user_data = 0x82b772194}, {pos = 565429256, events = 8, fd = 729227668, user_data = 0x820ed1e30}, {pos = 954655802, events = 3389, fd = 731050032, user_data = 0x1}, {pos = 552410720, events = 8, fd = 954675978, user_data = 0x82b75b858}, {pos = 729259384, events = 8, fd = 552410680, user_data = 0x820ed1eb0}, {pos = 552410680, events = 8, fd = 729222412, user_data = 0x821b3c408}, {pos = 729222412, events = 8, fd = 552410784, user_data = 0xd3d38e6e43a}, {pos = 552410824, events = 8, fd = 552411272, user_data = 0x820ed1eb0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3792285860, fd = 565452856, user_data = 0x800000001}, {pos = 565429256, events = 8, fd = 729166728, user_data = 0x821b41288}, {pos = 729135192, events = 8, fd = 565429256, user_data = 0x820ed1f38}, {pos = 552411384, events = 8, fd = 552410912, user_data = 0xd3d38e72ca2}, {pos = 2700562, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 565452856, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 552411640, user_data = 0x21b3c408}, {pos = 552411456, events = 8, fd = 552411056, user_data = 0x1}, {pos = 552411384, events = 8, fd = 32, user_data = 0x820ed1fa0}, {pos = 954673779, events = 3389, fd = 552411328, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821b42038}, {pos = 1, events = 8, fd = 565429256, user_data = 0x82b75b858}, {pos = 552411640, events = 8, fd = 552411456, user_data = 0x820ed1fb0}, {pos = 0, events = 0, fd = 565399560, user_data = 0x20}, {pos = 552411440, events = 8, fd = 954649319, user_data = 0x821b35008}, {pos = 565400584, events = 8, fd = 565401608, user_data = 0x821b35c08}, {pos = 565415944, events = 8, fd = 565416968, user_data = 0x821b39808}, {pos = 565419016, events = 8, fd = 565420040, user_data = 0x821b3a408}, {pos = 565422088, events = 8, fd = 565423112, user_data = 0x821b3b008}, {pos = 565425160, events = 8, fd = 565426184, user_data = 0x821b3bc08}, {pos = 565428232, events = 8, fd = 565429256, user_data = 0x821b3c808}, {pos = 565431304, events = 8, fd = 565432328, user_data = 0x821b3d408}, {pos = 565434376, events = 8, fd = 565435400, user_data = 0x821b3e008}, {pos = 565437448, events = 8, fd = 565438472, user_data = 0x821b3ec08}, {pos = 565444616, events = 8, fd = 565445640, user_data = 0x821b40808}, {pos = 565447688, events = 8, fd = 565399560, user_data = 0x293512}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821b42038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552411640, events = 8, fd = 552411056, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 565452856, user_data = 0x1}, {pos = 565399560, events = 8, fd = 313, user_data = 0x820ed21e0}, {pos = 954648047, events = 3389, fd = 2700562, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565452856, user_data = 0x1}, {pos = 565429256, events = 8, fd = 876593152, user_data = 0x1}, {pos = 876593556, events = 8, fd = 0, user_data = 0x820ed21b0}, {pos = 700134764, events = 8, fd = 1, user_data = 0x8343fc000}, {pos = 552411616, events = 8, fd = 700131074, user_data = 0x82b88d170 }, {pos = 12283392, events = 0, fd = 730386800, user_data = 0x821b3c408}, {pos = 552411840, events = 8, fd = 954647518, user_data = 0x83441a800}, {pos = 1, events = 0, fd = 954647134, user_data = 0x821b35008}, {pos = 552411624, events = 8, fd = 552411840, user_data = 0x1c20}, {pos = 876666560, events = 8, fd = 954726800, user_data = 0x0}, {pos = 552403839, events = 8, fd = 8092439, user_data = 0x820ed2270}, {pos = 700093456, events = 8, fd = 731050032, user_data = 0x82b931310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820ed22a0}, {pos = 700136349, events = 8, fd = 876593152, user_data = 0x178c}, {pos = 552411904, events = 8, fd = 700102906, user_data = 0x0}, {pos = 0, events = 0, fd = 966661375, user_data = 0x0}} [02:42:26.483] last_touch_time = 1726540692 [02:42:26.483] last_lockfile_recheck_time = 1726540692 [02:42:26.483] nevents = 1 [02:42:26.483] #22 0x0000000000889635 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820ed28e8) at ../src/backend/postmaster/postmaster.c:1346 [02:42:26.483] userDoption = [02:42:26.483] listen_addr_saved = [02:42:26.483] output_config_variable = [02:42:26.483] opt = [02:42:26.483] status = [02:42:26.483] #23 0x00000000007c47fc in main (argc=4, argv=0x820ed28e8) at ../src/backend/main/main.c:197 [02:42:26.483] do_check_root = [02:42:26.495] [02:42:26.495] [02:42:26.495] [02:42:26.553] dumping /tmp/cores/postgres.14185.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:42:26.670] [New LWP 100607] [02:42:26.732] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [02:42:26.732] Program terminated with signal SIGABRT, Aborted. [02:42:26.732] Sent by thr_kill() from pid 14185 and user 1003. [02:42:26.732] #0 0x000000082cc2c41a in thr_kill () from /lib/libc.so.7 [02:42:27.400] [02:42:27.400] Thread 1 (LWP 100607): [02:42:27.400] #0 0x000000082cc2c41a in thr_kill () from /lib/libc.so.7 [02:42:27.400] No symbol table info available. [02:42:27.400] #1 0x000000082cba5e64 in raise () from /lib/libc.so.7 [02:42:27.400] No symbol table info available. [02:42:27.400] #2 0x000000082cc566f9 in abort () from /lib/libc.so.7 [02:42:27.400] No symbol table info available. [02:42:27.400] #3 0x0000000000a8c125 in ExceptionalCondition (conditionName=0x2d18c9 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [02:42:27.400] No locals. [02:42:27.400] #4 0x000000000076f4ff in ExecFetchSlotHeapTuple (slot=0x820d12150, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [02:42:27.400] No locals. [02:42:27.400] #5 0x00000000007341b7 in ExecIRDeleteTriggers (estate=estate@entry=0x835faa100, relinfo=relinfo@entry=0x835faa6b0, slot=slot@entry=0x820d12150) at ../src/backend/commands/trigger.c:2841 [02:42:27.400] trigger = [02:42:27.400] oldtuple = [02:42:27.400] should_free = false [02:42:27.400] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83ea97be0, 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:42:27.400] trigdesc = 0x835faa8c0 [02:42:27.400] newtuple = 0x0 [02:42:27.400] i = 0 [02:42:27.400] #6 0x00000000007946d7 in ExecMergeMatched (context=0x820d121f8, resultRelInfo=0x835faa6b0, tupleid=0x0, oldtuple=0x820d12150, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [02:42:27.400] result = TM_Ok [02:42:27.400] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [02:42:27.400] relaction = 0x83b615d20 [02:42:27.400] commandType = CMD_DELETE [02:42:27.400] l__state = {l = 0x83b7c68f8, i = 0} [02:42:27.400] mtstate = 0x835faa4a0 [02:42:27.400] newslot = 0x0 [02:42:27.400] rslot = 0x0 [02:42:27.400] estate = 0x835faa100 [02:42:27.400] mergeActions = [02:42:27.400] econtext = 0x83b7c5998 [02:42:27.400] epqstate = 0x835faa588 [02:42:27.400] actionStates = 0x83b7c68f8 [02:42:27.400] l = [02:42:27.400] isNull = [02:42:27.400] lmerge_matched = [02:42:27.400] __error = [02:42:27.400] l__state = [02:42:27.400] result = [02:42:27.400] updateCxt = [02:42:27.400] relaction = [02:42:27.400] commandType = [02:42:27.400] __error = [02:42:27.400] resultRelationDesc = [02:42:27.400] lockmode = [02:42:27.400] inputslot = [02:42:27.400] epqslot = [02:42:27.400] was_matched = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] #7 ExecMerge (context=0x820d121f8, resultRelInfo=0x835faa6b0, tupleid=0x0, oldtuple=0x820d12150, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [02:42:27.400] matched = [02:42:27.400] rslot = 0x0 [02:42:27.400] #8 ExecModifyTable (pstate=0x835faa4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [02:42:27.400] context = {mtstate = 0x835faa4a0, epqstate = 0x835faa588, estate = 0x835faa100, planSlot = 0x83b7c3d98, tmfd = {ctid = {ip_blkid = {bi_hi = 36238, bi_lo = 11458}, ip_posid = 8}, xmax = 118, cmax = 0, traversed = false}, cpUpdateReturningSlot = 0x70df99baa0be6dc3} [02:42:27.400] tuple_ctid = {ip_blkid = {bi_hi = 8736, bi_lo = 8401}, ip_posid = 8} [02:42:27.400] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836040118} [02:42:27.400] node = 0x835faa4a0 [02:42:27.400] estate = 0x835faa100 [02:42:27.400] operation = CMD_MERGE [02:42:27.400] resultRelInfo = 0x835faa6b0 [02:42:27.400] subplanstate = 0x835fabdb0 [02:42:27.400] slot = [02:42:27.400] tupleid = 0x0 [02:42:27.400] oldtuple = 0x820d12150 [02:42:27.400] oldSlot = [02:42:27.400] #9 0x000000000076176b in ExecProcNode (node=0x835faa4a0) at ../src/include/executor/executor.h:278 [02:42:27.400] No locals. [02:42:27.400] #10 ExecutePlan (estate=0x835faa100, planstate=0x835faa4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x835fff710, execute_once=) at ../src/backend/executor/execMain.c:1641 [02:42:27.400] current_tuple_count = 0 [02:42:27.400] slot = [02:42:27.400] #11 standard_ExecutorRun (queryDesc=0x836042448, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [02:42:27.400] estate = 0x835faa100 [02:42:27.400] oldcontext = 0x835fff400 [02:42:27.400] operation = CMD_MERGE [02:42:27.400] dest = 0x835fff710 [02:42:27.400] sendTuples = true [02:42:27.400] #12 0x0000000837296961 in pgss_ExecutorRun (queryDesc=0x836042448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1024 [02:42:27.400] _local_sigjmp_buf = {{_sjb = {35285199153, 1, 34910315304, 34910315472, 12349624, 34910315312, 1, 35265979464, 34910307199, 7815873, 35265355776, 34359738368}}} [02:42:27.400] _save_exception_stack = 0x820d124e0 [02:42:27.400] _save_context_stack = 0x0 [02:42:27.400] _do_rethrow = false [02:42:27.400] #13 0x00000000009370af in ProcessQuery (plan=0x83b77ae80, sourceText=, params=0x0, queryEnv=0x0, dest=0x835fff710, qc=0x820d124a8) at ../src/backend/tcop/pquery.c:160 [02:42:27.400] queryDesc = 0x836042448 [02:42:27.400] #14 0x000000000093664d in PortalRunMulti (portal=portal@entry=0x835f17100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x835fff710, altdest=0xb7dd30 , qc=qc@entry=0x820d124a8) at ../src/backend/tcop/pquery.c:1287 [02:42:27.400] pstmt = 0x83b77ae80 [02:42:27.400] stmtlist_item__state = {l = 0x83b77f738, i = 0} [02:42:27.400] active_snapshot_set = true [02:42:27.400] stmtlist_item = 0x83b77f750 [02:42:27.400] #15 0x000000000093615c in FillPortalStore (portal=portal@entry=0x835f17100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [02:42:27.400] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:42:27.400] treceiver = 0x835fff710 [02:42:27.400] #16 0x0000000000935ecb in PortalRun (portal=portal@entry=0x835f17100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83b77f788, altdest=altdest@entry=0x83b77f788, qc=0x820d125e0) at ../src/backend/tcop/pquery.c:763 [02:42:27.400] _local_sigjmp_buf = {{_sjb = {9657965, 35264753920, 34910315736, 34910315968, 34910315744, 35264847872, 12316296, 12349624, 35264725887, 35264073984, 4294967984, 0}}} [02:42:27.400] _save_exception_stack = 0x820d126b0 [02:42:27.400] _save_context_stack = 0x0 [02:42:27.400] _do_rethrow = false [02:42:27.400] saveTopTransactionResourceOwner = 0x835f5d258 [02:42:27.400] saveTopTransactionContext = 0x835f2e000 [02:42:27.400] saveActivePortal = 0x0 [02:42:27.400] saveResourceOwner = 0x835f5d258 [02:42:27.400] savePortalContext = 0x0 [02:42:27.400] saveMemoryContext = 0x835f2e000 [02:42:27.400] result = [02:42:27.400] nprocessed = [02:42:27.400] #17 0x0000000000934d92 in exec_simple_query (query_string=query_string@entry=0x835e71100 "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:42:27.400] cmdtaglen = 5 [02:42:27.400] snapshot_set = [02:42:27.400] per_parsetree_context = 0x0 [02:42:27.400] plantree_list = [02:42:27.400] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:42:27.400] format = 0 [02:42:27.400] parsetree = 0x83b739428 [02:42:27.400] commandTag = [02:42:27.400] cmdtagname = [02:42:27.400] querytree_list = [02:42:27.400] portal = 0x835f17100 [02:42:27.400] receiver = 0x83b77f788 [02:42:27.400] parsetree_item__state = {l = 0x83b73acf0, i = 0} [02:42:27.400] msec_str = "\000\000\000\000\b", '\000' , "\301\353\350f\000\000\000\000\000\270\217ُ=D\"" [02:42:27.400] dest = DestRemote [02:42:27.400] was_logged = [02:42:27.400] oldcontext = 0x835f2e000 [02:42:27.400] parsetree_list = 0x83b73acf0 [02:42:27.400] use_implicit_block = false [02:42:27.400] parsetree_item = 0x83b73ad08 [02:42:27.400] save_log_statement_stats = [02:42:27.400] #18 0x0000000000932b00 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [02:42:27.400] query_string = 0x835e71100 "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:42:27.400] input_message = {data = 0x835e71100 "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:42:27.400] firstchar = [02:42:27.400] local_sigjmp_buf = {{_sjb = {9641878, 34910316208, 34910316168, 34910316752, 12358360, 1, 8192, 8388608, 895, 0, 0, 1}}} [02:42:27.400] send_ready_for_query = false [02:42:27.400] idle_in_transaction_timeout_enabled = false [02:42:27.400] idle_session_timeout_enabled = false [02:42:27.400] #19 0x000000000092d2d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:42:27.400] bsdata = [02:42:27.400] #20 0x0000000000887457 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d133f4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d13330) at ../src/backend/postmaster/launch_backend.c:274 [02:42:27.400] pid = [02:42:27.400] #21 0x000000000088b818 in BackendStartup (client_sock=0x820d13330) at ../src/backend/postmaster/postmaster.c:3415 [02:42:27.400] startup_data = {canAcceptConnections = CAC_OK} [02:42:27.400] bn = 0x835e7d4e8 [02:42:27.400] pid = [02:42:27.400] __error = [02:42:27.400] save_errno = [02:42:27.400] __error = [02:42:27.400] __error = [02:42:27.400] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [02:42:27.400] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = " \034\3475\b", '\000' , "\2203\321 \b\000\000\000h\005w*\b\000\000\000\v\000\000\000\000\000\000\000^\217w*\b", '\000' , "\3203\321 \b\000\000\000\004r\210\000\000\000\000\000\3403\321 \b", '\000' }, salen = 16}} [02:42:27.400] i = 0 [02:42:27.400] now = [02:42:27.400] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 750587010, events = 8, fd = 0, user_data = 0x820d132e0}, {pos = 904762840, events = 8, fd = 550580592, user_data = 0x0}, {pos = 624169738, events = 15907, fd = 749754272, user_data = 0x82cb16d78}, {pos = 550579688, events = 8, fd = 550579808, user_data = 0x820d12de8}, {pos = 624169738, events = 15907, fd = 749732744, user_data = 0x82cb16d78}, {pos = 550579736, events = 8, fd = 550579856, user_data = 0x820d12e18}, {pos = 749793684, events = 8, fd = 559232008, user_data = 0x82cb0f194}, {pos = 550579840, events = 8, fd = 624149562, user_data = 0x820d12e20}, {pos = 712434704, events = 8, fd = 751616048, user_data = 0x3e232534130a}, {pos = 749701208, events = 8, fd = 749825400, user_data = 0x820d12e88}, {pos = 550579968, events = 8, fd = 550579848, user_data = 0x82cb0dd0c}, {pos = 559232008, events = 8, fd = 749788428, user_data = 0x820d12ef0}, {pos = 624149562, events = 15907, fd = 550579992, user_data = 0x820d130e8}, {pos = 550579968, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821559038}, {pos = 1, events = 1893702074, fd = 559232008, user_data = 0x82cb00388}, {pos = 559253448, events = 8, fd = 0, user_data = 0x0}, {pos = 550580104, events = 8, fd = 550580568, user_data = 0x820d12f70}, {pos = 624168098, events = 15907, fd = 2700562, user_data = 0x6d68b}, {pos = 2090263927, events = 1893702074, fd = 559255608, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820d13258}, {pos = 559232008, events = 3, fd = 550580640, user_data = 0x821558828}, {pos = 656, events = 0, fd = 550580568, user_data = 0x820d12f88}, {pos = 550580208, events = 8, fd = 624167707, user_data = 0x820d13120}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 559255608, events = 8, fd = 1, user_data = 0x821553408}, {pos = 749701208, events = 8, fd = 550580824, user_data = 0x820d131a0}, {pos = 550580224, events = 8, fd = 0, user_data = 0x82154c008}, {pos = 33, events = 0, fd = 550580624, user_data = 0x3e232533aae7}, {pos = 559202312, events = 8, fd = 559203336, user_data = 0x82154c808}, {pos = 559205384, events = 8, fd = 559218696, user_data = 0x821550408}, {pos = 559220744, events = 8, fd = 559221768, user_data = 0x821551008}, {pos = 559223816, events = 8, fd = 559224840, user_data = 0x821551c08}, {pos = 559226888, events = 8, fd = 559227912, user_data = 0x821552808}, {pos = 559229960, events = 8, fd = 559230984, user_data = 0x821553408}, {pos = 559233032, events = 8, fd = 559234056, user_data = 0x821554008}, {pos = 559236104, events = 8, fd = 559237128, user_data = 0x821554c08}, {pos = 559239176, events = 8, fd = 559240200, user_data = 0x821555808}, {pos = 559242248, events = 8, fd = 559247368, user_data = 0x821557408}, {pos = 559249416, events = 8, fd = 559250440, user_data = 0x82155a408}, {pos = 211315000, events = 0, fd = 559202312, user_data = 0x293512}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821559038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550580824, events = 8, fd = 550580224, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 559255608, user_data = 0x1}, {pos = 559202312, events = 8, fd = 313, user_data = 0x820d13240}, {pos = 624141807, events = 15907, fd = 2700562, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 559255608, user_data = 0x1}, {pos = 559232008, events = 8, fd = 904269824, user_data = 0x1}, {pos = 904270228, events = 8, fd = 0, user_data = 0x820d13210}, {pos = 712476012, events = 8, fd = 1, user_data = 0x835e61000}, {pos = 550580800, events = 8, fd = 712472322, user_data = 0x82cc2a170 }, {pos = 12283392, events = 0, fd = 750952816, user_data = 0x821553408}, {pos = 550581024, events = 8, fd = 624141278, user_data = 0x835e7f800}, {pos = 1, events = 0, fd = 624140894, user_data = 0x82154c008}, {pos = 550580808, events = 8, fd = 550581024, user_data = 0x1c20}, {pos = 904338464, events = 8, fd = 624220560, user_data = 0x0}, {pos = 550568831, events = 8, fd = 8092439, user_data = 0x820d132d0}, {pos = 712434704, events = 8, fd = 751616048, user_data = 0x82ccce310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d13300}, {pos = 712477597, events = 8, fd = 904269824, user_data = 0x2fc6}, {pos = 550581088, events = 8, fd = 712444154, user_data = 0x0}, {pos = 0, events = 0, fd = -1598132797, user_data = 0x0}} [02:42:27.400] last_touch_time = 1726540725 [02:42:27.400] last_lockfile_recheck_time = 1726540725 [02:42:27.400] nevents = 1 [02:42:27.400] #23 0x0000000000889635 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820d13940) at ../src/backend/postmaster/postmaster.c:1346 [02:42:27.400] userDoption = [02:42:27.400] listen_addr_saved = [02:42:27.400] output_config_variable = [02:42:27.400] opt = [02:42:27.400] status = [02:42:27.400] #24 0x00000000007c47fc in main (argc=4, argv=0x820d13940) at ../src/backend/main/main.c:197 [02:42:27.400] do_check_root =