[06:22:29.254] src/tools/ci/cores_backtrace.sh linux /tmp/cores [06:22:29.469] dumping /tmp/cores/postgres-6-36233.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:22:29.726] [New LWP 36233] [06:22:29.726] [06:22:29.726] This GDB supports auto-downloading debuginfo from the following URLs: [06:22:29.726] [06:22:29.726] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [06:22:29.726] Debuginfod has been disabled. [06:22:29.726] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [06:22:29.855] [Thread debugging using libthread_db enabled] [06:22:29.855] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [06:22:29.855] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [06:22:29.855] Program terminated with signal SIGABRT, Aborted. [06:22:29.855] #0 0x00007f708bea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:30.899] [06:22:30.899] Thread 1 (Thread 0x7f708c633f00 (LWP 36233)): [06:22:30.899] #0 0x00007f708bea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:30.899] No symbol table info available. [06:22:30.899] #1 0x00007f708be5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:30.899] No symbol table info available. [06:22:30.899] #2 0x00007f708be45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:30.899] No symbol table info available. [06:22:30.899] #3 0x0000560229db3586 in ExceptionalCondition (conditionName=conditionName@entry=0x56022a025afd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x56022a025030 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:22:30.899] No locals. [06:22:30.899] #4 0x000056022973f17f in standard_ExecutorStart (queryDesc=0x56022c747eb0, eflags=0) at ../src/backend/executor/execMain.c:194 [06:22:30.899] estate = 0x56022c7a1040 [06:22:30.899] oldcontext = 0x56022c771b70 [06:22:30.899] __func__ = "standard_ExecutorStart" [06:22:30.899] #5 0x00007f70895616f7 in pgss_ExecutorStart (queryDesc=0x56022c747eb0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [06:22:30.899] No locals. [06:22:30.899] #6 0x000056022973f314 in ExecutorStart (queryDesc=queryDesc@entry=0x56022c747eb0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [06:22:30.899] No locals. [06:22:30.899] #7 0x00005602296654c2 in refresh_matview_datafill (dest=0x56022c64ce28, query=, query@entry=0x56022c7b5940, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [06:22:30.899] rewritten = [06:22:30.899] plan = 0x56022c7473e8 [06:22:30.899] queryDesc = 0x56022c747eb0 [06:22:30.899] copied_query = [06:22:30.899] processed = [06:22:30.899] __func__ = "refresh_matview_datafill" [06:22:30.899] #8 0x0000560229667829 in RefreshMatViewByOid (matviewOid=27241, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [06:22:30.899] dest = [06:22:30.899] matviewRel = 0x7f70878c5f38 [06:22:30.899] rule = [06:22:30.899] actions = [06:22:30.899] dataQuery = 0x56022c7b5940 [06:22:30.899] tableSpace = [06:22:30.899] relowner = 10 [06:22:30.899] OIDNewHeap = 27255 [06:22:30.899] processed = 0 [06:22:30.899] relpersistence = 112 'p' [06:22:30.899] save_userid = 10 [06:22:30.899] save_sec_context = 0 [06:22:30.899] save_nestlevel = 2 [06:22:30.899] address = {classId = 0, objectId = 0, objectSubId = 0} [06:22:30.899] __func__ = "RefreshMatViewByOid" [06:22:30.899] #9 0x0000560229667968 in ExecRefreshMatView (stmt=0x56022c76b0a0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:22:30.899] matviewOid = [06:22:30.899] lockmode = [06:22:30.899] #10 0x000056022961e7af in ExecCreateTableAs (pstate=pstate@entry=0x56022c771c70, stmt=stmt@entry=0x56022c613790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffed630d200) at ../src/backend/commands/createas.c:350 [06:22:30.899] refresh = [06:22:30.899] query = 0x56022c613950 [06:22:30.899] into = 0x56022c6134e8 [06:22:30.899] is_matview = true [06:22:30.899] do_refresh = false [06:22:30.899] dest = [06:22:30.899] address = {classId = 1259, objectId = 27241, objectSubId = 0} [06:22:30.899] __func__ = "ExecCreateTableAs" [06:22:30.899] #11 0x0000560229b2ddf7 in ProcessUtilitySlow (pstate=pstate@entry=0x56022c771c70, pstmt=pstmt@entry=0x56022c613840, queryString=queryString@entry=0x56022c612a50 "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=0x56022c6147e8, qc=0x7ffed630d200) at ../src/backend/tcop/utility.c:1675 [06:22:30.899] _save_exception_stack = 0x7ffed630cdb0 [06:22:30.899] _save_context_stack = 0x0 [06:22:30.899] _local_sigjmp_buf = {{__jmpbuf = {0, 1024154782710441268, 94567334492048, 0, 94567334488656, 0, 6759749086023853364, 1024160991018951988}, __mask_was_saved = 0, __saved_mask = {__val = {94567288935377, 0, 0, 94567294988736, 94567289188044, 140121290454464, 1, 16777216, 0, 112, 94567288935649, 140121291251712, 140121291251712, 0, 0, 140121290454464}}}} [06:22:30.899] _do_rethrow = false [06:22:30.899] parsetree = 0x56022c613790 [06:22:30.899] isTopLevel = true [06:22:30.899] isCompleteQuery = true [06:22:30.899] needCleanup = false [06:22:30.899] commandCollected = false [06:22:30.899] address = {classId = 22018, objectId = 744568720, objectSubId = 22018} [06:22:30.899] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:22:30.899] __func__ = "ProcessUtilitySlow" [06:22:30.899] #12 0x0000560229b2c408 in standard_ProcessUtility (pstmt=pstmt@entry=0x56022c613840, queryString=queryString@entry=0x56022c612a50 "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=0x56022c6147e8, qc=0x7ffed630d200) at ../src/backend/tcop/utility.c:1067 [06:22:30.899] parsetree = 0x56022c613790 [06:22:30.899] isTopLevel = true [06:22:30.899] isAtomicContext = false [06:22:30.899] pstate = 0x56022c771c70 [06:22:30.899] readonly_flags = [06:22:30.899] __func__ = "standard_ProcessUtility" [06:22:30.899] #13 0x00007f7089564d4a in pgss_ProcessUtility (pstmt=0x56022c613840, queryString=0x56022c612a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x56022c6147e8, qc=0x7ffed630d200) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [06:22:30.899] _save_exception_stack = 0x7ffed630d0c0 [06:22:30.899] _save_context_stack = 0x0 [06:22:30.899] _local_sigjmp_buf = {{__jmpbuf = {0, -6759094233061579468, 94567334492224, 94567334496232, 140732491944448, 0, 6759749086153876788, 6688915510560761140}, __mask_was_saved = 0, __saved_mask = {__val = {94567292751501, 140732491943718, 140732491943716, 0, 0, 0, 206158430232, 140732491943680, 94567292751718, 356, 206158430232, 94567334493024, 140732491943776, 0, 94567287596013, 94567334488400}}}} [06:22:30.899] _do_rethrow = false [06:22:30.899] duration = [06:22:30.899] bufusage = {shared_blks_hit = 94567336121464, shared_blks_read = 8589934592, shared_blks_dirtied = 94567335749096, shared_blks_written = 94567285935203, local_blks_hit = 94567336120968, local_blks_read = 94567336120384, local_blks_dirtied = 94567285934312, local_blks_written = 94567285487353, temp_blks_read = 94567336120968, temp_blks_written = 94567285458710, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94567292744953}, local_blk_read_time = {ticks = 140121368378808}, local_blk_write_time = {ticks = 94567334488656}, temp_blk_read_time = {ticks = 94567295057893}, temp_blk_write_time = {ticks = 94567304984354}} [06:22:30.899] walusage_start = {wal_records = 8941, wal_fpi = 146, wal_bytes = 1314700} [06:22:30.899] start = [06:22:30.899] rows = [06:22:30.899] bufusage_start = {shared_blks_hit = 33364, shared_blks_read = 3756, shared_blks_dirtied = 1594, shared_blks_written = 995, 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}} [06:22:30.899] walusage = {wal_records = 0, wal_fpi = 8589934592, wal_bytes = 94567336123400} [06:22:30.899] parsetree = [06:22:30.899] saved_queryId = 6041762721901209185 [06:22:30.899] saved_stmt_location = 0 [06:22:30.899] saved_stmt_len = 69 [06:22:30.899] enabled = true [06:22:30.899] #14 0x0000560229b2c4ae in ProcessUtility (pstmt=pstmt@entry=0x56022c613840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x56022c6147e8, qc=0x7ffed630d200) at ../src/backend/tcop/utility.c:519 [06:22:30.899] No locals. [06:22:30.899] #15 0x0000560229b27dcf in PortalRunUtility (portal=portal@entry=0x56022c693f90, pstmt=pstmt@entry=0x56022c613840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x56022c6147e8, qc=qc@entry=0x7ffed630d200) at ../src/backend/tcop/pquery.c:1158 [06:22:30.899] No locals. [06:22:30.899] #16 0x0000560229b28374 in PortalRunMulti (portal=portal@entry=0x56022c693f90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x56022c6147e8, altdest=altdest@entry=0x56022c6147e8, qc=qc@entry=0x7ffed630d200) at ../src/backend/tcop/pquery.c:1316 [06:22:30.899] pstmt = 0x56022c613840 [06:22:30.899] stmtlist_item__state = [06:22:30.899] active_snapshot_set = false [06:22:30.899] stmtlist_item = 0x56022c6147b0 [06:22:30.899] #17 0x0000560229b28947 in PortalRun (portal=portal@entry=0x56022c693f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x56022c6147e8, altdest=altdest@entry=0x56022c6147e8, qc=0x7ffed630d200) at ../src/backend/tcop/pquery.c:791 [06:22:30.899] _save_exception_stack = 0x7ffed630d2b0 [06:22:30.899] _save_context_stack = 0x0 [06:22:30.899] _local_sigjmp_buf = {{__jmpbuf = {0, 1024154784768795956, 94567335018384, 94567334492168, 94567335018384, 94567334492096, 6759749085740737844, 1024160988394759476}, __mask_was_saved = 0, __saved_mask = {__val = {94567292429614, 94567334488400, 112, 4, 94567292434031, 3593523599, 4, 94567334492096, 112, 73, 94567335018384, 94567334492168, 94567334492144, 94567334492096, 94567292521234, 1}}}} [06:22:30.899] _do_rethrow = [06:22:30.899] result = [06:22:30.899] nprocessed = [06:22:30.899] saveTopTransactionResourceOwner = 0x56022c653468 [06:22:30.899] saveTopTransactionContext = 0x56022c6a63c0 [06:22:30.899] saveActivePortal = 0x0 [06:22:30.899] saveResourceOwner = 0x56022c653468 [06:22:30.899] savePortalContext = 0x0 [06:22:30.899] saveMemoryContext = 0x56022c6a63c0 [06:22:30.899] __func__ = "PortalRun" [06:22:30.899] #18 0x0000560229b21d33 in exec_simple_query (query_string=query_string@entry=0x56022c612a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [06:22:30.899] cmdtaglen = 24 [06:22:30.899] snapshot_set = [06:22:30.899] per_parsetree_context = 0x0 [06:22:30.899] plantree_list = 0x56022c614798 [06:22:30.899] parsetree = 0x56022c6137c0 [06:22:30.899] commandTag = [06:22:30.899] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:22:30.899] querytree_list = [06:22:30.899] portal = 0x56022c693f90 [06:22:30.899] receiver = 0x56022c6147e8 [06:22:30.899] format = 0 [06:22:30.899] cmdtagname = [06:22:30.899] parsetree_item__state = [06:22:30.899] dest = DestRemote [06:22:30.899] oldcontext = 0x56022c6a63c0 [06:22:30.899] parsetree_list = 0x56022c6137f0 [06:22:30.899] parsetree_item = 0x56022c613808 [06:22:30.899] save_log_statement_stats = false [06:22:30.899] was_logged = true [06:22:30.899] use_implicit_block = false [06:22:30.899] msec_str = "`\3240\326\376\177\000\0004\223\335)\002V\000\000\220\3220\326\376\177\000\000G\000\000\000\000\000\000" [06:22:30.899] __func__ = "exec_simple_query" [06:22:30.899] #19 0x0000560229b24ab7 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [06:22:30.899] query_string = 0x56022c612a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:22:30.899] firstchar = [06:22:30.899] input_message = {data = 0x56022c612a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:22:30.899] local_sigjmp_buf = {{__jmpbuf = {94567304992920, 1024158406610068788, 4, 140732491945056, 140732491945200, 140732491945204, 6759749085803652404, 1024160995200410932}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94567334738240, 0, 168, 94567292434133, 0, 10, 2, 94567304992928, 94567334219248, 94567304987008, 140732491945056, 140732491945200, 140732491945204}}}} [06:22:30.899] send_ready_for_query = false [06:22:30.899] idle_in_transaction_timeout_enabled = false [06:22:30.899] idle_session_timeout_enabled = false [06:22:30.899] __func__ = "PostgresMain" [06:22:30.899] #20 0x0000560229b1a92e in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:22:30.899] bsdata = [06:22:30.899] #21 0x00005602299d232d in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffed630d40c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffed630d460) at ../src/backend/postmaster/launch_backend.c:274 [06:22:30.899] pid = [06:22:30.899] #22 0x00005602299d7de1 in BackendStartup (client_sock=client_sock@entry=0x7ffed630d460) at ../src/backend/postmaster/postmaster.c:3420 [06:22:30.899] bn = 0x56022c63f608 [06:22:30.899] pid = [06:22:30.899] startup_data = {canAcceptConnections = CAC_OK} [06:22:30.899] __func__ = "BackendStartup" [06:22:30.899] #23 0x00005602299d8343 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [06:22:30.899] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "0\326\376\177\000\000\364\3240\326\376\177", '\000' , "\256\276\271(\002V\000\000h\247\265(\002V\000\000\300\3250\326\376\177\000\000\270\3250\326\376\177\000\000\225[\362\001\000\000\000\000p\312c,\002V\000\000,", '\000' , "ý\271(\002V\000\000h\206w\215p\177\000\0000\246c\214p\177\000", __ss_align = 140121386484448}, salen = 2}} [06:22:30.899] i = 0 [06:22:30.899] now = [06:22:30.899] last_lockfile_recheck_time = 1727072354 [06:22:30.899] last_touch_time = 1727072354 [06:22:30.899] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 683261614, events = 22018, fd = -1921546648, user_data = 0x7f708c63a630}, {pos = -1921547552, events = 32624, fd = 2090263927, user_data = 0x7ffed630d640}, {pos = -1921717688, events = 32624, fd = 15, user_data = 0x7f708c63a630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1921547552, events = 32624, fd = -701442632, user_data = 0x7ffed630d5c0}, {pos = -1921546648, events = 32624, fd = 0, user_data = 0x56022c614890}, {pos = 702827899, events = 22018, fd = 32768, user_data = 0x1}, {pos = 744568176, events = 22018, fd = -1, user_data = 0x7f708be2e020}, {pos = -1925775456, events = 32624, fd = 744743688, user_data = 0x56022c63e1e8}, {pos = 744761489, events = 22018, fd = -1921691970, user_data = 0x1}, {pos = -1921547552, events = 32624, fd = 438, user_data = 0x56022a351db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x56022c614890}, {pos = -1921691970, events = 32624, fd = 1, user_data = 0x0}, {pos = -1948065760, events = 32624, fd = -1947259456, user_data = 0x10}, {pos = -701441488, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1921683014, user_data = 0x0}, {pos = -1947538140, events = 32624, fd = 0, user_data = 0x56022a9e2220 }, {pos = 2, events = 0, fd = 7, user_data = 0x56022c5d4e90}, {pos = 699092309, events = 22018, fd = 744782171, user_data = 0x560229ab898e }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x56022c614890}, {pos = -1921691970, events = 32624, fd = 1, user_data = 0x0}, {pos = -1948031800, events = 32624, fd = -1947613056, user_data = 0x423}, {pos = -1947504659, events = 32624, fd = 2, user_data = 0x56022c647900}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -1946215328, events = 32624, 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 = -1939622592, user_data = 0x7f708c63ba80}, {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 = 702506286, events = 22018, fd = 744757392, user_data = 0x7f708beb583e}, {pos = -1946232352, events = 32624, fd = -1947594386, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xc7f560dbe8de9500}, {pos = -1946229280, events = 32624, 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 = 744743080, user_data = 0x560229df6df1 }, {pos = 744742880, events = 22018, fd = 3, user_data = 0x0}, {pos = 32422, events = 0, fd = -328, user_data = 0x0}, {pos = 744573072, events = 22018, fd = -1947258925, user_data = 0x7ffed630dae8}, {pos = 702589602, events = 22018, fd = 715069520, user_data = 0x560229df955f }, {pos = 744742880, events = 22018, fd = 744565072, user_data = 0x56022c63dfe0}, {pos = -1947510722, events = 32624, fd = 0, user_data = 0x560229e0b1c9 }, {pos = 744742880, events = 1, fd = 702591762, user_data = 0x56022c612950}, {pos = -388066048, events = 3354747099, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1947587919, user_data = 0x7f708bea14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -388066048, user_data = 0x56022c5ea080}, {pos = -388066048, events = 3354747099, fd = 11, user_data = 0xc7f560dbe8de9500}, {pos = 0, events = 0, fd = -1947880903, user_data = 0x1}, {pos = 698163242, events = 22018, fd = 4194304, user_data = 0x560229df93f3 }, {pos = 744398976, events = 22018, fd = 744565072, user_data = 0x56022c5ea080}, {pos = 1, events = 0, fd = 0, user_data = 0x560229e0b1c9 }, {pos = 744398976, events = 22018, fd = 702591762, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5602298087e1 }, {pos = 0, events = 0, fd = 696310561, user_data = 0xb}, {pos = 698184399, events = 22018, fd = 711468528, user_data = 0x56022c613308}} [06:22:30.899] nevents = 1 [06:22:30.899] __func__ = "ServerLoop" [06:22:30.899] #24 0x00005602299d9ac6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x56022c5d0cf0) at ../src/backend/postmaster/postmaster.c:1351 [06:22:30.899] opt = [06:22:30.899] status = [06:22:30.899] userDoption = [06:22:30.899] listen_addr_saved = false [06:22:30.899] output_config_variable = [06:22:30.899] __func__ = "PostmasterMain" [06:22:30.899] #25 0x0000560229818bbd in main (argc=4, argv=0x56022c5d0cf0) at ../src/backend/main/main.c:197 [06:22:30.899] do_check_root = [06:22:30.936] -e [06:22:30.936] [06:22:30.936] [06:22:31.001] dumping /tmp/cores/postgres-6-29254.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [06:22:31.253] [New LWP 29254] [06:22:31.253] [06:22:31.253] This GDB supports auto-downloading debuginfo from the following URLs: [06:22:31.253] [06:22:31.253] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [06:22:31.253] Debuginfod has been disabled. [06:22:31.253] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [06:22:31.359] [Thread debugging using libthread_db enabled] [06:22:31.359] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [06:22:31.359] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [06:22:31.359] Program terminated with signal SIGABRT, Aborted. [06:22:31.359] #0 0x00007f4e1dca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:32.386] [06:22:32.386] Thread 1 (Thread 0x7f4e1bc1df00 (LWP 29254)): [06:22:32.386] #0 0x00007f4e1dca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:32.386] No symbol table info available. [06:22:32.386] #1 0x00007f4e1dc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:32.386] No symbol table info available. [06:22:32.386] #2 0x00007f4e1dc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:32.386] No symbol table info available. [06:22:32.386] #3 0x0000555b8da6f586 in ExceptionalCondition (conditionName=conditionName@entry=0x555b8dce1afd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x555b8dce1030 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:22:32.386] No locals. [06:22:32.386] #4 0x0000555b8d3fb17f in standard_ExecutorStart (queryDesc=queryDesc@entry=0x555b8f40af70, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [06:22:32.386] estate = 0x555b8f2d8d80 [06:22:32.386] oldcontext = 0x555b8f441f60 [06:22:32.386] __func__ = "standard_ExecutorStart" [06:22:32.386] #5 0x0000555b8d3fb35b in ExecutorStart (queryDesc=queryDesc@entry=0x555b8f40af70, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [06:22:32.386] No locals. [06:22:32.386] #6 0x0000555b8d3214c2 in refresh_matview_datafill (dest=0x555b8f413c08, query=, query@entry=0x555b8f44e520, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [06:22:32.386] rewritten = [06:22:32.386] plan = 0x555b8f40a4a8 [06:22:32.386] queryDesc = 0x555b8f40af70 [06:22:32.386] copied_query = [06:22:32.386] processed = [06:22:32.386] __func__ = "refresh_matview_datafill" [06:22:32.386] #7 0x0000555b8d323829 in RefreshMatViewByOid (matviewOid=27372, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [06:22:32.386] dest = [06:22:32.386] matviewRel = 0x7f4e122240c8 [06:22:32.386] rule = [06:22:32.386] actions = [06:22:32.386] dataQuery = 0x555b8f44e520 [06:22:32.386] tableSpace = [06:22:32.386] relowner = 10 [06:22:32.386] OIDNewHeap = 27390 [06:22:32.386] processed = 0 [06:22:32.386] relpersistence = 112 'p' [06:22:32.386] save_userid = 10 [06:22:32.386] save_sec_context = 0 [06:22:32.386] save_nestlevel = 2 [06:22:32.386] address = {classId = 0, objectId = 0, objectSubId = 0} [06:22:32.386] __func__ = "RefreshMatViewByOid" [06:22:32.386] #8 0x0000555b8d323968 in ExecRefreshMatView (stmt=0x555b8f440880, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:22:32.386] matviewOid = [06:22:32.386] lockmode = [06:22:32.386] #9 0x0000555b8d2da7af in ExecCreateTableAs (pstate=pstate@entry=0x555b8f442060, stmt=stmt@entry=0x555b8f2a67f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff69333870) at ../src/backend/commands/createas.c:350 [06:22:32.386] refresh = [06:22:32.386] query = 0x555b8f2a69b0 [06:22:32.386] into = 0x555b8f2a6548 [06:22:32.386] is_matview = true [06:22:32.386] do_refresh = false [06:22:32.386] dest = [06:22:32.386] address = {classId = 1259, objectId = 27372, objectSubId = 0} [06:22:32.386] __func__ = "ExecCreateTableAs" [06:22:32.386] #10 0x0000555b8d7e9df7 in ProcessUtilitySlow (pstate=pstate@entry=0x555b8f442060, pstmt=pstmt@entry=0x555b8f2a68a0, queryString=queryString@entry=0x555b8f2a5ab0 "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=0x555b8f2a72d8, qc=0x7fff69333870) at ../src/backend/tcop/utility.c:1675 [06:22:32.386] _save_exception_stack = 0x7fff69333730 [06:22:32.386] _save_context_stack = 0x0 [06:22:32.386] _local_sigjmp_buf = {{__jmpbuf = {0, -4303813979586588427, 93851732305904, 0, 93851732302512, 0, -7995002257959448331, -4303819098327379723}, __mask_was_saved = 0, __saved_mask = {__val = {4294977809, 139973297018752, 93851703685650, 1, 45155393312568, 1, 10513, 139973297018752, 139973297018752, 1, 93851703695679, 93851732514616, 10630746925102358528, 139973297018752, 139973297018752, 10513}}}} [06:22:32.386] _do_rethrow = false [06:22:32.386] parsetree = 0x555b8f2a67f0 [06:22:32.386] isTopLevel = true [06:22:32.386] isCompleteQuery = true [06:22:32.386] needCleanup = false [06:22:32.386] commandCollected = false [06:22:32.386] address = {classId = 21851, objectId = 2401921008, objectSubId = 21851} [06:22:32.386] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:22:32.386] __func__ = "ProcessUtilitySlow" [06:22:32.386] #11 0x0000555b8d7e8408 in standard_ProcessUtility (pstmt=0x555b8f2a68a0, queryString=0x555b8f2a5ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x555b8f2a72d8, qc=0x7fff69333870) at ../src/backend/tcop/utility.c:1067 [06:22:32.386] parsetree = 0x555b8f2a67f0 [06:22:32.386] isTopLevel = true [06:22:32.386] isAtomicContext = false [06:22:32.386] pstate = 0x555b8f442060 [06:22:32.386] readonly_flags = [06:22:32.386] __func__ = "standard_ProcessUtility" [06:22:32.386] #12 0x0000555b8d7e8563 in ProcessUtility (pstmt=pstmt@entry=0x555b8f2a68a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x555b8f2a72d8, qc=0x7fff69333870) at ../src/backend/tcop/utility.c:523 [06:22:32.386] No locals. [06:22:32.386] #13 0x0000555b8d7e3dcf in PortalRunUtility (portal=portal@entry=0x555b8f328050, pstmt=pstmt@entry=0x555b8f2a68a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x555b8f2a72d8, qc=qc@entry=0x7fff69333870) at ../src/backend/tcop/pquery.c:1158 [06:22:32.386] No locals. [06:22:32.386] #14 0x0000555b8d7e4374 in PortalRunMulti (portal=portal@entry=0x555b8f328050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x555b8f2a72d8, altdest=altdest@entry=0x555b8f2a72d8, qc=qc@entry=0x7fff69333870) at ../src/backend/tcop/pquery.c:1316 [06:22:32.386] pstmt = 0x555b8f2a68a0 [06:22:32.386] stmtlist_item__state = [06:22:32.386] active_snapshot_set = false [06:22:32.386] stmtlist_item = 0x555b8f2a72a0 [06:22:32.386] #15 0x0000555b8d7e4947 in PortalRun (portal=portal@entry=0x555b8f328050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x555b8f2a72d8, altdest=altdest@entry=0x555b8f2a72d8, qc=0x7fff69333870) at ../src/backend/tcop/pquery.c:791 [06:22:32.386] _save_exception_stack = 0x7fff69333920 [06:22:32.386] _save_context_stack = 0x0 [06:22:32.386] _local_sigjmp_buf = {{__jmpbuf = {0, -4303813980455857931, 93851732836432, 93851732306024, 93851732836432, 93851732305952, -7995002257829424907, -4303819100271046411}, __mask_was_saved = 0, __saved_mask = {__val = {93851707188526, 93851732302256, 112, 4, 93851707192943, 1764964351, 4, 93851732305952, 112, 73, 93851732836432, 93851732306024, 93851732306000, 93851732305952, 93851707280146, 1}}}} [06:22:32.386] _do_rethrow = [06:22:32.386] result = [06:22:32.386] nprocessed = [06:22:32.386] saveTopTransactionResourceOwner = 0x555b8f2e4d08 [06:22:32.386] saveTopTransactionContext = 0x555b8f339c60 [06:22:32.386] saveActivePortal = 0x0 [06:22:32.386] saveResourceOwner = 0x555b8f2e4d08 [06:22:32.386] savePortalContext = 0x0 [06:22:32.386] saveMemoryContext = 0x555b8f339c60 [06:22:32.386] __func__ = "PortalRun" [06:22:32.386] #16 0x0000555b8d7ddd33 in exec_simple_query (query_string=query_string@entry=0x555b8f2a5ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [06:22:32.386] cmdtaglen = 24 [06:22:32.386] snapshot_set = [06:22:32.386] per_parsetree_context = 0x0 [06:22:32.386] plantree_list = 0x555b8f2a7288 [06:22:32.386] parsetree = 0x555b8f2a6820 [06:22:32.386] commandTag = [06:22:32.386] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:22:32.386] querytree_list = [06:22:32.386] portal = 0x555b8f328050 [06:22:32.386] receiver = 0x555b8f2a72d8 [06:22:32.386] format = 0 [06:22:32.386] cmdtagname = [06:22:32.386] parsetree_item__state = [06:22:32.386] dest = DestRemote [06:22:32.386] oldcontext = 0x555b8f339c60 [06:22:32.386] parsetree_list = 0x555b8f2a6850 [06:22:32.386] parsetree_item = 0x555b8f2a6868 [06:22:32.386] save_log_statement_stats = false [06:22:32.386] was_logged = false [06:22:32.386] use_implicit_block = false [06:22:32.386] msec_str = "\320:3i\377\177\000\0004S\251\215[U\000\000\00093i\377\177\000\000G\000\000\000\000\000\000" [06:22:32.386] __func__ = "exec_simple_query" [06:22:32.386] #17 0x0000555b8d7e0ab7 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [06:22:32.386] query_string = 0x555b8f2a5ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:22:32.386] firstchar = [06:22:32.386] input_message = {data = 0x555b8f2a5ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:22:32.386] local_sigjmp_buf = {{__jmpbuf = {93851719751832, -4303816725681303307, 4, 140734958353104, 140734958353248, 140734958353252, -7995002257623904011, -4303819102744243979}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93851732032976, 15616, 93851719745920, 93851732556992, 140734958353248, 93851707192491, 0, 9, 2, 93851719751840, 93851732032976, 93851719745920, 140734958353104, 140734958353248, 140734958353252}}}} [06:22:32.386] send_ready_for_query = false [06:22:32.386] idle_in_transaction_timeout_enabled = false [06:22:32.386] idle_session_timeout_enabled = false [06:22:32.386] __func__ = "PostgresMain" [06:22:32.386] #18 0x0000555b8d7d692e in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:22:32.386] bsdata = [06:22:32.386] #19 0x0000555b8d68e32d in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff69333a7c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff69333ad0) at ../src/backend/postmaster/launch_backend.c:274 [06:22:32.386] pid = [06:22:32.386] #20 0x0000555b8d693de1 in BackendStartup (client_sock=client_sock@entry=0x7fff69333ad0) at ../src/backend/postmaster/postmaster.c:3420 [06:22:32.386] bn = 0x555b8f2ce488 [06:22:32.386] pid = [06:22:32.386] startup_data = {canAcceptConnections = CAC_OK} [06:22:32.386] __func__ = "BackendStartup" [06:22:32.386] #21 0x0000555b8d694343 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [06:22:32.386] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\303\035N\177\000\000\240\277\027\037N\177\000\000x;3i\377\177\000\000t;3i\377\177", '\000' , "\256~\205\214[U\000\000hg\201\214[U\000\000@<3i\377\177\000\0008<3i\377\177\000\000\225[\362\001\000\000\000\000\240DC\036N\177\000\000+", '\000' , "[U\000\000\303}\205\214[U\000", __ss_align = 139973510055528}, salen = 2}} [06:22:32.386] i = 0 [06:22:32.386] now = [06:22:32.386] last_lockfile_recheck_time = 1727072317 [06:22:32.386] last_touch_time = 1727072317 [06:22:32.386] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x555b8c857eae}, {pos = 525878888, events = 32590, fd = 507725360, user_data = 0x7f4e1f5842e0}, {pos = 2090263927, events = 0, fd = 1764965568, user_data = 0x7f4e1f55aa48}, {pos = 15, events = 0, fd = 507725360, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f4e1f5842e0}, {pos = 1764965432, events = 32767, fd = 1764965440, user_data = 0x7f4e1f584668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = -1893042000, events = 21851, fd = 1, user_data = 0x7fff69334163}, {pos = -1, events = 0, fd = 499310624, user_data = 0x7f4e1f17bfa0}, {pos = -1892866232, events = 21851, fd = -1892866520, user_data = 0x555b8f2d4841}, {pos = 525733566, events = 32590, fd = 1, user_data = 0x7f4e1f5842e0}, {pos = 438, events = 0, fd = -1912545872, user_data = 0x0}, {pos = 1, events = 0, fd = -1893049488, user_data = 0x7f4e1f560ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f4e1dc2e020}, {pos = 500116928, events = 32590, fd = 16, user_data = 0x7fff693340a0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 525742522, events = 32590, fd = 0, user_data = 0x7f4e1dcaed24 }, {pos = 0, events = 0, fd = -1905663456, user_data = 0x2}, {pos = 7, events = 0, fd = -1893302672, user_data = 0x555b8d77498e }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = -1893049488, user_data = 0x7f4e1f560ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f4e1dc364c8}, {pos = 499871725, events = 32590, fd = -1905608800, user_data = 0x555b8f2d1410}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 501161056, events = 32590, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x312020200a0a4e38}, {pos = 822763892, events = 808923703, fd = 825438775, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1892863952, user_data = 0x7f4e1dcb56eb}, {pos = 501144032, events = 32590, fd = 499781998, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x5f09884f8342d600}, {pos = 501147104, events = 32590, fd = -328, user_data = 0x0}, {pos = -1892866840, events = 21851, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1892867040, events = 21851, fd = 3, user_data = 0x0}, {pos = 25324, events = 0, fd = -328, user_data = 0x0}, {pos = -1893049488, events = 21851, fd = 500117459, user_data = 0x7fff69334158}, {pos = -1918080350, events = 21851, fd = -1905600432, user_data = 0x555b8dab555f }, {pos = -1892867040, events = 21851, fd = -1893049936, user_data = 0x555b8f2d2420}, {pos = 499865662, events = 32590, fd = 0, user_data = 0x555b8dac71c9 }, {pos = -1892867040, events = 1, fd = -1918078190, user_data = 0x555b8f2a59b0}, {pos = -2092771840, events = 1594460239, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 499788465, user_data = 0x7f4e1dca14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2092771840, user_data = 0x555b8f27d0e0}, {pos = -2092771840, events = 1594460239, fd = 11, user_data = 0x5f09884f8342d600}, {pos = 0, events = 0, fd = 499495481, user_data = 0x1}, {pos = -1922506710, events = 21851, fd = 4194304, user_data = 0x555b8dab53f3 }, {pos = -1893216032, events = 21851, fd = -1893049936, user_data = 0x555b8f27d0e0}, {pos = 1, events = 0, fd = 0, user_data = 0x555b8dac71c9 }, {pos = -1893216032, events = 21851, fd = -1918078190, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x555b8d4c47e1 }, {pos = 0, events = 0, fd = -1924359391, user_data = 0xb}, {pos = -1922485553, events = 21851, fd = -1909201424, user_data = 0x555b8f2a6388}} [06:22:32.386] nevents = 1 [06:22:32.386] __func__ = "ServerLoop" [06:22:32.386] #22 0x0000555b8d695ac6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x555b8f263d30) at ../src/backend/postmaster/postmaster.c:1351 [06:22:32.386] opt = [06:22:32.386] status = [06:22:32.386] userDoption = [06:22:32.386] listen_addr_saved = false [06:22:32.386] output_config_variable = [06:22:32.386] __func__ = "PostmasterMain" [06:22:32.386] #23 0x0000555b8d4d4bbd in main (argc=8, argv=0x555b8f263d30) at ../src/backend/main/main.c:197 [06:22:32.386] do_check_root = [06:22:32.425] -e [06:22:32.425] [06:22:32.425] [06:22:32.491] dumping /tmp/cores/postgres-6-30008.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:22:32.749] [New LWP 30008] [06:22:32.749] [06:22:32.749] This GDB supports auto-downloading debuginfo from the following URLs: [06:22:32.749] [06:22:32.749] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [06:22:32.749] Debuginfod has been disabled. [06:22:32.749] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [06:22:32.857] [Thread debugging using libthread_db enabled] [06:22:32.857] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [06:22:32.857] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [06:22:32.857] Program terminated with signal SIGABRT, Aborted. [06:22:32.857] #0 0x00007fa0058a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:33.817] [06:22:33.817] Thread 1 (Thread 0x7fa006686f00 (LWP 30008)): [06:22:33.817] #0 0x00007fa0058a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:33.817] No symbol table info available. [06:22:33.817] #1 0x00007fa00585afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:33.817] No symbol table info available. [06:22:33.817] #2 0x00007fa005845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [06:22:33.817] No symbol table info available. [06:22:33.817] #3 0x000055926a34f586 in ExceptionalCondition (conditionName=conditionName@entry=0x55926a5c1afd "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55926a5c1030 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:22:33.817] No locals. [06:22:33.817] #4 0x0000559269cdb17f in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55926b3aa210, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [06:22:33.817] estate = 0x55926b3fc8d0 [06:22:33.817] oldcontext = 0x55926b418f30 [06:22:33.817] __func__ = "standard_ExecutorStart" [06:22:33.817] #5 0x0000559269cdb35b in ExecutorStart (queryDesc=queryDesc@entry=0x55926b3aa210, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [06:22:33.817] No locals. [06:22:33.817] #6 0x0000559269c014c2 in refresh_matview_datafill (dest=0x55926b3c4348, query=, query@entry=0x55926b41a0b0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [06:22:33.817] rewritten = [06:22:33.817] plan = 0x55926b3a9748 [06:22:33.817] queryDesc = 0x55926b3aa210 [06:22:33.817] copied_query = [06:22:33.817] processed = [06:22:33.817] __func__ = "refresh_matview_datafill" [06:22:33.817] #7 0x0000559269c03829 in RefreshMatViewByOid (matviewOid=27333, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [06:22:33.817] dest = [06:22:33.817] matviewRel = 0x7f9ffa1e1fb8 [06:22:33.817] rule = [06:22:33.817] actions = [06:22:33.817] dataQuery = 0x55926b41a0b0 [06:22:33.817] tableSpace = [06:22:33.817] relowner = 10 [06:22:33.817] OIDNewHeap = 27340 [06:22:33.817] processed = 0 [06:22:33.817] relpersistence = 112 'p' [06:22:33.817] save_userid = 10 [06:22:33.817] save_sec_context = 0 [06:22:33.817] save_nestlevel = 2 [06:22:33.817] address = {classId = 0, objectId = 0, objectSubId = 0} [06:22:33.817] __func__ = "RefreshMatViewByOid" [06:22:33.817] #8 0x0000559269c03968 in ExecRefreshMatView (stmt=0x55926b44e950, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:22:33.817] matviewOid = [06:22:33.817] lockmode = [06:22:33.817] #9 0x0000559269bba7af in ExecCreateTableAs (pstate=pstate@entry=0x55926b419030, stmt=stmt@entry=0x55926b273770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff59570080) at ../src/backend/commands/createas.c:350 [06:22:33.817] refresh = [06:22:33.817] query = 0x55926b273930 [06:22:33.817] into = 0x55926b2734c8 [06:22:33.817] is_matview = true [06:22:33.817] do_refresh = false [06:22:33.817] dest = [06:22:33.817] address = {classId = 1259, objectId = 27333, objectSubId = 0} [06:22:33.817] __func__ = "ExecCreateTableAs" [06:22:33.817] #10 0x000055926a0c9df7 in ProcessUtilitySlow (pstate=pstate@entry=0x55926b419030, pstmt=pstmt@entry=0x55926b273820, queryString=queryString@entry=0x55926b272a30 "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=0x55926b274258, qc=0x7fff59570080) at ../src/backend/tcop/utility.c:1675 [06:22:33.817] _save_exception_stack = 0x7fff5956ff40 [06:22:33.817] _save_context_stack = 0x0 [06:22:33.817] _local_sigjmp_buf = {{__jmpbuf = {0, -343601964170269609, 94087351318384, 0, 94087351314992, 0, -5773294532474885033, -343604517733454761}, __mask_was_saved = 0, __saved_mask = {__val = {4294982212, 140325078410048, 94087332213266, 1, 64065531408600, 1, 94087336031481, 140325279002040, 94087351314992, 94087338344421, 94087348270882, 94087348271008, 140734692261252, 94087338539096, 94087348270897, 94087348271008}}}} [06:22:33.817] _do_rethrow = false [06:22:33.817] parsetree = 0x55926b273770 [06:22:33.817] isTopLevel = true [06:22:33.817] isCompleteQuery = true [06:22:33.817] needCleanup = false [06:22:33.817] commandCollected = false [06:22:33.817] address = {classId = 21906, objectId = 1797732208, objectSubId = 21906} [06:22:33.817] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:22:33.817] __func__ = "ProcessUtilitySlow" [06:22:33.817] #11 0x000055926a0c8408 in standard_ProcessUtility (pstmt=0x55926b273820, queryString=0x55926b272a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55926b274258, qc=0x7fff59570080) at ../src/backend/tcop/utility.c:1067 [06:22:33.817] parsetree = 0x55926b273770 [06:22:33.817] isTopLevel = true [06:22:33.817] isAtomicContext = false [06:22:33.817] pstate = 0x55926b419030 [06:22:33.817] readonly_flags = [06:22:33.817] __func__ = "standard_ProcessUtility" [06:22:33.817] #12 0x000055926a0c8563 in ProcessUtility (pstmt=pstmt@entry=0x55926b273820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55926b274258, qc=0x7fff59570080) at ../src/backend/tcop/utility.c:523 [06:22:33.817] No locals. [06:22:33.817] #13 0x000055926a0c3dcf in PortalRunUtility (portal=portal@entry=0x55926b2f5680, pstmt=pstmt@entry=0x55926b273820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55926b274258, qc=qc@entry=0x7fff59570080) at ../src/backend/tcop/pquery.c:1158 [06:22:33.817] No locals. [06:22:33.817] #14 0x000055926a0c4374 in PortalRunMulti (portal=portal@entry=0x55926b2f5680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55926b274258, altdest=altdest@entry=0x55926b274258, qc=qc@entry=0x7fff59570080) at ../src/backend/tcop/pquery.c:1316 [06:22:33.817] pstmt = 0x55926b273820 [06:22:33.817] stmtlist_item__state = [06:22:33.817] active_snapshot_set = false [06:22:33.817] stmtlist_item = 0x55926b274220 [06:22:33.817] #15 0x000055926a0c4947 in PortalRun (portal=portal@entry=0x55926b2f5680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55926b274258, altdest=altdest@entry=0x55926b274258, qc=0x7fff59570080) at ../src/backend/tcop/pquery.c:791 [06:22:33.817] _save_exception_stack = 0x7fff59570130 [06:22:33.817] _save_context_stack = 0x0 [06:22:33.817] _local_sigjmp_buf = {{__jmpbuf = {0, -343601964506862505, 94087351850624, 94087351318504, 94087351850624, 94087351318432, -5773294532336473001, -343604515923219369}, __mask_was_saved = 0, __saved_mask = {__val = {94087335716142, 94087351314736, 112, 4, 94087335720559, 1498873871, 4, 94087351318432, 112, 73, 94087351850624, 94087351318504, 94087351318480, 94087351318432, 94087335807762, 1}}}} [06:22:33.817] _do_rethrow = [06:22:33.817] result = [06:22:33.817] nprocessed = [06:22:33.817] saveTopTransactionResourceOwner = 0x55926b2b2838 [06:22:33.817] saveTopTransactionContext = 0x55926b306660 [06:22:33.817] saveActivePortal = 0x0 [06:22:33.817] saveResourceOwner = 0x55926b2b2838 [06:22:33.817] savePortalContext = 0x0 [06:22:33.817] saveMemoryContext = 0x55926b306660 [06:22:33.817] __func__ = "PortalRun" [06:22:33.817] #16 0x000055926a0bdd33 in exec_simple_query (query_string=query_string@entry=0x55926b272a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [06:22:33.817] cmdtaglen = 24 [06:22:33.817] snapshot_set = [06:22:33.817] per_parsetree_context = 0x0 [06:22:33.817] plantree_list = 0x55926b274208 [06:22:33.817] parsetree = 0x55926b2737a0 [06:22:33.817] commandTag = [06:22:33.817] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:22:33.817] querytree_list = [06:22:33.817] portal = 0x55926b2f5680 [06:22:33.817] receiver = 0x55926b274258 [06:22:33.817] format = 0 [06:22:33.817] cmdtagname = [06:22:33.817] parsetree_item__state = [06:22:33.817] dest = DestRemote [06:22:33.817] oldcontext = 0x55926b306660 [06:22:33.817] parsetree_list = 0x55926b2737d0 [06:22:33.817] parsetree_item = 0x55926b2737e8 [06:22:33.817] save_log_statement_stats = false [06:22:33.817] was_logged = true [06:22:33.817] use_implicit_block = false [06:22:33.817] msec_str = "\340\002WY\377\177\000\0004S7j\222U\000\000\020\001WY\377\177\000\000G\000\000\000\000\000\000" [06:22:33.817] __func__ = "exec_simple_query" [06:22:33.817] #17 0x000055926a0c0ab7 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [06:22:33.817] query_string = 0x55926b272a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:22:33.817] firstchar = [06:22:33.817] input_message = {data = 0x55926b272a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:22:33.817] local_sigjmp_buf = {{__jmpbuf = {94087348279448, -343605723357172649, 4, 140734692262624, 140734692262768, 140734692262772, -5773294532676211625, -343604513585550249}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94087351045552, 14336, 94087348273536, 94087351572464, 140734692262768, 94087335720107, 0, 9, 2, 94087348279456, 94087351045552, 94087348273536, 140734692262624, 140734692262768, 140734692262772}}}} [06:22:33.817] send_ready_for_query = false [06:22:33.817] idle_in_transaction_timeout_enabled = false [06:22:33.817] idle_session_timeout_enabled = false [06:22:33.817] __func__ = "PostgresMain" [06:22:33.817] #18 0x000055926a0b692e in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:22:33.817] bsdata = [06:22:33.817] #19 0x0000559269f6e32d in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff5957028c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff595702e0) at ../src/backend/postmaster/launch_backend.c:274 [06:22:33.817] pid = [06:22:33.817] #20 0x0000559269f73de1 in BackendStartup (client_sock=client_sock@entry=0x7fff595702e0) at ../src/backend/postmaster/postmaster.c:3420 [06:22:33.817] bn = 0x55926b2a7a78 [06:22:33.817] pid = [06:22:33.817] startup_data = {canAcceptConnections = CAC_OK} [06:22:33.817] __func__ = "BackendStartup" [06:22:33.817] #21 0x0000559269f74343 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [06:22:33.817] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "WY\377\177\000\000t\003WY\377\177", '\000' , "\256~\023i\222U\000\000hg\017i\222U\000\000@\004WY\377\177\000\0008\004WY\377\177\000\000\225[\362\001\000\000\000\000\240\264\322\006\240\177\000\000+", '\000' , "\303}\023i\222U\000\000hf$\a\240\177\000\0000\266\322\006\240\177\000", __ss_align = 140325291320032}, salen = 2}} [06:22:33.817] i = 0 [06:22:33.817] now = [06:22:33.817] last_lockfile_recheck_time = 1727072319 [06:22:33.817] last_touch_time = 1727072319 [06:22:33.817] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1762885294, events = 21906, fd = 119826024, user_data = 0x7fa006d2b630}, {pos = 119825120, events = 32672, fd = 2090263927, user_data = 0x7fff595704c0}, {pos = 119654984, events = 32672, fd = 15, user_data = 0x7fa006d2b630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 119825120, events = 32672, fd = 1498874936, user_data = 0x7fff59570440}, {pos = 119826024, events = 32672, fd = 0, user_data = 0x55926b272a48}, {pos = 1782451579, events = 21906, fd = 32768, user_data = 0x1}, {pos = 1797736432, events = 21906, fd = -1, user_data = 0x7fa00582e020}, {pos = 114904992, events = 32672, fd = 1797919592, user_data = 0x55926b2a1248}, {pos = 1797918753, events = 21906, fd = 119680702, user_data = 0x1}, {pos = 119825120, events = 32672, fd = 438, user_data = 0x55926a8eddb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55926b272a48}, {pos = 119680702, events = 32672, fd = 1, user_data = 0x0}, {pos = 92463136, events = 32672, fd = 93269440, user_data = 0x10}, {pos = 1498876080, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 119689658, user_data = 0x0}, {pos = 92990756, events = 32672, fd = 0, user_data = 0x55926af7e220 }, {pos = 2, events = 0, fd = 7, user_data = 0x55926b234e50}, {pos = 1778715989, events = 21906, fd = 1797937163, user_data = 0x55926a05498e }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55926b272a48}, {pos = 119680702, events = 32672, fd = 1, user_data = 0x0}, {pos = 92497096, events = 32672, fd = 92915840, user_data = 0x423}, {pos = 93023879, events = 32672, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 94313568, events = 32672, 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 = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, 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 = 1782129966, events = 21906, fd = 1797892672, user_data = 0x7fa0058b56eb}, {pos = 94296544, events = 32672, fd = 92934510, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3170318230c17300}, {pos = 94299616, events = 32672, 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 = 1797918984, user_data = 0x55926a392df1 }, {pos = 1797918784, events = 21906, fd = 3, user_data = 0x0}, {pos = 25879, events = 0, fd = -328, user_data = 0x0}, {pos = 1797728840, events = 21906, fd = 93269971, user_data = 0x7fff59570968}, {pos = 1782213282, events = 21906, fd = 1794693200, user_data = 0x55926a39555f }, {pos = 1797918784, events = 21906, fd = 1797728560, user_data = 0x55926b2a1040}, {pos = 93017835, events = 32672, fd = 0, user_data = 0x55926a3a71c9 }, {pos = 1797918784, events = 1, fd = 1782215442, user_data = 0x55926b272930}, {pos = 817984256, events = 829436290, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 92940977, user_data = 0x7fa0058a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 817984256, user_data = 0x55926b24a060}, {pos = 817984256, events = 829436290, fd = 11, user_data = 0x3170318230c17300}, {pos = 0, events = 0, fd = 92647993, user_data = 0x1}, {pos = 1777786922, events = 21906, fd = 4194304, user_data = 0x55926a3953f3 }, {pos = 1797562464, events = 21906, fd = 1797728560, user_data = 0x55926b24a060}, {pos = 1, events = 0, fd = 0, user_data = 0x55926a3a71c9 }, {pos = 1797562464, events = 21906, fd = 1782215442, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x559269da47e1 }, {pos = 0, events = 0, fd = 1775934241, user_data = 0xb}, {pos = 1777808079, events = 21906, fd = 1791092208, user_data = 0x55926b2732d8}} [06:22:33.818] nevents = 1 [06:22:33.818] __func__ = "ServerLoop" [06:22:33.818] #22 0x0000559269f75ac6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55926b230cc0) at ../src/backend/postmaster/postmaster.c:1351 [06:22:33.818] opt = [06:22:33.818] status = [06:22:33.818] userDoption = [06:22:33.818] listen_addr_saved = false [06:22:33.818] output_config_variable = [06:22:33.818] __func__ = "PostmasterMain" [06:22:33.818] #23 0x0000559269db4bbd in main (argc=4, argv=0x55926b230cc0) at ../src/backend/main/main.c:197 [06:22:33.818] do_check_root =