[20:33:07.368] src/tools/ci/cores_backtrace.sh linux /tmp/cores [20:33:07.567] dumping /tmp/cores/postgres-6-36907.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:33:07.826] [New LWP 36907] [20:33:07.826] [20:33:07.826] This GDB supports auto-downloading debuginfo from the following URLs: [20:33:07.826] [20:33:07.826] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:33:07.826] Debuginfod has been disabled. [20:33:07.826] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:33:07.961] [Thread debugging using libthread_db enabled] [20:33:07.961] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:33:07.961] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [20:33:07.961] Program terminated with signal SIGABRT, Aborted. [20:33:07.961] #0 0x00007f0f272a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:09.020] [20:33:09.020] Thread 1 (Thread 0x7f0f27a32f00 (LWP 36907)): [20:33:09.020] #0 0x00007f0f272a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:09.020] No symbol table info available. [20:33:09.020] #1 0x00007f0f2725afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:09.020] No symbol table info available. [20:33:09.020] #2 0x00007f0f27245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:09.020] No symbol table info available. [20:33:09.020] #3 0x00005583c30f4a39 in ExceptionalCondition (conditionName=conditionName@entry=0x5583c3371a1d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5583c3370f70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [20:33:09.020] No locals. [20:33:09.020] #4 0x00005583c2a63065 in standard_ExecutorStart (queryDesc=0x5583f9f074a0, eflags=0) at ../src/backend/executor/execMain.c:193 [20:33:09.020] estate = 0x5583f9f160b0 [20:33:09.020] oldcontext = 0x5583f9f4d4f0 [20:33:09.020] __func__ = "standard_ExecutorStart" [20:33:09.020] #5 0x00007f0f248ce6e9 in pgss_ExecutorStart (queryDesc=0x5583f9f074a0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [20:33:09.020] No locals. [20:33:09.020] #6 0x00005583c2a631fa in ExecutorStart (queryDesc=queryDesc@entry=0x5583f9f074a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [20:33:09.020] No locals. [20:33:09.020] #7 0x00005583c2982cc4 in refresh_matview_datafill (dest=0x5583f9f051b0, query=, query@entry=0x5583f9eb9560, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [20:33:09.020] rewritten = [20:33:09.020] plan = 0x5583f9f06af8 [20:33:09.020] queryDesc = 0x5583f9f074a0 [20:33:09.020] copied_query = [20:33:09.020] processed = [20:33:09.020] __func__ = "refresh_matview_datafill" [20:33:09.020] #8 0x00005583c298501e in RefreshMatViewByOid (matviewOid=28306, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [20:33:09.020] dest = [20:33:09.020] matviewRel = 0x7f0f22bca990 [20:33:09.020] rule = [20:33:09.020] actions = [20:33:09.020] dataQuery = 0x5583f9eb9560 [20:33:09.020] tableSpace = [20:33:09.020] relowner = 10 [20:33:09.020] OIDNewHeap = 28332 [20:33:09.020] processed = 0 [20:33:09.020] relpersistence = 112 'p' [20:33:09.020] save_userid = 10 [20:33:09.020] save_sec_context = 0 [20:33:09.020] save_nestlevel = 2 [20:33:09.020] address = {classId = 0, objectId = 0, objectSubId = 0} [20:33:09.020] __func__ = "RefreshMatViewByOid" [20:33:09.020] #9 0x00005583c298515d in ExecRefreshMatView (stmt=0x5583f9f04e88, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:33:09.020] matviewOid = [20:33:09.020] lockmode = [20:33:09.020] #10 0x00005583c293ac31 in ExecCreateTableAs (pstate=pstate@entry=0x5583f9f4d5f0, stmt=stmt@entry=0x5583f9da0790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffc8b86f00) at ../src/backend/commands/createas.c:351 [20:33:09.020] refresh = [20:33:09.020] query = 0x5583f9da0950 [20:33:09.020] into = 0x5583f9da04e8 [20:33:09.020] jstate = 0x0 [20:33:09.020] is_matview = true [20:33:09.020] do_refresh = false [20:33:09.020] dest = [20:33:09.020] address = {classId = 1259, objectId = 28306, objectSubId = 0} [20:33:09.020] __func__ = "ExecCreateTableAs" [20:33:09.020] #11 0x00005583c2e65560 in ProcessUtilitySlow (pstate=pstate@entry=0x5583f9f4d5f0, pstmt=pstmt@entry=0x5583f9da0840, queryString=queryString@entry=0x5583f9d9fa50 "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=0x5583f9da17e8, qc=0x7fffc8b86f00) at ../src/backend/tcop/utility.c:1678 [20:33:09.020] _save_exception_stack = 0x7fffc8b86ad0 [20:33:09.020] _save_context_stack = 0x0 [20:33:09.020] _local_sigjmp_buf = {{__jmpbuf = {0, 7525175099192173745, 94025320892304, 0, 94025320888912, 0, 4365861766445851825, 7525159395251905713}, __mask_was_saved = 0, __saved_mask = {__val = {94024391920760, 94025321501360, 94024391941320, 6487854739674020114, 12826949595698196639, 13078921423356586303, 17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 94024398374926, 0, 140736560917248, 0, 94024402227394, 140736560916444}}}} [20:33:09.020] _do_rethrow = false [20:33:09.020] parsetree = 0x5583f9da0790 [20:33:09.020] isTopLevel = true [20:33:09.020] isCompleteQuery = true [20:33:09.020] needCleanup = false [20:33:09.020] commandCollected = false [20:33:09.020] address = {classId = 21891, objectId = 4191815568, objectSubId = 21891} [20:33:09.020] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:33:09.020] __func__ = "ProcessUtilitySlow" [20:33:09.020] #12 0x00005583c2e63b71 in standard_ProcessUtility (pstmt=pstmt@entry=0x5583f9da0840, queryString=queryString@entry=0x5583f9d9fa50 "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=0x5583f9da17e8, qc=0x7fffc8b86f00) at ../src/backend/tcop/utility.c:1070 [20:33:09.020] parsetree = 0x5583f9da0790 [20:33:09.020] isTopLevel = true [20:33:09.020] isAtomicContext = false [20:33:09.020] pstate = 0x5583f9f4d5f0 [20:33:09.020] readonly_flags = [20:33:09.020] __func__ = "standard_ProcessUtility" [20:33:09.020] #13 0x00007f0f248d1d8f in pgss_ProcessUtility (pstmt=0x5583f9da0840, queryString=0x5583f9d9fa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5583f9da17e8, qc=0x7fffc8b86f00) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [20:33:09.020] _save_exception_stack = 0x7fffc8b86de0 [20:33:09.020] _save_context_stack = 0x0 [20:33:09.020] _local_sigjmp_buf = {{__jmpbuf = {0, -4365895322707761999, 94025320892480, 94025320896488, 140736560918272, 0, 4365861766475211953, 4429132246812910769}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140736560917504, 94024402235093, 1, 206158430232, 94025320893280, 140736560917600, 0, 94024397003944, 94025320888656, 94024401894566, 3, 94024395726636, 94025320892480}}}} [20:33:09.020] _do_rethrow = false [20:33:09.020] duration = [20:33:09.020] bufusage = {shared_blks_hit = 57, shared_blks_read = 94024398376716, shared_blks_dirtied = 94025322423656, shared_blks_written = 94024394856697, local_blks_hit = 94024395309618, local_blks_read = 94025322425720, local_blks_dirtied = 94025322423656, local_blks_written = 94024402228328, temp_blks_read = 139703066242488, temp_blks_written = 94025320888912, shared_blk_read_time = {ticks = 94024404590611}, shared_blk_write_time = {ticks = 94024414683618}, local_blk_read_time = {ticks = 94024414683744}, local_blk_write_time = {ticks = 140736560917508}, temp_blk_read_time = {ticks = 94024404784729}, temp_blk_write_time = {ticks = 94024414683633}} [20:33:09.020] walusage_start = {wal_records = 8976, wal_fpi = 114, wal_bytes = 1178951} [20:33:09.020] start = [20:33:09.020] rows = [20:33:09.020] bufusage_start = {shared_blks_hit = 34702, shared_blks_read = 4072, shared_blks_dirtied = 1397, shared_blks_written = 1016, 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}} [20:33:09.020] walusage = {wal_records = 1, wal_fpi = 4294967353, wal_bytes = 139702986853248} [20:33:09.020] parsetree = [20:33:09.020] saved_queryId = 7267788456574341698 [20:33:09.020] saved_stmt_location = 0 [20:33:09.020] saved_stmt_len = 69 [20:33:09.020] enabled = true [20:33:09.020] #14 0x00005583c2e63c17 in ProcessUtility (pstmt=pstmt@entry=0x5583f9da0840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5583f9da17e8, qc=0x7fffc8b86f00) at ../src/backend/tcop/utility.c:519 [20:33:09.020] No locals. [20:33:09.020] #15 0x00005583c2e5f68a in PortalRunUtility (portal=portal@entry=0x5583f9e22940, pstmt=pstmt@entry=0x5583f9da0840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5583f9da17e8, qc=qc@entry=0x7fffc8b86f00) at ../src/backend/tcop/pquery.c:1152 [20:33:09.020] No locals. [20:33:09.020] #16 0x00005583c2e5fc2f in PortalRunMulti (portal=portal@entry=0x5583f9e22940, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5583f9da17e8, altdest=altdest@entry=0x5583f9da17e8, qc=qc@entry=0x7fffc8b86f00) at ../src/backend/tcop/pquery.c:1309 [20:33:09.020] pstmt = 0x5583f9da0840 [20:33:09.020] stmtlist_item__state = [20:33:09.020] active_snapshot_set = false [20:33:09.020] stmtlist_item = 0x5583f9da17b0 [20:33:09.020] #17 0x00005583c2e60197 in PortalRun (portal=portal@entry=0x5583f9e22940, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5583f9da17e8, altdest=altdest@entry=0x5583f9da17e8, qc=qc@entry=0x7fffc8b86f00) at ../src/backend/tcop/pquery.c:787 [20:33:09.020] _save_exception_stack = 0x7fffc8b86fb0 [20:33:09.020] _save_context_stack = 0x0 [20:33:09.020] _local_sigjmp_buf = {{__jmpbuf = {0, 7525175098532619441, 94025321425216, 94025320892424, 94025320892400, 94025320892352, 4365861766615721137, 7525159396505609393}, __mask_was_saved = 0, __saved_mask = {__val = {94024401915418, 3367530127, 4, 94025320892352, 112, 73, 94025321425216, 94025320892424, 94025320892400, 94025320892352, 94024402002621, 1, 2, 73, 94024391264705, 0}}}} [20:33:09.020] _do_rethrow = [20:33:09.020] result = [20:33:09.020] nprocessed = [20:33:09.020] saveTopTransactionResourceOwner = 0x5583f9de4348 [20:33:09.020] saveTopTransactionContext = 0x5583f9e35180 [20:33:09.020] saveActivePortal = 0x0 [20:33:09.020] saveResourceOwner = 0x5583f9de4348 [20:33:09.020] savePortalContext = 0x0 [20:33:09.020] saveMemoryContext = 0x5583f9e35180 [20:33:09.020] __func__ = "PortalRun" [20:33:09.020] #18 0x00005583c2e5964f in exec_simple_query (query_string=query_string@entry=0x5583f9d9fa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [20:33:09.020] cmdtaglen = 24 [20:33:09.020] snapshot_set = [20:33:09.020] per_parsetree_context = 0x0 [20:33:09.020] plantree_list = 0x5583f9da1798 [20:33:09.020] parsetree = 0x5583f9da07c0 [20:33:09.020] commandTag = [20:33:09.020] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:33:09.020] querytree_list = [20:33:09.020] portal = 0x5583f9e22940 [20:33:09.020] receiver = 0x5583f9da17e8 [20:33:09.020] format = 0 [20:33:09.020] cmdtagname = [20:33:09.020] parsetree_item__state = [20:33:09.020] dest = DestRemote [20:33:09.020] oldcontext = 0x5583f9e35180 [20:33:09.020] parsetree_list = 0x5583f9da07f0 [20:33:09.020] parsetree_item = 0x5583f9da0808 [20:33:09.020] save_log_statement_stats = false [20:33:09.020] was_logged = true [20:33:09.020] use_implicit_block = false [20:33:09.020] msec_str = "\004\000\000\000\000\000\000\000g\250\021ÃU\000\000\220o\270\310\377\177\000\000G\000\000\000\000\000\000" [20:33:09.020] __func__ = "exec_simple_query" [20:33:09.020] #19 0x00005583c2e5c3a8 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [20:33:09.020] query_string = 0x5583f9d9fa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:33:09.020] firstchar = [20:33:09.020] input_message = {data = 0x5583f9d9fa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:33:09.020] local_sigjmp_buf = {{__jmpbuf = {94024414692216, 7525162003576841393, 140736560918796, 4, 17, 140736560919028, 4365861766682830001, 7525159416661992625}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94025321145072, 0, 168, 94024401915520, 0, 10, 2, 94024414692224, 94025320619504, 94024414686272, 4, 17, 140736560919028}}}} [20:33:09.020] send_ready_for_query = false [20:33:09.020] idle_in_transaction_timeout_enabled = false [20:33:09.020] idle_session_timeout_enabled = false [20:33:09.020] __func__ = "PostgresMain" [20:33:09.020] #20 0x00005583c2e52413 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:33:09.020] bsdata = [20:33:09.020] #21 0x00005583c2d0333e in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7fffc8b8710c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffc8b87160) at ../src/backend/postmaster/launch_backend.c:274 [20:33:09.020] pid = [20:33:09.020] #22 0x00005583c2d0854a in BackendStartup (client_sock=client_sock@entry=0x7fffc8b87160) at ../src/backend/postmaster/postmaster.c:3466 [20:33:09.020] bn = 0x5583f9dcb4a8 [20:33:09.020] pid = [20:33:09.020] startup_data = {canAcceptConnections = CAC_OK} [20:33:09.020] cac = [20:33:09.020] __func__ = "BackendStartup" [20:33:09.020] #23 0x00005583c2d0a56e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [20:33:09.020] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\270\310\377\177\000\000\364q\270\310\377\177", '\000' , "\352\246\350\301\203U\000\000\340\207\344\301\203U\000\000\300r\270\310\377\177\000\000\270r\270\310\377\177\000\000\225[\362\001\000\000\000\000\260\246\334\371\203U\000\000,", '\000' , "\370\245\350\301\203U\000\000hV\256(\017\177\000\0000\306r(\017\177\000", __ss_align = 139703083750112}, salen = 2}} [20:33:09.020] i = 0 [20:33:09.020] now = [20:33:09.020] last_lockfile_recheck_time = 1737059295 [20:33:09.020] last_touch_time = 1737059295 [20:33:09.020] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1041717526, events = 21891, fd = 682514024, user_data = 0x7f0f2872c630}, {pos = 682513120, events = 32527, fd = 2090263927, user_data = 0x7fffc8b87340}, {pos = 682342984, events = 32527, fd = 15, user_data = 0x7f0f2872c630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 682513120, events = 32527, fd = -927436104, user_data = 0x7fffc8b872c0}, {pos = 682514024, events = 32527, fd = 0, user_data = 0x5583f9dcd1b8}, {pos = -1021809430, events = 21891, fd = 32768, user_data = 0x1}, {pos = -103152272, events = 21891, fd = -1, user_data = 0x7f0f2722e020}, {pos = 678674336, events = 32527, fd = -102934456, user_data = 0x5583f9dd5728}, {pos = -102958063, events = 21891, fd = 682368702, user_data = 0x1}, {pos = 682513120, events = 32527, fd = 426, user_data = 0x5583c36a3d50 }, {pos = 0, events = 0, fd = 86, user_data = 0x5583f9dcd1b8}, {pos = 682368702, events = 32527, fd = 1, user_data = 0x0}, {pos = 656597024, events = 32527, fd = 657403456, user_data = 0x10}, {pos = -927434976, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 682377658, user_data = 0x0}, {pos = 657124772, events = 32527, fd = 0, user_data = 0x5583c3d56180 }, {pos = 2, events = 0, fd = 0, user_data = 0x5583f9d61e90}, {pos = -1025588526, events = 21891, fd = -102939285, user_data = 0x5583c2deff0b }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5583f9dcd1b8}, {pos = 682368702, events = 32527, fd = 1, user_data = 0x0}, {pos = 656630984, events = 32527, fd = 657049728, user_data = 0x43d}, {pos = 657157895, events = 32527, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 658447456, events = 32527, fd = 255, user_data = 0xfffffffffffffef0}, {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 = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 678614336, user_data = 0x7f0f2872da80}, {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 = 0x5583f9dd5520}, {pos = -1022130855, events = 21891, fd = 1024, user_data = 0x7f0f272b576b}, {pos = 658430432, events = 32527, fd = 657068398, user_data = 0x100000400}, {pos = 7, events = 0, fd = -102939376, user_data = 0x43fb9d9f9ad3e000}, {pos = 658433504, events = 32527, 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 = -102935064, user_data = 0x3}, {pos = 0, events = 0, fd = 32687, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -102968904, user_data = 0x7f0f272f3053 }, {pos = -102935064, events = 21891, fd = 1024, user_data = 0x7fffc8b877e8}, {pos = -1022049715, events = 21891, fd = -1009351888, user_data = 0x5583c313ad0a }, {pos = -102935264, events = 21891, fd = -103155376, user_data = 0x5583f9dd5520}, {pos = 657151851, events = 32527, fd = 0, user_data = 0x5583c314c974 }, {pos = -102935264, events = 1, fd = -1022047555, user_data = 0x5583f9d9f950}, {pos = -1697390592, events = 1140563359, fd = 0, user_data = 0x7f0f272a2ab1}, {pos = 657069296, events = 32527, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -103407984, user_data = 0x43fb9d9f9ad3e000}, {pos = 0, events = 0, fd = -1697390592, user_data = 0xc}, {pos = -1697390592, events = 1140563359, fd = 0, user_data = 0x7f0f2725b239 }, {pos = 87, events = 0, fd = -1026543557, user_data = 0x400000}, {pos = 0, events = 0, fd = -103407984, user_data = 0x5583c313ab9e }, {pos = -103321472, events = 21891, fd = -103155376, user_data = 0x5583f9d77080}, {pos = 1, events = 0, fd = 0, user_data = 0x5583c30f93a3 }, {pos = 12, events = 0, fd = -102972952, user_data = 0x5583f9dcc1c8}, {pos = -1009424640, events = 21891, fd = 296, user_data = 0x5583c2d05855 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1026527200, events = 21891, fd = -1013040912, user_data = 0x5583f9da0308}} [20:33:09.021] nevents = 1 [20:33:09.021] __func__ = "ServerLoop" [20:33:09.021] #24 0x00005583c2d0bdcd in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5583f9d5dcf0) at ../src/backend/postmaster/postmaster.c:1377 [20:33:09.021] opt = [20:33:09.021] status = [20:33:09.021] userDoption = [20:33:09.021] listen_addr_saved = false [20:33:09.021] output_config_variable = [20:33:09.021] __func__ = "PostmasterMain" [20:33:09.021] #25 0x00005583c2b40d92 in main (argc=4, argv=0x5583f9d5dcf0) at ../src/backend/main/main.c:230 [20:33:09.021] do_check_root = [20:33:09.021] dispatch_option = [20:33:09.062] -e [20:33:09.062] [20:33:09.062] [20:33:09.126] dumping /tmp/cores/postgres-6-29423.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:33:09.414] [New LWP 29423] [20:33:09.414] [20:33:09.414] This GDB supports auto-downloading debuginfo from the following URLs: [20:33:09.414] [20:33:09.414] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:33:09.414] Debuginfod has been disabled. [20:33:09.414] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:33:09.531] [Thread debugging using libthread_db enabled] [20:33:09.531] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:33:09.531] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [20:33:09.531] Program terminated with signal SIGABRT, Aborted. [20:33:09.531] #0 0x00007f6e9f6a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:10.518] [20:33:10.518] Thread 1 (Thread 0x7f6e9fe35f00 (LWP 29423)): [20:33:10.518] #0 0x00007f6e9f6a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:10.518] No symbol table info available. [20:33:10.518] #1 0x00007f6e9f65afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:10.518] No symbol table info available. [20:33:10.518] #2 0x00007f6e9f645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:10.518] No symbol table info available. [20:33:10.518] #3 0x000055bbe10eca39 in ExceptionalCondition (conditionName=conditionName@entry=0x55bbe1369a1d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55bbe1368f70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [20:33:10.518] No locals. [20:33:10.518] #4 0x000055bbe0a5b065 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55bbeb657730, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [20:33:10.518] estate = 0x55bbeb5ee000 [20:33:10.518] oldcontext = 0x55bbeb6335f0 [20:33:10.518] __func__ = "standard_ExecutorStart" [20:33:10.518] #5 0x000055bbe0a5b241 in ExecutorStart (queryDesc=queryDesc@entry=0x55bbeb657730, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [20:33:10.518] No locals. [20:33:10.518] #6 0x000055bbe097acc4 in refresh_matview_datafill (dest=0x55bbeb65d580, query=, query@entry=0x55bbeb61e980, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [20:33:10.518] rewritten = [20:33:10.518] plan = 0x55bbeb656d88 [20:33:10.518] queryDesc = 0x55bbeb657730 [20:33:10.518] copied_query = [20:33:10.518] processed = [20:33:10.518] __func__ = "refresh_matview_datafill" [20:33:10.518] #7 0x000055bbe097d01e in RefreshMatViewByOid (matviewOid=28521, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [20:33:10.518] dest = [20:33:10.518] matviewRel = 0x7f6e93c2e5f0 [20:33:10.518] rule = [20:33:10.518] actions = [20:33:10.518] dataQuery = 0x55bbeb61e980 [20:33:10.518] tableSpace = [20:33:10.518] relowner = 10 [20:33:10.518] OIDNewHeap = 28536 [20:33:10.518] processed = 0 [20:33:10.518] relpersistence = 112 'p' [20:33:10.518] save_userid = 10 [20:33:10.518] save_sec_context = 0 [20:33:10.518] save_nestlevel = 2 [20:33:10.518] address = {classId = 0, objectId = 0, objectSubId = 0} [20:33:10.518] __func__ = "RefreshMatViewByOid" [20:33:10.518] #8 0x000055bbe097d15d in ExecRefreshMatView (stmt=0x55bbeb65d258, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:33:10.518] matviewOid = [20:33:10.518] lockmode = [20:33:10.518] #9 0x000055bbe0932c31 in ExecCreateTableAs (pstate=pstate@entry=0x55bbeb6336f0, stmt=stmt@entry=0x55bbeb4e07f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc02d35020) at ../src/backend/commands/createas.c:351 [20:33:10.518] refresh = [20:33:10.518] query = 0x55bbeb4e09b0 [20:33:10.518] into = 0x55bbeb4e0548 [20:33:10.518] jstate = 0x0 [20:33:10.518] is_matview = true [20:33:10.518] do_refresh = false [20:33:10.518] dest = [20:33:10.518] address = {classId = 1259, objectId = 28521, objectSubId = 0} [20:33:10.518] __func__ = "ExecCreateTableAs" [20:33:10.518] #10 0x000055bbe0e5d560 in ProcessUtilitySlow (pstate=pstate@entry=0x55bbeb6336f0, pstmt=pstmt@entry=0x55bbeb4e08a0, queryString=queryString@entry=0x55bbeb4dfab0 "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=0x55bbeb4e12d8, qc=0x7ffc02d35020) at ../src/backend/tcop/utility.c:1678 [20:33:10.518] _save_exception_stack = 0x7ffc02d34f00 [20:33:10.518] _save_context_stack = 0x0 [20:33:10.518] _local_sigjmp_buf = {{__jmpbuf = {0, -7841146805143149598, 94265595004912, 0, 94265595001520, 0, -4061835934908226590, -7841134389095767070}, __mask_was_saved = 0, __saved_mask = {__val = {94265419818575, 94265596111544, 40608393743269, 9454, 94265419826179, 140112910124480, 140112910124480, 9454, 94265419828257, 1, 4294976750, 140112910124480, 94265419818575, 1, 40608569682616, 1}}}} [20:33:10.518] _do_rethrow = false [20:33:10.518] parsetree = 0x55bbeb4e07f0 [20:33:10.518] isTopLevel = true [20:33:10.518] isCompleteQuery = true [20:33:10.518] needCleanup = false [20:33:10.518] commandCollected = false [20:33:10.518] address = {classId = 21947, objectId = 3947759600, objectSubId = 21947} [20:33:10.518] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:33:10.518] __func__ = "ProcessUtilitySlow" [20:33:10.518] #11 0x000055bbe0e5bb71 in standard_ProcessUtility (pstmt=0x55bbeb4e08a0, queryString=0x55bbeb4dfab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55bbeb4e12d8, qc=0x7ffc02d35020) at ../src/backend/tcop/utility.c:1070 [20:33:10.518] parsetree = 0x55bbeb4e07f0 [20:33:10.518] isTopLevel = true [20:33:10.518] isAtomicContext = false [20:33:10.518] pstate = 0x55bbeb6336f0 [20:33:10.518] readonly_flags = [20:33:10.518] __func__ = "standard_ProcessUtility" [20:33:10.518] #12 0x000055bbe0e5bccc in ProcessUtility (pstmt=pstmt@entry=0x55bbeb4e08a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55bbeb4e12d8, qc=0x7ffc02d35020) at ../src/backend/tcop/utility.c:523 [20:33:10.518] No locals. [20:33:10.518] #13 0x000055bbe0e5768a in PortalRunUtility (portal=portal@entry=0x55bbeb564fc0, pstmt=pstmt@entry=0x55bbeb4e08a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55bbeb4e12d8, qc=qc@entry=0x7ffc02d35020) at ../src/backend/tcop/pquery.c:1152 [20:33:10.518] No locals. [20:33:10.518] #14 0x000055bbe0e57c2f in PortalRunMulti (portal=portal@entry=0x55bbeb564fc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55bbeb4e12d8, altdest=altdest@entry=0x55bbeb4e12d8, qc=qc@entry=0x7ffc02d35020) at ../src/backend/tcop/pquery.c:1309 [20:33:10.518] pstmt = 0x55bbeb4e08a0 [20:33:10.518] stmtlist_item__state = [20:33:10.518] active_snapshot_set = false [20:33:10.518] stmtlist_item = 0x55bbeb4e12a0 [20:33:10.518] #15 0x000055bbe0e58197 in PortalRun (portal=portal@entry=0x55bbeb564fc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55bbeb4e12d8, altdest=altdest@entry=0x55bbeb4e12d8, qc=qc@entry=0x7ffc02d35020) at ../src/backend/tcop/pquery.c:787 [20:33:10.518] _save_exception_stack = 0x7ffc02d350d0 [20:33:10.518] _save_context_stack = 0x0 [20:33:10.518] _local_sigjmp_buf = {{__jmpbuf = {0, -7841146804951260190, 94265595547584, 94265595005032, 94265595005008, 94265595004960, -4061835935046638622, -7841134388671749150}, __mask_was_saved = 0, __saved_mask = {__val = {94265423367706, 47402927, 4, 94265595004960, 112, 73, 94265595547584, 94265595005032, 94265595005008, 94265595004960, 94265423454909, 1, 2, 73, 94265412716993, 0}}}} [20:33:10.518] _do_rethrow = [20:33:10.518] result = [20:33:10.518] nprocessed = [20:33:10.518] saveTopTransactionResourceOwner = 0x55bbeb522d88 [20:33:10.518] saveTopTransactionContext = 0x55bbeb5773f0 [20:33:10.518] saveActivePortal = 0x0 [20:33:10.518] saveResourceOwner = 0x55bbeb522d88 [20:33:10.518] savePortalContext = 0x0 [20:33:10.518] saveMemoryContext = 0x55bbeb5773f0 [20:33:10.518] __func__ = "PortalRun" [20:33:10.518] #16 0x000055bbe0e5164f in exec_simple_query (query_string=query_string@entry=0x55bbeb4dfab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [20:33:10.518] cmdtaglen = 24 [20:33:10.518] snapshot_set = [20:33:10.518] per_parsetree_context = 0x0 [20:33:10.518] plantree_list = 0x55bbeb4e1288 [20:33:10.518] parsetree = 0x55bbeb4e0820 [20:33:10.518] commandTag = [20:33:10.518] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:33:10.518] querytree_list = [20:33:10.518] portal = 0x55bbeb564fc0 [20:33:10.518] receiver = 0x55bbeb4e12d8 [20:33:10.518] format = 0 [20:33:10.518] cmdtagname = [20:33:10.518] parsetree_item__state = [20:33:10.518] dest = DestRemote [20:33:10.518] oldcontext = 0x55bbeb5773f0 [20:33:10.518] parsetree_list = 0x55bbeb4e0850 [20:33:10.518] parsetree_item = 0x55bbeb4e0868 [20:33:10.518] save_log_statement_stats = false [20:33:10.518] was_logged = false [20:33:10.518] use_implicit_block = false [20:33:10.518] msec_str = "\004\000\000\000\000\000\000\000g(\021\341\273U\000\000\260P\323\002\374\177\000\000G\000\000\000\000\000\000" [20:33:10.518] __func__ = "exec_simple_query" [20:33:10.518] #17 0x000055bbe0e543a8 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [20:33:10.518] query_string = 0x55bbeb4dfab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:33:10.518] firstchar = [20:33:10.518] input_message = {data = 0x55bbeb4dfab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:33:10.518] local_sigjmp_buf = {{__jmpbuf = {94265436144504, -7841132305706851358, 140720355889708, 4, 18, 140720355889940, -4061835934576876574, -7841134393327033374}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94265594731984, 17408, 94265436138560, 94265595266352, 18, 94265423367254, 0, 10, 2, 94265436144512, 94265594731984, 94265436138560, 4, 18, 140720355889940}}}} [20:33:10.518] send_ready_for_query = false [20:33:10.518] idle_in_transaction_timeout_enabled = false [20:33:10.518] idle_session_timeout_enabled = false [20:33:10.518] __func__ = "PostgresMain" [20:33:10.518] #18 0x000055bbe0e4a413 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:33:10.518] bsdata = [20:33:10.518] #19 0x000055bbe0cfb33e in postmaster_child_launch (child_type=B_BACKEND, child_slot=18, startup_data=startup_data@entry=0x7ffc02d3522c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc02d35280) at ../src/backend/postmaster/launch_backend.c:274 [20:33:10.518] pid = [20:33:10.518] #20 0x000055bbe0d0054a in BackendStartup (client_sock=client_sock@entry=0x7ffc02d35280) at ../src/backend/postmaster/postmaster.c:3466 [20:33:10.518] bn = 0x55bbeb508358 [20:33:10.518] pid = [20:33:10.518] startup_data = {canAcceptConnections = CAC_OK} [20:33:10.518] cac = [20:33:10.518] __func__ = "BackendStartup" [20:33:10.518] #21 0x000055bbe0d0256e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [20:33:10.518] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\003\241n\177\000\000>\004\000\000\000\000\000\000\260\227c\237n\177\000\000\240ﺠn\177\000\0008S\323\002\374\177\000\0004S\323\002\374\177", '\000' , "\352&\350\337\273U\000\000\340\a\344\337\273U\000\000\000T\323\002\374\177\000\000\370S\323\002\374\177\000\000\225[\362\001D\3032\247\240\304\346\237n\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [20:33:10.518] i = 0 [20:33:10.518] now = [20:33:10.518] last_lockfile_recheck_time = 1737059256 [20:33:10.518] last_touch_time = 1737059256 [20:33:10.518] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 47404096, user_data = 0x0}, {pos = 15, events = 0, fd = -538433814, user_data = 0x7f6ea1060668}, {pos = -1612265936, events = 32622, fd = -1593441568, user_data = 0x7c96e577}, {pos = 47404160, events = 32764, fd = -1593611704, user_data = 0xf}, {pos = -1612265936, events = 32622, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1593441568, user_data = 0x7ffc02d353f8}, {pos = 47404032, events = 32764, fd = -1593440664, user_data = 0x0}, {pos = -347203680, events = 21947, fd = -1620120219, user_data = 0x7ffc02d35913}, {pos = 1, events = 0, fd = 47404032, user_data = 0xffffffff}, {pos = -1620910048, events = 32622, fd = -1598361696, user_data = 0x55bbeb50d3f8}, {pos = -347024680, events = 21947, fd = -347025231, user_data = 0x7f6ea103cebe}, {pos = 1, events = 0, fd = -1593441568, user_data = 0x1aa}, {pos = -513163952, events = 21947, fd = 0, user_data = 0xf9}, {pos = -347210896, events = 21947, fd = -1593585986, user_data = 0x1}, {pos = 0, events = 0, fd = -1620910048, user_data = 0x7f6e9f6f2e40 }, {pos = 16, events = 0, fd = 47405120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f6ea103f1ba}, {pos = 0, events = 0, fd = -1620382300, user_data = 0x0}, {pos = -506142336, events = 21947, fd = 2, user_data = 0x0}, {pos = -347464080, events = 21947, fd = 1952410737, user_data = 0x160}, {pos = -513164544, events = 21947, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -347210896, events = 21947, fd = -1593585986, user_data = 0x1}, {pos = -1620348819, events = 32622, fd = -1620876088, user_data = 0x55bbeb5124d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1619059616, events = 32622, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55bbeb4a1e70}, {pos = -1620346230, events = 32622, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 2036682049, fd = 168445494, user_data = 0x30373337310a6174}, {pos = 892483893, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1619076640, events = 32622, fd = -1620438674, user_data = 0x100000400}, {pos = 7, events = 0, fd = -347024160, user_data = 0xa732c3440527e800}, {pos = -1619073568, events = 32622, fd = -328, user_data = 0x0}, {pos = -347025000, events = 21947, fd = 1024, user_data = 0x55bbeb50d198}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 25537, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -347210896, user_data = 0x7f6e9f6f3053 }, {pos = -347025000, events = 21947, fd = 1024, user_data = 0x7ffc02d35908}, {pos = -518766003, events = 21947, fd = -506068176, user_data = 0x55bbe1132d0a }, {pos = -347025200, events = 21947, fd = -347211344, user_data = 0x55bbeb50d0d0}, {pos = -1620354882, events = 32622, fd = 0, user_data = 0x55bbe1144974 }, {pos = -347025200, events = 1, fd = -518763843, user_data = 0x55bbeb4df9b0}, {pos = 86501376, events = 2805121860, fd = 0, user_data = 0x7f6e9f6a2ab1}, {pos = -1620437776, events = 32622, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -347464080, user_data = 0xa732c3440527e800}, {pos = 0, events = 0, fd = 86501376, user_data = 0xc}, {pos = 86501376, events = 2805121860, fd = 0, user_data = 0x7f6e9f65b239 }, {pos = 250, events = 0, fd = -523259845, user_data = 0x400000}, {pos = 0, events = 0, fd = -347464080, user_data = 0x55bbe1132b9e }, {pos = -347377440, events = 21947, fd = -347211344, user_data = 0x55bbeb4b70e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55bbe10f13a3 }, {pos = 12, events = 0, fd = -347033864, user_data = 0x55bbeb50aed8}, {pos = -506140928, events = 21947, fd = 296, user_data = 0x55bbe0cfd855 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -523243488, events = 21947, fd = -509757200, user_data = 0x55bbeb4e0388}} [20:33:10.518] nevents = 1 [20:33:10.518] __func__ = "ServerLoop" [20:33:10.518] #22 0x000055bbe0d03dcd in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55bbeb49dd30) at ../src/backend/postmaster/postmaster.c:1377 [20:33:10.518] opt = [20:33:10.518] status = [20:33:10.518] userDoption = [20:33:10.518] listen_addr_saved = false [20:33:10.518] output_config_variable = [20:33:10.518] __func__ = "PostmasterMain" [20:33:10.518] #23 0x000055bbe0b38d92 in main (argc=8, argv=0x55bbeb49dd30) at ../src/backend/main/main.c:230 [20:33:10.518] do_check_root = [20:33:10.518] dispatch_option = [20:33:10.557] -e [20:33:10.557] [20:33:10.557] [20:33:10.625] dumping /tmp/cores/postgres-6-30303.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:33:10.885] [New LWP 30303] [20:33:10.885] [20:33:10.885] This GDB supports auto-downloading debuginfo from the following URLs: [20:33:10.885] [20:33:10.885] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:33:10.885] Debuginfod has been disabled. [20:33:10.885] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:33:10.995] [Thread debugging using libthread_db enabled] [20:33:10.995] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:33:10.995] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [20:33:10.995] Program terminated with signal SIGABRT, Aborted. [20:33:10.995] #0 0x00007ff4f76a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:11.992] [20:33:11.992] Thread 1 (Thread 0x7ff4f7e37f00 (LWP 30303)): [20:33:11.992] #0 0x00007ff4f76a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:11.992] No symbol table info available. [20:33:11.992] #1 0x00007ff4f765afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:11.992] No symbol table info available. [20:33:11.992] #2 0x00007ff4f7645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [20:33:11.992] No symbol table info available. [20:33:11.992] #3 0x0000564efc9d0a39 in ExceptionalCondition (conditionName=conditionName@entry=0x564efcc4da1d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x564efcc4cf70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [20:33:11.992] No locals. [20:33:11.992] #4 0x0000564efc33f065 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x564f07715b20, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:193 [20:33:11.992] estate = 0x564f076d4a60 [20:33:11.992] oldcontext = 0x564f0771a350 [20:33:11.992] __func__ = "standard_ExecutorStart" [20:33:11.992] #5 0x0000564efc33f241 in ExecutorStart (queryDesc=queryDesc@entry=0x564f07715b20, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [20:33:11.992] No locals. [20:33:11.992] #6 0x0000564efc25ecc4 in refresh_matview_datafill (dest=0x564f07756480, query=, query@entry=0x564f0773ac30, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [20:33:11.992] rewritten = [20:33:11.992] plan = 0x564f07715178 [20:33:11.992] queryDesc = 0x564f07715b20 [20:33:11.992] copied_query = [20:33:11.992] processed = [20:33:11.992] __func__ = "refresh_matview_datafill" [20:33:11.992] #7 0x0000564efc26101e in RefreshMatViewByOid (matviewOid=28572, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [20:33:11.992] dest = [20:33:11.992] matviewRel = 0x7ff4ebec6c80 [20:33:11.992] rule = [20:33:11.992] actions = [20:33:11.992] dataQuery = 0x564f0773ac30 [20:33:11.992] tableSpace = [20:33:11.992] relowner = 10 [20:33:11.992] OIDNewHeap = 28590 [20:33:11.992] processed = 0 [20:33:11.992] relpersistence = 112 'p' [20:33:11.992] save_userid = 10 [20:33:11.992] save_sec_context = 0 [20:33:11.992] save_nestlevel = 2 [20:33:11.992] address = {classId = 0, objectId = 0, objectSubId = 0} [20:33:11.992] __func__ = "RefreshMatViewByOid" [20:33:11.992] #8 0x0000564efc26115d in ExecRefreshMatView (stmt=0x564f07756158, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:33:11.992] matviewOid = [20:33:11.992] lockmode = [20:33:11.992] #9 0x0000564efc216c31 in ExecCreateTableAs (pstate=pstate@entry=0x564f0771a450, stmt=stmt@entry=0x564f075a5770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc4cc955d0) at ../src/backend/commands/createas.c:351 [20:33:11.992] refresh = [20:33:11.992] query = 0x564f075a5930 [20:33:11.992] into = 0x564f075a54c8 [20:33:11.992] jstate = 0x0 [20:33:11.992] is_matview = true [20:33:11.992] do_refresh = false [20:33:11.992] dest = [20:33:11.992] address = {classId = 1259, objectId = 28572, objectSubId = 0} [20:33:11.992] __func__ = "ExecCreateTableAs" [20:33:11.992] #10 0x0000564efc741560 in ProcessUtilitySlow (pstate=pstate@entry=0x564f0771a450, pstmt=pstmt@entry=0x564f075a5820, queryString=queryString@entry=0x564f075a4a30 "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=0x564f075a6258, qc=0x7ffc4cc955d0) at ../src/backend/tcop/utility.c:1678 [20:33:11.992] _save_exception_stack = 0x7ffc4cc954b0 [20:33:11.992] _save_context_stack = 0x0 [20:33:11.992] _local_sigjmp_buf = {{__jmpbuf = {0, 6681075104567225791, 94897425766256, 0, 94897425762864, 0, 1139803570509409727, 6679968801673932223}, __mask_was_saved = 0, __saved_mask = {__val = {94897242318415, 94897427314104, 94897246180456, 140690107628984, 94897425762864, 94897248542739, 94897258635746, 94897258635872, 140721596748500, 94897248736857, 94897258635761, 94897258635872, 140721596748532, 94897248736872, 94897258635872, 0}}}} [20:33:11.992] _do_rethrow = false [20:33:11.992] parsetree = 0x564f075a5770 [20:33:11.992] isTopLevel = true [20:33:11.992] isCompleteQuery = true [20:33:11.992] needCleanup = false [20:33:11.992] commandCollected = false [20:33:11.992] address = {classId = 22095, objectId = 123361136, objectSubId = 22095} [20:33:11.992] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:33:11.992] __func__ = "ProcessUtilitySlow" [20:33:11.992] #11 0x0000564efc73fb71 in standard_ProcessUtility (pstmt=0x564f075a5820, queryString=0x564f075a4a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x564f075a6258, qc=0x7ffc4cc955d0) at ../src/backend/tcop/utility.c:1070 [20:33:11.992] parsetree = 0x564f075a5770 [20:33:11.992] isTopLevel = true [20:33:11.992] isAtomicContext = false [20:33:11.992] pstate = 0x564f0771a450 [20:33:11.992] readonly_flags = [20:33:11.992] __func__ = "standard_ProcessUtility" [20:33:11.992] #12 0x0000564efc73fccc in ProcessUtility (pstmt=pstmt@entry=0x564f075a5820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x564f075a6258, qc=0x7ffc4cc955d0) at ../src/backend/tcop/utility.c:523 [20:33:11.992] No locals. [20:33:11.992] #13 0x0000564efc73b68a in PortalRunUtility (portal=portal@entry=0x564f076299c0, pstmt=pstmt@entry=0x564f075a5820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x564f075a6258, qc=qc@entry=0x7ffc4cc955d0) at ../src/backend/tcop/pquery.c:1152 [20:33:11.992] No locals. [20:33:11.992] #14 0x0000564efc73bc2f in PortalRunMulti (portal=portal@entry=0x564f076299c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x564f075a6258, altdest=altdest@entry=0x564f075a6258, qc=qc@entry=0x7ffc4cc955d0) at ../src/backend/tcop/pquery.c:1309 [20:33:11.992] pstmt = 0x564f075a5820 [20:33:11.992] stmtlist_item__state = [20:33:11.992] active_snapshot_set = false [20:33:11.992] stmtlist_item = 0x564f075a6220 [20:33:11.992] #15 0x0000564efc73c197 in PortalRun (portal=portal@entry=0x564f076299c0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x564f075a6258, altdest=altdest@entry=0x564f075a6258, qc=qc@entry=0x7ffc4cc955d0) at ../src/backend/tcop/pquery.c:787 [20:33:11.992] _save_exception_stack = 0x7ffc4cc95680 [20:33:11.992] _save_context_stack = 0x0 [20:33:11.992] _local_sigjmp_buf = {{__jmpbuf = {0, 6681075103161085375, 94897426307520, 94897425766376, 94897425766352, 94897425766304, 1139803570639433151, 6679968802315267519}, __mask_was_saved = 0, __saved_mask = {__val = {94897245867546, 1288263007, 4, 94897425766304, 112, 73, 94897426307520, 94897425766376, 94897425766352, 94897425766304, 94897245954749, 1, 2, 73, 94897235216833, 0}}}} [20:33:11.992] _do_rethrow = [20:33:11.992] result = [20:33:11.992] nprocessed = [20:33:11.992] saveTopTransactionResourceOwner = 0x564f075e6478 [20:33:11.992] saveTopTransactionContext = 0x564f0763b9e0 [20:33:11.992] saveActivePortal = 0x0 [20:33:11.992] saveResourceOwner = 0x564f075e6478 [20:33:11.992] savePortalContext = 0x0 [20:33:11.992] saveMemoryContext = 0x564f0763b9e0 [20:33:11.992] __func__ = "PortalRun" [20:33:11.992] #16 0x0000564efc73564f in exec_simple_query (query_string=query_string@entry=0x564f075a4a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [20:33:11.992] cmdtaglen = 24 [20:33:11.992] snapshot_set = [20:33:11.992] per_parsetree_context = 0x0 [20:33:11.992] plantree_list = 0x564f075a6208 [20:33:11.992] parsetree = 0x564f075a57a0 [20:33:11.992] commandTag = [20:33:11.992] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:33:11.992] querytree_list = [20:33:11.992] portal = 0x564f076299c0 [20:33:11.992] receiver = 0x564f075a6258 [20:33:11.992] format = 0 [20:33:11.992] cmdtagname = [20:33:11.992] parsetree_item__state = [20:33:11.992] dest = DestRemote [20:33:11.992] oldcontext = 0x564f0763b9e0 [20:33:11.992] parsetree_list = 0x564f075a57d0 [20:33:11.992] parsetree_item = 0x564f075a57e8 [20:33:11.992] save_log_statement_stats = false [20:33:11.992] was_logged = true [20:33:11.992] use_implicit_block = false [20:33:11.992] msec_str = "\004\000\000\000\000\000\000\000gh\237\374NV\000\000`V\311L\374\177\000\000G\000\000\000\000\000\000" [20:33:11.992] __func__ = "exec_simple_query" [20:33:11.992] #17 0x0000564efc7383a8 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [20:33:11.992] query_string = 0x564f075a4a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:33:11.992] firstchar = [20:33:11.992] input_message = {data = 0x564f075a4a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:33:11.992] local_sigjmp_buf = {{__jmpbuf = {94897258644344, 6679970833792724415, 140721596749788, 4, 3, 140721596750020, 1139803570572324287, 6679968797170560447}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94897425493424, 16128, 94897258638400, 94897426027568, 3, 94897245867094, 0, 9, 2, 94897258644352, 94897425493424, 94897258638400, 4, 3, 140721596750020}}}} [20:33:11.992] send_ready_for_query = false [20:33:11.992] idle_in_transaction_timeout_enabled = false [20:33:11.992] idle_session_timeout_enabled = false [20:33:11.992] __func__ = "PostgresMain" [20:33:11.992] #18 0x0000564efc72e413 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:33:11.992] bsdata = [20:33:11.992] #19 0x0000564efc5df33e in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x7ffc4cc957dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc4cc95830) at ../src/backend/postmaster/launch_backend.c:274 [20:33:11.992] pid = [20:33:11.992] #20 0x0000564efc5e454a in BackendStartup (client_sock=client_sock@entry=0x7ffc4cc95830) at ../src/backend/postmaster/postmaster.c:3466 [20:33:11.992] bn = 0x564f075ccf88 [20:33:11.992] pid = [20:33:11.992] startup_data = {canAcceptConnections = CAC_OK} [20:33:11.992] cac = [20:33:11.992] __func__ = "BackendStartup" [20:33:11.992] #21 0x0000564efc5e656e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [20:33:11.992] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\352fv\373NV\000\000\340Gr\373NV\000\000\200Y\311L\374\177\000\000xY\311L\374\177\000\000\225[\362\001\000\000\000\000\240\304H\370\364\177\000\000+", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h\026\375\370\364\177\000\0000\306H\370\364\177\000\000\340\022\375\370\364\177\000\000\316)fR\000\000\000", __ss_align = 1288264128}, salen = 2}} [20:33:11.992] i = 0 [20:33:11.992] now = [20:33:11.992] last_lockfile_recheck_time = 1737059259 [20:33:11.992] last_touch_time = 1737059259 [20:33:11.992] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -129448400, events = 32756, fd = -117632288, user_data = 0x7c96e577}, {pos = 1288264192, events = 32764, fd = -117802424, user_data = 0xf}, {pos = -129448400, events = 32756, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -117632288, user_data = 0x7ffc4cc95978}, {pos = 1288264064, events = 32764, fd = -117631384, user_data = 0x0}, {pos = 123357768, events = 22095, fd = -143951222, user_data = 0x564f075a4a48}, {pos = 1, events = 22094, fd = 32768, user_data = 0xffffffff}, {pos = -144515040, events = 32756, fd = -121860192, user_data = 0x564f075d1f38}, {pos = 123543064, events = 22095, fd = 123542513, user_data = 0x7ff4f8fadebe}, {pos = 1, events = 0, fd = -117632288, user_data = 0x1aa}, {pos = -50856624, events = 22094, fd = 0, user_data = 0xe5}, {pos = 123357768, events = 22095, fd = -117776706, user_data = 0x1}, {pos = 0, events = 0, fd = -144515040, user_data = 0x7ff4f76f2e40 }, {pos = 16, events = 0, fd = 1288265200, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7ff4f8fb01ba}, {pos = 0, events = 0, fd = -143987292, user_data = 0x0}, {pos = -43835008, events = 22094, fd = 2, user_data = 0x0}, {pos = 123104848, events = 22095, fd = -60001475, user_data = 0x564f075d73d0}, {pos = -59997486, events = 22094, fd = 123565099, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -144481080, user_data = 0x7ff4f769c880 }, {pos = -136086088, events = 32756, fd = 1288265392, user_data = 0x100007f00000002}, {pos = -143953811, events = 32756, fd = 2, user_data = 0x564f075d73d0}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -142664608, events = 32756, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 170996256, events = 1681290355, fd = 1450062414, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 22016, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 123548224, events = 22095, fd = 1080, user_data = 0x564f075d1c10}, {pos = -56539815, events = 22094, fd = 1024, user_data = 0x7ff4f76b58be}, {pos = -142681632, events = 32756, fd = -144043666, user_data = 0x100000400}, {pos = 7, events = 0, fd = 123543584, user_data = 0x5a1e8cbf0dc55600}, {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 = 0x564f075d1c10}, {pos = 1, events = 0, fd = 123542744, user_data = 0x3}, {pos = 0, events = 0, fd = 26167, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 123357768, user_data = 0x7ff4f76f3053 }, {pos = 123542744, events = 22095, fd = 1024, user_data = 0x7ffc4cc95eb8}, {pos = -56458675, events = 22094, fd = -43760848, user_data = 0x564efca16d0a }, {pos = 123542544, events = 22095, fd = 123357488, user_data = 0x564f075d1c10}, {pos = -143959874, events = 32756, fd = 0, user_data = 0x564efca28974 }, {pos = 123542544, events = 1, fd = -56456515, user_data = 0x564f075a4930}, {pos = 231036416, events = 1511951551, fd = 0, user_data = 0x7ff4f76a2ab1}, {pos = -144042768, events = 32756, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 123104848, user_data = 0x5a1e8cbf0dc55600}, {pos = 0, events = 0, fd = 231036416, user_data = 0xc}, {pos = 231036416, events = 1511951551, fd = 0, user_data = 0x7ff4f765b239 }, {pos = 230, events = 0, fd = -60952517, user_data = 0x400000}, {pos = 0, events = 0, fd = 123104848, user_data = 0x564efca16b9e }, {pos = 123191392, events = 22095, fd = 123357488, user_data = 0x564f0757c060}, {pos = 1, events = 0, fd = 0, user_data = 0x564efc9d53a3 }, {pos = 12, events = 0, fd = 123533880, user_data = 0x564f075cfa18}, {pos = -43833600, events = 22094, fd = 296, user_data = 0x564efc5e1855 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -60936160, events = 22094, fd = -47449872, user_data = 0x564f075a52d8}} [20:33:11.993] nevents = 1 [20:33:11.993] __func__ = "ServerLoop" [20:33:11.993] #22 0x0000564efc5e7dcd in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x564f07562cc0) at ../src/backend/postmaster/postmaster.c:1377 [20:33:11.993] opt = [20:33:11.993] status = [20:33:11.993] userDoption = [20:33:11.993] listen_addr_saved = false [20:33:11.993] output_config_variable = [20:33:11.993] __func__ = "PostmasterMain" [20:33:11.993] #23 0x0000564efc41cd92 in main (argc=4, argv=0x564f07562cc0) at ../src/backend/main/main.c:230 [20:33:11.993] do_check_root = [20:33:11.993] dispatch_option =