[20:45:56.470] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [20:45:56.836] dumping /tmp/cores/postgres.10721.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:45:56.963] [New LWP 101826] [20:45:57.048] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [20:45:57.048] Program terminated with signal SIGABRT, Aborted. [20:45:57.048] Sent by thr_kill() from pid 10721 and user 1003. [20:45:57.048] #0 0x000000082d9df41a in thr_kill () from /lib/libc.so.7 [20:45:57.629] [20:45:57.629] Thread 1 (LWP 101826): [20:45:57.629] #0 0x000000082d9df41a in thr_kill () from /lib/libc.so.7 [20:45:57.629] No symbol table info available. [20:45:57.629] #1 0x000000082d958e64 in raise () from /lib/libc.so.7 [20:45:57.629] No symbol table info available. [20:45:57.629] #2 0x000000082da096f9 in abort () from /lib/libc.so.7 [20:45:57.629] No symbol table info available. [20:45:57.629] #3 0x0000000000a89795 in ExceptionalCondition (conditionName=0x2e6199 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [20:45:57.629] No locals. [20:45:57.629] #4 0x000000000075fa99 in standard_ExecutorStart (queryDesc=0x8399a0380, eflags=0) at ../src/backend/executor/execMain.c:191 [20:45:57.629] estate = 0x839912100 [20:45:57.629] oldcontext = 0x83998b800 [20:45:57.629] #5 0x00000000006f6872 in refresh_matview_datafill (dest=0x848d1df38, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [20:45:57.629] copied_query = [20:45:57.629] rewritten = [20:45:57.629] plan = [20:45:57.629] queryDesc = 0x8399a0380 [20:45:57.629] processed = [20:45:57.629] __error = [20:45:57.629] #6 RefreshMatViewByOid (matviewOid=27276, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [20:45:57.629] dest = 0x848d1df38 [20:45:57.629] save_userid = 10 [20:45:57.629] save_sec_context = 0 [20:45:57.629] processed = 0 [20:45:57.629] matviewRel = 0x848cc2e18 [20:45:57.629] relowner = 10 [20:45:57.629] save_nestlevel = 2 [20:45:57.629] rule = [20:45:57.629] actions = [20:45:57.629] dataQuery = [20:45:57.629] tableSpace = [20:45:57.629] relpersistence = [20:45:57.629] OIDNewHeap = 27284 [20:45:57.629] address = [20:45:57.629] #7 0x00000000006f6456 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:45:57.629] lockmode = [20:45:57.629] matviewOid = 0 [20:45:57.629] #8 0x00000000006ce28c in ExecCreateTableAs (pstate=pstate@entry=0x83998b900, stmt=stmt@entry=0x848dc9fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821718050) at ../src/backend/commands/createas.c:350 [20:45:57.629] refresh = 0x0 [20:45:57.629] query = 0x848dba858 [20:45:57.629] into = 0x848dbaba0 [20:45:57.629] do_refresh = false [20:45:57.629] address = [20:45:57.629] dest = [20:45:57.629] is_matview = [20:45:57.629] #9 0x0000000000936ab8 in ProcessUtilitySlow (pstate=pstate@entry=0x83998b900, pstmt=pstmt@entry=0x83980aa68, queryString=queryString@entry=0x839809100 "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=0x821718050) at ../src/backend/tcop/utility.c:1675 [20:45:57.629] _local_sigjmp_buf = {{_sjb = {9659113, 0, 34920823928, 34920824304, 34920823936, 12338328, 0, 35326048512, 4294902655, 34920824044, 34920824080, 0}}} [20:45:57.629] _save_exception_stack = 0x821717f50 [20:45:57.629] _save_context_stack = 0x0 [20:45:57.629] _do_rethrow = false [20:45:57.629] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:45:57.629] parsetree = 0x848dc9fd0 [20:45:57.629] commandCollected = false [20:45:57.629] needCleanup = false [20:45:57.629] address = [20:45:57.629] isTopLevel = [20:45:57.629] isCompleteQuery = [20:45:57.629] #10 0x0000000000935438 in standard_ProcessUtility (pstmt=0x83980aa68, queryString=0x839809100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x848dbb088, qc=0x821718050) at ../src/backend/tcop/utility.c:1030 [20:45:57.629] isAtomicContext = false [20:45:57.629] parsetree = 0x848dc9fd0 [20:45:57.629] readonly_flags = [20:45:57.629] pstate = 0x83998b900 [20:45:57.629] isTopLevel = [20:45:57.629] #11 0x0000000000934ec8 in ProcessUtility (pstmt=0x18dc2, queryString=0x6 , readOnlyTree=, context=765326330, params=0x0, queryEnv=0x0, dest=0x848dbb088, qc=0x821718050) at ../src/backend/tcop/utility.c:523 [20:45:57.629] No locals. [20:45:57.629] #12 0x0000000000934a03 in PortalRunUtility (portal=0x8398e0100, pstmt=0x83980aa68, isTopLevel=, setHoldSnapshot=, dest=0x848dbb088, qc=0x821718050) at ../src/backend/tcop/pquery.c:1158 [20:45:57.629] No locals. [20:45:57.629] #13 0x0000000000934094 in PortalRunMulti (portal=portal@entry=0x8398e0100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x848dbb088, altdest=altdest@entry=0x848dbb088, qc=0x821718050) at ../src/backend/tcop/pquery.c:1323 [20:45:57.629] pstmt = 0x83980aa68 [20:45:57.629] stmtlist_item__state = {l = 0x848dbb038, i = 0} [20:45:57.629] active_snapshot_set = false [20:45:57.629] stmtlist_item = 0x848dbb050 [20:45:57.629] #14 0x0000000000933963 in PortalRun (portal=portal@entry=0x8398e0100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x848dbb088, altdest=altdest@entry=0x848dbb088, qc=0x821718050) at ../src/backend/tcop/pquery.c:791 [20:45:57.629] _local_sigjmp_buf = {{_sjb = {9648349, 35325346048, 34920824648, 34920824880, 34920824656, 35325362176, 12305000, 12338328, 35325346687, 35582150032, 4294967984, 0}}} [20:45:57.629] _save_exception_stack = 0x821718120 [20:45:57.629] _save_context_stack = 0x0 [20:45:57.629] _do_rethrow = false [20:45:57.629] saveTopTransactionResourceOwner = 0x8398f11d8 [20:45:57.629] saveTopTransactionContext = 0x8398e4000 [20:45:57.629] saveActivePortal = 0x0 [20:45:57.629] saveResourceOwner = 0x8398f11d8 [20:45:57.629] savePortalContext = 0x0 [20:45:57.629] saveMemoryContext = 0x8398e4000 [20:45:57.629] result = [20:45:57.629] nprocessed = [20:45:57.629] #15 0x0000000000932802 in exec_simple_query (query_string=query_string@entry=0x839809100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [20:45:57.629] cmdtaglen = 24 [20:45:57.629] snapshot_set = [20:45:57.629] per_parsetree_context = 0x0 [20:45:57.629] plantree_list = [20:45:57.629] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:45:57.629] format = 0 [20:45:57.629] parsetree = 0x83980a6a8 [20:45:57.629] commandTag = [20:45:57.629] cmdtagname = [20:45:57.629] querytree_list = [20:45:57.629] portal = 0x8398e0100 [20:45:57.629] receiver = 0x848dbb088 [20:45:57.629] parsetree_item__state = {l = 0x83980aa18, i = 0} [20:45:57.629] msec_str = "\000\000\000\000\b", '\000' , "\226\272\334f\000\000\000\000\306$\346\3211J\275\276" [20:45:57.629] dest = DestRemote [20:45:57.629] was_logged = [20:45:57.629] oldcontext = 0x8398e4000 [20:45:57.629] parsetree_list = 0x83980aa18 [20:45:57.629] use_implicit_block = false [20:45:57.629] parsetree_item = 0x83980aa30 [20:45:57.629] save_log_statement_stats = [20:45:57.629] #16 0x0000000000930570 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [20:45:57.629] query_string = 0x839809100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:45:57.629] input_message = {data = 0x839809100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:45:57.629] firstchar = [20:45:57.629] local_sigjmp_buf = {{_sjb = {9632262, 34920825120, 34920825080, 34920825664, 12347064, 1, 8192, 8388608, 34920792959, 0, 0, 1}}} [20:45:57.629] send_ready_for_query = false [20:45:57.629] idle_in_transaction_timeout_enabled = false [20:45:57.629] idle_session_timeout_enabled = false [20:45:57.629] #17 0x000000000092ad49 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:45:57.629] bsdata = [20:45:57.629] #18 0x0000000000884ee7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821718e64 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821718da0) at ../src/backend/postmaster/launch_backend.c:274 [20:45:57.629] pid = [20:45:57.629] #19 0x00000000008892a8 in BackendStartup (client_sock=0x821718da0) at ../src/backend/postmaster/postmaster.c:3415 [20:45:57.629] startup_data = {canAcceptConnections = CAC_OK} [20:45:57.629] bn = 0x8398151c8 [20:45:57.629] pid = [20:45:57.629] __error = [20:45:57.629] save_errno = [20:45:57.629] __error = [20:45:57.629] __error = [20:45:57.629] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [20:45:57.629] 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\257\2009\b", '\000' , "\216q!\b\000\000\000h\025\347,\b\000\000\000\v\000\000\000\000\000\000\000^\237\347,\b", '\000' , "@\216q!\b\000\000\000\224L\210\000\000\000\000\000P\216q!\b", '\000' }, salen = 16}} [20:45:57.629] i = 0 [20:45:57.629] now = [20:45:57.629] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 965105112, events = 8, fd = 561089504, user_data = 0x0}, {pos = 0, events = 0, fd = 717117939, user_data = 0x36a3eb85b30a}, {pos = 764118944, events = 8, fd = 764190072, user_data = 0x821718868}, {pos = 561088736, events = 8, fd = 561088616, user_data = 0x36a3eb85b30a}, {pos = 764097416, events = 8, fd = 764190072, user_data = 0x821718898}, {pos = 561088784, events = 8, fd = 561088664, user_data = 0x82d8c2194}, {pos = 576967688, events = 8, fd = 764158356, user_data = 0x821718900}, {pos = -343579590, events = 13987, fd = 765980720, user_data = 0x1}, {pos = 561088816, events = 8, fd = -343559414, user_data = 0x82d8ab858}, {pos = 764190072, events = 8, fd = 561088776, user_data = 0x821718980}, {pos = 561088776, events = 8, fd = 764153100, user_data = 0x82263d408}, {pos = 764153100, events = 8, fd = 561088880, user_data = 0x36a3eb85643a}, {pos = 561088920, events = 8, fd = 561089368, user_data = 0x821718980}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 186987070, fd = 576991288, user_data = 0x800000001}, {pos = 576967688, events = 8, fd = 764097416, user_data = 0x822642288}, {pos = 764065880, events = 8, fd = 576967688, user_data = 0x821718a08}, {pos = 561089480, events = 8, fd = 561089008, user_data = 0x36a3eb85aca2}, {pos = 2699716, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 576991288, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 561089736, user_data = 0x2263d408}, {pos = 561089552, events = 8, fd = 561089152, user_data = 0x1}, {pos = 561089480, events = 8, fd = 32, user_data = 0x821718a70}, {pos = -343561613, events = 13987, fd = 561089424, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822643038}, {pos = 1, events = 8, fd = 576967688, user_data = 0x82d8ab858}, {pos = 561089736, events = 8, fd = 561089552, user_data = 0x821718a80}, {pos = 0, events = 0, fd = 576937992, user_data = 0x20}, {pos = 561089536, events = 8, fd = -343586073, user_data = 0x822636008}, {pos = 576939016, events = 8, fd = 576940040, user_data = 0x822636c08}, {pos = 576954376, events = 8, fd = 576955400, user_data = 0x82263a808}, {pos = 576957448, events = 8, fd = 576958472, user_data = 0x82263b408}, {pos = 576960520, events = 8, fd = 576961544, user_data = 0x82263c008}, {pos = 576963592, events = 8, fd = 576964616, user_data = 0x82263cc08}, {pos = 576966664, events = 8, fd = 576967688, user_data = 0x82263d808}, {pos = 576969736, events = 8, fd = 576970760, user_data = 0x82263e408}, {pos = 576972808, events = 8, fd = 576973832, user_data = 0x82263f008}, {pos = 576975880, events = 8, fd = 576976904, user_data = 0x82263fc08}, {pos = 576983048, events = 8, fd = 576984072, user_data = 0x822641808}, {pos = 576986120, events = 8, fd = 576937992, user_data = 0x2931c4}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822643038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 561089736, events = 8, fd = 561089152, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 576991288, user_data = 0x1}, {pos = 576937992, events = 8, fd = 313, user_data = 0x821718cb0}, {pos = -343587345, events = 13987, fd = 2699716, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 576991288, user_data = 0x1}, {pos = 576967688, events = 8, fd = 964661248, user_data = 0x1}, {pos = 964661652, events = 8, fd = 0, user_data = 0x821718c80}, {pos = 753374572, events = 8, fd = 1, user_data = 0x8397f9000}, {pos = 561089712, events = 8, fd = 753370882, user_data = 0x82d9dd170 }, {pos = 12272096, events = 0, fd = 765317488, user_data = 0x82263d408}, {pos = 561089936, events = 8, fd = -343587874, user_data = 0x839817800}, {pos = 1, events = 0, fd = -343588258, user_data = 0x822636008}, {pos = 561089720, events = 8, fd = 561089936, user_data = 0x1c20}, {pos = 964734720, events = 8, fd = -343508592, user_data = 0x0}, {pos = 561054591, events = 8, fd = 8085367, user_data = 0x821718d40}, {pos = 753333264, events = 8, fd = 765980720, user_data = 0x82da81310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821718d70}, {pos = 753376157, events = 8, fd = 964661248, user_data = 0x1d89}, {pos = 561090000, events = 8, fd = 753342714, user_data = 0x0}, {pos = 0, events = 0, fd = 717117939, user_data = 0x0}} [20:45:57.629] last_touch_time = 1725741698 [20:45:57.629] last_lockfile_recheck_time = 1725741698 [20:45:57.629] nevents = 1 [20:45:57.629] #21 0x00000000008870c5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8217193b0) at ../src/backend/postmaster/postmaster.c:1346 [20:45:57.629] userDoption = [20:45:57.629] listen_addr_saved = [20:45:57.629] output_config_variable = [20:45:57.629] opt = [20:45:57.629] status = [20:45:57.629] #22 0x00000000007c2c5c in main (argc=8, argv=0x8217193b0) at ../src/backend/main/main.c:197 [20:45:57.629] do_check_root = [20:45:57.640] [20:45:57.640] [20:45:57.640] [20:45:57.702] dumping /tmp/cores/postgres.10995.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:45:57.824] [New LWP 101815] [20:45:57.892] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [20:45:57.892] Program terminated with signal SIGABRT, Aborted. [20:45:57.892] Sent by thr_kill() from pid 10995 and user 1003. [20:45:57.892] #0 0x000000082ae8341a in thr_kill () from /lib/libc.so.7 [20:45:58.432] [20:45:58.432] Thread 1 (LWP 101815): [20:45:58.432] #0 0x000000082ae8341a in thr_kill () from /lib/libc.so.7 [20:45:58.432] No symbol table info available. [20:45:58.432] #1 0x000000082adfce64 in raise () from /lib/libc.so.7 [20:45:58.432] No symbol table info available. [20:45:58.432] #2 0x000000082aead6f9 in abort () from /lib/libc.so.7 [20:45:58.432] No symbol table info available. [20:45:58.432] #3 0x0000000000a89795 in ExceptionalCondition (conditionName=0x2e6199 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [20:45:58.432] No locals. [20:45:58.432] #4 0x000000000075fa99 in standard_ExecutorStart (queryDesc=0x8348fb380, eflags=0) at ../src/backend/executor/execMain.c:191 [20:45:58.432] estate = 0x8429ee100 [20:45:58.432] oldcontext = 0x842939800 [20:45:58.432] #5 0x00000000006f6872 in refresh_matview_datafill (dest=0x8349bff38, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [20:45:58.432] copied_query = [20:45:58.432] rewritten = [20:45:58.432] plan = [20:45:58.432] queryDesc = 0x8348fb380 [20:45:58.432] processed = [20:45:58.432] __error = [20:45:58.432] #6 RefreshMatViewByOid (matviewOid=27483, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [20:45:58.432] dest = 0x8349bff38 [20:45:58.432] save_userid = 10 [20:45:58.432] save_sec_context = 0 [20:45:58.432] processed = 0 [20:45:58.432] matviewRel = 0x842911b00 [20:45:58.432] relowner = 10 [20:45:58.432] save_nestlevel = 2 [20:45:58.432] rule = [20:45:58.432] actions = [20:45:58.432] dataQuery = [20:45:58.432] tableSpace = [20:45:58.432] relpersistence = [20:45:58.432] OIDNewHeap = 27490 [20:45:58.432] address = [20:45:58.432] #7 0x00000000006f6456 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:45:58.432] lockmode = [20:45:58.432] matviewOid = 0 [20:45:58.432] #8 0x00000000006ce28c in ExecCreateTableAs (pstate=pstate@entry=0x842939900, stmt=stmt@entry=0x8349acfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82130f060) at ../src/backend/commands/createas.c:350 [20:45:58.432] refresh = 0x0 [20:45:58.432] query = 0x8349c1b58 [20:45:58.432] into = 0x8349c1ea0 [20:45:58.432] do_refresh = false [20:45:58.432] address = [20:45:58.432] dest = [20:45:58.432] is_matview = [20:45:58.432] #9 0x0000000000936ab8 in ProcessUtilitySlow (pstate=pstate@entry=0x842939900, pstmt=pstmt@entry=0x834826a68, queryString=queryString@entry=0x834825100 "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=0x82130f060) at ../src/backend/tcop/utility.c:1675 [20:45:58.432] _local_sigjmp_buf = {{_sjb = {9659113, 0, 34916592776, 34916593152, 34916592784, 12338328, 0, 35476707584, 4294902655, 34916592892, 34916592928, 0}}} [20:45:58.432] _save_exception_stack = 0x82130ef60 [20:45:58.432] _save_context_stack = 0x0 [20:45:58.432] _do_rethrow = false [20:45:58.432] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:45:58.432] parsetree = 0x8349acfd0 [20:45:58.432] commandCollected = false [20:45:58.432] needCleanup = false [20:45:58.432] address = [20:45:58.432] isTopLevel = [20:45:58.432] isCompleteQuery = [20:45:58.432] #10 0x0000000000935438 in standard_ProcessUtility (pstmt=0x834826a68, queryString=0x834825100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8349c2388, qc=0x82130f060) at ../src/backend/tcop/utility.c:1030 [20:45:58.432] isAtomicContext = false [20:45:58.432] parsetree = 0x8349acfd0 [20:45:58.432] readonly_flags = [20:45:58.432] pstate = 0x842939900 [20:45:58.432] isTopLevel = [20:45:58.432] #11 0x0000000000934ec8 in ProcessUtility (pstmt=0x18db7, queryString=0x6 , readOnlyTree=, context=719860730, params=0x0, queryEnv=0x0, dest=0x8349c2388, qc=0x82130f060) at ../src/backend/tcop/utility.c:523 [20:45:58.432] No locals. [20:45:58.432] #12 0x0000000000934a03 in PortalRunUtility (portal=0x8348cb100, pstmt=0x834826a68, isTopLevel=, setHoldSnapshot=, dest=0x8349c2388, qc=0x82130f060) at ../src/backend/tcop/pquery.c:1158 [20:45:58.432] No locals. [20:45:58.432] #13 0x0000000000934094 in PortalRunMulti (portal=portal@entry=0x8348cb100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8349c2388, altdest=altdest@entry=0x8349c2388, qc=0x82130f060) at ../src/backend/tcop/pquery.c:1323 [20:45:58.432] pstmt = 0x834826a68 [20:45:58.432] stmtlist_item__state = {l = 0x8349c2338, i = 0} [20:45:58.432] active_snapshot_set = false [20:45:58.432] stmtlist_item = 0x8349c2350 [20:45:58.432] #14 0x0000000000933963 in PortalRun (portal=portal@entry=0x8348cb100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8349c2388, altdest=altdest@entry=0x8349c2388, qc=0x82130f060) at ../src/backend/tcop/pquery.c:791 [20:45:58.432] _local_sigjmp_buf = {{_sjb = {9648349, 35241373952, 34916593496, 34916593728, 34916593504, 35241390080, 12305000, 12338328, 35241329535, 35242292624, 4294967984, 0}}} [20:45:58.432] _save_exception_stack = 0x82130f130 [20:45:58.432] _save_context_stack = 0x0 [20:45:58.432] _do_rethrow = false [20:45:58.432] saveTopTransactionResourceOwner = 0x83491a198 [20:45:58.432] saveTopTransactionContext = 0x8348cf000 [20:45:58.432] saveActivePortal = 0x0 [20:45:58.432] saveResourceOwner = 0x83491a198 [20:45:58.432] savePortalContext = 0x0 [20:45:58.432] saveMemoryContext = 0x8348cf000 [20:45:58.432] result = [20:45:58.432] nprocessed = [20:45:58.432] #15 0x0000000000932802 in exec_simple_query (query_string=query_string@entry=0x834825100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [20:45:58.432] cmdtaglen = 24 [20:45:58.432] snapshot_set = [20:45:58.432] per_parsetree_context = 0x0 [20:45:58.432] plantree_list = [20:45:58.432] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:45:58.432] format = 0 [20:45:58.432] parsetree = 0x8348266a8 [20:45:58.432] commandTag = [20:45:58.432] cmdtagname = [20:45:58.432] querytree_list = [20:45:58.432] portal = 0x8348cb100 [20:45:58.432] receiver = 0x8349c2388 [20:45:58.432] parsetree_item__state = {l = 0x834826a18, i = 0} [20:45:58.432] msec_str = "\000\000\000\000\b", '\000' , "\231\272\334f\000\000\000\000\366\375\237Y\322\336\314Y" [20:45:58.432] dest = DestRemote [20:45:58.432] was_logged = [20:45:58.432] oldcontext = 0x8348cf000 [20:45:58.432] parsetree_list = 0x834826a18 [20:45:58.432] use_implicit_block = false [20:45:58.432] parsetree_item = 0x834826a30 [20:45:58.432] save_log_statement_stats = [20:45:58.432] #16 0x0000000000930570 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [20:45:58.432] query_string = 0x834825100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:45:58.432] input_message = {data = 0x834825100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:45:58.432] firstchar = [20:45:58.432] local_sigjmp_buf = {{_sjb = {9632262, 34916593968, 34916593928, 34916594512, 12347064, 1, 8192, 8388608, 34916533119, 0, 0, 1}}} [20:45:58.432] send_ready_for_query = false [20:45:58.432] idle_in_transaction_timeout_enabled = false [20:45:58.432] idle_session_timeout_enabled = false [20:45:58.432] #17 0x000000000092ad49 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:45:58.432] bsdata = [20:45:58.432] #18 0x0000000000884ee7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82130fe74 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82130fdb0) at ../src/backend/postmaster/launch_backend.c:274 [20:45:58.432] pid = [20:45:58.432] #19 0x00000000008892a8 in BackendStartup (client_sock=0x82130fdb0) at ../src/backend/postmaster/postmaster.c:3415 [20:45:58.432] startup_data = {canAcceptConnections = CAC_OK} [20:45:58.432] bn = 0x8348310d8 [20:45:58.432] pid = [20:45:58.432] __error = [20:45:58.432] save_errno = [20:45:58.432] __error = [20:45:58.432] __error = [20:45:58.432] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [20:45:58.432] 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 = "\300n\2024\b", '\000' , "\020\3760!\b\000\000\000hU8+\b\000\000\000\v\000\000\000\000\000\000\000^\3378+\b", '\000' , "P\3760!\b\000\000\000\224L\210\000\000\000\000\000`\3760!\b", '\000' }, salen = 16}} [20:45:58.432] i = 0 [20:45:58.432] now = [20:45:58.432] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 719486082, events = 8, fd = 0, user_data = 0x82130fd60}, {pos = 881391064, events = 8, fd = 556858352, user_data = 0x0}, {pos = 0, events = 0, fd = -117417628, user_data = 0x299a5ded130a}, {pos = 718653344, events = 8, fd = 718724472, user_data = 0x82130f878}, {pos = 556857584, events = 8, fd = 556857464, user_data = 0x299a5ded130a}, {pos = 718631816, events = 8, fd = 718724472, user_data = 0x82130f8a8}, {pos = 556857632, events = 8, fd = 556857512, user_data = 0x82ad66194}, {pos = 563958792, events = 8, fd = 718692756, user_data = 0x82130f910}, {pos = 1575797818, events = 10650, fd = 720515120, user_data = 0x1}, {pos = 556857664, events = 8, fd = 1575817994, user_data = 0x82ad4f858}, {pos = 718724472, events = 8, fd = 556857624, user_data = 0x82130f990}, {pos = 556857624, events = 8, fd = 718687500, user_data = 0x8219d5408}, {pos = 718687500, events = 8, fd = 556857728, user_data = 0x299a5decc43a}, {pos = 556857768, events = 8, fd = 556858216, user_data = 0x82130f990}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1374031439, fd = 563982392, user_data = 0x800000001}, {pos = 563958792, events = 8, fd = 718631816, user_data = 0x8219da288}, {pos = 718600280, events = 8, fd = 563958792, user_data = 0x82130fa18}, {pos = 556858328, events = 8, fd = 556857856, user_data = 0x299a5ded0ca2}, {pos = 2699716, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 563982392, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 556858584, user_data = 0x219d5408}, {pos = 556858400, events = 8, fd = 556858000, user_data = 0x1}, {pos = 556858328, events = 8, fd = 32, user_data = 0x82130fa80}, {pos = 1575815795, events = 10650, fd = 556858272, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8219db038}, {pos = 1, events = 8, fd = 563958792, user_data = 0x82ad4f858}, {pos = 556858584, events = 8, fd = 556858400, user_data = 0x82130fa90}, {pos = 0, events = 0, fd = 563929096, user_data = 0x20}, {pos = 556858384, events = 8, fd = 1575791335, user_data = 0x8219ce008}, {pos = 563930120, events = 8, fd = 563931144, user_data = 0x8219cec08}, {pos = 563945480, events = 8, fd = 563946504, user_data = 0x8219d2808}, {pos = 563948552, events = 8, fd = 563949576, user_data = 0x8219d3408}, {pos = 563951624, events = 8, fd = 563952648, user_data = 0x8219d4008}, {pos = 563954696, events = 8, fd = 563955720, user_data = 0x8219d4c08}, {pos = 563957768, events = 8, fd = 563958792, user_data = 0x8219d5808}, {pos = 563960840, events = 8, fd = 563961864, user_data = 0x8219d6408}, {pos = 563963912, events = 8, fd = 563964936, user_data = 0x8219d7008}, {pos = 563966984, events = 8, fd = 563968008, user_data = 0x8219d7c08}, {pos = 563974152, events = 8, fd = 563975176, user_data = 0x8219d9808}, {pos = 563977224, events = 8, fd = 563929096, user_data = 0x2931c4}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8219db038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556858584, events = 8, fd = 556858000, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 563982392, user_data = 0x1}, {pos = 563929096, events = 8, fd = 313, user_data = 0x82130fcc0}, {pos = 1575790063, events = 10650, fd = 2699716, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 563982392, user_data = 0x1}, {pos = 563958792, events = 8, fd = 880889856, user_data = 0x1}, {pos = 880890260, events = 8, fd = 0, user_data = 0x82130fc90}, {pos = 725144940, events = 8, fd = 1, user_data = 0x834815000}, {pos = 556858560, events = 8, fd = 725141250, user_data = 0x82ae81170 }, {pos = 12272096, events = 0, fd = 719851888, user_data = 0x8219d5408}, {pos = 556858784, events = 8, fd = 1575789534, user_data = 0x834833800}, {pos = 1, events = 0, fd = 1575789150, user_data = 0x8219ce008}, {pos = 556858568, events = 8, fd = 556858784, user_data = 0x1c20}, {pos = 880963264, events = 8, fd = 1575868816, user_data = 0x0}, {pos = 556794751, events = 8, fd = 8085367, user_data = 0x82130fd50}, {pos = 725103632, events = 8, fd = 720515120, user_data = 0x82af25310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82130fd80}, {pos = 725146525, events = 8, fd = 880889856, user_data = 0x1d98}, {pos = 556858848, events = 8, fd = 725113082, user_data = 0x0}, {pos = 0, events = 0, fd = -117417628, user_data = 0x0}} [20:45:58.432] last_touch_time = 1725741698 [20:45:58.432] last_lockfile_recheck_time = 1725741698 [20:45:58.432] nevents = 1 [20:45:58.432] #21 0x00000000008870c5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8213103c8) at ../src/backend/postmaster/postmaster.c:1346 [20:45:58.432] userDoption = [20:45:58.432] listen_addr_saved = [20:45:58.432] output_config_variable = [20:45:58.432] opt = [20:45:58.432] status = [20:45:58.432] #22 0x00000000007c2c5c in main (argc=4, argv=0x8213103c8) at ../src/backend/main/main.c:197 [20:45:58.432] do_check_root = [20:45:58.444] [20:45:58.444] [20:45:58.444] [20:45:58.505] dumping /tmp/cores/postgres.17446.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:45:58.628] [New LWP 101865] [20:45:58.697] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [20:45:58.697] Program terminated with signal SIGABRT, Aborted. [20:45:58.697] Sent by thr_kill() from pid 17446 and user 1003. [20:45:58.697] #0 0x000000082a17841a in thr_kill () from /lib/libc.so.7 [20:45:59.267] [20:45:59.267] Thread 1 (LWP 101865): [20:45:59.267] #0 0x000000082a17841a in thr_kill () from /lib/libc.so.7 [20:45:59.267] No symbol table info available. [20:45:59.267] #1 0x000000082a0f1e64 in raise () from /lib/libc.so.7 [20:45:59.267] No symbol table info available. [20:45:59.267] #2 0x000000082a1a26f9 in abort () from /lib/libc.so.7 [20:45:59.267] No symbol table info available. [20:45:59.267] #3 0x0000000000a89795 in ExceptionalCondition (conditionName=0x2e6199 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [20:45:59.267] No locals. [20:45:59.267] #4 0x000000000075fa99 in standard_ExecutorStart (queryDesc=0x8387b4380, eflags=0) at ../src/backend/executor/execMain.c:191 [20:45:59.267] estate = 0x835d2e100 [20:45:59.267] oldcontext = 0x835cc5800 [20:45:59.267] #5 0x0000000839e8f862 in pgss_ExecutorStart (queryDesc=0x8387b4380, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:993 [20:45:59.267] No locals. [20:45:59.267] #6 0x00000000006f6872 in refresh_matview_datafill (dest=0x835cf8f38, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [20:45:59.267] copied_query = [20:45:59.267] rewritten = [20:45:59.267] plan = [20:45:59.267] queryDesc = 0x8387b4380 [20:45:59.267] processed = [20:45:59.267] __error = [20:45:59.267] #7 RefreshMatViewByOid (matviewOid=27247, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [20:45:59.267] dest = 0x835cf8f38 [20:45:59.267] save_userid = 10 [20:45:59.267] save_sec_context = 0 [20:45:59.267] processed = 0 [20:45:59.267] matviewRel = 0x8387f3d18 [20:45:59.267] relowner = 10 [20:45:59.267] save_nestlevel = 2 [20:45:59.267] rule = [20:45:59.267] actions = [20:45:59.267] dataQuery = [20:45:59.267] tableSpace = [20:45:59.267] relpersistence = [20:45:59.267] OIDNewHeap = 27259 [20:45:59.267] address = [20:45:59.267] #8 0x00000000006f6456 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:45:59.267] lockmode = [20:45:59.267] matviewOid = 0 [20:45:59.267] #9 0x00000000006ce28c in ExecCreateTableAs (pstate=pstate@entry=0x835cc5900, stmt=stmt@entry=0x835c8dfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820dc5be0) at ../src/backend/commands/createas.c:350 [20:45:59.267] refresh = 0x0 [20:45:59.267] query = 0x835d7d3c8 [20:45:59.267] into = 0x835c8df40 [20:45:59.267] do_refresh = false [20:45:59.267] address = [20:45:59.267] dest = [20:45:59.267] is_matview = [20:45:59.267] #10 0x0000000000936ab8 in ProcessUtilitySlow (pstate=pstate@entry=0x835cc5900, pstmt=pstmt@entry=0x835c8de30, queryString=queryString@entry=0x835bf0100 "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=0x820dc5be0) at ../src/backend/tcop/utility.c:1675 [20:45:59.267] _local_sigjmp_buf = {{_sjb = {9659113, 0, 34911049288, 34911049664, 34911049296, 12338328, 0, 35262322944, 34911028095, 7, 34911049440, 0}}} [20:45:59.267] _save_exception_stack = 0x820dc58d0 [20:45:59.267] _save_context_stack = 0x0 [20:45:59.267] _do_rethrow = false [20:45:59.267] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:45:59.267] parsetree = 0x835c8dfd0 [20:45:59.267] commandCollected = false [20:45:59.267] needCleanup = false [20:45:59.267] address = [20:45:59.267] isTopLevel = [20:45:59.267] isCompleteQuery = [20:45:59.267] #11 0x0000000000935438 in standard_ProcessUtility (pstmt=0x835c8de30, queryString=queryString@entry=0x835bf0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835d7db68, qc=0x820dc5be0) at ../src/backend/tcop/utility.c:1030 [20:45:59.267] isAtomicContext = false [20:45:59.267] parsetree = 0x835c8dfd0 [20:45:59.267] readonly_flags = [20:45:59.267] pstate = 0x835cc5900 [20:45:59.267] isTopLevel = [20:45:59.267] #12 0x0000000839e8fdee in pgss_ProcessUtility (pstmt=0x835c8de30, queryString=0x835bf0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835d7db68, qc=0x820dc5be0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1167 [20:45:59.267] _local_sigjmp_buf = {{_sjb = {35331308839, 34911049936, 34911049800, 34911050256, 35262094896, 0, 12338328, 34911050464, 34911028095, 34911050036, 34911050064, 0}}} [20:45:59.267] _save_exception_stack = 0x820dc5ae0 [20:45:59.267] _save_context_stack = 0x0 [20:45:59.267] _do_rethrow = false [20:45:59.267] bufusage = {shared_blks_hit = 35331308839, shared_blks_read = 34911049936, shared_blks_dirtied = 34911049800, shared_blks_written = 34911050256, local_blks_hit = 35262094896, local_blks_read = 0, local_blks_dirtied = 12338328, local_blks_written = 34911050464, temp_blks_read = 34911028095, temp_blks_written = 34911050036, shared_blk_read_time = {ticks = 34911050064}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4221329709034912000}, local_blk_write_time = {ticks = 12347368}, temp_blk_read_time = {ticks = 35346781824}, temp_blk_write_time = {ticks = 12300944}} [20:45:59.267] walusage_start = {wal_records = 8942, wal_fpi = 133, wal_bytes = 1196807} [20:45:59.267] duration = [20:45:59.267] bufusage_start = {shared_blks_hit = 151808, shared_blks_read = 7553, shared_blks_dirtied = 2538, shared_blks_written = 2477, 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}} [20:45:59.267] walusage = {wal_records = 904941487946635235, wal_fpi = 35262095312, wal_bytes = 123} [20:45:59.267] start = {ticks = -183381074842} [20:45:59.267] rows = [20:45:59.267] saved_queryId = 6041762721901209185 [20:45:59.267] parsetree = [20:45:59.267] saved_stmt_location = 0 [20:45:59.267] saved_stmt_len = 69 [20:45:59.267] enabled = [20:45:59.267] #13 0x0000000000934a03 in PortalRunUtility (portal=0x835c98100, pstmt=0x835c8de30, isTopLevel=, setHoldSnapshot=, dest=0x835d7db68, qc=0x820dc5be0) at ../src/backend/tcop/pquery.c:1158 [20:45:59.267] No locals. [20:45:59.267] #14 0x0000000000934094 in PortalRunMulti (portal=portal@entry=0x835c98100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835d7db68, altdest=altdest@entry=0x835d7db68, qc=0x820dc5be0) at ../src/backend/tcop/pquery.c:1323 [20:45:59.267] pstmt = 0x835c8de30 [20:45:59.267] stmtlist_item__state = {l = 0x835d7db18, i = 0} [20:45:59.267] active_snapshot_set = false [20:45:59.267] stmtlist_item = 0x835d7db30 [20:45:59.267] #15 0x0000000000933963 in PortalRun (portal=portal@entry=0x835c98100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835d7db68, altdest=altdest@entry=0x835d7db68, qc=0x820dc5be0) at ../src/backend/tcop/pquery.c:791 [20:45:59.267] _local_sigjmp_buf = {{_sjb = {9648349, 35262136576, 34911050456, 34911050688, 34911050464, 35262230528, 12305000, 12338328, 35262104447, 35262088672, 4294967984, 0}}} [20:45:59.267] _save_exception_stack = 0x820dc5cb0 [20:45:59.267] _save_context_stack = 0x0 [20:45:59.267] _do_rethrow = false [20:45:59.267] saveTopTransactionResourceOwner = 0x835ce6e18 [20:45:59.267] saveTopTransactionContext = 0x835caf000 [20:45:59.267] saveActivePortal = 0x0 [20:45:59.267] saveResourceOwner = 0x835ce6e18 [20:45:59.267] savePortalContext = 0x0 [20:45:59.267] saveMemoryContext = 0x835caf000 [20:45:59.267] result = [20:45:59.267] nprocessed = [20:45:59.267] #16 0x0000000000932802 in exec_simple_query (query_string=query_string@entry=0x835bf0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [20:45:59.267] cmdtaglen = 24 [20:45:59.267] snapshot_set = [20:45:59.267] per_parsetree_context = 0x0 [20:45:59.267] plantree_list = [20:45:59.267] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:45:59.267] format = 0 [20:45:59.267] parsetree = 0x835bf16a8 [20:45:59.267] commandTag = [20:45:59.267] cmdtagname = [20:45:59.267] querytree_list = [20:45:59.267] portal = 0x835c98100 [20:45:59.267] receiver = 0x835d7db68 [20:45:59.267] parsetree_item__state = {l = 0x835bf1a18, i = 0} [20:45:59.267] msec_str = "\000\000\000\000\b", '\000' , "\273\272\334f\000\000\000\000F\024\313\b|\033\246\226" [20:45:59.267] dest = DestRemote [20:45:59.267] was_logged = [20:45:59.267] oldcontext = 0x835caf000 [20:45:59.267] parsetree_list = 0x835bf1a18 [20:45:59.267] use_implicit_block = false [20:45:59.267] parsetree_item = 0x835bf1a30 [20:45:59.267] save_log_statement_stats = [20:45:59.267] #17 0x0000000000930570 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [20:45:59.267] query_string = 0x835bf0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:45:59.267] input_message = {data = 0x835bf0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:45:59.267] firstchar = [20:45:59.267] local_sigjmp_buf = {{_sjb = {9632262, 34911050928, 34911050888, 34911051472, 12347064, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [20:45:59.267] send_ready_for_query = false [20:45:59.267] idle_in_transaction_timeout_enabled = false [20:45:59.267] idle_session_timeout_enabled = false [20:45:59.267] #18 0x000000000092ad49 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:45:59.267] bsdata = [20:45:59.267] #19 0x0000000000884ee7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820dc69f4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820dc6930) at ../src/backend/postmaster/launch_backend.c:274 [20:45:59.267] pid = [20:45:59.267] #20 0x00000000008892a8 in BackendStartup (client_sock=0x820dc6930) at ../src/backend/postmaster/postmaster.c:3415 [20:45:59.267] startup_data = {canAcceptConnections = CAC_OK} [20:45:59.267] bn = 0x835bfc4e8 [20:45:59.267] pid = [20:45:59.267] __error = [20:45:59.267] save_errno = [20:45:59.267] __error = [20:45:59.267] __error = [20:45:59.267] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [20:45:59.267] 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\2775\b", '\000' , "\220i\334 \b\000\000\000h\305D+\b\000\000\000\v\000\000\000\000\000\000\000^OE+\b", '\000' , "\320i\334 \b\000\000\000\224L\210\000\000\000\000\000\340i\334 \b", '\000' }, salen = 16}} [20:45:59.267] i = 0 [20:45:59.267] now = [20:45:59.267] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 705809538, events = 8, fd = 0, user_data = 0x820dc68e0}, {pos = 902116824, events = 8, fd = 551315312, user_data = 0x0}, {pos = 1266299658, events = 3954, fd = 704976800, user_data = 0x82a062d78}, {pos = 551314408, events = 8, fd = 551314528, user_data = 0x820dc63e8}, {pos = 1266299658, events = 3954, fd = 704955272, user_data = 0x82a062d78}, {pos = 551314456, events = 8, fd = 551314576, user_data = 0x820dc6418}, {pos = 705016212, events = 8, fd = 551769096, user_data = 0x82a05b194}, {pos = 551314560, events = 8, fd = 1266279482, user_data = 0x820dc6420}, {pos = 725918736, events = 8, fd = 706838576, user_data = 0xf724b7a330a}, {pos = 704923736, events = 8, fd = 705047928, user_data = 0x820dc6488}, {pos = 551314688, events = 8, fd = 551314568, user_data = 0x82a059d0c}, {pos = 551769096, events = 8, fd = 705010956, user_data = 0x820dc64f0}, {pos = 1266279482, events = 3954, fd = 551314712, user_data = 0x820dc66e8}, {pos = 551314688, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x820e3b038}, {pos = 1, events = 210698109, fd = 551769096, user_data = 0x82a04c388}, {pos = 551790536, events = 8, fd = 0, user_data = 0x0}, {pos = 551314824, events = 8, fd = 551315288, user_data = 0x820dc6570}, {pos = 1266298018, events = 3954, fd = 2699716, user_data = 0x6d68b}, {pos = 2090263927, events = 210698109, fd = 551792696, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820dc6858}, {pos = 551769096, events = 3, fd = 551315360, user_data = 0x820e3a828}, {pos = 656, events = 0, fd = 551315288, user_data = 0x820dc6588}, {pos = 551314928, events = 8, fd = 1266297627, user_data = 0x820dc6720}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 551792696, events = 8, fd = 1, user_data = 0x820e35408}, {pos = 704923736, events = 8, fd = 551315544, user_data = 0x820dc67a0}, {pos = 551314944, events = 8, fd = 0, user_data = 0x820e2e008}, {pos = 33, events = 0, fd = 551315344, user_data = 0xf724b79cae7}, {pos = 551739400, events = 8, fd = 551740424, user_data = 0x820e2e808}, {pos = 551742472, events = 8, fd = 551755784, user_data = 0x820e32408}, {pos = 551757832, events = 8, fd = 551758856, user_data = 0x820e33008}, {pos = 551760904, events = 8, fd = 551761928, user_data = 0x820e33c08}, {pos = 551763976, events = 8, fd = 551765000, user_data = 0x820e34808}, {pos = 551767048, events = 8, fd = 551768072, user_data = 0x820e35408}, {pos = 551770120, events = 8, fd = 551771144, user_data = 0x820e36008}, {pos = 551773192, events = 8, fd = 551774216, user_data = 0x820e36c08}, {pos = 551776264, events = 8, fd = 551777288, user_data = 0x820e37808}, {pos = 551779336, events = 8, fd = 551784456, user_data = 0x820e39408}, {pos = 551786504, events = 8, fd = 551787528, user_data = 0x820e3c408}, {pos = 425037000, events = 0, fd = 551739400, user_data = 0x2931c4}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x820e3b038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 551315544, events = 8, fd = 551314944, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 551792696, user_data = 0x1}, {pos = 551739400, events = 8, fd = 313, user_data = 0x820dc6840}, {pos = 1266271727, events = 3954, fd = 2699716, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 551792696, user_data = 0x1}, {pos = 551769096, events = 8, fd = 901644288, user_data = 0x1}, {pos = 901644692, events = 8, fd = 0, user_data = 0x820dc6810}, {pos = 725960044, events = 8, fd = 1, user_data = 0x835be0000}, {pos = 551315520, events = 8, fd = 725956354, user_data = 0x82a176170 }, {pos = 12272096, events = 0, fd = 706175344, user_data = 0x820e35408}, {pos = 551315744, events = 8, fd = 1266271198, user_data = 0x835bfe800}, {pos = 1, events = 0, fd = 1266270814, user_data = 0x820e2e008}, {pos = 551315528, events = 8, fd = 551315744, user_data = 0x1c20}, {pos = 901712928, events = 8, fd = 1266350480, user_data = 0x0}, {pos = 551289727, events = 8, fd = 8085367, user_data = 0x820dc68d0}, {pos = 725918736, events = 8, fd = 706838576, user_data = 0x82a21a310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820dc6900}, {pos = 725961629, events = 8, fd = 901644288, user_data = 0x3575}, {pos = 551315808, events = 8, fd = 725928186, user_data = 0x0}, {pos = 0, events = 0, fd = 462591971, user_data = 0x0}} [20:45:59.267] last_touch_time = 1725741732 [20:45:59.267] last_lockfile_recheck_time = 1725741732 [20:45:59.267] nevents = 1 [20:45:59.267] #22 0x00000000008870c5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820dc6f40) at ../src/backend/postmaster/postmaster.c:1346 [20:45:59.267] userDoption = [20:45:59.267] listen_addr_saved = [20:45:59.267] output_config_variable = [20:45:59.267] opt = [20:45:59.267] status = [20:45:59.267] #23 0x00000000007c2c5c in main (argc=4, argv=0x820dc6f40) at ../src/backend/main/main.c:197 [20:45:59.267] do_check_root =