[05:40:40.728] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [05:40:41.109] dumping /tmp/cores/postgres.8300.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [05:40:41.244] [New LWP 101726] [05:40:41.333] Core was generated by `postgres: postgres regression [local] MERGE'. [05:40:41.333] Program terminated with signal SIGABRT, Aborted. [05:40:41.333] Sent by thr_kill() from pid 8300 and user 1003. [05:40:41.333] #0 0x0000000829d27dca in thr_kill () from /lib/libc.so.7 [05:40:41.929] [05:40:41.929] Thread 1 (LWP 101726): [05:40:41.929] #0 0x0000000829d27dca in thr_kill () from /lib/libc.so.7 [05:40:41.929] No symbol table info available. [05:40:41.929] #1 0x0000000829ca06f4 in raise () from /lib/libc.so.7 [05:40:41.929] No symbol table info available. [05:40:41.929] #2 0x0000000829d51bc9 in abort () from /lib/libc.so.7 [05:40:41.929] No symbol table info available. [05:40:41.929] #3 0x0000000000a5e2b7 in ExceptionalCondition (conditionName=, fileName=0x372e96 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [05:40:41.929] No locals. [05:40:41.929] #4 0x0000000000740570 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8211a36c0, materialize=, shouldFree=shouldFree@entry=0x8211a3666) at ../src/backend/executor/execTuples.c:1737 [05:40:41.929] No locals. [05:40:41.929] #5 0x00000000007067c8 in ExecIRDeleteTriggers (estate=estate@entry=0x83553d100, relinfo=relinfo@entry=0x83553d6b0, slot=slot@entry=0x8211a36c0) at ../src/backend/commands/trigger.c:2841 [05:40:41.929] trigger = [05:40:41.929] oldtuple = [05:40:41.929] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x846c1c240, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:40:41.929] trigdesc = 0x83553d8c0 [05:40:41.929] newtuple = 0x0 [05:40:41.929] i = 0 [05:40:41.929] should_free = false [05:40:41.929] #6 0x00000000007657ea in ExecMergeMatched (context=0x8211a3780, resultRelInfo=0x83553d6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [05:40:41.929] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:40:41.929] relaction = 0x84274f460 [05:40:41.929] commandType = CMD_DELETE [05:40:41.929] result = TM_Ok [05:40:41.929] l__state = {l = 0x8427c3808, i = 0} [05:40:41.929] mtstate = 0x83553d4a0 [05:40:41.929] newslot = 0x0 [05:40:41.929] rslot = 0x0 [05:40:41.929] estate = 0x18d5e [05:40:41.929] mergeActions = [05:40:41.929] econtext = 0x8427c28a8 [05:40:41.929] epqstate = 0x83553d588 [05:40:41.929] actionStates = 0x8427c3808 [05:40:41.929] l = [05:40:41.929] isNull = [05:40:41.929] lmerge_matched = [05:40:41.929] __error = [05:40:41.929] l__state = [05:40:41.929] updateCxt = [05:40:41.929] relaction = [05:40:41.929] commandType = [05:40:41.929] result = [05:40:41.929] __error = [05:40:41.929] resultRelationDesc = [05:40:41.929] lockmode = [05:40:41.929] inputslot = [05:40:41.929] epqslot = [05:40:41.929] was_matched = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] #7 ExecMerge (context=0x8211a3780, resultRelInfo=0x83553d6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [05:40:41.929] matched = [05:40:41.929] rslot = 0x0 [05:40:41.929] #8 ExecModifyTable (pstate=0x83553d4a0) at ../src/backend/executor/nodeModifyTable.c:4112 [05:40:41.929] context = {mtstate = 0x83553d4a0, epqstate = 0x83553d588, estate = 0x83553d100, planSlot = 0x84274f3d0, tmfd = {ctid = {ip_blkid = {bi_hi = 7616, bi_lo = 17023}, ip_posid = 8}, xmax = 894686896, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x83553d100} [05:40:41.929] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [05:40:41.929] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835551118} [05:40:41.929] node = 0x83553d4a0 [05:40:41.929] estate = 0x83553d100 [05:40:41.929] operation = CMD_MERGE [05:40:41.929] resultRelInfo = 0x83553d6b0 [05:40:41.929] subplanstate = 0x83553edf0 [05:40:41.929] slot = [05:40:41.929] tupleid = 0x0 [05:40:41.929] oldtuple = 0x0 [05:40:41.929] oldSlot = [05:40:41.929] #9 0x000000000073a60b in ExecProcNodeFirst (node=0x83553d4a0) at ../src/backend/executor/execProcnode.c:464 [05:40:41.929] No locals. [05:40:41.929] #10 0x00000000007328fa in ExecProcNode (node=0x83553d4a0) at ../src/include/executor/executor.h:274 [05:40:41.929] No locals. [05:40:41.929] #11 ExecutePlan (estate=0x83553d100, planstate=0x83553d4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x835478310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [05:40:41.929] current_tuple_count = [05:40:41.929] slot = [05:40:41.929] #12 standard_ExecutorRun (queryDesc=0x83541e448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [05:40:41.929] estate = 0x83553d100 [05:40:41.929] oldcontext = 0x835478000 [05:40:41.929] operation = CMD_MERGE [05:40:41.929] dest = 0x835478310 [05:40:41.929] sendTuples = true [05:40:41.929] #13 0x00000000007327af in ExecutorRun (queryDesc=0x18d5e, queryDesc@entry=0x83541e448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [05:40:41.929] No locals. [05:40:41.929] #14 0x000000000090baaf in ProcessQuery (plan=0x8427ef2a0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8211a3998) at ../src/backend/tcop/pquery.c:160 [05:40:41.929] queryDesc = 0x83541e448 [05:40:41.929] #15 0x000000000090b04d in PortalRunMulti (portal=portal@entry=0x835451100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x835478310, altdest=0xb52390 , qc=qc@entry=0x8211a3998) at ../src/backend/tcop/pquery.c:1286 [05:40:41.929] pstmt = 0x8427ef2a0 [05:40:41.929] stmtlist_item__state = {l = 0x8427f3b58, i = 0} [05:40:41.929] active_snapshot_set = true [05:40:41.929] stmtlist_item = 0x8427f3b70 [05:40:41.929] #16 0x000000000090ab3c in FillPortalStore (portal=portal@entry=0x835451100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [05:40:41.929] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:40:41.929] treceiver = 0x835478310 [05:40:41.929] #17 0x000000000090a890 in PortalRun (portal=portal@entry=0x835451100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8427f3ba8, altdest=altdest@entry=0x8427f3ba8, qc=0x8211a3ad0) at ../src/backend/tcop/pquery.c:763 [05:40:41.929] _local_sigjmp_buf = {{_sjb = {9480239, 35253527768, 34915105224, 34915105456, 34915105232, 12168568, 12136352, 35253457152, 7112098687, 35253465344, 3579124, 34359738368}}} [05:40:41.929] _save_exception_stack = 0x8211a3ba0 [05:40:41.929] _save_context_stack = 0x0 [05:40:41.929] _do_rethrow = false [05:40:41.929] saveTopTransactionResourceOwner = 0x8354624d8 [05:40:41.929] saveTopTransactionContext = 0x835387000 [05:40:41.929] saveActivePortal = 0x0 [05:40:41.929] saveResourceOwner = 0x8354624d8 [05:40:41.929] savePortalContext = 0x0 [05:40:41.929] saveMemoryContext = 0x835387000 [05:40:41.929] result = [05:40:41.929] nprocessed = [05:40:41.929] #18 0x000000000090979b in exec_simple_query (query_string=query_string@entry=0x83537b100 "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 [05:40:41.929] cmdtaglen = [05:40:41.929] snapshot_set = [05:40:41.929] per_parsetree_context = 0x0 [05:40:41.929] plantree_list = [05:40:41.929] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:40:41.929] parsetree = 0x842790568 [05:40:41.929] commandTag = CMDTAG_MERGE [05:40:41.929] cmdtagname = [05:40:41.929] querytree_list = [05:40:41.929] portal = 0x835451100 [05:40:41.929] format = 0 [05:40:41.929] receiver = 0x8427f3ba8 [05:40:41.929] parsetree_item__state = {l = 0x842791e30, i = 0} [05:40:41.929] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [05:40:41.929] dest = DestRemote [05:40:41.929] was_logged = [05:40:41.929] oldcontext = 0x835387000 [05:40:41.929] parsetree_list = 0x842791e30 [05:40:41.929] use_implicit_block = false [05:40:41.929] parsetree_item = 0x842791e48 [05:40:41.929] save_log_statement_stats = [05:40:41.929] #19 0x0000000000907574 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [05:40:41.929] query_string = 0x83537b100 "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"... [05:40:41.929] input_message = {data = 0x83537b100 "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} [05:40:41.929] firstchar = [05:40:41.929] local_sigjmp_buf = {{_sjb = {9464384, 34915105696, 34915105656, 34915106256, 12177304, 12123776, 8192, 8388608, 72057628953019263, 0, 0, 34359738369}}} [05:40:41.929] send_ready_for_query = false [05:40:41.929] idle_in_transaction_timeout_enabled = false [05:40:41.929] idle_session_timeout_enabled = false [05:40:41.929] #20 0x0000000000902049 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [05:40:41.929] bsdata = [05:40:41.929] #21 0x000000000085bea2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8211a48e0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211a4828) at ../src/backend/postmaster/launch_backend.c:265 [05:40:41.929] pid = [05:40:41.929] #22 0x0000000000860801 in BackendStartup (client_sock=0x8211a4828) at ../src/backend/postmaster/postmaster.c:3593 [05:40:41.929] startup_data = {canAcceptConnections = CAC_OK} [05:40:41.929] bn = 0x8353871c8 [05:40:41.929] pid = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] save_errno = [05:40:41.929] __error = [05:40:41.929] __error = [05:40:41.929] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [05:40:41.929] 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' , "\200H\032!\b\000\000\000\330U\372(\b\000\000\000\v\000\000\000\000\000\000\000\016\326\372(\b", '\000' , "\300H\032!\b\000\000\000t\274\205\000\000\000\000\000\320H\032!\b", '\000' }, salen = 16}} [05:40:41.929] i = 0 [05:40:41.929] now = [05:40:41.929] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 700517476, events = 8, fd = 555368048, user_data = 0x8211a4000}, {pos = 566088712, events = 8, fd = 32, user_data = 0x8211a3ff0}, {pos = -1385252204, events = 3425, fd = 566059016, user_data = 0x821bd6408}, {pos = 566061064, events = 8, fd = 566062088, user_data = 0x821bda008}, {pos = 566076424, events = 8, fd = 566077448, user_data = 0x821bdac08}, {pos = 566079496, events = 8, fd = 566080520, user_data = 0x821bdb808}, {pos = 566082568, events = 8, fd = 566083592, user_data = 0x821bdc408}, {pos = 566085640, events = 8, fd = 566086664, user_data = 0x821bdd008}, {pos = 566088712, events = 8, fd = -1, user_data = 0x829de82e0}, {pos = 555368288, events = 8, fd = 702108073, user_data = 0x0}, {pos = 4096, events = 0, fd = -748018426, user_data = 0x829de87e8}, {pos = 889232352, events = 8, fd = 160, user_data = 0x0}, {pos = 849825936, events = 8, fd = 555368496, user_data = 0x829d7392c}, {pos = 4096, events = 0, fd = 700533092, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 566114872, user_data = 0x800000001}, {pos = 566088712, events = 8, fd = 700446936, user_data = 0x8211a40b8}, {pos = 555368048, events = 8, fd = 32, user_data = 0x829c10c64}, {pos = 566088712, events = 8, fd = 566114872, user_data = 0x0}, {pos = 2625, events = 0, fd = 555368608, user_data = 0xd61ad6eb645}, {pos = 700533092, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 566114872, events = 8, fd = 1, user_data = 0x821bdd408}, {pos = 892776448, events = 8, fd = 1, user_data = 0x83536b194}, {pos = 0, events = 0, fd = 555368560, user_data = 0x828facc0c}, {pos = 1, events = 0, fd = 892776448, user_data = 0x8211a40a0}, {pos = 687521460, events = 8, fd = 702259552, user_data = 0x829dba160 }, {pos = 700629184, events = 8, fd = 566088712, user_data = 0x8211a4180}, {pos = -1385253844, events = 3425, fd = 849825936, user_data = 0x800000001}, {pos = -1385254226, events = 3425, fd = 12240, user_data = 0x8211a40a8}, {pos = 555368832, events = 8, fd = 893482984, user_data = 0x8211a46f0}, {pos = -1385173360, events = 3425, fd = 566088712, user_data = 0x8211a037f}, {pos = 701916572, events = 8, fd = 566059016, user_data = 0x0}, {pos = 566088712, events = 8, fd = 12240, user_data = 0x829bf0000}, {pos = 1964368, events = 0, fd = 702259552, user_data = 0x829c10c64}, {pos = 15616, events = 0, fd = 555370016, user_data = 0x8211a41f0}, {pos = 701190542, events = 8, fd = 702298168, user_data = 0x8211a41b4}, {pos = 893220314, events = 8, fd = 555370016, user_data = 0x8211a41f0}, {pos = 701281797, events = 8, fd = 555368882, user_data = 0x8211a4620}, {pos = 555370016, events = 8, fd = 0, user_data = 0x1bfd16afd36a2506}, {pos = 555370016, events = 8, fd = 893220312, user_data = 0x8211a46f0}, {pos = 702298168, events = 8, fd = 0, user_data = 0x8211a4660}, {pos = 701282061, events = 8, fd = 0, user_data = 0x0}, {pos = 555370384, events = 8, fd = 893220312, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1385225207, events = 3425, fd = 555369288, user_data = 0x829c10c64}, {pos = 2503, events = 0, fd = -1385225207, user_data = 0x8211a4368}, {pos = 700517476, events = 8, fd = 2758, user_data = 0x829c0a120}, {pos = 555369192, events = 8, fd = 566088712, user_data = 0x8211a4368}, {pos = 700490016, events = 8, fd = 555369296, user_data = 0xd61ad6ed465}, {pos = 0, events = 0, fd = 0, user_data = 0x829ddc0f0}, {pos = 700450128, events = 8, fd = 0, user_data = 0x0}, {pos = 702327216, events = 8, fd = -1385225207, user_data = 0x8211a43f8}, {pos = 700517476, events = 8, fd = 2924, user_data = 0x829c0a3b8}, {pos = 555369336, events = 8, fd = 566088712, user_data = 0x8211a43f8}, {pos = 700490680, events = 8, fd = 555369440, user_data = 0xd61ad6ed465}, {pos = 566112312, events = 8, fd = 2675099, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 566088712, events = 8, fd = 700450128, user_data = 0x8211a46b8}, {pos = 566088712, events = 8, fd = 555369880, user_data = 0x1e}, {pos = 700454112, events = 8, fd = 555369608, user_data = 0x821be2288}, {pos = 555370056, events = 8, fd = 555369584, user_data = 0xd61ad6f1da3}, {pos = 566112312, events = 8, fd = 2698787, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 566112312, user_data = 0x1}} [05:40:41.930] last_touch_time = 1714541865 [05:40:41.930] last_lockfile_recheck_time = 1714541865 [05:40:41.930] nevents = 1 [05:40:41.930] #24 0x000000000085e0d6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8211a4e20) at ../src/backend/postmaster/postmaster.c:1372 [05:40:41.930] userDoption = [05:40:41.930] listen_addr_saved = false [05:40:41.930] output_config_variable = [05:40:41.930] opt = [05:40:41.930] status = [05:40:41.930] #25 0x0000000000795c65 in main (argc=8, argv=0x8211a4e20) at ../src/backend/main/main.c:197 [05:40:41.930] do_check_root = [05:40:41.940] [05:40:41.940] [05:40:41.940] [05:40:42.008] dumping /tmp/cores/postgres.9033.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [05:40:42.134] [New LWP 101712] [05:40:42.203] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [05:40:42.203] Program terminated with signal SIGABRT, Aborted. [05:40:42.203] Sent by thr_kill() from pid 9033 and user 1003. [05:40:42.203] #0 0x000000082c509dca in thr_kill () from /lib/libc.so.7 [05:40:42.770] [05:40:42.770] Thread 1 (LWP 101712): [05:40:42.770] #0 0x000000082c509dca in thr_kill () from /lib/libc.so.7 [05:40:42.770] No symbol table info available. [05:40:42.770] #1 0x000000082c4826f4 in raise () from /lib/libc.so.7 [05:40:42.770] No symbol table info available. [05:40:42.770] #2 0x000000082c533bc9 in abort () from /lib/libc.so.7 [05:40:42.770] No symbol table info available. [05:40:42.770] #3 0x0000000000a5e2b7 in ExceptionalCondition (conditionName=, fileName=0x372e96 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [05:40:42.770] No locals. [05:40:42.770] #4 0x0000000000740570 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8216a9850, materialize=, shouldFree=shouldFree@entry=0x8216a97f6) at ../src/backend/executor/execTuples.c:1737 [05:40:42.770] No locals. [05:40:42.770] #5 0x00000000007067c8 in ExecIRDeleteTriggers (estate=estate@entry=0x8373d8100, relinfo=relinfo@entry=0x8373d86b0, slot=slot@entry=0x8216a9850) at ../src/backend/commands/trigger.c:2841 [05:40:42.770] trigger = [05:40:42.770] oldtuple = [05:40:42.770] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x842c773b0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:40:42.770] trigdesc = 0x8373d88c0 [05:40:42.770] newtuple = 0x0 [05:40:42.770] i = 0 [05:40:42.770] should_free = false [05:40:42.770] #6 0x00000000007657ea in ExecMergeMatched (context=0x8216a9910, resultRelInfo=0x8373d86b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [05:40:42.770] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:40:42.770] relaction = 0x842cff5a0 [05:40:42.770] commandType = CMD_DELETE [05:40:42.770] result = TM_Ok [05:40:42.770] l__state = {l = 0x842d854c8, i = 0} [05:40:42.770] mtstate = 0x8373d84a0 [05:40:42.770] newslot = 0x0 [05:40:42.770] rslot = 0x0 [05:40:42.770] estate = 0x18d50 [05:40:42.770] mergeActions = [05:40:42.770] econtext = 0x842d84568 [05:40:42.770] epqstate = 0x8373d8588 [05:40:42.770] actionStates = 0x842d854c8 [05:40:42.770] l = [05:40:42.770] isNull = [05:40:42.770] lmerge_matched = [05:40:42.770] __error = [05:40:42.770] l__state = [05:40:42.770] updateCxt = [05:40:42.770] relaction = [05:40:42.770] commandType = [05:40:42.770] result = [05:40:42.770] __error = [05:40:42.770] resultRelationDesc = [05:40:42.770] lockmode = [05:40:42.770] inputslot = [05:40:42.770] epqslot = [05:40:42.770] was_matched = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] #7 ExecMerge (context=0x8216a9910, resultRelInfo=0x8373d86b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [05:40:42.770] matched = [05:40:42.770] rslot = 0x0 [05:40:42.770] #8 ExecModifyTable (pstate=0x8373d84a0) at ../src/backend/executor/nodeModifyTable.c:4112 [05:40:42.770] context = {mtstate = 0x8373d84a0, epqstate = 0x8373d8588, estate = 0x8373d8100, planSlot = 0x842cff510, tmfd = {ctid = {ip_blkid = {bi_hi = 15936, bi_lo = 17115}, ip_posid = 8}, xmax = 926779056, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x8373d8100} [05:40:42.770] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [05:40:42.770] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8373ec118} [05:40:42.770] node = 0x8373d84a0 [05:40:42.770] estate = 0x8373d8100 [05:40:42.770] operation = CMD_MERGE [05:40:42.770] resultRelInfo = 0x8373d86b0 [05:40:42.770] subplanstate = 0x8373d9df0 [05:40:42.770] slot = [05:40:42.770] tupleid = 0x0 [05:40:42.770] oldtuple = 0x0 [05:40:42.770] oldSlot = [05:40:42.770] #9 0x000000000073a60b in ExecProcNodeFirst (node=0x8373d84a0) at ../src/backend/executor/execProcnode.c:464 [05:40:42.770] No locals. [05:40:42.770] #10 0x00000000007328fa in ExecProcNode (node=0x8373d84a0) at ../src/include/executor/executor.h:274 [05:40:42.770] No locals. [05:40:42.770] #11 ExecutePlan (estate=0x8373d8100, planstate=0x8373d84a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x837246b10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [05:40:42.770] current_tuple_count = [05:40:42.770] slot = [05:40:42.770] #12 standard_ExecutorRun (queryDesc=0x8372f1448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [05:40:42.770] estate = 0x8373d8100 [05:40:42.770] oldcontext = 0x837246800 [05:40:42.770] operation = CMD_MERGE [05:40:42.770] dest = 0x837246b10 [05:40:42.770] sendTuples = true [05:40:42.770] #13 0x00000000007327af in ExecutorRun (queryDesc=0x18d50, queryDesc@entry=0x8372f1448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [05:40:42.770] No locals. [05:40:42.770] #14 0x000000000090baaf in ProcessQuery (plan=0x842db1320, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8216a9b28) at ../src/backend/tcop/pquery.c:160 [05:40:42.770] queryDesc = 0x8372f1448 [05:40:42.770] #15 0x000000000090b04d in PortalRunMulti (portal=portal@entry=0x8372d1100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x837246b10, altdest=0xb52390 , qc=qc@entry=0x8216a9b28) at ../src/backend/tcop/pquery.c:1286 [05:40:42.770] pstmt = 0x842db1320 [05:40:42.770] stmtlist_item__state = {l = 0x842db5bd8, i = 0} [05:40:42.770] active_snapshot_set = true [05:40:42.770] stmtlist_item = 0x842db5bf0 [05:40:42.770] #16 0x000000000090ab3c in FillPortalStore (portal=portal@entry=0x8372d1100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [05:40:42.770] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:40:42.770] treceiver = 0x837246b10 [05:40:42.770] #17 0x000000000090a890 in PortalRun (portal=portal@entry=0x8372d1100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x842db5c28, altdest=altdest@entry=0x842db5c28, qc=0x8216a9c60) at ../src/backend/tcop/pquery.c:763 [05:40:42.770] _local_sigjmp_buf = {{_sjb = {9480239, 35285774936, 34920373080, 34920373312, 34920373088, 12168568, 12136352, 35285438720, 7112098687, 35285446912, 3579124, 34359738368}}} [05:40:42.770] _save_exception_stack = 0x8216a9d30 [05:40:42.770] _save_context_stack = 0x0 [05:40:42.770] _do_rethrow = false [05:40:42.770] saveTopTransactionResourceOwner = 0x837323258 [05:40:42.770] saveTopTransactionContext = 0x837244000 [05:40:42.770] saveActivePortal = 0x0 [05:40:42.770] saveResourceOwner = 0x837323258 [05:40:42.770] savePortalContext = 0x0 [05:40:42.770] saveMemoryContext = 0x837244000 [05:40:42.770] result = [05:40:42.770] nprocessed = [05:40:42.770] #18 0x000000000090979b in exec_simple_query (query_string=query_string@entry=0x837238100 "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 [05:40:42.770] cmdtaglen = [05:40:42.770] snapshot_set = [05:40:42.770] per_parsetree_context = 0x0 [05:40:42.770] plantree_list = [05:40:42.770] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:40:42.770] parsetree = 0x842d51e28 [05:40:42.770] commandTag = CMDTAG_MERGE [05:40:42.770] cmdtagname = [05:40:42.770] querytree_list = [05:40:42.770] portal = 0x8372d1100 [05:40:42.770] format = 0 [05:40:42.770] receiver = 0x842db5c28 [05:40:42.770] parsetree_item__state = {l = 0x842d536f0, i = 0} [05:40:42.770] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [05:40:42.770] dest = DestRemote [05:40:42.770] was_logged = [05:40:42.770] oldcontext = 0x837244000 [05:40:42.770] parsetree_list = 0x842d536f0 [05:40:42.770] use_implicit_block = false [05:40:42.770] parsetree_item = 0x842d53708 [05:40:42.770] save_log_statement_stats = [05:40:42.770] #19 0x0000000000907574 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [05:40:42.770] query_string = 0x837238100 "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"... [05:40:42.770] input_message = {data = 0x837238100 "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} [05:40:42.770] firstchar = [05:40:42.770] local_sigjmp_buf = {{_sjb = {9464384, 34920373552, 34920373512, 34920374112, 12177304, 12123776, 8192, 8388608, 72057628958262143, 0, 0, 34359738369}}} [05:40:42.770] send_ready_for_query = false [05:40:42.770] idle_in_transaction_timeout_enabled = false [05:40:42.770] idle_session_timeout_enabled = false [05:40:42.770] #20 0x0000000000902049 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [05:40:42.770] bsdata = [05:40:42.770] #21 0x000000000085bea2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8216aaa70 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8216aa9b8) at ../src/backend/postmaster/launch_backend.c:265 [05:40:42.770] pid = [05:40:42.770] #22 0x0000000000860801 in BackendStartup (client_sock=0x8216aa9b8) at ../src/backend/postmaster/postmaster.c:3593 [05:40:42.770] startup_data = {canAcceptConnections = CAC_OK} [05:40:42.770] bn = 0x837244448 [05:40:42.770] pid = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] save_errno = [05:40:42.770] __error = [05:40:42.770] __error = [05:40:42.770] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [05:40:42.770] 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' , "\020\252j!\b\000\000\000\330\205f+\b\000\000\000\v\000\000\000\000\000\000\000\016\006g+\b", '\000' , "P\252j!\b\000\000\000t\274\205\000\000\000\000\000`\252j!\b", '\000' }, salen = 16}} [05:40:42.770] i = 0 [05:40:42.770] now = [05:40:42.770] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 742337636, events = 8, fd = 560635904, user_data = 0x8216aa190}, {pos = 576750600, events = 8, fd = 32, user_data = 0x8216aa180}, {pos = 2138950292, events = 15714, fd = 576720904, user_data = 0x822601408}, {pos = 576722952, events = 8, fd = 576723976, user_data = 0x822605008}, {pos = 576738312, events = 8, fd = 576739336, user_data = 0x822605c08}, {pos = 576741384, events = 8, fd = 576742408, user_data = 0x822606808}, {pos = 576744456, events = 8, fd = 576745480, user_data = 0x822607408}, {pos = 576747528, events = 8, fd = 576748552, user_data = 0x822608008}, {pos = 576750600, events = 8, fd = 576770248, user_data = 0x8216aa308}, {pos = 560636208, events = 8, fd = 2138975651, user_data = 0x0}, {pos = 2571362, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 576774200, events = 8, fd = 1, user_data = 0x822608408}, {pos = 742245544, events = 8, fd = 560636936, user_data = 0x822608408}, {pos = 560636192, events = 0, fd = 742353252, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 576776760, user_data = 0x1}, {pos = 576750600, events = 8, fd = 742267096, user_data = 0x8216aa248}, {pos = 560635904, events = 8, fd = 32, user_data = 0x82c3f2c64}, {pos = 576750600, events = 8, fd = 576776760, user_data = 0x0}, {pos = 2625, events = 0, fd = 560636464, user_data = 0x3d627f7dc645}, {pos = 742353252, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 576776760, events = 8, fd = 1, user_data = 0x822608408}, {pos = 925007872, events = 8, fd = 1, user_data = 0x837228194}, {pos = 0, events = 0, fd = 560636416, user_data = 0x82b66fc0c}, {pos = 1, events = 0, fd = 925007872, user_data = 0x8216aa230}, {pos = 728166068, events = 8, fd = 744079712, user_data = 0x82c59c160 }, {pos = 742449344, events = 8, fd = 576750600, user_data = 0x8216aa310}, {pos = 2138948652, events = 15714, fd = 576749576, user_data = 0x800000001}, {pos = 2138948270, events = 15714, fd = 12240, user_data = 0x8216aa238}, {pos = 560636688, events = 8, fd = 925804520, user_data = 0x8216aa880}, {pos = 2139029136, events = 15714, fd = 576750600, user_data = 0x8216a037f}, {pos = 743736498, events = 8, fd = 576720904, user_data = 0x0}, {pos = 576750600, events = 8, fd = 12240, user_data = 0x82c3d2000}, {pos = 1964368, events = 0, fd = 744079712, user_data = 0x82c3f2c64}, {pos = 15616, events = 0, fd = 560637872, user_data = 0x8216aa380}, {pos = 743010702, events = 8, fd = 744118328, user_data = 0x8216aa344}, {pos = 925459930, events = 8, fd = 560637872, user_data = 0x8216aa380}, {pos = 743101957, events = 8, fd = 560636738, user_data = 0x8216aa7b0}, {pos = 560637872, events = 8, fd = 0, user_data = 0x2083ae963694f754}, {pos = 560637872, events = 8, fd = 925459928, user_data = 0x8216aa880}, {pos = 744118328, events = 8, fd = 0, user_data = 0x8216aa7f0}, {pos = 743102221, events = 8, fd = 0, user_data = 0x0}, {pos = 560638240, events = 8, fd = 925459928, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 2138977289, events = 15714, fd = 560637144, user_data = 0x82c3f2c64}, {pos = 2503, events = 0, fd = 2138977289, user_data = 0x8216aa4f8}, {pos = 742337636, events = 8, fd = 2758, user_data = 0x82c3ec120}, {pos = 560637048, events = 8, fd = 576750600, user_data = 0x8216aa4f8}, {pos = 742310176, events = 8, fd = 560637152, user_data = 0x3d627f7de465}, {pos = 0, events = 0, fd = 0, user_data = 0x82c5be0f0}, {pos = 742270288, events = 8, fd = 0, user_data = 0x0}, {pos = 744147376, events = 8, fd = 2138977289, user_data = 0x8216aa588}, {pos = 742337636, events = 8, fd = 2924, user_data = 0x82c3ec3b8}, {pos = 560637192, events = 8, fd = 576750600, user_data = 0x8216aa588}, {pos = 742310840, events = 8, fd = 560637296, user_data = 0x3d627f7de465}, {pos = 576774200, events = 8, fd = 2675099, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 576750600, events = 8, fd = 742270288, user_data = 0x8216aa848}, {pos = 576750600, events = 8, fd = 560637736, user_data = 0x1e}, {pos = 742274272, events = 8, fd = 560637464, user_data = 0x82260d288}, {pos = 560637912, events = 8, fd = 560637440, user_data = 0x3d627f7e2da3}, {pos = 576774200, events = 8, fd = 2698787, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 576774200, user_data = 0x1}} [05:40:42.770] last_touch_time = 1714541867 [05:40:42.770] last_lockfile_recheck_time = 1714541867 [05:40:42.770] nevents = 1 [05:40:42.770] #24 0x000000000085e0d6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8216aafb0) at ../src/backend/postmaster/postmaster.c:1372 [05:40:42.770] userDoption = [05:40:42.770] listen_addr_saved = false [05:40:42.770] output_config_variable = [05:40:42.770] opt = [05:40:42.770] status = [05:40:42.770] #25 0x0000000000795c65 in main (argc=4, argv=0x8216aafb0) at ../src/backend/main/main.c:197 [05:40:42.770] do_check_root = [05:40:42.782] [05:40:42.782] [05:40:42.782] [05:40:42.852] dumping /tmp/cores/postgres.14290.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [05:40:42.978] [New LWP 101712] [05:40:43.045] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [05:40:43.045] Program terminated with signal SIGABRT, Aborted. [05:40:43.045] Sent by thr_kill() from pid 14290 and user 1003. [05:40:43.045] #0 0x000000082bd09dca in thr_kill () from /lib/libc.so.7 [05:40:43.622] [05:40:43.622] Thread 1 (LWP 101712): [05:40:43.622] #0 0x000000082bd09dca in thr_kill () from /lib/libc.so.7 [05:40:43.622] No symbol table info available. [05:40:43.622] #1 0x000000082bc826f4 in raise () from /lib/libc.so.7 [05:40:43.622] No symbol table info available. [05:40:43.622] #2 0x000000082bd33bc9 in abort () from /lib/libc.so.7 [05:40:43.622] No symbol table info available. [05:40:43.622] #3 0x0000000000a5e2b7 in ExceptionalCondition (conditionName=, fileName=0x372e96 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [05:40:43.622] No locals. [05:40:43.622] #4 0x0000000000740570 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82166e7c0, materialize=, shouldFree=shouldFree@entry=0x82166e766) at ../src/backend/executor/execTuples.c:1737 [05:40:43.622] No locals. [05:40:43.622] #5 0x00000000007067c8 in ExecIRDeleteTriggers (estate=estate@entry=0x837cd1100, relinfo=relinfo@entry=0x837cd16b0, slot=slot@entry=0x82166e7c0) at ../src/backend/commands/trigger.c:2841 [05:40:43.622] trigger = [05:40:43.622] oldtuple = [05:40:43.622] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83ec4d9e0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:40:43.622] trigdesc = 0x837cd18c0 [05:40:43.622] newtuple = 0x0 [05:40:43.622] i = 0 [05:40:43.622] should_free = false [05:40:43.622] #6 0x00000000007657ea in ExecMergeMatched (context=0x82166e880, resultRelInfo=0x837cd16b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [05:40:43.622] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:40:43.622] relaction = 0x837c87ca0 [05:40:43.622] commandType = CMD_DELETE [05:40:43.622] result = TM_Ok [05:40:43.622] l__state = {l = 0x83a89de48, i = 0} [05:40:43.622] mtstate = 0x837cd14a0 [05:40:43.622] newslot = 0x0 [05:40:43.622] rslot = 0x0 [05:40:43.622] estate = 0x18d50 [05:40:43.622] mergeActions = [05:40:43.622] econtext = 0x83a89cee8 [05:40:43.622] epqstate = 0x837cd1588 [05:40:43.622] actionStates = 0x83a89de48 [05:40:43.622] l = [05:40:43.622] isNull = [05:40:43.622] lmerge_matched = [05:40:43.622] __error = [05:40:43.622] l__state = [05:40:43.622] updateCxt = [05:40:43.622] relaction = [05:40:43.622] commandType = [05:40:43.622] result = [05:40:43.622] __error = [05:40:43.622] resultRelationDesc = [05:40:43.622] lockmode = [05:40:43.622] inputslot = [05:40:43.622] epqslot = [05:40:43.622] was_matched = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] #7 ExecMerge (context=0x82166e880, resultRelInfo=0x837cd16b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [05:40:43.622] matched = [05:40:43.622] rslot = 0x0 [05:40:43.622] #8 ExecModifyTable (pstate=0x837cd14a0) at ../src/backend/executor/nodeModifyTable.c:4112 [05:40:43.622] context = {mtstate = 0x837cd14a0, epqstate = 0x837cd1588, estate = 0x837cd1100, planSlot = 0x837c87c10, tmfd = {ctid = {ip_blkid = {bi_hi = 59688, bi_lo = 8550}, ip_posid = 8}, xmax = 735837680, cmax = 8, traversed = 240}, cpUpdateReturningSlot = 0x82bd066de} [05:40:43.622] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [05:40:43.622] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x837cdd118} [05:40:43.622] node = 0x837cd14a0 [05:40:43.622] estate = 0x837cd1100 [05:40:43.622] operation = CMD_MERGE [05:40:43.622] resultRelInfo = 0x837cd16b0 [05:40:43.622] subplanstate = 0x837cd2df0 [05:40:43.622] slot = [05:40:43.622] tupleid = 0x0 [05:40:43.622] oldtuple = 0x0 [05:40:43.622] oldSlot = [05:40:43.622] #9 0x000000000073a60b in ExecProcNodeFirst (node=0x837cd14a0) at ../src/backend/executor/execProcnode.c:464 [05:40:43.622] No locals. [05:40:43.622] #10 0x00000000007328fa in ExecProcNode (node=0x837cd14a0) at ../src/include/executor/executor.h:274 [05:40:43.622] No locals. [05:40:43.622] #11 ExecutePlan (estate=0x837cd1100, planstate=0x837cd14a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x837b23b10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [05:40:43.622] current_tuple_count = [05:40:43.622] slot = [05:40:43.622] #12 standard_ExecutorRun (queryDesc=0x837bce448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [05:40:43.622] estate = 0x837cd1100 [05:40:43.622] oldcontext = 0x837b23800 [05:40:43.622] operation = CMD_MERGE [05:40:43.622] dest = 0x837b23b10 [05:40:43.622] sendTuples = true [05:40:43.622] #13 0x0000000839f02963 in pgss_ExecutorRun (queryDesc=0x837bce448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [05:40:43.622] _local_sigjmp_buf = {{_sjb = {35331778866, 12168568, 34920131000, 34920131168, 35294864456, 34920131008, 1, 1, 35295921023, 35294864456, 12177296, 34359738368}}} [05:40:43.622] _save_exception_stack = 0x82166eb80 [05:40:43.622] _save_context_stack = 0x0 [05:40:43.622] _do_rethrow = false [05:40:43.622] #14 0x00000000007327a8 in ExecutorRun (queryDesc=0x18d50, queryDesc@entry=0x837bce448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [05:40:43.622] No locals. [05:40:43.622] #15 0x000000000090baaf in ProcessQuery (plan=0x83a861480, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82166eb48) at ../src/backend/tcop/pquery.c:160 [05:40:43.622] queryDesc = 0x837bce448 [05:40:43.622] #16 0x000000000090b04d in PortalRunMulti (portal=portal@entry=0x837bb0100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x837b23b10, altdest=0xb52390 , qc=qc@entry=0x82166eb48) at ../src/backend/tcop/pquery.c:1286 [05:40:43.622] pstmt = 0x83a861480 [05:40:43.622] stmtlist_item__state = {l = 0x83a865d38, i = 0} [05:40:43.622] active_snapshot_set = true [05:40:43.622] stmtlist_item = 0x83a865d50 [05:40:43.622] #17 0x000000000090ab3c in FillPortalStore (portal=portal@entry=0x837bb0100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [05:40:43.622] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:40:43.622] treceiver = 0x837b23b10 [05:40:43.622] #18 0x000000000090a890 in PortalRun (portal=portal@entry=0x837bb0100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83a865d88, altdest=altdest@entry=0x83a865d88, qc=0x82166ec80) at ../src/backend/tcop/pquery.c:763 [05:40:43.622] _local_sigjmp_buf = {{_sjb = {9480239, 35295075096, 34920131448, 34920131680, 34920131456, 12168568, 12136352, 35294740736, 7112098687, 35294748928, 3579124, 34359738368}}} [05:40:43.622] _save_exception_stack = 0x82166ed50 [05:40:43.622] _save_context_stack = 0x0 [05:40:43.622] _do_rethrow = false [05:40:43.622] saveTopTransactionResourceOwner = 0x837c01b18 [05:40:43.622] saveTopTransactionContext = 0x837b21000 [05:40:43.622] saveActivePortal = 0x0 [05:40:43.622] saveResourceOwner = 0x837c01b18 [05:40:43.622] savePortalContext = 0x0 [05:40:43.622] saveMemoryContext = 0x837b21000 [05:40:43.622] result = [05:40:43.622] nprocessed = [05:40:43.622] #19 0x000000000090979b in exec_simple_query (query_string=query_string@entry=0x837b15100 "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 [05:40:43.622] cmdtaglen = [05:40:43.622] snapshot_set = [05:40:43.622] per_parsetree_context = 0x0 [05:40:43.622] plantree_list = [05:40:43.622] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:40:43.622] parsetree = 0x83a83d568 [05:40:43.622] commandTag = CMDTAG_MERGE [05:40:43.622] cmdtagname = [05:40:43.622] querytree_list = [05:40:43.622] portal = 0x837bb0100 [05:40:43.622] format = 0 [05:40:43.622] receiver = 0x83a865d88 [05:40:43.622] parsetree_item__state = {l = 0x83a83ee30, i = 0} [05:40:43.622] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [05:40:43.622] dest = DestRemote [05:40:43.622] was_logged = [05:40:43.622] oldcontext = 0x837b21000 [05:40:43.622] parsetree_list = 0x83a83ee30 [05:40:43.622] use_implicit_block = false [05:40:43.622] parsetree_item = 0x83a83ee48 [05:40:43.622] save_log_statement_stats = [05:40:43.622] #20 0x0000000000907574 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [05:40:43.622] query_string = 0x837b15100 "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"... [05:40:43.622] input_message = {data = 0x837b15100 "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} [05:40:43.622] firstchar = [05:40:43.622] local_sigjmp_buf = {{_sjb = {9464384, 34920131920, 34920131880, 34920132480, 12177304, 12123776, 8192, 8388608, 72057628957999999, 0, 0, 1}}} [05:40:43.622] send_ready_for_query = false [05:40:43.622] idle_in_transaction_timeout_enabled = false [05:40:43.622] idle_session_timeout_enabled = false [05:40:43.622] #21 0x0000000000902049 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [05:40:43.622] bsdata = [05:40:43.622] #22 0x000000000085bea2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82166fa90 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82166f9d8) at ../src/backend/postmaster/launch_backend.c:265 [05:40:43.622] pid = [05:40:43.622] #23 0x0000000000860801 in BackendStartup (client_sock=0x82166f9d8) at ../src/backend/postmaster/postmaster.c:3593 [05:40:43.622] startup_data = {canAcceptConnections = CAC_OK} [05:40:43.622] bn = 0x837b214e8 [05:40:43.622] pid = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] save_errno = [05:40:43.622] __error = [05:40:43.622] __error = [05:40:43.622] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [05:40:43.622] 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' , "0\372f!\b\000\000\000\330U\375,\b\000\000\000\v\000\000\000\000\000\000\000\016\326\375,\b", '\000' , "p\372f!\b\000\000\000t\274\205\000\000\000\000\000\200\372f!\b", '\000' }, salen = 16}} [05:40:43.622] i = 0 [05:40:43.622] now = [05:40:43.622] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 560394672, events = 8, fd = 563467272, user_data = 0x21}, {pos = 560394656, events = 8, fd = 1084967572, user_data = 0x821956008}, {pos = 563438600, events = 8, fd = 563439624, user_data = 0x821956c08}, {pos = 563453960, events = 8, fd = 563454984, user_data = 0x82195a808}, {pos = 563457032, events = 8, fd = 563458056, user_data = 0x82195b408}, {pos = 563460104, events = 8, fd = 563461128, user_data = 0x82195c008}, {pos = 563463176, events = 8, fd = 563464200, user_data = 0x82195cc08}, {pos = 563466248, events = 8, fd = 563467272, user_data = 0x8219620c8}, {pos = 560395048, events = 8, fd = 560394560, user_data = 0x373c40abada3}, {pos = 563467272, events = 8, fd = 2571362, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 563490872, user_data = 0x1}, {pos = 563467272, events = 8, fd = 733856936, user_data = 0x82166f428}, {pos = 563467272, events = 8, fd = 560394528, user_data = 0x273bac}, {pos = 560395120, events = 8, fd = 733964644, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 563493432, user_data = 0x373c00000001}, {pos = 563467272, events = 8, fd = 733878488, user_data = 0x82166f268}, {pos = 560394256, events = 8, fd = 33, user_data = 0x82bbf2c64}, {pos = 563467272, events = 8, fd = 563493432, user_data = 0x0}, {pos = 2625, events = 0, fd = 560394832, user_data = 0x373c40ab4645}, {pos = 733964644, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 563493432, events = 8, fd = 1, user_data = 0x82195d408}, {pos = 934301696, events = 8, fd = 1, user_data = 0x837b05194}, {pos = 0, events = 0, fd = 560394784, user_data = 0x82cfdcc0c}, {pos = 1, events = 0, fd = 934301696, user_data = 0x82166f250}, {pos = 754826932, events = 8, fd = 735691104, user_data = 0x82bd9c160 }, {pos = 734060736, events = 8, fd = 563467272, user_data = 0x82166f330}, {pos = 1084965932, events = 14140, fd = 80627796, user_data = 0x1}, {pos = 1084965550, events = 14140, fd = 12240, user_data = 0x82166f258}, {pos = 560395056, events = 8, fd = 935098344, user_data = 0x82166f8a0}, {pos = 1085046416, events = 14140, fd = 563467272, user_data = 0x82166037f}, {pos = 735347890, events = 8, fd = 560395360, user_data = 0x373c00000000}, {pos = 563467272, events = 8, fd = 12240, user_data = 0x82bbd2000}, {pos = 1964368, events = 0, fd = 735691104, user_data = 0x82bbf2c64}, {pos = 15616, events = 0, fd = 560396240, user_data = 0x82166f3a0}, {pos = 734622094, events = 8, fd = 735729720, user_data = 0x82166f364}, {pos = 934753754, events = 8, fd = 560396240, user_data = 0x82166f3a0}, {pos = 734713349, events = 8, fd = 560395106, user_data = 0x82166f7d0}, {pos = 560396240, events = 8, fd = 0, user_data = 0x8cfb822476917159}, {pos = 560396240, events = 8, fd = 934753752, user_data = 0x82166f8a0}, {pos = 735729720, events = 8, fd = 0, user_data = 0x82166f810}, {pos = 734713613, events = 8, fd = 0, user_data = 0x0}, {pos = 560396608, events = 8, fd = 934753752, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1084994569, user_data = 0x82166f4e8}, {pos = 733949028, events = 8, fd = 2503, user_data = 0x373c40abb409}, {pos = 560395528, events = 8, fd = 733949028, user_data = 0xac6}, {pos = 733921568, events = 8, fd = 560395400, user_data = 0x82195d408}, {pos = 560395528, events = 8, fd = 733921568, user_data = 0x82166f4f0}, {pos = 1084974181, events = 14140, fd = 0, user_data = 0x800000000}, {pos = 560395488, events = 8, fd = 733881680, user_data = 0x0}, {pos = 0, events = 0, fd = 560395456, user_data = 0x373c40abb409}, {pos = 560395672, events = 8, fd = 733949028, user_data = 0xb6c}, {pos = 733922232, events = 8, fd = 560395544, user_data = 0x82195d408}, {pos = 560395672, events = 8, fd = 733922232, user_data = 0x82166f580}, {pos = 1084974181, events = 14140, fd = 563490872, user_data = 0x28d19b}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 563467272, user_data = 0x82bbe2550}, {pos = 560396392, events = 8, fd = 563467272, user_data = 0x2166f748}, {pos = 31, events = 0, fd = 0, user_data = 0x82166f628}, {pos = 563488712, events = 8, fd = 560396280, user_data = 0x82166f610}, {pos = 1084992931, events = 14140, fd = 563490872, user_data = 0x292e23}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821963038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [05:40:43.623] last_touch_time = 1714541886 [05:40:43.623] last_lockfile_recheck_time = 1714541886 [05:40:43.623] nevents = 1 [05:40:43.623] #25 0x000000000085e0d6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82166ffd8) at ../src/backend/postmaster/postmaster.c:1372 [05:40:43.623] userDoption = [05:40:43.623] listen_addr_saved = false [05:40:43.623] output_config_variable = [05:40:43.623] opt = [05:40:43.623] status = [05:40:43.623] #26 0x0000000000795c65 in main (argc=4, argv=0x82166ffd8) at ../src/backend/main/main.c:197 [05:40:43.623] do_check_root =