[08:01:30.093] src/tools/ci/cores_backtrace.sh linux /tmp/cores [08:01:30.301] dumping /tmp/cores/postgres-6-36702.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:01:30.554] [New LWP 36702] [08:01:30.554] [08:01:30.554] This GDB supports auto-downloading debuginfo from the following URLs: [08:01:30.554] [08:01:30.554] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:01:30.554] Debuginfod has been disabled. [08:01:30.554] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:01:30.682] [Thread debugging using libthread_db enabled] [08:01:30.682] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:01:30.682] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [08:01:30.682] Program terminated with signal SIGABRT, Aborted. [08:01:30.682] #0 0x00007f04aaea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:31.660] [08:01:31.660] Thread 1 (Thread 0x7f04aadd2f00 (LWP 36702)): [08:01:31.660] #0 0x00007f04aaea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:31.660] No symbol table info available. [08:01:31.660] #1 0x00007f04aae5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:31.660] No symbol table info available. [08:01:31.660] #2 0x00007f04aae45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:31.660] No symbol table info available. [08:01:31.660] #3 0x000055e0fd31bbcc in ExceptionalCondition (conditionName=conditionName@entry=0x55e0fd591395 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55e0fd5908b0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [08:01:31.660] No locals. [08:01:31.660] #4 0x000055e0fcc9d8c5 in standard_ExecutorStart (queryDesc=0x55e10c721900, eflags=0) at ../src/backend/executor/execMain.c:194 [08:01:31.660] estate = 0x55e10c6a2730 [08:01:31.660] oldcontext = 0x55e10c6cb680 [08:01:31.660] __func__ = "standard_ExecutorStart" [08:01:31.660] #5 0x00007f04a8a3a6f7 in pgss_ExecutorStart (queryDesc=0x55e10c721900, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [08:01:31.660] No locals. [08:01:31.660] #6 0x000055e0fcc9da5a in ExecutorStart (queryDesc=queryDesc@entry=0x55e10c721900, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [08:01:31.660] No locals. [08:01:31.660] #7 0x000055e0fcbc236e in refresh_matview_datafill (dest=0x55e10c71a038, query=, query@entry=0x55e10c6fdd00, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [08:01:31.660] rewritten = [08:01:31.660] plan = 0x55e10c720d28 [08:01:31.660] queryDesc = 0x55e10c721900 [08:01:31.660] copied_query = [08:01:31.660] processed = [08:01:31.660] __func__ = "refresh_matview_datafill" [08:01:31.660] #8 0x000055e0fcbc46d5 in RefreshMatViewByOid (matviewOid=28283, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [08:01:31.660] dest = [08:01:31.660] matviewRel = 0x7f04a69019c8 [08:01:31.660] rule = [08:01:31.660] actions = [08:01:31.660] dataQuery = 0x55e10c6fdd00 [08:01:31.660] tableSpace = [08:01:31.660] relowner = 10 [08:01:31.660] OIDNewHeap = 28303 [08:01:31.660] processed = 0 [08:01:31.660] relpersistence = 112 'p' [08:01:31.660] save_userid = 10 [08:01:31.660] save_sec_context = 0 [08:01:31.660] save_nestlevel = 2 [08:01:31.660] address = {classId = 0, objectId = 0, objectSubId = 0} [08:01:31.660] __func__ = "RefreshMatViewByOid" [08:01:31.660] #9 0x000055e0fcbc4814 in ExecRefreshMatView (stmt=0x55e10c6da7d0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [08:01:31.660] matviewOid = [08:01:31.660] lockmode = [08:01:31.660] #10 0x000055e0fcb7a461 in ExecCreateTableAs (pstate=pstate@entry=0x55e10c6cb780, stmt=stmt@entry=0x55e10c575790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc77d06230) at ../src/backend/commands/createas.c:351 [08:01:31.660] refresh = [08:01:31.660] query = 0x55e10c575950 [08:01:31.660] into = 0x55e10c5754e8 [08:01:31.660] jstate = 0x0 [08:01:31.660] is_matview = true [08:01:31.660] do_refresh = false [08:01:31.660] dest = [08:01:31.660] address = {classId = 1259, objectId = 28283, objectSubId = 0} [08:01:31.660] __func__ = "ExecCreateTableAs" [08:01:31.660] #11 0x000055e0fd093f73 in ProcessUtilitySlow (pstate=pstate@entry=0x55e10c6cb780, pstmt=pstmt@entry=0x55e10c575840, queryString=queryString@entry=0x55e10c574a50 "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=0x55e10c5767e8, qc=0x7ffc77d06230) at ../src/backend/tcop/utility.c:1678 [08:01:31.660] _save_exception_stack = 0x7ffc77d05de0 [08:01:31.660] _save_context_stack = 0x0 [08:01:31.660] _local_sigjmp_buf = {{__jmpbuf = {0, 5612627235410430046, 94425063053200, 0, 94425063049808, 0, 1864201855017568350, 5613714976166135902}, __mask_was_saved = 0, __saved_mask = {__val = {17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 94424805700550, 0, 5412384741217271808, 94424811779456, 94424805953387, 139657953913088, 1, 16777216, 0, 112, 94424805700822, 139657954832384}}}} [08:01:31.660] _do_rethrow = false [08:01:31.660] parsetree = 0x55e10c575790 [08:01:31.660] isTopLevel = true [08:01:31.660] isCompleteQuery = true [08:01:31.660] needCleanup = false [08:01:31.660] commandCollected = false [08:01:31.660] address = {classId = 21985, objectId = 207050640, objectSubId = 21985} [08:01:31.660] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:01:31.660] __func__ = "ProcessUtilitySlow" [08:01:31.660] #12 0x000055e0fd092584 in standard_ProcessUtility (pstmt=pstmt@entry=0x55e10c575840, queryString=queryString@entry=0x55e10c574a50 "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=0x55e10c5767e8, qc=0x7ffc77d06230) at ../src/backend/tcop/utility.c:1070 [08:01:31.660] parsetree = 0x55e10c575790 [08:01:31.660] isTopLevel = true [08:01:31.660] isAtomicContext = false [08:01:31.660] pstate = 0x55e10c6cb780 [08:01:31.660] readonly_flags = [08:01:31.660] __func__ = "standard_ProcessUtility" [08:01:31.660] #13 0x00007f04a8a3dd9d in pgss_ProcessUtility (pstmt=0x55e10c575840, queryString=0x55e10c574a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55e10c5767e8, qc=0x7ffc77d06230) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [08:01:31.660] _save_exception_stack = 0x7ffc77d060f0 [08:01:31.660] _save_context_stack = 0x0 [08:01:31.660] _local_sigjmp_buf = {{__jmpbuf = {0, -1862777114276509602, 94425063053376, 94425063057384, 140722318631472, 0, 1864201854912710750, 1742690001646405726}, __mask_was_saved = 0, __saved_mask = {__val = {94424809527186, 140722318630742, 140722318630740, 0, 0, 139637976727552, 206158430232, 140722318630704, 94424809527403, 0, 206158430232, 94425063054176, 140722318630800, 0, 94424804340919, 94425063049552}}}} [08:01:31.660] _do_rethrow = false [08:01:31.660] duration = [08:01:31.660] bufusage = {shared_blks_hit = 94425064287080, shared_blks_read = 962072674304, shared_blks_dirtied = 0, shared_blks_written = 94425064286584, local_blks_hit = 94425064287080, local_blks_read = 94424802670861, local_blks_dirtied = 94425064800040, local_blks_written = 94424802671107, temp_blks_read = 94425064286584, temp_blks_written = 94425064286000, shared_blk_read_time = {ticks = 94424802670216}, shared_blk_write_time = {ticks = 94424809520638}, local_blk_read_time = {ticks = 139658023218616}, local_blk_write_time = {ticks = 94425063049808}, temp_blk_read_time = {ticks = 94424811847717}, temp_blk_write_time = {ticks = 94424821822498}} [08:01:31.660] walusage_start = {wal_records = 8952, wal_fpi = 134, wal_bytes = 1229184} [08:01:31.660] start = [08:01:31.660] rows = [08:01:31.660] bufusage_start = {shared_blks_hit = 34472, shared_blks_read = 3589, shared_blks_dirtied = 1498, shared_blks_written = 1123, local_blks_hit = 45, local_blks_read = 0, local_blks_dirtied = 10, local_blks_written = 17, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [08:01:31.660] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 139657953913088} [08:01:31.660] parsetree = [08:01:31.660] saved_queryId = 6041762721901209185 [08:01:31.660] saved_stmt_location = 0 [08:01:31.660] saved_stmt_len = 69 [08:01:31.660] enabled = true [08:01:31.660] #14 0x000055e0fd09262a in ProcessUtility (pstmt=pstmt@entry=0x55e10c575840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55e10c5767e8, qc=0x7ffc77d06230) at ../src/backend/tcop/utility.c:519 [08:01:31.660] No locals. [08:01:31.660] #15 0x000055e0fd08df4b in PortalRunUtility (portal=portal@entry=0x55e10c5f5f90, pstmt=pstmt@entry=0x55e10c575840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55e10c5767e8, qc=qc@entry=0x7ffc77d06230) at ../src/backend/tcop/pquery.c:1158 [08:01:31.660] No locals. [08:01:31.660] #16 0x000055e0fd08e4f0 in PortalRunMulti (portal=portal@entry=0x55e10c5f5f90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55e10c5767e8, altdest=altdest@entry=0x55e10c5767e8, qc=qc@entry=0x7ffc77d06230) at ../src/backend/tcop/pquery.c:1315 [08:01:31.660] pstmt = 0x55e10c575840 [08:01:31.660] stmtlist_item__state = [08:01:31.660] active_snapshot_set = false [08:01:31.660] stmtlist_item = 0x55e10c5767b0 [08:01:31.660] #17 0x000055e0fd08eac3 in PortalRun (portal=portal@entry=0x55e10c5f5f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55e10c5767e8, altdest=altdest@entry=0x55e10c5767e8, qc=0x7ffc77d06230) at ../src/backend/tcop/pquery.c:791 [08:01:31.660] _save_exception_stack = 0x7ffc77d062e0 [08:01:31.660] _save_context_stack = 0x0 [08:01:31.660] _local_sigjmp_buf = {{__jmpbuf = {0, 5612627234885093470, 94425063579536, 94425063053320, 94425063579536, 94425063053248, 1864201854763812958, 5613714965353875550}, __mask_was_saved = 0, __saved_mask = {__val = {94424809204338, 94425063049552, 112, 4, 94424809208755, 2010145215, 4, 94425063053248, 112, 73, 94425063579536, 94425063053320, 94425063053296, 94425063053248, 94424809295958, 1}}}} [08:01:31.660] _do_rethrow = [08:01:31.660] result = [08:01:31.660] nprocessed = [08:01:31.660] saveTopTransactionResourceOwner = 0x55e10c5b5468 [08:01:31.660] saveTopTransactionContext = 0x55e10c6083c0 [08:01:31.660] saveActivePortal = 0x0 [08:01:31.660] saveResourceOwner = 0x55e10c5b5468 [08:01:31.660] savePortalContext = 0x0 [08:01:31.660] saveMemoryContext = 0x55e10c6083c0 [08:01:31.660] __func__ = "PortalRun" [08:01:31.660] #18 0x000055e0fd087eaf in exec_simple_query (query_string=query_string@entry=0x55e10c574a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [08:01:31.660] cmdtaglen = 24 [08:01:31.660] snapshot_set = [08:01:31.660] per_parsetree_context = 0x0 [08:01:31.660] plantree_list = 0x55e10c576798 [08:01:31.660] parsetree = 0x55e10c5757c0 [08:01:31.660] commandTag = [08:01:31.660] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:01:31.660] querytree_list = [08:01:31.660] portal = 0x55e10c5f5f90 [08:01:31.660] receiver = 0x55e10c5767e8 [08:01:31.660] format = 0 [08:01:31.660] cmdtagname = [08:01:31.660] parsetree_item__state = [08:01:31.660] dest = DestRemote [08:01:31.660] oldcontext = 0x55e10c6083c0 [08:01:31.660] parsetree_list = 0x55e10c5757f0 [08:01:31.660] parsetree_item = 0x55e10c575808 [08:01:31.660] save_log_statement_stats = false [08:01:31.660] was_logged = true [08:01:31.660] use_implicit_block = false [08:01:31.660] msec_str = "\220d\320w\374\177\000\000z\0314\375\340U\000\000\300b\320w\374\177\000\000G\000\000\000\000\000\000" [08:01:31.660] __func__ = "exec_simple_query" [08:01:31.660] #19 0x000055e0fd08ac33 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [08:01:31.660] query_string = 0x55e10c574a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [08:01:31.660] firstchar = [08:01:31.660] input_message = {data = 0x55e10c574a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [08:01:31.660] local_sigjmp_buf = {{__jmpbuf = {94424821831064, 5613717111367157854, 4, 140722318632080, 140722318632224, 140722318632228, 1864201854692509790, 5613714963402606686}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94425063299392, 0, 168, 94424809208857, 0, 10, 2, 94424821831072, 94425062780400, 94424821825152, 140722318632080, 140722318632224, 140722318632228}}}} [08:01:31.660] send_ready_for_query = false [08:01:31.660] idle_in_transaction_timeout_enabled = false [08:01:31.660] idle_session_timeout_enabled = false [08:01:31.660] __func__ = "PostgresMain" [08:01:31.660] #20 0x000055e0fd080aa9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:01:31.660] bsdata = [08:01:31.660] #21 0x000055e0fcf34497 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc77d0643c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc77d06490) at ../src/backend/postmaster/launch_backend.c:266 [08:01:31.660] pid = [08:01:31.660] #22 0x000055e0fcf39f4b in BackendStartup (client_sock=client_sock@entry=0x7ffc77d06490) at ../src/backend/postmaster/postmaster.c:3417 [08:01:31.660] bn = 0x55e10c5a1298 [08:01:31.660] pid = [08:01:31.660] startup_data = {canAcceptConnections = CAC_OK} [08:01:31.660] __func__ = "BackendStartup" [08:01:31.660] #23 0x000055e0fcf3a4ad in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [08:01:31.660] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\343\252\004\177\000\000\240\2177\254\004\177\000\0008e\320w\374\177\000\0004e\320w\374\177", '\000' , "jq\016\374\340U\000\000(W\n\374\340U\000\000\000f\320w\374\177\000\000\370e\320w\374\177\000\000\225[\362\001\000\000\000\000p\352Y\f\341U\000\000,", '\000' , "\341U\000\000xp\016\374\340U\000", __ss_align = 139658050840168}, salen = 2}} [08:01:31.660] i = 0 [08:01:31.660] now = [08:01:31.660] last_lockfile_recheck_time = 1731225482 [08:01:31.660] last_touch_time = 1731225482 [08:01:31.660] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55e0fc0e716a}, {pos = -1400723864, events = 32516, fd = -1419553232, user_data = 0x7f04ac82a2e0}, {pos = 2090263927, events = 0, fd = 2010146432, user_data = 0x7f04ac800a48}, {pos = 15, events = 0, fd = -1419553232, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f04ac82a2e0}, {pos = 2010146296, events = 32764, fd = 2010146304, user_data = 0x7f04ac82a668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 207050096, events = 21985, fd = 1, user_data = 0x7ffc77d06b23}, {pos = -1, events = 0, fd = -1427972064, user_data = 0x7f04ac378fa0}, {pos = 207225608, events = 21985, fd = 207225320, user_data = 0x55e10c5a4891}, {pos = -1400869186, events = 32516, fd = 1, user_data = 0x7f04ac82a2e0}, {pos = 427, events = 0, fd = -41161384, user_data = 0x0}, {pos = 1, events = 0, fd = 207054992, user_data = 0x7f04ac806ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f04aae2e020}, {pos = -1427165632, events = 32516, fd = 16, user_data = 0x7ffc77d06a60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1400860230, events = 32516, fd = 0, user_data = 0x7f04aaeaeda4 }, {pos = 0, events = 0, fd = -34234624, user_data = 0x2}, {pos = 7, events = 0, fd = 206794384, user_data = 0x55e0fd01ea34 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 207054992, user_data = 0x7f04ac806ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f04aae364c8}, {pos = -1427410835, events = 32516, fd = -34179936, user_data = 0x55e10c5a9900}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -1426121632, events = 32516, 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 = -1412926144, events = 32516, fd = -1412924800, 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 = 207239312, user_data = 0x7f04aaeb58be}, {pos = -1426138656, events = 32516, fd = -1427500690, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x52c585710f8e8e00}, {pos = -1426135584, events = 32516, fd = -328, user_data = 0x0}, {pos = 207225000, events = 21985, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 207224800, events = 21985, fd = 3, user_data = 0x0}, {pos = 32720, events = 0, fd = -328, user_data = 0x0}, {pos = 207054992, events = 21985, fd = -1427165101, user_data = 0x7ffc77d06b18}, {pos = -46714906, events = 21984, fd = -34171568, user_data = 0x55e0fd361aa3 }, {pos = 207224800, events = 21985, fd = 207046992, user_data = 0x55e10c59ffe0}, {pos = -1427416898, events = 32516, fd = 0, user_data = 0x55e0fd37370d }, {pos = 207224800, events = 1, fd = -46712746, user_data = 0x55e10c574950}, {pos = 261000704, events = 1388676465, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1427494223, user_data = 0x7f04aaea14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 261000704, user_data = 0x55e10c54c080}, {pos = 261000704, events = 1388676465, fd = 11, user_data = 0x52c585710f8e8e00}, {pos = 0, events = 0, fd = -1427787207, user_data = 0x1}, {pos = -51166828, events = 21984, fd = 4194304, user_data = 0x55e0fd361937 }, {pos = 206880896, events = 21985, fd = 207046992, user_data = 0x55e10c54c080}, {pos = 1, events = 0, fd = 0, user_data = 0x55e0fd37370d }, {pos = 206880896, events = 21985, fd = -46712746, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55e0fcd67580 }, {pos = 0, events = 0, fd = -53032768, user_data = 0xb}, {pos = -51145671, events = 21984, fd = -37793904, user_data = 0x55e10c575308}} [08:01:31.661] nevents = 1 [08:01:31.661] __func__ = "ServerLoop" [08:01:31.661] #24 0x000055e0fcf3bc30 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55e10c532cf0) at ../src/backend/postmaster/postmaster.c:1348 [08:01:31.661] opt = [08:01:31.661] status = [08:01:31.661] userDoption = [08:01:31.661] listen_addr_saved = false [08:01:31.661] output_config_variable = [08:01:31.661] __func__ = "PostmasterMain" [08:01:31.661] #25 0x000055e0fcd77908 in main (argc=4, argv=0x55e10c532cf0) at ../src/backend/main/main.c:196 [08:01:31.661] do_check_root = [08:01:31.696] -e [08:01:31.696] [08:01:31.696] [08:01:31.758] dumping /tmp/cores/postgres-6-29099.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:01:32.017] [New LWP 29099] [08:01:32.017] [08:01:32.017] This GDB supports auto-downloading debuginfo from the following URLs: [08:01:32.017] [08:01:32.017] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:01:32.017] Debuginfod has been disabled. [08:01:32.017] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:01:32.128] [Thread debugging using libthread_db enabled] [08:01:32.128] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:01:32.128] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [08:01:32.128] Program terminated with signal SIGABRT, Aborted. [08:01:32.128] #0 0x00007f27146a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:33.031] [08:01:33.031] Thread 1 (Thread 0x7f2712423f00 (LWP 29099)): [08:01:33.031] #0 0x00007f27146a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:33.031] No symbol table info available. [08:01:33.031] #1 0x00007f271465afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:33.031] No symbol table info available. [08:01:33.031] #2 0x00007f2714645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:33.031] No symbol table info available. [08:01:33.031] #3 0x000055d0533fdbcc in ExceptionalCondition (conditionName=conditionName@entry=0x55d053673395 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55d0536728b0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [08:01:33.031] No locals. [08:01:33.031] #4 0x000055d052d7f8c5 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55d087e69130, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [08:01:33.031] estate = 0x55d087e62de0 [08:01:33.031] oldcontext = 0x55d087ea0190 [08:01:33.031] __func__ = "standard_ExecutorStart" [08:01:33.031] #5 0x000055d052d7faa1 in ExecutorStart (queryDesc=queryDesc@entry=0x55d087e69130, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [08:01:33.031] No locals. [08:01:33.031] #6 0x000055d052ca436e in refresh_matview_datafill (dest=0x55d087e661a8, query=, query@entry=0x55d087e9faf0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [08:01:33.031] rewritten = [08:01:33.031] plan = 0x55d087e68668 [08:01:33.031] queryDesc = 0x55d087e69130 [08:01:33.031] copied_query = [08:01:33.031] processed = [08:01:33.031] __func__ = "refresh_matview_datafill" [08:01:33.031] #7 0x000055d052ca66d5 in RefreshMatViewByOid (matviewOid=28440, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [08:01:33.031] dest = [08:01:33.031] matviewRel = 0x7f2708befdf8 [08:01:33.031] rule = [08:01:33.031] actions = [08:01:33.031] dataQuery = 0x55d087e9faf0 [08:01:33.031] tableSpace = [08:01:33.031] relowner = 10 [08:01:33.031] OIDNewHeap = 28452 [08:01:33.031] processed = 0 [08:01:33.031] relpersistence = 112 'p' [08:01:33.031] save_userid = 10 [08:01:33.031] save_sec_context = 0 [08:01:33.031] save_nestlevel = 2 [08:01:33.031] address = {classId = 0, objectId = 0, objectSubId = 0} [08:01:33.031] __func__ = "RefreshMatViewByOid" [08:01:33.031] #8 0x000055d052ca6814 in ExecRefreshMatView (stmt=0x55d087e8a6f0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [08:01:33.031] matviewOid = [08:01:33.031] lockmode = [08:01:33.031] #9 0x000055d052c5c461 in ExecCreateTableAs (pstate=pstate@entry=0x55d087ea0290, stmt=stmt@entry=0x55d087d337f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffddf972910) at ../src/backend/commands/createas.c:351 [08:01:33.031] refresh = [08:01:33.031] query = 0x55d087d339b0 [08:01:33.031] into = 0x55d087d33548 [08:01:33.031] jstate = 0x0 [08:01:33.031] is_matview = true [08:01:33.031] do_refresh = false [08:01:33.031] dest = [08:01:33.031] address = {classId = 1259, objectId = 28440, objectSubId = 0} [08:01:33.031] __func__ = "ExecCreateTableAs" [08:01:33.031] #10 0x000055d053175f73 in ProcessUtilitySlow (pstate=pstate@entry=0x55d087ea0290, pstmt=pstmt@entry=0x55d087d338a0, queryString=queryString@entry=0x55d087d32ab0 "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=0x55d087d342d8, qc=0x7ffddf972910) at ../src/backend/tcop/utility.c:1678 [08:01:33.031] _save_exception_stack = 0x7ffddf9727d0 [08:01:33.031] _save_context_stack = 0x0 [08:01:33.031] _local_sigjmp_buf = {{__jmpbuf = {0, 5235463635257263483, 94354120325104, 0, 94354120321712, 0, 2085917560422532475, 5235913923751970171}, __mask_was_saved = 0, __saved_mask = {__val = {139805635417728, 10575, 94353235023833, 1, 4294977871, 139805635417728, 94353235014151, 1, 45421559166872, 1, 10575, 139805635417728, 139805635417728, 1, 94353235024180, 94354121570200}}}} [08:01:33.031] _do_rethrow = false [08:01:33.031] parsetree = 0x55d087d337f0 [08:01:33.031] isTopLevel = true [08:01:33.031] isCompleteQuery = true [08:01:33.031] needCleanup = false [08:01:33.031] commandCollected = false [08:01:33.031] address = {classId = 21968, objectId = 2278766576, objectSubId = 21968} [08:01:33.031] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:01:33.031] __func__ = "ProcessUtilitySlow" [08:01:33.031] #11 0x000055d053174584 in standard_ProcessUtility (pstmt=0x55d087d338a0, queryString=0x55d087d32ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55d087d342d8, qc=0x7ffddf972910) at ../src/backend/tcop/utility.c:1070 [08:01:33.031] parsetree = 0x55d087d337f0 [08:01:33.031] isTopLevel = true [08:01:33.031] isAtomicContext = false [08:01:33.031] pstate = 0x55d087ea0290 [08:01:33.031] readonly_flags = [08:01:33.031] __func__ = "standard_ProcessUtility" [08:01:33.031] #12 0x000055d0531746df in ProcessUtility (pstmt=pstmt@entry=0x55d087d338a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55d087d342d8, qc=0x7ffddf972910) at ../src/backend/tcop/utility.c:523 [08:01:33.031] No locals. [08:01:33.031] #13 0x000055d05316ff4b in PortalRunUtility (portal=portal@entry=0x55d087db5050, pstmt=pstmt@entry=0x55d087d338a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d087d342d8, qc=qc@entry=0x7ffddf972910) at ../src/backend/tcop/pquery.c:1158 [08:01:33.031] No locals. [08:01:33.031] #14 0x000055d0531704f0 in PortalRunMulti (portal=portal@entry=0x55d087db5050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d087d342d8, altdest=altdest@entry=0x55d087d342d8, qc=qc@entry=0x7ffddf972910) at ../src/backend/tcop/pquery.c:1315 [08:01:33.031] pstmt = 0x55d087d338a0 [08:01:33.031] stmtlist_item__state = [08:01:33.031] active_snapshot_set = false [08:01:33.031] stmtlist_item = 0x55d087d342a0 [08:01:33.031] #15 0x000055d053170ac3 in PortalRun (portal=portal@entry=0x55d087db5050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55d087d342d8, altdest=altdest@entry=0x55d087d342d8, qc=0x7ffddf972910) at ../src/backend/tcop/pquery.c:791 [08:01:33.031] _save_exception_stack = 0x7ffddf9729c0 [08:01:33.031] _save_context_stack = 0x0 [08:01:33.031] _local_sigjmp_buf = {{__jmpbuf = {0, 5235463639200957819, 94354120855632, 94354120325224, 94354120855632, 94354120325152, 2085917560535778683, 5235913921261995387}, __mask_was_saved = 0, __saved_mask = {__val = {94353238526578, 94354120321456, 112, 4, 94353238530995, 3751225503, 4, 94354120325152, 112, 73, 94354120855632, 94354120325224, 94354120325200, 94354120325152, 94353238618198, 1}}}} [08:01:33.031] _do_rethrow = [08:01:33.031] result = [08:01:33.031] nprocessed = [08:01:33.031] saveTopTransactionResourceOwner = 0x55d087d71d08 [08:01:33.031] saveTopTransactionContext = 0x55d087dc6c60 [08:01:33.031] saveActivePortal = 0x0 [08:01:33.031] saveResourceOwner = 0x55d087d71d08 [08:01:33.031] savePortalContext = 0x0 [08:01:33.031] saveMemoryContext = 0x55d087dc6c60 [08:01:33.031] __func__ = "PortalRun" [08:01:33.031] #16 0x000055d053169eaf in exec_simple_query (query_string=query_string@entry=0x55d087d32ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [08:01:33.031] cmdtaglen = 24 [08:01:33.031] snapshot_set = [08:01:33.031] per_parsetree_context = 0x0 [08:01:33.031] plantree_list = 0x55d087d34288 [08:01:33.031] parsetree = 0x55d087d33820 [08:01:33.031] commandTag = [08:01:33.031] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:01:33.031] querytree_list = [08:01:33.031] portal = 0x55d087db5050 [08:01:33.031] receiver = 0x55d087d342d8 [08:01:33.031] format = 0 [08:01:33.031] cmdtagname = [08:01:33.031] parsetree_item__state = [08:01:33.031] dest = DestRemote [08:01:33.031] oldcontext = 0x55d087dc6c60 [08:01:33.031] parsetree_list = 0x55d087d33850 [08:01:33.031] parsetree_item = 0x55d087d33868 [08:01:33.031] save_log_statement_stats = false [08:01:33.031] was_logged = false [08:01:33.031] use_implicit_block = false [08:01:33.031] msec_str = "p+\227\337\375\177\000\000z9BS\320U\000\000\240)\227\337\375\177\000\000G\000\000\000\000\000\000" [08:01:33.031] __func__ = "exec_simple_query" [08:01:33.031] #17 0x000055d05316cc33 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [08:01:33.031] query_string = 0x55d087d32ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [08:01:33.031] firstchar = [08:01:33.031] input_message = {data = 0x55d087d32ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [08:01:33.031] local_sigjmp_buf = {{__jmpbuf = {94353251153304, 5235924807806879099, 4, 140728354679664, 140728354679808, 140728354679812, 2085917560221205883, 5235913936649717115}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94354120052176, 15616, 94353251147392, 94354120576192, 140728354679808, 94353238530543, 0, 9, 2, 94353251153312, 94354120052176, 94353251147392, 140728354679664, 140728354679808, 140728354679812}}}} [08:01:33.031] send_ready_for_query = false [08:01:33.031] idle_in_transaction_timeout_enabled = false [08:01:33.031] idle_session_timeout_enabled = false [08:01:33.031] __func__ = "PostgresMain" [08:01:33.031] #18 0x000055d053162aa9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:01:33.031] bsdata = [08:01:33.031] #19 0x000055d053016497 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffddf972b1c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffddf972b70) at ../src/backend/postmaster/launch_backend.c:266 [08:01:33.031] pid = [08:01:33.031] #20 0x000055d05301bf4b in BackendStartup (client_sock=client_sock@entry=0x7ffddf972b70) at ../src/backend/postmaster/postmaster.c:3417 [08:01:33.031] bn = 0x55d087d5b348 [08:01:33.031] pid = [08:01:33.031] startup_data = {canAcceptConnections = CAC_OK} [08:01:33.031] __func__ = "BackendStartup" [08:01:33.031] #21 0x000055d05301c4ad in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [08:01:33.031] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "b\024'\177\000\0004,\227\337\375\177\000\000\312`\353\025'\177\000\000>\004\000\000\000\000\000\000\260\227c\024'\177\000\000\240o\263\025'\177\000\0008,\227\337\375\177\000\0004,\227\337\375\177\000\000\000\000\000\000\000\000\000\000\320+\227\337\375\177\000\000j\221\034R\320U\000\000(w\030R\320U\000\000\000-\227\337\375\177\000\000\370,\227\337\375\177\000\000\225[\362\001\000\000\000", __ss_align = 139805837554848}, salen = 2}} [08:01:33.031] i = 0 [08:01:33.031] now = [08:01:33.031] last_lockfile_recheck_time = 1731225445 [08:01:33.031] last_touch_time = 1731225445 [08:01:33.031] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f2715ee02e0}, {pos = -543740808, events = 0, fd = 0, user_data = 0x7f2715ee0668}, {pos = 1377603946, events = 21968, fd = 367920744, user_data = 0x7f271548f630}, {pos = 367919840, events = 32551, fd = 2090263927, user_data = 0x7ffddf972d80}, {pos = 367749704, events = 32551, fd = 15, user_data = 0x7f271548f630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 367919840, events = 32551, fd = -543740680, user_data = 0x7ffddf972d00}, {pos = 367920744, events = 32551, fd = 0, user_data = 0x55d087d5f748}, {pos = -2016020952, events = 21968, fd = -2016012223, user_data = 0x7f2700000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f271462e020}, {pos = 364081056, events = 32551, fd = -2016020664, user_data = 0x7ffddf9730f0}, {pos = -2016020296, events = 21968, fd = -2016050512, user_data = 0x55d087d5f748}, {pos = 367919840, events = 32551, fd = 427, user_data = 0x55d0539a0d58 }, {pos = 0, events = 0, fd = 1, user_data = 0x55d087d32b70}, {pos = 367775422, events = 32551, fd = 1, user_data = 0x0}, {pos = 342024224, events = 32551, fd = 342830656, user_data = 0x7ffddf973160}, {pos = -543739584, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 367784378, user_data = 0x0}, {pos = 342551972, events = 32551, fd = 0, user_data = 0x55d05403bf00 }, {pos = 2, events = 0, fd = 7, user_data = 0x55d087cf4e70}, {pos = 0, events = 0, fd = 342058184, user_data = 0x7f271469c880 }, {pos = 306331064, events = 32551, fd = 8096, user_data = 0x100007f00000002}, {pos = 342585453, events = 32551, fd = 2, user_data = 0x55d087d5e410}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 343874656, events = 32551, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55d087cf4e70}, {pos = 342588042, events = 32551, fd = 1549556828, user_data = 0x55d087cf4e70}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294901760, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x6b4936432d737365}, {pos = 168456033, events = 840966176, fd = 822763892, user_data = 0x30340a3534343532}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x7f0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xc1c5e970c67ec900}, {pos = 343860704, events = 32551, fd = -328, user_data = 0x0}, {pos = -2016021272, events = 21968, fd = 1024, user_data = 0x55d087d5f4e8}, {pos = -543739400, events = 32765, fd = 342589215, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 25435, events = 0, fd = -328, user_data = 0x0}, {pos = -2016203920, events = 21968, fd = 342831187, user_data = 0x7ffddf9731f8}, {pos = 1397051366, events = 21968, fd = 1409594704, user_data = 0x55d053443aa3 }, {pos = -2016021472, events = 21968, fd = -2016204368, user_data = 0x55d087d5f420}, {pos = 342579390, events = 32551, fd = 0, user_data = 0x55d05345570d }, {pos = -2016021472, events = 1, fd = 1397053526, user_data = 0x55d087d329b0}, {pos = -964769536, events = 3250973040, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 342502065, user_data = 0x7f27146a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -964769536, user_data = 0x55d087d0a0e0}, {pos = -964769536, events = 3250973040, fd = 11, user_data = 0xc1c5e970c67ec900}, {pos = 0, events = 0, fd = 342209081, user_data = 0x1}, {pos = 1392599444, events = 21968, fd = 4194304, user_data = 0x55d053443937 }, {pos = -2016370464, events = 21968, fd = -2016204368, user_data = 0x55d087d0a0e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55d05345570d }, {pos = -2016370464, events = 21968, fd = 1397053526, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55d052e49580 }, {pos = 0, events = 0, fd = 1390733504, user_data = 0xb}, {pos = 1392620601, events = 21968, fd = 1405972368, user_data = 0x55d087d33388}} [08:01:33.031] nevents = 1 [08:01:33.031] __func__ = "ServerLoop" [08:01:33.031] #22 0x000055d05301dc30 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55d087cf0d30) at ../src/backend/postmaster/postmaster.c:1348 [08:01:33.031] opt = [08:01:33.031] status = [08:01:33.031] userDoption = [08:01:33.031] listen_addr_saved = false [08:01:33.031] output_config_variable = [08:01:33.031] __func__ = "PostmasterMain" [08:01:33.031] #23 0x000055d052e59908 in main (argc=8, argv=0x55d087cf0d30) at ../src/backend/main/main.c:196 [08:01:33.031] do_check_root = [08:01:33.068] -e [08:01:33.068] [08:01:33.068] [08:01:33.133] dumping /tmp/cores/postgres-6-29569.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:01:33.397] [New LWP 29569] [08:01:33.397] [08:01:33.397] This GDB supports auto-downloading debuginfo from the following URLs: [08:01:33.397] [08:01:33.397] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:01:33.397] Debuginfod has been disabled. [08:01:33.397] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:01:33.506] [Thread debugging using libthread_db enabled] [08:01:33.506] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:01:33.506] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [08:01:33.506] Program terminated with signal SIGABRT, Aborted. [08:01:33.506] #0 0x00007f81892a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:34.438] [08:01:34.438] Thread 1 (Thread 0x7f8187238f00 (LWP 29569)): [08:01:34.438] #0 0x00007f81892a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:34.438] No symbol table info available. [08:01:34.438] #1 0x00007f818925afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:34.438] No symbol table info available. [08:01:34.438] #2 0x00007f8189245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:34.438] No symbol table info available. [08:01:34.438] #3 0x0000562a7ca0cbcc in ExceptionalCondition (conditionName=conditionName@entry=0x562a7cc82395 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x562a7cc818b0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [08:01:34.438] No locals. [08:01:34.438] #4 0x0000562a7c38e8c5 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x562a8057a460, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [08:01:34.438] estate = 0x562a805d0af0 [08:01:34.438] oldcontext = 0x562a80564200 [08:01:34.438] __func__ = "standard_ExecutorStart" [08:01:34.438] #5 0x0000562a7c38eaa1 in ExecutorStart (queryDesc=queryDesc@entry=0x562a8057a460, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [08:01:34.438] No locals. [08:01:34.438] #6 0x0000562a7c2b336e in refresh_matview_datafill (dest=0x562a8059e5b8, query=, query@entry=0x562a805b3640, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [08:01:34.438] rewritten = [08:01:34.438] plan = 0x562a80579998 [08:01:34.438] queryDesc = 0x562a8057a460 [08:01:34.438] copied_query = [08:01:34.438] processed = [08:01:34.438] __func__ = "refresh_matview_datafill" [08:01:34.438] #7 0x0000562a7c2b56d5 in RefreshMatViewByOid (matviewOid=28369, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [08:01:34.438] dest = [08:01:34.438] matviewRel = 0x7f817dba54f8 [08:01:34.438] rule = [08:01:34.438] actions = [08:01:34.438] dataQuery = 0x562a805b3640 [08:01:34.438] tableSpace = [08:01:34.438] relowner = 10 [08:01:34.438] OIDNewHeap = 28386 [08:01:34.438] processed = 0 [08:01:34.438] relpersistence = 112 'p' [08:01:34.438] save_userid = 10 [08:01:34.438] save_sec_context = 0 [08:01:34.438] save_nestlevel = 2 [08:01:34.438] address = {classId = 0, objectId = 0, objectSubId = 0} [08:01:34.438] __func__ = "RefreshMatViewByOid" [08:01:34.438] #8 0x0000562a7c2b5814 in ExecRefreshMatView (stmt=0x562a8057f5a0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [08:01:34.438] matviewOid = [08:01:34.438] lockmode = [08:01:34.438] #9 0x0000562a7c26b461 in ExecCreateTableAs (pstate=pstate@entry=0x562a80564300, stmt=stmt@entry=0x562a8043c770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe76a4a120) at ../src/backend/commands/createas.c:351 [08:01:34.438] refresh = [08:01:34.438] query = 0x562a8043c930 [08:01:34.438] into = 0x562a8043c4c8 [08:01:34.438] jstate = 0x0 [08:01:34.438] is_matview = true [08:01:34.438] do_refresh = false [08:01:34.438] dest = [08:01:34.438] address = {classId = 1259, objectId = 28369, objectSubId = 0} [08:01:34.438] __func__ = "ExecCreateTableAs" [08:01:34.438] #10 0x0000562a7c784f73 in ProcessUtilitySlow (pstate=pstate@entry=0x562a80564300, pstmt=pstmt@entry=0x562a8043c820, queryString=queryString@entry=0x562a8043ba30 "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=0x562a8043d258, qc=0x7ffe76a4a120) at ../src/backend/tcop/utility.c:1678 [08:01:34.438] _save_exception_stack = 0x7ffe76a49fe0 [08:01:34.438] _save_context_stack = 0x0 [08:01:34.438] _local_sigjmp_buf = {{__jmpbuf = {0, 7419476686083634562, 94740540540784, 0, 94740540537392, 0, 3845699641193444738, 7419327217818187138}, __mask_was_saved = 0, __saved_mask = {__val = {140194142224192, 15222, 94740476299225, 1, 4294982518, 140194142224192, 94740480118270, 140194294762936, 94740540537392, 94740482445349, 94740492420130, 94740492420256, 140730888920612, 94740482640248, 94740492420145, 94740492420256}}}} [08:01:34.438] _do_rethrow = false [08:01:34.438] parsetree = 0x562a8043c770 [08:01:34.438] isTopLevel = true [08:01:34.438] isCompleteQuery = true [08:01:34.438] needCleanup = false [08:01:34.438] commandCollected = false [08:01:34.438] address = {classId = 22058, objectId = 2151925616, objectSubId = 22058} [08:01:34.438] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:01:34.438] __func__ = "ProcessUtilitySlow" [08:01:34.438] #11 0x0000562a7c783584 in standard_ProcessUtility (pstmt=0x562a8043c820, queryString=0x562a8043ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x562a8043d258, qc=0x7ffe76a4a120) at ../src/backend/tcop/utility.c:1070 [08:01:34.438] parsetree = 0x562a8043c770 [08:01:34.438] isTopLevel = true [08:01:34.438] isAtomicContext = false [08:01:34.438] pstate = 0x562a80564300 [08:01:34.438] readonly_flags = [08:01:34.438] __func__ = "standard_ProcessUtility" [08:01:34.438] #12 0x0000562a7c7836df in ProcessUtility (pstmt=pstmt@entry=0x562a8043c820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x562a8043d258, qc=0x7ffe76a4a120) at ../src/backend/tcop/utility.c:523 [08:01:34.438] No locals. [08:01:34.438] #13 0x0000562a7c77ef4b in PortalRunUtility (portal=portal@entry=0x562a804be680, pstmt=pstmt@entry=0x562a8043c820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562a8043d258, qc=qc@entry=0x7ffe76a4a120) at ../src/backend/tcop/pquery.c:1158 [08:01:34.438] No locals. [08:01:34.438] #14 0x0000562a7c77f4f0 in PortalRunMulti (portal=portal@entry=0x562a804be680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562a8043d258, altdest=altdest@entry=0x562a8043d258, qc=qc@entry=0x7ffe76a4a120) at ../src/backend/tcop/pquery.c:1315 [08:01:34.438] pstmt = 0x562a8043c820 [08:01:34.438] stmtlist_item__state = [08:01:34.438] active_snapshot_set = false [08:01:34.438] stmtlist_item = 0x562a8043d220 [08:01:34.438] #15 0x0000562a7c77fac3 in PortalRun (portal=portal@entry=0x562a804be680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x562a8043d258, altdest=altdest@entry=0x562a8043d258, qc=0x7ffe76a4a120) at ../src/backend/tcop/pquery.c:791 [08:01:34.438] _save_exception_stack = 0x7ffe76a4a1d0 [08:01:34.438] _save_context_stack = 0x0 [08:01:34.438] _local_sigjmp_buf = {{__jmpbuf = {0, 7419476685755430274, 94740541073024, 94740540540904, 94740541073024, 94740540540832, 3845699641357022594, 7419327253997860226}, __mask_was_saved = 0, __saved_mask = {__val = {94740479801970, 94740540537136, 112, 4, 94740479806387, 1990500527, 4, 94740540540832, 112, 73, 94740541073024, 94740540540904, 94740540540880, 94740540540832, 94740479893590, 1}}}} [08:01:34.438] _do_rethrow = [08:01:34.438] result = [08:01:34.438] nprocessed = [08:01:34.438] saveTopTransactionResourceOwner = 0x562a8047b838 [08:01:34.438] saveTopTransactionContext = 0x562a804cf660 [08:01:34.438] saveActivePortal = 0x0 [08:01:34.438] saveResourceOwner = 0x562a8047b838 [08:01:34.438] savePortalContext = 0x0 [08:01:34.438] saveMemoryContext = 0x562a804cf660 [08:01:34.438] __func__ = "PortalRun" [08:01:34.438] #16 0x0000562a7c778eaf in exec_simple_query (query_string=query_string@entry=0x562a8043ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [08:01:34.438] cmdtaglen = 24 [08:01:34.438] snapshot_set = [08:01:34.438] per_parsetree_context = 0x0 [08:01:34.438] plantree_list = 0x562a8043d208 [08:01:34.438] parsetree = 0x562a8043c7a0 [08:01:34.438] commandTag = [08:01:34.438] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:01:34.438] querytree_list = [08:01:34.438] portal = 0x562a804be680 [08:01:34.438] receiver = 0x562a8043d258 [08:01:34.438] format = 0 [08:01:34.438] cmdtagname = [08:01:34.438] parsetree_item__state = [08:01:34.438] dest = DestRemote [08:01:34.438] oldcontext = 0x562a804cf660 [08:01:34.438] parsetree_list = 0x562a8043c7d0 [08:01:34.438] parsetree_item = 0x562a8043c7e8 [08:01:34.438] save_log_statement_stats = false [08:01:34.438] was_logged = true [08:01:34.438] use_implicit_block = false [08:01:34.438] msec_str = "\200\243\244v\376\177\000\000z)\243|*V\000\000\260\241\244v\376\177\000\000G\000\000\000\000\000\000" [08:01:34.438] __func__ = "exec_simple_query" [08:01:34.438] #17 0x0000562a7c77bc33 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [08:01:34.438] query_string = 0x562a8043ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [08:01:34.438] firstchar = [08:01:34.438] input_message = {data = 0x562a8043ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [08:01:34.438] local_sigjmp_buf = {{__jmpbuf = {94740492428696, 7419325178310473090, 4, 140730888921984, 140730888922128, 140730888922132, 3845699640992118146, 7419327256519292290}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94740540267952, 14336, 94740492422784, 94740540794864, 140730888922128, 94740479805935, 0, 9, 2, 94740492428704, 94740540267952, 94740492422784, 140730888921984, 140730888922128, 140730888922132}}}} [08:01:34.438] send_ready_for_query = false [08:01:34.438] idle_in_transaction_timeout_enabled = false [08:01:34.438] idle_session_timeout_enabled = false [08:01:34.438] __func__ = "PostgresMain" [08:01:34.438] #18 0x0000562a7c771aa9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:01:34.438] bsdata = [08:01:34.438] #19 0x0000562a7c625497 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe76a4a32c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe76a4a380) at ../src/backend/postmaster/launch_backend.c:266 [08:01:34.438] pid = [08:01:34.438] #20 0x0000562a7c62af4b in BackendStartup (client_sock=client_sock@entry=0x7ffe76a4a380) at ../src/backend/postmaster/postmaster.c:3417 [08:01:34.438] bn = 0x562a80470a78 [08:01:34.438] pid = [08:01:34.438] startup_data = {canAcceptConnections = CAC_OK} [08:01:34.438] __func__ = "BackendStartup" [08:01:34.438] #21 0x0000562a7c62b4ad in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [08:01:34.438] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\267\212\201\177\000\000>\004\000\000\000\000\000\000\260\227#\211\201\177\000\000\240_y\212\201\177\000\0008\244\244v\376\177\000\0004\244\244v\376\177", '\000' , "j\201}{*V\000\000(gy{*V\000\000\000\245\244v\376\177\000\000\370\244\244v\376\177\000\000\225[\362\001\000\274\333\177\240\304r\212\201\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [08:01:34.438] i = 0 [08:01:34.438] now = [08:01:34.438] last_lockfile_recheck_time = 1731225448 [08:01:34.438] last_touch_time = 1731225448 [08:01:34.438] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 1990501696, user_data = 0x0}, {pos = 15, events = 0, fd = 2071822698, user_data = 0x7f818ab9e668}, {pos = -1972189648, events = 32641, fd = -1967529248, user_data = 0x7c96e577}, {pos = 1990501760, events = 32766, fd = -1967699384, user_data = 0xf}, {pos = -1972189648, events = 32641, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1967529248, user_data = 0x7ffe76a4a4f8}, {pos = 1990501632, events = 32766, fd = -1967528344, user_data = 0x0}, {pos = -2143037456, events = 22058, fd = -1993413275, user_data = 0x7ffe76a4aa13}, {pos = 1, events = 0, fd = 1990501632, user_data = 0xffffffff}, {pos = -1994203104, events = 32641, fd = -1971757152, user_data = 0x562a8046a368}, {pos = -2142854584, events = 22058, fd = -2142855135, user_data = 0x7f818ab7aebe}, {pos = 1, events = 0, fd = -1967529248, user_data = 0x1ab}, {pos = 2096823640, events = 22058, fd = 0, user_data = 0x1}, {pos = -2143045048, events = 22058, fd = -1967673666, user_data = 0x1}, {pos = 0, events = 0, fd = -1994203104, user_data = 0x7f81892f2e40 }, {pos = 16, events = 0, fd = 1990502736, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f818ab7d1ba}, {pos = 0, events = 0, fd = -1993675356, user_data = 0x0}, {pos = 2103750400, events = 22058, fd = 2, user_data = 0x7}, {pos = -2143297968, events = 22058, fd = 1952410737, user_data = 0x161}, {pos = 2096823048, events = 22058, fd = 4, user_data = 0x2ffff00001fa0}, {pos = -2143045048, events = 22058, fd = -1967673666, user_data = 0x1}, {pos = -1993642233, events = 32641, fd = -1994169144, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1992352672, events = 32641, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x562a803fde50}, {pos = -1993639286, events = 32641, 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 = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, 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 = -1992369696, events = 32641, fd = -1993731730, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x7fdbbc00dd401900}, {pos = -1992366624, events = 32641, fd = -328, user_data = 0x0}, {pos = -2142854904, events = 22058, fd = 1024, user_data = 0x562a8046a108}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 26056, events = 0, fd = -328, user_data = 0x0}, {pos = -2143045048, events = 22058, fd = -1993396141, user_data = 0x7ffe76a4aa08}, {pos = 2091270118, events = 22058, fd = 2103813456, user_data = 0x562a7ca52aa3 }, {pos = -2142855104, events = 22058, fd = -2143045328, user_data = 0x562a8046a040}, {pos = -1993648277, events = 32641, fd = 0, user_data = 0x562a7ca6470d }, {pos = -2142855104, events = 1, fd = 2091272278, user_data = 0x562a8043b930}, {pos = -583001856, events = 2145106944, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1993725263, user_data = 0x7f81892a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -583001856, user_data = 0x562a80413060}, {pos = -583001856, events = 2145106944, fd = 11, user_data = 0x7fdbbc00dd401900}, {pos = 0, events = 0, fd = -1994018247, user_data = 0x1}, {pos = 2086818196, events = 22058, fd = 4194304, user_data = 0x562a7ca52937 }, {pos = -2143211424, events = 22058, fd = -2143045328, user_data = 0x562a80413060}, {pos = 1, events = 0, fd = 0, user_data = 0x562a7ca6470d }, {pos = -2143211424, events = 22058, fd = 2091272278, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x562a7c458580 }, {pos = 0, events = 0, fd = 2084952256, user_data = 0xb}, {pos = 2086839353, events = 22058, fd = 2100191120, user_data = 0x562a8043c2d8}} [08:01:34.439] nevents = 1 [08:01:34.439] __func__ = "ServerLoop" [08:01:34.439] #22 0x0000562a7c62cc30 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x562a803f9cc0) at ../src/backend/postmaster/postmaster.c:1348 [08:01:34.439] opt = [08:01:34.439] status = [08:01:34.439] userDoption = [08:01:34.439] listen_addr_saved = false [08:01:34.439] output_config_variable = [08:01:34.439] __func__ = "PostmasterMain" [08:01:34.439] #23 0x0000562a7c468908 in main (argc=4, argv=0x562a803f9cc0) at ../src/backend/main/main.c:196 [08:01:34.439] do_check_root =