[20:56:24.714] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [20:56:25.033] dumping /tmp/cores/postgres.10673.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:56:25.173] [New LWP 101873] [20:56:25.257] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [20:56:25.257] Program terminated with signal SIGABRT, Aborted. [20:56:25.257] Sent by thr_kill() from pid 10673 and user 1003. [20:56:25.257] #0 0x0000000829a4141a in thr_kill () from /lib/libc.so.7 [20:56:25.312] [20:56:25.312] Thread 1 (LWP 101873): [20:56:25.312] #0 0x0000000829a4141a in thr_kill () from /lib/libc.so.7 [20:56:25.312] No symbol table info available. [20:56:25.312] #1 0x00000008299bae64 in raise () from /lib/libc.so.7 [20:56:25.312] No symbol table info available. [20:56:25.312] #2 0x0000000829a6b6f9 in abort () from /lib/libc.so.7 [20:56:25.312] No symbol table info available. [20:56:25.312] #3 0x0000000000a9d9d5 in ExceptionalCondition (conditionName=0x2ebfba "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [20:56:25.312] No locals. [20:56:25.312] #4 0x000000000076e0e9 in standard_ExecutorStart (queryDesc=0x832b14088, eflags=0) at ../src/backend/executor/execMain.c:195 [20:56:25.312] estate = 0x832c0d100 [20:56:25.312] oldcontext = 0x834ed4400 [20:56:25.312] #5 0x0000000000703ae5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [20:56:25.312] copied_query = [20:56:25.312] rewritten = [20:56:25.312] plan = 0x832baebd8 [20:56:25.312] queryDesc = 0x832b14088 [20:56:25.312] processed = [20:56:25.312] __error = [20:56:25.312] #6 RefreshMatViewByOid (matviewOid=28400, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [20:56:25.312] dest = [20:56:25.312] save_userid = 10 [20:56:25.312] save_sec_context = 0 [20:56:25.312] processed = 0 [20:56:25.312] matviewRel = 0x83503ded8 [20:56:25.312] relowner = 10 [20:56:25.312] save_nestlevel = 2 [20:56:25.312] rule = [20:56:25.312] actions = [20:56:25.312] dataQuery = [20:56:25.312] tableSpace = [20:56:25.312] relpersistence = [20:56:25.312] OIDNewHeap = 28407 [20:56:25.312] address = [20:56:25.312] #7 0x00000000007036c6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:56:25.312] lockmode = [20:56:25.312] matviewOid = 0 [20:56:25.312] #8 0x00000000006da7bc in ExecCreateTableAs (pstate=pstate@entry=0x834ed4500, stmt=stmt@entry=0x832b66fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820ffb1e0) at ../src/backend/commands/createas.c:351 [20:56:25.312] refresh = 0x0 [20:56:25.312] query = 0x832b85b98 [20:56:25.312] into = 0x832b85ee0 [20:56:25.312] jstate = 0x0 [20:56:25.312] do_refresh = false [20:56:25.312] address = [20:56:25.312] dest = [20:56:25.312] is_matview = [20:56:25.312] #9 0x0000000000949698 in ProcessUtilitySlow (pstate=pstate@entry=0x834ed4500, pstmt=pstmt@entry=0x832aa8a68, queryString=queryString@entry=0x832aa7100 "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=0x820ffb1e0) at ../src/backend/tcop/utility.c:1678 [20:56:25.312] _local_sigjmp_buf = {{_sjb = {9735881, 0, 34913365512, 34913365888, 34913365520, 12425704, 0, 35247703296, 4294902655, 34913365628, 34913365664, 0}}} [20:56:25.312] _save_exception_stack = 0x820ffb0e0 [20:56:25.312] _save_context_stack = 0x0 [20:56:25.312] _do_rethrow = false [20:56:25.312] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:56:25.312] parsetree = 0x832b66fd0 [20:56:25.312] commandCollected = false [20:56:25.312] needCleanup = false [20:56:25.312] address = [20:56:25.312] isTopLevel = [20:56:25.312] isCompleteQuery = [20:56:25.312] #10 0x0000000000948018 in standard_ProcessUtility (pstmt=0x832aa8a68, queryString=0x832aa7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x832b863c8, qc=0x820ffb1e0) at ../src/backend/tcop/utility.c:1033 [20:56:25.312] isAtomicContext = false [20:56:25.312] parsetree = 0x832b66fd0 [20:56:25.312] readonly_flags = [20:56:25.312] pstate = 0x834ed4500 [20:56:25.312] isTopLevel = [20:56:25.312] #11 0x0000000000947aa8 in ProcessUtility (pstmt=0x18df1, queryString=0x6 , readOnlyTree=, context=698618874, params=0x0, queryEnv=0x0, dest=0x832b863c8, qc=0x820ffb1e0) at ../src/backend/tcop/utility.c:523 [20:56:25.312] No locals. [20:56:25.312] #12 0x00000000009475e3 in PortalRunUtility (portal=0x832b7e100, pstmt=0x832aa8a68, isTopLevel=, setHoldSnapshot=, dest=0x832b863c8, qc=0x820ffb1e0) at ../src/backend/tcop/pquery.c:1158 [20:56:25.312] No locals. [20:56:25.312] #13 0x0000000000946c74 in PortalRunMulti (portal=portal@entry=0x832b7e100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x832b863c8, altdest=altdest@entry=0x832b863c8, qc=0x820ffb1e0) at ../src/backend/tcop/pquery.c:1322 [20:56:25.312] pstmt = 0x832aa8a68 [20:56:25.312] stmtlist_item__state = {l = 0x832b86378, i = 0} [20:56:25.312] active_snapshot_set = false [20:56:25.312] stmtlist_item = 0x832b86390 [20:56:25.312] #14 0x0000000000946543 in PortalRun (portal=portal@entry=0x832b7e100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x832b863c8, altdest=altdest@entry=0x832b863c8, qc=0x820ffb1e0) at ../src/backend/tcop/pquery.c:791 [20:56:25.312] _local_sigjmp_buf = {{_sjb = {9725117, 35210649856, 34913366232, 34913366464, 34913366240, 35211161600, 12391288, 12425704, 35210658687, 35210548624, 4294967984, 0}}} [20:56:25.312] _save_exception_stack = 0x820ffb2b0 [20:56:25.312] _save_context_stack = 0x0 [20:56:25.312] _do_rethrow = false [20:56:25.312] saveTopTransactionResourceOwner = 0x832b8f918 [20:56:25.312] saveTopTransactionContext = 0x832bfb000 [20:56:25.312] saveActivePortal = 0x0 [20:56:25.312] saveResourceOwner = 0x832b8f918 [20:56:25.312] savePortalContext = 0x0 [20:56:25.312] saveMemoryContext = 0x832bfb000 [20:56:25.312] result = [20:56:25.312] nprocessed = [20:56:25.312] #15 0x00000000009453e2 in exec_simple_query (query_string=query_string@entry=0x832aa7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [20:56:25.312] cmdtaglen = 24 [20:56:25.312] snapshot_set = [20:56:25.312] per_parsetree_context = 0x0 [20:56:25.312] plantree_list = [20:56:25.312] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:56:25.312] format = 0 [20:56:25.312] parsetree = 0x832aa86a8 [20:56:25.312] commandTag = [20:56:25.312] cmdtagname = [20:56:25.312] querytree_list = [20:56:25.312] portal = 0x832b7e100 [20:56:25.312] receiver = 0x832b863c8 [20:56:25.312] parsetree_item__state = {l = 0x832aa8a18, i = 0} [20:56:25.312] msec_str = "\000\000\000\000\b", '\000' , "r@Bg\000\000\000\000_H^CF\\", [20:56:25.312] dest = DestRemote [20:56:25.312] was_logged = [20:56:25.312] oldcontext = 0x832bfb000 [20:56:25.312] parsetree_list = 0x832aa8a18 [20:56:25.312] use_implicit_block = false [20:56:25.312] parsetree_item = 0x832aa8a30 [20:56:25.312] save_log_statement_stats = [20:56:25.312] #16 0x0000000000943053 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4794 [20:56:25.312] query_string = 0x832aa7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:56:25.312] input_message = {data = 0x832aa7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:56:25.312] firstchar = [20:56:25.312] local_sigjmp_buf = {{_sjb = {9708806, 34913366704, 34913366664, 34913367248, 12434440, 1, 8192, 8388608, 34913321855, 0, 0, 1}}} [20:56:25.312] send_ready_for_query = false [20:56:25.312] idle_in_transaction_timeout_enabled = false [20:56:25.312] idle_session_timeout_enabled = false [20:56:25.312] #17 0x000000000093d849 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:56:25.312] bsdata = [20:56:25.312] #18 0x0000000000895ac5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x820ffbfe8 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820ffbf30) at ../src/backend/postmaster/launch_backend.c:274 [20:56:25.312] pid = [20:56:25.312] #19 0x0000000000899ca8 in BackendStartup (client_sock=0x820ffbf30) at ../src/backend/postmaster/postmaster.c:3377 [20:56:25.312] startup_data = {canAcceptConnections = CAC_OK} [20:56:25.312] bn = 0x832b4a128 [20:56:25.312] cac = CAC_OK [20:56:25.312] pid = [20:56:25.312] __error = [20:56:25.312] save_errno = [20:56:25.312] __error = [20:56:25.312] __error = [20:56:25.312] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [20:56:25.312] 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' , "\220\277\377 \b\000\000\000h\305\314(\b\000\000\000\355\000\000\000\000\000\000\000^O\315(\b", '\000' , "п\377 \b\000\000\000dX\211\000\000\000\000\000\340\277\377 \b", '\000' }, salen = 16}} [20:56:25.312] i = 0 [20:56:25.312] now = [20:56:25.312] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 697498307, events = 8, fd = 128686702, user_data = 0x5a21c93dacf}, {pos = 556653112, events = 8, fd = 1, user_data = 0x8212d7408}, {pos = 697368936, events = 8, fd = -640666877, user_data = 0x820ffb6f8}, {pos = 553629424, events = 8, fd = 8192, user_data = 0x101000}, {pos = 850927616, events = 8, fd = 553629232, user_data = 0x829ab0a47}, {pos = 1, events = 0, fd = 1052672, user_data = 0xe8}, {pos = 0, events = 0, fd = 556613640, user_data = 0x8212d4408}, {pos = 556615688, events = 8, fd = 556616712, user_data = 0x820ffb6f0}, {pos = 553629416, events = 8, fd = 826081424, user_data = 0x832200980}, {pos = 32, events = 0, fd = 4096, user_data = 0x820ffb8b0}, {pos = 699054716, events = 8, fd = 553629296, user_data = 0x829ab0b22}, {pos = 553629416, events = 8, fd = 826081424, user_data = 0x20}, {pos = 4096, events = 0, fd = 553629872, user_data = 0x829aac098}, {pos = 840958160, events = 8, fd = 826081424, user_data = 0x3000}, {pos = 8192, events = 0, fd = 826081472, user_data = 0x1000}, {pos = 4097, events = 0, fd = 8192, user_data = 0x832200980}, {pos = 553631008, events = 8, fd = 840980696, user_data = 0x0}, {pos = 0, events = 0, fd = 841009280, user_data = 0x0}, {pos = 841009152, events = 8, fd = 232, user_data = 0x1}, {pos = 840960384, events = 8, fd = 553631008, user_data = 0x20}, {pos = 8388608, events = 0, fd = 8192, user_data = 0x83220c580}, {pos = 865688712, events = 8, fd = 865688704, user_data = 0x833995c78}, {pos = 865688688, events = 8, fd = 8417280, user_data = 0x832b76000}, {pos = 8193, events = 0, fd = 553629536, user_data = 0x820ffb760}, {pos = 1, events = 0, fd = 849965460, user_data = 0x0}, {pos = 553629632, events = 8, fd = 684541292, user_data = 0x1}, {pos = 849965056, events = 8, fd = 553629680, user_data = 0x828cd3702}, {pos = 699205968, events = 8, fd = 699294072, user_data = 0x829ad0950 }, {pos = 556626952, events = 8, fd = 553629904, user_data = 0x5a275d3d3de}, {pos = 556617736, events = 8, fd = 1, user_data = 0x5a275d3d25e}, {pos = 556626952, events = 8, fd = 553629688, user_data = 0x820ffb8d0}, {pos = 12264, events = 0, fd = 0, user_data = 0x5a275d50990}, {pos = 553631296, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = -640666877, events = 3642769527, fd = 0, user_data = 0x8212d7408}, {pos = 12264, events = 0, fd = -640666877, user_data = 0x8313d0090}, {pos = 1, events = 0, fd = 840980696, user_data = 0x832200980}, {pos = 0, events = 0, fd = 553630016, user_data = 0x8299cf915 }, {pos = 0, events = 0, fd = 553629952, user_data = 0x820ffbd70}, {pos = 0, events = 0, fd = 553630016, user_data = 0x8299e5b61}, {pos = 1, events = 0, fd = 553631088, user_data = 0x820ffbd70}, {pos = 0, events = 16777216, fd = -640666877, user_data = 0x829af46a0 <__stack_chk_guard>}, {pos = 850408920, events = 8, fd = 0, user_data = 0x829ad9e38}, {pos = 553631296, events = 8, fd = 553631152, user_data = 0x8299e5c82}, {pos = 0, events = 0, fd = 553631456, user_data = 0x832b035d8}, {pos = 553631088, events = 8, fd = 553630416, user_data = 0x2000}, {pos = 8192, events = 0, fd = 850878464, user_data = 0x820ffbad8}, {pos = 0, events = 0, fd = 826081424, user_data = 0x1}, {pos = 553630224, events = 8, fd = 699075017, user_data = 0x829915388}, {pos = 697482616, events = 8, fd = 553630248, user_data = 0x820ffbaa0}, {pos = 553630416, events = 8, fd = 553630408, user_data = 0x8313d0090}, {pos = 840960384, events = 8, fd = 32, user_data = 0x1000}, {pos = 553630864, events = 8, fd = 699054716, user_data = 0x820ffbac8}, {pos = 1976845066, events = 1442, fd = 697358424, user_data = 0x82992bd78}, {pos = 553630360, events = 8, fd = 553630480, user_data = 0x820ffba98}, {pos = 697445644, events = 8, fd = 556626952, user_data = 0x829922d0c}, {pos = 553630464, events = 8, fd = 1976824890, user_data = 0x8313d00c0}, {pos = 4096, events = 0, fd = 4097, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x832203238}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 556647048, user_data = 0x82990d858}, {pos = 556626952, events = 8, fd = 553630616, user_data = 0x820ffbd58}, {pos = 553630592, events = 8, fd = 1976843426, user_data = 0x298025}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8212dd038}} [20:56:25.312] last_touch_time = 1732395101 [20:56:25.312] last_lockfile_recheck_time = 1732395101 [20:56:25.312] nevents = 1 [20:56:25.312] #21 0x00000000008982ab in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820ffc540) at ../src/backend/postmaster/postmaster.c:1361 [20:56:25.312] userDoption = [20:56:25.312] listen_addr_saved = [20:56:25.312] output_config_variable = [20:56:25.312] opt = [20:56:25.312] status = [20:56:25.312] #22 0x00000000007d14ac in main (argc=8, argv=0x820ffc540) at ../src/backend/main/main.c:196 [20:56:25.312] do_check_root = [20:56:25.322] [20:56:25.322] [20:56:25.322] [20:56:25.382] dumping /tmp/cores/postgres.10999.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:56:25.505] [New LWP 101851] [20:56:25.568] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [20:56:25.568] Program terminated with signal SIGABRT, Aborted. [20:56:25.568] Sent by thr_kill() from pid 10999 and user 1003. [20:56:25.568] #0 0x000000082a16841a in thr_kill () from /lib/libc.so.7 [20:56:25.601] [20:56:25.601] Thread 1 (LWP 101851): [20:56:25.601] #0 0x000000082a16841a in thr_kill () from /lib/libc.so.7 [20:56:25.601] No symbol table info available. [20:56:25.601] #1 0x000000082a0e1e64 in raise () from /lib/libc.so.7 [20:56:25.601] No symbol table info available. [20:56:25.601] #2 0x000000082a1926f9 in abort () from /lib/libc.so.7 [20:56:25.601] No symbol table info available. [20:56:25.601] #3 0x0000000000a9d9d5 in ExceptionalCondition (conditionName=0x2ebfba "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [20:56:25.601] No locals. [20:56:25.601] #4 0x000000000076e0e9 in standard_ExecutorStart (queryDesc=0x84324f088, eflags=0) at ../src/backend/executor/execMain.c:195 [20:56:25.601] estate = 0x835b0b100 [20:56:25.601] oldcontext = 0x835c89800 [20:56:25.601] #5 0x0000000000703ae5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [20:56:25.601] copied_query = [20:56:25.601] rewritten = [20:56:25.601] plan = 0x84325ebd8 [20:56:25.601] queryDesc = 0x84324f088 [20:56:25.601] processed = [20:56:25.601] __error = [20:56:25.601] #6 RefreshMatViewByOid (matviewOid=28467, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [20:56:25.601] dest = [20:56:25.601] save_userid = 10 [20:56:25.601] save_sec_context = 0 [20:56:25.601] processed = 0 [20:56:25.601] matviewRel = 0x8433f2498 [20:56:25.601] relowner = 10 [20:56:25.601] save_nestlevel = 2 [20:56:25.601] rule = [20:56:25.601] actions = [20:56:25.601] dataQuery = [20:56:25.601] tableSpace = [20:56:25.601] relpersistence = [20:56:25.601] OIDNewHeap = 28474 [20:56:25.601] address = [20:56:25.601] #7 0x00000000007036c6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:56:25.601] lockmode = [20:56:25.601] matviewOid = 0 [20:56:25.601] #8 0x00000000006da7bc in ExecCreateTableAs (pstate=pstate@entry=0x835c89900, stmt=stmt@entry=0x835b82fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82163ad00) at ../src/backend/commands/createas.c:351 [20:56:25.601] refresh = 0x0 [20:56:25.601] query = 0x835ba2518 [20:56:25.601] into = 0x835ba2860 [20:56:25.601] jstate = 0x0 [20:56:25.601] do_refresh = false [20:56:25.601] address = [20:56:25.601] dest = [20:56:25.601] is_matview = [20:56:25.601] #9 0x0000000000949698 in ProcessUtilitySlow (pstate=pstate@entry=0x835c89900, pstmt=pstmt@entry=0x835abba68, queryString=queryString@entry=0x835aba100 "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=0x82163ad00) at ../src/backend/tcop/utility.c:1678 [20:56:25.601] _local_sigjmp_buf = {{_sjb = {9735881, 0, 34919917864, 34919918240, 34919917872, 12425704, 0, 35262077184, 4294902655, 34919917980, 34919918016, 0}}} [20:56:25.601] _save_exception_stack = 0x82163ac00 [20:56:25.601] _save_context_stack = 0x0 [20:56:25.601] _do_rethrow = false [20:56:25.601] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:56:25.601] parsetree = 0x835b82fd0 [20:56:25.601] commandCollected = false [20:56:25.601] needCleanup = false [20:56:25.601] address = [20:56:25.601] isTopLevel = [20:56:25.601] isCompleteQuery = [20:56:25.601] #10 0x0000000000948018 in standard_ProcessUtility (pstmt=0x835abba68, queryString=0x835aba100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835ba2d48, qc=0x82163ad00) at ../src/backend/tcop/utility.c:1033 [20:56:25.601] isAtomicContext = false [20:56:25.601] parsetree = 0x835b82fd0 [20:56:25.601] readonly_flags = [20:56:25.601] pstate = 0x835c89900 [20:56:25.601] isTopLevel = [20:56:25.601] #11 0x0000000000947aa8 in ProcessUtility (pstmt=0x18ddb, queryString=0x6 , readOnlyTree=, context=706118650, params=0x0, queryEnv=0x0, dest=0x835ba2d48, qc=0x82163ad00) at ../src/backend/tcop/utility.c:523 [20:56:25.601] No locals. [20:56:25.601] #12 0x00000000009475e3 in PortalRunUtility (portal=0x835b60100, pstmt=0x835abba68, isTopLevel=, setHoldSnapshot=, dest=0x835ba2d48, qc=0x82163ad00) at ../src/backend/tcop/pquery.c:1158 [20:56:25.601] No locals. [20:56:25.601] #13 0x0000000000946c74 in PortalRunMulti (portal=portal@entry=0x835b60100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835ba2d48, altdest=altdest@entry=0x835ba2d48, qc=0x82163ad00) at ../src/backend/tcop/pquery.c:1322 [20:56:25.601] pstmt = 0x835abba68 [20:56:25.601] stmtlist_item__state = {l = 0x835ba2cf8, i = 0} [20:56:25.601] active_snapshot_set = false [20:56:25.601] stmtlist_item = 0x835ba2d10 [20:56:25.601] #14 0x0000000000946543 in PortalRun (portal=portal@entry=0x835b60100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835ba2d48, altdest=altdest@entry=0x835ba2d48, qc=0x82163ad00) at ../src/backend/tcop/pquery.c:791 [20:56:25.601] _local_sigjmp_buf = {{_sjb = {9725117, 35260858624, 34919918584, 34919918816, 34919918592, 35260874752, 12391288, 12425704, 35260859263, 35260994960, 4294967984, 0}}} [20:56:25.601] _save_exception_stack = 0x82163add0 [20:56:25.601] _save_context_stack = 0x0 [20:56:25.601] _do_rethrow = false [20:56:25.601] saveTopTransactionResourceOwner = 0x835bafd18 [20:56:25.601] saveTopTransactionContext = 0x835b64000 [20:56:25.601] saveActivePortal = 0x0 [20:56:25.601] saveResourceOwner = 0x835bafd18 [20:56:25.601] savePortalContext = 0x0 [20:56:25.601] saveMemoryContext = 0x835b64000 [20:56:25.601] result = [20:56:25.601] nprocessed = [20:56:25.601] #15 0x00000000009453e2 in exec_simple_query (query_string=query_string@entry=0x835aba100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [20:56:25.601] cmdtaglen = 24 [20:56:25.601] snapshot_set = [20:56:25.601] per_parsetree_context = 0x0 [20:56:25.601] plantree_list = [20:56:25.601] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:56:25.601] format = 0 [20:56:25.601] parsetree = 0x835abb6a8 [20:56:25.601] commandTag = [20:56:25.601] cmdtagname = [20:56:25.601] querytree_list = [20:56:25.601] portal = 0x835b60100 [20:56:25.601] receiver = 0x835ba2d48 [20:56:25.601] parsetree_item__state = {l = 0x835abba18, i = 0} [20:56:25.601] msec_str = "\000\000\000\000\b", '\000' , "u@Bg\000\000\000\000Wxՠ\224\fۨ" [20:56:25.601] dest = DestRemote [20:56:25.601] was_logged = [20:56:25.601] oldcontext = 0x835b64000 [20:56:25.601] parsetree_list = 0x835abba18 [20:56:25.601] use_implicit_block = false [20:56:25.601] parsetree_item = 0x835abba30 [20:56:25.601] save_log_statement_stats = [20:56:25.601] #16 0x0000000000943053 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4794 [20:56:25.601] query_string = 0x835aba100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:56:25.601] input_message = {data = 0x835aba100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:56:25.601] firstchar = [20:56:25.601] local_sigjmp_buf = {{_sjb = {9708806, 34919919056, 34919919016, 34919919600, 12434440, 1, 8192, 8388608, 34919875455, 0, 0, 1}}} [20:56:25.601] send_ready_for_query = false [20:56:25.601] idle_in_transaction_timeout_enabled = false [20:56:25.601] idle_session_timeout_enabled = false [20:56:25.601] #17 0x000000000093d849 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:56:25.601] bsdata = [20:56:25.601] #18 0x0000000000895ac5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=11, startup_data=startup_data@entry=0x82163bb08 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82163ba50) at ../src/backend/postmaster/launch_backend.c:274 [20:56:25.601] pid = [20:56:25.601] #19 0x0000000000899ca8 in BackendStartup (client_sock=0x82163ba50) at ../src/backend/postmaster/postmaster.c:3377 [20:56:25.601] startup_data = {canAcceptConnections = CAC_OK} [20:56:25.601] bn = 0x835b7e218 [20:56:25.601] cac = CAC_OK [20:56:25.601] pid = [20:56:25.601] __error = [20:56:25.601] save_errno = [20:56:25.601] __error = [20:56:25.601] __error = [20:56:25.601] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [20:56:25.601] 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' , "\260\272c!\b\000\000\000hu\371(\b\000\000\000\331\000\000\000\000\000\000\000^\377\371(\b", '\000' , "\360\272c!\b\000\000\000dX\211\000\000\000\000\000\000\273c!\b", '\000' }, salen = 16}} [20:56:25.601] i = 0 [20:56:25.601] now = [20:56:25.601] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 704998083, events = 8, fd = 128686702, user_data = 0x3c821c93dacf}, {pos = 571320888, events = 8, fd = 1, user_data = 0x8220d4408}, {pos = 704868712, events = 8, fd = 560182056, user_data = 0x82163b270}, {pos = 560181472, events = 8, fd = 1, user_data = 0x8220d4408}, {pos = 32, events = 0, fd = 560181856, user_data = 0x3c82401b0a1a}, {pos = 571265032, events = 8, fd = 571266056, user_data = 0x8220cd808}, {pos = 571268104, events = 8, fd = 571281416, user_data = 0x8220d1408}, {pos = 571283464, events = 8, fd = 571284488, user_data = 0x8220d2008}, {pos = 571286536, events = 8, fd = 571287560, user_data = 0x8220d2c08}, {pos = 571289608, events = 8, fd = 571290632, user_data = 0x8220d3808}, {pos = 571292680, events = 8, fd = 571293704, user_data = 0x8220d4408}, {pos = -25761258, events = 8, fd = 571318328, user_data = 0x1}, {pos = 571294728, events = 8, fd = 704889976, user_data = 0x82163b4a8}, {pos = 2837853, events = 0, fd = 560182256, user_data = 0x82163b260}, {pos = 1, events = 0, fd = 560182184, user_data = 0x20}, {pos = 560181840, events = 8, fd = 1075538547, user_data = 0x8220d4408}, {pos = 704998083, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 571320888, events = 8, fd = 1, user_data = 0x8220d4408}, {pos = 704868712, events = 8, fd = 560182056, user_data = 0x82163b0e0}, {pos = 32, events = 18, fd = 0, user_data = 0x8220daa38}, {pos = 1, events = 0, fd = 571294728, user_data = 0x347}, {pos = 560182032, events = 8, fd = 1075512815, user_data = 0x82a056ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x8220daa38}, {pos = 1, events = 0, fd = 571294728, user_data = 0x835aaa000}, {pos = 1, events = 0, fd = 900374932, user_data = 0x0}, {pos = 560181984, events = 8, fd = 687469932, user_data = 0x1}, {pos = 900374528, events = 8, fd = 560182032, user_data = 0x828f9e702}, {pos = 706705744, events = 8, fd = 706793848, user_data = 0x82a1f7950 }, {pos = 571294728, events = 8, fd = 560182256, user_data = 0x3c82401b03de}, {pos = 571285512, events = 8, fd = 1, user_data = 0x3c82401b025e}, {pos = 571294728, events = 8, fd = 560182040, user_data = 0x82163b3f0}, {pos = 12264, events = 0, fd = 0, user_data = 0x3c82401c3990}, {pos = 560183648, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = 1454605872, events = 2525217550, fd = 0, user_data = 0x8220d4408}, {pos = 12264, events = 0, fd = 704847872, user_data = 0x1db178}, {pos = 706705744, events = 8, fd = 704982392, user_data = 0x3d4b}, {pos = 706852512, events = 8, fd = 560182368, user_data = 0x82a0f6915 }, {pos = 706743864, events = 8, fd = 560182304, user_data = 0x82163b890}, {pos = 0, events = 0, fd = 560182368, user_data = 0x82a10cb61}, {pos = 1, events = 0, fd = 560183440, user_data = 0x82163b890}, {pos = 0, events = 16777216, fd = 1454605872, user_data = 0x82a21b6a0 <__stack_chk_guard>}, {pos = 900875736, events = 8, fd = 0, user_data = 0x82a200e38}, {pos = 560183648, events = 8, fd = 560183504, user_data = 0x82a10cc82}, {pos = 0, events = 0, fd = 560183808, user_data = 0x835b245d8}, {pos = 560183440, events = 8, fd = 0, user_data = 0x0}, {pos = 1454605872, events = 2525217550, fd = 1075540746, user_data = 0x82a0417a0}, {pos = 704982392, events = 8, fd = 560182552, user_data = 0x82163b590}, {pos = 560182552, events = 8, fd = 1075540746, user_data = 0x82a03c388}, {pos = 704982392, events = 8, fd = 560182600, user_data = 0x82163b5c0}, {pos = 560182600, events = 8, fd = 704950676, user_data = 0x8220d4408}, {pos = 704950676, events = 8, fd = 560182704, user_data = 0x3c82401b243a}, {pos = 706773040, events = 8, fd = 1, user_data = 0x82163b5e0}, {pos = 1075540746, events = 15490, fd = 704858200, user_data = 0x82a052d78}, {pos = 560182712, events = 8, fd = 560182832, user_data = 0x82163b5b8}, {pos = 704945420, events = 8, fd = 571294728, user_data = 0x82a049d0c}, {pos = 560182816, events = 8, fd = 1075520570, user_data = 0x82163b648}, {pos = 560183304, events = 8, fd = 560182832, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x9683c30e526629ce}, {pos = 571318328, events = 8, fd = 1, user_data = 0x8220d4408}, {pos = 704889736, events = 8, fd = 571314824, user_data = 0x82a034858}, {pos = 571294728, events = 8, fd = 560182968, user_data = 0x82163b878}, {pos = 560182944, events = 8, fd = 1075539106, user_data = 0x298025}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8220da038}} [20:56:25.602] last_touch_time = 1732395101 [20:56:25.602] last_lockfile_recheck_time = 1732395101 [20:56:25.602] nevents = 1 [20:56:25.602] #21 0x00000000008982ab in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82163c068) at ../src/backend/postmaster/postmaster.c:1361 [20:56:25.602] userDoption = [20:56:25.602] listen_addr_saved = [20:56:25.602] output_config_variable = [20:56:25.602] opt = [20:56:25.602] status = [20:56:25.602] #22 0x00000000007d14ac in main (argc=4, argv=0x82163c068) at ../src/backend/main/main.c:196 [20:56:25.602] do_check_root = [20:56:25.611] [20:56:25.611] [20:56:25.611] [20:56:25.674] dumping /tmp/cores/postgres.17611.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:56:25.799] [New LWP 100136] [20:56:25.861] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [20:56:25.861] Program terminated with signal SIGABRT, Aborted. [20:56:25.861] Sent by thr_kill() from pid 17611 and user 1003. [20:56:25.861] #0 0x000000082caea41a in thr_kill () from /lib/libc.so.7 [20:56:25.905] [20:56:25.905] Thread 1 (LWP 100136): [20:56:25.905] #0 0x000000082caea41a in thr_kill () from /lib/libc.so.7 [20:56:25.905] No symbol table info available. [20:56:25.905] #1 0x000000082ca63e64 in raise () from /lib/libc.so.7 [20:56:25.905] No symbol table info available. [20:56:25.905] #2 0x000000082cb146f9 in abort () from /lib/libc.so.7 [20:56:25.905] No symbol table info available. [20:56:25.905] #3 0x0000000000a9d9d5 in ExceptionalCondition (conditionName=0x2ebfba "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [20:56:25.905] No locals. [20:56:25.905] #4 0x000000000076e0e9 in standard_ExecutorStart (queryDesc=0x8363ad088, eflags=0) at ../src/backend/executor/execMain.c:195 [20:56:25.905] estate = 0x83c563100 [20:56:25.905] oldcontext = 0x8362fe800 [20:56:25.905] #5 0x00000008396ed9c2 in pgss_ExecutorStart (queryDesc=0x8363ad088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [20:56:25.905] No locals. [20:56:25.905] #6 0x0000000000703ae5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [20:56:25.905] copied_query = [20:56:25.905] rewritten = [20:56:25.905] plan = 0x83c5d5bd8 [20:56:25.905] queryDesc = 0x8363ad088 [20:56:25.905] processed = [20:56:25.905] __error = [20:56:25.905] #7 RefreshMatViewByOid (matviewOid=28354, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [20:56:25.905] dest = [20:56:25.905] save_userid = 10 [20:56:25.905] save_sec_context = 0 [20:56:25.905] processed = 0 [20:56:25.905] matviewRel = 0x83c758d58 [20:56:25.905] relowner = 10 [20:56:25.905] save_nestlevel = 2 [20:56:25.905] rule = [20:56:25.905] actions = [20:56:25.905] dataQuery = [20:56:25.905] tableSpace = [20:56:25.905] relpersistence = [20:56:25.905] OIDNewHeap = 28368 [20:56:25.905] address = [20:56:25.905] #8 0x00000000007036c6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:56:25.905] lockmode = [20:56:25.905] matviewOid = 0 [20:56:25.905] #9 0x00000000006da7bc in ExecCreateTableAs (pstate=pstate@entry=0x8362fe900, stmt=stmt@entry=0x83637efd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821a7a9a0) at ../src/backend/commands/createas.c:351 [20:56:25.905] refresh = 0x0 [20:56:25.905] query = 0x83630b108 [20:56:25.905] into = 0x83637ef40 [20:56:25.905] jstate = 0x0 [20:56:25.905] do_refresh = false [20:56:25.905] address = [20:56:25.905] dest = [20:56:25.905] is_matview = [20:56:25.905] #10 0x0000000000949698 in ProcessUtilitySlow (pstate=pstate@entry=0x8362fe900, pstmt=pstmt@entry=0x83637ee30, queryString=queryString@entry=0x836223100 "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=0x821a7a9a0) at ../src/backend/tcop/utility.c:1678 [20:56:25.905] _local_sigjmp_buf = {{_sjb = {9735881, 0, 34924373000, 34924373376, 34924373008, 12425704, 0, 35268847872, 34924331903, 7, 34924373152, 0}}} [20:56:25.905] _save_exception_stack = 0x821a7a690 [20:56:25.905] _save_context_stack = 0x0 [20:56:25.905] _do_rethrow = false [20:56:25.905] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:56:25.905] parsetree = 0x83637efd0 [20:56:25.905] commandCollected = false [20:56:25.905] needCleanup = false [20:56:25.905] address = [20:56:25.905] isTopLevel = [20:56:25.905] isCompleteQuery = [20:56:25.905] #11 0x0000000000948018 in standard_ProcessUtility (pstmt=0x83637ee30, queryString=queryString@entry=0x836223100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83630b8a8, qc=0x821a7a9a0) at ../src/backend/tcop/utility.c:1033 [20:56:25.905] isAtomicContext = false [20:56:25.905] parsetree = 0x83637efd0 [20:56:25.905] readonly_flags = [20:56:25.905] pstate = 0x8362fe900 [20:56:25.905] isTopLevel = [20:56:25.905] #12 0x00000008396edf7e in pgss_ProcessUtility (pstmt=0x83637ee30, queryString=0x836223100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83630b8a8, qc=0x821a7a9a0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [20:56:25.905] _local_sigjmp_buf = {{_sjb = {35323305655, 34924373648, 34924373512, 34924373968, 35269373488, 0, 12425704, 34924374176, 34924331903, 34924373748, 34924373776, 0}}} [20:56:25.905] _save_exception_stack = 0x821a7a8a0 [20:56:25.905] _save_context_stack = 0x0 [20:56:25.905] _do_rethrow = false [20:56:25.905] bufusage = {shared_blks_hit = 35323305655, shared_blks_read = 34924373648, shared_blks_dirtied = 34924373512, shared_blks_written = 34924373968, local_blks_hit = 35269373488, local_blks_read = 0, local_blks_dirtied = 12425704, local_blks_written = 34924374176, temp_blks_read = 34924331903, temp_blks_written = 34924373748, shared_blk_read_time = {ticks = 34924373776}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4160759812469885056}, local_blk_write_time = {ticks = 12434744}, temp_blk_read_time = {ticks = 35332675584}, temp_blk_write_time = {ticks = 12387232}} [20:56:25.905] walusage_start = {wal_records = 8980, wal_fpi = 128, wal_bytes = 1242565} [20:56:25.905] duration = [20:56:25.905] bufusage_start = {shared_blks_hit = 153519, shared_blks_read = 8841, shared_blks_dirtied = 2697, shared_blks_written = 2416, local_blks_hit = 45, local_blks_read = 0, local_blks_dirtied = 10, local_blks_written = 17, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [20:56:25.905] walusage = {wal_records = -364382153798291242, wal_fpi = 35269373904, wal_bytes = 123} [20:56:25.905] start = {ticks = -183601724835} [20:56:25.905] rows = [20:56:25.905] saved_queryId = 6041762721901209185 [20:56:25.905] parsetree = [20:56:25.905] saved_stmt_location = 0 [20:56:25.905] saved_stmt_len = 69 [20:56:25.905] enabled = [20:56:25.905] #13 0x00000000009475e3 in PortalRunUtility (portal=0x8362c9100, pstmt=0x83637ee30, isTopLevel=, setHoldSnapshot=, dest=0x83630b8a8, qc=0x821a7a9a0) at ../src/backend/tcop/pquery.c:1158 [20:56:25.905] No locals. [20:56:25.905] #14 0x0000000000946c74 in PortalRunMulti (portal=portal@entry=0x8362c9100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83630b8a8, altdest=altdest@entry=0x83630b8a8, qc=0x821a7a9a0) at ../src/backend/tcop/pquery.c:1322 [20:56:25.905] pstmt = 0x83637ee30 [20:56:25.905] stmtlist_item__state = {l = 0x83630b858, i = 0} [20:56:25.905] active_snapshot_set = false [20:56:25.905] stmtlist_item = 0x83630b870 [20:56:25.905] #15 0x0000000000946543 in PortalRun (portal=portal@entry=0x8362c9100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83630b8a8, altdest=altdest@entry=0x83630b8a8, qc=0x821a7a9a0) at ../src/backend/tcop/pquery.c:791 [20:56:25.905] _local_sigjmp_buf = {{_sjb = {9725117, 35268628736, 34924374168, 34924374400, 34924374176, 35268644864, 12391288, 12425704, 35268592511, 35269367264, 4294967984, 0}}} [20:56:25.905] _save_exception_stack = 0x821a7aa70 [20:56:25.905] _save_context_stack = 0x0 [20:56:25.905] _do_rethrow = false [20:56:25.905] saveTopTransactionResourceOwner = 0x83631e3d8 [20:56:25.905] saveTopTransactionContext = 0x8362cd000 [20:56:25.905] saveActivePortal = 0x0 [20:56:25.905] saveResourceOwner = 0x83631e3d8 [20:56:25.905] savePortalContext = 0x0 [20:56:25.905] saveMemoryContext = 0x8362cd000 [20:56:25.905] result = [20:56:25.905] nprocessed = [20:56:25.905] #16 0x00000000009453e2 in exec_simple_query (query_string=query_string@entry=0x836223100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [20:56:25.905] cmdtaglen = 24 [20:56:25.905] snapshot_set = [20:56:25.905] per_parsetree_context = 0x0 [20:56:25.905] plantree_list = [20:56:25.905] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:56:25.905] format = 0 [20:56:25.905] parsetree = 0x8362246a8 [20:56:25.905] commandTag = [20:56:25.905] cmdtagname = [20:56:25.905] querytree_list = [20:56:25.905] portal = 0x8362c9100 [20:56:25.905] receiver = 0x83630b8a8 [20:56:25.905] parsetree_item__state = {l = 0x836224a18, i = 0} [20:56:25.905] msec_str = "\000\000\000\000\b", '\000' , "\233@Bg\000\000\000\000M\363\254\317A\376", [20:56:25.905] dest = DestRemote [20:56:25.905] was_logged = [20:56:25.905] oldcontext = 0x8362cd000 [20:56:25.905] parsetree_list = 0x836224a18 [20:56:25.905] use_implicit_block = false [20:56:25.905] parsetree_item = 0x836224a30 [20:56:25.905] save_log_statement_stats = [20:56:25.905] #17 0x0000000000943053 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4794 [20:56:25.905] query_string = 0x836223100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:56:25.905] input_message = {data = 0x836223100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:56:25.905] firstchar = [20:56:25.905] local_sigjmp_buf = {{_sjb = {9708806, 34924374640, 34924374600, 34924375184, 12434440, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [20:56:25.905] send_ready_for_query = false [20:56:25.905] idle_in_transaction_timeout_enabled = false [20:56:25.905] idle_session_timeout_enabled = false [20:56:25.905] #18 0x000000000093d849 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:56:25.905] bsdata = [20:56:25.905] #19 0x0000000000895ac5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x821a7b7a8 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a7b6f0) at ../src/backend/postmaster/launch_backend.c:274 [20:56:25.905] pid = [20:56:25.905] #20 0x0000000000899ca8 in BackendStartup (client_sock=0x821a7b6f0) at ../src/backend/postmaster/postmaster.c:3377 [20:56:25.905] startup_data = {canAcceptConnections = CAC_OK} [20:56:25.905] bn = 0x83630a158 [20:56:25.905] cac = CAC_OK [20:56:25.905] pid = [20:56:25.905] __error = [20:56:25.905] save_errno = [20:56:25.905] __error = [20:56:25.905] __error = [20:56:25.905] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [20:56:25.905] 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' , "P\267\247!\b\000\000\000he\313+\b\000\000\000W\000\000\000\000\000\000\000^\357\313+\b", '\000' , "\220\267\247!\b\000\000\000dX\211\000\000\000\000\000\240\267\247!\b", '\000' }, salen = 16}} [20:56:25.905] i = 0 [20:56:25.905] now = [20:56:25.905] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 479451855, events = 1334, fd = 571234872, user_data = 0x800000001}, {pos = 571208712, events = 8, fd = 748392808, user_data = 0x821a7afc8}, {pos = 564637456, events = 8, fd = 564637040, user_data = 0x1}, {pos = 571208712, events = 8, fd = 33, user_data = 0x821a7af00}, {pos = 1609316890, events = 1334, fd = 571179016, user_data = 0x8220b8408}, {pos = 571181064, events = 8, fd = 571182088, user_data = 0x8220bc008}, {pos = 571196424, events = 8, fd = 571197448, user_data = 0x8220bcc08}, {pos = 571199496, events = 8, fd = 571200520, user_data = 0x8220bd808}, {pos = 571202568, events = 8, fd = 571203592, user_data = 0x8220be408}, {pos = 571205640, events = 8, fd = 571206664, user_data = 0x8220bf008}, {pos = 571208712, events = 8, fd = -25761258, user_data = 0x8220c5038}, {pos = 1, events = 8, fd = 571208712, user_data = 0x82c9be478}, {pos = 564638024, events = 8, fd = 15, user_data = 0x821a7b090}, {pos = 564637424, events = 8, fd = 1, user_data = 0x821a7b048}, {pos = 33, events = 0, fd = 564637408, user_data = 0x5365fec9a73}, {pos = 564637376, events = 8, fd = 2591490, user_data = 0x8220bf408}, {pos = 748522179, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 571234872, events = 8, fd = 1, user_data = 0x8220bf408}, {pos = 748392808, events = 8, fd = 564637640, user_data = 0x821a7ad70}, {pos = 33, events = 18, fd = 0, user_data = 0x8220c5a38}, {pos = 1, events = 0, fd = 571208712, user_data = 0x347}, {pos = 564637616, events = 8, fd = 1609315823, user_data = 0x82c9d8ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x8220c5a38}, {pos = 1, events = 0, fd = 571208712, user_data = 0x836213000}, {pos = 1, events = 0, fd = 908145044, user_data = 0x0}, {pos = 564637568, events = 8, fd = 734782828, user_data = 0x1}, {pos = 908144640, events = 8, fd = 564637616, user_data = 0x82bcbd702}, {pos = 750229840, events = 8, fd = 750317944, user_data = 0x82cb79950 }, {pos = 571208712, events = 8, fd = 564637840, user_data = 0x5365fec33de}, {pos = 564638296, events = 8, fd = 1, user_data = 0x5365fec325e}, {pos = 571208712, events = 8, fd = 564637624, user_data = 0x821a7b090}, {pos = 12264, events = 0, fd = 0, user_data = 0x5365fed6990}, {pos = 564639232, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = -1738772266, events = 4210127964, fd = 0, user_data = 0x8220bf408}, {pos = 12264, events = 0, fd = 748371968, user_data = 0x1db178}, {pos = 750229840, events = 8, fd = 748506488, user_data = 0x3d4b}, {pos = 750376608, events = 8, fd = 564637952, user_data = 0x82ca78915 }, {pos = 750267960, events = 8, fd = 564637888, user_data = 0x821a7b530}, {pos = 0, events = 0, fd = 564637952, user_data = 0x82ca8eb61}, {pos = 1, events = 0, fd = 564639024, user_data = 0x821a7b530}, {pos = 0, events = 16777216, fd = -1738772266, user_data = 0x82cb9d6a0 <__stack_chk_guard>}, {pos = 908617176, events = 8, fd = 0, user_data = 0x82cb82e38}, {pos = 564639232, events = 8, fd = 564639088, user_data = 0x82ca8ec82}, {pos = 0, events = 0, fd = 564639392, user_data = 0x8362865d8}, {pos = 564639024, events = 8, fd = 0, user_data = 0x5365feca30a}, {pos = 748435360, events = 8, fd = 748506488, user_data = 0x821a7b1a8}, {pos = 564638240, events = 8, fd = 564638120, user_data = 0x5365feca30a}, {pos = 748413832, events = 8, fd = 748506488, user_data = 0x821a7b1d8}, {pos = 564638288, events = 8, fd = 564638168, user_data = 0x82c9cd194}, {pos = 571208712, events = 8, fd = 748474772, user_data = 0x821a7b240}, {pos = 1609323578, events = 1334, fd = 564638176, user_data = 0x82bcb4410 <__pthread_cleanup_pop_imp+48>}, {pos = 750297136, events = 8, fd = 1609343754, user_data = 0x82c9b6858}, {pos = 748506488, events = 8, fd = 564638280, user_data = 0x821a7b2c0}, {pos = 564638280, events = 8, fd = 748469516, user_data = 0x8220bf408}, {pos = 748469516, events = 8, fd = 564638384, user_data = 0x5365fec543a}, {pos = 564638424, events = 8, fd = 564638888, user_data = 0x821a7b2c0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 571232312, user_data = 0xfaf1745c00000001}, {pos = 571208712, events = 8, fd = 748413832, user_data = 0x8220c47c8}, {pos = 0, events = 0, fd = 0, user_data = 0x821a7b348}, {pos = 564639000, events = 8, fd = 564638512, user_data = 0x5365fec9ca2}, {pos = 2719781, events = 0, fd = 448139, user_data = 0xfaf1745c7c96e577}, {pos = 571232312, events = 8, fd = 1, user_data = 0x0}} [20:56:25.905] last_touch_time = 1732395138 [20:56:25.905] last_lockfile_recheck_time = 1732395138 [20:56:25.905] nevents = 1 [20:56:25.905] #22 0x00000000008982ab in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a7bd00) at ../src/backend/postmaster/postmaster.c:1361 [20:56:25.905] userDoption = [20:56:25.905] listen_addr_saved = [20:56:25.905] output_config_variable = [20:56:25.905] opt = [20:56:25.905] status = [20:56:25.905] #23 0x00000000007d14ac in main (argc=4, argv=0x821a7bd00) at ../src/backend/main/main.c:196 [20:56:25.905] do_check_root =