[13:39:41.932] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [13:39:42.290] dumping /tmp/cores/postgres.8208.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:39:42.415] [New LWP 100864] [13:39:42.500] Core was generated by `postgres: postgres regression [local] MERGE'. [13:39:42.500] Program terminated with signal SIGABRT, Aborted. [13:39:42.500] Sent by thr_kill() from pid 8208 and user 1003. [13:39:42.500] #0 0x000000082abaf41a in thr_kill () from /lib/libc.so.7 [13:39:43.066] [13:39:43.066] Thread 1 (LWP 100864): [13:39:43.066] #0 0x000000082abaf41a in thr_kill () from /lib/libc.so.7 [13:39:43.066] No symbol table info available. [13:39:43.066] #1 0x000000082ab28e64 in raise () from /lib/libc.so.7 [13:39:43.066] No symbol table info available. [13:39:43.066] #2 0x000000082abd96f9 in abort () from /lib/libc.so.7 [13:39:43.066] No symbol table info available. [13:39:43.066] #3 0x0000000000a8a055 in ExceptionalCondition (conditionName=0x2d0870 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:39:43.066] No locals. [13:39:43.066] #4 0x000000000076e09f in ExecFetchSlotHeapTuple (slot=0x821362b00, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [13:39:43.066] No locals. [13:39:43.066] #5 0x0000000000732d57 in ExecIRDeleteTriggers (estate=estate@entry=0x8355f0100, relinfo=relinfo@entry=0x8355f06b0, slot=slot@entry=0x821362b00) at ../src/backend/commands/trigger.c:2841 [13:39:43.066] trigger = [13:39:43.066] oldtuple = [13:39:43.066] should_free = false [13:39:43.066] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x835581f78, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:39:43.066] trigdesc = 0x8355f08c0 [13:39:43.066] newtuple = 0x0 [13:39:43.066] i = 0 [13:39:43.066] #6 0x0000000000793277 in ExecMergeMatched (context=0x821362ba8, resultRelInfo=0x8355f06b0, tupleid=0x0, oldtuple=0x821362b00, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [13:39:43.066] result = TM_Ok [13:39:43.066] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:39:43.066] relaction = 0x838998c78 [13:39:43.066] commandType = CMD_DELETE [13:39:43.066] l__state = {l = 0x838999238, i = 0} [13:39:43.066] mtstate = 0x8355f04a0 [13:39:43.066] newslot = 0x0 [13:39:43.066] rslot = 0x0 [13:39:43.066] estate = 0x8355f0100 [13:39:43.066] mergeActions = [13:39:43.066] econtext = 0x8389982a8 [13:39:43.066] epqstate = 0x8355f0588 [13:39:43.066] actionStates = 0x838999238 [13:39:43.066] l = [13:39:43.066] isNull = [13:39:43.066] lmerge_matched = [13:39:43.066] __error = [13:39:43.066] l__state = [13:39:43.066] result = [13:39:43.066] updateCxt = [13:39:43.066] relaction = [13:39:43.066] commandType = [13:39:43.066] __error = [13:39:43.066] resultRelationDesc = [13:39:43.066] lockmode = [13:39:43.066] inputslot = [13:39:43.066] epqslot = [13:39:43.066] was_matched = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] #7 ExecMerge (context=0x821362ba8, resultRelInfo=0x8355f06b0, tupleid=0x0, oldtuple=0x821362b00, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [13:39:43.066] matched = [13:39:43.066] rslot = 0x0 [13:39:43.066] #8 ExecModifyTable (pstate=0x8355f04a0) at ../src/backend/executor/nodeModifyTable.c:4133 [13:39:43.066] context = {mtstate = 0x8355f04a0, epqstate = 0x8355f0588, estate = 0x8355f0100, planSlot = 0x8388acc70, tmfd = {ctid = {ip_blkid = {bi_hi = 14728, bi_lo = 14492}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8355f06b0} [13:39:43.066] tuple_ctid = {ip_blkid = {bi_hi = 11968, bi_lo = 17476}, ip_posid = 8} [13:39:43.066] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83887a118} [13:39:43.066] node = 0x8355f04a0 [13:39:43.066] estate = 0x8355f0100 [13:39:43.066] operation = CMD_MERGE [13:39:43.066] resultRelInfo = 0x8355f06b0 [13:39:43.066] subplanstate = 0x8355f1df0 [13:39:43.066] slot = [13:39:43.066] tupleid = 0x0 [13:39:43.066] oldtuple = 0x821362b00 [13:39:43.066] oldSlot = [13:39:43.066] #9 0x000000000076030b in ExecProcNode (node=0x8355f04a0) at ../src/include/executor/executor.h:278 [13:39:43.066] No locals. [13:39:43.066] #10 ExecutePlan (estate=0x8355f0100, planstate=0x8355f04a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x8355ddb10, execute_once=) at ../src/backend/executor/execMain.c:1641 [13:39:43.066] current_tuple_count = 0 [13:39:43.066] slot = [13:39:43.066] #11 standard_ExecutorRun (queryDesc=0x835490c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [13:39:43.066] estate = 0x8355f0100 [13:39:43.066] oldcontext = 0x8355dd800 [13:39:43.066] operation = CMD_MERGE [13:39:43.066] dest = 0x8355ddb10 [13:39:43.066] sendTuples = true [13:39:43.066] #12 0x000000000093525f in ProcessQuery (plan=0x8389c3270, sourceText=, params=0x0, queryEnv=0x0, dest=0x8355ddb10, qc=0x821362da8) at ../src/backend/tcop/pquery.c:160 [13:39:43.066] queryDesc = 0x835490c48 [13:39:43.066] #13 0x00000000009347fd in PortalRunMulti (portal=portal@entry=0x83550f100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x8355ddb10, altdest=0xb7b8c0 , qc=qc@entry=0x821362da8) at ../src/backend/tcop/pquery.c:1287 [13:39:43.066] pstmt = 0x8389c3270 [13:39:43.066] stmtlist_item__state = {l = 0x8389c7b28, i = 0} [13:39:43.066] active_snapshot_set = true [13:39:43.066] stmtlist_item = 0x8389c7b40 [13:39:43.066] #14 0x000000000093430c in FillPortalStore (portal=portal@entry=0x83550f100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [13:39:43.066] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:39:43.066] treceiver = 0x8355ddb10 [13:39:43.066] #15 0x000000000093407b in PortalRun (portal=portal@entry=0x83550f100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8389c7b78, altdest=altdest@entry=0x8389c7b78, qc=0x821362ee0) at ../src/backend/tcop/pquery.c:763 [13:39:43.066] _local_sigjmp_buf = {{_sjb = {9650205, 35254235392, 34916937176, 34916937408, 34916937184, 35254255616, 12306536, 12339864, 35254240127, 35253362944, 4294967984, 0}}} [13:39:43.066] _save_exception_stack = 0x821362fb0 [13:39:43.066] _save_context_stack = 0x0 [13:39:43.066] _do_rethrow = false [13:39:43.066] saveTopTransactionResourceOwner = 0x835521798 [13:39:43.066] saveTopTransactionContext = 0x835514000 [13:39:43.066] saveActivePortal = 0x0 [13:39:43.066] saveResourceOwner = 0x835521798 [13:39:43.066] savePortalContext = 0x0 [13:39:43.066] saveMemoryContext = 0x835514000 [13:39:43.066] result = [13:39:43.066] nprocessed = [13:39:43.066] #16 0x0000000000932f42 in exec_simple_query (query_string=query_string@entry=0x83543a100 "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 [13:39:43.066] cmdtaglen = 5 [13:39:43.066] snapshot_set = [13:39:43.066] per_parsetree_context = 0x0 [13:39:43.066] plantree_list = [13:39:43.066] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:39:43.066] format = 0 [13:39:43.066] parsetree = 0x83896a0a8 [13:39:43.066] commandTag = [13:39:43.066] cmdtagname = [13:39:43.066] querytree_list = [13:39:43.066] portal = 0x83550f100 [13:39:43.066] receiver = 0x8389c7b78 [13:39:43.066] parsetree_item__state = {l = 0x83896b970, i = 0} [13:39:43.066] msec_str = "\000\000\000\000\b", '\000' , "\257\371\336f\000\000\000\000\020\376\236?R'i\024" [13:39:43.066] dest = DestRemote [13:39:43.066] was_logged = [13:39:43.066] oldcontext = 0x835514000 [13:39:43.066] parsetree_list = 0x83896b970 [13:39:43.066] use_implicit_block = false [13:39:43.066] parsetree_item = 0x83896b988 [13:39:43.066] save_log_statement_stats = [13:39:43.066] #17 0x0000000000930cb0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [13:39:43.066] query_string = 0x83543a100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [13:39:43.066] input_message = {data = 0x83543a100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [13:39:43.066] firstchar = [13:39:43.066] local_sigjmp_buf = {{_sjb = {9634118, 34916937648, 34916937608, 34916938192, 12348600, 1, 8192, 8388608, 34916926335, 0, 0, 1}}} [13:39:43.066] send_ready_for_query = false [13:39:43.066] idle_in_transaction_timeout_enabled = false [13:39:43.066] idle_session_timeout_enabled = false [13:39:43.066] #18 0x000000000092b489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:39:43.066] bsdata = [13:39:43.066] #19 0x0000000000885627 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821363cf4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821363c30) at ../src/backend/postmaster/launch_backend.c:274 [13:39:43.066] pid = [13:39:43.066] #20 0x00000000008899e8 in BackendStartup (client_sock=0x821363c30) at ../src/backend/postmaster/postmaster.c:3415 [13:39:43.066] startup_data = {canAcceptConnections = CAC_OK} [13:39:43.066] bn = 0x835446358 [13:39:43.066] pid = [13:39:43.066] __error = [13:39:43.066] save_errno = [13:39:43.066] __error = [13:39:43.066] __error = [13:39:43.066] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [13:39:43.066] 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\277C5\b", '\000' , "\220<6!\b\000\000\000h\305D*\b\000\000\000\v\000\000\000\000\000\000\000^OE*\b", '\000' , "\320<6!\b\000\000\000\324S\210\000\000\000\000\000\340<6!\b", '\000' }, salen = 16}} [13:39:43.066] i = 0 [13:39:43.066] now = [13:39:43.066] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 716520578, events = 8, fd = 0, user_data = 0x821363be0}, {pos = 894023128, events = 8, fd = 557202032, user_data = 0x0}, {pos = 0, events = 0, fd = 1438469202, user_data = 0x166dc26d30a}, {pos = 715687840, events = 8, fd = 715758968, user_data = 0x8213636f8}, {pos = 557201264, events = 8, fd = 557201144, user_data = 0x166dc26d30a}, {pos = 715666312, events = 8, fd = 715758968, user_data = 0x821363728}, {pos = 557201312, events = 8, fd = 557201192, user_data = 0x82aa92194}, {pos = 564167688, events = 8, fd = 715727252, user_data = 0x821363790}, {pos = -601455558, events = 358, fd = 717549616, user_data = 0x1}, {pos = 557201344, events = 8, fd = -601435382, user_data = 0x82aa7b858}, {pos = 715758968, events = 8, fd = 557201304, user_data = 0x821363810}, {pos = 557201304, events = 8, fd = 715721996, user_data = 0x821a08408}, {pos = 715721996, events = 8, fd = 557201408, user_data = 0x166dc26843a}, {pos = 557201448, events = 8, fd = 557201896, user_data = 0x821363810}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2872752016, fd = 564191288, user_data = 0x800000001}, {pos = 564167688, events = 8, fd = 715666312, user_data = 0x821a0d288}, {pos = 715634776, events = 8, fd = 564167688, user_data = 0x821363898}, {pos = 557202008, events = 8, fd = 557201536, user_data = 0x166dc26cca2}, {pos = 2699735, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 564191288, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 557202264, user_data = 0x21a08408}, {pos = 557202080, events = 8, fd = 557201680, user_data = 0x1}, {pos = 557202008, events = 8, fd = 32, user_data = 0x821363900}, {pos = -601437581, events = 358, fd = 557201952, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821a0e038}, {pos = 1, events = 8, fd = 564167688, user_data = 0x82aa7b858}, {pos = 557202264, events = 8, fd = 557202080, user_data = 0x821363910}, {pos = 0, events = 0, fd = 564137992, user_data = 0x20}, {pos = 557202064, events = 8, fd = -601462041, user_data = 0x821a01008}, {pos = 564139016, events = 8, fd = 564140040, user_data = 0x821a01c08}, {pos = 564154376, events = 8, fd = 564155400, user_data = 0x821a05808}, {pos = 564157448, events = 8, fd = 564158472, user_data = 0x821a06408}, {pos = 564160520, events = 8, fd = 564161544, user_data = 0x821a07008}, {pos = 564163592, events = 8, fd = 564164616, user_data = 0x821a07c08}, {pos = 564166664, events = 8, fd = 564167688, user_data = 0x821a08808}, {pos = 564169736, events = 8, fd = 564170760, user_data = 0x821a09408}, {pos = 564172808, events = 8, fd = 564173832, user_data = 0x821a0a008}, {pos = 564175880, events = 8, fd = 564176904, user_data = 0x821a0ac08}, {pos = 564183048, events = 8, fd = 564184072, user_data = 0x821a0c808}, {pos = 564186120, events = 8, fd = 564137992, user_data = 0x2931d7}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821a0e038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557202264, events = 8, fd = 557201680, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 564191288, user_data = 0x1}, {pos = 564137992, events = 8, fd = 313, user_data = 0x821363b40}, {pos = -601463313, events = 358, fd = 2699735, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564191288, user_data = 0x1}, {pos = 564167688, events = 8, fd = 893558784, user_data = 0x1}, {pos = 893559188, events = 8, fd = 0, user_data = 0x821363b10}, {pos = 709182828, events = 8, fd = 1, user_data = 0x83542a000}, {pos = 557202240, events = 8, fd = 709179138, user_data = 0x82abad170 }, {pos = 12273632, events = 0, fd = 716886384, user_data = 0x821a08408}, {pos = 557202464, events = 8, fd = -601463842, user_data = 0x835448800}, {pos = 1, events = 0, fd = -601464226, user_data = 0x821a01008}, {pos = 557202248, events = 8, fd = 557202464, user_data = 0x1c20}, {pos = 893632256, events = 8, fd = -601384560, user_data = 0x0}, {pos = 557187967, events = 8, fd = 8087223, user_data = 0x821363bd0}, {pos = 709141520, events = 8, fd = 717549616, user_data = 0x82ac51310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821363c00}, {pos = 709184413, events = 8, fd = 893558784, user_data = 0x18fd}, {pos = 557202528, events = 8, fd = 709150970, user_data = 0x0}, {pos = 0, events = 0, fd = 1438469202, user_data = 0x0}} [13:39:43.066] last_touch_time = 1725888933 [13:39:43.066] last_lockfile_recheck_time = 1725888933 [13:39:43.066] nevents = 1 [13:39:43.066] #22 0x0000000000887805 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821364248) at ../src/backend/postmaster/postmaster.c:1346 [13:39:43.066] userDoption = [13:39:43.066] listen_addr_saved = [13:39:43.066] output_config_variable = [13:39:43.066] opt = [13:39:43.066] status = [13:39:43.066] #23 0x00000000007c339c in main (argc=8, argv=0x821364248) at ../src/backend/main/main.c:197 [13:39:43.066] do_check_root = [13:39:43.077] [13:39:43.077] [13:39:43.077] [13:39:43.141] dumping /tmp/cores/postgres.8732.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:39:43.257] [New LWP 101768] [13:39:43.319] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [13:39:43.319] Program terminated with signal SIGABRT, Aborted. [13:39:43.319] Sent by thr_kill() from pid 8732 and user 1003. [13:39:43.319] #0 0x000000082d15541a in thr_kill () from /lib/libc.so.7 [13:39:43.865] [13:39:43.865] Thread 1 (LWP 101768): [13:39:43.865] #0 0x000000082d15541a in thr_kill () from /lib/libc.so.7 [13:39:43.865] No symbol table info available. [13:39:43.865] #1 0x000000082d0cee64 in raise () from /lib/libc.so.7 [13:39:43.865] No symbol table info available. [13:39:43.865] #2 0x000000082d17f6f9 in abort () from /lib/libc.so.7 [13:39:43.865] No symbol table info available. [13:39:43.865] #3 0x0000000000a8a055 in ExceptionalCondition (conditionName=0x2d0870 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:39:43.865] No locals. [13:39:43.865] #4 0x000000000076e09f in ExecFetchSlotHeapTuple (slot=0x8214d02d0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [13:39:43.865] No locals. [13:39:43.865] #5 0x0000000000732d57 in ExecIRDeleteTriggers (estate=estate@entry=0x8365b7100, relinfo=relinfo@entry=0x8365b76b0, slot=slot@entry=0x8214d02d0) at ../src/backend/commands/trigger.c:2841 [13:39:43.865] trigger = [13:39:43.865] oldtuple = [13:39:43.865] should_free = false [13:39:43.865] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8442fe788, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:39:43.865] trigdesc = 0x8365b78c0 [13:39:43.865] newtuple = 0x0 [13:39:43.865] i = 0 [13:39:43.865] #6 0x0000000000793277 in ExecMergeMatched (context=0x8214d0378, resultRelInfo=0x8365b76b0, tupleid=0x0, oldtuple=0x8214d02d0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [13:39:43.865] result = TM_Ok [13:39:43.865] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:39:43.865] relaction = 0x8420d5af8 [13:39:43.865] commandType = CMD_DELETE [13:39:43.865] l__state = {l = 0x8420d60b8, i = 0} [13:39:43.865] mtstate = 0x8365b74a0 [13:39:43.865] newslot = 0x0 [13:39:43.865] rslot = 0x0 [13:39:43.865] estate = 0x8365b7100 [13:39:43.865] mergeActions = [13:39:43.865] econtext = 0x8420d5128 [13:39:43.865] epqstate = 0x8365b7588 [13:39:43.865] actionStates = 0x8420d60b8 [13:39:43.865] l = [13:39:43.865] isNull = [13:39:43.865] lmerge_matched = [13:39:43.865] __error = [13:39:43.865] l__state = [13:39:43.865] result = [13:39:43.865] updateCxt = [13:39:43.865] relaction = [13:39:43.865] commandType = [13:39:43.865] __error = [13:39:43.865] resultRelationDesc = [13:39:43.865] lockmode = [13:39:43.865] inputslot = [13:39:43.865] epqslot = [13:39:43.865] was_matched = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] #7 ExecMerge (context=0x8214d0378, resultRelInfo=0x8365b76b0, tupleid=0x0, oldtuple=0x8214d02d0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [13:39:43.865] matched = [13:39:43.865] rslot = 0x0 [13:39:43.865] #8 ExecModifyTable (pstate=0x8365b74a0) at ../src/backend/executor/nodeModifyTable.c:4133 [13:39:43.865] context = {mtstate = 0x8365b74a0, epqstate = 0x8365b7588, estate = 0x8365b7100, planSlot = 0x842061c30, tmfd = {ctid = {ip_blkid = {bi_hi = 64696, bi_lo = 16910}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x8365b76b0} [13:39:43.865] tuple_ctid = {ip_blkid = {bi_hi = 53072, bi_lo = 17456}, ip_posid = 8} [13:39:43.865] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8365c3118} [13:39:43.865] node = 0x8365b74a0 [13:39:43.865] estate = 0x8365b7100 [13:39:43.865] operation = CMD_MERGE [13:39:43.865] resultRelInfo = 0x8365b76b0 [13:39:43.865] subplanstate = 0x8365b8df0 [13:39:43.865] slot = [13:39:43.865] tupleid = 0x0 [13:39:43.865] oldtuple = 0x8214d02d0 [13:39:43.865] oldSlot = [13:39:43.865] #9 0x000000000076030b in ExecProcNode (node=0x8365b74a0) at ../src/include/executor/executor.h:278 [13:39:43.865] No locals. [13:39:43.865] #10 ExecutePlan (estate=0x8365b7100, planstate=0x8365b74a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x836416b10, execute_once=) at ../src/backend/executor/execMain.c:1641 [13:39:43.865] current_tuple_count = 0 [13:39:43.865] slot = [13:39:43.865] #11 standard_ExecutorRun (queryDesc=0x836465448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [13:39:43.865] estate = 0x8365b7100 [13:39:43.865] oldcontext = 0x836416800 [13:39:43.865] operation = CMD_MERGE [13:39:43.865] dest = 0x836416b10 [13:39:43.865] sendTuples = true [13:39:43.865] #12 0x000000000093525f in ProcessQuery (plan=0x8420ef5a0, sourceText=, params=0x0, queryEnv=0x0, dest=0x836416b10, qc=0x8214d0578) at ../src/backend/tcop/pquery.c:160 [13:39:43.865] queryDesc = 0x836465448 [13:39:43.865] #13 0x00000000009347fd in PortalRunMulti (portal=portal@entry=0x8364ac100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x836416b10, altdest=0xb7b8c0 , qc=qc@entry=0x8214d0578) at ../src/backend/tcop/pquery.c:1287 [13:39:43.865] pstmt = 0x8420ef5a0 [13:39:43.865] stmtlist_item__state = {l = 0x8420f3e58, i = 0} [13:39:43.865] active_snapshot_set = true [13:39:43.865] stmtlist_item = 0x8420f3e70 [13:39:43.865] #14 0x000000000093430c in FillPortalStore (portal=portal@entry=0x8364ac100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [13:39:43.865] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:39:43.865] treceiver = 0x836416b10 [13:39:43.865] #15 0x000000000093407b in PortalRun (portal=portal@entry=0x8364ac100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8420f3ea8, altdest=altdest@entry=0x8420f3ea8, qc=0x8214d06b0) at ../src/backend/tcop/pquery.c:763 [13:39:43.865] _local_sigjmp_buf = {{_sjb = {9650205, 35270607104, 34918434216, 34918434448, 34918434224, 35270623232, 12306536, 12339864, 35270558591, 35269935360, 4294967984, 0}}} [13:39:43.865] _save_exception_stack = 0x8214d0780 [13:39:43.865] _save_context_stack = 0x0 [13:39:43.865] _do_rethrow = false [13:39:43.865] saveTopTransactionResourceOwner = 0x8364fb958 [13:39:43.865] saveTopTransactionContext = 0x8364b0000 [13:39:43.865] saveActivePortal = 0x0 [13:39:43.865] saveResourceOwner = 0x8364fb958 [13:39:43.865] savePortalContext = 0x0 [13:39:43.865] saveMemoryContext = 0x8364b0000 [13:39:43.865] result = [13:39:43.865] nprocessed = [13:39:43.865] #16 0x0000000000932f42 in exec_simple_query (query_string=query_string@entry=0x836408100 "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 [13:39:43.865] cmdtaglen = 5 [13:39:43.865] snapshot_set = [13:39:43.865] per_parsetree_context = 0x0 [13:39:43.865] plantree_list = [13:39:43.865] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:39:43.865] format = 0 [13:39:43.865] parsetree = 0x8420a7ae8 [13:39:43.865] commandTag = [13:39:43.865] cmdtagname = [13:39:43.865] querytree_list = [13:39:43.865] portal = 0x8364ac100 [13:39:43.865] receiver = 0x8420f3ea8 [13:39:43.865] parsetree_item__state = {l = 0x8420a93b0, i = 0} [13:39:43.865] msec_str = "\000\000\000\000\b", '\000' , "\263\371\336f\000\000\000\000\220\254\205\345j\225\260)" [13:39:43.865] dest = DestRemote [13:39:43.865] was_logged = [13:39:43.865] oldcontext = 0x8364b0000 [13:39:43.865] parsetree_list = 0x8420a93b0 [13:39:43.865] use_implicit_block = false [13:39:43.865] parsetree_item = 0x8420a93c8 [13:39:43.865] save_log_statement_stats = [13:39:43.865] #17 0x0000000000930cb0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [13:39:43.865] query_string = 0x836408100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [13:39:43.865] input_message = {data = 0x836408100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [13:39:43.865] firstchar = [13:39:43.865] local_sigjmp_buf = {{_sjb = {9634118, 34918434688, 34918434648, 34918435232, 12348600, 1, 8192, 8388608, 34918433663, 0, 0, 1}}} [13:39:43.865] send_ready_for_query = false [13:39:43.865] idle_in_transaction_timeout_enabled = false [13:39:43.865] idle_session_timeout_enabled = false [13:39:43.865] #18 0x000000000092b489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:39:43.865] bsdata = [13:39:43.865] #19 0x0000000000885627 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8214d14c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214d1400) at ../src/backend/postmaster/launch_backend.c:274 [13:39:43.865] pid = [13:39:43.865] #20 0x00000000008899e8 in BackendStartup (client_sock=0x8214d1400) at ../src/backend/postmaster/postmaster.c:3415 [13:39:43.865] startup_data = {canAcceptConnections = CAC_OK} [13:39:43.865] bn = 0x836414178 [13:39:43.865] pid = [13:39:43.865] __error = [13:39:43.865] save_errno = [13:39:43.865] __error = [13:39:43.865] __error = [13:39:43.865] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [13:39:43.865] 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@6\b", '\000' , "`\024M!\b\000\000\000he2+\b\000\000\000\v\000\000\000\000\000\000\000^\3572+\b", '\000' , "\240\024M!\b\000\000\000\324S\210\000\000\000\000\000\260\024M!\b", '\000' }, salen = 16}} [13:39:43.865] i = 0 [13:39:43.865] now = [13:39:43.865] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 755997826, events = 8, fd = 0, user_data = 0x8214d13b0}, {pos = 910624216, events = 8, fd = 558699072, user_data = 0x0}, {pos = 0, events = 0, fd = -1341658332, user_data = 0x2f5e77ed330a}, {pos = 755165088, events = 8, fd = 755236216, user_data = 0x8214d0ec8}, {pos = 558698304, events = 8, fd = 558698184, user_data = 0x2f5e77ed330a}, {pos = 755143560, events = 8, fd = 755236216, user_data = 0x8214d0ef8}, {pos = 558698352, events = 8, fd = 558698232, user_data = 0x82d038194}, {pos = 569615368, events = 8, fd = 755204500, user_data = 0x8214d0f60}, {pos = 2012013626, events = 12126, fd = 757026864, user_data = 0x1}, {pos = 558698384, events = 8, fd = 2012033802, user_data = 0x82d021858}, {pos = 755236216, events = 8, fd = 558698344, user_data = 0x8214d0fe0}, {pos = 558698344, events = 8, fd = 755199244, user_data = 0x821f3a408}, {pos = 755199244, events = 8, fd = 558698448, user_data = 0x2f5e77ece43a}, {pos = 558698488, events = 8, fd = 558698936, user_data = 0x8214d0fe0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2034138777, fd = 569638968, user_data = 0x800000001}, {pos = 569615368, events = 8, fd = 755143560, user_data = 0x821f3f288}, {pos = 755112024, events = 8, fd = 569615368, user_data = 0x8214d1068}, {pos = 558699048, events = 8, fd = 558698576, user_data = 0x2f5e77ed2ca2}, {pos = 2699735, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 569638968, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558699304, user_data = 0x21f3a408}, {pos = 558699120, events = 8, fd = 558698720, user_data = 0x1}, {pos = 558699048, events = 8, fd = 32, user_data = 0x8214d10d0}, {pos = 2012031603, events = 12126, fd = 558698992, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821f40038}, {pos = 1, events = 8, fd = 569615368, user_data = 0x82d021858}, {pos = 558699304, events = 8, fd = 558699120, user_data = 0x8214d10e0}, {pos = 0, events = 0, fd = 569585672, user_data = 0x20}, {pos = 558699104, events = 8, fd = 2012007143, user_data = 0x821f33008}, {pos = 569586696, events = 8, fd = 569587720, user_data = 0x821f33c08}, {pos = 569602056, events = 8, fd = 569603080, user_data = 0x821f37808}, {pos = 569605128, events = 8, fd = 569606152, user_data = 0x821f38408}, {pos = 569608200, events = 8, fd = 569609224, user_data = 0x821f39008}, {pos = 569611272, events = 8, fd = 569612296, user_data = 0x821f39c08}, {pos = 569614344, events = 8, fd = 569615368, user_data = 0x821f3a808}, {pos = 569617416, events = 8, fd = 569618440, user_data = 0x821f3b408}, {pos = 569620488, events = 8, fd = 569621512, user_data = 0x821f3c008}, {pos = 569623560, events = 8, fd = 569624584, user_data = 0x821f3cc08}, {pos = 569630728, events = 8, fd = 569631752, user_data = 0x821f3e808}, {pos = 569633800, events = 8, fd = 569585672, user_data = 0x2931d7}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821f40038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558699304, events = 8, fd = 558698720, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 569638968, user_data = 0x1}, {pos = 569585672, events = 8, fd = 313, user_data = 0x8214d1310}, {pos = 2012005871, events = 12126, fd = 2699735, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 569638968, user_data = 0x1}, {pos = 569615368, events = 8, fd = 910131200, user_data = 0x1}, {pos = 910131604, events = 8, fd = 0, user_data = 0x8214d12e0}, {pos = 724755820, events = 8, fd = 1, user_data = 0x8363f8000}, {pos = 558699280, events = 8, fd = 724752130, user_data = 0x82d153170 }, {pos = 12273632, events = 0, fd = 756363632, user_data = 0x821f3a408}, {pos = 558699504, events = 8, fd = 2012005342, user_data = 0x836416800}, {pos = 1, events = 0, fd = 2012004958, user_data = 0x821f33008}, {pos = 558699288, events = 8, fd = 558699504, user_data = 0x1c20}, {pos = 910204608, events = 8, fd = 2012084624, user_data = 0x0}, {pos = 558695295, events = 8, fd = 8087223, user_data = 0x8214d13a0}, {pos = 724714512, events = 8, fd = 757026864, user_data = 0x82d1f7310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214d13d0}, {pos = 724757405, events = 8, fd = 910131200, user_data = 0x1941}, {pos = 558699568, events = 8, fd = 724723962, user_data = 0x0}, {pos = 0, events = 0, fd = -1341658332, user_data = 0x0}} [13:39:43.865] last_touch_time = 1725888934 [13:39:43.865] last_lockfile_recheck_time = 1725888934 [13:39:43.865] nevents = 1 [13:39:43.865] #22 0x0000000000887805 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8214d1a18) at ../src/backend/postmaster/postmaster.c:1346 [13:39:43.865] userDoption = [13:39:43.865] listen_addr_saved = [13:39:43.865] output_config_variable = [13:39:43.865] opt = [13:39:43.865] status = [13:39:43.865] #23 0x00000000007c339c in main (argc=4, argv=0x8214d1a18) at ../src/backend/main/main.c:197 [13:39:43.865] do_check_root = [13:39:43.877] [13:39:43.877] [13:39:43.877] [13:39:43.937] dumping /tmp/cores/postgres.14567.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:39:44.052] [New LWP 100864] [13:39:44.114] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [13:39:44.114] Program terminated with signal SIGABRT, Aborted. [13:39:44.114] Sent by thr_kill() from pid 14567 and user 1003. [13:39:44.114] #0 0x000000082ae6c41a in thr_kill () from /lib/libc.so.7 [13:39:44.666] [13:39:44.666] Thread 1 (LWP 100864): [13:39:44.666] #0 0x000000082ae6c41a in thr_kill () from /lib/libc.so.7 [13:39:44.666] No symbol table info available. [13:39:44.666] #1 0x000000082ade5e64 in raise () from /lib/libc.so.7 [13:39:44.666] No symbol table info available. [13:39:44.666] #2 0x000000082ae966f9 in abort () from /lib/libc.so.7 [13:39:44.666] No symbol table info available. [13:39:44.666] #3 0x0000000000a8a055 in ExceptionalCondition (conditionName=0x2d0870 "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [13:39:44.666] No locals. [13:39:44.666] #4 0x000000000076e09f in ExecFetchSlotHeapTuple (slot=0x8212338e0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [13:39:44.666] No locals. [13:39:44.666] #5 0x0000000000732d57 in ExecIRDeleteTriggers (estate=estate@entry=0x837451100, relinfo=relinfo@entry=0x8374516b0, slot=slot@entry=0x8212338e0) at ../src/backend/commands/trigger.c:2841 [13:39:44.666] trigger = [13:39:44.666] oldtuple = [13:39:44.666] should_free = false [13:39:44.666] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83e639a28, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [13:39:44.666] trigdesc = 0x8374518c0 [13:39:44.666] newtuple = 0x0 [13:39:44.666] i = 0 [13:39:44.666] #6 0x0000000000793277 in ExecMergeMatched (context=0x821233988, resultRelInfo=0x8374516b0, tupleid=0x0, oldtuple=0x8212338e0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [13:39:44.666] result = TM_Ok [13:39:44.666] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [13:39:44.666] relaction = 0x83da34cb8 [13:39:44.666] commandType = CMD_DELETE [13:39:44.666] l__state = {l = 0x83da35278, i = 0} [13:39:44.666] mtstate = 0x8374514a0 [13:39:44.666] newslot = 0x0 [13:39:44.666] rslot = 0x0 [13:39:44.666] estate = 0x837451100 [13:39:44.666] mergeActions = [13:39:44.666] econtext = 0x83da342e8 [13:39:44.666] epqstate = 0x837451588 [13:39:44.666] actionStates = 0x83da35278 [13:39:44.666] l = [13:39:44.666] isNull = [13:39:44.666] lmerge_matched = [13:39:44.666] __error = [13:39:44.666] l__state = [13:39:44.666] result = [13:39:44.666] updateCxt = [13:39:44.666] relaction = [13:39:44.666] commandType = [13:39:44.666] __error = [13:39:44.666] resultRelationDesc = [13:39:44.666] lockmode = [13:39:44.666] inputslot = [13:39:44.666] epqslot = [13:39:44.666] was_matched = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] #7 ExecMerge (context=0x821233988, resultRelInfo=0x8374516b0, tupleid=0x0, oldtuple=0x8212338e0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [13:39:44.666] matched = [13:39:44.666] rslot = 0x0 [13:39:44.666] #8 ExecModifyTable (pstate=0x8374514a0) at ../src/backend/executor/nodeModifyTable.c:4133 [13:39:44.666] context = {mtstate = 0x8374514a0, epqstate = 0x837451588, estate = 0x837451100, planSlot = 0x83d929f30, tmfd = {ctid = {ip_blkid = {bi_hi = 36238, bi_lo = 10982}, ip_posid = 8}, xmax = 127, cmax = 0, traversed = 60}, cpUpdateReturningSlot = 0x445ead4673634b2e} [13:39:44.666] tuple_ctid = {ip_blkid = {bi_hi = 14768, bi_lo = 8483}, ip_posid = 8} [13:39:44.666] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83d920118} [13:39:44.666] node = 0x8374514a0 [13:39:44.666] estate = 0x837451100 [13:39:44.666] operation = CMD_MERGE [13:39:44.666] resultRelInfo = 0x8374516b0 [13:39:44.666] subplanstate = 0x837452df0 [13:39:44.666] slot = [13:39:44.666] tupleid = 0x0 [13:39:44.666] oldtuple = 0x8212338e0 [13:39:44.666] oldSlot = [13:39:44.666] #9 0x000000000076030b in ExecProcNode (node=0x8374514a0) at ../src/include/executor/executor.h:278 [13:39:44.666] No locals. [13:39:44.666] #10 ExecutePlan (estate=0x837451100, planstate=0x8374514a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x837321b10, execute_once=) at ../src/backend/executor/execMain.c:1641 [13:39:44.666] current_tuple_count = 0 [13:39:44.666] slot = [13:39:44.666] #11 standard_ExecutorRun (queryDesc=0x837370c48, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [13:39:44.666] estate = 0x837451100 [13:39:44.666] oldcontext = 0x837321800 [13:39:44.666] operation = CMD_MERGE [13:39:44.666] dest = 0x837321b10 [13:39:44.666] sendTuples = true [13:39:44.666] #12 0x000000083ac08961 in pgss_ExecutorRun (queryDesc=0x837370c48, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [13:39:44.666] _local_sigjmp_buf = {{_sjb = {35345434929, 1, 34915695288, 34915695456, 12339864, 34915695296, 1, 35286092872, 34915681151, 7810657, 35287011328, 34359738368}}} [13:39:44.666] _save_exception_stack = 0x821233c70 [13:39:44.666] _save_context_stack = 0x0 [13:39:44.666] _do_rethrow = false [13:39:44.666] #13 0x000000000093525f in ProcessQuery (plan=0x83da57b00, sourceText=, params=0x0, queryEnv=0x0, dest=0x837321b10, qc=0x821233c38) at ../src/backend/tcop/pquery.c:160 [13:39:44.666] queryDesc = 0x837370c48 [13:39:44.666] #14 0x00000000009347fd in PortalRunMulti (portal=portal@entry=0x8373b9100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x837321b10, altdest=0xb7b8c0 , qc=qc@entry=0x821233c38) at ../src/backend/tcop/pquery.c:1287 [13:39:44.666] pstmt = 0x83da57b00 [13:39:44.666] stmtlist_item__state = {l = 0x83da5c3b8, i = 0} [13:39:44.666] active_snapshot_set = true [13:39:44.666] stmtlist_item = 0x83da5c3d0 [13:39:44.666] #15 0x000000000093430c in FillPortalStore (portal=portal@entry=0x8373b9100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [13:39:44.666] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:39:44.666] treceiver = 0x837321b10 [13:39:44.666] #16 0x000000000093407b in PortalRun (portal=portal@entry=0x8373b9100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83da5c408, altdest=altdest@entry=0x83da5c408, qc=0x821233d70) at ../src/backend/tcop/pquery.c:763 [13:39:44.666] _local_sigjmp_buf = {{_sjb = {9650205, 35286388992, 34915695720, 34915695952, 34915695728, 35286482944, 12306536, 12339864, 35286352767, 35285709056, 4294967984, 0}}} [13:39:44.666] _save_exception_stack = 0x821233e40 [13:39:44.666] _save_context_stack = 0x0 [13:39:44.666] _do_rethrow = false [13:39:44.666] saveTopTransactionResourceOwner = 0x837407418 [13:39:44.666] saveTopTransactionContext = 0x8373d0000 [13:39:44.666] saveActivePortal = 0x0 [13:39:44.666] saveResourceOwner = 0x837407418 [13:39:44.666] savePortalContext = 0x0 [13:39:44.666] saveMemoryContext = 0x8373d0000 [13:39:44.666] result = [13:39:44.666] nprocessed = [13:39:44.666] #17 0x0000000000932f42 in exec_simple_query (query_string=query_string@entry=0x837313100 "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 [13:39:44.666] cmdtaglen = 5 [13:39:44.666] snapshot_set = [13:39:44.666] per_parsetree_context = 0x0 [13:39:44.666] plantree_list = [13:39:44.666] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:39:44.666] format = 0 [13:39:44.666] parsetree = 0x83da0e968 [13:39:44.666] commandTag = [13:39:44.666] cmdtagname = [13:39:44.666] querytree_list = [13:39:44.666] portal = 0x8373b9100 [13:39:44.666] receiver = 0x83da5c408 [13:39:44.666] parsetree_item__state = {l = 0x83da10230, i = 0} [13:39:44.666] msec_str = "\000\000\000\000\b", '\000' , "\317\371\336f\000\000\000\000\220$\354lWu$\177" [13:39:44.666] dest = DestRemote [13:39:44.666] was_logged = [13:39:44.666] oldcontext = 0x8373d0000 [13:39:44.666] parsetree_list = 0x83da10230 [13:39:44.666] use_implicit_block = false [13:39:44.666] parsetree_item = 0x83da10248 [13:39:44.666] save_log_statement_stats = [13:39:44.666] #18 0x0000000000930cb0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [13:39:44.666] query_string = 0x837313100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [13:39:44.666] input_message = {data = 0x837313100 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [13:39:44.666] firstchar = [13:39:44.666] local_sigjmp_buf = {{_sjb = {9634118, 34915696192, 34915696152, 34915696736, 12348600, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [13:39:44.666] send_ready_for_query = false [13:39:44.666] idle_in_transaction_timeout_enabled = false [13:39:44.666] idle_session_timeout_enabled = false [13:39:44.666] #19 0x000000000092b489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:39:44.666] bsdata = [13:39:44.666] #20 0x0000000000885627 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821234b84 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821234ac0) at ../src/backend/postmaster/launch_backend.c:274 [13:39:44.666] pid = [13:39:44.666] #21 0x00000000008899e8 in BackendStartup (client_sock=0x821234ac0) at ../src/backend/postmaster/postmaster.c:3415 [13:39:44.666] startup_data = {canAcceptConnections = CAC_OK} [13:39:44.666] bn = 0x83731f588 [13:39:44.666] pid = [13:39:44.666] __error = [13:39:44.666] save_errno = [13:39:44.666] __error = [13:39:44.666] __error = [13:39:44.666] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [13:39:44.666] 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 = " <17\b", '\000' , " K#!\b\000\000\000h5\a*\b\000\000\000\v\000\000\000\000\000\000\000^\277\a*\b", '\000' , "`K#!\b\000\000\000\324S\210\000\000\000\000\000pK#!\b", '\000' }, salen = 16}} [13:39:44.666] i = 0 [13:39:44.666] now = [13:39:44.666] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 719391874, events = 8, fd = 0, user_data = 0x821234a70}, {pos = 926397912, events = 8, fd = 555960576, user_data = 0x0}, {pos = -627858678, events = 12199, fd = 718559136, user_data = 0x82ad56d78}, {pos = 555959672, events = 8, fd = 555959792, user_data = 0x821234578}, {pos = -627858678, events = 12199, fd = 718537608, user_data = 0x82ad56d78}, {pos = 555959720, events = 8, fd = 555959840, user_data = 0x8212345a8}, {pos = 718598548, events = 8, fd = 562148360, user_data = 0x82ad4f194}, {pos = 555959824, events = 8, fd = -627878854, user_data = 0x8212345b0}, {pos = 705106960, events = 8, fd = 720420912, user_data = 0x2fa7da93a30a}, {pos = 718506072, events = 8, fd = 718630264, user_data = 0x821234618}, {pos = 555959952, events = 8, fd = 555959832, user_data = 0x82ad4dd0c}, {pos = 562148360, events = 8, fd = 718593292, user_data = 0x821234680}, {pos = -627878854, events = 12199, fd = 555959976, user_data = 0x821234878}, {pos = 555959952, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821821038}, {pos = 1, events = 1147055430, fd = 562148360, user_data = 0x82ad40388}, {pos = 562169800, events = 8, fd = 0, user_data = 0x0}, {pos = 555960088, events = 8, fd = 555960552, user_data = 0x821234700}, {pos = -627860318, events = 12199, fd = 2699735, user_data = 0x6d68b}, {pos = 2090263927, events = 1147055430, fd = 562171960, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8212349e8}, {pos = 562148360, events = 3, fd = 555960624, user_data = 0x821820828}, {pos = 656, events = 0, fd = 555960552, user_data = 0x821234718}, {pos = 555960192, events = 8, fd = -627860709, user_data = 0x8212348b0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 562171960, events = 8, fd = 1, user_data = 0x82181b408}, {pos = 718506072, events = 8, fd = 555960808, user_data = 0x821234930}, {pos = 555960208, events = 8, fd = 0, user_data = 0x821814008}, {pos = 33, events = 0, fd = 555960608, user_data = 0x2fa7da933ae7}, {pos = 562118664, events = 8, fd = 562119688, user_data = 0x821814808}, {pos = 562121736, events = 8, fd = 562135048, user_data = 0x821818408}, {pos = 562137096, events = 8, fd = 562138120, user_data = 0x821819008}, {pos = 562140168, events = 8, fd = 562141192, user_data = 0x821819c08}, {pos = 562143240, events = 8, fd = 562144264, user_data = 0x82181a808}, {pos = 562146312, events = 8, fd = 562147336, user_data = 0x82181b408}, {pos = 562149384, events = 8, fd = 562150408, user_data = 0x82181c008}, {pos = 562152456, events = 8, fd = 562153480, user_data = 0x82181cc08}, {pos = 562155528, events = 8, fd = 562156552, user_data = 0x82181d808}, {pos = 562158600, events = 8, fd = 562163720, user_data = 0x82181f408}, {pos = 562165768, events = 8, fd = 562166792, user_data = 0x821822408}, {pos = 166501000, events = 0, fd = 562118664, user_data = 0x2931d7}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821821038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555960808, events = 8, fd = 555960208, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 562171960, user_data = 0x1}, {pos = 562118664, events = 8, fd = 313, user_data = 0x8212349d0}, {pos = -627886609, events = 12199, fd = 2699735, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 562171960, user_data = 0x1}, {pos = 562148360, events = 8, fd = 925904896, user_data = 0x1}, {pos = 925905300, events = 8, fd = 0, user_data = 0x8212349a0}, {pos = 705148268, events = 8, fd = 1, user_data = 0x837303000}, {pos = 555960784, events = 8, fd = 705144578, user_data = 0x82ae6a170 }, {pos = 12273632, events = 0, fd = 719757680, user_data = 0x82181b408}, {pos = 555961008, events = 8, fd = -627887138, user_data = 0x837321800}, {pos = 1, events = 0, fd = -627887522, user_data = 0x821814008}, {pos = 555960792, events = 8, fd = 555961008, user_data = 0x1c20}, {pos = 925973536, events = 8, fd = -627807856, user_data = 0x0}, {pos = 555942783, events = 8, fd = 8087223, user_data = 0x821234a60}, {pos = 705106960, events = 8, fd = 720420912, user_data = 0x82af0e310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821234a90}, {pos = 705149853, events = 8, fd = 925904896, user_data = 0x3219}, {pos = 555961072, events = 8, fd = 705116410, user_data = 0x0}, {pos = 0, events = 0, fd = 1935887150, user_data = 0x0}} [13:39:44.666] last_touch_time = 1725888964 [13:39:44.666] last_lockfile_recheck_time = 1725888964 [13:39:44.666] nevents = 1 [13:39:44.666] #23 0x0000000000887805 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8212350d0) at ../src/backend/postmaster/postmaster.c:1346 [13:39:44.666] userDoption = [13:39:44.666] listen_addr_saved = [13:39:44.666] output_config_variable = [13:39:44.666] opt = [13:39:44.666] status = [13:39:44.666] #24 0x00000000007c339c in main (argc=4, argv=0x8212350d0) at ../src/backend/main/main.c:197 [13:39:44.666] do_check_root =