[13:12:01.934] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [13:12:02.342] dumping /tmp/cores/postgres.8730.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:12:02.490] [New LWP 101735] [13:12:02.588] Core was generated by `postgres: postgres regression [local] MERGE'. [13:12:02.588] Program terminated with signal SIGABRT, Aborted. [13:12:02.588] Sent by thr_kill() from pid 8730 and user 1003. [13:12:02.588] #0 0x000000082ccf8dca in thr_kill () from /lib/libc.so.7 [13:12:03.235] [13:12:03.235] Thread 1 (LWP 101735): [13:12:03.235] #0 0x000000082ccf8dca in thr_kill () from /lib/libc.so.7 [13:12:03.235] No symbol table info available. [13:12:03.235] #1 0x000000082cc716f4 in raise () from /lib/libc.so.7 [13:12:03.235] No symbol table info available. [13:12:03.235] #2 0x000000082cd22bc9 in abort () from /lib/libc.so.7 [13:12:03.235] No symbol table info available. [13:12:03.235] #3 0x0000000000a5fcf7 in ExceptionalCondition (conditionName=, fileName=0x372fdf "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:12:03.235] No locals. [13:12:03.235] #4 0x0000000000742b50 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82116e890, materialize=, shouldFree=shouldFree@entry=0x82116e856) at ../src/backend/executor/execTuples.c:1737 [13:12:03.235] No locals. [13:12:03.235] #5 0x00000000007084e8 in ExecIRDeleteTriggers (estate=estate@entry=0x834dae100, relinfo=relinfo@entry=0x834dae6b0, slot=slot@entry=0x82116e890) at ../src/backend/commands/trigger.c:2832 [13:12:03.235] trigger = [13:12:03.235] oldtuple = [13:12:03.235] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x840398f90, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:12:03.235] trigdesc = 0x834dae8c0 [13:12:03.235] newtuple = 0x0 [13:12:03.235] i = 0 [13:12:03.235] should_free = false [13:12:03.235] #6 0x0000000000767c47 in ExecMergeMatched (context=0x82116e930, resultRelInfo=0x834dae6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [13:12:03.235] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:12:03.235] relaction = 0x840459a20 [13:12:03.235] commandType = CMD_DELETE [13:12:03.235] result = TM_Ok [13:12:03.235] l__state = {l = 0x8404ca9c8, i = 0} [13:12:03.235] mtstate = 0x834dae4a0 [13:12:03.235] newslot = 0x0 [13:12:03.235] rslot = 0x0 [13:12:03.235] estate = 0x18d67 [13:12:03.235] mergeActions = [13:12:03.235] econtext = 0x8404c9a68 [13:12:03.235] epqstate = 0x834dae588 [13:12:03.235] actionStates = 0x8404ca9c8 [13:12:03.235] l = [13:12:03.235] isNull = [13:12:03.235] lmerge_matched = [13:12:03.235] __error = [13:12:03.235] l__state = [13:12:03.235] updateCxt = [13:12:03.235] relaction = [13:12:03.235] commandType = [13:12:03.235] result = [13:12:03.235] __error = [13:12:03.235] resultRelationDesc = [13:12:03.235] lockmode = [13:12:03.235] inputslot = [13:12:03.235] epqslot = [13:12:03.235] was_matched = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] #7 ExecMerge (context=0x82116e930, resultRelInfo=0x834dae6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [13:12:03.235] matched = [13:12:03.235] rslot = 0x0 [13:12:03.235] #8 ExecModifyTable (pstate=0x834dae4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [13:12:03.235] context = {mtstate = 0x834dae4a0, epqstate = 0x834dae588, estate = 0x834dae100, planSlot = 0x840459990, tmfd = {ctid = {ip_blkid = {bi_hi = 59760, bi_lo = 8470}, ip_posid = 8}, xmax = 1078764232, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x8404f5a78} [13:12:03.235] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [13:12:03.235] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834dc2118} [13:12:03.235] node = 0x834dae4a0 [13:12:03.235] estate = 0x834dae100 [13:12:03.235] operation = CMD_MERGE [13:12:03.235] resultRelInfo = 0x834dae6b0 [13:12:03.235] subplanstate = 0x834dafdf0 [13:12:03.235] slot = [13:12:03.235] tupleid = 0x0 [13:12:03.235] oldtuple = 0x0 [13:12:03.235] oldSlot = [13:12:03.235] #9 0x000000000073cb8b in ExecProcNodeFirst (node=0x834dae4a0) at ../src/backend/executor/execProcnode.c:464 [13:12:03.235] No locals. [13:12:03.235] #10 0x0000000000734e7a in ExecProcNode (node=0x834dae4a0) at ../src/include/executor/executor.h:274 [13:12:03.235] No locals. [13:12:03.235] #11 ExecutePlan (estate=0x834dae100, planstate=0x834dae4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x834ce5310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [13:12:03.235] current_tuple_count = [13:12:03.235] slot = [13:12:03.235] #12 standard_ExecutorRun (queryDesc=0x834c90448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [13:12:03.235] estate = 0x834dae100 [13:12:03.235] oldcontext = 0x834ce5000 [13:12:03.235] operation = CMD_MERGE [13:12:03.235] dest = 0x834ce5310 [13:12:03.235] sendTuples = true [13:12:03.235] #13 0x0000000000734d2f in ExecutorRun (queryDesc=0x18d67, queryDesc@entry=0x834c90448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [13:12:03.235] No locals. [13:12:03.235] #14 0x000000000090d4df in ProcessQuery (plan=0x8404f5360, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82116eb68) at ../src/backend/tcop/pquery.c:160 [13:12:03.235] queryDesc = 0x834c90448 [13:12:03.235] #15 0x000000000090ca7d in PortalRunMulti (portal=portal@entry=0x834cc3100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x834ce5310, altdest=0xb53da0 , qc=qc@entry=0x82116eb68) at ../src/backend/tcop/pquery.c:1286 [13:12:03.235] pstmt = 0x8404f5360 [13:12:03.235] stmtlist_item__state = {l = 0x8404f9c18, i = 0} [13:12:03.235] active_snapshot_set = true [13:12:03.235] stmtlist_item = 0x8404f9c30 [13:12:03.235] #16 0x000000000090c56c in FillPortalStore (portal=portal@entry=0x834cc3100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [13:12:03.235] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:12:03.235] treceiver = 0x834ce5310 [13:12:03.235] #17 0x000000000090c2c0 in PortalRun (portal=portal@entry=0x834cc3100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8404f9c68, altdest=altdest@entry=0x8404f9c68, qc=0x82116eca0) at ../src/backend/tcop/pquery.c:763 [13:12:03.235] _local_sigjmp_buf = {{_sjb = {9486943, 35245587992, 34914888600, 34914888832, 34914888608, 12175544, 12143328, 35245535488, 7112098687, 35245543680, 3579454, 34359738368}}} [13:12:03.235] _save_exception_stack = 0x82116ed70 [13:12:03.235] _save_context_stack = 0x0 [13:12:03.235] _do_rethrow = false [13:12:03.235] saveTopTransactionResourceOwner = 0x834ccfe18 [13:12:03.235] saveTopTransactionContext = 0x834bf9000 [13:12:03.235] saveActivePortal = 0x0 [13:12:03.235] saveResourceOwner = 0x834ccfe18 [13:12:03.235] savePortalContext = 0x0 [13:12:03.235] saveMemoryContext = 0x834bf9000 [13:12:03.235] result = [13:12:03.235] nprocessed = [13:12:03.235] #18 0x000000000090b1cb in exec_simple_query (query_string=query_string@entry=0x834bed100 "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 [13:12:03.235] cmdtaglen = [13:12:03.235] snapshot_set = [13:12:03.235] per_parsetree_context = 0x0 [13:12:03.235] plantree_list = [13:12:03.235] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:12:03.235] parsetree = 0x840497ea8 [13:12:03.235] commandTag = CMDTAG_MERGE [13:12:03.235] cmdtagname = [13:12:03.235] querytree_list = [13:12:03.235] portal = 0x834cc3100 [13:12:03.235] format = 0 [13:12:03.235] receiver = 0x8404f9c68 [13:12:03.235] parsetree_item__state = {l = 0x840499770, i = 0} [13:12:03.235] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [13:12:03.235] dest = DestRemote [13:12:03.235] was_logged = [13:12:03.235] oldcontext = 0x834bf9000 [13:12:03.235] parsetree_list = 0x840499770 [13:12:03.235] use_implicit_block = false [13:12:03.235] parsetree_item = 0x840499788 [13:12:03.235] save_log_statement_stats = [13:12:03.235] #19 0x0000000000908fa4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [13:12:03.235] query_string = 0x834bed100 "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"... [13:12:03.235] input_message = {data = 0x834bed100 "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} [13:12:03.235] firstchar = [13:12:03.235] local_sigjmp_buf = {{_sjb = {9471088, 34914889072, 34914889032, 34914889632, 12184280, 12130752, 8192, 8388608, 72057628952757119, 0, 0, 34359738369}}} [13:12:03.235] send_ready_for_query = false [13:12:03.235] idle_in_transaction_timeout_enabled = false [13:12:03.235] idle_session_timeout_enabled = false [13:12:03.235] #20 0x0000000000903a79 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [13:12:03.235] bsdata = [13:12:03.235] #21 0x000000000085dc12 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82116fab0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82116f9f8) at ../src/backend/postmaster/launch_backend.c:265 [13:12:03.235] pid = [13:12:03.235] #22 0x0000000000862571 in BackendStartup (client_sock=0x82116f9f8) at ../src/backend/postmaster/postmaster.c:3593 [13:12:03.235] startup_data = {canAcceptConnections = CAC_OK} [13:12:03.235] bn = 0x834bf92b8 [13:12:03.235] pid = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] save_errno = [13:12:03.235] __error = [13:12:03.235] __error = [13:12:03.235] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [13:12:03.235] 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' , "P\372\026!\b\000\000\000\330u[+\b\000\000\000\v\000\000\000\000\000\000\000\016\366[+\b", '\000' , "\220\372\026!\b\000\000\000\344م\000\000\000\000\000\240\372\026!\b", '\000' }, salen = 16}} [13:12:03.235] i = 0 [13:12:03.235] now = [13:12:03.235] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 750656612, events = 8, fd = 555151424, user_data = 0x82116f1d0}, {pos = 567358472, events = 8, fd = 32, user_data = 0x82116f1c0}, {pos = 1754409620, events = 15448, fd = 567328776, user_data = 0x821d0c408}, {pos = 567330824, events = 8, fd = 567331848, user_data = 0x821d10008}, {pos = 567346184, events = 8, fd = 567347208, user_data = 0x821d10c08}, {pos = 567349256, events = 8, fd = 567350280, user_data = 0x821d11808}, {pos = 567352328, events = 8, fd = 567353352, user_data = 0x821d12408}, {pos = 567355400, events = 8, fd = 567356424, user_data = 0x821d13008}, {pos = 567358472, events = 8, fd = -1, user_data = 0x82cdb92e0}, {pos = 555151664, events = 8, fd = 752247209, user_data = 0x0}, {pos = 4096, events = 0, fd = 1448658695, user_data = 0x82cdb97e8}, {pos = 876649440, events = 8, fd = 160, user_data = 0x0}, {pos = 852582544, events = 8, fd = 555151872, user_data = 0x82cd4492c}, {pos = 4096, events = 0, fd = 750672228, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 567384632, user_data = 0x800000001}, {pos = 567358472, events = 8, fd = 750586072, user_data = 0x82116f288}, {pos = 555151424, events = 8, fd = 32, user_data = 0x82cbe1c64}, {pos = 567358472, events = 8, fd = 567384632, user_data = 0x0}, {pos = 2625, events = 0, fd = 555151984, user_data = 0x3c5868922645}, {pos = 750672228, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 567384632, events = 8, fd = 1, user_data = 0x821d13408}, {pos = 884854784, events = 8, fd = 1, user_data = 0x834bdd194}, {pos = 0, events = 0, fd = 555151936, user_data = 0x82b5bec0c}, {pos = 1, events = 0, fd = 884854784, user_data = 0x82116f270}, {pos = 727441076, events = 8, fd = 752398688, user_data = 0x82cd8b160 }, {pos = 750768320, events = 8, fd = 567358472, user_data = 0x82116f350}, {pos = 1754407980, events = 15448, fd = 852582544, user_data = 0x800000001}, {pos = 1754407598, events = 15448, fd = 12240, user_data = 0x82116f278}, {pos = 555152208, events = 8, fd = 885561320, user_data = 0x82116f8c0}, {pos = 1754488464, events = 15448, fd = 567358472, user_data = 0x82116037f}, {pos = 752055708, events = 8, fd = 567328776, user_data = 0x0}, {pos = 567358472, events = 8, fd = 12240, user_data = 0x82cbc1000}, {pos = 1964368, events = 0, fd = 752398688, user_data = 0x82cbe1c64}, {pos = 15616, events = 0, fd = 555153392, user_data = 0x82116f3c0}, {pos = 751329678, events = 8, fd = 752437304, user_data = 0x82116f384}, {pos = 885298650, events = 8, fd = 555153392, user_data = 0x82116f3c0}, {pos = 751420933, events = 8, fd = 555152258, user_data = 0x82116f7f0}, {pos = 555153392, events = 8, fd = 0, user_data = 0xd3acf9935658c707}, {pos = 555153392, events = 8, fd = 885298648, user_data = 0x82116f8c0}, {pos = 752437304, events = 8, fd = 0, user_data = 0x82116f830}, {pos = 751421197, events = 8, fd = 0, user_data = 0x0}, {pos = 555153760, events = 8, fd = 885298648, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1754436617, events = 15448, fd = 555152664, user_data = 0x82cbe1c64}, {pos = 2503, events = 0, fd = 1754436617, user_data = 0x82116f538}, {pos = 750656612, events = 8, fd = 2758, user_data = 0x82cbdb120}, {pos = 555152568, events = 8, fd = 567358472, user_data = 0x82116f538}, {pos = 750629152, events = 8, fd = 555152672, user_data = 0x3c5868924465}, {pos = 0, events = 0, fd = 0, user_data = 0x82cdad0f0}, {pos = 750589264, events = 8, fd = 0, user_data = 0x0}, {pos = 752466352, events = 8, fd = 1754436617, user_data = 0x82116f5c8}, {pos = 750656612, events = 8, fd = 2924, user_data = 0x82cbdb3b8}, {pos = 555152712, events = 8, fd = 567358472, user_data = 0x82116f5c8}, {pos = 750629816, events = 8, fd = 555152816, user_data = 0x3c5868924465}, {pos = 567382072, events = 8, fd = 2675674, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567358472, events = 8, fd = 750589264, user_data = 0x82116f888}, {pos = 567358472, events = 8, fd = 555153256, user_data = 0x1e}, {pos = 750593248, events = 8, fd = 555152984, user_data = 0x821d18248}, {pos = 555153432, events = 8, fd = 555152960, user_data = 0x3c5868928da3}, {pos = 567382072, events = 8, fd = 2699362, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 567382072, user_data = 0x1}} [13:12:03.235] last_touch_time = 1712840945 [13:12:03.235] last_lockfile_recheck_time = 1712840945 [13:12:03.235] nevents = 1 [13:12:03.235] #24 0x000000000085fe46 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82116fff0) at ../src/backend/postmaster/postmaster.c:1372 [13:12:03.235] userDoption = [13:12:03.235] listen_addr_saved = false [13:12:03.235] output_config_variable = [13:12:03.235] opt = [13:12:03.235] status = [13:12:03.235] #25 0x0000000000797ec5 in main (argc=8, argv=0x82116fff0) at ../src/backend/main/main.c:197 [13:12:03.235] do_check_root = [13:12:03.246] [13:12:03.246] [13:12:03.246] [13:12:03.313] dumping /tmp/cores/postgres.9159.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:12:03.450] [New LWP 100166] [13:12:03.522] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [13:12:03.522] Program terminated with signal SIGABRT, Aborted. [13:12:03.522] Sent by thr_kill() from pid 9159 and user 1003. [13:12:03.522] #0 0x000000082a608dca in thr_kill () from /lib/libc.so.7 [13:12:04.139] [13:12:04.139] Thread 1 (LWP 100166): [13:12:04.139] #0 0x000000082a608dca in thr_kill () from /lib/libc.so.7 [13:12:04.139] No symbol table info available. [13:12:04.139] #1 0x000000082a5816f4 in raise () from /lib/libc.so.7 [13:12:04.139] No symbol table info available. [13:12:04.139] #2 0x000000082a632bc9 in abort () from /lib/libc.so.7 [13:12:04.139] No symbol table info available. [13:12:04.139] #3 0x0000000000a5fcf7 in ExceptionalCondition (conditionName=, fileName=0x372fdf "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:12:04.139] No locals. [13:12:04.139] #4 0x0000000000742b50 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820d3e380, materialize=, shouldFree=shouldFree@entry=0x820d3e346) at ../src/backend/executor/execTuples.c:1737 [13:12:04.139] No locals. [13:12:04.139] #5 0x00000000007084e8 in ExecIRDeleteTriggers (estate=estate@entry=0x8377db100, relinfo=relinfo@entry=0x8377db6b0, slot=slot@entry=0x820d3e380) at ../src/backend/commands/trigger.c:2832 [13:12:04.139] trigger = [13:12:04.139] oldtuple = [13:12:04.139] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8450826a8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:12:04.139] trigdesc = 0x8377db8c0 [13:12:04.139] newtuple = 0x0 [13:12:04.139] i = 0 [13:12:04.139] should_free = false [13:12:04.139] #6 0x0000000000767c47 in ExecMergeMatched (context=0x820d3e420, resultRelInfo=0x8377db6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [13:12:04.139] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:12:04.139] relaction = 0x84510d320 [13:12:04.139] commandType = CMD_DELETE [13:12:04.139] result = TM_Ok [13:12:04.139] l__state = {l = 0x845183f88, i = 0} [13:12:04.139] mtstate = 0x8377db4a0 [13:12:04.139] newslot = 0x0 [13:12:04.139] rslot = 0x0 [13:12:04.139] estate = 0x18746 [13:12:04.139] mergeActions = [13:12:04.139] econtext = 0x845183028 [13:12:04.139] epqstate = 0x8377db588 [13:12:04.139] actionStates = 0x845183f88 [13:12:04.139] l = [13:12:04.139] isNull = [13:12:04.139] lmerge_matched = [13:12:04.139] __error = [13:12:04.139] l__state = [13:12:04.139] updateCxt = [13:12:04.139] relaction = [13:12:04.139] commandType = [13:12:04.139] result = [13:12:04.139] __error = [13:12:04.139] resultRelationDesc = [13:12:04.139] lockmode = [13:12:04.139] inputslot = [13:12:04.139] epqslot = [13:12:04.139] was_matched = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] #7 ExecMerge (context=0x820d3e420, resultRelInfo=0x8377db6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [13:12:04.139] matched = [13:12:04.139] rslot = 0x0 [13:12:04.139] #8 ExecModifyTable (pstate=0x8377db4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [13:12:04.139] context = {mtstate = 0x8377db4a0, epqstate = 0x8377db588, estate = 0x8377db100, planSlot = 0x84510d290, tmfd = {ctid = {ip_blkid = {bi_hi = 58464, bi_lo = 8403}, ip_posid = 8}, xmax = 1159215240, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x8451b0ff8} [13:12:04.139] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [13:12:04.139] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8377ef118} [13:12:04.139] node = 0x8377db4a0 [13:12:04.139] estate = 0x8377db100 [13:12:04.139] operation = CMD_MERGE [13:12:04.139] resultRelInfo = 0x8377db6b0 [13:12:04.139] subplanstate = 0x8377dcdf0 [13:12:04.139] slot = [13:12:04.139] tupleid = 0x0 [13:12:04.139] oldtuple = 0x0 [13:12:04.139] oldSlot = [13:12:04.139] #9 0x000000000073cb8b in ExecProcNodeFirst (node=0x8377db4a0) at ../src/backend/executor/execProcnode.c:464 [13:12:04.139] No locals. [13:12:04.139] #10 0x0000000000734e7a in ExecProcNode (node=0x8377db4a0) at ../src/include/executor/executor.h:274 [13:12:04.139] No locals. [13:12:04.139] #11 ExecutePlan (estate=0x8377db100, planstate=0x8377db4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x837673b10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [13:12:04.139] current_tuple_count = [13:12:04.139] slot = [13:12:04.139] #12 standard_ExecutorRun (queryDesc=0x8376f5448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [13:12:04.139] estate = 0x8377db100 [13:12:04.139] oldcontext = 0x837673800 [13:12:04.139] operation = CMD_MERGE [13:12:04.139] dest = 0x837673b10 [13:12:04.139] sendTuples = true [13:12:04.139] #13 0x0000000000734d2f in ExecutorRun (queryDesc=0x18746, queryDesc@entry=0x8376f5448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [13:12:04.139] No locals. [13:12:04.139] #14 0x000000000090d4df in ProcessQuery (plan=0x8451b08e0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820d3e658) at ../src/backend/tcop/pquery.c:160 [13:12:04.139] queryDesc = 0x8376f5448 [13:12:04.139] #15 0x000000000090ca7d in PortalRunMulti (portal=portal@entry=0x8376d5100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x837673b10, altdest=0xb53da0 , qc=qc@entry=0x820d3e658) at ../src/backend/tcop/pquery.c:1286 [13:12:04.139] pstmt = 0x8451b08e0 [13:12:04.139] stmtlist_item__state = {l = 0x8451b5198, i = 0} [13:12:04.139] active_snapshot_set = true [13:12:04.139] stmtlist_item = 0x8451b51b0 [13:12:04.139] #16 0x000000000090c56c in FillPortalStore (portal=portal@entry=0x8376d5100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [13:12:04.139] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:12:04.139] treceiver = 0x837673b10 [13:12:04.139] #17 0x000000000090c2c0 in PortalRun (portal=portal@entry=0x8376d5100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8451b51e8, altdest=altdest@entry=0x8451b51e8, qc=0x820d3e790) at ../src/backend/tcop/pquery.c:763 [13:12:04.139] _local_sigjmp_buf = {{_sjb = {9486943, 35289955608, 34910496392, 34910496624, 34910496400, 12175544, 12143328, 35289649408, 7112098687, 35289657600, 3579454, 34359738368}}} [13:12:04.139] _save_exception_stack = 0x820d3e860 [13:12:04.139] _save_context_stack = 0x0 [13:12:04.139] _do_rethrow = false [13:12:04.139] saveTopTransactionResourceOwner = 0x83771fd18 [13:12:04.139] saveTopTransactionContext = 0x837648000 [13:12:04.139] saveActivePortal = 0x0 [13:12:04.139] saveResourceOwner = 0x83771fd18 [13:12:04.139] savePortalContext = 0x0 [13:12:04.139] saveMemoryContext = 0x837648000 [13:12:04.139] result = [13:12:04.139] nprocessed = [13:12:04.139] #18 0x000000000090b1cb in exec_simple_query (query_string=query_string@entry=0x83763c100 "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 [13:12:04.139] cmdtaglen = [13:12:04.139] snapshot_set = [13:12:04.139] per_parsetree_context = 0x0 [13:12:04.139] plantree_list = [13:12:04.139] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:12:04.139] parsetree = 0x8451510e8 [13:12:04.139] commandTag = CMDTAG_MERGE [13:12:04.139] cmdtagname = [13:12:04.139] querytree_list = [13:12:04.139] portal = 0x8376d5100 [13:12:04.139] format = 0 [13:12:04.139] receiver = 0x8451b51e8 [13:12:04.139] parsetree_item__state = {l = 0x8451529b0, i = 0} [13:12:04.139] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [13:12:04.139] dest = DestRemote [13:12:04.139] was_logged = [13:12:04.139] oldcontext = 0x837648000 [13:12:04.139] parsetree_list = 0x8451529b0 [13:12:04.139] use_implicit_block = false [13:12:04.139] parsetree_item = 0x8451529c8 [13:12:04.139] save_log_statement_stats = [13:12:04.139] #19 0x0000000000908fa4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [13:12:04.139] query_string = 0x83763c100 "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"... [13:12:04.139] input_message = {data = 0x83763c100 "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} [13:12:04.139] firstchar = [13:12:04.139] local_sigjmp_buf = {{_sjb = {9471088, 34910496864, 34910496824, 34910497424, 12184280, 12130752, 8192, 8388608, 72057628948366207, 0, 0, 34359738369}}} [13:12:04.139] send_ready_for_query = false [13:12:04.139] idle_in_transaction_timeout_enabled = false [13:12:04.139] idle_session_timeout_enabled = false [13:12:04.139] #20 0x0000000000903a79 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [13:12:04.139] bsdata = [13:12:04.139] #21 0x000000000085dc12 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d3f5a0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d3f4e8) at ../src/backend/postmaster/launch_backend.c:265 [13:12:04.139] pid = [13:12:04.139] #22 0x0000000000862571 in BackendStartup (client_sock=0x820d3f4e8) at ../src/backend/postmaster/postmaster.c:3593 [13:12:04.139] startup_data = {canAcceptConnections = CAC_OK} [13:12:04.139] bn = 0x837648308 [13:12:04.139] pid = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] save_errno = [13:12:04.139] __error = [13:12:04.139] __error = [13:12:04.139] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [13:12:04.139] 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' , "@\365\323 \b\000\000\000\330\025\375)\b\000\000\000\v\000\000\000\000\000\000\000\016\226\375)\b", '\000' , "\200\365\323 \b\000\000\000\344م\000\000\000\000\000\220\365\323 \b", '\000' }, salen = 16}} [13:12:04.139] i = 0 [13:12:04.139] now = [13:12:04.139] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 709827684, events = 8, fd = 550759216, user_data = 0x820d3ecc0}, {pos = 558294024, events = 8, fd = 32, user_data = 0x820d3ecb0}, {pos = 1872702100, events = 11245, fd = 558264328, user_data = 0x821467408}, {pos = 558266376, events = 8, fd = 558267400, user_data = 0x82146b008}, {pos = 558281736, events = 8, fd = 558282760, user_data = 0x82146bc08}, {pos = 558284808, events = 8, fd = 558285832, user_data = 0x82146c808}, {pos = 558287880, events = 8, fd = 558288904, user_data = 0x82146d408}, {pos = 558290952, events = 8, fd = 558291976, user_data = 0x82146e008}, {pos = 558294024, events = 8, fd = 558313608, user_data = 0x820d3ee38}, {pos = 550759520, events = 8, fd = 1872727459, user_data = 0x0}, {pos = 2571794, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 558317624, events = 8, fd = 1, user_data = 0x82146e408}, {pos = 709735592, events = 8, fd = 550760248, user_data = 0x82146e408}, {pos = 550759504, events = 0, fd = 709843300, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 558320184, user_data = 0x1}, {pos = 558294024, events = 8, fd = 709757144, user_data = 0x820d3ed78}, {pos = 550759216, events = 8, fd = 32, user_data = 0x82a4f1c64}, {pos = 558294024, events = 8, fd = 558320184, user_data = 0x0}, {pos = 2625, events = 0, fd = 550759776, user_data = 0x2bed6f9f2645}, {pos = 709843300, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 558320184, events = 8, fd = 1, user_data = 0x82146e408}, {pos = 929218560, events = 8, fd = 1, user_data = 0x83762c194}, {pos = 0, events = 0, fd = 550759728, user_data = 0x829fd8c0c}, {pos = 1, events = 0, fd = 929218560, user_data = 0x820d3ed60}, {pos = 704478900, events = 8, fd = 711569760, user_data = 0x82a69b160 }, {pos = 709939392, events = 8, fd = 558294024, user_data = 0x820d3ee40}, {pos = 1872700460, events = 11245, fd = 558293000, user_data = 0x800000001}, {pos = 1872700078, events = 11245, fd = 12240, user_data = 0x820d3ed68}, {pos = 550760000, events = 8, fd = 930015208, user_data = 0x820d3f3b0}, {pos = 1872780944, events = 11245, fd = 558294024, user_data = 0x820d3037f}, {pos = 711226546, events = 8, fd = 558264328, user_data = 0x0}, {pos = 558294024, events = 8, fd = 12240, user_data = 0x82a4d1000}, {pos = 1964368, events = 0, fd = 711569760, user_data = 0x82a4f1c64}, {pos = 15616, events = 0, fd = 550761184, user_data = 0x820d3eeb0}, {pos = 710500750, events = 8, fd = 711608376, user_data = 0x820d3ee74}, {pos = 929670618, events = 8, fd = 550761184, user_data = 0x820d3eeb0}, {pos = 710592005, events = 8, fd = 550760050, user_data = 0x820d3f2e0}, {pos = 550761184, events = 8, fd = 0, user_data = 0xbb98a4c02c67294f}, {pos = 550761184, events = 8, fd = 929670616, user_data = 0x820d3f3b0}, {pos = 711608376, events = 8, fd = 0, user_data = 0x820d3f320}, {pos = 710592269, events = 8, fd = 0, user_data = 0x0}, {pos = 550761552, events = 8, fd = 929670616, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1872729097, events = 11245, fd = 550760456, user_data = 0x82a4f1c64}, {pos = 2503, events = 0, fd = 1872729097, user_data = 0x820d3f028}, {pos = 709827684, events = 8, fd = 2758, user_data = 0x82a4eb120}, {pos = 550760360, events = 8, fd = 558294024, user_data = 0x820d3f028}, {pos = 709800224, events = 8, fd = 550760464, user_data = 0x2bed6f9f4465}, {pos = 0, events = 0, fd = 0, user_data = 0x82a6bd0f0}, {pos = 709760336, events = 8, fd = 0, user_data = 0x0}, {pos = 711637424, events = 8, fd = 1872729097, user_data = 0x820d3f0b8}, {pos = 709827684, events = 8, fd = 2924, user_data = 0x82a4eb3b8}, {pos = 550760504, events = 8, fd = 558294024, user_data = 0x820d3f0b8}, {pos = 709800888, events = 8, fd = 550760608, user_data = 0x2bed6f9f4465}, {pos = 558317624, events = 8, fd = 2675674, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 558294024, events = 8, fd = 709760336, user_data = 0x820d3f378}, {pos = 558294024, events = 8, fd = 550761048, user_data = 0x1e}, {pos = 709764320, events = 8, fd = 550760776, user_data = 0x821473248}, {pos = 550761224, events = 8, fd = 550760752, user_data = 0x2bed6f9f8da3}, {pos = 558317624, events = 8, fd = 2699362, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 558317624, user_data = 0x1}} [13:12:04.140] last_touch_time = 1712840947 [13:12:04.140] last_lockfile_recheck_time = 1712840947 [13:12:04.140] nevents = 1 [13:12:04.140] #24 0x000000000085fe46 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820d3fae8) at ../src/backend/postmaster/postmaster.c:1372 [13:12:04.140] userDoption = [13:12:04.140] listen_addr_saved = false [13:12:04.140] output_config_variable = [13:12:04.140] opt = [13:12:04.140] status = [13:12:04.140] #25 0x0000000000797ec5 in main (argc=4, argv=0x820d3fae8) at ../src/backend/main/main.c:197 [13:12:04.140] do_check_root = [13:12:04.153] [13:12:04.153] [13:12:04.153] [13:12:04.219] dumping /tmp/cores/postgres.14346.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:12:04.356] [New LWP 100112] [13:12:04.431] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [13:12:04.431] Program terminated with signal SIGABRT, Aborted. [13:12:04.431] Sent by thr_kill() from pid 14346 and user 1003. [13:12:04.431] #0 0x000000082b0efdca in thr_kill () from /lib/libc.so.7 [13:12:05.047] [13:12:05.047] Thread 1 (LWP 100112): [13:12:05.047] #0 0x000000082b0efdca in thr_kill () from /lib/libc.so.7 [13:12:05.047] No symbol table info available. [13:12:05.047] #1 0x000000082b0686f4 in raise () from /lib/libc.so.7 [13:12:05.047] No symbol table info available. [13:12:05.047] #2 0x000000082b119bc9 in abort () from /lib/libc.so.7 [13:12:05.047] No symbol table info available. [13:12:05.047] #3 0x0000000000a5fcf7 in ExceptionalCondition (conditionName=, fileName=0x372fdf "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:12:05.047] No locals. [13:12:05.047] #4 0x0000000000742b50 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821a384f0, materialize=, shouldFree=shouldFree@entry=0x821a384b6) at ../src/backend/executor/execTuples.c:1737 [13:12:05.047] No locals. [13:12:05.047] #5 0x00000000007084e8 in ExecIRDeleteTriggers (estate=estate@entry=0x83848e100, relinfo=relinfo@entry=0x83848e6b0, slot=slot@entry=0x821a384f0) at ../src/backend/commands/trigger.c:2832 [13:12:05.047] trigger = [13:12:05.047] oldtuple = [13:12:05.047] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83a80e770, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:12:05.047] trigdesc = 0x83848e8c0 [13:12:05.047] newtuple = 0x0 [13:12:05.047] i = 0 [13:12:05.047] should_free = false [13:12:05.047] #6 0x0000000000767c47 in ExecMergeMatched (context=0x821a38590, resultRelInfo=0x83848e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [13:12:05.047] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:12:05.047] relaction = 0x8384442e0 [13:12:05.047] commandType = CMD_DELETE [13:12:05.047] result = TM_Ok [13:12:05.047] l__state = {l = 0x83a95d888, i = 0} [13:12:05.047] mtstate = 0x83848e4a0 [13:12:05.047] newslot = 0x0 [13:12:05.047] rslot = 0x0 [13:12:05.047] estate = 0x18710 [13:12:05.047] mergeActions = [13:12:05.047] econtext = 0x83a95c928 [13:12:05.047] epqstate = 0x83848e588 [13:12:05.047] actionStates = 0x83a95d888 [13:12:05.047] l = [13:12:05.047] isNull = [13:12:05.047] lmerge_matched = [13:12:05.047] __error = [13:12:05.047] l__state = [13:12:05.047] updateCxt = [13:12:05.047] relaction = [13:12:05.047] commandType = [13:12:05.047] result = [13:12:05.047] __error = [13:12:05.047] resultRelationDesc = [13:12:05.047] lockmode = [13:12:05.047] inputslot = [13:12:05.047] epqslot = [13:12:05.047] was_matched = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] #7 ExecMerge (context=0x821a38590, resultRelInfo=0x83848e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [13:12:05.047] matched = [13:12:05.047] rslot = 0x0 [13:12:05.047] #8 ExecModifyTable (pstate=0x83848e4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [13:12:05.047] context = {mtstate = 0x83848e4a0, epqstate = 0x83848e588, estate = 0x83848e100, planSlot = 0x838444250, tmfd = {ctid = {ip_blkid = {bi_hi = 18382, bi_lo = 8956}, ip_posid = 63720}, xmax = 4, cmax = 0, traversed = 208}, cpUpdateReturningSlot = 0x821a386f0} [13:12:05.047] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [13:12:05.047] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83849a118} [13:12:05.047] node = 0x83848e4a0 [13:12:05.047] estate = 0x83848e100 [13:12:05.047] operation = CMD_MERGE [13:12:05.047] resultRelInfo = 0x83848e6b0 [13:12:05.047] subplanstate = 0x83848fdf0 [13:12:05.047] slot = [13:12:05.047] tupleid = 0x0 [13:12:05.047] oldtuple = 0x0 [13:12:05.047] oldSlot = [13:12:05.047] #9 0x000000000073cb8b in ExecProcNodeFirst (node=0x83848e4a0) at ../src/backend/executor/execProcnode.c:464 [13:12:05.047] No locals. [13:12:05.047] #10 0x0000000000734e7a in ExecProcNode (node=0x83848e4a0) at ../src/include/executor/executor.h:274 [13:12:05.047] No locals. [13:12:05.047] #11 ExecutePlan (estate=0x83848e100, planstate=0x83848e4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x8383ce310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [13:12:05.047] current_tuple_count = [13:12:05.047] slot = [13:12:05.047] #12 standard_ExecutorRun (queryDesc=0x83838b448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [13:12:05.047] estate = 0x83848e100 [13:12:05.047] oldcontext = 0x8383ce000 [13:12:05.047] operation = CMD_MERGE [13:12:05.047] dest = 0x8383ce310 [13:12:05.047] sendTuples = true [13:12:05.047] #13 0x000000083a3b8963 in pgss_ExecutorRun (queryDesc=0x83838b448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [13:12:05.047] _local_sigjmp_buf = {{_sjb = {35336718642, 12175544, 34924103400, 34924103568, 35302978632, 34924103408, 1, 1, 35303981951, 35302978632, 12184272, 34359738368}}} [13:12:05.047] _save_exception_stack = 0x821a388b0 [13:12:05.047] _save_context_stack = 0x0 [13:12:05.047] _do_rethrow = false [13:12:05.047] #14 0x0000000000734d28 in ExecutorRun (queryDesc=0x18710, queryDesc@entry=0x83838b448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [13:12:05.047] No locals. [13:12:05.047] #15 0x000000000090d4df in ProcessQuery (plan=0x83a9209c0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821a38878) at ../src/backend/tcop/pquery.c:160 [13:12:05.047] queryDesc = 0x83838b448 [13:12:05.047] #16 0x000000000090ca7d in PortalRunMulti (portal=portal@entry=0x83836d100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8383ce310, altdest=0xb53da0 , qc=qc@entry=0x821a38878) at ../src/backend/tcop/pquery.c:1286 [13:12:05.047] pstmt = 0x83a9209c0 [13:12:05.047] stmtlist_item__state = {l = 0x83a925278, i = 0} [13:12:05.047] active_snapshot_set = true [13:12:05.047] stmtlist_item = 0x83a925290 [13:12:05.047] #17 0x000000000090c56c in FillPortalStore (portal=portal@entry=0x83836d100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [13:12:05.047] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:12:05.047] treceiver = 0x8383ce310 [13:12:05.047] #18 0x000000000090c2c0 in PortalRun (portal=portal@entry=0x83836d100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83a9252c8, altdest=altdest@entry=0x83a9252c8, qc=0x821a389b0) at ../src/backend/tcop/pquery.c:763 [13:12:05.047] _local_sigjmp_buf = {{_sjb = {9486943, 35303187736, 34924103848, 34924104080, 34924103856, 12175544, 12143328, 35302854912, 7112098687, 35302863104, 3579454, 34359738368}}} [13:12:05.047] _save_exception_stack = 0x821a38a80 [13:12:05.047] _save_context_stack = 0x0 [13:12:05.047] _do_rethrow = false [13:12:05.047] saveTopTransactionResourceOwner = 0x8383be518 [13:12:05.047] saveTopTransactionContext = 0x8382de000 [13:12:05.047] saveActivePortal = 0x0 [13:12:05.047] saveResourceOwner = 0x8383be518 [13:12:05.047] savePortalContext = 0x0 [13:12:05.047] saveMemoryContext = 0x8382de000 [13:12:05.047] result = [13:12:05.047] nprocessed = [13:12:05.047] #19 0x000000000090b1cb in exec_simple_query (query_string=query_string@entry=0x8382d2100 "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 [13:12:05.047] cmdtaglen = [13:12:05.047] snapshot_set = [13:12:05.047] per_parsetree_context = 0x0 [13:12:05.047] plantree_list = [13:12:05.047] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:12:05.047] parsetree = 0x83a8fcb28 [13:12:05.047] commandTag = CMDTAG_MERGE [13:12:05.047] cmdtagname = [13:12:05.047] querytree_list = [13:12:05.047] portal = 0x83836d100 [13:12:05.047] format = 0 [13:12:05.047] receiver = 0x83a9252c8 [13:12:05.047] parsetree_item__state = {l = 0x83a8fe3f0, i = 0} [13:12:05.047] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [13:12:05.047] dest = DestRemote [13:12:05.047] was_logged = [13:12:05.047] oldcontext = 0x8382de000 [13:12:05.047] parsetree_list = 0x83a8fe3f0 [13:12:05.047] use_implicit_block = false [13:12:05.047] parsetree_item = 0x83a8fe408 [13:12:05.047] save_log_statement_stats = [13:12:05.047] #20 0x0000000000908fa4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [13:12:05.047] query_string = 0x8382d2100 "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"... [13:12:05.047] input_message = {data = 0x8382d2100 "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} [13:12:05.047] firstchar = [13:12:05.047] local_sigjmp_buf = {{_sjb = {9471088, 34924104320, 34924104280, 34924104880, 12184280, 12130752, 8192, 8388608, 72057628961997695, 0, 0, 1}}} [13:12:05.047] send_ready_for_query = false [13:12:05.047] idle_in_transaction_timeout_enabled = false [13:12:05.047] idle_session_timeout_enabled = false [13:12:05.047] #21 0x0000000000903a79 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [13:12:05.047] bsdata = [13:12:05.047] #22 0x000000000085dc12 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a397c0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a39708) at ../src/backend/postmaster/launch_backend.c:265 [13:12:05.047] pid = [13:12:05.047] #23 0x0000000000862571 in BackendStartup (client_sock=0x821a39708) at ../src/backend/postmaster/postmaster.c:3593 [13:12:05.047] startup_data = {canAcceptConnections = CAC_OK} [13:12:05.047] bn = 0x8382de498 [13:12:05.047] pid = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] save_errno = [13:12:05.047] __error = [13:12:05.047] __error = [13:12:05.047] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [13:12:05.047] 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' , "`\227\243!\b\000\000\000\330\365\r,\b\000\000\000\v\000\000\000\000\000\000\000\016v\016,\b", '\000' , "\240\227\243!\b\000\000\000\344م\000\000\000\000\000\260\227\243!\b", '\000' }, salen = 16}} [13:12:05.047] i = 0 [13:12:05.047] now = [13:12:05.047] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 564367072, events = 8, fd = 568280072, user_data = 0x21}, {pos = 564367056, events = 8, fd = 104286868, user_data = 0x821ded008}, {pos = 568251400, events = 8, fd = 568252424, user_data = 0x821dedc08}, {pos = 568266760, events = 8, fd = 568267784, user_data = 0x821df1808}, {pos = 568269832, events = 8, fd = 568270856, user_data = 0x821df2408}, {pos = 568272904, events = 8, fd = 568273928, user_data = 0x821df3008}, {pos = 568275976, events = 8, fd = 568277000, user_data = 0x821df3c08}, {pos = 568279048, events = 8, fd = 568280072, user_data = 0x821df9088}, {pos = 564367448, events = 8, fd = 564366960, user_data = 0x303c0637ada3}, {pos = 568280072, events = 8, fd = 2571794, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 568303672, user_data = 0x1}, {pos = 568280072, events = 8, fd = 721167528, user_data = 0x821a39158}, {pos = 568280072, events = 8, fd = 564366928, user_data = 0x273d5c}, {pos = 564367520, events = 8, fd = 721275236, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 568306232, user_data = 0x303c00000001}, {pos = 568280072, events = 8, fd = 721189080, user_data = 0x821a38f98}, {pos = 564366656, events = 8, fd = 33, user_data = 0x82afd8c64}, {pos = 568280072, events = 8, fd = 568306232, user_data = 0x0}, {pos = 2625, events = 0, fd = 564367232, user_data = 0x303c06374645}, {pos = 721275236, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 568306232, events = 8, fd = 1, user_data = 0x821df4408}, {pos = 942415872, events = 8, fd = 1, user_data = 0x8382c2194}, {pos = 0, events = 0, fd = 564367184, user_data = 0x82c0e6c0c}, {pos = 1, events = 0, fd = 942415872, user_data = 0x821a38f80}, {pos = 739139252, events = 8, fd = 723001696, user_data = 0x82b182160 }, {pos = 721371328, events = 8, fd = 568280072, user_data = 0x821a39060}, {pos = 104285228, events = 12348, fd = 80627796, user_data = 0x1}, {pos = 104284846, events = 12348, fd = 12240, user_data = 0x821a38f88}, {pos = 564367456, events = 8, fd = 943212520, user_data = 0x821a395d0}, {pos = 104365712, events = 12348, fd = 568280072, user_data = 0x821a3037f}, {pos = 722658482, events = 8, fd = 564367760, user_data = 0x303c00000000}, {pos = 568280072, events = 8, fd = 12240, user_data = 0x82afb8000}, {pos = 1964368, events = 0, fd = 723001696, user_data = 0x82afd8c64}, {pos = 15616, events = 0, fd = 564368640, user_data = 0x821a390d0}, {pos = 721932686, events = 8, fd = 723040312, user_data = 0x821a39094}, {pos = 942867930, events = 8, fd = 564368640, user_data = 0x821a390d0}, {pos = 722023941, events = 8, fd = 564367506, user_data = 0x821a39500}, {pos = 564368640, events = 8, fd = 0, user_data = 0x46fff8e822fc47ce}, {pos = 564368640, events = 8, fd = 942867928, user_data = 0x821a395d0}, {pos = 723040312, events = 8, fd = 0, user_data = 0x821a39540}, {pos = 722024205, events = 8, fd = 0, user_data = 0x0}, {pos = 564369008, events = 8, fd = 942867928, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 104313865, user_data = 0x821a39218}, {pos = 721259620, events = 8, fd = 2503, user_data = 0x303c0637b409}, {pos = 564367928, events = 8, fd = 721259620, user_data = 0xac6}, {pos = 721232160, events = 8, fd = 564367800, user_data = 0x821df4408}, {pos = 564367928, events = 8, fd = 721232160, user_data = 0x821a39220}, {pos = 104293477, events = 12348, fd = 0, user_data = 0x800000000}, {pos = 564367888, events = 8, fd = 721192272, user_data = 0x0}, {pos = 0, events = 0, fd = 564367856, user_data = 0x303c0637b409}, {pos = 564368072, events = 8, fd = 721259620, user_data = 0xb6c}, {pos = 721232824, events = 8, fd = 564367944, user_data = 0x821df4408}, {pos = 564368072, events = 8, fd = 721232824, user_data = 0x821a392b0}, {pos = 104293477, events = 12348, fd = 568303672, user_data = 0x28d3da}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 568280072, user_data = 0x82afc8550}, {pos = 564368792, events = 8, fd = 568280072, user_data = 0x21a39478}, {pos = 31, events = 0, fd = 0, user_data = 0x821a39358}, {pos = 568301448, events = 8, fd = 564368680, user_data = 0x821a39340}, {pos = 104312227, events = 12348, fd = 568303672, user_data = 0x293062}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821dfa038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [13:12:05.047] last_touch_time = 1712840967 [13:12:05.047] last_lockfile_recheck_time = 1712840967 [13:12:05.047] nevents = 1 [13:12:05.047] #25 0x000000000085fe46 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a39d08) at ../src/backend/postmaster/postmaster.c:1372 [13:12:05.047] userDoption = [13:12:05.047] listen_addr_saved = false [13:12:05.047] output_config_variable = [13:12:05.047] opt = [13:12:05.047] status = [13:12:05.047] #26 0x0000000000797ec5 in main (argc=4, argv=0x821a39d08) at ../src/backend/main/main.c:197 [13:12:05.047] do_check_root =