[12:14:31.580] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [12:14:31.976] dumping /tmp/cores/postgres.7757.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [12:14:32.119] [New LWP 101727] [12:14:32.212] Core was generated by `postgres: postgres regression [local] MERGE'. [12:14:32.212] Program terminated with signal SIGABRT, Aborted. [12:14:32.212] Sent by thr_kill() from pid 7757 and user 1003. [12:14:32.212] #0 0x000000082aa1fdca in thr_kill () from /lib/libc.so.7 [12:14:32.811] [12:14:32.811] Thread 1 (LWP 101727): [12:14:32.811] #0 0x000000082aa1fdca in thr_kill () from /lib/libc.so.7 [12:14:32.811] No symbol table info available. [12:14:32.811] #1 0x000000082a9986f4 in raise () from /lib/libc.so.7 [12:14:32.811] No symbol table info available. [12:14:32.811] #2 0x000000082aa49bc9 in abort () from /lib/libc.so.7 [12:14:32.811] No symbol table info available. [12:14:32.811] #3 0x0000000000a44fe7 in ExceptionalCondition (conditionName=, fileName=0x36f696 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [12:14:32.811] No locals. [12:14:32.811] #4 0x000000000072ff50 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8211cdd58, materialize=, shouldFree=shouldFree@entry=0x8211cdc16) at ../src/backend/executor/execTuples.c:1737 [12:14:32.811] No locals. [12:14:32.811] #5 0x00000000006f6478 in ExecIRDeleteTriggers (estate=estate@entry=0x836e4e100, relinfo=relinfo@entry=0x836e4e6b0, slot=slot@entry=0x8211cdd58) at ../src/backend/commands/trigger.c:2832 [12:14:32.811] trigger = [12:14:32.811] oldtuple = [12:14:32.811] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x844d49408, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [12:14:32.811] trigdesc = 0x836e4e8c0 [12:14:32.811] newtuple = 0x0 [12:14:32.811] i = 0 [12:14:32.811] should_free = false [12:14:32.811] #6 0x0000000000755635 in ExecMergeMatched (context=0x8211cdd90, resultRelInfo=0x836e4e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2938 [12:14:32.811] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [12:14:32.811] relaction = 0x84254e298 [12:14:32.811] commandType = CMD_DELETE [12:14:32.811] result = TM_Ok [12:14:32.811] l__state = {l = 0x84254e858, i = 0} [12:14:32.811] mtstate = 0x836e4e4a0 [12:14:32.811] newslot = 0x0 [12:14:32.811] rslot = 0x0 [12:14:32.811] estate = 0x18d5f [12:14:32.811] econtext = 0x84254d8c8 [12:14:32.811] epqstate = 0x836e4e588 [12:14:32.811] l = [12:14:32.811] isNull = [12:14:32.811] __error = [12:14:32.811] l__state = [12:14:32.811] updateCxt = [12:14:32.811] relaction = [12:14:32.811] commandType = [12:14:32.811] result = [12:14:32.811] __error = [12:14:32.811] resultRelationDesc = [12:14:32.811] lockmode = [12:14:32.811] inputslot = [12:14:32.811] epqslot = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] #7 ExecMerge (context=context@entry=0x8211cdd90, resultRelInfo=resultRelInfo@entry=0x836e4e6b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x8211cdd58, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2717 [12:14:32.811] matched = [12:14:32.811] rslot = 0x0 [12:14:32.811] #8 0x0000000000754653 in ExecModifyTable (pstate=0x836e4e4a0) at ../src/backend/executor/nodeModifyTable.c:3981 [12:14:32.811] context = {mtstate = 0x836e4e4a0, epqstate = 0x836e4e588, estate = 0x836e4e100, planSlot = 0x84254c3e8, tmfd = {ctid = {ip_blkid = {bi_hi = 10, bi_lo = 0}, ip_posid = 5}, xmax = 920969472, cmax = 8, traversed = 208}, cpUpdateReturningSlot = 0x0} [12:14:32.811] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [12:14:32.811] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8424b4118} [12:14:32.811] node = 0x836e4e4a0 [12:14:32.811] estate = 0x836e4e100 [12:14:32.811] operation = CMD_MERGE [12:14:32.811] resultRelInfo = 0x6 [12:14:32.811] subplanstate = 0x836e4fdf0 [12:14:32.811] tupleid = 0x0 [12:14:32.811] oldtuple = 0x8211cdd58 [12:14:32.811] slot = [12:14:32.811] oldSlot = [12:14:32.811] #9 0x0000000000729f9b in ExecProcNodeFirst (node=0x836e4e4a0) at ../src/backend/executor/execProcnode.c:464 [12:14:32.811] No locals. [12:14:32.811] #10 0x000000000072232a in ExecProcNode (node=0x836e4e4a0) at ../src/include/executor/executor.h:274 [12:14:32.811] No locals. [12:14:32.811] #11 ExecutePlan (estate=0x836e4e100, planstate=0x836e4e4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836d5c710, execute_once=false) at ../src/backend/executor/execMain.c:1644 [12:14:32.811] current_tuple_count = [12:14:32.811] slot = [12:14:32.811] #12 standard_ExecutorRun (queryDesc=0x836df1448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [12:14:32.811] estate = 0x836e4e100 [12:14:32.811] oldcontext = 0x836d5c400 [12:14:32.811] operation = CMD_MERGE [12:14:32.811] dest = 0x836d5c710 [12:14:32.811] sendTuples = true [12:14:32.811] #13 0x00000000007221df in ExecutorRun (queryDesc=0x18d5f, queryDesc@entry=0x836df1448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [12:14:32.811] No locals. [12:14:32.811] #14 0x00000000008f3ecf in ProcessQuery (plan=0x84257a058, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8211cdf98) at ../src/backend/tcop/pquery.c:160 [12:14:32.811] queryDesc = 0x836df1448 [12:14:32.811] #15 0x00000000008f346d in PortalRunMulti (portal=portal@entry=0x836e24100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836d5c710, altdest=0xb34ae0 , qc=qc@entry=0x8211cdf98) at ../src/backend/tcop/pquery.c:1286 [12:14:32.811] pstmt = 0x84257a058 [12:14:32.811] stmtlist_item__state = {l = 0x84257e8c0, i = 0} [12:14:32.811] active_snapshot_set = true [12:14:32.811] stmtlist_item = 0x84257e8d8 [12:14:32.811] #16 0x00000000008f2f5c in FillPortalStore (portal=portal@entry=0x836e24100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [12:14:32.811] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:14:32.811] treceiver = 0x836d5c710 [12:14:32.811] #17 0x00000000008f2cb0 in PortalRun (portal=portal@entry=0x836e24100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x84257e910, altdest=altdest@entry=0x84257e910, qc=0x8211ce0d0) at ../src/backend/tcop/pquery.c:763 [12:14:32.811] _local_sigjmp_buf = {{_sjb = {9382991, 35280609432, 34915278792, 34915279024, 34915278800, 12045256, 12013040, 35280535808, 7112098687, 35280544000, 3565109, 34359738368}}} [12:14:32.811] _save_exception_stack = 0x8211ce1a0 [12:14:32.811] _save_context_stack = 0x0 [12:14:32.811] _do_rethrow = false [12:14:32.811] saveTopTransactionResourceOwner = 0x836e36098 [12:14:32.811] saveTopTransactionContext = 0x836d5a000 [12:14:32.811] saveActivePortal = 0x0 [12:14:32.811] saveResourceOwner = 0x836e36098 [12:14:32.811] savePortalContext = 0x0 [12:14:32.811] saveMemoryContext = 0x836d5a000 [12:14:32.811] result = [12:14:32.811] nprocessed = [12:14:32.811] #18 0x00000000008f1bbb in exec_simple_query (query_string=query_string@entry=0x836d4e100 "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 [12:14:32.811] cmdtaglen = [12:14:32.811] snapshot_set = [12:14:32.811] per_parsetree_context = 0x0 [12:14:32.811] plantree_list = [12:14:32.811] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:14:32.811] parsetree = 0x84251b4e8 [12:14:32.811] commandTag = CMDTAG_MERGE [12:14:32.811] cmdtagname = [12:14:32.811] querytree_list = [12:14:32.811] portal = 0x836e24100 [12:14:32.811] format = 0 [12:14:32.811] receiver = 0x84257e910 [12:14:32.811] parsetree_item__state = {l = 0x84251cdb0, i = 0} [12:14:32.811] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [12:14:32.811] dest = DestRemote [12:14:32.811] was_logged = [12:14:32.811] oldcontext = 0x836d5a000 [12:14:32.811] parsetree_list = 0x84251cdb0 [12:14:32.811] use_implicit_block = false [12:14:32.811] parsetree_item = 0x84251cdc8 [12:14:32.811] save_log_statement_stats = [12:14:32.811] #19 0x00000000008ef9a4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [12:14:32.811] query_string = 0x836d4e100 "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"... [12:14:32.811] input_message = {data = 0x836d4e100 "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} [12:14:32.811] firstchar = [12:14:32.811] local_sigjmp_buf = {{_sjb = {9367152, 34915279264, 34915279224, 34915279824, 12053992, 12000464, 8192, 8388608, 72057628953150335, 0, 0, 34359738369}}} [12:14:32.811] send_ready_for_query = false [12:14:32.811] idle_in_transaction_timeout_enabled = false [12:14:32.811] idle_session_timeout_enabled = false [12:14:32.811] #20 0x00000000008ea709 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [12:14:32.811] bsdata = [12:14:32.811] #21 0x00000000008474d2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8211ceee0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211cee28) at ../src/backend/postmaster/launch_backend.c:265 [12:14:32.811] pid = [12:14:32.811] #22 0x000000000084bcf1 in BackendStartup (client_sock=0x8211cee28) at ../src/backend/postmaster/postmaster.c:3593 [12:14:32.811] startup_data = {canAcceptConnections = CAC_OK} [12:14:32.811] bn = 0x836d5a088 [12:14:32.811] pid = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] save_errno = [12:14:32.811] __error = [12:14:32.811] __error = [12:14:32.811] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [12:14:32.811] 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' , "\200\356\034!\b\000\000\000صD+\b\000\000\000\v\000\000\000\000\000\000\000\0166E+\b", '\000' , "\300\356\034!\b\000\000\000\244r\204\000\000\000\000\000\320\356\034!\b", '\000' }, salen = 16}} [12:14:32.811] i = 0 [12:14:32.811] now = [12:14:32.811] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 714116196, events = 8, fd = 555541616, user_data = 0x8211ce600}, {pos = 558654472, events = 8, fd = 32, user_data = 0x8211ce5f0}, {pos = 1388190356, events = 12423, fd = 558624776, user_data = 0x8214bf408}, {pos = 558626824, events = 8, fd = 558627848, user_data = 0x8214c3008}, {pos = 558642184, events = 8, fd = 558643208, user_data = 0x8214c3c08}, {pos = 558645256, events = 8, fd = 558646280, user_data = 0x8214c4808}, {pos = 558648328, events = 8, fd = 558649352, user_data = 0x8214c5408}, {pos = 558651400, events = 8, fd = 558652424, user_data = 0x8214c6008}, {pos = 558654472, events = 8, fd = -1, user_data = 0x82aae02e0}, {pos = 555541856, events = 8, fd = 715706793, user_data = 0x0}, {pos = 4096, events = 0, fd = -1223334838, user_data = 0x82aae07e8}, {pos = 903912416, events = 8, fd = 160, user_data = 0x0}, {pos = 887566480, events = 8, fd = 555542064, user_data = 0x82aa6b92c}, {pos = 4096, events = 0, fd = 714131812, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 558680632, user_data = 0x800000001}, {pos = 558654472, events = 8, fd = 714045656, user_data = 0x8211ce6b8}, {pos = 555541616, events = 8, fd = 32, user_data = 0x82a908c64}, {pos = 558654472, events = 8, fd = 558680632, user_data = 0x0}, {pos = 2625, events = 0, fd = 555542176, user_data = 0x308752be1645}, {pos = 714131812, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 558680632, events = 8, fd = 1, user_data = 0x8214c6408}, {pos = 919855104, events = 8, fd = 1, user_data = 0x836d3e194}, {pos = 0, events = 0, fd = 555542128, user_data = 0x82b452c0c}, {pos = 1, events = 0, fd = 919855104, user_data = 0x8211ce6a0}, {pos = 725950132, events = 8, fd = 715858272, user_data = 0x82aab2160 }, {pos = 714227904, events = 8, fd = 558654472, user_data = 0x8211ce780}, {pos = 1388188716, events = 12423, fd = 887566480, user_data = 0x800000001}, {pos = 1388188334, events = 12423, fd = 12240, user_data = 0x8211ce6a8}, {pos = 555542400, events = 8, fd = 920561640, user_data = 0x8211cecf0}, {pos = 1388269200, events = 12423, fd = 558654472, user_data = 0x8211c037f}, {pos = 715515292, events = 8, fd = 558624776, user_data = 0x0}, {pos = 558654472, events = 8, fd = 12240, user_data = 0x82a8e8000}, {pos = 1964368, events = 0, fd = 715858272, user_data = 0x82a908c64}, {pos = 15616, events = 0, fd = 555543584, user_data = 0x8211ce7f0}, {pos = 714789262, events = 8, fd = 715896888, user_data = 0x8211ce7b4}, {pos = 920298970, events = 8, fd = 555543584, user_data = 0x8211ce7f0}, {pos = 714880517, events = 8, fd = 555542450, user_data = 0x8211cec20}, {pos = 555543584, events = 8, fd = 0, user_data = 0x2b491f3b715644a}, {pos = 555543584, events = 8, fd = 920298968, user_data = 0x8211cecf0}, {pos = 715896888, events = 8, fd = 0, user_data = 0x8211cec60}, {pos = 714880781, events = 8, fd = 0, user_data = 0x0}, {pos = 555543952, events = 8, fd = 920298968, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1388217353, events = 12423, fd = 555542856, user_data = 0x82a908c64}, {pos = 2503, events = 0, fd = 1388217353, user_data = 0x8211ce968}, {pos = 714116196, events = 8, fd = 2758, user_data = 0x82a902120}, {pos = 555542760, events = 8, fd = 558654472, user_data = 0x8211ce968}, {pos = 714088736, events = 8, fd = 555542864, user_data = 0x308752be3465}, {pos = 0, events = 0, fd = 0, user_data = 0x82aad40f0}, {pos = 714048848, events = 8, fd = 0, user_data = 0x0}, {pos = 715925936, events = 8, fd = 1388217353, user_data = 0x8211ce9f8}, {pos = 714116196, events = 8, fd = 2924, user_data = 0x82a9023b8}, {pos = 555542904, events = 8, fd = 558654472, user_data = 0x8211ce9f8}, {pos = 714089400, events = 8, fd = 555543008, user_data = 0x308752be3465}, {pos = 558678072, events = 8, fd = 2671440, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 558654472, events = 8, fd = 714048848, user_data = 0x8211cecb8}, {pos = 558654472, events = 8, fd = 555543448, user_data = 0x1e}, {pos = 714052832, events = 8, fd = 555543176, user_data = 0x8214cb248}, {pos = 555543624, events = 8, fd = 555543152, user_data = 0x308752be7da3}, {pos = 558678072, events = 8, fd = 2694910, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 558678072, user_data = 0x1}} [12:14:32.811] last_touch_time = 1711627894 [12:14:32.811] last_lockfile_recheck_time = 1711627894 [12:14:32.811] nevents = 1 [12:14:32.811] #24 0x00000000008495c6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8211cf420) at ../src/backend/postmaster/postmaster.c:1372 [12:14:32.811] userDoption = [12:14:32.811] listen_addr_saved = false [12:14:32.811] output_config_variable = [12:14:32.811] opt = [12:14:32.811] status = [12:14:32.811] #25 0x0000000000784c75 in main (argc=8, argv=0x8211cf420) at ../src/backend/main/main.c:197 [12:14:32.811] do_check_root = [12:14:32.822] [12:14:32.822] [12:14:32.822] [12:14:32.889] dumping /tmp/cores/postgres.8374.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:14:33.025] [New LWP 101704] [12:14:33.095] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [12:14:33.095] Program terminated with signal SIGABRT, Aborted. [12:14:33.095] Sent by thr_kill() from pid 8374 and user 1003. [12:14:33.095] #0 0x000000082a91adca in thr_kill () from /lib/libc.so.7 [12:14:33.695] [12:14:33.695] Thread 1 (LWP 101704): [12:14:33.695] #0 0x000000082a91adca in thr_kill () from /lib/libc.so.7 [12:14:33.695] No symbol table info available. [12:14:33.695] #1 0x000000082a8936f4 in raise () from /lib/libc.so.7 [12:14:33.695] No symbol table info available. [12:14:33.695] #2 0x000000082a944bc9 in abort () from /lib/libc.so.7 [12:14:33.695] No symbol table info available. [12:14:33.695] #3 0x0000000000a44fe7 in ExceptionalCondition (conditionName=, fileName=0x36f696 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [12:14:33.695] No locals. [12:14:33.695] #4 0x000000000072ff50 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820b7a078, materialize=, shouldFree=shouldFree@entry=0x820b79f36) at ../src/backend/executor/execTuples.c:1737 [12:14:33.695] No locals. [12:14:33.695] #5 0x00000000006f6478 in ExecIRDeleteTriggers (estate=estate@entry=0x834a1c100, relinfo=relinfo@entry=0x834a1c6b0, slot=slot@entry=0x820b7a078) at ../src/backend/commands/trigger.c:2832 [12:14:33.695] trigger = [12:14:33.695] oldtuple = [12:14:33.695] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84083f790, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [12:14:33.695] trigdesc = 0x834a1c8c0 [12:14:33.695] newtuple = 0x0 [12:14:33.695] i = 0 [12:14:33.695] should_free = false [12:14:33.695] #6 0x0000000000755635 in ExecMergeMatched (context=0x820b7a0b0, resultRelInfo=0x834a1c6b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2938 [12:14:33.695] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [12:14:33.695] relaction = 0x840939c98 [12:14:33.695] commandType = CMD_DELETE [12:14:33.695] result = TM_Ok [12:14:33.695] l__state = {l = 0x84093a258, i = 0} [12:14:33.695] mtstate = 0x834a1c4a0 [12:14:33.695] newslot = 0x0 [12:14:33.695] rslot = 0x0 [12:14:33.695] estate = 0x18d48 [12:14:33.695] econtext = 0x8409392c8 [12:14:33.695] epqstate = 0x834a1c588 [12:14:33.695] l = [12:14:33.695] isNull = [12:14:33.695] __error = [12:14:33.695] l__state = [12:14:33.695] updateCxt = [12:14:33.695] relaction = [12:14:33.695] commandType = [12:14:33.695] result = [12:14:33.695] __error = [12:14:33.695] resultRelationDesc = [12:14:33.695] lockmode = [12:14:33.695] inputslot = [12:14:33.695] epqslot = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] #7 ExecMerge (context=context@entry=0x820b7a0b0, resultRelInfo=resultRelInfo@entry=0x834a1c6b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820b7a078, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2717 [12:14:33.695] matched = [12:14:33.695] rslot = 0x0 [12:14:33.695] #8 0x0000000000754653 in ExecModifyTable (pstate=0x834a1c4a0) at ../src/backend/executor/nodeModifyTable.c:3981 [12:14:33.695] context = {mtstate = 0x834a1c4a0, epqstate = 0x834a1c588, estate = 0x834a1c100, planSlot = 0x840937de8, tmfd = {ctid = {ip_blkid = {bi_hi = 10, bi_lo = 0}, ip_posid = 5}, xmax = 883015936, cmax = 8, traversed = 240}, cpUpdateReturningSlot = 0x0} [12:14:33.695] tuple_ctid = {ip_blkid = {bi_hi = 4, bi_lo = 0}, ip_posid = 0} [12:14:33.695] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834a34118} [12:14:33.695] node = 0x834a1c4a0 [12:14:33.695] estate = 0x834a1c100 [12:14:33.695] operation = CMD_MERGE [12:14:33.695] resultRelInfo = 0x6 [12:14:33.695] subplanstate = 0x834a1ddf0 [12:14:33.695] tupleid = 0x0 [12:14:33.695] oldtuple = 0x820b7a078 [12:14:33.695] slot = [12:14:33.695] oldSlot = [12:14:33.695] #9 0x0000000000729f9b in ExecProcNodeFirst (node=0x834a1c4a0) at ../src/backend/executor/execProcnode.c:464 [12:14:33.695] No locals. [12:14:33.695] #10 0x000000000072232a in ExecProcNode (node=0x834a1c4a0) at ../src/include/executor/executor.h:274 [12:14:33.695] No locals. [12:14:33.695] #11 ExecutePlan (estate=0x834a1c100, planstate=0x834a1c4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83488db10, execute_once=false) at ../src/backend/executor/execMain.c:1644 [12:14:33.695] current_tuple_count = [12:14:33.695] slot = [12:14:33.695] #12 standard_ExecutorRun (queryDesc=0x834938448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [12:14:33.695] estate = 0x834a1c100 [12:14:33.695] oldcontext = 0x83488d800 [12:14:33.695] operation = CMD_MERGE [12:14:33.695] dest = 0x83488db10 [12:14:33.695] sendTuples = true [12:14:33.695] #13 0x00000000007221df in ExecutorRun (queryDesc=0x18d48, queryDesc@entry=0x834938448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [12:14:33.695] No locals. [12:14:33.695] #14 0x00000000008f3ecf in ProcessQuery (plan=0x84094aa98, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820b7a2b8) at ../src/backend/tcop/pquery.c:160 [12:14:33.695] queryDesc = 0x834938448 [12:14:33.695] #15 0x00000000008f346d in PortalRunMulti (portal=portal@entry=0x834918100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83488db10, altdest=0xb34ae0 , qc=qc@entry=0x820b7a2b8) at ../src/backend/tcop/pquery.c:1286 [12:14:33.695] pstmt = 0x84094aa98 [12:14:33.695] stmtlist_item__state = {l = 0x84094f300, i = 0} [12:14:33.695] active_snapshot_set = true [12:14:33.695] stmtlist_item = 0x84094f318 [12:14:33.695] #16 0x00000000008f2f5c in FillPortalStore (portal=portal@entry=0x834918100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [12:14:33.695] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:14:33.695] treceiver = 0x83488db10 [12:14:33.695] #17 0x00000000008f2cb0 in PortalRun (portal=portal@entry=0x834918100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x84094f350, altdest=altdest@entry=0x84094f350, qc=0x820b7a3f0) at ../src/backend/tcop/pquery.c:763 [12:14:33.695] _local_sigjmp_buf = {{_sjb = {9382991, 35241995800, 34908644072, 34908644304, 34908644080, 12045256, 12013040, 35241689344, 7112098687, 35241697536, 3565109, 34359738368}}} [12:14:33.695] _save_exception_stack = 0x820b7a4c0 [12:14:33.695] _save_context_stack = 0x0 [12:14:33.695] _do_rethrow = false [12:14:33.695] saveTopTransactionResourceOwner = 0x834962e18 [12:14:33.695] saveTopTransactionContext = 0x83488b000 [12:14:33.695] saveActivePortal = 0x0 [12:14:33.695] saveResourceOwner = 0x834962e18 [12:14:33.695] savePortalContext = 0x0 [12:14:33.695] saveMemoryContext = 0x83488b000 [12:14:33.695] result = [12:14:33.695] nprocessed = [12:14:33.695] #18 0x00000000008f1bbb in exec_simple_query (query_string=query_string@entry=0x83487f100 "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 [12:14:33.695] cmdtaglen = [12:14:33.695] snapshot_set = [12:14:33.695] per_parsetree_context = 0x0 [12:14:33.695] plantree_list = [12:14:33.695] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:14:33.695] parsetree = 0x8409076a8 [12:14:33.695] commandTag = CMDTAG_MERGE [12:14:33.695] cmdtagname = [12:14:33.695] querytree_list = [12:14:33.695] portal = 0x834918100 [12:14:33.695] format = 0 [12:14:33.695] receiver = 0x84094f350 [12:14:33.695] parsetree_item__state = {l = 0x840908f70, i = 0} [12:14:33.695] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [12:14:33.695] dest = DestRemote [12:14:33.695] was_logged = [12:14:33.695] oldcontext = 0x83488b000 [12:14:33.695] parsetree_list = 0x840908f70 [12:14:33.695] use_implicit_block = false [12:14:33.695] parsetree_item = 0x840908f88 [12:14:33.695] save_log_statement_stats = [12:14:33.695] #19 0x00000000008ef9a4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [12:14:33.695] query_string = 0x83487f100 "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"... [12:14:33.695] input_message = {data = 0x83487f100 "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} [12:14:33.695] firstchar = [12:14:33.695] local_sigjmp_buf = {{_sjb = {9367152, 34908644544, 34908644504, 34908645104, 12053992, 12000464, 8192, 8388608, 72057628946531199, 0, 0, 34359738369}}} [12:14:33.695] send_ready_for_query = false [12:14:33.695] idle_in_transaction_timeout_enabled = false [12:14:33.695] idle_session_timeout_enabled = false [12:14:33.695] #20 0x00000000008ea709 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [12:14:33.695] bsdata = [12:14:33.695] #21 0x00000000008474d2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820b7b200 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820b7b148) at ../src/backend/postmaster/launch_backend.c:265 [12:14:33.695] pid = [12:14:33.695] #22 0x000000000084bcf1 in BackendStartup (client_sock=0x820b7b148) at ../src/backend/postmaster/postmaster.c:3593 [12:14:33.695] startup_data = {canAcceptConnections = CAC_OK} [12:14:33.695] bn = 0x83488b088 [12:14:33.695] pid = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] save_errno = [12:14:33.695] __error = [12:14:33.695] __error = [12:14:33.695] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [12:14:33.695] 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' , "\240\261\267 \b\000\000\000\330ś)\b\000\000\000\v\000\000\000\000\000\000\000\016F\234)\b", '\000' , "\340\261\267 \b\000\000\000\244r\204\000\000\000\000\000\360\261\267 \b", '\000' }, salen = 16}} [12:14:33.695] i = 0 [12:14:33.695] now = [12:14:33.695] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 713047140, events = 8, fd = 548906896, user_data = 0x820b7a920}, {pos = 560030728, events = 8, fd = 32, user_data = 0x820b7a910}, {pos = 1469667988, events = 13673, fd = 560001032, user_data = 0x82160f408}, {pos = 560003080, events = 8, fd = 560004104, user_data = 0x821613008}, {pos = 560018440, events = 8, fd = 560019464, user_data = 0x821613c08}, {pos = 560021512, events = 8, fd = 560022536, user_data = 0x821614808}, {pos = 560024584, events = 8, fd = 560025608, user_data = 0x821615408}, {pos = 560027656, events = 8, fd = 560028680, user_data = 0x821616008}, {pos = 560030728, events = 8, fd = 560050312, user_data = 0x820b7aa98}, {pos = 548907200, events = 8, fd = 1469693347, user_data = 0x0}, {pos = 2568186, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 560054328, events = 8, fd = 1, user_data = 0x821616408}, {pos = 712955048, events = 8, fd = 548907928, user_data = 0x821616408}, {pos = 548907184, events = 0, fd = 713062756, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 560056888, user_data = 0x1}, {pos = 560030728, events = 8, fd = 712976600, user_data = 0x820b7a9d8}, {pos = 548906896, events = 8, fd = 32, user_data = 0x82a803c64}, {pos = 560030728, events = 8, fd = 560056888, user_data = 0x0}, {pos = 2625, events = 0, fd = 548907456, user_data = 0x356957995645}, {pos = 713062756, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 560056888, events = 8, fd = 1, user_data = 0x821616408}, {pos = 881258496, events = 8, fd = 1, user_data = 0x83486f194}, {pos = 0, events = 0, fd = 548907408, user_data = 0x8299c3c0c}, {pos = 1, events = 0, fd = 881258496, user_data = 0x820b7a9c0}, {pos = 698101428, events = 8, fd = 714789216, user_data = 0x82a9ad160 }, {pos = 713158848, events = 8, fd = 560030728, user_data = 0x820b7aaa0}, {pos = 1469666348, events = 13673, fd = 560029704, user_data = 0x800000001}, {pos = 1469665966, events = 13673, fd = 12240, user_data = 0x820b7a9c8}, {pos = 548907680, events = 8, fd = 882055144, user_data = 0x820b7b010}, {pos = 1469746832, events = 13673, fd = 560030728, user_data = 0x820b7037f}, {pos = 714446002, events = 8, fd = 560001032, user_data = 0x0}, {pos = 560030728, events = 8, fd = 12240, user_data = 0x82a7e3000}, {pos = 1964368, events = 0, fd = 714789216, user_data = 0x82a803c64}, {pos = 15616, events = 0, fd = 548908864, user_data = 0x820b7ab10}, {pos = 713720206, events = 8, fd = 714827832, user_data = 0x820b7aad4}, {pos = 881710554, events = 8, fd = 548908864, user_data = 0x820b7ab10}, {pos = 713811461, events = 8, fd = 548907730, user_data = 0x820b7af40}, {pos = 548908864, events = 8, fd = 0, user_data = 0x18dc9534f5f9fbe5}, {pos = 548908864, events = 8, fd = 881710552, user_data = 0x820b7b010}, {pos = 714827832, events = 8, fd = 0, user_data = 0x820b7af80}, {pos = 713811725, events = 8, fd = 0, user_data = 0x0}, {pos = 548909232, events = 8, fd = 881710552, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1469694985, events = 13673, fd = 548908136, user_data = 0x82a803c64}, {pos = 2503, events = 0, fd = 1469694985, user_data = 0x820b7ac88}, {pos = 713047140, events = 8, fd = 2758, user_data = 0x82a7fd120}, {pos = 548908040, events = 8, fd = 560030728, user_data = 0x820b7ac88}, {pos = 713019680, events = 8, fd = 548908144, user_data = 0x356957997465}, {pos = 0, events = 0, fd = 0, user_data = 0x82a9cf0f0}, {pos = 712979792, events = 8, fd = 0, user_data = 0x0}, {pos = 714856880, events = 8, fd = 1469694985, user_data = 0x820b7ad18}, {pos = 713047140, events = 8, fd = 2924, user_data = 0x82a7fd3b8}, {pos = 548908184, events = 8, fd = 560030728, user_data = 0x820b7ad18}, {pos = 713020344, events = 8, fd = 548908288, user_data = 0x356957997465}, {pos = 560054328, events = 8, fd = 2671440, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 560030728, events = 8, fd = 712979792, user_data = 0x820b7afd8}, {pos = 560030728, events = 8, fd = 548908728, user_data = 0x1e}, {pos = 712983776, events = 8, fd = 548908456, user_data = 0x82161b248}, {pos = 548908904, events = 8, fd = 548908432, user_data = 0x35695799bda3}, {pos = 560054328, events = 8, fd = 2694910, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 560054328, user_data = 0x1}} [12:14:33.695] last_touch_time = 1711627896 [12:14:33.695] last_lockfile_recheck_time = 1711627896 [12:14:33.695] nevents = 1 [12:14:33.695] #24 0x00000000008495c6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820b7b740) at ../src/backend/postmaster/postmaster.c:1372 [12:14:33.695] userDoption = [12:14:33.695] listen_addr_saved = false [12:14:33.695] output_config_variable = [12:14:33.695] opt = [12:14:33.695] status = [12:14:33.695] #25 0x0000000000784c75 in main (argc=4, argv=0x820b7b740) at ../src/backend/main/main.c:197 [12:14:33.695] do_check_root = [12:14:33.707] [12:14:33.707] [12:14:33.707] [12:14:33.772] dumping /tmp/cores/postgres.14314.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:14:33.901] [New LWP 101703] [12:14:33.969] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [12:14:33.969] Program terminated with signal SIGABRT, Aborted. [12:14:33.969] Sent by thr_kill() from pid 14314 and user 1003. [12:14:33.969] #0 0x000000082bf39dca in thr_kill () from /lib/libc.so.7 [12:14:34.616] [12:14:34.616] Thread 1 (LWP 101703): [12:14:34.616] #0 0x000000082bf39dca in thr_kill () from /lib/libc.so.7 [12:14:34.616] No symbol table info available. [12:14:34.616] #1 0x000000082beb26f4 in raise () from /lib/libc.so.7 [12:14:34.616] No symbol table info available. [12:14:34.616] #2 0x000000082bf63bc9 in abort () from /lib/libc.so.7 [12:14:34.616] No symbol table info available. [12:14:34.616] #3 0x0000000000a44fe7 in ExceptionalCondition (conditionName=, fileName=0x36f696 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [12:14:34.616] No locals. [12:14:34.616] #4 0x000000000072ff50 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820e048f8, materialize=, shouldFree=shouldFree@entry=0x820e047b6) at ../src/backend/executor/execTuples.c:1737 [12:14:34.616] No locals. [12:14:34.616] #5 0x00000000006f6478 in ExecIRDeleteTriggers (estate=estate@entry=0x836339100, relinfo=relinfo@entry=0x8363396b0, slot=slot@entry=0x820e048f8) at ../src/backend/commands/trigger.c:2832 [12:14:34.616] trigger = [12:14:34.616] oldtuple = [12:14:34.616] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83d890080, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [12:14:34.616] trigdesc = 0x8363398c0 [12:14:34.616] newtuple = 0x0 [12:14:34.616] i = 0 [12:14:34.616] should_free = false [12:14:34.616] #6 0x0000000000755635 in ExecMergeMatched (context=0x820e04930, resultRelInfo=0x8363396b0, tupleid=0x0, oldtuple=0x0, canSetTag=false, matched=) at ../src/backend/executor/nodeModifyTable.c:2938 [12:14:34.616] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [12:14:34.616] relaction = 0x839bd6c18 [12:14:34.616] commandType = CMD_DELETE [12:14:34.616] result = TM_Ok [12:14:34.616] l__state = {l = 0x839bd71d8, i = 0} [12:14:34.616] mtstate = 0x8363394a0 [12:14:34.616] newslot = 0x0 [12:14:34.616] rslot = 0x0 [12:14:34.616] estate = 0x18d47 [12:14:34.616] econtext = 0x839bd6248 [12:14:34.616] epqstate = 0x836339588 [12:14:34.616] l = [12:14:34.616] isNull = [12:14:34.616] __error = [12:14:34.616] l__state = [12:14:34.616] updateCxt = [12:14:34.616] relaction = [12:14:34.616] commandType = [12:14:34.616] result = [12:14:34.616] __error = [12:14:34.616] resultRelationDesc = [12:14:34.616] lockmode = [12:14:34.616] inputslot = [12:14:34.616] epqslot = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] #7 ExecMerge (context=context@entry=0x820e04930, resultRelInfo=resultRelInfo@entry=0x8363396b0, tupleid=tupleid@entry=0x0, oldtuple=0x0, oldtuple@entry=0x820e048f8, canSetTag=false) at ../src/backend/executor/nodeModifyTable.c:2717 [12:14:34.616] matched = [12:14:34.616] rslot = 0x0 [12:14:34.616] #8 0x0000000000754653 in ExecModifyTable (pstate=0x8363394a0) at ../src/backend/executor/nodeModifyTable.c:3981 [12:14:34.616] context = {mtstate = 0x8363394a0, epqstate = 0x836339588, estate = 0x836339100, planSlot = 0x839bd4d68, tmfd = {ctid = {ip_blkid = {bi_hi = 18832, bi_lo = 8416}, ip_posid = 8}, xmax = 737371870, cmax = 8, traversed = 109}, cpUpdateReturningSlot = 0xf141d88ee7873692} [12:14:34.616] tuple_ctid = {ip_blkid = {bi_hi = 20424, bi_lo = 39993}, ip_posid = 19625} [12:14:34.616] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x839ab2118} [12:14:34.616] node = 0x8363394a0 [12:14:34.616] estate = 0x836339100 [12:14:34.616] operation = CMD_MERGE [12:14:34.616] resultRelInfo = 0x6 [12:14:34.616] subplanstate = 0x83633adf0 [12:14:34.616] tupleid = 0x0 [12:14:34.616] oldtuple = 0x820e048f8 [12:14:34.616] slot = [12:14:34.616] oldSlot = [12:14:34.616] #9 0x0000000000729f9b in ExecProcNodeFirst (node=0x8363394a0) at ../src/backend/executor/execProcnode.c:464 [12:14:34.616] No locals. [12:14:34.616] #10 0x000000000072232a in ExecProcNode (node=0x8363394a0) at ../src/include/executor/executor.h:274 [12:14:34.616] No locals. [12:14:34.616] #11 ExecutePlan (estate=0x836339100, planstate=0x8363394a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x8362eb710, execute_once=false) at ../src/backend/executor/execMain.c:1644 [12:14:34.616] current_tuple_count = [12:14:34.616] slot = [12:14:34.616] #12 standard_ExecutorRun (queryDesc=0x836216448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [12:14:34.616] estate = 0x836339100 [12:14:34.616] oldcontext = 0x8362eb400 [12:14:34.616] operation = CMD_MERGE [12:14:34.616] dest = 0x8362eb710 [12:14:34.616] sendTuples = true [12:14:34.616] #13 0x0000000838eb9963 in pgss_ExecutorRun (queryDesc=0x836216448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [12:14:34.616] _local_sigjmp_buf = {{_sjb = {35314702642, 12045256, 34911308376, 34911308544, 35267896392, 34911308384, 1, 1, 35269051263, 35267896392, 12053984, 34359738368}}} [12:14:34.616] _save_exception_stack = 0x820e04c20 [12:14:34.616] _save_context_stack = 0x0 [12:14:34.616] _do_rethrow = false [12:14:34.616] #14 0x00000000007221d8 in ExecutorRun (queryDesc=0x18d47, queryDesc@entry=0x836216448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [12:14:34.616] No locals. [12:14:34.616] #15 0x00000000008f3ecf in ProcessQuery (plan=0x839b99590, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820e04be8) at ../src/backend/tcop/pquery.c:160 [12:14:34.616] queryDesc = 0x836216448 [12:14:34.616] #16 0x00000000008f346d in PortalRunMulti (portal=portal@entry=0x8361f8100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8362eb710, altdest=0xb34ae0 , qc=qc@entry=0x820e04be8) at ../src/backend/tcop/pquery.c:1286 [12:14:34.616] pstmt = 0x839b99590 [12:14:34.616] stmtlist_item__state = {l = 0x839b9ddf8, i = 0} [12:14:34.616] active_snapshot_set = true [12:14:34.616] stmtlist_item = 0x839b9de10 [12:14:34.616] #17 0x00000000008f2f5c in FillPortalStore (portal=portal@entry=0x8361f8100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [12:14:34.616] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:14:34.616] treceiver = 0x8362eb710 [12:14:34.616] #18 0x00000000008f2cb0 in PortalRun (portal=portal@entry=0x8361f8100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x839b9de48, altdest=altdest@entry=0x839b9de48, qc=0x820e04d20) at ../src/backend/tcop/pquery.c:763 [12:14:34.616] _local_sigjmp_buf = {{_sjb = {9382991, 35268106584, 34911308824, 34911309056, 34911308832, 12045256, 12013040, 35267772672, 7112098687, 35267780864, 3565109, 34359738368}}} [12:14:34.616] _save_exception_stack = 0x820e04df0 [12:14:34.616] _save_context_stack = 0x0 [12:14:34.616] _do_rethrow = false [12:14:34.616] saveTopTransactionResourceOwner = 0x836249958 [12:14:34.616] saveTopTransactionContext = 0x836169000 [12:14:34.616] saveActivePortal = 0x0 [12:14:34.616] saveResourceOwner = 0x836249958 [12:14:34.616] savePortalContext = 0x0 [12:14:34.616] saveMemoryContext = 0x836169000 [12:14:34.616] result = [12:14:34.616] nprocessed = [12:14:34.616] #19 0x00000000008f1bbb in exec_simple_query (query_string=query_string@entry=0x83615d100 "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 [12:14:34.616] cmdtaglen = [12:14:34.616] snapshot_set = [12:14:34.616] per_parsetree_context = 0x0 [12:14:34.616] plantree_list = [12:14:34.616] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:14:34.616] parsetree = 0x839b76be8 [12:14:34.616] commandTag = CMDTAG_MERGE [12:14:34.616] cmdtagname = [12:14:34.616] querytree_list = [12:14:34.616] portal = 0x8361f8100 [12:14:34.616] format = 0 [12:14:34.616] receiver = 0x839b9de48 [12:14:34.616] parsetree_item__state = {l = 0x839b784b0, i = 0} [12:14:34.616] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [12:14:34.616] dest = DestRemote [12:14:34.616] was_logged = [12:14:34.616] oldcontext = 0x836169000 [12:14:34.616] parsetree_list = 0x839b784b0 [12:14:34.616] use_implicit_block = false [12:14:34.616] parsetree_item = 0x839b784c8 [12:14:34.616] save_log_statement_stats = [12:14:34.616] #20 0x00000000008ef9a4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [12:14:34.616] query_string = 0x83615d100 "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"... [12:14:34.616] input_message = {data = 0x83615d100 "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} [12:14:34.616] firstchar = [12:14:34.616] local_sigjmp_buf = {{_sjb = {9367152, 34911309296, 34911309256, 34911309856, 12053992, 12000464, 8192, 8388608, 72057628949218175, 0, 0, 1}}} [12:14:34.616] send_ready_for_query = false [12:14:34.616] idle_in_transaction_timeout_enabled = false [12:14:34.616] idle_session_timeout_enabled = false [12:14:34.616] #21 0x00000000008ea709 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [12:14:34.616] bsdata = [12:14:34.616] #22 0x00000000008474d2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820e05b30 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820e05a78) at ../src/backend/postmaster/launch_backend.c:265 [12:14:34.616] pid = [12:14:34.616] #23 0x000000000084bcf1 in BackendStartup (client_sock=0x820e05a78) at ../src/backend/postmaster/postmaster.c:3593 [12:14:34.616] startup_data = {canAcceptConnections = CAC_OK} [12:14:34.616] bn = 0x836169128 [12:14:34.616] pid = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] save_errno = [12:14:34.616] __error = [12:14:34.616] __error = [12:14:34.616] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [12:14:34.616] 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' , "\320Z\340 \b\000\000\000\330\025\245+\b\000\000\000\v\000\000\000\000\000\000\000\016\226\245+\b", '\000' , "\020[\340 \b\000\000\000\244r\204\000\000\000\000\000 [\340 \b", '\000' }, salen = 16}} [12:14:34.616] i = 0 [12:14:34.616] now = [12:14:34.616] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 558461960, user_data = 0x0}, {pos = 551572032, events = 8, fd = -449672556, user_data = 0x821490008}, {pos = 558433288, events = 8, fd = 558434312, user_data = 0x821490c08}, {pos = 558448648, events = 8, fd = 558449672, user_data = 0x821494808}, {pos = 558451720, events = 8, fd = 558452744, user_data = 0x821495408}, {pos = 558454792, events = 8, fd = 558455816, user_data = 0x821496008}, {pos = 558457864, events = 8, fd = 558458888, user_data = 0x821496c08}, {pos = 558460936, events = 8, fd = 558461960, user_data = 0x82149c088}, {pos = 551572424, events = 8, fd = 551571936, user_data = 0x930e532eda3}, {pos = 558461960, events = 8, fd = 2568186, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 558485560, user_data = 0x1}, {pos = 558461960, events = 8, fd = 736150696, user_data = 0x820e054c8}, {pos = 558461960, events = 8, fd = 551571904, user_data = 0x272f44}, {pos = 551572496, events = 8, fd = 736258404, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 558488120, user_data = 0x93000000001}, {pos = 558461960, events = 8, fd = 736172248, user_data = 0x820e05308}, {pos = 551571632, events = 8, fd = 33, user_data = 0x82be22c64}, {pos = 558461960, events = 8, fd = 558488120, user_data = 0x0}, {pos = 2625, events = 0, fd = 551572208, user_data = 0x930e5328645}, {pos = 736258404, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 558488120, events = 8, fd = 1, user_data = 0x821497408}, {pos = 907333632, events = 8, fd = 1, user_data = 0x83614d194}, {pos = 0, events = 0, fd = 551572160, user_data = 0x82ba58c0c}, {pos = 1, events = 0, fd = 907333632, user_data = 0x820e052f0}, {pos = 732266164, events = 8, fd = 737984864, user_data = 0x82bfcc160 }, {pos = 736354496, events = 8, fd = 558461960, user_data = 0x820e053d0}, {pos = -449674196, events = 2352, fd = 80627796, user_data = 0x1}, {pos = -449674578, events = 2352, fd = 12240, user_data = 0x820e052f8}, {pos = 551572432, events = 8, fd = 908130280, user_data = 0x820e05940}, {pos = -449593712, events = 2352, fd = 558461960, user_data = 0x820e0037f}, {pos = 737641650, events = 8, fd = 551572736, user_data = 0x93000000000}, {pos = 558461960, events = 8, fd = 12240, user_data = 0x82be02000}, {pos = 1964368, events = 0, fd = 737984864, user_data = 0x82be22c64}, {pos = 15616, events = 0, fd = 551573616, user_data = 0x820e05440}, {pos = 736915854, events = 8, fd = 738023480, user_data = 0x820e05404}, {pos = 907785690, events = 8, fd = 551573616, user_data = 0x820e05440}, {pos = 737007109, events = 8, fd = 551572482, user_data = 0x820e05870}, {pos = 551573616, events = 8, fd = 0, user_data = 0xc0424ca99c394fc8}, {pos = 551573616, events = 8, fd = 907785688, user_data = 0x820e05940}, {pos = 738023480, events = 8, fd = 0, user_data = 0x820e058b0}, {pos = 737007373, events = 8, fd = 0, user_data = 0x0}, {pos = 551573984, events = 8, fd = 907785688, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -449645559, user_data = 0x820e05588}, {pos = 736242788, events = 8, fd = 2503, user_data = 0x930e532f409}, {pos = 551572904, events = 8, fd = 736242788, user_data = 0xac6}, {pos = 736215328, events = 8, fd = 551572776, user_data = 0x821497408}, {pos = 551572904, events = 8, fd = 736215328, user_data = 0x820e05590}, {pos = -449665947, events = 2352, fd = 0, user_data = 0x800000000}, {pos = 551572864, events = 8, fd = 736175440, user_data = 0x0}, {pos = 0, events = 0, fd = 551572832, user_data = 0x930e532f409}, {pos = 551573048, events = 8, fd = 736242788, user_data = 0xb6c}, {pos = 736215992, events = 8, fd = 551572920, user_data = 0x821497408}, {pos = 551573048, events = 8, fd = 736215992, user_data = 0x820e05620}, {pos = -449665947, events = 2352, fd = 558485560, user_data = 0x28c350}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 558461960, user_data = 0x82be12550}, {pos = 551573768, events = 8, fd = 558461960, user_data = 0x20e057e8}, {pos = 31, events = 0, fd = 0, user_data = 0x820e056c8}, {pos = 558483336, events = 8, fd = 551573656, user_data = 0x820e056b0}, {pos = -449647197, events = 2352, fd = 558485560, user_data = 0x291efe}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82149d038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [12:14:34.616] last_touch_time = 1711627918 [12:14:34.616] last_lockfile_recheck_time = 1711627918 [12:14:34.616] nevents = 1 [12:14:34.616] #25 0x00000000008495c6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820e06078) at ../src/backend/postmaster/postmaster.c:1372 [12:14:34.616] userDoption = [12:14:34.616] listen_addr_saved = false [12:14:34.616] output_config_variable = [12:14:34.616] opt = [12:14:34.616] status = [12:14:34.616] #26 0x0000000000784c75 in main (argc=4, argv=0x820e06078) at ../src/backend/main/main.c:197 [12:14:34.616] do_check_root =