[15:40:11.047] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [15:40:11.445] dumping /tmp/cores/postgres.10554.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [15:40:11.580] [New LWP 101849] [15:40:11.674] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [15:40:11.674] Program terminated with signal SIGABRT, Aborted. [15:40:11.674] Sent by thr_kill() from pid 10554 and user 1003. [15:40:11.674] #0 0x000000082b9cb41a in thr_kill () from /lib/libc.so.7 [15:40:12.331] [15:40:12.331] Thread 1 (LWP 101849): [15:40:12.331] #0 0x000000082b9cb41a in thr_kill () from /lib/libc.so.7 [15:40:12.331] No symbol table info available. [15:40:12.331] #1 0x000000082b944e64 in raise () from /lib/libc.so.7 [15:40:12.331] No symbol table info available. [15:40:12.331] #2 0x000000082b9f56f9 in abort () from /lib/libc.so.7 [15:40:12.331] No symbol table info available. [15:40:12.331] #3 0x0000000000a8ba65 in ExceptionalCondition (conditionName=0x2e7225 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [15:40:12.331] No locals. [15:40:12.331] #4 0x0000000000760fb9 in standard_ExecutorStart (queryDesc=0x841cbf088, eflags=0) at ../src/backend/executor/execMain.c:191 [15:40:12.331] estate = 0x8360dd100 [15:40:12.331] oldcontext = 0x841c0a800 [15:40:12.331] #5 0x00000000006f7dc5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [15:40:12.331] copied_query = [15:40:12.331] rewritten = [15:40:12.331] plan = 0x83602bbd8 [15:40:12.331] queryDesc = 0x841cbf088 [15:40:12.331] processed = [15:40:12.331] __error = [15:40:12.331] #6 RefreshMatViewByOid (matviewOid=27166, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [15:40:12.331] dest = [15:40:12.331] save_userid = 10 [15:40:12.331] save_sec_context = 0 [15:40:12.331] processed = 0 [15:40:12.331] matviewRel = 0x841bae378 [15:40:12.331] relowner = 10 [15:40:12.331] save_nestlevel = 2 [15:40:12.331] rule = [15:40:12.331] actions = [15:40:12.331] dataQuery = [15:40:12.331] tableSpace = [15:40:12.331] relpersistence = [15:40:12.331] OIDNewHeap = 27203 [15:40:12.331] address = [15:40:12.331] #7 0x00000000006f79a6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [15:40:12.331] lockmode = [15:40:12.331] matviewOid = 0 [15:40:12.331] #8 0x00000000006cf77c in ExecCreateTableAs (pstate=pstate@entry=0x841c0a900, stmt=stmt@entry=0x836117fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820e29130) at ../src/backend/commands/createas.c:350 [15:40:12.331] refresh = 0x0 [15:40:12.331] query = 0x841c7cc58 [15:40:12.331] into = 0x841c7cfa0 [15:40:12.331] do_refresh = false [15:40:12.331] address = [15:40:12.331] dest = [15:40:12.331] is_matview = [15:40:12.331] #9 0x00000000009389c8 in ProcessUtilitySlow (pstate=pstate@entry=0x841c0a900, pstmt=pstmt@entry=0x835f85a68, queryString=queryString@entry=0x835f84100 "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=0x820e29130) at ../src/backend/tcop/utility.c:1675 [15:40:12.331] _local_sigjmp_buf = {{_sjb = {9667065, 0, 34911456600, 34911456976, 34911456608, 12348792, 0, 35462883584, 4294902655, 34911456716, 34911456752, 0}}} [15:40:12.331] _save_exception_stack = 0x820e29030 [15:40:12.331] _save_context_stack = 0x0 [15:40:12.331] _do_rethrow = false [15:40:12.331] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [15:40:12.331] parsetree = 0x836117fd0 [15:40:12.331] commandCollected = false [15:40:12.331] needCleanup = false [15:40:12.331] address = [15:40:12.331] isTopLevel = [15:40:12.331] isCompleteQuery = [15:40:12.331] #10 0x0000000000937348 in standard_ProcessUtility (pstmt=0x835f85a68, queryString=0x835f84100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x841c7d488, qc=0x820e29130) at ../src/backend/tcop/utility.c:1030 [15:40:12.331] isAtomicContext = false [15:40:12.331] parsetree = 0x836117fd0 [15:40:12.331] readonly_flags = [15:40:12.331] pstate = 0x841c0a900 [15:40:12.331] isTopLevel = [15:40:12.331] #11 0x0000000000936dd8 in ProcessUtility (pstmt=0x18dd9, queryString=0x6 , readOnlyTree=, context=731689978, params=0x0, queryEnv=0x0, dest=0x841c7d488, qc=0x820e29130) at ../src/backend/tcop/utility.c:523 [15:40:12.331] No locals. [15:40:12.331] #12 0x0000000000936913 in PortalRunUtility (portal=0x83605b100, pstmt=0x835f85a68, isTopLevel=, setHoldSnapshot=, dest=0x841c7d488, qc=0x820e29130) at ../src/backend/tcop/pquery.c:1158 [15:40:12.331] No locals. [15:40:12.331] #13 0x0000000000935fa4 in PortalRunMulti (portal=portal@entry=0x83605b100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x841c7d488, altdest=altdest@entry=0x841c7d488, qc=0x820e29130) at ../src/backend/tcop/pquery.c:1323 [15:40:12.331] pstmt = 0x835f85a68 [15:40:12.331] stmtlist_item__state = {l = 0x841c7d438, i = 0} [15:40:12.331] active_snapshot_set = false [15:40:12.331] stmtlist_item = 0x841c7d450 [15:40:12.331] #14 0x0000000000935873 in PortalRun (portal=portal@entry=0x83605b100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x841c7d488, altdest=altdest@entry=0x841c7d488, qc=0x820e29130) at ../src/backend/tcop/pquery.c:791 [15:40:12.331] _local_sigjmp_buf = {{_sjb = {9656301, 35266081024, 34911457320, 34911457552, 34911457328, 35266097152, 12315464, 12348792, 35266036607, 35266848144, 4294967984, 0}}} [15:40:12.331] _save_exception_stack = 0x820e29200 [15:40:12.331] _save_context_stack = 0x0 [15:40:12.331] _do_rethrow = false [15:40:12.331] saveTopTransactionResourceOwner = 0x83606ca98 [15:40:12.331] saveTopTransactionContext = 0x83605f000 [15:40:12.331] saveActivePortal = 0x0 [15:40:12.331] saveResourceOwner = 0x83606ca98 [15:40:12.331] savePortalContext = 0x0 [15:40:12.331] saveMemoryContext = 0x83605f000 [15:40:12.331] result = [15:40:12.331] nprocessed = [15:40:12.331] #15 0x0000000000934712 in exec_simple_query (query_string=query_string@entry=0x835f84100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [15:40:12.331] cmdtaglen = 24 [15:40:12.331] snapshot_set = [15:40:12.331] per_parsetree_context = 0x0 [15:40:12.331] plantree_list = [15:40:12.331] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:40:12.331] format = 0 [15:40:12.331] parsetree = 0x835f856a8 [15:40:12.331] commandTag = [15:40:12.331] cmdtagname = [15:40:12.331] querytree_list = [15:40:12.331] portal = 0x83605b100 [15:40:12.331] receiver = 0x841c7d488 [15:40:12.331] parsetree_item__state = {l = 0x835f85a18, i = 0} [15:40:12.331] msec_str = "\000\000\000\000\b", '\000' , "\347[\344f\000\000\000\000E\324\315=ˎ\315m" [15:40:12.331] dest = DestRemote [15:40:12.331] was_logged = [15:40:12.331] oldcontext = 0x83605f000 [15:40:12.331] parsetree_list = 0x835f85a18 [15:40:12.331] use_implicit_block = false [15:40:12.331] parsetree_item = 0x835f85a30 [15:40:12.331] save_log_statement_stats = [15:40:12.331] #16 0x0000000000932480 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [15:40:12.331] query_string = 0x835f84100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [15:40:12.331] input_message = {data = 0x835f84100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [15:40:12.331] firstchar = [15:40:12.331] local_sigjmp_buf = {{_sjb = {9640214, 34911457792, 34911457752, 34911458336, 12357528, 1, 8192, 8388608, 34911421311, 0, 0, 1}}} [15:40:12.331] send_ready_for_query = false [15:40:12.331] idle_in_transaction_timeout_enabled = false [15:40:12.331] idle_session_timeout_enabled = false [15:40:12.331] #17 0x000000000092cc59 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [15:40:12.331] bsdata = [15:40:12.331] #18 0x0000000000886dd7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820e29f44 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820e29e80) at ../src/backend/postmaster/launch_backend.c:274 [15:40:12.331] pid = [15:40:12.331] #19 0x000000000088b198 in BackendStartup (client_sock=0x820e29e80) at ../src/backend/postmaster/postmaster.c:3415 [15:40:12.331] startup_data = {canAcceptConnections = CAC_OK} [15:40:12.331] bn = 0x835f903a8 [15:40:12.331] pid = [15:40:12.331] __error = [15:40:12.331] save_errno = [15:40:12.331] __error = [15:40:12.331] __error = [15:40:12.331] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [15:40:12.331] 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 = "\000_\3705\b", '\000' , "\340\236\342 \b\000\000\000h%\"+\b\000\000\000\v\000\000\000\000\000\000\000^\257\"+\b", '\000' , " \237\342 \b\000\000\000\204k\210\000\000\000\000\0000\237\342 \b", '\000' }, salen = 16}} [15:40:12.331] i = 0 [15:40:12.331] now = [15:40:12.331] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 731315330, events = 8, fd = 0, user_data = 0x820e29e30}, {pos = 905840088, events = 8, fd = 551722176, user_data = 0x0}, {pos = 0, events = 0, fd = -436873313, user_data = 0x13f9b4bf830a}, {pos = 730482592, events = 8, fd = 730553720, user_data = 0x820e29948}, {pos = 551721408, events = 8, fd = 551721288, user_data = 0x13f9b4bf830a}, {pos = 730461064, events = 8, fd = 730553720, user_data = 0x820e29978}, {pos = 551721456, events = 8, fd = 551721336, user_data = 0x82b8ae194}, {pos = 552313864, events = 8, fd = 730522004, user_data = 0x820e299e0}, {pos = -1262537670, events = 5113, fd = 732344368, user_data = 0x1}, {pos = 551721488, events = 8, fd = -1262517494, user_data = 0x82b897858}, {pos = 730553720, events = 8, fd = 551721448, user_data = 0x820e29a60}, {pos = 551721448, events = 8, fd = 730516748, user_data = 0x820eba408}, {pos = 730516748, events = 8, fd = 551721552, user_data = 0x13f9b4bf343a}, {pos = 551721592, events = 8, fd = 551722040, user_data = 0x820e29a60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 694188225, fd = 552337464, user_data = 0x800000001}, {pos = 552313864, events = 8, fd = 730461064, user_data = 0x820ebf288}, {pos = 730429528, events = 8, fd = 552313864, user_data = 0x820e29ae8}, {pos = 551722152, events = 8, fd = 551721680, user_data = 0x13f9b4bf7ca2}, {pos = 2700599, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 552337464, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 551722408, user_data = 0x20eba408}, {pos = 551722224, events = 8, fd = 551721824, user_data = 0x1}, {pos = 551722152, events = 8, fd = 32, user_data = 0x820e29b50}, {pos = -1262519693, events = 5113, fd = 551722096, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x820ec0038}, {pos = 1, events = 8, fd = 552313864, user_data = 0x82b897858}, {pos = 551722408, events = 8, fd = 551722224, user_data = 0x820e29b60}, {pos = 0, events = 0, fd = 552284168, user_data = 0x20}, {pos = 551722208, events = 8, fd = -1262544153, user_data = 0x820eb3008}, {pos = 552285192, events = 8, fd = 552286216, user_data = 0x820eb3c08}, {pos = 552300552, events = 8, fd = 552301576, user_data = 0x820eb7808}, {pos = 552303624, events = 8, fd = 552304648, user_data = 0x820eb8408}, {pos = 552306696, events = 8, fd = 552307720, user_data = 0x820eb9008}, {pos = 552309768, events = 8, fd = 552310792, user_data = 0x820eb9c08}, {pos = 552312840, events = 8, fd = 552313864, user_data = 0x820eba808}, {pos = 552315912, events = 8, fd = 552316936, user_data = 0x820ebb408}, {pos = 552318984, events = 8, fd = 552320008, user_data = 0x820ebc008}, {pos = 552322056, events = 8, fd = 552323080, user_data = 0x820ebcc08}, {pos = 552329224, events = 8, fd = 552330248, user_data = 0x820ebe808}, {pos = 552332296, events = 8, fd = 552284168, user_data = 0x293537}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x820ec0038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 551722408, events = 8, fd = 551721824, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 552337464, user_data = 0x1}, {pos = 552284168, events = 8, fd = 313, user_data = 0x820e29d90}, {pos = -1262545425, events = 5113, fd = 2700599, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 552337464, user_data = 0x1}, {pos = 552313864, events = 8, fd = 905396224, user_data = 0x1}, {pos = 905396628, events = 8, fd = 0, user_data = 0x820e29d60}, {pos = 723690860, events = 8, fd = 1, user_data = 0x835f74000}, {pos = 551722384, events = 8, fd = 723687170, user_data = 0x82b9c9170 }, {pos = 12282560, events = 0, fd = 731681136, user_data = 0x820eba408}, {pos = 551722608, events = 8, fd = -1262545954, user_data = 0x835f92800}, {pos = 1, events = 0, fd = -1262546338, user_data = 0x820eb3008}, {pos = 551722392, events = 8, fd = 551722608, user_data = 0x1c20}, {pos = 905469696, events = 8, fd = -1262466672, user_data = 0x0}, {pos = 551682943, events = 8, fd = 8090775, user_data = 0x820e29e20}, {pos = 723649552, events = 8, fd = 732344368, user_data = 0x82ba6d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820e29e50}, {pos = 723692445, events = 8, fd = 905396224, user_data = 0x1d93}, {pos = 551722672, events = 8, fd = 723659002, user_data = 0x0}, {pos = 0, events = 0, fd = -436873313, user_data = 0x0}} [15:40:12.331] last_touch_time = 1726241748 [15:40:12.331] last_lockfile_recheck_time = 1726241748 [15:40:12.331] nevents = 1 [15:40:12.331] #21 0x0000000000888fb5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820e2a490) at ../src/backend/postmaster/postmaster.c:1346 [15:40:12.331] userDoption = [15:40:12.331] listen_addr_saved = [15:40:12.331] output_config_variable = [15:40:12.331] opt = [15:40:12.331] status = [15:40:12.331] #22 0x00000000007c417c in main (argc=8, argv=0x820e2a490) at ../src/backend/main/main.c:197 [15:40:12.331] do_check_root = [15:40:12.344] [15:40:12.344] [15:40:12.344] [15:40:12.410] dumping /tmp/cores/postgres.10914.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:40:12.535] [New LWP 101886] [15:40:12.605] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [15:40:12.605] Program terminated with signal SIGABRT, Aborted. [15:40:12.605] Sent by thr_kill() from pid 10914 and user 1003. [15:40:12.605] #0 0x000000082a5de41a in thr_kill () from /lib/libc.so.7 [15:40:13.258] [15:40:13.258] Thread 1 (LWP 101886): [15:40:13.258] #0 0x000000082a5de41a in thr_kill () from /lib/libc.so.7 [15:40:13.258] No symbol table info available. [15:40:13.258] #1 0x000000082a557e64 in raise () from /lib/libc.so.7 [15:40:13.258] No symbol table info available. [15:40:13.258] #2 0x000000082a6086f9 in abort () from /lib/libc.so.7 [15:40:13.258] No symbol table info available. [15:40:13.258] #3 0x0000000000a8ba65 in ExceptionalCondition (conditionName=0x2e7225 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [15:40:13.258] No locals. [15:40:13.258] #4 0x0000000000760fb9 in standard_ExecutorStart (queryDesc=0x841da3088, eflags=0) at ../src/backend/executor/execMain.c:191 [15:40:13.258] estate = 0x834351100 [15:40:13.258] oldcontext = 0x83433f800 [15:40:13.258] #5 0x00000000006f7dc5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [15:40:13.258] copied_query = [15:40:13.258] rewritten = [15:40:13.258] plan = 0x83434bbd8 [15:40:13.258] queryDesc = 0x841da3088 [15:40:13.258] processed = [15:40:13.258] __error = [15:40:13.258] #6 RefreshMatViewByOid (matviewOid=27303, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [15:40:13.258] dest = [15:40:13.258] save_userid = 10 [15:40:13.258] save_sec_context = 0 [15:40:13.258] processed = 0 [15:40:13.258] matviewRel = 0x841cad830 [15:40:13.258] relowner = 10 [15:40:13.258] save_nestlevel = 2 [15:40:13.258] rule = [15:40:13.258] actions = [15:40:13.258] dataQuery = [15:40:13.258] tableSpace = [15:40:13.258] relpersistence = [15:40:13.258] OIDNewHeap = 27310 [15:40:13.258] address = [15:40:13.258] #7 0x00000000006f79a6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [15:40:13.258] lockmode = [15:40:13.258] matviewOid = 0 [15:40:13.258] #8 0x00000000006cf77c in ExecCreateTableAs (pstate=pstate@entry=0x83433f900, stmt=stmt@entry=0x8342ccfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821288480) at ../src/backend/commands/createas.c:350 [15:40:13.258] refresh = 0x0 [15:40:13.258] query = 0x841dcb8d8 [15:40:13.258] into = 0x841dcbc20 [15:40:13.258] do_refresh = false [15:40:13.258] address = [15:40:13.258] dest = [15:40:13.258] is_matview = [15:40:13.258] #9 0x00000000009389c8 in ProcessUtilitySlow (pstate=pstate@entry=0x83433f900, pstmt=pstmt@entry=0x8341b7a68, queryString=queryString@entry=0x8341b6100 "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=0x821288480) at ../src/backend/tcop/utility.c:1675 [15:40:13.258] _local_sigjmp_buf = {{_sjb = {9667065, 0, 34916040872, 34916041248, 34916040880, 12348792, 0, 35235559680, 4294902655, 34916040988, 34916041024, 0}}} [15:40:13.258] _save_exception_stack = 0x821288380 [15:40:13.258] _save_context_stack = 0x0 [15:40:13.258] _do_rethrow = false [15:40:13.258] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [15:40:13.258] parsetree = 0x8342ccfd0 [15:40:13.258] commandCollected = false [15:40:13.258] needCleanup = false [15:40:13.258] address = [15:40:13.258] isTopLevel = [15:40:13.258] isCompleteQuery = [15:40:13.258] #10 0x0000000000937348 in standard_ProcessUtility (pstmt=0x8341b7a68, queryString=0x8341b6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x841dcc108, qc=0x821288480) at ../src/backend/tcop/utility.c:1030 [15:40:13.258] isAtomicContext = false [15:40:13.258] parsetree = 0x8342ccfd0 [15:40:13.258] readonly_flags = [15:40:13.258] pstate = 0x83433f900 [15:40:13.258] isTopLevel = [15:40:13.258] #11 0x0000000000936dd8 in ProcessUtility (pstmt=0x18dfe, queryString=0x6 , readOnlyTree=, context=710796282, params=0x0, queryEnv=0x0, dest=0x841dcc108, qc=0x821288480) at ../src/backend/tcop/utility.c:523 [15:40:13.258] No locals. [15:40:13.258] #12 0x0000000000936913 in PortalRunUtility (portal=0x83425c100, pstmt=0x8341b7a68, isTopLevel=, setHoldSnapshot=, dest=0x841dcc108, qc=0x821288480) at ../src/backend/tcop/pquery.c:1158 [15:40:13.258] No locals. [15:40:13.258] #13 0x0000000000935fa4 in PortalRunMulti (portal=portal@entry=0x83425c100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x841dcc108, altdest=altdest@entry=0x841dcc108, qc=0x821288480) at ../src/backend/tcop/pquery.c:1323 [15:40:13.258] pstmt = 0x8341b7a68 [15:40:13.258] stmtlist_item__state = {l = 0x841dcc0b8, i = 0} [15:40:13.258] active_snapshot_set = false [15:40:13.258] stmtlist_item = 0x841dcc0d0 [15:40:13.258] #14 0x0000000000935873 in PortalRun (portal=portal@entry=0x83425c100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x841dcc108, altdest=altdest@entry=0x841dcc108, qc=0x821288480) at ../src/backend/tcop/pquery.c:791 [15:40:13.258] _local_sigjmp_buf = {{_sjb = {9656301, 35234627840, 34916041592, 34916041824, 34916041600, 35234643968, 12315464, 12348792, 35234579327, 35235083664, 4294967984, 0}}} [15:40:13.258] _save_exception_stack = 0x821288550 [15:40:13.258] _save_context_stack = 0x0 [15:40:13.258] _do_rethrow = false [15:40:13.258] saveTopTransactionResourceOwner = 0x8342ab458 [15:40:13.258] saveTopTransactionContext = 0x834260000 [15:40:13.258] saveActivePortal = 0x0 [15:40:13.258] saveResourceOwner = 0x8342ab458 [15:40:13.258] savePortalContext = 0x0 [15:40:13.258] saveMemoryContext = 0x834260000 [15:40:13.258] result = [15:40:13.258] nprocessed = [15:40:13.258] #15 0x0000000000934712 in exec_simple_query (query_string=query_string@entry=0x8341b6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [15:40:13.258] cmdtaglen = 24 [15:40:13.258] snapshot_set = [15:40:13.258] per_parsetree_context = 0x0 [15:40:13.258] plantree_list = [15:40:13.258] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:40:13.258] format = 0 [15:40:13.258] parsetree = 0x8341b76a8 [15:40:13.258] commandTag = [15:40:13.258] cmdtagname = [15:40:13.258] querytree_list = [15:40:13.258] portal = 0x83425c100 [15:40:13.258] receiver = 0x841dcc108 [15:40:13.258] parsetree_item__state = {l = 0x8341b7a18, i = 0} [15:40:13.258] msec_str = "\000\000\000\000\b", '\000' , "\352[\344f\000\000\000\000m\206S\336\310%\"W" [15:40:13.258] dest = DestRemote [15:40:13.258] was_logged = [15:40:13.258] oldcontext = 0x834260000 [15:40:13.258] parsetree_list = 0x8341b7a18 [15:40:13.258] use_implicit_block = false [15:40:13.258] parsetree_item = 0x8341b7a30 [15:40:13.258] save_log_statement_stats = [15:40:13.258] #16 0x0000000000932480 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [15:40:13.258] query_string = 0x8341b6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [15:40:13.258] input_message = {data = 0x8341b6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [15:40:13.258] firstchar = [15:40:13.258] local_sigjmp_buf = {{_sjb = {9640214, 34916042064, 34916042024, 34916042608, 12357528, 1, 8192, 8388608, 34916008831, 0, 0, 1}}} [15:40:13.258] send_ready_for_query = false [15:40:13.258] idle_in_transaction_timeout_enabled = false [15:40:13.258] idle_session_timeout_enabled = false [15:40:13.258] #17 0x000000000092cc59 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [15:40:13.258] bsdata = [15:40:13.258] #18 0x0000000000886dd7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821289294 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212891d0) at ../src/backend/postmaster/launch_backend.c:274 [15:40:13.258] pid = [15:40:13.258] #19 0x000000000088b198 in BackendStartup (client_sock=0x8212891d0) at ../src/backend/postmaster/postmaster.c:3415 [15:40:13.258] startup_data = {canAcceptConnections = CAC_OK} [15:40:13.258] bn = 0x8341c3fb8 [15:40:13.258] pid = [15:40:13.258] __error = [15:40:13.258] save_errno = [15:40:13.258] __error = [15:40:13.258] __error = [15:40:13.258] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [15:40:13.258] 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 = "\300~\0334\b", '\000' , "0\222(!\b\000\000\000h\305q)\b\000\000\000\v\000\000\000\000\000\000\000^Or)\b", '\000' , "p\222(!\b\000\000\000\204k\210\000\000\000\000\000\200\222(!\b", '\000' }, salen = 16}} [15:40:13.258] i = 0 [15:40:13.258] now = [15:40:13.258] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 710421634, events = 8, fd = 0, user_data = 0x821289180}, {pos = 874644952, events = 8, fd = 556306448, user_data = 0x0}, {pos = 0, events = 0, fd = 1629957385, user_data = 0x1a8574ed730a}, {pos = 709588896, events = 8, fd = 709660024, user_data = 0x821288c98}, {pos = 556305680, events = 8, fd = 556305560, user_data = 0x1a8574ed730a}, {pos = 709567368, events = 8, fd = 709660024, user_data = 0x821288cc8}, {pos = 556305728, events = 8, fd = 556305608, user_data = 0x82a4c1194}, {pos = 566371336, events = 8, fd = 709628308, user_data = 0x821288d30}, {pos = 1961698362, events = 6789, fd = 711450672, user_data = 0x1}, {pos = 556305760, events = 8, fd = 1961718538, user_data = 0x82a4aa858}, {pos = 709660024, events = 8, fd = 556305720, user_data = 0x821288db0}, {pos = 556305720, events = 8, fd = 709623052, user_data = 0x821c22408}, {pos = 709623052, events = 8, fd = 556305824, user_data = 0x1a8574ed243a}, {pos = 556305864, events = 8, fd = 556306312, user_data = 0x821288db0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 237851185, fd = 566394936, user_data = 0x800000001}, {pos = 566371336, events = 8, fd = 709567368, user_data = 0x821c27288}, {pos = 709535832, events = 8, fd = 566371336, user_data = 0x821288e38}, {pos = 556306424, events = 8, fd = 556305952, user_data = 0x1a8574ed6ca2}, {pos = 2700599, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 566394936, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 556306680, user_data = 0x21c22408}, {pos = 556306496, events = 8, fd = 556306096, user_data = 0x1}, {pos = 556306424, events = 8, fd = 32, user_data = 0x821288ea0}, {pos = 1961716339, events = 6789, fd = 556306368, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821c28038}, {pos = 1, events = 8, fd = 566371336, user_data = 0x82a4aa858}, {pos = 556306680, events = 8, fd = 556306496, user_data = 0x821288eb0}, {pos = 0, events = 0, fd = 566341640, user_data = 0x20}, {pos = 556306480, events = 8, fd = 1961691879, user_data = 0x821c1b008}, {pos = 566342664, events = 8, fd = 566343688, user_data = 0x821c1bc08}, {pos = 566358024, events = 8, fd = 566359048, user_data = 0x821c1f808}, {pos = 566361096, events = 8, fd = 566362120, user_data = 0x821c20408}, {pos = 566364168, events = 8, fd = 566365192, user_data = 0x821c21008}, {pos = 566367240, events = 8, fd = 566368264, user_data = 0x821c21c08}, {pos = 566370312, events = 8, fd = 566371336, user_data = 0x821c22808}, {pos = 566373384, events = 8, fd = 566374408, user_data = 0x821c23408}, {pos = 566376456, events = 8, fd = 566377480, user_data = 0x821c24008}, {pos = 566379528, events = 8, fd = 566380552, user_data = 0x821c24c08}, {pos = 566386696, events = 8, fd = 566387720, user_data = 0x821c26808}, {pos = 566389768, events = 8, fd = 566341640, user_data = 0x293537}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821c28038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556306680, events = 8, fd = 556306096, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 566394936, user_data = 0x1}, {pos = 566341640, events = 8, fd = 313, user_data = 0x8212890e0}, {pos = 1961690607, events = 6789, fd = 2700599, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 566394936, user_data = 0x1}, {pos = 566371336, events = 8, fd = 874143744, user_data = 0x1}, {pos = 874144148, events = 8, fd = 0, user_data = 0x8212890b0}, {pos = 695354732, events = 8, fd = 1, user_data = 0x8341a6000}, {pos = 556306656, events = 8, fd = 695351042, user_data = 0x82a5dc170 }, {pos = 12282560, events = 0, fd = 710787440, user_data = 0x821c22408}, {pos = 556306880, events = 8, fd = 1961690078, user_data = 0x8341c4800}, {pos = 1, events = 0, fd = 1961689694, user_data = 0x821c1b008}, {pos = 556306664, events = 8, fd = 556306880, user_data = 0x1c20}, {pos = 874217152, events = 8, fd = 1961769360, user_data = 0x0}, {pos = 556270463, events = 8, fd = 8090775, user_data = 0x821289170}, {pos = 695313424, events = 8, fd = 711450672, user_data = 0x82a680310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8212891a0}, {pos = 695356317, events = 8, fd = 874143744, user_data = 0x1dd0}, {pos = 556306944, events = 8, fd = 695322874, user_data = 0x0}, {pos = 0, events = 0, fd = 1629957385, user_data = 0x0}} [15:40:13.259] last_touch_time = 1726241748 [15:40:13.259] last_lockfile_recheck_time = 1726241748 [15:40:13.259] nevents = 1 [15:40:13.259] #21 0x0000000000888fb5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8212897e8) at ../src/backend/postmaster/postmaster.c:1346 [15:40:13.259] userDoption = [15:40:13.259] listen_addr_saved = [15:40:13.259] output_config_variable = [15:40:13.259] opt = [15:40:13.259] status = [15:40:13.259] #22 0x00000000007c417c in main (argc=4, argv=0x8212897e8) at ../src/backend/main/main.c:197 [15:40:13.259] do_check_root = [15:40:13.273] [15:40:13.273] [15:40:13.273] [15:40:13.326] dumping /tmp/cores/sh.13906.core for /bin/sh [15:40:13.368] [New LWP 101881] [15:40:13.369] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/'. [15:40:13.369] Program terminated with signal SIGQUIT, Quit. [15:40:13.369] Sent by kill() from pid 13801 and user 1003. [15:40:13.369] #0 0x00004f95e86e35da in ?? () from /libexec/ld-elf.so.1 [15:40:13.369] [15:40:13.369] Thread 1 (LWP 101881): [15:40:13.369] #0 0x00004f95e86e35da in ?? () from /libexec/ld-elf.so.1 [15:40:13.369] No symbol table info available. [15:40:13.369] #1 0x00004f95e86df6ec in ?? () from /libexec/ld-elf.so.1 [15:40:13.369] No symbol table info available. [15:40:13.369] #2 0x0000000000000000 in ?? () [15:40:13.369] No symbol table info available. [15:40:13.376] [15:40:13.376] [15:40:13.376] [15:40:13.443] dumping /tmp/cores/postgres.17471.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:40:13.569] [New LWP 101864] [15:40:13.639] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [15:40:13.639] Program terminated with signal SIGABRT, Aborted. [15:40:13.639] Sent by thr_kill() from pid 17471 and user 1003. [15:40:13.639] #0 0x000000082aef841a in thr_kill () from /lib/libc.so.7 [15:40:14.284] [15:40:14.284] Thread 1 (LWP 101864): [15:40:14.284] #0 0x000000082aef841a in thr_kill () from /lib/libc.so.7 [15:40:14.284] No symbol table info available. [15:40:14.284] #1 0x000000082ae71e64 in raise () from /lib/libc.so.7 [15:40:14.284] No symbol table info available. [15:40:14.284] #2 0x000000082af226f9 in abort () from /lib/libc.so.7 [15:40:14.284] No symbol table info available. [15:40:14.284] #3 0x0000000000a8ba65 in ExceptionalCondition (conditionName=0x2e7225 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [15:40:14.284] No locals. [15:40:14.284] #4 0x0000000000760fb9 in standard_ExecutorStart (queryDesc=0x835b72088, eflags=0) at ../src/backend/executor/execMain.c:191 [15:40:14.284] estate = 0x833671100 [15:40:14.284] oldcontext = 0x835b90800 [15:40:14.284] #5 0x000000083514f862 in pgss_ExecutorStart (queryDesc=0x835b72088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:993 [15:40:14.284] No locals. [15:40:14.284] #6 0x00000000006f7dc5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [15:40:14.284] copied_query = [15:40:14.284] rewritten = [15:40:14.284] plan = 0x835b89bd8 [15:40:14.284] queryDesc = 0x835b72088 [15:40:14.284] processed = [15:40:14.284] __error = [15:40:14.284] #7 RefreshMatViewByOid (matviewOid=27373, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [15:40:14.284] dest = [15:40:14.284] save_userid = 10 [15:40:14.284] save_sec_context = 0 [15:40:14.284] processed = 0 [15:40:14.284] matviewRel = 0x835b3f098 [15:40:14.284] relowner = 10 [15:40:14.284] save_nestlevel = 2 [15:40:14.284] rule = [15:40:14.284] actions = [15:40:14.284] dataQuery = [15:40:14.284] tableSpace = [15:40:14.284] relpersistence = [15:40:14.284] OIDNewHeap = 27380 [15:40:14.284] address = [15:40:14.284] #8 0x00000000006f79a6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [15:40:14.284] lockmode = [15:40:14.284] matviewOid = 0 [15:40:14.284] #9 0x00000000006cf77c in ExecCreateTableAs (pstate=pstate@entry=0x835b90900, stmt=stmt@entry=0x8335d0fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821839350) at ../src/backend/commands/createas.c:350 [15:40:14.284] refresh = 0x0 [15:40:14.284] query = 0x83361bb88 [15:40:14.284] into = 0x8335d0f40 [15:40:14.284] do_refresh = false [15:40:14.284] address = [15:40:14.284] dest = [15:40:14.284] is_matview = [15:40:14.284] #10 0x00000000009389c8 in ProcessUtilitySlow (pstate=pstate@entry=0x835b90900, pstmt=pstmt@entry=0x8335d0e30, queryString=queryString@entry=0x833533100 "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=0x821839350) at ../src/backend/tcop/utility.c:1675 [15:40:14.284] _local_sigjmp_buf = {{_sjb = {9667065, 0, 34922007992, 34922008368, 34922008000, 12348792, 0, 35261057280, 34921972607, 7, 34922008144, 0}}} [15:40:14.284] _save_exception_stack = 0x821839040 [15:40:14.284] _save_context_stack = 0x0 [15:40:14.284] _do_rethrow = false [15:40:14.284] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [15:40:14.284] parsetree = 0x8335d0fd0 [15:40:14.284] commandCollected = false [15:40:14.284] needCleanup = false [15:40:14.284] address = [15:40:14.284] isTopLevel = [15:40:14.284] isCompleteQuery = [15:40:14.284] #11 0x0000000000937348 in standard_ProcessUtility (pstmt=0x8335d0e30, queryString=queryString@entry=0x833533100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83361c328, qc=0x821839350) at ../src/backend/tcop/utility.c:1030 [15:40:14.284] isAtomicContext = false [15:40:14.284] parsetree = 0x8335d0fd0 [15:40:14.284] readonly_flags = [15:40:14.284] pstate = 0x835b90900 [15:40:14.284] isTopLevel = [15:40:14.284] #12 0x000000083514fdee in pgss_ProcessUtility (pstmt=0x8335d0e30, queryString=0x833533100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83361c328, qc=0x821839350) at ../contrib/pg_stat_statements/pg_stat_statements.c:1167 [15:40:14.284] _local_sigjmp_buf = {{_sjb = {35250306343, 34922008640, 34922008504, 34922008960, 35221474864, 0, 12348792, 34922009168, 34921972607, 34922008740, 34922008768, 0}}} [15:40:14.284] _save_exception_stack = 0x821839250 [15:40:14.284] _save_context_stack = 0x0 [15:40:14.284] _do_rethrow = false [15:40:14.284] bufusage = {shared_blks_hit = 35250306343, shared_blks_read = 34922008640, shared_blks_dirtied = 34922008504, shared_blks_written = 34922008960, local_blks_hit = 35221474864, local_blks_read = 0, local_blks_dirtied = 12348792, local_blks_written = 34922009168, temp_blks_read = 34921972607, temp_blks_written = 34922008740, shared_blk_read_time = {ticks = 34922008768}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 3980000100821424384}, local_blk_write_time = {ticks = 12357832}, temp_blk_read_time = {ticks = 35290592896}, temp_blk_write_time = {ticks = 12311408}} [15:40:14.284] walusage_start = {wal_records = 8920, wal_fpi = 122, wal_bytes = 1188617} [15:40:14.284] duration = [15:40:14.284] bufusage_start = {shared_blks_hit = 149440, shared_blks_read = 9040, shared_blks_dirtied = 2811, shared_blks_written = 2343, 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}} [15:40:14.284] walusage = {wal_records = 4539782146534248931, wal_fpi = 35221475280, wal_bytes = 123} [15:40:14.284] start = {ticks = -189116083682} [15:40:14.284] rows = [15:40:14.284] saved_queryId = 6041762721901209185 [15:40:14.284] parsetree = [15:40:14.284] saved_stmt_location = 0 [15:40:14.284] saved_stmt_len = 69 [15:40:14.284] enabled = [15:40:14.284] #13 0x0000000000936913 in PortalRunUtility (portal=0x8335db100, pstmt=0x8335d0e30, isTopLevel=, setHoldSnapshot=, dest=0x83361c328, qc=0x821839350) at ../src/backend/tcop/pquery.c:1158 [15:40:14.284] No locals. [15:40:14.284] #14 0x0000000000935fa4 in PortalRunMulti (portal=portal@entry=0x8335db100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83361c328, altdest=altdest@entry=0x83361c328, qc=0x821839350) at ../src/backend/tcop/pquery.c:1323 [15:40:14.284] pstmt = 0x8335d0e30 [15:40:14.284] stmtlist_item__state = {l = 0x83361c2d8, i = 0} [15:40:14.284] active_snapshot_set = false [15:40:14.284] stmtlist_item = 0x83361c2f0 [15:40:14.284] #15 0x0000000000935873 in PortalRun (portal=portal@entry=0x8335db100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83361c328, altdest=altdest@entry=0x83361c328, qc=0x821839350) at ../src/backend/tcop/pquery.c:791 [15:40:14.284] _local_sigjmp_buf = {{_sjb = {9656301, 35221516544, 34922009160, 34922009392, 34922009168, 35221610496, 12315464, 12348792, 35221472127, 35221468640, 4294967984, 0}}} [15:40:14.284] _save_exception_stack = 0x821839420 [15:40:14.284] _save_context_stack = 0x0 [15:40:14.284] _do_rethrow = false [15:40:14.284] saveTopTransactionResourceOwner = 0x833629458 [15:40:14.284] saveTopTransactionContext = 0x8335f2000 [15:40:14.284] saveActivePortal = 0x0 [15:40:14.284] saveResourceOwner = 0x833629458 [15:40:14.284] savePortalContext = 0x0 [15:40:14.284] saveMemoryContext = 0x8335f2000 [15:40:14.284] result = [15:40:14.284] nprocessed = [15:40:14.284] #16 0x0000000000934712 in exec_simple_query (query_string=query_string@entry=0x833533100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [15:40:14.284] cmdtaglen = 24 [15:40:14.284] snapshot_set = [15:40:14.284] per_parsetree_context = 0x0 [15:40:14.284] plantree_list = [15:40:14.284] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:40:14.284] format = 0 [15:40:14.284] parsetree = 0x8335346a8 [15:40:14.284] commandTag = [15:40:14.284] cmdtagname = [15:40:14.284] querytree_list = [15:40:14.284] portal = 0x8335db100 [15:40:14.284] receiver = 0x83361c328 [15:40:14.284] parsetree_item__state = {l = 0x833534a18, i = 0} [15:40:14.284] msec_str = "\000\000\000\000\b", '\000' , "\016\\\344f\000\000\000\000#\217\031\357\276D\240\262" [15:40:14.284] dest = DestRemote [15:40:14.284] was_logged = [15:40:14.284] oldcontext = 0x8335f2000 [15:40:14.284] parsetree_list = 0x833534a18 [15:40:14.284] use_implicit_block = false [15:40:14.284] parsetree_item = 0x833534a30 [15:40:14.284] save_log_statement_stats = [15:40:14.284] #17 0x0000000000932480 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [15:40:14.284] query_string = 0x833533100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [15:40:14.284] input_message = {data = 0x833533100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [15:40:14.284] firstchar = [15:40:14.284] local_sigjmp_buf = {{_sjb = {9640214, 34922009632, 34922009592, 34922010176, 12357528, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [15:40:14.284] send_ready_for_query = false [15:40:14.284] idle_in_transaction_timeout_enabled = false [15:40:14.284] idle_session_timeout_enabled = false [15:40:14.284] #18 0x000000000092cc59 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [15:40:14.284] bsdata = [15:40:14.284] #19 0x0000000000886dd7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82183a164 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82183a0a0) at ../src/backend/postmaster/launch_backend.c:274 [15:40:14.284] pid = [15:40:14.284] #20 0x000000000088b198 in BackendStartup (client_sock=0x82183a0a0) at ../src/backend/postmaster/postmaster.c:3415 [15:40:14.284] startup_data = {canAcceptConnections = CAC_OK} [15:40:14.284] bn = 0x83353f3a8 [15:40:14.284] pid = [15:40:14.284] __error = [15:40:14.284] save_errno = [15:40:14.284] __error = [15:40:14.284] __error = [15:40:14.284] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [15:40:14.284] 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 = " , "\241\203!\b\000\000\000he\374)\b\000\000\000\v\000\000\000\000\000\000\000^\357\374)\b", '\000' , "@\241\203!\b\000\000\000\204k\210\000\000\000\000\000P\241\203!\b", '\000' }, salen = 16}} [15:40:14.284] i = 0 [15:40:14.284] now = [15:40:14.284] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 719965314, events = 8, fd = 0, user_data = 0x82183a050}, {pos = 861496792, events = 8, fd = 562274016, user_data = 0x0}, {pos = -1190784246, events = 11221, fd = 719132576, user_data = 0x82ade2d78}, {pos = 562273112, events = 8, fd = 562273232, user_data = 0x821839b58}, {pos = -1190784246, events = 11221, fd = 719111048, user_data = 0x82ade2d78}, {pos = 562273160, events = 8, fd = 562273280, user_data = 0x821839b88}, {pos = 719171988, events = 8, fd = 567931912, user_data = 0x82addb194}, {pos = 562273264, events = 8, fd = -1190804422, user_data = 0x821839b90}, {pos = 704398352, events = 8, fd = 720994352, user_data = 0x2bd5b906130a}, {pos = 719079512, events = 8, fd = 719203704, user_data = 0x821839bf8}, {pos = 562273392, events = 8, fd = 562273272, user_data = 0x82add9d0c}, {pos = 567931912, events = 8, fd = 719166732, user_data = 0x821839c60}, {pos = -1190804422, events = 11221, fd = 562273416, user_data = 0x821839e58}, {pos = 562273392, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821da5038}, {pos = 1, events = 1057000399, fd = 567931912, user_data = 0x82adcc388}, {pos = 567953352, events = 8, fd = 0, user_data = 0x0}, {pos = 562273528, events = 8, fd = 562273992, user_data = 0x821839ce0}, {pos = -1190785886, events = 11221, fd = 2700599, user_data = 0x6d68b}, {pos = 2090263927, events = 1057000399, fd = 567955512, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821839fc8}, {pos = 567931912, events = 3, fd = 562274064, user_data = 0x821da4828}, {pos = 656, events = 0, fd = 562273992, user_data = 0x821839cf8}, {pos = 562273632, events = 8, fd = -1190786277, user_data = 0x821839e90}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567955512, events = 8, fd = 1, user_data = 0x821d9f408}, {pos = 719079512, events = 8, fd = 562274248, user_data = 0x821839f10}, {pos = 562273648, events = 8, fd = 0, user_data = 0x821d98008}, {pos = 33, events = 0, fd = 562274048, user_data = 0x2bd5b905aae7}, {pos = 567902216, events = 8, fd = 567903240, user_data = 0x821d98808}, {pos = 567905288, events = 8, fd = 567918600, user_data = 0x821d9c408}, {pos = 567920648, events = 8, fd = 567921672, user_data = 0x821d9d008}, {pos = 567923720, events = 8, fd = 567924744, user_data = 0x821d9dc08}, {pos = 567926792, events = 8, fd = 567927816, user_data = 0x821d9e808}, {pos = 567929864, events = 8, fd = 567930888, user_data = 0x821d9f408}, {pos = 567932936, events = 8, fd = 567933960, user_data = 0x821da0008}, {pos = 567936008, events = 8, fd = 567937032, user_data = 0x821da0c08}, {pos = 567939080, events = 8, fd = 567940104, user_data = 0x821da1808}, {pos = 567942152, events = 8, fd = 567947272, user_data = 0x821da3408}, {pos = 567949320, events = 8, fd = 567950344, user_data = 0x821da6408}, {pos = 306152000, events = 0, fd = 567902216, user_data = 0x293537}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821da5038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 562274248, events = 8, fd = 562273648, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 567955512, user_data = 0x1}, {pos = 567902216, events = 8, fd = 313, user_data = 0x821839fb0}, {pos = -1190812177, events = 11221, fd = 2700599, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 567955512, user_data = 0x1}, {pos = 567931912, events = 8, fd = 861024256, user_data = 0x1}, {pos = 861024660, events = 8, fd = 0, user_data = 0x821839f80}, {pos = 704439660, events = 8, fd = 1, user_data = 0x833523000}, {pos = 562274224, events = 8, fd = 704435970, user_data = 0x82aef6170 }, {pos = 12282560, events = 0, fd = 720331120, user_data = 0x821d9f408}, {pos = 562274448, events = 8, fd = -1190812706, user_data = 0x833541800}, {pos = 1, events = 0, fd = -1190813090, user_data = 0x821d98008}, {pos = 562274232, events = 8, fd = 562274448, user_data = 0x1c20}, {pos = 861092896, events = 8, fd = -1190733424, user_data = 0x0}, {pos = 562234239, events = 8, fd = 8090775, user_data = 0x82183a040}, {pos = 704398352, events = 8, fd = 720994352, user_data = 0x82af9a310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82183a070}, {pos = 704441245, events = 8, fd = 861024256, user_data = 0x361a}, {pos = 562274512, events = 8, fd = 704407802, user_data = 0x0}, {pos = 0, events = 0, fd = 970297827, user_data = 0x0}} [15:40:14.284] last_touch_time = 1726241781 [15:40:14.284] last_lockfile_recheck_time = 1726241781 [15:40:14.284] nevents = 1 [15:40:14.284] #22 0x0000000000888fb5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82183a6b8) at ../src/backend/postmaster/postmaster.c:1346 [15:40:14.284] userDoption = [15:40:14.284] listen_addr_saved = [15:40:14.284] output_config_variable = [15:40:14.284] opt = [15:40:14.284] status = [15:40:14.284] #23 0x00000000007c417c in main (argc=4, argv=0x82183a6b8) at ../src/backend/main/main.c:197 [15:40:14.284] do_check_root =