[11:59:49.564] src/tools/ci/cores_backtrace.sh linux /tmp/cores [11:59:49.777] dumping /tmp/cores/postgres-6-36548.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [11:59:50.036] [New LWP 36548] [11:59:50.036] [11:59:50.036] This GDB supports auto-downloading debuginfo from the following URLs: [11:59:50.036] [11:59:50.036] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [11:59:50.036] Debuginfod has been disabled. [11:59:50.036] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [11:59:50.175] [Thread debugging using libthread_db enabled] [11:59:50.175] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [11:59:50.175] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [11:59:50.175] Program terminated with signal SIGABRT, Aborted. [11:59:50.175] #0 0x00007fd5114a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:51.098] [11:59:51.098] Thread 1 (Thread 0x7fd50f41ff00 (LWP 36548)): [11:59:51.098] #0 0x00007fd5114a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:51.098] No symbol table info available. [11:59:51.098] #1 0x00007fd51145afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:51.098] No symbol table info available. [11:59:51.098] #2 0x00007fd511445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:51.098] No symbol table info available. [11:59:51.098] #3 0x000055de6f002546 in ExceptionalCondition (conditionName=conditionName@entry=0x55de6f2734c5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55de6f272a30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [11:59:51.098] No locals. [11:59:51.098] #4 0x000055de6e990247 in standard_ExecutorStart (queryDesc=0x55de71a287a0, eflags=0) at ../src/backend/executor/execMain.c:191 [11:59:51.098] estate = 0x55de719a3e30 [11:59:51.098] oldcontext = 0x55de719fba40 [11:59:51.098] __func__ = "standard_ExecutorStart" [11:59:51.098] #5 0x00007fd50eb396f7 in pgss_ExecutorStart (queryDesc=0x55de71a287a0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [11:59:51.098] No locals. [11:59:51.098] #6 0x000055de6e9903dc in ExecutorStart (queryDesc=queryDesc@entry=0x55de71a287a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:130 [11:59:51.098] No locals. [11:59:51.098] #7 0x000055de6e8b742a in refresh_matview_datafill (dest=0x55de719f1ea8, query=, query@entry=0x55de719ace30, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [11:59:51.098] rewritten = [11:59:51.098] plan = 0x55de71a27cd8 [11:59:51.098] queryDesc = 0x55de71a287a0 [11:59:51.098] copied_query = [11:59:51.098] processed = [11:59:51.098] __func__ = "refresh_matview_datafill" [11:59:51.098] #8 0x000055de6e8b9791 in RefreshMatViewByOid (matviewOid=27315, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [11:59:51.098] dest = [11:59:51.098] matviewRel = 0x7fd50cea20c8 [11:59:51.098] rule = [11:59:51.098] actions = [11:59:51.098] dataQuery = 0x55de719ace30 [11:59:51.098] tableSpace = [11:59:51.098] relowner = 10 [11:59:51.098] OIDNewHeap = 27338 [11:59:51.098] processed = 0 [11:59:51.098] relpersistence = 112 'p' [11:59:51.098] save_userid = 10 [11:59:51.098] save_sec_context = 0 [11:59:51.098] save_nestlevel = 2 [11:59:51.098] address = {classId = 0, objectId = 0, objectSubId = 0} [11:59:51.098] __func__ = "RefreshMatViewByOid" [11:59:51.098] #9 0x000055de6e8b98d0 in ExecRefreshMatView (stmt=0x55de719f7380, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [11:59:51.098] matviewOid = [11:59:51.098] lockmode = [11:59:51.098] #10 0x000055de6e871044 in ExecCreateTableAs (pstate=pstate@entry=0x55de719fbb40, stmt=stmt@entry=0x55de7189d790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc15517a90) at ../src/backend/commands/createas.c:350 [11:59:51.098] refresh = [11:59:51.098] query = 0x55de7189d950 [11:59:51.098] into = 0x55de7189d4e8 [11:59:51.098] is_matview = true [11:59:51.098] do_refresh = false [11:59:51.098] dest = [11:59:51.098] address = {classId = 1259, objectId = 27315, objectSubId = 0} [11:59:51.098] __func__ = "ExecCreateTableAs" [11:59:51.098] #11 0x000055de6ed7d43e in ProcessUtilitySlow (pstate=pstate@entry=0x55de719fbb40, pstmt=pstmt@entry=0x55de7189d840, queryString=queryString@entry=0x55de7189ca50 "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=0x55de7189e7e8, qc=0x7ffc15517a90) at ../src/backend/tcop/utility.c:1675 [11:59:51.098] _save_exception_stack = 0x7ffc15517640 [11:59:51.098] _save_context_stack = 0x0 [11:59:51.098] _local_sigjmp_buf = {{__jmpbuf = {0, -6516047418913188266, 94413875959696, 0, 94413875956304, 0, -1020469024498903466, -6516031526302378410}, __mask_was_saved = 0, __saved_mask = {__val = {4, 2, 94413830929427, 357659352, 94413830167205, 0, 0, 94413836208800, 94413830419781, 140553024694976, 1, 16777216, 0, 112, 94413830167477, 140553025134592}}}} [11:59:51.098] _do_rethrow = false [11:59:51.098] parsetree = 0x55de7189d790 [11:59:51.098] isTopLevel = true [11:59:51.098] isCompleteQuery = true [11:59:51.098] needCleanup = false [11:59:51.098] commandCollected = false [11:59:51.098] address = {classId = 21982, objectId = 1904859024, objectSubId = 21982} [11:59:51.098] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [11:59:51.098] __func__ = "ProcessUtilitySlow" [11:59:51.098] #12 0x000055de6ed7ba4f in standard_ProcessUtility (pstmt=pstmt@entry=0x55de7189d840, queryString=queryString@entry=0x55de7189ca50 "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=0x55de7189e7e8, qc=0x7ffc15517a90) at ../src/backend/tcop/utility.c:1067 [11:59:51.098] parsetree = 0x55de7189d790 [11:59:51.098] isTopLevel = true [11:59:51.098] isAtomicContext = false [11:59:51.098] pstate = 0x55de719fbb40 [11:59:51.098] readonly_flags = [11:59:51.098] __func__ = "standard_ProcessUtility" [11:59:51.098] #13 0x00007fd50eb3cd4a in pgss_ProcessUtility (pstmt=0x55de7189d840, queryString=0x55de7189ca50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55de7189e7e8, qc=0x7ffc15517a90) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [11:59:51.098] _save_exception_stack = 0x7ffc15517950 [11:59:51.098] _save_context_stack = 0x0 [11:59:51.098] _local_sigjmp_buf = {{__jmpbuf = {0, 1021959184927954518, 94413875959872, 94413875963880, 140720666147472, 0, -1020469024377268650, -1043525520945441194}, __mask_was_saved = 0, __saved_mask = {__val = {94413833977287, 140720666146742, 140720666146740, 0, 0, 139637976727552, 206158430232, 140720666146704, 94413833977504, 0, 206158430232, 94413875960672, 140720666146800, 0, 94413828830205, 94413875956048}}}} [11:59:51.098] _do_rethrow = false [11:59:51.098] duration = [11:59:51.098] bufusage = {shared_blks_hit = 94413877035624, shared_blks_read = 953482739712, shared_blks_dirtied = 0, shared_blks_written = 94413877035128, local_blks_hit = 94413877035624, local_blks_read = 94413827169304, local_blks_dirtied = 94413877358024, local_blks_written = 94413827169550, temp_blks_read = 94413877035128, temp_blks_written = 94413877034544, shared_blk_read_time = {ticks = 94413827168659}, shared_blk_write_time = {ticks = 94413833970739}, local_blk_read_time = {ticks = 140553060744632}, local_blk_write_time = {ticks = 94413875956304}, temp_blk_read_time = {ticks = 94413836279781}, temp_blk_write_time = {ticks = 94413846189058}} [11:59:51.098] walusage_start = {wal_records = 8916, wal_fpi = 122, wal_bytes = 1199569} [11:59:51.098] start = [11:59:51.098] rows = [11:59:51.098] bufusage_start = {shared_blks_hit = 33700, shared_blks_read = 3459, shared_blks_dirtied = 1427, shared_blks_written = 922, 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}} [11:59:51.098] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 140553024694976} [11:59:51.098] parsetree = [11:59:51.098] saved_queryId = 6041762721901209185 [11:59:51.098] saved_stmt_location = 0 [11:59:51.098] saved_stmt_len = 69 [11:59:51.098] enabled = true [11:59:51.098] #14 0x000055de6ed7baf5 in ProcessUtility (pstmt=pstmt@entry=0x55de7189d840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55de7189e7e8, qc=0x7ffc15517a90) at ../src/backend/tcop/utility.c:519 [11:59:51.098] No locals. [11:59:51.098] #15 0x000055de6ed77416 in PortalRunUtility (portal=portal@entry=0x55de7191df90, pstmt=pstmt@entry=0x55de7189d840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55de7189e7e8, qc=qc@entry=0x7ffc15517a90) at ../src/backend/tcop/pquery.c:1158 [11:59:51.098] No locals. [11:59:51.098] #16 0x000055de6ed779bb in PortalRunMulti (portal=portal@entry=0x55de7191df90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55de7189e7e8, altdest=altdest@entry=0x55de7189e7e8, qc=qc@entry=0x7ffc15517a90) at ../src/backend/tcop/pquery.c:1316 [11:59:51.098] pstmt = 0x55de7189d840 [11:59:51.098] stmtlist_item__state = [11:59:51.098] active_snapshot_set = false [11:59:51.098] stmtlist_item = 0x55de7189e7b0 [11:59:51.098] #17 0x000055de6ed77f8e in PortalRun (portal=portal@entry=0x55de7191df90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55de7189e7e8, altdest=altdest@entry=0x55de7189e7e8, qc=0x7ffc15517a90) at ../src/backend/tcop/pquery.c:791 [11:59:51.098] _save_exception_stack = 0x7ffc15517b40 [11:59:51.098] _save_context_stack = 0x0 [11:59:51.098] _local_sigjmp_buf = {{__jmpbuf = {0, -6516047420000561578, 94413876486032, 94413875959816, 94413876486032, 94413875959744, -1020469024786213290, -6516031532670511530}, __mask_was_saved = 0, __saved_mask = {__val = {94413833655400, 94413875956048, 112, 4, 94413833659817, 357661215, 4, 94413875959744, 112, 73, 94413876486032, 94413875959816, 94413875959792, 94413875959744, 94413833747020, 1}}}} [11:59:51.098] _do_rethrow = [11:59:51.098] result = [11:59:51.098] nprocessed = [11:59:51.098] saveTopTransactionResourceOwner = 0x55de718dd468 [11:59:51.098] saveTopTransactionContext = 0x55de719303c0 [11:59:51.098] saveActivePortal = 0x0 [11:59:51.098] saveResourceOwner = 0x55de718dd468 [11:59:51.098] savePortalContext = 0x0 [11:59:51.098] saveMemoryContext = 0x55de719303c0 [11:59:51.098] __func__ = "PortalRun" [11:59:51.098] #18 0x000055de6ed7162a in exec_simple_query (query_string=query_string@entry=0x55de7189ca50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [11:59:51.098] cmdtaglen = 24 [11:59:51.098] snapshot_set = [11:59:51.098] per_parsetree_context = 0x0 [11:59:51.098] plantree_list = 0x55de7189e798 [11:59:51.098] parsetree = 0x55de7189d7c0 [11:59:51.098] commandTag = [11:59:51.098] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:59:51.098] querytree_list = [11:59:51.098] portal = 0x55de7191df90 [11:59:51.098] receiver = 0x55de7189e7e8 [11:59:51.098] format = 0 [11:59:51.098] cmdtagname = [11:59:51.098] parsetree_item__state = [11:59:51.098] dest = DestRemote [11:59:51.098] oldcontext = 0x55de719303c0 [11:59:51.098] parsetree_list = 0x55de7189d7f0 [11:59:51.098] parsetree_item = 0x55de7189d808 [11:59:51.098] save_log_statement_stats = false [11:59:51.098] was_logged = true [11:59:51.098] use_implicit_block = false [11:59:51.098] msec_str = "\360|Q\025\374\177\000\000n\202\002o\336U\000\000 {Q\025\374\177\000\000G\000\000\000\000\000\000" [11:59:51.098] __func__ = "exec_simple_query" [11:59:51.098] #19 0x000055de6ed74103 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [11:59:51.098] query_string = 0x55de7189ca50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [11:59:51.098] firstchar = [11:59:51.098] input_message = {data = 0x55de7189ca50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [11:59:51.098] local_sigjmp_buf = {{__jmpbuf = {94413846197624, -6516033621943118250, 4, 140720666148080, 140720666148224, 140720666148228, -1020469024698132906, -6516031530734840234}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94413876205888, 0, 168, 94413833659919, 0, 10, 2, 94413846197632, 94413875686896, 94413846191712, 140720666148080, 140720666148224, 140720666148228}}}} [11:59:51.098] send_ready_for_query = false [11:59:51.098] idle_in_transaction_timeout_enabled = false [11:59:51.098] idle_session_timeout_enabled = false [11:59:51.098] __func__ = "PostgresMain" [11:59:51.098] #20 0x000055de6ed6a225 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [11:59:51.098] bsdata = [11:59:51.098] #21 0x000055de6ec22ab6 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc15517c9c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc15517cf0) at ../src/backend/postmaster/launch_backend.c:274 [11:59:51.098] pid = [11:59:51.098] #22 0x000055de6ec28562 in BackendStartup (client_sock=client_sock@entry=0x7ffc15517cf0) at ../src/backend/postmaster/postmaster.c:3415 [11:59:51.098] bn = 0x55de718c92e8 [11:59:51.098] pid = [11:59:51.098] startup_data = {canAcceptConnections = CAC_OK} [11:59:51.098] __func__ = "BackendStartup" [11:59:51.098] #23 0x000055de6ec28ac4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [11:59:51.098] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "B\021\325\177\000\000\264}Q\025\374\177\000\000\312`\322\022\325\177\000\000>\004\000\000\000\000\000\000\260\227C\021\325\177\000\000\240\177\224\022\325\177\000\000\270}Q\025\374\177\000\000\264}Q\025\374\177\000\000\000\000\000\000\000\000\000\000P}Q\025\374\177\000\000\312\035\337m\336U\000\000H\a\333m\336U\000\000\200~Q\025\374\177\000\000x~Q\025\374\177\000\000\225[\362\001\000\000\000", __ss_align = 94413876128368}, salen = 2}} [11:59:51.098] i = 0 [11:59:51.098] now = [11:59:51.098] last_lockfile_recheck_time = 1726401384 [11:59:51.098] last_touch_time = 1726401384 [11:59:51.098] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7fd512d502e0}, {pos = 357662200, events = 0, fd = 0, user_data = 0x7fd512d50668}, {pos = 1843338698, events = 21982, fd = 315950696, user_data = 0x7fd512287630}, {pos = 315949792, events = 32725, fd = 2090263927, user_data = 0x7ffc15517f00}, {pos = 315779656, events = 32725, fd = 15, user_data = 0x7fd512287630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 315949792, events = 32725, fd = 357662328, user_data = 0x7ffc15517e80}, {pos = 315950696, events = 32725, fd = 0, user_data = 0x55de718c8308}, {pos = 1905033704, events = 21982, fd = 1905051793, user_data = 0x7fd500000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7fd51142e020}, {pos = 311721888, events = 32725, fd = 1905033992, user_data = 0x7ffc15518270}, {pos = 1905051960, events = 21982, fd = 1905053888, user_data = 0x55de718c8308}, {pos = 315949792, events = 32725, fd = 438, user_data = 0x55de6f59edb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55de7189e890}, {pos = 315805374, events = 32725, fd = 1, user_data = 0x0}, {pos = 289595424, events = 32725, fd = 290401728, user_data = 0x7ffc155182e0}, {pos = 357663424, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 315814330, user_data = 0x0}, {pos = 290123044, events = 32725, fd = 0, user_data = 0x55de6fc2cf20 }, {pos = 2, events = 0, fd = 7, user_data = 0x55de7185ee90}, {pos = 0, events = 0, fd = 289629384, user_data = 0x7fd51149c880 }, {pos = 255983032, events = 32725, fd = 8096, user_data = 0x100007f00000002}, {pos = 290156525, events = 32725, fd = 2, user_data = 0x55de718d1900}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 291445856, events = 32725, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55de7185ee90}, {pos = 290159114, events = 32725, fd = 1769300525, user_data = 0x55de7185ee90}, {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 = -1, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 311604544, user_data = 0x7fd51292ba80}, {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 = 0x41eda1ef2ba05400}, {pos = 291431904, events = 32725, fd = -328, user_data = 0x0}, {pos = 1905033384, events = 21982, fd = 1024, user_data = 0x55de718c80a8}, {pos = 357663608, events = 32764, fd = 290160287, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 32527, events = 0, fd = -328, user_data = 0x0}, {pos = 1904863376, events = 21982, fd = 290402259, user_data = 0x7ffc15518378}, {pos = 1862638044, events = 21982, fd = 1875096880, user_data = 0x55de6f048499 }, {pos = 1905033184, events = 21982, fd = 1904855376, user_data = 0x55de718c7fe0}, {pos = 290150462, events = 32725, fd = 0, user_data = 0x55de6f05a103 }, {pos = 1905033184, events = 1, fd = 1862640204, user_data = 0x55de7189c950}, {pos = 731927552, events = 1106092527, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 290073265, user_data = 0x7fd5114a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 731927552, user_data = 0x55de71874080}, {pos = 731927552, events = 1106092527, fd = 11, user_data = 0x41eda1ef2ba05400}, {pos = 0, events = 0, fd = 289780281, user_data = 0x1}, {pos = 1858217907, events = 21982, fd = 4194304, user_data = 0x55de6f04832d }, {pos = 1904689280, events = 21982, fd = 1904855376, user_data = 0x55de71874080}, {pos = 1, events = 0, fd = 0, user_data = 0x55de6f05a103 }, {pos = 1904689280, events = 21982, fd = 1862640204, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55de6ea5988c }, {pos = 0, events = 0, fd = 1856367564, user_data = 0xb}, {pos = 1858239056, events = 21982, fd = 1871504112, user_data = 0x55de7189d308}} [11:59:51.098] nevents = 1 [11:59:51.098] __func__ = "ServerLoop" [11:59:51.098] #24 0x000055de6ec2a23a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55de7185acf0) at ../src/backend/postmaster/postmaster.c:1346 [11:59:51.098] opt = [11:59:51.098] status = [11:59:51.098] userDoption = [11:59:51.098] listen_addr_saved = false [11:59:51.098] output_config_variable = [11:59:51.098] __func__ = "PostmasterMain" [11:59:51.098] #25 0x000055de6ea69c68 in main (argc=4, argv=0x55de7185acf0) at ../src/backend/main/main.c:197 [11:59:51.098] do_check_root = [11:59:51.136] -e [11:59:51.136] [11:59:51.136] [11:59:51.202] dumping /tmp/cores/postgres-6-30063.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [11:59:51.475] [New LWP 30063] [11:59:51.475] [11:59:51.475] This GDB supports auto-downloading debuginfo from the following URLs: [11:59:51.475] [11:59:51.475] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [11:59:51.475] Debuginfod has been disabled. [11:59:51.475] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [11:59:51.592] [Thread debugging using libthread_db enabled] [11:59:51.592] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [11:59:51.592] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [11:59:51.592] Program terminated with signal SIGABRT, Aborted. [11:59:51.592] #0 0x00007fc5696a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:52.486] [11:59:52.486] Thread 1 (Thread 0x7fc5693e9f00 (LWP 30063)): [11:59:52.486] #0 0x00007fc5696a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:52.486] No symbol table info available. [11:59:52.486] #1 0x00007fc56965afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:52.486] No symbol table info available. [11:59:52.486] #2 0x00007fc569645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:52.486] No symbol table info available. [11:59:52.486] #3 0x000055ba7453a546 in ExceptionalCondition (conditionName=conditionName@entry=0x55ba747ab4c5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55ba747aaa30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [11:59:52.486] No locals. [11:59:52.486] #4 0x000055ba73ec8247 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55ba767576f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [11:59:52.486] estate = 0x55ba7671a310 [11:59:52.486] oldcontext = 0x55ba766d00a0 [11:59:52.486] __func__ = "standard_ExecutorStart" [11:59:52.486] #5 0x000055ba73ec8423 in ExecutorStart (queryDesc=queryDesc@entry=0x55ba767576f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [11:59:52.486] No locals. [11:59:52.486] #6 0x000055ba73def42a in refresh_matview_datafill (dest=0x55ba7675cfb8, query=, query@entry=0x55ba7672f830, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [11:59:52.486] rewritten = [11:59:52.486] plan = 0x55ba76756c28 [11:59:52.486] queryDesc = 0x55ba767576f0 [11:59:52.486] copied_query = [11:59:52.486] processed = [11:59:52.486] __func__ = "refresh_matview_datafill" [11:59:52.486] #7 0x000055ba73df1791 in RefreshMatViewByOid (matviewOid=27458, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [11:59:52.486] dest = [11:59:52.486] matviewRel = 0x7fc55de410c8 [11:59:52.486] rule = [11:59:52.486] actions = [11:59:52.486] dataQuery = 0x55ba7672f830 [11:59:52.486] tableSpace = [11:59:52.486] relowner = 10 [11:59:52.486] OIDNewHeap = 27465 [11:59:52.486] processed = 0 [11:59:52.486] relpersistence = 112 'p' [11:59:52.486] save_userid = 10 [11:59:52.486] save_sec_context = 0 [11:59:52.486] save_nestlevel = 2 [11:59:52.486] address = {classId = 0, objectId = 0, objectSubId = 0} [11:59:52.486] __func__ = "RefreshMatViewByOid" [11:59:52.486] #8 0x000055ba73df18d0 in ExecRefreshMatView (stmt=0x55ba766e7a60, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [11:59:52.486] matviewOid = [11:59:52.486] lockmode = [11:59:52.486] #9 0x000055ba73da9044 in ExecCreateTableAs (pstate=pstate@entry=0x55ba766d01a0, stmt=stmt@entry=0x55ba76589770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffafc990c0) at ../src/backend/commands/createas.c:350 [11:59:52.486] refresh = [11:59:52.486] query = 0x55ba76589930 [11:59:52.486] into = 0x55ba765894c8 [11:59:52.486] is_matview = true [11:59:52.486] do_refresh = false [11:59:52.486] dest = [11:59:52.486] address = {classId = 1259, objectId = 27458, objectSubId = 0} [11:59:52.486] __func__ = "ExecCreateTableAs" [11:59:52.486] #10 0x000055ba742b543e in ProcessUtilitySlow (pstate=pstate@entry=0x55ba766d01a0, pstmt=pstmt@entry=0x55ba76589820, queryString=queryString@entry=0x55ba76588a30 "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=0x55ba7658a258, qc=0x7fffafc990c0) at ../src/backend/tcop/utility.c:1675 [11:59:52.486] _save_exception_stack = 0x7fffafc98f80 [11:59:52.486] _save_context_stack = 0x0 [11:59:52.486] _local_sigjmp_buf = {{__jmpbuf = {0, -8185049178315653581, 94259337795440, 0, 94259337792048, 0, -2674172801555595725, -8185052886100574669}, __mask_was_saved = 0, __saved_mask = {__val = {140485666137856, 15251, 94259300703928, 1, 4294982547, 140485666137856, 94259304506419, 140485850996152, 94259337792048, 94259306815461, 94259316724738, 94259316724864, 140736142609860, 94259307009944, 94259316724753, 94259316724864}}}} [11:59:52.486] _do_rethrow = false [11:59:52.486] parsetree = 0x55ba76589770 [11:59:52.486] isTopLevel = true [11:59:52.486] isCompleteQuery = true [11:59:52.486] needCleanup = false [11:59:52.486] commandCollected = false [11:59:52.486] address = {classId = 21946, objectId = 1985517424, objectSubId = 21946} [11:59:52.486] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [11:59:52.486] __func__ = "ProcessUtilitySlow" [11:59:52.486] #11 0x000055ba742b3a4f in standard_ProcessUtility (pstmt=0x55ba76589820, queryString=0x55ba76588a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55ba7658a258, qc=0x7fffafc990c0) at ../src/backend/tcop/utility.c:1067 [11:59:52.486] parsetree = 0x55ba76589770 [11:59:52.486] isTopLevel = true [11:59:52.486] isAtomicContext = false [11:59:52.486] pstate = 0x55ba766d01a0 [11:59:52.486] readonly_flags = [11:59:52.486] __func__ = "standard_ProcessUtility" [11:59:52.486] #12 0x000055ba742b3baa in ProcessUtility (pstmt=pstmt@entry=0x55ba76589820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55ba7658a258, qc=0x7fffafc990c0) at ../src/backend/tcop/utility.c:523 [11:59:52.486] No locals. [11:59:52.486] #13 0x000055ba742af416 in PortalRunUtility (portal=portal@entry=0x55ba7660b680, pstmt=pstmt@entry=0x55ba76589820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55ba7658a258, qc=qc@entry=0x7fffafc990c0) at ../src/backend/tcop/pquery.c:1158 [11:59:52.486] No locals. [11:59:52.486] #14 0x000055ba742af9bb in PortalRunMulti (portal=portal@entry=0x55ba7660b680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55ba7658a258, altdest=altdest@entry=0x55ba7658a258, qc=qc@entry=0x7fffafc990c0) at ../src/backend/tcop/pquery.c:1316 [11:59:52.486] pstmt = 0x55ba76589820 [11:59:52.486] stmtlist_item__state = [11:59:52.486] active_snapshot_set = false [11:59:52.486] stmtlist_item = 0x55ba7658a220 [11:59:52.486] #15 0x000055ba742aff8e in PortalRun (portal=portal@entry=0x55ba7660b680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55ba7658a258, altdest=altdest@entry=0x55ba7658a258, qc=0x7fffafc990c0) at ../src/backend/tcop/pquery.c:791 [11:59:52.486] _save_exception_stack = 0x7fffafc99170 [11:59:52.486] _save_context_stack = 0x0 [11:59:52.486] _local_sigjmp_buf = {{__jmpbuf = {0, -8185049180124447181, 94259338327680, 94259337795560, 94259338327680, 94259337795488, -2674172801694007757, -8185052870998065613}, __mask_was_saved = 0, __saved_mask = {__val = {94259304191080, 94259337791792, 112, 4, 94259304195497, 2949222479, 4, 94259337795488, 112, 73, 94259338327680, 94259337795560, 94259337795536, 94259337795488, 94259304282700, 1}}}} [11:59:52.486] _do_rethrow = [11:59:52.486] result = [11:59:52.486] nprocessed = [11:59:52.486] saveTopTransactionResourceOwner = 0x55ba765c8838 [11:59:52.486] saveTopTransactionContext = 0x55ba7661c660 [11:59:52.486] saveActivePortal = 0x0 [11:59:52.486] saveResourceOwner = 0x55ba765c8838 [11:59:52.486] savePortalContext = 0x0 [11:59:52.486] saveMemoryContext = 0x55ba7661c660 [11:59:52.486] __func__ = "PortalRun" [11:59:52.486] #16 0x000055ba742a962a in exec_simple_query (query_string=query_string@entry=0x55ba76588a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [11:59:52.486] cmdtaglen = 24 [11:59:52.486] snapshot_set = [11:59:52.486] per_parsetree_context = 0x0 [11:59:52.486] plantree_list = 0x55ba7658a208 [11:59:52.486] parsetree = 0x55ba765897a0 [11:59:52.486] commandTag = [11:59:52.486] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:59:52.486] querytree_list = [11:59:52.486] portal = 0x55ba7660b680 [11:59:52.486] receiver = 0x55ba7658a258 [11:59:52.486] format = 0 [11:59:52.486] cmdtagname = [11:59:52.486] parsetree_item__state = [11:59:52.486] dest = DestRemote [11:59:52.486] oldcontext = 0x55ba7661c660 [11:59:52.486] parsetree_list = 0x55ba765897d0 [11:59:52.486] parsetree_item = 0x55ba765897e8 [11:59:52.486] save_log_statement_stats = false [11:59:52.486] was_logged = true [11:59:52.486] use_implicit_block = false [11:59:52.486] msec_str = " \223ɯ\377\177\000\000n\002Vt\272U\000\000P\221ɯ\377\177\000\000G\000\000\000\000\000\000" [11:59:52.486] __func__ = "exec_simple_query" [11:59:52.486] #17 0x000055ba742ac103 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [11:59:52.486] query_string = 0x55ba76588a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [11:59:52.486] firstchar = [11:59:52.486] input_message = {data = 0x55ba76588a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [11:59:52.486] local_sigjmp_buf = {{__jmpbuf = {94259316733304, -8185050721672724941, 4, 140736142611232, 140736142611376, 140736142611380, -2674172801354269133, -8185052873067954637}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94259337522608, 14336, 94259316727392, 94259338049520, 140736142611376, 94259304195045, 0, 9, 2, 94259316733312, 94259337522608, 94259316727392, 140736142611232, 140736142611376, 140736142611380}}}} [11:59:52.486] send_ready_for_query = false [11:59:52.486] idle_in_transaction_timeout_enabled = false [11:59:52.486] idle_session_timeout_enabled = false [11:59:52.486] __func__ = "PostgresMain" [11:59:52.486] #18 0x000055ba742a2225 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [11:59:52.486] bsdata = [11:59:52.486] #19 0x000055ba7415aab6 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffafc992cc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffafc99320) at ../src/backend/postmaster/launch_backend.c:274 [11:59:52.486] pid = [11:59:52.486] #20 0x000055ba74160562 in BackendStartup (client_sock=client_sock@entry=0x7fffafc99320) at ../src/backend/postmaster/postmaster.c:3415 [11:59:52.486] bn = 0x55ba765bd9d8 [11:59:52.486] pid = [11:59:52.486] startup_data = {canAcceptConnections = CAC_OK} [11:59:52.486] __func__ = "BackendStartup" [11:59:52.486] #21 0x000055ba74160ac4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [11:59:52.486] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "ɯ\377\177\000\000\264\223ɯ\377\177", '\000' , "ʝ2s\272U\000\000H\207.s\272U\000\000\200\224ɯ\377\177\000\000x\224ɯ\377\177\000\000\225[\362\001\000\000\000\000\240\364\343i\305\177\000\000+", '\000' , "ߜ2s\272U\000\000h&\352j\305\177\000\0000\366\343i\305\177\000", __ss_align = 140485879014112}, salen = 2}} [11:59:52.486] i = 0 [11:59:52.486] now = [11:59:52.486] last_lockfile_recheck_time = 1726401346 [11:59:52.486] last_touch_time = 1726401346 [11:59:52.486] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1932697034, events = 21946, fd = 1793730152, user_data = 0x7fc569e3f630}, {pos = 1793729248, events = 32709, fd = 2090263927, user_data = 0x7fffafc99500}, {pos = 1793559112, events = 32709, fd = 15, user_data = 0x7fc569e3f630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1793729248, events = 32709, fd = -1345743752, user_data = 0x7fffafc99480}, {pos = 1793730152, events = 32709, fd = 0, user_data = 0x55ba76588a48}, {pos = 1952234677, events = 21946, fd = 32768, user_data = 0x1}, {pos = 1985521648, events = 21946, fd = -1, user_data = 0x7fc56962e020}, {pos = 1790119840, events = 32709, fd = 1985704808, user_data = 0x55ba765b7248}, {pos = 1985703969, events = 21946, fd = 1793584830, user_data = 0x1}, {pos = 1793729248, events = 32709, fd = 438, user_data = 0x55ba74ad6db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55ba76588a48}, {pos = 1793584830, events = 32709, fd = 1, user_data = 0x0}, {pos = 1768087584, events = 32709, fd = 1768893888, user_data = 0x10}, {pos = -1345742608, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1793593786, user_data = 0x0}, {pos = 1768615204, events = 32709, fd = 0, user_data = 0x55ba75164f20 }, {pos = 2, events = 0, fd = 7, user_data = 0x55ba7654ae50}, {pos = 1948505127, events = 21946, fd = 1985722379, user_data = 0x55ba74241060 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55ba76588a48}, {pos = 1793584830, events = 32709, fd = 1, user_data = 0x0}, {pos = 1768121544, events = 32709, fd = 1768540288, user_data = 0x41e}, {pos = 1768648327, events = 32709, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 1769938016, events = 32709, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, 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 = 1951913064, events = 21946, fd = 1985677888, user_data = 0x7fc5696b56eb}, {pos = 1769920992, events = 32709, fd = 1768558958, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x8b101bd2eace3600}, {pos = 1769924064, events = 32709, 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 = 1985704200, user_data = 0x55ba7457dd2b }, {pos = 1985704000, events = 21946, fd = 3, user_data = 0x0}, {pos = 26096, events = 0, fd = -328, user_data = 0x0}, {pos = 1985514056, events = 21946, fd = 1768894419, user_data = 0x7fffafc999a8}, {pos = 1951996380, events = 21946, fd = 1964455216, user_data = 0x55ba74580499 }, {pos = 1985704000, events = 21946, fd = 1985513776, user_data = 0x55ba765b7040}, {pos = 1768642283, events = 32709, fd = 0, user_data = 0x55ba74592103 }, {pos = 1985704000, events = 1, fd = 1951998540, user_data = 0x55ba76588930}, {pos = -355584512, events = 2333088722, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1768565425, user_data = 0x7fc5696a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -355584512, user_data = 0x55ba76560060}, {pos = -355584512, events = 2333088722, fd = 11, user_data = 0x8b101bd2eace3600}, {pos = 0, events = 0, fd = 1768272441, user_data = 0x1}, {pos = 1947576243, events = 21946, fd = 4194304, user_data = 0x55ba7458032d }, {pos = 1985347680, events = 21946, fd = 1985513776, user_data = 0x55ba76560060}, {pos = 1, events = 0, fd = 0, user_data = 0x55ba74592103 }, {pos = 1985347680, events = 21946, fd = 1951998540, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55ba73f9188c }, {pos = 0, events = 0, fd = 1945725900, user_data = 0xb}, {pos = 1947597392, events = 21946, fd = 1960862448, user_data = 0x55ba765892d8}} [11:59:52.486] nevents = 1 [11:59:52.486] __func__ = "ServerLoop" [11:59:52.486] #22 0x000055ba7416223a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55ba76546cc0) at ../src/backend/postmaster/postmaster.c:1346 [11:59:52.486] opt = [11:59:52.486] status = [11:59:52.486] userDoption = [11:59:52.486] listen_addr_saved = false [11:59:52.486] output_config_variable = [11:59:52.486] __func__ = "PostmasterMain" [11:59:52.486] #23 0x000055ba73fa1c68 in main (argc=4, argv=0x55ba76546cc0) at ../src/backend/main/main.c:197 [11:59:52.486] do_check_root = [11:59:52.523] -e [11:59:52.523] [11:59:52.523] [11:59:52.589] dumping /tmp/cores/postgres-6-29443.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [11:59:52.847] [New LWP 29443] [11:59:52.847] [11:59:52.847] This GDB supports auto-downloading debuginfo from the following URLs: [11:59:52.847] [11:59:52.847] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [11:59:52.847] Debuginfod has been disabled. [11:59:52.847] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [11:59:52.954] [Thread debugging using libthread_db enabled] [11:59:52.954] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [11:59:52.954] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [11:59:52.954] Program terminated with signal SIGABRT, Aborted. [11:59:52.954] #0 0x00007fd9890a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:53.847] [11:59:53.847] Thread 1 (Thread 0x7fd989833f00 (LWP 29443)): [11:59:53.847] #0 0x00007fd9890a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:53.847] No symbol table info available. [11:59:53.847] #1 0x00007fd98905afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:53.847] No symbol table info available. [11:59:53.847] #2 0x00007fd989045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [11:59:53.847] No symbol table info available. [11:59:53.847] #3 0x000055647c99e546 in ExceptionalCondition (conditionName=conditionName@entry=0x55647cc0f4c5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55647cc0ea30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [11:59:53.847] No locals. [11:59:53.847] #4 0x000055647c32c247 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55647ef9c450, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [11:59:53.847] estate = 0x55647edf3d80 [11:59:53.847] oldcontext = 0x55647ef2c120 [11:59:53.847] __func__ = "standard_ExecutorStart" [11:59:53.847] #5 0x000055647c32c423 in ExecutorStart (queryDesc=queryDesc@entry=0x55647ef9c450, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [11:59:53.847] No locals. [11:59:53.847] #6 0x000055647c25342a in refresh_matview_datafill (dest=0x55647ef127a8, query=, query@entry=0x55647eedcc20, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [11:59:53.847] rewritten = [11:59:53.847] plan = 0x55647ef9b988 [11:59:53.847] queryDesc = 0x55647ef9c450 [11:59:53.847] copied_query = [11:59:53.847] processed = [11:59:53.847] __func__ = "refresh_matview_datafill" [11:59:53.847] #7 0x000055647c255791 in RefreshMatViewByOid (matviewOid=27375, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [11:59:53.847] dest = [11:59:53.847] matviewRel = 0x7fd97d62c0c8 [11:59:53.847] rule = [11:59:53.847] actions = [11:59:53.847] dataQuery = 0x55647eedcc20 [11:59:53.847] tableSpace = [11:59:53.847] relowner = 10 [11:59:53.847] OIDNewHeap = 27387 [11:59:53.847] processed = 0 [11:59:53.847] relpersistence = 112 'p' [11:59:53.847] save_userid = 10 [11:59:53.847] save_sec_context = 0 [11:59:53.847] save_nestlevel = 2 [11:59:53.847] address = {classId = 0, objectId = 0, objectSubId = 0} [11:59:53.847] __func__ = "RefreshMatViewByOid" [11:59:53.847] #8 0x000055647c2558d0 in ExecRefreshMatView (stmt=0x55647ef2a630, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [11:59:53.847] matviewOid = [11:59:53.847] lockmode = [11:59:53.847] #9 0x000055647c20d044 in ExecCreateTableAs (pstate=pstate@entry=0x55647ef2c220, stmt=stmt@entry=0x55647edc17f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd7b80e2f0) at ../src/backend/commands/createas.c:350 [11:59:53.847] refresh = [11:59:53.847] query = 0x55647edc19b0 [11:59:53.847] into = 0x55647edc1548 [11:59:53.847] is_matview = true [11:59:53.847] do_refresh = false [11:59:53.847] dest = [11:59:53.847] address = {classId = 1259, objectId = 27375, objectSubId = 0} [11:59:53.847] __func__ = "ExecCreateTableAs" [11:59:53.847] #10 0x000055647c71943e in ProcessUtilitySlow (pstate=pstate@entry=0x55647ef2c220, pstmt=pstmt@entry=0x55647edc18a0, queryString=queryString@entry=0x55647edc0ab0 "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=0x55647edc22d8, qc=0x7ffd7b80e2f0) at ../src/backend/tcop/utility.c:1675 [11:59:53.847] _save_exception_stack = 0x7ffd7b80e1b0 [11:59:53.847] _save_context_stack = 0x0 [11:59:53.847] _local_sigjmp_buf = {{__jmpbuf = {0, -4004988544469431873, 93890113443824, 0, 93890113440432, 0, -7108537721611351617, -4004991472701011521}, __mask_was_saved = 0, __saved_mask = {__val = {140572096869120, 10623, 93890072338104, 1, 4294977919, 140572096869120, 93890072328422, 1, 45627566147384, 1, 10623, 140572096869120, 140572096869120, 1, 93890072338451, 93890113652536}}}} [11:59:53.847] _do_rethrow = false [11:59:53.847] parsetree = 0x55647edc17f0 [11:59:53.847] isTopLevel = true [11:59:53.847] isCompleteQuery = true [11:59:53.847] needCleanup = false [11:59:53.847] commandCollected = false [11:59:53.847] address = {classId = 21860, objectId = 2128353264, objectSubId = 21860} [11:59:53.847] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [11:59:53.847] __func__ = "ProcessUtilitySlow" [11:59:53.847] #11 0x000055647c717a4f in standard_ProcessUtility (pstmt=0x55647edc18a0, queryString=0x55647edc0ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55647edc22d8, qc=0x7ffd7b80e2f0) at ../src/backend/tcop/utility.c:1067 [11:59:53.847] parsetree = 0x55647edc17f0 [11:59:53.847] isTopLevel = true [11:59:53.847] isAtomicContext = false [11:59:53.847] pstate = 0x55647ef2c220 [11:59:53.847] readonly_flags = [11:59:53.847] __func__ = "standard_ProcessUtility" [11:59:53.847] #12 0x000055647c717baa in ProcessUtility (pstmt=pstmt@entry=0x55647edc18a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55647edc22d8, qc=0x7ffd7b80e2f0) at ../src/backend/tcop/utility.c:523 [11:59:53.847] No locals. [11:59:53.847] #13 0x000055647c713416 in PortalRunUtility (portal=portal@entry=0x55647ee43050, pstmt=pstmt@entry=0x55647edc18a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55647edc22d8, qc=qc@entry=0x7ffd7b80e2f0) at ../src/backend/tcop/pquery.c:1158 [11:59:53.847] No locals. [11:59:53.847] #14 0x000055647c7139bb in PortalRunMulti (portal=portal@entry=0x55647ee43050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55647edc22d8, altdest=altdest@entry=0x55647edc22d8, qc=qc@entry=0x7ffd7b80e2f0) at ../src/backend/tcop/pquery.c:1316 [11:59:53.847] pstmt = 0x55647edc18a0 [11:59:53.847] stmtlist_item__state = [11:59:53.847] active_snapshot_set = false [11:59:53.847] stmtlist_item = 0x55647edc22a0 [11:59:53.847] #15 0x000055647c713f8e in PortalRun (portal=portal@entry=0x55647ee43050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55647edc22d8, altdest=altdest@entry=0x55647edc22d8, qc=0x7ffd7b80e2f0) at ../src/backend/tcop/pquery.c:791 [11:59:53.847] _save_exception_stack = 0x7ffd7b80e3a0 [11:59:53.847] _save_context_stack = 0x0 [11:59:53.847] _local_sigjmp_buf = {{__jmpbuf = {0, -4004988545338701377, 93890113974352, 93890113443944, 93890113974352, 93890113443872, -7108537722286634561, -4004991474912589377}, __mask_was_saved = 0, __saved_mask = {__val = {93890075825256, 93890113440176, 112, 4, 93890075829673, 2072044159, 4, 93890113443872, 112, 73, 93890113974352, 93890113443944, 93890113443920, 93890113443872, 93890075916876, 1}}}} [11:59:53.847] _do_rethrow = [11:59:53.847] result = [11:59:53.847] nprocessed = [11:59:53.847] saveTopTransactionResourceOwner = 0x55647edffd08 [11:59:53.847] saveTopTransactionContext = 0x55647ee54c60 [11:59:53.847] saveActivePortal = 0x0 [11:59:53.847] saveResourceOwner = 0x55647edffd08 [11:59:53.847] savePortalContext = 0x0 [11:59:53.847] saveMemoryContext = 0x55647ee54c60 [11:59:53.847] __func__ = "PortalRun" [11:59:53.847] #16 0x000055647c70d62a in exec_simple_query (query_string=query_string@entry=0x55647edc0ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [11:59:53.847] cmdtaglen = 24 [11:59:53.847] snapshot_set = [11:59:53.847] per_parsetree_context = 0x0 [11:59:53.847] plantree_list = 0x55647edc2288 [11:59:53.847] parsetree = 0x55647edc1820 [11:59:53.847] commandTag = [11:59:53.847] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:59:53.847] querytree_list = [11:59:53.847] portal = 0x55647ee43050 [11:59:53.847] receiver = 0x55647edc22d8 [11:59:53.847] format = 0 [11:59:53.847] cmdtagname = [11:59:53.847] parsetree_item__state = [11:59:53.847] dest = DestRemote [11:59:53.847] oldcontext = 0x55647ee54c60 [11:59:53.847] parsetree_list = 0x55647edc1850 [11:59:53.847] parsetree_item = 0x55647edc1868 [11:59:53.847] save_log_statement_stats = false [11:59:53.847] was_logged = false [11:59:53.847] use_implicit_block = false [11:59:53.847] msec_str = "P\345\200{\375\177\000\000nB\234|dU\000\000\200\343\200{\375\177\000\000G\000\000\000\000\000\000" [11:59:53.847] __func__ = "exec_simple_query" [11:59:53.847] #17 0x000055647c710103 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [11:59:53.847] query_string = 0x55647edc0ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [11:59:53.847] firstchar = [11:59:53.847] input_message = {data = 0x55647edc0ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [11:59:53.847] local_sigjmp_buf = {{__jmpbuf = {93890088367480, -4004989651870545473, 4, 140726675498320, 140726675498464, 140726675498468, -7108537722349549121, -4004991468258326081}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93890113170896, 15616, 93890088361568, 93890113694912, 140726675498464, 93890075829221, 0, 9, 2, 93890088367488, 93890113170896, 93890088361568, 140726675498320, 140726675498464, 140726675498468}}}} [11:59:53.847] send_ready_for_query = false [11:59:53.847] idle_in_transaction_timeout_enabled = false [11:59:53.847] idle_session_timeout_enabled = false [11:59:53.847] __func__ = "PostgresMain" [11:59:53.847] #18 0x000055647c706225 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [11:59:53.847] bsdata = [11:59:53.847] #19 0x000055647c5beab6 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd7b80e4fc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd7b80e550) at ../src/backend/postmaster/launch_backend.c:274 [11:59:53.847] pid = [11:59:53.847] #20 0x000055647c5c4562 in BackendStartup (client_sock=client_sock@entry=0x7ffd7b80e550) at ../src/backend/postmaster/postmaster.c:3415 [11:59:53.847] bn = 0x55647ede9578 [11:59:53.847] pid = [11:59:53.847] startup_data = {canAcceptConnections = CAC_OK} [11:59:53.847] __func__ = "BackendStartup" [11:59:53.847] #21 0x000055647c5c4ac4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [11:59:53.847] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\003\211\331\177\000\000\240/Y\212\331\177\000\000\370\345\200{\375\177\000\000\364\345\200{\375\177", '\000' , "\312\335x{dU\000\000H\307t{dU\000\000\300\346\200{\375\177\000\000\270\346\200{\375\177\000\000\225[\362\001\000\000\000\000\240\244\203\211\331\177\000\000+", '\000' , "dU\000\000\337\334x{dU\000", __ss_align = 140572309960296}, salen = 2}} [11:59:53.847] i = 0 [11:59:53.847] now = [11:59:53.847] last_lockfile_recheck_time = 1726401343 [11:59:53.847] last_touch_time = 1726401343 [11:59:53.847] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55647b78ddca}, {pos = -1969637784, events = 32729, fd = -1987860944, user_data = 0x7fd98a99b2e0}, {pos = 2090263927, events = 0, fd = 2072045376, user_data = 0x7fd98a971a48}, {pos = 15, events = 0, fd = -1987860944, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fd98a99b2e0}, {pos = 2072045240, events = 32765, fd = 2072045248, user_data = 0x7fd98a99b668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2128357552, events = 21860, fd = 1, user_data = 0x7ffd7b80ebe3}, {pos = -1, events = 0, fd = -1996300256, user_data = 0x7fd98a592fa0}, {pos = 2128533320, events = 21860, fd = 2128533032, user_data = 0x55647edef841}, {pos = -1969783106, events = 32729, fd = 1, user_data = 0x7fd98a99b2e0}, {pos = 438, events = 0, fd = 2096344496, user_data = 0x0}, {pos = 1, events = 0, fd = 2128350064, user_data = 0x7fd98a977ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fd98902e020}, {pos = -1995493952, events = 32729, fd = 16, user_data = 0x7ffd7b80eb20}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1969774150, events = 32729, fd = 0, user_data = 0x7fd9890aed24 }, {pos = 0, events = 0, fd = 2103217952, user_data = 0x2}, {pos = 7, events = 0, fd = 2128096880, user_data = 0x55647c6a5060 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2128350064, user_data = 0x7fd98a977ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fd9890364c8}, {pos = -1995739155, events = 32729, fd = 2103268480, user_data = 0x55647edec410}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1994449824, events = 32729, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x312020200a0a416d}, {pos = 822763892, events = 875967031, fd = 875770160, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2128535600, user_data = 0x7fd9890b56eb}, {pos = -1994466848, events = 32729, fd = -1995828882, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x927a36ec3292b700}, {pos = -1994463776, events = 32729, fd = -328, user_data = 0x0}, {pos = 2128532712, events = 21860, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 2128532512, events = 21860, fd = 3, user_data = 0x0}, {pos = 25444, events = 0, fd = -328, user_data = 0x0}, {pos = 2128350064, events = 21860, fd = -1995493421, user_data = 0x7ffd7b80ebd8}, {pos = 2090818012, events = 21860, fd = 2103276848, user_data = 0x55647c9e4499 }, {pos = 2128532512, events = 21860, fd = 2128349616, user_data = 0x55647eded420}, {pos = -1995745218, events = 32729, fd = 0, user_data = 0x55647c9f6103 }, {pos = 2128532512, events = 1, fd = 2090820172, user_data = 0x55647edc09b0}, {pos = 848475904, events = 2457482988, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1995822415, user_data = 0x7fd9890a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 848475904, user_data = 0x55647ed980e0}, {pos = 848475904, events = 2457482988, fd = 11, user_data = 0x927a36ec3292b700}, {pos = 0, events = 0, fd = -1996115399, user_data = 0x1}, {pos = 2086397875, events = 21860, fd = 4194304, user_data = 0x55647c9e432d }, {pos = 2128183520, events = 21860, fd = 2128349616, user_data = 0x55647ed980e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55647c9f6103 }, {pos = 2128183520, events = 21860, fd = 2090820172, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55647c3f588c }, {pos = 0, events = 0, fd = 2084547532, user_data = 0xb}, {pos = 2086419024, events = 21860, fd = 2099684080, user_data = 0x55647edc1388}} [11:59:53.847] nevents = 1 [11:59:53.847] __func__ = "ServerLoop" [11:59:53.847] #22 0x000055647c5c623a in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55647ed7ed30) at ../src/backend/postmaster/postmaster.c:1346 [11:59:53.847] opt = [11:59:53.847] status = [11:59:53.847] userDoption = [11:59:53.847] listen_addr_saved = false [11:59:53.847] output_config_variable = [11:59:53.847] __func__ = "PostmasterMain" [11:59:53.847] #23 0x000055647c405c68 in main (argc=8, argv=0x55647ed7ed30) at ../src/backend/main/main.c:197 [11:59:53.847] do_check_root =