[09:27:04.378] src/tools/ci/cores_backtrace.sh linux /tmp/cores [09:27:04.576] dumping /tmp/cores/postgres-6-36584.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:27:04.817] [New LWP 36584] [09:27:04.817] [09:27:04.817] This GDB supports auto-downloading debuginfo from the following URLs: [09:27:04.817] [09:27:04.817] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:27:04.817] Debuginfod has been disabled. [09:27:04.817] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:27:04.943] [Thread debugging using libthread_db enabled] [09:27:04.943] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:27:04.943] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [09:27:04.943] Program terminated with signal SIGABRT, Aborted. [09:27:04.943] #0 0x00007f149b0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:05.828] [09:27:05.828] Thread 1 (Thread 0x7f149afd7f00 (LWP 36584)): [09:27:05.828] #0 0x00007f149b0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:05.828] No symbol table info available. [09:27:05.828] #1 0x00007f149b05afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:05.828] No symbol table info available. [09:27:05.828] #2 0x00007f149b045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:05.828] No symbol table info available. [09:27:05.828] #3 0x000055f8ccfcd67c in ExceptionalCondition (conditionName=conditionName@entry=0x55f8cd23e4c5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55f8cd23da30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [09:27:05.828] No locals. [09:27:05.828] #4 0x000055f8cc95b2f1 in standard_ExecutorStart (queryDesc=0x55f8cf67b7e0, eflags=0) at ../src/backend/executor/execMain.c:191 [09:27:05.828] estate = 0x55f8cf632160 [09:27:05.828] oldcontext = 0x55f8cf5f6f30 [09:27:05.828] __func__ = "standard_ExecutorStart" [09:27:05.828] #5 0x00007f14990296f7 in pgss_ExecutorStart (queryDesc=0x55f8cf67b7e0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [09:27:05.828] No locals. [09:27:05.828] #6 0x000055f8cc95b486 in ExecutorStart (queryDesc=queryDesc@entry=0x55f8cf67b7e0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:130 [09:27:05.828] No locals. [09:27:05.828] #7 0x000055f8cc8824d4 in refresh_matview_datafill (dest=0x55f8cf678858, query=, query@entry=0x55f8cf64ed10, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [09:27:05.828] rewritten = [09:27:05.828] plan = 0x55f8cf67ad18 [09:27:05.828] queryDesc = 0x55f8cf67b7e0 [09:27:05.828] copied_query = [09:27:05.828] processed = [09:27:05.828] __func__ = "refresh_matview_datafill" [09:27:05.828] #8 0x000055f8cc88483b in RefreshMatViewByOid (matviewOid=27343, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [09:27:05.828] dest = [09:27:05.828] matviewRel = 0x7f1496b04f38 [09:27:05.828] rule = [09:27:05.828] actions = [09:27:05.828] dataQuery = 0x55f8cf64ed10 [09:27:05.828] tableSpace = [09:27:05.828] relowner = 10 [09:27:05.828] OIDNewHeap = 27356 [09:27:05.828] processed = 0 [09:27:05.828] relpersistence = 112 'p' [09:27:05.828] save_userid = 10 [09:27:05.828] save_sec_context = 0 [09:27:05.828] save_nestlevel = 2 [09:27:05.828] address = {classId = 0, objectId = 0, objectSubId = 0} [09:27:05.828] __func__ = "RefreshMatViewByOid" [09:27:05.828] #9 0x000055f8cc88497a in ExecRefreshMatView (stmt=0x55f8cf612ce0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [09:27:05.828] matviewOid = [09:27:05.828] lockmode = [09:27:05.828] #10 0x000055f8cc83c044 in ExecCreateTableAs (pstate=pstate@entry=0x55f8cf5f7030, stmt=stmt@entry=0x55f8cf4ad790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffe3f665c0) at ../src/backend/commands/createas.c:350 [09:27:05.828] refresh = [09:27:05.828] query = 0x55f8cf4ad950 [09:27:05.828] into = 0x55f8cf4ad4e8 [09:27:05.828] is_matview = true [09:27:05.828] do_refresh = false [09:27:05.828] dest = [09:27:05.828] address = {classId = 1259, objectId = 27343, objectSubId = 0} [09:27:05.828] __func__ = "ExecCreateTableAs" [09:27:05.828] #11 0x000055f8ccd484e8 in ProcessUtilitySlow (pstate=pstate@entry=0x55f8cf5f7030, pstmt=pstmt@entry=0x55f8cf4ad840, queryString=queryString@entry=0x55f8cf4aca50 "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=0x55f8cf4ae7e8, qc=0x7fffe3f665c0) at ../src/backend/tcop/utility.c:1675 [09:27:05.828] _save_exception_stack = 0x7fffe3f66170 [09:27:05.828] _save_context_stack = 0x0 [09:27:05.828] _local_sigjmp_buf = {{__jmpbuf = {0, -4357480823799216299, 94527118038928, 0, 94527118035536, 0, -7527406970087733419, -4357486100546648235}, __mask_was_saved = 0, __saved_mask = {__val = {4, 2, 94527076920509, 1023, 94527076158287, 0, 0, 94527082199712, 94527076410863, 139726407338048, 1, 16777216, 0, 112, 94527076158559, 139726407696384}}}} [09:27:05.828] _do_rethrow = false [09:27:05.828] parsetree = 0x55f8cf4ad790 [09:27:05.828] isTopLevel = true [09:27:05.828] isCompleteQuery = true [09:27:05.828] needCleanup = false [09:27:05.828] commandCollected = false [09:27:05.828] address = {classId = 22008, objectId = 3477788560, objectSubId = 22008} [09:27:05.828] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [09:27:05.828] __func__ = "ProcessUtilitySlow" [09:27:05.828] #12 0x000055f8ccd46af9 in standard_ProcessUtility (pstmt=pstmt@entry=0x55f8cf4ad840, queryString=queryString@entry=0x55f8cf4aca50 "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=0x55f8cf4ae7e8, qc=0x7fffe3f665c0) at ../src/backend/tcop/utility.c:1067 [09:27:05.828] parsetree = 0x55f8cf4ad790 [09:27:05.828] isTopLevel = true [09:27:05.828] isAtomicContext = false [09:27:05.828] pstate = 0x55f8cf5f7030 [09:27:05.828] readonly_flags = [09:27:05.828] __func__ = "standard_ProcessUtility" [09:27:05.828] #13 0x00007f149902cd4a in pgss_ProcessUtility (pstmt=0x55f8cf4ad840, queryString=0x55f8cf4aca50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55f8cf4ae7e8, qc=0x7fffe3f665c0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [09:27:05.828] _save_exception_stack = 0x7fffe3f66480 [09:27:05.828] _save_context_stack = 0x0 [09:27:05.828] _local_sigjmp_buf = {{__jmpbuf = {0, 7527345469402318677, 94527118039104, 94527118043112, 140737017963968, 0, -7527406970108704939, -7611168207735027883}, __mask_was_saved = 0, __saved_mask = {__val = {94527079968509, 140737017963238, 140737017963236, 0, 0, 139637976727552, 206158430232, 140737017963200, 94527079968726, 0, 206158430232, 94527118039904, 140737017963296, 0, 94527074821287, 94527118035280}}}} [09:27:05.828] _do_rethrow = false [09:27:05.828] duration = [09:27:05.828] bufusage = {shared_blks_hit = 94527119631768, shared_blks_read = 1065151889408, shared_blks_dirtied = 0, shared_blks_written = 94527119631272, local_blks_hit = 94527119631768, local_blks_read = 94527073160386, local_blks_dirtied = 94527119916808, local_blks_written = 94527073160632, temp_blks_read = 94527119631272, temp_blks_written = 94527119630688, shared_blk_read_time = {ticks = 94527073159741}, shared_blk_write_time = {ticks = 94527079961961}, local_blk_read_time = {ticks = 139726476377528}, local_blk_write_time = {ticks = 94527118035536}, temp_blk_read_time = {ticks = 94527082270693}, temp_blk_write_time = {ticks = 94527092180194}} [09:27:05.828] walusage_start = {wal_records = 8929, wal_fpi = 129, wal_bytes = 1223854} [09:27:05.828] start = [09:27:05.828] rows = [09:27:05.828] bufusage_start = {shared_blks_hit = 33800, shared_blks_read = 3587, shared_blks_dirtied = 1468, shared_blks_written = 978, 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}} [09:27:05.828] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 139726407338048} [09:27:05.828] parsetree = [09:27:05.828] saved_queryId = 6041762721901209185 [09:27:05.828] saved_stmt_location = 0 [09:27:05.828] saved_stmt_len = 69 [09:27:05.828] enabled = true [09:27:05.828] #14 0x000055f8ccd46b9f in ProcessUtility (pstmt=pstmt@entry=0x55f8cf4ad840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55f8cf4ae7e8, qc=0x7fffe3f665c0) at ../src/backend/tcop/utility.c:519 [09:27:05.828] No locals. [09:27:05.828] #15 0x000055f8ccd424c0 in PortalRunUtility (portal=portal@entry=0x55f8cf52df90, pstmt=pstmt@entry=0x55f8cf4ad840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f8cf4ae7e8, qc=qc@entry=0x7fffe3f665c0) at ../src/backend/tcop/pquery.c:1158 [09:27:05.828] No locals. [09:27:05.828] #16 0x000055f8ccd42a65 in PortalRunMulti (portal=portal@entry=0x55f8cf52df90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f8cf4ae7e8, altdest=altdest@entry=0x55f8cf4ae7e8, qc=qc@entry=0x7fffe3f665c0) at ../src/backend/tcop/pquery.c:1316 [09:27:05.828] pstmt = 0x55f8cf4ad840 [09:27:05.828] stmtlist_item__state = [09:27:05.828] active_snapshot_set = false [09:27:05.828] stmtlist_item = 0x55f8cf4ae7b0 [09:27:05.828] #17 0x000055f8ccd43038 in PortalRun (portal=portal@entry=0x55f8cf52df90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55f8cf4ae7e8, altdest=altdest@entry=0x55f8cf4ae7e8, qc=0x7fffe3f665c0) at ../src/backend/tcop/pquery.c:791 [09:27:05.828] _save_exception_stack = 0x7fffe3f66670 [09:27:05.828] _save_context_stack = 0x0 [09:27:05.828] _local_sigjmp_buf = {{__jmpbuf = {0, -4357480822378395819, 94527118565264, 94527118039048, 94527118565264, 94527118038976, -7527406968722487467, -4357486098460375211}, __mask_was_saved = 0, __saved_mask = {__val = {94527079646622, 94527118035280, 112, 4, 94527079651039, 3824575823, 4, 94527118038976, 112, 73, 94527118565264, 94527118039048, 94527118039024, 94527118038976, 94527079738242, 1}}}} [09:27:05.828] _do_rethrow = [09:27:05.828] result = [09:27:05.828] nprocessed = [09:27:05.828] saveTopTransactionResourceOwner = 0x55f8cf4ed468 [09:27:05.828] saveTopTransactionContext = 0x55f8cf5403c0 [09:27:05.828] saveActivePortal = 0x0 [09:27:05.828] saveResourceOwner = 0x55f8cf4ed468 [09:27:05.828] savePortalContext = 0x0 [09:27:05.828] saveMemoryContext = 0x55f8cf5403c0 [09:27:05.828] __func__ = "PortalRun" [09:27:05.828] #18 0x000055f8ccd3c6d4 in exec_simple_query (query_string=query_string@entry=0x55f8cf4aca50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [09:27:05.828] cmdtaglen = 24 [09:27:05.828] snapshot_set = [09:27:05.828] per_parsetree_context = 0x0 [09:27:05.828] plantree_list = 0x55f8cf4ae798 [09:27:05.828] parsetree = 0x55f8cf4ad7c0 [09:27:05.828] commandTag = [09:27:05.828] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:27:05.828] querytree_list = [09:27:05.828] portal = 0x55f8cf52df90 [09:27:05.828] receiver = 0x55f8cf4ae7e8 [09:27:05.828] format = 0 [09:27:05.828] cmdtagname = [09:27:05.828] parsetree_item__state = [09:27:05.828] dest = DestRemote [09:27:05.828] oldcontext = 0x55f8cf5403c0 [09:27:05.828] parsetree_list = 0x55f8cf4ad7f0 [09:27:05.828] parsetree_item = 0x55f8cf4ad808 [09:27:05.828] save_log_statement_stats = false [09:27:05.828] was_logged = true [09:27:05.828] use_implicit_block = false [09:27:05.828] msec_str = " h\366\343\377\177\000\000\2443\377\314\370U\000\000Pf\366\343\377\177\000\000G\000\000\000\000\000\000" [09:27:05.828] __func__ = "exec_simple_query" [09:27:05.828] #19 0x000055f8ccd3f1ad in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [09:27:05.828] query_string = 0x55f8cf4aca50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [09:27:05.828] firstchar = [09:27:05.828] input_message = {data = 0x55f8cf4aca50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [09:27:05.828] local_sigjmp_buf = {{__jmpbuf = {94527092188760, -4357484073684367531, 4, 140737017964576, 140737017964720, 140737017964724, -7527406968793790635, -4357486122168678571}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94527118285120, 0, 168, 94527079651141, 0, 10, 2, 94527092188768, 94527117766128, 94527092182848, 140737017964576, 140737017964720, 140737017964724}}}} [09:27:05.828] send_ready_for_query = false [09:27:05.828] idle_in_transaction_timeout_enabled = false [09:27:05.828] idle_session_timeout_enabled = false [09:27:05.828] __func__ = "PostgresMain" [09:27:05.828] #20 0x000055f8ccd352cf in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:27:05.828] bsdata = [09:27:05.828] #21 0x000055f8ccbedb60 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffe3f667cc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffe3f66820) at ../src/backend/postmaster/launch_backend.c:274 [09:27:05.828] pid = [09:27:05.828] #22 0x000055f8ccbf360c in BackendStartup (client_sock=client_sock@entry=0x7fffe3f66820) at ../src/backend/postmaster/postmaster.c:3415 [09:27:05.828] bn = 0x55f8cf4d92e8 [09:27:05.828] pid = [09:27:05.828] startup_data = {canAcceptConnections = CAC_OK} [09:27:05.828] __func__ = "BackendStartup" [09:27:05.828] #23 0x000055f8ccbf3b6e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [09:27:05.828] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\366\343\377\177\000\000\264h\366\343\377\177", '\000' , "\316\315\333\313\370U\000\000H\267\327\313\370U\000\000\200i\366\343\377\177\000\000xi\366\343\377\177\000\000\225[\362\001\000\000\000\000pjM\317\370U\000\000,", '\000' , "\343\314\333\313\370U\000\000h\226\234\234\024\177\000\0000\206\203\233\024\177\000", __ss_align = 139726503580384}, salen = 2}} [09:27:05.828] i = 0 [09:27:05.828] now = [09:27:05.828] last_lockfile_recheck_time = 1726565035 [09:27:05.828] last_touch_time = 1726565035 [09:27:05.828] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = -1667459480, user_data = 0x0}, {pos = -1667460384, events = 32532, fd = 2090263927, user_data = 0x7fffe3f66a00}, {pos = -1667630520, events = 32532, fd = 15, user_data = 0x7f149b838630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1667460384, events = 32532, fd = -470390408, user_data = 0x7fffe3f66980}, {pos = -1667459480, events = 32532, fd = 0, user_data = 0x55f8cf4ae890}, {pos = -855249429, events = 22008, fd = 32768, user_data = 0x1}, {pos = -817179280, events = 22008, fd = -1, user_data = 0x7f149b02e020}, {pos = -1671688288, events = 32532, fd = -817003768, user_data = 0x55f8cf4d81e8}, {pos = -816985967, events = 22008, fd = -1667604802, user_data = 0x1}, {pos = -1667460384, events = 32532, fd = 438, user_data = 0x55f8cd569db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55f8cf4ae890}, {pos = -1667604802, events = 32532, fd = 1, user_data = 0x0}, {pos = -1694310368, events = 32532, fd = -1693504064, user_data = 0x10}, {pos = -470389264, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1667595846, user_data = 0x0}, {pos = -1693782748, events = 32532, fd = 0, user_data = 0x55f8cdbf8000 }, {pos = 2, events = 0, fd = 7, user_data = 0x55f8cf46ee90}, {pos = -858979119, events = 22008, fd = -816965285, user_data = 0x55f8cccd410a }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55f8cf4ae890}, {pos = -1667604802, events = 32532, fd = 1, user_data = 0x0}, {pos = -1694276408, events = 32532, fd = -1693857664, user_data = 0x41e}, {pos = -1693749267, events = 32532, fd = 2, user_data = 0x55f8cf4e1900}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -1692459936, events = 32532, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa67}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -1679268544, user_data = 0x7f149be86a80}, {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 = -855571042, events = 22008, fd = -816990064, user_data = 0x7f149b0b583e}, {pos = -1692476960, events = 32532, fd = -1693838994, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x745238ee49dcb700}, {pos = -1692473888, events = 32532, 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 = -817004376, user_data = 0x55f8cd010e61 }, {pos = -817004576, events = 22008, fd = 3, user_data = 0x0}, {pos = 33097, events = 0, fd = -328, user_data = 0x0}, {pos = -817174384, events = 22008, fd = -1693503533, user_data = 0x7fffe3f66ea8}, {pos = -855487726, events = 22008, fd = -843028976, user_data = 0x55f8cd0135cf }, {pos = -817004576, events = 22008, fd = -817182384, user_data = 0x55f8cf4d7fe0}, {pos = -1693755330, events = 32532, fd = 0, user_data = 0x55f8cd025239 }, {pos = -817004576, events = 1, fd = -855485566, user_data = 0x55f8cf4ac950}, {pos = 1239201536, events = 1951545582, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1693832527, user_data = 0x7f149b0a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1239201536, user_data = 0x55f8cf484080}, {pos = 1239201536, events = 1951545582, fd = 11, user_data = 0x745238ee49dcb700}, {pos = 0, events = 0, fd = -1694125511, user_data = 0x1}, {pos = -859908003, events = 22008, fd = 4194304, user_data = 0x55f8cd013463 }, {pos = -817348480, events = 22008, fd = -817182384, user_data = 0x55f8cf484080}, {pos = 1, events = 0, fd = 0, user_data = 0x55f8cd025239 }, {pos = -817348480, events = 22008, fd = -855485566, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55f8cca24936 }, {pos = 0, events = 0, fd = -861758346, user_data = 0xb}, {pos = -859886854, events = 22008, fd = -846621776, user_data = 0x55f8cf4ad308}} [09:27:05.829] nevents = 1 [09:27:05.829] __func__ = "ServerLoop" [09:27:05.829] #24 0x000055f8ccbf52e4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55f8cf46acf0) at ../src/backend/postmaster/postmaster.c:1346 [09:27:05.829] opt = [09:27:05.829] status = [09:27:05.829] userDoption = [09:27:05.829] listen_addr_saved = false [09:27:05.829] output_config_variable = [09:27:05.829] __func__ = "PostmasterMain" [09:27:05.829] #25 0x000055f8cca34d12 in main (argc=4, argv=0x55f8cf46acf0) at ../src/backend/main/main.c:197 [09:27:05.829] do_check_root = [09:27:05.862] -e [09:27:05.862] [09:27:05.862] [09:27:05.924] dumping /tmp/cores/postgres-6-29555.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:27:06.176] [New LWP 29555] [09:27:06.176] [09:27:06.176] This GDB supports auto-downloading debuginfo from the following URLs: [09:27:06.176] [09:27:06.176] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:27:06.176] Debuginfod has been disabled. [09:27:06.176] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:27:06.282] [Thread debugging using libthread_db enabled] [09:27:06.282] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:27:06.282] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [09:27:06.282] Program terminated with signal SIGABRT, Aborted. [09:27:06.282] #0 0x00007f66cc6a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:07.132] [09:27:07.132] Thread 1 (Thread 0x7f66cd487f00 (LWP 29555)): [09:27:07.132] #0 0x00007f66cc6a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:07.132] No symbol table info available. [09:27:07.132] #1 0x00007f66cc65afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:07.132] No symbol table info available. [09:27:07.132] #2 0x00007f66cc645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:07.132] No symbol table info available. [09:27:07.132] #3 0x00005588d530167c in ExceptionalCondition (conditionName=conditionName@entry=0x5588d55724c5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5588d5571a30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [09:27:07.132] No locals. [09:27:07.132] #4 0x00005588d4c8f2f1 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5588d6704450, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [09:27:07.132] estate = 0x5588d655bd80 [09:27:07.132] oldcontext = 0x5588d66d0bb0 [09:27:07.132] __func__ = "standard_ExecutorStart" [09:27:07.132] #5 0x00005588d4c8f4cd in ExecutorStart (queryDesc=queryDesc@entry=0x5588d6704450, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [09:27:07.132] No locals. [09:27:07.132] #6 0x00005588d4bb64d4 in refresh_matview_datafill (dest=0x5588d66867d8, query=, query@entry=0x5588d66d0510, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [09:27:07.132] rewritten = [09:27:07.132] plan = 0x5588d6703988 [09:27:07.132] queryDesc = 0x5588d6704450 [09:27:07.132] copied_query = [09:27:07.132] processed = [09:27:07.132] __func__ = "refresh_matview_datafill" [09:27:07.132] #7 0x00005588d4bb883b in RefreshMatViewByOid (matviewOid=27451, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [09:27:07.132] dest = [09:27:07.132] matviewRel = 0x7f66c0cce0c8 [09:27:07.132] rule = [09:27:07.132] actions = [09:27:07.132] dataQuery = 0x5588d66d0510 [09:27:07.132] tableSpace = [09:27:07.132] relowner = 10 [09:27:07.132] OIDNewHeap = 27458 [09:27:07.132] processed = 0 [09:27:07.132] relpersistence = 112 'p' [09:27:07.132] save_userid = 10 [09:27:07.132] save_sec_context = 0 [09:27:07.132] save_nestlevel = 2 [09:27:07.132] address = {classId = 0, objectId = 0, objectSubId = 0} [09:27:07.132] __func__ = "RefreshMatViewByOid" [09:27:07.132] #8 0x00005588d4bb897a in ExecRefreshMatView (stmt=0x5588d66ce0a0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [09:27:07.132] matviewOid = [09:27:07.132] lockmode = [09:27:07.132] #9 0x00005588d4b70044 in ExecCreateTableAs (pstate=pstate@entry=0x5588d66d0cb0, stmt=stmt@entry=0x5588d65297f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffec70fbf40) at ../src/backend/commands/createas.c:350 [09:27:07.132] refresh = [09:27:07.132] query = 0x5588d65299b0 [09:27:07.132] into = 0x5588d6529548 [09:27:07.132] is_matview = true [09:27:07.132] do_refresh = false [09:27:07.132] dest = [09:27:07.132] address = {classId = 1259, objectId = 27451, objectSubId = 0} [09:27:07.132] __func__ = "ExecCreateTableAs" [09:27:07.132] #10 0x00005588d507c4e8 in ProcessUtilitySlow (pstate=pstate@entry=0x5588d66d0cb0, pstmt=pstmt@entry=0x5588d65298a0, queryString=queryString@entry=0x5588d6528ab0 "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=0x5588d652a2d8, qc=0x7ffec70fbf40) at ../src/backend/tcop/utility.c:1675 [09:27:07.132] _save_exception_stack = 0x7ffec70fbe00 [09:27:07.132] _save_context_stack = 0x0 [09:27:07.132] _local_sigjmp_buf = {{__jmpbuf = {0, 8966389981804788468, 94046199650288, 0, 94046199646896, 0, 2919219404677348084, 8966388152771050228}, __mask_was_saved = 0, __saved_mask = {__val = {140079306515776, 10504, 94046177398626, 1, 4294977800, 140079306515776, 94046177388944, 1, 45117932422968, 1, 10504, 140079306515776, 140079306515776, 1, 94046177398973, 94046199859000}}}} [09:27:07.132] _do_rethrow = false [09:27:07.132] parsetree = 0x5588d65297f0 [09:27:07.132] isTopLevel = true [09:27:07.132] isCompleteQuery = true [09:27:07.132] needCleanup = false [09:27:07.132] commandCollected = false [09:27:07.132] address = {classId = 21896, objectId = 3595737072, objectSubId = 21896} [09:27:07.132] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [09:27:07.132] __func__ = "ProcessUtilitySlow" [09:27:07.132] #11 0x00005588d507aaf9 in standard_ProcessUtility (pstmt=0x5588d65298a0, queryString=0x5588d6528ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5588d652a2d8, qc=0x7ffec70fbf40) at ../src/backend/tcop/utility.c:1067 [09:27:07.132] parsetree = 0x5588d65297f0 [09:27:07.132] isTopLevel = true [09:27:07.132] isAtomicContext = false [09:27:07.132] pstate = 0x5588d66d0cb0 [09:27:07.132] readonly_flags = [09:27:07.132] __func__ = "standard_ProcessUtility" [09:27:07.132] #12 0x00005588d507ac54 in ProcessUtility (pstmt=pstmt@entry=0x5588d65298a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5588d652a2d8, qc=0x7ffec70fbf40) at ../src/backend/tcop/utility.c:523 [09:27:07.132] No locals. [09:27:07.132] #13 0x00005588d50764c0 in PortalRunUtility (portal=portal@entry=0x5588d65ab050, pstmt=pstmt@entry=0x5588d65298a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5588d652a2d8, qc=qc@entry=0x7ffec70fbf40) at ../src/backend/tcop/pquery.c:1158 [09:27:07.132] No locals. [09:27:07.132] #14 0x00005588d5076a65 in PortalRunMulti (portal=portal@entry=0x5588d65ab050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5588d652a2d8, altdest=altdest@entry=0x5588d652a2d8, qc=qc@entry=0x7ffec70fbf40) at ../src/backend/tcop/pquery.c:1316 [09:27:07.132] pstmt = 0x5588d65298a0 [09:27:07.132] stmtlist_item__state = [09:27:07.132] active_snapshot_set = false [09:27:07.132] stmtlist_item = 0x5588d652a2a0 [09:27:07.132] #15 0x00005588d5077038 in PortalRun (portal=portal@entry=0x5588d65ab050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5588d652a2d8, altdest=altdest@entry=0x5588d652a2d8, qc=0x7ffec70fbf40) at ../src/backend/tcop/pquery.c:791 [09:27:07.132] _save_exception_stack = 0x7ffec70fbff0 [09:27:07.132] _save_context_stack = 0x0 [09:27:07.132] _local_sigjmp_buf = {{__jmpbuf = {0, 8966389982019746548, 94046200180816, 94046199650408, 94046200180816, 94046199650336, 2919219404815760116, 8966388154858109684}, __mask_was_saved = 0, __saved_mask = {__val = {94046180885918, 94046199646640, 112, 4, 94046180890335, 3339697871, 4, 94046199650336, 112, 73, 94046200180816, 94046199650408, 94046199650384, 94046199650336, 94046180977538, 1}}}} [09:27:07.132] _do_rethrow = [09:27:07.132] result = [09:27:07.132] nprocessed = [09:27:07.132] saveTopTransactionResourceOwner = 0x5588d6567d08 [09:27:07.132] saveTopTransactionContext = 0x5588d65bcc60 [09:27:07.132] saveActivePortal = 0x0 [09:27:07.132] saveResourceOwner = 0x5588d6567d08 [09:27:07.132] savePortalContext = 0x0 [09:27:07.132] saveMemoryContext = 0x5588d65bcc60 [09:27:07.132] __func__ = "PortalRun" [09:27:07.132] #16 0x00005588d50706d4 in exec_simple_query (query_string=query_string@entry=0x5588d6528ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [09:27:07.132] cmdtaglen = 24 [09:27:07.132] snapshot_set = [09:27:07.132] per_parsetree_context = 0x0 [09:27:07.132] plantree_list = 0x5588d652a288 [09:27:07.132] parsetree = 0x5588d6529820 [09:27:07.132] commandTag = [09:27:07.132] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:27:07.132] querytree_list = [09:27:07.132] portal = 0x5588d65ab050 [09:27:07.132] receiver = 0x5588d652a2d8 [09:27:07.132] format = 0 [09:27:07.132] cmdtagname = [09:27:07.132] parsetree_item__state = [09:27:07.132] dest = DestRemote [09:27:07.132] oldcontext = 0x5588d65bcc60 [09:27:07.132] parsetree_list = 0x5588d6529850 [09:27:07.132] parsetree_item = 0x5588d6529868 [09:27:07.132] save_log_statement_stats = false [09:27:07.132] was_logged = false [09:27:07.132] use_implicit_block = false [09:27:07.132] msec_str = "\240\301\017\307\376\177\000\000\244s2ՈU\000\000п\017\307\376\177\000\000G\000\000\000\000\000\000" [09:27:07.132] __func__ = "exec_simple_query" [09:27:07.132] #17 0x00005588d50731ad in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [09:27:07.132] query_string = 0x5588d6528ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [09:27:07.132] firstchar = [09:27:07.132] input_message = {data = 0x5588d6528ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [09:27:07.132] local_sigjmp_buf = {{__jmpbuf = {94046193428056, 8966389148908288756, 4, 140732238119328, 140732238119472, 140732238119476, 2919219404744456948, 8966388156953164532}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94046199377360, 15616, 94046193422144, 94046199901376, 140732238119472, 94046180889883, 0, 9, 2, 94046193428064, 94046199377360, 94046193422144, 140732238119328, 140732238119472, 140732238119476}}}} [09:27:07.132] send_ready_for_query = false [09:27:07.132] idle_in_transaction_timeout_enabled = false [09:27:07.132] idle_session_timeout_enabled = false [09:27:07.132] __func__ = "PostgresMain" [09:27:07.132] #18 0x00005588d50692cf in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:27:07.132] bsdata = [09:27:07.132] #19 0x00005588d4f21b60 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffec70fc14c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffec70fc1a0) at ../src/backend/postmaster/launch_backend.c:274 [09:27:07.132] pid = [09:27:07.132] #20 0x00005588d4f2760c in BackendStartup (client_sock=client_sock@entry=0x7ffec70fc1a0) at ../src/backend/postmaster/postmaster.c:3415 [09:27:07.132] bn = 0x5588d65513e8 [09:27:07.132] pid = [09:27:07.132] startup_data = {canAcceptConnections = CAC_OK} [09:27:07.132] __func__ = "BackendStartup" [09:27:07.132] #21 0x00005588d4f27b6e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [09:27:07.132] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\017\307\376\177\000\0004\302\017\307\376\177", '\000' , "\316\r\017ԈU\000\000H\367\nԈU\000\000\000\303\017\307\376\177\000\000\370\302\017\307\376\177\000\000\225[\362\001\000\000\000\000\240Բ\315f\177\000\000+", '\000' , "\343\f\017ԈU\000\000h\206\005\316f\177\000\0000ֲ\315f\177\000", __ss_align = 140079519859424}, salen = 2}} [09:27:07.132] i = 0 [09:27:07.132] now = [09:27:07.132] last_lockfile_recheck_time = 1726565000 [09:27:07.132] last_touch_time = 1726565000 [09:27:07.132] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -737210930, events = 21896, fd = -838498712, user_data = 0x7f66cdb2d630}, {pos = -838499616, events = 32614, fd = 2090263927, user_data = 0x7ffec70fc380}, {pos = -838669752, events = 32614, fd = 15, user_data = 0x7f66cdb2d630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -838499616, events = 32614, fd = -955268360, user_data = 0x7ffec70fc300}, {pos = -838498712, events = 32614, fd = 0, user_data = 0x5588d6528b70}, {pos = -717672981, events = 21896, fd = 32768, user_data = 0x1}, {pos = -699225936, events = 21896, fd = -1, user_data = 0x7f66cc62e020}, {pos = -843419744, events = 32614, fd = -699050168, user_data = 0x5588d6555628}, {pos = -699041727, events = 21896, fd = -838644034, user_data = 0x1}, {pos = -838499616, events = 32614, fd = 438, user_data = 0x5588d589ddb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x5588d6528b70}, {pos = -838644034, events = 32614, fd = 1, user_data = 0x0}, {pos = -865935328, events = 32614, fd = -865129024, user_data = 0x10}, {pos = -955267216, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -838635078, user_data = 0x0}, {pos = -865407708, events = 32614, fd = 0, user_data = 0x5588d5f2c000 }, {pos = 2, events = 0, fd = 7, user_data = 0x5588d64eae70}, {pos = -721402671, events = 21896, fd = -699024165, user_data = 0x5588d500810a }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5588d6528b70}, {pos = -838644034, events = 32614, fd = 1, user_data = 0x0}, {pos = -865901368, events = 32614, fd = -865482624, user_data = 0x41e}, {pos = -865374227, events = 32614, fd = 2, user_data = 0x5588d6554410}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -864084896, events = 32614, 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 = 0x4f3239562d737365}, {pos = 168446037, events = 824188960, fd = 822763892, user_data = 0x30340a3030303536}, {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 = -717994594, events = 21896, fd = -699047888, user_data = 0x7f66cc6b56eb}, {pos = -864101920, events = 32614, fd = -865463954, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xd0d6cf8515075a00}, {pos = -864098848, events = 32614, 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 = -699050776, user_data = 0x5588d5344e61 }, {pos = -699050976, events = 21896, fd = 3, user_data = 0x0}, {pos = 25778, events = 0, fd = -328, user_data = 0x0}, {pos = -699233424, events = 21896, fd = -865128493, user_data = 0x7ffec70fc828}, {pos = -717911278, events = 21896, fd = -705452528, user_data = 0x5588d53475cf }, {pos = -699050976, events = 21896, fd = -699233872, user_data = 0x5588d6555420}, {pos = -865380290, events = 32614, fd = 0, user_data = 0x5588d5359239 }, {pos = -699050976, events = 1, fd = -717909118, user_data = 0x5588d65289b0}, {pos = 352803328, events = 3503738757, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -865457487, user_data = 0x7f66cc6a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 352803328, user_data = 0x5588d65000e0}, {pos = 352803328, events = 3503738757, fd = 11, user_data = 0xd0d6cf8515075a00}, {pos = 0, events = 0, fd = -865750471, user_data = 0x1}, {pos = -722331555, events = 21896, fd = 4194304, user_data = 0x5588d5347463 }, {pos = -699399968, events = 21896, fd = -699233872, user_data = 0x5588d65000e0}, {pos = 1, events = 0, fd = 0, user_data = 0x5588d5359239 }, {pos = -699399968, events = 21896, fd = -717909118, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x5588d4d58936 }, {pos = 0, events = 0, fd = -724181898, user_data = 0xb}, {pos = -722310406, events = 21896, fd = -709045328, user_data = 0x5588d6529388}} [09:27:07.132] nevents = 1 [09:27:07.132] __func__ = "ServerLoop" [09:27:07.132] #22 0x00005588d4f292e4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5588d64e6d30) at ../src/backend/postmaster/postmaster.c:1346 [09:27:07.132] opt = [09:27:07.132] status = [09:27:07.132] userDoption = [09:27:07.132] listen_addr_saved = false [09:27:07.132] output_config_variable = [09:27:07.132] __func__ = "PostmasterMain" [09:27:07.132] #23 0x00005588d4d68d12 in main (argc=8, argv=0x5588d64e6d30) at ../src/backend/main/main.c:197 [09:27:07.132] do_check_root = [09:27:07.166] -e [09:27:07.166] [09:27:07.166] [09:27:07.226] dumping /tmp/cores/postgres-6-30027.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:27:07.469] [New LWP 30027] [09:27:07.469] [09:27:07.469] This GDB supports auto-downloading debuginfo from the following URLs: [09:27:07.469] [09:27:07.469] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:27:07.469] Debuginfod has been disabled. [09:27:07.469] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:27:07.573] [Thread debugging using libthread_db enabled] [09:27:07.573] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:27:07.573] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [09:27:07.573] Program terminated with signal SIGABRT, Aborted. [09:27:07.573] #0 0x00007fd7602a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:08.420] [09:27:08.420] Thread 1 (Thread 0x7fd75e21ff00 (LWP 30027)): [09:27:08.420] #0 0x00007fd7602a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:08.420] No symbol table info available. [09:27:08.420] #1 0x00007fd76025afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:08.420] No symbol table info available. [09:27:08.420] #2 0x00007fd760245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:27:08.420] No symbol table info available. [09:27:08.420] #3 0x000055b40d0ae67c in ExceptionalCondition (conditionName=conditionName@entry=0x55b40d31f4c5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55b40d31ea30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [09:27:08.420] No locals. [09:27:08.420] #4 0x000055b40ca3c2f1 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55b40ed77f50, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [09:27:08.420] estate = 0x55b40edc4e10 [09:27:08.420] oldcontext = 0x55b40ed7b250 [09:27:08.420] __func__ = "standard_ExecutorStart" [09:27:08.420] #5 0x000055b40ca3c4cd in ExecutorStart (queryDesc=queryDesc@entry=0x55b40ed77f50, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [09:27:08.420] No locals. [09:27:08.420] #6 0x000055b40c9634d4 in refresh_matview_datafill (dest=0x55b40ed74fc8, query=, query@entry=0x55b40edd9710, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [09:27:08.420] rewritten = [09:27:08.420] plan = 0x55b40ed77488 [09:27:08.420] queryDesc = 0x55b40ed77f50 [09:27:08.420] copied_query = [09:27:08.420] processed = [09:27:08.420] __func__ = "refresh_matview_datafill" [09:27:08.420] #7 0x000055b40c96583b in RefreshMatViewByOid (matviewOid=27436, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [09:27:08.420] dest = [09:27:08.420] matviewRel = 0x7fd754b47fb8 [09:27:08.420] rule = [09:27:08.420] actions = [09:27:08.420] dataQuery = 0x55b40edd9710 [09:27:08.420] tableSpace = [09:27:08.420] relowner = 10 [09:27:08.420] OIDNewHeap = 27443 [09:27:08.420] processed = 0 [09:27:08.420] relpersistence = 112 'p' [09:27:08.420] save_userid = 10 [09:27:08.420] save_sec_context = 0 [09:27:08.420] save_nestlevel = 2 [09:27:08.420] address = {classId = 0, objectId = 0, objectSubId = 0} [09:27:08.420] __func__ = "RefreshMatViewByOid" [09:27:08.420] #8 0x000055b40c96597a in ExecRefreshMatView (stmt=0x55b40ed90d10, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [09:27:08.420] matviewOid = [09:27:08.420] lockmode = [09:27:08.420] #9 0x000055b40c91d044 in ExecCreateTableAs (pstate=pstate@entry=0x55b40ed7b350, stmt=stmt@entry=0x55b40ec33770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffebc8c6320) at ../src/backend/commands/createas.c:350 [09:27:08.420] refresh = [09:27:08.420] query = 0x55b40ec33930 [09:27:08.420] into = 0x55b40ec334c8 [09:27:08.420] is_matview = true [09:27:08.420] do_refresh = false [09:27:08.420] dest = [09:27:08.420] address = {classId = 1259, objectId = 27436, objectSubId = 0} [09:27:08.420] __func__ = "ExecCreateTableAs" [09:27:08.420] #10 0x000055b40ce294e8 in ProcessUtilitySlow (pstate=pstate@entry=0x55b40ed7b350, pstmt=pstmt@entry=0x55b40ec33820, queryString=queryString@entry=0x55b40ec32a30 "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=0x55b40ec34258, qc=0x7ffebc8c6320) at ../src/backend/tcop/utility.c:1675 [09:27:08.420] _save_exception_stack = 0x7ffebc8c61e0 [09:27:08.420] _save_context_stack = 0x0 [09:27:08.420] _local_sigjmp_buf = {{__jmpbuf = {0, -1313628165811585879, 94231830148976, 0, 94231830145584, 0, -5093453829668979543, -1313632282368394071}, __mask_was_saved = 0, __saved_mask = {__val = {140562821517760, 14398, 94231798079330, 1, 4294981694, 140562821517760, 94231801881961, 140562973982136, 94231830145584, 94231804190693, 94231814100194, 94231814100320, 140732061736996, 94231804385208, 94231814100209, 94231814100320}}}} [09:27:08.420] _do_rethrow = false [09:27:08.420] parsetree = 0x55b40ec33770 [09:27:08.420] isTopLevel = true [09:27:08.420] isCompleteQuery = true [09:27:08.420] needCleanup = false [09:27:08.420] commandCollected = false [09:27:08.420] address = {classId = 21940, objectId = 247674736, objectSubId = 21940} [09:27:08.420] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [09:27:08.420] __func__ = "ProcessUtilitySlow" [09:27:08.420] #11 0x000055b40ce27af9 in standard_ProcessUtility (pstmt=0x55b40ec33820, queryString=0x55b40ec32a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55b40ec34258, qc=0x7ffebc8c6320) at ../src/backend/tcop/utility.c:1067 [09:27:08.420] parsetree = 0x55b40ec33770 [09:27:08.420] isTopLevel = true [09:27:08.420] isAtomicContext = false [09:27:08.420] pstate = 0x55b40ed7b350 [09:27:08.420] readonly_flags = [09:27:08.420] __func__ = "standard_ProcessUtility" [09:27:08.420] #12 0x000055b40ce27c54 in ProcessUtility (pstmt=pstmt@entry=0x55b40ec33820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55b40ec34258, qc=0x7ffebc8c6320) at ../src/backend/tcop/utility.c:523 [09:27:08.420] No locals. [09:27:08.420] #13 0x000055b40ce234c0 in PortalRunUtility (portal=portal@entry=0x55b40ecb5680, pstmt=pstmt@entry=0x55b40ec33820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55b40ec34258, qc=qc@entry=0x7ffebc8c6320) at ../src/backend/tcop/pquery.c:1158 [09:27:08.420] No locals. [09:27:08.420] #14 0x000055b40ce23a65 in PortalRunMulti (portal=portal@entry=0x55b40ecb5680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55b40ec34258, altdest=altdest@entry=0x55b40ec34258, qc=qc@entry=0x7ffebc8c6320) at ../src/backend/tcop/pquery.c:1316 [09:27:08.420] pstmt = 0x55b40ec33820 [09:27:08.420] stmtlist_item__state = [09:27:08.420] active_snapshot_set = false [09:27:08.420] stmtlist_item = 0x55b40ec34220 [09:27:08.420] #15 0x000055b40ce24038 in PortalRun (portal=portal@entry=0x55b40ecb5680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55b40ec34258, altdest=altdest@entry=0x55b40ec34258, qc=0x7ffebc8c6320) at ../src/backend/tcop/pquery.c:791 [09:27:08.420] _save_exception_stack = 0x7ffebc8c63d0 [09:27:08.420] _save_context_stack = 0x0 [09:27:08.420] _local_sigjmp_buf = {{__jmpbuf = {0, -1313628167098188631, 94231830681216, 94231830149096, 94231830681216, 94231830149024, -5093453831132791639, -1313632280164156247}, __mask_was_saved = 0, __saved_mask = {__val = {94231801566622, 94231830145328, 112, 4, 94231801571039, 3163316911, 4, 94231830149024, 112, 73, 94231830681216, 94231830149096, 94231830149072, 94231830149024, 94231801658242, 1}}}} [09:27:08.420] _do_rethrow = [09:27:08.420] result = [09:27:08.420] nprocessed = [09:27:08.420] saveTopTransactionResourceOwner = 0x55b40ec72838 [09:27:08.420] saveTopTransactionContext = 0x55b40ecc6660 [09:27:08.420] saveActivePortal = 0x0 [09:27:08.420] saveResourceOwner = 0x55b40ec72838 [09:27:08.420] savePortalContext = 0x0 [09:27:08.420] saveMemoryContext = 0x55b40ecc6660 [09:27:08.420] __func__ = "PortalRun" [09:27:08.420] #16 0x000055b40ce1d6d4 in exec_simple_query (query_string=query_string@entry=0x55b40ec32a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [09:27:08.420] cmdtaglen = 24 [09:27:08.420] snapshot_set = [09:27:08.420] per_parsetree_context = 0x0 [09:27:08.420] plantree_list = 0x55b40ec34208 [09:27:08.420] parsetree = 0x55b40ec337a0 [09:27:08.420] commandTag = [09:27:08.420] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:27:08.420] querytree_list = [09:27:08.420] portal = 0x55b40ecb5680 [09:27:08.420] receiver = 0x55b40ec34258 [09:27:08.420] format = 0 [09:27:08.420] cmdtagname = [09:27:08.420] parsetree_item__state = [09:27:08.420] dest = DestRemote [09:27:08.420] oldcontext = 0x55b40ecc6660 [09:27:08.420] parsetree_list = 0x55b40ec337d0 [09:27:08.420] parsetree_item = 0x55b40ec337e8 [09:27:08.420] save_log_statement_stats = false [09:27:08.420] was_logged = true [09:27:08.420] use_implicit_block = false [09:27:08.420] msec_str = "\200e\214\274\376\177\000\000\244C\r\r\264U\000\000\260c\214\274\376\177\000\000G\000\000\000\000\000\000" [09:27:08.420] __func__ = "exec_simple_query" [09:27:08.420] #17 0x000055b40ce201ad in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [09:27:08.420] query_string = 0x55b40ec32a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [09:27:08.420] firstchar = [09:27:08.420] input_message = {data = 0x55b40ec32a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [09:27:08.420] local_sigjmp_buf = {{__jmpbuf = {94231814108760, -1313634652898313047, 4, 140732061738368, 140732061738512, 140732061738516, -5093453831078265687, -1313632303998288727}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94231829876144, 14336, 94231814102848, 94231830403056, 140732061738512, 94231801570587, 0, 9, 2, 94231814108768, 94231829876144, 94231814102848, 140732061738368, 140732061738512, 140732061738516}}}} [09:27:08.420] send_ready_for_query = false [09:27:08.420] idle_in_transaction_timeout_enabled = false [09:27:08.420] idle_session_timeout_enabled = false [09:27:08.420] __func__ = "PostgresMain" [09:27:08.420] #18 0x000055b40ce162cf in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:27:08.420] bsdata = [09:27:08.420] #19 0x000055b40ccceb60 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffebc8c652c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffebc8c6580) at ../src/backend/postmaster/launch_backend.c:274 [09:27:08.420] pid = [09:27:08.420] #20 0x000055b40ccd460c in BackendStartup (client_sock=client_sock@entry=0x7ffebc8c6580) at ../src/backend/postmaster/postmaster.c:3415 [09:27:08.420] bn = 0x55b40ec67ca8 [09:27:08.420] pid = [09:27:08.420] startup_data = {canAcceptConnections = CAC_OK} [09:27:08.420] __func__ = "BackendStartup" [09:27:08.420] #21 0x000055b40ccd4b6e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [09:27:08.420] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\265a\327\177\000\000>\004\000\000\000\000\000\000\260\227#`\327\177\000\000\240\337wa\327\177\000\0008f\214\274\376\177\000\0004f\214\274\376\177", '\000' , "\316\335\351\v\264U\000\000H\307\345\v\264U\000\000\000g\214\274\376\177\000\000\370f\214\274\376\177\000\000\225[\362\0011\237\260\237\240\204\ba\327\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [09:27:08.420] i = 0 [09:27:08.420] now = [09:27:08.420] last_lockfile_recheck_time = 1726565002 [09:27:08.420] last_touch_time = 1726565002 [09:27:08.420] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = -1131649216, user_data = 0x0}, {pos = 15, events = 0, fd = 199876046, user_data = 0x7fd761b86668}, {pos = 1627948592, events = 32727, fd = 1639473888, user_data = 0x7c96e577}, {pos = -1131649152, events = 32766, fd = 1639303752, user_data = 0xf}, {pos = 1627948592, events = 32727, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1639473888, user_data = 0x7ffebc8c66f8}, {pos = -1131649280, events = 32766, fd = 1639474792, user_data = 0x0}, {pos = 247678960, events = 21940, fd = 1613688037, user_data = 0x7ffebc8c6c13}, {pos = 1, events = 0, fd = -1131649280, user_data = 0xffffffff}, {pos = 1612898336, events = 32727, fd = 1635245984, user_data = 0x55b40ec61368}, {pos = 247861832, events = 21940, fd = 247861281, user_data = 0x7fd761b62ebe}, {pos = 1, events = 0, fd = 1639473888, user_data = 0x1b6}, {pos = 224701872, events = 21940, fd = 0, user_data = 0x1}, {pos = 247671368, events = 21940, fd = 1639329470, user_data = 0x1}, {pos = 0, events = 0, fd = 1612898336, user_data = 0x7fd7602f2dc0 }, {pos = 16, events = 0, fd = -1131648176, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fd761b651ba}, {pos = 0, events = 0, fd = 1613425956, user_data = 0x0}, {pos = 231575552, events = 21940, fd = 2, user_data = 0x7}, {pos = 247418448, events = 21940, fd = 1952410737, user_data = 0x169}, {pos = 224701256, events = 21940, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 247671368, events = 21940, fd = 1639329470, user_data = 0x1}, {pos = 1613459079, events = 32727, fd = 1612932296, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1614748768, events = 32727, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55b40ebf4e50}, {pos = 1613462026, events = 32727, 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 = 0xffffffffffffffff}, {pos = -1, events = 4294967295, 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 = 1614731744, events = 32727, fd = 1613369710, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x9fb09f31be9a2600}, {pos = 1614734816, events = 32727, fd = -328, user_data = 0x0}, {pos = 247861512, events = 21940, fd = 1024, user_data = 0x55b40ec61108}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 26298, events = 0, fd = -328, user_data = 0x0}, {pos = 247671368, events = 21940, fd = 1613705171, user_data = 0x7ffebc8c6c08}, {pos = 219175698, events = 21940, fd = 231634448, user_data = 0x55b40d0f45cf }, {pos = 247861312, events = 21940, fd = 247671088, user_data = 0x55b40ec61040}, {pos = 1613453035, events = 32727, fd = 0, user_data = 0x55b40d106239 }, {pos = 247861312, events = 1, fd = 219177858, user_data = 0x55b40ec32930}, {pos = -1097193984, events = 2679152433, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1613376177, user_data = 0x7fd7602a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1097193984, user_data = 0x55b40ec0a060}, {pos = -1097193984, events = 2679152433, fd = 11, user_data = 0x9fb09f31be9a2600}, {pos = 0, events = 0, fd = 1613083193, user_data = 0x1}, {pos = 214755421, events = 21940, fd = 4194304, user_data = 0x55b40d0f4463 }, {pos = 247504992, events = 21940, fd = 247671088, user_data = 0x55b40ec0a060}, {pos = 1, events = 0, fd = 0, user_data = 0x55b40d106239 }, {pos = 247504992, events = 21940, fd = 219177858, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55b40cb05936 }, {pos = 0, events = 0, fd = 212905078, user_data = 0xb}, {pos = 214776570, events = 21940, fd = 228041648, user_data = 0x55b40ec332d8}} [09:27:08.421] nevents = 1 [09:27:08.421] __func__ = "ServerLoop" [09:27:08.421] #22 0x000055b40ccd62e4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55b40ebf0cc0) at ../src/backend/postmaster/postmaster.c:1346 [09:27:08.421] opt = [09:27:08.421] status = [09:27:08.421] userDoption = [09:27:08.421] listen_addr_saved = false [09:27:08.421] output_config_variable = [09:27:08.421] __func__ = "PostmasterMain" [09:27:08.421] #23 0x000055b40cb15d12 in main (argc=4, argv=0x55b40ebf0cc0) at ../src/backend/main/main.c:197 [09:27:08.421] do_check_root =