[05:19:39.514] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [05:19:39.849] dumping /tmp/cores/postgres.8284.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [05:19:39.981] [New LWP 101719] [05:19:40.063] Core was generated by `postgres: postgres regression [local] MERGE'. [05:19:40.063] Program terminated with signal SIGABRT, Aborted. [05:19:40.063] Sent by thr_kill() from pid 8284 and user 1003. [05:19:40.063] #0 0x000000082c477dca in thr_kill () from /lib/libc.so.7 [05:19:40.586] [05:19:40.586] Thread 1 (LWP 101719): [05:19:40.586] #0 0x000000082c477dca in thr_kill () from /lib/libc.so.7 [05:19:40.586] No symbol table info available. [05:19:40.586] #1 0x000000082c3f06f4 in raise () from /lib/libc.so.7 [05:19:40.586] No symbol table info available. [05:19:40.586] #2 0x000000082c4a1bc9 in abort () from /lib/libc.so.7 [05:19:40.586] No symbol table info available. [05:19:40.586] #3 0x0000000000a5bf47 in ExceptionalCondition (conditionName=, fileName=0x372cab "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [05:19:40.586] No locals. [05:19:40.586] #4 0x000000000073eb40 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820d82100, materialize=, shouldFree=shouldFree@entry=0x820d820a6) at ../src/backend/executor/execTuples.c:1737 [05:19:40.586] No locals. [05:19:40.586] #5 0x0000000000704d38 in ExecIRDeleteTriggers (estate=estate@entry=0x84261d100, relinfo=relinfo@entry=0x84261d6b0, slot=slot@entry=0x820d82100) at ../src/backend/commands/trigger.c:2841 [05:19:40.586] trigger = [05:19:40.586] oldtuple = [05:19:40.586] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x84262eb30, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:19:40.586] trigdesc = 0x84261d8c0 [05:19:40.586] newtuple = 0x0 [05:19:40.586] i = 0 [05:19:40.586] should_free = false [05:19:40.586] #6 0x0000000000763c3a in ExecMergeMatched (context=0x820d821c0, resultRelInfo=0x84261d6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [05:19:40.586] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:19:40.586] relaction = 0x8426a6120 [05:19:40.586] commandType = CMD_DELETE [05:19:40.586] result = TM_Ok [05:19:40.586] l__state = {l = 0x84277a108, i = 0} [05:19:40.586] mtstate = 0x84261d4a0 [05:19:40.586] newslot = 0x0 [05:19:40.586] rslot = 0x0 [05:19:40.586] estate = 0x18d57 [05:19:40.586] mergeActions = [05:19:40.586] econtext = 0x8427791a8 [05:19:40.586] epqstate = 0x84261d588 [05:19:40.586] actionStates = 0x84277a108 [05:19:40.586] l = [05:19:40.586] isNull = [05:19:40.586] lmerge_matched = [05:19:40.586] __error = [05:19:40.586] l__state = [05:19:40.586] updateCxt = [05:19:40.586] relaction = [05:19:40.586] commandType = [05:19:40.586] result = [05:19:40.586] __error = [05:19:40.586] resultRelationDesc = [05:19:40.586] lockmode = [05:19:40.586] inputslot = [05:19:40.586] epqslot = [05:19:40.586] was_matched = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] #7 ExecMerge (context=0x820d821c0, resultRelInfo=0x84261d6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [05:19:40.586] matched = [05:19:40.586] rslot = 0x0 [05:19:40.586] #8 ExecModifyTable (pstate=0x84261d4a0) at ../src/backend/executor/nodeModifyTable.c:4112 [05:19:40.586] context = {mtstate = 0x84261d4a0, epqstate = 0x84261d588, estate = 0x84261d100, planSlot = 0x8426a6090, tmfd = {ctid = {ip_blkid = {bi_hi = 27264, bi_lo = 17018}, ip_posid = 8}, xmax = 1113708208, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x84261d100} [05:19:40.586] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [05:19:40.586] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x842672118} [05:19:40.586] node = 0x84261d4a0 [05:19:40.586] estate = 0x84261d100 [05:19:40.586] operation = CMD_MERGE [05:19:40.586] resultRelInfo = 0x84261d6b0 [05:19:40.586] subplanstate = 0x84261edf0 [05:19:40.586] slot = [05:19:40.586] tupleid = 0x0 [05:19:40.586] oldtuple = 0x0 [05:19:40.586] oldSlot = [05:19:40.586] #9 0x0000000000738bdb in ExecProcNodeFirst (node=0x84261d4a0) at ../src/backend/executor/execProcnode.c:464 [05:19:40.586] No locals. [05:19:40.586] #10 0x0000000000730eca in ExecProcNode (node=0x84261d4a0) at ../src/include/executor/executor.h:274 [05:19:40.586] No locals. [05:19:40.586] #11 ExecutePlan (estate=0x84261d100, planstate=0x84261d4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836438b10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [05:19:40.586] current_tuple_count = [05:19:40.586] slot = [05:19:40.586] #12 standard_ExecutorRun (queryDesc=0x8364cd448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [05:19:40.586] estate = 0x84261d100 [05:19:40.586] oldcontext = 0x836438800 [05:19:40.586] operation = CMD_MERGE [05:19:40.586] dest = 0x836438b10 [05:19:40.586] sendTuples = true [05:19:40.586] #13 0x0000000000730d7f in ExecutorRun (queryDesc=0x18d57, queryDesc@entry=0x8364cd448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [05:19:40.586] No locals. [05:19:40.586] #14 0x000000000090999f in ProcessQuery (plan=0x8427a3f60, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820d823d8) at ../src/backend/tcop/pquery.c:160 [05:19:40.586] queryDesc = 0x8364cd448 [05:19:40.586] #15 0x0000000000908f3d in PortalRunMulti (portal=portal@entry=0x836500100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836438b10, altdest=0xb50000 , qc=qc@entry=0x820d823d8) at ../src/backend/tcop/pquery.c:1286 [05:19:40.586] pstmt = 0x8427a3f60 [05:19:40.586] stmtlist_item__state = {l = 0x8427a8818, i = 0} [05:19:40.586] active_snapshot_set = true [05:19:40.586] stmtlist_item = 0x8427a8830 [05:19:40.586] #16 0x0000000000908a2c in FillPortalStore (portal=portal@entry=0x836500100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [05:19:40.586] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:19:40.586] treceiver = 0x836438b10 [05:19:40.586] #17 0x0000000000908780 in PortalRun (portal=portal@entry=0x836500100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8427a8868, altdest=altdest@entry=0x8427a8868, qc=0x820d82510) at ../src/backend/tcop/pquery.c:763 [05:19:40.586] _local_sigjmp_buf = {{_sjb = {9471775, 35271021400, 34910774280, 34910774512, 34910774288, 12159688, 12127472, 35270951168, 7112098687, 35270959360, 3578651, 34359738368}}} [05:19:40.586] _save_exception_stack = 0x820d825e0 [05:19:40.586] _save_context_stack = 0x0 [05:19:40.586] _do_rethrow = false [05:19:40.586] saveTopTransactionResourceOwner = 0x836511358 [05:19:40.586] saveTopTransactionContext = 0x836436000 [05:19:40.586] saveActivePortal = 0x0 [05:19:40.586] saveResourceOwner = 0x836511358 [05:19:40.586] savePortalContext = 0x0 [05:19:40.586] saveMemoryContext = 0x836436000 [05:19:40.586] result = [05:19:40.586] nprocessed = [05:19:40.586] #18 0x000000000090768b in exec_simple_query (query_string=query_string@entry=0x83642a100 "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 [05:19:40.586] cmdtaglen = [05:19:40.586] snapshot_set = [05:19:40.586] per_parsetree_context = 0x0 [05:19:40.586] plantree_list = [05:19:40.586] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:19:40.586] parsetree = 0x842746e68 [05:19:40.586] commandTag = CMDTAG_MERGE [05:19:40.586] cmdtagname = [05:19:40.586] querytree_list = [05:19:40.586] portal = 0x836500100 [05:19:40.586] format = 0 [05:19:40.586] receiver = 0x8427a8868 [05:19:40.586] parsetree_item__state = {l = 0x842748730, i = 0} [05:19:40.586] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [05:19:40.586] dest = DestRemote [05:19:40.586] was_logged = [05:19:40.586] oldcontext = 0x836436000 [05:19:40.586] parsetree_list = 0x842748730 [05:19:40.586] use_implicit_block = false [05:19:40.586] parsetree_item = 0x842748748 [05:19:40.586] save_log_statement_stats = [05:19:40.586] #19 0x0000000000905464 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [05:19:40.586] query_string = 0x83642a100 "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"... [05:19:40.586] input_message = {data = 0x83642a100 "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} [05:19:40.586] firstchar = [05:19:40.586] local_sigjmp_buf = {{_sjb = {9455920, 34910774752, 34910774712, 34910775312, 12168424, 12114896, 8192, 8388608, 72057628948693887, 0, 0, 34359738369}}} [05:19:40.586] send_ready_for_query = false [05:19:40.586] idle_in_transaction_timeout_enabled = false [05:19:40.586] idle_session_timeout_enabled = false [05:19:40.586] #20 0x00000000008fff39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [05:19:40.586] bsdata = [05:19:40.586] #21 0x0000000000859fe2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d83320 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d83268) at ../src/backend/postmaster/launch_backend.c:265 [05:19:40.586] pid = [05:19:40.586] #22 0x000000000085e941 in BackendStartup (client_sock=0x820d83268) at ../src/backend/postmaster/postmaster.c:3593 [05:19:40.586] startup_data = {canAcceptConnections = CAC_OK} [05:19:40.586] bn = 0x836436128 [05:19:40.586] pid = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] save_errno = [05:19:40.586] __error = [05:19:40.586] __error = [05:19:40.586] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [05:19:40.586] 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' , "\3002\330 \b\000\000\000\330\345\r*\b\000\000\000\v\000\000\000\000\000\000\000\016f\016*\b", '\000' , "3\330 \b\000\000\000\264\235\205\000\000\000\000\000\0203\330 \b", '\000' }, salen = 16}} [05:19:40.586] i = 0 [05:19:40.586] now = [05:19:40.586] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 741739620, events = 8, fd = 551037104, user_data = 0x820d82a40}, {pos = 555537416, events = 8, fd = 32, user_data = 0x820d82a30}, {pos = -1705760108, events = 7438, fd = 555507720, user_data = 0x8211c6408}, {pos = 555509768, events = 8, fd = 555510792, user_data = 0x8211ca008}, {pos = 555525128, events = 8, fd = 555526152, user_data = 0x8211cac08}, {pos = 555528200, events = 8, fd = 555529224, user_data = 0x8211cb808}, {pos = 555531272, events = 8, fd = 555532296, user_data = 0x8211cc408}, {pos = 555534344, events = 8, fd = 555535368, user_data = 0x8211cd008}, {pos = 555537416, events = 8, fd = -1, user_data = 0x82c5382e0}, {pos = 551037344, events = 8, fd = 743330217, user_data = 0x0}, {pos = 4096, events = 0, fd = -1751369438, user_data = 0x82c5387e8}, {pos = 906009568, events = 8, fd = 160, user_data = 0x0}, {pos = 884859024, events = 8, fd = 551037552, user_data = 0x82c4c392c}, {pos = 4096, events = 0, fd = 741755236, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 555563576, user_data = 0x800000001}, {pos = 555537416, events = 8, fd = 741669080, user_data = 0x820d82af8}, {pos = 551037104, events = 8, fd = 32, user_data = 0x82c360c64}, {pos = 555537416, events = 8, fd = 555563576, user_data = 0x0}, {pos = 2625, events = 0, fd = 551037664, user_data = 0x1d0e9a542645}, {pos = 741755236, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 555563576, events = 8, fd = 1, user_data = 0x8211cd408}, {pos = 910270464, events = 8, fd = 1, user_data = 0x83641a194}, {pos = 0, events = 0, fd = 551037616, user_data = 0x82a0e5c0c}, {pos = 1, events = 0, fd = 910270464, user_data = 0x820d82ae0}, {pos = 705580724, events = 8, fd = 743481696, user_data = 0x82c50a160 }, {pos = 741851328, events = 8, fd = 555537416, user_data = 0x820d82bc0}, {pos = -1705761748, events = 7438, fd = 884859024, user_data = 0x800000001}, {pos = -1705762130, events = 7438, fd = 12240, user_data = 0x820d82ae8}, {pos = 551037888, events = 8, fd = 910977000, user_data = 0x820d83130}, {pos = -1705681264, events = 7438, fd = 555537416, user_data = 0x820d8037f}, {pos = 743138716, events = 8, fd = 555507720, user_data = 0x0}, {pos = 555537416, events = 8, fd = 12240, user_data = 0x82c340000}, {pos = 1964368, events = 0, fd = 743481696, user_data = 0x82c360c64}, {pos = 15616, events = 0, fd = 551039072, user_data = 0x820d82c30}, {pos = 742412686, events = 8, fd = 743520312, user_data = 0x820d82bf4}, {pos = 910714330, events = 8, fd = 551039072, user_data = 0x820d82c30}, {pos = 742503941, events = 8, fd = 551037938, user_data = 0x820d83060}, {pos = 551039072, events = 8, fd = 0, user_data = 0x34197193979c3922}, {pos = 551039072, events = 8, fd = 910714328, user_data = 0x820d83130}, {pos = 743520312, events = 8, fd = 0, user_data = 0x820d830a0}, {pos = 742504205, events = 8, fd = 0, user_data = 0x0}, {pos = 551039440, events = 8, fd = 910714328, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1705733111, events = 7438, fd = 551038344, user_data = 0x82c360c64}, {pos = 2503, events = 0, fd = -1705733111, user_data = 0x820d82da8}, {pos = 741739620, events = 8, fd = 2758, user_data = 0x82c35a120}, {pos = 551038248, events = 8, fd = 555537416, user_data = 0x820d82da8}, {pos = 741712160, events = 8, fd = 551038352, user_data = 0x1d0e9a544465}, {pos = 0, events = 0, fd = 0, user_data = 0x82c52c0f0}, {pos = 741672272, events = 8, fd = 0, user_data = 0x0}, {pos = 743549360, events = 8, fd = -1705733111, user_data = 0x820d82e38}, {pos = 741739620, events = 8, fd = 2924, user_data = 0x82c35a3b8}, {pos = 551038392, events = 8, fd = 555537416, user_data = 0x820d82e38}, {pos = 741712824, events = 8, fd = 551038496, user_data = 0x1d0e9a544465}, {pos = 555561016, events = 8, fd = 2675238, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 555537416, events = 8, fd = 741672272, user_data = 0x820d830f8}, {pos = 555537416, events = 8, fd = 551038936, user_data = 0x1e}, {pos = 741676256, events = 8, fd = 551038664, user_data = 0x8211d2248}, {pos = 551039112, events = 8, fd = 551038640, user_data = 0x1d0e9a548da3}, {pos = 555561016, events = 8, fd = 2698926, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 555561016, user_data = 0x1}} [05:19:40.586] last_touch_time = 1712985411 [05:19:40.586] last_lockfile_recheck_time = 1712985411 [05:19:40.586] nevents = 1 [05:19:40.586] #24 0x000000000085c216 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d83868) at ../src/backend/postmaster/postmaster.c:1372 [05:19:40.586] userDoption = [05:19:40.586] listen_addr_saved = false [05:19:40.586] output_config_variable = [05:19:40.586] opt = [05:19:40.586] status = [05:19:40.586] #25 0x0000000000794145 in main (argc=8, argv=0x820d83868) at ../src/backend/main/main.c:197 [05:19:40.586] do_check_root = [05:19:40.597] [05:19:40.597] [05:19:40.597] [05:19:40.656] dumping /tmp/cores/postgres.9112.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [05:19:40.781] [New LWP 100181] [05:19:40.844] Core was generated by `postgres: old_node: postgres regression [local] MERGE'. [05:19:40.844] Program terminated with signal SIGABRT, Aborted. [05:19:40.844] Sent by thr_kill() from pid 9112 and user 1003. [05:19:40.844] #0 0x000000082d006dca in thr_kill () from /lib/libc.so.7 [05:19:41.355] [05:19:41.355] Thread 1 (LWP 100181): [05:19:41.355] #0 0x000000082d006dca in thr_kill () from /lib/libc.so.7 [05:19:41.355] No symbol table info available. [05:19:41.355] #1 0x000000082cf7f6f4 in raise () from /lib/libc.so.7 [05:19:41.355] No symbol table info available. [05:19:41.355] #2 0x000000082d030bc9 in abort () from /lib/libc.so.7 [05:19:41.355] No symbol table info available. [05:19:41.355] #3 0x0000000000a5bf47 in ExceptionalCondition (conditionName=, fileName=0x372cab "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [05:19:41.355] No locals. [05:19:41.355] #4 0x000000000073eb40 in ExecFetchSlotHeapTuple (slot=slot@entry=0x821120030, materialize=, shouldFree=shouldFree@entry=0x82111ffd6) at ../src/backend/executor/execTuples.c:1737 [05:19:41.355] No locals. [05:19:41.355] #5 0x0000000000704d38 in ExecIRDeleteTriggers (estate=estate@entry=0x838e21100, relinfo=relinfo@entry=0x838e216b0, slot=slot@entry=0x821120030) at ../src/backend/commands/trigger.c:2841 [05:19:41.355] trigger = [05:19:41.355] oldtuple = [05:19:41.355] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x8396ccdd0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:19:41.355] trigdesc = 0x838e218c0 [05:19:41.355] newtuple = 0x0 [05:19:41.355] i = 0 [05:19:41.355] should_free = false [05:19:41.355] #6 0x0000000000763c3a in ExecMergeMatched (context=0x8211200f0, resultRelInfo=0x838e216b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [05:19:41.355] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:19:41.355] relaction = 0x8397616e0 [05:19:41.355] commandType = CMD_DELETE [05:19:41.355] result = TM_Ok [05:19:41.355] l__state = {l = 0x8397da148, i = 0} [05:19:41.355] mtstate = 0x838e214a0 [05:19:41.355] newslot = 0x0 [05:19:41.355] rslot = 0x0 [05:19:41.355] estate = 0x18755 [05:19:41.355] mergeActions = [05:19:41.355] econtext = 0x8397d91e8 [05:19:41.355] epqstate = 0x838e21588 [05:19:41.355] actionStates = 0x8397da148 [05:19:41.355] l = [05:19:41.355] isNull = [05:19:41.355] lmerge_matched = [05:19:41.355] __error = [05:19:41.355] l__state = [05:19:41.355] updateCxt = [05:19:41.355] relaction = [05:19:41.355] commandType = [05:19:41.355] result = [05:19:41.355] __error = [05:19:41.355] resultRelationDesc = [05:19:41.355] lockmode = [05:19:41.355] inputslot = [05:19:41.355] epqslot = [05:19:41.355] was_matched = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] #7 ExecMerge (context=0x8211200f0, resultRelInfo=0x838e216b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [05:19:41.355] matched = [05:19:41.355] rslot = 0x0 [05:19:41.355] #8 ExecModifyTable (pstate=0x838e214a0) at ../src/backend/executor/nodeModifyTable.c:4112 [05:19:41.355] context = {mtstate = 0x838e214a0, epqstate = 0x838e21588, estate = 0x838e21100, planSlot = 0x839761650, tmfd = {ctid = {ip_blkid = {bi_hi = 37376, bi_lo = 14720}, ip_posid = 8}, xmax = 954341040, cmax = 8, traversed = 10}, cpUpdateReturningSlot = 0x838e21100} [05:19:41.355] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0} [05:19:41.355] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x838e35118} [05:19:41.355] node = 0x838e214a0 [05:19:41.355] estate = 0x838e21100 [05:19:41.355] operation = CMD_MERGE [05:19:41.355] resultRelInfo = 0x838e216b0 [05:19:41.355] subplanstate = 0x838e22df0 [05:19:41.355] slot = [05:19:41.355] tupleid = 0x0 [05:19:41.355] oldtuple = 0x0 [05:19:41.355] oldSlot = [05:19:41.355] #9 0x0000000000738bdb in ExecProcNodeFirst (node=0x838e214a0) at ../src/backend/executor/execProcnode.c:464 [05:19:41.355] No locals. [05:19:41.355] #10 0x0000000000730eca in ExecProcNode (node=0x838e214a0) at ../src/include/executor/executor.h:274 [05:19:41.355] No locals. [05:19:41.355] #11 ExecutePlan (estate=0x838e21100, planstate=0x838e214a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x838ca0f10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [05:19:41.355] current_tuple_count = [05:19:41.355] slot = [05:19:41.355] #12 standard_ExecutorRun (queryDesc=0x838d22448, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [05:19:41.355] estate = 0x838e21100 [05:19:41.355] oldcontext = 0x838ca0c00 [05:19:41.355] operation = CMD_MERGE [05:19:41.355] dest = 0x838ca0f10 [05:19:41.355] sendTuples = true [05:19:41.355] #13 0x0000000000730d7f in ExecutorRun (queryDesc=0x18755, queryDesc@entry=0x838d22448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [05:19:41.355] No locals. [05:19:41.355] #14 0x000000000090999f in ProcessQuery (plan=0x8398066e0, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x821120308) at ../src/backend/tcop/pquery.c:160 [05:19:41.355] queryDesc = 0x838d22448 [05:19:41.355] #15 0x0000000000908f3d in PortalRunMulti (portal=portal@entry=0x838d02100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x838ca0f10, altdest=0xb50000 , qc=qc@entry=0x821120308) at ../src/backend/tcop/pquery.c:1286 [05:19:41.355] pstmt = 0x8398066e0 [05:19:41.355] stmtlist_item__state = {l = 0x83980af98, i = 0} [05:19:41.355] active_snapshot_set = true [05:19:41.355] stmtlist_item = 0x83980afb0 [05:19:41.355] #16 0x0000000000908a2c in FillPortalStore (portal=portal@entry=0x838d02100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [05:19:41.355] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:19:41.355] treceiver = 0x838ca0f10 [05:19:41.355] #17 0x0000000000908780 in PortalRun (portal=portal@entry=0x838d02100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83980afe8, altdest=altdest@entry=0x83980afe8, qc=0x821120440) at ../src/backend/tcop/pquery.c:763 [05:19:41.355] _local_sigjmp_buf = {{_sjb = {9471775, 35313206488, 34914566968, 34914567200, 34914566976, 12159688, 12127472, 35312902400, 7112098687, 35312910592, 3578651, 34359738368}}} [05:19:41.355] _save_exception_stack = 0x821120510 [05:19:41.355] _save_context_stack = 0x0 [05:19:41.355] _do_rethrow = false [05:19:41.355] saveTopTransactionResourceOwner = 0x838d4c4d8 [05:19:41.355] saveTopTransactionContext = 0x838c75000 [05:19:41.355] saveActivePortal = 0x0 [05:19:41.355] saveResourceOwner = 0x838d4c4d8 [05:19:41.355] savePortalContext = 0x0 [05:19:41.355] saveMemoryContext = 0x838c75000 [05:19:41.355] result = [05:19:41.355] nprocessed = [05:19:41.355] #18 0x000000000090768b in exec_simple_query (query_string=query_string@entry=0x838c69100 "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 [05:19:41.355] cmdtaglen = [05:19:41.355] snapshot_set = [05:19:41.355] per_parsetree_context = 0x0 [05:19:41.355] plantree_list = [05:19:41.355] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:19:41.355] parsetree = 0x8397a73a8 [05:19:41.355] commandTag = CMDTAG_MERGE [05:19:41.355] cmdtagname = [05:19:41.355] querytree_list = [05:19:41.355] portal = 0x838d02100 [05:19:41.355] format = 0 [05:19:41.355] receiver = 0x83980afe8 [05:19:41.355] parsetree_item__state = {l = 0x8397a8c70, i = 0} [05:19:41.355] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [05:19:41.355] dest = DestRemote [05:19:41.355] was_logged = [05:19:41.355] oldcontext = 0x838c75000 [05:19:41.355] parsetree_list = 0x8397a8c70 [05:19:41.355] use_implicit_block = false [05:19:41.355] parsetree_item = 0x8397a8c88 [05:19:41.355] save_log_statement_stats = [05:19:41.355] #19 0x0000000000905464 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [05:19:41.355] query_string = 0x838c69100 "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"... [05:19:41.355] input_message = {data = 0x838c69100 "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} [05:19:41.355] firstchar = [05:19:41.355] local_sigjmp_buf = {{_sjb = {9455920, 34914567440, 34914567400, 34914568000, 12168424, 12114896, 8192, 8388608, 72057628952494975, 0, 0, 34359738369}}} [05:19:41.355] send_ready_for_query = false [05:19:41.355] idle_in_transaction_timeout_enabled = false [05:19:41.355] idle_session_timeout_enabled = false [05:19:41.355] #20 0x00000000008fff39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [05:19:41.355] bsdata = [05:19:41.355] #21 0x0000000000859fe2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821121250 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821121198) at ../src/backend/postmaster/launch_backend.c:265 [05:19:41.355] pid = [05:19:41.355] #22 0x000000000085e941 in BackendStartup (client_sock=0x821121198) at ../src/backend/postmaster/postmaster.c:3593 [05:19:41.355] startup_data = {canAcceptConnections = CAC_OK} [05:19:41.355] bn = 0x838c75038 [05:19:41.355] pid = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] save_errno = [05:19:41.355] __error = [05:19:41.355] __error = [05:19:41.355] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [05:19:41.355] 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\021\022!\b\000\000\000\330e6,\b\000\000\000\v\000\000\000\000\000\000\000\016\3466,\b", '\000' , "0\022\022!\b\000\000\000\264\235\205\000\000\000\000\000@\022\022!\b", '\000' }, salen = 16}} [05:19:41.355] i = 0 [05:19:41.355] now = [05:19:41.355] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 753859684, events = 8, fd = 554829792, user_data = 0x821120970}, {pos = 567550984, events = 8, fd = 32, user_data = 0x821120960}, {pos = 1404746388, events = 12990, fd = 567521288, user_data = 0x821d3b408}, {pos = 567523336, events = 8, fd = 567524360, user_data = 0x821d3f008}, {pos = 567538696, events = 8, fd = 567539720, user_data = 0x821d3fc08}, {pos = 567541768, events = 8, fd = 567542792, user_data = 0x821d40808}, {pos = 567544840, events = 8, fd = 567545864, user_data = 0x821d41408}, {pos = 567547912, events = 8, fd = 567548936, user_data = 0x821d42008}, {pos = 567550984, events = 8, fd = 567570568, user_data = 0x821120ae8}, {pos = 554830096, events = 8, fd = 1404771747, user_data = 0x0}, {pos = 2571482, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 567574584, events = 8, fd = 1, user_data = 0x821d42408}, {pos = 753767592, events = 8, fd = 554830824, user_data = 0x821d42408}, {pos = 554830080, events = 0, fd = 753875300, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 567577144, user_data = 0x1}, {pos = 567550984, events = 8, fd = 753789144, user_data = 0x821120a28}, {pos = 554829792, events = 8, fd = 32, user_data = 0x82ceefc64}, {pos = 567550984, events = 8, fd = 567577144, user_data = 0x0}, {pos = 2625, events = 0, fd = 554830352, user_data = 0x32be53bab645}, {pos = 753875300, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 567577144, events = 8, fd = 1, user_data = 0x821d42408}, {pos = 952471552, events = 8, fd = 1, user_data = 0x838c59194}, {pos = 0, events = 0, fd = 554830304, user_data = 0x82c36dc0c}, {pos = 1, events = 0, fd = 952471552, user_data = 0x821120a10}, {pos = 741789364, events = 8, fd = 755601760, user_data = 0x82d099160 }, {pos = 753971392, events = 8, fd = 567550984, user_data = 0x821120af0}, {pos = 1404744748, events = 12990, fd = 567549960, user_data = 0x800000001}, {pos = 1404744366, events = 12990, fd = 12240, user_data = 0x821120a18}, {pos = 554830576, events = 8, fd = 953268200, user_data = 0x821121060}, {pos = 1404825232, events = 12990, fd = 567550984, user_data = 0x82112037f}, {pos = 755258546, events = 8, fd = 567521288, user_data = 0x0}, {pos = 567550984, events = 8, fd = 12240, user_data = 0x82cecf000}, {pos = 1964368, events = 0, fd = 755601760, user_data = 0x82ceefc64}, {pos = 15616, events = 0, fd = 554831760, user_data = 0x821120b60}, {pos = 754532750, events = 8, fd = 755640376, user_data = 0x821120b24}, {pos = 952923610, events = 8, fd = 554831760, user_data = 0x821120b60}, {pos = 754624005, events = 8, fd = 554830626, user_data = 0x821120f90}, {pos = 554831760, events = 8, fd = 0, user_data = 0x48f4560f99327f75}, {pos = 554831760, events = 8, fd = 952923608, user_data = 0x821121060}, {pos = 755640376, events = 8, fd = 0, user_data = 0x821120fd0}, {pos = 754624269, events = 8, fd = 0, user_data = 0x0}, {pos = 554832128, events = 8, fd = 952923608, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1404773385, events = 12990, fd = 554831032, user_data = 0x82ceefc64}, {pos = 2503, events = 0, fd = 1404773385, user_data = 0x821120cd8}, {pos = 753859684, events = 8, fd = 2758, user_data = 0x82cee9120}, {pos = 554830936, events = 8, fd = 567550984, user_data = 0x821120cd8}, {pos = 753832224, events = 8, fd = 554831040, user_data = 0x32be53bad465}, {pos = 0, events = 0, fd = 0, user_data = 0x82d0bb0f0}, {pos = 753792336, events = 8, fd = 0, user_data = 0x0}, {pos = 755669424, events = 8, fd = 1404773385, user_data = 0x821120d68}, {pos = 753859684, events = 8, fd = 2924, user_data = 0x82cee93b8}, {pos = 554831080, events = 8, fd = 567550984, user_data = 0x821120d68}, {pos = 753832888, events = 8, fd = 554831184, user_data = 0x32be53bad465}, {pos = 567574584, events = 8, fd = 2675238, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567550984, events = 8, fd = 753792336, user_data = 0x821121028}, {pos = 567550984, events = 8, fd = 554831624, user_data = 0x1e}, {pos = 753796320, events = 8, fd = 554831352, user_data = 0x821d47248}, {pos = 554831800, events = 8, fd = 554831328, user_data = 0x32be53bb1da3}, {pos = 567574584, events = 8, fd = 2698926, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 567574584, user_data = 0x1}} [05:19:41.355] last_touch_time = 1712985413 [05:19:41.355] last_lockfile_recheck_time = 1712985413 [05:19:41.355] nevents = 1 [05:19:41.355] #24 0x000000000085c216 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821121798) at ../src/backend/postmaster/postmaster.c:1372 [05:19:41.355] userDoption = [05:19:41.355] listen_addr_saved = false [05:19:41.355] output_config_variable = [05:19:41.355] opt = [05:19:41.355] status = [05:19:41.355] #25 0x0000000000794145 in main (argc=4, argv=0x821121798) at ../src/backend/main/main.c:197 [05:19:41.355] do_check_root = [05:19:41.366] [05:19:41.366] [05:19:41.366] [05:19:41.425] dumping /tmp/cores/postgres.14087.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [05:19:41.549] [New LWP 101741] [05:19:41.612] Core was generated by `postgres: primary: postgres regression [local] MERGE'. [05:19:41.612] Program terminated with signal SIGABRT, Aborted. [05:19:41.612] Sent by thr_kill() from pid 14087 and user 1003. [05:19:41.612] #0 0x000000082c740dca in thr_kill () from /lib/libc.so.7 [05:19:42.127] [05:19:42.127] Thread 1 (LWP 101741): [05:19:42.127] #0 0x000000082c740dca in thr_kill () from /lib/libc.so.7 [05:19:42.127] No symbol table info available. [05:19:42.127] #1 0x000000082c6b96f4 in raise () from /lib/libc.so.7 [05:19:42.127] No symbol table info available. [05:19:42.127] #2 0x000000082c76abc9 in abort () from /lib/libc.so.7 [05:19:42.127] No symbol table info available. [05:19:42.127] #3 0x0000000000a5bf47 in ExceptionalCondition (conditionName=, fileName=0x372cab "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [05:19:42.127] No locals. [05:19:42.127] #4 0x000000000073eb40 in ExecFetchSlotHeapTuple (slot=slot@entry=0x820f54070, materialize=, shouldFree=shouldFree@entry=0x820f54016) at ../src/backend/executor/execTuples.c:1737 [05:19:42.127] No locals. [05:19:42.127] #5 0x0000000000704d38 in ExecIRDeleteTriggers (estate=estate@entry=0x836f6b100, relinfo=relinfo@entry=0x836f6b6b0, slot=slot@entry=0x820f54070) at ../src/backend/commands/trigger.c:2841 [05:19:42.127] trigger = [05:19:42.127] oldtuple = [05:19:42.127] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x839afdaf0, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:19:42.127] trigdesc = 0x836f6b8c0 [05:19:42.127] newtuple = 0x0 [05:19:42.127] i = 0 [05:19:42.127] should_free = false [05:19:42.127] #6 0x0000000000763c3a in ExecMergeMatched (context=0x820f54130, resultRelInfo=0x836f6b6b0, tupleid=0x0, oldtuple=0x0, canSetTag=, matched=) at ../src/backend/executor/nodeModifyTable.c:3027 [05:19:42.127] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:19:42.127] relaction = 0x836f01da0 [05:19:42.127] commandType = CMD_DELETE [05:19:42.127] result = TM_Ok [05:19:42.127] l__state = {l = 0x839c3de88, i = 0} [05:19:42.127] mtstate = 0x836f6b4a0 [05:19:42.127] newslot = 0x0 [05:19:42.127] rslot = 0x0 [05:19:42.127] estate = 0x18d6d [05:19:42.127] mergeActions = [05:19:42.127] econtext = 0x839c3cf28 [05:19:42.127] epqstate = 0x836f6b588 [05:19:42.127] actionStates = 0x839c3de88 [05:19:42.127] l = [05:19:42.127] isNull = [05:19:42.127] lmerge_matched = [05:19:42.127] __error = [05:19:42.127] l__state = [05:19:42.127] updateCxt = [05:19:42.127] relaction = [05:19:42.127] commandType = [05:19:42.127] result = [05:19:42.127] __error = [05:19:42.127] resultRelationDesc = [05:19:42.127] lockmode = [05:19:42.127] inputslot = [05:19:42.127] epqslot = [05:19:42.127] was_matched = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] #7 ExecMerge (context=0x820f54130, resultRelInfo=0x836f6b6b0, tupleid=0x0, oldtuple=0x0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [05:19:42.127] matched = [05:19:42.127] rslot = 0x0 [05:19:42.127] #8 ExecModifyTable (pstate=0x836f6b4a0) at ../src/backend/executor/nodeModifyTable.c:4112 [05:19:42.127] context = {mtstate = 0x836f6b4a0, epqstate = 0x836f6b588, estate = 0x836f6b100, planSlot = 0x836f01d10, tmfd = {ctid = {ip_blkid = {bi_hi = 16856, bi_lo = 8437}, ip_posid = 8}, xmax = 746548720, cmax = 8, traversed = 160}, cpUpdateReturningSlot = 0x82c73d6de} [05:19:42.127] tuple_ctid = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 0} [05:19:42.127] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x839b13118} [05:19:42.127] node = 0x836f6b4a0 [05:19:42.127] estate = 0x836f6b100 [05:19:42.127] operation = CMD_MERGE [05:19:42.127] resultRelInfo = 0x836f6b6b0 [05:19:42.127] subplanstate = 0x836f6cdf0 [05:19:42.127] slot = [05:19:42.127] tupleid = 0x0 [05:19:42.127] oldtuple = 0x0 [05:19:42.127] oldSlot = [05:19:42.127] #9 0x0000000000738bdb in ExecProcNodeFirst (node=0x836f6b4a0) at ../src/backend/executor/execProcnode.c:464 [05:19:42.127] No locals. [05:19:42.127] #10 0x0000000000730eca in ExecProcNode (node=0x836f6b4a0) at ../src/include/executor/executor.h:274 [05:19:42.127] No locals. [05:19:42.127] #11 ExecutePlan (estate=0x836f6b100, planstate=0x836f6b4a0, use_parallel_mode=, operation=CMD_MERGE, sendTuples=true, numberTuples=0, direction=, dest=0x836d9db10, execute_once=false) at ../src/backend/executor/execMain.c:1646 [05:19:42.127] current_tuple_count = [05:19:42.127] slot = [05:19:42.127] #12 standard_ExecutorRun (queryDesc=0x836e48448, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [05:19:42.127] estate = 0x836f6b100 [05:19:42.127] oldcontext = 0x836d9d800 [05:19:42.127] operation = CMD_MERGE [05:19:42.127] dest = 0x836d9db10 [05:19:42.127] sendTuples = true [05:19:42.127] #13 0x00000008393ba963 in pgss_ExecutorRun (queryDesc=0x836e48448, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [05:19:42.127] _local_sigjmp_buf = {{_sjb = {35319949618, 12159688, 34912682600, 34912682768, 35280684104, 34912682608, 1, 1, 35281830783, 35280684104, 12168416, 34359738368}}} [05:19:42.127] _save_exception_stack = 0x820f54430 [05:19:42.127] _save_context_stack = 0x0 [05:19:42.127] _do_rethrow = false [05:19:42.127] #14 0x0000000000730d78 in ExecutorRun (queryDesc=0x18d6d, queryDesc@entry=0x836e48448, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [05:19:42.127] No locals. [05:19:42.127] #15 0x000000000090999f in ProcessQuery (plan=0x839c01c40, sourceText=, params=0x0, queryEnv=0x0, dest=, qc=0x820f543f8) at ../src/backend/tcop/pquery.c:160 [05:19:42.127] queryDesc = 0x836e48448 [05:19:42.127] #16 0x0000000000908f3d in PortalRunMulti (portal=portal@entry=0x836e2a100, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x836d9db10, altdest=0xb50000 , qc=qc@entry=0x820f543f8) at ../src/backend/tcop/pquery.c:1286 [05:19:42.127] pstmt = 0x839c01c40 [05:19:42.127] stmtlist_item__state = {l = 0x839c064f8, i = 0} [05:19:42.127] active_snapshot_set = true [05:19:42.127] stmtlist_item = 0x839c06510 [05:19:42.127] #17 0x0000000000908a2c in FillPortalStore (portal=portal@entry=0x836e2a100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [05:19:42.127] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:19:42.127] treceiver = 0x836d9db10 [05:19:42.127] #18 0x0000000000908780 in PortalRun (portal=portal@entry=0x836e2a100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x839c06548, altdest=altdest@entry=0x839c06548, qc=0x820f54530) at ../src/backend/tcop/pquery.c:763 [05:19:42.127] _local_sigjmp_buf = {{_sjb = {9471775, 35280895768, 34912683048, 34912683280, 34912683056, 12159688, 12127472, 35280560384, 7112098687, 35280568576, 3578651, 34359738368}}} [05:19:42.127] _save_exception_stack = 0x820f54600 [05:19:42.127] _save_context_stack = 0x0 [05:19:42.127] _do_rethrow = false [05:19:42.127] saveTopTransactionResourceOwner = 0x836e7bf18 [05:19:42.127] saveTopTransactionContext = 0x836d9b000 [05:19:42.127] saveActivePortal = 0x0 [05:19:42.127] saveResourceOwner = 0x836e7bf18 [05:19:42.127] savePortalContext = 0x0 [05:19:42.127] saveMemoryContext = 0x836d9b000 [05:19:42.127] result = [05:19:42.127] nprocessed = [05:19:42.127] #19 0x000000000090768b in exec_simple_query (query_string=query_string@entry=0x836d8f100 "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 [05:19:42.127] cmdtaglen = [05:19:42.127] snapshot_set = [05:19:42.127] per_parsetree_context = 0x0 [05:19:42.127] plantree_list = [05:19:42.127] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:19:42.127] parsetree = 0x839bdcea8 [05:19:42.127] commandTag = CMDTAG_MERGE [05:19:42.127] cmdtagname = [05:19:42.127] querytree_list = [05:19:42.127] portal = 0x836e2a100 [05:19:42.127] format = 0 [05:19:42.127] receiver = 0x839c06548 [05:19:42.127] parsetree_item__state = {l = 0x839bde770, i = 0} [05:19:42.127] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [05:19:42.127] dest = DestRemote [05:19:42.127] was_logged = [05:19:42.127] oldcontext = 0x836d9b000 [05:19:42.127] parsetree_list = 0x839bde770 [05:19:42.127] use_implicit_block = false [05:19:42.127] parsetree_item = 0x839bde788 [05:19:42.127] save_log_statement_stats = [05:19:42.127] #20 0x0000000000905464 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [05:19:42.127] query_string = 0x836d8f100 "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"... [05:19:42.127] input_message = {data = 0x836d8f100 "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} [05:19:42.127] firstchar = [05:19:42.127] local_sigjmp_buf = {{_sjb = {9455920, 34912683520, 34912683480, 34912684080, 12168424, 12114896, 8192, 8388608, 72057628950594431, 0, 0, 1}}} [05:19:42.127] send_ready_for_query = false [05:19:42.127] idle_in_transaction_timeout_enabled = false [05:19:42.127] idle_session_timeout_enabled = false [05:19:42.127] #21 0x00000000008fff39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [05:19:42.127] bsdata = [05:19:42.127] #22 0x0000000000859fe2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820f55340 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f55288) at ../src/backend/postmaster/launch_backend.c:265 [05:19:42.127] pid = [05:19:42.127] #23 0x000000000085e941 in BackendStartup (client_sock=0x820f55288) at ../src/backend/postmaster/postmaster.c:3593 [05:19:42.127] startup_data = {canAcceptConnections = CAC_OK} [05:19:42.127] bn = 0x836d9b128 [05:19:42.127] pid = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] save_errno = [05:19:42.127] __error = [05:19:42.127] __error = [05:19:42.127] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [05:19:42.127] 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' , "\340R\365 \b\000\000\000إ\272*\b\000\000\000\v\000\000\000\000\000\000\000\016&\273*\b", '\000' , " S\365 \b\000\000\000\264\235\205\000\000\000\000\0000S\365 \b", '\000' }, salen = 16}} [05:19:42.127] i = 0 [05:19:42.127] now = [05:19:42.127] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 552946272, events = 8, fd = 568833032, user_data = 0x21}, {pos = 552946256, events = 8, fd = 1863379604, user_data = 0x821e74008}, {pos = 568804360, events = 8, fd = 568805384, user_data = 0x821e74c08}, {pos = 568819720, events = 8, fd = 568820744, user_data = 0x821e78808}, {pos = 568822792, events = 8, fd = 568823816, user_data = 0x821e79408}, {pos = 568825864, events = 8, fd = 568826888, user_data = 0x821e7a008}, {pos = 568828936, events = 8, fd = 568829960, user_data = 0x821e7ac08}, {pos = 568832008, events = 8, fd = 568833032, user_data = 0x821e80088}, {pos = 552946648, events = 8, fd = 552946160, user_data = 0x2706f114da3}, {pos = 568833032, events = 8, fd = 2571482, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 568856632, user_data = 0x1}, {pos = 568833032, events = 8, fd = 744567976, user_data = 0x820f54cd8}, {pos = 568833032, events = 8, fd = 552946128, user_data = 0x273c24}, {pos = 552946720, events = 8, fd = 744675684, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 568859192, user_data = 0x27000000001}, {pos = 568833032, events = 8, fd = 744589528, user_data = 0x820f54b18}, {pos = 552945856, events = 8, fd = 33, user_data = 0x82c629c64}, {pos = 568833032, events = 8, fd = 568859192, user_data = 0x0}, {pos = 2625, events = 0, fd = 552946432, user_data = 0x2706f10e645}, {pos = 744675684, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 568859192, events = 8, fd = 1, user_data = 0x821e7b408}, {pos = 920121344, events = 8, fd = 1, user_data = 0x836d7f194}, {pos = 0, events = 0, fd = 552946384, user_data = 0x82abb1c0c}, {pos = 1, events = 0, fd = 920121344, user_data = 0x820f54b00}, {pos = 716902068, events = 8, fd = 746402144, user_data = 0x82c7d3160 }, {pos = 744771776, events = 8, fd = 568833032, user_data = 0x820f54be0}, {pos = 1863377964, events = 624, fd = 80627796, user_data = 0x1}, {pos = 1863377582, events = 624, fd = 12240, user_data = 0x820f54b08}, {pos = 552946656, events = 8, fd = 920917992, user_data = 0x820f55150}, {pos = 1863458448, events = 624, fd = 568833032, user_data = 0x820f5037f}, {pos = 746058930, events = 8, fd = 552946960, user_data = 0x27000000000}, {pos = 568833032, events = 8, fd = 12240, user_data = 0x82c609000}, {pos = 1964368, events = 0, fd = 746402144, user_data = 0x82c629c64}, {pos = 15616, events = 0, fd = 552947840, user_data = 0x820f54c50}, {pos = 745333134, events = 8, fd = 746440760, user_data = 0x820f54c14}, {pos = 920573402, events = 8, fd = 552947840, user_data = 0x820f54c50}, {pos = 745424389, events = 8, fd = 552946706, user_data = 0x820f55080}, {pos = 552947840, events = 8, fd = 0, user_data = 0x9533d78b62381899}, {pos = 552947840, events = 8, fd = 920573400, user_data = 0x820f55150}, {pos = 746440760, events = 8, fd = 0, user_data = 0x820f550c0}, {pos = 745424653, events = 8, fd = 0, user_data = 0x0}, {pos = 552948208, events = 8, fd = 920573400, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1863406601, user_data = 0x820f54d98}, {pos = 744660068, events = 8, fd = 2503, user_data = 0x2706f115409}, {pos = 552947128, events = 8, fd = 744660068, user_data = 0xac6}, {pos = 744632608, events = 8, fd = 552947000, user_data = 0x821e7b408}, {pos = 552947128, events = 8, fd = 744632608, user_data = 0x820f54da0}, {pos = 1863386213, events = 624, fd = 0, user_data = 0x800000000}, {pos = 552947088, events = 8, fd = 744592720, user_data = 0x0}, {pos = 0, events = 0, fd = 552947056, user_data = 0x2706f115409}, {pos = 552947272, events = 8, fd = 744660068, user_data = 0xb6c}, {pos = 744633272, events = 8, fd = 552947144, user_data = 0x821e7b408}, {pos = 552947272, events = 8, fd = 744633272, user_data = 0x820f54e30}, {pos = 1863386213, events = 624, fd = 568856632, user_data = 0x28d226}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 568833032, user_data = 0x82c619550}, {pos = 552947992, events = 8, fd = 568833032, user_data = 0x20f54ff8}, {pos = 31, events = 0, fd = 0, user_data = 0x820f54ed8}, {pos = 568854408, events = 8, fd = 552947880, user_data = 0x820f54ec0}, {pos = 1863404963, events = 624, fd = 568856632, user_data = 0x292eae}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821e81038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [05:19:42.127] last_touch_time = 1712985432 [05:19:42.127] last_lockfile_recheck_time = 1712985432 [05:19:42.127] nevents = 1 [05:19:42.127] #25 0x000000000085c216 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f55880) at ../src/backend/postmaster/postmaster.c:1372 [05:19:42.127] userDoption = [05:19:42.127] listen_addr_saved = false [05:19:42.127] output_config_variable = [05:19:42.127] opt = [05:19:42.127] status = [05:19:42.127] #26 0x0000000000794145 in main (argc=4, argv=0x820f55880) at ../src/backend/main/main.c:197 [05:19:42.127] do_check_root =