[08:39:05.337] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [08:39:05.718] dumping /tmp/cores/postgres.8333.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:39:05.858] [New LWP 101794] [08:39:05.952] Core was generated by `postgres: postgres regression [local] MERGE'. [08:39:05.952] Program terminated with signal SIGABRT, Aborted. [08:39:05.952] Sent by thr_kill() from pid 8333 and user 1003. [08:39:05.952] #0 0x000000082be65dca in thr_kill () from /lib/libc.so.7 [08:39:06.605] [08:39:06.605] Thread 1 (LWP 101794): [08:39:06.605] #0 0x000000082be65dca in thr_kill () from /lib/libc.so.7 [08:39:06.605] No symbol table info available. [08:39:06.605] #1 0x000000082bdde6f4 in raise () from /lib/libc.so.7 [08:39:06.605] No symbol table info available. [08:39:06.605] #2 0x000000082be8fbc9 in abort () from /lib/libc.so.7 [08:39:06.605] No symbol table info available. [08:39:06.605] #3 0x0000000000a5d217 in ExceptionalCondition (conditionName=, fileName=0x372e24 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [08:39:06.605] No locals. [08:39:06.605] #4 0x000000000073f910 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821b4c310, materialize=, shouldFree=shouldFree@entry=0x821b4c2b6) at ../src/backend/executor/execTuples.c:1737 [08:39:06.605] No locals. [08:39:06.605] #5 0x0000000000705af8 in ExecIRDeleteTriggers (estate=estate@entry=0x835256100, relinfo=relinfo@entry=0x8352566b0, slot=slot@entry=0x821b4c310) at ../src/backend/commands/trigger.c:2841 [08:39:06.605] trigger = [08:39:06.605] oldtuple = [08:39:06.605] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8424bf5d0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [08:39:06.605] trigdesc = 0x8352568c0 [08:39:06.605] newtuple = 0x0 [08:39:06.605] i = 0 [08:39:06.605] should_free = false [08:39:06.605] #6 0x0000000000764a0a in ExecMergeMatched (context=0x821b4c3d0, resultRelInfo=0x8352566b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [08:39:06.605] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [08:39:06.605] relaction = 0x84257c820 [08:39:06.605] commandType = CMD_DELETE [08:39:06.605] result = TM_Ok [08:39:06.605] l__state = {l = 0x8425f0488, i = 0} [08:39:06.605] mtstate = 0x8352564a0 [08:39:06.605] newslot = 0x0 [08:39:06.605] rslot = 0x0 [08:39:06.605] estate = 0x18da2 [08:39:06.605] mergeActions = [08:39:06.605] econtext = 0x8425ef528 [08:39:06.605] epqstate = 0x835256588 [08:39:06.605] actionStates = 0x8425f0488 [08:39:06.605] l = [08:39:06.605] isNull = [08:39:06.605] lmerge_matched = [08:39:06.605] __error = [08:39:06.605] l__state = [08:39:06.605] updateCxt = [08:39:06.605] relaction = [08:39:06.605] commandType = [08:39:06.605] result = [08:39:06.605] __error = [08:39:06.605] resultRelationDesc = [08:39:06.605] lockmode = [08:39:06.605] inputslot = [08:39:06.605] epqslot = [08:39:06.605] was_matched = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] #7 ExecMerge (context=0x821b4c3d0, resultRelInfo=0x8352566b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [08:39:06.605] matched = [08:39:06.605] rslot = 0x0 [08:39:06.605] #8 ExecModifyTable (pstate=0x8352564a0) at ../src/backend/executor/nodeModifyTable.c:4112 [08:39:06.605] context = {mtstate = 0x8352564a0, epqstate = 0x835256588, estate = 0x835256100, planSlot = 0x84257c790, tmfd = {ctid = {ip_blkid = {bi_hi = 62656, bi_lo = 16993}, ip_posid = 8}, xmax = 891643568, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x835256100} [08:39:06.605] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [08:39:06.605] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x83526a118} [08:39:06.605] node = 0x8352564a0 [08:39:06.605] estate = 0x835256100 [08:39:06.605] operation = CMD_MERGE [08:39:06.605] resultRelInfo = 0x8352566b0 [08:39:06.605] subplanstate = 0x835257df0 [08:39:06.605] slot = [08:39:06.605] tupleid = 0x0 [08:39:06.605] oldtuple = 0x0 [08:39:06.605] oldSlot = [08:39:06.605] #9 0x00000000007399ab in ExecProcNodeFirst (node=0x8352564a0) at ../src/backend/executor/execProcnode.c:464 [08:39:06.605] No locals. [08:39:06.605] #10 0x0000000000731c9a in ExecProcNode (node=0x8352564a0) at ../src/include/executor/executor.h:274 [08:39:06.605] No locals. [08:39:06.605] #11 ExecutePlan (estate=0x835256100, planstate=0x8352564a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x835191310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [08:39:06.605] current_tuple_count = [08:39:06.605] slot = [08:39:06.605] #12 standard_ExecutorRun (queryDesc=0x835137448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [08:39:06.605] estate = 0x835256100 [08:39:06.605] oldcontext = 0x835191000 [08:39:06.605] operation = CMD_MERGE [08:39:06.605] dest = 0x835191310 [08:39:06.605] sendTuples = true [08:39:06.605] #13 0x0000000000731b4f in ExecutorRun (queryDesc=0x18da2, queryDesc@entry=0x835137448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [08:39:06.605] No locals. [08:39:06.605] #14 0x000000000090ab2f in ProcessQuery (plan=0x84261c9a0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821b4c5e8) at ../src/backend/tcop/pquery.c:160 [08:39:06.605] queryDesc = 0x835137448 [08:39:06.605] #15 0x000000000090a0cd in PortalRunMulti (portal=portal@entry=0x83516a100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x835191310, altdest=0xb512f0 , qc=qc@entry=0x821b4c5e8) at ../src/backend/tcop/pquery.c:1286 [08:39:06.605] pstmt = 0x84261c9a0 [08:39:06.605] stmtlist_item__state = {l = 0x842621258, i = 0} [08:39:06.605] active_snapshot_set = true [08:39:06.605] stmtlist_item = 0x842621270 [08:39:06.605] #16 0x0000000000909bbc in FillPortalStore (portal=portal@entry=0x83516a100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:39:06.605] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:39:06.605] treceiver = 0x835191310 [08:39:06.605] #17 0x0000000000909910 in PortalRun (portal=portal@entry=0x83516a100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8426212a8, altdest=altdest@entry=0x8426212a8, qc=0x821b4c720) at ../src/backend/tcop/pquery.c:763 [08:39:06.605] _local_sigjmp_buf = {{_sjb = {9476271, 35250487320, 34925233688, 34925233920, 34925233696, 12164520, 12132304, 35250413824, 7112098687, 35250422016, 3579028, 34359738368}}} [08:39:06.605] _save_exception_stack = 0x821b4c7f0 [08:39:06.605] _save_context_stack = 0x0 [08:39:06.605] _do_rethrow = false [08:39:06.605] saveTopTransactionResourceOwner = 0x83517c018 [08:39:06.605] saveTopTransactionContext = 0x8350a0000 [08:39:06.605] saveActivePortal = 0x0 [08:39:06.605] saveResourceOwner = 0x83517c018 [08:39:06.605] savePortalContext = 0x0 [08:39:06.605] saveMemoryContext = 0x8350a0000 [08:39:06.605] result = [08:39:06.605] nprocessed = [08:39:06.605] #18 0x000000000090881b in exec_simple_query (query_string=query_string@entry=0x835094100 "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 [08:39:06.605] cmdtaglen = [08:39:06.605] snapshot_set = [08:39:06.605] per_parsetree_context = 0x0 [08:39:06.605] plantree_list = [08:39:06.605] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:39:06.605] parsetree = 0x8425bd968 [08:39:06.605] commandTag = CMDTAG_MERGE [08:39:06.605] cmdtagname = [08:39:06.605] querytree_list = [08:39:06.605] portal = 0x83516a100 [08:39:06.605] format = 0 [08:39:06.605] receiver = 0x8426212a8 [08:39:06.605] parsetree_item__state = {l = 0x8425bf230, i = 0} [08:39:06.605] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [08:39:06.605] dest = DestRemote [08:39:06.605] was_logged = [08:39:06.605] oldcontext = 0x8350a0000 [08:39:06.605] parsetree_list = 0x8425bf230 [08:39:06.605] use_implicit_block = false [08:39:06.605] parsetree_item = 0x8425bf248 [08:39:06.605] save_log_statement_stats = [08:39:06.605] #19 0x00000000009065f4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [08:39:06.605] query_string = 0x835094100 "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"... [08:39:06.605] input_message = {data = 0x835094100 "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} [08:39:06.605] firstchar = [08:39:06.605] local_sigjmp_buf = {{_sjb = {9460416, 34925234160, 34925234120, 34925234720, 12173256, 12119728, 8192, 8388608, 72057628963111807, 0, 0, 34359738369}}} [08:39:06.605] send_ready_for_query = false [08:39:06.605] idle_in_transaction_timeout_enabled = false [08:39:06.605] idle_session_timeout_enabled = false [08:39:06.605] #20 0x00000000009010c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [08:39:06.605] bsdata = [08:39:06.605] #21 0x000000000085b022 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821b4d530 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821b4d478) at ../src/backend/postmaster/launch_backend.c:265 [08:39:06.605] pid = [08:39:06.605] #22 0x000000000085f981 in BackendStartup (client_sock=0x821b4d478) at ../src/backend/postmaster/postmaster.c:3593 [08:39:06.605] startup_data = {canAcceptConnections = CAC_OK} [08:39:06.605] bn = 0x8350a00d8 [08:39:06.605] pid = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] save_errno = [08:39:06.605] __error = [08:39:06.605] __error = [08:39:06.605] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [08:39:06.605] 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' , "\320Դ!\b\000\000\000\330\005U+\b\000\000\000\v\000\000\000\000\000\000\000\016\206U+\b", '\000' , "\020մ!\b\000\000\000\364\255\205\000\000\000\000\000 մ!\b", '\000' }, salen = 16}} [08:39:06.605] i = 0 [08:39:06.605] now = [08:39:06.605] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 565496512, user_data = 0x0}, {pos = 575841288, events = 8, fd = 32, user_data = 0x821b4cc40}, {pos = 690735764, events = 5541, fd = 575811592, user_data = 0x822523408}, {pos = 575813640, events = 8, fd = 575814664, user_data = 0x822527008}, {pos = 575829000, events = 8, fd = 575830024, user_data = 0x822527c08}, {pos = 575832072, events = 8, fd = 575833096, user_data = 0x822528808}, {pos = 575835144, events = 8, fd = 575836168, user_data = 0x822529408}, {pos = 575838216, events = 8, fd = 575839240, user_data = 0x82252a008}, {pos = 575841288, events = 8, fd = -1, user_data = 0x82bf262e0}, {pos = 565496752, events = 8, fd = 736965033, user_data = 0x0}, {pos = 4096, events = 0, fd = -2109068702, user_data = 0x82bf267e8}, {pos = 882940896, events = 8, fd = 160, user_data = 0x0}, {pos = 865456272, events = 8, fd = 565496960, user_data = 0x82beb192c}, {pos = 4096, events = 0, fd = 735390052, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 575867448, user_data = 0x800000001}, {pos = 575841288, events = 8, fd = 735303896, user_data = 0x821b4cd08}, {pos = 565496512, events = 8, fd = 32, user_data = 0x82bd4ec64}, {pos = 575841288, events = 8, fd = 575867448, user_data = 0x0}, {pos = 2625, events = 0, fd = 565497072, user_data = 0x15a5292bc645}, {pos = 735390052, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 575867448, events = 8, fd = 1, user_data = 0x82252a408}, {pos = 889733120, events = 8, fd = 1, user_data = 0x835084194}, {pos = 0, events = 0, fd = 565497024, user_data = 0x82b557c0c}, {pos = 1, events = 0, fd = 889733120, user_data = 0x821b4ccf0}, {pos = 727019188, events = 8, fd = 737116512, user_data = 0x82bef8160 }, {pos = 735486144, events = 8, fd = 575841288, user_data = 0x821b4cdd0}, {pos = 690734124, events = 5541, fd = 865456272, user_data = 0x800000001}, {pos = 690733742, events = 5541, fd = 12240, user_data = 0x821b4ccf8}, {pos = 565497296, events = 8, fd = 890439656, user_data = 0x821b4d340}, {pos = 690814608, events = 5541, fd = 575841288, user_data = 0x821b4037f}, {pos = 736773532, events = 8, fd = 575811592, user_data = 0x0}, {pos = 575841288, events = 8, fd = 12240, user_data = 0x82bd2e000}, {pos = 1964368, events = 0, fd = 737116512, user_data = 0x82bd4ec64}, {pos = 15616, events = 0, fd = 565498480, user_data = 0x821b4ce40}, {pos = 736047502, events = 8, fd = 737155128, user_data = 0x821b4ce04}, {pos = 890176986, events = 8, fd = 565498480, user_data = 0x821b4ce40}, {pos = 736138757, events = 8, fd = 565497346, user_data = 0x821b4d270}, {pos = 565498480, events = 8, fd = 0, user_data = 0x7a863e17824a2a62}, {pos = 565498480, events = 8, fd = 890176984, user_data = 0x821b4d340}, {pos = 737155128, events = 8, fd = 0, user_data = 0x821b4d2b0}, {pos = 736139021, events = 8, fd = 0, user_data = 0x0}, {pos = 565498848, events = 8, fd = 890176984, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 690762761, events = 5541, fd = 565497752, user_data = 0x82bd4ec64}, {pos = 2503, events = 0, fd = 690762761, user_data = 0x821b4cfb8}, {pos = 735374436, events = 8, fd = 2758, user_data = 0x82bd48120}, {pos = 565497656, events = 8, fd = 575841288, user_data = 0x821b4cfb8}, {pos = 735346976, events = 8, fd = 565497760, user_data = 0x15a5292be465}, {pos = 0, events = 0, fd = 0, user_data = 0x82bf1a0f0}, {pos = 735307088, events = 8, fd = 0, user_data = 0x0}, {pos = 737184176, events = 8, fd = 690762761, user_data = 0x821b4d048}, {pos = 735374436, events = 8, fd = 2924, user_data = 0x82bd483b8}, {pos = 565497800, events = 8, fd = 575841288, user_data = 0x821b4d048}, {pos = 735347640, events = 8, fd = 565497904, user_data = 0x15a5292be465}, {pos = 575864888, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 575841288, events = 8, fd = 735307088, user_data = 0x821b4d308}, {pos = 575841288, events = 8, fd = 565498344, user_data = 0x1e}, {pos = 735311072, events = 8, fd = 565498072, user_data = 0x82252f288}, {pos = 565498520, events = 8, fd = 565498048, user_data = 0x15a5292c2da3}, {pos = 575864888, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 575864888, user_data = 0x1}} [08:39:06.605] last_touch_time = 1713429374 [08:39:06.605] last_lockfile_recheck_time = 1713429374 [08:39:06.605] nevents = 1 [08:39:06.605] #24 0x000000000085d256 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821b4da70) at ../src/backend/postmaster/postmaster.c:1372 [08:39:06.605] userDoption = [08:39:06.605] listen_addr_saved = false [08:39:06.605] output_config_variable = [08:39:06.605] opt = [08:39:06.605] status = [08:39:06.605] #25 0x0000000000794f15 in main (argc=8, argv=0x821b4da70) at ../src/backend/main/main.c:197 [08:39:06.605] do_check_root = [08:39:06.618] [08:39:06.618] [08:39:06.618] [08:39:06.687] dumping /tmp/cores/postgres.9140.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:39:06.814] [New LWP 100111] [08:39:06.886] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [08:39:06.886] Program terminated with signal SIGABRT, Aborted. [08:39:06.886] Sent by thr_kill() from pid 9140 and user 1003. [08:39:06.886] #0 0x000000082b3cadca in thr_kill () from /lib/libc.so.7 [08:39:07.534] [08:39:07.534] Thread 1 (LWP 100111): [08:39:07.534] #0 0x000000082b3cadca in thr_kill () from /lib/libc.so.7 [08:39:07.534] No symbol table info available. [08:39:07.534] #1 0x000000082b3436f4 in raise () from /lib/libc.so.7 [08:39:07.534] No symbol table info available. [08:39:07.534] #2 0x000000082b3f4bc9 in abort () from /lib/libc.so.7 [08:39:07.534] No symbol table info available. [08:39:07.534] #3 0x0000000000a5d217 in ExceptionalCondition (conditionName=, fileName=0x372e24 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [08:39:07.534] No locals. [08:39:07.534] #4 0x000000000073f910 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820c98930, materialize=, shouldFree=shouldFree@entry=0x820c988d6) at ../src/backend/executor/execTuples.c:1737 [08:39:07.534] No locals. [08:39:07.534] #5 0x0000000000705af8 in ExecIRDeleteTriggers (estate=estate@entry=0x836a92100, relinfo=relinfo@entry=0x836a926b0, slot=slot@entry=0x820c98930) at ../src/backend/commands/trigger.c:2841 [08:39:07.534] trigger = [08:39:07.534] oldtuple = [08:39:07.534] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84665c600, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [08:39:07.534] trigdesc = 0x836a928c0 [08:39:07.534] newtuple = 0x0 [08:39:07.534] i = 0 [08:39:07.534] should_free = false [08:39:07.534] #6 0x0000000000764a0a in ExecMergeMatched (context=0x820c989f0, resultRelInfo=0x836a926b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [08:39:07.534] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [08:39:07.534] relaction = 0x8466f1460 [08:39:07.534] commandType = CMD_DELETE [08:39:07.534] result = TM_Ok [08:39:07.534] l__state = {l = 0x84676d608, i = 0} [08:39:07.534] mtstate = 0x836a924a0 [08:39:07.534] newslot = 0x0 [08:39:07.534] rslot = 0x0 [08:39:07.534] estate = 0x1870f [08:39:07.534] mergeActions = [08:39:07.534] econtext = 0x84676c6a8 [08:39:07.534] epqstate = 0x836a92588 [08:39:07.534] actionStates = 0x84676d608 [08:39:07.534] l = [08:39:07.534] isNull = [08:39:07.534] lmerge_matched = [08:39:07.534] __error = [08:39:07.534] l__state = [08:39:07.534] updateCxt = [08:39:07.534] relaction = [08:39:07.534] commandType = [08:39:07.534] result = [08:39:07.534] __error = [08:39:07.534] resultRelationDesc = [08:39:07.534] lockmode = [08:39:07.534] inputslot = [08:39:07.534] epqslot = [08:39:07.534] was_matched = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] #7 ExecMerge (context=0x820c989f0, resultRelInfo=0x836a926b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [08:39:07.534] matched = [08:39:07.534] rslot = 0x0 [08:39:07.534] #8 ExecModifyTable (pstate=0x836a924a0) at ../src/backend/executor/nodeModifyTable.c:4112 [08:39:07.534] context = {mtstate = 0x836a924a0, epqstate = 0x836a92588, estate = 0x836a92100, planSlot = 0x8466f13d0, tmfd = {ctid = {ip_blkid = {bi_hi = 51264, bi_lo = 18041}, ip_posid = 8}, xmax = 917055152, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x836a92100} [08:39:07.534] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [08:39:07.534] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x836aa6118} [08:39:07.534] node = 0x836a924a0 [08:39:07.534] estate = 0x836a92100 [08:39:07.534] operation = CMD_MERGE [08:39:07.534] resultRelInfo = 0x836a926b0 [08:39:07.534] subplanstate = 0x836a93df0 [08:39:07.534] slot = [08:39:07.534] tupleid = 0x0 [08:39:07.534] oldtuple = 0x0 [08:39:07.534] oldSlot = [08:39:07.534] #9 0x00000000007399ab in ExecProcNodeFirst (node=0x836a924a0) at ../src/backend/executor/execProcnode.c:464 [08:39:07.534] No locals. [08:39:07.534] #10 0x0000000000731c9a in ExecProcNode (node=0x836a924a0) at ../src/include/executor/executor.h:274 [08:39:07.534] No locals. [08:39:07.534] #11 ExecutePlan (estate=0x836a92100, planstate=0x836a924a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836900b10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [08:39:07.534] current_tuple_count = [08:39:07.534] slot = [08:39:07.534] #12 standard_ExecutorRun (queryDesc=0x8369ab448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [08:39:07.534] estate = 0x836a92100 [08:39:07.534] oldcontext = 0x836900800 [08:39:07.534] operation = CMD_MERGE [08:39:07.534] dest = 0x836900b10 [08:39:07.534] sendTuples = true [08:39:07.534] #13 0x0000000000731b4f in ExecutorRun (queryDesc=0x1870f, queryDesc@entry=0x8369ab448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [08:39:07.534] No locals. [08:39:07.534] #14 0x000000000090ab2f in ProcessQuery (plan=0x846799d20, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820c98c08) at ../src/backend/tcop/pquery.c:160 [08:39:07.534] queryDesc = 0x8369ab448 [08:39:07.534] #15 0x000000000090a0cd in PortalRunMulti (portal=portal@entry=0x83698b100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836900b10, altdest=0xb512f0 , qc=qc@entry=0x820c98c08) at ../src/backend/tcop/pquery.c:1286 [08:39:07.534] pstmt = 0x846799d20 [08:39:07.534] stmtlist_item__state = {l = 0x84679e5d8, i = 0} [08:39:07.534] active_snapshot_set = true [08:39:07.534] stmtlist_item = 0x84679e5f0 [08:39:07.534] #16 0x0000000000909bbc in FillPortalStore (portal=portal@entry=0x83698b100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:39:07.534] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:39:07.534] treceiver = 0x836900b10 [08:39:07.534] #17 0x0000000000909910 in PortalRun (portal=portal@entry=0x83698b100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x84679e628, altdest=altdest@entry=0x84679e628, qc=0x820c98d40) at ../src/backend/tcop/pquery.c:763 [08:39:07.534] _local_sigjmp_buf = {{_sjb = {9476271, 35276054616, 34909817912, 34909818144, 34909817920, 12164520, 12132304, 35275714816, 7112098687, 35275723008, 3579028, 34359738368}}} [08:39:07.534] _save_exception_stack = 0x820c98e10 [08:39:07.534] _save_context_stack = 0x0 [08:39:07.534] _do_rethrow = false [08:39:07.534] saveTopTransactionResourceOwner = 0x8369de058 [08:39:07.534] saveTopTransactionContext = 0x8368fe000 [08:39:07.534] saveActivePortal = 0x0 [08:39:07.534] saveResourceOwner = 0x8369de058 [08:39:07.534] savePortalContext = 0x0 [08:39:07.534] saveMemoryContext = 0x8368fe000 [08:39:07.534] result = [08:39:07.534] nprocessed = [08:39:07.534] #18 0x000000000090881b in exec_simple_query (query_string=query_string@entry=0x8368f2100 "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 [08:39:07.534] cmdtaglen = [08:39:07.534] snapshot_set = [08:39:07.534] per_parsetree_context = 0x0 [08:39:07.534] plantree_list = [08:39:07.534] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:39:07.534] parsetree = 0x84673a468 [08:39:07.534] commandTag = CMDTAG_MERGE [08:39:07.534] cmdtagname = [08:39:07.534] querytree_list = [08:39:07.534] portal = 0x83698b100 [08:39:07.534] format = 0 [08:39:07.534] receiver = 0x84679e628 [08:39:07.534] parsetree_item__state = {l = 0x84673bd30, i = 0} [08:39:07.534] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [08:39:07.534] dest = DestRemote [08:39:07.534] was_logged = [08:39:07.534] oldcontext = 0x8368fe000 [08:39:07.534] parsetree_list = 0x84673bd30 [08:39:07.534] use_implicit_block = false [08:39:07.534] parsetree_item = 0x84673bd48 [08:39:07.534] save_log_statement_stats = [08:39:07.534] #19 0x00000000009065f4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [08:39:07.534] query_string = 0x8368f2100 "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"... [08:39:07.534] input_message = {data = 0x8368f2100 "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} [08:39:07.534] firstchar = [08:39:07.534] local_sigjmp_buf = {{_sjb = {9460416, 34909818384, 34909818344, 34909818944, 12173256, 12119728, 8192, 8388608, 72057628947710847, 0, 0, 34359738369}}} [08:39:07.534] send_ready_for_query = false [08:39:07.534] idle_in_transaction_timeout_enabled = false [08:39:07.534] idle_session_timeout_enabled = false [08:39:07.534] #20 0x00000000009010c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [08:39:07.534] bsdata = [08:39:07.534] #21 0x000000000085b022 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820c99b50 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820c99a98) at ../src/backend/postmaster/launch_backend.c:265 [08:39:07.534] pid = [08:39:07.534] #22 0x000000000085f981 in BackendStartup (client_sock=0x820c99a98) at ../src/backend/postmaster/postmaster.c:3593 [08:39:07.534] startup_data = {canAcceptConnections = CAC_OK} [08:39:07.534] bn = 0x8368fe538 [08:39:07.534] pid = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] save_errno = [08:39:07.534] __error = [08:39:07.534] __error = [08:39:07.534] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [08:39:07.534] 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' , "\360\232\311 \b\000\000\000\330U\231*\b\000\000\000\v\000\000\000\000\000\000\000\016֙*\b", '\000' , "0\233\311 \b\000\000\000\364\255\205\000\000\000\000\000@\233\311 \b", '\000' }, salen = 16}} [08:39:07.534] i = 0 [08:39:07.534] now = [08:39:07.534] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 724253796, events = 8, fd = 550080736, user_data = 0x820c99270}, {pos = 566019080, events = 8, fd = 32, user_data = 0x820c99260}, {pos = -1088341356, events = 6970, fd = 565989384, user_data = 0x821bc5408}, {pos = 565991432, events = 8, fd = 565992456, user_data = 0x821bc9008}, {pos = 566006792, events = 8, fd = 566007816, user_data = 0x821bc9c08}, {pos = 566009864, events = 8, fd = 566010888, user_data = 0x821bca808}, {pos = 566012936, events = 8, fd = 566013960, user_data = 0x821bcb408}, {pos = 566016008, events = 8, fd = 566017032, user_data = 0x821bcc008}, {pos = 566019080, events = 8, fd = 566038728, user_data = 0x820c993e8}, {pos = 550081040, events = 8, fd = -1088315997, user_data = 0x0}, {pos = 2571326, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 566042680, events = 8, fd = 1, user_data = 0x821bcc408}, {pos = 724161704, events = 8, fd = 550081768, user_data = 0x821bcc408}, {pos = 550081024, events = 0, fd = 724269412, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 566045240, user_data = 0x1}, {pos = 566019080, events = 8, fd = 724183256, user_data = 0x820c99328}, {pos = 550080736, events = 8, fd = 32, user_data = 0x82b2b3c64}, {pos = 566019080, events = 8, fd = 566045240, user_data = 0x0}, {pos = 2625, events = 0, fd = 550081296, user_data = 0x1b3abf213645}, {pos = 724269412, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 566045240, events = 8, fd = 1, user_data = 0x821bcc408}, {pos = 915283968, events = 8, fd = 1, user_data = 0x8368e2194}, {pos = 0, events = 0, fd = 550081248, user_data = 0x82a99cc0c}, {pos = 1, events = 0, fd = 915283968, user_data = 0x820c99310}, {pos = 714718900, events = 8, fd = 725995872, user_data = 0x82b45d160 }, {pos = 724365504, events = 8, fd = 566019080, user_data = 0x820c993f0}, {pos = -1088342996, events = 6970, fd = 566018056, user_data = 0x800000001}, {pos = -1088343378, events = 6970, fd = 12240, user_data = 0x820c99318}, {pos = 550081520, events = 8, fd = 916080616, user_data = 0x820c99960}, {pos = -1088262512, events = 6970, fd = 566019080, user_data = 0x820c9037f}, {pos = 725652658, events = 8, fd = 565989384, user_data = 0x0}, {pos = 566019080, events = 8, fd = 12240, user_data = 0x82b293000}, {pos = 1964368, events = 0, fd = 725995872, user_data = 0x82b2b3c64}, {pos = 15616, events = 0, fd = 550082704, user_data = 0x820c99460}, {pos = 724926862, events = 8, fd = 726034488, user_data = 0x820c99424}, {pos = 915736026, events = 8, fd = 550082704, user_data = 0x820c99460}, {pos = 725018117, events = 8, fd = 550081570, user_data = 0x820c99890}, {pos = 550082704, events = 8, fd = 0, user_data = 0x9165944ff161d2ce}, {pos = 550082704, events = 8, fd = 915736024, user_data = 0x820c99960}, {pos = 726034488, events = 8, fd = 0, user_data = 0x820c998d0}, {pos = 725018381, events = 8, fd = 0, user_data = 0x0}, {pos = 550083072, events = 8, fd = 915736024, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1088314359, events = 6970, fd = 550081976, user_data = 0x82b2b3c64}, {pos = 2503, events = 0, fd = -1088314359, user_data = 0x820c995d8}, {pos = 724253796, events = 8, fd = 2758, user_data = 0x82b2ad120}, {pos = 550081880, events = 8, fd = 566019080, user_data = 0x820c995d8}, {pos = 724226336, events = 8, fd = 550081984, user_data = 0x1b3abf215465}, {pos = 0, events = 0, fd = 0, user_data = 0x82b47f0f0}, {pos = 724186448, events = 8, fd = 0, user_data = 0x0}, {pos = 726063536, events = 8, fd = -1088314359, user_data = 0x820c99668}, {pos = 724253796, events = 8, fd = 2924, user_data = 0x82b2ad3b8}, {pos = 550082024, events = 8, fd = 566019080, user_data = 0x820c99668}, {pos = 724227000, events = 8, fd = 550082128, user_data = 0x1b3abf215465}, {pos = 566042680, events = 8, fd = 2675014, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 566019080, events = 8, fd = 724186448, user_data = 0x820c99928}, {pos = 566019080, events = 8, fd = 550082568, user_data = 0x1e}, {pos = 724190432, events = 8, fd = 550082296, user_data = 0x821bd1288}, {pos = 550082744, events = 8, fd = 550082272, user_data = 0x1b3abf219da3}, {pos = 566042680, events = 8, fd = 2698702, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 566042680, user_data = 0x1}} [08:39:07.534] last_touch_time = 1713429376 [08:39:07.534] last_lockfile_recheck_time = 1713429376 [08:39:07.534] nevents = 1 [08:39:07.534] #24 0x000000000085d256 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820c9a098) at ../src/backend/postmaster/postmaster.c:1372 [08:39:07.534] userDoption = [08:39:07.534] listen_addr_saved = false [08:39:07.534] output_config_variable = [08:39:07.534] opt = [08:39:07.534] status = [08:39:07.534] #25 0x0000000000794f15 in main (argc=4, argv=0x820c9a098) at ../src/backend/main/main.c:197 [08:39:07.534] do_check_root = [08:39:07.544] [08:39:07.544] [08:39:07.544] [08:39:07.608] dumping /tmp/cores/postgres.14276.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:39:07.735] [New LWP 101713] [08:39:07.805] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [08:39:07.805] Program terminated with signal SIGABRT, Aborted. [08:39:07.805] Sent by thr_kill() from pid 14276 and user 1003. [08:39:07.805] #0 0x000000082c3cbdca in thr_kill () from /lib/libc.so.7 [08:39:08.430] [08:39:08.430] Thread 1 (LWP 101713): [08:39:08.430] #0 0x000000082c3cbdca in thr_kill () from /lib/libc.so.7 [08:39:08.430] No symbol table info available. [08:39:08.430] #1 0x000000082c3446f4 in raise () from /lib/libc.so.7 [08:39:08.430] No symbol table info available. [08:39:08.430] #2 0x000000082c3f5bc9 in abort () from /lib/libc.so.7 [08:39:08.430] No symbol table info available. [08:39:08.430] #3 0x0000000000a5d217 in ExceptionalCondition (conditionName=, fileName=0x372e24 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [08:39:08.430] No locals. [08:39:08.430] #4 0x000000000073f910 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821321360, materialize=, shouldFree=shouldFree@entry=0x821321306) at ../src/backend/executor/execTuples.c:1737 [08:39:08.430] No locals. [08:39:08.430] #5 0x0000000000705af8 in ExecIRDeleteTriggers (estate=estate@entry=0x834f25100, relinfo=relinfo@entry=0x834f256b0, slot=slot@entry=0x821321360) at ../src/backend/commands/trigger.c:2841 [08:39:08.430] trigger = [08:39:08.430] oldtuple = [08:39:08.430] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8384b73b0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [08:39:08.430] trigdesc = 0x834f258c0 [08:39:08.430] newtuple = 0x0 [08:39:08.430] i = 0 [08:39:08.430] should_free = false [08:39:08.430] #6 0x0000000000764a0a in ExecMergeMatched (context=0x821321420, resultRelInfo=0x834f256b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [08:39:08.430] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [08:39:08.430] relaction = 0x834ebb720 [08:39:08.430] commandType = CMD_DELETE [08:39:08.430] result = TM_Ok [08:39:08.430] l__state = {l = 0x838604108, i = 0} [08:39:08.430] mtstate = 0x834f254a0 [08:39:08.430] newslot = 0x0 [08:39:08.430] rslot = 0x0 [08:39:08.430] estate = 0x18d51 [08:39:08.430] mergeActions = [08:39:08.430] econtext = 0x8386031a8 [08:39:08.430] epqstate = 0x834f25588 [08:39:08.430] actionStates = 0x838604108 [08:39:08.430] l = [08:39:08.430] isNull = [08:39:08.430] lmerge_matched = [08:39:08.430] __error = [08:39:08.430] l__state = [08:39:08.430] updateCxt = [08:39:08.430] relaction = [08:39:08.430] commandType = [08:39:08.430] result = [08:39:08.430] __error = [08:39:08.430] resultRelationDesc = [08:39:08.430] lockmode = [08:39:08.430] inputslot = [08:39:08.430] epqslot = [08:39:08.430] was_matched = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] #7 ExecMerge (context=0x821321420, resultRelInfo=0x834f256b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [08:39:08.430] matched = [08:39:08.430] rslot = 0x0 [08:39:08.430] #8 ExecModifyTable (pstate=0x834f254a0) at ../src/backend/executor/nodeModifyTable.c:4112 [08:39:08.430] context = {mtstate = 0x834f254a0, epqstate = 0x834f25588, estate = 0x834f25100, planSlot = 0x834ebb690, tmfd = {ctid = {ip_blkid = {bi_hi = 5320, bi_lo = 8498}, ip_posid = 8}, xmax = 742923760, cmax = 8, traversed = 144}, cpUpdateReturningSlot = 0x82c3c86de} [08:39:08.430] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [08:39:08.430] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x8384d9118} [08:39:08.430] node = 0x834f254a0 [08:39:08.430] estate = 0x834f25100 [08:39:08.430] operation = CMD_MERGE [08:39:08.430] resultRelInfo = 0x834f256b0 [08:39:08.430] subplanstate = 0x834f26df0 [08:39:08.430] slot = [08:39:08.430] tupleid = 0x0 [08:39:08.430] oldtuple = 0x0 [08:39:08.430] oldSlot = [08:39:08.430] #9 0x00000000007399ab in ExecProcNodeFirst (node=0x834f254a0) at ../src/backend/executor/execProcnode.c:464 [08:39:08.430] No locals. [08:39:08.430] #10 0x0000000000731c9a in ExecProcNode (node=0x834f254a0) at ../src/include/executor/executor.h:274 [08:39:08.430] No locals. [08:39:08.430] #11 ExecutePlan (estate=0x834f25100, planstate=0x834f254a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x834ed9310, execute_once=false) at ../src/backend/executor/execMain.c:1646 [08:39:08.430] current_tuple_count = [08:39:08.430] slot = [08:39:08.430] #12 standard_ExecutorRun (queryDesc=0x834e02448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [08:39:08.430] estate = 0x834f25100 [08:39:08.430] oldcontext = 0x834ed9000 [08:39:08.430] operation = CMD_MERGE [08:39:08.430] dest = 0x834ed9310 [08:39:08.430] sendTuples = true [08:39:08.430] #13 0x0000000838a14963 in pgss_ExecutorRun (queryDesc=0x834e02448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [08:39:08.430] _local_sigjmp_buf = {{_sjb = {35309832498, 12164520, 34916668760, 34916668928, 35246842952, 34916668768, 1, 1, 35248014207, 35246842952, 12173248, 34359738368}}} [08:39:08.430] _save_exception_stack = 0x821321720 [08:39:08.430] _save_context_stack = 0x0 [08:39:08.430] _do_rethrow = false [08:39:08.430] #14 0x0000000000731b48 in ExecutorRun (queryDesc=0x18d51, queryDesc@entry=0x834e02448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [08:39:08.430] No locals. [08:39:08.430] #15 0x000000000090ab2f in ProcessQuery (plan=0x8385b6b80, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x8213216e8) at ../src/backend/tcop/pquery.c:160 [08:39:08.430] queryDesc = 0x834e02448 [08:39:08.430] #16 0x000000000090a0cd in PortalRunMulti (portal=portal@entry=0x834de4100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x834ed9310, altdest=0xb512f0 , qc=qc@entry=0x8213216e8) at ../src/backend/tcop/pquery.c:1286 [08:39:08.430] pstmt = 0x8385b6b80 [08:39:08.430] stmtlist_item__state = {l = 0x8385bb438, i = 0} [08:39:08.430] active_snapshot_set = true [08:39:08.430] stmtlist_item = 0x8385bb450 [08:39:08.430] #17 0x0000000000909bbc in FillPortalStore (portal=portal@entry=0x834de4100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:39:08.430] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:39:08.430] treceiver = 0x834ed9310 [08:39:08.430] #18 0x0000000000909910 in PortalRun (portal=portal@entry=0x834de4100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8385bb488, altdest=altdest@entry=0x8385bb488, qc=0x821321820) at ../src/backend/tcop/pquery.c:763 [08:39:08.430] _local_sigjmp_buf = {{_sjb = {9476271, 35247054040, 34916669208, 34916669440, 34916669216, 12164520, 12132304, 35246719232, 7112098687, 35246727424, 3579028, 34359738368}}} [08:39:08.430] _save_exception_stack = 0x8213218f0 [08:39:08.430] _save_context_stack = 0x0 [08:39:08.430] _do_rethrow = false [08:39:08.430] saveTopTransactionResourceOwner = 0x834e35cd8 [08:39:08.430] saveTopTransactionContext = 0x834d55000 [08:39:08.430] saveActivePortal = 0x0 [08:39:08.430] saveResourceOwner = 0x834e35cd8 [08:39:08.430] savePortalContext = 0x0 [08:39:08.430] saveMemoryContext = 0x834d55000 [08:39:08.430] result = [08:39:08.430] nprocessed = [08:39:08.430] #19 0x000000000090881b in exec_simple_query (query_string=query_string@entry=0x834d49100 "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 [08:39:08.430] cmdtaglen = [08:39:08.430] snapshot_set = [08:39:08.430] per_parsetree_context = 0x0 [08:39:08.430] plantree_list = [08:39:08.430] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:39:08.430] parsetree = 0x8385a3c28 [08:39:08.430] commandTag = CMDTAG_MERGE [08:39:08.430] cmdtagname = [08:39:08.430] querytree_list = [08:39:08.430] portal = 0x834de4100 [08:39:08.430] format = 0 [08:39:08.430] receiver = 0x8385bb488 [08:39:08.430] parsetree_item__state = {l = 0x8385a54f0, i = 0} [08:39:08.430] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [08:39:08.430] dest = DestRemote [08:39:08.430] was_logged = [08:39:08.430] oldcontext = 0x834d55000 [08:39:08.430] parsetree_list = 0x8385a54f0 [08:39:08.430] use_implicit_block = false [08:39:08.430] parsetree_item = 0x8385a5508 [08:39:08.430] save_log_statement_stats = [08:39:08.430] #20 0x00000000009065f4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [08:39:08.430] query_string = 0x834d49100 "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"... [08:39:08.430] input_message = {data = 0x834d49100 "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} [08:39:08.430] firstchar = [08:39:08.430] local_sigjmp_buf = {{_sjb = {9460416, 34916669680, 34916669640, 34916670240, 12173256, 12119728, 8192, 8388608, 72057628954592127, 0, 0, 1}}} [08:39:08.430] send_ready_for_query = false [08:39:08.430] idle_in_transaction_timeout_enabled = false [08:39:08.430] idle_session_timeout_enabled = false [08:39:08.430] #21 0x00000000009010c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [08:39:08.430] bsdata = [08:39:08.430] #22 0x000000000085b022 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821322630 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821322578) at ../src/backend/postmaster/launch_backend.c:265 [08:39:08.430] pid = [08:39:08.430] #23 0x000000000085f981 in BackendStartup (client_sock=0x821322578) at ../src/backend/postmaster/postmaster.c:3593 [08:39:08.430] startup_data = {canAcceptConnections = CAC_OK} [08:39:08.430] bn = 0x834d55448 [08:39:08.430] pid = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] save_errno = [08:39:08.430] __error = [08:39:08.430] __error = [08:39:08.430] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [08:39:08.430] 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' , "\320%2!\b\000\000\000\330E\177+\b\000\000\000\v\000\000\000\000\000\000\000\016\306\177+\b", '\000' , "\020&2!\b\000\000\000\364\255\205\000\000\000\000\000 &2!\b", '\000' }, salen = 16}} [08:39:08.430] i = 0 [08:39:08.430] now = [08:39:08.430] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 556932432, events = 8, fd = 560677896, user_data = 0x21}, {pos = 556932416, events = 8, fd = -389817708, user_data = 0x8216ad008}, {pos = 560649224, events = 8, fd = 560650248, user_data = 0x8216adc08}, {pos = 560664584, events = 8, fd = 560665608, user_data = 0x8216b1808}, {pos = 560667656, events = 8, fd = 560668680, user_data = 0x8216b2408}, {pos = 560670728, events = 8, fd = 560671752, user_data = 0x8216b3008}, {pos = 560673800, events = 8, fd = 560674824, user_data = 0x8216b3c08}, {pos = 560676872, events = 8, fd = 560677896, user_data = 0x8216b90c8}, {pos = 556932808, events = 8, fd = 556932320, user_data = 0x2432e8c43da3}, {pos = 560677896, events = 8, fd = 2571326, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 560701496, user_data = 0x1}, {pos = 560677896, events = 8, fd = 740943016, user_data = 0x821321fc8}, {pos = 560677896, events = 8, fd = 556932288, user_data = 0x273b88}, {pos = 556932880, events = 8, fd = 741050724, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 560704056, user_data = 0x243200000001}, {pos = 560677896, events = 8, fd = 740964568, user_data = 0x821321e08}, {pos = 556932016, events = 8, fd = 33, user_data = 0x82c2b4c64}, {pos = 560677896, events = 8, fd = 560704056, user_data = 0x0}, {pos = 2625, events = 0, fd = 556932592, user_data = 0x2432e8c3d645}, {pos = 741050724, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 560704056, events = 8, fd = 1, user_data = 0x8216b4408}, {pos = 886280192, events = 8, fd = 1, user_data = 0x834d39194}, {pos = 0, events = 0, fd = 556932544, user_data = 0x82b7fbc0c}, {pos = 1, events = 0, fd = 886280192, user_data = 0x821321df0}, {pos = 729788084, events = 8, fd = 742777184, user_data = 0x82c45e160 }, {pos = 741146816, events = 8, fd = 560677896, user_data = 0x821321ed0}, {pos = -389819348, events = 9266, fd = 80627796, user_data = 0x1}, {pos = -389819730, events = 9266, fd = 12240, user_data = 0x821321df8}, {pos = 556932816, events = 8, fd = 887076840, user_data = 0x821322440}, {pos = -389738864, events = 9266, fd = 560677896, user_data = 0x82132037f}, {pos = 742433970, events = 8, fd = 556933120, user_data = 0x243200000000}, {pos = 560677896, events = 8, fd = 12240, user_data = 0x82c294000}, {pos = 1964368, events = 0, fd = 742777184, user_data = 0x82c2b4c64}, {pos = 15616, events = 0, fd = 556934000, user_data = 0x821321f40}, {pos = 741708174, events = 8, fd = 742815800, user_data = 0x821321f04}, {pos = 886732250, events = 8, fd = 556934000, user_data = 0x821321f40}, {pos = 741799429, events = 8, fd = 556932866, user_data = 0x821322370}, {pos = 556934000, events = 8, fd = 0, user_data = 0x27fdd6bfd260bd}, {pos = 556934000, events = 8, fd = 886732248, user_data = 0x821322440}, {pos = 742815800, events = 8, fd = 0, user_data = 0x8213223b0}, {pos = 741799693, events = 8, fd = 0, user_data = 0x0}, {pos = 556934368, events = 8, fd = 886732248, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -389790711, user_data = 0x821322088}, {pos = 741035108, events = 8, fd = 2503, user_data = 0x2432e8c44409}, {pos = 556933288, events = 8, fd = 741035108, user_data = 0xac6}, {pos = 741007648, events = 8, fd = 556933160, user_data = 0x8216b4408}, {pos = 556933288, events = 8, fd = 741007648, user_data = 0x821322090}, {pos = -389811099, events = 9266, fd = 0, user_data = 0x800000000}, {pos = 556933248, events = 8, fd = 740967760, user_data = 0x0}, {pos = 0, events = 0, fd = 556933216, user_data = 0x2432e8c44409}, {pos = 556933432, events = 8, fd = 741035108, user_data = 0xb6c}, {pos = 741008312, events = 8, fd = 556933304, user_data = 0x8216b4408}, {pos = 556933432, events = 8, fd = 741008312, user_data = 0x821322120}, {pos = -389811099, events = 9266, fd = 560701496, user_data = 0x28d146}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 560677896, user_data = 0x82c2a4550}, {pos = 556934152, events = 8, fd = 560677896, user_data = 0x213222e8}, {pos = 31, events = 0, fd = 0, user_data = 0x8213221c8}, {pos = 560699336, events = 8, fd = 556934040, user_data = 0x8213221b0}, {pos = -389792349, events = 9266, fd = 560701496, user_data = 0x292dce}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216ba038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [08:39:08.430] last_touch_time = 1713429397 [08:39:08.430] last_lockfile_recheck_time = 1713429397 [08:39:08.430] nevents = 1 [08:39:08.430] #25 0x000000000085d256 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821322b78) at ../src/backend/postmaster/postmaster.c:1372 [08:39:08.430] userDoption = [08:39:08.430] listen_addr_saved = false [08:39:08.430] output_config_variable = [08:39:08.430] opt = [08:39:08.430] status = [08:39:08.430] #26 0x0000000000794f15 in main (argc=4, argv=0x821322b78) at ../src/backend/main/main.c:197 [08:39:08.430] do_check_root =