[15:01:10.294] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [15:01:10.672] dumping /tmp/cores/postgres.8465.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [15:01:10.809] [New LWP 101828] [15:01:10.898] Core was generated by `postgres: postgres regression [local] MERGE'. [15:01:10.898] Program terminated with signal SIGABRT, Aborted. [15:01:10.898] Sent by thr_kill() from pid 8465 and user 1003. [15:01:10.898] #0 0x000000082b50edca in thr_kill () from /lib/libc.so.7 [15:01:11.535] [15:01:11.535] Thread 1 (LWP 101828): [15:01:11.535] #0 0x000000082b50edca in thr_kill () from /lib/libc.so.7 [15:01:11.535] No symbol table info available. [15:01:11.535] #1 0x000000082b4876f4 in raise () from /lib/libc.so.7 [15:01:11.535] No symbol table info available. [15:01:11.535] #2 0x000000082b538bc9 in abort () from /lib/libc.so.7 [15:01:11.535] No symbol table info available. [15:01:11.535] #3 0x0000000000a61b07 in ExceptionalCondition (conditionName=, fileName=0x3732cd "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [15:01:11.535] No locals. [15:01:11.535] #4 0x0000000000744040 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820c891f0, materialize=, shouldFree=shouldFree@entry=0x820c891b6) at ../src/backend/executor/execTuples.c:1737 [15:01:11.535] No locals. [15:01:11.535] #5 0x00000000007099d8 in ExecIRDeleteTriggers (estate=estate@entry=0x835b2d100, relinfo=relinfo@entry=0x835b2d6b0, slot=slot@entry=0x820c891f0) at ../src/backend/commands/trigger.c:2832 [15:01:11.535] trigger = [15:01:11.535] oldtuple = [15:01:11.535] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84572d850, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [15:01:11.535] trigdesc = 0x835b2d8c0 [15:01:11.535] newtuple = 0x0 [15:01:11.535] i = 0 [15:01:11.535] should_free = false [15:01:11.535] #6 0x0000000000769137 in ExecMergeMatched (context=0x820c89290, resultRelInfo=0x835b2d6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [15:01:11.535] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [15:01:11.535] relaction = 0x8457bc160 [15:01:11.535] commandType = CMD_DELETE [15:01:11.535] result = TM_Ok [15:01:11.535] l__state = {l = 0x84584fb88, i = 0} [15:01:11.535] mtstate = 0x835b2d4a0 [15:01:11.535] newslot = 0x0 [15:01:11.535] rslot = 0x0 [15:01:11.535] estate = 0x18dc4 [15:01:11.535] mergeActions = [15:01:11.535] econtext = 0x84584ec28 [15:01:11.535] epqstate = 0x835b2d588 [15:01:11.535] actionStates = 0x84584fb88 [15:01:11.535] l = [15:01:11.535] isNull = [15:01:11.535] lmerge_matched = [15:01:11.535] __error = [15:01:11.535] l__state = [15:01:11.535] updateCxt = [15:01:11.535] relaction = [15:01:11.535] commandType = [15:01:11.535] result = [15:01:11.535] __error = [15:01:11.535] resultRelationDesc = [15:01:11.535] lockmode = [15:01:11.535] inputslot = [15:01:11.535] epqslot = [15:01:11.535] was_matched = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] #7 ExecMerge (context=0x820c89290, resultRelInfo=0x835b2d6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [15:01:11.535] matched = [15:01:11.535] rslot = 0x0 [15:01:11.535] #8 ExecModifyTable (pstate=0x835b2d4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [15:01:11.535] context = {mtstate = 0x835b2d4a0, epqstate = 0x835b2d588, estate = 0x835b2d100, planSlot = 0x8457bc0d0, tmfd = {ctid = {ip_blkid = {bi_hi = 37584, bi_lo = 8392}, ip_posid = 8}, xmax = 1166341256, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x84587c938} [15:01:11.535] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [15:01:11.535] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835b41118} [15:01:11.535] node = 0x835b2d4a0 [15:01:11.535] estate = 0x835b2d100 [15:01:11.535] operation = CMD_MERGE [15:01:11.535] resultRelInfo = 0x835b2d6b0 [15:01:11.535] subplanstate = 0x835b2edf0 [15:01:11.535] slot = [15:01:11.535] tupleid = 0x0 [15:01:11.535] oldtuple = 0x0 [15:01:11.535] oldSlot = [15:01:11.535] #9 0x000000000073e07b in ExecProcNodeFirst (node=0x835b2d4a0) at ../src/backend/executor/execProcnode.c:464 [15:01:11.535] No locals. [15:01:11.535] #10 0x000000000073636a in ExecProcNode (node=0x835b2d4a0) at ../src/include/executor/executor.h:274 [15:01:11.535] No locals. [15:01:11.535] #11 ExecutePlan (estate=0x835b2d100, planstate=0x835b2d4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x835b0eb10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [15:01:11.535] current_tuple_count = [15:01:11.535] slot = [15:01:11.535] #12 standard_ExecutorRun (queryDesc=0x835a0e448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [15:01:11.535] estate = 0x835b2d100 [15:01:11.535] oldcontext = 0x835b0e800 [15:01:11.535] operation = CMD_MERGE [15:01:11.535] dest = 0x835b0eb10 [15:01:11.535] sendTuples = true [15:01:11.535] #13 0x000000000073621f in ExecutorRun (queryDesc=0x18dc4, queryDesc@entry=0x835a0e448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [15:01:11.535] No locals. [15:01:11.535] #14 0x000000000090f2cf in ProcessQuery (plan=0x84587c220, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820c894c8) at ../src/backend/tcop/pquery.c:160 [15:01:11.535] queryDesc = 0x835a0e448 [15:01:11.535] #15 0x000000000090e86d in PortalRunMulti (portal=portal@entry=0x835a41100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x835b0eb10, altdest=0xb56ca0 , qc=qc@entry=0x820c894c8) at ../src/backend/tcop/pquery.c:1286 [15:01:11.535] pstmt = 0x84587c220 [15:01:11.535] stmtlist_item__state = {l = 0x845880ad8, i = 0} [15:01:11.535] active_snapshot_set = true [15:01:11.535] stmtlist_item = 0x845880af0 [15:01:11.535] #16 0x000000000090e35c in FillPortalStore (portal=portal@entry=0x835a41100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [15:01:11.535] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:01:11.535] treceiver = 0x835b0eb10 [15:01:11.535] #17 0x000000000090e0b0 in PortalRun (portal=portal@entry=0x835a41100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x845880b28, altdest=altdest@entry=0x845880b28, qc=0x820c89600) at ../src/backend/tcop/pquery.c:763 [15:01:11.535] _local_sigjmp_buf = {{_sjb = {9494607, 35259755224, 34909754616, 34909754848, 34909754624, 12187800, 12155584, 35259683072, 7112098687, 35259691264, 3580204, 34359738368}}} [15:01:11.535] _save_exception_stack = 0x820c896d0 [15:01:11.535] _save_context_stack = 0x0 [15:01:11.535] _do_rethrow = false [15:01:11.535] saveTopTransactionResourceOwner = 0x835a52ad8 [15:01:11.535] saveTopTransactionContext = 0x835977000 [15:01:11.535] saveActivePortal = 0x0 [15:01:11.535] saveResourceOwner = 0x835a52ad8 [15:01:11.535] savePortalContext = 0x0 [15:01:11.535] saveMemoryContext = 0x835977000 [15:01:11.535] result = [15:01:11.535] nprocessed = [15:01:11.535] #18 0x000000000090cfbb in exec_simple_query (query_string=query_string@entry=0x83596b100 "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 [15:01:11.535] cmdtaglen = [15:01:11.535] snapshot_set = [15:01:11.535] per_parsetree_context = 0x0 [15:01:11.535] plantree_list = [15:01:11.535] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:01:11.535] parsetree = 0x84581cf28 [15:01:11.535] commandTag = CMDTAG_MERGE [15:01:11.535] cmdtagname = [15:01:11.535] querytree_list = [15:01:11.535] portal = 0x835a41100 [15:01:11.535] format = 0 [15:01:11.535] receiver = 0x845880b28 [15:01:11.535] parsetree_item__state = {l = 0x84581e7f0, i = 0} [15:01:11.535] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [15:01:11.535] dest = DestRemote [15:01:11.535] was_logged = [15:01:11.535] oldcontext = 0x835977000 [15:01:11.535] parsetree_list = 0x84581e7f0 [15:01:11.535] use_implicit_block = false [15:01:11.535] parsetree_item = 0x84581e808 [15:01:11.535] save_log_statement_stats = [15:01:11.535] #19 0x000000000090ad94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [15:01:11.535] query_string = 0x83596b100 "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"... [15:01:11.535] input_message = {data = 0x83596b100 "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} [15:01:11.535] firstchar = [15:01:11.535] local_sigjmp_buf = {{_sjb = {9478752, 34909755088, 34909755048, 34909755648, 12196536, 12143008, 8192, 8388608, 72057628947645311, 0, 0, 34359738369}}} [15:01:11.535] send_ready_for_query = false [15:01:11.535] idle_in_transaction_timeout_enabled = false [15:01:11.535] idle_session_timeout_enabled = false [15:01:11.535] #20 0x0000000000905869 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [15:01:11.535] bsdata = [15:01:11.535] #21 0x000000000085f832 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820c8a410 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820c8a358) at ../src/backend/postmaster/launch_backend.c:265 [15:01:11.535] pid = [15:01:11.535] #22 0x0000000000864191 in BackendStartup (client_sock=0x820c8a358) at ../src/backend/postmaster/postmaster.c:3593 [15:01:11.535] startup_data = {canAcceptConnections = CAC_OK} [15:01:11.535] bn = 0x835977268 [15:01:11.535] pid = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] save_errno = [15:01:11.535] __error = [15:01:11.535] __error = [15:01:11.535] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [15:01:11.535] 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' , "\260\243\310 \b\000\000\000\330\345\214*\b\000\000\000\v\000\000\000\000\000\000\000\016f\215*\b", '\000' , "\360\243\310 \b\000\000\000\004\366\205\000\000\000\000\000\000\244\310 \b", '\000' }, salen = 16}} [15:01:11.535] i = 0 [15:01:11.535] now = [15:01:11.535] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 725580900, events = 8, fd = 550017440, user_data = 0x820c89b30}, {pos = 560690184, events = 8, fd = 32, user_data = 0x820c89b20}, {pos = -586401132, events = 6620, fd = 560660488, user_data = 0x8216b0408}, {pos = 560662536, events = 8, fd = 560663560, user_data = 0x8216b4008}, {pos = 560677896, events = 8, fd = 560678920, user_data = 0x8216b4c08}, {pos = 560680968, events = 8, fd = 560681992, user_data = 0x8216b5808}, {pos = 560684040, events = 8, fd = 560685064, user_data = 0x8216b6408}, {pos = 560687112, events = 8, fd = 560688136, user_data = 0x8216b7008}, {pos = 560690184, events = 8, fd = -1, user_data = 0x82b5cf2e0}, {pos = 550017680, events = 8, fd = 727171497, user_data = 0x0}, {pos = 4096, events = 0, fd = 1730423101, user_data = 0x82b5cf7e8}, {pos = 893426656, events = 8, fd = 160, user_data = 0x0}, {pos = 860876944, events = 8, fd = 550017888, user_data = 0x82b55a92c}, {pos = 4096, events = 0, fd = 725596516, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 560716344, user_data = 0x800000001}, {pos = 560690184, events = 8, fd = 725510360, user_data = 0x820c89be8}, {pos = 550017440, events = 8, fd = 32, user_data = 0x82b3f7c64}, {pos = 560690184, events = 8, fd = 560716344, user_data = 0x0}, {pos = 2625, events = 0, fd = 550018000, user_data = 0x19dcdd0c3645}, {pos = 725596516, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 560716344, events = 8, fd = 1, user_data = 0x8216b7408}, {pos = 899002368, events = 8, fd = 1, user_data = 0x83595b194}, {pos = 0, events = 0, fd = 550017952, user_data = 0x82a8d5c0c}, {pos = 1, events = 0, fd = 899002368, user_data = 0x820c89bd0}, {pos = 713903796, events = 8, fd = 727322976, user_data = 0x82b5a1160 }, {pos = 725692608, events = 8, fd = 560690184, user_data = 0x820c89cb0}, {pos = -586402772, events = 6620, fd = 860876944, user_data = 0x800000001}, {pos = -586403154, events = 6620, fd = 12240, user_data = 0x820c89bd8}, {pos = 550018224, events = 8, fd = 899708904, user_data = 0x820c8a220}, {pos = -586322288, events = 6620, fd = 560690184, user_data = 0x820c8037f}, {pos = 726979996, events = 8, fd = 560660488, user_data = 0x0}, {pos = 560690184, events = 8, fd = 12240, user_data = 0x82b3d7000}, {pos = 1964368, events = 0, fd = 727322976, user_data = 0x82b3f7c64}, {pos = 15616, events = 0, fd = 550019408, user_data = 0x820c89d20}, {pos = 726253966, events = 8, fd = 727361592, user_data = 0x820c89ce4}, {pos = 899446234, events = 8, fd = 550019408, user_data = 0x820c89d20}, {pos = 726345221, events = 8, fd = 550018274, user_data = 0x820c8a150}, {pos = 550019408, events = 8, fd = 0, user_data = 0xc3e284df6724293d}, {pos = 550019408, events = 8, fd = 899446232, user_data = 0x820c8a220}, {pos = 727361592, events = 8, fd = 0, user_data = 0x820c8a190}, {pos = 726345485, events = 8, fd = 0, user_data = 0x0}, {pos = 550019776, events = 8, fd = 899446232, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -586374135, events = 6620, fd = 550018680, user_data = 0x82b3f7c64}, {pos = 2503, events = 0, fd = -586374135, user_data = 0x820c89e98}, {pos = 725580900, events = 8, fd = 2758, user_data = 0x82b3f1120}, {pos = 550018584, events = 8, fd = 560690184, user_data = 0x820c89e98}, {pos = 725553440, events = 8, fd = 550018688, user_data = 0x19dcdd0c5465}, {pos = 0, events = 0, fd = 0, user_data = 0x82b5c30f0}, {pos = 725513552, events = 8, fd = 0, user_data = 0x0}, {pos = 727390640, events = 8, fd = -586374135, user_data = 0x820c89f28}, {pos = 725580900, events = 8, fd = 2924, user_data = 0x82b3f13b8}, {pos = 550018728, events = 8, fd = 560690184, user_data = 0x820c89f28}, {pos = 725554104, events = 8, fd = 550018832, user_data = 0x19dcdd0c5465}, {pos = 560713784, events = 8, fd = 2676410, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 560690184, events = 8, fd = 725513552, user_data = 0x820c8a1e8}, {pos = 560690184, events = 8, fd = 550019272, user_data = 0x1e}, {pos = 725517536, events = 8, fd = 550019000, user_data = 0x8216bc248}, {pos = 550019448, events = 8, fd = 550018976, user_data = 0x19dcdd0c9da3}, {pos = 560713784, events = 8, fd = 2700135, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 560713784, user_data = 0x1}} [15:01:11.535] last_touch_time = 1712674695 [15:01:11.535] last_lockfile_recheck_time = 1712674695 [15:01:11.535] nevents = 1 [15:01:11.535] #24 0x0000000000861a66 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820c8a950) at ../src/backend/postmaster/postmaster.c:1372 [15:01:11.535] userDoption = [15:01:11.535] listen_addr_saved = false [15:01:11.535] output_config_variable = [15:01:11.535] opt = [15:01:11.535] status = [15:01:11.535] #25 0x00000000007993b5 in main (argc=8, argv=0x820c8a950) at ../src/backend/main/main.c:197 [15:01:11.535] do_check_root = [15:01:11.546] [15:01:11.546] [15:01:11.546] [15:01:11.611] dumping /tmp/cores/postgres.9259.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:01:11.746] [New LWP 100179] [15:01:11.816] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [15:01:11.816] Program terminated with signal SIGABRT, Aborted. [15:01:11.816] Sent by thr_kill() from pid 9259 and user 1003. [15:01:11.816] #0 0x000000082aabcdca in thr_kill () from /lib/libc.so.7 [15:01:12.409] [15:01:12.409] Thread 1 (LWP 100179): [15:01:12.409] #0 0x000000082aabcdca in thr_kill () from /lib/libc.so.7 [15:01:12.409] No symbol table info available. [15:01:12.409] #1 0x000000082aa356f4 in raise () from /lib/libc.so.7 [15:01:12.409] No symbol table info available. [15:01:12.409] #2 0x000000082aae6bc9 in abort () from /lib/libc.so.7 [15:01:12.409] No symbol table info available. [15:01:12.409] #3 0x0000000000a61b07 in ExceptionalCondition (conditionName=, fileName=0x3732cd "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [15:01:12.409] No locals. [15:01:12.409] #4 0x0000000000744040 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8216b9a40, materialize=, shouldFree=shouldFree@entry=0x8216b9a06) at ../src/backend/executor/execTuples.c:1737 [15:01:12.409] No locals. [15:01:12.409] #5 0x00000000007099d8 in ExecIRDeleteTriggers (estate=estate@entry=0x834d0e100, relinfo=relinfo@entry=0x834d0e6b0, slot=slot@entry=0x8216b9a40) at ../src/backend/commands/trigger.c:2832 [15:01:12.409] trigger = [15:01:12.409] oldtuple = [15:01:12.409] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x843753998, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [15:01:12.409] trigdesc = 0x834d0e8c0 [15:01:12.409] newtuple = 0x0 [15:01:12.409] i = 0 [15:01:12.409] should_free = false [15:01:12.409] #6 0x0000000000769137 in ExecMergeMatched (context=0x8216b9ae0, resultRelInfo=0x834d0e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [15:01:12.409] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [15:01:12.409] relaction = 0x840f27060 [15:01:12.409] commandType = CMD_DELETE [15:01:12.409] result = TM_Ok [15:01:12.409] l__state = {l = 0x841005f88, i = 0} [15:01:12.409] mtstate = 0x834d0e4a0 [15:01:12.409] newslot = 0x0 [15:01:12.409] rslot = 0x0 [15:01:12.409] estate = 0x18753 [15:01:12.409] mergeActions = [15:01:12.409] econtext = 0x841005028 [15:01:12.409] epqstate = 0x834d0e588 [15:01:12.409] actionStates = 0x841005f88 [15:01:12.409] l = [15:01:12.409] isNull = [15:01:12.409] lmerge_matched = [15:01:12.409] __error = [15:01:12.409] l__state = [15:01:12.409] updateCxt = [15:01:12.409] relaction = [15:01:12.409] commandType = [15:01:12.409] result = [15:01:12.409] __error = [15:01:12.409] resultRelationDesc = [15:01:12.409] lockmode = [15:01:12.409] inputslot = [15:01:12.409] epqslot = [15:01:12.409] was_matched = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] #7 ExecMerge (context=0x8216b9ae0, resultRelInfo=0x834d0e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [15:01:12.409] matched = [15:01:12.409] rslot = 0x0 [15:01:12.409] #8 ExecModifyTable (pstate=0x834d0e4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [15:01:12.409] context = {mtstate = 0x834d0e4a0, epqstate = 0x834d0e588, estate = 0x834d0e100, planSlot = 0x840f26fd0, tmfd = {ctid = {ip_blkid = {bi_hi = 39712, bi_lo = 8555}, ip_posid = 8}, xmax = 1090541704, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x841032978} [15:01:12.409] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [15:01:12.409] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834d44118} [15:01:12.409] node = 0x834d0e4a0 [15:01:12.409] estate = 0x834d0e100 [15:01:12.409] operation = CMD_MERGE [15:01:12.409] resultRelInfo = 0x834d0e6b0 [15:01:12.409] subplanstate = 0x834d0fdf0 [15:01:12.409] slot = [15:01:12.409] tupleid = 0x0 [15:01:12.409] oldtuple = 0x0 [15:01:12.409] oldSlot = [15:01:12.409] #9 0x000000000073e07b in ExecProcNodeFirst (node=0x834d0e4a0) at ../src/backend/executor/execProcnode.c:464 [15:01:12.409] No locals. [15:01:12.409] #10 0x000000000073636a in ExecProcNode (node=0x834d0e4a0) at ../src/include/executor/executor.h:274 [15:01:12.409] No locals. [15:01:12.409] #11 ExecutePlan (estate=0x834d0e100, planstate=0x834d0e4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x834ba7710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [15:01:12.409] current_tuple_count = [15:01:12.409] slot = [15:01:12.409] #12 standard_ExecutorRun (queryDesc=0x834c28448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [15:01:12.409] estate = 0x834d0e100 [15:01:12.409] oldcontext = 0x834ba7400 [15:01:12.409] operation = CMD_MERGE [15:01:12.409] dest = 0x834ba7710 [15:01:12.409] sendTuples = true [15:01:12.409] #13 0x000000000073621f in ExecutorRun (queryDesc=0x18753, queryDesc@entry=0x834c28448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [15:01:12.409] No locals. [15:01:12.409] #14 0x000000000090f2cf in ProcessQuery (plan=0x841032260, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8216b9d18) at ../src/backend/tcop/pquery.c:160 [15:01:12.409] queryDesc = 0x834c28448 [15:01:12.409] #15 0x000000000090e86d in PortalRunMulti (portal=portal@entry=0x834c08100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x834ba7710, altdest=0xb56ca0 , qc=qc@entry=0x8216b9d18) at ../src/backend/tcop/pquery.c:1286 [15:01:12.409] pstmt = 0x841032260 [15:01:12.409] stmtlist_item__state = {l = 0x841036b18, i = 0} [15:01:12.409] active_snapshot_set = true [15:01:12.409] stmtlist_item = 0x841036b30 [15:01:12.409] #16 0x000000000090e35c in FillPortalStore (portal=portal@entry=0x834c08100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [15:01:12.409] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:01:12.409] treceiver = 0x834ba7710 [15:01:12.409] #17 0x000000000090e0b0 in PortalRun (portal=portal@entry=0x834c08100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x841036b68, altdest=altdest@entry=0x841036b68, qc=0x8216b9e50) at ../src/backend/tcop/pquery.c:763 [15:01:12.409] _local_sigjmp_buf = {{_sjb = {9494607, 35245074200, 34920439112, 34920439344, 34920439120, 12187800, 12155584, 35244769536, 7112098687, 35244777728, 3580204, 34359738368}}} [15:01:12.409] _save_exception_stack = 0x8216b9f20 [15:01:12.409] _save_context_stack = 0x0 [15:01:12.409] _do_rethrow = false [15:01:12.409] saveTopTransactionResourceOwner = 0x834c52718 [15:01:12.409] saveTopTransactionContext = 0x834b7b000 [15:01:12.409] saveActivePortal = 0x0 [15:01:12.409] saveResourceOwner = 0x834c52718 [15:01:12.409] savePortalContext = 0x0 [15:01:12.409] saveMemoryContext = 0x834b7b000 [15:01:12.409] result = [15:01:12.409] nprocessed = [15:01:12.409] #18 0x000000000090cfbb in exec_simple_query (query_string=query_string@entry=0x834b6f100 "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 [15:01:12.409] cmdtaglen = [15:01:12.409] snapshot_set = [15:01:12.409] per_parsetree_context = 0x0 [15:01:12.409] plantree_list = [15:01:12.409] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:01:12.409] parsetree = 0x840fd32a8 [15:01:12.409] commandTag = CMDTAG_MERGE [15:01:12.409] cmdtagname = [15:01:12.409] querytree_list = [15:01:12.409] portal = 0x834c08100 [15:01:12.409] format = 0 [15:01:12.409] receiver = 0x841036b68 [15:01:12.409] parsetree_item__state = {l = 0x840fd4b70, i = 0} [15:01:12.409] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [15:01:12.409] dest = DestRemote [15:01:12.409] was_logged = [15:01:12.409] oldcontext = 0x834b7b000 [15:01:12.409] parsetree_list = 0x840fd4b70 [15:01:12.409] use_implicit_block = false [15:01:12.409] parsetree_item = 0x840fd4b88 [15:01:12.409] save_log_statement_stats = [15:01:12.409] #19 0x000000000090ad94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [15:01:12.409] query_string = 0x834b6f100 "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"... [15:01:12.409] input_message = {data = 0x834b6f100 "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} [15:01:12.409] firstchar = [15:01:12.409] local_sigjmp_buf = {{_sjb = {9478752, 34920439584, 34920439544, 34920440144, 12196536, 12143008, 8192, 8388608, 72057628958327679, 0, 0, 34359738369}}} [15:01:12.409] send_ready_for_query = false [15:01:12.409] idle_in_transaction_timeout_enabled = false [15:01:12.409] idle_session_timeout_enabled = false [15:01:12.409] #20 0x0000000000905869 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [15:01:12.409] bsdata = [15:01:12.409] #21 0x000000000085f832 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8216bac60 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8216baba8) at ../src/backend/postmaster/launch_backend.c:265 [15:01:12.409] pid = [15:01:12.409] #22 0x0000000000864191 in BackendStartup (client_sock=0x8216baba8) at ../src/backend/postmaster/postmaster.c:3593 [15:01:12.409] startup_data = {canAcceptConnections = CAC_OK} [15:01:12.409] bn = 0x834b7b538 [15:01:12.409] pid = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] save_errno = [15:01:12.409] __error = [15:01:12.409] __error = [15:01:12.409] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [15:01:12.409] 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' , "\254k!\b\000\000\000\330\365\210)\b\000\000\000\v\000\000\000\000\000\000\000\016v\211)\b", '\000' , "@\254k!\b\000\000\000\004\366\205\000\000\000\000\000P\254k!\b", '\000' }, salen = 16}} [15:01:12.409] i = 0 [15:01:12.409] now = [15:01:12.409] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 714759268, events = 8, fd = 560701936, user_data = 0x8216ba380}, {pos = 570807304, events = 8, fd = 32, user_data = 0x8216ba370}, {pos = 1332538004, events = 15810, fd = 570777608, user_data = 0x822056408}, {pos = 570779656, events = 8, fd = 570780680, user_data = 0x82205a008}, {pos = 570795016, events = 8, fd = 570796040, user_data = 0x82205ac08}, {pos = 570798088, events = 8, fd = 570799112, user_data = 0x82205b808}, {pos = 570801160, events = 8, fd = 570802184, user_data = 0x82205c408}, {pos = 570804232, events = 8, fd = 570805256, user_data = 0x82205d008}, {pos = 570807304, events = 8, fd = 570826888, user_data = 0x8216ba4f8}, {pos = 560702240, events = 8, fd = 1332563363, user_data = 0x0}, {pos = 2572530, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 570830904, events = 8, fd = 1, user_data = 0x82205d408}, {pos = 714667176, events = 8, fd = 560702968, user_data = 0x82205d408}, {pos = 560702224, events = 0, fd = 714774884, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 570833464, user_data = 0x1}, {pos = 570807304, events = 8, fd = 714688728, user_data = 0x8216ba438}, {pos = 560701936, events = 8, fd = 32, user_data = 0x82a9a5c64}, {pos = 570807304, events = 8, fd = 570833464, user_data = 0x0}, {pos = 2625, events = 0, fd = 560702496, user_data = 0x3dc24f6ce645}, {pos = 714774884, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 570833464, events = 8, fd = 1, user_data = 0x82205d408}, {pos = 884338688, events = 8, fd = 1, user_data = 0x834b5f194}, {pos = 0, events = 0, fd = 560702448, user_data = 0x829896c0c}, {pos = 1, events = 0, fd = 884338688, user_data = 0x8216ba420}, {pos = 696868532, events = 8, fd = 716501344, user_data = 0x82ab4f160 }, {pos = 714870976, events = 8, fd = 570807304, user_data = 0x8216ba500}, {pos = 1332536364, events = 15810, fd = 570806280, user_data = 0x800000001}, {pos = 1332535982, events = 15810, fd = 12240, user_data = 0x8216ba428}, {pos = 560702720, events = 8, fd = 885135336, user_data = 0x8216baa70}, {pos = 1332616848, events = 15810, fd = 570807304, user_data = 0x8216b037f}, {pos = 716158130, events = 8, fd = 570777608, user_data = 0x0}, {pos = 570807304, events = 8, fd = 12240, user_data = 0x82a985000}, {pos = 1964368, events = 0, fd = 716501344, user_data = 0x82a9a5c64}, {pos = 15616, events = 0, fd = 560703904, user_data = 0x8216ba570}, {pos = 715432334, events = 8, fd = 716539960, user_data = 0x8216ba534}, {pos = 884790746, events = 8, fd = 560703904, user_data = 0x8216ba570}, {pos = 715523589, events = 8, fd = 560702770, user_data = 0x8216ba9a0}, {pos = 560703904, events = 8, fd = 0, user_data = 0x65881f1cd93d3ffb}, {pos = 560703904, events = 8, fd = 884790744, user_data = 0x8216baa70}, {pos = 716539960, events = 8, fd = 0, user_data = 0x8216ba9e0}, {pos = 715523853, events = 8, fd = 0, user_data = 0x0}, {pos = 560704272, events = 8, fd = 884790744, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1332565001, events = 15810, fd = 560703176, user_data = 0x82a9a5c64}, {pos = 2503, events = 0, fd = 1332565001, user_data = 0x8216ba6e8}, {pos = 714759268, events = 8, fd = 2758, user_data = 0x82a99f120}, {pos = 560703080, events = 8, fd = 570807304, user_data = 0x8216ba6e8}, {pos = 714731808, events = 8, fd = 560703184, user_data = 0x3dc24f6d0465}, {pos = 0, events = 0, fd = 0, user_data = 0x82ab710f0}, {pos = 714691920, events = 8, fd = 0, user_data = 0x0}, {pos = 716569008, events = 8, fd = 1332565001, user_data = 0x8216ba778}, {pos = 714759268, events = 8, fd = 2924, user_data = 0x82a99f3b8}, {pos = 560703224, events = 8, fd = 570807304, user_data = 0x8216ba778}, {pos = 714732472, events = 8, fd = 560703328, user_data = 0x3dc24f6d0465}, {pos = 570830904, events = 8, fd = 2676410, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 570807304, events = 8, fd = 714691920, user_data = 0x8216baa38}, {pos = 570807304, events = 8, fd = 560703768, user_data = 0x1e}, {pos = 714695904, events = 8, fd = 560703496, user_data = 0x822062248}, {pos = 560703944, events = 8, fd = 560703472, user_data = 0x3dc24f6d4da3}, {pos = 570830904, events = 8, fd = 2700135, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 570830904, user_data = 0x1}} [15:01:12.410] last_touch_time = 1712674697 [15:01:12.410] last_lockfile_recheck_time = 1712674697 [15:01:12.410] nevents = 1 [15:01:12.410] #24 0x0000000000861a66 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8216bb1a8) at ../src/backend/postmaster/postmaster.c:1372 [15:01:12.410] userDoption = [15:01:12.410] listen_addr_saved = false [15:01:12.410] output_config_variable = [15:01:12.410] opt = [15:01:12.410] status = [15:01:12.410] #25 0x00000000007993b5 in main (argc=4, argv=0x8216bb1a8) at ../src/backend/main/main.c:197 [15:01:12.410] do_check_root = [15:01:12.421] [15:01:12.421] [15:01:12.421] [15:01:12.481] dumping /tmp/cores/postgres.14304.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:01:12.608] [New LWP 100172] [15:01:12.674] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [15:01:12.674] Program terminated with signal SIGABRT, Aborted. [15:01:12.674] Sent by thr_kill() from pid 14304 and user 1003. [15:01:12.674] #0 0x000000082f6cddca in thr_kill () from /lib/libc.so.7 [15:01:13.276] [15:01:13.276] Thread 1 (LWP 100172): [15:01:13.276] #0 0x000000082f6cddca in thr_kill () from /lib/libc.so.7 [15:01:13.276] No symbol table info available. [15:01:13.276] #1 0x000000082f6466f4 in raise () from /lib/libc.so.7 [15:01:13.276] No symbol table info available. [15:01:13.276] #2 0x000000082f6f7bc9 in abort () from /lib/libc.so.7 [15:01:13.276] No symbol table info available. [15:01:13.276] #3 0x0000000000a61b07 in ExceptionalCondition (conditionName=, fileName=0x3732cd "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [15:01:13.276] No locals. [15:01:13.276] #4 0x0000000000744040 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821a85b80, materialize=, shouldFree=shouldFree@entry=0x821a85b46) at ../src/backend/executor/execTuples.c:1737 [15:01:13.276] No locals. [15:01:13.276] #5 0x00000000007099d8 in ExecIRDeleteTriggers (estate=estate@entry=0x83874a100, relinfo=relinfo@entry=0x83874a6b0, slot=slot@entry=0x821a85b80) at ../src/backend/commands/trigger.c:2832 [15:01:13.276] trigger = [15:01:13.276] oldtuple = [15:01:13.276] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83de26a80, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [15:01:13.276] trigdesc = 0x83874a8c0 [15:01:13.276] newtuple = 0x0 [15:01:13.276] i = 0 [15:01:13.276] should_free = false [15:01:13.276] #6 0x0000000000769137 in ExecMergeMatched (context=0x821a85c20, resultRelInfo=0x83874a6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [15:01:13.276] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [15:01:13.276] relaction = 0x8387009a0 [15:01:13.276] commandType = CMD_DELETE [15:01:13.276] result = TM_Ok [15:01:13.276] l__state = {l = 0x83df74408, i = 0} [15:01:13.276] mtstate = 0x83874a4a0 [15:01:13.276] newslot = 0x0 [15:01:13.276] rslot = 0x0 [15:01:13.276] estate = 0x1874c [15:01:13.276] mergeActions = [15:01:13.276] econtext = 0x83df734a8 [15:01:13.276] epqstate = 0x83874a588 [15:01:13.276] actionStates = 0x83df74408 [15:01:13.276] l = [15:01:13.276] isNull = [15:01:13.276] lmerge_matched = [15:01:13.276] __error = [15:01:13.276] l__state = [15:01:13.276] updateCxt = [15:01:13.276] relaction = [15:01:13.276] commandType = [15:01:13.276] result = [15:01:13.276] __error = [15:01:13.276] resultRelationDesc = [15:01:13.276] lockmode = [15:01:13.276] inputslot = [15:01:13.276] epqslot = [15:01:13.276] was_matched = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] #7 ExecMerge (context=0x821a85c20, resultRelInfo=0x83874a6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [15:01:13.276] matched = [15:01:13.276] rslot = 0x0 [15:01:13.276] #8 ExecModifyTable (pstate=0x83874a4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [15:01:13.276] context = {mtstate = 0x83874a4a0, epqstate = 0x83874a588, estate = 0x83874a100, planSlot = 0x838700910, tmfd = {ctid = {ip_blkid = {bi_hi = 51392, bi_lo = 2050}, ip_posid = 40714}, xmax = 4, cmax = 0, traversed = 176}, cpUpdateReturningSlot = 0x821a85d80} [15:01:13.276] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [15:01:13.276] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x838756118} [15:01:13.276] node = 0x83874a4a0 [15:01:13.276] estate = 0x83874a100 [15:01:13.276] operation = CMD_MERGE [15:01:13.276] resultRelInfo = 0x83874a6b0 [15:01:13.276] subplanstate = 0x83874bdf0 [15:01:13.276] slot = [15:01:13.276] tupleid = 0x0 [15:01:13.276] oldtuple = 0x0 [15:01:13.276] oldSlot = [15:01:13.276] #9 0x000000000073e07b in ExecProcNodeFirst (node=0x83874a4a0) at ../src/backend/executor/execProcnode.c:464 [15:01:13.276] No locals. [15:01:13.276] #10 0x000000000073636a in ExecProcNode (node=0x83874a4a0) at ../src/include/executor/executor.h:274 [15:01:13.276] No locals. [15:01:13.276] #11 ExecutePlan (estate=0x83874a100, planstate=0x83874a4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83859c710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [15:01:13.276] current_tuple_count = [15:01:13.276] slot = [15:01:13.276] #12 standard_ExecutorRun (queryDesc=0x838647448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [15:01:13.276] estate = 0x83874a100 [15:01:13.276] oldcontext = 0x83859c400 [15:01:13.276] operation = CMD_MERGE [15:01:13.276] dest = 0x83859c710 [15:01:13.276] sendTuples = true [15:01:13.276] #13 0x000000083c06b963 in pgss_ExecutorRun (queryDesc=0x838647448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [15:01:13.276] _local_sigjmp_buf = {{_sjb = {35366811954, 12187800, 34924420472, 34924420640, 35305845832, 34924420480, 1, 1, 35306865535, 35305845832, 12196528, 34359738368}}} [15:01:13.276] _save_exception_stack = 0x821a85f40 [15:01:13.276] _save_context_stack = 0x0 [15:01:13.276] _do_rethrow = false [15:01:13.276] #14 0x0000000000736218 in ExecutorRun (queryDesc=0x1874c, queryDesc@entry=0x838647448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [15:01:13.276] No locals. [15:01:13.276] #15 0x000000000090f2cf in ProcessQuery (plan=0x83df5c400, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821a85f08) at ../src/backend/tcop/pquery.c:160 [15:01:13.276] queryDesc = 0x838647448 [15:01:13.276] #16 0x000000000090e86d in PortalRunMulti (portal=portal@entry=0x838629100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83859c710, altdest=0xb56ca0 , qc=qc@entry=0x821a85f08) at ../src/backend/tcop/pquery.c:1286 [15:01:13.276] pstmt = 0x83df5c400 [15:01:13.276] stmtlist_item__state = {l = 0x83df60cb8, i = 0} [15:01:13.276] active_snapshot_set = true [15:01:13.276] stmtlist_item = 0x83df60cd0 [15:01:13.276] #17 0x000000000090e35c in FillPortalStore (portal=portal@entry=0x838629100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [15:01:13.276] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:01:13.276] treceiver = 0x83859c710 [15:01:13.276] #18 0x000000000090e0b0 in PortalRun (portal=portal@entry=0x838629100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83df60d08, altdest=altdest@entry=0x83df60d08, qc=0x821a86040) at ../src/backend/tcop/pquery.c:763 [15:01:13.276] _local_sigjmp_buf = {{_sjb = {9494607, 35306055768, 34924420920, 34924421152, 34924420928, 12187800, 12155584, 35305722112, 7112098687, 35305730304, 3580204, 34359738368}}} [15:01:13.276] _save_exception_stack = 0x821a86110 [15:01:13.276] _save_context_stack = 0x0 [15:01:13.276] _do_rethrow = false [15:01:13.276] saveTopTransactionResourceOwner = 0x83867a858 [15:01:13.276] saveTopTransactionContext = 0x83859a000 [15:01:13.276] saveActivePortal = 0x0 [15:01:13.276] saveResourceOwner = 0x83867a858 [15:01:13.276] savePortalContext = 0x0 [15:01:13.276] saveMemoryContext = 0x83859a000 [15:01:13.276] result = [15:01:13.276] nprocessed = [15:01:13.276] #19 0x000000000090cfbb in exec_simple_query (query_string=query_string@entry=0x83858e100 "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 [15:01:13.276] cmdtaglen = [15:01:13.276] snapshot_set = [15:01:13.276] per_parsetree_context = 0x0 [15:01:13.276] plantree_list = [15:01:13.276] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:01:13.276] parsetree = 0x83df13228 [15:01:13.276] commandTag = CMDTAG_MERGE [15:01:13.276] cmdtagname = [15:01:13.276] querytree_list = [15:01:13.276] portal = 0x838629100 [15:01:13.276] format = 0 [15:01:13.276] receiver = 0x83df60d08 [15:01:13.276] parsetree_item__state = {l = 0x83df14af0, i = 0} [15:01:13.276] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [15:01:13.276] dest = DestRemote [15:01:13.276] was_logged = [15:01:13.276] oldcontext = 0x83859a000 [15:01:13.276] parsetree_list = 0x83df14af0 [15:01:13.276] use_implicit_block = false [15:01:13.276] parsetree_item = 0x83df14b08 [15:01:13.276] save_log_statement_stats = [15:01:13.276] #20 0x000000000090ad94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [15:01:13.276] query_string = 0x83858e100 "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"... [15:01:13.276] input_message = {data = 0x83858e100 "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} [15:01:13.276] firstchar = [15:01:13.276] local_sigjmp_buf = {{_sjb = {9478752, 34924421392, 34924421352, 34924421952, 12196536, 12143008, 8192, 8388608, 72057628962325375, 0, 0, 1}}} [15:01:13.276] send_ready_for_query = false [15:01:13.276] idle_in_transaction_timeout_enabled = false [15:01:13.276] idle_session_timeout_enabled = false [15:01:13.276] #21 0x0000000000905869 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [15:01:13.276] bsdata = [15:01:13.276] #22 0x000000000085f832 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a86e50 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a86d98) at ../src/backend/postmaster/launch_backend.c:265 [15:01:13.276] pid = [15:01:13.276] #23 0x0000000000864191 in BackendStartup (client_sock=0x821a86d98) at ../src/backend/postmaster/postmaster.c:3593 [15:01:13.276] startup_data = {canAcceptConnections = CAC_OK} [15:01:13.276] bn = 0x83859a5d8 [15:01:13.276] pid = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] save_errno = [15:01:13.276] __error = [15:01:13.276] __error = [15:01:13.276] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [15:01:13.276] 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' , "\360m\250!\b\000\000\000\330\345],\b\000\000\000\v\000\000\000\000\000\000\000\016f^,\b", '\000' , "0n\250!\b\000\000\000\004\366\205\000\000\000\000\000@n\250!\b", '\000' }, salen = 16}} [15:01:13.276] i = 0 [15:01:13.276] now = [15:01:13.276] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 564684144, events = 8, fd = 580359176, user_data = 0x21}, {pos = 564684128, events = 8, fd = 414755476, user_data = 0x822972008}, {pos = 580330504, events = 8, fd = 580331528, user_data = 0x822972c08}, {pos = 580345864, events = 8, fd = 580346888, user_data = 0x822976808}, {pos = 580348936, events = 8, fd = 580349960, user_data = 0x822977408}, {pos = 580352008, events = 8, fd = 580353032, user_data = 0x822978008}, {pos = 580355080, events = 8, fd = 580356104, user_data = 0x822978c08}, {pos = 580358152, events = 8, fd = 580359176, user_data = 0x82297e088}, {pos = 564684520, events = 8, fd = 564684032, user_data = 0x126018b90da3}, {pos = 580359176, events = 8, fd = 2572530, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 580382776, user_data = 0x1}, {pos = 580359176, events = 8, fd = 794428584, user_data = 0x821a867e8}, {pos = 580359176, events = 8, fd = 564684000, user_data = 0x27403c}, {pos = 564684592, events = 8, fd = 794536292, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 580385336, user_data = 0x126000000001}, {pos = 580359176, events = 8, fd = 794450136, user_data = 0x821a86628}, {pos = 564683728, events = 8, fd = 33, user_data = 0x82f5b6c64}, {pos = 580359176, events = 8, fd = 580385336, user_data = 0x0}, {pos = 2625, events = 0, fd = 564684304, user_data = 0x126018b8a645}, {pos = 794536292, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 580385336, events = 8, fd = 1, user_data = 0x822979408}, {pos = 945283072, events = 8, fd = 1, user_data = 0x83857e194}, {pos = 0, events = 0, fd = 564684256, user_data = 0x82c5e5c0c}, {pos = 1, events = 0, fd = 945283072, user_data = 0x821a86610}, {pos = 744378036, events = 8, fd = 796262752, user_data = 0x82f760160 }, {pos = 794632384, events = 8, fd = 580359176, user_data = 0x821a866f0}, {pos = 414753836, events = 4704, fd = 80627796, user_data = 0x1}, {pos = 414753454, events = 4704, fd = 12240, user_data = 0x821a86618}, {pos = 564684528, events = 8, fd = 946079720, user_data = 0x821a86c60}, {pos = 414834320, events = 4704, fd = 580359176, user_data = 0x821a8037f}, {pos = 795919538, events = 8, fd = 564684832, user_data = 0x126000000000}, {pos = 580359176, events = 8, fd = 12240, user_data = 0x82f596000}, {pos = 1964368, events = 0, fd = 796262752, user_data = 0x82f5b6c64}, {pos = 15616, events = 0, fd = 564685712, user_data = 0x821a86760}, {pos = 795193742, events = 8, fd = 796301368, user_data = 0x821a86724}, {pos = 945735130, events = 8, fd = 564685712, user_data = 0x821a86760}, {pos = 795284997, events = 8, fd = 564684578, user_data = 0x821a86b90}, {pos = 564685712, events = 8, fd = 0, user_data = 0x41ac9f0a0802c8c0}, {pos = 564685712, events = 8, fd = 945735128, user_data = 0x821a86c60}, {pos = 796301368, events = 8, fd = 0, user_data = 0x821a86bd0}, {pos = 795285261, events = 8, fd = 0, user_data = 0x0}, {pos = 564686080, events = 8, fd = 945735128, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 414782473, user_data = 0x821a868a8}, {pos = 794520676, events = 8, fd = 2503, user_data = 0x126018b91409}, {pos = 564685000, events = 8, fd = 794520676, user_data = 0xac6}, {pos = 794493216, events = 8, fd = 564684872, user_data = 0x822979408}, {pos = 564685000, events = 8, fd = 794493216, user_data = 0x821a868b0}, {pos = 414762085, events = 4704, fd = 0, user_data = 0x800000000}, {pos = 564684960, events = 8, fd = 794453328, user_data = 0x0}, {pos = 0, events = 0, fd = 564684928, user_data = 0x126018b91409}, {pos = 564685144, events = 8, fd = 794520676, user_data = 0xb6c}, {pos = 794493880, events = 8, fd = 564685016, user_data = 0x822979408}, {pos = 564685144, events = 8, fd = 794493880, user_data = 0x821a86940}, {pos = 414762085, events = 4704, fd = 580382776, user_data = 0x28d6ba}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 580359176, user_data = 0x82f5a6550}, {pos = 564685864, events = 8, fd = 580359176, user_data = 0x21a86b08}, {pos = 31, events = 0, fd = 0, user_data = 0x821a869e8}, {pos = 580380552, events = 8, fd = 564685752, user_data = 0x821a869d0}, {pos = 414780835, events = 4704, fd = 580382776, user_data = 0x293367}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82297f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [15:01:13.276] last_touch_time = 1712674715 [15:01:13.276] last_lockfile_recheck_time = 1712674715 [15:01:13.276] nevents = 1 [15:01:13.276] #25 0x0000000000861a66 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a87398) at ../src/backend/postmaster/postmaster.c:1372 [15:01:13.276] userDoption = [15:01:13.276] listen_addr_saved = false [15:01:13.276] output_config_variable = [15:01:13.276] opt = [15:01:13.276] status = [15:01:13.276] #26 0x00000000007993b5 in main (argc=4, argv=0x821a87398) at ../src/backend/main/main.c:197 [15:01:13.276] do_check_root =