[09:25:12.972] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [09:25:13.338] dumping /tmp/cores/postgres.10636.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:25:13.469] [New LWP 101848] [09:25:13.555] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [09:25:13.555] Program terminated with signal SIGABRT, Aborted. [09:25:13.555] Sent by thr_kill() from pid 10636 and user 1003. [09:25:13.555] #0 0x000000082dd2d41a in thr_kill () from /lib/libc.so.7 [09:25:14.222] [09:25:14.222] Thread 1 (LWP 101848): [09:25:14.222] #0 0x000000082dd2d41a in thr_kill () from /lib/libc.so.7 [09:25:14.222] No symbol table info available. [09:25:14.222] #1 0x000000082dca6e64 in raise () from /lib/libc.so.7 [09:25:14.222] No symbol table info available. [09:25:14.222] #2 0x000000082dd576f9 in abort () from /lib/libc.so.7 [09:25:14.222] No symbol table info available. [09:25:14.222] #3 0x0000000000a8bb45 in ExceptionalCondition (conditionName=0x2e7225 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [09:25:14.222] No locals. [09:25:14.222] #4 0x0000000000761059 in standard_ExecutorStart (queryDesc=0x838415088, eflags=0) at ../src/backend/executor/execMain.c:191 [09:25:14.222] estate = 0x8366e9100 [09:25:14.222] oldcontext = 0x838348800 [09:25:14.222] #5 0x00000000006f7e65 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [09:25:14.222] copied_query = [09:25:14.222] rewritten = [09:25:14.222] plan = 0x836637bd8 [09:25:14.222] queryDesc = 0x838415088 [09:25:14.222] processed = [09:25:14.222] __error = [09:25:14.222] #6 RefreshMatViewByOid (matviewOid=27277, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [09:25:14.222] dest = [09:25:14.222] save_userid = 10 [09:25:14.222] save_sec_context = 0 [09:25:14.222] processed = 0 [09:25:14.222] matviewRel = 0x8383043f8 [09:25:14.222] relowner = 10 [09:25:14.222] save_nestlevel = 2 [09:25:14.222] rule = [09:25:14.222] actions = [09:25:14.222] dataQuery = [09:25:14.222] tableSpace = [09:25:14.222] relpersistence = [09:25:14.222] OIDNewHeap = 27287 [09:25:14.222] address = [09:25:14.222] #7 0x00000000006f7a46 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [09:25:14.222] lockmode = [09:25:14.222] matviewOid = 0 [09:25:14.222] #8 0x00000000006cf7bc in ExecCreateTableAs (pstate=pstate@entry=0x838348900, stmt=stmt@entry=0x836634fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820c35a80) at ../src/backend/commands/createas.c:350 [09:25:14.222] refresh = 0x0 [09:25:14.222] query = 0x8383d2258 [09:25:14.222] into = 0x8383d25a0 [09:25:14.222] do_refresh = false [09:25:14.222] address = [09:25:14.222] dest = [09:25:14.222] is_matview = [09:25:14.222] #9 0x0000000000938a68 in ProcessUtilitySlow (pstate=pstate@entry=0x838348900, pstmt=pstmt@entry=0x836591a68, queryString=queryString@entry=0x836590100 "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=0x820c35a80) at ../src/backend/tcop/utility.c:1675 [09:25:14.222] _local_sigjmp_buf = {{_sjb = {9667225, 0, 34909410984, 34909411360, 34909410992, 12349016, 0, 35302705408, 4294902655, 34909411100, 34909411136, 0}}} [09:25:14.222] _save_exception_stack = 0x820c35980 [09:25:14.222] _save_context_stack = 0x0 [09:25:14.222] _do_rethrow = false [09:25:14.222] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [09:25:14.222] parsetree = 0x836634fd0 [09:25:14.222] commandCollected = false [09:25:14.222] needCleanup = false [09:25:14.222] address = [09:25:14.222] isTopLevel = [09:25:14.222] isCompleteQuery = [09:25:14.222] #10 0x00000000009373e8 in standard_ProcessUtility (pstmt=0x836591a68, queryString=0x836590100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8383d2a88, qc=0x820c35a80) at ../src/backend/tcop/utility.c:1030 [09:25:14.222] isAtomicContext = false [09:25:14.222] parsetree = 0x836634fd0 [09:25:14.222] readonly_flags = [09:25:14.222] pstate = 0x838348900 [09:25:14.222] isTopLevel = [09:25:14.222] #11 0x0000000000936e78 in ProcessUtility (pstmt=0x18dd8, queryString=0x6 , readOnlyTree=, context=768791546, params=0x0, queryEnv=0x0, dest=0x8383d2a88, qc=0x820c35a80) at ../src/backend/tcop/utility.c:523 [09:25:14.222] No locals. [09:25:14.222] #12 0x00000000009369b3 in PortalRunUtility (portal=0x836667100, pstmt=0x836591a68, isTopLevel=, setHoldSnapshot=, dest=0x8383d2a88, qc=0x820c35a80) at ../src/backend/tcop/pquery.c:1158 [09:25:14.222] No locals. [09:25:14.222] #13 0x0000000000936044 in PortalRunMulti (portal=portal@entry=0x836667100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8383d2a88, altdest=altdest@entry=0x8383d2a88, qc=0x820c35a80) at ../src/backend/tcop/pquery.c:1323 [09:25:14.222] pstmt = 0x836591a68 [09:25:14.222] stmtlist_item__state = {l = 0x8383d2a38, i = 0} [09:25:14.222] active_snapshot_set = false [09:25:14.222] stmtlist_item = 0x8383d2a50 [09:25:14.222] #14 0x0000000000935913 in PortalRun (portal=portal@entry=0x836667100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8383d2a88, altdest=altdest@entry=0x8383d2a88, qc=0x820c35a80) at ../src/backend/tcop/pquery.c:791 [09:25:14.222] _local_sigjmp_buf = {{_sjb = {9656461, 35272421632, 34909411704, 34909411936, 34909411712, 35272437760, 12315688, 12349016, 35272393599, 35272209808, 4294967984, 0}}} [09:25:14.222] _save_exception_stack = 0x820c35b50 [09:25:14.222] _save_context_stack = 0x0 [09:25:14.222] _do_rethrow = false [09:25:14.222] saveTopTransactionResourceOwner = 0x836678198 [09:25:14.222] saveTopTransactionContext = 0x83666b000 [09:25:14.222] saveActivePortal = 0x0 [09:25:14.222] saveResourceOwner = 0x836678198 [09:25:14.222] savePortalContext = 0x0 [09:25:14.222] saveMemoryContext = 0x83666b000 [09:25:14.222] result = [09:25:14.222] nprocessed = [09:25:14.222] #15 0x00000000009347b2 in exec_simple_query (query_string=query_string@entry=0x836590100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [09:25:14.222] cmdtaglen = 24 [09:25:14.222] snapshot_set = [09:25:14.222] per_parsetree_context = 0x0 [09:25:14.222] plantree_list = [09:25:14.222] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:25:14.222] format = 0 [09:25:14.222] parsetree = 0x8365916a8 [09:25:14.222] commandTag = [09:25:14.222] cmdtagname = [09:25:14.222] querytree_list = [09:25:14.222] portal = 0x836667100 [09:25:14.222] receiver = 0x8383d2a88 [09:25:14.222] parsetree_item__state = {l = 0x836591a18, i = 0} [09:25:14.222] msec_str = "\000\000\000\000\b", '\000' , "\002J\351f\000\000\000\000Yr\2606\254]\320\006" [09:25:14.222] dest = DestRemote [09:25:14.222] was_logged = [09:25:14.222] oldcontext = 0x83666b000 [09:25:14.222] parsetree_list = 0x836591a18 [09:25:14.222] use_implicit_block = false [09:25:14.222] parsetree_item = 0x836591a30 [09:25:14.222] save_log_statement_stats = [09:25:14.222] #16 0x0000000000932520 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [09:25:14.222] query_string = 0x836590100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [09:25:14.222] input_message = {data = 0x836590100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [09:25:14.222] firstchar = [09:25:14.222] local_sigjmp_buf = {{_sjb = {9640374, 34909412176, 34909412136, 34909412720, 12357752, 1, 8192, 8388608, 34909389695, 0, 0, 1}}} [09:25:14.222] send_ready_for_query = false [09:25:14.222] idle_in_transaction_timeout_enabled = false [09:25:14.222] idle_session_timeout_enabled = false [09:25:14.222] #17 0x000000000092ccf9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:25:14.222] bsdata = [09:25:14.222] #18 0x0000000000886e77 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820c36894 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820c367d0) at ../src/backend/postmaster/launch_backend.c:274 [09:25:14.222] pid = [09:25:14.222] #19 0x000000000088b238 in BackendStartup (client_sock=0x820c367d0) at ../src/backend/postmaster/postmaster.c:3415 [09:25:14.222] startup_data = {canAcceptConnections = CAC_OK} [09:25:14.222] bn = 0x83659c3a8 [09:25:14.222] pid = [09:25:14.222] __error = [09:25:14.222] save_errno = [09:25:14.222] __error = [09:25:14.222] __error = [09:25:14.222] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [09:25:14.222] 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\037Y6\b", '\000' , "0h\303 \b\000\000\000h\225\036,\b\000\000\000\v\000\000\000\000\000\000\000^\037\037,\b", '\000' , "ph\303 \b\000\000\000$l\210\000\000\000\000\000\200h\303 \b", '\000' }, salen = 16}} [09:25:14.222] i = 0 [09:25:14.222] now = [09:25:14.222] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 768416898, events = 8, fd = 0, user_data = 0x820c36780}, {pos = 912180696, events = 8, fd = 549676560, user_data = 0x0}, {pos = 0, events = 0, fd = 547159641, user_data = 0x23fa82fa330a}, {pos = 767584160, events = 8, fd = 767655288, user_data = 0x820c36298}, {pos = 549675792, events = 8, fd = 549675672, user_data = 0x23fa82fa330a}, {pos = 767562632, events = 8, fd = 767655288, user_data = 0x820c362c8}, {pos = 549675840, events = 8, fd = 549675720, user_data = 0x82dc10194}, {pos = 563454984, events = 8, fd = 767623572, user_data = 0x820c36330}, {pos = -2097552326, events = 9210, fd = 769445936, user_data = 0x1}, {pos = 549675872, events = 8, fd = -2097532150, user_data = 0x82dbf9858}, {pos = 767655288, events = 8, fd = 549675832, user_data = 0x820c363b0}, {pos = 549675832, events = 8, fd = 767618316, user_data = 0x82195a408}, {pos = 767618316, events = 8, fd = 549675936, user_data = 0x23fa82f9e43a}, {pos = 549675976, events = 8, fd = 549676424, user_data = 0x820c363b0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3175220355, fd = 563478584, user_data = 0x800000001}, {pos = 563454984, events = 8, fd = 767562632, user_data = 0x82195f288}, {pos = 767531096, events = 8, fd = 563454984, user_data = 0x820c36438}, {pos = 549676536, events = 8, fd = 549676064, user_data = 0x23fa82fa2ca2}, {pos = 2700615, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 563478584, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 549676792, user_data = 0x2195a408}, {pos = 549676608, events = 8, fd = 549676208, user_data = 0x1}, {pos = 549676536, events = 8, fd = 32, user_data = 0x820c364a0}, {pos = -2097534349, events = 9210, fd = 549676480, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821960038}, {pos = 1, events = 8, fd = 563454984, user_data = 0x82dbf9858}, {pos = 549676792, events = 8, fd = 549676608, user_data = 0x820c364b0}, {pos = 0, events = 0, fd = 563425288, user_data = 0x20}, {pos = 549676592, events = 8, fd = -2097558809, user_data = 0x821953008}, {pos = 563426312, events = 8, fd = 563427336, user_data = 0x821953c08}, {pos = 563441672, events = 8, fd = 563442696, user_data = 0x821957808}, {pos = 563444744, events = 8, fd = 563445768, user_data = 0x821958408}, {pos = 563447816, events = 8, fd = 563448840, user_data = 0x821959008}, {pos = 563450888, events = 8, fd = 563451912, user_data = 0x821959c08}, {pos = 563453960, events = 8, fd = 563454984, user_data = 0x82195a808}, {pos = 563457032, events = 8, fd = 563458056, user_data = 0x82195b408}, {pos = 563460104, events = 8, fd = 563461128, user_data = 0x82195c008}, {pos = 563463176, events = 8, fd = 563464200, user_data = 0x82195cc08}, {pos = 563470344, events = 8, fd = 563471368, user_data = 0x82195e808}, {pos = 563473416, events = 8, fd = 563425288, user_data = 0x293547}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821960038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 549676792, events = 8, fd = 549676208, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 563478584, user_data = 0x1}, {pos = 563425288, events = 8, fd = 313, user_data = 0x820c366e0}, {pos = -2097560081, events = 9210, fd = 2700615, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 563478584, user_data = 0x1}, {pos = 563454984, events = 8, fd = 911736832, user_data = 0x1}, {pos = 911737236, events = 8, fd = 0, user_data = 0x820c366b0}, {pos = 740234604, events = 8, fd = 1, user_data = 0x836580000}, {pos = 549676768, events = 8, fd = 740230914, user_data = 0x82dd2b170 }, {pos = 12282784, events = 0, fd = 768782704, user_data = 0x82195a408}, {pos = 549676992, events = 8, fd = -2097560610, user_data = 0x83659e800}, {pos = 1, events = 0, fd = -2097560994, user_data = 0x821953008}, {pos = 549676776, events = 8, fd = 549676992, user_data = 0x1c20}, {pos = 911810304, events = 8, fd = -2097481328, user_data = 0x0}, {pos = 549651327, events = 8, fd = 8090935, user_data = 0x820c36770}, {pos = 740193296, events = 8, fd = 769445936, user_data = 0x82ddcf310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820c367a0}, {pos = 740236189, events = 8, fd = 911736832, user_data = 0x1d92}, {pos = 549677056, events = 8, fd = 740202746, user_data = 0x0}, {pos = 0, events = 0, fd = 547159641, user_data = 0x0}} [09:25:14.222] last_touch_time = 1726564846 [09:25:14.222] last_lockfile_recheck_time = 1726564846 [09:25:14.222] nevents = 1 [09:25:14.222] #21 0x0000000000889055 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820c36de0) at ../src/backend/postmaster/postmaster.c:1346 [09:25:14.222] userDoption = [09:25:14.222] listen_addr_saved = [09:25:14.222] output_config_variable = [09:25:14.222] opt = [09:25:14.222] status = [09:25:14.222] #22 0x00000000007c421c in main (argc=8, argv=0x820c36de0) at ../src/backend/main/main.c:197 [09:25:14.222] do_check_root = [09:25:14.235] [09:25:14.235] [09:25:14.235] [09:25:14.302] dumping /tmp/cores/postgres.11002.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:25:14.424] [New LWP 101906] [09:25:14.491] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [09:25:14.491] Program terminated with signal SIGABRT, Aborted. [09:25:14.491] Sent by thr_kill() from pid 11002 and user 1003. [09:25:14.491] #0 0x000000082c3bd41a in thr_kill () from /lib/libc.so.7 [09:25:15.114] [09:25:15.114] Thread 1 (LWP 101906): [09:25:15.114] #0 0x000000082c3bd41a in thr_kill () from /lib/libc.so.7 [09:25:15.114] No symbol table info available. [09:25:15.114] #1 0x000000082c336e64 in raise () from /lib/libc.so.7 [09:25:15.114] No symbol table info available. [09:25:15.114] #2 0x000000082c3e76f9 in abort () from /lib/libc.so.7 [09:25:15.114] No symbol table info available. [09:25:15.114] #3 0x0000000000a8bb45 in ExceptionalCondition (conditionName=0x2e7225 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [09:25:15.114] No locals. [09:25:15.114] #4 0x0000000000761059 in standard_ExecutorStart (queryDesc=0x838191088, eflags=0) at ../src/backend/executor/execMain.c:191 [09:25:15.114] estate = 0x8349d2100 [09:25:15.114] oldcontext = 0x834a07800 [09:25:15.114] #5 0x00000000006f7e65 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [09:25:15.114] copied_query = [09:25:15.114] rewritten = [09:25:15.114] plan = 0x8349d0bd8 [09:25:15.114] queryDesc = 0x838191088 [09:25:15.114] processed = [09:25:15.114] __error = [09:25:15.114] #6 RefreshMatViewByOid (matviewOid=27248, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [09:25:15.114] dest = [09:25:15.114] save_userid = 10 [09:25:15.114] save_sec_context = 0 [09:25:15.114] processed = 0 [09:25:15.114] matviewRel = 0x83809c270 [09:25:15.114] relowner = 10 [09:25:15.114] save_nestlevel = 2 [09:25:15.114] rule = [09:25:15.114] actions = [09:25:15.114] dataQuery = [09:25:15.114] tableSpace = [09:25:15.114] relpersistence = [09:25:15.114] OIDNewHeap = 27261 [09:25:15.114] address = [09:25:15.114] #7 0x00000000006f7a46 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [09:25:15.114] lockmode = [09:25:15.114] matviewOid = 0 [09:25:15.114] #8 0x00000000006cf7bc in ExecCreateTableAs (pstate=pstate@entry=0x834a07900, stmt=stmt@entry=0x834917fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820bbefb0) at ../src/backend/commands/createas.c:350 [09:25:15.114] refresh = 0x0 [09:25:15.114] query = 0x838164958 [09:25:15.114] into = 0x838164ca0 [09:25:15.114] do_refresh = false [09:25:15.114] address = [09:25:15.114] dest = [09:25:15.114] is_matview = [09:25:15.114] #9 0x0000000000938a68 in ProcessUtilitySlow (pstate=pstate@entry=0x834a07900, pstmt=pstmt@entry=0x834838a68, queryString=queryString@entry=0x834837100 "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=0x820bbefb0) at ../src/backend/tcop/utility.c:1675 [09:25:15.114] _local_sigjmp_buf = {{_sjb = {9667225, 0, 34908924888, 34908925264, 34908924896, 12349016, 0, 35242670336, 4294902655, 34908925004, 34908925040, 0}}} [09:25:15.114] _save_exception_stack = 0x820bbeeb0 [09:25:15.114] _save_context_stack = 0x0 [09:25:15.114] _do_rethrow = false [09:25:15.114] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [09:25:15.114] parsetree = 0x834917fd0 [09:25:15.114] commandCollected = false [09:25:15.114] needCleanup = false [09:25:15.114] address = [09:25:15.114] isTopLevel = [09:25:15.114] isCompleteQuery = [09:25:15.114] #10 0x00000000009373e8 in standard_ProcessUtility (pstmt=0x834838a68, queryString=0x834837100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838165188, qc=0x820bbefb0) at ../src/backend/tcop/utility.c:1030 [09:25:15.114] isAtomicContext = false [09:25:15.114] parsetree = 0x834917fd0 [09:25:15.114] readonly_flags = [09:25:15.114] pstate = 0x834a07900 [09:25:15.114] isTopLevel = [09:25:15.114] #11 0x0000000000936e78 in ProcessUtility (pstmt=0x18e12, queryString=0x6 , readOnlyTree=, context=742118394, params=0x0, queryEnv=0x0, dest=0x838165188, qc=0x820bbefb0) at ../src/backend/tcop/utility.c:523 [09:25:15.114] No locals. [09:25:15.114] #12 0x00000000009369b3 in PortalRunUtility (portal=0x8348dd100, pstmt=0x834838a68, isTopLevel=, setHoldSnapshot=, dest=0x838165188, qc=0x820bbefb0) at ../src/backend/tcop/pquery.c:1158 [09:25:15.114] No locals. [09:25:15.114] #13 0x0000000000936044 in PortalRunMulti (portal=portal@entry=0x8348dd100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x838165188, altdest=altdest@entry=0x838165188, qc=0x820bbefb0) at ../src/backend/tcop/pquery.c:1323 [09:25:15.114] pstmt = 0x834838a68 [09:25:15.114] stmtlist_item__state = {l = 0x838165138, i = 0} [09:25:15.114] active_snapshot_set = false [09:25:15.114] stmtlist_item = 0x838165150 [09:25:15.114] #14 0x0000000000935913 in PortalRun (portal=portal@entry=0x8348dd100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x838165188, altdest=altdest@entry=0x838165188, qc=0x820bbefb0) at ../src/backend/tcop/pquery.c:791 [09:25:15.114] _local_sigjmp_buf = {{_sjb = {9656461, 35241447680, 34908925608, 34908925840, 34908925616, 35241463808, 12315688, 12349016, 35241395071, 35241682320, 4294967984, 0}}} [09:25:15.114] _save_exception_stack = 0x820bbf080 [09:25:15.114] _save_context_stack = 0x0 [09:25:15.114] _do_rethrow = false [09:25:15.114] saveTopTransactionResourceOwner = 0x83492cd58 [09:25:15.114] saveTopTransactionContext = 0x8348e1000 [09:25:15.114] saveActivePortal = 0x0 [09:25:15.114] saveResourceOwner = 0x83492cd58 [09:25:15.114] savePortalContext = 0x0 [09:25:15.114] saveMemoryContext = 0x8348e1000 [09:25:15.114] result = [09:25:15.114] nprocessed = [09:25:15.114] #15 0x00000000009347b2 in exec_simple_query (query_string=query_string@entry=0x834837100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [09:25:15.114] cmdtaglen = 24 [09:25:15.114] snapshot_set = [09:25:15.114] per_parsetree_context = 0x0 [09:25:15.114] plantree_list = [09:25:15.114] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:25:15.114] format = 0 [09:25:15.114] parsetree = 0x8348386a8 [09:25:15.114] commandTag = [09:25:15.114] cmdtagname = [09:25:15.114] querytree_list = [09:25:15.114] portal = 0x8348dd100 [09:25:15.114] receiver = 0x838165188 [09:25:15.114] parsetree_item__state = {l = 0x834838a18, i = 0} [09:25:15.114] msec_str = "\000\000\000\000\b", '\000' , "\004J\351f\000\000\000\000\tr\216\b\026\a\242\222" [09:25:15.114] dest = DestRemote [09:25:15.114] was_logged = [09:25:15.114] oldcontext = 0x8348e1000 [09:25:15.114] parsetree_list = 0x834838a18 [09:25:15.114] use_implicit_block = false [09:25:15.114] parsetree_item = 0x834838a30 [09:25:15.114] save_log_statement_stats = [09:25:15.114] #16 0x0000000000932520 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [09:25:15.114] query_string = 0x834837100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [09:25:15.114] input_message = {data = 0x834837100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [09:25:15.114] firstchar = [09:25:15.114] local_sigjmp_buf = {{_sjb = {9640374, 34908926080, 34908926040, 34908926624, 12357752, 1, 8192, 8388608, 34908865407, 0, 0, 1}}} [09:25:15.114] send_ready_for_query = false [09:25:15.114] idle_in_transaction_timeout_enabled = false [09:25:15.114] idle_session_timeout_enabled = false [09:25:15.114] #17 0x000000000092ccf9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:25:15.114] bsdata = [09:25:15.114] #18 0x0000000000886e77 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820bbfdc4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820bbfd00) at ../src/backend/postmaster/launch_backend.c:274 [09:25:15.114] pid = [09:25:15.114] #19 0x000000000088b238 in BackendStartup (client_sock=0x820bbfd00) at ../src/backend/postmaster/postmaster.c:3415 [09:25:15.114] startup_data = {canAcceptConnections = CAC_OK} [09:25:15.114] bn = 0x834843588 [09:25:15.114] pid = [09:25:15.114] __error = [09:25:15.114] save_errno = [09:25:15.114] __error = [09:25:15.114] __error = [09:25:15.114] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [09:25:15.114] 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\2034\b", '\000' , "`\375\273 \b\000\000\000h\005f+\b\000\000\000\v\000\000\000\000\000\000\000^\217f+\b", '\000' , "\240\375\273 \b\000\000\000$l\210\000\000\000\000\000\260\375\273 \b", '\000' }, salen = 16}} [09:25:15.114] i = 0 [09:25:15.114] now = [09:25:15.114] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 741743746, events = 8, fd = 0, user_data = 0x820bbfcb0}, {pos = 881464792, events = 8, fd = 549190464, user_data = 0x0}, {pos = 0, events = 0, fd = -394230937, user_data = 0x2355459730a}, {pos = 740911008, events = 8, fd = 740982136, user_data = 0x820bbf7c8}, {pos = 549189696, events = 8, fd = 549189576, user_data = 0x2355459730a}, {pos = 740889480, events = 8, fd = 740982136, user_data = 0x820bbf7f8}, {pos = 549189744, events = 8, fd = 549189624, user_data = 0x82c2a0194}, {pos = 556532744, events = 8, fd = 740950420, user_data = 0x820bbf860}, {pos = 1415128122, events = 565, fd = 742772784, user_data = 0x1}, {pos = 549189776, events = 8, fd = 1415148298, user_data = 0x82c289858}, {pos = 740982136, events = 8, fd = 549189736, user_data = 0x820bbf8e0}, {pos = 549189736, events = 8, fd = 740945164, user_data = 0x8212c0408}, {pos = 740945164, events = 8, fd = 549189840, user_data = 0x2355459243a}, {pos = 549189880, events = 8, fd = 549190328, user_data = 0x820bbf8e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2189163527, fd = 556556344, user_data = 0x800000001}, {pos = 556532744, events = 8, fd = 740889480, user_data = 0x8212c5288}, {pos = 740857944, events = 8, fd = 556532744, user_data = 0x820bbf968}, {pos = 549190440, events = 8, fd = 549189968, user_data = 0x23554596ca2}, {pos = 2700615, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 556556344, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 549190696, user_data = 0x212c0408}, {pos = 549190512, events = 8, fd = 549190112, user_data = 0x1}, {pos = 549190440, events = 8, fd = 32, user_data = 0x820bbf9d0}, {pos = 1415146099, events = 565, fd = 549190384, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8212c6038}, {pos = 1, events = 8, fd = 556532744, user_data = 0x82c289858}, {pos = 549190696, events = 8, fd = 549190512, user_data = 0x820bbf9e0}, {pos = 0, events = 0, fd = 556503048, user_data = 0x20}, {pos = 549190496, events = 8, fd = 1415121639, user_data = 0x8212b9008}, {pos = 556504072, events = 8, fd = 556505096, user_data = 0x8212b9c08}, {pos = 556519432, events = 8, fd = 556520456, user_data = 0x8212bd808}, {pos = 556522504, events = 8, fd = 556523528, user_data = 0x8212be408}, {pos = 556525576, events = 8, fd = 556526600, user_data = 0x8212bf008}, {pos = 556528648, events = 8, fd = 556529672, user_data = 0x8212bfc08}, {pos = 556531720, events = 8, fd = 556532744, user_data = 0x8212c0808}, {pos = 556534792, events = 8, fd = 556535816, user_data = 0x8212c1408}, {pos = 556537864, events = 8, fd = 556538888, user_data = 0x8212c2008}, {pos = 556540936, events = 8, fd = 556541960, user_data = 0x8212c2c08}, {pos = 556548104, events = 8, fd = 556549128, user_data = 0x8212c4808}, {pos = 556551176, events = 8, fd = 556503048, user_data = 0x293547}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8212c6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 549190696, events = 8, fd = 549190112, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 556556344, user_data = 0x1}, {pos = 556503048, events = 8, fd = 313, user_data = 0x820bbfc10}, {pos = 1415120367, events = 565, fd = 2700615, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 556556344, user_data = 0x1}, {pos = 556532744, events = 8, fd = 880963584, user_data = 0x1}, {pos = 880963988, events = 8, fd = 0, user_data = 0x820bbfbe0}, {pos = 728139116, events = 8, fd = 1, user_data = 0x834827000}, {pos = 549190672, events = 8, fd = 728135426, user_data = 0x82c3bb170 }, {pos = 12282784, events = 0, fd = 742109552, user_data = 0x8212c0408}, {pos = 549190896, events = 8, fd = 1415119838, user_data = 0x834845800}, {pos = 1, events = 0, fd = 1415119454, user_data = 0x8212b9008}, {pos = 549190680, events = 8, fd = 549190896, user_data = 0x1c20}, {pos = 881036992, events = 8, fd = 1415199120, user_data = 0x0}, {pos = 549127039, events = 8, fd = 8090935, user_data = 0x820bbfca0}, {pos = 728097808, events = 8, fd = 742772784, user_data = 0x82c45f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820bbfcd0}, {pos = 728140701, events = 8, fd = 880963584, user_data = 0x1dca}, {pos = 549190960, events = 8, fd = 728107258, user_data = 0x0}, {pos = 0, events = 0, fd = -394230937, user_data = 0x0}} [09:25:15.114] last_touch_time = 1726564846 [09:25:15.114] last_lockfile_recheck_time = 1726564846 [09:25:15.114] nevents = 1 [09:25:15.114] #21 0x0000000000889055 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820bc0310) at ../src/backend/postmaster/postmaster.c:1346 [09:25:15.114] userDoption = [09:25:15.114] listen_addr_saved = [09:25:15.114] output_config_variable = [09:25:15.114] opt = [09:25:15.114] status = [09:25:15.114] #22 0x00000000007c421c in main (argc=4, argv=0x820bc0310) at ../src/backend/main/main.c:197 [09:25:15.114] do_check_root = [09:25:15.127] [09:25:15.127] [09:25:15.127] [09:25:15.192] dumping /tmp/cores/postgres.17775.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:25:15.313] [New LWP 100113] [09:25:15.382] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [09:25:15.382] Program terminated with signal SIGABRT, Aborted. [09:25:15.382] Sent by thr_kill() from pid 17775 and user 1003. [09:25:15.382] #0 0x000000082a57541a in thr_kill () from /lib/libc.so.7 [09:25:16.025] [09:25:16.025] Thread 1 (LWP 100113): [09:25:16.025] #0 0x000000082a57541a in thr_kill () from /lib/libc.so.7 [09:25:16.025] No symbol table info available. [09:25:16.025] #1 0x000000082a4eee64 in raise () from /lib/libc.so.7 [09:25:16.025] No symbol table info available. [09:25:16.025] #2 0x000000082a59f6f9 in abort () from /lib/libc.so.7 [09:25:16.025] No symbol table info available. [09:25:16.025] #3 0x0000000000a8bb45 in ExceptionalCondition (conditionName=0x2e7225 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [09:25:16.025] No locals. [09:25:16.025] #4 0x0000000000761059 in standard_ExecutorStart (queryDesc=0x83664e088, eflags=0) at ../src/backend/executor/execMain.c:191 [09:25:16.025] estate = 0x836690100 [09:25:16.025] oldcontext = 0x83b8d8800 [09:25:16.025] #5 0x0000000839644862 in pgss_ExecutorStart (queryDesc=0x83664e088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [09:25:16.025] No locals. [09:25:16.025] #6 0x00000000006f7e65 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [09:25:16.025] copied_query = [09:25:16.025] rewritten = [09:25:16.025] plan = 0x83b8cebd8 [09:25:16.025] queryDesc = 0x83664e088 [09:25:16.025] processed = [09:25:16.025] __error = [09:25:16.025] #7 RefreshMatViewByOid (matviewOid=27392, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [09:25:16.025] dest = [09:25:16.025] save_userid = 10 [09:25:16.025] save_sec_context = 0 [09:25:16.025] processed = 0 [09:25:16.025] matviewRel = 0x83b886ed8 [09:25:16.025] relowner = 10 [09:25:16.025] save_nestlevel = 2 [09:25:16.025] rule = [09:25:16.025] actions = [09:25:16.025] dataQuery = [09:25:16.025] tableSpace = [09:25:16.025] relpersistence = [09:25:16.025] OIDNewHeap = 27399 [09:25:16.025] address = [09:25:16.025] #8 0x00000000006f7a46 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [09:25:16.025] lockmode = [09:25:16.025] matviewOid = 0 [09:25:16.025] #9 0x00000000006cf7bc in ExecCreateTableAs (pstate=pstate@entry=0x83b8d8900, stmt=stmt@entry=0x83655bfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820f92be0) at ../src/backend/commands/createas.c:350 [09:25:16.025] refresh = 0x0 [09:25:16.025] query = 0x8365a6bc8 [09:25:16.025] into = 0x83655bf40 [09:25:16.025] do_refresh = false [09:25:16.025] address = [09:25:16.025] dest = [09:25:16.025] is_matview = [09:25:16.025] #10 0x0000000000938a68 in ProcessUtilitySlow (pstate=pstate@entry=0x83b8d8900, pstmt=pstmt@entry=0x83655be30, queryString=queryString@entry=0x8364be100 "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=0x820f92be0) at ../src/backend/tcop/utility.c:1675 [09:25:16.025] _local_sigjmp_buf = {{_sjb = {9667225, 0, 34912937544, 34912937920, 34912937552, 12349016, 0, 35358869760, 34912928639, 7, 34912937696, 0}}} [09:25:16.025] _save_exception_stack = 0x820f928d0 [09:25:16.025] _save_context_stack = 0x0 [09:25:16.025] _do_rethrow = false [09:25:16.025] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [09:25:16.025] parsetree = 0x83655bfd0 [09:25:16.025] commandCollected = false [09:25:16.025] needCleanup = false [09:25:16.025] address = [09:25:16.025] isTopLevel = [09:25:16.025] isCompleteQuery = [09:25:16.025] #11 0x00000000009373e8 in standard_ProcessUtility (pstmt=0x83655be30, queryString=queryString@entry=0x8364be100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8365a7368, qc=0x820f92be0) at ../src/backend/tcop/utility.c:1030 [09:25:16.025] isAtomicContext = false [09:25:16.025] parsetree = 0x83655bfd0 [09:25:16.025] readonly_flags = [09:25:16.025] pstate = 0x83b8d8900 [09:25:16.025] isTopLevel = [09:25:16.025] #12 0x0000000839644dee in pgss_ProcessUtility (pstmt=0x83655be30, queryString=0x8364be100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8365a7368, qc=0x820f92be0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [09:25:16.025] _local_sigjmp_buf = {{_sjb = {35322613031, 34912938192, 34912938056, 34912938512, 35271327280, 0, 12349016, 34912938720, 34912928639, 34912938292, 34912938320, 0}}} [09:25:16.025] _save_exception_stack = 0x820f92ae0 [09:25:16.025] _save_context_stack = 0x0 [09:25:16.025] _do_rethrow = false [09:25:16.025] bufusage = {shared_blks_hit = 35322613031, shared_blks_read = 34912938192, shared_blks_dirtied = 34912938056, shared_blks_written = 34912938512, local_blks_hit = 35271327280, local_blks_read = 0, local_blks_dirtied = 12349016, local_blks_written = 34912938720, temp_blks_read = 34912928639, temp_blks_written = 34912938292, shared_blk_read_time = {ticks = 34912938320}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4153072027166685440}, local_blk_write_time = {ticks = 12358056}, temp_blk_read_time = {ticks = 35330889344}, temp_blk_write_time = {ticks = 12311632}} [09:25:16.025] walusage_start = {wal_records = 8931, wal_fpi = 123, wal_bytes = 1179846} [09:25:16.025] duration = [09:25:16.025] bufusage_start = {shared_blks_hit = 150145, shared_blks_read = 8775, shared_blks_dirtied = 2713, shared_blks_written = 2341, 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}} [09:25:16.025] walusage = {wal_records = -6487635381251644614, wal_fpi = 35271327696, wal_bytes = 123} [09:25:16.025] start = {ticks = -188732246826} [09:25:16.025] rows = [09:25:16.025] saved_queryId = 6041762721901209185 [09:25:16.025] parsetree = [09:25:16.025] saved_stmt_location = 0 [09:25:16.025] saved_stmt_len = 69 [09:25:16.025] enabled = [09:25:16.025] #13 0x00000000009369b3 in PortalRunUtility (portal=0x836566100, pstmt=0x83655be30, isTopLevel=, setHoldSnapshot=, dest=0x8365a7368, qc=0x820f92be0) at ../src/backend/tcop/pquery.c:1158 [09:25:16.025] No locals. [09:25:16.025] #14 0x0000000000936044 in PortalRunMulti (portal=portal@entry=0x836566100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8365a7368, altdest=altdest@entry=0x8365a7368, qc=0x820f92be0) at ../src/backend/tcop/pquery.c:1323 [09:25:16.025] pstmt = 0x83655be30 [09:25:16.025] stmtlist_item__state = {l = 0x8365a7318, i = 0} [09:25:16.025] active_snapshot_set = false [09:25:16.025] stmtlist_item = 0x8365a7330 [09:25:16.025] #15 0x0000000000935913 in PortalRun (portal=portal@entry=0x836566100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8365a7368, altdest=altdest@entry=0x8365a7368, qc=0x820f92be0) at ../src/backend/tcop/pquery.c:791 [09:25:16.025] _local_sigjmp_buf = {{_sjb = {9656461, 35271368960, 34912938712, 34912938944, 34912938720, 35271462912, 12315688, 12349016, 35271345023, 35271321056, 4294967984, 0}}} [09:25:16.025] _save_exception_stack = 0x820f92cb0 [09:25:16.025] _save_context_stack = 0x0 [09:25:16.025] _do_rethrow = false [09:25:16.025] saveTopTransactionResourceOwner = 0x8365b4a98 [09:25:16.025] saveTopTransactionContext = 0x83657d000 [09:25:16.025] saveActivePortal = 0x0 [09:25:16.025] saveResourceOwner = 0x8365b4a98 [09:25:16.025] savePortalContext = 0x0 [09:25:16.025] saveMemoryContext = 0x83657d000 [09:25:16.025] result = [09:25:16.025] nprocessed = [09:25:16.025] #16 0x00000000009347b2 in exec_simple_query (query_string=query_string@entry=0x8364be100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [09:25:16.025] cmdtaglen = 24 [09:25:16.025] snapshot_set = [09:25:16.025] per_parsetree_context = 0x0 [09:25:16.025] plantree_list = [09:25:16.025] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:25:16.025] format = 0 [09:25:16.025] parsetree = 0x8364bf6a8 [09:25:16.025] commandTag = [09:25:16.025] cmdtagname = [09:25:16.025] querytree_list = [09:25:16.025] portal = 0x836566100 [09:25:16.025] receiver = 0x8365a7368 [09:25:16.025] parsetree_item__state = {l = 0x8364bfa18, i = 0} [09:25:16.025] msec_str = "\000\000\000\000\b", '\000' , ")J\351f\000\000\000\000\351\316Z\372\232\t\321\021" [09:25:16.025] dest = DestRemote [09:25:16.025] was_logged = [09:25:16.025] oldcontext = 0x83657d000 [09:25:16.025] parsetree_list = 0x8364bfa18 [09:25:16.025] use_implicit_block = false [09:25:16.025] parsetree_item = 0x8364bfa30 [09:25:16.025] save_log_statement_stats = [09:25:16.025] #17 0x0000000000932520 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [09:25:16.025] query_string = 0x8364be100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [09:25:16.025] input_message = {data = 0x8364be100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [09:25:16.025] firstchar = [09:25:16.025] local_sigjmp_buf = {{_sjb = {9640374, 34912939184, 34912939144, 34912939728, 12357752, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [09:25:16.025] send_ready_for_query = false [09:25:16.025] idle_in_transaction_timeout_enabled = false [09:25:16.025] idle_session_timeout_enabled = false [09:25:16.025] #18 0x000000000092ccf9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:25:16.025] bsdata = [09:25:16.025] #19 0x0000000000886e77 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820f939f4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f93930) at ../src/backend/postmaster/launch_backend.c:274 [09:25:16.025] pid = [09:25:16.025] #20 0x000000000088b238 in BackendStartup (client_sock=0x820f93930) at ../src/backend/postmaster/postmaster.c:3415 [09:25:16.025] startup_data = {canAcceptConnections = CAC_OK} [09:25:16.025] bn = 0x8364ca678 [09:25:16.025] pid = [09:25:16.025] __error = [09:25:16.025] save_errno = [09:25:16.025] __error = [09:25:16.025] __error = [09:25:16.025] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [09:25:16.025] 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 = " \354K6\b", '\000' , "\2209\371 \b\000\000\000h\205/)\b\000\000\000\v\000\000\000\000\000\000\000^\0170)\b", '\000' , "\3209\371 \b\000\000\000$l\210\000\000\000\000\000\3409\371 \b", '\000' }, salen = 16}} [09:25:16.025] i = 0 [09:25:16.025] now = [09:25:16.025] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 709991554, events = 8, fd = 0, user_data = 0x820f938e0}, {pos = 911349208, events = 8, fd = 553203568, user_data = 0x0}, {pos = 2084651786, events = 1369, fd = 709158816, user_data = 0x82a45fd78}, {pos = 553202664, events = 8, fd = 553202784, user_data = 0x820f933e8}, {pos = 2084651786, events = 1369, fd = 709137288, user_data = 0x82a45fd78}, {pos = 553202712, events = 8, fd = 553202832, user_data = 0x820f93418}, {pos = 709198228, events = 8, fd = 554726408, user_data = 0x82a458194}, {pos = 553202816, events = 8, fd = 2084631610, user_data = 0x820f93420}, {pos = 690971664, events = 8, fd = 711020592, user_data = 0x5597c41430a}, {pos = 709105752, events = 8, fd = 709229944, user_data = 0x820f93488}, {pos = 553202944, events = 8, fd = 553202824, user_data = 0x82a456d0c}, {pos = 554726408, events = 8, fd = 709192972, user_data = 0x820f934f0}, {pos = 2084631610, events = 1369, fd = 553202968, user_data = 0x820f936e8}, {pos = 553202944, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x82110d038}, {pos = 1, events = 2784446974, fd = 554726408, user_data = 0x82a449388}, {pos = 554747848, events = 8, fd = 0, user_data = 0x0}, {pos = 553203080, events = 8, fd = 553203544, user_data = 0x820f93570}, {pos = 2084650146, events = 1369, fd = 2700615, user_data = 0x6d68b}, {pos = 2090263927, events = 2784446974, fd = 554750008, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820f93858}, {pos = 554726408, events = 3, fd = 553203616, user_data = 0x82110c828}, {pos = 656, events = 0, fd = 553203544, user_data = 0x820f93588}, {pos = 553203184, events = 8, fd = 2084649755, user_data = 0x820f93720}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 554750008, events = 8, fd = 1, user_data = 0x821107408}, {pos = 709105752, events = 8, fd = 553203800, user_data = 0x820f937a0}, {pos = 553203200, events = 8, fd = 0, user_data = 0x821100008}, {pos = 33, events = 0, fd = 553203600, user_data = 0x5597c40dae7}, {pos = 554696712, events = 8, fd = 554697736, user_data = 0x821100808}, {pos = 554699784, events = 8, fd = 554713096, user_data = 0x821104408}, {pos = 554715144, events = 8, fd = 554716168, user_data = 0x821105008}, {pos = 554718216, events = 8, fd = 554719240, user_data = 0x821105c08}, {pos = 554721288, events = 8, fd = 554722312, user_data = 0x821106808}, {pos = 554724360, events = 8, fd = 554725384, user_data = 0x821107408}, {pos = 554727432, events = 8, fd = 554728456, user_data = 0x821108008}, {pos = 554730504, events = 8, fd = 554731528, user_data = 0x821108c08}, {pos = 554733576, events = 8, fd = 554734600, user_data = 0x821109808}, {pos = 554736648, events = 8, fd = 554741768, user_data = 0x82110b408}, {pos = 554743816, events = 8, fd = 554744840, user_data = 0x82110e408}, {pos = 228702000, events = 0, fd = 554696712, user_data = 0x293547}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82110d038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 553203800, events = 8, fd = 553203200, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 554750008, user_data = 0x1}, {pos = 554696712, events = 8, fd = 313, user_data = 0x820f93840}, {pos = 2084623855, events = 1369, fd = 2700615, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 554750008, user_data = 0x1}, {pos = 554726408, events = 8, fd = 910876672, user_data = 0x1}, {pos = 910877076, events = 8, fd = 0, user_data = 0x820f93810}, {pos = 691012972, events = 8, fd = 1, user_data = 0x8364ae000}, {pos = 553203776, events = 8, fd = 691009282, user_data = 0x82a573170 }, {pos = 12282784, events = 0, fd = 710357360, user_data = 0x821107408}, {pos = 553204000, events = 8, fd = 2084623326, user_data = 0x8364cc800}, {pos = 1, events = 0, fd = 2084622942, user_data = 0x821100008}, {pos = 553203784, events = 8, fd = 553204000, user_data = 0x1c20}, {pos = 910945312, events = 8, fd = 2084702608, user_data = 0x0}, {pos = 553190271, events = 8, fd = 8090935, user_data = 0x820f938d0}, {pos = 690971664, events = 8, fd = 711020592, user_data = 0x82a617310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820f93900}, {pos = 691014557, events = 8, fd = 910876672, user_data = 0x3918}, {pos = 553204064, events = 8, fd = 690981114, user_data = 0x0}, {pos = 0, events = 0, fd = 1681744698, user_data = 0x0}} [09:25:16.025] last_touch_time = 1726564884 [09:25:16.025] last_lockfile_recheck_time = 1726564884 [09:25:16.025] nevents = 1 [09:25:16.025] #22 0x0000000000889055 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f93f40) at ../src/backend/postmaster/postmaster.c:1346 [09:25:16.025] userDoption = [09:25:16.025] listen_addr_saved = [09:25:16.025] output_config_variable = [09:25:16.025] opt = [09:25:16.025] status = [09:25:16.025] #23 0x00000000007c421c in main (argc=4, argv=0x820f93f40) at ../src/backend/main/main.c:197 [09:25:16.025] do_check_root =