[02:21:01.599] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [02:21:01.960] dumping /tmp/cores/postgres.8316.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:21:02.089] [New LWP 101707] [02:21:02.175] Core was generated by `postgres: postgres regression [local] MERGE'. [02:21:02.175] Program terminated with signal SIGABRT, Aborted. [02:21:02.175] Sent by thr_kill() from pid 8316 and user 1003. [02:21:02.175] #0 0x000000082af02dca in thr_kill () from /lib/libc.so.7 [02:21:02.712] [02:21:02.712] Thread 1 (LWP 101707): [02:21:02.712] #0 0x000000082af02dca in thr_kill () from /lib/libc.so.7 [02:21:02.712] No symbol table info available. [02:21:02.712] #1 0x000000082ae7b6f4 in raise () from /lib/libc.so.7 [02:21:02.712] No symbol table info available. [02:21:02.712] #2 0x000000082af2cbc9 in abort () from /lib/libc.so.7 [02:21:02.712] No symbol table info available. [02:21:02.712] #3 0x0000000000a5e6d7 in ExceptionalCondition (conditionName=, fileName=0x372f34 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [02:21:02.712] No locals. [02:21:02.712] #4 0x00000000007407c0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8212ed7e0, materialize=, shouldFree=shouldFree@entry=0x8212ed786) at ../src/backend/executor/execTuples.c:1737 [02:21:02.712] No locals. [02:21:02.712] #5 0x0000000000706a18 in ExecIRDeleteTriggers (estate=estate@entry=0x834eb2100, relinfo=relinfo@entry=0x834eb26b0, slot=slot@entry=0x8212ed7e0) at ../src/backend/commands/trigger.c:2841 [02:21:02.712] trigger = [02:21:02.712] oldtuple = [02:21:02.712] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84270f948, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [02:21:02.712] trigdesc = 0x834eb28c0 [02:21:02.712] newtuple = 0x0 [02:21:02.712] i = 0 [02:21:02.712] should_free = false [02:21:02.712] #6 0x0000000000765a3a in ExecMergeMatched (context=0x8212ed8a0, resultRelInfo=0x834eb26b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [02:21:02.712] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [02:21:02.712] relaction = 0x841578a60 [02:21:02.712] commandType = CMD_DELETE [02:21:02.712] result = TM_Ok [02:21:02.712] l__state = {l = 0x84166ad48, i = 0} [02:21:02.712] mtstate = 0x834eb24a0 [02:21:02.712] newslot = 0x0 [02:21:02.712] rslot = 0x0 [02:21:02.712] estate = 0x18d4b [02:21:02.712] mergeActions = [02:21:02.712] econtext = 0x841669de8 [02:21:02.712] epqstate = 0x834eb2588 [02:21:02.712] actionStates = 0x84166ad48 [02:21:02.712] l = [02:21:02.712] isNull = [02:21:02.712] lmerge_matched = [02:21:02.712] __error = [02:21:02.712] l__state = [02:21:02.712] updateCxt = [02:21:02.712] relaction = [02:21:02.712] commandType = [02:21:02.712] result = [02:21:02.712] __error = [02:21:02.712] resultRelationDesc = [02:21:02.712] lockmode = [02:21:02.712] inputslot = [02:21:02.712] epqslot = [02:21:02.712] was_matched = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] #7 ExecMerge (context=0x8212ed8a0, resultRelInfo=0x834eb26b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [02:21:02.712] matched = [02:21:02.712] rslot = 0x0 [02:21:02.712] #8 ExecModifyTable (pstate=0x834eb24a0) at ../src/backend/executor/nodeModifyTable.c:4112 [02:21:02.712] context = {mtstate = 0x834eb24a0, epqstate = 0x834eb2588, estate = 0x834eb2100, planSlot = 0x8415789d0, tmfd = {ctid = {ip_blkid = {bi_hi = 40960, bi_lo = 16745}, ip_posid = 8}, xmax = 887826096, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x834eb2100} [02:21:02.712] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [02:21:02.712] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834ec6118} [02:21:02.712] node = 0x834eb24a0 [02:21:02.712] estate = 0x834eb2100 [02:21:02.712] operation = CMD_MERGE [02:21:02.712] resultRelInfo = 0x834eb26b0 [02:21:02.712] subplanstate = 0x834eb3df0 [02:21:02.712] slot = [02:21:02.712] tupleid = 0x0 [02:21:02.712] oldtuple = 0x0 [02:21:02.712] oldSlot = [02:21:02.712] #9 0x000000000073a85b in ExecProcNodeFirst (node=0x834eb24a0) at ../src/backend/executor/execProcnode.c:464 [02:21:02.712] No locals. [02:21:02.712] #10 0x0000000000732b4a in ExecProcNode (node=0x834eb24a0) at ../src/include/executor/executor.h:274 [02:21:02.712] No locals. [02:21:02.712] #11 ExecutePlan (estate=0x834eb2100, planstate=0x834eb24a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x834df7f10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [02:21:02.712] current_tuple_count = [02:21:02.712] slot = [02:21:02.712] #12 standard_ExecutorRun (queryDesc=0x834d93448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [02:21:02.712] estate = 0x834eb2100 [02:21:02.712] oldcontext = 0x834df7c00 [02:21:02.712] operation = CMD_MERGE [02:21:02.712] dest = 0x834df7f10 [02:21:02.712] sendTuples = true [02:21:02.712] #13 0x00000000007329ff in ExecutorRun (queryDesc=0x18d4b, queryDesc@entry=0x834d93448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [02:21:02.712] No locals. [02:21:02.712] #14 0x000000000090becf in ProcessQuery (plan=0x8416974e0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8212edab8) at ../src/backend/tcop/pquery.c:160 [02:21:02.712] queryDesc = 0x834d93448 [02:21:02.712] #15 0x000000000090b46d in PortalRunMulti (portal=portal@entry=0x834dc6100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x834df7f10, altdest=0xb52b20 , qc=qc@entry=0x8212edab8) at ../src/backend/tcop/pquery.c:1286 [02:21:02.712] pstmt = 0x8416974e0 [02:21:02.712] stmtlist_item__state = {l = 0x84169bd98, i = 0} [02:21:02.712] active_snapshot_set = true [02:21:02.712] stmtlist_item = 0x84169bdb0 [02:21:02.712] #16 0x000000000090af5c in FillPortalStore (portal=portal@entry=0x834dc6100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [02:21:02.712] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:21:02.712] treceiver = 0x834df7f10 [02:21:02.712] #17 0x000000000090acb0 in PortalRun (portal=portal@entry=0x834dc6100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x84169bde8, altdest=altdest@entry=0x84169bde8, qc=0x8212edbf0) at ../src/backend/tcop/pquery.c:763 [02:21:02.712] _local_sigjmp_buf = {{_sjb = {9481295, 35246669208, 34916457192, 34916457424, 34916457200, 12170504, 12138288, 35246596352, 7112098687, 35246604544, 3579282, 34359738368}}} [02:21:02.712] _save_exception_stack = 0x8212edcc0 [02:21:02.712] _save_context_stack = 0x0 [02:21:02.712] _do_rethrow = false [02:21:02.712] saveTopTransactionResourceOwner = 0x834dd7d98 [02:21:02.712] saveTopTransactionContext = 0x834cfc000 [02:21:02.712] saveActivePortal = 0x0 [02:21:02.712] saveResourceOwner = 0x834dd7d98 [02:21:02.712] savePortalContext = 0x0 [02:21:02.712] saveMemoryContext = 0x834cfc000 [02:21:02.712] result = [02:21:02.712] nprocessed = [02:21:02.712] #18 0x0000000000909bbb in exec_simple_query (query_string=query_string@entry=0x834cf0100 "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 [02:21:02.712] cmdtaglen = [02:21:02.712] snapshot_set = [02:21:02.712] per_parsetree_context = 0x0 [02:21:02.712] plantree_list = [02:21:02.712] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:21:02.712] parsetree = 0x8416385e8 [02:21:02.712] commandTag = CMDTAG_MERGE [02:21:02.712] cmdtagname = [02:21:02.712] querytree_list = [02:21:02.712] portal = 0x834dc6100 [02:21:02.712] format = 0 [02:21:02.712] receiver = 0x84169bde8 [02:21:02.712] parsetree_item__state = {l = 0x841639eb0, i = 0} [02:21:02.712] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [02:21:02.712] dest = DestRemote [02:21:02.712] was_logged = [02:21:02.712] oldcontext = 0x834cfc000 [02:21:02.712] parsetree_list = 0x841639eb0 [02:21:02.712] use_implicit_block = false [02:21:02.712] parsetree_item = 0x841639ec8 [02:21:02.712] save_log_statement_stats = [02:21:02.712] #19 0x0000000000907994 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [02:21:02.712] query_string = 0x834cf0100 "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"... [02:21:02.712] input_message = {data = 0x834cf0100 "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} [02:21:02.712] firstchar = [02:21:02.712] local_sigjmp_buf = {{_sjb = {9465440, 34916457664, 34916457624, 34916458224, 12179240, 12125712, 8192, 8388608, 72057628954329983, 0, 0, 34359738369}}} [02:21:02.712] send_ready_for_query = false [02:21:02.712] idle_in_transaction_timeout_enabled = false [02:21:02.712] idle_session_timeout_enabled = false [02:21:02.712] #20 0x0000000000902469 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [02:21:02.712] bsdata = [02:21:02.712] #21 0x000000000085c2c2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8212eea00 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212ee948) at ../src/backend/postmaster/launch_backend.c:265 [02:21:02.712] pid = [02:21:02.712] #22 0x0000000000860c21 in BackendStartup (client_sock=0x8212ee948) at ../src/backend/postmaster/postmaster.c:3593 [02:21:02.712] startup_data = {canAcceptConnections = CAC_OK} [02:21:02.712] bn = 0x834cfc448 [02:21:02.712] pid = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] save_errno = [02:21:02.712] __error = [02:21:02.712] __error = [02:21:02.712] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [02:21:02.712] 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' , "\240\351.!\b\000\000\000\330\005\242*\b\000\000\000\v\000\000\000\000\000\000\000\016\206\242*\b", '\000' , "\340\351.!\b\000\000\000\224\300\205\000\000\000\000\000\360\351.!\b", '\000' }, salen = 16}} [02:21:02.712] i = 0 [02:21:02.712] now = [02:21:02.712] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 719240292, events = 8, fd = 556720016, user_data = 0x8212ee120}, {pos = 567231496, events = 8, fd = 32, user_data = 0x8212ee110}, {pos = -1917265260, events = 11256, fd = 567201800, user_data = 0x821ced408}, {pos = 567203848, events = 8, fd = 567204872, user_data = 0x821cf1008}, {pos = 567219208, events = 8, fd = 567220232, user_data = 0x821cf1c08}, {pos = 567222280, events = 8, fd = 567223304, user_data = 0x821cf2808}, {pos = 567225352, events = 8, fd = 567226376, user_data = 0x821cf3408}, {pos = 567228424, events = 8, fd = 567229448, user_data = 0x821cf4008}, {pos = 567231496, events = 8, fd = -1, user_data = 0x82afc32e0}, {pos = 556720256, events = 8, fd = 720830889, user_data = 0x0}, {pos = 4096, events = 0, fd = 667321408, user_data = 0x82afc37e8}, {pos = 882940896, events = 8, fd = 160, user_data = 0x0}, {pos = 850006160, events = 8, fd = 556720464, user_data = 0x82af4e92c}, {pos = 4096, events = 0, fd = 719255908, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 567257656, user_data = 0x800000001}, {pos = 567231496, events = 8, fd = 719169752, user_data = 0x8212ee1d8}, {pos = 556720016, events = 8, fd = 32, user_data = 0x82adebc64}, {pos = 567231496, events = 8, fd = 567257656, user_data = 0x0}, {pos = 2625, events = 0, fd = 556720576, user_data = 0x2bf88db8d645}, {pos = 719255908, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 567257656, events = 8, fd = 1, user_data = 0x821cf4408}, {pos = 885915648, events = 8, fd = 1, user_data = 0x834ce0194}, {pos = 0, events = 0, fd = 556720528, user_data = 0x82aa27c0c}, {pos = 1, events = 0, fd = 885915648, user_data = 0x8212ee1c0}, {pos = 715288244, events = 8, fd = 720982368, user_data = 0x82af95160 }, {pos = 719352000, events = 8, fd = 567231496, user_data = 0x8212ee2a0}, {pos = -1917266900, events = 11256, fd = 850006160, user_data = 0x800000001}, {pos = -1917267282, events = 11256, fd = 12240, user_data = 0x8212ee1c8}, {pos = 556720800, events = 8, fd = 886622184, user_data = 0x8212ee810}, {pos = -1917186416, events = 11256, fd = 567231496, user_data = 0x8212e037f}, {pos = 720639388, events = 8, fd = 567201800, user_data = 0x0}, {pos = 567231496, events = 8, fd = 12240, user_data = 0x82adcb000}, {pos = 1964368, events = 0, fd = 720982368, user_data = 0x82adebc64}, {pos = 15616, events = 0, fd = 556721984, user_data = 0x8212ee310}, {pos = 719913358, events = 8, fd = 721020984, user_data = 0x8212ee2d4}, {pos = 886359514, events = 8, fd = 556721984, user_data = 0x8212ee310}, {pos = 720004613, events = 8, fd = 556720850, user_data = 0x8212ee740}, {pos = 556721984, events = 8, fd = 0, user_data = 0xbb7d74d827c68440}, {pos = 556721984, events = 8, fd = 886359512, user_data = 0x8212ee810}, {pos = 721020984, events = 8, fd = 0, user_data = 0x8212ee780}, {pos = 720004877, events = 8, fd = 0, user_data = 0x0}, {pos = 556722352, events = 8, fd = 886359512, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1917238263, events = 11256, fd = 556721256, user_data = 0x82adebc64}, {pos = 2503, events = 0, fd = -1917238263, user_data = 0x8212ee488}, {pos = 719240292, events = 8, fd = 2758, user_data = 0x82ade5120}, {pos = 556721160, events = 8, fd = 567231496, user_data = 0x8212ee488}, {pos = 719212832, events = 8, fd = 556721264, user_data = 0x2bf88db8f465}, {pos = 0, events = 0, fd = 0, user_data = 0x82afb70f0}, {pos = 719172944, events = 8, fd = 0, user_data = 0x0}, {pos = 721050032, events = 8, fd = -1917238263, user_data = 0x8212ee518}, {pos = 719240292, events = 8, fd = 2924, user_data = 0x82ade53b8}, {pos = 556721304, events = 8, fd = 567231496, user_data = 0x8212ee518}, {pos = 719213496, events = 8, fd = 556721408, user_data = 0x2bf88db8f465}, {pos = 567255096, events = 8, fd = 2675099, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567231496, events = 8, fd = 719172944, user_data = 0x8212ee7d8}, {pos = 567231496, events = 8, fd = 556721848, user_data = 0x1e}, {pos = 719176928, events = 8, fd = 556721576, user_data = 0x821cf9288}, {pos = 556722024, events = 8, fd = 556721552, user_data = 0x2bf88db93da3}, {pos = 567255096, events = 8, fd = 2698787, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 567255096, user_data = 0x1}} [02:21:02.712] last_touch_time = 1714875482 [02:21:02.712] last_lockfile_recheck_time = 1714875482 [02:21:02.712] nevents = 1 [02:21:02.712] #24 0x000000000085e4f6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8212eef48) at ../src/backend/postmaster/postmaster.c:1372 [02:21:02.712] userDoption = [02:21:02.712] listen_addr_saved = false [02:21:02.712] output_config_variable = [02:21:02.712] opt = [02:21:02.712] status = [02:21:02.712] #25 0x0000000000795eb5 in main (argc=8, argv=0x8212eef48) at ../src/backend/main/main.c:197 [02:21:02.712] do_check_root = [02:21:02.723] [02:21:02.723] [02:21:02.723] [02:21:02.786] dumping /tmp/cores/postgres.8907.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:21:02.908] [New LWP 101709] [02:21:02.971] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [02:21:02.971] Program terminated with signal SIGABRT, Aborted. [02:21:02.971] Sent by thr_kill() from pid 8907 and user 1003. [02:21:02.971] #0 0x0000000828b93dca in thr_kill () from /lib/libc.so.7 [02:21:03.481] [02:21:03.481] Thread 1 (LWP 101709): [02:21:03.481] #0 0x0000000828b93dca in thr_kill () from /lib/libc.so.7 [02:21:03.481] No symbol table info available. [02:21:03.481] #1 0x0000000828b0c6f4 in raise () from /lib/libc.so.7 [02:21:03.481] No symbol table info available. [02:21:03.481] #2 0x0000000828bbdbc9 in abort () from /lib/libc.so.7 [02:21:03.481] No symbol table info available. [02:21:03.481] #3 0x0000000000a5e6d7 in ExceptionalCondition (conditionName=, fileName=0x372f34 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [02:21:03.481] No locals. [02:21:03.481] #4 0x00000000007407c0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820d2b5a0, materialize=, shouldFree=shouldFree@entry=0x820d2b546) at ../src/backend/executor/execTuples.c:1737 [02:21:03.481] No locals. [02:21:03.481] #5 0x0000000000706a18 in ExecIRDeleteTriggers (estate=estate@entry=0x834c76100, relinfo=relinfo@entry=0x834c766b0, slot=slot@entry=0x820d2b5a0) at ../src/backend/commands/trigger.c:2841 [02:21:03.481] trigger = [02:21:03.481] oldtuple = [02:21:03.481] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8432a9190, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [02:21:03.481] trigdesc = 0x834c768c0 [02:21:03.481] newtuple = 0x0 [02:21:03.481] i = 0 [02:21:03.481] should_free = false [02:21:03.481] #6 0x0000000000765a3a in ExecMergeMatched (context=0x820d2b660, resultRelInfo=0x834c766b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [02:21:03.481] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [02:21:03.481] relaction = 0x84333d320 [02:21:03.481] commandType = CMD_DELETE [02:21:03.481] result = TM_Ok [02:21:03.481] l__state = {l = 0x8433b8e48, i = 0} [02:21:03.481] mtstate = 0x834c764a0 [02:21:03.481] newslot = 0x0 [02:21:03.481] rslot = 0x0 [02:21:03.481] estate = 0x18d4d [02:21:03.481] mergeActions = [02:21:03.481] econtext = 0x8433b7ee8 [02:21:03.481] epqstate = 0x834c76588 [02:21:03.481] actionStates = 0x8433b8e48 [02:21:03.481] l = [02:21:03.481] isNull = [02:21:03.481] lmerge_matched = [02:21:03.481] __error = [02:21:03.481] l__state = [02:21:03.481] updateCxt = [02:21:03.481] relaction = [02:21:03.481] commandType = [02:21:03.481] result = [02:21:03.481] __error = [02:21:03.481] resultRelationDesc = [02:21:03.481] lockmode = [02:21:03.481] inputslot = [02:21:03.481] epqslot = [02:21:03.481] was_matched = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] #7 ExecMerge (context=0x820d2b660, resultRelInfo=0x834c766b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [02:21:03.481] matched = [02:21:03.481] rslot = 0x0 [02:21:03.481] #8 ExecModifyTable (pstate=0x834c764a0) at ../src/backend/executor/nodeModifyTable.c:4112 [02:21:03.481] context = {mtstate = 0x834c764a0, epqstate = 0x834c76588, estate = 0x834c76100, planSlot = 0x84333d290, tmfd = {ctid = {ip_blkid = {bi_hi = 34880, bi_lo = 17214}, ip_posid = 8}, xmax = 885483184, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x834c76100} [02:21:03.481] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [02:21:03.481] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834c8a118} [02:21:03.481] node = 0x834c764a0 [02:21:03.481] estate = 0x834c76100 [02:21:03.481] operation = CMD_MERGE [02:21:03.481] resultRelInfo = 0x834c766b0 [02:21:03.481] subplanstate = 0x834c77df0 [02:21:03.481] slot = [02:21:03.481] tupleid = 0x0 [02:21:03.481] oldtuple = 0x0 [02:21:03.481] oldSlot = [02:21:03.481] #9 0x000000000073a85b in ExecProcNodeFirst (node=0x834c764a0) at ../src/backend/executor/execProcnode.c:464 [02:21:03.481] No locals. [02:21:03.481] #10 0x0000000000732b4a in ExecProcNode (node=0x834c764a0) at ../src/include/executor/executor.h:274 [02:21:03.481] No locals. [02:21:03.481] #11 ExecutePlan (estate=0x834c76100, planstate=0x834c764a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x834ae4b10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [02:21:03.481] current_tuple_count = [02:21:03.481] slot = [02:21:03.481] #12 standard_ExecutorRun (queryDesc=0x834b8f448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [02:21:03.481] estate = 0x834c76100 [02:21:03.481] oldcontext = 0x834ae4800 [02:21:03.481] operation = CMD_MERGE [02:21:03.481] dest = 0x834ae4b10 [02:21:03.481] sendTuples = true [02:21:03.481] #13 0x00000000007329ff in ExecutorRun (queryDesc=0x18d4d, queryDesc@entry=0x834b8f448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [02:21:03.481] No locals. [02:21:03.481] #14 0x000000000090becf in ProcessQuery (plan=0x8433e5d20, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820d2b878) at ../src/backend/tcop/pquery.c:160 [02:21:03.481] queryDesc = 0x834b8f448 [02:21:03.481] #15 0x000000000090b46d in PortalRunMulti (portal=portal@entry=0x834b6f100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x834ae4b10, altdest=0xb52b20 , qc=qc@entry=0x820d2b878) at ../src/backend/tcop/pquery.c:1286 [02:21:03.481] pstmt = 0x8433e5d20 [02:21:03.481] stmtlist_item__state = {l = 0x8433ea5d8, i = 0} [02:21:03.481] active_snapshot_set = true [02:21:03.481] stmtlist_item = 0x8433ea5f0 [02:21:03.481] #16 0x000000000090af5c in FillPortalStore (portal=portal@entry=0x834b6f100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [02:21:03.481] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:21:03.481] treceiver = 0x834ae4b10 [02:21:03.481] #17 0x000000000090acb0 in PortalRun (portal=portal@entry=0x834b6f100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8433ea628, altdest=altdest@entry=0x8433ea628, qc=0x820d2b9b0) at ../src/backend/tcop/pquery.c:763 [02:21:03.481] _local_sigjmp_buf = {{_sjb = {9481295, 35244480792, 34910419112, 34910419344, 34910419120, 12170504, 12138288, 35244142848, 7112098687, 35244151040, 3579282, 34359738368}}} [02:21:03.481] _save_exception_stack = 0x820d2ba80 [02:21:03.481] _save_context_stack = 0x0 [02:21:03.481] _do_rethrow = false [02:21:03.481] saveTopTransactionResourceOwner = 0x834bc1918 [02:21:03.481] saveTopTransactionContext = 0x834ae2000 [02:21:03.481] saveActivePortal = 0x0 [02:21:03.481] saveResourceOwner = 0x834bc1918 [02:21:03.481] savePortalContext = 0x0 [02:21:03.481] saveMemoryContext = 0x834ae2000 [02:21:03.481] result = [02:21:03.481] nprocessed = [02:21:03.481] #18 0x0000000000909bbb in exec_simple_query (query_string=query_string@entry=0x834ad6100 "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 [02:21:03.481] cmdtaglen = [02:21:03.481] snapshot_set = [02:21:03.481] per_parsetree_context = 0x0 [02:21:03.481] plantree_list = [02:21:03.481] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:21:03.481] parsetree = 0x843385f28 [02:21:03.481] commandTag = CMDTAG_MERGE [02:21:03.481] cmdtagname = [02:21:03.481] querytree_list = [02:21:03.481] portal = 0x834b6f100 [02:21:03.481] format = 0 [02:21:03.481] receiver = 0x8433ea628 [02:21:03.481] parsetree_item__state = {l = 0x8433877f0, i = 0} [02:21:03.481] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [02:21:03.481] dest = DestRemote [02:21:03.481] was_logged = [02:21:03.481] oldcontext = 0x834ae2000 [02:21:03.481] parsetree_list = 0x8433877f0 [02:21:03.481] use_implicit_block = false [02:21:03.481] parsetree_item = 0x843387808 [02:21:03.481] save_log_statement_stats = [02:21:03.481] #19 0x0000000000907994 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [02:21:03.481] query_string = 0x834ad6100 "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"... [02:21:03.481] input_message = {data = 0x834ad6100 "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} [02:21:03.481] firstchar = [02:21:03.481] local_sigjmp_buf = {{_sjb = {9465440, 34910419584, 34910419544, 34910420144, 12179240, 12125712, 8192, 8388608, 72057628948300671, 0, 0, 34359738369}}} [02:21:03.481] send_ready_for_query = false [02:21:03.481] idle_in_transaction_timeout_enabled = false [02:21:03.481] idle_session_timeout_enabled = false [02:21:03.481] #20 0x0000000000902469 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [02:21:03.481] bsdata = [02:21:03.481] #21 0x000000000085c2c2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d2c7c0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d2c708) at ../src/backend/postmaster/launch_backend.c:265 [02:21:03.481] pid = [02:21:03.481] #22 0x0000000000860c21 in BackendStartup (client_sock=0x820d2c708) at ../src/backend/postmaster/postmaster.c:3593 [02:21:03.481] startup_data = {canAcceptConnections = CAC_OK} [02:21:03.481] bn = 0x834ae2088 [02:21:03.481] pid = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] save_errno = [02:21:03.481] __error = [02:21:03.481] __error = [02:21:03.481] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [02:21:03.481] 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' , "`\307\322 \b\000\000\000ص8)\b\000\000\000\v\000\000\000\000\000\000\000\01669)\b", '\000' , "\240\307\322 \b\000\000\000\224\300\205\000\000\000\000\000\260\307\322 \b", '\000' }, salen = 16}} [02:21:03.481] i = 0 [02:21:03.481] now = [02:21:03.481] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 682085476, events = 8, fd = 550681936, user_data = 0x820d2bee0}, {pos = 555701256, events = 8, fd = 32, user_data = 0x820d2bed0}, {pos = 714951316, events = 2919, fd = 555671560, user_data = 0x8211ee408}, {pos = 555673608, events = 8, fd = 555674632, user_data = 0x8211f2008}, {pos = 555688968, events = 8, fd = 555689992, user_data = 0x8211f2c08}, {pos = 555692040, events = 8, fd = 555693064, user_data = 0x8211f3808}, {pos = 555695112, events = 8, fd = 555696136, user_data = 0x8211f4408}, {pos = 555698184, events = 8, fd = 555699208, user_data = 0x8211f5008}, {pos = 555701256, events = 8, fd = 555720904, user_data = 0x820d2c058}, {pos = 550682240, events = 8, fd = 714976675, user_data = 0x0}, {pos = 2571362, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 555724856, events = 8, fd = 1, user_data = 0x8211f5408}, {pos = 681993384, events = 8, fd = 550682968, user_data = 0x8211f5408}, {pos = 550682224, events = 0, fd = 682101092, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 555727416, user_data = 0x1}, {pos = 555701256, events = 8, fd = 682014936, user_data = 0x820d2bf98}, {pos = 550681936, events = 8, fd = 32, user_data = 0x828a7cc64}, {pos = 555701256, events = 8, fd = 555727416, user_data = 0x0}, {pos = 2625, events = 0, fd = 550682496, user_data = 0xb672a9d4645}, {pos = 682101092, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 555727416, events = 8, fd = 1, user_data = 0x8211f5408}, {pos = 883712000, events = 8, fd = 1, user_data = 0x834ac6194}, {pos = 0, events = 0, fd = 550682448, user_data = 0x829392c0c}, {pos = 1, events = 0, fd = 883712000, user_data = 0x820d2bf80}, {pos = 691609268, events = 8, fd = 683827552, user_data = 0x828c26160 }, {pos = 682197184, events = 8, fd = 555701256, user_data = 0x820d2c060}, {pos = 714949676, events = 2919, fd = 555700232, user_data = 0x800000001}, {pos = 714949294, events = 2919, fd = 12240, user_data = 0x820d2bf88}, {pos = 550682720, events = 8, fd = 884508648, user_data = 0x820d2c5d0}, {pos = 715030160, events = 2919, fd = 555701256, user_data = 0x820d2037f}, {pos = 683484338, events = 8, fd = 555671560, user_data = 0x0}, {pos = 555701256, events = 8, fd = 12240, user_data = 0x828a5c000}, {pos = 1964368, events = 0, fd = 683827552, user_data = 0x828a7cc64}, {pos = 15616, events = 0, fd = 550683904, user_data = 0x820d2c0d0}, {pos = 682758542, events = 8, fd = 683866168, user_data = 0x820d2c094}, {pos = 884164058, events = 8, fd = 550683904, user_data = 0x820d2c0d0}, {pos = 682849797, events = 8, fd = 550682770, user_data = 0x820d2c500}, {pos = 550683904, events = 8, fd = 0, user_data = 0x4cccdec7389ba65a}, {pos = 550683904, events = 8, fd = 884164056, user_data = 0x820d2c5d0}, {pos = 683866168, events = 8, fd = 0, user_data = 0x820d2c540}, {pos = 682850061, events = 8, fd = 0, user_data = 0x0}, {pos = 550684272, events = 8, fd = 884164056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 714978313, events = 2919, fd = 550683176, user_data = 0x828a7cc64}, {pos = 2503, events = 0, fd = 714978313, user_data = 0x820d2c248}, {pos = 682085476, events = 8, fd = 2758, user_data = 0x828a76120}, {pos = 550683080, events = 8, fd = 555701256, user_data = 0x820d2c248}, {pos = 682058016, events = 8, fd = 550683184, user_data = 0xb672a9d6465}, {pos = 0, events = 0, fd = 0, user_data = 0x828c480f0}, {pos = 682018128, events = 8, fd = 0, user_data = 0x0}, {pos = 683895216, events = 8, fd = 714978313, user_data = 0x820d2c2d8}, {pos = 682085476, events = 8, fd = 2924, user_data = 0x828a763b8}, {pos = 550683224, events = 8, fd = 555701256, user_data = 0x820d2c2d8}, {pos = 682058680, events = 8, fd = 550683328, user_data = 0xb672a9d6465}, {pos = 555724856, events = 8, fd = 2675099, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 555701256, events = 8, fd = 682018128, user_data = 0x820d2c598}, {pos = 555701256, events = 8, fd = 550683768, user_data = 0x1e}, {pos = 682022112, events = 8, fd = 550683496, user_data = 0x8211fa288}, {pos = 550683944, events = 8, fd = 550683472, user_data = 0xb672a9dada3}, {pos = 555724856, events = 8, fd = 2698787, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 555724856, user_data = 0x1}} [02:21:03.481] last_touch_time = 1714875484 [02:21:03.481] last_lockfile_recheck_time = 1714875484 [02:21:03.481] nevents = 1 [02:21:03.481] #24 0x000000000085e4f6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820d2cd00) at ../src/backend/postmaster/postmaster.c:1372 [02:21:03.481] userDoption = [02:21:03.481] listen_addr_saved = false [02:21:03.481] output_config_variable = [02:21:03.481] opt = [02:21:03.481] status = [02:21:03.481] #25 0x0000000000795eb5 in main (argc=4, argv=0x820d2cd00) at ../src/backend/main/main.c:197 [02:21:03.481] do_check_root = [02:21:03.491] [02:21:03.491] [02:21:03.491] [02:21:03.558] dumping /tmp/cores/postgres.14182.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:21:03.679] [New LWP 101806] [02:21:03.748] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [02:21:03.748] Program terminated with signal SIGABRT, Aborted. [02:21:03.748] Sent by thr_kill() from pid 14182 and user 1003. [02:21:03.748] #0 0x000000082db9ddca in thr_kill () from /lib/libc.so.7 [02:21:04.271] [02:21:04.271] Thread 1 (LWP 101806): [02:21:04.271] #0 0x000000082db9ddca in thr_kill () from /lib/libc.so.7 [02:21:04.271] No symbol table info available. [02:21:04.271] #1 0x000000082db166f4 in raise () from /lib/libc.so.7 [02:21:04.271] No symbol table info available. [02:21:04.271] #2 0x000000082dbc7bc9 in abort () from /lib/libc.so.7 [02:21:04.271] No symbol table info available. [02:21:04.271] #3 0x0000000000a5e6d7 in ExceptionalCondition (conditionName=, fileName=0x372f34 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [02:21:04.271] No locals. [02:21:04.271] #4 0x00000000007407c0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8213b4b80, materialize=, shouldFree=shouldFree@entry=0x8213b4b26) at ../src/backend/executor/execTuples.c:1737 [02:21:04.271] No locals. [02:21:04.271] #5 0x0000000000706a18 in ExecIRDeleteTriggers (estate=estate@entry=0x8365cb100, relinfo=relinfo@entry=0x8365cb6b0, slot=slot@entry=0x8213b4b80) at ../src/backend/commands/trigger.c:2841 [02:21:04.271] trigger = [02:21:04.271] oldtuple = [02:21:04.271] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84052cce8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [02:21:04.271] trigdesc = 0x8365cb8c0 [02:21:04.271] newtuple = 0x0 [02:21:04.271] i = 0 [02:21:04.271] should_free = false [02:21:04.271] #6 0x0000000000765a3a in ExecMergeMatched (context=0x8213b4c40, resultRelInfo=0x8365cb6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [02:21:04.271] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [02:21:04.271] relaction = 0x836581960 [02:21:04.271] commandType = CMD_DELETE [02:21:04.271] result = TM_Ok [02:21:04.271] l__state = {l = 0x8406a5d88, i = 0} [02:21:04.271] mtstate = 0x8365cb4a0 [02:21:04.271] newslot = 0x0 [02:21:04.271] rslot = 0x0 [02:21:04.271] estate = 0x18dae [02:21:04.271] mergeActions = [02:21:04.271] econtext = 0x8406a4e28 [02:21:04.271] epqstate = 0x8365cb588 [02:21:04.271] actionStates = 0x8406a5d88 [02:21:04.271] l = [02:21:04.271] isNull = [02:21:04.271] lmerge_matched = [02:21:04.271] __error = [02:21:04.271] l__state = [02:21:04.271] updateCxt = [02:21:04.271] relaction = [02:21:04.271] commandType = [02:21:04.271] result = [02:21:04.271] __error = [02:21:04.271] resultRelationDesc = [02:21:04.271] lockmode = [02:21:04.271] inputslot = [02:21:04.271] epqslot = [02:21:04.271] was_matched = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] #7 ExecMerge (context=0x8213b4c40, resultRelInfo=0x8365cb6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [02:21:04.271] matched = [02:21:04.271] rslot = 0x0 [02:21:04.271] #8 ExecModifyTable (pstate=0x8365cb4a0) at ../src/backend/executor/nodeModifyTable.c:4112 [02:21:04.271] context = {mtstate = 0x8365cb4a0, epqstate = 0x8365cb588, estate = 0x8365cb100, planSlot = 0x8365818d0, tmfd = {ctid = {ip_blkid = {bi_hi = 19688, bi_lo = 8507}, ip_posid = 8}, xmax = 767901168, cmax = 8, traversed = 176}, cpUpdateReturningSlot = 0x82db9a6de} [02:21:04.271] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [02:21:04.271] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8365d7118} [02:21:04.271] node = 0x8365cb4a0 [02:21:04.271] estate = 0x8365cb100 [02:21:04.271] operation = CMD_MERGE [02:21:04.271] resultRelInfo = 0x8365cb6b0 [02:21:04.271] subplanstate = 0x8365ccdf0 [02:21:04.271] slot = [02:21:04.271] tupleid = 0x0 [02:21:04.271] oldtuple = 0x0 [02:21:04.271] oldSlot = [02:21:04.271] #9 0x000000000073a85b in ExecProcNodeFirst (node=0x8365cb4a0) at ../src/backend/executor/execProcnode.c:464 [02:21:04.271] No locals. [02:21:04.271] #10 0x0000000000732b4a in ExecProcNode (node=0x8365cb4a0) at ../src/include/executor/executor.h:274 [02:21:04.271] No locals. [02:21:04.271] #11 ExecutePlan (estate=0x8365cb100, planstate=0x8365cb4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83659e310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [02:21:04.271] current_tuple_count = [02:21:04.271] slot = [02:21:04.271] #12 standard_ExecutorRun (queryDesc=0x8364c8448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [02:21:04.271] estate = 0x8365cb100 [02:21:04.271] oldcontext = 0x83659e000 [02:21:04.271] operation = CMD_MERGE [02:21:04.271] dest = 0x83659e310 [02:21:04.271] sendTuples = true [02:21:04.271] #13 0x000000083969d963 in pgss_ExecutorRun (queryDesc=0x8364c8448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [02:21:04.271] _local_sigjmp_buf = {{_sjb = {35322976562, 12170504, 34917272952, 34917273120, 35270722632, 34917272960, 1, 1, 35271738239, 35270722632, 12179232, 34359738368}}} [02:21:04.271] _save_exception_stack = 0x8213b4f40 [02:21:04.271] _save_context_stack = 0x0 [02:21:04.271] _do_rethrow = false [02:21:04.271] #14 0x00000000007329f8 in ExecutorRun (queryDesc=0x18dae, queryDesc@entry=0x8364c8448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [02:21:04.271] No locals. [02:21:04.271] #15 0x000000000090becf in ProcessQuery (plan=0x84065ce00, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8213b4f08) at ../src/backend/tcop/pquery.c:160 [02:21:04.271] queryDesc = 0x8364c8448 [02:21:04.271] #16 0x000000000090b46d in PortalRunMulti (portal=portal@entry=0x8364aa100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83659e310, altdest=0xb52b20 , qc=qc@entry=0x8213b4f08) at ../src/backend/tcop/pquery.c:1286 [02:21:04.271] pstmt = 0x84065ce00 [02:21:04.271] stmtlist_item__state = {l = 0x8406616b8, i = 0} [02:21:04.271] active_snapshot_set = true [02:21:04.271] stmtlist_item = 0x8406616d0 [02:21:04.271] #17 0x000000000090af5c in FillPortalStore (portal=portal@entry=0x8364aa100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [02:21:04.271] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:21:04.271] treceiver = 0x83659e310 [02:21:04.271] #18 0x000000000090acb0 in PortalRun (portal=portal@entry=0x8364aa100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x840661708, altdest=altdest@entry=0x840661708, qc=0x8213b5040) at ../src/backend/tcop/pquery.c:763 [02:21:04.271] _local_sigjmp_buf = {{_sjb = {9481295, 35270934680, 34917273400, 34917273632, 34917273408, 12170504, 12138288, 35270598912, 7112098687, 35270607104, 3579282, 34359738368}}} [02:21:04.271] _save_exception_stack = 0x8213b5110 [02:21:04.271] _save_context_stack = 0x0 [02:21:04.271] _do_rethrow = false [02:21:04.271] saveTopTransactionResourceOwner = 0x8364fc098 [02:21:04.271] saveTopTransactionContext = 0x83641b000 [02:21:04.271] saveActivePortal = 0x0 [02:21:04.271] saveResourceOwner = 0x8364fc098 [02:21:04.271] savePortalContext = 0x0 [02:21:04.271] saveMemoryContext = 0x83641b000 [02:21:04.271] result = [02:21:04.271] nprocessed = [02:21:04.271] #19 0x0000000000909bbb in exec_simple_query (query_string=query_string@entry=0x83640f100 "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 [02:21:04.271] cmdtaglen = [02:21:04.271] snapshot_set = [02:21:04.271] per_parsetree_context = 0x0 [02:21:04.271] plantree_list = [02:21:04.271] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:21:04.271] parsetree = 0x840644ce8 [02:21:04.271] commandTag = CMDTAG_MERGE [02:21:04.271] cmdtagname = [02:21:04.271] querytree_list = [02:21:04.271] portal = 0x8364aa100 [02:21:04.271] format = 0 [02:21:04.271] receiver = 0x840661708 [02:21:04.271] parsetree_item__state = {l = 0x8406465b0, i = 0} [02:21:04.271] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [02:21:04.271] dest = DestRemote [02:21:04.271] was_logged = [02:21:04.271] oldcontext = 0x83641b000 [02:21:04.271] parsetree_list = 0x8406465b0 [02:21:04.271] use_implicit_block = false [02:21:04.271] parsetree_item = 0x8406465c8 [02:21:04.271] save_log_statement_stats = [02:21:04.271] #20 0x0000000000907994 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [02:21:04.271] query_string = 0x83640f100 "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"... [02:21:04.271] input_message = {data = 0x83640f100 "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} [02:21:04.271] firstchar = [02:21:04.271] local_sigjmp_buf = {{_sjb = {9465440, 34917273872, 34917273832, 34917274432, 12179240, 12125712, 8192, 8388608, 72057628955181951, 0, 0, 1}}} [02:21:04.271] send_ready_for_query = false [02:21:04.271] idle_in_transaction_timeout_enabled = false [02:21:04.271] idle_session_timeout_enabled = false [02:21:04.271] #21 0x0000000000902469 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [02:21:04.271] bsdata = [02:21:04.271] #22 0x000000000085c2c2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8213b5e50 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8213b5d98) at ../src/backend/postmaster/launch_backend.c:265 [02:21:04.271] pid = [02:21:04.271] #23 0x0000000000860c21 in BackendStartup (client_sock=0x8213b5d98) at ../src/backend/postmaster/postmaster.c:3593 [02:21:04.271] startup_data = {canAcceptConnections = CAC_OK} [02:21:04.271] bn = 0x83641b628 [02:21:04.271] pid = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] save_errno = [02:21:04.271] __error = [02:21:04.271] __error = [02:21:04.271] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [02:21:04.271] 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' , "\360];!\b\000\000\000\330\005\233+\b\000\000\000\v\000\000\000\000\000\000\000\016\206\233+\b", '\000' , "0^;!\b\000\000\000\224\300\205\000\000\000\000\000@^;!\b", '\000' }, salen = 16}} [02:21:04.271] i = 0 [02:21:04.271] now = [02:21:04.271] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 557536624, events = 8, fd = 565998600, user_data = 0x21}, {pos = 557536608, events = 8, fd = 980818580, user_data = 0x821bc0008}, {pos = 565969928, events = 8, fd = 565970952, user_data = 0x821bc0c08}, {pos = 565985288, events = 8, fd = 565986312, user_data = 0x821bc4808}, {pos = 565988360, events = 8, fd = 565989384, user_data = 0x821bc5408}, {pos = 565991432, events = 8, fd = 565992456, user_data = 0x821bc6008}, {pos = 565994504, events = 8, fd = 565995528, user_data = 0x821bc6c08}, {pos = 565997576, events = 8, fd = 565998600, user_data = 0x821bcc0c8}, {pos = 557537000, events = 8, fd = 557536512, user_data = 0x29b3a767da3}, {pos = 565998600, events = 8, fd = 2571362, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 566022200, user_data = 0x1}, {pos = 565998600, events = 8, fd = 765920424, user_data = 0x8213b57e8}, {pos = 565998600, events = 8, fd = 557536480, user_data = 0x273bac}, {pos = 557537072, events = 8, fd = 766028132, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 566024760, user_data = 0x29b00000001}, {pos = 565998600, events = 8, fd = 765941976, user_data = 0x8213b5628}, {pos = 557536208, events = 8, fd = 33, user_data = 0x82da86c64}, {pos = 565998600, events = 8, fd = 566024760, user_data = 0x0}, {pos = 2625, events = 0, fd = 557536784, user_data = 0x29b3a761645}, {pos = 766028132, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 566024760, events = 8, fd = 1, user_data = 0x821bc7408}, {pos = 910159872, events = 8, fd = 1, user_data = 0x8363ff194}, {pos = 0, events = 0, fd = 557536736, user_data = 0x82b9b7c0c}, {pos = 1, events = 0, fd = 910159872, user_data = 0x8213b5610}, {pos = 731606708, events = 8, fd = 767754592, user_data = 0x82dc30160 }, {pos = 766124224, events = 8, fd = 565998600, user_data = 0x8213b56f0}, {pos = 980816940, events = 667, fd = 80627796, user_data = 0x1}, {pos = 980816558, events = 667, fd = 12240, user_data = 0x8213b5618}, {pos = 557537008, events = 8, fd = 910956520, user_data = 0x8213b5c60}, {pos = 980897424, events = 667, fd = 565998600, user_data = 0x8213b037f}, {pos = 767411378, events = 8, fd = 557537312, user_data = 0x29b00000000}, {pos = 565998600, events = 8, fd = 12240, user_data = 0x82da66000}, {pos = 1964368, events = 0, fd = 767754592, user_data = 0x82da86c64}, {pos = 15616, events = 0, fd = 557538192, user_data = 0x8213b5760}, {pos = 766685582, events = 8, fd = 767793208, user_data = 0x8213b5724}, {pos = 910611930, events = 8, fd = 557538192, user_data = 0x8213b5760}, {pos = 766776837, events = 8, fd = 557537058, user_data = 0x8213b5b90}, {pos = 557538192, events = 8, fd = 0, user_data = 0x909212b25aaed04b}, {pos = 557538192, events = 8, fd = 910611928, user_data = 0x8213b5c60}, {pos = 767793208, events = 8, fd = 0, user_data = 0x8213b5bd0}, {pos = 766777101, events = 8, fd = 0, user_data = 0x0}, {pos = 557538560, events = 8, fd = 910611928, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 980845577, user_data = 0x8213b58a8}, {pos = 766012516, events = 8, fd = 2503, user_data = 0x29b3a768409}, {pos = 557537480, events = 8, fd = 766012516, user_data = 0xac6}, {pos = 765985056, events = 8, fd = 557537352, user_data = 0x821bc7408}, {pos = 557537480, events = 8, fd = 765985056, user_data = 0x8213b58b0}, {pos = 980825189, events = 667, fd = 0, user_data = 0x800000000}, {pos = 557537440, events = 8, fd = 765945168, user_data = 0x0}, {pos = 0, events = 0, fd = 557537408, user_data = 0x29b3a768409}, {pos = 557537624, events = 8, fd = 766012516, user_data = 0xb6c}, {pos = 765985720, events = 8, fd = 557537496, user_data = 0x821bc7408}, {pos = 557537624, events = 8, fd = 765985720, user_data = 0x8213b5940}, {pos = 980825189, events = 667, fd = 566022200, user_data = 0x28d19b}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 565998600, user_data = 0x82da76550}, {pos = 557538344, events = 8, fd = 565998600, user_data = 0x213b5b08}, {pos = 31, events = 0, fd = 0, user_data = 0x8213b59e8}, {pos = 566020040, events = 8, fd = 557538232, user_data = 0x8213b59d0}, {pos = 980843939, events = 667, fd = 566022200, user_data = 0x292e23}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821bcd038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [02:21:04.271] last_touch_time = 1714875504 [02:21:04.271] last_lockfile_recheck_time = 1714875504 [02:21:04.271] nevents = 1 [02:21:04.271] #25 0x000000000085e4f6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8213b6390) at ../src/backend/postmaster/postmaster.c:1372 [02:21:04.271] userDoption = [02:21:04.271] listen_addr_saved = false [02:21:04.271] output_config_variable = [02:21:04.271] opt = [02:21:04.271] status = [02:21:04.271] #26 0x0000000000795eb5 in main (argc=4, argv=0x8213b6390) at ../src/backend/main/main.c:197 [02:21:04.271] do_check_root =