[22:27:38.293] src/tools/ci/cores_backtrace.sh linux /tmp/cores [22:27:38.486] dumping /tmp/cores/postgres-6-29122.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:27:38.725] [New LWP 29122] [22:27:38.725] [22:27:38.725] This GDB supports auto-downloading debuginfo from the following URLs: [22:27:38.725] [22:27:38.725] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:27:38.725] Debuginfod has been disabled. [22:27:38.725] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:27:38.843] [Thread debugging using libthread_db enabled] [22:27:38.843] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:27:38.843] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [22:27:38.843] Program terminated with signal SIGABRT, Aborted. [22:27:38.843] #0 0x00007f4ca1aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:39.782] [22:27:39.782] Thread 1 (Thread 0x7f4ca17d6f00 (LWP 29122)): [22:27:39.782] #0 0x00007f4ca1aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:39.782] No symbol table info available. [22:27:39.782] #1 0x00007f4ca1a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:39.782] No symbol table info available. [22:27:39.782] #2 0x00007f4ca1a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:39.782] No symbol table info available. [22:27:39.782] #3 0x000055cbc6550946 in ExceptionalCondition (conditionName=conditionName@entry=0x55cbc67cb8fd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55cbc67cae50 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:27:39.782] No locals. [22:27:39.782] #4 0x000055cbc5ec352e in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55cbf49468c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [22:27:39.782] estate = 0x55cbf4914810 [22:27:39.782] oldcontext = 0x55cbf4949850 [22:27:39.782] __func__ = "standard_ExecutorStart" [22:27:39.782] #5 0x000055cbc5ec370a in ExecutorStart (queryDesc=queryDesc@entry=0x55cbf49468c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [22:27:39.782] No locals. [22:27:39.782] #6 0x000055cbc5de4d15 in refresh_matview_datafill (dest=0x55cbf4949220, query=, query@entry=0x55cbf4902950, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [22:27:39.782] rewritten = [22:27:39.782] plan = 0x55cbf4945f18 [22:27:39.782] queryDesc = 0x55cbf49468c0 [22:27:39.782] copied_query = [22:27:39.782] processed = [22:27:39.782] __func__ = "refresh_matview_datafill" [22:27:39.782] #7 0x000055cbc5de706f in RefreshMatViewByOid (matviewOid=28595, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [22:27:39.782] dest = [22:27:39.782] matviewRel = 0x7f4c95eede60 [22:27:39.782] rule = [22:27:39.782] actions = [22:27:39.782] dataQuery = 0x55cbf4902950 [22:27:39.782] tableSpace = [22:27:39.782] relowner = 10 [22:27:39.782] OIDNewHeap = 28607 [22:27:39.782] processed = 0 [22:27:39.782] relpersistence = 112 'p' [22:27:39.782] save_userid = 10 [22:27:39.782] save_sec_context = 0 [22:27:39.782] save_nestlevel = 2 [22:27:39.782] address = {classId = 0, objectId = 0, objectSubId = 0} [22:27:39.782] __func__ = "RefreshMatViewByOid" [22:27:39.782] #8 0x000055cbc5de71ae in ExecRefreshMatView (stmt=0x55cbf4948ef8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:27:39.782] matviewOid = [22:27:39.782] lockmode = [22:27:39.782] #9 0x000055cbc5d9cc14 in ExecCreateTableAs (pstate=pstate@entry=0x55cbf4949950, stmt=stmt@entry=0x55cbf47eb7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffee5f3cdd0) at ../src/backend/commands/createas.c:351 [22:27:39.782] refresh = [22:27:39.782] query = 0x55cbf47eb9b0 [22:27:39.782] into = 0x55cbf47eb548 [22:27:39.782] jstate = 0x0 [22:27:39.782] is_matview = true [22:27:39.782] do_refresh = false [22:27:39.782] dest = [22:27:39.782] address = {classId = 1259, objectId = 28595, objectSubId = 0} [22:27:39.782] __func__ = "ExecCreateTableAs" [22:27:39.782] #10 0x000055cbc62c2ceb in ProcessUtilitySlow (pstate=pstate@entry=0x55cbf4949950, pstmt=pstmt@entry=0x55cbf47eb8a0, queryString=queryString@entry=0x55cbf47eaab0 "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=0x55cbf47ec2d8, qc=0x7ffee5f3cdd0) at ../src/backend/tcop/utility.c:1678 [22:27:39.782] _save_exception_stack = 0x7ffee5f3ccb0 [22:27:39.782] _save_context_stack = 0x0 [22:27:39.782] _local_sigjmp_buf = {{__jmpbuf = {0, -3591040508517963882, 94334468667376, 0, 94334468663984, 0, -7331811033662642282, -3590940060694763626}, __mask_was_saved = 0, __saved_mask = {__val = {94333690920530, 94334469886536, 46264417297212, 10771, 94333690928134, 139966917897984, 139966917897984, 10771, 94333690930212, 1, 4294978067, 139966917897984, 94333690920530, 1, 46265195909704, 1}}}} [22:27:39.782] _do_rethrow = false [22:27:39.782] parsetree = 0x55cbf47eb7f0 [22:27:39.782] isTopLevel = true [22:27:39.782] isCompleteQuery = true [22:27:39.782] needCleanup = false [22:27:39.782] commandCollected = false [22:27:39.782] address = {classId = 21963, objectId = 4101945328, objectSubId = 21963} [22:27:39.782] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:27:39.782] __func__ = "ProcessUtilitySlow" [22:27:39.782] #11 0x000055cbc62c12fc in standard_ProcessUtility (pstmt=0x55cbf47eb8a0, queryString=0x55cbf47eaab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55cbf47ec2d8, qc=0x7ffee5f3cdd0) at ../src/backend/tcop/utility.c:1070 [22:27:39.782] parsetree = 0x55cbf47eb7f0 [22:27:39.782] isTopLevel = true [22:27:39.782] isAtomicContext = false [22:27:39.782] pstate = 0x55cbf4949950 [22:27:39.782] readonly_flags = [22:27:39.782] __func__ = "standard_ProcessUtility" [22:27:39.782] #12 0x000055cbc62c1457 in ProcessUtility (pstmt=pstmt@entry=0x55cbf47eb8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55cbf47ec2d8, qc=0x7ffee5f3cdd0) at ../src/backend/tcop/utility.c:523 [22:27:39.782] No locals. [22:27:39.782] #13 0x000055cbc62bce15 in PortalRunUtility (portal=portal@entry=0x55cbf486ffc0, pstmt=pstmt@entry=0x55cbf47eb8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55cbf47ec2d8, qc=qc@entry=0x7ffee5f3cdd0) at ../src/backend/tcop/pquery.c:1152 [22:27:39.782] No locals. [22:27:39.782] #14 0x000055cbc62bd3ba in PortalRunMulti (portal=portal@entry=0x55cbf486ffc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55cbf47ec2d8, altdest=altdest@entry=0x55cbf47ec2d8, qc=qc@entry=0x7ffee5f3cdd0) at ../src/backend/tcop/pquery.c:1309 [22:27:39.782] pstmt = 0x55cbf47eb8a0 [22:27:39.782] stmtlist_item__state = [22:27:39.782] active_snapshot_set = false [22:27:39.782] stmtlist_item = 0x55cbf47ec2a0 [22:27:39.782] #15 0x000055cbc62bd922 in PortalRun (portal=portal@entry=0x55cbf486ffc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55cbf47ec2d8, altdest=altdest@entry=0x55cbf47ec2d8, qc=qc@entry=0x7ffee5f3cdd0) at ../src/backend/tcop/pquery.c:787 [22:27:39.782] _save_exception_stack = 0x7ffee5f3ce80 [22:27:39.782] _save_context_stack = 0x0 [22:27:39.782] _local_sigjmp_buf = {{__jmpbuf = {0, -3591040504431663210, 94334469210048, 94334468667496, 94334468667472, 94334468667424, -7331811033524230250, -3590940080395802730}, __mask_was_saved = 0, __saved_mask = {__val = {94333694463271, 3857960287, 4, 94334468667424, 112, 73, 94334469210048, 94334468667496, 94334468667472, 94334468667424, 94333694550474, 1, 2, 73, 94333683837343, 0}}}} [22:27:39.782] _do_rethrow = [22:27:39.782] result = [22:27:39.782] nprocessed = [22:27:39.782] saveTopTransactionResourceOwner = 0x55cbf482ad38 [22:27:39.782] saveTopTransactionContext = 0x55cbf48823f0 [22:27:39.782] saveActivePortal = 0x0 [22:27:39.782] saveResourceOwner = 0x55cbf482ad38 [22:27:39.782] savePortalContext = 0x0 [22:27:39.782] saveMemoryContext = 0x55cbf48823f0 [22:27:39.782] __func__ = "PortalRun" [22:27:39.782] #16 0x000055cbc62b6dda in exec_simple_query (query_string=query_string@entry=0x55cbf47eaab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:27:39.782] cmdtaglen = 24 [22:27:39.782] snapshot_set = [22:27:39.782] per_parsetree_context = 0x0 [22:27:39.782] plantree_list = 0x55cbf47ec288 [22:27:39.782] parsetree = 0x55cbf47eb820 [22:27:39.782] commandTag = [22:27:39.782] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:39.782] querytree_list = [22:27:39.782] portal = 0x55cbf486ffc0 [22:27:39.782] receiver = 0x55cbf47ec2d8 [22:27:39.782] format = 0 [22:27:39.782] cmdtagname = [22:27:39.782] parsetree_item__state = [22:27:39.782] dest = DestRemote [22:27:39.782] oldcontext = 0x55cbf48823f0 [22:27:39.782] parsetree_list = 0x55cbf47eb850 [22:27:39.782] parsetree_item = 0x55cbf47eb868 [22:27:39.782] save_log_statement_stats = false [22:27:39.782] was_logged = false [22:27:39.782] use_implicit_block = false [22:27:39.782] msec_str = "\004\000\000\000\000\000\000\000tgW\306\313U\000\000`\316\363\345\376\177\000\000G\000\000\000\000\000\000" [22:27:39.782] __func__ = "exec_simple_query" [22:27:39.782] #17 0x000055cbc62b9b33 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [22:27:39.782] query_string = 0x55cbf47eaab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:27:39.782] firstchar = [22:27:39.782] input_message = {data = 0x55cbf47eaab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:27:39.782] local_sigjmp_buf = {{__jmpbuf = {94333707200824, -3590941869816698986, 140732756381660, 4, 5, 140732756381892, -7331811033457121386, -3590940082233301098}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94334468394448, 17408, 94333707194880, 94334468928816, 5, 94333694462819, 0, 10, 2, 94333707200832, 94334468394448, 94333707194880, 4, 5, 140732756381892}}}} [22:27:39.782] send_ready_for_query = false [22:27:39.782] idle_in_transaction_timeout_enabled = false [22:27:39.782] idle_session_timeout_enabled = false [22:27:39.782] __func__ = "PostgresMain" [22:27:39.782] #18 0x000055cbc62afb9e in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:27:39.782] bsdata = [22:27:39.782] #19 0x000055cbc6161075 in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7ffee5f3cfdc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffee5f3d030) at ../src/backend/postmaster/launch_backend.c:274 [22:27:39.782] pid = [22:27:39.782] #20 0x000055cbc6166281 in BackendStartup (client_sock=client_sock@entry=0x7ffee5f3d030) at ../src/backend/postmaster/postmaster.c:3466 [22:27:39.782] bn = 0x55cbf48130e8 [22:27:39.782] pid = [22:27:39.782] startup_data = {canAcceptConnections = CAC_OK} [22:27:39.782] cac = [22:27:39.782] __func__ = "BackendStartup" [22:27:39.782] #21 0x000055cbc61682a5 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:27:39.782] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "B&/\305\313U\000\000\310\a+\305\313U\000\000\200\321\363\345\376\177\000\000x\321\363\345\376\177\000\000\225[\362\001\000\000\000\000\240\224\210\242L\177\000\000+", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000h\266-\243L\177\000\0000\226\210\242L\177\000\000\340\262-\243L\177\000\000\316)fR\000\000\000", __ss_align = 3857961408}, salen = 2}} [22:27:39.782] i = 0 [22:27:39.782] now = [22:27:39.782] last_lockfile_recheck_time = 1736720540 [22:27:39.782] last_touch_time = 1736720540 [22:27:39.782] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -1568106960, events = 32588, fd = -1557286176, user_data = 0x7c96e577}, {pos = -437005824, events = 32766, fd = -1557456312, user_data = 0xf}, {pos = -1568106960, events = 32588, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1557286176, user_data = 0x7ffee5f3d178}, {pos = -437005952, events = 32766, fd = -1557285272, user_data = 0x0}, {pos = -193025168, events = 21963, fd = -1582597494, user_data = 0x55cbf47eab70}, {pos = 1, events = 21963, fd = 32768, user_data = 0xffffffff}, {pos = -1583161312, events = 32588, fd = -1561124960, user_data = 0x55cbf48183f8}, {pos = -192838952, events = 21963, fd = -192839503, user_data = 0x7f4ca32b7ebe}, {pos = 1, events = 0, fd = -1557286176, user_data = 0x1aa}, {pos = -961553072, events = 21963, fd = 0, user_data = 0xf9}, {pos = -193025168, events = 21963, fd = -1557430594, user_data = 0x1}, {pos = 0, events = 0, fd = -1583161312, user_data = 0x7f4ca1af2e40 }, {pos = 16, events = 0, fd = -437004816, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f4ca32ba1ba}, {pos = 0, events = 0, fd = -1582633564, user_data = 0x0}, {pos = -954553120, events = 21963, fd = 2, user_data = 0x0}, {pos = -193278352, events = 21963, fd = -970683692, user_data = 0x55cbf481d4d0}, {pos = -970679703, events = 21963, fd = -192817877, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1583127352, user_data = 0x7f4ca1a9c880 }, {pos = -1585615432, events = 32588, fd = -437004624, user_data = 0x100007f00000002}, {pos = -1582600083, events = 32588, fd = 2, user_data = 0x55cbf481d4d0}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -1581310880, events = 32588, 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 = 1265585521, fd = 168457578, user_data = 0x37363337310a6174}, {pos = 875900978, events = 808716848, 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 = -192843600, events = 21963, fd = 1080, user_data = 0x55cbf48180d0}, {pos = -967228314, events = 21963, fd = 1024, user_data = 0x7f4ca1ab58be}, {pos = -1581327904, events = 32588, fd = -1582689938, user_data = 0x100000400}, {pos = 7, events = 0, fd = -192838432, user_data = 0x100b6136a168b900}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55cbf48180d0}, {pos = 1, events = 0, fd = -192839272, user_data = 0x3}, {pos = 0, events = 0, fd = 25133, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -193025168, user_data = 0x7f4ca1af3053 }, {pos = -192839272, events = 21963, fd = 1024, user_data = 0x7ffee5f3d6b8}, {pos = -967147174, events = 21963, fd = -954488592, user_data = 0x55cbc6596c17 }, {pos = -192839472, events = 21963, fd = -193025616, user_data = 0x55cbf48180d0}, {pos = -1582606146, events = 32588, fd = 0, user_data = 0x55cbc65a8881 }, {pos = -192839472, events = 1, fd = -967145014, user_data = 0x55cbf47ea9b0}, {pos = -1586972416, events = 269181238, fd = 0, user_data = 0x7f4ca1aa2ab1}, {pos = -1582689040, events = 32588, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -193278352, user_data = 0x100b6136a168b900}, {pos = 0, events = 0, fd = -1586972416, user_data = 0xc}, {pos = -1586972416, events = 269181238, fd = 0, user_data = 0x7f4ca1a5b239 }, {pos = 250, events = 0, fd = -971633294, user_data = 0x400000}, {pos = 0, events = 0, fd = -193278352, user_data = 0x55cbc6596aab }, {pos = -193191712, events = 21963, fd = -193025616, user_data = 0x55cbf47c20e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55cbc65552b0 }, {pos = 12, events = 0, fd = -192848136, user_data = 0x55cbf4815ed8}, {pos = -954551712, events = 21963, fd = 296, user_data = 0x55cbc616358c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -971616937, events = 21963, fd = -958158576, user_data = 0x55cbf47eb388}} [22:27:39.782] nevents = 1 [22:27:39.782] __func__ = "ServerLoop" [22:27:39.782] #22 0x000055cbc6169b04 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55cbf47a8d30) at ../src/backend/postmaster/postmaster.c:1377 [22:27:39.782] opt = [22:27:39.782] status = [22:27:39.782] userDoption = [22:27:39.782] listen_addr_saved = false [22:27:39.782] output_config_variable = [22:27:39.782] __func__ = "PostmasterMain" [22:27:39.782] #23 0x000055cbc5fa0344 in main (argc=8, argv=0x55cbf47a8d30) at ../src/backend/main/main.c:230 [22:27:39.782] do_check_root = [22:27:39.782] dispatch_option = [22:27:39.816] -e [22:27:39.816] [22:27:39.816] [22:27:39.877] dumping /tmp/cores/postgres-6-36348.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:27:40.118] [New LWP 36348] [22:27:40.118] [22:27:40.118] This GDB supports auto-downloading debuginfo from the following URLs: [22:27:40.118] [22:27:40.118] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:27:40.118] Debuginfod has been disabled. [22:27:40.118] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:27:40.221] [Thread debugging using libthread_db enabled] [22:27:40.221] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:27:40.221] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [22:27:40.221] Program terminated with signal SIGABRT, Aborted. [22:27:40.221] #0 0x00007f93852a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:41.145] [22:27:41.145] Thread 1 (Thread 0x7f93851e8f00 (LWP 36348)): [22:27:41.145] #0 0x00007f93852a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:41.145] No symbol table info available. [22:27:41.145] #1 0x00007f938525afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:41.145] No symbol table info available. [22:27:41.145] #2 0x00007f9385245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:41.145] No symbol table info available. [22:27:41.145] #3 0x0000556ba07bc946 in ExceptionalCondition (conditionName=conditionName@entry=0x556ba0a378fd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x556ba0a36e50 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:27:41.145] No locals. [22:27:41.145] #4 0x0000556ba012f52e in standard_ExecutorStart (queryDesc=0x556bca67c000, eflags=0) at ../src/backend/executor/execMain.c:193 [22:27:41.145] estate = 0x556bca613510 [22:27:41.145] oldcontext = 0x556bca781d10 [22:27:41.145] __func__ = "standard_ExecutorStart" [22:27:41.145] #5 0x00007f93829e26e9 in pgss_ExecutorStart (queryDesc=0x556bca67c000, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [22:27:41.145] No locals. [22:27:41.145] #6 0x0000556ba012f6c3 in ExecutorStart (queryDesc=queryDesc@entry=0x556bca67c000, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [22:27:41.145] No locals. [22:27:41.145] #7 0x0000556ba0050d15 in refresh_matview_datafill (dest=0x556bca77d2b0, query=, query@entry=0x556bca68a0c0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [22:27:41.145] rewritten = [22:27:41.145] plan = 0x556bca67b628 [22:27:41.145] queryDesc = 0x556bca67c000 [22:27:41.145] copied_query = [22:27:41.145] processed = [22:27:41.145] __func__ = "refresh_matview_datafill" [22:27:41.145] #8 0x0000556ba005306f in RefreshMatViewByOid (matviewOid=28510, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [22:27:41.145] dest = [22:27:41.145] matviewRel = 0x7f9380cdfd10 [22:27:41.145] rule = [22:27:41.145] actions = [22:27:41.145] dataQuery = 0x556bca68a0c0 [22:27:41.145] tableSpace = [22:27:41.145] relowner = 10 [22:27:41.145] OIDNewHeap = 28521 [22:27:41.145] processed = 0 [22:27:41.145] relpersistence = 112 'p' [22:27:41.145] save_userid = 10 [22:27:41.145] save_sec_context = 0 [22:27:41.145] save_nestlevel = 2 [22:27:41.145] address = {classId = 0, objectId = 0, objectSubId = 0} [22:27:41.145] __func__ = "RefreshMatViewByOid" [22:27:41.145] #9 0x0000556ba00531ae in ExecRefreshMatView (stmt=0x556bca77cf88, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:27:41.145] matviewOid = [22:27:41.145] lockmode = [22:27:41.145] #10 0x0000556ba0008c14 in ExecCreateTableAs (pstate=pstate@entry=0x556bca781e10, stmt=stmt@entry=0x556bca51f790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd7b456280) at ../src/backend/commands/createas.c:351 [22:27:41.145] refresh = [22:27:41.145] query = 0x556bca51f950 [22:27:41.145] into = 0x556bca51f4e8 [22:27:41.145] jstate = 0x0 [22:27:41.145] is_matview = true [22:27:41.145] do_refresh = false [22:27:41.145] dest = [22:27:41.145] address = {classId = 1259, objectId = 28510, objectSubId = 0} [22:27:41.145] __func__ = "ExecCreateTableAs" [22:27:41.145] #11 0x0000556ba052eceb in ProcessUtilitySlow (pstate=pstate@entry=0x556bca781e10, pstmt=pstmt@entry=0x556bca51f840, queryString=queryString@entry=0x556bca51ea50 "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=0x556bca5207e8, qc=0x7ffd7b456280) at ../src/backend/tcop/utility.c:1678 [22:27:41.145] _save_exception_stack = 0x7ffd7b455e50 [22:27:41.145] _save_context_stack = 0x0 [22:27:41.145] _local_sigjmp_buf = {{__jmpbuf = {0, -7761057354325466876, 93921444231056, 0, 93921444227664, 0, -4510832912748289788, -7760833063196466940}, __mask_was_saved = 0, __saved_mask = {__val = {93920732638217, 93921444840112, 93920732658777, 6487854739674020114, 12826949595698196639, 13078921423356586303, 17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 93920739074065, 0, 140726671597184, 0, 93920742918646, 140726671596380}}}} [22:27:41.145] _do_rethrow = false [22:27:41.145] parsetree = 0x556bca51f790 [22:27:41.145] isTopLevel = true [22:27:41.145] isCompleteQuery = true [22:27:41.145] needCleanup = false [22:27:41.145] commandCollected = false [22:27:41.145] address = {classId = 21867, objectId = 3394369424, objectSubId = 21867} [22:27:41.145] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:27:41.145] __func__ = "ProcessUtilitySlow" [22:27:41.145] #12 0x0000556ba052d2fc in standard_ProcessUtility (pstmt=pstmt@entry=0x556bca51f840, queryString=queryString@entry=0x556bca51ea50 "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=0x556bca5207e8, qc=0x7ffd7b456280) at ../src/backend/tcop/utility.c:1070 [22:27:41.145] parsetree = 0x556bca51f790 [22:27:41.145] isTopLevel = true [22:27:41.145] isAtomicContext = false [22:27:41.145] pstate = 0x556bca781e10 [22:27:41.145] readonly_flags = [22:27:41.145] __func__ = "standard_ProcessUtility" [22:27:41.145] #13 0x00007f93829e5d8f in pgss_ProcessUtility (pstmt=0x556bca51f840, queryString=0x556bca51ea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x556bca5207e8, qc=0x7ffd7b456280) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [22:27:41.145] _save_exception_stack = 0x7ffd7b456160 [22:27:41.145] _save_context_stack = 0x0 [22:27:41.145] _local_sigjmp_buf = {{__jmpbuf = {0, 4511687459641188612, 93921444231232, 93921444235240, 140726671598208, 0, -4510832912651820796, -4486782684927139580}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140726671597440, 93920742926345, 1, 206158430232, 93921444232032, 140726671597536, 0, 93920737704978, 93921444227408, 93920742587315, 3, 93920736433109, 93921444231232}}}} [22:27:41.145] _do_rethrow = false [22:27:41.145] duration = [22:27:41.145] bufusage = {shared_blks_hit = 46, shared_blks_read = 93920739075855, shared_blks_dirtied = 93921445230920, shared_blks_written = 93920735567275, local_blks_hit = 93920736017067, local_blks_read = 93921445232984, local_blks_dirtied = 93921445230920, local_blks_written = 93920742919580, temp_blks_read = 140271570292152, temp_blks_written = 93921444227664, shared_blk_read_time = {ticks = 93920745275411}, shared_blk_write_time = {ticks = 93920755337122}, local_blk_read_time = {ticks = 93920755337248}, local_blk_write_time = {ticks = 140726671597444}, temp_blk_read_time = {ticks = 93920745469209}, temp_blk_write_time = {ticks = 93920755337137}} [22:27:41.145] walusage_start = {wal_records = 8973, wal_fpi = 97, wal_bytes = 1078009} [22:27:41.145] start = [22:27:41.145] rows = [22:27:41.145] bufusage_start = {shared_blks_hit = 34509, shared_blks_read = 4109, shared_blks_dirtied = 1484, shared_blks_written = 995, 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}} [22:27:41.145] walusage = {wal_records = 1, wal_fpi = 4294967342, wal_bytes = 140271500732608} [22:27:41.145] parsetree = [22:27:41.145] saved_queryId = 6041762721901209185 [22:27:41.145] saved_stmt_location = 0 [22:27:41.145] saved_stmt_len = 69 [22:27:41.145] enabled = true [22:27:41.145] #14 0x0000556ba052d3a2 in ProcessUtility (pstmt=pstmt@entry=0x556bca51f840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x556bca5207e8, qc=0x7ffd7b456280) at ../src/backend/tcop/utility.c:519 [22:27:41.145] No locals. [22:27:41.145] #15 0x0000556ba0528e15 in PortalRunUtility (portal=portal@entry=0x556bca5a1940, pstmt=pstmt@entry=0x556bca51f840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556bca5207e8, qc=qc@entry=0x7ffd7b456280) at ../src/backend/tcop/pquery.c:1152 [22:27:41.145] No locals. [22:27:41.145] #16 0x0000556ba05293ba in PortalRunMulti (portal=portal@entry=0x556bca5a1940, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556bca5207e8, altdest=altdest@entry=0x556bca5207e8, qc=qc@entry=0x7ffd7b456280) at ../src/backend/tcop/pquery.c:1309 [22:27:41.145] pstmt = 0x556bca51f840 [22:27:41.145] stmtlist_item__state = [22:27:41.145] active_snapshot_set = false [22:27:41.145] stmtlist_item = 0x556bca5207b0 [22:27:41.145] #17 0x0000556ba0529922 in PortalRun (portal=portal@entry=0x556bca5a1940, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x556bca5207e8, altdest=altdest@entry=0x556bca5207e8, qc=qc@entry=0x7ffd7b456280) at ../src/backend/tcop/pquery.c:787 [22:27:41.145] _save_exception_stack = 0x7ffd7b456330 [22:27:41.145] _save_context_stack = 0x0 [22:27:41.145] _local_sigjmp_buf = {{__jmpbuf = {0, -7761057360823492348, 93921444763968, 93921444231176, 93921444231152, 93921444231104, -4510832910900698876, -7760833065767968508}, __mask_was_saved = 0, __saved_mask = {__val = {93920742608167, 2068144655, 4, 93921444231104, 112, 73, 93921444763968, 93921444231176, 93921444231152, 93921444231104, 93920742695370, 1, 2, 73, 93920731982239, 0}}}} [22:27:41.145] _do_rethrow = [22:27:41.145] result = [22:27:41.145] nprocessed = [22:27:41.145] saveTopTransactionResourceOwner = 0x556bca560e18 [22:27:41.145] saveTopTransactionContext = 0x556bca5b4180 [22:27:41.145] saveActivePortal = 0x0 [22:27:41.145] saveResourceOwner = 0x556bca560e18 [22:27:41.145] savePortalContext = 0x0 [22:27:41.145] saveMemoryContext = 0x556bca5b4180 [22:27:41.145] __func__ = "PortalRun" [22:27:41.145] #18 0x0000556ba0522dda in exec_simple_query (query_string=query_string@entry=0x556bca51ea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:27:41.145] cmdtaglen = 24 [22:27:41.145] snapshot_set = [22:27:41.145] per_parsetree_context = 0x0 [22:27:41.145] plantree_list = 0x556bca520798 [22:27:41.145] parsetree = 0x556bca51f7c0 [22:27:41.145] commandTag = [22:27:41.145] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:41.145] querytree_list = [22:27:41.145] portal = 0x556bca5a1940 [22:27:41.145] receiver = 0x556bca5207e8 [22:27:41.145] format = 0 [22:27:41.145] cmdtagname = [22:27:41.145] parsetree_item__state = [22:27:41.145] dest = DestRemote [22:27:41.145] oldcontext = 0x556bca5b4180 [22:27:41.145] parsetree_list = 0x556bca51f7f0 [22:27:41.145] parsetree_item = 0x556bca51f808 [22:27:41.145] save_log_statement_stats = false [22:27:41.145] was_logged = true [22:27:41.145] use_implicit_block = false [22:27:41.145] msec_str = "\004\000\000\000\000\000\000\000t'~\240kU\000\000\020cE{\375\177\000\000G\000\000\000\000\000\000" [22:27:41.145] __func__ = "exec_simple_query" [22:27:41.145] #19 0x0000556ba0525b33 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [22:27:41.145] query_string = 0x556bca51ea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:27:41.145] firstchar = [22:27:41.145] input_message = {data = 0x556bca51ea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:27:41.145] local_sigjmp_buf = {{__jmpbuf = {93920755345720, -7760835394140151548, 140726671598732, 4, 17, 140726671598964, -4510832910833590012, -7760833058965200636}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 93921444483824, 0, 168, 93920742608269, 0, 10, 2, 93920755345728, 93921443958256, 93920755339776, 4, 17, 140726671598964}}}} [22:27:41.145] send_ready_for_query = false [22:27:41.145] idle_in_transaction_timeout_enabled = false [22:27:41.145] idle_session_timeout_enabled = false [22:27:41.145] __func__ = "PostgresMain" [22:27:41.145] #20 0x0000556ba051bb9e in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:27:41.145] bsdata = [22:27:41.145] #21 0x0000556ba03cd075 in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7ffd7b45648c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd7b4564e0) at ../src/backend/postmaster/launch_backend.c:274 [22:27:41.145] pid = [22:27:41.145] #22 0x0000556ba03d2281 in BackendStartup (client_sock=client_sock@entry=0x7ffd7b4564e0) at ../src/backend/postmaster/postmaster.c:3466 [22:27:41.145] bn = 0x556bca54a4a8 [22:27:41.145] pid = [22:27:41.145] startup_data = {canAcceptConnections = CAC_OK} [22:27:41.145] cac = [22:27:41.145] __func__ = "BackendStartup" [22:27:41.145] #23 0x0000556ba03d42a5 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:27:41.145] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "E{\375\177\000\000teE{\375\177", '\000' , "B\346U\237kU\000\000\310\307Q\237kU\000\000@fE{\375\177\000\0008fE{\375\177\000\000\225[\362\001\000\000\000\000\260\226T\312kU\000\000,", '\000' , "P\345U\237kU\000\000h\306\300\206\223\177\000\0000\306r\206\223\177\000", __ss_align = 140271597699808}, salen = 2}} [22:27:41.145] i = 0 [22:27:41.145] now = [22:27:41.145] last_lockfile_recheck_time = 1736720576 [22:27:41.145] last_touch_time = 1736720576 [22:27:41.145] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1621760446, events = 21867, fd = -2034186648, user_data = 0x7f938672c630}, {pos = -2034187552, events = 32659, fd = 2090263927, user_data = 0x7ffd7b4566c0}, {pos = -2034357688, events = 32659, fd = 15, user_data = 0x7f938672c630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -2034187552, events = 32659, fd = 2068145720, user_data = 0x7ffd7b456640}, {pos = -2034186648, events = 32659, fd = 0, user_data = 0x556bca54c1b8}, {pos = -1601903074, events = 21867, fd = 32768, user_data = 0x1}, {pos = -900598416, events = 21867, fd = -1, user_data = 0x7f938522e020}, {pos = -2039107680, events = 32659, fd = -900380600, user_data = 0x556bca554728}, {pos = -900404207, events = 21867, fd = -2034331970, user_data = 0x1}, {pos = -2034187552, events = 32659, fd = 426, user_data = 0x556ba0d69d50 }, {pos = 0, events = 0, fd = 86, user_data = 0x556bca54c1b8}, {pos = -2034331970, events = 32659, fd = 1, user_data = 0x0}, {pos = -2061311968, events = 32659, fd = -2060505536, user_data = 0x10}, {pos = 2068146848, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2034323014, user_data = 0x0}, {pos = -2060784220, events = 32659, fd = 0, user_data = 0x556ba1416ce0 }, {pos = 2, events = 0, fd = 0, user_data = 0x556bca4e0e90}, {pos = -1605674391, events = 21867, fd = -900385429, user_data = 0x556ba04b96a2 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x556bca54c1b8}, {pos = -2034331970, events = 32659, fd = 1, user_data = 0x0}, {pos = -2061278008, events = 32659, fd = -2060859264, user_data = 0x43d}, {pos = -2060751097, events = 32659, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -2059461536, events = 32659, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -2039294656, user_data = 0x7f938672da80}, {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 = 0x556bca554520}, {pos = -1602223002, events = 21867, fd = 1024, user_data = 0x7f93852b576b}, {pos = -2059478560, events = 32659, fd = -2060840594, user_data = 0x100000400}, {pos = 7, events = 0, fd = -900385520, user_data = 0xa58ff6c54ffd9e00}, {pos = -2059475488, events = 32659, 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 = -900381208, user_data = 0x3}, {pos = 0, events = 0, fd = 32061, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -900415048, user_data = 0x7f93852f3053 }, {pos = -900381208, events = 21867, fd = 1024, user_data = 0x7ffd7b456b68}, {pos = -1602141862, events = 21867, fd = -1589483280, user_data = 0x556ba0802c17 }, {pos = -900381408, events = 21867, fd = -900601520, user_data = 0x556bca554520}, {pos = -2060757141, events = 32659, fd = 0, user_data = 0x556ba0814881 }, {pos = -900381408, events = 1, fd = -1602139702, user_data = 0x556bca51e950}, {pos = 1342021120, events = 2777675461, fd = 0, user_data = 0x7f93852a2ab1}, {pos = -2060839696, events = 32659, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -900854128, user_data = 0xa58ff6c54ffd9e00}, {pos = 0, events = 0, fd = 1342021120, user_data = 0xc}, {pos = 1342021120, events = 2777675461, fd = 0, user_data = 0x7f938525b239 }, {pos = 87, events = 0, fd = -1606627982, user_data = 0x400000}, {pos = 0, events = 0, fd = -900854128, user_data = 0x556ba0802aab }, {pos = -900767616, events = 21867, fd = -900601520, user_data = 0x556bca4f6080}, {pos = 1, events = 0, fd = 0, user_data = 0x556ba07c12b0 }, {pos = 12, events = 0, fd = -900419096, user_data = 0x556bca54b1c8}, {pos = -1589546400, events = 21867, fd = 296, user_data = 0x556ba03cf58c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1606611625, events = 21867, fd = -1593153264, user_data = 0x556bca51f308}} [22:27:41.145] nevents = 1 [22:27:41.145] __func__ = "ServerLoop" [22:27:41.145] #24 0x0000556ba03d5b04 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x556bca4dccf0) at ../src/backend/postmaster/postmaster.c:1377 [22:27:41.145] opt = [22:27:41.145] status = [22:27:41.145] userDoption = [22:27:41.145] listen_addr_saved = false [22:27:41.145] output_config_variable = [22:27:41.145] __func__ = "PostmasterMain" [22:27:41.145] #25 0x0000556ba020c344 in main (argc=4, argv=0x556bca4dccf0) at ../src/backend/main/main.c:230 [22:27:41.145] do_check_root = [22:27:41.145] dispatch_option = [22:27:41.181] -e [22:27:41.181] [22:27:41.181] [22:27:41.243] dumping /tmp/cores/postgres-6-29676.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:27:41.494] [New LWP 29676] [22:27:41.494] [22:27:41.494] This GDB supports auto-downloading debuginfo from the following URLs: [22:27:41.494] [22:27:41.494] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:27:41.494] Debuginfod has been disabled. [22:27:41.494] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:27:41.596] [Thread debugging using libthread_db enabled] [22:27:41.596] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:27:41.596] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [22:27:41.596] Program terminated with signal SIGABRT, Aborted. [22:27:41.596] #0 0x00007fc783ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:42.504] [22:27:42.504] Thread 1 (Thread 0x7fc784c87f00 (LWP 29676)): [22:27:42.504] #0 0x00007fc783ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:42.504] No symbol table info available. [22:27:42.504] #1 0x00007fc783e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:42.504] No symbol table info available. [22:27:42.504] #2 0x00007fc783e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:27:42.504] No symbol table info available. [22:27:42.504] #3 0x00005573171e5946 in ExceptionalCondition (conditionName=conditionName@entry=0x5573174608fd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55731745fe50 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:27:42.504] No locals. [22:27:42.504] #4 0x0000557316b5852e in standard_ExecutorStart (queryDesc=queryDesc@entry=0x557318a6a150, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [22:27:42.504] estate = 0x557318a9f2e0 [22:27:42.504] oldcontext = 0x557318b67230 [22:27:42.504] __func__ = "standard_ExecutorStart" [22:27:42.504] #5 0x0000557316b5870a in ExecutorStart (queryDesc=queryDesc@entry=0x557318a6a150, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [22:27:42.504] No locals. [22:27:42.504] #6 0x0000557316a79d15 in refresh_matview_datafill (dest=0x557318a7ddd0, query=, query@entry=0x557318ab3be0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [22:27:42.504] rewritten = [22:27:42.504] plan = 0x557318a697a8 [22:27:42.504] queryDesc = 0x557318a6a150 [22:27:42.504] copied_query = [22:27:42.504] processed = [22:27:42.504] __func__ = "refresh_matview_datafill" [22:27:42.504] #7 0x0000557316a7c06f in RefreshMatViewByOid (matviewOid=28546, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [22:27:42.504] dest = [22:27:42.504] matviewRel = 0x7fc77874a7f0 [22:27:42.504] rule = [22:27:42.504] actions = [22:27:42.504] dataQuery = 0x557318ab3be0 [22:27:42.504] tableSpace = [22:27:42.504] relowner = 10 [22:27:42.504] OIDNewHeap = 28553 [22:27:42.504] processed = 0 [22:27:42.504] relpersistence = 112 'p' [22:27:42.504] save_userid = 10 [22:27:42.504] save_sec_context = 0 [22:27:42.504] save_nestlevel = 2 [22:27:42.504] address = {classId = 0, objectId = 0, objectSubId = 0} [22:27:42.504] __func__ = "RefreshMatViewByOid" [22:27:42.504] #8 0x0000557316a7c1ae in ExecRefreshMatView (stmt=0x557318a7daa8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:27:42.504] matviewOid = [22:27:42.504] lockmode = [22:27:42.504] #9 0x0000557316a31c14 in ExecCreateTableAs (pstate=pstate@entry=0x557318b67330, stmt=stmt@entry=0x557318907770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe7ed5f050) at ../src/backend/commands/createas.c:351 [22:27:42.504] refresh = [22:27:42.504] query = 0x557318907930 [22:27:42.504] into = 0x5573189074c8 [22:27:42.504] jstate = 0x0 [22:27:42.504] is_matview = true [22:27:42.504] do_refresh = false [22:27:42.504] dest = [22:27:42.504] address = {classId = 1259, objectId = 28546, objectSubId = 0} [22:27:42.504] __func__ = "ExecCreateTableAs" [22:27:42.504] #10 0x0000557316f57ceb in ProcessUtilitySlow (pstate=pstate@entry=0x557318b67330, pstmt=pstmt@entry=0x557318907820, queryString=queryString@entry=0x557318906a30 "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=0x557318908258, qc=0x7ffe7ed5f050) at ../src/backend/tcop/utility.c:1678 [22:27:42.504] _save_exception_stack = 0x7ffe7ed5ef30 [22:27:42.504] _save_context_stack = 0x0 [22:27:42.504] _local_sigjmp_buf = {{__jmpbuf = {0, -1355297105657049716, 93952821720944, 0, 93952821717552, 0, -5175822354932937332, -1355274814073582196}, __mask_was_saved = 0, __saved_mask = {__val = {93952794201682, 93952823270312, 93952798055836, 140494902951352, 93952821717552, 93952800411667, 93952810473378, 93952810473504, 140731026369876, 93952800605465, 93952810473393, 93952810473504, 140731026369908, 93952800605480, 93952810473504, 11}}}} [22:27:42.504] _do_rethrow = false [22:27:42.504] parsetree = 0x557318907770 [22:27:42.504] isTopLevel = true [22:27:42.504] isCompleteQuery = true [22:27:42.504] needCleanup = false [22:27:42.504] commandCollected = false [22:27:42.504] address = {classId = 21875, objectId = 412120944, objectSubId = 21875} [22:27:42.504] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:27:42.504] __func__ = "ProcessUtilitySlow" [22:27:42.504] #11 0x0000557316f562fc in standard_ProcessUtility (pstmt=0x557318907820, queryString=0x557318906a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x557318908258, qc=0x7ffe7ed5f050) at ../src/backend/tcop/utility.c:1070 [22:27:42.504] parsetree = 0x557318907770 [22:27:42.504] isTopLevel = true [22:27:42.504] isAtomicContext = false [22:27:42.504] pstate = 0x557318b67330 [22:27:42.504] readonly_flags = [22:27:42.504] __func__ = "standard_ProcessUtility" [22:27:42.504] #12 0x0000557316f56457 in ProcessUtility (pstmt=pstmt@entry=0x557318907820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x557318908258, qc=0x7ffe7ed5f050) at ../src/backend/tcop/utility.c:523 [22:27:42.504] No locals. [22:27:42.504] #13 0x0000557316f51e15 in PortalRunUtility (portal=portal@entry=0x55731898b9c0, pstmt=pstmt@entry=0x557318907820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x557318908258, qc=qc@entry=0x7ffe7ed5f050) at ../src/backend/tcop/pquery.c:1152 [22:27:42.504] No locals. [22:27:42.504] #14 0x0000557316f523ba in PortalRunMulti (portal=portal@entry=0x55731898b9c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x557318908258, altdest=altdest@entry=0x557318908258, qc=qc@entry=0x7ffe7ed5f050) at ../src/backend/tcop/pquery.c:1309 [22:27:42.504] pstmt = 0x557318907820 [22:27:42.504] stmtlist_item__state = [22:27:42.504] active_snapshot_set = false [22:27:42.504] stmtlist_item = 0x557318908220 [22:27:42.504] #15 0x0000557316f52922 in PortalRun (portal=portal@entry=0x55731898b9c0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x557318908258, altdest=altdest@entry=0x557318908258, qc=qc@entry=0x7ffe7ed5f050) at ../src/backend/tcop/pquery.c:787 [22:27:42.504] _save_exception_stack = 0x7ffe7ed5f100 [22:27:42.504] _save_context_stack = 0x0 [22:27:42.504] _local_sigjmp_buf = {{__jmpbuf = {0, -1355297101688189556, 93952822262208, 93952821721064, 93952821721040, 93952821720992, -5175822355062960756, -1355274816377696884}, __mask_was_saved = 0, __saved_mask = {__val = {93952797744423, 2127949791, 4, 93952821720992, 112, 73, 93952822262208, 93952821721064, 93952821721040, 93952821720992, 93952797831626, 1, 2, 73, 93952787118495, 0}}}} [22:27:42.504] _do_rethrow = [22:27:42.504] result = [22:27:42.504] nprocessed = [22:27:42.504] saveTopTransactionResourceOwner = 0x557318948478 [22:27:42.504] saveTopTransactionContext = 0x55731899d9e0 [22:27:42.504] saveActivePortal = 0x0 [22:27:42.504] saveResourceOwner = 0x557318948478 [22:27:42.504] savePortalContext = 0x0 [22:27:42.504] saveMemoryContext = 0x55731899d9e0 [22:27:42.504] __func__ = "PortalRun" [22:27:42.504] #16 0x0000557316f4bdda in exec_simple_query (query_string=query_string@entry=0x557318906a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:27:42.504] cmdtaglen = 24 [22:27:42.504] snapshot_set = [22:27:42.504] per_parsetree_context = 0x0 [22:27:42.504] plantree_list = 0x557318908208 [22:27:42.504] parsetree = 0x5573189077a0 [22:27:42.504] commandTag = [22:27:42.504] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:27:42.504] querytree_list = [22:27:42.504] portal = 0x55731898b9c0 [22:27:42.504] receiver = 0x557318908258 [22:27:42.504] format = 0 [22:27:42.504] cmdtagname = [22:27:42.504] parsetree_item__state = [22:27:42.504] dest = DestRemote [22:27:42.504] oldcontext = 0x55731899d9e0 [22:27:42.504] parsetree_list = 0x5573189077d0 [22:27:42.504] parsetree_item = 0x5573189077e8 [22:27:42.504] save_log_statement_stats = false [22:27:42.504] was_logged = true [22:27:42.504] use_implicit_block = false [22:27:42.504] msec_str = "\004\000\000\000\000\000\000\000t\267 \027sU\000\000\340\360\325~\376\177\000\000G\000\000\000\000\000\000" [22:27:42.504] __func__ = "exec_simple_query" [22:27:42.504] #17 0x0000557316f4eb33 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [22:27:42.504] query_string = 0x557318906a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:27:42.504] firstchar = [22:27:42.504] input_message = {data = 0x557318906a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:27:42.504] local_sigjmp_buf = {{__jmpbuf = {93952810481976, -1355272740261442164, 140731026371164, 4, 7, 140731026371396, -5175822355130069620, -1355274801118687860}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93952821448112, 16128, 93952810476032, 93952821982256, 7, 93952797743971, 0, 9, 2, 93952810481984, 93952821448112, 93952810476032, 4, 7, 140731026371396}}}} [22:27:42.504] send_ready_for_query = false [22:27:42.504] idle_in_transaction_timeout_enabled = false [22:27:42.504] idle_session_timeout_enabled = false [22:27:42.504] __func__ = "PostgresMain" [22:27:42.504] #18 0x0000557316f44b9e in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:27:42.504] bsdata = [22:27:42.504] #19 0x0000557316df6075 in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7ffe7ed5f25c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe7ed5f2b0) at ../src/backend/postmaster/launch_backend.c:274 [22:27:42.504] pid = [22:27:42.504] #20 0x0000557316dfb281 in BackendStartup (client_sock=client_sock@entry=0x7ffe7ed5f2b0) at ../src/backend/postmaster/postmaster.c:3466 [22:27:42.504] bn = 0x55731892f048 [22:27:42.504] pid = [22:27:42.504] startup_data = {canAcceptConnections = CAC_OK} [22:27:42.504] cac = [22:27:42.504] __func__ = "BackendStartup" [22:27:42.504] #21 0x0000557316dfd2a5 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:27:42.504] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "Bv\370\025sU\000\000\310W\364\025sU\000\000\000\364\325~\376\177\000\000\370\363\325~\376\177\000\000\225[\362\001\000\000\000\000\240\344Ȅ\307\177\000\000+", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000h愅\307\177\000\0000\346Ȅ\307\177\000\000\340℅\307\177\000\000\316)fR\000\000\000", __ss_align = 2127950912}, salen = 2}} [22:27:42.504] i = 0 [22:27:42.504] now = [22:27:42.504] last_lockfile_recheck_time = 1736720542 [22:27:42.504] last_touch_time = 1736720542 [22:27:42.504] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -2067208656, events = 32711, fd = -2054888736, user_data = 0x7c96e577}, {pos = 2127950976, events = 32766, fd = -2055058872, user_data = 0xf}, {pos = -2067208656, events = 32711, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -2054888736, user_data = 0x7ffe7ed5f3f8}, {pos = 2127950848, events = 32766, fd = -2054887832, user_data = 0x0}, {pos = 412117576, events = 21875, fd = -2081719670, user_data = 0x557318906a48}, {pos = 1, events = 21875, fd = 32768, user_data = 0xffffffff}, {pos = -2082283488, events = 32711, fd = -2059808864, user_data = 0x557318933f38}, {pos = 412302872, events = 21875, fd = 412302321, user_data = 0x7fc78582aebe}, {pos = 1, events = 0, fd = -2054888736, user_data = 0x1aa}, {pos = 393817424, events = 21875, fd = 0, user_data = 0xe5}, {pos = 412117576, events = 21875, fd = -2055033154, user_data = 0x1}, {pos = 0, events = 0, fd = -2082283488, user_data = 0x7fc783ef2e40 }, {pos = 16, events = 0, fd = 2127951984, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fc78582d1ba}, {pos = 0, events = 0, fd = -2081755740, user_data = 0x0}, {pos = 400817376, events = 21875, fd = 2, user_data = 0x0}, {pos = 411864656, events = 21875, fd = 384686804, user_data = 0x5573189393d0}, {pos = 384690793, events = 21875, fd = 412324907, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -2082249528, user_data = 0x7fc783e9c880 }, {pos = -2067235400, events = 32711, fd = 2127952176, user_data = 0x100007f00000002}, {pos = -2081722259, events = 32711, fd = 2, user_data = 0x5573189393d0}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -2080433056, events = 32711, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 171061792, events = 911296082, fd = 1734619953, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, 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 = 412308032, events = 21875, fd = 1080, user_data = 0x557318933c10}, {pos = 388142182, events = 21875, fd = 1024, user_data = 0x7fc783eb58be}, {pos = -2080450080, events = 32711, fd = -2081812114, user_data = 0x100000400}, {pos = 7, events = 0, fd = 412303392, user_data = 0xf3b6cc1ef1c7700}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x557318933c10}, {pos = 1, events = 0, fd = 412302552, user_data = 0x3}, {pos = 0, events = 0, fd = 25754, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 412117576, user_data = 0x7fc783ef3053 }, {pos = 412302552, events = 21875, fd = 1024, user_data = 0x7ffe7ed5f938}, {pos = 388223322, events = 21875, fd = 400881904, user_data = 0x55731722bc17 }, {pos = 412302352, events = 21875, fd = 412117296, user_data = 0x557318933c10}, {pos = -2081728322, events = 32711, fd = 0, user_data = 0x55731723d881 }, {pos = 412302352, events = 1, fd = 388225482, user_data = 0x557318906930}, {pos = -283347200, events = 255552705, fd = 0, user_data = 0x7fc783ea2ab1}, {pos = -2081811216, events = 32711, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 411864656, user_data = 0xf3b6cc1ef1c7700}, {pos = 0, events = 0, fd = -283347200, user_data = 0xc}, {pos = -283347200, events = 255552705, fd = 0, user_data = 0x7fc783e5b239 }, {pos = 230, events = 0, fd = 383737202, user_data = 0x400000}, {pos = 0, events = 0, fd = 411864656, user_data = 0x55731722baab }, {pos = 411951200, events = 21875, fd = 412117296, user_data = 0x5573188de060}, {pos = 1, events = 0, fd = 0, user_data = 0x5573171ea2b0 }, {pos = 12, events = 0, fd = 412293688, user_data = 0x557318931a18}, {pos = 400818784, events = 21875, fd = 296, user_data = 0x557316df858c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 383753559, events = 21875, fd = 397211920, user_data = 0x5573189072d8}} [22:27:42.505] nevents = 1 [22:27:42.505] __func__ = "ServerLoop" [22:27:42.505] #22 0x0000557316dfeb04 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5573188c4cc0) at ../src/backend/postmaster/postmaster.c:1377 [22:27:42.505] opt = [22:27:42.505] status = [22:27:42.505] userDoption = [22:27:42.505] listen_addr_saved = false [22:27:42.505] output_config_variable = [22:27:42.505] __func__ = "PostmasterMain" [22:27:42.505] #23 0x0000557316c35344 in main (argc=4, argv=0x5573188c4cc0) at ../src/backend/main/main.c:230 [22:27:42.505] do_check_root = [22:27:42.505] dispatch_option =