[04:58:06.442] src/tools/ci/cores_backtrace.sh linux /tmp/cores [04:58:06.635] dumping /tmp/cores/postgres-6-29424.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [04:58:06.874] [New LWP 29424] [04:58:06.874] [04:58:06.874] This GDB supports auto-downloading debuginfo from the following URLs: [04:58:06.874] [04:58:06.874] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:58:06.874] Debuginfod has been disabled. [04:58:06.874] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:58:07.000] [Thread debugging using libthread_db enabled] [04:58:07.000] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:58:07.000] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [04:58:07.000] Program terminated with signal SIGABRT, Aborted. [04:58:07.000] #0 0x00007f416f6a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:07.974] [04:58:07.974] Thread 1 (Thread 0x7f416d61ff00 (LWP 29424)): [04:58:07.974] #0 0x00007f416f6a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:07.974] No symbol table info available. [04:58:07.974] #1 0x00007f416f65afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:07.974] No symbol table info available. [04:58:07.974] #2 0x00007f416f645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:07.974] No symbol table info available. [04:58:07.974] #3 0x000056127fcda28e in ExceptionalCondition (conditionName=conditionName@entry=0x56127ff4bdad "queryDesc->sourceText != NULL", fileName=fileName@entry=0x56127ff4b290 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [04:58:07.974] No locals. [04:58:07.974] #4 0x000056127f6647c7 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x56128194dbf0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [04:58:07.974] estate = 0x5612817b3db0 [04:58:07.974] oldcontext = 0x5612818e52a0 [04:58:07.974] __func__ = "standard_ExecutorStart" [04:58:07.974] #5 0x000056127f6649a3 in ExecutorStart (queryDesc=queryDesc@entry=0x56128194dbf0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [04:58:07.974] No locals. [04:58:07.974] #6 0x000056127f58a8f8 in refresh_matview_datafill (dest=0x5612818be368, query=, query@entry=0x561281925920, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [04:58:07.974] rewritten = [04:58:07.974] plan = 0x56128194d128 [04:58:07.974] queryDesc = 0x56128194dbf0 [04:58:07.974] copied_query = [04:58:07.974] processed = [04:58:07.974] __func__ = "refresh_matview_datafill" [04:58:07.974] #7 0x000056127f58cc5f in RefreshMatViewByOid (matviewOid=27401, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [04:58:07.974] dest = [04:58:07.974] matviewRel = 0x7f4163c24ce8 [04:58:07.974] rule = [04:58:07.974] actions = [04:58:07.974] dataQuery = 0x561281925920 [04:58:07.974] tableSpace = [04:58:07.974] relowner = 10 [04:58:07.974] OIDNewHeap = 27422 [04:58:07.974] processed = 0 [04:58:07.974] relpersistence = 112 'p' [04:58:07.974] save_userid = 10 [04:58:07.974] save_sec_context = 0 [04:58:07.974] save_nestlevel = 2 [04:58:07.974] address = {classId = 0, objectId = 0, objectSubId = 0} [04:58:07.974] __func__ = "RefreshMatViewByOid" [04:58:07.974] #8 0x000056127f58cd9e in ExecRefreshMatView (stmt=0x5612818d1c40, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [04:58:07.974] matviewOid = [04:58:07.974] lockmode = [04:58:07.974] #9 0x000056127f543719 in ExecCreateTableAs (pstate=pstate@entry=0x5612818e53a0, stmt=stmt@entry=0x56128177e7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffecc188860) at ../src/backend/commands/createas.c:350 [04:58:07.974] refresh = [04:58:07.974] query = 0x56128177e9b0 [04:58:07.974] into = 0x56128177e548 [04:58:07.974] is_matview = true [04:58:07.974] do_refresh = false [04:58:07.974] dest = [04:58:07.974] address = {classId = 1259, objectId = 27401, objectSubId = 0} [04:58:07.974] __func__ = "ExecCreateTableAs" [04:58:07.974] #10 0x000056127fa5456d in ProcessUtilitySlow (pstate=pstate@entry=0x5612818e53a0, pstmt=pstmt@entry=0x56128177e8a0, queryString=queryString@entry=0x56128177dab0 "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=0x56128177f2d8, qc=0x7ffecc188860) at ../src/backend/tcop/utility.c:1675 [04:58:07.974] _save_exception_stack = 0x7ffecc188720 [04:58:07.974] _save_context_stack = 0x0 [04:58:07.974] _local_sigjmp_buf = {{__jmpbuf = {0, 4187954808923869703, 94637481519088, 0, 94637481515696, 0, 7621779879296225799, 4188179498161263111}, __mask_was_saved = 0, __saved_mask = {__val = {4294977395, 139918831857664, 94637450352936, 1, 43377047062376, 1, 10099, 139918831857664, 139918831857664, 1, 94637450362965, 94637481740136, 10630746926468407296, 139918831857664, 139918831857664, 10099}}}} [04:58:07.974] _do_rethrow = false [04:58:07.974] parsetree = 0x56128177e7f0 [04:58:07.974] isTopLevel = true [04:58:07.974] isCompleteQuery = true [04:58:07.974] needCleanup = false [04:58:07.974] commandCollected = false [04:58:07.974] address = {classId = 22034, objectId = 2172119024, objectSubId = 22034} [04:58:07.974] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [04:58:07.974] __func__ = "ProcessUtilitySlow" [04:58:07.974] #11 0x000056127fa52b7e in standard_ProcessUtility (pstmt=0x56128177e8a0, queryString=0x56128177dab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x56128177f2d8, qc=0x7ffecc188860) at ../src/backend/tcop/utility.c:1067 [04:58:07.974] parsetree = 0x56128177e7f0 [04:58:07.974] isTopLevel = true [04:58:07.974] isAtomicContext = false [04:58:07.974] pstate = 0x5612818e53a0 [04:58:07.974] readonly_flags = [04:58:07.974] __func__ = "standard_ProcessUtility" [04:58:07.974] #12 0x000056127fa52cd9 in ProcessUtility (pstmt=pstmt@entry=0x56128177e8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x56128177f2d8, qc=0x7ffecc188860) at ../src/backend/tcop/utility.c:523 [04:58:07.974] No locals. [04:58:07.974] #13 0x000056127fa4e545 in PortalRunUtility (portal=portal@entry=0x561281800050, pstmt=pstmt@entry=0x56128177e8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x56128177f2d8, qc=qc@entry=0x7ffecc188860) at ../src/backend/tcop/pquery.c:1158 [04:58:07.974] No locals. [04:58:07.974] #14 0x000056127fa4eaea in PortalRunMulti (portal=portal@entry=0x561281800050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x56128177f2d8, altdest=altdest@entry=0x56128177f2d8, qc=qc@entry=0x7ffecc188860) at ../src/backend/tcop/pquery.c:1316 [04:58:07.974] pstmt = 0x56128177e8a0 [04:58:07.974] stmtlist_item__state = [04:58:07.974] active_snapshot_set = false [04:58:07.974] stmtlist_item = 0x56128177f2a0 [04:58:07.974] #15 0x000056127fa4f0bd in PortalRun (portal=portal@entry=0x561281800050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x56128177f2d8, altdest=altdest@entry=0x56128177f2d8, qc=0x7ffecc188860) at ../src/backend/tcop/pquery.c:791 [04:58:07.974] _save_exception_stack = 0x7ffecc188910 [04:58:07.974] _save_context_stack = 0x0 [04:58:07.974] _local_sigjmp_buf = {{__jmpbuf = {0, 4187954809803624967, 94637482049616, 94637481519208, 94637482049616, 94637481519136, 7621779879426249223, 4188179513266655751}, __mask_was_saved = 0, __saved_mask = {__val = {94637453857334, 94637481515440, 112, 4, 94637453861751, 3424159727, 4, 94637481519136, 112, 73, 94637482049616, 94637481519208, 94637481519184, 94637481519136, 94637453948954, 1}}}} [04:58:07.974] _do_rethrow = [04:58:07.974] result = [04:58:07.974] nprocessed = [04:58:07.974] saveTopTransactionResourceOwner = 0x5612817bcd08 [04:58:07.974] saveTopTransactionContext = 0x561281811c60 [04:58:07.974] saveActivePortal = 0x0 [04:58:07.974] saveResourceOwner = 0x5612817bcd08 [04:58:07.974] savePortalContext = 0x0 [04:58:07.974] saveMemoryContext = 0x561281811c60 [04:58:07.974] __func__ = "PortalRun" [04:58:07.974] #16 0x000056127fa484a9 in exec_simple_query (query_string=query_string@entry=0x56128177dab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [04:58:07.974] cmdtaglen = 24 [04:58:07.974] snapshot_set = [04:58:07.974] per_parsetree_context = 0x0 [04:58:07.974] plantree_list = 0x56128177f288 [04:58:07.974] parsetree = 0x56128177e820 [04:58:07.974] commandTag = [04:58:07.974] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:58:07.974] querytree_list = [04:58:07.974] portal = 0x561281800050 [04:58:07.974] receiver = 0x56128177f2d8 [04:58:07.974] format = 0 [04:58:07.974] cmdtagname = [04:58:07.974] parsetree_item__state = [04:58:07.974] dest = DestRemote [04:58:07.974] oldcontext = 0x561281811c60 [04:58:07.974] parsetree_list = 0x56128177e850 [04:58:07.974] parsetree_item = 0x56128177e868 [04:58:07.974] save_log_statement_stats = false [04:58:07.974] was_logged = false [04:58:07.974] use_implicit_block = false [04:58:07.974] msec_str = "\300\212\030\314\376\177\000\000<\000\320\177\022V\000\000\360\210\030\314\376\177\000\000G\000\000\000\000\000\000" [04:58:07.974] __func__ = "exec_simple_query" [04:58:07.974] #17 0x000056127fa4b22d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [04:58:07.974] query_string = 0x56128177dab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [04:58:07.974] firstchar = [04:58:07.974] input_message = {data = 0x56128177dab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [04:58:07.974] local_sigjmp_buf = {{__jmpbuf = {94637466422808, 4187953448677528071, 4, 140732322581184, 140732322581328, 140732322581332, 7621779878960681479, 4188179510923219463}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94637481246160, 15616, 94637466416896, 94637481770176, 140732322581328, 94637453861299, 0, 9, 2, 94637466422816, 94637481246160, 94637466416896, 140732322581184, 140732322581328, 140732322581332}}}} [04:58:07.974] send_ready_for_query = false [04:58:07.974] idle_in_transaction_timeout_enabled = false [04:58:07.974] idle_session_timeout_enabled = false [04:58:07.974] __func__ = "PostgresMain" [04:58:07.974] #18 0x000056127fa410a4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:58:07.974] bsdata = [04:58:07.974] #19 0x000056127f8f8a43 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffecc188a6c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffecc188ac0) at ../src/backend/postmaster/launch_backend.c:274 [04:58:07.974] pid = [04:58:07.974] #20 0x000056127f8fe4f7 in BackendStartup (client_sock=client_sock@entry=0x7ffecc188ac0) at ../src/backend/postmaster/postmaster.c:3420 [04:58:07.974] bn = 0x5612817a65c8 [04:58:07.974] pid = [04:58:07.974] startup_data = {canAcceptConnections = CAC_OK} [04:58:07.974] __func__ = "BackendStartup" [04:58:07.974] #21 0x000056127f8fea59 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [04:58:07.974] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\365pA\177\000\000>\004\000\000\000\000\000\000\260\227coA\177\000\000\240߷pA\177\000\000x\213\030\314\376\177\000\000t\213\030\314\376\177", '\000' , "\346߫~\022V\000\000\230ǧ~\022V\000\000@\214\030\314\376\177\000\0008\214\030\314\376\177\000\000\225[\362\001\200\023v \204HpA\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [04:58:07.974] i = 0 [04:58:07.974] now = [04:58:07.974] last_lockfile_recheck_time = 1727585662 [04:58:07.974] last_touch_time = 1727585662 [04:58:07.974] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -870806400, user_data = 0x0}, {pos = 15, events = 0, fd = 2125193190, user_data = 0x7f4170f86668}, {pos = 1883801136, events = 32577, fd = 1895326432, user_data = 0x7c96e577}, {pos = -870806336, events = 32766, fd = 1895156296, user_data = 0xf}, {pos = 1883801136, events = 32577, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1895326432, user_data = 0x7ffecc188c38}, {pos = -870806464, events = 32766, fd = 1895327336, user_data = 0x0}, {pos = -2122843984, events = 22034, fd = 1869540581, user_data = 0x7ffecc189153}, {pos = 1, events = 0, fd = -870806464, user_data = 0xffffffff}, {pos = 1868750880, events = 32577, fd = 1891098528, user_data = 0x5612817aa748}, {pos = -2122668504, events = 22034, fd = -2122659775, user_data = 0x7f4170f62ebe}, {pos = 1, events = 0, fd = 1895326432, user_data = 0x1b6}, {pos = -2144895568, events = 22034, fd = 0, user_data = 0x1}, {pos = -2122851472, events = 22034, fd = 1895182014, user_data = 0x1}, {pos = 0, events = 0, fd = 1868750880, user_data = 0x7f416f6f2dc0 }, {pos = 16, events = 0, fd = -870805360, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f4170f651ba}, {pos = 0, events = 0, fd = 1869278500, user_data = 0x0}, {pos = -2138007648, events = 22034, fd = 2, user_data = 0x7}, {pos = -2123104656, events = 22034, fd = 1952410737, user_data = 0x169}, {pos = -2144896184, events = 22034, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -2122851472, events = 22034, fd = 1895182014, user_data = 0x1}, {pos = 1869311981, events = 32577, fd = 1868784840, user_data = 0x5612817a9410}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1870601312, events = 32577, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x56128173fe70}, {pos = 1869314570, events = 32577, 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 = 1212894546, fd = 168458615, user_data = 0x35373237310a6174}, {pos = 909522232, events = 808716850, 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 = 1870584288, events = 32577, fd = 1869222254, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0xc27613809a638a00}, {pos = 1870587360, events = 32577, fd = -328, user_data = 0x0}, {pos = -2122668824, events = 22034, fd = 1024, user_data = 0x5612817aa4e8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 25733, events = 0, fd = -328, user_data = 0x0}, {pos = -2122851472, events = 22034, fd = 1869557715, user_data = 0x7ffecc189148}, {pos = 2144540586, events = 22034, fd = -2137944624, user_data = 0x56127fd20267 }, {pos = -2122669024, events = 22034, fd = -2122851920, user_data = 0x5612817aa420}, {pos = 1869305918, events = 32577, fd = 0, user_data = 0x56127fd31ed1 }, {pos = -2122669024, events = 1, fd = 2144542746, user_data = 0x56128177d9b0}, {pos = -1704752640, events = 3262518144, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1869228721, user_data = 0x7f416f6a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1704752640, user_data = 0x5612817550e0}, {pos = -1704752640, events = 3262518144, fd = 11, user_data = 0xc27613809a638a00}, {pos = 0, events = 0, fd = 1868935737, user_data = 0x1}, {pos = 2140112704, events = 22034, fd = 4194304, user_data = 0x56127fd200fb }, {pos = -2123018016, events = 22034, fd = -2122851920, user_data = 0x5612817550e0}, {pos = 1, events = 0, fd = 0, user_data = 0x56127fd31ed1 }, {pos = -2123018016, events = 22034, fd = 2144542746, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x56127f72e14c }, {pos = 0, events = 0, fd = 2138256524, user_data = 0xb}, {pos = 2140133861, events = 22034, fd = -2141546256, user_data = 0x56128177e388}} [04:58:07.975] nevents = 1 [04:58:07.975] __func__ = "ServerLoop" [04:58:07.975] #22 0x000056127f9001dc in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x56128173bd30) at ../src/backend/postmaster/postmaster.c:1351 [04:58:07.975] opt = [04:58:07.975] status = [04:58:07.975] userDoption = [04:58:07.975] listen_addr_saved = false [04:58:07.975] output_config_variable = [04:58:07.975] __func__ = "PostmasterMain" [04:58:07.975] #23 0x000056127f73e528 in main (argc=8, argv=0x56128173bd30) at ../src/backend/main/main.c:197 [04:58:07.975] do_check_root = [04:58:08.009] -e [04:58:08.009] [04:58:08.009] [04:58:08.070] dumping /tmp/cores/postgres-6-30021.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:58:08.318] [New LWP 30021] [04:58:08.318] [04:58:08.318] This GDB supports auto-downloading debuginfo from the following URLs: [04:58:08.318] [04:58:08.318] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:58:08.318] Debuginfod has been disabled. [04:58:08.318] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:58:08.422] [Thread debugging using libthread_db enabled] [04:58:08.422] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:58:08.422] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [04:58:08.422] Program terminated with signal SIGABRT, Aborted. [04:58:08.422] #0 0x00007fcd906a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:09.364] [04:58:09.364] Thread 1 (Thread 0x7fcd905d9f00 (LWP 30021)): [04:58:09.364] #0 0x00007fcd906a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:09.364] No symbol table info available. [04:58:09.364] #1 0x00007fcd9065afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:09.364] No symbol table info available. [04:58:09.364] #2 0x00007fcd90645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:09.364] No symbol table info available. [04:58:09.364] #3 0x000055f8ac9a028e in ExceptionalCondition (conditionName=conditionName@entry=0x55f8acc11dad "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55f8acc11290 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [04:58:09.364] No locals. [04:58:09.364] #4 0x000055f8ac32a7c7 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55f8ae66a5f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [04:58:09.364] estate = 0x55f8ae5c0ce0 [04:58:09.364] oldcontext = 0x55f8ae622de0 [04:58:09.364] __func__ = "standard_ExecutorStart" [04:58:09.364] #5 0x000055f8ac32a9a3 in ExecutorStart (queryDesc=queryDesc@entry=0x55f8ae66a5f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [04:58:09.364] No locals. [04:58:09.364] #6 0x000055f8ac2508f8 in refresh_matview_datafill (dest=0x55f8ae61fa78, query=, query@entry=0x55f8ae5a0d20, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [04:58:09.364] rewritten = [04:58:09.364] plan = 0x55f8ae669b28 [04:58:09.364] queryDesc = 0x55f8ae66a5f0 [04:58:09.364] copied_query = [04:58:09.364] processed = [04:58:09.364] __func__ = "refresh_matview_datafill" [04:58:09.364] #7 0x000055f8ac252c5f in RefreshMatViewByOid (matviewOid=27459, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [04:58:09.364] dest = [04:58:09.364] matviewRel = 0x7fcd84fb9fb0 [04:58:09.364] rule = [04:58:09.364] actions = [04:58:09.364] dataQuery = 0x55f8ae5a0d20 [04:58:09.364] tableSpace = [04:58:09.364] relowner = 10 [04:58:09.364] OIDNewHeap = 27466 [04:58:09.364] processed = 0 [04:58:09.364] relpersistence = 112 'p' [04:58:09.364] save_userid = 10 [04:58:09.364] save_sec_context = 0 [04:58:09.364] save_nestlevel = 2 [04:58:09.364] address = {classId = 0, objectId = 0, objectSubId = 0} [04:58:09.364] __func__ = "RefreshMatViewByOid" [04:58:09.364] #8 0x000055f8ac252d9e in ExecRefreshMatView (stmt=0x55f8ae600240, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [04:58:09.364] matviewOid = [04:58:09.364] lockmode = [04:58:09.364] #9 0x000055f8ac209719 in ExecCreateTableAs (pstate=pstate@entry=0x55f8ae622ee0, stmt=stmt@entry=0x55f8ae48b770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff29aea610) at ../src/backend/commands/createas.c:350 [04:58:09.364] refresh = [04:58:09.364] query = 0x55f8ae48b930 [04:58:09.364] into = 0x55f8ae48b4c8 [04:58:09.364] is_matview = true [04:58:09.364] do_refresh = false [04:58:09.364] dest = [04:58:09.364] address = {classId = 1259, objectId = 27459, objectSubId = 0} [04:58:09.364] __func__ = "ExecCreateTableAs" [04:58:09.364] #10 0x000055f8ac71a56d in ProcessUtilitySlow (pstate=pstate@entry=0x55f8ae622ee0, pstmt=pstmt@entry=0x55f8ae48b820, queryString=queryString@entry=0x55f8ae48aa30 "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=0x55f8ae48c258, qc=0x7fff29aea610) at ../src/backend/tcop/utility.c:1675 [04:58:09.364] _save_exception_stack = 0x7fff29aea4d0 [04:58:09.364] _save_context_stack = 0x0 [04:58:09.364] _local_sigjmp_buf = {{__jmpbuf = {0, -5804118024629547977, 94526564251504, 0, 94526564248112, 0, -325193052425319369, -5804113963382633417}, __mask_was_saved = 0, __saved_mask = {__val = {4294980641, 140520681245312, 94526532794664, 1, 57319263742680, 1, 94526536614401, 140520867077560, 94526564248112, 94526538924005, 94526548855970, 94526548856096, 140733892698900, 94526539118648, 94526548855985, 94526548856096}}}} [04:58:09.364] _do_rethrow = false [04:58:09.364] parsetree = 0x55f8ae48b770 [04:58:09.364] isTopLevel = true [04:58:09.364] isCompleteQuery = true [04:58:09.364] needCleanup = false [04:58:09.364] commandCollected = false [04:58:09.364] address = {classId = 22008, objectId = 2924001136, objectSubId = 22008} [04:58:09.364] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [04:58:09.364] __func__ = "ProcessUtilitySlow" [04:58:09.364] #11 0x000055f8ac718b7e in standard_ProcessUtility (pstmt=0x55f8ae48b820, queryString=0x55f8ae48aa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55f8ae48c258, qc=0x7fff29aea610) at ../src/backend/tcop/utility.c:1067 [04:58:09.364] parsetree = 0x55f8ae48b770 [04:58:09.364] isTopLevel = true [04:58:09.364] isAtomicContext = false [04:58:09.364] pstate = 0x55f8ae622ee0 [04:58:09.364] readonly_flags = [04:58:09.364] __func__ = "standard_ProcessUtility" [04:58:09.364] #12 0x000055f8ac718cd9 in ProcessUtility (pstmt=pstmt@entry=0x55f8ae48b820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55f8ae48c258, qc=0x7fff29aea610) at ../src/backend/tcop/utility.c:523 [04:58:09.364] No locals. [04:58:09.364] #13 0x000055f8ac714545 in PortalRunUtility (portal=portal@entry=0x55f8ae50d680, pstmt=pstmt@entry=0x55f8ae48b820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f8ae48c258, qc=qc@entry=0x7fff29aea610) at ../src/backend/tcop/pquery.c:1158 [04:58:09.364] No locals. [04:58:09.364] #14 0x000055f8ac714aea in PortalRunMulti (portal=portal@entry=0x55f8ae50d680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f8ae48c258, altdest=altdest@entry=0x55f8ae48c258, qc=qc@entry=0x7fff29aea610) at ../src/backend/tcop/pquery.c:1316 [04:58:09.364] pstmt = 0x55f8ae48b820 [04:58:09.364] stmtlist_item__state = [04:58:09.364] active_snapshot_set = false [04:58:09.364] stmtlist_item = 0x55f8ae48c220 [04:58:09.364] #15 0x000055f8ac7150bd in PortalRun (portal=portal@entry=0x55f8ae50d680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55f8ae48c258, altdest=altdest@entry=0x55f8ae48c258, qc=0x7fff29aea610) at ../src/backend/tcop/pquery.c:791 [04:58:09.364] _save_exception_stack = 0x7fff29aea6c0 [04:58:09.364] _save_context_stack = 0x0 [04:58:09.364] _local_sigjmp_buf = {{__jmpbuf = {0, -5804118024295052233, 94526564783744, 94526564251624, 94526564783744, 94526564251552, -325193052555342793, -5804113956882904009}, __mask_was_saved = 0, __saved_mask = {__val = {94526536299062, 94526564247856, 112, 4, 94526536303479, 699311519, 4, 94526564251552, 112, 73, 94526564783744, 94526564251624, 94526564251600, 94526564251552, 94526536390682, 1}}}} [04:58:09.364] _do_rethrow = [04:58:09.364] result = [04:58:09.364] nprocessed = [04:58:09.364] saveTopTransactionResourceOwner = 0x55f8ae4ca838 [04:58:09.364] saveTopTransactionContext = 0x55f8ae51e660 [04:58:09.364] saveActivePortal = 0x0 [04:58:09.364] saveResourceOwner = 0x55f8ae4ca838 [04:58:09.364] savePortalContext = 0x0 [04:58:09.364] saveMemoryContext = 0x55f8ae51e660 [04:58:09.364] __func__ = "PortalRun" [04:58:09.364] #16 0x000055f8ac70e4a9 in exec_simple_query (query_string=query_string@entry=0x55f8ae48aa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [04:58:09.364] cmdtaglen = 24 [04:58:09.364] snapshot_set = [04:58:09.364] per_parsetree_context = 0x0 [04:58:09.364] plantree_list = 0x55f8ae48c208 [04:58:09.364] parsetree = 0x55f8ae48b7a0 [04:58:09.364] commandTag = [04:58:09.364] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:58:09.364] querytree_list = [04:58:09.364] portal = 0x55f8ae50d680 [04:58:09.364] receiver = 0x55f8ae48c258 [04:58:09.364] format = 0 [04:58:09.364] cmdtagname = [04:58:09.364] parsetree_item__state = [04:58:09.364] dest = DestRemote [04:58:09.364] oldcontext = 0x55f8ae51e660 [04:58:09.364] parsetree_list = 0x55f8ae48b7d0 [04:58:09.364] parsetree_item = 0x55f8ae48b7e8 [04:58:09.364] save_log_statement_stats = false [04:58:09.364] was_logged = true [04:58:09.364] use_implicit_block = false [04:58:09.364] msec_str = "p\250\256)\377\177\000\000<`\234\254\370U\000\000\240\246\256)\377\177\000\000G\000\000\000\000\000\000" [04:58:09.364] __func__ = "exec_simple_query" [04:58:09.364] #17 0x000055f8ac71122d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [04:58:09.364] query_string = 0x55f8ae48aa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [04:58:09.364] firstchar = [04:58:09.364] input_message = {data = 0x55f8ae48aa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [04:58:09.364] local_sigjmp_buf = {{__jmpbuf = {94526548864536, -5804111589225034697, 4, 140733892700272, 140733892700416, 140733892700420, -325193052492428233, -5804113958832075721}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94526563978672, 14336, 94526548858624, 94526564505584, 140733892700416, 94526536303027, 0, 9, 2, 94526548864544, 94526563978672, 94526548858624, 140733892700272, 140733892700416, 140733892700420}}}} [04:58:09.364] send_ready_for_query = false [04:58:09.364] idle_in_transaction_timeout_enabled = false [04:58:09.364] idle_session_timeout_enabled = false [04:58:09.364] __func__ = "PostgresMain" [04:58:09.364] #18 0x000055f8ac7070a4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:58:09.364] bsdata = [04:58:09.364] #19 0x000055f8ac5bea43 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff29aea81c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff29aea870) at ../src/backend/postmaster/launch_backend.c:274 [04:58:09.364] pid = [04:58:09.364] #20 0x000055f8ac5c44f7 in BackendStartup (client_sock=client_sock@entry=0x7fff29aea870) at ../src/backend/postmaster/postmaster.c:3420 [04:58:09.364] bn = 0x55f8ae4bfa28 [04:58:09.364] pid = [04:58:09.364] startup_data = {canAcceptConnections = CAC_OK} [04:58:09.364] __func__ = "BackendStartup" [04:58:09.364] #21 0x000055f8ac5c4a59 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [04:58:09.364] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "b\220\315\177\000\0004\251\256)\377\177\000\000\312@\366\221\315\177\000\000>\004\000\000\000\000\000\000\260\227c\220\315\177\000\000\240_\270\221\315\177\000\0008\251\256)\377\177\000\0004\251\256)\377\177\000\000\000\000\000\000\000\000\000\000Ш\256)\377\177\000\000\346?x\253\370U\000\000\230't\253\370U\000\000\000\252\256)\377\177\000\000\370\251\256)\377\177\000\000\225[\362\001\000\000\000", __ss_align = 140520882476192}, salen = 2}} [04:58:09.364] i = 0 [04:58:09.364] now = [04:58:09.364] last_lockfile_recheck_time = 1727585664 [04:58:09.364] last_touch_time = 1727585664 [04:58:09.364] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7fcd91f8e2e0}, {pos = 699312504, events = 0, fd = 0, user_data = 0x7fcd91f8e668}, {pos = -1418182682, events = 22008, fd = -1845959064, user_data = 0x7fcd91489630}, {pos = -1845959968, events = 32717, fd = 2090263927, user_data = 0x7fff29aeaa80}, {pos = -1846130104, events = 32717, fd = 15, user_data = 0x7fcd91489630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1845959968, events = 32717, fd = 699312632, user_data = 0x7fff29aeaa00}, {pos = -1845959064, events = 32717, fd = 0, user_data = 0x55f8ae4b9368}, {pos = -1370779064, events = 22008, fd = -1370779615, user_data = 0x7fcd00000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7fcd9062e020}, {pos = -1850187872, events = 32717, fd = -1370778776, user_data = 0x7fff29aeadf0}, {pos = -1370807608, events = 22008, fd = -1370778544, user_data = 0x55f8ae4b9368}, {pos = -1845959968, events = 32717, fd = 438, user_data = 0x55f8acf3ddb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55f8ae48aa48}, {pos = -1846104386, events = 32717, fd = 1, user_data = 0x0}, {pos = -1872568288, events = 32717, fd = -1871761984, user_data = 0x7fff29aeae60}, {pos = 699313728, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1846095430, user_data = 0x0}, {pos = -1872040668, events = 32717, fd = 0, user_data = 0x55f8ad5cf7a0 }, {pos = 2, events = 0, fd = 7, user_data = 0x55f8ae44ce50}, {pos = 0, events = 0, fd = -1872534328, user_data = 0x7fcd9069c880 }, {pos = -1872912968, events = 32717, fd = 8096, user_data = 0x100007f00000002}, {pos = -1872007545, events = 32717, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1870717856, events = 32717, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55f8ae44ce50}, {pos = -1872004598, events = 32717, fd = 1663923061, user_data = 0x55f8ae44ce50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffff0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x7f0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x1e3f8d212a407300}, {pos = -1870731808, events = 32717, fd = -328, user_data = 0x0}, {pos = -1370779384, events = 22008, fd = 1024, user_data = 0x55f8ae4b9108}, {pos = 699313912, events = 32767, fd = -1872003425, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 26266, events = 0, fd = -328, user_data = 0x0}, {pos = -1370969528, events = 22008, fd = -1871761453, user_data = 0x7fff29aeaef8}, {pos = -1398835286, events = 22008, fd = -1386353200, user_data = 0x55f8ac9e6267 }, {pos = -1370779584, events = 22008, fd = -1370969808, user_data = 0x55f8ae4b9040}, {pos = -1872013589, events = 32717, fd = 0, user_data = 0x55f8ac9f7ed1 }, {pos = -1370779584, events = 1, fd = -1398833126, user_data = 0x55f8ae48a930}, {pos = 708866816, events = 507481377, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1872090447, user_data = 0x7fcd906a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 708866816, user_data = 0x55f8ae462060}, {pos = 708866816, events = 507481377, fd = 11, user_data = 0x1e3f8d212a407300}, {pos = 0, events = 0, fd = -1872383431, user_data = 0x1}, {pos = -1403263168, events = 22008, fd = 4194304, user_data = 0x55f8ac9e60fb }, {pos = -1371135904, events = 22008, fd = -1370969808, user_data = 0x55f8ae462060}, {pos = 1, events = 0, fd = 0, user_data = 0x55f8ac9f7ed1 }, {pos = -1371135904, events = 22008, fd = -1398833126, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55f8ac3f414c }, {pos = 0, events = 0, fd = -1405119348, user_data = 0xb}, {pos = -1403242011, events = 22008, fd = -1389954832, user_data = 0x55f8ae48b2d8}} [04:58:09.364] nevents = 1 [04:58:09.364] __func__ = "ServerLoop" [04:58:09.364] #22 0x000055f8ac5c61dc in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55f8ae448cc0) at ../src/backend/postmaster/postmaster.c:1351 [04:58:09.364] opt = [04:58:09.364] status = [04:58:09.364] userDoption = [04:58:09.364] listen_addr_saved = false [04:58:09.364] output_config_variable = [04:58:09.364] __func__ = "PostmasterMain" [04:58:09.364] #23 0x000055f8ac404528 in main (argc=4, argv=0x55f8ae448cc0) at ../src/backend/main/main.c:197 [04:58:09.364] do_check_root = [04:58:09.399] -e [04:58:09.399] [04:58:09.399] [04:58:09.460] dumping /tmp/cores/postgres-6-36504.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:58:09.699] [New LWP 36504] [04:58:09.699] [04:58:09.699] This GDB supports auto-downloading debuginfo from the following URLs: [04:58:09.699] [04:58:09.699] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:58:09.699] Debuginfod has been disabled. [04:58:09.699] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:58:09.804] [Thread debugging using libthread_db enabled] [04:58:09.804] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:58:09.804] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [04:58:09.804] Program terminated with signal SIGABRT, Aborted. [04:58:09.804] #0 0x00007f46568a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:10.759] [04:58:10.759] Thread 1 (Thread 0x7f46567d8f00 (LWP 36504)): [04:58:10.759] #0 0x00007f46568a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:10.759] No symbol table info available. [04:58:10.759] #1 0x00007f465685afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:10.759] No symbol table info available. [04:58:10.759] #2 0x00007f4656845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:58:10.759] No symbol table info available. [04:58:10.759] #3 0x000055d89ff7628e in ExceptionalCondition (conditionName=conditionName@entry=0x55d8a01e7dad "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55d8a01e7290 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [04:58:10.759] No locals. [04:58:10.759] #4 0x000055d89f9007c7 in standard_ExecutorStart (queryDesc=0x55d8a1ffca20, eflags=0) at ../src/backend/executor/execMain.c:194 [04:58:10.759] estate = 0x55d8a1ed8eb0 [04:58:10.759] oldcontext = 0x55d8a1f3bca0 [04:58:10.759] __func__ = "standard_ExecutorStart" [04:58:10.759] #5 0x00007f4653f616f7 in pgss_ExecutorStart (queryDesc=0x55d8a1ffca20, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [04:58:10.759] No locals. [04:58:10.759] #6 0x000055d89f90095c in ExecutorStart (queryDesc=queryDesc@entry=0x55d8a1ffca20, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [04:58:10.759] No locals. [04:58:10.759] #7 0x000055d89f8268f8 in refresh_matview_datafill (dest=0x55d8a1f83558, query=, query@entry=0x55d8a1f7d660, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [04:58:10.759] rewritten = [04:58:10.759] plan = 0x55d8a1ffbf58 [04:58:10.759] queryDesc = 0x55d8a1ffca20 [04:58:10.759] copied_query = [04:58:10.759] processed = [04:58:10.759] __func__ = "refresh_matview_datafill" [04:58:10.759] #8 0x000055d89f828c5f in RefreshMatViewByOid (matviewOid=27377, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [04:58:10.759] dest = [04:58:10.759] matviewRel = 0x7f4652343d28 [04:58:10.759] rule = [04:58:10.759] actions = [04:58:10.759] dataQuery = 0x55d8a1f7d660 [04:58:10.759] tableSpace = [04:58:10.759] relowner = 10 [04:58:10.759] OIDNewHeap = 27384 [04:58:10.759] processed = 0 [04:58:10.759] relpersistence = 112 'p' [04:58:10.759] save_userid = 10 [04:58:10.759] save_sec_context = 0 [04:58:10.759] save_nestlevel = 2 [04:58:10.759] address = {classId = 0, objectId = 0, objectSubId = 0} [04:58:10.759] __func__ = "RefreshMatViewByOid" [04:58:10.759] #9 0x000055d89f828d9e in ExecRefreshMatView (stmt=0x55d8a1f37d80, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [04:58:10.759] matviewOid = [04:58:10.759] lockmode = [04:58:10.759] #10 0x000055d89f7df719 in ExecCreateTableAs (pstate=pstate@entry=0x55d8a1f3bda0, stmt=stmt@entry=0x55d8a1ddc790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffeb073fa40) at ../src/backend/commands/createas.c:350 [04:58:10.759] refresh = [04:58:10.759] query = 0x55d8a1ddc950 [04:58:10.759] into = 0x55d8a1ddc4e8 [04:58:10.759] is_matview = true [04:58:10.759] do_refresh = false [04:58:10.759] dest = [04:58:10.759] address = {classId = 1259, objectId = 27377, objectSubId = 0} [04:58:10.759] __func__ = "ExecCreateTableAs" [04:58:10.759] #11 0x000055d89fcf056d in ProcessUtilitySlow (pstate=pstate@entry=0x55d8a1f3bda0, pstmt=pstmt@entry=0x55d8a1ddc840, queryString=queryString@entry=0x55d8a1ddba50 "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=0x55d8a1ddd7e8, qc=0x7ffeb073fa40) at ../src/backend/tcop/utility.c:1675 [04:58:10.759] _save_exception_stack = 0x7ffeb073f5f0 [04:58:10.759] _save_context_stack = 0x0 [04:58:10.759] _local_sigjmp_buf = {{__jmpbuf = {0, -7122257387881429923, 94388916963216, 0, 94388916959824, 0, -3934866275289988003, -7122209154405563299}, __mask_was_saved = 0, __saved_mask = {__val = {94388881865447, 0, 0, 94388887917792, 94388882118114, 139940006344128, 1, 16777216, 0, 112, 94388881865719, 139940007141376, 139940007141376, 0, 0, 139940006344128}}}} [04:58:10.759] _do_rethrow = false [04:58:10.759] parsetree = 0x55d8a1ddc790 [04:58:10.759] isTopLevel = true [04:58:10.759] isCompleteQuery = true [04:58:10.759] needCleanup = false [04:58:10.759] commandCollected = false [04:58:10.759] address = {classId = 21976, objectId = 2715666320, objectSubId = 21976} [04:58:10.759] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [04:58:10.759] __func__ = "ProcessUtilitySlow" [04:58:10.759] #12 0x000055d89fceeb7e in standard_ProcessUtility (pstmt=pstmt@entry=0x55d8a1ddc840, queryString=queryString@entry=0x55d8a1ddba50 "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=0x55d8a1ddd7e8, qc=0x7ffeb073fa40) at ../src/backend/tcop/utility.c:1067 [04:58:10.759] parsetree = 0x55d8a1ddc790 [04:58:10.759] isTopLevel = true [04:58:10.759] isAtomicContext = false [04:58:10.759] pstate = 0x55d8a1f3bda0 [04:58:10.759] readonly_flags = [04:58:10.759] __func__ = "standard_ProcessUtility" [04:58:10.759] #13 0x00007f4653f64d4a in pgss_ProcessUtility (pstmt=0x55d8a1ddc840, queryString=0x55d8a1ddba50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55d8a1ddd7e8, qc=0x7ffeb073fa40) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [04:58:10.759] _save_exception_stack = 0x7ffeb073f900 [04:58:10.759] _save_context_stack = 0x0 [04:58:10.759] _local_sigjmp_buf = {{__jmpbuf = {0, 3934434270225695837, 94388916963392, 94388916967400, 140731858811456, 0, -3934866275461954467, -4029229684691106723}, __mask_was_saved = 0, __saved_mask = {__val = {94388885683093, 140731858810726, 140731858810724, 0, 0, 0, 206158430232, 140731858810688, 94388885683310, 341, 206158430232, 94388916964192, 140731858810784, 0, 94388880526083, 94388916959568}}}} [04:58:10.759] _do_rethrow = false [04:58:10.759] duration = [04:58:10.759] bufusage = {shared_blks_hit = 94388917998312, shared_blks_read = 927712935936, shared_blks_dirtied = 94388919185752, shared_blks_written = 94388878861774, local_blks_hit = 94388917997816, local_blks_read = 94388917997232, local_blks_dirtied = 94388878860883, local_blks_written = 94388878413330, temp_blks_read = 94388917997816, temp_blks_written = 94388878384647, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94388885676545}, local_blk_read_time = {ticks = 139940075507128}, local_blk_write_time = {ticks = 94388916959824}, temp_blk_read_time = {ticks = 94388887986149}, temp_blk_write_time = {ticks = 94388897918114}} [04:58:10.759] walusage_start = {wal_records = 8933, wal_fpi = 133, wal_bytes = 1228089} [04:58:10.759] start = [04:58:10.759] rows = [04:58:10.759] bufusage_start = {shared_blks_hit = 35342, shared_blks_read = 3742, shared_blks_dirtied = 1521, shared_blks_written = 986, 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}} [04:58:10.759] walusage = {wal_records = 0, wal_fpi = 927712935936, wal_bytes = 94388918000248} [04:58:10.759] parsetree = [04:58:10.759] saved_queryId = 6041762721901209185 [04:58:10.759] saved_stmt_location = 0 [04:58:10.759] saved_stmt_len = 69 [04:58:10.759] enabled = true [04:58:10.759] #14 0x000055d89fceec24 in ProcessUtility (pstmt=pstmt@entry=0x55d8a1ddc840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55d8a1ddd7e8, qc=0x7ffeb073fa40) at ../src/backend/tcop/utility.c:519 [04:58:10.759] No locals. [04:58:10.759] #15 0x000055d89fcea545 in PortalRunUtility (portal=portal@entry=0x55d8a1e5cf90, pstmt=pstmt@entry=0x55d8a1ddc840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d8a1ddd7e8, qc=qc@entry=0x7ffeb073fa40) at ../src/backend/tcop/pquery.c:1158 [04:58:10.759] No locals. [04:58:10.759] #16 0x000055d89fceaaea in PortalRunMulti (portal=portal@entry=0x55d8a1e5cf90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d8a1ddd7e8, altdest=altdest@entry=0x55d8a1ddd7e8, qc=qc@entry=0x7ffeb073fa40) at ../src/backend/tcop/pquery.c:1316 [04:58:10.759] pstmt = 0x55d8a1ddc840 [04:58:10.759] stmtlist_item__state = [04:58:10.759] active_snapshot_set = false [04:58:10.759] stmtlist_item = 0x55d8a1ddd7b0 [04:58:10.759] #17 0x000055d89fceb0bd in PortalRun (portal=portal@entry=0x55d8a1e5cf90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55d8a1ddd7e8, altdest=altdest@entry=0x55d8a1ddd7e8, qc=0x7ffeb073fa40) at ../src/backend/tcop/pquery.c:791 [04:58:10.759] _save_exception_stack = 0x7ffeb073faf0 [04:58:10.759] _save_context_stack = 0x0 [04:58:10.759] _local_sigjmp_buf = {{__jmpbuf = {0, -7122257387767135139, 94388917489552, 94388916963336, 94388917489552, 94388916963264, -3934866275036232611, -7122209152332135331}, __mask_was_saved = 0, __saved_mask = {__val = {94388885361206, 94388916959568, 112, 4, 94388885365623, 2960390607, 4, 94388916963264, 112, 73, 94388917489552, 94388916963336, 94388916963312, 94388916963264, 94388885452826, 1}}}} [04:58:10.759] _do_rethrow = [04:58:10.759] result = [04:58:10.759] nprocessed = [04:58:10.759] saveTopTransactionResourceOwner = 0x55d8a1e1c468 [04:58:10.759] saveTopTransactionContext = 0x55d8a1e6aed0 [04:58:10.759] saveActivePortal = 0x0 [04:58:10.759] saveResourceOwner = 0x55d8a1e1c468 [04:58:10.759] savePortalContext = 0x0 [04:58:10.759] saveMemoryContext = 0x55d8a1e6aed0 [04:58:10.759] __func__ = "PortalRun" [04:58:10.759] #18 0x000055d89fce44a9 in exec_simple_query (query_string=query_string@entry=0x55d8a1ddba50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [04:58:10.759] cmdtaglen = 24 [04:58:10.759] snapshot_set = [04:58:10.759] per_parsetree_context = 0x0 [04:58:10.759] plantree_list = 0x55d8a1ddd798 [04:58:10.759] parsetree = 0x55d8a1ddc7c0 [04:58:10.759] commandTag = [04:58:10.759] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:58:10.759] querytree_list = [04:58:10.759] portal = 0x55d8a1e5cf90 [04:58:10.759] receiver = 0x55d8a1ddd7e8 [04:58:10.759] format = 0 [04:58:10.759] cmdtagname = [04:58:10.759] parsetree_item__state = [04:58:10.759] dest = DestRemote [04:58:10.759] oldcontext = 0x55d8a1e6aed0 [04:58:10.759] parsetree_list = 0x55d8a1ddc7f0 [04:58:10.759] parsetree_item = 0x55d8a1ddc808 [04:58:10.759] save_log_statement_stats = false [04:58:10.759] was_logged = true [04:58:10.759] use_implicit_block = false [04:58:10.759] msec_str = "\240\374s\260\376\177\000\000<\300\371\237\330U\000\000\320\372s\260\376\177\000\000G\000\000\000\000\000\000" [04:58:10.759] __func__ = "exec_simple_query" [04:58:10.759] #19 0x000055d89fce722d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [04:58:10.759] query_string = 0x55d8a1ddba50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [04:58:10.759] firstchar = [04:58:10.759] input_message = {data = 0x55d8a1ddba50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [04:58:10.759] local_sigjmp_buf = {{__jmpbuf = {94388897926680, -7122255442458377123, 4, 140731858812064, 140731858812208, 140731858812212, -3934866275107535779, -7122209150091459491}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94388917209408, 0, 168, 94388885365725, 0, 10, 2, 94388897926688, 94388916690416, 94388897920768, 140731858812064, 140731858812208, 140731858812212}}}} [04:58:10.759] send_ready_for_query = false [04:58:10.759] idle_in_transaction_timeout_enabled = false [04:58:10.759] idle_session_timeout_enabled = false [04:58:10.759] __func__ = "PostgresMain" [04:58:10.759] #20 0x000055d89fcdd0a4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:58:10.759] bsdata = [04:58:10.759] #21 0x000055d89fb94a43 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffeb073fc4c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffeb073fca0) at ../src/backend/postmaster/launch_backend.c:274 [04:58:10.759] pid = [04:58:10.759] #22 0x000055d89fb9a4f7 in BackendStartup (client_sock=client_sock@entry=0x7ffeb073fca0) at ../src/backend/postmaster/postmaster.c:3420 [04:58:10.759] bn = 0x55d8a1e08298 [04:58:10.759] pid = [04:58:10.759] startup_data = {canAcceptConnections = CAC_OK} [04:58:10.759] __func__ = "BackendStartup" [04:58:10.759] #23 0x000055d89fb9aa59 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [04:58:10.759] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "s\260\376\177\000\0004\375s\260\376\177", '\000' , "\346\237՞\330U\000\000\230\207ў\330U\000\000\000\376s\260\376\177\000\000\370\375s\260\376\177\000\000\225[\362\001\000\000\000\000pZ\340\241\330U\000\000,", '\000' , "\373\236՞\330U\000\000h\226\031XF\177\000\0000\206\003WF\177\000", __ss_align = 139940102509280}, salen = 2}} [04:58:10.759] i = 0 [04:58:10.759] now = [04:58:10.759] last_lockfile_recheck_time = 1727585697 [04:58:10.759] last_touch_time = 1727585697 [04:58:10.759] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1630167066, events = 21976, fd = 1478071912, user_data = 0x7f4657038630}, {pos = 1478071008, events = 32582, fd = 2090263927, user_data = 0x7ffeb073fe80}, {pos = 1477900872, events = 32582, fd = 15, user_data = 0x7f4657038630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1478071008, events = 32582, fd = -1334575624, user_data = 0x7ffeb073fe00}, {pos = 1478071912, events = 32582, fd = 0, user_data = 0x55d8a1ddd890}, {pos = -1610581373, events = 21976, fd = 32768, user_data = 0x1}, {pos = -1579301520, events = 21976, fd = -1, user_data = 0x7f465682e020}, {pos = 1473843104, events = 32582, fd = -1579126008, user_data = 0x55d8a1e071e8}, {pos = -1579108207, events = 21976, fd = 1477926590, user_data = 0x1}, {pos = 1478071008, events = 32582, fd = 438, user_data = 0x55d8a0513db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55d8a1ddd890}, {pos = 1477926590, events = 32582, fd = 1, user_data = 0x0}, {pos = 1451417632, events = 32582, fd = 1452223936, user_data = 0x10}, {pos = -1334574480, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1477935546, user_data = 0x0}, {pos = 1451945252, events = 32582, fd = 0, user_data = 0x55d8a0ba57a0 }, {pos = 2, events = 0, fd = 7, user_data = 0x55d8a1d9de90}, {pos = -1614318485, events = 21976, fd = -1579087525, user_data = 0x55d89fc7b0a4 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55d8a1ddd890}, {pos = 1477926590, events = 32582, fd = 1, user_data = 0x0}, {pos = 1451451592, events = 32582, fd = 1451870336, user_data = 0x423}, {pos = 1451978733, events = 32582, fd = 2, user_data = 0x55d8a1e10900}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = 1453268064, events = 32582, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa48}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 1459852608, user_data = 0x7f4657039a80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = -1610902986, events = 21976, fd = -1579112304, user_data = 0x7f46568b583e}, {pos = 1453251040, events = 32582, fd = 1451889006, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xf9ee7188862bd800}, {pos = 1453254112, events = 32582, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1579126616, user_data = 0x55d89ffb9af9 }, {pos = -1579126816, events = 21976, fd = 3, user_data = 0x0}, {pos = 32939, events = 0, fd = -328, user_data = 0x0}, {pos = -1579296624, events = 21976, fd = 1452224467, user_data = 0x7ffeb0740328}, {pos = -1610819670, events = 21976, fd = -1598337584, user_data = 0x55d89ffbc267 }, {pos = -1579126816, events = 21976, fd = -1579304624, user_data = 0x55d8a1e06fe0}, {pos = 1451972670, events = 32582, fd = 0, user_data = 0x55d89ffcded1 }, {pos = -1579126816, events = 1, fd = -1610817510, user_data = 0x55d8a1ddb950}, {pos = -2043947008, events = 4193153416, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1451895473, user_data = 0x7f46568a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2043947008, user_data = 0x55d8a1db3080}, {pos = -2043947008, events = 4193153416, fd = 11, user_data = 0xf9ee7188862bd800}, {pos = 0, events = 0, fd = 1451602489, user_data = 0x1}, {pos = -1615247552, events = 21976, fd = 4194304, user_data = 0x55d89ffbc0fb }, {pos = -1579470720, events = 21976, fd = -1579304624, user_data = 0x55d8a1db3080}, {pos = 1, events = 0, fd = 0, user_data = 0x55d89ffcded1 }, {pos = -1579470720, events = 21976, fd = -1610817510, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55d89f9ca14c }, {pos = 0, events = 0, fd = -1617103732, user_data = 0xb}, {pos = -1615226395, events = 21976, fd = -1601939216, user_data = 0x55d8a1ddc308}} [04:58:10.759] nevents = 1 [04:58:10.759] __func__ = "ServerLoop" [04:58:10.759] #24 0x000055d89fb9c1dc in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55d8a1d99cf0) at ../src/backend/postmaster/postmaster.c:1351 [04:58:10.759] opt = [04:58:10.759] status = [04:58:10.759] userDoption = [04:58:10.759] listen_addr_saved = false [04:58:10.759] output_config_variable = [04:58:10.759] __func__ = "PostmasterMain" [04:58:10.759] #25 0x000055d89f9da528 in main (argc=4, argv=0x55d8a1d99cf0) at ../src/backend/main/main.c:197 [04:58:10.759] do_check_root =