[19:32:03.813] src/tools/ci/cores_backtrace.sh linux /tmp/cores [19:32:04.024] dumping /tmp/cores/postgres-6-28667.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [19:32:04.279] [New LWP 28667] [19:32:04.279] [19:32:04.279] This GDB supports auto-downloading debuginfo from the following URLs: [19:32:04.279] [19:32:04.279] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [19:32:04.279] Debuginfod has been disabled. [19:32:04.279] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [19:32:04.407] [Thread debugging using libthread_db enabled] [19:32:04.407] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [19:32:04.407] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [19:32:04.407] Program terminated with signal SIGABRT, Aborted. [19:32:04.407] #0 0x00007f608cea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:05.374] [19:32:05.374] Thread 1 (Thread 0x7f608cdd9f00 (LWP 28667)): [19:32:05.374] #0 0x00007f608cea9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:05.374] No symbol table info available. [19:32:05.374] #1 0x00007f608ce5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:05.374] No symbol table info available. [19:32:05.374] #2 0x00007f608ce45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:05.374] No symbol table info available. [19:32:05.374] #3 0x0000557571eadbf3 in ExceptionalCondition (conditionName=conditionName@entry=0x55757211e505 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55757211da70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [19:32:05.374] No locals. [19:32:05.374] #4 0x000055757183dcb2 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5575746f9bf0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [19:32:05.374] estate = 0x55757465c620 [19:32:05.374] oldcontext = 0x557574730150 [19:32:05.374] __func__ = "standard_ExecutorStart" [19:32:05.374] #5 0x000055757183de8e in ExecutorStart (queryDesc=queryDesc@entry=0x5575746f9bf0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [19:32:05.374] No locals. [19:32:05.374] #6 0x0000557571764e99 in refresh_matview_datafill (dest=0x5575746e6888, query=, query@entry=0x5575746a47d0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [19:32:05.374] rewritten = [19:32:05.374] plan = 0x5575746e5480 [19:32:05.374] queryDesc = 0x5575746f9bf0 [19:32:05.374] copied_query = [19:32:05.374] processed = [19:32:05.374] __func__ = "refresh_matview_datafill" [19:32:05.374] #7 0x0000557571767200 in RefreshMatViewByOid (matviewOid=27402, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [19:32:05.374] dest = [19:32:05.374] matviewRel = 0x7f6081482fb8 [19:32:05.374] rule = [19:32:05.374] actions = [19:32:05.374] dataQuery = 0x5575746a47d0 [19:32:05.374] tableSpace = [19:32:05.374] relowner = 10 [19:32:05.374] OIDNewHeap = 27424 [19:32:05.374] processed = 0 [19:32:05.374] relpersistence = 112 'p' [19:32:05.374] save_userid = 10 [19:32:05.374] save_sec_context = 0 [19:32:05.374] save_nestlevel = 2 [19:32:05.374] address = {classId = 0, objectId = 0, objectSubId = 0} [19:32:05.374] __func__ = "RefreshMatViewByOid" [19:32:05.374] #8 0x000055757176733f in ExecRefreshMatView (stmt=0x5575746e7918, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:32:05.374] matviewOid = [19:32:05.374] lockmode = [19:32:05.374] #9 0x000055757171eacd in ExecCreateTableAs (pstate=pstate@entry=0x557574730250, stmt=stmt@entry=0x5575745887e0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffc5a9a0b0) at ../src/backend/commands/createas.c:350 [19:32:05.374] refresh = [19:32:05.374] query = 0x5575745889a0 [19:32:05.374] into = 0x557574588538 [19:32:05.374] is_matview = true [19:32:05.374] do_refresh = false [19:32:05.374] dest = [19:32:05.374] address = {classId = 1259, objectId = 27402, objectSubId = 0} [19:32:05.374] __func__ = "ExecCreateTableAs" [19:32:05.374] #10 0x0000557571c29545 in ProcessUtilitySlow (pstate=pstate@entry=0x557574730250, pstmt=pstmt@entry=0x557574588890, queryString=queryString@entry=0x557574587aa0 "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=0x5575745892c8, qc=0x7fffc5a9a0b0) at ../src/backend/tcop/utility.c:1675 [19:32:05.374] _save_exception_stack = 0x7fffc5a99f70 [19:32:05.374] _save_context_stack = 0x0 [19:32:05.374] _local_sigjmp_buf = {{__jmpbuf = {0, -4504818808617287748, 93962951493600, 0, 93962951490208, 0, -7751037134022230084, -4504830956563316804}, __mask_was_saved = 0, __saved_mask = {__val = {140052471126144, 9557, 93962907541288, 1, 4294976853, 140052471126144, 93962907531606, 1, 41048955277272, 1, 9557, 140052471126144, 140052471126144, 1, 93962907541635, 93962952363992}}}} [19:32:05.374] _do_rethrow = false [19:32:05.374] parsetree = 0x5575745887e0 [19:32:05.374] isTopLevel = true [19:32:05.374] isCompleteQuery = true [19:32:05.374] needCleanup = false [19:32:05.374] commandCollected = false [19:32:05.374] address = {classId = 21877, objectId = 1951959008, objectSubId = 21877} [19:32:05.374] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:32:05.374] __func__ = "ProcessUtilitySlow" [19:32:05.374] #11 0x0000557571c27b56 in standard_ProcessUtility (pstmt=0x557574588890, queryString=0x557574587aa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5575745892c8, qc=0x7fffc5a9a0b0) at ../src/backend/tcop/utility.c:1067 [19:32:05.374] parsetree = 0x5575745887e0 [19:32:05.374] isTopLevel = true [19:32:05.374] isAtomicContext = false [19:32:05.374] pstate = 0x557574730250 [19:32:05.374] readonly_flags = [19:32:05.374] __func__ = "standard_ProcessUtility" [19:32:05.374] #12 0x0000557571c27cb1 in ProcessUtility (pstmt=pstmt@entry=0x557574588890, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5575745892c8, qc=0x7fffc5a9a0b0) at ../src/backend/tcop/utility.c:523 [19:32:05.374] No locals. [19:32:05.374] #13 0x0000557571c2351d in PortalRunUtility (portal=portal@entry=0x55757460a040, pstmt=pstmt@entry=0x557574588890, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5575745892c8, qc=qc@entry=0x7fffc5a9a0b0) at ../src/backend/tcop/pquery.c:1158 [19:32:05.374] No locals. [19:32:05.374] #14 0x0000557571c23ac2 in PortalRunMulti (portal=portal@entry=0x55757460a040, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5575745892c8, altdest=altdest@entry=0x5575745892c8, qc=qc@entry=0x7fffc5a9a0b0) at ../src/backend/tcop/pquery.c:1316 [19:32:05.374] pstmt = 0x557574588890 [19:32:05.374] stmtlist_item__state = [19:32:05.374] active_snapshot_set = false [19:32:05.374] stmtlist_item = 0x557574589290 [19:32:05.374] #15 0x0000557571c24095 in PortalRun (portal=portal@entry=0x55757460a040, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5575745892c8, altdest=altdest@entry=0x5575745892c8, qc=0x7fffc5a9a0b0) at ../src/backend/tcop/pquery.c:791 [19:32:05.374] _save_exception_stack = 0x7fffc5a9a160 [19:32:05.374] _save_context_stack = 0x0 [19:32:05.374] _local_sigjmp_buf = {{__jmpbuf = {0, -4504818809497043012, 93962952024128, 93962951493720, 93962952024128, 93962951493648, -7751037134152253508, -4504830958784593988}, __mask_was_saved = 0, __saved_mask = {__val = {93962911025941, 93962951489952, 112, 4, 93962911030358, 3316228159, 4, 93962951493648, 112, 73, 93962952024128, 93962951493720, 93962951493696, 93962951493648, 93962911117561, 1}}}} [19:32:05.374] _do_rethrow = [19:32:05.374] result = [19:32:05.374] nprocessed = [19:32:05.374] saveTopTransactionResourceOwner = 0x5575745c6cf8 [19:32:05.374] saveTopTransactionContext = 0x55757461bc50 [19:32:05.374] saveActivePortal = 0x0 [19:32:05.374] saveResourceOwner = 0x5575745c6cf8 [19:32:05.374] savePortalContext = 0x0 [19:32:05.374] saveMemoryContext = 0x55757461bc50 [19:32:05.374] __func__ = "PortalRun" [19:32:05.374] #16 0x0000557571c1d731 in exec_simple_query (query_string=query_string@entry=0x557574587aa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [19:32:05.374] cmdtaglen = 24 [19:32:05.374] snapshot_set = [19:32:05.374] per_parsetree_context = 0x0 [19:32:05.374] plantree_list = 0x557574589278 [19:32:05.374] parsetree = 0x557574588810 [19:32:05.374] commandTag = [19:32:05.374] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:32:05.374] querytree_list = [19:32:05.374] portal = 0x55757460a040 [19:32:05.374] receiver = 0x5575745892c8 [19:32:05.374] format = 0 [19:32:05.374] cmdtagname = [19:32:05.374] parsetree_item__state = [19:32:05.374] dest = DestRemote [19:32:05.374] oldcontext = 0x55757461bc50 [19:32:05.374] parsetree_list = 0x557574588840 [19:32:05.374] parsetree_item = 0x557574588858 [19:32:05.374] save_log_statement_stats = false [19:32:05.374] was_logged = false [19:32:05.374] use_implicit_block = false [19:32:05.374] msec_str = "\020\243\251\305\377\177\000\000\0339\355quU\000\000@\241\251\305\377\177\000\000G\000\000\000\000\000\000" [19:32:05.374] __func__ = "exec_simple_query" [19:32:05.374] #17 0x0000557571c2020a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [19:32:05.374] query_string = 0x557574587aa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:32:05.374] firstchar = [19:32:05.374] input_message = {data = 0x557574587aa0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:32:05.374] local_sigjmp_buf = {{__jmpbuf = {93962923554648, -4504823640415649860, 4, 140736509616912, 140736509617056, 140736509617060, -7751037132612943940, -4504830960737042500}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93962951220640, 15616, 93962923548736, 93962951744688, 140736509617056, 93962911029906, 0, 9, 2, 93962923554656, 93962951220640, 93962923548736, 140736509616912, 140736509617056, 140736509617060}}}} [19:32:05.374] send_ready_for_query = false [19:32:05.374] idle_in_transaction_timeout_enabled = false [19:32:05.374] idle_session_timeout_enabled = false [19:32:05.374] __func__ = "PostgresMain" [19:32:05.374] #18 0x0000557571c1632c in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:32:05.374] bsdata = [19:32:05.374] #19 0x0000557571acecac in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffc5a9a2bc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffc5a9a310) at ../src/backend/postmaster/launch_backend.c:274 [19:32:05.374] pid = [19:32:05.374] #20 0x0000557571ad4758 in BackendStartup (client_sock=client_sock@entry=0x7fffc5a9a310) at ../src/backend/postmaster/postmaster.c:3415 [19:32:05.374] bn = 0x5575745b0388 [19:32:05.374] pid = [19:32:05.374] startup_data = {canAcceptConnections = CAC_OK} [19:32:05.374] __func__ = "BackendStartup" [19:32:05.374] #21 0x0000557571ad4cba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:32:05.374] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\343\214`\177\000\000\240/؍`\177\000\000\270\243\251\305\377\177\000\000\264\243\251\305\377\177", '\000' , "\272+\312puU\000\000\000\027\306puU\000\000\200\244\251\305\377\177\000\000x\244\251\305\377\177\000\000\225[\362\001\000\000\000\000\240\324c\215`\177\000\000+", '\000' , "uU\000\000\317*\312puU\000", __ss_align = 140052684187240}, salen = 2}} [19:32:05.374] i = 0 [19:32:05.374] now = [19:32:05.374] last_lockfile_recheck_time = 1725910095 [19:32:05.374] last_touch_time = 1725910095 [19:32:05.374] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x557570ca2bba}, {pos = -1904368024, events = 32608, fd = -1922836944, user_data = 0x7f608e7da2e0}, {pos = 2090263927, events = 0, fd = -978737920, user_data = 0x7f608e7b0a48}, {pos = 15, events = 0, fd = -1922836944, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f608e7da2e0}, {pos = -978738056, events = 32767, fd = -978738048, user_data = 0x7f608e7da668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 1951963296, events = 21877, fd = 1, user_data = 0x7fffc5a9a9a3}, {pos = -1, events = 0, fd = -1931288544, user_data = 0x7f608dd82fa0}, {pos = 1952139064, events = 21877, fd = 1952138776, user_data = 0x5575745b6831}, {pos = -1904513346, events = 32608, fd = 1, user_data = 0x7f608e7da2e0}, {pos = 438, events = 0, fd = 1917095344, user_data = 0x0}, {pos = 1, events = 0, fd = 1951955808, user_data = 0x7f608e7b6ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f608ce2e020}, {pos = -1930482240, events = 32608, fd = 16, user_data = 0x7fffc5a9a8e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1904504390, events = 32608, fd = 0, user_data = 0x7f608ceaed24 }, {pos = 0, events = 0, fd = 1923961088, user_data = 0x2}, {pos = 7, events = 0, fd = 1951702592, user_data = 0x557571bb50d0 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 1951955808, user_data = 0x7f608e7b6ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f608ce364c8}, {pos = -1930727443, events = 32608, fd = 1924011616, user_data = 0x5575745b3400}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1929438112, events = 32608, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x342020200a0a4e6e}, {pos = 822763892, events = 959787575, fd = 959459377, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {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 = 1952141344, user_data = 0x7f608ceb56eb}, {pos = -1929455136, events = 32608, fd = -1930817170, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x76e6c4e60792f700}, {pos = -1929452064, events = 32608, fd = -328, user_data = 0x0}, {pos = 1952138456, events = 21877, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1952138256, events = 21877, fd = 3, user_data = 0x0}, {pos = 25093, events = 0, fd = -328, user_data = 0x0}, {pos = 1951955808, events = 21877, fd = -1930481709, user_data = 0x7fffc5a9a998}, {pos = 1911574665, events = 21877, fd = 1924019984, user_data = 0x557571ef3b46 }, {pos = 1952138256, events = 21877, fd = 1951955360, user_data = 0x5575745b4410}, {pos = -1930733506, events = 32608, fd = 0, user_data = 0x557571f057b0 }, {pos = 1952138256, events = 1, fd = 1911576825, user_data = 0x5575745879a0}, {pos = 127072000, events = 1994835174, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1930810703, user_data = 0x7f608cea14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 127072000, user_data = 0x55757455f0d0}, {pos = 127072000, events = 1994835174, fd = 11, user_data = 0x76e6c4e60792f700}, {pos = 0, events = 0, fd = -1931103687, user_data = 0x1}, {pos = 1907157417, events = 21877, fd = 4194304, user_data = 0x557571ef39da }, {pos = 1951789264, events = 21877, fd = 1951955360, user_data = 0x55757455f0d0}, {pos = 1, events = 0, fd = 0, user_data = 0x557571f057b0 }, {pos = 1951789264, events = 21877, fd = 1911576825, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x5575719072f7 }, {pos = 0, events = 0, fd = 1905313335, user_data = 0xb}, {pos = 1907178566, events = 21877, fd = 1920430448, user_data = 0x557574588378}} [19:32:05.375] nevents = 1 [19:32:05.375] __func__ = "ServerLoop" [19:32:05.375] #22 0x0000557571ad6430 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x557574545d00) at ../src/backend/postmaster/postmaster.c:1346 [19:32:05.375] opt = [19:32:05.375] status = [19:32:05.375] userDoption = [19:32:05.375] listen_addr_saved = false [19:32:05.375] output_config_variable = [19:32:05.375] __func__ = "PostmasterMain" [19:32:05.375] #23 0x00005575719176d3 in main (argc=8, argv=0x557574545d00) at ../src/backend/main/main.c:197 [19:32:05.375] do_check_root = [19:32:05.412] -e [19:32:05.412] [19:32:05.412] [19:32:05.475] dumping /tmp/cores/postgres-6-29671.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:32:05.723] [New LWP 29671] [19:32:05.723] [19:32:05.723] This GDB supports auto-downloading debuginfo from the following URLs: [19:32:05.723] [19:32:05.723] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [19:32:05.723] Debuginfod has been disabled. [19:32:05.723] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [19:32:05.832] [Thread debugging using libthread_db enabled] [19:32:05.832] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [19:32:05.832] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [19:32:05.832] Program terminated with signal SIGABRT, Aborted. [19:32:05.832] #0 0x00007f59a36a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:06.766] [19:32:06.766] Thread 1 (Thread 0x7f59a4486f00 (LWP 29671)): [19:32:06.766] #0 0x00007f59a36a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:06.766] No symbol table info available. [19:32:06.766] #1 0x00007f59a365afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:06.766] No symbol table info available. [19:32:06.766] #2 0x00007f59a3645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:06.766] No symbol table info available. [19:32:06.766] #3 0x000055f6ed5fbbf3 in ExceptionalCondition (conditionName=conditionName@entry=0x55f6ed86c505 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55f6ed86ba70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [19:32:06.766] No locals. [19:32:06.766] #4 0x000055f6ecf8bcb2 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55f6ee5538f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:191 [19:32:06.766] estate = 0x55f6ee520620 [19:32:06.766] oldcontext = 0x55f6ee50d460 [19:32:06.766] __func__ = "standard_ExecutorStart" [19:32:06.766] #5 0x000055f6ecf8be8e in ExecutorStart (queryDesc=queryDesc@entry=0x55f6ee5538f0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:132 [19:32:06.766] No locals. [19:32:06.766] #6 0x000055f6eceb2e99 in refresh_matview_datafill (dest=0x55f6ee52b8d8, query=, query@entry=0x55f6ee597400, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [19:32:06.766] rewritten = [19:32:06.766] plan = 0x55f6ee551ca0 [19:32:06.766] queryDesc = 0x55f6ee5538f0 [19:32:06.766] copied_query = [19:32:06.766] processed = [19:32:06.766] __func__ = "refresh_matview_datafill" [19:32:06.766] #7 0x000055f6eceb5200 in RefreshMatViewByOid (matviewOid=27324, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [19:32:06.766] dest = [19:32:06.766] matviewRel = 0x7f5997fea0c8 [19:32:06.766] rule = [19:32:06.766] actions = [19:32:06.766] dataQuery = 0x55f6ee597400 [19:32:06.766] tableSpace = [19:32:06.766] relowner = 10 [19:32:06.766] OIDNewHeap = 27335 [19:32:06.766] processed = 0 [19:32:06.766] relpersistence = 112 'p' [19:32:06.766] save_userid = 10 [19:32:06.766] save_sec_context = 0 [19:32:06.766] save_nestlevel = 2 [19:32:06.766] address = {classId = 0, objectId = 0, objectSubId = 0} [19:32:06.766] __func__ = "RefreshMatViewByOid" [19:32:06.766] #8 0x000055f6eceb533f in ExecRefreshMatView (stmt=0x55f6ee586208, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:32:06.766] matviewOid = [19:32:06.766] lockmode = [19:32:06.766] #9 0x000055f6ece6cacd in ExecCreateTableAs (pstate=pstate@entry=0x55f6ee50d560, stmt=stmt@entry=0x55f6ee3f1770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffe7f611580) at ../src/backend/commands/createas.c:350 [19:32:06.766] refresh = [19:32:06.766] query = 0x55f6ee3f1930 [19:32:06.766] into = 0x55f6ee3f14c8 [19:32:06.766] is_matview = true [19:32:06.766] do_refresh = false [19:32:06.766] dest = [19:32:06.766] address = {classId = 1259, objectId = 27324, objectSubId = 0} [19:32:06.766] __func__ = "ExecCreateTableAs" [19:32:06.766] #10 0x000055f6ed377545 in ProcessUtilitySlow (pstate=pstate@entry=0x55f6ee50d560, pstmt=pstmt@entry=0x55f6ee3f1820, queryString=queryString@entry=0x55f6ee3f0a30 "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=0x55f6ee3f2258, qc=0x7ffe7f611580) at ../src/backend/tcop/utility.c:1675 [19:32:06.766] _save_exception_stack = 0x7ffe7f611440 [19:32:06.766] _save_context_stack = 0x0 [19:32:06.766] _local_sigjmp_buf = {{__jmpbuf = {0, -6998715969604175324, 94519047427952, 0, 94519047424560, 0, -3832930158390298076, -6998709301858420188}, __mask_was_saved = 0, __saved_mask = {__val = {140022784362176, 13266, 94519029579560, 1, 4294980562, 140022784362176, 94519033379383, 140022985027000, 94519047424560, 94519035686885, 94519045584354, 94519045584480, 140731035488900, 94519035881368, 94519045584369, 94519045584480}}}} [19:32:06.766] _do_rethrow = false [19:32:06.766] parsetree = 0x55f6ee3f1770 [19:32:06.766] isTopLevel = true [19:32:06.766] isCompleteQuery = true [19:32:06.766] needCleanup = false [19:32:06.766] commandCollected = false [19:32:06.766] address = {classId = 22006, objectId = 3997112176, objectSubId = 22006} [19:32:06.766] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:32:06.766] __func__ = "ProcessUtilitySlow" [19:32:06.766] #11 0x000055f6ed375b56 in standard_ProcessUtility (pstmt=0x55f6ee3f1820, queryString=0x55f6ee3f0a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55f6ee3f2258, qc=0x7ffe7f611580) at ../src/backend/tcop/utility.c:1067 [19:32:06.766] parsetree = 0x55f6ee3f1770 [19:32:06.766] isTopLevel = true [19:32:06.766] isAtomicContext = false [19:32:06.766] pstate = 0x55f6ee50d560 [19:32:06.766] readonly_flags = [19:32:06.766] __func__ = "standard_ProcessUtility" [19:32:06.766] #12 0x000055f6ed375cb1 in ProcessUtility (pstmt=pstmt@entry=0x55f6ee3f1820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55f6ee3f2258, qc=0x7ffe7f611580) at ../src/backend/tcop/utility.c:523 [19:32:06.766] No locals. [19:32:06.766] #13 0x000055f6ed37151d in PortalRunUtility (portal=portal@entry=0x55f6ee473680, pstmt=pstmt@entry=0x55f6ee3f1820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f6ee3f2258, qc=qc@entry=0x7ffe7f611580) at ../src/backend/tcop/pquery.c:1158 [19:32:06.766] No locals. [19:32:06.766] #14 0x000055f6ed371ac2 in PortalRunMulti (portal=portal@entry=0x55f6ee473680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55f6ee3f2258, altdest=altdest@entry=0x55f6ee3f2258, qc=qc@entry=0x7ffe7f611580) at ../src/backend/tcop/pquery.c:1316 [19:32:06.766] pstmt = 0x55f6ee3f1820 [19:32:06.766] stmtlist_item__state = [19:32:06.766] active_snapshot_set = false [19:32:06.766] stmtlist_item = 0x55f6ee3f2220 [19:32:06.766] #15 0x000055f6ed372095 in PortalRun (portal=portal@entry=0x55f6ee473680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55f6ee3f2258, altdest=altdest@entry=0x55f6ee3f2258, qc=0x7ffe7f611580) at ../src/backend/tcop/pquery.c:791 [19:32:06.766] _save_exception_stack = 0x7ffe7f611630 [19:32:06.766] _save_context_stack = 0x0 [19:32:06.766] _local_sigjmp_buf = {{__jmpbuf = {0, -6998715967671649756, 94519047960192, 94519047428072, 94519047960192, 94519047428000, -3832930158528710108, -6998709303944431068}, __mask_was_saved = 0, __saved_mask = {__val = {94519033064213, 94519047424304, 112, 4, 94519033068630, 2137068815, 4, 94519047428000, 112, 73, 94519047960192, 94519047428072, 94519047428048, 94519047428000, 94519033155833, 1}}}} [19:32:06.766] _do_rethrow = [19:32:06.766] result = [19:32:06.766] nprocessed = [19:32:06.766] saveTopTransactionResourceOwner = 0x55f6ee430838 [19:32:06.766] saveTopTransactionContext = 0x55f6ee484660 [19:32:06.766] saveActivePortal = 0x0 [19:32:06.766] saveResourceOwner = 0x55f6ee430838 [19:32:06.766] savePortalContext = 0x0 [19:32:06.766] saveMemoryContext = 0x55f6ee484660 [19:32:06.766] __func__ = "PortalRun" [19:32:06.766] #16 0x000055f6ed36b731 in exec_simple_query (query_string=query_string@entry=0x55f6ee3f0a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [19:32:06.766] cmdtaglen = 24 [19:32:06.766] snapshot_set = [19:32:06.766] per_parsetree_context = 0x0 [19:32:06.766] plantree_list = 0x55f6ee3f2208 [19:32:06.766] parsetree = 0x55f6ee3f17a0 [19:32:06.766] commandTag = [19:32:06.766] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:32:06.766] querytree_list = [19:32:06.766] portal = 0x55f6ee473680 [19:32:06.766] receiver = 0x55f6ee3f2258 [19:32:06.766] format = 0 [19:32:06.766] cmdtagname = [19:32:06.766] parsetree_item__state = [19:32:06.766] dest = DestRemote [19:32:06.766] oldcontext = 0x55f6ee484660 [19:32:06.766] parsetree_list = 0x55f6ee3f17d0 [19:32:06.766] parsetree_item = 0x55f6ee3f17e8 [19:32:06.766] save_log_statement_stats = false [19:32:06.766] was_logged = true [19:32:06.766] use_implicit_block = false [19:32:06.766] msec_str = "\340\027a\177\376\177\000\000\033\031b\355\366U\000\000\020\026a\177\376\177\000\000G\000\000\000\000\000\000" [19:32:06.766] __func__ = "exec_simple_query" [19:32:06.766] #17 0x000055f6ed36e20a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [19:32:06.766] query_string = 0x55f6ee3f0a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:32:06.766] firstchar = [19:32:06.766] input_message = {data = 0x55f6ee3f0a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:32:06.766] local_sigjmp_buf = {{__jmpbuf = {94519045592920, -6998716072524006876, 4, 140731035490272, 140731035490416, 140731035490420, -3832930158725842396, -6998709288842839516}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94519047155120, 14336, 94519045587008, 94519047682032, 140731035490416, 94519033068178, 0, 9, 2, 94519045592928, 94519047155120, 94519045587008, 140731035490272, 140731035490416, 140731035490420}}}} [19:32:06.766] send_ready_for_query = false [19:32:06.766] idle_in_transaction_timeout_enabled = false [19:32:06.766] idle_session_timeout_enabled = false [19:32:06.766] __func__ = "PostgresMain" [19:32:06.766] #18 0x000055f6ed36432c in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:32:06.766] bsdata = [19:32:06.766] #19 0x000055f6ed21ccac in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe7f61178c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe7f6117e0) at ../src/backend/postmaster/launch_backend.c:274 [19:32:06.766] pid = [19:32:06.766] #20 0x000055f6ed222758 in BackendStartup (client_sock=client_sock@entry=0x7ffe7f6117e0) at ../src/backend/postmaster/postmaster.c:3415 [19:32:06.766] bn = 0x55f6ee4258e8 [19:32:06.766] pid = [19:32:06.766] startup_data = {canAcceptConnections = CAC_OK} [19:32:06.766] __func__ = "BackendStartup" [19:32:06.766] #21 0x000055f6ed222cba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:32:06.766] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "a\177\376\177\000\000t\030a\177\376\177", '\000' , "\272\v?\354\366U\000\000\000\367:\354\366U\000\000@\031a\177\376\177\000\0008\031a\177\376\177\000\000\225[\362\001\000\000\000\000\240\264\262\244Y\177\000\000+", '\000' , "\317\n?\354\366U\000\000hf\004\245Y\177\000\0000\266\262\244Y\177\000", __ss_align = 140022997344992}, salen = 2}} [19:32:06.766] i = 0 [19:32:06.766] now = [19:32:06.766] last_lockfile_recheck_time = 1725910097 [19:32:06.766] last_touch_time = 1725910097 [19:32:06.766] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -331412550, events = 22006, fd = -1526438296, user_data = 0x7f59a4b2b630}, {pos = -1526439200, events = 32601, fd = 2090263927, user_data = 0x7ffe7f6119c0}, {pos = -1526609336, events = 32601, fd = 15, user_data = 0x7f59a4b2b630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1526439200, events = 32601, fd = 2137069880, user_data = 0x7ffe7f611940}, {pos = -1526438296, events = 32601, fd = 0, user_data = 0x55f6ee3f0a48}, {pos = -311897415, events = 22006, fd = 32768, user_data = 0x1}, {pos = -297850896, events = 22006, fd = -1, user_data = 0x7f59a362e020}, {pos = -1531359328, events = 32601, fd = -297667736, user_data = 0x55f6ee41f248}, {pos = -297668575, events = 22006, fd = -1526583618, user_data = 0x1}, {pos = -1526439200, events = 32601, fd = 438, user_data = 0x55f6edb96db0 }, {pos = 0, events = 0, fd = 1, user_data = 0x55f6ee3f0a48}, {pos = -1526583618, events = 32601, fd = 1, user_data = 0x0}, {pos = -1553801184, events = 32601, fd = -1552994880, user_data = 0x10}, {pos = 2137071024, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1526574662, user_data = 0x0}, {pos = -1553273564, events = 32601, fd = 0, user_data = 0x55f6ee223100 }, {pos = 2, events = 0, fd = 7, user_data = 0x55f6ee3b2e50}, {pos = -315624297, events = 22006, fd = -297650165, user_data = 0x55f6ed3030d0 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55f6ee3f0a48}, {pos = -1526583618, events = 32601, fd = 1, user_data = 0x0}, {pos = -1553767224, events = 32601, fd = -1553348480, user_data = 0x41e}, {pos = -1553240441, events = 32601, fd = 2, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -1551950752, events = 32601, 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 = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = -312218859, events = 22006, fd = -297694656, user_data = 0x7f59a36b56eb}, {pos = -1551967776, events = 32601, fd = -1553329810, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x897239411d35a400}, {pos = -1551964704, events = 32601, 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 = -297668344, user_data = 0x55f6ed63f3d8 }, {pos = -297668544, events = 22006, fd = 3, user_data = 0x0}, {pos = 25685, events = 0, fd = -328, user_data = 0x0}, {pos = -297858488, events = 22006, fd = -1552994349, user_data = 0x7ffe7f611e68}, {pos = -312135543, events = 22006, fd = -299690224, user_data = 0x55f6ed641b46 }, {pos = -297668544, events = 22006, fd = -297858768, user_data = 0x55f6ee41f040}, {pos = -1553246485, events = 32601, fd = 0, user_data = 0x55f6ed6537b0 }, {pos = -297668544, events = 1, fd = -312133383, user_data = 0x55f6ee3f0930}, {pos = 490054656, events = 2305964353, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1553323343, user_data = 0x7f59a36a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 490054656, user_data = 0x55f6ee3c8060}, {pos = 490054656, events = 2305964353, fd = 11, user_data = 0x897239411d35a400}, {pos = 0, events = 0, fd = -1553616327, user_data = 0x1}, {pos = -316552791, events = 22006, fd = 4194304, user_data = 0x55f6ed6419da }, {pos = -298024864, events = 22006, fd = -297858768, user_data = 0x55f6ee3c8060}, {pos = 1, events = 0, fd = 0, user_data = 0x55f6ed6537b0 }, {pos = -298024864, events = 22006, fd = -312133383, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55f6ed0552f7 }, {pos = 0, events = 0, fd = -318396873, user_data = 0xb}, {pos = -316531642, events = 22006, fd = -303279760, user_data = 0x55f6ee3f12d8}} [19:32:06.766] nevents = 1 [19:32:06.766] __func__ = "ServerLoop" [19:32:06.766] #22 0x000055f6ed224430 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55f6ee3aecc0) at ../src/backend/postmaster/postmaster.c:1346 [19:32:06.766] opt = [19:32:06.766] status = [19:32:06.766] userDoption = [19:32:06.766] listen_addr_saved = false [19:32:06.766] output_config_variable = [19:32:06.766] __func__ = "PostmasterMain" [19:32:06.766] #23 0x000055f6ed0656d3 in main (argc=4, argv=0x55f6ee3aecc0) at ../src/backend/main/main.c:197 [19:32:06.766] do_check_root = [19:32:06.803] -e [19:32:06.803] [19:32:06.803] [19:32:06.866] dumping /tmp/cores/postgres-6-35622.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:32:07.132] [New LWP 35622] [19:32:07.132] [19:32:07.132] This GDB supports auto-downloading debuginfo from the following URLs: [19:32:07.132] [19:32:07.132] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [19:32:07.132] Debuginfod has been disabled. [19:32:07.132] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [19:32:07.241] [Thread debugging using libthread_db enabled] [19:32:07.241] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [19:32:07.241] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [19:32:07.241] Program terminated with signal SIGABRT, Aborted. [19:32:07.241] #0 0x00007f7e2d0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:08.177] [19:32:08.177] Thread 1 (Thread 0x7f7e2d832f00 (LWP 35622)): [19:32:08.177] #0 0x00007f7e2d0a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:08.177] No symbol table info available. [19:32:08.177] #1 0x00007f7e2d05afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:08.177] No symbol table info available. [19:32:08.177] #2 0x00007f7e2d045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [19:32:08.177] No symbol table info available. [19:32:08.177] #3 0x0000560ee6348bf3 in ExceptionalCondition (conditionName=conditionName@entry=0x560ee65b9505 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x560ee65b8a70 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [19:32:08.177] No locals. [19:32:08.177] #4 0x0000560ee5cd8cb2 in standard_ExecutorStart (queryDesc=0x560ee8d6ad60, eflags=0) at ../src/backend/executor/execMain.c:191 [19:32:08.177] estate = 0x560ee8ce8190 [19:32:08.177] oldcontext = 0x560ee8d9aef0 [19:32:08.177] __func__ = "standard_ExecutorStart" [19:32:08.177] #5 0x00007f7e2a7396f7 in pgss_ExecutorStart (queryDesc=0x560ee8d6ad60, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:993 [19:32:08.177] No locals. [19:32:08.177] #6 0x0000560ee5cd8e47 in ExecutorStart (queryDesc=queryDesc@entry=0x560ee8d6ad60, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:130 [19:32:08.177] No locals. [19:32:08.177] #7 0x0000560ee5bffe99 in refresh_matview_datafill (dest=0x560ee8db8238, query=, query@entry=0x560ee8d135e0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [19:32:08.177] rewritten = [19:32:08.177] plan = 0x560ee8d74e10 [19:32:08.177] queryDesc = 0x560ee8d6ad60 [19:32:08.177] copied_query = [19:32:08.177] processed = [19:32:08.177] __func__ = "refresh_matview_datafill" [19:32:08.177] #8 0x0000560ee5c02200 in RefreshMatViewByOid (matviewOid=27377, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [19:32:08.177] dest = [19:32:08.177] matviewRel = 0x7f7e28aa1f38 [19:32:08.177] rule = [19:32:08.177] actions = [19:32:08.177] dataQuery = 0x560ee8d135e0 [19:32:08.177] tableSpace = [19:32:08.177] relowner = 10 [19:32:08.177] OIDNewHeap = 27389 [19:32:08.177] processed = 0 [19:32:08.177] relpersistence = 112 'p' [19:32:08.177] save_userid = 10 [19:32:08.177] save_sec_context = 0 [19:32:08.177] save_nestlevel = 2 [19:32:08.177] address = {classId = 0, objectId = 0, objectSubId = 0} [19:32:08.177] __func__ = "RefreshMatViewByOid" [19:32:08.177] #9 0x0000560ee5c0233f in ExecRefreshMatView (stmt=0x560ee8db6288, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:32:08.177] matviewOid = [19:32:08.177] lockmode = [19:32:08.177] #10 0x0000560ee5bb9acd in ExecCreateTableAs (pstate=pstate@entry=0x560ee8d9aff0, stmt=stmt@entry=0x560ee8c0b790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd012251e0) at ../src/backend/commands/createas.c:350 [19:32:08.177] refresh = [19:32:08.177] query = 0x560ee8c0b950 [19:32:08.177] into = 0x560ee8c0b4e8 [19:32:08.177] is_matview = true [19:32:08.177] do_refresh = false [19:32:08.177] dest = [19:32:08.177] address = {classId = 1259, objectId = 27377, objectSubId = 0} [19:32:08.177] __func__ = "ExecCreateTableAs" [19:32:08.177] #11 0x0000560ee60c4545 in ProcessUtilitySlow (pstate=pstate@entry=0x560ee8d9aff0, pstmt=pstmt@entry=0x560ee8c0b840, queryString=queryString@entry=0x560ee8c0aa50 "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=0x560ee8c0c7e8, qc=0x7ffd012251e0) at ../src/backend/tcop/utility.c:1675 [19:32:08.177] _save_exception_stack = 0x7ffd01224d90 [19:32:08.177] _save_context_stack = 0x0 [19:32:08.177] _local_sigjmp_buf = {{__jmpbuf = {0, -397295861390700403, 94622034474896, 0, 94622034471504, 0, -6225287221695278963, -397275412688727923}, __mask_was_saved = 0, __saved_mask = {__val = {4, 2, 94621989285146, 19024424, 94621988522773, 0, 0, 94621994559744, 94621988775500, 140179828112512, 1, 16777216, 0, 112, 94621988523045, 140179829129216}}}} [19:32:08.177] _do_rethrow = false [19:32:08.177] parsetree = 0x560ee8c0b790 [19:32:08.177] isTopLevel = true [19:32:08.177] isCompleteQuery = true [19:32:08.177] needCleanup = false [19:32:08.177] commandCollected = false [19:32:08.177] address = {classId = 22030, objectId = 3904944016, objectSubId = 22030} [19:32:08.177] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:32:08.177] __func__ = "ProcessUtilitySlow" [19:32:08.177] #12 0x0000560ee60c2b56 in standard_ProcessUtility (pstmt=pstmt@entry=0x560ee8c0b840, queryString=queryString@entry=0x560ee8c0aa50 "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=0x560ee8c0c7e8, qc=0x7ffd012251e0) at ../src/backend/tcop/utility.c:1067 [19:32:08.177] parsetree = 0x560ee8c0b790 [19:32:08.177] isTopLevel = true [19:32:08.177] isAtomicContext = false [19:32:08.177] pstate = 0x560ee8d9aff0 [19:32:08.177] readonly_flags = [19:32:08.177] __func__ = "standard_ProcessUtility" [19:32:08.177] #13 0x00007f7e2a73cd4a in pgss_ProcessUtility (pstmt=0x560ee8c0b840, queryString=0x560ee8c0aa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x560ee8c0c7e8, qc=0x7ffd012251e0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1167 [19:32:08.177] _save_exception_stack = 0x7ffd012250a0 [19:32:08.177] _save_context_stack = 0x0 [19:32:08.177] _local_sigjmp_buf = {{__jmpbuf = {0, 6224348543399956621, 94622034475072, 94622034479080, 140724622479840, 0, -6225287221791747955, -6296875732409184115}, __mask_was_saved = 0, __saved_mask = {__val = {94621992330187, 140724622479110, 140724622479108, 0, 0, 139637976727552, 206158430232, 140724622479072, 94621992330404, 0, 206158430232, 94622034475872, 140724622479168, 0, 94621987187296, 94622034471248}}}} [19:32:08.177] _do_rethrow = false [19:32:08.177] duration = [19:32:08.177] bufusage = {shared_blks_hit = 94622035379656, shared_blks_read = 60129542155, shared_blks_dirtied = 0, shared_blks_written = 94622035379160, local_blks_hit = 94622035379656, local_blks_read = 94621985531523, local_blks_dirtied = 94622035953688, local_blks_written = 94621985531769, temp_blks_read = 94622035379160, temp_blks_written = 94622035378576, shared_blk_read_time = {ticks = 94621985530878}, shared_blk_write_time = {ticks = 94621992323639}, local_blk_read_time = {ticks = 140179906178488}, local_blk_write_time = {ticks = 94622034471504}, temp_blk_read_time = {ticks = 94621994631141}, temp_blk_write_time = {ticks = 94622004528610}} [19:32:08.177] walusage_start = {wal_records = 8916, wal_fpi = 130, wal_bytes = 1270515} [19:32:08.177] start = [19:32:08.177] rows = [19:32:08.177] bufusage_start = {shared_blks_hit = 33555, shared_blks_read = 3745, shared_blks_dirtied = 1539, shared_blks_written = 1023, 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}} [19:32:08.177] walusage = {wal_records = 0, wal_fpi = 11, wal_bytes = 140179828112512} [19:32:08.177] parsetree = [19:32:08.177] saved_queryId = 6041762721901209185 [19:32:08.177] saved_stmt_location = 0 [19:32:08.177] saved_stmt_len = 69 [19:32:08.177] enabled = true [19:32:08.177] #14 0x0000560ee60c2bfc in ProcessUtility (pstmt=pstmt@entry=0x560ee8c0b840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x560ee8c0c7e8, qc=0x7ffd012251e0) at ../src/backend/tcop/utility.c:519 [19:32:08.177] No locals. [19:32:08.177] #15 0x0000560ee60be51d in PortalRunUtility (portal=portal@entry=0x560ee8c8bf90, pstmt=pstmt@entry=0x560ee8c0b840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560ee8c0c7e8, qc=qc@entry=0x7ffd012251e0) at ../src/backend/tcop/pquery.c:1158 [19:32:08.177] No locals. [19:32:08.177] #16 0x0000560ee60beac2 in PortalRunMulti (portal=portal@entry=0x560ee8c8bf90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x560ee8c0c7e8, altdest=altdest@entry=0x560ee8c0c7e8, qc=qc@entry=0x7ffd012251e0) at ../src/backend/tcop/pquery.c:1316 [19:32:08.177] pstmt = 0x560ee8c0b840 [19:32:08.177] stmtlist_item__state = [19:32:08.177] active_snapshot_set = false [19:32:08.177] stmtlist_item = 0x560ee8c0c7b0 [19:32:08.177] #17 0x0000560ee60bf095 in PortalRun (portal=portal@entry=0x560ee8c8bf90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x560ee8c0c7e8, altdest=altdest@entry=0x560ee8c0c7e8, qc=0x7ffd012251e0) at ../src/backend/tcop/pquery.c:791 [19:32:08.177] _save_exception_stack = 0x7ffd01225290 [19:32:08.177] _save_context_stack = 0x0 [19:32:08.177] _local_sigjmp_buf = {{__jmpbuf = {0, -397295864592002931, 94622035001232, 94622034475016, 94622035001232, 94622034474944, -6225287222469128051, -397275462157791091}, __mask_was_saved = 0, __saved_mask = {__val = {94621992008469, 94622034471248, 112, 4, 94621992012886, 19026287, 4, 94622034474944, 112, 73, 94622035001232, 94622034475016, 94622034474992, 94622034474944, 94621992100089, 1}}}} [19:32:08.177] _do_rethrow = [19:32:08.177] result = [19:32:08.177] nprocessed = [19:32:08.177] saveTopTransactionResourceOwner = 0x560ee8c4b450 [19:32:08.177] saveTopTransactionContext = 0x560ee8c9e3c0 [19:32:08.177] saveActivePortal = 0x0 [19:32:08.177] saveResourceOwner = 0x560ee8c4b450 [19:32:08.177] savePortalContext = 0x0 [19:32:08.177] saveMemoryContext = 0x560ee8c9e3c0 [19:32:08.177] __func__ = "PortalRun" [19:32:08.177] #18 0x0000560ee60b8731 in exec_simple_query (query_string=query_string@entry=0x560ee8c0aa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [19:32:08.177] cmdtaglen = 24 [19:32:08.177] snapshot_set = [19:32:08.177] per_parsetree_context = 0x0 [19:32:08.177] plantree_list = 0x560ee8c0c798 [19:32:08.177] parsetree = 0x560ee8c0b7c0 [19:32:08.177] commandTag = [19:32:08.177] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:32:08.177] querytree_list = [19:32:08.177] portal = 0x560ee8c8bf90 [19:32:08.177] receiver = 0x560ee8c0c7e8 [19:32:08.177] format = 0 [19:32:08.177] cmdtagname = [19:32:08.177] parsetree_item__state = [19:32:08.177] dest = DestRemote [19:32:08.177] oldcontext = 0x560ee8c9e3c0 [19:32:08.177] parsetree_list = 0x560ee8c0b7f0 [19:32:08.177] parsetree_item = 0x560ee8c0b808 [19:32:08.177] save_log_statement_stats = false [19:32:08.177] was_logged = true [19:32:08.177] use_implicit_block = false [19:32:08.177] msec_str = "@T\"\001\375\177\000\000\033\3516\346\016V\000\000pR\"\001\375\177\000\000G\000\000\000\000\000\000" [19:32:08.177] __func__ = "exec_simple_query" [19:32:08.177] #19 0x0000560ee60bb20a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [19:32:08.177] query_string = 0x560ee8c0aa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:32:08.177] firstchar = [19:32:08.177] input_message = {data = 0x560ee8c0aa50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:32:08.177] local_sigjmp_buf = {{__jmpbuf = {94622004537176, -397273435181215603, 4, 140724622480448, 140724622480592, 140724622480596, -6225287222548819827, -397275459802689395}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94622034721088, 0, 168, 94621992012988, 0, 10, 2, 94622004537184, 94622034202096, 94622004531264, 140724622480448, 140724622480592, 140724622480596}}}} [19:32:08.177] send_ready_for_query = false [19:32:08.177] idle_in_transaction_timeout_enabled = false [19:32:08.177] idle_session_timeout_enabled = false [19:32:08.177] __func__ = "PostgresMain" [19:32:08.177] #20 0x0000560ee60b132c in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:32:08.177] bsdata = [19:32:08.177] #21 0x0000560ee5f69cac in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd012253ec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd01225440) at ../src/backend/postmaster/launch_backend.c:274 [19:32:08.177] pid = [19:32:08.177] #22 0x0000560ee5f6f758 in BackendStartup (client_sock=client_sock@entry=0x7ffd01225440) at ../src/backend/postmaster/postmaster.c:3415 [19:32:08.177] bn = 0x560ee8c37658 [19:32:08.177] pid = [19:32:08.177] startup_data = {canAcceptConnections = CAC_OK} [19:32:08.177] __func__ = "BackendStartup" [19:32:08.177] #23 0x0000560ee5f6fcba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:32:08.177] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\223.~\177\000\000>\004\000\000\000\000\000\000\260\227\003-~\177\000\000\240\257U.~\177\000\000\370T\"\001\375\177\000\000\364T\"\001\375\177", '\000' , "\272\333\023\345\016V\000\000\000\307\017\345\016V\000\000\300U\"\001\375\177\000\000\270U\"\001\375\177\000\000\225[\362\001\023\343\r\237pJ\303\350\016V\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [19:32:08.177] i = 0 [19:32:08.177] now = [19:32:08.177] last_lockfile_recheck_time = 1725910129 [19:32:08.177] last_touch_time = 1725910129 [19:32:08.177] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 19027456, user_data = 0x0}, {pos = 15, events = 0, fd = -451683398, user_data = 0x7f7e2e963668}, {pos = 777176624, events = 32638, fd = 781595360, user_data = 0x7c96e577}, {pos = 19027520, events = 32765, fd = 781425224, user_data = 0xf}, {pos = 777176624, events = 32638, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 781595360, user_data = 0x7ffd012255b8}, {pos = 19027392, events = 32765, fd = 781596264, user_data = 0x0}, {pos = -390023824, events = 22030, fd = 755952869, user_data = 0x7ffd01225ad3}, {pos = 1, events = 0, fd = 19027392, user_data = 0xffffffff}, {pos = 755163168, events = 32638, fd = 777367456, user_data = 0x560ee8c36308}, {pos = -389848600, events = 22030, fd = -389830511, user_data = 0x7f7e2e93febe}, {pos = 1, events = 0, fd = 781595360, user_data = 0x1b6}, {pos = -426885712, events = 22030, fd = 0, user_data = 0x1}, {pos = -390018928, events = 22030, fd = 781450942, user_data = 0x1}, {pos = 0, events = 0, fd = 755163168, user_data = 0x7f7e2d0f2dc0 }, {pos = 16, events = 0, fd = 19028496, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f7e2e9421ba}, {pos = 0, events = 0, fd = 755690788, user_data = 0x0}, {pos = -420019968, events = 22030, fd = 2, user_data = 0x7}, {pos = -390279536, events = 22030, fd = 1952410737, user_data = 0x16a}, {pos = -426886320, events = 22030, fd = 4, user_data = 0x2ffff00001fa0}, {pos = -390018928, events = 22030, fd = 781450942, user_data = 0x1}, {pos = 755724269, events = 32638, fd = 755197128, user_data = 0x560ee8c3f900}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 757013600, events = 32638, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x560ee8bcce90}, {pos = 755726858, events = 32638, fd = 0, user_data = 0x0}, {pos = -65536, events = 4294967295, fd = -1, 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 = 0x7f7e2e52d540}, {pos = 777181824, events = 32638, 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 = 756996576, events = 32638, fd = 755634542, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x9f0de3130fc9a900}, {pos = 756999648, events = 32638, fd = -328, user_data = 0x0}, {pos = -389848920, events = 22030, fd = 1024, user_data = 0x560ee8c360a8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 32200, events = 0, fd = -328, user_data = 0x0}, {pos = -390018928, events = 22030, fd = 755970003, user_data = 0x7ffd01225ac8}, {pos = -432406391, events = 22030, fd = -419961072, user_data = 0x560ee638eb46 }, {pos = -389849120, events = 22030, fd = -390026928, user_data = 0x560ee8c35fe0}, {pos = 755718206, events = 32638, fd = 0, user_data = 0x560ee63a07b0 }, {pos = -389849120, events = 1, fd = -432404231, user_data = 0x560ee8c0a950}, {pos = 264874240, events = 2668487443, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 755641009, user_data = 0x7f7e2d0a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 264874240, user_data = 0x560ee8be2080}, {pos = 264874240, events = 2668487443, fd = 11, user_data = 0x9f0de3130fc9a900}, {pos = 0, events = 0, fd = 755348025, user_data = 0x1}, {pos = -436823639, events = 22030, fd = 4194304, user_data = 0x560ee638e9da }, {pos = -390193024, events = 22030, fd = -390026928, user_data = 0x560ee8be2080}, {pos = 1, events = 0, fd = 0, user_data = 0x560ee63a07b0 }, {pos = -390193024, events = 22030, fd = -432404231, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x560ee5da22f7 }, {pos = 0, events = 0, fd = -438667721, user_data = 0xb}, {pos = -436802490, events = 22030, fd = -423550608, user_data = 0x560ee8c0b308}} [19:32:08.177] nevents = 1 [19:32:08.177] __func__ = "ServerLoop" [19:32:08.177] #24 0x0000560ee5f71430 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x560ee8bc8cf0) at ../src/backend/postmaster/postmaster.c:1346 [19:32:08.177] opt = [19:32:08.177] status = [19:32:08.177] userDoption = [19:32:08.177] listen_addr_saved = false [19:32:08.177] output_config_variable = [19:32:08.177] __func__ = "PostmasterMain" [19:32:08.177] #25 0x0000560ee5db26d3 in main (argc=4, argv=0x560ee8bc8cf0) at ../src/backend/main/main.c:197 [19:32:08.177] do_check_root =