[13:35:15.918] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [13:35:16.282] dumping /tmp/cores/postgres.8440.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:35:16.408] [New LWP 101756] [13:35:16.488] Core was generated by `postgres: postgres regression [local] MERGE'. [13:35:16.488] Program terminated with signal SIGABRT, Aborted. [13:35:16.488] Sent by thr_kill() from pid 8440 and user 1003. [13:35:16.488] #0 0x000000082eb96dca in thr_kill () from /lib/libc.so.7 [13:35:17.030] [13:35:17.030] Thread 1 (LWP 101756): [13:35:17.030] #0 0x000000082eb96dca in thr_kill () from /lib/libc.so.7 [13:35:17.030] No symbol table info available. [13:35:17.030] #1 0x000000082eb0f6f4 in raise () from /lib/libc.so.7 [13:35:17.030] No symbol table info available. [13:35:17.030] #2 0x000000082ebc0bc9 in abort () from /lib/libc.so.7 [13:35:17.030] No symbol table info available. [13:35:17.030] #3 0x0000000000a5d727 in ExceptionalCondition (conditionName=, fileName=0x372e50 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:35:17.030] No locals. [13:35:17.030] #4 0x000000000073fda0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8213c5830, materialize=, shouldFree=shouldFree@entry=0x8213c57d6) at ../src/backend/executor/execTuples.c:1737 [13:35:17.030] No locals. [13:35:17.030] #5 0x0000000000705f88 in ExecIRDeleteTriggers (estate=estate@entry=0x839539100, relinfo=relinfo@entry=0x8395396b0, slot=slot@entry=0x8213c5830) at ../src/backend/commands/trigger.c:2841 [13:35:17.030] trigger = [13:35:17.030] oldtuple = [13:35:17.030] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8488b77a8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:35:17.030] trigdesc = 0x8395398c0 [13:35:17.030] newtuple = 0x0 [13:35:17.030] i = 0 [13:35:17.030] should_free = false [13:35:17.030] #6 0x0000000000764e9a in ExecMergeMatched (context=0x8213c58f0, resultRelInfo=0x8395396b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [13:35:17.030] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:35:17.030] relaction = 0x845fb6ea0 [13:35:17.030] commandType = CMD_DELETE [13:35:17.030] result = TM_Ok [13:35:17.030] l__state = {l = 0x846031cc8, i = 0} [13:35:17.030] mtstate = 0x8395394a0 [13:35:17.030] newslot = 0x0 [13:35:17.030] rslot = 0x0 [13:35:17.030] estate = 0x18d7c [13:35:17.030] mergeActions = [13:35:17.030] econtext = 0x846030d68 [13:35:17.030] epqstate = 0x839539588 [13:35:17.030] actionStates = 0x846031cc8 [13:35:17.030] l = [13:35:17.030] isNull = [13:35:17.030] lmerge_matched = [13:35:17.030] __error = [13:35:17.030] l__state = [13:35:17.030] updateCxt = [13:35:17.030] relaction = [13:35:17.030] commandType = [13:35:17.030] result = [13:35:17.030] __error = [13:35:17.030] resultRelationDesc = [13:35:17.030] lockmode = [13:35:17.030] inputslot = [13:35:17.030] epqslot = [13:35:17.030] was_matched = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] #7 ExecMerge (context=0x8213c58f0, resultRelInfo=0x8395396b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [13:35:17.030] matched = [13:35:17.030] rslot = 0x0 [13:35:17.030] #8 ExecModifyTable (pstate=0x8395394a0) at ../src/backend/executor/nodeModifyTable.c:4112 [13:35:17.030] context = {mtstate = 0x8395394a0, epqstate = 0x839539588, estate = 0x839539100, planSlot = 0x845fb6e10, tmfd = {ctid = {ip_blkid = {bi_hi = 62208, bi_lo = 17925}, ip_posid = 8}, xmax = 961779376, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x839539100} [13:35:17.030] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [13:35:17.030] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83954d118} [13:35:17.030] node = 0x8395394a0 [13:35:17.030] estate = 0x839539100 [13:35:17.030] operation = CMD_MERGE [13:35:17.030] resultRelInfo = 0x8395396b0 [13:35:17.030] subplanstate = 0x83953adf0 [13:35:17.030] slot = [13:35:17.030] tupleid = 0x0 [13:35:17.030] oldtuple = 0x0 [13:35:17.030] oldSlot = [13:35:17.030] #9 0x0000000000739e3b in ExecProcNodeFirst (node=0x8395394a0) at ../src/backend/executor/execProcnode.c:464 [13:35:17.030] No locals. [13:35:17.030] #10 0x000000000073212a in ExecProcNode (node=0x8395394a0) at ../src/include/executor/executor.h:274 [13:35:17.030] No locals. [13:35:17.030] #11 ExecutePlan (estate=0x839539100, planstate=0x8395394a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83950e710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [13:35:17.030] current_tuple_count = [13:35:17.030] slot = [13:35:17.030] #12 standard_ExecutorRun (queryDesc=0x83941b448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [13:35:17.030] estate = 0x839539100 [13:35:17.030] oldcontext = 0x83950e400 [13:35:17.030] operation = CMD_MERGE [13:35:17.030] dest = 0x83950e710 [13:35:17.030] sendTuples = true [13:35:17.030] #13 0x0000000000731fdf in ExecutorRun (queryDesc=0x18d7c, queryDesc@entry=0x83941b448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [13:35:17.030] No locals. [13:35:17.030] #14 0x000000000090b03f in ProcessQuery (plan=0x84605c7e0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8213c5b08) at ../src/backend/tcop/pquery.c:160 [13:35:17.030] queryDesc = 0x83941b448 [13:35:17.030] #15 0x000000000090a5dd in PortalRunMulti (portal=portal@entry=0x83944e100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83950e710, altdest=0xb51800 , qc=qc@entry=0x8213c5b08) at ../src/backend/tcop/pquery.c:1286 [13:35:17.030] pstmt = 0x84605c7e0 [13:35:17.030] stmtlist_item__state = {l = 0x846061098, i = 0} [13:35:17.030] active_snapshot_set = true [13:35:17.030] stmtlist_item = 0x8460610b0 [13:35:17.030] #16 0x000000000090a0cc in FillPortalStore (portal=portal@entry=0x83944e100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [13:35:17.030] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:35:17.030] treceiver = 0x83950e710 [13:35:17.030] #17 0x0000000000909e20 in PortalRun (portal=portal@entry=0x83944e100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8460610e8, altdest=altdest@entry=0x8460610e8, qc=0x8213c5c40) at ../src/backend/tcop/pquery.c:763 [13:35:17.030] _local_sigjmp_buf = {{_sjb = {9477567, 35320605080, 34917342008, 34917342240, 34917342016, 12165816, 12133600, 35320553728, 7112098687, 35320561920, 3579025, 34359738368}}} [13:35:17.030] _save_exception_stack = 0x8213c5d10 [13:35:17.030] _save_context_stack = 0x0 [13:35:17.030] _do_rethrow = false [13:35:17.030] saveTopTransactionResourceOwner = 0x83945a998 [13:35:17.030] saveTopTransactionContext = 0x839384000 [13:35:17.030] saveActivePortal = 0x0 [13:35:17.030] saveResourceOwner = 0x83945a998 [13:35:17.030] savePortalContext = 0x0 [13:35:17.030] saveMemoryContext = 0x839384000 [13:35:17.030] result = [13:35:17.030] nprocessed = [13:35:17.030] #18 0x0000000000908d2b in exec_simple_query (query_string=query_string@entry=0x839378100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [13:35:17.030] cmdtaglen = [13:35:17.030] snapshot_set = [13:35:17.030] per_parsetree_context = 0x0 [13:35:17.030] plantree_list = [13:35:17.030] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:35:17.030] parsetree = 0x845fff728 [13:35:17.030] commandTag = CMDTAG_MERGE [13:35:17.030] cmdtagname = [13:35:17.030] querytree_list = [13:35:17.030] portal = 0x83944e100 [13:35:17.030] format = 0 [13:35:17.030] receiver = 0x8460610e8 [13:35:17.030] parsetree_item__state = {l = 0x846000ff0, i = 0} [13:35:17.030] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [13:35:17.030] dest = DestRemote [13:35:17.030] was_logged = [13:35:17.030] oldcontext = 0x839384000 [13:35:17.030] parsetree_list = 0x846000ff0 [13:35:17.030] use_implicit_block = false [13:35:17.030] parsetree_item = 0x846001008 [13:35:17.030] save_log_statement_stats = [13:35:17.030] #19 0x0000000000906b04 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [13:35:17.030] query_string = 0x839378100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [13:35:17.030] input_message = {data = 0x839378100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [13:35:17.030] firstchar = [13:35:17.030] local_sigjmp_buf = {{_sjb = {9461712, 34917342480, 34917342440, 34917343040, 12174552, 12121024, 8192, 8388608, 72057628955247487, 0, 0, 34359738369}}} [13:35:17.030] send_ready_for_query = false [13:35:17.030] idle_in_transaction_timeout_enabled = false [13:35:17.030] idle_session_timeout_enabled = false [13:35:17.030] #20 0x00000000009015d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [13:35:17.030] bsdata = [13:35:17.030] #21 0x000000000085b432 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8213c6a50 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8213c6998) at ../src/backend/postmaster/launch_backend.c:265 [13:35:17.030] pid = [13:35:17.030] #22 0x000000000085fd91 in BackendStartup (client_sock=0x8213c6998) at ../src/backend/postmaster/postmaster.c:3593 [13:35:17.030] startup_data = {canAcceptConnections = CAC_OK} [13:35:17.030] bn = 0x839384268 [13:35:17.030] pid = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] save_errno = [13:35:17.030] __error = [13:35:17.030] __error = [13:35:17.030] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [13:35:17.030] 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' , "\360i, "0j}, salen = 16}} [13:35:17.030] i = 0 [13:35:17.030] now = [13:35:17.030] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 782761060, events = 8, fd = 557604832, user_data = 0x8213c6170}, {pos = 572933128, events = 8, fd = 32, user_data = 0x8213c6160}, {pos = -1184363884, events = 14147, fd = 572903432, user_data = 0x82225d408}, {pos = 572905480, events = 8, fd = 572906504, user_data = 0x822261008}, {pos = 572920840, events = 8, fd = 572921864, user_data = 0x822261c08}, {pos = 572923912, events = 8, fd = 572924936, user_data = 0x822262808}, {pos = 572926984, events = 8, fd = 572928008, user_data = 0x822263408}, {pos = 572930056, events = 8, fd = 572931080, user_data = 0x822264008}, {pos = 572933128, events = 8, fd = -1, user_data = 0x82ec572e0}, {pos = 557605072, events = 8, fd = 784351657, user_data = 0x0}, {pos = 4096, events = 0, fd = -813362556, user_data = 0x82ec577e8}, {pos = 950049760, events = 8, fd = 160, user_data = 0x0}, {pos = 922329232, events = 8, fd = 557605280, user_data = 0x82ebe292c}, {pos = 4096, events = 0, fd = 782776676, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 572959288, user_data = 0x800000001}, {pos = 572933128, events = 8, fd = 782690520, user_data = 0x8213c6228}, {pos = 557604832, events = 8, fd = 32, user_data = 0x82ea7fc64}, {pos = 572933128, events = 8, fd = 572959288, user_data = 0x0}, {pos = 2625, events = 0, fd = 557605392, user_data = 0x3743b9680645}, {pos = 782776676, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 572959288, events = 8, fd = 1, user_data = 0x822264408}, {pos = 959873024, events = 8, fd = 1, user_data = 0x839368194}, {pos = 0, events = 0, fd = 557605344, user_data = 0x82cad5c0c}, {pos = 1, events = 0, fd = 959873024, user_data = 0x8213c6210}, {pos = 749555380, events = 8, fd = 784503136, user_data = 0x82ec29160 }, {pos = 782872768, events = 8, fd = 572933128, user_data = 0x8213c62f0}, {pos = -1184365524, events = 14147, fd = 922329232, user_data = 0x800000001}, {pos = -1184365906, events = 14147, fd = 12240, user_data = 0x8213c6218}, {pos = 557605616, events = 8, fd = 960579560, user_data = 0x8213c6860}, {pos = -1184285040, events = 14147, fd = 572933128, user_data = 0x8213c037f}, {pos = 784160156, events = 8, fd = 572903432, user_data = 0x0}, {pos = 572933128, events = 8, fd = 12240, user_data = 0x82ea5f000}, {pos = 1964368, events = 0, fd = 784503136, user_data = 0x82ea7fc64}, {pos = 15616, events = 0, fd = 557606800, user_data = 0x8213c6360}, {pos = 783434126, events = 8, fd = 784541752, user_data = 0x8213c6324}, {pos = 960316890, events = 8, fd = 557606800, user_data = 0x8213c6360}, {pos = 783525381, events = 8, fd = 557605666, user_data = 0x8213c6790}, {pos = 557606800, events = 8, fd = 0, user_data = 0xfb048df8cf851284}, {pos = 557606800, events = 8, fd = 960316888, user_data = 0x8213c6860}, {pos = 784541752, events = 8, fd = 0, user_data = 0x8213c67d0}, {pos = 783525645, events = 8, fd = 0, user_data = 0x0}, {pos = 557607168, events = 8, fd = 960316888, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1184336887, events = 14147, fd = 557606072, user_data = 0x82ea7fc64}, {pos = 2503, events = 0, fd = -1184336887, user_data = 0x8213c64d8}, {pos = 782761060, events = 8, fd = 2758, user_data = 0x82ea79120}, {pos = 557605976, events = 8, fd = 572933128, user_data = 0x8213c64d8}, {pos = 782733600, events = 8, fd = 557606080, user_data = 0x3743b9682465}, {pos = 0, events = 0, fd = 0, user_data = 0x82ec4b0f0}, {pos = 782693712, events = 8, fd = 0, user_data = 0x0}, {pos = 784570800, events = 8, fd = -1184336887, user_data = 0x8213c6568}, {pos = 782761060, events = 8, fd = 2924, user_data = 0x82ea793b8}, {pos = 557606120, events = 8, fd = 572933128, user_data = 0x8213c6568}, {pos = 782734264, events = 8, fd = 557606224, user_data = 0x3743b9682465}, {pos = 572956728, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 572933128, events = 8, fd = 782693712, user_data = 0x8213c6828}, {pos = 572933128, events = 8, fd = 557606664, user_data = 0x1e}, {pos = 782697696, events = 8, fd = 557606392, user_data = 0x822269288}, {pos = 557606840, events = 8, fd = 557606368, user_data = 0x3743b9686da3}, {pos = 572956728, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 572956728, user_data = 0x1}} [13:35:17.031] last_touch_time = 1714051936 [13:35:17.031] last_lockfile_recheck_time = 1714051936 [13:35:17.031] nevents = 1 [13:35:17.031] #24 0x000000000085d666 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8213c6f90) at ../src/backend/postmaster/postmaster.c:1372 [13:35:17.031] userDoption = [13:35:17.031] listen_addr_saved = false [13:35:17.031] output_config_variable = [13:35:17.031] opt = [13:35:17.031] status = [13:35:17.031] #25 0x0000000000795325 in main (argc=8, argv=0x8213c6f90) at ../src/backend/main/main.c:197 [13:35:17.031] do_check_root = [13:35:17.041] [13:35:17.041] [13:35:17.041] [13:35:17.101] dumping /tmp/cores/postgres.9136.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:35:17.222] [New LWP 100161] [13:35:17.282] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [13:35:17.282] Program terminated with signal SIGABRT, Aborted. [13:35:17.282] Sent by thr_kill() from pid 9136 and user 1003. [13:35:17.282] #0 0x000000082be26dca in thr_kill () from /lib/libc.so.7 [13:35:17.809] [13:35:17.809] Thread 1 (LWP 100161): [13:35:17.809] #0 0x000000082be26dca in thr_kill () from /lib/libc.so.7 [13:35:17.809] No symbol table info available. [13:35:17.809] #1 0x000000082bd9f6f4 in raise () from /lib/libc.so.7 [13:35:17.809] No symbol table info available. [13:35:17.809] #2 0x000000082be50bc9 in abort () from /lib/libc.so.7 [13:35:17.809] No symbol table info available. [13:35:17.809] #3 0x0000000000a5d727 in ExceptionalCondition (conditionName=, fileName=0x372e50 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:35:17.809] No locals. [13:35:17.809] #4 0x000000000073fda0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821394e10, materialize=, shouldFree=shouldFree@entry=0x821394db6) at ../src/backend/executor/execTuples.c:1737 [13:35:17.809] No locals. [13:35:17.809] #5 0x0000000000705f88 in ExecIRDeleteTriggers (estate=estate@entry=0x83620c100, relinfo=relinfo@entry=0x83620c6b0, slot=slot@entry=0x821394e10) at ../src/backend/commands/trigger.c:2841 [13:35:17.809] trigger = [13:35:17.809] oldtuple = [13:35:17.809] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x846c43968, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:35:17.809] trigdesc = 0x83620c8c0 [13:35:17.809] newtuple = 0x0 [13:35:17.809] i = 0 [13:35:17.809] should_free = false [13:35:17.809] #6 0x0000000000764e9a in ExecMergeMatched (context=0x821394ed0, resultRelInfo=0x83620c6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [13:35:17.809] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:35:17.809] relaction = 0x843ff4be0 [13:35:17.809] commandType = CMD_DELETE [13:35:17.809] result = TM_Ok [13:35:17.809] l__state = {l = 0x84406af88, i = 0} [13:35:17.809] mtstate = 0x83620c4a0 [13:35:17.809] newslot = 0x0 [13:35:17.809] rslot = 0x0 [13:35:17.809] estate = 0x18741 [13:35:17.809] mergeActions = [13:35:17.809] econtext = 0x84406a028 [13:35:17.809] epqstate = 0x83620c588 [13:35:17.809] actionStates = 0x84406af88 [13:35:17.809] l = [13:35:17.809] isNull = [13:35:17.809] lmerge_matched = [13:35:17.809] __error = [13:35:17.809] l__state = [13:35:17.809] updateCxt = [13:35:17.809] relaction = [13:35:17.809] commandType = [13:35:17.809] result = [13:35:17.809] __error = [13:35:17.809] resultRelationDesc = [13:35:17.809] lockmode = [13:35:17.809] inputslot = [13:35:17.809] epqslot = [13:35:17.809] was_matched = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] #7 ExecMerge (context=0x821394ed0, resultRelInfo=0x83620c6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [13:35:17.809] matched = [13:35:17.809] rslot = 0x0 [13:35:17.809] #8 ExecModifyTable (pstate=0x83620c4a0) at ../src/backend/executor/nodeModifyTable.c:4112 [13:35:17.809] context = {mtstate = 0x83620c4a0, epqstate = 0x83620c588, estate = 0x83620c100, planSlot = 0x843ff4b50, tmfd = {ctid = {ip_blkid = {bi_hi = 39360, bi_lo = 17417}, ip_posid = 8}, xmax = 908117680, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x83620c100} [13:35:17.809] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [13:35:17.809] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836220118} [13:35:17.809] node = 0x83620c4a0 [13:35:17.809] estate = 0x83620c100 [13:35:17.809] operation = CMD_MERGE [13:35:17.809] resultRelInfo = 0x83620c6b0 [13:35:17.809] subplanstate = 0x83620ddf0 [13:35:17.809] slot = [13:35:17.809] tupleid = 0x0 [13:35:17.809] oldtuple = 0x0 [13:35:17.809] oldSlot = [13:35:17.809] #9 0x0000000000739e3b in ExecProcNodeFirst (node=0x83620c4a0) at ../src/backend/executor/execProcnode.c:464 [13:35:17.809] No locals. [13:35:17.809] #10 0x000000000073212a in ExecProcNode (node=0x83620c4a0) at ../src/include/executor/executor.h:274 [13:35:17.809] No locals. [13:35:17.809] #11 ExecutePlan (estate=0x83620c100, planstate=0x83620c4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x8360bff10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [13:35:17.809] current_tuple_count = [13:35:17.809] slot = [13:35:17.809] #12 standard_ExecutorRun (queryDesc=0x836125448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [13:35:17.809] estate = 0x83620c100 [13:35:17.809] oldcontext = 0x8360bfc00 [13:35:17.809] operation = CMD_MERGE [13:35:17.809] dest = 0x8360bff10 [13:35:17.809] sendTuples = true [13:35:17.809] #13 0x0000000000731fdf in ExecutorRun (queryDesc=0x18741, queryDesc@entry=0x836125448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [13:35:17.809] No locals. [13:35:17.809] #14 0x000000000090b03f in ProcessQuery (plan=0x844096ea0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8213950e8) at ../src/backend/tcop/pquery.c:160 [13:35:17.809] queryDesc = 0x836125448 [13:35:17.809] #15 0x000000000090a5dd in PortalRunMulti (portal=portal@entry=0x836105100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8360bff10, altdest=0xb51800 , qc=qc@entry=0x8213950e8) at ../src/backend/tcop/pquery.c:1286 [13:35:17.809] pstmt = 0x844096ea0 [13:35:17.809] stmtlist_item__state = {l = 0x84409b758, i = 0} [13:35:17.809] active_snapshot_set = true [13:35:17.809] stmtlist_item = 0x84409b770 [13:35:17.809] #16 0x000000000090a0cc in FillPortalStore (portal=portal@entry=0x836105100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [13:35:17.809] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:35:17.809] treceiver = 0x8360bff10 [13:35:17.809] #17 0x0000000000909e20 in PortalRun (portal=portal@entry=0x836105100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x84409b7a8, altdest=altdest@entry=0x84409b7a8, qc=0x821395220) at ../src/backend/tcop/pquery.c:763 [13:35:17.809] _local_sigjmp_buf = {{_sjb = {9477567, 35267116632, 34917142808, 34917143040, 34917142816, 12165816, 12133600, 35266777344, 7112098687, 35266785536, 3579025, 34359738368}}} [13:35:17.809] _save_exception_stack = 0x8213952f0 [13:35:17.809] _save_context_stack = 0x0 [13:35:17.809] _do_rethrow = false [13:35:17.809] saveTopTransactionResourceOwner = 0x836157e58 [13:35:17.809] saveTopTransactionContext = 0x836078000 [13:35:17.809] saveActivePortal = 0x0 [13:35:17.809] saveResourceOwner = 0x836157e58 [13:35:17.809] savePortalContext = 0x0 [13:35:17.809] saveMemoryContext = 0x836078000 [13:35:17.809] result = [13:35:17.809] nprocessed = [13:35:17.809] #18 0x0000000000908d2b in exec_simple_query (query_string=query_string@entry=0x83606c100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [13:35:17.809] cmdtaglen = [13:35:17.809] snapshot_set = [13:35:17.809] per_parsetree_context = 0x0 [13:35:17.809] plantree_list = [13:35:17.809] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:35:17.809] parsetree = 0x844038328 [13:35:17.809] commandTag = CMDTAG_MERGE [13:35:17.809] cmdtagname = [13:35:17.809] querytree_list = [13:35:17.809] portal = 0x836105100 [13:35:17.809] format = 0 [13:35:17.809] receiver = 0x84409b7a8 [13:35:17.809] parsetree_item__state = {l = 0x844039bf0, i = 0} [13:35:17.809] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [13:35:17.809] dest = DestRemote [13:35:17.809] was_logged = [13:35:17.809] oldcontext = 0x836078000 [13:35:17.809] parsetree_list = 0x844039bf0 [13:35:17.809] use_implicit_block = false [13:35:17.809] parsetree_item = 0x844039c08 [13:35:17.809] save_log_statement_stats = [13:35:17.809] #19 0x0000000000906b04 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [13:35:17.809] query_string = 0x83606c100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [13:35:17.809] input_message = {data = 0x83606c100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [13:35:17.809] firstchar = [13:35:17.809] local_sigjmp_buf = {{_sjb = {9461712, 34917143280, 34917143240, 34917143840, 12174552, 12121024, 8192, 8388608, 72057628955050879, 0, 0, 34359738369}}} [13:35:17.809] send_ready_for_query = false [13:35:17.809] idle_in_transaction_timeout_enabled = false [13:35:17.809] idle_session_timeout_enabled = false [13:35:17.809] #20 0x00000000009015d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [13:35:17.809] bsdata = [13:35:17.809] #21 0x000000000085b432 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821396030 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821395f78) at ../src/backend/postmaster/launch_backend.c:265 [13:35:17.809] pid = [13:35:17.809] #22 0x000000000085fd91 in BackendStartup (client_sock=0x821395f78) at ../src/backend/postmaster/postmaster.c:3593 [13:35:17.809] startup_data = {canAcceptConnections = CAC_OK} [13:35:17.809] bn = 0x8360783a8 [13:35:17.809] pid = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] save_errno = [13:35:17.809] __error = [13:35:17.809] __error = [13:35:17.809] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [13:35:17.809] 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' , "\320_9!\b\000\000\000\330\005\322)\b\000\000\000\v\000\000\000\000\000\000\000\016\206\322)\b", '\000' , "\020`9!\b\000\000\000\004\262\205\000\000\000\000\000 `9!\b", '\000' }, salen = 16}} [13:35:17.809] i = 0 [13:35:17.809] now = [13:35:17.809] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 735116388, events = 8, fd = 557405632, user_data = 0x821395750}, {pos = 573768712, events = 8, fd = 32, user_data = 0x821395740}, {pos = 899369620, events = 14674, fd = 573739016, user_data = 0x822329408}, {pos = 573741064, events = 8, fd = 573742088, user_data = 0x82232d008}, {pos = 573756424, events = 8, fd = 573757448, user_data = 0x82232dc08}, {pos = 573759496, events = 8, fd = 573760520, user_data = 0x82232e808}, {pos = 573762568, events = 8, fd = 573763592, user_data = 0x82232f408}, {pos = 573765640, events = 8, fd = 573766664, user_data = 0x822330008}, {pos = 573768712, events = 8, fd = 573788360, user_data = 0x8213958c8}, {pos = 557405936, events = 8, fd = 899394979, user_data = 0x0}, {pos = 2571326, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 573792312, events = 8, fd = 1, user_data = 0x822330408}, {pos = 735024296, events = 8, fd = 557406664, user_data = 0x822330408}, {pos = 557405920, events = 0, fd = 735132004, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 573794872, user_data = 0x1}, {pos = 573768712, events = 8, fd = 735045848, user_data = 0x821395808}, {pos = 557405632, events = 8, fd = 32, user_data = 0x82bd0fc64}, {pos = 573768712, events = 8, fd = 573794872, user_data = 0x0}, {pos = 2625, events = 0, fd = 557406192, user_data = 0x3952359b4645}, {pos = 735132004, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 573794872, events = 8, fd = 1, user_data = 0x822330408}, {pos = 906346496, events = 8, fd = 1, user_data = 0x83605c194}, {pos = 0, events = 0, fd = 557406144, user_data = 0x829d27c0c}, {pos = 1, events = 0, fd = 906346496, user_data = 0x8213957f0}, {pos = 701656756, events = 8, fd = 736858464, user_data = 0x82beb9160 }, {pos = 735228096, events = 8, fd = 573768712, user_data = 0x8213958d0}, {pos = 899367980, events = 14674, fd = 573767688, user_data = 0x800000001}, {pos = 899367598, events = 14674, fd = 12240, user_data = 0x8213957f8}, {pos = 557406416, events = 8, fd = 907143144, user_data = 0x821395e40}, {pos = 899448464, events = 14674, fd = 573768712, user_data = 0x82139037f}, {pos = 736515250, events = 8, fd = 573739016, user_data = 0x0}, {pos = 573768712, events = 8, fd = 12240, user_data = 0x82bcef000}, {pos = 1964368, events = 0, fd = 736858464, user_data = 0x82bd0fc64}, {pos = 15616, events = 0, fd = 557407600, user_data = 0x821395940}, {pos = 735789454, events = 8, fd = 736897080, user_data = 0x821395904}, {pos = 906798554, events = 8, fd = 557407600, user_data = 0x821395940}, {pos = 735880709, events = 8, fd = 557406466, user_data = 0x821395d70}, {pos = 557407600, events = 8, fd = 0, user_data = 0x9ef0a7654bf192eb}, {pos = 557407600, events = 8, fd = 906798552, user_data = 0x821395e40}, {pos = 736897080, events = 8, fd = 0, user_data = 0x821395db0}, {pos = 735880973, events = 8, fd = 0, user_data = 0x0}, {pos = 557407968, events = 8, fd = 906798552, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 899396617, events = 14674, fd = 557406872, user_data = 0x82bd0fc64}, {pos = 2503, events = 0, fd = 899396617, user_data = 0x821395ab8}, {pos = 735116388, events = 8, fd = 2758, user_data = 0x82bd09120}, {pos = 557406776, events = 8, fd = 573768712, user_data = 0x821395ab8}, {pos = 735088928, events = 8, fd = 557406880, user_data = 0x3952359b6465}, {pos = 0, events = 0, fd = 0, user_data = 0x82bedb0f0}, {pos = 735049040, events = 8, fd = 0, user_data = 0x0}, {pos = 736926128, events = 8, fd = 899396617, user_data = 0x821395b48}, {pos = 735116388, events = 8, fd = 2924, user_data = 0x82bd093b8}, {pos = 557406920, events = 8, fd = 573768712, user_data = 0x821395b48}, {pos = 735089592, events = 8, fd = 557407024, user_data = 0x3952359b6465}, {pos = 573792312, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 573768712, events = 8, fd = 735049040, user_data = 0x821395e08}, {pos = 573768712, events = 8, fd = 557407464, user_data = 0x1e}, {pos = 735053024, events = 8, fd = 557407192, user_data = 0x822335288}, {pos = 557407640, events = 8, fd = 557407168, user_data = 0x3952359bada3}, {pos = 573792312, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 573792312, user_data = 0x1}} [13:35:17.810] last_touch_time = 1714051938 [13:35:17.810] last_lockfile_recheck_time = 1714051938 [13:35:17.810] nevents = 1 [13:35:17.810] #24 0x000000000085d666 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821396570) at ../src/backend/postmaster/postmaster.c:1372 [13:35:17.810] userDoption = [13:35:17.810] listen_addr_saved = false [13:35:17.810] output_config_variable = [13:35:17.810] opt = [13:35:17.810] status = [13:35:17.810] #25 0x0000000000795325 in main (argc=4, argv=0x821396570) at ../src/backend/main/main.c:197 [13:35:17.810] do_check_root = [13:35:17.820] [13:35:17.820] [13:35:17.820] [13:35:17.879] dumping /tmp/cores/postgres.14581.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:35:17.997] [New LWP 100683] [13:35:18.058] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [13:35:18.058] Program terminated with signal SIGABRT, Aborted. [13:35:18.058] Sent by thr_kill() from pid 14581 and user 1003. [13:35:18.058] #0 0x000000082d5c1dca in thr_kill () from /lib/libc.so.7 [13:35:18.583] [13:35:18.583] Thread 1 (LWP 100683): [13:35:18.583] #0 0x000000082d5c1dca in thr_kill () from /lib/libc.so.7 [13:35:18.583] No symbol table info available. [13:35:18.583] #1 0x000000082d53a6f4 in raise () from /lib/libc.so.7 [13:35:18.583] No symbol table info available. [13:35:18.583] #2 0x000000082d5ebbc9 in abort () from /lib/libc.so.7 [13:35:18.583] No symbol table info available. [13:35:18.583] #3 0x0000000000a5d727 in ExceptionalCondition (conditionName=, fileName=0x372e50 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:35:18.583] No locals. [13:35:18.583] #4 0x000000000073fda0 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8212952c0, materialize=, shouldFree=shouldFree@entry=0x821295266) at ../src/backend/executor/execTuples.c:1737 [13:35:18.583] No locals. [13:35:18.583] #5 0x0000000000705f88 in ExecIRDeleteTriggers (estate=estate@entry=0x83808e100, relinfo=relinfo@entry=0x83808e6b0, slot=slot@entry=0x8212952c0) at ../src/backend/commands/trigger.c:2841 [13:35:18.583] trigger = [13:35:18.583] oldtuple = [13:35:18.583] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83d27d788, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:35:18.583] trigdesc = 0x83808e8c0 [13:35:18.583] newtuple = 0x0 [13:35:18.583] i = 0 [13:35:18.583] should_free = false [13:35:18.583] #6 0x0000000000764e9a in ExecMergeMatched (context=0x821295380, resultRelInfo=0x83808e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [13:35:18.583] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:35:18.583] relaction = 0x8380a6620 [13:35:18.583] commandType = CMD_DELETE [13:35:18.583] result = TM_Ok [13:35:18.583] l__state = {l = 0x83d3e1d88, i = 0} [13:35:18.583] mtstate = 0x83808e4a0 [13:35:18.583] newslot = 0x0 [13:35:18.583] rslot = 0x0 [13:35:18.583] estate = 0x1894b [13:35:18.583] mergeActions = [13:35:18.583] econtext = 0x83d3e0e28 [13:35:18.583] epqstate = 0x83808e588 [13:35:18.583] actionStates = 0x83d3e1d88 [13:35:18.583] l = [13:35:18.583] isNull = [13:35:18.583] lmerge_matched = [13:35:18.583] __error = [13:35:18.583] l__state = [13:35:18.583] updateCxt = [13:35:18.583] relaction = [13:35:18.583] commandType = [13:35:18.583] result = [13:35:18.583] __error = [13:35:18.583] resultRelationDesc = [13:35:18.583] lockmode = [13:35:18.583] inputslot = [13:35:18.583] epqslot = [13:35:18.583] was_matched = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] #7 ExecMerge (context=0x821295380, resultRelInfo=0x83808e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [13:35:18.583] matched = [13:35:18.583] rslot = 0x0 [13:35:18.583] #8 ExecModifyTable (pstate=0x83808e4a0) at ../src/backend/executor/nodeModifyTable.c:4112 [13:35:18.583] context = {mtstate = 0x83808e4a0, epqstate = 0x83808e588, estate = 0x83808e100, planSlot = 0x8380a6590, tmfd = {ctid = {ip_blkid = {bi_hi = 21544, bi_lo = 8489}, ip_posid = 8}, xmax = 761757168, cmax = 8, traversed = 240}, cpUpdateReturningSlot = 0x82d5be6de} [13:35:18.583] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [13:35:18.583] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83809a118} [13:35:18.583] node = 0x83808e4a0 [13:35:18.583] estate = 0x83808e100 [13:35:18.583] operation = CMD_MERGE [13:35:18.583] resultRelInfo = 0x83808e6b0 [13:35:18.583] subplanstate = 0x83808fdf0 [13:35:18.583] slot = [13:35:18.583] tupleid = 0x0 [13:35:18.583] oldtuple = 0x0 [13:35:18.583] oldSlot = [13:35:18.583] #9 0x0000000000739e3b in ExecProcNodeFirst (node=0x83808e4a0) at ../src/backend/executor/execProcnode.c:464 [13:35:18.583] No locals. [13:35:18.583] #10 0x000000000073212a in ExecProcNode (node=0x83808e4a0) at ../src/include/executor/executor.h:274 [13:35:18.583] No locals. [13:35:18.583] #11 ExecutePlan (estate=0x83808e100, planstate=0x83808e4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x837fcef10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [13:35:18.583] current_tuple_count = [13:35:18.583] slot = [13:35:18.583] #12 standard_ExecutorRun (queryDesc=0x837f8b448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [13:35:18.583] estate = 0x83808e100 [13:35:18.583] oldcontext = 0x837fcec00 [13:35:18.583] operation = CMD_MERGE [13:35:18.583] dest = 0x837fcef10 [13:35:18.583] sendTuples = true [13:35:18.583] #13 0x000000083b040963 in pgss_ExecutorRun (queryDesc=0x837f8b448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [13:35:18.583] _local_sigjmp_buf = {{_sjb = {35349858610, 12165816, 34916095160, 34916095328, 35298784328, 34916095168, 1, 1, 35299787647, 35298784328, 12174544, 34359738368}}} [13:35:18.583] _save_exception_stack = 0x821295680 [13:35:18.583] _save_context_stack = 0x0 [13:35:18.583] _do_rethrow = false [13:35:18.583] #14 0x0000000000731fd8 in ExecutorRun (queryDesc=0x1894b, queryDesc@entry=0x837f8b448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [13:35:18.583] No locals. [13:35:18.583] #15 0x000000000090b03f in ProcessQuery (plan=0x83d3a5180, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821295648) at ../src/backend/tcop/pquery.c:160 [13:35:18.583] queryDesc = 0x837f8b448 [13:35:18.583] #16 0x000000000090a5dd in PortalRunMulti (portal=portal@entry=0x837f6d100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x837fcef10, altdest=0xb51800 , qc=qc@entry=0x821295648) at ../src/backend/tcop/pquery.c:1286 [13:35:18.583] pstmt = 0x83d3a5180 [13:35:18.583] stmtlist_item__state = {l = 0x83d3a9a38, i = 0} [13:35:18.583] active_snapshot_set = true [13:35:18.583] stmtlist_item = 0x83d3a9a50 [13:35:18.583] #17 0x000000000090a0cc in FillPortalStore (portal=portal@entry=0x837f6d100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [13:35:18.583] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:35:18.583] treceiver = 0x837fcef10 [13:35:18.583] #18 0x0000000000909e20 in PortalRun (portal=portal@entry=0x837f6d100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83d3a9a88, altdest=altdest@entry=0x83d3a9a88, qc=0x821295780) at ../src/backend/tcop/pquery.c:763 [13:35:18.583] _local_sigjmp_buf = {{_sjb = {9477567, 35298996056, 34916095608, 34916095840, 34916095616, 12165816, 12133600, 35298660608, 7112098687, 35298668800, 3579025, 34359738368}}} [13:35:18.583] _save_exception_stack = 0x821295850 [13:35:18.583] _save_context_stack = 0x0 [13:35:18.583] _do_rethrow = false [13:35:18.583] saveTopTransactionResourceOwner = 0x837fbef58 [13:35:18.583] saveTopTransactionContext = 0x837ede000 [13:35:18.583] saveActivePortal = 0x0 [13:35:18.583] saveResourceOwner = 0x837fbef58 [13:35:18.583] savePortalContext = 0x0 [13:35:18.583] saveMemoryContext = 0x837ede000 [13:35:18.583] result = [13:35:18.583] nprocessed = [13:35:18.583] #19 0x0000000000908d2b in exec_simple_query (query_string=query_string@entry=0x837ed2100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [13:35:18.583] cmdtaglen = [13:35:18.583] snapshot_set = [13:35:18.583] per_parsetree_context = 0x0 [13:35:18.583] plantree_list = [13:35:18.583] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:35:18.583] parsetree = 0x83d3812e8 [13:35:18.583] commandTag = CMDTAG_MERGE [13:35:18.583] cmdtagname = [13:35:18.583] querytree_list = [13:35:18.583] portal = 0x837f6d100 [13:35:18.583] format = 0 [13:35:18.583] receiver = 0x83d3a9a88 [13:35:18.583] parsetree_item__state = {l = 0x83d382bb0, i = 0} [13:35:18.583] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [13:35:18.583] dest = DestRemote [13:35:18.583] was_logged = [13:35:18.583] oldcontext = 0x837ede000 [13:35:18.583] parsetree_list = 0x83d382bb0 [13:35:18.583] use_implicit_block = false [13:35:18.583] parsetree_item = 0x83d382bc8 [13:35:18.583] save_log_statement_stats = [13:35:18.583] #20 0x0000000000906b04 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [13:35:18.583] query_string = 0x837ed2100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [13:35:18.583] input_message = {data = 0x837ed2100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [13:35:18.583] firstchar = [13:35:18.583] local_sigjmp_buf = {{_sjb = {9461712, 34916096080, 34916096040, 34916096640, 12174552, 12121024, 8192, 8388608, 72057628954002303, 0, 0, 1}}} [13:35:18.583] send_ready_for_query = false [13:35:18.583] idle_in_transaction_timeout_enabled = false [13:35:18.583] idle_session_timeout_enabled = false [13:35:18.583] #21 0x00000000009015d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [13:35:18.583] bsdata = [13:35:18.583] #22 0x000000000085b432 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821296590 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212964d8) at ../src/backend/postmaster/launch_backend.c:265 [13:35:18.583] pid = [13:35:18.583] #23 0x000000000085fd91 in BackendStartup (client_sock=0x8212964d8) at ../src/backend/postmaster/postmaster.c:3593 [13:35:18.583] startup_data = {canAcceptConnections = CAC_OK} [13:35:18.583] bn = 0x837ede218 [13:35:18.583] pid = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] save_errno = [13:35:18.583] __error = [13:35:18.583] __error = [13:35:18.583] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [13:35:18.583] 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' , "0e)!\b\000\000\000\330\205\236,\b\000\000\000\v\000\000\000\000\000\000\000\016\006\237,\b", '\000' , "pe)!\b\000\000\000\004\262\205\000\000\000\000\000\200e)!\b", '\000' }, salen = 16}} [13:35:18.583] i = 0 [13:35:18.583] now = [13:35:18.583] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 568263688, user_data = 0x0}, {pos = 556358816, events = 8, fd = -1428874604, user_data = 0x821de9008}, {pos = 568235016, events = 8, fd = 568236040, user_data = 0x821de9c08}, {pos = 568250376, events = 8, fd = 568251400, user_data = 0x821ded808}, {pos = 568253448, events = 8, fd = 568254472, user_data = 0x821dee408}, {pos = 568256520, events = 8, fd = 568257544, user_data = 0x821def008}, {pos = 568259592, events = 8, fd = 568260616, user_data = 0x821defc08}, {pos = 568262664, events = 8, fd = 568263688, user_data = 0x821df50c8}, {pos = 556359208, events = 8, fd = 556358720, user_data = 0x2366aad57da3}, {pos = 568263688, events = 8, fd = 2571326, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 568287288, user_data = 0x1}, {pos = 568263688, events = 8, fd = 759776424, user_data = 0x821295f28}, {pos = 568263688, events = 8, fd = 556358688, user_data = 0x273b88}, {pos = 556359280, events = 8, fd = 759884132, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 568289848, user_data = 0x236600000001}, {pos = 568263688, events = 8, fd = 759797976, user_data = 0x821295d68}, {pos = 556358416, events = 8, fd = 33, user_data = 0x82d4aac64}, {pos = 568263688, events = 8, fd = 568289848, user_data = 0x0}, {pos = 2625, events = 0, fd = 556358992, user_data = 0x2366aad51645}, {pos = 759884132, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 568289848, events = 8, fd = 1, user_data = 0x821df0408}, {pos = 938221568, events = 8, fd = 1, user_data = 0x837ec2194}, {pos = 0, events = 0, fd = 556358944, user_data = 0x82c9efc0c}, {pos = 1, events = 0, fd = 938221568, user_data = 0x821295d50}, {pos = 748613300, events = 8, fd = 761610592, user_data = 0x82d654160 }, {pos = 759980224, events = 8, fd = 568263688, user_data = 0x821295e30}, {pos = -1428876244, events = 9062, fd = 80627796, user_data = 0x1}, {pos = -1428876626, events = 9062, fd = 12240, user_data = 0x821295d58}, {pos = 556359216, events = 8, fd = 939018216, user_data = 0x8212963a0}, {pos = -1428795760, events = 9062, fd = 568263688, user_data = 0x82129037f}, {pos = 761267378, events = 8, fd = 556359520, user_data = 0x236600000000}, {pos = 568263688, events = 8, fd = 12240, user_data = 0x82d48a000}, {pos = 1964368, events = 0, fd = 761610592, user_data = 0x82d4aac64}, {pos = 15616, events = 0, fd = 556360400, user_data = 0x821295ea0}, {pos = 760541582, events = 8, fd = 761649208, user_data = 0x821295e64}, {pos = 938673626, events = 8, fd = 556360400, user_data = 0x821295ea0}, {pos = 760632837, events = 8, fd = 556359266, user_data = 0x8212962d0}, {pos = 556360400, events = 8, fd = 0, user_data = 0xd056c02933d4bd29}, {pos = 556360400, events = 8, fd = 938673624, user_data = 0x8212963a0}, {pos = 761649208, events = 8, fd = 0, user_data = 0x821296310}, {pos = 760633101, events = 8, fd = 0, user_data = 0x0}, {pos = 556360768, events = 8, fd = 938673624, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1428847607, user_data = 0x821295fe8}, {pos = 759868516, events = 8, fd = 2503, user_data = 0x2366aad58409}, {pos = 556359688, events = 8, fd = 759868516, user_data = 0xac6}, {pos = 759841056, events = 8, fd = 556359560, user_data = 0x821df0408}, {pos = 556359688, events = 8, fd = 759841056, user_data = 0x821295ff0}, {pos = -1428867995, events = 9062, fd = 0, user_data = 0x800000000}, {pos = 556359648, events = 8, fd = 759801168, user_data = 0x0}, {pos = 0, events = 0, fd = 556359616, user_data = 0x2366aad58409}, {pos = 556359832, events = 8, fd = 759868516, user_data = 0xb6c}, {pos = 759841720, events = 8, fd = 556359704, user_data = 0x821df0408}, {pos = 556359832, events = 8, fd = 759841720, user_data = 0x821296080}, {pos = -1428867995, events = 9062, fd = 568287288, user_data = 0x28d146}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 568263688, user_data = 0x82d49a550}, {pos = 556360552, events = 8, fd = 568263688, user_data = 0x21296248}, {pos = 31, events = 0, fd = 0, user_data = 0x821296128}, {pos = 568285128, events = 8, fd = 556360440, user_data = 0x821296110}, {pos = -1428849245, events = 9062, fd = 568287288, user_data = 0x292dce}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821df6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [13:35:18.583] last_touch_time = 1714051958 [13:35:18.583] last_lockfile_recheck_time = 1714051958 [13:35:18.583] nevents = 1 [13:35:18.583] #25 0x000000000085d666 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821296ad8) at ../src/backend/postmaster/postmaster.c:1372 [13:35:18.583] userDoption = [13:35:18.583] listen_addr_saved = false [13:35:18.583] output_config_variable = [13:35:18.583] opt = [13:35:18.583] status = [13:35:18.583] #26 0x0000000000795325 in main (argc=4, argv=0x821296ad8) at ../src/backend/main/main.c:197 [13:35:18.583] do_check_root =