[06:03:34.354] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [06:03:34.750] dumping /tmp/cores/postgres.7988.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [06:03:34.891] [New LWP 101710] [06:03:34.990] Core was generated by `postgres: postgres regression [local] MERGE'. [06:03:34.990] Program terminated with signal SIGABRT, Aborted. [06:03:34.990] Sent by thr_kill() from pid 7988 and user 1003. [06:03:34.990] #0 0x000000082b5dd41a in thr_kill () from /lib/libc.so.7 [06:03:35.685] [06:03:35.685] Thread 1 (LWP 101710): [06:03:35.685] #0 0x000000082b5dd41a in thr_kill () from /lib/libc.so.7 [06:03:35.685] No symbol table info available. [06:03:35.685] #1 0x000000082b556e64 in raise () from /lib/libc.so.7 [06:03:35.685] No symbol table info available. [06:03:35.685] #2 0x000000082b6076f9 in abort () from /lib/libc.so.7 [06:03:35.685] No symbol table info available. [06:03:35.685] #3 0x0000000000a8c0e5 in ExceptionalCondition (conditionName=0x2d18c9 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [06:03:35.685] No locals. [06:03:35.685] #4 0x000000000076f4ff in ExecFetchSlotHeapTuple (slot=0x82193dc50, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [06:03:35.685] No locals. [06:03:35.685] #5 0x00000000007341b7 in ExecIRDeleteTriggers (estate=estate@entry=0x8352a3100, relinfo=relinfo@entry=0x8352a36b0, slot=slot@entry=0x82193dc50) at ../src/backend/commands/trigger.c:2841 [06:03:35.685] trigger = [06:03:35.685] oldtuple = [06:03:35.685] should_free = false [06:03:35.685] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x841576538, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [06:03:35.685] trigdesc = 0x8352a38c0 [06:03:35.685] newtuple = 0x0 [06:03:35.685] i = 0 [06:03:35.685] #6 0x00000000007946d7 in ExecMergeMatched (context=0x82193dcf8, resultRelInfo=0x8352a36b0, tupleid=0x0, oldtuple=0x82193dc50, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [06:03:35.685] result = TM_Ok [06:03:35.685] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [06:03:35.685] relaction = 0x841695ca0 [06:03:35.685] commandType = CMD_DELETE [06:03:35.685] l__state = {l = 0x84175bd78, i = 0} [06:03:35.685] mtstate = 0x8352a34a0 [06:03:35.685] newslot = 0x0 [06:03:35.685] rslot = 0x0 [06:03:35.685] estate = 0x8352a3100 [06:03:35.685] mergeActions = [06:03:35.685] econtext = 0x84175ae18 [06:03:35.685] epqstate = 0x8352a3588 [06:03:35.685] actionStates = 0x84175bd78 [06:03:35.685] l = [06:03:35.685] isNull = [06:03:35.685] lmerge_matched = [06:03:35.685] __error = [06:03:35.685] l__state = [06:03:35.685] result = [06:03:35.685] updateCxt = [06:03:35.685] relaction = [06:03:35.685] commandType = [06:03:35.685] __error = [06:03:35.685] resultRelationDesc = [06:03:35.685] lockmode = [06:03:35.685] inputslot = [06:03:35.685] epqslot = [06:03:35.685] was_matched = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] #7 ExecMerge (context=0x82193dcf8, resultRelInfo=0x8352a36b0, tupleid=0x0, oldtuple=0x82193dc50, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [06:03:35.685] matched = [06:03:35.685] rslot = 0x0 [06:03:35.685] #8 ExecModifyTable (pstate=0x8352a34a0) at ../src/backend/executor/nodeModifyTable.c:4133 [06:03:35.685] context = {mtstate = 0x8352a34a0, epqstate = 0x8352a3588, estate = 0x8352a3100, planSlot = 0x841759218, tmfd = {ctid = {ip_blkid = {bi_hi = 40560, bi_lo = 16753}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8352a36b0} [06:03:35.685] tuple_ctid = {ip_blkid = {bi_hi = 36752, bi_lo = 17636}, ip_posid = 8} [06:03:35.685] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835321118} [06:03:35.685] node = 0x8352a34a0 [06:03:35.685] estate = 0x8352a3100 [06:03:35.685] operation = CMD_MERGE [06:03:35.685] resultRelInfo = 0x8352a36b0 [06:03:35.685] subplanstate = 0x8352a4db0 [06:03:35.685] slot = [06:03:35.685] tupleid = 0x0 [06:03:35.685] oldtuple = 0x82193dc50 [06:03:35.685] oldSlot = [06:03:35.685] #9 0x000000000076176b in ExecProcNode (node=0x8352a34a0) at ../src/include/executor/executor.h:278 [06:03:35.685] No locals. [06:03:35.685] #10 ExecutePlan (estate=0x8352a3100, planstate=0x8352a34a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x835157710, execute_once=) at ../src/backend/executor/execMain.c:1641 [06:03:35.685] current_tuple_count = 0 [06:03:35.685] slot = [06:03:35.685] #11 standard_ExecutorRun (queryDesc=0x835325448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [06:03:35.685] estate = 0x8352a3100 [06:03:35.685] oldcontext = 0x835157400 [06:03:35.685] operation = CMD_MERGE [06:03:35.685] dest = 0x835157710 [06:03:35.685] sendTuples = true [06:03:35.685] #12 0x00000000009370af in ProcessQuery (plan=0x841719758, sourceText=, params=0x0, queryEnv=0x0, dest=0x835157710, qc=0x82193def8) at ../src/backend/tcop/pquery.c:160 [06:03:35.685] queryDesc = 0x835325448 [06:03:35.685] #13 0x000000000093664d in PortalRunMulti (portal=portal@entry=0x83521e100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x835157710, altdest=0xb7dcf0 , qc=qc@entry=0x82193def8) at ../src/backend/tcop/pquery.c:1287 [06:03:35.685] pstmt = 0x841719758 [06:03:35.685] stmtlist_item__state = {l = 0x84171e010, i = 0} [06:03:35.685] active_snapshot_set = true [06:03:35.685] stmtlist_item = 0x84171e028 [06:03:35.685] #14 0x000000000093615c in FillPortalStore (portal=portal@entry=0x83521e100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [06:03:35.685] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:03:35.685] treceiver = 0x835157710 [06:03:35.685] #15 0x0000000000935ecb in PortalRun (portal=portal@entry=0x83521e100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x84171e060, altdest=altdest@entry=0x84171e060, qc=0x82193e030) at ../src/backend/tcop/pquery.c:763 [06:03:35.685] _local_sigjmp_buf = {{_sjb = {9657965, 35251151104, 34923077416, 34923077648, 34923077424, 35251171328, 12316232, 12349560, 35251159935, 35250278656, 4294967984, 0}}} [06:03:35.685] _save_exception_stack = 0x82193e100 [06:03:35.685] _save_context_stack = 0x0 [06:03:35.685] _do_rethrow = false [06:03:35.685] saveTopTransactionResourceOwner = 0x835230198 [06:03:35.685] saveTopTransactionContext = 0x835223000 [06:03:35.685] saveActivePortal = 0x0 [06:03:35.685] saveResourceOwner = 0x835230198 [06:03:35.685] savePortalContext = 0x0 [06:03:35.685] saveMemoryContext = 0x835223000 [06:03:35.685] result = [06:03:35.685] nprocessed = [06:03:35.685] #16 0x0000000000934d92 in exec_simple_query (query_string=query_string@entry=0x835149100 "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 [06:03:35.685] cmdtaglen = 5 [06:03:35.685] snapshot_set = [06:03:35.685] per_parsetree_context = 0x0 [06:03:35.685] plantree_list = [06:03:35.685] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:03:35.685] format = 0 [06:03:35.685] parsetree = 0x8416d3ce8 [06:03:35.685] commandTag = [06:03:35.685] cmdtagname = [06:03:35.685] querytree_list = [06:03:35.685] portal = 0x83521e100 [06:03:35.685] receiver = 0x84171e060 [06:03:35.685] parsetree_item__state = {l = 0x8416d55b0, i = 0} [06:03:35.685] msec_str = "\000\000\000\000\b", '\000' , "\275w\346f\000\000\000\000\252\235\023AӒ\271\251" [06:03:35.685] dest = DestRemote [06:03:35.685] was_logged = [06:03:35.685] oldcontext = 0x835223000 [06:03:35.685] parsetree_list = 0x8416d55b0 [06:03:35.685] use_implicit_block = false [06:03:35.685] parsetree_item = 0x8416d55c8 [06:03:35.685] save_log_statement_stats = [06:03:35.685] #17 0x0000000000932b00 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [06:03:35.685] query_string = 0x835149100 "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"... [06:03:35.685] input_message = {data = 0x835149100 "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} [06:03:35.685] firstchar = [06:03:35.685] local_sigjmp_buf = {{_sjb = {9641878, 34923077888, 34923077848, 34923078432, 12358296, 1, 8192, 8388608, 34923021183, 0, 0, 1}}} [06:03:35.685] send_ready_for_query = false [06:03:35.685] idle_in_transaction_timeout_enabled = false [06:03:35.685] idle_session_timeout_enabled = false [06:03:35.685] #18 0x000000000092d2d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:03:35.685] bsdata = [06:03:35.685] #19 0x0000000000887457 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82193ee44 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82193ed80) at ../src/backend/postmaster/launch_backend.c:274 [06:03:35.685] pid = [06:03:35.685] #20 0x000000000088b818 in BackendStartup (client_sock=0x82193ed80) at ../src/backend/postmaster/postmaster.c:3415 [06:03:35.685] startup_data = {canAcceptConnections = CAC_OK} [06:03:35.685] bn = 0x835155498 [06:03:35.685] pid = [06:03:35.685] __error = [06:03:35.685] save_errno = [06:03:35.685] __error = [06:03:35.685] __error = [06:03:35.685] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [06:03:35.685] 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\257\0245\b", '\000' , "\340\355\223!\b\000\000\000h\005\370*\b\000\000\000\v\000\000\000\000\000\000\000^\217\370*\b", '\000' , " \356\223!\b\000\000\000\004r\210\000\000\000\000\0000\356\223!\b", '\000' }, salen = 16}} [06:03:35.685] i = 0 [06:03:35.685] now = [06:03:35.685] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 727194754, events = 8, fd = 0, user_data = 0x82193ed30}, {pos = 890938840, events = 8, fd = 563342272, user_data = 0x0}, {pos = 0, events = 0, fd = 1891923952, user_data = 0x33a08049b30a}, {pos = 726362016, events = 8, fd = 726433144, user_data = 0x82193e848}, {pos = 563341504, events = 8, fd = 563341384, user_data = 0x33a08049b30a}, {pos = 726340488, events = 8, fd = 726433144, user_data = 0x82193e878}, {pos = 563341552, events = 8, fd = 563341432, user_data = 0x82b4c0194}, {pos = 568878088, events = 8, fd = 726401428, user_data = 0x82193e8e0}, {pos = -2142673862, events = 13216, fd = 728223792, user_data = 0x1}, {pos = 563341584, events = 8, fd = -2142653686, user_data = 0x82b4a9858}, {pos = 726433144, events = 8, fd = 563341544, user_data = 0x82193e960}, {pos = 563341544, events = 8, fd = 726396172, user_data = 0x821e86408}, {pos = 726396172, events = 8, fd = 563341648, user_data = 0x33a08049643a}, {pos = 563341688, events = 8, fd = 563342136, user_data = 0x82193e960}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2629893964, fd = 568901688, user_data = 0x800000001}, {pos = 568878088, events = 8, fd = 726340488, user_data = 0x821e8b288}, {pos = 726308952, events = 8, fd = 568878088, user_data = 0x82193e9e8}, {pos = 563342248, events = 8, fd = 563341776, user_data = 0x33a08049aca2}, {pos = 2700546, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 568901688, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 563342504, user_data = 0x21e86408}, {pos = 563342320, events = 8, fd = 563341920, user_data = 0x1}, {pos = 563342248, events = 8, fd = 32, user_data = 0x82193ea50}, {pos = -2142655885, events = 13216, fd = 563342192, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821e8c038}, {pos = 1, events = 8, fd = 568878088, user_data = 0x82b4a9858}, {pos = 563342504, events = 8, fd = 563342320, user_data = 0x82193ea60}, {pos = 0, events = 0, fd = 568848392, user_data = 0x20}, {pos = 563342304, events = 8, fd = -2142680345, user_data = 0x821e7f008}, {pos = 568849416, events = 8, fd = 568850440, user_data = 0x821e7fc08}, {pos = 568864776, events = 8, fd = 568865800, user_data = 0x821e83808}, {pos = 568867848, events = 8, fd = 568868872, user_data = 0x821e84408}, {pos = 568870920, events = 8, fd = 568871944, user_data = 0x821e85008}, {pos = 568873992, events = 8, fd = 568875016, user_data = 0x821e85c08}, {pos = 568877064, events = 8, fd = 568878088, user_data = 0x821e86808}, {pos = 568880136, events = 8, fd = 568881160, user_data = 0x821e87408}, {pos = 568883208, events = 8, fd = 568884232, user_data = 0x821e88008}, {pos = 568886280, events = 8, fd = 568887304, user_data = 0x821e88c08}, {pos = 568893448, events = 8, fd = 568894472, user_data = 0x821e8a808}, {pos = 568896520, events = 8, fd = 568848392, user_data = 0x293502}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821e8c038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 563342504, events = 8, fd = 563341920, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 568901688, user_data = 0x1}, {pos = 568848392, events = 8, fd = 313, user_data = 0x82193ec90}, {pos = -2142681617, events = 13216, fd = 2700546, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 568901688, user_data = 0x1}, {pos = 568878088, events = 8, fd = 890474496, user_data = 0x1}, {pos = 890474900, events = 8, fd = 0, user_data = 0x82193ec60}, {pos = 720930156, events = 8, fd = 1, user_data = 0x835139000}, {pos = 563342480, events = 8, fd = 720926466, user_data = 0x82b5db170 }, {pos = 12283328, events = 0, fd = 727560560, user_data = 0x821e86408}, {pos = 563342704, events = 8, fd = -2142682146, user_data = 0x835157800}, {pos = 1, events = 0, fd = -2142682530, user_data = 0x821e7f008}, {pos = 563342488, events = 8, fd = 563342704, user_data = 0x1c20}, {pos = 890547968, events = 8, fd = -2142602864, user_data = 0x0}, {pos = 563282815, events = 8, fd = 8092439, user_data = 0x82193ed20}, {pos = 720888848, events = 8, fd = 728223792, user_data = 0x82b67f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82193ed50}, {pos = 720931741, events = 8, fd = 890474496, user_data = 0x1765}, {pos = 563342768, events = 8, fd = 720898298, user_data = 0x0}, {pos = 0, events = 0, fd = 1891923952, user_data = 0x0}} [06:03:35.685] last_touch_time = 1726379955 [06:03:35.685] last_lockfile_recheck_time = 1726379955 [06:03:35.685] nevents = 1 [06:03:35.685] #22 0x0000000000889635 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82193f398) at ../src/backend/postmaster/postmaster.c:1346 [06:03:35.685] userDoption = [06:03:35.685] listen_addr_saved = [06:03:35.685] output_config_variable = [06:03:35.685] opt = [06:03:35.685] status = [06:03:35.685] #23 0x00000000007c47fc in main (argc=8, argv=0x82193f398) at ../src/backend/main/main.c:197 [06:03:35.685] do_check_root = [06:03:35.698] [06:03:35.698] [06:03:35.698] [06:03:35.763] dumping /tmp/cores/postgres.8192.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:03:35.885] [New LWP 101708] [06:03:35.958] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [06:03:35.958] Program terminated with signal SIGABRT, Aborted. [06:03:35.958] Sent by thr_kill() from pid 8192 and user 1003. [06:03:35.958] #0 0x000000082add041a in thr_kill () from /lib/libc.so.7 [06:03:36.585] [06:03:36.585] Thread 1 (LWP 101708): [06:03:36.585] #0 0x000000082add041a in thr_kill () from /lib/libc.so.7 [06:03:36.585] No symbol table info available. [06:03:36.585] #1 0x000000082ad49e64 in raise () from /lib/libc.so.7 [06:03:36.585] No symbol table info available. [06:03:36.585] #2 0x000000082adfa6f9 in abort () from /lib/libc.so.7 [06:03:36.585] No symbol table info available. [06:03:36.585] #3 0x0000000000a8c0e5 in ExceptionalCondition (conditionName=0x2d18c9 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [06:03:36.585] No locals. [06:03:36.585] #4 0x000000000076f4ff in ExecFetchSlotHeapTuple (slot=0x82186bed0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [06:03:36.585] No locals. [06:03:36.585] #5 0x00000000007341b7 in ExecIRDeleteTriggers (estate=estate@entry=0x8371b1100, relinfo=relinfo@entry=0x8371b16b0, slot=slot@entry=0x82186bed0) at ../src/backend/commands/trigger.c:2841 [06:03:36.585] trigger = [06:03:36.585] oldtuple = [06:03:36.585] should_free = false [06:03:36.585] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8371737b8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [06:03:36.585] trigdesc = 0x8371b18c0 [06:03:36.585] newtuple = 0x0 [06:03:36.585] i = 0 [06:03:36.585] #6 0x00000000007946d7 in ExecMergeMatched (context=0x82186bf78, resultRelInfo=0x8371b16b0, tupleid=0x0, oldtuple=0x82186bed0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [06:03:36.585] result = TM_Ok [06:03:36.585] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [06:03:36.585] relaction = 0x83727e160 [06:03:36.585] commandType = CMD_DELETE [06:03:36.585] l__state = {l = 0x83733bdf8, i = 0} [06:03:36.585] mtstate = 0x8371b14a0 [06:03:36.585] newslot = 0x0 [06:03:36.585] rslot = 0x0 [06:03:36.585] estate = 0x8371b1100 [06:03:36.585] mergeActions = [06:03:36.585] econtext = 0x83733ae98 [06:03:36.585] epqstate = 0x8371b1588 [06:03:36.585] actionStates = 0x83733bdf8 [06:03:36.585] l = [06:03:36.585] isNull = [06:03:36.585] lmerge_matched = [06:03:36.585] __error = [06:03:36.585] l__state = [06:03:36.585] result = [06:03:36.585] updateCxt = [06:03:36.585] relaction = [06:03:36.585] commandType = [06:03:36.585] __error = [06:03:36.585] resultRelationDesc = [06:03:36.585] lockmode = [06:03:36.585] inputslot = [06:03:36.585] epqslot = [06:03:36.585] was_matched = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] #7 ExecMerge (context=0x82186bf78, resultRelInfo=0x8371b16b0, tupleid=0x0, oldtuple=0x82186bed0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [06:03:36.585] matched = [06:03:36.585] rslot = 0x0 [06:03:36.585] #8 ExecModifyTable (pstate=0x8371b14a0) at ../src/backend/executor/nodeModifyTable.c:4133 [06:03:36.585] context = {mtstate = 0x8371b14a0, epqstate = 0x8371b1588, estate = 0x8371b1100, planSlot = 0x837339298, tmfd = {ctid = {ip_blkid = {bi_hi = 23664, bi_lo = 14127}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8371b16b0} [06:03:36.585] tuple_ctid = {ip_blkid = {bi_hi = 59424, bi_lo = 17073}, ip_posid = 8} [06:03:36.585] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834070118} [06:03:36.585] node = 0x8371b14a0 [06:03:36.585] estate = 0x8371b1100 [06:03:36.585] operation = CMD_MERGE [06:03:36.585] resultRelInfo = 0x8371b16b0 [06:03:36.585] subplanstate = 0x8371b2db0 [06:03:36.585] slot = [06:03:36.585] tupleid = 0x0 [06:03:36.585] oldtuple = 0x82186bed0 [06:03:36.585] oldSlot = [06:03:36.585] #9 0x000000000076176b in ExecProcNode (node=0x8371b14a0) at ../src/include/executor/executor.h:278 [06:03:36.585] No locals. [06:03:36.585] #10 ExecutePlan (estate=0x8371b1100, planstate=0x8371b14a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x8341c2710, execute_once=) at ../src/backend/executor/execMain.c:1641 [06:03:36.585] current_tuple_count = 0 [06:03:36.585] slot = [06:03:36.585] #11 standard_ExecutorRun (queryDesc=0x83407dc48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [06:03:36.585] estate = 0x8371b1100 [06:03:36.585] oldcontext = 0x8341c2400 [06:03:36.585] operation = CMD_MERGE [06:03:36.585] dest = 0x8341c2710 [06:03:36.585] sendTuples = true [06:03:36.585] #12 0x00000000009370af in ProcessQuery (plan=0x8372f5558, sourceText=, params=0x0, queryEnv=0x0, dest=0x8341c2710, qc=0x82186c178) at ../src/backend/tcop/pquery.c:160 [06:03:36.585] queryDesc = 0x83407dc48 [06:03:36.585] #13 0x000000000093664d in PortalRunMulti (portal=portal@entry=0x8340c4100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x8341c2710, altdest=0xb7dcf0 , qc=qc@entry=0x82186c178) at ../src/backend/tcop/pquery.c:1287 [06:03:36.585] pstmt = 0x8372f5558 [06:03:36.585] stmtlist_item__state = {l = 0x8372f9e10, i = 0} [06:03:36.585] active_snapshot_set = true [06:03:36.585] stmtlist_item = 0x8372f9e28 [06:03:36.585] #14 0x000000000093615c in FillPortalStore (portal=portal@entry=0x8340c4100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [06:03:36.585] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:03:36.585] treceiver = 0x8341c2710 [06:03:36.585] #15 0x0000000000935ecb in PortalRun (portal=portal@entry=0x8340c4100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8372f9e60, altdest=altdest@entry=0x8372f9e60, qc=0x82186c2b0) at ../src/backend/tcop/pquery.c:763 [06:03:36.585] _local_sigjmp_buf = {{_sjb = {9657965, 35232956672, 34922217896, 34922218128, 34922217904, 35232972800, 12316232, 12349560, 35232940927, 35232284928, 4294967984, 0}}} [06:03:36.585] _save_exception_stack = 0x82186c380 [06:03:36.585] _save_context_stack = 0x0 [06:03:36.585] _do_rethrow = false [06:03:36.585] saveTopTransactionResourceOwner = 0x834113e18 [06:03:36.585] saveTopTransactionContext = 0x8340c8000 [06:03:36.585] saveActivePortal = 0x0 [06:03:36.585] saveResourceOwner = 0x834113e18 [06:03:36.585] savePortalContext = 0x0 [06:03:36.585] saveMemoryContext = 0x8340c8000 [06:03:36.585] result = [06:03:36.585] nprocessed = [06:03:36.585] #16 0x0000000000934d92 in exec_simple_query (query_string=query_string@entry=0x834020100 "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 [06:03:36.585] cmdtaglen = 5 [06:03:36.585] snapshot_set = [06:03:36.585] per_parsetree_context = 0x0 [06:03:36.585] plantree_list = [06:03:36.585] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:03:36.585] format = 0 [06:03:36.585] parsetree = 0x8372b42a8 [06:03:36.585] commandTag = [06:03:36.585] cmdtagname = [06:03:36.585] querytree_list = [06:03:36.585] portal = 0x8340c4100 [06:03:36.585] receiver = 0x8372f9e60 [06:03:36.585] parsetree_item__state = {l = 0x8372b5b70, i = 0} [06:03:36.585] msec_str = "\000\000\000\000\b", '\000' , "\277w\346f\000\000\000\000\"i\374w\270U\243|" [06:03:36.585] dest = DestRemote [06:03:36.585] was_logged = [06:03:36.585] oldcontext = 0x8340c8000 [06:03:36.585] parsetree_list = 0x8372b5b70 [06:03:36.585] use_implicit_block = false [06:03:36.585] parsetree_item = 0x8372b5b88 [06:03:36.585] save_log_statement_stats = [06:03:36.585] #17 0x0000000000932b00 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [06:03:36.585] query_string = 0x834020100 "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"... [06:03:36.585] input_message = {data = 0x834020100 "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} [06:03:36.585] firstchar = [06:03:36.585] local_sigjmp_buf = {{_sjb = {9641878, 34922218368, 34922218328, 34922218912, 12358296, 1, 8192, 8388608, 34922169215, 0, 0, 1}}} [06:03:36.585] send_ready_for_query = false [06:03:36.585] idle_in_transaction_timeout_enabled = false [06:03:36.585] idle_session_timeout_enabled = false [06:03:36.585] #18 0x000000000092d2d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:03:36.585] bsdata = [06:03:36.585] #19 0x0000000000887457 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82186d0c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82186d000) at ../src/backend/postmaster/launch_backend.c:274 [06:03:36.585] pid = [06:03:36.585] #20 0x000000000088b818 in BackendStartup (client_sock=0x82186d000) at ../src/backend/postmaster/postmaster.c:3415 [06:03:36.585] startup_data = {canAcceptConnections = CAC_OK} [06:03:36.585] bn = 0x83402c038 [06:03:36.585] pid = [06:03:36.585] __error = [06:03:36.585] save_errno = [06:03:36.585] __error = [06:03:36.585] __error = [06:03:36.585] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [06:03:36.585] 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\036\0024\b", '\000' , "`І!\b\000\000\000h\0253*\b\000\000\000\v\000\000\000\000\000\000\000^\2373*\b", '\000' , "\240І!\b\000\000\000\004r\210\000\000\000\000\000\260І!\b", '\000' }, salen = 16}} [06:03:36.585] i = 0 [06:03:36.585] now = [06:03:36.585] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 872973784, events = 8, fd = 562482752, user_data = 0x0}, {pos = 0, events = 0, fd = -335942787, user_data = 0x51d94ace30a}, {pos = 717920160, events = 8, fd = 717991288, user_data = 0x82186cac8}, {pos = 562481984, events = 8, fd = 562481864, user_data = 0x51d94ace30a}, {pos = 717898632, events = 8, fd = 717991288, user_data = 0x82186caf8}, {pos = 562482032, events = 8, fd = 562481912, user_data = 0x82acb3194}, {pos = 576939016, events = 8, fd = 717959572, user_data = 0x82186cb60}, {pos = -1800629190, events = 1309, fd = 719781936, user_data = 0x1}, {pos = 562482064, events = 8, fd = -1800609014, user_data = 0x82ac9c858}, {pos = 717991288, events = 8, fd = 562482024, user_data = 0x82186cbe0}, {pos = 562482024, events = 8, fd = 717954316, user_data = 0x822636408}, {pos = 717954316, events = 8, fd = 562482128, user_data = 0x51d94ac943a}, {pos = 562482168, events = 8, fd = 562482616, user_data = 0x82186cbe0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3718116972, fd = 576962616, user_data = 0x800000001}, {pos = 576939016, events = 8, fd = 717898632, user_data = 0x82263b288}, {pos = 717867096, events = 8, fd = 576939016, user_data = 0x82186cc68}, {pos = 562482728, events = 8, fd = 562482256, user_data = 0x51d94acdca2}, {pos = 2700546, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 576962616, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 562482984, user_data = 0x22636408}, {pos = 562482800, events = 8, fd = 562482400, user_data = 0x1}, {pos = 562482728, events = 8, fd = 32, user_data = 0x82186ccd0}, {pos = -1800611213, events = 1309, fd = 562482672, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82263c038}, {pos = 1, events = 8, fd = 576939016, user_data = 0x82ac9c858}, {pos = 562482984, events = 8, fd = 562482800, user_data = 0x82186cce0}, {pos = 0, events = 0, fd = 576909320, user_data = 0x20}, {pos = 562482784, events = 8, fd = -1800635673, user_data = 0x82262f008}, {pos = 576910344, events = 8, fd = 576911368, user_data = 0x82262fc08}, {pos = 576925704, events = 8, fd = 576926728, user_data = 0x822633808}, {pos = 576928776, events = 8, fd = 576929800, user_data = 0x822634408}, {pos = 576931848, events = 8, fd = 576932872, user_data = 0x822635008}, {pos = 576934920, events = 8, fd = 576935944, user_data = 0x822635c08}, {pos = 576937992, events = 8, fd = 576939016, user_data = 0x822636808}, {pos = 576941064, events = 8, fd = 576942088, user_data = 0x822637408}, {pos = 576944136, events = 8, fd = 576945160, user_data = 0x822638008}, {pos = 576947208, events = 8, fd = 576948232, user_data = 0x822638c08}, {pos = 576954376, events = 8, fd = 576955400, user_data = 0x82263a808}, {pos = 576957448, events = 8, fd = 576909320, user_data = 0x293502}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82263c038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 562482984, events = 8, fd = 562482400, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 576962616, user_data = 0x1}, {pos = 576909320, events = 8, fd = 313, user_data = 0x82186cf10}, {pos = -1800636945, events = 1309, fd = 2700546, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 576962616, user_data = 0x1}, {pos = 576939016, events = 8, fd = 872480768, user_data = 0x1}, {pos = 872481172, events = 8, fd = 0, user_data = 0x82186cee0}, {pos = 708023660, events = 8, fd = 1, user_data = 0x834010000}, {pos = 562482960, events = 8, fd = 708019970, user_data = 0x82adce170 }, {pos = 12283328, events = 0, fd = 719118704, user_data = 0x822636408}, {pos = 562483184, events = 8, fd = -1800637474, user_data = 0x83402e800}, {pos = 1, events = 0, fd = -1800637858, user_data = 0x82262f008}, {pos = 562482968, events = 8, fd = 562483184, user_data = 0x1c20}, {pos = 872554176, events = 8, fd = -1800558192, user_data = 0x0}, {pos = 562430847, events = 8, fd = 8092439, user_data = 0x82186cfa0}, {pos = 707982352, events = 8, fd = 719781936, user_data = 0x82ae72310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82186cfd0}, {pos = 708025245, events = 8, fd = 872480768, user_data = 0x17b9}, {pos = 562483248, events = 8, fd = 707991802, user_data = 0x0}, {pos = 0, events = 0, fd = -335942787, user_data = 0x0}} [06:03:36.585] last_touch_time = 1726379955 [06:03:36.585] last_lockfile_recheck_time = 1726379955 [06:03:36.585] nevents = 1 [06:03:36.585] #22 0x0000000000889635 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82186d610) at ../src/backend/postmaster/postmaster.c:1346 [06:03:36.585] userDoption = [06:03:36.585] listen_addr_saved = [06:03:36.585] output_config_variable = [06:03:36.585] opt = [06:03:36.585] status = [06:03:36.585] #23 0x00000000007c47fc in main (argc=4, argv=0x82186d610) at ../src/backend/main/main.c:197 [06:03:36.585] do_check_root = [06:03:36.597] [06:03:36.597] [06:03:36.597] [06:03:36.666] dumping /tmp/cores/postgres.14323.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:03:36.793] [New LWP 101688] [06:03:36.863] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [06:03:36.863] Program terminated with signal SIGABRT, Aborted. [06:03:36.863] Sent by thr_kill() from pid 14323 and user 1003. [06:03:36.863] #0 0x000000082bbbb41a in thr_kill () from /lib/libc.so.7 [06:03:37.521] [06:03:37.521] Thread 1 (LWP 101688): [06:03:37.521] #0 0x000000082bbbb41a in thr_kill () from /lib/libc.so.7 [06:03:37.521] No symbol table info available. [06:03:37.521] #1 0x000000082bb34e64 in raise () from /lib/libc.so.7 [06:03:37.521] No symbol table info available. [06:03:37.521] #2 0x000000082bbe56f9 in abort () from /lib/libc.so.7 [06:03:37.521] No symbol table info available. [06:03:37.521] #3 0x0000000000a8c0e5 in ExceptionalCondition (conditionName=0x2d18c9 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [06:03:37.521] No locals. [06:03:37.521] #4 0x000000000076f4ff in ExecFetchSlotHeapTuple (slot=0x820bd6a30, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [06:03:37.521] No locals. [06:03:37.521] #5 0x00000000007341b7 in ExecIRDeleteTriggers (estate=estate@entry=0x834d58100, relinfo=relinfo@entry=0x834d586b0, slot=slot@entry=0x820bd6a30) at ../src/backend/commands/trigger.c:2841 [06:03:37.521] trigger = [06:03:37.521] oldtuple = [06:03:37.521] should_free = false [06:03:37.521] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8369c2e90, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [06:03:37.521] trigdesc = 0x834d588c0 [06:03:37.521] newtuple = 0x0 [06:03:37.521] i = 0 [06:03:37.521] #6 0x00000000007946d7 in ExecMergeMatched (context=0x820bd6ad8, resultRelInfo=0x834d586b0, tupleid=0x0, oldtuple=0x820bd6a30, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [06:03:37.521] result = TM_Ok [06:03:37.521] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [06:03:37.521] relaction = 0x836a07d60 [06:03:37.521] commandType = CMD_DELETE [06:03:37.521] l__state = {l = 0x836b8a1f8, i = 0} [06:03:37.521] mtstate = 0x834d584a0 [06:03:37.521] newslot = 0x0 [06:03:37.521] rslot = 0x0 [06:03:37.521] estate = 0x834d58100 [06:03:37.521] mergeActions = [06:03:37.521] econtext = 0x836b89298 [06:03:37.521] epqstate = 0x834d58588 [06:03:37.521] actionStates = 0x836b8a1f8 [06:03:37.521] l = [06:03:37.521] isNull = [06:03:37.521] lmerge_matched = [06:03:37.521] __error = [06:03:37.521] l__state = [06:03:37.521] result = [06:03:37.521] updateCxt = [06:03:37.521] relaction = [06:03:37.521] commandType = [06:03:37.521] __error = [06:03:37.521] resultRelationDesc = [06:03:37.521] lockmode = [06:03:37.521] inputslot = [06:03:37.521] epqslot = [06:03:37.521] was_matched = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] #7 ExecMerge (context=0x820bd6ad8, resultRelInfo=0x834d586b0, tupleid=0x0, oldtuple=0x820bd6a30, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [06:03:37.521] matched = [06:03:37.521] rslot = 0x0 [06:03:37.521] #8 ExecModifyTable (pstate=0x834d584a0) at ../src/backend/executor/nodeModifyTable.c:4133 [06:03:37.521] context = {mtstate = 0x834d584a0, epqstate = 0x834d58588, estate = 0x834d58100, planSlot = 0x836b87698, tmfd = {ctid = {ip_blkid = {bi_hi = 32142, bi_lo = 11195}, ip_posid = 8}, xmax = 121, cmax = 0, traversed = 80}, cpUpdateReturningSlot = 0x77f74a497101f55c} [06:03:37.521] tuple_ctid = {ip_blkid = {bi_hi = 27392, bi_lo = 8381}, ip_posid = 8} [06:03:37.521] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x834de8118} [06:03:37.521] node = 0x834d584a0 [06:03:37.521] estate = 0x834d58100 [06:03:37.521] operation = CMD_MERGE [06:03:37.521] resultRelInfo = 0x834d586b0 [06:03:37.521] subplanstate = 0x834d59db0 [06:03:37.521] slot = [06:03:37.521] tupleid = 0x0 [06:03:37.521] oldtuple = 0x820bd6a30 [06:03:37.521] oldSlot = [06:03:37.521] #9 0x000000000076176b in ExecProcNode (node=0x834d584a0) at ../src/include/executor/executor.h:278 [06:03:37.521] No locals. [06:03:37.521] #10 ExecutePlan (estate=0x834d58100, planstate=0x834d584a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x834dcbb10, execute_once=) at ../src/backend/executor/execMain.c:1641 [06:03:37.521] current_tuple_count = 0 [06:03:37.521] slot = [06:03:37.521] #11 standard_ExecutorRun (queryDesc=0x834dea448, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [06:03:37.521] estate = 0x834d58100 [06:03:37.521] oldcontext = 0x834dcb800 [06:03:37.521] operation = CMD_MERGE [06:03:37.521] dest = 0x834dcbb10 [06:03:37.521] sendTuples = true [06:03:37.521] #12 0x0000000835f88961 in pgss_ExecutorRun (queryDesc=0x834dea448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1024 [06:03:37.521] _local_sigjmp_buf = {{_sjb = {35265218865, 1, 34909023240, 34909023408, 12349560, 34909023248, 1, 35246744648, 34908996479, 7815873, 35246145536, 34359738368}}} [06:03:37.521] _save_exception_stack = 0x820bd6dc0 [06:03:37.521] _save_context_stack = 0x0 [06:03:37.521] _do_rethrow = false [06:03:37.521] #13 0x00000000009370af in ProcessQuery (plan=0x836b3e040, sourceText=, params=0x0, queryEnv=0x0, dest=0x834dcbb10, qc=0x820bd6d88) at ../src/backend/tcop/pquery.c:160 [06:03:37.521] queryDesc = 0x834dea448 [06:03:37.521] #14 0x000000000093664d in PortalRunMulti (portal=portal@entry=0x834cc0100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x834dcbb10, altdest=0xb7dcf0 , qc=qc@entry=0x820bd6d88) at ../src/backend/tcop/pquery.c:1287 [06:03:37.521] pstmt = 0x836b3e040 [06:03:37.521] stmtlist_item__state = {l = 0x836b428f8, i = 0} [06:03:37.521] active_snapshot_set = true [06:03:37.521] stmtlist_item = 0x836b42910 [06:03:37.521] #15 0x000000000093615c in FillPortalStore (portal=portal@entry=0x834cc0100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [06:03:37.521] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:03:37.521] treceiver = 0x834dcbb10 [06:03:37.521] #16 0x0000000000935ecb in PortalRun (portal=portal@entry=0x834cc0100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x836b42948, altdest=altdest@entry=0x836b42948, qc=0x820bd6ec0) at ../src/backend/tcop/pquery.c:763 [06:03:37.521] _local_sigjmp_buf = {{_sjb = {9657965, 35245523200, 34909023672, 34909023904, 34909023680, 35245617152, 12316232, 12349560, 35245523839, 35244843264, 4294967984, 0}}} [06:03:37.521] _save_exception_stack = 0x820bd6f90 [06:03:37.521] _save_context_stack = 0x0 [06:03:37.521] _do_rethrow = false [06:03:37.521] saveTopTransactionResourceOwner = 0x834d0e598 [06:03:37.521] saveTopTransactionContext = 0x834cd7000 [06:03:37.521] saveActivePortal = 0x0 [06:03:37.521] saveResourceOwner = 0x834d0e598 [06:03:37.521] savePortalContext = 0x0 [06:03:37.521] saveMemoryContext = 0x834cd7000 [06:03:37.521] result = [06:03:37.521] nprocessed = [06:03:37.521] #17 0x0000000000934d92 in exec_simple_query (query_string=query_string@entry=0x834c1a100 "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 [06:03:37.521] cmdtaglen = 5 [06:03:37.521] snapshot_set = [06:03:37.521] per_parsetree_context = 0x0 [06:03:37.521] plantree_list = [06:03:37.521] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:03:37.521] format = 0 [06:03:37.521] parsetree = 0x836b07128 [06:03:37.521] commandTag = [06:03:37.521] cmdtagname = [06:03:37.521] querytree_list = [06:03:37.521] portal = 0x834cc0100 [06:03:37.521] receiver = 0x836b42948 [06:03:37.521] parsetree_item__state = {l = 0x836b089f0, i = 0} [06:03:37.521] msec_str = "\000\000\000\000\b", '\000' , "\340w\346f\000\000\000\000\036֔\276", [06:03:37.521] dest = DestRemote [06:03:37.521] was_logged = [06:03:37.521] oldcontext = 0x834cd7000 [06:03:37.521] parsetree_list = 0x836b089f0 [06:03:37.521] use_implicit_block = false [06:03:37.521] parsetree_item = 0x836b08a08 [06:03:37.521] save_log_statement_stats = [06:03:37.521] #18 0x0000000000932b00 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [06:03:37.521] query_string = 0x834c1a100 "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"... [06:03:37.521] input_message = {data = 0x834c1a100 "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} [06:03:37.521] firstchar = [06:03:37.521] local_sigjmp_buf = {{_sjb = {9641878, 34909024144, 34909024104, 34909024688, 12358296, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [06:03:37.521] send_ready_for_query = false [06:03:37.521] idle_in_transaction_timeout_enabled = false [06:03:37.521] idle_session_timeout_enabled = false [06:03:37.521] #19 0x000000000092d2d9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:03:37.521] bsdata = [06:03:37.521] #20 0x0000000000887457 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820bd7cd4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820bd7c10) at ../src/backend/postmaster/launch_backend.c:274 [06:03:37.521] pid = [06:03:37.521] #21 0x000000000088b818 in BackendStartup (client_sock=0x820bd7c10) at ../src/backend/postmaster/postmaster.c:3415 [06:03:37.521] startup_data = {canAcceptConnections = CAC_OK} [06:03:37.521] bn = 0x834c262b8 [06:03:37.521] pid = [06:03:37.521] __error = [06:03:37.521] save_errno = [06:03:37.521] __error = [06:03:37.521] __error = [06:03:37.521] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [06:03:37.521] 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 = " \254\3014\b", '\000' , "p|\275 \b\000\000\000h\345A*\b\000\000\000\v\000\000\000\000\000\000\000^oB*\b", '\000' , "\260|\275 \b\000\000\000\004r\210\000\000\000\000\000\300|\275 \b", '\000' }, salen = 16}} [06:03:37.521] i = 0 [06:03:37.521] now = [06:03:37.521] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 733346946, events = 8, fd = 0, user_data = 0x820bd7bc0}, {pos = 885532120, events = 8, fd = 549288528, user_data = 0x0}, {pos = -86621430, events = 2724, fd = 732514208, user_data = 0x82baa5d78}, {pos = 549287624, events = 8, fd = 549287744, user_data = 0x820bd76c8}, {pos = -86621430, events = 2724, fd = 732492680, user_data = 0x82baa5d78}, {pos = 549287672, events = 8, fd = 549287792, user_data = 0x820bd76f8}, {pos = 732553620, events = 8, fd = 561398792, user_data = 0x82ba9e194}, {pos = 549287776, events = 8, fd = -86641606, user_data = 0x820bd7700}, {pos = 708953104, events = 8, fd = 734375984, user_data = 0xaa4fad6430a}, {pos = 732461144, events = 8, fd = 732585336, user_data = 0x820bd7768}, {pos = 549287904, events = 8, fd = 549287784, user_data = 0x82ba9cd0c}, {pos = 561398792, events = 8, fd = 732548364, user_data = 0x820bd77d0}, {pos = -86641606, events = 2724, fd = 549287928, user_data = 0x820bd79c8}, {pos = 549287904, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x82176a038}, {pos = 1, events = 2012695113, fd = 561398792, user_data = 0x82ba8f388}, {pos = 561420232, events = 8, fd = 0, user_data = 0x0}, {pos = 549288040, events = 8, fd = 549288504, user_data = 0x820bd7850}, {pos = -86623070, events = 2724, fd = 2700546, user_data = 0x6d68b}, {pos = 2090263927, events = 2012695113, fd = 561422392, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820bd7b38}, {pos = 561398792, events = 3, fd = 549288576, user_data = 0x821769828}, {pos = 656, events = 0, fd = 549288504, user_data = 0x820bd7868}, {pos = 549288144, events = 8, fd = -86623461, user_data = 0x820bd7a00}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 561422392, events = 8, fd = 1, user_data = 0x821764408}, {pos = 732461144, events = 8, fd = 549288760, user_data = 0x820bd7a80}, {pos = 549288160, events = 8, fd = 0, user_data = 0x82175d008}, {pos = 33, events = 0, fd = 549288560, user_data = 0xaa4fad5dae7}, {pos = 561369096, events = 8, fd = 561370120, user_data = 0x82175d808}, {pos = 561372168, events = 8, fd = 561385480, user_data = 0x821761408}, {pos = 561387528, events = 8, fd = 561388552, user_data = 0x821762008}, {pos = 561390600, events = 8, fd = 561391624, user_data = 0x821762c08}, {pos = 561393672, events = 8, fd = 561394696, user_data = 0x821763808}, {pos = 561396744, events = 8, fd = 561397768, user_data = 0x821764408}, {pos = 561399816, events = 8, fd = 561400840, user_data = 0x821765008}, {pos = 561402888, events = 8, fd = 561403912, user_data = 0x821765c08}, {pos = 561405960, events = 8, fd = 561406984, user_data = 0x821766808}, {pos = 561409032, events = 8, fd = 561414152, user_data = 0x821768408}, {pos = 561416200, events = 8, fd = 561417224, user_data = 0x82176b408}, {pos = 66834000, events = 0, fd = 561369096, user_data = 0x293502}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82176a038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 549288760, events = 8, fd = 549288160, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 561422392, user_data = 0x1}, {pos = 561369096, events = 8, fd = 313, user_data = 0x820bd7b20}, {pos = -86649361, events = 2724, fd = 2700546, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 561422392, user_data = 0x1}, {pos = 561398792, events = 8, fd = 885039104, user_data = 0x1}, {pos = 885039508, events = 8, fd = 0, user_data = 0x820bd7af0}, {pos = 708994412, events = 8, fd = 1, user_data = 0x834c0a000}, {pos = 549288736, events = 8, fd = 708990722, user_data = 0x82bbb9170 }, {pos = 12283328, events = 0, fd = 733712752, user_data = 0x821764408}, {pos = 549288960, events = 8, fd = -86649890, user_data = 0x834c28800}, {pos = 1, events = 0, fd = -86650274, user_data = 0x82175d008}, {pos = 549288744, events = 8, fd = 549288960, user_data = 0x1c20}, {pos = 885107744, events = 8, fd = -86570608, user_data = 0x0}, {pos = 549258111, events = 8, fd = 8092439, user_data = 0x820bd7bb0}, {pos = 708953104, events = 8, fd = 734375984, user_data = 0x82bc5d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820bd7be0}, {pos = 708995997, events = 8, fd = 885039104, user_data = 0x3054}, {pos = 549289024, events = 8, fd = 708962554, user_data = 0x0}, {pos = 0, events = 0, fd = 1895953756, user_data = 0x0}} [06:03:37.521] last_touch_time = 1726379987 [06:03:37.521] last_lockfile_recheck_time = 1726379987 [06:03:37.521] nevents = 1 [06:03:37.521] #23 0x0000000000889635 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820bd8228) at ../src/backend/postmaster/postmaster.c:1346 [06:03:37.521] userDoption = [06:03:37.521] listen_addr_saved = [06:03:37.521] output_config_variable = [06:03:37.521] opt = [06:03:37.521] status = [06:03:37.521] #24 0x00000000007c47fc in main (argc=4, argv=0x820bd8228) at ../src/backend/main/main.c:197 [06:03:37.521] do_check_root =