[10:44:06.973] src/tools/ci/cores_backtrace.sh linux /tmp/cores [10:44:07.167] dumping /tmp/cores/postgres-3-36631.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:44:07.406] [New LWP 36631] [10:44:07.406] [10:44:07.406] This GDB supports auto-downloading debuginfo from the following URLs: [10:44:07.406] [10:44:07.406] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [10:44:07.406] Debuginfod has been disabled. [10:44:07.406] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [10:44:07.522] [New LWP 36273] [10:44:07.522] [Thread debugging using libthread_db enabled] [10:44:07.522] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [10:44:07.522] Core was generated by `postgres: standby2: startup recovering 000000020000000000000004 '. [10:44:07.522] Program terminated with signal SIGQUIT, Quit. [10:44:07.522] #0 0x00007fe7a7aaeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:07.556] [Current thread is 1 (LWP 36631)] [10:44:07.563] [10:44:07.563] Thread 2 (Thread 0x7fe7a8238f00 (LWP 36273)): [10:44:07.563] warning: Couldn't find general-purpose registers in core file. [10:44:07.563] #0 in ?? () [10:44:07.563] PC unavailable, cannot determine locals. [10:44:07.563] Backtrace stopped: not enough registers or memory available to unwind further [10:44:07.563] [10:44:07.563] Thread 1 (LWP 36631): [10:44:07.563] #0 0x00007fe7a7aaeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:07.563] No symbol table info available. [10:44:07.563] #1 0x00007fe7a7a5b239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:07.563] No symbol table info available. [10:44:07.563] #2 0x00007fe7a7b16204 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:07.563] No symbol table info available. [10:44:07.563] #3 0x00007fe7a7b2885c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:07.563] No symbol table info available. [10:44:07.581] -e [10:44:07.581] [10:44:07.581] [10:44:07.643] dumping /tmp/cores/postgres-6-29214.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [10:44:07.898] [New LWP 29214] [10:44:07.898] [10:44:07.898] This GDB supports auto-downloading debuginfo from the following URLs: [10:44:07.898] [10:44:07.898] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [10:44:07.898] Debuginfod has been disabled. [10:44:07.898] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [10:44:08.011] [Thread debugging using libthread_db enabled] [10:44:08.011] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [10:44:08.011] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [10:44:08.011] Program terminated with signal SIGABRT, Aborted. [10:44:08.011] #0 0x00007fddbe8a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:08.904] [10:44:08.904] Thread 1 (Thread 0x7fddbf033f00 (LWP 29214)): [10:44:08.904] #0 0x00007fddbe8a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:08.904] No symbol table info available. [10:44:08.904] #1 0x00007fddbe85afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:08.904] No symbol table info available. [10:44:08.904] #2 0x00007fddbe845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:08.904] No symbol table info available. [10:44:08.904] #3 0x00005564dbee6eea in ExceptionalCondition (conditionName=conditionName@entry=0x5564dc16495d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5564dc163eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [10:44:08.904] No locals. [10:44:08.904] #4 0x00005564db851fbf in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5564f86e7e70, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [10:44:08.904] estate = 0x5564f867e9b0 [10:44:08.904] oldcontext = 0x5564f8730210 [10:44:08.904] __func__ = "standard_ExecutorStart" [10:44:08.904] #5 0x00005564db85219b in ExecutorStart (queryDesc=queryDesc@entry=0x5564f86e7e70, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [10:44:08.904] No locals. [10:44:08.904] #6 0x00005564db77176c in refresh_matview_datafill (dest=0x5564f87146d0, query=, query@entry=0x5564f86af330, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [10:44:08.904] rewritten = [10:44:08.904] plan = 0x5564f86e74c8 [10:44:08.904] queryDesc = 0x5564f86e7e70 [10:44:08.904] copied_query = [10:44:08.904] processed = [10:44:08.904] __func__ = "refresh_matview_datafill" [10:44:08.904] #7 0x00005564db773ac6 in RefreshMatViewByOid (matviewOid=28632, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [10:44:08.904] dest = [10:44:08.904] matviewRel = 0x7fddb2d1b4e0 [10:44:08.904] rule = [10:44:08.904] actions = [10:44:08.904] dataQuery = 0x5564f86af330 [10:44:08.904] tableSpace = [10:44:08.904] relowner = 10 [10:44:08.904] OIDNewHeap = 28647 [10:44:08.904] processed = 0 [10:44:08.904] relpersistence = 112 'p' [10:44:08.904] save_userid = 10 [10:44:08.904] save_sec_context = 0 [10:44:08.904] save_nestlevel = 2 [10:44:08.904] address = {classId = 0, objectId = 0, objectSubId = 0} [10:44:08.904] __func__ = "RefreshMatViewByOid" [10:44:08.904] #8 0x00005564db773c05 in ExecRefreshMatView (stmt=0x5564f87143a8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [10:44:08.904] matviewOid = [10:44:08.904] lockmode = [10:44:08.904] #9 0x00005564db7296d9 in ExecCreateTableAs (pstate=pstate@entry=0x5564f8730310, stmt=stmt@entry=0x5564f85717f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcd646b350) at ../src/backend/commands/createas.c:351 [10:44:08.904] refresh = [10:44:08.904] query = 0x5564f85719b0 [10:44:08.904] into = 0x5564f8571548 [10:44:08.904] jstate = 0x0 [10:44:08.904] is_matview = true [10:44:08.904] do_refresh = false [10:44:08.904] dest = [10:44:08.904] address = {classId = 1259, objectId = 28632, objectSubId = 0} [10:44:08.904] __func__ = "ExecCreateTableAs" [10:44:08.904] #10 0x00005564dbc55d91 in ProcessUtilitySlow (pstate=pstate@entry=0x5564f8730310, pstmt=pstmt@entry=0x5564f85718a0, queryString=queryString@entry=0x5564f8570ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x5564f85722d8, qc=0x7ffcd646b350) at ../src/backend/tcop/utility.c:1678 [10:44:08.904] _save_exception_stack = 0x7ffcd646b230 [10:44:08.904] _save_context_stack = 0x0 [10:44:08.904] _local_sigjmp_buf = {{__jmpbuf = {0, -2906702080305690894, 93892151547888, 0, 93892151544496, 0, -9036175815016085774, -2906766799992813838}, __mask_was_saved = 0, __saved_mask = {__val = {28636, 0, 93891675206347, 3000087776, 93892152653944, 0, 93891671989001, 0, 93891671649890, 140590313535872, 45170171052032, 140590172762020, 93891674675357, 10517, 93891671649890, 140590165075360}}}} [10:44:08.904] _do_rethrow = false [10:44:08.904] parsetree = 0x5564f85717f0 [10:44:08.904] isTopLevel = true [10:44:08.904] isCompleteQuery = true [10:44:08.904] needCleanup = false [10:44:08.904] commandCollected = false [10:44:08.904] address = {classId = 21860, objectId = 4166457328, objectSubId = 21860} [10:44:08.904] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [10:44:08.904] __func__ = "ProcessUtilitySlow" [10:44:08.904] #11 0x00005564dbc543a2 in standard_ProcessUtility (pstmt=0x5564f85718a0, queryString=0x5564f8570ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5564f85722d8, qc=0x7ffcd646b350) at ../src/backend/tcop/utility.c:1070 [10:44:08.904] parsetree = 0x5564f85717f0 [10:44:08.904] isTopLevel = true [10:44:08.904] isAtomicContext = false [10:44:08.904] pstate = 0x5564f8730310 [10:44:08.904] readonly_flags = [10:44:08.904] __func__ = "standard_ProcessUtility" [10:44:08.904] #12 0x00005564dbc544fd in ProcessUtility (pstmt=pstmt@entry=0x5564f85718a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5564f85722d8, qc=0x7ffcd646b350) at ../src/backend/tcop/utility.c:523 [10:44:08.904] No locals. [10:44:08.904] #13 0x00005564dbc4febb in PortalRunUtility (portal=portal@entry=0x5564f85f5fc0, pstmt=pstmt@entry=0x5564f85718a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5564f85722d8, qc=qc@entry=0x7ffcd646b350) at ../src/backend/tcop/pquery.c:1152 [10:44:08.904] No locals. [10:44:08.904] #14 0x00005564dbc50460 in PortalRunMulti (portal=portal@entry=0x5564f85f5fc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5564f85722d8, altdest=altdest@entry=0x5564f85722d8, qc=qc@entry=0x7ffcd646b350) at ../src/backend/tcop/pquery.c:1309 [10:44:08.904] pstmt = 0x5564f85718a0 [10:44:08.904] stmtlist_item__state = [10:44:08.904] active_snapshot_set = false [10:44:08.904] stmtlist_item = 0x5564f85722a0 [10:44:08.904] #15 0x00005564dbc509c8 in PortalRun (portal=portal@entry=0x5564f85f5fc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5564f85722d8, altdest=altdest@entry=0x5564f85722d8, qc=qc@entry=0x7ffcd646b350) at ../src/backend/tcop/pquery.c:787 [10:44:08.904] _save_exception_stack = 0x7ffcd646b400 [10:44:08.904] _save_context_stack = 0x0 [10:44:08.904] _local_sigjmp_buf = {{__jmpbuf = {0, -2906702079969097998, 93892152090560, 93892151548008, 93892151547984, 93892151547936, -9036175814617626894, -2906766797464303886}, __mask_was_saved = 0, __saved_mask = {__val = {93891675206347, 3594957535, 4, 93892151547936, 112, 73, 93892152090560, 93892151548008, 93892151547984, 93892151547936, 93891675293550, 1, 2, 73, 93891664542202, 0}}}} [10:44:08.904] _do_rethrow = [10:44:08.904] result = [10:44:08.904] nprocessed = [10:44:08.904] saveTopTransactionResourceOwner = 0x5564f85b3d88 [10:44:08.904] saveTopTransactionContext = 0x5564f86083f0 [10:44:08.904] saveActivePortal = 0x0 [10:44:08.904] saveResourceOwner = 0x5564f85b3d88 [10:44:08.904] savePortalContext = 0x0 [10:44:08.904] saveMemoryContext = 0x5564f86083f0 [10:44:08.904] __func__ = "PortalRun" [10:44:08.904] #16 0x00005564dbc49e80 in exec_simple_query (query_string=query_string@entry=0x5564f8570ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [10:44:08.904] cmdtaglen = 24 [10:44:08.904] snapshot_set = [10:44:08.904] per_parsetree_context = 0x0 [10:44:08.904] plantree_list = 0x5564f8572288 [10:44:08.904] parsetree = 0x5564f8571820 [10:44:08.904] commandTag = [10:44:08.904] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:44:08.904] querytree_list = [10:44:08.904] portal = 0x5564f85f5fc0 [10:44:08.904] receiver = 0x5564f85722d8 [10:44:08.904] format = 0 [10:44:08.904] cmdtagname = [10:44:08.904] parsetree_item__state = [10:44:08.904] dest = DestRemote [10:44:08.904] oldcontext = 0x5564f86083f0 [10:44:08.904] parsetree_list = 0x5564f8571850 [10:44:08.904] parsetree_item = 0x5564f8571868 [10:44:08.904] save_log_statement_stats = false [10:44:08.904] was_logged = false [10:44:08.904] use_implicit_block = false [10:44:08.904] msec_str = "\004\000\000\000\000\000\000\000\030\315\360\333dU\000\000\340\263F\326\374\177\000\000G\000\000\000\000\000\000" [10:44:08.904] __func__ = "exec_simple_query" [10:44:08.904] #17 0x00005564dbc4cbd9 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [10:44:08.904] query_string = 0x5564f8570ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [10:44:08.904] firstchar = [10:44:08.904] input_message = {data = 0x5564f8570ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [10:44:08.904] local_sigjmp_buf = {{__jmpbuf = {93891688064344, -2906765592042305806, 140723903444316, 4, 3, 140723903444548, -9036175814550518030, -2906766812672981262}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93892151274960, 17408, 93891688058400, 93892151809328, 3, 93891675205895, 0, 10, 2, 93891688064352, 93892151274960, 93891688058400, 4, 3, 140723903444548}}}} [10:44:08.904] send_ready_for_query = false [10:44:08.904] idle_in_transaction_timeout_enabled = false [10:44:08.904] idle_session_timeout_enabled = false [10:44:08.904] __func__ = "PostgresMain" [10:44:08.904] #18 0x00005564dbc42c44 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:44:08.904] bsdata = [10:44:08.904] #19 0x00005564dbaf3a08 in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x7ffcd646b55c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcd646b5b0) at ../src/backend/postmaster/launch_backend.c:274 [10:44:08.904] pid = [10:44:08.904] #20 0x00005564dbaf8c03 in BackendStartup (client_sock=client_sock@entry=0x7ffcd646b5b0) at ../src/backend/postmaster/postmaster.c:3519 [10:44:08.904] bn = 0x5564f8599088 [10:44:08.904] pid = [10:44:08.904] startup_data = {canAcceptConnections = CAC_OK} [10:44:08.904] cac = [10:44:08.904] __func__ = "BackendStartup" [10:44:08.904] #21 0x00005564dbafacd3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [10:44:08.904] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\273g\307\332dU\000\000\020H\303\332dU\000\000\000\267F\326\374\177\000\000\370\266F\326\374\177\000\000\225[\362\001\000\000\000\000\240\244\003\277\335\177\000\000+", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h\026\021\300\335\177\000\0000\246\003\277\335\177\000\000\340\022\021\300\335\177\000\000\316)fR\000\000\000", __ss_align = 3594958656}, salen = 2}} [10:44:08.904] i = 0 [10:44:08.904] now = [10:44:08.904] last_lockfile_recheck_time = 1737887922 [10:44:08.904] last_touch_time = 1737887922 [10:44:08.904] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -1072622880, user_data = 0x0}, {pos = -700008576, events = 32764, fd = -1072793016, user_data = 0xf}, {pos = -1090279888, events = 32733, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1072622880, user_data = 0x7ffcd646b6f8}, {pos = -700008704, events = 32764, fd = -1072621976, user_data = 0x0}, {pos = -128513168, events = 21860, fd = -1098155382, user_data = 0x5564f8570b70}, {pos = 1, events = 21860, fd = 32768, user_data = 0xffffffff}, {pos = -1098719200, events = 32733, fd = -1076695136, user_data = 0x5564f859e3f8}, {pos = -128326952, events = 21860, fd = -128327503, user_data = 0x7fddc00edebe}, {pos = 1, events = 0, fd = -1072622880, user_data = 0x1ab}, {pos = -599106216, events = 21860, fd = 0, user_data = 0xf9}, {pos = -128513168, events = 21860, fd = -1072767298, user_data = 0x1}, {pos = 0, events = 0, fd = -1098719200, user_data = 0x7fddbe8f2e40 }, {pos = 16, events = 0, fd = -700007568, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fddc00f01ba}, {pos = 0, events = 0, fd = -1098191452, user_data = 0x0}, {pos = -592069280, events = 21860, fd = 2, user_data = 0x0}, {pos = -128766352, events = 21860, fd = -608322736, user_data = 0x5564f85a34d0}, {pos = -608318747, events = 21860, fd = -128305877, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1098685240, user_data = 0x7fddbe89c880 }, {pos = -1090306632, events = 32733, fd = -700007376, user_data = 0x100007f00000002}, {pos = -1098157971, events = 32733, fd = 2, user_data = 0x5564f85a34d0}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -1096868768, events = 32733, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1630762836, fd = 168452953, user_data = 0x38373337310a6174}, {pos = 842610488, events = 808716850, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -128331600, events = 21860, fd = 1080, user_data = 0x5564f859e0d0}, {pos = -604853750, events = 21860, fd = 1024, user_data = 0x7fddbe8b58be}, {pos = -1096885792, events = 32733, fd = -1098247826, user_data = 0x100000400}, {pos = 7, events = 0, fd = -128326432, user_data = 0x4f5a0a433ab90c00}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5564f859e0d0}, {pos = 1, events = 0, fd = -128327272, user_data = 0x3}, {pos = 0, events = 0, fd = 25557, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -128513168, user_data = 0x7fddbe8f3053 }, {pos = -128327272, events = 21860, fd = 1024, user_data = 0x7ffcd646bc38}, {pos = -604772610, events = 21860, fd = -591993584, user_data = 0x5564dbf2d1bb }, {pos = -128327472, events = 21860, fd = -128513616, user_data = 0x5564f859e0d0}, {pos = -1098164034, events = 32733, fd = 0, user_data = 0x5564dbf3ee25 }, {pos = -128327472, events = 1, fd = -604770450, user_data = 0x5564f85709b0}, {pos = 985205760, events = 1331300931, fd = 0, user_data = 0x7fddbe8a2ab1}, {pos = -1098246928, events = 32733, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -128766352, user_data = 0x4f5a0a433ab90c00}, {pos = 0, events = 0, fd = 985205760, user_data = 0xc}, {pos = 985205760, events = 1331300931, fd = 0, user_data = 0x7fddbe85b239 }, {pos = 250, events = 0, fd = -609274107, user_data = 0x400000}, {pos = 0, events = 0, fd = -128766352, user_data = 0x5564dbf2d04f }, {pos = -128679712, events = 21860, fd = -128513616, user_data = 0x5564f85480e0}, {pos = 1, events = 0, fd = 0, user_data = 0x5564dbeeb854 }, {pos = 12, events = 0, fd = -128336136, user_data = 0x5564f859bed8}, {pos = -592067872, events = 21860, fd = 296, user_data = 0x5564dbaf5f1f }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -609257742, events = 21860, fd = -595689392, user_data = 0x5564f8571388}} [10:44:08.904] nevents = 1 [10:44:08.904] __func__ = "ServerLoop" [10:44:08.904] #22 0x00005564dbafc532 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5564f852ed30) at ../src/backend/postmaster/postmaster.c:1386 [10:44:08.904] opt = [10:44:08.904] status = [10:44:08.904] userDoption = [10:44:08.904] listen_addr_saved = false [10:44:08.904] output_config_variable = [10:44:08.904] __func__ = "PostmasterMain" [10:44:08.904] #23 0x00005564db9311aa in main (argc=8, argv=0x5564f852ed30) at ../src/backend/main/main.c:230 [10:44:08.904] do_check_root = [10:44:08.904] dispatch_option = [10:44:08.940] -e [10:44:08.940] [10:44:08.940] [10:44:09.001] dumping /tmp/cores/postgres-6-29979.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:44:09.250] [New LWP 29979] [10:44:09.250] [10:44:09.250] This GDB supports auto-downloading debuginfo from the following URLs: [10:44:09.250] [10:44:09.250] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [10:44:09.250] Debuginfod has been disabled. [10:44:09.250] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [10:44:09.356] [Thread debugging using libthread_db enabled] [10:44:09.356] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [10:44:09.356] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [10:44:09.356] Program terminated with signal SIGABRT, Aborted. [10:44:09.356] #0 0x00007f0bfa2a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:10.248] [10:44:10.248] Thread 1 (Thread 0x7f0bfaa33f00 (LWP 29979)): [10:44:10.248] #0 0x00007f0bfa2a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:10.248] No symbol table info available. [10:44:10.248] #1 0x00007f0bfa25afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:10.248] No symbol table info available. [10:44:10.248] #2 0x00007f0bfa245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:10.248] No symbol table info available. [10:44:10.248] #3 0x0000556462e82eea in ExceptionalCondition (conditionName=conditionName@entry=0x55646310095d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5564630ffeb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [10:44:10.248] No locals. [10:44:10.248] #4 0x00005564627edfbf in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55647c2ba2b0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [10:44:10.248] estate = 0x55647c0f7920 [10:44:10.248] oldcontext = 0x55647c211050 [10:44:10.248] __func__ = "standard_ExecutorStart" [10:44:10.248] #5 0x00005564627ee19b in ExecutorStart (queryDesc=queryDesc@entry=0x55647c2ba2b0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [10:44:10.248] No locals. [10:44:10.248] #6 0x000055646270d76c in refresh_matview_datafill (dest=0x55647c26e720, query=, query@entry=0x55647c2105a0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [10:44:10.248] rewritten = [10:44:10.248] plan = 0x55647c2b9908 [10:44:10.248] queryDesc = 0x55647c2ba2b0 [10:44:10.248] copied_query = [10:44:10.248] processed = [10:44:10.248] __func__ = "refresh_matview_datafill" [10:44:10.248] #7 0x000055646270fac6 in RefreshMatViewByOid (matviewOid=28614, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [10:44:10.248] dest = [10:44:10.248] matviewRel = 0x7f0beeaa53f0 [10:44:10.248] rule = [10:44:10.248] actions = [10:44:10.248] dataQuery = 0x55647c2105a0 [10:44:10.248] tableSpace = [10:44:10.248] relowner = 10 [10:44:10.248] OIDNewHeap = 28621 [10:44:10.248] processed = 0 [10:44:10.248] relpersistence = 112 'p' [10:44:10.248] save_userid = 10 [10:44:10.248] save_sec_context = 0 [10:44:10.248] save_nestlevel = 2 [10:44:10.248] address = {classId = 0, objectId = 0, objectSubId = 0} [10:44:10.248] __func__ = "RefreshMatViewByOid" [10:44:10.248] #8 0x000055646270fc05 in ExecRefreshMatView (stmt=0x55647c26e3f8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [10:44:10.248] matviewOid = [10:44:10.248] lockmode = [10:44:10.248] #9 0x00005564626c56d9 in ExecCreateTableAs (pstate=pstate@entry=0x55647c211150, stmt=stmt@entry=0x55647c099b60, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcc8ecc000) at ../src/backend/commands/createas.c:351 [10:44:10.248] refresh = [10:44:10.248] query = 0x55647c099d20 [10:44:10.248] into = 0x55647c0998b8 [10:44:10.248] jstate = 0x0 [10:44:10.248] is_matview = true [10:44:10.248] do_refresh = false [10:44:10.248] dest = [10:44:10.248] address = {classId = 1259, objectId = 28614, objectSubId = 0} [10:44:10.248] __func__ = "ExecCreateTableAs" [10:44:10.248] #10 0x0000556462bf1d91 in ProcessUtilitySlow (pstate=pstate@entry=0x55647c211150, pstmt=pstmt@entry=0x55647c099c10, queryString=queryString@entry=0x55647c098e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x55647c09a648, qc=0x7ffcc8ecc000) at ../src/backend/tcop/utility.c:1678 [10:44:10.248] _save_exception_stack = 0x7ffcc8ecbee0 [10:44:10.248] _save_context_stack = 0x0 [10:44:10.248] _local_sigjmp_buf = {{__jmpbuf = {0, -7501529664728211411, 93890066094944, 0, 93890066091552, 0, -4407793365856165843, -7501576483353403347}, __mask_was_saved = 0, __saved_mask = {__val = {28618, 0, 93889645066457, 139689426369976, 93890066091552, 93889647431699, 93889657603010, 93889657603136, 140723679444228, 93889647626553, 93889657603025, 93889657603136, 140723679444260, 93889647626568, 93889657603136, 0}}}} [10:44:10.248] _do_rethrow = false [10:44:10.248] parsetree = 0x55647c099b60 [10:44:10.248] isTopLevel = true [10:44:10.248] isCompleteQuery = true [10:44:10.248] needCleanup = false [10:44:10.248] commandCollected = false [10:44:10.248] address = {classId = 21860, objectId = 2081004384, objectSubId = 21860} [10:44:10.248] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [10:44:10.248] __func__ = "ProcessUtilitySlow" [10:44:10.248] #11 0x0000556462bf03a2 in standard_ProcessUtility (pstmt=0x55647c099c10, queryString=0x55647c098e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55647c09a648, qc=0x7ffcc8ecc000) at ../src/backend/tcop/utility.c:1070 [10:44:10.248] parsetree = 0x55647c099b60 [10:44:10.248] isTopLevel = true [10:44:10.248] isAtomicContext = false [10:44:10.248] pstate = 0x55647c211150 [10:44:10.248] readonly_flags = [10:44:10.248] __func__ = "standard_ProcessUtility" [10:44:10.248] #12 0x0000556462bf04fd in ProcessUtility (pstmt=pstmt@entry=0x55647c099c10, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55647c09a648, qc=0x7ffcc8ecc000) at ../src/backend/tcop/utility.c:523 [10:44:10.248] No locals. [10:44:10.248] #13 0x0000556462bebebb in PortalRunUtility (portal=portal@entry=0x55647c11ddb0, pstmt=pstmt@entry=0x55647c099c10, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55647c09a648, qc=qc@entry=0x7ffcc8ecc000) at ../src/backend/tcop/pquery.c:1152 [10:44:10.248] No locals. [10:44:10.248] #14 0x0000556462bec460 in PortalRunMulti (portal=portal@entry=0x55647c11ddb0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55647c09a648, altdest=altdest@entry=0x55647c09a648, qc=qc@entry=0x7ffcc8ecc000) at ../src/backend/tcop/pquery.c:1309 [10:44:10.248] pstmt = 0x55647c099c10 [10:44:10.248] stmtlist_item__state = [10:44:10.248] active_snapshot_set = false [10:44:10.248] stmtlist_item = 0x55647c09a610 [10:44:10.248] #15 0x0000556462bec9c8 in PortalRun (portal=portal@entry=0x55647c11ddb0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55647c09a648, altdest=altdest@entry=0x55647c09a648, qc=qc@entry=0x7ffcc8ecc000) at ../src/backend/tcop/pquery.c:787 [10:44:10.248] _save_exception_stack = 0x7ffcc8ecc0b0 [10:44:10.248] _save_context_stack = 0x0 [10:44:10.248] _local_sigjmp_buf = {{__jmpbuf = {0, -7501529665071095763, 93890066636208, 93890066095064, 93890066095040, 93890066094992, -4407793365986189267, -7501576489902415827}, __mask_was_saved = 0, __saved_mask = {__val = {93889644753611, 3370958735, 4, 93890066094992, 112, 73, 93890066636208, 93890066095064, 93890066095040, 93890066094992, 93889644840814, 1, 2, 73, 93889634089466, 0}}}} [10:44:10.248] _do_rethrow = [10:44:10.248] result = [10:44:10.248] nprocessed = [10:44:10.248] saveTopTransactionResourceOwner = 0x55647c0da868 [10:44:10.248] saveTopTransactionContext = 0x55647c12fdd0 [10:44:10.248] saveActivePortal = 0x0 [10:44:10.248] saveResourceOwner = 0x55647c0da868 [10:44:10.248] savePortalContext = 0x0 [10:44:10.248] saveMemoryContext = 0x55647c12fdd0 [10:44:10.248] __func__ = "PortalRun" [10:44:10.248] #16 0x0000556462be5e80 in exec_simple_query (query_string=query_string@entry=0x55647c098e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [10:44:10.248] cmdtaglen = 24 [10:44:10.248] snapshot_set = [10:44:10.248] per_parsetree_context = 0x0 [10:44:10.248] plantree_list = 0x55647c09a5f8 [10:44:10.248] parsetree = 0x55647c099b90 [10:44:10.248] commandTag = [10:44:10.248] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:44:10.248] querytree_list = [10:44:10.248] portal = 0x55647c11ddb0 [10:44:10.248] receiver = 0x55647c09a648 [10:44:10.248] format = 0 [10:44:10.248] cmdtagname = [10:44:10.248] parsetree_item__state = [10:44:10.248] dest = DestRemote [10:44:10.248] oldcontext = 0x55647c12fdd0 [10:44:10.248] parsetree_list = 0x55647c099bc0 [10:44:10.248] parsetree_item = 0x55647c099bd8 [10:44:10.248] save_log_statement_stats = false [10:44:10.248] was_logged = true [10:44:10.248] use_implicit_block = false [10:44:10.248] msec_str = "\004\000\000\000\000\000\000\000\030\215\352bdU\000\000\220\300\354\310\374\177\000\000G\000\000\000\000\000\000" [10:44:10.248] __func__ = "exec_simple_query" [10:44:10.248] #17 0x0000556462be8bd9 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [10:44:10.248] query_string = 0x55647c098e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [10:44:10.248] firstchar = [10:44:10.248] input_message = {data = 0x55647c098e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [10:44:10.248] local_sigjmp_buf = {{__jmpbuf = {93889657611608, -7501578670550425555, 140723679445516, 4, 17, 140723679445748, -4407793366053298131, -7501576487578378195}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93890065821216, 16128, 93889657605664, 93890066356256, 17, 93889644753159, 0, 9, 2, 93889657611616, 93890065821216, 93889657605664, 4, 17, 140723679445748}}}} [10:44:10.248] send_ready_for_query = false [10:44:10.248] idle_in_transaction_timeout_enabled = false [10:44:10.248] idle_session_timeout_enabled = false [10:44:10.248] __func__ = "PostgresMain" [10:44:10.248] #18 0x0000556462bdec44 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:44:10.248] bsdata = [10:44:10.248] #19 0x0000556462a8fa08 in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7ffcc8ecc20c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcc8ecc260) at ../src/backend/postmaster/launch_backend.c:274 [10:44:10.248] pid = [10:44:10.248] #20 0x0000556462a94c03 in BackendStartup (client_sock=client_sock@entry=0x7ffcc8ecc260) at ../src/backend/postmaster/postmaster.c:3519 [10:44:10.248] bn = 0x55647c0c1618 [10:44:10.248] pid = [10:44:10.248] startup_data = {canAcceptConnections = CAC_OK} [10:44:10.248] cac = [10:44:10.248] __func__ = "BackendStartup" [10:44:10.248] #21 0x0000556462a96cd3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [10:44:10.248] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\354\310\374\177\000\000\364\302\354\310\374\177", '\000' , "\273'\301adU\000\000\020\b\275adU\000\000\300\303\354\310\374\177\000\000\270\303\354\310\374\177\000\000\225[\362\001\000\000\000\000\240t\b\373\v\177\000\000+", '\000' , "\311&\301adU\000\000h\366\267\373\v\177\000\0000v\b\373\v\177\000", __ss_align = 139689444504288}, salen = 2}} [10:44:10.248] i = 0 [10:44:10.248] now = [10:44:10.248] last_lockfile_recheck_time = 1737887924 [10:44:10.248] last_touch_time = 1737887924 [10:44:10.248] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = -71829912, user_data = 0x0}, {pos = -71830816, events = 32523, fd = 2090263927, user_data = 0x7ffcc8ecc440}, {pos = -72000952, events = 32523, fd = 15, user_data = 0x7f0bfb087630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -71830816, events = 32523, fd = -924007496, user_data = 0x7ffcc8ecc3c0}, {pos = -71829912, events = 32523, fd = 0, user_data = 0x55647c098e38}, {pos = 1659982171, events = 21860, fd = 32768, user_data = 0x1}, {pos = 2081008336, events = 21860, fd = -1, user_data = 0x7f0bfa22e020}, {pos = -76058720, events = 32523, fd = 2081186600, user_data = 0x55647c0c6208}, {pos = 2081185761, events = 21860, fd = -71975234, user_data = 0x1}, {pos = -71830816, events = 32523, fd = 427, user_data = 0x556463441d58 }, {pos = 0, events = 0, fd = 229, user_data = 0x55647c098e38}, {pos = -71975234, events = 32523, fd = 1, user_data = 0x0}, {pos = -98377696, events = 32523, fd = -97571264, user_data = 0x10}, {pos = -924006368, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -71966278, user_data = 0x0}, {pos = -97849948, events = 32523, fd = 0, user_data = 0x556463af7d60 }, {pos = 2, events = 0, fd = 0, user_data = 0x55647c05aec0}, {pos = 1656195813, events = 21860, fd = 2081208347, user_data = 0x556462b7c71e }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55647c098e38}, {pos = -71975234, events = 32523, fd = 1, user_data = 0x0}, {pos = -98343736, events = 32523, fd = -97924992, user_data = 0x444}, {pos = -97816467, events = 32523, fd = 2, user_data = 0x55647c0cb7c0}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -96527264, events = 32523, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55647c0c6000}, {pos = 1659660810, events = 21860, fd = 1024, user_data = 0x7f0bfa2b58be}, {pos = -96544288, events = 32523, fd = -97906322, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2081186832, user_data = 0xdf7ced107568ab00}, {pos = -96541216, events = 32523, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2081185992, user_data = 0x3}, {pos = 0, events = 0, fd = 26159, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2081001016, user_data = 0x7f0bfa2f3053 }, {pos = 2081185992, events = 21860, fd = 1024, user_data = 0x7ffcc8ecc8e8}, {pos = 1659741950, events = 21860, fd = 1672520976, user_data = 0x556462ec91bb }, {pos = 2081185792, events = 21860, fd = 2081000736, user_data = 0x55647c0c6000}, {pos = -97822530, events = 32523, fd = 0, user_data = 0x556462edae25 }, {pos = 2081185792, events = 1, fd = 1659744110, user_data = 0x55647c098d20}, {pos = 1969793792, events = 3749506320, fd = 0, user_data = 0x7f0bfa2a2ab1}, {pos = -97905424, events = 32523, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2080747200, user_data = 0xdf7ced107568ab00}, {pos = 0, events = 0, fd = 1969793792, user_data = 0xc}, {pos = 1969793792, events = 3749506320, fd = 0, user_data = 0x7f0bfa25b239 }, {pos = 230, events = 0, fd = 1655240453, user_data = 0x400000}, {pos = 0, events = 0, fd = 2080747200, user_data = 0x556462ec904f }, {pos = 2080834640, events = 21860, fd = 2081000736, user_data = 0x55647c070450}, {pos = 1, events = 0, fd = 0, user_data = 0x556462e87854 }, {pos = 12, events = 0, fd = 2081177128, user_data = 0x55647c0c3e08}, {pos = 1672446688, events = 21860, fd = 296, user_data = 0x556462a91f1f }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1655256818, events = 21860, fd = 1668825168, user_data = 0x55647c0996c8}} [10:44:10.248] nevents = 1 [10:44:10.248] __func__ = "ServerLoop" [10:44:10.248] #22 0x0000556462a98532 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55647c056d30) at ../src/backend/postmaster/postmaster.c:1386 [10:44:10.248] opt = [10:44:10.248] status = [10:44:10.248] userDoption = [10:44:10.248] listen_addr_saved = false [10:44:10.248] output_config_variable = [10:44:10.248] __func__ = "PostmasterMain" [10:44:10.248] #23 0x00005564628cd1aa in main (argc=4, argv=0x55647c056d30) at ../src/backend/main/main.c:230 [10:44:10.248] do_check_root = [10:44:10.248] dispatch_option = [10:44:10.281] -e [10:44:10.281] [10:44:10.281] [10:44:10.342] dumping /tmp/cores/postgres-6-37081.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:44:10.595] [New LWP 37081] [10:44:10.595] [10:44:10.595] This GDB supports auto-downloading debuginfo from the following URLs: [10:44:10.595] [10:44:10.595] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [10:44:10.595] Debuginfod has been disabled. [10:44:10.595] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [10:44:10.703] [Thread debugging using libthread_db enabled] [10:44:10.703] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [10:44:10.703] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [10:44:10.703] Program terminated with signal SIGABRT, Aborted. [10:44:10.703] #0 0x00007f6f168a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:11.606] [10:44:11.606] Thread 1 (Thread 0x7f6f17033f00 (LWP 37081)): [10:44:11.606] #0 0x00007f6f168a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:11.606] No symbol table info available. [10:44:11.606] #1 0x00007f6f1685afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:11.606] No symbol table info available. [10:44:11.606] #2 0x00007f6f16845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [10:44:11.606] No symbol table info available. [10:44:11.606] #3 0x000055a84382aeea in ExceptionalCondition (conditionName=conditionName@entry=0x55a843aa895d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55a843aa7eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [10:44:11.606] No locals. [10:44:11.606] #4 0x000055a843195fbf in standard_ExecutorStart (queryDesc=0x55a8781e5130, eflags=0) at ../src/backend/executor/execMain.c:193 [10:44:11.606] estate = 0x55a8780207c0 [10:44:11.606] oldcontext = 0x55a878135230 [10:44:11.606] __func__ = "standard_ExecutorStart" [10:44:11.606] #5 0x00007f6f13ef06e9 in pgss_ExecutorStart (queryDesc=0x55a8781e5130, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [10:44:11.606] No locals. [10:44:11.606] #6 0x000055a843196154 in ExecutorStart (queryDesc=queryDesc@entry=0x55a8781e5130, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [10:44:11.606] No locals. [10:44:11.606] #7 0x000055a8430b576c in refresh_matview_datafill (dest=0x55a878106bb0, query=, query@entry=0x55a8781598a0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [10:44:11.606] rewritten = [10:44:11.606] plan = 0x55a8781e4758 [10:44:11.606] queryDesc = 0x55a8781e5130 [10:44:11.606] copied_query = [10:44:11.606] processed = [10:44:11.606] __func__ = "refresh_matview_datafill" [10:44:11.606] #8 0x000055a8430b7ac6 in RefreshMatViewByOid (matviewOid=28452, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [10:44:11.606] dest = [10:44:11.606] matviewRel = 0x7f6f121ed8c0 [10:44:11.606] rule = [10:44:11.606] actions = [10:44:11.606] dataQuery = 0x55a8781598a0 [10:44:11.606] tableSpace = [10:44:11.606] relowner = 10 [10:44:11.606] OIDNewHeap = 28471 [10:44:11.606] processed = 0 [10:44:11.606] relpersistence = 112 'p' [10:44:11.606] save_userid = 10 [10:44:11.606] save_sec_context = 0 [10:44:11.606] save_nestlevel = 2 [10:44:11.606] address = {classId = 0, objectId = 0, objectSubId = 0} [10:44:11.606] __func__ = "RefreshMatViewByOid" [10:44:11.606] #9 0x000055a8430b7c05 in ExecRefreshMatView (stmt=0x55a878106888, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [10:44:11.606] matviewOid = [10:44:11.606] lockmode = [10:44:11.606] #10 0x000055a84306d6d9 in ExecCreateTableAs (pstate=pstate@entry=0x55a878135330, stmt=stmt@entry=0x55a877fc5b80, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcb6ecb040) at ../src/backend/commands/createas.c:351 [10:44:11.606] refresh = [10:44:11.606] query = 0x55a877fc5d40 [10:44:11.606] into = 0x55a877fc58d8 [10:44:11.606] jstate = 0x0 [10:44:11.606] is_matview = true [10:44:11.606] do_refresh = false [10:44:11.606] dest = [10:44:11.606] address = {classId = 1259, objectId = 28452, objectSubId = 0} [10:44:11.606] __func__ = "ExecCreateTableAs" [10:44:11.606] #11 0x000055a843599d91 in ProcessUtilitySlow (pstate=pstate@entry=0x55a878135330, pstmt=pstmt@entry=0x55a877fc5c30, queryString=queryString@entry=0x55a877fc4e40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x55a877fc6bd8, qc=0x7ffcb6ecb040) at ../src/backend/tcop/utility.c:1678 [10:44:11.606] _save_exception_stack = 0x7ffcb6ecac10 [10:44:11.606] _save_context_stack = 0x0 [10:44:11.606] _local_sigjmp_buf = {{__jmpbuf = {0, -3877440018635577401, 94182055893888, 0, 94182055890496, 0, -7018557682320169017, -3877324869266987065}, __mask_was_saved = 0, __saved_mask = {__val = {94181175603999, 140723377449296, 140115097096672, 5, 140723377449295, 1, 94182056570936, 94182055898272, 94182056562928, 140723377449296, 94181173013294, 1, 140723377450048, 0, 94181176096051, 140723377449244}}}} [10:44:11.606] _do_rethrow = false [10:44:11.606] parsetree = 0x55a877fc5b80 [10:44:11.606] isTopLevel = true [10:44:11.606] isCompleteQuery = true [10:44:11.606] needCleanup = false [10:44:11.606] commandCollected = false [10:44:11.606] address = {classId = 21928, objectId = 2013027200, objectSubId = 21928} [10:44:11.606] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [10:44:11.606] __func__ = "ProcessUtilitySlow" [10:44:11.606] #12 0x000055a8435983a2 in standard_ProcessUtility (pstmt=pstmt@entry=0x55a877fc5c30, queryString=queryString@entry=0x55a877fc4e40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=readOnlyTree@entry=false, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x55a877fc6bd8, qc=0x7ffcb6ecb040) at ../src/backend/tcop/utility.c:1070 [10:44:11.606] parsetree = 0x55a877fc5b80 [10:44:11.606] isTopLevel = true [10:44:11.606] isAtomicContext = false [10:44:11.606] pstate = 0x55a878135330 [10:44:11.606] readonly_flags = [10:44:11.606] __func__ = "standard_ProcessUtility" [10:44:11.606] #13 0x00007f6f13ef3d8f in pgss_ProcessUtility (pstmt=0x55a877fc5c30, queryString=0x55a877fc4e40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55a877fc6bd8, qc=0x7ffcb6ecb040) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [10:44:11.606] _save_exception_stack = 0x7ffcb6ecaf20 [10:44:11.606] _save_context_stack = 0x0 [10:44:11.606] _local_sigjmp_buf = {{__jmpbuf = {0, 7016747994912892871, 94182055894064, 94182055898072, 140723377451072, 0, -7018557682148202553, -6936008526099404857}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140723377450304, 94181176103750, 1, 206158430232, 94182055894864, 140723377450400, 0, 94181170864774, 94182055890240, 94181175763287, 3, 94181169587012, 94182055894064}}}} [10:44:11.606] _do_rethrow = false [10:44:11.606] duration = [10:44:11.606] bufusage = {shared_blks_hit = 1, shared_blks_read = 128, shared_blks_dirtied = 140115024936256, shared_blks_written = 140115024936256, local_blks_hit = 1, local_blks_read = 94181172237711, local_blks_dirtied = 94182056268936, local_blks_written = 94181176096985, temp_blks_read = 140115104185784, temp_blks_written = 94182055890496, shared_blk_read_time = {ticks = 94181178462227}, shared_blk_write_time = {ticks = 94181188633538}, local_blk_read_time = {ticks = 94181188633664}, local_blk_write_time = {ticks = 140723377450308}, temp_blk_read_time = {ticks = 94181178657081}, temp_blk_write_time = {ticks = 94181188633553}} [10:44:11.606] walusage_start = {wal_records = 8954, wal_fpi = 95, wal_bytes = 1063020} [10:44:11.606] start = [10:44:11.606] rows = [10:44:11.606] bufusage_start = {shared_blks_hit = 34585, shared_blks_read = 4100, shared_blks_dirtied = 1397, shared_blks_written = 1003, local_blks_hit = 45, local_blks_read = 0, local_blks_dirtied = 10, local_blks_written = 17, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [10:44:11.606] walusage = {wal_records = 140115028040320, wal_fpi = 549755813888, wal_bytes = 140115024936292} [10:44:11.606] parsetree = [10:44:11.606] saved_queryId = 7267788456574341698 [10:44:11.606] saved_stmt_location = 0 [10:44:11.606] saved_stmt_len = 69 [10:44:11.606] enabled = true [10:44:11.606] #14 0x000055a843598448 in ProcessUtility (pstmt=pstmt@entry=0x55a877fc5c30, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55a877fc6bd8, qc=0x7ffcb6ecb040) at ../src/backend/tcop/utility.c:519 [10:44:11.606] No locals. [10:44:11.606] #15 0x000055a843593ebb in PortalRunUtility (portal=portal@entry=0x55a878047d30, pstmt=pstmt@entry=0x55a877fc5c30, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55a877fc6bd8, qc=qc@entry=0x7ffcb6ecb040) at ../src/backend/tcop/pquery.c:1152 [10:44:11.606] No locals. [10:44:11.606] #16 0x000055a843594460 in PortalRunMulti (portal=portal@entry=0x55a878047d30, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55a877fc6bd8, altdest=altdest@entry=0x55a877fc6bd8, qc=qc@entry=0x7ffcb6ecb040) at ../src/backend/tcop/pquery.c:1309 [10:44:11.606] pstmt = 0x55a877fc5c30 [10:44:11.606] stmtlist_item__state = [10:44:11.606] active_snapshot_set = false [10:44:11.606] stmtlist_item = 0x55a877fc6ba0 [10:44:11.606] #17 0x000055a8435949c8 in PortalRun (portal=portal@entry=0x55a878047d30, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55a877fc6bd8, altdest=altdest@entry=0x55a877fc6bd8, qc=qc@entry=0x7ffcb6ecb040) at ../src/backend/tcop/pquery.c:787 [10:44:11.606] _save_exception_stack = 0x7ffcb6ecb0f0 [10:44:11.606] _save_context_stack = 0x0 [10:44:11.606] _local_sigjmp_buf = {{__jmpbuf = {0, -3877440018213001273, 94182056426800, 94182055894008, 94182055893984, 94182055893936, -7018557682041247801, -3877324871269111865}, __mask_was_saved = 0, __saved_mask = {__val = {94181175784139, 3068964815, 4, 94182055893936, 112, 73, 94182056426800, 94182055894008, 94182055893984, 94182055893936, 94181175871342, 1, 2, 73, 94181165119994, 0}}}} [10:44:11.606] _do_rethrow = [10:44:11.606] result = [10:44:11.606] nprocessed = [10:44:11.606] saveTopTransactionResourceOwner = 0x55a878009738 [10:44:11.606] saveTopTransactionContext = 0x55a87805a570 [10:44:11.606] saveActivePortal = 0x0 [10:44:11.606] saveResourceOwner = 0x55a878009738 [10:44:11.606] savePortalContext = 0x0 [10:44:11.606] saveMemoryContext = 0x55a87805a570 [10:44:11.606] __func__ = "PortalRun" [10:44:11.606] #18 0x000055a84358de80 in exec_simple_query (query_string=query_string@entry=0x55a877fc4e40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [10:44:11.606] cmdtaglen = 24 [10:44:11.606] snapshot_set = [10:44:11.606] per_parsetree_context = 0x0 [10:44:11.606] plantree_list = 0x55a877fc6b88 [10:44:11.606] parsetree = 0x55a877fc5bb0 [10:44:11.606] commandTag = [10:44:11.606] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:44:11.606] querytree_list = [10:44:11.606] portal = 0x55a878047d30 [10:44:11.606] receiver = 0x55a877fc6bd8 [10:44:11.606] format = 0 [10:44:11.606] cmdtagname = [10:44:11.606] parsetree_item__state = [10:44:11.606] dest = DestRemote [10:44:11.606] oldcontext = 0x55a87805a570 [10:44:11.606] parsetree_list = 0x55a877fc5be0 [10:44:11.606] parsetree_item = 0x55a877fc5bf8 [10:44:11.606] save_log_statement_stats = false [10:44:11.606] was_logged = true [10:44:11.606] use_implicit_block = false [10:44:11.606] msec_str = "\004\000\000\000\000\000\000\000\030\r\205C\250U\000\000а\354\266\374\177\000\000G\000\000\000\000\000\000" [10:44:11.606] __func__ = "exec_simple_query" [10:44:11.606] #19 0x000055a843590bd9 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [10:44:11.606] query_string = 0x55a877fc4e40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [10:44:11.606] firstchar = [10:44:11.606] input_message = {data = 0x55a877fc4e40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [10:44:11.606] local_sigjmp_buf = {{__jmpbuf = {94181188642136, -3877326916868921401, 140723377451596, 4, 17, 140723377451828, -7018557681974138937, -3877324873626703929}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94182056146656, 0, 168, 94181175784241, 0, 10, 2, 94181188642144, 94182055620192, 94181188636192, 4, 17, 140723377451828}}}} [10:44:11.606] send_ready_for_query = false [10:44:11.606] idle_in_transaction_timeout_enabled = false [10:44:11.606] idle_session_timeout_enabled = false [10:44:11.606] __func__ = "PostgresMain" [10:44:11.606] #20 0x000055a843586c44 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:44:11.606] bsdata = [10:44:11.606] #21 0x000055a843437a08 in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7ffcb6ecb24c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcb6ecb2a0) at ../src/backend/postmaster/launch_backend.c:274 [10:44:11.606] pid = [10:44:11.606] #22 0x000055a84343cc03 in BackendStartup (client_sock=client_sock@entry=0x7ffcb6ecb2a0) at ../src/backend/postmaster/postmaster.c:3519 [10:44:11.606] bn = 0x55a877ff0898 [10:44:11.606] pid = [10:44:11.606] startup_data = {canAcceptConnections = CAC_OK} [10:44:11.606] cac = [10:44:11.606] __func__ = "BackendStartup" [10:44:11.606] #23 0x000055a84343ecd3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [10:44:11.606] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\354\266\374\177\000\0004\263\354\266\374\177", '\000' , "\273\247[B\250U\000\000\020\210WB\250U\000\000\000\264\354\266\374\177\000\000\370\263\354\266\374\177\000\000\225[\362\001\000\000\000\000\240\372\376w\250U\000\000,", '\000' , "ɦ[B\250U\000\000h&\021\030o\177\000\0000\246\003\027o\177\000", __ss_align = 140115121873632}, salen = 2}} [10:44:11.606] i = 0 [10:44:11.606] now = [10:44:11.606] last_lockfile_recheck_time = 1737887959 [10:44:11.606] last_touch_time = 1737887959 [10:44:11.606] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 403777128, user_data = 0x0}, {pos = 403776224, events = 32623, fd = 2090263927, user_data = 0x7ffcb6ecb480}, {pos = 403606088, events = 32623, fd = 15, user_data = 0x7f6f1703a630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 403776224, events = 32623, fd = -1226001416, user_data = 0x7ffcb6ecb400}, {pos = 403777128, events = 32623, fd = 0, user_data = 0x55a877ff25a8}, {pos = 1133236571, events = 21928, fd = 32768, user_data = 0x1}, {pos = 2013026656, events = 21928, fd = -1, user_data = 0x7f6f1682e020}, {pos = 399703968, events = 32623, fd = 2013244472, user_data = 0x55a877ffab18}, {pos = 2013220865, events = 21928, fd = 403631806, user_data = 0x1}, {pos = 403776224, events = 32623, fd = 427, user_data = 0x55a843de9d58 }, {pos = 0, events = 0, fd = 86, user_data = 0x55a877ff25a8}, {pos = 403631806, events = 32623, fd = 1, user_data = 0x0}, {pos = 377675808, events = 32623, fd = 378482240, user_data = 0x10}, {pos = -1226000288, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 403640762, user_data = 0x0}, {pos = 378203556, events = 32623, fd = 0, user_data = 0x55a84449fd60 }, {pos = 2, events = 0, fd = 0, user_data = 0x55a877f86f00}, {pos = 1129450213, events = 21928, fd = 2013239643, user_data = 0x55a84352471e }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55a877ff25a8}, {pos = 403631806, events = 32623, fd = 1, user_data = 0x0}, {pos = 377709768, events = 32623, fd = 378128512, user_data = 0x444}, {pos = 378236679, events = 32623, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 379526240, events = 32623, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa64}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 386118976, user_data = 0x7f6f1703ba80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55a877ffa910}, {pos = 1132915210, events = 21928, fd = 1024, user_data = 0x7f6f168b576b}, {pos = 379509216, events = 32623, fd = 378147182, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2013239552, user_data = 0x425131143a162f00}, {pos = 379512288, events = 32623, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2013243864, user_data = 0x3}, {pos = 0, events = 0, fd = 32746, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2013210024, user_data = 0x7f6f168f3053 }, {pos = 2013243864, events = 21928, fd = 1024, user_data = 0x7ffcb6ecb928}, {pos = 1132996350, events = 21928, fd = 1145775376, user_data = 0x55a8438711bb }, {pos = 2013243664, events = 21928, fd = 2013023552, user_data = 0x55a877ffa910}, {pos = 378230635, events = 32623, fd = 0, user_data = 0x55a843882e25 }, {pos = 2013243664, events = 1, fd = 1132998510, user_data = 0x55a877fc4d40}, {pos = 974532352, events = 1112617236, fd = 0, user_data = 0x7f6f168a2ab1}, {pos = 378148080, events = 32623, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2012770048, user_data = 0x425131143a162f00}, {pos = 0, events = 0, fd = 974532352, user_data = 0xc}, {pos = 974532352, events = 1112617236, fd = 0, user_data = 0x7f6f1685b239 }, {pos = 87, events = 0, fd = 1128494853, user_data = 0x400000}, {pos = 0, events = 0, fd = 2012770048, user_data = 0x55a84387104f }, {pos = 2012857456, events = 21928, fd = 2013023552, user_data = 0x55a877f9c470}, {pos = 1, events = 0, fd = 0, user_data = 0x55a84382f854 }, {pos = 12, events = 0, fd = 2013205976, user_data = 0x55a877ff15b8}, {pos = 1145701088, events = 21928, fd = 296, user_data = 0x55a843439f1f }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1128511218, events = 21928, fd = 1142079568, user_data = 0x55a877fc56f8}} [10:44:11.606] nevents = 1 [10:44:11.606] __func__ = "ServerLoop" [10:44:11.606] #24 0x000055a843440532 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a877f82d60) at ../src/backend/postmaster/postmaster.c:1386 [10:44:11.606] opt = [10:44:11.606] status = [10:44:11.606] userDoption = [10:44:11.606] listen_addr_saved = false [10:44:11.606] output_config_variable = [10:44:11.606] __func__ = "PostmasterMain" [10:44:11.606] #25 0x000055a8432751aa in main (argc=4, argv=0x55a877f82d60) at ../src/backend/main/main.c:230 [10:44:11.606] do_check_root = [10:44:11.606] dispatch_option =