[03:49:58.668] src/tools/ci/cores_backtrace.sh linux /tmp/cores [03:49:58.870] dumping /tmp/cores/postgres-6-29067.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:49:59.102] [New LWP 29067] [03:49:59.102] [03:49:59.102] This GDB supports auto-downloading debuginfo from the following URLs: [03:49:59.102] [03:49:59.102] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:49:59.102] Debuginfod has been disabled. [03:49:59.102] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:49:59.216] [Thread debugging using libthread_db enabled] [03:49:59.216] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:49:59.216] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:49:59.216] Program terminated with signal SIGABRT, Aborted. [03:49:59.216] #0 0x00007f219e0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:00.037] [03:50:00.037] Thread 1 (Thread 0x7f219dfd8f00 (LWP 29067)): [03:50:00.037] #0 0x00007f219e0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:00.037] No symbol table info available. [03:50:00.037] #1 0x00007f219e05afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:00.037] No symbol table info available. [03:50:00.037] #2 0x00007f219e045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:00.037] No symbol table info available. [03:50:00.037] #3 0x0000563108347ce5 in ExceptionalCondition (conditionName=conditionName@entry=0x5631085bc0b5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5631085bb5d0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:50:00.037] No locals. [03:50:00.037] #4 0x0000563107ccb19d in standard_ExecutorStart (queryDesc=queryDesc@entry=0x56311e3c5070, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [03:50:00.037] estate = 0x56311e33fe30 [03:50:00.037] oldcontext = 0x56311e4161e0 [03:50:00.037] __func__ = "standard_ExecutorStart" [03:50:00.037] #5 0x0000563107ccb379 in ExecutorStart (queryDesc=queryDesc@entry=0x56311e3c5070, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [03:50:00.037] No locals. [03:50:00.037] #6 0x0000563107bf1bb4 in refresh_matview_datafill (dest=0x56311e41a608, query=, query@entry=0x56311e3df530, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:50:00.037] rewritten = [03:50:00.037] plan = 0x56311e3c45a8 [03:50:00.037] queryDesc = 0x56311e3c5070 [03:50:00.037] copied_query = [03:50:00.037] processed = [03:50:00.037] __func__ = "refresh_matview_datafill" [03:50:00.037] #7 0x0000563107bf3f1b in RefreshMatViewByOid (matviewOid=27442, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:50:00.037] dest = [03:50:00.037] matviewRel = 0x7f21926a5d18 [03:50:00.037] rule = [03:50:00.037] actions = [03:50:00.037] dataQuery = 0x56311e3df530 [03:50:00.037] tableSpace = [03:50:00.037] relowner = 10 [03:50:00.037] OIDNewHeap = 27451 [03:50:00.037] processed = 0 [03:50:00.037] relpersistence = 112 'p' [03:50:00.037] save_userid = 10 [03:50:00.037] save_sec_context = 0 [03:50:00.037] save_nestlevel = 2 [03:50:00.037] address = {classId = 0, objectId = 0, objectSubId = 0} [03:50:00.037] __func__ = "RefreshMatViewByOid" [03:50:00.037] #8 0x0000563107bf405a in ExecRefreshMatView (stmt=0x56311e3ab090, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:50:00.037] matviewOid = [03:50:00.037] lockmode = [03:50:00.037] #9 0x0000563107ba9ca7 in ExecCreateTableAs (pstate=pstate@entry=0x56311e4162e0, stmt=stmt@entry=0x56311e26b7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe74a014b0) at ../src/backend/commands/createas.c:351 [03:50:00.037] refresh = [03:50:00.037] query = 0x56311e26b9b0 [03:50:00.037] into = 0x56311e26b548 [03:50:00.037] jstate = 0x0 [03:50:00.037] is_matview = true [03:50:00.037] do_refresh = false [03:50:00.037] dest = [03:50:00.037] address = {classId = 1259, objectId = 27442, objectSubId = 0} [03:50:00.037] __func__ = "ExecCreateTableAs" [03:50:00.037] #10 0x00005631080c02c3 in ProcessUtilitySlow (pstate=pstate@entry=0x56311e4162e0, pstmt=pstmt@entry=0x56311e26b8a0, queryString=queryString@entry=0x56311e26aab0 "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=0x56311e26c2d8, qc=0x7ffe74a014b0) at ../src/backend/tcop/utility.c:1675 [03:50:00.037] _save_exception_stack = 0x7ffe74a01370 [03:50:00.037] _save_context_stack = 0x0 [03:50:00.037] _local_sigjmp_buf = {{__jmpbuf = {0, -6760578771197113215, 94768959240176, 0, 94768959236784, 0, -1030395913098507135, -6760548215136596863}, __mask_was_saved = 0, __saved_mask = {__val = {139782175694592, 10479, 94768587815511, 1, 4294977775, 139782175694592, 94768587805829, 1, 45007469021160, 1, 10479, 139782175694592, 139782175694592, 1, 94768587815858, 94768960112616}}}} [03:50:00.037] _do_rethrow = false [03:50:00.037] parsetree = 0x56311e26b7f0 [03:50:00.037] isTopLevel = true [03:50:00.037] isCompleteQuery = true [03:50:00.037] needCleanup = false [03:50:00.037] commandCollected = false [03:50:00.037] address = {classId = 22065, objectId = 505853936, objectSubId = 22065} [03:50:00.037] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:50:00.037] __func__ = "ProcessUtilitySlow" [03:50:00.037] #11 0x00005631080be8d4 in standard_ProcessUtility (pstmt=0x56311e26b8a0, queryString=0x56311e26aab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x56311e26c2d8, qc=0x7ffe74a014b0) at ../src/backend/tcop/utility.c:1067 [03:50:00.037] parsetree = 0x56311e26b7f0 [03:50:00.037] isTopLevel = true [03:50:00.037] isAtomicContext = false [03:50:00.037] pstate = 0x56311e4162e0 [03:50:00.037] readonly_flags = [03:50:00.037] __func__ = "standard_ProcessUtility" [03:50:00.037] #12 0x00005631080bea2f in ProcessUtility (pstmt=pstmt@entry=0x56311e26b8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x56311e26c2d8, qc=0x7ffe74a014b0) at ../src/backend/tcop/utility.c:523 [03:50:00.037] No locals. [03:50:00.037] #13 0x00005631080ba29b in PortalRunUtility (portal=portal@entry=0x56311e2ed050, pstmt=pstmt@entry=0x56311e26b8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x56311e26c2d8, qc=qc@entry=0x7ffe74a014b0) at ../src/backend/tcop/pquery.c:1158 [03:50:00.037] No locals. [03:50:00.037] #14 0x00005631080ba840 in PortalRunMulti (portal=portal@entry=0x56311e2ed050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x56311e26c2d8, altdest=altdest@entry=0x56311e26c2d8, qc=qc@entry=0x7ffe74a014b0) at ../src/backend/tcop/pquery.c:1316 [03:50:00.037] pstmt = 0x56311e26b8a0 [03:50:00.037] stmtlist_item__state = [03:50:00.037] active_snapshot_set = false [03:50:00.037] stmtlist_item = 0x56311e26c2a0 [03:50:00.037] #15 0x00005631080bae13 in PortalRun (portal=portal@entry=0x56311e2ed050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x56311e26c2d8, altdest=altdest@entry=0x56311e26c2d8, qc=0x7ffe74a014b0) at ../src/backend/tcop/pquery.c:791 [03:50:00.037] _save_exception_stack = 0x7ffe74a01560 [03:50:00.037] _save_context_stack = 0x0 [03:50:00.037] _local_sigjmp_buf = {{__jmpbuf = {0, -6760578768721425279, 94768959770704, 94768959240296, 94768959770704, 94768959240224, -1030395912691659647, -6760548217492091775}, __mask_was_saved = 0, __saved_mask = {__val = {94768591317899, 94768959236528, 112, 4, 94768591322316, 1956647999, 4, 94768959240224, 112, 73, 94768959770704, 94768959240296, 94768959240272, 94768959240224, 94768591409519, 1}}}} [03:50:00.037] _do_rethrow = [03:50:00.037] result = [03:50:00.037] nprocessed = [03:50:00.037] saveTopTransactionResourceOwner = 0x56311e2a9d08 [03:50:00.037] saveTopTransactionContext = 0x56311e2fec60 [03:50:00.037] saveActivePortal = 0x0 [03:50:00.037] saveResourceOwner = 0x56311e2a9d08 [03:50:00.037] savePortalContext = 0x0 [03:50:00.037] saveMemoryContext = 0x56311e2fec60 [03:50:00.037] __func__ = "PortalRun" [03:50:00.037] #16 0x00005631080b41ff in exec_simple_query (query_string=query_string@entry=0x56311e26aab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [03:50:00.037] cmdtaglen = 24 [03:50:00.037] snapshot_set = [03:50:00.037] per_parsetree_context = 0x0 [03:50:00.037] plantree_list = 0x56311e26c288 [03:50:00.037] parsetree = 0x56311e26b820 [03:50:00.037] commandTag = [03:50:00.037] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:50:00.037] querytree_list = [03:50:00.037] portal = 0x56311e2ed050 [03:50:00.037] receiver = 0x56311e26c2d8 [03:50:00.037] format = 0 [03:50:00.037] cmdtagname = [03:50:00.037] parsetree_item__state = [03:50:00.037] dest = DestRemote [03:50:00.037] oldcontext = 0x56311e2fec60 [03:50:00.037] parsetree_list = 0x56311e26b850 [03:50:00.037] parsetree_item = 0x56311e26b868 [03:50:00.037] save_log_statement_stats = false [03:50:00.037] was_logged = false [03:50:00.037] use_implicit_block = false [03:50:00.037] msec_str = "\020\027\240t\376\177\000\000\223\3326\b1V\000\000@\025\240t\376\177\000\000G\000\000\000\000\000\000" [03:50:00.037] __func__ = "exec_simple_query" [03:50:00.037] #17 0x00005631080b6f83 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [03:50:00.037] query_string = 0x56311e26aab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:50:00.037] firstchar = [03:50:00.037] input_message = {data = 0x56311e26aab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:50:00.037] local_sigjmp_buf = {{__jmpbuf = {94768603929304, -6760548649459004287, 4, 140730855069456, 140730855069600, 140730855069604, -1030395912897180543, -6760548219846538111}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94768958967248, 15616, 94768603923392, 94768959491264, 140730855069600, 94768591321864, 0, 9, 2, 94768603929312, 94768958967248, 94768603923392, 140730855069456, 140730855069600, 140730855069604}}}} [03:50:00.037] send_ready_for_query = false [03:50:00.037] idle_in_transaction_timeout_enabled = false [03:50:00.037] idle_session_timeout_enabled = false [03:50:00.037] __func__ = "PostgresMain" [03:50:00.037] #18 0x00005631080acdfa in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:50:00.037] bsdata = [03:50:00.037] #19 0x0000563107f60781 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe74a016bc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe74a01710) at ../src/backend/postmaster/launch_backend.c:266 [03:50:00.037] pid = [03:50:00.037] #20 0x0000563107f66235 in BackendStartup (client_sock=client_sock@entry=0x7ffe74a01710) at ../src/backend/postmaster/postmaster.c:3417 [03:50:00.037] bn = 0x56311e293438 [03:50:00.037] pid = [03:50:00.037] startup_data = {canAcceptConnections = CAC_OK} [03:50:00.037] __func__ = "BackendStartup" [03:50:00.037] #21 0x0000563107f66797 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [03:50:00.037] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\003\236!\177\000\000\240\257T\237!\177\000\000\270\027\240t\376\177\000\000\264\027\240t\376\177", '\000' , "2\261\021\a1V\000\000 \227\r\a1V\000\000\200\030\240t\376\177\000\000x\030\240t\376\177\000\000\225[\362\001\000\000\000\000\240\204\203\236!\177\000\000+", '\000' , "1V\000\000@\260\021\a1V\000", __ss_align = 139782388696680}, salen = 2}} [03:50:00.037] i = 0 [03:50:00.037] now = [03:50:00.037] last_lockfile_recheck_time = 1730519167 [03:50:00.037] last_touch_time = 1730519167 [03:50:00.037] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x56310711b132}, {pos = -1616918936, events = 32545, fd = -1635547600, user_data = 0x7f219f9fc2e0}, {pos = 2090263927, events = 0, fd = 1956649216, user_data = 0x7f219f9d2a48}, {pos = 15, events = 0, fd = -1635547600, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f219f9fc2e0}, {pos = 1956649080, events = 32766, fd = 1956649088, user_data = 0x7f219f9fc668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 505858224, events = 22065, fd = 1, user_data = 0x7ffe74a01da3}, {pos = -1, events = 0, fd = -1643978720, user_data = 0x7f219f54afa0}, {pos = 506033992, events = 22065, fd = 506033704, user_data = 0x56311e299841}, {pos = -1617064258, events = 32545, fd = 1, user_data = 0x7f219f9fc2e0}, {pos = 427, events = 0, fd = 143564120, user_data = 0x0}, {pos = 1, events = 0, fd = 505850736, user_data = 0x7f219f9d8ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f219e02e020}, {pos = -1643172416, events = 32545, fd = 16, user_data = 0x7ffe74a01ce0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1617055302, events = 32545, fd = 0, user_data = 0x7f219e0aed24 }, {pos = 0, events = 0, fd = 150479936, user_data = 0x2}, {pos = 7, events = 0, fd = 505597552, user_data = 0x56310804acb2 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 505850736, user_data = 0x7f219f9d8ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f219e0364c8}, {pos = -1643417619, events = 32545, fd = 150534624, user_data = 0x56311e296410}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1642128288, events = 32545, 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 = 0x312020200a0a5437}, {pos = 822763892, events = 892351287, fd = 909195569, 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 = 506036272, user_data = 0x7f219e0b56eb}, {pos = -1642145312, events = 32545, fd = -1643507346, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xfd8154ba64f89f00}, {pos = -1642142240, events = 32545, fd = -328, user_data = 0x0}, {pos = 506033384, events = 22065, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 506033184, events = 22065, fd = 3, user_data = 0x0}, {pos = 25468, events = 0, fd = -328, user_data = 0x0}, {pos = 505850736, events = 22065, fd = -1643171885, user_data = 0x7ffe74a01d98}, {pos = 138014975, events = 22065, fd = 150542992, user_data = 0x56310838dbbc }, {pos = 506033184, events = 22065, fd = 505850288, user_data = 0x56311e297420}, {pos = -1643423682, events = 32545, fd = 0, user_data = 0x56310839f826 }, {pos = 506033184, events = 1, fd = 138017135, user_data = 0x56311e26a9b0}, {pos = 1694015232, events = 4253111482, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1643500879, user_data = 0x7f219e0a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1694015232, user_data = 0x56311e2420e0}, {pos = 1694015232, events = 4253111482, fd = 11, user_data = 0xfd8154ba64f89f00}, {pos = 0, events = 0, fd = -1643793863, user_data = 0x1}, {pos = 133563518, events = 22065, fd = 4194304, user_data = 0x56310838da50 }, {pos = 505684192, events = 22065, fd = 505850288, user_data = 0x56311e2420e0}, {pos = 1, events = 0, fd = 0, user_data = 0x56310839f826 }, {pos = 505684192, events = 22065, fd = 138017135, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x563107d94e50 }, {pos = 0, events = 0, fd = 131703184, user_data = 0xb}, {pos = 133584675, events = 22065, fd = 146921232, user_data = 0x56311e26b388}} [03:50:00.037] nevents = 1 [03:50:00.037] __func__ = "ServerLoop" [03:50:00.037] #22 0x0000563107f67f1a in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x56311e228d30) at ../src/backend/postmaster/postmaster.c:1348 [03:50:00.037] opt = [03:50:00.037] status = [03:50:00.037] userDoption = [03:50:00.037] listen_addr_saved = false [03:50:00.037] output_config_variable = [03:50:00.037] __func__ = "PostmasterMain" [03:50:00.037] #23 0x0000563107da51d8 in main (argc=8, argv=0x56311e228d30) at ../src/backend/main/main.c:196 [03:50:00.037] do_check_root = [03:50:00.069] -e [03:50:00.069] [03:50:00.069] [03:50:00.130] dumping /tmp/cores/postgres-6-36257.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:50:00.374] [New LWP 36257] [03:50:00.374] [03:50:00.374] This GDB supports auto-downloading debuginfo from the following URLs: [03:50:00.374] [03:50:00.374] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:50:00.374] Debuginfod has been disabled. [03:50:00.374] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:50:00.475] [Thread debugging using libthread_db enabled] [03:50:00.475] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:50:00.475] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:50:00.475] Program terminated with signal SIGABRT, Aborted. [03:50:00.475] #0 0x00007feb6f2a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:01.270] [03:50:01.270] Thread 1 (Thread 0x7feb6f1d3f00 (LWP 36257)): [03:50:01.270] #0 0x00007feb6f2a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:01.270] No symbol table info available. [03:50:01.270] #1 0x00007feb6f25afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:01.270] No symbol table info available. [03:50:01.270] #2 0x00007feb6f245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:01.270] No symbol table info available. [03:50:01.270] #3 0x000055f43cd07ce5 in ExceptionalCondition (conditionName=conditionName@entry=0x55f43cf7c0b5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55f43cf7b5d0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:50:01.270] No locals. [03:50:01.270] #4 0x000055f43c68b19d in standard_ExecutorStart (queryDesc=0x55f461ef11b0, eflags=0) at ../src/backend/executor/execMain.c:194 [03:50:01.270] estate = 0x55f461dbb200 [03:50:01.270] oldcontext = 0x55f461e153b0 [03:50:01.270] __func__ = "standard_ExecutorStart" [03:50:01.270] #5 0x00007feb6c9d66f7 in pgss_ExecutorStart (queryDesc=0x55f461ef11b0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [03:50:01.270] No locals. [03:50:01.270] #6 0x000055f43c68b332 in ExecutorStart (queryDesc=queryDesc@entry=0x55f461ef11b0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [03:50:01.270] No locals. [03:50:01.270] #7 0x000055f43c5b1bb4 in refresh_matview_datafill (dest=0x55f461eec108, query=, query@entry=0x55f461e7dd40, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:50:01.270] rewritten = [03:50:01.270] plan = 0x55f461ef05d8 [03:50:01.270] queryDesc = 0x55f461ef11b0 [03:50:01.270] copied_query = [03:50:01.270] processed = [03:50:01.270] __func__ = "refresh_matview_datafill" [03:50:01.270] #8 0x000055f43c5b3f1b in RefreshMatViewByOid (matviewOid=27456, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:50:01.270] dest = [03:50:01.270] matviewRel = 0x7feb6ac76bb8 [03:50:01.270] rule = [03:50:01.270] actions = [03:50:01.270] dataQuery = 0x55f461e7dd40 [03:50:01.270] tableSpace = [03:50:01.270] relowner = 10 [03:50:01.270] OIDNewHeap = 27474 [03:50:01.270] processed = 0 [03:50:01.270] relpersistence = 112 'p' [03:50:01.270] save_userid = 10 [03:50:01.270] save_sec_context = 0 [03:50:01.270] save_nestlevel = 2 [03:50:01.270] address = {classId = 0, objectId = 0, objectSubId = 0} [03:50:01.270] __func__ = "RefreshMatViewByOid" [03:50:01.270] #9 0x000055f43c5b405a in ExecRefreshMatView (stmt=0x55f461e31410, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:50:01.270] matviewOid = [03:50:01.270] lockmode = [03:50:01.270] #10 0x000055f43c569ca7 in ExecCreateTableAs (pstate=pstate@entry=0x55f461e154b0, stmt=stmt@entry=0x55f461cd3790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc2c9058a0) at ../src/backend/commands/createas.c:351 [03:50:01.270] refresh = [03:50:01.270] query = 0x55f461cd3950 [03:50:01.270] into = 0x55f461cd34e8 [03:50:01.270] jstate = 0x0 [03:50:01.270] is_matview = true [03:50:01.270] do_refresh = false [03:50:01.270] dest = [03:50:01.270] address = {classId = 1259, objectId = 27456, objectSubId = 0} [03:50:01.270] __func__ = "ExecCreateTableAs" [03:50:01.270] #11 0x000055f43ca802c3 in ProcessUtilitySlow (pstate=pstate@entry=0x55f461e154b0, pstmt=pstmt@entry=0x55f461cd3840, queryString=queryString@entry=0x55f461cd2a50 "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=0x55f461cd47e8, qc=0x7ffc2c9058a0) at ../src/backend/tcop/utility.c:1675 [03:50:01.270] _save_exception_stack = 0x7ffc2c905450 [03:50:01.270] _save_context_stack = 0x0 [03:50:01.270] _local_sigjmp_buf = {{__jmpbuf = {0, -6327832136768652042, 94508101220240, 0, 94508101216848, 0, -270325343513314058, -6327631250856837898}, __mask_was_saved = 0, __saved_mask = {__val = {17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 94507477448260, 0, 5412384741217271808, 94507483521504, 94507477701121, 140649088756928, 1, 16777216, 0, 112, 94507477448532, 140649089261568}}}} [03:50:01.270] _do_rethrow = false [03:50:01.270] parsetree = 0x55f461cd3790 [03:50:01.270] isTopLevel = true [03:50:01.270] isCompleteQuery = true [03:50:01.270] needCleanup = false [03:50:01.270] commandCollected = false [03:50:01.270] address = {classId = 22004, objectId = 1640839056, objectSubId = 22004} [03:50:01.270] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:50:01.270] __func__ = "ProcessUtilitySlow" [03:50:01.270] #12 0x000055f43ca7e8d4 in standard_ProcessUtility (pstmt=pstmt@entry=0x55f461cd3840, queryString=queryString@entry=0x55f461cd2a50 "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=0x55f461cd47e8, qc=0x7ffc2c9058a0) at ../src/backend/tcop/utility.c:1067 [03:50:01.270] parsetree = 0x55f461cd3790 [03:50:01.270] isTopLevel = true [03:50:01.270] isAtomicContext = false [03:50:01.270] pstate = 0x55f461e154b0 [03:50:01.270] readonly_flags = [03:50:01.270] __func__ = "standard_ProcessUtility" [03:50:01.270] #13 0x00007feb6c9d9d9d in pgss_ProcessUtility (pstmt=0x55f461cd3840, queryString=0x55f461cd2a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55f461cd47e8, qc=0x7ffc2c9058a0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [03:50:01.270] _save_exception_stack = 0x7ffc2c905760 [03:50:01.270] _save_context_stack = 0x0 [03:50:01.270] _local_sigjmp_buf = {{__jmpbuf = {0, 272403631466773750, 94508101220416, 94508101224424, 140721056143520, 0, -270325342603150090, -283413880052744970}, __mask_was_saved = 0, __saved_mask = {__val = {94507481273588, 140721056142790, 140721056142788, 0, 0, 139637976727552, 206158430232, 140721056142752, 94507481273805, 0, 206158430232, 94508101221216, 140721056142848, 0, 94507476092872, 94508101216592}}}} [03:50:01.270] _do_rethrow = false [03:50:01.270] duration = [03:50:01.270] bufusage = {shared_blks_hit = 94508102170168, shared_blks_read = 1047972020224, shared_blks_dirtied = 0, shared_blks_written = 94508102169672, local_blks_hit = 94508102170168, local_blks_read = 94507474424255, local_blks_dirtied = 94508103390088, local_blks_written = 94507474424501, temp_blks_read = 94508102169672, temp_blks_written = 94508102169088, shared_blk_read_time = {ticks = 94507474423610}, shared_blk_write_time = {ticks = 94507481267040}, local_blk_read_time = {ticks = 140649158229432}, local_blk_write_time = {ticks = 94508101216848}, temp_blk_read_time = {ticks = 94507483590693}, temp_blk_write_time = {ticks = 94507493554530}} [03:50:01.270] walusage_start = {wal_records = 8933, wal_fpi = 116, wal_bytes = 1186945} [03:50:01.270] start = [03:50:01.270] rows = [03:50:01.270] bufusage_start = {shared_blks_hit = 34141, shared_blks_read = 3758, shared_blks_dirtied = 1525, shared_blks_written = 1036, 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}} [03:50:01.270] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 140649088756928} [03:50:01.270] parsetree = [03:50:01.270] saved_queryId = 6041762721901209185 [03:50:01.270] saved_stmt_location = 0 [03:50:01.270] saved_stmt_len = 69 [03:50:01.270] enabled = true [03:50:01.270] #14 0x000055f43ca7e97a in ProcessUtility (pstmt=pstmt@entry=0x55f461cd3840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55f461cd47e8, qc=0x7ffc2c9058a0) at ../src/backend/tcop/utility.c:519 [03:50:01.270] No locals. [03:50:01.270] #15 0x000055f43ca7a29b in PortalRunUtility (portal=portal@entry=0x55f461d53f90, pstmt=pstmt@entry=0x55f461cd3840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f461cd47e8, qc=qc@entry=0x7ffc2c9058a0) at ../src/backend/tcop/pquery.c:1158 [03:50:01.270] No locals. [03:50:01.270] #16 0x000055f43ca7a840 in PortalRunMulti (portal=portal@entry=0x55f461d53f90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f461cd47e8, altdest=altdest@entry=0x55f461cd47e8, qc=qc@entry=0x7ffc2c9058a0) at ../src/backend/tcop/pquery.c:1316 [03:50:01.270] pstmt = 0x55f461cd3840 [03:50:01.270] stmtlist_item__state = [03:50:01.270] active_snapshot_set = false [03:50:01.270] stmtlist_item = 0x55f461cd47b0 [03:50:01.270] #17 0x000055f43ca7ae13 in PortalRun (portal=portal@entry=0x55f461d53f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55f461cd47e8, altdest=altdest@entry=0x55f461cd47e8, qc=0x7ffc2c9058a0) at ../src/backend/tcop/pquery.c:791 [03:50:01.270] _save_exception_stack = 0x7ffc2c905950 [03:50:01.270] _save_context_stack = 0x0 [03:50:01.270] _local_sigjmp_buf = {{__jmpbuf = {0, -6327832138158015242, 94508101746576, 94508101220360, 94508101746576, 94508101220288, -270325342726882058, -6327631248900588298}, __mask_was_saved = 0, __saved_mask = {__val = {94507480951691, 94508101216592, 112, 4, 94507480956108, 747657263, 4, 94508101220288, 112, 73, 94508101746576, 94508101220360, 94508101220336, 94508101220288, 94507481043311, 1}}}} [03:50:01.270] _do_rethrow = [03:50:01.270] result = [03:50:01.270] nprocessed = [03:50:01.270] saveTopTransactionResourceOwner = 0x55f461d13468 [03:50:01.270] saveTopTransactionContext = 0x55f461d663c0 [03:50:01.270] saveActivePortal = 0x0 [03:50:01.270] saveResourceOwner = 0x55f461d13468 [03:50:01.270] savePortalContext = 0x0 [03:50:01.270] saveMemoryContext = 0x55f461d663c0 [03:50:01.270] __func__ = "PortalRun" [03:50:01.270] #18 0x000055f43ca741ff in exec_simple_query (query_string=query_string@entry=0x55f461cd2a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [03:50:01.270] cmdtaglen = 24 [03:50:01.270] snapshot_set = [03:50:01.270] per_parsetree_context = 0x0 [03:50:01.270] plantree_list = 0x55f461cd4798 [03:50:01.270] parsetree = 0x55f461cd37c0 [03:50:01.270] commandTag = [03:50:01.270] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:50:01.270] querytree_list = [03:50:01.270] portal = 0x55f461d53f90 [03:50:01.270] receiver = 0x55f461cd47e8 [03:50:01.270] format = 0 [03:50:01.270] cmdtagname = [03:50:01.270] parsetree_item__state = [03:50:01.270] dest = DestRemote [03:50:01.270] oldcontext = 0x55f461d663c0 [03:50:01.270] parsetree_list = 0x55f461cd37f0 [03:50:01.270] parsetree_item = 0x55f461cd3808 [03:50:01.270] save_log_statement_stats = false [03:50:01.270] was_logged = true [03:50:01.270] use_implicit_block = false [03:50:01.270] msec_str = "\000[\220,\374\177\000\000\223\332\322<\364U\000\0000Y\220,\374\177\000\000G\000\000\000\000\000\000" [03:50:01.270] __func__ = "exec_simple_query" [03:50:01.270] #19 0x000055f43ca76f83 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [03:50:01.270] query_string = 0x55f461cd2a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:50:01.270] firstchar = [03:50:01.270] input_message = {data = 0x55f461cd2a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:50:01.270] local_sigjmp_buf = {{__jmpbuf = {94507493563096, -6327629481903489802, 4, 140721056144128, 140721056144272, 140721056144276, -270325342890459914, -6327631255005266698}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94508101466432, 0, 168, 94507480956210, 0, 10, 2, 94507493563104, 94508100947440, 94507493557184, 140721056144128, 140721056144272, 140721056144276}}}} [03:50:01.270] send_ready_for_query = false [03:50:01.270] idle_in_transaction_timeout_enabled = false [03:50:01.270] idle_session_timeout_enabled = false [03:50:01.270] __func__ = "PostgresMain" [03:50:01.270] #20 0x000055f43ca6cdfa in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:50:01.270] bsdata = [03:50:01.270] #21 0x000055f43c920781 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc2c905aac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc2c905b00) at ../src/backend/postmaster/launch_backend.c:266 [03:50:01.270] pid = [03:50:01.270] #22 0x000055f43c926235 in BackendStartup (client_sock=client_sock@entry=0x7ffc2c905b00) at ../src/backend/postmaster/postmaster.c:3417 [03:50:01.270] bn = 0x55f461cff298 [03:50:01.270] pid = [03:50:01.270] startup_data = {canAcceptConnections = CAC_OK} [03:50:01.270] __func__ = "BackendStartup" [03:50:01.270] #23 0x000055f43c926797 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [03:50:01.270] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\273p\353\177\000\000>\004\000\000\000\000\000\000\260\227#o\353\177\000\000\240\017sp\353\177\000\000\270[\220,\374\177\000\000\264[\220,\374\177", '\000' , "2\261\255;\364U\000\000 \227\251;\364U\000\000\200\\\220,\374\177\000\000x\\\220,\374\177\000\000\225[\362\001\202t-dp\312\317a\364U\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [03:50:01.270] i = 0 [03:50:01.270] now = [03:50:01.270] last_lockfile_recheck_time = 1730519201 [03:50:01.270] last_touch_time = 1730519201 [03:50:01.270] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 747658432, user_data = 0x0}, {pos = 15, events = 0, fd = 1001238834, user_data = 0x7feb70be2668}, {pos = 1872967216, events = 32747, fd = 1891508960, user_data = 0x7c96e577}, {pos = 747658496, events = 32764, fd = 1891338824, user_data = 0xf}, {pos = 1872967216, events = 32747, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1891508960, user_data = 0x7ffc2c905c78}, {pos = 747658368, events = 32764, fd = 1891509864, user_data = 0x0}, {pos = 1640838512, events = 22004, fd = 1865346277, user_data = 0x7ffc2c906193}, {pos = 1, events = 0, fd = 747658368, user_data = 0xffffffff}, {pos = 1864556576, events = 32747, fd = 1886588832, user_data = 0x55f461cfe308}, {pos = 1641013736, events = 22004, fd = 1641031825, user_data = 0x7feb70bbeebe}, {pos = 1, events = 0, fd = 1891508960, user_data = 0x1ab}, {pos = 1026202968, events = 22004, fd = 0, user_data = 0x1}, {pos = 1640843408, events = 22004, fd = 1891364542, user_data = 0x1}, {pos = 0, events = 0, fd = 1864556576, user_data = 0x7feb6f2f2dc0 }, {pos = 16, events = 0, fd = 747659472, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7feb70bc11ba}, {pos = 0, events = 0, fd = 1865084196, user_data = 0x0}, {pos = 1033118784, events = 22004, fd = 2, user_data = 0x7}, {pos = 1640582800, events = 22004, fd = 1952410737, user_data = 0x161}, {pos = 1026202376, events = 22004, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 1640843408, events = 22004, fd = 1891364542, user_data = 0x1}, {pos = 1865117677, events = 32747, fd = 1864590536, user_data = 0x55f461d07900}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1866407008, events = 32747, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55f461c94e90}, {pos = 1865120266, events = 32747, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {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 = 0x7feb70087540}, {pos = 1879603840, events = 32747, 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 = 1866389984, events = 32747, fd = 1865027950, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x642d74823f400b00}, {pos = 1866393056, events = 32747, fd = -328, user_data = 0x0}, {pos = 1641013416, events = 22004, fd = 1024, user_data = 0x55f461cfe0a8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 32658, events = 0, fd = -328, user_data = 0x0}, {pos = 1640843408, events = 22004, fd = 1865363411, user_data = 0x7ffc2c906188}, {pos = 1020653823, events = 22004, fd = 1033181840, user_data = 0x55f43cd4dbbc }, {pos = 1641013216, events = 22004, fd = 1640835408, user_data = 0x55f461cfdfe0}, {pos = 1865111614, events = 32747, fd = 0, user_data = 0x55f43cd5f826 }, {pos = 1641013216, events = 1, fd = 1020655983, user_data = 0x55f461cd2950}, {pos = 1061161728, events = 1680700546, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1865034417, user_data = 0x7feb6f2a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1061161728, user_data = 0x55f461caa080}, {pos = 1061161728, events = 1680700546, fd = 11, user_data = 0x642d74823f400b00}, {pos = 0, events = 0, fd = 1864741433, user_data = 0x1}, {pos = 1016202366, events = 22004, fd = 4194304, user_data = 0x55f43cd4da50 }, {pos = 1640669312, events = 22004, fd = 1640835408, user_data = 0x55f461caa080}, {pos = 1, events = 0, fd = 0, user_data = 0x55f43cd5f826 }, {pos = 1640669312, events = 22004, fd = 1020655983, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55f43c754e50 }, {pos = 0, events = 0, fd = 1014342032, user_data = 0xb}, {pos = 1016223523, events = 22004, fd = 1029560080, user_data = 0x55f461cd3308}} [03:50:01.270] nevents = 1 [03:50:01.270] __func__ = "ServerLoop" [03:50:01.270] #24 0x000055f43c927f1a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55f461c90cf0) at ../src/backend/postmaster/postmaster.c:1348 [03:50:01.270] opt = [03:50:01.270] status = [03:50:01.270] userDoption = [03:50:01.270] listen_addr_saved = false [03:50:01.270] output_config_variable = [03:50:01.270] __func__ = "PostmasterMain" [03:50:01.270] #25 0x000055f43c7651d8 in main (argc=4, argv=0x55f461c90cf0) at ../src/backend/main/main.c:196 [03:50:01.270] do_check_root = [03:50:01.303] -e [03:50:01.303] [03:50:01.303] [03:50:01.362] dumping /tmp/cores/postgres-6-29871.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:50:01.594] [New LWP 29871] [03:50:01.594] [03:50:01.594] This GDB supports auto-downloading debuginfo from the following URLs: [03:50:01.594] [03:50:01.594] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:50:01.594] Debuginfod has been disabled. [03:50:01.594] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:50:01.689] [Thread debugging using libthread_db enabled] [03:50:01.689] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:50:01.689] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:50:01.689] Program terminated with signal SIGABRT, Aborted. [03:50:01.689] #0 0x00007fb0c42a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:02.479] [03:50:02.479] Thread 1 (Thread 0x7fb0c4a36f00 (LWP 29871)): [03:50:02.479] #0 0x00007fb0c42a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:02.479] No symbol table info available. [03:50:02.479] #1 0x00007fb0c425afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:02.479] No symbol table info available. [03:50:02.479] #2 0x00007fb0c4245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:50:02.479] No symbol table info available. [03:50:02.479] #3 0x00005636b4fa9ce5 in ExceptionalCondition (conditionName=conditionName@entry=0x5636b521e0b5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5636b521d5d0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:50:02.479] No locals. [03:50:02.479] #4 0x00005636b492d19d in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5636e000dfc0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [03:50:02.479] estate = 0x5636e0063160 [03:50:02.479] oldcontext = 0x5636e00c2620 [03:50:02.479] __func__ = "standard_ExecutorStart" [03:50:02.479] #5 0x00005636b492d379 in ExecutorStart (queryDesc=queryDesc@entry=0x5636e000dfc0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [03:50:02.479] No locals. [03:50:02.479] #6 0x00005636b4853bb4 in refresh_matview_datafill (dest=0x5636e00280f8, query=, query@entry=0x5636e0066a30, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:50:02.479] rewritten = [03:50:02.479] plan = 0x5636e000d4f8 [03:50:02.479] queryDesc = 0x5636e000dfc0 [03:50:02.479] copied_query = [03:50:02.479] processed = [03:50:02.479] __func__ = "refresh_matview_datafill" [03:50:02.479] #7 0x00005636b4855f1b in RefreshMatViewByOid (matviewOid=27357, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:50:02.479] dest = [03:50:02.479] matviewRel = 0x7fb0b8bb5d18 [03:50:02.479] rule = [03:50:02.479] actions = [03:50:02.479] dataQuery = 0x5636e0066a30 [03:50:02.479] tableSpace = [03:50:02.479] relowner = 10 [03:50:02.479] OIDNewHeap = 27374 [03:50:02.479] processed = 0 [03:50:02.479] relpersistence = 112 'p' [03:50:02.479] save_userid = 10 [03:50:02.479] save_sec_context = 0 [03:50:02.479] save_nestlevel = 2 [03:50:02.479] address = {classId = 0, objectId = 0, objectSubId = 0} [03:50:02.479] __func__ = "RefreshMatViewByOid" [03:50:02.479] #8 0x00005636b485605a in ExecRefreshMatView (stmt=0x5636dffebbe0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:50:02.479] matviewOid = [03:50:02.479] lockmode = [03:50:02.479] #9 0x00005636b480bca7 in ExecCreateTableAs (pstate=pstate@entry=0x5636e00c2720, stmt=stmt@entry=0x5636dfed0770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcabc45230) at ../src/backend/commands/createas.c:351 [03:50:02.479] refresh = [03:50:02.479] query = 0x5636dfed0930 [03:50:02.479] into = 0x5636dfed04c8 [03:50:02.479] jstate = 0x0 [03:50:02.479] is_matview = true [03:50:02.479] do_refresh = false [03:50:02.479] dest = [03:50:02.479] address = {classId = 1259, objectId = 27357, objectSubId = 0} [03:50:02.479] __func__ = "ExecCreateTableAs" [03:50:02.479] #10 0x00005636b4d222c3 in ProcessUtilitySlow (pstate=pstate@entry=0x5636e00c2720, pstmt=pstmt@entry=0x5636dfed0820, queryString=queryString@entry=0x5636dfecfa30 "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=0x5636dfed1258, qc=0x7ffcabc45230) at ../src/backend/tcop/utility.c:1675 [03:50:02.479] _save_exception_stack = 0x7ffcabc450f0 [03:50:02.479] _save_context_stack = 0x0 [03:50:02.479] _local_sigjmp_buf = {{__jmpbuf = {0, -1530563547732065098, 94793685075824, 0, 94793685072432, 0, -5091687979038751562, -1530503770480655178}, __mask_was_saved = 0, __saved_mask = {__val = {140396995996096, 14942, 94792961317463, 1, 4294982238, 140396995996096, 94792965135200, 140397190016440, 94793685072432, 94792967458853, 94792977422690, 94792977422816, 140723190255412, 94792967653720, 94792977422705, 94792977422816}}}} [03:50:02.479] _do_rethrow = false [03:50:02.479] parsetree = 0x5636dfed0770 [03:50:02.479] isTopLevel = true [03:50:02.479] isCompleteQuery = true [03:50:02.479] needCleanup = false [03:50:02.479] commandCollected = false [03:50:02.479] address = {classId = 22070, objectId = 3756853104, objectSubId = 22070} [03:50:02.479] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:50:02.479] __func__ = "ProcessUtilitySlow" [03:50:02.479] #11 0x00005636b4d208d4 in standard_ProcessUtility (pstmt=0x5636dfed0820, queryString=0x5636dfecfa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5636dfed1258, qc=0x7ffcabc45230) at ../src/backend/tcop/utility.c:1067 [03:50:02.479] parsetree = 0x5636dfed0770 [03:50:02.479] isTopLevel = true [03:50:02.479] isAtomicContext = false [03:50:02.479] pstate = 0x5636e00c2720 [03:50:02.479] readonly_flags = [03:50:02.479] __func__ = "standard_ProcessUtility" [03:50:02.479] #12 0x00005636b4d20a2f in ProcessUtility (pstmt=pstmt@entry=0x5636dfed0820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5636dfed1258, qc=0x7ffcabc45230) at ../src/backend/tcop/utility.c:523 [03:50:02.479] No locals. [03:50:02.479] #13 0x00005636b4d1c29b in PortalRunUtility (portal=portal@entry=0x5636dff52680, pstmt=pstmt@entry=0x5636dfed0820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5636dfed1258, qc=qc@entry=0x7ffcabc45230) at ../src/backend/tcop/pquery.c:1158 [03:50:02.479] No locals. [03:50:02.479] #14 0x00005636b4d1c840 in PortalRunMulti (portal=portal@entry=0x5636dff52680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5636dfed1258, altdest=altdest@entry=0x5636dfed1258, qc=qc@entry=0x7ffcabc45230) at ../src/backend/tcop/pquery.c:1316 [03:50:02.479] pstmt = 0x5636dfed0820 [03:50:02.479] stmtlist_item__state = [03:50:02.479] active_snapshot_set = false [03:50:02.479] stmtlist_item = 0x5636dfed1220 [03:50:02.479] #15 0x00005636b4d1ce13 in PortalRun (portal=portal@entry=0x5636dff52680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5636dfed1258, altdest=altdest@entry=0x5636dfed1258, qc=0x7ffcabc45230) at ../src/backend/tcop/pquery.c:791 [03:50:02.479] _save_exception_stack = 0x7ffcabc452e0 [03:50:02.479] _save_context_stack = 0x0 [03:50:02.479] _local_sigjmp_buf = {{__jmpbuf = {0, -1530563546986527562, 94793685608064, 94793685075944, 94793685608064, 94793685075872, -5091687978371857226, -1530503789599996746}, __mask_was_saved = 0, __saved_mask = {__val = {94792964819851, 94793685072176, 112, 4, 94792964824268, 2881769919, 4, 94793685075872, 112, 73, 94793685608064, 94793685075944, 94793685075920, 94793685075872, 94792964911471, 1}}}} [03:50:02.479] _do_rethrow = [03:50:02.479] result = [03:50:02.479] nprocessed = [03:50:02.479] saveTopTransactionResourceOwner = 0x5636dff0f838 [03:50:02.479] saveTopTransactionContext = 0x5636dff63660 [03:50:02.479] saveActivePortal = 0x0 [03:50:02.479] saveResourceOwner = 0x5636dff0f838 [03:50:02.479] savePortalContext = 0x0 [03:50:02.479] saveMemoryContext = 0x5636dff63660 [03:50:02.479] __func__ = "PortalRun" [03:50:02.479] #16 0x00005636b4d161ff in exec_simple_query (query_string=query_string@entry=0x5636dfecfa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [03:50:02.479] cmdtaglen = 24 [03:50:02.479] snapshot_set = [03:50:02.479] per_parsetree_context = 0x0 [03:50:02.479] plantree_list = 0x5636dfed1208 [03:50:02.479] parsetree = 0x5636dfed07a0 [03:50:02.479] commandTag = [03:50:02.479] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:50:02.479] querytree_list = [03:50:02.479] portal = 0x5636dff52680 [03:50:02.479] receiver = 0x5636dfed1258 [03:50:02.479] format = 0 [03:50:02.479] cmdtagname = [03:50:02.479] parsetree_item__state = [03:50:02.479] dest = DestRemote [03:50:02.479] oldcontext = 0x5636dff63660 [03:50:02.479] parsetree_list = 0x5636dfed07d0 [03:50:02.479] parsetree_item = 0x5636dfed07e8 [03:50:02.479] save_log_statement_stats = false [03:50:02.479] was_logged = true [03:50:02.479] use_implicit_block = false [03:50:02.479] msec_str = "\220Tī\374\177\000\000\223\372\374\2646V\000\000\300Rī\374\177\000\000G\000\000\000\000\000\000" [03:50:02.479] __func__ = "exec_simple_query" [03:50:02.479] #17 0x00005636b4d18f83 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [03:50:02.479] query_string = 0x5636dfecfa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:50:02.479] firstchar = [03:50:02.479] input_message = {data = 0x5636dfecfa30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:50:02.479] local_sigjmp_buf = {{__jmpbuf = {94792977431256, -1530506766729296714, 4, 140723190256784, 140723190256928, 140723190256932, -5091687978434771786, -1530503791539993418}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94793684802992, 14336, 94792977425344, 94793685329904, 140723190256928, 94792964823816, 0, 9, 2, 94792977431264, 94793684802992, 94792977425344, 140723190256784, 140723190256928, 140723190256932}}}} [03:50:02.479] send_ready_for_query = false [03:50:02.479] idle_in_transaction_timeout_enabled = false [03:50:02.479] idle_session_timeout_enabled = false [03:50:02.479] __func__ = "PostgresMain" [03:50:02.479] #18 0x00005636b4d0edfa in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:50:02.479] bsdata = [03:50:02.479] #19 0x00005636b4bc2781 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffcabc4543c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcabc45490) at ../src/backend/postmaster/launch_backend.c:266 [03:50:02.479] pid = [03:50:02.479] #20 0x00005636b4bc8235 in BackendStartup (client_sock=client_sock@entry=0x7ffcabc45490) at ../src/backend/postmaster/postmaster.c:3417 [03:50:02.479] bn = 0x5636dff04b68 [03:50:02.479] pid = [03:50:02.479] startup_data = {canAcceptConnections = CAC_OK} [03:50:02.479] __func__ = "BackendStartup" [03:50:02.479] #21 0x00005636b4bc8797 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [03:50:02.479] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "#İ\177\000\000\240/tŰ\177\000\0008Uī\374\177\000\0004Uī\374\177", '\000' , "2\321׳6V\000\000 \267ӳ6V\000\000\000Vī\374\177\000\000\370Uī\374\177\000\000\225[\362\001\000\000\000\000\240T\244İ\177\000\000+", '\000' , "6V\000\000@\320׳6V\000", __ss_align = 140397208618600}, salen = 2}} [03:50:02.479] i = 0 [03:50:02.479] now = [03:50:02.479] last_lockfile_recheck_time = 1730519169 [03:50:02.479] last_touch_time = 1730519169 [03:50:02.479] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x5636b3d7d132}, {pos = -977320344, events = 32688, fd = -995862992, user_data = 0x7fb0c5bf42e0}, {pos = 2090263927, events = 0, fd = -1413196160, user_data = 0x7fb0c5bcaa48}, {pos = 15, events = 0, fd = -995862992, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fb0c5bf42e0}, {pos = -1413196296, events = 32764, fd = -1413196288, user_data = 0x7fb0c5bf4668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -538109968, events = 22070, fd = 1, user_data = 0x7ffcabc45b23}, {pos = -1, events = 0, fd = -1004347360, user_data = 0x7fb0c5742fa0}, {pos = -537926808, events = 22070, fd = -537927096, user_data = 0x5636dfefe021}, {pos = -977465666, events = 32688, fd = 1, user_data = 0x7fb0c5bf42e0}, {pos = 427, events = 0, fd = -1252737704, user_data = 0x0}, {pos = 1, events = 0, fd = -538117560, user_data = 0x7fb0c5bd0ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb0c422e020}, {pos = -1003541056, events = 32688, fd = 16, user_data = 0x7ffcabc45a60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -977456710, events = 32688, fd = 0, user_data = 0x7fb0c42aed24 }, {pos = 0, events = 0, fd = -1245821888, user_data = 0x2}, {pos = 7, events = 0, fd = -538370480, user_data = 0x5636b4caccb2 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -538117560, user_data = 0x7fb0c5bd0ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb0c42364c8}, {pos = -1003786617, events = 32688, fd = -1245767200, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1002496928, events = 32688, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, 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 = 4294967040, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -537953728, user_data = 0x7fb0c42b56eb}, {pos = -1002513952, events = 32688, fd = -1003875986, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x64f562d883117100}, {pos = -1002510880, events = 32688, fd = -328, user_data = 0x0}, {pos = -537927416, events = 22070, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -537927616, events = 22070, fd = 3, user_data = 0x0}, {pos = 26089, events = 0, fd = -328, user_data = 0x0}, {pos = -538117560, events = 22070, fd = -1003540525, user_data = 0x7ffcabc45b18}, {pos = -1258286849, events = 22070, fd = -1245758832, user_data = 0x5636b4fefbbc }, {pos = -537927616, events = 22070, fd = -538117840, user_data = 0x5636dfefe040}, {pos = -1003792661, events = 32688, fd = 0, user_data = 0x5636b5001826 }, {pos = -537927616, events = 1, fd = -1258284689, user_data = 0x5636dfecf930}, {pos = -2096008960, events = 1693803224, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1003869519, user_data = 0x7fb0c42a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2096008960, user_data = 0x5636dfea7060}, {pos = -2096008960, events = 1693803224, fd = 11, user_data = 0x64f562d883117100}, {pos = 0, events = 0, fd = -1004162503, user_data = 0x1}, {pos = -1262738306, events = 22070, fd = 4194304, user_data = 0x5636b4fefa50 }, {pos = -538283936, events = 22070, fd = -538117840, user_data = 0x5636dfea7060}, {pos = 1, events = 0, fd = 0, user_data = 0x5636b5001826 }, {pos = -538283936, events = 22070, fd = -1258284689, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5636b49f6e50 }, {pos = 0, events = 0, fd = -1264598640, user_data = 0xb}, {pos = -1262717149, events = 22070, fd = -1249380592, user_data = 0x5636dfed02d8}} [03:50:02.479] nevents = 1 [03:50:02.479] __func__ = "ServerLoop" [03:50:02.479] #22 0x00005636b4bc9f1a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5636dfe8dcc0) at ../src/backend/postmaster/postmaster.c:1348 [03:50:02.479] opt = [03:50:02.479] status = [03:50:02.479] userDoption = [03:50:02.479] listen_addr_saved = false [03:50:02.479] output_config_variable = [03:50:02.479] __func__ = "PostmasterMain" [03:50:02.479] #23 0x00005636b4a071d8 in main (argc=4, argv=0x5636dfe8dcc0) at ../src/backend/main/main.c:196 [03:50:02.479] do_check_root =