[22:26:03.904] src/tools/ci/cores_backtrace.sh linux /tmp/cores [22:26:04.117] dumping /tmp/cores/postgres-6-29329.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:26:04.374] [New LWP 29329] [22:26:04.374] [22:26:04.374] This GDB supports auto-downloading debuginfo from the following URLs: [22:26:04.374] [22:26:04.374] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:26:04.374] Debuginfod has been disabled. [22:26:04.374] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:26:04.505] [Thread debugging using libthread_db enabled] [22:26:04.505] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:26:04.505] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [22:26:04.505] Program terminated with signal SIGABRT, Aborted. [22:26:04.505] #0 0x00007f1d4d4a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:05.416] [22:26:05.416] Thread 1 (Thread 0x7f1d4d1ddf00 (LWP 29329)): [22:26:05.416] #0 0x00007f1d4d4a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:05.416] No symbol table info available. [22:26:05.416] #1 0x00007f1d4d45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:05.416] No symbol table info available. [22:26:05.416] #2 0x00007f1d4d445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:05.416] No symbol table info available. [22:26:05.416] #3 0x00005622aca6de97 in ExceptionalCondition (conditionName=conditionName@entry=0x5622accea9bd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5622acce9f10 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:26:05.416] No locals. [22:26:05.416] #4 0x00005622ac3dc172 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5622e89b5980, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [22:26:05.416] estate = 0x5622e895c960 [22:26:05.416] oldcontext = 0x5622e89a2470 [22:26:05.416] __func__ = "standard_ExecutorStart" [22:26:05.416] #5 0x00005622ac3dc34e in ExecutorStart (queryDesc=queryDesc@entry=0x5622e89b5980, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [22:26:05.416] No locals. [22:26:05.416] #6 0x00005622ac2fbdd1 in refresh_matview_datafill (dest=0x5622e89c7800, query=, query@entry=0x5622e89541b0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [22:26:05.416] rewritten = [22:26:05.416] plan = 0x5622e89b4fd8 [22:26:05.416] queryDesc = 0x5622e89b5980 [22:26:05.416] copied_query = [22:26:05.416] processed = [22:26:05.416] __func__ = "refresh_matview_datafill" [22:26:05.416] #7 0x00005622ac2fe12b in RefreshMatViewByOid (matviewOid=28589, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [22:26:05.416] dest = [22:26:05.416] matviewRel = 0x7f1d41890dc8 [22:26:05.416] rule = [22:26:05.416] actions = [22:26:05.416] dataQuery = 0x5622e89541b0 [22:26:05.416] tableSpace = [22:26:05.416] relowner = 10 [22:26:05.416] OIDNewHeap = 28598 [22:26:05.416] processed = 0 [22:26:05.416] relpersistence = 112 'p' [22:26:05.416] save_userid = 10 [22:26:05.416] save_sec_context = 0 [22:26:05.416] save_nestlevel = 2 [22:26:05.416] address = {classId = 0, objectId = 0, objectSubId = 0} [22:26:05.416] __func__ = "RefreshMatViewByOid" [22:26:05.416] #8 0x00005622ac2fe26a in ExecRefreshMatView (stmt=0x5622e89c74d8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:26:05.416] matviewOid = [22:26:05.416] lockmode = [22:26:05.416] #9 0x00005622ac2b3d3e in ExecCreateTableAs (pstate=pstate@entry=0x5622e89a2570, stmt=stmt@entry=0x5622e882f7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffda1d0fdd0) at ../src/backend/commands/createas.c:351 [22:26:05.416] refresh = [22:26:05.416] query = 0x5622e882f9b0 [22:26:05.416] into = 0x5622e882f548 [22:26:05.416] jstate = 0x0 [22:26:05.416] is_matview = true [22:26:05.416] do_refresh = false [22:26:05.416] dest = [22:26:05.416] address = {classId = 1259, objectId = 28589, objectSubId = 0} [22:26:05.416] __func__ = "ExecCreateTableAs" [22:26:05.416] #10 0x00005622ac7de910 in ProcessUtilitySlow (pstate=pstate@entry=0x5622e89a2570, pstmt=pstmt@entry=0x5622e882f8a0, queryString=queryString@entry=0x5622e882eab0 "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=0x5622e88302d8, qc=0x7ffda1d0fdd0) at ../src/backend/tcop/utility.c:1678 [22:26:05.416] _save_exception_stack = 0x7ffda1d0fcb0 [22:26:05.416] _save_context_stack = 0x0 [22:26:05.416] _local_sigjmp_buf = {{__jmpbuf = {0, -8504705803199193625, 94707929774064, 0, 94707929770672, 0, -2718021856214131225, -8504556553861079577}, __mask_was_saved = 0, __saved_mask = {__val = {94706922224127, 94707931010072, 46010583375701, 10712, 94706922231731, 139763638284352, 139763638284352, 10712, 94706922233809, 1, 4294978008, 139763638284352, 94706922224127, 1, 46011591808024, 1}}}} [22:26:05.416] _do_rethrow = false [22:26:05.416] parsetree = 0x5622e882f7f0 [22:26:05.416] isTopLevel = true [22:26:05.416] isCompleteQuery = true [22:26:05.416] needCleanup = false [22:26:05.416] commandCollected = false [22:26:05.416] address = {classId = 22050, objectId = 3900897264, objectSubId = 22050} [22:26:05.416] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:26:05.416] __func__ = "ProcessUtilitySlow" [22:26:05.416] #11 0x00005622ac7dcf21 in standard_ProcessUtility (pstmt=0x5622e882f8a0, queryString=0x5622e882eab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5622e88302d8, qc=0x7ffda1d0fdd0) at ../src/backend/tcop/utility.c:1070 [22:26:05.416] parsetree = 0x5622e882f7f0 [22:26:05.416] isTopLevel = true [22:26:05.416] isAtomicContext = false [22:26:05.416] pstate = 0x5622e89a2570 [22:26:05.416] readonly_flags = [22:26:05.416] __func__ = "standard_ProcessUtility" [22:26:05.416] #12 0x00005622ac7dd07c in ProcessUtility (pstmt=pstmt@entry=0x5622e882f8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5622e88302d8, qc=0x7ffda1d0fdd0) at ../src/backend/tcop/utility.c:523 [22:26:05.416] No locals. [22:26:05.416] #13 0x00005622ac7d8a3a in PortalRunUtility (portal=portal@entry=0x5622e88b3fc0, pstmt=pstmt@entry=0x5622e882f8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5622e88302d8, qc=qc@entry=0x7ffda1d0fdd0) at ../src/backend/tcop/pquery.c:1152 [22:26:05.416] No locals. [22:26:05.416] #14 0x00005622ac7d8fdf in PortalRunMulti (portal=portal@entry=0x5622e88b3fc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5622e88302d8, altdest=altdest@entry=0x5622e88302d8, qc=qc@entry=0x7ffda1d0fdd0) at ../src/backend/tcop/pquery.c:1309 [22:26:05.416] pstmt = 0x5622e882f8a0 [22:26:05.416] stmtlist_item__state = [22:26:05.416] active_snapshot_set = false [22:26:05.416] stmtlist_item = 0x5622e88302a0 [22:26:05.416] #15 0x00005622ac7d9547 in PortalRun (portal=portal@entry=0x5622e88b3fc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5622e88302d8, altdest=altdest@entry=0x5622e88302d8, qc=qc@entry=0x7ffda1d0fdd0) at ../src/backend/tcop/pquery.c:787 [22:26:05.416] _save_exception_stack = 0x7ffda1d0fe80 [22:26:05.416] _save_context_stack = 0x0 [22:26:05.416] _local_sigjmp_buf = {{__jmpbuf = {0, -8504705801239405081, 94707930316736, 94707929774184, 94707929774160, 94707929774112, -2718021856075719193, -8504556555911963161}, __mask_was_saved = 0, __saved_mask = {__val = {94706925773432, 2714828127, 4, 94707929774112, 112, 73, 94707930316736, 94707929774184, 94707929774160, 94707929774112, 94706925860635, 1, 2, 73, 94706915121601, 0}}}} [22:26:05.416] _do_rethrow = [22:26:05.416] result = [22:26:05.416] nprocessed = [22:26:05.416] saveTopTransactionResourceOwner = 0x5622e8871d88 [22:26:05.416] saveTopTransactionContext = 0x5622e88c1f00 [22:26:05.416] saveActivePortal = 0x0 [22:26:05.416] saveResourceOwner = 0x5622e8871d88 [22:26:05.416] savePortalContext = 0x0 [22:26:05.416] saveMemoryContext = 0x5622e88c1f00 [22:26:05.416] __func__ = "PortalRun" [22:26:05.416] #16 0x00005622ac7d29ff in exec_simple_query (query_string=query_string@entry=0x5622e882eab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:26:05.416] cmdtaglen = 24 [22:26:05.416] snapshot_set = [22:26:05.416] per_parsetree_context = 0x0 [22:26:05.416] plantree_list = 0x5622e8830288 [22:26:05.416] parsetree = 0x5622e882f820 [22:26:05.416] commandTag = [22:26:05.416] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:26:05.416] querytree_list = [22:26:05.416] portal = 0x5622e88b3fc0 [22:26:05.416] receiver = 0x5622e88302d8 [22:26:05.416] format = 0 [22:26:05.416] cmdtagname = [22:26:05.416] parsetree_item__state = [22:26:05.416] dest = DestRemote [22:26:05.416] oldcontext = 0x5622e88c1f00 [22:26:05.416] parsetree_list = 0x5622e882f850 [22:26:05.416] parsetree_item = 0x5622e882f868 [22:26:05.416] save_log_statement_stats = false [22:26:05.416] was_logged = false [22:26:05.416] use_implicit_block = false [22:26:05.416] msec_str = "\004\000\000\000\000\000\000\000\305<\251\254\"V\000\000`\376С\375\177\000\000G\000\000\000\000\000\000" [22:26:05.416] __func__ = "exec_simple_query" [22:26:05.416] #17 0x00005622ac7d5758 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [22:26:05.416] query_string = 0x5622e882eab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:26:05.416] firstchar = [22:26:05.416] input_message = {data = 0x5622e882eab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:26:05.416] local_sigjmp_buf = {{__jmpbuf = {94706938583256, -8504558643652600345, 140727318282204, 4, 10, 140727318282436, -2718021856008610329, -8504556557686546969}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94707929501136, 17408, 94706938577312, 94707930035504, 10, 94706925772980, 0, 10, 2, 94706938583264, 94707929501136, 94706938577312, 4, 10, 140727318282436}}}} [22:26:05.416] send_ready_for_query = false [22:26:05.416] idle_in_transaction_timeout_enabled = false [22:26:05.416] idle_session_timeout_enabled = false [22:26:05.416] __func__ = "PostgresMain" [22:26:05.416] #18 0x00005622ac7cb7c3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:26:05.416] bsdata = [22:26:05.416] #19 0x00005622ac67c637 in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x7ffda1d0ffdc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffda1d10030) at ../src/backend/postmaster/launch_backend.c:274 [22:26:05.416] pid = [22:26:05.416] #20 0x00005622ac681843 in BackendStartup (client_sock=client_sock@entry=0x7ffda1d10030) at ../src/backend/postmaster/postmaster.c:3466 [22:26:05.416] bn = 0x5622e88571d8 [22:26:05.416] pid = [22:26:05.416] startup_data = {canAcceptConnections = CAC_OK} [22:26:05.416] cac = [22:26:05.416] __func__ = "BackendStartup" [22:26:05.416] #21 0x00005622ac683867 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:26:05.416] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\352&\200\253\"V\000\000\340\a|\253\"V\000\000\200\001ѡ\375\177\000\000x\001ѡ\375\177\000\000\225[\362\001\000\000\000\000\240D\303M\035\177\000\000+", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\006\314N\035\177\000\0000F\303M\035\177\000\000\340\002\314N\035\177\000\000\316)fR\000\000\000", __ss_align = 2714829248}, salen = 2}} [22:26:05.416] i = 0 [22:26:05.416] now = [22:26:05.416] last_lockfile_recheck_time = 1737325227 [22:26:05.416] last_touch_time = 1737325227 [22:26:05.416] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1304643120, events = 32541, fd = 1321992928, user_data = 0x7c96e577}, {pos = -1580137984, events = 32765, fd = 1321822792, user_data = 0xf}, {pos = 1304643120, events = 32541, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1321992928, user_data = 0x7ffda1d10178}, {pos = -1580138112, events = 32765, fd = 1321993832, user_data = 0x0}, {pos = -394073232, events = 22050, fd = 1296792202, user_data = 0x5622e882eb70}, {pos = 1, events = 22050, fd = 32768, user_data = 0xffffffff}, {pos = 1296228384, events = 32541, fd = 1312001952, user_data = 0x5622e885c3f8}, {pos = -393887016, events = 22050, fd = -393887567, user_data = 0x7f1d4ec9cebe}, {pos = 1, events = 0, fd = 1321992928, user_data = 0x1aa}, {pos = -1392358064, events = 22050, fd = 0, user_data = 0xf9}, {pos = -394073232, events = 22050, fd = 1321848510, user_data = 0x1}, {pos = 0, events = 0, fd = 1296228384, user_data = 0x7f1d4d4f2e40 }, {pos = 16, events = 0, fd = -1580136976, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f1d4ec9f1ba}, {pos = 0, events = 0, fd = 1296756132, user_data = 0x0}, {pos = -1385335072, events = 22050, fd = 2, user_data = 0x0}, {pos = -394326416, events = 22050, fd = -1401534739, user_data = 0x5622e88614d0}, {pos = -1401530750, events = 22050, fd = -393865941, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 1296262344, user_data = 0x7f1d4d49c880 }, {pos = 1293802936, events = 32541, fd = -1580136784, user_data = 0x100007f00000002}, {pos = 1296789613, events = 32541, fd = 2, user_data = 0x5622e88614d0}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 1298078816, events = 32541, 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 = 1499752259, fd = 168449624, user_data = 0x33373337310a6174}, {pos = 842151218, events = 808716855, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 22016, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -393891664, events = 22050, fd = 1080, user_data = 0x5622e885c0d0}, {pos = -1398072905, events = 22050, fd = 1024, user_data = 0x7f1d4d4b58be}, {pos = 1298061792, events = 32541, fd = 1296699758, user_data = 0x100000400}, {pos = 7, events = 0, fd = -393886496, user_data = 0xa7c2cbdb5e465100}, {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 = 0x5622e885c0d0}, {pos = 1, events = 0, fd = -393887336, user_data = 0x3}, {pos = 0, events = 0, fd = 25394, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -394073232, user_data = 0x7f1d4d4f3053 }, {pos = -393887336, events = 22050, fd = 1024, user_data = 0x7ffda1d106b8}, {pos = -1397991765, events = 22050, fd = -1385260912, user_data = 0x5622acab4168 }, {pos = -393887536, events = 22050, fd = -394073680, user_data = 0x5622e885c0d0}, {pos = 1296783550, events = 32541, fd = 0, user_data = 0x5622acac5dd2 }, {pos = -393887536, events = 1, fd = -1397989605, user_data = 0x5622e882e9b0}, {pos = 1581666560, events = 2814561243, fd = 0, user_data = 0x7f1d4d4a2ab1}, {pos = 1296700656, events = 32541, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -394326416, user_data = 0xa7c2cbdb5e465100}, {pos = 0, events = 0, fd = 1581666560, user_data = 0xc}, {pos = 1581666560, events = 2814561243, fd = 0, user_data = 0x7f1d4d45b239 }, {pos = 250, events = 0, fd = -1402485964, user_data = 0x400000}, {pos = 0, events = 0, fd = -394326416, user_data = 0x5622acab3ffc }, {pos = -394239776, events = 22050, fd = -394073680, user_data = 0x5622e88060e0}, {pos = 1, events = 0, fd = 0, user_data = 0x5622aca72801 }, {pos = 12, events = 0, fd = -393896200, user_data = 0x5622e8859ed8}, {pos = -1385333664, events = 22050, fd = 296, user_data = 0x5622ac67eb4e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1402469607, events = 22050, fd = -1388950864, user_data = 0x5622e882f388}} [22:26:05.416] nevents = 1 [22:26:05.416] __func__ = "ServerLoop" [22:26:05.416] #22 0x00005622ac6850c6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5622e87ecd30) at ../src/backend/postmaster/postmaster.c:1377 [22:26:05.416] opt = [22:26:05.416] status = [22:26:05.416] userDoption = [22:26:05.416] listen_addr_saved = false [22:26:05.416] output_config_variable = [22:26:05.416] __func__ = "PostmasterMain" [22:26:05.416] #23 0x00005622ac4b9e9f in main (argc=8, argv=0x5622e87ecd30) at ../src/backend/main/main.c:230 [22:26:05.416] do_check_root = [22:26:05.416] dispatch_option = [22:26:05.452] -e [22:26:05.452] [22:26:05.452] [22:26:05.517] dumping /tmp/cores/postgres-6-36681.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:26:05.788] [New LWP 36681] [22:26:05.788] [22:26:05.788] This GDB supports auto-downloading debuginfo from the following URLs: [22:26:05.788] [22:26:05.788] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:26:05.788] Debuginfod has been disabled. [22:26:05.788] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:26:05.900] [Thread debugging using libthread_db enabled] [22:26:05.900] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:26:05.900] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [22:26:05.900] Program terminated with signal SIGABRT, Aborted. [22:26:05.900] #0 0x00007f1912ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:06.813] [22:26:06.813] Thread 1 (Thread 0x7f1912bd2f00 (LWP 36681)): [22:26:06.813] #0 0x00007f1912ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:06.813] No symbol table info available. [22:26:06.813] #1 0x00007f1912e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:06.813] No symbol table info available. [22:26:06.813] #2 0x00007f1912e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:06.813] No symbol table info available. [22:26:06.813] #3 0x000055e8aa8e7e97 in ExceptionalCondition (conditionName=conditionName@entry=0x55e8aab649bd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55e8aab63f10 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:26:06.813] No locals. [22:26:06.813] #4 0x000055e8aa256172 in standard_ExecutorStart (queryDesc=0x55e8af6ea190, eflags=0) at ../src/backend/executor/execMain.c:193 [22:26:06.813] estate = 0x55e8af5b3300 [22:26:06.813] oldcontext = 0x55e8af615620 [22:26:06.813] __func__ = "standard_ExecutorStart" [22:26:06.813] #5 0x00007f19104c26e9 in pgss_ExecutorStart (queryDesc=0x55e8af6ea190, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [22:26:06.813] No locals. [22:26:06.813] #6 0x000055e8aa256307 in ExecutorStart (queryDesc=queryDesc@entry=0x55e8af6ea190, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [22:26:06.813] No locals. [22:26:06.813] #7 0x000055e8aa175dd1 in refresh_matview_datafill (dest=0x55e8af64f7d0, query=, query@entry=0x55e8af65dc50, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [22:26:06.813] rewritten = [22:26:06.813] plan = 0x55e8af6e96d8 [22:26:06.813] queryDesc = 0x55e8af6ea190 [22:26:06.813] copied_query = [22:26:06.813] processed = [22:26:06.813] __func__ = "refresh_matview_datafill" [22:26:06.813] #8 0x000055e8aa17812b in RefreshMatViewByOid (matviewOid=28575, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [22:26:06.813] dest = [22:26:06.813] matviewRel = 0x7f190e7c61b8 [22:26:06.813] rule = [22:26:06.813] actions = [22:26:06.813] dataQuery = 0x55e8af65dc50 [22:26:06.813] tableSpace = [22:26:06.813] relowner = 10 [22:26:06.813] OIDNewHeap = 28583 [22:26:06.813] processed = 0 [22:26:06.813] relpersistence = 112 'p' [22:26:06.813] save_userid = 10 [22:26:06.813] save_sec_context = 0 [22:26:06.813] save_nestlevel = 2 [22:26:06.813] address = {classId = 0, objectId = 0, objectSubId = 0} [22:26:06.813] __func__ = "RefreshMatViewByOid" [22:26:06.813] #9 0x000055e8aa17826a in ExecRefreshMatView (stmt=0x55e8af64f4a8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:26:06.813] matviewOid = [22:26:06.813] lockmode = [22:26:06.813] #10 0x000055e8aa12dd3e in ExecCreateTableAs (pstate=pstate@entry=0x55e8af615720, stmt=stmt@entry=0x55e8af4cc790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffca6ff0cb0) at ../src/backend/commands/createas.c:351 [22:26:06.813] refresh = [22:26:06.813] query = 0x55e8af4cc950 [22:26:06.813] into = 0x55e8af4cc4e8 [22:26:06.813] jstate = 0x0 [22:26:06.813] is_matview = true [22:26:06.813] do_refresh = false [22:26:06.813] dest = [22:26:06.813] address = {classId = 1259, objectId = 28575, objectSubId = 0} [22:26:06.813] __func__ = "ExecCreateTableAs" [22:26:06.813] #11 0x000055e8aa658910 in ProcessUtilitySlow (pstate=pstate@entry=0x55e8af615720, pstmt=pstmt@entry=0x55e8af4cc840, queryString=queryString@entry=0x55e8af4cba50 "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=0x55e8af4cd7e8, qc=0x7ffca6ff0cb0) at ../src/backend/tcop/utility.c:1678 [22:26:06.813] _save_exception_stack = 0x7ffca6ff0880 [22:26:06.813] _save_context_stack = 0x0 [22:26:06.813] _local_sigjmp_buf = {{__jmpbuf = {0, -8890372648004816523, 94457861818256, 0, 94457861814864, 0, -3407221291563683467, -8890378903925100171}, __mask_was_saved = 0, __saved_mask = {__val = {94457772522894, 94457862427312, 94457772543454, 5, 94457779782872, 140723110217055, 12595973051381711041, 6, 10, 0, 94457862038096, 140723110217055, 140723110217904, 0, 94457782830234, 140723110217100}}}} [22:26:06.813] _do_rethrow = false [22:26:06.813] parsetree = 0x55e8af4cc790 [22:26:06.813] isTopLevel = true [22:26:06.813] isCompleteQuery = true [22:26:06.813] needCleanup = false [22:26:06.813] commandCollected = false [22:26:06.813] address = {classId = 21992, objectId = 2941044624, objectSubId = 21992} [22:26:06.813] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:26:06.813] __func__ = "ProcessUtilitySlow" [22:26:06.813] #12 0x000055e8aa656f21 in standard_ProcessUtility (pstmt=pstmt@entry=0x55e8af4cc840, queryString=queryString@entry=0x55e8af4cba50 "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=0x55e8af4cd7e8, qc=0x7ffca6ff0cb0) at ../src/backend/tcop/utility.c:1070 [22:26:06.813] parsetree = 0x55e8af4cc790 [22:26:06.813] isTopLevel = true [22:26:06.813] isAtomicContext = false [22:26:06.813] pstate = 0x55e8af615720 [22:26:06.813] readonly_flags = [22:26:06.813] __func__ = "standard_ProcessUtility" [22:26:06.813] #13 0x00007f19104c5d8f in pgss_ProcessUtility (pstmt=0x55e8af4cc840, queryString=0x55e8af4cba50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55e8af4cd7e8, qc=0x7ffca6ff0cb0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [22:26:06.813] _save_exception_stack = 0x7ffca6ff0b90 [22:26:06.813] _save_context_stack = 0x0 [22:26:06.813] _local_sigjmp_buf = {{__jmpbuf = {0, 3408754015999291765, 94457861818432, 94457861822440, 140723110218928, 0, -3407221291651763851, -3351677376371691147}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140723110218160, 94457782837933, 1, 206158430232, 94457861819232, 140723110218256, 0, 94457777606523, 94457861814608, 94457782497540, 3, 94457776328761, 94457861818432}}}} [22:26:06.813] _do_rethrow = false [22:26:06.813] duration = [22:26:06.813] bufusage = {shared_blks_hit = 58, shared_blks_read = 94457778979516, shared_blks_dirtied = 94457862764472, shared_blks_written = 94457775458822, local_blks_hit = 94457775911743, local_blks_read = 94457862766536, local_blks_dirtied = 94457862764472, local_blks_written = 94457782831168, temp_blks_read = 139745665297848, temp_blks_written = 94457861814864, shared_blk_read_time = {ticks = 94457785192467}, shared_blk_write_time = {ticks = 94457795319618}, local_blk_read_time = {ticks = 94457795319744}, local_blk_write_time = {ticks = 140723110218164}, temp_blk_read_time = {ticks = 94457785387129}, temp_blk_write_time = {ticks = 94457795319633}} [22:26:06.813] walusage_start = {wal_records = 8974, wal_fpi = 122, wal_bytes = 1214476} [22:26:06.813] start = [22:26:06.813] rows = [22:26:06.813] bufusage_start = {shared_blks_hit = 36087, shared_blks_read = 4271, shared_blks_dirtied = 1498, shared_blks_written = 1095, 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:26:06.813] walusage = {wal_records = 1, wal_fpi = 4294967354, wal_bytes = 139745596738496} [22:26:06.813] parsetree = [22:26:06.813] saved_queryId = 7267788456574341698 [22:26:06.813] saved_stmt_location = 0 [22:26:06.813] saved_stmt_len = 69 [22:26:06.813] enabled = true [22:26:06.813] #14 0x000055e8aa656fc7 in ProcessUtility (pstmt=pstmt@entry=0x55e8af4cc840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55e8af4cd7e8, qc=0x7ffca6ff0cb0) at ../src/backend/tcop/utility.c:519 [22:26:06.813] No locals. [22:26:06.813] #15 0x000055e8aa652a3a in PortalRunUtility (portal=portal@entry=0x55e8af54e940, pstmt=pstmt@entry=0x55e8af4cc840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55e8af4cd7e8, qc=qc@entry=0x7ffca6ff0cb0) at ../src/backend/tcop/pquery.c:1152 [22:26:06.813] No locals. [22:26:06.813] #16 0x000055e8aa652fdf in PortalRunMulti (portal=portal@entry=0x55e8af54e940, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55e8af4cd7e8, altdest=altdest@entry=0x55e8af4cd7e8, qc=qc@entry=0x7ffca6ff0cb0) at ../src/backend/tcop/pquery.c:1309 [22:26:06.813] pstmt = 0x55e8af4cc840 [22:26:06.813] stmtlist_item__state = [22:26:06.813] active_snapshot_set = false [22:26:06.813] stmtlist_item = 0x55e8af4cd7b0 [22:26:06.813] #17 0x000055e8aa653547 in PortalRun (portal=portal@entry=0x55e8af54e940, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55e8af4cd7e8, altdest=altdest@entry=0x55e8af4cd7e8, qc=qc@entry=0x7ffca6ff0cb0) at ../src/backend/tcop/pquery.c:787 [22:26:06.813] _save_exception_stack = 0x7ffca6ff0d60 [22:26:06.813] _save_context_stack = 0x0 [22:26:06.813] _local_sigjmp_buf = {{__jmpbuf = {0, -8890372647288639115, 94457862351168, 94457861818376, 94457861818352, 94457861818304, -3407221291850993291, -8890378901882343051}, __mask_was_saved = 0, __saved_mask = {__val = {94457782518392, 2801732671, 4, 94457861818304, 112, 73, 94457862351168, 94457861818376, 94457861818352, 94457861818304, 94457782605595, 1, 2, 73, 94457771866561, 0}}}} [22:26:06.813] _do_rethrow = [22:26:06.813] result = [22:26:06.813] nprocessed = [22:26:06.813] saveTopTransactionResourceOwner = 0x55e8af510348 [22:26:06.813] saveTopTransactionContext = 0x55e8af561180 [22:26:06.813] saveActivePortal = 0x0 [22:26:06.813] saveResourceOwner = 0x55e8af510348 [22:26:06.813] savePortalContext = 0x0 [22:26:06.813] saveMemoryContext = 0x55e8af561180 [22:26:06.813] __func__ = "PortalRun" [22:26:06.813] #18 0x000055e8aa64c9ff in exec_simple_query (query_string=query_string@entry=0x55e8af4cba50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:26:06.813] cmdtaglen = 24 [22:26:06.813] snapshot_set = [22:26:06.813] per_parsetree_context = 0x0 [22:26:06.813] plantree_list = 0x55e8af4cd798 [22:26:06.813] parsetree = 0x55e8af4cc7c0 [22:26:06.813] commandTag = [22:26:06.813] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:26:06.813] querytree_list = [22:26:06.813] portal = 0x55e8af54e940 [22:26:06.813] receiver = 0x55e8af4cd7e8 [22:26:06.813] format = 0 [22:26:06.813] cmdtagname = [22:26:06.813] parsetree_item__state = [22:26:06.813] dest = DestRemote [22:26:06.813] oldcontext = 0x55e8af561180 [22:26:06.813] parsetree_list = 0x55e8af4cc7f0 [22:26:06.813] parsetree_item = 0x55e8af4cc808 [22:26:06.813] save_log_statement_stats = false [22:26:06.813] was_logged = true [22:26:06.813] use_implicit_block = false [22:26:06.813] msec_str = "\004\000\000\000\000\000\000\000\305ܐ\252\350U\000\000@\r\377\246\374\177\000\000G\000\000\000\000\000\000" [22:26:06.813] __func__ = "exec_simple_query" [22:26:06.813] #19 0x000055e8aa64f758 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [22:26:06.813] query_string = 0x55e8af4cba50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:26:06.813] firstchar = [22:26:06.813] input_message = {data = 0x55e8af4cba50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:26:06.813] local_sigjmp_buf = {{__jmpbuf = {94457795328216, -8890381521931538059, 140723110219452, 4, 20, 140723110219684, -3407221292052319883, -8890378900503858827}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94457862071024, 0, 168, 94457782518494, 0, 10, 2, 94457795328224, 94457861545456, 94457795322272, 4, 20, 140723110219684}}}} [22:26:06.813] send_ready_for_query = false [22:26:06.813] idle_in_transaction_timeout_enabled = false [22:26:06.813] idle_session_timeout_enabled = false [22:26:06.813] __func__ = "PostgresMain" [22:26:06.813] #20 0x000055e8aa6457c3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:26:06.813] bsdata = [22:26:06.813] #21 0x000055e8aa4f6637 in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x7ffca6ff0ebc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffca6ff0f10) at ../src/backend/postmaster/launch_backend.c:274 [22:26:06.813] pid = [22:26:06.813] #22 0x000055e8aa4fb843 in BackendStartup (client_sock=client_sock@entry=0x7ffca6ff0f10) at ../src/backend/postmaster/postmaster.c:3466 [22:26:06.813] bn = 0x55e8af4f7538 [22:26:06.813] pid = [22:26:06.813] startup_data = {canAcceptConnections = CAC_OK} [22:26:06.813] cac = [22:26:06.813] __func__ = "BackendStartup" [22:26:06.813] #23 0x000055e8aa4fd867 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:26:06.813] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\343\022\031\177\000\000\240\3172\024\031\177\000\000\270\017\377\246\374\177\000\000\264\017\377\246\374\177", '\000' , "\352\306g\251\350U\000\000\340\247c\251\350U\000\000\200\020\377\246\374\177\000\000x\020\377\246\374\177\000\000\225[\362\001\000\000\000\000\260fO\257\350U\000\000,", '\000' , "\350U\000\000\370\305g\251\350U\000", __ss_align = 139745693623912}, salen = 2}} [22:26:06.813] i = 0 [22:26:06.813] now = [22:26:06.813] last_lockfile_recheck_time = 1737325265 [22:26:06.813] last_touch_time = 1737325265 [22:26:06.813] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55e8a967c6ea}, {pos = 342713960, events = 32537, fd = 325269040, user_data = 0x7f19146d62e0}, {pos = 2090263927, events = 0, fd = -1493233408, user_data = 0x7f19146aca48}, {pos = 15, events = 0, fd = 325269040, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f19146d62e0}, {pos = -1493233544, events = 32764, fd = -1493233536, user_data = 0x7f19146d6668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -1353923216, events = 21992, fd = 1, user_data = 0x7ffca6ff15a3}, {pos = -1, events = 0, fd = 316858400, user_data = 0x7f191432cfa0}, {pos = -1353705400, events = 21992, fd = -1353705688, user_data = 0x55e8af4fbc11}, {pos = 342568638, events = 32537, fd = 1, user_data = 0x7f19146d62e0}, {pos = 426, events = 0, fd = -1427509936, user_data = 0x0}, {pos = 86, events = 0, fd = -1353739848, user_data = 0x7f19146b2ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f1912e2e020}, {pos = 317664832, events = 32537, fd = 16, user_data = 0x7ffca6ff14d0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 342577594, events = 32537, fd = 0, user_data = 0x7f1912eaeda4 }, {pos = 0, events = 0, fd = -1420486944, user_data = 0x2}, {pos = 0, events = 0, fd = -1354178928, user_data = 0x55e8aa5e32bb }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -1353739848, user_data = 0x7f19146b2ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f1912e364c8}, {pos = 317419271, events = 32537, fd = -1420421184, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 318708832, events = 32537, 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 = 331900224, events = 32537, fd = 331901568, 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 = 1024, user_data = 0x7f1912eb576b}, {pos = 318691808, events = 32537, fd = 317329774, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1353710320, user_data = 0xdfd8b9b5ea953800}, {pos = 318694880, events = 32537, fd = -328, user_data = 0x0}, {pos = -1353706008, events = 21992, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 32490, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1353739848, user_data = 0x7f1912ef3053 }, {pos = -1353706008, events = 21992, fd = 1024, user_data = 0x7ffca6ff1598}, {pos = -1433143637, events = 21992, fd = -1420412784, user_data = 0x55e8aa92e168 }, {pos = -1353706208, events = 21992, fd = -1353926320, user_data = 0x55e8af501520}, {pos = 317413227, events = 32537, fd = 0, user_data = 0x55e8aa93fdd2 }, {pos = -1353706208, events = 1, fd = -1433141477, user_data = 0x55e8af4cb950}, {pos = -359319552, events = 3755522485, fd = 0, user_data = 0x7f1912ea2ab1}, {pos = 317330672, events = 32537, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1354178928, user_data = 0xdfd8b9b5ea953800}, {pos = 0, events = 0, fd = -359319552, user_data = 0xc}, {pos = -359319552, events = 3755522485, fd = 0, user_data = 0x7f1912e5b239 }, {pos = 87, events = 0, fd = -1437637836, user_data = 0x400000}, {pos = 0, events = 0, fd = -1354178928, user_data = 0x55e8aa92dffc }, {pos = -1354092416, events = 21992, fd = -1353926320, user_data = 0x55e8af4a3080}, {pos = 1, events = 0, fd = 0, user_data = 0x55e8aa8ec801 }, {pos = 12, events = 0, fd = -1353743896, user_data = 0x55e8af4f81c8}, {pos = -1420485536, events = 21992, fd = 296, user_data = 0x55e8aa4f8b4e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1437621479, events = 21992, fd = -1424102736, user_data = 0x55e8af4cc308}} [22:26:06.813] nevents = 1 [22:26:06.813] __func__ = "ServerLoop" [22:26:06.813] #24 0x000055e8aa4ff0c6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55e8af489cf0) at ../src/backend/postmaster/postmaster.c:1377 [22:26:06.813] opt = [22:26:06.813] status = [22:26:06.813] userDoption = [22:26:06.813] listen_addr_saved = false [22:26:06.813] output_config_variable = [22:26:06.813] __func__ = "PostmasterMain" [22:26:06.813] #25 0x000055e8aa333e9f in main (argc=4, argv=0x55e8af489cf0) at ../src/backend/main/main.c:230 [22:26:06.813] do_check_root = [22:26:06.813] dispatch_option = [22:26:06.850] -e [22:26:06.850] [22:26:06.850] [22:26:06.913] dumping /tmp/cores/postgres-6-29782.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:26:07.190] [New LWP 29782] [22:26:07.190] [22:26:07.190] This GDB supports auto-downloading debuginfo from the following URLs: [22:26:07.190] [22:26:07.190] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:26:07.190] Debuginfod has been disabled. [22:26:07.190] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:26:07.305] [Thread debugging using libthread_db enabled] [22:26:07.305] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:26:07.305] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [22:26:07.305] Program terminated with signal SIGABRT, Aborted. [22:26:07.305] #0 0x00007fb387aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:08.215] [22:26:08.215] Thread 1 (Thread 0x7fb388232f00 (LWP 29782)): [22:26:08.215] #0 0x00007fb387aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:08.215] No symbol table info available. [22:26:08.215] #1 0x00007fb387a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:08.215] No symbol table info available. [22:26:08.215] #2 0x00007fb387a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:26:08.215] No symbol table info available. [22:26:08.215] #3 0x000055e0676f0e97 in ExceptionalCondition (conditionName=conditionName@entry=0x55e06796d9bd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55e06796cf10 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:26:08.215] No locals. [22:26:08.215] #4 0x000055e06705f172 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55e0930d4010, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [22:26:08.215] estate = 0x55e093095770 [22:26:08.215] oldcontext = 0x55e09302d990 [22:26:08.215] __func__ = "standard_ExecutorStart" [22:26:08.215] #5 0x000055e06705f34e in ExecutorStart (queryDesc=queryDesc@entry=0x55e0930d4010, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [22:26:08.215] No locals. [22:26:08.215] #6 0x000055e066f7edd1 in refresh_matview_datafill (dest=0x55e093065010, query=, query@entry=0x55e093090c20, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [22:26:08.215] rewritten = [22:26:08.215] plan = 0x55e0930d3668 [22:26:08.215] queryDesc = 0x55e0930d4010 [22:26:08.215] copied_query = [22:26:08.215] processed = [22:26:08.215] __func__ = "refresh_matview_datafill" [22:26:08.215] #7 0x000055e066f8112b in RefreshMatViewByOid (matviewOid=28632, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [22:26:08.215] dest = [22:26:08.215] matviewRel = 0x7fb37c27d040 [22:26:08.215] rule = [22:26:08.215] actions = [22:26:08.215] dataQuery = 0x55e093090c20 [22:26:08.215] tableSpace = [22:26:08.215] relowner = 10 [22:26:08.215] OIDNewHeap = 28646 [22:26:08.215] processed = 0 [22:26:08.215] relpersistence = 112 'p' [22:26:08.215] save_userid = 10 [22:26:08.215] save_sec_context = 0 [22:26:08.215] save_nestlevel = 2 [22:26:08.215] address = {classId = 0, objectId = 0, objectSubId = 0} [22:26:08.215] __func__ = "RefreshMatViewByOid" [22:26:08.215] #8 0x000055e066f8126a in ExecRefreshMatView (stmt=0x55e093064ce8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:26:08.215] matviewOid = [22:26:08.215] lockmode = [22:26:08.215] #9 0x000055e066f36d3e in ExecCreateTableAs (pstate=pstate@entry=0x55e09302da90, stmt=stmt@entry=0x55e092efb770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffeba423020) at ../src/backend/commands/createas.c:351 [22:26:08.215] refresh = [22:26:08.215] query = 0x55e092efb930 [22:26:08.215] into = 0x55e092efb4c8 [22:26:08.215] jstate = 0x0 [22:26:08.215] is_matview = true [22:26:08.215] do_refresh = false [22:26:08.215] dest = [22:26:08.215] address = {classId = 1259, objectId = 28632, objectSubId = 0} [22:26:08.215] __func__ = "ExecCreateTableAs" [22:26:08.215] #10 0x000055e067461910 in ProcessUtilitySlow (pstate=pstate@entry=0x55e09302da90, pstmt=pstmt@entry=0x55e092efb820, queryString=queryString@entry=0x55e092efaa30 "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=0x55e092efc258, qc=0x7ffeba423020) at ../src/backend/tcop/utility.c:1678 [22:26:08.215] _save_exception_stack = 0x7ffeba422f00 [22:26:08.215] _save_context_stack = 0x0 [22:26:08.215] _local_sigjmp_buf = {{__jmpbuf = {0, -109533274888618242, 94423026218864, 0, 94423026215472, 0, -6177094488883872002, -109433007557460226}, __mask_was_saved = 0, __saved_mask = {__val = {94422293096959, 94423027766712, 94422296959040, 140409059880376, 94423026215472, 94422299320339, 94422309447490, 94422309447616, 140732023319844, 94422299515001, 94422309447505, 94422309447616, 140732023319876, 94422299515016, 94422309447616, 0}}}} [22:26:08.215] _do_rethrow = false [22:26:08.215] parsetree = 0x55e092efb770 [22:26:08.215] isTopLevel = true [22:26:08.215] isCompleteQuery = true [22:26:08.215] needCleanup = false [22:26:08.215] commandCollected = false [22:26:08.215] address = {classId = 21984, objectId = 2465183600, objectSubId = 21984} [22:26:08.215] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:26:08.215] __func__ = "ProcessUtilitySlow" [22:26:08.215] #11 0x000055e06745ff21 in standard_ProcessUtility (pstmt=0x55e092efb820, queryString=0x55e092efaa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55e092efc258, qc=0x7ffeba423020) at ../src/backend/tcop/utility.c:1070 [22:26:08.215] parsetree = 0x55e092efb770 [22:26:08.215] isTopLevel = true [22:26:08.215] isAtomicContext = false [22:26:08.215] pstate = 0x55e09302da90 [22:26:08.215] readonly_flags = [22:26:08.215] __func__ = "standard_ProcessUtility" [22:26:08.215] #12 0x000055e06746007c in ProcessUtility (pstmt=pstmt@entry=0x55e092efb820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55e092efc258, qc=0x7ffeba423020) at ../src/backend/tcop/utility.c:523 [22:26:08.215] No locals. [22:26:08.215] #13 0x000055e06745ba3a in PortalRunUtility (portal=portal@entry=0x55e092f7f9c0, pstmt=pstmt@entry=0x55e092efb820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55e092efc258, qc=qc@entry=0x7ffeba423020) at ../src/backend/tcop/pquery.c:1152 [22:26:08.215] No locals. [22:26:08.215] #14 0x000055e06745bfdf in PortalRunMulti (portal=portal@entry=0x55e092f7f9c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55e092efc258, altdest=altdest@entry=0x55e092efc258, qc=qc@entry=0x7ffeba423020) at ../src/backend/tcop/pquery.c:1309 [22:26:08.215] pstmt = 0x55e092efb820 [22:26:08.215] stmtlist_item__state = [22:26:08.215] active_snapshot_set = false [22:26:08.215] stmtlist_item = 0x55e092efc220 [22:26:08.215] #15 0x000055e06745c547 in PortalRun (portal=portal@entry=0x55e092f7f9c0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55e092efc258, altdest=altdest@entry=0x55e092efc258, qc=qc@entry=0x7ffeba423020) at ../src/backend/tcop/pquery.c:787 [22:26:08.215] _save_exception_stack = 0x7ffeba4230d0 [22:26:08.215] _save_context_stack = 0x0 [22:26:08.215] _local_sigjmp_buf = {{__jmpbuf = {0, -109533271320314114, 94423026760128, 94423026218984, 94423026218960, 94423026218912, -6177094489013895426, -109432992630063362}, __mask_was_saved = 0, __saved_mask = {__val = {94422296646264, 3124899759, 4, 94423026218912, 112, 73, 94423026760128, 94423026218984, 94423026218960, 94423026218912, 94422296733467, 1, 2, 73, 94422285994433, 0}}}} [22:26:08.215] _do_rethrow = [22:26:08.215] result = [22:26:08.215] nprocessed = [22:26:08.215] saveTopTransactionResourceOwner = 0x55e092f3c478 [22:26:08.215] saveTopTransactionContext = 0x55e092f919e0 [22:26:08.215] saveActivePortal = 0x0 [22:26:08.215] saveResourceOwner = 0x55e092f3c478 [22:26:08.215] savePortalContext = 0x0 [22:26:08.215] saveMemoryContext = 0x55e092f919e0 [22:26:08.215] __func__ = "PortalRun" [22:26:08.215] #16 0x000055e0674559ff in exec_simple_query (query_string=query_string@entry=0x55e092efaa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:26:08.215] cmdtaglen = 24 [22:26:08.215] snapshot_set = [22:26:08.215] per_parsetree_context = 0x0 [22:26:08.215] plantree_list = 0x55e092efc208 [22:26:08.215] parsetree = 0x55e092efb7a0 [22:26:08.215] commandTag = [22:26:08.215] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:26:08.215] querytree_list = [22:26:08.215] portal = 0x55e092f7f9c0 [22:26:08.215] receiver = 0x55e092efc258 [22:26:08.215] format = 0 [22:26:08.215] cmdtagname = [22:26:08.215] parsetree_item__state = [22:26:08.215] dest = DestRemote [22:26:08.215] oldcontext = 0x55e092f919e0 [22:26:08.215] parsetree_list = 0x55e092efb7d0 [22:26:08.215] parsetree_item = 0x55e092efb7e8 [22:26:08.215] save_log_statement_stats = false [22:26:08.215] was_logged = true [22:26:08.215] use_implicit_block = false [22:26:08.215] msec_str = "\004\000\000\000\000\000\000\000\305lqg\340U\000\000\2600B\272\376\177\000\000G\000\000\000\000\000\000" [22:26:08.215] __func__ = "exec_simple_query" [22:26:08.215] #17 0x000055e067458758 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [22:26:08.215] query_string = 0x55e092efaa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:26:08.215] firstchar = [22:26:08.215] input_message = {data = 0x55e092efaa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:26:08.215] local_sigjmp_buf = {{__jmpbuf = {94422309456088, -109447981678346498, 140732023321132, 4, 13, 140732023321364, -6177094489752092930, -109432998228017410}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94423025946032, 16128, 94422309450144, 94423026480176, 13, 94422296645812, 0, 9, 2, 94422309456096, 94423025946032, 94422309450144, 4, 13, 140732023321364}}}} [22:26:08.215] send_ready_for_query = false [22:26:08.215] idle_in_transaction_timeout_enabled = false [22:26:08.215] idle_session_timeout_enabled = false [22:26:08.215] __func__ = "PostgresMain" [22:26:08.215] #18 0x000055e06744e7c3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:26:08.215] bsdata = [22:26:08.215] #19 0x000055e0672ff637 in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x7ffeba42322c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffeba423280) at ../src/backend/postmaster/launch_backend.c:274 [22:26:08.215] pid = [22:26:08.215] #20 0x000055e067304843 in BackendStartup (client_sock=client_sock@entry=0x7ffeba423280) at ../src/backend/postmaster/postmaster.c:3466 [22:26:08.215] bn = 0x55e092f23168 [22:26:08.215] pid = [22:26:08.215] startup_data = {canAcceptConnections = CAC_OK} [22:26:08.215] cac = [22:26:08.215] __func__ = "BackendStartup" [22:26:08.215] #21 0x000055e067306867 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:26:08.215] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "4\211\263\177\000\000>\004\000\000\000\000\000\000\260\227\243\207\263\177\000\000\240\037\366\210\263\177\000\00083B\272\376\177\000\00043B\272\376\177", '\000' , "\352VHf\340U\000\000\3407Df\340U\000\000\0004B\272\376\177\000\000\3703B\272\376\177\000\000\225[\362\001uˠ研\210\210\263\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [22:26:08.215] i = 0 [22:26:08.215] now = [22:26:08.215] last_lockfile_recheck_time = 1737325229 [22:26:08.215] last_touch_time = 1737325229 [22:26:08.215] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -1170066368, user_data = 0x0}, {pos = 15, events = 0, fd = 1716016874, user_data = 0x7fb38936a668}, {pos = -2004314576, events = 32691, fd = -1992908064, user_data = 0x7c96e577}, {pos = -1170066304, events = 32766, fd = -1993078200, user_data = 0xf}, {pos = -2004314576, events = 32691, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1992908064, user_data = 0x7ffeba4233f8}, {pos = -1170066432, events = 32766, fd = -1992907160, user_data = 0x0}, {pos = -1829779744, events = 21984, fd = -2018579099, user_data = 0x7ffeba423913}, {pos = 1, events = 0, fd = -1170066432, user_data = 0xffffffff}, {pos = -2019368928, events = 32691, fd = -1997135968, user_data = 0x55e092f27f38}, {pos = -1829601768, events = 21984, fd = -1829602319, user_data = 0x7fb389346ebe}, {pos = 1, events = 0, fd = -1992908064, user_data = 0x1aa}, {pos = 1741323600, events = 21984, fd = 0, user_data = 0xe5}, {pos = -1829787064, events = 21984, fd = -1993052482, user_data = 0x1}, {pos = 0, events = 0, fd = -2019368928, user_data = 0x7fb387af2e40 }, {pos = 16, events = 0, fd = -1170065344, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fb3893491ba}, {pos = 0, events = 0, fd = -2018841180, user_data = 0x0}, {pos = 1748346592, events = 21984, fd = 2, user_data = 0x0}, {pos = -1830039984, events = 21984, fd = 1952410737, user_data = 0x160}, {pos = 1741323008, events = 21984, fd = 4, user_data = 0x2ffff00001fa0}, {pos = -1829787064, events = 21984, fd = -1993052482, user_data = 0x1}, {pos = -2018807699, events = 32691, fd = -2019334968, user_data = 0x55e092f2d3d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -2017518496, events = 32691, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55e092ebce50}, {pos = -2018805110, events = 32691, 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 = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 32512, 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 = -2017535520, events = 32691, fd = -2018897554, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1829601248, user_data = 0xe7a0cb7534fa3900}, {pos = -2017532448, events = 32691, fd = -328, user_data = 0x0}, {pos = -1829602088, events = 21984, fd = 1024, user_data = 0x55e092f27cd8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 26020, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1829787064, user_data = 0x7fb387af3053 }, {pos = -1829602088, events = 21984, fd = 1024, user_data = 0x7ffeba423908}, {pos = 1735689899, events = 21984, fd = 1748420752, user_data = 0x55e067737168 }, {pos = -1829602288, events = 21984, fd = -1829787344, user_data = 0x55e092f27c10}, {pos = -2018813762, events = 32691, fd = 0, user_data = 0x55e067748dd2 }, {pos = -1829602288, events = 1, fd = 1735692059, user_data = 0x55e092efa930}, {pos = 888813824, events = 3886074741, fd = 0, user_data = 0x7fb387aa2ab1}, {pos = -2018896656, events = 32691, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1830039984, user_data = 0xe7a0cb7534fa3900}, {pos = 0, events = 0, fd = 888813824, user_data = 0xc}, {pos = 888813824, events = 3886074741, fd = 0, user_data = 0x7fb387a5b239 }, {pos = 230, events = 0, fd = 1731195700, user_data = 0x400000}, {pos = 0, events = 0, fd = -1830039984, user_data = 0x55e067736ffc }, {pos = -1829953440, events = 21984, fd = -1829787344, user_data = 0x55e092ed2060}, {pos = 1, events = 0, fd = 0, user_data = 0x55e0676f5801 }, {pos = 12, events = 0, fd = -1829610952, user_data = 0x55e092f25a18}, {pos = 1748348000, events = 21984, fd = 296, user_data = 0x55e067301b4e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1731212057, events = 21984, fd = 1744730800, user_data = 0x55e092efb2d8}} [22:26:08.215] nevents = 1 [22:26:08.215] __func__ = "ServerLoop" [22:26:08.215] #22 0x000055e0673080c6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55e092eb8cc0) at ../src/backend/postmaster/postmaster.c:1377 [22:26:08.215] opt = [22:26:08.215] status = [22:26:08.215] userDoption = [22:26:08.215] listen_addr_saved = false [22:26:08.215] output_config_variable = [22:26:08.215] __func__ = "PostmasterMain" [22:26:08.215] #23 0x000055e06713ce9f in main (argc=4, argv=0x55e092eb8cc0) at ../src/backend/main/main.c:230 [22:26:08.215] do_check_root = [22:26:08.215] dispatch_option =