[00:42:08.473] src/tools/ci/cores_backtrace.sh linux /tmp/cores [00:42:08.665] dumping /tmp/cores/postgres-6-36275.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:42:08.907] [New LWP 36275] [00:42:08.907] [00:42:08.907] This GDB supports auto-downloading debuginfo from the following URLs: [00:42:08.907] [00:42:08.907] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [00:42:08.907] Debuginfod has been disabled. [00:42:08.907] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [00:42:09.025] [Thread debugging using libthread_db enabled] [00:42:09.025] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:42:09.025] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [00:42:09.025] Program terminated with signal SIGABRT, Aborted. [00:42:09.025] #0 0x00007fe5b20a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:09.948] [00:42:09.948] Thread 1 (Thread 0x7fe5b2e86f00 (LWP 36275)): [00:42:09.948] #0 0x00007fe5b20a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:09.948] No symbol table info available. [00:42:09.948] #1 0x00007fe5b205afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:09.948] No symbol table info available. [00:42:09.948] #2 0x00007fe5b2045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:09.948] No symbol table info available. [00:42:09.948] #3 0x00005559a5056fce in ExceptionalCondition (conditionName=conditionName@entry=0x5559a52cb0b5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5559a52ca5d0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [00:42:09.948] No locals. [00:42:09.948] #4 0x00005559a49dadf8 in standard_ExecutorStart (queryDesc=0x5559bad0c7d0, eflags=0) at ../src/backend/executor/execMain.c:194 [00:42:09.948] estate = 0x5559bacb41b0 [00:42:09.948] oldcontext = 0x5559bad16c60 [00:42:09.948] __func__ = "standard_ExecutorStart" [00:42:09.948] #5 0x00007fe5b00326f7 in pgss_ExecutorStart (queryDesc=0x5559bad0c7d0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [00:42:09.948] No locals. [00:42:09.948] #6 0x00005559a49daf8d in ExecutorStart (queryDesc=queryDesc@entry=0x5559bad0c7d0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [00:42:09.948] No locals. [00:42:09.948] #7 0x00005559a490180f in refresh_matview_datafill (dest=0x5559bad09848, query=, query@entry=0x5559bac8b530, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [00:42:09.948] rewritten = [00:42:09.948] plan = 0x5559bad0bd08 [00:42:09.948] queryDesc = 0x5559bad0c7d0 [00:42:09.948] copied_query = [00:42:09.948] processed = [00:42:09.948] __func__ = "refresh_matview_datafill" [00:42:09.948] #8 0x00005559a4903b76 in RefreshMatViewByOid (matviewOid=27208, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [00:42:09.948] dest = [00:42:09.948] matviewRel = 0x7fe5adabed18 [00:42:09.948] rule = [00:42:09.948] actions = [00:42:09.948] dataQuery = 0x5559bac8b530 [00:42:09.948] tableSpace = [00:42:09.948] relowner = 10 [00:42:09.948] OIDNewHeap = 27233 [00:42:09.948] processed = 0 [00:42:09.948] relpersistence = 112 'p' [00:42:09.948] save_userid = 10 [00:42:09.948] save_sec_context = 0 [00:42:09.948] save_nestlevel = 2 [00:42:09.948] address = {classId = 0, objectId = 0, objectSubId = 0} [00:42:09.948] __func__ = "RefreshMatViewByOid" [00:42:09.948] #9 0x00005559a4903cb5 in ExecRefreshMatView (stmt=0x5559bac7c880, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:42:09.948] matviewOid = [00:42:09.948] lockmode = [00:42:09.948] #10 0x00005559a48b9ba8 in ExecCreateTableAs (pstate=pstate@entry=0x5559bad16d60, stmt=stmt@entry=0x5559bab2b790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffae088bc0) at ../src/backend/commands/createas.c:351 [00:42:09.948] refresh = [00:42:09.948] query = 0x5559bab2b950 [00:42:09.948] into = 0x5559bab2b4e8 [00:42:09.948] jstate = 0x0 [00:42:09.948] is_matview = true [00:42:09.948] do_refresh = false [00:42:09.948] dest = [00:42:09.948] address = {classId = 1259, objectId = 27208, objectSubId = 0} [00:42:09.948] __func__ = "ExecCreateTableAs" [00:42:09.948] #11 0x00005559a4dcffa7 in ProcessUtilitySlow (pstate=pstate@entry=0x5559bad16d60, pstmt=pstmt@entry=0x5559bab2b840, queryString=queryString@entry=0x5559bab2aa50 "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=0x5559bab2c7e8, qc=0x7fffae088bc0) at ../src/backend/tcop/utility.c:1675 [00:42:09.948] _save_exception_stack = 0x7fffae088770 [00:42:09.948] _save_context_stack = 0x0 [00:42:09.948] _local_sigjmp_buf = {{__jmpbuf = {0, 1335895376665787043, 93843872724880, 0, 93843872721488, 0, 5171861560724830883, 1335934222244133539}, __mask_was_saved = 0, __saved_mask = {__val = {114, 3, 140624512621664, 1023, 18446744073709551344, 64, 0, 93843874103120, 140624511334922, 1, 93843509321332, 93843874696096, 120, 93843872721232, 93843509321332, 93843872721232}}}} [00:42:09.948] _do_rethrow = false [00:42:09.948] parsetree = 0x5559bab2b790 [00:42:09.948] isTopLevel = true [00:42:09.948] isCompleteQuery = true [00:42:09.948] needCleanup = false [00:42:09.948] commandCollected = false [00:42:09.948] address = {classId = 21849, objectId = 3132274576, objectSubId = 21849} [00:42:09.948] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:42:09.948] __func__ = "ProcessUtilitySlow" [00:42:09.948] #12 0x00005559a4dce5b8 in standard_ProcessUtility (pstmt=pstmt@entry=0x5559bab2b840, queryString=queryString@entry=0x5559bab2aa50 "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=0x5559bab2c7e8, qc=0x7fffae088bc0) at ../src/backend/tcop/utility.c:1067 [00:42:09.948] parsetree = 0x5559bab2b790 [00:42:09.948] isTopLevel = true [00:42:09.948] isAtomicContext = false [00:42:09.948] pstate = 0x5559bad16d60 [00:42:09.948] readonly_flags = [00:42:09.948] __func__ = "standard_ProcessUtility" [00:42:09.948] #13 0x00007fe5b0035d9d in pgss_ProcessUtility (pstmt=0x5559bab2b840, queryString=0x5559bab2aa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5559bab2c7e8, qc=0x7fffae088bc0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [00:42:09.948] _save_exception_stack = 0x7fffae088a80 [00:42:09.948] _save_context_stack = 0x0 [00:42:09.948] _local_sigjmp_buf = {{__jmpbuf = {0, -5171970063774762333, 93843872725056, 93843872729064, 140736113183680, 0, 5171861560888408739, 5184233229511572131}, __mask_was_saved = 0, __saved_mask = {__val = {93843509643229, 140736113182950, 140736113182948, 0, 0, 139637976727552, 206158430232, 140736113182912, 93843509643446, 0, 206158430232, 93843872725856, 140736113183008, 0, 93843504465103, 93843872721232}}}} [00:42:09.948] _do_rethrow = false [00:42:09.948] duration = [00:42:09.948] bufusage = {shared_blks_hit = 93843874334184, shared_blks_read = 382252089355, shared_blks_dirtied = 0, shared_blks_written = 93843874333688, local_blks_hit = 93843874334184, local_blks_read = 93843502796314, local_blks_dirtied = 93843874680568, local_blks_written = 93843502796560, temp_blks_read = 93843874333688, temp_blks_written = 93843874333104, shared_blk_read_time = {ticks = 93843502795669}, shared_blk_write_time = {ticks = 93843509636681}, local_blk_read_time = {ticks = 140624525815224}, local_blk_write_time = {ticks = 93843872721488}, temp_blk_read_time = {ticks = 93843511959589}, temp_blk_write_time = {ticks = 93843521919298}} [00:42:09.948] walusage_start = {wal_records = 8952, wal_fpi = 136, wal_bytes = 1263453} [00:42:09.948] start = [00:42:09.948] rows = [00:42:09.948] bufusage_start = {shared_blks_hit = 34411, shared_blks_read = 3481, shared_blks_dirtied = 1461, shared_blks_written = 1033, 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}} [00:42:09.948] walusage = {wal_records = 0, wal_fpi = 11, wal_bytes = 140624441088704} [00:42:09.948] parsetree = [00:42:09.948] saved_queryId = 6041762721901209185 [00:42:09.948] saved_stmt_location = 0 [00:42:09.948] saved_stmt_len = 69 [00:42:09.948] enabled = true [00:42:09.948] #14 0x00005559a4dce65e in ProcessUtility (pstmt=pstmt@entry=0x5559bab2b840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5559bab2c7e8, qc=0x7fffae088bc0) at ../src/backend/tcop/utility.c:519 [00:42:09.948] No locals. [00:42:09.948] #15 0x00005559a4dc9f7f in PortalRunUtility (portal=portal@entry=0x5559bababf90, pstmt=pstmt@entry=0x5559bab2b840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5559bab2c7e8, qc=qc@entry=0x7fffae088bc0) at ../src/backend/tcop/pquery.c:1158 [00:42:09.948] No locals. [00:42:09.948] #16 0x00005559a4dca524 in PortalRunMulti (portal=portal@entry=0x5559bababf90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5559bab2c7e8, altdest=altdest@entry=0x5559bab2c7e8, qc=qc@entry=0x7fffae088bc0) at ../src/backend/tcop/pquery.c:1316 [00:42:09.948] pstmt = 0x5559bab2b840 [00:42:09.948] stmtlist_item__state = [00:42:09.948] active_snapshot_set = false [00:42:09.948] stmtlist_item = 0x5559bab2c7b0 [00:42:09.948] #17 0x00005559a4dcaaf7 in PortalRun (portal=portal@entry=0x5559bababf90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5559bab2c7e8, altdest=altdest@entry=0x5559bab2c7e8, qc=0x7fffae088bc0) at ../src/backend/tcop/pquery.c:791 [00:42:09.948] _save_exception_stack = 0x7fffae088c70 [00:42:09.948] _save_context_stack = 0x0 [00:42:09.948] _local_sigjmp_buf = {{__jmpbuf = {0, 1335895377484724899, 93843873251216, 93843872725000, 93843873251216, 93843872724928, 5171861560479464099, 1335934219751013027}, __mask_was_saved = 0, __saved_mask = {__val = {93843509321332, 93843872721232, 112, 4, 93843509325749, 2919795535, 4, 93843872724928, 112, 73, 93843873251216, 93843872725000, 93843872724976, 93843872724928, 93843509412952, 1}}}} [00:42:09.948] _do_rethrow = [00:42:09.948] result = [00:42:09.948] nprocessed = [00:42:09.948] saveTopTransactionResourceOwner = 0x5559bab6b468 [00:42:09.948] saveTopTransactionContext = 0x5559babbe3c0 [00:42:09.948] saveActivePortal = 0x0 [00:42:09.948] saveResourceOwner = 0x5559bab6b468 [00:42:09.948] savePortalContext = 0x0 [00:42:09.948] saveMemoryContext = 0x5559babbe3c0 [00:42:09.948] __func__ = "PortalRun" [00:42:09.948] #18 0x00005559a4dc3ee3 in exec_simple_query (query_string=query_string@entry=0x5559bab2aa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [00:42:09.948] cmdtaglen = 24 [00:42:09.948] snapshot_set = [00:42:09.948] per_parsetree_context = 0x0 [00:42:09.948] plantree_list = 0x5559bab2c798 [00:42:09.948] parsetree = 0x5559bab2b7c0 [00:42:09.948] commandTag = [00:42:09.948] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:42:09.948] querytree_list = [00:42:09.948] portal = 0x5559bababf90 [00:42:09.948] receiver = 0x5559bab2c7e8 [00:42:09.948] format = 0 [00:42:09.948] cmdtagname = [00:42:09.948] parsetree_item__state = [00:42:09.948] dest = DestRemote [00:42:09.948] oldcontext = 0x5559babbe3c0 [00:42:09.948] parsetree_list = 0x5559bab2b7f0 [00:42:09.948] parsetree_item = 0x5559bab2b808 [00:42:09.948] save_log_statement_stats = false [00:42:09.948] was_logged = true [00:42:09.948] use_implicit_block = false [00:42:09.948] msec_str = " \216\b\256\377\177\000\000|\315\a\245YU\000\000P\214\b\256\377\177\000\000G\000\000\000\000\000\000" [00:42:09.948] __func__ = "exec_simple_query" [00:42:09.948] #19 0x00005559a4dc6c67 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [00:42:09.948] query_string = 0x5559bab2aa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:42:09.948] firstchar = [00:42:09.948] input_message = {data = 0x5559bab2aa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:42:09.948] local_sigjmp_buf = {{__jmpbuf = {93843521927864, 1335936533106014883, 4, 140736113184288, 140736113184432, 140736113184436, 5171861560676596387, 1335934226660473507}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 93843872971072, 0, 168, 93843509325851, 0, 10, 2, 93843521927872, 93843872452080, 93843521921952, 140736113184288, 140736113184432, 140736113184436}}}} [00:42:09.948] send_ready_for_query = false [00:42:09.948] idle_in_transaction_timeout_enabled = false [00:42:09.948] idle_session_timeout_enabled = false [00:42:09.948] __func__ = "PostgresMain" [00:42:09.948] #20 0x00005559a4dbcade in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:42:09.948] bsdata = [00:42:09.948] #21 0x00005559a4c70456 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffae088dcc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffae088e20) at ../src/backend/postmaster/launch_backend.c:266 [00:42:09.948] pid = [00:42:09.948] #22 0x00005559a4c75f0a in BackendStartup (client_sock=client_sock@entry=0x7fffae088e20) at ../src/backend/postmaster/postmaster.c:3417 [00:42:09.948] bn = 0x5559bab57478 [00:42:09.948] pid = [00:42:09.948] startup_data = {canAcceptConnections = CAC_OK} [00:42:09.948] __func__ = "BackendStartup" [00:42:09.948] #23 0x00005559a4c7646c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [00:42:09.948] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\b\256\377\177\000\000\264\216\b\256\377\177", '\000' , "\032\301\342\243YU\000\000 \247ޣYU\000\000\200\217\b\256\377\177\000\000x\217\b\256\377\177\000\000\225[\362\001\000\000\000\000pJ\265\272YU\000\000,", '\000' , "(\300\342\243YU\000\000hv\244\263\345\177\000\0000\306R\263\345\177\000", __ss_align = 140624538137312}, salen = 2}} [00:42:09.948] i = 0 [00:42:09.948] now = [00:42:09.948] last_lockfile_recheck_time = 1730335134 [00:42:09.948] last_touch_time = 1730335134 [00:42:09.948] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1545420518, events = 21849, fd = -1281067416, user_data = 0x7fe5b352c630}, {pos = -1281068320, events = 32741, fd = 2090263927, user_data = 0x7fffae089000}, {pos = -1281238456, events = 32741, fd = 15, user_data = 0x7fe5b352c630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1281068320, events = 32741, fd = -1375170696, user_data = 0x7fffae088f80}, {pos = -1281067416, events = 32741, fd = 0, user_data = 0x5559bab2c890}, {pos = -1525774645, events = 21849, fd = 32768, user_data = 0x1}, {pos = -1162693264, events = 21849, fd = -1, user_data = 0x7fe5b202e020}, {pos = -1285988448, events = 32741, fd = -1162517752, user_data = 0x5559bab561e8}, {pos = -1162499951, events = 21849, fd = -1281212738, user_data = 0x1}, {pos = -1281068320, events = 32741, fd = 427, user_data = 0x5559a55f8d58 }, {pos = 0, events = 0, fd = 1, user_data = 0x5559bab2c890}, {pos = -1281212738, events = 32741, fd = 1, user_data = 0x0}, {pos = -1308434400, events = 32741, fd = -1307628096, user_data = 0x10}, {pos = -1375169552, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1281203782, user_data = 0x0}, {pos = -1307906780, events = 32741, fd = 0, user_data = 0x5559a5c90420 }, {pos = 2, events = 0, fd = 7, user_data = 0x5559baaece90}, {pos = -1529516772, events = 21849, fd = -1162479269, user_data = 0x5559a4d5a955 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5559bab2c890}, {pos = -1281212738, events = 32741, fd = 1, user_data = 0x0}, {pos = -1308400440, events = 32741, fd = -1307981696, user_data = 0x420}, {pos = -1307873299, events = 32741, fd = 2, user_data = 0x5559bab5f900}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -1306583968, events = 32741, 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 = 0xa57}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -1286417088, user_data = 0x7fe5b352da80}, {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 = -1526096268, events = 21849, fd = -1162504048, user_data = 0x7fe5b20b583e}, {pos = -1306600992, events = 32741, fd = -1307963026, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xf1248aad5cc1d400}, {pos = -1306597920, events = 32741, 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 = -1162518360, user_data = 0x5559a509a737 }, {pos = -1162518560, events = 21849, fd = 3, user_data = 0x0}, {pos = 32724, events = 0, fd = -328, user_data = 0x0}, {pos = -1162688368, events = 21849, fd = -1307627565, user_data = 0x7fffae0894a8}, {pos = -1526012952, events = 21849, fd = -1513489808, user_data = 0x5559a509cea5 }, {pos = -1162518560, events = 21849, fd = -1162696368, user_data = 0x5559bab55fe0}, {pos = -1307879362, events = 32741, fd = 0, user_data = 0x5559a50aeb0f }, {pos = -1162518560, events = 1, fd = -1526010792, user_data = 0x5559bab2a950}, {pos = 1556206592, events = 4045703853, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1307956559, user_data = 0x7fe5b20a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1556206592, user_data = 0x5559bab02080}, {pos = 1556206592, events = 4045703853, fd = 11, user_data = 0xf1248aad5cc1d400}, {pos = 0, events = 0, fd = -1308249543, user_data = 0x1}, {pos = -1530461869, events = 21849, fd = 4194304, user_data = 0x5559a509cd39 }, {pos = -1162862464, events = 21849, fd = -1162696368, user_data = 0x5559bab02080}, {pos = 1, events = 0, fd = 0, user_data = 0x5559a50aeb0f }, {pos = -1162862464, events = 21849, fd = -1526010792, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5559a4aa4b51 }, {pos = 0, events = 0, fd = -1532322159, user_data = 0xb}, {pos = -1530440712, events = 21849, fd = -1517108016, user_data = 0x5559bab2b308}} [00:42:09.948] nevents = 1 [00:42:09.948] __func__ = "ServerLoop" [00:42:09.948] #24 0x00005559a4c77bef in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5559baae8cf0) at ../src/backend/postmaster/postmaster.c:1348 [00:42:09.948] opt = [00:42:09.948] status = [00:42:09.948] userDoption = [00:42:09.948] listen_addr_saved = false [00:42:09.948] output_config_variable = [00:42:09.948] __func__ = "PostmasterMain" [00:42:09.948] #25 0x00005559a4ab4ed9 in main (argc=4, argv=0x5559baae8cf0) at ../src/backend/main/main.c:196 [00:42:09.948] do_check_root = [00:42:09.982] -e [00:42:09.982] [00:42:09.982] [00:42:10.041] dumping /tmp/cores/postgres-6-30109.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:42:10.271] [New LWP 30109] [00:42:10.271] [00:42:10.271] This GDB supports auto-downloading debuginfo from the following URLs: [00:42:10.271] [00:42:10.271] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [00:42:10.271] Debuginfod has been disabled. [00:42:10.271] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [00:42:10.367] [Thread debugging using libthread_db enabled] [00:42:10.367] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:42:10.367] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [00:42:10.367] Program terminated with signal SIGABRT, Aborted. [00:42:10.367] #0 0x00007f32f42a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:11.234] [00:42:11.234] Thread 1 (Thread 0x7f32f41d7f00 (LWP 30109)): [00:42:11.234] #0 0x00007f32f42a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:11.234] No symbol table info available. [00:42:11.234] #1 0x00007f32f425afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:11.234] No symbol table info available. [00:42:11.234] #2 0x00007f32f4245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:11.234] No symbol table info available. [00:42:11.234] #3 0x00005560f4fdffce in ExceptionalCondition (conditionName=conditionName@entry=0x5560f52540b5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5560f52535d0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [00:42:11.234] No locals. [00:42:11.234] #4 0x00005560f4963df8 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x556124f4f4c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [00:42:11.234] estate = 0x556124f91740 [00:42:11.234] oldcontext = 0x556124f75d60 [00:42:11.234] __func__ = "standard_ExecutorStart" [00:42:11.234] #5 0x00005560f4963fd4 in ExecutorStart (queryDesc=queryDesc@entry=0x556124f4f4c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [00:42:11.234] No locals. [00:42:11.234] #6 0x00005560f488a80f in refresh_matview_datafill (dest=0x556124ff3f38, query=, query@entry=0x556124f3ce00, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [00:42:11.234] rewritten = [00:42:11.234] plan = 0x556124f4e9f8 [00:42:11.234] queryDesc = 0x556124f4f4c0 [00:42:11.234] copied_query = [00:42:11.234] processed = [00:42:11.234] __func__ = "refresh_matview_datafill" [00:42:11.234] #7 0x00005560f488cb76 in RefreshMatViewByOid (matviewOid=27487, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [00:42:11.234] dest = [00:42:11.234] matviewRel = 0x7f32e8b61d18 [00:42:11.234] rule = [00:42:11.234] actions = [00:42:11.234] dataQuery = 0x556124f3ce00 [00:42:11.234] tableSpace = [00:42:11.234] relowner = 10 [00:42:11.234] OIDNewHeap = 27500 [00:42:11.234] processed = 0 [00:42:11.234] relpersistence = 112 'p' [00:42:11.234] save_userid = 10 [00:42:11.234] save_sec_context = 0 [00:42:11.234] save_nestlevel = 2 [00:42:11.234] address = {classId = 0, objectId = 0, objectSubId = 0} [00:42:11.234] __func__ = "RefreshMatViewByOid" [00:42:11.234] #8 0x00005560f488ccb5 in ExecRefreshMatView (stmt=0x556124f104c0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:42:11.234] matviewOid = [00:42:11.234] lockmode = [00:42:11.234] #9 0x00005560f4842ba8 in ExecCreateTableAs (pstate=pstate@entry=0x556124f75e60, stmt=stmt@entry=0x556124e07770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffa119e4d0) at ../src/backend/commands/createas.c:351 [00:42:11.234] refresh = [00:42:11.234] query = 0x556124e07930 [00:42:11.234] into = 0x556124e074c8 [00:42:11.234] jstate = 0x0 [00:42:11.234] is_matview = true [00:42:11.234] do_refresh = false [00:42:11.234] dest = [00:42:11.234] address = {classId = 1259, objectId = 27487, objectSubId = 0} [00:42:11.234] __func__ = "ExecCreateTableAs" [00:42:11.234] #10 0x00005560f4d58fa7 in ProcessUtilitySlow (pstate=pstate@entry=0x556124f75e60, pstmt=pstmt@entry=0x556124e07820, queryString=queryString@entry=0x556124e06a30 "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=0x556124e08258, qc=0x7fffa119e4d0) at ../src/backend/tcop/utility.c:1675 [00:42:11.234] _save_exception_stack = 0x7fffa119e390 [00:42:11.234] _save_context_stack = 0x0 [00:42:11.234] _local_sigjmp_buf = {{__jmpbuf = {0, 7691737442646983224, 93875718879088, 0, 93875718875696, 0, 4576644036723180088, 7691350027782685240}, __mask_was_saved = 0, __saved_mask = {__val = {139856634806336, 12792, 93874912282362, 1, 4294980088, 139856634806336, 93874916097609, 139856820665784, 93875718875696, 93874918420517, 93874928380226, 93874928380352, 140735896216020, 93874918615448, 93874928380241, 93874928380352}}}} [00:42:11.234] _do_rethrow = false [00:42:11.234] parsetree = 0x556124e07770 [00:42:11.234] isTopLevel = true [00:42:11.234] isCompleteQuery = true [00:42:11.234] needCleanup = false [00:42:11.234] commandCollected = false [00:42:11.234] address = {classId = 21857, objectId = 618690416, objectSubId = 21857} [00:42:11.234] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:42:11.234] __func__ = "ProcessUtilitySlow" [00:42:11.234] #11 0x00005560f4d575b8 in standard_ProcessUtility (pstmt=0x556124e07820, queryString=0x556124e06a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x556124e08258, qc=0x7fffa119e4d0) at ../src/backend/tcop/utility.c:1067 [00:42:11.234] parsetree = 0x556124e07770 [00:42:11.234] isTopLevel = true [00:42:11.234] isAtomicContext = false [00:42:11.234] pstate = 0x556124f75e60 [00:42:11.234] readonly_flags = [00:42:11.234] __func__ = "standard_ProcessUtility" [00:42:11.234] #12 0x00005560f4d57713 in ProcessUtility (pstmt=pstmt@entry=0x556124e07820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x556124e08258, qc=0x7fffa119e4d0) at ../src/backend/tcop/utility.c:523 [00:42:11.234] No locals. [00:42:11.234] #13 0x00005560f4d52f7f in PortalRunUtility (portal=portal@entry=0x556124e89680, pstmt=pstmt@entry=0x556124e07820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556124e08258, qc=qc@entry=0x7fffa119e4d0) at ../src/backend/tcop/pquery.c:1158 [00:42:11.234] No locals. [00:42:11.234] #14 0x00005560f4d53524 in PortalRunMulti (portal=portal@entry=0x556124e89680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x556124e08258, altdest=altdest@entry=0x556124e08258, qc=qc@entry=0x7fffa119e4d0) at ../src/backend/tcop/pquery.c:1316 [00:42:11.234] pstmt = 0x556124e07820 [00:42:11.234] stmtlist_item__state = [00:42:11.234] active_snapshot_set = false [00:42:11.234] stmtlist_item = 0x556124e08220 [00:42:11.234] #15 0x00005560f4d53af7 in PortalRun (portal=portal@entry=0x556124e89680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x556124e08258, altdest=altdest@entry=0x556124e08258, qc=0x7fffa119e4d0) at ../src/backend/tcop/pquery.c:791 [00:42:11.234] _save_exception_stack = 0x7fffa119e580 [00:42:11.234] _save_context_stack = 0x0 [00:42:11.234] _local_sigjmp_buf = {{__jmpbuf = {0, 7691737437478552120, 93875719411328, 93875718879208, 93875719411328, 93875718879136, 4576644035787850296, 7691350025792094776}, __mask_was_saved = 0, __saved_mask = {__val = {93874915782260, 93875718875440, 112, 4, 93874915786677, 2702828639, 4, 93875718879136, 112, 73, 93875719411328, 93875718879208, 93875718879184, 93875718879136, 93874915873880, 1}}}} [00:42:11.234] _do_rethrow = [00:42:11.234] result = [00:42:11.234] nprocessed = [00:42:11.234] saveTopTransactionResourceOwner = 0x556124e46838 [00:42:11.234] saveTopTransactionContext = 0x556124e9a660 [00:42:11.234] saveActivePortal = 0x0 [00:42:11.234] saveResourceOwner = 0x556124e46838 [00:42:11.234] savePortalContext = 0x0 [00:42:11.234] saveMemoryContext = 0x556124e9a660 [00:42:11.234] __func__ = "PortalRun" [00:42:11.234] #16 0x00005560f4d4cee3 in exec_simple_query (query_string=query_string@entry=0x556124e06a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [00:42:11.234] cmdtaglen = 24 [00:42:11.234] snapshot_set = [00:42:11.234] per_parsetree_context = 0x0 [00:42:11.234] plantree_list = 0x556124e08208 [00:42:11.234] parsetree = 0x556124e077a0 [00:42:11.234] commandTag = [00:42:11.234] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:42:11.234] querytree_list = [00:42:11.234] portal = 0x556124e89680 [00:42:11.234] receiver = 0x556124e08258 [00:42:11.234] format = 0 [00:42:11.234] cmdtagname = [00:42:11.234] parsetree_item__state = [00:42:11.234] dest = DestRemote [00:42:11.234] oldcontext = 0x556124e9a660 [00:42:11.234] parsetree_list = 0x556124e077d0 [00:42:11.234] parsetree_item = 0x556124e077e8 [00:42:11.234] save_log_statement_stats = false [00:42:11.234] was_logged = true [00:42:11.234] use_implicit_block = false [00:42:11.234] msec_str = "0\347\031\241\377\177\000\000|]\000\365`U\000\000`\345\031\241\377\177\000\000G\000\000\000\000\000\000" [00:42:11.234] __func__ = "exec_simple_query" [00:42:11.234] #17 0x00005560f4d4fc67 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [00:42:11.234] query_string = 0x556124e06a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:42:11.234] firstchar = [00:42:11.234] input_message = {data = 0x556124e06a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:42:11.234] local_sigjmp_buf = {{__jmpbuf = {93874928388792, 7691347952946348600, 4, 140735896217392, 140735896217536, 140735896217540, 4576644035984982584, 7691350032165470776}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93875718606256, 14336, 93874928382880, 93875719133168, 140735896217536, 93874915786225, 0, 9, 2, 93874928388800, 93875718606256, 93874928382880, 140735896217392, 140735896217536, 140735896217540}}}} [00:42:11.234] send_ready_for_query = false [00:42:11.234] idle_in_transaction_timeout_enabled = false [00:42:11.234] idle_session_timeout_enabled = false [00:42:11.234] __func__ = "PostgresMain" [00:42:11.234] #18 0x00005560f4d45ade in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:42:11.234] bsdata = [00:42:11.234] #19 0x00005560f4bf9456 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffa119e6dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffa119e730) at ../src/backend/postmaster/launch_backend.c:266 [00:42:11.234] pid = [00:42:11.234] #20 0x00005560f4bfef0a in BackendStartup (client_sock=client_sock@entry=0x7fffa119e730) at ../src/backend/postmaster/postmaster.c:3417 [00:42:11.234] bn = 0x556124e3bd98 [00:42:11.234] pid = [00:42:11.234] startup_data = {canAcceptConnections = CAC_OK} [00:42:11.234] __func__ = "BackendStartup" [00:42:11.234] #21 0x00005560f4bff46c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [00:42:11.234] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\"\3642\177\000\000\364\347\031\241\377\177\000\000\312\360\267\3652\177\000\000>\004\000\000\000\000\000\000\260\227#\3642\177\000\000\240\017z\3652\177\000\000\370\347\031\241\377\177\000\000\364\347\031\241\377\177\000\000\000\000\000\000\000\000\000\000\220\347\031\241\377\177\000\000\032Q\333\363`U\000\000 7\327\363`U\000\000\300\350\031\241\377\177\000\000\270\350\031\241\377\177\000\000\225[\362\001\000\000\000", __ss_align = 139856836068512}, salen = 2}} [00:42:11.234] i = 0 [00:42:11.234] now = [00:42:11.234] last_lockfile_recheck_time = 1730335102 [00:42:11.234] last_touch_time = 1730335102 [00:42:11.234] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f32f5ba92e0}, {pos = -1592137672, events = 0, fd = 0, user_data = 0x7f32f5ba9668}, {pos = -203730662, events = 21856, fd = -172321176, user_data = 0x7f32f5088630}, {pos = -172322080, events = 32562, fd = 2090263927, user_data = 0x7fffa119e940}, {pos = -172492216, events = 32562, fd = 15, user_data = 0x7f32f5088630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -172322080, events = 32562, fd = -1592137544, user_data = 0x7fffa119e8c0}, {pos = -172321176, events = 32562, fd = 0, user_data = 0x556124e35368}, {pos = 618877512, events = 21857, fd = 618876961, user_data = 0x7f3200000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f32f422e020}, {pos = -176549984, events = 32562, fd = 618877800, user_data = 0x7fffa119ecb0}, {pos = 618848968, events = 21857, fd = 618878032, user_data = 0x556124e35368}, {pos = -172322080, events = 32562, fd = 427, user_data = 0x5560f5581d58 }, {pos = 0, events = 0, fd = 1, user_data = 0x556124e06a48}, {pos = -172466498, events = 32562, fd = 1, user_data = 0x0}, {pos = -199040992, events = 32562, fd = -198234688, user_data = 0x7fffa119ed20}, {pos = -1592136448, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -172457542, user_data = 0x0}, {pos = -198513372, events = 32562, fd = 0, user_data = 0x5560f5c19420 }, {pos = 2, events = 0, fd = 7, user_data = 0x556124dc8e50}, {pos = 0, events = 0, fd = -199007032, user_data = 0x7f32f429c880 }, {pos = -199393864, events = 32562, fd = 8096, user_data = 0x100007f00000002}, {pos = -198480249, events = 32562, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -197190560, events = 32562, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x556124dc8e50}, {pos = -198477302, events = 32562, fd = 1663923061, user_data = 0x556124dc8e50}, {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 = 0x4661745a0a323220}, {pos = 1198147171, events = 10, fd = 0, user_data = 0xffffff0000000000}, {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 = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x75790367ef42b700}, {pos = -197204512, events = 32562, fd = -328, user_data = 0x0}, {pos = 618877192, events = 21857, fd = 1024, user_data = 0x556124e35108}, {pos = -1592136264, events = 32767, fd = -198476129, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 26204, events = 0, fd = -328, user_data = 0x0}, {pos = 618687048, events = 21857, fd = -198234157, user_data = 0x7fffa119edb8}, {pos = -184323096, events = 21856, fd = -171799952, user_data = 0x5560f5025ea5 }, {pos = 618876992, events = 21857, fd = 618686768, user_data = 0x556124e35040}, {pos = -198486293, events = 32562, fd = 0, user_data = 0x5560f5037b0f }, {pos = 618876992, events = 1, fd = -184320936, user_data = 0x556124e06930}, {pos = -280840448, events = 1970864999, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -198563151, user_data = 0x7f32f42a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -280840448, user_data = 0x556124dde060}, {pos = -280840448, events = 1970864999, fd = 11, user_data = 0x75790367ef42b700}, {pos = 0, events = 0, fd = -198856135, user_data = 0x1}, {pos = -188772013, events = 21856, fd = 4194304, user_data = 0x5560f5025d39 }, {pos = 618520672, events = 21857, fd = 618686768, user_data = 0x556124dde060}, {pos = 1, events = 0, fd = 0, user_data = 0x5560f5037b0f }, {pos = 618520672, events = 21857, fd = -184320936, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5560f4a2db51 }, {pos = 0, events = 0, fd = -190632303, user_data = 0xb}, {pos = -188750856, events = 21856, fd = -175418160, user_data = 0x556124e072d8}} [00:42:11.234] nevents = 1 [00:42:11.234] __func__ = "ServerLoop" [00:42:11.234] #22 0x00005560f4c00bef in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x556124dc4cc0) at ../src/backend/postmaster/postmaster.c:1348 [00:42:11.234] opt = [00:42:11.234] status = [00:42:11.234] userDoption = [00:42:11.234] listen_addr_saved = false [00:42:11.234] output_config_variable = [00:42:11.234] __func__ = "PostmasterMain" [00:42:11.234] #23 0x00005560f4a3ded9 in main (argc=4, argv=0x556124dc4cc0) at ../src/backend/main/main.c:196 [00:42:11.234] do_check_root = [00:42:11.268] -e [00:42:11.268] [00:42:11.268] [00:42:11.325] dumping /tmp/cores/postgres-6-28806.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:42:11.566] [New LWP 28806] [00:42:11.566] [00:42:11.566] This GDB supports auto-downloading debuginfo from the following URLs: [00:42:11.566] [00:42:11.566] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [00:42:11.566] Debuginfod has been disabled. [00:42:11.566] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [00:42:11.660] [Thread debugging using libthread_db enabled] [00:42:11.660] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:42:11.660] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [00:42:11.660] Program terminated with signal SIGABRT, Aborted. [00:42:11.660] #0 0x00007f38fb0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:12.524] [00:42:12.524] Thread 1 (Thread 0x7f38fafd3f00 (LWP 28806)): [00:42:12.524] #0 0x00007f38fb0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:12.524] No symbol table info available. [00:42:12.524] #1 0x00007f38fb05afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:12.524] No symbol table info available. [00:42:12.524] #2 0x00007f38fb045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:12.524] No symbol table info available. [00:42:12.524] #3 0x0000559000014fce in ExceptionalCondition (conditionName=conditionName@entry=0x5590002890b5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5590002885d0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [00:42:12.524] No locals. [00:42:12.524] #4 0x0000558fff998df8 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55900ca445d0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [00:42:12.524] estate = 0x55900c9aae30 [00:42:12.524] oldcontext = 0x55900ca8aad0 [00:42:12.524] __func__ = "standard_ExecutorStart" [00:42:12.524] #5 0x0000558fff998fd4 in ExecutorStart (queryDesc=queryDesc@entry=0x55900ca445d0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [00:42:12.524] No locals. [00:42:12.524] #6 0x0000558fff8bf80f in refresh_matview_datafill (dest=0x55900ca41648, query=, query@entry=0x55900ca80820, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [00:42:12.524] rewritten = [00:42:12.524] plan = 0x55900ca43b08 [00:42:12.524] queryDesc = 0x55900ca445d0 [00:42:12.524] copied_query = [00:42:12.524] processed = [00:42:12.524] __func__ = "refresh_matview_datafill" [00:42:12.524] #7 0x0000558fff8c1b76 in RefreshMatViewByOid (matviewOid=27448, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [00:42:12.524] dest = [00:42:12.524] matviewRel = 0x7f38ef5dbbb8 [00:42:12.524] rule = [00:42:12.524] actions = [00:42:12.524] dataQuery = 0x55900ca80820 [00:42:12.524] tableSpace = [00:42:12.524] relowner = 10 [00:42:12.524] OIDNewHeap = 27471 [00:42:12.524] processed = 0 [00:42:12.524] relpersistence = 112 'p' [00:42:12.524] save_userid = 10 [00:42:12.524] save_sec_context = 0 [00:42:12.524] save_nestlevel = 2 [00:42:12.524] address = {classId = 0, objectId = 0, objectSubId = 0} [00:42:12.524] __func__ = "RefreshMatViewByOid" [00:42:12.524] #8 0x0000558fff8c1cb5 in ExecRefreshMatView (stmt=0x55900ca1a930, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:42:12.524] matviewOid = [00:42:12.524] lockmode = [00:42:12.524] #9 0x0000558fff877ba8 in ExecCreateTableAs (pstate=pstate@entry=0x55900ca8abd0, stmt=stmt@entry=0x55900c8d67f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffdcbcd8c00) at ../src/backend/commands/createas.c:351 [00:42:12.524] refresh = [00:42:12.524] query = 0x55900c8d69b0 [00:42:12.524] into = 0x55900c8d6548 [00:42:12.524] jstate = 0x0 [00:42:12.524] is_matview = true [00:42:12.524] do_refresh = false [00:42:12.524] dest = [00:42:12.524] address = {classId = 1259, objectId = 27448, objectSubId = 0} [00:42:12.524] __func__ = "ExecCreateTableAs" [00:42:12.524] #10 0x0000558fffd8dfa7 in ProcessUtilitySlow (pstate=pstate@entry=0x55900ca8abd0, pstmt=pstmt@entry=0x55900c8d68a0, queryString=queryString@entry=0x55900c8d5ab0 "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=0x55900c8d72d8, qc=0x7ffdcbcd8c00) at ../src/backend/tcop/utility.c:1675 [00:42:12.524] _save_exception_stack = 0x7ffdcbcd8ac0 [00:42:12.524] _save_context_stack = 0x0 [00:42:12.524] _local_sigjmp_buf = {{__jmpbuf = {0, 9168129196893533226, 94077174245360, 0, 94077174241968, 0, 3161582394463089706, 9152539596685308970}, __mask_was_saved = 0, __saved_mask = {__val = {139882519320256, 9294, 94076960511738, 1, 4294976590, 139882519320256, 94076960502056, 1, 39917637515240, 1, 9294, 139882519320256, 139882519320256, 1, 94076960512085, 94077175117800}}}} [00:42:12.524] _do_rethrow = false [00:42:12.524] parsetree = 0x55900c8d67f0 [00:42:12.524] isTopLevel = true [00:42:12.524] isCompleteQuery = true [00:42:12.524] needCleanup = false [00:42:12.524] commandCollected = false [00:42:12.524] address = {classId = 21904, objectId = 210593776, objectSubId = 21904} [00:42:12.524] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:42:12.524] __func__ = "ProcessUtilitySlow" [00:42:12.524] #11 0x0000558fffd8c5b8 in standard_ProcessUtility (pstmt=0x55900c8d68a0, queryString=0x55900c8d5ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55900c8d72d8, qc=0x7ffdcbcd8c00) at ../src/backend/tcop/utility.c:1067 [00:42:12.524] parsetree = 0x55900c8d67f0 [00:42:12.524] isTopLevel = true [00:42:12.524] isAtomicContext = false [00:42:12.524] pstate = 0x55900ca8abd0 [00:42:12.524] readonly_flags = [00:42:12.524] __func__ = "standard_ProcessUtility" [00:42:12.524] #12 0x0000558fffd8c713 in ProcessUtility (pstmt=pstmt@entry=0x55900c8d68a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55900c8d72d8, qc=0x7ffdcbcd8c00) at ../src/backend/tcop/utility.c:523 [00:42:12.524] No locals. [00:42:12.524] #13 0x0000558fffd87f7f in PortalRunUtility (portal=portal@entry=0x55900c958050, pstmt=pstmt@entry=0x55900c8d68a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55900c8d72d8, qc=qc@entry=0x7ffdcbcd8c00) at ../src/backend/tcop/pquery.c:1158 [00:42:12.524] No locals. [00:42:12.524] #14 0x0000558fffd88524 in PortalRunMulti (portal=portal@entry=0x55900c958050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55900c8d72d8, altdest=altdest@entry=0x55900c8d72d8, qc=qc@entry=0x7ffdcbcd8c00) at ../src/backend/tcop/pquery.c:1316 [00:42:12.524] pstmt = 0x55900c8d68a0 [00:42:12.524] stmtlist_item__state = [00:42:12.524] active_snapshot_set = false [00:42:12.524] stmtlist_item = 0x55900c8d72a0 [00:42:12.524] #15 0x0000558fffd88af7 in PortalRun (portal=portal@entry=0x55900c958050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55900c8d72d8, altdest=altdest@entry=0x55900c8d72d8, qc=0x7ffdcbcd8c00) at ../src/backend/tcop/pquery.c:791 [00:42:12.524] _save_exception_stack = 0x7ffdcbcd8cb0 [00:42:12.524] _save_context_stack = 0x0 [00:42:12.524] _local_sigjmp_buf = {{__jmpbuf = {0, 9168129197758608426, 94077174775888, 94077174245480, 94077174775888, 94077174245408, 3161582394064630826, 9152539598456747050}, __mask_was_saved = 0, __saved_mask = {__val = {94076964011636, 94077174241712, 112, 4, 94076964016053, 3419245455, 4, 94077174245408, 112, 73, 94077174775888, 94077174245480, 94077174245456, 94077174245408, 94076964103256, 1}}}} [00:42:12.524] _do_rethrow = [00:42:12.524] result = [00:42:12.524] nprocessed = [00:42:12.524] saveTopTransactionResourceOwner = 0x55900c914d08 [00:42:12.524] saveTopTransactionContext = 0x55900c969c60 [00:42:12.524] saveActivePortal = 0x0 [00:42:12.524] saveResourceOwner = 0x55900c914d08 [00:42:12.524] savePortalContext = 0x0 [00:42:12.524] saveMemoryContext = 0x55900c969c60 [00:42:12.524] __func__ = "PortalRun" [00:42:12.524] #16 0x0000558fffd81ee3 in exec_simple_query (query_string=query_string@entry=0x55900c8d5ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [00:42:12.524] cmdtaglen = 24 [00:42:12.524] snapshot_set = [00:42:12.524] per_parsetree_context = 0x0 [00:42:12.524] plantree_list = 0x55900c8d7288 [00:42:12.524] parsetree = 0x55900c8d6820 [00:42:12.524] commandTag = [00:42:12.524] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:42:12.524] querytree_list = [00:42:12.524] portal = 0x55900c958050 [00:42:12.524] receiver = 0x55900c8d72d8 [00:42:12.524] format = 0 [00:42:12.524] cmdtagname = [00:42:12.524] parsetree_item__state = [00:42:12.524] dest = DestRemote [00:42:12.524] oldcontext = 0x55900c969c60 [00:42:12.524] parsetree_list = 0x55900c8d6850 [00:42:12.524] parsetree_item = 0x55900c8d6868 [00:42:12.524] save_log_statement_stats = false [00:42:12.524] was_logged = false [00:42:12.524] use_implicit_block = false [00:42:12.524] msec_str = "`\216\315\313\375\177\000\000|\255\003\000\220U\000\000\220\214\315\313\375\177\000\000G\000\000\000\000\000\000" [00:42:12.524] __func__ = "exec_simple_query" [00:42:12.524] #17 0x0000558fffd84c67 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [00:42:12.524] query_string = 0x55900c8d5ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:42:12.524] firstchar = [00:42:12.524] input_message = {data = 0x55900c8d5ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:42:12.524] local_sigjmp_buf = {{__jmpbuf = {94076976618168, 9168102333546624042, 4, 140728022699616, 140728022699760, 140728022699764, 3161582394127545386, 9152539592343942186}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94077173972432, 15616, 94076976612256, 94077174496448, 140728022699760, 94076964015601, 0, 9, 2, 94076976618176, 94077173972432, 94076976612256, 140728022699616, 140728022699760, 140728022699764}}}} [00:42:12.524] send_ready_for_query = false [00:42:12.524] idle_in_transaction_timeout_enabled = false [00:42:12.524] idle_session_timeout_enabled = false [00:42:12.524] __func__ = "PostgresMain" [00:42:12.524] #18 0x0000558fffd7aade in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:42:12.524] bsdata = [00:42:12.524] #19 0x0000558fffc2e456 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffdcbcd8e0c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdcbcd8e60) at ../src/backend/postmaster/launch_backend.c:266 [00:42:12.524] pid = [00:42:12.524] #20 0x0000558fffc33f0a in BackendStartup (client_sock=client_sock@entry=0x7ffdcbcd8e60) at ../src/backend/postmaster/postmaster.c:3417 [00:42:12.524] bn = 0x55900c8fe3e8 [00:42:12.524] pid = [00:42:12.524] startup_data = {canAcceptConnections = CAC_OK} [00:42:12.524] __func__ = "BackendStartup" [00:42:12.524] #21 0x0000558fffc3446c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [00:42:12.524] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\315\313\375\177\000\000\364\216\315\313\375\177", '\000' , "\032\241\336\376\217U\000\000 \207\332\376\217U\000\000\300\217\315\313\375\177\000\000\270\217\315\313\375\177\000\000\225[\362\001\000\000\000\000\240T\203\3738\177\000\000+", '\000' , "(\240\336\376\217U\000\000h6\223\3748\177\000\0000V\203\3738\177\000", __ss_align = 139882732401376}, salen = 2}} [00:42:12.524] i = 0 [00:42:12.524] now = [00:42:12.524] last_lockfile_recheck_time = 1730335099 [00:42:12.524] last_touch_time = 1730335099 [00:42:12.524] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -18964198, events = 21903, fd = -57461144, user_data = 0x7f38fb835630}, {pos = -57462048, events = 32568, fd = 2090263927, user_data = 0x7ffdcbcd9040}, {pos = -57632184, events = 32568, fd = 15, user_data = 0x7f38fb835630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -57462048, events = 32568, fd = -875720776, user_data = 0x7ffdcbcd8fc0}, {pos = -57461144, events = 32568, fd = 0, user_data = 0x55900c8d5b70}, {pos = 681675, events = 21904, fd = 32768, user_data = 0x1}, {pos = 210598064, events = 21904, fd = -1, user_data = 0x7f38fb02e020}, {pos = -61689952, events = 32568, fd = 210773832, user_data = 0x55900c902628}, {pos = 210782273, events = 21904, fd = -57606466, user_data = 0x1}, {pos = -57462048, events = 32568, fd = 427, user_data = 0x5590005b6d58 }, {pos = 0, events = 0, fd = 1, user_data = 0x55900c8d5b70}, {pos = -57606466, events = 32568, fd = 1, user_data = 0x0}, {pos = -83697632, events = 32568, fd = -82891328, user_data = 0x10}, {pos = -875719632, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -57597510, user_data = 0x0}, {pos = -83170012, events = 32568, fd = 0, user_data = 0x559000c4e420 }, {pos = 2, events = 0, fd = 7, user_data = 0x55900c897e70}, {pos = -3060452, events = 21903, fd = 210799835, user_data = 0x558fffd18955 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55900c8d5b70}, {pos = -57606466, events = 32568, fd = 1, user_data = 0x0}, {pos = -83663672, events = 32568, fd = -83244928, user_data = 0x420}, {pos = -83136531, events = 32568, fd = 2, user_data = 0x55900c901410}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -81847200, events = 32568, 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 = 0x6e77476c2d737365}, {pos = 168442166, events = 824188960, fd = 822763892, user_data = 0x30340a3939303533}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x550000000000}, {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 = 360052, events = 21904, fd = 210776112, user_data = 0x7f38fb0b56eb}, {pos = -81864224, events = 32568, fd = -83226258, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x5af0244256e8b00}, {pos = -81861152, events = 32568, 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 = 210773224, user_data = 0x559000058737 }, {pos = 210773024, events = 21904, fd = 3, user_data = 0x0}, {pos = 25567, events = 0, fd = -328, user_data = 0x0}, {pos = 210590576, events = 21904, fd = -82890797, user_data = 0x7ffdcbcd94e8}, {pos = 443368, events = 21904, fd = 12966512, user_data = 0x55900005aea5 }, {pos = 210773024, events = 21904, fd = 210590128, user_data = 0x55900c902420}, {pos = -83142594, events = 32568, fd = 0, user_data = 0x55900006cb0f }, {pos = 210773024, events = 1, fd = 445528, user_data = 0x55900c8d59b0}, {pos = 628001536, events = 95355460, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -83219791, user_data = 0x7f38fb0a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 628001536, user_data = 0x55900c8ad0e0}, {pos = 628001536, events = 95355460, fd = 11, user_data = 0x5af0244256e8b00}, {pos = 0, events = 0, fd = -83512775, user_data = 0x1}, {pos = -4005549, events = 21903, fd = 4194304, user_data = 0x55900005ad39 }, {pos = 210424032, events = 21904, fd = 210590128, user_data = 0x55900c8ad0e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55900006cb0f }, {pos = 210424032, events = 21904, fd = 445528, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x558fffa62b51 }, {pos = 0, events = 0, fd = -5865839, user_data = 0xb}, {pos = -3984392, events = 21903, fd = 9348304, user_data = 0x55900c8d6388}} [00:42:12.524] nevents = 1 [00:42:12.524] __func__ = "ServerLoop" [00:42:12.524] #22 0x0000558fffc35bef in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55900c893d30) at ../src/backend/postmaster/postmaster.c:1348 [00:42:12.524] opt = [00:42:12.524] status = [00:42:12.524] userDoption = [00:42:12.524] listen_addr_saved = false [00:42:12.524] output_config_variable = [00:42:12.524] __func__ = "PostmasterMain" [00:42:12.524] #23 0x0000558fffa72ed9 in main (argc=8, argv=0x55900c893d30) at ../src/backend/main/main.c:196 [00:42:12.524] do_check_root = [00:42:12.555] -e [00:42:12.555] [00:42:12.555] [00:42:12.612] dumping /tmp/cores/postgres-3-36386.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:42:12.854] [New LWP 36386] [00:42:12.854] [00:42:12.854] This GDB supports auto-downloading debuginfo from the following URLs: [00:42:12.854] [00:42:12.854] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [00:42:12.854] Debuginfod has been disabled. [00:42:12.854] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [00:42:12.946] [New LWP 36227] [00:42:12.946] [Thread debugging using libthread_db enabled] [00:42:12.946] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:42:12.946] Core was generated by `postgres: replica_success: startup waiting for 000000010000000000000004 '. [00:42:12.946] Program terminated with signal SIGQUIT, Quit. [00:42:12.946] #0 0x00007f26bfaaed24 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:12.951] [Current thread is 1 (LWP 36386)] [00:42:12.954] [00:42:12.954] Thread 2 (Thread 0x7f26c0233f00 (LWP 36227)): [00:42:12.954] warning: Couldn't find general-purpose registers in core file. [00:42:12.954] #0 in ?? () [00:42:12.954] PC unavailable, cannot determine locals. [00:42:12.954] Backtrace stopped: not enough registers or memory available to unwind further [00:42:12.954] [00:42:12.954] Thread 1 (LWP 36386): [00:42:12.954] #0 0x00007f26bfaaed24 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:12.954] No symbol table info available. [00:42:12.954] #1 0x00007f26bfa5b239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:12.954] No symbol table info available. [00:42:12.954] #2 0x00007f26bfb16184 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:12.954] No symbol table info available. [00:42:12.954] #3 0x00007f26bfb287dc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [00:42:12.954] No symbol table info available.