[07:41:41.572] src/tools/ci/cores_backtrace.sh linux /tmp/cores [07:41:41.789] dumping /tmp/cores/postgres-6-29243.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:41:42.060] [New LWP 29243] [07:41:42.060] [07:41:42.060] This GDB supports auto-downloading debuginfo from the following URLs: [07:41:42.060] [07:41:42.060] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:41:42.060] Debuginfod has been disabled. [07:41:42.060] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:41:42.198] [Thread debugging using libthread_db enabled] [07:41:42.198] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:41:42.198] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [07:41:42.198] Program terminated with signal SIGABRT, Aborted. [07:41:42.198] #0 0x00007fb367aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:43.135] [07:41:43.135] Thread 1 (Thread 0x7fb368235f00 (LWP 29243)): [07:41:43.135] #0 0x00007fb367aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:43.135] No symbol table info available. [07:41:43.135] #1 0x00007fb367a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:43.135] No symbol table info available. [07:41:43.135] #2 0x00007fb367a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:43.135] No symbol table info available. [07:41:43.135] #3 0x0000562ec71a14e3 in ExceptionalCondition (conditionName=conditionName@entry=0x562ec7413dad "queryDesc->sourceText != NULL", fileName=fileName@entry=0x562ec7413290 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [07:41:43.135] No locals. [07:41:43.135] #4 0x0000562ec6b2c7c7 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x562ec90727c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [07:41:43.135] estate = 0x562ec8ed3d80 [07:41:43.135] oldcontext = 0x562ec8fe3580 [07:41:43.135] __func__ = "standard_ExecutorStart" [07:41:43.135] #5 0x0000562ec6b2c9a3 in ExecutorStart (queryDesc=queryDesc@entry=0x562ec90727c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [07:41:43.135] No locals. [07:41:43.135] #6 0x0000562ec6a528f8 in refresh_matview_datafill (dest=0x562ec906f728, query=, query@entry=0x562ec904abf0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [07:41:43.135] rewritten = [07:41:43.135] plan = 0x562ec9071be8 [07:41:43.135] queryDesc = 0x562ec90727c0 [07:41:43.135] copied_query = [07:41:43.135] processed = [07:41:43.135] __func__ = "refresh_matview_datafill" [07:41:43.135] #7 0x0000562ec6a54c5f in RefreshMatViewByOid (matviewOid=27455, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [07:41:43.135] dest = [07:41:43.135] matviewRel = 0x7fb35c0c6b88 [07:41:43.135] rule = [07:41:43.135] actions = [07:41:43.135] dataQuery = 0x562ec904abf0 [07:41:43.135] tableSpace = [07:41:43.135] relowner = 10 [07:41:43.135] OIDNewHeap = 27462 [07:41:43.135] processed = 0 [07:41:43.135] relpersistence = 112 'p' [07:41:43.135] save_userid = 10 [07:41:43.135] save_sec_context = 0 [07:41:43.135] save_nestlevel = 2 [07:41:43.135] address = {classId = 0, objectId = 0, objectSubId = 0} [07:41:43.135] __func__ = "RefreshMatViewByOid" [07:41:43.135] #8 0x0000562ec6a54d9e in ExecRefreshMatView (stmt=0x562ec8ff8720, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [07:41:43.135] matviewOid = [07:41:43.135] lockmode = [07:41:43.135] #9 0x0000562ec6a0b719 in ExecCreateTableAs (pstate=pstate@entry=0x562ec8fe3680, stmt=stmt@entry=0x562ec8ea17f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc6684a6e0) at ../src/backend/commands/createas.c:350 [07:41:43.135] refresh = [07:41:43.135] query = 0x562ec8ea19b0 [07:41:43.135] into = 0x562ec8ea1548 [07:41:43.135] is_matview = true [07:41:43.135] do_refresh = false [07:41:43.135] dest = [07:41:43.135] address = {classId = 1259, objectId = 27455, objectSubId = 0} [07:41:43.135] __func__ = "ExecCreateTableAs" [07:41:43.135] #10 0x0000562ec6f1b7c2 in ProcessUtilitySlow (pstate=pstate@entry=0x562ec8fe3680, pstmt=pstmt@entry=0x562ec8ea18a0, queryString=queryString@entry=0x562ec8ea0ab0 "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=0x562ec8ea22d8, qc=0x7ffc6684a6e0) at ../src/backend/tcop/utility.c:1675 [07:41:43.135] _save_exception_stack = 0x7ffc6684a5a0 [07:41:43.135] _save_context_stack = 0x0 [07:41:43.135] _local_sigjmp_buf = {{__jmpbuf = {0, 827422293282041231, 94758939269104, 0, 94758939265712, 0, 6403772239899045263, 827400119720390031}, __mask_was_saved = 0, __saved_mask = {__val = {4294976681, 140408328588672, 94758905629565, 1, 40311639066424, 1, 9385, 140408328588672, 140408328588672, 1, 94758905639594, 94758939477816, 10630746926333063168, 140408328588672, 140408328588672, 9385}}}} [07:41:43.135] _do_rethrow = false [07:41:43.135] parsetree = 0x562ec8ea17f0 [07:41:43.135] isTopLevel = true [07:41:43.135] isCompleteQuery = true [07:41:43.135] needCleanup = false [07:41:43.135] commandCollected = false [07:41:43.135] address = {classId = 22062, objectId = 3370784752, objectSubId = 22062} [07:41:43.135] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [07:41:43.135] __func__ = "ProcessUtilitySlow" [07:41:43.135] #11 0x0000562ec6f19dd3 in standard_ProcessUtility (pstmt=0x562ec8ea18a0, queryString=0x562ec8ea0ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x562ec8ea22d8, qc=0x7ffc6684a6e0) at ../src/backend/tcop/utility.c:1067 [07:41:43.135] parsetree = 0x562ec8ea17f0 [07:41:43.135] isTopLevel = true [07:41:43.135] isAtomicContext = false [07:41:43.135] pstate = 0x562ec8fe3680 [07:41:43.135] readonly_flags = [07:41:43.135] __func__ = "standard_ProcessUtility" [07:41:43.135] #12 0x0000562ec6f19f2e in ProcessUtility (pstmt=pstmt@entry=0x562ec8ea18a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x562ec8ea22d8, qc=0x7ffc6684a6e0) at ../src/backend/tcop/utility.c:523 [07:41:43.135] No locals. [07:41:43.135] #13 0x0000562ec6f1579a in PortalRunUtility (portal=portal@entry=0x562ec8f23050, pstmt=pstmt@entry=0x562ec8ea18a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562ec8ea22d8, qc=qc@entry=0x7ffc6684a6e0) at ../src/backend/tcop/pquery.c:1158 [07:41:43.135] No locals. [07:41:43.135] #14 0x0000562ec6f15d3f in PortalRunMulti (portal=portal@entry=0x562ec8f23050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562ec8ea22d8, altdest=altdest@entry=0x562ec8ea22d8, qc=qc@entry=0x7ffc6684a6e0) at ../src/backend/tcop/pquery.c:1316 [07:41:43.135] pstmt = 0x562ec8ea18a0 [07:41:43.135] stmtlist_item__state = [07:41:43.135] active_snapshot_set = false [07:41:43.135] stmtlist_item = 0x562ec8ea22a0 [07:41:43.135] #15 0x0000562ec6f16312 in PortalRun (portal=portal@entry=0x562ec8f23050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x562ec8ea22d8, altdest=altdest@entry=0x562ec8ea22d8, qc=0x7ffc6684a6e0) at ../src/backend/tcop/pquery.c:791 [07:41:43.135] _save_exception_stack = 0x7ffc6684a790 [07:41:43.135] _save_context_stack = 0x0 [07:41:43.135] _local_sigjmp_buf = {{__jmpbuf = {0, 827422294562352527, 94758939799632, 94758939269224, 94758939799632, 94758939269152, 6403772239760633231, 827400126104513935}, __mask_was_saved = 0, __saved_mask = {__val = {94758909133963, 94758939265456, 112, 4, 94758909138380, 1719969391, 4, 94758939269152, 112, 73, 94758939799632, 94758939269224, 94758939269200, 94758939269152, 94758909225583, 1}}}} [07:41:43.135] _do_rethrow = [07:41:43.135] result = [07:41:43.135] nprocessed = [07:41:43.135] saveTopTransactionResourceOwner = 0x562ec8edfd08 [07:41:43.135] saveTopTransactionContext = 0x562ec8f34c60 [07:41:43.135] saveActivePortal = 0x0 [07:41:43.135] saveResourceOwner = 0x562ec8edfd08 [07:41:43.135] savePortalContext = 0x0 [07:41:43.135] saveMemoryContext = 0x562ec8f34c60 [07:41:43.135] __func__ = "PortalRun" [07:41:43.135] #16 0x0000562ec6f0f6fe in exec_simple_query (query_string=query_string@entry=0x562ec8ea0ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [07:41:43.135] cmdtaglen = 24 [07:41:43.135] snapshot_set = [07:41:43.135] per_parsetree_context = 0x0 [07:41:43.135] plantree_list = 0x562ec8ea2288 [07:41:43.135] parsetree = 0x562ec8ea1820 [07:41:43.135] commandTag = [07:41:43.135] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:41:43.135] querytree_list = [07:41:43.135] portal = 0x562ec8f23050 [07:41:43.135] receiver = 0x562ec8ea22d8 [07:41:43.135] format = 0 [07:41:43.135] cmdtagname = [07:41:43.135] parsetree_item__state = [07:41:43.135] dest = DestRemote [07:41:43.135] oldcontext = 0x562ec8f34c60 [07:41:43.135] parsetree_list = 0x562ec8ea1850 [07:41:43.135] parsetree_item = 0x562ec8ea1868 [07:41:43.135] save_log_statement_stats = false [07:41:43.135] was_logged = false [07:41:43.135] use_implicit_block = false [07:41:43.135] msec_str = "@\251\204f\374\177\000\000\221r\034\307.V\000\000p\247\204f\374\177\000\000G\000\000\000\000\000\000" [07:41:43.135] __func__ = "exec_simple_query" [07:41:43.135] #17 0x0000562ec6f12482 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [07:41:43.135] query_string = 0x562ec8ea0ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [07:41:43.135] firstchar = [07:41:43.135] input_message = {data = 0x562ec8ea0ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [07:41:43.135] local_sigjmp_buf = {{__jmpbuf = {94758921700952, 827402673963707791, 4, 140722028456256, 140722028456400, 140722028456404, 6403772239697718671, 827400122551283087}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94758938996176, 15616, 94758921695040, 94758939520192, 140722028456400, 94758909137928, 0, 9, 2, 94758921700960, 94758938996176, 94758921695040, 140722028456256, 140722028456400, 140722028456404}}}} [07:41:43.135] send_ready_for_query = false [07:41:43.135] idle_in_transaction_timeout_enabled = false [07:41:43.135] idle_session_timeout_enabled = false [07:41:43.135] __func__ = "PostgresMain" [07:41:43.135] #18 0x0000562ec6f082f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:41:43.135] bsdata = [07:41:43.135] #19 0x0000562ec6dbfc98 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc6684a8ec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc6684a940) at ../src/backend/postmaster/launch_backend.c:274 [07:41:43.135] pid = [07:41:43.135] #20 0x0000562ec6dc574c in BackendStartup (client_sock=client_sock@entry=0x7ffc6684a940) at ../src/backend/postmaster/postmaster.c:3420 [07:41:43.135] bn = 0x562ec8ec9348 [07:41:43.135] pid = [07:41:43.135] startup_data = {canAcceptConnections = CAC_OK} [07:41:43.135] __func__ = "BackendStartup" [07:41:43.135] #21 0x0000562ec6dc5cae in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [07:41:43.135] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "Di\263\177\000\000>\004\000\000\000\000\000\000\260\227\243g\263\177\000\000\240\277\373h\263\177\000\000\370\251\204f\374\177\000\000\364\251\204f\374\177", '\000' , "Vo\370\305.V\000\000\200W\364\305.V\000\000\300\252\204f\374\177\000\000\270\252\204f\374\177\000\000\225[\362\001}\301\245\b\240\264\362h\263\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [07:41:43.135] i = 0 [07:41:43.135] now = [07:41:43.135] last_lockfile_recheck_time = 1727422664 [07:41:43.135] last_touch_time = 1727422664 [07:41:43.135] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 1719970560, user_data = 0x0}, {pos = 15, events = 0, fd = -973574314, user_data = 0x7fb36946d668}, {pos = 1760736816, events = 32691, fd = 1766249184, user_data = 0x7c96e577}, {pos = 1719970624, events = 32764, fd = 1766079048, user_data = 0xf}, {pos = 1760736816, events = 32691, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1766249184, user_data = 0x7ffc6684aab8}, {pos = 1719970496, events = 32764, fd = 1766250088, user_data = 0x0}, {pos = -924178256, events = 22062, fd = 1739517157, user_data = 0x7ffc6684afd3}, {pos = 1, events = 0, fd = 1719970496, user_data = 0xffffffff}, {pos = 1738727456, events = 32691, fd = 1761329056, user_data = 0x562ec8ecd748}, {pos = -924002776, events = 22062, fd = -923994047, user_data = 0x7fb369449ebe}, {pos = 1, events = 0, fd = 1766249184, user_data = 0x1b6}, {pos = -948699728, events = 22062, fd = 0, user_data = 0x1}, {pos = -924185744, events = 22062, fd = 1766104766, user_data = 0x1}, {pos = 0, events = 0, fd = 1738727456, user_data = 0x7fb367af2dc0 }, {pos = 16, events = 0, fd = 1719971600, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fb36944c1ba}, {pos = 0, events = 0, fd = 1739255076, user_data = 0x0}, {pos = -941813792, events = 22062, fd = 2, user_data = 0x7}, {pos = -924438928, events = 22062, fd = 1952410737, user_data = 0x169}, {pos = -948700344, events = 22062, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -924185744, events = 22062, fd = 1766104766, user_data = 0x1}, {pos = 1739288557, events = 32691, fd = 1738761416, user_data = 0x562ec8ecc410}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1740577888, events = 32691, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x562ec8e62e70}, {pos = 1739291146, events = 32691, 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 = 812475760, fd = 168456822, user_data = 0x34373237310a6174}, {pos = 909521458, events = 808716852, 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 = 1740560864, events = 32691, fd = 1739198830, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x8a5c17d19835500}, {pos = 1740563936, events = 32691, fd = -328, user_data = 0x0}, {pos = -924003096, events = 22062, fd = 1024, user_data = 0x562ec8ecd4e8}, {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 = 25252, events = 0, fd = -328, user_data = 0x0}, {pos = -924185744, events = 22062, fd = 1739534291, user_data = 0x7ffc6684afc8}, {pos = -954234369, events = 22062, fd = -941750768, user_data = 0x562ec71e74bc }, {pos = -924003296, events = 22062, fd = -924186192, user_data = 0x562ec8ecd420}, {pos = 1739282494, events = 32691, fd = 0, user_data = 0x562ec71f9126 }, {pos = -924003296, events = 1, fd = -954232209, user_data = 0x562ec8ea09b0}, {pos = 428037376, events = 145080701, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1739205297, user_data = 0x7fb367aa14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 428037376, user_data = 0x562ec8e780e0}, {pos = 428037376, events = 145080701, fd = 11, user_data = 0x8a5c17d19835500}, {pos = 0, events = 0, fd = 1738912313, user_data = 0x1}, {pos = -958662251, events = 22062, fd = 4194304, user_data = 0x562ec71e7350 }, {pos = -924352288, events = 22062, fd = -924186192, user_data = 0x562ec8e780e0}, {pos = 1, events = 0, fd = 0, user_data = 0x562ec71f9126 }, {pos = -924352288, events = 22062, fd = -954232209, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x562ec6bf614c }, {pos = 0, events = 0, fd = -960514932, user_data = 0xb}, {pos = -958641094, events = 22062, fd = -945352400, user_data = 0x562ec8ea1388}} [07:41:43.135] nevents = 1 [07:41:43.135] __func__ = "ServerLoop" [07:41:43.135] #22 0x0000562ec6dc7431 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x562ec8e5ed30) at ../src/backend/postmaster/postmaster.c:1351 [07:41:43.135] opt = [07:41:43.135] status = [07:41:43.135] userDoption = [07:41:43.135] listen_addr_saved = false [07:41:43.135] output_config_variable = [07:41:43.135] __func__ = "PostmasterMain" [07:41:43.135] #23 0x0000562ec6c06528 in main (argc=8, argv=0x562ec8e5ed30) at ../src/backend/main/main.c:197 [07:41:43.135] do_check_root = [07:41:43.170] -e [07:41:43.170] [07:41:43.170] [07:41:43.239] dumping /tmp/cores/postgres-6-29617.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:41:43.508] [New LWP 29617] [07:41:43.508] [07:41:43.508] This GDB supports auto-downloading debuginfo from the following URLs: [07:41:43.508] [07:41:43.508] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:41:43.508] Debuginfod has been disabled. [07:41:43.508] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:41:43.620] [Thread debugging using libthread_db enabled] [07:41:43.620] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:41:43.620] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [07:41:43.620] Program terminated with signal SIGABRT, Aborted. [07:41:43.620] #0 0x00007fa34cca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:44.529] [07:41:44.529] Thread 1 (Thread 0x7fa34ac1bf00 (LWP 29617)): [07:41:44.529] #0 0x00007fa34cca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:44.529] No symbol table info available. [07:41:44.529] #1 0x00007fa34cc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:44.529] No symbol table info available. [07:41:44.529] #2 0x00007fa34cc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:44.529] No symbol table info available. [07:41:44.529] #3 0x000055a3075064e3 in ExceptionalCondition (conditionName=conditionName@entry=0x55a307778dad "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55a307778290 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [07:41:44.529] No locals. [07:41:44.529] #4 0x000055a306e917c7 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55a309cabd90, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [07:41:44.529] estate = 0x55a309cf6440 [07:41:44.529] oldcontext = 0x55a309cd7510 [07:41:44.529] __func__ = "standard_ExecutorStart" [07:41:44.529] #5 0x000055a306e919a3 in ExecutorStart (queryDesc=queryDesc@entry=0x55a309cabd90, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [07:41:44.529] No locals. [07:41:44.529] #6 0x000055a306db78f8 in refresh_matview_datafill (dest=0x55a309d46be8, query=, query@entry=0x55a309d14840, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [07:41:44.529] rewritten = [07:41:44.529] plan = 0x55a309cab2c8 [07:41:44.529] queryDesc = 0x55a309cabd90 [07:41:44.529] copied_query = [07:41:44.529] processed = [07:41:44.529] __func__ = "refresh_matview_datafill" [07:41:44.529] #7 0x000055a306db9c5f in RefreshMatViewByOid (matviewOid=27448, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [07:41:44.529] dest = [07:41:44.529] matviewRel = 0x7fa341549000 [07:41:44.529] rule = [07:41:44.529] actions = [07:41:44.529] dataQuery = 0x55a309d14840 [07:41:44.529] tableSpace = [07:41:44.529] relowner = 10 [07:41:44.529] OIDNewHeap = 27462 [07:41:44.529] processed = 0 [07:41:44.529] relpersistence = 112 'p' [07:41:44.529] save_userid = 10 [07:41:44.529] save_sec_context = 0 [07:41:44.529] save_nestlevel = 2 [07:41:44.529] address = {classId = 0, objectId = 0, objectSubId = 0} [07:41:44.529] __func__ = "RefreshMatViewByOid" [07:41:44.529] #8 0x000055a306db9d9e in ExecRefreshMatView (stmt=0x55a309cface0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [07:41:44.529] matviewOid = [07:41:44.529] lockmode = [07:41:44.529] #9 0x000055a306d70719 in ExecCreateTableAs (pstate=pstate@entry=0x55a309cd7610, stmt=stmt@entry=0x55a309b6b770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc96de62f0) at ../src/backend/commands/createas.c:350 [07:41:44.529] refresh = [07:41:44.529] query = 0x55a309b6b930 [07:41:44.529] into = 0x55a309b6b4c8 [07:41:44.529] is_matview = true [07:41:44.529] do_refresh = false [07:41:44.529] dest = [07:41:44.529] address = {classId = 1259, objectId = 27448, objectSubId = 0} [07:41:44.529] __func__ = "ExecCreateTableAs" [07:41:44.529] #10 0x000055a3072807c2 in ProcessUtilitySlow (pstate=pstate@entry=0x55a309cd7610, pstmt=pstmt@entry=0x55a309b6b820, queryString=queryString@entry=0x55a309b6aa30 "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=0x55a309b6c258, qc=0x7ffc96de62f0) at ../src/backend/tcop/utility.c:1675 [07:41:44.529] _save_exception_stack = 0x7ffc96de61b0 [07:41:44.529] _save_context_stack = 0x0 [07:41:44.529] _local_sigjmp_buf = {{__jmpbuf = {0, 7968546245516180069, 94158730999664, 0, 94158730996272, 0, 4191382608858561125, 7968534281613982309}, __mask_was_saved = 0, __saved_mask = {__val = {4294982636, 140339157724480, 94158687509373, 1, 65884962490952, 1, 94158691329110, 140339310607800, 94158730996272, 94158693642213, 94158703572194, 94158703572320, 140722839642100, 94158693836856, 94158703572209, 94158703572320}}}} [07:41:44.529] _do_rethrow = false [07:41:44.529] parsetree = 0x55a309b6b770 [07:41:44.529] isTopLevel = true [07:41:44.529] isCompleteQuery = true [07:41:44.529] needCleanup = false [07:41:44.529] commandCollected = false [07:41:44.529] address = {classId = 21923, objectId = 162969456, objectSubId = 21923} [07:41:44.529] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [07:41:44.529] __func__ = "ProcessUtilitySlow" [07:41:44.529] #11 0x000055a30727edd3 in standard_ProcessUtility (pstmt=0x55a309b6b820, queryString=0x55a309b6aa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55a309b6c258, qc=0x7ffc96de62f0) at ../src/backend/tcop/utility.c:1067 [07:41:44.529] parsetree = 0x55a309b6b770 [07:41:44.529] isTopLevel = true [07:41:44.529] isAtomicContext = false [07:41:44.529] pstate = 0x55a309cd7610 [07:41:44.529] readonly_flags = [07:41:44.529] __func__ = "standard_ProcessUtility" [07:41:44.529] #12 0x000055a30727ef2e in ProcessUtility (pstmt=pstmt@entry=0x55a309b6b820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55a309b6c258, qc=0x7ffc96de62f0) at ../src/backend/tcop/utility.c:523 [07:41:44.529] No locals. [07:41:44.529] #13 0x000055a30727a79a in PortalRunUtility (portal=portal@entry=0x55a309bed680, pstmt=pstmt@entry=0x55a309b6b820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55a309b6c258, qc=qc@entry=0x7ffc96de62f0) at ../src/backend/tcop/pquery.c:1158 [07:41:44.529] No locals. [07:41:44.529] #14 0x000055a30727ad3f in PortalRunMulti (portal=portal@entry=0x55a309bed680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55a309b6c258, altdest=altdest@entry=0x55a309b6c258, qc=qc@entry=0x7ffc96de62f0) at ../src/backend/tcop/pquery.c:1316 [07:41:44.529] pstmt = 0x55a309b6b820 [07:41:44.529] stmtlist_item__state = [07:41:44.529] active_snapshot_set = false [07:41:44.529] stmtlist_item = 0x55a309b6c220 [07:41:44.529] #15 0x000055a30727b312 in PortalRun (portal=portal@entry=0x55a309bed680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55a309b6c258, altdest=altdest@entry=0x55a309b6c258, qc=0x7ffc96de62f0) at ../src/backend/tcop/pquery.c:791 [07:41:44.529] _save_exception_stack = 0x7ffc96de63a0 [07:41:44.529] _save_context_stack = 0x0 [07:41:44.529] _local_sigjmp_buf = {{__jmpbuf = {0, 7968546246798588517, 94158731531904, 94158730999784, 94158731531904, 94158730999712, 4191382610062326373, 7968534279405812325}, __mask_was_saved = 0, __saved_mask = {__val = {94158691013771, 94158730996016, 112, 4, 94158691018188, 2531156607, 4, 94158730999712, 112, 73, 94158731531904, 94158730999784, 94158730999760, 94158730999712, 94158691105391, 1}}}} [07:41:44.529] _do_rethrow = [07:41:44.529] result = [07:41:44.529] nprocessed = [07:41:44.529] saveTopTransactionResourceOwner = 0x55a309baa838 [07:41:44.529] saveTopTransactionContext = 0x55a309bfe660 [07:41:44.529] saveActivePortal = 0x0 [07:41:44.529] saveResourceOwner = 0x55a309baa838 [07:41:44.529] savePortalContext = 0x0 [07:41:44.529] saveMemoryContext = 0x55a309bfe660 [07:41:44.529] __func__ = "PortalRun" [07:41:44.529] #16 0x000055a3072746fe in exec_simple_query (query_string=query_string@entry=0x55a309b6aa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [07:41:44.529] cmdtaglen = 24 [07:41:44.529] snapshot_set = [07:41:44.529] per_parsetree_context = 0x0 [07:41:44.529] plantree_list = 0x55a309b6c208 [07:41:44.529] parsetree = 0x55a309b6b7a0 [07:41:44.529] commandTag = [07:41:44.529] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:41:44.529] querytree_list = [07:41:44.529] portal = 0x55a309bed680 [07:41:44.529] receiver = 0x55a309b6c258 [07:41:44.529] format = 0 [07:41:44.529] cmdtagname = [07:41:44.529] parsetree_item__state = [07:41:44.529] dest = DestRemote [07:41:44.529] oldcontext = 0x55a309bfe660 [07:41:44.529] parsetree_list = 0x55a309b6b7d0 [07:41:44.529] parsetree_item = 0x55a309b6b7e8 [07:41:44.529] save_log_statement_stats = false [07:41:44.529] was_logged = true [07:41:44.529] use_implicit_block = false [07:41:44.529] msec_str = "Peޖ\374\177\000\000\221\302R\a\243U\000\000\200cޖ\374\177\000\000G\000\000\000\000\000\000" [07:41:44.529] __func__ = "exec_simple_query" [07:41:44.529] #17 0x000055a307277482 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [07:41:44.529] query_string = 0x55a309b6aa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [07:41:44.529] firstchar = [07:41:44.529] input_message = {data = 0x55a309b6aa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [07:41:44.529] local_sigjmp_buf = {{__jmpbuf = {94158703580760, 7968545400288426597, 4, 140722839643472, 140722839643616, 140722839643620, 4191382609999411813, 7968534278270859877}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94158730726832, 14336, 94158703574848, 94158731253744, 140722839643616, 94158691017736, 0, 9, 2, 94158703580768, 94158730726832, 94158703574848, 140722839643472, 140722839643616, 140722839643620}}}} [07:41:44.529] send_ready_for_query = false [07:41:44.529] idle_in_transaction_timeout_enabled = false [07:41:44.529] idle_session_timeout_enabled = false [07:41:44.529] __func__ = "PostgresMain" [07:41:44.529] #18 0x000055a30726d2f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:41:44.529] bsdata = [07:41:44.529] #19 0x000055a307124c98 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc96de64fc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc96de6550) at ../src/backend/postmaster/launch_backend.c:274 [07:41:44.529] pid = [07:41:44.529] #20 0x000055a30712a74c in BackendStartup (client_sock=client_sock@entry=0x7ffc96de6550) at ../src/backend/postmaster/postmaster.c:3420 [07:41:44.529] bn = 0x55a309b9fb18 [07:41:44.529] pid = [07:41:44.529] startup_data = {canAcceptConnections = CAC_OK} [07:41:44.529] __func__ = "BackendStartup" [07:41:44.529] #21 0x000055a30712acae in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [07:41:44.529] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\303L\243\177\000\000\240_\023N\243\177\000\000\370eޖ\374\177\000\000\364eޖ\374\177", '\000' , "V\277.\006\243U\000\000\200\247*\006\243U\000\000\300fޖ\374\177\000\000\270fޖ\374\177\000\000\225[\362\001\000\000\000\000\240\244\302J\243\177\000\000+", '\000' , "\243U\000\000k\276.\006\243U\000", __ss_align = 140339370288744}, salen = 2}} [07:41:44.529] i = 0 [07:41:44.529] now = [07:41:44.529] last_lockfile_recheck_time = 1727422667 [07:41:44.529] last_touch_time = 1727422667 [07:41:44.529] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55a3062ebf56}, {pos = 1313891944, events = 32675, fd = 1254270512, user_data = 0x7fa34e5062e0}, {pos = 2090263927, events = 0, fd = -1763809472, user_data = 0x7fa34e4dca48}, {pos = 15, events = 0, fd = 1254270512, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fa34e5062e0}, {pos = -1763809608, events = 32764, fd = -1763809600, user_data = 0x7fa34e506668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 162973680, events = 21923, fd = 1, user_data = 0x7ffc96de6be3}, {pos = -1, events = 0, fd = 1287839776, user_data = 0x7fa34e135fa0}, {pos = 163156840, events = 21923, fd = 163156552, user_data = 0x55a309b99021}, {pos = 1313746622, events = 32675, fd = 1, user_data = 0x7fa34e5062e0}, {pos = 438, events = 0, fd = 128601520, user_data = 0x0}, {pos = 1, events = 0, fd = 162966088, user_data = 0x7fa34e4e2ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fa34cc2e020}, {pos = 1288646080, events = 32675, fd = 16, user_data = 0x7ffc96de6b20}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1313755578, events = 32675, fd = 0, user_data = 0x7fa34ccaed24 }, {pos = 0, events = 0, fd = 135487456, user_data = 0x2}, {pos = 7, events = 0, fd = 162713168, user_data = 0x55a30720b2f9 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 162966088, user_data = 0x7fa34e4e2ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fa34cc364c8}, {pos = 1288400519, events = 32675, fd = 135542112, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1289690208, events = 32675, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, 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 = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 163129920, user_data = 0x7fa34ccb56eb}, {pos = 1289673184, events = 32675, fd = 1288311150, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x7f86771e37db00}, {pos = 1289676256, events = 32675, fd = -328, user_data = 0x0}, {pos = 163156232, events = 21923, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 163156032, events = 21923, fd = 3, user_data = 0x0}, {pos = 25873, events = 0, fd = -328, user_data = 0x0}, {pos = 162966088, events = 21923, fd = 1288646611, user_data = 0x7ffc96de6bd8}, {pos = 123066879, events = 21923, fd = 135550480, user_data = 0x55a30754c4bc }, {pos = 163156032, events = 21923, fd = 162965808, user_data = 0x55a309b99040}, {pos = 1288394475, events = 32675, fd = 0, user_data = 0x55a30755e126 }, {pos = 163156032, events = 1, fd = 123069039, user_data = 0x55a309b6a930}, {pos = 506977024, events = 8357495, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1288317617, user_data = 0x7fa34cca14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 506977024, user_data = 0x55a309b42060}, {pos = 506977024, events = 8357495, fd = 11, user_data = 0x7f86771e37db00}, {pos = 0, events = 0, fd = 1288024633, user_data = 0x1}, {pos = 118638997, events = 21923, fd = 4194304, user_data = 0x55a30754c350 }, {pos = 162799712, events = 21923, fd = 162965808, user_data = 0x55a309b42060}, {pos = 1, events = 0, fd = 0, user_data = 0x55a30755e126 }, {pos = 162799712, events = 21923, fd = 123069039, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55a306f5b14c }, {pos = 0, events = 0, fd = 116786316, user_data = 0xb}, {pos = 118660154, events = 21923, fd = 131948848, user_data = 0x55a309b6b2d8}} [07:41:44.529] nevents = 1 [07:41:44.529] __func__ = "ServerLoop" [07:41:44.529] #22 0x000055a30712c431 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a309b28cc0) at ../src/backend/postmaster/postmaster.c:1351 [07:41:44.529] opt = [07:41:44.529] status = [07:41:44.529] userDoption = [07:41:44.529] listen_addr_saved = false [07:41:44.529] output_config_variable = [07:41:44.529] __func__ = "PostmasterMain" [07:41:44.529] #23 0x000055a306f6b528 in main (argc=4, argv=0x55a309b28cc0) at ../src/backend/main/main.c:197 [07:41:44.529] do_check_root = [07:41:44.565] -e [07:41:44.565] [07:41:44.565] [07:41:44.631] dumping /tmp/cores/postgres-6-36197.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:41:44.889] [New LWP 36197] [07:41:44.889] [07:41:44.889] This GDB supports auto-downloading debuginfo from the following URLs: [07:41:44.889] [07:41:44.889] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:41:44.889] Debuginfod has been disabled. [07:41:44.889] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:41:45.003] [Thread debugging using libthread_db enabled] [07:41:45.003] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:41:45.003] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [07:41:45.003] Program terminated with signal SIGABRT, Aborted. [07:41:45.003] #0 0x00007fbba94a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:45.943] [07:41:45.943] Thread 1 (Thread 0x7fbba741df00 (LWP 36197)): [07:41:45.943] #0 0x00007fbba94a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:45.943] No symbol table info available. [07:41:45.943] #1 0x00007fbba945afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:45.943] No symbol table info available. [07:41:45.943] #2 0x00007fbba9445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:41:45.943] No symbol table info available. [07:41:45.943] #3 0x00005561237914e3 in ExceptionalCondition (conditionName=conditionName@entry=0x556123a03dad "queryDesc->sourceText != NULL", fileName=fileName@entry=0x556123a03290 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [07:41:45.943] No locals. [07:41:45.943] #4 0x000055612311c7c7 in standard_ExecutorStart (queryDesc=0x556126554b60, eflags=0) at ../src/backend/executor/execMain.c:194 [07:41:45.943] estate = 0x556126587530 [07:41:45.943] oldcontext = 0x55612659b4a0 [07:41:45.943] __func__ = "standard_ExecutorStart" [07:41:45.943] #5 0x00007fbba6b0c6f7 in pgss_ExecutorStart (queryDesc=0x556126554b60, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [07:41:45.943] No locals. [07:41:45.943] #6 0x000055612311c95c in ExecutorStart (queryDesc=queryDesc@entry=0x556126554b60, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [07:41:45.943] No locals. [07:41:45.943] #7 0x00005561230428f8 in refresh_matview_datafill (dest=0x5561265517c8, query=, query@entry=0x556126566c90, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [07:41:45.943] rewritten = [07:41:45.943] plan = 0x556126554098 [07:41:45.943] queryDesc = 0x556126554b60 [07:41:45.943] copied_query = [07:41:45.943] processed = [07:41:45.943] __func__ = "refresh_matview_datafill" [07:41:45.943] #8 0x0000556123044c5f in RefreshMatViewByOid (matviewOid=27345, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [07:41:45.943] dest = [07:41:45.943] matviewRel = 0x7fbba4e71648 [07:41:45.943] rule = [07:41:45.943] actions = [07:41:45.943] dataQuery = 0x556126566c90 [07:41:45.943] tableSpace = [07:41:45.943] relowner = 10 [07:41:45.943] OIDNewHeap = 27353 [07:41:45.943] processed = 0 [07:41:45.943] relpersistence = 112 'p' [07:41:45.943] save_userid = 10 [07:41:45.943] save_sec_context = 0 [07:41:45.943] save_nestlevel = 2 [07:41:45.943] address = {classId = 0, objectId = 0, objectSubId = 0} [07:41:45.943] __func__ = "RefreshMatViewByOid" [07:41:45.943] #9 0x0000556123044d9e in ExecRefreshMatView (stmt=0x5561265d12f0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [07:41:45.943] matviewOid = [07:41:45.943] lockmode = [07:41:45.943] #10 0x0000556122ffb719 in ExecCreateTableAs (pstate=pstate@entry=0x55612659b5a0, stmt=stmt@entry=0x5561263fa790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe7bef2860) at ../src/backend/commands/createas.c:350 [07:41:45.943] refresh = [07:41:45.943] query = 0x5561263fa950 [07:41:45.943] into = 0x5561263fa4e8 [07:41:45.943] is_matview = true [07:41:45.943] do_refresh = false [07:41:45.943] dest = [07:41:45.943] address = {classId = 1259, objectId = 27345, objectSubId = 0} [07:41:45.943] __func__ = "ExecCreateTableAs" [07:41:45.943] #11 0x000055612350b7c2 in ProcessUtilitySlow (pstate=pstate@entry=0x55612659b5a0, pstmt=pstmt@entry=0x5561263fa840, queryString=queryString@entry=0x5561263f9a50 "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=0x5561263fb7e8, qc=0x7ffe7bef2860) at ../src/backend/tcop/utility.c:1675 [07:41:45.943] _save_exception_stack = 0x7ffe7bef2410 [07:41:45.943] _save_context_stack = 0x0 [07:41:45.943] _local_sigjmp_buf = {{__jmpbuf = {0, 4270872574185472666, 93875741894544, 0, 93875741891152, 0, 7961119884992610970, 4270860660223804058}, __mask_was_saved = 0, __saved_mask = {__val = {64, 3, 140443977194592, 1023, 18446744073709551344, 64, 0, 93875742997568, 140443975907850, 1, 93875695600779, 93875743638672, 120, 93875741890896, 93875695600779, 93875741890896}}}} [07:41:45.943] _do_rethrow = false [07:41:45.943] parsetree = 0x5561263fa790 [07:41:45.943] isTopLevel = true [07:41:45.943] isCompleteQuery = true [07:41:45.943] needCleanup = false [07:41:45.943] commandCollected = false [07:41:45.943] address = {classId = 21857, objectId = 641705872, objectSubId = 21857} [07:41:45.943] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [07:41:45.943] __func__ = "ProcessUtilitySlow" [07:41:45.943] #12 0x0000556123509dd3 in standard_ProcessUtility (pstmt=pstmt@entry=0x5561263fa840, queryString=queryString@entry=0x5561263f9a50 "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=0x5561263fb7e8, qc=0x7ffe7bef2860) at ../src/backend/tcop/utility.c:1067 [07:41:45.943] parsetree = 0x5561263fa790 [07:41:45.943] isTopLevel = true [07:41:45.943] isAtomicContext = false [07:41:45.943] pstate = 0x55612659b5a0 [07:41:45.943] readonly_flags = [07:41:45.943] __func__ = "standard_ProcessUtility" [07:41:45.943] #13 0x00007fbba6b0fd4a in pgss_ProcessUtility (pstmt=0x5561263fa840, queryString=0x5561263f9a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5561263fb7e8, qc=0x7ffe7bef2860) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [07:41:45.943] _save_exception_stack = 0x7ffe7bef2720 [07:41:45.943] _save_context_stack = 0x0 [07:41:45.943] _local_sigjmp_buf = {{__jmpbuf = {0, -7960284392502820198, 93875741894720, 93875741898728, 140730977691744, 0, 7961119886968128154, 7993940898601927322}, __mask_was_saved = 0, __saved_mask = {__val = {93875695922666, 140730977691014, 140730977691012, 0, 0, 0, 206158430232, 140730977690976, 93875695922883, 360, 206158430232, 93875741895520, 140730977691072, 0, 93875690765656, 93875741890896}}}} [07:41:45.943] _do_rethrow = false [07:41:45.943] duration = [07:41:45.943] bufusage = {shared_blks_hit = 93875743521128, shared_blks_read = 416611827712, shared_blks_dirtied = 93875743623144, shared_blks_written = 93875689104846, local_blks_hit = 93875743520632, local_blks_read = 93875743520048, local_blks_dirtied = 93875689103955, local_blks_written = 93875688656402, temp_blks_read = 93875743520632, temp_blks_written = 93875688627719, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93875695916118}, local_blk_read_time = {ticks = 140443941723576}, local_blk_write_time = {ticks = 93875741891152}, temp_blk_read_time = {ticks = 93875698229221}, temp_blk_write_time = {ticks = 93875708159202}} [07:41:45.943] walusage_start = {wal_records = 8923, wal_fpi = 117, wal_bytes = 1146779} [07:41:45.943] start = [07:41:45.943] rows = [07:41:45.943] bufusage_start = {shared_blks_hit = 33645, shared_blks_read = 3600, shared_blks_dirtied = 1518, shared_blks_written = 947, 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}} [07:41:45.943] walusage = {wal_records = 0, wal_fpi = 416611827712, wal_bytes = 93875743523064} [07:41:45.943] parsetree = [07:41:45.943] saved_queryId = 6041762721901209185 [07:41:45.943] saved_stmt_location = 0 [07:41:45.943] saved_stmt_len = 69 [07:41:45.943] enabled = true [07:41:45.943] #14 0x0000556123509e79 in ProcessUtility (pstmt=pstmt@entry=0x5561263fa840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5561263fb7e8, qc=0x7ffe7bef2860) at ../src/backend/tcop/utility.c:519 [07:41:45.943] No locals. [07:41:45.943] #15 0x000055612350579a in PortalRunUtility (portal=portal@entry=0x55612647af90, pstmt=pstmt@entry=0x5561263fa840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5561263fb7e8, qc=qc@entry=0x7ffe7bef2860) at ../src/backend/tcop/pquery.c:1158 [07:41:45.943] No locals. [07:41:45.943] #16 0x0000556123505d3f in PortalRunMulti (portal=portal@entry=0x55612647af90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5561263fb7e8, altdest=altdest@entry=0x5561263fb7e8, qc=qc@entry=0x7ffe7bef2860) at ../src/backend/tcop/pquery.c:1316 [07:41:45.943] pstmt = 0x5561263fa840 [07:41:45.943] stmtlist_item__state = [07:41:45.943] active_snapshot_set = false [07:41:45.943] stmtlist_item = 0x5561263fb7b0 [07:41:45.943] #17 0x0000556123506312 in PortalRun (portal=portal@entry=0x55612647af90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5561263fb7e8, altdest=altdest@entry=0x5561263fb7e8, qc=0x7ffe7bef2860) at ../src/backend/tcop/pquery.c:791 [07:41:45.943] _save_exception_stack = 0x7ffe7bef2910 [07:41:45.943] _save_context_stack = 0x0 [07:41:45.943] _local_sigjmp_buf = {{__jmpbuf = {0, 4270872573863559834, 93875742420880, 93875741894664, 93875742420880, 93875741894592, 7961119886827618970, 4270860666724319898}, __mask_was_saved = 0, __saved_mask = {__val = {93875695600779, 93875741890896, 112, 4, 93875695605196, 2079270895, 4, 93875741894592, 112, 73, 93875742420880, 93875741894664, 93875741894640, 93875741894592, 93875695692399, 1}}}} [07:41:45.943] _do_rethrow = [07:41:45.943] result = [07:41:45.943] nprocessed = [07:41:45.943] saveTopTransactionResourceOwner = 0x55612643a468 [07:41:45.943] saveTopTransactionContext = 0x55612648d3c0 [07:41:45.943] saveActivePortal = 0x0 [07:41:45.943] saveResourceOwner = 0x55612643a468 [07:41:45.943] savePortalContext = 0x0 [07:41:45.943] saveMemoryContext = 0x55612648d3c0 [07:41:45.943] __func__ = "PortalRun" [07:41:45.943] #18 0x00005561234ff6fe in exec_simple_query (query_string=query_string@entry=0x5561263f9a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [07:41:45.943] cmdtaglen = 24 [07:41:45.943] snapshot_set = [07:41:45.943] per_parsetree_context = 0x0 [07:41:45.943] plantree_list = 0x5561263fb798 [07:41:45.943] parsetree = 0x5561263fa7c0 [07:41:45.943] commandTag = [07:41:45.943] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:41:45.943] querytree_list = [07:41:45.943] portal = 0x55612647af90 [07:41:45.943] receiver = 0x5561263fb7e8 [07:41:45.943] format = 0 [07:41:45.943] cmdtagname = [07:41:45.943] parsetree_item__state = [07:41:45.943] dest = DestRemote [07:41:45.943] oldcontext = 0x55612648d3c0 [07:41:45.943] parsetree_list = 0x5561263fa7f0 [07:41:45.943] parsetree_item = 0x5561263fa808 [07:41:45.943] save_log_statement_stats = false [07:41:45.943] was_logged = true [07:41:45.943] use_implicit_block = false [07:41:45.943] msec_str = "\300*\357{\376\177\000\000\221r{#aU\000\000\360(\357{\376\177\000\000G\000\000\000\000\000\000" [07:41:45.943] __func__ = "exec_simple_query" [07:41:45.943] #19 0x0000556123502482 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [07:41:45.943] query_string = 0x5561263f9a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [07:41:45.943] firstchar = [07:41:45.943] input_message = {data = 0x5561263f9a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [07:41:45.943] local_sigjmp_buf = {{__jmpbuf = {93875708167768, 4270868196737188506, 4, 140730977692352, 140730977692496, 140730977692500, 7961119886622098074, 4270860662492660378}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 93875742140736, 0, 168, 93875695605298, 0, 10, 2, 93875708167776, 93875741621744, 93875708161856, 140730977692352, 140730977692496, 140730977692500}}}} [07:41:45.943] send_ready_for_query = false [07:41:45.943] idle_in_transaction_timeout_enabled = false [07:41:45.943] idle_session_timeout_enabled = false [07:41:45.943] __func__ = "PostgresMain" [07:41:45.943] #20 0x00005561234f82f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:41:45.943] bsdata = [07:41:45.943] #21 0x00005561233afc98 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe7bef2a6c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe7bef2ac0) at ../src/backend/postmaster/launch_backend.c:274 [07:41:45.943] pid = [07:41:45.943] #22 0x00005561233b574c in BackendStartup (client_sock=client_sock@entry=0x7ffe7bef2ac0) at ../src/backend/postmaster/postmaster.c:3420 [07:41:45.943] bn = 0x5561264266a8 [07:41:45.943] pid = [07:41:45.943] startup_data = {canAcceptConnections = CAC_OK} [07:41:45.943] __func__ = "BackendStartup" [07:41:45.943] #23 0x00005561233b5cae in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [07:41:45.943] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "Ϫ\273\177\000\000>\004\000\000\000\000\000\000\260\227C\251\273\177\000\000\240\217\223\252\273\177\000\000x+\357{\376\177\000\000t+\357{\376\177", '\000' , "VoW\"aU\000\000\200WS\"aU\000\000@,\357{\376\177\000\0008,\357{\376\177\000\000\225[\362\001\3775\225\244p:B&aU\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [07:41:45.943] i = 0 [07:41:45.943] now = [07:41:45.943] last_lockfile_recheck_time = 1727422703 [07:41:45.943] last_touch_time = 1727422703 [07:41:45.943] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 2079272064, user_data = 0x0}, {pos = 15, events = 0, fd = 576155478, user_data = 0x7fbbaad1b668}, {pos = -1440188880, events = 32699, fd = -1429097760, user_data = 0x7c96e577}, {pos = 2079272128, events = 32766, fd = -1429267896, user_data = 0xf}, {pos = -1440188880, events = 32699, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1429097760, user_data = 0x7ffe7bef2c38}, {pos = 2079272000, events = 32766, fd = -1429096856, user_data = 0x0}, {pos = 641705328, events = 21857, fd = -1454445339, user_data = 0x7ffe7bef3153}, {pos = 1, events = 0, fd = 2079272000, user_data = 0xffffffff}, {pos = -1455235040, events = 32699, fd = -1433170016, user_data = 0x556126425308}, {pos = 641880552, events = 21857, fd = 641898641, user_data = 0x7fbbaacf7ebe}, {pos = 1, events = 0, fd = -1429097760, user_data = 0x1b6}, {pos = 601030064, events = 21857, fd = 0, user_data = 0x1}, {pos = 641710224, events = 21857, fd = -1429242178, user_data = 0x1}, {pos = 0, events = 0, fd = -1455235040, user_data = 0x7fbba94f2dc0 }, {pos = 16, events = 0, fd = 2079273104, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fbbaacfa1ba}, {pos = 0, events = 0, fd = -1454707420, user_data = 0x0}, {pos = 607916000, events = 21857, fd = 2, user_data = 0x7}, {pos = 641449616, events = 21857, fd = 1952410737, user_data = 0x169}, {pos = 601029448, events = 21857, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 641710224, events = 21857, fd = -1429242178, user_data = 0x1}, {pos = -1454673939, events = 32699, fd = -1455201080, user_data = 0x55612642e900}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1453384608, events = 32699, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x5561263bbe90}, {pos = -1454671350, events = 32699, 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 = 0x7fbbaa92a540}, {pos = -1433228672, events = 32699, 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 = -1453401632, events = 32699, fd = -1454763666, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0xa49535ffb480ff00}, {pos = -1453398560, events = 32699, fd = -328, user_data = 0x0}, {pos = 641880232, events = 21857, fd = 1024, user_data = 0x5561264250a8}, {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 = 32402, events = 0, fd = -328, user_data = 0x0}, {pos = 641710224, events = 21857, fd = -1454428205, user_data = 0x7ffe7bef3148}, {pos = 595495423, events = 21857, fd = 607979024, user_data = 0x5561237d74bc }, {pos = 641880032, events = 21857, fd = 641702224, user_data = 0x556126424fe0}, {pos = -1454680002, events = 32699, fd = 0, user_data = 0x5561237e9126 }, {pos = 641880032, events = 1, fd = 595497583, user_data = 0x5561263f9950}, {pos = -1266614528, events = 2761242111, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1454757199, user_data = 0x7fbba94a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1266614528, user_data = 0x5561263d1080}, {pos = -1266614528, events = 2761242111, fd = 11, user_data = 0xa49535ffb480ff00}, {pos = 0, events = 0, fd = -1455050183, user_data = 0x1}, {pos = 591067541, events = 21857, fd = 4194304, user_data = 0x5561237d7350 }, {pos = 641536128, events = 21857, fd = 641702224, user_data = 0x5561263d1080}, {pos = 1, events = 0, fd = 0, user_data = 0x5561237e9126 }, {pos = 641536128, events = 21857, fd = 595497583, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5561231e614c }, {pos = 0, events = 0, fd = 589214860, user_data = 0xb}, {pos = 591088698, events = 21857, fd = 604377392, user_data = 0x5561263fa308}} [07:41:45.943] nevents = 1 [07:41:45.943] __func__ = "ServerLoop" [07:41:45.943] #24 0x00005561233b7431 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5561263b7cf0) at ../src/backend/postmaster/postmaster.c:1351 [07:41:45.943] opt = [07:41:45.943] status = [07:41:45.943] userDoption = [07:41:45.943] listen_addr_saved = false [07:41:45.943] output_config_variable = [07:41:45.943] __func__ = "PostmasterMain" [07:41:45.943] #25 0x00005561231f6528 in main (argc=4, argv=0x5561263b7cf0) at ../src/backend/main/main.c:197 [07:41:45.943] do_check_root =