[03:44:36.524] src/tools/ci/cores_backtrace.sh linux /tmp/cores [03:44:36.711] dumping /tmp/cores/postgres-6-30426.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:44:36.958] [New LWP 30426] [03:44:36.958] [03:44:36.958] This GDB supports auto-downloading debuginfo from the following URLs: [03:44:36.958] [03:44:36.958] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:44:36.958] Debuginfod has been disabled. [03:44:36.958] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:44:37.078] [Thread debugging using libthread_db enabled] [03:44:37.078] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:44:37.078] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:44:37.078] Program terminated with signal SIGABRT, Aborted. [03:44:37.078] #0 0x00007fc9acca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:38.115] [03:44:38.115] Thread 1 (Thread 0x7fc9ad435f00 (LWP 30426)): [03:44:38.115] #0 0x00007fc9acca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:38.115] No symbol table info available. [03:44:38.115] #1 0x00007fc9acc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:38.115] No symbol table info available. [03:44:38.115] #2 0x00007fc9acc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:38.115] No symbol table info available. [03:44:38.115] #3 0x00005606c3961744 in ExceptionalCondition (conditionName=conditionName@entry=0x5606c3be1706 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5606c3be0b30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [03:44:38.115] No locals. [03:44:38.115] #4 0x00005606c32bfc23 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5606dbaa0f40, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:203 [03:44:38.115] estate = 0x5606dbaadf50 [03:44:38.115] oldcontext = 0x5606dba5e190 [03:44:38.115] __func__ = "standard_ExecutorStart" [03:44:38.115] #5 0x00005606c32bfe02 in ExecutorStart (queryDesc=queryDesc@entry=0x5606dbaa0f40, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:142 [03:44:38.115] plan_valid = [03:44:38.115] #6 0x00005606c31dda18 in refresh_matview_datafill (dest=0x5606dbaad360, query=, query@entry=0x5606dbace090, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:44:38.115] rewritten = [03:44:38.115] plan = 0x5606dbaa0598 [03:44:38.115] queryDesc = 0x5606dbaa0f40 [03:44:38.115] copied_query = [03:44:38.115] processed = [03:44:38.115] __func__ = "refresh_matview_datafill" [03:44:38.115] #7 0x00005606c31dfdc3 in RefreshMatViewByOid (matviewOid=28779, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:44:38.115] dest = [03:44:38.115] matviewRel = 0x7fc9a151fc40 [03:44:38.115] rule = [03:44:38.115] actions = [03:44:38.115] dataQuery = 0x5606dbace090 [03:44:38.115] tableSpace = [03:44:38.115] relowner = 10 [03:44:38.115] OIDNewHeap = 28805 [03:44:38.115] processed = 0 [03:44:38.115] relpersistence = 112 'p' [03:44:38.115] save_userid = 10 [03:44:38.115] save_sec_context = 0 [03:44:38.115] save_nestlevel = 2 [03:44:38.115] address = {classId = 0, objectId = 0, objectSubId = 0} [03:44:38.115] __func__ = "RefreshMatViewByOid" [03:44:38.115] #8 0x00005606c31dff02 in ExecRefreshMatView (stmt=0x5606dbaad038, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:44:38.115] matviewOid = [03:44:38.115] lockmode = [03:44:38.115] #9 0x00005606c3195575 in ExecCreateTableAs (pstate=pstate@entry=0x5606dba5e290, stmt=stmt@entry=0x5606db939230, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcf1d375d0) at ../src/backend/commands/createas.c:351 [03:44:38.115] refresh = [03:44:38.115] query = 0x5606db9393f0 [03:44:38.115] into = 0x5606db938f88 [03:44:38.115] jstate = 0x0 [03:44:38.115] is_matview = true [03:44:38.115] do_refresh = false [03:44:38.115] dest = [03:44:38.115] address = {classId = 1259, objectId = 28779, objectSubId = 0} [03:44:38.115] __func__ = "ExecCreateTableAs" [03:44:38.115] #10 0x00005606c36ce90a in ProcessUtilitySlow (pstate=pstate@entry=0x5606dba5e290, pstmt=pstmt@entry=0x5606db9392e0, queryString=queryString@entry=0x5606db9384f0 "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=0x5606db939d18, qc=0x7ffcf1d375d0) at ../src/backend/tcop/utility.c:1678 [03:44:38.115] _save_exception_stack = 0x7ffcf1d374b0 [03:44:38.115] _save_context_stack = 0x0 [03:44:38.115] _local_sigjmp_buf = {{__jmpbuf = {0, 2328317348735442036, 94587453674032, 0, 94587453670640, 0, 8339413939230170228, 2328336493431577716}, __mask_was_saved = 0, __saved_mask = {__val = {28797, 0, 94587051781253, 140504172027320, 94587453670640, 94587054157843, 94587064417762, 94587064417888, 140724365652692, 94587054353401, 94587064417777, 94587064417888, 140724365652724, 94587054353416, 94587064417888, 0}}}} [03:44:38.115] _do_rethrow = false [03:44:38.115] parsetree = 0x5606db939230 [03:44:38.115] isTopLevel = true [03:44:38.115] isCompleteQuery = true [03:44:38.115] needCleanup = false [03:44:38.115] commandCollected = false [03:44:38.115] address = {classId = 22022, objectId = 3683881520, objectSubId = 22022} [03:44:38.115] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:44:38.115] __func__ = "ProcessUtilitySlow" [03:44:38.115] #11 0x00005606c36ccf05 in standard_ProcessUtility (pstmt=0x5606db9392e0, queryString=0x5606db9384f0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5606db939d18, qc=0x7ffcf1d375d0) at ../src/backend/tcop/utility.c:1070 [03:44:38.115] parsetree = 0x5606db939230 [03:44:38.115] isTopLevel = true [03:44:38.115] isAtomicContext = false [03:44:38.115] pstate = 0x5606dba5e290 [03:44:38.115] readonly_flags = [03:44:38.115] __func__ = "standard_ProcessUtility" [03:44:38.115] #12 0x00005606c36cd060 in ProcessUtility (pstmt=pstmt@entry=0x5606db9392e0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5606db939d18, qc=0x7ffcf1d375d0) at ../src/backend/tcop/utility.c:523 [03:44:38.115] No locals. [03:44:38.115] #13 0x00005606c36c8985 in PortalRunUtility (portal=portal@entry=0x5606db9bd480, pstmt=pstmt@entry=0x5606db9392e0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5606db939d18, qc=qc@entry=0x7ffcf1d375d0) at ../src/backend/tcop/pquery.c:1184 [03:44:38.115] No locals. [03:44:38.115] #14 0x00005606c36c8f89 in PortalRunMulti (portal=portal@entry=0x5606db9bd480, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5606db939d18, altdest=altdest@entry=0x5606db939d18, qc=qc@entry=0x7ffcf1d375d0) at ../src/backend/tcop/pquery.c:1348 [03:44:38.115] pstmt = 0x5606db9392e0 [03:44:38.115] stmtlist_item__state = [03:44:38.115] active_snapshot_set = false [03:44:38.115] stmtlist_item = 0x5606db939ce0 [03:44:38.115] query_index = 0 [03:44:38.115] #15 0x00005606c36c9508 in PortalRun (portal=portal@entry=0x5606db9bd480, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5606db939d18, altdest=altdest@entry=0x5606db939d18, qc=qc@entry=0x7ffcf1d375d0) at ../src/backend/tcop/pquery.c:819 [03:44:38.115] _save_exception_stack = 0x7ffcf1d37680 [03:44:38.115] _save_context_stack = 0x0 [03:44:38.115] _local_sigjmp_buf = {{__jmpbuf = {0, 2328317348742782068, 94587454215296, 94587453674152, 94587453674128, 94587453674080, 8339413939091758196, 2328336495476563060}, __mask_was_saved = 0, __saved_mask = {__val = {94587051465646, 4057167199, 4, 94587453674080, 112, 73, 94587454215296, 94587453674152, 94587453674128, 94587453674080, 94587051552849, 73, 2, 73, 94587040713025, 0}}}} [03:44:38.115] _do_rethrow = [03:44:38.115] result = [03:44:38.115] nprocessed = [03:44:38.115] saveTopTransactionResourceOwner = 0x5606db979f38 [03:44:38.115] saveTopTransactionContext = 0x5606db9cf4a0 [03:44:38.115] saveActivePortal = 0x0 [03:44:38.115] saveResourceOwner = 0x5606db979f38 [03:44:38.115] savePortalContext = 0x0 [03:44:38.115] saveMemoryContext = 0x5606db9cf4a0 [03:44:38.115] __func__ = "PortalRun" [03:44:38.115] #16 0x00005606c36c272e in exec_simple_query (query_string=query_string@entry=0x5606db9384f0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [03:44:38.115] cmdtaglen = 24 [03:44:38.115] snapshot_set = [03:44:38.115] per_parsetree_context = 0x0 [03:44:38.115] plantree_list = 0x5606db939cc8 [03:44:38.115] parsetree = 0x5606db939260 [03:44:38.115] commandTag = [03:44:38.115] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:44:38.115] querytree_list = [03:44:38.115] portal = 0x5606db9bd480 [03:44:38.115] receiver = 0x5606db939d18 [03:44:38.115] format = 0 [03:44:38.115] cmdtagname = [03:44:38.115] parsetree_item__state = [03:44:38.115] dest = DestRemote [03:44:38.115] oldcontext = 0x5606db9cf4a0 [03:44:38.115] parsetree_list = 0x5606db939290 [03:44:38.115] parsetree_item = 0x5606db9392a8 [03:44:38.115] save_log_statement_stats = false [03:44:38.115] was_logged = true [03:44:38.115] use_implicit_block = false [03:44:38.115] msec_str = "\004\000\000\000\000\000\000\000\271u\230\303\006V\000\000`v\323\361\374\177\000\000G\000\000\000\000\000\000" [03:44:38.115] __func__ = "exec_simple_query" [03:44:38.115] #17 0x00005606c36c5490 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4693 [03:44:38.115] query_string = 0x5606db9384f0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:44:38.115] firstchar = [03:44:38.115] input_message = {data = 0x5606db9384f0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:44:38.115] local_sigjmp_buf = {{__jmpbuf = {94587064426360, 2328334266699701364, 140724365653980, 4, 10, 140724365654212, 8339413939158867060, 2328336497363999860}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94587453401168, 16128, 94587064420416, 94587453935344, 10, 94587051465194, 0, 9, 2, 94587064426368, 94587453401168, 94587064420416, 4, 10, 140724365654212}}}} [03:44:38.115] send_ready_for_query = false [03:44:38.115] idle_in_transaction_timeout_enabled = false [03:44:38.115] idle_session_timeout_enabled = false [03:44:38.115] __func__ = "PostgresMain" [03:44:38.115] #18 0x00005606c36bb4c4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:44:38.115] bsdata = [03:44:38.115] #19 0x00005606c356a5b8 in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x7ffcf1d377dc, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcf1d37830) at ../src/backend/postmaster/launch_backend.c:274 [03:44:38.115] pid = [03:44:38.115] #20 0x00005606c356f7b3 in BackendStartup (client_sock=client_sock@entry=0x7ffcf1d37830) at ../src/backend/postmaster/postmaster.c:3519 [03:44:38.115] bn = 0x5606db960b98 [03:44:38.115] pid = [03:44:38.115] startup_data = {canAcceptConnections = CAC_OK} [03:44:38.115] cac = [03:44:38.115] __func__ = "BackendStartup" [03:44:38.115] #21 0x00005606c3571883 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:44:38.115] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\203\316l\302\006V\000\000\360\250h\302\006V\000\000\200y\323\361\374\177\000\000xy\323\361\374\177\000\000\225[\362\001\000\000\000\000\240DD\255\311\177\000\000+", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000hv`\256\311\177\000\0000FD\255\311\177\000\000\340r`\256\311\177\000\000\316)fR\000\000\000", __ss_align = 4057168320}, salen = 2}} [03:44:38.115] i = 0 [03:44:38.115] now = [03:44:38.115] last_lockfile_recheck_time = 1741318738 [03:44:38.115] last_touch_time = 1741318738 [03:44:38.115] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = -1369410848, user_data = 0x0}, {pos = -237798912, events = 32764, fd = -1369580984, user_data = 0xf}, {pos = -1388034512, events = 32713, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1369410848, user_data = 0x7ffcf1d37978}, {pos = -237799040, events = 32764, fd = -1369409944, user_data = 0x0}, {pos = -611089144, events = 22022, fd = -1395950966, user_data = 0x5606db938508}, {pos = 1, events = 22022, fd = 32768, user_data = 0xffffffff}, {pos = -1396514784, events = 32713, fd = -1374330976, user_data = 0x5606db9659f8}, {pos = -610903848, events = 22022, fd = -610904399, user_data = 0x7fc9ae5e3ebe}, {pos = 1, events = 0, fd = -1369410848, user_data = 0x1aa}, {pos = -1007518384, events = 22022, fd = 0, user_data = 0xe5}, {pos = -611089144, events = 22022, fd = -1369555266, user_data = 0x1}, {pos = 0, events = 0, fd = -1396514784, user_data = 0x7fc9accf2e40 }, {pos = 16, events = 0, fd = -237797904, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fc9ae5e61ba}, {pos = 0, events = 0, fd = -1395987036, user_data = 0x0}, {pos = -1000434688, events = 22022, fd = 2, user_data = 0x0}, {pos = -611342096, events = 22022, fd = -1016774280, user_data = 0x5606db96ae90}, {pos = -1016770291, events = 22022, fd = -610881813, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1396480824, user_data = 0x7fc9acc9c880 }, {pos = -1388094024, events = 32713, fd = -237797712, user_data = 0x100007f00000002}, {pos = -1395953555, events = 32713, fd = 2, user_data = 0x5606db96ae90}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -1394664352, events = 32713, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 170930720, events = 1835103025, fd = 1362712388, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 22016, 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 = -610898688, events = 22022, fd = 1080, user_data = 0x5606db9656d0}, {pos = -1013296403, events = 22022, fd = 1024, user_data = 0x7fc9accb58be}, {pos = -1394681376, events = 32713, fd = -1396043410, user_data = 0x100000400}, {pos = 7, events = 0, fd = -610903328, user_data = 0xebac819377ab4400}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5606db9656d0}, {pos = 1, events = 0, fd = -610904168, user_data = 0x3}, {pos = 0, events = 0, fd = 26117, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -611089144, user_data = 0x7fc9accf3053 }, {pos = -610904168, events = 22022, fd = 1024, user_data = 0x7ffcf1d37eb8}, {pos = -1013215263, events = 22022, fd = -1000333520, user_data = 0x5606c39a7a9e }, {pos = -610904368, events = 22022, fd = -611089424, user_data = 0x5606db9656d0}, {pos = -1395959618, events = 32713, fd = 0, user_data = 0x5606c39b9708 }, {pos = -610904368, events = 1, fd = -1013213103, user_data = 0x5606db9383f0}, {pos = 2007712768, events = 3953951123, fd = 0, user_data = 0x7fc9acca2ab1}, {pos = -1396042512, events = 32713, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -611342096, user_data = 0xebac819377ab4400}, {pos = 0, events = 0, fd = 2007712768, user_data = 0xc}, {pos = 2007712768, events = 3953951123, fd = 0, user_data = 0x7fc9acc5b239 }, {pos = 230, events = 0, fd = -1017732427, user_data = 0x400000}, {pos = 0, events = 0, fd = -611342096, user_data = 0x5606c39a7932 }, {pos = -611255520, events = 22022, fd = -611089424, user_data = 0x5606db90fb20}, {pos = 1, events = 0, fd = 0, user_data = 0x5606c39660ae }, {pos = 12, events = 0, fd = -610913032, user_data = 0x5606db9634d8}, {pos = -1000433280, events = 22022, fd = 296, user_data = 0x5606c356cacf }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1017716062, events = 22022, fd = -1004069648, user_data = 0x5606db938d98}} [03:44:38.116] nevents = 1 [03:44:38.116] __func__ = "ServerLoop" [03:44:38.116] #22 0x00005606c35730e2 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5606db8f6760) at ../src/backend/postmaster/postmaster.c:1386 [03:44:38.116] opt = [03:44:38.116] status = [03:44:38.116] userDoption = [03:44:38.116] listen_addr_saved = false [03:44:38.116] output_config_variable = [03:44:38.116] __func__ = "PostmasterMain" [03:44:38.116] #23 0x00005606c33a3182 in main (argc=4, argv=0x5606db8f6760) at ../src/backend/main/main.c:230 [03:44:38.116] do_check_root = [03:44:38.116] dispatch_option = [03:44:38.154] -e [03:44:38.154] [03:44:38.154] [03:44:38.220] dumping /tmp/cores/postgres-6-29474.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:44:38.470] [New LWP 29474] [03:44:38.470] [03:44:38.470] This GDB supports auto-downloading debuginfo from the following URLs: [03:44:38.470] [03:44:38.470] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:44:38.470] Debuginfod has been disabled. [03:44:38.470] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:44:38.575] [Thread debugging using libthread_db enabled] [03:44:38.575] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:44:38.575] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:44:38.575] Program terminated with signal SIGABRT, Aborted. [03:44:38.575] #0 0x00007f49a0aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:39.596] [03:44:39.596] Thread 1 (Thread 0x7f49a07d2f00 (LWP 29474)): [03:44:39.596] #0 0x00007f49a0aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:39.596] No symbol table info available. [03:44:39.596] #1 0x00007f49a0a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:39.596] No symbol table info available. [03:44:39.596] #2 0x00007f49a0a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:39.596] No symbol table info available. [03:44:39.596] #3 0x000055c8179ac744 in ExceptionalCondition (conditionName=conditionName@entry=0x55c817c2c706 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55c817c2bb30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [03:44:39.596] No locals. [03:44:39.596] #4 0x000055c81730ac23 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55c82abdbd10, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:203 [03:44:39.596] estate = 0x55c82aae3b30 [03:44:39.596] oldcontext = 0x55c82ab4fce0 [03:44:39.596] __func__ = "standard_ExecutorStart" [03:44:39.596] #5 0x000055c81730ae02 in ExecutorStart (queryDesc=queryDesc@entry=0x55c82abdbd10, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:142 [03:44:39.596] plan_valid = [03:44:39.596] #6 0x000055c817228a18 in refresh_matview_datafill (dest=0x55c82ab0f440, query=, query@entry=0x55c82ab45cc0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:44:39.596] rewritten = [03:44:39.596] plan = 0x55c82abdb368 [03:44:39.596] queryDesc = 0x55c82abdbd10 [03:44:39.596] copied_query = [03:44:39.596] processed = [03:44:39.596] __func__ = "refresh_matview_datafill" [03:44:39.596] #7 0x000055c81722adc3 in RefreshMatViewByOid (matviewOid=28887, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:44:39.596] dest = [03:44:39.596] matviewRel = 0x7f4994eebcd0 [03:44:39.596] rule = [03:44:39.596] actions = [03:44:39.596] dataQuery = 0x55c82ab45cc0 [03:44:39.596] tableSpace = [03:44:39.596] relowner = 10 [03:44:39.596] OIDNewHeap = 28895 [03:44:39.596] processed = 0 [03:44:39.596] relpersistence = 112 'p' [03:44:39.596] save_userid = 10 [03:44:39.596] save_sec_context = 0 [03:44:39.596] save_nestlevel = 2 [03:44:39.596] address = {classId = 0, objectId = 0, objectSubId = 0} [03:44:39.596] __func__ = "RefreshMatViewByOid" [03:44:39.596] #8 0x000055c81722af02 in ExecRefreshMatView (stmt=0x55c82ab0f118, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:44:39.596] matviewOid = [03:44:39.596] lockmode = [03:44:39.596] #9 0x000055c8171e0575 in ExecCreateTableAs (pstate=pstate@entry=0x55c82ab4fde0, stmt=stmt@entry=0x55c82a9b6eb0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fffa63c34f0) at ../src/backend/commands/createas.c:351 [03:44:39.596] refresh = [03:44:39.596] query = 0x55c82a9b7070 [03:44:39.596] into = 0x55c82a9b6c08 [03:44:39.596] jstate = 0x0 [03:44:39.596] is_matview = true [03:44:39.596] do_refresh = false [03:44:39.596] dest = [03:44:39.596] address = {classId = 1259, objectId = 28887, objectSubId = 0} [03:44:39.596] __func__ = "ExecCreateTableAs" [03:44:39.596] #10 0x000055c81771990a in ProcessUtilitySlow (pstate=pstate@entry=0x55c82ab4fde0, pstmt=pstmt@entry=0x55c82a9b6f60, queryString=queryString@entry=0x55c82a9b6170 "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=0x55c82a9b7998, qc=0x7fffa63c34f0) at ../src/backend/tcop/utility.c:1678 [03:44:39.596] _save_exception_stack = 0x7fffa63c33d0 [03:44:39.596] _save_context_stack = 0x0 [03:44:39.596] _local_sigjmp_buf = {{__jmpbuf = {0, -3744707730396331155, 94318196649648, 0, 94318196646256, 0, -7464934745620528275, -3744641947801664659}, __mask_was_saved = 0, __saved_mask = {__val = {28891, 0, 94317878119342, 2498673872, 94318197885464, 0, 94317874893056, 0, 94317874553745, 139954157020352, 45217415692288, 139954016219748, 94317877585791, 10528, 94317874553745, 139954008499616}}}} [03:44:39.596] _do_rethrow = false [03:44:39.596] parsetree = 0x55c82a9b6eb0 [03:44:39.596] isTopLevel = true [03:44:39.596] isCompleteQuery = true [03:44:39.596] needCleanup = false [03:44:39.596] commandCollected = false [03:44:39.596] address = {classId = 21960, objectId = 714829488, objectSubId = 21960} [03:44:39.596] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:44:39.596] __func__ = "ProcessUtilitySlow" [03:44:39.596] #11 0x000055c817717f05 in standard_ProcessUtility (pstmt=0x55c82a9b6f60, queryString=0x55c82a9b6170 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55c82a9b7998, qc=0x7fffa63c34f0) at ../src/backend/tcop/utility.c:1070 [03:44:39.596] parsetree = 0x55c82a9b6eb0 [03:44:39.596] isTopLevel = true [03:44:39.596] isAtomicContext = false [03:44:39.596] pstate = 0x55c82ab4fde0 [03:44:39.596] readonly_flags = [03:44:39.596] __func__ = "standard_ProcessUtility" [03:44:39.596] #12 0x000055c817718060 in ProcessUtility (pstmt=pstmt@entry=0x55c82a9b6f60, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55c82a9b7998, qc=0x7fffa63c34f0) at ../src/backend/tcop/utility.c:523 [03:44:39.596] No locals. [03:44:39.596] #13 0x000055c817713985 in PortalRunUtility (portal=portal@entry=0x55c82aa3b680, pstmt=pstmt@entry=0x55c82a9b6f60, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55c82a9b7998, qc=qc@entry=0x7fffa63c34f0) at ../src/backend/tcop/pquery.c:1184 [03:44:39.596] No locals. [03:44:39.596] #14 0x000055c817713f89 in PortalRunMulti (portal=portal@entry=0x55c82aa3b680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55c82a9b7998, altdest=altdest@entry=0x55c82a9b7998, qc=qc@entry=0x7fffa63c34f0) at ../src/backend/tcop/pquery.c:1348 [03:44:39.596] pstmt = 0x55c82a9b6f60 [03:44:39.596] stmtlist_item__state = [03:44:39.596] active_snapshot_set = false [03:44:39.596] stmtlist_item = 0x55c82a9b7960 [03:44:39.596] query_index = 0 [03:44:39.596] #15 0x000055c817714508 in PortalRun (portal=portal@entry=0x55c82aa3b680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55c82a9b7998, altdest=altdest@entry=0x55c82a9b7998, qc=qc@entry=0x7fffa63c34f0) at ../src/backend/tcop/pquery.c:819 [03:44:39.596] _save_exception_stack = 0x7fffa63c35a0 [03:44:39.596] _save_context_stack = 0x0 [03:44:39.596] _local_sigjmp_buf = {{__jmpbuf = {0, -3744707729761942675, 94318197192320, 94318196649768, 94318196649744, 94318196649696, -7464934745247235219, -3744641950110366867}, __mask_was_saved = 0, __saved_mask = {__val = {94317878119342, 2788963455, 4, 94318196649696, 112, 73, 94318197192320, 94318196649768, 94318196649744, 94318196649696, 94317878206545, 73, 2, 73, 94317867366721, 0}}}} [03:44:39.596] _do_rethrow = [03:44:39.596] result = [03:44:39.596] nprocessed = [03:44:39.596] saveTopTransactionResourceOwner = 0x55c82a9f9448 [03:44:39.596] saveTopTransactionContext = 0x55c82aa4dab0 [03:44:39.596] saveActivePortal = 0x0 [03:44:39.596] saveResourceOwner = 0x55c82a9f9448 [03:44:39.596] savePortalContext = 0x0 [03:44:39.596] saveMemoryContext = 0x55c82aa4dab0 [03:44:39.596] __func__ = "PortalRun" [03:44:39.596] #16 0x000055c81770d72e in exec_simple_query (query_string=query_string@entry=0x55c82a9b6170 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [03:44:39.596] cmdtaglen = 24 [03:44:39.596] snapshot_set = [03:44:39.596] per_parsetree_context = 0x0 [03:44:39.596] plantree_list = 0x55c82a9b7948 [03:44:39.596] parsetree = 0x55c82a9b6ee0 [03:44:39.596] commandTag = [03:44:39.596] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:44:39.596] querytree_list = [03:44:39.596] portal = 0x55c82aa3b680 [03:44:39.596] receiver = 0x55c82a9b7998 [03:44:39.596] format = 0 [03:44:39.596] cmdtagname = [03:44:39.596] parsetree_item__state = [03:44:39.596] dest = DestRemote [03:44:39.596] oldcontext = 0x55c82aa4dab0 [03:44:39.596] parsetree_list = 0x55c82a9b6f10 [03:44:39.596] parsetree_item = 0x55c82a9b6f28 [03:44:39.596] save_log_statement_stats = false [03:44:39.596] was_logged = false [03:44:39.596] use_implicit_block = false [03:44:39.596] msec_str = "\004\000\000\000\000\000\000\000\271%\235\027\310U\000\000\2005<\246\377\177\000\000G\000\000\000\000\000\000" [03:44:39.596] __func__ = "exec_simple_query" [03:44:39.596] #17 0x000055c817710490 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4693 [03:44:39.596] query_string = 0x55c82a9b6170 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:44:39.596] firstchar = [03:44:39.596] input_message = {data = 0x55c82a9b6170 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:44:39.596] local_sigjmp_buf = {{__jmpbuf = {94317891080056, -3744666297891208339, 140735982352124, 4, 6, 140735982352356, -7464934745448561811, -3744641935354805395}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94318196377600, 17408, 94317891074112, 94318196911088, 6, 94317878118890, 0, 10, 2, 94317891080064, 94318196377600, 94317891074112, 4, 6, 140735982352356}}}} [03:44:39.596] send_ready_for_query = false [03:44:39.596] idle_in_transaction_timeout_enabled = false [03:44:39.596] idle_session_timeout_enabled = false [03:44:39.596] __func__ = "PostgresMain" [03:44:39.596] #18 0x000055c8177064c4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:44:39.596] bsdata = [03:44:39.596] #19 0x000055c8175b55b8 in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x7fffa63c36fc, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffa63c3750) at ../src/backend/postmaster/launch_backend.c:274 [03:44:39.596] pid = [03:44:39.596] #20 0x000055c8175ba7b3 in BackendStartup (client_sock=client_sock@entry=0x7fffa63c3750) at ../src/backend/postmaster/postmaster.c:3519 [03:44:39.596] bn = 0x55c82a9de7d8 [03:44:39.596] pid = [03:44:39.596] startup_data = {canAcceptConnections = CAC_OK} [03:44:39.596] cac = [03:44:39.596] __func__ = "BackendStartup" [03:44:39.596] #21 0x000055c8175bc883 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:44:39.596] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\243\240I\177\000\000\240\217\363\241I\177\000\000\3707<\246\377\177\000\000\3647<\246\377\177", '\000' , "\203~q\026\310U\000\000\360Xm\026\310U\000\000\3008<\246\377\177\000\000\2708<\246\377\177\000\000\225[\362\001\000\000\000\000\240\024\211\241I\177\000\000+", '\000' , "\310U\000\000\221}q\026\310U\000", __ss_align = 139954230273640}, salen = 2}} [03:44:39.596] i = 0 [03:44:39.596] now = [03:44:39.596] last_lockfile_recheck_time = 1741318736 [03:44:39.596] last_touch_time = 1741318736 [03:44:39.596] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x0}, {pos = -1574033816, events = 32585, fd = -1584851408, user_data = 0x7f49a22e22e0}, {pos = 2090263927, events = 0, fd = -1506002624, user_data = 0x7f49a22b8a48}, {pos = 15, events = 0, fd = -1584851408, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f49a22e22e0}, {pos = -1506002760, events = 32767, fd = -1506002752, user_data = 0x7f49a22e2668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 714833504, events = 21960, fd = 1, user_data = 0x7fffa63c3de3}, {pos = -1, events = 0, fd = -1599938528, user_data = 0x7f49a1f38fa0}, {pos = 715012792, events = 21960, fd = 715012504, user_data = 0x55c82a9e3771}, {pos = -1574179138, events = 32585, fd = 1, user_data = 0x7f49a22e22e0}, {pos = 426, events = 0, fd = 402074960, user_data = 0x0}, {pos = 249, events = 0, fd = 714826288, user_data = 0x7f49a22beebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f49a0a2e020}, {pos = -1599132096, events = 32585, fd = 16, user_data = 0x7fffa63c3d10}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1574170182, events = 32585, fd = 0, user_data = 0x7f49a0aaeda4 }, {pos = 0, events = 0, fd = 409158656, user_data = 0x2}, {pos = 0, events = 0, fd = 714573984, user_data = 0x55c8176a3d46 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 714826288, user_data = 0x7f49a22beebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f49a0a364c8}, {pos = -1599377299, events = 32585, fd = 409251424, user_data = 0x55c82a9e8b90}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -1598088096, events = 32585, 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 = 0x312020200a0a7656}, {pos = 822763892, events = 858862647, fd = 859256881, 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 = 1024, user_data = 0x7f49a0ab58be}, {pos = -1598105120, events = 32585, fd = -1599467154, user_data = 0x100000400}, {pos = 7, events = 0, fd = 715013024, user_data = 0x8775ac40359e7800}, {pos = -1598102048, events = 32585, fd = -328, user_data = 0x0}, {pos = 715012184, events = 21960, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 25500, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 714826288, user_data = 0x7f49a0af3053 }, {pos = 715012184, events = 21960, fd = 1024, user_data = 0x7fffa63c3dd8}, {pos = 396378081, events = 21960, fd = 409259824, user_data = 0x55c8179f2a9e }, {pos = 715011984, events = 21960, fd = 714825840, user_data = 0x55c82a9e3790}, {pos = -1599383362, events = 32585, fd = 0, user_data = 0x55c817a04708 }, {pos = 715011984, events = 1, fd = 396380241, user_data = 0x55c82a9b6070}, {pos = 899577856, events = 2272635968, fd = 0, user_data = 0x7f49a0aa2ab1}, {pos = -1599466256, events = 32585, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 714573984, user_data = 0x8775ac40359e7800}, {pos = 0, events = 0, fd = 899577856, user_data = 0xc}, {pos = 899577856, events = 2272635968, fd = 0, user_data = 0x7f49a0a5b239 }, {pos = 250, events = 0, fd = 391860917, user_data = 0x400000}, {pos = 0, events = 0, fd = 714573984, user_data = 0x55c8179f2932 }, {pos = 714659744, events = 21960, fd = 714825840, user_data = 0x55c82a98d7a0}, {pos = 1, events = 0, fd = 0, user_data = 0x55c8179b10ae }, {pos = 12, events = 0, fd = 715003320, user_data = 0x55c82a9e1598}, {pos = 409160064, events = 21960, fd = 296, user_data = 0x55c8175b7acf }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 391877282, events = 21960, fd = 405523696, user_data = 0x55c82a9b6a48}} [03:44:39.596] nevents = 1 [03:44:39.596] __func__ = "ServerLoop" [03:44:39.596] #22 0x000055c8175be0e2 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55c82a974760) at ../src/backend/postmaster/postmaster.c:1386 [03:44:39.596] opt = [03:44:39.596] status = [03:44:39.596] userDoption = [03:44:39.596] listen_addr_saved = false [03:44:39.596] output_config_variable = [03:44:39.596] __func__ = "PostmasterMain" [03:44:39.596] #23 0x000055c8173ee182 in main (argc=8, argv=0x55c82a974760) at ../src/backend/main/main.c:230 [03:44:39.596] do_check_root = [03:44:39.596] dispatch_option = [03:44:39.635] -e [03:44:39.635] [03:44:39.635] [03:44:39.701] dumping /tmp/cores/postgres-6-37348.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:44:39.967] [New LWP 37348] [03:44:39.967] [03:44:39.967] This GDB supports auto-downloading debuginfo from the following URLs: [03:44:39.967] [03:44:39.967] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:44:39.967] Debuginfod has been disabled. [03:44:39.967] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:44:40.072] [Thread debugging using libthread_db enabled] [03:44:40.072] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:44:40.072] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [03:44:40.072] Program terminated with signal SIGABRT, Aborted. [03:44:40.072] #0 0x00007f3f796a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:41.102] [03:44:41.102] Thread 1 (Thread 0x7f3f795dbf00 (LWP 37348)): [03:44:41.102] #0 0x00007f3f796a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:41.102] No symbol table info available. [03:44:41.102] #1 0x00007f3f7965afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:41.102] No symbol table info available. [03:44:41.102] #2 0x00007f3f79645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:44:41.102] No symbol table info available. [03:44:41.102] #3 0x0000557ba76fa744 in ExceptionalCondition (conditionName=conditionName@entry=0x557ba797a706 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x557ba7979b30 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [03:44:41.102] No locals. [03:44:41.102] #4 0x0000557ba7058c23 in standard_ExecutorStart (queryDesc=0x557bb691c6d0, eflags=0) at ../src/backend/executor/execMain.c:203 [03:44:41.102] estate = 0x557bb6828e90 [03:44:41.102] oldcontext = 0x557bb697afa0 [03:44:41.102] __func__ = "standard_ExecutorStart" [03:44:41.102] #5 0x00007f3f7723e6fd in pgss_ExecutorStart (queryDesc=0x557bb691c6d0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:998 [03:44:41.102] plan_valid = [03:44:41.102] #6 0x0000557ba7058dbb in ExecutorStart (queryDesc=queryDesc@entry=0x557bb691c6d0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:140 [03:44:41.102] plan_valid = [03:44:41.102] #7 0x0000557ba6f76a18 in refresh_matview_datafill (dest=0x557bb6955080, query=, query@entry=0x557bb68ea400, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [03:44:41.102] rewritten = [03:44:41.102] plan = 0x557bb691bcf8 [03:44:41.102] queryDesc = 0x557bb691c6d0 [03:44:41.102] copied_query = [03:44:41.102] processed = [03:44:41.102] __func__ = "refresh_matview_datafill" [03:44:41.102] #8 0x0000557ba6f78dc3 in RefreshMatViewByOid (matviewOid=28717, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [03:44:41.102] dest = [03:44:41.102] matviewRel = 0x7f3f75012cc0 [03:44:41.102] rule = [03:44:41.102] actions = [03:44:41.102] dataQuery = 0x557bb68ea400 [03:44:41.102] tableSpace = [03:44:41.102] relowner = 10 [03:44:41.102] OIDNewHeap = 28729 [03:44:41.102] processed = 0 [03:44:41.102] relpersistence = 112 'p' [03:44:41.102] save_userid = 10 [03:44:41.102] save_sec_context = 0 [03:44:41.102] save_nestlevel = 2 [03:44:41.102] address = {classId = 0, objectId = 0, objectSubId = 0} [03:44:41.102] __func__ = "RefreshMatViewByOid" [03:44:41.102] #9 0x0000557ba6f78f02 in ExecRefreshMatView (stmt=0x557bb6954d58, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:44:41.102] matviewOid = [03:44:41.102] lockmode = [03:44:41.102] #10 0x0000557ba6f2e575 in ExecCreateTableAs (pstate=pstate@entry=0x557bb697b0a0, stmt=stmt@entry=0x557bb67ce250, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc82981530) at ../src/backend/commands/createas.c:351 [03:44:41.102] refresh = [03:44:41.102] query = 0x557bb67ce410 [03:44:41.102] into = 0x557bb67cdfa8 [03:44:41.102] jstate = 0x0 [03:44:41.102] is_matview = true [03:44:41.102] do_refresh = false [03:44:41.102] dest = [03:44:41.102] address = {classId = 1259, objectId = 28717, objectSubId = 0} [03:44:41.102] __func__ = "ExecCreateTableAs" [03:44:41.102] #11 0x0000557ba746790a in ProcessUtilitySlow (pstate=pstate@entry=0x557bb697b0a0, pstmt=pstmt@entry=0x557bb67ce300, queryString=queryString@entry=0x557bb67cd510 "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=0x557bb67cf2a8, qc=0x7ffc82981530) at ../src/backend/tcop/utility.c:1678 [03:44:41.102] _save_exception_stack = 0x7ffc82981100 [03:44:41.102] _save_context_stack = 0x0 [03:44:41.102] _local_sigjmp_buf = {{__jmpbuf = {0, 8008945076929851868, 93989830976080, 0, 93989830972688, 0, 4191466781621383644, 8008912413780111836}, __mask_was_saved = 0, __saved_mask = {__val = {11102307609396555763, 3672368693164710999, 93989575173481, 0, 5412384741217271808, 93989581351712, 93989575426326, 139910525507072, 1, 16777216, 0, 139910525507072, 140722499490096, 0, 93989579045087, 140722499489292}}}} [03:44:41.102] _do_rethrow = false [03:44:41.102] parsetree = 0x557bb67ce250 [03:44:41.102] isTopLevel = true [03:44:41.102] isCompleteQuery = true [03:44:41.102] needCleanup = false [03:44:41.102] commandCollected = false [03:44:41.102] address = {classId = 21883, objectId = 3061637712, objectSubId = 21883} [03:44:41.102] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:44:41.102] __func__ = "ProcessUtilitySlow" [03:44:41.102] #12 0x0000557ba7465f05 in standard_ProcessUtility (pstmt=pstmt@entry=0x557bb67ce300, queryString=queryString@entry=0x557bb67cd510 "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=0x557bb67cf2a8, qc=0x7ffc82981530) at ../src/backend/tcop/utility.c:1070 [03:44:41.102] parsetree = 0x557bb67ce250 [03:44:41.102] isTopLevel = true [03:44:41.102] isAtomicContext = false [03:44:41.102] pstate = 0x557bb697b0a0 [03:44:41.102] readonly_flags = [03:44:41.102] __func__ = "standard_ProcessUtility" [03:44:41.102] #13 0x00007f3f77241deb in pgss_ProcessUtility (pstmt=0x557bb67ce300, queryString=0x557bb67cd510 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x557bb67cf2a8, qc=0x7ffc82981530) at ../contrib/pg_stat_statements/pg_stat_statements.c:1179 [03:44:41.102] _save_exception_stack = 0x7ffc82981410 [03:44:41.102] _save_context_stack = 0x0 [03:44:41.102] _local_sigjmp_buf = {{__jmpbuf = {0, -4192268629929856548, 93989830976256, 93989830980264, 140722499491120, 0, 4191466781524914652, 4300092861596594652}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 206158430232, 140722499490352, 93989579052786, 1, 206158430232, 93989830977056, 140722499490448, 0, 93989573794614, 93989830972432, 93989578709562, 3, 93989572498204, 93989830976256}}}} [03:44:41.102] _do_rethrow = false [03:44:41.102] duration = [03:44:41.102] bufusage = {shared_blks_hit = 1, shared_blks_read = 99, shared_blks_dirtied = 139910525507072, shared_blks_written = 139910525507072, local_blks_hit = 1, local_blks_read = 93989575174879, local_blks_dirtied = 93989831351160, local_blks_written = 93989579046021, temp_blks_read = 139910595853752, temp_blks_written = 93989830972688, shared_blk_read_time = {ticks = 93989581422611}, shared_blk_write_time = {ticks = 93989591682530}, local_blk_read_time = {ticks = 93989591682656}, local_blk_write_time = {ticks = 140722499490356}, temp_blk_read_time = {ticks = 93989581618169}, temp_blk_write_time = {ticks = 93989591682545}} [03:44:41.102] walusage_start = {wal_records = 8963, wal_fpi = 132, wal_bytes = 1226308, wal_buffers_full = 45} [03:44:41.102] start = [03:44:41.102] rows = [03:44:41.102] bufusage_start = {shared_blks_hit = 34309, shared_blks_read = 4484, shared_blks_dirtied = 1575, shared_blks_written = 1075, local_blks_hit = 45, local_blks_read = 0, local_blks_dirtied = 10, local_blks_written = 17, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [03:44:41.102] walusage = {wal_records = 139910528612992, wal_fpi = 425201762304, wal_bytes = 139910525507108, wal_buffers_full = 93989578196863} [03:44:41.102] parsetree = [03:44:41.102] saved_queryId = 7566811930394970136 [03:44:41.102] saved_stmt_location = 0 [03:44:41.102] saved_stmt_len = 69 [03:44:41.102] enabled = true [03:44:41.102] #14 0x0000557ba7465fab in ProcessUtility (pstmt=pstmt@entry=0x557bb67ce300, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x557bb67cf2a8, qc=0x7ffc82981530) at ../src/backend/tcop/utility.c:519 [03:44:41.102] No locals. [03:44:41.102] #15 0x0000557ba7461985 in PortalRunUtility (portal=portal@entry=0x557bb6850400, pstmt=pstmt@entry=0x557bb67ce300, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x557bb67cf2a8, qc=qc@entry=0x7ffc82981530) at ../src/backend/tcop/pquery.c:1184 [03:44:41.102] No locals. [03:44:41.102] #16 0x0000557ba7461f89 in PortalRunMulti (portal=portal@entry=0x557bb6850400, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x557bb67cf2a8, altdest=altdest@entry=0x557bb67cf2a8, qc=qc@entry=0x7ffc82981530) at ../src/backend/tcop/pquery.c:1348 [03:44:41.102] pstmt = 0x557bb67ce300 [03:44:41.102] stmtlist_item__state = [03:44:41.102] active_snapshot_set = false [03:44:41.102] stmtlist_item = 0x557bb67cf270 [03:44:41.102] query_index = 0 [03:44:41.102] #17 0x0000557ba7462508 in PortalRun (portal=portal@entry=0x557bb6850400, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x557bb67cf2a8, altdest=altdest@entry=0x557bb67cf2a8, qc=qc@entry=0x7ffc82981530) at ../src/backend/tcop/pquery.c:819 [03:44:41.102] _save_exception_stack = 0x7ffc829815e0 [03:44:41.102] _save_context_stack = 0x0 [03:44:41.102] _local_sigjmp_buf = {{__jmpbuf = {0, 8008945077522297308, 93989831508992, 93989830976200, 93989830976176, 93989830976128, 4191466781669618140, 8008912416093008348}, __mask_was_saved = 0, __saved_mask = {__val = {93989578730414, 2191004863, 4, 93989830976128, 112, 73, 93989831508992, 93989830976200, 93989830976176, 93989830976128, 93989578817617, 73, 2, 73, 93989567977793, 0}}}} [03:44:41.102] _do_rethrow = [03:44:41.102] result = [03:44:41.102] nprocessed = [03:44:41.102] saveTopTransactionResourceOwner = 0x557bb6811e08 [03:44:41.102] saveTopTransactionContext = 0x557bb6862c40 [03:44:41.102] saveActivePortal = 0x0 [03:44:41.102] saveResourceOwner = 0x557bb6811e08 [03:44:41.102] savePortalContext = 0x0 [03:44:41.102] saveMemoryContext = 0x557bb6862c40 [03:44:41.102] __func__ = "PortalRun" [03:44:41.102] #18 0x0000557ba745b72e in exec_simple_query (query_string=query_string@entry=0x557bb67cd510 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [03:44:41.102] cmdtaglen = 24 [03:44:41.102] snapshot_set = [03:44:41.102] per_parsetree_context = 0x0 [03:44:41.102] plantree_list = 0x557bb67cf258 [03:44:41.102] parsetree = 0x557bb67ce280 [03:44:41.102] commandTag = [03:44:41.102] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:44:41.102] querytree_list = [03:44:41.102] portal = 0x557bb6850400 [03:44:41.102] receiver = 0x557bb67cf2a8 [03:44:41.102] format = 0 [03:44:41.102] cmdtagname = [03:44:41.102] parsetree_item__state = [03:44:41.102] dest = DestRemote [03:44:41.102] oldcontext = 0x557bb6862c40 [03:44:41.102] parsetree_list = 0x557bb67ce2b0 [03:44:41.102] parsetree_item = 0x557bb67ce2c8 [03:44:41.102] save_log_statement_stats = false [03:44:41.102] was_logged = true [03:44:41.102] use_implicit_block = false [03:44:41.102] msec_str = "\004\000\000\000\000\000\000\000\271\005r\247{U\000\000\300\025\230\202\374\177\000\000G\000\000\000\000\000\000" [03:44:41.102] __func__ = "exec_simple_query" [03:44:41.102] #19 0x0000557ba745e490 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4693 [03:44:41.102] query_string = 0x557bb67cd510 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:44:41.102] firstchar = [03:44:41.102] input_message = {data = 0x557bb67cd510 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:44:41.102] local_sigjmp_buf = {{__jmpbuf = {93989591691128, 8008879632785109468, 140722499491644, 4, 7, 140722499491876, 4191466781870944732, 8008912443750248924}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 93989831228848, 0, 168, 93989578730516, 0, 10, 2, 93989591691136, 93989830703248, 93989591685184, 4, 7, 140722499491876}}}} [03:44:41.102] send_ready_for_query = false [03:44:41.102] idle_in_transaction_timeout_enabled = false [03:44:41.102] idle_session_timeout_enabled = false [03:44:41.102] __func__ = "PostgresMain" [03:44:41.102] #20 0x0000557ba74544c4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:44:41.102] bsdata = [03:44:41.102] #21 0x0000557ba73035b8 in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7ffc8298173c, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc82981790) at ../src/backend/postmaster/launch_backend.c:274 [03:44:41.102] pid = [03:44:41.102] #22 0x0000557ba73087b3 in BackendStartup (client_sock=client_sock@entry=0x7ffc82981790) at ../src/backend/postmaster/postmaster.c:3519 [03:44:41.102] bn = 0x557bb67f8d88 [03:44:41.102] pid = [03:44:41.102] startup_data = {canAcceptConnections = CAC_OK} [03:44:41.102] cac = [03:44:41.102] __func__ = "BackendStartup" [03:44:41.102] #23 0x0000557ba730a883 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:44:41.102] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "cy?\177\000\000\240_\272z?\177\000\0008\030\230\202\374\177\000\0004\030\230\202\374\177", '\000' , "\203^F\246{U\000\000\3608B\246{U\000\000\000\031\230\202\374\177\000\000\370\030\230\202\374\177\000\000\225[\362\001\000\000\000\000p\201\177\266{U\000\000,", '\000' , "{U\000\000\221]F\246{U\000", __ss_align = 139910622930536}, salen = 2}} [03:44:41.102] i = 0 [03:44:41.102] now = [03:44:41.102] last_lockfile_recheck_time = 1741318775 [03:44:41.102] last_touch_time = 1741318775 [03:44:41.102] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x0}, {pos = 2063263336, events = 32575, fd = 2058536496, user_data = 0x7f3f7afae2e0}, {pos = 2090263927, events = 0, fd = -2103961216, user_data = 0x7f3f7af84a48}, {pos = 15, events = 0, fd = 2058536496, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f3f7afae2e0}, {pos = -2103961352, events = 32764, fd = -2103961344, user_data = 0x7f3f7afae668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -1233330128, events = 21883, fd = 1, user_data = 0x7ffc82981e23}, {pos = -1, events = 0, fd = 2036523040, user_data = 0x7f3f7aba5fa0}, {pos = -1233112312, events = 21883, fd = -1233112600, user_data = 0x557bb67fd6d1}, {pos = 2063118014, events = 32575, fd = 1, user_data = 0x7f3f7afae2e0}, {pos = 426, events = 0, fd = -1479799472, user_data = 0x0}, {pos = 86, events = 0, fd = -1233146760, user_data = 0x7f3f7af8aebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f3f7962e020}, {pos = 2037329472, events = 32575, fd = 16, user_data = 0x7ffc82981d50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 2063126970, events = 32575, fd = 0, user_data = 0x7f3f796aeda4 }, {pos = 0, events = 0, fd = -1472715776, user_data = 0x2}, {pos = 0, events = 0, fd = -1233585872, user_data = 0x557ba73f1d46 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -1233146760, user_data = 0x7f3f7af8aebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f3f796364c8}, {pos = 2037083911, events = 32575, fd = -1472623008, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 2038373472, events = 32575, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = 2058540352, events = 32575, fd = 2058541696, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1024, user_data = 0x7f3f796b576b}, {pos = 2038356448, events = 32575, fd = 2036994414, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1233117232, user_data = 0xbff402b10b740700}, {pos = 2038359520, events = 32575, fd = -328, user_data = 0x0}, {pos = -1233112920, events = 21883, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 33028, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1233146760, user_data = 0x7f3f796f3053 }, {pos = -1233112920, events = 21883, fd = 1024, user_data = 0x7ffc82981e18}, {pos = -1485496351, events = 21883, fd = -1472614608, user_data = 0x557ba7740a9e }, {pos = -1233113120, events = 21883, fd = -1233333232, user_data = 0x557bb6802fe0}, {pos = 2037077867, events = 32575, fd = 0, user_data = 0x557ba7752708 }, {pos = -1233113120, events = 1, fd = -1485494191, user_data = 0x557bb67cd410}, {pos = 192153344, events = 3220439729, fd = 0, user_data = 0x7f3f796a2ab1}, {pos = 2036995312, events = 32575, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1233585872, user_data = 0xbff402b10b740700}, {pos = 0, events = 0, fd = 192153344, user_data = 0xc}, {pos = 192153344, events = 3220439729, fd = 0, user_data = 0x7f3f7965b239 }, {pos = 87, events = 0, fd = -1490013515, user_data = 0x400000}, {pos = 0, events = 0, fd = -1233585872, user_data = 0x557ba7740932 }, {pos = -1233499328, events = 21883, fd = -1233333232, user_data = 0x557bb67a4b40}, {pos = 1, events = 0, fd = 0, user_data = 0x557ba76ff0ae }, {pos = 12, events = 0, fd = -1233150808, user_data = 0x557bb67f9c88}, {pos = -1472714368, events = 21883, fd = 296, user_data = 0x557ba7305acf }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1489997150, events = 21883, fd = -1476350736, user_data = 0x557bb67cddc8}} [03:44:41.102] nevents = 1 [03:44:41.102] __func__ = "ServerLoop" [03:44:41.102] #24 0x0000557ba730c0e2 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x557bb678b790) at ../src/backend/postmaster/postmaster.c:1386 [03:44:41.102] opt = [03:44:41.102] status = [03:44:41.102] userDoption = [03:44:41.102] listen_addr_saved = false [03:44:41.102] output_config_variable = [03:44:41.102] __func__ = "PostmasterMain" [03:44:41.102] #25 0x0000557ba713c182 in main (argc=4, argv=0x557bb678b790) at ../src/backend/main/main.c:230 [03:44:41.102] do_check_root = [03:44:41.102] dispatch_option =