[10:47:49.910] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [10:47:50.280] dumping /tmp/cores/postgres.8294.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [10:47:50.414] [New LWP 100115] [10:47:50.500] Core was generated by `postgres: postgres regression [local] MERGE'. [10:47:50.500] Program terminated with signal SIGABRT, Aborted. [10:47:50.500] Sent by thr_kill() from pid 8294 and user 1003. [10:47:50.500] #0 0x000000082b4ecdca in thr_kill () from /lib/libc.so.7 [10:47:51.080] [10:47:51.080] Thread 1 (LWP 100115): [10:47:51.080] #0 0x000000082b4ecdca in thr_kill () from /lib/libc.so.7 [10:47:51.080] No symbol table info available. [10:47:51.080] #1 0x000000082b4656f4 in raise () from /lib/libc.so.7 [10:47:51.080] No symbol table info available. [10:47:51.080] #2 0x000000082b516bc9 in abort () from /lib/libc.so.7 [10:47:51.080] No symbol table info available. [10:47:51.080] #3 0x0000000000a5d727 in ExceptionalCondition (conditionName=, fileName=0x372e57 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [10:47:51.080] No locals. [10:47:51.080] #4 0x000000000073fda0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821ac8640, materialize=, shouldFree=shouldFree@entry=0x821ac85e6) at ../src/backend/executor/execTuples.c:1737 [10:47:51.080] No locals. [10:47:51.080] #5 0x0000000000705f88 in ExecIRDeleteTriggers (estate=estate@entry=0x8353c0100, relinfo=relinfo@entry=0x8353c06b0, slot=slot@entry=0x821ac8640) at ../src/backend/commands/trigger.c:2841 [10:47:51.080] trigger = [10:47:51.080] oldtuple = [10:47:51.080] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x840c75450, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [10:47:51.080] trigdesc = 0x8353c08c0 [10:47:51.080] newtuple = 0x0 [10:47:51.080] i = 0 [10:47:51.080] should_free = false [10:47:51.080] #6 0x0000000000764e9a in ExecMergeMatched (context=0x821ac8700, resultRelInfo=0x8353c06b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [10:47:51.080] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [10:47:51.080] relaction = 0x840d2bd20 [10:47:51.080] commandType = CMD_DELETE [10:47:51.080] result = TM_Ok [10:47:51.080] l__state = {l = 0x840da44c8, i = 0} [10:47:51.080] mtstate = 0x8353c04a0 [10:47:51.080] newslot = 0x0 [10:47:51.080] rslot = 0x0 [10:47:51.080] estate = 0x18713 [10:47:51.080] mergeActions = [10:47:51.080] econtext = 0x840da3568 [10:47:51.080] epqstate = 0x8353c0588 [10:47:51.080] actionStates = 0x840da44c8 [10:47:51.080] l = [10:47:51.080] isNull = [10:47:51.080] lmerge_matched = [10:47:51.080] __error = [10:47:51.080] l__state = [10:47:51.080] updateCxt = [10:47:51.080] relaction = [10:47:51.080] commandType = [10:47:51.080] result = [10:47:51.080] __error = [10:47:51.080] resultRelationDesc = [10:47:51.080] lockmode = [10:47:51.080] inputslot = [10:47:51.080] epqslot = [10:47:51.080] was_matched = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] #7 ExecMerge (context=0x821ac8700, resultRelInfo=0x8353c06b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [10:47:51.080] matched = [10:47:51.080] rslot = 0x0 [10:47:51.080] #8 ExecModifyTable (pstate=0x8353c04a0) at ../src/backend/executor/nodeModifyTable.c:4112 [10:47:51.080] context = {mtstate = 0x8353c04a0, epqstate = 0x8353c0588, estate = 0x8353c0100, planSlot = 0x840d2bc90, tmfd = {ctid = {ip_blkid = {bi_hi = 11328, bi_lo = 16605}, ip_posid = 8}, xmax = 893126320, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x8353c0100} [10:47:51.080] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [10:47:51.080] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8353d4118} [10:47:51.080] node = 0x8353c04a0 [10:47:51.080] estate = 0x8353c0100 [10:47:51.080] operation = CMD_MERGE [10:47:51.080] resultRelInfo = 0x8353c06b0 [10:47:51.080] subplanstate = 0x8353c1df0 [10:47:51.080] slot = [10:47:51.080] tupleid = 0x0 [10:47:51.080] oldtuple = 0x0 [10:47:51.080] oldSlot = [10:47:51.080] #9 0x0000000000739e3b in ExecProcNodeFirst (node=0x8353c04a0) at ../src/backend/executor/execProcnode.c:464 [10:47:51.080] No locals. [10:47:51.080] #10 0x000000000073212a in ExecProcNode (node=0x8353c04a0) at ../src/include/executor/executor.h:274 [10:47:51.080] No locals. [10:47:51.080] #11 ExecutePlan (estate=0x8353c0100, planstate=0x8353c04a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83520cb10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [10:47:51.080] current_tuple_count = [10:47:51.080] slot = [10:47:51.080] #12 standard_ExecutorRun (queryDesc=0x8352a1448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [10:47:51.080] estate = 0x8353c0100 [10:47:51.080] oldcontext = 0x83520c800 [10:47:51.080] operation = CMD_MERGE [10:47:51.080] dest = 0x83520cb10 [10:47:51.080] sendTuples = true [10:47:51.080] #13 0x0000000000731fdf in ExecutorRun (queryDesc=0x18713, queryDesc@entry=0x8352a1448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [10:47:51.080] No locals. [10:47:51.080] #14 0x000000000090b03f in ProcessQuery (plan=0x840dd0120, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821ac8918) at ../src/backend/tcop/pquery.c:160 [10:47:51.080] queryDesc = 0x8352a1448 [10:47:51.080] #15 0x000000000090a5dd in PortalRunMulti (portal=portal@entry=0x8352d4100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83520cb10, altdest=0xb51800 , qc=qc@entry=0x821ac8918) at ../src/backend/tcop/pquery.c:1286 [10:47:51.080] pstmt = 0x840dd0120 [10:47:51.080] stmtlist_item__state = {l = 0x840dd49d8, i = 0} [10:47:51.080] active_snapshot_set = true [10:47:51.080] stmtlist_item = 0x840dd49f0 [10:47:51.080] #16 0x000000000090a0cc in FillPortalStore (portal=portal@entry=0x8352d4100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [10:47:51.080] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:47:51.080] treceiver = 0x83520cb10 [10:47:51.080] #17 0x0000000000909e20 in PortalRun (portal=portal@entry=0x8352d4100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x840dd4a28, altdest=altdest@entry=0x840dd4a28, qc=0x821ac8a50) at ../src/backend/tcop/pquery.c:763 [10:47:51.080] _local_sigjmp_buf = {{_sjb = {9477567, 35251967192, 34924693832, 34924694064, 34924693840, 12165816, 12133600, 35251896576, 7112098687, 35251904768, 3579061, 34359738368}}} [10:47:51.080] _save_exception_stack = 0x821ac8b20 [10:47:51.080] _save_context_stack = 0x0 [10:47:51.080] _do_rethrow = false [10:47:51.080] saveTopTransactionResourceOwner = 0x8352e54d8 [10:47:51.080] saveTopTransactionContext = 0x83520a000 [10:47:51.080] saveActivePortal = 0x0 [10:47:51.080] saveResourceOwner = 0x8352e54d8 [10:47:51.080] savePortalContext = 0x0 [10:47:51.080] saveMemoryContext = 0x83520a000 [10:47:51.080] result = [10:47:51.080] nprocessed = [10:47:51.080] #18 0x0000000000908d2b in exec_simple_query (query_string=query_string@entry=0x8351fe100 "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:1274 [10:47:51.080] cmdtaglen = [10:47:51.080] snapshot_set = [10:47:51.080] per_parsetree_context = 0x0 [10:47:51.080] plantree_list = [10:47:51.080] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:47:51.080] parsetree = 0x840d70ee8 [10:47:51.080] commandTag = CMDTAG_MERGE [10:47:51.080] cmdtagname = [10:47:51.080] querytree_list = [10:47:51.080] portal = 0x8352d4100 [10:47:51.080] format = 0 [10:47:51.080] receiver = 0x840dd4a28 [10:47:51.080] parsetree_item__state = {l = 0x840d727b0, i = 0} [10:47:51.080] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [10:47:51.080] dest = DestRemote [10:47:51.080] was_logged = [10:47:51.080] oldcontext = 0x83520a000 [10:47:51.080] parsetree_list = 0x840d727b0 [10:47:51.080] use_implicit_block = false [10:47:51.080] parsetree_item = 0x840d727c8 [10:47:51.080] save_log_statement_stats = [10:47:51.080] #19 0x0000000000906b04 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [10:47:51.080] query_string = 0x8351fe100 "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"... [10:47:51.080] input_message = {data = 0x8351fe100 "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} [10:47:51.080] firstchar = [10:47:51.080] local_sigjmp_buf = {{_sjb = {9461712, 34924694304, 34924694264, 34924694864, 12174552, 12121024, 8192, 8388608, 72057628962587519, 0, 0, 34359738369}}} [10:47:51.080] send_ready_for_query = false [10:47:51.080] idle_in_transaction_timeout_enabled = false [10:47:51.080] idle_session_timeout_enabled = false [10:47:51.080] #20 0x00000000009015d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [10:47:51.080] bsdata = [10:47:51.080] #21 0x000000000085b432 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821ac9860 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821ac97a8) at ../src/backend/postmaster/launch_backend.c:265 [10:47:51.080] pid = [10:47:51.080] #22 0x000000000085fd91 in BackendStartup (client_sock=0x821ac97a8) at ../src/backend/postmaster/postmaster.c:3593 [10:47:51.080] startup_data = {canAcceptConnections = CAC_OK} [10:47:51.080] bn = 0x83520a588 [10:47:51.080] pid = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] save_errno = [10:47:51.080] __error = [10:47:51.080] __error = [10:47:51.080] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [10:47:51.080] 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' , "\230\254!\b\000\000\000\330e\371*\b\000\000\000\v\000\000\000\000\000\000\000\016\346\371*\b", '\000' , "@\230\254!\b\000\000\000\004\262\205\000\000\000\000\000P\230\254!\b", '\000' }, salen = 16}} [10:47:51.080] i = 0 [10:47:51.080] now = [10:47:51.080] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 725441636, events = 8, fd = 564956656, user_data = 0x821ac8f80}, {pos = 568980488, events = 8, fd = 32, user_data = 0x821ac8f70}, {pos = 1959226004, events = 603, fd = 568950792, user_data = 0x821e98408}, {pos = 568952840, events = 8, fd = 568953864, user_data = 0x821e9c008}, {pos = 568968200, events = 8, fd = 568969224, user_data = 0x821e9cc08}, {pos = 568971272, events = 8, fd = 568972296, user_data = 0x821e9d808}, {pos = 568974344, events = 8, fd = 568975368, user_data = 0x821e9e408}, {pos = 568977416, events = 8, fd = 568978440, user_data = 0x821e9f008}, {pos = 568980488, events = 8, fd = -1, user_data = 0x82b5ad2e0}, {pos = 564956896, events = 8, fd = 727032233, user_data = 0x0}, {pos = 4096, events = 0, fd = 256134686, user_data = 0x82b5ad7e8}, {pos = 876649440, events = 8, fd = 160, user_data = 0x0}, {pos = 872403088, events = 8, fd = 564957104, user_data = 0x82b53892c}, {pos = 4096, events = 0, fd = 725457252, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 569006648, user_data = 0x800000001}, {pos = 568980488, events = 8, fd = 725371096, user_data = 0x821ac9038}, {pos = 564956656, events = 8, fd = 32, user_data = 0x82b3d5c64}, {pos = 568980488, events = 8, fd = 569006648, user_data = 0x0}, {pos = 2625, events = 0, fd = 564957216, user_data = 0x25b74c76645}, {pos = 725457252, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 569006648, events = 8, fd = 1, user_data = 0x821e9f408}, {pos = 891215872, events = 8, fd = 1, user_data = 0x8351ee194}, {pos = 0, events = 0, fd = 564957168, user_data = 0x82af9dc0c}, {pos = 1, events = 0, fd = 891215872, user_data = 0x821ac9020}, {pos = 721014452, events = 8, fd = 727183712, user_data = 0x82b57f160 }, {pos = 725553344, events = 8, fd = 568980488, user_data = 0x821ac9100}, {pos = 1959224364, events = 603, fd = 872403088, user_data = 0x800000001}, {pos = 1959223982, events = 603, fd = 12240, user_data = 0x821ac9028}, {pos = 564957440, events = 8, fd = 891922408, user_data = 0x821ac9670}, {pos = 1959304848, events = 603, fd = 568980488, user_data = 0x821ac037f}, {pos = 726840732, events = 8, fd = 568950792, user_data = 0x0}, {pos = 568980488, events = 8, fd = 12240, user_data = 0x82b3b5000}, {pos = 1964368, events = 0, fd = 727183712, user_data = 0x82b3d5c64}, {pos = 15616, events = 0, fd = 564958624, user_data = 0x821ac9170}, {pos = 726114702, events = 8, fd = 727222328, user_data = 0x821ac9134}, {pos = 891659738, events = 8, fd = 564958624, user_data = 0x821ac9170}, {pos = 726205957, events = 8, fd = 564957490, user_data = 0x821ac95a0}, {pos = 564958624, events = 8, fd = 0, user_data = 0xcece2f060f444e1e}, {pos = 564958624, events = 8, fd = 891659736, user_data = 0x821ac9670}, {pos = 727222328, events = 8, fd = 0, user_data = 0x821ac95e0}, {pos = 726206221, events = 8, fd = 0, user_data = 0x0}, {pos = 564958992, events = 8, fd = 891659736, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1959253001, events = 603, fd = 564957896, user_data = 0x82b3d5c64}, {pos = 2503, events = 0, fd = 1959253001, user_data = 0x821ac92e8}, {pos = 725441636, events = 8, fd = 2758, user_data = 0x82b3cf120}, {pos = 564957800, events = 8, fd = 568980488, user_data = 0x821ac92e8}, {pos = 725414176, events = 8, fd = 564957904, user_data = 0x25b74c78465}, {pos = 0, events = 0, fd = 0, user_data = 0x82b5a10f0}, {pos = 725374288, events = 8, fd = 0, user_data = 0x0}, {pos = 727251376, events = 8, fd = 1959253001, user_data = 0x821ac9378}, {pos = 725441636, events = 8, fd = 2924, user_data = 0x82b3cf3b8}, {pos = 564957944, events = 8, fd = 568980488, user_data = 0x821ac9378}, {pos = 725414840, events = 8, fd = 564958048, user_data = 0x25b74c78465}, {pos = 569004088, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 568980488, events = 8, fd = 725374288, user_data = 0x821ac9638}, {pos = 568980488, events = 8, fd = 564958488, user_data = 0x1e}, {pos = 725378272, events = 8, fd = 564958216, user_data = 0x821ea4288}, {pos = 564958664, events = 8, fd = 564958192, user_data = 0x25b74c7cda3}, {pos = 569004088, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 569004088, user_data = 0x1}} [10:47:51.080] last_touch_time = 1714214695 [10:47:51.080] last_lockfile_recheck_time = 1714214695 [10:47:51.080] nevents = 1 [10:47:51.080] #24 0x000000000085d666 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821ac9da0) at ../src/backend/postmaster/postmaster.c:1372 [10:47:51.080] userDoption = [10:47:51.080] listen_addr_saved = false [10:47:51.080] output_config_variable = [10:47:51.080] opt = [10:47:51.080] status = [10:47:51.080] #25 0x0000000000795325 in main (argc=8, argv=0x821ac9da0) at ../src/backend/main/main.c:197 [10:47:51.080] do_check_root = [10:47:51.091] [10:47:51.091] [10:47:51.091] [10:47:51.153] dumping /tmp/cores/postgres.8917.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:47:51.282] [New LWP 101794] [10:47:51.346] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [10:47:51.346] Program terminated with signal SIGABRT, Aborted. [10:47:51.346] Sent by thr_kill() from pid 8917 and user 1003. [10:47:51.346] #0 0x000000082c00edca in thr_kill () from /lib/libc.so.7 [10:47:51.891] [10:47:51.891] Thread 1 (LWP 101794): [10:47:51.891] #0 0x000000082c00edca in thr_kill () from /lib/libc.so.7 [10:47:51.891] No symbol table info available. [10:47:51.891] #1 0x000000082bf876f4 in raise () from /lib/libc.so.7 [10:47:51.891] No symbol table info available. [10:47:51.891] #2 0x000000082c038bc9 in abort () from /lib/libc.so.7 [10:47:51.891] No symbol table info available. [10:47:51.891] #3 0x0000000000a5d727 in ExceptionalCondition (conditionName=, fileName=0x372e57 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [10:47:51.891] No locals. [10:47:51.891] #4 0x000000000073fda0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8212cd020, materialize=, shouldFree=shouldFree@entry=0x8212ccfc6) at ../src/backend/executor/execTuples.c:1737 [10:47:51.891] No locals. [10:47:51.891] #5 0x0000000000705f88 in ExecIRDeleteTriggers (estate=estate@entry=0x8348b7100, relinfo=relinfo@entry=0x8348b76b0, slot=slot@entry=0x8212cd020) at ../src/backend/commands/trigger.c:2841 [10:47:51.891] trigger = [10:47:51.891] oldtuple = [10:47:51.891] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x836b1f110, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [10:47:51.891] trigdesc = 0x8348b78c0 [10:47:51.891] newtuple = 0x0 [10:47:51.891] i = 0 [10:47:51.891] should_free = false [10:47:51.891] #6 0x0000000000764e9a in ExecMergeMatched (context=0x8212cd0e0, resultRelInfo=0x8348b76b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [10:47:51.891] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [10:47:51.891] relaction = 0x836bb1e20 [10:47:51.891] commandType = CMD_DELETE [10:47:51.891] result = TM_Ok [10:47:51.891] l__state = {l = 0x836c2cdc8, i = 0} [10:47:51.891] mtstate = 0x8348b74a0 [10:47:51.891] newslot = 0x0 [10:47:51.891] rslot = 0x0 [10:47:51.891] estate = 0x18da2 [10:47:51.891] mergeActions = [10:47:51.891] econtext = 0x836c2be68 [10:47:51.891] epqstate = 0x8348b7588 [10:47:51.891] actionStates = 0x836c2cdc8 [10:47:51.891] l = [10:47:51.891] isNull = [10:47:51.891] lmerge_matched = [10:47:51.891] __error = [10:47:51.891] l__state = [10:47:51.891] updateCxt = [10:47:51.891] relaction = [10:47:51.891] commandType = [10:47:51.891] result = [10:47:51.891] __error = [10:47:51.891] resultRelationDesc = [10:47:51.891] lockmode = [10:47:51.891] inputslot = [10:47:51.891] epqslot = [10:47:51.891] was_matched = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] #7 ExecMerge (context=0x8212cd0e0, resultRelInfo=0x8348b76b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [10:47:51.891] matched = [10:47:51.891] rslot = 0x0 [10:47:51.891] #8 ExecModifyTable (pstate=0x8348b74a0) at ../src/backend/executor/nodeModifyTable.c:4112 [10:47:51.891] context = {mtstate = 0x8348b74a0, epqstate = 0x8348b7588, estate = 0x8348b7100, planSlot = 0x836bb1d90, tmfd = {ctid = {ip_blkid = {bi_hi = 48640, bi_lo = 14021}, ip_posid = 8}, xmax = 881555120, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x8348b7100} [10:47:51.891] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [10:47:51.891] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8348cb118} [10:47:51.891] node = 0x8348b74a0 [10:47:51.891] estate = 0x8348b7100 [10:47:51.891] operation = CMD_MERGE [10:47:51.891] resultRelInfo = 0x8348b76b0 [10:47:51.891] subplanstate = 0x8348b8df0 [10:47:51.891] slot = [10:47:51.891] tupleid = 0x0 [10:47:51.891] oldtuple = 0x0 [10:47:51.891] oldSlot = [10:47:51.891] #9 0x0000000000739e3b in ExecProcNodeFirst (node=0x8348b74a0) at ../src/backend/executor/execProcnode.c:464 [10:47:51.891] No locals. [10:47:51.891] #10 0x000000000073212a in ExecProcNode (node=0x8348b74a0) at ../src/include/executor/executor.h:274 [10:47:51.891] No locals. [10:47:51.891] #11 ExecutePlan (estate=0x8348b7100, planstate=0x8348b74a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83476a310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [10:47:51.891] current_tuple_count = [10:47:51.891] slot = [10:47:51.891] #12 standard_ExecutorRun (queryDesc=0x8347d0448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [10:47:51.891] estate = 0x8348b7100 [10:47:51.891] oldcontext = 0x83476a000 [10:47:51.891] operation = CMD_MERGE [10:47:51.891] dest = 0x83476a310 [10:47:51.891] sendTuples = true [10:47:51.891] #13 0x0000000000731fdf in ExecutorRun (queryDesc=0x18da2, queryDesc@entry=0x8347d0448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [10:47:51.891] No locals. [10:47:51.891] #14 0x000000000090b03f in ProcessQuery (plan=0x836c592e0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8212cd2f8) at ../src/backend/tcop/pquery.c:160 [10:47:51.891] queryDesc = 0x8347d0448 [10:47:51.891] #15 0x000000000090a5dd in PortalRunMulti (portal=portal@entry=0x8347b0100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83476a310, altdest=0xb51800 , qc=qc@entry=0x8212cd2f8) at ../src/backend/tcop/pquery.c:1286 [10:47:51.891] pstmt = 0x836c592e0 [10:47:51.891] stmtlist_item__state = {l = 0x836c5db98, i = 0} [10:47:51.891] active_snapshot_set = true [10:47:51.891] stmtlist_item = 0x836c5dbb0 [10:47:51.891] #16 0x000000000090a0cc in FillPortalStore (portal=portal@entry=0x8347b0100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [10:47:51.891] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:47:51.891] treceiver = 0x83476a310 [10:47:51.891] #17 0x0000000000909e20 in PortalRun (portal=portal@entry=0x8347b0100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x836c5dbe8, altdest=altdest@entry=0x836c5dbe8, qc=0x8212cd430) at ../src/backend/tcop/pquery.c:763 [10:47:51.891] _local_sigjmp_buf = {{_sjb = {9477567, 35240552728, 34916324136, 34916324368, 34916324144, 12165816, 12133600, 35240214784, 7112098687, 35240222976, 3579061, 34359738368}}} [10:47:51.891] _save_exception_stack = 0x8212cd500 [10:47:51.891] _save_context_stack = 0x0 [10:47:51.891] _do_rethrow = false [10:47:51.891] saveTopTransactionResourceOwner = 0x834802918 [10:47:51.891] saveTopTransactionContext = 0x834723000 [10:47:51.891] saveActivePortal = 0x0 [10:47:51.891] saveResourceOwner = 0x834802918 [10:47:51.891] savePortalContext = 0x0 [10:47:51.891] saveMemoryContext = 0x834723000 [10:47:51.891] result = [10:47:51.891] nprocessed = [10:47:51.891] #18 0x0000000000908d2b in exec_simple_query (query_string=query_string@entry=0x834717100 "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:1274 [10:47:51.891] cmdtaglen = [10:47:51.891] snapshot_set = [10:47:51.891] per_parsetree_context = 0x0 [10:47:51.891] plantree_list = [10:47:51.891] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:47:51.891] parsetree = 0x836bfa468 [10:47:51.891] commandTag = CMDTAG_MERGE [10:47:51.891] cmdtagname = [10:47:51.891] querytree_list = [10:47:51.891] portal = 0x8347b0100 [10:47:51.891] format = 0 [10:47:51.891] receiver = 0x836c5dbe8 [10:47:51.891] parsetree_item__state = {l = 0x836bfbd30, i = 0} [10:47:51.891] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [10:47:51.891] dest = DestRemote [10:47:51.891] was_logged = [10:47:51.891] oldcontext = 0x834723000 [10:47:51.891] parsetree_list = 0x836bfbd30 [10:47:51.891] use_implicit_block = false [10:47:51.891] parsetree_item = 0x836bfbd48 [10:47:51.891] save_log_statement_stats = [10:47:51.891] #19 0x0000000000906b04 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [10:47:51.891] query_string = 0x834717100 "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"... [10:47:51.891] input_message = {data = 0x834717100 "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} [10:47:51.891] firstchar = [10:47:51.891] local_sigjmp_buf = {{_sjb = {9461712, 34916324608, 34916324568, 34916325168, 12174552, 12121024, 8192, 8388608, 72057628954198911, 0, 0, 34359738369}}} [10:47:51.891] send_ready_for_query = false [10:47:51.891] idle_in_transaction_timeout_enabled = false [10:47:51.891] idle_session_timeout_enabled = false [10:47:51.891] #20 0x00000000009015d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [10:47:51.891] bsdata = [10:47:51.891] #21 0x000000000085b432 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8212ce240 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212ce188) at ../src/backend/postmaster/launch_backend.c:265 [10:47:51.891] pid = [10:47:51.891] #22 0x000000000085fd91 in BackendStartup (client_sock=0x8212ce188) at ../src/backend/postmaster/postmaster.c:3593 [10:47:51.891] startup_data = {canAcceptConnections = CAC_OK} [10:47:51.891] bn = 0x8347231c8 [10:47:51.891] pid = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] save_errno = [10:47:51.891] __error = [10:47:51.891] __error = [10:47:51.891] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [10:47:51.891] 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 = '\000' , "\340\341,!\b\000\000\000ص^)\b\000\000\000\v\000\000\000\000\000\000\000\0166_)\b", '\000' , " \342,!\b\000\000\000\004\262\205\000\000\000\000\0000\342,!\b", '\000' }, salen = 16}} [10:47:51.891] i = 0 [10:47:51.891] now = [10:47:51.891] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 737115236, events = 8, fd = 556586960, user_data = 0x8212cd960}, {pos = 570586120, events = 8, fd = 32, user_data = 0x8212cd950}, {pos = -1277789548, events = 12142, fd = 570556424, user_data = 0x822020408}, {pos = 570558472, events = 8, fd = 570559496, user_data = 0x822024008}, {pos = 570573832, events = 8, fd = 570574856, user_data = 0x822024c08}, {pos = 570576904, events = 8, fd = 570577928, user_data = 0x822025808}, {pos = 570579976, events = 8, fd = 570581000, user_data = 0x822026408}, {pos = 570583048, events = 8, fd = 570584072, user_data = 0x822027008}, {pos = 570586120, events = 8, fd = 570605768, user_data = 0x8212cdad8}, {pos = 556587264, events = 8, fd = -1277764189, user_data = 0x0}, {pos = 2571326, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 570609720, events = 8, fd = 1, user_data = 0x822027408}, {pos = 737023144, events = 8, fd = 556587992, user_data = 0x822027408}, {pos = 556587248, events = 0, fd = 737130852, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 570612280, user_data = 0x1}, {pos = 570586120, events = 8, fd = 737044696, user_data = 0x8212cda18}, {pos = 556586960, events = 8, fd = 32, user_data = 0x82bef7c64}, {pos = 570586120, events = 8, fd = 570612280, user_data = 0x0}, {pos = 2625, events = 0, fd = 556587520, user_data = 0x2f6eb3d67645}, {pos = 737130852, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 570612280, events = 8, fd = 1, user_data = 0x822027408}, {pos = 879783936, events = 8, fd = 1, user_data = 0x834707194}, {pos = 0, events = 0, fd = 556587472, user_data = 0x8295f2c0c}, {pos = 1, events = 0, fd = 879783936, user_data = 0x8212cda00}, {pos = 694099636, events = 8, fd = 738857312, user_data = 0x82c0a1160 }, {pos = 737226944, events = 8, fd = 570586120, user_data = 0x8212cdae0}, {pos = -1277791188, events = 12142, fd = 570585096, user_data = 0x800000001}, {pos = -1277791570, events = 12142, fd = 12240, user_data = 0x8212cda08}, {pos = 556587744, events = 8, fd = 880580584, user_data = 0x8212ce050}, {pos = -1277710704, events = 12142, fd = 570586120, user_data = 0x8212c037f}, {pos = 738514098, events = 8, fd = 570556424, user_data = 0x0}, {pos = 570586120, events = 8, fd = 12240, user_data = 0x82bed7000}, {pos = 1964368, events = 0, fd = 738857312, user_data = 0x82bef7c64}, {pos = 15616, events = 0, fd = 556588928, user_data = 0x8212cdb50}, {pos = 737788302, events = 8, fd = 738895928, user_data = 0x8212cdb14}, {pos = 880235994, events = 8, fd = 556588928, user_data = 0x8212cdb50}, {pos = 737879557, events = 8, fd = 556587794, user_data = 0x8212cdf80}, {pos = 556588928, events = 8, fd = 0, user_data = 0xe6e1319be606ba13}, {pos = 556588928, events = 8, fd = 880235992, user_data = 0x8212ce050}, {pos = 738895928, events = 8, fd = 0, user_data = 0x8212cdfc0}, {pos = 737879821, events = 8, fd = 0, user_data = 0x0}, {pos = 556589296, events = 8, fd = 880235992, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1277762551, events = 12142, fd = 556588200, user_data = 0x82bef7c64}, {pos = 2503, events = 0, fd = -1277762551, user_data = 0x8212cdcc8}, {pos = 737115236, events = 8, fd = 2758, user_data = 0x82bef1120}, {pos = 556588104, events = 8, fd = 570586120, user_data = 0x8212cdcc8}, {pos = 737087776, events = 8, fd = 556588208, user_data = 0x2f6eb3d69465}, {pos = 0, events = 0, fd = 0, user_data = 0x82c0c30f0}, {pos = 737047888, events = 8, fd = 0, user_data = 0x0}, {pos = 738924976, events = 8, fd = -1277762551, user_data = 0x8212cdd58}, {pos = 737115236, events = 8, fd = 2924, user_data = 0x82bef13b8}, {pos = 556588248, events = 8, fd = 570586120, user_data = 0x8212cdd58}, {pos = 737088440, events = 8, fd = 556588352, user_data = 0x2f6eb3d69465}, {pos = 570609720, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 570586120, events = 8, fd = 737047888, user_data = 0x8212ce018}, {pos = 570586120, events = 8, fd = 556588792, user_data = 0x1e}, {pos = 737051872, events = 8, fd = 556588520, user_data = 0x82202c288}, {pos = 556588968, events = 8, fd = 556588496, user_data = 0x2f6eb3d6dda3}, {pos = 570609720, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 570609720, user_data = 0x1}} [10:47:51.892] last_touch_time = 1714214697 [10:47:51.892] last_lockfile_recheck_time = 1714214697 [10:47:51.892] nevents = 1 [10:47:51.892] #24 0x000000000085d666 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8212ce780) at ../src/backend/postmaster/postmaster.c:1372 [10:47:51.892] userDoption = [10:47:51.892] listen_addr_saved = false [10:47:51.892] output_config_variable = [10:47:51.892] opt = [10:47:51.892] status = [10:47:51.892] #25 0x0000000000795325 in main (argc=4, argv=0x8212ce780) at ../src/backend/main/main.c:197 [10:47:51.892] do_check_root = [10:47:51.903] [10:47:51.903] [10:47:51.903] [10:47:51.967] dumping /tmp/cores/postgres.14073.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:47:52.089] [New LWP 100100] [10:47:52.151] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [10:47:52.151] Program terminated with signal SIGABRT, Aborted. [10:47:52.151] Sent by thr_kill() from pid 14073 and user 1003. [10:47:52.151] #0 0x000000082ba75dca in thr_kill () from /lib/libc.so.7 [10:47:52.687] [10:47:52.687] Thread 1 (LWP 100100): [10:47:52.687] #0 0x000000082ba75dca in thr_kill () from /lib/libc.so.7 [10:47:52.687] No symbol table info available. [10:47:52.687] #1 0x000000082b9ee6f4 in raise () from /lib/libc.so.7 [10:47:52.687] No symbol table info available. [10:47:52.687] #2 0x000000082ba9fbc9 in abort () from /lib/libc.so.7 [10:47:52.687] No symbol table info available. [10:47:52.687] #3 0x0000000000a5d727 in ExceptionalCondition (conditionName=, fileName=0x372e57 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [10:47:52.687] No locals. [10:47:52.687] #4 0x000000000073fda0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82121b800, materialize=, shouldFree=shouldFree@entry=0x82121b7a6) at ../src/backend/executor/execTuples.c:1737 [10:47:52.687] No locals. [10:47:52.687] #5 0x0000000000705f88 in ExecIRDeleteTriggers (estate=estate@entry=0x836686100, relinfo=relinfo@entry=0x8366866b0, slot=slot@entry=0x82121b800) at ../src/backend/commands/trigger.c:2841 [10:47:52.687] trigger = [10:47:52.687] oldtuple = [10:47:52.687] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8398b4170, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [10:47:52.687] trigdesc = 0x8366868c0 [10:47:52.687] newtuple = 0x0 [10:47:52.687] i = 0 [10:47:52.687] should_free = false [10:47:52.687] #6 0x0000000000764e9a in ExecMergeMatched (context=0x82121b8c0, resultRelInfo=0x8366866b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [10:47:52.687] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [10:47:52.687] relaction = 0x8366827a0 [10:47:52.687] commandType = CMD_DELETE [10:47:52.687] result = TM_Ok [10:47:52.687] l__state = {l = 0x839a00608, i = 0} [10:47:52.687] mtstate = 0x8366864a0 [10:47:52.687] newslot = 0x0 [10:47:52.687] rslot = 0x0 [10:47:52.687] estate = 0x18704 [10:47:52.687] mergeActions = [10:47:52.687] econtext = 0x8399ff6a8 [10:47:52.687] epqstate = 0x836686588 [10:47:52.687] actionStates = 0x839a00608 [10:47:52.687] l = [10:47:52.687] isNull = [10:47:52.687] lmerge_matched = [10:47:52.687] __error = [10:47:52.687] l__state = [10:47:52.687] updateCxt = [10:47:52.687] relaction = [10:47:52.687] commandType = [10:47:52.687] result = [10:47:52.687] __error = [10:47:52.687] resultRelationDesc = [10:47:52.687] lockmode = [10:47:52.687] inputslot = [10:47:52.687] epqslot = [10:47:52.687] was_matched = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] #7 ExecMerge (context=0x82121b8c0, resultRelInfo=0x8366866b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [10:47:52.687] matched = [10:47:52.687] rslot = 0x0 [10:47:52.687] #8 ExecModifyTable (pstate=0x8366864a0) at ../src/backend/executor/nodeModifyTable.c:4112 [10:47:52.687] context = {mtstate = 0x8366864a0, epqstate = 0x836686588, estate = 0x836686100, planSlot = 0x836682710, tmfd = {ctid = {ip_blkid = {bi_hi = 47464, bi_lo = 8481}, ip_posid = 8}, xmax = 733134320, cmax = 8, traversed = 48}, cpUpdateReturningSlot = 0x82ba726de} [10:47:52.687] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [10:47:52.687] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836692118} [10:47:52.687] node = 0x8366864a0 [10:47:52.687] estate = 0x836686100 [10:47:52.687] operation = CMD_MERGE [10:47:52.687] resultRelInfo = 0x8366866b0 [10:47:52.687] subplanstate = 0x836687df0 [10:47:52.687] slot = [10:47:52.687] tupleid = 0x0 [10:47:52.687] oldtuple = 0x0 [10:47:52.687] oldSlot = [10:47:52.687] #9 0x0000000000739e3b in ExecProcNodeFirst (node=0x8366864a0) at ../src/backend/executor/execProcnode.c:464 [10:47:52.687] No locals. [10:47:52.687] #10 0x000000000073212a in ExecProcNode (node=0x8366864a0) at ../src/include/executor/executor.h:274 [10:47:52.687] No locals. [10:47:52.687] #11 ExecutePlan (estate=0x836686100, planstate=0x8366864a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836658710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [10:47:52.687] current_tuple_count = [10:47:52.687] slot = [10:47:52.687] #12 standard_ExecutorRun (queryDesc=0x836583448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [10:47:52.687] estate = 0x836686100 [10:47:52.687] oldcontext = 0x836658400 [10:47:52.687] operation = CMD_MERGE [10:47:52.687] dest = 0x836658710 [10:47:52.687] sendTuples = true [10:47:52.687] #13 0x00000008388b0963 in pgss_ExecutorRun (queryDesc=0x836583448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [10:47:52.687] _local_sigjmp_buf = {{_sjb = {35308374322, 12165816, 34915596792, 34915596960, 35271488584, 34915596800, 1, 1, 35272524671, 35271488584, 12174544, 34359738368}}} [10:47:52.687] _save_exception_stack = 0x82121bbc0 [10:47:52.687] _save_context_stack = 0x0 [10:47:52.687] _do_rethrow = false [10:47:52.687] #14 0x0000000000731fd8 in ExecutorRun (queryDesc=0x18704, queryDesc@entry=0x836583448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [10:47:52.687] No locals. [10:47:52.687] #15 0x000000000090b03f in ProcessQuery (plan=0x8399b7240, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82121bb88) at ../src/backend/tcop/pquery.c:160 [10:47:52.687] queryDesc = 0x836583448 [10:47:52.687] #16 0x000000000090a5dd in PortalRunMulti (portal=portal@entry=0x836565100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836658710, altdest=0xb51800 , qc=qc@entry=0x82121bb88) at ../src/backend/tcop/pquery.c:1286 [10:47:52.687] pstmt = 0x8399b7240 [10:47:52.687] stmtlist_item__state = {l = 0x8399bbaf8, i = 0} [10:47:52.687] active_snapshot_set = true [10:47:52.687] stmtlist_item = 0x8399bbb10 [10:47:52.687] #17 0x000000000090a0cc in FillPortalStore (portal=portal@entry=0x836565100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [10:47:52.687] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:47:52.687] treceiver = 0x836658710 [10:47:52.687] #18 0x0000000000909e20 in PortalRun (portal=portal@entry=0x836565100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8399bbb48, altdest=altdest@entry=0x8399bbb48, qc=0x82121bcc0) at ../src/backend/tcop/pquery.c:763 [10:47:52.687] _local_sigjmp_buf = {{_sjb = {9477567, 35271696728, 34915597240, 34915597472, 34915597248, 12165816, 12133600, 35271364864, 7112098687, 35271373056, 3579061, 34359738368}}} [10:47:52.687] _save_exception_stack = 0x82121bd90 [10:47:52.687] _save_context_stack = 0x0 [10:47:52.687] _do_rethrow = false [10:47:52.687] saveTopTransactionResourceOwner = 0x8365b6158 [10:47:52.687] saveTopTransactionContext = 0x8364d6000 [10:47:52.687] saveActivePortal = 0x0 [10:47:52.687] saveResourceOwner = 0x8365b6158 [10:47:52.687] savePortalContext = 0x0 [10:47:52.687] saveMemoryContext = 0x8364d6000 [10:47:52.687] result = [10:47:52.687] nprocessed = [10:47:52.687] #19 0x0000000000908d2b in exec_simple_query (query_string=query_string@entry=0x8364ca100 "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:1274 [10:47:52.687] cmdtaglen = [10:47:52.687] snapshot_set = [10:47:52.687] per_parsetree_context = 0x0 [10:47:52.687] plantree_list = [10:47:52.687] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:47:52.687] parsetree = 0x83999f6a8 [10:47:52.687] commandTag = CMDTAG_MERGE [10:47:52.687] cmdtagname = [10:47:52.687] querytree_list = [10:47:52.687] portal = 0x836565100 [10:47:52.687] format = 0 [10:47:52.687] receiver = 0x8399bbb48 [10:47:52.687] parsetree_item__state = {l = 0x8399a0f70, i = 0} [10:47:52.687] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [10:47:52.687] dest = DestRemote [10:47:52.687] was_logged = [10:47:52.687] oldcontext = 0x8364d6000 [10:47:52.687] parsetree_list = 0x8399a0f70 [10:47:52.687] use_implicit_block = false [10:47:52.687] parsetree_item = 0x8399a0f88 [10:47:52.687] save_log_statement_stats = [10:47:52.687] #20 0x0000000000906b04 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [10:47:52.687] query_string = 0x8364ca100 "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"... [10:47:52.687] input_message = {data = 0x8364ca100 "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} [10:47:52.687] firstchar = [10:47:52.687] local_sigjmp_buf = {{_sjb = {9461712, 34915597712, 34915597672, 34915598272, 12174552, 12121024, 8192, 8388608, 72057628953478015, 0, 0, 1}}} [10:47:52.687] send_ready_for_query = false [10:47:52.687] idle_in_transaction_timeout_enabled = false [10:47:52.687] idle_session_timeout_enabled = false [10:47:52.687] #21 0x00000000009015d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [10:47:52.687] bsdata = [10:47:52.687] #22 0x000000000085b432 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82121cad0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82121ca18) at ../src/backend/postmaster/launch_backend.c:265 [10:47:52.687] pid = [10:47:52.687] #23 0x000000000085fd91 in BackendStartup (client_sock=0x82121ca18) at ../src/backend/postmaster/postmaster.c:3593 [10:47:52.687] startup_data = {canAcceptConnections = CAC_OK} [10:47:52.687] bn = 0x8364d63a8 [10:47:52.687] pid = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] save_errno = [10:47:52.687] __error = [10:47:52.687] __error = [10:47:52.687] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [10:47:52.687] 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 = '\000' , "p\312!!\b\000\000\000\330\365\226*\b\000\000\000\v\000\000\000\000\000\000\000\016v\227*\b", '\000' , "\260\312!!\b\000\000\000\004\262\205\000\000\000\000\000\300\312!!\b", '\000' }, salen = 16}} [10:47:52.687] i = 0 [10:47:52.687] now = [10:47:52.687] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 555860464, events = 8, fd = 559600648, user_data = 0x21}, {pos = 555860448, events = 8, fd = 1096440468, user_data = 0x8215a6008}, {pos = 559571976, events = 8, fd = 559573000, user_data = 0x8215a6c08}, {pos = 559587336, events = 8, fd = 559588360, user_data = 0x8215aa808}, {pos = 559590408, events = 8, fd = 559591432, user_data = 0x8215ab408}, {pos = 559593480, events = 8, fd = 559594504, user_data = 0x8215ac008}, {pos = 559596552, events = 8, fd = 559597576, user_data = 0x8215acc08}, {pos = 559599624, events = 8, fd = 559600648, user_data = 0x8215b20c8}, {pos = 555860840, events = 8, fd = 555860352, user_data = 0x2eef415abda3}, {pos = 559600648, events = 8, fd = 2571326, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 559624248, user_data = 0x1}, {pos = 559600648, events = 8, fd = 731153576, user_data = 0x82121c468}, {pos = 559600648, events = 8, fd = 555860320, user_data = 0x273b88}, {pos = 555860912, events = 8, fd = 731261284, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 559626808, user_data = 0x2eef00000001}, {pos = 559600648, events = 8, fd = 731175128, user_data = 0x82121c2a8}, {pos = 555860048, events = 8, fd = 33, user_data = 0x82b95ec64}, {pos = 559600648, events = 8, fd = 559626808, user_data = 0x0}, {pos = 2625, events = 0, fd = 555860624, user_data = 0x2eef415a5645}, {pos = 731261284, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 559626808, events = 8, fd = 1, user_data = 0x8215ad408}, {pos = 910925824, events = 8, fd = 1, user_data = 0x8364ba194}, {pos = 0, events = 0, fd = 555860576, user_data = 0x82a976c0c}, {pos = 1, events = 0, fd = 910925824, user_data = 0x82121c290}, {pos = 714563252, events = 8, fd = 732987744, user_data = 0x82bb08160 }, {pos = 731357376, events = 8, fd = 559600648, user_data = 0x82121c370}, {pos = 1096438828, events = 12015, fd = 80627796, user_data = 0x1}, {pos = 1096438446, events = 12015, fd = 12240, user_data = 0x82121c298}, {pos = 555860848, events = 8, fd = 911722472, user_data = 0x82121c8e0}, {pos = 1096519312, events = 12015, fd = 559600648, user_data = 0x82121037f}, {pos = 732644530, events = 8, fd = 555861152, user_data = 0x2eef00000000}, {pos = 559600648, events = 8, fd = 12240, user_data = 0x82b93e000}, {pos = 1964368, events = 0, fd = 732987744, user_data = 0x82b95ec64}, {pos = 15616, events = 0, fd = 555862032, user_data = 0x82121c3e0}, {pos = 731918734, events = 8, fd = 733026360, user_data = 0x82121c3a4}, {pos = 911377882, events = 8, fd = 555862032, user_data = 0x82121c3e0}, {pos = 732009989, events = 8, fd = 555860898, user_data = 0x82121c810}, {pos = 555862032, events = 8, fd = 0, user_data = 0x84fd604c85c2cf9d}, {pos = 555862032, events = 8, fd = 911377880, user_data = 0x82121c8e0}, {pos = 733026360, events = 8, fd = 0, user_data = 0x82121c850}, {pos = 732010253, events = 8, fd = 0, user_data = 0x0}, {pos = 555862400, events = 8, fd = 911377880, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1096467465, user_data = 0x82121c528}, {pos = 731245668, events = 8, fd = 2503, user_data = 0x2eef415ac409}, {pos = 555861320, events = 8, fd = 731245668, user_data = 0xac6}, {pos = 731218208, events = 8, fd = 555861192, user_data = 0x8215ad408}, {pos = 555861320, events = 8, fd = 731218208, user_data = 0x82121c530}, {pos = 1096447077, events = 12015, fd = 0, user_data = 0x800000000}, {pos = 555861280, events = 8, fd = 731178320, user_data = 0x0}, {pos = 0, events = 0, fd = 555861248, user_data = 0x2eef415ac409}, {pos = 555861464, events = 8, fd = 731245668, user_data = 0xb6c}, {pos = 731218872, events = 8, fd = 555861336, user_data = 0x8215ad408}, {pos = 555861464, events = 8, fd = 731218872, user_data = 0x82121c5c0}, {pos = 1096447077, events = 12015, fd = 559624248, user_data = 0x28d146}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 559600648, user_data = 0x82b94e550}, {pos = 555862184, events = 8, fd = 559600648, user_data = 0x2121c788}, {pos = 31, events = 0, fd = 0, user_data = 0x82121c668}, {pos = 559622088, events = 8, fd = 555862072, user_data = 0x82121c650}, {pos = 1096465827, events = 12015, fd = 559624248, user_data = 0x292dce}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8215b3038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [10:47:52.687] last_touch_time = 1714214716 [10:47:52.687] last_lockfile_recheck_time = 1714214716 [10:47:52.687] nevents = 1 [10:47:52.687] #25 0x000000000085d666 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82121d010) at ../src/backend/postmaster/postmaster.c:1372 [10:47:52.687] userDoption = [10:47:52.687] listen_addr_saved = false [10:47:52.687] output_config_variable = [10:47:52.687] opt = [10:47:52.687] status = [10:47:52.687] #26 0x0000000000795325 in main (argc=4, argv=0x82121d010) at ../src/backend/main/main.c:197 [10:47:52.687] do_check_root =