[03:44:45.938] src/tools/ci/cores_backtrace.sh linux /tmp/cores [03:44:46.146] dumping /tmp/cores/postgres-6-30200.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:44:46.393] [New LWP 30200] [03:44:46.393] [03:44:46.393] This GDB supports auto-downloading debuginfo from the following URLs: [03:44:46.393] [03:44:46.393] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:44:46.393] Debuginfod has been disabled. [03:44:46.393] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:44:46.518] [Thread debugging using libthread_db enabled] [03:44:46.518] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:44:46.518] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:44:46.518] Program terminated with signal SIGABRT, Aborted. [03:44:46.518] #0 0x00007f8e13aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:47.477] [03:44:47.477] Thread 1 (Thread 0x7f8e11a21f00 (LWP 30200)): [03:44:47.477] #0 0x00007f8e13aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:47.477] No symbol table info available. [03:44:47.477] #1 0x00007f8e13a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:47.477] No symbol table info available. [03:44:47.477] #2 0x00007f8e13a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:47.477] No symbol table info available. [03:44:47.477] #3 0x00005618d3f2520a in ExceptionalCondition (conditionName=conditionName@entry=0x5618d4197d5d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5618d4197210 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=206) at ../src/backend/utils/error/assert.c:66 [03:44:47.477] No locals. [03:44:47.477] #4 0x00005618d38af5f6 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5618d59bd9f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:206 [03:44:47.477] estate = 0x5618d59b3e90 [03:44:47.477] oldcontext = 0x5618d5a0d1f0 [03:44:47.477] __func__ = "standard_ExecutorStart" [03:44:47.477] #5 0x00005618d38af7d2 in ExecutorStart (queryDesc=queryDesc@entry=0x5618d59bd9f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:147 [03:44:47.477] No locals. [03:44:47.477] #6 0x00005618d37d5890 in refresh_matview_datafill (dest=0x5618d5a0aea8, query=, query@entry=0x5618d59c97a0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:44:47.477] rewritten = [03:44:47.477] plan = 0x5618d59bcf28 [03:44:47.477] queryDesc = 0x5618d59bd9f0 [03:44:47.477] copied_query = [03:44:47.477] processed = [03:44:47.477] __func__ = "refresh_matview_datafill" [03:44:47.477] #7 0x00005618d37d7bf7 in RefreshMatViewByOid (matviewOid=27529, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:44:47.477] dest = [03:44:47.477] matviewRel = 0x7f8e08349000 [03:44:47.477] rule = [03:44:47.477] actions = [03:44:47.477] dataQuery = 0x5618d59c97a0 [03:44:47.477] tableSpace = [03:44:47.477] relowner = 10 [03:44:47.477] OIDNewHeap = 27553 [03:44:47.477] processed = 0 [03:44:47.477] relpersistence = 112 'p' [03:44:47.477] save_userid = 10 [03:44:47.477] save_sec_context = 0 [03:44:47.477] save_nestlevel = 2 [03:44:47.477] address = {classId = 0, objectId = 0, objectSubId = 0} [03:44:47.477] __func__ = "RefreshMatViewByOid" [03:44:47.477] #8 0x00005618d37d7d36 in ExecRefreshMatView (stmt=0x5618d599d240, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:44:47.477] matviewOid = [03:44:47.477] lockmode = [03:44:47.477] #9 0x00005618d378e6b1 in ExecCreateTableAs (pstate=pstate@entry=0x5618d5a0d2f0, stmt=stmt@entry=0x5618d5828770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffdcc266fe0) at ../src/backend/commands/createas.c:350 [03:44:47.477] refresh = [03:44:47.477] query = 0x5618d5828930 [03:44:47.477] into = 0x5618d58284c8 [03:44:47.477] is_matview = true [03:44:47.477] do_refresh = false [03:44:47.477] dest = [03:44:47.477] address = {classId = 1259, objectId = 27529, objectSubId = 0} [03:44:47.477] __func__ = "ExecCreateTableAs" [03:44:47.477] #10 0x00005618d3c9f408 in ProcessUtilitySlow (pstate=pstate@entry=0x5618d5a0d2f0, pstmt=pstmt@entry=0x5618d5828820, queryString=queryString@entry=0x5618d5827a30 "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=0x5618d5829258, qc=0x7ffdcc266fe0) at ../src/backend/tcop/utility.c:1675 [03:44:47.477] _save_exception_stack = 0x7ffdcc266ea0 [03:44:47.477] _save_context_stack = 0x0 [03:44:47.477] _local_sigjmp_buf = {{__jmpbuf = {0, -7498619282654544451, 94664661305200, 0, 94664661301808, 0, -4312831936992428611, -7498632006896239171}, __mask_was_saved = 0, __saved_mask = {__val = {4294982710, 140248005017536, 94664631846851, 1, 66206209178328, 1, 94664635666813, 140248157920696, 94664661301808, 94664637980645, 94664647913442, 94664647913568, 140728028523748, 94664638175320, 94664647913457, 94664647913568}}}} [03:44:47.477] _do_rethrow = false [03:44:47.477] parsetree = 0x5618d5828770 [03:44:47.477] isTopLevel = true [03:44:47.477] isCompleteQuery = true [03:44:47.477] needCleanup = false [03:44:47.477] commandCollected = false [03:44:47.477] address = {classId = 22040, objectId = 3582101360, objectSubId = 22040} [03:44:47.477] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:44:47.477] __func__ = "ProcessUtilitySlow" [03:44:47.477] #11 0x00005618d3c9da19 in standard_ProcessUtility (pstmt=0x5618d5828820, queryString=0x5618d5827a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5618d5829258, qc=0x7ffdcc266fe0) at ../src/backend/tcop/utility.c:1067 [03:44:47.477] parsetree = 0x5618d5828770 [03:44:47.477] isTopLevel = true [03:44:47.477] isAtomicContext = false [03:44:47.477] pstate = 0x5618d5a0d2f0 [03:44:47.477] readonly_flags = [03:44:47.477] __func__ = "standard_ProcessUtility" [03:44:47.477] #12 0x00005618d3c9db74 in ProcessUtility (pstmt=pstmt@entry=0x5618d5828820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5618d5829258, qc=0x7ffdcc266fe0) at ../src/backend/tcop/utility.c:523 [03:44:47.477] No locals. [03:44:47.477] #13 0x00005618d3c993e0 in PortalRunUtility (portal=portal@entry=0x5618d58aa680, pstmt=pstmt@entry=0x5618d5828820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5618d5829258, qc=qc@entry=0x7ffdcc266fe0) at ../src/backend/tcop/pquery.c:1158 [03:44:47.477] No locals. [03:44:47.477] #14 0x00005618d3c99985 in PortalRunMulti (portal=portal@entry=0x5618d58aa680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5618d5829258, altdest=altdest@entry=0x5618d5829258, qc=qc@entry=0x7ffdcc266fe0) at ../src/backend/tcop/pquery.c:1316 [03:44:47.477] pstmt = 0x5618d5828820 [03:44:47.477] stmtlist_item__state = [03:44:47.477] active_snapshot_set = false [03:44:47.477] stmtlist_item = 0x5618d5829220 [03:44:47.477] #15 0x00005618d3c99f58 in PortalRun (portal=portal@entry=0x5618d58aa680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5618d5829258, altdest=altdest@entry=0x5618d5829258, qc=0x7ffdcc266fe0) at ../src/backend/tcop/pquery.c:791 [03:44:47.477] _save_exception_stack = 0x7ffdcc267090 [03:44:47.477] _save_context_stack = 0x0 [03:44:47.477] _local_sigjmp_buf = {{__jmpbuf = {0, -7498619282989040195, 94664661837440, 94664661305320, 94664661837440, 94664661305248, -4312831936862405187, -7498632004838801987}, __mask_was_saved = 0, __saved_mask = {__val = {94664635351474, 94664661301552, 112, 4, 94664635355891, 3425070959, 4, 94664661305248, 112, 73, 94664661837440, 94664661305320, 94664661305296, 94664661305248, 94664635443094, 1}}}} [03:44:47.477] _do_rethrow = [03:44:47.477] result = [03:44:47.477] nprocessed = [03:44:47.477] saveTopTransactionResourceOwner = 0x5618d5867838 [03:44:47.477] saveTopTransactionContext = 0x5618d58bb660 [03:44:47.477] saveActivePortal = 0x0 [03:44:47.477] saveResourceOwner = 0x5618d5867838 [03:44:47.477] savePortalContext = 0x0 [03:44:47.477] saveMemoryContext = 0x5618d58bb660 [03:44:47.477] __func__ = "PortalRun" [03:44:47.477] #16 0x00005618d3c93344 in exec_simple_query (query_string=query_string@entry=0x5618d5827a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:44:47.477] cmdtaglen = 24 [03:44:47.477] snapshot_set = [03:44:47.477] per_parsetree_context = 0x0 [03:44:47.477] plantree_list = 0x5618d5829208 [03:44:47.477] parsetree = 0x5618d58287a0 [03:44:47.477] commandTag = [03:44:47.477] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:44:47.477] querytree_list = [03:44:47.477] portal = 0x5618d58aa680 [03:44:47.477] receiver = 0x5618d5829258 [03:44:47.477] format = 0 [03:44:47.477] cmdtagname = [03:44:47.477] parsetree_item__state = [03:44:47.477] dest = DestRemote [03:44:47.477] oldcontext = 0x5618d58bb660 [03:44:47.477] parsetree_list = 0x5618d58287d0 [03:44:47.477] parsetree_item = 0x5618d58287e8 [03:44:47.477] save_log_statement_stats = false [03:44:47.477] was_logged = true [03:44:47.477] use_implicit_block = false [03:44:47.477] msec_str = "@r&\314\375\177\000\000\270\257\364\323\030V\000\000pp&\314\375\177\000\000G\000\000\000\000\000\000" [03:44:47.477] __func__ = "exec_simple_query" [03:44:47.477] #17 0x00005618d3c960c8 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [03:44:47.477] query_string = 0x5618d5827a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:44:47.477] firstchar = [03:44:47.477] input_message = {data = 0x5618d5827a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:44:47.477] local_sigjmp_buf = {{__jmpbuf = {94664647922008, -7498617537043939907, 4, 140728028525120, 140728028525264, 140728028525268, -4312831937193755203, -7498632011345609283}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94664661032368, 14336, 94664647916096, 94664661559280, 140728028525264, 94664635355439, 0, 9, 2, 94664647922016, 94664661032368, 94664647916096, 140728028525120, 140728028525264, 140728028525268}}}} [03:44:47.477] send_ready_for_query = false [03:44:47.477] idle_in_transaction_timeout_enabled = false [03:44:47.477] idle_session_timeout_enabled = false [03:44:47.477] __func__ = "PostgresMain" [03:44:47.477] #18 0x00005618d3c8bf3f in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:44:47.477] bsdata = [03:44:47.477] #19 0x00005618d3b438de in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffdcc2671ec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdcc267240) at ../src/backend/postmaster/launch_backend.c:274 [03:44:47.477] pid = [03:44:47.477] #20 0x00005618d3b49392 in BackendStartup (client_sock=client_sock@entry=0x7ffdcc267240) at ../src/backend/postmaster/postmaster.c:3420 [03:44:47.477] bn = 0x5618d585cd98 [03:44:47.477] pid = [03:44:47.477] startup_data = {canAcceptConnections = CAC_OK} [03:44:47.477] __func__ = "BackendStartup" [03:44:47.477] #21 0x00005618d3b498f4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [03:44:47.477] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = ".\025\216\177\000\000>\004\000\000\000\000\000\000\260\227\243\023\216\177\000\000\240?\213\024\216\177\000\000\370r&\314\375\177\000\000\364r&\314\375\177", '\000' , "\376\217\320\322\030V\000\000\230w\314\322\030V\000\000\300s&\314\375\177\000\000\270s&\314\375\177\000\000\225[\362\001Qy\025\256\240T#\024\216\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [03:44:47.477] i = 0 [03:44:47.477] now = [03:44:47.477] last_lockfile_recheck_time = 1727754053 [03:44:47.477] last_touch_time = 1727754053 [03:44:47.477] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -869895168, user_data = 0x0}, {pos = 15, events = 0, fd = -758083586, user_data = 0x7f8e1530b668}, {pos = 337860144, events = 32654, fd = 355513056, user_data = 0x7c96e577}, {pos = -869895104, events = 32765, fd = 355342920, user_data = 0xf}, {pos = 337860144, events = 32654, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 355513056, user_data = 0x7ffdcc2673b8}, {pos = -869895232, events = 32765, fd = 355513960, user_data = 0x0}, {pos = -712861712, events = 22040, fd = 330231013, user_data = 0x7ffdcc2678d3}, {pos = 1, events = 0, fd = -869895232, user_data = 0xffffffff}, {pos = 329441312, events = 32654, fd = 344670112, user_data = 0x5618d5856368}, {pos = -712678840, events = 22040, fd = -712679391, user_data = 0x7f8e152e7ebe}, {pos = 1, events = 0, fd = 355513056, user_data = 0x1b6}, {pos = -733200976, events = 22040, fd = 0, user_data = 0x1}, {pos = -712869304, events = 22040, fd = 355368638, user_data = 0x1}, {pos = 0, events = 0, fd = 329441312, user_data = 0x7f8e13af2dc0 }, {pos = 16, events = 0, fd = -869894128, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f8e152ea1ba}, {pos = 0, events = 0, fd = 329968932, user_data = 0x0}, {pos = -726312224, events = 22040, fd = 2, user_data = 0x7}, {pos = -713122224, events = 22040, fd = 1952410737, user_data = 0x169}, {pos = -733201592, events = 22040, fd = 4, user_data = 0x2ffff00001fa0}, {pos = -712869304, events = 22040, fd = 355368638, user_data = 0x1}, {pos = 330002055, events = 32654, fd = 329475272, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 331291744, events = 32654, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x5618d57e9e50}, {pos = 330005002, events = 32654, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 824188960, events = 859123764, fd = 538976266, user_data = 0x0}, {pos = 0, events = 0, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 22016, 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 = 331274720, events = 32654, fd = 329912686, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0xae157951e161f800}, {pos = 331277792, events = 32654, fd = -328, user_data = 0x0}, {pos = -712679160, events = 22040, fd = 1024, user_data = 0x5618d5856108}, {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 = 26364, events = 0, fd = -328, user_data = 0x0}, {pos = -712869304, events = 22040, fd = 330248147, user_data = 0x7ffdcc2678c8}, {pos = -738736346, events = 22040, fd = -726249200, user_data = 0x5618d3f6b1e3 }, {pos = -712679360, events = 22040, fd = -712869584, user_data = 0x5618d5856040}, {pos = 329996011, events = 32654, fd = 0, user_data = 0x5618d3f7ce4d }, {pos = -712679360, events = 1, fd = -738734186, user_data = 0x5618d5827930}, {pos = -513673216, events = 2920642897, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 329919153, user_data = 0x7f8e13aa14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -513673216, user_data = 0x5618d57ff060}, {pos = -513673216, events = 2920642897, fd = 11, user_data = 0xae157951e161f800}, {pos = 0, events = 0, fd = 329626169, user_data = 0x1}, {pos = -743164453, events = 22040, fd = 4194304, user_data = 0x5618d3f6b077 }, {pos = -713035680, events = 22040, fd = -712869584, user_data = 0x5618d57ff060}, {pos = 1, events = 0, fd = 0, user_data = 0x5618d3f7ce4d }, {pos = -713035680, events = 22040, fd = -738734186, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5618d3978fa9 }, {pos = 0, events = 0, fd = -745020695, user_data = 0xb}, {pos = -743143296, events = 22040, fd = -729851728, user_data = 0x5618d58282d8}} [03:44:47.477] nevents = 1 [03:44:47.477] __func__ = "ServerLoop" [03:44:47.477] #22 0x00005618d3b4b077 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5618d57e5cc0) at ../src/backend/postmaster/postmaster.c:1351 [03:44:47.477] opt = [03:44:47.477] status = [03:44:47.477] userDoption = [03:44:47.477] listen_addr_saved = false [03:44:47.477] output_config_variable = [03:44:47.477] __func__ = "PostmasterMain" [03:44:47.477] #23 0x00005618d3989385 in main (argc=4, argv=0x5618d57e5cc0) at ../src/backend/main/main.c:197 [03:44:47.477] do_check_root = [03:44:47.515] -e [03:44:47.515] [03:44:47.515] [03:44:47.577] dumping /tmp/cores/postgres-6-36519.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:44:47.818] [New LWP 36519] [03:44:47.818] [03:44:47.818] This GDB supports auto-downloading debuginfo from the following URLs: [03:44:47.818] [03:44:47.818] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:44:47.818] Debuginfod has been disabled. [03:44:47.818] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:44:47.922] [Thread debugging using libthread_db enabled] [03:44:47.922] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:44:47.922] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:44:47.922] Program terminated with signal SIGABRT, Aborted. [03:44:47.922] #0 0x00007fca52ca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:48.856] [03:44:48.856] Thread 1 (Thread 0x7fca52bd8f00 (LWP 36519)): [03:44:48.856] #0 0x00007fca52ca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:48.856] No symbol table info available. [03:44:48.856] #1 0x00007fca52c5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:48.856] No symbol table info available. [03:44:48.856] #2 0x00007fca52c45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:48.856] No symbol table info available. [03:44:48.856] #3 0x000055cf7035c20a in ExceptionalCondition (conditionName=conditionName@entry=0x55cf705ced5d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55cf705ce210 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=206) at ../src/backend/utils/error/assert.c:66 [03:44:48.856] No locals. [03:44:48.856] #4 0x000055cf6fce65f6 in standard_ExecutorStart (queryDesc=0x55cf719992f0, eflags=0) at ../src/backend/executor/execMain.c:206 [03:44:48.856] estate = 0x55cf718c11c0 [03:44:48.856] oldcontext = 0x55cf7199f1f0 [03:44:48.856] __func__ = "standard_ExecutorStart" [03:44:48.856] #5 0x00007fca503616f7 in pgss_ExecutorStart (queryDesc=0x55cf719992f0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [03:44:48.856] No locals. [03:44:48.856] #6 0x000055cf6fce678b in ExecutorStart (queryDesc=queryDesc@entry=0x55cf719992f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:145 [03:44:48.856] No locals. [03:44:48.856] #7 0x000055cf6fc0c890 in refresh_matview_datafill (dest=0x55cf71943bf8, query=, query@entry=0x55cf718cf4e0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:44:48.856] rewritten = [03:44:48.856] plan = 0x55cf719987f8 [03:44:48.856] queryDesc = 0x55cf719992f0 [03:44:48.856] copied_query = [03:44:48.856] processed = [03:44:48.856] __func__ = "refresh_matview_datafill" [03:44:48.856] #8 0x000055cf6fc0ebf7 in RefreshMatViewByOid (matviewOid=27325, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:44:48.856] dest = [03:44:48.856] matviewRel = 0x7fca4e6c6b88 [03:44:48.856] rule = [03:44:48.856] actions = [03:44:48.856] dataQuery = 0x55cf718cf4e0 [03:44:48.856] tableSpace = [03:44:48.856] relowner = 10 [03:44:48.856] OIDNewHeap = 27335 [03:44:48.856] processed = 0 [03:44:48.856] relpersistence = 112 'p' [03:44:48.856] save_userid = 10 [03:44:48.856] save_sec_context = 0 [03:44:48.856] save_nestlevel = 2 [03:44:48.856] address = {classId = 0, objectId = 0, objectSubId = 0} [03:44:48.856] __func__ = "RefreshMatViewByOid" [03:44:48.856] #9 0x000055cf6fc0ed36 in ExecRefreshMatView (stmt=0x55cf71913c70, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:44:48.856] matviewOid = [03:44:48.856] lockmode = [03:44:48.856] #10 0x000055cf6fbc56b1 in ExecCreateTableAs (pstate=pstate@entry=0x55cf7199f2f0, stmt=stmt@entry=0x55cf717b0790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd6b7dfdd0) at ../src/backend/commands/createas.c:350 [03:44:48.856] refresh = [03:44:48.856] query = 0x55cf717b0950 [03:44:48.856] into = 0x55cf717b04e8 [03:44:48.856] is_matview = true [03:44:48.856] do_refresh = false [03:44:48.856] dest = [03:44:48.856] address = {classId = 1259, objectId = 27325, objectSubId = 0} [03:44:48.856] __func__ = "ExecCreateTableAs" [03:44:48.856] #11 0x000055cf700d6408 in ProcessUtilitySlow (pstate=pstate@entry=0x55cf7199f2f0, pstmt=pstmt@entry=0x55cf717b0840, queryString=queryString@entry=0x55cf717afa50 "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=0x55cf717b17e8, qc=0x7ffd6b7dfdd0) at ../src/backend/tcop/utility.c:1675 [03:44:48.856] _save_exception_stack = 0x7ffd6b7df980 [03:44:48.856] _save_context_stack = 0x0 [03:44:48.856] _local_sigjmp_buf = {{__jmpbuf = {0, 3455245722842387956, 94349450479504, 0, 94349450476112, 0, 8905669940197283316, 3455243057947825652}, __mask_was_saved = 0, __saved_mask = {__val = {94349425940866, 0, 0, 94349431997568, 94349426193533, 140506879110144, 1, 16777216, 0, 112, 94349425941138, 140506879590400, 140506879590400, 0, 0, 140506879110144}}}} [03:44:48.856] _do_rethrow = false [03:44:48.856] parsetree = 0x55cf717b0790 [03:44:48.856] isTopLevel = true [03:44:48.856] isCompleteQuery = true [03:44:48.856] needCleanup = false [03:44:48.856] commandCollected = false [03:44:48.856] address = {classId = 21967, objectId = 1903888272, objectSubId = 21967} [03:44:48.856] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:44:48.856] __func__ = "ProcessUtilitySlow" [03:44:48.856] #12 0x000055cf700d4a19 in standard_ProcessUtility (pstmt=pstmt@entry=0x55cf717b0840, queryString=queryString@entry=0x55cf717afa50 "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=0x55cf717b17e8, qc=0x7ffd6b7dfdd0) at ../src/backend/tcop/utility.c:1067 [03:44:48.856] parsetree = 0x55cf717b0790 [03:44:48.856] isTopLevel = true [03:44:48.856] isAtomicContext = false [03:44:48.856] pstate = 0x55cf7199f2f0 [03:44:48.856] readonly_flags = [03:44:48.856] __func__ = "standard_ProcessUtility" [03:44:48.856] #13 0x00007fca50364d4a in pgss_ProcessUtility (pstmt=0x55cf717b0840, queryString=0x55cf717afa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55cf717b17e8, qc=0x7ffd6b7dfdd0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [03:44:48.856] _save_exception_stack = 0x7ffd6b7dfc90 [03:44:48.856] _save_context_stack = 0x0 [03:44:48.856] _local_sigjmp_buf = {{__jmpbuf = {0, -8904287871100955148, 94349450479680, 94349450483688, 140726406872528, 0, 8905669940302140916, 8933238642975921652}, __mask_was_saved = 0, __saved_mask = {__val = {94349429758737, 140726406871798, 140726406871796, 0, 0, 0, 206158430232, 140726406871760, 94349429758954, 350, 206158430232, 94349450480480, 140726406871856, 0, 94349424601440, 94349450475856}}}} [03:44:48.856] _do_rethrow = false [03:44:48.856] duration = [03:44:48.856] bufusage = {shared_blks_hit = 94349451597304, shared_blks_read = 889058230272, shared_blks_dirtied = 94349452135192, shared_blks_written = 94349422937131, local_blks_hit = 94349451596808, local_blks_read = 94349451596224, local_blks_dirtied = 94349422936240, local_blks_written = 94349422488687, temp_blks_read = 94349451596808, temp_blks_written = 94349422460004, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94349429752189}, local_blk_read_time = {ticks = 140506948275640}, local_blk_write_time = {ticks = 94349450476112}, temp_blk_read_time = {ticks = 94349432066021}, temp_blk_write_time = {ticks = 94349441998818}} [03:44:48.856] walusage_start = {wal_records = 8939, wal_fpi = 141, wal_bytes = 1250440} [03:44:48.856] start = [03:44:48.856] rows = [03:44:48.856] bufusage_start = {shared_blks_hit = 33523, shared_blks_read = 3607, shared_blks_dirtied = 1526, shared_blks_written = 1064, 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}} [03:44:48.856] walusage = {wal_records = 0, wal_fpi = 889058230272, wal_bytes = 94349451599240} [03:44:48.856] parsetree = [03:44:48.856] saved_queryId = 6041762721901209185 [03:44:48.856] saved_stmt_location = 0 [03:44:48.856] saved_stmt_len = 69 [03:44:48.856] enabled = true [03:44:48.856] #14 0x000055cf700d4abf in ProcessUtility (pstmt=pstmt@entry=0x55cf717b0840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55cf717b17e8, qc=0x7ffd6b7dfdd0) at ../src/backend/tcop/utility.c:519 [03:44:48.856] No locals. [03:44:48.856] #15 0x000055cf700d03e0 in PortalRunUtility (portal=portal@entry=0x55cf71830f90, pstmt=pstmt@entry=0x55cf717b0840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55cf717b17e8, qc=qc@entry=0x7ffd6b7dfdd0) at ../src/backend/tcop/pquery.c:1158 [03:44:48.856] No locals. [03:44:48.856] #16 0x000055cf700d0985 in PortalRunMulti (portal=portal@entry=0x55cf71830f90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55cf717b17e8, altdest=altdest@entry=0x55cf717b17e8, qc=qc@entry=0x7ffd6b7dfdd0) at ../src/backend/tcop/pquery.c:1316 [03:44:48.856] pstmt = 0x55cf717b0840 [03:44:48.856] stmtlist_item__state = [03:44:48.856] active_snapshot_set = false [03:44:48.856] stmtlist_item = 0x55cf717b17b0 [03:44:48.856] #17 0x000055cf700d0f58 in PortalRun (portal=portal@entry=0x55cf71830f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55cf717b17e8, altdest=altdest@entry=0x55cf717b17e8, qc=0x7ffd6b7dfdd0) at ../src/backend/tcop/pquery.c:791 [03:44:48.856] _save_exception_stack = 0x7ffd6b7dfe80 [03:44:48.856] _save_context_stack = 0x0 [03:44:48.856] _local_sigjmp_buf = {{__jmpbuf = {0, 3455245722795202036, 94349451005840, 94349450479624, 94349451005840, 94349450479552, 8905669939947722228, 3455243060139218420}, __mask_was_saved = 0, __saved_mask = {__val = {94349429436850, 94349450475856, 112, 4, 94349429441267, 1803418975, 4, 94349450479552, 112, 73, 94349451005840, 94349450479624, 94349450479600, 94349450479552, 94349429528470, 1}}}} [03:44:48.856] _do_rethrow = [03:44:48.856] result = [03:44:48.856] nprocessed = [03:44:48.856] saveTopTransactionResourceOwner = 0x55cf717f0468 [03:44:48.856] saveTopTransactionContext = 0x55cf718433c0 [03:44:48.856] saveActivePortal = 0x0 [03:44:48.856] saveResourceOwner = 0x55cf717f0468 [03:44:48.856] savePortalContext = 0x0 [03:44:48.856] saveMemoryContext = 0x55cf718433c0 [03:44:48.856] __func__ = "PortalRun" [03:44:48.856] #18 0x000055cf700ca344 in exec_simple_query (query_string=query_string@entry=0x55cf717afa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:44:48.856] cmdtaglen = 24 [03:44:48.856] snapshot_set = [03:44:48.856] per_parsetree_context = 0x0 [03:44:48.856] plantree_list = 0x55cf717b1798 [03:44:48.856] parsetree = 0x55cf717b07c0 [03:44:48.856] commandTag = [03:44:48.856] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:44:48.856] querytree_list = [03:44:48.856] portal = 0x55cf71830f90 [03:44:48.856] receiver = 0x55cf717b17e8 [03:44:48.856] format = 0 [03:44:48.856] cmdtagname = [03:44:48.856] parsetree_item__state = [03:44:48.856] dest = DestRemote [03:44:48.856] oldcontext = 0x55cf718433c0 [03:44:48.856] parsetree_list = 0x55cf717b07f0 [03:44:48.856] parsetree_item = 0x55cf717b0808 [03:44:48.856] save_log_statement_stats = false [03:44:48.856] was_logged = true [03:44:48.856] use_implicit_block = false [03:44:48.856] msec_str = "0\000~k\375\177\000\000\270\0378p\317U\000\000`\376}k\375\177\000\000G\000\000\000\000\000\000" [03:44:48.856] __func__ = "exec_simple_query" [03:44:48.856] #19 0x000055cf700cd0c8 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [03:44:48.856] query_string = 0x55cf717afa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:44:48.856] firstchar = [03:44:48.856] input_message = {data = 0x55cf717afa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:44:48.856] local_sigjmp_buf = {{__jmpbuf = {94349442007384, 3455242400991368692, 4, 140726406873136, 140726406873280, 140726406873284, 8905669940019025396, 3455243062086817268}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94349450725696, 0, 168, 94349429441369, 0, 10, 2, 94349442007392, 94349450206704, 94349442001472, 140726406873136, 140726406873280, 140726406873284}}}} [03:44:48.856] send_ready_for_query = false [03:44:48.856] idle_in_transaction_timeout_enabled = false [03:44:48.856] idle_session_timeout_enabled = false [03:44:48.856] __func__ = "PostgresMain" [03:44:48.856] #20 0x000055cf700c2f3f in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:44:48.856] bsdata = [03:44:48.856] #21 0x000055cf6ff7a8de in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd6b7dffdc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd6b7e0030) at ../src/backend/postmaster/launch_backend.c:274 [03:44:48.856] pid = [03:44:48.856] #22 0x000055cf6ff80392 in BackendStartup (client_sock=client_sock@entry=0x7ffd6b7e0030) at ../src/backend/postmaster/postmaster.c:3420 [03:44:48.856] bn = 0x55cf717dc748 [03:44:48.856] pid = [03:44:48.856] startup_data = {canAcceptConnections = CAC_OK} [03:44:48.856] __func__ = "BackendStartup" [03:44:48.856] #23 0x000055cf6ff808f4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [03:44:48.856] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\302R\312\177\000\000\364\000~k\375\177\000\000\312\360VT\312\177\000\000>\004\000\000\000\000\000\000\260\227\303R\312\177\000\000\240\017\031T\312\177\000\000\370\000~k\375\177\000\000\364\000~k\375\177\000\000\000\000\000\000\000\000\000\000\220\000~k\375\177\000\000\376\377\023o\317U\000\000\230\347\017o\317U\000\000\300\001~k\375\177\000\000\270\001~k\375\177\000\000\225[\362\001\000\000\000", __ss_align = 94349450648176}, salen = 2}} [03:44:48.856] i = 0 [03:44:48.856] now = [03:44:48.856] last_lockfile_recheck_time = 1727754087 [03:44:48.856] last_touch_time = 1727754087 [03:44:48.856] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7fca545992e0}, {pos = 1803419960, events = 0, fd = 0, user_data = 0x7fca54599668}, {pos = 1863581694, events = 21967, fd = 1415157352, user_data = 0x7fca53438630}, {pos = 1415156448, events = 32714, fd = 2090263927, user_data = 0x7ffd6b7e0240}, {pos = 1414986312, events = 32714, fd = 15, user_data = 0x7fca53438630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1415156448, events = 32714, fd = 1803420088, user_data = 0x7ffd6b7e01c0}, {pos = 1415157352, events = 32714, fd = 0, user_data = 0x55cf717db308}, {pos = 1904062952, events = 21967, fd = 1904081041, user_data = 0x7fca00000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7fca52c2e020}, {pos = 1410928544, events = 32714, fd = 1904063240, user_data = 0x7ffd6b7e05b0}, {pos = 1904081208, events = 21967, fd = 1904083136, user_data = 0x55cf717db308}, {pos = 1415156448, events = 32714, fd = 438, user_data = 0x55cf708fadb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55cf717b1890}, {pos = 1415012030, events = 32714, fd = 1, user_data = 0x0}, {pos = 1388503072, events = 32714, fd = 1389309376, user_data = 0x7ffd6b7e0620}, {pos = 1803421184, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1415020986, user_data = 0x0}, {pos = 1389030692, events = 32714, fd = 0, user_data = 0x55cf70f8cae0 }, {pos = 2, events = 0, fd = 7, user_data = 0x55cf71771e90}, {pos = 0, events = 0, fd = 1388537032, user_data = 0x7fca52c9c880 }, {pos = 1388154296, events = 32714, fd = 8096, user_data = 0x100007f00000002}, {pos = 1389064173, events = 32714, fd = 2, user_data = 0x55cf717e4900}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 1390353504, events = 32714, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55cf71771e90}, {pos = 1389066762, events = 32714, fd = 1769300525, user_data = 0x55cf71771e90}, {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 = 0x3139352f0a202020}, {pos = 1180911370, events = 1248217955, fd = 0, user_data = 0x0}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 1396938048, user_data = 0x7fca53439a80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xfadf673a7802a300}, {pos = 1390339552, events = 32714, fd = -328, user_data = 0x0}, {pos = 1904062632, events = 21967, fd = 1024, user_data = 0x55cf717db0a8}, {pos = 1803421368, events = 32765, fd = 1389067935, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 32903, events = 0, fd = -328, user_data = 0x0}, {pos = 1903892624, events = 21967, fd = 1389309907, user_data = 0x7ffd6b7e06b8}, {pos = 1882928934, events = 21967, fd = 1895416080, user_data = 0x55cf703a21e3 }, {pos = 1904062432, events = 21967, fd = 1903884624, user_data = 0x55cf717dafe0}, {pos = 1389058110, events = 32714, fd = 0, user_data = 0x55cf703b3e4d }, {pos = 1904062432, events = 1, fd = 1882931094, user_data = 0x55cf717af950}, {pos = 2013438720, events = 4208944954, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1388980913, user_data = 0x7fca52ca14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2013438720, user_data = 0x55cf71787080}, {pos = 2013438720, events = 4208944954, fd = 11, user_data = 0xfadf673a7802a300}, {pos = 0, events = 0, fd = 1388687929, user_data = 0x1}, {pos = 1878500827, events = 21967, fd = 4194304, user_data = 0x55cf703a2077 }, {pos = 1903718528, events = 21967, fd = 1903884624, user_data = 0x55cf71787080}, {pos = 1, events = 0, fd = 0, user_data = 0x55cf703b3e4d }, {pos = 1903718528, events = 21967, fd = 1882931094, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55cf6fdaffa9 }, {pos = 0, events = 0, fd = 1876644585, user_data = 0xb}, {pos = 1878521984, events = 21967, fd = 1891813552, user_data = 0x55cf717b0308}} [03:44:48.856] nevents = 1 [03:44:48.856] __func__ = "ServerLoop" [03:44:48.856] #24 0x000055cf6ff82077 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55cf7176dcf0) at ../src/backend/postmaster/postmaster.c:1351 [03:44:48.856] opt = [03:44:48.856] status = [03:44:48.856] userDoption = [03:44:48.856] listen_addr_saved = false [03:44:48.856] output_config_variable = [03:44:48.856] __func__ = "PostmasterMain" [03:44:48.856] #25 0x000055cf6fdc0385 in main (argc=4, argv=0x55cf7176dcf0) at ../src/backend/main/main.c:197 [03:44:48.856] do_check_root = [03:44:48.893] -e [03:44:48.893] [03:44:48.893] [03:44:48.956] dumping /tmp/cores/postgres-6-29400.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:44:49.205] [New LWP 29400] [03:44:49.205] [03:44:49.205] This GDB supports auto-downloading debuginfo from the following URLs: [03:44:49.205] [03:44:49.205] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:44:49.205] Debuginfod has been disabled. [03:44:49.205] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:44:49.307] [Thread debugging using libthread_db enabled] [03:44:49.307] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:44:49.307] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:44:49.307] Program terminated with signal SIGABRT, Aborted. [03:44:49.307] #0 0x00007fde298a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:50.228] [03:44:50.228] Thread 1 (Thread 0x7fde2a039f00 (LWP 29400)): [03:44:50.228] #0 0x00007fde298a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:50.228] No symbol table info available. [03:44:50.228] #1 0x00007fde2985afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:50.228] No symbol table info available. [03:44:50.228] #2 0x00007fde29845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:50.228] No symbol table info available. [03:44:50.228] #3 0x000055fa769d120a in ExceptionalCondition (conditionName=conditionName@entry=0x55fa76c43d5d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55fa76c43210 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=206) at ../src/backend/utils/error/assert.c:66 [03:44:50.228] No locals. [03:44:50.228] #4 0x000055fa7635b5f6 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55fa779f7050, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:206 [03:44:50.228] estate = 0x55fa778ced80 [03:44:50.228] oldcontext = 0x55fa77a2dc90 [03:44:50.228] __func__ = "standard_ExecutorStart" [03:44:50.228] #5 0x000055fa7635b7d2 in ExecutorStart (queryDesc=queryDesc@entry=0x55fa779f7050, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:147 [03:44:50.228] No locals. [03:44:50.228] #6 0x000055fa76281890 in refresh_matview_datafill (dest=0x55fa77a02f28, query=, query@entry=0x55fa77a45910, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:44:50.228] rewritten = [03:44:50.228] plan = 0x55fa779f6478 [03:44:50.228] queryDesc = 0x55fa779f7050 [03:44:50.228] copied_query = [03:44:50.228] processed = [03:44:50.228] __func__ = "refresh_matview_datafill" [03:44:50.228] #7 0x000055fa76283bf7 in RefreshMatViewByOid (matviewOid=27436, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:44:50.228] dest = [03:44:50.228] matviewRel = 0x7fde1dec6a58 [03:44:50.228] rule = [03:44:50.228] actions = [03:44:50.228] dataQuery = 0x55fa77a45910 [03:44:50.228] tableSpace = [03:44:50.228] relowner = 10 [03:44:50.228] OIDNewHeap = 27453 [03:44:50.228] processed = 0 [03:44:50.228] relpersistence = 112 'p' [03:44:50.228] save_userid = 10 [03:44:50.228] save_sec_context = 0 [03:44:50.228] save_nestlevel = 2 [03:44:50.228] address = {classId = 0, objectId = 0, objectSubId = 0} [03:44:50.228] __func__ = "RefreshMatViewByOid" [03:44:50.228] #8 0x000055fa76283d36 in ExecRefreshMatView (stmt=0x55fa779ebc30, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:44:50.228] matviewOid = [03:44:50.228] lockmode = [03:44:50.228] #9 0x000055fa7623a6b1 in ExecCreateTableAs (pstate=pstate@entry=0x55fa77a2dd90, stmt=stmt@entry=0x55fa7789c7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd1b0b6ea0) at ../src/backend/commands/createas.c:350 [03:44:50.228] refresh = [03:44:50.228] query = 0x55fa7789c9b0 [03:44:50.228] into = 0x55fa7789c548 [03:44:50.228] is_matview = true [03:44:50.228] do_refresh = false [03:44:50.228] dest = [03:44:50.228] address = {classId = 1259, objectId = 27436, objectSubId = 0} [03:44:50.228] __func__ = "ExecCreateTableAs" [03:44:50.228] #10 0x000055fa7674b408 in ProcessUtilitySlow (pstate=pstate@entry=0x55fa77a2dd90, pstmt=pstmt@entry=0x55fa7789c8a0, queryString=queryString@entry=0x55fa7789bab0 "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=0x55fa7789d2d8, qc=0x7ffd1b0b6ea0) at ../src/backend/tcop/utility.c:1675 [03:44:50.228] _save_exception_stack = 0x7ffd1b0b6d60 [03:44:50.228] _save_context_stack = 0x0 [03:44:50.228] _local_sigjmp_buf = {{__jmpbuf = {0, -289529750628716894, 94534235703280, 0, 94534235699888, 0, -5767497879010791774, -289530259207475550}, __mask_was_saved = 0, __saved_mask = {__val = {4294978063, 140591969986304, 94534216959939, 1, 46245918603064, 1, 10767, 140591969986304, 140591969986304, 1, 94534216969968, 94534235911992, 10630746925302099968, 140591969986304, 140591969986304, 10767}}}} [03:44:50.228] _do_rethrow = false [03:44:50.228] parsetree = 0x55fa7789c7f0 [03:44:50.228] isTopLevel = true [03:44:50.228] isCompleteQuery = true [03:44:50.228] needCleanup = false [03:44:50.228] commandCollected = false [03:44:50.228] address = {classId = 22010, objectId = 2005518320, objectSubId = 22010} [03:44:50.228] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:44:50.228] __func__ = "ProcessUtilitySlow" [03:44:50.228] #11 0x000055fa76749a19 in standard_ProcessUtility (pstmt=0x55fa7789c8a0, queryString=0x55fa7789bab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55fa7789d2d8, qc=0x7ffd1b0b6ea0) at ../src/backend/tcop/utility.c:1067 [03:44:50.228] parsetree = 0x55fa7789c7f0 [03:44:50.228] isTopLevel = true [03:44:50.228] isAtomicContext = false [03:44:50.228] pstate = 0x55fa77a2dd90 [03:44:50.228] readonly_flags = [03:44:50.228] __func__ = "standard_ProcessUtility" [03:44:50.228] #12 0x000055fa76749b74 in ProcessUtility (pstmt=pstmt@entry=0x55fa7789c8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55fa7789d2d8, qc=0x7ffd1b0b6ea0) at ../src/backend/tcop/utility.c:523 [03:44:50.228] No locals. [03:44:50.228] #13 0x000055fa767453e0 in PortalRunUtility (portal=portal@entry=0x55fa7791e050, pstmt=pstmt@entry=0x55fa7789c8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55fa7789d2d8, qc=qc@entry=0x7ffd1b0b6ea0) at ../src/backend/tcop/pquery.c:1158 [03:44:50.228] No locals. [03:44:50.228] #14 0x000055fa76745985 in PortalRunMulti (portal=portal@entry=0x55fa7791e050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55fa7789d2d8, altdest=altdest@entry=0x55fa7789d2d8, qc=qc@entry=0x7ffd1b0b6ea0) at ../src/backend/tcop/pquery.c:1316 [03:44:50.228] pstmt = 0x55fa7789c8a0 [03:44:50.228] stmtlist_item__state = [03:44:50.228] active_snapshot_set = false [03:44:50.228] stmtlist_item = 0x55fa7789d2a0 [03:44:50.228] #15 0x000055fa76745f58 in PortalRun (portal=portal@entry=0x55fa7791e050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55fa7789d2d8, altdest=altdest@entry=0x55fa7789d2d8, qc=0x7ffd1b0b6ea0) at ../src/backend/tcop/pquery.c:791 [03:44:50.228] _save_exception_stack = 0x7ffd1b0b6f50 [03:44:50.228] _save_context_stack = 0x0 [03:44:50.228] _local_sigjmp_buf = {{__jmpbuf = {0, -289529749902053726, 94534236233808, 94534235703400, 94534236233808, 94534235703328, -5767497879165981022, -289530261399392606}, __mask_was_saved = 0, __saved_mask = {__val = {94534220464562, 94534235699632, 112, 4, 94534220468979, 453733935, 4, 94534235703328, 112, 73, 94534236233808, 94534235703400, 94534235703376, 94534235703328, 94534220556182, 1}}}} [03:44:50.228] _do_rethrow = [03:44:50.228] result = [03:44:50.228] nprocessed = [03:44:50.228] saveTopTransactionResourceOwner = 0x55fa778dad08 [03:44:50.228] saveTopTransactionContext = 0x55fa7792fc60 [03:44:50.228] saveActivePortal = 0x0 [03:44:50.228] saveResourceOwner = 0x55fa778dad08 [03:44:50.228] savePortalContext = 0x0 [03:44:50.228] saveMemoryContext = 0x55fa7792fc60 [03:44:50.228] __func__ = "PortalRun" [03:44:50.228] #16 0x000055fa7673f344 in exec_simple_query (query_string=query_string@entry=0x55fa7789bab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:44:50.228] cmdtaglen = 24 [03:44:50.228] snapshot_set = [03:44:50.228] per_parsetree_context = 0x0 [03:44:50.228] plantree_list = 0x55fa7789d288 [03:44:50.228] parsetree = 0x55fa7789c820 [03:44:50.228] commandTag = [03:44:50.228] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:44:50.228] querytree_list = [03:44:50.228] portal = 0x55fa7791e050 [03:44:50.228] receiver = 0x55fa7789d2d8 [03:44:50.228] format = 0 [03:44:50.228] cmdtagname = [03:44:50.228] parsetree_item__state = [03:44:50.228] dest = DestRemote [03:44:50.228] oldcontext = 0x55fa7792fc60 [03:44:50.228] parsetree_list = 0x55fa7789c850 [03:44:50.228] parsetree_item = 0x55fa7789c868 [03:44:50.228] save_log_statement_stats = false [03:44:50.228] was_logged = false [03:44:50.228] use_implicit_block = false [03:44:50.228] msec_str = "\000q\v\033\375\177\000\000\270o\237v\372U\000\0000o\v\033\375\177\000\000G\000\000\000\000\000\000" [03:44:50.228] __func__ = "exec_simple_query" [03:44:50.228] #17 0x000055fa767420c8 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [03:44:50.228] query_string = 0x55fa7789bab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:44:50.228] firstchar = [03:44:50.228] input_message = {data = 0x55fa7789bab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:44:50.228] local_sigjmp_buf = {{__jmpbuf = {94534233035096, -289527900831600990, 4, 140725057188096, 140725057188240, 140725057188244, -5767497879212118366, -289530263338602846}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94534235430352, 15616, 94534233029184, 94534235954368, 140725057188240, 94534220468527, 0, 9, 2, 94534233035104, 94534235430352, 94534233029184, 140725057188096, 140725057188240, 140725057188244}}}} [03:44:50.228] send_ready_for_query = false [03:44:50.228] idle_in_transaction_timeout_enabled = false [03:44:50.228] idle_session_timeout_enabled = false [03:44:50.228] __func__ = "PostgresMain" [03:44:50.228] #18 0x000055fa76737f3f in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:44:50.228] bsdata = [03:44:50.228] #19 0x000055fa765ef8de in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd1b0b70ac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd1b0b7100) at ../src/backend/postmaster/launch_backend.c:274 [03:44:50.228] pid = [03:44:50.228] #20 0x000055fa765f5392 in BackendStartup (client_sock=client_sock@entry=0x7ffd1b0b7100) at ../src/backend/postmaster/postmaster.c:3420 [03:44:50.228] bn = 0x55fa778c4398 [03:44:50.228] pid = [03:44:50.228] startup_data = {canAcceptConnections = CAC_OK} [03:44:50.228] __func__ = "BackendStartup" [03:44:50.228] #21 0x000055fa765f58f4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [03:44:50.228] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "$+\336\177\000\000>\004\000\000\000\000\000\000\260\227\203)\336\177\000\000\240\357\333*\336\177\000\000\270q\v\033\375\177\000\000\264q\v\033\375\177", '\000' , "\376O{u\372U\000\000\2307wu\372U\000\000\200r\v\033\375\177\000\000xr\v\033\375\177\000\000\225[\362\001\223\374\200\226\2404i*\336\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [03:44:50.228] i = 0 [03:44:50.228] now = [03:44:50.228] last_lockfile_recheck_time = 1727754051 [03:44:50.228] last_touch_time = 1727754051 [03:44:50.228] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 453735104, user_data = 0x0}, {pos = 15, events = 0, fd = 1971015678, user_data = 0x7fde2b270668}, {pos = 711538224, events = 32734, fd = 723976928, user_data = 0x7c96e577}, {pos = 453735168, events = 32765, fd = 723806792, user_data = 0xf}, {pos = 711538224, events = 32734, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 723976928, user_data = 0x7ffd1b0b7278}, {pos = 453735040, events = 32765, fd = 723977832, user_data = 0x0}, {pos = 2005522608, events = 22010, fd = 697232613, user_data = 0x7ffd1b0b7793}, {pos = 1, events = 0, fd = 453735040, user_data = 0xffffffff}, {pos = 696442912, events = 32734, fd = 719056800, user_data = 0x55fa778c8748}, {pos = 2005698088, events = 22010, fd = 2005706817, user_data = 0x7fde2b24cebe}, {pos = 1, events = 0, fd = 723976928, user_data = 0x1b6}, {pos = 1995898288, events = 22010, fd = 0, user_data = 0x1}, {pos = 2005515120, events = 22010, fd = 723832510, user_data = 0x1}, {pos = 0, events = 0, fd = 696442912, user_data = 0x7fde298f2dc0 }, {pos = 16, events = 0, fd = 453736144, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fde2b24f1ba}, {pos = 0, events = 0, fd = 696970532, user_data = 0x0}, {pos = 2002787040, events = 22010, fd = 2, user_data = 0x7}, {pos = 2005261936, events = 22010, fd = 1952410737, user_data = 0x169}, {pos = 1995897672, events = 22010, fd = 8, user_data = 0x2ffff00001fa0}, {pos = 2005515120, events = 22010, fd = 723832510, user_data = 0x1}, {pos = 697004013, events = 32734, fd = 696476872, user_data = 0x55fa778c7410}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 698293344, events = 32734, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55fa7785de70}, {pos = 697006602, events = 32734, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1196587364, fd = 168452721, user_data = 0x37373237310a6174}, {pos = 892351541, events = 808716849, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 698276320, events = 32734, fd = 696914286, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x9680fc938549ba00}, {pos = 698279392, events = 32734, fd = -328, user_data = 0x0}, {pos = 2005697768, events = 22010, fd = 1024, user_data = 0x55fa778c84e8}, {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 = 25785, events = 0, fd = -328, user_data = 0x0}, {pos = 2005515120, events = 22010, fd = 697249747, user_data = 0x7ffd1b0b7788}, {pos = 1990362918, events = 22010, fd = 2002850064, user_data = 0x55fa76a171e3 }, {pos = 2005697568, events = 22010, fd = 2005514672, user_data = 0x55fa778c8420}, {pos = 696997950, events = 32734, fd = 0, user_data = 0x55fa76a28e4d }, {pos = 2005697568, events = 1, fd = 1990365078, user_data = 0x55fa7789b9b0}, {pos = -2058765824, events = 2525035667, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 696920753, user_data = 0x7fde298a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2058765824, user_data = 0x55fa778730e0}, {pos = -2058765824, events = 2525035667, fd = 11, user_data = 0x9680fc938549ba00}, {pos = 0, events = 0, fd = 696627769, user_data = 0x1}, {pos = 1985934811, events = 22010, fd = 4194304, user_data = 0x55fa76a17077 }, {pos = 2005348576, events = 22010, fd = 2005514672, user_data = 0x55fa778730e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55fa76a28e4d }, {pos = 2005348576, events = 22010, fd = 1990365078, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55fa76424fa9 }, {pos = 0, events = 0, fd = 1984078569, user_data = 0xb}, {pos = 1985955968, events = 22010, fd = 1999247536, user_data = 0x55fa7789c388}} [03:44:50.229] nevents = 1 [03:44:50.229] __func__ = "ServerLoop" [03:44:50.229] #22 0x000055fa765f7077 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55fa77859d30) at ../src/backend/postmaster/postmaster.c:1351 [03:44:50.229] opt = [03:44:50.229] status = [03:44:50.229] userDoption = [03:44:50.229] listen_addr_saved = false [03:44:50.229] output_config_variable = [03:44:50.229] __func__ = "PostmasterMain" [03:44:50.229] #23 0x000055fa76435385 in main (argc=8, argv=0x55fa77859d30) at ../src/backend/main/main.c:197 [03:44:50.229] do_check_root =