[20:58:24.122] src/tools/ci/cores_backtrace.sh linux /tmp/cores [20:58:24.335] dumping /tmp/cores/postgres-6-36150.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:58:24.585] [New LWP 36150] [20:58:24.585] [20:58:24.585] This GDB supports auto-downloading debuginfo from the following URLs: [20:58:24.585] [20:58:24.585] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:58:24.585] Debuginfod has been disabled. [20:58:24.585] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:58:24.716] [Thread debugging using libthread_db enabled] [20:58:24.716] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:58:24.716] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [20:58:24.716] Program terminated with signal SIGABRT, Aborted. [20:58:24.716] #0 0x00007f07678a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:25.710] [20:58:25.710] Thread 1 (Thread 0x7f07675d4f00 (LWP 36150)): [20:58:25.710] #0 0x00007f07678a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:25.710] No symbol table info available. [20:58:25.710] #1 0x00007f076785afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:25.710] No symbol table info available. [20:58:25.710] #2 0x00007f0767845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:25.710] No symbol table info available. [20:58:25.710] #3 0x000055b0e9887008 in ExceptionalCondition (conditionName=conditionName@entry=0x55b0e9afc475 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55b0e9afb990 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [20:58:25.710] No locals. [20:58:25.710] #4 0x000055b0e9206133 in standard_ExecutorStart (queryDesc=0x55b0ff3adaf0, eflags=0) at ../src/backend/executor/execMain.c:195 [20:58:25.710] estate = 0x55b0ff3ea780 [20:58:25.710] oldcontext = 0x55b0ff3b4570 [20:58:25.710] __func__ = "standard_ExecutorStart" [20:58:25.710] #5 0x00007f0764ec26f7 in pgss_ExecutorStart (queryDesc=0x55b0ff3adaf0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [20:58:25.710] No locals. [20:58:25.710] #6 0x000055b0e92062c8 in ExecutorStart (queryDesc=queryDesc@entry=0x55b0ff3adaf0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [20:58:25.710] No locals. [20:58:25.710] #7 0x000055b0e912a688 in refresh_matview_datafill (dest=0x55b0ff3aab68, query=, query@entry=0x55b0ff3c0fa0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [20:58:25.710] rewritten = [20:58:25.710] plan = 0x55b0ff3ad028 [20:58:25.710] queryDesc = 0x55b0ff3adaf0 [20:58:25.710] copied_query = [20:58:25.710] processed = [20:58:25.710] __func__ = "refresh_matview_datafill" [20:58:25.710] #8 0x000055b0e912c9ef in RefreshMatViewByOid (matviewOid=28308, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [20:58:25.710] dest = [20:58:25.710] matviewRel = 0x7f07631c5d18 [20:58:25.710] rule = [20:58:25.710] actions = [20:58:25.710] dataQuery = 0x55b0ff3c0fa0 [20:58:25.710] tableSpace = [20:58:25.710] relowner = 10 [20:58:25.710] OIDNewHeap = 28316 [20:58:25.710] processed = 0 [20:58:25.710] relpersistence = 112 'p' [20:58:25.710] save_userid = 10 [20:58:25.710] save_sec_context = 0 [20:58:25.710] save_nestlevel = 2 [20:58:25.710] address = {classId = 0, objectId = 0, objectSubId = 0} [20:58:25.710] __func__ = "RefreshMatViewByOid" [20:58:25.710] #9 0x000055b0e912cb2e in ExecRefreshMatView (stmt=0x55b0ff3e2cf0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:58:25.710] matviewOid = [20:58:25.710] lockmode = [20:58:25.710] #10 0x000055b0e90e2748 in ExecCreateTableAs (pstate=pstate@entry=0x55b0ff3b4670, stmt=stmt@entry=0x55b0ff255790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe214141a0) at ../src/backend/commands/createas.c:351 [20:58:25.710] refresh = [20:58:25.710] query = 0x55b0ff255950 [20:58:25.710] into = 0x55b0ff2554e8 [20:58:25.710] jstate = 0x0 [20:58:25.710] is_matview = true [20:58:25.710] do_refresh = false [20:58:25.710] dest = [20:58:25.710] address = {classId = 1259, objectId = 28308, objectSubId = 0} [20:58:25.710] __func__ = "ExecCreateTableAs" [20:58:25.710] #11 0x000055b0e95fe50e in ProcessUtilitySlow (pstate=pstate@entry=0x55b0ff3b4670, pstmt=pstmt@entry=0x55b0ff255840, queryString=queryString@entry=0x55b0ff254a50 "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=0x55b0ff2567e8, qc=0x7ffe214141a0) at ../src/backend/tcop/utility.c:1678 [20:58:25.710] _save_exception_stack = 0x7ffe21413d50 [20:58:25.710] _save_context_stack = 0x0 [20:58:25.710] _local_sigjmp_buf = {{__jmpbuf = {0, -6151857163673768643, 94218683242384, 0, 94218683238992, 0, -126793171919672003, -6151887997945221827}, __mask_was_saved = 0, __saved_mask = {__val = {17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 94218317403476, 0, 5412384741217271808, 94218323487296, 94218317656069, 139669707158656, 1, 16777216, 0, 112, 94218317403748, 139669707931648}}}} [20:58:25.710] _do_rethrow = false [20:58:25.710] parsetree = 0x55b0ff255790 [20:58:25.710] isTopLevel = true [20:58:25.710] isCompleteQuery = true [20:58:25.710] needCleanup = false [20:58:25.710] commandCollected = false [20:58:25.710] address = {classId = 21936, objectId = 4280637328, objectSubId = 21936} [20:58:25.710] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:58:25.710] __func__ = "ProcessUtilitySlow" [20:58:25.710] #12 0x000055b0e95fcb1f in standard_ProcessUtility (pstmt=pstmt@entry=0x55b0ff255840, queryString=queryString@entry=0x55b0ff254a50 "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=0x55b0ff2567e8, qc=0x7ffe214141a0) at ../src/backend/tcop/utility.c:1070 [20:58:25.710] parsetree = 0x55b0ff255790 [20:58:25.710] isTopLevel = true [20:58:25.710] isAtomicContext = false [20:58:25.710] pstate = 0x55b0ff3b4670 [20:58:25.710] readonly_flags = [20:58:25.710] __func__ = "standard_ProcessUtility" [20:58:25.710] #13 0x00007f0764ec5d9d in pgss_ProcessUtility (pstmt=0x55b0ff255840, queryString=0x55b0ff254a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55b0ff2567e8, qc=0x7ffe214141a0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [20:58:25.710] _save_exception_stack = 0x7ffe21414060 [20:58:25.710] _save_context_stack = 0x0 [20:58:25.710] _local_sigjmp_buf = {{__jmpbuf = {0, 126603035975118141, 94218683242560, 94218683246568, 140729456345504, 0, -126793171890311875, -13791093265502915}, __mask_was_saved = 0, __saved_mask = {__val = {94218321235408, 140729456344774, 140729456344772, 0, 0, 139637976727552, 206158430232, 140729456344736, 94218321235625, 0, 206158430232, 94218683243360, 140729456344832, 0, 94218316037553, 94218683238736}}}} [20:58:25.710] _do_rethrow = false [20:58:25.710] duration = [20:58:25.710] bufusage = {shared_blks_hit = 94218684902328, shared_blks_read = 755914244096, shared_blks_dirtied = 0, shared_blks_written = 94218684901832, local_blks_hit = 94218684902328, local_blks_read = 94218314367424, local_blks_dirtied = 94218684635592, local_blks_written = 94218314367670, temp_blks_read = 94218684901832, temp_blks_written = 94218684901248, shared_blk_read_time = {ticks = 94218314366779}, shared_blk_write_time = {ticks = 94218321228860}, local_blk_read_time = {ticks = 139669775666616}, local_blk_write_time = {ticks = 94218683238992}, temp_blk_read_time = {ticks = 94218323558437}, temp_blk_write_time = {ticks = 94218333541410}} [20:58:25.710] walusage_start = {wal_records = 8950, wal_fpi = 87, wal_bytes = 1034943} [20:58:25.710] start = [20:58:25.710] rows = [20:58:25.710] bufusage_start = {shared_blks_hit = 34304, shared_blks_read = 3570, shared_blks_dirtied = 1470, shared_blks_written = 994, 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}} [20:58:25.710] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 139669707158656} [20:58:25.710] parsetree = [20:58:25.710] saved_queryId = 6041762721901209185 [20:58:25.710] saved_stmt_location = 0 [20:58:25.710] saved_stmt_len = 69 [20:58:25.710] enabled = true [20:58:25.710] #14 0x000055b0e95fcbc5 in ProcessUtility (pstmt=pstmt@entry=0x55b0ff255840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55b0ff2567e8, qc=0x7ffe214141a0) at ../src/backend/tcop/utility.c:519 [20:58:25.710] No locals. [20:58:25.710] #15 0x000055b0e95f84e6 in PortalRunUtility (portal=portal@entry=0x55b0ff2d7fc0, pstmt=pstmt@entry=0x55b0ff255840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55b0ff2567e8, qc=qc@entry=0x7ffe214141a0) at ../src/backend/tcop/pquery.c:1158 [20:58:25.710] No locals. [20:58:25.710] #16 0x000055b0e95f8a8b in PortalRunMulti (portal=portal@entry=0x55b0ff2d7fc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55b0ff2567e8, altdest=altdest@entry=0x55b0ff2567e8, qc=qc@entry=0x7ffe214141a0) at ../src/backend/tcop/pquery.c:1315 [20:58:25.710] pstmt = 0x55b0ff255840 [20:58:25.710] stmtlist_item__state = [20:58:25.710] active_snapshot_set = false [20:58:25.710] stmtlist_item = 0x55b0ff2567b0 [20:58:25.710] #17 0x000055b0e95f905e in PortalRun (portal=portal@entry=0x55b0ff2d7fc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55b0ff2567e8, altdest=altdest@entry=0x55b0ff2567e8, qc=0x7ffe214141a0) at ../src/backend/tcop/pquery.c:791 [20:58:25.710] _save_exception_stack = 0x7ffe21414250 [20:58:25.710] _save_context_stack = 0x0 [20:58:25.710] _local_sigjmp_buf = {{__jmpbuf = {0, -6151857165102977731, 94218683776960, 94218683242504, 94218683776960, 94218683242432, -126793172030821059, -6151888000003183299}, __mask_was_saved = 0, __saved_mask = {__val = {94218320912560, 94218683238736, 112, 4, 94218320916977, 557924655, 4, 94218683242432, 112, 73, 94218683776960, 94218683242504, 94218683242480, 94218683242432, 94218321004180, 1}}}} [20:58:25.710] _do_rethrow = [20:58:25.710] result = [20:58:25.710] nprocessed = [20:58:25.710] saveTopTransactionResourceOwner = 0x55b0ff297498 [20:58:25.710] saveTopTransactionContext = 0x55b0ff2e9fe0 [20:58:25.710] saveActivePortal = 0x0 [20:58:25.710] saveResourceOwner = 0x55b0ff297498 [20:58:25.710] savePortalContext = 0x0 [20:58:25.710] saveMemoryContext = 0x55b0ff2e9fe0 [20:58:25.710] __func__ = "PortalRun" [20:58:25.710] #18 0x000055b0e95f2445 in exec_simple_query (query_string=query_string@entry=0x55b0ff254a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [20:58:25.710] cmdtaglen = 24 [20:58:25.710] snapshot_set = [20:58:25.710] per_parsetree_context = 0x0 [20:58:25.710] plantree_list = 0x55b0ff256798 [20:58:25.710] parsetree = 0x55b0ff2557c0 [20:58:25.710] commandTag = [20:58:25.710] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:58:25.710] querytree_list = [20:58:25.710] portal = 0x55b0ff2d7fc0 [20:58:25.710] receiver = 0x55b0ff2567e8 [20:58:25.710] format = 0 [20:58:25.710] cmdtagname = [20:58:25.710] parsetree_item__state = [20:58:25.710] dest = DestRemote [20:58:25.710] oldcontext = 0x55b0ff2e9fe0 [20:58:25.710] parsetree_list = 0x55b0ff2557f0 [20:58:25.710] parsetree_item = 0x55b0ff255808 [20:58:25.710] save_log_statement_stats = false [20:58:25.710] was_logged = true [20:58:25.710] use_implicit_block = false [20:58:25.710] msec_str = "\004\000\000\000\000\000\000\000\177Ί\351\260U\000\0000BA!\376\177\000\000G\000\000\000\000\000\000" [20:58:25.710] __func__ = "exec_simple_query" [20:58:25.710] #19 0x000055b0e95f51c9 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [20:58:25.710] query_string = 0x55b0ff254a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:58:25.710] firstchar = [20:58:25.710] input_message = {data = 0x55b0ff254a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:58:25.710] local_sigjmp_buf = {{__jmpbuf = {94218333549976, -6151885958086628035, 140729456346028, 4, 8, 140729456346260, -126793168914453187, -6151888002085917379}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94218683496816, 0, 168, 94218320917079, 0, 10, 2, 94218333549984, 94218682969584, 94218333544064, 4, 8, 140729456346260}}}} [20:58:25.710] send_ready_for_query = false [20:58:25.710] idle_in_transaction_timeout_enabled = false [20:58:25.710] idle_session_timeout_enabled = false [20:58:25.710] __func__ = "PostgresMain" [20:58:25.710] #20 0x000055b0e95eb03f in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:58:25.710] bsdata = [20:58:25.710] #21 0x000055b0e949cd91 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x7ffe214143ac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe21414400) at ../src/backend/postmaster/launch_backend.c:274 [20:58:25.710] pid = [20:58:25.710] #22 0x000055b0e94a1d8c in BackendStartup (client_sock=client_sock@entry=0x7ffe21414400) at ../src/backend/postmaster/postmaster.c:3377 [20:58:25.710] bn = 0x55b0ff281208 [20:58:25.710] pid = [20:58:25.710] startup_data = {canAcceptConnections = CAC_OK} [20:58:25.710] cac = [20:58:25.710] __func__ = "BackendStartup" [20:58:25.710] #23 0x000055b0e94a3c65 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [20:58:25.710] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\ni\a\177\000\000>\004\000\000\000\000\000\000\260\227\203g\a\177\000\000\240\377\322h\a\177\000\000\270DA!\376\177\000\000\264DA!\376\177", '\000' , "\242\342d\350\260U\000\000X\307`\350\260U\000\000\200EA!\376\177\000\000xEA!\376\177\000\000\225[\362\001 [20:58:25.710] last_lockfile_recheck_time = 1732395298 [20:58:25.710] last_touch_time = 1732395298 [20:58:25.710] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 557925824, user_data = 0x0}, {pos = 15, events = 0, fd = -396041566, user_data = 0x7f07690d9668}, {pos = 1751676464, events = 32519, fd = 1762497248, user_data = 0x7c96e577}, {pos = 557925888, events = 32766, fd = 1762327112, user_data = 0xf}, {pos = 1751676464, events = 32519, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1762497248, user_data = 0x7ffe21414578}, {pos = 557925760, events = 32766, fd = 1762498152, user_data = 0x0}, {pos = -14330512, events = 21936, fd = 1737420133, user_data = 0x7ffe21414a93}, {pos = 1, events = 0, fd = 557925760, user_data = 0xffffffff}, {pos = 1736630304, events = 32519, fd = 1758658464, user_data = 0x55b0ff285658}, {pos = -14133960, events = 21936, fd = -14110463, user_data = 0x7f07690b5ebe}, {pos = 1, events = 0, fd = 1762497248, user_data = 0x1ab}, {pos = -371020456, events = 21936, fd = 0, user_data = 0x56}, {pos = -14143288, events = 21936, fd = 1762352830, user_data = 0x1}, {pos = 0, events = 0, fd = 1736630304, user_data = 0x7f07678f2e40 }, {pos = 16, events = 0, fd = 557926848, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f07690b81ba}, {pos = 0, events = 0, fd = 1737158052, user_data = 0x0}, {pos = -364086976, events = 21936, fd = 2, user_data = 0x0}, {pos = -14586224, events = 21936, fd = 1952410737, user_data = 0x161}, {pos = -371021048, events = 21936, fd = 4, user_data = 0x2ffff00001fa0}, {pos = -14143288, events = 21936, fd = 1762352830, user_data = 0x1}, {pos = 1737191175, events = 32519, fd = 1736664264, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1738480736, events = 32519, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55b0ff216e90}, {pos = 1737194122, events = 32519, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f0768688540}, {pos = 1751681664, events = 32519, 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 = 1738463712, events = 32519, fd = 1737101678, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x6226513c77a05f00}, {pos = 1738466784, events = 32519, fd = -328, user_data = 0x0}, {pos = -14134280, events = 21936, fd = 1024, user_data = 0x55b0ff2853f8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 32398, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -14143288, user_data = 0x7f07678f3053 }, {pos = -14134280, events = 21936, fd = 1024, user_data = 0x7ffe21414a88}, {pos = -376576476, events = 21936, fd = -364022448, user_data = 0x55b0e98cd0e1 }, {pos = -14134480, events = 21936, fd = -14333616, user_data = 0x55b0ff285330}, {pos = 1737185131, events = 32519, fd = 0, user_data = 0x55b0e98ded4b }, {pos = -14134480, events = 1, fd = -376574316, user_data = 0x55b0ff254950}, {pos = 2006998784, events = 1646678332, fd = 0, user_data = 0x7f07678a2ab1}, {pos = 1737102576, events = 32519, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -14586224, user_data = 0x6226513c77a05f00}, {pos = 0, events = 0, fd = 2006998784, user_data = 0xc}, {pos = 2006998784, events = 1646678332, fd = 0, user_data = 0x7f076785b239 }, {pos = 87, events = 0, fd = -381039986, user_data = 0x400000}, {pos = 0, events = 0, fd = -14586224, user_data = 0x55b0e98ccf75 }, {pos = -14499712, events = 21936, fd = -14333616, user_data = 0x55b0ff22c080}, {pos = 1, events = 0, fd = 0, user_data = 0x55b0e988b972 }, {pos = 12, events = 0, fd = -14147336, user_data = 0x55b0ff2820d8}, {pos = -364085568, events = 21936, fd = 296, user_data = 0x55b0e949f2a8 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -381023515, events = 21936, fd = -367653968, user_data = 0x55b0ff255308}} [20:58:25.710] nevents = 1 [20:58:25.710] __func__ = "ServerLoop" [20:58:25.710] #24 0x000055b0e94a54f6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55b0ff212cf0) at ../src/backend/postmaster/postmaster.c:1361 [20:58:25.710] opt = [20:58:25.710] status = [20:58:25.710] userDoption = [20:58:25.710] listen_addr_saved = false [20:58:25.710] output_config_variable = [20:58:25.710] __func__ = "PostmasterMain" [20:58:25.710] #25 0x000055b0e92e01bb in main (argc=4, argv=0x55b0ff212cf0) at ../src/backend/main/main.c:196 [20:58:25.710] do_check_root = [20:58:25.746] -e [20:58:25.746] [20:58:25.746] [20:58:25.807] dumping /tmp/cores/postgres-6-29746.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:58:26.053] [New LWP 29746] [20:58:26.053] [20:58:26.053] This GDB supports auto-downloading debuginfo from the following URLs: [20:58:26.053] [20:58:26.053] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:58:26.053] Debuginfod has been disabled. [20:58:26.053] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:58:26.158] [Thread debugging using libthread_db enabled] [20:58:26.158] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:58:26.158] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [20:58:26.158] Program terminated with signal SIGABRT, Aborted. [20:58:26.158] #0 0x00007f168cca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:27.133] [20:58:27.133] Thread 1 (Thread 0x7f168d432f00 (LWP 29746)): [20:58:27.133] #0 0x00007f168cca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:27.133] No symbol table info available. [20:58:27.133] #1 0x00007f168cc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:27.133] No symbol table info available. [20:58:27.133] #2 0x00007f168cc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:27.133] No symbol table info available. [20:58:27.133] #3 0x000055bc276ce008 in ExceptionalCondition (conditionName=conditionName@entry=0x55bc27943475 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55bc27942990 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [20:58:27.133] No locals. [20:58:27.133] #4 0x000055bc2704d133 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55bc545cae00, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [20:58:27.133] estate = 0x55bc5451be10 [20:58:27.133] oldcontext = 0x55bc545265b0 [20:58:27.133] __func__ = "standard_ExecutorStart" [20:58:27.133] #5 0x000055bc2704d30f in ExecutorStart (queryDesc=queryDesc@entry=0x55bc545cae00, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [20:58:27.133] No locals. [20:58:27.133] #6 0x000055bc26f71688 in refresh_matview_datafill (dest=0x55bc545c7e48, query=, query@entry=0x55bc545c2af0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [20:58:27.133] rewritten = [20:58:27.133] plan = 0x55bc545ca308 [20:58:27.133] queryDesc = 0x55bc545cae00 [20:58:27.133] copied_query = [20:58:27.133] processed = [20:58:27.133] __func__ = "refresh_matview_datafill" [20:58:27.133] #7 0x000055bc26f739ef in RefreshMatViewByOid (matviewOid=28145, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [20:58:27.133] dest = [20:58:27.133] matviewRel = 0x7f168156d648 [20:58:27.133] rule = [20:58:27.133] actions = [20:58:27.133] dataQuery = 0x55bc545c2af0 [20:58:27.133] tableSpace = [20:58:27.133] relowner = 10 [20:58:27.133] OIDNewHeap = 28207 [20:58:27.133] processed = 0 [20:58:27.133] relpersistence = 112 'p' [20:58:27.133] save_userid = 10 [20:58:27.133] save_sec_context = 0 [20:58:27.133] save_nestlevel = 2 [20:58:27.133] address = {classId = 0, objectId = 0, objectSubId = 0} [20:58:27.133] __func__ = "RefreshMatViewByOid" [20:58:27.133] #8 0x000055bc26f73b2e in ExecRefreshMatView (stmt=0x55bc5458b4b0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:58:27.133] matviewOid = [20:58:27.133] lockmode = [20:58:27.133] #9 0x000055bc26f29748 in ExecCreateTableAs (pstate=pstate@entry=0x55bc545266b0, stmt=stmt@entry=0x55bc54416770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe2ed235a0) at ../src/backend/commands/createas.c:351 [20:58:27.133] refresh = [20:58:27.133] query = 0x55bc54416930 [20:58:27.133] into = 0x55bc544164c8 [20:58:27.133] jstate = 0x0 [20:58:27.133] is_matview = true [20:58:27.133] do_refresh = false [20:58:27.133] dest = [20:58:27.133] address = {classId = 1259, objectId = 28145, objectSubId = 0} [20:58:27.133] __func__ = "ExecCreateTableAs" [20:58:27.133] #10 0x000055bc2744550e in ProcessUtilitySlow (pstate=pstate@entry=0x55bc545266b0, pstmt=pstmt@entry=0x55bc54416820, queryString=queryString@entry=0x55bc54415a30 "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=0x55bc54417258, qc=0x7ffe2ed235a0) at ../src/backend/tcop/utility.c:1678 [20:58:27.133] _save_exception_stack = 0x7ffe2ed23460 [20:58:27.133] _save_context_stack = 0x0 [20:58:27.133] _local_sigjmp_buf = {{__jmpbuf = {0, -1497920779909877512, 94267355785072, 0, 94267355781680, 0, -4633458710425128712, -1497808658354949896}, __mask_was_saved = 0, __saved_mask = {__val = {139734641308416, 14917, 94266600425831, 1, 4294982213, 139734641308416, 94266604250172, 139734835998136, 94267355781680, 94266606579749, 94266616562722, 94266616562848, 140729683948196, 94266606774584, 94266616562737, 94266616562848}}}} [20:58:27.133] _do_rethrow = false [20:58:27.133] parsetree = 0x55bc54416770 [20:58:27.133] isTopLevel = true [20:58:27.133] isCompleteQuery = true [20:58:27.133] needCleanup = false [20:58:27.133] commandCollected = false [20:58:27.133] address = {classId = 21948, objectId = 1413572464, objectSubId = 21948} [20:58:27.133] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:58:27.133] __func__ = "ProcessUtilitySlow" [20:58:27.133] #11 0x000055bc27443b1f in standard_ProcessUtility (pstmt=0x55bc54416820, queryString=0x55bc54415a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55bc54417258, qc=0x7ffe2ed235a0) at ../src/backend/tcop/utility.c:1070 [20:58:27.133] parsetree = 0x55bc54416770 [20:58:27.133] isTopLevel = true [20:58:27.133] isAtomicContext = false [20:58:27.133] pstate = 0x55bc545266b0 [20:58:27.133] readonly_flags = [20:58:27.133] __func__ = "standard_ProcessUtility" [20:58:27.133] #12 0x000055bc27443c7a in ProcessUtility (pstmt=pstmt@entry=0x55bc54416820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55bc54417258, qc=0x7ffe2ed235a0) at ../src/backend/tcop/utility.c:523 [20:58:27.133] No locals. [20:58:27.133] #13 0x000055bc2743f4e6 in PortalRunUtility (portal=portal@entry=0x55bc544977a0, pstmt=pstmt@entry=0x55bc54416820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55bc54417258, qc=qc@entry=0x7ffe2ed235a0) at ../src/backend/tcop/pquery.c:1158 [20:58:27.133] No locals. [20:58:27.133] #14 0x000055bc2743fa8b in PortalRunMulti (portal=portal@entry=0x55bc544977a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55bc54417258, altdest=altdest@entry=0x55bc54417258, qc=qc@entry=0x7ffe2ed235a0) at ../src/backend/tcop/pquery.c:1315 [20:58:27.133] pstmt = 0x55bc54416820 [20:58:27.133] stmtlist_item__state = [20:58:27.133] active_snapshot_set = false [20:58:27.133] stmtlist_item = 0x55bc54417220 [20:58:27.133] #15 0x000055bc2744005e in PortalRun (portal=portal@entry=0x55bc544977a0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55bc54417258, altdest=altdest@entry=0x55bc54417258, qc=0x7ffe2ed235a0) at ../src/backend/tcop/pquery.c:791 [20:58:27.133] _save_exception_stack = 0x7ffe2ed23650 [20:58:27.133] _save_context_stack = 0x0 [20:58:27.133] _local_sigjmp_buf = {{__jmpbuf = {0, -1497920780120641288, 94267356313504, 94267355785192, 94267356313504, 94267355785120, -4633458710412545800, -1497808643266858760}, __mask_was_saved = 0, __saved_mask = {__val = {94266603933872, 94267355781424, 112, 4, 94266603938289, 785528111, 4, 94267355785120, 112, 73, 94267356313504, 94267355785192, 94267355785168, 94267355785120, 94266604025492, 1}}}} [20:58:27.133] _do_rethrow = [20:58:27.133] result = [20:58:27.133] nprocessed = [20:58:27.133] saveTopTransactionResourceOwner = 0x55bc54454958 [20:58:27.133] saveTopTransactionContext = 0x55bc544abc10 [20:58:27.133] saveActivePortal = 0x0 [20:58:27.133] saveResourceOwner = 0x55bc54454958 [20:58:27.133] savePortalContext = 0x0 [20:58:27.133] saveMemoryContext = 0x55bc544abc10 [20:58:27.133] __func__ = "PortalRun" [20:58:27.133] #16 0x000055bc27439445 in exec_simple_query (query_string=query_string@entry=0x55bc54415a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [20:58:27.133] cmdtaglen = 24 [20:58:27.133] snapshot_set = [20:58:27.133] per_parsetree_context = 0x0 [20:58:27.133] plantree_list = 0x55bc54417208 [20:58:27.133] parsetree = 0x55bc544167a0 [20:58:27.133] commandTag = [20:58:27.133] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:58:27.133] querytree_list = [20:58:27.133] portal = 0x55bc544977a0 [20:58:27.133] receiver = 0x55bc54417258 [20:58:27.133] format = 0 [20:58:27.133] cmdtagname = [20:58:27.133] parsetree_item__state = [20:58:27.133] dest = DestRemote [20:58:27.133] oldcontext = 0x55bc544abc10 [20:58:27.133] parsetree_list = 0x55bc544167d0 [20:58:27.133] parsetree_item = 0x55bc544167e8 [20:58:27.133] save_log_statement_stats = false [20:58:27.133] was_logged = true [20:58:27.133] use_implicit_block = false [20:58:27.133] msec_str = "\004\000\000\000\000\000\000\000\177>o'\274U\000\00006\322.\376\177\000\000G\000\000\000\000\000\000" [20:58:27.133] __func__ = "exec_simple_query" [20:58:27.133] #17 0x000055bc2743c1c9 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [20:58:27.133] query_string = 0x55bc54415a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:58:27.133] firstchar = [20:58:27.133] input_message = {data = 0x55bc54415a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:58:27.133] local_sigjmp_buf = {{__jmpbuf = {94266616571288, -1497824980580454152, 140729683949484, 4, 4, 140729683949716, -4633458710492237576, -1497808645341204232}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94267355512240, 14336, 94266616565376, 94267356035344, 4, 94266603937837, 0, 9, 2, 94266616571296, 94267355512240, 94266616565376, 4, 4, 140729683949716}}}} [20:58:27.133] send_ready_for_query = false [20:58:27.133] idle_in_transaction_timeout_enabled = false [20:58:27.133] idle_session_timeout_enabled = false [20:58:27.133] __func__ = "PostgresMain" [20:58:27.133] #18 0x000055bc2743203f in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:58:27.133] bsdata = [20:58:27.133] #19 0x000055bc272e3d91 in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x7ffe2ed237ac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe2ed23800) at ../src/backend/postmaster/launch_backend.c:274 [20:58:27.133] pid = [20:58:27.133] #20 0x000055bc272e8d8c in BackendStartup (client_sock=client_sock@entry=0x7ffe2ed23800) at ../src/backend/postmaster/postmaster.c:3377 [20:58:27.133] bn = 0x55bc5443d308 [20:58:27.133] pid = [20:58:27.133] startup_data = {canAcceptConnections = CAC_OK} [20:58:27.133] cac = [20:58:27.133] __func__ = "BackendStartup" [20:58:27.133] #21 0x000055bc272eac65 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [20:58:27.133] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "Q\216\026\177\000\000>\004\000\000\000\000\000\000\260\227Ì\026\177\000\000\240O\023\216\026\177\000\000\2708\322.\376\177\000\000\2648\322.\376\177", '\000' , "\242RI&\274U\000\000X7E&\274U\000\000\2009\322.\376\177\000\000x9\322.\376\177\000\000\225[\362\001Е,\036\240\224C\215\026\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [20:58:27.133] i = 0 [20:58:27.133] now = [20:58:27.133] last_lockfile_recheck_time = 1732395264 [20:58:27.133] last_touch_time = 1732395264 [20:58:27.133] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 785529280, user_data = 0x0}, {pos = 15, events = 0, fd = 642339490, user_data = 0x7f168e53d668}, {pos = -1924950480, events = 32534, fd = -1907109152, user_data = 0x7c96e577}, {pos = 785529344, events = 32766, fd = -1907279288, user_data = 0xf}, {pos = -1924950480, events = 32534, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1907109152, user_data = 0x7ffe2ed23978}, {pos = 785529216, events = 32766, fd = -1907108248, user_data = 0x0}, {pos = 1413576416, events = 21948, fd = -1932595867, user_data = 0x7ffe2ed23e93}, {pos = 1, events = 0, fd = 785529216, user_data = 0xffffffff}, {pos = -1933385696, events = 32534, fd = -1911337056, user_data = 0x55bc54441008}, {pos = 1413746408, events = 21948, fd = 1413743793, user_data = 0x7f168e519ebe}, {pos = 1, events = 0, fd = -1907109152, user_data = 0x1ab}, {pos = 667360600, events = 21948, fd = 0, user_data = 0xd8}, {pos = 1413569096, events = 21948, fd = -1907253570, user_data = 0x1}, {pos = 0, events = 0, fd = -1933385696, user_data = 0x7f168ccf2e40 }, {pos = 16, events = 0, fd = 785530304, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f168e51c1ba}, {pos = 0, events = 0, fd = -1932857948, user_data = 0x0}, {pos = 674294080, events = 21948, fd = 2, user_data = 0x0}, {pos = 1413316176, events = 21948, fd = 1952410737, user_data = 0x161}, {pos = 667360008, events = 21948, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 1413569096, events = 21948, fd = -1907253570, user_data = 0x1}, {pos = -1932824825, events = 32534, fd = -1933351736, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1931535264, events = 32534, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55bc543d7e50}, {pos = -1932821878, events = 32534, 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 = 32512, 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 = -1931552288, events = 32534, fd = -1932914322, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x1e2c95d0f5dbbf00}, {pos = -1931549216, events = 32534, fd = -328, user_data = 0x0}, {pos = 1413746088, events = 21948, fd = 1024, user_data = 0x55bc54440da8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 25963, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1413569096, user_data = 0x7f168ccf3053 }, {pos = 1413746088, events = 21948, fd = 1024, user_data = 0x7ffe2ed23e88}, {pos = 661804580, events = 21948, fd = 674358608, user_data = 0x55bc277140e1 }, {pos = 1413745888, events = 21948, fd = 1413568816, user_data = 0x55bc54440ce0}, {pos = -1932830869, events = 32534, fd = 0, user_data = 0x55bc27725d4b }, {pos = 1413745888, events = 1, fd = 661806740, user_data = 0x55bc54415930}, {pos = -170148096, events = 506238416, fd = 0, user_data = 0x7f168cca2ab1}, {pos = -1932913424, events = 32534, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1413316176, user_data = 0x1e2c95d0f5dbbf00}, {pos = 0, events = 0, fd = -170148096, user_data = 0xc}, {pos = -170148096, events = 506238416, fd = 0, user_data = 0x7f168cc5b239 }, {pos = 217, events = 0, fd = 657341070, user_data = 0x400000}, {pos = 0, events = 0, fd = 1413316176, user_data = 0x55bc27713f75 }, {pos = 1413402720, events = 21948, fd = 1413568816, user_data = 0x55bc543ed060}, {pos = 1, events = 0, fd = 0, user_data = 0x55bc276d2972 }, {pos = 12, events = 0, fd = 1413741336, user_data = 0x55bc5443faf8}, {pos = 674295488, events = 21948, fd = 296, user_data = 0x55bc272e62a8 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 657357541, events = 21948, fd = 670727088, user_data = 0x55bc544162d8}} [20:58:27.134] nevents = 1 [20:58:27.134] __func__ = "ServerLoop" [20:58:27.134] #22 0x000055bc272ec4f6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55bc543d3cc0) at ../src/backend/postmaster/postmaster.c:1361 [20:58:27.134] opt = [20:58:27.134] status = [20:58:27.134] userDoption = [20:58:27.134] listen_addr_saved = false [20:58:27.134] output_config_variable = [20:58:27.134] __func__ = "PostmasterMain" [20:58:27.134] #23 0x000055bc271271bb in main (argc=4, argv=0x55bc543d3cc0) at ../src/backend/main/main.c:196 [20:58:27.134] do_check_root = [20:58:27.172] -e [20:58:27.172] [20:58:27.172] [20:58:27.238] dumping /tmp/cores/postgres-6-28900.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:58:27.488] [New LWP 28900] [20:58:27.488] [20:58:27.488] This GDB supports auto-downloading debuginfo from the following URLs: [20:58:27.488] [20:58:27.488] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:58:27.488] Debuginfod has been disabled. [20:58:27.488] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:58:27.590] [Thread debugging using libthread_db enabled] [20:58:27.590] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:58:27.590] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [20:58:27.590] Program terminated with signal SIGABRT, Aborted. [20:58:27.590] #0 0x00007f7530aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:28.529] [20:58:28.529] Thread 1 (Thread 0x7f7531232f00 (LWP 28900)): [20:58:28.529] #0 0x00007f7530aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:28.529] No symbol table info available. [20:58:28.529] #1 0x00007f7530a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:28.529] No symbol table info available. [20:58:28.529] #2 0x00007f7530a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [20:58:28.529] No symbol table info available. [20:58:28.529] #3 0x0000560f9411e008 in ExceptionalCondition (conditionName=conditionName@entry=0x560f94393475 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x560f94392990 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [20:58:28.529] No locals. [20:58:28.529] #4 0x0000560f93a9d133 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x560fcae2fbd0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [20:58:28.529] estate = 0x560fcad3d0d0 [20:58:28.529] oldcontext = 0x560fcad6e900 [20:58:28.529] __func__ = "standard_ExecutorStart" [20:58:28.529] #5 0x0000560f93a9d30f in ExecutorStart (queryDesc=queryDesc@entry=0x560fcae2fbd0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [20:58:28.529] No locals. [20:58:28.529] #6 0x0000560f939c1688 in refresh_matview_datafill (dest=0x560fcad29ba8, query=, query@entry=0x560fcad3a4b0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [20:58:28.529] rewritten = [20:58:28.529] plan = 0x560fcae2eff8 [20:58:28.529] queryDesc = 0x560fcae2fbd0 [20:58:28.529] copied_query = [20:58:28.529] processed = [20:58:28.529] __func__ = "refresh_matview_datafill" [20:58:28.529] #7 0x0000560f939c39ef in RefreshMatViewByOid (matviewOid=28538, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [20:58:28.529] dest = [20:58:28.529] matviewRel = 0x7f7525019e88 [20:58:28.529] rule = [20:58:28.529] actions = [20:58:28.529] dataQuery = 0x560fcad3a4b0 [20:58:28.529] tableSpace = [20:58:28.529] relowner = 10 [20:58:28.529] OIDNewHeap = 28550 [20:58:28.529] processed = 0 [20:58:28.529] relpersistence = 112 'p' [20:58:28.529] save_userid = 10 [20:58:28.529] save_sec_context = 0 [20:58:28.529] save_nestlevel = 2 [20:58:28.529] address = {classId = 0, objectId = 0, objectSubId = 0} [20:58:28.529] __func__ = "RefreshMatViewByOid" [20:58:28.529] #8 0x0000560f939c3b2e in ExecRefreshMatView (stmt=0x560fcad43920, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:58:28.529] matviewOid = [20:58:28.529] lockmode = [20:58:28.529] #9 0x0000560f93979748 in ExecCreateTableAs (pstate=pstate@entry=0x560fcad6ea00, stmt=stmt@entry=0x560fcac0f7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffce5d58530) at ../src/backend/commands/createas.c:351 [20:58:28.529] refresh = [20:58:28.529] query = 0x560fcac0f9b0 [20:58:28.529] into = 0x560fcac0f548 [20:58:28.529] jstate = 0x0 [20:58:28.529] is_matview = true [20:58:28.529] do_refresh = false [20:58:28.529] dest = [20:58:28.529] address = {classId = 1259, objectId = 28538, objectSubId = 0} [20:58:28.529] __func__ = "ExecCreateTableAs" [20:58:28.529] #10 0x0000560f93e9550e in ProcessUtilitySlow (pstate=pstate@entry=0x560fcad6ea00, pstmt=pstmt@entry=0x560fcac0f8a0, queryString=queryString@entry=0x560fcac0eab0 "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=0x560fcac102d8, qc=0x7ffce5d58530) at ../src/backend/tcop/utility.c:1678 [20:58:28.529] _save_exception_stack = 0x7ffce5d583f0 [20:58:28.529] _save_context_stack = 0x0 [20:58:28.529] _local_sigjmp_buf = {{__jmpbuf = {0, 8394333480414645632, 94625826142192, 0, 94625826138800, 0, 2853303009608764800, 8394176995285306752}, __mask_was_saved = 0, __saved_mask = {__val = {140141116971584, 10718, 94624905464167, 1, 4294978014, 140141116971584, 94624905454485, 1, 46036862360200, 1, 10718, 140141116971584, 140141116971584, 1, 94624905464514, 94625827379848}}}} [20:58:28.529] _do_rethrow = false [20:58:28.529] parsetree = 0x560fcac0f7f0 [20:58:28.529] isTopLevel = true [20:58:28.529] isCompleteQuery = true [20:58:28.529] needCleanup = false [20:58:28.529] commandCollected = false [20:58:28.529] address = {classId = 22031, objectId = 3401644016, objectSubId = 22031} [20:58:28.529] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:58:28.529] __func__ = "ProcessUtilitySlow" [20:58:28.529] #11 0x0000560f93e93b1f in standard_ProcessUtility (pstmt=0x560fcac0f8a0, queryString=0x560fcac0eab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x560fcac102d8, qc=0x7ffce5d58530) at ../src/backend/tcop/utility.c:1070 [20:58:28.529] parsetree = 0x560fcac0f7f0 [20:58:28.529] isTopLevel = true [20:58:28.529] isAtomicContext = false [20:58:28.529] pstate = 0x560fcad6ea00 [20:58:28.529] readonly_flags = [20:58:28.529] __func__ = "standard_ProcessUtility" [20:58:28.529] #12 0x0000560f93e93c7a in ProcessUtility (pstmt=pstmt@entry=0x560fcac0f8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x560fcac102d8, qc=0x7ffce5d58530) at ../src/backend/tcop/utility.c:523 [20:58:28.529] No locals. [20:58:28.529] #13 0x0000560f93e8f4e6 in PortalRunUtility (portal=portal@entry=0x560fcac930c0, pstmt=pstmt@entry=0x560fcac0f8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560fcac102d8, qc=qc@entry=0x7ffce5d58530) at ../src/backend/tcop/pquery.c:1158 [20:58:28.529] No locals. [20:58:28.529] #14 0x0000560f93e8fa8b in PortalRunMulti (portal=portal@entry=0x560fcac930c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560fcac102d8, altdest=altdest@entry=0x560fcac102d8, qc=qc@entry=0x7ffce5d58530) at ../src/backend/tcop/pquery.c:1315 [20:58:28.529] pstmt = 0x560fcac0f8a0 [20:58:28.529] stmtlist_item__state = [20:58:28.529] active_snapshot_set = false [20:58:28.529] stmtlist_item = 0x560fcac102a0 [20:58:28.529] #15 0x0000560f93e9005e in PortalRun (portal=portal@entry=0x560fcac930c0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x560fcac102d8, altdest=altdest@entry=0x560fcac102d8, qc=0x7ffce5d58530) at ../src/backend/tcop/pquery.c:791 [20:58:28.529] _save_exception_stack = 0x7ffce5d585e0 [20:58:28.529] _save_context_stack = 0x0 [20:58:28.529] _local_sigjmp_buf = {{__jmpbuf = {0, 8394333469483240832, 94625826681024, 94625826142312, 94625826681024, 94625826142240, 2853303015912803712, 8394177006061915520}, __mask_was_saved = 0, __saved_mask = {__val = {94624908972208, 94625826138544, 112, 4, 94624908976625, 3855975615, 4, 94625826142240, 112, 73, 94625826681024, 94625826142312, 94625826142288, 94625826142240, 94624909063828, 1}}}} [20:58:28.529] _do_rethrow = [20:58:28.529] result = [20:58:28.529] nprocessed = [20:58:28.529] saveTopTransactionResourceOwner = 0x560fcac4fd78 [20:58:28.529] saveTopTransactionContext = 0x560fcaca54f0 [20:58:28.529] saveActivePortal = 0x0 [20:58:28.529] saveResourceOwner = 0x560fcac4fd78 [20:58:28.529] savePortalContext = 0x0 [20:58:28.529] saveMemoryContext = 0x560fcaca54f0 [20:58:28.529] __func__ = "PortalRun" [20:58:28.529] #16 0x0000560f93e89445 in exec_simple_query (query_string=query_string@entry=0x560fcac0eab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [20:58:28.529] cmdtaglen = 24 [20:58:28.529] snapshot_set = [20:58:28.529] per_parsetree_context = 0x0 [20:58:28.529] plantree_list = 0x560fcac10288 [20:58:28.529] parsetree = 0x560fcac0f820 [20:58:28.529] commandTag = [20:58:28.529] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:58:28.529] querytree_list = [20:58:28.529] portal = 0x560fcac930c0 [20:58:28.529] receiver = 0x560fcac102d8 [20:58:28.529] format = 0 [20:58:28.529] cmdtagname = [20:58:28.529] parsetree_item__state = [20:58:28.529] dest = DestRemote [20:58:28.529] oldcontext = 0x560fcaca54f0 [20:58:28.529] parsetree_list = 0x560fcac0f850 [20:58:28.529] parsetree_item = 0x560fcac0f868 [20:58:28.529] save_log_statement_stats = false [20:58:28.529] was_logged = false [20:58:28.529] use_implicit_block = false [20:58:28.529] msec_str = "\004\000\000\000\000\000\000\000\177>\024\224\017V\000\000\300\205\325\345\374\177\000\000G\000\000\000\000\000\000" [20:58:28.529] __func__ = "exec_simple_query" [20:58:28.529] #17 0x0000560f93e8c1c9 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [20:58:28.529] query_string = 0x560fcac0eab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:58:28.529] firstchar = [20:58:28.529] input_message = {data = 0x560fcac0eab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:58:28.529] local_sigjmp_buf = {{__jmpbuf = {94624921609624, 8394170942309830016, 140724164462396, 4, 4, 140724164462628, 2853303015715671424, 8394177008282537344}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94625825869264, 15616, 94624921603712, 94625826401584, 4, 94624908976173, 0, 9, 2, 94624921609632, 94625825869264, 94624921603712, 4, 4, 140724164462628}}}} [20:58:28.529] send_ready_for_query = false [20:58:28.529] idle_in_transaction_timeout_enabled = false [20:58:28.529] idle_session_timeout_enabled = false [20:58:28.529] __func__ = "PostgresMain" [20:58:28.529] #18 0x0000560f93e8203f in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:58:28.529] bsdata = [20:58:28.529] #19 0x0000560f93d33d91 in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x7ffce5d5873c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffce5d58790) at ../src/backend/postmaster/launch_backend.c:274 [20:58:28.529] pid = [20:58:28.529] #20 0x0000560f93d38d8c in BackendStartup (client_sock=client_sock@entry=0x7ffce5d58790) at ../src/backend/postmaster/postmaster.c:3377 [20:58:28.529] bn = 0x560fcac370b8 [20:58:28.529] pid = [20:58:28.529] startup_data = {canAcceptConnections = CAC_OK} [20:58:28.529] cac = [20:58:28.529] __func__ = "BackendStartup" [20:58:28.529] #21 0x0000560f93d3ac65 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [20:58:28.529] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\2430u\177\000\000\240\317\3621u\177\000\0008\210\325\345\374\177\000\0004\210\325\345\374\177", '\000' , "\242R\356\222\017V\000\000X7\352\222\017V\000\000\000\211\325\345\374\177\000\000\370\210\325\345\374\177\000\000\225[\362\001\000\000\000\000\240\224\2101u\177\000\000+", '\000' , "\017V\000\000\260Q\356\222\017V\000", __ss_align = 140141329970792}, salen = 2}} [20:58:28.529] i = 0 [20:58:28.529] now = [20:58:28.529] last_lockfile_recheck_time = 1732395261 [20:58:28.529] last_touch_time = 1732395261 [20:58:28.529] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x560f92ee52a2}, {pos = 842069608, events = 32629, fd = 831034928, user_data = 0x7f753230f2e0}, {pos = 2090263927, events = 0, fd = -438990464, user_data = 0x7f75322e5a48}, {pos = 15, events = 0, fd = 831034928, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f753230f2e0}, {pos = -438990600, events = 32764, fd = -438990592, user_data = 0x7f753230f668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = -893319264, events = 22031, fd = 1, user_data = 0x7ffce5d58e23}, {pos = -1, events = 0, fd = 815980576, user_data = 0x7f7531f2cfa0}, {pos = -893148840, events = 22031, fd = -893149128, user_data = 0x560fcac3c421}, {pos = 841924286, events = 32629, fd = 1, user_data = 0x7f753230f2e0}, {pos = 427, events = 0, fd = -1804853928, user_data = 0x0}, {pos = 236, events = 0, fd = -893326480, user_data = 0x7f75322ebebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f7530a2e020}, {pos = 816787008, events = 32629, fd = 16, user_data = 0x7ffce5d58d50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 841933242, events = 32629, fd = 0, user_data = 0x7f7530aaeda4 }, {pos = 0, events = 0, fd = -1797920448, user_data = 0x2}, {pos = 0, events = 0, fd = -893579664, user_data = 0x560f93e1fbc2 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = -893326480, user_data = 0x7f75322ebebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f7530a364c8}, {pos = 816541447, events = 32629, fd = -1797864288, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 817831008, events = 32629, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x342020200a0a5272}, {pos = 822763892, events = 858927927, fd = 909260089, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {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 = -893133744, user_data = 0x7f7530ab576b}, {pos = 817813984, events = 32629, fd = 816451950, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xab9dd6161ec7c00}, {pos = 817817056, events = 32629, fd = -328, user_data = 0x0}, {pos = -893149448, events = 22031, 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 = 25222, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -893326480, user_data = 0x7f7530af3053 }, {pos = -893149448, events = 22031, fd = 1024, user_data = 0x7ffce5d58e18}, {pos = -1810409948, events = 22031, fd = -1797855920, user_data = 0x560f941640e1 }, {pos = -893149648, events = 22031, fd = -893326928, user_data = 0x560fcac39e30}, {pos = 816535403, events = 32629, fd = 0, user_data = 0x560f94175d4b }, {pos = -893149648, events = 1, fd = -1810407788, user_data = 0x560fcac0e9b0}, {pos = 1642888192, events = 179952993, fd = 0, user_data = 0x7f7530aa2ab1}, {pos = 816452848, events = 32629, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -893579664, user_data = 0xab9dd6161ec7c00}, {pos = 0, events = 0, fd = 1642888192, user_data = 0xc}, {pos = 1642888192, events = 179952993, fd = 0, user_data = 0x7f7530a5b239 }, {pos = 237, events = 0, fd = -1814873458, user_data = 0x400000}, {pos = 0, events = 0, fd = -893579664, user_data = 0x560f94163f75 }, {pos = -893493024, events = 22031, fd = -893326928, user_data = 0x560fcabe60e0}, {pos = 1, events = 0, fd = 0, user_data = 0x560f94122972 }, {pos = 12, events = 0, fd = -893150072, user_data = 0x560fcac39c68}, {pos = -1797919040, events = 22031, fd = 296, user_data = 0x560f93d362a8 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1814856987, events = 22031, fd = -1801487440, user_data = 0x560fcac0f388}} [20:58:28.530] nevents = 1 [20:58:28.530] __func__ = "ServerLoop" [20:58:28.530] #22 0x0000560f93d3c4f6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x560fcabccd30) at ../src/backend/postmaster/postmaster.c:1361 [20:58:28.530] opt = [20:58:28.530] status = [20:58:28.530] userDoption = [20:58:28.530] listen_addr_saved = false [20:58:28.530] output_config_variable = [20:58:28.530] __func__ = "PostmasterMain" [20:58:28.530] #23 0x0000560f93b771bb in main (argc=8, argv=0x560fcabccd30) at ../src/backend/main/main.c:196 [20:58:28.530] do_check_root =