[20:48:05.696] src/tools/ci/cores_backtrace.sh linux /tmp/cores [20:48:05.899] dumping /tmp/cores/postgres-6-29204.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:48:06.175] [New LWP 29204] [20:48:06.175] [20:48:06.175] This GDB supports auto-downloading debuginfo from the following URLs: [20:48:06.175] [20:48:06.175] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:48:06.175] Debuginfod has been disabled. [20:48:06.175] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:48:06.312] [Thread debugging using libthread_db enabled] [20:48:06.312] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:48:06.312] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [20:48:06.312] Program terminated with signal SIGABRT, Aborted. [20:48:06.312] #0 0x00007fd8194a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:07.336] [20:48:07.336] Thread 1 (Thread 0x7fd819c37f00 (LWP 29204)): [20:48:07.336] #0 0x00007fd8194a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:07.336] No symbol table info available. [20:48:07.336] #1 0x00007fd81945afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:07.336] No symbol table info available. [20:48:07.336] #2 0x00007fd819445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:07.336] No symbol table info available. [20:48:07.336] #3 0x00005620223d3d96 in ExceptionalCondition (conditionName=conditionName@entry=0x562022644505 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x562022643a70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [20:48:07.336] No locals. [20:48:07.336] #4 0x0000562021d63c10 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5620246e6df0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [20:48:07.336] estate = 0x562024717310 [20:48:07.336] oldcontext = 0x5620246c0560 [20:48:07.336] __func__ = "standard_ExecutorStart" [20:48:07.336] #5 0x0000562021d63dec in ExecutorStart (queryDesc=queryDesc@entry=0x5620246e6df0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [20:48:07.336] No locals. [20:48:07.336] #6 0x0000562021c8af16 in refresh_matview_datafill (dest=0x5620246c45e8, query=, query@entry=0x56202472b400, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [20:48:07.336] rewritten = [20:48:07.336] plan = 0x56202475fed0 [20:48:07.336] queryDesc = 0x5620246e6df0 [20:48:07.336] copied_query = [20:48:07.336] processed = [20:48:07.336] __func__ = "refresh_matview_datafill" [20:48:07.336] #7 0x0000562021c8d2c7 in RefreshMatViewByOid (matviewOid=27354, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [20:48:07.336] dest = [20:48:07.336] matviewRel = 0x7fd80dcb50c8 [20:48:07.336] rule = [20:48:07.336] actions = [20:48:07.336] dataQuery = 0x56202472b400 [20:48:07.336] tableSpace = [20:48:07.336] relowner = 10 [20:48:07.336] OIDNewHeap = 27361 [20:48:07.336] processed = 0 [20:48:07.336] relpersistence = 112 'p' [20:48:07.336] save_userid = 10 [20:48:07.336] save_sec_context = 0 [20:48:07.336] save_nestlevel = 2 [20:48:07.336] address = {classId = 0, objectId = 0, objectSubId = 0} [20:48:07.336] __func__ = "RefreshMatViewByOid" [20:48:07.336] #8 0x0000562021c8d406 in ExecRefreshMatView (stmt=0x5620246c5678, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:48:07.336] matviewOid = [20:48:07.336] lockmode = [20:48:07.336] #9 0x0000562021c44acd in ExecCreateTableAs (pstate=pstate@entry=0x5620246c0660, stmt=stmt@entry=0x562024585770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffca2176350) at ../src/backend/commands/createas.c:350 [20:48:07.336] refresh = [20:48:07.336] query = 0x562024585930 [20:48:07.336] into = 0x5620245854c8 [20:48:07.336] is_matview = true [20:48:07.336] do_refresh = false [20:48:07.336] dest = [20:48:07.336] address = {classId = 1259, objectId = 27354, objectSubId = 0} [20:48:07.336] __func__ = "ExecCreateTableAs" [20:48:07.336] #10 0x000056202214f4a9 in ProcessUtilitySlow (pstate=pstate@entry=0x5620246c0660, pstmt=pstmt@entry=0x562024585820, queryString=queryString@entry=0x562024584a30 "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=0x562024586258, qc=0x7ffca2176350) at ../src/backend/tcop/utility.c:1675 [20:48:07.336] _save_exception_stack = 0x7ffca2176210 [20:48:07.336] _save_context_stack = 0x0 [20:48:07.336] _local_sigjmp_buf = {{__jmpbuf = {0, 5704151098112682407, 94696048711536, 0, 94696048708144, 0, 2058210646740773287, 5704156007148759463}, __mask_was_saved = 0, __saved_mask = {__val = {140565926752192, 13686, 94696010169996, 1, 4294980982, 140565926752192, 94696013970394, 140566121905592, 94696048708144, 94696016277477, 94696026174530, 94696026174656, 140723027927124, 94696016471896, 94696026174545, 94696026174656}}}} [20:48:07.336] _do_rethrow = false [20:48:07.336] parsetree = 0x562024585770 [20:48:07.336] isTopLevel = true [20:48:07.336] isCompleteQuery = true [20:48:07.336] needCleanup = false [20:48:07.336] commandCollected = false [20:48:07.336] address = {classId = 22048, objectId = 609769328, objectSubId = 22048} [20:48:07.336] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:48:07.336] __func__ = "ProcessUtilitySlow" [20:48:07.336] #11 0x000056202214daba in standard_ProcessUtility (pstmt=0x562024585820, queryString=0x562024584a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x562024586258, qc=0x7ffca2176350) at ../src/backend/tcop/utility.c:1067 [20:48:07.336] parsetree = 0x562024585770 [20:48:07.336] isTopLevel = true [20:48:07.336] isAtomicContext = false [20:48:07.336] pstate = 0x5620246c0660 [20:48:07.336] readonly_flags = [20:48:07.336] __func__ = "standard_ProcessUtility" [20:48:07.336] #12 0x000056202214dc15 in ProcessUtility (pstmt=pstmt@entry=0x562024585820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x562024586258, qc=0x7ffca2176350) at ../src/backend/tcop/utility.c:523 [20:48:07.336] No locals. [20:48:07.336] #13 0x0000562022149481 in PortalRunUtility (portal=portal@entry=0x562024607680, pstmt=pstmt@entry=0x562024585820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562024586258, qc=qc@entry=0x7ffca2176350) at ../src/backend/tcop/pquery.c:1158 [20:48:07.336] No locals. [20:48:07.336] #14 0x0000562022149a26 in PortalRunMulti (portal=portal@entry=0x562024607680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562024586258, altdest=altdest@entry=0x562024586258, qc=qc@entry=0x7ffca2176350) at ../src/backend/tcop/pquery.c:1316 [20:48:07.336] pstmt = 0x562024585820 [20:48:07.336] stmtlist_item__state = [20:48:07.336] active_snapshot_set = false [20:48:07.336] stmtlist_item = 0x562024586220 [20:48:07.336] #15 0x0000562022149ff9 in PortalRun (portal=portal@entry=0x562024607680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x562024586258, altdest=altdest@entry=0x562024586258, qc=0x7ffca2176350) at ../src/backend/tcop/pquery.c:791 [20:48:07.336] _save_exception_stack = 0x7ffca2176400 [20:48:07.336] _save_context_stack = 0x0 [20:48:07.336] _local_sigjmp_buf = {{__jmpbuf = {0, 5704151098862414247, 94696049243776, 94696048711656, 94696049243776, 94696048711584, 2058210647667714471, 5704156004946094503}, __mask_was_saved = 0, __saved_mask = {__val = {94696013655224, 94696048707888, 112, 4, 94696013659641, 2719441631, 4, 94696048711584, 112, 73, 94696049243776, 94696048711656, 94696048711632, 94696048711584, 94696013746844, 1}}}} [20:48:07.336] _do_rethrow = [20:48:07.336] result = [20:48:07.336] nprocessed = [20:48:07.336] saveTopTransactionResourceOwner = 0x5620245c4838 [20:48:07.336] saveTopTransactionContext = 0x562024618660 [20:48:07.336] saveActivePortal = 0x0 [20:48:07.336] saveResourceOwner = 0x5620245c4838 [20:48:07.336] savePortalContext = 0x0 [20:48:07.336] saveMemoryContext = 0x562024618660 [20:48:07.336] __func__ = "PortalRun" [20:48:07.336] #16 0x0000562022143695 in exec_simple_query (query_string=query_string@entry=0x562024584a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [20:48:07.336] cmdtaglen = 24 [20:48:07.336] snapshot_set = [20:48:07.336] per_parsetree_context = 0x0 [20:48:07.336] plantree_list = 0x562024586208 [20:48:07.336] parsetree = 0x5620245857a0 [20:48:07.336] commandTag = [20:48:07.336] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:48:07.336] querytree_list = [20:48:07.336] portal = 0x562024607680 [20:48:07.336] receiver = 0x562024586258 [20:48:07.336] format = 0 [20:48:07.336] cmdtagname = [20:48:07.336] parsetree_item__state = [20:48:07.336] dest = DestRemote [20:48:07.336] oldcontext = 0x562024618660 [20:48:07.336] parsetree_list = 0x5620245857d0 [20:48:07.336] parsetree_item = 0x5620245857e8 [20:48:07.336] save_log_statement_stats = false [20:48:07.336] was_logged = true [20:48:07.336] use_implicit_block = false [20:48:07.336] msec_str = "\260e\027\242\374\177\000\000\276\232?\" V\000\000\340c\027\242\374\177\000\000G\000\000\000\000\000\000" [20:48:07.336] __func__ = "exec_simple_query" [20:48:07.336] #17 0x000056202214616e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [20:48:07.336] query_string = 0x562024584a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:48:07.336] firstchar = [20:48:07.336] input_message = {data = 0x562024584a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:48:07.336] local_sigjmp_buf = {{__jmpbuf = {94696026183096, 5704153634488002983, 4, 140723027928496, 140723027928640, 140723027928644, 2058210647613188519, 5704156011600357799}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94696048438704, 14336, 94696026177184, 94696048965616, 140723027928640, 94696013659189, 0, 9, 2, 94696026183104, 94696048438704, 94696026177184, 140723027928496, 140723027928640, 140723027928644}}}} [20:48:07.336] send_ready_for_query = false [20:48:07.336] idle_in_transaction_timeout_enabled = false [20:48:07.336] idle_session_timeout_enabled = false [20:48:07.336] __func__ = "PostgresMain" [20:48:07.336] #18 0x000056202213c290 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:48:07.336] bsdata = [20:48:07.336] #19 0x0000562021ff4c10 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffca217655c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffca21765b0) at ../src/backend/postmaster/launch_backend.c:274 [20:48:07.336] pid = [20:48:07.336] #20 0x0000562021ffa6bc in BackendStartup (client_sock=client_sock@entry=0x7ffca21765b0) at ../src/backend/postmaster/postmaster.c:3415 [20:48:07.336] bn = 0x5620245b9848 [20:48:07.336] pid = [20:48:07.336] startup_data = {canAcceptConnections = CAC_OK} [20:48:07.336] __func__ = "BackendStartup" [20:48:07.336] #21 0x0000562021ffac1e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [20:48:07.336] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "B\031\330\177\000\000tf\027\242\374\177\000\000\312\360\313\032\330\177\000\000>\004\000\000\000\000\000\000\260\227C\031\330\177\000\000\240\377\223\032\330\177\000\000xf\027\242\374\177\000\000tf\027\242\374\177\000\000\000\000\000\000\000\000\000\000\020f\027\242\374\177\000\000\202\213\034! V\000\000\370v\030! V\000\000@g\027\242\374\177\000\0008g\027\242\374\177\000\000\225[\362\001\000\000\000", __ss_align = 140566128522400}, salen = 2}} [20:48:07.336] i = 0 [20:48:07.336] now = [20:48:07.336] last_lockfile_recheck_time = 1725741853 [20:48:07.336] last_touch_time = 1725741853 [20:48:07.336] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7fd81ace92e0}, {pos = -1575524680, events = 0, fd = 0, user_data = 0x7fd81ace9668}, {pos = 555518850, events = 22048, fd = 449746536, user_data = 0x7fd81a287630}, {pos = 449745632, events = 32728, fd = 2090263927, user_data = 0x7ffca21767c0}, {pos = 449575496, events = 32728, fd = 15, user_data = 0x7fd81a287630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 449745632, events = 32728, fd = -1575524552, user_data = 0x7ffca2176740}, {pos = 449746536, events = 32728, fd = 0, user_data = 0x5620245b3368}, {pos = 609956424, events = 22048, fd = 609955873, user_data = 0x7fd800000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7fd81942e020}, {pos = 445906848, events = 32728, fd = 609956712, user_data = 0x7ffca2176b30}, {pos = 609927880, events = 22048, fd = 609956944, user_data = 0x5620245b3368}, {pos = 449745632, events = 32728, fd = 438, user_data = 0x56202296edb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x562024584a48}, {pos = 449601214, events = 32728, fd = 1, user_data = 0x0}, {pos = 423813152, events = 32728, fd = 424619456, user_data = 0x7ffca2176ba0}, {pos = -1575523456, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 449610170, user_data = 0x0}, {pos = 424340772, events = 32728, fd = 0, user_data = 0x562022ffaf60 }, {pos = 2, events = 0, fd = 7, user_data = 0x562024546e50}, {pos = 0, events = 0, fd = 423847112, user_data = 0x7fd81949c880 }, {pos = 432242104, events = 32728, fd = 8096, user_data = 0x100007f00000002}, {pos = 424373895, events = 32728, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 425663584, events = 32728, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x562024546e50}, {pos = 424376842, events = 32728, fd = 1663923061, user_data = 0x562024546e50}, {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 = 0x55616a350a313220}, {pos = 1634624624, events = 10, fd = 0, user_data = 0xffffff0000000000}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x7f0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x2f48555780f47a00}, {pos = 425649632, events = 32728, fd = -328, user_data = 0x0}, {pos = 609956104, events = 22048, fd = 1024, user_data = 0x5620245b3108}, {pos = -1575523272, events = 32764, fd = 424378015, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 25383, events = 0, fd = -328, user_data = 0x0}, {pos = 609765960, events = 22048, fd = 424619987, user_data = 0x7ffca2176c38}, {pos = 574796332, events = 22048, fd = 587240816, user_data = 0x562022419ce9 }, {pos = 609955904, events = 22048, fd = 609765680, user_data = 0x5620245b3040}, {pos = 424367851, events = 32728, fd = 0, user_data = 0x56202242b953 }, {pos = 609955904, events = 1, fd = 574798492, user_data = 0x562024584930}, {pos = -2131461632, events = 793269591, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 424290993, user_data = 0x7fd8194a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2131461632, user_data = 0x56202455c060}, {pos = -2131461632, events = 793269591, fd = 11, user_data = 0x2f48555780f47a00}, {pos = 0, events = 0, fd = 423998009, user_data = 0x1}, {pos = 570378509, events = 22048, fd = 4194304, user_data = 0x562022419b7d }, {pos = 609599584, events = 22048, fd = 609765680, user_data = 0x56202455c060}, {pos = 1, events = 0, fd = 0, user_data = 0x56202242b953 }, {pos = 609599584, events = 22048, fd = 574798492, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x562021e2d255 }, {pos = 0, events = 0, fd = 568534421, user_data = 0xb}, {pos = 570399658, events = 22048, fd = 583651408, user_data = 0x5620245852d8}} [20:48:07.336] nevents = 1 [20:48:07.336] __func__ = "ServerLoop" [20:48:07.336] #22 0x0000562021ffc394 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x562024542cc0) at ../src/backend/postmaster/postmaster.c:1346 [20:48:07.336] opt = [20:48:07.336] status = [20:48:07.336] userDoption = [20:48:07.336] listen_addr_saved = false [20:48:07.336] output_config_variable = [20:48:07.336] __func__ = "PostmasterMain" [20:48:07.336] #23 0x0000562021e3d631 in main (argc=4, argv=0x562024542cc0) at ../src/backend/main/main.c:197 [20:48:07.336] do_check_root = [20:48:07.377] -e [20:48:07.377] [20:48:07.377] [20:48:07.445] dumping /tmp/cores/postgres-6-28443.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:48:07.703] [New LWP 28443] [20:48:07.703] [20:48:07.703] This GDB supports auto-downloading debuginfo from the following URLs: [20:48:07.703] [20:48:07.703] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:48:07.703] Debuginfod has been disabled. [20:48:07.703] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:48:07.813] [Thread debugging using libthread_db enabled] [20:48:07.813] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:48:07.813] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [20:48:07.813] Program terminated with signal SIGABRT, Aborted. [20:48:07.813] #0 0x00007f47538a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:08.738] [20:48:08.738] Thread 1 (Thread 0x7f47535d4f00 (LWP 28443)): [20:48:08.738] #0 0x00007f47538a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:08.738] No symbol table info available. [20:48:08.738] #1 0x00007f475385afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:08.738] No symbol table info available. [20:48:08.738] #2 0x00007f4753845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:08.738] No symbol table info available. [20:48:08.738] #3 0x000055d991e94d96 in ExceptionalCondition (conditionName=conditionName@entry=0x55d992105505 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55d992104a70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [20:48:08.738] No locals. [20:48:08.738] #4 0x000055d991824c10 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55d99485b860, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [20:48:08.738] estate = 0x55d994780620 [20:48:08.738] oldcontext = 0x55d994840c20 [20:48:08.738] __func__ = "standard_ExecutorStart" [20:48:08.738] #5 0x000055d991824dec in ExecutorStart (queryDesc=queryDesc@entry=0x55d99485b860, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [20:48:08.738] No locals. [20:48:08.738] #6 0x000055d99174bf16 in refresh_matview_datafill (dest=0x55d994814168, query=, query@entry=0x55d994851db0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [20:48:08.738] rewritten = [20:48:08.738] plan = 0x55d994888890 [20:48:08.738] queryDesc = 0x55d99485b860 [20:48:08.738] copied_query = [20:48:08.738] processed = [20:48:08.738] __func__ = "refresh_matview_datafill" [20:48:08.738] #7 0x000055d99174e2c7 in RefreshMatViewByOid (matviewOid=27439, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [20:48:08.738] dest = [20:48:08.738] matviewRel = 0x7f4747d24f38 [20:48:08.738] rule = [20:48:08.738] actions = [20:48:08.738] dataQuery = 0x55d994851db0 [20:48:08.738] tableSpace = [20:48:08.738] relowner = 10 [20:48:08.738] OIDNewHeap = 27448 [20:48:08.738] processed = 0 [20:48:08.738] relpersistence = 112 'p' [20:48:08.738] save_userid = 10 [20:48:08.738] save_sec_context = 0 [20:48:08.738] save_nestlevel = 2 [20:48:08.738] address = {classId = 0, objectId = 0, objectSubId = 0} [20:48:08.738] __func__ = "RefreshMatViewByOid" [20:48:08.738] #8 0x000055d99174e406 in ExecRefreshMatView (stmt=0x55d99485d498, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:48:08.738] matviewOid = [20:48:08.738] lockmode = [20:48:08.738] #9 0x000055d991705acd in ExecCreateTableAs (pstate=pstate@entry=0x55d994840d20, stmt=stmt@entry=0x55d9946ac7e0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe6a9ea690) at ../src/backend/commands/createas.c:350 [20:48:08.738] refresh = [20:48:08.738] query = 0x55d9946ac9a0 [20:48:08.738] into = 0x55d9946ac538 [20:48:08.738] is_matview = true [20:48:08.738] do_refresh = false [20:48:08.738] dest = [20:48:08.738] address = {classId = 1259, objectId = 27439, objectSubId = 0} [20:48:08.738] __func__ = "ExecCreateTableAs" [20:48:08.738] #10 0x000055d991c104a9 in ProcessUtilitySlow (pstate=pstate@entry=0x55d994840d20, pstmt=pstmt@entry=0x55d9946ac890, queryString=queryString@entry=0x55d9946abaa0 "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=0x55d9946ad2c8, qc=0x7ffe6a9ea690) at ../src/backend/tcop/utility.c:1675 [20:48:08.738] _save_exception_stack = 0x7ffe6a9ea550 [20:48:08.738] _save_context_stack = 0x0 [20:48:08.738] _local_sigjmp_buf = {{__jmpbuf = {0, -2143514974294836572, 94392986290144, 0, 94392986286752, 0, -5327958933995980124, -2143503241648342364}, __mask_was_saved = 0, __saved_mask = {__val = {139944132846976, 10569, 94392941039244, 1, 4294977865, 139944132846976, 94392941029562, 1, 45396000247768, 1, 10569, 139944132846976, 139944132846976, 1, 94392941039591, 94392987160536}}}} [20:48:08.738] _do_rethrow = false [20:48:08.738] parsetree = 0x55d9946ac7e0 [20:48:08.738] isTopLevel = true [20:48:08.738] isCompleteQuery = true [20:48:08.738] needCleanup = false [20:48:08.738] commandCollected = false [20:48:08.738] address = {classId = 21977, objectId = 2490025952, objectSubId = 21977} [20:48:08.738] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:48:08.738] __func__ = "ProcessUtilitySlow" [20:48:08.738] #11 0x000055d991c0eaba in standard_ProcessUtility (pstmt=0x55d9946ac890, queryString=0x55d9946abaa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55d9946ad2c8, qc=0x7ffe6a9ea690) at ../src/backend/tcop/utility.c:1067 [20:48:08.738] parsetree = 0x55d9946ac7e0 [20:48:08.738] isTopLevel = true [20:48:08.738] isAtomicContext = false [20:48:08.738] pstate = 0x55d994840d20 [20:48:08.738] readonly_flags = [20:48:08.738] __func__ = "standard_ProcessUtility" [20:48:08.738] #12 0x000055d991c0ec15 in ProcessUtility (pstmt=pstmt@entry=0x55d9946ac890, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55d9946ad2c8, qc=0x7ffe6a9ea690) at ../src/backend/tcop/utility.c:523 [20:48:08.738] No locals. [20:48:08.738] #13 0x000055d991c0a481 in PortalRunUtility (portal=portal@entry=0x55d99472e040, pstmt=pstmt@entry=0x55d9946ac890, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d9946ad2c8, qc=qc@entry=0x7ffe6a9ea690) at ../src/backend/tcop/pquery.c:1158 [20:48:08.738] No locals. [20:48:08.738] #14 0x000055d991c0aa26 in PortalRunMulti (portal=portal@entry=0x55d99472e040, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55d9946ad2c8, altdest=altdest@entry=0x55d9946ad2c8, qc=qc@entry=0x7ffe6a9ea690) at ../src/backend/tcop/pquery.c:1316 [20:48:08.738] pstmt = 0x55d9946ac890 [20:48:08.738] stmtlist_item__state = [20:48:08.738] active_snapshot_set = false [20:48:08.738] stmtlist_item = 0x55d9946ad290 [20:48:08.738] #15 0x000055d991c0aff9 in PortalRun (portal=portal@entry=0x55d99472e040, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55d9946ad2c8, altdest=altdest@entry=0x55d9946ad2c8, qc=0x7ffe6a9ea690) at ../src/backend/tcop/pquery.c:791 [20:48:08.738] _save_exception_stack = 0x7ffe6a9ea740 [20:48:08.738] _save_context_stack = 0x0 [20:48:08.738] _local_sigjmp_buf = {{__jmpbuf = {0, -2143514973951952220, 94392986820672, 94392986290264, 94392986820672, 94392986290192, -5327958934109226332, -2143503243754538332}, __mask_was_saved = 0, __saved_mask = {__val = {94392944524472, 94392986286496, 112, 4, 94392944528889, 1788782111, 4, 94392986290192, 112, 73, 94392986820672, 94392986290264, 94392986290240, 94392986290192, 94392944616092, 1}}}} [20:48:08.738] _do_rethrow = [20:48:08.738] result = [20:48:08.738] nprocessed = [20:48:08.738] saveTopTransactionResourceOwner = 0x55d9946eacf8 [20:48:08.738] saveTopTransactionContext = 0x55d99473fc50 [20:48:08.738] saveActivePortal = 0x0 [20:48:08.738] saveResourceOwner = 0x55d9946eacf8 [20:48:08.738] savePortalContext = 0x0 [20:48:08.738] saveMemoryContext = 0x55d99473fc50 [20:48:08.738] __func__ = "PortalRun" [20:48:08.738] #16 0x000055d991c04695 in exec_simple_query (query_string=query_string@entry=0x55d9946abaa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [20:48:08.738] cmdtaglen = 24 [20:48:08.738] snapshot_set = [20:48:08.738] per_parsetree_context = 0x0 [20:48:08.738] plantree_list = 0x55d9946ad278 [20:48:08.738] parsetree = 0x55d9946ac810 [20:48:08.738] commandTag = [20:48:08.738] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:48:08.738] querytree_list = [20:48:08.738] portal = 0x55d99472e040 [20:48:08.738] receiver = 0x55d9946ad2c8 [20:48:08.738] format = 0 [20:48:08.738] cmdtagname = [20:48:08.738] parsetree_item__state = [20:48:08.738] dest = DestRemote [20:48:08.738] oldcontext = 0x55d99473fc50 [20:48:08.738] parsetree_list = 0x55d9946ac840 [20:48:08.738] parsetree_item = 0x55d9946ac858 [20:48:08.738] save_log_statement_stats = false [20:48:08.738] was_logged = false [20:48:08.738] use_implicit_block = false [20:48:08.738] msec_str = "\360\250\236j\376\177\000\000\276\252\353\221\331U\000\000 \247\236j\376\177\000\000G\000\000\000\000\000\000" [20:48:08.738] __func__ = "exec_simple_query" [20:48:08.738] #17 0x000055d991c0716e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [20:48:08.738] query_string = 0x55d9946abaa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:48:08.738] firstchar = [20:48:08.738] input_message = {data = 0x55d9946abaa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:48:08.738] local_sigjmp_buf = {{__jmpbuf = {94392957052344, -2143508982171632988, 4, 140730687203568, 140730687203712, 140730687203716, -5327958934063088988, -2143503237230298460}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94392986017184, 15616, 94392957046432, 94392986541232, 140730687203712, 94392944528437, 0, 9, 2, 94392957052352, 94392986017184, 94392957046432, 140730687203568, 140730687203712, 140730687203716}}}} [20:48:08.738] send_ready_for_query = false [20:48:08.738] idle_in_transaction_timeout_enabled = false [20:48:08.738] idle_session_timeout_enabled = false [20:48:08.738] __func__ = "PostgresMain" [20:48:08.738] #18 0x000055d991bfd290 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:48:08.738] bsdata = [20:48:08.738] #19 0x000055d991ab5c10 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe6a9ea89c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe6a9ea8f0) at ../src/backend/postmaster/launch_backend.c:274 [20:48:08.738] pid = [20:48:08.738] #20 0x000055d991abb6bc in BackendStartup (client_sock=client_sock@entry=0x7ffe6a9ea8f0) at ../src/backend/postmaster/postmaster.c:3415 [20:48:08.738] bn = 0x55d9946d4158 [20:48:08.738] pid = [20:48:08.738] startup_data = {canAcceptConnections = CAC_OK} [20:48:08.738] __func__ = "BackendStartup" [20:48:08.738] #21 0x000055d991abbc1e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [20:48:08.738] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\202SG\177\000\000\264\251\236j\376\177\000\000\312\000\bUG\177\000\000>\004\000\000\000\000\000\000\260\227\203SG\177\000\000\240\217\323TG\177\000\000\270\251\236j\376\177\000\000\264\251\236j\376\177\000\000\000\000\000\000\000\000\000\000P\251\236j\376\177\000\000\202\233Ȑ\331U\000\000\370\206Đ\331U\000\000\200\252\236j\376\177\000\000x\252\236j\376\177\000\000\225[\362\001\000\000\000", __ss_align = 139944335545504}, salen = 2}} [20:48:08.738] i = 0 [20:48:08.738] now = [20:48:08.738] last_lockfile_recheck_time = 1725741851 [20:48:08.738] last_touch_time = 1725741851 [20:48:08.738] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f47550aa2e0}, {pos = 1788783096, events = 0, fd = 0, user_data = 0x7f47550aa668}, {pos = -1865901182, events = 21977, fd = 1426761320, user_data = 0x7f4754689630}, {pos = 1426760416, events = 32583, fd = 2090263927, user_data = 0x7ffe6a9eab00}, {pos = 1426590280, events = 32583, fd = 15, user_data = 0x7f4754689630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1426760416, events = 32583, fd = 1788783224, user_data = 0x7ffe6a9eaa80}, {pos = 1426761320, events = 32583, fd = 0, user_data = 0x55d9946d8738}, {pos = -1804761576, events = 21977, fd = -1804752847, user_data = 0x7f4700000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f475382e020}, {pos = 1423151008, events = 32583, fd = -1804761288, user_data = 0x7ffe6a9eae70}, {pos = -1804760920, events = 21977, fd = -1804791136, user_data = 0x55d9946d8738}, {pos = 1426760416, events = 32583, fd = 438, user_data = 0x55d99242fdb0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55d9946abb60}, {pos = 1426615998, events = 32583, fd = 1, user_data = 0x0}, {pos = 1401085984, events = 32583, fd = 1401892288, user_data = 0x7ffe6a9eaee0}, {pos = 1788784320, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1426624954, user_data = 0x0}, {pos = 1401613604, events = 32583, fd = 0, user_data = 0x55d992abbf60 }, {pos = 2, events = 0, fd = 7, user_data = 0x55d99466de40}, {pos = 0, events = 0, fd = 1401119944, user_data = 0x7f475389c880 }, {pos = 1398623672, events = 32583, fd = 8096, user_data = 0x100007f00000002}, {pos = 1401647085, events = 32583, fd = 2, user_data = 0x55d9946d7400}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 1402936416, events = 32583, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55d99466de40}, {pos = 1401649674, events = 32583, fd = 1549556828, user_data = 0x55d99466de40}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294901760, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x435756442d737365}, {pos = 168452427, events = 908075040, fd = 822763892, user_data = 0x30340a3135383134}, {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 = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x806c28f54d898e00}, {pos = 1402922464, events = 32583, fd = -328, user_data = 0x0}, {pos = -1804761896, events = 21977, fd = 1024, user_data = 0x55d9946d84d8}, {pos = 1788784504, events = 32766, fd = 1401650847, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 24784, events = 0, fd = -328, user_data = 0x0}, {pos = -1804944544, events = 21977, fd = 1401892819, user_data = 0x7ffe6a9eaf78}, {pos = -1846623700, events = 21977, fd = -1834179216, user_data = 0x55d991edace9 }, {pos = -1804762096, events = 21977, fd = -1804944992, user_data = 0x55d9946d8410}, {pos = 1401641022, events = 32583, fd = 0, user_data = 0x55d991eec953 }, {pos = -1804762096, events = 1, fd = -1846621540, user_data = 0x55d9946ab9a0}, {pos = 1300860416, events = 2154572021, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1401563825, user_data = 0x7f47538a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1300860416, user_data = 0x55d9946830d0}, {pos = 1300860416, events = 2154572021, fd = 11, user_data = 0x806c28f54d898e00}, {pos = 0, events = 0, fd = 1401270841, user_data = 0x1}, {pos = -1851041523, events = 21977, fd = 4194304, user_data = 0x55d991edab7d }, {pos = -1805111088, events = 21977, fd = -1804944992, user_data = 0x55d9946830d0}, {pos = 1, events = 0, fd = 0, user_data = 0x55d991eec953 }, {pos = -1805111088, events = 21977, fd = -1846621540, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55d9918ee255 }, {pos = 0, events = 0, fd = -1852885611, user_data = 0xb}, {pos = -1851020374, events = 21977, fd = -1837768624, user_data = 0x55d9946ac378}} [20:48:08.738] nevents = 1 [20:48:08.738] __func__ = "ServerLoop" [20:48:08.738] #22 0x000055d991abd394 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55d994669d00) at ../src/backend/postmaster/postmaster.c:1346 [20:48:08.738] opt = [20:48:08.738] status = [20:48:08.738] userDoption = [20:48:08.738] listen_addr_saved = false [20:48:08.738] output_config_variable = [20:48:08.738] __func__ = "PostmasterMain" [20:48:08.738] #23 0x000055d9918fe631 in main (argc=8, argv=0x55d994669d00) at ../src/backend/main/main.c:197 [20:48:08.738] do_check_root = [20:48:08.777] -e [20:48:08.777] [20:48:08.777] [20:48:08.842] dumping /tmp/cores/postgres-6-35488.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:48:09.099] [New LWP 35488] [20:48:09.099] [20:48:09.099] This GDB supports auto-downloading debuginfo from the following URLs: [20:48:09.099] [20:48:09.099] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:48:09.099] Debuginfod has been disabled. [20:48:09.099] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:48:09.208] [Thread debugging using libthread_db enabled] [20:48:09.208] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:48:09.208] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [20:48:09.208] Program terminated with signal SIGABRT, Aborted. [20:48:09.208] #0 0x00007fd4b58a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:10.186] [20:48:10.186] Thread 1 (Thread 0x7fd4b57d5f00 (LWP 35488)): [20:48:10.186] #0 0x00007fd4b58a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:10.186] No symbol table info available. [20:48:10.186] #1 0x00007fd4b585afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:10.186] No symbol table info available. [20:48:10.186] #2 0x00007fd4b5845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:10.186] No symbol table info available. [20:48:10.186] #3 0x0000560b324add96 in ExceptionalCondition (conditionName=conditionName@entry=0x560b3271e505 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x560b3271da70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [20:48:10.186] No locals. [20:48:10.186] #4 0x0000560b31e3dc10 in standard_ExecutorStart (queryDesc=0x560b34c98ca0, eflags=0) at ../src/backend/executor/execMain.c:191 [20:48:10.186] estate = 0x560b34b9adc0 [20:48:10.186] oldcontext = 0x560b34be02c0 [20:48:10.186] __func__ = "standard_ExecutorStart" [20:48:10.186] #5 0x00007fd4b2fd66f7 in pgss_ExecutorStart (queryDesc=0x560b34c98ca0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:993 [20:48:10.186] No locals. [20:48:10.186] #6 0x0000560b31e3dda5 in ExecutorStart (queryDesc=queryDesc@entry=0x560b34c98ca0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:130 [20:48:10.186] No locals. [20:48:10.186] #7 0x0000560b31d64f16 in refresh_matview_datafill (dest=0x560b34c9c888, query=, query@entry=0x560b34c3d190, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [20:48:10.186] rewritten = [20:48:10.186] plan = 0x560b34c0b320 [20:48:10.186] queryDesc = 0x560b34c98ca0 [20:48:10.186] copied_query = [20:48:10.186] processed = [20:48:10.186] __func__ = "refresh_matview_datafill" [20:48:10.186] #8 0x0000560b31d672c7 in RefreshMatViewByOid (matviewOid=27318, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [20:48:10.186] dest = [20:48:10.186] matviewRel = 0x7fd4b133f0c8 [20:48:10.186] rule = [20:48:10.186] actions = [20:48:10.186] dataQuery = 0x560b34c3d190 [20:48:10.186] tableSpace = [20:48:10.186] relowner = 10 [20:48:10.186] OIDNewHeap = 27332 [20:48:10.186] processed = 0 [20:48:10.186] relpersistence = 112 'p' [20:48:10.186] save_userid = 10 [20:48:10.186] save_sec_context = 0 [20:48:10.186] save_nestlevel = 2 [20:48:10.186] address = {classId = 0, objectId = 0, objectSubId = 0} [20:48:10.186] __func__ = "RefreshMatViewByOid" [20:48:10.186] #9 0x0000560b31d67406 in ExecRefreshMatView (stmt=0x560b34c9e8e8, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:48:10.186] matviewOid = [20:48:10.186] lockmode = [20:48:10.186] #10 0x0000560b31d1eacd in ExecCreateTableAs (pstate=pstate@entry=0x560b34be03c0, stmt=stmt@entry=0x560b34acf790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff3cfa4140) at ../src/backend/commands/createas.c:350 [20:48:10.186] refresh = [20:48:10.186] query = 0x560b34acf950 [20:48:10.186] into = 0x560b34acf4e8 [20:48:10.186] is_matview = true [20:48:10.186] do_refresh = false [20:48:10.186] dest = [20:48:10.186] address = {classId = 1259, objectId = 27318, objectSubId = 0} [20:48:10.186] __func__ = "ExecCreateTableAs" [20:48:10.186] #11 0x0000560b322294a9 in ProcessUtilitySlow (pstate=pstate@entry=0x560b34be03c0, pstmt=pstmt@entry=0x560b34acf840, queryString=queryString@entry=0x560b34acea50 "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=0x560b34ad07e8, qc=0x7fff3cfa4140) at ../src/backend/tcop/utility.c:1675 [20:48:10.186] _save_exception_stack = 0x7fff3cfa3cf0 [20:48:10.186] _save_context_stack = 0x0 [20:48:10.186] _local_sigjmp_buf = {{__jmpbuf = {0, -6240156388791153923, 94606128379792, 0, 94606128376400, 0, -392215043376674051, -6240142116764120323}, __mask_was_saved = 0, __saved_mask = {__val = {4, 2, 94606085946372, 1023031688, 94606085184121, 0, 0, 94606091221248, 94606085436848, 140551486030720, 1, 16777216, 0, 112, 94606085184393, 140551486754816}}}} [20:48:10.186] _do_rethrow = false [20:48:10.186] parsetree = 0x560b34acf790 [20:48:10.186] isTopLevel = true [20:48:10.186] isCompleteQuery = true [20:48:10.186] needCleanup = false [20:48:10.186] commandCollected = false [20:48:10.186] address = {classId = 22027, objectId = 883750800, objectSubId = 22027} [20:48:10.186] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:48:10.186] __func__ = "ProcessUtilitySlow" [20:48:10.186] #12 0x0000560b32227aba in standard_ProcessUtility (pstmt=pstmt@entry=0x560b34acf840, queryString=queryString@entry=0x560b34acea50 "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=0x560b34ad07e8, qc=0x7fff3cfa4140) at ../src/backend/tcop/utility.c:1067 [20:48:10.186] parsetree = 0x560b34acf790 [20:48:10.186] isTopLevel = true [20:48:10.186] isAtomicContext = false [20:48:10.186] pstate = 0x560b34be03c0 [20:48:10.186] readonly_flags = [20:48:10.186] __func__ = "standard_ProcessUtility" [20:48:10.186] #13 0x00007fd4b2fd9d4a in pgss_ProcessUtility (pstmt=0x560b34acf840, queryString=0x560b34acea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x560b34ad07e8, qc=0x7fff3cfa4140) at ../contrib/pg_stat_statements/pg_stat_statements.c:1167 [20:48:10.186] _save_exception_stack = 0x7fff3cfa4000 [20:48:10.186] _save_context_stack = 0x0 [20:48:10.186] _local_sigjmp_buf = {{__jmpbuf = {0, 392072147930450685, 94606128379968, 94606128383976, 140734216421696, 0, -392215043489920259, -371108875231687939}, __mask_was_saved = 0, __saved_mask = {__val = {94606088992110, 140734216420966, 140734216420964, 0, 0, 139637976727552, 206158430232, 140734216420928, 94606088992327, 0, 206158430232, 94606128380768, 140734216421024, 0, 94606083848644, 94606128376144}}}} [20:48:10.186] _do_rethrow = false [20:48:10.186] duration = [20:48:10.186] bufusage = {shared_blks_hit = 94606129213944, shared_blks_read = 47244640256, shared_blks_dirtied = 0, shared_blks_written = 94606129213448, local_blks_hit = 94606129213944, local_blks_read = 94606082192865, local_blks_dirtied = 94606129671464, local_blks_written = 94606082193111, temp_blks_read = 94606129213448, temp_blks_written = 94606129212864, shared_blk_read_time = {ticks = 94606082192220}, shared_blk_write_time = {ticks = 94606088985562}, local_blk_read_time = {ticks = 140551554686392}, local_blk_write_time = {ticks = 94606128376400}, temp_blk_read_time = {ticks = 94606091292645}, temp_blk_write_time = {ticks = 94606101189698}} [20:48:10.186] walusage_start = {wal_records = 8930, wal_fpi = 133, wal_bytes = 1218337} [20:48:10.186] start = [20:48:10.186] rows = [20:48:10.186] bufusage_start = {shared_blks_hit = 33524, shared_blks_read = 3777, shared_blks_dirtied = 1583, shared_blks_written = 1009, 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}} [20:48:10.186] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 140551486030720} [20:48:10.186] parsetree = [20:48:10.186] saved_queryId = 6041762721901209185 [20:48:10.186] saved_stmt_location = 0 [20:48:10.186] saved_stmt_len = 69 [20:48:10.186] enabled = true [20:48:10.186] #14 0x0000560b32227b60 in ProcessUtility (pstmt=pstmt@entry=0x560b34acf840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x560b34ad07e8, qc=0x7fff3cfa4140) at ../src/backend/tcop/utility.c:519 [20:48:10.186] No locals. [20:48:10.186] #15 0x0000560b32223481 in PortalRunUtility (portal=portal@entry=0x560b34b4ff90, pstmt=pstmt@entry=0x560b34acf840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560b34ad07e8, qc=qc@entry=0x7fff3cfa4140) at ../src/backend/tcop/pquery.c:1158 [20:48:10.186] No locals. [20:48:10.186] #16 0x0000560b32223a26 in PortalRunMulti (portal=portal@entry=0x560b34b4ff90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560b34ad07e8, altdest=altdest@entry=0x560b34ad07e8, qc=qc@entry=0x7fff3cfa4140) at ../src/backend/tcop/pquery.c:1316 [20:48:10.186] pstmt = 0x560b34acf840 [20:48:10.186] stmtlist_item__state = [20:48:10.186] active_snapshot_set = false [20:48:10.186] stmtlist_item = 0x560b34ad07b0 [20:48:10.186] #17 0x0000560b32223ff9 in PortalRun (portal=portal@entry=0x560b34b4ff90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x560b34ad07e8, altdest=altdest@entry=0x560b34ad07e8, qc=0x7fff3cfa4140) at ../src/backend/tcop/pquery.c:791 [20:48:10.186] _save_exception_stack = 0x7fff3cfa41f0 [20:48:10.186] _save_context_stack = 0x0 [20:48:10.186] _local_sigjmp_buf = {{__jmpbuf = {0, -6240156401656132867, 94606128906128, 94606128379912, 94606128906128, 94606128379840, -392215043634623747, -6240142114690692355}, __mask_was_saved = 0, __saved_mask = {__val = {94606088670392, 94606128376144, 112, 4, 94606088674809, 1023033551, 4, 94606128379840, 112, 73, 94606128906128, 94606128379912, 94606128379888, 94606128379840, 94606088762012, 1}}}} [20:48:10.186] _do_rethrow = [20:48:10.186] result = [20:48:10.186] nprocessed = [20:48:10.186] saveTopTransactionResourceOwner = 0x560b34b0f450 [20:48:10.186] saveTopTransactionContext = 0x560b34b623c0 [20:48:10.186] saveActivePortal = 0x0 [20:48:10.186] saveResourceOwner = 0x560b34b0f450 [20:48:10.186] savePortalContext = 0x0 [20:48:10.186] saveMemoryContext = 0x560b34b623c0 [20:48:10.186] __func__ = "PortalRun" [20:48:10.186] #18 0x0000560b3221d695 in exec_simple_query (query_string=query_string@entry=0x560b34acea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [20:48:10.186] cmdtaglen = 24 [20:48:10.186] snapshot_set = [20:48:10.186] per_parsetree_context = 0x0 [20:48:10.186] plantree_list = 0x560b34ad0798 [20:48:10.186] parsetree = 0x560b34acf7c0 [20:48:10.186] commandTag = [20:48:10.186] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:48:10.186] querytree_list = [20:48:10.186] portal = 0x560b34b4ff90 [20:48:10.186] receiver = 0x560b34ad07e8 [20:48:10.186] format = 0 [20:48:10.186] cmdtagname = [20:48:10.186] parsetree_item__state = [20:48:10.186] dest = DestRemote [20:48:10.186] oldcontext = 0x560b34b623c0 [20:48:10.186] parsetree_list = 0x560b34acf7f0 [20:48:10.186] parsetree_item = 0x560b34acf808 [20:48:10.186] save_log_statement_stats = false [20:48:10.186] was_logged = true [20:48:10.186] use_implicit_block = false [20:48:10.186] msec_str = "\240C\372<\377\177\000\000\276:M2\vV\000\000\320A\372<\377\177\000\000G\000\000\000\000\000\000" [20:48:10.186] __func__ = "exec_simple_query" [20:48:10.186] #19 0x0000560b3222016e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [20:48:10.186] query_string = 0x560b34acea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:48:10.186] firstchar = [20:48:10.186] input_message = {data = 0x560b34acea50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:48:10.186] local_sigjmp_buf = {{__jmpbuf = {94606101198264, -6240144554461754627, 4, 140734216422304, 140734216422448, 140734216422452, -392215047455634691, -6240142138126365955}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94606128625984, 0, 168, 94606088674911, 0, 10, 2, 94606101198272, 94606128106992, 94606101192352, 140734216422304, 140734216422448, 140734216422452}}}} [20:48:10.186] send_ready_for_query = false [20:48:10.186] idle_in_transaction_timeout_enabled = false [20:48:10.186] idle_session_timeout_enabled = false [20:48:10.186] __func__ = "PostgresMain" [20:48:10.186] #20 0x0000560b32216290 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:48:10.186] bsdata = [20:48:10.186] #21 0x0000560b320cec10 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff3cfa434c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff3cfa43a0) at ../src/backend/postmaster/launch_backend.c:274 [20:48:10.186] pid = [20:48:10.186] #22 0x0000560b320d46bc in BackendStartup (client_sock=client_sock@entry=0x7fff3cfa43a0) at ../src/backend/postmaster/postmaster.c:3415 [20:48:10.186] bn = 0x560b34afb1f8 [20:48:10.186] pid = [20:48:10.186] startup_data = {canAcceptConnections = CAC_OK} [20:48:10.186] __func__ = "BackendStartup" [20:48:10.186] #23 0x0000560b320d4c1e in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [20:48:10.186] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\372<\377\177\000\0004D\372<\377\177", '\000' , "\202+*1\vV\000\000\370\026&1\vV\000\000\000E\372<\377\177\000\000\370D\372<\377\177\000\000\225[\362\001\000\000\000\000p\212\2574\vV\000\000,", '\000' , "\227**1\vV\000\000hF\036\267\324\177\000\0000V\003\266\324\177\000", __ss_align = 140551582008032}, salen = 2}} [20:48:10.186] i = 0 [20:48:10.186] now = [20:48:10.186] last_lockfile_recheck_time = 1725741885 [20:48:10.186] last_touch_time = 1725741885 [20:48:10.186] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 824847234, events = 22027, fd = -1222752664, user_data = 0x7fd4b6035630}, {pos = -1222753568, events = 32724, fd = 2090263927, user_data = 0x7fff3cfa4580}, {pos = -1222923704, events = 32724, fd = 15, user_data = 0x7fd4b6035630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1222753568, events = 32724, fd = 1023034616, user_data = 0x7fff3cfa4500}, {pos = -1222752664, events = 32724, fd = 0, user_data = 0x560b34ad0890}, {pos = 844362844, events = 22027, fd = 32768, user_data = 0x1}, {pos = 883750256, events = 22027, fd = -1, user_data = 0x7fd4b582e020}, {pos = -1227673696, events = 32724, fd = 883925768, user_data = 0x560b34afa1e8}, {pos = 883943569, events = 22027, fd = -1222897986, user_data = 0x1}, {pos = -1222753568, events = 32724, fd = 438, user_data = 0x560b32a48db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x560b34ad0890}, {pos = -1222897986, events = 32724, fd = 1, user_data = 0x0}, {pos = -1249714144, events = 32724, fd = -1248907840, user_data = 0x10}, {pos = 1023035760, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1222889030, user_data = 0x0}, {pos = -1249186524, events = 32724, fd = 0, user_data = 0x560b330d4f60 }, {pos = 2, events = 0, fd = 7, user_data = 0x560b34a90e90}, {pos = 840635387, events = 22027, fd = 883964251, user_data = 0x560b321b5034 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x560b34ad0890}, {pos = -1222897986, events = 32724, fd = 1, user_data = 0x0}, {pos = -1249680184, events = 32724, fd = -1249261440, user_data = 0x41e}, {pos = -1249153043, events = 32724, fd = 2, user_data = 0x560b34b03900}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -1247863712, events = 32724, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa67}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -1241291456, user_data = 0x7fd4b6036a80}, {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 = 844041400, events = 22027, fd = 883939472, user_data = 0x7fd4b58b583e}, {pos = -1247880736, events = 32724, fd = -1249242770, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xb354a308d188ff00}, {pos = -1247877664, events = 32724, 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 = 883925160, user_data = 0x560b324f157b }, {pos = 883924960, events = 22027, fd = 3, user_data = 0x0}, {pos = 31932, events = 0, fd = -328, user_data = 0x0}, {pos = 883755152, events = 22027, fd = -1248907309, user_data = 0x7fff3cfa4a28}, {pos = 844124716, events = 22027, fd = 856569200, user_data = 0x560b324f3ce9 }, {pos = 883924960, events = 22027, fd = 883747152, user_data = 0x560b34af9fe0}, {pos = -1249159106, events = 32724, fd = 0, user_data = 0x560b32505953 }, {pos = 883924960, events = 1, fd = 844126876, user_data = 0x560b34ace950}, {pos = -779550976, events = 3008668424, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1249236303, user_data = 0x7fd4b58a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -779550976, user_data = 0x560b34aa6080}, {pos = -779550976, events = 3008668424, fd = 11, user_data = 0xb354a308d188ff00}, {pos = 0, events = 0, fd = -1249529287, user_data = 0x1}, {pos = 839706893, events = 22027, fd = 4194304, user_data = 0x560b324f3b7d }, {pos = 883581056, events = 22027, fd = 883747152, user_data = 0x560b34aa6080}, {pos = 1, events = 0, fd = 0, user_data = 0x560b32505953 }, {pos = 883581056, events = 22027, fd = 844126876, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x560b31f07255 }, {pos = 0, events = 0, fd = 837862805, user_data = 0xb}, {pos = 839728042, events = 22027, fd = 852979792, user_data = 0x560b34acf308}} [20:48:10.186] nevents = 1 [20:48:10.186] __func__ = "ServerLoop" [20:48:10.186] #24 0x0000560b320d6394 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x560b34a8ccf0) at ../src/backend/postmaster/postmaster.c:1346 [20:48:10.186] opt = [20:48:10.186] status = [20:48:10.186] userDoption = [20:48:10.186] listen_addr_saved = false [20:48:10.186] output_config_variable = [20:48:10.186] __func__ = "PostmasterMain" [20:48:10.186] #25 0x0000560b31f17631 in main (argc=4, argv=0x560b34a8ccf0) at ../src/backend/main/main.c:197 [20:48:10.186] do_check_root = [20:48:10.221] -e [20:48:10.221] [20:48:10.221] [20:48:10.280] dumping /tmp/cores/sh-3-35492.core for /bin/sh [20:48:10.327] [20:48:10.327] This GDB supports auto-downloading debuginfo from the following URLs: [20:48:10.327] [20:48:10.327] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [20:48:10.327] Debuginfod has been disabled. [20:48:10.327] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [20:48:10.331] [New LWP 35492] [20:48:10.333] [Thread debugging using libthread_db enabled] [20:48:10.333] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:48:10.333] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/042_low_level_backup/data'. [20:48:10.333] Program terminated with signal SIGQUIT, Quit. [20:48:10.333] #0 0x00007f5d09510b13 in wait4 () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:10.336] [20:48:10.336] Thread 1 (Thread 0x7f5d0943a740 (LWP 35492)): [20:48:10.336] #0 0x00007f5d09510b13 in wait4 () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:10.336] No symbol table info available. [20:48:10.336] #1 0x000055f86f232cc0 in ?? () [20:48:10.336] No symbol table info available. [20:48:10.336] #2 0x000055f86f232efa in ?? () [20:48:10.336] No symbol table info available. [20:48:10.336] #3 0x000055f86f234630 in ?? () [20:48:10.336] No symbol table info available. [20:48:10.336] #4 0x000055f86f22e371 in ?? () [20:48:10.336] No symbol table info available. [20:48:10.336] #5 0x000055f86f22d20f in ?? () [20:48:10.336] No symbol table info available. [20:48:10.336] #6 0x000055f86f22dc3b in ?? () [20:48:10.336] No symbol table info available. [20:48:10.336] #7 0x000055f86f22b66f in ?? () [20:48:10.336] No symbol table info available. [20:48:10.336] #8 0x00007f5d0946424a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:10.336] No symbol table info available. [20:48:10.336] #9 0x00007f5d09464305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [20:48:10.336] No symbol table info available. [20:48:10.336] #10 0x000055f86f22b781 in ?? () [20:48:10.336] No symbol table info available.