[16:14:15.155] src/tools/ci/cores_backtrace.sh linux /tmp/cores [16:14:15.332] dumping /tmp/cores/postgres-6-31081.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [16:14:15.573] [New LWP 31081] [16:14:15.573] [16:14:15.573] This GDB supports auto-downloading debuginfo from the following URLs: [16:14:15.573] [16:14:15.573] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [16:14:15.573] Debuginfod has been disabled. [16:14:15.573] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [16:14:15.687] [Thread debugging using libthread_db enabled] [16:14:15.687] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [16:14:15.687] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [16:14:15.687] Program terminated with signal SIGABRT, Aborted. [16:14:15.687] #0 0x00007f3d5b4a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:16.622] [16:14:16.622] Thread 1 (Thread 0x7f3d5b3d8f00 (LWP 31081)): [16:14:16.622] #0 0x00007f3d5b4a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:16.622] No symbol table info available. [16:14:16.622] #1 0x00007f3d5b45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:16.622] No symbol table info available. [16:14:16.622] #2 0x00007f3d5b445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:16.622] No symbol table info available. [16:14:16.622] #3 0x0000562886d5b08d in ExceptionalCondition (conditionName=conditionName@entry=0x562886fda266 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x562886fd9690 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [16:14:16.622] No locals. [16:14:16.622] #4 0x00005628866ba30f in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5628a6647ca0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:203 [16:14:16.622] estate = 0x5628a65ff6d0 [16:14:16.622] oldcontext = 0x5628a664e490 [16:14:16.622] __func__ = "standard_ExecutorStart" [16:14:16.622] #5 0x00005628866ba4ee in ExecutorStart (queryDesc=queryDesc@entry=0x5628a6647ca0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:142 [16:14:16.622] plan_valid = [16:14:16.622] #6 0x00005628865d88b3 in refresh_matview_datafill (dest=0x5628a660ed90, query=, query@entry=0x5628a66859f0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [16:14:16.622] rewritten = [16:14:16.622] plan = 0x5628a66472f8 [16:14:16.622] queryDesc = 0x5628a6647ca0 [16:14:16.622] copied_query = [16:14:16.622] processed = [16:14:16.622] __func__ = "refresh_matview_datafill" [16:14:16.622] #7 0x00005628865dac52 in RefreshMatViewByOid (matviewOid=28719, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [16:14:16.622] dest = [16:14:16.622] matviewRel = 0x7f3d4fa289b0 [16:14:16.622] rule = [16:14:16.622] actions = [16:14:16.622] dataQuery = 0x5628a66859f0 [16:14:16.622] tableSpace = [16:14:16.622] relowner = 10 [16:14:16.622] OIDNewHeap = 28726 [16:14:16.622] processed = 0 [16:14:16.622] relpersistence = 112 'p' [16:14:16.622] save_userid = 10 [16:14:16.622] save_sec_context = 0 [16:14:16.622] save_nestlevel = 2 [16:14:16.622] address = {classId = 0, objectId = 0, objectSubId = 0} [16:14:16.622] __func__ = "RefreshMatViewByOid" [16:14:16.622] #8 0x00005628865dad91 in ExecRefreshMatView (stmt=0x5628a660ea68, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [16:14:16.622] matviewOid = [16:14:16.622] lockmode = [16:14:16.622] #9 0x000056288659044a in ExecCreateTableAs (pstate=pstate@entry=0x5628a664e590, stmt=stmt@entry=0x5628a64d1eb0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe4068d1a0) at ../src/backend/commands/createas.c:351 [16:14:16.622] refresh = [16:14:16.622] query = 0x5628a64d2070 [16:14:16.622] into = 0x5628a64d1c08 [16:14:16.622] jstate = 0x0 [16:14:16.622] is_matview = true [16:14:16.622] do_refresh = false [16:14:16.622] dest = [16:14:16.622] address = {classId = 1259, objectId = 28719, objectSubId = 0} [16:14:16.622] __func__ = "ExecCreateTableAs" [16:14:16.622] #10 0x0000562886ac8967 in ProcessUtilitySlow (pstate=pstate@entry=0x5628a664e590, pstmt=pstmt@entry=0x5628a64d1f60, queryString=queryString@entry=0x5628a64d1170 "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=0x5628a64d2998, qc=0x7ffe4068d1a0) at ../src/backend/tcop/utility.c:1678 [16:14:16.622] _save_exception_stack = 0x7ffe4068d080 [16:14:16.622] _save_context_stack = 0x0 [16:14:16.622] _local_sigjmp_buf = {{__jmpbuf = {0, 9045463086562010403, 94732588752560, 0, 94732588749168, 0, 3326537843300361507, 9045393000001561891}, __mask_was_saved = 0, __saved_mask = {__val = {28723, 0, 94732061111460, 1336052144, 94732589991352, 0, 94732057887077, 0, 94732057547717, 139901454613120, 36837934497792, 139901313698468, 94732060578394, 8577, 94732057547717, 139901306271136}}}} [16:14:16.622] _do_rethrow = false [16:14:16.622] parsetree = 0x5628a64d1eb0 [16:14:16.622] isTopLevel = true [16:14:16.622] isCompleteQuery = true [16:14:16.622] needCleanup = false [16:14:16.622] commandCollected = false [16:14:16.622] address = {classId = 22056, objectId = 2790071984, objectSubId = 22056} [16:14:16.622] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [16:14:16.622] __func__ = "ProcessUtilitySlow" [16:14:16.622] #11 0x0000562886ac6f62 in standard_ProcessUtility (pstmt=0x5628a64d1f60, queryString=0x5628a64d1170 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5628a64d2998, qc=0x7ffe4068d1a0) at ../src/backend/tcop/utility.c:1070 [16:14:16.622] parsetree = 0x5628a64d1eb0 [16:14:16.622] isTopLevel = true [16:14:16.622] isAtomicContext = false [16:14:16.622] pstate = 0x5628a664e590 [16:14:16.622] readonly_flags = [16:14:16.622] __func__ = "standard_ProcessUtility" [16:14:16.622] #12 0x0000562886ac70bd in ProcessUtility (pstmt=pstmt@entry=0x5628a64d1f60, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5628a64d2998, qc=0x7ffe4068d1a0) at ../src/backend/tcop/utility.c:523 [16:14:16.622] No locals. [16:14:16.622] #13 0x0000562886ac29e2 in PortalRunUtility (portal=portal@entry=0x5628a6556680, pstmt=pstmt@entry=0x5628a64d1f60, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5628a64d2998, qc=qc@entry=0x7ffe4068d1a0) at ../src/backend/tcop/pquery.c:1184 [16:14:16.622] No locals. [16:14:16.622] #14 0x0000562886ac2fe6 in PortalRunMulti (portal=portal@entry=0x5628a6556680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5628a64d2998, altdest=altdest@entry=0x5628a64d2998, qc=qc@entry=0x7ffe4068d1a0) at ../src/backend/tcop/pquery.c:1348 [16:14:16.622] pstmt = 0x5628a64d1f60 [16:14:16.622] stmtlist_item__state = [16:14:16.622] active_snapshot_set = false [16:14:16.622] stmtlist_item = 0x5628a64d2960 [16:14:16.622] query_index = 0 [16:14:16.622] #15 0x0000562886ac3565 in PortalRun (portal=portal@entry=0x5628a6556680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5628a64d2998, altdest=altdest@entry=0x5628a64d2998, qc=qc@entry=0x7ffe4068d1a0) at ../src/backend/tcop/pquery.c:819 [16:14:16.622] _save_exception_stack = 0x7ffe4068d250 [16:14:16.622] _save_context_stack = 0x0 [16:14:16.622] _local_sigjmp_buf = {{__jmpbuf = {0, 9045463088226100515, 94732589295232, 94732588752680, 94732588752656, 94732588752608, 3326537842625078563, 9045393001974719779}, __mask_was_saved = 0, __saved_mask = {__val = {94732061111460, 1080611119, 4, 94732588752608, 112, 73, 94732589295232, 94732588752680, 94732588752656, 94732588752608, 94732061198663, 73, 2, 73, 94732050389239, 0}}}} [16:14:16.622] _do_rethrow = [16:14:16.622] result = [16:14:16.622] nprocessed = [16:14:16.622] saveTopTransactionResourceOwner = 0x5628a6514448 [16:14:16.622] saveTopTransactionContext = 0x5628a6568ab0 [16:14:16.622] saveActivePortal = 0x0 [16:14:16.622] saveResourceOwner = 0x5628a6514448 [16:14:16.622] savePortalContext = 0x0 [16:14:16.622] saveMemoryContext = 0x5628a6568ab0 [16:14:16.622] __func__ = "PortalRun" [16:14:16.622] #16 0x0000562886abc78b in exec_simple_query (query_string=query_string@entry=0x5628a64d1170 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [16:14:16.622] cmdtaglen = 24 [16:14:16.622] snapshot_set = [16:14:16.622] per_parsetree_context = 0x0 [16:14:16.622] plantree_list = 0x5628a64d2948 [16:14:16.622] parsetree = 0x5628a64d1ee0 [16:14:16.622] commandTag = [16:14:16.622] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:14:16.622] querytree_list = [16:14:16.622] portal = 0x5628a6556680 [16:14:16.622] receiver = 0x5628a64d2998 [16:14:16.622] format = 0 [16:14:16.622] cmdtagname = [16:14:16.622] parsetree_item__state = [16:14:16.622] dest = DestRemote [16:14:16.622] oldcontext = 0x5628a6568ab0 [16:14:16.622] parsetree_list = 0x5628a64d1f10 [16:14:16.622] parsetree_item = 0x5628a64d1f28 [16:14:16.622] save_log_statement_stats = false [16:14:16.622] was_logged = false [16:14:16.622] use_implicit_block = false [16:14:16.622] msec_str = "\004\000\000\000\000\000\000\000\262\016؆(V\000\0000\322h@\376\177\000\000G\000\000\000\000\000\000" [16:14:16.622] __func__ = "exec_simple_query" [16:14:16.622] #17 0x0000562886abf4ed in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4693 [16:14:16.622] query_string = 0x5628a64d1170 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [16:14:16.622] firstchar = [16:14:16.622] input_message = {data = 0x5628a64d1170 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [16:14:16.622] local_sigjmp_buf = {{__jmpbuf = {94732074043416, 9045395619647055139, 140729979032492, 4, 2, 140729979032724, 3326537842692187427, 9045393047868794147}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94732588480512, 17408, 94732074037472, 94732589014000, 2, 94732061111008, 0, 10, 2, 94732074043424, 94732588480512, 94732074037472, 4, 2, 140729979032724}}}} [16:14:16.622] send_ready_for_query = false [16:14:16.622] idle_in_transaction_timeout_enabled = false [16:14:16.622] idle_session_timeout_enabled = false [16:14:16.622] __func__ = "PostgresMain" [16:14:16.622] #18 0x0000562886ab5521 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [16:14:16.622] bsdata = [16:14:16.622] #19 0x00005628869649b8 in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffe4068d3ac, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe4068d400) at ../src/backend/postmaster/launch_backend.c:274 [16:14:16.622] pid = [16:14:16.622] #20 0x0000562886969bb3 in BackendStartup (client_sock=client_sock@entry=0x7ffe4068d400) at ../src/backend/postmaster/postmaster.c:3519 [16:14:16.622] bn = 0x5628a64f9718 [16:14:16.622] pid = [16:14:16.622] startup_data = {canAcceptConnections = CAC_OK} [16:14:16.622] cac = [16:14:16.622] __func__ = "BackendStartup" [16:14:16.622] #21 0x000056288696bc83 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [16:14:16.622] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\336\\=\177\000\000>\004\000\000\000\000\000\000\260\227C[=\177\000\000\240o\226\\=\177\000\000\270\324h@\376\177\000\000\264\324h@\376\177", '\000' , "S<\255\205(V\000\000\240\030\251\205(V\000\000\200\325h@\376\177\000\000x\325h@\376\177\000\000\225[\362\001\204\337\360\372\240\244(\\=\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [16:14:16.622] i = 0 [16:14:16.622] now = [16:14:16.622] last_lockfile_recheck_time = 1740586128 [16:14:16.622] last_touch_time = 1740586128 [16:14:16.622] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 1080612288, user_data = 0x0}, {pos = 15, events = 0, fd = -2052244397, user_data = 0x7f3d5ce18668}, {pos = 1546167856, events = 32573, fd = 1558282976, user_data = 0x7c96e577}, {pos = 1080612352, events = 32766, fd = 1558112840, user_data = 0xf}, {pos = 1546167856, events = 32573, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1558282976, user_data = 0x7ffe4068d578}, {pos = 1080612224, events = 32766, fd = 1558283880, user_data = 0x0}, {pos = -1504891296, events = 22056, fd = 1531899237, user_data = 0x7ffe4068da93}, {pos = 1, events = 0, fd = 1080612224, user_data = 0xffffffff}, {pos = 1531109408, events = 32573, fd = 1553362848, user_data = 0x5628a64feab8}, {pos = -1504712296, events = 22056, fd = -1504712847, user_data = 0x7f3d5cdf4ebe}, {pos = 1, events = 0, fd = 1558282976, user_data = 0x1aa}, {pos = -2026771120, events = 22056, fd = 0, user_data = 0xf9}, {pos = -1504898512, events = 22056, fd = 1558138558, user_data = 0x1}, {pos = 0, events = 0, fd = 1531109408, user_data = 0x7f3d5b4f2e40 }, {pos = 16, events = 0, fd = 1080613312, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f3d5cdf71ba}, {pos = 0, events = 0, fd = 1531637156, user_data = 0x0}, {pos = -2019705696, events = 22056, fd = 2, user_data = 0x0}, {pos = -1505150816, events = 22056, fd = 1952410737, user_data = 0x160}, {pos = -2026771712, events = 22056, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -1504898512, events = 22056, fd = 1558138558, user_data = 0x1}, {pos = 1531670637, events = 32573, fd = 1531143368, user_data = 0x5628a6503b90}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1532959840, events = 32573, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x5628a64938a0}, {pos = 1531673226, events = 32573, 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 = 862285667, fd = 168456003, user_data = 0x35303437310a6174}, {pos = 842085944, events = 808716856, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1532942816, events = 32573, fd = 1531580782, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1504711776, user_data = 0xfaf0df84e0583400}, {pos = 1532945888, events = 32573, fd = -328, user_data = 0x0}, {pos = -1504712616, events = 22056, fd = 1024, user_data = 0x5628a64fe858}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 27108, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1504898512, user_data = 0x7f3d5b4f3053 }, {pos = -1504712616, events = 22056, fd = 1024, user_data = 0x7ffe4068da88}, {pos = -2032457513, events = 22056, fd = -2019604528, user_data = 0x562886da1394 }, {pos = -1504712816, events = 22056, fd = -1504898960, user_data = 0x5628a64fe790}, {pos = 1531664574, events = 32573, fd = 0, user_data = 0x562886db2ffe }, {pos = -1504712816, events = 1, fd = -2032455353, user_data = 0x5628a64d1070}, {pos = -531090432, events = 4210089860, fd = 0, user_data = 0x7f3d5b4a2ab1}, {pos = 1531581680, events = 32573, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1505150816, user_data = 0xfaf0df84e0583400}, {pos = 0, events = 0, fd = -531090432, user_data = 0xc}, {pos = -531090432, events = 4210089860, fd = 0, user_data = 0x7f3d5b45b239 }, {pos = 250, events = 0, fd = -2036971851, user_data = 0x400000}, {pos = 0, events = 0, fd = -1505150816, user_data = 0x562886da1228 }, {pos = -1505065056, events = 22056, fd = -1504898960, user_data = 0x5628a64a87a0}, {pos = 1, events = 0, fd = 0, user_data = 0x562886d5f9f7 }, {pos = 12, events = 0, fd = -1504721480, user_data = 0x5628a64fc598}, {pos = -2019704288, events = 22056, fd = 296, user_data = 0x562886966ecf }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -2036955486, events = 22056, fd = -2023336592, user_data = 0x5628a64d1a48}} [16:14:16.622] nevents = 1 [16:14:16.622] __func__ = "ServerLoop" [16:14:16.622] #22 0x000056288696d4e2 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5628a648f760) at ../src/backend/postmaster/postmaster.c:1386 [16:14:16.622] opt = [16:14:16.622] status = [16:14:16.622] userDoption = [16:14:16.622] listen_addr_saved = false [16:14:16.622] output_config_variable = [16:14:16.622] __func__ = "PostmasterMain" [16:14:16.622] #23 0x000056288679d838 in main (argc=8, argv=0x5628a648f760) at ../src/backend/main/main.c:230 [16:14:16.622] do_check_root = [16:14:16.622] dispatch_option = [16:14:16.655] -e [16:14:16.655] [16:14:16.655] [16:14:16.710] dumping /tmp/cores/postgres-6-31754.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:14:16.953] [New LWP 31754] [16:14:16.953] [16:14:16.953] This GDB supports auto-downloading debuginfo from the following URLs: [16:14:16.953] [16:14:16.953] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [16:14:16.953] Debuginfod has been disabled. [16:14:16.953] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [16:14:17.051] [Thread debugging using libthread_db enabled] [16:14:17.051] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [16:14:17.051] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [16:14:17.051] Program terminated with signal SIGABRT, Aborted. [16:14:17.051] #0 0x00007fca018a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:17.962] [16:14:17.962] Thread 1 (Thread 0x7fca015d4f00 (LWP 31754)): [16:14:17.962] #0 0x00007fca018a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:17.962] No symbol table info available. [16:14:17.962] #1 0x00007fca0185afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:17.962] No symbol table info available. [16:14:17.962] #2 0x00007fca01845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:17.962] No symbol table info available. [16:14:17.962] #3 0x000056198002308d in ExceptionalCondition (conditionName=conditionName@entry=0x5619802a2266 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5619802a1690 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [16:14:17.962] No locals. [16:14:17.962] #4 0x000056197f98230f in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5619b37be0a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:203 [16:14:17.962] estate = 0x5619b3733be0 [16:14:17.962] oldcontext = 0x5619b376ebf0 [16:14:17.962] __func__ = "standard_ExecutorStart" [16:14:17.962] #5 0x000056197f9824ee in ExecutorStart (queryDesc=queryDesc@entry=0x5619b37be0a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:142 [16:14:17.962] plan_valid = [16:14:17.962] #6 0x000056197f8a08b3 in refresh_matview_datafill (dest=0x5619b3771dc0, query=, query@entry=0x5619b36c2720, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [16:14:17.962] rewritten = [16:14:17.962] plan = 0x5619b37bd6f8 [16:14:17.962] queryDesc = 0x5619b37be0a0 [16:14:17.962] copied_query = [16:14:17.962] processed = [16:14:17.962] __func__ = "refresh_matview_datafill" [16:14:17.962] #7 0x000056197f8a2c52 in RefreshMatViewByOid (matviewOid=28761, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [16:14:17.962] dest = [16:14:17.962] matviewRel = 0x7fc9f5f97c90 [16:14:17.962] rule = [16:14:17.962] actions = [16:14:17.962] dataQuery = 0x5619b36c2720 [16:14:17.962] tableSpace = [16:14:17.962] relowner = 10 [16:14:17.962] OIDNewHeap = 28787 [16:14:17.962] processed = 0 [16:14:17.962] relpersistence = 112 'p' [16:14:17.962] save_userid = 10 [16:14:17.962] save_sec_context = 0 [16:14:17.962] save_nestlevel = 2 [16:14:17.962] address = {classId = 0, objectId = 0, objectSubId = 0} [16:14:17.962] __func__ = "RefreshMatViewByOid" [16:14:17.962] #8 0x000056197f8a2d91 in ExecRefreshMatView (stmt=0x5619b3771a98, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [16:14:17.962] matviewOid = [16:14:17.962] lockmode = [16:14:17.962] #9 0x000056197f85844a in ExecCreateTableAs (pstate=pstate@entry=0x5619b376ecf0, stmt=stmt@entry=0x5619b359a230, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd13c6a190) at ../src/backend/commands/createas.c:351 [16:14:17.962] refresh = [16:14:17.962] query = 0x5619b359a3f0 [16:14:17.962] into = 0x5619b3599f88 [16:14:17.962] jstate = 0x0 [16:14:17.962] is_matview = true [16:14:17.962] do_refresh = false [16:14:17.962] dest = [16:14:17.962] address = {classId = 1259, objectId = 28761, objectSubId = 0} [16:14:17.962] __func__ = "ExecCreateTableAs" [16:14:17.962] #10 0x000056197fd90967 in ProcessUtilitySlow (pstate=pstate@entry=0x5619b376ecf0, pstmt=pstmt@entry=0x5619b359a2e0, queryString=queryString@entry=0x5619b35994f0 "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=0x5619b359ad18, qc=0x7ffd13c6a190) at ../src/backend/tcop/utility.c:1678 [16:14:17.962] _save_exception_stack = 0x7ffd13c6a070 [16:14:17.962] _save_context_stack = 0x0 [16:14:17.962] _local_sigjmp_buf = {{__jmpbuf = {0, 5126920396058492396, 94668383167024, 0, 94668383163632, 0, 1508490172168502764, 5127317309447175660}, __mask_was_saved = 0, __saved_mask = {__val = {28777, 0, 94667522390806, 140505583013304, 94668383163632, 94667524767763, 94667535001218, 94667535001344, 140724935237268, 94667524963193, 94667535001233, 94667535001344, 140724935237300, 94667524963208, 94667535001344, 0}}}} [16:14:17.962] _do_rethrow = false [16:14:17.962] parsetree = 0x5619b359a230 [16:14:17.962] isTopLevel = true [16:14:17.962] isCompleteQuery = true [16:14:17.962] needCleanup = false [16:14:17.962] commandCollected = false [16:14:17.962] address = {classId = 22041, objectId = 3008995888, objectSubId = 22041} [16:14:17.962] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [16:14:17.962] __func__ = "ProcessUtilitySlow" [16:14:17.962] #11 0x000056197fd8ef62 in standard_ProcessUtility (pstmt=0x5619b359a2e0, queryString=0x5619b35994f0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5619b359ad18, qc=0x7ffd13c6a190) at ../src/backend/tcop/utility.c:1070 [16:14:17.962] parsetree = 0x5619b359a230 [16:14:17.962] isTopLevel = true [16:14:17.962] isAtomicContext = false [16:14:17.962] pstate = 0x5619b376ecf0 [16:14:17.962] readonly_flags = [16:14:17.962] __func__ = "standard_ProcessUtility" [16:14:17.962] #12 0x000056197fd8f0bd in ProcessUtility (pstmt=pstmt@entry=0x5619b359a2e0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5619b359ad18, qc=0x7ffd13c6a190) at ../src/backend/tcop/utility.c:523 [16:14:17.962] No locals. [16:14:17.962] #13 0x000056197fd8a9e2 in PortalRunUtility (portal=portal@entry=0x5619b361e480, pstmt=pstmt@entry=0x5619b359a2e0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5619b359ad18, qc=qc@entry=0x7ffd13c6a190) at ../src/backend/tcop/pquery.c:1184 [16:14:17.962] No locals. [16:14:17.962] #14 0x000056197fd8afe6 in PortalRunMulti (portal=portal@entry=0x5619b361e480, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5619b359ad18, altdest=altdest@entry=0x5619b359ad18, qc=qc@entry=0x7ffd13c6a190) at ../src/backend/tcop/pquery.c:1348 [16:14:17.962] pstmt = 0x5619b359a2e0 [16:14:17.962] stmtlist_item__state = [16:14:17.962] active_snapshot_set = false [16:14:17.962] stmtlist_item = 0x5619b359ace0 [16:14:17.962] query_index = 0 [16:14:17.962] #15 0x000056197fd8b565 in PortalRun (portal=portal@entry=0x5619b361e480, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5619b359ad18, altdest=altdest@entry=0x5619b359ad18, qc=qc@entry=0x7ffd13c6a190) at ../src/backend/tcop/pquery.c:819 [16:14:17.962] _save_exception_stack = 0x7ffd13c6a240 [16:14:17.962] _save_context_stack = 0x0 [16:14:17.962] _local_sigjmp_buf = {{__jmpbuf = {0, 5126920396367822316, 94668383708288, 94668383167144, 94668383167120, 94668383167072, 1508490172298526188, 5127317311760072172}, __mask_was_saved = 0, __saved_mask = {__val = {94667522077860, 331784479, 4, 94668383167072, 112, 73, 94668383708288, 94668383167144, 94668383167120, 94668383167072, 94667522165063, 73, 2, 73, 94667511355639, 0}}}} [16:14:17.962] _do_rethrow = [16:14:17.962] result = [16:14:17.962] nprocessed = [16:14:17.962] saveTopTransactionResourceOwner = 0x5619b35daf38 [16:14:17.962] saveTopTransactionContext = 0x5619b36304a0 [16:14:17.962] saveActivePortal = 0x0 [16:14:17.962] saveResourceOwner = 0x5619b35daf38 [16:14:17.962] savePortalContext = 0x0 [16:14:17.962] saveMemoryContext = 0x5619b36304a0 [16:14:17.962] __func__ = "PortalRun" [16:14:17.962] #16 0x000056197fd8478b in exec_simple_query (query_string=query_string@entry=0x5619b35994f0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [16:14:17.962] cmdtaglen = 24 [16:14:17.962] snapshot_set = [16:14:17.962] per_parsetree_context = 0x0 [16:14:17.962] plantree_list = 0x5619b359acc8 [16:14:17.962] parsetree = 0x5619b359a260 [16:14:17.962] commandTag = [16:14:17.962] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:14:17.962] querytree_list = [16:14:17.962] portal = 0x5619b361e480 [16:14:17.962] receiver = 0x5619b359ad18 [16:14:17.962] format = 0 [16:14:17.962] cmdtagname = [16:14:17.962] parsetree_item__state = [16:14:17.962] dest = DestRemote [16:14:17.962] oldcontext = 0x5619b36304a0 [16:14:17.962] parsetree_list = 0x5619b359a290 [16:14:17.962] parsetree_item = 0x5619b359a2a8 [16:14:17.962] save_log_statement_stats = false [16:14:17.962] was_logged = true [16:14:17.962] use_implicit_block = false [16:14:17.962] msec_str = "\004\000\000\000\000\000\000\000\262\216\004\200\031V\000\000 \242\306\023\375\177\000\000G\000\000\000\000\000\000" [16:14:17.962] __func__ = "exec_simple_query" [16:14:17.962] #17 0x000056197fd874ed in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4693 [16:14:17.962] query_string = 0x5619b35994f0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [16:14:17.962] firstchar = [16:14:17.962] input_message = {data = 0x5619b35994f0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [16:14:17.962] local_sigjmp_buf = {{__jmpbuf = {94667535009816, 5126817983846776300, 140724935238556, 4, 13, 140724935238788, 1508490172365635052, 5127317305057574380}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94668382894160, 16128, 94667535003872, 94668383428336, 13, 94667522077408, 0, 9, 2, 94667535009824, 94668382894160, 94667535003872, 4, 13, 140724935238788}}}} [16:14:17.962] send_ready_for_query = false [16:14:17.962] idle_in_transaction_timeout_enabled = false [16:14:17.962] idle_session_timeout_enabled = false [16:14:17.962] __func__ = "PostgresMain" [16:14:17.962] #18 0x000056197fd7d521 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [16:14:17.962] bsdata = [16:14:17.962] #19 0x000056197fc2c9b8 in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x7ffd13c6a39c, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd13c6a3f0) at ../src/backend/postmaster/launch_backend.c:274 [16:14:17.962] pid = [16:14:17.962] #20 0x000056197fc31bb3 in BackendStartup (client_sock=client_sock@entry=0x7ffd13c6a3f0) at ../src/backend/postmaster/postmaster.c:3519 [16:14:17.962] bn = 0x5619b35c1c28 [16:14:17.962] pid = [16:14:17.962] startup_data = {canAcceptConnections = CAC_OK} [16:14:17.962] cac = [16:14:17.962] __func__ = "BackendStartup" [16:14:17.962] #21 0x000056197fc33c83 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [16:14:17.962] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "S\274\331~\031V\000\000\240\230\325~\031V\000\000@\245\306\023\375\177\000\0008\245\306\023\375\177\000\000\225[\362\001\000\000\000\000\240\224h\002\312\177\000\000+", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\246\n\003\312\177\000\0000\226h\002\312\177\000\000\340\242\n\003\312\177\000\000\316)fR\000\000\000", __ss_align = 331785600}, salen = 2}} [16:14:17.962] i = 0 [16:14:17.962] now = [16:14:17.962] last_lockfile_recheck_time = 1740586130 [16:14:17.962] last_touch_time = 1740586130 [16:14:17.962] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 51028704, user_data = 0x0}, {pos = 331785664, events = 32765, fd = 50858568, user_data = 0xf}, {pos = 40408624, events = 32714, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 51028704, user_data = 0x7ffd13c6a538}, {pos = 331785536, events = 32765, fd = 51029608, user_data = 0x0}, {pos = -1285974776, events = 22041, fd = 25918090, user_data = 0x5619b3599508}, {pos = 1, events = 22041, fd = 32768, user_data = 0xffffffff}, {pos = 25354272, events = 32714, fd = 47419296, user_data = 0x5619b35c69f8}, {pos = -1285789480, events = 22041, fd = -1285790031, user_data = 0x7fca03086ebe}, {pos = 1, events = 0, fd = 51028704, user_data = 0x1aa}, {pos = -2141295280, events = 22041, fd = 0, user_data = 0xe5}, {pos = -1285974776, events = 22041, fd = 50884286, user_data = 0x1}, {pos = 0, events = 0, fd = 25354272, user_data = 0x7fca018f2e40 }, {pos = 16, events = 0, fd = 331786672, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fca030891ba}, {pos = 0, events = 0, fd = 25882020, user_data = 0x0}, {pos = -2134229856, events = 22041, fd = 2, user_data = 0x0}, {pos = -1286227728, events = 22041, fd = 2144428460, user_data = 0x5619b35cbe90}, {pos = 2144432449, events = 22041, fd = -1285767445, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 25388232, user_data = 0x7fca0189c880 }, {pos = 22891960, events = 32714, fd = 331786864, user_data = 0x100007f00000002}, {pos = 25915501, events = 32714, fd = 2, user_data = 0x5619b35cbe90}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 27204704, events = 32714, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 22016, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1285784320, events = 22041, fd = 1080, user_data = 0x5619b35c66d0}, {pos = -2147062813, events = 22041, fd = 1024, user_data = 0x7fca018b58be}, {pos = 27187680, events = 32714, fd = 25825646, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1285788960, user_data = 0x135280c80bf9d400}, {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 = 0x5619b35c66d0}, {pos = 1, events = 0, fd = -1285789800, user_data = 0x3}, {pos = 0, events = 0, fd = 27804, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1285974776, user_data = 0x7fca018f3053 }, {pos = -1285789800, events = 22041, fd = 1024, user_data = 0x7ffd13c6aa78}, {pos = -2146981673, events = 22041, fd = -2134128688, user_data = 0x561980069394 }, {pos = -1285790000, events = 22041, fd = -1285975056, user_data = 0x5619b35c66d0}, {pos = 25909438, events = 32714, fd = 0, user_data = 0x56198007affe }, {pos = -1285790000, events = 1, fd = -2146979513, user_data = 0x5619b35993f0}, {pos = 200922112, events = 324174024, fd = 0, user_data = 0x7fca018a2ab1}, {pos = 25826544, events = 32714, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1286227728, user_data = 0x135280c80bf9d400}, {pos = 0, events = 0, fd = 200922112, user_data = 0xc}, {pos = 200922112, events = 324174024, fd = 0, user_data = 0x7fca0185b239 }, {pos = 230, events = 0, fd = 2143471285, user_data = 0x400000}, {pos = 0, events = 0, fd = -1286227728, user_data = 0x561980069228 }, {pos = -1286141152, events = 22041, fd = -1285975056, user_data = 0x5619b3570b20}, {pos = 1, events = 0, fd = 0, user_data = 0x5619800279f7 }, {pos = 12, events = 0, fd = -1285798664, user_data = 0x5619b35c44d8}, {pos = -2134228448, events = 22041, fd = 296, user_data = 0x56197fc2eecf }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 2143487650, events = 22041, fd = -2137860752, user_data = 0x5619b3599d98}} [16:14:17.963] nevents = 1 [16:14:17.963] __func__ = "ServerLoop" [16:14:17.963] #22 0x000056197fc354e2 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5619b3557760) at ../src/backend/postmaster/postmaster.c:1386 [16:14:17.963] opt = [16:14:17.963] status = [16:14:17.963] userDoption = [16:14:17.963] listen_addr_saved = false [16:14:17.963] output_config_variable = [16:14:17.963] __func__ = "PostmasterMain" [16:14:17.963] #23 0x000056197fa65838 in main (argc=4, argv=0x5619b3557760) at ../src/backend/main/main.c:230 [16:14:17.963] do_check_root = [16:14:17.963] dispatch_option = [16:14:17.998] -e [16:14:17.998] [16:14:17.998] [16:14:18.055] dumping /tmp/cores/postgres-6-38914.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:14:18.306] [New LWP 38914] [16:14:18.306] [16:14:18.306] This GDB supports auto-downloading debuginfo from the following URLs: [16:14:18.306] [16:14:18.306] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [16:14:18.306] Debuginfod has been disabled. [16:14:18.306] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [16:14:18.404] [Thread debugging using libthread_db enabled] [16:14:18.404] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [16:14:18.404] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [16:14:18.404] Program terminated with signal SIGABRT, Aborted. [16:14:18.404] #0 0x00007f61d6aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:19.349] [16:14:19.349] Thread 1 (Thread 0x7f61d7886f00 (LWP 38914)): [16:14:19.349] #0 0x00007f61d6aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:19.349] No symbol table info available. [16:14:19.349] #1 0x00007f61d6a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:19.349] No symbol table info available. [16:14:19.349] #2 0x00007f61d6a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [16:14:19.349] No symbol table info available. [16:14:19.349] #3 0x000055ccd4de608d in ExceptionalCondition (conditionName=conditionName@entry=0x55ccd5065266 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55ccd5064690 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [16:14:19.349] No locals. [16:14:19.349] #4 0x000055ccd474530f in standard_ExecutorStart (queryDesc=0x55ccdafb9e20, eflags=0) at ../src/backend/executor/execMain.c:203 [16:14:19.349] estate = 0x55ccdaec9250 [16:14:19.349] oldcontext = 0x55ccdaf21750 [16:14:19.349] __func__ = "standard_ExecutorStart" [16:14:19.349] #5 0x00007f61d40ce6fd in pgss_ExecutorStart (queryDesc=0x55ccdafb9e20, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:998 [16:14:19.349] plan_valid = [16:14:19.349] #6 0x000055ccd47454a7 in ExecutorStart (queryDesc=queryDesc@entry=0x55ccdafb9e20, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:140 [16:14:19.349] plan_valid = [16:14:19.349] #7 0x000055ccd46638b3 in refresh_matview_datafill (dest=0x55ccdaf34d40, query=, query@entry=0x55ccdaf8fa80, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [16:14:19.349] rewritten = [16:14:19.349] plan = 0x55ccdafb9448 [16:14:19.349] queryDesc = 0x55ccdafb9e20 [16:14:19.349] copied_query = [16:14:19.349] processed = [16:14:19.349] __func__ = "refresh_matview_datafill" [16:14:19.349] #8 0x000055ccd4665c52 in RefreshMatViewByOid (matviewOid=28633, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [16:14:19.349] dest = [16:14:19.349] matviewRel = 0x7f61d2363d20 [16:14:19.349] rule = [16:14:19.349] actions = [16:14:19.349] dataQuery = 0x55ccdaf8fa80 [16:14:19.349] tableSpace = [16:14:19.349] relowner = 10 [16:14:19.349] OIDNewHeap = 28644 [16:14:19.349] processed = 0 [16:14:19.349] relpersistence = 112 'p' [16:14:19.349] save_userid = 10 [16:14:19.349] save_sec_context = 0 [16:14:19.349] save_nestlevel = 2 [16:14:19.349] address = {classId = 0, objectId = 0, objectSubId = 0} [16:14:19.349] __func__ = "RefreshMatViewByOid" [16:14:19.349] #9 0x000055ccd4665d91 in ExecRefreshMatView (stmt=0x55ccdaf34a18, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [16:14:19.349] matviewOid = [16:14:19.349] lockmode = [16:14:19.349] #10 0x000055ccd461b44a in ExecCreateTableAs (pstate=pstate@entry=0x55ccdaf21850, stmt=stmt@entry=0x55ccdaddc250, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc02919de0) at ../src/backend/commands/createas.c:351 [16:14:19.349] refresh = [16:14:19.349] query = 0x55ccdaddc410 [16:14:19.349] into = 0x55ccdaddbfa8 [16:14:19.349] jstate = 0x0 [16:14:19.349] is_matview = true [16:14:19.349] do_refresh = false [16:14:19.349] dest = [16:14:19.349] address = {classId = 1259, objectId = 28633, objectSubId = 0} [16:14:19.349] __func__ = "ExecCreateTableAs" [16:14:19.349] #11 0x000055ccd4b53967 in ProcessUtilitySlow (pstate=pstate@entry=0x55ccdaf21850, pstmt=pstmt@entry=0x55ccdaddc300, queryString=queryString@entry=0x55ccdaddb510 "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=0x55ccdaddd2a8, qc=0x7ffc02919de0) at ../src/backend/tcop/utility.c:1678 [16:14:19.349] _save_exception_stack = 0x7ffc029199b0 [16:14:19.349] _save_context_stack = 0x0 [16:14:19.349] _local_sigjmp_buf = {{__jmpbuf = {0, 1809994634151300937, 94338333655632, 0, 94338333652240, 0, 5584415292608712521, 1810016412769029961}, __mask_was_saved = 0, __saved_mask = {__val = {11102307609396555763, 3672368693164710999, 94338229757341, 0, 5412384741217271808, 94338235930272, 94338230010235, 140058118158720, 1, 16777216, 0, 140058118158720, 140720351582688, 0, 94338233624432, 140720351581884}}}} [16:14:19.349] _do_rethrow = false [16:14:19.349] parsetree = 0x55ccdaddc250 [16:14:19.349] isTopLevel = true [16:14:19.349] isCompleteQuery = true [16:14:19.349] needCleanup = false [16:14:19.349] commandCollected = false [16:14:19.349] address = {classId = 21964, objectId = 3671966288, objectSubId = 21964} [16:14:19.349] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [16:14:19.349] __func__ = "ProcessUtilitySlow" [16:14:19.349] #12 0x000055ccd4b51f62 in standard_ProcessUtility (pstmt=pstmt@entry=0x55ccdaddc300, queryString=queryString@entry=0x55ccdaddb510 "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=0x55ccdaddd2a8, qc=0x7ffc02919de0) at ../src/backend/tcop/utility.c:1070 [16:14:19.349] parsetree = 0x55ccdaddc250 [16:14:19.349] isTopLevel = true [16:14:19.349] isAtomicContext = false [16:14:19.349] pstate = 0x55ccdaf21850 [16:14:19.349] readonly_flags = [16:14:19.349] __func__ = "standard_ProcessUtility" [16:14:19.349] #13 0x00007f61d40d1deb in pgss_ProcessUtility (pstmt=0x55ccdaddc300, queryString=0x55ccdaddb510 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55ccdaddd2a8, qc=0x7ffc02919de0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1179 [16:14:19.349] _save_exception_stack = 0x7ffc02919cc0 [16:14:19.349] _save_context_stack = 0x0 [16:14:19.349] _local_sigjmp_buf = {{__jmpbuf = {0, -5582263156736815287, 94338333655808, 94338333659816, 140720351583712, 0, 5584415293040725833, 5495650649706041161}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140720351582944, 94338233632131, 1, 206158430232, 94338333656608, 140720351583040, 0, 94338228379545, 94338333651984, 94338233291568, 3, 94338227083730, 94338333655808}}}} [16:14:19.349] _do_rethrow = false [16:14:19.349] duration = [16:14:19.349] bufusage = {shared_blks_hit = 1, shared_blks_read = 113, shared_blks_dirtied = 140058118158720, shared_blks_written = 140058118158720, local_blks_hit = 1, local_blks_read = 94338229758739, local_blks_dirtied = 94338334629688, local_blks_written = 94338233625366, temp_blks_read = 140058204597688, temp_blks_written = 94338333652240, shared_blk_read_time = {ticks = 94338236002323}, shared_blk_write_time = {ticks = 94338246235778}, local_blk_read_time = {ticks = 94338246235904}, local_blk_write_time = {ticks = 140720351582948}, temp_blk_read_time = {ticks = 94338236197753}, temp_blk_write_time = {ticks = 94338246235793}} [16:14:19.349] walusage_start = {wal_records = 8961, wal_fpi = 91, wal_bytes = 1059468, wal_buffers_full = 25} [16:14:19.349] start = [16:14:19.349] rows = [16:14:19.349] bufusage_start = {shared_blks_hit = 34397, shared_blks_read = 4181, shared_blks_dirtied = 1512, shared_blks_written = 1113, 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}} [16:14:19.349] walusage = {wal_records = 140058121263744, wal_fpi = 485331304448, wal_bytes = 140058118158756, wal_buffers_full = 94338232779354} [16:14:19.349] parsetree = [16:14:19.349] saved_queryId = 7566811930394970136 [16:14:19.349] saved_stmt_location = 0 [16:14:19.349] saved_stmt_len = 69 [16:14:19.349] enabled = true [16:14:19.349] #14 0x000055ccd4b52008 in ProcessUtility (pstmt=pstmt@entry=0x55ccdaddc300, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55ccdaddd2a8, qc=0x7ffc02919de0) at ../src/backend/tcop/utility.c:519 [16:14:19.349] No locals. [16:14:19.349] #15 0x000055ccd4b4d9e2 in PortalRunUtility (portal=portal@entry=0x55ccdae5e400, pstmt=pstmt@entry=0x55ccdaddc300, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55ccdaddd2a8, qc=qc@entry=0x7ffc02919de0) at ../src/backend/tcop/pquery.c:1184 [16:14:19.349] No locals. [16:14:19.349] #16 0x000055ccd4b4dfe6 in PortalRunMulti (portal=portal@entry=0x55ccdae5e400, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55ccdaddd2a8, altdest=altdest@entry=0x55ccdaddd2a8, qc=qc@entry=0x7ffc02919de0) at ../src/backend/tcop/pquery.c:1348 [16:14:19.349] pstmt = 0x55ccdaddc300 [16:14:19.349] stmtlist_item__state = [16:14:19.349] active_snapshot_set = false [16:14:19.349] stmtlist_item = 0x55ccdaddd270 [16:14:19.349] query_index = 0 [16:14:19.349] #17 0x000055ccd4b4e565 in PortalRun (portal=portal@entry=0x55ccdae5e400, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55ccdaddd2a8, altdest=altdest@entry=0x55ccdaddd2a8, qc=qc@entry=0x7ffc02919de0) at ../src/backend/tcop/pquery.c:819 [16:14:19.349] _save_exception_stack = 0x7ffc02919e90 [16:14:19.349] _save_context_stack = 0x0 [16:14:19.349] _local_sigjmp_buf = {{__jmpbuf = {0, 1809994633625964361, 94338334188544, 94338333655752, 94338333655728, 94338333655680, 5584415292896022345, 1810016410523242313}, __mask_was_saved = 0, __saved_mask = {__val = {94338233312420, 43097455, 4, 94338333655680, 112, 73, 94338334188544, 94338333655752, 94338333655728, 94338333655680, 94338233399623, 73, 2, 73, 94338222590199, 0}}}} [16:14:19.349] _do_rethrow = [16:14:19.349] result = [16:14:19.349] nprocessed = [16:14:19.349] saveTopTransactionResourceOwner = 0x55ccdae1fe08 [16:14:19.349] saveTopTransactionContext = 0x55ccdae70c40 [16:14:19.349] saveActivePortal = 0x0 [16:14:19.349] saveResourceOwner = 0x55ccdae1fe08 [16:14:19.349] savePortalContext = 0x0 [16:14:19.349] saveMemoryContext = 0x55ccdae70c40 [16:14:19.349] __func__ = "PortalRun" [16:14:19.349] #18 0x000055ccd4b4778b in exec_simple_query (query_string=query_string@entry=0x55ccdaddb510 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [16:14:19.349] cmdtaglen = 24 [16:14:19.349] snapshot_set = [16:14:19.349] per_parsetree_context = 0x0 [16:14:19.349] plantree_list = 0x55ccdaddd258 [16:14:19.349] parsetree = 0x55ccdaddc280 [16:14:19.349] commandTag = [16:14:19.349] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:14:19.349] querytree_list = [16:14:19.349] portal = 0x55ccdae5e400 [16:14:19.349] receiver = 0x55ccdaddd2a8 [16:14:19.349] format = 0 [16:14:19.349] cmdtagname = [16:14:19.349] parsetree_item__state = [16:14:19.349] dest = DestRemote [16:14:19.349] oldcontext = 0x55ccdae70c40 [16:14:19.349] parsetree_list = 0x55ccdaddc2b0 [16:14:19.349] parsetree_item = 0x55ccdaddc2c8 [16:14:19.349] save_log_statement_stats = false [16:14:19.349] was_logged = true [16:14:19.349] use_implicit_block = false [16:14:19.349] msec_str = "\004\000\000\000\000\000\000\000\262\276\340\324\314U\000\000p\236\221\002\374\177\000\000G\000\000\000\000\000\000" [16:14:19.349] __func__ = "exec_simple_query" [16:14:19.349] #19 0x000055ccd4b4a4ed in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4693 [16:14:19.349] query_string = 0x55ccdaddb510 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [16:14:19.349] firstchar = [16:14:19.349] input_message = {data = 0x55ccdaddb510 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [16:14:19.349] local_sigjmp_buf = {{__jmpbuf = {94338246244376, 1810018738275323721, 140720351584236, 4, 17, 140720351584468, 5584415292963131209, 1810016407025192777}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94338333908400, 0, 168, 94338233312522, 0, 10, 2, 94338246244384, 94338333382800, 94338246238432, 4, 17, 140720351584468}}}} [16:14:19.349] send_ready_for_query = false [16:14:19.349] idle_in_transaction_timeout_enabled = false [16:14:19.349] idle_session_timeout_enabled = false [16:14:19.349] __func__ = "PostgresMain" [16:14:19.349] #20 0x000055ccd4b40521 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [16:14:19.349] bsdata = [16:14:19.349] #21 0x000055ccd49ef9b8 in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7ffc02919fec, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc0291a040) at ../src/backend/postmaster/launch_backend.c:274 [16:14:19.349] pid = [16:14:19.349] #22 0x000055ccd49f4bb3 in BackendStartup (client_sock=client_sock@entry=0x7ffc0291a040) at ../src/backend/postmaster/postmaster.c:3519 [16:14:19.349] bn = 0x55ccdae06f68 [16:14:19.349] pid = [16:14:19.349] startup_data = {canAcceptConnections = CAC_OK} [16:14:19.349] cac = [16:14:19.349] __func__ = "BackendStartup" [16:14:19.349] #23 0x000055ccd49f6c83 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [16:14:19.349] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "+\330a\177\000\000>\004\000\000\000\000\000\000\260\227\243\326a\177\000\000\240\317\363\327a\177\000\000\370\240\221\002\374\177\000\000\364\240\221\002\374\177", '\000' , "S\354\265\323\314U\000\000\240ȱ\323\314U\000\000\300\241\221\002\374\177\000\000\270\241\221\002\374\177\000\000\225[\362\001\270\v\363'pa\340\332\314U\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [16:14:19.349] i = 0 [16:14:19.349] now = [16:14:19.349] last_lockfile_recheck_time = 1740586166 [16:14:19.349] last_touch_time = 1740586166 [16:14:19.349] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 43098624, user_data = 0x0}, {pos = 15, events = 0, fd = -743052205, user_data = 0x7f61d82e6668}, {pos = -671951312, events = 32609, fd = -668048672, user_data = 0x7c96e577}, {pos = 43098688, events = 32764, fd = -668218808, user_data = 0xf}, {pos = -671951312, events = 32609, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -668048672, user_data = 0x7ffc0291a1b8}, {pos = 43098560, events = 32764, fd = -668047768, user_data = 0x0}, {pos = -623001552, events = 21964, fd = -693179035, user_data = 0x7ffc0291a6d3}, {pos = 1, events = 0, fd = 43098560, user_data = 0xffffffff}, {pos = -693968864, events = 32609, fd = -671887456, user_data = 0x55ccdae11308}, {pos = -622784024, events = 21964, fd = -622807343, user_data = 0x7f61d82c2ebe}, {pos = 1, events = 0, fd = -668048672, user_data = 0x1aa}, {pos = -717578928, events = 21964, fd = 0, user_data = 0x56}, {pos = -622818184, events = 21964, fd = -668193090, user_data = 0x1}, {pos = 0, events = 0, fd = -693968864, user_data = 0x7f61d6af2e40 }, {pos = 16, events = 0, fd = 43099648, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f61d82c51ba}, {pos = 0, events = 0, fd = -693441116, user_data = 0x0}, {pos = -710513504, events = 21964, fd = 2, user_data = 0x0}, {pos = -623257296, events = 21964, fd = 1952410737, user_data = 0x160}, {pos = -717579520, events = 21964, fd = 4, user_data = 0x2ffff00001fa0}, {pos = -622818184, events = 21964, fd = -668193090, user_data = 0x1}, {pos = -693407993, events = 32609, fd = -693934904, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -692118432, events = 32609, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55ccdad9d930}, {pos = -693405046, events = 32609, fd = 0, user_data = 0x0}, {pos = -65536, events = 4294967295, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f61d7f2e540}, {pos = -671946112, events = 32609, 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 = -692135456, events = 32609, fd = -693497490, user_data = 0x100000400}, {pos = 7, events = 0, fd = -622788656, user_data = 0x27f30bb82b25f500}, {pos = -692132384, events = 32609, fd = -328, user_data = 0x0}, {pos = -622784344, events = 21964, fd = 1024, user_data = 0x55ccdae110a8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 34675, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -622818184, user_data = 0x7f61d6af3053 }, {pos = -622784344, events = 21964, fd = 1024, user_data = 0x7ffc0291a6c8}, {pos = -723265321, events = 21964, fd = -710412336, user_data = 0x55ccd4e2c394 }, {pos = -622784544, events = 21964, fd = -623004656, user_data = 0x55ccdae10fe0}, {pos = -693414037, events = 32609, fd = 0, user_data = 0x55ccd4e3dffe }, {pos = -622784544, events = 1, fd = -723263161, user_data = 0x55ccdaddb410}, {pos = 723907840, events = 670239672, fd = 0, user_data = 0x7f61d6aa2ab1}, {pos = -693496592, events = 32609, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -623257296, user_data = 0x27f30bb82b25f500}, {pos = 0, events = 0, fd = 723907840, user_data = 0xc}, {pos = 723907840, events = 670239672, fd = 0, user_data = 0x7f61d6a5b239 }, {pos = 87, events = 0, fd = -727779659, user_data = 0x400000}, {pos = 0, events = 0, fd = -623257296, user_data = 0x55ccd4e2c228 }, {pos = -623170752, events = 21964, fd = -623004656, user_data = 0x55ccdadb2b40}, {pos = 1, events = 0, fd = 0, user_data = 0x55ccd4dea9f7 }, {pos = 12, events = 0, fd = -622822232, user_data = 0x55ccdae07c88}, {pos = -710512096, events = 21964, fd = 296, user_data = 0x55ccd49f1ecf }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -727763294, events = 21964, fd = -714144400, user_data = 0x55ccdaddbdc8}} [16:14:19.350] nevents = 1 [16:14:19.350] __func__ = "ServerLoop" [16:14:19.350] #24 0x000055ccd49f84e2 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55ccdad99790) at ../src/backend/postmaster/postmaster.c:1386 [16:14:19.350] opt = [16:14:19.350] status = [16:14:19.350] userDoption = [16:14:19.350] listen_addr_saved = false [16:14:19.350] output_config_variable = [16:14:19.350] __func__ = "PostmasterMain" [16:14:19.350] #25 0x000055ccd4828838 in main (argc=4, argv=0x55ccdad99790) at ../src/backend/main/main.c:230 [16:14:19.350] do_check_root = [16:14:19.350] dispatch_option =