[21:10:12.022] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [21:10:12.380] dumping /tmp/cores/postgres.10639.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [21:10:12.516] [New LWP 101827] [21:10:12.601] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [21:10:12.601] Program terminated with signal SIGABRT, Aborted. [21:10:12.601] Sent by thr_kill() from pid 10639 and user 1003. [21:10:12.601] #0 0x000000082b09241a in thr_kill () from /lib/libc.so.7 [21:10:13.287] [21:10:13.287] Thread 1 (LWP 101827): [21:10:13.287] #0 0x000000082b09241a in thr_kill () from /lib/libc.so.7 [21:10:13.287] No symbol table info available. [21:10:13.287] #1 0x000000082b00be64 in raise () from /lib/libc.so.7 [21:10:13.287] No symbol table info available. [21:10:13.287] #2 0x000000082b0bc6f9 in abort () from /lib/libc.so.7 [21:10:13.287] No symbol table info available. [21:10:13.287] #3 0x0000000000a89865 in ExceptionalCondition (conditionName=0x2e6199 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [21:10:13.287] No locals. [21:10:13.287] #4 0x000000000075faf9 in standard_ExecutorStart (queryDesc=0x83640d380, eflags=0) at ../src/backend/executor/execMain.c:191 [21:10:13.287] estate = 0x83639a100 [21:10:13.287] oldcontext = 0x8399d5800 [21:10:13.287] #5 0x00000000006f68d2 in refresh_matview_datafill (dest=0x8399d2f38, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [21:10:13.287] copied_query = [21:10:13.287] rewritten = [21:10:13.287] plan = [21:10:13.287] queryDesc = 0x83640d380 [21:10:13.287] processed = [21:10:13.287] __error = [21:10:13.287] #6 RefreshMatViewByOid (matviewOid=27185, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [21:10:13.287] dest = 0x8399d2f38 [21:10:13.287] save_userid = 10 [21:10:13.287] save_sec_context = 0 [21:10:13.287] processed = 0 [21:10:13.287] matviewRel = 0x839997738 [21:10:13.287] relowner = 10 [21:10:13.287] save_nestlevel = 2 [21:10:13.287] rule = [21:10:13.287] actions = [21:10:13.287] dataQuery = [21:10:13.287] tableSpace = [21:10:13.287] relpersistence = [21:10:13.287] OIDNewHeap = 27196 [21:10:13.287] address = [21:10:13.287] #7 0x00000000006f64b6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [21:10:13.287] lockmode = [21:10:13.287] matviewOid = 0 [21:10:13.287] #8 0x00000000006ce2cc in ExecCreateTableAs (pstate=pstate@entry=0x8399d5900, stmt=stmt@entry=0x839aa2fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8215ec800) at ../src/backend/commands/createas.c:350 [21:10:13.287] refresh = 0x0 [21:10:13.287] query = 0x8399be3d8 [21:10:13.287] into = 0x8399be720 [21:10:13.287] do_refresh = false [21:10:13.287] address = [21:10:13.287] dest = [21:10:13.287] is_matview = [21:10:13.287] #9 0x0000000000936af8 in ProcessUtilitySlow (pstate=pstate@entry=0x8399d5900, pstmt=pstmt@entry=0x836292a68, queryString=queryString@entry=0x836291100 "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=0x8215ec800) at ../src/backend/tcop/utility.c:1675 [21:10:13.287] _local_sigjmp_buf = {{_sjb = {9659177, 0, 34919597096, 34919597472, 34919597104, 12338536, 0, 35326351616, 4294902655, 34919597212, 34919597248, 0}}} [21:10:13.287] _save_exception_stack = 0x8215ec700 [21:10:13.287] _save_context_stack = 0x0 [21:10:13.287] _do_rethrow = false [21:10:13.287] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [21:10:13.287] parsetree = 0x839aa2fd0 [21:10:13.287] commandCollected = false [21:10:13.287] needCleanup = false [21:10:13.287] address = [21:10:13.287] isTopLevel = [21:10:13.287] isCompleteQuery = [21:10:13.287] #10 0x0000000000935478 in standard_ProcessUtility (pstmt=0x836292a68, queryString=0x836291100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8399bec08, qc=0x8215ec800) at ../src/backend/tcop/utility.c:1030 [21:10:13.287] isAtomicContext = false [21:10:13.287] parsetree = 0x839aa2fd0 [21:10:13.287] readonly_flags = [21:10:13.287] pstate = 0x8399d5900 [21:10:13.287] isTopLevel = [21:10:13.287] #11 0x0000000000934f08 in ProcessUtility (pstmt=0x18dc3, queryString=0x6 , readOnlyTree=, context=722019322, params=0x0, queryEnv=0x0, dest=0x8399bec08, qc=0x8215ec800) at ../src/backend/tcop/utility.c:523 [21:10:13.287] No locals. [21:10:13.287] #12 0x0000000000934a43 in PortalRunUtility (portal=0x836368100, pstmt=0x836292a68, isTopLevel=, setHoldSnapshot=, dest=0x8399bec08, qc=0x8215ec800) at ../src/backend/tcop/pquery.c:1158 [21:10:13.287] No locals. [21:10:13.287] #13 0x00000000009340d4 in PortalRunMulti (portal=portal@entry=0x836368100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8399bec08, altdest=altdest@entry=0x8399bec08, qc=0x8215ec800) at ../src/backend/tcop/pquery.c:1323 [21:10:13.287] pstmt = 0x836292a68 [21:10:13.287] stmtlist_item__state = {l = 0x8399bebb8, i = 0} [21:10:13.287] active_snapshot_set = false [21:10:13.287] stmtlist_item = 0x8399bebd0 [21:10:13.287] #14 0x00000000009339a3 in PortalRun (portal=portal@entry=0x836368100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8399bec08, altdest=altdest@entry=0x8399bec08, qc=0x8215ec800) at ../src/backend/tcop/pquery.c:791 [21:10:13.287] _local_sigjmp_buf = {{_sjb = {9648413, 35269280000, 34919597816, 34919598048, 34919597824, 35269296128, 12305208, 12338536, 35269247871, 35327186320, 4294967984, 0}}} [21:10:13.287] _save_exception_stack = 0x8215ec8d0 [21:10:13.287] _save_context_stack = 0x0 [21:10:13.287] _do_rethrow = false [21:10:13.287] saveTopTransactionResourceOwner = 0x836379358 [21:10:13.287] saveTopTransactionContext = 0x83636c000 [21:10:13.287] saveActivePortal = 0x0 [21:10:13.287] saveResourceOwner = 0x836379358 [21:10:13.287] savePortalContext = 0x0 [21:10:13.287] saveMemoryContext = 0x83636c000 [21:10:13.287] result = [21:10:13.287] nprocessed = [21:10:13.287] #15 0x0000000000932842 in exec_simple_query (query_string=query_string@entry=0x836291100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [21:10:13.287] cmdtaglen = 24 [21:10:13.287] snapshot_set = [21:10:13.287] per_parsetree_context = 0x0 [21:10:13.287] plantree_list = [21:10:13.287] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:10:13.287] format = 0 [21:10:13.287] parsetree = 0x8362926a8 [21:10:13.287] commandTag = [21:10:13.287] cmdtagname = [21:10:13.287] querytree_list = [21:10:13.287] portal = 0x836368100 [21:10:13.287] receiver = 0x8399bec08 [21:10:13.287] parsetree_item__state = {l = 0x836292a18, i = 0} [21:10:13.287] msec_str = "\000\000\000\000\b", '\000' , "A\035\332f\000\000\000\000p\336O\363s\322", [21:10:13.287] dest = DestRemote [21:10:13.287] was_logged = [21:10:13.287] oldcontext = 0x83636c000 [21:10:13.287] parsetree_list = 0x836292a18 [21:10:13.287] use_implicit_block = false [21:10:13.287] parsetree_item = 0x836292a30 [21:10:13.287] save_log_statement_stats = [21:10:13.287] #16 0x00000000009305b0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [21:10:13.287] query_string = 0x836291100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [21:10:13.287] input_message = {data = 0x836291100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [21:10:13.287] firstchar = [21:10:13.287] local_sigjmp_buf = {{_sjb = {9632326, 34919598288, 34919598248, 34919598832, 12347272, 1, 8192, 8388608, 34919547775, 0, 0, 1}}} [21:10:13.287] send_ready_for_query = false [21:10:13.287] idle_in_transaction_timeout_enabled = false [21:10:13.287] idle_session_timeout_enabled = false [21:10:13.287] #17 0x000000000092ad89 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [21:10:13.287] bsdata = [21:10:13.287] #18 0x0000000000884f47 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8215ed614 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215ed550) at ../src/backend/postmaster/launch_backend.c:274 [21:10:13.287] pid = [21:10:13.287] #19 0x0000000000889308 in BackendStartup (client_sock=0x8215ed550) at ../src/backend/postmaster/postmaster.c:3415 [21:10:13.287] startup_data = {canAcceptConnections = CAC_OK} [21:10:13.287] bn = 0x83629d358 [21:10:13.287] pid = [21:10:13.287] __error = [21:10:13.287] save_errno = [21:10:13.287] __error = [21:10:13.287] __error = [21:10:13.287] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [21:10:13.287] 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/)6\b", '\000' , "\260\325^!\b\000\000\000h\245c*\b\000\000\000\v\000\000\000\000\000\000\000^/d*\b", '\000' , "\360\325^!\b\000\000\000\364L\210\000\000\000\000\000\000\326^!\b", '\000' }, salen = 16}} [21:10:13.287] i = 0 [21:10:13.287] now = [21:10:13.287] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 721644674, events = 8, fd = 0, user_data = 0x8215ed500}, {pos = 909039064, events = 8, fd = 559862672, user_data = 0x0}, {pos = 0, events = 0, fd = -1878623449, user_data = 0x23dc4311330a}, {pos = 720811936, events = 8, fd = 720883064, user_data = 0x8215ed018}, {pos = 559861904, events = 8, fd = 559861784, user_data = 0x23dc4311330a}, {pos = 720790408, events = 8, fd = 720883064, user_data = 0x8215ed048}, {pos = 559861952, events = 8, fd = 559861832, user_data = 0x82af75194}, {pos = 569070600, events = 8, fd = 720851348, user_data = 0x8215ed0b0}, {pos = 1125180474, events = 9180, fd = 722673712, user_data = 0x1}, {pos = 559861984, events = 8, fd = 1125200650, user_data = 0x82af5e858}, {pos = 720883064, events = 8, fd = 559861944, user_data = 0x8215ed130}, {pos = 559861944, events = 8, fd = 720846092, user_data = 0x821eb5408}, {pos = 720846092, events = 8, fd = 559862048, user_data = 0x23dc4310e43a}, {pos = 559862088, events = 8, fd = 559862536, user_data = 0x8215ed130}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 601143466, fd = 569094200, user_data = 0x800000001}, {pos = 569070600, events = 8, fd = 720790408, user_data = 0x821eba288}, {pos = 720758872, events = 8, fd = 569070600, user_data = 0x8215ed1b8}, {pos = 559862648, events = 8, fd = 559862176, user_data = 0x23dc43112ca2}, {pos = 2699752, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 569094200, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 559862904, user_data = 0x21eb5408}, {pos = 559862720, events = 8, fd = 559862320, user_data = 0x1}, {pos = 559862648, events = 8, fd = 32, user_data = 0x8215ed220}, {pos = 1125198451, events = 9180, fd = 559862592, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821ebb038}, {pos = 1, events = 8, fd = 569070600, user_data = 0x82af5e858}, {pos = 559862904, events = 8, fd = 559862720, user_data = 0x8215ed230}, {pos = 0, events = 0, fd = 569040904, user_data = 0x20}, {pos = 559862704, events = 8, fd = 1125173991, user_data = 0x821eae008}, {pos = 569041928, events = 8, fd = 569042952, user_data = 0x821eaec08}, {pos = 569057288, events = 8, fd = 569058312, user_data = 0x821eb2808}, {pos = 569060360, events = 8, fd = 569061384, user_data = 0x821eb3408}, {pos = 569063432, events = 8, fd = 569064456, user_data = 0x821eb4008}, {pos = 569066504, events = 8, fd = 569067528, user_data = 0x821eb4c08}, {pos = 569069576, events = 8, fd = 569070600, user_data = 0x821eb5808}, {pos = 569072648, events = 8, fd = 569073672, user_data = 0x821eb6408}, {pos = 569075720, events = 8, fd = 569076744, user_data = 0x821eb7008}, {pos = 569078792, events = 8, fd = 569079816, user_data = 0x821eb7c08}, {pos = 569085960, events = 8, fd = 569086984, user_data = 0x821eb9808}, {pos = 569089032, events = 8, fd = 569040904, user_data = 0x2931e8}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821ebb038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 559862904, events = 8, fd = 559862320, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 569094200, user_data = 0x1}, {pos = 569040904, events = 8, fd = 313, user_data = 0x8215ed460}, {pos = 1125172719, events = 9180, fd = 2699752, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 569094200, user_data = 0x1}, {pos = 569070600, events = 8, fd = 908595200, user_data = 0x1}, {pos = 908595604, events = 8, fd = 0, user_data = 0x8215ed430}, {pos = 711206252, events = 8, fd = 1, user_data = 0x836281000}, {pos = 559862880, events = 8, fd = 711202562, user_data = 0x82b090170 }, {pos = 12272304, events = 0, fd = 722010480, user_data = 0x821eb5408}, {pos = 559863104, events = 8, fd = 1125172190, user_data = 0x83629f800}, {pos = 1, events = 0, fd = 1125171806, user_data = 0x821eae008}, {pos = 559862888, events = 8, fd = 559863104, user_data = 0x1c20}, {pos = 908668672, events = 8, fd = 1125251472, user_data = 0x0}, {pos = 559809407, events = 8, fd = 8085463, user_data = 0x8215ed4f0}, {pos = 711164944, events = 8, fd = 722673712, user_data = 0x82b134310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8215ed520}, {pos = 711207837, events = 8, fd = 908595200, user_data = 0x1d72}, {pos = 559863168, events = 8, fd = 711174394, user_data = 0x0}, {pos = 0, events = 0, fd = -1878623449, user_data = 0x0}} [21:10:13.287] last_touch_time = 1725570349 [21:10:13.287] last_lockfile_recheck_time = 1725570349 [21:10:13.287] nevents = 1 [21:10:13.287] #21 0x0000000000887125 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8215edb68) at ../src/backend/postmaster/postmaster.c:1346 [21:10:13.287] userDoption = [21:10:13.287] listen_addr_saved = [21:10:13.287] output_config_variable = [21:10:13.287] opt = [21:10:13.287] status = [21:10:13.287] #22 0x00000000007c2cbc in main (argc=8, argv=0x8215edb68) at ../src/backend/main/main.c:197 [21:10:13.287] do_check_root = [21:10:13.301] [21:10:13.301] [21:10:13.301] [21:10:13.367] dumping /tmp/cores/postgres.11259.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:10:13.490] [New LWP 101816] [21:10:13.554] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [21:10:13.554] Program terminated with signal SIGABRT, Aborted. [21:10:13.554] Sent by thr_kill() from pid 11259 and user 1003. [21:10:13.554] #0 0x000000082999c41a in thr_kill () from /lib/libc.so.7 [21:10:14.202] [21:10:14.202] Thread 1 (LWP 101816): [21:10:14.202] #0 0x000000082999c41a in thr_kill () from /lib/libc.so.7 [21:10:14.202] No symbol table info available. [21:10:14.202] #1 0x0000000829915e64 in raise () from /lib/libc.so.7 [21:10:14.202] No symbol table info available. [21:10:14.202] #2 0x00000008299c66f9 in abort () from /lib/libc.so.7 [21:10:14.202] No symbol table info available. [21:10:14.202] #3 0x0000000000a89865 in ExceptionalCondition (conditionName=0x2e6199 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [21:10:14.202] No locals. [21:10:14.202] #4 0x000000000075faf9 in standard_ExecutorStart (queryDesc=0x832665380, eflags=0) at ../src/backend/executor/execMain.c:191 [21:10:14.202] estate = 0x83e242100 [21:10:14.202] oldcontext = 0x83267e800 [21:10:14.202] #5 0x00000000006f68d2 in refresh_matview_datafill (dest=0x8326b4f38, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [21:10:14.202] copied_query = [21:10:14.202] rewritten = [21:10:14.202] plan = [21:10:14.202] queryDesc = 0x832665380 [21:10:14.202] processed = [21:10:14.202] __error = [21:10:14.202] #6 RefreshMatViewByOid (matviewOid=27280, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [21:10:14.202] dest = 0x8326b4f38 [21:10:14.202] save_userid = 10 [21:10:14.202] save_sec_context = 0 [21:10:14.202] processed = 0 [21:10:14.202] matviewRel = 0x83e16a1c0 [21:10:14.202] relowner = 10 [21:10:14.202] save_nestlevel = 2 [21:10:14.202] rule = [21:10:14.202] actions = [21:10:14.202] dataQuery = [21:10:14.202] tableSpace = [21:10:14.202] relpersistence = [21:10:14.202] OIDNewHeap = 27308 [21:10:14.202] address = [21:10:14.202] #7 0x00000000006f64b6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [21:10:14.202] lockmode = [21:10:14.202] matviewOid = 0 [21:10:14.202] #8 0x00000000006ce2cc in ExecCreateTableAs (pstate=pstate@entry=0x83267e900, stmt=stmt@entry=0x83e235fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82105dfd0) at ../src/backend/commands/createas.c:350 [21:10:14.202] refresh = 0x0 [21:10:14.202] query = 0x83e209498 [21:10:14.202] into = 0x83e2097e0 [21:10:14.202] do_refresh = false [21:10:14.202] address = [21:10:14.202] dest = [21:10:14.202] is_matview = [21:10:14.202] #9 0x0000000000936af8 in ProcessUtilitySlow (pstate=pstate@entry=0x83267e900, pstmt=pstmt@entry=0x8324e3a68, queryString=queryString@entry=0x8324e2100 "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=0x82105dfd0) at ../src/backend/tcop/utility.c:1675 [21:10:14.202] _local_sigjmp_buf = {{_sjb = {9659177, 0, 34913770488, 34913770864, 34913770496, 12338536, 0, 35205409024, 4294902655, 34913770604, 34913770640, 0}}} [21:10:14.202] _save_exception_stack = 0x82105ded0 [21:10:14.202] _save_context_stack = 0x0 [21:10:14.202] _do_rethrow = false [21:10:14.202] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [21:10:14.202] parsetree = 0x83e235fd0 [21:10:14.202] commandCollected = false [21:10:14.202] needCleanup = false [21:10:14.202] address = [21:10:14.202] isTopLevel = [21:10:14.202] isCompleteQuery = [21:10:14.202] #10 0x0000000000935478 in standard_ProcessUtility (pstmt=0x8324e3a68, queryString=0x8324e2100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83e209cc8, qc=0x82105dfd0) at ../src/backend/tcop/utility.c:1030 [21:10:14.202] isAtomicContext = false [21:10:14.202] parsetree = 0x83e235fd0 [21:10:14.202] readonly_flags = [21:10:14.202] pstate = 0x83267e900 [21:10:14.202] isTopLevel = [21:10:14.202] #11 0x0000000000934f08 in ProcessUtility (pstmt=0x18db8, queryString=0x6 , readOnlyTree=, context=697943034, params=0x0, queryEnv=0x0, dest=0x83e209cc8, qc=0x82105dfd0) at ../src/backend/tcop/utility.c:523 [21:10:14.202] No locals. [21:10:14.202] #12 0x0000000000934a43 in PortalRunUtility (portal=0x832588100, pstmt=0x8324e3a68, isTopLevel=, setHoldSnapshot=, dest=0x83e209cc8, qc=0x82105dfd0) at ../src/backend/tcop/pquery.c:1158 [21:10:14.202] No locals. [21:10:14.202] #13 0x00000000009340d4 in PortalRunMulti (portal=portal@entry=0x832588100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83e209cc8, altdest=altdest@entry=0x83e209cc8, qc=0x82105dfd0) at ../src/backend/tcop/pquery.c:1323 [21:10:14.202] pstmt = 0x8324e3a68 [21:10:14.202] stmtlist_item__state = {l = 0x83e209c78, i = 0} [21:10:14.202] active_snapshot_set = false [21:10:14.202] stmtlist_item = 0x83e209c90 [21:10:14.202] #14 0x00000000009339a3 in PortalRun (portal=portal@entry=0x832588100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83e209cc8, altdest=altdest@entry=0x83e209cc8, qc=0x82105dfd0) at ../src/backend/tcop/pquery.c:791 [21:10:14.202] _local_sigjmp_buf = {{_sjb = {9648413, 35204399360, 34913771208, 34913771440, 34913771216, 35204415488, 12305208, 12338536, 35204367231, 35402237328, 4294967984, 0}}} [21:10:14.202] _save_exception_stack = 0x82105e0a0 [21:10:14.202] _save_context_stack = 0x0 [21:10:14.202] _do_rethrow = false [21:10:14.202] saveTopTransactionResourceOwner = 0x8325d7158 [21:10:14.202] saveTopTransactionContext = 0x83258c000 [21:10:14.202] saveActivePortal = 0x0 [21:10:14.202] saveResourceOwner = 0x8325d7158 [21:10:14.202] savePortalContext = 0x0 [21:10:14.202] saveMemoryContext = 0x83258c000 [21:10:14.202] result = [21:10:14.202] nprocessed = [21:10:14.202] #15 0x0000000000932842 in exec_simple_query (query_string=query_string@entry=0x8324e2100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [21:10:14.202] cmdtaglen = 24 [21:10:14.202] snapshot_set = [21:10:14.202] per_parsetree_context = 0x0 [21:10:14.202] plantree_list = [21:10:14.202] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:10:14.202] format = 0 [21:10:14.202] parsetree = 0x8324e36a8 [21:10:14.202] commandTag = [21:10:14.202] cmdtagname = [21:10:14.202] querytree_list = [21:10:14.202] portal = 0x832588100 [21:10:14.202] receiver = 0x83e209cc8 [21:10:14.202] parsetree_item__state = {l = 0x8324e3a18, i = 0} [21:10:14.202] msec_str = "\000\000\000\000\b", '\000' , "E\035\332f\000\000\000\000p\300\220\266H\223\306M" [21:10:14.202] dest = DestRemote [21:10:14.202] was_logged = [21:10:14.202] oldcontext = 0x83258c000 [21:10:14.202] parsetree_list = 0x8324e3a18 [21:10:14.202] use_implicit_block = false [21:10:14.202] parsetree_item = 0x8324e3a30 [21:10:14.202] save_log_statement_stats = [21:10:14.202] #16 0x00000000009305b0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [21:10:14.202] query_string = 0x8324e2100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [21:10:14.202] input_message = {data = 0x8324e2100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [21:10:14.202] firstchar = [21:10:14.202] local_sigjmp_buf = {{_sjb = {9632326, 34913771680, 34913771640, 34913772224, 12347272, 1, 8192, 8388608, 34913715071, 0, 0, 1}}} [21:10:14.202] send_ready_for_query = false [21:10:14.202] idle_in_transaction_timeout_enabled = false [21:10:14.202] idle_session_timeout_enabled = false [21:10:14.202] #17 0x000000000092ad89 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [21:10:14.202] bsdata = [21:10:14.202] #18 0x0000000000884f47 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82105ede4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82105ed20) at ../src/backend/postmaster/launch_backend.c:274 [21:10:14.202] pid = [21:10:14.202] #19 0x0000000000889308 in BackendStartup (client_sock=0x82105ed20) at ../src/backend/postmaster/postmaster.c:3415 [21:10:14.202] startup_data = {canAcceptConnections = CAC_OK} [21:10:14.202] bn = 0x8324ee2b8 [21:10:14.202] pid = [21:10:14.202] __error = [21:10:14.202] save_errno = [21:10:14.202] __error = [21:10:14.202] __error = [21:10:14.202] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [21:10:14.202] 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>N2\b", '\000' , "\200\355\005!\b\000\000\000h\245G)\b\000\000\000\v\000\000\000\000\000\000\000^/H)\b", '\000' , "\300\355\005!\b\000\000\000\364L\210\000\000\000\000\000\320\355\005!\b", '\000' }, salen = 16}} [21:10:14.202] i = 0 [21:10:14.202] now = [21:10:14.202] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 697568386, events = 8, fd = 0, user_data = 0x82105ecd0}, {pos = 844416472, events = 8, fd = 554036064, user_data = 0x0}, {pos = 0, events = 0, fd = -1579643217, user_data = 0x2720a278530a}, {pos = 696735648, events = 8, fd = 696806776, user_data = 0x82105e7e8}, {pos = 554035296, events = 8, fd = 554035176, user_data = 0x2720a278530a}, {pos = 696714120, events = 8, fd = 696806776, user_data = 0x82105e818}, {pos = 554035344, events = 8, fd = 554035224, user_data = 0x82987f194}, {pos = 557880328, events = 8, fd = 696775060, user_data = 0x82105e880}, {pos = -1569192902, events = 10016, fd = 698597424, user_data = 0x1}, {pos = 554035376, events = 8, fd = -1569172726, user_data = 0x829868858}, {pos = 696806776, events = 8, fd = 554035336, user_data = 0x82105e900}, {pos = 554035336, events = 8, fd = 696769804, user_data = 0x821409408}, {pos = 696769804, events = 8, fd = 554035440, user_data = 0x2720a278043a}, {pos = 554035480, events = 8, fd = 554035928, user_data = 0x82105e900}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2413197232, fd = 557903928, user_data = 0x800000001}, {pos = 557880328, events = 8, fd = 696714120, user_data = 0x82140e288}, {pos = 696682584, events = 8, fd = 557880328, user_data = 0x82105e988}, {pos = 554036040, events = 8, fd = 554035568, user_data = 0x2720a2784ca2}, {pos = 2699752, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 557903928, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554036296, user_data = 0x21409408}, {pos = 554036112, events = 8, fd = 554035712, user_data = 0x1}, {pos = 554036040, events = 8, fd = 32, user_data = 0x82105e9f0}, {pos = -1569174925, events = 10016, fd = 554035984, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82140f038}, {pos = 1, events = 8, fd = 557880328, user_data = 0x829868858}, {pos = 554036296, events = 8, fd = 554036112, user_data = 0x82105ea00}, {pos = 0, events = 0, fd = 557850632, user_data = 0x20}, {pos = 554036096, events = 8, fd = -1569199385, user_data = 0x821402008}, {pos = 557851656, events = 8, fd = 557852680, user_data = 0x821402c08}, {pos = 557867016, events = 8, fd = 557868040, user_data = 0x821406808}, {pos = 557870088, events = 8, fd = 557871112, user_data = 0x821407408}, {pos = 557873160, events = 8, fd = 557874184, user_data = 0x821408008}, {pos = 557876232, events = 8, fd = 557877256, user_data = 0x821408c08}, {pos = 557879304, events = 8, fd = 557880328, user_data = 0x821409808}, {pos = 557882376, events = 8, fd = 557883400, user_data = 0x82140a408}, {pos = 557885448, events = 8, fd = 557886472, user_data = 0x82140b008}, {pos = 557888520, events = 8, fd = 557889544, user_data = 0x82140bc08}, {pos = 557895688, events = 8, fd = 557896712, user_data = 0x82140d808}, {pos = 557898760, events = 8, fd = 557850632, user_data = 0x2931e8}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82140f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554036296, events = 8, fd = 554035712, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 557903928, user_data = 0x1}, {pos = 557850632, events = 8, fd = 313, user_data = 0x82105ec30}, {pos = -1569200657, events = 10016, fd = 2699752, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 557903928, user_data = 0x1}, {pos = 557880328, events = 8, fd = 843915264, user_data = 0x1}, {pos = 843915668, events = 8, fd = 0, user_data = 0x82105ec00}, {pos = 692594028, events = 8, fd = 1, user_data = 0x8324d2000}, {pos = 554036272, events = 8, fd = 692590338, user_data = 0x82999a170 }, {pos = 12272304, events = 0, fd = 697934192, user_data = 0x821409408}, {pos = 554036496, events = 8, fd = -1569201186, user_data = 0x8324f0800}, {pos = 1, events = 0, fd = -1569201570, user_data = 0x821402008}, {pos = 554036280, events = 8, fd = 554036496, user_data = 0x1c20}, {pos = 843988672, events = 8, fd = -1569121904, user_data = 0x0}, {pos = 553976703, events = 8, fd = 8085463, user_data = 0x82105ecc0}, {pos = 692552720, events = 8, fd = 698597424, user_data = 0x829a3e310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82105ecf0}, {pos = 692595613, events = 8, fd = 843915264, user_data = 0x1d9c}, {pos = 554036560, events = 8, fd = 692562170, user_data = 0x0}, {pos = 0, events = 0, fd = -1579643217, user_data = 0x0}} [21:10:14.202] last_touch_time = 1725570350 [21:10:14.202] last_lockfile_recheck_time = 1725570350 [21:10:14.202] nevents = 1 [21:10:14.202] #21 0x0000000000887125 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82105f330) at ../src/backend/postmaster/postmaster.c:1346 [21:10:14.202] userDoption = [21:10:14.202] listen_addr_saved = [21:10:14.202] output_config_variable = [21:10:14.202] opt = [21:10:14.202] status = [21:10:14.202] #22 0x00000000007c2cbc in main (argc=4, argv=0x82105f330) at ../src/backend/main/main.c:197 [21:10:14.202] do_check_root = [21:10:14.215] [21:10:14.215] [21:10:14.215] [21:10:14.278] dumping /tmp/cores/postgres.17235.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:10:14.401] [New LWP 100168] [21:10:14.466] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [21:10:14.466] Program terminated with signal SIGABRT, Aborted. [21:10:14.466] Sent by thr_kill() from pid 17235 and user 1003. [21:10:14.466] #0 0x000000082b2da41a in thr_kill () from /lib/libc.so.7 [21:10:15.124] [21:10:15.124] Thread 1 (LWP 100168): [21:10:15.124] #0 0x000000082b2da41a in thr_kill () from /lib/libc.so.7 [21:10:15.124] No symbol table info available. [21:10:15.124] #1 0x000000082b253e64 in raise () from /lib/libc.so.7 [21:10:15.124] No symbol table info available. [21:10:15.124] #2 0x000000082b3046f9 in abort () from /lib/libc.so.7 [21:10:15.124] No symbol table info available. [21:10:15.124] #3 0x0000000000a89865 in ExceptionalCondition (conditionName=0x2e6199 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [21:10:15.124] No locals. [21:10:15.124] #4 0x000000000075faf9 in standard_ExecutorStart (queryDesc=0x83a700380, eflags=0) at ../src/backend/executor/execMain.c:191 [21:10:15.124] estate = 0x83a76d100 [21:10:15.124] oldcontext = 0x8352c0800 [21:10:15.124] #5 0x0000000837ab3862 in pgss_ExecutorStart (queryDesc=0x83a700380, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:993 [21:10:15.124] No locals. [21:10:15.124] #6 0x00000000006f68d2 in refresh_matview_datafill (dest=0x8352bd038, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [21:10:15.124] copied_query = [21:10:15.124] rewritten = [21:10:15.124] plan = [21:10:15.124] queryDesc = 0x83a700380 [21:10:15.124] processed = [21:10:15.124] __error = [21:10:15.124] #7 RefreshMatViewByOid (matviewOid=27355, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [21:10:15.124] dest = 0x8352bd038 [21:10:15.124] save_userid = 10 [21:10:15.124] save_sec_context = 0 [21:10:15.124] processed = 0 [21:10:15.124] matviewRel = 0x83a803e28 [21:10:15.124] relowner = 10 [21:10:15.124] save_nestlevel = 2 [21:10:15.124] rule = [21:10:15.124] actions = [21:10:15.124] dataQuery = [21:10:15.124] tableSpace = [21:10:15.124] relpersistence = [21:10:15.124] OIDNewHeap = 27362 [21:10:15.124] address = [21:10:15.124] #8 0x00000000006f64b6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [21:10:15.124] lockmode = [21:10:15.124] matviewOid = 0 [21:10:15.124] #9 0x00000000006ce2cc in ExecCreateTableAs (pstate=pstate@entry=0x8352c0900, stmt=stmt@entry=0x835285fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821591930) at ../src/backend/commands/createas.c:350 [21:10:15.124] refresh = 0x0 [21:10:15.124] query = 0x835375f08 [21:10:15.124] into = 0x835285f40 [21:10:15.124] do_refresh = false [21:10:15.124] address = [21:10:15.124] dest = [21:10:15.124] is_matview = [21:10:15.124] #10 0x0000000000936af8 in ProcessUtilitySlow (pstate=pstate@entry=0x8352c0900, pstmt=pstmt@entry=0x835285e30, queryString=queryString@entry=0x8351e8100 "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=0x821591930) at ../src/backend/tcop/utility.c:1675 [21:10:15.124] _local_sigjmp_buf = {{_sjb = {9659177, 0, 34919224216, 34919224592, 34919224224, 12338536, 0, 35251816704, 34919220095, 7, 34919224368, 0}}} [21:10:15.124] _save_exception_stack = 0x821591620 [21:10:15.124] _save_context_stack = 0x0 [21:10:15.124] _do_rethrow = false [21:10:15.124] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [21:10:15.124] parsetree = 0x835285fd0 [21:10:15.124] commandCollected = false [21:10:15.124] needCleanup = false [21:10:15.124] address = [21:10:15.124] isTopLevel = [21:10:15.124] isCompleteQuery = [21:10:15.124] #11 0x0000000000935478 in standard_ProcessUtility (pstmt=0x835285e30, queryString=queryString@entry=0x8351e8100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8353766a8, qc=0x821591930) at ../src/backend/tcop/utility.c:1030 [21:10:15.124] isAtomicContext = false [21:10:15.124] parsetree = 0x835285fd0 [21:10:15.124] readonly_flags = [21:10:15.124] pstate = 0x8352c0900 [21:10:15.124] isTopLevel = [21:10:15.124] #12 0x0000000837ab3dee in pgss_ProcessUtility (pstmt=0x835285e30, queryString=0x8351e8100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8353766a8, qc=0x821591930) at ../contrib/pg_stat_statements/pg_stat_statements.c:1167 [21:10:15.124] _local_sigjmp_buf = {{_sjb = {35293707559, 34919224864, 34919224728, 34919225184, 35251576368, 0, 12338536, 34919225392, 34919220095, 34919224964, 34919224992, 0}}} [21:10:15.124] _save_exception_stack = 0x821591830 [21:10:15.124] _save_context_stack = 0x0 [21:10:15.124] _do_rethrow = false [21:10:15.124] bufusage = {shared_blks_hit = 35293707559, shared_blks_read = 34919224864, shared_blks_dirtied = 34919224728, shared_blks_written = 34919225184, local_blks_hit = 35251576368, local_blks_read = 0, local_blks_dirtied = 12338536, local_blks_written = 34919225392, temp_blks_read = 34919220095, temp_blks_written = 34919224964, shared_blk_read_time = {ticks = 34919224992}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4039232991246764288}, local_blk_write_time = {ticks = 12347576}, temp_blk_read_time = {ticks = 34919225008}, temp_blk_write_time = {ticks = 6627487}} [21:10:15.124] walusage_start = {wal_records = 8938, wal_fpi = 123, wal_bytes = 1198670} [21:10:15.124] duration = [21:10:15.124] bufusage_start = {shared_blks_hit = 151916, shared_blks_read = 8344, shared_blks_dirtied = 2630, shared_blks_written = 2445, 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}} [21:10:15.124] walusage = {wal_records = 8107, wal_fpi = 12347576, wal_bytes = 8869} [21:10:15.124] start = {ticks = -192663628570} [21:10:15.124] rows = [21:10:15.124] saved_queryId = 6041762721901209185 [21:10:15.124] parsetree = [21:10:15.124] saved_stmt_location = 0 [21:10:15.124] saved_stmt_len = 69 [21:10:15.124] enabled = [21:10:15.124] #13 0x0000000000934a43 in PortalRunUtility (portal=0x835290100, pstmt=0x835285e30, isTopLevel=, setHoldSnapshot=, dest=0x8353766a8, qc=0x821591930) at ../src/backend/tcop/pquery.c:1158 [21:10:15.124] No locals. [21:10:15.124] #14 0x00000000009340d4 in PortalRunMulti (portal=portal@entry=0x835290100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8353766a8, altdest=altdest@entry=0x8353766a8, qc=0x821591930) at ../src/backend/tcop/pquery.c:1323 [21:10:15.124] pstmt = 0x835285e30 [21:10:15.124] stmtlist_item__state = {l = 0x835376658, i = 0} [21:10:15.124] active_snapshot_set = false [21:10:15.124] stmtlist_item = 0x835376670 [21:10:15.124] #15 0x00000000009339a3 in PortalRun (portal=portal@entry=0x835290100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8353766a8, altdest=altdest@entry=0x8353766a8, qc=0x821591930) at ../src/backend/tcop/pquery.c:791 [21:10:15.124] _local_sigjmp_buf = {{_sjb = {9648413, 35251618048, 34919225384, 34919225616, 34919225392, 35251712000, 12305208, 12338536, 35251618687, 35251570144, 4294967984, 0}}} [21:10:15.124] _save_exception_stack = 0x821591a00 [21:10:15.124] _save_context_stack = 0x0 [21:10:15.124] _do_rethrow = false [21:10:15.124] saveTopTransactionResourceOwner = 0x8352defd8 [21:10:15.124] saveTopTransactionContext = 0x8352a7000 [21:10:15.124] saveActivePortal = 0x0 [21:10:15.124] saveResourceOwner = 0x8352defd8 [21:10:15.124] savePortalContext = 0x0 [21:10:15.124] saveMemoryContext = 0x8352a7000 [21:10:15.124] result = [21:10:15.124] nprocessed = [21:10:15.124] #16 0x0000000000932842 in exec_simple_query (query_string=query_string@entry=0x8351e8100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [21:10:15.124] cmdtaglen = 24 [21:10:15.124] snapshot_set = [21:10:15.124] per_parsetree_context = 0x0 [21:10:15.124] plantree_list = [21:10:15.124] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:10:15.124] format = 0 [21:10:15.124] parsetree = 0x8351e96a8 [21:10:15.124] commandTag = [21:10:15.124] cmdtagname = [21:10:15.124] querytree_list = [21:10:15.124] portal = 0x835290100 [21:10:15.124] receiver = 0x8353766a8 [21:10:15.124] parsetree_item__state = {l = 0x8351e9a18, i = 0} [21:10:15.124] msec_str = "\000\000\000\000\b", '\000' , "h\035\332f\000\000\000\000\320\034g\3153Z\264\004" [21:10:15.124] dest = DestRemote [21:10:15.124] was_logged = [21:10:15.124] oldcontext = 0x8352a7000 [21:10:15.124] parsetree_list = 0x8351e9a18 [21:10:15.124] use_implicit_block = false [21:10:15.124] parsetree_item = 0x8351e9a30 [21:10:15.124] save_log_statement_stats = [21:10:15.124] #17 0x00000000009305b0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [21:10:15.124] query_string = 0x8351e8100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [21:10:15.124] input_message = {data = 0x8351e8100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [21:10:15.124] firstchar = [21:10:15.124] local_sigjmp_buf = {{_sjb = {9632326, 34919225856, 34919225816, 34919226400, 12347272, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [21:10:15.124] send_ready_for_query = false [21:10:15.124] idle_in_transaction_timeout_enabled = false [21:10:15.124] idle_session_timeout_enabled = false [21:10:15.124] #18 0x000000000092ad89 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [21:10:15.124] bsdata = [21:10:15.124] #19 0x0000000000884f47 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821592744 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821592680) at ../src/backend/postmaster/launch_backend.c:274 [21:10:15.124] pid = [21:10:15.124] #20 0x0000000000889308 in BackendStartup (client_sock=0x821592680) at ../src/backend/postmaster/postmaster.c:3415 [21:10:15.124] startup_data = {canAcceptConnections = CAC_OK} [21:10:15.124] bn = 0x8351f4308 [21:10:15.124] pid = [21:10:15.124] __error = [21:10:15.124] save_errno = [21:10:15.124] __error = [21:10:15.124] __error = [21:10:15.124] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [21:10:15.124] 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 = " \214\0365\b", '\000' , "\340&Y!\b\000\000\000h\365c)\b\000\000\000\v\000\000\000\000\000\000\000^\177d)\b", '\000' , " 'Y!\b\000\000\000\364L\210\000\000\000\000\0000'Y!\b", '\000' }, salen = 16}} [21:10:15.124] i = 0 [21:10:15.124] now = [21:10:15.124] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 724036738, events = 8, fd = 0, user_data = 0x821592630}, {pos = 891598296, events = 8, fd = 559490240, user_data = 0x0}, {pos = -362990838, events = 15705, fd = 723204000, user_data = 0x82b1c4d78}, {pos = 559489336, events = 8, fd = 559489456, user_data = 0x821592138}, {pos = -362990838, events = 15705, fd = 723182472, user_data = 0x82b1c4d78}, {pos = 559489384, events = 8, fd = 559489504, user_data = 0x821592168}, {pos = 723243412, events = 8, fd = 566256648, user_data = 0x82b1bd194}, {pos = 559489488, events = 8, fd = -363011014, user_data = 0x821592170}, {pos = 694408208, events = 8, fd = 725065776, user_data = 0x3d59ea5d330a}, {pos = 723150936, events = 8, fd = 723275128, user_data = 0x8215921d8}, {pos = 559489616, events = 8, fd = 559489496, user_data = 0x82b1bbd0c}, {pos = 566256648, events = 8, fd = 723238156, user_data = 0x821592240}, {pos = -363011014, events = 15705, fd = 559489640, user_data = 0x821592438}, {pos = 559489616, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821c0c038}, {pos = 1, events = 3500214527, fd = 566256648, user_data = 0x82b1ae388}, {pos = 566278088, events = 8, fd = 0, user_data = 0x0}, {pos = 559489752, events = 8, fd = 559490216, user_data = 0x8215922c0}, {pos = -362992478, events = 15705, fd = 2699752, user_data = 0x6d68b}, {pos = 2090263927, events = 3500214527, fd = 566280248, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8215925a8}, {pos = 566256648, events = 3, fd = 559490288, user_data = 0x821c0b828}, {pos = 656, events = 0, fd = 559490216, user_data = 0x8215922d8}, {pos = 559489856, events = 8, fd = -362992869, user_data = 0x821592470}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 566280248, events = 8, fd = 1, user_data = 0x821c06408}, {pos = 723150936, events = 8, fd = 559490472, user_data = 0x8215924f0}, {pos = 559489872, events = 8, fd = 0, user_data = 0x821bff008}, {pos = 33, events = 0, fd = 559490272, user_data = 0x3d59ea5ccae7}, {pos = 566226952, events = 8, fd = 566227976, user_data = 0x821bff808}, {pos = 566230024, events = 8, fd = 566243336, user_data = 0x821c03408}, {pos = 566245384, events = 8, fd = 566246408, user_data = 0x821c04008}, {pos = 566248456, events = 8, fd = 566249480, user_data = 0x821c04c08}, {pos = 566251528, events = 8, fd = 566252552, user_data = 0x821c05808}, {pos = 566254600, events = 8, fd = 566255624, user_data = 0x821c06408}, {pos = 566257672, events = 8, fd = 566258696, user_data = 0x821c07008}, {pos = 566260744, events = 8, fd = 566261768, user_data = 0x821c07c08}, {pos = 566263816, events = 8, fd = 566264840, user_data = 0x821c08808}, {pos = 566266888, events = 8, fd = 566272008, user_data = 0x821c0a408}, {pos = 566274056, events = 8, fd = 566275080, user_data = 0x821c0d408}, {pos = 218101000, events = 0, fd = 566226952, user_data = 0x2931e8}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821c0c038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 559490472, events = 8, fd = 559489872, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 566280248, user_data = 0x1}, {pos = 566226952, events = 8, fd = 313, user_data = 0x821592590}, {pos = -363018769, events = 15705, fd = 2699752, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 566280248, user_data = 0x1}, {pos = 566256648, events = 8, fd = 891125760, user_data = 0x1}, {pos = 891126164, events = 8, fd = 0, user_data = 0x821592560}, {pos = 694449516, events = 8, fd = 1, user_data = 0x8351d8000}, {pos = 559490448, events = 8, fd = 694445826, user_data = 0x82b2d8170 }, {pos = 12272304, events = 0, fd = 724402544, user_data = 0x821c06408}, {pos = 559490672, events = 8, fd = -363019298, user_data = 0x8351f6800}, {pos = 1, events = 0, fd = -363019682, user_data = 0x821bff008}, {pos = 559490456, events = 8, fd = 559490672, user_data = 0x1c20}, {pos = 891194400, events = 8, fd = -362940016, user_data = 0x0}, {pos = 559481727, events = 8, fd = 8085463, user_data = 0x821592620}, {pos = 694408208, events = 8, fd = 725065776, user_data = 0x82b37c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821592650}, {pos = 694451101, events = 8, fd = 891125760, user_data = 0x35fe}, {pos = 559490736, events = 8, fd = 694417658, user_data = 0x0}, {pos = 0, events = 0, fd = 1242630893, user_data = 0x0}} [21:10:15.124] last_touch_time = 1725570383 [21:10:15.124] last_lockfile_recheck_time = 1725570383 [21:10:15.124] nevents = 1 [21:10:15.124] #22 0x0000000000887125 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821592c98) at ../src/backend/postmaster/postmaster.c:1346 [21:10:15.124] userDoption = [21:10:15.124] listen_addr_saved = [21:10:15.124] output_config_variable = [21:10:15.124] opt = [21:10:15.124] status = [21:10:15.124] #23 0x00000000007c2cbc in main (argc=4, argv=0x821592c98) at ../src/backend/main/main.c:197 [21:10:15.124] do_check_root =