[21:39:54.330] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [21:39:54.719] dumping /tmp/cores/postgres.7889.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [21:39:54.881] [New LWP 100123] [21:39:54.972] Core was generated by `postgres: postgres regression [local] MERGE'. [21:39:54.972] Program terminated with signal SIGABRT, Aborted. [21:39:54.972] Sent by thr_kill() from pid 7889 and user 1003. [21:39:54.972] #0 0x000000082bf49dca in thr_kill () from /lib/libc.so.7 [21:39:55.543] [21:39:55.543] Thread 1 (LWP 100123): [21:39:55.543] #0 0x000000082bf49dca in thr_kill () from /lib/libc.so.7 [21:39:55.543] No symbol table info available. [21:39:55.543] #1 0x000000082bec26f4 in raise () from /lib/libc.so.7 [21:39:55.543] No symbol table info available. [21:39:55.543] #2 0x000000082bf73bc9 in abort () from /lib/libc.so.7 [21:39:55.543] No symbol table info available. [21:39:55.543] #3 0x0000000000a415b7 in ExceptionalCondition (conditionName=, fileName=0x36efa0 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1728) at ../src/backend/utils/error/assert.c:66 [21:39:55.543] No locals. [21:39:55.543] #4 0x000000000072df00 in ExecFetchSlotHeapTuple (slot=slot@entry=0x82197a750, materialize=, shouldFree=shouldFree@entry=0x82197a616) at ../src/backend/executor/execTuples.c:1728 [21:39:55.543] No locals. [21:39:55.543] #5 0x00000000006f4428 in ExecIRDeleteTriggers (estate=estate@entry=0x8331d8100, relinfo=relinfo@entry=0x8331d86b0, slot=slot@entry=0x82197a750) at ../src/backend/commands/trigger.c:2841 [21:39:55.543] trigger = [21:39:55.543] oldtuple = [21:39:55.543] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8444e21a8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:39:55.543] trigdesc = 0x8331d88c0 [21:39:55.543] newtuple = 0x0 [21:39:55.543] i = 0 [21:39:55.543] should_free = false [21:39:55.543] #6 0x00000000007535a5 in ExecMergeMatched (context=0x82197a780, resultRelInfo=0x8331d86b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2991 [21:39:55.543] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:39:55.543] relaction = 0x840dd2c58 [21:39:55.543] commandType = CMD_DELETE [21:39:55.543] result = TM_Ok [21:39:55.543] l__state = {l = 0x840dd3218, i = 0} [21:39:55.543] mtstate = 0x8331d84a0 [21:39:55.543] newslot = 0x0 [21:39:55.543] rslot = 0x0 [21:39:55.543] estate = 0x1871b [21:39:55.543] econtext = 0x840dd2288 [21:39:55.543] epqstate = 0x8331d8588 [21:39:55.543] l = [21:39:55.543] isNull = [21:39:55.543] __error = [21:39:55.543] l__state = [21:39:55.543] updateCxt = [21:39:55.543] relaction = [21:39:55.543] commandType = [21:39:55.543] result = [21:39:55.543] __error = [21:39:55.543] resultRelationDesc = [21:39:55.543] lockmode = [21:39:55.543] inputslot = [21:39:55.543] epqslot = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] #7 ExecMerge (context=context@entry=0x82197a780, resultRelInfo=resultRelInfo@entry=0x8331d86b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x82197a750, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2772 [21:39:55.543] matched = [21:39:55.543] rslot = 0x0 [21:39:55.543] #8 0x00000000007529e6 in ExecModifyTable (pstate=0x8331d84a0) at ../src/backend/executor/nodeModifyTable.c:4028 [21:39:55.543] context = {mtstate = 0x8331d84a0, epqstate = 0x8331d8588, estate = 0x8331d8100, planSlot = 0x840dd0da8, tmfd = {ctid = {ip_blkid = {bi_hi = 10, bi_lo = 0}, ip_posid = 5}, xmax = 857571584, cmax = 8, traversed = 192}, cpUpdateReturningSlot = 0x0} [21:39:55.543] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [21:39:55.543] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8332b4118} [21:39:55.543] node = 0x8331d84a0 [21:39:55.543] estate = 0x8331d8100 [21:39:55.543] operation = CMD_MERGE [21:39:55.543] resultRelInfo = 0x6 [21:39:55.543] subplanstate = 0x8331d9df0 [21:39:55.543] tupleid = 0x0 [21:39:55.543] oldtuple = 0x82197a750 [21:39:55.543] slot = [21:39:55.543] oldSlot = [21:39:55.543] #9 0x0000000000727f9b in ExecProcNodeFirst (node=0x8331d84a0) at ../src/backend/executor/execProcnode.c:464 [21:39:55.543] No locals. [21:39:55.543] #10 0x000000000072034a in ExecProcNode (node=0x8331d84a0) at ../src/include/executor/executor.h:274 [21:39:55.543] No locals. [21:39:55.543] #11 ExecutePlan (estate=0x8331d8100, planstate=0x8331d84a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x8331d5f10, execute_once=false) at ../src/backend/executor/execMain.c:1644 [21:39:55.543] current_tuple_count = [21:39:55.543] slot = [21:39:55.543] #12 standard_ExecutorRun (queryDesc=0x83317b448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:39:55.543] estate = 0x8331d8100 [21:39:55.543] oldcontext = 0x8331d5c00 [21:39:55.543] operation = CMD_MERGE [21:39:55.543] dest = 0x8331d5f10 [21:39:55.543] sendTuples = true [21:39:55.543] #13 0x00000000007201ff in ExecutorRun (queryDesc=0x1871b, queryDesc@entry=0x83317b448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:39:55.543] No locals. [21:39:55.543] #14 0x00000000008f14af in ProcessQuery (plan=0x840e06058, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x82197a988) at ../src/backend/tcop/pquery.c:160 [21:39:55.543] queryDesc = 0x83317b448 [21:39:55.543] #15 0x00000000008f0a4d in PortalRunMulti (portal=portal@entry=0x8331ae100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8331d5f10, altdest=0xb30d00 , qc=qc@entry=0x82197a988) at ../src/backend/tcop/pquery.c:1286 [21:39:55.543] pstmt = 0x840e06058 [21:39:55.543] stmtlist_item__state = {l = 0x840e0a8c0, i = 0} [21:39:55.543] active_snapshot_set = true [21:39:55.543] stmtlist_item = 0x840e0a8d8 [21:39:55.543] #16 0x00000000008f053c in FillPortalStore (portal=portal@entry=0x8331ae100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:39:55.543] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:39:55.543] treceiver = 0x8331d5f10 [21:39:55.543] #17 0x00000000008f0290 in PortalRun (portal=portal@entry=0x8331ae100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x840e0a910, altdest=altdest@entry=0x840e0a910, qc=0x82197aac0) at ../src/backend/tcop/pquery.c:763 [21:39:55.543] _local_sigjmp_buf = {{_sjb = {9372207, 35217209752, 34923325880, 34923326112, 34923325888, 12029368, 11997152, 35217137920, 7112098687, 35217146112, 3563355, 34359738368}}} [21:39:55.543] _save_exception_stack = 0x82197ab90 [21:39:55.543] _save_context_stack = 0x0 [21:39:55.543] _do_rethrow = false [21:39:55.543] saveTopTransactionResourceOwner = 0x8331bf998 [21:39:55.543] saveTopTransactionContext = 0x8330e4000 [21:39:55.543] saveActivePortal = 0x0 [21:39:55.543] saveResourceOwner = 0x8331bf998 [21:39:55.543] savePortalContext = 0x0 [21:39:55.543] saveMemoryContext = 0x8330e4000 [21:39:55.543] result = [21:39:55.543] nprocessed = [21:39:55.543] #18 0x00000000008ef19b in exec_simple_query (query_string=query_string@entry=0x8330d8100 "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 [21:39:55.543] cmdtaglen = [21:39:55.543] snapshot_set = [21:39:55.543] per_parsetree_context = 0x0 [21:39:55.543] plantree_list = [21:39:55.543] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:39:55.543] parsetree = 0x840d9fe28 [21:39:55.543] commandTag = CMDTAG_MERGE [21:39:55.543] cmdtagname = [21:39:55.543] querytree_list = [21:39:55.543] portal = 0x8331ae100 [21:39:55.543] format = 0 [21:39:55.543] receiver = 0x840e0a910 [21:39:55.543] parsetree_item__state = {l = 0x840da16f0, i = 0} [21:39:55.543] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:39:55.543] dest = DestRemote [21:39:55.543] was_logged = [21:39:55.543] oldcontext = 0x8330e4000 [21:39:55.543] parsetree_list = 0x840da16f0 [21:39:55.543] use_implicit_block = false [21:39:55.543] parsetree_item = 0x840da1708 [21:39:55.543] save_log_statement_stats = [21:39:55.543] #19 0x00000000008ecf84 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:39:55.543] query_string = 0x8330d8100 "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"... [21:39:55.543] input_message = {data = 0x8330d8100 "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} [21:39:55.543] firstchar = [21:39:55.543] local_sigjmp_buf = {{_sjb = {9356368, 34923326352, 34923326312, 34923326912, 12038104, 11984576, 8192, 8388608, 72057628961211263, 0, 0, 34359738369}}} [21:39:55.543] send_ready_for_query = false [21:39:55.543] idle_in_transaction_timeout_enabled = false [21:39:55.543] idle_session_timeout_enabled = false [21:39:55.543] #20 0x00000000008e7ce9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [21:39:55.543] bsdata = [21:39:55.543] #21 0x0000000000844c42 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82197b8d0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82197b818) at ../src/backend/postmaster/launch_backend.c:265 [21:39:55.543] pid = [21:39:55.543] #22 0x0000000000849461 in BackendStartup (client_sock=0x82197b818) at ../src/backend/postmaster/postmaster.c:3593 [21:39:55.543] startup_data = {canAcceptConnections = CAC_OK} [21:39:55.543] bn = 0x8330e42b8 [21:39:55.543] pid = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] save_errno = [21:39:55.543] __error = [21:39:55.543] __error = [21:39:55.543] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:39:55.543] 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\270\227!\b\000\000\000\330Փ*\b\000\000\000\v\000\000\000\000\000\000\000\016V\224*\b", '\000' , "\260\270\227!\b\000\000\000\024J\204\000\000\000\000\000\300\270\227!\b", '\000' }, salen = 16}} [21:39:55.543] i = 0 [21:39:55.543] now = [21:39:55.543] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 736308324, events = 8, fd = 563588704, user_data = 0x82197aff0}, {pos = 575919112, events = 8, fd = 32, user_data = 0x82197afe0}, {pos = -300045676, events = 7995, fd = 575889416, user_data = 0x822536408}, {pos = 575891464, events = 8, fd = 575892488, user_data = 0x82253a008}, {pos = 575906824, events = 8, fd = 575907848, user_data = 0x82253ac08}, {pos = 575909896, events = 8, fd = 575910920, user_data = 0x82253b808}, {pos = 575912968, events = 8, fd = 575913992, user_data = 0x82253c408}, {pos = 575916040, events = 8, fd = 575917064, user_data = 0x82253d008}, {pos = 575919112, events = 8, fd = -1, user_data = 0x82c00a2e0}, {pos = 563588944, events = 8, fd = 737898921, user_data = 0x0}, {pos = 4096, events = 0, fd = -1125379258, user_data = 0x82c00a7e8}, {pos = 847289312, events = 8, fd = 160, user_data = 0x0}, {pos = 837099664, events = 8, fd = 563589152, user_data = 0x82bf9592c}, {pos = 4096, events = 0, fd = 736323940, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 575945272, user_data = 0x800000001}, {pos = 575919112, events = 8, fd = 736237784, user_data = 0x82197b0a8}, {pos = 563588704, events = 8, fd = 32, user_data = 0x82be32c64}, {pos = 575919112, events = 8, fd = 575945272, user_data = 0x0}, {pos = 2625, events = 0, fd = 563589264, user_data = 0x1f3bee1da645}, {pos = 736323940, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 575945272, events = 8, fd = 1, user_data = 0x82253d408}, {pos = 856457216, events = 8, fd = 1, user_data = 0x8330c8194}, {pos = 0, events = 0, fd = 563589216, user_data = 0x82a944c0c}, {pos = 1, events = 0, fd = 856457216, user_data = 0x82197b090}, {pos = 714358452, events = 8, fd = 738050400, user_data = 0x82bfdc160 }, {pos = 736420032, events = 8, fd = 575919112, user_data = 0x82197b170}, {pos = -300047316, events = 7995, fd = 837099664, user_data = 0x800000001}, {pos = -300047698, events = 7995, fd = 12240, user_data = 0x82197b098}, {pos = 563589488, events = 8, fd = 857163752, user_data = 0x82197b6e0}, {pos = -299966832, events = 7995, fd = 575919112, user_data = 0x82197037f}, {pos = 737707420, events = 8, fd = 575889416, user_data = 0x0}, {pos = 575919112, events = 8, fd = 12240, user_data = 0x82be12000}, {pos = 1964368, events = 0, fd = 738050400, user_data = 0x82be32c64}, {pos = 15616, events = 0, fd = 563590672, user_data = 0x82197b1e0}, {pos = 736981390, events = 8, fd = 738089016, user_data = 0x82197b1a4}, {pos = 856901082, events = 8, fd = 563590672, user_data = 0x82197b1e0}, {pos = 737072645, events = 8, fd = 563589538, user_data = 0x82197b610}, {pos = 563590672, events = 8, fd = 0, user_data = 0x68083bbdbcec1346}, {pos = 563590672, events = 8, fd = 856901080, user_data = 0x82197b6e0}, {pos = 738089016, events = 8, fd = 0, user_data = 0x82197b650}, {pos = 737072909, events = 8, fd = 0, user_data = 0x0}, {pos = 563591040, events = 8, fd = 856901080, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -300018679, events = 7995, fd = 563589944, user_data = 0x82be32c64}, {pos = 2503, events = 0, fd = -300018679, user_data = 0x82197b358}, {pos = 736308324, events = 8, fd = 2758, user_data = 0x82be2c120}, {pos = 563589848, events = 8, fd = 575919112, user_data = 0x82197b358}, {pos = 736280864, events = 8, fd = 563589952, user_data = 0x1f3bee1dc465}, {pos = 0, events = 0, fd = 0, user_data = 0x82bffe0f0}, {pos = 736240976, events = 8, fd = 0, user_data = 0x0}, {pos = 738118064, events = 8, fd = -300018679, user_data = 0x82197b3e8}, {pos = 736308324, events = 8, fd = 2924, user_data = 0x82be2c3b8}, {pos = 563589992, events = 8, fd = 575919112, user_data = 0x82197b3e8}, {pos = 736281528, events = 8, fd = 563590096, user_data = 0x1f3bee1dc465}, {pos = 575942712, events = 8, fd = 2671068, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 575919112, events = 8, fd = 736240976, user_data = 0x82197b6a8}, {pos = 575919112, events = 8, fd = 563590536, user_data = 0x1e}, {pos = 736244960, events = 8, fd = 563590264, user_data = 0x822542248}, {pos = 563590712, events = 8, fd = 563590240, user_data = 0x1f3bee1e0da3}, {pos = 575942712, events = 8, fd = 2694607, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 575942712, user_data = 0x1}} [21:39:55.543] last_touch_time = 1711143398 [21:39:55.543] last_lockfile_recheck_time = 1711143398 [21:39:55.543] nevents = 1 [21:39:55.543] #24 0x0000000000846d36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82197be10) at ../src/backend/postmaster/postmaster.c:1372 [21:39:55.543] userDoption = [21:39:55.543] listen_addr_saved = false [21:39:55.543] output_config_variable = [21:39:55.543] opt = [21:39:55.543] status = [21:39:55.543] #25 0x0000000000783065 in main (argc=8, argv=0x82197be10) at ../src/backend/main/main.c:197 [21:39:55.543] do_check_root = [21:39:55.560] [21:39:55.560] [21:39:55.560] [21:39:55.623] dumping /tmp/cores/postgres.8706.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:39:55.782] [New LWP 101644] [21:39:55.852] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [21:39:55.852] Program terminated with signal SIGABRT, Aborted. [21:39:55.852] Sent by thr_kill() from pid 8706 and user 1003. [21:39:55.852] #0 0x000000082c389dca in thr_kill () from /lib/libc.so.7 [21:39:56.396] [21:39:56.396] Thread 1 (LWP 101644): [21:39:56.396] #0 0x000000082c389dca in thr_kill () from /lib/libc.so.7 [21:39:56.396] No symbol table info available. [21:39:56.396] #1 0x000000082c3026f4 in raise () from /lib/libc.so.7 [21:39:56.396] No symbol table info available. [21:39:56.396] #2 0x000000082c3b3bc9 in abort () from /lib/libc.so.7 [21:39:56.396] No symbol table info available. [21:39:56.396] #3 0x0000000000a415b7 in ExceptionalCondition (conditionName=, fileName=0x36efa0 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1728) at ../src/backend/utils/error/assert.c:66 [21:39:56.396] No locals. [21:39:56.396] #4 0x000000000072df00 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820f0fa50, materialize=, shouldFree=shouldFree@entry=0x820f0f916) at ../src/backend/executor/execTuples.c:1728 [21:39:56.396] No locals. [21:39:56.396] #5 0x00000000006f4428 in ExecIRDeleteTriggers (estate=estate@entry=0x835695100, relinfo=relinfo@entry=0x8356956b0, slot=slot@entry=0x820f0fa50) at ../src/backend/commands/trigger.c:2841 [21:39:56.396] trigger = [21:39:56.396] oldtuple = [21:39:56.396] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8419f3bb0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:39:56.396] trigdesc = 0x8356958c0 [21:39:56.396] newtuple = 0x0 [21:39:56.396] i = 0 [21:39:56.396] should_free = false [21:39:56.396] #6 0x00000000007535a5 in ExecMergeMatched (context=0x820f0fa80, resultRelInfo=0x8356956b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2991 [21:39:56.396] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:39:56.396] relaction = 0x841af8cd8 [21:39:56.396] commandType = CMD_DELETE [21:39:56.396] result = TM_Ok [21:39:56.396] l__state = {l = 0x841af9298, i = 0} [21:39:56.396] mtstate = 0x8356954a0 [21:39:56.396] newslot = 0x0 [21:39:56.396] rslot = 0x0 [21:39:56.396] estate = 0x18d0c [21:39:56.396] econtext = 0x841af8308 [21:39:56.396] epqstate = 0x835695588 [21:39:56.396] l = [21:39:56.396] isNull = [21:39:56.396] __error = [21:39:56.396] l__state = [21:39:56.396] updateCxt = [21:39:56.396] relaction = [21:39:56.396] commandType = [21:39:56.396] result = [21:39:56.396] __error = [21:39:56.396] resultRelationDesc = [21:39:56.396] lockmode = [21:39:56.396] inputslot = [21:39:56.396] epqslot = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] #7 ExecMerge (context=context@entry=0x820f0fa80, resultRelInfo=resultRelInfo@entry=0x8356956b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820f0fa50, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2772 [21:39:56.396] matched = [21:39:56.396] rslot = 0x0 [21:39:56.396] #8 0x00000000007529e6 in ExecModifyTable (pstate=0x8356954a0) at ../src/backend/executor/nodeModifyTable.c:4028 [21:39:56.396] context = {mtstate = 0x8356954a0, epqstate = 0x835695588, estate = 0x835695100, planSlot = 0x841af6e28, tmfd = {ctid = {ip_blkid = {bi_hi = 10, bi_lo = 0}, ip_posid = 5}, xmax = 896094464, cmax = 8, traversed = 192}, cpUpdateReturningSlot = 0x0} [21:39:56.396] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [21:39:56.396] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8356ad118} [21:39:56.396] node = 0x8356954a0 [21:39:56.396] estate = 0x835695100 [21:39:56.396] operation = CMD_MERGE [21:39:56.396] resultRelInfo = 0x6 [21:39:56.396] subplanstate = 0x835696df0 [21:39:56.396] tupleid = 0x0 [21:39:56.396] oldtuple = 0x820f0fa50 [21:39:56.396] slot = [21:39:56.396] oldSlot = [21:39:56.396] #9 0x0000000000727f9b in ExecProcNodeFirst (node=0x8356954a0) at ../src/backend/executor/execProcnode.c:464 [21:39:56.396] No locals. [21:39:56.396] #10 0x000000000072034a in ExecProcNode (node=0x8356954a0) at ../src/include/executor/executor.h:274 [21:39:56.396] No locals. [21:39:56.396] #11 ExecutePlan (estate=0x835695100, planstate=0x8356954a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83567c710, execute_once=false) at ../src/backend/executor/execMain.c:1644 [21:39:56.396] current_tuple_count = [21:39:56.396] slot = [21:39:56.396] #12 standard_ExecutorRun (queryDesc=0x835598448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:39:56.396] estate = 0x835695100 [21:39:56.396] oldcontext = 0x83567c400 [21:39:56.396] operation = CMD_MERGE [21:39:56.396] dest = 0x83567c710 [21:39:56.396] sendTuples = true [21:39:56.396] #13 0x00000000007201ff in ExecutorRun (queryDesc=0x18d0c, queryDesc@entry=0x835598448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:39:56.396] No locals. [21:39:56.396] #14 0x00000000008f14af in ProcessQuery (plan=0x841b25058, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820f0fc88) at ../src/backend/tcop/pquery.c:160 [21:39:56.396] queryDesc = 0x835598448 [21:39:56.396] #15 0x00000000008f0a4d in PortalRunMulti (portal=portal@entry=0x835578100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83567c710, altdest=0xb30d00 , qc=qc@entry=0x820f0fc88) at ../src/backend/tcop/pquery.c:1286 [21:39:56.396] pstmt = 0x841b25058 [21:39:56.396] stmtlist_item__state = {l = 0x841b298c0, i = 0} [21:39:56.396] active_snapshot_set = true [21:39:56.396] stmtlist_item = 0x841b298d8 [21:39:56.396] #16 0x00000000008f053c in FillPortalStore (portal=portal@entry=0x835578100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:39:56.396] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:39:56.396] treceiver = 0x83567c710 [21:39:56.396] #17 0x00000000008f0290 in PortalRun (portal=portal@entry=0x835578100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x841b29910, altdest=altdest@entry=0x841b29910, qc=0x820f0fdc0) at ../src/backend/tcop/pquery.c:763 [21:39:56.396] _local_sigjmp_buf = {{_sjb = {9372207, 35255002200, 34912402616, 34912402848, 34912402624, 12029368, 11997152, 35254665472, 7112098687, 35254673664, 3563355, 34359738368}}} [21:39:56.396] _save_exception_stack = 0x820f0fe90 [21:39:56.396] _save_context_stack = 0x0 [21:39:56.396] _do_rethrow = false [21:39:56.396] saveTopTransactionResourceOwner = 0x8355ca458 [21:39:56.396] saveTopTransactionContext = 0x8354eb000 [21:39:56.396] saveActivePortal = 0x0 [21:39:56.396] saveResourceOwner = 0x8355ca458 [21:39:56.396] savePortalContext = 0x0 [21:39:56.396] saveMemoryContext = 0x8354eb000 [21:39:56.396] result = [21:39:56.396] nprocessed = [21:39:56.396] #18 0x00000000008ef19b in exec_simple_query (query_string=query_string@entry=0x8354df100 "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 [21:39:56.396] cmdtaglen = [21:39:56.396] snapshot_set = [21:39:56.396] per_parsetree_context = 0x0 [21:39:56.396] plantree_list = [21:39:56.396] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:39:56.396] parsetree = 0x841ac65a8 [21:39:56.396] commandTag = CMDTAG_MERGE [21:39:56.396] cmdtagname = [21:39:56.396] querytree_list = [21:39:56.396] portal = 0x835578100 [21:39:56.396] format = 0 [21:39:56.396] receiver = 0x841b29910 [21:39:56.396] parsetree_item__state = {l = 0x841ac7e70, i = 0} [21:39:56.396] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:39:56.396] dest = DestRemote [21:39:56.396] was_logged = [21:39:56.396] oldcontext = 0x8354eb000 [21:39:56.396] parsetree_list = 0x841ac7e70 [21:39:56.396] use_implicit_block = false [21:39:56.396] parsetree_item = 0x841ac7e88 [21:39:56.396] save_log_statement_stats = [21:39:56.396] #19 0x00000000008ecf84 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:39:56.396] query_string = 0x8354df100 "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"... [21:39:56.396] input_message = {data = 0x8354df100 "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} [21:39:56.396] firstchar = [21:39:56.396] local_sigjmp_buf = {{_sjb = {9356368, 34912403088, 34912403048, 34912403648, 12038104, 11984576, 8192, 8388608, 72057628950266751, 0, 0, 34359738369}}} [21:39:56.396] send_ready_for_query = false [21:39:56.396] idle_in_transaction_timeout_enabled = false [21:39:56.396] idle_session_timeout_enabled = false [21:39:56.396] #20 0x00000000008e7ce9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [21:39:56.396] bsdata = [21:39:56.396] #21 0x0000000000844c42 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820f10bd0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f10b18) at ../src/backend/postmaster/launch_backend.c:265 [21:39:56.396] pid = [21:39:56.396] #22 0x0000000000849461 in BackendStartup (client_sock=0x820f10b18) at ../src/backend/postmaster/postmaster.c:3593 [21:39:56.396] startup_data = {canAcceptConnections = CAC_OK} [21:39:56.396] bn = 0x8354eb178 [21:39:56.396] pid = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] save_errno = [21:39:56.396] __error = [21:39:56.396] __error = [21:39:56.396] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:39:56.396] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "p\v\361 \b\000\000\000إ\b+\b\000\000\000\v\000\000\000\000\000\000\000\016&\t+\b", '\000' , "\260\v\361 \b\000\000\000\024J\204\000\000\000\000\000\300\v\361 \b", '\000' }, salen = 16}} [21:39:56.396] i = 0 [21:39:56.396] now = [21:39:56.396] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 740764772, events = 8, fd = 552665440, user_data = 0x820f102f0}, {pos = 557630472, events = 8, fd = 32, user_data = 0x820f102e0}, {pos = -1139250540, events = 959, fd = 557600776, user_data = 0x8213c5408}, {pos = 557602824, events = 8, fd = 557603848, user_data = 0x8213c9008}, {pos = 557618184, events = 8, fd = 557619208, user_data = 0x8213c9c08}, {pos = 557621256, events = 8, fd = 557622280, user_data = 0x8213ca808}, {pos = 557624328, events = 8, fd = 557625352, user_data = 0x8213cb408}, {pos = 557627400, events = 8, fd = 557628424, user_data = 0x8213cc008}, {pos = 557630472, events = 8, fd = 557650056, user_data = 0x820f10468}, {pos = 552665744, events = 8, fd = -1139225181, user_data = 0x0}, {pos = 2567962, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 557654072, events = 8, fd = 1, user_data = 0x8213cc408}, {pos = 740672680, events = 8, fd = 552666472, user_data = 0x8213cc408}, {pos = 552665728, events = 0, fd = 740780388, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 557656632, user_data = 0x1}, {pos = 557630472, events = 8, fd = 740694232, user_data = 0x820f103a8}, {pos = 552665440, events = 8, fd = 32, user_data = 0x82c272c64}, {pos = 557630472, events = 8, fd = 557656632, user_data = 0x0}, {pos = 2625, events = 0, fd = 552666000, user_data = 0x3bfbc186645}, {pos = 740780388, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 557656632, events = 8, fd = 1, user_data = 0x8213cc408}, {pos = 894234624, events = 8, fd = 1, user_data = 0x8354cf194}, {pos = 0, events = 0, fd = 552665952, user_data = 0x82b091c0c}, {pos = 1, events = 0, fd = 894234624, user_data = 0x820f10390}, {pos = 722013876, events = 8, fd = 742506848, user_data = 0x82c41c160 }, {pos = 740876480, events = 8, fd = 557630472, user_data = 0x820f10470}, {pos = -1139252180, events = 959, fd = 557629448, user_data = 0x800000001}, {pos = -1139252562, events = 959, fd = 12240, user_data = 0x820f10398}, {pos = 552666224, events = 8, fd = 895031272, user_data = 0x820f109e0}, {pos = -1139171696, events = 959, fd = 557630472, user_data = 0x820f1037f}, {pos = 742163634, events = 8, fd = 557600776, user_data = 0x0}, {pos = 557630472, events = 8, fd = 12240, user_data = 0x82c252000}, {pos = 1964368, events = 0, fd = 742506848, user_data = 0x82c272c64}, {pos = 15616, events = 0, fd = 552667408, user_data = 0x820f104e0}, {pos = 741437838, events = 8, fd = 742545464, user_data = 0x820f104a4}, {pos = 894686682, events = 8, fd = 552667408, user_data = 0x820f104e0}, {pos = 741529093, events = 8, fd = 552666274, user_data = 0x820f10910}, {pos = 552667408, events = 8, fd = 0, user_data = 0x2917f95eed9f97c3}, {pos = 552667408, events = 8, fd = 894686680, user_data = 0x820f109e0}, {pos = 742545464, events = 8, fd = 0, user_data = 0x820f10950}, {pos = 741529357, events = 8, fd = 0, user_data = 0x0}, {pos = 552667776, events = 8, fd = 894686680, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1139223543, events = 959, fd = 552666680, user_data = 0x82c272c64}, {pos = 2503, events = 0, fd = -1139223543, user_data = 0x820f10658}, {pos = 740764772, events = 8, fd = 2758, user_data = 0x82c26c120}, {pos = 552666584, events = 8, fd = 557630472, user_data = 0x820f10658}, {pos = 740737312, events = 8, fd = 552666688, user_data = 0x3bfbc188465}, {pos = 0, events = 0, fd = 0, user_data = 0x82c43e0f0}, {pos = 740697424, events = 8, fd = 0, user_data = 0x0}, {pos = 742574512, events = 8, fd = -1139223543, user_data = 0x820f106e8}, {pos = 740764772, events = 8, fd = 2924, user_data = 0x82c26c3b8}, {pos = 552666728, events = 8, fd = 557630472, user_data = 0x820f106e8}, {pos = 740737976, events = 8, fd = 552666832, user_data = 0x3bfbc188465}, {pos = 557654072, events = 8, fd = 2671068, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 557630472, events = 8, fd = 740697424, user_data = 0x820f109a8}, {pos = 557630472, events = 8, fd = 552667272, user_data = 0x1e}, {pos = 740701408, events = 8, fd = 552667000, user_data = 0x8213d1248}, {pos = 552667448, events = 8, fd = 552666976, user_data = 0x3bfbc18cda3}, {pos = 557654072, events = 8, fd = 2694607, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 557654072, user_data = 0x1}} [21:39:56.397] last_touch_time = 1711143400 [21:39:56.397] last_lockfile_recheck_time = 1711143400 [21:39:56.397] nevents = 1 [21:39:56.397] #24 0x0000000000846d36 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f11110) at ../src/backend/postmaster/postmaster.c:1372 [21:39:56.397] userDoption = [21:39:56.397] listen_addr_saved = false [21:39:56.397] output_config_variable = [21:39:56.397] opt = [21:39:56.397] status = [21:39:56.397] #25 0x0000000000783065 in main (argc=4, argv=0x820f11110) at ../src/backend/main/main.c:197 [21:39:56.397] do_check_root = [21:39:56.414] [21:39:56.414] [21:39:56.414] [21:39:56.478] dumping /tmp/cores/postgres.14180.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:39:56.634] [New LWP 100122] [21:39:56.707] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [21:39:56.707] Program terminated with signal SIGABRT, Aborted. [21:39:56.707] Sent by thr_kill() from pid 14180 and user 1003. [21:39:56.707] #0 0x000000082a7efdca in thr_kill () from /lib/libc.so.7 [21:39:57.278] [21:39:57.278] Thread 1 (LWP 100122): [21:39:57.278] #0 0x000000082a7efdca in thr_kill () from /lib/libc.so.7 [21:39:57.278] No symbol table info available. [21:39:57.278] #1 0x000000082a7686f4 in raise () from /lib/libc.so.7 [21:39:57.278] No symbol table info available. [21:39:57.278] #2 0x000000082a819bc9 in abort () from /lib/libc.so.7 [21:39:57.278] No symbol table info available. [21:39:57.278] #3 0x0000000000a415b7 in ExceptionalCondition (conditionName=, fileName=0x36efa0 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1728) at ../src/backend/utils/error/assert.c:66 [21:39:57.278] No locals. [21:39:57.278] #4 0x000000000072df00 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820f4f080, materialize=, shouldFree=shouldFree@entry=0x820f4ef46) at ../src/backend/executor/execTuples.c:1728 [21:39:57.278] No locals. [21:39:57.278] #5 0x00000000006f4428 in ExecIRDeleteTriggers (estate=estate@entry=0x83462c100, relinfo=relinfo@entry=0x83462c6b0, slot=slot@entry=0x820f4f080) at ../src/backend/commands/trigger.c:2841 [21:39:57.278] trigger = [21:39:57.278] oldtuple = [21:39:57.278] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83adc3aa0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:39:57.278] trigdesc = 0x83462c8c0 [21:39:57.278] newtuple = 0x0 [21:39:57.278] i = 0 [21:39:57.278] should_free = false [21:39:57.278] #6 0x00000000007535a5 in ExecMergeMatched (context=0x820f4f0b0, resultRelInfo=0x83462c6b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2991 [21:39:57.278] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:39:57.278] relaction = 0x83af08e98 [21:39:57.278] commandType = CMD_DELETE [21:39:57.278] result = TM_Ok [21:39:57.278] l__state = {l = 0x83af09458, i = 0} [21:39:57.278] mtstate = 0x83462c4a0 [21:39:57.278] newslot = 0x0 [21:39:57.278] rslot = 0x0 [21:39:57.278] estate = 0x1871a [21:39:57.278] econtext = 0x83af084c8 [21:39:57.278] epqstate = 0x83462c588 [21:39:57.278] l = [21:39:57.278] isNull = [21:39:57.278] __error = [21:39:57.278] l__state = [21:39:57.278] updateCxt = [21:39:57.278] relaction = [21:39:57.278] commandType = [21:39:57.278] result = [21:39:57.278] __error = [21:39:57.278] resultRelationDesc = [21:39:57.278] lockmode = [21:39:57.278] inputslot = [21:39:57.278] epqslot = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] #7 ExecMerge (context=context@entry=0x820f4f0b0, resultRelInfo=resultRelInfo@entry=0x83462c6b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820f4f080, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2772 [21:39:57.278] matched = [21:39:57.278] rslot = 0x0 [21:39:57.278] #8 0x00000000007529e6 in ExecModifyTable (pstate=0x83462c4a0) at ../src/backend/executor/nodeModifyTable.c:4028 [21:39:57.278] context = {mtstate = 0x83462c4a0, epqstate = 0x83462c588, estate = 0x83462c100, planSlot = 0x83af06fe8, tmfd = {ctid = {ip_blkid = {bi_hi = 61712, bi_lo = 8436}, ip_posid = 8}, xmax = 712951518, cmax = 8, traversed = 131}, cpUpdateReturningSlot = 0x2a2714385a508832} [21:39:57.278] tuple_ctid = {ip_blkid = {bi_hi = 21400, bi_lo = 31798}, ip_posid = 18411} [21:39:57.278] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834638118} [21:39:57.278] node = 0x83462c4a0 [21:39:57.278] estate = 0x83462c100 [21:39:57.278] operation = CMD_MERGE [21:39:57.278] resultRelInfo = 0x6 [21:39:57.278] subplanstate = 0x83462ddf0 [21:39:57.278] tupleid = 0x0 [21:39:57.278] oldtuple = 0x820f4f080 [21:39:57.278] slot = [21:39:57.278] oldSlot = [21:39:57.278] #9 0x0000000000727f9b in ExecProcNodeFirst (node=0x83462c4a0) at ../src/backend/executor/execProcnode.c:464 [21:39:57.278] No locals. [21:39:57.278] #10 0x000000000072034a in ExecProcNode (node=0x83462c4a0) at ../src/include/executor/executor.h:274 [21:39:57.278] No locals. [21:39:57.278] #11 ExecutePlan (estate=0x83462c100, planstate=0x83462c4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x8345fd310, execute_once=false) at ../src/backend/executor/execMain.c:1644 [21:39:57.278] current_tuple_count = [21:39:57.278] slot = [21:39:57.278] #12 standard_ExecutorRun (queryDesc=0x834527448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:39:57.278] estate = 0x83462c100 [21:39:57.278] oldcontext = 0x8345fd000 [21:39:57.278] operation = CMD_MERGE [21:39:57.278] dest = 0x8345fd310 [21:39:57.278] sendTuples = true [21:39:57.278] #13 0x00000008378d0963 in pgss_ExecutorRun (queryDesc=0x834527448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [21:39:57.278] _local_sigjmp_buf = {{_sjb = {35291728178, 12029368, 34912661976, 34912662144, 35237557320, 34912661984, 1, 1, 35238577023, 35237557320, 12038096, 34359738368}}} [21:39:57.278] _save_exception_stack = 0x820f4f3a0 [21:39:57.278] _save_context_stack = 0x0 [21:39:57.278] _do_rethrow = false [21:39:57.278] #14 0x00000000007201f8 in ExecutorRun (queryDesc=0x1871a, queryDesc@entry=0x834527448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [21:39:57.278] No locals. [21:39:57.278] #15 0x00000000008f14af in ProcessQuery (plan=0x83aef0b08, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820f4f368) at ../src/backend/tcop/pquery.c:160 [21:39:57.278] queryDesc = 0x834527448 [21:39:57.278] #16 0x00000000008f0a4d in PortalRunMulti (portal=portal@entry=0x834509100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8345fd310, altdest=0xb30d00 , qc=qc@entry=0x820f4f368) at ../src/backend/tcop/pquery.c:1286 [21:39:57.278] pstmt = 0x83aef0b08 [21:39:57.278] stmtlist_item__state = {l = 0x83aef5370, i = 0} [21:39:57.278] active_snapshot_set = true [21:39:57.278] stmtlist_item = 0x83aef5388 [21:39:57.278] #17 0x00000000008f053c in FillPortalStore (portal=portal@entry=0x834509100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:39:57.278] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:39:57.278] treceiver = 0x8345fd310 [21:39:57.278] #18 0x00000000008f0290 in PortalRun (portal=portal@entry=0x834509100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83aef53c0, altdest=altdest@entry=0x83aef53c0, qc=0x820f4f4a0) at ../src/backend/tcop/pquery.c:763 [21:39:57.278] _local_sigjmp_buf = {{_sjb = {9372207, 35237767640, 34912662424, 34912662656, 34912662432, 12029368, 11997152, 35237433600, 7112098687, 35237441792, 3563355, 34359738368}}} [21:39:57.278] _save_exception_stack = 0x820f4f570 [21:39:57.278] _save_context_stack = 0x0 [21:39:57.278] _do_rethrow = false [21:39:57.278] saveTopTransactionResourceOwner = 0x83455a9d8 [21:39:57.278] saveTopTransactionContext = 0x83447a000 [21:39:57.278] saveActivePortal = 0x0 [21:39:57.278] saveResourceOwner = 0x83455a9d8 [21:39:57.278] savePortalContext = 0x0 [21:39:57.278] saveMemoryContext = 0x83447a000 [21:39:57.278] result = [21:39:57.278] nprocessed = [21:39:57.278] #19 0x00000000008ef19b in exec_simple_query (query_string=query_string@entry=0x83446e100 "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 [21:39:57.278] cmdtaglen = [21:39:57.278] snapshot_set = [21:39:57.278] per_parsetree_context = 0x0 [21:39:57.278] plantree_list = [21:39:57.278] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:39:57.278] parsetree = 0x83aea88e8 [21:39:57.278] commandTag = CMDTAG_MERGE [21:39:57.278] cmdtagname = [21:39:57.278] querytree_list = [21:39:57.278] portal = 0x834509100 [21:39:57.278] format = 0 [21:39:57.278] receiver = 0x83aef53c0 [21:39:57.278] parsetree_item__state = {l = 0x83aeaa1b0, i = 0} [21:39:57.278] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:39:57.278] dest = DestRemote [21:39:57.278] was_logged = [21:39:57.278] oldcontext = 0x83447a000 [21:39:57.278] parsetree_list = 0x83aeaa1b0 [21:39:57.278] use_implicit_block = false [21:39:57.278] parsetree_item = 0x83aeaa1c8 [21:39:57.278] save_log_statement_stats = [21:39:57.278] #20 0x00000000008ecf84 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:39:57.278] query_string = 0x83446e100 "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"... [21:39:57.278] input_message = {data = 0x83446e100 "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} [21:39:57.278] firstchar = [21:39:57.278] local_sigjmp_buf = {{_sjb = {9356368, 34912662896, 34912662856, 34912663456, 12038104, 11984576, 8192, 8388608, 72057628950528895, 0, 0, 1}}} [21:39:57.278] send_ready_for_query = false [21:39:57.278] idle_in_transaction_timeout_enabled = false [21:39:57.278] idle_session_timeout_enabled = false [21:39:57.278] #21 0x00000000008e7ce9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [21:39:57.278] bsdata = [21:39:57.278] #22 0x0000000000844c42 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820f502b0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f501f8) at ../src/backend/postmaster/launch_backend.c:265 [21:39:57.278] pid = [21:39:57.278] #23 0x0000000000849461 in BackendStartup (client_sock=0x820f501f8) at ../src/backend/postmaster/postmaster.c:3593 [21:39:57.278] startup_data = {canAcceptConnections = CAC_OK} [21:39:57.278] bn = 0x83447a678 [21:39:57.278] pid = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] save_errno = [21:39:57.278] __error = [21:39:57.278] __error = [21:39:57.278] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:39:57.278] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "P\002\365 \b\000\000\000\330EZ)\b\000\000\000\v\000\000\000\000\000\000\000\016\306Z)\b", '\000' , "\220\002\365 \b\000\000\000\024J\204\000\000\000\000\000\240\002\365 \b", '\000' }, salen = 16}} [21:39:57.278] i = 0 [21:39:57.278] now = [21:39:57.278] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 559145992, user_data = 0x0}, {pos = 552925632, events = 8, fd = -1234425196, user_data = 0x821537008}, {pos = 559117320, events = 8, fd = 559118344, user_data = 0x821537c08}, {pos = 559132680, events = 8, fd = 559133704, user_data = 0x82153b808}, {pos = 559135752, events = 8, fd = 559136776, user_data = 0x82153c408}, {pos = 559138824, events = 8, fd = 559139848, user_data = 0x82153d008}, {pos = 559141896, events = 8, fd = 559142920, user_data = 0x82153dc08}, {pos = 559144968, events = 8, fd = 559145992, user_data = 0x821543088}, {pos = 552926024, events = 8, fd = 552925536, user_data = 0x20dbb66c8da3}, {pos = 559145992, events = 8, fd = 2567962, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 559169592, user_data = 0x1}, {pos = 559145992, events = 8, fd = 711730344, user_data = 0x820f4fc48}, {pos = 559145992, events = 8, fd = 552925504, user_data = 0x272e64}, {pos = 552926096, events = 8, fd = 711838052, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 559172152, user_data = 0x20db00000001}, {pos = 559145992, events = 8, fd = 711751896, user_data = 0x820f4fa88}, {pos = 552925232, events = 8, fd = 33, user_data = 0x82a6d8c64}, {pos = 559145992, events = 8, fd = 559172152, user_data = 0x0}, {pos = 2625, events = 0, fd = 552925808, user_data = 0x20dbb66c2645}, {pos = 711838052, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 559172152, events = 8, fd = 1, user_data = 0x82153e408}, {pos = 876994560, events = 8, fd = 1, user_data = 0x83445e194}, {pos = 0, events = 0, fd = 552925760, user_data = 0x8295abc0c}, {pos = 1, events = 0, fd = 876994560, user_data = 0x820f4fa70}, {pos = 693808820, events = 8, fd = 713564512, user_data = 0x82a882160 }, {pos = 711934144, events = 8, fd = 559145992, user_data = 0x820f4fb50}, {pos = -1234426836, events = 8411, fd = 80627796, user_data = 0x1}, {pos = -1234427218, events = 8411, fd = 12240, user_data = 0x820f4fa78}, {pos = 552926032, events = 8, fd = 877791208, user_data = 0x820f500c0}, {pos = -1234346352, events = 8411, fd = 559145992, user_data = 0x820f4037f}, {pos = 713221298, events = 8, fd = 552926336, user_data = 0x20db00000000}, {pos = 559145992, events = 8, fd = 12240, user_data = 0x82a6b8000}, {pos = 1964368, events = 0, fd = 713564512, user_data = 0x82a6d8c64}, {pos = 15616, events = 0, fd = 552927216, user_data = 0x820f4fbc0}, {pos = 712495502, events = 8, fd = 713603128, user_data = 0x820f4fb84}, {pos = 877446618, events = 8, fd = 552927216, user_data = 0x820f4fbc0}, {pos = 712586757, events = 8, fd = 552926082, user_data = 0x820f4fff0}, {pos = 552927216, events = 8, fd = 0, user_data = 0x153447eb7c365398}, {pos = 552927216, events = 8, fd = 877446616, user_data = 0x820f500c0}, {pos = 713603128, events = 8, fd = 0, user_data = 0x820f50030}, {pos = 712587021, events = 8, fd = 0, user_data = 0x0}, {pos = 552927584, events = 8, fd = 877446616, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1234398199, user_data = 0x820f4fd08}, {pos = 711822436, events = 8, fd = 2503, user_data = 0x20dbb66c9409}, {pos = 552926504, events = 8, fd = 711822436, user_data = 0xac6}, {pos = 711794976, events = 8, fd = 552926376, user_data = 0x82153e408}, {pos = 552926504, events = 8, fd = 711794976, user_data = 0x820f4fd10}, {pos = -1234418587, events = 8411, fd = 0, user_data = 0x800000000}, {pos = 552926464, events = 8, fd = 711755088, user_data = 0x0}, {pos = 0, events = 0, fd = 552926432, user_data = 0x20dbb66c9409}, {pos = 552926648, events = 8, fd = 711822436, user_data = 0xb6c}, {pos = 711795640, events = 8, fd = 552926520, user_data = 0x82153e408}, {pos = 552926648, events = 8, fd = 711795640, user_data = 0x820f4fda0}, {pos = -1234418587, events = 8411, fd = 559169592, user_data = 0x28c1dc}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 559145992, user_data = 0x82a6c8550}, {pos = 552927368, events = 8, fd = 559145992, user_data = 0x20f4ff68}, {pos = 31, events = 0, fd = 0, user_data = 0x820f4fe48}, {pos = 559167368, events = 8, fd = 552927256, user_data = 0x820f4fe30}, {pos = -1234399837, events = 8411, fd = 559169592, user_data = 0x291dcf}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821544038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [21:39:57.278] last_touch_time = 1711143423 [21:39:57.278] last_lockfile_recheck_time = 1711143423 [21:39:57.278] nevents = 1 [21:39:57.278] #25 0x0000000000846d36 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f507f8) at ../src/backend/postmaster/postmaster.c:1372 [21:39:57.278] userDoption = [21:39:57.278] listen_addr_saved = false [21:39:57.278] output_config_variable = [21:39:57.278] opt = [21:39:57.278] status = [21:39:57.278] #26 0x0000000000783065 in main (argc=4, argv=0x820f507f8) at ../src/backend/main/main.c:197 [21:39:57.278] do_check_root =