[01:45:29.510] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [01:45:29.857] dumping /tmp/cores/postgres.10854.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [01:45:29.990] [New LWP 101948] [01:45:30.074] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [01:45:30.074] Program terminated with signal SIGABRT, Aborted. [01:45:30.074] Sent by thr_kill() from pid 10854 and user 1003. [01:45:30.074] #0 0x000000082b94941a in thr_kill () from /lib/libc.so.7 [01:45:30.130] [01:45:30.130] Thread 1 (LWP 101948): [01:45:30.130] #0 0x000000082b94941a in thr_kill () from /lib/libc.so.7 [01:45:30.130] No symbol table info available. [01:45:30.130] #1 0x000000082b8c2e64 in raise () from /lib/libc.so.7 [01:45:30.130] No symbol table info available. [01:45:30.130] #2 0x000000082b9736f9 in abort () from /lib/libc.so.7 [01:45:30.130] No symbol table info available. [01:45:30.130] #3 0x0000000000aa19b5 in ExceptionalCondition (conditionName=0x2ecf53 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [01:45:30.130] No locals. [01:45:30.130] #4 0x000000000076f549 in standard_ExecutorStart (queryDesc=0x8340b4b40, eflags=0) at ../src/backend/executor/execMain.c:193 [01:45:30.130] estate = 0x836d02100 [01:45:30.130] oldcontext = 0x8340dc800 [01:45:30.130] #5 0x0000000000704d15 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [01:45:30.130] copied_query = [01:45:30.130] rewritten = [01:45:30.130] plan = 0x8340b46e8 [01:45:30.130] queryDesc = 0x8340b4b40 [01:45:30.130] processed = [01:45:30.130] __error = [01:45:30.130] #6 RefreshMatViewByOid (matviewOid=28339, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [01:45:30.130] dest = [01:45:30.130] save_userid = 10 [01:45:30.130] save_sec_context = 0 [01:45:30.130] processed = 0 [01:45:30.130] matviewRel = 0x836d8c158 [01:45:30.130] relowner = 10 [01:45:30.130] save_nestlevel = 2 [01:45:30.130] rule = [01:45:30.130] actions = [01:45:30.130] dataQuery = [01:45:30.130] tableSpace = [01:45:30.130] relpersistence = [01:45:30.130] OIDNewHeap = 28346 [01:45:30.130] address = [01:45:30.130] #7 0x00000000007048f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:45:30.130] lockmode = [01:45:30.130] matviewOid = 0 [01:45:30.130] #8 0x00000000006dba0c in ExecCreateTableAs (pstate=pstate@entry=0x8340dc900, stmt=stmt@entry=0x8340cffd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8212d6cb0) at ../src/backend/commands/createas.c:351 [01:45:30.130] refresh = 0x0 [01:45:30.130] query = 0x836e0dc18 [01:45:30.130] into = 0x836e0df60 [01:45:30.130] jstate = 0x0 [01:45:30.130] do_refresh = false [01:45:30.130] address = [01:45:30.130] dest = [01:45:30.130] is_matview = [01:45:30.130] #9 0x000000000094c3e8 in ProcessUtilitySlow (pstate=pstate@entry=0x8340dc900, pstmt=pstmt@entry=0x834011a68, queryString=queryString@entry=0x834010100 "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=, qc=0x8212d6cb0) at ../src/backend/tcop/utility.c:1678 [01:45:30.130] _local_sigjmp_buf = {{_sjb = {9747481, 0, 34916362456, 34916362832, 34916362464, 12442504, 0, 35233057024, 12387199, 1, 4294967295, 34359738368}}} [01:45:30.130] _save_exception_stack = 0x8212d6bb0 [01:45:30.130] _save_context_stack = 0x0 [01:45:30.130] _do_rethrow = false [01:45:30.130] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:45:30.130] parsetree = 0x8340cffd0 [01:45:30.130] commandCollected = false [01:45:30.130] needCleanup = false [01:45:30.130] address = [01:45:30.130] isTopLevel = [01:45:30.130] isCompleteQuery = [01:45:30.130] #10 0x000000000094ad68 in standard_ProcessUtility (pstmt=0x834011a68, queryString=0x834010100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836e0e448, qc=0x8212d6cb0) at ../src/backend/tcop/utility.c:1033 [01:45:30.130] isAtomicContext = false [01:45:30.130] parsetree = 0x8340cffd0 [01:45:30.130] readonly_flags = [01:45:30.130] pstate = 0x8340dc900 [01:45:30.130] isTopLevel = [01:45:30.130] #11 0x000000000094a7f8 in ProcessUtility (pstmt=0x18e3c, queryString=0x6 , readOnlyTree=, context=731157498, params=0x0, queryEnv=0x0, dest=0x836e0e448, qc=0x8212d6cb0) at ../src/backend/tcop/utility.c:523 [01:45:30.130] No locals. [01:45:30.130] #12 0x000000000094a333 in PortalRunUtility (portal=0x8340e7100, pstmt=0x834011a68, isTopLevel=, setHoldSnapshot=, dest=0x836e0e448, qc=0x8212d6cb0) at ../src/backend/tcop/pquery.c:1152 [01:45:30.130] No locals. [01:45:30.130] #13 0x00000000009499f4 in PortalRunMulti (portal=portal@entry=0x8340e7100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x836e0e448, altdest=altdest@entry=0x836e0e448, qc=qc@entry=0x8212d6cb0) at ../src/backend/tcop/pquery.c:1316 [01:45:30.130] pstmt = 0x834011a68 [01:45:30.130] stmtlist_item__state = {l = 0x836e0e3f8, i = 0} [01:45:30.130] active_snapshot_set = false [01:45:30.130] stmtlist_item = 0x836e0e410 [01:45:30.130] #14 0x00000000009492db in PortalRun (portal=portal@entry=0x8340e7100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x836e0e448, altdest=altdest@entry=0x836e0e448, qc=qc@entry=0x8212d6cb0) at ../src/backend/tcop/pquery.c:787 [01:45:30.130] _local_sigjmp_buf = {{_sjb = {9736789, 35233100032, 34916363176, 34916363424, 34916363184, 12442504, 34916363440, 12408104, 12387199, 0, 35233071999, 34359738368}}} [01:45:30.130] _save_exception_stack = 0x8212d6d60 [01:45:30.130] _save_context_stack = 0x0 [01:45:30.130] _do_rethrow = false [01:45:30.130] saveTopTransactionResourceOwner = 0x8340f8998 [01:45:30.130] saveTopTransactionContext = 0x8340eb000 [01:45:30.130] saveActivePortal = 0x0 [01:45:30.130] saveResourceOwner = 0x8340f8998 [01:45:30.130] savePortalContext = 0x0 [01:45:30.130] saveMemoryContext = 0x8340eb000 [01:45:30.130] result = [01:45:30.130] nprocessed = [01:45:30.130] #15 0x0000000000948169 in exec_simple_query (query_string=query_string@entry=0x834010100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [01:45:30.130] cmdtaglen = 24 [01:45:30.130] snapshot_set = [01:45:30.130] per_parsetree_context = 0x0 [01:45:30.130] plantree_list = [01:45:30.130] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:45:30.130] format = 0 [01:45:30.130] parsetree = 0x8340116a8 [01:45:30.130] commandTag = [01:45:30.130] cmdtagname = [01:45:30.130] querytree_list = [01:45:30.130] portal = 0x8340e7100 [01:45:30.130] receiver = 0x836e0e448 [01:45:30.130] parsetree_item__state = {l = 0x834011a18, i = 0} [01:45:30.130] msec_str = "\000\000\000\000\b", '\000' , "@\234Wg\000\000\000\000\330\203q\201\272\376\334", [01:45:30.130] dest = DestRemote [01:45:30.130] was_logged = [01:45:30.130] oldcontext = 0x8340eb000 [01:45:30.130] parsetree_list = 0x834011a18 [01:45:30.130] use_implicit_block = false [01:45:30.130] parsetree_item = 0x834011a30 [01:45:30.130] save_log_statement_stats = [01:45:30.130] #16 0x0000000000945dd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4816 [01:45:30.130] query_string = 0x834010100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:45:30.130] input_message = {data = 0x834010100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:45:30.130] firstchar = [01:45:30.130] local_sigjmp_buf = {{_sjb = {9720454, 34916363616, 34916363608, 34916364160, 12451240, 1, 8192, 8388608, 34916336511, 0, 0, 1}}} [01:45:30.130] send_ready_for_query = false [01:45:30.130] idle_in_transaction_timeout_enabled = false [01:45:30.130] idle_session_timeout_enabled = false [01:45:30.130] #17 0x0000000000940569 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [01:45:30.130] bsdata = [01:45:30.130] #18 0x00000000008986c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x8212d7a98 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212d79e0) at ../src/backend/postmaster/launch_backend.c:274 [01:45:30.130] pid = [01:45:30.130] #19 0x000000000089c8a8 in BackendStartup (client_sock=0x8212d79e0) at ../src/backend/postmaster/postmaster.c:3390 [01:45:30.130] startup_data = {canAcceptConnections = CAC_OK} [01:45:30.130] bn = 0x8340b3188 [01:45:30.130] cac = CAC_OK [01:45:30.130] pid = [01:45:30.130] __error = [01:45:30.130] save_errno = [01:45:30.130] __error = [01:45:30.130] __error = [01:45:30.130] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [01:45:30.130] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\f", '\000' , "@z-!\b\000\000\000h\325k+\b\000\000\000\355\000\000\000\000\000\000\000^_l+\b", '\000' , "\200z-!\b\000\000\000d\204\211\000\000\000\000\000\220z-!\b", '\000' }, salen = 16}} [01:45:30.130] i = 0 [01:45:30.130] now = [01:45:30.130] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 730036931, events = 8, fd = 128686702, user_data = 0x2d021c93dacf}, {pos = 558062136, events = 8, fd = 1, user_data = 0x82142f408}, {pos = 729907560, events = 8, fd = 1171617558, user_data = 0x8212d71a8}, {pos = 556626336, events = 8, fd = 8192, user_data = 0x101000}, {pos = 873377792, events = 8, fd = 556626144, user_data = 0x82b9b8a47}, {pos = 1, events = 0, fd = 1052672, user_data = 0xe8}, {pos = 0, events = 0, fd = 558022664, user_data = 0x82142c408}, {pos = 558024712, events = 8, fd = 558025736, user_data = 0x8212d71a0}, {pos = 556626328, events = 8, fd = 840646800, user_data = 0x833c00980}, {pos = 32, events = 0, fd = 4096, user_data = 0x8212d7360}, {pos = 731593340, events = 8, fd = 556626208, user_data = 0x82b9b8b22}, {pos = 556626328, events = 8, fd = 840646800, user_data = 0x20}, {pos = 4096, events = 0, fd = 556626784, user_data = 0x82b9b4098}, {pos = 868221136, events = 8, fd = 840646800, user_data = 0x3000}, {pos = 8192, events = 0, fd = 840646848, user_data = 0x1000}, {pos = 4097, events = 0, fd = 8192, user_data = 0x833c00980}, {pos = 556627920, events = 8, fd = 868243672, user_data = 0x0}, {pos = 0, events = 0, fd = 868272256, user_data = 0x0}, {pos = 868272128, events = 8, fd = 232, user_data = 0x1}, {pos = 868223360, events = 8, fd = 556627920, user_data = 0x20}, {pos = 8388608, events = 0, fd = 8192, user_data = 0x833c0c580}, {pos = 888801232, events = 8, fd = 888801224, user_data = 0x834fa07c0}, {pos = 888801208, events = 8, fd = 8417280, user_data = 0x8340df000}, {pos = 8193, events = 0, fd = 556626448, user_data = 0x8212d7210}, {pos = 1, events = 0, fd = 872415636, user_data = 0x0}, {pos = 556626544, events = 8, fd = 728520044, user_data = 0x1}, {pos = 872415232, events = 8, fd = 556626592, user_data = 0x82b6c4702}, {pos = 731744592, events = 8, fd = 731832696, user_data = 0x82b9d8950 }, {pos = 558035976, events = 8, fd = 556626816, user_data = 0x2d021ff6b3de}, {pos = 558026760, events = 8, fd = 1, user_data = 0x2d021ff6b25e}, {pos = 558035976, events = 8, fd = 556626600, user_data = 0x8212d7380}, {pos = 12264, events = 0, fd = 0, user_data = 0x2d021ff7e990}, {pos = 556628208, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = 1171617558, events = 1502214956, fd = 0, user_data = 0x82142f408}, {pos = 12264, events = 0, fd = 1171617558, user_data = 0x8321b4090}, {pos = 1, events = 0, fd = 868243672, user_data = 0x833c00980}, {pos = 0, events = 0, fd = 556626928, user_data = 0x82b8d7915 }, {pos = 0, events = 0, fd = 556626864, user_data = 0x8212d7820}, {pos = 0, events = 0, fd = 556626928, user_data = 0x82b8edb61}, {pos = 1, events = 0, fd = 556628000, user_data = 0x8212d7820}, {pos = 0, events = 16777216, fd = 1171617558, user_data = 0x82b9fc6a0 <__stack_chk_guard>}, {pos = 872859096, events = 8, fd = 0, user_data = 0x82b9e1e38}, {pos = 556628208, events = 8, fd = 556628064, user_data = 0x82b8edc82}, {pos = 0, events = 0, fd = 556628368, user_data = 0x83406c5d8}, {pos = 556628000, events = 8, fd = 556627328, user_data = 0x2000}, {pos = 8192, events = 0, fd = 873328640, user_data = 0x8212d7588}, {pos = 0, events = 0, fd = 840646800, user_data = 0x1}, {pos = 556627136, events = 8, fd = 731613641, user_data = 0x82b81d388}, {pos = 730021240, events = 8, fd = 556627160, user_data = 0x8212d7550}, {pos = 556627328, events = 8, fd = 556627320, user_data = 0x8321b4090}, {pos = 868223360, events = 8, fd = 32, user_data = 0x1000}, {pos = 556627776, events = 8, fd = 731593340, user_data = 0x8212d7578}, {pos = 536290058, events = 11522, fd = 729897048, user_data = 0x82b833d78}, {pos = 556627272, events = 8, fd = 556627392, user_data = 0x8212d7548}, {pos = 729984268, events = 8, fd = 558035976, user_data = 0x82b82ad0c}, {pos = 556627376, events = 8, fd = 536269882, user_data = 0x8321b40c0}, {pos = 4096, events = 0, fd = 4097, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x833c03238}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558056072, user_data = 0x82b815858}, {pos = 558035976, events = 8, fd = 556627528, user_data = 0x8212d7808}, {pos = 556627504, events = 8, fd = 536288418, user_data = 0x2981b3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821435038}} [01:45:30.130] last_touch_time = 1733794860 [01:45:30.130] last_lockfile_recheck_time = 1733794860 [01:45:30.130] nevents = 1 [01:45:30.130] #21 0x000000000089aea9 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8212d8008) at ../src/backend/postmaster/postmaster.c:1374 [01:45:30.130] userDoption = [01:45:30.130] listen_addr_saved = false [01:45:30.130] output_config_variable = [01:45:30.130] opt = [01:45:30.130] status = [01:45:30.130] #22 0x00000000007d2abd in main (argc=8, argv=0x8212d8008) at ../src/backend/main/main.c:222 [01:45:30.130] do_check_root = [01:45:30.130] dispatch_option = DISPATCH_POSTMASTER [01:45:30.139] [01:45:30.139] [01:45:30.139] [01:45:30.200] dumping /tmp/cores/postgres.11246.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:45:30.321] [New LWP 101914] [01:45:30.386] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [01:45:30.386] Program terminated with signal SIGABRT, Aborted. [01:45:30.386] Sent by thr_kill() from pid 11246 and user 1003. [01:45:30.386] #0 0x000000082c45041a in thr_kill () from /lib/libc.so.7 [01:45:30.422] [01:45:30.422] Thread 1 (LWP 101914): [01:45:30.422] #0 0x000000082c45041a in thr_kill () from /lib/libc.so.7 [01:45:30.422] No symbol table info available. [01:45:30.422] #1 0x000000082c3c9e64 in raise () from /lib/libc.so.7 [01:45:30.422] No symbol table info available. [01:45:30.422] #2 0x000000082c47a6f9 in abort () from /lib/libc.so.7 [01:45:30.422] No symbol table info available. [01:45:30.422] #3 0x0000000000aa19b5 in ExceptionalCondition (conditionName=0x2ecf53 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [01:45:30.422] No locals. [01:45:30.422] #4 0x000000000076f549 in standard_ExecutorStart (queryDesc=0x8392fcb40, eflags=0) at ../src/backend/executor/execMain.c:193 [01:45:30.422] estate = 0x8393ed100 [01:45:30.422] oldcontext = 0x83931b800 [01:45:30.422] #5 0x0000000000704d15 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [01:45:30.422] copied_query = [01:45:30.422] rewritten = [01:45:30.422] plan = 0x8392fc6e8 [01:45:30.422] queryDesc = 0x8392fcb40 [01:45:30.422] processed = [01:45:30.422] __error = [01:45:30.422] #6 RefreshMatViewByOid (matviewOid=28387, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [01:45:30.422] dest = [01:45:30.422] save_userid = 10 [01:45:30.422] save_sec_context = 0 [01:45:30.422] processed = 0 [01:45:30.422] matviewRel = 0x845c03ba8 [01:45:30.422] relowner = 10 [01:45:30.422] save_nestlevel = 2 [01:45:30.422] rule = [01:45:30.422] actions = [01:45:30.422] dataQuery = [01:45:30.422] tableSpace = [01:45:30.422] relpersistence = [01:45:30.422] OIDNewHeap = 28401 [01:45:30.422] address = [01:45:30.422] #7 0x00000000007048f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:45:30.422] lockmode = [01:45:30.422] matviewOid = 0 [01:45:30.422] #8 0x00000000006dba0c in ExecCreateTableAs (pstate=pstate@entry=0x83931b900, stmt=stmt@entry=0x839308fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821a27510) at ../src/backend/commands/createas.c:351 [01:45:30.422] refresh = 0x0 [01:45:30.422] query = 0x8393bb298 [01:45:30.422] into = 0x8393bb5e0 [01:45:30.422] jstate = 0x0 [01:45:30.422] do_refresh = false [01:45:30.422] address = [01:45:30.422] dest = [01:45:30.422] is_matview = [01:45:30.422] #9 0x000000000094c3e8 in ProcessUtilitySlow (pstate=pstate@entry=0x83931b900, pstmt=pstmt@entry=0x839229a68, queryString=queryString@entry=0x839228100 "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=, qc=0x821a27510) at ../src/backend/tcop/utility.c:1678 [01:45:30.422] _local_sigjmp_buf = {{_sjb = {9747481, 0, 34924032312, 34924032688, 34924032320, 12442504, 0, 35319298304, 12387199, 1, 4294967295, 34359738368}}} [01:45:30.422] _save_exception_stack = 0x821a27410 [01:45:30.422] _save_context_stack = 0x0 [01:45:30.422] _do_rethrow = false [01:45:30.422] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:45:30.422] parsetree = 0x839308fd0 [01:45:30.422] commandCollected = false [01:45:30.422] needCleanup = false [01:45:30.422] address = [01:45:30.422] isTopLevel = [01:45:30.422] isCompleteQuery = [01:45:30.422] #10 0x000000000094ad68 in standard_ProcessUtility (pstmt=0x839229a68, queryString=0x839228100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8393bbac8, qc=0x821a27510) at ../src/backend/tcop/utility.c:1033 [01:45:30.422] isAtomicContext = false [01:45:30.422] parsetree = 0x839308fd0 [01:45:30.422] readonly_flags = [01:45:30.422] pstate = 0x83931b900 [01:45:30.422] isTopLevel = [01:45:30.422] #11 0x000000000094a7f8 in ProcessUtility (pstmt=0x18e1a, queryString=0x6 , readOnlyTree=, context=742720506, params=0x0, queryEnv=0x0, dest=0x8393bbac8, qc=0x821a27510) at ../src/backend/tcop/utility.c:523 [01:45:30.422] No locals. [01:45:30.422] #12 0x000000000094a333 in PortalRunUtility (portal=0x8392ce100, pstmt=0x839229a68, isTopLevel=, setHoldSnapshot=, dest=0x8393bbac8, qc=0x821a27510) at ../src/backend/tcop/pquery.c:1152 [01:45:30.422] No locals. [01:45:30.422] #13 0x00000000009499f4 in PortalRunMulti (portal=portal@entry=0x8392ce100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8393bbac8, altdest=altdest@entry=0x8393bbac8, qc=qc@entry=0x821a27510) at ../src/backend/tcop/pquery.c:1316 [01:45:30.422] pstmt = 0x839229a68 [01:45:30.422] stmtlist_item__state = {l = 0x8393bba78, i = 0} [01:45:30.422] active_snapshot_set = false [01:45:30.422] stmtlist_item = 0x8393bba90 [01:45:30.422] #14 0x00000000009492db in PortalRun (portal=portal@entry=0x8392ce100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8393bbac8, altdest=altdest@entry=0x8393bbac8, qc=qc@entry=0x821a27510) at ../src/backend/tcop/pquery.c:787 [01:45:30.422] _local_sigjmp_buf = {{_sjb = {9736789, 35318980864, 34924033032, 34924033280, 34924033040, 12442504, 34924033296, 12408104, 12387199, 0, 35318989695, 34359738368}}} [01:45:30.422] _save_exception_stack = 0x821a275c0 [01:45:30.422] _save_context_stack = 0x0 [01:45:30.422] _do_rethrow = false [01:45:30.422] saveTopTransactionResourceOwner = 0x83931d858 [01:45:30.422] saveTopTransactionContext = 0x8392d2000 [01:45:30.422] saveActivePortal = 0x0 [01:45:30.422] saveResourceOwner = 0x83931d858 [01:45:30.422] savePortalContext = 0x0 [01:45:30.422] saveMemoryContext = 0x8392d2000 [01:45:30.422] result = [01:45:30.422] nprocessed = [01:45:30.422] #15 0x0000000000948169 in exec_simple_query (query_string=query_string@entry=0x839228100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [01:45:30.422] cmdtaglen = 24 [01:45:30.422] snapshot_set = [01:45:30.422] per_parsetree_context = 0x0 [01:45:30.422] plantree_list = [01:45:30.422] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:45:30.422] format = 0 [01:45:30.422] parsetree = 0x8392296a8 [01:45:30.422] commandTag = [01:45:30.422] cmdtagname = [01:45:30.422] querytree_list = [01:45:30.422] portal = 0x8392ce100 [01:45:30.422] receiver = 0x8393bbac8 [01:45:30.422] parsetree_item__state = {l = 0x839229a18, i = 0} [01:45:30.422] msec_str = "\000\000\000\000\b", '\000' , "C\234Wg\000\000\000\0000\245\233\330", [01:45:30.422] dest = DestRemote [01:45:30.422] was_logged = [01:45:30.422] oldcontext = 0x8392d2000 [01:45:30.422] parsetree_list = 0x839229a18 [01:45:30.422] use_implicit_block = false [01:45:30.422] parsetree_item = 0x839229a30 [01:45:30.422] save_log_statement_stats = [01:45:30.422] #16 0x0000000000945dd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4816 [01:45:30.422] query_string = 0x839228100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:45:30.422] input_message = {data = 0x839228100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:45:30.422] firstchar = [01:45:30.422] local_sigjmp_buf = {{_sjb = {9720454, 34924033472, 34924033464, 34924034016, 12451240, 1, 8192, 8388608, 34924004223, 0, 0, 1}}} [01:45:30.422] send_ready_for_query = false [01:45:30.422] idle_in_transaction_timeout_enabled = false [01:45:30.422] idle_session_timeout_enabled = false [01:45:30.422] #17 0x0000000000940569 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [01:45:30.422] bsdata = [01:45:30.422] #18 0x00000000008986c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x821a282f8 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a28240) at ../src/backend/postmaster/launch_backend.c:274 [01:45:30.422] pid = [01:45:30.422] #19 0x000000000089c8a8 in BackendStartup (client_sock=0x821a28240) at ../src/backend/postmaster/postmaster.c:3390 [01:45:30.422] startup_data = {canAcceptConnections = CAC_OK} [01:45:30.422] bn = 0x8392ec3c8 [01:45:30.422] cac = CAC_OK [01:45:30.422] pid = [01:45:30.422] __error = [01:45:30.422] save_errno = [01:45:30.422] __error = [01:45:30.422] __error = [01:45:30.422] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [01:45:30.422] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\f", '\000' , "\240\202\242!\b\000\000\000h\225r+\b\000\000\000\331\000\000\000\000\000\000\000^\037s+\b", '\000' , "\340\202\242!\b\000\000\000d\204\211\000\000\000\000\000\360\202\242!\b", '\000' }, salen = 16}} [01:45:30.422] i = 0 [01:45:30.422] now = [01:45:30.422] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 741599939, events = 8, fd = 128686702, user_data = 0x36311c93dacf}, {pos = 574118456, events = 8, fd = 1, user_data = 0x82237f408}, {pos = 741470568, events = 8, fd = 564296472, user_data = 0x821a27a60}, {pos = 564295888, events = 8, fd = 1, user_data = 0x82237f408}, {pos = 32, events = 0, fd = 564296272, user_data = 0x3631d43c6a1a}, {pos = 574062600, events = 8, fd = 574063624, user_data = 0x822378808}, {pos = 574065672, events = 8, fd = 574078984, user_data = 0x82237c408}, {pos = 574081032, events = 8, fd = 574082056, user_data = 0x82237d008}, {pos = 574084104, events = 8, fd = 574085128, user_data = 0x82237dc08}, {pos = 574087176, events = 8, fd = 574088200, user_data = 0x82237e808}, {pos = 574090248, events = 8, fd = 574091272, user_data = 0x82237f408}, {pos = -25761258, events = 8, fd = 574115896, user_data = 0x1}, {pos = 574092296, events = 8, fd = 741491832, user_data = 0x821a27c98}, {pos = 2841949, events = 0, fd = 564296672, user_data = 0x821a27a50}, {pos = 1, events = 0, fd = 564296600, user_data = 0x20}, {pos = 564296256, events = 8, fd = -734213517, user_data = 0x82237f408}, {pos = 741599939, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 574118456, events = 8, fd = 1, user_data = 0x82237f408}, {pos = 741470568, events = 8, fd = 564296472, user_data = 0x821a278d0}, {pos = 32, events = 18, fd = 0, user_data = 0x822385a38}, {pos = 1, events = 0, fd = 574092296, user_data = 0x347}, {pos = 564296448, events = 8, fd = -734239249, user_data = 0x82c33eac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822385a38}, {pos = 1, events = 0, fd = 574092296, user_data = 0x839218000}, {pos = 1, events = 0, fd = 958497172, user_data = 0x0}, {pos = 564296400, events = 8, fd = 728962412, user_data = 0x1}, {pos = 958496768, events = 8, fd = 564296448, user_data = 0x82b730702}, {pos = 743307600, events = 8, fd = 743395704, user_data = 0x82c4df950 }, {pos = 574092296, events = 8, fd = 564296672, user_data = 0x3631d43c63de}, {pos = 574083080, events = 8, fd = 1, user_data = 0x3631d43c625e}, {pos = 574092296, events = 8, fd = 564296456, user_data = 0x821a27be0}, {pos = 12264, events = 0, fd = 0, user_data = 0x3631d43d9990}, {pos = 564298064, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = 233872860, events = 883290516, fd = 0, user_data = 0x82237f408}, {pos = 12264, events = 0, fd = 741449728, user_data = 0x1db178}, {pos = 743307600, events = 8, fd = 741584248, user_data = 0x3d4b}, {pos = 743454368, events = 8, fd = 564296784, user_data = 0x82c3de915 }, {pos = 743345720, events = 8, fd = 564296720, user_data = 0x821a28080}, {pos = 0, events = 0, fd = 564296784, user_data = 0x82c3f4b61}, {pos = 1, events = 0, fd = 564297856, user_data = 0x821a28080}, {pos = 0, events = 16777216, fd = 233872860, user_data = 0x82c5036a0 <__stack_chk_guard>}, {pos = 958997976, events = 8, fd = 0, user_data = 0x82c4e8e38}, {pos = 564298064, events = 8, fd = 564297920, user_data = 0x82c3f4c82}, {pos = 0, events = 0, fd = 564298224, user_data = 0x8392925d8}, {pos = 564297856, events = 8, fd = 0, user_data = 0x0}, {pos = 233872860, events = 883290516, fd = -734211318, user_data = 0x82c3297a0}, {pos = 741584248, events = 8, fd = 564296968, user_data = 0x821a27d80}, {pos = 564296968, events = 8, fd = -734211318, user_data = 0x82c324388}, {pos = 741584248, events = 8, fd = 564297016, user_data = 0x821a27db0}, {pos = 564297016, events = 8, fd = 741552532, user_data = 0x82237f408}, {pos = 741552532, events = 8, fd = 564297120, user_data = 0x3631d43c843a}, {pos = 743374896, events = 8, fd = 1, user_data = 0x821a27dd0}, {pos = -734211318, events = 13873, fd = 741460056, user_data = 0x82c33ad78}, {pos = 564297128, events = 8, fd = 564297248, user_data = 0x821a27da8}, {pos = 741547276, events = 8, fd = 574092296, user_data = 0x82c331d0c}, {pos = 564297232, events = 8, fd = -734231494, user_data = 0x821a27e38}, {pos = 564297720, events = 8, fd = 564297248, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x34a5f194526629ce}, {pos = 574115896, events = 8, fd = 1, user_data = 0x82237f408}, {pos = 741491592, events = 8, fd = 574112392, user_data = 0x82c31c858}, {pos = 574092296, events = 8, fd = 564297384, user_data = 0x821a28068}, {pos = 564297360, events = 8, fd = -734212958, user_data = 0x2981b3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822385038}} [01:45:30.422] last_touch_time = 1733794860 [01:45:30.422] last_lockfile_recheck_time = 1733794860 [01:45:30.422] nevents = 1 [01:45:30.422] #21 0x000000000089aea9 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a28860) at ../src/backend/postmaster/postmaster.c:1374 [01:45:30.422] userDoption = [01:45:30.422] listen_addr_saved = false [01:45:30.422] output_config_variable = [01:45:30.422] opt = [01:45:30.422] status = [01:45:30.422] #22 0x00000000007d2abd in main (argc=4, argv=0x821a28860) at ../src/backend/main/main.c:222 [01:45:30.422] do_check_root = [01:45:30.422] dispatch_option = DISPATCH_POSTMASTER [01:45:30.432] [01:45:30.432] [01:45:30.432] [01:45:30.497] dumping /tmp/cores/postgres.17866.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:45:30.623] [New LWP 101898] [01:45:30.687] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [01:45:30.687] Program terminated with signal SIGABRT, Aborted. [01:45:30.687] Sent by thr_kill() from pid 17866 and user 1003. [01:45:30.687] #0 0x0000000828dbf41a in thr_kill () from /lib/libc.so.7 [01:45:30.728] [01:45:30.728] Thread 1 (LWP 101898): [01:45:30.728] #0 0x0000000828dbf41a in thr_kill () from /lib/libc.so.7 [01:45:30.728] No symbol table info available. [01:45:30.728] #1 0x0000000828d38e64 in raise () from /lib/libc.so.7 [01:45:30.728] No symbol table info available. [01:45:30.728] #2 0x0000000828de96f9 in abort () from /lib/libc.so.7 [01:45:30.728] No symbol table info available. [01:45:30.728] #3 0x0000000000aa19b5 in ExceptionalCondition (conditionName=0x2ecf53 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [01:45:30.728] No locals. [01:45:30.728] #4 0x000000000076f549 in standard_ExecutorStart (queryDesc=0x832ad6b40, eflags=0) at ../src/backend/executor/execMain.c:193 [01:45:30.728] estate = 0x839843100 [01:45:30.728] oldcontext = 0x832ae7800 [01:45:30.728] #5 0x0000000835ac09c2 in pgss_ExecutorStart (queryDesc=0x832ad6b40, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [01:45:30.728] No locals. [01:45:30.728] #6 0x0000000000704d15 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [01:45:30.728] copied_query = [01:45:30.728] rewritten = [01:45:30.728] plan = 0x832ad66e8 [01:45:30.728] queryDesc = 0x832ad6b40 [01:45:30.728] processed = [01:45:30.728] __error = [01:45:30.728] #7 RefreshMatViewByOid (matviewOid=28466, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [01:45:30.728] dest = [01:45:30.728] save_userid = 10 [01:45:30.728] save_sec_context = 0 [01:45:30.728] processed = 0 [01:45:30.728] matviewRel = 0x8398c72e8 [01:45:30.728] relowner = 10 [01:45:30.728] save_nestlevel = 2 [01:45:30.728] rule = [01:45:30.728] actions = [01:45:30.728] dataQuery = [01:45:30.728] tableSpace = [01:45:30.728] relpersistence = [01:45:30.728] OIDNewHeap = 28473 [01:45:30.728] address = [01:45:30.728] #8 0x00000000007048f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:45:30.728] lockmode = [01:45:30.728] matviewOid = 0 [01:45:30.728] #9 0x00000000006dba0c in ExecCreateTableAs (pstate=pstate@entry=0x832ae7900, stmt=stmt@entry=0x832a9efd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82132dff0) at ../src/backend/commands/createas.c:351 [01:45:30.728] refresh = 0x0 [01:45:30.728] query = 0x83980c748 [01:45:30.728] into = 0x832a9ef40 [01:45:30.728] jstate = 0x0 [01:45:30.728] do_refresh = false [01:45:30.728] address = [01:45:30.728] dest = [01:45:30.728] is_matview = [01:45:30.728] #10 0x000000000094c3e8 in ProcessUtilitySlow (pstate=pstate@entry=0x832ae7900, pstmt=pstmt@entry=0x832a9ee30, queryString=queryString@entry=0x832941100 "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=, qc=0x82132dff0) at ../src/backend/tcop/utility.c:1678 [01:45:30.728] _local_sigjmp_buf = {{_sjb = {9747481, 0, 34916719192, 34916719568, 34916719200, 12442504, 0, 35210033408, 895, 1, 34916719324, 0}}} [01:45:30.728] _save_exception_stack = 0x82132dce0 [01:45:30.728] _save_context_stack = 0x0 [01:45:30.728] _do_rethrow = false [01:45:30.728] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:45:30.728] parsetree = 0x832a9efd0 [01:45:30.728] commandCollected = false [01:45:30.728] needCleanup = false [01:45:30.728] address = [01:45:30.728] isTopLevel = [01:45:30.728] isCompleteQuery = [01:45:30.728] #11 0x000000000094ad68 in standard_ProcessUtility (pstmt=0x832a9ee30, queryString=queryString@entry=0x832941100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83980cee8, qc=0x82132dff0) at ../src/backend/tcop/utility.c:1033 [01:45:30.728] isAtomicContext = false [01:45:30.728] parsetree = 0x832a9efd0 [01:45:30.728] readonly_flags = [01:45:30.728] pstate = 0x832ae7900 [01:45:30.728] isTopLevel = [01:45:30.728] #12 0x0000000835ac0f6e in pgss_ProcessUtility (pstmt=0x832a9ee30, queryString=0x832941100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83980cee8, qc=0x82132dff0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [01:45:30.728] _local_sigjmp_buf = {{_sjb = {35260206759, 34916719840, 34916719704, 34916720160, 35209735728, 0, 12442504, 34916720368, 895, 1, 34916719956, 34359738368}}} [01:45:30.728] _save_exception_stack = 0x82132def0 [01:45:30.728] _save_context_stack = 0x0 [01:45:30.728] _do_rethrow = false [01:45:30.728] bufusage = {shared_blks_hit = 35260206759, shared_blks_read = 34916719840, shared_blks_dirtied = 34916719704, shared_blks_written = 34916720160, local_blks_hit = 35209735728, local_blks_read = 0, local_blks_dirtied = 12442504, local_blks_written = 34916720368, temp_blks_read = 895, temp_blks_written = 1, shared_blk_read_time = {ticks = 34916719956}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 3890543834764740736}, local_blk_write_time = {ticks = 12451528}, temp_blk_read_time = {ticks = 35269761024}, temp_blk_write_time = {ticks = 12404048}} [01:45:30.728] walusage_start = {wal_records = 8986, wal_fpi = 148, wal_bytes = 1385918} [01:45:30.728] duration = [01:45:30.728] bufusage_start = {shared_blks_hit = 153299, shared_blks_read = 9656, shared_blks_dirtied = 2761, shared_blks_written = 2276, local_blks_hit = 45, local_blks_read = 0, local_blks_dirtied = 10, local_blks_written = 17, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [01:45:30.728] walusage = {wal_records = 0, wal_fpi = 549755813888, wal_bytes = 16832554120747873312} [01:45:30.728] start = {ticks = -289412769146} [01:45:30.728] rows = [01:45:30.728] saved_queryId = 6041762721901209185 [01:45:30.728] parsetree = [01:45:30.728] saved_stmt_location = 0 [01:45:30.728] saved_stmt_len = 69 [01:45:30.728] enabled = [01:45:30.728] #13 0x000000000094a333 in PortalRunUtility (portal=0x8329e7100, pstmt=0x832a9ee30, isTopLevel=, setHoldSnapshot=, dest=0x83980cee8, qc=0x82132dff0) at ../src/backend/tcop/pquery.c:1152 [01:45:30.728] No locals. [01:45:30.728] #14 0x00000000009499f4 in PortalRunMulti (portal=portal@entry=0x8329e7100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83980cee8, altdest=altdest@entry=0x83980cee8, qc=qc@entry=0x82132dff0) at ../src/backend/tcop/pquery.c:1316 [01:45:30.728] pstmt = 0x832a9ee30 [01:45:30.728] stmtlist_item__state = {l = 0x83980ce98, i = 0} [01:45:30.728] active_snapshot_set = false [01:45:30.728] stmtlist_item = 0x83980ceb0 [01:45:30.728] #15 0x00000000009492db in PortalRun (portal=portal@entry=0x8329e7100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x83980cee8, altdest=altdest@entry=0x83980cee8, qc=qc@entry=0x82132dff0) at ../src/backend/tcop/pquery.c:787 [01:45:30.728] _local_sigjmp_buf = {{_sjb = {9736789, 35208982784, 34916720360, 34916720608, 34916720368, 12442504, 34916720624, 12408104, 12387199, 0, 35208954751, 34359738368}}} [01:45:30.728] _save_exception_stack = 0x82132e0a0 [01:45:30.728] _save_context_stack = 0x0 [01:45:30.728] _do_rethrow = false [01:45:30.728] saveTopTransactionResourceOwner = 0x832a3c198 [01:45:30.728] saveTopTransactionContext = 0x8329eb000 [01:45:30.728] saveActivePortal = 0x0 [01:45:30.728] saveResourceOwner = 0x832a3c198 [01:45:30.728] savePortalContext = 0x0 [01:45:30.728] saveMemoryContext = 0x8329eb000 [01:45:30.728] result = [01:45:30.728] nprocessed = [01:45:30.728] #16 0x0000000000948169 in exec_simple_query (query_string=query_string@entry=0x832941100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [01:45:30.728] cmdtaglen = 24 [01:45:30.728] snapshot_set = [01:45:30.728] per_parsetree_context = 0x0 [01:45:30.728] plantree_list = [01:45:30.728] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:45:30.728] format = 0 [01:45:30.728] parsetree = 0x8329426a8 [01:45:30.728] commandTag = [01:45:30.728] cmdtagname = [01:45:30.728] querytree_list = [01:45:30.728] portal = 0x8329e7100 [01:45:30.728] receiver = 0x83980cee8 [01:45:30.728] parsetree_item__state = {l = 0x832942a18, i = 0} [01:45:30.728] msec_str = "\000\000\000\000\b", '\000' , "f\234Wg\000\000\000\000\262l\341\003#\305j\214" [01:45:30.728] dest = DestRemote [01:45:30.728] was_logged = [01:45:30.728] oldcontext = 0x8329eb000 [01:45:30.728] parsetree_list = 0x832942a18 [01:45:30.728] use_implicit_block = false [01:45:30.728] parsetree_item = 0x832942a30 [01:45:30.728] save_log_statement_stats = [01:45:30.728] #17 0x0000000000945dd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4816 [01:45:30.728] query_string = 0x832941100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:45:30.728] input_message = {data = 0x832941100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:45:30.728] firstchar = [01:45:30.728] local_sigjmp_buf = {{_sjb = {9720454, 34916720800, 34916720792, 34916721344, 12451240, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [01:45:30.728] send_ready_for_query = false [01:45:30.728] idle_in_transaction_timeout_enabled = false [01:45:30.728] idle_session_timeout_enabled = false [01:45:30.728] #18 0x0000000000940569 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [01:45:30.728] bsdata = [01:45:30.728] #19 0x00000000008986c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x82132edd8 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82132ed20) at ../src/backend/postmaster/launch_backend.c:274 [01:45:30.728] pid = [01:45:30.728] #20 0x000000000089c8a8 in BackendStartup (client_sock=0x82132ed20) at ../src/backend/postmaster/postmaster.c:3390 [01:45:30.728] startup_data = {canAcceptConnections = CAC_OK} [01:45:30.728] bn = 0x832a28d08 [01:45:30.728] cac = CAC_OK [01:45:30.728] pid = [01:45:30.728] __error = [01:45:30.728] save_errno = [01:45:30.728] __error = [01:45:30.728] __error = [01:45:30.728] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [01:45:30.728] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\f", '\000' , "\200\3552!\b\000\000\000h%H'\b\000\000\000W\000\000\000\000\000\000\000^\257H'\b", '\000' , "\300\3552!\b\000\000\000d\204\211\000\000\000\000\000\320\3552!\b", '\000' }, salen = 16}} [01:45:30.728] i = 0 [01:45:30.728] now = [01:45:30.728] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 479451855, events = 10586, fd = 558205496, user_data = 0x800000001}, {pos = 558179336, events = 8, fd = 684253544, user_data = 0x82132e5f8}, {pos = 556983616, events = 8, fd = 556983200, user_data = 0x1}, {pos = 558179336, events = 8, fd = 33, user_data = 0x82132e530}, {pos = -1782986214, events = 10586, fd = 558149640, user_data = 0x82144b408}, {pos = 558151688, events = 8, fd = 558152712, user_data = 0x82144f008}, {pos = 558167048, events = 8, fd = 558168072, user_data = 0x82144fc08}, {pos = 558170120, events = 8, fd = 558171144, user_data = 0x821450808}, {pos = 558173192, events = 8, fd = 558174216, user_data = 0x821451408}, {pos = 558176264, events = 8, fd = 558177288, user_data = 0x821452008}, {pos = 558179336, events = 8, fd = -25761258, user_data = 0x821458038}, {pos = 1, events = 8, fd = 558179336, user_data = 0x828c93478}, {pos = 556984184, events = 8, fd = 15, user_data = 0x82132e6c0}, {pos = 556983584, events = 8, fd = 1, user_data = 0x82132e678}, {pos = 33, events = 0, fd = 556983568, user_data = 0x295a95ba2a73}, {pos = 556983536, events = 8, fd = 2591802, user_data = 0x821452408}, {pos = 684382915, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 558205496, events = 8, fd = 1, user_data = 0x821452408}, {pos = 684253544, events = 8, fd = 556983800, user_data = 0x82132e3a0}, {pos = 33, events = 18, fd = 0, user_data = 0x821458a38}, {pos = 1, events = 0, fd = 558179336, user_data = 0x347}, {pos = 556983776, events = 8, fd = -1782987281, user_data = 0x828cadac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821458a38}, {pos = 1, events = 0, fd = 558179336, user_data = 0x832931000}, {pos = 1, events = 0, fd = 848499092, user_data = 0x0}, {pos = 556983728, events = 8, fd = 659072364, user_data = 0x1}, {pos = 848498688, events = 8, fd = 556983776, user_data = 0x827489702}, {pos = 686090576, events = 8, fd = 686178680, user_data = 0x828e4e950 }, {pos = 558179336, events = 8, fd = 556984000, user_data = 0x295a95b9c3de}, {pos = 556984456, events = 8, fd = 1, user_data = 0x295a95b9c25e}, {pos = 558179336, events = 8, fd = 556983784, user_data = 0x82132e6c0}, {pos = 12264, events = 0, fd = 0, user_data = 0x295a95baf990}, {pos = 556985392, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = 1169617952, events = 3919134410, fd = 0, user_data = 0x821452408}, {pos = 12264, events = 0, fd = 684232704, user_data = 0x1db178}, {pos = 686090576, events = 8, fd = 684367224, user_data = 0x3d4b}, {pos = 686237344, events = 8, fd = 556984112, user_data = 0x828d4d915 }, {pos = 686128696, events = 8, fd = 556984048, user_data = 0x82132eb60}, {pos = 0, events = 0, fd = 556984112, user_data = 0x828d63b61}, {pos = 1, events = 0, fd = 556985184, user_data = 0x82132eb60}, {pos = 0, events = 16777216, fd = 1169617952, user_data = 0x828e726a0 <__stack_chk_guard>}, {pos = 848971224, events = 8, fd = 0, user_data = 0x828e57e38}, {pos = 556985392, events = 8, fd = 556985248, user_data = 0x828d63c82}, {pos = 0, events = 0, fd = 556985552, user_data = 0x8329a45d8}, {pos = 556985184, events = 8, fd = 0, user_data = 0x295a95ba330a}, {pos = 684296096, events = 8, fd = 684367224, user_data = 0x82132e7d8}, {pos = 556984400, events = 8, fd = 556984280, user_data = 0x295a95ba330a}, {pos = 684274568, events = 8, fd = 684367224, user_data = 0x82132e808}, {pos = 556984448, events = 8, fd = 556984328, user_data = 0x828ca2194}, {pos = 558179336, events = 8, fd = 684335508, user_data = 0x82132e870}, {pos = -1782979526, events = 10586, fd = 556984336, user_data = 0x827480410 <__pthread_cleanup_pop_imp+48>}, {pos = 686157872, events = 8, fd = -1782959350, user_data = 0x828c8b858}, {pos = 684367224, events = 8, fd = 556984440, user_data = 0x82132e8f0}, {pos = 556984440, events = 8, fd = 684330252, user_data = 0x821452408}, {pos = 684330252, events = 8, fd = 556984544, user_data = 0x295a95b9e43a}, {pos = 556984584, events = 8, fd = 556985048, user_data = 0x82132e8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 558202936, user_data = 0xe9993eca00000001}, {pos = 558179336, events = 8, fd = 684274568, user_data = 0x8214577c8}, {pos = 0, events = 0, fd = 0, user_data = 0x82132e978}, {pos = 556985160, events = 8, fd = 556984672, user_data = 0x295a95ba2ca2}, {pos = 2720179, events = 0, fd = 448139, user_data = 0xe9993eca7c96e577}, {pos = 558202936, events = 8, fd = 1, user_data = 0x0}} [01:45:30.728] last_touch_time = 1733794895 [01:45:30.728] last_lockfile_recheck_time = 1733794895 [01:45:30.728] nevents = 1 [01:45:30.728] #22 0x000000000089aea9 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82132f348) at ../src/backend/postmaster/postmaster.c:1374 [01:45:30.728] userDoption = [01:45:30.728] listen_addr_saved = false [01:45:30.728] output_config_variable = [01:45:30.728] opt = [01:45:30.728] status = [01:45:30.728] #23 0x00000000007d2abd in main (argc=4, argv=0x82132f348) at ../src/backend/main/main.c:222 [01:45:30.728] do_check_root = [01:45:30.728] dispatch_option = DISPATCH_POSTMASTER [01:45:30.738] [01:45:30.738] [01:45:30.738] [01:45:30.790] dumping /tmp/cores/cp.25153.core for /bin/cp [01:45:30.830] [New LWP 101893] [01:45:30.835] Core was generated by `cp pg_wal/000000010000000000000003 /tmp/cirrus-ci-build/build/testrun/pg_combine'. [01:45:30.835] Program terminated with signal SIGQUIT, Quit. [01:45:30.835] Sent by kill() from pid 25124 and user 1003. [01:45:30.835] #0 0x000030c87572423a in copy_file_range () from /lib/libc.so.7 [01:45:30.835] [01:45:30.835] Thread 1 (LWP 101893): [01:45:30.835] #0 0x000030c87572423a in copy_file_range () from /lib/libc.so.7 [01:45:30.835] No symbol table info available. [01:45:30.835] #1 0x000030c0541fe3e0 in ?? () [01:45:30.835] No symbol table info available. [01:45:30.835] #2 0x000030c0541fe01e in ?? () [01:45:30.835] No symbol table info available. [01:45:30.835] #3 0x000030c0541fd8ad in ?? () [01:45:30.835] No symbol table info available. [01:45:30.835] #4 0x000030c0541fd33d in ?? () [01:45:30.835] No symbol table info available. [01:45:30.835] #5 0x000030c8754fc408 in ?? () [01:45:30.835] No symbol table info available. [01:45:30.835] #6 0x0000000000000000 in ?? () [01:45:30.835] No symbol table info available.