[23:45:24.027] src/tools/ci/cores_backtrace.sh linux /tmp/cores [23:45:24.231] dumping /tmp/cores/postgres-6-29648.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:45:24.483] [New LWP 29648] [23:45:24.483] [23:45:24.483] This GDB supports auto-downloading debuginfo from the following URLs: [23:45:24.483] [23:45:24.483] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [23:45:24.483] Debuginfod has been disabled. [23:45:24.483] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [23:45:24.609] [Thread debugging using libthread_db enabled] [23:45:24.609] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:45:24.609] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [23:45:24.609] Program terminated with signal SIGABRT, Aborted. [23:45:24.609] #0 0x00007f055a4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:25.581] [23:45:25.581] Thread 1 (Thread 0x7f055a3d7f00 (LWP 29648)): [23:45:25.581] #0 0x00007f055a4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:25.581] No symbol table info available. [23:45:25.581] #1 0x00007f055a45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:25.581] No symbol table info available. [23:45:25.581] #2 0x00007f055a445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:25.581] No symbol table info available. [23:45:25.581] #3 0x000055906f353daf in ExceptionalCondition (conditionName=conditionName@entry=0x55906f5c80b5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55906f5c75d0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [23:45:25.581] No locals. [23:45:25.581] #4 0x000055906ecd725b in standard_ExecutorStart (queryDesc=queryDesc@entry=0x559097b1a400, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [23:45:25.581] estate = 0x559097ae37c0 [23:45:25.581] oldcontext = 0x559097a05a00 [23:45:25.581] __func__ = "standard_ExecutorStart" [23:45:25.581] #5 0x000055906ecd7437 in ExecutorStart (queryDesc=queryDesc@entry=0x559097b1a400, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [23:45:25.581] No locals. [23:45:25.581] #6 0x000055906ebfdc72 in refresh_matview_datafill (dest=0x559097b17478, query=, query@entry=0x559097ac9e00, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [23:45:25.581] rewritten = [23:45:25.581] plan = 0x559097b19938 [23:45:25.581] queryDesc = 0x559097b1a400 [23:45:25.581] copied_query = [23:45:25.581] processed = [23:45:25.581] __func__ = "refresh_matview_datafill" [23:45:25.581] #7 0x000055906ebfffd9 in RefreshMatViewByOid (matviewOid=27486, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [23:45:25.581] dest = [23:45:25.581] matviewRel = 0x7f054edb5d18 [23:45:25.581] rule = [23:45:25.581] actions = [23:45:25.581] dataQuery = 0x559097ac9e00 [23:45:25.581] tableSpace = [23:45:25.581] relowner = 10 [23:45:25.581] OIDNewHeap = 27493 [23:45:25.581] processed = 0 [23:45:25.581] relpersistence = 112 'p' [23:45:25.581] save_userid = 10 [23:45:25.581] save_sec_context = 0 [23:45:25.581] save_nestlevel = 2 [23:45:25.581] address = {classId = 0, objectId = 0, objectSubId = 0} [23:45:25.581] __func__ = "RefreshMatViewByOid" [23:45:25.581] #8 0x000055906ec00118 in ExecRefreshMatView (stmt=0x559097b0d0e0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [23:45:25.581] matviewOid = [23:45:25.581] lockmode = [23:45:25.581] #9 0x000055906ebb5d65 in ExecCreateTableAs (pstate=pstate@entry=0x559097a05b00, stmt=stmt@entry=0x5590979b0770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffcfc06380) at ../src/backend/commands/createas.c:351 [23:45:25.581] refresh = [23:45:25.581] query = 0x5590979b0930 [23:45:25.581] into = 0x5590979b04c8 [23:45:25.581] jstate = 0x0 [23:45:25.581] is_matview = true [23:45:25.581] do_refresh = false [23:45:25.581] dest = [23:45:25.581] address = {classId = 1259, objectId = 27486, objectSubId = 0} [23:45:25.581] __func__ = "ExecCreateTableAs" [23:45:25.581] #10 0x000055906f0cc381 in ProcessUtilitySlow (pstate=pstate@entry=0x559097a05b00, pstmt=pstmt@entry=0x5590979b0820, queryString=queryString@entry=0x5590979afa30 "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=0x5590979b1258, qc=0x7fffcfc06380) at ../src/backend/tcop/utility.c:1675 [23:45:25.581] _save_exception_stack = 0x7fffcfc06240 [23:45:25.581] _save_context_stack = 0x0 [23:45:25.581] _local_sigjmp_buf = {{__jmpbuf = {0, 9045341135325470844, 94079507171184, 0, 94079507167792, 0, 2979466917689794684, 9045041120070312060}, __mask_was_saved = 0, __saved_mask = {__val = {139660780305600, 15018, 94078826183445, 1, 4294982314, 139660780305600, 94078830001194, 139660965543352, 94079507167792, 94078832324645, 94078842288610, 94078842288736, 140736678879364, 94078832519512, 94078842288625, 94078842288736}}}} [23:45:25.581] _do_rethrow = false [23:45:25.581] parsetree = 0x5590979b0770 [23:45:25.581] isTopLevel = true [23:45:25.581] isCompleteQuery = true [23:45:25.581] needCleanup = false [23:45:25.581] commandCollected = false [23:45:25.581] address = {classId = 21904, objectId = 2543519600, objectSubId = 21904} [23:45:25.581] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [23:45:25.581] __func__ = "ProcessUtilitySlow" [23:45:25.581] #11 0x000055906f0ca992 in standard_ProcessUtility (pstmt=0x5590979b0820, queryString=0x5590979afa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5590979b1258, qc=0x7fffcfc06380) at ../src/backend/tcop/utility.c:1067 [23:45:25.581] parsetree = 0x5590979b0770 [23:45:25.581] isTopLevel = true [23:45:25.581] isAtomicContext = false [23:45:25.581] pstate = 0x559097a05b00 [23:45:25.581] readonly_flags = [23:45:25.581] __func__ = "standard_ProcessUtility" [23:45:25.581] #12 0x000055906f0caaed in ProcessUtility (pstmt=pstmt@entry=0x5590979b0820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5590979b1258, qc=0x7fffcfc06380) at ../src/backend/tcop/utility.c:523 [23:45:25.581] No locals. [23:45:25.581] #13 0x000055906f0c6359 in PortalRunUtility (portal=portal@entry=0x559097a32680, pstmt=pstmt@entry=0x5590979b0820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5590979b1258, qc=qc@entry=0x7fffcfc06380) at ../src/backend/tcop/pquery.c:1158 [23:45:25.581] No locals. [23:45:25.581] #14 0x000055906f0c68fe in PortalRunMulti (portal=portal@entry=0x559097a32680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5590979b1258, altdest=altdest@entry=0x5590979b1258, qc=qc@entry=0x7fffcfc06380) at ../src/backend/tcop/pquery.c:1316 [23:45:25.581] pstmt = 0x5590979b0820 [23:45:25.581] stmtlist_item__state = [23:45:25.581] active_snapshot_set = false [23:45:25.581] stmtlist_item = 0x5590979b1220 [23:45:25.581] #15 0x000055906f0c6ed1 in PortalRun (portal=portal@entry=0x559097a32680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5590979b1258, altdest=altdest@entry=0x5590979b1258, qc=0x7fffcfc06380) at ../src/backend/tcop/pquery.c:791 [23:45:25.581] _save_exception_stack = 0x7fffcfc06430 [23:45:25.581] _save_context_stack = 0x0 [23:45:25.581] _local_sigjmp_buf = {{__jmpbuf = {0, 9045341135668355196, 94079507703424, 94079507171304, 94079507703424, 94079507171232, 2979466918088253564, 9045041113534931068}, __mask_was_saved = 0, __saved_mask = {__val = {94078829685845, 94079507167536, 112, 4, 94078829690262, 3485491983, 4, 94079507171232, 112, 73, 94079507703424, 94079507171304, 94079507171280, 94079507171232, 94078829777465, 1}}}} [23:45:25.581] _do_rethrow = [23:45:25.581] result = [23:45:25.581] nprocessed = [23:45:25.581] saveTopTransactionResourceOwner = 0x5590979ef838 [23:45:25.581] saveTopTransactionContext = 0x559097a43660 [23:45:25.581] saveActivePortal = 0x0 [23:45:25.581] saveResourceOwner = 0x5590979ef838 [23:45:25.581] savePortalContext = 0x0 [23:45:25.581] saveMemoryContext = 0x559097a43660 [23:45:25.581] __func__ = "PortalRun" [23:45:25.581] #16 0x000055906f0c02bd in exec_simple_query (query_string=query_string@entry=0x5590979afa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [23:45:25.581] cmdtaglen = 24 [23:45:25.581] snapshot_set = [23:45:25.581] per_parsetree_context = 0x0 [23:45:25.581] plantree_list = 0x5590979b1208 [23:45:25.581] parsetree = 0x5590979b07a0 [23:45:25.581] commandTag = [23:45:25.581] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:45:25.581] querytree_list = [23:45:25.581] portal = 0x559097a32680 [23:45:25.581] receiver = 0x5590979b1258 [23:45:25.581] format = 0 [23:45:25.581] cmdtagname = [23:45:25.581] parsetree_item__state = [23:45:25.581] dest = DestRemote [23:45:25.581] oldcontext = 0x559097a43660 [23:45:25.581] parsetree_list = 0x5590979b07d0 [23:45:25.581] parsetree_item = 0x5590979b07e8 [23:45:25.581] save_log_statement_stats = false [23:45:25.581] was_logged = true [23:45:25.581] use_implicit_block = false [23:45:25.581] msec_str = "\340e\300\317\377\177\000\000]\2337o\220U\000\000\020d\300\317\377\177\000\000G\000\000\000\000\000\000" [23:45:25.581] __func__ = "exec_simple_query" [23:45:25.581] #17 0x000055906f0c3041 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [23:45:25.581] query_string = 0x5590979afa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [23:45:25.581] firstchar = [23:45:25.581] input_message = {data = 0x5590979afa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [23:45:25.581] local_sigjmp_buf = {{__jmpbuf = {94078842297176, 9045041229075423356, 4, 140736678880736, 140736678880880, 140736678880884, 2979466918159556732, 9045041115754635388}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94079506898352, 14336, 94078842291264, 94079507425264, 140736678880880, 94078829689810, 0, 9, 2, 94078842297184, 94079506898352, 94078842291264, 140736678880736, 140736678880880, 140736678880884}}}} [23:45:25.581] send_ready_for_query = false [23:45:25.581] idle_in_transaction_timeout_enabled = false [23:45:25.581] idle_session_timeout_enabled = false [23:45:25.581] __func__ = "PostgresMain" [23:45:25.581] #18 0x000055906f0b8eb8 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [23:45:25.581] bsdata = [23:45:25.581] #19 0x000055906ef6c83f in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffcfc0658c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffcfc065e0) at ../src/backend/postmaster/launch_backend.c:266 [23:45:25.581] pid = [23:45:25.581] #20 0x000055906ef722f3 in BackendStartup (client_sock=client_sock@entry=0x7fffcfc065e0) at ../src/backend/postmaster/postmaster.c:3417 [23:45:25.581] bn = 0x5590979e4b18 [23:45:25.581] pid = [23:45:25.581] startup_data = {canAcceptConnections = CAC_OK} [23:45:25.581] __func__ = "BackendStartup" [23:45:25.581] #21 0x000055906ef72855 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [23:45:25.581] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\300\317\377\177\000\000tf\300\317\377\177", '\000' , "Rq\022n\220U\000\000(W\016n\220U\000\000@g\300\317\377\177\000\0008g\300\317\377\177\000\000\225[\362\001\000\000\000\000\240t\303Z\005\177\000\000+", '\000' , "`p\022n\220U\000\000hf\336[\005\177\000\0000v\303Z\005\177\000", __ss_align = 139660992864992}, salen = 2}} [23:45:25.581] i = 0 [23:45:25.581] now = [23:45:25.581] last_lockfile_recheck_time = 1730677287 [23:45:25.581] last_touch_time = 1730677287 [23:45:25.581] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1846702418, events = 21904, fd = 1541301864, user_data = 0x7f055ac37630}, {pos = 1541300960, events = 32517, fd = 2090263927, user_data = 0x7fffcfc067c0}, {pos = 1541130824, events = 32517, fd = 15, user_data = 0x7f055ac37630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1541300960, events = 32517, fd = -809474248, user_data = 0x7fffcfc06740}, {pos = 1541301864, events = 32517, fd = 0, user_data = 0x5590979afa48}, {pos = 1866355884, events = 21904, fd = 32768, user_data = 0x1}, {pos = -1751443472, events = 21904, fd = -1, user_data = 0x7f055a42e020}, {pos = 1536380832, events = 32517, fd = -1751260312, user_data = 0x5590979de248}, {pos = -1751261151, events = 21904, fd = 1541156542, user_data = 0x1}, {pos = 1541300960, events = 32517, fd = 427, user_data = 0x55906f8f5d58 }, {pos = 0, events = 0, fd = 1, user_data = 0x5590979afa48}, {pos = 1541156542, events = 32517, fd = 1, user_data = 0x0}, {pos = 1514332192, events = 32517, fd = 1515138496, user_data = 0x10}, {pos = -809473104, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1541165498, user_data = 0x0}, {pos = 1514859812, events = 32517, fd = 0, user_data = 0x55906ff8e4c0 }, {pos = 2, events = 0, fd = 7, user_data = 0x559097971e50}, {pos = 1862611255, events = 21904, fd = -1751242741, user_data = 0x55906f056d70 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5590979afa48}, {pos = 1541156542, events = 32517, fd = 1, user_data = 0x0}, {pos = 1514366152, events = 32517, fd = 1514784896, user_data = 0x420}, {pos = 1514892935, events = 32517, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 1516182624, events = 32517, 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 = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x7f0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1866034261, events = 21904, fd = -1751287232, user_data = 0x7f055a4b56eb}, {pos = 1516165600, events = 32517, fd = 1514803566, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xc50c1e96bac65400}, {pos = 1516168672, events = 32517, 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 = -1751260920, user_data = 0x55906f397518 }, {pos = -1751261120, events = 21904, fd = 3, user_data = 0x0}, {pos = 26105, events = 0, fd = -328, user_data = 0x0}, {pos = -1751451064, events = 21904, fd = 1515139027, user_data = 0x7fffcfc06c68}, {pos = 1866117577, events = 21904, fd = 1878645520, user_data = 0x55906f399c86 }, {pos = -1751261120, events = 21904, fd = -1751451344, user_data = 0x5590979de040}, {pos = 1514886891, events = 32517, fd = 0, user_data = 0x55906f3ab8f0 }, {pos = -1751261120, events = 1, fd = 1866119737, user_data = 0x5590979af930}, {pos = -1161407488, events = 3305905814, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1514810033, user_data = 0x7f055a4a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1161407488, user_data = 0x559097987060}, {pos = -1161407488, events = 3305905814, fd = 11, user_data = 0xc50c1e96bac65400}, {pos = 0, events = 0, fd = 1514517049, user_data = 0x1}, {pos = 1861666108, events = 21904, fd = 4194304, user_data = 0x55906f399b1a }, {pos = -1751617440, events = 21904, fd = -1751451344, user_data = 0x559097987060}, {pos = 1, events = 0, fd = 0, user_data = 0x55906f3ab8f0 }, {pos = -1751617440, events = 21904, fd = 1866119737, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55906eda0f0e }, {pos = 0, events = 0, fd = 1859805774, user_data = 0xb}, {pos = 1861687265, events = 21904, fd = 1875023760, user_data = 0x5590979b02d8}} [23:45:25.581] nevents = 1 [23:45:25.581] __func__ = "ServerLoop" [23:45:25.581] #22 0x000055906ef73fd8 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55909796dcc0) at ../src/backend/postmaster/postmaster.c:1348 [23:45:25.581] opt = [23:45:25.581] status = [23:45:25.581] userDoption = [23:45:25.581] listen_addr_saved = false [23:45:25.581] output_config_variable = [23:45:25.581] __func__ = "PostmasterMain" [23:45:25.581] #23 0x000055906edb1296 in main (argc=4, argv=0x55909796dcc0) at ../src/backend/main/main.c:196 [23:45:25.581] do_check_root = [23:45:25.618] -e [23:45:25.618] [23:45:25.618] [23:45:25.680] dumping /tmp/cores/postgres-6-29322.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:45:25.918] [New LWP 29322] [23:45:25.918] [23:45:25.918] This GDB supports auto-downloading debuginfo from the following URLs: [23:45:25.918] [23:45:25.918] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [23:45:25.918] Debuginfod has been disabled. [23:45:25.918] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [23:45:26.023] [Thread debugging using libthread_db enabled] [23:45:26.023] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:45:26.023] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [23:45:26.023] Program terminated with signal SIGABRT, Aborted. [23:45:26.023] #0 0x00007fd5288a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:26.980] [23:45:26.980] Thread 1 (Thread 0x7fd526423f00 (LWP 29322)): [23:45:26.980] #0 0x00007fd5288a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:26.980] No symbol table info available. [23:45:26.980] #1 0x00007fd52885afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:26.980] No symbol table info available. [23:45:26.980] #2 0x00007fd528845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:26.980] No symbol table info available. [23:45:26.980] #3 0x000055897b861daf in ExceptionalCondition (conditionName=conditionName@entry=0x55897bad60b5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55897bad55d0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [23:45:26.980] No locals. [23:45:26.980] #4 0x000055897b1e525b in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55898be20630, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [23:45:26.980] estate = 0x55898bd21e30 [23:45:26.980] oldcontext = 0x55898bdf6d90 [23:45:26.980] __func__ = "standard_ExecutorStart" [23:45:26.980] #5 0x000055897b1e5437 in ExecutorStart (queryDesc=queryDesc@entry=0x55898be20630, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [23:45:26.980] No locals. [23:45:26.980] #6 0x000055897b10bc72 in refresh_matview_datafill (dest=0x55898be1d6a8, query=, query@entry=0x55898bd7b0d0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [23:45:26.980] rewritten = [23:45:26.980] plan = 0x55898be1fb68 [23:45:26.980] queryDesc = 0x55898be20630 [23:45:26.980] copied_query = [23:45:26.980] processed = [23:45:26.980] __func__ = "refresh_matview_datafill" [23:45:26.980] #7 0x000055897b10dfd9 in RefreshMatViewByOid (matviewOid=27551, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [23:45:26.980] dest = [23:45:26.980] matviewRel = 0x7fd51cdd4d18 [23:45:26.980] rule = [23:45:26.980] actions = [23:45:26.980] dataQuery = 0x55898bd7b0d0 [23:45:26.980] tableSpace = [23:45:26.980] relowner = 10 [23:45:26.980] OIDNewHeap = 27563 [23:45:26.980] processed = 0 [23:45:26.980] relpersistence = 112 'p' [23:45:26.980] save_userid = 10 [23:45:26.980] save_sec_context = 0 [23:45:26.980] save_nestlevel = 2 [23:45:26.980] address = {classId = 0, objectId = 0, objectSubId = 0} [23:45:26.980] __func__ = "RefreshMatViewByOid" [23:45:26.980] #8 0x000055897b10e118 in ExecRefreshMatView (stmt=0x55898bdb0970, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [23:45:26.980] matviewOid = [23:45:26.980] lockmode = [23:45:26.980] #9 0x000055897b0c3d65 in ExecCreateTableAs (pstate=pstate@entry=0x55898bdf6e90, stmt=stmt@entry=0x55898bc4d7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff2dc413b0) at ../src/backend/commands/createas.c:351 [23:45:26.980] refresh = [23:45:26.980] query = 0x55898bc4d9b0 [23:45:26.980] into = 0x55898bc4d548 [23:45:26.980] jstate = 0x0 [23:45:26.980] is_matview = true [23:45:26.980] do_refresh = false [23:45:26.980] dest = [23:45:26.980] address = {classId = 1259, objectId = 27551, objectSubId = 0} [23:45:26.980] __func__ = "ExecCreateTableAs" [23:45:26.980] #10 0x000055897b5da381 in ProcessUtilitySlow (pstate=pstate@entry=0x55898bdf6e90, pstmt=pstmt@entry=0x55898bc4d8a0, queryString=queryString@entry=0x55898bc4cab0 "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=0x55898bc4e2d8, qc=0x7fff2dc413b0) at ../src/backend/tcop/utility.c:1675 [23:45:26.980] _save_exception_stack = 0x7fff2dc41270 [23:45:26.980] _save_context_stack = 0x0 [23:45:26.980] _local_sigjmp_buf = {{__jmpbuf = {0, -636010345661934006, 94049243813872, 0, 94049243810480, 0, -6646992042191169974, -635694984900454838}, __mask_was_saved = 0, __saved_mask = {__val = {140553297681920, 10859, 94048968039189, 1, 4294978155, 140553297681920, 94048968029507, 1, 46641395673064, 1, 10859, 140553297681920, 140553297681920, 1, 94048968039536, 94049244686312}}}} [23:45:26.980] _do_rethrow = false [23:45:26.980] parsetree = 0x55898bc4d7f0 [23:45:26.980] isTopLevel = true [23:45:26.980] isCompleteQuery = true [23:45:26.980] needCleanup = false [23:45:26.980] commandCollected = false [23:45:26.980] address = {classId = 21897, objectId = 2344933360, objectSubId = 21897} [23:45:26.980] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [23:45:26.980] __func__ = "ProcessUtilitySlow" [23:45:26.980] #11 0x000055897b5d8992 in standard_ProcessUtility (pstmt=0x55898bc4d8a0, queryString=0x55898bc4cab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55898bc4e2d8, qc=0x7fff2dc413b0) at ../src/backend/tcop/utility.c:1067 [23:45:26.980] parsetree = 0x55898bc4d7f0 [23:45:26.980] isTopLevel = true [23:45:26.980] isAtomicContext = false [23:45:26.980] pstate = 0x55898bdf6e90 [23:45:26.980] readonly_flags = [23:45:26.980] __func__ = "standard_ProcessUtility" [23:45:26.980] #12 0x000055897b5d8aed in ProcessUtility (pstmt=pstmt@entry=0x55898bc4d8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55898bc4e2d8, qc=0x7fff2dc413b0) at ../src/backend/tcop/utility.c:523 [23:45:26.980] No locals. [23:45:26.980] #13 0x000055897b5d4359 in PortalRunUtility (portal=portal@entry=0x55898bccf050, pstmt=pstmt@entry=0x55898bc4d8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55898bc4e2d8, qc=qc@entry=0x7fff2dc413b0) at ../src/backend/tcop/pquery.c:1158 [23:45:26.980] No locals. [23:45:26.980] #14 0x000055897b5d48fe in PortalRunMulti (portal=portal@entry=0x55898bccf050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55898bc4e2d8, altdest=altdest@entry=0x55898bc4e2d8, qc=qc@entry=0x7fff2dc413b0) at ../src/backend/tcop/pquery.c:1316 [23:45:26.980] pstmt = 0x55898bc4d8a0 [23:45:26.980] stmtlist_item__state = [23:45:26.980] active_snapshot_set = false [23:45:26.980] stmtlist_item = 0x55898bc4e2a0 [23:45:26.980] #15 0x000055897b5d4ed1 in PortalRun (portal=portal@entry=0x55898bccf050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55898bc4e2d8, altdest=altdest@entry=0x55898bc4e2d8, qc=0x7fff2dc413b0) at ../src/backend/tcop/pquery.c:791 [23:45:26.980] _save_exception_stack = 0x7fff2dc41460 [23:45:26.980] _save_context_stack = 0x0 [23:45:26.980] _local_sigjmp_buf = {{__jmpbuf = {0, -636010346394888630, 94049244344400, 94049243813992, 94049244344400, 94049243813920, -6646992042866452918, -635694987239434678}, __mask_was_saved = 0, __saved_mask = {__val = {94048971541589, 94049243810224, 112, 4, 94048971546006, 767824703, 4, 94049243813920, 112, 73, 94049244344400, 94049243813992, 94049243813968, 94049243813920, 94048971633209, 1}}}} [23:45:26.980] _do_rethrow = [23:45:26.980] result = [23:45:26.980] nprocessed = [23:45:26.980] saveTopTransactionResourceOwner = 0x55898bc8bd08 [23:45:26.980] saveTopTransactionContext = 0x55898bce0c60 [23:45:26.980] saveActivePortal = 0x0 [23:45:26.980] saveResourceOwner = 0x55898bc8bd08 [23:45:26.980] savePortalContext = 0x0 [23:45:26.980] saveMemoryContext = 0x55898bce0c60 [23:45:26.980] __func__ = "PortalRun" [23:45:26.980] #16 0x000055897b5ce2bd in exec_simple_query (query_string=query_string@entry=0x55898bc4cab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [23:45:26.980] cmdtaglen = 24 [23:45:26.980] snapshot_set = [23:45:26.980] per_parsetree_context = 0x0 [23:45:26.980] plantree_list = 0x55898bc4e288 [23:45:26.980] parsetree = 0x55898bc4d820 [23:45:26.980] commandTag = [23:45:26.980] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:45:26.980] querytree_list = [23:45:26.980] portal = 0x55898bccf050 [23:45:26.980] receiver = 0x55898bc4e2d8 [23:45:26.980] format = 0 [23:45:26.980] cmdtagname = [23:45:26.980] parsetree_item__state = [23:45:26.980] dest = DestRemote [23:45:26.980] oldcontext = 0x55898bce0c60 [23:45:26.980] parsetree_list = 0x55898bc4d850 [23:45:26.980] parsetree_item = 0x55898bc4d868 [23:45:26.980] save_log_statement_stats = false [23:45:26.980] was_logged = false [23:45:26.980] use_implicit_block = false [23:45:26.980] msec_str = "\020\026\304-\377\177\000\000]{\210{\211U\000\000@\024\304-\377\177\000\000G\000\000\000\000\000\000" [23:45:26.980] __func__ = "exec_simple_query" [23:45:26.980] #17 0x000055897b5d1041 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [23:45:26.980] query_string = 0x55898bc4cab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [23:45:26.980] firstchar = [23:45:26.980] input_message = {data = 0x55898bc4cab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [23:45:26.980] local_sigjmp_buf = {{__jmpbuf = {94048984152920, -635710233656109494, 4, 140733961213456, 140733961213600, 140733961213604, -6646992043063585206, -635694989316270518}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94049243540944, 15616, 94048984147008, 94049244064960, 140733961213600, 94048971545554, 0, 9, 2, 94048984152928, 94049243540944, 94048984147008, 140733961213456, 140733961213600, 140733961213604}}}} [23:45:26.980] send_ready_for_query = false [23:45:26.980] idle_in_transaction_timeout_enabled = false [23:45:26.980] idle_session_timeout_enabled = false [23:45:26.980] __func__ = "PostgresMain" [23:45:26.980] #18 0x000055897b5c6eb8 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [23:45:26.980] bsdata = [23:45:26.980] #19 0x000055897b47a83f in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff2dc415bc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff2dc41610) at ../src/backend/postmaster/launch_backend.c:266 [23:45:26.980] pid = [23:45:26.980] #20 0x000055897b4802f3 in BackendStartup (client_sock=client_sock@entry=0x7fff2dc41610) at ../src/backend/postmaster/postmaster.c:3417 [23:45:26.980] bn = 0x55898bc752f8 [23:45:26.980] pid = [23:45:26.980] startup_data = {canAcceptConnections = CAC_OK} [23:45:26.980] __func__ = "BackendStartup" [23:45:26.980] #21 0x000055897b480855 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [23:45:26.980] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\203(\325\177\000\000\240\317\322)\325\177\000\000\270\026\304-\377\177\000\000\264\026\304-\377\177", '\000' , "RQcz\211U\000\000(7_z\211U\000\000\200\027\304-\377\177\000\000x\027\304-\377\177\000\000\225[\362\001\000\000\000\000\2404\003)\325\177\000\000+", '\000' , "\211U\000\000`Pcz\211U\000", __ss_align = 140553510598248}, salen = 2}} [23:45:26.980] i = 0 [23:45:26.980] now = [23:45:26.980] last_lockfile_recheck_time = 1730677284 [23:45:26.980] last_touch_time = 1730677284 [23:45:26.980] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55897a635152}, {pos = 705836648, events = 32725, fd = 688076336, user_data = 0x7fd52a1232e0}, {pos = 2090263927, events = 0, fd = 767825920, user_data = 0x7fd52a0f9a48}, {pos = 15, events = 0, fd = 688076336, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fd52a1232e0}, {pos = 767825784, events = 32767, fd = 767825792, user_data = 0x7fd52a123668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = -1950029648, events = 21897, fd = 1, user_data = 0x7fff2dc41ca3}, {pos = -1, events = 0, fd = 679665696, user_data = 0x7fd529d2cfa0}, {pos = -1949853880, events = 21897, fd = -1949854168, user_data = 0x55898bc7b841}, {pos = 705691326, events = 32725, fd = 1, user_data = 0x7fd52a1232e0}, {pos = 427, events = 0, fd = 2078293336, user_data = 0x0}, {pos = 1, events = 0, fd = -1950037136, user_data = 0x7fd52a0ffebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fd52882e020}, {pos = 680472000, events = 32725, fd = 16, user_data = 0x7fff2dc41be0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 705700282, events = 32725, fd = 0, user_data = 0x7fd5288aed24 }, {pos = 0, events = 0, fd = 2085209280, user_data = 0x2}, {pos = 7, events = 0, fd = -1950290320, user_data = 0x55897b564d70 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = -1950037136, user_data = 0x7fd52a0ffebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fd5288364c8}, {pos = 680226797, events = 32725, fd = 2085263968, user_data = 0x55898bc78410}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 681516128, events = 32725, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x312020200a0a5330}, {pos = 822763892, events = 909128503, fd = 942815031, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1949851600, user_data = 0x7fd5288b56eb}, {pos = 681499104, events = 32725, fd = 680137070, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3562571fe4c1fb00}, {pos = 681502176, events = 32725, fd = -328, user_data = 0x0}, {pos = -1949854488, events = 21897, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1949854688, events = 21897, fd = 3, user_data = 0x0}, {pos = 25436, events = 0, fd = -328, user_data = 0x0}, {pos = -1950037136, events = 21897, fd = 680472531, user_data = 0x7fff2dc41c98}, {pos = 2072744393, events = 21897, fd = 2085272336, user_data = 0x55897b8a7c86 }, {pos = -1949854688, events = 21897, fd = -1950037584, user_data = 0x55898bc79420}, {pos = 680220734, events = 32725, fd = 0, user_data = 0x55897b8b98f0 }, {pos = -1949854688, events = 1, fd = 2072746553, user_data = 0x55898bc4c9b0}, {pos = -457049344, events = 895637279, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 680143537, user_data = 0x7fd5288a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -457049344, user_data = 0x55898bc240e0}, {pos = -457049344, events = 895637279, fd = 11, user_data = 0x3562571fe4c1fb00}, {pos = 0, events = 0, fd = 679850553, user_data = 0x1}, {pos = 2068292924, events = 21897, fd = 4194304, user_data = 0x55897b8a7b1a }, {pos = -1950203680, events = 21897, fd = -1950037584, user_data = 0x55898bc240e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55897b8b98f0 }, {pos = -1950203680, events = 21897, fd = 2072746553, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55897b2aef0e }, {pos = 0, events = 0, fd = 2066432590, user_data = 0xb}, {pos = 2068314081, events = 21897, fd = 2081650576, user_data = 0x55898bc4d388}} [23:45:26.980] nevents = 1 [23:45:26.980] __func__ = "ServerLoop" [23:45:26.980] #22 0x000055897b481fd8 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55898bc0ad30) at ../src/backend/postmaster/postmaster.c:1348 [23:45:26.980] opt = [23:45:26.980] status = [23:45:26.980] userDoption = [23:45:26.980] listen_addr_saved = false [23:45:26.980] output_config_variable = [23:45:26.980] __func__ = "PostmasterMain" [23:45:26.980] #23 0x000055897b2bf296 in main (argc=8, argv=0x55898bc0ad30) at ../src/backend/main/main.c:196 [23:45:26.980] do_check_root = [23:45:27.017] -e [23:45:27.017] [23:45:27.017] [23:45:27.079] dumping /tmp/cores/postgres-6-36232.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:45:27.319] [New LWP 36232] [23:45:27.319] [23:45:27.319] This GDB supports auto-downloading debuginfo from the following URLs: [23:45:27.319] [23:45:27.319] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [23:45:27.319] Debuginfod has been disabled. [23:45:27.319] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [23:45:27.425] [Thread debugging using libthread_db enabled] [23:45:27.425] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:45:27.425] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [23:45:27.425] Program terminated with signal SIGABRT, Aborted. [23:45:27.425] #0 0x00007f3f59aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:28.379] [23:45:28.379] Thread 1 (Thread 0x7f3f5762ff00 (LWP 36232)): [23:45:28.379] #0 0x00007f3f59aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:28.379] No symbol table info available. [23:45:28.379] #1 0x00007f3f59a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:28.379] No symbol table info available. [23:45:28.379] #2 0x00007f3f59a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [23:45:28.379] No symbol table info available. [23:45:28.379] #3 0x00005636cfcfbdaf in ExceptionalCondition (conditionName=conditionName@entry=0x5636cff700b5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5636cff6f5d0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [23:45:28.379] No locals. [23:45:28.379] #4 0x00005636cf67f25b in standard_ExecutorStart (queryDesc=0x5636f6dfb3c0, eflags=0) at ../src/backend/executor/execMain.c:194 [23:45:28.379] estate = 0x5636f6cf9910 [23:45:28.379] oldcontext = 0x5636f6daa990 [23:45:28.379] __func__ = "standard_ExecutorStart" [23:45:28.379] #5 0x00007f3f571396f7 in pgss_ExecutorStart (queryDesc=0x5636f6dfb3c0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [23:45:28.379] No locals. [23:45:28.379] #6 0x00005636cf67f3f0 in ExecutorStart (queryDesc=queryDesc@entry=0x5636f6dfb3c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [23:45:28.379] No locals. [23:45:28.379] #7 0x00005636cf5a5c72 in refresh_matview_datafill (dest=0x5636f6d5fea8, query=, query@entry=0x5636f6d2ba70, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [23:45:28.379] rewritten = [23:45:28.379] plan = 0x5636f6dfa8c8 [23:45:28.379] queryDesc = 0x5636f6dfb3c0 [23:45:28.379] copied_query = [23:45:28.379] processed = [23:45:28.379] __func__ = "refresh_matview_datafill" [23:45:28.379] #8 0x00005636cf5a7fd9 in RefreshMatViewByOid (matviewOid=27415, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [23:45:28.379] dest = [23:45:28.379] matviewRel = 0x7f3f553d9d18 [23:45:28.379] rule = [23:45:28.379] actions = [23:45:28.379] dataQuery = 0x5636f6d2ba70 [23:45:28.379] tableSpace = [23:45:28.379] relowner = 10 [23:45:28.379] OIDNewHeap = 27435 [23:45:28.379] processed = 0 [23:45:28.379] relpersistence = 112 'p' [23:45:28.379] save_userid = 10 [23:45:28.379] save_sec_context = 0 [23:45:28.379] save_nestlevel = 2 [23:45:28.379] address = {classId = 0, objectId = 0, objectSubId = 0} [23:45:28.379] __func__ = "RefreshMatViewByOid" [23:45:28.379] #9 0x00005636cf5a8118 in ExecRefreshMatView (stmt=0x5636f6d9f750, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [23:45:28.379] matviewOid = [23:45:28.379] lockmode = [23:45:28.379] #10 0x00005636cf55dd65 in ExecCreateTableAs (pstate=pstate@entry=0x5636f6daaa90, stmt=stmt@entry=0x5636f6c09790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffbb7e00c0) at ../src/backend/commands/createas.c:351 [23:45:28.379] refresh = [23:45:28.379] query = 0x5636f6c09950 [23:45:28.379] into = 0x5636f6c094e8 [23:45:28.379] jstate = 0x0 [23:45:28.379] is_matview = true [23:45:28.379] do_refresh = false [23:45:28.379] dest = [23:45:28.379] address = {classId = 1259, objectId = 27415, objectSubId = 0} [23:45:28.379] __func__ = "ExecCreateTableAs" [23:45:28.379] #11 0x00005636cfa74381 in ProcessUtilitySlow (pstate=pstate@entry=0x5636f6daaa90, pstmt=pstmt@entry=0x5636f6c09840, queryString=queryString@entry=0x5636f6c08a50 "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=0x5636f6c0a7e8, qc=0x7fffbb7e00c0) at ../src/backend/tcop/utility.c:1675 [23:45:28.379] _save_exception_stack = 0x7fffbb7dfc70 [23:45:28.379] _save_context_stack = 0x0 [23:45:28.379] _local_sigjmp_buf = {{__jmpbuf = {0, -5739912826070085765, 94794068039568, 0, 94794068036176, 0, -2034183609301971077, -5739897659884810373}, __mask_was_saved = 0, __saved_mask = {__val = {17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 94793411491586, 0, 5412384741217271808, 94793417564640, 94793411744447, 139909993030848, 1, 16777216, 0, 112, 94793411491858, 139909993795584}}}} [23:45:28.379] _do_rethrow = false [23:45:28.379] parsetree = 0x5636f6c09790 [23:45:28.379] isTopLevel = true [23:45:28.379] isCompleteQuery = true [23:45:28.379] needCleanup = false [23:45:28.379] commandCollected = false [23:45:28.379] address = {classId = 22070, objectId = 4139816848, objectSubId = 22070} [23:45:28.379] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [23:45:28.379] __func__ = "ProcessUtilitySlow" [23:45:28.379] #12 0x00005636cfa72992 in standard_ProcessUtility (pstmt=pstmt@entry=0x5636f6c09840, queryString=queryString@entry=0x5636f6c08a50 "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=0x5636f6c0a7e8, qc=0x7fffbb7e00c0) at ../src/backend/tcop/utility.c:1067 [23:45:28.379] parsetree = 0x5636f6c09790 [23:45:28.379] isTopLevel = true [23:45:28.379] isAtomicContext = false [23:45:28.379] pstate = 0x5636f6daaa90 [23:45:28.379] readonly_flags = [23:45:28.379] __func__ = "standard_ProcessUtility" [23:45:28.379] #13 0x00007f3f5713cd9d in pgss_ProcessUtility (pstmt=0x5636f6c09840, queryString=0x5636f6c08a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5636f6c0a7e8, qc=0x7fffbb7e00c0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [23:45:28.379] _save_exception_stack = 0x7fffbb7dff80 [23:45:28.379] _save_context_stack = 0x0 [23:45:28.379] _local_sigjmp_buf = {{__jmpbuf = {0, 2034032958769352571, 94794068039744, 94794068043752, 140736338985152, 0, -2034183609205502085, -2142314755338907781}, __mask_was_saved = 0, __saved_mask = {__val = {94793415316926, 140736338984422, 140736338984420, 0, 0, 139637976727552, 206158430232, 140736338984384, 94793415317143, 0, 206158430232, 94794068040544, 140736338984480, 0, 94793410136198, 94794068035920}}}} [23:45:28.379] _do_rethrow = false [23:45:28.379] duration = [23:45:28.379] bufusage = {shared_blks_hit = 94794069024072, shared_blks_read = 231928233984, shared_blks_dirtied = 0, shared_blks_written = 94794069023576, local_blks_hit = 94794069024072, local_blks_read = 94793408467581, local_blks_dirtied = 94794070072008, local_blks_written = 94793408467827, temp_blks_read = 94794069023576, temp_blks_written = 94794069022992, shared_blk_read_time = {ticks = 94793408466936}, shared_blk_write_time = {ticks = 94793415310378}, local_blk_read_time = {ticks = 139910025772472}, local_blk_write_time = {ticks = 94794068036176}, temp_blk_read_time = {ticks = 94793417633829}, temp_blk_write_time = {ticks = 94793427597794}} [23:45:28.379] walusage_start = {wal_records = 8933, wal_fpi = 95, wal_bytes = 1092674} [23:45:28.379] start = [23:45:28.379] rows = [23:45:28.379] bufusage_start = {shared_blks_hit = 34110, shared_blks_read = 3656, shared_blks_dirtied = 1551, shared_blks_written = 1053, 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}} [23:45:28.379] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 139909993030848} [23:45:28.379] parsetree = [23:45:28.379] saved_queryId = 6041762721901209185 [23:45:28.379] saved_stmt_location = 0 [23:45:28.379] saved_stmt_len = 69 [23:45:28.379] enabled = true [23:45:28.379] #14 0x00005636cfa72a38 in ProcessUtility (pstmt=pstmt@entry=0x5636f6c09840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5636f6c0a7e8, qc=0x7fffbb7e00c0) at ../src/backend/tcop/utility.c:519 [23:45:28.379] No locals. [23:45:28.379] #15 0x00005636cfa6e359 in PortalRunUtility (portal=portal@entry=0x5636f6c89f90, pstmt=pstmt@entry=0x5636f6c09840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5636f6c0a7e8, qc=qc@entry=0x7fffbb7e00c0) at ../src/backend/tcop/pquery.c:1158 [23:45:28.379] No locals. [23:45:28.379] #16 0x00005636cfa6e8fe in PortalRunMulti (portal=portal@entry=0x5636f6c89f90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5636f6c0a7e8, altdest=altdest@entry=0x5636f6c0a7e8, qc=qc@entry=0x7fffbb7e00c0) at ../src/backend/tcop/pquery.c:1316 [23:45:28.379] pstmt = 0x5636f6c09840 [23:45:28.379] stmtlist_item__state = [23:45:28.379] active_snapshot_set = false [23:45:28.379] stmtlist_item = 0x5636f6c0a7b0 [23:45:28.379] #17 0x00005636cfa6eed1 in PortalRun (portal=portal@entry=0x5636f6c89f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5636f6c0a7e8, altdest=altdest@entry=0x5636f6c0a7e8, qc=0x7fffbb7e00c0) at ../src/backend/tcop/pquery.c:791 [23:45:28.379] _save_exception_stack = 0x7fffbb7e0170 [23:45:28.379] _save_context_stack = 0x0 [23:45:28.379] _local_sigjmp_buf = {{__jmpbuf = {0, -5739912825553137797, 94794068565904, 94794068039688, 94794068565904, 94794068039616, -2034183609048215685, -5739897653351526533}, __mask_was_saved = 0, __saved_mask = {__val = {94793414995029, 94794068035920, 112, 4, 94793414999446, 3145597007, 4, 94794068039616, 112, 73, 94794068565904, 94794068039688, 94794068039664, 94794068039616, 94793415086649, 1}}}} [23:45:28.379] _do_rethrow = [23:45:28.379] result = [23:45:28.379] nprocessed = [23:45:28.379] saveTopTransactionResourceOwner = 0x5636f6c49468 [23:45:28.379] saveTopTransactionContext = 0x5636f6c9c3c0 [23:45:28.379] saveActivePortal = 0x0 [23:45:28.379] saveResourceOwner = 0x5636f6c49468 [23:45:28.379] savePortalContext = 0x0 [23:45:28.379] saveMemoryContext = 0x5636f6c9c3c0 [23:45:28.379] __func__ = "PortalRun" [23:45:28.379] #18 0x00005636cfa682bd in exec_simple_query (query_string=query_string@entry=0x5636f6c08a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [23:45:28.379] cmdtaglen = 24 [23:45:28.379] snapshot_set = [23:45:28.379] per_parsetree_context = 0x0 [23:45:28.379] plantree_list = 0x5636f6c0a798 [23:45:28.379] parsetree = 0x5636f6c097c0 [23:45:28.379] commandTag = [23:45:28.379] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:45:28.379] querytree_list = [23:45:28.379] portal = 0x5636f6c89f90 [23:45:28.379] receiver = 0x5636f6c0a7e8 [23:45:28.379] format = 0 [23:45:28.379] cmdtagname = [23:45:28.379] parsetree_item__state = [23:45:28.379] dest = DestRemote [23:45:28.379] oldcontext = 0x5636f6c9c3c0 [23:45:28.379] parsetree_list = 0x5636f6c097f0 [23:45:28.379] parsetree_item = 0x5636f6c09808 [23:45:28.379] save_log_statement_stats = false [23:45:28.379] was_logged = true [23:45:28.379] use_implicit_block = false [23:45:28.379] msec_str = " \003~\273\377\177\000\000]\033\322\3176V\000\000P\001~\273\377\177\000\000G\000\000\000\000\000\000" [23:45:28.379] __func__ = "exec_simple_query" [23:45:28.379] #19 0x00005636cfa6b041 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [23:45:28.379] query_string = 0x5636f6c08a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [23:45:28.379] firstchar = [23:45:28.379] input_message = {data = 0x5636f6c08a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [23:45:28.379] local_sigjmp_buf = {{__jmpbuf = {94793427606360, -5739847501668528261, 4, 140736338985760, 140736338985904, 140736338985908, -2034183583215497349, -5739897655703351429}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94794068285760, 0, 168, 94793414999548, 0, 10, 2, 94793427606368, 94794067766768, 94793427600448, 140736338985760, 140736338985904, 140736338985908}}}} [23:45:28.379] send_ready_for_query = false [23:45:28.379] idle_in_transaction_timeout_enabled = false [23:45:28.379] idle_session_timeout_enabled = false [23:45:28.379] __func__ = "PostgresMain" [23:45:28.379] #20 0x00005636cfa60eb8 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [23:45:28.379] bsdata = [23:45:28.379] #21 0x00005636cf91483f in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffbb7e02cc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffbb7e0320) at ../src/backend/postmaster/launch_backend.c:266 [23:45:28.379] pid = [23:45:28.379] #22 0x00005636cf91a2f3 in BackendStartup (client_sock=client_sock@entry=0x7fffbb7e0320) at ../src/backend/postmaster/postmaster.c:3417 [23:45:28.379] bn = 0x5636f6c355b8 [23:45:28.379] pid = [23:45:28.379] startup_data = {canAcceptConnections = CAC_OK} [23:45:28.379] __func__ = "BackendStartup" [23:45:28.379] #23 0x00005636cf91a855 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [23:45:28.379] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "~\273\377\177\000\000\264\003~\273\377\177", '\000' , "R\361\254\3166V\000\000(ר\3166V\000\000\200\004~\273\377\177\000\000x\004~\273\377\177\000\000\225[\362\001\000\000\000\000p*\303\3666V\000\000,", '\000' , "`\360\254\3166V\000\000h65[?\177\000\0000\006\243W?\177\000", __ss_align = 139910089880288}, salen = 2}} [23:45:28.379] i = 0 [23:45:28.379] now = [23:45:28.379] last_lockfile_recheck_time = 1730677321 [23:45:28.379] last_touch_time = 1730677321 [23:45:28.379] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -827526830, events = 22070, fd = 1530213992, user_data = 0x7f3f57a30630}, {pos = 1530213088, events = 32575, fd = 2090263927, user_data = 0x7fffbb7e0500}, {pos = 1530042952, events = 32575, fd = 15, user_data = 0x7f3f57a30630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1530213088, events = 32575, fd = -1149369224, user_data = 0x7fffbb7e0480}, {pos = 1530213992, events = 32575, fd = 0, user_data = 0x5636f6c0a890}, {pos = -807873364, events = 22070, fd = 32768, user_data = 0x1}, {pos = -155150992, events = 22070, fd = -1, user_data = 0x7f3f59a2e020}, {pos = 1525985184, events = 32575, fd = -154975480, user_data = 0x5636f6c341e8}, {pos = -154957679, events = 22070, fd = 1530068670, user_data = 0x1}, {pos = 1530213088, events = 32575, fd = 427, user_data = 0x5636d029dd58 }, {pos = 0, events = 0, fd = 1, user_data = 0x5636f6c0a890}, {pos = 1530068670, events = 32575, fd = 1, user_data = 0x0}, {pos = 1503846432, events = 32575, fd = 1504652736, user_data = 0x10}, {pos = -1149368080, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1530077626, user_data = 0x0}, {pos = 1504374052, events = 32575, fd = 0, user_data = 0x5636d09364c0 }, {pos = 2, events = 0, fd = 7, user_data = 0x5636f6bcae90}, {pos = -811617993, events = 22070, fd = -154936997, user_data = 0x5636cf9fed70 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5636f6c0a890}, {pos = 1530068670, events = 32575, fd = 1, user_data = 0x0}, {pos = 1503880392, events = 32575, fd = 1504299136, user_data = 0x420}, {pos = 1504407533, events = 32575, fd = 2, user_data = 0x5636f6c3d900}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = 1505696864, events = 32575, 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 = 0xa62}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 1512256832, user_data = 0x7f3f5a233a80}, {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 = -808194987, events = 22070, fd = -154961776, user_data = 0x7f3f59ab583e}, {pos = 1505679840, events = 32575, fd = 1504317806, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xa4e95a3336275900}, {pos = 1505682912, events = 32575, 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 = -154976088, user_data = 0x5636cfd3f518 }, {pos = -154976288, events = 22070, fd = 3, user_data = 0x0}, {pos = 32661, events = 0, fd = -328, user_data = 0x0}, {pos = -155146096, events = 22070, fd = 1504653267, user_data = 0x7fffbb7e09a8}, {pos = -808111671, events = 22070, fd = -795583728, user_data = 0x5636cfd41c86 }, {pos = -154976288, events = 22070, fd = -155154096, user_data = 0x5636f6c33fe0}, {pos = 1504401470, events = 32575, fd = 0, user_data = 0x5636cfd538f0 }, {pos = -154976288, events = 1, fd = -808109511, user_data = 0x5636f6c08950}, {pos = 908548352, events = 2766756403, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1504324273, user_data = 0x7f3f59aa14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 908548352, user_data = 0x5636f6be0080}, {pos = 908548352, events = 2766756403, fd = 11, user_data = 0xa4e95a3336275900}, {pos = 0, events = 0, fd = 1504031289, user_data = 0x1}, {pos = -812563140, events = 22070, fd = 4194304, user_data = 0x5636cfd41b1a }, {pos = -155320192, events = 22070, fd = -155154096, user_data = 0x5636f6be0080}, {pos = 1, events = 0, fd = 0, user_data = 0x5636cfd538f0 }, {pos = -155320192, events = 22070, fd = -808109511, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5636cf748f0e }, {pos = 0, events = 0, fd = -814423474, user_data = 0xb}, {pos = -812541983, events = 22070, fd = -799205488, user_data = 0x5636f6c09308}} [23:45:28.379] nevents = 1 [23:45:28.379] __func__ = "ServerLoop" [23:45:28.379] #24 0x00005636cf91bfd8 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5636f6bc6cf0) at ../src/backend/postmaster/postmaster.c:1348 [23:45:28.379] opt = [23:45:28.379] status = [23:45:28.379] userDoption = [23:45:28.379] listen_addr_saved = false [23:45:28.379] output_config_variable = [23:45:28.379] __func__ = "PostmasterMain" [23:45:28.379] #25 0x00005636cf759296 in main (argc=4, argv=0x5636f6bc6cf0) at ../src/backend/main/main.c:196 [23:45:28.379] do_check_root =