[15:42:15.755] src/tools/ci/cores_backtrace.sh linux /tmp/cores [15:42:15.966] dumping /tmp/cores/postgres-6-29711.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:42:16.214] [New LWP 29711] [15:42:16.214] [15:42:16.214] This GDB supports auto-downloading debuginfo from the following URLs: [15:42:16.214] [15:42:16.214] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [15:42:16.214] Debuginfod has been disabled. [15:42:16.214] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [15:42:16.337] [Thread debugging using libthread_db enabled] [15:42:16.337] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [15:42:16.337] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [15:42:16.337] Program terminated with signal SIGABRT, Aborted. [15:42:16.337] #0 0x00007f5a2b4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:17.229] [15:42:17.229] Thread 1 (Thread 0x7f5a2b3d9f00 (LWP 29711)): [15:42:17.229] #0 0x00007f5a2b4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:17.229] No symbol table info available. [15:42:17.229] #1 0x00007f5a2b45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:17.229] No symbol table info available. [15:42:17.229] #2 0x00007f5a2b445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:17.229] No symbol table info available. [15:42:17.229] #3 0x0000557d0524e52f in ExceptionalCondition (conditionName=conditionName@entry=0x557d054bf4c5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x557d054bea30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [15:42:17.229] No locals. [15:42:17.229] #4 0x0000557d04bdc230 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x557d06478250, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [15:42:17.229] estate = 0x557d063be0c0 [15:42:17.229] oldcontext = 0x557d063f3fe0 [15:42:17.229] __func__ = "standard_ExecutorStart" [15:42:17.229] #5 0x0000557d04bdc40c in ExecutorStart (queryDesc=queryDesc@entry=0x557d06478250, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [15:42:17.229] No locals. [15:42:17.229] #6 0x0000557d04b03413 in refresh_matview_datafill (dest=0x557d064752c8, query=, query@entry=0x557d0639a180, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [15:42:17.229] rewritten = [15:42:17.229] plan = 0x557d06477788 [15:42:17.229] queryDesc = 0x557d06478250 [15:42:17.229] copied_query = [15:42:17.229] processed = [15:42:17.229] __func__ = "refresh_matview_datafill" [15:42:17.229] #7 0x0000557d04b0577a in RefreshMatViewByOid (matviewOid=27351, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [15:42:17.229] dest = [15:42:17.229] matviewRel = 0x7f5a1fd9ec28 [15:42:17.229] rule = [15:42:17.229] actions = [15:42:17.229] dataQuery = 0x557d0639a180 [15:42:17.229] tableSpace = [15:42:17.229] relowner = 10 [15:42:17.229] OIDNewHeap = 27379 [15:42:17.229] processed = 0 [15:42:17.229] relpersistence = 112 'p' [15:42:17.229] save_userid = 10 [15:42:17.229] save_sec_context = 0 [15:42:17.229] save_nestlevel = 2 [15:42:17.229] address = {classId = 0, objectId = 0, objectSubId = 0} [15:42:17.229] __func__ = "RefreshMatViewByOid" [15:42:17.229] #8 0x0000557d04b058b9 in ExecRefreshMatView (stmt=0x557d06473340, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [15:42:17.229] matviewOid = [15:42:17.229] lockmode = [15:42:17.229] #9 0x0000557d04abd02d in ExecCreateTableAs (pstate=pstate@entry=0x557d063f40e0, stmt=stmt@entry=0x557d0628a770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffc73ef750) at ../src/backend/commands/createas.c:350 [15:42:17.229] refresh = [15:42:17.229] query = 0x557d0628a930 [15:42:17.229] into = 0x557d0628a4c8 [15:42:17.229] is_matview = true [15:42:17.229] do_refresh = false [15:42:17.229] dest = [15:42:17.229] address = {classId = 1259, objectId = 27351, objectSubId = 0} [15:42:17.229] __func__ = "ExecCreateTableAs" [15:42:17.229] #10 0x0000557d04fc9427 in ProcessUtilitySlow (pstate=pstate@entry=0x557d063f40e0, pstmt=pstmt@entry=0x557d0628a820, queryString=queryString@entry=0x557d06289a30 "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=0x557d0628b258, qc=0x7fffc73ef750) at ../src/backend/tcop/utility.c:1675 [15:42:17.229] _save_exception_stack = 0x7fffc73ef610 [15:42:17.229] _save_context_stack = 0x0 [15:42:17.229] _local_sigjmp_buf = {{__jmpbuf = {0, -2569831683294458720, 93995462600560, 0, 93995462597168, 0, -8551317958344799072, -2569837835442549600}, __mask_was_saved = 0, __saved_mask = {__val = {140025063902144, 14950, 93995442364065, 1, 4294982246, 140025063902144, 93995446166556, 140025249242552, 93995462597168, 93995448475621, 93995458384898, 93995458385024, 140736536179796, 93995448670104, 93995458384913, 93995458385024}}}} [15:42:17.229] _do_rethrow = false [15:42:17.229] parsetree = 0x557d0628a770 [15:42:17.229] isTopLevel = true [15:42:17.229] isCompleteQuery = true [15:42:17.229] needCleanup = false [15:42:17.229] commandCollected = false [15:42:17.229] address = {classId = 21885, objectId = 103327600, objectSubId = 21885} [15:42:17.229] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [15:42:17.229] __func__ = "ProcessUtilitySlow" [15:42:17.229] #11 0x0000557d04fc7a38 in standard_ProcessUtility (pstmt=0x557d0628a820, queryString=0x557d06289a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x557d0628b258, qc=0x7fffc73ef750) at ../src/backend/tcop/utility.c:1067 [15:42:17.229] parsetree = 0x557d0628a770 [15:42:17.229] isTopLevel = true [15:42:17.229] isAtomicContext = false [15:42:17.229] pstate = 0x557d063f40e0 [15:42:17.229] readonly_flags = [15:42:17.229] __func__ = "standard_ProcessUtility" [15:42:17.229] #12 0x0000557d04fc7b93 in ProcessUtility (pstmt=pstmt@entry=0x557d0628a820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x557d0628b258, qc=0x7fffc73ef750) at ../src/backend/tcop/utility.c:523 [15:42:17.229] No locals. [15:42:17.229] #13 0x0000557d04fc33ff in PortalRunUtility (portal=portal@entry=0x557d0630c680, pstmt=pstmt@entry=0x557d0628a820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x557d0628b258, qc=qc@entry=0x7fffc73ef750) at ../src/backend/tcop/pquery.c:1158 [15:42:17.229] No locals. [15:42:17.229] #14 0x0000557d04fc39a4 in PortalRunMulti (portal=portal@entry=0x557d0630c680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x557d0628b258, altdest=altdest@entry=0x557d0628b258, qc=qc@entry=0x7fffc73ef750) at ../src/backend/tcop/pquery.c:1316 [15:42:17.229] pstmt = 0x557d0628a820 [15:42:17.229] stmtlist_item__state = [15:42:17.229] active_snapshot_set = false [15:42:17.229] stmtlist_item = 0x557d0628b220 [15:42:17.229] #15 0x0000557d04fc3f77 in PortalRun (portal=portal@entry=0x557d0630c680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x557d0628b258, altdest=altdest@entry=0x557d0628b258, qc=0x7fffc73ef750) at ../src/backend/tcop/pquery.c:791 [15:42:17.229] _save_exception_stack = 0x7fffc73ef800 [15:42:17.229] _save_context_stack = 0x0 [15:42:17.229] _local_sigjmp_buf = {{__jmpbuf = {0, -2569831682966254432, 93995463132800, 93995462600680, 93995463132800, 93995462600608, -8551317958474822496, -2569837837495268192}, __mask_was_saved = 0, __saved_mask = {__val = {93995445851217, 93995462596912, 112, 4, 93995445855634, 3342792415, 4, 93995462600608, 112, 73, 93995463132800, 93995462600680, 93995462600656, 93995462600608, 93995445942837, 1}}}} [15:42:17.229] _do_rethrow = [15:42:17.229] result = [15:42:17.229] nprocessed = [15:42:17.229] saveTopTransactionResourceOwner = 0x557d062c9838 [15:42:17.229] saveTopTransactionContext = 0x557d0631d660 [15:42:17.229] saveActivePortal = 0x0 [15:42:17.229] saveResourceOwner = 0x557d062c9838 [15:42:17.229] savePortalContext = 0x0 [15:42:17.229] saveMemoryContext = 0x557d0631d660 [15:42:17.229] __func__ = "PortalRun" [15:42:17.229] #16 0x0000557d04fbd613 in exec_simple_query (query_string=query_string@entry=0x557d06289a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [15:42:17.229] cmdtaglen = 24 [15:42:17.229] snapshot_set = [15:42:17.229] per_parsetree_context = 0x0 [15:42:17.229] plantree_list = 0x557d0628b208 [15:42:17.229] parsetree = 0x557d0628a7a0 [15:42:17.229] commandTag = [15:42:17.229] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:42:17.229] querytree_list = [15:42:17.229] portal = 0x557d0630c680 [15:42:17.229] receiver = 0x557d0628b258 [15:42:17.229] format = 0 [15:42:17.229] cmdtagname = [15:42:17.229] parsetree_item__state = [15:42:17.229] dest = DestRemote [15:42:17.229] oldcontext = 0x557d0631d660 [15:42:17.229] parsetree_list = 0x557d0628a7d0 [15:42:17.229] parsetree_item = 0x557d0628a7e8 [15:42:17.229] save_log_statement_stats = false [15:42:17.229] was_logged = true [15:42:17.229] use_implicit_block = false [15:42:17.229] msec_str = "\260\371>\307\377\177\000\000WB'\005}U\000\000\340\367>\307\377\177\000\000G\000\000\000\000\000\000" [15:42:17.229] __func__ = "exec_simple_query" [15:42:17.229] #17 0x0000557d04fc00ec in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [15:42:17.229] query_string = 0x557d06289a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [15:42:17.229] firstchar = [15:42:17.229] input_message = {data = 0x557d06289a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [15:42:17.229] local_sigjmp_buf = {{__jmpbuf = {93995458393464, -2569839931590407008, 4, 140736536181168, 140736536181312, 140736536181316, -8551317958411907936, -2569837856761803616}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93995462327728, 14336, 93995458387552, 93995462854640, 140736536181312, 93995445855182, 0, 9, 2, 93995458393472, 93995462327728, 93995458387552, 140736536181168, 140736536181312, 140736536181316}}}} [15:42:17.229] send_ready_for_query = false [15:42:17.229] idle_in_transaction_timeout_enabled = false [15:42:17.229] idle_session_timeout_enabled = false [15:42:17.229] __func__ = "PostgresMain" [15:42:17.229] #18 0x0000557d04fb620e in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [15:42:17.229] bsdata = [15:42:17.229] #19 0x0000557d04e6ea9f in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffc73ef95c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffc73ef9b0) at ../src/backend/postmaster/launch_backend.c:274 [15:42:17.229] pid = [15:42:17.229] #20 0x0000557d04e7454b in BackendStartup (client_sock=client_sock@entry=0x7fffc73ef9b0) at ../src/backend/postmaster/postmaster.c:3415 [15:42:17.229] bn = 0x557d062bea78 [15:42:17.229] pid = [15:42:17.229] startup_data = {canAcceptConnections = CAC_OK} [15:42:17.229] __func__ = "BackendStartup" [15:42:17.229] #21 0x0000557d04e74aad in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [15:42:17.229] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "B+Z\177\000\000t\372>\307\377\177\000\000\312\000\333,Z\177\000\000>\004\000\000\000\000\000\000\260\227C+Z\177\000\000\240/8,Z\177\000\000x\372>\307\377\177\000\000t\372>\307\377\177\000\000\000\000\000\000\000\000\000\000\020\372>\307\377\177\000\000\312\335\003\004}U\000\000H\307\377\003}U\000\000@\373>\307\377\177\000\0008\373>\307\377\177\000\000\225[\362\001\000\000\000", __ss_align = 140025258038432}, salen = 2}} [15:42:17.229] i = 0 [15:42:17.229] now = [15:42:17.229] last_lockfile_recheck_time = 1726241909 [15:42:17.229] last_touch_time = 1726241909 [15:42:17.229] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f5a2cdda2e0}, {pos = -952173896, events = 0, fd = 0, user_data = 0x7f5a2cdda668}, {pos = 67362250, events = 21885, fd = 752723560, user_data = 0x7f5a2bc3d630}, {pos = 752722656, events = 32602, fd = 2090263927, user_data = 0x7fffc73efbc0}, {pos = 752552520, events = 32602, fd = 15, user_data = 0x7f5a2bc3d630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 752722656, events = 32602, fd = -952173768, user_data = 0x7fffc73efb40}, {pos = 752723560, events = 32602, fd = 0, user_data = 0x557d062b8368}, {pos = 103514696, events = 21885, fd = 103514145, user_data = 0x7f5a00000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f5a2b42e020}, {pos = 741879712, events = 32602, fd = 103514984, user_data = 0x7fffc73eff30}, {pos = 103486152, events = 21885, fd = 103515216, user_data = 0x557d062b8368}, {pos = 752722656, events = 32602, fd = 438, user_data = 0x557d057eadb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x557d06289a48}, {pos = 752578238, events = 32602, fd = 1, user_data = 0x0}, {pos = 725803040, events = 32602, fd = 726609344, user_data = 0x7fffc73effa0}, {pos = -952172672, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 752587194, user_data = 0x0}, {pos = 726330660, events = 32602, fd = 0, user_data = 0x557d05e78f20 }, {pos = 2, events = 0, fd = 7, user_data = 0x557d0624be50}, {pos = 0, events = 0, fd = 725837000, user_data = 0x7f5a2b49c880 }, {pos = 725458360, events = 32602, fd = 8096, user_data = 0x100007f00000002}, {pos = 726363783, events = 32602, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 727653472, events = 32602, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x557d0624be50}, {pos = 726366730, events = 32602, fd = 1663923061, user_data = 0x557d0624be50}, {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 = 0x394d4a6a0a323220}, {pos = 1297567588, events = 10, fd = 0, user_data = 0xffffff0000000000}, {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 = 0xf75ab1826ff39800}, {pos = 727639520, events = 32602, fd = -328, user_data = 0x0}, {pos = 103514376, events = 21885, fd = 1024, user_data = 0x557d062b8108}, {pos = -952172488, events = 32767, fd = 726367903, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 25998, events = 0, fd = -328, user_data = 0x0}, {pos = 103324232, events = 21885, fd = 726609875, user_data = 0x7fffc73f0038}, {pos = 86661573, events = 21885, fd = 99120432, user_data = 0x557d05294482 }, {pos = 103514176, events = 21885, fd = 103323952, user_data = 0x557d062b8040}, {pos = 726357739, events = 32602, fd = 0, user_data = 0x557d052a60ec }, {pos = 103514176, events = 1, fd = 86663733, user_data = 0x557d06289930}, {pos = 1878235136, events = 4149916034, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 726280881, user_data = 0x7f5a2b4a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1878235136, user_data = 0x557d06261060}, {pos = 1878235136, events = 4149916034, fd = 11, user_data = 0xf75ab1826ff39800}, {pos = 0, events = 0, fd = 725987897, user_data = 0x1}, {pos = 82241436, events = 21885, fd = 4194304, user_data = 0x557d05294316 }, {pos = 103157856, events = 21885, fd = 103323952, user_data = 0x557d06261060}, {pos = 1, events = 0, fd = 0, user_data = 0x557d052a60ec }, {pos = 103157856, events = 21885, fd = 86663733, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x557d04ca5875 }, {pos = 0, events = 0, fd = 80391093, user_data = 0xb}, {pos = 82262585, events = 21885, fd = 95527664, user_data = 0x557d0628a2d8}} [15:42:17.230] nevents = 1 [15:42:17.230] __func__ = "ServerLoop" [15:42:17.230] #22 0x0000557d04e76223 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x557d06247cc0) at ../src/backend/postmaster/postmaster.c:1346 [15:42:17.230] opt = [15:42:17.230] status = [15:42:17.230] userDoption = [15:42:17.230] listen_addr_saved = false [15:42:17.230] output_config_variable = [15:42:17.230] __func__ = "PostmasterMain" [15:42:17.230] #23 0x0000557d04cb5c51 in main (argc=4, argv=0x557d06247cc0) at ../src/backend/main/main.c:197 [15:42:17.230] do_check_root = [15:42:17.264] -e [15:42:17.264] [15:42:17.264] [15:42:17.326] dumping /tmp/cores/postgres-6-36177.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:42:17.566] [New LWP 36177] [15:42:17.566] [15:42:17.566] This GDB supports auto-downloading debuginfo from the following URLs: [15:42:17.566] [15:42:17.566] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [15:42:17.566] Debuginfod has been disabled. [15:42:17.566] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [15:42:17.676] [Thread debugging using libthread_db enabled] [15:42:17.676] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [15:42:17.676] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [15:42:17.676] Program terminated with signal SIGABRT, Aborted. [15:42:17.676] #0 0x00007f048a4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:18.567] [15:42:18.567] Thread 1 (Thread 0x7f0488228f00 (LWP 36177)): [15:42:18.567] #0 0x00007f048a4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:18.567] No symbol table info available. [15:42:18.567] #1 0x00007f048a45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:18.567] No symbol table info available. [15:42:18.567] #2 0x00007f048a445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:18.567] No symbol table info available. [15:42:18.567] #3 0x000055ca52b7452f in ExceptionalCondition (conditionName=conditionName@entry=0x55ca52de54c5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55ca52de4a30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [15:42:18.567] No locals. [15:42:18.567] #4 0x000055ca52502230 in standard_ExecutorStart (queryDesc=0x55ca5583fa60, eflags=0) at ../src/backend/executor/execMain.c:191 [15:42:18.567] estate = 0x55ca5580e130 [15:42:18.567] oldcontext = 0x55ca5588ab80 [15:42:18.567] __func__ = "standard_ExecutorStart" [15:42:18.567] #5 0x00007f0487e646f7 in pgss_ExecutorStart (queryDesc=0x55ca5583fa60, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:993 [15:42:18.567] No locals. [15:42:18.567] #6 0x000055ca525023c5 in ExecutorStart (queryDesc=queryDesc@entry=0x55ca5583fa60, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:130 [15:42:18.567] No locals. [15:42:18.567] #7 0x000055ca52429413 in refresh_matview_datafill (dest=0x55ca558b7418, query=, query@entry=0x55ca558974e0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [15:42:18.567] rewritten = [15:42:18.567] plan = 0x55ca5583ef68 [15:42:18.567] queryDesc = 0x55ca5583fa60 [15:42:18.567] copied_query = [15:42:18.567] processed = [15:42:18.567] __func__ = "refresh_matview_datafill" [15:42:18.567] #8 0x000055ca5242b77a in RefreshMatViewByOid (matviewOid=27366, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [15:42:18.567] dest = [15:42:18.567] matviewRel = 0x7f0485ddd0c8 [15:42:18.567] rule = [15:42:18.567] actions = [15:42:18.567] dataQuery = 0x55ca558974e0 [15:42:18.567] tableSpace = [15:42:18.567] relowner = 10 [15:42:18.567] OIDNewHeap = 27373 [15:42:18.567] processed = 0 [15:42:18.567] relpersistence = 112 'p' [15:42:18.567] save_userid = 10 [15:42:18.567] save_sec_context = 0 [15:42:18.567] save_nestlevel = 2 [15:42:18.567] address = {classId = 0, objectId = 0, objectSubId = 0} [15:42:18.567] __func__ = "RefreshMatViewByOid" [15:42:18.567] #9 0x000055ca5242b8b9 in ExecRefreshMatView (stmt=0x55ca55887490, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [15:42:18.567] matviewOid = [15:42:18.567] lockmode = [15:42:18.567] #10 0x000055ca523e302d in ExecCreateTableAs (pstate=pstate@entry=0x55ca5588ac80, stmt=stmt@entry=0x55ca55723790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff08062760) at ../src/backend/commands/createas.c:350 [15:42:18.567] refresh = [15:42:18.567] query = 0x55ca55723950 [15:42:18.567] into = 0x55ca557234e8 [15:42:18.567] is_matview = true [15:42:18.567] do_refresh = false [15:42:18.567] dest = [15:42:18.567] address = {classId = 1259, objectId = 27366, objectSubId = 0} [15:42:18.567] __func__ = "ExecCreateTableAs" [15:42:18.567] #11 0x000055ca528ef427 in ProcessUtilitySlow (pstate=pstate@entry=0x55ca5588ac80, pstmt=pstmt@entry=0x55ca55723840, queryString=queryString@entry=0x55ca55722a50 "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=0x55ca557247e8, qc=0x7fff08062760) at ../src/backend/tcop/utility.c:1675 [15:42:18.567] _save_exception_stack = 0x7fff08062310 [15:42:18.567] _save_context_stack = 0x0 [15:42:18.567] _local_sigjmp_buf = {{__jmpbuf = {0, 3874535814276612782, 94327505303440, 0, 94327505300048, 0, 7039028512232866478, 3874523063451812526}, __mask_was_saved = 0, __saved_mask = {__val = {114, 3, 139657478085728, 1023, 18446744073709551344, 64, 0, 94327506954096, 139657476798986, 1, 94327459771473, 94327507226704, 120, 94327505299792, 94327459771473, 94327505299792}}}} [15:42:18.567] _do_rethrow = false [15:42:18.567] parsetree = 0x55ca55723790 [15:42:18.567] isTopLevel = true [15:42:18.567] isCompleteQuery = true [15:42:18.567] needCleanup = false [15:42:18.567] commandCollected = false [15:42:18.567] address = {classId = 21962, objectId = 1433548688, objectSubId = 21962} [15:42:18.567] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [15:42:18.567] __func__ = "ProcessUtilitySlow" [15:42:18.567] #12 0x000055ca528eda38 in standard_ProcessUtility (pstmt=pstmt@entry=0x55ca55723840, queryString=queryString@entry=0x55ca55722a50 "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=0x55ca557247e8, qc=0x7fff08062760) at ../src/backend/tcop/utility.c:1067 [15:42:18.567] parsetree = 0x55ca55723790 [15:42:18.567] isTopLevel = true [15:42:18.567] isAtomicContext = false [15:42:18.567] pstate = 0x55ca5588ac80 [15:42:18.567] readonly_flags = [15:42:18.567] __func__ = "standard_ProcessUtility" [15:42:18.567] #13 0x00007f0487e67d4a in pgss_ProcessUtility (pstmt=0x55ca55723840, queryString=0x55ca55722a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55ca557247e8, qc=0x7fff08062760) at ../contrib/pg_stat_statements/pg_stat_statements.c:1167 [15:42:18.567] _save_exception_stack = 0x7fff08062620 [15:42:18.567] _save_context_stack = 0x0 [15:42:18.567] _local_sigjmp_buf = {{__jmpbuf = {0, -7038643329843821906, 94327505303616, 94327505307624, 140733328009056, 0, 7039028512664879790, 6942502114825765550}, __mask_was_saved = 0, __saved_mask = {__val = {94327460093360, 140733328008326, 140733328008324, 0, 0, 139637976727552, 206158430232, 140733328008288, 94327460093577, 0, 206158430232, 94327505304416, 140733328008384, 0, 94327454946278, 94327505299792}}}} [15:42:18.567] _do_rethrow = false [15:42:18.567] duration = [15:42:18.567] bufusage = {shared_blks_hit = 94327506265448, shared_blks_read = 867583393792, shared_blks_dirtied = 0, shared_blks_written = 94327506264952, local_blks_hit = 94327506265448, local_blks_read = 94327453285377, local_blks_dirtied = 94327507211176, local_blks_written = 94327453285623, temp_blks_read = 94327506264952, temp_blks_written = 94327506264368, shared_blk_read_time = {ticks = 94327453284732}, shared_blk_write_time = {ticks = 94327460086812}, local_blk_read_time = {ticks = 139657440562616}, local_blk_write_time = {ticks = 94327505300048}, temp_blk_read_time = {ticks = 94327462395877}, temp_blk_write_time = {ticks = 94327472305154}} [15:42:18.567] walusage_start = {wal_records = 8938, wal_fpi = 121, wal_bytes = 1195933} [15:42:18.567] start = [15:42:18.567] rows = [15:42:18.567] bufusage_start = {shared_blks_hit = 33575, shared_blks_read = 3590, shared_blks_dirtied = 1496, shared_blks_written = 970, 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}} [15:42:18.567] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 139657405634240} [15:42:18.567] parsetree = [15:42:18.567] saved_queryId = 6041762721901209185 [15:42:18.567] saved_stmt_location = 0 [15:42:18.567] saved_stmt_len = 69 [15:42:18.567] enabled = true [15:42:18.567] #14 0x000055ca528edade in ProcessUtility (pstmt=pstmt@entry=0x55ca55723840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55ca557247e8, qc=0x7fff08062760) at ../src/backend/tcop/utility.c:519 [15:42:18.567] No locals. [15:42:18.567] #15 0x000055ca528e93ff in PortalRunUtility (portal=portal@entry=0x55ca557a3f90, pstmt=pstmt@entry=0x55ca55723840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55ca557247e8, qc=qc@entry=0x7fff08062760) at ../src/backend/tcop/pquery.c:1158 [15:42:18.567] No locals. [15:42:18.567] #16 0x000055ca528e99a4 in PortalRunMulti (portal=portal@entry=0x55ca557a3f90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55ca557247e8, altdest=altdest@entry=0x55ca557247e8, qc=qc@entry=0x7fff08062760) at ../src/backend/tcop/pquery.c:1316 [15:42:18.567] pstmt = 0x55ca55723840 [15:42:18.567] stmtlist_item__state = [15:42:18.567] active_snapshot_set = false [15:42:18.567] stmtlist_item = 0x55ca557247b0 [15:42:18.567] #17 0x000055ca528e9f77 in PortalRun (portal=portal@entry=0x55ca557a3f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55ca557247e8, altdest=altdest@entry=0x55ca557247e8, qc=0x7fff08062760) at ../src/backend/tcop/pquery.c:791 [15:42:18.567] _save_exception_stack = 0x7fff08062810 [15:42:18.567] _save_context_stack = 0x0 [15:42:18.567] _local_sigjmp_buf = {{__jmpbuf = {0, 3874535814288147118, 94327505829776, 94327505303560, 94327505829776, 94327505303488, 7039028512520176302, 3874523061230273198}, __mask_was_saved = 0, __saved_mask = {__val = {94327459771473, 94327505299792, 112, 4, 94327459775890, 134620911, 4, 94327505303488, 112, 73, 94327505829776, 94327505303560, 94327505303536, 94327505303488, 94327459863093, 1}}}} [15:42:18.567] _do_rethrow = [15:42:18.567] result = [15:42:18.567] nprocessed = [15:42:18.567] saveTopTransactionResourceOwner = 0x55ca55763450 [15:42:18.567] saveTopTransactionContext = 0x55ca557b63c0 [15:42:18.567] saveActivePortal = 0x0 [15:42:18.567] saveResourceOwner = 0x55ca55763450 [15:42:18.567] savePortalContext = 0x0 [15:42:18.567] saveMemoryContext = 0x55ca557b63c0 [15:42:18.567] __func__ = "PortalRun" [15:42:18.567] #18 0x000055ca528e3613 in exec_simple_query (query_string=query_string@entry=0x55ca55722a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [15:42:18.567] cmdtaglen = 24 [15:42:18.567] snapshot_set = [15:42:18.567] per_parsetree_context = 0x0 [15:42:18.567] plantree_list = 0x55ca55724798 [15:42:18.567] parsetree = 0x55ca557237c0 [15:42:18.567] commandTag = [15:42:18.567] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:42:18.567] querytree_list = [15:42:18.567] portal = 0x55ca557a3f90 [15:42:18.567] receiver = 0x55ca557247e8 [15:42:18.567] format = 0 [15:42:18.567] cmdtagname = [15:42:18.567] parsetree_item__state = [15:42:18.567] dest = DestRemote [15:42:18.567] oldcontext = 0x55ca557b63c0 [15:42:18.567] parsetree_list = 0x55ca557237f0 [15:42:18.567] parsetree_item = 0x55ca55723808 [15:42:18.567] save_log_statement_stats = false [15:42:18.567] was_logged = true [15:42:18.567] use_implicit_block = false [15:42:18.567] msec_str = "\300)\006\b\377\177\000\000W\242\271R\312U\000\000\360'\006\b\377\177\000\000G\000\000\000\000\000\000" [15:42:18.567] __func__ = "exec_simple_query" [15:42:18.567] #19 0x000055ca528e60ec in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [15:42:18.567] query_string = 0x55ca55722a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [15:42:18.567] firstchar = [15:42:18.567] input_message = {data = 0x55ca55722a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [15:42:18.567] local_sigjmp_buf = {{__jmpbuf = {94327472313720, 3874522685190734510, 4, 140733328009664, 140733328009808, 140733328009812, 7039028512448873134, 3874523067867759278}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94327505549632, 0, 168, 94327459775992, 0, 10, 2, 94327472313728, 94327505030640, 94327472307808, 140733328009664, 140733328009808, 140733328009812}}}} [15:42:18.567] send_ready_for_query = false [15:42:18.567] idle_in_transaction_timeout_enabled = false [15:42:18.567] idle_session_timeout_enabled = false [15:42:18.567] __func__ = "PostgresMain" [15:42:18.567] #20 0x000055ca528dc20e in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [15:42:18.567] bsdata = [15:42:18.567] #21 0x000055ca52794a9f in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff0806296c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff080629c0) at ../src/backend/postmaster/launch_backend.c:274 [15:42:18.567] pid = [15:42:18.567] #22 0x000055ca5279a54b in BackendStartup (client_sock=client_sock@entry=0x7fff080629c0) at ../src/backend/postmaster/postmaster.c:3415 [15:42:18.567] bn = 0x55ca5574f3d8 [15:42:18.567] pid = [15:42:18.567] startup_data = {canAcceptConnections = CAC_OK} [15:42:18.567] __func__ = "BackendStartup" [15:42:18.567] #23 0x000055ca5279aaad in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [15:42:18.567] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "Nj\004\177\000\000>\004\000\000\000\000\000\000\260\227C\212\004\177\000\000\240/\223\213\004\177\000\000x*\006\b\377\177\000\000t*\006\b\377\177", '\000' , "\312=\226Q\312U\000\000H'\222Q\312U\000\000@+\006\b\377\177\000\0008+\006\b\377\177\000\000\225[\362\001}\347\361\226p\312tU\312U\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [15:42:18.567] i = 0 [15:42:18.567] now = [15:42:18.567] last_lockfile_recheck_time = 1726241942 [15:42:18.567] last_touch_time = 1726241942 [15:42:18.567] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 134622080, user_data = 0x0}, {pos = 15, events = 0, fd = 1368800714, user_data = 0x7f048bca4668}, {pos = -1977592272, events = 32516, fd = -1949678880, user_data = 0x7c96e577}, {pos = 134622144, events = 32767, fd = -1949849016, user_data = 0xf}, {pos = -1977592272, events = 32516, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1949678880, user_data = 0x7fff08062b38}, {pos = 134622016, events = 32767, fd = -1949677976, user_data = 0x0}, {pos = 1433548144, events = 21962, fd = -1974539035, user_data = 0x7fff08063053}, {pos = 1, events = 0, fd = 134622016, user_data = 0xffffffff}, {pos = -1975328736, events = 32516, fd = -1953288288, user_data = 0x55ca5574e308}, {pos = 1433723368, events = 21962, fd = 1433741457, user_data = 0x7f048bc80ebe}, {pos = 1, events = 0, fd = -1949678880, user_data = 0x1b6}, {pos = 1393626544, events = 21962, fd = 0, user_data = 0x1}, {pos = 1433553040, events = 21962, fd = -1949823298, user_data = 0x1}, {pos = 0, events = 0, fd = -1975328736, user_data = 0x7f048a4f2dc0 }, {pos = 16, events = 0, fd = 134623120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f048bc831ba}, {pos = 0, events = 0, fd = -1974801116, user_data = 0x0}, {pos = 1400500000, events = 21962, fd = 2, user_data = 0x7}, {pos = 1433292432, events = 21962, fd = 1952410737, user_data = 0x16a}, {pos = 1393625936, events = 21962, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 1433553040, events = 21962, fd = -1949823298, user_data = 0x1}, {pos = -1974767635, events = 32516, fd = -1975294776, user_data = 0x55ca55757900}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1973478304, events = 32516, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55ca556e4e90}, {pos = -1974765046, events = 32516, fd = 0, user_data = 0x0}, {pos = -65536, events = 4294967295, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f048a2e3540}, {pos = -1976681856, events = 32516, 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 = -1973495328, events = 32516, fd = -1974857362, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x96f1e77d6e347d00}, {pos = -1973492256, events = 32516, fd = -328, user_data = 0x0}, {pos = 1433723048, events = 21962, fd = 1024, user_data = 0x55ca5574e0a8}, {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 = 32521, events = 0, fd = -328, user_data = 0x0}, {pos = 1433553040, events = 21962, fd = -1974521901, user_data = 0x7fff08063048}, {pos = 1388100037, events = 21962, fd = 1400558896, user_data = 0x55ca52bba482 }, {pos = 1433722848, events = 21962, fd = 1433545040, user_data = 0x55ca5574dfe0}, {pos = -1974773698, events = 32516, fd = 0, user_data = 0x55ca52bcc0ec }, {pos = 1433722848, events = 1, fd = 1388102197, user_data = 0x55ca55722950}, {pos = 1848933632, events = 2532435837, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1974850895, user_data = 0x7f048a4a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1848933632, user_data = 0x55ca556fa080}, {pos = 1848933632, events = 2532435837, fd = 11, user_data = 0x96f1e77d6e347d00}, {pos = 0, events = 0, fd = -1975143879, user_data = 0x1}, {pos = 1383679900, events = 21962, fd = 4194304, user_data = 0x55ca52bba316 }, {pos = 1433378944, events = 21962, fd = 1433545040, user_data = 0x55ca556fa080}, {pos = 1, events = 0, fd = 0, user_data = 0x55ca52bcc0ec }, {pos = 1433378944, events = 21962, fd = 1388102197, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55ca525cb875 }, {pos = 0, events = 0, fd = 1381829557, user_data = 0xb}, {pos = 1383701049, events = 21962, fd = 1396966128, user_data = 0x55ca55723308}} [15:42:18.568] nevents = 1 [15:42:18.568] __func__ = "ServerLoop" [15:42:18.568] #24 0x000055ca5279c223 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55ca556e0cf0) at ../src/backend/postmaster/postmaster.c:1346 [15:42:18.568] opt = [15:42:18.568] status = [15:42:18.568] userDoption = [15:42:18.568] listen_addr_saved = false [15:42:18.568] output_config_variable = [15:42:18.568] __func__ = "PostmasterMain" [15:42:18.568] #25 0x000055ca525dbc51 in main (argc=4, argv=0x55ca556e0cf0) at ../src/backend/main/main.c:197 [15:42:18.568] do_check_root = [15:42:18.602] -e [15:42:18.602] [15:42:18.602] [15:42:18.663] dumping /tmp/cores/postgres-6-28965.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [15:42:18.914] [New LWP 28965] [15:42:18.914] [15:42:18.914] This GDB supports auto-downloading debuginfo from the following URLs: [15:42:18.914] [15:42:18.914] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [15:42:18.914] Debuginfod has been disabled. [15:42:18.914] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [15:42:19.018] [Thread debugging using libthread_db enabled] [15:42:19.018] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [15:42:19.018] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [15:42:19.018] Program terminated with signal SIGABRT, Aborted. [15:42:19.018] #0 0x00007f0d3c8a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:19.881] [15:42:19.881] Thread 1 (Thread 0x7f0d3c5dcf00 (LWP 28965)): [15:42:19.881] #0 0x00007f0d3c8a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:19.881] No symbol table info available. [15:42:19.881] #1 0x00007f0d3c85afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:19.881] No symbol table info available. [15:42:19.881] #2 0x00007f0d3c845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [15:42:19.881] No symbol table info available. [15:42:19.881] #3 0x00005566713f852f in ExceptionalCondition (conditionName=conditionName@entry=0x5566716694c5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x556671668a30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [15:42:19.881] No locals. [15:42:19.881] #4 0x0000556670d86230 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x556672d30290, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [15:42:19.881] estate = 0x556672b7cd70 [15:42:19.881] oldcontext = 0x556672cf4000 [15:42:19.881] __func__ = "standard_ExecutorStart" [15:42:19.881] #5 0x0000556670d8640c in ExecutorStart (queryDesc=queryDesc@entry=0x556672d30290, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [15:42:19.881] No locals. [15:42:19.881] #6 0x0000556670cad413 in refresh_matview_datafill (dest=0x556672d2d308, query=, query@entry=0x556672cb0f80, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [15:42:19.881] rewritten = [15:42:19.881] plan = 0x556672d2f7c8 [15:42:19.881] queryDesc = 0x556672d30290 [15:42:19.881] copied_query = [15:42:19.881] processed = [15:42:19.881] __func__ = "refresh_matview_datafill" [15:42:19.881] #7 0x0000556670caf77a in RefreshMatViewByOid (matviewOid=27432, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [15:42:19.881] dest = [15:42:19.881] matviewRel = 0x7f0d30d24fb8 [15:42:19.881] rule = [15:42:19.881] actions = [15:42:19.881] dataQuery = 0x556672cb0f80 [15:42:19.881] tableSpace = [15:42:19.881] relowner = 10 [15:42:19.881] OIDNewHeap = 27439 [15:42:19.881] processed = 0 [15:42:19.881] relpersistence = 112 'p' [15:42:19.881] save_userid = 10 [15:42:19.881] save_sec_context = 0 [15:42:19.881] save_nestlevel = 2 [15:42:19.881] address = {classId = 0, objectId = 0, objectSubId = 0} [15:42:19.881] __func__ = "RefreshMatViewByOid" [15:42:19.881] #8 0x0000556670caf8b9 in ExecRefreshMatView (stmt=0x556672c8bf80, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [15:42:19.881] matviewOid = [15:42:19.881] lockmode = [15:42:19.881] #9 0x0000556670c6702d in ExecCreateTableAs (pstate=pstate@entry=0x556672cf4100, stmt=stmt@entry=0x556672b4a7e0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc70d83150) at ../src/backend/commands/createas.c:350 [15:42:19.881] refresh = [15:42:19.881] query = 0x556672b4a9a0 [15:42:19.881] into = 0x556672b4a538 [15:42:19.881] is_matview = true [15:42:19.881] do_refresh = false [15:42:19.881] dest = [15:42:19.881] address = {classId = 1259, objectId = 27432, objectSubId = 0} [15:42:19.881] __func__ = "ExecCreateTableAs" [15:42:19.881] #10 0x0000556671173427 in ProcessUtilitySlow (pstate=pstate@entry=0x556672cf4100, pstmt=pstmt@entry=0x556672b4a890, queryString=queryString@entry=0x556672b49aa0 "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=0x556672b4b2c8, qc=0x7ffc70d83150) at ../src/backend/tcop/utility.c:1675 [15:42:19.881] _save_exception_stack = 0x7ffc70d83010 [15:42:19.881] _save_context_stack = 0x0 [15:42:19.881] _local_sigjmp_buf = {{__jmpbuf = {0, 2127718380470967800, 93898499467232, 0, 93898499463840, 0, 5238575051412512248, 2127717587407904248}, __mask_was_saved = 0, __saved_mask = {__val = {139694638868032, 10572, 93898471800481, 1, 4294977868, 139694638868032, 93898471790799, 1, 45408318904104, 1, 10572, 139694638868032, 139694638868032, 1, 93898471800828, 93898499675944}}}} [15:42:19.881] _do_rethrow = false [15:42:19.881] parsetree = 0x556672b4a7e0 [15:42:19.881] isTopLevel = true [15:42:19.881] isCompleteQuery = true [15:42:19.881] needCleanup = false [15:42:19.881] commandCollected = false [15:42:19.881] address = {classId = 21862, objectId = 1924442080, objectSubId = 21862} [15:42:19.881] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [15:42:19.881] __func__ = "ProcessUtilitySlow" [15:42:19.881] #11 0x0000556671171a38 in standard_ProcessUtility (pstmt=0x556672b4a890, queryString=0x556672b49aa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x556672b4b2c8, qc=0x7ffc70d83150) at ../src/backend/tcop/utility.c:1067 [15:42:19.881] parsetree = 0x556672b4a7e0 [15:42:19.881] isTopLevel = true [15:42:19.881] isAtomicContext = false [15:42:19.881] pstate = 0x556672cf4100 [15:42:19.881] readonly_flags = [15:42:19.881] __func__ = "standard_ProcessUtility" [15:42:19.881] #12 0x0000556671171b93 in ProcessUtility (pstmt=pstmt@entry=0x556672b4a890, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x556672b4b2c8, qc=0x7ffc70d83150) at ../src/backend/tcop/utility.c:523 [15:42:19.881] No locals. [15:42:19.881] #13 0x000055667116d3ff in PortalRunUtility (portal=portal@entry=0x556672bcc040, pstmt=pstmt@entry=0x556672b4a890, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556672b4b2c8, qc=qc@entry=0x7ffc70d83150) at ../src/backend/tcop/pquery.c:1158 [15:42:19.881] No locals. [15:42:19.881] #14 0x000055667116d9a4 in PortalRunMulti (portal=portal@entry=0x556672bcc040, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556672b4b2c8, altdest=altdest@entry=0x556672b4b2c8, qc=qc@entry=0x7ffc70d83150) at ../src/backend/tcop/pquery.c:1316 [15:42:19.881] pstmt = 0x556672b4a890 [15:42:19.881] stmtlist_item__state = [15:42:19.881] active_snapshot_set = false [15:42:19.881] stmtlist_item = 0x556672b4b290 [15:42:19.881] #15 0x000055667116df77 in PortalRun (portal=portal@entry=0x556672bcc040, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x556672b4b2c8, altdest=altdest@entry=0x556672b4b2c8, qc=0x7ffc70d83150) at ../src/backend/tcop/pquery.c:791 [15:42:19.881] _save_exception_stack = 0x7ffc70d83200 [15:42:19.881] _save_context_stack = 0x0 [15:42:19.881] _local_sigjmp_buf = {{__jmpbuf = {0, 2127718381354917368, 93898499997760, 93898499467352, 93898499997760, 93898499467280, 5238575051274100216, 2127717576714132984}, __mask_was_saved = 0, __saved_mask = {__val = {93898475287633, 93898499463584, 112, 4, 93898475292050, 1893216479, 4, 93898499467280, 112, 73, 93898499997760, 93898499467352, 93898499467328, 93898499467280, 93898475379253, 1}}}} [15:42:19.881] _do_rethrow = [15:42:19.881] result = [15:42:19.881] nprocessed = [15:42:19.881] saveTopTransactionResourceOwner = 0x556672b88cf8 [15:42:19.881] saveTopTransactionContext = 0x556672bddc50 [15:42:19.881] saveActivePortal = 0x0 [15:42:19.881] saveResourceOwner = 0x556672b88cf8 [15:42:19.881] savePortalContext = 0x0 [15:42:19.881] saveMemoryContext = 0x556672bddc50 [15:42:19.881] __func__ = "PortalRun" [15:42:19.881] #16 0x0000556671167613 in exec_simple_query (query_string=query_string@entry=0x556672b49aa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [15:42:19.881] cmdtaglen = 24 [15:42:19.881] snapshot_set = [15:42:19.881] per_parsetree_context = 0x0 [15:42:19.881] plantree_list = 0x556672b4b278 [15:42:19.881] parsetree = 0x556672b4a810 [15:42:19.881] commandTag = [15:42:19.881] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:42:19.881] querytree_list = [15:42:19.881] portal = 0x556672bcc040 [15:42:19.881] receiver = 0x556672b4b2c8 [15:42:19.881] format = 0 [15:42:19.881] cmdtagname = [15:42:19.881] parsetree_item__state = [15:42:19.881] dest = DestRemote [15:42:19.881] oldcontext = 0x556672bddc50 [15:42:19.881] parsetree_list = 0x556672b4a840 [15:42:19.881] parsetree_item = 0x556672b4a858 [15:42:19.881] save_log_statement_stats = false [15:42:19.881] was_logged = false [15:42:19.881] use_implicit_block = false [15:42:19.881] msec_str = "\2603\330p\374\177\000\000W\342AqfU\000\000\3401\330p\374\177\000\000G\000\000\000\000\000\000" [15:42:19.881] __func__ = "exec_simple_query" [15:42:19.881] #17 0x000055667116a0ec in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [15:42:19.881] query_string = 0x556672b49aa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [15:42:19.881] firstchar = [15:42:19.881] input_message = {data = 0x556672b49aa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [15:42:19.881] local_sigjmp_buf = {{__jmpbuf = {93898487829880, 2127719889717861880, 4, 140722201703344, 140722201703488, 140722201703492, 5238575052150709752, 2127717574635855352}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93898499194272, 15616, 93898487823968, 93898499718320, 140722201703488, 93898475291598, 0, 9, 2, 93898487829888, 93898499194272, 93898487823968, 140722201703344, 140722201703488, 140722201703492}}}} [15:42:19.881] send_ready_for_query = false [15:42:19.881] idle_in_transaction_timeout_enabled = false [15:42:19.881] idle_session_timeout_enabled = false [15:42:19.881] __func__ = "PostgresMain" [15:42:19.881] #18 0x000055667116020e in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [15:42:19.881] bsdata = [15:42:19.881] #19 0x0000556671018a9f in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc70d8335c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc70d833b0) at ../src/backend/postmaster/launch_backend.c:274 [15:42:19.881] pid = [15:42:19.881] #20 0x000055667101e54b in BackendStartup (client_sock=client_sock@entry=0x7ffc70d833b0) at ../src/backend/postmaster/postmaster.c:3415 [15:42:19.881] bn = 0x556672b72338 [15:42:19.881] pid = [15:42:19.881] startup_data = {canAcceptConnections = CAC_OK} [15:42:19.881] __func__ = "BackendStartup" [15:42:19.881] #21 0x000055667101eaad in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [15:42:19.881] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\202<\r\177\000\000t4\330p\374\177\000\000\312@\t>\r\177\000\000>\004\000\000\000\000\000\000\260\227\203<\r\177\000\000\240\257\323=\r\177\000\000x4\330p\374\177\000\000t4\330p\374\177\000\000\000\000\000\000\000\000\000\000\0204\330p\374\177\000\000\312}\036pfU\000\000Hg\032pfU\000\000@5\330p\374\177\000\00085\330p\374\177\000\000\225[\362\001\000\000\000", __ss_align = 139694848521376}, salen = 2}} [15:42:19.881] i = 0 [15:42:19.881] now = [15:42:19.881] last_lockfile_recheck_time = 1726241906 [15:42:19.881] last_touch_time = 1726241906 [15:42:19.881] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f0d3e0be2e0}, {pos = 1893217464, events = 0, fd = 0, user_data = 0x7f0d3e0be668}, {pos = 1881046474, events = 21862, fd = 1040967272, user_data = 0x7f0d3dd2b630}, {pos = 1040966368, events = 32525, fd = 2090263927, user_data = 0x7ffc70d835c0}, {pos = 1040796232, events = 32525, fd = 15, user_data = 0x7f0d3dd2b630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1040966368, events = 32525, fd = 1893217592, user_data = 0x7ffc70d83540}, {pos = 1040967272, events = 32525, fd = 0, user_data = 0x556672b76738}, {pos = 1924621848, events = 21862, fd = 1924630577, user_data = 0x7f0d00000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f0d3c82e020}, {pos = 1037283232, events = 32525, fd = 1924622136, user_data = 0x7ffc70d83930}, {pos = 1924622504, events = 21862, fd = 1924592288, user_data = 0x556672b76738}, {pos = 1040966368, events = 32525, fd = 438, user_data = 0x556671994db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x556672b49b60}, {pos = 1040821950, events = 32525, fd = 1, user_data = 0x0}, {pos = 1015210016, events = 32525, fd = 1016016320, user_data = 0x7ffc70d839a0}, {pos = 1893218688, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1040830906, user_data = 0x0}, {pos = 1015737636, events = 32525, fd = 0, user_data = 0x556672022f20 }, {pos = 2, events = 0, fd = 7, user_data = 0x556672b0be40}, {pos = 0, events = 0, fd = 1015243976, user_data = 0x7f0d3c89c880 }, {pos = 1012780472, events = 32525, fd = 8096, user_data = 0x100007f00000002}, {pos = 1015771117, events = 32525, fd = 2, user_data = 0x556672b75400}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 1017060448, events = 32525, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x556672b0be40}, {pos = 1015773706, events = 32525, fd = 1549556828, user_data = 0x556672b0be40}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294901760, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x6953346f2d737365}, {pos = 168442196, events = 824188960, fd = 822763892, user_data = 0x30340a3630393134}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, 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 = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xd11e931f048f1300}, {pos = 1017046496, events = 32525, fd = -328, user_data = 0x0}, {pos = 1924621528, events = 21862, fd = 1024, user_data = 0x556672b764d8}, {pos = 1893218872, events = 32764, fd = 1015774879, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 25307, events = 0, fd = -328, user_data = 0x0}, {pos = 1924438880, events = 21862, fd = 1016016851, user_data = 0x7ffc70d83a38}, {pos = 1900345797, events = 21862, fd = 1912804656, user_data = 0x55667143e482 }, {pos = 1924621328, events = 21862, fd = 1924438432, user_data = 0x556672b76410}, {pos = 1015765054, events = 32525, fd = 0, user_data = 0x5566714500ec }, {pos = 1924621328, events = 1, fd = 1900347957, user_data = 0x556672b499a0}, {pos = 76485376, events = 3508441887, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1015687857, user_data = 0x7f0d3c8a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 76485376, user_data = 0x556672b210d0}, {pos = 76485376, events = 3508441887, fd = 11, user_data = 0xd11e931f048f1300}, {pos = 0, events = 0, fd = 1015394873, user_data = 0x1}, {pos = 1895925660, events = 21862, fd = 4194304, user_data = 0x55667143e316 }, {pos = 1924272336, events = 21862, fd = 1924438432, user_data = 0x556672b210d0}, {pos = 1, events = 0, fd = 0, user_data = 0x5566714500ec }, {pos = 1924272336, events = 21862, fd = 1900347957, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x556670e4f875 }, {pos = 0, events = 0, fd = 1894075317, user_data = 0xb}, {pos = 1895946809, events = 21862, fd = 1909211888, user_data = 0x556672b4a378}} [15:42:19.882] nevents = 1 [15:42:19.882] __func__ = "ServerLoop" [15:42:19.882] #22 0x0000556671020223 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x556672b07d00) at ../src/backend/postmaster/postmaster.c:1346 [15:42:19.882] opt = [15:42:19.882] status = [15:42:19.882] userDoption = [15:42:19.882] listen_addr_saved = false [15:42:19.882] output_config_variable = [15:42:19.882] __func__ = "PostmasterMain" [15:42:19.882] #23 0x0000556670e5fc51 in main (argc=8, argv=0x556672b07d00) at ../src/backend/main/main.c:197 [15:42:19.882] do_check_root =