[03:30:15.959] src/tools/ci/cores_backtrace.sh linux /tmp/cores [03:30:16.155] dumping /tmp/cores/postgres-6-29322.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:30:16.403] [New LWP 29322] [03:30:16.403] [03:30:16.403] This GDB supports auto-downloading debuginfo from the following URLs: [03:30:16.403] [03:30:16.403] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:30:16.403] Debuginfod has been disabled. [03:30:16.403] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:30:16.529] [Thread debugging using libthread_db enabled] [03:30:16.529] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:30:16.529] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:30:16.529] Program terminated with signal SIGABRT, Aborted. [03:30:16.529] #0 0x00007fc80fea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:17.400] [03:30:17.400] Thread 1 (Thread 0x7fc810635f00 (LWP 29322)): [03:30:17.400] #0 0x00007fc80fea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:17.400] No symbol table info available. [03:30:17.400] #1 0x00007fc80fe5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:17.400] No symbol table info available. [03:30:17.400] #2 0x00007fc80fe45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:17.400] No symbol table info available. [03:30:17.400] #3 0x000055d554ec6ad6 in ExceptionalCondition (conditionName=conditionName@entry=0x55d55514395d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55d555142eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:30:17.400] No locals. [03:30:17.400] #4 0x000055d55483120f in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55d5827c11c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [03:30:17.400] estate = 0x55d5826f49b0 [03:30:17.400] oldcontext = 0x55d582740410 [03:30:17.400] __func__ = "standard_ExecutorStart" [03:30:17.400] #5 0x000055d5548313eb in ExecutorStart (queryDesc=queryDesc@entry=0x55d5827c11c0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [03:30:17.400] No locals. [03:30:17.400] #6 0x000055d5547506d7 in refresh_matview_datafill (dest=0x55d5827436e0, query=, query@entry=0x55d582776600, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:30:17.400] rewritten = [03:30:17.400] plan = 0x55d5827c0818 [03:30:17.400] queryDesc = 0x55d5827c11c0 [03:30:17.400] copied_query = [03:30:17.400] processed = [03:30:17.400] __func__ = "refresh_matview_datafill" [03:30:17.400] #7 0x000055d554752a31 in RefreshMatViewByOid (matviewOid=28591, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:30:17.400] dest = [03:30:17.400] matviewRel = 0x7fc80440c3f0 [03:30:17.400] rule = [03:30:17.400] actions = [03:30:17.400] dataQuery = 0x55d582776600 [03:30:17.400] tableSpace = [03:30:17.400] relowner = 10 [03:30:17.400] OIDNewHeap = 28606 [03:30:17.400] processed = 0 [03:30:17.400] relpersistence = 112 'p' [03:30:17.400] save_userid = 10 [03:30:17.400] save_sec_context = 0 [03:30:17.400] save_nestlevel = 2 [03:30:17.400] address = {classId = 0, objectId = 0, objectSubId = 0} [03:30:17.400] __func__ = "RefreshMatViewByOid" [03:30:17.400] #8 0x000055d554752b70 in ExecRefreshMatView (stmt=0x55d5827433b8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:30:17.400] matviewOid = [03:30:17.400] lockmode = [03:30:17.400] #9 0x000055d554708623 in ExecCreateTableAs (pstate=pstate@entry=0x55d582740510, stmt=stmt@entry=0x55d5825e77f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcb36e1560) at ../src/backend/commands/createas.c:351 [03:30:17.400] refresh = [03:30:17.400] query = 0x55d5825e79b0 [03:30:17.400] into = 0x55d5825e7548 [03:30:17.400] jstate = 0x0 [03:30:17.400] is_matview = true [03:30:17.400] do_refresh = false [03:30:17.400] dest = [03:30:17.400] address = {classId = 1259, objectId = 28591, objectSubId = 0} [03:30:17.400] __func__ = "ExecCreateTableAs" [03:30:17.400] #10 0x000055d554c35579 in ProcessUtilitySlow (pstate=pstate@entry=0x55d582740510, pstmt=pstmt@entry=0x55d5825e78a0, queryString=queryString@entry=0x55d5825e6ab0 "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=0x55d5825e82d8, qc=0x7ffcb36e1560) at ../src/backend/tcop/utility.c:1678 [03:30:17.400] _save_exception_stack = 0x7ffcb36e1440 [03:30:17.400] _save_context_stack = 0x0 [03:30:17.400] _local_sigjmp_buf = {{__jmpbuf = {0, 7970468799555540743, 94375503624176, 0, 94375503620784, 0, 4237510409939556103, 7970639196042139399}, __mask_was_saved = 0, __saved_mask = {__val = {28595, 0, 94374741454519, 71353328, 94375504730232, 0, 94374738236060, 0, 94374737896966, 140497190519168, 44650480009216, 140497049710948, 94374740923523, 10396, 94374737896966, 140497042032032}}}} [03:30:17.400] _do_rethrow = false [03:30:17.400] parsetree = 0x55d5825e77f0 [03:30:17.400] isTopLevel = true [03:30:17.400] isCompleteQuery = true [03:30:17.400] needCleanup = false [03:30:17.400] commandCollected = false [03:30:17.400] address = {classId = 21973, objectId = 2187229168, objectSubId = 21973} [03:30:17.400] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:30:17.400] __func__ = "ProcessUtilitySlow" [03:30:17.400] #11 0x000055d554c33b78 in standard_ProcessUtility (pstmt=0x55d5825e78a0, queryString=0x55d5825e6ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55d5825e82d8, qc=0x7ffcb36e1560) at ../src/backend/tcop/utility.c:1070 [03:30:17.400] parsetree = 0x55d5825e77f0 [03:30:17.400] isTopLevel = true [03:30:17.400] isAtomicContext = false [03:30:17.400] pstate = 0x55d582740510 [03:30:17.400] readonly_flags = [03:30:17.400] __func__ = "standard_ProcessUtility" [03:30:17.400] #12 0x000055d554c33cd3 in ProcessUtility (pstmt=pstmt@entry=0x55d5825e78a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55d5825e82d8, qc=0x7ffcb36e1560) at ../src/backend/tcop/utility.c:523 [03:30:17.400] No locals. [03:30:17.400] #13 0x000055d554c2f67f in PortalRunUtility (portal=portal@entry=0x55d58266bfc0, pstmt=pstmt@entry=0x55d5825e78a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d5825e82d8, qc=qc@entry=0x7ffcb36e1560) at ../src/backend/tcop/pquery.c:1152 [03:30:17.400] No locals. [03:30:17.400] #14 0x000055d554c2fc2a in PortalRunMulti (portal=portal@entry=0x55d58266bfc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d5825e82d8, altdest=altdest@entry=0x55d5825e82d8, qc=qc@entry=0x7ffcb36e1560) at ../src/backend/tcop/pquery.c:1309 [03:30:17.400] pstmt = 0x55d5825e78a0 [03:30:17.400] stmtlist_item__state = [03:30:17.400] active_snapshot_set = false [03:30:17.400] stmtlist_item = 0x55d5825e82a0 [03:30:17.400] #15 0x000055d554c30192 in PortalRun (portal=portal@entry=0x55d58266bfc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55d5825e82d8, altdest=altdest@entry=0x55d5825e82d8, qc=qc@entry=0x7ffcb36e1560) at ../src/backend/tcop/pquery.c:787 [03:30:17.400] _save_exception_stack = 0x7ffcb36e1610 [03:30:17.400] _save_context_stack = 0x0 [03:30:17.400] _local_sigjmp_buf = {{__jmpbuf = {0, 7970468800953292551, 94375504166848, 94375503624296, 94375503624272, 94375503624224, 4237510408995837703, 7970639195121358599}, __mask_was_saved = 0, __saved_mask = {__val = {94374741454519, 3010335983, 4, 94375503624224, 112, 73, 94375504166848, 94375503624296, 94375503624272, 94375503624224, 94374741541722, 1, 2, 73, 94374730787322, 0}}}} [03:30:17.400] _do_rethrow = [03:30:17.400] result = [03:30:17.400] nprocessed = [03:30:17.400] saveTopTransactionResourceOwner = 0x55d582629d88 [03:30:17.400] saveTopTransactionContext = 0x55d58267e3f0 [03:30:17.400] saveActivePortal = 0x0 [03:30:17.400] saveResourceOwner = 0x55d582629d88 [03:30:17.400] savePortalContext = 0x0 [03:30:17.400] saveMemoryContext = 0x55d58267e3f0 [03:30:17.400] __func__ = "PortalRun" [03:30:17.400] #16 0x000055d554c29628 in exec_simple_query (query_string=query_string@entry=0x55d5825e6ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [03:30:17.400] cmdtaglen = 24 [03:30:17.400] snapshot_set = [03:30:17.400] per_parsetree_context = 0x0 [03:30:17.400] plantree_list = 0x55d5825e8288 [03:30:17.400] parsetree = 0x55d5825e7820 [03:30:17.400] commandTag = [03:30:17.400] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:30:17.400] querytree_list = [03:30:17.400] portal = 0x55d58266bfc0 [03:30:17.400] receiver = 0x55d5825e82d8 [03:30:17.400] format = 0 [03:30:17.400] cmdtagname = [03:30:17.400] parsetree_item__state = [03:30:17.400] dest = DestRemote [03:30:17.400] oldcontext = 0x55d58267e3f0 [03:30:17.400] parsetree_list = 0x55d5825e7850 [03:30:17.400] parsetree_item = 0x55d5825e7868 [03:30:17.400] save_log_statement_stats = false [03:30:17.400] was_logged = false [03:30:17.400] use_implicit_block = false [03:30:17.400] msec_str = "\004\000\000\000\000\000\000\000\004\311\356T\325U\000\000\360\025n\263\374\177\000\000G\000\000\000\000\000\000" [03:30:17.400] __func__ = "exec_simple_query" [03:30:17.400] #17 0x000055d554c2c381 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [03:30:17.400] query_string = 0x55d5825e6ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:30:17.400] firstchar = [03:30:17.400] input_message = {data = 0x55d5825e6ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:30:17.400] local_sigjmp_buf = {{__jmpbuf = {94374754311352, 7970637904350779143, 140723318822764, 4, 6, 140723318822996, 4237510409062946567, 7970639191686092551}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94375503351248, 17408, 94374754305408, 94375503885616, 6, 94374741454067, 0, 10, 2, 94374754311360, 94375503351248, 94374754305408, 4, 6, 140723318822996}}}} [03:30:17.400] send_ready_for_query = false [03:30:17.400] idle_in_transaction_timeout_enabled = false [03:30:17.400] idle_session_timeout_enabled = false [03:30:17.400] __func__ = "PostgresMain" [03:30:17.400] #18 0x000055d554c223d7 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:30:17.400] bsdata = [03:30:17.400] #19 0x000055d554ad330a in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x7ffcb36e176c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcb36e17c0) at ../src/backend/postmaster/launch_backend.c:274 [03:30:17.400] pid = [03:30:17.400] #20 0x000055d554ad8505 in BackendStartup (client_sock=client_sock@entry=0x7ffcb36e17c0) at ../src/backend/postmaster/postmaster.c:3519 [03:30:17.400] bn = 0x55d58260f118 [03:30:17.400] pid = [03:30:17.400] startup_data = {canAcceptConnections = CAC_OK} [03:30:17.400] cac = [03:30:17.400] __func__ = "BackendStartup" [03:30:17.400] #21 0x000055d554ada5d5 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:30:17.400] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "}\021\310\177\000\000>\004\000\000\000\000\000\000\260\227\343\017\310\177\000\000\240_5\021\310\177\000\000x\030n\263\374\177\000\000t\030n\263\374\177", '\000' , "\233H\305S\325U\000\000\030(\301S\325U\000\000@\031n\263\374\177\000\0008\031n\263\374\177\000\000\225[\362\001\377\223\365ӠDd\020\310\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [03:30:17.400] i = 0 [03:30:17.400] now = [03:30:17.400] last_lockfile_recheck_time = 1738380284 [03:30:17.400] last_touch_time = 1738380284 [03:30:17.400] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -1284630144, user_data = 0x0}, {pos = 15, events = 0, fd = 1405438107, user_data = 0x7fc811807668}, {pos = 275007024, events = 32712, fd = 293630688, user_data = 0x7c96e577}, {pos = -1284630080, events = 32764, fd = 293460552, user_data = 0xf}, {pos = 275007024, events = 32712, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 293630688, user_data = 0x7ffcb36e1938}, {pos = -1284630208, events = 32764, fd = 293631592, user_data = 0x0}, {pos = -2107734112, events = 21973, fd = 267316581, user_data = 0x7ffcb36e1e53}, {pos = 1, events = 0, fd = -1284630208, user_data = 0xffffffff}, {pos = 266526752, events = 32712, fd = 288710560, user_data = 0x55d5826143f8}, {pos = -2107555112, events = 21973, fd = -2107555663, user_data = 0x7fc8117e3ebe}, {pos = 1, events = 0, fd = 293630688, user_data = 0x1aa}, {pos = 1430801744, events = 21973, fd = 0, user_data = 0xf9}, {pos = -2107741328, events = 21973, fd = 293486270, user_data = 0x1}, {pos = 0, events = 0, fd = 266526752, user_data = 0x7fc80fef2e40 }, {pos = 16, events = 0, fd = -1284629120, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fc8117e61ba}, {pos = 0, events = 0, fd = 267054500, user_data = 0x0}, {pos = 1437840576, events = 21973, fd = 2, user_data = 0x0}, {pos = -2107994512, events = 21973, fd = 1952410737, user_data = 0x160}, {pos = 1430801152, events = 21973, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -2107741328, events = 21973, fd = 293486270, user_data = 0x1}, {pos = 267087981, events = 32712, fd = 266560712, user_data = 0x55d5826194d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 268377184, events = 32712, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55d5825a8e70}, {pos = 267090570, events = 32712, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1802268751, fd = 168456761, user_data = 0x33383337310a6174}, {pos = 942813240, events = 808716852, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, 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 = 0x0}, {pos = 268360160, events = 32712, fd = 266998126, user_data = 0x100000400}, {pos = 7, events = 0, fd = -2107554592, user_data = 0xd3f593ff98736200}, {pos = 268363232, events = 32712, fd = -328, user_data = 0x0}, {pos = -2107555432, events = 21973, fd = 1024, user_data = 0x55d582614198}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 25316, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -2107741328, user_data = 0x7fc80fef3053 }, {pos = -2107555432, events = 21973, fd = 1024, user_data = 0x7ffcb36e1e48}, {pos = 1425138410, events = 21973, fd = 1437916272, user_data = 0x55d554f0cda7 }, {pos = -2107555632, events = 21973, fd = -2107741776, user_data = 0x55d5826140d0}, {pos = 267081918, events = 32712, fd = 0, user_data = 0x55d554f1ea11 }, {pos = -2107555632, events = 1, fd = 1425140570, user_data = 0x55d5825e69b0}, {pos = -1737268736, events = 3556086783, fd = 0, user_data = 0x7fc80fea2ab1}, {pos = 266999024, events = 32712, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2107994512, user_data = 0xd3f593ff98736200}, {pos = 0, events = 0, fd = -1737268736, user_data = 0xc}, {pos = -1737268736, events = 3556086783, fd = 0, user_data = 0x7fc80fe5b239 }, {pos = 250, events = 0, fd = 1420636167, user_data = 0x400000}, {pos = 0, events = 0, fd = -2107994512, user_data = 0x55d554f0cc3b }, {pos = -2107907872, events = 21973, fd = -2107741776, user_data = 0x55d5825be0e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55d554ecb440 }, {pos = 12, events = 0, fd = -2107564296, user_data = 0x55d582611ed8}, {pos = 1437841984, events = 21973, fd = 296, user_data = 0x55d554ad5821 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1420652532, events = 21973, fd = 1434219632, user_data = 0x55d5825e7388}} [03:30:17.400] nevents = 1 [03:30:17.400] __func__ = "ServerLoop" [03:30:17.400] #22 0x000055d554adbe34 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55d5825a4d30) at ../src/backend/postmaster/postmaster.c:1386 [03:30:17.400] opt = [03:30:17.400] status = [03:30:17.400] userDoption = [03:30:17.400] listen_addr_saved = false [03:30:17.400] output_config_variable = [03:30:17.400] __func__ = "PostmasterMain" [03:30:17.400] #23 0x000055d554910a0b in main (argc=8, argv=0x55d5825a4d30) at ../src/backend/main/main.c:230 [03:30:17.400] do_check_root = [03:30:17.400] dispatch_option = [03:30:17.433] -e [03:30:17.433] [03:30:17.433] [03:30:17.493] dumping /tmp/cores/postgres-3-32278.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:30:17.735] [New LWP 32278] [03:30:17.735] [03:30:17.735] This GDB supports auto-downloading debuginfo from the following URLs: [03:30:17.735] [03:30:17.735] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:30:17.735] Debuginfod has been disabled. [03:30:17.735] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:30:17.839] [New LWP 31108] [03:30:17.839] [Thread debugging using libthread_db enabled] [03:30:17.839] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:30:17.839] Core was generated by `postgres: standby: startup waiting for 000000010000000000000005 '. [03:30:17.839] Program terminated with signal SIGQUIT, Quit. [03:30:17.839] #0 0x00007fc9782aeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:17.845] [Current thread is 1 (LWP 32278)] [03:30:17.848] [03:30:17.848] Thread 2 (Thread 0x7fc978a32f00 (LWP 31108)): [03:30:17.848] warning: Couldn't find general-purpose registers in core file. [03:30:17.848] #0 in ?? () [03:30:17.848] PC unavailable, cannot determine locals. [03:30:17.848] Backtrace stopped: not enough registers or memory available to unwind further [03:30:17.848] [03:30:17.848] Thread 1 (LWP 32278): [03:30:17.848] #0 0x00007fc9782aeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:17.848] No symbol table info available. [03:30:17.848] #1 0x00007fc97825b239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:17.848] No symbol table info available. [03:30:17.848] #2 0x00007fc978316204 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:17.848] No symbol table info available. [03:30:17.848] #3 0x00007fc97832885c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:17.848] No symbol table info available. [03:30:17.866] -e [03:30:17.866] [03:30:17.866] [03:30:17.926] dumping /tmp/cores/postgres-6-29784.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:30:18.179] [New LWP 29784] [03:30:18.179] [03:30:18.179] This GDB supports auto-downloading debuginfo from the following URLs: [03:30:18.179] [03:30:18.179] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:30:18.179] Debuginfod has been disabled. [03:30:18.179] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:30:18.286] [Thread debugging using libthread_db enabled] [03:30:18.286] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:30:18.286] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:30:18.286] Program terminated with signal SIGABRT, Aborted. [03:30:18.286] #0 0x00007f30092a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:19.122] [03:30:19.122] Thread 1 (Thread 0x7f300722cf00 (LWP 29784)): [03:30:19.122] #0 0x00007f30092a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:19.122] No symbol table info available. [03:30:19.122] #1 0x00007f300925afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:19.122] No symbol table info available. [03:30:19.122] #2 0x00007f3009245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:19.122] No symbol table info available. [03:30:19.122] #3 0x0000561b36824ad6 in ExceptionalCondition (conditionName=conditionName@entry=0x561b36aa195d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x561b36aa0eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:30:19.122] No locals. [03:30:19.122] #4 0x0000561b3618f20f in standard_ExecutorStart (queryDesc=queryDesc@entry=0x561b428510a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [03:30:19.122] estate = 0x561b4287c510 [03:30:19.122] oldcontext = 0x561b428570d0 [03:30:19.122] __func__ = "standard_ExecutorStart" [03:30:19.122] #5 0x0000561b3618f3eb in ExecutorStart (queryDesc=queryDesc@entry=0x561b428510a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [03:30:19.122] No locals. [03:30:19.122] #6 0x0000561b360ae6d7 in refresh_matview_datafill (dest=0x561b42842580, query=, query@entry=0x561b4280b050, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:30:19.122] rewritten = [03:30:19.122] plan = 0x561b428506f8 [03:30:19.122] queryDesc = 0x561b428510a0 [03:30:19.122] copied_query = [03:30:19.122] processed = [03:30:19.122] __func__ = "refresh_matview_datafill" [03:30:19.122] #7 0x0000561b360b0a31 in RefreshMatViewByOid (matviewOid=28678, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:30:19.122] dest = [03:30:19.122] matviewRel = 0x7f2ffda7e320 [03:30:19.122] rule = [03:30:19.122] actions = [03:30:19.122] dataQuery = 0x561b4280b050 [03:30:19.122] tableSpace = [03:30:19.122] relowner = 10 [03:30:19.122] OIDNewHeap = 28689 [03:30:19.122] processed = 0 [03:30:19.122] relpersistence = 112 'p' [03:30:19.122] save_userid = 10 [03:30:19.122] save_sec_context = 0 [03:30:19.122] save_nestlevel = 2 [03:30:19.122] address = {classId = 0, objectId = 0, objectSubId = 0} [03:30:19.122] __func__ = "RefreshMatViewByOid" [03:30:19.122] #8 0x0000561b360b0b70 in ExecRefreshMatView (stmt=0x561b42842258, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:30:19.122] matviewOid = [03:30:19.122] lockmode = [03:30:19.122] #9 0x0000561b36066623 in ExecCreateTableAs (pstate=pstate@entry=0x561b428571d0, stmt=stmt@entry=0x561b426e2b60, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcb5b16a30) at ../src/backend/commands/createas.c:351 [03:30:19.122] refresh = [03:30:19.122] query = 0x561b426e2d20 [03:30:19.122] into = 0x561b426e28b8 [03:30:19.122] jstate = 0x0 [03:30:19.122] is_matview = true [03:30:19.122] do_refresh = false [03:30:19.122] dest = [03:30:19.122] address = {classId = 1259, objectId = 28678, objectSubId = 0} [03:30:19.122] __func__ = "ExecCreateTableAs" [03:30:19.122] #10 0x0000561b36593579 in ProcessUtilitySlow (pstate=pstate@entry=0x561b428571d0, pstmt=pstmt@entry=0x561b426e2c10, queryString=queryString@entry=0x561b426e1e20 "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=0x561b426e3648, qc=0x7ffcb5b16a30) at ../src/backend/tcop/utility.c:1678 [03:30:19.122] _save_exception_stack = 0x7ffcb5b16910 [03:30:19.122] _save_context_stack = 0x0 [03:30:19.122] _local_sigjmp_buf = {{__jmpbuf = {0, -5467388212542548449, 94675078622048, 0, 94675078618656, 0, -1742892103121349089, -5467643669158013409}, __mask_was_saved = 0, __saved_mask = {__val = {28682, 0, 94674879206616, 139844254879160, 94675078618656, 94674881568787, 94674891741986, 94674891742112, 140723356788532, 94674881763609, 94674891742001, 94674891742112, 140723356788564, 94674881763624, 94674891742112, 0}}}} [03:30:19.122] _do_rethrow = false [03:30:19.122] parsetree = 0x561b426e2b60 [03:30:19.122] isTopLevel = true [03:30:19.122] isCompleteQuery = true [03:30:19.122] needCleanup = false [03:30:19.122] commandCollected = false [03:30:19.122] address = {classId = 22043, objectId = 1114516320, objectSubId = 22043} [03:30:19.122] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:30:19.122] __func__ = "ProcessUtilitySlow" [03:30:19.122] #11 0x0000561b36591b78 in standard_ProcessUtility (pstmt=0x561b426e2c10, queryString=0x561b426e1e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x561b426e3648, qc=0x7ffcb5b16a30) at ../src/backend/tcop/utility.c:1070 [03:30:19.122] parsetree = 0x561b426e2b60 [03:30:19.122] isTopLevel = true [03:30:19.122] isAtomicContext = false [03:30:19.122] pstate = 0x561b428571d0 [03:30:19.122] readonly_flags = [03:30:19.122] __func__ = "standard_ProcessUtility" [03:30:19.122] #12 0x0000561b36591cd3 in ProcessUtility (pstmt=pstmt@entry=0x561b426e2c10, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x561b426e3648, qc=0x7ffcb5b16a30) at ../src/backend/tcop/utility.c:523 [03:30:19.122] No locals. [03:30:19.122] #13 0x0000561b3658d67f in PortalRunUtility (portal=portal@entry=0x561b42766db0, pstmt=pstmt@entry=0x561b426e2c10, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x561b426e3648, qc=qc@entry=0x7ffcb5b16a30) at ../src/backend/tcop/pquery.c:1152 [03:30:19.122] No locals. [03:30:19.122] #14 0x0000561b3658dc2a in PortalRunMulti (portal=portal@entry=0x561b42766db0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x561b426e3648, altdest=altdest@entry=0x561b426e3648, qc=qc@entry=0x7ffcb5b16a30) at ../src/backend/tcop/pquery.c:1309 [03:30:19.122] pstmt = 0x561b426e2c10 [03:30:19.122] stmtlist_item__state = [03:30:19.122] active_snapshot_set = false [03:30:19.122] stmtlist_item = 0x561b426e3610 [03:30:19.122] #15 0x0000561b3658e192 in PortalRun (portal=portal@entry=0x561b42766db0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x561b426e3648, altdest=altdest@entry=0x561b426e3648, qc=qc@entry=0x7ffcb5b16a30) at ../src/backend/tcop/pquery.c:787 [03:30:19.122] _save_exception_stack = 0x7ffcb5b16ae0 [03:30:19.122] _save_context_stack = 0x0 [03:30:19.122] _local_sigjmp_buf = {{__jmpbuf = {0, -5467388212335978977, 94675079163312, 94675078622168, 94675078622144, 94675078622096, -1742892102991325665, -5467643662545824225}, __mask_was_saved = 0, __saved_mask = {__val = {94674878893751, 3048303039, 4, 94675078622096, 112, 73, 94675079163312, 94675078622168, 94675078622144, 94675078622096, 94674878980954, 1, 2, 73, 94674868226554, 0}}}} [03:30:19.122] _do_rethrow = [03:30:19.122] result = [03:30:19.122] nprocessed = [03:30:19.122] saveTopTransactionResourceOwner = 0x561b42723868 [03:30:19.122] saveTopTransactionContext = 0x561b42778dd0 [03:30:19.122] saveActivePortal = 0x0 [03:30:19.122] saveResourceOwner = 0x561b42723868 [03:30:19.122] savePortalContext = 0x0 [03:30:19.122] saveMemoryContext = 0x561b42778dd0 [03:30:19.122] __func__ = "PortalRun" [03:30:19.122] #16 0x0000561b36587628 in exec_simple_query (query_string=query_string@entry=0x561b426e1e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [03:30:19.122] cmdtaglen = 24 [03:30:19.122] snapshot_set = [03:30:19.122] per_parsetree_context = 0x0 [03:30:19.122] plantree_list = 0x561b426e35f8 [03:30:19.122] parsetree = 0x561b426e2b90 [03:30:19.122] commandTag = [03:30:19.122] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:30:19.122] querytree_list = [03:30:19.122] portal = 0x561b42766db0 [03:30:19.122] receiver = 0x561b426e3648 [03:30:19.122] format = 0 [03:30:19.122] cmdtagname = [03:30:19.122] parsetree_item__state = [03:30:19.122] dest = DestRemote [03:30:19.122] oldcontext = 0x561b42778dd0 [03:30:19.122] parsetree_list = 0x561b426e2bc0 [03:30:19.122] parsetree_item = 0x561b426e2bd8 [03:30:19.122] save_log_statement_stats = false [03:30:19.122] was_logged = true [03:30:19.122] use_implicit_block = false [03:30:19.122] msec_str = "\004\000\000\000\000\000\000\000\004\251\2046\033V\000\000\300j\261\265\374\177\000\000G\000\000\000\000\000\000" [03:30:19.122] __func__ = "exec_simple_query" [03:30:19.122] #17 0x0000561b3658a381 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [03:30:19.122] query_string = 0x561b426e1e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:30:19.122] firstchar = [03:30:19.122] input_message = {data = 0x561b426e1e20 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:30:19.122] local_sigjmp_buf = {{__jmpbuf = {94674891750584, -5467645742516644321, 140723356789820, 4, 14, 140723356790052, -1742892103058434529, -5467643665075120609}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94675078348320, 16128, 94674891744640, 94675078883360, 14, 94674878893299, 0, 9, 2, 94674891750592, 94675078348320, 94674891744640, 4, 14, 140723356790052}}}} [03:30:19.122] send_ready_for_query = false [03:30:19.122] idle_in_transaction_timeout_enabled = false [03:30:19.122] idle_session_timeout_enabled = false [03:30:19.122] __func__ = "PostgresMain" [03:30:19.122] #18 0x0000561b365803d7 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:30:19.122] bsdata = [03:30:19.122] #19 0x0000561b3643130a in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x7ffcb5b16c3c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcb5b16c90) at ../src/backend/postmaster/launch_backend.c:274 [03:30:19.122] pid = [03:30:19.122] #20 0x0000561b36436505 in BackendStartup (client_sock=client_sock@entry=0x7ffcb5b16c90) at ../src/backend/postmaster/postmaster.c:3519 [03:30:19.122] bn = 0x561b4270a588 [03:30:19.122] pid = [03:30:19.122] startup_data = {canAcceptConnections = CAC_OK} [03:30:19.122] cac = [03:30:19.122] __func__ = "BackendStartup" [03:30:19.122] #21 0x0000561b364385d5 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:30:19.122] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "#\t0\177\000\000\240\017v\n0\177\000\0008m\261\265\374\177\000\0004m\261\265\374\177", '\000' , "\233([5\033V\000\000\030\bW5\033V\000\000\000n\261\265\374\177\000\000\370m\261\265\374\177\000\000\225[\362\001\000\000\000\000\240t\b\n0\177\000\000+", '\000' , "\033V\000\000\251'[5\033V\000", __ss_align = 139844314895976}, salen = 2}} [03:30:19.122] i = 0 [03:30:19.122] now = [03:30:19.122] last_lockfile_recheck_time = 1738380287 [03:30:19.122] last_touch_time = 1738380287 [03:30:19.122] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x0}, {pos = 179738216, events = 32560, fd = 168326704, user_data = 0x7f300ab692e0}, {pos = 2090263927, events = 0, fd = -1246663040, user_data = 0x7f300ab3fa48}, {pos = 15, events = 0, fd = 168326704, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f300ab692e0}, {pos = -1246663176, events = 32764, fd = -1246663168, user_data = 0x7f300ab69668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 1114520272, events = 22043, fd = 1, user_data = 0x7ffcb5b17323}, {pos = -1, events = 0, fd = 153280544, user_data = 0x7f300a760fa0}, {pos = 1114698536, events = 22043, fd = 1114698248, user_data = 0x561b4270efe1}, {pos = 179592894, events = 32560, fd = 1, user_data = 0x7f300ab692e0}, {pos = 426, events = 0, fd = 920530256, user_data = 0x0}, {pos = 229, events = 0, fd = 1114512952, user_data = 0x7f300ab45ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f300922e020}, {pos = 154086976, events = 32560, fd = 16, user_data = 0x7ffcb5b17250}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 179601850, events = 32560, fd = 0, user_data = 0x7f30092aeda4 }, {pos = 0, events = 0, fd = 927569088, user_data = 0x2}, {pos = 0, events = 0, fd = 1114259136, user_data = 0x561b3651deb1 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 1114512952, user_data = 0x7f300ab45ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f30092364c8}, {pos = 153841773, events = 32560, fd = 927636384, user_data = 0x561b427147c0}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 155130976, events = 32560, 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 = 1024, user_data = 0x7f30092b58be}, {pos = 155113952, events = 32560, fd = 153751918, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1114698768, user_data = 0x3fec884aa9f19f00}, {pos = 155117024, events = 32560, fd = -328, user_data = 0x0}, {pos = 1114697928, events = 22043, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 25959, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1114512952, user_data = 0x7f30092f3053 }, {pos = 1114697928, events = 22043, fd = 1024, user_data = 0x7ffcb5b17318}, {pos = 914866922, events = 22043, fd = 927644784, user_data = 0x561b3686ada7 }, {pos = 1114697728, events = 22043, fd = 1114512672, user_data = 0x561b4270f000}, {pos = 153835710, events = 32560, fd = 0, user_data = 0x561b3687ca11 }, {pos = 1114697728, events = 1, fd = 914869082, user_data = 0x561b426e1d20}, {pos = -1443782912, events = 1072465994, fd = 0, user_data = 0x7f30092a2ab1}, {pos = 153752816, events = 32560, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1114259136, user_data = 0x3fec884aa9f19f00}, {pos = 0, events = 0, fd = -1443782912, user_data = 0xc}, {pos = -1443782912, events = 1072465994, fd = 0, user_data = 0x7f300925b239 }, {pos = 230, events = 0, fd = 910364679, user_data = 0x400000}, {pos = 0, events = 0, fd = 1114259136, user_data = 0x561b3686ac3b }, {pos = 1114346576, events = 22043, fd = 1114512672, user_data = 0x561b426b9450}, {pos = 1, events = 0, fd = 0, user_data = 0x561b36829440 }, {pos = 12, events = 0, fd = 1114689064, user_data = 0x561b4270ce08}, {pos = 927570496, events = 22043, fd = 296, user_data = 0x561b36433821 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 910381044, events = 22043, fd = 923948144, user_data = 0x561b426e26c8}} [03:30:19.122] nevents = 1 [03:30:19.122] __func__ = "ServerLoop" [03:30:19.122] #22 0x0000561b36439e34 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x561b4269fd30) at ../src/backend/postmaster/postmaster.c:1386 [03:30:19.122] opt = [03:30:19.122] status = [03:30:19.122] userDoption = [03:30:19.122] listen_addr_saved = false [03:30:19.122] output_config_variable = [03:30:19.122] __func__ = "PostmasterMain" [03:30:19.122] #23 0x0000561b3626ea0b in main (argc=4, argv=0x561b4269fd30) at ../src/backend/main/main.c:230 [03:30:19.122] do_check_root = [03:30:19.122] dispatch_option = [03:30:19.157] -e [03:30:19.157] [03:30:19.157] [03:30:19.219] dumping /tmp/cores/postgres-6-36621.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:30:19.480] [New LWP 36621] [03:30:19.480] [03:30:19.480] This GDB supports auto-downloading debuginfo from the following URLs: [03:30:19.480] [03:30:19.480] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:30:19.480] Debuginfod has been disabled. [03:30:19.480] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:30:19.584] [Thread debugging using libthread_db enabled] [03:30:19.584] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:30:19.584] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:30:19.584] Program terminated with signal SIGABRT, Aborted. [03:30:19.584] #0 0x00007f6ba72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:20.431] [03:30:20.431] Thread 1 (Thread 0x7f6ba7a35f00 (LWP 36621)): [03:30:20.431] #0 0x00007f6ba72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:20.431] No symbol table info available. [03:30:20.431] #1 0x00007f6ba725afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:20.431] No symbol table info available. [03:30:20.431] #2 0x00007f6ba7245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:30:20.431] No symbol table info available. [03:30:20.431] #3 0x000056126c996ad6 in ExceptionalCondition (conditionName=conditionName@entry=0x56126cc1395d "queryDesc->sourceText != NULL", fileName=fileName@entry=0x56126cc12eb0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:30:20.431] No locals. [03:30:20.431] #4 0x000056126c30120f in standard_ExecutorStart (queryDesc=0x56127afd1ea0, eflags=0) at ../src/backend/executor/execMain.c:194 [03:30:20.431] estate = 0x56127af7aff0 [03:30:20.431] oldcontext = 0x56127afa7230 [03:30:20.431] __func__ = "standard_ExecutorStart" [03:30:20.431] #5 0x00007f6ba4e4a6e9 in pgss_ExecutorStart (queryDesc=0x56127afd1ea0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [03:30:20.431] No locals. [03:30:20.431] #6 0x000056126c3013a4 in ExecutorStart (queryDesc=queryDesc@entry=0x56127afd1ea0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [03:30:20.431] No locals. [03:30:20.431] #7 0x000056126c2206d7 in refresh_matview_datafill (dest=0x56127afb6ba0, query=, query@entry=0x56127aff7880, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:30:20.431] rewritten = [03:30:20.431] plan = 0x56127afd14f8 [03:30:20.431] queryDesc = 0x56127afd1ea0 [03:30:20.431] copied_query = [03:30:20.431] processed = [03:30:20.431] __func__ = "refresh_matview_datafill" [03:30:20.431] #8 0x000056126c222a31 in RefreshMatViewByOid (matviewOid=28578, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:30:20.431] dest = [03:30:20.431] matviewRel = 0x7f6ba2c9a680 [03:30:20.431] rule = [03:30:20.431] actions = [03:30:20.431] dataQuery = 0x56127aff7880 [03:30:20.431] tableSpace = [03:30:20.431] relowner = 10 [03:30:20.431] OIDNewHeap = 28585 [03:30:20.431] processed = 0 [03:30:20.431] relpersistence = 112 'p' [03:30:20.431] save_userid = 10 [03:30:20.431] save_sec_context = 0 [03:30:20.431] save_nestlevel = 2 [03:30:20.431] address = {classId = 0, objectId = 0, objectSubId = 0} [03:30:20.431] __func__ = "RefreshMatViewByOid" [03:30:20.431] #9 0x000056126c222b70 in ExecRefreshMatView (stmt=0x56127afb6878, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:30:20.431] matviewOid = [03:30:20.431] lockmode = [03:30:20.431] #10 0x000056126c1d8623 in ExecCreateTableAs (pstate=pstate@entry=0x56127afa7330, stmt=stmt@entry=0x56127ae6eb80, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff811e3190) at ../src/backend/commands/createas.c:351 [03:30:20.431] refresh = [03:30:20.431] query = 0x56127ae6ed40 [03:30:20.431] into = 0x56127ae6e8d8 [03:30:20.431] jstate = 0x0 [03:30:20.431] is_matview = true [03:30:20.431] do_refresh = false [03:30:20.431] dest = [03:30:20.431] address = {classId = 1259, objectId = 28578, objectSubId = 0} [03:30:20.431] __func__ = "ExecCreateTableAs" [03:30:20.431] #11 0x000056126c705579 in ProcessUtilitySlow (pstate=pstate@entry=0x56127afa7330, pstmt=pstmt@entry=0x56127ae6ec30, queryString=queryString@entry=0x56127ae6de40 "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=0x56127ae6fbd8, qc=0x7fff811e3190) at ../src/backend/tcop/utility.c:1678 [03:30:20.431] _save_exception_stack = 0x7fff811e2d60 [03:30:20.431] _save_context_stack = 0x0 [03:30:20.431] _local_sigjmp_buf = {{__jmpbuf = {0, -6019327829263287359, 94637371353984, 0, 94637371350592, 0, -23368149610824767, -6019307095861396543}, __mask_was_saved = 0, __saved_mask = {__val = {3, 5, 1, 5, 1, 1, 94637371357568, 94637371358368, 94637131760065, 2063300824, 94637131668854, 94637371350336, 140735359626640, 0, 94637131985202, 140735359625836}}}} [03:30:20.431] _do_rethrow = false [03:30:20.431] parsetree = 0x56127ae6eb80 [03:30:20.431] isTopLevel = true [03:30:20.431] isCompleteQuery = true [03:30:20.431] needCleanup = false [03:30:20.431] commandCollected = false [03:30:20.431] address = {classId = 22034, objectId = 2061953920, objectSubId = 22034} [03:30:20.431] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:30:20.431] __func__ = "ProcessUtilitySlow" [03:30:20.431] #12 0x000056126c703b78 in standard_ProcessUtility (pstmt=pstmt@entry=0x56127ae6ec30, queryString=queryString@entry=0x56127ae6de40 "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=0x56127ae6fbd8, qc=0x7fff811e3190) at ../src/backend/tcop/utility.c:1070 [03:30:20.431] parsetree = 0x56127ae6eb80 [03:30:20.431] isTopLevel = true [03:30:20.431] isAtomicContext = false [03:30:20.431] pstate = 0x56127afa7330 [03:30:20.431] readonly_flags = [03:30:20.431] __func__ = "standard_ProcessUtility" [03:30:20.431] #13 0x00007f6ba4e4dd97 in pgss_ProcessUtility (pstmt=0x56127ae6ec30, queryString=0x56127ae6de40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x56127ae6fbd8, qc=0x7fff811e3190) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [03:30:20.431] _save_exception_stack = 0x7fff811e3070 [03:30:20.431] _save_context_stack = 0x0 [03:30:20.431] _local_sigjmp_buf = {{__jmpbuf = {0, 23636162778463169, 94637371354160, 94637371358168, 140735359627664, 0, -23368149715682367, -106765605863457855}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140735359626896, 94637131992901, 1, 206158430232, 94637371354960, 140735359626992, 0, 94637126753083, 94637371350336, 94637131652419, 3, 94637125475237, 94637371354160}}}} [03:30:20.431] _do_rethrow = false [03:30:20.431] duration = [03:30:20.431] bufusage = {shared_blks_hit = 1, shared_blks_read = 37, shared_blks_dirtied = 140100272039552, shared_blks_written = 140100272039552, local_blks_hit = 1, local_blks_read = 94637128125730, local_blks_dirtied = 94637372456120, local_blks_written = 94637131986136, temp_blks_read = 140100350729656, temp_blks_written = 94637371350592, shared_blk_read_time = {ticks = 94637134348307}, shared_blk_write_time = {ticks = 94637144521506}, local_blk_read_time = {ticks = 94637144521632}, local_blk_write_time = {ticks = 140735359626900}, temp_blk_read_time = {ticks = 94637134543129}, temp_blk_write_time = {ticks = 94637144521521}} [03:30:20.431] walusage_start = {wal_records = 8961, wal_fpi = 117, wal_bytes = 1176443} [03:30:20.431] start = [03:30:20.431] rows = [03:30:20.431] bufusage_start = {shared_blks_hit = 34681, shared_blks_read = 4021, shared_blks_dirtied = 1449, shared_blks_written = 936, 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}} [03:30:20.431] walusage = {wal_records = 140100275151936, wal_fpi = 158913789952, wal_bytes = 140100272039588} [03:30:20.431] parsetree = [03:30:20.431] saved_queryId = 7267788456574341698 [03:30:20.431] saved_stmt_location = 0 [03:30:20.431] saved_stmt_len = 69 [03:30:20.431] enabled = true [03:30:20.431] #14 0x000056126c703c1e in ProcessUtility (pstmt=pstmt@entry=0x56127ae6ec30, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x56127ae6fbd8, qc=0x7fff811e3190) at ../src/backend/tcop/utility.c:519 [03:30:20.431] No locals. [03:30:20.431] #15 0x000056126c6ff67f in PortalRunUtility (portal=portal@entry=0x56127aef0d30, pstmt=pstmt@entry=0x56127ae6ec30, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x56127ae6fbd8, qc=qc@entry=0x7fff811e3190) at ../src/backend/tcop/pquery.c:1152 [03:30:20.431] No locals. [03:30:20.431] #16 0x000056126c6ffc2a in PortalRunMulti (portal=portal@entry=0x56127aef0d30, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x56127ae6fbd8, altdest=altdest@entry=0x56127ae6fbd8, qc=qc@entry=0x7fff811e3190) at ../src/backend/tcop/pquery.c:1309 [03:30:20.431] pstmt = 0x56127ae6ec30 [03:30:20.431] stmtlist_item__state = [03:30:20.431] active_snapshot_set = false [03:30:20.431] stmtlist_item = 0x56127ae6fba0 [03:30:20.431] #17 0x000056126c700192 in PortalRun (portal=portal@entry=0x56127aef0d30, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x56127ae6fbd8, altdest=altdest@entry=0x56127ae6fbd8, qc=qc@entry=0x7fff811e3190) at ../src/backend/tcop/pquery.c:787 [03:30:20.431] _save_exception_stack = 0x7fff811e3240 [03:30:20.431] _save_context_stack = 0x0 [03:30:20.431] _local_sigjmp_buf = {{__jmpbuf = {0, -6019327829736195135, 94637371886896, 94637371354104, 94637371354080, 94637371354032, -23368149898134591, -6019307093803697215}, __mask_was_saved = 0, __saved_mask = {__val = {94637131673271, 2166239519, 4, 94637371354032, 112, 73, 94637371886896, 94637371354104, 94637371354080, 94637371354032, 94637131760474, 1, 2, 73, 94637121006074, 0}}}} [03:30:20.431] _do_rethrow = [03:30:20.431] result = [03:30:20.431] nprocessed = [03:30:20.431] saveTopTransactionResourceOwner = 0x56127aeb2738 [03:30:20.431] saveTopTransactionContext = 0x56127af03570 [03:30:20.431] saveActivePortal = 0x0 [03:30:20.431] saveResourceOwner = 0x56127aeb2738 [03:30:20.431] savePortalContext = 0x0 [03:30:20.431] saveMemoryContext = 0x56127af03570 [03:30:20.431] __func__ = "PortalRun" [03:30:20.431] #18 0x000056126c6f9628 in exec_simple_query (query_string=query_string@entry=0x56127ae6de40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [03:30:20.431] cmdtaglen = 24 [03:30:20.431] snapshot_set = [03:30:20.431] per_parsetree_context = 0x0 [03:30:20.431] plantree_list = 0x56127ae6fb88 [03:30:20.431] parsetree = 0x56127ae6ebb0 [03:30:20.431] commandTag = [03:30:20.431] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:30:20.431] querytree_list = [03:30:20.431] portal = 0x56127aef0d30 [03:30:20.431] receiver = 0x56127ae6fbd8 [03:30:20.431] format = 0 [03:30:20.431] cmdtagname = [03:30:20.431] parsetree_item__state = [03:30:20.431] dest = DestRemote [03:30:20.431] oldcontext = 0x56127af03570 [03:30:20.431] parsetree_list = 0x56127ae6ebe0 [03:30:20.431] parsetree_item = 0x56127ae6ebf8 [03:30:20.431] save_log_statement_stats = false [03:30:20.431] was_logged = true [03:30:20.431] use_implicit_block = false [03:30:20.431] msec_str = "\004\000\000\000\000\000\000\000\004ɛl\022V\000\000 2\036\201\377\177\000\000G\000\000\000\000\000\000" [03:30:20.431] __func__ = "exec_simple_query" [03:30:20.431] #19 0x000056126c6fc381 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [03:30:20.431] query_string = 0x56127ae6de40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:30:20.431] firstchar = [03:30:20.431] input_message = {data = 0x56127ae6de40 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:30:20.431] local_sigjmp_buf = {{__jmpbuf = {94637144530104, -6019304764724773951, 140735359628188, 4, 13, 140735359628420, -23368149965243455, -6019307014200132671}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94637371606752, 0, 168, 94637131673373, 0, 10, 2, 94637144530112, 94637371080288, 94637144524160, 4, 13, 140735359628420}}}} [03:30:20.431] send_ready_for_query = false [03:30:20.431] idle_in_transaction_timeout_enabled = false [03:30:20.431] idle_session_timeout_enabled = false [03:30:20.431] __func__ = "PostgresMain" [03:30:20.431] #20 0x000056126c6f23d7 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:30:20.431] bsdata = [03:30:20.431] #21 0x000056126c5a330a in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x7fff811e339c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff811e33f0) at ../src/backend/postmaster/launch_backend.c:274 [03:30:20.431] pid = [03:30:20.431] #22 0x000056126c5a8505 in BackendStartup (client_sock=client_sock@entry=0x7fff811e33f0) at ../src/backend/postmaster/postmaster.c:3519 [03:30:20.431] bn = 0x56127ae997d8 [03:30:20.431] pid = [03:30:20.431] startup_data = {canAcceptConnections = CAC_OK} [03:30:20.431] cac = [03:30:20.431] __func__ = "BackendStartup" [03:30:20.431] #23 0x000056126c5aa5d5 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:30:20.431] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\233Hrk\022V\000\000\030(nk\022V\000\000@5\036\201\377\177\000\00085\036\201\377\177\000\000\225[\362\001\000\000\000\000\240\212\351z\022V\000\000,", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\206\274\250k\177\000\0000\006\t\250k\177\000\000\340\202\274\250k\177\000\000\316)fR\000\000\000", __ss_align = 2166240640}, salen = 2}} [03:30:20.431] i = 0 [03:30:20.431] now = [03:30:20.431] last_lockfile_recheck_time = 1738380320 [03:30:20.431] last_touch_time = 1738380320 [03:30:20.431] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = -1464040736, user_data = 0x0}, {pos = -2128726592, events = 32767, fd = -1464210872, user_data = 0xf}, {pos = -1475803600, events = 32619, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1464040736, user_data = 0x7fff811e3538}, {pos = -2128726720, events = 32767, fd = -1464039832, user_data = 0x0}, {pos = 2062136744, events = 22034, fd = -1490322806, user_data = 0x56127ae9b5a8}, {pos = 1, events = 22034, fd = 32768, user_data = 0xffffffff}, {pos = -1490886624, events = 32619, fd = -1468293216, user_data = 0x56127aea3c38}, {pos = 2062170904, events = 22034, fd = 2062147585, user_data = 0x7f6ba8ba4ebe}, {pos = 1, events = 0, fd = -1464040736, user_data = 0x1aa}, {pos = 1828015440, events = 22034, fd = 0, user_data = 0x56}, {pos = 2062136744, events = 22034, fd = -1464185154, user_data = 0x1}, {pos = 0, events = 0, fd = -1490886624, user_data = 0x7f6ba72f2e40 }, {pos = 16, events = 0, fd = -2128725584, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f6ba8ba71ba}, {pos = 0, events = 0, fd = -1490358876, user_data = 0x0}, {pos = 1835054272, events = 22034, fd = 2, user_data = 0x0}, {pos = 2061696768, events = 22034, fd = 1818800867, user_data = 0x56127aea2900}, {pos = 1818804856, events = 22034, fd = 2062166363, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1490852664, user_data = 0x7f6ba729c880 }, {pos = -1482465864, events = 32619, fd = -2128725392, user_data = 0x100007f00000002}, {pos = -1490325753, events = 32619, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1489036192, events = 32619, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f6ba872a540}, {pos = -1468880256, events = 32619, 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 = 2062177584, events = 22034, fd = 1080, user_data = 0x56127aea3910}, {pos = 1822270966, events = 22034, fd = 1024, user_data = 0x7f6ba72b576b}, {pos = -1489053216, events = 32619, fd = -1490415250, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2062166272, user_data = 0x68e43da9796c200}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x56127aea3910}, {pos = 1, events = 0, fd = 2062170584, user_data = 0x3}, {pos = 0, events = 0, fd = 32518, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2062136744, user_data = 0x7f6ba72f3053 }, {pos = 2062170584, events = 22034, fd = 1024, user_data = 0x7fff811e3a78}, {pos = 1822352106, events = 22034, fd = 1835129968, user_data = 0x56126c9dcda7 }, {pos = 2062170384, events = 22034, fd = 2061950272, user_data = 0x56127aea3910}, {pos = -1490331797, events = 32619, fd = 0, user_data = 0x56126c9eea11 }, {pos = 2062170384, events = 1, fd = 1822354266, user_data = 0x56127ae6dd40}, {pos = -1751727616, events = 109986778, fd = 0, user_data = 0x7f6ba72a2ab1}, {pos = -1490414352, events = 32619, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2061696768, user_data = 0x68e43da9796c200}, {pos = 0, events = 0, fd = -1751727616, user_data = 0xc}, {pos = -1751727616, events = 109986778, fd = 0, user_data = 0x7f6ba725b239 }, {pos = 87, events = 0, fd = 1817849863, user_data = 0x400000}, {pos = 0, events = 0, fd = 2061696768, user_data = 0x56126c9dcc3b }, {pos = 2061784176, events = 22034, fd = 2061950272, user_data = 0x56127ae45470}, {pos = 1, events = 0, fd = 0, user_data = 0x56126c99b440 }, {pos = 12, events = 0, fd = 2062132696, user_data = 0x56127ae9a5b8}, {pos = 1835055680, events = 22034, fd = 296, user_data = 0x56126c5a5821 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1817866228, events = 22034, fd = 1831433328, user_data = 0x56127ae6e6f8}} [03:30:20.431] nevents = 1 [03:30:20.431] __func__ = "ServerLoop" [03:30:20.431] #24 0x000056126c5abe34 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x56127ae2bd60) at ../src/backend/postmaster/postmaster.c:1386 [03:30:20.431] opt = [03:30:20.431] status = [03:30:20.431] userDoption = [03:30:20.431] listen_addr_saved = false [03:30:20.431] output_config_variable = [03:30:20.431] __func__ = "PostmasterMain" [03:30:20.431] #25 0x000056126c3e0a0b in main (argc=4, argv=0x56127ae2bd60) at ../src/backend/main/main.c:230 [03:30:20.431] do_check_root = [03:30:20.431] dispatch_option =