[12:28:49.224] src/tools/ci/cores_backtrace.sh linux /tmp/cores [12:28:49.432] dumping /tmp/cores/postgres-6-36596.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:28:49.690] [New LWP 36596] [12:28:49.690] [12:28:49.690] This GDB supports auto-downloading debuginfo from the following URLs: [12:28:49.690] [12:28:49.690] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:28:49.690] Debuginfod has been disabled. [12:28:49.690] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:28:49.813] [Thread debugging using libthread_db enabled] [12:28:49.813] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:28:49.813] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [12:28:49.813] Program terminated with signal SIGABRT, Aborted. [12:28:49.813] #0 0x00007f65ea4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.757] [12:28:50.757] Thread 1 (Thread 0x7f65e841ef00 (LWP 36596)): [12:28:50.757] #0 0x00007f65ea4a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.757] No symbol table info available. [12:28:50.757] #1 0x00007f65ea45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.757] No symbol table info available. [12:28:50.757] #2 0x00007f65ea445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.757] No symbol table info available. [12:28:50.757] #3 0x000055a034a8b402 in ExceptionalCondition (conditionName=conditionName@entry=0x55a034cfdd95 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55a034cfd2b0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [12:28:50.757] No locals. [12:28:50.757] #4 0x000055a034415301 in standard_ExecutorStart (queryDesc=0x55a05c2001b0, eflags=0) at ../src/backend/executor/execMain.c:194 [12:28:50.757] estate = 0x55a05c1c8aa0 [12:28:50.757] oldcontext = 0x55a05c205db0 [12:28:50.757] __func__ = "standard_ExecutorStart" [12:28:50.757] #5 0x00007f65e7b2d6f7 in pgss_ExecutorStart (queryDesc=0x55a05c2001b0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [12:28:50.757] No locals. [12:28:50.757] #6 0x000055a034415496 in ExecutorStart (queryDesc=queryDesc@entry=0x55a05c2001b0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [12:28:50.757] No locals. [12:28:50.757] #7 0x000055a03433b616 in refresh_matview_datafill (dest=0x55a05c212208, query=, query@entry=0x55a05c1c0c60, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [12:28:50.757] rewritten = [12:28:50.757] plan = 0x55a05c1ff6e8 [12:28:50.757] queryDesc = 0x55a05c2001b0 [12:28:50.757] copied_query = [12:28:50.757] processed = [12:28:50.757] __func__ = "refresh_matview_datafill" [12:28:50.757] #8 0x000055a03433d97d in RefreshMatViewByOid (matviewOid=27323, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [12:28:50.757] dest = [12:28:50.757] matviewRel = 0x7f65e5e92b88 [12:28:50.757] rule = [12:28:50.757] actions = [12:28:50.757] dataQuery = 0x55a05c1c0c60 [12:28:50.757] tableSpace = [12:28:50.757] relowner = 10 [12:28:50.757] OIDNewHeap = 27349 [12:28:50.757] processed = 0 [12:28:50.757] relpersistence = 112 'p' [12:28:50.757] save_userid = 10 [12:28:50.757] save_sec_context = 0 [12:28:50.757] save_nestlevel = 2 [12:28:50.757] address = {classId = 0, objectId = 0, objectSubId = 0} [12:28:50.757] __func__ = "RefreshMatViewByOid" [12:28:50.757] #9 0x000055a03433dabc in ExecRefreshMatView (stmt=0x55a05c20a190, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [12:28:50.757] matviewOid = [12:28:50.757] lockmode = [12:28:50.757] #10 0x000055a0342f4770 in ExecCreateTableAs (pstate=pstate@entry=0x55a05c205eb0, stmt=stmt@entry=0x55a05c0af790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe9f3b6720) at ../src/backend/commands/createas.c:350 [12:28:50.757] refresh = [12:28:50.757] query = 0x55a05c0af950 [12:28:50.757] into = 0x55a05c0af4e8 [12:28:50.757] is_matview = true [12:28:50.757] do_refresh = false [12:28:50.757] dest = [12:28:50.757] address = {classId = 1259, objectId = 27323, objectSubId = 0} [12:28:50.757] __func__ = "ExecCreateTableAs" [12:28:50.757] #11 0x000055a034805476 in ProcessUtilitySlow (pstate=pstate@entry=0x55a05c205eb0, pstmt=pstmt@entry=0x55a05c0af840, queryString=queryString@entry=0x55a05c0aea50 "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=0x55a05c0b07e8, qc=0x7ffe9f3b6720) at ../src/backend/tcop/utility.c:1675 [12:28:50.757] _save_exception_stack = 0x7ffe9f3b62d0 [12:28:50.757] _save_context_stack = 0x0 [12:28:50.757] _local_sigjmp_buf = {{__jmpbuf = {0, 5319688222079299809, 94147227350928, 0, 94147227347536, 0, 2120863524524503265, 5319742186078187745}, __mask_was_saved = 0, __saved_mask = {__val = {4, 2, 94146564144485, 1023, 94146563377648, 0, 0, 94146569434432, 94146563630315, 140075628946880, 1, 16777216, 0, 112, 94146563377920, 140075629223936}}}} [12:28:50.757] _do_rethrow = false [12:28:50.757] parsetree = 0x55a05c0af790 [12:28:50.757] isTopLevel = true [12:28:50.757] isCompleteQuery = true [12:28:50.757] needCleanup = false [12:28:50.757] commandCollected = false [12:28:50.757] address = {classId = 21920, objectId = 1544222608, objectSubId = 21920} [12:28:50.757] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [12:28:50.757] __func__ = "ProcessUtilitySlow" [12:28:50.757] #12 0x000055a034803a87 in standard_ProcessUtility (pstmt=pstmt@entry=0x55a05c0af840, queryString=queryString@entry=0x55a05c0aea50 "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=0x55a05c0b07e8, qc=0x7ffe9f3b6720) at ../src/backend/tcop/utility.c:1067 [12:28:50.757] parsetree = 0x55a05c0af790 [12:28:50.757] isTopLevel = true [12:28:50.757] isAtomicContext = false [12:28:50.757] pstate = 0x55a05c205eb0 [12:28:50.757] readonly_flags = [12:28:50.757] __func__ = "standard_ProcessUtility" [12:28:50.757] #13 0x00007f65e7b30d4a in pgss_ProcessUtility (pstmt=0x55a05c0af840, queryString=0x55a05c0aea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55a05c0b07e8, qc=0x7ffe9f3b6720) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [12:28:50.757] _save_exception_stack = 0x7ffe9f3b65e0 [12:28:50.757] _save_context_stack = 0x0 [12:28:50.757] _local_sigjmp_buf = {{__jmpbuf = {0, -2120091148799332127, 94147227351104, 94147227355112, 140731569891104, 0, 2120863526500020449, 2042421133520122081}, __mask_was_saved = 0, __saved_mask = {__val = {94146567195920, 140731569890374, 140731569890372, 0, 0, 139637976727552, 206158430232, 140731569890336, 94146567196137, 0, 206158430232, 94147227351904, 140731569890432, 0, 94146562038448, 94147227347280}}}} [12:28:50.757] _do_rethrow = false [12:28:50.757] duration = [12:28:50.757] bufusage = {shared_blks_hit = 94147228503768, shared_blks_read = 687194767360, shared_blks_dirtied = 0, shared_blks_written = 94147228503272, local_blks_hit = 94147228503768, local_blks_read = 94146560372708, local_blks_dirtied = 94147228723432, local_blks_written = 94146560372954, temp_blks_read = 94147228503272, temp_blks_written = 94147228502688, shared_blk_read_time = {ticks = 94146560372063}, shared_blk_write_time = {ticks = 94146567189372}, local_blk_read_time = {ticks = 140075665059256}, local_blk_write_time = {ticks = 94147227347536}, temp_blk_read_time = {ticks = 94146569502693}, temp_blk_write_time = {ticks = 94146579435874}} [12:28:50.757] walusage_start = {wal_records = 8930, wal_fpi = 122, wal_bytes = 1176562} [12:28:50.757] start = [12:28:50.757] rows = [12:28:50.757] bufusage_start = {shared_blks_hit = 33516, shared_blks_read = 3624, shared_blks_dirtied = 1540, shared_blks_written = 1011, 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}} [12:28:50.757] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 140075628946880} [12:28:50.757] parsetree = [12:28:50.757] saved_queryId = 6041762721901209185 [12:28:50.757] saved_stmt_location = 0 [12:28:50.757] saved_stmt_len = 69 [12:28:50.757] enabled = true [12:28:50.757] #14 0x000055a034803b2d in ProcessUtility (pstmt=pstmt@entry=0x55a05c0af840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55a05c0b07e8, qc=0x7ffe9f3b6720) at ../src/backend/tcop/utility.c:519 [12:28:50.757] No locals. [12:28:50.757] #15 0x000055a0347ff44e in PortalRunUtility (portal=portal@entry=0x55a05c12ff90, pstmt=pstmt@entry=0x55a05c0af840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55a05c0b07e8, qc=qc@entry=0x7ffe9f3b6720) at ../src/backend/tcop/pquery.c:1158 [12:28:50.757] No locals. [12:28:50.757] #16 0x000055a0347ff9f3 in PortalRunMulti (portal=portal@entry=0x55a05c12ff90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55a05c0b07e8, altdest=altdest@entry=0x55a05c0b07e8, qc=qc@entry=0x7ffe9f3b6720) at ../src/backend/tcop/pquery.c:1316 [12:28:50.757] pstmt = 0x55a05c0af840 [12:28:50.757] stmtlist_item__state = [12:28:50.757] active_snapshot_set = false [12:28:50.757] stmtlist_item = 0x55a05c0b07b0 [12:28:50.757] #17 0x000055a0347fffc6 in PortalRun (portal=portal@entry=0x55a05c12ff90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55a05c0b07e8, altdest=altdest@entry=0x55a05c0b07e8, qc=0x7ffe9f3b6720) at ../src/backend/tcop/pquery.c:791 [12:28:50.757] _save_exception_stack = 0x7ffe9f3b67d0 [12:28:50.757] _save_context_stack = 0x0 [12:28:50.757] _local_sigjmp_buf = {{__jmpbuf = {0, 5319688232526262497, 94147227877264, 94147227351048, 94147227877264, 94147227350976, 2120863526376288481, 5319741453851144417}, __mask_was_saved = 0, __saved_mask = {__val = {94146566874026, 94147227347280, 112, 4, 94146566878443, 2671470255, 4, 94147227350976, 112, 73, 94147227877264, 94147227351048, 94147227351024, 94147227350976, 94146566965646, 1}}}} [12:28:50.757] _do_rethrow = [12:28:50.757] result = [12:28:50.757] nprocessed = [12:28:50.757] saveTopTransactionResourceOwner = 0x55a05c0ef468 [12:28:50.757] saveTopTransactionContext = 0x55a05c1423c0 [12:28:50.757] saveActivePortal = 0x0 [12:28:50.757] saveResourceOwner = 0x55a05c0ef468 [12:28:50.757] savePortalContext = 0x0 [12:28:50.757] saveMemoryContext = 0x55a05c1423c0 [12:28:50.757] __func__ = "PortalRun" [12:28:50.757] #18 0x000055a0347f93b2 in exec_simple_query (query_string=query_string@entry=0x55a05c0aea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [12:28:50.757] cmdtaglen = 24 [12:28:50.757] snapshot_set = [12:28:50.757] per_parsetree_context = 0x0 [12:28:50.757] plantree_list = 0x55a05c0b0798 [12:28:50.757] parsetree = 0x55a05c0af7c0 [12:28:50.757] commandTag = [12:28:50.757] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:28:50.757] querytree_list = [12:28:50.757] portal = 0x55a05c12ff90 [12:28:50.757] receiver = 0x55a05c0b07e8 [12:28:50.757] format = 0 [12:28:50.757] cmdtagname = [12:28:50.757] parsetree_item__state = [12:28:50.757] dest = DestRemote [12:28:50.757] oldcontext = 0x55a05c1423c0 [12:28:50.757] parsetree_list = 0x55a05c0af7f0 [12:28:50.757] parsetree_item = 0x55a05c0af808 [12:28:50.757] save_log_statement_stats = false [12:28:50.757] was_logged = true [12:28:50.757] use_implicit_block = false [12:28:50.757] msec_str = "\200i;\237\376\177\000\000\260\021\2534\240U\000\000\260g;\237\376\177\000\000G\000\000\000\000\000\000" [12:28:50.757] __func__ = "exec_simple_query" [12:28:50.757] #19 0x000055a0347fc136 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [12:28:50.757] query_string = 0x55a05c0aea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [12:28:50.757] firstchar = [12:28:50.757] input_message = {data = 0x55a05c0aea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [12:28:50.757] local_sigjmp_buf = {{__jmpbuf = {94146579444440, 5319743522278846689, 4, 140731569891712, 140731569891856, 140731569891860, 2120863526455980257, 5319741451777454305}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94147227597120, 0, 168, 94146566878545, 0, 10, 2, 94146579444448, 94147227078128, 94146579438528, 140731569891712, 140731569891856, 140731569891860}}}} [12:28:50.757] send_ready_for_query = false [12:28:50.757] idle_in_transaction_timeout_enabled = false [12:28:50.757] idle_session_timeout_enabled = false [12:28:50.757] __func__ = "PostgresMain" [12:28:50.757] #20 0x000055a0347f1fad in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:28:50.757] bsdata = [12:28:50.757] #21 0x000055a0346a9a2e in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe9f3b692c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe9f3b6980) at ../src/backend/postmaster/launch_backend.c:274 [12:28:50.757] pid = [12:28:50.757] #22 0x000055a0346af4e2 in BackendStartup (client_sock=client_sock@entry=0x7ffe9f3b6980) at ../src/backend/postmaster/postmaster.c:3420 [12:28:50.757] bn = 0x55a05c0db1a8 [12:28:50.757] pid = [12:28:50.757] startup_data = {canAcceptConnections = CAC_OK} [12:28:50.757] __func__ = "BackendStartup" [12:28:50.757] #23 0x000055a0346afa44 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [12:28:50.757] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\321\353e\177\000\000>\004\000\000\000\000\000\000\260\227C\352e\177\000\000\240/\223\353e\177\000\0008j;\237\376\177\000\0004j;\237\376\177", '\000' , "\036\360\2063\240U\000\000\240ׂ3\240U\000\000\000k;\237\376\177\000\000\370j;\237\376\177\000\000\225[\362\001\343_`\311p\212\r\\\240U\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [12:28:50.757] i = 0 [12:28:50.757] now = [12:28:50.757] last_lockfile_recheck_time = 1728303920 [12:28:50.757] last_touch_time = 1728303920 [12:28:50.757] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -1623495872, user_data = 0x0}, {pos = 15, events = 0, fd = 864481310, user_data = 0x7f65ebd3b668}, {pos = -349665744, events = 32613, fd = -338447648, user_data = 0x7c96e577}, {pos = -1623495808, events = 32766, fd = -338617784, user_data = 0xf}, {pos = -349665744, events = 32613, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -338447648, user_data = 0x7ffe9f3b6af8}, {pos = -1623495936, events = 32766, fd = -338446744, user_data = 0x0}, {pos = 1544222064, events = 21920, fd = -363926299, user_data = 0x7ffe9f3b7013}, {pos = 1, events = 0, fd = -1623495936, user_data = 0xffffffff}, {pos = -364716000, events = 32613, fd = -342675552, user_data = 0x55a05c0da308}, {pos = 1544397288, events = 21920, fd = 1544415377, user_data = 0x7f65ebd17ebe}, {pos = 1, events = 0, fd = -338447648, user_data = 0x1b6}, {pos = 889363888, events = 21920, fd = 0, user_data = 0x1}, {pos = 1544226960, events = 21920, fd = -338592066, user_data = 0x1}, {pos = 0, events = 0, fd = -364716000, user_data = 0x7f65ea4f2dc0 }, {pos = 16, events = 0, fd = -1623494832, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f65ebd1a1ba}, {pos = 0, events = 0, fd = -364188380, user_data = 0x0}, {pos = 896253024, events = 21920, fd = 2, user_data = 0x7}, {pos = 1543966352, events = 21920, fd = 1952410737, user_data = 0x169}, {pos = 889363272, events = 21920, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 1544226960, events = 21920, fd = -338592066, user_data = 0x1}, {pos = -364154899, events = 32613, fd = -364682040, user_data = 0x55a05c0e3900}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -362865568, events = 32613, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55a05c070e90}, {pos = -364152310, events = 32613, fd = 0, user_data = 0x0}, {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 = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f65eb289540}, {pos = -349660544, events = 32613, 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 = -362882592, events = 32613, fd = -364244626, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0xc9605fe3eb172f00}, {pos = -362879520, events = 32613, fd = -328, user_data = 0x0}, {pos = 1544396968, events = 21920, fd = 1024, user_data = 0x55a05c0da0a8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 32840, events = 0, fd = -328, user_data = 0x0}, {pos = 1544226960, events = 21920, fd = -363909165, user_data = 0x7ffe9f3b7008}, {pos = 883829022, events = 21920, fd = 896316048, user_data = 0x55a034ad13db }, {pos = 1544396768, events = 21920, fd = 1544218960, user_data = 0x55a05c0d9fe0}, {pos = -364160962, events = 32613, fd = 0, user_data = 0x55a034ae3045 }, {pos = 1544396768, events = 1, fd = 883831182, user_data = 0x55a05c0ae950}, {pos = -350802176, events = 3378536419, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -364238159, user_data = 0x7f65ea4a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -350802176, user_data = 0x55a05c086080}, {pos = -350802176, events = 3378536419, fd = 11, user_data = 0xc9605fe3eb172f00}, {pos = 0, events = 0, fd = -364531143, user_data = 0x1}, {pos = 879400747, events = 21920, fd = 4194304, user_data = 0x55a034ad126f }, {pos = 1544052864, events = 21920, fd = 1544218960, user_data = 0x55a05c086080}, {pos = 1, events = 0, fd = 0, user_data = 0x55a034ae3045 }, {pos = 1544052864, events = 21920, fd = 883831182, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55a0344dec58 }, {pos = 0, events = 0, fd = 877543320, user_data = 0xb}, {pos = 879421904, events = 21920, fd = 892713296, user_data = 0x55a05c0af308}} [12:28:50.757] nevents = 1 [12:28:50.757] __func__ = "ServerLoop" [12:28:50.757] #24 0x000055a0346b11c7 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a05c06ccf0) at ../src/backend/postmaster/postmaster.c:1351 [12:28:50.757] opt = [12:28:50.757] status = [12:28:50.757] userDoption = [12:28:50.757] listen_addr_saved = false [12:28:50.757] output_config_variable = [12:28:50.757] __func__ = "PostmasterMain" [12:28:50.757] #25 0x000055a0344ef025 in main (argc=4, argv=0x55a05c06ccf0) at ../src/backend/main/main.c:197 [12:28:50.757] do_check_root = [12:28:50.791] -e [12:28:50.791] [12:28:50.791] [12:28:50.849] dumping /tmp/cores/sh-3-32819.core for /bin/sh [12:28:50.897] [12:28:50.897] This GDB supports auto-downloading debuginfo from the following URLs: [12:28:50.897] [12:28:50.897] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:28:50.897] Debuginfod has been disabled. [12:28:50.897] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:28:50.901] [New LWP 32819] [12:28:50.902] [Thread debugging using libthread_db enabled] [12:28:50.902] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:28:50.902] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/020_archive_status/data/t'. [12:28:50.902] Program terminated with signal SIGQUIT, Quit. [12:28:50.902] #0 0x00007f6934f04d24 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.905] [12:28:50.905] Thread 1 (Thread 0x7f6934e72740 (LWP 32819)): [12:28:50.905] #0 0x00007f6934f04d24 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.905] No symbol table info available. [12:28:50.905] #1 0x00007f6934eb1239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.905] No symbol table info available. [12:28:50.905] #2 0x00007f6934eb1497 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.905] No symbol table info available. [12:28:50.905] #3 0x000055fc370e95c1 in ?? () [12:28:50.905] No symbol table info available. [12:28:50.905] #4 0x000055fc370e3369 in ?? () [12:28:50.905] No symbol table info available. [12:28:50.905] #5 0x000055fc370e220f in ?? () [12:28:50.905] No symbol table info available. [12:28:50.905] #6 0x000055fc370e2c3b in ?? () [12:28:50.905] No symbol table info available. [12:28:50.905] #7 0x000055fc370e066f in ?? () [12:28:50.905] No symbol table info available. [12:28:50.905] #8 0x00007f6934e9c24a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.905] No symbol table info available. [12:28:50.905] #9 0x00007f6934e9c305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:50.905] No symbol table info available. [12:28:50.905] #10 0x000055fc370e0781 in ?? () [12:28:50.905] No symbol table info available. [12:28:50.912] -e [12:28:50.912] [12:28:50.912] [12:28:50.975] dumping /tmp/cores/postgres-6-30040.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:28:51.225] [New LWP 30040] [12:28:51.225] [12:28:51.225] This GDB supports auto-downloading debuginfo from the following URLs: [12:28:51.225] [12:28:51.225] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:28:51.225] Debuginfod has been disabled. [12:28:51.225] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:28:51.327] [Thread debugging using libthread_db enabled] [12:28:51.327] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:28:51.327] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [12:28:51.327] Program terminated with signal SIGABRT, Aborted. [12:28:51.327] #0 0x00007fef9dea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:52.207] [12:28:52.207] Thread 1 (Thread 0x7fef9e638f00 (LWP 30040)): [12:28:52.207] #0 0x00007fef9dea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:52.207] No symbol table info available. [12:28:52.207] #1 0x00007fef9de5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:52.207] No symbol table info available. [12:28:52.207] #2 0x00007fef9de45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:52.207] No symbol table info available. [12:28:52.207] #3 0x0000560f1d07a402 in ExceptionalCondition (conditionName=conditionName@entry=0x560f1d2ecd95 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x560f1d2ec2b0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [12:28:52.207] No locals. [12:28:52.207] #4 0x0000560f1ca04301 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x560f2bec2970, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [12:28:52.207] estate = 0x560f2be91940 [12:28:52.207] oldcontext = 0x560f2bf37ba0 [12:28:52.207] __func__ = "standard_ExecutorStart" [12:28:52.207] #5 0x0000560f1ca044dd in ExecutorStart (queryDesc=queryDesc@entry=0x560f2bec2970, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [12:28:52.207] No locals. [12:28:52.207] #6 0x0000560f1c92a616 in refresh_matview_datafill (dest=0x560f2be9cd68, query=, query@entry=0x560f2be7e640, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [12:28:52.207] rewritten = [12:28:52.207] plan = 0x560f2bec1ea8 [12:28:52.207] queryDesc = 0x560f2bec2970 [12:28:52.207] copied_query = [12:28:52.207] processed = [12:28:52.207] __func__ = "refresh_matview_datafill" [12:28:52.207] #7 0x0000560f1c92c97d in RefreshMatViewByOid (matviewOid=27285, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [12:28:52.207] dest = [12:28:52.207] matviewRel = 0x7fef92839ce8 [12:28:52.207] rule = [12:28:52.207] actions = [12:28:52.207] dataQuery = 0x560f2be7e640 [12:28:52.207] tableSpace = [12:28:52.207] relowner = 10 [12:28:52.207] OIDNewHeap = 27311 [12:28:52.207] processed = 0 [12:28:52.207] relpersistence = 112 'p' [12:28:52.207] save_userid = 10 [12:28:52.207] save_sec_context = 0 [12:28:52.207] save_nestlevel = 2 [12:28:52.207] address = {classId = 0, objectId = 0, objectSubId = 0} [12:28:52.207] __func__ = "RefreshMatViewByOid" [12:28:52.207] #8 0x0000560f1c92cabc in ExecRefreshMatView (stmt=0x560f2be83e10, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [12:28:52.207] matviewOid = [12:28:52.207] lockmode = [12:28:52.207] #9 0x0000560f1c8e3770 in ExecCreateTableAs (pstate=pstate@entry=0x560f2bf37ca0, stmt=stmt@entry=0x560f2bd5c770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffeb9508610) at ../src/backend/commands/createas.c:350 [12:28:52.207] refresh = [12:28:52.207] query = 0x560f2bd5c930 [12:28:52.207] into = 0x560f2bd5c4c8 [12:28:52.207] is_matview = true [12:28:52.207] do_refresh = false [12:28:52.207] dest = [12:28:52.207] address = {classId = 1259, objectId = 27285, objectSubId = 0} [12:28:52.207] __func__ = "ExecCreateTableAs" [12:28:52.207] #10 0x0000560f1cdf4476 in ProcessUtilitySlow (pstate=pstate@entry=0x560f2bf37ca0, pstmt=pstmt@entry=0x560f2bd5c820, queryString=queryString@entry=0x560f2bd5ba30 "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=0x560f2bd5d258, qc=0x7ffeb9508610) at ../src/backend/tcop/utility.c:1675 [12:28:52.207] _save_exception_stack = 0x7ffeb95084d0 [12:28:52.207] _save_context_stack = 0x0 [12:28:52.207] _local_sigjmp_buf = {{__jmpbuf = {0, -5605759905572053311, 94623159928688, 0, 94623159925296, 0, -2173142832393478463, -5605792943378784575}, __mask_was_saved = 0, __saved_mask = {__val = {140666937599616, 14737, 94622908317187, 1, 4294982033, 140666937599616, 94622912127868, 140667131235768, 94623159925296, 94622914441189, 94622924374370, 94622924374496, 140732007482132, 94622914635800, 94622924374385, 94622924374496}}}} [12:28:52.207] _do_rethrow = false [12:28:52.207] parsetree = 0x560f2bd5c770 [12:28:52.207] isTopLevel = true [12:28:52.207] isCompleteQuery = true [12:28:52.207] needCleanup = false [12:28:52.207] commandCollected = false [12:28:52.207] address = {classId = 22031, objectId = 735430512, objectSubId = 22031} [12:28:52.207] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [12:28:52.207] __func__ = "ProcessUtilitySlow" [12:28:52.207] #11 0x0000560f1cdf2a87 in standard_ProcessUtility (pstmt=0x560f2bd5c820, queryString=0x560f2bd5ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x560f2bd5d258, qc=0x7ffeb9508610) at ../src/backend/tcop/utility.c:1067 [12:28:52.207] parsetree = 0x560f2bd5c770 [12:28:52.207] isTopLevel = true [12:28:52.207] isAtomicContext = false [12:28:52.207] pstate = 0x560f2bf37ca0 [12:28:52.207] readonly_flags = [12:28:52.207] __func__ = "standard_ProcessUtility" [12:28:52.207] #12 0x0000560f1cdf2be2 in ProcessUtility (pstmt=pstmt@entry=0x560f2bd5c820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x560f2bd5d258, qc=0x7ffeb9508610) at ../src/backend/tcop/utility.c:523 [12:28:52.207] No locals. [12:28:52.207] #13 0x0000560f1cdee44e in PortalRunUtility (portal=portal@entry=0x560f2bdde680, pstmt=pstmt@entry=0x560f2bd5c820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560f2bd5d258, qc=qc@entry=0x7ffeb9508610) at ../src/backend/tcop/pquery.c:1158 [12:28:52.207] No locals. [12:28:52.207] #14 0x0000560f1cdee9f3 in PortalRunMulti (portal=portal@entry=0x560f2bdde680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560f2bd5d258, altdest=altdest@entry=0x560f2bd5d258, qc=qc@entry=0x7ffeb9508610) at ../src/backend/tcop/pquery.c:1316 [12:28:52.207] pstmt = 0x560f2bd5c820 [12:28:52.207] stmtlist_item__state = [12:28:52.207] active_snapshot_set = false [12:28:52.207] stmtlist_item = 0x560f2bd5d220 [12:28:52.207] #15 0x0000560f1cdeefc6 in PortalRun (portal=portal@entry=0x560f2bdde680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x560f2bd5d258, altdest=altdest@entry=0x560f2bd5d258, qc=0x7ffeb9508610) at ../src/backend/tcop/pquery.c:791 [12:28:52.207] _save_exception_stack = 0x7ffeb95086c0 [12:28:52.207] _save_context_stack = 0x0 [12:28:52.207] _local_sigjmp_buf = {{__jmpbuf = {0, -5605759904826515775, 94623160460928, 94623159928808, 94623160460928, 94623159928736, -2173142832263455039, -5605792932701790527}, __mask_was_saved = 0, __saved_mask = {__val = {94622911812522, 94623159925040, 112, 4, 94622911816939, 3109062047, 4, 94623159928736, 112, 73, 94623160460928, 94623159928808, 94623159928784, 94623159928736, 94622911904142, 1}}}} [12:28:52.207] _do_rethrow = [12:28:52.207] result = [12:28:52.207] nprocessed = [12:28:52.207] saveTopTransactionResourceOwner = 0x560f2bd9b838 [12:28:52.207] saveTopTransactionContext = 0x560f2bdef660 [12:28:52.207] saveActivePortal = 0x0 [12:28:52.207] saveResourceOwner = 0x560f2bd9b838 [12:28:52.207] savePortalContext = 0x0 [12:28:52.207] saveMemoryContext = 0x560f2bdef660 [12:28:52.207] __func__ = "PortalRun" [12:28:52.207] #16 0x0000560f1cde83b2 in exec_simple_query (query_string=query_string@entry=0x560f2bd5ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [12:28:52.207] cmdtaglen = 24 [12:28:52.207] snapshot_set = [12:28:52.207] per_parsetree_context = 0x0 [12:28:52.207] plantree_list = 0x560f2bd5d208 [12:28:52.207] parsetree = 0x560f2bd5c7a0 [12:28:52.207] commandTag = [12:28:52.207] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:28:52.207] querytree_list = [12:28:52.207] portal = 0x560f2bdde680 [12:28:52.207] receiver = 0x560f2bd5d258 [12:28:52.207] format = 0 [12:28:52.207] cmdtagname = [12:28:52.207] parsetree_item__state = [12:28:52.207] dest = DestRemote [12:28:52.207] oldcontext = 0x560f2bdef660 [12:28:52.207] parsetree_list = 0x560f2bd5c7d0 [12:28:52.207] parsetree_item = 0x560f2bd5c7e8 [12:28:52.207] save_log_statement_stats = false [12:28:52.207] was_logged = true [12:28:52.207] use_implicit_block = false [12:28:52.207] msec_str = "p\210P\271\376\177\000\000\260\001\n\035\017V\000\000\240\206P\271\376\177\000\000G\000\000\000\000\000\000" [12:28:52.207] __func__ = "exec_simple_query" [12:28:52.207] #17 0x0000560f1cdeb136 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [12:28:52.207] query_string = 0x560f2bd5ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [12:28:52.207] firstchar = [12:28:52.207] input_message = {data = 0x560f2bd5ba30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [12:28:52.207] local_sigjmp_buf = {{__jmpbuf = {94622924382936, -5605790568190828863, 4, 140732007483504, 140732007483648, 140732007483652, -2173142832326369599, -5605792930615779647}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94623159655856, 14336, 94622924377024, 94623160182768, 140732007483648, 94622911816487, 0, 9, 2, 94622924382944, 94623159655856, 94622924377024, 140732007483504, 140732007483648, 140732007483652}}}} [12:28:52.207] send_ready_for_query = false [12:28:52.207] idle_in_transaction_timeout_enabled = false [12:28:52.207] idle_session_timeout_enabled = false [12:28:52.207] __func__ = "PostgresMain" [12:28:52.207] #18 0x0000560f1cde0fad in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:28:52.207] bsdata = [12:28:52.207] #19 0x0000560f1cc98a2e in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffeb950881c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffeb9508870) at ../src/backend/postmaster/launch_backend.c:274 [12:28:52.207] pid = [12:28:52.207] #20 0x0000560f1cc9e4e2 in BackendStartup (client_sock=client_sock@entry=0x7ffeb9508870) at ../src/backend/postmaster/postmaster.c:3420 [12:28:52.207] bn = 0x560f2bd90d98 [12:28:52.207] pid = [12:28:52.207] startup_data = {canAcceptConnections = CAC_OK} [12:28:52.207] __func__ = "BackendStartup" [12:28:52.207] #21 0x0000560f1cc9ea44 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [12:28:52.207] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\342\235\357\177\000\0004\211P\271\376\177\000\000\312\300\206\237\357\177\000\000>\004\000\000\000\000\000\000\260\227\343\235\357\177\000\000\240O>\237\357\177\000\0008\211P\271\376\177\000\0004\211P\271\376\177\000\000\000\000\000\000\000\000\000\000ЈP\271\376\177\000\000\036\340\345\033\017V\000\000\240\307\341\033\017V\000\000\000\212P\271\376\177\000\000\370\211P\271\376\177\000\000\225[\362\001\000\000\000", __ss_align = 140667137860768}, salen = 2}} [12:28:52.207] i = 0 [12:28:52.207] now = [12:28:52.207] last_lockfile_recheck_time = 1728303886 [12:28:52.207] last_touch_time = 1728303886 [12:28:52.207] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7fef9f8962e0}, {pos = -1185904264, events = 0, fd = 0, user_data = 0x7fef9f896668}, {pos = 468049950, events = 22031, fd = -1618385304, user_data = 0x7fef9ec8a630}, {pos = -1618386208, events = 32751, fd = 2090263927, user_data = 0x7ffeb9508a80}, {pos = -1618556344, events = 32751, fd = 15, user_data = 0x7fef9ec8a630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1618386208, events = 32751, fd = -1185904136, user_data = 0x7ffeb9508a00}, {pos = -1618385304, events = 32751, fd = 0, user_data = 0x560f2bd8a368}, {pos = 735617608, events = 22031, fd = 735617057, user_data = 0x7fef00000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7fef9de2e020}, {pos = -1623306336, events = 32751, fd = 735617896, user_data = 0x7ffeb9508df0}, {pos = 735589064, events = 22031, fd = 735618128, user_data = 0x560f2bd8a368}, {pos = -1618386208, events = 32751, fd = 438, user_data = 0x560f1d618db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x560f2bd5ba48}, {pos = -1618530626, events = 32751, fd = 1, user_data = 0x0}, {pos = -1646075872, events = 32751, fd = -1645269568, user_data = 0x7ffeb9508e60}, {pos = -1185903040, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1618521670, user_data = 0x0}, {pos = -1645548252, events = 32751, fd = 0, user_data = 0x560f1dcaac60 }, {pos = 2, events = 0, fd = 7, user_data = 0x560f2bd1de50}, {pos = 0, events = 0, fd = -1646041912, user_data = 0x7fef9de9c880 }, {pos = -1637642824, events = 32751, fd = 8096, user_data = 0x100007f00000002}, {pos = -1645515129, events = 32751, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1644225440, events = 32751, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x560f2bd1de50}, {pos = -1645512182, events = 32751, fd = 1663923061, user_data = 0x560f2bd1de50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffff0000000000}, {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 = 0x7f0000000000}, {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 = 0x6efb76f9439acc00}, {pos = -1644239392, events = 32751, fd = -328, user_data = 0x0}, {pos = 735617288, events = 22031, fd = 1024, user_data = 0x560f2bd8a108}, {pos = -1185902856, events = 32766, fd = -1645511009, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 26228, events = 0, fd = -328, user_data = 0x0}, {pos = 735427144, events = 22031, fd = -1645269037, user_data = 0x7ffeb9508ef8}, {pos = 487397662, events = 22031, fd = 499884688, user_data = 0x560f1d0c03db }, {pos = 735617088, events = 22031, fd = 735426864, user_data = 0x560f2bd8a040}, {pos = -1645521173, events = 32751, fd = 0, user_data = 0x560f1d0d2045 }, {pos = 735617088, events = 1, fd = 487399822, user_data = 0x560f2bd5b930}, {pos = 1134218240, events = 1861973753, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1645598031, user_data = 0x7fef9dea14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1134218240, user_data = 0x560f2bd33060}, {pos = 1134218240, events = 1861973753, fd = 11, user_data = 0x6efb76f9439acc00}, {pos = 0, events = 0, fd = -1645891015, user_data = 0x1}, {pos = 482969387, events = 22031, fd = 4194304, user_data = 0x560f1d0c026f }, {pos = 735260768, events = 22031, fd = 735426864, user_data = 0x560f2bd33060}, {pos = 1, events = 0, fd = 0, user_data = 0x560f1d0d2045 }, {pos = 735260768, events = 22031, fd = 487399822, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x560f1cacdc58 }, {pos = 0, events = 0, fd = 481111960, user_data = 0xb}, {pos = 482990544, events = 22031, fd = 496281936, user_data = 0x560f2bd5c2d8}} [12:28:52.208] nevents = 1 [12:28:52.208] __func__ = "ServerLoop" [12:28:52.208] #22 0x0000560f1cca01c7 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x560f2bd19cc0) at ../src/backend/postmaster/postmaster.c:1351 [12:28:52.208] opt = [12:28:52.208] status = [12:28:52.208] userDoption = [12:28:52.208] listen_addr_saved = false [12:28:52.208] output_config_variable = [12:28:52.208] __func__ = "PostmasterMain" [12:28:52.208] #23 0x0000560f1cade025 in main (argc=4, argv=0x560f2bd19cc0) at ../src/backend/main/main.c:197 [12:28:52.208] do_check_root = [12:28:52.243] -e [12:28:52.243] [12:28:52.243] [12:28:52.305] dumping /tmp/cores/postgres-6-29484.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [12:28:52.557] [New LWP 29484] [12:28:52.557] [12:28:52.557] This GDB supports auto-downloading debuginfo from the following URLs: [12:28:52.557] [12:28:52.557] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:28:52.557] Debuginfod has been disabled. [12:28:52.557] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:28:52.659] [Thread debugging using libthread_db enabled] [12:28:52.659] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:28:52.659] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [12:28:52.659] Program terminated with signal SIGABRT, Aborted. [12:28:52.659] #0 0x00007f3f712a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:53.557] [12:28:53.557] Thread 1 (Thread 0x7f3f72086f00 (LWP 29484)): [12:28:53.557] #0 0x00007f3f712a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:53.557] No symbol table info available. [12:28:53.557] #1 0x00007f3f7125afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:53.557] No symbol table info available. [12:28:53.557] #2 0x00007f3f71245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:28:53.557] No symbol table info available. [12:28:53.557] #3 0x00005643c56f1402 in ExceptionalCondition (conditionName=conditionName@entry=0x5643c5963d95 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5643c59632b0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [12:28:53.557] No locals. [12:28:53.557] #4 0x00005643c507b301 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x564403985c50, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [12:28:53.557] estate = 0x5644037dcd80 [12:28:53.557] oldcontext = 0x564403915920 [12:28:53.557] __func__ = "standard_ExecutorStart" [12:28:53.557] #5 0x00005643c507b4dd in ExecutorStart (queryDesc=queryDesc@entry=0x564403985c50, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [12:28:53.557] No locals. [12:28:53.557] #6 0x00005643c4fa1616 in refresh_matview_datafill (dest=0x5644038fc7b8, query=, query@entry=0x5644038c6420, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [12:28:53.557] rewritten = [12:28:53.557] plan = 0x564403985188 [12:28:53.557] queryDesc = 0x564403985c50 [12:28:53.557] copied_query = [12:28:53.557] processed = [12:28:53.557] __func__ = "refresh_matview_datafill" [12:28:53.557] #7 0x00005643c4fa397d in RefreshMatViewByOid (matviewOid=27421, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [12:28:53.557] dest = [12:28:53.557] matviewRel = 0x7f3f65845b88 [12:28:53.557] rule = [12:28:53.557] actions = [12:28:53.557] dataQuery = 0x5644038c6420 [12:28:53.557] tableSpace = [12:28:53.557] relowner = 10 [12:28:53.557] OIDNewHeap = 27435 [12:28:53.557] processed = 0 [12:28:53.557] relpersistence = 112 'p' [12:28:53.557] save_userid = 10 [12:28:53.557] save_sec_context = 0 [12:28:53.557] save_nestlevel = 2 [12:28:53.557] address = {classId = 0, objectId = 0, objectSubId = 0} [12:28:53.557] __func__ = "RefreshMatViewByOid" [12:28:53.557] #8 0x00005643c4fa3abc in ExecRefreshMatView (stmt=0x564403913e30, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [12:28:53.557] matviewOid = [12:28:53.557] lockmode = [12:28:53.557] #9 0x00005643c4f5a770 in ExecCreateTableAs (pstate=pstate@entry=0x564403915a20, stmt=stmt@entry=0x5644037aa7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd495b8d40) at ../src/backend/commands/createas.c:350 [12:28:53.557] refresh = [12:28:53.557] query = 0x5644037aa9b0 [12:28:53.557] into = 0x5644037aa548 [12:28:53.557] is_matview = true [12:28:53.557] do_refresh = false [12:28:53.557] dest = [12:28:53.557] address = {classId = 1259, objectId = 27421, objectSubId = 0} [12:28:53.557] __func__ = "ExecCreateTableAs" [12:28:53.557] #10 0x00005643c546b476 in ProcessUtilitySlow (pstate=pstate@entry=0x564403915a20, pstmt=pstmt@entry=0x5644037aa8a0, queryString=queryString@entry=0x5644037a9ab0 "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=0x5644037ab2d8, qc=0x7ffd495b8d40) at ../src/backend/tcop/utility.c:1675 [12:28:53.557] _save_exception_stack = 0x7ffd495b8c00 [12:28:53.557] _save_context_stack = 0x0 [12:28:53.557] _local_sigjmp_buf = {{__jmpbuf = {0, 4775831603960755490, 94850116134896, 0, 94850116131504, 0, 1240105939286766882, 4776249864666101026}, __mask_was_saved = 0, __saved_mask = {__val = {139910271313024, 10565, 94849071967747, 1, 4294977861, 139910271313024, 94849071958065, 1, 45376388060984, 1, 10565, 139910271313024, 139910271313024, 1, 94849071968094, 94850116343608}}}} [12:28:53.557] _do_rethrow = false [12:28:53.557] parsetree = 0x5644037aa7f0 [12:28:53.557] isTopLevel = true [12:28:53.557] isCompleteQuery = true [12:28:53.557] needCleanup = false [12:28:53.557] commandCollected = false [12:28:53.557] address = {classId = 22084, objectId = 58370032, objectSubId = 22084} [12:28:53.557] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [12:28:53.557] __func__ = "ProcessUtilitySlow" [12:28:53.557] #11 0x00005643c5469a87 in standard_ProcessUtility (pstmt=0x5644037aa8a0, queryString=0x5644037a9ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5644037ab2d8, qc=0x7ffd495b8d40) at ../src/backend/tcop/utility.c:1067 [12:28:53.557] parsetree = 0x5644037aa7f0 [12:28:53.557] isTopLevel = true [12:28:53.557] isAtomicContext = false [12:28:53.557] pstate = 0x564403915a20 [12:28:53.557] readonly_flags = [12:28:53.557] __func__ = "standard_ProcessUtility" [12:28:53.557] #12 0x00005643c5469be2 in ProcessUtility (pstmt=pstmt@entry=0x5644037aa8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5644037ab2d8, qc=0x7ffd495b8d40) at ../src/backend/tcop/utility.c:523 [12:28:53.557] No locals. [12:28:53.557] #13 0x00005643c546544e in PortalRunUtility (portal=portal@entry=0x56440382c050, pstmt=pstmt@entry=0x5644037aa8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5644037ab2d8, qc=qc@entry=0x7ffd495b8d40) at ../src/backend/tcop/pquery.c:1158 [12:28:53.557] No locals. [12:28:53.557] #14 0x00005643c54659f3 in PortalRunMulti (portal=portal@entry=0x56440382c050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5644037ab2d8, altdest=altdest@entry=0x5644037ab2d8, qc=qc@entry=0x7ffd495b8d40) at ../src/backend/tcop/pquery.c:1316 [12:28:53.557] pstmt = 0x5644037aa8a0 [12:28:53.557] stmtlist_item__state = [12:28:53.557] active_snapshot_set = false [12:28:53.557] stmtlist_item = 0x5644037ab2a0 [12:28:53.557] #15 0x00005643c5465fc6 in PortalRun (portal=portal@entry=0x56440382c050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5644037ab2d8, altdest=altdest@entry=0x5644037ab2d8, qc=0x7ffd495b8d40) at ../src/backend/tcop/pquery.c:791 [12:28:53.557] _save_exception_stack = 0x7ffd495b8df0 [12:28:53.557] _save_context_stack = 0x0 [12:28:53.557] _local_sigjmp_buf = {{__jmpbuf = {0, 4775831604173616418, 94850116665424, 94850116135016, 94850116665424, 94850116134944, 1240105939425178914, 4776249871034234146}, __mask_was_saved = 0, __saved_mask = {__val = {94849075463082, 94850116131248, 112, 4, 94849075467499, 1230736591, 4, 94850116134944, 112, 73, 94850116665424, 94850116135016, 94850116134992, 94850116134944, 94849075554702, 1}}}} [12:28:53.557] _do_rethrow = [12:28:53.557] result = [12:28:53.557] nprocessed = [12:28:53.557] saveTopTransactionResourceOwner = 0x5644037e8d08 [12:28:53.557] saveTopTransactionContext = 0x56440383dc60 [12:28:53.557] saveActivePortal = 0x0 [12:28:53.557] saveResourceOwner = 0x5644037e8d08 [12:28:53.557] savePortalContext = 0x0 [12:28:53.557] saveMemoryContext = 0x56440383dc60 [12:28:53.557] __func__ = "PortalRun" [12:28:53.557] #16 0x00005643c545f3b2 in exec_simple_query (query_string=query_string@entry=0x5644037a9ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [12:28:53.557] cmdtaglen = 24 [12:28:53.557] snapshot_set = [12:28:53.557] per_parsetree_context = 0x0 [12:28:53.557] plantree_list = 0x5644037ab288 [12:28:53.557] parsetree = 0x5644037aa820 [12:28:53.557] commandTag = [12:28:53.557] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:28:53.557] querytree_list = [12:28:53.557] portal = 0x56440382c050 [12:28:53.557] receiver = 0x5644037ab2d8 [12:28:53.557] format = 0 [12:28:53.557] cmdtagname = [12:28:53.557] parsetree_item__state = [12:28:53.557] dest = DestRemote [12:28:53.557] oldcontext = 0x56440383dc60 [12:28:53.557] parsetree_list = 0x5644037aa850 [12:28:53.557] parsetree_item = 0x5644037aa868 [12:28:53.557] save_log_statement_stats = false [12:28:53.557] was_logged = false [12:28:53.557] use_implicit_block = false [12:28:53.557] msec_str = "\240\217[I\375\177\000\000\260qq\305CV\000\000Ѝ[I\375\177\000\000G\000\000\000\000\000\000" [12:28:53.557] __func__ = "exec_simple_query" [12:28:53.557] #17 0x00005643c5462136 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4793 [12:28:53.557] query_string = 0x5644037a9ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [12:28:53.557] firstchar = [12:28:53.557] input_message = {data = 0x5644037a9ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [12:28:53.557] local_sigjmp_buf = {{__jmpbuf = {94849088033496, 4776246733160723746, 4, 140725834190752, 140725834190896, 140725834190900, 1240105939622311202, 4776249868830782754}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94850115861968, 15616, 94849088027584, 94850116385984, 140725834190896, 94849075467047, 0, 9, 2, 94849088033504, 94850115861968, 94849088027584, 140725834190752, 140725834190896, 140725834190900}}}} [12:28:53.557] send_ready_for_query = false [12:28:53.557] idle_in_transaction_timeout_enabled = false [12:28:53.557] idle_session_timeout_enabled = false [12:28:53.557] __func__ = "PostgresMain" [12:28:53.557] #18 0x00005643c5457fad in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:28:53.557] bsdata = [12:28:53.557] #19 0x00005643c530fa2e in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd495b8f4c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd495b8fa0) at ../src/backend/postmaster/launch_backend.c:274 [12:28:53.557] pid = [12:28:53.557] #20 0x00005643c53154e2 in BackendStartup (client_sock=client_sock@entry=0x7ffd495b8fa0) at ../src/backend/postmaster/postmaster.c:3420 [12:28:53.557] bn = 0x5644037d2208 [12:28:53.557] pid = [12:28:53.557] startup_data = {canAcceptConnections = CAC_OK} [12:28:53.557] __func__ = "BackendStartup" [12:28:53.557] #21 0x00005643c5315a44 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [12:28:53.557] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "[I\375\177\000\0004\220[I\375\177", '\000' , "\036PM\304CV\000\000\2407I\304CV\000\000\000\221[I\375\177\000\000\370\220[I\375\177\000\000\225[\362\001\000\000\000\000\240\324rr?\177\000\000+", '\000' , "3OM\304CV\000\000h\366\273r?\177\000\0000\326rr?\177\000", __ss_align = 139910484587232}, salen = 2}} [12:28:53.557] i = 0 [12:28:53.557] now = [12:28:53.557] last_lockfile_recheck_time = 1728303884 [12:28:53.557] last_touch_time = 1728303884 [12:28:53.557] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -1001566178, events = 22083, fd = 1924920936, user_data = 0x7f3f7272d630}, {pos = 1924920032, events = 32575, fd = 2090263927, user_data = 0x7ffd495b9180}, {pos = 1924749896, events = 32575, fd = 15, user_data = 0x7f3f7272d630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1924920032, events = 32575, fd = 1230737656, user_data = 0x7ffd495b9100}, {pos = 1924920936, events = 32575, fd = 0, user_data = 0x5644037a9b70}, {pos = -981980162, events = 22083, fd = 32768, user_data = 0x1}, {pos = 58374320, events = 22084, fd = -1, user_data = 0x7f3f7122e020}, {pos = 1920692128, events = 32575, fd = 58550088, user_data = 0x5644037d6628}, {pos = 58558529, events = 22084, fd = 1924775614, user_data = 0x1}, {pos = 1924920032, events = 32575, fd = 438, user_data = 0x5643c5c8fdb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x5644037a9b70}, {pos = 1924775614, events = 32575, fd = 1, user_data = 0x0}, {pos = 1898111008, events = 32575, fd = 1898917312, user_data = 0x10}, {pos = 1230738800, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1924784570, user_data = 0x0}, {pos = 1898638628, events = 32575, fd = 0, user_data = 0x5643c6321c60 }, {pos = 2, events = 0, fd = 7, user_data = 0x56440376be70}, {pos = -985717900, events = 22083, fd = 58576091, user_data = 0x5643c53f5fad }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5644037a9b70}, {pos = 1924775614, events = 32575, fd = 1, user_data = 0x0}, {pos = 1898144968, events = 32575, fd = 1898563712, user_data = 0x423}, {pos = 1898672109, events = 32575, fd = 2, user_data = 0x5644037d5410}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 1899961440, events = 32575, 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 = 0x484c536a2d737365}, {pos = 168444750, events = 824188960, fd = 822763892, user_data = 0x30340a3438383330}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = -982301782, events = 22083, fd = 58552368, user_data = 0x7f3f712b56eb}, {pos = 1899944416, events = 32575, fd = 1898582382, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x277605db85c54c00}, {pos = 1899947488, events = 32575, 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 = 58549480, user_data = 0x5643c5734c6d }, {pos = 58549280, events = 22084, fd = 3, user_data = 0x0}, {pos = 25678, events = 0, fd = -328, user_data = 0x0}, {pos = 58366832, events = 22084, fd = 1898917843, user_data = 0x7ffd495b9628}, {pos = -982218466, events = 22083, fd = -969731440, user_data = 0x5643c57373db }, {pos = 58549280, events = 22084, fd = 58366384, user_data = 0x5644037d6420}, {pos = 1898666046, events = 32575, fd = 0, user_data = 0x5643c5749045 }, {pos = 58549280, events = 1, fd = -982216306, user_data = 0x5644037a99b0}, {pos = -2050667520, events = 662046171, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1898588849, user_data = 0x7f3f712a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2050667520, user_data = 0x5644037810e0}, {pos = -2050667520, events = 662046171, fd = 11, user_data = 0x277605db85c54c00}, {pos = 0, events = 0, fd = 1898295865, user_data = 0x1}, {pos = -986646741, events = 22083, fd = 4194304, user_data = 0x5643c573726f }, {pos = 58200288, events = 22084, fd = 58366384, user_data = 0x5644037810e0}, {pos = 1, events = 0, fd = 0, user_data = 0x5643c5749045 }, {pos = 58200288, events = 22084, fd = -982216306, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x5643c5144c58 }, {pos = 0, events = 0, fd = -988504168, user_data = 0xb}, {pos = -986625584, events = 22083, fd = -973334192, user_data = 0x5644037aa388}} [12:28:53.557] nevents = 1 [12:28:53.557] __func__ = "ServerLoop" [12:28:53.557] #22 0x00005643c53171c7 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x564403767d30) at ../src/backend/postmaster/postmaster.c:1351 [12:28:53.557] opt = [12:28:53.557] status = [12:28:53.557] userDoption = [12:28:53.557] listen_addr_saved = false [12:28:53.557] output_config_variable = [12:28:53.557] __func__ = "PostmasterMain" [12:28:53.557] #23 0x00005643c5155025 in main (argc=8, argv=0x564403767d30) at ../src/backend/main/main.c:197 [12:28:53.557] do_check_root = [12:28:53.589] -e [12:28:53.589] [12:28:53.589] [12:28:53.649] dumping /tmp/cores/cp-3-32822.core for /usr/bin/cp [12:28:53.697] [12:28:53.697] This GDB supports auto-downloading debuginfo from the following URLs: [12:28:53.697] [12:28:53.697] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:28:53.697] Debuginfod has been disabled. [12:28:53.697] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:28:53.697] [New LWP 32822] [12:28:53.698] Core was generated by `cp /tmp/cirrus-ci-build/build/testrun/recovery/020_archive_status/data/t_020_ar'. [12:28:53.698] Program terminated with signal SIGQUIT, Quit. [12:28:53.698] #0 0x00007fa6b73aba50 in ?? () [12:28:53.698] [12:28:53.698] Thread 1 (LWP 32822): [12:28:53.698] #0 0x00007fa6b73aba50 in ?? () [12:28:53.698] No symbol table info available. [12:28:53.698] #1 0x0000000000000003 in ?? () [12:28:53.698] No symbol table info available. [12:28:53.698] #2 0x00007ffeb3da9493 in ?? () [12:28:53.698] No symbol table info available. [12:28:53.698] #3 0x00007ffeb3da9496 in ?? () [12:28:53.698] No symbol table info available. [12:28:53.698] #4 0x00007ffeb3da9516 in ?? () [12:28:53.698] No symbol table info available. [12:28:53.698] #5 0x0000000000000000 in ?? () [12:28:53.698] No symbol table info available.