[19:36:33.649] src/tools/ci/cores_backtrace.sh linux /tmp/cores [19:36:33.858] dumping /tmp/cores/postgres-6-36942.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:36:34.116] [New LWP 36942] [19:36:34.116] [19:36:34.116] This GDB supports auto-downloading debuginfo from the following URLs: [19:36:34.116] [19:36:34.116] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [19:36:34.116] Debuginfod has been disabled. [19:36:34.116] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [19:36:34.238] [Thread debugging using libthread_db enabled] [19:36:34.238] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [19:36:34.238] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [19:36:34.238] Program terminated with signal SIGABRT, Aborted. [19:36:34.238] #0 0x00007fa6592a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:35.288] [19:36:35.288] Thread 1 (Thread 0x7fa658fe1f00 (LWP 36942)): [19:36:35.288] #0 0x00007fa6592a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:35.288] No symbol table info available. [19:36:35.288] #1 0x00007fa65925afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:35.288] No symbol table info available. [19:36:35.288] #2 0x00007fa659245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:35.288] No symbol table info available. [19:36:35.288] #3 0x000055cfb39a5747 in ExceptionalCondition (conditionName=conditionName@entry=0x55cfb3c2295d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55cfb3c21eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [19:36:35.288] No locals. [19:36:35.288] #4 0x000055cfb3310206 in standard_ExecutorStart (queryDesc=0x55cfe5225620, eflags=0) at ../src/backend/executor/execMain.c:193 [19:36:35.288] estate = 0x55cfe511b7c0 [19:36:35.288] oldcontext = 0x55cfe51e50c0 [19:36:35.288] __func__ = "standard_ExecutorStart" [19:36:35.288] #5 0x00007fa6570276e9 in pgss_ExecutorStart (queryDesc=0x55cfe5225620, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [19:36:35.288] No locals. [19:36:35.288] #6 0x000055cfb331039b in ExecutorStart (queryDesc=queryDesc@entry=0x55cfe5225620, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [19:36:35.288] No locals. [19:36:35.288] #7 0x000055cfb322f6df in refresh_matview_datafill (dest=0x55cfe51def20, query=, query@entry=0x55cfe525a7b0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [19:36:35.288] rewritten = [19:36:35.288] plan = 0x55cfe5224c48 [19:36:35.288] queryDesc = 0x55cfe5225620 [19:36:35.288] copied_query = [19:36:35.288] processed = [19:36:35.288] __func__ = "refresh_matview_datafill" [19:36:35.288] #8 0x000055cfb3231a39 in RefreshMatViewByOid (matviewOid=28595, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [19:36:35.288] dest = [19:36:35.288] matviewRel = 0x7fa654b705f0 [19:36:35.288] rule = [19:36:35.288] actions = [19:36:35.288] dataQuery = 0x55cfe525a7b0 [19:36:35.288] tableSpace = [19:36:35.288] relowner = 10 [19:36:35.288] OIDNewHeap = 28615 [19:36:35.288] processed = 0 [19:36:35.288] relpersistence = 112 'p' [19:36:35.288] save_userid = 10 [19:36:35.288] save_sec_context = 0 [19:36:35.288] save_nestlevel = 2 [19:36:35.288] address = {classId = 0, objectId = 0, objectSubId = 0} [19:36:35.288] __func__ = "RefreshMatViewByOid" [19:36:35.288] #9 0x000055cfb3231b78 in ExecRefreshMatView (stmt=0x55cfe51debf8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:36:35.288] matviewOid = [19:36:35.288] lockmode = [19:36:35.288] #10 0x000055cfb31e7634 in ExecCreateTableAs (pstate=pstate@entry=0x55cfe51e51c0, stmt=stmt@entry=0x55cfe50c0b80, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe955d9cb0) at ../src/backend/commands/createas.c:351 [19:36:35.288] refresh = [19:36:35.288] query = 0x55cfe50c0d40 [19:36:35.288] into = 0x55cfe50c08d8 [19:36:35.288] jstate = 0x0 [19:36:35.288] is_matview = true [19:36:35.288] do_refresh = false [19:36:35.288] dest = [19:36:35.288] address = {classId = 1259, objectId = 28595, objectSubId = 0} [19:36:35.288] __func__ = "ExecCreateTableAs" [19:36:35.288] #11 0x000055cfb3714297 in ProcessUtilitySlow (pstate=pstate@entry=0x55cfe51e51c0, pstmt=pstmt@entry=0x55cfe50c0c30, queryString=queryString@entry=0x55cfe50bfe40 "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=0x55cfe50c1bd8, qc=0x7ffe955d9cb0) at ../src/backend/tcop/utility.c:1678 [19:36:35.288] _save_exception_stack = 0x7ffe955d9880 [19:36:35.288] _save_context_stack = 0x0 [19:36:35.288] _local_sigjmp_buf = {{__jmpbuf = {0, -4033973719395243035, 94351389363072, 0, 94351389359680, 0, -7176887442561078299, -4033854466579928091}, __mask_was_saved = 0, __saved_mask = {__val = {3, 5, 1, 5, 1, 1, 94351389366656, 94351389367456, 94350560194098, 3843945544, 94350557335628, 1, 140731404359856, 0, 94350560419235, 140731404359052}}}} [19:36:35.288] _do_rethrow = false [19:36:35.288] parsetree = 0x55cfe50c0b80 [19:36:35.288] isTopLevel = true [19:36:35.288] isCompleteQuery = true [19:36:35.288] needCleanup = false [19:36:35.288] commandCollected = false [19:36:35.288] address = {classId = 21967, objectId = 3842771840, objectSubId = 21967} [19:36:35.288] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:36:35.288] __func__ = "ProcessUtilitySlow" [19:36:35.288] #12 0x000055cfb3712896 in standard_ProcessUtility (pstmt=pstmt@entry=0x55cfe50c0c30, queryString=queryString@entry=0x55cfe50bfe40 "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=0x55cfe50c1bd8, qc=0x7ffe955d9cb0) at ../src/backend/tcop/utility.c:1070 [19:36:35.288] parsetree = 0x55cfe50c0b80 [19:36:35.288] isTopLevel = true [19:36:35.288] isAtomicContext = false [19:36:35.288] pstate = 0x55cfe51e51c0 [19:36:35.288] readonly_flags = [19:36:35.288] __func__ = "standard_ProcessUtility" [19:36:35.288] #13 0x00007fa65702ad97 in pgss_ProcessUtility (pstmt=0x55cfe50c0c30, queryString=0x55cfe50bfe40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55cfe50c1bd8, qc=0x7ffe955d9cb0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [19:36:35.288] _save_exception_stack = 0x7ffe955d9b90 [19:36:35.288] _save_context_stack = 0x0 [19:36:35.288] _local_sigjmp_buf = {{__jmpbuf = {0, 7177533146996370405, 94351389363248, 94351389367256, 140731404360880, 0, -7176887442380723227, -7145217702959027227}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140731404360112, 94350560426934, 1, 206158430232, 94351389364048, 140731404360208, 0, 94350555186865, 94351389359424, 94350560086452, 3, 94350553909091, 94351389363248}}}} [19:36:35.288] _do_rethrow = false [19:36:35.288] duration = [19:36:35.288] bufusage = {shared_blks_hit = 1, shared_blks_read = 126, shared_blks_dirtied = 140352365280448, shared_blks_written = 140352365280448, local_blks_hit = 1, local_blks_read = 94350556559936, local_blks_dirtied = 94351389738120, local_blks_written = 94350560420169, temp_blks_read = 140352434347448, temp_blks_written = 94351389359680, shared_blk_read_time = {ticks = 94350562783251}, shared_blk_write_time = {ticks = 94350572956162}, local_blk_read_time = {ticks = 94350572956288}, local_blk_write_time = {ticks = 140731404360116}, temp_blk_read_time = {ticks = 94350562978105}, temp_blk_write_time = {ticks = 94350572956177}} [19:36:35.288] walusage_start = {wal_records = 8972, wal_fpi = 137, wal_bytes = 1247890} [19:36:35.288] start = [19:36:35.288] rows = [19:36:35.288] bufusage_start = {shared_blks_hit = 34330, shared_blks_read = 4339, shared_blks_dirtied = 1457, shared_blks_written = 997, 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}} [19:36:35.288] walusage = {wal_records = 140352368392960, wal_fpi = 541165879296, wal_bytes = 140352365280484} [19:36:35.288] parsetree = [19:36:35.288] saved_queryId = 7267788456574341698 [19:36:35.288] saved_stmt_location = 0 [19:36:35.288] saved_stmt_len = 69 [19:36:35.288] enabled = true [19:36:35.288] #14 0x000055cfb371293c in ProcessUtility (pstmt=pstmt@entry=0x55cfe50c0c30, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55cfe50c1bd8, qc=0x7ffe955d9cb0) at ../src/backend/tcop/utility.c:519 [19:36:35.288] No locals. [19:36:35.288] #15 0x000055cfb370e39d in PortalRunUtility (portal=portal@entry=0x55cfe5142d30, pstmt=pstmt@entry=0x55cfe50c0c30, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55cfe50c1bd8, qc=qc@entry=0x7ffe955d9cb0) at ../src/backend/tcop/pquery.c:1152 [19:36:35.288] No locals. [19:36:35.288] #16 0x000055cfb370e948 in PortalRunMulti (portal=portal@entry=0x55cfe5142d30, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55cfe50c1bd8, altdest=altdest@entry=0x55cfe50c1bd8, qc=qc@entry=0x7ffe955d9cb0) at ../src/backend/tcop/pquery.c:1309 [19:36:35.288] pstmt = 0x55cfe50c0c30 [19:36:35.288] stmtlist_item__state = [19:36:35.288] active_snapshot_set = false [19:36:35.288] stmtlist_item = 0x55cfe50c1ba0 [19:36:35.288] #17 0x000055cfb370eeb0 in PortalRun (portal=portal@entry=0x55cfe5142d30, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55cfe50c1bd8, altdest=altdest@entry=0x55cfe50c1bd8, qc=qc@entry=0x7ffe955d9cb0) at ../src/backend/tcop/pquery.c:787 [19:36:35.288] _save_exception_stack = 0x7ffe955d9d60 [19:36:35.288] _save_context_stack = 0x0 [19:36:35.288] _local_sigjmp_buf = {{__jmpbuf = {0, -4033973720136586267, 94351389895984, 94351389363192, 94351389363168, 94351389363120, -7176887442848388123, -4033854451384095771}, __mask_was_saved = 0, __saved_mask = {__val = {94350560107304, 2505940031, 4, 94351389363120, 112, 73, 94351389895984, 94351389363192, 94351389363168, 94351389363120, 94350560194507, 1, 2, 73, 94350549441018, 0}}}} [19:36:35.288] _do_rethrow = [19:36:35.288] result = [19:36:35.288] nprocessed = [19:36:35.288] saveTopTransactionResourceOwner = 0x55cfe5104738 [19:36:35.288] saveTopTransactionContext = 0x55cfe5155570 [19:36:35.288] saveActivePortal = 0x0 [19:36:35.288] saveResourceOwner = 0x55cfe5104738 [19:36:35.288] savePortalContext = 0x0 [19:36:35.288] saveMemoryContext = 0x55cfe5155570 [19:36:35.288] __func__ = "PortalRun" [19:36:35.288] #18 0x000055cfb3708346 in exec_simple_query (query_string=query_string@entry=0x55cfe50bfe40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [19:36:35.288] cmdtaglen = 24 [19:36:35.288] snapshot_set = [19:36:35.288] per_parsetree_context = 0x0 [19:36:35.288] plantree_list = 0x55cfe50c1b88 [19:36:35.288] parsetree = 0x55cfe50c0bb0 [19:36:35.288] commandTag = [19:36:35.288] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:36:35.288] querytree_list = [19:36:35.288] portal = 0x55cfe5142d30 [19:36:35.288] receiver = 0x55cfe50c1bd8 [19:36:35.288] format = 0 [19:36:35.288] cmdtagname = [19:36:35.288] parsetree_item__state = [19:36:35.288] dest = DestRemote [19:36:35.288] oldcontext = 0x55cfe5155570 [19:36:35.288] parsetree_list = 0x55cfe50c0be0 [19:36:35.288] parsetree_item = 0x55cfe50c0bf8 [19:36:35.288] save_log_statement_stats = false [19:36:35.288] was_logged = true [19:36:35.288] use_implicit_block = false [19:36:35.288] msec_str = "\004\000\000\000\000\000\000\000u\265\234\263\317U\000\000@\235]\225\376\177\000\000G\000\000\000\000\000\000" [19:36:35.288] __func__ = "exec_simple_query" [19:36:35.288] #19 0x000055cfb370b09f in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [19:36:35.288] query_string = 0x55cfe50bfe40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:36:35.288] firstchar = [19:36:35.288] input_message = {data = 0x55cfe50bfe40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:36:35.288] local_sigjmp_buf = {{__jmpbuf = {94350572964760, -4033869998302729243, 140731404361404, 4, 5, 140731404361636, -7176887442647061531, -4033854453636568091}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94351389615840, 0, 168, 94350560107406, 0, 10, 2, 94350572964768, 94351389089376, 94350572958816, 4, 5, 140731404361636}}}} [19:36:35.288] send_ready_for_query = false [19:36:35.288] idle_in_transaction_timeout_enabled = false [19:36:35.288] idle_session_timeout_enabled = false [19:36:35.288] __func__ = "PostgresMain" [19:36:35.288] #20 0x000055cfb37010f5 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:36:35.288] bsdata = [19:36:35.288] #21 0x000055cfb35b1f3e in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7ffe955d9ebc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe955d9f10) at ../src/backend/postmaster/launch_backend.c:274 [19:36:35.288] pid = [19:36:35.288] #22 0x000055cfb35b7139 in BackendStartup (client_sock=client_sock@entry=0x7ffe955d9f10) at ../src/backend/postmaster/postmaster.c:3519 [19:36:35.288] bn = 0x55cfe50eb658 [19:36:35.288] pid = [19:36:35.288] startup_data = {canAcceptConnections = CAC_OK} [19:36:35.288] cac = [19:36:35.288] __func__ = "BackendStartup" [19:36:35.288] #23 0x000055cfb35b9209 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [19:36:35.288] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "#Y\246\177\000\000\240/\021Z\246\177\000\000\270\237]\225\376\177\000\000\264\237]\225\376\177", '\000' , "c8s\262\317U\000\000(\030o\262\317U\000\000\200\240]\225\376\177\000\000x\240]\225\376\177\000\000\225[\362\001\000\000\000\000\240\252\016\345\317U\000\000,", '\000' , "\317U\000\000q7s\262\317U\000", __ss_align = 140352462366312}, salen = 2}} [19:36:35.288] i = 0 [19:36:35.288] now = [19:36:35.288] last_lockfile_recheck_time = 1738265490 [19:36:35.288] last_touch_time = 1738265490 [19:36:35.288] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x0}, {pos = 1521067624, events = 32678, fd = 1510512176, user_data = 0x7fa65aa9a2e0}, {pos = 2090263927, events = 0, fd = -1789026048, user_data = 0x7fa65aa70a48}, {pos = 15, events = 0, fd = 1510512176, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fa65aa9a2e0}, {pos = -1789026184, events = 32766, fd = -1789026176, user_data = 0x7fa65aa9a668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -452196000, events = 21967, fd = 1, user_data = 0x7ffe955da5a3}, {pos = -1, events = 0, fd = 1495457824, user_data = 0x7fa65a112fa0}, {pos = -451978184, events = 21967, fd = -451978472, user_data = 0x55cfe50f0001}, {pos = 1520922302, events = 32678, fd = 1, user_data = 0x7fa65aa9a2e0}, {pos = 427, events = 0, fd = -1275708072, user_data = 0x0}, {pos = 86, events = 0, fd = -452012632, user_data = 0x7fa65aa76ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fa65922e020}, {pos = 1496264256, events = 32678, fd = 16, user_data = 0x7ffe955da4d0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1520931258, events = 32678, fd = 0, user_data = 0x7fa6592aeda4 }, {pos = 0, events = 0, fd = -1268669536, user_data = 0x2}, {pos = 0, events = 0, fd = -452452608, user_data = 0x55cfb369ebcf }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -452012632, user_data = 0x7fa65aa76ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fa6592364c8}, {pos = 1496018695, events = 32678, fd = -1268602240, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1497308256, events = 32678, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, 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 = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = 1510516032, events = 32678, fd = 1510517376, 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 = 1024, user_data = 0x7fa6592b576b}, {pos = 1497291232, events = 32678, fd = 1495929198, user_data = 0x100000400}, {pos = 7, events = 0, fd = -451983104, user_data = 0x295cfbaf4ad56800}, {pos = 1497294304, events = 32678, fd = -328, user_data = 0x0}, {pos = -451978792, events = 21967, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 32724, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -452012632, user_data = 0x7fa6592f3053 }, {pos = -451978792, events = 21967, fd = 1024, user_data = 0x7ffe955da598}, {pos = -1281372325, events = 21967, fd = -1268593840, user_data = 0x55cfb39eba18 }, {pos = -451978992, events = 21967, fd = -452199104, user_data = 0x55cfe50f5910}, {pos = 1496012651, events = 32678, fd = 0, user_data = 0x55cfb39fd682 }, {pos = -451978992, events = 1, fd = -1281370165, user_data = 0x55cfe50bfd40}, {pos = 1255499776, events = 693959599, fd = 0, user_data = 0x7fa6592a2ab1}, {pos = 1495930096, events = 32678, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -452452608, user_data = 0x295cfbaf4ad56800}, {pos = 0, events = 0, fd = 1255499776, user_data = 0xc}, {pos = 1255499776, events = 693959599, fd = 0, user_data = 0x7fa65925b239 }, {pos = 87, events = 0, fd = -1285874629, user_data = 0x400000}, {pos = 0, events = 0, fd = -452452608, user_data = 0x55cfb39eb8ac }, {pos = -452365200, events = 21967, fd = -452199104, user_data = 0x55cfe5097470}, {pos = 1, events = 0, fd = 0, user_data = 0x55cfb39aa0b1 }, {pos = 12, events = 0, fd = -452016680, user_data = 0x55cfe50ec5b8}, {pos = -1268668128, events = 21967, fd = 296, user_data = 0x55cfb35b4455 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1285858264, events = 21967, fd = -1272290640, user_data = 0x55cfe50c06f8}} [19:36:35.288] nevents = 1 [19:36:35.288] __func__ = "ServerLoop" [19:36:35.288] #24 0x000055cfb35baa68 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55cfe507dd60) at ../src/backend/postmaster/postmaster.c:1386 [19:36:35.288] opt = [19:36:35.288] status = [19:36:35.288] userDoption = [19:36:35.288] listen_addr_saved = false [19:36:35.288] output_config_variable = [19:36:35.288] __func__ = "PostmasterMain" [19:36:35.288] #25 0x000055cfb33ef5c9 in main (argc=4, argv=0x55cfe507dd60) at ../src/backend/main/main.c:230 [19:36:35.288] do_check_root = [19:36:35.288] dispatch_option = [19:36:35.327] -e [19:36:35.327] [19:36:35.327] [19:36:35.390] dumping /tmp/cores/postgres-6-30275.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:36:35.663] [New LWP 30275] [19:36:35.663] [19:36:35.663] This GDB supports auto-downloading debuginfo from the following URLs: [19:36:35.663] [19:36:35.663] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [19:36:35.663] Debuginfod has been disabled. [19:36:35.663] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [19:36:35.770] [Thread debugging using libthread_db enabled] [19:36:35.770] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [19:36:35.770] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [19:36:35.770] Program terminated with signal SIGABRT, Aborted. [19:36:35.770] #0 0x00007f88f48a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:36.773] [19:36:36.773] Thread 1 (Thread 0x7f88f2431f00 (LWP 30275)): [19:36:36.773] #0 0x00007f88f48a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:36.773] No symbol table info available. [19:36:36.773] #1 0x00007f88f485afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:36.773] No symbol table info available. [19:36:36.773] #2 0x00007f88f4845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:36.773] No symbol table info available. [19:36:36.773] #3 0x000055de0d4ed747 in ExceptionalCondition (conditionName=conditionName@entry=0x55de0d76a95d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55de0d769eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [19:36:36.773] No locals. [19:36:36.773] #4 0x000055de0ce58206 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55de4173cea0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [19:36:36.773] estate = 0x55de416e9ab0 [19:36:36.773] oldcontext = 0x55de41740b00 [19:36:36.773] __func__ = "standard_ExecutorStart" [19:36:36.773] #5 0x000055de0ce583e2 in ExecutorStart (queryDesc=queryDesc@entry=0x55de4173cea0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [19:36:36.773] No locals. [19:36:36.773] #6 0x000055de0cd776df in refresh_matview_datafill (dest=0x55de41760110, query=, query@entry=0x55de416fef40, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [19:36:36.773] rewritten = [19:36:36.773] plan = 0x55de4173c4f8 [19:36:36.773] queryDesc = 0x55de4173cea0 [19:36:36.773] copied_query = [19:36:36.773] processed = [19:36:36.773] __func__ = "refresh_matview_datafill" [19:36:36.773] #7 0x000055de0cd79a39 in RefreshMatViewByOid (matviewOid=28678, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [19:36:36.773] dest = [19:36:36.773] matviewRel = 0x7f88e90b1dc8 [19:36:36.773] rule = [19:36:36.773] actions = [19:36:36.773] dataQuery = 0x55de416fef40 [19:36:36.773] tableSpace = [19:36:36.773] relowner = 10 [19:36:36.773] OIDNewHeap = 28691 [19:36:36.773] processed = 0 [19:36:36.773] relpersistence = 112 'p' [19:36:36.773] save_userid = 10 [19:36:36.773] save_sec_context = 0 [19:36:36.773] save_nestlevel = 2 [19:36:36.773] address = {classId = 0, objectId = 0, objectSubId = 0} [19:36:36.773] __func__ = "RefreshMatViewByOid" [19:36:36.773] #8 0x000055de0cd79b78 in ExecRefreshMatView (stmt=0x55de4175fde8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:36:36.773] matviewOid = [19:36:36.773] lockmode = [19:36:36.773] #9 0x000055de0cd2f634 in ExecCreateTableAs (pstate=pstate@entry=0x55de41740c00, stmt=stmt@entry=0x55de415cdb60, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd227e25f0) at ../src/backend/commands/createas.c:351 [19:36:36.773] refresh = [19:36:36.773] query = 0x55de415cdd20 [19:36:36.773] into = 0x55de415cd8b8 [19:36:36.773] jstate = 0x0 [19:36:36.773] is_matview = true [19:36:36.773] do_refresh = false [19:36:36.773] dest = [19:36:36.773] address = {classId = 1259, objectId = 28678, objectSubId = 0} [19:36:36.773] __func__ = "ExecCreateTableAs" [19:36:36.773] #10 0x000055de0d25c297 in ProcessUtilitySlow (pstate=pstate@entry=0x55de41740c00, pstmt=pstmt@entry=0x55de415cdc10, queryString=queryString@entry=0x55de415cce20 "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=0x55de415ce648, qc=0x7ffd227e25f0) at ../src/backend/tcop/utility.c:1678 [19:36:36.773] _save_exception_stack = 0x7ffd227e24d0 [19:36:36.773] _save_context_stack = 0x0 [19:36:36.773] _local_sigjmp_buf = {{__jmpbuf = {0, 2253106191530272261, 94413067705184, 0, 94413067701792, 0, 5404990672392758789, 2252992604065703429}, __mask_was_saved = 0, __saved_mask = {__val = {28682, 0, 94412194963785, 140226156764600, 94413067701792, 94412197326867, 94412207499778, 94412207499904, 140725182145268, 94412197521721, 94412207499793, 94412207499904, 140725182145300, 94412197521736, 94412207499904, 0}}}} [19:36:36.773] _do_rethrow = false [19:36:36.773] parsetree = 0x55de415cdb60 [19:36:36.773] isTopLevel = true [19:36:36.773] isCompleteQuery = true [19:36:36.773] needCleanup = false [19:36:36.773] commandCollected = false [19:36:36.773] address = {classId = 21982, objectId = 1096604512, objectSubId = 21982} [19:36:36.773] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:36:36.773] __func__ = "ProcessUtilitySlow" [19:36:36.773] #11 0x000055de0d25a896 in standard_ProcessUtility (pstmt=0x55de415cdc10, queryString=0x55de415cce20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55de415ce648, qc=0x7ffd227e25f0) at ../src/backend/tcop/utility.c:1070 [19:36:36.773] parsetree = 0x55de415cdb60 [19:36:36.773] isTopLevel = true [19:36:36.773] isAtomicContext = false [19:36:36.773] pstate = 0x55de41740c00 [19:36:36.773] readonly_flags = [19:36:36.773] __func__ = "standard_ProcessUtility" [19:36:36.773] #12 0x000055de0d25a9f1 in ProcessUtility (pstmt=pstmt@entry=0x55de415cdc10, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55de415ce648, qc=0x7ffd227e25f0) at ../src/backend/tcop/utility.c:523 [19:36:36.773] No locals. [19:36:36.773] #13 0x000055de0d25639d in PortalRunUtility (portal=portal@entry=0x55de41651db0, pstmt=pstmt@entry=0x55de415cdc10, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55de415ce648, qc=qc@entry=0x7ffd227e25f0) at ../src/backend/tcop/pquery.c:1152 [19:36:36.773] No locals. [19:36:36.773] #14 0x000055de0d256948 in PortalRunMulti (portal=portal@entry=0x55de41651db0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55de415ce648, altdest=altdest@entry=0x55de415ce648, qc=qc@entry=0x7ffd227e25f0) at ../src/backend/tcop/pquery.c:1309 [19:36:36.773] pstmt = 0x55de415cdc10 [19:36:36.773] stmtlist_item__state = [19:36:36.773] active_snapshot_set = false [19:36:36.773] stmtlist_item = 0x55de415ce610 [19:36:36.773] #15 0x000055de0d256eb0 in PortalRun (portal=portal@entry=0x55de41651db0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55de415ce648, altdest=altdest@entry=0x55de415ce648, qc=qc@entry=0x7ffd227e25f0) at ../src/backend/tcop/pquery.c:787 [19:36:36.773] _save_exception_stack = 0x7ffd227e26a0 [19:36:36.773] _save_context_stack = 0x0 [19:36:36.773] _local_sigjmp_buf = {{__jmpbuf = {0, 2253106191336285701, 94413068246448, 94413067705304, 94413067705280, 94413067705232, 5404990672547948037, 2252992610536072709}, __mask_was_saved = 0, __saved_mask = {__val = {94412194650920, 578692479, 4, 94413067705232, 112, 73, 94413068246448, 94413067705304, 94413067705280, 94413067705232, 94412194738123, 1, 2, 73, 94412183984634, 0}}}} [19:36:36.773] _do_rethrow = [19:36:36.773] result = [19:36:36.773] nprocessed = [19:36:36.773] saveTopTransactionResourceOwner = 0x55de4160e868 [19:36:36.773] saveTopTransactionContext = 0x55de4165fcf0 [19:36:36.773] saveActivePortal = 0x0 [19:36:36.773] saveResourceOwner = 0x55de4160e868 [19:36:36.773] savePortalContext = 0x0 [19:36:36.773] saveMemoryContext = 0x55de4165fcf0 [19:36:36.773] __func__ = "PortalRun" [19:36:36.773] #16 0x000055de0d250346 in exec_simple_query (query_string=query_string@entry=0x55de415cce20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [19:36:36.773] cmdtaglen = 24 [19:36:36.773] snapshot_set = [19:36:36.773] per_parsetree_context = 0x0 [19:36:36.773] plantree_list = 0x55de415ce5f8 [19:36:36.773] parsetree = 0x55de415cdb90 [19:36:36.773] commandTag = [19:36:36.773] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:36:36.773] querytree_list = [19:36:36.773] portal = 0x55de41651db0 [19:36:36.773] receiver = 0x55de415ce648 [19:36:36.773] format = 0 [19:36:36.773] cmdtagname = [19:36:36.773] parsetree_item__state = [19:36:36.773] dest = DestRemote [19:36:36.773] oldcontext = 0x55de4165fcf0 [19:36:36.773] parsetree_list = 0x55de415cdbc0 [19:36:36.773] parsetree_item = 0x55de415cdbd8 [19:36:36.773] save_log_statement_stats = false [19:36:36.773] was_logged = true [19:36:36.773] use_implicit_block = false [19:36:36.773] msec_str = "\004\000\000\000\000\000\000\000u5Q\r\336U\000\000\200&~\"\375\177\000\000G\000\000\000\000\000\000" [19:36:36.773] __func__ = "exec_simple_query" [19:36:36.773] #17 0x000055de0d25309f in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [19:36:36.773] query_string = 0x55de415cce20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:36:36.773] firstchar = [19:36:36.773] input_message = {data = 0x55de415cce20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:36:36.773] local_sigjmp_buf = {{__jmpbuf = {94412207508376, 2252990257891190277, 140725182146556, 4, 9, 140725182146788, 5404990672615056901, 2252992608283862533}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94413067431456, 16128, 94412207502432, 94413067966496, 9, 94412194650468, 0, 9, 2, 94412207508384, 94413067431456, 94412207502432, 4, 9, 140725182146788}}}} [19:36:36.773] send_ready_for_query = false [19:36:36.773] idle_in_transaction_timeout_enabled = false [19:36:36.773] idle_session_timeout_enabled = false [19:36:36.773] __func__ = "PostgresMain" [19:36:36.773] #18 0x000055de0d2490f5 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:36:36.773] bsdata = [19:36:36.773] #19 0x000055de0d0f9f3e in postmaster_child_launch (child_type=B_BACKEND, child_slot=9, startup_data=startup_data@entry=0x7ffd227e27fc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd227e2850) at ../src/backend/postmaster/launch_backend.c:274 [19:36:36.773] pid = [19:36:36.773] #20 0x000055de0d0ff139 in BackendStartup (client_sock=client_sock@entry=0x7ffd227e2850) at ../src/backend/postmaster/postmaster.c:3519 [19:36:36.773] bn = 0x55de415f5498 [19:36:36.773] pid = [19:36:36.773] startup_data = {canAcceptConnections = CAC_OK} [19:36:36.773] cac = [19:36:36.773] __func__ = "BackendStartup" [19:36:36.773] #21 0x000055de0d101209 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [19:36:36.773] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\203\364\210\177\000\000\240?\327\365\210\177\000\000\370(~\"\375\177\000\000\364(~\"\375\177", '\000' , "c\270'\f\336U\000\000(\230#\f\336U\000\000\300)~\"\375\177\000\000\270)~\"\375\177\000\000\225[\362\001\000\000\000\000\240\344\003\365\210\177\000\000+", '\000' , "\336U\000\000q\267'\f\336U\000", __ss_align = 140226221033064}, salen = 2}} [19:36:36.773] i = 0 [19:36:36.773] now = [19:36:36.773] last_lockfile_recheck_time = 1738265453 [19:36:36.773] last_touch_time = 1738265453 [19:36:36.773] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x0}, {pos = -166214040, events = 32648, fd = -184293840, user_data = 0x7f88f617c2e0}, {pos = 2090263927, events = 0, fd = 578693696, user_data = 0x7f88f6152a48}, {pos = 15, events = 0, fd = -184293840, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f88f617c2e0}, {pos = 578693560, events = 32765, fd = 578693568, user_data = 0x7f88f617c668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 1096608464, events = 21982, fd = 1, user_data = 0x7ffd227e2ee3}, {pos = -1, events = 0, fd = -192749536, user_data = 0x7f88f5d73fa0}, {pos = 1096786728, events = 21982, fd = 1096786440, user_data = 0x55de415f9fe1}, {pos = -166359362, events = 32648, fd = 1, user_data = 0x7f88f617c2e0}, {pos = 427, events = 0, fd = 229293400, user_data = 0x0}, {pos = 229, events = 0, fd = 1096601144, user_data = 0x7f88f6158ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f88f482e020}, {pos = -191943104, events = 32648, fd = 16, user_data = 0x7ffd227e2e10}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -166350406, events = 32648, fd = 0, user_data = 0x7f88f48aeda4 }, {pos = 0, events = 0, fd = 236331936, user_data = 0x2}, {pos = 0, events = 0, fd = 1096347328, user_data = 0x55de0d1e6bcf }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 1096601144, user_data = 0x7f88f6158ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f88f48364c8}, {pos = -192188307, events = 32648, fd = 236399232, user_data = 0x55de415ff7c0}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -190899104, events = 32648, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffff0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {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 = 0x0}, {pos = 0, events = 0, fd = 1024, user_data = 0x7f88f48b58be}, {pos = -190916128, events = 32648, fd = -192278162, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1096786960, user_data = 0xf777291e669f1f00}, {pos = -190913056, events = 32648, fd = -328, user_data = 0x0}, {pos = 1096786120, events = 21982, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 26263, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1096601144, user_data = 0x7f88f48f3053 }, {pos = 1096786120, events = 21982, fd = 1024, user_data = 0x7ffd227e2ed8}, {pos = 223629147, events = 21982, fd = 236407632, user_data = 0x55de0d533a18 }, {pos = 1096785920, events = 21982, fd = 1096600864, user_data = 0x55de415fa000}, {pos = -192194370, events = 32648, fd = 0, user_data = 0x55de0d545682 }, {pos = 1096785920, events = 1, fd = 223631307, user_data = 0x55de415ccd20}, {pos = 1721704192, events = 4151781662, fd = 0, user_data = 0x7f88f48a2ab1}, {pos = -192277264, events = 32648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1096347328, user_data = 0xf777291e669f1f00}, {pos = 0, events = 0, fd = 1721704192, user_data = 0xc}, {pos = 1721704192, events = 4151781662, fd = 0, user_data = 0x7f88f485b239 }, {pos = 230, events = 0, fd = 219126843, user_data = 0x400000}, {pos = 0, events = 0, fd = 1096347328, user_data = 0x55de0d5338ac }, {pos = 1096434768, events = 21982, fd = 1096600864, user_data = 0x55de415a4450}, {pos = 1, events = 0, fd = 0, user_data = 0x55de0d4f20b1 }, {pos = 12, events = 0, fd = 1096777256, user_data = 0x55de415f7e08}, {pos = 236333344, events = 21982, fd = 296, user_data = 0x55de0d0fc455 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 219143208, events = 21982, fd = 232710832, user_data = 0x55de415cd6c8}} [19:36:36.773] nevents = 1 [19:36:36.773] __func__ = "ServerLoop" [19:36:36.773] #22 0x000055de0d102a68 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55de4158ad30) at ../src/backend/postmaster/postmaster.c:1386 [19:36:36.773] opt = [19:36:36.773] status = [19:36:36.773] userDoption = [19:36:36.773] listen_addr_saved = false [19:36:36.773] output_config_variable = [19:36:36.773] __func__ = "PostmasterMain" [19:36:36.773] #23 0x000055de0cf375c9 in main (argc=4, argv=0x55de4158ad30) at ../src/backend/main/main.c:230 [19:36:36.773] do_check_root = [19:36:36.773] dispatch_option = [19:36:36.812] -e [19:36:36.812] [19:36:36.812] [19:36:36.873] dumping /tmp/cores/postgres-6-29648.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [19:36:37.135] [New LWP 29648] [19:36:37.135] [19:36:37.135] This GDB supports auto-downloading debuginfo from the following URLs: [19:36:37.135] [19:36:37.135] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [19:36:37.135] Debuginfod has been disabled. [19:36:37.135] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [19:36:37.236] [Thread debugging using libthread_db enabled] [19:36:37.236] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [19:36:37.236] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [19:36:37.236] Program terminated with signal SIGABRT, Aborted. [19:36:37.236] #0 0x00007fb4310a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:38.248] [19:36:38.248] Thread 1 (Thread 0x7fb431e87f00 (LWP 29648)): [19:36:38.248] #0 0x00007fb4310a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:38.248] No symbol table info available. [19:36:38.248] #1 0x00007fb43105afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:38.248] No symbol table info available. [19:36:38.248] #2 0x00007fb431045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [19:36:38.248] No symbol table info available. [19:36:38.248] #3 0x0000556fb5d68747 in ExceptionalCondition (conditionName=conditionName@entry=0x556fb5fe595d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x556fb5fe4eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [19:36:38.248] No locals. [19:36:38.248] #4 0x0000556fb56d3206 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x556feb6005c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [19:36:38.248] estate = 0x556feb5a34d0 [19:36:38.248] oldcontext = 0x556feb651210 [19:36:38.248] __func__ = "standard_ExecutorStart" [19:36:38.248] #5 0x0000556fb56d33e2 in ExecutorStart (queryDesc=queryDesc@entry=0x556feb6005c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [19:36:38.248] No locals. [19:36:38.248] #6 0x0000556fb55f26df in refresh_matview_datafill (dest=0x556feb634ec0, query=, query@entry=0x556feb5d0330, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [19:36:38.248] rewritten = [19:36:38.248] plan = 0x556feb5ffc18 [19:36:38.248] queryDesc = 0x556feb6005c0 [19:36:38.248] copied_query = [19:36:38.248] processed = [19:36:38.248] __func__ = "refresh_matview_datafill" [19:36:38.248] #7 0x0000556fb55f4a39 in RefreshMatViewByOid (matviewOid=28480, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [19:36:38.248] dest = [19:36:38.248] matviewRel = 0x7fb4254f9990 [19:36:38.248] rule = [19:36:38.248] actions = [19:36:38.248] dataQuery = 0x556feb5d0330 [19:36:38.248] tableSpace = [19:36:38.248] relowner = 10 [19:36:38.248] OIDNewHeap = 28508 [19:36:38.248] processed = 0 [19:36:38.248] relpersistence = 112 'p' [19:36:38.248] save_userid = 10 [19:36:38.248] save_sec_context = 0 [19:36:38.248] save_nestlevel = 2 [19:36:38.248] address = {classId = 0, objectId = 0, objectSubId = 0} [19:36:38.248] __func__ = "RefreshMatViewByOid" [19:36:38.248] #8 0x0000556fb55f4b78 in ExecRefreshMatView (stmt=0x556feb634b98, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:36:38.248] matviewOid = [19:36:38.248] lockmode = [19:36:38.248] #9 0x0000556fb55aa634 in ExecCreateTableAs (pstate=pstate@entry=0x556feb651310, stmt=stmt@entry=0x556feb4927f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff47d848e0) at ../src/backend/commands/createas.c:351 [19:36:38.248] refresh = [19:36:38.248] query = 0x556feb4929b0 [19:36:38.248] into = 0x556feb492548 [19:36:38.248] jstate = 0x0 [19:36:38.248] is_matview = true [19:36:38.248] do_refresh = false [19:36:38.248] dest = [19:36:38.248] address = {classId = 1259, objectId = 28480, objectSubId = 0} [19:36:38.248] __func__ = "ExecCreateTableAs" [19:36:38.248] #10 0x0000556fb5ad7297 in ProcessUtilitySlow (pstate=pstate@entry=0x556feb651310, pstmt=pstmt@entry=0x556feb4928a0, queryString=queryString@entry=0x556feb491ab0 "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=0x556feb4932d8, qc=0x7fff47d848e0) at ../src/backend/tcop/utility.c:1678 [19:36:38.248] _save_exception_stack = 0x7fff47d847c0 [19:36:38.248] _save_context_stack = 0x0 [19:36:38.248] _local_sigjmp_buf = {{__jmpbuf = {0, -403313796433928749, 93939177170928, 0, 93939177167536, 0, -5816824292424639021, -403184360684741165}, __mask_was_saved = 0, __saved_mask = {__val = {28484, 0, 93938280745768, 625973648, 93939178292120, 0, 93938277527482, 0, 93938277188388, 140411845778048, 39449274613760, 140411704902308, 93938280214772, 9185, 93938277188388, 140411697300896}}}} [19:36:38.248] _do_rethrow = false [19:36:38.248] parsetree = 0x556feb4927f0 [19:36:38.248] isTopLevel = true [19:36:38.248] isCompleteQuery = true [19:36:38.248] needCleanup = false [19:36:38.248] commandCollected = false [19:36:38.248] address = {classId = 21871, objectId = 3947440112, objectSubId = 21871} [19:36:38.248] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:36:38.248] __func__ = "ProcessUtilitySlow" [19:36:38.248] #11 0x0000556fb5ad5896 in standard_ProcessUtility (pstmt=0x556feb4928a0, queryString=0x556feb491ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x556feb4932d8, qc=0x7fff47d848e0) at ../src/backend/tcop/utility.c:1070 [19:36:38.248] parsetree = 0x556feb4927f0 [19:36:38.248] isTopLevel = true [19:36:38.248] isAtomicContext = false [19:36:38.248] pstate = 0x556feb651310 [19:36:38.248] readonly_flags = [19:36:38.248] __func__ = "standard_ProcessUtility" [19:36:38.248] #12 0x0000556fb5ad59f1 in ProcessUtility (pstmt=pstmt@entry=0x556feb4928a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x556feb4932d8, qc=0x7fff47d848e0) at ../src/backend/tcop/utility.c:523 [19:36:38.248] No locals. [19:36:38.248] #13 0x0000556fb5ad139d in PortalRunUtility (portal=portal@entry=0x556feb516fc0, pstmt=pstmt@entry=0x556feb4928a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556feb4932d8, qc=qc@entry=0x7fff47d848e0) at ../src/backend/tcop/pquery.c:1152 [19:36:38.248] No locals. [19:36:38.248] #14 0x0000556fb5ad1948 in PortalRunMulti (portal=portal@entry=0x556feb516fc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556feb4932d8, altdest=altdest@entry=0x556feb4932d8, qc=qc@entry=0x7fff47d848e0) at ../src/backend/tcop/pquery.c:1309 [19:36:38.248] pstmt = 0x556feb4928a0 [19:36:38.248] stmtlist_item__state = [19:36:38.248] active_snapshot_set = false [19:36:38.248] stmtlist_item = 0x556feb4932a0 [19:36:38.248] #15 0x0000556fb5ad1eb0 in PortalRun (portal=portal@entry=0x556feb516fc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x556feb4932d8, altdest=altdest@entry=0x556feb4932d8, qc=qc@entry=0x7fff47d848e0) at ../src/backend/tcop/pquery.c:787 [19:36:38.248] _save_exception_stack = 0x7fff47d84990 [19:36:38.248] _save_context_stack = 0x0 [19:36:38.248] _local_sigjmp_buf = {{__jmpbuf = {0, -403313796770521645, 93939177713600, 93939177171048, 93939177171024, 93939177170976, -5816824292554662445, -403184362937737773}, __mask_was_saved = 0, __saved_mask = {__val = {93938280745768, 1205356655, 4, 93939177170976, 112, 73, 93939177713600, 93939177171048, 93939177171024, 93939177170976, 93938280832971, 1, 2, 73, 93938270079482, 0}}}} [19:36:38.248] _do_rethrow = [19:36:38.248] result = [19:36:38.248] nprocessed = [19:36:38.248] saveTopTransactionResourceOwner = 0x556feb4d4d88 [19:36:38.248] saveTopTransactionContext = 0x556feb5293f0 [19:36:38.248] saveActivePortal = 0x0 [19:36:38.248] saveResourceOwner = 0x556feb4d4d88 [19:36:38.248] savePortalContext = 0x0 [19:36:38.248] saveMemoryContext = 0x556feb5293f0 [19:36:38.248] __func__ = "PortalRun" [19:36:38.248] #16 0x0000556fb5acb346 in exec_simple_query (query_string=query_string@entry=0x556feb491ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [19:36:38.248] cmdtaglen = 24 [19:36:38.248] snapshot_set = [19:36:38.248] per_parsetree_context = 0x0 [19:36:38.248] plantree_list = 0x556feb493288 [19:36:38.248] parsetree = 0x556feb492820 [19:36:38.248] commandTag = [19:36:38.248] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:36:38.248] querytree_list = [19:36:38.248] portal = 0x556feb516fc0 [19:36:38.248] receiver = 0x556feb4932d8 [19:36:38.248] format = 0 [19:36:38.248] cmdtagname = [19:36:38.248] parsetree_item__state = [19:36:38.248] dest = DestRemote [19:36:38.248] oldcontext = 0x556feb5293f0 [19:36:38.248] parsetree_list = 0x556feb492850 [19:36:38.248] parsetree_item = 0x556feb492868 [19:36:38.248] save_log_statement_stats = false [19:36:38.248] was_logged = false [19:36:38.248] use_implicit_block = false [19:36:38.248] msec_str = "\004\000\000\000\000\000\000\000u\345صoU\000\000pI\330G\377\177\000\000G\000\000\000\000\000\000" [19:36:38.248] __func__ = "exec_simple_query" [19:36:38.248] #17 0x0000556fb5ace09f in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [19:36:38.248] query_string = 0x556feb491ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:36:38.248] firstchar = [19:36:38.248] input_message = {data = 0x556feb491ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:36:38.248] local_sigjmp_buf = {{__jmpbuf = {93938293603224, -403178189921542701, 140734398745324, 4, 11, 140734398745556, -5816824292621771309, -403184356315062829}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93939176898000, 17408, 93938293597280, 93939177432368, 11, 93938280745316, 0, 10, 2, 93938293603232, 93939176898000, 93938293597280, 4, 11, 140734398745556}}}} [19:36:38.248] send_ready_for_query = false [19:36:38.248] idle_in_transaction_timeout_enabled = false [19:36:38.248] idle_session_timeout_enabled = false [19:36:38.248] __func__ = "PostgresMain" [19:36:38.248] #18 0x0000556fb5ac40f5 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:36:38.248] bsdata = [19:36:38.248] #19 0x0000556fb5974f3e in postmaster_child_launch (child_type=B_BACKEND, child_slot=11, startup_data=startup_data@entry=0x7fff47d84aec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff47d84b40) at ../src/backend/postmaster/launch_backend.c:274 [19:36:38.248] pid = [19:36:38.248] #20 0x0000556fb597a139 in BackendStartup (client_sock=client_sock@entry=0x7fff47d84b40) at ../src/backend/postmaster/postmaster.c:3519 [19:36:38.248] bn = 0x556feb4ba208 [19:36:38.248] pid = [19:36:38.248] startup_data = {canAcceptConnections = CAC_OK} [19:36:38.248] cac = [19:36:38.248] __func__ = "BackendStartup" [19:36:38.248] #21 0x0000556fb597c209 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [19:36:38.248] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\2142\264\177\000\000>\004\000\000\000\000\000\000\260\227\0031\264\177\000\000\240\177T2\264\177\000\000\370K\330G\377\177\000\000\364K\330G\377\177", '\000' , "ch\257\264oU\000\000(H\253\264oU\000\000\300L\330G\377\177\000\000\270L\330G\377\177\000\000\225[\362\001\231j\264\212\240\344\3501\264\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [19:36:38.248] i = 0 [19:36:38.248] now = [19:36:38.248] last_lockfile_recheck_time = 1738265450 [19:36:38.248] last_touch_time = 1738265450 [19:36:38.248] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 1205357824, user_data = 0x0}, {pos = 15, events = 0, fd = -1263572893, user_data = 0x7fb4328f1668}, {pos = 837346864, events = 32692, fd = 848237280, user_data = 0x7c96e577}, {pos = 1205357888, events = 32767, fd = 848067144, user_data = 0xf}, {pos = 837346864, events = 32692, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 848237280, user_data = 0x7fff47d84cb8}, {pos = 1205357760, events = 32767, fd = 848238184, user_data = 0x0}, {pos = -347523168, events = 21871, fd = 823061861, user_data = 0x7fff47d851d3}, {pos = 1, events = 0, fd = 1205357760, user_data = 0xffffffff}, {pos = 822272032, events = 32692, fd = 844398496, user_data = 0x556feb4bf3f8}, {pos = -347344168, events = 21871, fd = -347344719, user_data = 0x7fb4328cdebe}, {pos = 1, events = 0, fd = 848237280, user_data = 0x1ab}, {pos = -1238209192, events = 21871, fd = 0, user_data = 0xf9}, {pos = -347530384, events = 21871, fd = 848092862, user_data = 0x1}, {pos = 0, events = 0, fd = 822272032, user_data = 0x7fb4310f2e40 }, {pos = 16, events = 0, fd = 1205358848, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fb4328d01ba}, {pos = 0, events = 0, fd = 822799780, user_data = 0x0}, {pos = -1231170656, events = 21871, fd = 2, user_data = 0x0}, {pos = -347783568, events = 21871, fd = 1952410737, user_data = 0x161}, {pos = -1238209784, events = 21871, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -347530384, events = 21871, fd = 848092862, user_data = 0x1}, {pos = 822833261, events = 32692, fd = 822305992, user_data = 0x556feb4c44d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 824122464, events = 32692, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x556feb453e70}, {pos = 822835850, events = 32692, 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 = 1432842102, fd = 168450129, user_data = 0x32383337310a6174}, {pos = 892613942, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, 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 = 0x0}, {pos = 824105440, events = 32692, fd = 822743406, user_data = 0x100000400}, {pos = 7, events = 0, fd = -347343648, user_data = 0x8ab46a99b3901d00}, {pos = 824108512, events = 32692, fd = -328, user_data = 0x0}, {pos = -347344488, events = 21871, fd = 1024, user_data = 0x556feb4bf198}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 25600, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -347530384, user_data = 0x7fb4310f3053 }, {pos = -347344488, events = 21871, fd = 1024, user_data = 0x7fff47d851c8}, {pos = -1243873445, events = 21871, fd = -1231094960, user_data = 0x556fb5daea18 }, {pos = -347344688, events = 21871, fd = -347530832, user_data = 0x556feb4bf0d0}, {pos = 822827198, events = 32692, fd = 0, user_data = 0x556fb5dc0682 }, {pos = -347344688, events = 1, fd = -1243871285, user_data = 0x556feb4919b0}, {pos = -1282401024, events = 2327079577, fd = 0, user_data = 0x7fb4310a2ab1}, {pos = 822744304, events = 32692, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -347783568, user_data = 0x8ab46a99b3901d00}, {pos = 0, events = 0, fd = -1282401024, user_data = 0xc}, {pos = -1282401024, events = 2327079577, fd = 0, user_data = 0x7fb43105b239 }, {pos = 250, events = 0, fd = -1248375749, user_data = 0x400000}, {pos = 0, events = 0, fd = -347783568, user_data = 0x556fb5dae8ac }, {pos = -347696928, events = 21871, fd = -347530832, user_data = 0x556feb4690e0}, {pos = 1, events = 0, fd = 0, user_data = 0x556fb5d6d0b1 }, {pos = 12, events = 0, fd = -347353352, user_data = 0x556feb4bced8}, {pos = -1231169248, events = 21871, fd = 296, user_data = 0x556fb5977455 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1248359384, events = 21871, fd = -1234791760, user_data = 0x556feb492388}} [19:36:38.249] nevents = 1 [19:36:38.249] __func__ = "ServerLoop" [19:36:38.249] #22 0x0000556fb597da68 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x556feb44fd30) at ../src/backend/postmaster/postmaster.c:1386 [19:36:38.249] opt = [19:36:38.249] status = [19:36:38.249] userDoption = [19:36:38.249] listen_addr_saved = false [19:36:38.249] output_config_variable = [19:36:38.249] __func__ = "PostmasterMain" [19:36:38.249] #23 0x0000556fb57b25c9 in main (argc=8, argv=0x556feb44fd30) at ../src/backend/main/main.c:230 [19:36:38.249] do_check_root = [19:36:38.249] dispatch_option =