[19:34:24.899] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [19:34:25.207] dumping /tmp/cores/postgres.11020.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [19:34:25.352] [New LWP 101939] [19:34:25.440] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [19:34:25.440] Program terminated with signal SIGABRT, Aborted. [19:34:25.440] Sent by thr_kill() from pid 11020 and user 1003. [19:34:25.440] #0 0x000000082bb0041a in thr_kill () from /lib/libc.so.7 [19:34:25.498] [19:34:25.498] Thread 1 (LWP 101939): [19:34:25.498] #0 0x000000082bb0041a in thr_kill () from /lib/libc.so.7 [19:34:25.498] No symbol table info available. [19:34:25.498] #1 0x000000082ba79e64 in raise () from /lib/libc.so.7 [19:34:25.498] No symbol table info available. [19:34:25.498] #2 0x000000082bb2a6f9 in abort () from /lib/libc.so.7 [19:34:25.498] No symbol table info available. [19:34:25.498] #3 0x0000000000aa2d35 in ExceptionalCondition (conditionName=0x2ed359 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [19:34:25.498] No locals. [19:34:25.498] #4 0x0000000000769b69 in standard_ExecutorStart (queryDesc=0x835914bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [19:34:25.498] estate = 0x843edc100 [19:34:25.498] oldcontext = 0x8359c2800 [19:34:25.498] #5 0x00000000006fdd1f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [19:34:25.498] copied_query = [19:34:25.498] rewritten = [19:34:25.498] plan = 0x835914778 [19:34:25.498] queryDesc = 0x835914bd0 [19:34:25.498] processed = [19:34:25.498] __error = [19:34:25.498] #6 RefreshMatViewByOid (matviewOid=28559, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [19:34:25.498] dest = [19:34:25.498] save_userid = 10 [19:34:25.498] save_sec_context = 0 [19:34:25.498] processed = 0 [19:34:25.498] matviewRel = 0x843f6dab8 [19:34:25.498] relowner = 10 [19:34:25.498] save_nestlevel = 2 [19:34:25.498] rule = [19:34:25.498] actions = [19:34:25.498] dataQuery = [19:34:25.498] tableSpace = [19:34:25.498] relpersistence = [19:34:25.498] OIDNewHeap = 28567 [19:34:25.498] address = [19:34:25.498] #7 0x00000000006fd8f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:34:25.498] lockmode = [19:34:25.498] matviewOid = 0 [19:34:25.498] #8 0x00000000006d48ec in ExecCreateTableAs (pstate=pstate@entry=0x8359c2900, stmt=stmt@entry=0x83590cfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8210360c0) at ../src/backend/commands/createas.c:351 [19:34:25.498] refresh = 0x0 [19:34:25.498] query = 0x83592bf98 [19:34:25.498] into = 0x83592c2e0 [19:34:25.498] jstate = 0x0 [19:34:25.498] do_refresh = false [19:34:25.498] address = [19:34:25.498] dest = [19:34:25.498] is_matview = [19:34:25.498] #9 0x000000000094a49e in ProcessUtilitySlow (pstate=pstate@entry=0x8359c2900, pstmt=pstmt@entry=0x83584ea68, queryString=queryString@entry=0x83584d100 "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=0x8210360c0) at ../src/backend/tcop/utility.c:1678 [19:34:25.498] _local_sigjmp_buf = {{_sjb = {9739468, 0, 34913606888, 34913607264, 34913606896, 12564408, 0, 35259164928, 12452735, 1, 4294967295, 34359738368}}} [19:34:25.498] _save_exception_stack = 0x821035fc0 [19:34:25.498] _save_context_stack = 0x0 [19:34:25.498] _do_rethrow = false [19:34:25.498] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:34:25.498] parsetree = 0x83590cfd0 [19:34:25.498] commandCollected = false [19:34:25.498] needCleanup = false [19:34:25.498] address = [19:34:25.498] isTopLevel = [19:34:25.498] isCompleteQuery = [19:34:25.498] #10 0x0000000000948e1b in standard_ProcessUtility (pstmt=0x83584ea68, queryString=0x83584d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83592c7c8, qc=0x8210360c0) at ../src/backend/tcop/utility.c:1033 [19:34:25.498] isAtomicContext = false [19:34:25.498] parsetree = 0x83590cfd0 [19:34:25.498] readonly_flags = [19:34:25.498] pstate = 0x8359c2900 [19:34:25.498] isTopLevel = [19:34:25.498] #11 0x00000000009488a8 in ProcessUtility (pstmt=0x18e33, queryString=0x6 , readOnlyTree=, context=732955642, params=0x0, queryEnv=0x0, dest=0x83592c7c8, qc=0x8210360c0) at ../src/backend/tcop/utility.c:523 [19:34:25.498] No locals. [19:34:25.498] #12 0x00000000009483e3 in PortalRunUtility (portal=0x835924100, pstmt=0x83584ea68, isTopLevel=, setHoldSnapshot=, dest=0x83592c7c8, qc=0x8210360c0) at ../src/backend/tcop/pquery.c:1152 [19:34:25.498] No locals. [19:34:25.498] #13 0x0000000000947a94 in PortalRunMulti (portal=portal@entry=0x835924100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83592c7c8, altdest=altdest@entry=0x83592c7c8, qc=qc@entry=0x8210360c0) at ../src/backend/tcop/pquery.c:1316 [19:34:25.498] pstmt = 0x83584ea68 [19:34:25.498] stmtlist_item__state = {l = 0x83592c778, i = 0} [19:34:25.498] active_snapshot_set = false [19:34:25.498] stmtlist_item = 0x83592c790 [19:34:25.498] #14 0x000000000094737b in PortalRun (portal=portal@entry=0x835924100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x83592c7c8, altdest=altdest@entry=0x83592c7c8, qc=qc@entry=0x8210360c0) at ../src/backend/tcop/pquery.c:787 [19:34:25.498] _local_sigjmp_buf = {{_sjb = {9728757, 35258515712, 34913607608, 34913607856, 34913607616, 12564408, 34913607872, 12518840, 12518271, 0, 35258499967, 34359738368}}} [19:34:25.498] _save_exception_stack = 0x821036170 [19:34:25.498] _save_context_stack = 0x0 [19:34:25.498] _do_rethrow = false [19:34:25.498] saveTopTransactionResourceOwner = 0x835933248 [19:34:25.498] saveTopTransactionContext = 0x835928000 [19:34:25.498] saveActivePortal = 0x0 [19:34:25.498] saveResourceOwner = 0x835933248 [19:34:25.498] savePortalContext = 0x0 [19:34:25.498] saveMemoryContext = 0x835928000 [19:34:25.498] result = [19:34:25.498] nprocessed = [19:34:25.498] #15 0x00000000009461f9 in exec_simple_query (query_string=query_string@entry=0x83584d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [19:34:25.498] cmdtaglen = 24 [19:34:25.498] snapshot_set = [19:34:25.498] per_parsetree_context = 0x0 [19:34:25.498] plantree_list = [19:34:25.498] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:34:25.498] format = 0 [19:34:25.498] parsetree = 0x83584e6a8 [19:34:25.498] commandTag = [19:34:25.498] cmdtagname = [19:34:25.498] querytree_list = [19:34:25.498] portal = 0x835924100 [19:34:25.498] receiver = 0x83592c7c8 [19:34:25.498] parsetree_item__state = {l = 0x83584ea18, i = 0} [19:34:25.498] msec_str = "\000\000\000\000\b", '\000' , "\330қg\000\000\000\000\312]Z\351\323\036]$" [19:34:25.498] dest = DestRemote [19:34:25.498] was_logged = [19:34:25.498] oldcontext = 0x835928000 [19:34:25.498] parsetree_list = 0x83584ea18 [19:34:25.498] use_implicit_block = false [19:34:25.498] parsetree_item = 0x83584ea30 [19:34:25.498] save_log_statement_stats = [19:34:25.498] #16 0x0000000000943e63 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [19:34:25.498] query_string = 0x83584d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:34:25.498] input_message = {data = 0x83584d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:34:25.498] firstchar = [19:34:25.498] local_sigjmp_buf = {{_sjb = {9712390, 34913608048, 34913608040, 34913608592, 12573160, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [19:34:25.498] send_ready_for_query = false [19:34:25.498] idle_in_transaction_timeout_enabled = false [19:34:25.498] idle_session_timeout_enabled = false [19:34:25.498] #17 0x000000000093e7f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:34:25.498] bsdata = [19:34:25.498] #18 0x0000000000896035 in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x821036ea0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821036df0) at ../src/backend/postmaster/launch_backend.c:274 [19:34:25.498] pid = [19:34:25.498] #19 0x000000000089a3db in BackendStartup (client_sock=0x821036df0) at ../src/backend/postmaster/postmaster.c:3519 [19:34:25.498] startup_data = {canAcceptConnections = CAC_OK} [19:34:25.498] bn = 0x8358f0158 [19:34:25.498] cac = CAC_OK [19:34:25.498] pid = [19:34:25.498] __error = [19:34:25.498] save_errno = [19:34:25.498] __error = [19:34:25.498] __error = [19:34:25.498] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [19:34:25.498] 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' , "Pn\003!\b\000\000\000h\005\361)\b\000\000\000\372\000\000\000\000\000\000\000^\217\361)\b", '\000' , "\220n\003!\b\000\000\000\304]\211\000\000\000\000\000\240n\003!\b", '\000' }, salen = 16}} [19:34:25.498] i = 0 [19:34:25.498] now = [19:34:25.498] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 898274776, events = 8, fd = 553872432, user_data = 0x821036990}, {pos = 8192, events = 0, fd = 8192, user_data = 0x83591c000}, {pos = 553871768, events = 8, fd = 0, user_data = 0x83382b090}, {pos = 1, events = 0, fd = 553871568, user_data = 0x82bb6f9c9}, {pos = 731726728, events = 8, fd = 731819384, user_data = 0x8210368e8}, {pos = 553871712, events = 8, fd = 553871760, user_data = 0x821036988}, {pos = 864202896, events = 8, fd = 893389184, user_data = 0x20}, {pos = 4096, events = 0, fd = 553872208, user_data = 0x82bb6aa7c}, {pos = 553871752, events = 8, fd = 1584136970, user_data = 0x82b9cc858}, {pos = 731819384, events = 8, fd = 553871704, user_data = 0x8210369d0}, {pos = 553871704, events = 8, fd = 731782412, user_data = 0x821811408}, {pos = 731782412, events = 8, fd = 553871808, user_data = 0x4cd5e6bb43a}, {pos = 864202944, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 893399608, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821816288}, {pos = 731695192, events = 8, fd = 562107400, user_data = 0x821036a58}, {pos = 553872408, events = 8, fd = 553871936, user_data = 0x4cd5e6bfca2}, {pos = 2722358, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 562131000, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 553872664, user_data = 0x21811408}, {pos = 553872480, events = 8, fd = 553872080, user_data = 0x1}, {pos = 553872408, events = 8, fd = 32, user_data = 0x821036ac0}, {pos = 1584134771, events = 1229, fd = 553872352, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821817038}, {pos = 1, events = 8, fd = 562107400, user_data = 0x82b9cc858}, {pos = 553872664, events = 8, fd = 553872480, user_data = 0x821036ad0}, {pos = 0, events = 0, fd = 562077704, user_data = 0x20}, {pos = 553872464, events = 8, fd = 1584110311, user_data = 0x82180a008}, {pos = 562078728, events = 8, fd = 562079752, user_data = 0x82180ac08}, {pos = 562094088, events = 8, fd = 562095112, user_data = 0x82180e808}, {pos = 562097160, events = 8, fd = 562098184, user_data = 0x82180f408}, {pos = 562100232, events = 8, fd = 562101256, user_data = 0x821810008}, {pos = 562103304, events = 8, fd = 562104328, user_data = 0x821810c08}, {pos = 562106376, events = 8, fd = 562107400, user_data = 0x821811808}, {pos = 562109448, events = 8, fd = 562110472, user_data = 0x821812408}, {pos = 562112520, events = 8, fd = 562113544, user_data = 0x821813008}, {pos = 562115592, events = 8, fd = 562116616, user_data = 0x821813c08}, {pos = 562122760, events = 8, fd = 562123784, user_data = 0x821815808}, {pos = 562125832, events = 8, fd = 562077704, user_data = 0x298a36}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821817038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 553872664, events = 8, fd = 553872080, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 562131000, user_data = 0x1}, {pos = 562077704, events = 8, fd = 298, user_data = 0x821036d00}, {pos = 1584109039, events = 1229, fd = 2722358, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 562131000, user_data = 0x1}, {pos = 562107400, events = 8, fd = 897830912, user_data = 0x1}, {pos = 897831316, events = 8, fd = 0, user_data = 0x821036cd0}, {pos = 703694188, events = 8, fd = 1, user_data = 0x83583d000}, {pos = 553872640, events = 8, fd = 703690498, user_data = 0x82bafe170 }, {pos = 12481216, events = 0, fd = 732946800, user_data = 0x821811408}, {pos = 553872864, events = 8, fd = 1584108510, user_data = 0x83585b800}, {pos = 1, events = 8, fd = 1584108126, user_data = 0x82180a008}, {pos = 553872648, events = 8, fd = 553872864, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1584187792, user_data = 0x0}, {pos = 553845631, events = 8, fd = 8135255, user_data = 0x821036d90}, {pos = 703652880, events = 8, fd = 733610032, user_data = 0x82bba2310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821036dc0}, {pos = 703695773, events = 8, fd = 897830912, user_data = 0x1dce}, {pos = 553872928, events = 8, fd = 703662330, user_data = 0x0}, {pos = 0, events = 0, fd = 415434906, user_data = 0x0}} [19:34:25.499] last_touch_time = 1738265279 [19:34:25.499] last_lockfile_recheck_time = 1738265279 [19:34:25.499] nevents = 1 [19:34:25.499] #21 0x0000000000898814 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821037418) at ../src/backend/postmaster/postmaster.c:1386 [19:34:25.499] userDoption = [19:34:25.499] listen_addr_saved = false [19:34:25.499] output_config_variable = [19:34:25.499] opt = [19:34:25.499] status = [19:34:25.499] #22 0x00000000007cef30 in main (argc=8, argv=0x821037418) at ../src/backend/main/main.c:230 [19:34:25.499] do_check_root = [19:34:25.499] dispatch_option = DISPATCH_POSTMASTER [19:34:25.510] [19:34:25.510] [19:34:25.510] [19:34:25.586] dumping /tmp/cores/postgres.11408.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:34:25.724] [New LWP 101864] [19:34:25.794] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [19:34:25.794] Program terminated with signal SIGABRT, Aborted. [19:34:25.794] Sent by thr_kill() from pid 11408 and user 1003. [19:34:25.794] #0 0x000000082ce3841a in thr_kill () from /lib/libc.so.7 [19:34:25.830] [19:34:25.830] Thread 1 (LWP 101864): [19:34:25.830] #0 0x000000082ce3841a in thr_kill () from /lib/libc.so.7 [19:34:25.830] No symbol table info available. [19:34:25.830] #1 0x000000082cdb1e64 in raise () from /lib/libc.so.7 [19:34:25.830] No symbol table info available. [19:34:25.830] #2 0x000000082ce626f9 in abort () from /lib/libc.so.7 [19:34:25.830] No symbol table info available. [19:34:25.830] #3 0x0000000000aa2d35 in ExceptionalCondition (conditionName=0x2ed359 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [19:34:25.830] No locals. [19:34:25.830] #4 0x0000000000769b69 in standard_ExecutorStart (queryDesc=0x8383bebd0, eflags=0) at ../src/backend/executor/execMain.c:193 [19:34:25.830] estate = 0x846ee2100 [19:34:25.830] oldcontext = 0x838374800 [19:34:25.830] #5 0x00000000006fdd1f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [19:34:25.830] copied_query = [19:34:25.830] rewritten = [19:34:25.830] plan = 0x8383be778 [19:34:25.830] queryDesc = 0x8383bebd0 [19:34:25.830] processed = [19:34:25.830] __error = [19:34:25.830] #6 RefreshMatViewByOid (matviewOid=28427, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [19:34:25.830] dest = [19:34:25.830] save_userid = 10 [19:34:25.830] save_sec_context = 0 [19:34:25.830] processed = 0 [19:34:25.830] matviewRel = 0x846f60f08 [19:34:25.830] relowner = 10 [19:34:25.830] save_nestlevel = 2 [19:34:25.830] rule = [19:34:25.830] actions = [19:34:25.830] dataQuery = [19:34:25.830] tableSpace = [19:34:25.830] relpersistence = [19:34:25.830] OIDNewHeap = 28444 [19:34:25.830] address = [19:34:25.830] #7 0x00000000006fd8f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:34:25.830] lockmode = [19:34:25.830] matviewOid = 0 [19:34:25.830] #8 0x00000000006d48ec in ExecCreateTableAs (pstate=pstate@entry=0x838374900, stmt=stmt@entry=0x83837cfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821b8d950) at ../src/backend/commands/createas.c:351 [19:34:25.830] refresh = 0x0 [19:34:25.830] query = 0x846e39d98 [19:34:25.830] into = 0x846e3a0e0 [19:34:25.830] jstate = 0x0 [19:34:25.830] do_refresh = false [19:34:25.830] address = [19:34:25.830] dest = [19:34:25.830] is_matview = [19:34:25.830] #9 0x000000000094a49e in ProcessUtilitySlow (pstate=pstate@entry=0x838374900, pstmt=pstmt@entry=0x8382a9a68, queryString=queryString@entry=0x8382a8100 "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=0x821b8d950) at ../src/backend/tcop/utility.c:1678 [19:34:25.830] _local_sigjmp_buf = {{_sjb = {9739468, 0, 34925499768, 34925500144, 34925499776, 12564408, 0, 35302885632, 12452735, 1, 4294967295, 34359738368}}} [19:34:25.830] _save_exception_stack = 0x821b8d850 [19:34:25.830] _save_context_stack = 0x0 [19:34:25.830] _do_rethrow = false [19:34:25.830] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:34:25.830] parsetree = 0x83837cfd0 [19:34:25.830] commandCollected = false [19:34:25.830] needCleanup = false [19:34:25.830] address = [19:34:25.830] isTopLevel = [19:34:25.830] isCompleteQuery = [19:34:25.830] #10 0x0000000000948e1b in standard_ProcessUtility (pstmt=0x8382a9a68, queryString=0x8382a8100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x846e3a5c8, qc=0x821b8d950) at ../src/backend/tcop/utility.c:1033 [19:34:25.830] isAtomicContext = false [19:34:25.830] parsetree = 0x83837cfd0 [19:34:25.830] readonly_flags = [19:34:25.830] pstate = 0x838374900 [19:34:25.830] isTopLevel = [19:34:25.830] #11 0x00000000009488a8 in ProcessUtility (pstmt=0x18de8, queryString=0x6 , readOnlyTree=, context=753107962, params=0x0, queryEnv=0x0, dest=0x846e3a5c8, qc=0x821b8d950) at ../src/backend/tcop/utility.c:523 [19:34:25.830] No locals. [19:34:25.830] #12 0x00000000009483e3 in PortalRunUtility (portal=0x83834e100, pstmt=0x8382a9a68, isTopLevel=, setHoldSnapshot=, dest=0x846e3a5c8, qc=0x821b8d950) at ../src/backend/tcop/pquery.c:1152 [19:34:25.830] No locals. [19:34:25.830] #13 0x0000000000947a94 in PortalRunMulti (portal=portal@entry=0x83834e100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x846e3a5c8, altdest=altdest@entry=0x846e3a5c8, qc=qc@entry=0x821b8d950) at ../src/backend/tcop/pquery.c:1316 [19:34:25.830] pstmt = 0x8382a9a68 [19:34:25.830] stmtlist_item__state = {l = 0x846e3a578, i = 0} [19:34:25.830] active_snapshot_set = false [19:34:25.830] stmtlist_item = 0x846e3a590 [19:34:25.830] #14 0x000000000094737b in PortalRun (portal=portal@entry=0x83834e100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x846e3a5c8, altdest=altdest@entry=0x846e3a5c8, qc=qc@entry=0x821b8d950) at ../src/backend/tcop/pquery.c:787 [19:34:25.830] _local_sigjmp_buf = {{_sjb = {9728757, 35302727936, 34925500488, 34925500736, 34925500496, 12564408, 34925500752, 12518840, 12518271, 0, 35302736767, 34359738368}}} [19:34:25.830] _save_exception_stack = 0x821b8da00 [19:34:25.830] _save_context_stack = 0x0 [19:34:25.830] _do_rethrow = false [19:34:25.830] saveTopTransactionResourceOwner = 0x83839d258 [19:34:25.830] saveTopTransactionContext = 0x838352000 [19:34:25.830] saveActivePortal = 0x0 [19:34:25.830] saveResourceOwner = 0x83839d258 [19:34:25.830] savePortalContext = 0x0 [19:34:25.830] saveMemoryContext = 0x838352000 [19:34:25.830] result = [19:34:25.830] nprocessed = [19:34:25.830] #15 0x00000000009461f9 in exec_simple_query (query_string=query_string@entry=0x8382a8100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [19:34:25.830] cmdtaglen = 24 [19:34:25.830] snapshot_set = [19:34:25.830] per_parsetree_context = 0x0 [19:34:25.830] plantree_list = [19:34:25.830] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:34:25.830] format = 0 [19:34:25.830] parsetree = 0x8382a96a8 [19:34:25.830] commandTag = [19:34:25.830] cmdtagname = [19:34:25.830] querytree_list = [19:34:25.830] portal = 0x83834e100 [19:34:25.830] receiver = 0x846e3a5c8 [19:34:25.830] parsetree_item__state = {l = 0x8382a9a18, i = 0} [19:34:25.830] msec_str = "\000\000\000\000\b", '\000' , "\333қg\000\000\000\000r\003g\3360\232\\l" [19:34:25.830] dest = DestRemote [19:34:25.830] was_logged = [19:34:25.830] oldcontext = 0x838352000 [19:34:25.830] parsetree_list = 0x8382a9a18 [19:34:25.830] use_implicit_block = false [19:34:25.830] parsetree_item = 0x8382a9a30 [19:34:25.830] save_log_statement_stats = [19:34:25.830] #16 0x0000000000943e63 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [19:34:25.830] query_string = 0x8382a8100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:34:25.830] input_message = {data = 0x8382a8100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:34:25.830] firstchar = [19:34:25.830] local_sigjmp_buf = {{_sjb = {9712390, 34925500928, 34925500920, 34925501472, 12573160, 1, 8192, 8388608, 34925446015, 0, 0, 1}}} [19:34:25.830] send_ready_for_query = false [19:34:25.830] idle_in_transaction_timeout_enabled = false [19:34:25.830] idle_session_timeout_enabled = false [19:34:25.830] #17 0x000000000093e7f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:34:25.830] bsdata = [19:34:25.830] #18 0x0000000000896035 in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x821b8e730 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821b8e680) at ../src/backend/postmaster/launch_backend.c:274 [19:34:25.830] pid = [19:34:25.830] #19 0x000000000089a3db in BackendStartup (client_sock=0x821b8e680) at ../src/backend/postmaster/postmaster.c:3519 [19:34:25.830] startup_data = {canAcceptConnections = CAC_OK} [19:34:25.830] bn = 0x83836c0c8 [19:34:25.830] cac = CAC_OK [19:34:25.830] pid = [19:34:25.830] __error = [19:34:25.830] save_errno = [19:34:25.830] __error = [19:34:25.830] __error = [19:34:25.830] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [19:34:25.830] 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' , "\340\346\270!\b\000\000\000h\325\360+\b\000\000\000\346\000\000\000\000\000\000\000^_\361+\b", '\000' , " \347\270!\b\000\000\000\304]\211\000\000\000\000\0000\347\270!\b", '\000' }, salen = 16}} [19:34:25.830] i = 0 [19:34:25.830] now = [19:34:25.830] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 942745048, events = 8, fd = 565765312, user_data = 0x0}, {pos = 0, events = 0, fd = 397565576, user_data = 0x2ccf3c66030a}, {pos = 751900576, events = 8, fd = 751971704, user_data = 0x821b8e148}, {pos = 565764544, events = 8, fd = 565764424, user_data = 0x2ccf3c66030a}, {pos = 751879048, events = 8, fd = 751971704, user_data = 0x821b8e178}, {pos = 565764592, events = 8, fd = 565764472, user_data = 0x82cd1b194}, {pos = 565818376, events = 8, fd = 751939988, user_data = 0x821b8e1e0}, {pos = 1013298234, events = 11471, fd = 753762352, user_data = 0x1}, {pos = 565764624, events = 8, fd = 1013318410, user_data = 0x82cd04858}, {pos = 751971704, events = 8, fd = 565764584, user_data = 0x821b8e260}, {pos = 565764584, events = 8, fd = 751934732, user_data = 0x821b9b408}, {pos = 751934732, events = 8, fd = 565764688, user_data = 0x2ccf3c65b43a}, {pos = 565764728, events = 8, fd = 565765176, user_data = 0x821b8e260}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 4272056380, fd = 565841976, user_data = 0x800000001}, {pos = 565818376, events = 8, fd = 751879048, user_data = 0x821ba0288}, {pos = 751847512, events = 8, fd = 565818376, user_data = 0x821b8e2e8}, {pos = 565765288, events = 8, fd = 565764816, user_data = 0x2ccf3c65fca2}, {pos = 2722358, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 565841976, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 565765544, user_data = 0x21b9b408}, {pos = 565765360, events = 8, fd = 565764960, user_data = 0x1}, {pos = 565765288, events = 8, fd = 32, user_data = 0x821b8e350}, {pos = 1013316211, events = 11471, fd = 565765232, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821ba1038}, {pos = 1, events = 8, fd = 565818376, user_data = 0x82cd04858}, {pos = 565765544, events = 8, fd = 565765360, user_data = 0x821b8e360}, {pos = 0, events = 0, fd = 565788680, user_data = 0x20}, {pos = 565765344, events = 8, fd = 1013291751, user_data = 0x821b94008}, {pos = 565789704, events = 8, fd = 565790728, user_data = 0x821b94c08}, {pos = 565805064, events = 8, fd = 565806088, user_data = 0x821b98808}, {pos = 565808136, events = 8, fd = 565809160, user_data = 0x821b99408}, {pos = 565811208, events = 8, fd = 565812232, user_data = 0x821b9a008}, {pos = 565814280, events = 8, fd = 565815304, user_data = 0x821b9ac08}, {pos = 565817352, events = 8, fd = 565818376, user_data = 0x821b9b808}, {pos = 565820424, events = 8, fd = 565821448, user_data = 0x821b9c408}, {pos = 565823496, events = 8, fd = 565824520, user_data = 0x821b9d008}, {pos = 565826568, events = 8, fd = 565827592, user_data = 0x821b9dc08}, {pos = 565833736, events = 8, fd = 565834760, user_data = 0x821b9f808}, {pos = 565836808, events = 8, fd = 565788680, user_data = 0x298a36}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821ba1038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 565765544, events = 8, fd = 565764960, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 565841976, user_data = 0x1}, {pos = 565788680, events = 8, fd = 298, user_data = 0x821b8e590}, {pos = 1013290479, events = 11471, fd = 2722358, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565841976, user_data = 0x1}, {pos = 565818376, events = 8, fd = 942243840, user_data = 0x1}, {pos = 942244244, events = 8, fd = 0, user_data = 0x821b8e560}, {pos = 737236332, events = 8, fd = 1, user_data = 0x838298000}, {pos = 565765520, events = 8, fd = 737232642, user_data = 0x82ce36170 }, {pos = 12481216, events = 0, fd = 753099120, user_data = 0x821b9b408}, {pos = 565765744, events = 8, fd = 1013289950, user_data = 0x8382b6800}, {pos = 1, events = 8, fd = 1013289566, user_data = 0x821b94008}, {pos = 565765528, events = 8, fd = 565765744, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1013369232, user_data = 0x0}, {pos = 565707647, events = 8, fd = 8135255, user_data = 0x821b8e620}, {pos = 737195024, events = 8, fd = 753762352, user_data = 0x82ceda310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821b8e650}, {pos = 737237917, events = 8, fd = 942243840, user_data = 0x1ddf}, {pos = 565765808, events = 8, fd = 737204474, user_data = 0x0}, {pos = 0, events = 0, fd = 397565576, user_data = 0x0}} [19:34:25.830] last_touch_time = 1738265279 [19:34:25.830] last_lockfile_recheck_time = 1738265279 [19:34:25.830] nevents = 1 [19:34:25.830] #21 0x0000000000898814 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821b8eca8) at ../src/backend/postmaster/postmaster.c:1386 [19:34:25.830] userDoption = [19:34:25.830] listen_addr_saved = false [19:34:25.830] output_config_variable = [19:34:25.830] opt = [19:34:25.830] status = [19:34:25.830] #22 0x00000000007cef30 in main (argc=4, argv=0x821b8eca8) at ../src/backend/main/main.c:230 [19:34:25.830] do_check_root = [19:34:25.830] dispatch_option = DISPATCH_POSTMASTER [19:34:25.840] [19:34:25.840] [19:34:25.840] [19:34:25.901] dumping /tmp/cores/postgres.13883.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:34:26.036] [New LWP 101863] [19:34:26.101] Core was generated by `postgres: cascade: startup recovering 000000020000000000000004'. [19:34:26.101] Program terminated with signal SIGQUIT, Quit. [19:34:26.101] Sent by thr_kill() from pid 13883 and user 1003. [19:34:26.101] #0 0x000000082d5288fa in _sigprocmask () from /lib/libc.so.7 [19:34:26.126] [19:34:26.126] Thread 1 (LWP 101863): [19:34:26.126] #0 0x000000082d5288fa in _sigprocmask () from /lib/libc.so.7 [19:34:26.126] No symbol table info available. [19:34:26.126] #1 0x000000082d561f91 in _system () from /lib/libc.so.7 [19:34:26.126] No symbol table info available. [19:34:26.126] #2 0x000000082c4b59d3 in ?? () from /lib/libthr.so.3 [19:34:26.126] No symbol table info available. [19:34:26.126] #3 0x0000000000669ab5 in RestoreArchivedFile (path=path@entry=0x8215a61d0 "pg_wal/00000002", '0' , "4", xlogfname=xlogfname@entry=0x8215a65d0 "00000003.history", recovername=, expectedSize=expectedSize@entry=0, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [19:34:26.126] xlogpath = "pg_wal/RECOVERYHISTORY", '\000' , "\200\t\3007\b\000\000\000\210fZ!\b\000\000\0009\000\000\000\000\000\000\000\000\000\344\000\000\000\000\000\000\020\n\000\000\000\000\000\200\315\3007\b\000\000\000P\005\\8\b\000\000\000\200\004\\8\b\000\000\000x\004\\8\b\000\000\000x\377[8\b\000\000\000\000\340\344\000\000\000\000\000\000p\3757\b\000\000\000\000\020\n\000\000\000\000\000 ]Z!\b\000\000\000 ]Z!\b", '\000' , "\350^Z!\b\000\000\000h]Z!\b\000\000\000\b\000\000\0000\000\000\000"... [19:34:26.126] lastRestartPointFname = '0' , "\000\000\000\000\000\000\000\000\030\000\000\0000\000\000\000\260\\Z!\b\000\000\000`ZZ!\b", '\000' , "\240\246]-\b", '\000' , "U#\257\000\000\000\000\000\300YZ!\b\000\000\0000\000\000\000\000\000\000\000\210`Z!\b", '\000' , "pYZ!\b\000\000\000\243&\257", '\000' , "U#\257\000\000\000\000\000\210`Z!\b\000\000\000\376\377\377\377\000\000\000\000\002", '\000' ... [19:34:26.126] stat_buf = {st_dev = 90112, st_ino = 2, st_nlink = 34919309760, st_mode = 7651, st_padding0 = 175, st_uid = 0, st_gid = 559571392, st_padding1 = 8, st_rdev = 35119576551, st_atim = {tv_sec = 16011, tv_nsec = 3}, st_mtim = {tv_sec = 35333972940, tv_nsec = 29400}, st_ctim = {tv_sec = -72340172838076673, tv_nsec = -9187201950435737472}, st_birthtim = {tv_sec = 4485125597436446111, tv_nsec = 34919309744}, st_size = 6, st_blocks = 0, st_blksize = 78, st_flags = 0, st_gen = 35120850592, st_spare = {34919309680, 35120102063, 1738265317, 924872022942081846, 4485125597436446111, 2, 0, 34919309744, 206158430240, 34919309776}} [19:34:26.126] restartRedoPtr = 34919309504 [19:34:26.126] restartTli = 8 [19:34:26.126] restartSegNo = [19:34:26.126] xlogRestoreCmd = 0x837fa02f8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/data/t_025_stuck_on_old_timeline_primary_data/archives/00000003.history\" \"pg_wal/RECOVERYHISTORY\"" [19:34:26.126] rc = [19:34:26.126] #4 0x0000000000650b78 in existsTimeLineHistory (probeTLI=probeTLI@entry=3) at ../src/backend/access/transam/timeline.c:235 [19:34:26.126] path = "pg_wal/00000002", '0' , "4", '\000' , "8`*\"\b\000\000\000\001\000\000\000\000\000\000\000\b\004*\"\b\000\000\0008\262?-\b\000\000\000\250dZ!\b\000\000\000\360cZ!\b\000\000\000`bZ!\b", '\000' , "\b\220)\"\b\000\000\000 \000\000\000\000\000\000\000\340cZ!\b\000\000\000\347j\321\326H\030\000\000\b\220)\"\b\000\000\000\b\224)\"\b\000\000\000\b\230)\"\b\000\000\000\b\234)\"\b\000\000\000\b\320)\"\b\000\000\000\b\324)\"\b\000\000\000\b\330)\"\b\000\000\000"... [19:34:26.126] histfname = "00000003.history\000fZ!\b\000\000\000\337S\221", '\000' , "\377\377\377\377\377\377\377\377\237\0056\270\367]>>\000\000\000\000\000\000\000" [19:34:26.126] fd = [19:34:26.126] #5 0x0000000000650c38 in findNewestTimeLine (startTLI=startTLI@entry=2) at ../src/backend/access/transam/timeline.c:277 [19:34:26.126] newestTLI = 2 [19:34:26.126] probeTLI = 3 [19:34:26.126] #6 0x0000000000674edb in rescanLatestTimeLine (replayTLI=replayTLI@entry=2, replayLSN=replayLSN@entry=67199064) at ../src/backend/access/transam/xlogrecovery.c:4115 [19:34:26.126] oldtarget = 2 [19:34:26.126] currentTle = 0x0 [19:34:26.126] newtarget = [19:34:26.126] newExpectedTLEs = [19:34:26.126] found = [19:34:26.126] cell = [19:34:26.126] #7 0x0000000000671123 in WaitForWALToBecomeAvailable (RecPtr=67199088, tliRecPtr=67199064, replayTLI=2, replayLSN=67199064, randAccess=, fetching_ckpt=, nonblocking=) at ../src/backend/access/transam/xlogrecovery.c:3677 [19:34:26.126] startWalReceiver = false [19:34:26.126] streaming_reply_sent = true [19:34:26.126] now = [19:34:26.126] startWalReceiver = [19:34:26.126] oldSource = [19:34:26.126] wait_time = [19:34:26.126] __error = [19:34:26.126] __error = [19:34:26.126] __error = [19:34:26.126] havedata = [19:34:26.126] ptr = [19:34:26.126] tli = [19:34:26.126] __error = [19:34:26.126] latestChunkStart = [19:34:26.126] __error = [19:34:26.126] #8 XLogPageRead (xlogreader=0x837eb0130, targetPagePtr=67198976, reqLen=112, targetRecPtr=67199064, readBuf=0x837f9c9b8 "\030\321\006") at ../src/backend/access/transam/xlogrecovery.c:3353 [19:34:26.126] private = 0x837eb0110 [19:34:26.126] emode = 15 [19:34:26.126] targetSegNo = 4 [19:34:26.126] targetPageOff = 90112 [19:34:26.126] r = [19:34:26.126] #9 0x0000000000677e22 in ReadPageInternal (state=state@entry=0x837eb0130, pageptr=67198976, reqLen=112) at ../src/backend/access/transam/xlogreader.c:1060 [19:34:26.126] targetSegNo = 4 [19:34:26.126] targetPageOff = 90112 [19:34:26.126] readLen = [19:34:26.126] hdr = [19:34:26.126] err = [19:34:26.126] #10 0x0000000000676c92 in XLogDecodeNextRecord (state=0x837eb0130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:597 [19:34:26.126] errormsg = 0x8215aac98 "" [19:34:26.126] randAccess = [19:34:26.126] decoded = 0x0 [19:34:26.126] RecPtr = 67199064 [19:34:26.126] assembled = false [19:34:26.126] targetPagePtr = 34919307200 [19:34:26.126] readOff = [19:34:26.126] record = [19:34:26.126] gotheader = [19:34:26.126] targetRecOff = 88 [19:34:26.126] pageHeaderSize = [19:34:26.126] len = [19:34:26.126] total_len = [19:34:26.126] buffer = [19:34:26.126] gotlen = [19:34:26.126] pageHeader = [19:34:26.126] contdata = [19:34:26.126] save_copy = [19:34:26.126] #11 XLogReadAhead (state=0x837eb0130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:973 [19:34:26.126] result = [19:34:26.126] #12 0x000000000066e3d8 in XLogPrefetcherNextBlock (pgsr_private=35298863560, lsn=0x837fcd598) at ../src/backend/access/transam/xlogprefetcher.c:490 [19:34:26.126] nonblocking = false [19:34:26.126] record = 0x0 [19:34:26.126] prefetcher = 0x837f9e9c8 [19:34:26.126] reader = 0x837eb0130 [19:34:26.126] replaying_lsn = 67198632 [19:34:26.126] #13 0x000000000066e042 in lrq_prefetch (lrq=0x837fcd328) at ../src/backend/access/transam/xlogprefetcher.c:252 [19:34:26.126] No locals. [19:34:26.126] #14 lrq_complete_lsn (lrq=0x837fcd328, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [19:34:26.126] No locals. [19:34:26.126] #15 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x837f9e9c8, errmsg=errmsg@entry=0x8215aad60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [19:34:26.126] replayed_up_to = [19:34:26.126] record = [19:34:26.126] #16 0x0000000000671b7a in ReadRecord (xlogprefetcher=0x837f9e9c8, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=2) at ../src/backend/access/transam/xlogrecovery.c:3153 [19:34:26.126] errormsg = 0x837eb0940 "" [19:34:26.126] xlogreader = 0x837eb0130 [19:34:26.126] private = [19:34:26.126] record = [19:34:26.126] #17 0x0000000000672459 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1832 [19:34:26.126] ru0 = {tv = {tv_sec = 1738265316, tv_usec = 463532}, ru = {ru_utime = {tv_sec = 0, tv_usec = 0}, ru_stime = {tv_sec = 0, tv_usec = 955}, ru_maxrss = 0, ru_ixrss = 0, ru_idrss = 0, ru_isrss = 0, ru_minflt = 152, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 0, ru_msgsnd = 0, ru_msgrcv = 0, ru_nsignals = 0, ru_nvcsw = 12, ru_nivcsw = 2}} [19:34:26.126] xtime = [19:34:26.126] reachedRecoveryTarget = false [19:34:26.126] replayTLI = 2 [19:34:26.126] record = [19:34:26.126] #18 0x0000000000662de3 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5848 [19:34:26.126] wasShutdown = false [19:34:26.126] haveTblspcMap = false [19:34:26.126] haveBackupLabel = true [19:34:26.126] promoted = false [19:34:26.126] didCrash = [19:34:26.127] checkPoint = {redo = 33554472, ThisTimeLineID = 1, PrevTimeLineID = , fullPageWrites = true, wal_level = , nextXid = {value = }, nextOid = , nextMulti = , nextMultiOffset = , oldestXid = , oldestXidDB = 1, oldestMulti = , oldestMultiDB = , time = , oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 743} [19:34:26.127] oldestActiveXID = [19:34:26.127] performedWalRecovery = [19:34:26.127] endOfRecoveryInfo = [19:34:26.127] EndOfLog = [19:34:26.127] EndOfLogTLI = [19:34:26.127] abortedRecPtr = [19:34:26.127] missingContrecPtr = [19:34:26.127] newTLI = [19:34:26.127] Insert = [19:34:26.127] #19 0x000000000089bc9b in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [19:34:26.127] No locals. [19:34:26.127] #20 0x0000000000896035 in postmaster_child_launch (child_type=child_type@entry=B_STARTUP, child_slot=57, startup_data=startup_data@entry=0x0, startup_data_len=startup_data_len@entry=0, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:274 [19:34:26.127] pid = [19:34:26.127] #21 0x0000000000898c37 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3905 [19:34:26.127] pmchild = 0x0 [19:34:26.127] pid = [19:34:26.127] #22 0x00000000008987d2 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8215afc10) at ../src/backend/postmaster/postmaster.c:1378 [19:34:26.127] userDoption = [19:34:26.127] listen_addr_saved = false [19:34:26.127] output_config_variable = [19:34:26.127] opt = [19:34:26.127] status = [19:34:26.127] #23 0x00000000007cef30 in main (argc=4, argv=0x8215afc10) at ../src/backend/main/main.c:230 [19:34:26.127] do_check_root = [19:34:26.127] dispatch_option = DISPATCH_POSTMASTER [19:34:26.137] [19:34:26.137] [19:34:26.137] [19:34:26.202] dumping /tmp/cores/postgres.18268.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:34:26.335] [New LWP 101887] [19:34:26.410] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [19:34:26.410] Program terminated with signal SIGABRT, Aborted. [19:34:26.410] Sent by thr_kill() from pid 18268 and user 1003. [19:34:26.410] #0 0x000000082f59d41a in thr_kill () from /lib/libc.so.7 [19:34:26.454] [19:34:26.454] Thread 1 (LWP 101887): [19:34:26.454] #0 0x000000082f59d41a in thr_kill () from /lib/libc.so.7 [19:34:26.454] No symbol table info available. [19:34:26.454] #1 0x000000082f516e64 in raise () from /lib/libc.so.7 [19:34:26.454] No symbol table info available. [19:34:26.454] #2 0x000000082f5c76f9 in abort () from /lib/libc.so.7 [19:34:26.454] No symbol table info available. [19:34:26.454] #3 0x0000000000aa2d35 in ExceptionalCondition (conditionName=0x2ed359 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [19:34:26.454] No locals. [19:34:26.454] #4 0x0000000000769b69 in standard_ExecutorStart (queryDesc=0x838d88bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [19:34:26.454] estate = 0x83f673100 [19:34:26.454] oldcontext = 0x838de8800 [19:34:26.454] #5 0x000000083b1349c2 in pgss_ExecutorStart (queryDesc=0x838d88bd0, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [19:34:26.454] No locals. [19:34:26.454] #6 0x00000000006fdd1f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [19:34:26.454] copied_query = [19:34:26.454] rewritten = [19:34:26.454] plan = 0x838d88778 [19:34:26.454] queryDesc = 0x838d88bd0 [19:34:26.454] processed = [19:34:26.454] __error = [19:34:26.454] #7 RefreshMatViewByOid (matviewOid=28495, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [19:34:26.454] dest = [19:34:26.454] save_userid = 10 [19:34:26.454] save_sec_context = 0 [19:34:26.454] processed = 0 [19:34:26.454] matviewRel = 0x83f6f5c58 [19:34:26.454] relowner = 10 [19:34:26.454] save_nestlevel = 2 [19:34:26.454] rule = [19:34:26.454] actions = [19:34:26.454] dataQuery = [19:34:26.454] tableSpace = [19:34:26.454] relpersistence = [19:34:26.454] OIDNewHeap = 28507 [19:34:26.454] address = [19:34:26.454] #8 0x00000000006fd8f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:34:26.454] lockmode = [19:34:26.454] matviewOid = 0 [19:34:26.454] #9 0x00000000006d48ec in ExecCreateTableAs (pstate=pstate@entry=0x838de8900, stmt=stmt@entry=0x838d68fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821a04c80) at ../src/backend/commands/createas.c:351 [19:34:26.454] refresh = 0x0 [19:34:26.454] query = 0x838cf3848 [19:34:26.454] into = 0x838d68f40 [19:34:26.454] jstate = 0x0 [19:34:26.454] do_refresh = false [19:34:26.454] address = [19:34:26.454] dest = [19:34:26.454] is_matview = [19:34:26.454] #10 0x000000000094a49e in ProcessUtilitySlow (pstate=pstate@entry=0x838de8900, pstmt=pstmt@entry=0x838d68e30, queryString=queryString@entry=0x838c0b100 "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=0x821a04c80) at ../src/backend/tcop/utility.c:1678 [19:34:26.454] _local_sigjmp_buf = {{_sjb = {9739468, 0, 34923890408, 34923890784, 34923890416, 12564408, 0, 35313846528, 895, 1, 34923890540, 0}}} [19:34:26.454] _save_exception_stack = 0x821a04970 [19:34:26.454] _save_context_stack = 0x0 [19:34:26.454] _do_rethrow = false [19:34:26.454] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:34:26.454] parsetree = 0x838d68fd0 [19:34:26.454] commandCollected = false [19:34:26.454] needCleanup = false [19:34:26.454] address = [19:34:26.454] isTopLevel = [19:34:26.454] isCompleteQuery = [19:34:26.454] #11 0x0000000000948e1b in standard_ProcessUtility (pstmt=0x838d68e30, queryString=queryString@entry=0x838c0b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838cf3fe8, qc=0x821a04c80) at ../src/backend/tcop/utility.c:1033 [19:34:26.454] isAtomicContext = false [19:34:26.454] parsetree = 0x838d68fd0 [19:34:26.454] readonly_flags = [19:34:26.454] pstate = 0x838de8900 [19:34:26.454] isTopLevel = [19:34:26.454] #12 0x000000083b134f70 in pgss_ProcessUtility (pstmt=0x838d68e30, queryString=0x838c0b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838cf3fe8, qc=0x821a04c80) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [19:34:26.454] _local_sigjmp_buf = {{_sjb = {35350859433, 34923891056, 34923890920, 34923891376, 35313323568, 0, 12564408, 34923891584, 895, 1, 34923891172, 34359738368}}} [19:34:26.454] _save_exception_stack = 0x821a04b80 [19:34:26.454] _save_context_stack = 0x0 [19:34:26.454] _do_rethrow = false [19:34:26.454] bufusage = {shared_blks_hit = 35350859433, shared_blks_read = 34923891056, shared_blks_dirtied = 34923890920, shared_blks_written = 34923891376, local_blks_hit = 35313323568, local_blks_read = 0, local_blks_dirtied = 12564408, local_blks_written = 34923891584, temp_blks_read = 895, temp_blks_written = 1, shared_blk_read_time = {ticks = 34923891172}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4348962118328523264}, local_blk_write_time = {ticks = 12573336}, temp_blk_read_time = {ticks = 35376524416}, temp_blk_write_time = {ticks = 12514800}} [19:34:26.454] walusage_start = {wal_records = 8996, wal_fpi = 164, wal_bytes = 1427571} [19:34:26.454] duration = [19:34:26.454] bufusage_start = {shared_blks_hit = 154116, shared_blks_read = 9646, shared_blks_dirtied = 2779, shared_blks_written = 2258, local_blks_hit = 45, local_blks_read = 0, local_blks_dirtied = 10, local_blks_written = 17, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [19:34:26.454] walusage = {wal_records = 0, wal_fpi = 549755813888, wal_bytes = 10784188495676635085} [19:34:26.454] start = {ticks = -209012182297} [19:34:26.454] rows = [19:34:26.454] saved_queryId = 7267788456574341698 [19:34:26.454] parsetree = [19:34:26.454] saved_stmt_location = 0 [19:34:26.454] saved_stmt_len = 69 [19:34:26.454] enabled = [19:34:26.454] #13 0x00000000009483e3 in PortalRunUtility (portal=0x838cb1100, pstmt=0x838d68e30, isTopLevel=, setHoldSnapshot=, dest=0x838cf3fe8, qc=0x821a04c80) at ../src/backend/tcop/pquery.c:1152 [19:34:26.454] No locals. [19:34:26.454] #14 0x0000000000947a94 in PortalRunMulti (portal=portal@entry=0x838cb1100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x838cf3fe8, altdest=altdest@entry=0x838cf3fe8, qc=qc@entry=0x821a04c80) at ../src/backend/tcop/pquery.c:1316 [19:34:26.454] pstmt = 0x838d68e30 [19:34:26.454] stmtlist_item__state = {l = 0x838cf3f98, i = 0} [19:34:26.454] active_snapshot_set = false [19:34:26.454] stmtlist_item = 0x838cf3fb0 [19:34:26.454] #15 0x000000000094737b in PortalRun (portal=portal@entry=0x838cb1100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x838cf3fe8, altdest=altdest@entry=0x838cf3fe8, qc=qc@entry=0x821a04c80) at ../src/backend/tcop/pquery.c:787 [19:34:26.454] _local_sigjmp_buf = {{_sjb = {9728757, 35312570624, 34923891576, 34923891824, 34923891584, 12564408, 34923891840, 12518840, 12518271, 0, 35312567167, 34359738368}}} [19:34:26.454] _save_exception_stack = 0x821a04d30 [19:34:26.454] _save_context_stack = 0x0 [19:34:26.454] _do_rethrow = false [19:34:26.454] saveTopTransactionResourceOwner = 0x838d06c98 [19:34:26.454] saveTopTransactionContext = 0x838cb5000 [19:34:26.454] saveActivePortal = 0x0 [19:34:26.454] saveResourceOwner = 0x838d06c98 [19:34:26.454] savePortalContext = 0x0 [19:34:26.454] saveMemoryContext = 0x838cb5000 [19:34:26.454] result = [19:34:26.454] nprocessed = [19:34:26.454] #16 0x00000000009461f9 in exec_simple_query (query_string=query_string@entry=0x838c0b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [19:34:26.454] cmdtaglen = 24 [19:34:26.454] snapshot_set = [19:34:26.454] per_parsetree_context = 0x0 [19:34:26.454] plantree_list = [19:34:26.454] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:34:26.454] format = 0 [19:34:26.454] parsetree = 0x838c0c6a8 [19:34:26.454] commandTag = [19:34:26.454] cmdtagname = [19:34:26.454] querytree_list = [19:34:26.454] portal = 0x838cb1100 [19:34:26.454] receiver = 0x838cf3fe8 [19:34:26.454] parsetree_item__state = {l = 0x838c0ca18, i = 0} [19:34:26.454] msec_str = "\000\000\000\000\b", '\000' , "\aӛg\000\000\000\000\266\363_\n\263\210", [19:34:26.454] dest = DestRemote [19:34:26.454] was_logged = [19:34:26.454] oldcontext = 0x838cb5000 [19:34:26.454] parsetree_list = 0x838c0ca18 [19:34:26.454] use_implicit_block = false [19:34:26.454] parsetree_item = 0x838c0ca30 [19:34:26.454] save_log_statement_stats = [19:34:26.454] #17 0x0000000000943e63 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [19:34:26.454] query_string = 0x838c0b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:34:26.454] input_message = {data = 0x838c0b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:34:26.454] firstchar = [19:34:26.454] local_sigjmp_buf = {{_sjb = {9712390, 34923892016, 34923892008, 34923892560, 12573160, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [19:34:26.454] send_ready_for_query = false [19:34:26.454] idle_in_transaction_timeout_enabled = false [19:34:26.454] idle_session_timeout_enabled = false [19:34:26.454] #18 0x000000000093e7f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:34:26.454] bsdata = [19:34:26.454] #19 0x0000000000896035 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x821a05a60 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a059b0) at ../src/backend/postmaster/launch_backend.c:274 [19:34:26.454] pid = [19:34:26.454] #20 0x000000000089a3db in BackendStartup (client_sock=0x821a059b0) at ../src/backend/postmaster/postmaster.c:3519 [19:34:26.454] startup_data = {canAcceptConnections = CAC_OK} [19:34:26.454] bn = 0x838cf2988 [19:34:26.454] cac = CAC_OK [19:34:26.454] pid = [19:34:26.454] __error = [19:34:26.454] save_errno = [19:34:26.454] __error = [19:34:26.454] __error = [19:34:26.454] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [19:34:26.454] 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' , "\020Z\240!\b\000\000\000h\345\225-\b\000\000\000W\000\000\000\000\000\000\000^o\226-\b", '\000' , "PZ\240!\b\000\000\000\304]\211\000\000\000\000\000`Z\240!\b", '\000' }, salen = 16}} [19:34:26.454] i = 0 [19:34:26.454] now = [19:34:26.454] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 952559064, events = 8, fd = 564156400, user_data = 0x0}, {pos = 559743754, events = 10314, fd = 793208736, user_data = 0x82f487d78}, {pos = 564155496, events = 8, fd = 564155616, user_data = 0x821a05468}, {pos = 559743754, events = 10314, fd = 793187208, user_data = 0x82f487d78}, {pos = 564155544, events = 8, fd = 564155664, user_data = 0x821a05498}, {pos = 793248148, events = 8, fd = 579367944, user_data = 0x82f480194}, {pos = 564155648, events = 8, fd = 559723578, user_data = 0x821a054a0}, {pos = 764789776, events = 8, fd = 795070512, user_data = 0x284a215d030a}, {pos = 793155672, events = 8, fd = 793279864, user_data = 0x821a05508}, {pos = 564155776, events = 8, fd = 564155656, user_data = 0x82f47ed0c}, {pos = 579367944, events = 8, fd = 793242892, user_data = 0x821a05570}, {pos = 559723578, events = 10314, fd = 564155800, user_data = 0x821a05768}, {pos = 564155776, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x82288d038}, {pos = 1, events = 2510889548, fd = 579367944, user_data = 0x82f471388}, {pos = 579389384, events = 8, fd = 0, user_data = 0x0}, {pos = 564155912, events = 8, fd = 564156376, user_data = 0x821a055f0}, {pos = 559742114, events = 10314, fd = 2722358, user_data = 0x6d68b}, {pos = 2090263927, events = 2510889548, fd = 579391544, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821a058d8}, {pos = 579367944, events = 3, fd = 564156448, user_data = 0x82288c828}, {pos = 656, events = 0, fd = 564156376, user_data = 0x821a05608}, {pos = 564156016, events = 8, fd = 559741723, user_data = 0x821a057a0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 579391544, events = 8, fd = 1, user_data = 0x822887408}, {pos = 793155672, events = 8, fd = 564156632, user_data = 0x821a05820}, {pos = 564156032, events = 8, fd = 0, user_data = 0x822880008}, {pos = 33, events = 0, fd = 564156432, user_data = 0x284a215c9ae7}, {pos = 579338248, events = 8, fd = 579339272, user_data = 0x822880808}, {pos = 579341320, events = 8, fd = 579354632, user_data = 0x822884408}, {pos = 579356680, events = 8, fd = 579357704, user_data = 0x822885008}, {pos = 579359752, events = 8, fd = 579360776, user_data = 0x822885c08}, {pos = 579362824, events = 8, fd = 579363848, user_data = 0x822886808}, {pos = 579365896, events = 8, fd = 579366920, user_data = 0x822887408}, {pos = 579368968, events = 8, fd = 579369992, user_data = 0x822888008}, {pos = 579372040, events = 8, fd = 579373064, user_data = 0x822888c08}, {pos = 579375112, events = 8, fd = 579376136, user_data = 0x822889808}, {pos = 579378184, events = 8, fd = 579383304, user_data = 0x82288b408}, {pos = 579385352, events = 8, fd = 579386376, user_data = 0x82288e408}, {pos = 87441000, events = 0, fd = 579338248, user_data = 0x298a36}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82288d038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564156632, events = 8, fd = 564156032, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 579391544, user_data = 0x1}, {pos = 579338248, events = 8, fd = 298, user_data = 0x821a058c0}, {pos = 559715823, events = 10314, fd = 2722358, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 579391544, user_data = 0x1}, {pos = 579367944, events = 8, fd = 952086528, user_data = 0x1}, {pos = 952086932, events = 8, fd = 0, user_data = 0x821a05890}, {pos = 764831084, events = 8, fd = 1, user_data = 0x838bfb000}, {pos = 564156608, events = 8, fd = 764827394, user_data = 0x82f59b170 }, {pos = 12481216, events = 0, fd = 794407280, user_data = 0x822887408}, {pos = 564156832, events = 8, fd = 559715294, user_data = 0x838c19800}, {pos = 1, events = 8, fd = 559714910, user_data = 0x822880008}, {pos = 564156616, events = 8, fd = 564156832, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 559794576, user_data = 0x0}, {pos = 564134783, events = 8, fd = 8135255, user_data = 0x821a05950}, {pos = 764789776, events = 8, fd = 795070512, user_data = 0x82f63f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a05980}, {pos = 764832669, events = 8, fd = 952086528, user_data = 0x36b7}, {pos = 564156896, events = 8, fd = 764799226, user_data = 0x0}, {pos = 0, events = 0, fd = -1146554419, user_data = 0x0}} [19:34:26.454] last_touch_time = 1738265318 [19:34:26.454] last_lockfile_recheck_time = 1738265318 [19:34:26.454] nevents = 1 [19:34:26.454] #22 0x0000000000898814 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a05fd8) at ../src/backend/postmaster/postmaster.c:1386 [19:34:26.454] userDoption = [19:34:26.454] listen_addr_saved = false [19:34:26.454] output_config_variable = [19:34:26.454] opt = [19:34:26.454] status = [19:34:26.454] #23 0x00000000007cef30 in main (argc=4, argv=0x821a05fd8) at ../src/backend/main/main.c:230 [19:34:26.454] do_check_root = [19:34:26.454] dispatch_option = DISPATCH_POSTMASTER