[00:17:55.262] src/tools/ci/cores_backtrace.sh linux /tmp/cores [00:17:55.458] dumping /tmp/cores/postgres-6-36675.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:17:55.707] [New LWP 36675] [00:17:55.707] [00:17:55.707] This GDB supports auto-downloading debuginfo from the following URLs: [00:17:55.707] [00:17:55.707] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [00:17:55.707] Debuginfod has been disabled. [00:17:55.707] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [00:17:55.826] [Thread debugging using libthread_db enabled] [00:17:55.826] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:17:55.826] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [00:17:55.826] Program terminated with signal SIGABRT, Aborted. [00:17:55.826] #0 0x00007f9ad06a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:56.726] [00:17:56.726] Thread 1 (Thread 0x7f9ace61af00 (LWP 36675)): [00:17:56.726] #0 0x00007f9ad06a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:56.726] No symbol table info available. [00:17:56.726] #1 0x00007f9ad065afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:56.726] No symbol table info available. [00:17:56.726] #2 0x00007f9ad0645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:56.726] No symbol table info available. [00:17:56.726] #3 0x000055b1585f9347 in ExceptionalCondition (conditionName=conditionName@entry=0x55b15887695d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55b158875eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [00:17:56.726] No locals. [00:17:56.726] #4 0x000055b157f640af in standard_ExecutorStart (queryDesc=0x55b17528be80, eflags=0) at ../src/backend/executor/execMain.c:193 [00:17:56.726] estate = 0x55b1750cb7c0 [00:17:56.726] oldcontext = 0x55b175201580 [00:17:56.726] __func__ = "standard_ExecutorStart" [00:17:56.726] #5 0x00007f9acdd2d6e9 in pgss_ExecutorStart (queryDesc=0x55b17528be80, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [00:17:56.726] No locals. [00:17:56.726] #6 0x000055b157f64244 in ExecutorStart (queryDesc=queryDesc@entry=0x55b17528be80, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [00:17:56.726] No locals. [00:17:56.726] #7 0x000055b157e836c7 in refresh_matview_datafill (dest=0x55b1751d7a60, query=, query@entry=0x55b1751ffe90, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [00:17:56.726] rewritten = [00:17:56.726] plan = 0x55b17528b4d8 [00:17:56.726] queryDesc = 0x55b17528be80 [00:17:56.726] copied_query = [00:17:56.726] processed = [00:17:56.726] __func__ = "refresh_matview_datafill" [00:17:56.726] #8 0x000055b157e85a21 in RefreshMatViewByOid (matviewOid=28530, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [00:17:56.726] dest = [00:17:56.726] matviewRel = 0x7f9acc025dd0 [00:17:56.726] rule = [00:17:56.726] actions = [00:17:56.726] dataQuery = 0x55b1751ffe90 [00:17:56.726] tableSpace = [00:17:56.726] relowner = 10 [00:17:56.726] OIDNewHeap = 28537 [00:17:56.726] processed = 0 [00:17:56.726] relpersistence = 112 'p' [00:17:56.726] save_userid = 10 [00:17:56.726] save_sec_context = 0 [00:17:56.726] save_nestlevel = 2 [00:17:56.726] address = {classId = 0, objectId = 0, objectSubId = 0} [00:17:56.726] __func__ = "RefreshMatViewByOid" [00:17:56.726] #9 0x000055b157e85b60 in ExecRefreshMatView (stmt=0x55b1751d7738, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:17:56.726] matviewOid = [00:17:56.726] lockmode = [00:17:56.726] #10 0x000055b157e3b634 in ExecCreateTableAs (pstate=pstate@entry=0x55b175201680, stmt=stmt@entry=0x55b175070b80, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffba8e6c40) at ../src/backend/commands/createas.c:351 [00:17:56.726] refresh = [00:17:56.726] query = 0x55b175070d40 [00:17:56.726] into = 0x55b1750708d8 [00:17:56.726] jstate = 0x0 [00:17:56.726] is_matview = true [00:17:56.726] do_refresh = false [00:17:56.726] dest = [00:17:56.726] address = {classId = 1259, objectId = 28530, objectSubId = 0} [00:17:56.726] __func__ = "ExecCreateTableAs" [00:17:56.726] #11 0x000055b158367eb5 in ProcessUtilitySlow (pstate=pstate@entry=0x55b175201680, pstmt=pstmt@entry=0x55b175070c30, queryString=queryString@entry=0x55b17506fe40 "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=0x55b175071bd8, qc=0x7fffba8e6c40) at ../src/backend/tcop/utility.c:1678 [00:17:56.726] _save_exception_stack = 0x7fffba8e6810 [00:17:56.726] _save_context_stack = 0x0 [00:17:56.726] _local_sigjmp_buf = {{__jmpbuf = {0, 5849350095396582286, 94220660968320, 0, 94220660964928, 0, 409985867678135182, 5849413445398606734}, __mask_was_saved = 0, __saved_mask = {__val = {3, 5, 1, 5, 1, 1, 94220660971904, 94220660972704, 94220180597298, 1964869528, 94220180506087, 94220660964672, 140736323283008, 0, 94220180822435, 140736323282204}}}} [00:17:56.726] _do_rethrow = false [00:17:56.726] parsetree = 0x55b175070b80 [00:17:56.726] isTopLevel = true [00:17:56.726] isCompleteQuery = true [00:17:56.726] needCleanup = false [00:17:56.726] commandCollected = false [00:17:56.726] address = {classId = 21937, objectId = 1963395968, objectSubId = 21937} [00:17:56.726] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:17:56.726] __func__ = "ProcessUtilitySlow" [00:17:56.726] #12 0x000055b1583664c6 in standard_ProcessUtility (pstmt=pstmt@entry=0x55b175070c30, queryString=queryString@entry=0x55b17506fe40 "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=0x55b175071bd8, qc=0x7fffba8e6c40) at ../src/backend/tcop/utility.c:1070 [00:17:56.726] parsetree = 0x55b175070b80 [00:17:56.726] isTopLevel = true [00:17:56.726] isAtomicContext = false [00:17:56.726] pstate = 0x55b175201680 [00:17:56.726] readonly_flags = [00:17:56.726] __func__ = "standard_ProcessUtility" [00:17:56.726] #13 0x00007f9acdd30d8f in pgss_ProcessUtility (pstmt=0x55b175070c30, queryString=0x55b17506fe40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55b175071bd8, qc=0x7fffba8e6c40) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [00:17:56.726] _save_exception_stack = 0x7fffba8e6b20 [00:17:56.726] _save_context_stack = 0x0 [00:17:56.726] _local_sigjmp_buf = {{__jmpbuf = {0, -409833176603380850, 94220660968496, 94220660972504, 140736323284032, 0, 409985867841713038, 394734860601045902}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140736323283264, 94220180830134, 1, 206158430232, 94220660969296, 140736323283360, 0, 94220175590447, 94220660964672, 94220180489652, 3, 94220174312500, 94220660968496}}}} [00:17:56.726] _do_rethrow = false [00:17:56.726] duration = [00:17:56.726] bufusage = {shared_blks_hit = 1, shared_blks_read = 8, shared_blks_dirtied = 140302827237184, shared_blks_written = 140302827237184, local_blks_hit = 1, local_blks_read = 94220176963251, local_blks_dirtied = 94220661343368, local_blks_written = 94220180823369, temp_blks_read = 140302864199096, temp_blks_written = 94220660964928, shared_blk_read_time = {ticks = 94220183187475}, shared_blk_write_time = {ticks = 94220193359586}, local_blk_read_time = {ticks = 94220193359712}, local_blk_write_time = {ticks = 140736323283268}, temp_blk_read_time = {ticks = 94220183382329}, temp_blk_write_time = {ticks = 94220193359601}} [00:17:56.726] walusage_start = {wal_records = 8972, wal_fpi = 131, wal_bytes = 1223830} [00:17:56.726] start = [00:17:56.726] rows = [00:17:56.726] bufusage_start = {shared_blks_hit = 34342, shared_blks_read = 4350, shared_blks_dirtied = 1515, shared_blks_written = 1101, 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}} [00:17:56.726] walusage = {wal_records = 140302830359744, wal_fpi = 34359738368, wal_bytes = 140302827237220} [00:17:56.726] parsetree = [00:17:56.726] saved_queryId = 7267788456574341698 [00:17:56.726] saved_stmt_location = 0 [00:17:56.726] saved_stmt_len = 69 [00:17:56.726] enabled = true [00:17:56.726] #14 0x000055b15836656c in ProcessUtility (pstmt=pstmt@entry=0x55b175070c30, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55b175071bd8, qc=0x7fffba8e6c40) at ../src/backend/tcop/utility.c:519 [00:17:56.726] No locals. [00:17:56.726] #15 0x000055b158361fdf in PortalRunUtility (portal=portal@entry=0x55b1750f2d30, pstmt=pstmt@entry=0x55b175070c30, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55b175071bd8, qc=qc@entry=0x7fffba8e6c40) at ../src/backend/tcop/pquery.c:1152 [00:17:56.726] No locals. [00:17:56.726] #16 0x000055b158362584 in PortalRunMulti (portal=portal@entry=0x55b1750f2d30, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55b175071bd8, altdest=altdest@entry=0x55b175071bd8, qc=qc@entry=0x7fffba8e6c40) at ../src/backend/tcop/pquery.c:1309 [00:17:56.726] pstmt = 0x55b175070c30 [00:17:56.726] stmtlist_item__state = [00:17:56.726] active_snapshot_set = false [00:17:56.726] stmtlist_item = 0x55b175071ba0 [00:17:56.726] #17 0x000055b158362aec in PortalRun (portal=portal@entry=0x55b1750f2d30, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55b175071bd8, altdest=altdest@entry=0x55b175071bd8, qc=qc@entry=0x7fffba8e6c40) at ../src/backend/tcop/pquery.c:787 [00:17:56.726] _save_exception_stack = 0x7fffba8e6cf0 [00:17:56.726] _save_context_stack = 0x0 [00:17:56.726] _local_sigjmp_buf = {{__jmpbuf = {0, 5849350094755902350, 94220661501232, 94220660968440, 94220660968416, 94220660968368, 409985867411796878, 5849413447173452686}, __mask_was_saved = 0, __saved_mask = {__val = {94220180510504, 3129895887, 4, 94220660968368, 112, 73, 94220661501232, 94220660968440, 94220660968416, 94220660968368, 94220180597707, 1, 2, 73, 94220169845242, 0}}}} [00:17:56.726] _do_rethrow = [00:17:56.726] result = [00:17:56.726] nprocessed = [00:17:56.726] saveTopTransactionResourceOwner = 0x55b1750b4738 [00:17:56.726] saveTopTransactionContext = 0x55b175105570 [00:17:56.726] saveActivePortal = 0x0 [00:17:56.726] saveResourceOwner = 0x55b1750b4738 [00:17:56.726] savePortalContext = 0x0 [00:17:56.726] saveMemoryContext = 0x55b175105570 [00:17:56.726] __func__ = "PortalRun" [00:17:56.726] #18 0x000055b15835bfa4 in exec_simple_query (query_string=query_string@entry=0x55b17506fe40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [00:17:56.726] cmdtaglen = 24 [00:17:56.726] snapshot_set = [00:17:56.726] per_parsetree_context = 0x0 [00:17:56.726] plantree_list = 0x55b175071b88 [00:17:56.726] parsetree = 0x55b175070bb0 [00:17:56.726] commandTag = [00:17:56.726] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:17:56.726] querytree_list = [00:17:56.726] portal = 0x55b1750f2d30 [00:17:56.726] receiver = 0x55b175071bd8 [00:17:56.726] format = 0 [00:17:56.726] cmdtagname = [00:17:56.726] parsetree_item__state = [00:17:56.726] dest = DestRemote [00:17:56.726] oldcontext = 0x55b175105570 [00:17:56.726] parsetree_list = 0x55b175070be0 [00:17:56.726] parsetree_item = 0x55b175070bf8 [00:17:56.726] save_log_statement_stats = false [00:17:56.726] was_logged = true [00:17:56.726] use_implicit_block = false [00:17:56.726] msec_str = "\004\000\000\000\000\000\000\000u\361aX\261U\000\000\320l\216\272\377\177\000\000G\000\000\000\000\000\000" [00:17:56.726] __func__ = "exec_simple_query" [00:17:56.726] #19 0x000055b15835ecfd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [00:17:56.726] query_string = 0x55b17506fe40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:17:56.726] firstchar = [00:17:56.726] input_message = {data = 0x55b17506fe40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:17:56.726] local_sigjmp_buf = {{__jmpbuf = {94220193368184, 5849411435974800270, 140736323284556, 4, 8, 140736323284788, 409985867478905742, 5849413466828092302}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94220661221088, 0, 168, 94220180510606, 0, 10, 2, 94220193368192, 94220660694624, 94220193362240, 4, 8, 140736323284788}}}} [00:17:56.726] send_ready_for_query = false [00:17:56.726] idle_in_transaction_timeout_enabled = false [00:17:56.726] idle_session_timeout_enabled = false [00:17:56.726] __func__ = "PostgresMain" [00:17:56.726] #20 0x000055b158354d68 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:17:56.726] bsdata = [00:17:56.726] #21 0x000055b158205bb1 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x7fffba8e6e4c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffba8e6ea0) at ../src/backend/postmaster/launch_backend.c:274 [00:17:56.726] pid = [00:17:56.726] #22 0x000055b15820adac in BackendStartup (client_sock=client_sock@entry=0x7fffba8e6ea0) at ../src/backend/postmaster/postmaster.c:3519 [00:17:56.726] bn = 0x55b17509b6e8 [00:17:56.726] pid = [00:17:56.726] startup_data = {canAcceptConnections = CAC_OK} [00:17:56.726] cac = [00:17:56.726] __func__ = "BackendStartup" [00:17:56.726] #23 0x000055b15820ce7c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [00:17:56.726] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\216\272\377\177\000\0004o\216\272\377\177", '\000' , "cx8W\261U\000\000(X4W\261U\000\000\000p\216\272\377\177\000\000\370o\216\272\377\177\000\000\225[\362\001\000\000\000\000\240\252\tu\261U\000\000,", '\000' , "qw8W\261U\000\000hv\363њ\177\000\0000F]К\177\000", __ss_align = 140302924083936}, salen = 2}} [00:17:56.726] i = 0 [00:17:56.726] now = [00:17:56.726] last_lockfile_recheck_time = 1738195999 [00:17:56.726] last_touch_time = 1738195999 [00:17:56.726] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = -772573592, user_data = 0x0}, {pos = -772574496, events = 32666, fd = 2090263927, user_data = 0x7fffba8e7080}, {pos = -772744632, events = 32666, fd = 15, user_data = 0x7f9ad05d4630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -772574496, events = 32666, fd = -1165070344, user_data = 0x7fffba8e7000}, {pos = -772573592, events = 32666, fd = 0, user_data = 0x55b17509d5a8}, {pos = 1483257291, events = 21937, fd = 32768, user_data = 0x1}, {pos = 1963395424, events = 21937, fd = -1, user_data = 0x7f9ad062e020}, {pos = -776802400, events = 32666, fd = 1963613240, user_data = 0x55b1750a5b18}, {pos = 1963589633, events = 21937, fd = -772718914, user_data = 0x1}, {pos = -772574496, events = 32666, fd = 427, user_data = 0x55b158bb7d58 }, {pos = 0, events = 0, fd = 86, user_data = 0x55b17509d5a8}, {pos = -772718914, events = 32666, fd = 1, user_data = 0x0}, {pos = -798826464, events = 32666, fd = -798020032, user_data = 0x10}, {pos = -1165069216, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -772709958, user_data = 0x0}, {pos = -798298716, events = 32666, fd = 0, user_data = 0x55b15926e080 }, {pos = 2, events = 0, fd = 0, user_data = 0x55b175031f00}, {pos = 1479470089, events = 21937, fd = 1963608411, user_data = 0x55b1582f2842 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55b17509d5a8}, {pos = -772718914, events = 32666, fd = 1, user_data = 0x0}, {pos = -798792504, events = 32666, fd = -798373760, user_data = 0x444}, {pos = -798265593, events = 32666, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -796976032, events = 32666, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa5a}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -790416064, user_data = 0x7f9ad0e33a80}, {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 = 0x55b1750a5910}, {pos = 1482935911, events = 21937, fd = 1024, user_data = 0x7f9ad06b576b}, {pos = -796993056, events = 32666, fd = -798355090, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1963608320, user_data = 0x7ac3353384650100}, {pos = -796989984, events = 32666, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1963612632, user_data = 0x3}, {pos = 0, events = 0, fd = 32518, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1963578792, user_data = 0x7f9ad06f3053 }, {pos = 1963612632, events = 21937, fd = 1024, user_data = 0x7fffba8e7528}, {pos = 1483017051, events = 21937, fd = 1495795760, user_data = 0x55b15863f618 }, {pos = 1963612432, events = 21937, fd = 1963392320, user_data = 0x55b1750a5910}, {pos = -798271637, events = 32666, fd = 0, user_data = 0x55b158651282 }, {pos = 1963612432, events = 1, fd = 1483019211, user_data = 0x55b17506fd40}, {pos = -2073755392, events = 2059613491, fd = 0, user_data = 0x7f9ad06a2ab1}, {pos = -798354192, events = 32666, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1963138816, user_data = 0x7ac3353384650100}, {pos = 0, events = 0, fd = -2073755392, user_data = 0xc}, {pos = -2073755392, events = 2059613491, fd = 0, user_data = 0x7f9ad065b239 }, {pos = 87, events = 0, fd = 1478514862, user_data = 0x400000}, {pos = 0, events = 0, fd = 1963138816, user_data = 0x55b15863f4ac }, {pos = 1963226224, events = 21937, fd = 1963392320, user_data = 0x55b175047470}, {pos = 1, events = 0, fd = 0, user_data = 0x55b1585fdcb1 }, {pos = 12, events = 0, fd = 1963574744, user_data = 0x55b17509c5b8}, {pos = 1495721472, events = 21937, fd = 296, user_data = 0x55b1582080c8 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1478531227, events = 21937, fd = 1492099312, user_data = 0x55b1750706f8}} [00:17:56.726] nevents = 1 [00:17:56.726] __func__ = "ServerLoop" [00:17:56.726] #24 0x000055b15820e6db in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55b17502dd60) at ../src/backend/postmaster/postmaster.c:1386 [00:17:56.726] opt = [00:17:56.726] status = [00:17:56.726] userDoption = [00:17:56.726] listen_addr_saved = false [00:17:56.726] output_config_variable = [00:17:56.726] __func__ = "PostmasterMain" [00:17:56.726] #25 0x000055b15804329a in main (argc=4, argv=0x55b17502dd60) at ../src/backend/main/main.c:230 [00:17:56.726] do_check_root = [00:17:56.726] dispatch_option = [00:17:56.759] -e [00:17:56.759] [00:17:56.759] [00:17:56.820] dumping /tmp/cores/postgres-6-30058.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:17:57.070] [New LWP 30058] [00:17:57.070] [00:17:57.070] This GDB supports auto-downloading debuginfo from the following URLs: [00:17:57.070] [00:17:57.070] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [00:17:57.070] Debuginfod has been disabled. [00:17:57.070] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [00:17:57.170] [Thread debugging using libthread_db enabled] [00:17:57.170] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:17:57.170] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [00:17:57.170] Program terminated with signal SIGABRT, Aborted. [00:17:57.170] #0 0x00007fce226a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:58.027] [00:17:58.027] Thread 1 (Thread 0x7fce22e35f00 (LWP 30058)): [00:17:58.027] #0 0x00007fce226a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:58.027] No symbol table info available. [00:17:58.027] #1 0x00007fce2265afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:58.027] No symbol table info available. [00:17:58.027] #2 0x00007fce22645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:58.027] No symbol table info available. [00:17:58.027] #3 0x000055f947a34347 in ExceptionalCondition (conditionName=conditionName@entry=0x55f947cb195d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55f947cb0eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [00:17:58.027] No locals. [00:17:58.027] #4 0x000055f94739f0af in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55f954e02a50, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [00:17:58.027] estate = 0x55f954d7ae90 [00:17:58.027] oldcontext = 0x55f954d38e70 [00:17:58.027] __func__ = "standard_ExecutorStart" [00:17:58.027] #5 0x000055f94739f28b in ExecutorStart (queryDesc=queryDesc@entry=0x55f954e02a50, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [00:17:58.027] No locals. [00:17:58.027] #6 0x000055f9472be6c7 in refresh_matview_datafill (dest=0x55f954dbfb30, query=, query@entry=0x55f954d615a0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [00:17:58.027] rewritten = [00:17:58.027] plan = 0x55f954e020a8 [00:17:58.027] queryDesc = 0x55f954e02a50 [00:17:58.027] copied_query = [00:17:58.027] processed = [00:17:58.027] __func__ = "refresh_matview_datafill" [00:17:58.027] #7 0x000055f9472c0a21 in RefreshMatViewByOid (matviewOid=28656, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [00:17:58.027] dest = [00:17:58.027] matviewRel = 0x7fce16f47100 [00:17:58.027] rule = [00:17:58.027] actions = [00:17:58.027] dataQuery = 0x55f954d615a0 [00:17:58.027] tableSpace = [00:17:58.027] relowner = 10 [00:17:58.027] OIDNewHeap = 28663 [00:17:58.027] processed = 0 [00:17:58.027] relpersistence = 112 'p' [00:17:58.027] save_userid = 10 [00:17:58.027] save_sec_context = 0 [00:17:58.027] save_nestlevel = 2 [00:17:58.027] address = {classId = 0, objectId = 0, objectSubId = 0} [00:17:58.027] __func__ = "RefreshMatViewByOid" [00:17:58.027] #8 0x000055f9472c0b60 in ExecRefreshMatView (stmt=0x55f954dbf808, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:17:58.027] matviewOid = [00:17:58.027] lockmode = [00:17:58.027] #9 0x000055f947276634 in ExecCreateTableAs (pstate=pstate@entry=0x55f954d38f70, stmt=stmt@entry=0x55f954beab60, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffceb1f9c30) at ../src/backend/commands/createas.c:351 [00:17:58.027] refresh = [00:17:58.027] query = 0x55f954bead20 [00:17:58.027] into = 0x55f954bea8b8 [00:17:58.027] jstate = 0x0 [00:17:58.027] is_matview = true [00:17:58.027] do_refresh = false [00:17:58.027] dest = [00:17:58.027] address = {classId = 1259, objectId = 28656, objectSubId = 0} [00:17:58.027] __func__ = "ExecCreateTableAs" [00:17:58.027] #10 0x000055f9477a2eb5 in ProcessUtilitySlow (pstate=pstate@entry=0x55f954d38f70, pstmt=pstmt@entry=0x55f954beac10, queryString=queryString@entry=0x55f954be9e20 "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=0x55f954beb648, qc=0x7ffceb1f9c30) at ../src/backend/tcop/utility.c:1678 [00:17:58.027] _save_exception_stack = 0x7ffceb1f9b10 [00:17:58.027] _save_context_stack = 0x0 [00:17:58.027] _local_sigjmp_buf = {{__jmpbuf = {0, 4502529301166688320, 94529356999520, 0, 94529356996128, 0, 7671686016863045696, 4502496826686310464}, __mask_was_saved = 0, __saved_mask = {__val = {28660, 0, 94529137691977, 140523325316536, 94529356996128, 94529140056083, 94529150228194, 94529150228320, 140724253202740, 94529140250937, 94529150228209, 94529150228320, 140724253202772, 94529140250952, 94529150228320, 0}}}} [00:17:58.027] _do_rethrow = false [00:17:58.027] parsetree = 0x55f954beab60 [00:17:58.027] isTopLevel = true [00:17:58.027] isCompleteQuery = true [00:17:58.027] needCleanup = false [00:17:58.027] commandCollected = false [00:17:58.027] address = {classId = 22009, objectId = 1421781856, objectSubId = 22009} [00:17:58.027] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:17:58.027] __func__ = "ProcessUtilitySlow" [00:17:58.027] #11 0x000055f9477a14c6 in standard_ProcessUtility (pstmt=0x55f954beac10, queryString=0x55f954be9e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55f954beb648, qc=0x7ffceb1f9c30) at ../src/backend/tcop/utility.c:1070 [00:17:58.027] parsetree = 0x55f954beab60 [00:17:58.027] isTopLevel = true [00:17:58.027] isAtomicContext = false [00:17:58.027] pstate = 0x55f954d38f70 [00:17:58.027] readonly_flags = [00:17:58.027] __func__ = "standard_ProcessUtility" [00:17:58.027] #12 0x000055f9477a1621 in ProcessUtility (pstmt=pstmt@entry=0x55f954beac10, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55f954beb648, qc=0x7ffceb1f9c30) at ../src/backend/tcop/utility.c:523 [00:17:58.027] No locals. [00:17:58.027] #13 0x000055f94779cfdf in PortalRunUtility (portal=portal@entry=0x55f954c6edb0, pstmt=pstmt@entry=0x55f954beac10, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f954beb648, qc=qc@entry=0x7ffceb1f9c30) at ../src/backend/tcop/pquery.c:1152 [00:17:58.027] No locals. [00:17:58.027] #14 0x000055f94779d584 in PortalRunMulti (portal=portal@entry=0x55f954c6edb0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f954beb648, altdest=altdest@entry=0x55f954beb648, qc=qc@entry=0x7ffceb1f9c30) at ../src/backend/tcop/pquery.c:1309 [00:17:58.027] pstmt = 0x55f954beac10 [00:17:58.027] stmtlist_item__state = [00:17:58.027] active_snapshot_set = false [00:17:58.027] stmtlist_item = 0x55f954beb610 [00:17:58.027] #15 0x000055f94779daec in PortalRun (portal=portal@entry=0x55f954c6edb0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55f954beb648, altdest=altdest@entry=0x55f954beb648, qc=qc@entry=0x7ffceb1f9c30) at ../src/backend/tcop/pquery.c:787 [00:17:58.027] _save_exception_stack = 0x7ffceb1f9ce0 [00:17:58.027] _save_context_stack = 0x0 [00:17:58.027] _local_sigjmp_buf = {{__jmpbuf = {0, 4502529302031763520, 94529357540784, 94529356999640, 94529356999616, 94529356999568, 7671686016733022272, 4502496841614231616}, __mask_was_saved = 0, __saved_mask = {__val = {94529137379112, 3944717247, 4, 94529356999568, 112, 73, 94529357540784, 94529356999640, 94529356999616, 94529356999568, 94529137466315, 1, 2, 73, 94529126713850, 0}}}} [00:17:58.027] _do_rethrow = [00:17:58.027] result = [00:17:58.027] nprocessed = [00:17:58.027] saveTopTransactionResourceOwner = 0x55f954c2b868 [00:17:58.027] saveTopTransactionContext = 0x55f954c80dd0 [00:17:58.027] saveActivePortal = 0x0 [00:17:58.027] saveResourceOwner = 0x55f954c2b868 [00:17:58.027] savePortalContext = 0x0 [00:17:58.027] saveMemoryContext = 0x55f954c80dd0 [00:17:58.027] __func__ = "PortalRun" [00:17:58.027] #16 0x000055f947796fa4 in exec_simple_query (query_string=query_string@entry=0x55f954be9e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [00:17:58.027] cmdtaglen = 24 [00:17:58.027] snapshot_set = [00:17:58.027] per_parsetree_context = 0x0 [00:17:58.027] plantree_list = 0x55f954beb5f8 [00:17:58.027] parsetree = 0x55f954beab90 [00:17:58.027] commandTag = [00:17:58.027] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:17:58.027] querytree_list = [00:17:58.027] portal = 0x55f954c6edb0 [00:17:58.027] receiver = 0x55f954beb648 [00:17:58.027] format = 0 [00:17:58.027] cmdtagname = [00:17:58.027] parsetree_item__state = [00:17:58.027] dest = DestRemote [00:17:58.027] oldcontext = 0x55f954c80dd0 [00:17:58.027] parsetree_list = 0x55f954beabc0 [00:17:58.027] parsetree_item = 0x55f954beabd8 [00:17:58.027] save_log_statement_stats = false [00:17:58.027] was_logged = true [00:17:58.027] use_implicit_block = false [00:17:58.027] msec_str = "\004\000\000\000\000\000\000\000u\241\245G\371U\000\000\300\234\037\353\374\177\000\000G\000\000\000\000\000\000" [00:17:58.027] __func__ = "exec_simple_query" [00:17:58.027] #17 0x000055f947799cfd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [00:17:58.027] query_string = 0x55f954be9e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:17:58.027] firstchar = [00:17:58.027] input_message = {data = 0x55f954be9e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:17:58.027] local_sigjmp_buf = {{__jmpbuf = {94529150236792, 4502485965636634688, 140724253204028, 4, 17, 140724253204260, 7671686016531695680, 4502496839542114368}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94529356725792, 16128, 94529150230848, 94529357260832, 17, 94529137378660, 0, 9, 2, 94529150236800, 94529356725792, 94529150230848, 4, 17, 140724253204260}}}} [00:17:58.027] send_ready_for_query = false [00:17:58.027] idle_in_transaction_timeout_enabled = false [00:17:58.027] idle_session_timeout_enabled = false [00:17:58.027] __func__ = "PostgresMain" [00:17:58.027] #18 0x000055f94778fd68 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:17:58.027] bsdata = [00:17:58.027] #19 0x000055f947640bb1 in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7ffceb1f9e3c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffceb1f9e90) at ../src/backend/postmaster/launch_backend.c:274 [00:17:58.027] pid = [00:17:58.027] #20 0x000055f947645dac in BackendStartup (client_sock=client_sock@entry=0x7ffceb1f9e90) at ../src/backend/postmaster/postmaster.c:3519 [00:17:58.027] bn = 0x55f954c12618 [00:17:58.027] pid = [00:17:58.027] startup_data = {canAcceptConnections = CAC_OK} [00:17:58.027] cac = [00:17:58.027] __func__ = "BackendStartup" [00:17:58.027] #21 0x000055f947647e7c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [00:17:58.027] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "c\"\316\177\000\000\240/\267#\316\177\000\0008\237\037\353\374\177\000\0004\237\037\353\374\177", '\000' , "c(|F\371U\000\000(\bxF\371U\000\000\000\240\037\353\374\177\000\000\370\237\037\353\374\177\000\000\225[\362\001\000\000\000\000\240D\344\"\316\177\000\000+", '\000' , "\371U\000\000q'|F\371U\000", __ss_align = 140523344119400}, salen = 2}} [00:17:58.027] i = 0 [00:17:58.027] now = [00:17:58.027] last_lockfile_recheck_time = 1738195964 [00:17:58.027] last_touch_time = 1738195964 [00:17:58.027] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x0}, {pos = 604128872, events = 32718, fd = 585385520, user_data = 0x7fce240242e0}, {pos = 2090263927, events = 0, fd = -350248832, user_data = 0x7fce23ffaa48}, {pos = 15, events = 0, fd = 585385520, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fce240242e0}, {pos = -350248968, events = 32764, fd = -350248960, user_data = 0x7fce24024668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 1421785808, events = 22009, fd = 1, user_data = 0x7ffceb1fa523}, {pos = -1, events = 0, fd = 576905248, user_data = 0x7fce23b72fa0}, {pos = 1421964072, events = 22009, fd = 1421963784, user_data = 0x55f954c16fe1}, {pos = 603983550, events = 32718, fd = 1, user_data = 0x7fce240242e0}, {pos = 427, events = 0, fd = 1207905624, user_data = 0x0}, {pos = 229, events = 0, fd = 1421778488, user_data = 0x7fce24000ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fce2262e020}, {pos = 577711680, events = 32718, fd = 16, user_data = 0x7ffceb1fa450}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 603992506, events = 32718, fd = 0, user_data = 0x7fce226aeda4 }, {pos = 0, events = 0, fd = 1214943360, user_data = 0x2}, {pos = 0, events = 0, fd = 1421524672, user_data = 0x55f94772d842 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 1421778488, user_data = 0x7fce24000ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fce226364c8}, {pos = 577466477, events = 32718, fd = 1215010656, user_data = 0x55f954c1c7c0}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 578755680, events = 32718, 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 = 4294967040, 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 = 0x7fce226b58be}, {pos = 578738656, events = 32718, fd = 577376622, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1421964304, user_data = 0xfabbade989031700}, {pos = 578741728, events = 32718, fd = -328, user_data = 0x0}, {pos = 1421963464, events = 22009, 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 = 26055, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1421778488, user_data = 0x7fce226f3053 }, {pos = 1421963464, events = 22009, fd = 1024, user_data = 0x7ffceb1fa518}, {pos = 1202240347, events = 22009, fd = 1215019056, user_data = 0x55f947a7a618 }, {pos = 1421963264, events = 22009, fd = 1421778208, user_data = 0x55f954c17000}, {pos = 577460414, events = 32718, fd = 0, user_data = 0x55f947a8c282 }, {pos = 1421963264, events = 1, fd = 1202242507, user_data = 0x55f954be9d20}, {pos = -1996286208, events = 4206603753, fd = 0, user_data = 0x7fce226a2ab1}, {pos = 577377520, events = 32718, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1421524672, user_data = 0xfabbade989031700}, {pos = 0, events = 0, fd = -1996286208, user_data = 0xc}, {pos = -1996286208, events = 4206603753, fd = 0, user_data = 0x7fce2265b239 }, {pos = 230, events = 0, fd = 1197738158, user_data = 0x400000}, {pos = 0, events = 0, fd = 1421524672, user_data = 0x55f947a7a4ac }, {pos = 1421612112, events = 22009, fd = 1421778208, user_data = 0x55f954bc1450}, {pos = 1, events = 0, fd = 0, user_data = 0x55f947a38cb1 }, {pos = 12, events = 0, fd = 1421954600, user_data = 0x55f954c14e08}, {pos = 1214944768, events = 22009, fd = 296, user_data = 0x55f9476430c8 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1197754523, events = 22009, fd = 1211322608, user_data = 0x55f954bea6c8}} [00:17:58.028] nevents = 1 [00:17:58.028] __func__ = "ServerLoop" [00:17:58.028] #22 0x000055f9476496db in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55f954ba7d30) at ../src/backend/postmaster/postmaster.c:1386 [00:17:58.028] opt = [00:17:58.028] status = [00:17:58.028] userDoption = [00:17:58.028] listen_addr_saved = false [00:17:58.028] output_config_variable = [00:17:58.028] __func__ = "PostmasterMain" [00:17:58.028] #23 0x000055f94747e29a in main (argc=4, argv=0x55f954ba7d30) at ../src/backend/main/main.c:230 [00:17:58.028] do_check_root = [00:17:58.028] dispatch_option = [00:17:58.062] -e [00:17:58.062] [00:17:58.062] [00:17:58.124] dumping /tmp/cores/postgres-6-29345.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:17:58.374] [New LWP 29345] [00:17:58.374] [00:17:58.374] This GDB supports auto-downloading debuginfo from the following URLs: [00:17:58.374] [00:17:58.374] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [00:17:58.374] Debuginfod has been disabled. [00:17:58.374] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [00:17:58.480] [Thread debugging using libthread_db enabled] [00:17:58.480] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:17:58.480] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [00:17:58.480] Program terminated with signal SIGABRT, Aborted. [00:17:58.480] #0 0x00007f40df6a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:59.344] [00:17:59.344] Thread 1 (Thread 0x7f40e0487f00 (LWP 29345)): [00:17:59.344] #0 0x00007f40df6a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:59.344] No symbol table info available. [00:17:59.344] #1 0x00007f40df65afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:59.344] No symbol table info available. [00:17:59.344] #2 0x00007f40df645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [00:17:59.344] No symbol table info available. [00:17:59.344] #3 0x000055ebd480a347 in ExceptionalCondition (conditionName=conditionName@entry=0x55ebd4a8795d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55ebd4a86eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [00:17:59.344] No locals. [00:17:59.344] #4 0x000055ebd41750af in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55ebe94f4210, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [00:17:59.344] estate = 0x55ebe93e69b0 [00:17:59.344] oldcontext = 0x55ebe9435f50 [00:17:59.344] __func__ = "standard_ExecutorStart" [00:17:59.344] #5 0x000055ebd417528b in ExecutorStart (queryDesc=queryDesc@entry=0x55ebe94f4210, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [00:17:59.344] No locals. [00:17:59.344] #6 0x000055ebd40946c7 in refresh_matview_datafill (dest=0x55ebe94339e0, query=, query@entry=0x55ebe93fbc90, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [00:17:59.344] rewritten = [00:17:59.344] plan = 0x55ebe94f3868 [00:17:59.344] queryDesc = 0x55ebe94f4210 [00:17:59.344] copied_query = [00:17:59.344] processed = [00:17:59.344] __func__ = "refresh_matview_datafill" [00:17:59.344] #7 0x000055ebd4096a21 in RefreshMatViewByOid (matviewOid=28659, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [00:17:59.344] dest = [00:17:59.344] matviewRel = 0x7f40d3bf7c90 [00:17:59.344] rule = [00:17:59.344] actions = [00:17:59.344] dataQuery = 0x55ebe93fbc90 [00:17:59.344] tableSpace = [00:17:59.344] relowner = 10 [00:17:59.344] OIDNewHeap = 28673 [00:17:59.344] processed = 0 [00:17:59.344] relpersistence = 112 'p' [00:17:59.344] save_userid = 10 [00:17:59.344] save_sec_context = 0 [00:17:59.344] save_nestlevel = 2 [00:17:59.344] address = {classId = 0, objectId = 0, objectSubId = 0} [00:17:59.344] __func__ = "RefreshMatViewByOid" [00:17:59.344] #8 0x000055ebd4096b60 in ExecRefreshMatView (stmt=0x55ebe94336b8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:17:59.344] matviewOid = [00:17:59.344] lockmode = [00:17:59.344] #9 0x000055ebd404c634 in ExecCreateTableAs (pstate=pstate@entry=0x55ebe9436050, stmt=stmt@entry=0x55ebe92d97f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc77cee790) at ../src/backend/commands/createas.c:351 [00:17:59.344] refresh = [00:17:59.344] query = 0x55ebe92d99b0 [00:17:59.344] into = 0x55ebe92d9548 [00:17:59.344] jstate = 0x0 [00:17:59.344] is_matview = true [00:17:59.344] do_refresh = false [00:17:59.344] dest = [00:17:59.344] address = {classId = 1259, objectId = 28659, objectSubId = 0} [00:17:59.344] __func__ = "ExecCreateTableAs" [00:17:59.344] #10 0x000055ebd4578eb5 in ProcessUtilitySlow (pstate=pstate@entry=0x55ebe9436050, pstmt=pstmt@entry=0x55ebe92d98a0, queryString=queryString@entry=0x55ebe92d8ab0 "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=0x55ebe92da2d8, qc=0x7ffc77cee790) at ../src/backend/tcop/utility.c:1678 [00:17:59.344] _save_exception_stack = 0x7ffc77cee670 [00:17:59.344] _save_context_stack = 0x0 [00:17:59.344] _local_sigjmp_buf = {{__jmpbuf = {0, -694456864425538571, 94471717754864, 0, 94471717751472, 0, -6740772707914904587, -694484681464771595}, __mask_was_saved = 0, __saved_mask = {__val = {28663, 0, 94471371155240, 3552541840, 94471718860920, 0, 94471367937069, 0, 94471367597975, 139916556193408, 45891725557760, 139916415400356, 94471370624250, 10685, 94471367597975, 139916407670176}}}} [00:17:59.344] _do_rethrow = false [00:17:59.344] parsetree = 0x55ebe92d97f0 [00:17:59.344] isTopLevel = true [00:17:59.344] isCompleteQuery = true [00:17:59.344] needCleanup = false [00:17:59.344] commandCollected = false [00:17:59.344] address = {classId = 21995, objectId = 3912079344, objectSubId = 21995} [00:17:59.344] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:17:59.344] __func__ = "ProcessUtilitySlow" [00:17:59.344] #11 0x000055ebd45774c6 in standard_ProcessUtility (pstmt=0x55ebe92d98a0, queryString=0x55ebe92d8ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55ebe92da2d8, qc=0x7ffc77cee790) at ../src/backend/tcop/utility.c:1070 [00:17:59.344] parsetree = 0x55ebe92d97f0 [00:17:59.344] isTopLevel = true [00:17:59.344] isAtomicContext = false [00:17:59.344] pstate = 0x55ebe9436050 [00:17:59.344] readonly_flags = [00:17:59.344] __func__ = "standard_ProcessUtility" [00:17:59.344] #12 0x000055ebd4577621 in ProcessUtility (pstmt=pstmt@entry=0x55ebe92d98a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55ebe92da2d8, qc=0x7ffc77cee790) at ../src/backend/tcop/utility.c:523 [00:17:59.344] No locals. [00:17:59.344] #13 0x000055ebd4572fdf in PortalRunUtility (portal=portal@entry=0x55ebe935dfc0, pstmt=pstmt@entry=0x55ebe92d98a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55ebe92da2d8, qc=qc@entry=0x7ffc77cee790) at ../src/backend/tcop/pquery.c:1152 [00:17:59.344] No locals. [00:17:59.344] #14 0x000055ebd4573584 in PortalRunMulti (portal=portal@entry=0x55ebe935dfc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55ebe92da2d8, altdest=altdest@entry=0x55ebe92da2d8, qc=qc@entry=0x7ffc77cee790) at ../src/backend/tcop/pquery.c:1309 [00:17:59.344] pstmt = 0x55ebe92d98a0 [00:17:59.344] stmtlist_item__state = [00:17:59.344] active_snapshot_set = false [00:17:59.344] stmtlist_item = 0x55ebe92da2a0 [00:17:59.344] #15 0x000055ebd4573aec in PortalRun (portal=portal@entry=0x55ebe935dfc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55ebe92da2d8, altdest=altdest@entry=0x55ebe92da2d8, qc=qc@entry=0x7ffc77cee790) at ../src/backend/tcop/pquery.c:787 [00:17:59.344] _save_exception_stack = 0x7ffc77cee840 [00:17:59.344] _save_context_stack = 0x0 [00:17:59.344] _local_sigjmp_buf = {{__jmpbuf = {0, -694456864747451403, 94471718297536, 94471717754984, 94471717754960, 94471717754912, -6740772707776492555, -694484684052263947}, __mask_was_saved = 0, __saved_mask = {__val = {94471371155240, 2010048287, 4, 94471717754912, 112, 73, 94471718297536, 94471717754984, 94471717754960, 94471717754912, 94471371242443, 1, 2, 73, 94471360489978, 0}}}} [00:17:59.344] _do_rethrow = [00:17:59.344] result = [00:17:59.344] nprocessed = [00:17:59.344] saveTopTransactionResourceOwner = 0x55ebe931bd88 [00:17:59.344] saveTopTransactionContext = 0x55ebe93703f0 [00:17:59.344] saveActivePortal = 0x0 [00:17:59.344] saveResourceOwner = 0x55ebe931bd88 [00:17:59.344] savePortalContext = 0x0 [00:17:59.344] saveMemoryContext = 0x55ebe93703f0 [00:17:59.344] __func__ = "PortalRun" [00:17:59.344] #16 0x000055ebd456cfa4 in exec_simple_query (query_string=query_string@entry=0x55ebe92d8ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [00:17:59.344] cmdtaglen = 24 [00:17:59.344] snapshot_set = [00:17:59.344] per_parsetree_context = 0x0 [00:17:59.344] plantree_list = 0x55ebe92da288 [00:17:59.344] parsetree = 0x55ebe92d9820 [00:17:59.344] commandTag = [00:17:59.344] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:17:59.344] querytree_list = [00:17:59.344] portal = 0x55ebe935dfc0 [00:17:59.344] receiver = 0x55ebe92da2d8 [00:17:59.344] format = 0 [00:17:59.344] cmdtagname = [00:17:59.344] parsetree_item__state = [00:17:59.344] dest = DestRemote [00:17:59.344] oldcontext = 0x55ebe93703f0 [00:17:59.344] parsetree_list = 0x55ebe92d9850 [00:17:59.344] parsetree_item = 0x55ebe92d9868 [00:17:59.344] save_log_statement_stats = false [00:17:59.344] was_logged = false [00:17:59.344] use_implicit_block = false [00:17:59.344] msec_str = "\004\000\000\000\000\000\000\000u\001\203\324\353U\000\000 \350\316w\374\177\000\000G\000\000\000\000\000\000" [00:17:59.344] __func__ = "exec_simple_query" [00:17:59.344] #17 0x000055ebd456fcfd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [00:17:59.344] query_string = 0x55ebe92d8ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:17:59.344] firstchar = [00:17:59.344] input_message = {data = 0x55ebe92d8ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:17:59.344] local_sigjmp_buf = {{__jmpbuf = {94471384012920, -694482466721395723, 140722318535068, 4, 11, 140722318535300, -6740772708112036875, -694484668558636043}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94471717481936, 17408, 94471384006976, 94471718016304, 11, 94471371154788, 0, 10, 2, 94471384012928, 94471717481936, 94471384006976, 4, 11, 140722318535300}}}} [00:17:59.344] send_ready_for_query = false [00:17:59.344] idle_in_transaction_timeout_enabled = false [00:17:59.344] idle_session_timeout_enabled = false [00:17:59.344] __func__ = "PostgresMain" [00:17:59.344] #18 0x000055ebd4565d68 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:17:59.344] bsdata = [00:17:59.344] #19 0x000055ebd4416bb1 in postmaster_child_launch (child_type=B_BACKEND, child_slot=11, startup_data=startup_data@entry=0x7ffc77cee99c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc77cee9f0) at ../src/backend/postmaster/launch_backend.c:274 [00:17:59.344] pid = [00:17:59.344] #20 0x000055ebd441bdac in BackendStartup (client_sock=client_sock@entry=0x7ffc77cee9f0) at ../src/backend/postmaster/postmaster.c:3519 [00:17:59.344] bn = 0x55ebe9301208 [00:17:59.344] pid = [00:17:59.344] startup_data = {canAcceptConnections = CAC_OK} [00:17:59.344] cac = [00:17:59.344] __func__ = "BackendStartup" [00:17:59.344] #21 0x000055ebd441de7c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [00:17:59.344] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "c\210Y\323\353U\000\000(hU\323\353U\000\000@\353\316w\374\177\000\0008\353\316w\374\177\000\000\225[\362\001\000\000\000\000\240Բ\340@\177\000\000+", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h\346\376\340@\177\000\0000ֲ\340@\177\000\000\340\342\376\340@\177\000\000\316)fR\000\000\000", __ss_align = 2010049408}, salen = 2}} [00:17:59.344] i = 0 [00:17:59.344] now = [00:17:59.344] last_lockfile_recheck_time = 1738195961 [00:17:59.344] last_touch_time = 1738195961 [00:17:59.344] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -520166688, user_data = 0x0}, {pos = 2010049472, events = 32764, fd = -520336824, user_data = 0xf}, {pos = -525150672, events = 32576, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -520166688, user_data = 0x7ffc77ceeb38}, {pos = 2010049344, events = 32764, fd = -520165784, user_data = 0x0}, {pos = -382891152, events = 21995, fd = -546604406, user_data = 0x55ebe92d8b70}, {pos = 1, events = 21995, fd = 32768, user_data = 0xffffffff}, {pos = -547168224, events = 32576, fd = -525086816, user_data = 0x55ebe93063f8}, {pos = -382704936, events = 21995, fd = -382705487, user_data = 0x7f40e0fcaebe}, {pos = 1, events = 0, fd = -520166688, user_data = 0x1ab}, {pos = -723743400, events = 21995, fd = 0, user_data = 0xf9}, {pos = -382891152, events = 21995, fd = -520311106, user_data = 0x1}, {pos = 0, events = 0, fd = -547168224, user_data = 0x7f40df6f2e40 }, {pos = 16, events = 0, fd = 2010050480, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f40e0fcd1ba}, {pos = 0, events = 0, fd = -546640476, user_data = 0x0}, {pos = -716705664, events = 21995, fd = 2, user_data = 0x0}, {pos = -383144336, events = 21995, fd = -732959628, user_data = 0x55ebe930b4d0}, {pos = -732955639, events = 21995, fd = -382683861, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -547134264, user_data = 0x7f40df69c880 }, {pos = -532120136, events = 32576, fd = 2010050672, user_data = 0x100007f00000002}, {pos = -546606995, events = 32576, fd = 2, user_data = 0x55ebe930b4d0}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -545317792, events = 32576, 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 = 1866753379, fd = 168455022, user_data = 0x31383337310a6174}, {pos = 909718841, events = 808716849, 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 = -382709584, events = 21995, fd = 1080, user_data = 0x55ebe93060d0}, {pos = -729489817, events = 21995, fd = 1024, user_data = 0x7f40df6b58be}, {pos = -545334816, events = 32576, fd = -546696850, user_data = 0x100000400}, {pos = 7, events = 0, fd = -382704416, user_data = 0xd622b6ce80977900}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55ebe93060d0}, {pos = 1, events = 0, fd = -382705256, user_data = 0x3}, {pos = 0, events = 0, fd = 25421, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -382891152, user_data = 0x7f40df6f3053 }, {pos = -382705256, events = 21995, fd = 1024, user_data = 0x7ffc77cef078}, {pos = -729408677, events = 21995, fd = -716629968, user_data = 0x55ebd4850618 }, {pos = -382705456, events = 21995, fd = -382891600, user_data = 0x55ebe93060d0}, {pos = -546613058, events = 32576, fd = 0, user_data = 0x55ebd4862282 }, {pos = -382705456, events = 1, fd = -729406517, user_data = 0x55ebe92d89b0}, {pos = -2137556736, events = 3592599246, fd = 0, user_data = 0x7f40df6a2ab1}, {pos = -546695952, events = 32576, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -383144336, user_data = 0xd622b6ce80977900}, {pos = 0, events = 0, fd = -2137556736, user_data = 0xc}, {pos = -2137556736, events = 3592599246, fd = 0, user_data = 0x7f40df65b239 }, {pos = 250, events = 0, fd = -733910866, user_data = 0x400000}, {pos = 0, events = 0, fd = -383144336, user_data = 0x55ebd48504ac }, {pos = -383057696, events = 21995, fd = -382891600, user_data = 0x55ebe92b00e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55ebd480ecb1 }, {pos = 12, events = 0, fd = -382714120, user_data = 0x55ebe9303ed8}, {pos = -716704256, events = 21995, fd = 296, user_data = 0x55ebd44190c8 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -733894501, events = 21995, fd = -720326416, user_data = 0x55ebe92d9388}} [00:17:59.344] nevents = 1 [00:17:59.344] __func__ = "ServerLoop" [00:17:59.344] #22 0x000055ebd441f6db in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55ebe9296d30) at ../src/backend/postmaster/postmaster.c:1386 [00:17:59.344] opt = [00:17:59.344] status = [00:17:59.344] userDoption = [00:17:59.344] listen_addr_saved = false [00:17:59.344] output_config_variable = [00:17:59.344] __func__ = "PostmasterMain" [00:17:59.344] #23 0x000055ebd425429a in main (argc=8, argv=0x55ebe9296d30) at ../src/backend/main/main.c:230 [00:17:59.344] do_check_root = [00:17:59.344] dispatch_option =