[07:57:24.882] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [07:57:25.258] dumping /tmp/cores/postgres.8998.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:57:25.395] [New LWP 100173] [07:57:25.484] Core was generated by `postgres: postgres regression [local] MERGE'. [07:57:25.484] Program terminated with signal SIGABRT, Aborted. [07:57:25.484] Sent by thr_kill() from pid 8998 and user 1003. [07:57:25.484] #0 0x000000082a9d2dca in thr_kill () from /lib/libc.so.7 [07:57:26.049] [07:57:26.049] Thread 1 (LWP 100173): [07:57:26.049] #0 0x000000082a9d2dca in thr_kill () from /lib/libc.so.7 [07:57:26.049] No symbol table info available. [07:57:26.049] #1 0x000000082a94b6f4 in raise () from /lib/libc.so.7 [07:57:26.049] No symbol table info available. [07:57:26.049] #2 0x000000082a9fcbc9 in abort () from /lib/libc.so.7 [07:57:26.049] No symbol table info available. [07:57:26.049] #3 0x0000000000a61657 in ExceptionalCondition (conditionName=, fileName=0x373253 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [07:57:26.049] No locals. [07:57:26.049] #4 0x0000000000743c80 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820bb1170, materialize=, shouldFree=shouldFree@entry=0x820bb1136) at ../src/backend/executor/execTuples.c:1737 [07:57:26.049] No locals. [07:57:26.049] #5 0x0000000000709618 in ExecIRDeleteTriggers (estate=estate@entry=0x83324e100, relinfo=relinfo@entry=0x83324e6b0, slot=slot@entry=0x820bb1170) at ../src/backend/commands/trigger.c:2832 [07:57:26.049] trigger = [07:57:26.049] oldtuple = [07:57:26.049] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8430bb468, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [07:57:26.049] trigdesc = 0x83324e8c0 [07:57:26.049] newtuple = 0x0 [07:57:26.049] i = 0 [07:57:26.049] should_free = false [07:57:26.049] #6 0x0000000000768d77 in ExecMergeMatched (context=0x820bb1210, resultRelInfo=0x83324e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [07:57:26.049] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [07:57:26.049] relaction = 0x8413f8220 [07:57:26.049] commandType = CMD_DELETE [07:57:26.049] result = TM_Ok [07:57:26.049] l__state = {l = 0x84146ec48, i = 0} [07:57:26.049] mtstate = 0x83324e4a0 [07:57:26.049] newslot = 0x0 [07:57:26.049] rslot = 0x0 [07:57:26.049] estate = 0x1874d [07:57:26.049] mergeActions = [07:57:26.049] econtext = 0x84146dce8 [07:57:26.049] epqstate = 0x83324e588 [07:57:26.049] actionStates = 0x84146ec48 [07:57:26.049] l = [07:57:26.049] isNull = [07:57:26.049] lmerge_matched = [07:57:26.049] __error = [07:57:26.049] l__state = [07:57:26.049] updateCxt = [07:57:26.049] relaction = [07:57:26.049] commandType = [07:57:26.049] result = [07:57:26.049] __error = [07:57:26.049] resultRelationDesc = [07:57:26.049] lockmode = [07:57:26.049] inputslot = [07:57:26.049] epqslot = [07:57:26.049] was_matched = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] #7 ExecMerge (context=0x820bb1210, resultRelInfo=0x83324e6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [07:57:26.049] matched = [07:57:26.049] rslot = 0x0 [07:57:26.049] #8 ExecModifyTable (pstate=0x83324e4a0) at ../src/backend/executor/nodeModifyTable.c:4067 [07:57:26.049] context = {mtstate = 0x83324e4a0, epqstate = 0x83324e588, estate = 0x83324e100, planSlot = 0x8413f8190, tmfd = {ctid = {ip_blkid = {bi_hi = 4688, bi_lo = 8379}, ip_posid = 8}, xmax = 1095165256, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x841499cb8} [07:57:26.049] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [07:57:26.049] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x833262118} [07:57:26.049] node = 0x83324e4a0 [07:57:26.049] estate = 0x83324e100 [07:57:26.049] operation = CMD_MERGE [07:57:26.049] resultRelInfo = 0x83324e6b0 [07:57:26.049] subplanstate = 0x83324fdf0 [07:57:26.049] slot = [07:57:26.049] tupleid = 0x0 [07:57:26.049] oldtuple = 0x0 [07:57:26.049] oldSlot = [07:57:26.049] #9 0x000000000073dcbb in ExecProcNodeFirst (node=0x83324e4a0) at ../src/backend/executor/execProcnode.c:464 [07:57:26.049] No locals. [07:57:26.049] #10 0x0000000000735faa in ExecProcNode (node=0x83324e4a0) at ../src/include/executor/executor.h:274 [07:57:26.049] No locals. [07:57:26.049] #11 ExecutePlan (estate=0x83324e100, planstate=0x83324e4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83322bf10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [07:57:26.049] current_tuple_count = [07:57:26.049] slot = [07:57:26.049] #12 standard_ExecutorRun (queryDesc=0x833130448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [07:57:26.049] estate = 0x83324e100 [07:57:26.049] oldcontext = 0x83322bc00 [07:57:26.049] operation = CMD_MERGE [07:57:26.049] dest = 0x83322bf10 [07:57:26.049] sendTuples = true [07:57:26.049] #13 0x0000000000735e5f in ExecutorRun (queryDesc=0x1874d, queryDesc@entry=0x833130448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [07:57:26.049] No locals. [07:57:26.049] #14 0x000000000090efbf in ProcessQuery (plan=0x8414995a0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820bb1448) at ../src/backend/tcop/pquery.c:160 [07:57:26.049] queryDesc = 0x833130448 [07:57:26.049] #15 0x000000000090e55d in PortalRunMulti (portal=portal@entry=0x833163100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83322bf10, altdest=0xb567e0 , qc=qc@entry=0x820bb1448) at ../src/backend/tcop/pquery.c:1286 [07:57:26.049] pstmt = 0x8414995a0 [07:57:26.049] stmtlist_item__state = {l = 0x84149de58, i = 0} [07:57:26.049] active_snapshot_set = true [07:57:26.049] stmtlist_item = 0x84149de70 [07:57:26.049] #16 0x000000000090e04c in FillPortalStore (portal=portal@entry=0x833163100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [07:57:26.049] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:26.049] treceiver = 0x83322bf10 [07:57:26.049] #17 0x000000000090dda0 in PortalRun (portal=portal@entry=0x833163100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x84149dea8, altdest=altdest@entry=0x84149dea8, qc=0x820bb1580) at ../src/backend/tcop/pquery.c:763 [07:57:26.049] _local_sigjmp_buf = {{_sjb = {9493823, 35216883096, 34908869752, 34908869984, 34908869760, 12186568, 12154352, 35216830720, 7112098687, 35216838912, 3580080, 34359738368}}} [07:57:26.049] _save_exception_stack = 0x820bb1650 [07:57:26.049] _save_context_stack = 0x0 [07:57:26.049] _do_rethrow = false [07:57:26.049] saveTopTransactionResourceOwner = 0x83316fd98 [07:57:26.049] saveTopTransactionContext = 0x833099000 [07:57:26.049] saveActivePortal = 0x0 [07:57:26.049] saveResourceOwner = 0x83316fd98 [07:57:26.049] savePortalContext = 0x0 [07:57:26.049] saveMemoryContext = 0x833099000 [07:57:26.049] result = [07:57:26.049] nprocessed = [07:57:26.049] #18 0x000000000090ccab in exec_simple_query (query_string=query_string@entry=0x83308d100 "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:1274 [07:57:26.049] cmdtaglen = [07:57:26.049] snapshot_set = [07:57:26.049] per_parsetree_context = 0x0 [07:57:26.049] plantree_list = [07:57:26.049] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:26.049] parsetree = 0x84143c8e8 [07:57:26.049] commandTag = CMDTAG_MERGE [07:57:26.049] cmdtagname = [07:57:26.049] querytree_list = [07:57:26.049] portal = 0x833163100 [07:57:26.049] format = 0 [07:57:26.049] receiver = 0x84149dea8 [07:57:26.049] parsetree_item__state = {l = 0x84143e1b0, i = 0} [07:57:26.049] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [07:57:26.049] dest = DestRemote [07:57:26.049] was_logged = [07:57:26.049] oldcontext = 0x833099000 [07:57:26.049] parsetree_list = 0x84143e1b0 [07:57:26.049] use_implicit_block = false [07:57:26.049] parsetree_item = 0x84143e1c8 [07:57:26.049] save_log_statement_stats = [07:57:26.049] #19 0x000000000090aa84 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [07:57:26.049] query_string = 0x83308d100 "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"... [07:57:26.049] input_message = {data = 0x83308d100 "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} [07:57:26.049] firstchar = [07:57:26.049] local_sigjmp_buf = {{_sjb = {9477968, 34908870224, 34908870184, 34908870784, 12195304, 12141776, 8192, 8388608, 72057628946793343, 0, 0, 34359738369}}} [07:57:26.049] send_ready_for_query = false [07:57:26.049] idle_in_transaction_timeout_enabled = false [07:57:26.049] idle_session_timeout_enabled = false [07:57:26.049] #20 0x0000000000905559 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [07:57:26.049] bsdata = [07:57:26.049] #21 0x000000000085f522 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820bb2390 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820bb22d8) at ../src/backend/postmaster/launch_backend.c:265 [07:57:26.049] pid = [07:57:26.049] #22 0x0000000000863e81 in BackendStartup (client_sock=0x820bb22d8) at ../src/backend/postmaster/postmaster.c:3593 [07:57:26.049] startup_data = {canAcceptConnections = CAC_OK} [07:57:26.049] bn = 0x833099538 [07:57:26.049] pid = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] save_errno = [07:57:26.049] __error = [07:57:26.049] __error = [07:57:26.049] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [07:57:26.049] 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' , "0#\273 \b\000\000\000ؕ\370)\b\000\000\000\v\000\000\000\000\000\000\000\016\026\371)\b", '\000' , "p#\273 \b\000\000\000\364\362\205\000\000\000\000\000\200#\273 \b", '\000' }, salen = 16}} [07:57:26.049] i = 0 [07:57:26.049] now = [07:57:26.049] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713800804, events = 8, fd = 549132576, user_data = 0x820bb1ab0}, {pos = 555594760, events = 8, fd = 32, user_data = 0x820bb1aa0}, {pos = 2045143700, events = 11795, fd = 555565064, user_data = 0x8211d4408}, {pos = 555567112, events = 8, fd = 555568136, user_data = 0x8211d8008}, {pos = 555582472, events = 8, fd = 555583496, user_data = 0x8211d8c08}, {pos = 555585544, events = 8, fd = 555586568, user_data = 0x8211d9808}, {pos = 555588616, events = 8, fd = 555589640, user_data = 0x8211da408}, {pos = 555591688, events = 8, fd = 555592712, user_data = 0x8211db008}, {pos = 555594760, events = 8, fd = -1, user_data = 0x82aa932e0}, {pos = 549132816, events = 8, fd = 715391401, user_data = 0x0}, {pos = 4096, events = 0, fd = -1794194911, user_data = 0x82aa937e8}, {pos = 849386464, events = 8, fd = 160, user_data = 0x0}, {pos = 827809936, events = 8, fd = 549133024, user_data = 0x82aa1e92c}, {pos = 4096, events = 0, fd = 713816420, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 555620920, user_data = 0x800000001}, {pos = 555594760, events = 8, fd = 713730264, user_data = 0x820bb1b68}, {pos = 549132576, events = 8, fd = 32, user_data = 0x82a8bbc64}, {pos = 555594760, events = 8, fd = 555620920, user_data = 0x0}, {pos = 2625, events = 0, fd = 549133136, user_data = 0x2e1379e66645}, {pos = 713816420, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 555620920, events = 8, fd = 1, user_data = 0x8211db408}, {pos = 856150016, events = 8, fd = 1, user_data = 0x83307d194}, {pos = 0, events = 0, fd = 549133088, user_data = 0x829f90c0c}, {pos = 1, events = 0, fd = 856150016, user_data = 0x820bb1b50}, {pos = 704183988, events = 8, fd = 715542880, user_data = 0x82aa65160 }, {pos = 713912512, events = 8, fd = 555594760, user_data = 0x820bb1c30}, {pos = 2045142060, events = 11795, fd = 827809936, user_data = 0x800000001}, {pos = 2045141678, events = 11795, fd = 12240, user_data = 0x820bb1b58}, {pos = 549133360, events = 8, fd = 856856552, user_data = 0x820bb21a0}, {pos = 2045222544, events = 11795, fd = 555594760, user_data = 0x820bb037f}, {pos = 715199900, events = 8, fd = 555565064, user_data = 0x0}, {pos = 555594760, events = 8, fd = 12240, user_data = 0x82a89b000}, {pos = 1964368, events = 0, fd = 715542880, user_data = 0x82a8bbc64}, {pos = 15616, events = 0, fd = 549134544, user_data = 0x820bb1ca0}, {pos = 714473870, events = 8, fd = 715581496, user_data = 0x820bb1c64}, {pos = 856593882, events = 8, fd = 549134544, user_data = 0x820bb1ca0}, {pos = 714565125, events = 8, fd = 549133410, user_data = 0x820bb20d0}, {pos = 549134544, events = 8, fd = 0, user_data = 0xee13155950ec221}, {pos = 549134544, events = 8, fd = 856593880, user_data = 0x820bb21a0}, {pos = 715581496, events = 8, fd = 0, user_data = 0x820bb2110}, {pos = 714565389, events = 8, fd = 0, user_data = 0x0}, {pos = 549134912, events = 8, fd = 856593880, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 2045170697, events = 11795, fd = 549133816, user_data = 0x82a8bbc64}, {pos = 2503, events = 0, fd = 2045170697, user_data = 0x820bb1e18}, {pos = 713800804, events = 8, fd = 2758, user_data = 0x82a8b5120}, {pos = 549133720, events = 8, fd = 555594760, user_data = 0x820bb1e18}, {pos = 713773344, events = 8, fd = 549133824, user_data = 0x2e1379e68465}, {pos = 0, events = 0, fd = 0, user_data = 0x82aa870f0}, {pos = 713733456, events = 8, fd = 0, user_data = 0x0}, {pos = 715610544, events = 8, fd = 2045170697, user_data = 0x820bb1ea8}, {pos = 713800804, events = 8, fd = 2924, user_data = 0x82a8b53b8}, {pos = 549133864, events = 8, fd = 555594760, user_data = 0x820bb1ea8}, {pos = 713774008, events = 8, fd = 549133968, user_data = 0x2e1379e68465}, {pos = 555618360, events = 8, fd = 2676322, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 555594760, events = 8, fd = 713733456, user_data = 0x820bb2168}, {pos = 555594760, events = 8, fd = 549134408, user_data = 0x1e}, {pos = 713737440, events = 8, fd = 549134136, user_data = 0x8211e0248}, {pos = 549134584, events = 8, fd = 549134112, user_data = 0x2e1379e6cda3}, {pos = 555618360, events = 8, fd = 2700047, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 555618360, user_data = 0x1}} [07:57:26.049] last_touch_time = 1712562871 [07:57:26.049] last_lockfile_recheck_time = 1712562871 [07:57:26.049] nevents = 1 [07:57:26.049] #24 0x0000000000861756 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820bb28d8) at ../src/backend/postmaster/postmaster.c:1372 [07:57:26.049] userDoption = [07:57:26.049] listen_addr_saved = false [07:57:26.049] output_config_variable = [07:57:26.049] opt = [07:57:26.049] status = [07:57:26.049] #25 0x0000000000798ff5 in main (argc=8, argv=0x820bb28d8) at ../src/backend/main/main.c:197 [07:57:26.049] do_check_root = [07:57:26.059] [07:57:26.059] [07:57:26.059] [07:57:26.121] dumping /tmp/cores/postgres.9769.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:57:26.251] [New LWP 101896] [07:57:26.321] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [07:57:26.321] Program terminated with signal SIGABRT, Aborted. [07:57:26.321] Sent by thr_kill() from pid 9769 and user 1003. [07:57:26.321] #0 0x00000008292f4dca in thr_kill () from /lib/libc.so.7 [07:57:26.869] [07:57:26.869] Thread 1 (LWP 101896): [07:57:26.869] #0 0x00000008292f4dca in thr_kill () from /lib/libc.so.7 [07:57:26.869] No symbol table info available. [07:57:26.869] #1 0x000000082926d6f4 in raise () from /lib/libc.so.7 [07:57:26.869] No symbol table info available. [07:57:26.869] #2 0x000000082931ebc9 in abort () from /lib/libc.so.7 [07:57:26.869] No symbol table info available. [07:57:26.869] #3 0x0000000000a61657 in ExceptionalCondition (conditionName=, fileName=0x373253 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [07:57:26.869] No locals. [07:57:26.869] #4 0x0000000000743c80 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820b714d0, materialize=, shouldFree=shouldFree@entry=0x820b71496) at ../src/backend/executor/execTuples.c:1737 [07:57:26.869] No locals. [07:57:26.869] #5 0x0000000000709618 in ExecIRDeleteTriggers (estate=estate@entry=0x833de5100, relinfo=relinfo@entry=0x833de56b0, slot=slot@entry=0x820b714d0) at ../src/backend/commands/trigger.c:2832 [07:57:26.869] trigger = [07:57:26.869] oldtuple = [07:57:26.869] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83725c750, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [07:57:26.869] trigdesc = 0x833de58c0 [07:57:26.869] newtuple = 0x0 [07:57:26.869] i = 0 [07:57:26.869] should_free = false [07:57:26.869] #6 0x0000000000768d77 in ExecMergeMatched (context=0x820b71570, resultRelInfo=0x833de56b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [07:57:26.869] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [07:57:26.869] relaction = 0x8372f1d20 [07:57:26.869] commandType = CMD_DELETE [07:57:26.869] result = TM_Ok [07:57:26.869] l__state = {l = 0x83736d308, i = 0} [07:57:26.869] mtstate = 0x833de54a0 [07:57:26.869] newslot = 0x0 [07:57:26.869] rslot = 0x0 [07:57:26.869] estate = 0x18e08 [07:57:26.869] mergeActions = [07:57:26.869] econtext = 0x83736c3a8 [07:57:26.869] epqstate = 0x833de5588 [07:57:26.869] actionStates = 0x83736d308 [07:57:26.869] l = [07:57:26.869] isNull = [07:57:26.869] lmerge_matched = [07:57:26.869] __error = [07:57:26.869] l__state = [07:57:26.869] updateCxt = [07:57:26.869] relaction = [07:57:26.869] commandType = [07:57:26.869] result = [07:57:26.869] __error = [07:57:26.869] resultRelationDesc = [07:57:26.869] lockmode = [07:57:26.869] inputslot = [07:57:26.869] epqslot = [07:57:26.869] was_matched = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] #7 ExecMerge (context=0x820b71570, resultRelInfo=0x833de56b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [07:57:26.869] matched = [07:57:26.869] rslot = 0x0 [07:57:26.869] #8 ExecModifyTable (pstate=0x833de54a0) at ../src/backend/executor/nodeModifyTable.c:4067 [07:57:26.869] context = {mtstate = 0x833de54a0, epqstate = 0x833de5588, estate = 0x833de5100, planSlot = 0x8372f1c90, tmfd = {ctid = {ip_blkid = {bi_hi = 5552, bi_lo = 8375}, ip_posid = 8}, xmax = 926338056, cmax = 8, traversed = false}, cpUpdateReturningSlot = 0x837399f38} [07:57:26.869] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [07:57:26.869] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x833df9118} [07:57:26.869] node = 0x833de54a0 [07:57:26.869] estate = 0x833de5100 [07:57:26.869] operation = CMD_MERGE [07:57:26.869] resultRelInfo = 0x833de56b0 [07:57:26.869] subplanstate = 0x833de6df0 [07:57:26.869] slot = [07:57:26.869] tupleid = 0x0 [07:57:26.869] oldtuple = 0x0 [07:57:26.869] oldSlot = [07:57:26.869] #9 0x000000000073dcbb in ExecProcNodeFirst (node=0x833de54a0) at ../src/backend/executor/execProcnode.c:464 [07:57:26.869] No locals. [07:57:26.869] #10 0x0000000000735faa in ExecProcNode (node=0x833de54a0) at ../src/include/executor/executor.h:274 [07:57:26.869] No locals. [07:57:26.869] #11 ExecutePlan (estate=0x833de5100, planstate=0x833de54a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x833c53b10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [07:57:26.869] current_tuple_count = [07:57:26.869] slot = [07:57:26.869] #12 standard_ExecutorRun (queryDesc=0x833cfe448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [07:57:26.869] estate = 0x833de5100 [07:57:26.869] oldcontext = 0x833c53800 [07:57:26.869] operation = CMD_MERGE [07:57:26.869] dest = 0x833c53b10 [07:57:26.869] sendTuples = true [07:57:26.869] #13 0x0000000000735e5f in ExecutorRun (queryDesc=0x18e08, queryDesc@entry=0x833cfe448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [07:57:26.869] No locals. [07:57:26.869] #14 0x000000000090efbf in ProcessQuery (plan=0x837399820, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820b717a8) at ../src/backend/tcop/pquery.c:160 [07:57:26.869] queryDesc = 0x833cfe448 [07:57:26.869] #15 0x000000000090e55d in PortalRunMulti (portal=portal@entry=0x833cde100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x833c53b10, altdest=0xb567e0 , qc=qc@entry=0x820b717a8) at ../src/backend/tcop/pquery.c:1286 [07:57:26.869] pstmt = 0x837399820 [07:57:26.869] stmtlist_item__state = {l = 0x83739e0d8, i = 0} [07:57:26.869] active_snapshot_set = true [07:57:26.869] stmtlist_item = 0x83739e0f0 [07:57:26.869] #16 0x000000000090e04c in FillPortalStore (portal=portal@entry=0x833cde100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [07:57:26.869] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:26.869] treceiver = 0x833c53b10 [07:57:26.869] #17 0x000000000090dda0 in PortalRun (portal=portal@entry=0x833cde100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83739e128, altdest=altdest@entry=0x83739e128, qc=0x820b718e0) at ../src/backend/tcop/pquery.c:763 [07:57:26.869] _local_sigjmp_buf = {{_sjb = {9493823, 35229207064, 34908608472, 34908608704, 34908608480, 12186568, 12154352, 35228868864, 7112098687, 35228877056, 3580080, 34359738368}}} [07:57:26.869] _save_exception_stack = 0x820b719b0 [07:57:26.869] _save_context_stack = 0x0 [07:57:26.869] _do_rethrow = false [07:57:26.869] saveTopTransactionResourceOwner = 0x833d30a18 [07:57:26.869] saveTopTransactionContext = 0x833c51000 [07:57:26.869] saveActivePortal = 0x0 [07:57:26.869] saveResourceOwner = 0x833d30a18 [07:57:26.869] savePortalContext = 0x0 [07:57:26.869] saveMemoryContext = 0x833c51000 [07:57:26.869] result = [07:57:26.869] nprocessed = [07:57:26.869] #18 0x000000000090ccab in exec_simple_query (query_string=query_string@entry=0x833c45100 "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:1274 [07:57:26.869] cmdtaglen = [07:57:26.869] snapshot_set = [07:57:26.869] per_parsetree_context = 0x0 [07:57:26.869] plantree_list = [07:57:26.869] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:26.869] parsetree = 0x83733a6e8 [07:57:26.869] commandTag = CMDTAG_MERGE [07:57:26.869] cmdtagname = [07:57:26.869] querytree_list = [07:57:26.869] portal = 0x833cde100 [07:57:26.869] format = 0 [07:57:26.869] receiver = 0x83739e128 [07:57:26.869] parsetree_item__state = {l = 0x83733bfb0, i = 0} [07:57:26.869] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [07:57:26.869] dest = DestRemote [07:57:26.869] was_logged = [07:57:26.869] oldcontext = 0x833c51000 [07:57:26.869] parsetree_list = 0x83733bfb0 [07:57:26.869] use_implicit_block = false [07:57:26.869] parsetree_item = 0x83733bfc8 [07:57:26.869] save_log_statement_stats = [07:57:26.869] #19 0x000000000090aa84 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [07:57:26.869] query_string = 0x833c45100 "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"... [07:57:26.869] input_message = {data = 0x833c45100 "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} [07:57:26.869] firstchar = [07:57:26.869] local_sigjmp_buf = {{_sjb = {9477968, 34908608944, 34908608904, 34908609504, 12195304, 12141776, 8192, 8388608, 72057628946531199, 0, 0, 34359738369}}} [07:57:26.869] send_ready_for_query = false [07:57:26.869] idle_in_transaction_timeout_enabled = false [07:57:26.869] idle_session_timeout_enabled = false [07:57:26.869] #20 0x0000000000905559 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [07:57:26.869] bsdata = [07:57:26.869] #21 0x000000000085f522 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820b726f0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820b72638) at ../src/backend/postmaster/launch_backend.c:265 [07:57:26.869] pid = [07:57:26.869] #22 0x0000000000863e81 in BackendStartup (client_sock=0x820b72638) at ../src/backend/postmaster/postmaster.c:3593 [07:57:26.869] startup_data = {canAcceptConnections = CAC_OK} [07:57:26.869] bn = 0x833c51308 [07:57:26.869] pid = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] save_errno = [07:57:26.869] __error = [07:57:26.869] __error = [07:57:26.869] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [07:57:26.869] 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 = '\000' , "\220&\267 \b\000\000\000\330\365.(\b\000\000\000\v\000\000\000\000\000\000\000\016v/(\b", '\000' , "\320&\267 \b\000\000\000\364\362\205\000\000\000\000\000\340&\267 \b", '\000' }, salen = 16}} [07:57:26.869] i = 0 [07:57:26.869] now = [07:57:26.869] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 689822820, events = 8, fd = 548871296, user_data = 0x820b71e10}, {pos = 559297544, events = 8, fd = 32, user_data = 0x820b71e00}, {pos = -1381315948, events = 12243, fd = 559267848, user_data = 0x82155c408}, {pos = 559269896, events = 8, fd = 559270920, user_data = 0x821560008}, {pos = 559285256, events = 8, fd = 559286280, user_data = 0x821560c08}, {pos = 559288328, events = 8, fd = 559289352, user_data = 0x821561808}, {pos = 559291400, events = 8, fd = 559292424, user_data = 0x821562408}, {pos = 559294472, events = 8, fd = 559295496, user_data = 0x821563008}, {pos = 559297544, events = 8, fd = 559317128, user_data = 0x820b71f88}, {pos = 548871600, events = 8, fd = -1381290589, user_data = 0x0}, {pos = 2572490, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 559321144, events = 8, fd = 1, user_data = 0x821563408}, {pos = 689730728, events = 8, fd = 548872328, user_data = 0x821563408}, {pos = 548871584, events = 0, fd = 689838436, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 559323704, user_data = 0x1}, {pos = 559297544, events = 8, fd = 689752280, user_data = 0x820b71ec8}, {pos = 548871296, events = 8, fd = 32, user_data = 0x8291ddc64}, {pos = 559297544, events = 8, fd = 559323704, user_data = 0x0}, {pos = 2625, events = 0, fd = 548871856, user_data = 0x2fd3adaac645}, {pos = 689838436, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 559323704, events = 8, fd = 1, user_data = 0x821563408}, {pos = 868438016, events = 8, fd = 1, user_data = 0x833c35194}, {pos = 0, events = 0, fd = 548871808, user_data = 0x8282f6c0c}, {pos = 1, events = 0, fd = 868438016, user_data = 0x820b71eb0}, {pos = 674193076, events = 8, fd = 691564896, user_data = 0x829387160 }, {pos = 689934528, events = 8, fd = 559297544, user_data = 0x820b71f90}, {pos = -1381317588, events = 12243, fd = 559296520, user_data = 0x800000001}, {pos = -1381317970, events = 12243, fd = 12240, user_data = 0x820b71eb8}, {pos = 548872080, events = 8, fd = 869234664, user_data = 0x820b72500}, {pos = -1381237104, events = 12243, fd = 559297544, user_data = 0x820b7037f}, {pos = 691221682, events = 8, fd = 559267848, user_data = 0x0}, {pos = 559297544, events = 8, fd = 12240, user_data = 0x8291bd000}, {pos = 1964368, events = 0, fd = 691564896, user_data = 0x8291ddc64}, {pos = 15616, events = 0, fd = 548873264, user_data = 0x820b72000}, {pos = 690495886, events = 8, fd = 691603512, user_data = 0x820b71fc4}, {pos = 868890074, events = 8, fd = 548873264, user_data = 0x820b72000}, {pos = 690587141, events = 8, fd = 548872130, user_data = 0x820b72430}, {pos = 548873264, events = 8, fd = 0, user_data = 0x58d0ef76808f0ca}, {pos = 548873264, events = 8, fd = 868890072, user_data = 0x820b72500}, {pos = 691603512, events = 8, fd = 0, user_data = 0x820b72470}, {pos = 690587405, events = 8, fd = 0, user_data = 0x0}, {pos = 548873632, events = 8, fd = 868890072, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1381288951, events = 12243, fd = 548872536, user_data = 0x8291ddc64}, {pos = 2503, events = 0, fd = -1381288951, user_data = 0x820b72178}, {pos = 689822820, events = 8, fd = 2758, user_data = 0x8291d7120}, {pos = 548872440, events = 8, fd = 559297544, user_data = 0x820b72178}, {pos = 689795360, events = 8, fd = 548872544, user_data = 0x2fd3adaae465}, {pos = 0, events = 0, fd = 0, user_data = 0x8293a90f0}, {pos = 689755472, events = 8, fd = 0, user_data = 0x0}, {pos = 691632560, events = 8, fd = -1381288951, user_data = 0x820b72208}, {pos = 689822820, events = 8, fd = 2924, user_data = 0x8291d73b8}, {pos = 548872584, events = 8, fd = 559297544, user_data = 0x820b72208}, {pos = 689796024, events = 8, fd = 548872688, user_data = 0x2fd3adaae465}, {pos = 559321144, events = 8, fd = 2676322, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 559297544, events = 8, fd = 689755472, user_data = 0x820b724c8}, {pos = 559297544, events = 8, fd = 548873128, user_data = 0x1e}, {pos = 689759456, events = 8, fd = 548872856, user_data = 0x821568248}, {pos = 548873304, events = 8, fd = 548872832, user_data = 0x2fd3adab2da3}, {pos = 559321144, events = 8, fd = 2700047, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 559321144, user_data = 0x1}} [07:57:26.869] last_touch_time = 1712562873 [07:57:26.869] last_lockfile_recheck_time = 1712562873 [07:57:26.869] nevents = 1 [07:57:26.869] #24 0x0000000000861756 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820b72c30) at ../src/backend/postmaster/postmaster.c:1372 [07:57:26.869] userDoption = [07:57:26.869] listen_addr_saved = false [07:57:26.869] output_config_variable = [07:57:26.869] opt = [07:57:26.869] status = [07:57:26.869] #25 0x0000000000798ff5 in main (argc=4, argv=0x820b72c30) at ../src/backend/main/main.c:197 [07:57:26.869] do_check_root = [07:57:26.880] [07:57:26.880] [07:57:26.880] [07:57:26.942] dumping /tmp/cores/postgres.15144.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:57:27.074] [New LWP 101836] [07:57:27.153] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [07:57:27.153] Program terminated with signal SIGABRT, Aborted. [07:57:27.153] Sent by thr_kill() from pid 15144 and user 1003. [07:57:27.153] #0 0x000000082c888dca in thr_kill () from /lib/libc.so.7 [07:57:27.743] [07:57:27.743] Thread 1 (LWP 101836): [07:57:27.743] #0 0x000000082c888dca in thr_kill () from /lib/libc.so.7 [07:57:27.743] No symbol table info available. [07:57:27.743] #1 0x000000082c8016f4 in raise () from /lib/libc.so.7 [07:57:27.743] No symbol table info available. [07:57:27.743] #2 0x000000082c8b2bc9 in abort () from /lib/libc.so.7 [07:57:27.743] No symbol table info available. [07:57:27.743] #3 0x0000000000a61657 in ExceptionalCondition (conditionName=, fileName=0x373253 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [07:57:27.743] No locals. [07:57:27.743] #4 0x0000000000743c80 in ExecFetchSlotHeapTuple (slot=slot@entry=0x8212c51d0, materialize=, shouldFree=shouldFree@entry=0x8212c5196) at ../src/backend/executor/execTuples.c:1737 [07:57:27.743] No locals. [07:57:27.743] #5 0x0000000000709618 in ExecIRDeleteTriggers (estate=estate@entry=0x835f08100, relinfo=relinfo@entry=0x835f086b0, slot=slot@entry=0x8212c51d0) at ../src/backend/commands/trigger.c:2832 [07:57:27.743] trigger = [07:57:27.743] oldtuple = [07:57:27.743] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83c924dd0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [07:57:27.743] trigdesc = 0x835f088c0 [07:57:27.743] newtuple = 0x0 [07:57:27.743] i = 0 [07:57:27.743] should_free = false [07:57:27.743] #6 0x0000000000768d77 in ExecMergeMatched (context=0x8212c5270, resultRelInfo=0x835f086b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:2976 [07:57:27.743] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [07:57:27.743] relaction = 0x835ebe160 [07:57:27.743] commandType = CMD_DELETE [07:57:27.743] result = TM_Ok [07:57:27.743] l__state = {l = 0x83ca73a08, i = 0} [07:57:27.743] mtstate = 0x835f084a0 [07:57:27.743] newslot = 0x0 [07:57:27.743] rslot = 0x0 [07:57:27.743] estate = 0x18dcc [07:57:27.743] mergeActions = [07:57:27.743] econtext = 0x83ca72aa8 [07:57:27.743] epqstate = 0x835f08588 [07:57:27.743] actionStates = 0x83ca73a08 [07:57:27.743] l = [07:57:27.743] isNull = [07:57:27.743] lmerge_matched = [07:57:27.743] __error = [07:57:27.743] l__state = [07:57:27.743] updateCxt = [07:57:27.743] relaction = [07:57:27.743] commandType = [07:57:27.743] result = [07:57:27.743] __error = [07:57:27.743] resultRelationDesc = [07:57:27.743] lockmode = [07:57:27.743] inputslot = [07:57:27.743] epqslot = [07:57:27.743] was_matched = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] #7 ExecMerge (context=0x8212c5270, resultRelInfo=0x835f086b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2738 [07:57:27.743] matched = [07:57:27.743] rslot = 0x0 [07:57:27.743] #8 ExecModifyTable (pstate=0x835f084a0) at ../src/backend/executor/nodeModifyTable.c:4067 [07:57:27.743] context = {mtstate = 0x835f084a0, epqstate = 0x835f08588, estate = 0x835f08100, planSlot = 0x835ebe0d0, tmfd = {ctid = {ip_blkid = {bi_hi = 47653, bi_lo = 44450}, ip_posid = 8376}, xmax = 4, cmax = 0, traversed = 224}, cpUpdateReturningSlot = 0x8212c53d0} [07:57:27.743] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [07:57:27.743] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x835f14118} [07:57:27.743] node = 0x835f084a0 [07:57:27.743] estate = 0x835f08100 [07:57:27.743] operation = CMD_MERGE [07:57:27.743] resultRelInfo = 0x835f086b0 [07:57:27.743] subplanstate = 0x835f09df0 [07:57:27.743] slot = [07:57:27.743] tupleid = 0x0 [07:57:27.743] oldtuple = 0x0 [07:57:27.743] oldSlot = [07:57:27.743] #9 0x000000000073dcbb in ExecProcNodeFirst (node=0x835f084a0) at ../src/backend/executor/execProcnode.c:464 [07:57:27.743] No locals. [07:57:27.743] #10 0x0000000000735faa in ExecProcNode (node=0x835f084a0) at ../src/include/executor/executor.h:274 [07:57:27.743] No locals. [07:57:27.743] #11 ExecutePlan (estate=0x835f08100, planstate=0x835f084a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x835e52f10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [07:57:27.743] current_tuple_count = [07:57:27.743] slot = [07:57:27.743] #12 standard_ExecutorRun (queryDesc=0x835e05448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [07:57:27.743] estate = 0x835f08100 [07:57:27.743] oldcontext = 0x835e52c00 [07:57:27.743] operation = CMD_MERGE [07:57:27.743] dest = 0x835e52f10 [07:57:27.743] sendTuples = true [07:57:27.743] #13 0x0000000838858963 in pgss_ExecutorRun (queryDesc=0x835e05448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [07:57:27.743] _local_sigjmp_buf = {{_sjb = {35308013874, 12186568, 34916291528, 34916291696, 35263632456, 34916291536, 1, 1, 35264660351, 35263632456, 12195296, 34359738368}}} [07:57:27.743] _save_exception_stack = 0x8212c5590 [07:57:27.743] _save_context_stack = 0x0 [07:57:27.743] _do_rethrow = false [07:57:27.743] #14 0x0000000000735e58 in ExecutorRun (queryDesc=0x18dcc, queryDesc@entry=0x835e05448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [07:57:27.743] No locals. [07:57:27.743] #15 0x000000000090efbf in ProcessQuery (plan=0x83ca372c0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8212c5558) at ../src/backend/tcop/pquery.c:160 [07:57:27.743] queryDesc = 0x835e05448 [07:57:27.743] #16 0x000000000090e55d in PortalRunMulti (portal=portal@entry=0x835de7100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x835e52f10, altdest=0xb567e0 , qc=qc@entry=0x8212c5558) at ../src/backend/tcop/pquery.c:1286 [07:57:27.743] pstmt = 0x83ca372c0 [07:57:27.743] stmtlist_item__state = {l = 0x83ca3bb78, i = 0} [07:57:27.743] active_snapshot_set = true [07:57:27.743] stmtlist_item = 0x83ca3bb90 [07:57:27.743] #17 0x000000000090e04c in FillPortalStore (portal=portal@entry=0x835de7100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [07:57:27.743] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:27.743] treceiver = 0x835e52f10 [07:57:27.743] #18 0x000000000090dda0 in PortalRun (portal=portal@entry=0x835de7100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83ca3bbc8, altdest=altdest@entry=0x83ca3bbc8, qc=0x8212c5690) at ../src/backend/tcop/pquery.c:763 [07:57:27.743] _local_sigjmp_buf = {{_sjb = {9493823, 35263841560, 34916291976, 34916292208, 34916291984, 12186568, 12154352, 35263508736, 7112098687, 35263516928, 3580080, 34359738368}}} [07:57:27.743] _save_exception_stack = 0x8212c5760 [07:57:27.743] _save_context_stack = 0x0 [07:57:27.743] _do_rethrow = false [07:57:27.743] saveTopTransactionResourceOwner = 0x835e38518 [07:57:27.743] saveTopTransactionContext = 0x835d58000 [07:57:27.743] saveActivePortal = 0x0 [07:57:27.743] saveResourceOwner = 0x835e38518 [07:57:27.743] savePortalContext = 0x0 [07:57:27.743] saveMemoryContext = 0x835d58000 [07:57:27.743] result = [07:57:27.743] nprocessed = [07:57:27.743] #19 0x000000000090ccab in exec_simple_query (query_string=query_string@entry=0x835d4c100 "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:1274 [07:57:27.743] cmdtaglen = [07:57:27.743] snapshot_set = [07:57:27.743] per_parsetree_context = 0x0 [07:57:27.743] plantree_list = [07:57:27.743] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:57:27.743] parsetree = 0x83ca13528 [07:57:27.743] commandTag = CMDTAG_MERGE [07:57:27.743] cmdtagname = [07:57:27.743] querytree_list = [07:57:27.743] portal = 0x835de7100 [07:57:27.743] format = 0 [07:57:27.743] receiver = 0x83ca3bbc8 [07:57:27.743] parsetree_item__state = {l = 0x83ca14df0, i = 0} [07:57:27.743] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [07:57:27.743] dest = DestRemote [07:57:27.743] was_logged = [07:57:27.743] oldcontext = 0x835d58000 [07:57:27.743] parsetree_list = 0x83ca14df0 [07:57:27.743] use_implicit_block = false [07:57:27.743] parsetree_item = 0x83ca14e08 [07:57:27.743] save_log_statement_stats = [07:57:27.743] #20 0x000000000090aa84 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [07:57:27.743] query_string = 0x835d4c100 "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"... [07:57:27.743] input_message = {data = 0x835d4c100 "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} [07:57:27.743] firstchar = [07:57:27.743] local_sigjmp_buf = {{_sjb = {9477968, 34916292448, 34916292408, 34916293008, 12195304, 12141776, 8192, 8388608, 72057628954198911, 0, 0, 1}}} [07:57:27.743] send_ready_for_query = false [07:57:27.743] idle_in_transaction_timeout_enabled = false [07:57:27.743] idle_session_timeout_enabled = false [07:57:27.743] #21 0x0000000000905559 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [07:57:27.743] bsdata = [07:57:27.743] #22 0x000000000085f522 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8212c64a0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212c63e8) at ../src/backend/postmaster/launch_backend.c:265 [07:57:27.743] pid = [07:57:27.743] #23 0x0000000000863e81 in BackendStartup (client_sock=0x8212c63e8) at ../src/backend/postmaster/postmaster.c:3593 [07:57:27.743] startup_data = {canAcceptConnections = CAC_OK} [07:57:27.743] bn = 0x835d58308 [07:57:27.743] pid = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] save_errno = [07:57:27.743] __error = [07:57:27.743] __error = [07:57:27.743] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [07:57:27.743] 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 = '\000' , "@d,!\b\000\000\000\330u\265+\b\000\000\000\v\000\000\000\000\000\000\000\016\366\265+\b", '\000' , "\200d,!\b\000\000\000\364\362\205\000\000\000\000\000\220d,!\b", '\000' }, salen = 16}} [07:57:27.743] i = 0 [07:57:27.743] now = [07:57:27.743] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 556555200, events = 8, fd = 571339784, user_data = 0x21}, {pos = 556555184, events = 8, fd = 830302868, user_data = 0x8220d8008}, {pos = 571311112, events = 8, fd = 571312136, user_data = 0x8220d8c08}, {pos = 571326472, events = 8, fd = 571327496, user_data = 0x8220dc808}, {pos = 571329544, events = 8, fd = 571330568, user_data = 0x8220dd408}, {pos = 571332616, events = 8, fd = 571333640, user_data = 0x8220de008}, {pos = 571335688, events = 8, fd = 571336712, user_data = 0x8220dec08}, {pos = 571338760, events = 8, fd = 571339784, user_data = 0x8220e4088}, {pos = 556555576, events = 8, fd = 556555088, user_data = 0x2237317dcda3}, {pos = 571339784, events = 8, fd = 2572490, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 571363384, user_data = 0x1}, {pos = 571339784, events = 8, fd = 745911464, user_data = 0x8212c5e38}, {pos = 571339784, events = 8, fd = 556555056, user_data = 0x274014}, {pos = 556555648, events = 8, fd = 746019172, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 571365944, user_data = 0x223700000001}, {pos = 571339784, events = 8, fd = 745933016, user_data = 0x8212c5c78}, {pos = 556554784, events = 8, fd = 33, user_data = 0x82c771c64}, {pos = 571339784, events = 8, fd = 571365944, user_data = 0x0}, {pos = 2625, events = 0, fd = 556555360, user_data = 0x2237317d6645}, {pos = 746019172, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 571365944, events = 8, fd = 1, user_data = 0x8220df408}, {pos = 903069696, events = 8, fd = 1, user_data = 0x835d3c194}, {pos = 0, events = 0, fd = 556555312, user_data = 0x82bb5ec0c}, {pos = 1, events = 0, fd = 903069696, user_data = 0x8212c5c60}, {pos = 733339316, events = 8, fd = 747745632, user_data = 0x82c91b160 }, {pos = 746115264, events = 8, fd = 571339784, user_data = 0x8212c5d40}, {pos = 830301228, events = 8759, fd = 80627796, user_data = 0x1}, {pos = 830300846, events = 8759, fd = 12240, user_data = 0x8212c5c68}, {pos = 556555584, events = 8, fd = 903866344, user_data = 0x8212c62b0}, {pos = 830381712, events = 8759, fd = 571339784, user_data = 0x8212c037f}, {pos = 747402418, events = 8, fd = 556555888, user_data = 0x223700000000}, {pos = 571339784, events = 8, fd = 12240, user_data = 0x82c751000}, {pos = 1964368, events = 0, fd = 747745632, user_data = 0x82c771c64}, {pos = 15616, events = 0, fd = 556556768, user_data = 0x8212c5db0}, {pos = 746676622, events = 8, fd = 747784248, user_data = 0x8212c5d74}, {pos = 903521754, events = 8, fd = 556556768, user_data = 0x8212c5db0}, {pos = 746767877, events = 8, fd = 556555634, user_data = 0x8212c61e0}, {pos = 556556768, events = 8, fd = 0, user_data = 0xa35b20b8ada2ba25}, {pos = 556556768, events = 8, fd = 903521752, user_data = 0x8212c62b0}, {pos = 747784248, events = 8, fd = 0, user_data = 0x8212c6220}, {pos = 746768141, events = 8, fd = 0, user_data = 0x0}, {pos = 556557136, events = 8, fd = 903521752, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 830329865, user_data = 0x8212c5ef8}, {pos = 746003556, events = 8, fd = 2503, user_data = 0x2237317dd409}, {pos = 556556056, events = 8, fd = 746003556, user_data = 0xac6}, {pos = 745976096, events = 8, fd = 556555928, user_data = 0x8220df408}, {pos = 556556056, events = 8, fd = 745976096, user_data = 0x8212c5f00}, {pos = 830309477, events = 8759, fd = 0, user_data = 0x800000000}, {pos = 556556016, events = 8, fd = 745936208, user_data = 0x0}, {pos = 0, events = 0, fd = 556555984, user_data = 0x2237317dd409}, {pos = 556556200, events = 8, fd = 746003556, user_data = 0xb6c}, {pos = 745976760, events = 8, fd = 556556072, user_data = 0x8220df408}, {pos = 556556200, events = 8, fd = 745976760, user_data = 0x8212c5f90}, {pos = 830309477, events = 8759, fd = 571363384, user_data = 0x28d662}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 571339784, user_data = 0x82c761550}, {pos = 556556920, events = 8, fd = 571339784, user_data = 0x212c6158}, {pos = 31, events = 0, fd = 0, user_data = 0x8212c6038}, {pos = 571361160, events = 8, fd = 556556808, user_data = 0x8212c6020}, {pos = 830328227, events = 8759, fd = 571363384, user_data = 0x29330f}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8220e5038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [07:57:27.743] last_touch_time = 1712562893 [07:57:27.743] last_lockfile_recheck_time = 1712562893 [07:57:27.743] nevents = 1 [07:57:27.743] #25 0x0000000000861756 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8212c69e0) at ../src/backend/postmaster/postmaster.c:1372 [07:57:27.743] userDoption = [07:57:27.743] listen_addr_saved = false [07:57:27.743] output_config_variable = [07:57:27.743] opt = [07:57:27.743] status = [07:57:27.743] #26 0x0000000000798ff5 in main (argc=4, argv=0x8212c69e0) at ../src/backend/main/main.c:197 [07:57:27.743] do_check_root =