[22:23:37.836] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [22:23:38.148] dumping /tmp/cores/postgres.10876.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:23:38.275] [New LWP 101911] [22:23:38.353] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [22:23:38.353] Program terminated with signal SIGABRT, Aborted. [22:23:38.353] Sent by thr_kill() from pid 10876 and user 1003. [22:23:38.353] #0 0x000000082c62241a in thr_kill () from /lib/libc.so.7 [22:23:38.407] [22:23:38.407] Thread 1 (LWP 101911): [22:23:38.407] #0 0x000000082c62241a in thr_kill () from /lib/libc.so.7 [22:23:38.407] No symbol table info available. [22:23:38.407] #1 0x000000082c59be64 in raise () from /lib/libc.so.7 [22:23:38.407] No symbol table info available. [22:23:38.407] #2 0x000000082c64c6f9 in abort () from /lib/libc.so.7 [22:23:38.407] No symbol table info available. [22:23:38.407] #3 0x0000000000aa0335 in ExceptionalCondition (conditionName=0x2ed1f3 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:23:38.407] No locals. [22:23:38.407] #4 0x00000000007686e9 in standard_ExecutorStart (queryDesc=0x83569abd0, eflags=0) at ../src/backend/executor/execMain.c:193 [22:23:38.407] estate = 0x842509100 [22:23:38.407] oldcontext = 0x835616800 [22:23:38.407] #5 0x00000000006fcc9f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [22:23:38.407] copied_query = [22:23:38.407] rewritten = [22:23:38.407] plan = 0x83569a778 [22:23:38.407] queryDesc = 0x83569abd0 [22:23:38.407] processed = [22:23:38.407] __error = [22:23:38.407] #6 RefreshMatViewByOid (matviewOid=28228, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [22:23:38.407] dest = [22:23:38.407] save_userid = 10 [22:23:38.407] save_sec_context = 0 [22:23:38.407] processed = 0 [22:23:38.407] matviewRel = 0x8425c9018 [22:23:38.407] relowner = 10 [22:23:38.407] save_nestlevel = 2 [22:23:38.407] rule = [22:23:38.407] actions = [22:23:38.407] dataQuery = [22:23:38.407] tableSpace = [22:23:38.407] relpersistence = [22:23:38.407] OIDNewHeap = 28235 [22:23:38.407] address = [22:23:38.407] #7 0x00000000006fc876 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:23:38.407] lockmode = [22:23:38.407] matviewOid = 0 [22:23:38.407] #8 0x00000000006d386c in ExecCreateTableAs (pstate=pstate@entry=0x835616900, stmt=stmt@entry=0x8355dbfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8210a67e0) at ../src/backend/commands/createas.c:351 [22:23:38.407] refresh = 0x0 [22:23:38.407] query = 0x842511c98 [22:23:38.407] into = 0x842511fe0 [22:23:38.407] jstate = 0x0 [22:23:38.407] do_refresh = false [22:23:38.407] address = [22:23:38.407] dest = [22:23:38.407] is_matview = [22:23:38.407] #9 0x0000000000948b0b in ProcessUtilitySlow (pstate=pstate@entry=0x835616900, pstmt=pstmt@entry=0x83551da68, queryString=queryString@entry=0x83551c100 "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=0x8210a67e0) at ../src/backend/tcop/utility.c:1678 [22:23:38.407] _local_sigjmp_buf = {{_sjb = {9732921, 0, 34914067464, 34914067840, 34914067472, 12527240, 0, 35255314688, 12452735, 1, 4294967295, 34359738368}}} [22:23:38.407] _save_exception_stack = 0x8210a66e0 [22:23:38.407] _save_context_stack = 0x0 [22:23:38.407] _do_rethrow = false [22:23:38.407] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:23:38.407] parsetree = 0x8355dbfd0 [22:23:38.407] commandCollected = false [22:23:38.407] needCleanup = false [22:23:38.407] address = [22:23:38.407] isTopLevel = [22:23:38.407] isCompleteQuery = [22:23:38.407] #10 0x0000000000947488 in standard_ProcessUtility (pstmt=0x83551da68, queryString=0x83551c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8425124c8, qc=0x8210a67e0) at ../src/backend/tcop/utility.c:1033 [22:23:38.407] isAtomicContext = false [22:23:38.407] parsetree = 0x8355dbfd0 [22:23:38.407] readonly_flags = [22:23:38.407] pstate = 0x835616900 [22:23:38.407] isTopLevel = [22:23:38.407] #11 0x0000000000946f18 in ProcessUtility (pstmt=0x18e17, queryString=0x6 , readOnlyTree=, context=744629242, params=0x0, queryEnv=0x0, dest=0x8425124c8, qc=0x8210a67e0) at ../src/backend/tcop/utility.c:523 [22:23:38.407] No locals. [22:23:38.407] #12 0x0000000000946a53 in PortalRunUtility (portal=0x8355f3100, pstmt=0x83551da68, isTopLevel=, setHoldSnapshot=, dest=0x8425124c8, qc=0x8210a67e0) at ../src/backend/tcop/pquery.c:1152 [22:23:38.407] No locals. [22:23:38.407] #13 0x0000000000946114 in PortalRunMulti (portal=portal@entry=0x8355f3100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8425124c8, altdest=altdest@entry=0x8425124c8, qc=qc@entry=0x8210a67e0) at ../src/backend/tcop/pquery.c:1316 [22:23:38.407] pstmt = 0x83551da68 [22:23:38.407] stmtlist_item__state = {l = 0x842512478, i = 0} [22:23:38.407] active_snapshot_set = false [22:23:38.407] stmtlist_item = 0x842512490 [22:23:38.407] #14 0x00000000009459fb in PortalRun (portal=portal@entry=0x8355f3100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8425124c8, altdest=altdest@entry=0x8425124c8, qc=qc@entry=0x8210a67e0) at ../src/backend/tcop/pquery.c:787 [22:23:38.407] _local_sigjmp_buf = {{_sjb = {9722229, 35255169280, 34914068184, 34914068432, 34914068192, 12527240, 34914068448, 12483208, 12452735, 0, 35255157631, 34359738368}}} [22:23:38.407] _save_exception_stack = 0x8210a6890 [22:23:38.407] _save_context_stack = 0x0 [22:23:38.407] _do_rethrow = false [22:23:38.407] saveTopTransactionResourceOwner = 0x835602188 [22:23:38.407] saveTopTransactionContext = 0x8355f7000 [22:23:38.407] saveActivePortal = 0x0 [22:23:38.407] saveResourceOwner = 0x835602188 [22:23:38.407] savePortalContext = 0x0 [22:23:38.407] saveMemoryContext = 0x8355f7000 [22:23:38.407] result = [22:23:38.407] nprocessed = [22:23:38.407] #15 0x0000000000944889 in exec_simple_query (query_string=query_string@entry=0x83551c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:23:38.407] cmdtaglen = 24 [22:23:38.407] snapshot_set = [22:23:38.407] per_parsetree_context = 0x0 [22:23:38.407] plantree_list = [22:23:38.407] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:23:38.407] format = 0 [22:23:38.407] parsetree = 0x83551d6a8 [22:23:38.407] commandTag = [22:23:38.407] cmdtagname = [22:23:38.407] querytree_list = [22:23:38.407] portal = 0x8355f3100 [22:23:38.407] receiver = 0x8425124c8 [22:23:38.407] parsetree_item__state = {l = 0x83551da18, i = 0} [22:23:38.407] msec_str = "\000\000\000\000\b", '\000' , "\036z\215g\000\000\000\000Z]~\a\304", [22:23:38.407] dest = DestRemote [22:23:38.407] was_logged = [22:23:38.407] oldcontext = 0x8355f7000 [22:23:38.407] parsetree_list = 0x83551da18 [22:23:38.407] use_implicit_block = false [22:23:38.407] parsetree_item = 0x83551da30 [22:23:38.407] save_log_statement_stats = [22:23:38.407] #16 0x00000000009424f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [22:23:38.407] query_string = 0x83551c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:23:38.407] input_message = {data = 0x83551c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:23:38.407] firstchar = [22:23:38.407] local_sigjmp_buf = {{_sjb = {9705894, 34914068624, 34914068616, 34914069168, 12535992, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [22:23:38.407] send_ready_for_query = false [22:23:38.407] idle_in_transaction_timeout_enabled = false [22:23:38.407] idle_session_timeout_enabled = false [22:23:38.407] #17 0x000000000093ce99 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:23:38.407] bsdata = [22:23:38.407] #18 0x00000000008941d5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x8210a75c0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8210a7510) at ../src/backend/postmaster/launch_backend.c:274 [22:23:38.407] pid = [22:23:38.407] #19 0x0000000000898726 in BackendStartup (client_sock=0x8210a7510) at ../src/backend/postmaster/postmaster.c:3466 [22:23:38.407] startup_data = {canAcceptConnections = CAC_OK} [22:23:38.407] bn = 0x8355bf0c8 [22:23:38.407] cac = CAC_OK [22:23:38.407] pid = [22:23:38.407] __error = [22:23:38.407] save_errno = [22:23:38.407] __error = [22:23:38.407] __error = [22:23:38.407] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:23:38.407] 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' , "pu\n!\b\000\000\000h\225\026+\b\000\000\000\372\000\000\000\000\000\000\000^\037\027+\b", '\000' , "\260u\n!\b\000\000\000d?\211\000\000\000\000\000\300u\n!\b", '\000' }, salen = 16}} [22:23:38.407] i = 0 [22:23:38.407] now = [22:23:38.407] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 744254594, events = 8, fd = 0, user_data = 0x8210a74c0}, {pos = 894928344, events = 8, fd = 554333008, user_data = 0x8210a70b0}, {pos = 8192, events = 0, fd = 8192, user_data = 0x8355eb000}, {pos = 554332344, events = 8, fd = 0, user_data = 0x8345ed090}, {pos = 1, events = 0, fd = 554332144, user_data = 0x82c6919c9}, {pos = 743400328, events = 8, fd = 743492984, user_data = 0x8210a7008}, {pos = 554332288, events = 8, fd = 554332336, user_data = 0x8210a70a8}, {pos = 878629008, events = 8, fd = 891292032, user_data = 0x20}, {pos = 4096, events = 0, fd = 554332784, user_data = 0x82c68ca7c}, {pos = 554332328, events = 8, fd = 40887050, user_data = 0x82c4ee858}, {pos = 743492984, events = 8, fd = 554332280, user_data = 0x8210a70f0}, {pos = 554332280, events = 8, fd = 743456012, user_data = 0x821e39408}, {pos = 743456012, events = 8, fd = 554332384, user_data = 0xf7026f943a}, {pos = 878629056, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 891302456, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821e3e288}, {pos = 743368792, events = 8, fd = 568562696, user_data = 0x8210a7178}, {pos = 554332984, events = 8, fd = 554332512, user_data = 0xf7026fdca2}, {pos = 2721811, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 568586296, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554333240, user_data = 0x21e39408}, {pos = 554333056, events = 8, fd = 554332656, user_data = 0x1}, {pos = 554332984, events = 8, fd = 32, user_data = 0x8210a71e0}, {pos = 40884851, events = 247, fd = 554332928, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821e3f038}, {pos = 1, events = 8, fd = 568562696, user_data = 0x82c4ee858}, {pos = 554333240, events = 8, fd = 554333056, user_data = 0x8210a71f0}, {pos = 0, events = 0, fd = 568533000, user_data = 0x20}, {pos = 554333040, events = 8, fd = 40860391, user_data = 0x821e32008}, {pos = 568534024, events = 8, fd = 568535048, user_data = 0x821e32c08}, {pos = 568549384, events = 8, fd = 568550408, user_data = 0x821e36808}, {pos = 568552456, events = 8, fd = 568553480, user_data = 0x821e37408}, {pos = 568555528, events = 8, fd = 568556552, user_data = 0x821e38008}, {pos = 568558600, events = 8, fd = 568559624, user_data = 0x821e38c08}, {pos = 568561672, events = 8, fd = 568562696, user_data = 0x821e39808}, {pos = 568564744, events = 8, fd = 568565768, user_data = 0x821e3a408}, {pos = 568567816, events = 8, fd = 568568840, user_data = 0x821e3b008}, {pos = 568570888, events = 8, fd = 568571912, user_data = 0x821e3bc08}, {pos = 568578056, events = 8, fd = 568579080, user_data = 0x821e3d808}, {pos = 568581128, events = 8, fd = 568533000, user_data = 0x298813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821e3f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554333240, events = 8, fd = 554332656, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 568586296, user_data = 0x1}, {pos = 568533000, events = 8, fd = 298, user_data = 0x8210a7420}, {pos = 40859119, events = 247, fd = 2721811, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 568586296, user_data = 0x1}, {pos = 568562696, events = 8, fd = 894484480, user_data = 0x1}, {pos = 894484884, events = 8, fd = 0, user_data = 0x8210a73f0}, {pos = 722933100, events = 8, fd = 1, user_data = 0x83550c000}, {pos = 554333216, events = 8, fd = 722929410, user_data = 0x82c620170 }, {pos = 12445616, events = 0, fd = 744620400, user_data = 0x821e39408}, {pos = 554333440, events = 8, fd = 40858590, user_data = 0x83552a800}, {pos = 1, events = 8, fd = 40858206, user_data = 0x821e32008}, {pos = 554333224, events = 8, fd = 554333440, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 40937872, user_data = 0x0}, {pos = 554304383, events = 8, fd = 8127943, user_data = 0x8210a74b0}, {pos = 722891792, events = 8, fd = 745283632, user_data = 0x82c6c4310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8210a74e0}, {pos = 722934685, events = 8, fd = 894484480, user_data = 0x1df2}, {pos = 554333504, events = 8, fd = 722901242, user_data = 0x0}, {pos = 0, events = 0, fd = -1718428330, user_data = 0x0}} [22:23:38.407] last_touch_time = 1737325064 [22:23:38.407] last_lockfile_recheck_time = 1737325064 [22:23:38.407] nevents = 1 [22:23:38.407] #21 0x00000000008969b4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8210a7b38) at ../src/backend/postmaster/postmaster.c:1377 [22:23:38.407] userDoption = [22:23:38.407] listen_addr_saved = false [22:23:38.407] output_config_variable = [22:23:38.407] opt = [22:23:38.407] status = [22:23:38.407] #22 0x00000000007cd2a0 in main (argc=8, argv=0x8210a7b38) at ../src/backend/main/main.c:230 [22:23:38.407] do_check_root = [22:23:38.407] dispatch_option = DISPATCH_POSTMASTER [22:23:38.416] [22:23:38.416] [22:23:38.416] [22:23:38.473] dumping /tmp/cores/postgres.11380.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:23:38.593] [New LWP 101890] [22:23:38.655] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [22:23:38.655] Program terminated with signal SIGABRT, Aborted. [22:23:38.655] Sent by thr_kill() from pid 11380 and user 1003. [22:23:38.655] #0 0x000000082ad0f41a in thr_kill () from /lib/libc.so.7 [22:23:38.689] [22:23:38.689] Thread 1 (LWP 101890): [22:23:38.689] #0 0x000000082ad0f41a in thr_kill () from /lib/libc.so.7 [22:23:38.689] No symbol table info available. [22:23:38.689] #1 0x000000082ac88e64 in raise () from /lib/libc.so.7 [22:23:38.689] No symbol table info available. [22:23:38.689] #2 0x000000082ad396f9 in abort () from /lib/libc.so.7 [22:23:38.689] No symbol table info available. [22:23:38.689] #3 0x0000000000aa0335 in ExceptionalCondition (conditionName=0x2ed1f3 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:23:38.689] No locals. [22:23:38.689] #4 0x00000000007686e9 in standard_ExecutorStart (queryDesc=0x8340a0bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [22:23:38.689] estate = 0x8340da100 [22:23:38.689] oldcontext = 0x833fdc800 [22:23:38.689] #5 0x00000000006fcc9f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [22:23:38.689] copied_query = [22:23:38.689] rewritten = [22:23:38.689] plan = 0x8340a0778 [22:23:38.689] queryDesc = 0x8340a0bd0 [22:23:38.689] processed = [22:23:38.689] __error = [22:23:38.689] #6 RefreshMatViewByOid (matviewOid=28417, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [22:23:38.689] dest = [22:23:38.689] save_userid = 10 [22:23:38.689] save_sec_context = 0 [22:23:38.689] processed = 0 [22:23:38.689] matviewRel = 0x84076ff18 [22:23:38.689] relowner = 10 [22:23:38.689] save_nestlevel = 2 [22:23:38.689] rule = [22:23:38.689] actions = [22:23:38.689] dataQuery = [22:23:38.689] tableSpace = [22:23:38.689] relpersistence = [22:23:38.689] OIDNewHeap = 28424 [22:23:38.689] address = [22:23:38.689] #7 0x00000000006fc876 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:23:38.689] lockmode = [22:23:38.689] matviewOid = 0 [22:23:38.689] #8 0x00000000006d386c in ExecCreateTableAs (pstate=pstate@entry=0x833fdc900, stmt=stmt@entry=0x8340a5fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820cddeb0) at ../src/backend/commands/createas.c:351 [22:23:38.689] refresh = 0x0 [22:23:38.689] query = 0x833ff2518 [22:23:38.689] into = 0x833ff2860 [22:23:38.689] jstate = 0x0 [22:23:38.689] do_refresh = false [22:23:38.689] address = [22:23:38.689] dest = [22:23:38.689] is_matview = [22:23:38.689] #9 0x0000000000948b0b in ProcessUtilitySlow (pstate=pstate@entry=0x833fdc900, pstmt=pstmt@entry=0x833f0ba68, queryString=queryString@entry=0x833f0a100 "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=0x820cddeb0) at ../src/backend/tcop/utility.c:1678 [22:23:38.689] _local_sigjmp_buf = {{_sjb = {9732921, 0, 34910100184, 34910100560, 34910100192, 12527240, 0, 35232008448, 12452735, 1, 4294967295, 34359738368}}} [22:23:38.689] _save_exception_stack = 0x820cdddb0 [22:23:38.689] _save_context_stack = 0x0 [22:23:38.689] _do_rethrow = false [22:23:38.689] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:23:38.689] parsetree = 0x8340a5fd0 [22:23:38.689] commandCollected = false [22:23:38.689] needCleanup = false [22:23:38.689] address = [22:23:38.689] isTopLevel = [22:23:38.689] isCompleteQuery = [22:23:38.689] #10 0x0000000000947488 in standard_ProcessUtility (pstmt=0x833f0ba68, queryString=0x833f0a100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x833ff2d48, qc=0x820cddeb0) at ../src/backend/tcop/utility.c:1033 [22:23:38.689] isAtomicContext = false [22:23:38.689] parsetree = 0x8340a5fd0 [22:23:38.689] readonly_flags = [22:23:38.689] pstate = 0x833fdc900 [22:23:38.689] isTopLevel = [22:23:38.689] #11 0x0000000000946f18 in ProcessUtility (pstmt=0x18e02, queryString=0x6 , readOnlyTree=, context=718337018, params=0x0, queryEnv=0x0, dest=0x833ff2d48, qc=0x820cddeb0) at ../src/backend/tcop/utility.c:523 [22:23:38.689] No locals. [22:23:38.689] #12 0x0000000000946a53 in PortalRunUtility (portal=0x833fb0100, pstmt=0x833f0ba68, isTopLevel=, setHoldSnapshot=, dest=0x833ff2d48, qc=0x820cddeb0) at ../src/backend/tcop/pquery.c:1152 [22:23:38.689] No locals. [22:23:38.689] #13 0x0000000000946114 in PortalRunMulti (portal=portal@entry=0x833fb0100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x833ff2d48, altdest=altdest@entry=0x833ff2d48, qc=qc@entry=0x820cddeb0) at ../src/backend/tcop/pquery.c:1316 [22:23:38.689] pstmt = 0x833f0ba68 [22:23:38.689] stmtlist_item__state = {l = 0x833ff2cf8, i = 0} [22:23:38.689] active_snapshot_set = false [22:23:38.689] stmtlist_item = 0x833ff2d10 [22:23:38.689] #14 0x00000000009459fb in PortalRun (portal=portal@entry=0x833fb0100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x833ff2d48, altdest=altdest@entry=0x833ff2d48, qc=qc@entry=0x820cddeb0) at ../src/backend/tcop/pquery.c:787 [22:23:38.689] _local_sigjmp_buf = {{_sjb = {9722229, 35231826176, 34910100904, 34910101152, 34910100912, 12527240, 34910101168, 12483208, 12452735, 0, 35231826815, 34359738368}}} [22:23:38.689] _save_exception_stack = 0x820cddf60 [22:23:38.689] _save_context_stack = 0x0 [22:23:38.689] _do_rethrow = false [22:23:38.689] saveTopTransactionResourceOwner = 0x833fff118 [22:23:38.689] saveTopTransactionContext = 0x833fb4000 [22:23:38.689] saveActivePortal = 0x0 [22:23:38.689] saveResourceOwner = 0x833fff118 [22:23:38.689] savePortalContext = 0x0 [22:23:38.689] saveMemoryContext = 0x833fb4000 [22:23:38.689] result = [22:23:38.689] nprocessed = [22:23:38.689] #15 0x0000000000944889 in exec_simple_query (query_string=query_string@entry=0x833f0a100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:23:38.689] cmdtaglen = 24 [22:23:38.689] snapshot_set = [22:23:38.689] per_parsetree_context = 0x0 [22:23:38.689] plantree_list = [22:23:38.689] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:23:38.689] format = 0 [22:23:38.689] parsetree = 0x833f0b6a8 [22:23:38.689] commandTag = [22:23:38.689] cmdtagname = [22:23:38.689] querytree_list = [22:23:38.689] portal = 0x833fb0100 [22:23:38.689] receiver = 0x833ff2d48 [22:23:38.689] parsetree_item__state = {l = 0x833f0ba18, i = 0} [22:23:38.689] msec_str = "\000\000\000\000\b", '\000' , "\"z\215g\000\000\000\000\352\2041\243\361", [22:23:38.689] dest = DestRemote [22:23:38.689] was_logged = [22:23:38.689] oldcontext = 0x833fb4000 [22:23:38.689] parsetree_list = 0x833f0ba18 [22:23:38.689] use_implicit_block = false [22:23:38.689] parsetree_item = 0x833f0ba30 [22:23:38.689] save_log_statement_stats = [22:23:38.689] #16 0x00000000009424f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [22:23:38.689] query_string = 0x833f0a100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:23:38.689] input_message = {data = 0x833f0a100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:23:38.689] firstchar = [22:23:38.689] local_sigjmp_buf = {{_sjb = {9705894, 34910101344, 34910101336, 34910101888, 12535992, 1, 8192, 8388608, 34910045055, 0, 0, 1}}} [22:23:38.689] send_ready_for_query = false [22:23:38.689] idle_in_transaction_timeout_enabled = false [22:23:38.689] idle_session_timeout_enabled = false [22:23:38.689] #17 0x000000000093ce99 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:23:38.689] bsdata = [22:23:38.689] #18 0x00000000008941d5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x820cdec90 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820cdebe0) at ../src/backend/postmaster/launch_backend.c:274 [22:23:38.689] pid = [22:23:38.689] #19 0x0000000000898726 in BackendStartup (client_sock=0x820cdebe0) at ../src/backend/postmaster/postmaster.c:3466 [22:23:38.689] startup_data = {canAcceptConnections = CAC_OK} [22:23:38.689] bn = 0x833fce038 [22:23:38.689] cac = CAC_OK [22:23:38.689] pid = [22:23:38.689] __error = [22:23:38.689] save_errno = [22:23:38.689] __error = [22:23:38.689] __error = [22:23:38.689] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:23:38.689] 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' , "@\354\315 \b\000\000\000hU\322)\b\000\000\000\346\000\000\000\000\000\000\000^\337\322)\b", '\000' , "\200\354\315 \b\000\000\000d?\211\000\000\000\000\000\220\354\315 \b", '\000' }, salen = 16}} [22:23:38.689] i = 0 [22:23:38.689] now = [22:23:38.689] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 717962370, events = 8, fd = 0, user_data = 0x820cdeb90}, {pos = 871843288, events = 8, fd = 550365728, user_data = 0x0}, {pos = 0, events = 0, fd = 2057662425, user_data = 0x3b257e03430a}, {pos = 717129632, events = 8, fd = 717200760, user_data = 0x820cde6a8}, {pos = 550364960, events = 8, fd = 550364840, user_data = 0x3b257e03430a}, {pos = 717108104, events = 8, fd = 717200760, user_data = 0x820cde6d8}, {pos = 550365008, events = 8, fd = 550364888, user_data = 0x82abf2194}, {pos = 555271176, events = 8, fd = 717169044, user_data = 0x820cde740}, {pos = 2114122810, events = 15141, fd = 718991408, user_data = 0x1}, {pos = 550365040, events = 8, fd = 2114142986, user_data = 0x82abdb858}, {pos = 717200760, events = 8, fd = 550365000, user_data = 0x820cde7c0}, {pos = 550365000, events = 8, fd = 717163788, user_data = 0x82118c408}, {pos = 717163788, events = 8, fd = 550365104, user_data = 0x3b257e02f43a}, {pos = 550365144, events = 8, fd = 550365592, user_data = 0x820cde7c0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 260670901, fd = 555294776, user_data = 0x800000001}, {pos = 555271176, events = 8, fd = 717108104, user_data = 0x821191288}, {pos = 717076568, events = 8, fd = 555271176, user_data = 0x820cde848}, {pos = 550365704, events = 8, fd = 550365232, user_data = 0x3b257e033ca2}, {pos = 2721811, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 555294776, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550365960, user_data = 0x2118c408}, {pos = 550365776, events = 8, fd = 550365376, user_data = 0x1}, {pos = 550365704, events = 8, fd = 32, user_data = 0x820cde8b0}, {pos = 2114140787, events = 15141, fd = 550365648, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821192038}, {pos = 1, events = 8, fd = 555271176, user_data = 0x82abdb858}, {pos = 550365960, events = 8, fd = 550365776, user_data = 0x820cde8c0}, {pos = 0, events = 0, fd = 555241480, user_data = 0x20}, {pos = 550365760, events = 8, fd = 2114116327, user_data = 0x821185008}, {pos = 555242504, events = 8, fd = 555243528, user_data = 0x821185c08}, {pos = 555257864, events = 8, fd = 555258888, user_data = 0x821189808}, {pos = 555260936, events = 8, fd = 555261960, user_data = 0x82118a408}, {pos = 555264008, events = 8, fd = 555265032, user_data = 0x82118b008}, {pos = 555267080, events = 8, fd = 555268104, user_data = 0x82118bc08}, {pos = 555270152, events = 8, fd = 555271176, user_data = 0x82118c808}, {pos = 555273224, events = 8, fd = 555274248, user_data = 0x82118d408}, {pos = 555276296, events = 8, fd = 555277320, user_data = 0x82118e008}, {pos = 555279368, events = 8, fd = 555280392, user_data = 0x82118ec08}, {pos = 555286536, events = 8, fd = 555287560, user_data = 0x821190808}, {pos = 555289608, events = 8, fd = 555241480, user_data = 0x298813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821192038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550365960, events = 8, fd = 550365376, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 555294776, user_data = 0x1}, {pos = 555241480, events = 8, fd = 298, user_data = 0x820cdeaf0}, {pos = 2114115055, events = 15141, fd = 2721811, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 555294776, user_data = 0x1}, {pos = 555271176, events = 8, fd = 871342080, user_data = 0x1}, {pos = 871342484, events = 8, fd = 0, user_data = 0x820cdeac0}, {pos = 701683052, events = 8, fd = 1, user_data = 0x833efa000}, {pos = 550365936, events = 8, fd = 701679362, user_data = 0x82ad0d170 }, {pos = 12445616, events = 0, fd = 718328176, user_data = 0x82118c408}, {pos = 550366160, events = 8, fd = 2114114526, user_data = 0x833f18800}, {pos = 1, events = 8, fd = 2114114142, user_data = 0x821185008}, {pos = 550365944, events = 8, fd = 550366160, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 2114193808, user_data = 0x0}, {pos = 550306687, events = 8, fd = 8127943, user_data = 0x820cdeb80}, {pos = 701641744, events = 8, fd = 718991408, user_data = 0x82adb1310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820cdebb0}, {pos = 701684637, events = 8, fd = 871342080, user_data = 0x1e53}, {pos = 550366224, events = 8, fd = 701651194, user_data = 0x0}, {pos = 0, events = 0, fd = 2057662425, user_data = 0x0}} [22:23:38.689] last_touch_time = 1737325065 [22:23:38.689] last_lockfile_recheck_time = 1737325065 [22:23:38.689] nevents = 1 [22:23:38.689] #21 0x00000000008969b4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820cdf208) at ../src/backend/postmaster/postmaster.c:1377 [22:23:38.689] userDoption = [22:23:38.689] listen_addr_saved = false [22:23:38.689] output_config_variable = [22:23:38.689] opt = [22:23:38.689] status = [22:23:38.689] #22 0x00000000007cd2a0 in main (argc=4, argv=0x820cdf208) at ../src/backend/main/main.c:230 [22:23:38.689] do_check_root = [22:23:38.689] dispatch_option = DISPATCH_POSTMASTER [22:23:38.699] [22:23:38.699] [22:23:38.699] [22:23:38.749] dumping /tmp/cores/sh.13950.core for /bin/sh [22:23:38.789] [New LWP 101916] [22:23:38.789] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/'. [22:23:38.789] Program terminated with signal SIGQUIT, Quit. [22:23:38.789] Sent by kill() from pid 13823 and user 1003. [22:23:38.789] #0 0x0000145ab0f7cff0 in ?? () [22:23:38.789] [22:23:38.789] Thread 1 (LWP 101916): [22:23:38.789] #0 0x0000145ab0f7cff0 in ?? () [22:23:38.789] No symbol table info available. [22:23:38.789] #1 0x0000000000000000 in ?? () [22:23:38.789] No symbol table info available. [22:23:38.794] [22:23:38.794] [22:23:38.794] [22:23:38.854] dumping /tmp/cores/postgres.17566.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:23:38.975] [New LWP 101903] [22:23:39.036] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [22:23:39.036] Program terminated with signal SIGABRT, Aborted. [22:23:39.036] Sent by thr_kill() from pid 17566 and user 1003. [22:23:39.036] #0 0x000000082adf741a in thr_kill () from /lib/libc.so.7 [22:23:39.077] [22:23:39.077] Thread 1 (LWP 101903): [22:23:39.077] #0 0x000000082adf741a in thr_kill () from /lib/libc.so.7 [22:23:39.077] No symbol table info available. [22:23:39.077] #1 0x000000082ad70e64 in raise () from /lib/libc.so.7 [22:23:39.077] No symbol table info available. [22:23:39.077] #2 0x000000082ae216f9 in abort () from /lib/libc.so.7 [22:23:39.077] No symbol table info available. [22:23:39.077] #3 0x0000000000aa0335 in ExceptionalCondition (conditionName=0x2ed1f3 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:23:39.077] No locals. [22:23:39.077] #4 0x00000000007686e9 in standard_ExecutorStart (queryDesc=0x83b085bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [22:23:39.077] estate = 0x83b180100 [22:23:39.077] oldcontext = 0x8334e2800 [22:23:39.077] #5 0x0000000836abe9c2 in pgss_ExecutorStart (queryDesc=0x83b085bd0, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [22:23:39.077] No locals. [22:23:39.077] #6 0x00000000006fcc9f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [22:23:39.077] copied_query = [22:23:39.077] rewritten = [22:23:39.077] plan = 0x83b085778 [22:23:39.077] queryDesc = 0x83b085bd0 [22:23:39.077] processed = [22:23:39.077] __error = [22:23:39.077] #7 RefreshMatViewByOid (matviewOid=28567, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [22:23:39.077] dest = [22:23:39.077] save_userid = 10 [22:23:39.077] save_sec_context = 0 [22:23:39.077] processed = 0 [22:23:39.077] matviewRel = 0x83b20bf18 [22:23:39.077] relowner = 10 [22:23:39.077] save_nestlevel = 2 [22:23:39.077] rule = [22:23:39.077] actions = [22:23:39.077] dataQuery = [22:23:39.077] tableSpace = [22:23:39.077] relpersistence = [22:23:39.077] OIDNewHeap = 28574 [22:23:39.077] address = [22:23:39.077] #8 0x00000000006fc876 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:23:39.077] lockmode = [22:23:39.077] matviewOid = 0 [22:23:39.077] #9 0x00000000006d386c in ExecCreateTableAs (pstate=pstate@entry=0x8334e2900, stmt=stmt@entry=0x83346afd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821414050) at ../src/backend/commands/createas.c:351 [22:23:39.077] refresh = 0x0 [22:23:39.077] query = 0x8333f53c8 [22:23:39.077] into = 0x83346af40 [22:23:39.077] jstate = 0x0 [22:23:39.077] do_refresh = false [22:23:39.077] address = [22:23:39.077] dest = [22:23:39.077] is_matview = [22:23:39.077] #10 0x0000000000948b0b in ProcessUtilitySlow (pstate=pstate@entry=0x8334e2900, pstmt=pstmt@entry=0x83346ae30, queryString=queryString@entry=0x83330d100 "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=0x821414050) at ../src/backend/tcop/utility.c:1678 [22:23:39.077] _local_sigjmp_buf = {{_sjb = {9732921, 0, 34917661368, 34917661744, 34917661376, 12527240, 0, 35220498688, 895, 1, 34917661500, 0}}} [22:23:39.077] _save_exception_stack = 0x821413d40 [22:23:39.077] _save_context_stack = 0x0 [22:23:39.077] _do_rethrow = false [22:23:39.077] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:23:39.077] parsetree = 0x83346afd0 [22:23:39.077] commandCollected = false [22:23:39.077] needCleanup = false [22:23:39.077] address = [22:23:39.077] isTopLevel = [22:23:39.077] isCompleteQuery = [22:23:39.077] #11 0x0000000000947488 in standard_ProcessUtility (pstmt=0x83346ae30, queryString=queryString@entry=0x83330d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8333f5b68, qc=0x821414050) at ../src/backend/tcop/utility.c:1033 [22:23:39.077] isAtomicContext = false [22:23:39.077] parsetree = 0x83346afd0 [22:23:39.077] readonly_flags = [22:23:39.077] pstate = 0x8334e2900 [22:23:39.077] isTopLevel = [22:23:39.077] #12 0x0000000836abef6d in pgss_ProcessUtility (pstmt=0x83346ae30, queryString=0x83330d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8333f5b68, qc=0x821414050) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [22:23:39.077] _local_sigjmp_buf = {{_sjb = {35276975782, 34917662016, 34917661880, 34917662336, 35220008496, 0, 12527240, 34917662544, 895, 1, 34917662132, 34359738368}}} [22:23:39.077] _save_exception_stack = 0x821413f50 [22:23:39.077] _save_context_stack = 0x0 [22:23:39.077] _do_rethrow = false [22:23:39.077] bufusage = {shared_blks_hit = 35276975782, shared_blks_read = 34917662016, shared_blks_dirtied = 34917661880, shared_blks_written = 34917662336, local_blks_hit = 35220008496, local_blks_read = 0, local_blks_dirtied = 12527240, local_blks_written = 34917662544, temp_blks_read = 895, temp_blks_written = 1, shared_blk_read_time = {ticks = 34917662132}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4078464665646602752}, local_blk_write_time = {ticks = 12536168}, temp_blk_read_time = {ticks = 35313544320}, temp_blk_write_time = {ticks = 12479168}} [22:23:39.077] walusage_start = {wal_records = 8990, wal_fpi = 161, wal_bytes = 1413921} [22:23:39.077] duration = [22:23:39.077] bufusage_start = {shared_blks_hit = 153894, shared_blks_read = 8939, shared_blks_dirtied = 2656, shared_blks_written = 2422, 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}} [22:23:39.077] walusage = {wal_records = 0, wal_fpi = 549755813888, wal_bytes = 13233015673287581309} [22:23:39.077] start = {ticks = -188207800928} [22:23:39.077] rows = [22:23:39.077] saved_queryId = 7267788456574341698 [22:23:39.077] parsetree = [22:23:39.077] saved_stmt_location = 0 [22:23:39.077] saved_stmt_len = 69 [22:23:39.077] enabled = [22:23:39.077] #13 0x0000000000946a53 in PortalRunUtility (portal=0x8333b3100, pstmt=0x83346ae30, isTopLevel=, setHoldSnapshot=, dest=0x8333f5b68, qc=0x821414050) at ../src/backend/tcop/pquery.c:1152 [22:23:39.077] No locals. [22:23:39.077] #14 0x0000000000946114 in PortalRunMulti (portal=portal@entry=0x8333b3100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8333f5b68, altdest=altdest@entry=0x8333f5b68, qc=qc@entry=0x821414050) at ../src/backend/tcop/pquery.c:1316 [22:23:39.077] pstmt = 0x83346ae30 [22:23:39.077] stmtlist_item__state = {l = 0x8333f5b18, i = 0} [22:23:39.077] active_snapshot_set = false [22:23:39.077] stmtlist_item = 0x8333f5b30 [22:23:39.077] #15 0x00000000009459fb in PortalRun (portal=portal@entry=0x8333b3100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8333f5b68, altdest=altdest@entry=0x8333f5b68, qc=qc@entry=0x821414050) at ../src/backend/tcop/pquery.c:787 [22:23:39.077] _local_sigjmp_buf = {{_sjb = {9722229, 35219255552, 34917662536, 34917662784, 34917662544, 12527240, 34917662800, 12483208, 12452735, 0, 35219243903, 34359738368}}} [22:23:39.077] _save_exception_stack = 0x821414100 [22:23:39.077] _save_context_stack = 0x0 [22:23:39.077] _do_rethrow = false [22:23:39.077] saveTopTransactionResourceOwner = 0x833408918 [22:23:39.077] saveTopTransactionContext = 0x8333b7000 [22:23:39.077] saveActivePortal = 0x0 [22:23:39.077] saveResourceOwner = 0x833408918 [22:23:39.077] savePortalContext = 0x0 [22:23:39.077] saveMemoryContext = 0x8333b7000 [22:23:39.077] result = [22:23:39.077] nprocessed = [22:23:39.077] #16 0x0000000000944889 in exec_simple_query (query_string=query_string@entry=0x83330d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:23:39.077] cmdtaglen = 24 [22:23:39.077] snapshot_set = [22:23:39.077] per_parsetree_context = 0x0 [22:23:39.077] plantree_list = [22:23:39.077] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:23:39.077] format = 0 [22:23:39.077] parsetree = 0x83330e6a8 [22:23:39.077] commandTag = [22:23:39.077] cmdtagname = [22:23:39.077] querytree_list = [22:23:39.077] portal = 0x8333b3100 [22:23:39.077] receiver = 0x8333f5b68 [22:23:39.077] parsetree_item__state = {l = 0x83330ea18, i = 0} [22:23:39.077] msec_str = "\000\000\000\000\b", '\000' , "Fz\215g\000\000\000\000b\373\003\020./\243y" [22:23:39.077] dest = DestRemote [22:23:39.077] was_logged = [22:23:39.077] oldcontext = 0x8333b7000 [22:23:39.077] parsetree_list = 0x83330ea18 [22:23:39.077] use_implicit_block = false [22:23:39.077] parsetree_item = 0x83330ea30 [22:23:39.077] save_log_statement_stats = [22:23:39.077] #17 0x00000000009424f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [22:23:39.077] query_string = 0x83330d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:23:39.077] input_message = {data = 0x83330d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:23:39.077] firstchar = [22:23:39.077] local_sigjmp_buf = {{_sjb = {9705894, 34917662976, 34917662968, 34917663520, 12535992, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [22:23:39.077] send_ready_for_query = false [22:23:39.077] idle_in_transaction_timeout_enabled = false [22:23:39.077] idle_session_timeout_enabled = false [22:23:39.077] #18 0x000000000093ce99 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:23:39.077] bsdata = [22:23:39.077] #19 0x00000000008941d5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=12, startup_data=startup_data@entry=0x821414e30 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821414d80) at ../src/backend/postmaster/launch_backend.c:274 [22:23:39.077] pid = [22:23:39.077] #20 0x0000000000898726 in BackendStartup (client_sock=0x821414d80) at ../src/backend/postmaster/postmaster.c:3466 [22:23:39.077] startup_data = {canAcceptConnections = CAC_OK} [22:23:39.077] bn = 0x8333f45c8 [22:23:39.077] cac = CAC_OK [22:23:39.077] pid = [22:23:39.077] __error = [22:23:39.077] save_errno = [22:23:39.077] __error = [22:23:39.077] __error = [22:23:39.077] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:23:39.077] 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' , "\340MA!\b\000\000\000h\345\363+\b\000\000\000W\000\000\000\000\000\000\000^o\364+\b", '\000' , " NA!\b\000\000\000d?\211\000\000\000\000\0000NA!\b", '\000' }, salen = 16}} [22:23:39.077] i = 0 [22:23:39.077] now = [22:23:39.077] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 718912642, events = 8, fd = 0, user_data = 0x821414d30}, {pos = 859243992, events = 8, fd = 557927360, user_data = 0x0}, {pos = 889389834, events = 2554, fd = 718079904, user_data = 0x82ace1d78}, {pos = 557926456, events = 8, fd = 557926576, user_data = 0x821414838}, {pos = 889389834, events = 2554, fd = 718058376, user_data = 0x82ace1d78}, {pos = 557926504, events = 8, fd = 557926624, user_data = 0x821414868}, {pos = 718119316, events = 8, fd = 562381832, user_data = 0x82acda194}, {pos = 557926608, events = 8, fd = 889369658, user_data = 0x821414870}, {pos = 737395728, events = 8, fd = 719941680, user_data = 0x9fa3503030a}, {pos = 718026840, events = 8, fd = 718151032, user_data = 0x8214148d8}, {pos = 557926736, events = 8, fd = 557926616, user_data = 0x82acd8d0c}, {pos = 562381832, events = 8, fd = 718114060, user_data = 0x821414940}, {pos = 889369658, events = 2554, fd = 557926760, user_data = 0x821414b38}, {pos = 557926736, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x82185a038}, {pos = 1, events = 3081051556, fd = 562381832, user_data = 0x82accb388}, {pos = 562403272, events = 8, fd = 0, user_data = 0x0}, {pos = 557926872, events = 8, fd = 557927336, user_data = 0x8214149c0}, {pos = 889388194, events = 2554, fd = 2721811, user_data = 0x6d68b}, {pos = 2090263927, events = 3081051556, fd = 562405432, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821414ca8}, {pos = 562381832, events = 3, fd = 557927408, user_data = 0x821859828}, {pos = 656, events = 0, fd = 557927336, user_data = 0x8214149d8}, {pos = 557926976, events = 8, fd = 889387803, user_data = 0x821414b70}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 562405432, events = 8, fd = 1, user_data = 0x821854408}, {pos = 718026840, events = 8, fd = 557927592, user_data = 0x821414bf0}, {pos = 557926992, events = 8, fd = 0, user_data = 0x82184d008}, {pos = 33, events = 0, fd = 557927392, user_data = 0x9fa35029ae7}, {pos = 562352136, events = 8, fd = 562353160, user_data = 0x82184d808}, {pos = 562355208, events = 8, fd = 562368520, user_data = 0x821851408}, {pos = 562370568, events = 8, fd = 562371592, user_data = 0x821852008}, {pos = 562373640, events = 8, fd = 562374664, user_data = 0x821852c08}, {pos = 562376712, events = 8, fd = 562377736, user_data = 0x821853808}, {pos = 562379784, events = 8, fd = 562380808, user_data = 0x821854408}, {pos = 562382856, events = 8, fd = 562383880, user_data = 0x821855008}, {pos = 562385928, events = 8, fd = 562386952, user_data = 0x821855c08}, {pos = 562389000, events = 8, fd = 562390024, user_data = 0x821856808}, {pos = 562392072, events = 8, fd = 562397192, user_data = 0x821858408}, {pos = 562399240, events = 8, fd = 562400264, user_data = 0x82185b408}, {pos = 912069000, events = 0, fd = 562352136, user_data = 0x298813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82185a038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557927592, events = 8, fd = 557926992, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 562405432, user_data = 0x1}, {pos = 562352136, events = 8, fd = 298, user_data = 0x821414c90}, {pos = 889361903, events = 2554, fd = 2721811, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 562405432, user_data = 0x1}, {pos = 562381832, events = 8, fd = 858771456, user_data = 0x1}, {pos = 858771860, events = 8, fd = 0, user_data = 0x821414c60}, {pos = 737437036, events = 8, fd = 1, user_data = 0x8332fd000}, {pos = 557927568, events = 8, fd = 737433346, user_data = 0x82adf5170 }, {pos = 12445616, events = 0, fd = 719278448, user_data = 0x821854408}, {pos = 557927792, events = 8, fd = 889361374, user_data = 0x83331b800}, {pos = 1, events = 8, fd = 889360990, user_data = 0x82184d008}, {pos = 557927576, events = 8, fd = 557927792, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 889440656, user_data = 0x0}, {pos = 557908863, events = 8, fd = 8127943, user_data = 0x821414d20}, {pos = 737395728, events = 8, fd = 719941680, user_data = 0x82ae99310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821414d50}, {pos = 737438621, events = 8, fd = 858771456, user_data = 0x3622}, {pos = 557927856, events = 8, fd = 737405178, user_data = 0x0}, {pos = 0, events = 0, fd = -1317298563, user_data = 0x0}} [22:23:39.077] last_touch_time = 1737325102 [22:23:39.077] last_lockfile_recheck_time = 1737325102 [22:23:39.077] nevents = 1 [22:23:39.077] #22 0x00000000008969b4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8214153a8) at ../src/backend/postmaster/postmaster.c:1377 [22:23:39.077] userDoption = [22:23:39.077] listen_addr_saved = false [22:23:39.077] output_config_variable = [22:23:39.077] opt = [22:23:39.077] status = [22:23:39.077] #23 0x00000000007cd2a0 in main (argc=4, argv=0x8214153a8) at ../src/backend/main/main.c:230 [22:23:39.077] do_check_root = [22:23:39.077] dispatch_option = DISPATCH_POSTMASTER