[17:40:59.455] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [17:40:59.828] dumping /tmp/cores/postgres.7760.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [17:40:59.970] [New LWP 101726] [17:41:00.060] Core was generated by `postgres: postgres regression [local] MERGE'. [17:41:00.060] Program terminated with signal SIGABRT, Aborted. [17:41:00.060] Sent by thr_kill() from pid 7760 and user 1003. [17:41:00.060] #0 0x000000082b42fdca in thr_kill () from /lib/libc.so.7 [17:41:00.603] [17:41:00.603] Thread 1 (LWP 101726): [17:41:00.603] #0 0x000000082b42fdca in thr_kill () from /lib/libc.so.7 [17:41:00.603] No symbol table info available. [17:41:00.603] #1 0x000000082b3a86f4 in raise () from /lib/libc.so.7 [17:41:00.603] No symbol table info available. [17:41:00.603] #2 0x000000082b459bc9 in abort () from /lib/libc.so.7 [17:41:00.603] No symbol table info available. [17:41:00.603] #3 0x0000000000a42a17 in ExceptionalCondition (conditionName=, fileName=0x36f265 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1728) at ../src/backend/utils/error/assert.c:66 [17:41:00.603] No locals. [17:41:00.603] #4 0x000000000072f1b0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82138e790, materialize=, shouldFree=shouldFree@entry=0x82138e656) at ../src/backend/executor/execTuples.c:1728 [17:41:00.603] No locals. [17:41:00.603] #5 0x00000000006f56d8 in ExecIRDeleteTriggers (estate=estate@entry=0x833205100, relinfo=relinfo@entry=0x8332056b0, slot=slot@entry=0x82138e790) at ../src/backend/commands/trigger.c:2841 [17:41:00.603] trigger = [17:41:00.603] oldtuple = [17:41:00.603] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8445b1008, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [17:41:00.603] trigdesc = 0x8332058c0 [17:41:00.603] newtuple = 0x0 [17:41:00.603] i = 0 [17:41:00.603] should_free = false [17:41:00.603] #6 0x0000000000754855 in ExecMergeMatched (context=0x82138e7c0, resultRelInfo=0x8332056b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2991 [17:41:00.603] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [17:41:00.603] relaction = 0x841b9b2d8 [17:41:00.603] commandType = CMD_DELETE [17:41:00.603] result = TM_Ok [17:41:00.603] l__state = {l = 0x841b9b898, i = 0} [17:41:00.603] mtstate = 0x8332054a0 [17:41:00.603] newslot = 0x0 [17:41:00.603] rslot = 0x0 [17:41:00.603] estate = 0x18d5e [17:41:00.603] econtext = 0x841b9a908 [17:41:00.603] epqstate = 0x833205588 [17:41:00.603] l = [17:41:00.603] isNull = [17:41:00.603] __error = [17:41:00.603] l__state = [17:41:00.603] updateCxt = [17:41:00.603] relaction = [17:41:00.603] commandType = [17:41:00.603] result = [17:41:00.603] __error = [17:41:00.603] resultRelationDesc = [17:41:00.603] lockmode = [17:41:00.603] inputslot = [17:41:00.603] epqslot = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] #7 ExecMerge (context=context@entry=0x82138e7c0, resultRelInfo=resultRelInfo@entry=0x8332056b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x82138e790, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2772 [17:41:00.603] matched = [17:41:00.603] rslot = 0x0 [17:41:00.603] #8 0x0000000000753c96 in ExecModifyTable (pstate=0x8332054a0) at ../src/backend/executor/nodeModifyTable.c:4028 [17:41:00.603] context = {mtstate = 0x8332054a0, epqstate = 0x833205588, estate = 0x833205100, planSlot = 0x841b99428, tmfd = {ctid = {ip_blkid = {bi_hi = 10, bi_lo = 0}, ip_posid = 5}, xmax = 857755904, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x0} [17:41:00.603] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [17:41:00.603] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x841b07118} [17:41:00.603] node = 0x8332054a0 [17:41:00.603] estate = 0x833205100 [17:41:00.603] operation = CMD_MERGE [17:41:00.603] resultRelInfo = 0x6 [17:41:00.603] subplanstate = 0x833206df0 [17:41:00.603] tupleid = 0x0 [17:41:00.603] oldtuple = 0x82138e790 [17:41:00.603] slot = [17:41:00.603] oldSlot = [17:41:00.603] #9 0x000000000072924b in ExecProcNodeFirst (node=0x8332054a0) at ../src/backend/executor/execProcnode.c:464 [17:41:00.603] No locals. [17:41:00.603] #10 0x00000000007215fa in ExecProcNode (node=0x8332054a0) at ../src/include/executor/executor.h:274 [17:41:00.603] No locals. [17:41:00.603] #11 ExecutePlan (estate=0x833205100, planstate=0x8332054a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x833113710, execute_once=false) at ../src/backend/executor/execMain.c:1644 [17:41:00.603] current_tuple_count = [17:41:00.603] slot = [17:41:00.603] #12 standard_ExecutorRun (queryDesc=0x8331a8448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [17:41:00.603] estate = 0x833205100 [17:41:00.603] oldcontext = 0x833113400 [17:41:00.603] operation = CMD_MERGE [17:41:00.603] dest = 0x833113710 [17:41:00.603] sendTuples = true [17:41:00.603] #13 0x00000000007214af in ExecutorRun (queryDesc=0x18d5e, queryDesc@entry=0x8331a8448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [17:41:00.603] No locals. [17:41:00.603] #14 0x00000000008f25df in ProcessQuery (plan=0x841bc50d8, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82138e9c8) at ../src/backend/tcop/pquery.c:160 [17:41:00.603] queryDesc = 0x8331a8448 [17:41:00.603] #15 0x00000000008f1b7d in PortalRunMulti (portal=portal@entry=0x8331db100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x833113710, altdest=0xb322e0 , qc=qc@entry=0x82138e9c8) at ../src/backend/tcop/pquery.c:1286 [17:41:00.603] pstmt = 0x841bc50d8 [17:41:00.603] stmtlist_item__state = {l = 0x841bc9940, i = 0} [17:41:00.603] active_snapshot_set = true [17:41:00.603] stmtlist_item = 0x841bc9958 [17:41:00.603] #16 0x00000000008f166c in FillPortalStore (portal=portal@entry=0x8331db100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [17:41:00.603] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:41:00.603] treceiver = 0x833113710 [17:41:00.603] #17 0x00000000008f13c0 in PortalRun (portal=portal@entry=0x8331db100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x841bc9990, altdest=altdest@entry=0x841bc9990, qc=0x82138eb00) at ../src/backend/tcop/pquery.c:763 [17:41:00.603] _local_sigjmp_buf = {{_sjb = {9376607, 35217392792, 34917116408, 34917116640, 34917116416, 12034920, 12002704, 35217322240, 7112098687, 35217330432, 3564064, 34359738368}}} [17:41:00.603] _save_exception_stack = 0x82138ebd0 [17:41:00.603] _save_context_stack = 0x0 [17:41:00.603] _do_rethrow = false [17:41:00.603] saveTopTransactionResourceOwner = 0x8331ec498 [17:41:00.603] saveTopTransactionContext = 0x833111000 [17:41:00.603] saveActivePortal = 0x0 [17:41:00.603] saveResourceOwner = 0x8331ec498 [17:41:00.603] savePortalContext = 0x0 [17:41:00.603] saveMemoryContext = 0x833111000 [17:41:00.603] result = [17:41:00.603] nprocessed = [17:41:00.603] #18 0x00000000008f02cb in exec_simple_query (query_string=query_string@entry=0x833105100 "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 [17:41:00.603] cmdtaglen = [17:41:00.603] snapshot_set = [17:41:00.603] per_parsetree_context = 0x0 [17:41:00.603] plantree_list = [17:41:00.603] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:41:00.603] parsetree = 0x841b683e8 [17:41:00.603] commandTag = CMDTAG_MERGE [17:41:00.603] cmdtagname = [17:41:00.603] querytree_list = [17:41:00.603] portal = 0x8331db100 [17:41:00.603] format = 0 [17:41:00.603] receiver = 0x841bc9990 [17:41:00.603] parsetree_item__state = {l = 0x841b69cb0, i = 0} [17:41:00.603] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [17:41:00.603] dest = DestRemote [17:41:00.603] was_logged = [17:41:00.603] oldcontext = 0x833111000 [17:41:00.603] parsetree_list = 0x841b69cb0 [17:41:00.603] use_implicit_block = false [17:41:00.603] parsetree_item = 0x841b69cc8 [17:41:00.603] save_log_statement_stats = [17:41:00.603] #19 0x00000000008ee0b4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [17:41:00.603] query_string = 0x833105100 "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"... [17:41:00.603] input_message = {data = 0x833105100 "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} [17:41:00.603] firstchar = [17:41:00.603] local_sigjmp_buf = {{_sjb = {9360768, 34917116880, 34917116840, 34917117440, 12043656, 11990128, 8192, 8388608, 72057628954985343, 0, 0, 34359738369}}} [17:41:00.603] send_ready_for_query = false [17:41:00.603] idle_in_transaction_timeout_enabled = false [17:41:00.603] idle_session_timeout_enabled = false [17:41:00.603] #20 0x00000000008e8e19 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [17:41:00.603] bsdata = [17:41:00.603] #21 0x0000000000845d72 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82138f910 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82138f858) at ../src/backend/postmaster/launch_backend.c:265 [17:41:00.603] pid = [17:41:00.603] #22 0x000000000084a591 in BackendStartup (client_sock=0x82138f858) at ../src/backend/postmaster/postmaster.c:3593 [17:41:00.603] startup_data = {canAcceptConnections = CAC_OK} [17:41:00.603] bn = 0x833111498 [17:41:00.603] pid = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] save_errno = [17:41:00.603] __error = [17:41:00.603] __error = [17:41:00.603] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [17:41:00.603] 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' , "\260\3708!\b\000\000\000ص\331)\b\000\000\000\v\000\000\000\000\000\000\000\0166\332)\b", '\000' , "\360\3708!\b\000\000\000D[\204\000\000\000\000\000\000\3718!\b", '\000' }, salen = 16}} [17:41:00.603] i = 0 [17:41:00.603] now = [17:41:00.603] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 724667492, events = 8, fd = 557379232, user_data = 0x82138f030}, {pos = 567927816, events = 8, fd = 32, user_data = 0x82138f020}, {pos = -1545332076, events = 2652, fd = 567898120, user_data = 0x821d97408}, {pos = 567900168, events = 8, fd = 567901192, user_data = 0x821d9b008}, {pos = 567915528, events = 8, fd = 567916552, user_data = 0x821d9bc08}, {pos = 567918600, events = 8, fd = 567919624, user_data = 0x821d9c808}, {pos = 567921672, events = 8, fd = 567922696, user_data = 0x821d9d408}, {pos = 567924744, events = 8, fd = 567925768, user_data = 0x821d9e008}, {pos = 567927816, events = 8, fd = -1, user_data = 0x82b4f02e0}, {pos = 557379472, events = 8, fd = 726258089, user_data = 0x0}, {pos = 4096, events = 0, fd = -1204416917, user_data = 0x82b4f07e8}, {pos = 851483616, events = 8, fd = 160, user_data = 0x0}, {pos = 823214224, events = 8, fd = 557379680, user_data = 0x82b47b92c}, {pos = 4096, events = 0, fd = 724683108, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 567953976, user_data = 0x800000001}, {pos = 567927816, events = 8, fd = 724596952, user_data = 0x82138f0e8}, {pos = 557379232, events = 8, fd = 32, user_data = 0x82b318c64}, {pos = 567927816, events = 8, fd = 567953976, user_data = 0x0}, {pos = 2625, events = 0, fd = 557379792, user_data = 0xa5ca3e41645}, {pos = 724683108, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 567953976, events = 8, fd = 1, user_data = 0x821d9e408}, {pos = 856641536, events = 8, fd = 1, user_data = 0x8330f5194}, {pos = 0, events = 0, fd = 557379744, user_data = 0x829da2c0c}, {pos = 1, events = 0, fd = 856641536, user_data = 0x82138f0d0}, {pos = 702160564, events = 8, fd = 726409568, user_data = 0x82b4c2160 }, {pos = 724779200, events = 8, fd = 567927816, user_data = 0x82138f1b0}, {pos = -1545333716, events = 2652, fd = 823214224, user_data = 0x800000001}, {pos = -1545334098, events = 2652, fd = 12240, user_data = 0x82138f0d8}, {pos = 557380016, events = 8, fd = 857348072, user_data = 0x82138f720}, {pos = -1545253232, events = 2652, fd = 567927816, user_data = 0x82138037f}, {pos = 726066588, events = 8, fd = 567898120, user_data = 0x0}, {pos = 567927816, events = 8, fd = 12240, user_data = 0x82b2f8000}, {pos = 1964368, events = 0, fd = 726409568, user_data = 0x82b318c64}, {pos = 15616, events = 0, fd = 557381200, user_data = 0x82138f220}, {pos = 725340558, events = 8, fd = 726448184, user_data = 0x82138f1e4}, {pos = 857085402, events = 8, fd = 557381200, user_data = 0x82138f220}, {pos = 725431813, events = 8, fd = 557380066, user_data = 0x82138f650}, {pos = 557381200, events = 8, fd = 0, user_data = 0x264a198db8360e6b}, {pos = 557381200, events = 8, fd = 857085400, user_data = 0x82138f720}, {pos = 726448184, events = 8, fd = 0, user_data = 0x82138f690}, {pos = 725432077, events = 8, fd = 0, user_data = 0x0}, {pos = 557381568, events = 8, fd = 857085400, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1545305079, events = 2652, fd = 557380472, user_data = 0x82b318c64}, {pos = 2503, events = 0, fd = -1545305079, user_data = 0x82138f398}, {pos = 724667492, events = 8, fd = 2758, user_data = 0x82b312120}, {pos = 557380376, events = 8, fd = 567927816, user_data = 0x82138f398}, {pos = 724640032, events = 8, fd = 557380480, user_data = 0xa5ca3e43465}, {pos = 0, events = 0, fd = 0, user_data = 0x82b4e40f0}, {pos = 724600144, events = 8, fd = 0, user_data = 0x0}, {pos = 726477232, events = 8, fd = -1545305079, user_data = 0x82138f428}, {pos = 724667492, events = 8, fd = 2924, user_data = 0x82b3123b8}, {pos = 557380520, events = 8, fd = 567927816, user_data = 0x82138f428}, {pos = 724640696, events = 8, fd = 557380624, user_data = 0xa5ca3e43465}, {pos = 567951416, events = 8, fd = 2670842, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567927816, events = 8, fd = 724600144, user_data = 0x82138f6e8}, {pos = 567927816, events = 8, fd = 557381064, user_data = 0x1e}, {pos = 724604128, events = 8, fd = 557380792, user_data = 0x821da3248}, {pos = 557381240, events = 8, fd = 557380768, user_data = 0xa5ca3e47da3}, {pos = 567951416, events = 8, fd = 2694224, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 567951416, user_data = 0x1}} [17:41:00.603] last_touch_time = 1711301892 [17:41:00.603] last_lockfile_recheck_time = 1711301892 [17:41:00.603] nevents = 1 [17:41:00.603] #24 0x0000000000847e66 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82138fe58) at ../src/backend/postmaster/postmaster.c:1372 [17:41:00.603] userDoption = [17:41:00.603] listen_addr_saved = false [17:41:00.603] output_config_variable = [17:41:00.603] opt = [17:41:00.603] status = [17:41:00.603] #25 0x0000000000784195 in main (argc=8, argv=0x82138fe58) at ../src/backend/main/main.c:197 [17:41:00.603] do_check_root = [17:41:00.614] [17:41:00.614] [17:41:00.614] [17:41:00.676] dumping /tmp/cores/postgres.8398.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [17:41:00.802] [New LWP 101636] [17:41:00.866] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [17:41:00.866] Program terminated with signal SIGABRT, Aborted. [17:41:00.866] Sent by thr_kill() from pid 8398 and user 1003. [17:41:00.866] #0 0x000000082a413dca in thr_kill () from /lib/libc.so.7 [17:41:01.405] [17:41:01.405] Thread 1 (LWP 101636): [17:41:01.405] #0 0x000000082a413dca in thr_kill () from /lib/libc.so.7 [17:41:01.405] No symbol table info available. [17:41:01.405] #1 0x000000082a38c6f4 in raise () from /lib/libc.so.7 [17:41:01.405] No symbol table info available. [17:41:01.405] #2 0x000000082a43dbc9 in abort () from /lib/libc.so.7 [17:41:01.405] No symbol table info available. [17:41:01.405] #3 0x0000000000a42a17 in ExceptionalCondition (conditionName=, fileName=0x36f265 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1728) at ../src/backend/utils/error/assert.c:66 [17:41:01.405] No locals. [17:41:01.405] #4 0x000000000072f1b0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8215b3e90, materialize=, shouldFree=shouldFree@entry=0x8215b3d56) at ../src/backend/executor/execTuples.c:1728 [17:41:01.405] No locals. [17:41:01.405] #5 0x00000000006f56d8 in ExecIRDeleteTriggers (estate=estate@entry=0x834804100, relinfo=relinfo@entry=0x8348046b0, slot=slot@entry=0x8215b3e90) at ../src/backend/commands/trigger.c:2841 [17:41:01.405] trigger = [17:41:01.405] oldtuple = [17:41:01.405] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83fcfa8b0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [17:41:01.405] trigdesc = 0x8348048c0 [17:41:01.405] newtuple = 0x0 [17:41:01.405] i = 0 [17:41:01.405] should_free = false [17:41:01.405] #6 0x0000000000754855 in ExecMergeMatched (context=0x8215b3ec0, resultRelInfo=0x8348046b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2991 [17:41:01.405] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [17:41:01.405] relaction = 0x83fdf5258 [17:41:01.405] commandType = CMD_DELETE [17:41:01.405] result = TM_Ok [17:41:01.405] l__state = {l = 0x83fdf5818, i = 0} [17:41:01.405] mtstate = 0x8348044a0 [17:41:01.405] newslot = 0x0 [17:41:01.405] rslot = 0x0 [17:41:01.405] estate = 0x18d04 [17:41:01.405] econtext = 0x83fdf4888 [17:41:01.405] epqstate = 0x834804588 [17:41:01.405] l = [17:41:01.405] isNull = [17:41:01.405] __error = [17:41:01.405] l__state = [17:41:01.405] updateCxt = [17:41:01.405] relaction = [17:41:01.405] commandType = [17:41:01.405] result = [17:41:01.405] __error = [17:41:01.405] resultRelationDesc = [17:41:01.405] lockmode = [17:41:01.405] inputslot = [17:41:01.405] epqslot = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] #7 ExecMerge (context=context@entry=0x8215b3ec0, resultRelInfo=resultRelInfo@entry=0x8348046b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x8215b3e90, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2772 [17:41:01.405] matched = [17:41:01.405] rslot = 0x0 [17:41:01.405] #8 0x0000000000753c96 in ExecModifyTable (pstate=0x8348044a0) at ../src/backend/executor/nodeModifyTable.c:4028 [17:41:01.405] context = {mtstate = 0x8348044a0, epqstate = 0x834804588, estate = 0x834804100, planSlot = 0x83fdf33a8, tmfd = {ctid = {ip_blkid = {bi_hi = 10, bi_lo = 0}, ip_posid = 5}, xmax = 880820480, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x0} [17:41:01.405] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [17:41:01.405] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83481c118} [17:41:01.405] node = 0x8348044a0 [17:41:01.405] estate = 0x834804100 [17:41:01.405] operation = CMD_MERGE [17:41:01.405] resultRelInfo = 0x6 [17:41:01.405] subplanstate = 0x834805df0 [17:41:01.405] tupleid = 0x0 [17:41:01.405] oldtuple = 0x8215b3e90 [17:41:01.405] slot = [17:41:01.405] oldSlot = [17:41:01.405] #9 0x000000000072924b in ExecProcNodeFirst (node=0x8348044a0) at ../src/backend/executor/execProcnode.c:464 [17:41:01.405] No locals. [17:41:01.405] #10 0x00000000007215fa in ExecProcNode (node=0x8348044a0) at ../src/include/executor/executor.h:274 [17:41:01.405] No locals. [17:41:01.405] #11 ExecutePlan (estate=0x834804100, planstate=0x8348044a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83469d310, execute_once=false) at ../src/backend/executor/execMain.c:1644 [17:41:01.405] current_tuple_count = [17:41:01.405] slot = [17:41:01.405] #12 standard_ExecutorRun (queryDesc=0x83471f448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [17:41:01.405] estate = 0x834804100 [17:41:01.405] oldcontext = 0x83469d000 [17:41:01.405] operation = CMD_MERGE [17:41:01.405] dest = 0x83469d310 [17:41:01.405] sendTuples = true [17:41:01.405] #13 0x00000000007214af in ExecutorRun (queryDesc=0x18d04, queryDesc@entry=0x83471f448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [17:41:01.405] No locals. [17:41:01.405] #14 0x00000000008f25df in ProcessQuery (plan=0x83fe20558, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8215b40c8) at ../src/backend/tcop/pquery.c:160 [17:41:01.405] queryDesc = 0x83471f448 [17:41:01.405] #15 0x00000000008f1b7d in PortalRunMulti (portal=portal@entry=0x8346ff100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83469d310, altdest=0xb322e0 , qc=qc@entry=0x8215b40c8) at ../src/backend/tcop/pquery.c:1286 [17:41:01.405] pstmt = 0x83fe20558 [17:41:01.405] stmtlist_item__state = {l = 0x83fe24dc0, i = 0} [17:41:01.405] active_snapshot_set = true [17:41:01.405] stmtlist_item = 0x83fe24dd8 [17:41:01.405] #16 0x00000000008f166c in FillPortalStore (portal=portal@entry=0x8346ff100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [17:41:01.405] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:41:01.405] treceiver = 0x83469d310 [17:41:01.405] #17 0x00000000008f13c0 in PortalRun (portal=portal@entry=0x8346ff100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83fe24e10, altdest=altdest@entry=0x83fe24e10, qc=0x8215b4200) at ../src/backend/tcop/pquery.c:763 [17:41:01.405] _local_sigjmp_buf = {{_sjb = {9376607, 35239826648, 34919366904, 34919367136, 34919366912, 12034920, 12002704, 35239489792, 7112098687, 35239497984, 3564064, 34359738368}}} [17:41:01.405] _save_exception_stack = 0x8215b42d0 [17:41:01.405] _save_context_stack = 0x0 [17:41:01.405] _do_rethrow = false [17:41:01.405] saveTopTransactionResourceOwner = 0x8347514d8 [17:41:01.405] saveTopTransactionContext = 0x834672000 [17:41:01.405] saveActivePortal = 0x0 [17:41:01.405] saveResourceOwner = 0x8347514d8 [17:41:01.405] savePortalContext = 0x0 [17:41:01.405] saveMemoryContext = 0x834672000 [17:41:01.405] result = [17:41:01.405] nprocessed = [17:41:01.405] #18 0x00000000008f02cb in exec_simple_query (query_string=query_string@entry=0x834666100 "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 [17:41:01.405] cmdtaglen = [17:41:01.405] snapshot_set = [17:41:01.405] per_parsetree_context = 0x0 [17:41:01.405] plantree_list = [17:41:01.405] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:41:01.405] parsetree = 0x83fdc24a8 [17:41:01.405] commandTag = CMDTAG_MERGE [17:41:01.405] cmdtagname = [17:41:01.405] querytree_list = [17:41:01.405] portal = 0x8346ff100 [17:41:01.405] format = 0 [17:41:01.405] receiver = 0x83fe24e10 [17:41:01.405] parsetree_item__state = {l = 0x83fdc3d70, i = 0} [17:41:01.405] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [17:41:01.405] dest = DestRemote [17:41:01.405] was_logged = [17:41:01.405] oldcontext = 0x834672000 [17:41:01.405] parsetree_list = 0x83fdc3d70 [17:41:01.405] use_implicit_block = false [17:41:01.405] parsetree_item = 0x83fdc3d88 [17:41:01.405] save_log_statement_stats = [17:41:01.405] #19 0x00000000008ee0b4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [17:41:01.405] query_string = 0x834666100 "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"... [17:41:01.405] input_message = {data = 0x834666100 "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} [17:41:01.405] firstchar = [17:41:01.405] local_sigjmp_buf = {{_sjb = {9360768, 34919367376, 34919367336, 34919367936, 12043656, 11990128, 8192, 8388608, 72057628957279103, 0, 0, 34359738369}}} [17:41:01.405] send_ready_for_query = false [17:41:01.405] idle_in_transaction_timeout_enabled = false [17:41:01.405] idle_session_timeout_enabled = false [17:41:01.405] #20 0x00000000008e8e19 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [17:41:01.405] bsdata = [17:41:01.405] #21 0x0000000000845d72 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8215b5010 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215b4f58) at ../src/backend/postmaster/launch_backend.c:265 [17:41:01.405] pid = [17:41:01.405] #22 0x000000000084a591 in BackendStartup (client_sock=0x8215b4f58) at ../src/backend/postmaster/postmaster.c:3593 [17:41:01.405] startup_data = {canAcceptConnections = CAC_OK} [17:41:01.405] bn = 0x8346723f8 [17:41:01.405] pid = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] save_errno = [17:41:01.405] __error = [17:41:01.405] __error = [17:41:01.405] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [17:41:01.405] 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' , "\260O[!\b\000\000\000\330u\235(\b\000\000\000\v\000\000\000\000\000\000\000\016\366\235(\b", '\000' , "\360O[!\b\000\000\000D[\204\000\000\000\000\000\000P[!\b", '\000' }, salen = 16}} [17:41:01.405] i = 0 [17:41:01.405] now = [17:41:01.405] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 707775588, events = 8, fd = 559629728, user_data = 0x8215b4730}, {pos = 573875208, events = 8, fd = 32, user_data = 0x8215b4720}, {pos = 893549204, events = 4159, fd = 573845512, user_data = 0x822343408}, {pos = 573847560, events = 8, fd = 573848584, user_data = 0x822347008}, {pos = 573862920, events = 8, fd = 573863944, user_data = 0x822347c08}, {pos = 573865992, events = 8, fd = 573867016, user_data = 0x822348808}, {pos = 573869064, events = 8, fd = 573870088, user_data = 0x822349408}, {pos = 573872136, events = 8, fd = 573873160, user_data = 0x82234a008}, {pos = 573875208, events = 8, fd = 573894792, user_data = 0x8215b48a8}, {pos = 559630032, events = 8, fd = 893574563, user_data = 0x0}, {pos = 2567718, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 573898808, events = 8, fd = 1, user_data = 0x82234a408}, {pos = 707683496, events = 8, fd = 559630760, user_data = 0x82234a408}, {pos = 559630016, events = 0, fd = 707791204, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 573901368, user_data = 0x1}, {pos = 573875208, events = 8, fd = 707705048, user_data = 0x8215b47e8}, {pos = 559629728, events = 8, fd = 32, user_data = 0x82a2fcc64}, {pos = 573875208, events = 8, fd = 573901368, user_data = 0x0}, {pos = 2625, events = 0, fd = 559630288, user_data = 0x103f35427645}, {pos = 707791204, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 573901368, events = 8, fd = 1, user_data = 0x82234a408}, {pos = 879058944, events = 8, fd = 1, user_data = 0x834656194}, {pos = 0, events = 0, fd = 559630240, user_data = 0x8289dec0c}, {pos = 1, events = 0, fd = 879058944, user_data = 0x8215b47d0}, {pos = 681434804, events = 8, fd = 709517664, user_data = 0x82a4a6160 }, {pos = 707887296, events = 8, fd = 573875208, user_data = 0x8215b48b0}, {pos = 893547564, events = 4159, fd = 573874184, user_data = 0x800000001}, {pos = 893547182, events = 4159, fd = 12240, user_data = 0x8215b47d8}, {pos = 559630512, events = 8, fd = 879855592, user_data = 0x8215b4e20}, {pos = 893628048, events = 4159, fd = 573875208, user_data = 0x8215b037f}, {pos = 709174450, events = 8, fd = 573845512, user_data = 0x0}, {pos = 573875208, events = 8, fd = 12240, user_data = 0x82a2dc000}, {pos = 1964368, events = 0, fd = 709517664, user_data = 0x82a2fcc64}, {pos = 15616, events = 0, fd = 559631696, user_data = 0x8215b4920}, {pos = 708448654, events = 8, fd = 709556280, user_data = 0x8215b48e4}, {pos = 879511002, events = 8, fd = 559631696, user_data = 0x8215b4920}, {pos = 708539909, events = 8, fd = 559630562, user_data = 0x8215b4d50}, {pos = 559631696, events = 8, fd = 0, user_data = 0x786415b4b823ec55}, {pos = 559631696, events = 8, fd = 879511000, user_data = 0x8215b4e20}, {pos = 709556280, events = 8, fd = 0, user_data = 0x8215b4d90}, {pos = 708540173, events = 8, fd = 0, user_data = 0x0}, {pos = 559632064, events = 8, fd = 879511000, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 893576201, events = 4159, fd = 559630968, user_data = 0x82a2fcc64}, {pos = 2503, events = 0, fd = 893576201, user_data = 0x8215b4a98}, {pos = 707775588, events = 8, fd = 2758, user_data = 0x82a2f6120}, {pos = 559630872, events = 8, fd = 573875208, user_data = 0x8215b4a98}, {pos = 707748128, events = 8, fd = 559630976, user_data = 0x103f35429465}, {pos = 0, events = 0, fd = 0, user_data = 0x82a4c80f0}, {pos = 707708240, events = 8, fd = 0, user_data = 0x0}, {pos = 709585328, events = 8, fd = 893576201, user_data = 0x8215b4b28}, {pos = 707775588, events = 8, fd = 2924, user_data = 0x82a2f63b8}, {pos = 559631016, events = 8, fd = 573875208, user_data = 0x8215b4b28}, {pos = 707748792, events = 8, fd = 559631120, user_data = 0x103f35429465}, {pos = 573898808, events = 8, fd = 2670842, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 573875208, events = 8, fd = 707708240, user_data = 0x8215b4de8}, {pos = 573875208, events = 8, fd = 559631560, user_data = 0x1e}, {pos = 707712224, events = 8, fd = 559631288, user_data = 0x82234f248}, {pos = 559631736, events = 8, fd = 559631264, user_data = 0x103f3542dda3}, {pos = 573898808, events = 8, fd = 2694224, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 573898808, user_data = 0x1}} [17:41:01.405] last_touch_time = 1711301893 [17:41:01.405] last_lockfile_recheck_time = 1711301893 [17:41:01.405] nevents = 1 [17:41:01.405] #24 0x0000000000847e66 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8215b5558) at ../src/backend/postmaster/postmaster.c:1372 [17:41:01.405] userDoption = [17:41:01.405] listen_addr_saved = false [17:41:01.405] output_config_variable = [17:41:01.405] opt = [17:41:01.405] status = [17:41:01.405] #25 0x0000000000784195 in main (argc=4, argv=0x8215b5558) at ../src/backend/main/main.c:197 [17:41:01.405] do_check_root = [17:41:01.416] [17:41:01.416] [17:41:01.416] [17:41:01.482] dumping /tmp/cores/postgres.13445.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [17:41:01.613] [New LWP 101641] [17:41:01.680] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [17:41:01.680] Program terminated with signal SIGABRT, Aborted. [17:41:01.680] Sent by thr_kill() from pid 13445 and user 1003. [17:41:01.680] #0 0x000000082d532dca in thr_kill () from /lib/libc.so.7 [17:41:02.223] [17:41:02.223] Thread 1 (LWP 101641): [17:41:02.223] #0 0x000000082d532dca in thr_kill () from /lib/libc.so.7 [17:41:02.223] No symbol table info available. [17:41:02.223] #1 0x000000082d4ab6f4 in raise () from /lib/libc.so.7 [17:41:02.223] No symbol table info available. [17:41:02.223] #2 0x000000082d55cbc9 in abort () from /lib/libc.so.7 [17:41:02.223] No symbol table info available. [17:41:02.223] #3 0x0000000000a42a17 in ExceptionalCondition (conditionName=, fileName=0x36f265 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1728) at ../src/backend/utils/error/assert.c:66 [17:41:02.223] No locals. [17:41:02.223] #4 0x000000000072f1b0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820b852b0, materialize=, shouldFree=shouldFree@entry=0x820b85176) at ../src/backend/executor/execTuples.c:1728 [17:41:02.223] No locals. [17:41:02.223] #5 0x00000000006f56d8 in ExecIRDeleteTriggers (estate=estate@entry=0x838b5c100, relinfo=relinfo@entry=0x838b5c6b0, slot=slot@entry=0x820b852b0) at ../src/backend/commands/trigger.c:2841 [17:41:02.223] trigger = [17:41:02.223] oldtuple = [17:41:02.223] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83c10ed20, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [17:41:02.223] trigdesc = 0x838b5c8c0 [17:41:02.223] newtuple = 0x0 [17:41:02.223] i = 0 [17:41:02.223] should_free = false [17:41:02.223] #6 0x0000000000754855 in ExecMergeMatched (context=0x820b852e0, resultRelInfo=0x838b5c6b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2991 [17:41:02.223] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [17:41:02.223] relaction = 0x83c254d98 [17:41:02.223] commandType = CMD_DELETE [17:41:02.223] result = TM_Ok [17:41:02.223] l__state = {l = 0x83c255358, i = 0} [17:41:02.223] mtstate = 0x838b5c4a0 [17:41:02.223] newslot = 0x0 [17:41:02.223] rslot = 0x0 [17:41:02.223] estate = 0x18d09 [17:41:02.223] econtext = 0x83c2543c8 [17:41:02.223] epqstate = 0x838b5c588 [17:41:02.223] l = [17:41:02.223] isNull = [17:41:02.223] __error = [17:41:02.223] l__state = [17:41:02.223] updateCxt = [17:41:02.223] relaction = [17:41:02.223] commandType = [17:41:02.223] result = [17:41:02.223] __error = [17:41:02.223] resultRelationDesc = [17:41:02.223] lockmode = [17:41:02.223] inputslot = [17:41:02.223] epqslot = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] #7 ExecMerge (context=context@entry=0x820b852e0, resultRelInfo=resultRelInfo@entry=0x838b5c6b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820b852b0, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2772 [17:41:02.223] matched = [17:41:02.223] rslot = 0x0 [17:41:02.223] #8 0x0000000000753c96 in ExecModifyTable (pstate=0x838b5c4a0) at ../src/backend/executor/nodeModifyTable.c:4028 [17:41:02.223] context = {mtstate = 0x838b5c4a0, epqstate = 0x838b5c588, estate = 0x838b5c100, planSlot = 0x83c252ee8, tmfd = {ctid = {ip_blkid = {bi_hi = 21312, bi_lo = 8376}, ip_posid = 8}, xmax = 760411870, cmax = 8, traversed = 104}, cpUpdateReturningSlot = 0x4632b4eb56e993fe} [17:41:02.223] tuple_ctid = {ip_blkid = {bi_hi = 28683, bi_lo = 36395}, ip_posid = 24308} [17:41:02.223] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x838b68118} [17:41:02.223] node = 0x838b5c4a0 [17:41:02.223] estate = 0x838b5c100 [17:41:02.223] operation = CMD_MERGE [17:41:02.223] resultRelInfo = 0x6 [17:41:02.223] subplanstate = 0x838b5ddf0 [17:41:02.223] tupleid = 0x0 [17:41:02.223] oldtuple = 0x820b852b0 [17:41:02.223] slot = [17:41:02.223] oldSlot = [17:41:02.223] #9 0x000000000072924b in ExecProcNodeFirst (node=0x838b5c4a0) at ../src/backend/executor/execProcnode.c:464 [17:41:02.223] No locals. [17:41:02.223] #10 0x00000000007215fa in ExecProcNode (node=0x838b5c4a0) at ../src/include/executor/executor.h:274 [17:41:02.223] No locals. [17:41:02.223] #11 ExecutePlan (estate=0x838b5c100, planstate=0x838b5c4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x838a9a310, execute_once=false) at ../src/backend/executor/execMain.c:1644 [17:41:02.223] current_tuple_count = [17:41:02.223] slot = [17:41:02.223] #12 standard_ExecutorRun (queryDesc=0x838a57448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [17:41:02.223] estate = 0x838b5c100 [17:41:02.223] oldcontext = 0x838a9a000 [17:41:02.223] operation = CMD_MERGE [17:41:02.223] dest = 0x838a9a310 [17:41:02.223] sendTuples = true [17:41:02.223] #13 0x000000083b56f963 in pgss_ExecutorRun (queryDesc=0x838a57448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [17:41:02.223] _local_sigjmp_buf = {{_sjb = {35355294002, 12034920, 34908689416, 34908689584, 35310105672, 34908689424, 1, 1, 35311125375, 35310105672, 12043648, 34359738368}}} [17:41:02.223] _save_exception_stack = 0x820b855d0 [17:41:02.223] _save_context_stack = 0x0 [17:41:02.223] _do_rethrow = false [17:41:02.223] #14 0x00000000007214a8 in ExecutorRun (queryDesc=0x18d09, queryDesc@entry=0x838a57448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [17:41:02.223] No locals. [17:41:02.223] #15 0x00000000008f25df in ProcessQuery (plan=0x83c217cc8, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820b85598) at ../src/backend/tcop/pquery.c:160 [17:41:02.223] queryDesc = 0x838a57448 [17:41:02.223] #16 0x00000000008f1b7d in PortalRunMulti (portal=portal@entry=0x838a39100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x838a9a310, altdest=0xb322e0 , qc=qc@entry=0x820b85598) at ../src/backend/tcop/pquery.c:1286 [17:41:02.223] pstmt = 0x83c217cc8 [17:41:02.223] stmtlist_item__state = {l = 0x83c21c530, i = 0} [17:41:02.223] active_snapshot_set = true [17:41:02.223] stmtlist_item = 0x83c21c548 [17:41:02.223] #17 0x00000000008f166c in FillPortalStore (portal=portal@entry=0x838a39100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [17:41:02.223] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:41:02.223] treceiver = 0x838a9a310 [17:41:02.223] #18 0x00000000008f13c0 in PortalRun (portal=portal@entry=0x838a39100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83c21c580, altdest=altdest@entry=0x83c21c580, qc=0x820b856d0) at ../src/backend/tcop/pquery.c:763 [17:41:02.223] _local_sigjmp_buf = {{_sjb = {9376607, 35310317528, 34908689864, 34908690096, 34908689872, 12034920, 12002704, 35309981952, 7112098687, 35309990144, 3564064, 34359738368}}} [17:41:02.223] _save_exception_stack = 0x820b857a0 [17:41:02.223] _save_context_stack = 0x0 [17:41:02.223] _do_rethrow = false [17:41:02.223] saveTopTransactionResourceOwner = 0x838a8afd8 [17:41:02.223] saveTopTransactionContext = 0x8389aa000 [17:41:02.223] saveActivePortal = 0x0 [17:41:02.223] saveResourceOwner = 0x838a8afd8 [17:41:02.223] savePortalContext = 0x0 [17:41:02.223] saveMemoryContext = 0x8389aa000 [17:41:02.223] result = [17:41:02.223] nprocessed = [17:41:02.223] #19 0x00000000008f02cb in exec_simple_query (query_string=query_string@entry=0x83899e100 "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 [17:41:02.223] cmdtaglen = [17:41:02.223] snapshot_set = [17:41:02.223] per_parsetree_context = 0x0 [17:41:02.223] plantree_list = [17:41:02.223] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [17:41:02.223] parsetree = 0x83c1f46e8 [17:41:02.223] commandTag = CMDTAG_MERGE [17:41:02.223] cmdtagname = [17:41:02.223] querytree_list = [17:41:02.223] portal = 0x838a39100 [17:41:02.223] format = 0 [17:41:02.223] receiver = 0x83c21c580 [17:41:02.223] parsetree_item__state = {l = 0x83c1f5fb0, i = 0} [17:41:02.223] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [17:41:02.223] dest = DestRemote [17:41:02.223] was_logged = [17:41:02.223] oldcontext = 0x8389aa000 [17:41:02.223] parsetree_list = 0x83c1f5fb0 [17:41:02.223] use_implicit_block = false [17:41:02.223] parsetree_item = 0x83c1f5fc8 [17:41:02.223] save_log_statement_stats = [17:41:02.223] #20 0x00000000008ee0b4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [17:41:02.223] query_string = 0x83899e100 "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"... [17:41:02.223] input_message = {data = 0x83899e100 "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} [17:41:02.223] firstchar = [17:41:02.223] local_sigjmp_buf = {{_sjb = {9360768, 34908690336, 34908690296, 34908690896, 12043656, 11990128, 8192, 8388608, 72057628946596735, 0, 0, 1}}} [17:41:02.223] send_ready_for_query = false [17:41:02.223] idle_in_transaction_timeout_enabled = false [17:41:02.223] idle_session_timeout_enabled = false [17:41:02.223] #21 0x00000000008e8e19 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [17:41:02.223] bsdata = [17:41:02.223] #22 0x0000000000845d72 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820b864e0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820b86428) at ../src/backend/postmaster/launch_backend.c:265 [17:41:02.223] pid = [17:41:02.223] #23 0x000000000084a591 in BackendStartup (client_sock=0x820b86428) at ../src/backend/postmaster/postmaster.c:3593 [17:41:02.223] startup_data = {canAcceptConnections = CAC_OK} [17:41:02.223] bn = 0x8389aa4e8 [17:41:02.223] pid = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] save_errno = [17:41:02.223] __error = [17:41:02.223] __error = [17:41:02.223] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [17:41:02.223] 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' , "\200d\270 \b\000\000\000\330\305\333,\b\000\000\000\v\000\000\000\000\000\000\000\016F\334,\b", '\000' , "\300d\270 \b\000\000\000D[\204\000\000\000\000\000\320d\270 \b", '\000' }, salen = 16}} [17:41:02.223] i = 0 [17:41:02.223] now = [17:41:02.223] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 548953088, events = 8, fd = 556012552, user_data = 0x21}, {pos = 548953072, events = 8, fd = -264115564, user_data = 0x82123a008}, {pos = 555983880, events = 8, fd = 555984904, user_data = 0x82123ac08}, {pos = 555999240, events = 8, fd = 556000264, user_data = 0x82123e808}, {pos = 556002312, events = 8, fd = 556003336, user_data = 0x82123f408}, {pos = 556005384, events = 8, fd = 556006408, user_data = 0x821240008}, {pos = 556008456, events = 8, fd = 556009480, user_data = 0x821240c08}, {pos = 556011528, events = 8, fd = 556012552, user_data = 0x821246088}, {pos = 548953464, events = 8, fd = 548952976, user_data = 0xa98f0424da3}, {pos = 556012552, events = 8, fd = 2567718, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 556036152, user_data = 0x1}, {pos = 556012552, events = 8, fd = 759190696, user_data = 0x820b85e78}, {pos = 556012552, events = 8, fd = 548952944, user_data = 0x272d70}, {pos = 548953536, events = 8, fd = 759298404, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 556038712, user_data = 0xa9800000001}, {pos = 556012552, events = 8, fd = 759212248, user_data = 0x820b85cb8}, {pos = 548952672, events = 8, fd = 33, user_data = 0x82d41bc64}, {pos = 556012552, events = 8, fd = 556038712, user_data = 0x0}, {pos = 2625, events = 0, fd = 548953248, user_data = 0xa98f041e645}, {pos = 759298404, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 556038712, events = 8, fd = 1, user_data = 0x821241408}, {pos = 949542912, events = 8, fd = 1, user_data = 0x83898e194}, {pos = 0, events = 0, fd = 548953200, user_data = 0x82cdc3c0c}, {pos = 1, events = 0, fd = 949542912, user_data = 0x820b85ca0}, {pos = 752627380, events = 8, fd = 761024864, user_data = 0x82d5c5160 }, {pos = 759394496, events = 8, fd = 556012552, user_data = 0x820b85d80}, {pos = -264117204, events = 2712, fd = 80627796, user_data = 0x1}, {pos = -264117586, events = 2712, fd = 12240, user_data = 0x820b85ca8}, {pos = 548953472, events = 8, fd = 950339560, user_data = 0x820b862f0}, {pos = -264036720, events = 2712, fd = 556012552, user_data = 0x820b8037f}, {pos = 760681650, events = 8, fd = 548953776, user_data = 0xa9800000000}, {pos = 556012552, events = 8, fd = 12240, user_data = 0x82d3fb000}, {pos = 1964368, events = 0, fd = 761024864, user_data = 0x82d41bc64}, {pos = 15616, events = 0, fd = 548954656, user_data = 0x820b85df0}, {pos = 759955854, events = 8, fd = 761063480, user_data = 0x820b85db4}, {pos = 949994970, events = 8, fd = 548954656, user_data = 0x820b85df0}, {pos = 760047109, events = 8, fd = 548953522, user_data = 0x820b86220}, {pos = 548954656, events = 8, fd = 0, user_data = 0x31c05ef48e2b700b}, {pos = 548954656, events = 8, fd = 949994968, user_data = 0x820b862f0}, {pos = 761063480, events = 8, fd = 0, user_data = 0x820b86260}, {pos = 760047373, events = 8, fd = 0, user_data = 0x0}, {pos = 548955024, events = 8, fd = 949994968, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -264088567, user_data = 0x820b85f38}, {pos = 759282788, events = 8, fd = 2503, user_data = 0xa98f0425409}, {pos = 548953944, events = 8, fd = 759282788, user_data = 0xac6}, {pos = 759255328, events = 8, fd = 548953816, user_data = 0x821241408}, {pos = 548953944, events = 8, fd = 759255328, user_data = 0x820b85f40}, {pos = -264108955, events = 2712, fd = 0, user_data = 0x800000000}, {pos = 548953904, events = 8, fd = 759215440, user_data = 0x0}, {pos = 0, events = 0, fd = 548953872, user_data = 0xa98f0425409}, {pos = 548954088, events = 8, fd = 759282788, user_data = 0xb6c}, {pos = 759255992, events = 8, fd = 548953960, user_data = 0x821241408}, {pos = 548954088, events = 8, fd = 759255992, user_data = 0x820b85fd0}, {pos = -264108955, events = 2712, fd = 556036152, user_data = 0x28c0fa}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 556012552, user_data = 0x82d40b550}, {pos = 548954808, events = 8, fd = 556012552, user_data = 0x20b86198}, {pos = 31, events = 0, fd = 0, user_data = 0x820b86078}, {pos = 556033928, events = 8, fd = 548954696, user_data = 0x820b86060}, {pos = -264090205, events = 2712, fd = 556036152, user_data = 0x291c50}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821247038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [17:41:02.224] last_touch_time = 1711301914 [17:41:02.224] last_lockfile_recheck_time = 1711301914 [17:41:02.224] nevents = 1 [17:41:02.224] #25 0x0000000000847e66 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820b86a28) at ../src/backend/postmaster/postmaster.c:1372 [17:41:02.224] userDoption = [17:41:02.224] listen_addr_saved = false [17:41:02.224] output_config_variable = [17:41:02.224] opt = [17:41:02.224] status = [17:41:02.224] #26 0x0000000000784195 in main (argc=4, argv=0x820b86a28) at ../src/backend/main/main.c:197 [17:41:02.224] do_check_root =