[21:11:58.934] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [21:11:59.300] dumping /tmp/cores/postgres.8198.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [21:11:59.438] [New LWP 101739] [21:11:59.522] Core was generated by `postgres: postgres regression [local] MERGE'. [21:11:59.522] Program terminated with signal SIGABRT, Aborted. [21:11:59.522] Sent by thr_kill() from pid 8198 and user 1003. [21:11:59.522] #0 0x000000082aa42dca in thr_kill () from /lib/libc.so.7 [21:12:00.061] [21:12:00.061] Thread 1 (LWP 101739): [21:12:00.061] #0 0x000000082aa42dca in thr_kill () from /lib/libc.so.7 [21:12:00.061] No symbol table info available. [21:12:00.061] #1 0x000000082a9bb6f4 in raise () from /lib/libc.so.7 [21:12:00.061] No symbol table info available. [21:12:00.061] #2 0x000000082aa6cbc9 in abort () from /lib/libc.so.7 [21:12:00.061] No symbol table info available. [21:12:00.061] #3 0x0000000000a5c137 in ExceptionalCondition (conditionName=, fileName=0x372cab "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:12:00.061] No locals. [21:12:00.061] #4 0x000000000073eb60 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820cdcef0, materialize=, shouldFree=shouldFree@entry=0x820cdce96) at ../src/backend/executor/execTuples.c:1737 [21:12:00.061] No locals. [21:12:00.061] #5 0x0000000000704d58 in ExecIRDeleteTriggers (estate=estate@entry=0x836a23100, relinfo=relinfo@entry=0x836a236b0, slot=slot@entry=0x820cdcef0) at ../src/backend/commands/trigger.c:2841 [21:12:00.061] trigger = [21:12:00.061] oldtuple = [21:12:00.061] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8434c54e8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:12:00.061] trigdesc = 0x836a238c0 [21:12:00.061] newtuple = 0x0 [21:12:00.061] i = 0 [21:12:00.061] should_free = false [21:12:00.061] #6 0x0000000000763c5a in ExecMergeMatched (context=0x820cdcfb0, resultRelInfo=0x836a236b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [21:12:00.061] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:12:00.061] relaction = 0x843597560 [21:12:00.061] commandType = CMD_DELETE [21:12:00.061] result = TM_Ok [21:12:00.061] l__state = {l = 0x8436011c8, i = 0} [21:12:00.061] mtstate = 0x836a234a0 [21:12:00.061] newslot = 0x0 [21:12:00.061] rslot = 0x0 [21:12:00.061] estate = 0x18d6b [21:12:00.061] mergeActions = [21:12:00.061] econtext = 0x843600268 [21:12:00.061] epqstate = 0x836a23588 [21:12:00.061] actionStates = 0x8436011c8 [21:12:00.061] l = [21:12:00.061] isNull = [21:12:00.061] lmerge_matched = [21:12:00.061] __error = [21:12:00.061] l__state = [21:12:00.061] updateCxt = [21:12:00.061] relaction = [21:12:00.061] commandType = [21:12:00.061] result = [21:12:00.061] __error = [21:12:00.061] resultRelationDesc = [21:12:00.061] lockmode = [21:12:00.061] inputslot = [21:12:00.061] epqslot = [21:12:00.061] was_matched = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] #7 ExecMerge (context=0x820cdcfb0, resultRelInfo=0x836a236b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:12:00.061] matched = [21:12:00.061] rslot = 0x0 [21:12:00.061] #8 ExecModifyTable (pstate=0x836a234a0) at ../src/backend/executor/nodeModifyTable.c:4112 [21:12:00.061] context = {mtstate = 0x836a234a0, epqstate = 0x836a23588, estate = 0x836a23100, planSlot = 0x8435974d0, tmfd = {ctid = {ip_blkid = {bi_hi = 1856, bi_lo = 17251}, ip_posid = 8}, xmax = 916600496, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x836a23100} [21:12:00.061] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [21:12:00.061] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836a37118} [21:12:00.061] node = 0x836a234a0 [21:12:00.061] estate = 0x836a23100 [21:12:00.061] operation = CMD_MERGE [21:12:00.061] resultRelInfo = 0x836a236b0 [21:12:00.061] subplanstate = 0x836a24df0 [21:12:00.061] slot = [21:12:00.061] tupleid = 0x0 [21:12:00.061] oldtuple = 0x0 [21:12:00.061] oldSlot = [21:12:00.061] #9 0x0000000000738bfb in ExecProcNodeFirst (node=0x836a234a0) at ../src/backend/executor/execProcnode.c:464 [21:12:00.061] No locals. [21:12:00.061] #10 0x0000000000730eea in ExecProcNode (node=0x836a234a0) at ../src/include/executor/executor.h:274 [21:12:00.061] No locals. [21:12:00.061] #11 ExecutePlan (estate=0x836a23100, planstate=0x836a234a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836a04310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [21:12:00.061] current_tuple_count = [21:12:00.061] slot = [21:12:00.061] #12 standard_ExecutorRun (queryDesc=0x836904448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:12:00.061] estate = 0x836a23100 [21:12:00.061] oldcontext = 0x836a04000 [21:12:00.061] operation = CMD_MERGE [21:12:00.061] dest = 0x836a04310 [21:12:00.061] sendTuples = true [21:12:00.061] #13 0x0000000000730d9f in ExecutorRun (queryDesc=0x18d6b, queryDesc@entry=0x836904448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:12:00.061] No locals. [21:12:00.061] #14 0x0000000000909b8f in ProcessQuery (plan=0x84362dc20, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820cdd1c8) at ../src/backend/tcop/pquery.c:160 [21:12:00.061] queryDesc = 0x836904448 [21:12:00.061] #15 0x000000000090912d in PortalRunMulti (portal=portal@entry=0x836937100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836a04310, altdest=0xb501f0 , qc=qc@entry=0x820cdd1c8) at ../src/backend/tcop/pquery.c:1286 [21:12:00.061] pstmt = 0x84362dc20 [21:12:00.061] stmtlist_item__state = {l = 0x8436324d8, i = 0} [21:12:00.061] active_snapshot_set = true [21:12:00.061] stmtlist_item = 0x8436324f0 [21:12:00.061] #16 0x0000000000908c1c in FillPortalStore (portal=portal@entry=0x836937100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:12:00.061] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:12:00.061] treceiver = 0x836a04310 [21:12:00.061] #17 0x0000000000908970 in PortalRun (portal=portal@entry=0x836937100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x843632528, altdest=altdest@entry=0x843632528, qc=0x820cdd300) at ../src/backend/tcop/pquery.c:763 [21:12:00.061] _local_sigjmp_buf = {{_sjb = {9472271, 35275443224, 34910097912, 34910098144, 34910097920, 12160184, 12127968, 35275370752, 7112098687, 35275378944, 3578651, 34359738368}}} [21:12:00.061] _save_exception_stack = 0x820cdd3d0 [21:12:00.061] _save_context_stack = 0x0 [21:12:00.061] _do_rethrow = false [21:12:00.061] saveTopTransactionResourceOwner = 0x836948c18 [21:12:00.061] saveTopTransactionContext = 0x83686d000 [21:12:00.061] saveActivePortal = 0x0 [21:12:00.061] saveResourceOwner = 0x836948c18 [21:12:00.061] savePortalContext = 0x0 [21:12:00.061] saveMemoryContext = 0x83686d000 [21:12:00.061] result = [21:12:00.061] nprocessed = [21:12:00.061] #18 0x000000000090787b in exec_simple_query (query_string=query_string@entry=0x836861100 "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 [21:12:00.061] cmdtaglen = [21:12:00.061] snapshot_set = [21:12:00.061] per_parsetree_context = 0x0 [21:12:00.061] plantree_list = [21:12:00.061] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:12:00.061] parsetree = 0x8435ce828 [21:12:00.061] commandTag = CMDTAG_MERGE [21:12:00.061] cmdtagname = [21:12:00.061] querytree_list = [21:12:00.061] portal = 0x836937100 [21:12:00.061] format = 0 [21:12:00.061] receiver = 0x843632528 [21:12:00.061] parsetree_item__state = {l = 0x8435d00f0, i = 0} [21:12:00.061] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:12:00.061] dest = DestRemote [21:12:00.061] was_logged = [21:12:00.061] oldcontext = 0x83686d000 [21:12:00.061] parsetree_list = 0x8435d00f0 [21:12:00.061] use_implicit_block = false [21:12:00.061] parsetree_item = 0x8435d0108 [21:12:00.061] save_log_statement_stats = [21:12:00.061] #19 0x0000000000905654 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:12:00.061] query_string = 0x836861100 "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"... [21:12:00.061] input_message = {data = 0x836861100 "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} [21:12:00.061] firstchar = [21:12:00.061] local_sigjmp_buf = {{_sjb = {9456416, 34910098384, 34910098344, 34910098944, 12168920, 12115392, 8192, 8388608, 72057628947972991, 0, 0, 34359738369}}} [21:12:00.061] send_ready_for_query = false [21:12:00.061] idle_in_transaction_timeout_enabled = false [21:12:00.061] idle_session_timeout_enabled = false [21:12:00.061] #20 0x0000000000900129 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:12:00.061] bsdata = [21:12:00.061] #21 0x000000000085a002 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820cde110 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820cde058) at ../src/backend/postmaster/launch_backend.c:265 [21:12:00.061] pid = [21:12:00.061] #22 0x000000000085e961 in BackendStartup (client_sock=0x820cde058) at ../src/backend/postmaster/postmaster.c:3593 [21:12:00.061] startup_data = {canAcceptConnections = CAC_OK} [21:12:00.061] bn = 0x83686d268 [21:12:00.061] pid = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] save_errno = [21:12:00.061] __error = [21:12:00.061] __error = [21:12:00.061] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:12:00.061] 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' , "\260\340\315 \b\000\000\000\330\325r*\b\000\000\000\v\000\000\000\000\000\000\000\016Vs*\b", '\000' , "\360\340\315 \b\000\000\000ԝ\205\000\000\000\000\000\000\341\315 \b", '\000' }, salen = 16}} [21:12:00.061] i = 0 [21:12:00.061] now = [21:12:00.061] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 714259556, events = 8, fd = 550360736, user_data = 0x820cdd830}, {pos = 563164168, events = 8, fd = 32, user_data = 0x820cdd820}, {pos = 1343232660, events = 9823, fd = 563134472, user_data = 0x82190c408}, {pos = 563136520, events = 8, fd = 563137544, user_data = 0x821910008}, {pos = 563151880, events = 8, fd = 563152904, user_data = 0x821910c08}, {pos = 563154952, events = 8, fd = 563155976, user_data = 0x821911808}, {pos = 563158024, events = 8, fd = 563159048, user_data = 0x821912408}, {pos = 563161096, events = 8, fd = 563162120, user_data = 0x821913008}, {pos = 563164168, events = 8, fd = -1, user_data = 0x82ab032e0}, {pos = 550360976, events = 8, fd = 715850153, user_data = 0x0}, {pos = 4096, events = 0, fd = 1024957346, user_data = 0x82ab037e8}, {pos = 912301024, events = 8, fd = 160, user_data = 0x0}, {pos = 878706832, events = 8, fd = 550361184, user_data = 0x82aa8e92c}, {pos = 4096, events = 0, fd = 714275172, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 563190328, user_data = 0x800000001}, {pos = 563164168, events = 8, fd = 714189016, user_data = 0x820cdd8e8}, {pos = 550360736, events = 8, fd = 32, user_data = 0x82a92bc64}, {pos = 563164168, events = 8, fd = 563190328, user_data = 0x0}, {pos = 2625, events = 0, fd = 550361296, user_data = 0x265f50101645}, {pos = 714275172, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 563190328, events = 8, fd = 1, user_data = 0x821913408}, {pos = 914690048, events = 8, fd = 1, user_data = 0x836851194}, {pos = 0, events = 0, fd = 550361248, user_data = 0x82a734c0c}, {pos = 1, events = 0, fd = 914690048, user_data = 0x820cdd8d0}, {pos = 712195764, events = 8, fd = 716001632, user_data = 0x82aad5160 }, {pos = 714371264, events = 8, fd = 563164168, user_data = 0x820cdd9b0}, {pos = 1343231020, events = 9823, fd = 878706832, user_data = 0x800000001}, {pos = 1343230638, events = 9823, fd = 12240, user_data = 0x820cdd8d8}, {pos = 550361520, events = 8, fd = 915396584, user_data = 0x820cddf20}, {pos = 1343311504, events = 9823, fd = 563164168, user_data = 0x820cd037f}, {pos = 715658652, events = 8, fd = 563134472, user_data = 0x0}, {pos = 563164168, events = 8, fd = 12240, user_data = 0x82a90b000}, {pos = 1964368, events = 0, fd = 716001632, user_data = 0x82a92bc64}, {pos = 15616, events = 0, fd = 550362704, user_data = 0x820cdda20}, {pos = 714932622, events = 8, fd = 716040248, user_data = 0x820cdd9e4}, {pos = 915133914, events = 8, fd = 550362704, user_data = 0x820cdda20}, {pos = 715023877, events = 8, fd = 550361570, user_data = 0x820cdde50}, {pos = 550362704, events = 8, fd = 0, user_data = 0x2e806abc3d179ba2}, {pos = 550362704, events = 8, fd = 915133912, user_data = 0x820cddf20}, {pos = 716040248, events = 8, fd = 0, user_data = 0x820cdde90}, {pos = 715024141, events = 8, fd = 0, user_data = 0x0}, {pos = 550363072, events = 8, fd = 915133912, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1343259657, events = 9823, fd = 550361976, user_data = 0x82a92bc64}, {pos = 2503, events = 0, fd = 1343259657, user_data = 0x820cddb98}, {pos = 714259556, events = 8, fd = 2758, user_data = 0x82a925120}, {pos = 550361880, events = 8, fd = 563164168, user_data = 0x820cddb98}, {pos = 714232096, events = 8, fd = 550361984, user_data = 0x265f50103465}, {pos = 0, events = 0, fd = 0, user_data = 0x82aaf70f0}, {pos = 714192208, events = 8, fd = 0, user_data = 0x0}, {pos = 716069296, events = 8, fd = 1343259657, user_data = 0x820cddc28}, {pos = 714259556, events = 8, fd = 2924, user_data = 0x82a9253b8}, {pos = 550362024, events = 8, fd = 563164168, user_data = 0x820cddc28}, {pos = 714232760, events = 8, fd = 550362128, user_data = 0x265f50103465}, {pos = 563187768, events = 8, fd = 2675238, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 563164168, events = 8, fd = 714192208, user_data = 0x820cddee8}, {pos = 563164168, events = 8, fd = 550362568, user_data = 0x1e}, {pos = 714196192, events = 8, fd = 550362296, user_data = 0x821918248}, {pos = 550362744, events = 8, fd = 550362272, user_data = 0x265f50107da3}, {pos = 563187768, events = 8, fd = 2698926, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 563187768, user_data = 0x1}} [21:12:00.061] last_touch_time = 1713128949 [21:12:00.061] last_lockfile_recheck_time = 1713128949 [21:12:00.061] nevents = 1 [21:12:00.061] #24 0x000000000085c236 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820cde658) at ../src/backend/postmaster/postmaster.c:1372 [21:12:00.061] userDoption = [21:12:00.061] listen_addr_saved = false [21:12:00.061] output_config_variable = [21:12:00.061] opt = [21:12:00.061] status = [21:12:00.061] #25 0x0000000000794165 in main (argc=8, argv=0x820cde658) at ../src/backend/main/main.c:197 [21:12:00.061] do_check_root = [21:12:00.072] [21:12:00.072] [21:12:00.072] [21:12:00.131] dumping /tmp/cores/postgres.9049.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:12:00.257] [New LWP 101805] [21:12:00.321] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [21:12:00.321] Program terminated with signal SIGABRT, Aborted. [21:12:00.321] Sent by thr_kill() from pid 9049 and user 1003. [21:12:00.321] #0 0x000000082b498dca in thr_kill () from /lib/libc.so.7 [21:12:00.828] [21:12:00.828] Thread 1 (LWP 101805): [21:12:00.828] #0 0x000000082b498dca in thr_kill () from /lib/libc.so.7 [21:12:00.828] No symbol table info available. [21:12:00.828] #1 0x000000082b4116f4 in raise () from /lib/libc.so.7 [21:12:00.828] No symbol table info available. [21:12:00.828] #2 0x000000082b4c2bc9 in abort () from /lib/libc.so.7 [21:12:00.828] No symbol table info available. [21:12:00.828] #3 0x0000000000a5c137 in ExceptionalCondition (conditionName=, fileName=0x372cab "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:12:00.828] No locals. [21:12:00.828] #4 0x000000000073eb60 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821a94d40, materialize=, shouldFree=shouldFree@entry=0x821a94ce6) at ../src/backend/executor/execTuples.c:1737 [21:12:00.828] No locals. [21:12:00.828] #5 0x0000000000704d58 in ExecIRDeleteTriggers (estate=estate@entry=0x834684100, relinfo=relinfo@entry=0x8346846b0, slot=slot@entry=0x821a94d40) at ../src/backend/commands/trigger.c:2841 [21:12:00.828] trigger = [21:12:00.828] oldtuple = [21:12:00.828] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x844ade7e8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:12:00.828] trigdesc = 0x8346848c0 [21:12:00.828] newtuple = 0x0 [21:12:00.828] i = 0 [21:12:00.828] should_free = false [21:12:00.828] #6 0x0000000000763c5a in ExecMergeMatched (context=0x821a94e00, resultRelInfo=0x8346846b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [21:12:00.828] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:12:00.828] relaction = 0x842d5e060 [21:12:00.828] commandType = CMD_DELETE [21:12:00.828] result = TM_Ok [21:12:00.828] l__state = {l = 0x842e6ee48, i = 0} [21:12:00.828] mtstate = 0x8346844a0 [21:12:00.828] newslot = 0x0 [21:12:00.828] rslot = 0x0 [21:12:00.828] estate = 0x18dad [21:12:00.828] mergeActions = [21:12:00.828] econtext = 0x842e6dee8 [21:12:00.828] epqstate = 0x834684588 [21:12:00.828] actionStates = 0x842e6ee48 [21:12:00.828] l = [21:12:00.828] isNull = [21:12:00.828] lmerge_matched = [21:12:00.828] __error = [21:12:00.828] l__state = [21:12:00.828] updateCxt = [21:12:00.828] relaction = [21:12:00.828] commandType = [21:12:00.828] result = [21:12:00.828] __error = [21:12:00.828] resultRelationDesc = [21:12:00.828] lockmode = [21:12:00.828] inputslot = [21:12:00.828] epqslot = [21:12:00.828] was_matched = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] #7 ExecMerge (context=0x821a94e00, resultRelInfo=0x8346846b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:12:00.828] matched = [21:12:00.828] rslot = 0x0 [21:12:00.828] #8 ExecModifyTable (pstate=0x8346844a0) at ../src/backend/executor/nodeModifyTable.c:4112 [21:12:00.828] context = {mtstate = 0x8346844a0, epqstate = 0x834684588, estate = 0x834684100, planSlot = 0x842d5dfd0, tmfd = {ctid = {ip_blkid = {bi_hi = 36288, bi_lo = 17125}, ip_posid = 8}, xmax = 879249072, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x834684100} [21:12:00.828] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [21:12:00.828] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8346b1118} [21:12:00.828] node = 0x8346844a0 [21:12:00.828] estate = 0x834684100 [21:12:00.828] operation = CMD_MERGE [21:12:00.828] resultRelInfo = 0x8346846b0 [21:12:00.828] subplanstate = 0x834685df0 [21:12:00.828] slot = [21:12:00.828] tupleid = 0x0 [21:12:00.828] oldtuple = 0x0 [21:12:00.828] oldSlot = [21:12:00.828] #9 0x0000000000738bfb in ExecProcNodeFirst (node=0x8346844a0) at ../src/backend/executor/execProcnode.c:464 [21:12:00.828] No locals. [21:12:00.828] #10 0x0000000000730eea in ExecProcNode (node=0x8346844a0) at ../src/include/executor/executor.h:274 [21:12:00.828] No locals. [21:12:00.828] #11 ExecutePlan (estate=0x834684100, planstate=0x8346844a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x83451d310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [21:12:00.828] current_tuple_count = [21:12:00.828] slot = [21:12:00.828] #12 standard_ExecutorRun (queryDesc=0x83459e448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:12:00.828] estate = 0x834684100 [21:12:00.828] oldcontext = 0x83451d000 [21:12:00.828] operation = CMD_MERGE [21:12:00.828] dest = 0x83451d310 [21:12:00.828] sendTuples = true [21:12:00.828] #13 0x0000000000730d9f in ExecutorRun (queryDesc=0x18dad, queryDesc@entry=0x83459e448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [21:12:00.828] No locals. [21:12:00.828] #14 0x0000000000909b8f in ProcessQuery (plan=0x842e562a0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821a95018) at ../src/backend/tcop/pquery.c:160 [21:12:00.828] queryDesc = 0x83459e448 [21:12:00.828] #15 0x000000000090912d in PortalRunMulti (portal=portal@entry=0x83457e100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83451d310, altdest=0xb501f0 , qc=qc@entry=0x821a95018) at ../src/backend/tcop/pquery.c:1286 [21:12:00.828] pstmt = 0x842e562a0 [21:12:00.828] stmtlist_item__state = {l = 0x842e5ab58, i = 0} [21:12:00.828] active_snapshot_set = true [21:12:00.828] stmtlist_item = 0x842e5ab70 [21:12:00.828] #16 0x0000000000908c1c in FillPortalStore (portal=portal@entry=0x83457e100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:12:00.828] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:12:00.828] treceiver = 0x83451d310 [21:12:00.828] #17 0x0000000000908970 in PortalRun (portal=portal@entry=0x83457e100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x842e5aba8, altdest=altdest@entry=0x842e5aba8, qc=0x821a95150) at ../src/backend/tcop/pquery.c:763 [21:12:00.828] _local_sigjmp_buf = {{_sjb = {9472271, 35238216280, 34924482632, 34924482864, 34924482640, 12160184, 12127968, 35237912832, 7112098687, 35237921024, 3578651, 34359738368}}} [21:12:00.828] _save_exception_stack = 0x821a95220 [21:12:00.828] _save_context_stack = 0x0 [21:12:00.828] _do_rethrow = false [21:12:00.828] saveTopTransactionResourceOwner = 0x8345c8258 [21:12:00.828] saveTopTransactionContext = 0x8344f1000 [21:12:00.828] saveActivePortal = 0x0 [21:12:00.828] saveResourceOwner = 0x8345c8258 [21:12:00.828] savePortalContext = 0x0 [21:12:00.828] saveMemoryContext = 0x8344f1000 [21:12:00.828] result = [21:12:00.828] nprocessed = [21:12:00.828] #18 0x000000000090787b in exec_simple_query (query_string=query_string@entry=0x8344e5100 "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 [21:12:00.828] cmdtaglen = [21:12:00.828] snapshot_set = [21:12:00.828] per_parsetree_context = 0x0 [21:12:00.828] plantree_list = [21:12:00.828] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:12:00.828] parsetree = 0x842e085e8 [21:12:00.828] commandTag = CMDTAG_MERGE [21:12:00.828] cmdtagname = [21:12:00.828] querytree_list = [21:12:00.828] portal = 0x83457e100 [21:12:00.828] format = 0 [21:12:00.828] receiver = 0x842e5aba8 [21:12:00.828] parsetree_item__state = {l = 0x842e09eb0, i = 0} [21:12:00.828] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:12:00.828] dest = DestRemote [21:12:00.828] was_logged = [21:12:00.828] oldcontext = 0x8344f1000 [21:12:00.828] parsetree_list = 0x842e09eb0 [21:12:00.828] use_implicit_block = false [21:12:00.828] parsetree_item = 0x842e09ec8 [21:12:00.828] save_log_statement_stats = [21:12:00.828] #19 0x0000000000905654 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:12:00.828] query_string = 0x8344e5100 "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"... [21:12:00.828] input_message = {data = 0x8344e5100 "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} [21:12:00.828] firstchar = [21:12:00.828] local_sigjmp_buf = {{_sjb = {9456416, 34924483104, 34924483064, 34924483664, 12168920, 12115392, 8192, 8388608, 72057628962390911, 0, 0, 34359738369}}} [21:12:00.828] send_ready_for_query = false [21:12:00.828] idle_in_transaction_timeout_enabled = false [21:12:00.828] idle_session_timeout_enabled = false [21:12:00.828] #20 0x0000000000900129 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:12:00.828] bsdata = [21:12:00.828] #21 0x000000000085a002 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a95f60 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a95ea8) at ../src/backend/postmaster/launch_backend.c:265 [21:12:00.828] pid = [21:12:00.828] #22 0x000000000085e961 in BackendStartup (client_sock=0x821a95ea8) at ../src/backend/postmaster/postmaster.c:3593 [21:12:00.828] startup_data = {canAcceptConnections = CAC_OK} [21:12:00.828] bn = 0x8344f1498 [21:12:00.828] pid = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] save_errno = [21:12:00.828] __error = [21:12:00.828] __error = [21:12:00.828] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:12:00.828] 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' , "_\251!\b\000\000\000\330\025\024+\b\000\000\000\v\000\000\000\000\000\000\000\016\226\024+\b", '\000' , "@_\251!\b\000\000\000ԝ\205\000\000\000\000\000P_\251!\b", '\000' }, salen = 16}} [21:12:00.828] i = 0 [21:12:00.828] now = [21:12:00.828] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 725097572, events = 8, fd = 564745456, user_data = 0x821a95680}, {pos = 568923144, events = 8, fd = 32, user_data = 0x821a95670}, {pos = -1912554860, events = 12625, fd = 568893448, user_data = 0x821e8a408}, {pos = 568895496, events = 8, fd = 568896520, user_data = 0x821e8e008}, {pos = 568910856, events = 8, fd = 568911880, user_data = 0x821e8ec08}, {pos = 568913928, events = 8, fd = 568914952, user_data = 0x821e8f808}, {pos = 568917000, events = 8, fd = 568918024, user_data = 0x821e90408}, {pos = 568920072, events = 8, fd = 568921096, user_data = 0x821e91008}, {pos = 568923144, events = 8, fd = 568942728, user_data = 0x821a957f8}, {pos = 564745760, events = 8, fd = -1912529501, user_data = 0x0}, {pos = 2571482, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 568946744, events = 8, fd = 1, user_data = 0x821e91408}, {pos = 725005480, events = 8, fd = 564746488, user_data = 0x821e91408}, {pos = 564745744, events = 0, fd = 725113188, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 568949304, user_data = 0x1}, {pos = 568923144, events = 8, fd = 725027032, user_data = 0x821a95738}, {pos = 564745456, events = 8, fd = 32, user_data = 0x82b381c64}, {pos = 568923144, events = 8, fd = 568949304, user_data = 0x0}, {pos = 2625, events = 0, fd = 564746016, user_data = 0x31518e00b645}, {pos = 725113188, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 568949304, events = 8, fd = 1, user_data = 0x821e91408}, {pos = 877481984, events = 8, fd = 1, user_data = 0x8344d5194}, {pos = 0, events = 0, fd = 564745968, user_data = 0x82b148c0c}, {pos = 1, events = 0, fd = 877481984, user_data = 0x821a95720}, {pos = 722763444, events = 8, fd = 726839648, user_data = 0x82b52b160 }, {pos = 725209280, events = 8, fd = 568923144, user_data = 0x821a95800}, {pos = -1912556500, events = 12625, fd = 568922120, user_data = 0x800000001}, {pos = -1912556882, events = 12625, fd = 12240, user_data = 0x821a95728}, {pos = 564746240, events = 8, fd = 878278632, user_data = 0x821a95d70}, {pos = -1912476016, events = 12625, fd = 568923144, user_data = 0x821a9037f}, {pos = 726496434, events = 8, fd = 568893448, user_data = 0x0}, {pos = 568923144, events = 8, fd = 12240, user_data = 0x82b361000}, {pos = 1964368, events = 0, fd = 726839648, user_data = 0x82b381c64}, {pos = 15616, events = 0, fd = 564747424, user_data = 0x821a95870}, {pos = 725770638, events = 8, fd = 726878264, user_data = 0x821a95834}, {pos = 877934042, events = 8, fd = 564747424, user_data = 0x821a95870}, {pos = 725861893, events = 8, fd = 564746290, user_data = 0x821a95ca0}, {pos = 564747424, events = 8, fd = 0, user_data = 0x98b8968e506d2cc2}, {pos = 564747424, events = 8, fd = 877934040, user_data = 0x821a95d70}, {pos = 726878264, events = 8, fd = 0, user_data = 0x821a95ce0}, {pos = 725862157, events = 8, fd = 0, user_data = 0x0}, {pos = 564747792, events = 8, fd = 877934040, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1912527863, events = 12625, fd = 564746696, user_data = 0x82b381c64}, {pos = 2503, events = 0, fd = -1912527863, user_data = 0x821a959e8}, {pos = 725097572, events = 8, fd = 2758, user_data = 0x82b37b120}, {pos = 564746600, events = 8, fd = 568923144, user_data = 0x821a959e8}, {pos = 725070112, events = 8, fd = 564746704, user_data = 0x31518e00d465}, {pos = 0, events = 0, fd = 0, user_data = 0x82b54d0f0}, {pos = 725030224, events = 8, fd = 0, user_data = 0x0}, {pos = 726907312, events = 8, fd = -1912527863, user_data = 0x821a95a78}, {pos = 725097572, events = 8, fd = 2924, user_data = 0x82b37b3b8}, {pos = 564746744, events = 8, fd = 568923144, user_data = 0x821a95a78}, {pos = 725070776, events = 8, fd = 564746848, user_data = 0x31518e00d465}, {pos = 568946744, events = 8, fd = 2675238, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 568923144, events = 8, fd = 725030224, user_data = 0x821a95d38}, {pos = 568923144, events = 8, fd = 564747288, user_data = 0x1e}, {pos = 725034208, events = 8, fd = 564747016, user_data = 0x821e96248}, {pos = 564747464, events = 8, fd = 564746992, user_data = 0x31518e011da3}, {pos = 568946744, events = 8, fd = 2698926, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 568946744, user_data = 0x1}} [21:12:00.828] last_touch_time = 1713128951 [21:12:00.828] last_lockfile_recheck_time = 1713128951 [21:12:00.828] nevents = 1 [21:12:00.828] #24 0x000000000085c236 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a964a0) at ../src/backend/postmaster/postmaster.c:1372 [21:12:00.828] userDoption = [21:12:00.828] listen_addr_saved = false [21:12:00.828] output_config_variable = [21:12:00.828] opt = [21:12:00.828] status = [21:12:00.828] #25 0x0000000000794165 in main (argc=4, argv=0x821a964a0) at ../src/backend/main/main.c:197 [21:12:00.828] do_check_root = [21:12:00.838] [21:12:00.838] [21:12:00.838] [21:12:00.898] dumping /tmp/cores/postgres.13834.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:12:01.023] [New LWP 101796] [21:12:01.088] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [21:12:01.088] Program terminated with signal SIGABRT, Aborted. [21:12:01.088] Sent by thr_kill() from pid 13834 and user 1003. [21:12:01.088] #0 0x000000082c850dca in thr_kill () from /lib/libc.so.7 [21:12:01.613] [21:12:01.613] Thread 1 (LWP 101796): [21:12:01.613] #0 0x000000082c850dca in thr_kill () from /lib/libc.so.7 [21:12:01.613] No symbol table info available. [21:12:01.613] #1 0x000000082c7c96f4 in raise () from /lib/libc.so.7 [21:12:01.613] No symbol table info available. [21:12:01.613] #2 0x000000082c87abc9 in abort () from /lib/libc.so.7 [21:12:01.613] No symbol table info available. [21:12:01.613] #3 0x0000000000a5c137 in ExceptionalCondition (conditionName=, fileName=0x372cab "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:12:01.613] No locals. [21:12:01.613] #4 0x000000000073eb60 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821182550, materialize=, shouldFree=shouldFree@entry=0x8211824f6) at ../src/backend/executor/execTuples.c:1737 [21:12:01.613] No locals. [21:12:01.613] #5 0x0000000000704d58 in ExecIRDeleteTriggers (estate=estate@entry=0x8341e5100, relinfo=relinfo@entry=0x8341e56b0, slot=slot@entry=0x821182550) at ../src/backend/commands/trigger.c:2841 [21:12:01.613] trigger = [21:12:01.613] oldtuple = [21:12:01.613] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x83a5aced0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:12:01.613] trigdesc = 0x8341e58c0 [21:12:01.613] newtuple = 0x0 [21:12:01.613] i = 0 [21:12:01.613] should_free = false [21:12:01.613] #6 0x0000000000763c5a in ExecMergeMatched (context=0x821182610, resultRelInfo=0x8341e56b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [21:12:01.613] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:12:01.613] relaction = 0x8341e1d60 [21:12:01.613] commandType = CMD_DELETE [21:12:01.613] result = TM_Ok [21:12:01.613] l__state = {l = 0x83a6fc088, i = 0} [21:12:01.613] mtstate = 0x8341e54a0 [21:12:01.613] newslot = 0x0 [21:12:01.613] rslot = 0x0 [21:12:01.613] estate = 0x18da4 [21:12:01.613] mergeActions = [21:12:01.613] econtext = 0x83a6fb128 [21:12:01.613] epqstate = 0x8341e5588 [21:12:01.613] actionStates = 0x83a6fc088 [21:12:01.613] l = [21:12:01.613] isNull = [21:12:01.613] lmerge_matched = [21:12:01.613] __error = [21:12:01.613] l__state = [21:12:01.613] updateCxt = [21:12:01.613] relaction = [21:12:01.613] commandType = [21:12:01.613] result = [21:12:01.613] __error = [21:12:01.613] resultRelationDesc = [21:12:01.613] lockmode = [21:12:01.613] inputslot = [21:12:01.613] epqslot = [21:12:01.613] was_matched = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] #7 ExecMerge (context=0x821182610, resultRelInfo=0x8341e56b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:12:01.613] matched = [21:12:01.613] rslot = 0x0 [21:12:01.613] #8 ExecModifyTable (pstate=0x8341e54a0) at ../src/backend/executor/nodeModifyTable.c:4112 [21:12:01.613] context = {mtstate = 0x8341e54a0, epqstate = 0x8341e5588, estate = 0x8341e5100, planSlot = 0x8341e1cd0, tmfd = {ctid = {ip_blkid = {bi_hi = 9912, bi_lo = 8472}, ip_posid = 8}, xmax = 747662832, cmax = 8, traversed = 128}, cpUpdateReturningSlot = 0x82c84d6de} [21:12:01.613] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [21:12:01.613] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8341f1118} [21:12:01.613] node = 0x8341e54a0 [21:12:01.613] estate = 0x8341e5100 [21:12:01.613] operation = CMD_MERGE [21:12:01.613] resultRelInfo = 0x8341e56b0 [21:12:01.613] subplanstate = 0x8341e6df0 [21:12:01.613] slot = [21:12:01.613] tupleid = 0x0 [21:12:01.613] oldtuple = 0x0 [21:12:01.613] oldSlot = [21:12:01.613] #9 0x0000000000738bfb in ExecProcNodeFirst (node=0x8341e54a0) at ../src/backend/executor/execProcnode.c:464 [21:12:01.613] No locals. [21:12:01.613] #10 0x0000000000730eea in ExecProcNode (node=0x8341e54a0) at ../src/include/executor/executor.h:274 [21:12:01.613] No locals. [21:12:01.613] #11 ExecutePlan (estate=0x8341e5100, planstate=0x8341e54a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x8341b9710, execute_once=false) at ../src/backend/executor/execMain.c:1646 [21:12:01.613] current_tuple_count = [21:12:01.613] slot = [21:12:01.613] #12 standard_ExecutorRun (queryDesc=0x8340e2448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [21:12:01.613] estate = 0x8341e5100 [21:12:01.613] oldcontext = 0x8341b9400 [21:12:01.613] operation = CMD_MERGE [21:12:01.613] dest = 0x8341b9710 [21:12:01.613] sendTuples = true [21:12:01.613] #13 0x0000000837338963 in pgss_ExecutorRun (queryDesc=0x8340e2448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [21:12:01.613] _local_sigjmp_buf = {{_sjb = {35285862706, 12160184, 34914969416, 34914969584, 35233080392, 34914969424, 1, 1, 35234120575, 35233080392, 12168912, 34359738368}}} [21:12:01.613] _save_exception_stack = 0x821182910 [21:12:01.613] _save_context_stack = 0x0 [21:12:01.613] _do_rethrow = false [21:12:01.613] #14 0x0000000000730d98 in ExecutorRun (queryDesc=0x18da4, queryDesc@entry=0x8340e2448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [21:12:01.613] No locals. [21:12:01.613] #15 0x0000000000909b8f in ProcessQuery (plan=0x83a6b2f40, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8211828d8) at ../src/backend/tcop/pquery.c:160 [21:12:01.613] queryDesc = 0x8340e2448 [21:12:01.613] #16 0x000000000090912d in PortalRunMulti (portal=portal@entry=0x8340c4100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x8341b9710, altdest=0xb501f0 , qc=qc@entry=0x8211828d8) at ../src/backend/tcop/pquery.c:1286 [21:12:01.613] pstmt = 0x83a6b2f40 [21:12:01.613] stmtlist_item__state = {l = 0x83a6b77f8, i = 0} [21:12:01.613] active_snapshot_set = true [21:12:01.613] stmtlist_item = 0x83a6b7810 [21:12:01.613] #17 0x0000000000908c1c in FillPortalStore (portal=portal@entry=0x8340c4100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [21:12:01.613] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:12:01.613] treceiver = 0x8341b9710 [21:12:01.613] #18 0x0000000000908970 in PortalRun (portal=portal@entry=0x8340c4100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83a6b7848, altdest=altdest@entry=0x83a6b7848, qc=0x821182a10) at ../src/backend/tcop/pquery.c:763 [21:12:01.613] _local_sigjmp_buf = {{_sjb = {9472271, 35233292184, 34914969864, 34914970096, 34914969872, 12160184, 12127968, 35232956672, 7112098687, 35232964864, 3578651, 34359738368}}} [21:12:01.613] _save_exception_stack = 0x821182ae0 [21:12:01.613] _save_context_stack = 0x0 [21:12:01.613] _do_rethrow = false [21:12:01.613] saveTopTransactionResourceOwner = 0x834115f98 [21:12:01.613] saveTopTransactionContext = 0x834035000 [21:12:01.613] saveActivePortal = 0x0 [21:12:01.613] saveResourceOwner = 0x834115f98 [21:12:01.613] savePortalContext = 0x0 [21:12:01.613] saveMemoryContext = 0x834035000 [21:12:01.613] result = [21:12:01.613] nprocessed = [21:12:01.613] #19 0x000000000090787b in exec_simple_query (query_string=query_string@entry=0x834029100 "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 [21:12:01.613] cmdtaglen = [21:12:01.613] snapshot_set = [21:12:01.613] per_parsetree_context = 0x0 [21:12:01.613] plantree_list = [21:12:01.613] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:12:01.613] parsetree = 0x83a69b928 [21:12:01.613] commandTag = CMDTAG_MERGE [21:12:01.613] cmdtagname = [21:12:01.613] querytree_list = [21:12:01.613] portal = 0x8340c4100 [21:12:01.613] format = 0 [21:12:01.613] receiver = 0x83a6b7848 [21:12:01.613] parsetree_item__state = {l = 0x83a69d1f0, i = 0} [21:12:01.613] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [21:12:01.613] dest = DestRemote [21:12:01.613] was_logged = [21:12:01.613] oldcontext = 0x834035000 [21:12:01.613] parsetree_list = 0x83a69d1f0 [21:12:01.613] use_implicit_block = false [21:12:01.613] parsetree_item = 0x83a69d208 [21:12:01.613] save_log_statement_stats = [21:12:01.613] #20 0x0000000000905654 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [21:12:01.613] query_string = 0x834029100 "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"... [21:12:01.613] input_message = {data = 0x834029100 "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} [21:12:01.613] firstchar = [21:12:01.613] local_sigjmp_buf = {{_sjb = {9456416, 34914970336, 34914970296, 34914970896, 12168920, 12115392, 8192, 8388608, 72057628952888191, 0, 0, 1}}} [21:12:01.613] send_ready_for_query = false [21:12:01.613] idle_in_transaction_timeout_enabled = false [21:12:01.613] idle_session_timeout_enabled = false [21:12:01.613] #21 0x0000000000900129 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:12:01.613] bsdata = [21:12:01.613] #22 0x000000000085a002 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821183820 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821183768) at ../src/backend/postmaster/launch_backend.c:265 [21:12:01.613] pid = [21:12:01.613] #23 0x000000000085e961 in BackendStartup (client_sock=0x821183768) at ../src/backend/postmaster/postmaster.c:3593 [21:12:01.613] startup_data = {canAcceptConnections = CAC_OK} [21:12:01.613] bn = 0x8340352b8 [21:12:01.613] pid = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] save_errno = [21:12:01.613] __error = [21:12:01.613] __error = [21:12:01.613] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:12:01.613] 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' , "\3007\030!\b\000\000\000\330E\272*\b\000\000\000\v\000\000\000\000\000\000\000\016ƺ*\b", '\000' , "8\030!\b\000\000\000ԝ\205\000\000\000\000\000\0208\030!\b", '\000' }, salen = 16}} [21:12:01.613] i = 0 [21:12:01.613] now = [21:12:01.613] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 555233088, events = 8, fd = 568669192, user_data = 0x21}, {pos = 555233072, events = 8, fd = -2117485932, user_data = 0x821e4c008}, {pos = 568640520, events = 8, fd = 568641544, user_data = 0x821e4cc08}, {pos = 568655880, events = 8, fd = 568656904, user_data = 0x821e50808}, {pos = 568658952, events = 8, fd = 568659976, user_data = 0x821e51408}, {pos = 568662024, events = 8, fd = 568663048, user_data = 0x821e52008}, {pos = 568665096, events = 8, fd = 568666120, user_data = 0x821e52c08}, {pos = 568668168, events = 8, fd = 568669192, user_data = 0x821e58088}, {pos = 555233464, events = 8, fd = 555232976, user_data = 0x52e81ca1da3}, {pos = 568669192, events = 8, fd = 2571482, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 568692792, user_data = 0x1}, {pos = 568669192, events = 8, fd = 745682088, user_data = 0x8211831b8}, {pos = 568669192, events = 8, fd = 555232944, user_data = 0x273c24}, {pos = 555233536, events = 8, fd = 745789796, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 568695352, user_data = 0x52e00000001}, {pos = 568669192, events = 8, fd = 745703640, user_data = 0x821182ff8}, {pos = 555232672, events = 8, fd = 33, user_data = 0x82c739c64}, {pos = 568669192, events = 8, fd = 568695352, user_data = 0x0}, {pos = 2625, events = 0, fd = 555233248, user_data = 0x52e81c9b645}, {pos = 745789796, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 568695352, events = 8, fd = 1, user_data = 0x821e53408}, {pos = 872517632, events = 8, fd = 1, user_data = 0x834019194}, {pos = 0, events = 0, fd = 555233200, user_data = 0x82ababc0c}, {pos = 1, events = 0, fd = 872517632, user_data = 0x821182fe0}, {pos = 716877492, events = 8, fd = 747516256, user_data = 0x82c8e3160 }, {pos = 745885888, events = 8, fd = 568669192, user_data = 0x8211830c0}, {pos = -2117487572, events = 1326, fd = 80627796, user_data = 0x1}, {pos = -2117487954, events = 1326, fd = 12240, user_data = 0x821182fe8}, {pos = 555233472, events = 8, fd = 873314280, user_data = 0x821183630}, {pos = -2117407088, events = 1326, fd = 568669192, user_data = 0x82118037f}, {pos = 747173042, events = 8, fd = 555233776, user_data = 0x52e00000000}, {pos = 568669192, events = 8, fd = 12240, user_data = 0x82c719000}, {pos = 1964368, events = 0, fd = 747516256, user_data = 0x82c739c64}, {pos = 15616, events = 0, fd = 555234656, user_data = 0x821183130}, {pos = 746447246, events = 8, fd = 747554872, user_data = 0x8211830f4}, {pos = 872969690, events = 8, fd = 555234656, user_data = 0x821183130}, {pos = 746538501, events = 8, fd = 555233522, user_data = 0x821183560}, {pos = 555234656, events = 8, fd = 0, user_data = 0x70d064c7ee27b3d}, {pos = 555234656, events = 8, fd = 872969688, user_data = 0x821183630}, {pos = 747554872, events = 8, fd = 0, user_data = 0x8211835a0}, {pos = 746538765, events = 8, fd = 0, user_data = 0x0}, {pos = 555235024, events = 8, fd = 872969688, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2117458935, user_data = 0x821183278}, {pos = 745774180, events = 8, fd = 2503, user_data = 0x52e81ca2409}, {pos = 555233944, events = 8, fd = 745774180, user_data = 0xac6}, {pos = 745746720, events = 8, fd = 555233816, user_data = 0x821e53408}, {pos = 555233944, events = 8, fd = 745746720, user_data = 0x821183280}, {pos = -2117479323, events = 1326, fd = 0, user_data = 0x800000000}, {pos = 555233904, events = 8, fd = 745706832, user_data = 0x0}, {pos = 0, events = 0, fd = 555233872, user_data = 0x52e81ca2409}, {pos = 555234088, events = 8, fd = 745774180, user_data = 0xb6c}, {pos = 745747384, events = 8, fd = 555233960, user_data = 0x821e53408}, {pos = 555234088, events = 8, fd = 745747384, user_data = 0x821183310}, {pos = -2117479323, events = 1326, fd = 568692792, user_data = 0x28d226}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 568669192, user_data = 0x82c729550}, {pos = 555234808, events = 8, fd = 568669192, user_data = 0x211834d8}, {pos = 31, events = 0, fd = 0, user_data = 0x8211833b8}, {pos = 568690568, events = 8, fd = 555234696, user_data = 0x8211833a0}, {pos = -2117460573, events = 1326, fd = 568692792, user_data = 0x292eae}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821e59038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [21:12:01.613] last_touch_time = 1713128970 [21:12:01.613] last_lockfile_recheck_time = 1713128970 [21:12:01.613] nevents = 1 [21:12:01.613] #25 0x000000000085c236 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821183d60) at ../src/backend/postmaster/postmaster.c:1372 [21:12:01.613] userDoption = [21:12:01.613] listen_addr_saved = false [21:12:01.613] output_config_variable = [21:12:01.613] opt = [21:12:01.613] status = [21:12:01.613] #26 0x0000000000794165 in main (argc=4, argv=0x821183d60) at ../src/backend/main/main.c:197 [21:12:01.613] do_check_root =