[00:08:57.865] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [00:08:58.205] dumping /tmp/cores/postgres.7987.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:08:58.333] [New LWP 101686] [00:08:58.413] Core was generated by `postgres: postgres regression [local] MERGE'. [00:08:58.413] Program terminated with signal SIGABRT, Aborted. [00:08:58.413] Sent by thr_kill() from pid 7987 and user 1003. [00:08:58.413] #0 0x000000082a87641a in thr_kill () from /lib/libc.so.7 [00:08:59.065] [00:08:59.065] Thread 1 (LWP 101686): [00:08:59.065] #0 0x000000082a87641a in thr_kill () from /lib/libc.so.7 [00:08:59.065] No symbol table info available. [00:08:59.065] #1 0x000000082a7efe64 in raise () from /lib/libc.so.7 [00:08:59.065] No symbol table info available. [00:08:59.065] #2 0x000000082a8a06f9 in abort () from /lib/libc.so.7 [00:08:59.065] No symbol table info available. [00:08:59.065] #3 0x0000000000a8f8b5 in ExceptionalCondition (conditionName=0x2d19e0 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [00:08:59.065] No locals. [00:08:59.065] #4 0x000000000077243f in ExecFetchSlotHeapTuple (slot=0x821686950, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [00:08:59.065] No locals. [00:08:59.065] #5 0x0000000000736e27 in ExecIRDeleteTriggers (estate=estate@entry=0x83402e100, relinfo=relinfo@entry=0x83402e6b0, slot=slot@entry=0x821686950) at ../src/backend/commands/trigger.c:2842 [00:08:59.065] trigger = [00:08:59.065] oldtuple = [00:08:59.065] should_free = false [00:08:59.065] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x836090e38, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [00:08:59.065] trigdesc = 0x83402e8c0 [00:08:59.065] newtuple = 0x0 [00:08:59.065] i = 0 [00:08:59.065] #6 0x0000000000797617 in ExecMergeMatched (context=0x8216869f8, resultRelInfo=0x83402e6b0, tupleid=0x0, oldtuple=0x821686950, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [00:08:59.065] result = TM_Ok [00:08:59.065] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [00:08:59.065] relaction = 0x8361e4120 [00:08:59.065] commandType = CMD_DELETE [00:08:59.065] l__state = {l = 0x836255378, i = 0} [00:08:59.065] mtstate = 0x83402e4a0 [00:08:59.065] newslot = 0x0 [00:08:59.065] rslot = 0x0 [00:08:59.065] estate = 0x83402e100 [00:08:59.065] mergeActions = [00:08:59.065] econtext = 0x836254418 [00:08:59.065] epqstate = 0x83402e588 [00:08:59.065] actionStates = 0x836255378 [00:08:59.065] l = [00:08:59.065] isNull = [00:08:59.065] lmerge_matched = [00:08:59.065] __error = [00:08:59.065] l__state = [00:08:59.065] result = [00:08:59.065] updateCxt = [00:08:59.065] relaction = [00:08:59.065] commandType = [00:08:59.065] __error = [00:08:59.065] resultRelationDesc = [00:08:59.065] lockmode = [00:08:59.065] inputslot = [00:08:59.065] epqslot = [00:08:59.065] was_matched = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] #7 ExecMerge (context=0x8216869f8, resultRelInfo=0x83402e6b0, tupleid=0x0, oldtuple=0x821686950, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [00:08:59.065] matched = [00:08:59.065] rslot = 0x0 [00:08:59.065] #8 ExecModifyTable (pstate=0x83402e4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [00:08:59.065] context = {mtstate = 0x83402e4a0, epqstate = 0x83402e588, estate = 0x83402e100, planSlot = 0x836252818, tmfd = {ctid = {ip_blkid = {bi_hi = 8880, bi_lo = 16721}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x83402e6b0} [00:08:59.065] tuple_ctid = {ip_blkid = {bi_hi = 8832, bi_lo = 16751}, ip_posid = 8} [00:08:59.065] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8340b0118} [00:08:59.065] node = 0x83402e4a0 [00:08:59.065] estate = 0x83402e100 [00:08:59.065] operation = CMD_MERGE [00:08:59.065] resultRelInfo = 0x83402e6b0 [00:08:59.065] subplanstate = 0x83402fdb0 [00:08:59.065] slot = [00:08:59.065] tupleid = 0x0 [00:08:59.065] oldtuple = 0x821686950 [00:08:59.065] oldSlot = [00:08:59.065] #9 0x000000000076460b in ExecProcNode (node=0x83402e4a0) at ../src/include/executor/executor.h:278 [00:08:59.065] No locals. [00:08:59.065] #10 ExecutePlan (estate=0x83402e100, planstate=0x83402e4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x83407b310, execute_once=) at ../src/backend/executor/execMain.c:1653 [00:08:59.065] current_tuple_count = 0 [00:08:59.065] slot = [00:08:59.065] #11 standard_ExecutorRun (queryDesc=0x834090448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [00:08:59.065] estate = 0x83402e100 [00:08:59.065] oldcontext = 0x83407b000 [00:08:59.065] operation = CMD_MERGE [00:08:59.065] dest = 0x83407b310 [00:08:59.065] sendTuples = true [00:08:59.065] #12 0x000000000093a49f in ProcessQuery (plan=0x841511b98, sourceText=, params=0x0, queryEnv=0x0, dest=0x83407b310, qc=0x821686bf8) at ../src/backend/tcop/pquery.c:160 [00:08:59.065] queryDesc = 0x834090448 [00:08:59.065] #13 0x0000000000939a3d in PortalRunMulti (portal=portal@entry=0x833fa9100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x83407b310, altdest=0xb818f0 , qc=qc@entry=0x821686bf8) at ../src/backend/tcop/pquery.c:1287 [00:08:59.065] pstmt = 0x841511b98 [00:08:59.065] stmtlist_item__state = {l = 0x841516450, i = 0} [00:08:59.065] active_snapshot_set = true [00:08:59.065] stmtlist_item = 0x841516468 [00:08:59.065] #14 0x000000000093954c in FillPortalStore (portal=portal@entry=0x833fa9100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [00:08:59.065] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:08:59.065] treceiver = 0x83407b310 [00:08:59.065] #15 0x00000000009392bb in PortalRun (portal=portal@entry=0x833fa9100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8415164a0, altdest=altdest@entry=0x8415164a0, qc=0x821686d30) at ../src/backend/tcop/pquery.c:763 [00:08:59.065] _local_sigjmp_buf = {{_sjb = {9671261, 35231797504, 34920229928, 34920230160, 34920229936, 35231817728, 12331624, 12364952, 35231761279, 35230925056, 4294967984, 0}}} [00:08:59.065] _save_exception_stack = 0x821686e00 [00:08:59.065] _save_context_stack = 0x0 [00:08:59.065] _do_rethrow = false [00:08:59.065] saveTopTransactionResourceOwner = 0x833fbb898 [00:08:59.065] saveTopTransactionContext = 0x833fae000 [00:08:59.065] saveActivePortal = 0x0 [00:08:59.065] saveResourceOwner = 0x833fbb898 [00:08:59.065] savePortalContext = 0x0 [00:08:59.065] saveMemoryContext = 0x833fae000 [00:08:59.065] result = [00:08:59.065] nprocessed = [00:08:59.065] #16 0x0000000000938182 in exec_simple_query (query_string=query_string@entry=0x833ed4100 "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:1284 [00:08:59.065] cmdtaglen = 5 [00:08:59.065] snapshot_set = [00:08:59.065] per_parsetree_context = 0x0 [00:08:59.065] plantree_list = [00:08:59.065] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:08:59.065] format = 0 [00:08:59.065] parsetree = 0x8361cd1a8 [00:08:59.065] commandTag = [00:08:59.065] cmdtagname = [00:08:59.065] querytree_list = [00:08:59.065] portal = 0x833fa9100 [00:08:59.065] receiver = 0x8415164a0 [00:08:59.065] parsetree_item__state = {l = 0x8361cea70, i = 0} [00:08:59.065] msec_str = "\000\000\000\000\b", '\000' , "\251j\353f\000\000\000\000IcGy\216V\000#" [00:08:59.065] dest = DestRemote [00:08:59.065] was_logged = [00:08:59.065] oldcontext = 0x833fae000 [00:08:59.065] parsetree_list = 0x8361cea70 [00:08:59.065] use_implicit_block = false [00:08:59.065] parsetree_item = 0x8361cea88 [00:08:59.065] save_log_statement_stats = [00:08:59.065] #17 0x0000000000935df3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [00:08:59.065] query_string = 0x833ed4100 "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"... [00:08:59.065] input_message = {data = 0x833ed4100 "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} [00:08:59.065] firstchar = [00:08:59.065] local_sigjmp_buf = {{_sjb = {9654950, 34920230400, 34920230360, 34920230944, 12373688, 1, 8192, 8388608, 34920203135, 0, 0, 1}}} [00:08:59.065] send_ready_for_query = false [00:08:59.065] idle_in_transaction_timeout_enabled = false [00:08:59.065] idle_session_timeout_enabled = false [00:08:59.065] #18 0x00000000009305e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:08:59.065] bsdata = [00:08:59.065] #19 0x000000000088a737 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821687b44 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821687a80) at ../src/backend/postmaster/launch_backend.c:274 [00:08:59.065] pid = [00:08:59.065] #20 0x000000000088eaf8 in BackendStartup (client_sock=0x821687a80) at ../src/backend/postmaster/postmaster.c:3415 [00:08:59.065] startup_data = {canAcceptConnections = CAC_OK} [00:08:59.065] bn = 0x833ee00d8 [00:08:59.065] pid = [00:08:59.065] __error = [00:08:59.065] save_errno = [00:08:59.065] __error = [00:08:59.065] __error = [00:08:59.065] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [00:08:59.065] 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_\3553\b", '\000' , "\340zh!\b\000\000\000h\225[)\b\000\000\000\v\000\000\000\000\000\000\000^\037\\)\b", '\000' , " {h!\b\000\000\000䤈\000\000\000\000\0000{h!\b", '\000' }, salen = 16}} [00:08:59.065] i = 0 [00:08:59.065] now = [00:08:59.065] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713141378, events = 8, fd = 0, user_data = 0x821687a30}, {pos = 871585240, events = 8, fd = 560494784, user_data = 0x0}, {pos = 0, events = 0, fd = 1270068247, user_data = 0x23a8935cc30a}, {pos = 712308640, events = 8, fd = 712379768, user_data = 0x821687548}, {pos = 560494016, events = 8, fd = 560493896, user_data = 0x23a8935cc30a}, {pos = 712287112, events = 8, fd = 712379768, user_data = 0x821687578}, {pos = 560494064, events = 8, fd = 560493944, user_data = 0x82a759194}, {pos = 563983368, events = 8, fd = 712348052, user_data = 0x8216875e0}, {pos = -1822657478, events = 9128, fd = 714170416, user_data = 0x1}, {pos = 560494096, events = 8, fd = -1822637302, user_data = 0x82a742858}, {pos = 712379768, events = 8, fd = 560494056, user_data = 0x821687660}, {pos = 560494056, events = 8, fd = 712342796, user_data = 0x8219db408}, {pos = 712342796, events = 8, fd = 560494160, user_data = 0x23a8935c743a}, {pos = 560494200, events = 8, fd = 560494648, user_data = 0x821687660}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3904863711, fd = 564006968, user_data = 0x800000001}, {pos = 563983368, events = 8, fd = 712287112, user_data = 0x8219e0288}, {pos = 712255576, events = 8, fd = 563983368, user_data = 0x8216876e8}, {pos = 560494760, events = 8, fd = 560494288, user_data = 0x23a8935cbca2}, {pos = 2700866, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 564006968, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 560495016, user_data = 0x219db408}, {pos = 560494832, events = 8, fd = 560494432, user_data = 0x1}, {pos = 560494760, events = 8, fd = 32, user_data = 0x821687750}, {pos = -1822639501, events = 9128, fd = 560494704, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8219e1038}, {pos = 1, events = 8, fd = 563983368, user_data = 0x82a742858}, {pos = 560495016, events = 8, fd = 560494832, user_data = 0x821687760}, {pos = 0, events = 0, fd = 563953672, user_data = 0x20}, {pos = 560494816, events = 8, fd = -1822663961, user_data = 0x8219d4008}, {pos = 563954696, events = 8, fd = 563955720, user_data = 0x8219d4c08}, {pos = 563970056, events = 8, fd = 563971080, user_data = 0x8219d8808}, {pos = 563973128, events = 8, fd = 563974152, user_data = 0x8219d9408}, {pos = 563976200, events = 8, fd = 563977224, user_data = 0x8219da008}, {pos = 563979272, events = 8, fd = 563980296, user_data = 0x8219dac08}, {pos = 563982344, events = 8, fd = 563983368, user_data = 0x8219db808}, {pos = 563985416, events = 8, fd = 563986440, user_data = 0x8219dc408}, {pos = 563988488, events = 8, fd = 563989512, user_data = 0x8219dd008}, {pos = 563991560, events = 8, fd = 563992584, user_data = 0x8219ddc08}, {pos = 563998728, events = 8, fd = 563999752, user_data = 0x8219df808}, {pos = 564001800, events = 8, fd = 563953672, user_data = 0x293642}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8219e1038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 560495016, events = 8, fd = 560494432, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 564006968, user_data = 0x1}, {pos = 563953672, events = 8, fd = 313, user_data = 0x821687990}, {pos = -1822665233, events = 9128, fd = 2700866, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564006968, user_data = 0x1}, {pos = 563983368, events = 8, fd = 871120896, user_data = 0x1}, {pos = 871121300, events = 8, fd = 0, user_data = 0x821687960}, {pos = 693900652, events = 8, fd = 1, user_data = 0x833ec4000}, {pos = 560494992, events = 8, fd = 693896962, user_data = 0x82a874170 }, {pos = 12298720, events = 0, fd = 713507184, user_data = 0x8219db408}, {pos = 560495216, events = 8, fd = -1822665762, user_data = 0x833ee2800}, {pos = 1, events = 0, fd = -1822666146, user_data = 0x8219d4008}, {pos = 560495000, events = 8, fd = 560495216, user_data = 0x1c20}, {pos = 871194368, events = 8, fd = -1822586480, user_data = 0x0}, {pos = 560464767, events = 8, fd = 8104535, user_data = 0x821687a20}, {pos = 693859344, events = 8, fd = 714170416, user_data = 0x82a918310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821687a50}, {pos = 693902237, events = 8, fd = 871120896, user_data = 0x178f}, {pos = 560495280, events = 8, fd = 693868794, user_data = 0x0}, {pos = 0, events = 0, fd = 1270068247, user_data = 0x0}} [00:08:59.065] last_touch_time = 1726704286 [00:08:59.065] last_lockfile_recheck_time = 1726704286 [00:08:59.065] nevents = 1 [00:08:59.065] #22 0x000000000088c915 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821688090) at ../src/backend/postmaster/postmaster.c:1346 [00:08:59.065] userDoption = [00:08:59.065] listen_addr_saved = [00:08:59.065] output_config_variable = [00:08:59.065] opt = [00:08:59.065] status = [00:08:59.065] #23 0x00000000007c773c in main (argc=8, argv=0x821688090) at ../src/backend/main/main.c:197 [00:08:59.065] do_check_root = [00:08:59.076] [00:08:59.076] [00:08:59.076] [00:08:59.136] dumping /tmp/cores/postgres.8195.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:08:59.252] [New LWP 101688] [00:08:59.313] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [00:08:59.313] Program terminated with signal SIGABRT, Aborted. [00:08:59.313] Sent by thr_kill() from pid 8195 and user 1003. [00:08:59.313] #0 0x000000082bbca41a in thr_kill () from /lib/libc.so.7 [00:08:59.913] [00:08:59.913] Thread 1 (LWP 101688): [00:08:59.913] #0 0x000000082bbca41a in thr_kill () from /lib/libc.so.7 [00:08:59.913] No symbol table info available. [00:08:59.913] #1 0x000000082bb43e64 in raise () from /lib/libc.so.7 [00:08:59.913] No symbol table info available. [00:08:59.913] #2 0x000000082bbf46f9 in abort () from /lib/libc.so.7 [00:08:59.913] No symbol table info available. [00:08:59.913] #3 0x0000000000a8f8b5 in ExceptionalCondition (conditionName=0x2d19e0 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [00:08:59.913] No locals. [00:08:59.913] #4 0x000000000077243f in ExecFetchSlotHeapTuple (slot=0x820dbed00, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [00:08:59.913] No locals. [00:08:59.913] #5 0x0000000000736e27 in ExecIRDeleteTriggers (estate=estate@entry=0x834d1a100, relinfo=relinfo@entry=0x834d1a6b0, slot=slot@entry=0x820dbed00) at ../src/backend/commands/trigger.c:2842 [00:08:59.913] trigger = [00:08:59.913] oldtuple = [00:08:59.913] should_free = false [00:08:59.913] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x837653d20, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [00:08:59.913] trigdesc = 0x834d1a8c0 [00:08:59.913] newtuple = 0x0 [00:08:59.913] i = 0 [00:08:59.913] #6 0x0000000000797617 in ExecMergeMatched (context=0x820dbeda8, resultRelInfo=0x834d1a6b0, tupleid=0x0, oldtuple=0x820dbed00, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [00:08:59.913] result = TM_Ok [00:08:59.913] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [00:08:59.913] relaction = 0x837720560 [00:08:59.913] commandType = CMD_DELETE [00:08:59.913] l__state = {l = 0x8377e3738, i = 0} [00:08:59.913] mtstate = 0x834d1a4a0 [00:08:59.913] newslot = 0x0 [00:08:59.913] rslot = 0x0 [00:08:59.913] estate = 0x834d1a100 [00:08:59.913] mergeActions = [00:08:59.913] econtext = 0x8377e27d8 [00:08:59.913] epqstate = 0x834d1a588 [00:08:59.913] actionStates = 0x8377e3738 [00:08:59.913] l = [00:08:59.913] isNull = [00:08:59.913] lmerge_matched = [00:08:59.913] __error = [00:08:59.913] l__state = [00:08:59.913] result = [00:08:59.913] updateCxt = [00:08:59.913] relaction = [00:08:59.913] commandType = [00:08:59.913] __error = [00:08:59.913] resultRelationDesc = [00:08:59.913] lockmode = [00:08:59.913] inputslot = [00:08:59.913] epqslot = [00:08:59.913] was_matched = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] #7 ExecMerge (context=0x820dbeda8, resultRelInfo=0x834d1a6b0, tupleid=0x0, oldtuple=0x820dbed00, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [00:08:59.913] matched = [00:08:59.913] rslot = 0x0 [00:08:59.913] #8 ExecModifyTable (pstate=0x834d1a4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [00:08:59.913] context = {mtstate = 0x834d1a4a0, epqstate = 0x834d1a588, estate = 0x834d1a100, planSlot = 0x8377e0bd8, tmfd = {ctid = {ip_blkid = {bi_hi = 18672, bi_lo = 14214}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x834d1a6b0} [00:08:59.913] tuple_ctid = {ip_blkid = {bi_hi = 57008, bi_lo = 17670}, ip_posid = 8} [00:08:59.913] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834bae118} [00:08:59.913] node = 0x834d1a4a0 [00:08:59.913] estate = 0x834d1a100 [00:08:59.913] operation = CMD_MERGE [00:08:59.913] resultRelInfo = 0x834d1a6b0 [00:08:59.913] subplanstate = 0x834d1bdb0 [00:08:59.913] slot = [00:08:59.913] tupleid = 0x0 [00:08:59.913] oldtuple = 0x820dbed00 [00:08:59.913] oldSlot = [00:08:59.913] #9 0x000000000076460b in ExecProcNode (node=0x834d1a4a0) at ../src/include/executor/executor.h:278 [00:08:59.913] No locals. [00:08:59.913] #10 ExecutePlan (estate=0x834d1a100, planstate=0x834d1a4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x834d04710, execute_once=) at ../src/backend/executor/execMain.c:1653 [00:08:59.913] current_tuple_count = 0 [00:08:59.913] slot = [00:08:59.913] #11 standard_ExecutorRun (queryDesc=0x834bbbc48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:364 [00:08:59.913] estate = 0x834d1a100 [00:08:59.913] oldcontext = 0x834d04400 [00:08:59.913] operation = CMD_MERGE [00:08:59.913] dest = 0x834d04710 [00:08:59.913] sendTuples = true [00:08:59.913] #12 0x000000000093a49f in ProcessQuery (plan=0x8378641d8, sourceText=, params=0x0, queryEnv=0x0, dest=0x834d04710, qc=0x820dbefa8) at ../src/backend/tcop/pquery.c:160 [00:08:59.913] queryDesc = 0x834bbbc48 [00:08:59.913] #13 0x0000000000939a3d in PortalRunMulti (portal=portal@entry=0x834c02100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x834d04710, altdest=0xb818f0 , qc=qc@entry=0x820dbefa8) at ../src/backend/tcop/pquery.c:1287 [00:08:59.913] pstmt = 0x8378641d8 [00:08:59.913] stmtlist_item__state = {l = 0x837868a90, i = 0} [00:08:59.913] active_snapshot_set = true [00:08:59.913] stmtlist_item = 0x837868aa8 [00:08:59.913] #14 0x000000000093954c in FillPortalStore (portal=portal@entry=0x834c02100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [00:08:59.913] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:08:59.913] treceiver = 0x834d04710 [00:08:59.913] #15 0x00000000009392bb in PortalRun (portal=portal@entry=0x834c02100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x837868ae0, altdest=altdest@entry=0x837868ae0, qc=0x820dbf0e0) at ../src/backend/tcop/pquery.c:763 [00:08:59.913] _local_sigjmp_buf = {{_sjb = {9671261, 35244744960, 34911023064, 34911023296, 34911023072, 35244761088, 12331624, 12364952, 35244737407, 35244073216, 4294967984, 0}}} [00:08:59.913] _save_exception_stack = 0x820dbf1b0 [00:08:59.913] _save_context_stack = 0x0 [00:08:59.913] _do_rethrow = false [00:08:59.913] saveTopTransactionResourceOwner = 0x834c51198 [00:08:59.913] saveTopTransactionContext = 0x834c06000 [00:08:59.913] saveActivePortal = 0x0 [00:08:59.913] saveResourceOwner = 0x834c51198 [00:08:59.913] savePortalContext = 0x0 [00:08:59.913] saveMemoryContext = 0x834c06000 [00:08:59.913] result = [00:08:59.913] nprocessed = [00:08:59.913] #16 0x0000000000938182 in exec_simple_query (query_string=query_string@entry=0x834b5e100 "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:1284 [00:08:59.913] cmdtaglen = 5 [00:08:59.913] snapshot_set = [00:08:59.913] per_parsetree_context = 0x0 [00:08:59.913] plantree_list = [00:08:59.913] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:08:59.913] format = 0 [00:08:59.913] parsetree = 0x8377566e8 [00:08:59.913] commandTag = [00:08:59.913] cmdtagname = [00:08:59.913] querytree_list = [00:08:59.913] portal = 0x834c02100 [00:08:59.913] receiver = 0x837868ae0 [00:08:59.913] parsetree_item__state = {l = 0x837757fb0, i = 0} [00:08:59.913] msec_str = "\000\000\000\000\b", '\000' , "\252j\353f\000\000\000\000E\226ws\275\265\236\371" [00:08:59.913] dest = DestRemote [00:08:59.913] was_logged = [00:08:59.913] oldcontext = 0x834c06000 [00:08:59.913] parsetree_list = 0x837757fb0 [00:08:59.913] use_implicit_block = false [00:08:59.913] parsetree_item = 0x837757fc8 [00:08:59.913] save_log_statement_stats = [00:08:59.913] #17 0x0000000000935df3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [00:08:59.913] query_string = 0x834b5e100 "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"... [00:08:59.913] input_message = {data = 0x834b5e100 "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} [00:08:59.913] firstchar = [00:08:59.913] local_sigjmp_buf = {{_sjb = {9654950, 34911023536, 34911023496, 34911024080, 12373688, 1, 8192, 8388608, 34910962559, 0, 0, 1}}} [00:08:59.913] send_ready_for_query = false [00:08:59.913] idle_in_transaction_timeout_enabled = false [00:08:59.913] idle_session_timeout_enabled = false [00:08:59.913] #18 0x00000000009305e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:08:59.913] bsdata = [00:08:59.913] #19 0x000000000088a737 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820dbfef4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820dbfe30) at ../src/backend/postmaster/launch_backend.c:274 [00:08:59.913] pid = [00:08:59.913] #20 0x000000000088eaf8 in BackendStartup (client_sock=0x820dbfe30) at ../src/backend/postmaster/postmaster.c:3415 [00:08:59.913] startup_data = {canAcceptConnections = CAC_OK} [00:08:59.913] bn = 0x834b6a218 [00:08:59.913] pid = [00:08:59.913] __error = [00:08:59.913] save_errno = [00:08:59.913] __error = [00:08:59.913] __error = [00:08:59.913] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [00:08:59.913] 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 = "\300\376\2654\b", '\000' , "\220\376\333 \b\000\000\000hE`*\b\000\000\000\v\000\000\000\000\000\000\000^\317`*\b", '\000' , "\320\376\333 \b\000\000\000䤈\000\000\000\000\000\340\376\333 \b", '\000' }, salen = 16}} [00:08:59.913] i = 0 [00:08:59.913] now = [00:08:59.913] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 733408386, events = 8, fd = 0, user_data = 0x820dbfde0}, {pos = 884762072, events = 8, fd = 551287920, user_data = 0x0}, {pos = 0, events = 0, fd = -1846413534, user_data = 0x37d58b5dc30a}, {pos = 732575648, events = 8, fd = 732646776, user_data = 0x820dbf8f8}, {pos = 551287152, events = 8, fd = 551287032, user_data = 0x37d58b5dc30a}, {pos = 732554120, events = 8, fd = 732646776, user_data = 0x820dbf928}, {pos = 551287200, events = 8, fd = 551287080, user_data = 0x82baad194}, {pos = 562750472, events = 8, fd = 732615060, user_data = 0x820dbf990}, {pos = -1956809670, events = 14293, fd = 734437424, user_data = 0x1}, {pos = 551287232, events = 8, fd = -1956789494, user_data = 0x82ba96858}, {pos = 732646776, events = 8, fd = 551287192, user_data = 0x820dbfa10}, {pos = 551287192, events = 8, fd = 732609804, user_data = 0x8218ae408}, {pos = 732609804, events = 8, fd = 551287296, user_data = 0x37d58b5d743a}, {pos = 551287336, events = 8, fd = 551287784, user_data = 0x820dbfa10}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 744110141, fd = 562774072, user_data = 0x800000001}, {pos = 562750472, events = 8, fd = 732554120, user_data = 0x8218b3288}, {pos = 732522584, events = 8, fd = 562750472, user_data = 0x820dbfa98}, {pos = 551287896, events = 8, fd = 551287424, user_data = 0x37d58b5dbca2}, {pos = 2700866, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 562774072, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 551288152, user_data = 0x218ae408}, {pos = 551287968, events = 8, fd = 551287568, user_data = 0x1}, {pos = 551287896, events = 8, fd = 32, user_data = 0x820dbfb00}, {pos = -1956791693, events = 14293, fd = 551287840, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8218b4038}, {pos = 1, events = 8, fd = 562750472, user_data = 0x82ba96858}, {pos = 551288152, events = 8, fd = 551287968, user_data = 0x820dbfb10}, {pos = 0, events = 0, fd = 562720776, user_data = 0x20}, {pos = 551287952, events = 8, fd = -1956816153, user_data = 0x8218a7008}, {pos = 562721800, events = 8, fd = 562722824, user_data = 0x8218a7c08}, {pos = 562737160, events = 8, fd = 562738184, user_data = 0x8218ab808}, {pos = 562740232, events = 8, fd = 562741256, user_data = 0x8218ac408}, {pos = 562743304, events = 8, fd = 562744328, user_data = 0x8218ad008}, {pos = 562746376, events = 8, fd = 562747400, user_data = 0x8218adc08}, {pos = 562749448, events = 8, fd = 562750472, user_data = 0x8218ae808}, {pos = 562752520, events = 8, fd = 562753544, user_data = 0x8218af408}, {pos = 562755592, events = 8, fd = 562756616, user_data = 0x8218b0008}, {pos = 562758664, events = 8, fd = 562759688, user_data = 0x8218b0c08}, {pos = 562765832, events = 8, fd = 562766856, user_data = 0x8218b2808}, {pos = 562768904, events = 8, fd = 562720776, user_data = 0x293642}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8218b4038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 551288152, events = 8, fd = 551287568, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 562774072, user_data = 0x1}, {pos = 562720776, events = 8, fd = 313, user_data = 0x820dbfd40}, {pos = -1956817425, events = 14293, fd = 2700866, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 562774072, user_data = 0x1}, {pos = 562750472, events = 8, fd = 884269056, user_data = 0x1}, {pos = 884269460, events = 8, fd = 0, user_data = 0x820dbfd10}, {pos = 710985068, events = 8, fd = 1, user_data = 0x834b4e000}, {pos = 551288128, events = 8, fd = 710981378, user_data = 0x82bbc8170 }, {pos = 12298720, events = 0, fd = 733774192, user_data = 0x8218ae408}, {pos = 551288352, events = 8, fd = -1956817954, user_data = 0x834b6c800}, {pos = 1, events = 0, fd = -1956818338, user_data = 0x8218a7008}, {pos = 551288136, events = 8, fd = 551288352, user_data = 0x1c20}, {pos = 884342464, events = 8, fd = -1956738672, user_data = 0x0}, {pos = 551224191, events = 8, fd = 8104535, user_data = 0x820dbfdd0}, {pos = 710943760, events = 8, fd = 734437424, user_data = 0x82bc6c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820dbfe00}, {pos = 710986653, events = 8, fd = 884269056, user_data = 0x179e}, {pos = 551288416, events = 8, fd = 710953210, user_data = 0x0}, {pos = 0, events = 0, fd = -1846413534, user_data = 0x0}} [00:08:59.913] last_touch_time = 1726704287 [00:08:59.913] last_lockfile_recheck_time = 1726704287 [00:08:59.913] nevents = 1 [00:08:59.913] #22 0x000000000088c915 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820dc0448) at ../src/backend/postmaster/postmaster.c:1346 [00:08:59.913] userDoption = [00:08:59.913] listen_addr_saved = [00:08:59.913] output_config_variable = [00:08:59.913] opt = [00:08:59.913] status = [00:08:59.913] #23 0x00000000007c773c in main (argc=4, argv=0x820dc0448) at ../src/backend/main/main.c:197 [00:08:59.913] do_check_root = [00:08:59.925] [00:08:59.925] [00:08:59.925] [00:08:59.972] dumping /tmp/cores/sh.12175.core for /bin/sh [00:09:00.009] [New LWP 100163] [00:09:00.009] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/'. [00:09:00.009] Program terminated with signal SIGQUIT, Quit. [00:09:00.009] Sent by kill() from pid 12115 and user 1003. [00:09:00.009] #0 0x000039c0dce37ff0 in ?? () [00:09:00.009] [00:09:00.009] Thread 1 (LWP 100163): [00:09:00.009] #0 0x000039c0dce37ff0 in ?? () [00:09:00.009] No symbol table info available. [00:09:00.009] #1 0x0000000000000000 in ?? () [00:09:00.009] No symbol table info available. [00:09:00.014] [00:09:00.014] [00:09:00.014] [00:09:00.074] dumping /tmp/cores/postgres.14145.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:09:00.190] [New LWP 101762] [00:09:00.250] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [00:09:00.250] Program terminated with signal SIGABRT, Aborted. [00:09:00.250] Sent by thr_kill() from pid 14145 and user 1003. [00:09:00.250] #0 0x000000082992e41a in thr_kill () from /lib/libc.so.7 [00:09:00.862] [00:09:00.862] Thread 1 (LWP 101762): [00:09:00.862] #0 0x000000082992e41a in thr_kill () from /lib/libc.so.7 [00:09:00.862] No symbol table info available. [00:09:00.862] #1 0x00000008298a7e64 in raise () from /lib/libc.so.7 [00:09:00.862] No symbol table info available. [00:09:00.862] #2 0x00000008299586f9 in abort () from /lib/libc.so.7 [00:09:00.862] No symbol table info available. [00:09:00.862] #3 0x0000000000a8f8b5 in ExceptionalCondition (conditionName=0x2d19e0 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [00:09:00.862] No locals. [00:09:00.862] #4 0x000000000077243f in ExecFetchSlotHeapTuple (slot=0x821638a60, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [00:09:00.862] No locals. [00:09:00.862] #5 0x0000000000736e27 in ExecIRDeleteTriggers (estate=estate@entry=0x8335a7100, relinfo=relinfo@entry=0x8335a76b0, slot=slot@entry=0x821638a60) at ../src/backend/commands/trigger.c:2842 [00:09:00.862] trigger = [00:09:00.862] oldtuple = [00:09:00.862] should_free = false [00:09:00.862] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x836bd37c0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [00:09:00.862] trigdesc = 0x8335a78c0 [00:09:00.862] newtuple = 0x0 [00:09:00.862] i = 0 [00:09:00.862] #6 0x0000000000797617 in ExecMergeMatched (context=0x821638b08, resultRelInfo=0x8335a76b0, tupleid=0x0, oldtuple=0x821638a60, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [00:09:00.862] result = TM_Ok [00:09:00.862] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [00:09:00.862] relaction = 0x836c17a60 [00:09:00.862] commandType = CMD_DELETE [00:09:00.862] l__state = {l = 0x836d8e9f8, i = 0} [00:09:00.862] mtstate = 0x8335a74a0 [00:09:00.862] newslot = 0x0 [00:09:00.862] rslot = 0x0 [00:09:00.862] estate = 0x8335a7100 [00:09:00.862] mergeActions = [00:09:00.862] econtext = 0x836d8da98 [00:09:00.862] epqstate = 0x8335a7588 [00:09:00.862] actionStates = 0x836d8e9f8 [00:09:00.862] l = [00:09:00.862] isNull = [00:09:00.862] lmerge_matched = [00:09:00.862] __error = [00:09:00.862] l__state = [00:09:00.862] result = [00:09:00.862] updateCxt = [00:09:00.862] relaction = [00:09:00.862] commandType = [00:09:00.862] __error = [00:09:00.862] resultRelationDesc = [00:09:00.862] lockmode = [00:09:00.862] inputslot = [00:09:00.862] epqslot = [00:09:00.862] was_matched = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] #7 ExecMerge (context=0x821638b08, resultRelInfo=0x8335a76b0, tupleid=0x0, oldtuple=0x821638a60, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [00:09:00.862] matched = [00:09:00.862] rslot = 0x0 [00:09:00.862] #8 ExecModifyTable (pstate=0x8335a74a0) at ../src/backend/executor/nodeModifyTable.c:4133 [00:09:00.862] context = {mtstate = 0x8335a74a0, epqstate = 0x8335a7588, estate = 0x8335a7100, planSlot = 0x836d8be98, tmfd = {ctid = {ip_blkid = {bi_hi = 44430, bi_lo = 10642}, ip_posid = 8}, xmax = 119, cmax = 0, traversed = 126}, cpUpdateReturningSlot = 0xcd2bafe9aea12426} [00:09:00.862] tuple_ctid = {ip_blkid = {bi_hi = 35632, bi_lo = 8547}, ip_posid = 8} [00:09:00.862] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83363b118} [00:09:00.862] node = 0x8335a74a0 [00:09:00.862] estate = 0x8335a7100 [00:09:00.862] operation = CMD_MERGE [00:09:00.862] resultRelInfo = 0x8335a76b0 [00:09:00.862] subplanstate = 0x8335a8db0 [00:09:00.862] slot = [00:09:00.862] tupleid = 0x0 [00:09:00.862] oldtuple = 0x821638a60 [00:09:00.862] oldSlot = [00:09:00.862] #9 0x000000000076460b in ExecProcNode (node=0x8335a74a0) at ../src/include/executor/executor.h:278 [00:09:00.862] No locals. [00:09:00.862] #10 ExecutePlan (estate=0x8335a7100, planstate=0x8335a74a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x83356df10, execute_once=) at ../src/backend/executor/execMain.c:1653 [00:09:00.862] current_tuple_count = 0 [00:09:00.862] slot = [00:09:00.862] #11 standard_ExecutorRun (queryDesc=0x83363d448, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:364 [00:09:00.862] estate = 0x8335a7100 [00:09:00.862] oldcontext = 0x83356dc00 [00:09:00.862] operation = CMD_MERGE [00:09:00.862] dest = 0x83356df10 [00:09:00.862] sendTuples = true [00:09:00.862] #12 0x0000000838279961 in pgss_ExecutorRun (queryDesc=0x83363d448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1024 [00:09:00.862] _local_sigjmp_buf = {{_sjb = {35301857585, 1, 34919910456, 34919910624, 12364952, 34919910464, 1, 35221918792, 34919875455, 7827969, 35221303296, 34359738368}}} [00:09:00.862] _save_exception_stack = 0x821638df0 [00:09:00.862] _save_context_stack = 0x0 [00:09:00.862] _do_rethrow = false [00:09:00.862] #13 0x000000000093a49f in ProcessQuery (plan=0x836d3e680, sourceText=, params=0x0, queryEnv=0x0, dest=0x83356df10, qc=0x821638db8) at ../src/backend/tcop/pquery.c:160 [00:09:00.862] queryDesc = 0x83363d448 [00:09:00.862] #14 0x0000000000939a3d in PortalRunMulti (portal=portal@entry=0x83350f100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x83356df10, altdest=0xb818f0 , qc=qc@entry=0x821638db8) at ../src/backend/tcop/pquery.c:1287 [00:09:00.862] pstmt = 0x836d3e680 [00:09:00.862] stmtlist_item__state = {l = 0x836d42f38, i = 0} [00:09:00.862] active_snapshot_set = true [00:09:00.862] stmtlist_item = 0x836d42f50 [00:09:00.862] #15 0x000000000093954c in FillPortalStore (portal=portal@entry=0x83350f100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [00:09:00.862] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:09:00.862] treceiver = 0x83356df10 [00:09:00.862] #16 0x00000000009392bb in PortalRun (portal=portal@entry=0x83350f100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x836d42f88, altdest=altdest@entry=0x836d42f88, qc=0x821638ef0) at ../src/backend/tcop/pquery.c:763 [00:09:00.862] _local_sigjmp_buf = {{_sjb = {9671261, 35220680960, 34919910888, 34919911120, 34919910896, 35220774912, 12331624, 12364952, 35220685695, 35220001024, 4294967984, 0}}} [00:09:00.862] _save_exception_stack = 0x821638fc0 [00:09:00.862] _save_context_stack = 0x0 [00:09:00.862] _do_rethrow = false [00:09:00.862] saveTopTransactionResourceOwner = 0x83355db18 [00:09:00.862] saveTopTransactionContext = 0x833526000 [00:09:00.862] saveActivePortal = 0x0 [00:09:00.862] saveResourceOwner = 0x83355db18 [00:09:00.862] savePortalContext = 0x0 [00:09:00.862] saveMemoryContext = 0x833526000 [00:09:00.862] result = [00:09:00.862] nprocessed = [00:09:00.862] #17 0x0000000000938182 in exec_simple_query (query_string=query_string@entry=0x833469100 "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:1284 [00:09:00.862] cmdtaglen = 5 [00:09:00.862] snapshot_set = [00:09:00.862] per_parsetree_context = 0x0 [00:09:00.862] plantree_list = [00:09:00.862] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:09:00.862] format = 0 [00:09:00.862] parsetree = 0x836d012e8 [00:09:00.862] commandTag = [00:09:00.862] cmdtagname = [00:09:00.862] querytree_list = [00:09:00.862] portal = 0x83350f100 [00:09:00.862] receiver = 0x836d42f88 [00:09:00.862] parsetree_item__state = {l = 0x836d02bb0, i = 0} [00:09:00.862] msec_str = "\000\000\000\000\b", '\000' , "\312j\353f\000\000\000\000mHesWk:\233" [00:09:00.862] dest = DestRemote [00:09:00.862] was_logged = [00:09:00.862] oldcontext = 0x833526000 [00:09:00.862] parsetree_list = 0x836d02bb0 [00:09:00.862] use_implicit_block = false [00:09:00.862] parsetree_item = 0x836d02bc8 [00:09:00.862] save_log_statement_stats = [00:09:00.862] #18 0x0000000000935df3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [00:09:00.862] query_string = 0x833469100 "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"... [00:09:00.862] input_message = {data = 0x833469100 "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} [00:09:00.862] firstchar = [00:09:00.862] local_sigjmp_buf = {{_sjb = {9654950, 34919911360, 34919911320, 34919911904, 12373688, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [00:09:00.862] send_ready_for_query = false [00:09:00.862] idle_in_transaction_timeout_enabled = false [00:09:00.862] idle_session_timeout_enabled = false [00:09:00.862] #19 0x00000000009305e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:09:00.862] bsdata = [00:09:00.862] #20 0x000000000088a737 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821639d04 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821639c40) at ../src/backend/postmaster/launch_backend.c:274 [00:09:00.862] pid = [00:09:00.862] #21 0x000000000088eaf8 in BackendStartup (client_sock=0x821639c40) at ../src/backend/postmaster/postmaster.c:3415 [00:09:00.862] startup_data = {canAcceptConnections = CAC_OK} [00:09:00.862] bn = 0x8334753a8 [00:09:00.862] pid = [00:09:00.862] __error = [00:09:00.862] save_errno = [00:09:00.862] __error = [00:09:00.862] __error = [00:09:00.862] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [00:09:00.862] 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 = " \234F3\b", '\000' , "\240\234c!\b\000\000\000h5\006+\b\000\000\000\v\000\000\000\000\000\000\000^\277\006+\b", '\000' , "\340\234c!\b\000\000\000䤈\000\000\000\000\000\360\234c!\b", '\000' }, salen = 16}} [00:09:00.862] i = 0 [00:09:00.862] now = [00:09:00.862] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 697117826, events = 8, fd = 0, user_data = 0x821639bf0}, {pos = 860689880, events = 8, fd = 560175744, user_data = 0x0}, {pos = 803644170, events = 389, fd = 696285088, user_data = 0x829818d78}, {pos = 560174840, events = 8, fd = 560174960, user_data = 0x8216396f8}, {pos = 803644170, events = 389, fd = 696263560, user_data = 0x829818d78}, {pos = 560174888, events = 8, fd = 560175008, user_data = 0x821639728}, {pos = 696324500, events = 8, fd = 576398344, user_data = 0x829811194}, {pos = 560174992, events = 8, fd = 803623994, user_data = 0x821639730}, {pos = 721818640, events = 8, fd = 698146864, user_data = 0x1852fe6a30a}, {pos = 696232024, events = 8, fd = 696356216, user_data = 0x821639798}, {pos = 560175120, events = 8, fd = 560175000, user_data = 0x82980fd0c}, {pos = 576398344, events = 8, fd = 696319244, user_data = 0x821639800}, {pos = 803623994, events = 389, fd = 560175144, user_data = 0x8216399f8}, {pos = 560175120, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8225b8038}, {pos = 1, events = 3442192361, fd = 576398344, user_data = 0x829802388}, {pos = 576419784, events = 8, fd = 0, user_data = 0x0}, {pos = 560175256, events = 8, fd = 560175720, user_data = 0x821639880}, {pos = 803642530, events = 389, fd = 2700866, user_data = 0x6d68b}, {pos = 2090263927, events = 3442192361, fd = 576421944, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821639b68}, {pos = 576398344, events = 3, fd = 560175792, user_data = 0x8225b7828}, {pos = 656, events = 0, fd = 560175720, user_data = 0x821639898}, {pos = 560175360, events = 8, fd = 803642139, user_data = 0x821639a30}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 576421944, events = 8, fd = 1, user_data = 0x8225b2408}, {pos = 696232024, events = 8, fd = 560175976, user_data = 0x821639ab0}, {pos = 560175376, events = 8, fd = 0, user_data = 0x8225ab008}, {pos = 33, events = 0, fd = 560175776, user_data = 0x1852fe63ae7}, {pos = 576368648, events = 8, fd = 576369672, user_data = 0x8225ab808}, {pos = 576371720, events = 8, fd = 576385032, user_data = 0x8225af408}, {pos = 576387080, events = 8, fd = 576388104, user_data = 0x8225b0008}, {pos = 576390152, events = 8, fd = 576391176, user_data = 0x8225b0c08}, {pos = 576393224, events = 8, fd = 576394248, user_data = 0x8225b1808}, {pos = 576396296, events = 8, fd = 576397320, user_data = 0x8225b2408}, {pos = 576399368, events = 8, fd = 576400392, user_data = 0x8225b3008}, {pos = 576402440, events = 8, fd = 576403464, user_data = 0x8225b3c08}, {pos = 576405512, events = 8, fd = 576406536, user_data = 0x8225b4808}, {pos = 576408584, events = 8, fd = 576413704, user_data = 0x8225b6408}, {pos = 576415752, events = 8, fd = 576416776, user_data = 0x8225b9408}, {pos = 417422000, events = 0, fd = 576368648, user_data = 0x293642}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8225b8038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 560175976, events = 8, fd = 560175376, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 576421944, user_data = 0x1}, {pos = 576368648, events = 8, fd = 313, user_data = 0x821639b50}, {pos = 803616239, events = 389, fd = 2700866, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 576421944, user_data = 0x1}, {pos = 576398344, events = 8, fd = 860196864, user_data = 0x1}, {pos = 860197268, events = 8, fd = 0, user_data = 0x821639b20}, {pos = 721859948, events = 8, fd = 1, user_data = 0x833459000}, {pos = 560175952, events = 8, fd = 721856258, user_data = 0x82992c170 }, {pos = 12298720, events = 0, fd = 697483632, user_data = 0x8225b2408}, {pos = 560176176, events = 8, fd = 803615710, user_data = 0x833477800}, {pos = 1, events = 0, fd = 803615326, user_data = 0x8225ab008}, {pos = 560175960, events = 8, fd = 560176176, user_data = 0x1c20}, {pos = 860265504, events = 8, fd = 803694992, user_data = 0x0}, {pos = 560137087, events = 8, fd = 8104535, user_data = 0x821639be0}, {pos = 721818640, events = 8, fd = 698146864, user_data = 0x8299d0310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821639c10}, {pos = 721861533, events = 8, fd = 860196864, user_data = 0x2fd9}, {pos = 560176240, events = 8, fd = 721828090, user_data = 0x0}, {pos = 0, events = 0, fd = -1365171162, user_data = 0x0}} [00:09:00.862] last_touch_time = 1726704317 [00:09:00.862] last_lockfile_recheck_time = 1726704317 [00:09:00.862] nevents = 1 [00:09:00.862] #23 0x000000000088c915 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82163a258) at ../src/backend/postmaster/postmaster.c:1346 [00:09:00.862] userDoption = [00:09:00.862] listen_addr_saved = [00:09:00.862] output_config_variable = [00:09:00.862] opt = [00:09:00.862] status = [00:09:00.862] #24 0x00000000007c773c in main (argc=4, argv=0x82163a258) at ../src/backend/main/main.c:197 [00:09:00.862] do_check_root =