[13:42:41.239] src/tools/ci/cores_backtrace.sh linux /tmp/cores [13:42:41.447] dumping /tmp/cores/postgres-6-28833.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:42:41.699] [New LWP 28833] [13:42:41.699] [13:42:41.699] This GDB supports auto-downloading debuginfo from the following URLs: [13:42:41.699] [13:42:41.699] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:42:41.699] Debuginfod has been disabled. [13:42:41.699] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:42:41.836] [Thread debugging using libthread_db enabled] [13:42:41.836] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:42:41.836] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [13:42:41.836] Program terminated with signal SIGABRT, Aborted. [13:42:41.836] #0 0x00007fb555ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:42.788] [13:42:42.788] Thread 1 (Thread 0x7fb555bd4f00 (LWP 28833)): [13:42:42.788] #0 0x00007fb555ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:42.788] No symbol table info available. [13:42:42.788] #1 0x00007fb555e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:42.788] No symbol table info available. [13:42:42.788] #2 0x00007fb555e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:42.788] No symbol table info available. [13:42:42.788] #3 0x0000555e7a9ad7b8 in ExceptionalCondition (conditionName=conditionName@entry=0x555e7ac233f5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x555e7ac22910 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [13:42:42.788] No locals. [13:42:42.788] #4 0x0000555e7a32913e in standard_ExecutorStart (queryDesc=queryDesc@entry=0x555e7d8a7880, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [13:42:42.788] estate = 0x555e7d7b6f00 [13:42:42.788] oldcontext = 0x555e7d7dda80 [13:42:42.788] __func__ = "standard_ExecutorStart" [13:42:42.788] #5 0x0000555e7a32931a in ExecutorStart (queryDesc=queryDesc@entry=0x555e7d8a7880, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [13:42:42.788] No locals. [13:42:42.788] #6 0x0000555e7a24d618 in refresh_matview_datafill (dest=0x555e7d817cc8, query=, query@entry=0x555e7d7b2750, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [13:42:42.788] rewritten = [13:42:42.788] plan = 0x555e7d8a6db8 [13:42:42.788] queryDesc = 0x555e7d8a7880 [13:42:42.788] copied_query = [13:42:42.788] processed = [13:42:42.788] __func__ = "refresh_matview_datafill" [13:42:42.788] #7 0x0000555e7a24f97f in RefreshMatViewByOid (matviewOid=28492, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [13:42:42.788] dest = [13:42:42.788] matviewRel = 0x7fb54a3826e8 [13:42:42.788] rule = [13:42:42.788] actions = [13:42:42.788] dataQuery = 0x555e7d7b2750 [13:42:42.788] tableSpace = [13:42:42.788] relowner = 10 [13:42:42.788] OIDNewHeap = 28501 [13:42:42.788] processed = 0 [13:42:42.788] relpersistence = 112 'p' [13:42:42.788] save_userid = 10 [13:42:42.788] save_sec_context = 0 [13:42:42.788] save_nestlevel = 2 [13:42:42.788] address = {classId = 0, objectId = 0, objectSubId = 0} [13:42:42.788] __func__ = "RefreshMatViewByOid" [13:42:42.788] #8 0x0000555e7a24fabe in ExecRefreshMatView (stmt=0x555e7d82ecd0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:42:42.788] matviewOid = [13:42:42.788] lockmode = [13:42:42.788] #9 0x0000555e7a2056d8 in ExecCreateTableAs (pstate=pstate@entry=0x555e7d7ddb80, stmt=stmt@entry=0x555e7d6887f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff45bc3140) at ../src/backend/commands/createas.c:351 [13:42:42.788] refresh = [13:42:42.788] query = 0x555e7d6889b0 [13:42:42.788] into = 0x555e7d688548 [13:42:42.788] jstate = 0x0 [13:42:42.788] is_matview = true [13:42:42.788] do_refresh = false [13:42:42.788] dest = [13:42:42.788] address = {classId = 1259, objectId = 28492, objectSubId = 0} [13:42:42.788] __func__ = "ExecCreateTableAs" [13:42:42.788] #10 0x0000555e7a72404b in ProcessUtilitySlow (pstate=pstate@entry=0x555e7d7ddb80, pstmt=pstmt@entry=0x555e7d6888a0, queryString=queryString@entry=0x555e7d687ab0 "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=0x555e7d6892d8, qc=0x7fff45bc3140) at ../src/backend/tcop/utility.c:1678 [13:42:42.788] _save_exception_stack = 0x7fff45bc3000 [13:42:42.788] _save_context_stack = 0x0 [13:42:42.788] _local_sigjmp_buf = {{__jmpbuf = {0, -4602589124170320803, 93864319289328, 0, 93864319285936, 0, -7682542576684993443, -4602573648330591139}, __mask_was_saved = 0, __saved_mask = {__val = {140416619074304, 10625, 93864269018316, 1, 4294977921, 140416619074304, 93864269008634, 1, 45636132763832, 1, 10625, 140416619074304, 140416619074304, 1, 93864269018663, 93864320530616}}}} [13:42:42.788] _do_rethrow = false [13:42:42.788] parsetree = 0x555e7d6887f0 [13:42:42.788] isTopLevel = true [13:42:42.788] isCompleteQuery = true [13:42:42.788] needCleanup = false [13:42:42.788] commandCollected = false [13:42:42.788] address = {classId = 21854, objectId = 2104002544, objectSubId = 21854} [13:42:42.788] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:42:42.788] __func__ = "ProcessUtilitySlow" [13:42:42.788] #11 0x0000555e7a72265c in standard_ProcessUtility (pstmt=0x555e7d6888a0, queryString=0x555e7d687ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x555e7d6892d8, qc=0x7fff45bc3140) at ../src/backend/tcop/utility.c:1070 [13:42:42.788] parsetree = 0x555e7d6887f0 [13:42:42.788] isTopLevel = true [13:42:42.788] isAtomicContext = false [13:42:42.788] pstate = 0x555e7d7ddb80 [13:42:42.788] readonly_flags = [13:42:42.788] __func__ = "standard_ProcessUtility" [13:42:42.788] #12 0x0000555e7a7227b7 in ProcessUtility (pstmt=pstmt@entry=0x555e7d6888a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x555e7d6892d8, qc=0x7fff45bc3140) at ../src/backend/tcop/utility.c:523 [13:42:42.788] No locals. [13:42:42.788] #13 0x0000555e7a71e023 in PortalRunUtility (portal=portal@entry=0x555e7d70c0c0, pstmt=pstmt@entry=0x555e7d6888a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x555e7d6892d8, qc=qc@entry=0x7fff45bc3140) at ../src/backend/tcop/pquery.c:1158 [13:42:42.788] No locals. [13:42:42.788] #14 0x0000555e7a71e5c8 in PortalRunMulti (portal=portal@entry=0x555e7d70c0c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x555e7d6892d8, altdest=altdest@entry=0x555e7d6892d8, qc=qc@entry=0x7fff45bc3140) at ../src/backend/tcop/pquery.c:1315 [13:42:42.788] pstmt = 0x555e7d6888a0 [13:42:42.788] stmtlist_item__state = [13:42:42.788] active_snapshot_set = false [13:42:42.788] stmtlist_item = 0x555e7d6892a0 [13:42:42.788] #15 0x0000555e7a71eb9b in PortalRun (portal=portal@entry=0x555e7d70c0c0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x555e7d6892d8, altdest=altdest@entry=0x555e7d6892d8, qc=0x7fff45bc3140) at ../src/backend/tcop/pquery.c:791 [13:42:42.788] _save_exception_stack = 0x7fff45bc31f0 [13:42:42.788] _save_context_stack = 0x0 [13:42:42.788] _local_sigjmp_buf = {{__jmpbuf = {0, -4602589125052173219, 93864319828160, 93864319289448, 93864319828160, 93864319289376, -7682542576823405475, -4602573672030112675}, __mask_was_saved = 0, __saved_mask = {__val = {93864272529504, 93864319285680, 112, 4, 93864272533921, 1169961167, 4, 93864319289376, 112, 73, 93864319828160, 93864319289448, 93864319289424, 93864319289376, 93864272621124, 1}}}} [13:42:42.788] _do_rethrow = [13:42:42.788] result = [13:42:42.788] nprocessed = [13:42:42.788] saveTopTransactionResourceOwner = 0x555e7d6c8d78 [13:42:42.788] saveTopTransactionContext = 0x555e7d71e4f0 [13:42:42.788] saveActivePortal = 0x0 [13:42:42.788] saveResourceOwner = 0x555e7d6c8d78 [13:42:42.788] savePortalContext = 0x0 [13:42:42.788] saveMemoryContext = 0x555e7d71e4f0 [13:42:42.788] __func__ = "PortalRun" [13:42:42.788] #16 0x0000555e7a717f7d in exec_simple_query (query_string=query_string@entry=0x555e7d687ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:42:42.788] cmdtaglen = 24 [13:42:42.788] snapshot_set = [13:42:42.788] per_parsetree_context = 0x0 [13:42:42.788] plantree_list = 0x555e7d689288 [13:42:42.788] parsetree = 0x555e7d688820 [13:42:42.788] commandTag = [13:42:42.788] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:42:42.788] querytree_list = [13:42:42.788] portal = 0x555e7d70c0c0 [13:42:42.788] receiver = 0x555e7d6892d8 [13:42:42.788] format = 0 [13:42:42.788] cmdtagname = [13:42:42.788] parsetree_item__state = [13:42:42.788] dest = DestRemote [13:42:42.788] oldcontext = 0x555e7d71e4f0 [13:42:42.788] parsetree_list = 0x555e7d688850 [13:42:42.788] parsetree_item = 0x555e7d688868 [13:42:42.788] save_log_statement_stats = false [13:42:42.788] was_logged = false [13:42:42.788] use_implicit_block = false [13:42:42.788] msec_str = "\004\000\000\000\000\000\000\000/6\235z^U\000\000\3201\274E\377\177\000\000G\000\000\000\000\000\000" [13:42:42.788] __func__ = "exec_simple_query" [13:42:42.788] #17 0x0000555e7a71ad01 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [13:42:42.788] query_string = 0x555e7d687ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:42:42.788] firstchar = [13:42:42.788] input_message = {data = 0x555e7d687ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:42:42.788] local_sigjmp_buf = {{__jmpbuf = {93864285180760, -4602576003942812579, 140734363349836, 4, 10, 140734363350068, -7682542577423190947, -4602573670213847971}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93864319016400, 15616, 93864285174848, 93864319548720, 10, 93864272533469, 0, 9, 2, 93864285180768, 93864319016400, 93864285174848, 4, 10, 140734363350068}}}} [13:42:42.788] send_ready_for_query = false [13:42:42.788] idle_in_transaction_timeout_enabled = false [13:42:42.788] idle_session_timeout_enabled = false [13:42:42.788] __func__ = "PostgresMain" [13:42:42.788] #18 0x0000555e7a710b64 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:42:42.788] bsdata = [13:42:42.788] #19 0x0000555e7a5c284c in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x7fff45bc334c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff45bc33a0) at ../src/backend/postmaster/launch_backend.c:274 [13:42:42.788] pid = [13:42:42.788] #20 0x0000555e7a5c7847 in BackendStartup (client_sock=client_sock@entry=0x7fff45bc33a0) at ../src/backend/postmaster/postmaster.c:3377 [13:42:42.788] bn = 0x555e7d6b01d8 [13:42:42.788] pid = [13:42:42.788] startup_data = {canAcceptConnections = CAC_OK} [13:42:42.788] cac = [13:42:42.788] __func__ = "BackendStartup" [13:42:42.788] #21 0x0000555e7a5c9720 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [13:42:42.788] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\274E\377\177\000\00044\274E\377\177", '\000' , "\022\343vy^U\000\000h\307ry^U\000\000\0005\274E\377\177\000\000\3704\274E\377\177\000\000\225[\362\001\000\000\000\000\240\224\310V\265\177\000\000+", '\000' , " \342vy^U\000\000h\266jW\265\177\000\0000\226\310V\265\177\000", __ss_align = 140416832418528}, salen = 2}} [13:42:42.788] i = 0 [13:42:42.788] now = [13:42:42.788] last_lockfile_recheck_time = 1732973911 [13:42:42.788] last_touch_time = 1732973911 [13:42:42.788] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 2037834514, events = 21854, fd = 1466611304, user_data = 0x7fb556c89630}, {pos = 1466610400, events = 32693, fd = 2090263927, user_data = 0x7fff45bc3580}, {pos = 1466440264, events = 32693, fd = 15, user_data = 0x7fb556c89630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1466610400, events = 32693, fd = 1169962232, user_data = 0x7fff45bc3500}, {pos = 1466611304, events = 32693, fd = 0, user_data = 0x555e7d687b70}, {pos = 2057565294, events = 21854, fd = 32768, user_data = 0x1}, {pos = 2104006560, events = 21854, fd = -1, user_data = 0x7fb555e2e020}, {pos = 1463000992, events = 32693, fd = 2104176984, user_data = 0x555e7d6b3038}, {pos = 2104185889, events = 21854, fd = 1466465982, user_data = 0x1}, {pos = 1466610400, events = 32693, fd = 427, user_data = 0x555e7af52d58 }, {pos = 0, events = 0, fd = 236, user_data = 0x555e7d687b70}, {pos = 1466465982, events = 32693, fd = 1, user_data = 0x0}, {pos = 1440931872, events = 32693, fd = 1441738304, user_data = 0x10}, {pos = 1169963360, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1466474938, user_data = 0x0}, {pos = 1441459620, events = 32693, fd = 0, user_data = 0x555e7b5f1700 }, {pos = 2, events = 0, fd = 0, user_data = 0x555e7d649e70}, {pos = 2053810926, events = 21854, fd = 2104208603, user_data = 0x555e7a6ae727 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x555e7d687b70}, {pos = 1466465982, events = 32693, fd = 1, user_data = 0x0}, {pos = 1440965832, events = 32693, fd = 1441384576, user_data = 0x42d}, {pos = 1441492743, events = 32693, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 1442782304, events = 32693, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x6152634a2d737365}, {pos = 168457577, events = 874520608, fd = 822763892, user_data = 0x30340a3131393337}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, 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 = 0, user_data = 0xa}, {pos = 2057242720, events = 21854, fd = 2104192080, user_data = 0x7fb555eb576b}, {pos = 1442765280, events = 32693, fd = 1441403246, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xd7080c1e2debfb00}, {pos = 1442768352, events = 32693, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2104176376, user_data = 0x3}, {pos = 0, events = 0, fd = 24986, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2103999344, user_data = 0x7fb555ef3053 }, {pos = 2104176376, events = 21854, fd = 1024, user_data = 0x7fff45bc3a28}, {pos = 2057326036, events = 21854, fd = 2069893904, user_data = 0x555e7a9f3891 }, {pos = 2104176176, events = 21854, fd = 2103998896, user_data = 0x555e7d6b2e30}, {pos = 1441486699, events = 32693, fd = 0, user_data = 0x555e7aa054fb }, {pos = 2104176176, events = 1, fd = 2057328196, user_data = 0x555e7d6879b0}, {pos = 770439936, events = 3607628830, fd = 0, user_data = 0x7fb555ea2ab1}, {pos = 1441404144, events = 32693, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2103746160, user_data = 0xd7080c1e2debfb00}, {pos = 0, events = 0, fd = 770439936, user_data = 0xc}, {pos = 770439936, events = 3607628830, fd = 0, user_data = 0x7fb555e5b239 }, {pos = 237, events = 0, fd = 2052859209, user_data = 0x400000}, {pos = 0, events = 0, fd = 2103746160, user_data = 0x555e7a9f3725 }, {pos = 2103832800, events = 21854, fd = 2103998896, user_data = 0x555e7d65f0e0}, {pos = 1, events = 0, fd = 0, user_data = 0x555e7a9b2122 }, {pos = 12, events = 0, fd = 2104175752, user_data = 0x555e7d6b2c68}, {pos = 2069830784, events = 21854, fd = 296, user_data = 0x555e7a5c4d63 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 2052875680, events = 21854, fd = 2066260240, user_data = 0x555e7d688388}} [13:42:42.788] nevents = 1 [13:42:42.788] __func__ = "ServerLoop" [13:42:42.788] #22 0x0000555e7a5caf43 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x555e7d645d30) at ../src/backend/postmaster/postmaster.c:1361 [13:42:42.788] opt = [13:42:42.788] status = [13:42:42.788] userDoption = [13:42:42.788] listen_addr_saved = false [13:42:42.788] output_config_variable = [13:42:42.788] __func__ = "PostmasterMain" [13:42:42.788] #23 0x0000555e7a4031c6 in main (argc=8, argv=0x555e7d645d30) at ../src/backend/main/main.c:196 [13:42:42.788] do_check_root = [13:42:42.824] -e [13:42:42.824] [13:42:42.824] [13:42:42.889] dumping /tmp/cores/postgres-6-36291.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:42:43.148] [New LWP 36291] [13:42:43.148] [13:42:43.148] This GDB supports auto-downloading debuginfo from the following URLs: [13:42:43.148] [13:42:43.148] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:42:43.148] Debuginfod has been disabled. [13:42:43.148] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:42:43.254] [Thread debugging using libthread_db enabled] [13:42:43.254] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:42:43.254] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [13:42:43.254] Program terminated with signal SIGABRT, Aborted. [13:42:43.254] #0 0x00007f7acc2a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:44.178] [13:42:44.178] Thread 1 (Thread 0x7f7acca39f00 (LWP 36291)): [13:42:44.178] #0 0x00007f7acc2a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:44.178] No symbol table info available. [13:42:44.178] #1 0x00007f7acc25afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:44.178] No symbol table info available. [13:42:44.178] #2 0x00007f7acc245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:44.178] No symbol table info available. [13:42:44.178] #3 0x000055bad5e817b8 in ExceptionalCondition (conditionName=conditionName@entry=0x55bad60f73f5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55bad60f6910 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [13:42:44.178] No locals. [13:42:44.178] #4 0x000055bad57fd13e in standard_ExecutorStart (queryDesc=0x55bad8bfbae0, eflags=0) at ../src/backend/executor/execMain.c:195 [13:42:44.178] estate = 0x55bad8ad97a0 [13:42:44.178] oldcontext = 0x55bad8bb4260 [13:42:44.178] __func__ = "standard_ExecutorStart" [13:42:44.178] #5 0x00007f7aca25a6f7 in pgss_ExecutorStart (queryDesc=0x55bad8bfbae0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [13:42:44.178] No locals. [13:42:44.178] #6 0x000055bad57fd2d3 in ExecutorStart (queryDesc=queryDesc@entry=0x55bad8bfbae0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [13:42:44.178] No locals. [13:42:44.178] #7 0x000055bad5721618 in refresh_matview_datafill (dest=0x55bad8b3a928, query=, query@entry=0x55bad8b89370, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [13:42:44.178] rewritten = [13:42:44.178] plan = 0x55bad8bfb018 [13:42:44.178] queryDesc = 0x55bad8bfbae0 [13:42:44.178] copied_query = [13:42:44.178] processed = [13:42:44.178] __func__ = "refresh_matview_datafill" [13:42:44.178] #8 0x000055bad572397f in RefreshMatViewByOid (matviewOid=28315, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [13:42:44.178] dest = [13:42:44.178] matviewRel = 0x7f7ac7d218e8 [13:42:44.178] rule = [13:42:44.178] actions = [13:42:44.178] dataQuery = 0x55bad8b89370 [13:42:44.178] tableSpace = [13:42:44.178] relowner = 10 [13:42:44.178] OIDNewHeap = 28336 [13:42:44.178] processed = 0 [13:42:44.178] relpersistence = 112 'p' [13:42:44.178] save_userid = 10 [13:42:44.178] save_sec_context = 0 [13:42:44.178] save_nestlevel = 2 [13:42:44.178] address = {classId = 0, objectId = 0, objectSubId = 0} [13:42:44.178] __func__ = "RefreshMatViewByOid" [13:42:44.178] #9 0x000055bad5723abe in ExecRefreshMatView (stmt=0x55bad8b27510, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:42:44.178] matviewOid = [13:42:44.178] lockmode = [13:42:44.178] #10 0x000055bad56d96d8 in ExecCreateTableAs (pstate=pstate@entry=0x55bad8bb4360, stmt=stmt@entry=0x55bad89e1790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcb3f8ad30) at ../src/backend/commands/createas.c:351 [13:42:44.178] refresh = [13:42:44.178] query = 0x55bad89e1950 [13:42:44.178] into = 0x55bad89e14e8 [13:42:44.178] jstate = 0x0 [13:42:44.178] is_matview = true [13:42:44.178] do_refresh = false [13:42:44.178] dest = [13:42:44.178] address = {classId = 1259, objectId = 28315, objectSubId = 0} [13:42:44.178] __func__ = "ExecCreateTableAs" [13:42:44.178] #11 0x000055bad5bf804b in ProcessUtilitySlow (pstate=pstate@entry=0x55bad8bb4360, pstmt=pstmt@entry=0x55bad89e1840, queryString=queryString@entry=0x55bad89e0a50 "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=0x55bad89e27e8, qc=0x7ffcb3f8ad30) at ../src/backend/tcop/utility.c:1678 [13:42:44.178] _save_exception_stack = 0x7ffcb3f8a8e0 [13:42:44.178] _save_context_stack = 0x0 [13:42:44.178] _local_sigjmp_buf = {{__jmpbuf = {0, -7492661459654154297, 94260986517392, 0, 94260986514000, 0, -3708592432776091705, -7492685367059683385}, __mask_was_saved = 0, __saved_mask = {__val = {114, 3, 140165389425760, 1023, 18446744073709551344, 64, 0, 94260987847632, 140165388139146, 1, 94260941310048, 94260988731072, 120, 94260986513744, 94260941310048, 94260986513744}}}} [13:42:44.178] _do_rethrow = false [13:42:44.178] parsetree = 0x55bad89e1790 [13:42:44.178] isTopLevel = true [13:42:44.178] isCompleteQuery = true [13:42:44.178] needCleanup = false [13:42:44.178] commandCollected = false [13:42:44.178] address = {classId = 21946, objectId = 3634239376, objectSubId = 21946} [13:42:44.178] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:42:44.178] __func__ = "ProcessUtilitySlow" [13:42:44.178] #12 0x000055bad5bf665c in standard_ProcessUtility (pstmt=pstmt@entry=0x55bad89e1840, queryString=queryString@entry=0x55bad89e0a50 "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=0x55bad89e27e8, qc=0x7ffcb3f8ad30) at ../src/backend/tcop/utility.c:1070 [13:42:44.178] parsetree = 0x55bad89e1790 [13:42:44.178] isTopLevel = true [13:42:44.178] isAtomicContext = false [13:42:44.178] pstate = 0x55bad8bb4360 [13:42:44.178] readonly_flags = [13:42:44.178] __func__ = "standard_ProcessUtility" [13:42:44.178] #13 0x00007f7aca25dd9d in pgss_ProcessUtility (pstmt=0x55bad89e1840, queryString=0x55bad89e0a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55bad89e27e8, qc=0x7ffcb3f8ad30) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [13:42:44.178] _save_exception_stack = 0x7ffcb3f8abf0 [13:42:44.178] _save_context_stack = 0x0 [13:42:44.178] _local_sigjmp_buf = {{__jmpbuf = {0, 3706754025430837191, 94260986517568, 94260986521576, 140723327905072, 0, -3708592432738342969, -3637609502672558137}, __mask_was_saved = 0, __saved_mask = {__val = {94260941632896, 140723327904342, 140723327904340, 0, 0, 139637976727552, 206158430232, 140723327904304, 94260941633113, 0, 206158430232, 94260986518368, 140723327904400, 0, 94260936431724, 94260986513744}}}} [13:42:44.178] _do_rethrow = false [13:42:44.178] duration = [13:42:44.178] bufusage = {shared_blks_hit = 94260987534296, shared_blks_read = 798863917056, shared_blks_dirtied = 0, shared_blks_written = 94260987533800, local_blks_hit = 94260987534296, local_blks_read = 94260934750667, local_blks_dirtied = 94260988715544, local_blks_written = 94260934750913, temp_blks_read = 94260987533800, temp_blks_written = 94260987533216, shared_blk_read_time = {ticks = 94260934750022}, shared_blk_write_time = {ticks = 94260941626348}, local_blk_read_time = {ticks = 140165396012472}, local_blk_write_time = {ticks = 94260986514000}, temp_blk_read_time = {ticks = 94260943958053}, temp_blk_write_time = {ticks = 94260953952738}} [13:42:44.178] walusage_start = {wal_records = 8968, wal_fpi = 114, wal_bytes = 1141635} [13:42:44.178] start = [13:42:44.178] rows = [13:42:44.178] bufusage_start = {shared_blks_hit = 34455, shared_blks_read = 4274, shared_blks_dirtied = 1433, shared_blks_written = 1119, 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}} [13:42:44.178] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 140165317894464} [13:42:44.178] parsetree = [13:42:44.178] saved_queryId = 6041762721901209185 [13:42:44.178] saved_stmt_location = 0 [13:42:44.178] saved_stmt_len = 69 [13:42:44.178] enabled = true [13:42:44.178] #14 0x000055bad5bf6702 in ProcessUtility (pstmt=pstmt@entry=0x55bad89e1840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55bad89e27e8, qc=0x7ffcb3f8ad30) at ../src/backend/tcop/utility.c:519 [13:42:44.178] No locals. [13:42:44.178] #15 0x000055bad5bf2023 in PortalRunUtility (portal=portal@entry=0x55bad8a63fc0, pstmt=pstmt@entry=0x55bad89e1840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55bad89e27e8, qc=qc@entry=0x7ffcb3f8ad30) at ../src/backend/tcop/pquery.c:1158 [13:42:44.178] No locals. [13:42:44.178] #16 0x000055bad5bf25c8 in PortalRunMulti (portal=portal@entry=0x55bad8a63fc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55bad89e27e8, altdest=altdest@entry=0x55bad89e27e8, qc=qc@entry=0x7ffcb3f8ad30) at ../src/backend/tcop/pquery.c:1315 [13:42:44.178] pstmt = 0x55bad89e1840 [13:42:44.178] stmtlist_item__state = [13:42:44.178] active_snapshot_set = false [13:42:44.178] stmtlist_item = 0x55bad89e27b0 [13:42:44.178] #17 0x000055bad5bf2b9b in PortalRun (portal=portal@entry=0x55bad8a63fc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55bad89e27e8, altdest=altdest@entry=0x55bad89e27e8, qc=0x7ffcb3f8ad30) at ../src/backend/tcop/pquery.c:791 [13:42:44.178] _save_exception_stack = 0x7ffcb3f8ade0 [13:42:44.178] _save_context_stack = 0x0 [13:42:44.178] _local_sigjmp_buf = {{__jmpbuf = {0, -7492661458961045561, 94260987051968, 94260986517512, 94260987051968, 94260986517440, -3708592432895629369, -7492685364854134841}, __mask_was_saved = 0, __saved_mask = {__val = {94260941310048, 94260986513744, 112, 4, 94260941314465, 3019418815, 4, 94260986517440, 112, 73, 94260987051968, 94260986517512, 94260986517488, 94260986517440, 94260941401668, 1}}}} [13:42:44.178] _do_rethrow = [13:42:44.178] result = [13:42:44.178] nprocessed = [13:42:44.178] saveTopTransactionResourceOwner = 0x55bad8a23498 [13:42:44.178] saveTopTransactionContext = 0x55bad8a75fe0 [13:42:44.178] saveActivePortal = 0x0 [13:42:44.178] saveResourceOwner = 0x55bad8a23498 [13:42:44.178] savePortalContext = 0x0 [13:42:44.178] saveMemoryContext = 0x55bad8a75fe0 [13:42:44.178] __func__ = "PortalRun" [13:42:44.178] #18 0x000055bad5bebf7d in exec_simple_query (query_string=query_string@entry=0x55bad89e0a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:42:44.178] cmdtaglen = 24 [13:42:44.178] snapshot_set = [13:42:44.178] per_parsetree_context = 0x0 [13:42:44.178] plantree_list = 0x55bad89e2798 [13:42:44.178] parsetree = 0x55bad89e17c0 [13:42:44.178] commandTag = [13:42:44.178] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:42:44.178] querytree_list = [13:42:44.178] portal = 0x55bad8a63fc0 [13:42:44.178] receiver = 0x55bad89e27e8 [13:42:44.178] format = 0 [13:42:44.178] cmdtagname = [13:42:44.178] parsetree_item__state = [13:42:44.178] dest = DestRemote [13:42:44.178] oldcontext = 0x55bad8a75fe0 [13:42:44.178] parsetree_list = 0x55bad89e17f0 [13:42:44.178] parsetree_item = 0x55bad89e1808 [13:42:44.178] save_log_statement_stats = false [13:42:44.178] was_logged = true [13:42:44.178] use_implicit_block = false [13:42:44.178] msec_str = "\004\000\000\000\000\000\000\000/v\352պU\000\000\300\255\370\263\374\177\000\000G\000\000\000\000\000\000" [13:42:44.178] __func__ = "exec_simple_query" [13:42:44.178] #19 0x000055bad5beed01 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [13:42:44.178] query_string = 0x55bad89e0a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:42:44.178] firstchar = [13:42:44.178] input_message = {data = 0x55bad89e0a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:42:44.178] local_sigjmp_buf = {{__jmpbuf = {94260953961304, -7492683013641345081, 140723327905596, 4, 4, 140723327905828, -3708592433092761657, -7492685379815086137}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94260986771824, 0, 168, 94260941314567, 0, 10, 2, 94260953961312, 94260986244592, 94260953955392, 4, 4, 140723327905828}}}} [13:42:44.178] send_ready_for_query = false [13:42:44.178] idle_in_transaction_timeout_enabled = false [13:42:44.178] idle_session_timeout_enabled = false [13:42:44.178] __func__ = "PostgresMain" [13:42:44.178] #20 0x000055bad5be4b64 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:42:44.178] bsdata = [13:42:44.178] #21 0x000055bad5a9684c in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x7ffcb3f8af3c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcb3f8af90) at ../src/backend/postmaster/launch_backend.c:274 [13:42:44.178] pid = [13:42:44.178] #22 0x000055bad5a9b847 in BackendStartup (client_sock=client_sock@entry=0x7ffcb3f8af90) at ../src/backend/postmaster/postmaster.c:3377 [13:42:44.178] bn = 0x55bad8a0d148 [13:42:44.178] pid = [13:42:44.178] startup_data = {canAcceptConnections = CAC_OK} [13:42:44.178] cac = [13:42:44.178] __func__ = "BackendStartup" [13:42:44.178] #23 0x000055bad5a9d720 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [13:42:44.178] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "#\314z\177\000\000\240\357{\315z\177\000\0008\260\370\263\374\177\000\0004\260\370\263\374\177", '\000' , "\022#\304ԺU\000\000h\a\300ԺU\000\000\000\261\370\263\374\177\000\000\370\260\370\263\374\177\000\000\225[\362\001\000\000\000\000p\252\240غU\000\000,", '\000' , "\272U\000\000 \"\304ԺU\000", __ss_align = 140165415110248}, salen = 2}} [13:42:44.178] i = 0 [13:42:44.178] now = [13:42:44.178] last_lockfile_recheck_time = 1732973948 [13:42:44.178] last_touch_time = 1732973948 [13:42:44.178] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55bad4c42312}, {pos = -842594712, events = 32634, fd = -855034320, user_data = 0x7f7acdc702e0}, {pos = 2090263927, events = 0, fd = -1275547264, user_data = 0x7f7acdc46a48}, {pos = 15, events = 0, fd = -855034320, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f7acdc702e0}, {pos = -1275547400, events = 32764, fd = -1275547392, user_data = 0x7f7acdc70668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -660728464, events = 21946, fd = 1, user_data = 0x7ffcb3f8b623}, {pos = -1, events = 0, fd = -870129632, user_data = 0x7f7acd7befa0}, {pos = -660531624, events = 21946, fd = -660531912, user_data = 0x55bad8a17101}, {pos = -842740034, events = 32634, fd = 1, user_data = 0x7f7acdc702e0}, {pos = 427, events = 0, fd = -700289704, user_data = 0x0}, {pos = 86, events = 0, fd = -660541240, user_data = 0x7f7acdc4cebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f7acc22e020}, {pos = -869323200, events = 32634, fd = 16, user_data = 0x7ffcb3f8b550}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -842731078, events = 32634, fd = 0, user_data = 0x7f7acc2aeda4 }, {pos = 0, events = 0, fd = -693348608, user_data = 0x2}, {pos = 0, events = 0, fd = -660984176, user_data = 0x55bad5b82727 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -660541240, user_data = 0x7f7acdc4cebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f7acc2364c8}, {pos = -869568761, events = 32634, fd = -693292448, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -868279200, events = 32634, 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 = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = -855030464, events = 32634, fd = -855029120, 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 = -660502224, user_data = 0x7f7acc2b576b}, {pos = -868296224, events = 32634, fd = -869658258, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x4ea5d7922eac5600}, {pos = -868293152, events = 32634, fd = -328, user_data = 0x0}, {pos = -660532232, events = 21946, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 32131, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -660541240, user_data = 0x7f7acc2f3053 }, {pos = -660532232, events = 21946, fd = 1024, user_data = 0x7ffcb3f8b618}, {pos = -705851948, events = 21946, fd = -693284080, user_data = 0x55bad5ec7891 }, {pos = -660532432, events = 21946, fd = -660731568, user_data = 0x55bad8a11330}, {pos = -869574805, events = 32634, fd = 0, user_data = 0x55bad5ed94fb }, {pos = -660532432, events = 1, fd = -705849788, user_data = 0x55bad89e0950}, {pos = 783046144, events = 1319491474, fd = 0, user_data = 0x7f7acc2a2ab1}, {pos = -869657360, events = 32634, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -660984176, user_data = 0x4ea5d7922eac5600}, {pos = 0, events = 0, fd = 783046144, user_data = 0xc}, {pos = 783046144, events = 1319491474, fd = 0, user_data = 0x7f7acc25b239 }, {pos = 87, events = 0, fd = -710318775, user_data = 0x400000}, {pos = 0, events = 0, fd = -660984176, user_data = 0x55bad5ec7725 }, {pos = -660897664, events = 21946, fd = -660731568, user_data = 0x55bad89b8080}, {pos = 1, events = 0, fd = 0, user_data = 0x55bad5e86122 }, {pos = 12, events = 0, fd = -660545288, user_data = 0x55bad8a0e0d8}, {pos = -693347200, events = 21946, fd = 296, user_data = 0x55bad5a98d63 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -710302304, events = 21946, fd = -696917744, user_data = 0x55bad89e1308}} [13:42:44.179] nevents = 1 [13:42:44.179] __func__ = "ServerLoop" [13:42:44.179] #24 0x000055bad5a9ef43 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55bad899ecf0) at ../src/backend/postmaster/postmaster.c:1361 [13:42:44.179] opt = [13:42:44.179] status = [13:42:44.179] userDoption = [13:42:44.179] listen_addr_saved = false [13:42:44.179] output_config_variable = [13:42:44.179] __func__ = "PostmasterMain" [13:42:44.179] #25 0x000055bad58d71c6 in main (argc=4, argv=0x55bad899ecf0) at ../src/backend/main/main.c:196 [13:42:44.179] do_check_root = [13:42:44.216] -e [13:42:44.216] [13:42:44.216] [13:42:44.283] dumping /tmp/cores/postgres-6-29572.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:42:44.543] [New LWP 29572] [13:42:44.543] [13:42:44.543] This GDB supports auto-downloading debuginfo from the following URLs: [13:42:44.543] [13:42:44.543] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:42:44.543] Debuginfod has been disabled. [13:42:44.543] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:42:44.650] [Thread debugging using libthread_db enabled] [13:42:44.650] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:42:44.650] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [13:42:44.650] Program terminated with signal SIGABRT, Aborted. [13:42:44.650] #0 0x00007ff0e4ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:45.571] [13:42:45.571] Thread 1 (Thread 0x7ff0e5637f00 (LWP 29572)): [13:42:45.571] #0 0x00007ff0e4ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:45.571] No symbol table info available. [13:42:45.571] #1 0x00007ff0e4e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:45.571] No symbol table info available. [13:42:45.571] #2 0x00007ff0e4e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:42:45.571] No symbol table info available. [13:42:45.571] #3 0x0000558bd8fa77b8 in ExceptionalCondition (conditionName=conditionName@entry=0x558bd921d3f5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x558bd921c910 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [13:42:45.571] No locals. [13:42:45.571] #4 0x0000558bd892313e in standard_ExecutorStart (queryDesc=queryDesc@entry=0x558bdad7c680, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [13:42:45.571] estate = 0x558bdac8a7f0 [13:42:45.571] oldcontext = 0x558bdac82480 [13:42:45.571] __func__ = "standard_ExecutorStart" [13:42:45.571] #5 0x0000558bd892331a in ExecutorStart (queryDesc=queryDesc@entry=0x558bdad7c680, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [13:42:45.571] No locals. [13:42:45.571] #6 0x0000558bd8847618 in refresh_matview_datafill (dest=0x558bdad796f8, query=, query@entry=0x558bdad08af0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [13:42:45.571] rewritten = [13:42:45.571] plan = 0x558bdad7bbb8 [13:42:45.571] queryDesc = 0x558bdad7c680 [13:42:45.571] copied_query = [13:42:45.571] processed = [13:42:45.571] __func__ = "refresh_matview_datafill" [13:42:45.571] #7 0x0000558bd884997f in RefreshMatViewByOid (matviewOid=28512, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [13:42:45.571] dest = [13:42:45.571] matviewRel = 0x7ff0d9713478 [13:42:45.571] rule = [13:42:45.571] actions = [13:42:45.571] dataQuery = 0x558bdad08af0 [13:42:45.571] tableSpace = [13:42:45.571] relowner = 10 [13:42:45.571] OIDNewHeap = 28535 [13:42:45.571] processed = 0 [13:42:45.571] relpersistence = 112 'p' [13:42:45.571] save_userid = 10 [13:42:45.571] save_sec_context = 0 [13:42:45.571] save_nestlevel = 2 [13:42:45.571] address = {classId = 0, objectId = 0, objectSubId = 0} [13:42:45.571] __func__ = "RefreshMatViewByOid" [13:42:45.571] #8 0x0000558bd8849abe in ExecRefreshMatView (stmt=0x558bdad36af0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:42:45.571] matviewOid = [13:42:45.571] lockmode = [13:42:45.571] #9 0x0000558bd87ff6d8 in ExecCreateTableAs (pstate=pstate@entry=0x558bdac82580, stmt=stmt@entry=0x558bdab5c770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffda815acd0) at ../src/backend/commands/createas.c:351 [13:42:45.571] refresh = [13:42:45.571] query = 0x558bdab5c930 [13:42:45.571] into = 0x558bdab5c4c8 [13:42:45.571] jstate = 0x0 [13:42:45.571] is_matview = true [13:42:45.571] do_refresh = false [13:42:45.571] dest = [13:42:45.571] address = {classId = 1259, objectId = 28512, objectSubId = 0} [13:42:45.571] __func__ = "ExecCreateTableAs" [13:42:45.571] #10 0x0000558bd8d1e04b in ProcessUtilitySlow (pstate=pstate@entry=0x558bdac82580, pstmt=pstmt@entry=0x558bdab5c820, queryString=queryString@entry=0x558bdab5ba30 "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=0x558bdab5d258, qc=0x7ffda815acd0) at ../src/backend/tcop/utility.c:1678 [13:42:45.571] _save_exception_stack = 0x7ffda815ab90 [13:42:45.571] _save_context_stack = 0x0 [13:42:45.571] _local_sigjmp_buf = {{__jmpbuf = {0, -2549568138638960468, 94059158161264, 0, 94059158157872, 0, -8614550415859165012, -2549572296185784148}, __mask_was_saved = 0, __saved_mask = {__val = {140672422304512, 15269, 94059125871820, 1, 4294982565, 140672422304512, 94059129699308, 140672617381304, 94059158157872, 94059132031013, 94059142025698, 94059142025824, 140727423445460, 94059132225881, 94059142025713, 94059142025824}}}} [13:42:45.571] _do_rethrow = false [13:42:45.571] parsetree = 0x558bdab5c770 [13:42:45.571] isTopLevel = true [13:42:45.571] isCompleteQuery = true [13:42:45.571] needCleanup = false [13:42:45.571] commandCollected = false [13:42:45.571] address = {classId = 21899, objectId = 3669346160, objectSubId = 21899} [13:42:45.571] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:42:45.571] __func__ = "ProcessUtilitySlow" [13:42:45.571] #11 0x0000558bd8d1c65c in standard_ProcessUtility (pstmt=0x558bdab5c820, queryString=0x558bdab5ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x558bdab5d258, qc=0x7ffda815acd0) at ../src/backend/tcop/utility.c:1070 [13:42:45.571] parsetree = 0x558bdab5c770 [13:42:45.571] isTopLevel = true [13:42:45.571] isAtomicContext = false [13:42:45.571] pstate = 0x558bdac82580 [13:42:45.571] readonly_flags = [13:42:45.571] __func__ = "standard_ProcessUtility" [13:42:45.571] #12 0x0000558bd8d1c7b7 in ProcessUtility (pstmt=pstmt@entry=0x558bdab5c820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x558bdab5d258, qc=0x7ffda815acd0) at ../src/backend/tcop/utility.c:523 [13:42:45.571] No locals. [13:42:45.571] #13 0x0000558bd8d18023 in PortalRunUtility (portal=portal@entry=0x558bdabdd7a0, pstmt=pstmt@entry=0x558bdab5c820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x558bdab5d258, qc=qc@entry=0x7ffda815acd0) at ../src/backend/tcop/pquery.c:1158 [13:42:45.571] No locals. [13:42:45.571] #14 0x0000558bd8d185c8 in PortalRunMulti (portal=portal@entry=0x558bdabdd7a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x558bdab5d258, altdest=altdest@entry=0x558bdab5d258, qc=qc@entry=0x7ffda815acd0) at ../src/backend/tcop/pquery.c:1315 [13:42:45.571] pstmt = 0x558bdab5c820 [13:42:45.571] stmtlist_item__state = [13:42:45.571] active_snapshot_set = false [13:42:45.571] stmtlist_item = 0x558bdab5d220 [13:42:45.571] #15 0x0000558bd8d18b9b in PortalRun (portal=portal@entry=0x558bdabdd7a0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x558bdab5d258, altdest=altdest@entry=0x558bdab5d258, qc=0x7ffda815acd0) at ../src/backend/tcop/pquery.c:791 [13:42:45.571] _save_exception_stack = 0x7ffda815ad80 [13:42:45.571] _save_context_stack = 0x0 [13:42:45.571] _local_sigjmp_buf = {{__jmpbuf = {0, -2549568139520812884, 94059158689696, 94059158161384, 94059158689696, 94059158161312, -8614550415443928916, -2549572294115501908}, __mask_was_saved = 0, __saved_mask = {__val = {94059129383008, 94059158157616, 112, 4, 94059129387425, 2819992671, 4, 94059158161312, 112, 73, 94059158689696, 94059158161384, 94059158161360, 94059158161312, 94059129474628, 1}}}} [13:42:45.571] _do_rethrow = [13:42:45.571] result = [13:42:45.571] nprocessed = [13:42:45.571] saveTopTransactionResourceOwner = 0x558bdab9a958 [13:42:45.571] saveTopTransactionContext = 0x558bdabf1c10 [13:42:45.571] saveActivePortal = 0x0 [13:42:45.571] saveResourceOwner = 0x558bdab9a958 [13:42:45.571] savePortalContext = 0x0 [13:42:45.571] saveMemoryContext = 0x558bdabf1c10 [13:42:45.571] __func__ = "PortalRun" [13:42:45.571] #16 0x0000558bd8d11f7d in exec_simple_query (query_string=query_string@entry=0x558bdab5ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:42:45.571] cmdtaglen = 24 [13:42:45.571] snapshot_set = [13:42:45.571] per_parsetree_context = 0x0 [13:42:45.571] plantree_list = 0x558bdab5d208 [13:42:45.571] parsetree = 0x558bdab5c7a0 [13:42:45.571] commandTag = [13:42:45.571] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:42:45.571] querytree_list = [13:42:45.571] portal = 0x558bdabdd7a0 [13:42:45.571] receiver = 0x558bdab5d258 [13:42:45.571] format = 0 [13:42:45.571] cmdtagname = [13:42:45.571] parsetree_item__state = [13:42:45.571] dest = DestRemote [13:42:45.571] oldcontext = 0x558bdabf1c10 [13:42:45.571] parsetree_list = 0x558bdab5c7d0 [13:42:45.571] parsetree_item = 0x558bdab5c7e8 [13:42:45.571] save_log_statement_stats = false [13:42:45.571] was_logged = true [13:42:45.571] use_implicit_block = false [13:42:45.571] msec_str = "\004\000\000\000\000\000\000\000/\326\374؋U\000\000`\255\025\250\375\177\000\000G\000\000\000\000\000\000" [13:42:45.571] __func__ = "exec_simple_query" [13:42:45.571] #17 0x0000558bd8d14d01 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [13:42:45.571] query_string = 0x558bdab5ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:42:45.571] firstchar = [13:42:45.571] input_message = {data = 0x558bdab5ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:42:45.571] local_sigjmp_buf = {{__jmpbuf = {94059142034264, -2549570249388894036, 140727423446748, 4, 20, 140727423446980, -8614550415523620692, -2549572300889171796}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94059157888432, 14336, 94059142028352, 94059158411536, 20, 94059129386973, 0, 9, 2, 94059142034272, 94059157888432, 94059142028352, 4, 20, 140727423446980}}}} [13:42:45.571] send_ready_for_query = false [13:42:45.571] idle_in_transaction_timeout_enabled = false [13:42:45.571] idle_session_timeout_enabled = false [13:42:45.571] __func__ = "PostgresMain" [13:42:45.571] #18 0x0000558bd8d0ab64 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:42:45.571] bsdata = [13:42:45.571] #19 0x0000558bd8bbc84c in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x7ffda815aedc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffda815af30) at ../src/backend/postmaster/launch_backend.c:274 [13:42:45.571] pid = [13:42:45.571] #20 0x0000558bd8bc1847 in BackendStartup (client_sock=client_sock@entry=0x7ffda815af30) at ../src/backend/postmaster/postmaster.c:3377 [13:42:45.571] bn = 0x558bdab83608 [13:42:45.571] pid = [13:42:45.571] startup_data = {canAcceptConnections = CAC_OK} [13:42:45.571] cac = [13:42:45.571] __func__ = "BackendStartup" [13:42:45.571] #21 0x0000558bd8bc3720 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [13:42:45.571] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\022\203\326\327\213U\000\000hg\322\327\213U\000\000\200\260\025\250\375\177\000\000x\260\025\250\375\177\000\000\225[\362\001\000\000\000\000\240\204\310\345\360\177\000\000+", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\246n\346\360\177\000\0000\206\310\345\360\177\000\000\340\242n\346\360\177\000\000\316)fR\000\000\000", __ss_align = 2819993792}, salen = 2}} [13:42:45.571] i = 0 [13:42:45.571] now = [13:42:45.571] last_lockfile_recheck_time = 1732973913 [13:42:45.571] last_touch_time = 1732973913 [13:42:45.571] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -439843280, events = 32752, fd = -428956960, user_data = 0x7c96e577}, {pos = -1474973440, events = 32765, fd = -429127096, user_data = 0xf}, {pos = -439843280, events = 32752, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -428956960, user_data = 0x7ffda815b078}, {pos = -1474973568, events = 32765, fd = -428956056, user_data = 0x0}, {pos = -625624504, events = 21899, fd = -454329718, user_data = 0x558bdab5ba48}, {pos = 1, events = 21899, fd = 32768, user_data = 0xffffffff}, {pos = -454893536, events = 32752, fd = -432795744, user_data = 0x558bdab87008}, {pos = -625447192, events = 21899, fd = -625449807, user_data = 0x7ff0e66c6ebe}, {pos = 1, events = 0, fd = -428956960, user_data = 0x1ab}, {pos = -648753832, events = 21899, fd = 0, user_data = 0xd8}, {pos = -625624504, events = 21899, fd = -429101378, user_data = 0x1}, {pos = 0, events = 0, fd = -454893536, user_data = 0x7ff0e4ef2e40 }, {pos = 16, events = 0, fd = -1474972432, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7ff0e66c91ba}, {pos = 0, events = 0, fd = -454365788, user_data = 0x0}, {pos = -641812736, events = 21899, fd = 2, user_data = 0x0}, {pos = -625877424, events = 21899, fd = -657835175, user_data = 0x558bdab8e7b0}, {pos = -657831186, events = 21899, fd = -625416181, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -454859576, user_data = 0x7ff0e4e9c880 }, {pos = -446464584, events = 32752, fd = -1474972240, user_data = 0x100007f00000002}, {pos = -454332665, events = 32752, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -453043104, events = 32752, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 171061792, events = 1633760817, fd = 894458448, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -625442992, events = 21899, fd = -454329718, user_data = 0xa}, {pos = -654399392, events = 21899, fd = -625434768, user_data = 0x7ff0e4eb58be}, {pos = -453060128, events = 32752, fd = -454422162, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xd081ad242ef34600}, {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 = 0x558bdab86ce0}, {pos = 1, events = 0, fd = -625447512, user_data = 0x3}, {pos = 0, events = 0, fd = 25624, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -625624504, user_data = 0x7ff0e4ef3053 }, {pos = -625447512, events = 21899, fd = 1024, user_data = 0x7ffda815b5b8}, {pos = -654316076, events = 21899, fd = -641748208, user_data = 0x558bd8fed891 }, {pos = -625447712, events = 21899, fd = -625624784, user_data = 0x558bdab86ce0}, {pos = -454338709, events = 32752, fd = 0, user_data = 0x558bd8fff4fb }, {pos = -625447712, events = 1, fd = -654313916, user_data = 0x558bdab5b930}, {pos = 787695104, events = 3498159396, fd = 0, user_data = 0x7ff0e4ea2ab1}, {pos = -454421264, events = 32752, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -625877424, user_data = 0xd081ad242ef34600}, {pos = 0, events = 0, fd = 787695104, user_data = 0xc}, {pos = 787695104, events = 3498159396, fd = 0, user_data = 0x7ff0e4e5b239 }, {pos = 217, events = 0, fd = -658782903, user_data = 0x400000}, {pos = 0, events = 0, fd = -625877424, user_data = 0x558bd8fed725 }, {pos = -625790880, events = 21899, fd = -625624784, user_data = 0x558bdab33060}, {pos = 1, events = 0, fd = 0, user_data = 0x558bd8fac122 }, {pos = 12, events = 0, fd = -625452264, user_data = 0x558bdab85af8}, {pos = -641811328, events = 21899, fd = 296, user_data = 0x558bd8bbed63 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -658766432, events = 21899, fd = -645381872, user_data = 0x558bdab5c2d8}} [13:42:45.571] nevents = 1 [13:42:45.571] __func__ = "ServerLoop" [13:42:45.571] #22 0x0000558bd8bc4f43 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x558bdab19cc0) at ../src/backend/postmaster/postmaster.c:1361 [13:42:45.571] opt = [13:42:45.571] status = [13:42:45.571] userDoption = [13:42:45.571] listen_addr_saved = false [13:42:45.571] output_config_variable = [13:42:45.571] __func__ = "PostmasterMain" [13:42:45.571] #23 0x0000558bd89fd1c6 in main (argc=4, argv=0x558bdab19cc0) at ../src/backend/main/main.c:196 [13:42:45.571] do_check_root =