[10:07:24.346] src/tools/ci/cores_backtrace.sh linux /tmp/cores [10:07:24.562] dumping /tmp/cores/postgres-6-36865.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:07:24.828] [New LWP 36865] [10:07:24.828] [10:07:24.828] This GDB supports auto-downloading debuginfo from the following URLs: [10:07:24.828] [10:07:24.828] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [10:07:24.828] Debuginfod has been disabled. [10:07:24.828] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [10:07:24.966] [Thread debugging using libthread_db enabled] [10:07:24.966] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [10:07:24.966] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [10:07:24.966] Program terminated with signal SIGABRT, Aborted. [10:07:24.966] #0 0x00007efe662a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:25.856] [10:07:25.856] Thread 1 (Thread 0x7efe66a36f00 (LWP 36865)): [10:07:25.856] #0 0x00007efe662a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:25.856] No symbol table info available. [10:07:25.856] #1 0x00007efe6625afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:25.856] No symbol table info available. [10:07:25.856] #2 0x00007efe66245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:25.856] No symbol table info available. [10:07:25.856] #3 0x000055c6fb397248 in ExceptionalCondition (conditionName=conditionName@entry=0x55c6fb60c395 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55c6fb60b8b0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [10:07:25.856] No locals. [10:07:25.856] #4 0x000055c6fad18a2d in standard_ExecutorStart (queryDesc=0x55c732c9da50, eflags=0) at ../src/backend/executor/execMain.c:195 [10:07:25.856] estate = 0x55c732babd60 [10:07:25.856] oldcontext = 0x55c732ba90b0 [10:07:25.856] __func__ = "standard_ExecutorStart" [10:07:25.856] #5 0x00007efe640276f7 in pgss_ExecutorStart (queryDesc=0x55c732c9da50, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [10:07:25.856] No locals. [10:07:25.856] #6 0x000055c6fad18bc2 in ExecutorStart (queryDesc=queryDesc@entry=0x55c732c9da50, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [10:07:25.856] No locals. [10:07:25.856] #7 0x000055c6fac3d424 in refresh_matview_datafill (dest=0x55c732c9aac8, query=, query@entry=0x55c732b98690, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [10:07:25.856] rewritten = [10:07:25.856] plan = 0x55c732c9cf88 [10:07:25.856] queryDesc = 0x55c732c9da50 [10:07:25.856] copied_query = [10:07:25.856] processed = [10:07:25.856] __func__ = "refresh_matview_datafill" [10:07:25.856] #8 0x000055c6fac3f78b in RefreshMatViewByOid (matviewOid=28346, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [10:07:25.856] dest = [10:07:25.856] matviewRel = 0x7efe61b7a878 [10:07:25.856] rule = [10:07:25.856] actions = [10:07:25.856] dataQuery = 0x55c732b98690 [10:07:25.856] tableSpace = [10:07:25.856] relowner = 10 [10:07:25.856] OIDNewHeap = 28367 [10:07:25.856] processed = 0 [10:07:25.856] relpersistence = 112 'p' [10:07:25.856] save_userid = 10 [10:07:25.856] save_sec_context = 0 [10:07:25.856] save_nestlevel = 2 [10:07:25.856] address = {classId = 0, objectId = 0, objectSubId = 0} [10:07:25.856] __func__ = "RefreshMatViewByOid" [10:07:25.856] #9 0x000055c6fac3f8ca in ExecRefreshMatView (stmt=0x55c732c0f7d0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [10:07:25.856] matviewOid = [10:07:25.856] lockmode = [10:07:25.856] #10 0x000055c6fabf54f9 in ExecCreateTableAs (pstate=pstate@entry=0x55c732ba91b0, stmt=stmt@entry=0x55c732a7f790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd06537be0) at ../src/backend/commands/createas.c:351 [10:07:25.856] refresh = [10:07:25.856] query = 0x55c732a7f950 [10:07:25.856] into = 0x55c732a7f4e8 [10:07:25.856] jstate = 0x0 [10:07:25.856] is_matview = true [10:07:25.856] do_refresh = false [10:07:25.856] dest = [10:07:25.856] address = {classId = 1259, objectId = 28346, objectSubId = 0} [10:07:25.856] __func__ = "ExecCreateTableAs" [10:07:25.856] #11 0x000055c6fb10f39c in ProcessUtilitySlow (pstate=pstate@entry=0x55c732ba91b0, pstmt=pstmt@entry=0x55c732a7f840, queryString=queryString@entry=0x55c732a7ea50 "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=0x55c732a807e8, qc=0x7ffd06537be0) at ../src/backend/tcop/utility.c:1678 [10:07:25.856] _save_exception_stack = 0x7ffd06537790 [10:07:25.856] _save_context_stack = 0x0 [10:07:25.856] _local_sigjmp_buf = {{__jmpbuf = {0, 1949808851178095452, 94314036721552, 0, 94314036718160, 0, 5727300237855425372, 1949090791749190492}, __mask_was_saved = 0, __saved_mask = {__val = {17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 94313103501295, 0, 5412384741217271808, 94313109579136, 94313103754132, 139631028928448, 1, 16777216, 0, 112, 94313103501567, 139631029026816}}}} [10:07:25.856] _do_rethrow = false [10:07:25.856] parsetree = 0x55c732a7f790 [10:07:25.856] isTopLevel = true [10:07:25.856] isCompleteQuery = true [10:07:25.856] needCleanup = false [10:07:25.856] commandCollected = false [10:07:25.856] address = {classId = 21959, objectId = 849868688, objectSubId = 21959} [10:07:25.856] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [10:07:25.856] __func__ = "ProcessUtilitySlow" [10:07:25.856] #12 0x000055c6fb10d9ad in standard_ProcessUtility (pstmt=pstmt@entry=0x55c732a7f840, queryString=queryString@entry=0x55c732a7ea50 "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=0x55c732a807e8, qc=0x7ffd06537be0) at ../src/backend/tcop/utility.c:1070 [10:07:25.856] parsetree = 0x55c732a7f790 [10:07:25.856] isTopLevel = true [10:07:25.856] isAtomicContext = false [10:07:25.856] pstate = 0x55c732ba91b0 [10:07:25.856] readonly_flags = [10:07:25.856] __func__ = "standard_ProcessUtility" [10:07:25.856] #13 0x00007efe6402ad9d in pgss_ProcessUtility (pstmt=0x55c732a7f840, queryString=0x55c732a7ea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55c732a807e8, qc=0x7ffd06537be0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [10:07:25.856] _save_exception_stack = 0x7ffd06537aa0 [10:07:25.856] _save_context_stack = 0x0 [10:07:25.856] _local_sigjmp_buf = {{__jmpbuf = {0, -5728163530941529252, 94314036721728, 94314036725736, 140724709587936, 0, 5727300237884785500, 5583814394316456796}, __mask_was_saved = 0, __saved_mask = {__val = {94313107329013, 140724709587206, 140724709587204, 0, 0, 139637976727552, 206158430232, 140724709587168, 94313107329230, 0, 206158430232, 94314036722528, 140724709587264, 0, 94313102141028, 94314036717904}}}} [10:07:25.856] _do_rethrow = false [10:07:25.856] duration = [10:07:25.856] bufusage = {shared_blks_hit = 94314037952920, shared_blks_read = 850403524608, shared_blks_dirtied = 0, shared_blks_written = 94314037952424, local_blks_hit = 94314037952920, local_blks_read = 94313100470970, local_blks_dirtied = 94314038927736, local_blks_written = 94313100471216, temp_blks_read = 94314037952424, temp_blks_written = 94314037951840, shared_blk_read_time = {ticks = 94313100470325}, shared_blk_write_time = {ticks = 94313107322465}, local_blk_read_time = {ticks = 139631108779448}, local_blk_write_time = {ticks = 94314036718160}, temp_blk_read_time = {ticks = 94313109647397}, temp_blk_write_time = {ticks = 94313119627586}} [10:07:25.856] walusage_start = {wal_records = 8982, wal_fpi = 100, wal_bytes = 1097504} [10:07:25.856] start = [10:07:25.856] rows = [10:07:25.856] bufusage_start = {shared_blks_hit = 34392, shared_blks_read = 3754, shared_blks_dirtied = 1576, shared_blks_written = 1074, 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}} [10:07:25.856] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 139631028928448} [10:07:25.856] parsetree = [10:07:25.856] saved_queryId = 6041762721901209185 [10:07:25.856] saved_stmt_location = 0 [10:07:25.856] saved_stmt_len = 69 [10:07:25.856] enabled = true [10:07:25.856] #14 0x000055c6fb10da53 in ProcessUtility (pstmt=pstmt@entry=0x55c732a7f840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55c732a807e8, qc=0x7ffd06537be0) at ../src/backend/tcop/utility.c:519 [10:07:25.856] No locals. [10:07:25.856] #15 0x000055c6fb109374 in PortalRunUtility (portal=portal@entry=0x55c732afff90, pstmt=pstmt@entry=0x55c732a7f840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55c732a807e8, qc=qc@entry=0x7ffd06537be0) at ../src/backend/tcop/pquery.c:1158 [10:07:25.856] No locals. [10:07:25.856] #16 0x000055c6fb109919 in PortalRunMulti (portal=portal@entry=0x55c732afff90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55c732a807e8, altdest=altdest@entry=0x55c732a807e8, qc=qc@entry=0x7ffd06537be0) at ../src/backend/tcop/pquery.c:1315 [10:07:25.856] pstmt = 0x55c732a7f840 [10:07:25.856] stmtlist_item__state = [10:07:25.856] active_snapshot_set = false [10:07:25.856] stmtlist_item = 0x55c732a807b0 [10:07:25.856] #17 0x000055c6fb109eec in PortalRun (portal=portal@entry=0x55c732afff90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55c732a807e8, altdest=altdest@entry=0x55c732a807e8, qc=0x7ffd06537be0) at ../src/backend/tcop/pquery.c:791 [10:07:25.856] _save_exception_stack = 0x7ffd06537c90 [10:07:25.856] _save_context_stack = 0x0 [10:07:25.856] _local_sigjmp_buf = {{__jmpbuf = {0, 1949808835521807196, 94314037247888, 94314036721672, 94314037247888, 94314036721600, 5727300238109180764, 1949090789763318620}, __mask_was_saved = 0, __saved_mask = {__val = {94313107006165, 94314036717904, 112, 4, 94313107010582, 106134383, 4, 94314036721600, 112, 73, 94314037247888, 94314036721672, 94314036721648, 94314036721600, 94313107097785, 1}}}} [10:07:25.856] _do_rethrow = [10:07:25.856] result = [10:07:25.856] nprocessed = [10:07:25.856] saveTopTransactionResourceOwner = 0x55c732abf468 [10:07:25.856] saveTopTransactionContext = 0x55c732b123c0 [10:07:25.856] saveActivePortal = 0x0 [10:07:25.856] saveResourceOwner = 0x55c732abf468 [10:07:25.856] savePortalContext = 0x0 [10:07:25.856] saveMemoryContext = 0x55c732b123c0 [10:07:25.856] __func__ = "PortalRun" [10:07:25.856] #18 0x000055c6fb1032d8 in exec_simple_query (query_string=query_string@entry=0x55c732a7ea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [10:07:25.856] cmdtaglen = 24 [10:07:25.856] snapshot_set = [10:07:25.856] per_parsetree_context = 0x0 [10:07:25.856] plantree_list = 0x55c732a80798 [10:07:25.856] parsetree = 0x55c732a7f7c0 [10:07:25.856] commandTag = [10:07:25.856] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:07:25.856] querytree_list = [10:07:25.856] portal = 0x55c732afff90 [10:07:25.856] receiver = 0x55c732a807e8 [10:07:25.856] format = 0 [10:07:25.856] cmdtagname = [10:07:25.856] parsetree_item__state = [10:07:25.856] dest = DestRemote [10:07:25.856] oldcontext = 0x55c732b123c0 [10:07:25.856] parsetree_list = 0x55c732a7f7f0 [10:07:25.856] parsetree_item = 0x55c732a7f808 [10:07:25.856] save_log_statement_stats = false [10:07:25.856] was_logged = true [10:07:25.856] use_implicit_block = false [10:07:25.856] msec_str = "@~S\006\375\177\000\000\267\320;\373\306U\000\000p|S\006\375\177\000\000G\000\000\000\000\000\000" [10:07:25.856] __func__ = "exec_simple_query" [10:07:25.856] #19 0x000055c6fb10605c in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [10:07:25.856] query_string = 0x55c732a7ea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [10:07:25.856] firstchar = [10:07:25.856] input_message = {data = 0x55c732a7ea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [10:07:25.856] local_sigjmp_buf = {{__jmpbuf = {94313119636152, 1949089292842304348, 4, 140724709588544, 140724709588688, 140724709588692, 5727300238172095324, 1949090787407823708}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94314036967744, 0, 168, 94313107010684, 0, 10, 2, 94313119636160, 94314036448752, 94313119630240, 140724709588544, 140724709588688, 140724709588692}}}} [10:07:25.856] send_ready_for_query = false [10:07:25.856] idle_in_transaction_timeout_enabled = false [10:07:25.856] idle_session_timeout_enabled = false [10:07:25.856] __func__ = "PostgresMain" [10:07:25.856] #20 0x000055c6fb0fbed2 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:07:25.856] bsdata = [10:07:25.856] #21 0x000055c6fafaf644 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd06537dec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd06537e40) at ../src/backend/postmaster/launch_backend.c:266 [10:07:25.856] pid = [10:07:25.856] #22 0x000055c6fafb50f8 in BackendStartup (client_sock=client_sock@entry=0x7ffd06537e40) at ../src/backend/postmaster/postmaster.c:3417 [10:07:25.856] bn = 0x55c732aab428 [10:07:25.856] pid = [10:07:25.856] startup_data = {canAcceptConnections = CAC_OK} [10:07:25.856] __func__ = "BackendStartup" [10:07:25.856] #23 0x000055c6fafb565a in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [10:07:25.856] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\251g\376~\000\000>\004\000\000\000\000\000\000\260\227#f\376~\000\000\240\177sg\376~\000\000\370~S\006\375\177\000\000\364~S\006\375\177", '\000' , "\372\021\026\372\306U\000\000@\367\021\372\306U\000\000\300\177S\006\375\177\000\000\270\177S\006\375\177\000\000\225[\362\001\220\205\323Kp\212\2522\307U\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [10:07:25.856] i = 0 [10:07:25.856] now = [10:07:25.856] last_lockfile_recheck_time = 1731405839 [10:07:25.856] last_touch_time = 1731405839 [10:07:25.856] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 106135552, user_data = 0x0}, {pos = 15, events = 0, fd = -99216902, user_data = 0x7efe67abb668}, {pos = 1722046000, events = 32510, fd = 1739305696, user_data = 0x7c96e577}, {pos = 106135616, events = 32765, fd = 1739135560, user_data = 0xf}, {pos = 1722046000, events = 32510, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1739305696, user_data = 0x7ffd06537fb8}, {pos = 106135488, events = 32765, fd = 1739306600, user_data = 0x0}, {pos = 849868144, events = 21959, fd = 1714351461, user_data = 0x7ffd065384d3}, {pos = 1, events = 0, fd = 106135488, user_data = 0xffffffff}, {pos = 1713561632, events = 32510, fd = 1735622560, user_data = 0x55c732aaa308}, {pos = 850043368, events = 21959, fd = 850061457, user_data = 0x7efe67a97ebe}, {pos = 1, events = 0, fd = 1739305696, user_data = 0x1ab}, {pos = -74207912, events = 21958, fd = 0, user_data = 0x1}, {pos = 849873040, events = 21959, fd = 1739161278, user_data = 0x1}, {pos = 0, events = 0, fd = 1713561632, user_data = 0x7efe662f2e40 }, {pos = 16, events = 0, fd = 106136592, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7efe67a9a1ba}, {pos = 0, events = 0, fd = 1714089380, user_data = 0x0}, {pos = -67279840, events = 21958, fd = 2, user_data = 0x7}, {pos = 849612432, events = 21959, fd = 1952410737, user_data = 0x161}, {pos = -74208504, events = 21958, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 849873040, events = 21959, fd = 1739161278, user_data = 0x1}, {pos = 1714122861, events = 32510, fd = 1713595592, user_data = 0x55c732ab3900}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1715412064, events = 32510, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55c732a40e90}, {pos = 1714125450, events = 32510, fd = 0, user_data = 0x0}, {pos = -65536, events = 4294967295, fd = -1, 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 = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7efe67087540}, {pos = 1728608896, events = 32510, 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 = 1715395040, events = 32510, fd = 1714033006, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x4bd3859055fd2800}, {pos = 1715398112, events = 32510, fd = -328, user_data = 0x0}, {pos = 850043048, events = 21959, fd = 1024, user_data = 0x55c732aaa0a8}, {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 = 32938, events = 0, fd = -328, user_data = 0x0}, {pos = 849873040, events = 21959, fd = 1714368595, user_data = 0x7ffd065384c8}, {pos = -79763383, events = 21958, fd = -67216784, user_data = 0x55c6fb3dd306 }, {pos = 850042848, events = 21959, fd = 849865040, user_data = 0x55c732aa9fe0}, {pos = 1714116798, events = 32510, fd = 0, user_data = 0x55c6fb3eef70 }, {pos = 850042848, events = 1, fd = -79761223, user_data = 0x55c732a7e950}, {pos = 1442654208, events = 1272153488, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1714039473, user_data = 0x7efe662a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1442654208, user_data = 0x55c732a56080}, {pos = 1442654208, events = 1272153488, fd = 11, user_data = 0x4bd3859055fd2800}, {pos = 0, events = 0, fd = 1713746489, user_data = 0x1}, {pos = -84217023, events = 21958, fd = 4194304, user_data = 0x55c6fb3dd19a }, {pos = 849698944, events = 21959, fd = 849865040, user_data = 0x55c732a56080}, {pos = 1, events = 0, fd = 0, user_data = 0x55c6fb3eef70 }, {pos = 849698944, events = 21959, fd = -79761223, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55c6fade272d }, {pos = 0, events = 0, fd = -86082963, user_data = 0xb}, {pos = -84195866, events = 21958, fd = -70840272, user_data = 0x55c732a7f308}} [10:07:25.856] nevents = 1 [10:07:25.856] __func__ = "ServerLoop" [10:07:25.856] #24 0x000055c6fafb6ddd in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55c732a3ccf0) at ../src/backend/postmaster/postmaster.c:1348 [10:07:25.856] opt = [10:07:25.856] status = [10:07:25.856] userDoption = [10:07:25.856] listen_addr_saved = false [10:07:25.856] output_config_variable = [10:07:25.856] __func__ = "PostmasterMain" [10:07:25.856] #25 0x000055c6fadf2ab5 in main (argc=4, argv=0x55c732a3ccf0) at ../src/backend/main/main.c:196 [10:07:25.856] do_check_root = [10:07:25.893] -e [10:07:25.893] [10:07:25.893] [10:07:25.958] dumping /tmp/cores/postgres-6-30410.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:07:26.211] [New LWP 30410] [10:07:26.211] [10:07:26.211] This GDB supports auto-downloading debuginfo from the following URLs: [10:07:26.211] [10:07:26.211] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [10:07:26.211] Debuginfod has been disabled. [10:07:26.211] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [10:07:26.325] [Thread debugging using libthread_db enabled] [10:07:26.325] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [10:07:26.325] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [10:07:26.325] Program terminated with signal SIGABRT, Aborted. [10:07:26.325] #0 0x00007f4a6cca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:27.174] [10:07:27.174] Thread 1 (Thread 0x7f4a6d434f00 (LWP 30410)): [10:07:27.174] #0 0x00007f4a6cca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:27.174] No symbol table info available. [10:07:27.174] #1 0x00007f4a6cc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:27.174] No symbol table info available. [10:07:27.174] #2 0x00007f4a6cc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:27.174] No symbol table info available. [10:07:27.174] #3 0x000055b65d7de248 in ExceptionalCondition (conditionName=conditionName@entry=0x55b65da53395 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55b65da528b0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [10:07:27.174] No locals. [10:07:27.174] #4 0x000055b65d15fa2d in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55b6994bc0f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [10:07:27.174] estate = 0x55b6993d59b0 [10:07:27.174] oldcontext = 0x55b699450bf0 [10:07:27.174] __func__ = "standard_ExecutorStart" [10:07:27.174] #5 0x000055b65d15fc09 in ExecutorStart (queryDesc=queryDesc@entry=0x55b6994bc0f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [10:07:27.174] No locals. [10:07:27.174] #6 0x000055b65d084424 in refresh_matview_datafill (dest=0x55b69944f0c8, query=, query@entry=0x55b699447d70, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [10:07:27.174] rewritten = [10:07:27.174] plan = 0x55b6994bb628 [10:07:27.174] queryDesc = 0x55b6994bc0f0 [10:07:27.174] copied_query = [10:07:27.174] processed = [10:07:27.174] __func__ = "refresh_matview_datafill" [10:07:27.174] #7 0x000055b65d08678b in RefreshMatViewByOid (matviewOid=28406, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [10:07:27.174] dest = [10:07:27.174] matviewRel = 0x7f4a6161bd08 [10:07:27.174] rule = [10:07:27.174] actions = [10:07:27.174] dataQuery = 0x55b699447d70 [10:07:27.174] tableSpace = [10:07:27.174] relowner = 10 [10:07:27.174] OIDNewHeap = 28413 [10:07:27.174] processed = 0 [10:07:27.174] relpersistence = 112 'p' [10:07:27.174] save_userid = 10 [10:07:27.174] save_sec_context = 0 [10:07:27.174] save_nestlevel = 2 [10:07:27.174] address = {classId = 0, objectId = 0, objectSubId = 0} [10:07:27.174] __func__ = "RefreshMatViewByOid" [10:07:27.174] #8 0x000055b65d0868ca in ExecRefreshMatView (stmt=0x55b699407410, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [10:07:27.174] matviewOid = [10:07:27.174] lockmode = [10:07:27.174] #9 0x000055b65d03c4f9 in ExecCreateTableAs (pstate=pstate@entry=0x55b699450cf0, stmt=stmt@entry=0x55b69929c770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffdcdb10930) at ../src/backend/commands/createas.c:351 [10:07:27.174] refresh = [10:07:27.174] query = 0x55b69929c930 [10:07:27.174] into = 0x55b69929c4c8 [10:07:27.174] jstate = 0x0 [10:07:27.174] is_matview = true [10:07:27.174] do_refresh = false [10:07:27.174] dest = [10:07:27.174] address = {classId = 1259, objectId = 28406, objectSubId = 0} [10:07:27.174] __func__ = "ExecCreateTableAs" [10:07:27.174] #10 0x000055b65d55639c in ProcessUtilitySlow (pstate=pstate@entry=0x55b699450cf0, pstmt=pstmt@entry=0x55b69929c820, queryString=queryString@entry=0x55b69929ba30 "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=0x55b69929d258, qc=0x7ffdcdb10930) at ../src/backend/tcop/utility.c:1678 [10:07:27.174] _save_exception_stack = 0x7ffdcdb107f0 [10:07:27.174] _save_context_stack = 0x0 [10:07:27.174] _local_sigjmp_buf = {{__jmpbuf = {0, -2903180468447062808, 94242742060912, 0, 94242742057520, 0, -8997209575470115608, -2903594395896097560}, __mask_was_saved = 0, __saved_mask = {__val = {139957443452480, 15282, 94241737710594, 1, 4294982578, 139957443452480, 94241741530721, 139957637434808, 94242742057520, 94241743855653, 94241753835842, 94241753835968, 140728054384180, 94241744050552, 94241753835857, 94241753835968}}}} [10:07:27.174] _do_rethrow = false [10:07:27.174] parsetree = 0x55b69929c770 [10:07:27.174] isTopLevel = true [10:07:27.174] isCompleteQuery = true [10:07:27.174] needCleanup = false [10:07:27.174] commandCollected = false [10:07:27.174] address = {classId = 21942, objectId = 2569652080, objectSubId = 21942} [10:07:27.174] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [10:07:27.174] __func__ = "ProcessUtilitySlow" [10:07:27.174] #11 0x000055b65d5549ad in standard_ProcessUtility (pstmt=0x55b69929c820, queryString=0x55b69929ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55b69929d258, qc=0x7ffdcdb10930) at ../src/backend/tcop/utility.c:1070 [10:07:27.174] parsetree = 0x55b69929c770 [10:07:27.174] isTopLevel = true [10:07:27.174] isAtomicContext = false [10:07:27.174] pstate = 0x55b699450cf0 [10:07:27.174] readonly_flags = [10:07:27.174] __func__ = "standard_ProcessUtility" [10:07:27.174] #12 0x000055b65d554b08 in ProcessUtility (pstmt=pstmt@entry=0x55b69929c820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55b69929d258, qc=0x7ffdcdb10930) at ../src/backend/tcop/utility.c:523 [10:07:27.174] No locals. [10:07:27.174] #13 0x000055b65d550374 in PortalRunUtility (portal=portal@entry=0x55b69931e680, pstmt=pstmt@entry=0x55b69929c820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55b69929d258, qc=qc@entry=0x7ffdcdb10930) at ../src/backend/tcop/pquery.c:1158 [10:07:27.174] No locals. [10:07:27.174] #14 0x000055b65d550919 in PortalRunMulti (portal=portal@entry=0x55b69931e680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55b69929d258, altdest=altdest@entry=0x55b69929d258, qc=qc@entry=0x7ffdcdb10930) at ../src/backend/tcop/pquery.c:1315 [10:07:27.174] pstmt = 0x55b69929c820 [10:07:27.174] stmtlist_item__state = [10:07:27.174] active_snapshot_set = false [10:07:27.174] stmtlist_item = 0x55b69929d220 [10:07:27.174] #15 0x000055b65d550eec in PortalRun (portal=portal@entry=0x55b69931e680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55b69929d258, altdest=altdest@entry=0x55b69929d258, qc=0x7ffdcdb10930) at ../src/backend/tcop/pquery.c:791 [10:07:27.174] _save_exception_stack = 0x7ffdcdb109e0 [10:07:27.174] _save_context_stack = 0x0 [10:07:27.174] _local_sigjmp_buf = {{__jmpbuf = {0, -2903180468643146520, 94242742593152, 94242742061032, 94242742593152, 94242742060960, -8997209575340092184, -2903594397869648664}, __mask_was_saved = 0, __saved_mask = {__val = {94241741214421, 94242742057264, 112, 4, 94241741218838, 3450931391, 4, 94242742060960, 112, 73, 94242742593152, 94242742061032, 94242742061008, 94242742060960, 94241741306041, 1}}}} [10:07:27.174] _do_rethrow = [10:07:27.174] result = [10:07:27.174] nprocessed = [10:07:27.174] saveTopTransactionResourceOwner = 0x55b6992db838 [10:07:27.174] saveTopTransactionContext = 0x55b69932f660 [10:07:27.174] saveActivePortal = 0x0 [10:07:27.174] saveResourceOwner = 0x55b6992db838 [10:07:27.174] savePortalContext = 0x0 [10:07:27.174] saveMemoryContext = 0x55b69932f660 [10:07:27.174] __func__ = "PortalRun" [10:07:27.174] #16 0x000055b65d54a2d8 in exec_simple_query (query_string=query_string@entry=0x55b69929ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [10:07:27.174] cmdtaglen = 24 [10:07:27.174] snapshot_set = [10:07:27.174] per_parsetree_context = 0x0 [10:07:27.174] plantree_list = 0x55b69929d208 [10:07:27.174] parsetree = 0x55b69929c7a0 [10:07:27.174] commandTag = [10:07:27.174] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:07:27.174] querytree_list = [10:07:27.174] portal = 0x55b69931e680 [10:07:27.174] receiver = 0x55b69929d258 [10:07:27.174] format = 0 [10:07:27.174] cmdtagname = [10:07:27.174] parsetree_item__state = [10:07:27.174] dest = DestRemote [10:07:27.174] oldcontext = 0x55b69932f660 [10:07:27.174] parsetree_list = 0x55b69929c7d0 [10:07:27.174] parsetree_item = 0x55b69929c7e8 [10:07:27.174] save_log_statement_stats = false [10:07:27.174] was_logged = true [10:07:27.174] use_implicit_block = false [10:07:27.174] msec_str = "\220\v\261\315\375\177\000\000\267@\200]\266U\000\000\300\t\261\315\375\177\000\000G\000\000\000\000\000\000" [10:07:27.174] __func__ = "exec_simple_query" [10:07:27.174] #17 0x000055b65d54d05c in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [10:07:27.174] query_string = 0x55b69929ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [10:07:27.174] firstchar = [10:07:27.174] input_message = {data = 0x55b69929ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [10:07:27.174] local_sigjmp_buf = {{__jmpbuf = {94241753844408, -2903596453155023640, 4, 140728054385552, 140728054385696, 140728054385700, -8997209575805659928, -2903594408801708824}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94242741788080, 14336, 94241753838496, 94242742314992, 140728054385696, 94241741218386, 0, 9, 2, 94241753844416, 94242741788080, 94241753838496, 140728054385552, 140728054385696, 140728054385700}}}} [10:07:27.174] send_ready_for_query = false [10:07:27.174] idle_in_transaction_timeout_enabled = false [10:07:27.174] idle_session_timeout_enabled = false [10:07:27.174] __func__ = "PostgresMain" [10:07:27.174] #18 0x000055b65d542ed2 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:07:27.174] bsdata = [10:07:27.174] #19 0x000055b65d3f6644 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffdcdb10b3c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdcdb10b90) at ../src/backend/postmaster/launch_backend.c:266 [10:07:27.174] pid = [10:07:27.174] #20 0x000055b65d3fc0f8 in BackendStartup (client_sock=client_sock@entry=0x7ffdcdb10b90) at ../src/backend/postmaster/postmaster.c:3417 [10:07:27.174] bn = 0x55b6992d0de8 [10:07:27.174] pid = [10:07:27.174] startup_data = {canAcceptConnections = CAC_OK} [10:07:27.174] __func__ = "BackendStartup" [10:07:27.174] #21 0x000055b65d3fc65a in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [10:07:27.174] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\303lJ\177\000\000\240\017\024nJ\177\000\0008\f\261\315\375\177\000\0004\f\261\315\375\177", '\000' , "\372\201Z\\\266U\000\000@gV\\\266U\000\000\000\r\261\315\375\177\000\000\370\f\261\315\375\177\000\000\225[\362\001\000\000\000\000\2404DmJ\177\000\000+", '\000' , "\266U\000\000\b\201Z\\\266U\000", __ss_align = 139957656036968}, salen = 2}} [10:07:27.174] i = 0 [10:07:27.174] now = [10:07:27.174] last_lockfile_recheck_time = 1731405804 [10:07:27.174] last_touch_time = 1731405804 [10:07:27.174] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55b65c5a81fa}, {pos = 1851729512, events = 32586, fd = 1833186864, user_data = 0x7f4a6e5f22e0}, {pos = 2090263927, events = 0, fd = -844034688, user_data = 0x7f4a6e5c8a48}, {pos = 15, events = 0, fd = 1833186864, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f4a6e5f22e0}, {pos = -844034824, events = 32765, fd = -844034816, user_data = 0x7f4a6e5f2668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -1725310992, events = 21942, fd = 1, user_data = 0x7ffdcdb11223}, {pos = -1, events = 0, fd = 1824710688, user_data = 0x7f4a6e140fa0}, {pos = -1725127832, events = 21942, fd = -1725128120, user_data = 0x55b6992ca021}, {pos = 1851584190, events = 32586, fd = 1, user_data = 0x7f4a6e5f22e0}, {pos = 427, events = 0, fd = 1574444376, user_data = 0x0}, {pos = 1, events = 0, fd = -1725318584, user_data = 0x7f4a6e5ceebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f4a6cc2e020}, {pos = 1825517120, events = 32586, fd = 16, user_data = 0x7ffdcdb11160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1851593146, events = 32586, fd = 0, user_data = 0x7f4a6ccaeda4 }, {pos = 0, events = 0, fd = 1581372448, user_data = 0x2}, {pos = 7, events = 0, fd = -1725571504, user_data = 0x55b65d4e0e5d }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -1725318584, user_data = 0x7f4a6e5ceebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f4a6cc364c8}, {pos = 1825271559, events = 32586, fd = 1581427136, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1826561120, events = 32586, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1725154752, user_data = 0x7f4a6ccb576b}, {pos = 1826544096, events = 32586, fd = 1825182062, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x5f5191e476a61200}, {pos = 1826547168, events = 32586, fd = -328, user_data = 0x0}, {pos = -1725128440, events = 21942, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1725128640, events = 21942, fd = 3, user_data = 0x0}, {pos = 26447, events = 0, fd = -328, user_data = 0x0}, {pos = -1725318584, events = 21942, fd = 1825517651, user_data = 0x7ffdcdb11218}, {pos = 1568888905, events = 21942, fd = 1581435504, user_data = 0x55b65d824306 }, {pos = -1725128640, events = 21942, fd = -1725318864, user_data = 0x55b6992ca040}, {pos = 1825265515, events = 32586, fd = 0, user_data = 0x55b65d835f70 }, {pos = -1725128640, events = 1, fd = 1568891065, user_data = 0x55b69929b930}, {pos = 1990595072, events = 1599181284, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1825188529, user_data = 0x7f4a6cca14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1990595072, user_data = 0x55b699273060}, {pos = 1990595072, events = 1599181284, fd = 11, user_data = 0x5f5191e476a61200}, {pos = 0, events = 0, fd = 1824895545, user_data = 0x1}, {pos = 1564435265, events = 21942, fd = 4194304, user_data = 0x55b65d82419a }, {pos = -1725484960, events = 21942, fd = -1725318864, user_data = 0x55b699273060}, {pos = 1, events = 0, fd = 0, user_data = 0x55b65d835f70 }, {pos = -1725484960, events = 21942, fd = 1568891065, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55b65d22972d }, {pos = 0, events = 0, fd = 1562569325, user_data = 0xb}, {pos = 1564456422, events = 21942, fd = 1577812016, user_data = 0x55b69929c2d8}} [10:07:27.175] nevents = 1 [10:07:27.175] __func__ = "ServerLoop" [10:07:27.175] #22 0x000055b65d3fdddd in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55b699259cc0) at ../src/backend/postmaster/postmaster.c:1348 [10:07:27.175] opt = [10:07:27.175] status = [10:07:27.175] userDoption = [10:07:27.175] listen_addr_saved = false [10:07:27.175] output_config_variable = [10:07:27.175] __func__ = "PostmasterMain" [10:07:27.175] #23 0x000055b65d239ab5 in main (argc=4, argv=0x55b699259cc0) at ../src/backend/main/main.c:196 [10:07:27.175] do_check_root = [10:07:27.210] -e [10:07:27.210] [10:07:27.210] [10:07:27.273] dumping /tmp/cores/postgres-6-29266.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [10:07:27.531] [New LWP 29266] [10:07:27.531] [10:07:27.531] This GDB supports auto-downloading debuginfo from the following URLs: [10:07:27.531] [10:07:27.531] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [10:07:27.531] Debuginfod has been disabled. [10:07:27.531] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [10:07:27.639] [Thread debugging using libthread_db enabled] [10:07:27.639] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [10:07:27.639] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [10:07:27.639] Program terminated with signal SIGABRT, Aborted. [10:07:27.639] #0 0x00007f426e6a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:28.491] [10:07:28.491] Thread 1 (Thread 0x7f426c225f00 (LWP 29266)): [10:07:28.491] #0 0x00007f426e6a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:28.491] No symbol table info available. [10:07:28.491] #1 0x00007f426e65afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:28.491] No symbol table info available. [10:07:28.491] #2 0x00007f426e645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [10:07:28.491] No symbol table info available. [10:07:28.491] #3 0x00005605831cd248 in ExceptionalCondition (conditionName=conditionName@entry=0x560583442395 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5605834418b0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [10:07:28.491] No locals. [10:07:28.491] #4 0x0000560582b4ea2d in standard_ExecutorStart (queryDesc=queryDesc@entry=0x560593ba38b0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [10:07:28.491] estate = 0x560593ab2f20 [10:07:28.491] oldcontext = 0x560593a9ba70 [10:07:28.491] __func__ = "standard_ExecutorStart" [10:07:28.491] #5 0x0000560582b4ec09 in ExecutorStart (queryDesc=queryDesc@entry=0x560593ba38b0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [10:07:28.491] No locals. [10:07:28.491] #6 0x0000560582a73424 in refresh_matview_datafill (dest=0x560593b34068, query=, query@entry=0x560593b2dd00, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [10:07:28.491] rewritten = [10:07:28.491] plan = 0x560593ba2de8 [10:07:28.491] queryDesc = 0x560593ba38b0 [10:07:28.491] copied_query = [10:07:28.491] processed = [10:07:28.491] __func__ = "refresh_matview_datafill" [10:07:28.491] #7 0x0000560582a7578b in RefreshMatViewByOid (matviewOid=28391, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [10:07:28.491] dest = [10:07:28.491] matviewRel = 0x7f4262c63888 [10:07:28.491] rule = [10:07:28.491] actions = [10:07:28.491] dataQuery = 0x560593b2dd00 [10:07:28.491] tableSpace = [10:07:28.491] relowner = 10 [10:07:28.491] OIDNewHeap = 28399 [10:07:28.491] processed = 0 [10:07:28.491] relpersistence = 112 'p' [10:07:28.491] save_userid = 10 [10:07:28.491] save_sec_context = 0 [10:07:28.491] save_nestlevel = 2 [10:07:28.491] address = {classId = 0, objectId = 0, objectSubId = 0} [10:07:28.491] __func__ = "RefreshMatViewByOid" [10:07:28.491] #8 0x0000560582a758ca in ExecRefreshMatView (stmt=0x560593abffa0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [10:07:28.491] matviewOid = [10:07:28.491] lockmode = [10:07:28.491] #9 0x0000560582a2b4f9 in ExecCreateTableAs (pstate=pstate@entry=0x560593a9bb70, stmt=stmt@entry=0x5605939847f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc8d98ff00) at ../src/backend/commands/createas.c:351 [10:07:28.491] refresh = [10:07:28.491] query = 0x5605939849b0 [10:07:28.491] into = 0x560593984548 [10:07:28.491] jstate = 0x0 [10:07:28.491] is_matview = true [10:07:28.491] do_refresh = false [10:07:28.491] dest = [10:07:28.491] address = {classId = 1259, objectId = 28391, objectSubId = 0} [10:07:28.491] __func__ = "ExecCreateTableAs" [10:07:28.491] #10 0x0000560582f4539c in ProcessUtilitySlow (pstate=pstate@entry=0x560593a9bb70, pstmt=pstmt@entry=0x5605939848a0, queryString=queryString@entry=0x560593983ab0 "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=0x5605939852d8, qc=0x7ffc8d98ff00) at ../src/backend/tcop/utility.c:1678 [10:07:28.491] _save_exception_stack = 0x7ffc8d98fdc0 [10:07:28.491] _save_context_stack = 0x0 [10:07:28.491] _local_sigjmp_buf = {{__jmpbuf = {0, -3602186325332989173, 94581951055856, 0, 94581951052464, 0, -7066065772134405365, -3602224085182846197}, __mask_was_saved = 0, __saved_mask = {__val = {139923109859712, 9595, 94581671300098, 1, 4294976891, 139923109859712, 94581671290416, 1, 41212688677080, 1, 9595, 139923109859712, 139923109859712, 1, 94581671300445, 94581952297176}}}} [10:07:28.491] _do_rethrow = false [10:07:28.491] parsetree = 0x5605939847f0 [10:07:28.491] isTopLevel = true [10:07:28.491] isCompleteQuery = true [10:07:28.491] needCleanup = false [10:07:28.491] commandCollected = false [10:07:28.491] address = {classId = 22021, objectId = 2476230640, objectSubId = 22021} [10:07:28.491] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [10:07:28.491] __func__ = "ProcessUtilitySlow" [10:07:28.491] #11 0x0000560582f439ad in standard_ProcessUtility (pstmt=0x5605939848a0, queryString=0x560593983ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5605939852d8, qc=0x7ffc8d98ff00) at ../src/backend/tcop/utility.c:1070 [10:07:28.491] parsetree = 0x5605939847f0 [10:07:28.491] isTopLevel = true [10:07:28.491] isAtomicContext = false [10:07:28.491] pstate = 0x560593a9bb70 [10:07:28.491] readonly_flags = [10:07:28.491] __func__ = "standard_ProcessUtility" [10:07:28.491] #12 0x0000560582f43b08 in ProcessUtility (pstmt=pstmt@entry=0x5605939848a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5605939852d8, qc=0x7ffc8d98ff00) at ../src/backend/tcop/utility.c:523 [10:07:28.491] No locals. [10:07:28.491] #13 0x0000560582f3f374 in PortalRunUtility (portal=portal@entry=0x560593a06050, pstmt=pstmt@entry=0x5605939848a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5605939852d8, qc=qc@entry=0x7ffc8d98ff00) at ../src/backend/tcop/pquery.c:1158 [10:07:28.491] No locals. [10:07:28.491] #14 0x0000560582f3f919 in PortalRunMulti (portal=portal@entry=0x560593a06050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5605939852d8, altdest=altdest@entry=0x5605939852d8, qc=qc@entry=0x7ffc8d98ff00) at ../src/backend/tcop/pquery.c:1315 [10:07:28.491] pstmt = 0x5605939848a0 [10:07:28.491] stmtlist_item__state = [10:07:28.491] active_snapshot_set = false [10:07:28.491] stmtlist_item = 0x5605939852a0 [10:07:28.491] #15 0x0000560582f3feec in PortalRun (portal=portal@entry=0x560593a06050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5605939852d8, altdest=altdest@entry=0x5605939852d8, qc=0x7ffc8d98ff00) at ../src/backend/tcop/pquery.c:791 [10:07:28.491] _save_exception_stack = 0x7ffc8d98ffb0 [10:07:28.491] _save_context_stack = 0x0 [10:07:28.491] _local_sigjmp_buf = {{__jmpbuf = {0, -3602186324604228853, 94581951586384, 94581951055976, 94581951586384, 94581951055904, -7066065772272817397, -3602224083146118389}, __mask_was_saved = 0, __saved_mask = {__val = {94581674803925, 94581951052208, 112, 4, 94581674808342, 2375614095, 4, 94581951055904, 112, 73, 94581951586384, 94581951055976, 94581951055952, 94581951055904, 94581674895545, 1}}}} [10:07:28.491] _do_rethrow = [10:07:28.491] result = [10:07:28.491] nprocessed = [10:07:28.491] saveTopTransactionResourceOwner = 0x5605939c2d08 [10:07:28.491] saveTopTransactionContext = 0x560593a17c60 [10:07:28.491] saveActivePortal = 0x0 [10:07:28.491] saveResourceOwner = 0x5605939c2d08 [10:07:28.491] savePortalContext = 0x0 [10:07:28.491] saveMemoryContext = 0x560593a17c60 [10:07:28.491] __func__ = "PortalRun" [10:07:28.491] #16 0x0000560582f392d8 in exec_simple_query (query_string=query_string@entry=0x560593983ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [10:07:28.491] cmdtaglen = 24 [10:07:28.491] snapshot_set = [10:07:28.491] per_parsetree_context = 0x0 [10:07:28.491] plantree_list = 0x560593985288 [10:07:28.491] parsetree = 0x560593984820 [10:07:28.491] commandTag = [10:07:28.491] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:07:28.491] querytree_list = [10:07:28.491] portal = 0x560593a06050 [10:07:28.491] receiver = 0x5605939852d8 [10:07:28.491] format = 0 [10:07:28.491] cmdtagname = [10:07:28.491] parsetree_item__state = [10:07:28.491] dest = DestRemote [10:07:28.491] oldcontext = 0x560593a17c60 [10:07:28.491] parsetree_list = 0x560593984850 [10:07:28.491] parsetree_item = 0x560593984868 [10:07:28.491] save_log_statement_stats = false [10:07:28.491] was_logged = false [10:07:28.491] use_implicit_block = false [10:07:28.491] msec_str = "`\001\231\215\374\177\000\000\2670\037\203\005V\000\000\220\377\230\215\374\177\000\000G\000\000\000\000\000\000" [10:07:28.491] __func__ = "exec_simple_query" [10:07:28.491] #17 0x0000560582f3c05c in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [10:07:28.491] query_string = 0x560593983ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [10:07:28.491] firstchar = [10:07:28.491] input_message = {data = 0x560593983ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [10:07:28.491] local_sigjmp_buf = {{__jmpbuf = {94581687433912, -3602221727217489141, 4, 140722684100960, 140722684101104, 140722684101108, -7066065772335731957, -3602224080808449269}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94581950782928, 15616, 94581687428000, 94581951306944, 140722684101104, 94581674807890, 0, 9, 2, 94581687433920, 94581950782928, 94581687428000, 140722684100960, 140722684101104, 140722684101108}}}} [10:07:28.491] send_ready_for_query = false [10:07:28.491] idle_in_transaction_timeout_enabled = false [10:07:28.491] idle_session_timeout_enabled = false [10:07:28.491] __func__ = "PostgresMain" [10:07:28.491] #18 0x0000560582f31ed2 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:07:28.491] bsdata = [10:07:28.491] #19 0x0000560582de5644 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc8d99010c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc8d990160) at ../src/backend/postmaster/launch_backend.c:266 [10:07:28.491] pid = [10:07:28.491] #20 0x0000560582deb0f8 in BackendStartup (client_sock=client_sock@entry=0x7ffc8d990160) at ../src/backend/postmaster/postmaster.c:3417 [10:07:28.491] bn = 0x5605939ac0c8 [10:07:28.491] pid = [10:07:28.491] startup_data = {canAcceptConnections = CAC_OK} [10:07:28.491] __func__ = "BackendStartup" [10:07:28.491] #21 0x0000560582deb65a in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [10:07:28.491] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\231\215\374\177\000\000\364\001\231\215\374\177", '\000' , "\372q\371\201\005V\000\000@W\365\201\005V\000\000\300\002\231\215\374\177\000\000\270\002\231\215\374\177\000\000\225[\362\001\000\000\000\000\240\204HoB\177\000\000+", '\000' , "\bq\371\201\005V\000\000h\226\364oB\177\000\0000\206HoB\177\000", __ss_align = 139923322868448}, salen = 2}} [10:07:28.491] i = 0 [10:07:28.491] now = [10:07:28.491] last_lockfile_recheck_time = 1731405802 [10:07:28.491] last_touch_time = 1731405802 [10:07:28.491] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -2114358790, events = 22021, fd = 1878300264, user_data = 0x7f426f488630}, {pos = 1878299360, events = 32578, fd = 2090263927, user_data = 0x7ffc8d990340}, {pos = 1878129224, events = 32578, fd = 15, user_data = 0x7f426f488630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1878299360, events = 32578, fd = -1919352136, user_data = 0x7ffc8d9902c0}, {pos = 1878300264, events = 32578, fd = 0, user_data = 0x560593983b70}, {pos = -2094666013, events = 22021, fd = 32768, user_data = 0x1}, {pos = -1818732368, events = 22021, fd = -1, user_data = 0x7f426e62e020}, {pos = 1874071456, events = 32578, fd = -1818556600, user_data = 0x5605939b0628}, {pos = -1818548159, events = 22021, fd = 1878154942, user_data = 0x1}, {pos = 1878299360, events = 32578, fd = 427, user_data = 0x560583770d58 }, {pos = 0, events = 0, fd = 1, user_data = 0x560593983b70}, {pos = 1878154942, events = 32578, fd = 1, user_data = 0x0}, {pos = 1851973664, events = 32578, fd = 1852780096, user_data = 0x10}, {pos = -1919350992, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1878163898, user_data = 0x0}, {pos = 1852501412, events = 32578, fd = 0, user_data = 0x560583e0c420 }, {pos = 2, events = 0, fd = 7, user_data = 0x560593945e70}, {pos = -2098413020, events = 22021, fd = -1818530597, user_data = 0x560582ecfe5d }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x560593983b70}, {pos = 1878154942, events = 32578, fd = 1, user_data = 0x0}, {pos = 1852007624, events = 32578, fd = 1852426368, user_data = 0x420}, {pos = 1852534893, events = 32578, fd = 2, user_data = 0x5605939af410}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 1853824096, events = 32578, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x776b76512d737365}, {pos = 168441905, events = 824188960, fd = 822763892, user_data = 0x30340a3230383530}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, 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 = 0, user_data = 0xa}, {pos = -2094988587, events = 22021, fd = -1818554320, user_data = 0x7f426e6b576b}, {pos = 1853807072, events = 32578, fd = 1852445038, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x358e49b48da06b00}, {pos = 1853810144, events = 32578, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1818557208, user_data = 0x560583210b98 }, {pos = -1818557408, events = 22021, fd = 3, user_data = 0x0}, {pos = 25786, events = 0, fd = -328, user_data = 0x0}, {pos = -1818739856, events = 22021, fd = 1852780627, user_data = 0x7ffc8d9907e8}, {pos = -2094905271, events = 22021, fd = -2082358672, user_data = 0x560583213306 }, {pos = -1818557408, events = 22021, fd = -1818740304, user_data = 0x5605939b0420}, {pos = 1852528830, events = 32578, fd = 0, user_data = 0x560583224f70 }, {pos = -1818557408, events = 1, fd = -2094903111, user_data = 0x5605939839b0}, {pos = -1918866688, events = 898517428, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1852451505, user_data = 0x7f426e6a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1918866688, user_data = 0x56059395b0e0}, {pos = -1918866688, events = 898517428, fd = 11, user_data = 0x358e49b48da06b00}, {pos = 0, events = 0, fd = 1852158521, user_data = 0x1}, {pos = -2099358911, events = 22021, fd = 4194304, user_data = 0x56058321319a }, {pos = -1818906400, events = 22021, fd = -1818740304, user_data = 0x56059395b0e0}, {pos = 1, events = 0, fd = 0, user_data = 0x560583224f70 }, {pos = -1818906400, events = 22021, fd = -2094903111, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x560582c1872d }, {pos = 0, events = 0, fd = -2101224851, user_data = 0xb}, {pos = -2099337754, events = 22021, fd = -2085982160, user_data = 0x560593984388}} [10:07:28.491] nevents = 1 [10:07:28.491] __func__ = "ServerLoop" [10:07:28.491] #22 0x0000560582decddd in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x560593941d30) at ../src/backend/postmaster/postmaster.c:1348 [10:07:28.491] opt = [10:07:28.491] status = [10:07:28.491] userDoption = [10:07:28.491] listen_addr_saved = false [10:07:28.491] output_config_variable = [10:07:28.491] __func__ = "PostmasterMain" [10:07:28.491] #23 0x0000560582c28ab5 in main (argc=8, argv=0x560593941d30) at ../src/backend/main/main.c:196 [10:07:28.491] do_check_root =