[01:13:30.049] src/tools/ci/cores_backtrace.sh linux /tmp/cores [01:13:30.280] dumping /tmp/cores/postgres-6-35914.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:13:30.533] [New LWP 35914] [01:13:30.533] [01:13:30.533] This GDB supports auto-downloading debuginfo from the following URLs: [01:13:30.533] [01:13:30.533] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:13:30.533] Debuginfod has been disabled. [01:13:30.533] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:13:30.668] [Thread debugging using libthread_db enabled] [01:13:30.668] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:13:30.668] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [01:13:30.668] Program terminated with signal SIGABRT, Aborted. [01:13:30.668] #0 0x00007fb88a4a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:31.579] [01:13:31.579] Thread 1 (Thread 0x7fb888420f00 (LWP 35914)): [01:13:31.579] #0 0x00007fb88a4a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:31.579] No symbol table info available. [01:13:31.579] #1 0x00007fb88a45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:31.579] No symbol table info available. [01:13:31.579] #2 0x00007fb88a445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:31.579] No symbol table info available. [01:13:31.579] #3 0x000055739f95cd2d in ExceptionalCondition (conditionName=conditionName@entry=0x55739fbc970a "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55739fbc8c70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=196) at ../src/backend/utils/error/assert.c:66 [01:13:31.579] No locals. [01:13:31.579] #4 0x000055739f2f09b1 in standard_ExecutorStart (queryDesc=0x5573a0f8eb60, eflags=0) at ../src/backend/executor/execMain.c:196 [01:13:31.579] estate = 0x5573a0e467f0 [01:13:31.579] oldcontext = 0x5573a0f49340 [01:13:31.579] __func__ = "standard_ExecutorStart" [01:13:31.579] #5 0x00007fb88803d407 in pgss_ExecutorStart (queryDesc=0x5573a0f8eb60, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:994 [01:13:31.579] No locals. [01:13:31.579] #6 0x000055739f2f0b46 in ExecutorStart (queryDesc=queryDesc@entry=0x5573a0f8eb60, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [01:13:31.579] No locals. [01:13:31.579] #7 0x000055739f216d75 in refresh_matview_datafill (dest=0x5573a0f08988, query=, query@entry=0x5573a0e8ea40, queryString=queryString@entry=0x0) at ../src/backend/commands/matview.c:429 [01:13:31.579] rewritten = [01:13:31.579] plan = 0x5573a0f04d60 [01:13:31.579] queryDesc = 0x5573a0f8eb60 [01:13:31.579] copied_query = [01:13:31.579] processed = [01:13:31.579] __func__ = "refresh_matview_datafill" [01:13:31.579] #8 0x000055739f2190a5 in RefreshMatViewByOid (matviewOid=27351, skipData=, concurrent=, queryString=queryString@entry=0x0, params=params@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:321 [01:13:31.579] matviewRel = 0x7fb885fba5c8 [01:13:31.579] rule = [01:13:31.579] actions = [01:13:31.579] dataQuery = 0x5573a0e8ea40 [01:13:31.579] tableSpace = [01:13:31.579] relowner = 10 [01:13:31.579] OIDNewHeap = 27358 [01:13:31.579] dest = [01:13:31.579] processed = 0 [01:13:31.579] relpersistence = 112 'p' [01:13:31.579] save_userid = 10 [01:13:31.579] save_sec_context = 0 [01:13:31.579] save_nestlevel = 2 [01:13:31.579] address = {classId = 2700383568, objectId = 21875, objectSubId = 0} [01:13:31.579] __func__ = "RefreshMatViewByOid" [01:13:31.579] #9 0x000055739f2191dc in ExecRefreshMatView (stmt=0x5573a0f09a18, queryString=queryString@entry=0x0, params=params@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:13:31.579] matviewOid = [01:13:31.579] lockmode = [01:13:31.579] #10 0x000055739f1d04bb in ExecCreateTableAs (pstate=pstate@entry=0x5573a0f49440, stmt=stmt@entry=0x5573a0d76690, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc8df19730) at ../src/backend/commands/createas.c:353 [01:13:31.579] refresh = [01:13:31.579] query = 0x5573a0d76850 [01:13:31.579] into = 0x5573a0d763e8 [01:13:31.579] is_matview = true [01:13:31.579] do_refresh = false [01:13:31.579] dest = [01:13:31.579] address = {classId = 1259, objectId = 27351, objectSubId = 0} [01:13:31.579] rewritten = [01:13:31.579] plan = [01:13:31.579] queryDesc = [01:13:31.579] __func__ = "ExecCreateTableAs" [01:13:31.579] #11 0x000055739f6dc99d in ProcessUtilitySlow (pstate=pstate@entry=0x5573a0f49440, pstmt=pstmt@entry=0x5573a0d76740, queryString=queryString@entry=0x5573a0d75950 "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=0x5573a0d776e8, qc=0x7ffc8df19730) at ../src/backend/tcop/utility.c:1675 [01:13:31.579] _save_exception_stack = 0x7ffc8df192e0 [01:13:31.579] _save_context_stack = 0x0 [01:13:31.579] _local_sigjmp_buf = {{__jmpbuf = {0, -8202719483506144006, 93955108071056, 0, 93955108067664, 0, -2651410326289855238, -8202627895836488454}, __mask_was_saved = 0, __saved_mask = {__val = {64, 3, 93955087271832, 2381418360, 3, 5, 1, 5, 1, 1, 93955108072256, 93955108073664, 93955087358626, 2700099872, 93955087267415, 93955108067408}}}} [01:13:31.579] _do_rethrow = false [01:13:31.579] parsetree = 0x5573a0d76690 [01:13:31.579] isTopLevel = true [01:13:31.579] isCompleteQuery = true [01:13:31.579] needCleanup = false [01:13:31.579] commandCollected = false [01:13:31.579] address = {classId = 21875, objectId = 2698471056, objectSubId = 21875} [01:13:31.579] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:13:31.579] __func__ = "ProcessUtilitySlow" [01:13:31.579] #12 0x000055739f6dafc7 in standard_ProcessUtility (pstmt=pstmt@entry=0x5573a0d76740, queryString=queryString@entry=0x5573a0d75950 "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=0x5573a0d776e8, qc=0x7ffc8df19730) at ../src/backend/tcop/utility.c:1067 [01:13:31.579] parsetree = 0x5573a0d76690 [01:13:31.579] isTopLevel = true [01:13:31.579] isAtomicContext = false [01:13:31.579] pstate = 0x5573a0f49440 [01:13:31.579] readonly_flags = [01:13:31.579] __func__ = "standard_ProcessUtility" [01:13:31.579] #13 0x00007fb8880408aa in pgss_ProcessUtility (pstmt=0x5573a0d76740, queryString=0x5573a0d75950 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5573a0d776e8, qc=0x7ffc8df19730) at ../contrib/pg_stat_statements/pg_stat_statements.c:1168 [01:13:31.579] _save_exception_stack = 0x7ffc8df195f0 [01:13:31.579] _save_context_stack = 0x0 [01:13:31.579] _local_sigjmp_buf = {{__jmpbuf = {0, 2651872204449434874, 93955108071232, 93955108075240, 140722689906480, 0, -2651410326392615686, -2613134861739045638}, __mask_was_saved = 0, __saved_mask = {__val = {93955087589198, 140722689905750, 140722689905748, 0, 0, 139637976727552, 206158430232, 140722689905712, 93955087589415, 0, 206158430232, 140722689905744, 140722689905552, 2, 945, 93955108072032}}}} [01:13:31.579] _do_rethrow = false [01:13:31.579] duration = [01:13:31.579] bufusage = {shared_blks_hit = 93955108924456, shared_blks_read = 493921239040, shared_blks_dirtied = 0, shared_blks_written = 93955108923960, local_blks_hit = 93955108924456, local_blks_read = 93955080804967, local_blks_dirtied = 93955109701480, local_blks_written = 93955080805213, temp_blks_read = 93955108923960, temp_blks_written = 93955108923376, shared_blk_read_time = {ticks = 93955080804322}, shared_blk_write_time = {ticks = 93955087582650}, local_blk_read_time = {ticks = 140430536740280}, local_blk_write_time = {ticks = 93955108067664}, temp_blk_read_time = {ticks = 93955089874918}, temp_blk_write_time = {ticks = 93955099550818}} [01:13:31.579] walusage_start = {wal_records = 8917, wal_fpi = 118, wal_bytes = 1130497} [01:13:31.579] start = [01:13:31.579] rows = [01:13:31.579] bufusage_start = {shared_blks_hit = 33307, shared_blks_read = 3890, shared_blks_dirtied = 1636, shared_blks_written = 989, 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}} [01:13:31.579] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 140430501842496} [01:13:31.579] parsetree = [01:13:31.579] saved_queryId = 10350026774104024207 [01:13:31.579] saved_stmt_location = 0 [01:13:31.579] saved_stmt_len = 69 [01:13:31.579] enabled = true [01:13:31.579] #14 0x000055739f6db06d in ProcessUtility (pstmt=pstmt@entry=0x5573a0d76740, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5573a0d776e8, qc=0x7ffc8df19730) at ../src/backend/tcop/utility.c:519 [01:13:31.579] No locals. [01:13:31.579] #15 0x000055739f6d698e in PortalRunUtility (portal=portal@entry=0x5573a0df6e90, pstmt=pstmt@entry=0x5573a0d76740, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5573a0d776e8, qc=qc@entry=0x7ffc8df19730) at ../src/backend/tcop/pquery.c:1158 [01:13:31.579] No locals. [01:13:31.579] #16 0x000055739f6d6f33 in PortalRunMulti (portal=portal@entry=0x5573a0df6e90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5573a0d776e8, altdest=altdest@entry=0x5573a0d776e8, qc=qc@entry=0x7ffc8df19730) at ../src/backend/tcop/pquery.c:1315 [01:13:31.579] pstmt = 0x5573a0d76740 [01:13:31.579] stmtlist_item__state = [01:13:31.579] active_snapshot_set = false [01:13:31.579] stmtlist_item = 0x5573a0d776b0 [01:13:31.579] #17 0x000055739f6d7506 in PortalRun (portal=portal@entry=0x5573a0df6e90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5573a0d776e8, altdest=altdest@entry=0x5573a0d776e8, qc=0x7ffc8df19730) at ../src/backend/tcop/pquery.c:791 [01:13:31.579] _save_exception_stack = 0x7ffc8df197e0 [01:13:31.579] _save_context_stack = 0x0 [01:13:31.579] _local_sigjmp_buf = {{__jmpbuf = {0, -8202719484031480582, 93955108597392, 93955108071176, 93955108597392, 93955108071104, -2651410326537319174, -8202627898056979206}, __mask_was_saved = 0, __saved_mask = {__val = {93955087267415, 93955108067408, 112, 4, 93955087271832, 2381420223, 4, 93955108071104, 112, 73, 93955108597392, 93955108071176, 93955108071152, 93955108071104, 93955087359035, 1}}}} [01:13:31.579] _do_rethrow = [01:13:31.579] result = [01:13:31.579] nprocessed = [01:13:31.579] saveTopTransactionResourceOwner = 0x5573a0db6350 [01:13:31.579] saveTopTransactionContext = 0x5573a0e092c0 [01:13:31.579] saveActivePortal = 0x0 [01:13:31.579] saveResourceOwner = 0x5573a0db6350 [01:13:31.579] savePortalContext = 0x0 [01:13:31.579] saveMemoryContext = 0x5573a0e092c0 [01:13:31.579] __func__ = "PortalRun" [01:13:31.579] #18 0x000055739f6d0c9b in exec_simple_query (query_string=query_string@entry=0x5573a0d75950 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1274 [01:13:31.579] cmdtaglen = 24 [01:13:31.579] snapshot_set = [01:13:31.579] per_parsetree_context = 0x0 [01:13:31.579] plantree_list = 0x5573a0d77698 [01:13:31.579] parsetree = 0x5573a0d766c0 [01:13:31.579] commandTag = [01:13:31.579] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:13:31.579] querytree_list = [01:13:31.579] portal = 0x5573a0df6e90 [01:13:31.579] receiver = 0x5573a0d776e8 [01:13:31.579] format = 0 [01:13:31.579] cmdtagname = [01:13:31.579] parsetree_item__state = [01:13:31.579] dest = DestRemote [01:13:31.579] oldcontext = 0x5573a0e092c0 [01:13:31.579] parsetree_list = 0x5573a0d766f0 [01:13:31.579] parsetree_item = 0x5573a0d76708 [01:13:31.579] save_log_statement_stats = false [01:13:31.579] was_logged = true [01:13:31.579] use_implicit_block = false [01:13:31.579] msec_str = "\220\231\361\215\374\177\000\000X%\230\237sU\000\000\300\227\361\215\374\177\000\000G\000\000\000\000\000\000" [01:13:31.579] __func__ = "exec_simple_query" [01:13:31.579] #19 0x000055739f6d367b in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4679 [01:13:31.579] query_string = 0x5573a0d75950 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:13:31.579] firstchar = [01:13:31.579] input_message = {data = 0x5573a0d75950 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:13:31.579] local_sigjmp_buf = {{__jmpbuf = {93955099559416, -8202718400058700550, 4, 140722689907088, 140722689907232, 140722689907236, -2651410326608622342, -8202627900036821766}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 93955108317248, 0, 168, 93955087271934, 0, 10, 2, 93955099559424, 93955107798512, 93955099553496, 140722689907088, 140722689907232, 140722689907236}}}} [01:13:31.579] send_ready_for_query = false [01:13:31.579] idle_in_transaction_timeout_enabled = false [01:13:31.579] idle_session_timeout_enabled = false [01:13:31.579] __func__ = "PostgresMain" [01:13:31.579] #20 0x000055739f6c9fc9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:106 [01:13:31.579] bsdata = [01:13:31.579] #21 0x000055739f58344a in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc8df1993c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc8df19990) at ../src/backend/postmaster/launch_backend.c:269 [01:13:31.579] pid = [01:13:31.579] #22 0x000055739f5896bc in BackendStartup (client_sock=client_sock@entry=0x7ffc8df19990) at ../src/backend/postmaster/postmaster.c:3593 [01:13:31.579] bn = 0x5573a0da2508 [01:13:31.579] pid = [01:13:31.579] startup_data = {canAcceptConnections = CAC_OK} [01:13:31.579] __func__ = "BackendStartup" [01:13:31.579] #23 0x000055739f589c66 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [01:13:31.579] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "C\212\270\177\000\000\240\377\233\213\270\177\000\0008\232\361\215\374\177\000\0004\232\361\215\374\177", '\000' , "\236\211u\236sU\000\000\300vq\236sU\000\000\000\233\361\215\374\177\000\000\370\232\361\215\374\177\000\000\225[\362\001\000\000\000\000p\371٠sU\000\000,", '\000' , "sU\000\000\276\210u\236sU\000", __ss_align = 140430597887592}, salen = 2}} [01:13:31.579] i = 0 [01:13:31.579] now = [01:13:31.579] last_lockfile_recheck_time = 1722042614 [01:13:31.579] last_touch_time = 1722042614 [01:13:31.579] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55739e75899e}, {pos = -1947789720, events = 32696, fd = -1975691728, user_data = 0x7fb88be712e0}, {pos = 2090263927, events = 0, fd = -1913545856, user_data = 0x7fb88be47a48}, {pos = 15, events = 0, fd = -1975691728, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fb88be712e0}, {pos = -1913545992, events = 32764, fd = -1913545984, user_data = 0x7fb88be71668}, {pos = 0, events = 0, fd = -1596491888, user_data = 0x55739f9ede3c }, {pos = 32768, events = 0, fd = 1, user_data = 0x5573a0d76470}, {pos = -1, events = 0, fd = -1975328768, user_data = 0x7fb88b9bffa0}, {pos = -1596321272, events = 21875, fd = -1596321560, user_data = 0x5573a0da5791}, {pos = -1947935042, events = 32696, fd = 1, user_data = 0x7fb88be712e0}, {pos = 439, events = 0, fd = -1611915848, user_data = 0x0}, {pos = 1, events = 0, fd = -1596491888, user_data = 0x7fb88be4debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb88a42e000}, {pos = -1974522432, events = 32696, fd = 16, user_data = 0x7ffc8df19f60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1947926102, events = 32696, fd = 0, user_data = 0x7fb88a4aed14 }, {pos = 0, events = 0, fd = -1605065824, user_data = 0x2}, {pos = 7, events = 0, fd = -1596752240, user_data = 0x55739f6657e8 }, {pos = -1596282789, events = 21875, fd = -1620667382, user_data = 0x7367702f65736162}, {pos = 8096, events = 196607, fd = -1596491888, user_data = 0x7fb88be4debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb88a4364a8}, {pos = -1974767651, events = 32696, fd = -1605016352, user_data = 0x5573a0daa800}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -1973478304, events = 32696, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, 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 = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = -1960299200, events = 32696, fd = -1960297856, 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 = -1596307568, user_data = 0x7fb88a4b582e}, {pos = -1973495328, events = 32696, fd = -1974857362, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xf407e3ff38002700}, {pos = -1973492256, events = 32696, fd = -328, user_data = 0x0}, {pos = -1596321880, events = 21875, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1596322080, events = 21875, fd = 3, user_data = 0x0}, {pos = 31866, events = 0, fd = -328, user_data = 0x0}, {pos = -1596491888, events = 21875, fd = -1974521901, user_data = 0x7ffc8df1a018}, {pos = -1617216565, events = 21875, fd = -1605007952, user_data = 0x55739f9a2688 }, {pos = -1596322080, events = 21875, fd = -1596499888, user_data = 0x5573a0da0ee0}, {pos = -1974773714, events = 32696, fd = 0, user_data = 0x55739f9b42f2 }, {pos = -1596322080, events = 1, fd = -1617214405, user_data = 0x5573a0d75850}, {pos = 939534080, events = 4094157823, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1974850895, user_data = 0x7fb88a4a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 939534080, user_data = 0x5573a0d4cf80}, {pos = 939534080, events = 4094157823, fd = 11, user_data = 0xf407e3ff38002700}, {pos = 0, events = 0, fd = -1975143879, user_data = 0x1}, {pos = -1621610122, events = 21875, fd = 4194304, user_data = 0x55739f9a251c }, {pos = -1596665984, events = 21875, fd = -1596499888, user_data = 0x5573a0d4cf80}, {pos = 1, events = 0, fd = 0, user_data = 0x55739f9b42f2 }, {pos = -1596665984, events = 21875, fd = -1617214405, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55739f3b96d9 }, {pos = 0, events = 0, fd = -1623463389, user_data = 0xb}, {pos = -1621588463, events = 21875, fd = 0, user_data = 0x0}} [01:13:31.580] nevents = 1 [01:13:31.580] __func__ = "ServerLoop" [01:13:31.580] #24 0x000055739f58b671 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5573a0d33cf0) at ../src/backend/postmaster/postmaster.c:1372 [01:13:31.580] opt = [01:13:31.580] status = [01:13:31.580] userDoption = [01:13:31.580] listen_addr_saved = false [01:13:31.580] output_config_variable = [01:13:31.580] __func__ = "PostmasterMain" [01:13:31.580] #25 0x000055739f3c9af7 in main (argc=4, argv=0x5573a0d33cf0) at ../src/backend/main/main.c:197 [01:13:31.580] do_check_root = [01:13:31.614] -e [01:13:31.614] [01:13:31.614] [01:13:31.680] dumping /tmp/cores/postgres-6-28775.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [01:13:31.956] [New LWP 28775] [01:13:31.956] [01:13:31.956] This GDB supports auto-downloading debuginfo from the following URLs: [01:13:31.956] [01:13:31.956] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:13:31.956] Debuginfod has been disabled. [01:13:31.956] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:13:32.066] [Thread debugging using libthread_db enabled] [01:13:32.066] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:13:32.066] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [01:13:32.066] Program terminated with signal SIGABRT, Aborted. [01:13:32.066] #0 0x00007fcea8ca9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:32.937] [01:13:32.937] Thread 1 (Thread 0x7fcea9436f00 (LWP 28775)): [01:13:32.937] #0 0x00007fcea8ca9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:32.937] No symbol table info available. [01:13:32.937] #1 0x00007fcea8c5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:32.937] No symbol table info available. [01:13:32.937] #2 0x00007fcea8c45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:32.937] No symbol table info available. [01:13:32.937] #3 0x0000560d5d135d2d in ExceptionalCondition (conditionName=conditionName@entry=0x560d5d3a270a "queryDesc->sourceText != NULL", fileName=fileName@entry=0x560d5d3a1c70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=196) at ../src/backend/utils/error/assert.c:66 [01:13:32.937] No locals. [01:13:32.937] #4 0x0000560d5cac99b1 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x560d5eef7fb0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:196 [01:13:32.937] estate = 0x560d5ee6dd00 [01:13:32.937] oldcontext = 0x560d5ef3e7d0 [01:13:32.937] __func__ = "standard_ExecutorStart" [01:13:32.937] #5 0x0000560d5cac9b8d in ExecutorStart (queryDesc=queryDesc@entry=0x560d5eef7fb0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:137 [01:13:32.937] No locals. [01:13:32.937] #6 0x0000560d5c9efd75 in refresh_matview_datafill (dest=0x560d5ef0a268, query=, query@entry=0x560d5eeb5eb0, queryString=queryString@entry=0x0) at ../src/backend/commands/matview.c:429 [01:13:32.937] rewritten = [01:13:32.937] plan = 0x560d5eef5b40 [01:13:32.937] queryDesc = 0x560d5eef7fb0 [01:13:32.937] copied_query = [01:13:32.937] processed = [01:13:32.937] __func__ = "refresh_matview_datafill" [01:13:32.937] #7 0x0000560d5c9f20a5 in RefreshMatViewByOid (matviewOid=27358, skipData=, concurrent=, queryString=queryString@entry=0x0, params=params@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:321 [01:13:32.937] matviewRel = 0x7fce9d2ce5c8 [01:13:32.937] rule = [01:13:32.937] actions = [01:13:32.937] dataQuery = 0x560d5eeb5eb0 [01:13:32.937] tableSpace = [01:13:32.937] relowner = 10 [01:13:32.937] OIDNewHeap = 27365 [01:13:32.937] dest = [01:13:32.937] processed = 0 [01:13:32.937] relpersistence = 112 'p' [01:13:32.937] save_userid = 10 [01:13:32.937] save_sec_context = 0 [01:13:32.937] save_nestlevel = 2 [01:13:32.937] address = {classId = 1593043424, objectId = 22029, objectSubId = 0} [01:13:32.937] __func__ = "RefreshMatViewByOid" [01:13:32.937] #8 0x0000560d5c9f21dc in ExecRefreshMatView (stmt=0x560d5ef0b2f8, queryString=queryString@entry=0x0, params=params@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:13:32.937] matviewOid = [01:13:32.937] lockmode = [01:13:32.937] #9 0x0000560d5c9a94bb in ExecCreateTableAs (pstate=pstate@entry=0x560d5ef3e8d0, stmt=stmt@entry=0x560d5ed9a6e0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc11b0cf40) at ../src/backend/commands/createas.c:353 [01:13:32.937] refresh = [01:13:32.937] query = 0x560d5ed9a8a0 [01:13:32.937] into = 0x560d5ed9a438 [01:13:32.937] is_matview = true [01:13:32.937] do_refresh = false [01:13:32.937] dest = [01:13:32.937] address = {classId = 1259, objectId = 27358, objectSubId = 0} [01:13:32.937] rewritten = [01:13:32.937] plan = [01:13:32.937] queryDesc = [01:13:32.937] __func__ = "ExecCreateTableAs" [01:13:32.937] #10 0x0000560d5ceb599d in ProcessUtilitySlow (pstate=pstate@entry=0x560d5ef3e8d0, pstmt=pstmt@entry=0x560d5ed9a790, queryString=queryString@entry=0x560d5ed999a0 "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=0x560d5ed9b1c8, qc=0x7ffc11b0cf40) at ../src/backend/tcop/utility.c:1675 [01:13:32.937] _save_exception_stack = 0x7ffc11b0ce00 [01:13:32.937] _save_context_stack = 0x0 [01:13:32.937] _local_sigjmp_buf = {{__jmpbuf = {0, -2762458858159803466, 94615425885920, 0, 94615425882528, 0, -8481588032755928138, -2762463418422856778}, __mask_was_saved = 0, __saved_mask = {__val = {140525385441664, 10619, 94615392924171, 1, 4294977915, 140525385441664, 94615392914472, 1, 45609849906872, 1, 10619, 140525385441664, 140525385441664, 1, 94615392924518, 94615426754232}}}} [01:13:32.937] _do_rethrow = false [01:13:32.937] parsetree = 0x560d5ed9a6e0 [01:13:32.937] isTopLevel = true [01:13:32.937] isCompleteQuery = true [01:13:32.937] needCleanup = false [01:13:32.937] commandCollected = false [01:13:32.937] address = {classId = 22029, objectId = 1591322336, objectSubId = 22029} [01:13:32.937] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:13:32.937] __func__ = "ProcessUtilitySlow" [01:13:32.937] #11 0x0000560d5ceb3fc7 in standard_ProcessUtility (pstmt=0x560d5ed9a790, queryString=0x560d5ed999a0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x560d5ed9b1c8, qc=0x7ffc11b0cf40) at ../src/backend/tcop/utility.c:1067 [01:13:32.937] parsetree = 0x560d5ed9a6e0 [01:13:32.937] isTopLevel = true [01:13:32.937] isAtomicContext = false [01:13:32.937] pstate = 0x560d5ef3e8d0 [01:13:32.937] readonly_flags = [01:13:32.937] __func__ = "standard_ProcessUtility" [01:13:32.937] #12 0x0000560d5ceb4122 in ProcessUtility (pstmt=pstmt@entry=0x560d5ed9a790, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x560d5ed9b1c8, qc=0x7ffc11b0cf40) at ../src/backend/tcop/utility.c:523 [01:13:32.937] No locals. [01:13:32.937] #13 0x0000560d5ceaf98e in PortalRunUtility (portal=portal@entry=0x560d5ee1bf40, pstmt=pstmt@entry=0x560d5ed9a790, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560d5ed9b1c8, qc=qc@entry=0x7ffc11b0cf40) at ../src/backend/tcop/pquery.c:1158 [01:13:32.937] No locals. [01:13:32.937] #14 0x0000560d5ceaff33 in PortalRunMulti (portal=portal@entry=0x560d5ee1bf40, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560d5ed9b1c8, altdest=altdest@entry=0x560d5ed9b1c8, qc=qc@entry=0x7ffc11b0cf40) at ../src/backend/tcop/pquery.c:1315 [01:13:32.937] pstmt = 0x560d5ed9a790 [01:13:32.937] stmtlist_item__state = [01:13:32.937] active_snapshot_set = false [01:13:32.937] stmtlist_item = 0x560d5ed9b190 [01:13:32.937] #15 0x0000560d5ceb0506 in PortalRun (portal=portal@entry=0x560d5ee1bf40, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x560d5ed9b1c8, altdest=altdest@entry=0x560d5ed9b1c8, qc=0x7ffc11b0cf40) at ../src/backend/tcop/pquery.c:791 [01:13:32.937] _save_exception_stack = 0x7ffc11b0cff0 [01:13:32.937] _save_context_stack = 0x0 [01:13:32.937] _local_sigjmp_buf = {{__jmpbuf = {0, -2762458858903243850, 94615426416448, 94615425886040, 94615426416448, 94615425885968, -8481588032615418954, -2762463416214162506}, __mask_was_saved = 0, __saved_mask = {__val = {94615396386391, 94615425882272, 112, 4, 94615396390808, 296799951, 4, 94615425885968, 112, 73, 94615426416448, 94615425886040, 94615425886016, 94615425885968, 94615396478011, 1}}}} [01:13:32.937] _do_rethrow = [01:13:32.937] result = [01:13:32.937] nprocessed = [01:13:32.937] saveTopTransactionResourceOwner = 0x560d5edd8bf8 [01:13:32.937] saveTopTransactionContext = 0x560d5ee2db50 [01:13:32.937] saveActivePortal = 0x0 [01:13:32.937] saveResourceOwner = 0x560d5edd8bf8 [01:13:32.937] savePortalContext = 0x0 [01:13:32.937] saveMemoryContext = 0x560d5ee2db50 [01:13:32.937] __func__ = "PortalRun" [01:13:32.937] #16 0x0000560d5cea9c9b in exec_simple_query (query_string=query_string@entry=0x560d5ed999a0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1274 [01:13:32.937] cmdtaglen = 24 [01:13:32.937] snapshot_set = [01:13:32.937] per_parsetree_context = 0x0 [01:13:32.937] plantree_list = 0x560d5ed9b178 [01:13:32.937] parsetree = 0x560d5ed9a710 [01:13:32.937] commandTag = [01:13:32.937] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:13:32.937] querytree_list = [01:13:32.937] portal = 0x560d5ee1bf40 [01:13:32.937] receiver = 0x560d5ed9b1c8 [01:13:32.937] format = 0 [01:13:32.937] cmdtagname = [01:13:32.937] parsetree_item__state = [01:13:32.937] dest = DestRemote [01:13:32.937] oldcontext = 0x560d5ee2db50 [01:13:32.937] parsetree_list = 0x560d5ed9a740 [01:13:32.937] parsetree_item = 0x560d5ed9a758 [01:13:32.937] save_log_statement_stats = false [01:13:32.937] was_logged = false [01:13:32.937] use_implicit_block = false [01:13:32.937] msec_str = "\240Ѱ\021\374\177\000\000X\265\025]\rV\000\000\320ϰ\021\374\177\000\000G\000\000\000\000\000\000" [01:13:32.937] __func__ = "exec_simple_query" [01:13:32.937] #17 0x0000560d5ceac67b in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4679 [01:13:32.937] query_string = 0x560d5ed999a0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:13:32.937] firstchar = [01:13:32.937] input_message = {data = 0x560d5ed999a0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:13:32.937] local_sigjmp_buf = {{__jmpbuf = {94615408678392, -2762465409543113802, 4, 140720605286816, 140720605286960, 140720605286964, -8481588032552504394, -2762463403027401802}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94615425613216, 15616, 94615408672472, 94615426137008, 140720605286960, 94615396390356, 0, 9, 2, 94615408678400, 94615425613216, 94615408672472, 140720605286816, 140720605286960, 140720605286964}}}} [01:13:32.937] send_ready_for_query = false [01:13:32.937] idle_in_transaction_timeout_enabled = false [01:13:32.937] idle_session_timeout_enabled = false [01:13:32.937] __func__ = "PostgresMain" [01:13:32.937] #18 0x0000560d5cea2fc9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:106 [01:13:32.937] bsdata = [01:13:32.937] #19 0x0000560d5cd5c44a in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc11b0d14c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc11b0d1a0) at ../src/backend/postmaster/launch_backend.c:269 [01:13:32.937] pid = [01:13:32.937] #20 0x0000560d5cd626bc in BackendStartup (client_sock=client_sock@entry=0x7ffc11b0d1a0) at ../src/backend/postmaster/postmaster.c:3593 [01:13:32.937] bn = 0x560d5edc20a8 [01:13:32.937] pid = [01:13:32.937] startup_data = {canAcceptConnections = CAC_OK} [01:13:32.937] __func__ = "BackendStartup" [01:13:32.937] #21 0x0000560d5cd62c66 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [01:13:32.937] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\260\021\374\177\000\0004Ұ\021\374\177", '\000' , "\236\031\363[\rV\000\000\300\006\357[\rV\000\000\000Ӱ\021\374\177\000\000\370Ұ\021\374\177\000\000\225[\362\001\000\000\000\000\240TD\251\316\177\000\000+", '\000' , "\276\030\363[\rV\000\000hfc\252\316\177\000\0000VD\251\316\177\000", __ss_align = 140525598630624}, salen = 2}} [01:13:32.937] i = 0 [01:13:32.937] now = [01:13:32.937] last_lockfile_recheck_time = 1722042577 [01:13:32.937] last_touch_time = 1722042577 [01:13:32.937] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1542658462, events = 22029, fd = -1436326296, user_data = 0x7fcea9445630}, {pos = -1436327200, events = 32718, fd = 2090263927, user_data = 0x7ffc11b0d380}, {pos = -1436497336, events = 32718, fd = 15, user_data = 0x7fcea9445630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1436327200, events = 32718, fd = 296801016, user_data = 0x7ffc11b0d300}, {pos = -1436326296, events = 32718, fd = 0, user_data = 0x560d5ed99a60}, {pos = -1463059974, events = 32718, fd = 1591319136, user_data = 0x560d00000001}, {pos = 32768, events = 0, fd = -1, user_data = 0x7fcea8c2e000}, {pos = -1441247328, events = 32718, fd = 1591502392, user_data = 0x560d5edc6518}, {pos = 1591510833, events = 22029, fd = -1436471618, user_data = 0x1}, {pos = -1436327200, events = 32718, fd = 439, user_data = 0x560d5d69adb8 }, {pos = 0, events = 0, fd = 1, user_data = 0x560d5ed99a60}, {pos = -1436471618, events = 32718, fd = 1, user_data = 0x0}, {pos = -1463623680, events = 32718, fd = -1462817344, user_data = 0x10}, {pos = 296802160, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1436462678, user_data = 0x0}, {pos = -1463096044, events = 32718, fd = 0, user_data = 0x560d5dd233a0 }, {pos = 2, events = 0, fd = 7, user_data = 0x560d5ed5be40}, {pos = 1558435940, events = 22029, fd = 1591528304, user_data = 0x560d5ce3e7e8 }, {pos = 1591528395, events = 22029, fd = 8096, user_data = 0x7367702f65736162}, {pos = 1952410737, events = 28781, fd = 1, user_data = 0x0}, {pos = -1463589720, events = 32718, fd = -1463170944, user_data = 0x438}, {pos = -1463062563, events = 32718, fd = 2, user_data = 0x560d5edc5300}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -1461773216, events = 32718, 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 = 0x764679412d737365}, {pos = 168446296, events = 824188960, fd = 822763892, user_data = 0x30340a3737353234}, {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 = 1561822807, events = 22029, fd = 1591504672, user_data = 0x7fcea8cb56db}, {pos = -1461790240, events = 32718, fd = -1463152274, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x8f85830e22af7400}, {pos = -1461787168, events = 32718, 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 = 1591501784, user_data = 0x560d5d178f1a }, {pos = 1591501584, events = 22029, fd = 3, user_data = 0x0}, {pos = 24924, events = 0, fd = -328, user_data = 0x0}, {pos = 1591319136, events = 22029, fd = -1462816813, user_data = 0x7ffc11b0d828}, {pos = 1561906123, events = 22029, fd = 1574114736, user_data = 0x560d5d17b688 }, {pos = 1591501584, events = 22029, fd = 1591318688, user_data = 0x560d5edc6310}, {pos = -1463068626, events = 32718, fd = 0, user_data = 0x560d5d18d2f2 }, {pos = 1591501584, events = 1, fd = 1561908283, user_data = 0x560d5ed998a0}, {pos = 581923840, events = 2407891726, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1463145807, user_data = 0x7fcea8ca14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 581923840, user_data = 0x560d5ed70fd0}, {pos = 581923840, events = 2407891726, fd = 11, user_data = 0x8f85830e22af7400}, {pos = 0, events = 0, fd = -1463438791, user_data = 0x1}, {pos = 1557512566, events = 22029, fd = 4194304, user_data = 0x560d5d17b51c }, {pos = 1591152592, events = 22029, fd = 1591318688, user_data = 0x560d5ed70fd0}, {pos = 1, events = 0, fd = 0, user_data = 0x560d5d18d2f2 }, {pos = 1591152592, events = 22029, fd = 1561908283, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x560d5cb926d9 }, {pos = 0, events = 0, fd = 1555659299, user_data = 0xb}, {pos = 1557534225, events = 22029, fd = 0, user_data = 0x0}} [01:13:32.937] nevents = 1 [01:13:32.937] __func__ = "ServerLoop" [01:13:32.937] #22 0x0000560d5cd64671 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x560d5ed57d00) at ../src/backend/postmaster/postmaster.c:1372 [01:13:32.937] opt = [01:13:32.937] status = [01:13:32.937] userDoption = [01:13:32.937] listen_addr_saved = false [01:13:32.937] output_config_variable = [01:13:32.937] __func__ = "PostmasterMain" [01:13:32.937] #23 0x0000560d5cba2af7 in main (argc=8, argv=0x560d5ed57d00) at ../src/backend/main/main.c:197 [01:13:32.937] do_check_root = [01:13:32.972] -e [01:13:32.972] [01:13:32.972] [01:13:33.036] dumping /tmp/cores/postgres-6-29438.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:13:33.296] [New LWP 29438] [01:13:33.296] [01:13:33.296] This GDB supports auto-downloading debuginfo from the following URLs: [01:13:33.296] [01:13:33.296] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:13:33.296] Debuginfod has been disabled. [01:13:33.296] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:13:33.406] [Thread debugging using libthread_db enabled] [01:13:33.406] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:13:33.406] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [01:13:33.406] Program terminated with signal SIGABRT, Aborted. [01:13:33.406] #0 0x00007f8ddd4a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:34.295] [01:13:34.295] Thread 1 (Thread 0x7f8ddd3eaf00 (LWP 29438)): [01:13:34.295] #0 0x00007f8ddd4a9e2c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:34.295] No symbol table info available. [01:13:34.295] #1 0x00007f8ddd45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:34.295] No symbol table info available. [01:13:34.295] #2 0x00007f8ddd445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:13:34.295] No symbol table info available. [01:13:34.295] #3 0x0000560022f24d2d in ExceptionalCondition (conditionName=conditionName@entry=0x56002319170a "queryDesc->sourceText != NULL", fileName=fileName@entry=0x560023190c70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=196) at ../src/backend/utils/error/assert.c:66 [01:13:34.295] No locals. [01:13:34.295] #4 0x00005600228b89b1 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x560025353790, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:196 [01:13:34.295] estate = 0x5600252d1ac0 [01:13:34.295] oldcontext = 0x560025357020 [01:13:34.295] __func__ = "standard_ExecutorStart" [01:13:34.295] #5 0x00005600228b8b8d in ExecutorStart (queryDesc=queryDesc@entry=0x560025353790, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:137 [01:13:34.295] No locals. [01:13:34.295] #6 0x00005600227ded75 in refresh_matview_datafill (dest=0x5600252e9618, query=, query@entry=0x560025342910, queryString=queryString@entry=0x0) at ../src/backend/commands/matview.c:429 [01:13:34.295] rewritten = [01:13:34.295] plan = 0x560025382c30 [01:13:34.295] queryDesc = 0x560025353790 [01:13:34.295] copied_query = [01:13:34.295] processed = [01:13:34.295] __func__ = "refresh_matview_datafill" [01:13:34.295] #7 0x00005600227e10a5 in RefreshMatViewByOid (matviewOid=27465, skipData=, concurrent=, queryString=queryString@entry=0x0, params=params@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:321 [01:13:34.295] matviewRel = 0x7f8dd1dc95c8 [01:13:34.295] rule = [01:13:34.295] actions = [01:13:34.295] dataQuery = 0x560025342910 [01:13:34.295] tableSpace = [01:13:34.295] relowner = 10 [01:13:34.295] OIDNewHeap = 27472 [01:13:34.295] dest = [01:13:34.295] processed = 0 [01:13:34.295] relpersistence = 112 'p' [01:13:34.295] save_userid = 10 [01:13:34.295] save_sec_context = 0 [01:13:34.295] save_nestlevel = 2 [01:13:34.295] address = {classId = 624259632, objectId = 22016, objectSubId = 0} [01:13:34.295] __func__ = "RefreshMatViewByOid" [01:13:34.295] #8 0x00005600227e11dc in ExecRefreshMatView (stmt=0x5600252ea6a8, queryString=queryString@entry=0x0, params=params@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:13:34.295] matviewOid = [01:13:34.295] lockmode = [01:13:34.295] #9 0x00005600227984bb in ExecCreateTableAs (pstate=pstate@entry=0x560025357120, stmt=stmt@entry=0x5600251ac670, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcbdc9dd30) at ../src/backend/commands/createas.c:353 [01:13:34.295] refresh = [01:13:34.295] query = 0x5600251ac830 [01:13:34.295] into = 0x5600251ac3c8 [01:13:34.295] is_matview = true [01:13:34.295] do_refresh = false [01:13:34.295] dest = [01:13:34.295] address = {classId = 1259, objectId = 27465, objectSubId = 0} [01:13:34.295] rewritten = [01:13:34.295] plan = [01:13:34.295] queryDesc = [01:13:34.295] __func__ = "ExecCreateTableAs" [01:13:34.295] #10 0x0000560022ca499d in ProcessUtilitySlow (pstate=pstate@entry=0x560025357120, pstmt=pstmt@entry=0x5600251ac720, queryString=queryString@entry=0x5600251ab930 "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=0x5600251ad158, qc=0x7ffcbdc9dd30) at ../src/backend/tcop/utility.c:1675 [01:13:34.295] _save_exception_stack = 0x7ffcbdc9dbf0 [01:13:34.295] _save_context_stack = 0x0 [01:13:34.295] _local_sigjmp_buf = {{__jmpbuf = {0, -2877241522801727978, 94558622500464, 0, 94558622497072, 0, -8365210141619509738, -2877250725411150314}, __mask_was_saved = 0, __saved_mask = {__val = {140247093788224, 15410, 94558583104011, 1, 4294982706, 140247093788224, 94558586881466, 140247278988728, 94558622497072, 94558589173734, 94558598849634, 94558598849760, 140723492608564, 94558589365208, 94558598849649, 94558598849760}}}} [01:13:34.295] _do_rethrow = false [01:13:34.295] parsetree = 0x5600251ac670 [01:13:34.295] isTopLevel = true [01:13:34.295] isCompleteQuery = true [01:13:34.295] needCleanup = false [01:13:34.295] commandCollected = false [01:13:34.295] address = {classId = 22016, objectId = 622511728, objectSubId = 22016} [01:13:34.295] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:13:34.295] __func__ = "ProcessUtilitySlow" [01:13:34.295] #11 0x0000560022ca2fc7 in standard_ProcessUtility (pstmt=0x5600251ac720, queryString=0x5600251ab930 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5600251ad158, qc=0x7ffcbdc9dd30) at ../src/backend/tcop/utility.c:1067 [01:13:34.295] parsetree = 0x5600251ac670 [01:13:34.295] isTopLevel = true [01:13:34.295] isAtomicContext = false [01:13:34.295] pstate = 0x560025357120 [01:13:34.295] readonly_flags = [01:13:34.295] __func__ = "standard_ProcessUtility" [01:13:34.295] #12 0x0000560022ca3122 in ProcessUtility (pstmt=pstmt@entry=0x5600251ac720, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5600251ad158, qc=0x7ffcbdc9dd30) at ../src/backend/tcop/utility.c:523 [01:13:34.295] No locals. [01:13:34.295] #13 0x0000560022c9e98e in PortalRunUtility (portal=portal@entry=0x56002522e580, pstmt=pstmt@entry=0x5600251ac720, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5600251ad158, qc=qc@entry=0x7ffcbdc9dd30) at ../src/backend/tcop/pquery.c:1158 [01:13:34.295] No locals. [01:13:34.295] #14 0x0000560022c9ef33 in PortalRunMulti (portal=portal@entry=0x56002522e580, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5600251ad158, altdest=altdest@entry=0x5600251ad158, qc=qc@entry=0x7ffcbdc9dd30) at ../src/backend/tcop/pquery.c:1315 [01:13:34.295] pstmt = 0x5600251ac720 [01:13:34.295] stmtlist_item__state = [01:13:34.295] active_snapshot_set = false [01:13:34.295] stmtlist_item = 0x5600251ad120 [01:13:34.295] #15 0x0000560022c9f506 in PortalRun (portal=portal@entry=0x56002522e580, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5600251ad158, altdest=altdest@entry=0x5600251ad158, qc=0x7ffcbdc9dd30) at ../src/backend/tcop/pquery.c:791 [01:13:34.295] _save_exception_stack = 0x7ffcbdc9dde0 [01:13:34.295] _save_context_stack = 0x0 [01:13:34.295] _local_sigjmp_buf = {{__jmpbuf = {0, -2877241522463037930, 94558623032704, 94558622500584, 94558623032704, 94558622500512, -8365210141487389162, -2877250740373674474}, __mask_was_saved = 0, __saved_mask = {__val = {94558586566231, 94558622496816, 112, 4, 94558586570648, 3184123071, 4, 94558622500512, 112, 73, 94558623032704, 94558622500584, 94558622500560, 94558622500512, 94558586657851, 1}}}} [01:13:34.295] _do_rethrow = [01:13:34.295] result = [01:13:34.295] nprocessed = [01:13:34.295] saveTopTransactionResourceOwner = 0x5600251eb738 [01:13:34.295] saveTopTransactionContext = 0x56002523f560 [01:13:34.295] saveActivePortal = 0x0 [01:13:34.295] saveResourceOwner = 0x5600251eb738 [01:13:34.295] savePortalContext = 0x0 [01:13:34.295] saveMemoryContext = 0x56002523f560 [01:13:34.295] __func__ = "PortalRun" [01:13:34.295] #16 0x0000560022c98c9b in exec_simple_query (query_string=query_string@entry=0x5600251ab930 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1274 [01:13:34.295] cmdtaglen = 24 [01:13:34.295] snapshot_set = [01:13:34.295] per_parsetree_context = 0x0 [01:13:34.295] plantree_list = 0x5600251ad108 [01:13:34.295] parsetree = 0x5600251ac6a0 [01:13:34.295] commandTag = [01:13:34.295] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:13:34.295] querytree_list = [01:13:34.295] portal = 0x56002522e580 [01:13:34.295] receiver = 0x5600251ad158 [01:13:34.295] format = 0 [01:13:34.295] cmdtagname = [01:13:34.295] parsetree_item__state = [01:13:34.295] dest = DestRemote [01:13:34.295] oldcontext = 0x56002523f560 [01:13:34.295] parsetree_list = 0x5600251ac6d0 [01:13:34.295] parsetree_item = 0x5600251ac6e8 [01:13:34.295] save_log_statement_stats = false [01:13:34.295] was_logged = true [01:13:34.295] use_implicit_block = false [01:13:34.295] msec_str = "\220\337ɽ\374\177\000\000X\245\364\"\000V\000\000\300\335ɽ\374\177\000\000G\000\000\000\000\000\000" [01:13:34.295] __func__ = "exec_simple_query" [01:13:34.295] #17 0x0000560022c9b67b in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4679 [01:13:34.295] query_string = 0x5600251ab930 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:13:34.295] firstchar = [01:13:34.295] input_message = {data = 0x5600251ab930 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:13:34.295] local_sigjmp_buf = {{__jmpbuf = {94558598858232, -2877253404799392234, 4, 140723492609936, 140723492610080, 140723492610084, -8365210141416085994, -2877250738460940778}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94558622227888, 14336, 94558598852312, 94558622754544, 140723492610080, 94558586570196, 0, 9, 2, 94558598858240, 94558622227888, 94558598852312, 140723492609936, 140723492610080, 140723492610084}}}} [01:13:34.295] send_ready_for_query = false [01:13:34.295] idle_in_transaction_timeout_enabled = false [01:13:34.295] idle_session_timeout_enabled = false [01:13:34.295] __func__ = "PostgresMain" [01:13:34.295] #18 0x0000560022c91fc9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:106 [01:13:34.295] bsdata = [01:13:34.295] #19 0x0000560022b4b44a in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffcbdc9df3c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcbdc9df90) at ../src/backend/postmaster/launch_backend.c:269 [01:13:34.295] pid = [01:13:34.295] #20 0x0000560022b516bc in BackendStartup (client_sock=client_sock@entry=0x7ffcbdc9df90) at ../src/backend/postmaster/postmaster.c:3593 [01:13:34.295] bn = 0x5600251e0c48 [01:13:34.295] pid = [01:13:34.295] startup_data = {canAcceptConnections = CAC_OK} [01:13:34.295] __func__ = "BackendStartup" [01:13:34.295] #21 0x0000560022b51c66 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [01:13:34.295] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "Cݍ\177\000\000\240\257\225ލ\177\000\0008\340ɽ\374\177\000\0004\340ɽ\374\177", '\000' , "\236\t\322!\000V\000\000\300\366\315!\000V\000\000\000\341ɽ\374\177\000\000\370\340ɽ\374\177\000\000\225[\362\001\000\000\000\000\240Ēލ\177\000\000+", '\000' , "V\000\000\276\b\322!\000V\000", __ss_align = 140247306389096}, salen = 2}} [01:13:34.295] i = 0 [01:13:34.295] now = [01:13:34.295] last_lockfile_recheck_time = 1722042579 [01:13:34.295] last_touch_time = 1722042579 [01:13:34.295] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x560021d2099e}, {pos = -555694488, events = 32653, fd = -560806352, user_data = 0x7f8ddee0c2e0}, {pos = 2090263927, events = 0, fd = -1110843008, user_data = 0x7f8ddede2a48}, {pos = 15, events = 0, fd = -560806352, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f8ddee0c2e0}, {pos = -1110843144, events = 32764, fd = -1110843136, user_data = 0x7f8ddee0c668}, {pos = 0, events = 0, fd = 622508360, user_data = 0x560022fb5e3c }, {pos = 32768, events = 0, fd = 1, user_data = 0x5600251ad6f0}, {pos = -1, events = 0, fd = -582819840, user_data = 0x7f8dde95afa0}, {pos = 622699112, events = 22016, fd = 622698824, user_data = 0x5600251d9f21}, {pos = -555839810, events = 32653, fd = 1, user_data = 0x7f8ddee0c2e0}, {pos = 439, events = 0, fd = 591961528, user_data = 0x0}, {pos = 1, events = 0, fd = 622508360, user_data = 0x7f8ddede8ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f8ddd42e000}, {pos = -582013504, events = 32653, fd = 16, user_data = 0x7ffcbdc9e560}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -555830870, events = 32653, fd = 0, user_data = 0x7f8ddd4aed14 }, {pos = 0, events = 0, fd = 598811552, user_data = 0x2}, {pos = 7, events = 0, fd = 622255696, user_data = 0x560022c2d7e8 }, {pos = 622716683, events = 22016, fd = 583209994, user_data = 0x7367702f65736162}, {pos = 8096, events = 196607, fd = 622508360, user_data = 0x7f8ddede8ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f8ddd4364a8}, {pos = -582259081, events = 32653, fd = 598861024, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -580969376, events = 32653, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, 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 = 4294967040, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 622672192, user_data = 0x7f8ddd4b56db}, {pos = -580986400, events = 32653, fd = -582348434, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xce7ccd7b409c9e00}, {pos = -580983328, events = 32653, fd = -328, user_data = 0x0}, {pos = 622698504, events = 22016, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 622698304, events = 22016, fd = 3, user_data = 0x0}, {pos = 25347, events = 0, fd = -328, user_data = 0x0}, {pos = 622508360, events = 22016, fd = -582012973, user_data = 0x7ffcbdc9e618}, {pos = 586660811, events = 22016, fd = 598869424, user_data = 0x560022f6a688 }, {pos = 622698304, events = 22016, fd = 622508080, user_data = 0x5600251d9f40}, {pos = -582265125, events = 32653, fd = 0, user_data = 0x560022f7c2f2 }, {pos = 622698304, events = 1, fd = 586662971, user_data = 0x5600251ab830}, {pos = 1084005888, events = 3464285563, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -582341967, user_data = 0x7f8ddd4a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1084005888, user_data = 0x560025182f60}, {pos = 1084005888, events = 3464285563, fd = 11, user_data = 0xce7ccd7b409c9e00}, {pos = 0, events = 0, fd = -582634951, user_data = 0x1}, {pos = 582267254, events = 22016, fd = 4194304, user_data = 0x560022f6a51c }, {pos = 622341984, events = 22016, fd = 622508080, user_data = 0x560025182f60}, {pos = 1, events = 0, fd = 0, user_data = 0x560022f7c2f2 }, {pos = 622341984, events = 22016, fd = 586662971, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5600229816d9 }, {pos = 0, events = 0, fd = 580413987, user_data = 0xb}, {pos = 582288913, events = 22016, fd = 0, user_data = 0x0}} [01:13:34.295] nevents = 1 [01:13:34.295] __func__ = "ServerLoop" [01:13:34.295] #22 0x0000560022b53671 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x560025169cc0) at ../src/backend/postmaster/postmaster.c:1372 [01:13:34.295] opt = [01:13:34.295] status = [01:13:34.295] userDoption = [01:13:34.295] listen_addr_saved = false [01:13:34.295] output_config_variable = [01:13:34.295] __func__ = "PostmasterMain" [01:13:34.295] #23 0x0000560022991af7 in main (argc=4, argv=0x560025169cc0) at ../src/backend/main/main.c:197 [01:13:34.295] do_check_root =