[09:40:28.834] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [09:40:29.191] dumping /tmp/cores/postgres.7906.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:40:29.318] [New LWP 100140] [09:40:29.406] Core was generated by `postgres: postgres regression [local] MERGE'. [09:40:29.406] Program terminated with signal SIGABRT, Aborted. [09:40:29.406] Sent by thr_kill() from pid 7906 and user 1003. [09:40:29.406] #0 0x000000082ced941a in thr_kill () from /lib/libc.so.7 [09:40:30.065] [09:40:30.065] Thread 1 (LWP 100140): [09:40:30.065] #0 0x000000082ced941a in thr_kill () from /lib/libc.so.7 [09:40:30.065] No symbol table info available. [09:40:30.065] #1 0x000000082ce52e64 in raise () from /lib/libc.so.7 [09:40:30.065] No symbol table info available. [09:40:30.065] #2 0x000000082cf036f9 in abort () from /lib/libc.so.7 [09:40:30.065] No symbol table info available. [09:40:30.065] #3 0x0000000000a8c0a5 in ExceptionalCondition (conditionName=0x2d18c9 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [09:40:30.065] No locals. [09:40:30.065] #4 0x000000000076f4ef in ExecFetchSlotHeapTuple (slot=0x82171e590, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [09:40:30.065] No locals. [09:40:30.065] #5 0x00000000007341a7 in ExecIRDeleteTriggers (estate=estate@entry=0x837f85100, relinfo=relinfo@entry=0x837f856b0, slot=slot@entry=0x82171e590) at ../src/backend/commands/trigger.c:2841 [09:40:30.065] trigger = [09:40:30.065] oldtuple = [09:40:30.065] should_free = false [09:40:30.065] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x845923780, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [09:40:30.065] trigdesc = 0x837f858c0 [09:40:30.065] newtuple = 0x0 [09:40:30.065] i = 0 [09:40:30.065] #6 0x00000000007946c7 in ExecMergeMatched (context=0x82171e638, resultRelInfo=0x837f856b0, tupleid=0x0, oldtuple=0x82171e590, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [09:40:30.065] result = TM_Ok [09:40:30.065] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [09:40:30.065] relaction = 0x845a05d60 [09:40:30.065] commandType = CMD_DELETE [09:40:30.065] l__state = {l = 0x845acb778, i = 0} [09:40:30.065] mtstate = 0x837f854a0 [09:40:30.065] newslot = 0x0 [09:40:30.065] rslot = 0x0 [09:40:30.065] estate = 0x837f85100 [09:40:30.065] mergeActions = [09:40:30.065] econtext = 0x845aca818 [09:40:30.065] epqstate = 0x837f85588 [09:40:30.065] actionStates = 0x845acb778 [09:40:30.065] l = [09:40:30.065] isNull = [09:40:30.065] lmerge_matched = [09:40:30.065] __error = [09:40:30.065] l__state = [09:40:30.065] result = [09:40:30.065] updateCxt = [09:40:30.065] relaction = [09:40:30.065] commandType = [09:40:30.065] __error = [09:40:30.065] resultRelationDesc = [09:40:30.065] lockmode = [09:40:30.065] inputslot = [09:40:30.065] epqslot = [09:40:30.065] was_matched = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] #7 ExecMerge (context=0x82171e638, resultRelInfo=0x837f856b0, tupleid=0x0, oldtuple=0x82171e590, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [09:40:30.065] matched = [09:40:30.065] rslot = 0x0 [09:40:30.065] #8 ExecModifyTable (pstate=0x837f854a0) at ../src/backend/executor/nodeModifyTable.c:4133 [09:40:30.065] context = {mtstate = 0x837f854a0, epqstate = 0x837f85588, estate = 0x837f85100, planSlot = 0x845ac8c18, tmfd = {ctid = {ip_blkid = {bi_hi = 34160, bi_lo = 17832}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x837f856b0} [09:40:30.065] tuple_ctid = {ip_blkid = {bi_hi = 25072, bi_lo = 18778}, ip_posid = 8} [09:40:30.065] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8458e5118} [09:40:30.065] node = 0x837f854a0 [09:40:30.065] estate = 0x837f85100 [09:40:30.065] operation = CMD_MERGE [09:40:30.065] resultRelInfo = 0x837f856b0 [09:40:30.065] subplanstate = 0x837f86db0 [09:40:30.065] slot = [09:40:30.065] tupleid = 0x0 [09:40:30.065] oldtuple = 0x82171e590 [09:40:30.065] oldSlot = [09:40:30.065] #9 0x000000000076175b in ExecProcNode (node=0x837f854a0) at ../src/include/executor/executor.h:278 [09:40:30.065] No locals. [09:40:30.065] #10 ExecutePlan (estate=0x837f85100, planstate=0x837f854a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x837f34f10, execute_once=) at ../src/backend/executor/execMain.c:1641 [09:40:30.065] current_tuple_count = 0 [09:40:30.065] slot = [09:40:30.065] #11 standard_ExecutorRun (queryDesc=0x838008448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [09:40:30.065] estate = 0x837f85100 [09:40:30.065] oldcontext = 0x837f34c00 [09:40:30.065] operation = CMD_MERGE [09:40:30.065] dest = 0x837f34f10 [09:40:30.065] sendTuples = true [09:40:30.065] #12 0x000000000093709f in ProcessQuery (plan=0x845a87e58, sourceText=, params=0x0, queryEnv=0x0, dest=0x837f34f10, qc=0x82171e838) at ../src/backend/tcop/pquery.c:160 [09:40:30.065] queryDesc = 0x838008448 [09:40:30.065] #13 0x000000000093663d in PortalRunMulti (portal=portal@entry=0x837f00100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x837f34f10, altdest=0xb7dcb0 , qc=qc@entry=0x82171e838) at ../src/backend/tcop/pquery.c:1287 [09:40:30.065] pstmt = 0x845a87e58 [09:40:30.065] stmtlist_item__state = {l = 0x845a8c710, i = 0} [09:40:30.065] active_snapshot_set = true [09:40:30.065] stmtlist_item = 0x845a8c728 [09:40:30.065] #14 0x000000000093614c in FillPortalStore (portal=portal@entry=0x837f00100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [09:40:30.065] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:40:30.065] treceiver = 0x837f34f10 [09:40:30.065] #15 0x0000000000935ebb in PortalRun (portal=portal@entry=0x837f00100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x845a8c760, altdest=altdest@entry=0x845a8c760, qc=0x82171e970) at ../src/backend/tcop/pquery.c:763 [09:40:30.065] _local_sigjmp_buf = {{_sjb = {9657949, 35298214144, 34920851560, 34920851792, 34920851568, 35298234368, 12316168, 12349496, 35298214783, 35297341696, 4294967984, 0}}} [09:40:30.065] _save_exception_stack = 0x82171ea40 [09:40:30.065] _save_context_stack = 0x0 [09:40:30.065] _do_rethrow = false [09:40:30.065] saveTopTransactionResourceOwner = 0x837f12898 [09:40:30.065] saveTopTransactionContext = 0x837f05000 [09:40:30.065] saveActivePortal = 0x0 [09:40:30.065] saveResourceOwner = 0x837f12898 [09:40:30.065] savePortalContext = 0x0 [09:40:30.065] saveMemoryContext = 0x837f05000 [09:40:30.065] result = [09:40:30.065] nprocessed = [09:40:30.065] #16 0x0000000000934d82 in exec_simple_query (query_string=query_string@entry=0x837e2b100 "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 [09:40:30.065] cmdtaglen = 5 [09:40:30.065] snapshot_set = [09:40:30.065] per_parsetree_context = 0x0 [09:40:30.065] plantree_list = [09:40:30.065] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:40:30.065] format = 0 [09:40:30.065] parsetree = 0x845a446e8 [09:40:30.065] commandTag = [09:40:30.065] cmdtagname = [09:40:30.065] querytree_list = [09:40:30.065] portal = 0x837f00100 [09:40:30.065] receiver = 0x845a8c760 [09:40:30.065] parsetree_item__state = {l = 0x845a45fb0, i = 0} [09:40:30.065] msec_str = "\000\000\000\000\b", '\000' , "\223\a\344f\000\000\000\000x\231\344\373\322", [09:40:30.065] dest = DestRemote [09:40:30.065] was_logged = [09:40:30.065] oldcontext = 0x837f05000 [09:40:30.065] parsetree_list = 0x845a45fb0 [09:40:30.065] use_implicit_block = false [09:40:30.065] parsetree_item = 0x845a45fc8 [09:40:30.065] save_log_statement_stats = [09:40:30.065] #17 0x0000000000932af0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [09:40:30.065] query_string = 0x837e2b100 "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"... [09:40:30.065] input_message = {data = 0x837e2b100 "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} [09:40:30.065] firstchar = [09:40:30.065] local_sigjmp_buf = {{_sjb = {9641862, 34920852032, 34920851992, 34920852576, 12358232, 1, 8192, 8388608, 34920792959, 0, 0, 1}}} [09:40:30.065] send_ready_for_query = false [09:40:30.065] idle_in_transaction_timeout_enabled = false [09:40:30.065] idle_session_timeout_enabled = false [09:40:30.065] #18 0x000000000092d2c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:40:30.065] bsdata = [09:40:30.065] #19 0x0000000000887447 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82171f784 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82171f6c0) at ../src/backend/postmaster/launch_backend.c:274 [09:40:30.065] pid = [09:40:30.065] #20 0x000000000088b808 in BackendStartup (client_sock=0x82171f6c0) at ../src/backend/postmaster/postmaster.c:3415 [09:40:30.065] startup_data = {canAcceptConnections = CAC_OK} [09:40:30.065] bn = 0x837e37308 [09:40:30.065] pid = [09:40:30.065] __error = [09:40:30.065] save_errno = [09:40:30.065] __error = [09:40:30.065] __error = [09:40:30.065] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [09:40:30.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\317\3427\b", '\000' , " \367q!\b\000\000\000h\005\001,\b\000\000\000\v\000\000\000\000\000\000\000^\217\001,\b", '\000' , "`\367q!\b\000\000\000\364q\210\000\000\000\000\000p\367q!\b", '\000' }, salen = 16}} [09:40:30.065] i = 0 [09:40:30.065] now = [09:40:30.065] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 753392770, events = 8, fd = 0, user_data = 0x82171f670}, {pos = 938001880, events = 8, fd = 561116416, user_data = 0x0}, {pos = 0, events = 0, fd = -2002657709, user_data = 0x24f5cefff30a}, {pos = 752560032, events = 8, fd = 752631160, user_data = 0x82171f188}, {pos = 561115648, events = 8, fd = 561115528, user_data = 0x24f5cefff30a}, {pos = 752538504, events = 8, fd = 752631160, user_data = 0x82171f1b8}, {pos = 561115696, events = 8, fd = 561115576, user_data = 0x82cdbc194}, {pos = 569480200, events = 8, fd = 752599444, user_data = 0x82171f220}, {pos = -822107078, events = 9461, fd = 754421808, user_data = 0x1}, {pos = 561115728, events = 8, fd = -822086902, user_data = 0x82cda5858}, {pos = 752631160, events = 8, fd = 561115688, user_data = 0x82171f2a0}, {pos = 561115688, events = 8, fd = 752594188, user_data = 0x821f19408}, {pos = 752594188, events = 8, fd = 561115792, user_data = 0x24f5ceffa43a}, {pos = 561115832, events = 8, fd = 561116280, user_data = 0x82171f2a0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2389092653, fd = 569503800, user_data = 0x800000001}, {pos = 569480200, events = 8, fd = 752538504, user_data = 0x821f1e288}, {pos = 752506968, events = 8, fd = 569480200, user_data = 0x82171f328}, {pos = 561116392, events = 8, fd = 561115920, user_data = 0x24f5ceffeca2}, {pos = 2700546, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 569503800, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 561116648, user_data = 0x21f19408}, {pos = 561116464, events = 8, fd = 561116064, user_data = 0x1}, {pos = 561116392, events = 8, fd = 32, user_data = 0x82171f390}, {pos = -822089101, events = 9461, fd = 561116336, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821f1f038}, {pos = 1, events = 8, fd = 569480200, user_data = 0x82cda5858}, {pos = 561116648, events = 8, fd = 561116464, user_data = 0x82171f3a0}, {pos = 0, events = 0, fd = 569450504, user_data = 0x20}, {pos = 561116448, events = 8, fd = -822113561, user_data = 0x821f12008}, {pos = 569451528, events = 8, fd = 569452552, user_data = 0x821f12c08}, {pos = 569466888, events = 8, fd = 569467912, user_data = 0x821f16808}, {pos = 569469960, events = 8, fd = 569470984, user_data = 0x821f17408}, {pos = 569473032, events = 8, fd = 569474056, user_data = 0x821f18008}, {pos = 569476104, events = 8, fd = 569477128, user_data = 0x821f18c08}, {pos = 569479176, events = 8, fd = 569480200, user_data = 0x821f19808}, {pos = 569482248, events = 8, fd = 569483272, user_data = 0x821f1a408}, {pos = 569485320, events = 8, fd = 569486344, user_data = 0x821f1b008}, {pos = 569488392, events = 8, fd = 569489416, user_data = 0x821f1bc08}, {pos = 569495560, events = 8, fd = 569496584, user_data = 0x821f1d808}, {pos = 569498632, events = 8, fd = 569450504, user_data = 0x293502}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821f1f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 561116648, events = 8, fd = 561116064, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 569503800, user_data = 0x1}, {pos = 569450504, events = 8, fd = 313, user_data = 0x82171f5d0}, {pos = -822114833, events = 9461, fd = 2700546, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 569503800, user_data = 0x1}, {pos = 569480200, events = 8, fd = 937537536, user_data = 0x1}, {pos = 937537940, events = 8, fd = 0, user_data = 0x82171f5a0}, {pos = 738297196, events = 8, fd = 1, user_data = 0x837e1b000}, {pos = 561116624, events = 8, fd = 738293506, user_data = 0x82ced7170 }, {pos = 12283264, events = 0, fd = 753758576, user_data = 0x821f19408}, {pos = 561116848, events = 8, fd = -822115362, user_data = 0x837e39800}, {pos = 1, events = 0, fd = -822115746, user_data = 0x821f12008}, {pos = 561116632, events = 8, fd = 561116848, user_data = 0x1c20}, {pos = 937611008, events = 8, fd = -822036080, user_data = 0x0}, {pos = 561054591, events = 8, fd = 8092423, user_data = 0x82171f660}, {pos = 738255888, events = 8, fd = 754421808, user_data = 0x82cf7b310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82171f690}, {pos = 738298781, events = 8, fd = 937537536, user_data = 0x1756}, {pos = 561116912, events = 8, fd = 738265338, user_data = 0x0}, {pos = 0, events = 0, fd = -2002657709, user_data = 0x0}} [09:40:30.065] last_touch_time = 1726220169 [09:40:30.065] last_lockfile_recheck_time = 1726220169 [09:40:30.065] nevents = 1 [09:40:30.065] #22 0x0000000000889625 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82171fcd8) at ../src/backend/postmaster/postmaster.c:1346 [09:40:30.065] userDoption = [09:40:30.065] listen_addr_saved = [09:40:30.065] output_config_variable = [09:40:30.065] opt = [09:40:30.065] status = [09:40:30.065] #23 0x00000000007c47ec in main (argc=8, argv=0x82171fcd8) at ../src/backend/main/main.c:197 [09:40:30.065] do_check_root = [09:40:30.078] [09:40:30.078] [09:40:30.078] [09:40:30.142] dumping /tmp/cores/postgres.8133.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:40:30.274] [New LWP 101686] [09:40:30.337] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [09:40:30.337] Program terminated with signal SIGABRT, Aborted. [09:40:30.337] Sent by thr_kill() from pid 8133 and user 1003. [09:40:30.337] #0 0x000000082ba8341a in thr_kill () from /lib/libc.so.7 [09:40:30.957] [09:40:30.957] Thread 1 (LWP 101686): [09:40:30.957] #0 0x000000082ba8341a in thr_kill () from /lib/libc.so.7 [09:40:30.957] No symbol table info available. [09:40:30.957] #1 0x000000082b9fce64 in raise () from /lib/libc.so.7 [09:40:30.957] No symbol table info available. [09:40:30.957] #2 0x000000082baad6f9 in abort () from /lib/libc.so.7 [09:40:30.957] No symbol table info available. [09:40:30.957] #3 0x0000000000a8c0a5 in ExceptionalCondition (conditionName=0x2d18c9 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [09:40:30.957] No locals. [09:40:30.957] #4 0x000000000076f4ef in ExecFetchSlotHeapTuple (slot=0x820ff5f60, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [09:40:30.957] No locals. [09:40:30.957] #5 0x00000000007341a7 in ExecIRDeleteTriggers (estate=estate@entry=0x837081100, relinfo=relinfo@entry=0x8370816b0, slot=slot@entry=0x820ff5f60) at ../src/backend/commands/trigger.c:2841 [09:40:30.957] trigger = [09:40:30.957] oldtuple = [09:40:30.957] should_free = false [09:40:30.957] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8399a1ab0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [09:40:30.957] trigdesc = 0x8370818c0 [09:40:30.957] newtuple = 0x0 [09:40:30.957] i = 0 [09:40:30.957] #6 0x00000000007946c7 in ExecMergeMatched (context=0x820ff6008, resultRelInfo=0x8370816b0, tupleid=0x0, oldtuple=0x820ff5f60, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [09:40:30.957] result = TM_Ok [09:40:30.957] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [09:40:30.957] relaction = 0x839a792a0 [09:40:30.957] commandType = CMD_DELETE [09:40:30.957] l__state = {l = 0x839b3aff8, i = 0} [09:40:30.957] mtstate = 0x8370814a0 [09:40:30.957] newslot = 0x0 [09:40:30.957] rslot = 0x0 [09:40:30.957] estate = 0x837081100 [09:40:30.957] mergeActions = [09:40:30.957] econtext = 0x839b3a098 [09:40:30.957] epqstate = 0x837081588 [09:40:30.957] actionStates = 0x839b3aff8 [09:40:30.957] l = [09:40:30.957] isNull = [09:40:30.957] lmerge_matched = [09:40:30.957] __error = [09:40:30.957] l__state = [09:40:30.957] result = [09:40:30.957] updateCxt = [09:40:30.957] relaction = [09:40:30.957] commandType = [09:40:30.957] __error = [09:40:30.957] resultRelationDesc = [09:40:30.957] lockmode = [09:40:30.957] inputslot = [09:40:30.957] epqslot = [09:40:30.957] was_matched = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] #7 ExecMerge (context=0x820ff6008, resultRelInfo=0x8370816b0, tupleid=0x0, oldtuple=0x820ff5f60, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [09:40:30.957] matched = [09:40:30.957] rslot = 0x0 [09:40:30.957] #8 ExecModifyTable (pstate=0x8370814a0) at ../src/backend/executor/nodeModifyTable.c:4133 [09:40:30.957] context = {mtstate = 0x8370814a0, epqstate = 0x837081588, estate = 0x837081100, planSlot = 0x839b38498, tmfd = {ctid = {ip_blkid = {bi_hi = 49264, bi_lo = 14767}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8370816b0} [09:40:30.957] tuple_ctid = {ip_blkid = {bi_hi = 20192, bi_lo = 17715}, ip_posid = 8} [09:40:30.957] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x837066118} [09:40:30.957] node = 0x8370814a0 [09:40:30.957] estate = 0x837081100 [09:40:30.957] operation = CMD_MERGE [09:40:30.957] resultRelInfo = 0x8370816b0 [09:40:30.957] subplanstate = 0x837082db0 [09:40:30.957] slot = [09:40:30.957] tupleid = 0x0 [09:40:30.957] oldtuple = 0x820ff5f60 [09:40:30.957] oldSlot = [09:40:30.957] #9 0x000000000076175b in ExecProcNode (node=0x8370814a0) at ../src/include/executor/executor.h:278 [09:40:30.957] No locals. [09:40:30.957] #10 ExecutePlan (estate=0x837081100, planstate=0x8370814a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x836f1df10, execute_once=) at ../src/backend/executor/execMain.c:1641 [09:40:30.957] current_tuple_count = 0 [09:40:30.957] slot = [09:40:30.957] #11 standard_ExecutorRun (queryDesc=0x836f25c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [09:40:30.957] estate = 0x837081100 [09:40:30.957] oldcontext = 0x836f1dc00 [09:40:30.957] operation = CMD_MERGE [09:40:30.957] dest = 0x836f1df10 [09:40:30.957] sendTuples = true [09:40:30.957] #12 0x000000000093709f in ProcessQuery (plan=0x839afb958, sourceText=, params=0x0, queryEnv=0x0, dest=0x836f1df10, qc=0x820ff6208) at ../src/backend/tcop/pquery.c:160 [09:40:30.957] queryDesc = 0x836f25c48 [09:40:30.957] #13 0x000000000093663d in PortalRunMulti (portal=portal@entry=0x836f6c100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x836f1df10, altdest=0xb7dcb0 , qc=qc@entry=0x820ff6208) at ../src/backend/tcop/pquery.c:1287 [09:40:30.957] pstmt = 0x839afb958 [09:40:30.957] stmtlist_item__state = {l = 0x839b00210, i = 0} [09:40:30.957] active_snapshot_set = true [09:40:30.957] stmtlist_item = 0x839b00228 [09:40:30.957] #14 0x000000000093614c in FillPortalStore (portal=portal@entry=0x836f6c100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [09:40:30.957] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:40:30.957] treceiver = 0x836f1df10 [09:40:30.957] #15 0x0000000000935ebb in PortalRun (portal=portal@entry=0x836f6c100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x839b00260, altdest=altdest@entry=0x839b00260, qc=0x820ff6340) at ../src/backend/tcop/pquery.c:763 [09:40:30.957] _local_sigjmp_buf = {{_sjb = {9657949, 35281879296, 34913346104, 34913346336, 34913346112, 35281895424, 12316168, 12349496, 35281830783, 35281207552, 4294967984, 0}}} [09:40:30.957] _save_exception_stack = 0x820ff6410 [09:40:30.957] _save_context_stack = 0x0 [09:40:30.957] _do_rethrow = false [09:40:30.957] saveTopTransactionResourceOwner = 0x836fb3998 [09:40:30.957] saveTopTransactionContext = 0x836f70000 [09:40:30.957] saveActivePortal = 0x0 [09:40:30.957] saveResourceOwner = 0x836fb3998 [09:40:30.957] savePortalContext = 0x0 [09:40:30.957] saveMemoryContext = 0x836f70000 [09:40:30.957] result = [09:40:30.957] nprocessed = [09:40:30.957] #16 0x0000000000934d82 in exec_simple_query (query_string=query_string@entry=0x836ec8100 "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 [09:40:30.957] cmdtaglen = 5 [09:40:30.957] snapshot_set = [09:40:30.957] per_parsetree_context = 0x0 [09:40:30.957] plantree_list = [09:40:30.957] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:40:30.957] format = 0 [09:40:30.957] parsetree = 0x839ab8328 [09:40:30.957] commandTag = [09:40:30.957] cmdtagname = [09:40:30.957] querytree_list = [09:40:30.957] portal = 0x836f6c100 [09:40:30.957] receiver = 0x839b00260 [09:40:30.957] parsetree_item__state = {l = 0x839ab9bf0, i = 0} [09:40:30.957] msec_str = "\000\000\000\000\b", '\000' , "\225\a\344f\000\000\000\000\016\335g#/\2104k" [09:40:30.957] dest = DestRemote [09:40:30.957] was_logged = [09:40:30.957] oldcontext = 0x836f70000 [09:40:30.957] parsetree_list = 0x839ab9bf0 [09:40:30.957] use_implicit_block = false [09:40:30.957] parsetree_item = 0x839ab9c08 [09:40:30.957] save_log_statement_stats = [09:40:30.957] #17 0x0000000000932af0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [09:40:30.957] query_string = 0x836ec8100 "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"... [09:40:30.957] input_message = {data = 0x836ec8100 "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} [09:40:30.957] firstchar = [09:40:30.957] local_sigjmp_buf = {{_sjb = {9641862, 34913346576, 34913346536, 34913347120, 12358232, 1, 8192, 8388608, 34913321855, 0, 0, 1}}} [09:40:30.957] send_ready_for_query = false [09:40:30.957] idle_in_transaction_timeout_enabled = false [09:40:30.957] idle_session_timeout_enabled = false [09:40:30.957] #18 0x000000000092d2c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:40:30.957] bsdata = [09:40:30.957] #19 0x0000000000887447 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820ff7154 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820ff7090) at ../src/backend/postmaster/launch_backend.c:274 [09:40:30.957] pid = [09:40:30.957] #20 0x000000000088b808 in BackendStartup (client_sock=0x820ff7090) at ../src/backend/postmaster/postmaster.c:3415 [09:40:30.957] startup_data = {canAcceptConnections = CAC_OK} [09:40:30.957] bn = 0x836ed4538 [09:40:30.957] pid = [09:40:30.957] __error = [09:40:30.957] save_errno = [09:40:30.957] __error = [09:40:30.957] __error = [09:40:30.957] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [09:40:30.957] 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\236\3546\b", '\000' , "\360p\377 \b\000\000\000h\265\257*\b\000\000\000\v\000\000\000\000\000\000\000^?\260*\b", '\000' , "0q\377 \b\000\000\000\364q\210\000\000\000\000\000@q\377 \b", '\000' }, salen = 16}} [09:40:30.957] i = 0 [09:40:30.957] now = [09:40:30.957] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 732068994, events = 8, fd = 0, user_data = 0x820ff7040}, {pos = 921896408, events = 8, fd = 553610960, user_data = 0x0}, {pos = 0, events = 0, fd = -238916303, user_data = 0xd2aebc0d30a}, {pos = 731236256, events = 8, fd = 731307384, user_data = 0x820ff6b58}, {pos = 553610192, events = 8, fd = 553610072, user_data = 0xd2aebc0d30a}, {pos = 731214728, events = 8, fd = 731307384, user_data = 0x820ff6b88}, {pos = 553610240, events = 8, fd = 553610120, user_data = 0x82b966194}, {pos = 563938312, events = 8, fd = 731275668, user_data = 0x820ff6bf0}, {pos = -339704774, events = 3370, fd = 733098032, user_data = 0x1}, {pos = 553610272, events = 8, fd = -339684598, user_data = 0x82b94f858}, {pos = 731307384, events = 8, fd = 553610232, user_data = 0x820ff6c70}, {pos = 553610232, events = 8, fd = 731270412, user_data = 0x8219d0408}, {pos = 731270412, events = 8, fd = 553610336, user_data = 0xd2aebc0843a}, {pos = 553610376, events = 8, fd = 553610824, user_data = 0x820ff6c70}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1315561288, fd = 563961912, user_data = 0x800000001}, {pos = 563938312, events = 8, fd = 731214728, user_data = 0x8219d5288}, {pos = 731183192, events = 8, fd = 563938312, user_data = 0x820ff6cf8}, {pos = 553610936, events = 8, fd = 553610464, user_data = 0xd2aebc0cca2}, {pos = 2700546, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 563961912, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 553611192, user_data = 0x219d0408}, {pos = 553611008, events = 8, fd = 553610608, user_data = 0x1}, {pos = 553610936, events = 8, fd = 32, user_data = 0x820ff6d60}, {pos = -339686797, events = 3370, fd = 553610880, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8219d6038}, {pos = 1, events = 8, fd = 563938312, user_data = 0x82b94f858}, {pos = 553611192, events = 8, fd = 553611008, user_data = 0x820ff6d70}, {pos = 0, events = 0, fd = 563908616, user_data = 0x20}, {pos = 553610992, events = 8, fd = -339711257, user_data = 0x8219c9008}, {pos = 563909640, events = 8, fd = 563910664, user_data = 0x8219c9c08}, {pos = 563925000, events = 8, fd = 563926024, user_data = 0x8219cd808}, {pos = 563928072, events = 8, fd = 563929096, user_data = 0x8219ce408}, {pos = 563931144, events = 8, fd = 563932168, user_data = 0x8219cf008}, {pos = 563934216, events = 8, fd = 563935240, user_data = 0x8219cfc08}, {pos = 563937288, events = 8, fd = 563938312, user_data = 0x8219d0808}, {pos = 563940360, events = 8, fd = 563941384, user_data = 0x8219d1408}, {pos = 563943432, events = 8, fd = 563944456, user_data = 0x8219d2008}, {pos = 563946504, events = 8, fd = 563947528, user_data = 0x8219d2c08}, {pos = 563953672, events = 8, fd = 563954696, user_data = 0x8219d4808}, {pos = 563956744, events = 8, fd = 563908616, user_data = 0x293502}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8219d6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 553611192, events = 8, fd = 553610608, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 563961912, user_data = 0x1}, {pos = 563908616, events = 8, fd = 313, user_data = 0x820ff6fa0}, {pos = -339712529, events = 3370, fd = 2700546, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 563961912, user_data = 0x1}, {pos = 563938312, events = 8, fd = 921403392, user_data = 0x1}, {pos = 921403796, events = 8, fd = 0, user_data = 0x820ff6f70}, {pos = 716191084, events = 8, fd = 1, user_data = 0x836eb8000}, {pos = 553611168, events = 8, fd = 716187394, user_data = 0x82ba81170 }, {pos = 12283264, events = 0, fd = 732434800, user_data = 0x8219d0408}, {pos = 553611392, events = 8, fd = -339713058, user_data = 0x836ed6800}, {pos = 1, events = 0, fd = -339713442, user_data = 0x8219c9008}, {pos = 553611176, events = 8, fd = 553611392, user_data = 0x1c20}, {pos = 921476800, events = 8, fd = -339633776, user_data = 0x0}, {pos = 553583487, events = 8, fd = 8092423, user_data = 0x820ff7030}, {pos = 716149776, events = 8, fd = 733098032, user_data = 0x82bb25310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820ff7060}, {pos = 716192669, events = 8, fd = 921403392, user_data = 0x17c2}, {pos = 553611456, events = 8, fd = 716159226, user_data = 0x0}, {pos = 0, events = 0, fd = -238916303, user_data = 0x0}} [09:40:30.957] last_touch_time = 1726220170 [09:40:30.957] last_lockfile_recheck_time = 1726220170 [09:40:30.957] nevents = 1 [09:40:30.957] #22 0x0000000000889625 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820ff76a0) at ../src/backend/postmaster/postmaster.c:1346 [09:40:30.957] userDoption = [09:40:30.957] listen_addr_saved = [09:40:30.957] output_config_variable = [09:40:30.957] opt = [09:40:30.957] status = [09:40:30.957] #23 0x00000000007c47ec in main (argc=4, argv=0x820ff76a0) at ../src/backend/main/main.c:197 [09:40:30.957] do_check_root = [09:40:30.969] [09:40:30.969] [09:40:30.969] [09:40:31.032] dumping /tmp/cores/postgres.14268.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:40:31.152] [New LWP 101710] [09:40:31.218] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [09:40:31.218] Program terminated with signal SIGABRT, Aborted. [09:40:31.218] Sent by thr_kill() from pid 14268 and user 1003. [09:40:31.218] #0 0x000000082a6de41a in thr_kill () from /lib/libc.so.7 [09:40:31.843] [09:40:31.843] Thread 1 (LWP 101710): [09:40:31.843] #0 0x000000082a6de41a in thr_kill () from /lib/libc.so.7 [09:40:31.843] No symbol table info available. [09:40:31.843] #1 0x000000082a657e64 in raise () from /lib/libc.so.7 [09:40:31.843] No symbol table info available. [09:40:31.843] #2 0x000000082a7086f9 in abort () from /lib/libc.so.7 [09:40:31.843] No symbol table info available. [09:40:31.843] #3 0x0000000000a8c0a5 in ExceptionalCondition (conditionName=0x2d18c9 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [09:40:31.843] No locals. [09:40:31.843] #4 0x000000000076f4ef in ExecFetchSlotHeapTuple (slot=0x821097e50, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [09:40:31.843] No locals. [09:40:31.843] #5 0x00000000007341a7 in ExecIRDeleteTriggers (estate=estate@entry=0x835694100, relinfo=relinfo@entry=0x8356946b0, slot=slot@entry=0x821097e50) at ../src/backend/commands/trigger.c:2841 [09:40:31.843] trigger = [09:40:31.843] oldtuple = [09:40:31.843] should_free = false [09:40:31.843] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83ad34d30, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [09:40:31.843] trigdesc = 0x8356948c0 [09:40:31.843] newtuple = 0x0 [09:40:31.843] i = 0 [09:40:31.843] #6 0x00000000007946c7 in ExecMergeMatched (context=0x821097ef8, resultRelInfo=0x8356946b0, tupleid=0x0, oldtuple=0x821097e50, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [09:40:31.843] result = TM_Ok [09:40:31.843] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [09:40:31.843] relaction = 0x83ad74e60 [09:40:31.843] commandType = CMD_DELETE [09:40:31.843] l__state = {l = 0x83aeec3b8, i = 0} [09:40:31.843] mtstate = 0x8356944a0 [09:40:31.843] newslot = 0x0 [09:40:31.843] rslot = 0x0 [09:40:31.843] estate = 0x835694100 [09:40:31.843] mergeActions = [09:40:31.843] econtext = 0x83aeeb458 [09:40:31.843] epqstate = 0x835694588 [09:40:31.843] actionStates = 0x83aeec3b8 [09:40:31.843] l = [09:40:31.843] isNull = [09:40:31.843] lmerge_matched = [09:40:31.843] __error = [09:40:31.843] l__state = [09:40:31.843] result = [09:40:31.843] updateCxt = [09:40:31.843] relaction = [09:40:31.843] commandType = [09:40:31.843] __error = [09:40:31.843] resultRelationDesc = [09:40:31.843] lockmode = [09:40:31.843] inputslot = [09:40:31.843] epqslot = [09:40:31.843] was_matched = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] #7 ExecMerge (context=0x821097ef8, resultRelInfo=0x8356946b0, tupleid=0x0, oldtuple=0x821097e50, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [09:40:31.843] matched = [09:40:31.843] rslot = 0x0 [09:40:31.843] #8 ExecModifyTable (pstate=0x8356944a0) at ../src/backend/executor/nodeModifyTable.c:4133 [09:40:31.843] context = {mtstate = 0x8356944a0, epqstate = 0x835694588, estate = 0x835694100, planSlot = 0x83aee9858, tmfd = {ctid = {ip_blkid = {bi_hi = 44430, bi_lo = 10861}, ip_posid = 8}, xmax = 119, cmax = 0, traversed = 30}, cpUpdateReturningSlot = 0x22d86680e6dd0abe} [09:40:31.843] tuple_ctid = {ip_blkid = {bi_hi = 32544, bi_lo = 8457}, ip_posid = 8} [09:40:31.843] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835724118} [09:40:31.843] node = 0x8356944a0 [09:40:31.843] estate = 0x835694100 [09:40:31.843] operation = CMD_MERGE [09:40:31.843] resultRelInfo = 0x8356946b0 [09:40:31.843] subplanstate = 0x835695db0 [09:40:31.843] slot = [09:40:31.843] tupleid = 0x0 [09:40:31.843] oldtuple = 0x821097e50 [09:40:31.843] oldSlot = [09:40:31.843] #9 0x000000000076175b in ExecProcNode (node=0x8356944a0) at ../src/include/executor/executor.h:278 [09:40:31.843] No locals. [09:40:31.843] #10 ExecutePlan (estate=0x835694100, planstate=0x8356944a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x835708b10, execute_once=) at ../src/backend/executor/execMain.c:1641 [09:40:31.843] current_tuple_count = 0 [09:40:31.843] slot = [09:40:31.843] #11 standard_ExecutorRun (queryDesc=0x835727448, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [09:40:31.843] estate = 0x835694100 [09:40:31.843] oldcontext = 0x835708800 [09:40:31.843] operation = CMD_MERGE [09:40:31.843] dest = 0x835708b10 [09:40:31.843] sendTuples = true [09:40:31.843] #12 0x00000008376bb961 in pgss_ExecutorRun (queryDesc=0x835727448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [09:40:31.843] _local_sigjmp_buf = {{_sjb = {35289545009, 1, 34914009128, 34914009296, 12349496, 34914009136, 1, 35256431688, 34913977215, 7815857, 35255828480, 34359738368}}} [09:40:31.843] _save_exception_stack = 0x8210981e0 [09:40:31.843] _save_context_stack = 0x0 [09:40:31.843] _do_rethrow = false [09:40:31.843] #13 0x000000000093709f in ProcessQuery (plan=0x83aea48c0, sourceText=, params=0x0, queryEnv=0x0, dest=0x835708b10, qc=0x8210981a8) at ../src/backend/tcop/pquery.c:160 [09:40:31.843] queryDesc = 0x835727448 [09:40:31.843] #14 0x000000000093663d in PortalRunMulti (portal=portal@entry=0x8355fc100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x835708b10, altdest=0xb7dcb0 , qc=qc@entry=0x8210981a8) at ../src/backend/tcop/pquery.c:1287 [09:40:31.843] pstmt = 0x83aea48c0 [09:40:31.843] stmtlist_item__state = {l = 0x83aea9178, i = 0} [09:40:31.843] active_snapshot_set = true [09:40:31.843] stmtlist_item = 0x83aea9190 [09:40:31.843] #15 0x000000000093614c in FillPortalStore (portal=portal@entry=0x8355fc100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [09:40:31.843] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:40:31.843] treceiver = 0x835708b10 [09:40:31.843] #16 0x0000000000935ebb in PortalRun (portal=portal@entry=0x8355fc100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83aea91c8, altdest=altdest@entry=0x83aea91c8, qc=0x8210982e0) at ../src/backend/tcop/pquery.c:763 [09:40:31.843] _local_sigjmp_buf = {{_sjb = {9657949, 35255206144, 34914009560, 34914009792, 34914009568, 35255300096, 12316168, 12349496, 35255157631, 35254526208, 4294967984, 0}}} [09:40:31.843] _save_exception_stack = 0x8210983b0 [09:40:31.843] _save_context_stack = 0x0 [09:40:31.843] _do_rethrow = false [09:40:31.843] saveTopTransactionResourceOwner = 0x83564aa98 [09:40:31.843] saveTopTransactionContext = 0x835613000 [09:40:31.843] saveActivePortal = 0x0 [09:40:31.843] saveResourceOwner = 0x83564aa98 [09:40:31.843] savePortalContext = 0x0 [09:40:31.843] saveMemoryContext = 0x835613000 [09:40:31.843] result = [09:40:31.843] nprocessed = [09:40:31.843] #17 0x0000000000934d82 in exec_simple_query (query_string=query_string@entry=0x835556100 "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 [09:40:31.843] cmdtaglen = 5 [09:40:31.843] snapshot_set = [09:40:31.843] per_parsetree_context = 0x0 [09:40:31.843] plantree_list = [09:40:31.843] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:40:31.843] format = 0 [09:40:31.843] parsetree = 0x83ae5e528 [09:40:31.843] commandTag = [09:40:31.843] cmdtagname = [09:40:31.843] querytree_list = [09:40:31.843] portal = 0x8355fc100 [09:40:31.843] receiver = 0x83aea91c8 [09:40:31.843] parsetree_item__state = {l = 0x83ae5fdf0, i = 0} [09:40:31.843] msec_str = "\000\000\000\000\b", '\000' , "\266\a\344f\000\000\000\000&\237.\016\273\336=\r" [09:40:31.843] dest = DestRemote [09:40:31.843] was_logged = [09:40:31.843] oldcontext = 0x835613000 [09:40:31.843] parsetree_list = 0x83ae5fdf0 [09:40:31.843] use_implicit_block = false [09:40:31.843] parsetree_item = 0x83ae5fe08 [09:40:31.843] save_log_statement_stats = [09:40:31.843] #18 0x0000000000932af0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [09:40:31.843] query_string = 0x835556100 "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"... [09:40:31.843] input_message = {data = 0x835556100 "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} [09:40:31.843] firstchar = [09:40:31.843] local_sigjmp_buf = {{_sjb = {9641862, 34914010032, 34914009992, 34914010576, 12358232, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [09:40:31.843] send_ready_for_query = false [09:40:31.843] idle_in_transaction_timeout_enabled = false [09:40:31.843] idle_session_timeout_enabled = false [09:40:31.843] #19 0x000000000092d2c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:40:31.843] bsdata = [09:40:31.843] #20 0x0000000000887447 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8210990f4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821099030) at ../src/backend/postmaster/launch_backend.c:274 [09:40:31.843] pid = [09:40:31.843] #21 0x000000000088b808 in BackendStartup (client_sock=0x821099030) at ../src/backend/postmaster/postmaster.c:3415 [09:40:31.843] startup_data = {canAcceptConnections = CAC_OK} [09:40:31.843] bn = 0x8355624e8 [09:40:31.843] pid = [09:40:31.843] __error = [09:40:31.843] save_errno = [09:40:31.843] __error = [09:40:31.843] __error = [09:40:31.843] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [09:40:31.843] 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 = " lU5\b", '\000' , "\220\220\t!\b\000\000\000h\245+*\b\000\000\000\v\000\000\000\000\000\000\000^/,*\b", '\000' , "А\t!\b\000\000\000\364q\210\000\000\000\000\000\340\220\t!\b", '\000' }, salen = 16}} [09:40:31.843] i = 0 [09:40:31.843] now = [09:40:31.843] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 711470210, events = 8, fd = 0, user_data = 0x821098fe0}, {pos = 895215064, events = 8, fd = 554274416, user_data = 0x0}, {pos = 284443402, events = 2229, fd = 710637472, user_data = 0x82a5c8d78}, {pos = 554273512, events = 8, fd = 554273632, user_data = 0x821098ae8}, {pos = 284443402, events = 2229, fd = 710615944, user_data = 0x82a5c8d78}, {pos = 554273560, events = 8, fd = 554273680, user_data = 0x821098b18}, {pos = 710676884, events = 8, fd = 557073416, user_data = 0x82a5c1194}, {pos = 554273664, events = 8, fd = 284423226, user_data = 0x821098b20}, {pos = 707494928, events = 8, fd = 712499248, user_data = 0x8b510f4430a}, {pos = 710584408, events = 8, fd = 710708600, user_data = 0x821098b88}, {pos = 554273792, events = 8, fd = 554273672, user_data = 0x82a5bfd0c}, {pos = 557073416, events = 8, fd = 710671628, user_data = 0x821098bf0}, {pos = 284423226, events = 2229, fd = 554273816, user_data = 0x821098de8}, {pos = 554273792, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x82134a038}, {pos = 1, events = 584607360, fd = 557073416, user_data = 0x82a5b2388}, {pos = 557094856, events = 8, fd = 0, user_data = 0x0}, {pos = 554273928, events = 8, fd = 554274392, user_data = 0x821098c70}, {pos = 284441762, events = 2229, fd = 2700546, user_data = 0x6d68b}, {pos = 2090263927, events = 584607360, fd = 557097016, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821098f58}, {pos = 557073416, events = 3, fd = 554274464, user_data = 0x821349828}, {pos = 656, events = 0, fd = 554274392, user_data = 0x821098c88}, {pos = 554274032, events = 8, fd = 284441371, user_data = 0x821098e20}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 557097016, events = 8, fd = 1, user_data = 0x821344408}, {pos = 710584408, events = 8, fd = 554274648, user_data = 0x821098ea0}, {pos = 554274048, events = 8, fd = 0, user_data = 0x82133d008}, {pos = 33, events = 0, fd = 554274448, user_data = 0x8b510f3dae7}, {pos = 557043720, events = 8, fd = 557044744, user_data = 0x82133d808}, {pos = 557046792, events = 8, fd = 557060104, user_data = 0x821341408}, {pos = 557062152, events = 8, fd = 557063176, user_data = 0x821342008}, {pos = 557065224, events = 8, fd = 557066248, user_data = 0x821342c08}, {pos = 557068296, events = 8, fd = 557069320, user_data = 0x821343808}, {pos = 557071368, events = 8, fd = 557072392, user_data = 0x821344408}, {pos = 557074440, events = 8, fd = 557075464, user_data = 0x821345008}, {pos = 557077512, events = 8, fd = 557078536, user_data = 0x821345c08}, {pos = 557080584, events = 8, fd = 557081608, user_data = 0x821346808}, {pos = 557083656, events = 8, fd = 557088776, user_data = 0x821348408}, {pos = 557090824, events = 8, fd = 557091848, user_data = 0x82134b408}, {pos = 885270000, events = 0, fd = 557043720, user_data = 0x293502}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82134a038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554274648, events = 8, fd = 554274048, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 557097016, user_data = 0x1}, {pos = 557043720, events = 8, fd = 313, user_data = 0x821098f40}, {pos = 284415471, events = 2229, fd = 2700546, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 557097016, user_data = 0x1}, {pos = 557073416, events = 8, fd = 894722048, user_data = 0x1}, {pos = 894722452, events = 8, fd = 0, user_data = 0x821098f10}, {pos = 707536236, events = 8, fd = 1, user_data = 0x835546000}, {pos = 554274624, events = 8, fd = 707532546, user_data = 0x82a6dc170 }, {pos = 12283264, events = 0, fd = 711836016, user_data = 0x821344408}, {pos = 554274848, events = 8, fd = 284414942, user_data = 0x835564800}, {pos = 1, events = 0, fd = 284414558, user_data = 0x82133d008}, {pos = 554274632, events = 8, fd = 554274848, user_data = 0x1c20}, {pos = 894790688, events = 8, fd = 284494224, user_data = 0x0}, {pos = 554238847, events = 8, fd = 8092423, user_data = 0x821098fd0}, {pos = 707494928, events = 8, fd = 712499248, user_data = 0x82a780310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821099000}, {pos = 707537821, events = 8, fd = 894722048, user_data = 0x300c}, {pos = 554274912, events = 8, fd = 707504378, user_data = 0x0}, {pos = 0, events = 0, fd = -421721410, user_data = 0x0}} [09:40:31.843] last_touch_time = 1726220201 [09:40:31.843] last_lockfile_recheck_time = 1726220201 [09:40:31.843] nevents = 1 [09:40:31.843] #23 0x0000000000889625 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821099648) at ../src/backend/postmaster/postmaster.c:1346 [09:40:31.843] userDoption = [09:40:31.843] listen_addr_saved = [09:40:31.843] output_config_variable = [09:40:31.843] opt = [09:40:31.843] status = [09:40:31.843] #24 0x00000000007c47ec in main (argc=4, argv=0x821099648) at ../src/backend/main/main.c:197 [09:40:31.843] do_check_root =