[14:48:37.772] src/tools/ci/cores_backtrace.sh linux /tmp/cores [14:48:37.979] dumping /tmp/cores/postgres-6-29719.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [14:48:38.223] [New LWP 29719] [14:48:38.223] [14:48:38.223] This GDB supports auto-downloading debuginfo from the following URLs: [14:48:38.223] [14:48:38.223] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [14:48:38.223] Debuginfod has been disabled. [14:48:38.223] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [14:48:38.351] [Thread debugging using libthread_db enabled] [14:48:38.351] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [14:48:38.351] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [14:48:38.351] Program terminated with signal SIGABRT, Aborted. [14:48:38.351] #0 0x00007fbb83ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:39.268] [14:48:39.268] Thread 1 (Thread 0x7fbb84633f00 (LWP 29719)): [14:48:39.268] #0 0x00007fbb83ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:39.268] No symbol table info available. [14:48:39.268] #1 0x00007fbb83e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:39.268] No symbol table info available. [14:48:39.268] #2 0x00007fbb83e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:39.268] No symbol table info available. [14:48:39.268] #3 0x000055deb5df77d3 in ExceptionalCondition (conditionName=conditionName@entry=0x55deb606d455 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55deb606c970 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [14:48:39.268] No locals. [14:48:39.268] #4 0x000055deb57714c2 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55deb822b1a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [14:48:39.268] estate = 0x55deb8126310 [14:48:39.268] oldcontext = 0x55deb832ca60 [14:48:39.268] __func__ = "standard_ExecutorStart" [14:48:39.268] #5 0x000055deb577169e in ExecutorStart (queryDesc=queryDesc@entry=0x55deb822b1a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [14:48:39.268] No locals. [14:48:39.268] #6 0x000055deb5695707 in refresh_matview_datafill (dest=0x55deb8231c48, query=, query@entry=0x55deb81f1df0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [14:48:39.268] rewritten = [14:48:39.268] plan = 0x55deb822a768 [14:48:39.268] queryDesc = 0x55deb822b1a0 [14:48:39.268] copied_query = [14:48:39.268] processed = [14:48:39.268] __func__ = "refresh_matview_datafill" [14:48:39.268] #7 0x000055deb5697a6e in RefreshMatViewByOid (matviewOid=28525, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [14:48:39.268] dest = [14:48:39.268] matviewRel = 0x7fbb787c8778 [14:48:39.268] rule = [14:48:39.268] actions = [14:48:39.268] dataQuery = 0x55deb81f1df0 [14:48:39.268] tableSpace = [14:48:39.268] relowner = 10 [14:48:39.268] OIDNewHeap = 28537 [14:48:39.268] processed = 0 [14:48:39.268] relpersistence = 112 'p' [14:48:39.268] save_userid = 10 [14:48:39.268] save_sec_context = 0 [14:48:39.268] save_nestlevel = 2 [14:48:39.268] address = {classId = 0, objectId = 0, objectSubId = 0} [14:48:39.268] __func__ = "RefreshMatViewByOid" [14:48:39.268] #8 0x000055deb5697bad in ExecRefreshMatView (stmt=0x55deb8234da0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [14:48:39.268] matviewOid = [14:48:39.268] lockmode = [14:48:39.268] #9 0x000055deb564d7c7 in ExecCreateTableAs (pstate=pstate@entry=0x55deb832cb60, stmt=stmt@entry=0x55deb80cb770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe2c3042d0) at ../src/backend/commands/createas.c:351 [14:48:39.268] refresh = [14:48:39.268] query = 0x55deb80cb930 [14:48:39.268] into = 0x55deb80cb4c8 [14:48:39.268] jstate = 0x0 [14:48:39.268] is_matview = true [14:48:39.268] do_refresh = false [14:48:39.268] dest = [14:48:39.268] address = {classId = 1259, objectId = 28525, objectSubId = 0} [14:48:39.268] __func__ = "ExecCreateTableAs" [14:48:39.268] #10 0x000055deb5b6d06d in ProcessUtilitySlow (pstate=pstate@entry=0x55deb832cb60, pstmt=pstmt@entry=0x55deb80cb820, queryString=queryString@entry=0x55deb80caa30 "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=0x55deb80cc258, qc=0x7ffe2c3042d0) at ../src/backend/tcop/utility.c:1678 [14:48:39.268] _save_exception_stack = 0x7ffe2c304190 [14:48:39.268] _save_context_stack = 0x0 [14:48:39.268] _local_sigjmp_buf = {{__jmpbuf = {0, 5551667881690666134, 94415058941808, 0, 94415058938416, 0, 1822362454321927318, 5551645255787091094}, __mask_was_saved = 0, __saved_mask = {__val = {140443162262784, 15469, 94415019181045, 1, 4294982765, 140443162262784, 94415023012871, 140443356708280, 94415058938416, 94415025344558, 94415035344098, 94415035344224, 140729639780308, 94415025539801, 94415035344113, 94415035344224}}}} [14:48:39.268] _do_rethrow = false [14:48:39.268] parsetree = 0x55deb80cb770 [14:48:39.268] isTopLevel = true [14:48:39.268] isCompleteQuery = true [14:48:39.268] needCleanup = false [14:48:39.268] commandCollected = false [14:48:39.268] address = {classId = 21982, objectId = 3087841136, objectSubId = 21982} [14:48:39.268] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [14:48:39.268] __func__ = "ProcessUtilitySlow" [14:48:39.268] #11 0x000055deb5b6b67e in standard_ProcessUtility (pstmt=0x55deb80cb820, queryString=0x55deb80caa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55deb80cc258, qc=0x7ffe2c3042d0) at ../src/backend/tcop/utility.c:1070 [14:48:39.268] parsetree = 0x55deb80cb770 [14:48:39.268] isTopLevel = true [14:48:39.268] isAtomicContext = false [14:48:39.268] pstate = 0x55deb832cb60 [14:48:39.268] readonly_flags = [14:48:39.268] __func__ = "standard_ProcessUtility" [14:48:39.268] #12 0x000055deb5b6b7d9 in ProcessUtility (pstmt=pstmt@entry=0x55deb80cb820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55deb80cc258, qc=0x7ffe2c3042d0) at ../src/backend/tcop/utility.c:523 [14:48:39.268] No locals. [14:48:39.268] #13 0x000055deb5b67045 in PortalRunUtility (portal=portal@entry=0x55deb814c7a0, pstmt=pstmt@entry=0x55deb80cb820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55deb80cc258, qc=qc@entry=0x7ffe2c3042d0) at ../src/backend/tcop/pquery.c:1158 [14:48:39.268] No locals. [14:48:39.268] #14 0x000055deb5b675ea in PortalRunMulti (portal=portal@entry=0x55deb814c7a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55deb80cc258, altdest=altdest@entry=0x55deb80cc258, qc=qc@entry=0x7ffe2c3042d0) at ../src/backend/tcop/pquery.c:1315 [14:48:39.268] pstmt = 0x55deb80cb820 [14:48:39.268] stmtlist_item__state = [14:48:39.268] active_snapshot_set = false [14:48:39.268] stmtlist_item = 0x55deb80cc220 [14:48:39.268] #15 0x000055deb5b67bbd in PortalRun (portal=portal@entry=0x55deb814c7a0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55deb80cc258, altdest=altdest@entry=0x55deb80cc258, qc=0x7ffe2c3042d0) at ../src/backend/tcop/pquery.c:791 [14:48:39.268] _save_exception_stack = 0x7ffe2c304380 [14:48:39.268] _save_context_stack = 0x0 [14:48:39.268] _local_sigjmp_buf = {{__jmpbuf = {0, 5551667884053107862, 94415059470240, 94415058941928, 94415059470240, 94415058941856, 1822362456859481238, 5551645262168331414}, __mask_was_saved = 0, __saved_mask = {__val = {94415022696571, 94415058938160, 112, 4, 94415022700988, 741360223, 4, 94415058941856, 112, 73, 94415059470240, 94415058941928, 94415058941904, 94415058941856, 94415022788191, 1}}}} [14:48:39.268] _do_rethrow = [14:48:39.268] result = [14:48:39.268] nprocessed = [14:48:39.268] saveTopTransactionResourceOwner = 0x55deb8109958 [14:48:39.268] saveTopTransactionContext = 0x55deb8160c10 [14:48:39.268] saveActivePortal = 0x0 [14:48:39.268] saveResourceOwner = 0x55deb8109958 [14:48:39.268] savePortalContext = 0x0 [14:48:39.268] saveMemoryContext = 0x55deb8160c10 [14:48:39.268] __func__ = "PortalRun" [14:48:39.268] #16 0x000055deb5b60f9f in exec_simple_query (query_string=query_string@entry=0x55deb80caa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [14:48:39.268] cmdtaglen = 24 [14:48:39.268] snapshot_set = [14:48:39.268] per_parsetree_context = 0x0 [14:48:39.268] plantree_list = 0x55deb80cc208 [14:48:39.268] parsetree = 0x55deb80cb7a0 [14:48:39.268] commandTag = [14:48:39.268] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:48:39.268] querytree_list = [14:48:39.268] portal = 0x55deb814c7a0 [14:48:39.268] receiver = 0x55deb80cc258 [14:48:39.268] format = 0 [14:48:39.268] cmdtagname = [14:48:39.268] parsetree_item__state = [14:48:39.268] dest = DestRemote [14:48:39.268] oldcontext = 0x55deb8160c10 [14:48:39.268] parsetree_list = 0x55deb80cb7d0 [14:48:39.268] parsetree_item = 0x55deb80cb7e8 [14:48:39.268] save_log_statement_stats = false [14:48:39.268] was_logged = true [14:48:39.268] use_implicit_block = false [14:48:39.268] msec_str = "\004\000\000\000\000\000\000\000J\326\341\265\336U\000\000`C0,\376\177\000\000G\000\000\000\000\000\000" [14:48:39.268] __func__ = "exec_simple_query" [14:48:39.268] #17 0x000055deb5b63d23 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [14:48:39.268] query_string = 0x55deb80caa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [14:48:39.268] firstchar = [14:48:39.268] input_message = {data = 0x55deb80caa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [14:48:39.268] local_sigjmp_buf = {{__jmpbuf = {94415035352664, 5551638540697080982, 140729639781596, 4, 2, 140729639781828, 1822362456804955286, 5551645259664200854}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94415058668976, 14336, 94415035346752, 94415059192080, 2, 94415022700536, 0, 9, 2, 94415035352672, 94415058668976, 94415035346752, 4, 2, 140729639781828}}}} [14:48:39.268] send_ready_for_query = false [14:48:39.268] idle_in_transaction_timeout_enabled = false [14:48:39.268] idle_session_timeout_enabled = false [14:48:39.268] __func__ = "PostgresMain" [14:48:39.268] #18 0x000055deb5b59b18 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [14:48:39.268] bsdata = [14:48:39.268] #19 0x000055deb5a0b64c in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffe2c3044dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe2c304530) at ../src/backend/postmaster/launch_backend.c:274 [14:48:39.268] pid = [14:48:39.268] #20 0x000055deb5a10647 in BackendStartup (client_sock=client_sock@entry=0x7ffe2c304530) at ../src/backend/postmaster/postmaster.c:3390 [14:48:39.268] bn = 0x55deb80f22a8 [14:48:39.268] pid = [14:48:39.268] startup_data = {canAcceptConnections = CAC_OK} [14:48:39.268] cac = [14:48:39.268] __func__ = "BackendStartup" [14:48:39.268] #21 0x000055deb5a12520 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [14:48:39.268] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\202S\273\264\336U\000\000x7\267\264\336U\000\000\200F0,\376\177\000\000xF0,\376\177\000\000\225[\362\001\000\000\000\000\240\244c\204\273\177\000\000+", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000hv{\205\273\177\000\0000\246c\204\273\177\000\000\340r{\205\273\177\000\000\316)fR\000\000\000", __ss_align = 741361344}, salen = 2}} [14:48:39.268] i = 0 [14:48:39.268] now = [14:48:39.268] last_lockfile_recheck_time = 1733582670 [14:48:39.268] last_touch_time = 1733582670 [14:48:39.268] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -2073844176, events = 32699, fd = -2055507232, user_data = 0x7c96e577}, {pos = 741361408, events = 32766, fd = -2055677368, user_data = 0xf}, {pos = -2073844176, events = 32699, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -2055507232, user_data = 0x7ffe2c304678}, {pos = 741361280, events = 32766, fd = -2055506328, user_data = 0x0}, {pos = -1207129528, events = 21982, fd = -2081719670, user_data = 0x55deb80caa48}, {pos = 1, events = 21982, fd = 32768, user_data = 0xffffffff}, {pos = -2082283488, events = 32699, fd = -2059735136, user_data = 0x55deb80f6008}, {pos = -1206952216, events = 21982, fd = -1206954831, user_data = 0x7fbb85793ebe}, {pos = 1, events = 0, fd = -2055507232, user_data = 0x1ab}, {pos = -1237725864, events = 21982, fd = 0, user_data = 0xd8}, {pos = -1207129528, events = 21982, fd = -2055651650, user_data = 0x1}, {pos = 0, events = 0, fd = -2082283488, user_data = 0x7fbb83ef2e40 }, {pos = 16, events = 0, fd = 741362416, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fbb857961ba}, {pos = 0, events = 0, fd = -2081755740, user_data = 0x0}, {pos = -1230779872, events = 21982, fd = 2, user_data = 0x0}, {pos = -1207382448, events = 21982, fd = -1246811518, user_data = 0x55deb80fd7b0}, {pos = -1246807529, events = 21982, fd = -1206921205, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -2082249528, user_data = 0x7fbb83e9c880 }, {pos = -2073870920, events = 32699, fd = 741362608, user_data = 0x100007f00000002}, {pos = -2081722617, events = 32699, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -2080433056, 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 = 171520288, events = 1717650228, fd = 1731224687, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 21760, 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 = -1206948016, events = 21982, fd = -2081719670, user_data = 0xa}, {pos = -1243371397, events = 21982, fd = -1206939792, user_data = 0x7fbb83eb58be}, {pos = -2080450080, events = 32699, fd = -2081812114, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x4d1ba4d683814300}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55deb80f5ce0}, {pos = 1, events = 0, fd = -1206952536, user_data = 0x3}, {pos = 0, events = 0, fd = 25823, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1207129528, user_data = 0x7fbb83ef3053 }, {pos = -1206952536, events = 21982, fd = 1024, user_data = 0x7ffe2c304bb8}, {pos = -1243288081, events = 21982, fd = -1230715376, user_data = 0x55deb5e3d8ac }, {pos = -1206952736, events = 21982, fd = -1207129808, user_data = 0x55deb80f5ce0}, {pos = -2081728661, events = 32699, fd = 0, user_data = 0x55deb5e4f516 }, {pos = -1206952736, events = 1, fd = -1243285921, user_data = 0x55deb80ca930}, {pos = -2088680704, events = 1293657302, fd = 0, user_data = 0x7fbb83ea2ab1}, {pos = -2081811216, events = 32699, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1207382448, user_data = 0x4d1ba4d683814300}, {pos = 0, events = 0, fd = -2088680704, user_data = 0xc}, {pos = -2088680704, events = 1293657302, fd = 0, user_data = 0x7fbb83e5b239 }, {pos = 217, events = 0, fd = -1247759543, user_data = 0x400000}, {pos = 0, events = 0, fd = -1207382448, user_data = 0x55deb5e3d740 }, {pos = -1207295904, events = 21982, fd = -1207129808, user_data = 0x55deb80a2060}, {pos = 1, events = 0, fd = 0, user_data = 0x55deb5dfc13d }, {pos = 12, events = 0, fd = -1206957288, user_data = 0x55deb80f4af8}, {pos = -1230778464, events = 21982, fd = 296, user_data = 0x55deb5a0db63 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1247743072, events = 21982, fd = -1234351792, user_data = 0x55deb80cb2d8}} [14:48:39.269] nevents = 1 [14:48:39.269] __func__ = "ServerLoop" [14:48:39.269] #22 0x000055deb5a13db4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55deb8088cc0) at ../src/backend/postmaster/postmaster.c:1374 [14:48:39.269] opt = [14:48:39.269] status = [14:48:39.269] userDoption = [14:48:39.269] listen_addr_saved = false [14:48:39.269] output_config_variable = [14:48:39.269] __func__ = "PostmasterMain" [14:48:39.269] #23 0x000055deb584b82d in main (argc=4, argv=0x55deb8088cc0) at ../src/backend/main/main.c:222 [14:48:39.269] do_check_root = [14:48:39.269] dispatch_option = [14:48:39.304] -e [14:48:39.304] [14:48:39.304] [14:48:39.366] dumping /tmp/cores/postgres-6-29211.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [14:48:39.607] [New LWP 29211] [14:48:39.607] [14:48:39.607] This GDB supports auto-downloading debuginfo from the following URLs: [14:48:39.607] [14:48:39.607] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [14:48:39.607] Debuginfod has been disabled. [14:48:39.607] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [14:48:39.711] [Thread debugging using libthread_db enabled] [14:48:39.711] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [14:48:39.711] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [14:48:39.711] Program terminated with signal SIGABRT, Aborted. [14:48:39.711] #0 0x00007f0e1cca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:40.598] [14:48:40.598] Thread 1 (Thread 0x7f0e1c9daf00 (LWP 29211)): [14:48:40.598] #0 0x00007f0e1cca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:40.598] No symbol table info available. [14:48:40.598] #1 0x00007f0e1cc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:40.598] No symbol table info available. [14:48:40.598] #2 0x00007f0e1cc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:40.598] No symbol table info available. [14:48:40.598] #3 0x0000556bc10707d3 in ExceptionalCondition (conditionName=conditionName@entry=0x556bc12e6455 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x556bc12e5970 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [14:48:40.598] No locals. [14:48:40.598] #4 0x0000556bc09ea4c2 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x556bc397d6f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [14:48:40.598] estate = 0x556bc38d1450 [14:48:40.598] oldcontext = 0x556bc39055a0 [14:48:40.598] __func__ = "standard_ExecutorStart" [14:48:40.598] #5 0x0000556bc09ea69e in ExecutorStart (queryDesc=queryDesc@entry=0x556bc397d6f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [14:48:40.598] No locals. [14:48:40.598] #6 0x0000556bc090e707 in refresh_matview_datafill (dest=0x556bc398dba8, query=, query@entry=0x556bc38d9720, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [14:48:40.598] rewritten = [14:48:40.598] plan = 0x556bc397ccb8 [14:48:40.598] queryDesc = 0x556bc397d6f0 [14:48:40.598] copied_query = [14:48:40.598] processed = [14:48:40.598] __func__ = "refresh_matview_datafill" [14:48:40.598] #7 0x0000556bc0910a6e in RefreshMatViewByOid (matviewOid=28537, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [14:48:40.598] dest = [14:48:40.598] matviewRel = 0x7f0e111827f8 [14:48:40.598] rule = [14:48:40.598] actions = [14:48:40.598] dataQuery = 0x556bc38d9720 [14:48:40.598] tableSpace = [14:48:40.598] relowner = 10 [14:48:40.598] OIDNewHeap = 28544 [14:48:40.598] processed = 0 [14:48:40.598] relpersistence = 112 'p' [14:48:40.598] save_userid = 10 [14:48:40.598] save_sec_context = 0 [14:48:40.598] save_nestlevel = 2 [14:48:40.598] address = {classId = 0, objectId = 0, objectSubId = 0} [14:48:40.598] __func__ = "RefreshMatViewByOid" [14:48:40.598] #8 0x0000556bc0910bad in ExecRefreshMatView (stmt=0x556bc38c22f0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [14:48:40.598] matviewOid = [14:48:40.598] lockmode = [14:48:40.598] #9 0x0000556bc08c67c7 in ExecCreateTableAs (pstate=pstate@entry=0x556bc39056a0, stmt=stmt@entry=0x556bc37ab7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffeaa078410) at ../src/backend/commands/createas.c:351 [14:48:40.598] refresh = [14:48:40.598] query = 0x556bc37ab9b0 [14:48:40.598] into = 0x556bc37ab548 [14:48:40.598] jstate = 0x0 [14:48:40.598] is_matview = true [14:48:40.598] do_refresh = false [14:48:40.598] dest = [14:48:40.598] address = {classId = 1259, objectId = 28537, objectSubId = 0} [14:48:40.598] __func__ = "ExecCreateTableAs" [14:48:40.598] #10 0x0000556bc0de606d in ProcessUtilitySlow (pstate=pstate@entry=0x556bc39056a0, pstmt=pstmt@entry=0x556bc37ab8a0, queryString=queryString@entry=0x556bc37aaab0 "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=0x556bc37ac2d8, qc=0x7ffeaa078410) at ../src/backend/tcop/utility.c:1678 [14:48:40.598] _save_exception_stack = 0x7ffeaa0782d0 [14:48:40.598] _save_context_stack = 0x0 [14:48:40.598] _local_sigjmp_buf = {{__jmpbuf = {0, -8706293900895785628, 93921329461232, 0, 93921329457840, 0, -3312444629999882908, -8706301839608976028}, __mask_was_saved = 0, __saved_mask = {__val = {139698401161664, 11004, 93921285084149, 1, 4294978300, 139698401161664, 93921285074467, 1, 47265100930568, 1, 11004, 139698401161664, 139698401161664, 1, 93921285084496, 93921330667016}}}} [14:48:40.598] _do_rethrow = false [14:48:40.598] parsetree = 0x556bc37ab7f0 [14:48:40.598] isTopLevel = true [14:48:40.598] isCompleteQuery = true [14:48:40.598] needCleanup = false [14:48:40.598] commandCollected = false [14:48:40.598] address = {classId = 21867, objectId = 3279599600, objectSubId = 21867} [14:48:40.598] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [14:48:40.598] __func__ = "ProcessUtilitySlow" [14:48:40.598] #11 0x0000556bc0de467e in standard_ProcessUtility (pstmt=0x556bc37ab8a0, queryString=0x556bc37aaab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x556bc37ac2d8, qc=0x7ffeaa078410) at ../src/backend/tcop/utility.c:1070 [14:48:40.598] parsetree = 0x556bc37ab7f0 [14:48:40.598] isTopLevel = true [14:48:40.598] isAtomicContext = false [14:48:40.598] pstate = 0x556bc39056a0 [14:48:40.598] readonly_flags = [14:48:40.598] __func__ = "standard_ProcessUtility" [14:48:40.598] #12 0x0000556bc0de47d9 in ProcessUtility (pstmt=pstmt@entry=0x556bc37ab8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x556bc37ac2d8, qc=0x7ffeaa078410) at ../src/backend/tcop/utility.c:523 [14:48:40.598] No locals. [14:48:40.598] #13 0x0000556bc0de0045 in PortalRunUtility (portal=portal@entry=0x556bc382f0c0, pstmt=pstmt@entry=0x556bc37ab8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556bc37ac2d8, qc=qc@entry=0x7ffeaa078410) at ../src/backend/tcop/pquery.c:1158 [14:48:40.598] No locals. [14:48:40.598] #14 0x0000556bc0de05ea in PortalRunMulti (portal=portal@entry=0x556bc382f0c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556bc37ac2d8, altdest=altdest@entry=0x556bc37ac2d8, qc=qc@entry=0x7ffeaa078410) at ../src/backend/tcop/pquery.c:1315 [14:48:40.598] pstmt = 0x556bc37ab8a0 [14:48:40.598] stmtlist_item__state = [14:48:40.598] active_snapshot_set = false [14:48:40.598] stmtlist_item = 0x556bc37ac2a0 [14:48:40.598] #15 0x0000556bc0de0bbd in PortalRun (portal=portal@entry=0x556bc382f0c0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x556bc37ac2d8, altdest=altdest@entry=0x556bc37ac2d8, qc=0x7ffeaa078410) at ../src/backend/tcop/pquery.c:791 [14:48:40.598] _save_exception_stack = 0x7ffeaa0784c0 [14:48:40.598] _save_context_stack = 0x0 [14:48:40.598] _local_sigjmp_buf = {{__jmpbuf = {0, -8706293898562704028, 93921330000064, 93921329461352, 93921330000064, 93921329461280, -3312444627705598620, -8706301841829466780}, __mask_was_saved = 0, __saved_mask = {__val = {93921288599675, 93921329457584, 112, 4, 93921288604092, 2852619167, 4, 93921329461280, 112, 73, 93921330000064, 93921329461352, 93921329461328, 93921329461280, 93921288691295, 1}}}} [14:48:40.598] _do_rethrow = [14:48:40.598] result = [14:48:40.598] nprocessed = [14:48:40.598] saveTopTransactionResourceOwner = 0x556bc37ebd78 [14:48:40.598] saveTopTransactionContext = 0x556bc38414f0 [14:48:40.598] saveActivePortal = 0x0 [14:48:40.598] saveResourceOwner = 0x556bc37ebd78 [14:48:40.598] savePortalContext = 0x0 [14:48:40.598] saveMemoryContext = 0x556bc38414f0 [14:48:40.598] __func__ = "PortalRun" [14:48:40.598] #16 0x0000556bc0dd9f9f in exec_simple_query (query_string=query_string@entry=0x556bc37aaab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [14:48:40.598] cmdtaglen = 24 [14:48:40.598] snapshot_set = [14:48:40.598] per_parsetree_context = 0x0 [14:48:40.598] plantree_list = 0x556bc37ac288 [14:48:40.598] parsetree = 0x556bc37ab820 [14:48:40.598] commandTag = [14:48:40.598] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:48:40.598] querytree_list = [14:48:40.598] portal = 0x556bc382f0c0 [14:48:40.598] receiver = 0x556bc37ac2d8 [14:48:40.598] format = 0 [14:48:40.598] cmdtagname = [14:48:40.598] parsetree_item__state = [14:48:40.598] dest = DestRemote [14:48:40.598] oldcontext = 0x556bc38414f0 [14:48:40.598] parsetree_list = 0x556bc37ab850 [14:48:40.598] parsetree_item = 0x556bc37ab868 [14:48:40.598] save_log_statement_stats = false [14:48:40.598] was_logged = false [14:48:40.598] use_implicit_block = false [14:48:40.598] msec_str = "\004\000\000\000\000\000\000\000Jf\t\301kU\000\000\240\204\a\252\376\177\000\000G\000\000\000\000\000\000" [14:48:40.598] __func__ = "exec_simple_query" [14:48:40.598] #17 0x0000556bc0ddcd23 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [14:48:40.598] query_string = 0x556bc37aaab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [14:48:40.598] firstchar = [14:48:40.598] input_message = {data = 0x556bc37aaab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [14:48:40.598] local_sigjmp_buf = {{__jmpbuf = {93921301255768, -8706299485619950236, 140731751040540, 4, 15, 140731751040772, -3312444627516854940, -8706301826876641948}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93921329188304, 15616, 93921301249856, 93921329720624, 15, 93921288603640, 0, 9, 2, 93921301255776, 93921329188304, 93921301249856, 4, 15, 140731751040772}}}} [14:48:40.598] send_ready_for_query = false [14:48:40.598] idle_in_transaction_timeout_enabled = false [14:48:40.598] idle_session_timeout_enabled = false [14:48:40.598] __func__ = "PostgresMain" [14:48:40.598] #18 0x0000556bc0dd2b18 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [14:48:40.598] bsdata = [14:48:40.598] #19 0x0000556bc0c8464c in postmaster_child_launch (child_type=B_BACKEND, child_slot=15, startup_data=startup_data@entry=0x7ffeaa07861c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffeaa078670) at ../src/backend/postmaster/launch_backend.c:274 [14:48:40.598] pid = [14:48:40.598] #20 0x0000556bc0c89647 in BackendStartup (client_sock=client_sock@entry=0x7ffeaa078670) at ../src/backend/postmaster/postmaster.c:3390 [14:48:40.598] bn = 0x556bc37d32c8 [14:48:40.598] pid = [14:48:40.598] startup_data = {canAcceptConnections = CAC_OK} [14:48:40.598] cac = [14:48:40.598] __func__ = "BackendStartup" [14:48:40.598] #21 0x0000556bc0c8b520 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [14:48:40.598] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\202\343\342\277kU\000\000x\307\336\277kU\000\000\300\207\a\252\376\177\000\000\270\207\a\252\376\177\000\000\225[\362\001\000\000\000\000\240\204\250\035\016\177\000\000+", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000h\306K\036\016\177\000\0000\206\250\035\016\177\000\000\340\302K\036\016\177\000\000\316)fR\000\000\000", __ss_align = 2852620288}, salen = 2}} [14:48:40.598] i = 0 [14:48:40.598] now = [14:48:40.598] last_lockfile_recheck_time = 1733582668 [14:48:40.598] last_touch_time = 1733582668 [14:48:40.598] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 497583664, events = 32526, fd = 508281568, user_data = 0x7c96e577}, {pos = -1442346944, events = 32766, fd = 508111432, user_data = 0xf}, {pos = 497583664, events = 32526, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 508281568, user_data = 0x7ffeaa0787b8}, {pos = -1442347072, events = 32766, fd = 508282472, user_data = 0x0}, {pos = -1015370896, events = 21867, fd = 483097226, user_data = 0x556bc37aab70}, {pos = 1, events = 21867, fd = 32768, user_data = 0xffffffff}, {pos = 482533408, events = 32526, fd = 504598432, user_data = 0x556bc37d6158}, {pos = -1015193544, events = 21867, fd = -1015184351, user_data = 0x7f0e1e498ebe}, {pos = 1, events = 0, fd = 508281568, user_data = 0x1ab}, {pos = -1050583720, events = 21867, fd = 0, user_data = 0xec}, {pos = -1015370896, events = 21867, fd = 508137150, user_data = 0x1}, {pos = 0, events = 0, fd = 482533408, user_data = 0x7f0e1ccf2e40 }, {pos = 16, events = 0, fd = -1442345936, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f0e1e49b1ba}, {pos = 0, events = 0, fd = 483061156, user_data = 0x0}, {pos = -1043637728, events = 21867, fd = 2, user_data = 0x0}, {pos = -1015624080, events = 21867, fd = -1059669374, user_data = 0x556bc37ddc80}, {pos = -1059665385, events = 21867, fd = -1015161637, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 482567368, user_data = 0x7f0e1cc9c880 }, {pos = 480095672, events = 32526, fd = -1442345744, user_data = 0x100007f00000002}, {pos = 483094279, events = 32526, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 484383840, events = 32526, 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 = 1346524227, fd = 168447814, user_data = 0x35333337310a6174}, {pos = 909521464, events = 808716856, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, 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 = -1015190496, events = 21867, fd = 483097226, user_data = 0xa}, {pos = -1056229253, events = 21867, fd = -1015178160, user_data = 0x7f0e1ccb576b}, {pos = 484366816, events = 32526, fd = 483004782, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xa8296ef8dace3000}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x556bc37d5e30}, {pos = 1, events = 0, fd = -1015193864, user_data = 0x3}, {pos = 0, events = 0, fd = 25333, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1015370896, user_data = 0x7f0e1ccf3053 }, {pos = -1015193864, events = 21867, fd = 1024, user_data = 0x7ffeaa078cf8}, {pos = -1056145937, events = 21867, fd = -1043573232, user_data = 0x556bc10b68ac }, {pos = -1015194064, events = 21867, fd = -1015371344, user_data = 0x556bc37d5e30}, {pos = 483088235, events = 32526, fd = 0, user_data = 0x556bc10c8516 }, {pos = -1015194064, events = 1, fd = -1056143777, user_data = 0x556bc37aa9b0}, {pos = -624021504, events = 2821287672, fd = 0, user_data = 0x7f0e1cca2ab1}, {pos = 483005680, events = 32526, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1015624080, user_data = 0xa8296ef8dace3000}, {pos = 0, events = 0, fd = -624021504, user_data = 0xc}, {pos = -624021504, events = 2821287672, fd = 0, user_data = 0x7f0e1cc5b239 }, {pos = 237, events = 0, fd = -1060617399, user_data = 0x400000}, {pos = 0, events = 0, fd = -1015624080, user_data = 0x556bc10b6740 }, {pos = -1015537440, events = 21867, fd = -1015371344, user_data = 0x556bc37820e0}, {pos = 1, events = 0, fd = 0, user_data = 0x556bc107513d }, {pos = 12, events = 0, fd = -1015194488, user_data = 0x556bc37d5c68}, {pos = -1043636320, events = 21867, fd = 296, user_data = 0x556bc0c86b63 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1060600928, events = 21867, fd = -1047209648, user_data = 0x556bc37ab388}} [14:48:40.598] nevents = 1 [14:48:40.598] __func__ = "ServerLoop" [14:48:40.598] #22 0x0000556bc0c8cdb4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x556bc3768d30) at ../src/backend/postmaster/postmaster.c:1374 [14:48:40.598] opt = [14:48:40.598] status = [14:48:40.598] userDoption = [14:48:40.598] listen_addr_saved = false [14:48:40.598] output_config_variable = [14:48:40.598] __func__ = "PostmasterMain" [14:48:40.598] #23 0x0000556bc0ac482d in main (argc=8, argv=0x556bc3768d30) at ../src/backend/main/main.c:222 [14:48:40.598] do_check_root = [14:48:40.598] dispatch_option = [14:48:40.634] -e [14:48:40.634] [14:48:40.634] [14:48:40.696] dumping /tmp/cores/postgres-6-36258.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [14:48:40.940] [New LWP 36258] [14:48:40.940] [14:48:40.940] This GDB supports auto-downloading debuginfo from the following URLs: [14:48:40.940] [14:48:40.940] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [14:48:40.940] Debuginfod has been disabled. [14:48:40.940] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [14:48:41.043] [Thread debugging using libthread_db enabled] [14:48:41.043] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [14:48:41.043] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [14:48:41.043] Program terminated with signal SIGABRT, Aborted. [14:48:41.043] #0 0x00007f87788a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:41.945] [14:48:41.945] Thread 1 (Thread 0x7f8779035f00 (LWP 36258)): [14:48:41.945] #0 0x00007f87788a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:41.945] No symbol table info available. [14:48:41.945] #1 0x00007f877885afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:41.945] No symbol table info available. [14:48:41.945] #2 0x00007f8778845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [14:48:41.945] No symbol table info available. [14:48:41.945] #3 0x000055de64b377d3 in ExceptionalCondition (conditionName=conditionName@entry=0x55de64dad455 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55de64dac970 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [14:48:41.945] No locals. [14:48:41.945] #4 0x000055de644b14c2 in standard_ExecutorStart (queryDesc=0x55de669e4040, eflags=0) at ../src/backend/executor/execMain.c:195 [14:48:41.945] estate = 0x55de668cae30 [14:48:41.945] oldcontext = 0x55de669082f0 [14:48:41.945] __func__ = "standard_ExecutorStart" [14:48:41.945] #5 0x00007f877644a6f7 in pgss_ExecutorStart (queryDesc=0x55de669e4040, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [14:48:41.945] No locals. [14:48:41.945] #6 0x000055de644b1657 in ExecutorStart (queryDesc=queryDesc@entry=0x55de669e4040, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [14:48:41.945] No locals. [14:48:41.945] #7 0x000055de643d5707 in refresh_matview_datafill (dest=0x55de669216f8, query=, query@entry=0x55de668e54f0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [14:48:41.945] rewritten = [14:48:41.945] plan = 0x55de669e3608 [14:48:41.945] queryDesc = 0x55de669e4040 [14:48:41.945] copied_query = [14:48:41.945] processed = [14:48:41.945] __func__ = "refresh_matview_datafill" [14:48:41.945] #8 0x000055de643d7a6e in RefreshMatViewByOid (matviewOid=28344, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [14:48:41.945] dest = [14:48:41.945] matviewRel = 0x7f87742a07f8 [14:48:41.945] rule = [14:48:41.945] actions = [14:48:41.945] dataQuery = 0x55de668e54f0 [14:48:41.945] tableSpace = [14:48:41.945] relowner = 10 [14:48:41.945] OIDNewHeap = 28355 [14:48:41.945] processed = 0 [14:48:41.945] relpersistence = 112 'p' [14:48:41.945] save_userid = 10 [14:48:41.945] save_sec_context = 0 [14:48:41.945] save_nestlevel = 2 [14:48:41.945] address = {classId = 0, objectId = 0, objectSubId = 0} [14:48:41.945] __func__ = "RefreshMatViewByOid" [14:48:41.945] #9 0x000055de643d7bad in ExecRefreshMatView (stmt=0x55de669220d0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [14:48:41.945] matviewOid = [14:48:41.945] lockmode = [14:48:41.945] #10 0x000055de6438d7c7 in ExecCreateTableAs (pstate=pstate@entry=0x55de669083f0, stmt=stmt@entry=0x55de667ce790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe40e213c0) at ../src/backend/commands/createas.c:351 [14:48:41.945] refresh = [14:48:41.945] query = 0x55de667ce950 [14:48:41.945] into = 0x55de667ce4e8 [14:48:41.945] jstate = 0x0 [14:48:41.945] is_matview = true [14:48:41.945] do_refresh = false [14:48:41.945] dest = [14:48:41.945] address = {classId = 1259, objectId = 28344, objectSubId = 0} [14:48:41.945] __func__ = "ExecCreateTableAs" [14:48:41.945] #11 0x000055de648ad06d in ProcessUtilitySlow (pstate=pstate@entry=0x55de669083f0, pstmt=pstmt@entry=0x55de667ce840, queryString=queryString@entry=0x55de667cda50 "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=0x55de667cf7e8, qc=0x7ffe40e213c0) at ../src/backend/tcop/utility.c:1678 [14:48:41.945] _save_exception_stack = 0x7ffe40e20f70 [14:48:41.945] _save_context_stack = 0x0 [14:48:41.945] _local_sigjmp_buf = {{__jmpbuf = {0, -8993001301475495116, 94413690562448, 0, 94413690559056, 0, -2922205264559115468, -8992996750417497292}, __mask_was_saved = 0, __saved_mask = {__val = {17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 94413657341922, 0, 5412384741217271808, 94413663436512, 94413657594451, 140219748946880, 1, 16777216, 0, 112, 94413657342194, 140219749695488}}}} [14:48:41.945] _do_rethrow = false [14:48:41.945] parsetree = 0x55de667ce790 [14:48:41.945] isTopLevel = true [14:48:41.945] isCompleteQuery = true [14:48:41.945] needCleanup = false [14:48:41.945] commandCollected = false [14:48:41.945] address = {classId = 21982, objectId = 1719461776, objectSubId = 21982} [14:48:41.945] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [14:48:41.945] __func__ = "ProcessUtilitySlow" [14:48:41.945] #12 0x000055de648ab67e in standard_ProcessUtility (pstmt=pstmt@entry=0x55de667ce840, queryString=queryString@entry=0x55de667cda50 "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=0x55de667cf7e8, qc=0x7ffe40e213c0) at ../src/backend/tcop/utility.c:1070 [14:48:41.945] parsetree = 0x55de667ce790 [14:48:41.945] isTopLevel = true [14:48:41.945] isAtomicContext = false [14:48:41.945] pstate = 0x55de669083f0 [14:48:41.945] readonly_flags = [14:48:41.945] __func__ = "standard_ProcessUtility" [14:48:41.945] #13 0x00007f877644dd9d in pgss_ProcessUtility (pstmt=0x55de667ce840, queryString=0x55de667cda50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55de667cf7e8, qc=0x7ffe40e213c0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [14:48:41.945] _save_exception_stack = 0x7ffe40e21280 [14:48:41.945] _save_context_stack = 0x0 [14:48:41.945] _local_sigjmp_buf = {{__jmpbuf = {0, 2922479982035694388, 94413690562624, 94413690566632, 140729986978752, 0, -2922205264714304716, -2918244018011933900}, __mask_was_saved = 0, __saved_mask = {__val = {94413661181339, 140729986978022, 140729986978020, 0, 0, 139637976727552, 206158430232, 140729986977984, 94413661181556, 0, 206158430232, 94413690563424, 140729986978080, 0, 94413655975532, 94413690558800}}}} [14:48:41.945] _do_rethrow = false [14:48:41.945] duration = [14:48:41.945] bufusage = {shared_blks_hit = 94413691597416, shared_blks_read = 953482739712, shared_blks_dirtied = 0, shared_blks_written = 94413691596920, local_blks_hit = 94413691597416, local_blks_read = 94413654292162, local_blks_dirtied = 94413690565328, local_blks_written = 94413654292408, temp_blks_read = 94413691596920, temp_blks_written = 94413691596336, shared_blk_read_time = {ticks = 94413654291517}, shared_blk_write_time = {ticks = 94413661174791}, local_blk_read_time = {ticks = 140219827576248}, local_blk_write_time = {ticks = 94413690559056}, temp_blk_read_time = {ticks = 94413663506478}, temp_blk_write_time = {ticks = 94413673506018}} [14:48:41.945] walusage_start = {wal_records = 8988, wal_fpi = 104, wal_bytes = 1146371} [14:48:41.945] start = [14:48:41.945] rows = [14:48:41.945] bufusage_start = {shared_blks_hit = 34352, shared_blks_read = 4466, shared_blks_dirtied = 1618, shared_blks_written = 1059, 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}} [14:48:41.945] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 140219748946880} [14:48:41.945] parsetree = [14:48:41.945] saved_queryId = 6041762721901209185 [14:48:41.945] saved_stmt_location = 0 [14:48:41.945] saved_stmt_len = 69 [14:48:41.945] enabled = true [14:48:41.945] #14 0x000055de648ab724 in ProcessUtility (pstmt=pstmt@entry=0x55de667ce840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55de667cf7e8, qc=0x7ffe40e213c0) at ../src/backend/tcop/utility.c:519 [14:48:41.945] No locals. [14:48:41.945] #15 0x000055de648a7045 in PortalRunUtility (portal=portal@entry=0x55de66850fc0, pstmt=pstmt@entry=0x55de667ce840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55de667cf7e8, qc=qc@entry=0x7ffe40e213c0) at ../src/backend/tcop/pquery.c:1158 [14:48:41.945] No locals. [14:48:41.945] #16 0x000055de648a75ea in PortalRunMulti (portal=portal@entry=0x55de66850fc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55de667cf7e8, altdest=altdest@entry=0x55de667cf7e8, qc=qc@entry=0x7ffe40e213c0) at ../src/backend/tcop/pquery.c:1315 [14:48:41.945] pstmt = 0x55de667ce840 [14:48:41.945] stmtlist_item__state = [14:48:41.945] active_snapshot_set = false [14:48:41.945] stmtlist_item = 0x55de667cf7b0 [14:48:41.945] #17 0x000055de648a7bbd in PortalRun (portal=portal@entry=0x55de66850fc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55de667cf7e8, altdest=altdest@entry=0x55de667cf7e8, qc=0x7ffe40e213c0) at ../src/backend/tcop/pquery.c:791 [14:48:41.945] _save_exception_stack = 0x7ffe40e21470 [14:48:41.945] _save_context_stack = 0x0 [14:48:41.945] _local_sigjmp_buf = {{__jmpbuf = {0, -8993001301226982604, 94413691097024, 94413690562568, 94413691097024, 94413690562496, -2922205264305360076, -8992996743898107084}, __mask_was_saved = 0, __saved_mask = {__val = {94413660858491, 94413690558800, 112, 4, 94413660862908, 1088557903, 4, 94413690562496, 112, 73, 94413691097024, 94413690562568, 94413690562544, 94413690562496, 94413660950111, 1}}}} [14:48:41.945] _do_rethrow = [14:48:41.945] result = [14:48:41.945] nprocessed = [14:48:41.945] saveTopTransactionResourceOwner = 0x55de66810498 [14:48:41.945] saveTopTransactionContext = 0x55de66862fe0 [14:48:41.945] saveActivePortal = 0x0 [14:48:41.945] saveResourceOwner = 0x55de66810498 [14:48:41.945] savePortalContext = 0x0 [14:48:41.945] saveMemoryContext = 0x55de66862fe0 [14:48:41.945] __func__ = "PortalRun" [14:48:41.945] #18 0x000055de648a0f9f in exec_simple_query (query_string=query_string@entry=0x55de667cda50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [14:48:41.945] cmdtaglen = 24 [14:48:41.945] snapshot_set = [14:48:41.945] per_parsetree_context = 0x0 [14:48:41.945] plantree_list = 0x55de667cf798 [14:48:41.945] parsetree = 0x55de667ce7c0 [14:48:41.945] commandTag = [14:48:41.945] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:48:41.945] querytree_list = [14:48:41.945] portal = 0x55de66850fc0 [14:48:41.945] receiver = 0x55de667cf7e8 [14:48:41.945] format = 0 [14:48:41.945] cmdtagname = [14:48:41.945] parsetree_item__state = [14:48:41.945] dest = DestRemote [14:48:41.945] oldcontext = 0x55de66862fe0 [14:48:41.945] parsetree_list = 0x55de667ce7f0 [14:48:41.945] parsetree_item = 0x55de667ce808 [14:48:41.945] save_log_statement_stats = false [14:48:41.945] was_logged = true [14:48:41.945] use_implicit_block = false [14:48:41.945] msec_str = "\004\000\000\000\000\000\000\000Jֵd\336U\000\000P\024\342@\376\177\000\000G\000\000\000\000\000\000" [14:48:41.945] __func__ = "exec_simple_query" [14:48:41.945] #19 0x000055de648a3d23 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [14:48:41.945] query_string = 0x55de667cda50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [14:48:41.945] firstchar = [14:48:41.945] input_message = {data = 0x55de667cda50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [14:48:41.945] local_sigjmp_buf = {{__jmpbuf = {94413673514584, -8992994669311986892, 140729986979276, 4, 11, 140729986979508, -2922205264510880972, -8992996746502638796}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94413690816880, 0, 168, 94413660863010, 0, 10, 2, 94413673514592, 94413690289648, 94413673508672, 4, 11, 140729986979508}}}} [14:48:41.945] send_ready_for_query = false [14:48:41.945] idle_in_transaction_timeout_enabled = false [14:48:41.945] idle_session_timeout_enabled = false [14:48:41.945] __func__ = "PostgresMain" [14:48:41.945] #20 0x000055de64899b18 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [14:48:41.945] bsdata = [14:48:41.945] #21 0x000055de6474b64c in postmaster_child_launch (child_type=B_BACKEND, child_slot=11, startup_data=startup_data@entry=0x7ffe40e215cc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe40e21620) at ../src/backend/postmaster/launch_backend.c:274 [14:48:41.945] pid = [14:48:41.945] #22 0x000055de64750647 in BackendStartup (client_sock=client_sock@entry=0x7ffe40e21620) at ../src/backend/postmaster/postmaster.c:3390 [14:48:41.945] bn = 0x55de667fa298 [14:48:41.945] pid = [14:48:41.945] startup_data = {canAcceptConnections = CAC_OK} [14:48:41.945] cac = [14:48:41.945] __func__ = "BackendStartup" [14:48:41.945] #23 0x000055de64752520 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [14:48:41.945] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\342@\376\177\000\000\264\026\342@\376\177", '\000' , "\202S\217c\336U\000\000x7\213c\336U\000\000\200\027\342@\376\177\000\000x\027\342@\376\177\000\000\225[\362\001\000\000\000\000pz\177f\336U\000\000,", '\000' , "\220R\217c\336U\000\000h&\034z\207\177\000\0000\006iy\207\177\000", __ss_align = 140219845976800}, salen = 2}} [14:48:41.945] i = 0 [14:48:41.945] now = [14:48:41.945] last_lockfile_recheck_time = 1733582705 [14:48:41.945] last_touch_time = 1733582705 [14:48:41.945] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1670337410, events = 21982, fd = 2048665192, user_data = 0x7f8779690630}, {pos = 2048664288, events = 32647, fd = 2090263927, user_data = 0x7ffe40e21800}, {pos = 2048494152, events = 32647, fd = 15, user_data = 0x7f8779690630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 2048664288, events = 32647, fd = 1088558968, user_data = 0x7ffe40e21780}, {pos = 2048665192, events = 32647, fd = 0, user_data = 0x55de667fc0c8}, {pos = 1690080393, events = 21982, fd = 32768, user_data = 0x1}, {pos = 1719461232, events = 21982, fd = -1, user_data = 0x7f877882e020}, {pos = 2044436384, events = 32647, fd = 1719658072, user_data = 0x55de667fe538}, {pos = 1719681281, events = 21982, fd = 2048519870, user_data = 0x1}, {pos = 2048664288, events = 32647, fd = 427, user_data = 0x55de650dcd58 }, {pos = 0, events = 0, fd = 86, user_data = 0x55de667fc0c8}, {pos = 2048519870, events = 32647, fd = 1, user_data = 0x0}, {pos = 2021842976, events = 32647, fd = 2022649408, user_data = 0x10}, {pos = 1088560096, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2048528826, user_data = 0x0}, {pos = 2022370724, events = 32647, fd = 0, user_data = 0x55de6577ca20 }, {pos = 2, events = 0, fd = 0, user_data = 0x55de6678fe90}, {pos = 1686321687, events = 21982, fd = 1719675227, user_data = 0x55de64837650 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55de667fc0c8}, {pos = 2048519870, events = 32647, fd = 1, user_data = 0x0}, {pos = 2021876936, events = 32647, fd = 2022295680, user_data = 0x43a}, {pos = 2022403847, events = 32647, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 2023693408, events = 32647, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa38}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 2043848000, user_data = 0x7f8779d2aa80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1689757819, events = 21982, fd = 1719687472, user_data = 0x7f87788b576b}, {pos = 2023676384, events = 32647, fd = 2022314350, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xc5e564af8a286800}, {pos = 2023679456, events = 32647, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1719657464, user_data = 0x3}, {pos = 0, events = 0, fd = 32558, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1719648456, user_data = 0x7f87788f3053 }, {pos = 1719657464, events = 21982, fd = 1024, user_data = 0x7ffe40e21ca8}, {pos = 1689841135, events = 21982, fd = 1702413840, user_data = 0x55de64b7d8ac }, {pos = 1719657264, events = 21982, fd = 1719458128, user_data = 0x55de667fe330}, {pos = 2022397803, events = 32647, fd = 0, user_data = 0x55de64b8f516 }, {pos = 1719657264, events = 1, fd = 1689843295, user_data = 0x55de667cd950}, {pos = -1977063424, events = 3320145071, fd = 0, user_data = 0x7f87788a2ab1}, {pos = 2022315248, events = 32647, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1719205520, user_data = 0xc5e564af8a286800}, {pos = 0, events = 0, fd = -1977063424, user_data = 0xc}, {pos = -1977063424, events = 3320145071, fd = 0, user_data = 0x7f877885b239 }, {pos = 87, events = 0, fd = 1685369673, user_data = 0x400000}, {pos = 0, events = 0, fd = 1719205520, user_data = 0x55de64b7d740 }, {pos = 1719292032, events = 21982, fd = 1719458128, user_data = 0x55de667a5080}, {pos = 1, events = 0, fd = 0, user_data = 0x55de64b3c13d }, {pos = 12, events = 0, fd = 1719644408, user_data = 0x55de667fb0d8}, {pos = 1702350752, events = 21982, fd = 296, user_data = 0x55de6474db63 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1685386144, events = 21982, fd = 1698777424, user_data = 0x55de667ce308}} [14:48:41.945] nevents = 1 [14:48:41.945] __func__ = "ServerLoop" [14:48:41.945] #24 0x000055de64753db4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55de6678bcf0) at ../src/backend/postmaster/postmaster.c:1374 [14:48:41.945] opt = [14:48:41.945] status = [14:48:41.945] userDoption = [14:48:41.945] listen_addr_saved = false [14:48:41.945] output_config_variable = [14:48:41.945] __func__ = "PostmasterMain" [14:48:41.945] #25 0x000055de6458b82d in main (argc=4, argv=0x55de6678bcf0) at ../src/backend/main/main.c:222 [14:48:41.945] do_check_root = [14:48:41.945] dispatch_option =