[01:09:50.095] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [01:09:50.429] dumping /tmp/cores/postgres.10694.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [01:09:50.549] [New LWP 101819] [01:09:50.628] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [01:09:50.628] Program terminated with signal SIGABRT, Aborted. [01:09:50.628] Sent by thr_kill() from pid 10694 and user 1003. [01:09:50.628] #0 0x000000082a69241a in thr_kill () from /lib/libc.so.7 [01:09:51.150] [01:09:51.150] Thread 1 (LWP 101819): [01:09:51.150] #0 0x000000082a69241a in thr_kill () from /lib/libc.so.7 [01:09:51.150] No symbol table info available. [01:09:51.150] #1 0x000000082a60be64 in raise () from /lib/libc.so.7 [01:09:51.150] No symbol table info available. [01:09:51.150] #2 0x000000082a6bc6f9 in abort () from /lib/libc.so.7 [01:09:51.150] No symbol table info available. [01:09:51.150] #3 0x0000000000a57c55 in ExceptionalCondition (conditionName=0x2e5f8a "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=196) at ../src/backend/utils/error/assert.c:66 [01:09:51.150] No locals. [01:09:51.150] #4 0x000000000072e809 in standard_ExecutorStart (queryDesc=0x834f75380, eflags=0) at ../src/backend/executor/execMain.c:196 [01:09:51.150] estate = 0x841009100 [01:09:51.150] oldcontext = 0x83504d800 [01:09:51.150] #5 0x00000000006c5595 in refresh_matview_datafill (dest=0x835045f38, query=, queryString=0x0) at ../src/backend/commands/matview.c:429 [01:09:51.150] copied_query = [01:09:51.150] rewritten = [01:09:51.150] plan = [01:09:51.150] queryDesc = 0x834f75380 [01:09:51.150] processed = [01:09:51.150] __error = [01:09:51.150] #6 RefreshMatViewByOid (matviewOid=27370, skipData=, concurrent=, queryString=0x0, params=, qc=0x0) at ../src/backend/commands/matview.c:321 [01:09:51.150] save_userid = 10 [01:09:51.150] save_sec_context = 0 [01:09:51.150] processed = 0 [01:09:51.150] matviewRel = 0x840f5ed60 [01:09:51.150] relowner = 10 [01:09:51.150] save_nestlevel = 2 [01:09:51.150] rule = [01:09:51.150] actions = [01:09:51.150] dataQuery = [01:09:51.150] tableSpace = [01:09:51.150] relpersistence = [01:09:51.150] OIDNewHeap = 27377 [01:09:51.150] dest = 0x835045f38 [01:09:51.150] address = [01:09:51.150] #7 0x00000000006c51a4 in ExecRefreshMatView (stmt=, queryString=0x82a6923fa "\017\202x\341\377\377\303", '\314' , "̸\261\001", queryString@entry=0x0, params=params@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:09:51.150] lockmode = [01:09:51.150] matviewOid = 0 [01:09:51.150] #8 0x000000000069d0bf in ExecCreateTableAs (pstate=pstate@entry=0x83504d900, stmt=stmt@entry=0x841051fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820b97b70) at ../src/backend/commands/createas.c:353 [01:09:51.150] refresh = 0x0 [01:09:51.150] query = 0x834f719d8 [01:09:51.150] into = 0x834f71d20 [01:09:51.150] do_refresh = false [01:09:51.150] address = [01:09:51.150] dest = [01:09:51.150] rewritten = [01:09:51.150] plan = [01:09:51.150] queryDesc = [01:09:51.150] is_matview = [01:09:51.150] #9 0x0000000000906c6a in ProcessUtilitySlow (pstate=pstate@entry=0x83504d900, pstmt=pstmt@entry=0x834eafa68, queryString=queryString@entry=0x834eae100 "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=0x820b97b70) at ../src/backend/tcop/utility.c:1675 [01:09:51.150] _local_sigjmp_buf = {{_sjb = {9462953, 0, 34908764056, 34908764432, 34908764064, 12130696, 0, 35249248512, 4294902655, 34908764172, 34908764208, 0}}} [01:09:51.150] _save_exception_stack = 0x820b97a70 [01:09:51.150] _save_context_stack = 0x0 [01:09:51.150] _do_rethrow = false [01:09:51.150] validnsps = {0x371d32 "toast", 0x0} [01:09:51.150] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:09:51.150] parsetree = 0x841051fd0 [01:09:51.150] commandCollected = false [01:09:51.150] needCleanup = false [01:09:51.150] address = [01:09:51.150] isTopLevel = [01:09:51.150] isCompleteQuery = [01:09:51.150] #10 0x00000000009055f8 in standard_ProcessUtility (pstmt=0x834eafa68, queryString=0x834eae100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834f72208, qc=0x820b97b70) at ../src/backend/tcop/utility.c:1030 [01:09:51.150] isAtomicContext = false [01:09:51.150] parsetree = 0x841051fd0 [01:09:51.150] readonly_flags = [01:09:51.150] pstate = 0x83504d900 [01:09:51.150] isTopLevel = [01:09:51.150] #11 0x0000000000905088 in ProcessUtility (pstmt=0x18dbb, queryString=0x6 , readOnlyTree=, context=711533562, params=0x0, queryEnv=0x0, dest=0x834f72208, qc=0x820b97b70) at ../src/backend/tcop/utility.c:523 [01:09:51.150] No locals. [01:09:51.150] #12 0x0000000000904bc3 in PortalRunUtility (portal=0x834f85100, pstmt=0x834eafa68, isTopLevel=, setHoldSnapshot=, dest=0x834f72208, qc=0x820b97b70) at ../src/backend/tcop/pquery.c:1158 [01:09:51.150] No locals. [01:09:51.150] #13 0x0000000000904254 in PortalRunMulti (portal=portal@entry=0x834f85100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x834f72208, altdest=altdest@entry=0x834f72208, qc=0x820b97b70) at ../src/backend/tcop/pquery.c:1322 [01:09:51.150] pstmt = 0x834eafa68 [01:09:51.150] stmtlist_item__state = {l = 0x834f721b8, i = 0} [01:09:51.150] active_snapshot_set = false [01:09:51.150] stmtlist_item = 0x834f721d0 [01:09:51.150] #14 0x0000000000903b23 in PortalRun (portal=portal@entry=0x834f85100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x834f72208, altdest=altdest@entry=0x834f72208, qc=0x820b97b70) at ../src/backend/tcop/pquery.c:791 [01:09:51.150] _local_sigjmp_buf = {{_sjb = {9452189, 35248427264, 34908764776, 34908765008, 34908764784, 35248443392, 12098480, 12130696, 35248407423, 35450586512, 4294967984, 0}}} [01:09:51.150] _save_exception_stack = 0x820b97c40 [01:09:51.150] _save_context_stack = 0x0 [01:09:51.150] _do_rethrow = false [01:09:51.150] saveTopTransactionResourceOwner = 0x834f96e18 [01:09:51.150] saveTopTransactionContext = 0x834f89000 [01:09:51.150] saveActivePortal = 0x0 [01:09:51.150] saveResourceOwner = 0x834f96e18 [01:09:51.150] savePortalContext = 0x0 [01:09:51.150] saveMemoryContext = 0x834f89000 [01:09:51.150] result = [01:09:51.150] nprocessed = [01:09:51.150] #15 0x00000000009029c2 in exec_simple_query (query_string=query_string@entry=0x834eae100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1274 [01:09:51.150] cmdtaglen = 24 [01:09:51.150] snapshot_set = [01:09:51.150] per_parsetree_context = 0x0 [01:09:51.150] plantree_list = [01:09:51.150] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:09:51.150] format = 0 [01:09:51.150] parsetree = 0x834eaf6a8 [01:09:51.150] commandTag = [01:09:51.150] cmdtagname = [01:09:51.150] querytree_list = [01:09:51.150] portal = 0x834f85100 [01:09:51.150] receiver = 0x834f72208 [01:09:51.150] parsetree_item__state = {l = 0x834eafa18, i = 0} [01:09:51.150] msec_str = "\000\000\000\000\b", '\000' , "9H\244f\000\000\000\000|\006\307D*U\275[" [01:09:51.150] dest = DestRemote [01:09:51.150] was_logged = [01:09:51.150] oldcontext = 0x834f89000 [01:09:51.150] parsetree_list = 0x834eafa18 [01:09:51.150] use_implicit_block = false [01:09:51.150] parsetree_item = 0x834eafa30 [01:09:51.150] save_log_statement_stats = [01:09:51.150] #16 0x0000000000900770 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4675 [01:09:51.150] query_string = 0x834eae100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:09:51.150] input_message = {data = 0x834eae100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:09:51.150] firstchar = [01:09:51.150] local_sigjmp_buf = {{_sjb = {9436246, 34908765248, 34908765208, 34908765792, 12139432, 11982416, 8192, 8388608, 34908734335, 0, 0, 1}}} [01:09:51.150] send_ready_for_query = false [01:09:51.150] idle_in_transaction_timeout_enabled = false [01:09:51.150] idle_session_timeout_enabled = false [01:09:51.150] #17 0x00000000008fb219 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:106 [01:09:51.150] bsdata = [01:09:51.150] #18 0x00000000008556a2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820b98964 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820b988b0) at ../src/backend/postmaster/launch_backend.c:269 [01:09:51.150] pid = [01:09:51.150] #19 0x0000000000859fe0 in BackendStartup (client_sock=0x820b988b0) at ../src/backend/postmaster/postmaster.c:3593 [01:09:51.150] startup_data = {canAcceptConnections = CAC_OK} [01:09:51.150] bn = 0x834eba5d8 [01:09:51.150] pid = [01:09:51.150] __error = [01:09:51.150] __error = [01:09:51.150] save_errno = [01:09:51.150] __error = [01:09:51.150] __error = [01:09:51.150] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [01:09:51.150] 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 = "\v\000\000\000\000\000\000\000\000\211\271 \b\000\000\000h\325!*\b", '\000' , "^_\"*\b", '\000' , "@\211\271 \b\000\000\000tT\205\000\000\000\000\000*H\244f", '\000' }, salen = 16}} [01:09:51.150] i = 0 [01:09:51.150] now = [01:09:51.150] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1, events = 8, fd = 560894984, user_data = 0x82a561168}, {pos = 549028200, events = 8, fd = 549028016, user_data = 0x820b97f20}, {pos = 1, events = 0, fd = 560894984, user_data = 0x20}, {pos = 549028000, events = 8, fd = -1933063654, user_data = 0x8216e2008}, {pos = 560866312, events = 8, fd = 560867336, user_data = 0x8216e2c08}, {pos = 560881672, events = 8, fd = 560882696, user_data = 0x8216e6808}, {pos = 560884744, events = 8, fd = 560885768, user_data = 0x8216e7408}, {pos = 560887816, events = 8, fd = 560888840, user_data = 0x8216e8008}, {pos = 560890888, events = 8, fd = 560891912, user_data = 0x8216e8c08}, {pos = 560893960, events = 8, fd = 560894984, user_data = 0x0}, {pos = 712309664, events = 8, fd = 712310952, user_data = 0x834600980}, {pos = 549028000, events = 8, fd = 711834236, user_data = 0x1000}, {pos = 711853830, events = 8, fd = 878746592, user_data = 0xa0}, {pos = 549028000, events = 8, fd = 711833502, user_data = 0x820b98090}, {pos = 0, events = 0, fd = 560894984, user_data = 0x82a580ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x8216efa38}, {pos = 1, events = 8, fd = 560894984, user_data = 0x82a561168}, {pos = 549028200, events = 8, fd = 549027616, user_data = 0x1200000020}, {pos = 0, events = 0, fd = 560921144, user_data = 0x1}, {pos = 560894984, events = 8, fd = 839, user_data = 0x820b98150}, {pos = -1933064721, events = 12964, fd = 710412995, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 560921144, user_data = 0x1}, {pos = 560894984, events = 8, fd = 887742464, user_data = 0x1}, {pos = 887742868, events = 8, fd = 0, user_data = 0x820b98120}, {pos = 706893164, events = 8, fd = 1, user_data = 0x834e9e000}, {pos = 549028176, events = 8, fd = 706889474, user_data = 0x82a721950 }, {pos = 712208760, events = 8, fd = 712120656, user_data = 0x8216e9408}, {pos = 549028400, events = 8, fd = -1933065250, user_data = 0x8331d3090}, {pos = 1, events = 0, fd = -1933065634, user_data = 0x8216e9408}, {pos = 549028184, events = 8, fd = 549028400, user_data = 0x2fe8}, {pos = 0, events = 0, fd = -1932985968, user_data = 0x820b987a0}, {pos = 115213183, events = 0, fd = -25761258, user_data = 0xd8d7812d3cdbb52b}, {pos = 0, events = 8, fd = 560894984, user_data = 0x2fe8}, {pos = 710262784, events = 8, fd = 1945976, user_data = 0x82a721950 }, {pos = 710397304, events = 8, fd = 15691, user_data = 0x82a7456a0 <__stack_chk_guard>}, {pos = 549028512, events = 8, fd = 711067925, user_data = 0x82a72ae38}, {pos = 549028448, events = 8, fd = 549029584, user_data = 0x0}, {pos = 549028512, events = 8, fd = 711158625, user_data = 0x1}, {pos = 549029584, events = 8, fd = 549029584, user_data = 0x100000000000000}, {pos = 1021031723, events = 3638001965, fd = 712267424, user_data = 0x834f055d8}, {pos = 0, events = 0, fd = 712158776, user_data = 0x820b987a0}, {pos = 549029648, events = 8, fd = 711158914, user_data = 0x0}, {pos = 549029952, events = 8, fd = 888165848, user_data = 0x820b986d0}, {pos = 0, events = 0, fd = 0, user_data = 0xd8d7812d3cdbb52b}, {pos = -1933036790, events = 12964, fd = 710326176, user_data = 0x82a57cd78}, {pos = 549028696, events = 8, fd = 549028816, user_data = 0x820b98358}, {pos = -1933036790, events = 12964, fd = 710304648, user_data = 0x82a57cd78}, {pos = 549028744, events = 8, fd = 549028864, user_data = 0x820b98388}, {pos = 710365588, events = 8, fd = 560894984, user_data = 0x82a575194}, {pos = 549028848, events = 8, fd = -1933056966, user_data = 0x82a732030 <__thr_jtable>}, {pos = 1, events = 0, fd = 549028896, user_data = 0x82a566388}, {pos = 0, events = 0, fd = -1933036790, user_data = 0x82a55e858}, {pos = 710397304, events = 8, fd = 549028872, user_data = 0x820b98480}, {pos = 549028872, events = 8, fd = 710360332, user_data = 0x8216e9408}, {pos = 710360332, events = 8, fd = 549028976, user_data = 0x32a48cc7e43a}, {pos = 549028976, events = 8, fd = -1933038430, user_data = 0x28d228}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 1, events = 8, fd = 560894984, user_data = 0x82a566388}, {pos = 549029704, events = 8, fd = 857552276, user_data = 0x8216ee288}, {pos = 710273112, events = 8, fd = 560894984, user_data = 0x820b98508}, {pos = 549029576, events = 8, fd = 549029104, user_data = 0x32a48cc82ca2}, {pos = 2698906, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560918584, events = 8, fd = 1, user_data = 0x0}} [01:09:51.150] last_touch_time = 1722042410 [01:09:51.150] last_lockfile_recheck_time = 1722042410 [01:09:51.150] nevents = 1 [01:09:51.150] #21 0x0000000000857885 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820b98ea0) at ../src/backend/postmaster/postmaster.c:1372 [01:09:51.150] userDoption = [01:09:51.150] listen_addr_saved = [01:09:51.150] output_config_variable = [01:09:51.150] opt = [01:09:51.150] status = [01:09:51.150] #22 0x000000000079184c in main (argc=8, argv=0x820b98ea0) at ../src/backend/main/main.c:197 [01:09:51.150] do_check_root = [01:09:51.161] [01:09:51.161] [01:09:51.161] [01:09:51.219] dumping /tmp/cores/postgres.11548.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:09:51.333] [New LWP 101900] [01:09:51.392] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [01:09:51.392] Program terminated with signal SIGABRT, Aborted. [01:09:51.392] Sent by thr_kill() from pid 11548 and user 1003. [01:09:51.392] #0 0x0000000829d0541a in thr_kill () from /lib/libc.so.7 [01:09:51.896] [01:09:51.896] Thread 1 (LWP 101900): [01:09:51.896] #0 0x0000000829d0541a in thr_kill () from /lib/libc.so.7 [01:09:51.896] No symbol table info available. [01:09:51.896] #1 0x0000000829c7ee64 in raise () from /lib/libc.so.7 [01:09:51.896] No symbol table info available. [01:09:51.896] #2 0x0000000829d2f6f9 in abort () from /lib/libc.so.7 [01:09:51.896] No symbol table info available. [01:09:51.896] #3 0x0000000000a57c55 in ExceptionalCondition (conditionName=0x2e5f8a "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=196) at ../src/backend/utils/error/assert.c:66 [01:09:51.896] No locals. [01:09:51.896] #4 0x000000000072e809 in standard_ExecutorStart (queryDesc=0x837639380, eflags=0) at ../src/backend/executor/execMain.c:196 [01:09:51.896] estate = 0x843ea7100 [01:09:51.896] oldcontext = 0x837751800 [01:09:51.896] #5 0x00000000006c5595 in refresh_matview_datafill (dest=0x837649f38, query=, queryString=0x0) at ../src/backend/commands/matview.c:429 [01:09:51.896] copied_query = [01:09:51.896] rewritten = [01:09:51.896] plan = [01:09:51.896] queryDesc = 0x837639380 [01:09:51.896] processed = [01:09:51.896] __error = [01:09:51.896] #6 RefreshMatViewByOid (matviewOid=27323, skipData=, concurrent=, queryString=0x0, params=, qc=0x0) at ../src/backend/commands/matview.c:321 [01:09:51.896] save_userid = 10 [01:09:51.896] save_sec_context = 0 [01:09:51.896] processed = 0 [01:09:51.896] matviewRel = 0x843dc9a58 [01:09:51.896] relowner = 10 [01:09:51.896] save_nestlevel = 2 [01:09:51.896] rule = [01:09:51.896] actions = [01:09:51.896] dataQuery = [01:09:51.896] tableSpace = [01:09:51.896] relpersistence = [01:09:51.896] OIDNewHeap = 27346 [01:09:51.896] dest = 0x837649f38 [01:09:51.896] address = [01:09:51.896] #7 0x00000000006c51a4 in ExecRefreshMatView (stmt=, queryString=0x829d053fa "\017\202x\341\377\377\303", '\314' , "̸\261\001", queryString@entry=0x0, params=params@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:09:51.896] lockmode = [01:09:51.896] matviewOid = 0 [01:09:51.896] #8 0x000000000069d0bf in ExecCreateTableAs (pstate=pstate@entry=0x837751900, stmt=stmt@entry=0x843ea0fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820dbcf50) at ../src/backend/commands/createas.c:353 [01:09:51.896] refresh = 0x0 [01:09:51.896] query = 0x8376fcfd8 [01:09:51.896] into = 0x8376fd320 [01:09:51.896] do_refresh = false [01:09:51.896] address = [01:09:51.896] dest = [01:09:51.896] rewritten = [01:09:51.896] plan = [01:09:51.896] queryDesc = [01:09:51.896] is_matview = [01:09:51.896] #9 0x0000000000906c6a in ProcessUtilitySlow (pstate=pstate@entry=0x837751900, pstmt=pstmt@entry=0x83757ea68, queryString=queryString@entry=0x83757d100 "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=0x820dbcf50) at ../src/backend/tcop/utility.c:1675 [01:09:51.896] _local_sigjmp_buf = {{_sjb = {9462953, 0, 34911013752, 34911014128, 34911013760, 12130696, 0, 35290159360, 4294902655, 34911013868, 34911013904, 0}}} [01:09:51.896] _save_exception_stack = 0x820dbce50 [01:09:51.896] _save_context_stack = 0x0 [01:09:51.896] _do_rethrow = false [01:09:51.896] validnsps = {0x371d32 "toast", 0x0} [01:09:51.896] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:09:51.896] parsetree = 0x843ea0fd0 [01:09:51.896] commandCollected = false [01:09:51.896] needCleanup = false [01:09:51.896] address = [01:09:51.896] isTopLevel = [01:09:51.896] isCompleteQuery = [01:09:51.896] #10 0x00000000009055f8 in standard_ProcessUtility (pstmt=0x83757ea68, queryString=0x83757d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8376fd808, qc=0x820dbcf50) at ../src/backend/tcop/utility.c:1030 [01:09:51.896] isAtomicContext = false [01:09:51.896] parsetree = 0x843ea0fd0 [01:09:51.896] readonly_flags = [01:09:51.896] pstate = 0x837751900 [01:09:51.896] isTopLevel = [01:09:51.896] #11 0x0000000000905088 in ProcessUtility (pstmt=0x18e0c, queryString=0x6 , readOnlyTree=, context=701518842, params=0x0, queryEnv=0x0, dest=0x8376fd808, qc=0x820dbcf50) at ../src/backend/tcop/utility.c:523 [01:09:51.896] No locals. [01:09:51.896] #12 0x0000000000904bc3 in PortalRunUtility (portal=0x837618100, pstmt=0x83757ea68, isTopLevel=, setHoldSnapshot=, dest=0x8376fd808, qc=0x820dbcf50) at ../src/backend/tcop/pquery.c:1158 [01:09:51.896] No locals. [01:09:51.896] #13 0x0000000000904254 in PortalRunMulti (portal=portal@entry=0x837618100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8376fd808, altdest=altdest@entry=0x8376fd808, qc=0x820dbcf50) at ../src/backend/tcop/pquery.c:1322 [01:09:51.896] pstmt = 0x83757ea68 [01:09:51.896] stmtlist_item__state = {l = 0x8376fd7b8, i = 0} [01:09:51.896] active_snapshot_set = false [01:09:51.896] stmtlist_item = 0x8376fd7d0 [01:09:51.896] #14 0x0000000000903b23 in PortalRun (portal=portal@entry=0x837618100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8376fd808, altdest=altdest@entry=0x8376fd808, qc=0x820dbcf50) at ../src/backend/tcop/pquery.c:791 [01:09:51.896] _local_sigjmp_buf = {{_sjb = {9452189, 35288875264, 34911014472, 34911014704, 34911014480, 35288891392, 12098480, 12130696, 35288843135, 35499144592, 4294967984, 0}}} [01:09:51.896] _save_exception_stack = 0x820dbd020 [01:09:51.896] _save_context_stack = 0x0 [01:09:51.896] _do_rethrow = false [01:09:51.896] saveTopTransactionResourceOwner = 0x83766a6d8 [01:09:51.896] saveTopTransactionContext = 0x83761c000 [01:09:51.896] saveActivePortal = 0x0 [01:09:51.896] saveResourceOwner = 0x83766a6d8 [01:09:51.896] savePortalContext = 0x0 [01:09:51.896] saveMemoryContext = 0x83761c000 [01:09:51.896] result = [01:09:51.896] nprocessed = [01:09:51.896] #15 0x00000000009029c2 in exec_simple_query (query_string=query_string@entry=0x83757d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1274 [01:09:51.896] cmdtaglen = 24 [01:09:51.896] snapshot_set = [01:09:51.896] per_parsetree_context = 0x0 [01:09:51.896] plantree_list = [01:09:51.896] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:09:51.896] format = 0 [01:09:51.896] parsetree = 0x83757e6a8 [01:09:51.896] commandTag = [01:09:51.896] cmdtagname = [01:09:51.896] querytree_list = [01:09:51.896] portal = 0x837618100 [01:09:51.896] receiver = 0x8376fd808 [01:09:51.896] parsetree_item__state = {l = 0x83757ea18, i = 0} [01:09:51.896] msec_str = "\000\000\000\000\b", '\000' , ">H\244f\000\000\000\000\214:\034\244'B\aB" [01:09:51.896] dest = DestRemote [01:09:51.896] was_logged = [01:09:51.896] oldcontext = 0x83761c000 [01:09:51.896] parsetree_list = 0x83757ea18 [01:09:51.896] use_implicit_block = false [01:09:51.896] parsetree_item = 0x83757ea30 [01:09:51.896] save_log_statement_stats = [01:09:51.896] #16 0x0000000000900770 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4675 [01:09:51.896] query_string = 0x83757d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:09:51.896] input_message = {data = 0x83757d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:09:51.896] firstchar = [01:09:51.896] local_sigjmp_buf = {{_sjb = {9436246, 34911014944, 34911014904, 34911015488, 12139432, 11982416, 8192, 8388608, 34910962559, 0, 0, 1}}} [01:09:51.896] send_ready_for_query = false [01:09:51.896] idle_in_transaction_timeout_enabled = false [01:09:51.896] idle_session_timeout_enabled = false [01:09:51.896] #17 0x00000000008fb219 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:106 [01:09:51.896] bsdata = [01:09:51.896] #18 0x00000000008556a2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820dbdd44 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820dbdc90) at ../src/backend/postmaster/launch_backend.c:269 [01:09:51.896] pid = [01:09:51.896] #19 0x0000000000859fe0 in BackendStartup (client_sock=0x820dbdc90) at ../src/backend/postmaster/postmaster.c:3593 [01:09:51.896] startup_data = {canAcceptConnections = CAC_OK} [01:09:51.896] bn = 0x837589448 [01:09:51.896] pid = [01:09:51.896] __error = [01:09:51.896] __error = [01:09:51.896] save_errno = [01:09:51.896] __error = [01:09:51.896] __error = [01:09:51.896] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [01:09:51.896] 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 = "\v\000\000\000\000\000\000\000\340\334\333 \b\000\000\000hU\300*\b", '\000' , "^\337\300*\b", '\000' , " \335\333 \b\000\000\000tT\205\000\000\000\000\000,H\244f", '\000' }, salen = 16}} [01:09:51.896] i = 0 [01:09:51.896] now = [01:09:51.896] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 1, events = 8, fd = 554152968, user_data = 0x829bd4168}, {pos = 551277896, events = 8, fd = 551277712, user_data = 0x820dbd300}, {pos = 1, events = 0, fd = 554152968, user_data = 0x20}, {pos = 551277696, events = 8, fd = -747521510, user_data = 0x821074008}, {pos = 554124296, events = 8, fd = 554125320, user_data = 0x821074c08}, {pos = 554139656, events = 8, fd = 554140680, user_data = 0x821078808}, {pos = 554142728, events = 8, fd = 554143752, user_data = 0x821079408}, {pos = 554145800, events = 8, fd = 554146824, user_data = 0x82107a008}, {pos = 554148872, events = 8, fd = 554149896, user_data = 0x82107ac08}, {pos = 554151944, events = 8, fd = 554152968, user_data = 0x8fe76ea16}, {pos = 554176568, events = 8, fd = 1, user_data = 0x82107b408}, {pos = 700290168, events = 8, fd = 551278280, user_data = 0x2afc2f}, {pos = 551278096, events = 8, fd = 551277696, user_data = 0x1}, {pos = 551278024, events = 8, fd = 32, user_data = 0x820dbd470}, {pos = -747496845, events = 8056, fd = 554152968, user_data = 0x829bf3ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821081a38}, {pos = 1, events = 0, fd = 554152968, user_data = 0x829bd4168}, {pos = 551277896, events = 8, fd = 551277312, user_data = 0x1200000020}, {pos = 0, events = 0, fd = 554179128, user_data = 0x1}, {pos = 554152968, events = 8, fd = 839, user_data = 0x820dbd530}, {pos = -747522577, events = 8056, fd = 700398275, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 554179128, user_data = 0x1}, {pos = 554152968, events = 8, fd = 928436224, user_data = 0x1}, {pos = 928436628, events = 8, fd = 0, user_data = 0x820dbd500}, {pos = 717280620, events = 8, fd = 1, user_data = 0x83756d000}, {pos = 551277872, events = 8, fd = 717276930, user_data = 0x829d94950 }, {pos = 702194040, events = 8, fd = 702105936, user_data = 0x82107b408}, {pos = 551278096, events = 8, fd = -747523106, user_data = 0x821079008}, {pos = 1, events = 8, fd = -747523490, user_data = 0x82107b408}, {pos = 551277880, events = 8, fd = 551278096, user_data = 0x2fe8}, {pos = 0, events = 0, fd = -747443824, user_data = 0x820dbdb80}, {pos = 115213183, events = 0, fd = -25761258, user_data = 0xa54c9a502557f4e2}, {pos = 0, events = 8, fd = 554152968, user_data = 0x2fe8}, {pos = 700248064, events = 8, fd = 1945976, user_data = 0x829d94950 }, {pos = 700382584, events = 8, fd = 15691, user_data = 0x829db86a0 <__stack_chk_guard>}, {pos = 551278208, events = 8, fd = 701053205, user_data = 0x829d9de38}, {pos = 551278144, events = 8, fd = 551279280, user_data = 0x0}, {pos = 551278208, events = 8, fd = 701143905, user_data = 0x1}, {pos = 551279280, events = 8, fd = 551279280, user_data = 0x100000000000000}, {pos = 626521314, events = 2773260880, fd = 702252704, user_data = 0x8375dd5d8}, {pos = 0, events = 0, fd = 702144056, user_data = 0x820dbdb80}, {pos = 551279344, events = 8, fd = 701144194, user_data = 0x0}, {pos = 551279648, events = 8, fd = 928896472, user_data = 0x820dbdab0}, {pos = 0, events = 0, fd = 0, user_data = 0xa54c9a502557f4e2}, {pos = -747494646, events = 8056, fd = 700311456, user_data = 0x829befd78}, {pos = 551278392, events = 8, fd = 551278512, user_data = 0x820dbd738}, {pos = -747494646, events = 8056, fd = 700289928, user_data = 0x829befd78}, {pos = 551278440, events = 8, fd = 551278560, user_data = 0x820dbd768}, {pos = 700350868, events = 8, fd = 554152968, user_data = 0x829be8194}, {pos = 551278544, events = 8, fd = -747514822, user_data = 0x829da5030 <__thr_jtable>}, {pos = 1, events = 0, fd = 551278592, user_data = 0x829bd9388}, {pos = 0, events = 0, fd = -747494646, user_data = 0x829bd1858}, {pos = 700382584, events = 8, fd = 551278568, user_data = 0x820dbd860}, {pos = 551278568, events = 8, fd = 700345612, user_data = 0x82107b408}, {pos = 700345612, events = 8, fd = 551278672, user_data = 0x1f78d371d43a}, {pos = 551278672, events = 8, fd = -747496286, user_data = 0x28d228}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 1, events = 8, fd = 554152968, user_data = 0x829bd9388}, {pos = 551279400, events = 8, fd = 893429140, user_data = 0x821080288}, {pos = 700258392, events = 8, fd = 554152968, user_data = 0x820dbd8e8}, {pos = 551279272, events = 8, fd = 551278800, user_data = 0x1f78d3721ca2}, {pos = 2698906, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 554176568, events = 8, fd = 1, user_data = 0x0}} [01:09:51.896] last_touch_time = 1722042412 [01:09:51.896] last_lockfile_recheck_time = 1722042412 [01:09:51.896] nevents = 1 [01:09:51.896] #21 0x0000000000857885 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820dbe288) at ../src/backend/postmaster/postmaster.c:1372 [01:09:51.896] userDoption = [01:09:51.896] listen_addr_saved = [01:09:51.896] output_config_variable = [01:09:51.896] opt = [01:09:51.896] status = [01:09:51.896] #22 0x000000000079184c in main (argc=4, argv=0x820dbe288) at ../src/backend/main/main.c:197 [01:09:51.896] do_check_root = [01:09:51.908] [01:09:51.908] [01:09:51.908] [01:09:51.955] dumping /tmp/cores/sh.13552.core for /bin/sh [01:09:51.993] [New LWP 101832] [01:09:51.993] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/'. [01:09:51.993] Program terminated with signal SIGQUIT, Quit. [01:09:51.993] Sent by kill() from pid 13418 and user 1003. [01:09:51.993] #0 0x00003f0ed7805ff0 in ?? () [01:09:51.993] [01:09:51.993] Thread 1 (LWP 101832): [01:09:51.993] #0 0x00003f0ed7805ff0 in ?? () [01:09:51.993] No symbol table info available. [01:09:51.993] #1 0x0000000000000000 in ?? () [01:09:51.993] No symbol table info available. [01:09:51.998] [01:09:51.998] [01:09:51.998] [01:09:52.054] dumping /tmp/cores/postgres.18367.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:09:52.167] [New LWP 100163] [01:09:52.227] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [01:09:52.227] Program terminated with signal SIGABRT, Aborted. [01:09:52.227] Sent by thr_kill() from pid 18367 and user 1003. [01:09:52.227] #0 0x000000082d61941a in thr_kill () from /lib/libc.so.7 [01:09:52.734] [01:09:52.734] Thread 1 (LWP 100163): [01:09:52.734] #0 0x000000082d61941a in thr_kill () from /lib/libc.so.7 [01:09:52.734] No symbol table info available. [01:09:52.734] #1 0x000000082d592e64 in raise () from /lib/libc.so.7 [01:09:52.734] No symbol table info available. [01:09:52.734] #2 0x000000082d6436f9 in abort () from /lib/libc.so.7 [01:09:52.734] No symbol table info available. [01:09:52.734] #3 0x0000000000a57c55 in ExceptionalCondition (conditionName=0x2e5f8a "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=196) at ../src/backend/utils/error/assert.c:66 [01:09:52.734] No locals. [01:09:52.734] #4 0x000000000072e809 in standard_ExecutorStart (queryDesc=0x839900380, eflags=0) at ../src/backend/executor/execMain.c:196 [01:09:52.734] estate = 0x83f7ac100 [01:09:52.734] oldcontext = 0x83f73b800 [01:09:52.734] #5 0x000000083bc42872 in pgss_ExecutorStart (queryDesc=0x839900380, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:994 [01:09:52.734] No locals. [01:09:52.734] #6 0x00000000006c5595 in refresh_matview_datafill (dest=0x83982cf38, query=, queryString=0x0) at ../src/backend/commands/matview.c:429 [01:09:52.734] copied_query = [01:09:52.734] rewritten = [01:09:52.734] plan = [01:09:52.734] queryDesc = 0x839900380 [01:09:52.734] processed = [01:09:52.734] __error = [01:09:52.734] #7 RefreshMatViewByOid (matviewOid=26824, skipData=, concurrent=, queryString=0x0, params=, qc=0x0) at ../src/backend/commands/matview.c:321 [01:09:52.734] save_userid = 10 [01:09:52.734] save_sec_context = 0 [01:09:52.734] processed = 0 [01:09:52.734] matviewRel = 0x83f701150 [01:09:52.734] relowner = 10 [01:09:52.734] save_nestlevel = 2 [01:09:52.734] rule = [01:09:52.734] actions = [01:09:52.734] dataQuery = [01:09:52.734] tableSpace = [01:09:52.734] relpersistence = [01:09:52.734] OIDNewHeap = 26836 [01:09:52.734] dest = 0x83982cf38 [01:09:52.734] address = [01:09:52.734] #8 0x00000000006c51a4 in ExecRefreshMatView (stmt=, queryString=0x82d6193fa "\017\202x\341\377\377\303", '\314' , "̸\261\001", queryString@entry=0x0, params=params@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:09:52.734] lockmode = [01:09:52.734] matviewOid = 0 [01:09:52.734] #9 0x000000000069d0bf in ExecCreateTableAs (pstate=pstate@entry=0x83f73b900, stmt=stmt@entry=0x8397b7fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821122570) at ../src/backend/commands/createas.c:353 [01:09:52.734] refresh = 0x0 [01:09:52.734] query = 0x8398ade08 [01:09:52.734] into = 0x8397b7f40 [01:09:52.734] do_refresh = false [01:09:52.734] address = [01:09:52.734] dest = [01:09:52.734] rewritten = [01:09:52.734] plan = [01:09:52.734] queryDesc = [01:09:52.734] is_matview = [01:09:52.734] #10 0x0000000000906c6a in ProcessUtilitySlow (pstate=pstate@entry=0x83f73b900, pstmt=pstmt@entry=0x8397b7e30, queryString=queryString@entry=0x839725100 "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=0x821122570) at ../src/backend/tcop/utility.c:1675 [01:09:52.734] _local_sigjmp_buf = {{_sjb = {9462953, 0, 34914574296, 34914574672, 34914574304, 12130696, 0, 35424286976, 34914567039, 7, 34914574448, 0}}} [01:09:52.734] _save_exception_stack = 0x821122260 [01:09:52.734] _save_context_stack = 0x0 [01:09:52.734] _do_rethrow = false [01:09:52.734] validnsps = {0x371d32 "toast", 0x0} [01:09:52.734] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:09:52.734] parsetree = 0x8397b7fd0 [01:09:52.734] commandCollected = false [01:09:52.734] needCleanup = false [01:09:52.734] address = [01:09:52.734] isTopLevel = [01:09:52.734] isCompleteQuery = [01:09:52.734] #11 0x00000000009055f8 in standard_ProcessUtility (pstmt=0x8397b7e30, queryString=queryString@entry=0x839725100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8398ae5a8, qc=0x821122570) at ../src/backend/tcop/utility.c:1030 [01:09:52.734] isAtomicContext = false [01:09:52.734] parsetree = 0x8397b7fd0 [01:09:52.734] readonly_flags = [01:09:52.734] pstate = 0x83f73b900 [01:09:52.734] isTopLevel = [01:09:52.734] #12 0x000000083bc42dfd in pgss_ProcessUtility (pstmt=0x8397b7e30, queryString=0x839725100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8398ae5a8, qc=0x821122570) at ../contrib/pg_stat_statements/pg_stat_statements.c:1168 [01:09:52.734] _local_sigjmp_buf = {{_sjb = {35362450742, 34914574944, 34914574808, 34914575264, 35324132912, 0, 12130696, 34914575472, 34914567039, 34914575044, 34914575072, 0}}} [01:09:52.734] _save_exception_stack = 0x821122470 [01:09:52.734] _save_context_stack = 0x0 [01:09:52.734] _do_rethrow = false [01:09:52.734] bufusage = {shared_blks_hit = 35362450742, shared_blks_read = 34914574944, shared_blks_dirtied = 34914574808, shared_blks_written = 34914575264, local_blks_hit = 35324132912, local_blks_read = 0, local_blks_dirtied = 12130696, local_blks_written = 34914575472, temp_blks_read = 34914567039, temp_blks_written = 34914575044, shared_blk_read_time = {ticks = 34914575072}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4341185272583424128}, local_blk_write_time = {ticks = 12139736}, temp_blk_read_time = {ticks = 35374687744}, temp_blk_write_time = {ticks = 12094432}} [01:09:52.734] walusage_start = {wal_records = 8929, wal_fpi = 129, wal_bytes = 1265651} [01:09:52.734] duration = [01:09:52.734] bufusage_start = {shared_blks_hit = 150945, shared_blks_read = 7517, shared_blks_dirtied = 2456, shared_blks_written = 2296, local_blks_hit = 45, local_blks_read = 0, local_blks_dirtied = 10, local_blks_written = 17, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [01:09:52.734] walusage = {wal_records = 6725165997443310632, wal_fpi = 35324133328, wal_bytes = 123} [01:09:52.734] start = {ticks = -167435813060} [01:09:52.734] rows = [01:09:52.734] saved_queryId = 10350026774104024207 [01:09:52.734] parsetree = [01:09:52.734] saved_stmt_location = 0 [01:09:52.734] saved_stmt_len = 69 [01:09:52.734] enabled = [01:09:52.734] #13 0x0000000000904bc3 in PortalRunUtility (portal=0x8397c2100, pstmt=0x8397b7e30, isTopLevel=, setHoldSnapshot=, dest=0x8398ae5a8, qc=0x821122570) at ../src/backend/tcop/pquery.c:1158 [01:09:52.734] No locals. [01:09:52.734] #14 0x0000000000904254 in PortalRunMulti (portal=portal@entry=0x8397c2100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8398ae5a8, altdest=altdest@entry=0x8398ae5a8, qc=0x821122570) at ../src/backend/tcop/pquery.c:1322 [01:09:52.734] pstmt = 0x8397b7e30 [01:09:52.734] stmtlist_item__state = {l = 0x8398ae558, i = 0} [01:09:52.734] active_snapshot_set = false [01:09:52.734] stmtlist_item = 0x8398ae570 [01:09:52.734] #15 0x0000000000903b23 in PortalRun (portal=portal@entry=0x8397c2100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8398ae5a8, altdest=altdest@entry=0x8398ae5a8, qc=0x821122570) at ../src/backend/tcop/pquery.c:791 [01:09:52.734] _local_sigjmp_buf = {{_sjb = {9452189, 35324174592, 34914575464, 34914575696, 34914575472, 35324485632, 12098480, 12130696, 35324167039, 35324126688, 4294967984, 0}}} [01:09:52.734] _save_exception_stack = 0x821122640 [01:09:52.734] _save_context_stack = 0x0 [01:09:52.734] _do_rethrow = false [01:09:52.734] saveTopTransactionResourceOwner = 0x839813958 [01:09:52.734] saveTopTransactionContext = 0x83980e000 [01:09:52.734] saveActivePortal = 0x0 [01:09:52.734] saveResourceOwner = 0x839813958 [01:09:52.734] savePortalContext = 0x0 [01:09:52.734] saveMemoryContext = 0x83980e000 [01:09:52.734] result = [01:09:52.734] nprocessed = [01:09:52.734] #16 0x00000000009029c2 in exec_simple_query (query_string=query_string@entry=0x839725100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1274 [01:09:52.734] cmdtaglen = 24 [01:09:52.734] snapshot_set = [01:09:52.734] per_parsetree_context = 0x0 [01:09:52.734] plantree_list = [01:09:52.734] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:09:52.734] format = 0 [01:09:52.734] parsetree = 0x8397266a8 [01:09:52.734] commandTag = [01:09:52.734] cmdtagname = [01:09:52.734] querytree_list = [01:09:52.734] portal = 0x8397c2100 [01:09:52.734] receiver = 0x8398ae5a8 [01:09:52.734] parsetree_item__state = {l = 0x839726a18, i = 0} [01:09:52.734] msec_str = "\000\000\000\000\b", '\000' , "XH\244f\000\000\000\000\310\346Msop\327\177" [01:09:52.734] dest = DestRemote [01:09:52.734] was_logged = [01:09:52.734] oldcontext = 0x83980e000 [01:09:52.734] parsetree_list = 0x839726a18 [01:09:52.734] use_implicit_block = false [01:09:52.734] parsetree_item = 0x839726a30 [01:09:52.734] save_log_statement_stats = [01:09:52.734] #17 0x0000000000900770 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4675 [01:09:52.734] query_string = 0x839725100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:09:52.734] input_message = {data = 0x839725100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:09:52.734] firstchar = [01:09:52.734] local_sigjmp_buf = {{_sjb = {9436246, 34914575936, 34914575896, 34914576480, 12139432, 11982416, 8192, 8388608, 895, 0, 0, 34359738369}}} [01:09:52.734] send_ready_for_query = false [01:09:52.734] idle_in_transaction_timeout_enabled = false [01:09:52.734] idle_session_timeout_enabled = false [01:09:52.734] #18 0x00000000008fb219 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:106 [01:09:52.734] bsdata = [01:09:52.734] #19 0x00000000008556a2 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821123364 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211232b0) at ../src/backend/postmaster/launch_backend.c:269 [01:09:52.734] pid = [01:09:52.734] #20 0x0000000000859fe0 in BackendStartup (client_sock=0x8211232b0) at ../src/backend/postmaster/postmaster.c:3593 [01:09:52.734] startup_data = {canAcceptConnections = CAC_OK} [01:09:52.734] bn = 0x839731088 [01:09:52.734] pid = [01:09:52.734] __error = [01:09:52.734] __error = [01:09:52.734] save_errno = [01:09:52.734] __error = [01:09:52.734] __error = [01:09:52.734] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [01:09:52.734] 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 = "\v\000\000\000\000\000\000\000\0003\022!\b\000\000\000h\225j,\b", '\000' , "^\037k,\b", '\000' , "@3\022!\b\000\000\000tT\205\000\000\000\000\000BH\244f", '\000' }, salen = 16}} [01:09:52.734] i = 0 [01:09:52.734] now = [01:09:52.734] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 760119656, events = 8, fd = 554838888, user_data = 0x821122ab0}, {pos = 554838288, events = 8, fd = 1, user_data = 0x8213bb408}, {pos = 33, events = 0, fd = 554838688, user_data = 0xcb4c4af6a1a}, {pos = 557531144, events = 8, fd = 557532168, user_data = 0x8213b4808}, {pos = 557534216, events = 8, fd = 557547528, user_data = 0x8213b8408}, {pos = 557549576, events = 8, fd = 557550600, user_data = 0x8213b9008}, {pos = 557552648, events = 8, fd = 557553672, user_data = 0x8213b9c08}, {pos = 557555720, events = 8, fd = 557556744, user_data = 0x8213ba808}, {pos = 557558792, events = 8, fd = 557559816, user_data = 0x8213bb408}, {pos = -25761258, events = 0, fd = 557584440, user_data = 0x800000001}, {pos = 557560840, events = 8, fd = 760140920, user_data = 0x821122ce8}, {pos = 15, events = 0, fd = 554839088, user_data = 0x821122a90}, {pos = 1, events = 0, fd = 554839016, user_data = 0x21}, {pos = 554838656, events = 8, fd = -995112333, user_data = 0x821122a60}, {pos = 2571534, events = 0, fd = 557560840, user_data = 0x82d507ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x8213c1a38}, {pos = 1, events = 8, fd = 557560840, user_data = 0x82d4e8168}, {pos = 554838888, events = 8, fd = 554838288, user_data = 0x1200000021}, {pos = 0, events = 0, fd = 557587000, user_data = 0x1}, {pos = 557560840, events = 8, fd = 839, user_data = 0x821122b50}, {pos = -995138065, events = 3252, fd = 760249027, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 557587000, user_data = 0x1}, {pos = 557560840, events = 8, fd = 963727360, user_data = 0x1}, {pos = 963727764, events = 8, fd = 0, user_data = 0x821122b20}, {pos = 745215340, events = 8, fd = 1, user_data = 0x839715000}, {pos = 554838864, events = 8, fd = 745211650, user_data = 0x82d6a8950 }, {pos = 762044792, events = 8, fd = 761956688, user_data = 0x8213bb408}, {pos = 554839088, events = 8, fd = -995138594, user_data = 0x821122df8}, {pos = 1, events = 8, fd = -995138978, user_data = 0x8213bb408}, {pos = 554838872, events = 8, fd = 554839088, user_data = 0x2fe8}, {pos = 0, events = 0, fd = -995059312, user_data = 0x8211231a0}, {pos = 115213183, events = 0, fd = -25761258, user_data = 0x5d5496d7dd24e428}, {pos = 0, events = 8, fd = 557560840, user_data = 0x2fe8}, {pos = 760098816, events = 8, fd = 1945976, user_data = 0x82d6a8950 }, {pos = 760233336, events = 8, fd = 15691, user_data = 0x82d6cc6a0 <__stack_chk_guard>}, {pos = 554839200, events = 8, fd = 760903957, user_data = 0x82d6b1e38}, {pos = 554839136, events = 8, fd = 554840272, user_data = 0x0}, {pos = 554839200, events = 8, fd = 760994657, user_data = 0x1}, {pos = 554840272, events = 8, fd = 554840272, user_data = 0x100000000000000}, {pos = -584784856, events = 1565824727, fd = 762103456, user_data = 0x83977e5d8}, {pos = 0, events = 0, fd = 761994808, user_data = 0x8211231a0}, {pos = 554840336, events = 8, fd = 760994946, user_data = 0x0}, {pos = 554840640, events = 8, fd = 964158936, user_data = 0x8211230d0}, {pos = 0, events = 0, fd = -995110134, user_data = 0x82d4f27a0}, {pos = 760233336, events = 8, fd = 554839368, user_data = 0x821122dc0}, {pos = 554839368, events = 8, fd = -995110134, user_data = 0x82d4ed388}, {pos = 760233336, events = 8, fd = 554839416, user_data = 0x821122df0}, {pos = 554839416, events = 8, fd = 760201620, user_data = 0x8213bb408}, {pos = 760201620, events = 8, fd = 554839520, user_data = 0xcb4c4af843a}, {pos = 554839424, events = 8, fd = 745174032, user_data = 0x82d6b9030 <__thr_jtable>}, {pos = 760140680, events = 8, fd = 0, user_data = 0xcb4c4afd30a}, {pos = 760109144, events = 8, fd = 760233336, user_data = 0x821122df8}, {pos = 554839664, events = 8, fd = 554839544, user_data = 0x82d4fad0c}, {pos = 557560840, events = 8, fd = 760196364, user_data = 0x821122e60}, {pos = -995130310, events = 3252, fd = 554839648, user_data = 0xcb4c4afcca2}, {pos = 2675240, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 1, user_data = 0x8213bb408}, {pos = 760140680, events = 8, fd = 554840392, user_data = 0x21122eb0}, {pos = 557582280, events = 8, fd = 0, user_data = 0x0}, {pos = 554839800, events = 8, fd = 554840264, user_data = 0x821122ee0}, {pos = -995111774, events = 3252, fd = 2698906, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 557584440, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x8211231c8}} [01:09:52.734] last_touch_time = 1722042434 [01:09:52.734] last_lockfile_recheck_time = 1722042434 [01:09:52.734] nevents = 1 [01:09:52.734] #22 0x0000000000857885 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8211238a8) at ../src/backend/postmaster/postmaster.c:1372 [01:09:52.734] userDoption = [01:09:52.734] listen_addr_saved = [01:09:52.734] output_config_variable = [01:09:52.734] opt = [01:09:52.734] status = [01:09:52.734] #23 0x000000000079184c in main (argc=4, argv=0x8211238a8) at ../src/backend/main/main.c:197 [01:09:52.734] do_check_root =