[11:57:08.578] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [11:57:08.973] dumping /tmp/cores/postgres.10711.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [11:57:09.113] [New LWP 101901] [11:57:09.215] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [11:57:09.215] Program terminated with signal SIGABRT, Aborted. [11:57:09.215] Sent by thr_kill() from pid 10711 and user 1003. [11:57:09.215] #0 0x000000082a47441a in thr_kill () from /lib/libc.so.7 [11:57:09.886] [11:57:09.886] Thread 1 (LWP 101901): [11:57:09.886] #0 0x000000082a47441a in thr_kill () from /lib/libc.so.7 [11:57:09.886] No symbol table info available. [11:57:09.886] #1 0x000000082a3ede64 in raise () from /lib/libc.so.7 [11:57:09.886] No symbol table info available. [11:57:09.886] #2 0x000000082a49e6f9 in abort () from /lib/libc.so.7 [11:57:09.886] No symbol table info available. [11:57:09.886] #3 0x0000000000a8ba75 in ExceptionalCondition (conditionName=0x2e7225 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [11:57:09.886] No locals. [11:57:09.886] #4 0x0000000000760fc9 in standard_ExecutorStart (queryDesc=0x833d21088, eflags=0) at ../src/backend/executor/execMain.c:191 [11:57:09.886] estate = 0x833dd4100 [11:57:09.886] oldcontext = 0x840957800 [11:57:09.886] #5 0x00000000006f7dd5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [11:57:09.886] copied_query = [11:57:09.886] rewritten = [11:57:09.886] plan = 0x833dfabd8 [11:57:09.886] queryDesc = 0x833d21088 [11:57:09.886] processed = [11:57:09.886] __error = [11:57:09.886] #6 RefreshMatViewByOid (matviewOid=27274, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [11:57:09.886] dest = [11:57:09.886] save_userid = 10 [11:57:09.886] save_sec_context = 0 [11:57:09.886] processed = 0 [11:57:09.886] matviewRel = 0x840923118 [11:57:09.886] relowner = 10 [11:57:09.886] save_nestlevel = 2 [11:57:09.886] rule = [11:57:09.886] actions = [11:57:09.886] dataQuery = [11:57:09.886] tableSpace = [11:57:09.886] relpersistence = [11:57:09.886] OIDNewHeap = 27281 [11:57:09.886] address = [11:57:09.886] #7 0x00000000006f79b6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [11:57:09.886] lockmode = [11:57:09.886] matviewOid = 0 [11:57:09.886] #8 0x00000000006cf78c in ExecCreateTableAs (pstate=pstate@entry=0x840957900, stmt=stmt@entry=0x840a0dfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820f2c530) at ../src/backend/commands/createas.c:350 [11:57:09.886] refresh = 0x0 [11:57:09.886] query = 0x8409860d8 [11:57:09.886] into = 0x840986420 [11:57:09.886] do_refresh = false [11:57:09.886] address = [11:57:09.886] dest = [11:57:09.886] is_matview = [11:57:09.886] #9 0x00000000009389d8 in ProcessUtilitySlow (pstate=pstate@entry=0x840957900, pstmt=pstmt@entry=0x833c7ca68, queryString=queryString@entry=0x833c7b100 "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=0x820f2c530) at ../src/backend/tcop/utility.c:1675 [11:57:09.886] _local_sigjmp_buf = {{_sjb = {9667081, 0, 34912518488, 34912518864, 34912518496, 12348808, 0, 35443276032, 4294902655, 34912518604, 34912518640, 0}}} [11:57:09.886] _save_exception_stack = 0x820f2c430 [11:57:09.886] _save_context_stack = 0x0 [11:57:09.886] _do_rethrow = false [11:57:09.886] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [11:57:09.886] parsetree = 0x840a0dfd0 [11:57:09.886] commandCollected = false [11:57:09.886] needCleanup = false [11:57:09.886] address = [11:57:09.886] isTopLevel = [11:57:09.886] isCompleteQuery = [11:57:09.886] #10 0x0000000000937358 in standard_ProcessUtility (pstmt=0x833c7ca68, queryString=0x833c7b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x840986908, qc=0x820f2c530) at ../src/backend/tcop/utility.c:1030 [11:57:09.886] isAtomicContext = false [11:57:09.886] parsetree = 0x840a0dfd0 [11:57:09.886] readonly_flags = [11:57:09.886] pstate = 0x840957900 [11:57:09.886] isTopLevel = [11:57:09.886] #11 0x0000000000936de8 in ProcessUtility (pstmt=0x18e0d, queryString=0x6 , readOnlyTree=, context=709313530, params=0x0, queryEnv=0x0, dest=0x840986908, qc=0x820f2c530) at ../src/backend/tcop/utility.c:523 [11:57:09.886] No locals. [11:57:09.886] #12 0x0000000000936923 in PortalRunUtility (portal=0x833d52100, pstmt=0x833c7ca68, isTopLevel=, setHoldSnapshot=, dest=0x840986908, qc=0x820f2c530) at ../src/backend/tcop/pquery.c:1158 [11:57:09.886] No locals. [11:57:09.886] #13 0x0000000000935fb4 in PortalRunMulti (portal=portal@entry=0x833d52100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x840986908, altdest=altdest@entry=0x840986908, qc=0x820f2c530) at ../src/backend/tcop/pquery.c:1323 [11:57:09.886] pstmt = 0x833c7ca68 [11:57:09.886] stmtlist_item__state = {l = 0x8409868b8, i = 0} [11:57:09.886] active_snapshot_set = false [11:57:09.886] stmtlist_item = 0x8409868d0 [11:57:09.886] #14 0x0000000000935883 in PortalRun (portal=portal@entry=0x833d52100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x840986908, altdest=altdest@entry=0x840986908, qc=0x820f2c530) at ../src/backend/tcop/pquery.c:791 [11:57:09.886] _local_sigjmp_buf = {{_sjb = {9656317, 35229344000, 34912519208, 34912519440, 34912519216, 35229360128, 12315480, 12348808, 35229336447, 35444016528, 4294967984, 0}}} [11:57:09.886] _save_exception_stack = 0x820f2c600 [11:57:09.886] _save_context_stack = 0x0 [11:57:09.886] _do_rethrow = false [11:57:09.886] saveTopTransactionResourceOwner = 0x833d63918 [11:57:09.886] saveTopTransactionContext = 0x833d56000 [11:57:09.886] saveActivePortal = 0x0 [11:57:09.886] saveResourceOwner = 0x833d63918 [11:57:09.886] savePortalContext = 0x0 [11:57:09.886] saveMemoryContext = 0x833d56000 [11:57:09.886] result = [11:57:09.886] nprocessed = [11:57:09.886] #15 0x0000000000934722 in exec_simple_query (query_string=query_string@entry=0x833c7b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [11:57:09.886] cmdtaglen = 24 [11:57:09.886] snapshot_set = [11:57:09.886] per_parsetree_context = 0x0 [11:57:09.886] plantree_list = [11:57:09.886] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:57:09.886] format = 0 [11:57:09.886] parsetree = 0x833c7c6a8 [11:57:09.886] commandTag = [11:57:09.886] cmdtagname = [11:57:09.886] querytree_list = [11:57:09.886] portal = 0x833d52100 [11:57:09.886] receiver = 0x840986908 [11:57:09.886] parsetree_item__state = {l = 0x833c7ca18, i = 0} [11:57:09.886] msec_str = "\000\000\000\000\b", '\000' , "\236\312\346f\000\000\000\000\332\377|\275\376\311\033\210" [11:57:09.886] dest = DestRemote [11:57:09.886] was_logged = [11:57:09.886] oldcontext = 0x833d56000 [11:57:09.886] parsetree_list = 0x833c7ca18 [11:57:09.886] use_implicit_block = false [11:57:09.886] parsetree_item = 0x833c7ca30 [11:57:09.886] save_log_statement_stats = [11:57:09.886] #16 0x0000000000932490 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [11:57:09.886] query_string = 0x833c7b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [11:57:09.886] input_message = {data = 0x833c7b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [11:57:09.886] firstchar = [11:57:09.886] local_sigjmp_buf = {{_sjb = {9640230, 34912519680, 34912519640, 34912520224, 12357544, 1, 8192, 8388608, 34912469887, 0, 0, 1}}} [11:57:09.886] send_ready_for_query = false [11:57:09.886] idle_in_transaction_timeout_enabled = false [11:57:09.886] idle_session_timeout_enabled = false [11:57:09.886] #17 0x000000000092cc69 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [11:57:09.886] bsdata = [11:57:09.886] #18 0x0000000000886de7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820f2d344 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f2d280) at ../src/backend/postmaster/launch_backend.c:274 [11:57:09.886] pid = [11:57:09.886] #19 0x000000000088b1a8 in BackendStartup (client_sock=0x820f2d280) at ../src/backend/postmaster/postmaster.c:3415 [11:57:09.886] startup_data = {canAcceptConnections = CAC_OK} [11:57:09.886] bn = 0x833c873f8 [11:57:09.886] pid = [11:57:09.886] __error = [11:57:09.886] save_errno = [11:57:09.886] __error = [11:57:09.886] __error = [11:57:09.886] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [11:57:09.886] 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\317\3073\b", '\000' , "\340\322\362 \b\000\000\000h\265\n*\b\000\000\000\v\000\000\000\000\000\000\000^?\v*\b", '\000' , " \323\362 \b\000\000\000\224k\210\000\000\000\000\0000\323\362 \b", '\000' }, salen = 16}} [11:57:09.886] i = 0 [11:57:09.886] now = [11:57:09.886] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 708938882, events = 8, fd = 0, user_data = 0x820f2d230}, {pos = 869103064, events = 8, fd = 552784064, user_data = 0x0}, {pos = 0, events = 0, fd = -1266828933, user_data = 0x2bf71450130a}, {pos = 708106144, events = 8, fd = 708177272, user_data = 0x820f2cd48}, {pos = 552783296, events = 8, fd = 552783176, user_data = 0x2bf71450130a}, {pos = 708084616, events = 8, fd = 708177272, user_data = 0x820f2cd78}, {pos = 552783344, events = 8, fd = 552783224, user_data = 0x82a357194}, {pos = 558756872, events = 8, fd = 708145556, user_data = 0x820f2cde0}, {pos = 340771898, events = 11255, fd = 709967920, user_data = 0x1}, {pos = 552783376, events = 8, fd = 340792074, user_data = 0x82a340858}, {pos = 708177272, events = 8, fd = 552783336, user_data = 0x820f2ce60}, {pos = 552783336, events = 8, fd = 708140300, user_data = 0x8214df408}, {pos = 708140300, events = 8, fd = 552783440, user_data = 0x2bf7144fc43a}, {pos = 552783480, events = 8, fd = 552783928, user_data = 0x820f2ce60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 243463693, fd = 558780472, user_data = 0x800000001}, {pos = 558756872, events = 8, fd = 708084616, user_data = 0x8214e4288}, {pos = 708053080, events = 8, fd = 558756872, user_data = 0x820f2cee8}, {pos = 552784040, events = 8, fd = 552783568, user_data = 0x2bf714500ca2}, {pos = 2700599, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 558780472, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 552784296, user_data = 0x214df408}, {pos = 552784112, events = 8, fd = 552783712, user_data = 0x1}, {pos = 552784040, events = 8, fd = 32, user_data = 0x820f2cf50}, {pos = 340789875, events = 11255, fd = 552783984, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8214e5038}, {pos = 1, events = 8, fd = 558756872, user_data = 0x82a340858}, {pos = 552784296, events = 8, fd = 552784112, user_data = 0x820f2cf60}, {pos = 0, events = 0, fd = 558727176, user_data = 0x20}, {pos = 552784096, events = 8, fd = 340765415, user_data = 0x8214d8008}, {pos = 558728200, events = 8, fd = 558729224, user_data = 0x8214d8c08}, {pos = 558743560, events = 8, fd = 558744584, user_data = 0x8214dc808}, {pos = 558746632, events = 8, fd = 558747656, user_data = 0x8214dd408}, {pos = 558749704, events = 8, fd = 558750728, user_data = 0x8214de008}, {pos = 558752776, events = 8, fd = 558753800, user_data = 0x8214dec08}, {pos = 558755848, events = 8, fd = 558756872, user_data = 0x8214df808}, {pos = 558758920, events = 8, fd = 558759944, user_data = 0x8214e0408}, {pos = 558761992, events = 8, fd = 558763016, user_data = 0x8214e1008}, {pos = 558765064, events = 8, fd = 558766088, user_data = 0x8214e1c08}, {pos = 558772232, events = 8, fd = 558773256, user_data = 0x8214e3808}, {pos = 558775304, events = 8, fd = 558727176, user_data = 0x293537}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8214e5038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552784296, events = 8, fd = 552783712, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 558780472, user_data = 0x1}, {pos = 558727176, events = 8, fd = 313, user_data = 0x820f2d190}, {pos = 340764143, events = 11255, fd = 2700599, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 558780472, user_data = 0x1}, {pos = 558756872, events = 8, fd = 868659200, user_data = 0x1}, {pos = 868659604, events = 8, fd = 0, user_data = 0x820f2d160}, {pos = 705377644, events = 8, fd = 1, user_data = 0x833c6b000}, {pos = 552784272, events = 8, fd = 705373954, user_data = 0x82a472170 }, {pos = 12282576, events = 0, fd = 709304688, user_data = 0x8214df408}, {pos = 552784496, events = 8, fd = 340763614, user_data = 0x833c89800}, {pos = 1, events = 0, fd = 340763230, user_data = 0x8214d8008}, {pos = 552784280, events = 8, fd = 552784496, user_data = 0x1c20}, {pos = 868732672, events = 8, fd = 340842896, user_data = 0x0}, {pos = 552731519, events = 8, fd = 8090791, user_data = 0x820f2d220}, {pos = 705336336, events = 8, fd = 709967920, user_data = 0x82a516310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820f2d250}, {pos = 705379229, events = 8, fd = 868659200, user_data = 0x1dbf}, {pos = 552784560, events = 8, fd = 705345786, user_data = 0x0}, {pos = 0, events = 0, fd = -1266828933, user_data = 0x0}} [11:57:09.886] last_touch_time = 1726401161 [11:57:09.886] last_lockfile_recheck_time = 1726401161 [11:57:09.886] nevents = 1 [11:57:09.886] #21 0x0000000000888fc5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820f2d898) at ../src/backend/postmaster/postmaster.c:1346 [11:57:09.886] userDoption = [11:57:09.886] listen_addr_saved = [11:57:09.886] output_config_variable = [11:57:09.886] opt = [11:57:09.886] status = [11:57:09.886] #22 0x00000000007c418c in main (argc=8, argv=0x820f2d898) at ../src/backend/main/main.c:197 [11:57:09.886] do_check_root = [11:57:09.900] [11:57:09.900] [11:57:09.900] [11:57:09.968] dumping /tmp/cores/postgres.11326.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [11:57:10.101] [New LWP 101888] [11:57:10.170] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [11:57:10.170] Program terminated with signal SIGABRT, Aborted. [11:57:10.170] Sent by thr_kill() from pid 11326 and user 1003. [11:57:10.170] #0 0x000000082acf841a in thr_kill () from /lib/libc.so.7 [11:57:10.822] [11:57:10.822] Thread 1 (LWP 101888): [11:57:10.822] #0 0x000000082acf841a in thr_kill () from /lib/libc.so.7 [11:57:10.822] No symbol table info available. [11:57:10.822] #1 0x000000082ac71e64 in raise () from /lib/libc.so.7 [11:57:10.822] No symbol table info available. [11:57:10.822] #2 0x000000082ad226f9 in abort () from /lib/libc.so.7 [11:57:10.822] No symbol table info available. [11:57:10.822] #3 0x0000000000a8ba75 in ExceptionalCondition (conditionName=0x2e7225 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [11:57:10.822] No locals. [11:57:10.822] #4 0x0000000000760fc9 in standard_ExecutorStart (queryDesc=0x834bd1088, eflags=0) at ../src/backend/executor/execMain.c:191 [11:57:10.822] estate = 0x834bdd100 [11:57:10.822] oldcontext = 0x834cde400 [11:57:10.822] #5 0x00000000006f7dd5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [11:57:10.822] copied_query = [11:57:10.822] rewritten = [11:57:10.822] plan = 0x834c18bd8 [11:57:10.822] queryDesc = 0x834bd1088 [11:57:10.822] processed = [11:57:10.822] __error = [11:57:10.822] #6 RefreshMatViewByOid (matviewOid=27349, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [11:57:10.822] dest = [11:57:10.822] save_userid = 10 [11:57:10.822] save_sec_context = 0 [11:57:10.822] processed = 0 [11:57:10.822] matviewRel = 0x840f612f8 [11:57:10.822] relowner = 10 [11:57:10.822] save_nestlevel = 2 [11:57:10.822] rule = [11:57:10.822] actions = [11:57:10.822] dataQuery = [11:57:10.822] tableSpace = [11:57:10.822] relpersistence = [11:57:10.822] OIDNewHeap = 27376 [11:57:10.822] address = [11:57:10.822] #7 0x00000000006f79b6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [11:57:10.822] lockmode = [11:57:10.822] matviewOid = 0 [11:57:10.822] #8 0x00000000006cf78c in ExecCreateTableAs (pstate=pstate@entry=0x834cde500, stmt=stmt@entry=0x834be1fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821637c00) at ../src/backend/commands/createas.c:350 [11:57:10.822] refresh = 0x0 [11:57:10.822] query = 0x840edfed8 [11:57:10.822] into = 0x840ee0220 [11:57:10.822] do_refresh = false [11:57:10.822] address = [11:57:10.822] dest = [11:57:10.822] is_matview = [11:57:10.822] #9 0x00000000009389d8 in ProcessUtilitySlow (pstate=pstate@entry=0x834cde500, pstmt=pstmt@entry=0x834b08a68, queryString=queryString@entry=0x834b07100 "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=0x821637c00) at ../src/backend/tcop/utility.c:1675 [11:57:10.822] _local_sigjmp_buf = {{_sjb = {9667081, 0, 34919905320, 34919905696, 34919905328, 12348808, 0, 35245647104, 4294902655, 34919905436, 34919905472, 0}}} [11:57:10.822] _save_exception_stack = 0x821637b00 [11:57:10.822] _save_context_stack = 0x0 [11:57:10.822] _do_rethrow = false [11:57:10.822] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [11:57:10.822] parsetree = 0x834be1fd0 [11:57:10.822] commandCollected = false [11:57:10.822] needCleanup = false [11:57:10.822] address = [11:57:10.822] isTopLevel = [11:57:10.822] isCompleteQuery = [11:57:10.822] #10 0x0000000000937358 in standard_ProcessUtility (pstmt=0x834b08a68, queryString=0x834b07100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x840ee0708, qc=0x821637c00) at ../src/backend/tcop/utility.c:1030 [11:57:10.822] isAtomicContext = false [11:57:10.822] parsetree = 0x834be1fd0 [11:57:10.822] readonly_flags = [11:57:10.822] pstate = 0x834cde500 [11:57:10.822] isTopLevel = [11:57:10.822] #11 0x0000000000936de8 in ProcessUtility (pstmt=0x18e00, queryString=0x6 , readOnlyTree=, context=718242810, params=0x0, queryEnv=0x0, dest=0x840ee0708, qc=0x821637c00) at ../src/backend/tcop/utility.c:523 [11:57:10.822] No locals. [11:57:10.822] #12 0x0000000000936923 in PortalRunUtility (portal=0x834bad100, pstmt=0x834b08a68, isTopLevel=, setHoldSnapshot=, dest=0x840ee0708, qc=0x821637c00) at ../src/backend/tcop/pquery.c:1158 [11:57:10.822] No locals. [11:57:10.822] #13 0x0000000000935fb4 in PortalRunMulti (portal=portal@entry=0x834bad100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x840ee0708, altdest=altdest@entry=0x840ee0708, qc=0x821637c00) at ../src/backend/tcop/pquery.c:1323 [11:57:10.822] pstmt = 0x834b08a68 [11:57:10.822] stmtlist_item__state = {l = 0x840ee06b8, i = 0} [11:57:10.822] active_snapshot_set = false [11:57:10.822] stmtlist_item = 0x840ee06d0 [11:57:10.822] #14 0x0000000000935883 in PortalRun (portal=portal@entry=0x834bad100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x840ee0708, altdest=altdest@entry=0x840ee0708, qc=0x821637c00) at ../src/backend/tcop/pquery.c:791 [11:57:10.822] _local_sigjmp_buf = {{_sjb = {9656317, 35244396800, 34919906040, 34919906272, 34919906048, 35244498944, 12315480, 12348808, 35244344191, 35244606864, 4294967984, 0}}} [11:57:10.822] _save_exception_stack = 0x821637cd0 [11:57:10.822] _save_context_stack = 0x0 [11:57:10.822] _do_rethrow = false [11:57:10.822] saveTopTransactionResourceOwner = 0x834bfcf58 [11:57:10.822] saveTopTransactionContext = 0x834bc6000 [11:57:10.822] saveActivePortal = 0x0 [11:57:10.822] saveResourceOwner = 0x834bfcf58 [11:57:10.822] savePortalContext = 0x0 [11:57:10.822] saveMemoryContext = 0x834bc6000 [11:57:10.822] result = [11:57:10.822] nprocessed = [11:57:10.822] #15 0x0000000000934722 in exec_simple_query (query_string=query_string@entry=0x834b07100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [11:57:10.822] cmdtaglen = 24 [11:57:10.822] snapshot_set = [11:57:10.822] per_parsetree_context = 0x0 [11:57:10.822] plantree_list = [11:57:10.822] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:57:10.822] format = 0 [11:57:10.822] parsetree = 0x834b086a8 [11:57:10.822] commandTag = [11:57:10.822] cmdtagname = [11:57:10.822] querytree_list = [11:57:10.822] portal = 0x834bad100 [11:57:10.822] receiver = 0x840ee0708 [11:57:10.822] parsetree_item__state = {l = 0x834b08a18, i = 0} [11:57:10.822] msec_str = "\000\000\000\000\b", '\000' , "\241\312\346f\000\000\000\000\312x)\276\206E", [11:57:10.822] dest = DestRemote [11:57:10.822] was_logged = [11:57:10.822] oldcontext = 0x834bc6000 [11:57:10.822] parsetree_list = 0x834b08a18 [11:57:10.822] use_implicit_block = false [11:57:10.822] parsetree_item = 0x834b08a30 [11:57:10.822] save_log_statement_stats = [11:57:10.822] #16 0x0000000000932490 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [11:57:10.822] query_string = 0x834b07100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [11:57:10.822] input_message = {data = 0x834b07100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [11:57:10.822] firstchar = [11:57:10.822] local_sigjmp_buf = {{_sjb = {9640230, 34919906512, 34919906472, 34919907056, 12357544, 1, 8192, 8388608, 34919875455, 0, 0, 1}}} [11:57:10.822] send_ready_for_query = false [11:57:10.822] idle_in_transaction_timeout_enabled = false [11:57:10.822] idle_session_timeout_enabled = false [11:57:10.822] #17 0x000000000092cc69 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [11:57:10.822] bsdata = [11:57:10.822] #18 0x0000000000886de7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821638a14 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821638950) at ../src/backend/postmaster/launch_backend.c:274 [11:57:10.822] pid = [11:57:10.822] #19 0x000000000088b1a8 in BackendStartup (client_sock=0x821638950) at ../src/backend/postmaster/postmaster.c:3415 [11:57:10.822] startup_data = {canAcceptConnections = CAC_OK} [11:57:10.822] bn = 0x834b13498 [11:57:10.822] pid = [11:57:10.822] __error = [11:57:10.822] save_errno = [11:57:10.822] __error = [11:57:10.822] __error = [11:57:10.822] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [11:57:10.822] 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\216\2604\b", '\000' , "\260\211c!\b\000\000\000hu4)\b\000\000\000\v\000\000\000\000\000\000\000^\3774)\b", '\000' , "\360\211c!\b\000\000\000\224k\210\000\000\000\000\000\000\212c!\b", '\000' }, salen = 16}} [11:57:10.822] i = 0 [11:57:10.822] now = [11:57:10.822] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 717868162, events = 8, fd = 0, user_data = 0x821638900}, {pos = 884413912, events = 8, fd = 560170896, user_data = 0x0}, {pos = 0, events = 0, fd = -926712187, user_data = 0x399eace8830a}, {pos = 717035424, events = 8, fd = 717106552, user_data = 0x821638418}, {pos = 560170128, events = 8, fd = 560170008, user_data = 0x399eace8830a}, {pos = 717013896, events = 8, fd = 717106552, user_data = 0x821638448}, {pos = 560170176, events = 8, fd = 560170056, user_data = 0x82abdb194}, {pos = 560378888, events = 8, fd = 717074836, user_data = 0x8216384b0}, {pos = -1394068422, events = 14750, fd = 718897200, user_data = 0x1}, {pos = 560170208, events = 8, fd = -1394048246, user_data = 0x82abc4858}, {pos = 717106552, events = 8, fd = 560170168, user_data = 0x821638530}, {pos = 560170168, events = 8, fd = 717069580, user_data = 0x82166b408}, {pos = 717069580, events = 8, fd = 560170272, user_data = 0x399eace8343a}, {pos = 560170312, events = 8, fd = 560170760, user_data = 0x821638530}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 672104689, fd = 560402488, user_data = 0x800000001}, {pos = 560378888, events = 8, fd = 717013896, user_data = 0x821670288}, {pos = 716982360, events = 8, fd = 560378888, user_data = 0x8216385b8}, {pos = 560170872, events = 8, fd = 560170400, user_data = 0x399eace87ca2}, {pos = 2700599, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560402488, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 560171128, user_data = 0x2166b408}, {pos = 560170944, events = 8, fd = 560170544, user_data = 0x1}, {pos = 560170872, events = 8, fd = 32, user_data = 0x821638620}, {pos = -1394050445, events = 14750, fd = 560170816, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821671038}, {pos = 1, events = 8, fd = 560378888, user_data = 0x82abc4858}, {pos = 560171128, events = 8, fd = 560170944, user_data = 0x821638630}, {pos = 0, events = 0, fd = 560349192, user_data = 0x20}, {pos = 560170928, events = 8, fd = -1394074905, user_data = 0x821664008}, {pos = 560350216, events = 8, fd = 560351240, user_data = 0x821664c08}, {pos = 560365576, events = 8, fd = 560366600, user_data = 0x821668808}, {pos = 560368648, events = 8, fd = 560369672, user_data = 0x821669408}, {pos = 560371720, events = 8, fd = 560372744, user_data = 0x82166a008}, {pos = 560374792, events = 8, fd = 560375816, user_data = 0x82166ac08}, {pos = 560377864, events = 8, fd = 560378888, user_data = 0x82166b808}, {pos = 560380936, events = 8, fd = 560381960, user_data = 0x82166c408}, {pos = 560384008, events = 8, fd = 560385032, user_data = 0x82166d008}, {pos = 560387080, events = 8, fd = 560388104, user_data = 0x82166dc08}, {pos = 560394248, events = 8, fd = 560395272, user_data = 0x82166f808}, {pos = 560397320, events = 8, fd = 560349192, user_data = 0x293537}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821671038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 560171128, events = 8, fd = 560170544, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560402488, user_data = 0x1}, {pos = 560349192, events = 8, fd = 313, user_data = 0x821638860}, {pos = -1394076177, events = 14750, fd = 2700599, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560402488, user_data = 0x1}, {pos = 560378888, events = 8, fd = 883912704, user_data = 0x1}, {pos = 883913108, events = 8, fd = 0, user_data = 0x821638830}, {pos = 691336556, events = 8, fd = 1, user_data = 0x834af7000}, {pos = 560171104, events = 8, fd = 691332866, user_data = 0x82acf6170 }, {pos = 12282576, events = 0, fd = 718233968, user_data = 0x82166b408}, {pos = 560171328, events = 8, fd = -1394076706, user_data = 0x834b15800}, {pos = 1, events = 0, fd = -1394077090, user_data = 0x821664008}, {pos = 560171112, events = 8, fd = 560171328, user_data = 0x1c20}, {pos = 883986112, events = 8, fd = -1393997424, user_data = 0x0}, {pos = 560137087, events = 8, fd = 8090791, user_data = 0x8216388f0}, {pos = 691295248, events = 8, fd = 718897200, user_data = 0x82ad9a310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821638920}, {pos = 691338141, events = 8, fd = 883912704, user_data = 0x1e25}, {pos = 560171392, events = 8, fd = 691304698, user_data = 0x0}, {pos = 0, events = 0, fd = -926712187, user_data = 0x0}} [11:57:10.823] last_touch_time = 1726401162 [11:57:10.823] last_lockfile_recheck_time = 1726401162 [11:57:10.823] nevents = 1 [11:57:10.823] #21 0x0000000000888fc5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821638f60) at ../src/backend/postmaster/postmaster.c:1346 [11:57:10.823] userDoption = [11:57:10.823] listen_addr_saved = [11:57:10.823] output_config_variable = [11:57:10.823] opt = [11:57:10.823] status = [11:57:10.823] #22 0x00000000007c418c in main (argc=4, argv=0x821638f60) at ../src/backend/main/main.c:197 [11:57:10.823] do_check_root = [11:57:10.837] [11:57:10.837] [11:57:10.837] [11:57:10.908] dumping /tmp/cores/postgres.17699.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [11:57:11.038] [New LWP 101854] [11:57:11.114] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [11:57:11.114] Program terminated with signal SIGABRT, Aborted. [11:57:11.114] Sent by thr_kill() from pid 17699 and user 1003. [11:57:11.114] #0 0x000000082b83b41a in thr_kill () from /lib/libc.so.7 [11:57:11.750] [11:57:11.750] Thread 1 (LWP 101854): [11:57:11.750] #0 0x000000082b83b41a in thr_kill () from /lib/libc.so.7 [11:57:11.750] No symbol table info available. [11:57:11.750] #1 0x000000082b7b4e64 in raise () from /lib/libc.so.7 [11:57:11.750] No symbol table info available. [11:57:11.750] #2 0x000000082b8656f9 in abort () from /lib/libc.so.7 [11:57:11.750] No symbol table info available. [11:57:11.750] #3 0x0000000000a8ba75 in ExceptionalCondition (conditionName=0x2e7225 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [11:57:11.750] No locals. [11:57:11.750] #4 0x0000000000760fc9 in standard_ExecutorStart (queryDesc=0x83a2dd088, eflags=0) at ../src/backend/executor/execMain.c:191 [11:57:11.750] estate = 0x834b0e100 [11:57:11.750] oldcontext = 0x83a1f0800 [11:57:11.750] #5 0x0000000837cb5862 in pgss_ExecutorStart (queryDesc=0x83a2dd088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [11:57:11.750] No locals. [11:57:11.750] #6 0x00000000006f7dd5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [11:57:11.750] copied_query = [11:57:11.750] rewritten = [11:57:11.750] plan = 0x83a20cbd8 [11:57:11.750] queryDesc = 0x83a2dd088 [11:57:11.750] processed = [11:57:11.750] __error = [11:57:11.750] #7 RefreshMatViewByOid (matviewOid=27323, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [11:57:11.750] dest = [11:57:11.750] save_userid = 10 [11:57:11.750] save_sec_context = 0 [11:57:11.750] processed = 0 [11:57:11.750] matviewRel = 0x83a1cc058 [11:57:11.750] relowner = 10 [11:57:11.750] save_nestlevel = 2 [11:57:11.750] rule = [11:57:11.750] actions = [11:57:11.750] dataQuery = [11:57:11.750] tableSpace = [11:57:11.750] relpersistence = [11:57:11.750] OIDNewHeap = 27340 [11:57:11.750] address = [11:57:11.750] #8 0x00000000006f79b6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [11:57:11.750] lockmode = [11:57:11.750] matviewOid = 0 [11:57:11.750] #9 0x00000000006cf78c in ExecCreateTableAs (pstate=pstate@entry=0x83a1f0900, stmt=stmt@entry=0x834a6dfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820d4b0e0) at ../src/backend/commands/createas.c:350 [11:57:11.750] refresh = 0x0 [11:57:11.750] query = 0x834ab8dc8 [11:57:11.750] into = 0x834a6df40 [11:57:11.750] do_refresh = false [11:57:11.750] address = [11:57:11.750] dest = [11:57:11.750] is_matview = [11:57:11.750] #10 0x00000000009389d8 in ProcessUtilitySlow (pstate=pstate@entry=0x83a1f0900, pstmt=pstmt@entry=0x834a6de30, queryString=queryString@entry=0x8349d0100 "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=0x820d4b0e0) at ../src/backend/tcop/utility.c:1675 [11:57:11.750] _local_sigjmp_buf = {{_sjb = {9667081, 0, 34910546760, 34910547136, 34910546768, 12348808, 0, 35334850816, 34910503807, 7, 34910546912, 0}}} [11:57:11.750] _save_exception_stack = 0x820d4add0 [11:57:11.750] _save_context_stack = 0x0 [11:57:11.750] _do_rethrow = false [11:57:11.750] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [11:57:11.750] parsetree = 0x834a6dfd0 [11:57:11.750] commandCollected = false [11:57:11.750] needCleanup = false [11:57:11.750] address = [11:57:11.750] isTopLevel = [11:57:11.750] isCompleteQuery = [11:57:11.750] #11 0x0000000000937358 in standard_ProcessUtility (pstmt=0x834a6de30, queryString=queryString@entry=0x8349d0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834ab9568, qc=0x820d4b0e0) at ../src/backend/tcop/utility.c:1030 [11:57:11.750] isAtomicContext = false [11:57:11.750] parsetree = 0x834a6dfd0 [11:57:11.750] readonly_flags = [11:57:11.750] pstate = 0x83a1f0900 [11:57:11.750] isTopLevel = [11:57:11.750] #12 0x0000000837cb5dee in pgss_ProcessUtility (pstmt=0x834a6de30, queryString=0x8349d0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834ab9568, qc=0x820d4b0e0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [11:57:11.750] _local_sigjmp_buf = {{_sjb = {35295812903, 34910547408, 34910547272, 34910547728, 35243089456, 0, 12348808, 34910547936, 34910503807, 34910547508, 34910547536, 0}}} [11:57:11.750] _save_exception_stack = 0x820d4afe0 [11:57:11.750] _save_context_stack = 0x0 [11:57:11.750] _do_rethrow = false [11:57:11.750] bufusage = {shared_blks_hit = 35295812903, shared_blks_read = 34910547408, shared_blks_dirtied = 34910547272, shared_blks_written = 34910547728, local_blks_hit = 35243089456, local_blks_read = 0, local_blks_dirtied = 12348808, local_blks_written = 34910547936, temp_blks_read = 34910503807, temp_blks_written = 34910547508, shared_blk_read_time = {ticks = 34910547536}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4029645249850325248}, local_blk_write_time = {ticks = 12357848}, temp_blk_read_time = {ticks = 35302151808}, temp_blk_write_time = {ticks = 12311424}} [11:57:11.750] walusage_start = {wal_records = 8944, wal_fpi = 145, wal_bytes = 1349352} [11:57:11.750] duration = [11:57:11.750] bufusage_start = {shared_blks_hit = 150244, shared_blks_read = 8560, shared_blks_dirtied = 2645, shared_blks_written = 2392, 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}} [11:57:11.750] walusage = {wal_records = 960249444961612913, wal_fpi = 35243089872, wal_bytes = 123} [11:57:11.750] start = {ticks = -192523688579} [11:57:11.750] rows = [11:57:11.750] saved_queryId = 6041762721901209185 [11:57:11.750] parsetree = [11:57:11.750] saved_stmt_location = 0 [11:57:11.750] saved_stmt_len = 69 [11:57:11.750] enabled = [11:57:11.750] #13 0x0000000000936923 in PortalRunUtility (portal=0x834a78100, pstmt=0x834a6de30, isTopLevel=, setHoldSnapshot=, dest=0x834ab9568, qc=0x820d4b0e0) at ../src/backend/tcop/pquery.c:1158 [11:57:11.750] No locals. [11:57:11.750] #14 0x0000000000935fb4 in PortalRunMulti (portal=portal@entry=0x834a78100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x834ab9568, altdest=altdest@entry=0x834ab9568, qc=0x820d4b0e0) at ../src/backend/tcop/pquery.c:1323 [11:57:11.750] pstmt = 0x834a6de30 [11:57:11.750] stmtlist_item__state = {l = 0x834ab9518, i = 0} [11:57:11.750] active_snapshot_set = false [11:57:11.750] stmtlist_item = 0x834ab9530 [11:57:11.750] #15 0x0000000000935883 in PortalRun (portal=portal@entry=0x834a78100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x834ab9568, altdest=altdest@entry=0x834ab9568, qc=0x820d4b0e0) at ../src/backend/tcop/pquery.c:791 [11:57:11.750] _local_sigjmp_buf = {{_sjb = {9656317, 35243131136, 34910547928, 34910548160, 34910547936, 35243225088, 12315480, 12348808, 35243099007, 35243083232, 4294967984, 0}}} [11:57:11.750] _save_exception_stack = 0x820d4b1b0 [11:57:11.750] _save_context_stack = 0x0 [11:57:11.750] _do_rethrow = false [11:57:11.750] saveTopTransactionResourceOwner = 0x834ac6858 [11:57:11.750] saveTopTransactionContext = 0x834a8f000 [11:57:11.750] saveActivePortal = 0x0 [11:57:11.750] saveResourceOwner = 0x834ac6858 [11:57:11.750] savePortalContext = 0x0 [11:57:11.750] saveMemoryContext = 0x834a8f000 [11:57:11.750] result = [11:57:11.750] nprocessed = [11:57:11.750] #16 0x0000000000934722 in exec_simple_query (query_string=query_string@entry=0x8349d0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [11:57:11.750] cmdtaglen = 24 [11:57:11.750] snapshot_set = [11:57:11.750] per_parsetree_context = 0x0 [11:57:11.750] plantree_list = [11:57:11.750] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:57:11.750] format = 0 [11:57:11.750] parsetree = 0x8349d16a8 [11:57:11.750] commandTag = [11:57:11.750] cmdtagname = [11:57:11.750] querytree_list = [11:57:11.750] portal = 0x834a78100 [11:57:11.750] receiver = 0x834ab9568 [11:57:11.750] parsetree_item__state = {l = 0x8349d1a18, i = 0} [11:57:11.750] msec_str = "\000\000\000\000\b", '\000' , "\305\312\346f\000\000\000\000ⶌ\370\000", [11:57:11.750] dest = DestRemote [11:57:11.750] was_logged = [11:57:11.750] oldcontext = 0x834a8f000 [11:57:11.750] parsetree_list = 0x8349d1a18 [11:57:11.750] use_implicit_block = false [11:57:11.750] parsetree_item = 0x8349d1a30 [11:57:11.750] save_log_statement_stats = [11:57:11.750] #17 0x0000000000932490 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [11:57:11.750] query_string = 0x8349d0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [11:57:11.750] input_message = {data = 0x8349d0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [11:57:11.750] firstchar = [11:57:11.750] local_sigjmp_buf = {{_sjb = {9640230, 34910548400, 34910548360, 34910548944, 12357544, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [11:57:11.750] send_ready_for_query = false [11:57:11.750] idle_in_transaction_timeout_enabled = false [11:57:11.750] idle_session_timeout_enabled = false [11:57:11.750] #18 0x000000000092cc69 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [11:57:11.750] bsdata = [11:57:11.750] #19 0x0000000000886de7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d4bef4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d4be30) at ../src/backend/postmaster/launch_backend.c:274 [11:57:11.750] pid = [11:57:11.750] #20 0x000000000088b1a8 in BackendStartup (client_sock=0x820d4be30) at ../src/backend/postmaster/postmaster.c:3415 [11:57:11.750] startup_data = {canAcceptConnections = CAC_OK} [11:57:11.750] bn = 0x8349dc128 [11:57:11.750] pid = [11:57:11.750] __error = [11:57:11.750] save_errno = [11:57:11.750] __error = [11:57:11.750] __error = [11:57:11.750] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [11:57:11.750] 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\2354\b", '\000' , "\220\276\324 \b\000\000\000h\265B*\b\000\000\000\v\000\000\000\000\000\000\000^?C*\b", '\000' , "о\324 \b\000\000\000\224k\210\000\000\000\000\000\340\276\324 \b", '\000' }, salen = 16}} [11:57:11.750] i = 0 [11:57:11.750] now = [11:57:11.750] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 729676930, events = 8, fd = 0, user_data = 0x820d4bde0}, {pos = 883111384, events = 8, fd = 550812784, user_data = 0x0}, {pos = 1055499018, events = 2587, fd = 728844192, user_data = 0x82b725d78}, {pos = 550811880, events = 8, fd = 550812000, user_data = 0x820d4b8e8}, {pos = 1055499018, events = 2587, fd = 728822664, user_data = 0x82b725d78}, {pos = 550811928, events = 8, fd = 550812048, user_data = 0x820d4b918}, {pos = 728883604, events = 8, fd = 552371208, user_data = 0x82b71e194}, {pos = 550812032, events = 8, fd = 1055478842, user_data = 0x820d4b920}, {pos = 709006352, events = 8, fd = 730705968, user_data = 0xa1b3ee9a30a}, {pos = 728791128, events = 8, fd = 728915320, user_data = 0x820d4b988}, {pos = 550812160, events = 8, fd = 550812040, user_data = 0x82b71cd0c}, {pos = 552371208, events = 8, fd = 728878348, user_data = 0x820d4b9f0}, {pos = 1055478842, events = 2587, fd = 550812184, user_data = 0x820d4bbe8}, {pos = 550812160, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x820ece038}, {pos = 1, events = 223575496, fd = 552371208, user_data = 0x82b70f388}, {pos = 552392648, events = 8, fd = 0, user_data = 0x0}, {pos = 550812296, events = 8, fd = 550812760, user_data = 0x820d4ba70}, {pos = 1055497378, events = 2587, fd = 2700599, user_data = 0x6d68b}, {pos = 2090263927, events = 223575496, fd = 552394808, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820d4bd58}, {pos = 552371208, events = 3, fd = 550812832, user_data = 0x820ecd828}, {pos = 656, events = 0, fd = 550812760, user_data = 0x820d4ba88}, {pos = 550812400, events = 8, fd = 1055496987, user_data = 0x820d4bc20}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 552394808, events = 8, fd = 1, user_data = 0x820ec8408}, {pos = 728791128, events = 8, fd = 550813016, user_data = 0x820d4bca0}, {pos = 550812416, events = 8, fd = 0, user_data = 0x820ec1008}, {pos = 33, events = 0, fd = 550812816, user_data = 0xa1b3ee93ae7}, {pos = 552341512, events = 8, fd = 552342536, user_data = 0x820ec1808}, {pos = 552344584, events = 8, fd = 552357896, user_data = 0x820ec5408}, {pos = 552359944, events = 8, fd = 552360968, user_data = 0x820ec6008}, {pos = 552363016, events = 8, fd = 552364040, user_data = 0x820ec6c08}, {pos = 552366088, events = 8, fd = 552367112, user_data = 0x820ec7808}, {pos = 552369160, events = 8, fd = 552370184, user_data = 0x820ec8408}, {pos = 552372232, events = 8, fd = 552373256, user_data = 0x820ec9008}, {pos = 552375304, events = 8, fd = 552376328, user_data = 0x820ec9c08}, {pos = 552378376, events = 8, fd = 552379400, user_data = 0x820eca808}, {pos = 552381448, events = 8, fd = 552386568, user_data = 0x820ecc408}, {pos = 552388616, events = 8, fd = 552389640, user_data = 0x820ecf408}, {pos = 280288000, events = 0, fd = 552341512, user_data = 0x293537}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x820ece038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550813016, events = 8, fd = 550812416, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 552394808, user_data = 0x1}, {pos = 552341512, events = 8, fd = 313, user_data = 0x820d4bd40}, {pos = 1055471087, events = 2587, fd = 2700599, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 552394808, user_data = 0x1}, {pos = 552371208, events = 8, fd = 882638848, user_data = 0x1}, {pos = 882639252, events = 8, fd = 0, user_data = 0x820d4bd10}, {pos = 709047660, events = 8, fd = 1, user_data = 0x8349c0000}, {pos = 550812992, events = 8, fd = 709043970, user_data = 0x82b839170 }, {pos = 12282576, events = 0, fd = 730042736, user_data = 0x820ec8408}, {pos = 550813216, events = 8, fd = 1055470558, user_data = 0x8349de800}, {pos = 1, events = 0, fd = 1055470174, user_data = 0x820ec1008}, {pos = 550813000, events = 8, fd = 550813216, user_data = 0x1c20}, {pos = 882707488, events = 8, fd = 1055549840, user_data = 0x0}, {pos = 550765439, events = 8, fd = 8090791, user_data = 0x820d4bdd0}, {pos = 709006352, events = 8, fd = 730705968, user_data = 0x82b8dd310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d4be00}, {pos = 709049245, events = 8, fd = 882638848, user_data = 0x367a}, {pos = 550813280, events = 8, fd = 709015802, user_data = 0x0}, {pos = 0, events = 0, fd = 1454634097, user_data = 0x0}} [11:57:11.751] last_touch_time = 1726401196 [11:57:11.751] last_lockfile_recheck_time = 1726401196 [11:57:11.751] nevents = 1 [11:57:11.751] #22 0x0000000000888fc5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820d4c440) at ../src/backend/postmaster/postmaster.c:1346 [11:57:11.751] userDoption = [11:57:11.751] listen_addr_saved = [11:57:11.751] output_config_variable = [11:57:11.751] opt = [11:57:11.751] status = [11:57:11.751] #23 0x00000000007c418c in main (argc=4, argv=0x820d4c440) at ../src/backend/main/main.c:197 [11:57:11.751] do_check_root =