[10:22:11.814] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [10:22:12.155] dumping /tmp/cores/postgres.7938.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [10:22:12.282] [New LWP 101689] [10:22:12.365] Core was generated by `postgres: postgres regression [local] MERGE'. [10:22:12.365] Program terminated with signal SIGABRT, Aborted. [10:22:12.365] Sent by thr_kill() from pid 7938 and user 1003. [10:22:12.365] #0 0x000000082a4b141a in thr_kill () from /lib/libc.so.7 [10:22:12.940] [10:22:12.940] Thread 1 (LWP 101689): [10:22:12.940] #0 0x000000082a4b141a in thr_kill () from /lib/libc.so.7 [10:22:12.940] No symbol table info available. [10:22:12.940] #1 0x000000082a42ae64 in raise () from /lib/libc.so.7 [10:22:12.940] No symbol table info available. [10:22:12.940] #2 0x000000082a4db6f9 in abort () from /lib/libc.so.7 [10:22:12.940] No symbol table info available. [10:22:12.940] #3 0x0000000000a5e0b5 in ExceptionalCondition (conditionName=0x2d0bde "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [10:22:12.940] No locals. [10:22:12.940] #4 0x000000000074036f in ExecFetchSlotHeapTuple (slot=0x821086600, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [10:22:12.940] No locals. [10:22:12.940] #5 0x0000000000705027 in ExecIRDeleteTriggers (estate=estate@entry=0x83703e100, relinfo=relinfo@entry=0x83703e6b0, slot=slot@entry=0x821086600) at ../src/backend/commands/trigger.c:2841 [10:22:12.940] trigger = [10:22:12.940] oldtuple = [10:22:12.940] should_free = false [10:22:12.940] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83707e790, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [10:22:12.940] trigdesc = 0x83703e8c0 [10:22:12.940] newtuple = 0x0 [10:22:12.940] i = 0 [10:22:12.940] #6 0x0000000000765547 in ExecMergeMatched (context=0x8210866a8, resultRelInfo=0x83703e6b0, tupleid=0x0, oldtuple=0x821086600, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [10:22:12.940] result = TM_Ok [10:22:12.940] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [10:22:12.940] relaction = 0x8371b63f8 [10:22:12.940] commandType = CMD_DELETE [10:22:12.940] l__state = {l = 0x8371b69b8, i = 0} [10:22:12.940] mtstate = 0x83703e4a0 [10:22:12.940] newslot = 0x0 [10:22:12.940] rslot = 0x0 [10:22:12.940] estate = 0x83703e100 [10:22:12.940] mergeActions = [10:22:12.940] econtext = 0x8371b5a28 [10:22:12.940] epqstate = 0x83703e588 [10:22:12.940] actionStates = 0x8371b69b8 [10:22:12.940] l = [10:22:12.940] isNull = [10:22:12.940] lmerge_matched = [10:22:12.940] __error = [10:22:12.940] l__state = [10:22:12.940] result = [10:22:12.940] updateCxt = [10:22:12.940] relaction = [10:22:12.940] commandType = [10:22:12.940] __error = [10:22:12.940] resultRelationDesc = [10:22:12.940] lockmode = [10:22:12.940] inputslot = [10:22:12.940] epqslot = [10:22:12.940] was_matched = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] #7 ExecMerge (context=0x8210866a8, resultRelInfo=0x83703e6b0, tupleid=0x0, oldtuple=0x821086600, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [10:22:12.940] matched = [10:22:12.940] rslot = 0x0 [10:22:12.940] #8 ExecModifyTable (pstate=0x83703e4a0) at ../src/backend/executor/nodeModifyTable.c:4133 [10:22:12.940] context = {mtstate = 0x83703e4a0, epqstate = 0x83703e588, estate = 0x83703e100, planSlot = 0x8370e1cf0, tmfd = {ctid = {ip_blkid = {bi_hi = 13560, bi_lo = 14110}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x83703e6b0} [10:22:12.940] tuple_ctid = {ip_blkid = {bi_hi = 14384, bi_lo = 14210}, ip_posid = 8} [10:22:12.940] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8370c4118} [10:22:12.940] node = 0x83703e4a0 [10:22:12.940] estate = 0x83703e100 [10:22:12.940] operation = CMD_MERGE [10:22:12.940] resultRelInfo = 0x83703e6b0 [10:22:12.940] subplanstate = 0x83703fdf0 [10:22:12.940] slot = [10:22:12.940] tupleid = 0x0 [10:22:12.940] oldtuple = 0x821086600 [10:22:12.940] oldSlot = [10:22:12.940] #9 0x00000000007325db in ExecProcNode (node=0x83703e4a0) at ../src/include/executor/executor.h:278 [10:22:12.940] No locals. [10:22:12.940] #10 ExecutePlan (estate=0x83703e100, planstate=0x83703e4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x835bcc310, execute_once=) at ../src/backend/executor/execMain.c:1641 [10:22:12.940] current_tuple_count = 0 [10:22:12.940] slot = [10:22:12.940] #11 standard_ExecutorRun (queryDesc=0x835a84c48, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [10:22:12.940] estate = 0x83703e100 [10:22:12.940] oldcontext = 0x835bcc000 [10:22:12.940] operation = CMD_MERGE [10:22:12.940] dest = 0x835bcc310 [10:22:12.940] sendTuples = true [10:22:12.940] #12 0x000000000090963f in ProcessQuery (plan=0x8371e2de0, sourceText=, params=0x0, queryEnv=0x0, dest=0x835bcc310, qc=0x8210868a8) at ../src/backend/tcop/pquery.c:160 [10:22:12.940] queryDesc = 0x835a84c48 [10:22:12.940] #13 0x0000000000908bdd in PortalRunMulti (portal=portal@entry=0x835b03100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x835bcc310, altdest=0xb4ff00 , qc=qc@entry=0x8210868a8) at ../src/backend/tcop/pquery.c:1287 [10:22:12.940] pstmt = 0x8371e2de0 [10:22:12.940] stmtlist_item__state = {l = 0x8371e7698, i = 0} [10:22:12.940] active_snapshot_set = true [10:22:12.940] stmtlist_item = 0x8371e76b0 [10:22:12.940] #14 0x00000000009086ec in FillPortalStore (portal=portal@entry=0x835b03100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [10:22:12.940] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:22:12.940] treceiver = 0x835bcc310 [10:22:12.940] #15 0x000000000090845b in PortalRun (portal=portal@entry=0x835b03100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8371e76e8, altdest=altdest@entry=0x8371e76e8, qc=0x8210869e0) at ../src/backend/tcop/pquery.c:763 [10:22:12.940] _local_sigjmp_buf = {{_sjb = {9470973, 35260477696, 34913937624, 34913937856, 34913937632, 35260497920, 12127640, 12160952, 35260466047, 35259605248, 4294967984, 0}}} [10:22:12.940] _save_exception_stack = 0x821086ab0 [10:22:12.940] _save_context_stack = 0x0 [10:22:12.940] _do_rethrow = false [10:22:12.940] saveTopTransactionResourceOwner = 0x835b10e18 [10:22:12.940] saveTopTransactionContext = 0x835b08000 [10:22:12.940] saveActivePortal = 0x0 [10:22:12.940] saveResourceOwner = 0x835b10e18 [10:22:12.940] savePortalContext = 0x0 [10:22:12.940] saveMemoryContext = 0x835b08000 [10:22:12.940] result = [10:22:12.940] nprocessed = [10:22:12.940] #16 0x0000000000907322 in exec_simple_query (query_string=query_string@entry=0x835a2e100 "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 [10:22:12.940] cmdtaglen = 5 [10:22:12.940] snapshot_set = [10:22:12.940] per_parsetree_context = 0x0 [10:22:12.940] plantree_list = [10:22:12.940] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:22:12.940] format = 0 [10:22:12.940] parsetree = 0x8371839e8 [10:22:12.940] commandTag = [10:22:12.940] cmdtagname = [10:22:12.940] querytree_list = [10:22:12.940] portal = 0x835b03100 [10:22:12.940] receiver = 0x8371e76e8 [10:22:12.940] parsetree_item__state = {l = 0x8371852b0, i = 0} [10:22:12.940] msec_str = "\000\000\000\000\b", '\000' , "\337a\310f\000\000\000\000\365k\320\377\333\373\026\204" [10:22:12.940] dest = DestRemote [10:22:12.940] was_logged = [10:22:12.940] oldcontext = 0x835b08000 [10:22:12.940] parsetree_list = 0x8371852b0 [10:22:12.940] use_implicit_block = false [10:22:12.940] parsetree_item = 0x8371852c8 [10:22:12.940] save_log_statement_stats = [10:22:12.940] #17 0x0000000000905090 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [10:22:12.940] query_string = 0x835a2e100 "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"... [10:22:12.940] input_message = {data = 0x835a2e100 "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} [10:22:12.940] firstchar = [10:22:12.940] local_sigjmp_buf = {{_sjb = {9454886, 34913938096, 34913938056, 34913938640, 12169688, 1, 8192, 8388608, 34913911679, 0, 0, 1}}} [10:22:12.940] send_ready_for_query = false [10:22:12.940] idle_in_transaction_timeout_enabled = false [10:22:12.940] idle_session_timeout_enabled = false [10:22:12.940] #18 0x00000000008ff869 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:22:12.940] bsdata = [10:22:12.940] #19 0x0000000000859a87 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8210877f4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821087730) at ../src/backend/postmaster/launch_backend.c:274 [10:22:12.940] pid = [10:22:12.940] #20 0x000000000085de48 in BackendStartup (client_sock=0x821087730) at ../src/backend/postmaster/postmaster.c:3414 [10:22:12.940] startup_data = {canAcceptConnections = CAC_OK} [10:22:12.940] bn = 0x835a3a1c8 [10:22:12.940] pid = [10:22:12.940] __error = [10:22:12.940] save_errno = [10:22:12.940] __error = [10:22:12.940] __error = [10:22:12.940] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [10:22:12.940] 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\377\2425\b", '\000' , "\220w\b!\b\000\000\000h\225\371(\b\000\000\000\v\000\000\000\000\000\000\000^\037\372(\b", '\000' , "\320w\b!\b\000\000\0004\230\205\000\000\000\000\000\340w\b!\b", '\000' }, salen = 16}} [10:22:12.940] i = 0 [10:22:12.940] now = [10:22:12.940] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 709188738, events = 8, fd = 0, user_data = 0x8210876e0}, {pos = 900265432, events = 8, fd = 554202480, user_data = 0x0}, {pos = 0, events = 0, fd = 1411913174, user_data = 0x345f9d92a30a}, {pos = 708356000, events = 8, fd = 708427128, user_data = 0x8210871f8}, {pos = 554201712, events = 8, fd = 554201592, user_data = 0x345f9d92a30a}, {pos = 708334472, events = 8, fd = 708427128, user_data = 0x821087228}, {pos = 554201760, events = 8, fd = 554201640, user_data = 0x82a394194}, {pos = 560022536, events = 8, fd = 708395412, user_data = 0x821087290}, {pos = -1651354566, events = 13407, fd = 710217776, user_data = 0x1}, {pos = 554201792, events = 8, fd = -1651334390, user_data = 0x82a37d858}, {pos = 708427128, events = 8, fd = 554201752, user_data = 0x821087310}, {pos = 554201752, events = 8, fd = 708390156, user_data = 0x821614408}, {pos = 708390156, events = 8, fd = 554201856, user_data = 0x345f9d92543a}, {pos = 554201896, events = 8, fd = 554202344, user_data = 0x821087310}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2718353940, fd = 560046136, user_data = 0x800000001}, {pos = 560022536, events = 8, fd = 708334472, user_data = 0x821619288}, {pos = 708302936, events = 8, fd = 560022536, user_data = 0x821087398}, {pos = 554202456, events = 8, fd = 554201984, user_data = 0x345f9d929ca2}, {pos = 2699999, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560046136, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554202712, user_data = 0x21614408}, {pos = 554202528, events = 8, fd = 554202128, user_data = 0x1}, {pos = 554202456, events = 8, fd = 32, user_data = 0x821087400}, {pos = -1651336589, events = 13407, fd = 554202400, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82161a038}, {pos = 1, events = 8, fd = 560022536, user_data = 0x82a37d858}, {pos = 554202712, events = 8, fd = 554202528, user_data = 0x821087410}, {pos = 0, events = 0, fd = 559992840, user_data = 0x20}, {pos = 554202512, events = 8, fd = -1651361049, user_data = 0x82160d008}, {pos = 559993864, events = 8, fd = 559994888, user_data = 0x82160dc08}, {pos = 560009224, events = 8, fd = 560010248, user_data = 0x821611808}, {pos = 560012296, events = 8, fd = 560013320, user_data = 0x821612408}, {pos = 560015368, events = 8, fd = 560016392, user_data = 0x821613008}, {pos = 560018440, events = 8, fd = 560019464, user_data = 0x821613c08}, {pos = 560021512, events = 8, fd = 560022536, user_data = 0x821614808}, {pos = 560024584, events = 8, fd = 560025608, user_data = 0x821615408}, {pos = 560027656, events = 8, fd = 560028680, user_data = 0x821616008}, {pos = 560030728, events = 8, fd = 560031752, user_data = 0x821616c08}, {pos = 560037896, events = 8, fd = 560038920, user_data = 0x821618808}, {pos = 560040968, events = 8, fd = 559992840, user_data = 0x2932df}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82161a038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554202712, events = 8, fd = 554202128, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560046136, user_data = 0x1}, {pos = 559992840, events = 8, fd = 314, user_data = 0x821087640}, {pos = -1651362321, events = 13407, fd = 2699999, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560046136, user_data = 0x1}, {pos = 560022536, events = 8, fd = 899801088, user_data = 0x1}, {pos = 899801492, events = 8, fd = 0, user_data = 0x821087610}, {pos = 687478124, events = 8, fd = 1, user_data = 0x835a1e000}, {pos = 554202688, events = 8, fd = 687474434, user_data = 0x82a4af170 }, {pos = 12094728, events = 0, fd = 709554544, user_data = 0x821614408}, {pos = 554202912, events = 8, fd = -1651362850, user_data = 0x835a3c800}, {pos = 1, events = 8, fd = -1651363234, user_data = 0x82160d008}, {pos = 554202696, events = 8, fd = 554202912, user_data = 0x1c38}, {pos = 899874560, events = 8, fd = -1651283568, user_data = 0x0}, {pos = 554173311, events = 8, fd = 7899223, user_data = 0x8210876d0}, {pos = 687436816, events = 8, fd = 710217776, user_data = 0x82a553310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821087700}, {pos = 687479709, events = 8, fd = 899801088, user_data = 0x176d}, {pos = 554202976, events = 8, fd = 687446266, user_data = 0x0}, {pos = 0, events = 0, fd = 1411913174, user_data = 0x0}} [10:22:12.941] last_touch_time = 1724408277 [10:22:12.941] last_lockfile_recheck_time = 1724408277 [10:22:12.941] nevents = 1 [10:22:12.941] #22 0x000000000085bc65 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821087d48) at ../src/backend/postmaster/postmaster.c:1346 [10:22:12.941] userDoption = [10:22:12.941] listen_addr_saved = [10:22:12.941] output_config_variable = [10:22:12.941] opt = [10:22:12.941] status = [10:22:12.941] #23 0x000000000079555c in main (argc=8, argv=0x821087d48) at ../src/backend/main/main.c:197 [10:22:12.941] do_check_root = [10:22:12.953] [10:22:12.953] [10:22:12.953] [10:22:13.018] dumping /tmp/cores/postgres.8120.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:22:13.141] [New LWP 101715] [10:22:13.209] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [10:22:13.209] Program terminated with signal SIGABRT, Aborted. [10:22:13.209] Sent by thr_kill() from pid 8120 and user 1003. [10:22:13.209] #0 0x000000082c24d41a in thr_kill () from /lib/libc.so.7 [10:22:13.754] [10:22:13.754] Thread 1 (LWP 101715): [10:22:13.754] #0 0x000000082c24d41a in thr_kill () from /lib/libc.so.7 [10:22:13.754] No symbol table info available. [10:22:13.754] #1 0x000000082c1c6e64 in raise () from /lib/libc.so.7 [10:22:13.754] No symbol table info available. [10:22:13.754] #2 0x000000082c2776f9 in abort () from /lib/libc.so.7 [10:22:13.754] No symbol table info available. [10:22:13.754] #3 0x0000000000a5e0b5 in ExceptionalCondition (conditionName=0x2d0bde "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [10:22:13.754] No locals. [10:22:13.754] #4 0x000000000074036f in ExecFetchSlotHeapTuple (slot=0x8219ce050, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [10:22:13.754] No locals. [10:22:13.754] #5 0x0000000000705027 in ExecIRDeleteTriggers (estate=estate@entry=0x835d84100, relinfo=relinfo@entry=0x835d846b0, slot=slot@entry=0x8219ce050) at ../src/backend/commands/trigger.c:2841 [10:22:13.754] trigger = [10:22:13.754] oldtuple = [10:22:13.754] should_free = false [10:22:13.754] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84204a880, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [10:22:13.754] trigdesc = 0x835d848c0 [10:22:13.754] newtuple = 0x0 [10:22:13.754] i = 0 [10:22:13.754] #6 0x0000000000765547 in ExecMergeMatched (context=0x8219ce0f8, resultRelInfo=0x835d846b0, tupleid=0x0, oldtuple=0x8219ce050, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [10:22:13.754] result = TM_Ok [10:22:13.754] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [10:22:13.754] relaction = 0x84215b638 [10:22:13.754] commandType = CMD_DELETE [10:22:13.754] l__state = {l = 0x84215bbf8, i = 0} [10:22:13.754] mtstate = 0x835d844a0 [10:22:13.754] newslot = 0x0 [10:22:13.754] rslot = 0x0 [10:22:13.754] estate = 0x835d84100 [10:22:13.754] mergeActions = [10:22:13.754] econtext = 0x84215ac68 [10:22:13.754] epqstate = 0x835d84588 [10:22:13.754] actionStates = 0x84215bbf8 [10:22:13.754] l = [10:22:13.754] isNull = [10:22:13.754] lmerge_matched = [10:22:13.754] __error = [10:22:13.754] l__state = [10:22:13.754] result = [10:22:13.754] updateCxt = [10:22:13.754] relaction = [10:22:13.754] commandType = [10:22:13.754] __error = [10:22:13.754] resultRelationDesc = [10:22:13.754] lockmode = [10:22:13.754] inputslot = [10:22:13.754] epqslot = [10:22:13.754] was_matched = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] #7 ExecMerge (context=0x8219ce0f8, resultRelInfo=0x835d846b0, tupleid=0x0, oldtuple=0x8219ce050, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [10:22:13.754] matched = [10:22:13.754] rslot = 0x0 [10:22:13.754] #8 ExecModifyTable (pstate=0x835d844a0) at ../src/backend/executor/nodeModifyTable.c:4133 [10:22:13.754] context = {mtstate = 0x835d844a0, epqstate = 0x835d84588, estate = 0x835d84100, planSlot = 0x842082df0, tmfd = {ctid = {ip_blkid = {bi_hi = 34488, bi_lo = 16920}, ip_posid = 8}, xmax = 10, cmax = 5, traversed = 2}, cpUpdateReturningSlot = 0x835d846b0} [10:22:13.754] tuple_ctid = {ip_blkid = {bi_hi = 54416, bi_lo = 17119}, ip_posid = 8} [10:22:13.754] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x84205c118} [10:22:13.754] node = 0x835d844a0 [10:22:13.754] estate = 0x835d84100 [10:22:13.754] operation = CMD_MERGE [10:22:13.754] resultRelInfo = 0x835d846b0 [10:22:13.754] subplanstate = 0x835d85df0 [10:22:13.754] slot = [10:22:13.754] tupleid = 0x0 [10:22:13.754] oldtuple = 0x8219ce050 [10:22:13.754] oldSlot = [10:22:13.754] #9 0x00000000007325db in ExecProcNode (node=0x835d844a0) at ../src/include/executor/executor.h:278 [10:22:13.754] No locals. [10:22:13.754] #10 ExecutePlan (estate=0x835d84100, planstate=0x835d844a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x835c19310, execute_once=) at ../src/backend/executor/execMain.c:1641 [10:22:13.754] current_tuple_count = 0 [10:22:13.754] slot = [10:22:13.754] #11 standard_ExecutorRun (queryDesc=0x835c3d448, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:358 [10:22:13.754] estate = 0x835d84100 [10:22:13.754] oldcontext = 0x835c19000 [10:22:13.754] operation = CMD_MERGE [10:22:13.754] dest = 0x835c19310 [10:22:13.754] sendTuples = true [10:22:13.754] #12 0x000000000090963f in ProcessQuery (plan=0x842187fa0, sourceText=, params=0x0, queryEnv=0x0, dest=0x835c19310, qc=0x8219ce2f8) at ../src/backend/tcop/pquery.c:160 [10:22:13.754] queryDesc = 0x835c3d448 [10:22:13.754] #13 0x0000000000908bdd in PortalRunMulti (portal=portal@entry=0x835c84100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x835c19310, altdest=0xb4ff00 , qc=qc@entry=0x8219ce2f8) at ../src/backend/tcop/pquery.c:1287 [10:22:13.754] pstmt = 0x842187fa0 [10:22:13.754] stmtlist_item__state = {l = 0x84218c858, i = 0} [10:22:13.754] active_snapshot_set = true [10:22:13.754] stmtlist_item = 0x84218c870 [10:22:13.754] #14 0x00000000009086ec in FillPortalStore (portal=portal@entry=0x835c84100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [10:22:13.754] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:22:13.754] treceiver = 0x835c19310 [10:22:13.754] #15 0x000000000090845b in PortalRun (portal=portal@entry=0x835c84100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x84218c8a8, altdest=altdest@entry=0x84218c8a8, qc=0x8219ce430) at ../src/backend/tcop/pquery.c:763 [10:22:13.754] _local_sigjmp_buf = {{_sjb = {9470973, 35262054656, 34923668264, 34923668496, 34923668272, 35262070784, 12127640, 12160952, 35262038911, 35261382912, 4294967984, 0}}} [10:22:13.754] _save_exception_stack = 0x8219ce500 [10:22:13.754] _save_context_stack = 0x0 [10:22:13.754] _do_rethrow = false [10:22:13.754] saveTopTransactionResourceOwner = 0x835ccbe58 [10:22:13.754] saveTopTransactionContext = 0x835c88000 [10:22:13.754] saveActivePortal = 0x0 [10:22:13.754] saveResourceOwner = 0x835ccbe58 [10:22:13.754] savePortalContext = 0x0 [10:22:13.754] saveMemoryContext = 0x835c88000 [10:22:13.754] result = [10:22:13.754] nprocessed = [10:22:13.754] #16 0x0000000000907322 in exec_simple_query (query_string=query_string@entry=0x835be0100 "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 [10:22:13.754] cmdtaglen = 5 [10:22:13.754] snapshot_set = [10:22:13.754] per_parsetree_context = 0x0 [10:22:13.754] plantree_list = [10:22:13.754] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:22:13.754] format = 0 [10:22:13.754] parsetree = 0x842129728 [10:22:13.754] commandTag = [10:22:13.754] cmdtagname = [10:22:13.754] querytree_list = [10:22:13.754] portal = 0x835c84100 [10:22:13.754] receiver = 0x84218c8a8 [10:22:13.754] parsetree_item__state = {l = 0x84212aff0, i = 0} [10:22:13.754] msec_str = "\000\000\000\000\b", '\000' , "\340a\310f\000\000\000\000\345\351\241\r\306{\237", [10:22:13.754] dest = DestRemote [10:22:13.754] was_logged = [10:22:13.754] oldcontext = 0x835c88000 [10:22:13.754] parsetree_list = 0x84212aff0 [10:22:13.754] use_implicit_block = false [10:22:13.754] parsetree_item = 0x84212b008 [10:22:13.754] save_log_statement_stats = [10:22:13.754] #17 0x0000000000905090 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [10:22:13.754] query_string = 0x835be0100 "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"... [10:22:13.754] input_message = {data = 0x835be0100 "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} [10:22:13.754] firstchar = [10:22:13.754] local_sigjmp_buf = {{_sjb = {9454886, 34923668736, 34923668696, 34923669280, 12169688, 1, 8192, 8388608, 34923611007, 0, 0, 1}}} [10:22:13.754] send_ready_for_query = false [10:22:13.754] idle_in_transaction_timeout_enabled = false [10:22:13.754] idle_session_timeout_enabled = false [10:22:13.754] #18 0x00000000008ff869 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:22:13.754] bsdata = [10:22:13.754] #19 0x0000000000859a87 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8219cf244 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8219cf180) at ../src/backend/postmaster/launch_backend.c:274 [10:22:13.754] pid = [10:22:13.754] #20 0x000000000085de48 in BackendStartup (client_sock=0x8219cf180) at ../src/backend/postmaster/postmaster.c:3414 [10:22:13.754] startup_data = {canAcceptConnections = CAC_OK} [10:22:13.754] bn = 0x835bec088 [10:22:13.754] pid = [10:22:13.754] __error = [10:22:13.754] save_errno = [10:22:13.754] __error = [10:22:13.754] __error = [10:22:13.754] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [10:22:13.754] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\300\036\2765\b", '\000' , "\340\361\234!\b\000\000\000h\245!+\b\000\000\000\v\000\000\000\000\000\000\000^/\"+\b", '\000' , " \362\234!\b\000\000\0004\230\205\000\000\000\000\0000\362\234!\b", '\000' }, salen = 16}} [10:22:13.754] i = 0 [10:22:13.754] now = [10:22:13.754] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 740236418, events = 8, fd = 0, user_data = 0x8219cf130}, {pos = 902071768, events = 8, fd = 563933120, user_data = 0x0}, {pos = 0, events = 0, fd = -1656539475, user_data = 0x3c01c734c30a}, {pos = 739403680, events = 8, fd = 739474808, user_data = 0x8219cec48}, {pos = 563932352, events = 8, fd = 563932232, user_data = 0x3c01c734c30a}, {pos = 739382152, events = 8, fd = 739474808, user_data = 0x8219cec78}, {pos = 563932400, events = 8, fd = 563932280, user_data = 0x82c130194}, {pos = 569160712, events = 8, fd = 739443092, user_data = 0x8219cece0}, {pos = -952863686, events = 15361, fd = 741265456, user_data = 0x1}, {pos = 563932432, events = 8, fd = -952843510, user_data = 0x82c119858}, {pos = 739474808, events = 8, fd = 563932392, user_data = 0x8219ced60}, {pos = 563932392, events = 8, fd = 739437836, user_data = 0x821ecb408}, {pos = 739437836, events = 8, fd = 563932496, user_data = 0x3c01c734743a}, {pos = 563932536, events = 8, fd = 563932984, user_data = 0x8219ced60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1282199442, fd = 569184312, user_data = 0x800000001}, {pos = 569160712, events = 8, fd = 739382152, user_data = 0x821ed0288}, {pos = 739350616, events = 8, fd = 569160712, user_data = 0x8219cede8}, {pos = 563933096, events = 8, fd = 563932624, user_data = 0x3c01c734bca2}, {pos = 2699999, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 569184312, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 563933352, user_data = 0x21ecb408}, {pos = 563933168, events = 8, fd = 563932768, user_data = 0x1}, {pos = 563933096, events = 8, fd = 32, user_data = 0x8219cee50}, {pos = -952845709, events = 15361, fd = 563933040, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821ed1038}, {pos = 1, events = 8, fd = 569160712, user_data = 0x82c119858}, {pos = 563933352, events = 8, fd = 563933168, user_data = 0x8219cee60}, {pos = 0, events = 0, fd = 569131016, user_data = 0x20}, {pos = 563933152, events = 8, fd = -952870169, user_data = 0x821ec4008}, {pos = 569132040, events = 8, fd = 569133064, user_data = 0x821ec4c08}, {pos = 569147400, events = 8, fd = 569148424, user_data = 0x821ec8808}, {pos = 569150472, events = 8, fd = 569151496, user_data = 0x821ec9408}, {pos = 569153544, events = 8, fd = 569154568, user_data = 0x821eca008}, {pos = 569156616, events = 8, fd = 569157640, user_data = 0x821ecac08}, {pos = 569159688, events = 8, fd = 569160712, user_data = 0x821ecb808}, {pos = 569162760, events = 8, fd = 569163784, user_data = 0x821ecc408}, {pos = 569165832, events = 8, fd = 569166856, user_data = 0x821ecd008}, {pos = 569168904, events = 8, fd = 569169928, user_data = 0x821ecdc08}, {pos = 569176072, events = 8, fd = 569177096, user_data = 0x821ecf808}, {pos = 569179144, events = 8, fd = 569131016, user_data = 0x2932df}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821ed1038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 563933352, events = 8, fd = 563932768, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 569184312, user_data = 0x1}, {pos = 569131016, events = 8, fd = 314, user_data = 0x8219cf090}, {pos = -952871441, events = 15361, fd = 2699999, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 569184312, user_data = 0x1}, {pos = 569160712, events = 8, fd = 901578752, user_data = 0x1}, {pos = 901579156, events = 8, fd = 0, user_data = 0x8219cf060}, {pos = 723658092, events = 8, fd = 1, user_data = 0x835bd0000}, {pos = 563933328, events = 8, fd = 723654402, user_data = 0x82c24b170 }, {pos = 12094728, events = 0, fd = 740602224, user_data = 0x821ecb408}, {pos = 563933552, events = 8, fd = -952871970, user_data = 0x835bee800}, {pos = 1, events = 8, fd = -952872354, user_data = 0x821ec4008}, {pos = 563933336, events = 8, fd = 563933552, user_data = 0x1c38}, {pos = 901652160, events = 8, fd = -952792688, user_data = 0x0}, {pos = 563872639, events = 8, fd = 7899223, user_data = 0x8219cf120}, {pos = 723616784, events = 8, fd = 741265456, user_data = 0x82c2ef310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8219cf150}, {pos = 723659677, events = 8, fd = 901578752, user_data = 0x17af}, {pos = 563933616, events = 8, fd = 723626234, user_data = 0x0}, {pos = 0, events = 0, fd = -1656539475, user_data = 0x0}} [10:22:13.755] last_touch_time = 1724408278 [10:22:13.755] last_lockfile_recheck_time = 1724408278 [10:22:13.755] nevents = 1 [10:22:13.755] #22 0x000000000085bc65 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8219cf798) at ../src/backend/postmaster/postmaster.c:1346 [10:22:13.755] userDoption = [10:22:13.755] listen_addr_saved = [10:22:13.755] output_config_variable = [10:22:13.755] opt = [10:22:13.755] status = [10:22:13.755] #23 0x000000000079555c in main (argc=4, argv=0x8219cf798) at ../src/backend/main/main.c:197 [10:22:13.755] do_check_root = [10:22:13.767] [10:22:13.767] [10:22:13.767] [10:22:13.832] dumping /tmp/cores/postgres.14201.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:22:13.958] [New LWP 101755] [10:22:14.028] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [10:22:14.028] Program terminated with signal SIGABRT, Aborted. [10:22:14.028] Sent by thr_kill() from pid 14201 and user 1003. [10:22:14.028] #0 0x000000082ab5b41a in thr_kill () from /lib/libc.so.7 [10:22:14.583] [10:22:14.583] Thread 1 (LWP 101755): [10:22:14.583] #0 0x000000082ab5b41a in thr_kill () from /lib/libc.so.7 [10:22:14.583] No symbol table info available. [10:22:14.583] #1 0x000000082aad4e64 in raise () from /lib/libc.so.7 [10:22:14.583] No symbol table info available. [10:22:14.583] #2 0x000000082ab856f9 in abort () from /lib/libc.so.7 [10:22:14.583] No symbol table info available. [10:22:14.583] #3 0x0000000000a5e0b5 in ExceptionalCondition (conditionName=0x2d0bde "!TTS_EMPTY(slot)", fileName=, lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [10:22:14.583] No locals. [10:22:14.583] #4 0x000000000074036f in ExecFetchSlotHeapTuple (slot=0x821083fd0, materialize=, shouldFree=) at ../src/backend/executor/execTuples.c:1737 [10:22:14.583] No locals. [10:22:14.583] #5 0x0000000000705027 in ExecIRDeleteTriggers (estate=estate@entry=0x832c57100, relinfo=relinfo@entry=0x832c576b0, slot=slot@entry=0x821083fd0) at ../src/backend/commands/trigger.c:2841 [10:22:14.583] trigger = [10:22:14.583] oldtuple = [10:22:14.583] should_free = false [10:22:14.583] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83a9fab10, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [10:22:14.583] trigdesc = 0x832c578c0 [10:22:14.583] newtuple = 0x0 [10:22:14.583] i = 0 [10:22:14.583] #6 0x0000000000765547 in ExecMergeMatched (context=0x821084078, resultRelInfo=0x832c576b0, tupleid=0x0, oldtuple=0x821083fd0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3043 [10:22:14.583] result = TM_Ok [10:22:14.583] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [10:22:14.583] relaction = 0x83ab6aff8 [10:22:14.583] commandType = CMD_DELETE [10:22:14.583] l__state = {l = 0x83ab6b5b8, i = 0} [10:22:14.583] mtstate = 0x832c574a0 [10:22:14.583] newslot = 0x0 [10:22:14.583] rslot = 0x0 [10:22:14.583] estate = 0x832c57100 [10:22:14.583] mergeActions = [10:22:14.583] econtext = 0x83ab6a628 [10:22:14.583] epqstate = 0x832c57588 [10:22:14.583] actionStates = 0x83ab6b5b8 [10:22:14.583] l = [10:22:14.583] isNull = [10:22:14.583] lmerge_matched = [10:22:14.583] __error = [10:22:14.583] l__state = [10:22:14.583] result = [10:22:14.583] updateCxt = [10:22:14.583] relaction = [10:22:14.583] commandType = [10:22:14.583] __error = [10:22:14.583] resultRelationDesc = [10:22:14.583] lockmode = [10:22:14.583] inputslot = [10:22:14.583] epqslot = [10:22:14.583] was_matched = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] #7 ExecMerge (context=0x821084078, resultRelInfo=0x832c576b0, tupleid=0x0, oldtuple=0x821083fd0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2804 [10:22:14.583] matched = [10:22:14.583] rslot = 0x0 [10:22:14.583] #8 ExecModifyTable (pstate=0x832c574a0) at ../src/backend/executor/nodeModifyTable.c:4133 [10:22:14.583] context = {mtstate = 0x832c574a0, epqstate = 0x832c57588, estate = 0x832c57100, planSlot = 0x83aa0edb0, tmfd = {ctid = {ip_blkid = {bi_hi = 32142, bi_lo = 10933}, ip_posid = 8}, xmax = 118, cmax = 0, traversed = 114}, cpUpdateReturningSlot = 0xcb090223c941d3f} [10:22:14.583] tuple_ctid = {ip_blkid = {bi_hi = 16544, bi_lo = 8456}, ip_posid = 8} [10:22:14.583] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83aa33118} [10:22:14.583] node = 0x832c574a0 [10:22:14.583] estate = 0x832c57100 [10:22:14.583] operation = CMD_MERGE [10:22:14.583] resultRelInfo = 0x832c576b0 [10:22:14.583] subplanstate = 0x832c58df0 [10:22:14.583] slot = [10:22:14.583] tupleid = 0x0 [10:22:14.583] oldtuple = 0x821083fd0 [10:22:14.583] oldSlot = [10:22:14.583] #9 0x00000000007325db in ExecProcNode (node=0x832c574a0) at ../src/include/executor/executor.h:278 [10:22:14.583] No locals. [10:22:14.583] #10 ExecutePlan (estate=0x832c57100, planstate=0x832c574a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x832a8b710, execute_once=) at ../src/backend/executor/execMain.c:1641 [10:22:14.583] current_tuple_count = 0 [10:22:14.583] slot = [10:22:14.583] #11 standard_ExecutorRun (queryDesc=0x832adac48, direction=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:358 [10:22:14.583] estate = 0x832c57100 [10:22:14.583] oldcontext = 0x832a8b400 [10:22:14.583] operation = CMD_MERGE [10:22:14.583] dest = 0x832a8b710 [10:22:14.583] sendTuples = true [10:22:14.583] #12 0x0000000835a25961 in pgss_ExecutorRun (queryDesc=0x832adac48, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1031 [10:22:14.583] _local_sigjmp_buf = {{_sjb = {35259570481, 1, 34913927592, 34913927760, 12160952, 34913927600, 1, 35209981000, 34913911679, 7622961, 35211538432, 34359738368}}} [10:22:14.583] _save_exception_stack = 0x821084360 [10:22:14.583] _save_context_stack = 0x0 [10:22:14.583] _do_rethrow = false [10:22:14.583] #13 0x000000000090963f in ProcessQuery (plan=0x83ab2dec0, sourceText=, params=0x0, queryEnv=0x0, dest=0x832a8b710, qc=0x821084328) at ../src/backend/tcop/pquery.c:160 [10:22:14.583] queryDesc = 0x832adac48 [10:22:14.583] #14 0x0000000000908bdd in PortalRunMulti (portal=portal@entry=0x832b23100, isTopLevel=true, setHoldSnapshot=true, dest=dest@entry=0x832a8b710, altdest=0xb4ff00 , qc=qc@entry=0x821084328) at ../src/backend/tcop/pquery.c:1287 [10:22:14.583] pstmt = 0x83ab2dec0 [10:22:14.583] stmtlist_item__state = {l = 0x83ab32778, i = 0} [10:22:14.583] active_snapshot_set = true [10:22:14.583] stmtlist_item = 0x83ab32790 [10:22:14.583] #15 0x00000000009086ec in FillPortalStore (portal=portal@entry=0x832b23100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [10:22:14.583] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:22:14.583] treceiver = 0x832a8b710 [10:22:14.583] #16 0x000000000090845b in PortalRun (portal=portal@entry=0x832b23100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83ab327c8, altdest=altdest@entry=0x83ab327c8, qc=0x821084460) at ../src/backend/tcop/pquery.c:763 [10:22:14.583] _local_sigjmp_buf = {{_sjb = {9470973, 35210277120, 34913928024, 34913928256, 34913928032, 35210371072, 12127640, 12160952, 35210265471, 35209597184, 4294967984, 0}}} [10:22:14.583] _save_exception_stack = 0x821084530 [10:22:14.583] _save_context_stack = 0x0 [10:22:14.583] _do_rethrow = false [10:22:14.583] saveTopTransactionResourceOwner = 0x832b69218 [10:22:14.583] saveTopTransactionContext = 0x832b3a000 [10:22:14.583] saveActivePortal = 0x0 [10:22:14.583] saveResourceOwner = 0x832b69218 [10:22:14.583] savePortalContext = 0x0 [10:22:14.583] saveMemoryContext = 0x832b3a000 [10:22:14.583] result = [10:22:14.583] nprocessed = [10:22:14.583] #17 0x0000000000907322 in exec_simple_query (query_string=query_string@entry=0x832a7d100 "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 [10:22:14.583] cmdtaglen = 5 [10:22:14.583] snapshot_set = [10:22:14.583] per_parsetree_context = 0x0 [10:22:14.583] plantree_list = [10:22:14.583] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:22:14.583] format = 0 [10:22:14.583] parsetree = 0x83ab0abe8 [10:22:14.583] commandTag = [10:22:14.583] cmdtagname = [10:22:14.583] querytree_list = [10:22:14.583] portal = 0x832b23100 [10:22:14.583] receiver = 0x83ab327c8 [10:22:14.583] parsetree_item__state = {l = 0x83ab0c4b0, i = 0} [10:22:14.583] msec_str = "\000\000\000\000\b", '\000' , "b\310f\000\000\000\000i\032+\b\0169\016f" [10:22:14.583] dest = DestRemote [10:22:14.583] was_logged = [10:22:14.583] oldcontext = 0x832b3a000 [10:22:14.583] parsetree_list = 0x83ab0c4b0 [10:22:14.583] use_implicit_block = false [10:22:14.583] parsetree_item = 0x83ab0c4c8 [10:22:14.583] save_log_statement_stats = [10:22:14.583] #18 0x0000000000905090 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [10:22:14.583] query_string = 0x832a7d100 "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"... [10:22:14.583] input_message = {data = 0x832a7d100 "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} [10:22:14.583] firstchar = [10:22:14.583] local_sigjmp_buf = {{_sjb = {9454886, 34913928496, 34913928456, 34913929040, 12169688, 1, 8192, 8388608, 895, 0, 0, 1}}} [10:22:14.583] send_ready_for_query = false [10:22:14.583] idle_in_transaction_timeout_enabled = false [10:22:14.583] idle_session_timeout_enabled = false [10:22:14.583] #19 0x00000000008ff869 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:22:14.583] bsdata = [10:22:14.583] #20 0x0000000000859a87 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821085274 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8210851b0) at ../src/backend/postmaster/launch_backend.c:274 [10:22:14.583] pid = [10:22:14.583] #21 0x000000000085de48 in BackendStartup (client_sock=0x8210851b0) at ../src/backend/postmaster/postmaster.c:3414 [10:22:14.583] startup_data = {canAcceptConnections = CAC_OK} [10:22:14.583] bn = 0x832a89178 [10:22:14.583] pid = [10:22:14.583] __error = [10:22:14.583] save_errno = [10:22:14.583] __error = [10:22:14.583] __error = [10:22:14.583] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [10:22:14.583] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = " ܧ2\b", '\000' , "\020R\b!\b\000\000\000h\325\313(\b\000\000\000\v\000\000\000\000\000\000\000^_\314(\b", '\000' , "PR\b!\b\000\000\0004\230\205\000\000\000\000\000`R\b!\b", '\000' }, salen = 16}} [10:22:14.583] i = 0 [10:22:14.583] now = [10:22:14.583] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 716176514, events = 8, fd = 0, user_data = 0x821085160}, {pos = 850286040, events = 8, fd = 554192880, user_data = 0x0}, {pos = -1195547894, events = 1379, fd = 715343776, user_data = 0x82aa45d78}, {pos = 554191976, events = 8, fd = 554192096, user_data = 0x821084c68}, {pos = -1195547894, events = 1379, fd = 715322248, user_data = 0x82aa45d78}, {pos = 554192024, events = 8, fd = 554192144, user_data = 0x821084c98}, {pos = 715383188, events = 8, fd = 565122056, user_data = 0x82aa3e194}, {pos = 554192128, events = 8, fd = -1195568070, user_data = 0x821084ca0}, {pos = 684438544, events = 8, fd = 717205552, user_data = 0x563b8bd630a}, {pos = 715290712, events = 8, fd = 715414904, user_data = 0x821084d08}, {pos = 554192256, events = 8, fd = 554192136, user_data = 0x82aa3cd0c}, {pos = 565122056, events = 8, fd = 715377932, user_data = 0x821084d70}, {pos = -1195568070, events = 1379, fd = 554192280, user_data = 0x821084f68}, {pos = 554192256, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821af7038}, {pos = 1, events = 212897826, fd = 565122056, user_data = 0x82aa2f388}, {pos = 565143496, events = 8, fd = 0, user_data = 0x0}, {pos = 554192392, events = 8, fd = 554192856, user_data = 0x821084df0}, {pos = -1195549534, events = 1379, fd = 2699999, user_data = 0x6d68b}, {pos = 2090263927, events = 212897826, fd = 565145656, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8210850d8}, {pos = 565122056, events = 3, fd = 554192928, user_data = 0x821af6828}, {pos = 656, events = 0, fd = 554192856, user_data = 0x821084e08}, {pos = 554192496, events = 8, fd = -1195549925, user_data = 0x821084fa0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 565145656, events = 8, fd = 1, user_data = 0x821af1408}, {pos = 715290712, events = 8, fd = 554193112, user_data = 0x821085020}, {pos = 554192512, events = 8, fd = 0, user_data = 0x821aea008}, {pos = 33, events = 0, fd = 554192912, user_data = 0x563b8bcfae7}, {pos = 565092360, events = 8, fd = 565093384, user_data = 0x821aea808}, {pos = 565095432, events = 8, fd = 565108744, user_data = 0x821aee408}, {pos = 565110792, events = 8, fd = 565111816, user_data = 0x821aef008}, {pos = 565113864, events = 8, fd = 565114888, user_data = 0x821aefc08}, {pos = 565116936, events = 8, fd = 565117960, user_data = 0x821af0808}, {pos = 565120008, events = 8, fd = 565121032, user_data = 0x821af1408}, {pos = 565123080, events = 8, fd = 565124104, user_data = 0x821af2008}, {pos = 565126152, events = 8, fd = 565127176, user_data = 0x821af2c08}, {pos = 565129224, events = 8, fd = 565130248, user_data = 0x821af3808}, {pos = 565132296, events = 8, fd = 565137416, user_data = 0x821af5408}, {pos = 565139464, events = 8, fd = 565140488, user_data = 0x821af8408}, {pos = 145678000, events = 0, fd = 565092360, user_data = 0x2932df}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821af7038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554193112, events = 8, fd = 554192512, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 565145656, user_data = 0x1}, {pos = 565092360, events = 8, fd = 314, user_data = 0x8210850c0}, {pos = -1195575825, events = 1379, fd = 2699999, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565145656, user_data = 0x1}, {pos = 565122056, events = 8, fd = 849793024, user_data = 0x1}, {pos = 849793428, events = 8, fd = 0, user_data = 0x821085090}, {pos = 684479852, events = 8, fd = 1, user_data = 0x832a6d000}, {pos = 554193088, events = 8, fd = 684476162, user_data = 0x82ab59170 }, {pos = 12094728, events = 0, fd = 716542320, user_data = 0x821af1408}, {pos = 554193312, events = 8, fd = -1195576354, user_data = 0x832a8b800}, {pos = 1, events = 8, fd = -1195576738, user_data = 0x821aea008}, {pos = 554193096, events = 8, fd = 554193312, user_data = 0x1c38}, {pos = 849861664, events = 8, fd = -1195497072, user_data = 0x0}, {pos = 554173311, events = 8, fd = 7899223, user_data = 0x821085150}, {pos = 684438544, events = 8, fd = 717205552, user_data = 0x82abfd310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821085180}, {pos = 684481437, events = 8, fd = 849793024, user_data = 0x3035}, {pos = 554193376, events = 8, fd = 684447994, user_data = 0x0}, {pos = 0, events = 0, fd = 1016339775, user_data = 0x0}} [10:22:14.583] last_touch_time = 1724408308 [10:22:14.583] last_lockfile_recheck_time = 1724408308 [10:22:14.583] nevents = 1 [10:22:14.583] #23 0x000000000085bc65 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8210857c0) at ../src/backend/postmaster/postmaster.c:1346 [10:22:14.583] userDoption = [10:22:14.583] listen_addr_saved = [10:22:14.583] output_config_variable = [10:22:14.583] opt = [10:22:14.583] status = [10:22:14.583] #24 0x000000000079555c in main (argc=4, argv=0x8210857c0) at ../src/backend/main/main.c:197 [10:22:14.583] do_check_root =