[08:35:16.200] src/tools/ci/cores_backtrace.sh linux /tmp/cores [08:35:16.413] dumping /tmp/cores/postgres-6-29807.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:35:16.660] [New LWP 29807] [08:35:16.660] [08:35:16.660] This GDB supports auto-downloading debuginfo from the following URLs: [08:35:16.660] [08:35:16.660] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:35:16.660] Debuginfod has been disabled. [08:35:16.660] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:35:16.790] [Thread debugging using libthread_db enabled] [08:35:16.790] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:35:16.790] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [08:35:16.790] Program terminated with signal SIGABRT, Aborted. [08:35:16.790] #0 0x00007fd3d58a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:17.686] [08:35:17.686] Thread 1 (Thread 0x7fd3d57d4f00 (LWP 29807)): [08:35:17.686] #0 0x00007fd3d58a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:17.686] No symbol table info available. [08:35:17.686] #1 0x00007fd3d585afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:17.686] No symbol table info available. [08:35:17.686] #2 0x00007fd3d5845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:17.686] No symbol table info available. [08:35:17.686] #3 0x000055f6af65b388 in ExceptionalCondition (conditionName=conditionName@entry=0x55f6af8cddad "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55f6af8cd290 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [08:35:17.686] No locals. [08:35:17.686] #4 0x000055f6aefe66f9 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55f6b22cf4d0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [08:35:17.686] estate = 0x55f6b22f4ac0 [08:35:17.686] oldcontext = 0x55f6b22d47e0 [08:35:17.686] __func__ = "standard_ExecutorStart" [08:35:17.686] #5 0x000055f6aefe68d5 in ExecutorStart (queryDesc=queryDesc@entry=0x55f6b22cf4d0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [08:35:17.686] No locals. [08:35:17.686] #6 0x000055f6aef0c844 in refresh_matview_datafill (dest=0x55f6b22b0728, query=, query@entry=0x55f6b227a980, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [08:35:17.686] rewritten = [08:35:17.686] plan = 0x55f6b22cea08 [08:35:17.686] queryDesc = 0x55f6b22cf4d0 [08:35:17.686] copied_query = [08:35:17.686] processed = [08:35:17.686] __func__ = "refresh_matview_datafill" [08:35:17.686] #7 0x000055f6aef0ebab in RefreshMatViewByOid (matviewOid=27387, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [08:35:17.686] dest = [08:35:17.686] matviewRel = 0x7fd3ca140b88 [08:35:17.686] rule = [08:35:17.686] actions = [08:35:17.686] dataQuery = 0x55f6b227a980 [08:35:17.686] tableSpace = [08:35:17.686] relowner = 10 [08:35:17.686] OIDNewHeap = 27400 [08:35:17.686] processed = 0 [08:35:17.686] relpersistence = 112 'p' [08:35:17.686] save_userid = 10 [08:35:17.686] save_sec_context = 0 [08:35:17.686] save_nestlevel = 2 [08:35:17.686] address = {classId = 0, objectId = 0, objectSubId = 0} [08:35:17.686] __func__ = "RefreshMatViewByOid" [08:35:17.686] #8 0x000055f6aef0ecea in ExecRefreshMatView (stmt=0x55f6b2304200, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [08:35:17.686] matviewOid = [08:35:17.686] lockmode = [08:35:17.686] #9 0x000055f6aeec569e in ExecCreateTableAs (pstate=pstate@entry=0x55f6b22d48e0, stmt=stmt@entry=0x55f6b216a770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe12521350) at ../src/backend/commands/createas.c:350 [08:35:17.686] refresh = [08:35:17.686] query = 0x55f6b216a930 [08:35:17.686] into = 0x55f6b216a4c8 [08:35:17.686] is_matview = true [08:35:17.686] do_refresh = false [08:35:17.686] dest = [08:35:17.686] address = {classId = 1259, objectId = 27387, objectSubId = 0} [08:35:17.686] __func__ = "ExecCreateTableAs" [08:35:17.686] #10 0x000055f6af3d56f4 in ProcessUtilitySlow (pstate=pstate@entry=0x55f6b22d48e0, pstmt=pstmt@entry=0x55f6b216a820, queryString=queryString@entry=0x55f6b2169a30 "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=0x55f6b216b258, qc=0x7ffe12521350) at ../src/backend/tcop/utility.c:1675 [08:35:17.686] _save_exception_stack = 0x7ffe12521210 [08:35:17.686] _save_context_stack = 0x0 [08:35:17.686] _local_sigjmp_buf = {{__jmpbuf = {0, -8446322776986114790, 94518038144880, 0, 94518038141488, 0, -2388628924336462566, -8446333457860942566}, __mask_was_saved = 0, __saved_mask = {__val = {4294980175, 140547610744320, 94517989763759, 1, 55317873276072, 1, 94517993583355, 140547796585912, 94518038141488, 94517995896805, 94518005826754, 94518005826880, 140729205788756, 94517996091416, 94518005826769, 94518005826880}}}} [08:35:17.686] _do_rethrow = false [08:35:17.686] parsetree = 0x55f6b216a770 [08:35:17.686] isTopLevel = true [08:35:17.686] isCompleteQuery = true [08:35:17.686] needCleanup = false [08:35:17.686] commandCollected = false [08:35:17.686] address = {classId = 22006, objectId = 2987829104, objectSubId = 22006} [08:35:17.686] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:35:17.686] __func__ = "ProcessUtilitySlow" [08:35:17.686] #11 0x000055f6af3d3d05 in standard_ProcessUtility (pstmt=0x55f6b216a820, queryString=0x55f6b2169a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55f6b216b258, qc=0x7ffe12521350) at ../src/backend/tcop/utility.c:1067 [08:35:17.686] parsetree = 0x55f6b216a770 [08:35:17.686] isTopLevel = true [08:35:17.686] isAtomicContext = false [08:35:17.686] pstate = 0x55f6b22d48e0 [08:35:17.686] readonly_flags = [08:35:17.686] __func__ = "standard_ProcessUtility" [08:35:17.686] #12 0x000055f6af3d3e60 in ProcessUtility (pstmt=pstmt@entry=0x55f6b216a820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55f6b216b258, qc=0x7ffe12521350) at ../src/backend/tcop/utility.c:523 [08:35:17.686] No locals. [08:35:17.686] #13 0x000055f6af3cf6cc in PortalRunUtility (portal=portal@entry=0x55f6b21ec680, pstmt=pstmt@entry=0x55f6b216a820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f6b216b258, qc=qc@entry=0x7ffe12521350) at ../src/backend/tcop/pquery.c:1158 [08:35:17.686] No locals. [08:35:17.686] #14 0x000055f6af3cfc71 in PortalRunMulti (portal=portal@entry=0x55f6b21ec680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f6b216b258, altdest=altdest@entry=0x55f6b216b258, qc=qc@entry=0x7ffe12521350) at ../src/backend/tcop/pquery.c:1316 [08:35:17.686] pstmt = 0x55f6b216a820 [08:35:17.686] stmtlist_item__state = [08:35:17.686] active_snapshot_set = false [08:35:17.686] stmtlist_item = 0x55f6b216b220 [08:35:17.686] #15 0x000055f6af3d0244 in PortalRun (portal=portal@entry=0x55f6b21ec680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55f6b216b258, altdest=altdest@entry=0x55f6b216b258, qc=0x7ffe12521350) at ../src/backend/tcop/pquery.c:791 [08:35:17.686] _save_exception_stack = 0x7ffe12521400 [08:35:17.686] _save_context_stack = 0x0 [08:35:17.686] _local_sigjmp_buf = {{__jmpbuf = {0, -8446322776649521894, 94518038677120, 94518038145000, 94518038677120, 94518038144928, -2388628924206439142, -8446333459939089126}, __mask_was_saved = 0, __saved_mask = {__val = {94517993268016, 94518038141232, 112, 4, 94517993272433, 307368671, 4, 94518038144928, 112, 73, 94518038677120, 94518038145000, 94518038144976, 94518038144928, 94517993359636, 1}}}} [08:35:17.686] _do_rethrow = [08:35:17.686] result = [08:35:17.686] nprocessed = [08:35:17.686] saveTopTransactionResourceOwner = 0x55f6b21a9838 [08:35:17.686] saveTopTransactionContext = 0x55f6b21fd660 [08:35:17.686] saveActivePortal = 0x0 [08:35:17.686] saveResourceOwner = 0x55f6b21a9838 [08:35:17.686] savePortalContext = 0x0 [08:35:17.686] saveMemoryContext = 0x55f6b21fd660 [08:35:17.686] __func__ = "PortalRun" [08:35:17.686] #16 0x000055f6af3c9630 in exec_simple_query (query_string=query_string@entry=0x55f6b2169a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [08:35:17.686] cmdtaglen = 24 [08:35:17.686] snapshot_set = [08:35:17.686] per_parsetree_context = 0x0 [08:35:17.686] plantree_list = 0x55f6b216b208 [08:35:17.686] parsetree = 0x55f6b216a7a0 [08:35:17.686] commandTag = [08:35:17.686] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:35:17.686] querytree_list = [08:35:17.686] portal = 0x55f6b21ec680 [08:35:17.686] receiver = 0x55f6b216b258 [08:35:17.686] format = 0 [08:35:17.686] cmdtagname = [08:35:17.686] parsetree_item__state = [08:35:17.686] dest = DestRemote [08:35:17.686] oldcontext = 0x55f6b21fd660 [08:35:17.686] parsetree_list = 0x55f6b216a7d0 [08:35:17.686] parsetree_item = 0x55f6b216a7e8 [08:35:17.686] save_log_statement_stats = false [08:35:17.686] was_logged = true [08:35:17.686] use_implicit_block = false [08:35:17.686] msec_str = "\260\025R\022\376\177\000\0006\021h\257\366U\000\000\340\023R\022\376\177\000\000G\000\000\000\000\000\000" [08:35:17.686] __func__ = "exec_simple_query" [08:35:17.686] #17 0x000055f6af3cc3b4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [08:35:17.686] query_string = 0x55f6b2169a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [08:35:17.686] firstchar = [08:35:17.686] input_message = {data = 0x55f6b2169a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [08:35:17.686] local_sigjmp_buf = {{__jmpbuf = {94518005835320, -8446318232973630182, 4, 140729205790128, 140729205790272, 140729205790276, -2388628924135135974, -8446333445137783526}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94518037872048, 14336, 94518005829408, 94518038398960, 140729205790272, 94517993271981, 0, 9, 2, 94518005835328, 94518037872048, 94518005829408, 140729205790128, 140729205790272, 140729205790276}}}} [08:35:17.686] send_ready_for_query = false [08:35:17.686] idle_in_transaction_timeout_enabled = false [08:35:17.686] idle_session_timeout_enabled = false [08:35:17.686] __func__ = "PostgresMain" [08:35:17.686] #18 0x000055f6af3c222b in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:35:17.686] bsdata = [08:35:17.686] #19 0x000055f6af279bca in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe1252155c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe125215b0) at ../src/backend/postmaster/launch_backend.c:274 [08:35:17.686] pid = [08:35:17.686] #20 0x000055f6af27f67e in BackendStartup (client_sock=client_sock@entry=0x7ffe125215b0) at ../src/backend/postmaster/postmaster.c:3420 [08:35:17.686] bn = 0x55f6b219e8e8 [08:35:17.686] pid = [08:35:17.686] startup_data = {canAcceptConnections = CAC_OK} [08:35:17.686] __func__ = "BackendStartup" [08:35:17.686] #21 0x000055f6af27fbe0 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [08:35:17.686] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\202\325\323\177\000\000t\026R\022\376\177\000\000\312p\027\327\323\177\000\000>\004\000\000\000\000\000\000\260\227\203\325\323\177\000\000\240\217\331\326\323\177\000\000x\026R\022\376\177\000\000t\026R\022\376\177\000\000\000\000\000\000\000\000\000\000\020\026R\022\376\177\000\000V\017D\256\366U\000\000\200\367?\256\366U\000\000@\027R\022\376\177\000\0008\027R\022\376\177\000\000\225[\362\001\000\000\000", __ss_align = 140547812013216}, salen = 2}} [08:35:17.686] i = 0 [08:35:17.686] now = [08:35:17.686] last_lockfile_recheck_time = 1727253089 [08:35:17.686] last_touch_time = 1727253089 [08:35:17.686] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7fd3d71a12e0}, {pos = 307369656, events = 0, fd = 0, user_data = 0x7fd3d71a1668}, {pos = -1371271338, events = 22006, fd = -686156184, user_data = 0x7fd3d668b630}, {pos = -686157088, events = 32723, fd = 2090263927, user_data = 0x7ffe125217c0}, {pos = -686327224, events = 32723, fd = 15, user_data = 0x7fd3d668b630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -686157088, events = 32723, fd = 307369784, user_data = 0x7ffe12521740}, {pos = -686156184, events = 32723, fd = 0, user_data = 0x55f6b2198368}, {pos = -1306951096, events = 22006, fd = -1306951647, user_data = 0x7fd300000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7fd3d582e020}, {pos = -690384992, events = 32723, fd = -1306950808, user_data = 0x7ffe12521b30}, {pos = -1306979640, events = 22006, fd = -1306950576, user_data = 0x55f6b2198368}, {pos = -686157088, events = 32723, fd = 438, user_data = 0x55f6afbf9db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55f6b2169a48}, {pos = -686301506, events = 32723, fd = 1, user_data = 0x0}, {pos = -712843232, events = 32723, fd = -712036928, user_data = 0x7ffe12521ba0}, {pos = 307370880, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -686292550, user_data = 0x0}, {pos = -712315612, events = 32723, fd = 0, user_data = 0x55f6b028afc0 }, {pos = 2, events = 0, fd = 7, user_data = 0x55f6b212be50}, {pos = 0, events = 0, fd = -712809272, user_data = 0x7fd3d589c880 }, {pos = -713208392, events = 32723, fd = 8096, user_data = 0x100007f00000002}, {pos = -712282489, events = 32723, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -710992800, events = 32723, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55f6b212be50}, {pos = -712279542, events = 32723, fd = 1663923061, user_data = 0x55f6b212be50}, {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 = 0x553974420a393120}, {pos = 1280723554, events = 10, fd = 0, user_data = 0xffffff0000000000}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x7f0000000000}, {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 = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xb8063cef56860700}, {pos = -711006752, events = 32723, fd = -328, user_data = 0x0}, {pos = -1306951416, events = 22006, fd = 1024, user_data = 0x55f6b2198108}, {pos = 307371064, events = 32766, fd = -712278369, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 25940, events = 0, fd = -328, user_data = 0x0}, {pos = -1307141560, events = 22006, fd = -712036397, user_data = 0x7ffe12521c38}, {pos = -1351931740, events = 22006, fd = -1339447824, user_data = 0x55f6af6a1361 }, {pos = -1306951616, events = 22006, fd = -1307141840, user_data = 0x55f6b2198040}, {pos = -712288533, events = 32723, fd = 0, user_data = 0x55f6af6b2fcb }, {pos = -1306951616, events = 1, fd = -1351929580, user_data = 0x55f6b2169930}, {pos = 1451624192, events = 3087416559, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -712365391, user_data = 0x7fd3d58a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1451624192, user_data = 0x55f6b2141060}, {pos = 1451624192, events = 3087416559, fd = 11, user_data = 0xb8063cef56860700}, {pos = 0, events = 0, fd = -712658375, user_data = 0x1}, {pos = -1356359481, events = 22006, fd = 4194304, user_data = 0x55f6af6a11f5 }, {pos = -1307307936, events = 22006, fd = -1307141840, user_data = 0x55f6b2141060}, {pos = 1, events = 0, fd = 0, user_data = 0x55f6af6b2fcb }, {pos = -1307307936, events = 22006, fd = -1351929580, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55f6af0b007e }, {pos = 0, events = 0, fd = -1358212162, user_data = 0xb}, {pos = -1356338324, events = 22006, fd = -1343049424, user_data = 0x55f6b216a2d8}} [08:35:17.686] nevents = 1 [08:35:17.686] __func__ = "ServerLoop" [08:35:17.686] #22 0x000055f6af281363 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55f6b2127cc0) at ../src/backend/postmaster/postmaster.c:1351 [08:35:17.686] opt = [08:35:17.686] status = [08:35:17.686] userDoption = [08:35:17.686] listen_addr_saved = false [08:35:17.686] output_config_variable = [08:35:17.686] __func__ = "PostmasterMain" [08:35:17.686] #23 0x000055f6af0c045a in main (argc=4, argv=0x55f6b2127cc0) at ../src/backend/main/main.c:197 [08:35:17.686] do_check_root = [08:35:17.721] -e [08:35:17.721] [08:35:17.721] [08:35:17.787] dumping /tmp/cores/postgres-6-35826.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:35:18.032] [New LWP 35826] [08:35:18.032] [08:35:18.032] This GDB supports auto-downloading debuginfo from the following URLs: [08:35:18.032] [08:35:18.032] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:35:18.032] Debuginfod has been disabled. [08:35:18.032] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:35:18.141] [Thread debugging using libthread_db enabled] [08:35:18.141] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:35:18.141] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [08:35:18.141] Program terminated with signal SIGABRT, Aborted. [08:35:18.141] #0 0x00007f76d66a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:19.006] [08:35:19.006] Thread 1 (Thread 0x7f76d65d2f00 (LWP 35826)): [08:35:19.006] #0 0x00007f76d66a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:19.006] No symbol table info available. [08:35:19.006] #1 0x00007f76d665afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:19.006] No symbol table info available. [08:35:19.006] #2 0x00007f76d6645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:19.006] No symbol table info available. [08:35:19.006] #3 0x00005579f6d43388 in ExceptionalCondition (conditionName=conditionName@entry=0x5579f6fb5dad "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5579f6fb5290 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [08:35:19.006] No locals. [08:35:19.006] #4 0x00005579f66ce6f9 in standard_ExecutorStart (queryDesc=0x5579f8d0c240, eflags=0) at ../src/backend/executor/execMain.c:194 [08:35:19.006] estate = 0x5579f8ca4930 [08:35:19.006] oldcontext = 0x5579f8d23a00 [08:35:19.006] __func__ = "standard_ExecutorStart" [08:35:19.006] #5 0x00007f76d46246f7 in pgss_ExecutorStart (queryDesc=0x5579f8d0c240, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [08:35:19.006] No locals. [08:35:19.006] #6 0x00005579f66ce88e in ExecutorStart (queryDesc=queryDesc@entry=0x5579f8d0c240, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [08:35:19.006] No locals. [08:35:19.006] #7 0x00005579f65f4844 in refresh_matview_datafill (dest=0x5579f8d20278, query=, query@entry=0x5579f8d5d880, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [08:35:19.006] rewritten = [08:35:19.006] plan = 0x5579f8d0b778 [08:35:19.006] queryDesc = 0x5579f8d0c240 [08:35:19.006] copied_query = [08:35:19.006] processed = [08:35:19.006] __func__ = "refresh_matview_datafill" [08:35:19.006] #8 0x00005579f65f6bab in RefreshMatViewByOid (matviewOid=27350, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [08:35:19.006] dest = [08:35:19.006] matviewRel = 0x7f76d2182a58 [08:35:19.006] rule = [08:35:19.006] actions = [08:35:19.006] dataQuery = 0x5579f8d5d880 [08:35:19.006] tableSpace = [08:35:19.006] relowner = 10 [08:35:19.006] OIDNewHeap = 27370 [08:35:19.006] processed = 0 [08:35:19.006] relpersistence = 112 'p' [08:35:19.006] save_userid = 10 [08:35:19.006] save_sec_context = 0 [08:35:19.006] save_nestlevel = 2 [08:35:19.006] address = {classId = 0, objectId = 0, objectSubId = 0} [08:35:19.006] __func__ = "RefreshMatViewByOid" [08:35:19.006] #9 0x00005579f65f6cea in ExecRefreshMatView (stmt=0x5579f8d8ac50, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [08:35:19.006] matviewOid = [08:35:19.006] lockmode = [08:35:19.006] #10 0x00005579f65ad69e in ExecCreateTableAs (pstate=pstate@entry=0x5579f8d23b00, stmt=stmt@entry=0x5579f8bb9790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff5f770e90) at ../src/backend/commands/createas.c:350 [08:35:19.006] refresh = [08:35:19.006] query = 0x5579f8bb9950 [08:35:19.006] into = 0x5579f8bb94e8 [08:35:19.006] is_matview = true [08:35:19.006] do_refresh = false [08:35:19.006] dest = [08:35:19.006] address = {classId = 1259, objectId = 27350, objectSubId = 0} [08:35:19.006] __func__ = "ExecCreateTableAs" [08:35:19.006] #11 0x00005579f6abd6f4 in ProcessUtilitySlow (pstate=pstate@entry=0x5579f8d23b00, pstmt=pstmt@entry=0x5579f8bb9840, queryString=queryString@entry=0x5579f8bb8a50 "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=0x5579f8bba7e8, qc=0x7fff5f770e90) at ../src/backend/tcop/utility.c:1675 [08:35:19.006] _save_exception_stack = 0x7fff5f770a40 [08:35:19.006] _save_context_stack = 0x0 [08:35:19.006] _local_sigjmp_buf = {{__jmpbuf = {0, -2259030858835023101, 93982352447376, 0, 93982352443984, 0, -5356186240366531837, -2259026597254386941}, __mask_was_saved = 0, __saved_mask = {__val = {93982317284462, 0, 0, 93982323340480, 93982317537129, 140148310794432, 1, 16777216, 0, 112, 93982317284734, 140148311429120, 140148311429120, 0, 0, 140148310794432}}}} [08:35:19.006] _do_rethrow = false [08:35:19.006] parsetree = 0x5579f8bb9790 [08:35:19.006] isTopLevel = true [08:35:19.006] isCompleteQuery = true [08:35:19.006] needCleanup = false [08:35:19.006] commandCollected = false [08:35:19.006] address = {classId = 21881, objectId = 4173043600, objectSubId = 21881} [08:35:19.006] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:35:19.006] __func__ = "ProcessUtilitySlow" [08:35:19.006] #12 0x00005579f6abbd05 in standard_ProcessUtility (pstmt=pstmt@entry=0x5579f8bb9840, queryString=queryString@entry=0x5579f8bb8a50 "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=0x5579f8bba7e8, qc=0x7fff5f770e90) at ../src/backend/tcop/utility.c:1067 [08:35:19.006] parsetree = 0x5579f8bb9790 [08:35:19.006] isTopLevel = true [08:35:19.006] isAtomicContext = false [08:35:19.006] pstate = 0x5579f8d23b00 [08:35:19.006] readonly_flags = [08:35:19.006] __func__ = "standard_ProcessUtility" [08:35:19.006] #13 0x00007f76d4627d4a in pgss_ProcessUtility (pstmt=0x5579f8bb9840, queryString=0x5579f8bb8a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5579f8bba7e8, qc=0x7fff5f770e90) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [08:35:19.006] _save_exception_stack = 0x7fff5f770d50 [08:35:19.006] _save_context_stack = 0x0 [08:35:19.006] _local_sigjmp_buf = {{__jmpbuf = {0, 5356396308477127427, 93982352447552, 93982352451560, 140734795026064, 0, -5356186239900964093, -5424560647829181693}, __mask_was_saved = 0, __saved_mask = {__val = {93982321101967, 140734795025334, 140734795025332, 0, 0, 0, 206158430232, 140734795025296, 93982321102184, 341, 206158430232, 93982352448352, 140734795025392, 0, 93982315945098, 93982352443728}}}} [08:35:19.006] _do_rethrow = false [08:35:19.006] duration = [08:35:19.006] bufusage = {shared_blks_hit = 93982353411432, shared_blks_read = 519691042827, shared_blks_dirtied = 93982353828216, shared_blks_written = 93982314284288, local_blks_hit = 93982353410936, local_blks_read = 93982353410352, local_blks_dirtied = 93982314283397, local_blks_written = 93982313835844, temp_blks_read = 93982353410936, temp_blks_written = 93982313807161, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93982321095419}, local_blk_read_time = {ticks = 140148379299256}, local_blk_write_time = {ticks = 93982352443984}, temp_blk_read_time = {ticks = 93982323408869}, temp_blk_write_time = {ticks = 93982333338818}} [08:35:19.006] walusage_start = {wal_records = 8919, wal_fpi = 142, wal_bytes = 1255732} [08:35:19.006] start = [08:35:19.006] rows = [08:35:19.006] bufusage_start = {shared_blks_hit = 33459, shared_blks_read = 3946, shared_blks_dirtied = 1570, shared_blks_written = 1000, 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}} [08:35:19.006] walusage = {wal_records = 0, wal_fpi = 519691042827, wal_bytes = 93982353413368} [08:35:19.006] parsetree = [08:35:19.006] saved_queryId = 6041762721901209185 [08:35:19.006] saved_stmt_location = 0 [08:35:19.006] saved_stmt_len = 69 [08:35:19.006] enabled = true [08:35:19.006] #14 0x00005579f6abbdab in ProcessUtility (pstmt=pstmt@entry=0x5579f8bb9840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5579f8bba7e8, qc=0x7fff5f770e90) at ../src/backend/tcop/utility.c:519 [08:35:19.006] No locals. [08:35:19.006] #15 0x00005579f6ab76cc in PortalRunUtility (portal=portal@entry=0x5579f8c39f90, pstmt=pstmt@entry=0x5579f8bb9840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5579f8bba7e8, qc=qc@entry=0x7fff5f770e90) at ../src/backend/tcop/pquery.c:1158 [08:35:19.006] No locals. [08:35:19.006] #16 0x00005579f6ab7c71 in PortalRunMulti (portal=portal@entry=0x5579f8c39f90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5579f8bba7e8, altdest=altdest@entry=0x5579f8bba7e8, qc=qc@entry=0x7fff5f770e90) at ../src/backend/tcop/pquery.c:1316 [08:35:19.006] pstmt = 0x5579f8bb9840 [08:35:19.006] stmtlist_item__state = [08:35:19.006] active_snapshot_set = false [08:35:19.006] stmtlist_item = 0x5579f8bba7b0 [08:35:19.006] #17 0x00005579f6ab8244 in PortalRun (portal=portal@entry=0x5579f8c39f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5579f8bba7e8, altdest=altdest@entry=0x5579f8bba7e8, qc=0x7fff5f770e90) at ../src/backend/tcop/pquery.c:791 [08:35:19.006] _save_exception_stack = 0x7fff5f770f40 [08:35:19.006] _save_context_stack = 0x0 [08:35:19.006] _local_sigjmp_buf = {{__jmpbuf = {0, -2259030857581974781, 93982352973712, 93982352447496, 93982352973712, 93982352447424, -5356186240045667581, -2259026597999269117}, __mask_was_saved = 0, __saved_mask = {__val = {93982320780080, 93982352443728, 112, 4, 93982320784497, 1601637919, 4, 93982352447424, 112, 73, 93982352973712, 93982352447496, 93982352447472, 93982352447424, 93982320871700, 1}}}} [08:35:19.006] _do_rethrow = [08:35:19.006] result = [08:35:19.006] nprocessed = [08:35:19.006] saveTopTransactionResourceOwner = 0x5579f8bf9468 [08:35:19.006] saveTopTransactionContext = 0x5579f8c4c3c0 [08:35:19.006] saveActivePortal = 0x0 [08:35:19.006] saveResourceOwner = 0x5579f8bf9468 [08:35:19.006] savePortalContext = 0x0 [08:35:19.006] saveMemoryContext = 0x5579f8c4c3c0 [08:35:19.006] __func__ = "PortalRun" [08:35:19.006] #18 0x00005579f6ab1630 in exec_simple_query (query_string=query_string@entry=0x5579f8bb8a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [08:35:19.006] cmdtaglen = 24 [08:35:19.006] snapshot_set = [08:35:19.006] per_parsetree_context = 0x0 [08:35:19.006] plantree_list = 0x5579f8bba798 [08:35:19.006] parsetree = 0x5579f8bb97c0 [08:35:19.006] commandTag = [08:35:19.006] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:35:19.006] querytree_list = [08:35:19.006] portal = 0x5579f8c39f90 [08:35:19.006] receiver = 0x5579f8bba7e8 [08:35:19.006] format = 0 [08:35:19.006] cmdtagname = [08:35:19.006] parsetree_item__state = [08:35:19.006] dest = DestRemote [08:35:19.006] oldcontext = 0x5579f8c4c3c0 [08:35:19.006] parsetree_list = 0x5579f8bb97f0 [08:35:19.006] parsetree_item = 0x5579f8bb9808 [08:35:19.006] save_log_statement_stats = false [08:35:19.006] was_logged = true [08:35:19.006] use_implicit_block = false [08:35:19.006] msec_str = "\360\020w_\377\177\000\0006\221\326\366yU\000\000 \017w_\377\177\000\000G\000\000\000\000\000\000" [08:35:19.006] __func__ = "exec_simple_query" [08:35:19.006] #19 0x00005579f6ab43b4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [08:35:19.006] query_string = 0x5579f8bb8a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [08:35:19.006] firstchar = [08:35:19.006] input_message = {data = 0x5579f8bb8a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [08:35:19.006] local_sigjmp_buf = {{__jmpbuf = {93982333347384, -2259028963479377149, 4, 140734795026672, 140734795026816, 140734795026820, -5356186240016307453, -2259026601393902845}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 93982352693568, 0, 168, 93982320784599, 0, 10, 2, 93982333347392, 93982352174576, 93982333341472, 140734795026672, 140734795026816, 140734795026820}}}} [08:35:19.006] send_ready_for_query = false [08:35:19.006] idle_in_transaction_timeout_enabled = false [08:35:19.006] idle_session_timeout_enabled = false [08:35:19.006] __func__ = "PostgresMain" [08:35:19.006] #20 0x00005579f6aaa22b in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:35:19.006] bsdata = [08:35:19.006] #21 0x00005579f6961bca in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff5f77109c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff5f7710f0) at ../src/backend/postmaster/launch_backend.c:274 [08:35:19.006] pid = [08:35:19.006] #22 0x00005579f696767e in BackendStartup (client_sock=client_sock@entry=0x7fff5f7710f0) at ../src/backend/postmaster/postmaster.c:3420 [08:35:19.006] bn = 0x5579f8be51f8 [08:35:19.006] pid = [08:35:19.006] startup_data = {canAcceptConnections = CAC_OK} [08:35:19.006] __func__ = "BackendStartup" [08:35:19.006] #23 0x00005579f6967be0 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [08:35:19.006] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "b\326v\177\000\000\264\021w_\377\177\000\000ʐ\000\330v\177\000\000>\004\000\000\000\000\000\000\260\227c\326v\177\000\000\240\037\270\327v\177\000\000\270\021w_\377\177\000\000\264\021w_\377\177\000\000\000\000\000\000\000\000\000\000P\021w_\377\177\000\000V\217\262\365yU\000\000\200w\256\365yU\000\000\200\022w_\377\177\000\000x\022w_\377\177\000\000\225[\362\001\000\000\000", __ss_align = 93982352616048}, salen = 2}} [08:35:19.006] i = 0 [08:35:19.006] now = [08:35:19.006] last_lockfile_recheck_time = 1727253122 [08:35:19.006] last_touch_time = 1727253122 [08:35:19.006] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f76d80332e0}, {pos = 1601638904, events = 0, fd = 0, user_data = 0x7f76d8033668}, {pos = -172847274, events = 21881, fd = -670878104, user_data = 0x7f76d6e3e630}, {pos = -670879008, events = 32630, fd = 2090263927, user_data = 0x7fff5f771300}, {pos = -671049144, events = 32630, fd = 15, user_data = 0x7f76d6e3e630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -670879008, events = 32630, fd = 1601639032, user_data = 0x7fff5f771280}, {pos = -670878104, events = 32630, fd = 0, user_data = 0x5579f8be4308}, {pos = -121749016, events = 21881, fd = -121730927, user_data = 0x7f7600000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f76d662e020}, {pos = -675799136, events = 32630, fd = -121748728, user_data = 0x7fff5f771670}, {pos = -121730760, events = 21881, fd = -121728832, user_data = 0x5579f8be4308}, {pos = -670879008, events = 32630, fd = 438, user_data = 0x5579f72e1db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x5579f8bba890}, {pos = -671023426, events = 32630, fd = 1, user_data = 0x0}, {pos = -698163168, events = 32630, fd = -697356864, user_data = 0x7fff5f7716e0}, {pos = 1601640128, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -671014470, user_data = 0x0}, {pos = -697635548, events = 32630, fd = 0, user_data = 0x5579f7972fc0 }, {pos = 2, events = 0, fd = 7, user_data = 0x5579f8b7ae90}, {pos = 0, events = 0, fd = -698129208, user_data = 0x7f76d669c880 }, {pos = -698536520, events = 32630, fd = 8096, user_data = 0x100007f00000002}, {pos = -697602067, events = 32630, fd = 2, user_data = 0x5579f8bed900}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -696312736, events = 32630, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x5579f8b7ae90}, {pos = -697599478, events = 32630, fd = 1769300525, user_data = 0x5579f8b7ae90}, {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 = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -683121344, user_data = 0x7f76d7486a80}, {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 = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xf26c0347809e0600}, {pos = -696326688, events = 32630, fd = -328, user_data = 0x0}, {pos = -121749336, events = 21881, fd = 1024, user_data = 0x5579f8be40a8}, {pos = 1601640312, events = 32767, fd = -697598305, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 32550, events = 0, fd = -328, user_data = 0x0}, {pos = -121919344, events = 21881, fd = -697356333, user_data = 0x7fff5f771778}, {pos = -153507676, events = 21881, fd = -141023760, user_data = 0x5579f6d89361 }, {pos = -121749536, events = 21881, fd = -121927344, user_data = 0x5579f8be3fe0}, {pos = -697608130, events = 32630, fd = 0, user_data = 0x5579f6d9afcb }, {pos = -121749536, events = 1, fd = -153505516, user_data = 0x5579f8bb8950}, {pos = -2137127424, events = 4067164999, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -697685327, user_data = 0x7f76d66a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2137127424, user_data = 0x5579f8b90080}, {pos = -2137127424, events = 4067164999, fd = 11, user_data = 0xf26c0347809e0600}, {pos = 0, events = 0, fd = -697978311, user_data = 0x1}, {pos = -157935417, events = 21881, fd = 4194304, user_data = 0x5579f6d891f5 }, {pos = -122093440, events = 21881, fd = -121927344, user_data = 0x5579f8b90080}, {pos = 1, events = 0, fd = 0, user_data = 0x5579f6d9afcb }, {pos = -122093440, events = 21881, fd = -153505516, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5579f679807e }, {pos = 0, events = 0, fd = -159788098, user_data = 0xb}, {pos = -157914260, events = 21881, fd = -144625360, user_data = 0x5579f8bb9308}} [08:35:19.007] nevents = 1 [08:35:19.007] __func__ = "ServerLoop" [08:35:19.007] #24 0x00005579f6969363 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5579f8b76cf0) at ../src/backend/postmaster/postmaster.c:1351 [08:35:19.007] opt = [08:35:19.007] status = [08:35:19.007] userDoption = [08:35:19.007] listen_addr_saved = false [08:35:19.007] output_config_variable = [08:35:19.007] __func__ = "PostmasterMain" [08:35:19.007] #25 0x00005579f67a845a in main (argc=4, argv=0x5579f8b76cf0) at ../src/backend/main/main.c:197 [08:35:19.007] do_check_root = [08:35:19.041] -e [08:35:19.041] [08:35:19.041] [08:35:19.104] dumping /tmp/cores/postgres-6-29040.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:35:19.347] [New LWP 29040] [08:35:19.347] [08:35:19.347] This GDB supports auto-downloading debuginfo from the following URLs: [08:35:19.347] [08:35:19.347] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:35:19.347] Debuginfod has been disabled. [08:35:19.347] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:35:19.458] [Thread debugging using libthread_db enabled] [08:35:19.458] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:35:19.458] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [08:35:19.458] Program terminated with signal SIGABRT, Aborted. [08:35:19.458] #0 0x00007fe8ec4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:20.363] [08:35:20.363] Thread 1 (Thread 0x7fe8ec1dcf00 (LWP 29040)): [08:35:20.363] #0 0x00007fe8ec4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:20.363] No symbol table info available. [08:35:20.363] #1 0x00007fe8ec45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:20.363] No symbol table info available. [08:35:20.363] #2 0x00007fe8ec445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:35:20.363] No symbol table info available. [08:35:20.363] #3 0x000055d937da0388 in ExceptionalCondition (conditionName=conditionName@entry=0x55d938012dad "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55d938012290 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [08:35:20.363] No locals. [08:35:20.363] #4 0x000055d93772b6f9 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55d939647f20, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [08:35:20.363] estate = 0x55d93961e800 [08:35:20.363] oldcontext = 0x55d939650320 [08:35:20.363] __func__ = "standard_ExecutorStart" [08:35:20.363] #5 0x000055d93772b8d5 in ExecutorStart (queryDesc=queryDesc@entry=0x55d939647f20, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [08:35:20.363] No locals. [08:35:20.363] #6 0x000055d937651844 in refresh_matview_datafill (dest=0x55d939655448, query=, query@entry=0x55d9396a0910, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [08:35:20.363] rewritten = [08:35:20.363] plan = 0x55d939647458 [08:35:20.363] queryDesc = 0x55d939647f20 [08:35:20.363] copied_query = [08:35:20.363] processed = [08:35:20.363] __func__ = "refresh_matview_datafill" [08:35:20.363] #7 0x000055d937653bab in RefreshMatViewByOid (matviewOid=27196, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [08:35:20.363] dest = [08:35:20.363] matviewRel = 0x7fe8e091da58 [08:35:20.363] rule = [08:35:20.363] actions = [08:35:20.363] dataQuery = 0x55d9396a0910 [08:35:20.363] tableSpace = [08:35:20.363] relowner = 10 [08:35:20.363] OIDNewHeap = 27210 [08:35:20.363] processed = 0 [08:35:20.363] relpersistence = 112 'p' [08:35:20.363] save_userid = 10 [08:35:20.363] save_sec_context = 0 [08:35:20.363] save_nestlevel = 2 [08:35:20.363] address = {classId = 0, objectId = 0, objectSubId = 0} [08:35:20.363] __func__ = "RefreshMatViewByOid" [08:35:20.363] #8 0x000055d937653cea in ExecRefreshMatView (stmt=0x55d939651060, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [08:35:20.363] matviewOid = [08:35:20.363] lockmode = [08:35:20.363] #9 0x000055d93760a69e in ExecCreateTableAs (pstate=pstate@entry=0x55d939650420, stmt=stmt@entry=0x55d9394f77f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe2204d720) at ../src/backend/commands/createas.c:350 [08:35:20.363] refresh = [08:35:20.363] query = 0x55d9394f79b0 [08:35:20.363] into = 0x55d9394f7548 [08:35:20.363] is_matview = true [08:35:20.363] do_refresh = false [08:35:20.363] dest = [08:35:20.363] address = {classId = 1259, objectId = 27196, objectSubId = 0} [08:35:20.363] __func__ = "ExecCreateTableAs" [08:35:20.363] #10 0x000055d937b1a6f4 in ProcessUtilitySlow (pstate=pstate@entry=0x55d939650420, pstmt=pstmt@entry=0x55d9394f78a0, queryString=queryString@entry=0x55d9394f6ab0 "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=0x55d9394f82d8, qc=0x7ffe2204d720) at ../src/backend/tcop/utility.c:1675 [08:35:20.363] _save_exception_stack = 0x7ffe2204d5e0 [08:35:20.363] _save_context_stack = 0x0 [08:35:20.363] _local_sigjmp_buf = {{__jmpbuf = {0, -3185738183192728080, 94391457773552, 0, 94391457770160, 0, -8680747006424633872, -3185766781882585616}, __mask_was_saved = 0, __saved_mask = {__val = {4294977661, 140638185255552, 94391430068911, 1, 44518298743224, 1, 10365, 140638185255552, 140638185255552, 1, 94391430078940, 94391458984376, 10630746928564428800, 140638185255552, 140638185255552, 10365}}}} [08:35:20.363] _do_rethrow = false [08:35:20.363] parsetree = 0x55d9394f77f0 [08:35:20.363] isTopLevel = true [08:35:20.363] isCompleteQuery = true [08:35:20.363] needCleanup = false [08:35:20.363] commandCollected = false [08:35:20.363] address = {classId = 21977, objectId = 961509360, objectSubId = 21977} [08:35:20.363] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:35:20.363] __func__ = "ProcessUtilitySlow" [08:35:20.363] #11 0x000055d937b18d05 in standard_ProcessUtility (pstmt=0x55d9394f78a0, queryString=0x55d9394f6ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55d9394f82d8, qc=0x7ffe2204d720) at ../src/backend/tcop/utility.c:1067 [08:35:20.363] parsetree = 0x55d9394f77f0 [08:35:20.363] isTopLevel = true [08:35:20.363] isAtomicContext = false [08:35:20.363] pstate = 0x55d939650420 [08:35:20.363] readonly_flags = [08:35:20.363] __func__ = "standard_ProcessUtility" [08:35:20.363] #12 0x000055d937b18e60 in ProcessUtility (pstmt=pstmt@entry=0x55d9394f78a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55d9394f82d8, qc=0x7ffe2204d720) at ../src/backend/tcop/utility.c:523 [08:35:20.363] No locals. [08:35:20.363] #13 0x000055d937b146cc in PortalRunUtility (portal=portal@entry=0x55d939579050, pstmt=pstmt@entry=0x55d9394f78a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d9394f82d8, qc=qc@entry=0x7ffe2204d720) at ../src/backend/tcop/pquery.c:1158 [08:35:20.363] No locals. [08:35:20.363] #14 0x000055d937b14c71 in PortalRunMulti (portal=portal@entry=0x55d939579050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d9394f82d8, altdest=altdest@entry=0x55d9394f82d8, qc=qc@entry=0x7ffe2204d720) at ../src/backend/tcop/pquery.c:1316 [08:35:20.363] pstmt = 0x55d9394f78a0 [08:35:20.363] stmtlist_item__state = [08:35:20.363] active_snapshot_set = false [08:35:20.363] stmtlist_item = 0x55d9394f82a0 [08:35:20.363] #15 0x000055d937b15244 in PortalRun (portal=portal@entry=0x55d939579050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55d9394f82d8, altdest=altdest@entry=0x55d9394f82d8, qc=0x7ffe2204d720) at ../src/backend/tcop/pquery.c:791 [08:35:20.363] _save_exception_stack = 0x7ffe2204d7d0 [08:35:20.363] _save_context_stack = 0x0 [08:35:20.363] _local_sigjmp_buf = {{__jmpbuf = {0, -3185738176948458000, 94391458304080, 94391457773672, 94391458304080, 94391457773600, -8680747006563045904, -3185766788524659216}, __mask_was_saved = 0, __saved_mask = {__val = {94391433573168, 94391457769904, 112, 4, 94391433577585, 570742447, 4, 94391457773600, 112, 73, 94391458304080, 94391457773672, 94391457773648, 94391457773600, 94391433664788, 1}}}} [08:35:20.363] _do_rethrow = [08:35:20.363] result = [08:35:20.363] nprocessed = [08:35:20.363] saveTopTransactionResourceOwner = 0x55d939535d08 [08:35:20.363] saveTopTransactionContext = 0x55d93958ac60 [08:35:20.363] saveActivePortal = 0x0 [08:35:20.363] saveResourceOwner = 0x55d939535d08 [08:35:20.363] savePortalContext = 0x0 [08:35:20.363] saveMemoryContext = 0x55d93958ac60 [08:35:20.363] __func__ = "PortalRun" [08:35:20.363] #16 0x000055d937b0e630 in exec_simple_query (query_string=query_string@entry=0x55d9394f6ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [08:35:20.363] cmdtaglen = 24 [08:35:20.363] snapshot_set = [08:35:20.363] per_parsetree_context = 0x0 [08:35:20.363] plantree_list = 0x55d9394f8288 [08:35:20.363] parsetree = 0x55d9394f7820 [08:35:20.363] commandTag = [08:35:20.363] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:35:20.363] querytree_list = [08:35:20.363] portal = 0x55d939579050 [08:35:20.363] receiver = 0x55d9394f82d8 [08:35:20.363] format = 0 [08:35:20.363] cmdtagname = [08:35:20.363] parsetree_item__state = [08:35:20.363] dest = DestRemote [08:35:20.363] oldcontext = 0x55d93958ac60 [08:35:20.363] parsetree_list = 0x55d9394f7850 [08:35:20.363] parsetree_item = 0x55d9394f7868 [08:35:20.363] save_log_statement_stats = false [08:35:20.363] was_logged = false [08:35:20.363] use_implicit_block = false [08:35:20.363] msec_str = "\200\331\004\"\376\177\000\0006a\3347\331U\000\000\260\327\004\"\376\177\000\000G\000\000\000\000\000\000" [08:35:20.363] __func__ = "exec_simple_query" [08:35:20.363] #17 0x000055d937b113b4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [08:35:20.363] query_string = 0x55d9394f6ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [08:35:20.363] firstchar = [08:35:20.363] input_message = {data = 0x55d9394f6ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [08:35:20.363] local_sigjmp_buf = {{__jmpbuf = {94391446140472, -3185734175799497232, 4, 140729469163904, 140729469164048, 140729469164052, -8680747006491742736, -3185766786035733008}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94391457500624, 15616, 94391446134560, 94391458024640, 140729469164048, 94391433577133, 0, 9, 2, 94391446140480, 94391457500624, 94391446134560, 140729469163904, 140729469164048, 140729469164052}}}} [08:35:20.363] send_ready_for_query = false [08:35:20.363] idle_in_transaction_timeout_enabled = false [08:35:20.363] idle_session_timeout_enabled = false [08:35:20.363] __func__ = "PostgresMain" [08:35:20.363] #18 0x000055d937b0722b in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:35:20.363] bsdata = [08:35:20.363] #19 0x000055d9379bebca in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe2204d92c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe2204d980) at ../src/backend/postmaster/launch_backend.c:274 [08:35:20.363] pid = [08:35:20.363] #20 0x000055d9379c467e in BackendStartup (client_sock=client_sock@entry=0x7ffe2204d980) at ../src/backend/postmaster/postmaster.c:3420 [08:35:20.363] bn = 0x55d93951f2a8 [08:35:20.363] pid = [08:35:20.363] startup_data = {canAcceptConnections = CAC_OK} [08:35:20.363] __func__ = "BackendStartup" [08:35:20.363] #21 0x000055d9379c4be0 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [08:35:20.363] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\311\355\350\177\000\000>\004\000\000\000\000\000\000\260\227C\354\350\177\000\000\240\257\223\355\350\177\000\0008\332\004\"\376\177\000\0004\332\004\"\376\177", '\000' , "V_\2706\331U\000\000\200G\2646\331U\000\000\000\333\004\"\376\177\000\000\370\332\004\"\376\177\000\000\225[\362\001ȁ\222破\222\355\350\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [08:35:20.363] i = 0 [08:35:20.363] now = [08:35:20.363] last_lockfile_recheck_time = 1727253087 [08:35:20.363] last_touch_time = 1727253087 [08:35:20.363] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 570743616, user_data = 0x0}, {pos = 15, events = 0, fd = 918052694, user_data = 0x7fe8edcbe668}, {pos = -309152208, events = 32744, fd = -305405216, user_data = 0x7c96e577}, {pos = 570743680, events = 32766, fd = -305575352, user_data = 0xf}, {pos = -309152208, events = 32744, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -305405216, user_data = 0x7ffe2204daf8}, {pos = 570743552, events = 32766, fd = -305404312, user_data = 0x0}, {pos = 961513648, events = 21977, fd = -330371867, user_data = 0x7ffe2204e013}, {pos = 1, events = 0, fd = 570743552, user_data = 0xffffffff}, {pos = -331161568, events = 32744, fd = -309088352, user_data = 0x55d939523748}, {pos = 961689128, events = 21977, fd = 961697857, user_data = 0x7fe8edc9aebe}, {pos = 1, events = 0, fd = -305405216, user_data = 0x1b6}, {pos = 942927280, events = 21977, fd = 0, user_data = 0x1}, {pos = 961506160, events = 21977, fd = -305549634, user_data = 0x1}, {pos = 0, events = 0, fd = -331161568, user_data = 0x7fe8ec4f2dc0 }, {pos = 16, events = 0, fd = 570744656, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fe8edc9d1ba}, {pos = 0, events = 0, fd = -330633948, user_data = 0x0}, {pos = 949813184, events = 21977, fd = 2, user_data = 0x7}, {pos = 961252976, events = 21977, fd = 1952410737, user_data = 0x169}, {pos = 942926664, events = 21977, fd = 8, user_data = 0x2ffff00001fa0}, {pos = 961506160, events = 21977, fd = -305549634, user_data = 0x1}, {pos = -330600467, events = 32744, fd = -331127608, user_data = 0x55d939522410}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -329311136, events = 32744, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55d9394b8e70}, {pos = -330597878, events = 32744, 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 = 858874214, fd = 168447062, user_data = 0x32373237310a6174}, {pos = 942682933, events = 808716855, 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 = -329328160, events = 32744, fd = -330690194, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0xe79281c8acd67e00}, {pos = -329325088, events = 32744, fd = -328, user_data = 0x0}, {pos = 961688808, events = 21977, fd = 1024, user_data = 0x55d9395234e8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 25400, events = 0, fd = -328, user_data = 0x0}, {pos = 961506160, events = 21977, fd = -330354733, user_data = 0x7ffe2204e008}, {pos = 937392292, events = 21977, fd = 949876208, user_data = 0x55d937de6361 }, {pos = 961688608, events = 21977, fd = 961505712, user_data = 0x55d939523420}, {pos = -330606530, events = 32744, fd = 0, user_data = 0x55d937df7fcb }, {pos = 961688608, events = 1, fd = 937394452, user_data = 0x55d9394f69b0}, {pos = -1395229184, events = 3885138376, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -330683727, user_data = 0x7fe8ec4a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1395229184, user_data = 0x55d9394ce0e0}, {pos = -1395229184, events = 3885138376, fd = 11, user_data = 0xe79281c8acd67e00}, {pos = 0, events = 0, fd = -330976711, user_data = 0x1}, {pos = 932964551, events = 21977, fd = 4194304, user_data = 0x55d937de61f5 }, {pos = 961339616, events = 21977, fd = 961505712, user_data = 0x55d9394ce0e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55d937df7fcb }, {pos = 961339616, events = 21977, fd = 937394452, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55d9377f507e }, {pos = 0, events = 0, fd = 931111870, user_data = 0xb}, {pos = 932985708, events = 21977, fd = 946274608, user_data = 0x55d9394f7388}} [08:35:20.364] nevents = 1 [08:35:20.364] __func__ = "ServerLoop" [08:35:20.364] #22 0x000055d9379c6363 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55d9394b4d30) at ../src/backend/postmaster/postmaster.c:1351 [08:35:20.364] opt = [08:35:20.364] status = [08:35:20.364] userDoption = [08:35:20.364] listen_addr_saved = false [08:35:20.364] output_config_variable = [08:35:20.364] __func__ = "PostmasterMain" [08:35:20.364] #23 0x000055d93780545a in main (argc=8, argv=0x55d9394b4d30) at ../src/backend/main/main.c:197 [08:35:20.364] do_check_root =