[07:45:11.056] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [07:45:11.420] dumping /tmp/cores/postgres.6598.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:45:11.551] [New LWP 100160] [07:45:11.636] Core was generated by `postgres: postgres regression [local] MERGE'. [07:45:11.636] Program terminated with signal SIGABRT, Aborted. [07:45:11.636] Sent by thr_kill() from pid 6598 and user 1003. [07:45:11.636] #0 0x000000082c4b9dca in thr_kill () from /lib/libc.so.7 [07:45:12.173] [07:45:12.173] Thread 1 (LWP 100160): [07:45:12.173] #0 0x000000082c4b9dca in thr_kill () from /lib/libc.so.7 [07:45:12.173] No symbol table info available. [07:45:12.173] #1 0x000000082c4326f4 in raise () from /lib/libc.so.7 [07:45:12.173] No symbol table info available. [07:45:12.173] #2 0x000000082c4e3bc9 in abort () from /lib/libc.so.7 [07:45:12.173] No symbol table info available. [07:45:12.173] #3 0x0000000000a1cfe7 in ExceptionalCondition (conditionName=, fileName=0x36c3bf "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [07:45:12.173] No locals. [07:45:12.173] #4 0x000000000070f010 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820e17288, materialize=, shouldFree=shouldFree@entry=0x820e17166) at ../src/backend/executor/execTuples.c:1649 [07:45:12.173] No locals. [07:45:12.173] #5 0x00000000006d6c98 in ExecIRDeleteTriggers (estate=estate@entry=0x842c3e100, relinfo=relinfo@entry=0x842c3e6b0, slot=slot@entry=0x820e17288) at ../src/backend/commands/trigger.c:2841 [07:45:12.173] trigger = [07:45:12.173] oldtuple = [07:45:12.173] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x842b60fc0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [07:45:12.173] trigdesc = 0x842c3e8c0 [07:45:12.173] newtuple = 0x0 [07:45:12.173] i = 0 [07:45:12.173] should_free = false [07:45:12.173] #6 0x0000000000734734 in ExecMergeMatched (context=0x820e172c0, resultRelInfo=0x842c3e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [07:45:12.173] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [07:45:12.173] commandType = CMD_DELETE [07:45:12.173] result = TM_Ok [07:45:12.173] relaction = [07:45:12.173] l__state = {l = 0x842c7b2a8, i = 0} [07:45:12.173] mtstate = 0x842c3e4a0 [07:45:12.173] estate = 0x18740 [07:45:12.173] econtext = 0x842c7aaa8 [07:45:12.173] epqstate = 0x842c3e588 [07:45:12.173] l = [07:45:12.173] newslot = [07:45:12.173] isNull = [07:45:12.173] __error = [07:45:12.173] l__state = [07:45:12.173] updateCxt = [07:45:12.173] commandType = [07:45:12.173] result = [07:45:12.173] relaction = [07:45:12.173] __error = [07:45:12.173] resultRelationDesc = [07:45:12.173] lockmode = [07:45:12.173] inputslot = [07:45:12.173] epqslot = [07:45:12.173] __error = [07:45:12.173] __error = [07:45:12.173] __error = [07:45:12.173] __error = [07:45:12.173] __error = [07:45:12.173] __error = [07:45:12.173] __error = [07:45:12.173] #7 ExecMerge (context=context@entry=0x820e172c0, resultRelInfo=resultRelInfo@entry=0x842c3e6b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820e17288, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [07:45:12.173] matched = [07:45:12.173] #8 0x0000000000733ae7 in ExecModifyTable (pstate=0x842c3e4a0) at ../src/backend/executor/nodeModifyTable.c:3920 [07:45:12.173] context = {mtstate = 0x842c3e4a0, epqstate = 0x842c3e588, estate = 0x842c3e100, planSlot = 0x842c799e8, relaction = 0x842c7ace8, tmfd = {ctid = {ip_blkid = {bi_hi = 57600, bi_lo = 17091}, ip_posid = 8}, xmax = 551645952, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [07:45:12.173] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [07:45:12.173] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8364db118} [07:45:12.173] node = 0x842c3e4a0 [07:45:12.173] estate = 0x842c3e100 [07:45:12.173] operation = CMD_MERGE [07:45:12.173] resultRelInfo = 0x6 [07:45:12.173] subplanstate = 0x842c3fdf0 [07:45:12.173] slot = 0x842c799e8 [07:45:12.173] tupleid = 0x0 [07:45:12.173] oldtuple = 0x820e17288 [07:45:12.173] oldSlot = [07:45:12.173] #9 0x000000000070928b in ExecProcNodeFirst (node=0x842c3e4a0) at ../src/backend/executor/execProcnode.c:464 [07:45:12.173] No locals. [07:45:12.173] #10 0x000000000070167a in ExecProcNode (node=0x842c3e4a0) at ../src/include/executor/executor.h:274 [07:45:12.173] No locals. [07:45:12.173] #11 ExecutePlan (estate=0x842c3e100, planstate=0x842c3e4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x842ca89a0, execute_once=) at ../src/backend/executor/execMain.c:1638 [07:45:12.173] current_tuple_count = [07:45:12.173] slot = [07:45:12.173] #12 standard_ExecutorRun (queryDesc=0x8363e0900, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:357 [07:45:12.173] estate = 0x842c3e100 [07:45:12.173] oldcontext = 0x8363e0800 [07:45:12.173] operation = CMD_MERGE [07:45:12.173] dest = 0x842ca89a0 [07:45:12.173] sendTuples = false [07:45:12.173] #13 0x000000000070153f in ExecutorRun (queryDesc=0x18740, queryDesc@entry=0x8363e0900, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:301 [07:45:12.173] No locals. [07:45:12.173] #14 0x00000000008cff2f in ProcessQuery (plan=0x842ca4b28, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820e175c0) at ../src/backend/tcop/pquery.c:160 [07:45:12.173] queryDesc = 0x8363e0900 [07:45:12.173] #15 0x00000000008cf4cd in PortalRunMulti (portal=portal@entry=0x8364a8100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x842ca89a0, altdest=altdest@entry=0x842ca89a0, qc=0x820e175c0) at ../src/backend/tcop/pquery.c:1286 [07:45:12.173] pstmt = 0x842ca4b28 [07:45:12.173] stmtlist_item__state = {l = 0x842ca8950, i = 0} [07:45:12.173] active_snapshot_set = true [07:45:12.173] stmtlist_item = 0x842ca8968 [07:45:12.173] #16 0x00000000008ced3b in PortalRun (portal=portal@entry=0x8364a8100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82c4b9daa , dest@entry=0x842ca89a0, altdest=0x0, altdest@entry=0x842ca89a0, qc=0x820e175c0) at ../src/backend/tcop/pquery.c:791 [07:45:12.173] _local_sigjmp_buf = {{_sjb = {9235631, 35270657840, 34911384760, 34911384992, 34911384768, 11863608, 11831392, 35270590720, -6347183290308295809, 35270598912, 3552315, 34359738368}}} [07:45:12.173] _save_exception_stack = 0x820e17690 [07:45:12.173] _save_context_stack = 0x0 [07:45:12.173] _do_rethrow = false [07:45:12.173] saveTopTransactionResourceOwner = 0x8364b8730 [07:45:12.173] saveTopTransactionContext = 0x8363de000 [07:45:12.173] saveActivePortal = 0x0 [07:45:12.173] saveResourceOwner = 0x8364b8730 [07:45:12.173] savePortalContext = 0x0 [07:45:12.173] saveMemoryContext = 0x8363de000 [07:45:12.173] result = [07:45:12.173] nprocessed = [07:45:12.173] #17 0x00000000008cdc1b in exec_simple_query (query_string=query_string@entry=0x8363d2100 "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:1273 [07:45:12.173] cmdtaglen = [07:45:12.173] snapshot_set = [07:45:12.173] per_parsetree_context = 0x0 [07:45:12.173] plantree_list = [07:45:12.173] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:45:12.173] parsetree = 0x842bf1fc8 [07:45:12.173] commandTag = CMDTAG_MERGE [07:45:12.173] cmdtagname = [07:45:12.173] querytree_list = [07:45:12.173] portal = 0x8364a8100 [07:45:12.173] format = 0 [07:45:12.173] receiver = 0x842ca89a0 [07:45:12.173] parsetree_item__state = {l = 0x842c4a938, i = 0} [07:45:12.173] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [07:45:12.173] dest = DestRemote [07:45:12.173] was_logged = [07:45:12.173] oldcontext = 0x8363de000 [07:45:12.173] parsetree_list = 0x842c4a938 [07:45:12.173] use_implicit_block = false [07:45:12.173] parsetree_item = 0x842c4a950 [07:45:12.173] save_log_statement_stats = [07:45:12.173] #18 0x00000000008cba04 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [07:45:12.173] query_string = 0x8363d2100 "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"... [07:45:12.173] input_message = {data = 0x8363d2100 "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 = 241, maxlen = 1024, cursor = 241} [07:45:12.173] firstchar = [07:45:12.173] local_sigjmp_buf = {{_sjb = {9219792, 34911385232, 34911385192, 34911385792, 11872344, 11818832, 8192, 8388608, 72057628949283711, 0, 0, 34359738369}}} [07:45:12.173] send_ready_for_query = false [07:45:12.173] idle_in_transaction_timeout_enabled = false [07:45:12.173] idle_session_timeout_enabled = false [07:45:12.173] #19 0x000000000082b205 in BackendRun (port=port@entry=0x8364a5000) at ../src/backend/postmaster/postmaster.c:4475 [07:45:12.173] No locals. [07:45:12.173] #20 0x000000000082953d in BackendStartup (port=0x8364a5000) at ../src/backend/postmaster/postmaster.c:4151 [07:45:12.173] bn = 0x8363de358 [07:45:12.173] pid = [07:45:12.173] __error = [07:45:12.173] __error = [07:45:12.173] __error = [07:45:12.173] save_errno = [07:45:12.173] __error = [07:45:12.173] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [07:45:12.173] port = 0x8364a5000 [07:45:12.173] i = 0 [07:45:12.173] now = [07:45:12.173] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 567645192, events = 8, fd = 567646216, user_data = 0x821d59c08}, {pos = 567648264, events = 8, fd = 567649288, user_data = 0x821d5a808}, {pos = 567651336, events = 8, fd = 567652360, user_data = 0x821d5b408}, {pos = -1, events = 0, fd = 743940832, user_data = 0x820e179b0}, {pos = 743600553, events = 8, fd = 0, user_data = 0x1000}, {pos = 753588836, events = 38083618, fd = 743942120, user_data = 0x835a09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x8346ab090}, {pos = 551647872, events = 8, fd = 743463212, user_data = 0x1000}, {pos = 742025572, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 567679544, events = 8, fd = 1, user_data = 0x821d5b408}, {pos = 741939416, events = 8, fd = 551648008, user_data = 0x820e178c0}, {pos = 32, events = 18, fd = 742009956, user_data = 0x821d5b408}, {pos = 567679544, events = 8, fd = 0, user_data = 0xa41}, {pos = 551647984, events = 8, fd = 213001797, user_data = 0x82c3a6964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821d61a38}, {pos = 1, events = 0, fd = 567653384, user_data = 0x8363c2000}, {pos = 1, events = 0, fd = 909910420, user_data = 0x0}, {pos = 551647936, events = 8, fd = 721071116, user_data = 0x1}, {pos = 909910016, events = 8, fd = 551647984, user_data = 0x82afa9eb4}, {pos = 743752032, events = 8, fd = 743752032, user_data = 0x82c3be0c0}, {pos = 567653384, events = 8, fd = 551648208, user_data = 0x1b280cb2242c}, {pos = 879407248, events = 8, fd = 1, user_data = 0x1b280cb222ae}, {pos = 12240, events = 0, fd = 551647992, user_data = 0x820e17bd0}, {pos = 910616552, events = 8, fd = 551649600, user_data = 0x1b280cb35e90}, {pos = 567653384, events = 8, fd = 551617407, user_data = 0x82c4f859c}, {pos = 567623688, events = 8, fd = 0, user_data = 0x821d5b408}, {pos = 12240, events = 0, fd = 741875712, user_data = 0x1df950}, {pos = 743752032, events = 8, fd = 742009956, user_data = 0x3d00}, {pos = 551649392, events = 8, fd = 551648320, user_data = 0x82c44718e }, {pos = 743790648, events = 8, fd = 551648260, user_data = 0x83642e5da}, {pos = 551649392, events = 8, fd = 551648320, user_data = 0x82c45d605}, {pos = 551648258, events = 8, fd = 551649392, user_data = 0x820e18070}, {pos = 0, events = 16777216, fd = 753588836, user_data = 0x820e18070}, {pos = 910353880, events = 8, fd = 551649600, user_data = 0x82c555838}, {pos = 0, events = 0, fd = 551649456, user_data = 0x82c45d70d}, {pos = 0, events = 0, fd = 0, user_data = 0x820e181e0}, {pos = 910353880, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1b280cb29409}, {pos = 551648664, events = 8, fd = 742009956, user_data = 0x9c7}, {pos = 213029897, events = 6952, fd = 551648696, user_data = 0x82c3a2c64}, {pos = 2758, events = 0, fd = 741982496, user_data = 0x820e17d38}, {pos = 567653384, events = 8, fd = 551648696, user_data = 0x82c39c120}, {pos = 551648672, events = 8, fd = 213009509, user_data = 0x0}, {pos = 0, events = 0, fd = 743891184, user_data = 0x82c392550}, {pos = 0, events = 0, fd = 0, user_data = 0x82c55c9b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x820e17e28}, {pos = 567672968, events = 8, fd = 213029897, user_data = 0x820e17e68}, {pos = 742009956, events = 8, fd = 2924, user_data = 0x82c39c3b8}, {pos = 551648744, events = 8, fd = 567653384, user_data = 0x820e17e68}, {pos = 741983160, events = 8, fd = 551648848, user_data = 0x1b280cb24465}, {pos = 567676984, events = 8, fd = 1, user_data = 0x821d5b408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 551649256, events = 0, fd = 2564492, user_data = 0x820e18050}, {pos = 551649360, events = 8, fd = 551649288, user_data = 0x1e}, {pos = 741946592, events = 8, fd = 551649016, user_data = 0x821d60248}, {pos = 551649464, events = 8, fd = 551648992, user_data = 0x1b280cb28da3}, {pos = 567676984, events = 8, fd = 2690432, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 567676984, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820e181b8}, {pos = 567653384, events = 8, fd = 551649344, user_data = 0x27218c}, {pos = 551649536, events = 8, fd = 551649536, user_data = 0x820e180b8}, {pos = 32, events = 0, fd = 551649120, user_data = 0x1b280cb28b83}} [07:45:12.173] last_touch_time = 1709710820 [07:45:12.173] last_lockfile_recheck_time = 1709710820 [07:45:12.173] nevents = 1 [07:45:12.173] #22 0x0000000000826843 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820e18870) at ../src/backend/postmaster/postmaster.c:1468 [07:45:12.173] userDoption = [07:45:12.173] listen_addr_saved = false [07:45:12.173] output_config_variable = [07:45:12.173] opt = [07:45:12.173] status = [07:45:12.173] #23 0x0000000000763d45 in main (argc=8, argv=0x820e18870) at ../src/backend/main/main.c:197 [07:45:12.173] do_check_root = [07:45:12.183] [07:45:12.183] [07:45:12.183] [07:45:12.242] dumping /tmp/cores/postgres.7005.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:45:12.361] [New LWP 100158] [07:45:12.426] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [07:45:12.426] Program terminated with signal SIGABRT, Aborted. [07:45:12.426] Sent by thr_kill() from pid 7005 and user 1003. [07:45:12.426] #0 0x000000082c526dca in thr_kill () from /lib/libc.so.7 [07:45:12.966] [07:45:12.966] Thread 1 (LWP 100158): [07:45:12.966] #0 0x000000082c526dca in thr_kill () from /lib/libc.so.7 [07:45:12.966] No symbol table info available. [07:45:12.966] #1 0x000000082c49f6f4 in raise () from /lib/libc.so.7 [07:45:12.966] No symbol table info available. [07:45:12.966] #2 0x000000082c550bc9 in abort () from /lib/libc.so.7 [07:45:12.966] No symbol table info available. [07:45:12.966] #3 0x0000000000a1cfe7 in ExceptionalCondition (conditionName=, fileName=0x36c3bf "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [07:45:12.966] No locals. [07:45:12.966] #4 0x000000000070f010 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8219a13a8, materialize=, shouldFree=shouldFree@entry=0x8219a1286) at ../src/backend/executor/execTuples.c:1649 [07:45:12.966] No locals. [07:45:12.966] #5 0x00000000006d6c98 in ExecIRDeleteTriggers (estate=estate@entry=0x839290100, relinfo=relinfo@entry=0x8392906b0, slot=slot@entry=0x8219a13a8) at ../src/backend/commands/trigger.c:2841 [07:45:12.966] trigger = [07:45:12.966] oldtuple = [07:45:12.966] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8391dfda0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [07:45:12.966] trigdesc = 0x8392908c0 [07:45:12.966] newtuple = 0x0 [07:45:12.966] i = 0 [07:45:12.966] should_free = false [07:45:12.966] #6 0x0000000000734734 in ExecMergeMatched (context=0x8219a13e0, resultRelInfo=0x8392906b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [07:45:12.966] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [07:45:12.966] commandType = CMD_DELETE [07:45:12.966] result = TM_Ok [07:45:12.966] relaction = [07:45:12.966] l__state = {l = 0x8392cd628, i = 0} [07:45:12.966] mtstate = 0x8392904a0 [07:45:12.966] estate = 0x1873e [07:45:12.966] econtext = 0x8392cce28 [07:45:12.966] epqstate = 0x839290588 [07:45:12.966] l = [07:45:12.966] newslot = [07:45:12.966] isNull = [07:45:12.966] __error = [07:45:12.966] l__state = [07:45:12.966] updateCxt = [07:45:12.966] commandType = [07:45:12.966] result = [07:45:12.966] relaction = [07:45:12.966] __error = [07:45:12.966] resultRelationDesc = [07:45:12.966] lockmode = [07:45:12.966] inputslot = [07:45:12.966] epqslot = [07:45:12.966] __error = [07:45:12.966] __error = [07:45:12.966] __error = [07:45:12.966] __error = [07:45:12.966] __error = [07:45:12.966] __error = [07:45:12.966] __error = [07:45:12.966] #7 ExecMerge (context=context@entry=0x8219a13e0, resultRelInfo=resultRelInfo@entry=0x8392906b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x8219a13a8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [07:45:12.966] matched = [07:45:12.966] #8 0x0000000000733ae7 in ExecModifyTable (pstate=0x8392904a0) at ../src/backend/executor/nodeModifyTable.c:3920 [07:45:12.966] context = {mtstate = 0x8392904a0, epqstate = 0x839290588, estate = 0x839290100, planSlot = 0x8392cbd68, relaction = 0x8392cd068, tmfd = {ctid = {ip_blkid = {bi_hi = 256, bi_lo = 14633}, ip_posid = 8}, xmax = 563745824, cmax = 1, traversed = false}, cpUpdateReturningSlot = 0x4} [07:45:12.966] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [07:45:12.966] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x839200118} [07:45:12.966] node = 0x8392904a0 [07:45:12.966] estate = 0x839290100 [07:45:12.966] operation = CMD_MERGE [07:45:12.966] resultRelInfo = 0x6 [07:45:12.966] subplanstate = 0x839291df0 [07:45:12.966] slot = 0x8392cbd68 [07:45:12.966] tupleid = 0x0 [07:45:12.966] oldtuple = 0x8219a13a8 [07:45:12.966] oldSlot = [07:45:12.966] #9 0x000000000070928b in ExecProcNodeFirst (node=0x8392904a0) at ../src/backend/executor/execProcnode.c:464 [07:45:12.966] No locals. [07:45:12.966] #10 0x000000000070167a in ExecProcNode (node=0x8392904a0) at ../src/include/executor/executor.h:274 [07:45:12.966] No locals. [07:45:12.966] #11 ExecutePlan (estate=0x839290100, planstate=0x8392904a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x8392f3520, execute_once=) at ../src/backend/executor/execMain.c:1638 [07:45:12.966] current_tuple_count = [07:45:12.966] slot = [07:45:12.966] #12 standard_ExecutorRun (queryDesc=0x8364c5500, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:357 [07:45:12.966] estate = 0x839290100 [07:45:12.966] oldcontext = 0x8364c5400 [07:45:12.966] operation = CMD_MERGE [07:45:12.966] dest = 0x8392f3520 [07:45:12.966] sendTuples = false [07:45:12.966] #13 0x000000000070153f in ExecutorRun (queryDesc=0x1873e, queryDesc@entry=0x8364c5500, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:301 [07:45:12.966] No locals. [07:45:12.966] #14 0x00000000008cff2f in ProcessQuery (plan=0x8392ef6a8, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8219a16e0) at ../src/backend/tcop/pquery.c:160 [07:45:12.966] queryDesc = 0x8364c5500 [07:45:12.966] #15 0x00000000008cf4cd in PortalRunMulti (portal=portal@entry=0x8363c8100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8392f3520, altdest=altdest@entry=0x8392f3520, qc=0x8219a16e0) at ../src/backend/tcop/pquery.c:1286 [07:45:12.966] pstmt = 0x8392ef6a8 [07:45:12.966] stmtlist_item__state = {l = 0x8392f34d0, i = 0} [07:45:12.966] active_snapshot_set = true [07:45:12.966] stmtlist_item = 0x8392f34e8 [07:45:12.966] #16 0x00000000008ced3b in PortalRun (portal=portal@entry=0x8363c8100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82c526daa , dest@entry=0x8392f3520, altdest=0x0, altdest@entry=0x8392f3520, qc=0x8219a16e0) at ../src/backend/tcop/pquery.c:791 [07:45:12.966] _local_sigjmp_buf = {{_sjb = {9235631, 35269968176, 34923484632, 34923484864, 34923484640, 11863608, 11831392, 35269673216, -6347183290296171649, 35269681408, 3552315, 34359738368}}} [07:45:12.966] _save_exception_stack = 0x8219a17b0 [07:45:12.966] _save_context_stack = 0x0 [07:45:12.966] _do_rethrow = false [07:45:12.966] saveTopTransactionResourceOwner = 0x836410130 [07:45:12.966] saveTopTransactionContext = 0x83633b000 [07:45:12.966] saveActivePortal = 0x0 [07:45:12.966] saveResourceOwner = 0x836410130 [07:45:12.966] savePortalContext = 0x0 [07:45:12.966] saveMemoryContext = 0x83633b000 [07:45:12.966] result = [07:45:12.966] nprocessed = [07:45:12.966] #17 0x00000000008cdc1b in exec_simple_query (query_string=query_string@entry=0x83632f100 "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:1273 [07:45:12.966] cmdtaglen = [07:45:12.966] snapshot_set = [07:45:12.966] per_parsetree_context = 0x0 [07:45:12.966] plantree_list = [07:45:12.966] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:45:12.966] parsetree = 0x8364f4fc8 [07:45:12.966] commandTag = CMDTAG_MERGE [07:45:12.966] cmdtagname = [07:45:12.966] querytree_list = [07:45:12.966] portal = 0x8363c8100 [07:45:12.966] format = 0 [07:45:12.966] receiver = 0x8392f3520 [07:45:12.966] parsetree_item__state = {l = 0x83929bfb8, i = 0} [07:45:12.966] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [07:45:12.966] dest = DestRemote [07:45:12.966] was_logged = [07:45:12.966] oldcontext = 0x83633b000 [07:45:12.966] parsetree_list = 0x83929bfb8 [07:45:12.966] use_implicit_block = false [07:45:12.966] parsetree_item = 0x83929bfd0 [07:45:12.966] save_log_statement_stats = [07:45:12.966] #18 0x00000000008cba04 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [07:45:12.966] query_string = 0x83632f100 "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"... [07:45:12.966] input_message = {data = 0x83632f100 "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 = 241, maxlen = 1024, cursor = 241} [07:45:12.966] firstchar = [07:45:12.966] local_sigjmp_buf = {{_sjb = {9219792, 34923485104, 34923485064, 34923485664, 11872344, 11818832, 8192, 8388608, 72057628961407871, 0, 0, 34359738369}}} [07:45:12.966] send_ready_for_query = false [07:45:12.966] idle_in_transaction_timeout_enabled = false [07:45:12.966] idle_session_timeout_enabled = false [07:45:12.966] #19 0x000000000082b205 in BackendRun (port=port@entry=0x8363e2000) at ../src/backend/postmaster/postmaster.c:4475 [07:45:12.966] No locals. [07:45:12.966] #20 0x000000000082953d in BackendStartup (port=0x8363e2000) at ../src/backend/postmaster/postmaster.c:4151 [07:45:12.966] bn = 0x83633b498 [07:45:12.966] pid = [07:45:12.966] __error = [07:45:12.966] __error = [07:45:12.966] __error = [07:45:12.966] save_errno = [07:45:12.966] __error = [07:45:12.966] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [07:45:12.966] port = 0x8363e2000 [07:45:12.966] i = 0 [07:45:12.966] now = [07:45:12.966] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 578081800, events = 8, fd = 578082824, user_data = 0x82274dc08}, {pos = 578084872, events = 8, fd = 578085896, user_data = 0x82274e808}, {pos = 578087944, events = 8, fd = 578088968, user_data = 0x82274f408}, {pos = 578109576, events = 8, fd = 563748072, user_data = 0x8219a1b10}, {pos = -1863594589, events = 4290, fd = 0, user_data = 0x272242}, {pos = 115249317, events = 0, fd = -25761258, user_data = 0x822755038}, {pos = 1, events = 0, fd = 578089992, user_data = 0x82c3f94a8}, {pos = 563748328, events = 8, fd = 578089992, user_data = 0x219a1b00}, {pos = 742472036, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 578116152, events = 8, fd = 1, user_data = 0x82274f408}, {pos = 742385880, events = 8, fd = 563747880, user_data = 0x8219a19e0}, {pos = 32, events = 18, fd = 742456420, user_data = 0x82274f408}, {pos = 578116152, events = 8, fd = 0, user_data = 0xa41}, {pos = 563747856, events = 8, fd = -1863621051, user_data = 0x82c413964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822755a38}, {pos = 1, events = 0, fd = 578089992, user_data = 0x83631f000}, {pos = 1, events = 0, fd = 909242772, user_data = 0x0}, {pos = 563747808, events = 8, fd = 726866956, user_data = 0x1}, {pos = 909242368, events = 8, fd = 563747856, user_data = 0x82b530eb4}, {pos = 744198496, events = 8, fd = 744198496, user_data = 0x82c42b0c0}, {pos = 578089992, events = 8, fd = 563748080, user_data = 0x10c290eb642c}, {pos = 578088968, events = 8, fd = 1, user_data = 0x10c290eb62ae}, {pos = 12240, events = 0, fd = 563747864, user_data = 0x8219a1cf0}, {pos = 910022632, events = 8, fd = 563749472, user_data = 0x10c290ec9e90}, {pos = 578089992, events = 8, fd = 563741567, user_data = 0x82c5654b2}, {pos = 578060296, events = 8, fd = 0, user_data = 0x82274f408}, {pos = 12240, events = 0, fd = 742322176, user_data = 0x1df950}, {pos = 744198496, events = 8, fd = 742456420, user_data = 0x3d00}, {pos = 563749264, events = 8, fd = 563748192, user_data = 0x82c4b418e }, {pos = 744237112, events = 8, fd = 563748132, user_data = 0x83638d5da}, {pos = 563749264, events = 8, fd = 563748192, user_data = 0x82c4ca605}, {pos = 563748130, events = 8, fd = 563749264, user_data = 0x8219a2190}, {pos = 0, events = 16777216, fd = 699638638, user_data = 0x8219a2190}, {pos = 909694424, events = 8, fd = 563749472, user_data = 0x82c5c2838}, {pos = 0, events = 0, fd = 563749328, user_data = 0x82c4ca70d}, {pos = 0, events = 0, fd = 0, user_data = 0x8219a2300}, {pos = 909694424, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x10c290ebd409}, {pos = 563748536, events = 8, fd = 742456420, user_data = 0x9c7}, {pos = -1863592951, events = 4290, fd = 563748568, user_data = 0x82c40fc64}, {pos = 2758, events = 0, fd = 742428960, user_data = 0x8219a1e58}, {pos = 578089992, events = 8, fd = 563748568, user_data = 0x82c409120}, {pos = 563748544, events = 8, fd = -1863613339, user_data = 0x0}, {pos = 0, events = 0, fd = 744337648, user_data = 0x82c3ff550}, {pos = 0, events = 0, fd = 0, user_data = 0x82c5c99b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x8219a1f48}, {pos = 578109576, events = 8, fd = -1863592951, user_data = 0x8219a1f88}, {pos = 742456420, events = 8, fd = 2924, user_data = 0x82c4093b8}, {pos = 563748616, events = 8, fd = 578089992, user_data = 0x8219a1f88}, {pos = 742429624, events = 8, fd = 563748720, user_data = 0x10c290eb8465}, {pos = 578113592, events = 8, fd = 1, user_data = 0x82274f408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 563749128, events = 0, fd = 2564492, user_data = 0x8219a2170}, {pos = 563749232, events = 8, fd = 563749160, user_data = 0x1e}, {pos = 742393056, events = 8, fd = 563748888, user_data = 0x822754248}, {pos = 563749336, events = 8, fd = 563748864, user_data = 0x10c290ebcda3}, {pos = 578113592, events = 8, fd = 2690432, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 578113592, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8219a22d8}, {pos = 578089992, events = 8, fd = 563749216, user_data = 0x27218c}, {pos = 563749408, events = 8, fd = 563749408, user_data = 0x8219a21d8}, {pos = 32, events = 0, fd = 563748992, user_data = 0x10c290ebcb83}} [07:45:12.966] last_touch_time = 1709710821 [07:45:12.966] last_lockfile_recheck_time = 1709710821 [07:45:12.966] nevents = 1 [07:45:12.966] #22 0x0000000000826843 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8219a2990) at ../src/backend/postmaster/postmaster.c:1468 [07:45:12.966] userDoption = [07:45:12.966] listen_addr_saved = false [07:45:12.966] output_config_variable = [07:45:12.966] opt = [07:45:12.966] status = [07:45:12.966] #23 0x0000000000763d45 in main (argc=4, argv=0x8219a2990) at ../src/backend/main/main.c:197 [07:45:12.966] do_check_root = [07:45:12.977] [07:45:12.977] [07:45:12.977] [07:45:13.043] dumping /tmp/cores/postgres.13752.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:45:13.168] [New LWP 101628] [07:45:13.240] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [07:45:13.240] Program terminated with signal SIGABRT, Aborted. [07:45:13.240] Sent by thr_kill() from pid 13752 and user 1003. [07:45:13.240] #0 0x0000000829555dca in thr_kill () from /lib/libc.so.7 [07:45:13.785] [07:45:13.785] Thread 1 (LWP 101628): [07:45:13.785] #0 0x0000000829555dca in thr_kill () from /lib/libc.so.7 [07:45:13.785] No symbol table info available. [07:45:13.785] #1 0x00000008294ce6f4 in raise () from /lib/libc.so.7 [07:45:13.785] No symbol table info available. [07:45:13.785] #2 0x000000082957fbc9 in abort () from /lib/libc.so.7 [07:45:13.785] No symbol table info available. [07:45:13.785] #3 0x0000000000a1cfe7 in ExceptionalCondition (conditionName=, fileName=0x36c3bf "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1649) at ../src/backend/utils/error/assert.c:66 [07:45:13.785] No locals. [07:45:13.785] #4 0x000000000070f010 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821182338, materialize=, shouldFree=shouldFree@entry=0x821182216) at ../src/backend/executor/execTuples.c:1649 [07:45:13.785] No locals. [07:45:13.785] #5 0x00000000006d6c98 in ExecIRDeleteTriggers (estate=estate@entry=0x8399ea100, relinfo=relinfo@entry=0x8399ea6b0, slot=slot@entry=0x821182338) at ../src/backend/commands/trigger.c:2841 [07:45:13.785] trigger = [07:45:13.785] oldtuple = [07:45:13.785] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x839878450, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [07:45:13.785] trigdesc = 0x8399ea8c0 [07:45:13.785] newtuple = 0x0 [07:45:13.785] i = 0 [07:45:13.785] should_free = false [07:45:13.785] #6 0x0000000000734734 in ExecMergeMatched (context=0x821182370, resultRelInfo=0x8399ea6b0, tupleid=0x0, oldtuple=0x0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2977 [07:45:13.785] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [07:45:13.785] commandType = CMD_DELETE [07:45:13.785] result = TM_Ok [07:45:13.785] relaction = [07:45:13.785] l__state = {l = 0x83997dba8, i = 0} [07:45:13.785] mtstate = 0x8399ea4a0 [07:45:13.785] estate = 0x18cfc [07:45:13.785] econtext = 0x83997d3a8 [07:45:13.785] epqstate = 0x8399ea588 [07:45:13.785] l = [07:45:13.785] newslot = [07:45:13.785] isNull = [07:45:13.785] __error = [07:45:13.785] l__state = [07:45:13.785] updateCxt = [07:45:13.785] commandType = [07:45:13.785] result = [07:45:13.785] relaction = [07:45:13.785] __error = [07:45:13.785] resultRelationDesc = [07:45:13.785] lockmode = [07:45:13.785] inputslot = [07:45:13.785] epqslot = [07:45:13.785] __error = [07:45:13.785] __error = [07:45:13.785] __error = [07:45:13.785] __error = [07:45:13.785] __error = [07:45:13.785] __error = [07:45:13.785] __error = [07:45:13.785] #7 ExecMerge (context=context@entry=0x821182370, resultRelInfo=resultRelInfo@entry=0x8399ea6b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x821182338, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2774 [07:45:13.785] matched = [07:45:13.785] #8 0x0000000000733ae7 in ExecModifyTable (pstate=0x8399ea4a0) at ../src/backend/executor/nodeModifyTable.c:3920 [07:45:13.785] context = {mtstate = 0x8399ea4a0, epqstate = 0x8399ea588, estate = 0x8399ea100, planSlot = 0x83997c2e8, relaction = 0x83997d5e8, tmfd = {ctid = {ip_blkid = {bi_hi = 9950, bi_lo = 10581}, ip_posid = 8}, xmax = 159, cmax = 0, traversed = 146}, cpUpdateReturningSlot = 0x60467418c0e6b03} [07:45:13.785] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [07:45:13.785] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x839895118} [07:45:13.785] node = 0x8399ea4a0 [07:45:13.785] estate = 0x8399ea100 [07:45:13.785] operation = CMD_MERGE [07:45:13.785] resultRelInfo = 0x6 [07:45:13.785] subplanstate = 0x8399ebdf0 [07:45:13.785] slot = 0x83997c2e8 [07:45:13.785] tupleid = 0x0 [07:45:13.785] oldtuple = 0x821182338 [07:45:13.785] oldSlot = [07:45:13.785] #9 0x000000000070928b in ExecProcNodeFirst (node=0x8399ea4a0) at ../src/backend/executor/execProcnode.c:464 [07:45:13.785] No locals. [07:45:13.785] #10 0x000000000070167a in ExecProcNode (node=0x8399ea4a0) at ../src/include/executor/executor.h:274 [07:45:13.785] No locals. [07:45:13.785] #11 ExecutePlan (estate=0x8399ea100, planstate=0x8399ea4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=false, numberTuples=0, direction=ForwardScanDirection, dest=0x8399bb948, execute_once=) at ../src/backend/executor/execMain.c:1638 [07:45:13.785] current_tuple_count = [07:45:13.785] slot = [07:45:13.785] #12 standard_ExecutorRun (queryDesc=0x833802500, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:357 [07:45:13.785] estate = 0x8399ea100 [07:45:13.785] oldcontext = 0x833802400 [07:45:13.785] operation = CMD_MERGE [07:45:13.785] dest = 0x8399bb948 [07:45:13.785] sendTuples = false [07:45:13.785] #13 0x0000000834c42963 in pgss_ExecutorRun (queryDesc=0x833802500, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [07:45:13.785] _local_sigjmp_buf = {{_sjb = {35245009202, 11863608, 34914968728, 34914968896, 35223774464, 34914968736, 1, 1, 35326395263, 35223774464, 11872336, 34359738368}}} [07:45:13.785] _save_exception_stack = 0x821182620 [07:45:13.785] _save_context_stack = 0x0 [07:45:13.785] _do_rethrow = false [07:45:13.785] #14 0x0000000000701538 in ExecutorRun (queryDesc=0x18cfc, queryDesc@entry=0x833802500, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:299 [07:45:13.785] No locals. [07:45:13.785] #15 0x00000000008cff2f in ProcessQuery (plan=0x8399b7ad0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821182720) at ../src/backend/tcop/pquery.c:160 [07:45:13.785] queryDesc = 0x833802500 [07:45:13.785] #16 0x00000000008cf4cd in PortalRunMulti (portal=portal@entry=0x83370d100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8399bb948, altdest=altdest@entry=0x8399bb948, qc=0x821182720) at ../src/backend/tcop/pquery.c:1286 [07:45:13.785] pstmt = 0x8399b7ad0 [07:45:13.785] stmtlist_item__state = {l = 0x8399bb8f8, i = 0} [07:45:13.785] active_snapshot_set = true [07:45:13.785] stmtlist_item = 0x8399bb910 [07:45:13.785] #17 0x00000000008ced3b in PortalRun (portal=portal@entry=0x83370d100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x829555daa , dest@entry=0x8399bb948, altdest=0x0, altdest@entry=0x8399bb948, qc=0x821182720) at ../src/backend/tcop/pquery.c:791 [07:45:13.785] _local_sigjmp_buf = {{_sjb = {9235631, 35223085120, 34914969112, 34914969344, 34914969120, 11863608, 11831392, 35222769920, -6347183290304691329, 35222778112, 3552315, 34359738368}}} [07:45:13.785] _save_exception_stack = 0x8211827f0 [07:45:13.785] _save_context_stack = 0x0 [07:45:13.785] _do_rethrow = false [07:45:13.785] saveTopTransactionResourceOwner = 0x83375a040 [07:45:13.785] saveTopTransactionContext = 0x83367e000 [07:45:13.785] saveActivePortal = 0x0 [07:45:13.785] saveResourceOwner = 0x83375a040 [07:45:13.785] savePortalContext = 0x0 [07:45:13.785] saveMemoryContext = 0x83367e000 [07:45:13.785] result = [07:45:13.785] nprocessed = [07:45:13.785] #18 0x00000000008cdc1b in exec_simple_query (query_string=query_string@entry=0x833672100 "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:1273 [07:45:13.785] cmdtaglen = [07:45:13.785] snapshot_set = [07:45:13.785] per_parsetree_context = 0x0 [07:45:13.785] plantree_list = [07:45:13.785] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:45:13.785] parsetree = 0x833702fc8 [07:45:13.785] commandTag = CMDTAG_MERGE [07:45:13.785] cmdtagname = [07:45:13.785] querytree_list = [07:45:13.785] portal = 0x83370d100 [07:45:13.785] format = 0 [07:45:13.785] receiver = 0x8399bb948 [07:45:13.785] parsetree_item__state = {l = 0x839962f78, i = 0} [07:45:13.785] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [07:45:13.785] dest = DestRemote [07:45:13.785] was_logged = [07:45:13.785] oldcontext = 0x83367e000 [07:45:13.785] parsetree_list = 0x839962f78 [07:45:13.785] use_implicit_block = false [07:45:13.785] parsetree_item = 0x839962f90 [07:45:13.785] save_log_statement_stats = [07:45:13.785] #19 0x00000000008cba04 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [07:45:13.785] query_string = 0x833672100 "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"... [07:45:13.785] input_message = {data = 0x833672100 "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 = 241, maxlen = 1024, cursor = 241} [07:45:13.785] firstchar = [07:45:13.785] local_sigjmp_buf = {{_sjb = {9219792, 34914969584, 34914969544, 34914970144, 11872344, 11818832, 8192, 8388608, 72057628952888191, 0, 0, 1}}} [07:45:13.785] send_ready_for_query = false [07:45:13.785] idle_in_transaction_timeout_enabled = false [07:45:13.785] idle_session_timeout_enabled = false [07:45:13.785] #20 0x000000000082b205 in BackendRun (port=port@entry=0x83374f000) at ../src/backend/postmaster/postmaster.c:4475 [07:45:13.785] No locals. [07:45:13.785] #21 0x000000000082953d in BackendStartup (port=0x83374f000) at ../src/backend/postmaster/postmaster.c:4151 [07:45:13.785] bn = 0x83367e268 [07:45:13.785] pid = [07:45:13.785] __error = [07:45:13.785] __error = [07:45:13.785] __error = [07:45:13.785] save_errno = [07:45:13.785] __error = [07:45:13.785] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [07:45:13.785] port = 0x83374f000 [07:45:13.785] i = 0 [07:45:13.785] now = [07:45:13.785] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 555719688, events = 8, fd = 555720712, user_data = 0x8211fa408}, {pos = 555722760, events = 8, fd = 555723784, user_data = 0x8211fb008}, {pos = 555725832, events = 8, fd = 555745416, user_data = 0x821182d28}, {pos = 555232064, events = 8, fd = 1692716451, user_data = 0x8211fb408}, {pos = 2564674, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 555749432, events = 8, fd = 1, user_data = 0x8211fb408}, {pos = 692225192, events = 8, fd = 555232808, user_data = 0x8211fb408}, {pos = 555232032, events = 0, fd = 2564492, user_data = 0x821182d70}, {pos = 692332900, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 555751992, events = 8, fd = 1, user_data = 0x8211fb408}, {pos = 692246744, events = 8, fd = 555232360, user_data = 0x821182a10}, {pos = 33, events = 18, fd = 692317284, user_data = 0x8211fb408}, {pos = 555751992, events = 8, fd = 0, user_data = 0xa41}, {pos = 555232336, events = 8, fd = 1692689989, user_data = 0x829442964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821201a38}, {pos = 1, events = 0, fd = 555725832, user_data = 0x833662000}, {pos = 1, events = 0, fd = 862331284, user_data = 0x0}, {pos = 555232288, events = 8, fd = 711052300, user_data = 0x1}, {pos = 862330880, events = 8, fd = 555232336, user_data = 0x82a61beb4}, {pos = 694059360, events = 8, fd = 694059360, user_data = 0x82945a0c0}, {pos = 555725832, events = 8, fd = 555232560, user_data = 0x26b264e4642c}, {pos = 80627796, events = 0, fd = 1, user_data = 0x26b264e462ae}, {pos = 12240, events = 0, fd = 555232344, user_data = 0x821182d30}, {pos = 863127528, events = 8, fd = 555233952, user_data = 0x26b264e59e90}, {pos = 555725832, events = 8, fd = 555221887, user_data = 0x8295944b2}, {pos = 555232864, events = 8, fd = 0, user_data = 0x8211fb408}, {pos = 12240, events = 0, fd = 692183040, user_data = 0x1df950}, {pos = 694059360, events = 8, fd = 692317284, user_data = 0x3d00}, {pos = 555233744, events = 8, fd = 555232672, user_data = 0x8294e318e }, {pos = 694097976, events = 8, fd = 555232612, user_data = 0x8336d05da}, {pos = 555233744, events = 8, fd = 555232672, user_data = 0x8294f9605}, {pos = 555232610, events = 8, fd = 555233744, user_data = 0x8211831d0}, {pos = 0, events = 16777216, fd = -1945212157, user_data = 0x8211831d0}, {pos = 862782936, events = 8, fd = 555233952, user_data = 0x8295f1838}, {pos = 0, events = 0, fd = 555233808, user_data = 0x8294f970d}, {pos = 0, events = 0, fd = 0, user_data = 0x821183340}, {pos = 862782936, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1692718089, events = 9906, fd = 555233000, user_data = 0x82943ec64}, {pos = 2503, events = 0, fd = 1692718089, user_data = 0x821182f08}, {pos = 692317284, events = 8, fd = 2758, user_data = 0x829438120}, {pos = 555232904, events = 8, fd = 555725832, user_data = 0x821182f08}, {pos = 692289824, events = 8, fd = 555233008, user_data = 0x26b264e48465}, {pos = 0, events = 0, fd = 0, user_data = 0x821182ee0}, {pos = 692249936, events = 8, fd = 0, user_data = 0x0}, {pos = 555232960, events = 8, fd = 16, user_data = 0x0}, {pos = 555233144, events = 8, fd = 555745416, user_data = 0x26b264e4d409}, {pos = 555233208, events = 8, fd = 692317284, user_data = 0xb6c}, {pos = 692290488, events = 8, fd = 555233080, user_data = 0x8211fb408}, {pos = 555233208, events = 8, fd = 692290488, user_data = 0x821182fa0}, {pos = 1692697701, events = 9906, fd = 555749432, user_data = 0x800000001}, {pos = 555725832, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 555233608, user_data = 0x27218c}, {pos = 555233712, events = 8, fd = 555233712, user_data = 0x821183168}, {pos = 31, events = 0, fd = 0, user_data = 0x821183048}, {pos = 555747208, events = 8, fd = 555233816, user_data = 0x821183030}, {pos = 1692716451, events = 9906, fd = 555749432, user_data = 0x290d80}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821201038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555234072, events = 8, fd = 0, user_data = 0x3211831a0}, {pos = 555747304, events = 8, fd = 555233888, user_data = 0x290}, {pos = 555233816, events = 8, fd = 555233352, user_data = 0x8211830b0}, {pos = 1692716077, events = 9906, fd = 555714568, user_data = 0x0}} [07:45:13.785] last_touch_time = 1709710878 [07:45:13.785] last_lockfile_recheck_time = 1709710878 [07:45:13.785] nevents = 1 [07:45:13.785] #23 0x0000000000826843 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8211839d8) at ../src/backend/postmaster/postmaster.c:1468 [07:45:13.785] userDoption = [07:45:13.785] listen_addr_saved = false [07:45:13.785] output_config_variable = [07:45:13.785] opt = [07:45:13.785] status = [07:45:13.785] #24 0x0000000000763d45 in main (argc=4, argv=0x8211839d8) at ../src/backend/main/main.c:197 [07:45:13.785] do_check_root =