[03:53:30.382] src/tools/ci/cores_backtrace.sh linux /tmp/cores [03:53:30.592] dumping /tmp/cores/postgres-6-36464.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:53:30.853] [New LWP 36464] [03:53:30.853] [03:53:30.853] This GDB supports auto-downloading debuginfo from the following URLs: [03:53:30.853] [03:53:30.853] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:53:30.853] Debuginfod has been disabled. [03:53:30.853] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:53:30.993] [Thread debugging using libthread_db enabled] [03:53:30.993] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:53:30.993] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:53:30.993] Program terminated with signal SIGABRT, Aborted. [03:53:30.993] #0 0x00007f8ba80a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:31.975] [03:53:31.975] Thread 1 (Thread 0x7f8ba7dd6f00 (LWP 36464)): [03:53:31.975] #0 0x00007f8ba80a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:31.975] No symbol table info available. [03:53:31.975] #1 0x00007f8ba805afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:31.975] No symbol table info available. [03:53:31.975] #2 0x00007f8ba8045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:31.975] No symbol table info available. [03:53:31.975] #3 0x000056548143a6aa in ExceptionalCondition (conditionName=conditionName@entry=0x5654816acadd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5654816ac010 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:53:31.975] No locals. [03:53:31.975] #4 0x0000565480dc70a1 in standard_ExecutorStart (queryDesc=0x5654833b0db0, eflags=0) at ../src/backend/executor/execMain.c:194 [03:53:31.975] estate = 0x565483283930 [03:53:31.975] oldcontext = 0x5654832b1530 [03:53:31.975] __func__ = "standard_ExecutorStart" [03:53:31.975] #5 0x00007f8ba56c26f7 in pgss_ExecutorStart (queryDesc=0x5654833b0db0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [03:53:31.975] No locals. [03:53:31.975] #6 0x0000565480dc7236 in ExecutorStart (queryDesc=queryDesc@entry=0x5654833b0db0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [03:53:31.975] No locals. [03:53:31.975] #7 0x0000565480ced3e4 in refresh_matview_datafill (dest=0x5654832ee608, query=, query@entry=0x565483305800, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:53:31.975] rewritten = [03:53:31.975] plan = 0x5654833b02e8 [03:53:31.975] queryDesc = 0x5654833b0db0 [03:53:31.975] copied_query = [03:53:31.975] processed = [03:53:31.975] __func__ = "refresh_matview_datafill" [03:53:31.975] #8 0x0000565480cef74b in RefreshMatViewByOid (matviewOid=27340, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:53:31.975] dest = [03:53:31.975] matviewRel = 0x7f8ba3a2af38 [03:53:31.975] rule = [03:53:31.975] actions = [03:53:31.975] dataQuery = 0x565483305800 [03:53:31.975] tableSpace = [03:53:31.975] relowner = 10 [03:53:31.975] OIDNewHeap = 27352 [03:53:31.975] processed = 0 [03:53:31.975] relpersistence = 112 'p' [03:53:31.975] save_userid = 10 [03:53:31.975] save_sec_context = 0 [03:53:31.975] save_nestlevel = 2 [03:53:31.975] address = {classId = 0, objectId = 0, objectSubId = 0} [03:53:31.975] __func__ = "RefreshMatViewByOid" [03:53:31.975] #9 0x0000565480cef88a in ExecRefreshMatView (stmt=0x5654832ad620, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:53:31.975] matviewOid = [03:53:31.975] lockmode = [03:53:31.975] #10 0x0000565480ca66d1 in ExecCreateTableAs (pstate=pstate@entry=0x5654832b1630, stmt=stmt@entry=0x565483198790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff621689f0) at ../src/backend/commands/createas.c:350 [03:53:31.975] refresh = [03:53:31.975] query = 0x565483198950 [03:53:31.975] into = 0x5654831984e8 [03:53:31.975] is_matview = true [03:53:31.975] do_refresh = false [03:53:31.975] dest = [03:53:31.975] address = {classId = 1259, objectId = 27340, objectSubId = 0} [03:53:31.975] __func__ = "ExecCreateTableAs" [03:53:31.975] #11 0x00005654811b4f1b in ProcessUtilitySlow (pstate=pstate@entry=0x5654832b1630, pstmt=pstmt@entry=0x565483198840, queryString=queryString@entry=0x565483197a50 "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=0x5654831997e8, qc=0x7fff621689f0) at ../src/backend/tcop/utility.c:1675 [03:53:31.975] _save_exception_stack = 0x7fff621685a0 [03:53:31.975] _save_context_stack = 0x0 [03:53:31.975] _local_sigjmp_buf = {{__jmpbuf = {0, 2824329746993718810, 94920976730000, 0, 94920976726608, 0, 8387333008675382810, 2824334165345773082}, __mask_was_saved = 0, __saved_mask = {__val = {94920942719703, 0, 0, 94920948769184, 94920942972279, 140237725791872, 1, 16777216, 0, 112, 94920942719975, 140237726093312, 140237726093312, 0, 0, 140237725791872}}}} [03:53:31.975] _do_rethrow = false [03:53:31.975] parsetree = 0x565483198790 [03:53:31.975] isTopLevel = true [03:53:31.975] isCompleteQuery = true [03:53:31.975] needCleanup = false [03:53:31.975] commandCollected = false [03:53:31.975] address = {classId = 22100, objectId = 2199488400, objectSubId = 22100} [03:53:31.975] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:53:31.975] __func__ = "ProcessUtilitySlow" [03:53:31.975] #12 0x00005654811b352c in standard_ProcessUtility (pstmt=pstmt@entry=0x565483198840, queryString=queryString@entry=0x565483197a50 "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=0x5654831997e8, qc=0x7fff621689f0) at ../src/backend/tcop/utility.c:1067 [03:53:31.975] parsetree = 0x565483198790 [03:53:31.975] isTopLevel = true [03:53:31.975] isAtomicContext = false [03:53:31.975] pstate = 0x5654832b1630 [03:53:31.975] readonly_flags = [03:53:31.975] __func__ = "standard_ProcessUtility" [03:53:31.975] #13 0x00007f8ba56c5d4a in pgss_ProcessUtility (pstmt=0x565483198840, queryString=0x565483197a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5654831997e8, qc=0x7fff621689f0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [03:53:31.975] _save_exception_stack = 0x7fff621688b0 [03:53:31.975] _save_context_stack = 0x0 [03:53:31.975] _local_sigjmp_buf = {{__jmpbuf = {0, -8387093646295357926, 94920976730176, 94920976734184, 140734839032304, 0, 8387333008713131546, 8398162289165542938}, __mask_was_saved = 0, __saved_mask = {__val = {94920946532139, 140734839031574, 140734839031572, 0, 0, 0, 206158430232, 140734839031536, 94920946532356, 362, 206158430232, 94920976730976, 140734839031632, 0, 94920941380367, 94920976726352}}}} [03:53:31.975] _do_rethrow = false [03:53:31.975] duration = [03:53:31.975] bufusage = {shared_blks_hit = 94920977694056, shared_blks_read = 360777252864, shared_blks_dirtied = 94920978920840, shared_blks_written = 94920939719557, local_blks_hit = 94920977693560, local_blks_read = 94920977692976, local_blks_dirtied = 94920939718666, local_blks_written = 94920939271707, temp_blks_read = 94920977693560, temp_blks_written = 94920939243064, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94920946525591}, local_blk_read_time = {ticks = 140237793488312}, local_blk_write_time = {ticks = 94920976726608}, temp_blk_read_time = {ticks = 94920948838373}, temp_blk_write_time = {ticks = 94920958759106}} [03:53:31.975] walusage_start = {wal_records = 8927, wal_fpi = 114, wal_bytes = 1133463} [03:53:31.975] start = [03:53:31.975] rows = [03:53:31.975] bufusage_start = {shared_blks_hit = 33565, shared_blks_read = 3707, shared_blks_dirtied = 1534, shared_blks_written = 1002, 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:53:31.975] walusage = {wal_records = 0, wal_fpi = 360777252864, wal_bytes = 94920977695992} [03:53:31.975] parsetree = [03:53:31.975] saved_queryId = 6041762721901209185 [03:53:31.975] saved_stmt_location = 0 [03:53:31.975] saved_stmt_len = 69 [03:53:31.975] enabled = true [03:53:31.975] #14 0x00005654811b35d2 in ProcessUtility (pstmt=pstmt@entry=0x565483198840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5654831997e8, qc=0x7fff621689f0) at ../src/backend/tcop/utility.c:519 [03:53:31.975] No locals. [03:53:31.975] #15 0x00005654811aeef3 in PortalRunUtility (portal=portal@entry=0x565483218f90, pstmt=pstmt@entry=0x565483198840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5654831997e8, qc=qc@entry=0x7fff621689f0) at ../src/backend/tcop/pquery.c:1158 [03:53:31.975] No locals. [03:53:31.975] #16 0x00005654811af498 in PortalRunMulti (portal=portal@entry=0x565483218f90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5654831997e8, altdest=altdest@entry=0x5654831997e8, qc=qc@entry=0x7fff621689f0) at ../src/backend/tcop/pquery.c:1316 [03:53:31.975] pstmt = 0x565483198840 [03:53:31.975] stmtlist_item__state = [03:53:31.975] active_snapshot_set = false [03:53:31.975] stmtlist_item = 0x5654831997b0 [03:53:31.975] #17 0x00005654811afa6b in PortalRun (portal=portal@entry=0x565483218f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5654831997e8, altdest=altdest@entry=0x5654831997e8, qc=0x7fff621689f0) at ../src/backend/tcop/pquery.c:791 [03:53:31.975] _save_exception_stack = 0x7fff62168aa0 [03:53:31.975] _save_context_stack = 0x0 [03:53:31.975] _local_sigjmp_buf = {{__jmpbuf = {0, 2824329746915075610, 94920977256336, 94920976730120, 94920977256336, 94920976730048, 8387333008392267290, 2824334167042762266}, __mask_was_saved = 0, __saved_mask = {__val = {94920946210252, 94920976726352, 112, 4, 94920946214669, 1645644159, 4, 94920976730048, 112, 73, 94920977256336, 94920976730120, 94920976730096, 94920976730048, 94920946301872, 1}}}} [03:53:31.975] _do_rethrow = [03:53:31.975] result = [03:53:31.975] nprocessed = [03:53:31.975] saveTopTransactionResourceOwner = 0x5654831d8468 [03:53:31.975] saveTopTransactionContext = 0x56548322b3c0 [03:53:31.975] saveActivePortal = 0x0 [03:53:31.975] saveResourceOwner = 0x5654831d8468 [03:53:31.975] savePortalContext = 0x0 [03:53:31.975] saveMemoryContext = 0x56548322b3c0 [03:53:31.975] __func__ = "PortalRun" [03:53:31.975] #18 0x00005654811a8e5c in exec_simple_query (query_string=query_string@entry=0x565483197a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:53:31.975] cmdtaglen = 24 [03:53:31.975] snapshot_set = [03:53:31.975] per_parsetree_context = 0x0 [03:53:31.975] plantree_list = 0x565483199798 [03:53:31.975] parsetree = 0x5654831987c0 [03:53:31.975] commandTag = [03:53:31.975] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:53:31.975] querytree_list = [03:53:31.975] portal = 0x565483218f90 [03:53:31.975] receiver = 0x5654831997e8 [03:53:31.975] format = 0 [03:53:31.975] cmdtagname = [03:53:31.975] parsetree_item__state = [03:53:31.975] dest = DestRemote [03:53:31.975] oldcontext = 0x56548322b3c0 [03:53:31.975] parsetree_list = 0x5654831987f0 [03:53:31.975] parsetree_item = 0x565483198808 [03:53:31.975] save_log_statement_stats = false [03:53:31.975] was_logged = true [03:53:31.975] use_implicit_block = false [03:53:31.975] msec_str = "P\214\026b\377\177\000\000\322\003F\201TV\000\000\200\212\026b\377\177\000\000G\000\000\000\000\000\000" [03:53:31.975] __func__ = "exec_simple_query" [03:53:31.975] #19 0x00005654811abbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4790 [03:53:31.975] query_string = 0x565483197a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:53:31.975] firstchar = [03:53:31.975] input_message = {data = 0x565483197a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:53:31.975] local_sigjmp_buf = {{__jmpbuf = {94920958767672, 2824331792270566938, 4, 140734839032912, 140734839033056, 140734839033060, 8387333008463570458, 2824334169519498778}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94920976976192, 0, 168, 94920946214771, 0, 10, 2, 94920958767680, 94920976457200, 94920958761760, 140734839032912, 140734839033056, 140734839033060}}}} [03:53:31.975] send_ready_for_query = false [03:53:31.975] idle_in_transaction_timeout_enabled = false [03:53:31.975] idle_session_timeout_enabled = false [03:53:31.975] __func__ = "PostgresMain" [03:53:31.975] #20 0x00005654811a1a57 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:53:31.975] bsdata = [03:53:31.975] #21 0x000056548105a24f in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff62168bfc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff62168c50) at ../src/backend/postmaster/launch_backend.c:274 [03:53:31.975] pid = [03:53:31.975] #22 0x000056548105fcfb in BackendStartup (client_sock=client_sock@entry=0x7fff62168c50) at ../src/backend/postmaster/postmaster.c:3415 [03:53:31.975] bn = 0x5654831c45b8 [03:53:31.975] pid = [03:53:31.975] startup_data = {canAcceptConnections = CAC_OK} [03:53:31.975] __func__ = "BackendStartup" [03:53:31.975] #23 0x000056548106025d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [03:53:31.975] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\003\250\213\177\000\000\240\037S\251\213\177\000\000\370\214\026b\377\177\000\000\364\214\026b\377\177", '\000' , "vN\"\200TV\000\000`7\036\200TV\000\000\300\215\026b\377\177\000\000\270\215\026b\377\177\000\000\225[\362\001\000\000\000\000p\032\034\203TV\000\000,", '\000' , "TV\000\000\213M\"\200TV\000", __ss_align = 140237821818472}, salen = 2}} [03:53:31.975] i = 0 [03:53:31.975] now = [03:53:31.975] last_lockfile_recheck_time = 1726890613 [03:53:31.975] last_touch_time = 1726890613 [03:53:31.975] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x565480224e76}, {pos = -1450330520, events = 32651, fd = -1461152208, user_data = 0x7f8ba98db2e0}, {pos = 2090263927, events = 0, fd = 1645645376, user_data = 0x7f8ba98b1a48}, {pos = 15, events = 0, fd = -1461152208, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f8ba98db2e0}, {pos = 1645645240, events = 32767, fd = 1645645248, user_data = 0x7f8ba98db668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -2095479440, events = 22100, fd = 1, user_data = 0x7fff621692e3}, {pos = -1, events = 0, fd = -1476206560, user_data = 0x7f8ba9531fa0}, {pos = -2095303928, events = 22100, fd = -2095304216, user_data = 0x5654831c7891}, {pos = -1450475842, events = 32651, fd = 1, user_data = 0x7f8ba98db2e0}, {pos = 438, events = 0, fd = -2120381008, user_data = 0x0}, {pos = 1, events = 0, fd = -2095474544, user_data = 0x7f8ba98b7ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f8ba802e020}, {pos = -1475400256, events = 32651, fd = 16, user_data = 0x7fff62169220}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1450466886, events = 32651, fd = 0, user_data = 0x7f8ba80aed24 }, {pos = 0, events = 0, fd = -2113500192, user_data = 0x2}, {pos = 7, events = 0, fd = -2095735152, user_data = 0x565481140892 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -2095474544, user_data = 0x7f8ba98b7ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f8ba80364c8}, {pos = -1475645459, events = 32651, fd = -2113449664, user_data = 0x5654831cc900}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -1474356128, events = 32651, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = -1461148352, events = 32651, fd = -1461147008, 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 = -2095290224, user_data = 0x7f8ba80b583e}, {pos = -1474373152, events = 32651, fd = -1475735186, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xce8202970df9ee00}, {pos = -1474370080, events = 32651, fd = -328, user_data = 0x0}, {pos = -2095304536, events = 22100, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -2095304736, events = 22100, fd = 3, user_data = 0x0}, {pos = 32575, events = 0, fd = -328, user_data = 0x0}, {pos = -2095474544, events = 22100, fd = -1475399725, user_data = 0x7fff621692d8}, {pos = -2125915328, events = 22100, fd = -2113441296, user_data = 0x5654814805fd }, {pos = -2095304736, events = 22100, fd = -2095482544, user_data = 0x5654831c2fe0}, {pos = -1475651522, events = 32651, fd = 0, user_data = 0x565481492267 }, {pos = -2095304736, events = 1, fd = -2125913168, user_data = 0x565483197950}, {pos = 234483200, events = 3464626839, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1475728719, user_data = 0x7f8ba80a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 234483200, user_data = 0x56548316f080}, {pos = 234483200, events = 3464626839, fd = 11, user_data = 0xce8202970df9ee00}, {pos = 0, events = 0, fd = -1476021703, user_data = 0x1}, {pos = -2130337972, events = 22100, fd = 4194304, user_data = 0x565481480491 }, {pos = -2095648640, events = 22100, fd = -2095482544, user_data = 0x56548316f080}, {pos = 1, events = 0, fd = 0, user_data = 0x565481492267 }, {pos = -2095648640, events = 22100, fd = -2125913168, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x565480e90703 }, {pos = 0, events = 0, fd = -2132190653, user_data = 0xb}, {pos = -2130316823, events = 22100, fd = -2117036624, user_data = 0x565483198308}} [03:53:31.975] nevents = 1 [03:53:31.975] __func__ = "ServerLoop" [03:53:31.975] #24 0x00005654810619d3 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x565483155cf0) at ../src/backend/postmaster/postmaster.c:1346 [03:53:31.975] opt = [03:53:31.975] status = [03:53:31.975] userDoption = [03:53:31.975] listen_addr_saved = false [03:53:31.975] output_config_variable = [03:53:31.975] __func__ = "PostmasterMain" [03:53:31.975] #25 0x0000565480ea0adf in main (argc=4, argv=0x565483155cf0) at ../src/backend/main/main.c:197 [03:53:31.975] do_check_root = [03:53:32.011] -e [03:53:32.011] [03:53:32.011] [03:53:32.072] dumping /tmp/cores/sh-3-32513.core for /bin/sh [03:53:32.120] [03:53:32.120] This GDB supports auto-downloading debuginfo from the following URLs: [03:53:32.120] [03:53:32.120] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:53:32.120] Debuginfod has been disabled. [03:53:32.120] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:53:32.121] [New LWP 32513] [03:53:32.121] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/020_archive_status/data/t'. [03:53:32.121] Program terminated with signal SIGQUIT, Quit. [03:53:32.121] #0 0x00007f598fa0da50 in ?? () [03:53:32.121] [03:53:32.121] Thread 1 (LWP 32513): [03:53:32.121] #0 0x00007f598fa0da50 in ?? () [03:53:32.121] No symbol table info available. [03:53:32.121] #1 0x0000000000000003 in ?? () [03:53:32.121] No symbol table info available. [03:53:32.121] #2 0x00007fffb0f224cd in ?? () [03:53:32.121] No symbol table info available. [03:53:32.121] #3 0x00007fffb0f224d0 in ?? () [03:53:32.121] No symbol table info available. [03:53:32.121] #4 0x00007fffb0f224d3 in ?? () [03:53:32.121] No symbol table info available. [03:53:32.121] #5 0x0000000000000000 in ?? () [03:53:32.121] No symbol table info available. [03:53:32.128] -e [03:53:32.128] [03:53:32.128] [03:53:32.192] dumping /tmp/cores/postgres-6-29123.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:53:32.459] [New LWP 29123] [03:53:32.459] [03:53:32.459] This GDB supports auto-downloading debuginfo from the following URLs: [03:53:32.459] [03:53:32.459] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:53:32.459] Debuginfod has been disabled. [03:53:32.459] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:53:32.573] [Thread debugging using libthread_db enabled] [03:53:32.573] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:53:32.573] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:53:32.573] Program terminated with signal SIGABRT, Aborted. [03:53:32.573] #0 0x00007f5f21ea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:33.487] [03:53:33.487] Thread 1 (Thread 0x7f5f22633f00 (LWP 29123)): [03:53:33.487] #0 0x00007f5f21ea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:33.487] No symbol table info available. [03:53:33.487] #1 0x00007f5f21e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:33.487] No symbol table info available. [03:53:33.487] #2 0x00007f5f21e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:33.487] No symbol table info available. [03:53:33.487] #3 0x000055d87bdd36aa in ExceptionalCondition (conditionName=conditionName@entry=0x55d87c045add "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55d87c045010 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:53:33.487] No locals. [03:53:33.487] #4 0x000055d87b7600a1 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55d87d594c50, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [03:53:33.487] estate = 0x55d87d3ebd80 [03:53:33.487] oldcontext = 0x55d87d525920 [03:53:33.487] __func__ = "standard_ExecutorStart" [03:53:33.487] #5 0x000055d87b76027d in ExecutorStart (queryDesc=queryDesc@entry=0x55d87d594c50, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [03:53:33.487] No locals. [03:53:33.487] #6 0x000055d87b6863e4 in refresh_matview_datafill (dest=0x55d87d4f4738, query=, query@entry=0x55d87d4d5820, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:53:33.487] rewritten = [03:53:33.487] plan = 0x55d87d594188 [03:53:33.487] queryDesc = 0x55d87d594c50 [03:53:33.487] copied_query = [03:53:33.487] processed = [03:53:33.487] __func__ = "refresh_matview_datafill" [03:53:33.487] #7 0x000055d87b68874b in RefreshMatViewByOid (matviewOid=27455, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:53:33.487] dest = [03:53:33.487] matviewRel = 0x7f5f1642c0c8 [03:53:33.487] rule = [03:53:33.487] actions = [03:53:33.487] dataQuery = 0x55d87d4d5820 [03:53:33.487] tableSpace = [03:53:33.487] relowner = 10 [03:53:33.487] OIDNewHeap = 27464 [03:53:33.487] processed = 0 [03:53:33.487] relpersistence = 112 'p' [03:53:33.487] save_userid = 10 [03:53:33.487] save_sec_context = 0 [03:53:33.487] save_nestlevel = 2 [03:53:33.487] address = {classId = 0, objectId = 0, objectSubId = 0} [03:53:33.487] __func__ = "RefreshMatViewByOid" [03:53:33.487] #8 0x000055d87b68888a in ExecRefreshMatView (stmt=0x55d87d521e20, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:53:33.487] matviewOid = [03:53:33.487] lockmode = [03:53:33.487] #9 0x000055d87b63f6d1 in ExecCreateTableAs (pstate=pstate@entry=0x55d87d525a20, stmt=stmt@entry=0x55d87d3b97f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc0caeb260) at ../src/backend/commands/createas.c:350 [03:53:33.487] refresh = [03:53:33.487] query = 0x55d87d3b99b0 [03:53:33.487] into = 0x55d87d3b9548 [03:53:33.487] is_matview = true [03:53:33.487] do_refresh = false [03:53:33.487] dest = [03:53:33.487] address = {classId = 1259, objectId = 27455, objectSubId = 0} [03:53:33.487] __func__ = "ExecCreateTableAs" [03:53:33.487] #10 0x000055d87bb4df1b in ProcessUtilitySlow (pstate=pstate@entry=0x55d87d525a20, pstmt=pstmt@entry=0x55d87d3b98a0, queryString=queryString@entry=0x55d87d3b8ab0 "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=0x55d87d3ba2d8, qc=0x7ffc0caeb260) at ../src/backend/tcop/utility.c:1675 [03:53:33.487] _save_exception_stack = 0x7ffc0caeb120 [03:53:33.487] _save_context_stack = 0x0 [03:53:33.487] _local_sigjmp_buf = {{__jmpbuf = {0, -8587196699873510930, 94388302354416, 0, 94388302351024, 0, -2549946464969033234, -8587191278004864530}, __mask_was_saved = 0, __saved_mask = {__val = {4294977871, 140046380705536, 94388276166936, 1, 45421380421432, 1, 10575, 140046380705536, 140046380705536, 1, 94388276176965, 94388302563128, 10630746925172105216, 140046380705536, 140046380705536, 10575}}}} [03:53:33.487] _do_rethrow = false [03:53:33.487] parsetree = 0x55d87d3b97f0 [03:53:33.487] isTopLevel = true [03:53:33.487] isCompleteQuery = true [03:53:33.487] needCleanup = false [03:53:33.487] commandCollected = false [03:53:33.487] address = {classId = 21976, objectId = 2101057520, objectSubId = 21976} [03:53:33.487] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:53:33.487] __func__ = "ProcessUtilitySlow" [03:53:33.487] #11 0x000055d87bb4c52c in standard_ProcessUtility (pstmt=0x55d87d3b98a0, queryString=0x55d87d3b8ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55d87d3ba2d8, qc=0x7ffc0caeb260) at ../src/backend/tcop/utility.c:1067 [03:53:33.487] parsetree = 0x55d87d3b97f0 [03:53:33.487] isTopLevel = true [03:53:33.487] isAtomicContext = false [03:53:33.487] pstate = 0x55d87d525a20 [03:53:33.487] readonly_flags = [03:53:33.487] __func__ = "standard_ProcessUtility" [03:53:33.487] #12 0x000055d87bb4c687 in ProcessUtility (pstmt=pstmt@entry=0x55d87d3b98a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55d87d3ba2d8, qc=0x7ffc0caeb260) at ../src/backend/tcop/utility.c:523 [03:53:33.487] No locals. [03:53:33.487] #13 0x000055d87bb47ef3 in PortalRunUtility (portal=portal@entry=0x55d87d43b050, pstmt=pstmt@entry=0x55d87d3b98a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d87d3ba2d8, qc=qc@entry=0x7ffc0caeb260) at ../src/backend/tcop/pquery.c:1158 [03:53:33.487] No locals. [03:53:33.487] #14 0x000055d87bb48498 in PortalRunMulti (portal=portal@entry=0x55d87d43b050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d87d3ba2d8, altdest=altdest@entry=0x55d87d3ba2d8, qc=qc@entry=0x7ffc0caeb260) at ../src/backend/tcop/pquery.c:1316 [03:53:33.487] pstmt = 0x55d87d3b98a0 [03:53:33.487] stmtlist_item__state = [03:53:33.487] active_snapshot_set = false [03:53:33.487] stmtlist_item = 0x55d87d3ba2a0 [03:53:33.487] #15 0x000055d87bb48a6b in PortalRun (portal=portal@entry=0x55d87d43b050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55d87d3ba2d8, altdest=altdest@entry=0x55d87d3ba2d8, qc=0x7ffc0caeb260) at ../src/backend/tcop/pquery.c:791 [03:53:33.487] _save_exception_stack = 0x7ffc0caeb310 [03:53:33.487] _save_context_stack = 0x0 [03:53:33.487] _local_sigjmp_buf = {{__jmpbuf = {0, -8587196699140556306, 94388302884944, 94388302354536, 94388302884944, 94388302354464, -2549946464025314834, -8587191280191800850}, __mask_was_saved = 0, __saved_mask = {__val = {94388279666124, 94388302350768, 112, 4, 94388279670541, 212775407, 4, 94388302354464, 112, 73, 94388302884944, 94388302354536, 94388302354512, 94388302354464, 94388279757744, 1}}}} [03:53:33.487] _do_rethrow = [03:53:33.487] result = [03:53:33.487] nprocessed = [03:53:33.487] saveTopTransactionResourceOwner = 0x55d87d3f7d08 [03:53:33.487] saveTopTransactionContext = 0x55d87d44cc60 [03:53:33.487] saveActivePortal = 0x0 [03:53:33.487] saveResourceOwner = 0x55d87d3f7d08 [03:53:33.487] savePortalContext = 0x0 [03:53:33.487] saveMemoryContext = 0x55d87d44cc60 [03:53:33.487] __func__ = "PortalRun" [03:53:33.487] #16 0x000055d87bb41e5c in exec_simple_query (query_string=query_string@entry=0x55d87d3b8ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:53:33.487] cmdtaglen = 24 [03:53:33.487] snapshot_set = [03:53:33.487] per_parsetree_context = 0x0 [03:53:33.487] plantree_list = 0x55d87d3ba288 [03:53:33.487] parsetree = 0x55d87d3b9820 [03:53:33.487] commandTag = [03:53:33.487] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:53:33.487] querytree_list = [03:53:33.487] portal = 0x55d87d43b050 [03:53:33.487] receiver = 0x55d87d3ba2d8 [03:53:33.487] format = 0 [03:53:33.487] cmdtagname = [03:53:33.487] parsetree_item__state = [03:53:33.487] dest = DestRemote [03:53:33.487] oldcontext = 0x55d87d44cc60 [03:53:33.487] parsetree_list = 0x55d87d3b9850 [03:53:33.487] parsetree_item = 0x55d87d3b9868 [03:53:33.487] save_log_statement_stats = false [03:53:33.487] was_logged = false [03:53:33.487] use_implicit_block = false [03:53:33.487] msec_str = "\300\264\256\f\374\177\000\000ғ\337{\330U\000\000\360\262\256\f\374\177\000\000G\000\000\000\000\000\000" [03:53:33.487] __func__ = "exec_simple_query" [03:53:33.487] #17 0x000055d87bb44be0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4790 [03:53:33.487] query_string = 0x55d87d3b8ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:53:33.487] firstchar = [03:53:33.487] input_message = {data = 0x55d87d3b8ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:53:33.487] local_sigjmp_buf = {{__jmpbuf = {94388292223544, -8587197718137275922, 4, 140720521262272, 140720521262416, 140720521262420, -2549946464096618002, -8587191282144249362}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94388302081488, 15616, 94388292217632, 94388302605504, 140720521262416, 94388279670089, 0, 9, 2, 94388292223552, 94388302081488, 94388292217632, 140720521262272, 140720521262416, 140720521262420}}}} [03:53:33.487] send_ready_for_query = false [03:53:33.487] idle_in_transaction_timeout_enabled = false [03:53:33.487] idle_session_timeout_enabled = false [03:53:33.487] __func__ = "PostgresMain" [03:53:33.487] #18 0x000055d87bb3aa57 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:53:33.487] bsdata = [03:53:33.487] #19 0x000055d87b9f324f in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc0caeb46c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc0caeb4c0) at ../src/backend/postmaster/launch_backend.c:274 [03:53:33.487] pid = [03:53:33.487] #20 0x000055d87b9f8cfb in BackendStartup (client_sock=client_sock@entry=0x7ffc0caeb4c0) at ../src/backend/postmaster/postmaster.c:3415 [03:53:33.487] bn = 0x55d87d3e1438 [03:53:33.487] pid = [03:53:33.487] startup_data = {canAcceptConnections = CAC_OK} [03:53:33.487] __func__ = "BackendStartup" [03:53:33.487] #21 0x000055d87b9f925d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [03:53:33.487] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "u#_\177\000\000>\004\000\000\000\000\000\000\260\227\343!_\177\000\000\240\1777#_\177\000\000x\265\256\f\374\177\000\000t\265\256\f\374\177", '\000' , "v\336\273z\330U\000\000`Ƿz\330U\000\000@\266\256\f\374\177\000\0008\266\256\f\374\177\000\000\225[\362\001(A\354f\240t\310\"_\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [03:53:33.487] i = 0 [03:53:33.487] now = [03:53:33.487] last_lockfile_recheck_time = 1726890576 [03:53:33.487] last_touch_time = 1726890576 [03:53:33.487] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 212776576, user_data = 0x0}, {pos = 15, events = 0, fd = 2059132534, user_data = 0x7f5f23780668}, {pos = 583562800, events = 32607, fd = 595067616, user_data = 0x7c96e577}, {pos = 212776640, events = 32764, fd = 594897480, user_data = 0xf}, {pos = 583562800, events = 32607, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 595067616, user_data = 0x7ffc0caeb638}, {pos = 212776512, events = 32764, fd = 595068520, user_data = 0x0}, {pos = 2101061808, events = 21976, fd = 569306341, user_data = 0x7ffc0caebb53}, {pos = 1, events = 0, fd = 212776512, user_data = 0xffffffff}, {pos = 568516640, events = 32607, fd = 590839712, user_data = 0x55d87d3e5748}, {pos = 2101237288, events = 21976, fd = 2101246017, user_data = 0x7f5f2375cebe}, {pos = 1, events = 0, fd = 595067616, user_data = 0x1b6}, {pos = 2083986864, events = 21976, fd = 0, user_data = 0x1}, {pos = 2101054320, events = 21976, fd = 594923198, user_data = 0x1}, {pos = 0, events = 0, fd = 568516640, user_data = 0x7f5f21ef2dc0 }, {pos = 16, events = 0, fd = 212777616, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f5f2375f1ba}, {pos = 0, events = 0, fd = 569044260, user_data = 0x0}, {pos = 2090867680, events = 21976, fd = 2, user_data = 0x7}, {pos = 2100801136, events = 21976, fd = 1952410737, user_data = 0x169}, {pos = 2083986248, events = 21976, fd = 8, user_data = 0x2ffff00001fa0}, {pos = 2101054320, events = 21976, fd = 594923198, user_data = 0x1}, {pos = 569077741, events = 32607, fd = 568550600, user_data = 0x55d87d3e4410}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 570367072, events = 32607, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55d87d37ae70}, {pos = 569080330, events = 32607, 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 = 1900962100, fd = 168457282, user_data = 0x38363237310a6174}, {pos = 926232633, events = 808716854, 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 = 570350048, events = 32607, fd = 568988014, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x66ec41287615f000}, {pos = 570353120, events = 32607, fd = -328, user_data = 0x0}, {pos = 2101236968, events = 21976, fd = 1024, user_data = 0x55d87d3e54e8}, {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 = 25348, events = 0, fd = -328, user_data = 0x0}, {pos = 2101054320, events = 21976, fd = 569323475, user_data = 0x7ffc0caebb48}, {pos = 2078452544, events = 21976, fd = 2090926576, user_data = 0x55d87be195fd }, {pos = 2101236768, events = 21976, fd = 2101053872, user_data = 0x55d87d3e5420}, {pos = 569071678, events = 32607, fd = 0, user_data = 0x55d87be2b267 }, {pos = 2101236768, events = 1, fd = 2078454704, user_data = 0x55d87d3b89b0}, {pos = 1981149184, events = 1726759208, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 568994481, user_data = 0x7f5f21ea14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1981149184, user_data = 0x55d87d3900e0}, {pos = 1981149184, events = 1726759208, fd = 11, user_data = 0x66ec41287615f000}, {pos = 0, events = 0, fd = 568701497, user_data = 0x1}, {pos = 2074029900, events = 21976, fd = 4194304, user_data = 0x55d87be19491 }, {pos = 2100887776, events = 21976, fd = 2101053872, user_data = 0x55d87d3900e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55d87be2b267 }, {pos = 2100887776, events = 21976, fd = 2078454704, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55d87b829703 }, {pos = 0, events = 0, fd = 2072177219, user_data = 0xb}, {pos = 2074051049, events = 21976, fd = 2087331248, user_data = 0x55d87d3b9388}} [03:53:33.487] nevents = 1 [03:53:33.487] __func__ = "ServerLoop" [03:53:33.487] #22 0x000055d87b9fa9d3 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55d87d376d30) at ../src/backend/postmaster/postmaster.c:1346 [03:53:33.487] opt = [03:53:33.487] status = [03:53:33.487] userDoption = [03:53:33.487] listen_addr_saved = false [03:53:33.487] output_config_variable = [03:53:33.487] __func__ = "PostmasterMain" [03:53:33.487] #23 0x000055d87b839adf in main (argc=8, argv=0x55d87d376d30) at ../src/backend/main/main.c:197 [03:53:33.487] do_check_root = [03:53:33.523] -e [03:53:33.523] [03:53:33.523] [03:53:33.587] dumping /tmp/cores/postgres-6-29468.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:53:33.843] [New LWP 29468] [03:53:33.843] [03:53:33.843] This GDB supports auto-downloading debuginfo from the following URLs: [03:53:33.843] [03:53:33.843] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:53:33.843] Debuginfod has been disabled. [03:53:33.843] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:53:33.954] [Thread debugging using libthread_db enabled] [03:53:33.954] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:53:33.954] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:53:33.954] Program terminated with signal SIGABRT, Aborted. [03:53:33.954] #0 0x00007f7f47ea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:34.877] [03:53:34.877] Thread 1 (Thread 0x7f7f48633f00 (LWP 29468)): [03:53:34.877] #0 0x00007f7f47ea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:34.877] No symbol table info available. [03:53:34.877] #1 0x00007f7f47e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:34.877] No symbol table info available. [03:53:34.877] #2 0x00007f7f47e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:53:34.877] No symbol table info available. [03:53:34.877] #3 0x00005620f3df46aa in ExceptionalCondition (conditionName=conditionName@entry=0x5620f4066add "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5620f4066010 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:53:34.877] No locals. [03:53:34.877] #4 0x00005620f37810a1 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5620f687cca0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [03:53:34.877] estate = 0x5620f67d48c0 [03:53:34.877] oldcontext = 0x5620f68828a0 [03:53:34.877] __func__ = "standard_ExecutorStart" [03:53:34.877] #5 0x00005620f378127d in ExecutorStart (queryDesc=queryDesc@entry=0x5620f687cca0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [03:53:34.877] No locals. [03:53:34.877] #6 0x00005620f36a73e4 in refresh_matview_datafill (dest=0x5620f67bd388, query=, query@entry=0x5620f67b0980, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:53:34.877] rewritten = [03:53:34.877] plan = 0x5620f687c1d8 [03:53:34.877] queryDesc = 0x5620f687cca0 [03:53:34.877] copied_query = [03:53:34.877] processed = [03:53:34.877] __func__ = "refresh_matview_datafill" [03:53:34.877] #7 0x00005620f36a974b in RefreshMatViewByOid (matviewOid=27305, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:53:34.877] dest = [03:53:34.877] matviewRel = 0x7f7f3c71ff38 [03:53:34.877] rule = [03:53:34.877] actions = [03:53:34.877] dataQuery = 0x5620f67b0980 [03:53:34.877] tableSpace = [03:53:34.877] relowner = 10 [03:53:34.877] OIDNewHeap = 27326 [03:53:34.877] processed = 0 [03:53:34.877] relpersistence = 112 'p' [03:53:34.877] save_userid = 10 [03:53:34.877] save_sec_context = 0 [03:53:34.877] save_nestlevel = 2 [03:53:34.877] address = {classId = 0, objectId = 0, objectSubId = 0} [03:53:34.877] __func__ = "RefreshMatViewByOid" [03:53:34.877] #8 0x00005620f36a988a in ExecRefreshMatView (stmt=0x5620f67e7140, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:53:34.877] matviewOid = [03:53:34.877] lockmode = [03:53:34.877] #9 0x00005620f36606d1 in ExecCreateTableAs (pstate=pstate@entry=0x5620f68829a0, stmt=stmt@entry=0x5620f66a0770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffffacacc10) at ../src/backend/commands/createas.c:350 [03:53:34.877] refresh = [03:53:34.877] query = 0x5620f66a0930 [03:53:34.877] into = 0x5620f66a04c8 [03:53:34.877] is_matview = true [03:53:34.877] do_refresh = false [03:53:34.877] dest = [03:53:34.877] address = {classId = 1259, objectId = 27305, objectSubId = 0} [03:53:34.877] __func__ = "ExecCreateTableAs" [03:53:34.877] #10 0x00005620f3b6ef1b in ProcessUtilitySlow (pstate=pstate@entry=0x5620f68829a0, pstmt=pstmt@entry=0x5620f66a0820, queryString=queryString@entry=0x5620f669fa30 "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=0x5620f66a1258, qc=0x7ffffacacc10) at ../src/backend/tcop/utility.c:1675 [03:53:34.877] _save_exception_stack = 0x7ffffacacad0 [03:53:34.877] _save_context_stack = 0x0 [03:53:34.877] _local_sigjmp_buf = {{__jmpbuf = {0, 191497150847901040, 94699573086064, 0, 94699573082672, 0, 5842942115113983344, 191506464375299440}, __mask_was_saved = 0, __saved_mask = {__val = {4294982407, 140184457430016, 94699527213336, 1, 64905386595496, 1, 94699531027863, 140184652037560, 94699573082672, 94699533340645, 94699543261378, 94699543261504, 140737400981780, 94699533535320, 94699543261393, 94699543261504}}}} [03:53:34.877] _do_rethrow = false [03:53:34.877] parsetree = 0x5620f66a0770 [03:53:34.877] isTopLevel = true [03:53:34.877] isCompleteQuery = true [03:53:34.877] needCleanup = false [03:53:34.877] commandCollected = false [03:53:34.877] address = {classId = 22048, objectId = 4134143856, objectSubId = 22048} [03:53:34.877] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:53:34.877] __func__ = "ProcessUtilitySlow" [03:53:34.877] #11 0x00005620f3b6d52c in standard_ProcessUtility (pstmt=0x5620f66a0820, queryString=0x5620f669fa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5620f66a1258, qc=0x7ffffacacc10) at ../src/backend/tcop/utility.c:1067 [03:53:34.877] parsetree = 0x5620f66a0770 [03:53:34.877] isTopLevel = true [03:53:34.877] isAtomicContext = false [03:53:34.877] pstate = 0x5620f68829a0 [03:53:34.877] readonly_flags = [03:53:34.877] __func__ = "standard_ProcessUtility" [03:53:34.877] #12 0x00005620f3b6d687 in ProcessUtility (pstmt=pstmt@entry=0x5620f66a0820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5620f66a1258, qc=0x7ffffacacc10) at ../src/backend/tcop/utility.c:523 [03:53:34.877] No locals. [03:53:34.877] #13 0x00005620f3b68ef3 in PortalRunUtility (portal=portal@entry=0x5620f6722680, pstmt=pstmt@entry=0x5620f66a0820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5620f66a1258, qc=qc@entry=0x7ffffacacc10) at ../src/backend/tcop/pquery.c:1158 [03:53:34.877] No locals. [03:53:34.877] #14 0x00005620f3b69498 in PortalRunMulti (portal=portal@entry=0x5620f6722680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5620f66a1258, altdest=altdest@entry=0x5620f66a1258, qc=qc@entry=0x7ffffacacc10) at ../src/backend/tcop/pquery.c:1316 [03:53:34.877] pstmt = 0x5620f66a0820 [03:53:34.877] stmtlist_item__state = [03:53:34.877] active_snapshot_set = false [03:53:34.877] stmtlist_item = 0x5620f66a1220 [03:53:34.877] #15 0x00005620f3b69a6b in PortalRun (portal=portal@entry=0x5620f6722680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5620f66a1258, altdest=altdest@entry=0x5620f66a1258, qc=0x7ffffacacc10) at ../src/backend/tcop/pquery.c:791 [03:53:34.877] _save_exception_stack = 0x7ffffacaccc0 [03:53:34.877] _save_context_stack = 0x0 [03:53:34.877] _local_sigjmp_buf = {{__jmpbuf = {0, 191497150637137264, 94699573618304, 94699573086184, 94699573618304, 94699573086112, 5842942114723913072, 191506466043977072}, __mask_was_saved = 0, __saved_mask = {__val = {94699530712524, 94699573082416, 112, 4, 94699530716941, 4207594399, 4, 94699573086112, 112, 73, 94699573618304, 94699573086184, 94699573086160, 94699573086112, 94699530804144, 1}}}} [03:53:34.877] _do_rethrow = [03:53:34.877] result = [03:53:34.877] nprocessed = [03:53:34.877] saveTopTransactionResourceOwner = 0x5620f66df838 [03:53:34.877] saveTopTransactionContext = 0x5620f6733660 [03:53:34.877] saveActivePortal = 0x0 [03:53:34.877] saveResourceOwner = 0x5620f66df838 [03:53:34.877] savePortalContext = 0x0 [03:53:34.877] saveMemoryContext = 0x5620f6733660 [03:53:34.877] __func__ = "PortalRun" [03:53:34.877] #16 0x00005620f3b62e5c in exec_simple_query (query_string=query_string@entry=0x5620f669fa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:53:34.877] cmdtaglen = 24 [03:53:34.877] snapshot_set = [03:53:34.877] per_parsetree_context = 0x0 [03:53:34.877] plantree_list = 0x5620f66a1208 [03:53:34.877] parsetree = 0x5620f66a07a0 [03:53:34.877] commandTag = [03:53:34.877] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:53:34.877] querytree_list = [03:53:34.877] portal = 0x5620f6722680 [03:53:34.877] receiver = 0x5620f66a1258 [03:53:34.877] format = 0 [03:53:34.877] cmdtagname = [03:53:34.877] parsetree_item__state = [03:53:34.877] dest = DestRemote [03:53:34.877] oldcontext = 0x5620f6733660 [03:53:34.877] parsetree_list = 0x5620f66a07d0 [03:53:34.877] parsetree_item = 0x5620f66a07e8 [03:53:34.877] save_log_statement_stats = false [03:53:34.877] was_logged = true [03:53:34.877] use_implicit_block = false [03:53:34.877] msec_str = "p\316\312\372\377\177\000\000ң\341\363 V\000\000\240\314\312\372\377\177\000\000G\000\000\000\000\000\000" [03:53:34.877] __func__ = "exec_simple_query" [03:53:34.877] #17 0x00005620f3b65be0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4790 [03:53:34.877] query_string = 0x5620f669fa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:53:34.877] firstchar = [03:53:34.877] input_message = {data = 0x5620f669fa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:53:34.877] local_sigjmp_buf = {{__jmpbuf = {94699543269944, 191491180629450096, 4, 140737400983152, 140737400983296, 140737400983300, 5842942114778439024, 191506459926584688}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94699572813232, 14336, 94699543264032, 94699573340144, 140737400983296, 94699530716489, 0, 9, 2, 94699543269952, 94699572813232, 94699543264032, 140737400983152, 140737400983296, 140737400983300}}}} [03:53:34.877] send_ready_for_query = false [03:53:34.877] idle_in_transaction_timeout_enabled = false [03:53:34.877] idle_session_timeout_enabled = false [03:53:34.877] __func__ = "PostgresMain" [03:53:34.877] #18 0x00005620f3b5ba57 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:53:34.877] bsdata = [03:53:34.877] #19 0x00005620f3a1424f in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffffacace1c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffffacace70) at ../src/backend/postmaster/launch_backend.c:274 [03:53:34.877] pid = [03:53:34.877] #20 0x00005620f3a19cfb in BackendStartup (client_sock=client_sock@entry=0x7ffffacace70) at ../src/backend/postmaster/postmaster.c:3415 [03:53:34.877] bn = 0x5620f66d4cf8 [03:53:34.877] pid = [03:53:34.877] startup_data = {canAcceptConnections = CAC_OK} [03:53:34.877] __func__ = "BackendStartup" [03:53:34.877] #21 0x00005620f3a1a25d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [03:53:34.877] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\342G\177\177\000\0004\317\312\372\377\177\000\000\312 tI\177\177\000\000>\004\000\000\000\000\000\000\260\227\343G\177\177\000\000\240?6I\177\177\000\0008\317\312\372\377\177\000\0004\317\312\372\377\177\000\000\000\000\000\000\000\000\000\000\320\316\312\372\377\177\000\000v\356\275\362 V\000\000`\327\271\362 V\000\000\000\320\312\372\377\177\000\000\370\317\312\372\377\177\000\000\225[\362\001\000\000\000", __ss_align = 140184652063904}, salen = 2}} [03:53:34.877] i = 0 [03:53:34.877] now = [03:53:34.877] last_lockfile_recheck_time = 1726890578 [03:53:34.877] last_touch_time = 1726890578 [03:53:34.877] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f7f4976c2e0}, {pos = -87371912, events = 0, fd = 0, user_data = 0x7f7f4976c668}, {pos = -222433674, events = 22048, fd = 1232520808, user_data = 0x7f7f4863a630}, {pos = 1232519904, events = 32639, fd = 2090263927, user_data = 0x7ffffacad080}, {pos = 1232349768, events = 32639, fd = 15, user_data = 0x7f7f4863a630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1232519904, events = 32639, fd = -87371784, user_data = 0x7ffffacad000}, {pos = 1232520808, events = 32639, fd = 0, user_data = 0x5620f66ce368}, {pos = -160636344, events = 22048, fd = -160636895, user_data = 0x7f7f00000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f7f47e2e020}, {pos = 1228292000, events = 32639, fd = -160636056, user_data = 0x7ffffacad3f0}, {pos = -160664888, events = 22048, fd = -160635824, user_data = 0x5620f66ce368}, {pos = 1232519904, events = 32639, fd = 438, user_data = 0x5620f4392db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x5620f669fa48}, {pos = 1232375486, events = 32639, fd = 1, user_data = 0x0}, {pos = 1206050848, events = 32639, fd = 1206857152, user_data = 0x7ffffacad460}, {pos = -87370688, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1232384442, user_data = 0x0}, {pos = 1206578468, events = 32639, fd = 0, user_data = 0x5620f4a22be0 }, {pos = 2, events = 0, fd = 7, user_data = 0x5620f6661e50}, {pos = 0, events = 0, fd = 1206084808, user_data = 0x7f7f47e9c880 }, {pos = 1214463416, events = 32639, fd = 8096, user_data = 0x100007f00000002}, {pos = 1206611591, events = 32639, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 1207901280, events = 32639, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x5620f6661e50}, {pos = 1206614538, events = 32639, fd = 1663923061, user_data = 0x5620f6661e50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffff0000000000}, {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 = 0x7f0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x962ec1ec6dadee00}, {pos = 1207887328, events = 32639, fd = -328, user_data = 0x0}, {pos = -160636664, events = 22048, fd = 1024, user_data = 0x5620f66ce108}, {pos = -87370504, events = 32767, fd = 1206615711, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 25786, events = 0, fd = -328, user_data = 0x0}, {pos = -160826808, events = 22048, fd = 1206857683, user_data = 0x7ffffacad4f8}, {pos = -203113664, events = 22048, fd = -190639632, user_data = 0x5620f3e3a5fd }, {pos = -160636864, events = 22048, fd = -160827088, user_data = 0x5620f66ce040}, {pos = 1206605547, events = 32639, fd = 0, user_data = 0x5620f3e4c267 }, {pos = -160636864, events = 1, fd = -203111504, user_data = 0x5620f669f930}, {pos = 1840115200, events = 2519646700, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1206528689, user_data = 0x7f7f47ea14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1840115200, user_data = 0x5620f6677060}, {pos = 1840115200, events = 2519646700, fd = 11, user_data = 0x962ec1ec6dadee00}, {pos = 0, events = 0, fd = 1206235705, user_data = 0x1}, {pos = -207536308, events = 22048, fd = 4194304, user_data = 0x5620f3e3a491 }, {pos = -160993184, events = 22048, fd = -160827088, user_data = 0x5620f6677060}, {pos = 1, events = 0, fd = 0, user_data = 0x5620f3e4c267 }, {pos = -160993184, events = 22048, fd = -203111504, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5620f384a703 }, {pos = 0, events = 0, fd = -209388989, user_data = 0xb}, {pos = -207515159, events = 22048, fd = -194234960, user_data = 0x5620f66a02d8}} [03:53:34.877] nevents = 1 [03:53:34.877] __func__ = "ServerLoop" [03:53:34.877] #22 0x00005620f3a1b9d3 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5620f665dcc0) at ../src/backend/postmaster/postmaster.c:1346 [03:53:34.877] opt = [03:53:34.877] status = [03:53:34.877] userDoption = [03:53:34.877] listen_addr_saved = false [03:53:34.877] output_config_variable = [03:53:34.877] __func__ = "PostmasterMain" [03:53:34.877] #23 0x00005620f385aadf in main (argc=4, argv=0x5620f665dcc0) at ../src/backend/main/main.c:197 [03:53:34.877] do_check_root =