[13:26:38.467] src/tools/ci/cores_backtrace.sh linux /tmp/cores [13:26:38.679] dumping /tmp/cores/postgres-6-29025.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:26:38.927] [New LWP 29025] [13:26:38.927] [13:26:38.927] This GDB supports auto-downloading debuginfo from the following URLs: [13:26:38.927] [13:26:38.927] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:26:38.927] Debuginfod has been disabled. [13:26:38.927] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:26:39.050] [Thread debugging using libthread_db enabled] [13:26:39.050] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:26:39.050] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [13:26:39.050] Program terminated with signal SIGABRT, Aborted. [13:26:39.050] #0 0x00007f3be02a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:40.055] [13:26:40.055] Thread 1 (Thread 0x7f3bde221f00 (LWP 29025)): [13:26:40.055] #0 0x00007f3be02a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:40.055] No symbol table info available. [13:26:40.055] #1 0x00007f3be025afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:40.055] No symbol table info available. [13:26:40.055] #2 0x00007f3be0245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:40.055] No symbol table info available. [13:26:40.055] #3 0x000056276430fd96 in ExceptionalCondition (conditionName=conditionName@entry=0x56276458541d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x562764584970 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [13:26:40.055] No locals. [13:26:40.055] #4 0x0000562763c882fe in standard_ExecutorStart (queryDesc=queryDesc@entry=0x562766f8b330, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [13:26:40.055] estate = 0x562766e9d680 [13:26:40.055] oldcontext = 0x562766f0eee0 [13:26:40.055] __func__ = "standard_ExecutorStart" [13:26:40.055] #5 0x0000562763c884da in ExecutorStart (queryDesc=queryDesc@entry=0x562766f8b330, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [13:26:40.055] No locals. [13:26:40.055] #6 0x0000562763baa68d in refresh_matview_datafill (dest=0x562766dcf2d8, query=, query@entry=0x562766f1bc80, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [13:26:40.055] rewritten = [13:26:40.055] plan = 0x562766f8a8f8 [13:26:40.055] queryDesc = 0x562766f8b330 [13:26:40.055] copied_query = [13:26:40.055] processed = [13:26:40.055] __func__ = "refresh_matview_datafill" [13:26:40.055] #7 0x0000562763bac9ef 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 [13:26:40.055] dest = [13:26:40.055] matviewRel = 0x7f3bd48616e8 [13:26:40.055] rule = [13:26:40.055] actions = [13:26:40.055] dataQuery = 0x562766f1bc80 [13:26:40.055] tableSpace = [13:26:40.055] relowner = 10 [13:26:40.055] OIDNewHeap = 28582 [13:26:40.055] processed = 0 [13:26:40.055] relpersistence = 112 'p' [13:26:40.055] save_userid = 10 [13:26:40.055] save_sec_context = 0 [13:26:40.055] save_nestlevel = 2 [13:26:40.055] address = {classId = 0, objectId = 0, objectSubId = 0} [13:26:40.055] __func__ = "RefreshMatViewByOid" [13:26:40.055] #8 0x0000562763bacb2e in ExecRefreshMatView (stmt=0x562766f0cbd0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:26:40.055] matviewOid = [13:26:40.055] lockmode = [13:26:40.055] #9 0x0000562763b62705 in ExecCreateTableAs (pstate=pstate@entry=0x562766f0efe0, stmt=stmt@entry=0x562766d727f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffdcb056770) at ../src/backend/commands/createas.c:351 [13:26:40.055] refresh = [13:26:40.055] query = 0x562766d729b0 [13:26:40.055] into = 0x562766d72548 [13:26:40.055] jstate = 0x0 [13:26:40.055] is_matview = true [13:26:40.055] do_refresh = false [13:26:40.055] dest = [13:26:40.055] address = {classId = 1259, objectId = 28575, objectSubId = 0} [13:26:40.055] __func__ = "ExecCreateTableAs" [13:26:40.055] #10 0x000056276408490c in ProcessUtilitySlow (pstate=pstate@entry=0x562766f0efe0, pstmt=pstmt@entry=0x562766d728a0, queryString=queryString@entry=0x562766d71ab0 "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=0x562766d732d8, qc=0x7ffdcb056770) at ../src/backend/tcop/utility.c:1678 [13:26:40.055] _save_exception_stack = 0x7ffdcb056650 [13:26:40.055] _save_context_stack = 0x0 [13:26:40.055] _local_sigjmp_buf = {{__jmpbuf = {0, 7552061915221472801, 94727229089776, 0, 94727229086384, 0, 4286032562369345057, 7552068125457921569}, __mask_was_saved = 0, __saved_mask = {__val = {94727181391850, 94727230316600, 45008640326972, 10479, 94727181399454, 139894953553536, 139894953553536, 10479, 94727181401532, 1, 4294977775, 139894953553536, 94727181391850, 1, 45008688898104, 1}}}} [13:26:40.055] _do_rethrow = false [13:26:40.055] parsetree = 0x562766d727f0 [13:26:40.055] isTopLevel = true [13:26:40.055] isCompleteQuery = true [13:26:40.055] needCleanup = false [13:26:40.055] commandCollected = false [13:26:40.055] address = {classId = 22055, objectId = 1725376496, objectSubId = 22055} [13:26:40.055] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:26:40.055] __func__ = "ProcessUtilitySlow" [13:26:40.055] #11 0x0000562764082f1d in standard_ProcessUtility (pstmt=0x562766d728a0, queryString=0x562766d71ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x562766d732d8, qc=0x7ffdcb056770) at ../src/backend/tcop/utility.c:1070 [13:26:40.055] parsetree = 0x562766d727f0 [13:26:40.055] isTopLevel = true [13:26:40.055] isAtomicContext = false [13:26:40.055] pstate = 0x562766f0efe0 [13:26:40.055] readonly_flags = [13:26:40.055] __func__ = "standard_ProcessUtility" [13:26:40.055] #12 0x0000562764083078 in ProcessUtility (pstmt=pstmt@entry=0x562766d728a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x562766d732d8, qc=0x7ffdcb056770) at ../src/backend/tcop/utility.c:523 [13:26:40.055] No locals. [13:26:40.055] #13 0x000056276407ea36 in PortalRunUtility (portal=portal@entry=0x562766df60c0, pstmt=pstmt@entry=0x562766d728a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562766d732d8, qc=qc@entry=0x7ffdcb056770) at ../src/backend/tcop/pquery.c:1152 [13:26:40.055] No locals. [13:26:40.055] #14 0x000056276407efdb in PortalRunMulti (portal=portal@entry=0x562766df60c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562766d732d8, altdest=altdest@entry=0x562766d732d8, qc=qc@entry=0x7ffdcb056770) at ../src/backend/tcop/pquery.c:1309 [13:26:40.055] pstmt = 0x562766d728a0 [13:26:40.055] stmtlist_item__state = [13:26:40.055] active_snapshot_set = false [13:26:40.055] stmtlist_item = 0x562766d732a0 [13:26:40.055] #15 0x000056276407f543 in PortalRun (portal=portal@entry=0x562766df60c0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x562766d732d8, altdest=altdest@entry=0x562766d732d8, qc=qc@entry=0x7ffdcb056770) at ../src/backend/tcop/pquery.c:787 [13:26:40.055] _save_exception_stack = 0x7ffdcb056820 [13:26:40.055] _save_context_stack = 0x0 [13:26:40.055] _local_sigjmp_buf = {{__jmpbuf = {0, 7552061915019097633, 94727229628608, 94727229089896, 94727229089872, 94727229089824, 4286032562373539361, 7552068101999572513}, __mask_was_saved = 0, __saved_mask = {__val = {94727184924543, 3406128895, 4, 94727229089824, 112, 73, 94727229628608, 94727229089896, 94727229089872, 94727229089824, 94727185011746, 1, 2, 73, 94727174327393, 0}}}} [13:26:40.055] _do_rethrow = [13:26:40.055] result = [13:26:40.055] nprocessed = [13:26:40.055] saveTopTransactionResourceOwner = 0x562766db2d78 [13:26:40.055] saveTopTransactionContext = 0x562766e084f0 [13:26:40.055] saveActivePortal = 0x0 [13:26:40.055] saveResourceOwner = 0x562766db2d78 [13:26:40.055] savePortalContext = 0x0 [13:26:40.055] saveMemoryContext = 0x562766e084f0 [13:26:40.055] __func__ = "PortalRun" [13:26:40.055] #16 0x0000562764078a00 in exec_simple_query (query_string=query_string@entry=0x562766d71ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:26:40.055] cmdtaglen = 24 [13:26:40.055] snapshot_set = [13:26:40.055] per_parsetree_context = 0x0 [13:26:40.055] plantree_list = 0x562766d73288 [13:26:40.055] parsetree = 0x562766d72820 [13:26:40.055] commandTag = [13:26:40.055] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:26:40.055] querytree_list = [13:26:40.055] portal = 0x562766df60c0 [13:26:40.055] receiver = 0x562766d732d8 [13:26:40.055] format = 0 [13:26:40.055] cmdtagname = [13:26:40.055] parsetree_item__state = [13:26:40.055] dest = DestRemote [13:26:40.055] oldcontext = 0x562766e084f0 [13:26:40.055] parsetree_list = 0x562766d72850 [13:26:40.055] parsetree_item = 0x562766d72868 [13:26:40.055] save_log_statement_stats = false [13:26:40.055] was_logged = false [13:26:40.055] use_implicit_block = false [13:26:40.055] msec_str = "\004\000\000\000\000\000\000\000\r\\3d'V\000\000\000h\005\313\375\177\000\000G\000\000\000\000\000\000" [13:26:40.055] __func__ = "exec_simple_query" [13:26:40.055] #17 0x000056276407b759 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4820 [13:26:40.055] query_string = 0x562766d71ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:26:40.055] firstchar = [13:26:40.055] input_message = {data = 0x562766d71ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:26:40.055] local_sigjmp_buf = {{__jmpbuf = {94727197582712, 7552066045205820961, 140728009582972, 4, 8, 140728009583204, 4286032562440648225, 7552068104450094625}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94727228816848, 15616, 94727197576800, 94727229349168, 8, 94727184924091, 0, 9, 2, 94727197582720, 94727228816848, 94727197576800, 4, 8, 140728009583204}}}} [13:26:40.055] send_ready_for_query = false [13:26:40.055] idle_in_transaction_timeout_enabled = false [13:26:40.055] idle_session_timeout_enabled = false [13:26:40.055] __func__ = "PostgresMain" [13:26:40.055] #18 0x0000562764071583 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:26:40.055] bsdata = [13:26:40.055] #19 0x0000562763f22c5b in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x7ffdcb05697c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdcb0569d0) at ../src/backend/postmaster/launch_backend.c:274 [13:26:40.055] pid = [13:26:40.055] #20 0x0000562763f27c56 in BackendStartup (client_sock=client_sock@entry=0x7ffdcb0569d0) at ../src/backend/postmaster/postmaster.c:3389 [13:26:40.055] bn = 0x562766d9a178 [13:26:40.055] pid = [13:26:40.055] startup_data = {canAcceptConnections = CAC_OK} [13:26:40.055] cac = [13:26:40.055] __func__ = "BackendStartup" [13:26:40.055] #21 0x0000562763f29b2f in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [13:26:40.055] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "#\340;\177\000\000\240ou\341;\177\000\000xj\005\313\375\177\000\000tj\005\313\375\177", '\000' , "\362s\fc'V\000\000\210W\bc'V\000\000@k\005\313\375\177\000\0008k\005\313\375\177\000\000\225[\362\001\000\000\000\000\240ԣ\340;\177\000\000+", '\000' , "'V\000\000\000s\fc'V\000", __ss_align = 139895166596712}, salen = 2}} [13:26:40.055] i = 0 [13:26:40.055] now = [13:26:40.055] last_lockfile_recheck_time = 1734096150 [13:26:40.055] last_touch_time = 1734096150 [13:26:40.055] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x5627630c73f2}, {pos = -508168600, events = 32571, fd = -526133712, user_data = 0x7f3be1b5f2e0}, {pos = 2090263927, events = 0, fd = -888837184, user_data = 0x7f3be1b35a48}, {pos = 15, events = 0, fd = -526133712, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f3be1b5f2e0}, {pos = -888837320, events = 32765, fd = -888837312, user_data = 0x7f3be1b5f668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 1725380512, events = 22055, fd = 1, user_data = 0x7ffdcb057063}, {pos = -1, events = 0, fd = -534585312, user_data = 0x7f3be1756fa0}, {pos = 1725550936, events = 22055, fd = 1725550648, user_data = 0x562766d9f421}, {pos = -508313922, events = 32571, fd = 1, user_data = 0x7f3be1b5f2e0}, {pos = 427, events = 0, fd = 1686850904, user_data = 0x0}, {pos = 236, events = 0, fd = 1725373296, user_data = 0x7f3be1b3bebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f3be022e020}, {pos = -533778880, events = 32571, fd = 16, user_data = 0x7ffdcb056f90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -508304966, events = 32571, fd = 0, user_data = 0x7f3be02aeda4 }, {pos = 0, events = 0, fd = 1693804864, user_data = 0x2}, {pos = 0, events = 0, fd = 1725120112, user_data = 0x56276400f017 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 1725373296, user_data = 0x7f3be1b3bebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f3be02364c8}, {pos = -534024441, events = 32571, fd = 1693860992, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -532734880, events = 32571, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x332020200a0a4b65}, {pos = 822763892, events = 808727351, fd = 892417593, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1725566032, user_data = 0x7f3be02b576b}, {pos = -532751904, events = 32571, fd = -534113938, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x43f52c4f28d10500}, {pos = -532748832, events = 32571, fd = -328, user_data = 0x0}, {pos = 1725550328, events = 22055, 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 = 25282, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1725373296, user_data = 0x7f3be02f3053 }, {pos = 1725550328, events = 22055, fd = 1024, user_data = 0x7ffdcb057058}, {pos = 1681290162, events = 22055, fd = 1693869360, user_data = 0x562764355e6f }, {pos = 1725550128, events = 22055, fd = 1725372848, user_data = 0x562766d9ce30}, {pos = -534030485, events = 32571, fd = 0, user_data = 0x562764367ad9 }, {pos = 1725550128, events = 1, fd = 1681292322, user_data = 0x562766d719b0}, {pos = 684786944, events = 1140141135, fd = 0, user_data = 0x7f3be02a2ab1}, {pos = -534113040, events = 32571, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1725120112, user_data = 0x43f52c4f28d10500}, {pos = 0, events = 0, fd = 684786944, user_data = 0xc}, {pos = 684786944, events = 1140141135, fd = 0, user_data = 0x7f3be025b239 }, {pos = 237, events = 0, fd = 1676814680, user_data = 0x400000}, {pos = 0, events = 0, fd = 1725120112, user_data = 0x562764355d03 }, {pos = 1725206752, events = 22055, fd = 1725372848, user_data = 0x562766d490e0}, {pos = 1, events = 0, fd = 0, user_data = 0x562764314700 }, {pos = 12, events = 0, fd = 1725549704, user_data = 0x562766d9cc68}, {pos = 1693806272, events = 22055, fd = 296, user_data = 0x562763f25172 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1676831151, events = 22055, fd = 1690231248, user_data = 0x562766d72388}} [13:26:40.055] nevents = 1 [13:26:40.055] __func__ = "ServerLoop" [13:26:40.055] #22 0x0000562763f2b3b5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x562766d2fd30) at ../src/backend/postmaster/postmaster.c:1374 [13:26:40.055] opt = [13:26:40.055] status = [13:26:40.055] userDoption = [13:26:40.055] listen_addr_saved = false [13:26:40.055] output_config_variable = [13:26:40.055] __func__ = "PostmasterMain" [13:26:40.055] #23 0x0000562763d626d0 in main (argc=8, argv=0x562766d2fd30) at ../src/backend/main/main.c:224 [13:26:40.055] do_check_root = [13:26:40.055] dispatch_option = [13:26:40.091] -e [13:26:40.091] [13:26:40.091] [13:26:40.151] dumping /tmp/cores/postgres-6-29900.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:26:40.399] [New LWP 29900] [13:26:40.399] [13:26:40.399] This GDB supports auto-downloading debuginfo from the following URLs: [13:26:40.399] [13:26:40.399] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:26:40.399] Debuginfod has been disabled. [13:26:40.399] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:26:40.505] [Thread debugging using libthread_db enabled] [13:26:40.505] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:26:40.505] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [13:26:40.505] Program terminated with signal SIGABRT, Aborted. [13:26:40.505] #0 0x00007fe27d4a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:41.462] [13:26:41.462] Thread 1 (Thread 0x7fe27dc36f00 (LWP 29900)): [13:26:41.462] #0 0x00007fe27d4a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:41.462] No symbol table info available. [13:26:41.462] #1 0x00007fe27d45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:41.462] No symbol table info available. [13:26:41.462] #2 0x00007fe27d445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:41.462] No symbol table info available. [13:26:41.462] #3 0x00005602ae4abd96 in ExceptionalCondition (conditionName=conditionName@entry=0x5602ae72141d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5602ae720970 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [13:26:41.462] No locals. [13:26:41.462] #4 0x00005602ade242fe in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5602af862830, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [13:26:41.462] estate = 0x5602af88ff80 [13:26:41.462] oldcontext = 0x5602af843fd0 [13:26:41.462] __func__ = "standard_ExecutorStart" [13:26:41.462] #5 0x00005602ade244da in ExecutorStart (queryDesc=queryDesc@entry=0x5602af862830, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [13:26:41.462] No locals. [13:26:41.462] #6 0x00005602add4668d in refresh_matview_datafill (dest=0x5602af840f48, query=, query@entry=0x5602af89c450, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [13:26:41.462] rewritten = [13:26:41.462] plan = 0x5602af861df8 [13:26:41.462] queryDesc = 0x5602af862830 [13:26:41.462] copied_query = [13:26:41.462] processed = [13:26:41.462] __func__ = "refresh_matview_datafill" [13:26:41.462] #7 0x00005602add489ef in RefreshMatViewByOid (matviewOid=28443, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [13:26:41.462] dest = [13:26:41.462] matviewRel = 0x7fe271e1af18 [13:26:41.462] rule = [13:26:41.462] actions = [13:26:41.462] dataQuery = 0x5602af89c450 [13:26:41.462] tableSpace = [13:26:41.462] relowner = 10 [13:26:41.462] OIDNewHeap = 28450 [13:26:41.462] processed = 0 [13:26:41.462] relpersistence = 112 'p' [13:26:41.462] save_userid = 10 [13:26:41.462] save_sec_context = 0 [13:26:41.462] save_nestlevel = 2 [13:26:41.462] address = {classId = 0, objectId = 0, objectSubId = 0} [13:26:41.462] __func__ = "RefreshMatViewByOid" [13:26:41.462] #8 0x00005602add48b2e in ExecRefreshMatView (stmt=0x5602af841920, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:26:41.462] matviewOid = [13:26:41.462] lockmode = [13:26:41.462] #9 0x00005602adcfe705 in ExecCreateTableAs (pstate=pstate@entry=0x5602af8440d0, stmt=stmt@entry=0x5602af705770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffeeeac4e30) at ../src/backend/commands/createas.c:351 [13:26:41.462] refresh = [13:26:41.462] query = 0x5602af705930 [13:26:41.462] into = 0x5602af7054c8 [13:26:41.462] jstate = 0x0 [13:26:41.462] is_matview = true [13:26:41.462] do_refresh = false [13:26:41.462] dest = [13:26:41.462] address = {classId = 1259, objectId = 28443, objectSubId = 0} [13:26:41.462] __func__ = "ExecCreateTableAs" [13:26:41.462] #10 0x00005602ae22090c in ProcessUtilitySlow (pstate=pstate@entry=0x5602af8440d0, pstmt=pstmt@entry=0x5602af705820, queryString=queryString@entry=0x5602af704a30 "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=0x5602af706258, qc=0x7ffeeeac4e30) at ../src/backend/tcop/utility.c:1678 [13:26:41.462] _save_exception_stack = 0x7ffeeeac4d10 [13:26:41.462] _save_context_stack = 0x0 [13:26:41.462] _local_sigjmp_buf = {{__jmpbuf = {0, -725603497125000272, 94569533298544, 0, 94569533295152, 0, -6478814204687725648, -725605287340979280}, __mask_was_saved = 0, __saved_mask = {__val = {94569510803434, 94569534804632, 94569514647465, 140610749296056, 94569533295152, 94569516978222, 94569526985730, 94569526985856, 140732902689588, 94569517173465, 94569526985745, 94569526985856, 140732902689620, 94569517173480, 94569526985856, 0}}}} [13:26:41.462] _do_rethrow = false [13:26:41.462] parsetree = 0x5602af705770 [13:26:41.462] isTopLevel = true [13:26:41.462] isCompleteQuery = true [13:26:41.462] needCleanup = false [13:26:41.462] commandCollected = false [13:26:41.462] address = {classId = 22018, objectId = 2943375216, objectSubId = 22018} [13:26:41.462] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:26:41.462] __func__ = "ProcessUtilitySlow" [13:26:41.462] #11 0x00005602ae21ef1d in standard_ProcessUtility (pstmt=0x5602af705820, queryString=0x5602af704a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5602af706258, qc=0x7ffeeeac4e30) at ../src/backend/tcop/utility.c:1070 [13:26:41.462] parsetree = 0x5602af705770 [13:26:41.462] isTopLevel = true [13:26:41.462] isAtomicContext = false [13:26:41.462] pstate = 0x5602af8440d0 [13:26:41.462] readonly_flags = [13:26:41.462] __func__ = "standard_ProcessUtility" [13:26:41.462] #12 0x00005602ae21f078 in ProcessUtility (pstmt=pstmt@entry=0x5602af705820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5602af706258, qc=0x7ffeeeac4e30) at ../src/backend/tcop/utility.c:523 [13:26:41.462] No locals. [13:26:41.462] #13 0x00005602ae21aa36 in PortalRunUtility (portal=portal@entry=0x5602af7867a0, pstmt=pstmt@entry=0x5602af705820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5602af706258, qc=qc@entry=0x7ffeeeac4e30) at ../src/backend/tcop/pquery.c:1152 [13:26:41.462] No locals. [13:26:41.462] #14 0x00005602ae21afdb in PortalRunMulti (portal=portal@entry=0x5602af7867a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5602af706258, altdest=altdest@entry=0x5602af706258, qc=qc@entry=0x7ffeeeac4e30) at ../src/backend/tcop/pquery.c:1309 [13:26:41.462] pstmt = 0x5602af705820 [13:26:41.462] stmtlist_item__state = [13:26:41.462] active_snapshot_set = false [13:26:41.462] stmtlist_item = 0x5602af706220 [13:26:41.462] #15 0x00005602ae21b543 in PortalRun (portal=portal@entry=0x5602af7867a0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5602af706258, altdest=altdest@entry=0x5602af706258, qc=qc@entry=0x7ffeeeac4e30) at ../src/backend/tcop/pquery.c:787 [13:26:41.462] _save_exception_stack = 0x7ffeeeac4ee0 [13:26:41.462] _save_context_stack = 0x0 [13:26:41.462] _local_sigjmp_buf = {{__jmpbuf = {0, -725603496775824464, 94569533826976, 94569533298664, 94569533298640, 94569533298592, -6478814204834526288, -725605289593451600}, __mask_was_saved = 0, __saved_mask = {__val = {94569514336127, 4004269503, 4, 94569533298592, 112, 73, 94569533826976, 94569533298664, 94569533298640, 94569533298592, 94569514423330, 1, 2, 73, 94569503738977, 0}}}} [13:26:41.462] _do_rethrow = [13:26:41.462] result = [13:26:41.462] nprocessed = [13:26:41.462] saveTopTransactionResourceOwner = 0x5602af743958 [13:26:41.462] saveTopTransactionContext = 0x5602af79ac10 [13:26:41.462] saveActivePortal = 0x0 [13:26:41.462] saveResourceOwner = 0x5602af743958 [13:26:41.462] savePortalContext = 0x0 [13:26:41.462] saveMemoryContext = 0x5602af79ac10 [13:26:41.462] __func__ = "PortalRun" [13:26:41.462] #16 0x00005602ae214a00 in exec_simple_query (query_string=query_string@entry=0x5602af704a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:26:41.462] cmdtaglen = 24 [13:26:41.462] snapshot_set = [13:26:41.462] per_parsetree_context = 0x0 [13:26:41.462] plantree_list = 0x5602af706208 [13:26:41.462] parsetree = 0x5602af7057a0 [13:26:41.462] commandTag = [13:26:41.462] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:26:41.462] querytree_list = [13:26:41.462] portal = 0x5602af7867a0 [13:26:41.462] receiver = 0x5602af706258 [13:26:41.462] format = 0 [13:26:41.462] cmdtagname = [13:26:41.462] parsetree_item__state = [13:26:41.462] dest = DestRemote [13:26:41.462] oldcontext = 0x5602af79ac10 [13:26:41.462] parsetree_list = 0x5602af7057d0 [13:26:41.462] parsetree_item = 0x5602af7057e8 [13:26:41.462] save_log_statement_stats = false [13:26:41.462] was_logged = true [13:26:41.462] use_implicit_block = false [13:26:41.462] msec_str = "\004\000\000\000\000\000\000\000\r\034M\256\002V\000\000\300N\254\356\376\177\000\000G\000\000\000\000\000\000" [13:26:41.462] __func__ = "exec_simple_query" [13:26:41.462] #17 0x00005602ae217759 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4820 [13:26:41.462] query_string = 0x5602af704a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:26:41.462] firstchar = [13:26:41.462] input_message = {data = 0x5602af704a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:26:41.462] local_sigjmp_buf = {{__jmpbuf = {94569526994296, -725603224272942160, 140732902690876, 4, 15, 140732902691108, -6478814204767417424, -725605291972670544}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94569533025712, 14336, 94569526988384, 94569533548816, 15, 94569514335675, 0, 9, 2, 94569526994304, 94569533025712, 94569526988384, 4, 15, 140732902691108}}}} [13:26:41.462] send_ready_for_query = false [13:26:41.462] idle_in_transaction_timeout_enabled = false [13:26:41.462] idle_session_timeout_enabled = false [13:26:41.462] __func__ = "PostgresMain" [13:26:41.462] #18 0x00005602ae20d583 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:26:41.462] bsdata = [13:26:41.462] #19 0x00005602ae0bec5b in postmaster_child_launch (child_type=B_BACKEND, child_slot=15, startup_data=startup_data@entry=0x7ffeeeac503c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffeeeac5090) at ../src/backend/postmaster/launch_backend.c:274 [13:26:41.462] pid = [13:26:41.462] #20 0x00005602ae0c3c56 in BackendStartup (client_sock=client_sock@entry=0x7ffeeeac5090) at ../src/backend/postmaster/postmaster.c:3389 [13:26:41.462] bn = 0x5602af72c518 [13:26:41.462] pid = [13:26:41.462] startup_data = {canAcceptConnections = CAC_OK} [13:26:41.462] cac = [13:26:41.462] __func__ = "BackendStartup" [13:26:41.462] #21 0x00005602ae0c5b2f in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [13:26:41.462] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "C}\342\177\000\000\240/\224~\342\177\000\0008Q\254\356\376\177\000\0004Q\254\356\376\177", '\000' , "\3623&\255\002V\000\000\210\027\"\255\002V\000\000\000R\254\356\376\177\000\000\370Q\254\356\376\177\000\000\225[\362\001\000\000\000\000\240T\304}\342\177\000\000+", '\000' , "\002V\000\000\0003&\255\002V\000", __ss_align = 140610767898216}, salen = 2}} [13:26:41.462] i = 0 [13:26:41.462] now = [13:26:41.462] last_lockfile_recheck_time = 1734096152 [13:26:41.462] last_touch_time = 1734096152 [13:26:41.462] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x5602ad2633f2}, {pos = 2128561768, events = 32738, fd = 2110019120, user_data = 0x7fe27edf42e0}, {pos = 2090263927, events = 0, fd = -290696576, user_data = 0x7fe27edcaa48}, {pos = 15, events = 0, fd = 2110019120, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fe27edf42e0}, {pos = -290696712, events = 32766, fd = -290696704, user_data = 0x7fe27edf4668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -1351588128, events = 22018, fd = 1, user_data = 0x7ffeeeac5723}, {pos = -1, events = 0, fd = 2101534752, user_data = 0x7fe27e942fa0}, {pos = -1351417848, events = 22018, fd = -1351418136, user_data = 0x5602af72f4b1}, {pos = 2128416446, events = 32738, fd = 1, user_data = 0x7fe27edf42e0}, {pos = 427, events = 0, fd = -1364914856, user_data = 0x0}, {pos = 216, events = 0, fd = -1351595448, user_data = 0x7fe27edd0ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fe27d42e020}, {pos = 2102341184, events = 32738, fd = 16, user_data = 0x7ffeeeac5650}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 2128425402, events = 32738, fd = 0, user_data = 0x7fe27d4aeda4 }, {pos = 0, events = 0, fd = -1357960896, user_data = 0x2}, {pos = 0, events = 0, fd = -1351848368, user_data = 0x5602ae1ab017 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -1351595448, user_data = 0x7fe27edd0ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fe27d4364c8}, {pos = 2102095623, events = 32738, fd = -1357904768, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 2103385184, events = 32738, 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 = 4294967040, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1351405712, user_data = 0x7fe27d4b58be}, {pos = 2103368160, events = 32738, fd = 2102006126, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x85c49d7c32633c00}, {pos = 2103371232, events = 32738, fd = -328, user_data = 0x0}, {pos = -1351418456, events = 22018, 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 = 25885, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1351595448, user_data = 0x7fe27d4f3053 }, {pos = -1351418456, events = 22018, fd = 1024, user_data = 0x7ffeeeac5718}, {pos = -1370475598, events = 22018, fd = -1357896400, user_data = 0x5602ae4f1e6f }, {pos = -1351418656, events = 22018, fd = -1351595728, user_data = 0x5602af72fce0}, {pos = 2102089579, events = 32738, fd = 0, user_data = 0x5602ae503ad9 }, {pos = -1351418656, events = 1, fd = -1370473438, user_data = 0x5602af704930}, {pos = 845364224, events = 2244255100, fd = 0, user_data = 0x7fe27d4a2ab1}, {pos = 2102007024, events = 32738, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1351848368, user_data = 0x85c49d7c32633c00}, {pos = 0, events = 0, fd = 845364224, user_data = 0xc}, {pos = 845364224, events = 2244255100, fd = 0, user_data = 0x7fe27d45b239 }, {pos = 217, events = 0, fd = -1374951080, user_data = 0x400000}, {pos = 0, events = 0, fd = -1351848368, user_data = 0x5602ae4f1d03 }, {pos = -1351761824, events = 22018, fd = -1351595728, user_data = 0x5602af6dc060}, {pos = 1, events = 0, fd = 0, user_data = 0x5602ae4b0700 }, {pos = 12, events = 0, fd = -1351423208, user_data = 0x5602af72eaf8}, {pos = -1357959488, events = 22018, fd = 296, user_data = 0x5602ae0c1172 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1374934609, events = 22018, fd = -1361534512, user_data = 0x5602af7052d8}} [13:26:41.463] nevents = 1 [13:26:41.463] __func__ = "ServerLoop" [13:26:41.463] #22 0x00005602ae0c73b5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5602af6c2cc0) at ../src/backend/postmaster/postmaster.c:1374 [13:26:41.463] opt = [13:26:41.463] status = [13:26:41.463] userDoption = [13:26:41.463] listen_addr_saved = false [13:26:41.463] output_config_variable = [13:26:41.463] __func__ = "PostmasterMain" [13:26:41.463] #23 0x00005602adefe6d0 in main (argc=4, argv=0x5602af6c2cc0) at ../src/backend/main/main.c:224 [13:26:41.463] do_check_root = [13:26:41.463] dispatch_option = [13:26:41.498] -e [13:26:41.498] [13:26:41.498] [13:26:41.564] dumping /tmp/cores/postgres-6-36500.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:26:41.812] [New LWP 36500] [13:26:41.812] [13:26:41.812] This GDB supports auto-downloading debuginfo from the following URLs: [13:26:41.812] [13:26:41.812] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:26:41.812] Debuginfod has been disabled. [13:26:41.812] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:26:41.919] [Thread debugging using libthread_db enabled] [13:26:41.919] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:26:41.919] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [13:26:41.919] Program terminated with signal SIGABRT, Aborted. [13:26:41.919] #0 0x00007f81018a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:42.887] [13:26:42.887] Thread 1 (Thread 0x7f8102038f00 (LWP 36500)): [13:26:42.887] #0 0x00007f81018a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:42.887] No symbol table info available. [13:26:42.887] #1 0x00007f810185afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:42.887] No symbol table info available. [13:26:42.887] #2 0x00007f8101845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:26:42.887] No symbol table info available. [13:26:42.887] #3 0x0000555aedd31d96 in ExceptionalCondition (conditionName=conditionName@entry=0x555aedfa741d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x555aedfa6970 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [13:26:42.887] No locals. [13:26:42.887] #4 0x0000555aed6aa2fe in standard_ExecutorStart (queryDesc=0x555af07ccf90, eflags=0) at ../src/backend/executor/execMain.c:193 [13:26:42.887] estate = 0x555af0694c30 [13:26:42.887] oldcontext = 0x555af06ced60 [13:26:42.887] __func__ = "standard_ExecutorStart" [13:26:42.887] #5 0x00007f80ff8276e9 in pgss_ExecutorStart (queryDesc=0x555af07ccf90, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [13:26:42.887] No locals. [13:26:42.887] #6 0x0000555aed6aa493 in ExecutorStart (queryDesc=queryDesc@entry=0x555af07ccf90, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [13:26:42.887] No locals. [13:26:42.887] #7 0x0000555aed5cc68d in refresh_matview_datafill (dest=0x555af06ec148, query=, query@entry=0x555af073a510, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [13:26:42.887] rewritten = [13:26:42.887] plan = 0x555af07cc558 [13:26:42.887] queryDesc = 0x555af07ccf90 [13:26:42.887] copied_query = [13:26:42.887] processed = [13:26:42.887] __func__ = "refresh_matview_datafill" [13:26:42.887] #8 0x0000555aed5ce9ef in RefreshMatViewByOid (matviewOid=28450, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [13:26:42.887] dest = [13:26:42.887] matviewRel = 0x7f80fd37a658 [13:26:42.887] rule = [13:26:42.887] actions = [13:26:42.887] dataQuery = 0x555af073a510 [13:26:42.887] tableSpace = [13:26:42.887] relowner = 10 [13:26:42.887] OIDNewHeap = 28465 [13:26:42.887] processed = 0 [13:26:42.887] relpersistence = 112 'p' [13:26:42.887] save_userid = 10 [13:26:42.887] save_sec_context = 0 [13:26:42.887] save_nestlevel = 2 [13:26:42.887] address = {classId = 0, objectId = 0, objectSubId = 0} [13:26:42.887] __func__ = "RefreshMatViewByOid" [13:26:42.887] #9 0x0000555aed5ceb2e in ExecRefreshMatView (stmt=0x555af06e9ae0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:26:42.887] matviewOid = [13:26:42.887] lockmode = [13:26:42.887] #10 0x0000555aed584705 in ExecCreateTableAs (pstate=pstate@entry=0x555af06cee60, stmt=stmt@entry=0x555af05af790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffea78d1020) at ../src/backend/commands/createas.c:351 [13:26:42.887] refresh = [13:26:42.887] query = 0x555af05af950 [13:26:42.887] into = 0x555af05af4e8 [13:26:42.887] jstate = 0x0 [13:26:42.887] is_matview = true [13:26:42.887] do_refresh = false [13:26:42.887] dest = [13:26:42.887] address = {classId = 1259, objectId = 28450, objectSubId = 0} [13:26:42.887] __func__ = "ExecCreateTableAs" [13:26:42.887] #11 0x0000555aedaa690c in ProcessUtilitySlow (pstate=pstate@entry=0x555af06cee60, pstmt=pstmt@entry=0x555af05af840, queryString=queryString@entry=0x555af05aea50 "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=0x555af05b07e8, qc=0x7ffea78d1020) at ../src/backend/tcop/utility.c:1678 [13:26:42.887] _save_exception_stack = 0x7ffea78d0bf0 [13:26:42.887] _save_context_stack = 0x0 [13:26:42.887] _local_sigjmp_buf = {{__jmpbuf = {0, 3512177202716877229, 93849067911056, 0, 93849067907664, 0, 7346898356748820909, 3512237543550230957}, __mask_was_saved = 0, __saved_mask = {__val = {93849015789608, 93849068519696, 93849015810168, 5, 1, 1, 93849067914640, 93849067915440, 93849025819273, 4033784904, 93849025728062, 93849067907408, 64, 3, 93849025732479, 4033782808}}}} [13:26:42.887] _do_rethrow = false [13:26:42.887] parsetree = 0x555af05af790 [13:26:42.887] isTopLevel = true [13:26:42.887] isCompleteQuery = true [13:26:42.887] needCleanup = false [13:26:42.887] commandCollected = false [13:26:42.887] address = {classId = 21850, objectId = 4032493456, objectSubId = 21850} [13:26:42.887] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:26:42.887] __func__ = "ProcessUtilitySlow" [13:26:42.887] #12 0x0000555aedaa4f1d in standard_ProcessUtility (pstmt=pstmt@entry=0x555af05af840, queryString=queryString@entry=0x555af05aea50 "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=0x555af05b07e8, qc=0x7ffea78d1020) at ../src/backend/tcop/utility.c:1070 [13:26:42.887] parsetree = 0x555af05af790 [13:26:42.887] isTopLevel = true [13:26:42.887] isAtomicContext = false [13:26:42.887] pstate = 0x555af06cee60 [13:26:42.887] readonly_flags = [13:26:42.887] __func__ = "standard_ProcessUtility" [13:26:42.887] #13 0x00007f80ff82ad8f in pgss_ProcessUtility (pstmt=0x555af05af840, queryString=0x555af05aea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x555af05b07e8, qc=0x7ffea78d1020) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [13:26:42.887] _save_exception_stack = 0x7ffea78d0f00 [13:26:42.887] _save_context_stack = 0x0 [13:26:42.887] _local_sigjmp_buf = {{__jmpbuf = {0, -7347585153970331219, 93849067911232, 93849067915240, 140731709460512, 0, 7346898357105336749, 7280593531337318829}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140731709459744, 93849026050582, 1, 206158430232, 93849067912032, 140731709459840, 0, 93849020841065, 93849067907408, 93849022726289, 3, 93849019570013, 93849067911232}}}} [13:26:42.887] _do_rethrow = false [13:26:42.887] duration = [13:26:42.887] bufusage = {shared_blks_hit = 103, shared_blks_read = 93849022210215, shared_blks_dirtied = 93849068851304, shared_blks_written = 93849018715202, local_blks_hit = 93849019155927, local_blks_read = 93849068853240, local_blks_dirtied = 93849068851304, local_blks_written = 93849026043817, temp_blks_read = 140192061296056, temp_blks_written = 93849067907664, shared_blk_read_time = {ticks = 93849028374574}, shared_blk_write_time = {ticks = 93849038382082}, local_blk_read_time = {ticks = 93849038382208}, local_blk_write_time = {ticks = 140731709459748}, temp_blk_read_time = {ticks = 93849028569817}, temp_blk_write_time = {ticks = 93849038382097}} [13:26:42.887] walusage_start = {wal_records = 8964, wal_fpi = 144, wal_bytes = 1328400} [13:26:42.887] start = [13:26:42.887] rows = [13:26:42.887] bufusage_start = {shared_blks_hit = 34231, shared_blks_read = 4342, shared_blks_dirtied = 1557, shared_blks_written = 1019, 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}} [13:26:42.887] walusage = {wal_records = 1, wal_fpi = 4294967399, wal_bytes = 140191983539840} [13:26:42.887] parsetree = [13:26:42.887] saved_queryId = 6041762721901209185 [13:26:42.887] saved_stmt_location = 0 [13:26:42.887] saved_stmt_len = 69 [13:26:42.887] enabled = true [13:26:42.887] #14 0x0000555aedaa4fc3 in ProcessUtility (pstmt=pstmt@entry=0x555af05af840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x555af05b07e8, qc=0x7ffea78d1020) at ../src/backend/tcop/utility.c:519 [13:26:42.887] No locals. [13:26:42.887] #15 0x0000555aedaa0a36 in PortalRunUtility (portal=portal@entry=0x555af0631fc0, pstmt=pstmt@entry=0x555af05af840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x555af05b07e8, qc=qc@entry=0x7ffea78d1020) at ../src/backend/tcop/pquery.c:1152 [13:26:42.887] No locals. [13:26:42.887] #16 0x0000555aedaa0fdb in PortalRunMulti (portal=portal@entry=0x555af0631fc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x555af05b07e8, altdest=altdest@entry=0x555af05b07e8, qc=qc@entry=0x7ffea78d1020) at ../src/backend/tcop/pquery.c:1309 [13:26:42.887] pstmt = 0x555af05af840 [13:26:42.887] stmtlist_item__state = [13:26:42.887] active_snapshot_set = false [13:26:42.887] stmtlist_item = 0x555af05b07b0 [13:26:42.887] #17 0x0000555aedaa1543 in PortalRun (portal=portal@entry=0x555af0631fc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x555af05b07e8, altdest=altdest@entry=0x555af05b07e8, qc=qc@entry=0x7ffea78d1020) at ../src/backend/tcop/pquery.c:787 [13:26:42.887] _save_exception_stack = 0x7ffea78d10d0 [13:26:42.887] _save_context_stack = 0x0 [13:26:42.887] _local_sigjmp_buf = {{__jmpbuf = {0, 3512177196397109677, 93849068445632, 93849067911176, 93849067911152, 93849067911104, 7346898356994187693, 3512237541239300525}, __mask_was_saved = 0, __saved_mask = {__val = {93849025732479, 2811039663, 4, 93849067911104, 112, 73, 93849068445632, 93849067911176, 93849067911152, 93849067911104, 93849025819682, 1, 2, 73, 93849015135329, 0}}}} [13:26:42.887] _do_rethrow = [13:26:42.887] result = [13:26:42.887] nprocessed = [13:26:42.887] saveTopTransactionResourceOwner = 0x555af05f1498 [13:26:42.887] saveTopTransactionContext = 0x555af0643fe0 [13:26:42.887] saveActivePortal = 0x0 [13:26:42.887] saveResourceOwner = 0x555af05f1498 [13:26:42.887] savePortalContext = 0x0 [13:26:42.887] saveMemoryContext = 0x555af0643fe0 [13:26:42.887] __func__ = "PortalRun" [13:26:42.887] #18 0x0000555aeda9aa00 in exec_simple_query (query_string=query_string@entry=0x555af05aea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:26:42.887] cmdtaglen = 24 [13:26:42.887] snapshot_set = [13:26:42.887] per_parsetree_context = 0x0 [13:26:42.887] plantree_list = 0x555af05b0798 [13:26:42.887] parsetree = 0x555af05af7c0 [13:26:42.887] commandTag = [13:26:42.887] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:26:42.887] querytree_list = [13:26:42.887] portal = 0x555af0631fc0 [13:26:42.887] receiver = 0x555af05b07e8 [13:26:42.887] format = 0 [13:26:42.887] cmdtagname = [13:26:42.887] parsetree_item__state = [13:26:42.887] dest = DestRemote [13:26:42.887] oldcontext = 0x555af0643fe0 [13:26:42.887] parsetree_list = 0x555af05af7f0 [13:26:42.887] parsetree_item = 0x555af05af808 [13:26:42.887] save_log_statement_stats = false [13:26:42.887] was_logged = true [13:26:42.887] use_implicit_block = false [13:26:42.887] msec_str = "\004\000\000\000\000\000\000\000\r|\325\355ZU\000\000\260\020\215\247\376\177\000\000G\000\000\000\000\000\000" [13:26:42.887] __func__ = "exec_simple_query" [13:26:42.887] #19 0x0000555aeda9d759 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4820 [13:26:42.887] query_string = 0x555af05aea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:26:42.887] firstchar = [13:26:42.887] input_message = {data = 0x555af05aea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:26:42.887] local_sigjmp_buf = {{__jmpbuf = {93849038390648, 3512243704035942829, 140731709461036, 4, 9, 140731709461268, 7346898357463949741, 3512237513016877485}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 93849068165488, 0, 168, 93849025732581, 0, 10, 2, 93849038390656, 93849067638256, 93849038384736, 4, 9, 140731709461268}}}} [13:26:42.887] send_ready_for_query = false [13:26:42.887] idle_in_transaction_timeout_enabled = false [13:26:42.887] idle_session_timeout_enabled = false [13:26:42.887] __func__ = "PostgresMain" [13:26:42.887] #20 0x0000555aeda93583 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:26:42.887] bsdata = [13:26:42.887] #21 0x0000555aed944c5b in postmaster_child_launch (child_type=B_BACKEND, child_slot=9, startup_data=startup_data@entry=0x7ffea78d122c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffea78d1280) at ../src/backend/postmaster/launch_backend.c:274 [13:26:42.887] pid = [13:26:42.887] #22 0x0000555aed949c56 in BackendStartup (client_sock=client_sock@entry=0x7ffea78d1280) at ../src/backend/postmaster/postmaster.c:3389 [13:26:42.887] bn = 0x555af05db238 [13:26:42.887] pid = [13:26:42.887] startup_data = {canAcceptConnections = CAC_OK} [13:26:42.887] cac = [13:26:42.887] __func__ = "BackendStartup" [13:26:42.887] #23 0x0000555aed94bb2f in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [13:26:42.887] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "&\003\201\177\000\000>\004\000\000\000\000\000\000\260\227\203\001\201\177\000\000\240O\336\002\201\177\000\0008\023\215\247\376\177\000\0004\023\215\247\376\177", '\000' , "\362\223\256\354ZU\000\000\210w\252\354ZU\000\000\000\024\215\247\376\177\000\000\370\023\215\247\376\177\000\000\225[\362\001Z\252\3435p\212]\360ZU\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [13:26:42.887] i = 0 [13:26:42.887] now = [13:26:42.887] last_lockfile_recheck_time = 1734096187 [13:26:42.887] last_touch_time = 1734096187 [13:26:42.887] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -1483926464, user_data = 0x0}, {pos = 15, events = 0, fd = -324103182, user_data = 0x7f8103296668}, {pos = 40412720, events = 32641, fd = 53043936, user_data = 0x7c96e577}, {pos = -1483926400, events = 32766, fd = 52873800, user_data = 0xf}, {pos = 40412720, events = 32641, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 53043936, user_data = 0x7ffea78d13f8}, {pos = -1483926528, events = 32766, fd = 53044840, user_data = 0x0}, {pos = -262474384, events = 21850, fd = 26144101, user_data = 0x7ffea78d1913}, {pos = 1, events = 0, fd = -1483926528, user_data = 0xffffffff}, {pos = 25354272, events = 32641, fd = 48123808, user_data = 0x555af05df658}, {pos = -262277832, events = 21850, fd = -262254335, user_data = 0x7f8103272ebe}, {pos = 1, events = 0, fd = 53043936, user_data = 0x1ab}, {pos = -299012776, events = 21850, fd = 0, user_data = 0x56}, {pos = -262287160, events = 21850, fd = 52899518, user_data = 0x1}, {pos = 0, events = 0, fd = 25354272, user_data = 0x7f81018f2e40 }, {pos = 16, events = 0, fd = -1483925440, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f81032751ba}, {pos = 0, events = 0, fd = 25882020, user_data = 0x0}, {pos = -292058816, events = 21850, fd = 2, user_data = 0x0}, {pos = -262730096, events = 21850, fd = 1952410737, user_data = 0x161}, {pos = -299013368, events = 21850, fd = 4, user_data = 0x2ffff00001fa0}, {pos = -262287160, events = 21850, fd = 52899518, user_data = 0x1}, {pos = 25915143, events = 32641, fd = 25388232, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 27204704, events = 32641, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x555af0570e90}, {pos = 25918090, events = 32641, fd = 0, user_data = 0x0}, {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 = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f810268b540}, {pos = 40417920, events = 32641, 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 = 27187680, events = 32641, fd = 25825646, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x35e3aa5a18297b00}, {pos = 27190752, events = 32641, fd = -328, user_data = 0x0}, {pos = -262278152, events = 21850, fd = 1024, user_data = 0x555af05df3f8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 32440, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -262287160, user_data = 0x7f81018f3053 }, {pos = -262278152, events = 21850, fd = 1024, user_data = 0x7ffea78d1908}, {pos = -304573518, events = 21850, fd = -291994320, user_data = 0x555aedd77e6f }, {pos = -262278352, events = 21850, fd = -262477488, user_data = 0x555af05df330}, {pos = 25909099, events = 32641, fd = 0, user_data = 0x555aedd89ad9 }, {pos = -262278352, events = 1, fd = -304571358, user_data = 0x555af05ae950}, {pos = 405371648, events = 904112730, fd = 0, user_data = 0x7f81018a2ab1}, {pos = 25826544, events = 32641, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -262730096, user_data = 0x35e3aa5a18297b00}, {pos = 0, events = 0, fd = 405371648, user_data = 0xc}, {pos = 405371648, events = 904112730, fd = 0, user_data = 0x7f810185b239 }, {pos = 87, events = 0, fd = -309049000, user_data = 0x400000}, {pos = 0, events = 0, fd = -262730096, user_data = 0x555aedd77d03 }, {pos = -262643584, events = 21850, fd = -262477488, user_data = 0x555af0586080}, {pos = 1, events = 0, fd = 0, user_data = 0x555aedd36700 }, {pos = 12, events = 0, fd = -262291208, user_data = 0x555af05dc0d8}, {pos = -292057408, events = 21850, fd = 296, user_data = 0x555aed947172 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -309032529, events = 21850, fd = -295632432, user_data = 0x555af05af308}} [13:26:42.887] nevents = 1 [13:26:42.887] __func__ = "ServerLoop" [13:26:42.887] #24 0x0000555aed94d3b5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x555af056ccf0) at ../src/backend/postmaster/postmaster.c:1374 [13:26:42.887] opt = [13:26:42.887] status = [13:26:42.887] userDoption = [13:26:42.887] listen_addr_saved = false [13:26:42.887] output_config_variable = [13:26:42.887] __func__ = "PostmasterMain" [13:26:42.887] #25 0x0000555aed7846d0 in main (argc=4, argv=0x555af056ccf0) at ../src/backend/main/main.c:224 [13:26:42.887] do_check_root = [13:26:42.887] dispatch_option =