[03:42:33.175] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [03:42:33.508] dumping /tmp/cores/postgres.10713.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:42:33.632] [New LWP 101804] [03:42:33.715] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:42:33.715] Program terminated with signal SIGABRT, Aborted. [03:42:33.715] Sent by thr_kill() from pid 10713 and user 1003. [03:42:33.715] #0 0x000000082a6b341a in thr_kill () from /lib/libc.so.7 [03:42:34.263] [03:42:34.263] Thread 1 (LWP 101804): [03:42:34.263] #0 0x000000082a6b341a in thr_kill () from /lib/libc.so.7 [03:42:34.263] No symbol table info available. [03:42:34.263] #1 0x000000082a62ce64 in raise () from /lib/libc.so.7 [03:42:34.263] No symbol table info available. [03:42:34.263] #2 0x000000082a6dd6f9 in abort () from /lib/libc.so.7 [03:42:34.263] No symbol table info available. [03:42:34.263] #3 0x0000000000a91255 in ExceptionalCondition (conditionName=0x2e76b0 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=206) at ../src/backend/utils/error/assert.c:66 [03:42:34.263] No locals. [03:42:34.263] #4 0x0000000000764d99 in standard_ExecutorStart (queryDesc=0x84202f088, eflags=0) at ../src/backend/executor/execMain.c:206 [03:42:34.263] estate = 0x8341a1100 [03:42:34.263] oldcontext = 0x8341e4800 [03:42:34.263] #5 0x00000000006fb595 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:42:34.263] copied_query = [03:42:34.263] rewritten = [03:42:34.263] plan = 0x8341d9bd8 [03:42:34.263] queryDesc = 0x84202f088 [03:42:34.263] processed = [03:42:34.263] __error = [03:42:34.263] #6 RefreshMatViewByOid (matviewOid=27348, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:42:34.263] dest = [03:42:34.263] save_userid = 10 [03:42:34.263] save_sec_context = 0 [03:42:34.263] processed = 0 [03:42:34.263] matviewRel = 0x841f49528 [03:42:34.263] relowner = 10 [03:42:34.263] save_nestlevel = 2 [03:42:34.263] rule = [03:42:34.263] actions = [03:42:34.263] dataQuery = [03:42:34.263] tableSpace = [03:42:34.263] relpersistence = [03:42:34.263] OIDNewHeap = 27355 [03:42:34.263] address = [03:42:34.263] #7 0x00000000006fb176 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:42:34.263] lockmode = [03:42:34.263] matviewOid = 0 [03:42:34.263] #8 0x00000000006d273c in ExecCreateTableAs (pstate=pstate@entry=0x8341e4900, stmt=stmt@entry=0x83414ffd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8213030e0) at ../src/backend/commands/createas.c:350 [03:42:34.263] refresh = 0x0 [03:42:34.263] query = 0x842066b18 [03:42:34.263] into = 0x842066e60 [03:42:34.263] do_refresh = false [03:42:34.263] address = [03:42:34.263] dest = [03:42:34.263] is_matview = [03:42:34.263] #9 0x000000000093dad8 in ProcessUtilitySlow (pstate=pstate@entry=0x8341e4900, pstmt=pstmt@entry=0x834049a68, queryString=queryString@entry=0x834048100 "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=0x8213030e0) at ../src/backend/tcop/utility.c:1675 [03:42:34.263] _local_sigjmp_buf = {{_sjb = {9687817, 0, 34916543752, 34916544128, 34916543760, 12377048, 0, 35234138368, 4294902655, 34916543868, 34916543904, 0}}} [03:42:34.263] _save_exception_stack = 0x821302fe0 [03:42:34.263] _save_context_stack = 0x0 [03:42:34.263] _do_rethrow = false [03:42:34.263] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:42:34.263] parsetree = 0x83414ffd0 [03:42:34.263] commandCollected = false [03:42:34.263] needCleanup = false [03:42:34.263] address = [03:42:34.263] isTopLevel = [03:42:34.263] isCompleteQuery = [03:42:34.263] #10 0x000000000093c458 in standard_ProcessUtility (pstmt=0x834049a68, queryString=0x834048100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x842067348, qc=0x8213030e0) at ../src/backend/tcop/utility.c:1030 [03:42:34.263] isAtomicContext = false [03:42:34.263] parsetree = 0x83414ffd0 [03:42:34.263] readonly_flags = [03:42:34.263] pstate = 0x8341e4900 [03:42:34.263] isTopLevel = [03:42:34.263] #11 0x000000000093bee8 in ProcessUtility (pstmt=0x18dac, queryString=0x6 , readOnlyTree=, context=711668730, params=0x0, queryEnv=0x0, dest=0x842067348, qc=0x8213030e0) at ../src/backend/tcop/utility.c:523 [03:42:34.263] No locals. [03:42:34.263] #12 0x000000000093ba23 in PortalRunUtility (portal=0x83411f100, pstmt=0x834049a68, isTopLevel=, setHoldSnapshot=, dest=0x842067348, qc=0x8213030e0) at ../src/backend/tcop/pquery.c:1158 [03:42:34.263] No locals. [03:42:34.263] #13 0x000000000093b0b4 in PortalRunMulti (portal=portal@entry=0x83411f100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x842067348, altdest=altdest@entry=0x842067348, qc=0x8213030e0) at ../src/backend/tcop/pquery.c:1323 [03:42:34.263] pstmt = 0x834049a68 [03:42:34.263] stmtlist_item__state = {l = 0x8420672f8, i = 0} [03:42:34.263] active_snapshot_set = false [03:42:34.263] stmtlist_item = 0x842067310 [03:42:34.263] #14 0x000000000093a983 in PortalRun (portal=portal@entry=0x83411f100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x842067348, altdest=altdest@entry=0x842067348, qc=0x8213030e0) at ../src/backend/tcop/pquery.c:791 [03:42:34.263] _local_sigjmp_buf = {{_sjb = {9677053, 35233329408, 34916544472, 34916544704, 34916544480, 35233345536, 12343704, 12377048, 35233334143, 35233523088, 4294967984, 0}}} [03:42:34.263] _save_exception_stack = 0x8213031b0 [03:42:34.263] _save_context_stack = 0x0 [03:42:34.263] _do_rethrow = false [03:42:34.263] saveTopTransactionResourceOwner = 0x834130318 [03:42:34.263] saveTopTransactionContext = 0x834123000 [03:42:34.263] saveActivePortal = 0x0 [03:42:34.263] saveResourceOwner = 0x834130318 [03:42:34.263] savePortalContext = 0x0 [03:42:34.263] saveMemoryContext = 0x834123000 [03:42:34.263] result = [03:42:34.263] nprocessed = [03:42:34.263] #15 0x0000000000939822 in exec_simple_query (query_string=query_string@entry=0x834048100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:42:34.263] cmdtaglen = 24 [03:42:34.263] snapshot_set = [03:42:34.263] per_parsetree_context = 0x0 [03:42:34.263] plantree_list = [03:42:34.263] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:42:34.263] format = 0 [03:42:34.263] parsetree = 0x8340496a8 [03:42:34.263] commandTag = [03:42:34.263] cmdtagname = [03:42:34.263] querytree_list = [03:42:34.263] portal = 0x83411f100 [03:42:34.263] receiver = 0x842067348 [03:42:34.263] parsetree_item__state = {l = 0x834049a18, i = 0} [03:42:34.263] msec_str = "\000\000\000\000\b", '\000' , "\262n\373f\000\000\000\000ać\335=I\221\235" [03:42:34.263] dest = DestRemote [03:42:34.263] was_logged = [03:42:34.263] oldcontext = 0x834123000 [03:42:34.263] parsetree_list = 0x834049a18 [03:42:34.263] use_implicit_block = false [03:42:34.263] parsetree_item = 0x834049a30 [03:42:34.263] save_log_statement_stats = [03:42:34.263] #16 0x0000000000937493 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [03:42:34.263] query_string = 0x834048100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:42:34.263] input_message = {data = 0x834048100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:42:34.263] firstchar = [03:42:34.263] local_sigjmp_buf = {{_sjb = {9660742, 34916544944, 34916544904, 34916545488, 12385784, 1, 8192, 8388608, 34916533119, 0, 0, 1}}} [03:42:34.263] send_ready_for_query = false [03:42:34.263] idle_in_transaction_timeout_enabled = false [03:42:34.263] idle_session_timeout_enabled = false [03:42:34.263] #17 0x0000000000931c79 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:42:34.263] bsdata = [03:42:34.263] #18 0x000000000088b807 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821303ef4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821303e30) at ../src/backend/postmaster/launch_backend.c:274 [03:42:34.263] pid = [03:42:34.263] #19 0x000000000088fbd8 in BackendStartup (client_sock=0x821303e30) at ../src/backend/postmaster/postmaster.c:3420 [03:42:34.263] startup_data = {canAcceptConnections = CAC_OK} [03:42:34.263] bn = 0x8340545d8 [03:42:34.263] pid = [03:42:34.263] __error = [03:42:34.263] save_errno = [03:42:34.263] __error = [03:42:34.263] __error = [03:42:34.263] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [03:42:34.263] 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\237\0044\b", '\000' , "\220>0!\b\000\000\000h\245\021)\b\000\000\000\v\000\000\000\000\000\000\000^/\022)\b", '\000' , "\320>0!\b\000\000\000\264\265\210\000\000\000\000\000\340>0!\b", '\000' }, salen = 16}} [03:42:34.263] i = 0 [03:42:34.263] now = [03:42:34.263] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 711294082, events = 8, fd = 0, user_data = 0x821303de0}, {pos = 873088472, events = 8, fd = 556809328, user_data = 0x0}, {pos = 0, events = 0, fd = -1644536836, user_data = 0x1588663a230a}, {pos = 710461344, events = 8, fd = 710532472, user_data = 0x8213038f8}, {pos = 556808560, events = 8, fd = 556808440, user_data = 0x1588663a230a}, {pos = 710439816, events = 8, fd = 710532472, user_data = 0x821303928}, {pos = 556808608, events = 8, fd = 556808488, user_data = 0x82a596194}, {pos = 567075848, events = 8, fd = 710500756, user_data = 0x821303990}, {pos = 1715065914, events = 5512, fd = 712323120, user_data = 0x1}, {pos = 556808640, events = 8, fd = 1715086090, user_data = 0x82a57f858}, {pos = 710532472, events = 8, fd = 556808600, user_data = 0x821303a10}, {pos = 556808600, events = 8, fd = 710495500, user_data = 0x821cce408}, {pos = 710495500, events = 8, fd = 556808704, user_data = 0x15886639d43a}, {pos = 556808744, events = 8, fd = 556809192, user_data = 0x821303a10}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2319448355, fd = 567099448, user_data = 0x800000001}, {pos = 567075848, events = 8, fd = 710439816, user_data = 0x821cd3288}, {pos = 710408280, events = 8, fd = 567075848, user_data = 0x821303a98}, {pos = 556809304, events = 8, fd = 556808832, user_data = 0x1588663a1ca2}, {pos = 2701916, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 567099448, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 556809560, user_data = 0x21cce408}, {pos = 556809376, events = 8, fd = 556808976, user_data = 0x1}, {pos = 556809304, events = 8, fd = 32, user_data = 0x821303b00}, {pos = 1715083891, events = 5512, fd = 556809248, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821cd4038}, {pos = 1, events = 8, fd = 567075848, user_data = 0x82a57f858}, {pos = 556809560, events = 8, fd = 556809376, user_data = 0x821303b10}, {pos = 0, events = 0, fd = 567046152, user_data = 0x20}, {pos = 556809360, events = 8, fd = 1715059431, user_data = 0x821cc7008}, {pos = 567047176, events = 8, fd = 567048200, user_data = 0x821cc7c08}, {pos = 567062536, events = 8, fd = 567063560, user_data = 0x821ccb808}, {pos = 567065608, events = 8, fd = 567066632, user_data = 0x821ccc408}, {pos = 567068680, events = 8, fd = 567069704, user_data = 0x821ccd008}, {pos = 567071752, events = 8, fd = 567072776, user_data = 0x821ccdc08}, {pos = 567074824, events = 8, fd = 567075848, user_data = 0x821cce808}, {pos = 567077896, events = 8, fd = 567078920, user_data = 0x821ccf408}, {pos = 567080968, events = 8, fd = 567081992, user_data = 0x821cd0008}, {pos = 567084040, events = 8, fd = 567085064, user_data = 0x821cd0c08}, {pos = 567091208, events = 8, fd = 567092232, user_data = 0x821cd2808}, {pos = 567094280, events = 8, fd = 567046152, user_data = 0x293a5c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821cd4038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556809560, events = 8, fd = 556808976, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 567099448, user_data = 0x1}, {pos = 567046152, events = 8, fd = 313, user_data = 0x821303d40}, {pos = 1715058159, events = 5512, fd = 2701916, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 567099448, user_data = 0x1}, {pos = 567075848, events = 8, fd = 872644608, user_data = 0x1}, {pos = 872645012, events = 8, fd = 0, user_data = 0x821303d10}, {pos = 689055084, events = 8, fd = 1, user_data = 0x834038000}, {pos = 556809536, events = 8, fd = 689051394, user_data = 0x82a6b1170 }, {pos = 12306704, events = 0, fd = 711659888, user_data = 0x821cce408}, {pos = 556809760, events = 8, fd = 1715057630, user_data = 0x834056800}, {pos = 1, events = 0, fd = 1715057246, user_data = 0x821cc7008}, {pos = 556809544, events = 8, fd = 556809760, user_data = 0x1c20}, {pos = 872718080, events = 8, fd = 1715136912, user_data = 0x0}, {pos = 556794751, events = 8, fd = 8107511, user_data = 0x821303dd0}, {pos = 689013776, events = 8, fd = 712323120, user_data = 0x82a755310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821303e00}, {pos = 689056669, events = 8, fd = 872644608, user_data = 0x1dc8}, {pos = 556809824, events = 8, fd = 689023226, user_data = 0x0}, {pos = 0, events = 0, fd = -1644536836, user_data = 0x0}} [03:42:34.264] last_touch_time = 1727753886 [03:42:34.264] last_lockfile_recheck_time = 1727753886 [03:42:34.264] nevents = 1 [03:42:34.264] #21 0x000000000088d9f5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821304448) at ../src/backend/postmaster/postmaster.c:1351 [03:42:34.264] userDoption = [03:42:34.264] listen_addr_saved = [03:42:34.264] output_config_variable = [03:42:34.264] opt = [03:42:34.264] status = [03:42:34.264] #22 0x00000000007c82dc in main (argc=8, argv=0x821304448) at ../src/backend/main/main.c:197 [03:42:34.264] do_check_root = [03:42:34.275] [03:42:34.275] [03:42:34.275] [03:42:34.334] dumping /tmp/cores/postgres.11233.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:42:34.453] [New LWP 101831] [03:42:34.519] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:42:34.519] Program terminated with signal SIGABRT, Aborted. [03:42:34.519] Sent by thr_kill() from pid 11233 and user 1003. [03:42:34.519] #0 0x000000082a13e41a in thr_kill () from /lib/libc.so.7 [03:42:35.048] [03:42:35.048] Thread 1 (LWP 101831): [03:42:35.048] #0 0x000000082a13e41a in thr_kill () from /lib/libc.so.7 [03:42:35.048] No symbol table info available. [03:42:35.048] #1 0x000000082a0b7e64 in raise () from /lib/libc.so.7 [03:42:35.048] No symbol table info available. [03:42:35.048] #2 0x000000082a1686f9 in abort () from /lib/libc.so.7 [03:42:35.048] No symbol table info available. [03:42:35.048] #3 0x0000000000a91255 in ExceptionalCondition (conditionName=0x2e76b0 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=206) at ../src/backend/utils/error/assert.c:66 [03:42:35.048] No locals. [03:42:35.048] #4 0x0000000000764d99 in standard_ExecutorStart (queryDesc=0x8339f1088, eflags=0) at ../src/backend/executor/execMain.c:206 [03:42:35.048] estate = 0x83f7fe100 [03:42:35.048] oldcontext = 0x833b1d800 [03:42:35.048] #5 0x00000000006fb595 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:42:35.048] copied_query = [03:42:35.048] rewritten = [03:42:35.048] plan = 0x833b16bd8 [03:42:35.048] queryDesc = 0x8339f1088 [03:42:35.048] processed = [03:42:35.048] __error = [03:42:35.048] #6 RefreshMatViewByOid (matviewOid=27411, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:42:35.048] dest = [03:42:35.048] save_userid = 10 [03:42:35.048] save_sec_context = 0 [03:42:35.048] processed = 0 [03:42:35.048] matviewRel = 0x83f7af930 [03:42:35.048] relowner = 10 [03:42:35.048] save_nestlevel = 2 [03:42:35.048] rule = [03:42:35.048] actions = [03:42:35.048] dataQuery = [03:42:35.048] tableSpace = [03:42:35.048] relpersistence = [03:42:35.048] OIDNewHeap = 27426 [03:42:35.048] address = [03:42:35.048] #7 0x00000000006fb176 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:42:35.048] lockmode = [03:42:35.048] matviewOid = 0 [03:42:35.048] #8 0x00000000006d273c in ExecCreateTableAs (pstate=pstate@entry=0x833b1d900, stmt=stmt@entry=0x833a59fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821953110) at ../src/backend/commands/createas.c:350 [03:42:35.048] refresh = 0x0 [03:42:35.048] query = 0x833a61c98 [03:42:35.048] into = 0x833a61fe0 [03:42:35.048] do_refresh = false [03:42:35.048] address = [03:42:35.048] dest = [03:42:35.048] is_matview = [03:42:35.048] #9 0x000000000093dad8 in ProcessUtilitySlow (pstate=pstate@entry=0x833b1d900, pstmt=pstmt@entry=0x83397aa68, queryString=queryString@entry=0x833979100 "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=0x821953110) at ../src/backend/tcop/utility.c:1675 [03:42:35.048] _local_sigjmp_buf = {{_sjb = {9687817, 0, 34923162936, 34923163312, 34923162944, 12377048, 0, 35227031808, 4294902655, 34923163052, 34923163088, 0}}} [03:42:35.048] _save_exception_stack = 0x821953010 [03:42:35.048] _save_context_stack = 0x0 [03:42:35.048] _do_rethrow = false [03:42:35.048] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:42:35.048] parsetree = 0x833a59fd0 [03:42:35.048] commandCollected = false [03:42:35.048] needCleanup = false [03:42:35.048] address = [03:42:35.048] isTopLevel = [03:42:35.048] isCompleteQuery = [03:42:35.048] #10 0x000000000093c458 in standard_ProcessUtility (pstmt=0x83397aa68, queryString=0x833979100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x833a624c8, qc=0x821953110) at ../src/backend/tcop/utility.c:1030 [03:42:35.048] isAtomicContext = false [03:42:35.048] parsetree = 0x833a59fd0 [03:42:35.048] readonly_flags = [03:42:35.048] pstate = 0x833b1d900 [03:42:35.048] isTopLevel = [03:42:35.048] #11 0x000000000093bee8 in ProcessUtility (pstmt=0x18dc7, queryString=0x6 , readOnlyTree=, context=705946618, params=0x0, queryEnv=0x0, dest=0x833a624c8, qc=0x821953110) at ../src/backend/tcop/utility.c:523 [03:42:35.048] No locals. [03:42:35.048] #12 0x000000000093ba23 in PortalRunUtility (portal=0x833a1f100, pstmt=0x83397aa68, isTopLevel=, setHoldSnapshot=, dest=0x833a624c8, qc=0x821953110) at ../src/backend/tcop/pquery.c:1158 [03:42:35.048] No locals. [03:42:35.048] #13 0x000000000093b0b4 in PortalRunMulti (portal=portal@entry=0x833a1f100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x833a624c8, altdest=altdest@entry=0x833a624c8, qc=0x821953110) at ../src/backend/tcop/pquery.c:1323 [03:42:35.048] pstmt = 0x83397aa68 [03:42:35.048] stmtlist_item__state = {l = 0x833a62478, i = 0} [03:42:35.048] active_snapshot_set = false [03:42:35.048] stmtlist_item = 0x833a62490 [03:42:35.048] #14 0x000000000093a983 in PortalRun (portal=portal@entry=0x833a1f100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x833a624c8, altdest=altdest@entry=0x833a624c8, qc=0x821953110) at ../src/backend/tcop/pquery.c:791 [03:42:35.048] _local_sigjmp_buf = {{_sjb = {9677053, 35225989376, 34923163656, 34923163888, 34923163664, 35226005504, 12343704, 12377048, 35225994111, 35226224016, 4294967984, 0}}} [03:42:35.048] _save_exception_stack = 0x8219531e0 [03:42:35.048] _save_context_stack = 0x0 [03:42:35.048] _do_rethrow = false [03:42:35.048] saveTopTransactionResourceOwner = 0x833a6ef18 [03:42:35.048] saveTopTransactionContext = 0x833a23000 [03:42:35.048] saveActivePortal = 0x0 [03:42:35.048] saveResourceOwner = 0x833a6ef18 [03:42:35.048] savePortalContext = 0x0 [03:42:35.048] saveMemoryContext = 0x833a23000 [03:42:35.048] result = [03:42:35.048] nprocessed = [03:42:35.048] #15 0x0000000000939822 in exec_simple_query (query_string=query_string@entry=0x833979100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:42:35.048] cmdtaglen = 24 [03:42:35.048] snapshot_set = [03:42:35.048] per_parsetree_context = 0x0 [03:42:35.048] plantree_list = [03:42:35.048] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:42:35.048] format = 0 [03:42:35.048] parsetree = 0x83397a6a8 [03:42:35.048] commandTag = [03:42:35.048] cmdtagname = [03:42:35.048] querytree_list = [03:42:35.048] portal = 0x833a1f100 [03:42:35.048] receiver = 0x833a624c8 [03:42:35.048] parsetree_item__state = {l = 0x83397aa18, i = 0} [03:42:35.048] msec_str = "\000\000\000\000\b", '\000' , "\265n\373f\000\000\000\000!t\274f\302\235;\235" [03:42:35.048] dest = DestRemote [03:42:35.048] was_logged = [03:42:35.048] oldcontext = 0x833a23000 [03:42:35.048] parsetree_list = 0x83397aa18 [03:42:35.048] use_implicit_block = false [03:42:35.048] parsetree_item = 0x83397aa30 [03:42:35.048] save_log_statement_stats = [03:42:35.048] #16 0x0000000000937493 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [03:42:35.048] query_string = 0x833979100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:42:35.048] input_message = {data = 0x833979100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:42:35.048] firstchar = [03:42:35.048] local_sigjmp_buf = {{_sjb = {9660742, 34923164128, 34923164088, 34923164672, 12385784, 1, 8192, 8388608, 34923152255, 0, 0, 1}}} [03:42:35.048] send_ready_for_query = false [03:42:35.048] idle_in_transaction_timeout_enabled = false [03:42:35.048] idle_session_timeout_enabled = false [03:42:35.048] #17 0x0000000000931c79 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:42:35.048] bsdata = [03:42:35.048] #18 0x000000000088b807 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821953f24 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821953e60) at ../src/backend/postmaster/launch_backend.c:274 [03:42:35.048] pid = [03:42:35.048] #19 0x000000000088fbd8 in BackendStartup (client_sock=0x821953e60) at ../src/backend/postmaster/postmaster.c:3420 [03:42:35.048] startup_data = {canAcceptConnections = CAC_OK} [03:42:35.048] bn = 0x833985268 [03:42:35.048] pid = [03:42:35.048] __error = [03:42:35.048] save_errno = [03:42:35.048] __error = [03:42:35.048] __error = [03:42:35.048] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [03:42:35.048] 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\256\2273\b", '\000' , "\300>\225!\b\000\000\000h\345\354(\b\000\000\000\v\000\000\000\000\000\000\000^o\355(\b", '\000' , "?\225!\b\000\000\000\264\265\210\000\000\000\000\000\020?\225!\b", '\000' }, salen = 16}} [03:42:35.048] i = 0 [03:42:35.048] now = [03:42:35.048] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 705571970, events = 8, fd = 0, user_data = 0x821953e10}, {pos = 866006488, events = 8, fd = 563428512, user_data = 0x0}, {pos = 0, events = 0, fd = 1819568433, user_data = 0x18c12fd4430a}, {pos = 704739232, events = 8, fd = 704810360, user_data = 0x821953928}, {pos = 563427744, events = 8, fd = 563427624, user_data = 0x18c12fd4430a}, {pos = 704717704, events = 8, fd = 704810360, user_data = 0x821953958}, {pos = 563427792, events = 8, fd = 563427672, user_data = 0x82a021194}, {pos = 579535880, events = 8, fd = 704778644, user_data = 0x8219539c0}, {pos = 802419770, events = 6337, fd = 706601008, user_data = 0x1}, {pos = 563427824, events = 8, fd = 802439946, user_data = 0x82a00a858}, {pos = 704810360, events = 8, fd = 563427784, user_data = 0x821953a40}, {pos = 563427784, events = 8, fd = 704773388, user_data = 0x8228b0408}, {pos = 704773388, events = 8, fd = 563427888, user_data = 0x18c12fd3f43a}, {pos = 563427928, events = 8, fd = 563428376, user_data = 0x821953a40}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1215500446, fd = 579559480, user_data = 0x800000001}, {pos = 579535880, events = 8, fd = 704717704, user_data = 0x8228b5288}, {pos = 704686168, events = 8, fd = 579535880, user_data = 0x821953ac8}, {pos = 563428488, events = 8, fd = 563428016, user_data = 0x18c12fd43ca2}, {pos = 2701916, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 579559480, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 563428744, user_data = 0x228b0408}, {pos = 563428560, events = 8, fd = 563428160, user_data = 0x1}, {pos = 563428488, events = 8, fd = 32, user_data = 0x821953b30}, {pos = 802437747, events = 6337, fd = 563428432, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8228b6038}, {pos = 1, events = 8, fd = 579535880, user_data = 0x82a00a858}, {pos = 563428744, events = 8, fd = 563428560, user_data = 0x821953b40}, {pos = 0, events = 0, fd = 579506184, user_data = 0x20}, {pos = 563428544, events = 8, fd = 802413287, user_data = 0x8228a9008}, {pos = 579507208, events = 8, fd = 579508232, user_data = 0x8228a9c08}, {pos = 579522568, events = 8, fd = 579523592, user_data = 0x8228ad808}, {pos = 579525640, events = 8, fd = 579526664, user_data = 0x8228ae408}, {pos = 579528712, events = 8, fd = 579529736, user_data = 0x8228af008}, {pos = 579531784, events = 8, fd = 579532808, user_data = 0x8228afc08}, {pos = 579534856, events = 8, fd = 579535880, user_data = 0x8228b0808}, {pos = 579537928, events = 8, fd = 579538952, user_data = 0x8228b1408}, {pos = 579541000, events = 8, fd = 579542024, user_data = 0x8228b2008}, {pos = 579544072, events = 8, fd = 579545096, user_data = 0x8228b2c08}, {pos = 579551240, events = 8, fd = 579552264, user_data = 0x8228b4808}, {pos = 579554312, events = 8, fd = 579506184, user_data = 0x293a5c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8228b6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 563428744, events = 8, fd = 563428160, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 579559480, user_data = 0x1}, {pos = 579506184, events = 8, fd = 313, user_data = 0x821953d70}, {pos = 802412015, events = 6337, fd = 2701916, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 579559480, user_data = 0x1}, {pos = 579535880, events = 8, fd = 865505280, user_data = 0x1}, {pos = 865505684, events = 8, fd = 0, user_data = 0x821953d40}, {pos = 686646636, events = 8, fd = 1, user_data = 0x833969000}, {pos = 563428720, events = 8, fd = 686642946, user_data = 0x82a13c170 }, {pos = 12306704, events = 0, fd = 705937776, user_data = 0x8228b0408}, {pos = 563428944, events = 8, fd = 802411486, user_data = 0x833987800}, {pos = 1, events = 0, fd = 802411102, user_data = 0x8228a9008}, {pos = 563428728, events = 8, fd = 563428944, user_data = 0x1c20}, {pos = 865578688, events = 8, fd = 802490768, user_data = 0x0}, {pos = 563413887, events = 8, fd = 8107511, user_data = 0x821953e00}, {pos = 686605328, events = 8, fd = 706601008, user_data = 0x82a1e0310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821953e30}, {pos = 686648221, events = 8, fd = 865505280, user_data = 0x1dfd}, {pos = 563429008, events = 8, fd = 686614778, user_data = 0x0}, {pos = 0, events = 0, fd = 1819568433, user_data = 0x0}} [03:42:35.048] last_touch_time = 1727753886 [03:42:35.048] last_lockfile_recheck_time = 1727753886 [03:42:35.048] nevents = 1 [03:42:35.048] #21 0x000000000088d9f5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821954478) at ../src/backend/postmaster/postmaster.c:1351 [03:42:35.048] userDoption = [03:42:35.048] listen_addr_saved = [03:42:35.048] output_config_variable = [03:42:35.048] opt = [03:42:35.048] status = [03:42:35.048] #22 0x00000000007c82dc in main (argc=4, argv=0x821954478) at ../src/backend/main/main.c:197 [03:42:35.048] do_check_root = [03:42:35.061] [03:42:35.061] [03:42:35.061] [03:42:35.122] dumping /tmp/cores/postgres.17412.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:42:35.238] [New LWP 100101] [03:42:35.299] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:42:35.299] Program terminated with signal SIGABRT, Aborted. [03:42:35.299] Sent by thr_kill() from pid 17412 and user 1003. [03:42:35.299] #0 0x00000008298d041a in thr_kill () from /lib/libc.so.7 [03:42:35.831] [03:42:35.831] Thread 1 (LWP 100101): [03:42:35.831] #0 0x00000008298d041a in thr_kill () from /lib/libc.so.7 [03:42:35.831] No symbol table info available. [03:42:35.831] #1 0x0000000829849e64 in raise () from /lib/libc.so.7 [03:42:35.831] No symbol table info available. [03:42:35.831] #2 0x00000008298fa6f9 in abort () from /lib/libc.so.7 [03:42:35.831] No symbol table info available. [03:42:35.831] #3 0x0000000000a91255 in ExceptionalCondition (conditionName=0x2e76b0 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=206) at ../src/backend/utils/error/assert.c:66 [03:42:35.831] No locals. [03:42:35.831] #4 0x0000000000764d99 in standard_ExecutorStart (queryDesc=0x835d06088, eflags=0) at ../src/backend/executor/execMain.c:206 [03:42:35.831] estate = 0x835d4d100 [03:42:35.831] oldcontext = 0x835cfc800 [03:42:35.831] #5 0x0000000838a86862 in pgss_ExecutorStart (queryDesc=0x835d06088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [03:42:35.831] No locals. [03:42:35.831] #6 0x00000000006fb595 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:42:35.831] copied_query = [03:42:35.831] rewritten = [03:42:35.831] plan = 0x835c57bd8 [03:42:35.831] queryDesc = 0x835d06088 [03:42:35.831] processed = [03:42:35.831] __error = [03:42:35.831] #7 RefreshMatViewByOid (matviewOid=27473, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:42:35.831] dest = [03:42:35.831] save_userid = 10 [03:42:35.831] save_sec_context = 0 [03:42:35.831] processed = 0 [03:42:35.831] matviewRel = 0x83c342558 [03:42:35.831] relowner = 10 [03:42:35.831] save_nestlevel = 2 [03:42:35.831] rule = [03:42:35.831] actions = [03:42:35.831] dataQuery = [03:42:35.831] tableSpace = [03:42:35.831] relpersistence = [03:42:35.831] OIDNewHeap = 27493 [03:42:35.831] address = [03:42:35.831] #8 0x00000000006fb176 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:42:35.831] lockmode = [03:42:35.831] matviewOid = 0 [03:42:35.831] #9 0x00000000006d273c in ExecCreateTableAs (pstate=pstate@entry=0x835cfc900, stmt=stmt@entry=0x835c14fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8215cb480) at ../src/backend/commands/createas.c:350 [03:42:35.831] refresh = 0x0 [03:42:35.831] query = 0x83c395a08 [03:42:35.831] into = 0x835c14f40 [03:42:35.831] do_refresh = false [03:42:35.831] address = [03:42:35.831] dest = [03:42:35.831] is_matview = [03:42:35.831] #10 0x000000000093dad8 in ProcessUtilitySlow (pstate=pstate@entry=0x835cfc900, pstmt=pstmt@entry=0x835c14e30, queryString=queryString@entry=0x835b77100 "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=0x8215cb480) at ../src/backend/tcop/utility.c:1675 [03:42:35.831] _local_sigjmp_buf = {{_sjb = {9687817, 0, 34919460584, 34919460960, 34919460592, 12377048, 0, 35262548224, 34919416703, 7, 34919460736, 0}}} [03:42:35.831] _save_exception_stack = 0x8215cb170 [03:42:35.831] _save_context_stack = 0x0 [03:42:35.831] _do_rethrow = false [03:42:35.831] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:42:35.831] parsetree = 0x835c14fd0 [03:42:35.831] commandCollected = false [03:42:35.831] needCleanup = false [03:42:35.831] address = [03:42:35.831] isTopLevel = [03:42:35.831] isCompleteQuery = [03:42:35.831] #11 0x000000000093c458 in standard_ProcessUtility (pstmt=0x835c14e30, queryString=queryString@entry=0x835b77100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83c3961a8, qc=0x8215cb480) at ../src/backend/tcop/utility.c:1030 [03:42:35.831] isAtomicContext = false [03:42:35.831] parsetree = 0x835c14fd0 [03:42:35.831] readonly_flags = [03:42:35.831] pstate = 0x835cfc900 [03:42:35.831] isTopLevel = [03:42:35.831] #12 0x0000000838a86dee in pgss_ProcessUtility (pstmt=0x835c14e30, queryString=0x835b77100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83c3961a8, qc=0x8215cb480) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [03:42:35.831] _local_sigjmp_buf = {{_sjb = {35310300455, 34919461232, 34919461096, 34919461552, 35261599280, 0, 12377048, 34919461760, 34919416703, 34919461332, 34919461360, 0}}} [03:42:35.831] _save_exception_stack = 0x8215cb380 [03:42:35.831] _save_context_stack = 0x0 [03:42:35.831] _do_rethrow = false [03:42:35.831] bufusage = {shared_blks_hit = 35310300455, shared_blks_read = 34919461232, shared_blks_dirtied = 34919461096, shared_blks_written = 34919461552, local_blks_hit = 35261599280, local_blks_read = 0, local_blks_dirtied = 12377048, local_blks_written = 34919461760, temp_blks_read = 34919416703, temp_blks_written = 34919461332, shared_blk_read_time = {ticks = 34919461360}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4123147718698166528}, local_blk_write_time = {ticks = 12386088}, temp_blk_read_time = {ticks = 35323918592}, temp_blk_write_time = {ticks = 12339648}} [03:42:35.831] walusage_start = {wal_records = 8944, wal_fpi = 124, wal_bytes = 1245712} [03:42:35.831] duration = [03:42:35.831] bufusage_start = {shared_blks_hit = 151905, shared_blks_read = 8458, shared_blks_dirtied = 2694, shared_blks_written = 2243, 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}} [03:42:35.831] walusage = {wal_records = 2992147641721383399, wal_fpi = 35261599696, wal_bytes = 123} [03:42:35.831] start = {ticks = -184224198191} [03:42:35.831] rows = [03:42:35.831] saved_queryId = 6041762721901209185 [03:42:35.831] parsetree = [03:42:35.831] saved_stmt_location = 0 [03:42:35.831] saved_stmt_len = 69 [03:42:35.831] enabled = [03:42:35.831] #13 0x000000000093ba23 in PortalRunUtility (portal=0x835c1f100, pstmt=0x835c14e30, isTopLevel=, setHoldSnapshot=, dest=0x83c3961a8, qc=0x8215cb480) at ../src/backend/tcop/pquery.c:1158 [03:42:35.831] No locals. [03:42:35.831] #14 0x000000000093b0b4 in PortalRunMulti (portal=portal@entry=0x835c1f100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83c3961a8, altdest=altdest@entry=0x83c3961a8, qc=0x8215cb480) at ../src/backend/tcop/pquery.c:1323 [03:42:35.831] pstmt = 0x835c14e30 [03:42:35.831] stmtlist_item__state = {l = 0x83c396158, i = 0} [03:42:35.831] active_snapshot_set = false [03:42:35.831] stmtlist_item = 0x83c396170 [03:42:35.831] #15 0x000000000093a983 in PortalRun (portal=portal@entry=0x835c1f100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83c3961a8, altdest=altdest@entry=0x83c3961a8, qc=0x8215cb480) at ../src/backend/tcop/pquery.c:791 [03:42:35.831] _local_sigjmp_buf = {{_sjb = {9677053, 35261640960, 34919461752, 34919461984, 34919461760, 35261734912, 12343704, 12377048, 35261645695, 35261593056, 4294967984, 0}}} [03:42:35.831] _save_exception_stack = 0x8215cb550 [03:42:35.831] _save_context_stack = 0x0 [03:42:35.831] _do_rethrow = false [03:42:35.831] saveTopTransactionResourceOwner = 0x835c6da98 [03:42:35.831] saveTopTransactionContext = 0x835c36000 [03:42:35.831] saveActivePortal = 0x0 [03:42:35.831] saveResourceOwner = 0x835c6da98 [03:42:35.831] savePortalContext = 0x0 [03:42:35.831] saveMemoryContext = 0x835c36000 [03:42:35.831] result = [03:42:35.831] nprocessed = [03:42:35.831] #16 0x0000000000939822 in exec_simple_query (query_string=query_string@entry=0x835b77100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:42:35.831] cmdtaglen = 24 [03:42:35.831] snapshot_set = [03:42:35.831] per_parsetree_context = 0x0 [03:42:35.831] plantree_list = [03:42:35.831] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:42:35.831] format = 0 [03:42:35.831] parsetree = 0x835b786a8 [03:42:35.831] commandTag = [03:42:35.831] cmdtagname = [03:42:35.831] querytree_list = [03:42:35.831] portal = 0x835c1f100 [03:42:35.831] receiver = 0x83c3961a8 [03:42:35.831] parsetree_item__state = {l = 0x835b78a18, i = 0} [03:42:35.831] msec_str = "\000\000\000\000\b", '\000' , "\330n\373f\000\000\000\000ɱ\022\312Y", [03:42:35.831] dest = DestRemote [03:42:35.831] was_logged = [03:42:35.831] oldcontext = 0x835c36000 [03:42:35.831] parsetree_list = 0x835b78a18 [03:42:35.831] use_implicit_block = false [03:42:35.831] parsetree_item = 0x835b78a30 [03:42:35.831] save_log_statement_stats = [03:42:35.831] #17 0x0000000000937493 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [03:42:35.831] query_string = 0x835b77100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:42:35.831] input_message = {data = 0x835b77100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:42:35.831] firstchar = [03:42:35.831] local_sigjmp_buf = {{_sjb = {9660742, 34919462224, 34919462184, 34919462768, 12385784, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [03:42:35.831] send_ready_for_query = false [03:42:35.831] idle_in_transaction_timeout_enabled = false [03:42:35.831] idle_session_timeout_enabled = false [03:42:35.831] #18 0x0000000000931c79 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:42:35.831] bsdata = [03:42:35.831] #19 0x000000000088b807 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8215cc294 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215cc1d0) at ../src/backend/postmaster/launch_backend.c:274 [03:42:35.831] pid = [03:42:35.831] #20 0x000000000088fbd8 in BackendStartup (client_sock=0x8215cc1d0) at ../src/backend/postmaster/postmaster.c:3420 [03:42:35.831] startup_data = {canAcceptConnections = CAC_OK} [03:42:35.831] bn = 0x835b83628 [03:42:35.831] pid = [03:42:35.831] __error = [03:42:35.831] save_errno = [03:42:35.831] __error = [03:42:35.831] __error = [03:42:35.831] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [03:42:35.831] 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 = " |\2675\b", '\000' , "0\302\\!\b\000\000\000hŵ(\b\000\000\000\v\000\000\000\000\000\000\000^O\266(\b", '\000' , "p\302\\!\b\000\000\000\264\265\210\000\000\000\000\000\200\302\\!\b", '\000' }, salen = 16}} [03:42:35.831] i = 0 [03:42:35.831] now = [03:42:35.831] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 696732802, events = 8, fd = 0, user_data = 0x8215cc180}, {pos = 901621208, events = 8, fd = 559726608, user_data = 0x0}, {pos = -1384443126, events = 8764, fd = 695900064, user_data = 0x8297bad78}, {pos = 559725704, events = 8, fd = 559725824, user_data = 0x8215cbc88}, {pos = -1384443126, events = 8764, fd = 695878536, user_data = 0x8297bad78}, {pos = 559725752, events = 8, fd = 559725872, user_data = 0x8215cbcb8}, {pos = 695939476, events = 8, fd = 568816648, user_data = 0x8297b3194}, {pos = 559725856, events = 8, fd = -1384463302, user_data = 0x8215cbcc0}, {pos = 682992656, events = 8, fd = 697761840, user_data = 0x223cad7b130a}, {pos = 695847000, events = 8, fd = 695971192, user_data = 0x8215cbd28}, {pos = 559725984, events = 8, fd = 559725864, user_data = 0x8297b1d0c}, {pos = 568816648, events = 8, fd = 695934220, user_data = 0x8215cbd90}, {pos = -1384463302, events = 8764, fd = 559726008, user_data = 0x8215cbf88}, {pos = 559725984, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821e7d038}, {pos = 1, events = 696663661, fd = 568816648, user_data = 0x8297a4388}, {pos = 568838088, events = 8, fd = 0, user_data = 0x0}, {pos = 559726120, events = 8, fd = 559726584, user_data = 0x8215cbe10}, {pos = -1384444766, events = 8764, fd = 2701916, user_data = 0x6d68b}, {pos = 2090263927, events = 696663661, fd = 568840248, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8215cc0f8}, {pos = 568816648, events = 3, fd = 559726656, user_data = 0x821e7c828}, {pos = 656, events = 0, fd = 559726584, user_data = 0x8215cbe28}, {pos = 559726224, events = 8, fd = -1384445157, user_data = 0x8215cbfc0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 568840248, events = 8, fd = 1, user_data = 0x821e77408}, {pos = 695847000, events = 8, fd = 559726840, user_data = 0x8215cc040}, {pos = 559726240, events = 8, fd = 0, user_data = 0x821e70008}, {pos = 33, events = 0, fd = 559726640, user_data = 0x223cad7aaae7}, {pos = 568786952, events = 8, fd = 568787976, user_data = 0x821e70808}, {pos = 568790024, events = 8, fd = 568803336, user_data = 0x821e74408}, {pos = 568805384, events = 8, fd = 568806408, user_data = 0x821e75008}, {pos = 568808456, events = 8, fd = 568809480, user_data = 0x821e75c08}, {pos = 568811528, events = 8, fd = 568812552, user_data = 0x821e76808}, {pos = 568814600, events = 8, fd = 568815624, user_data = 0x821e77408}, {pos = 568817672, events = 8, fd = 568818696, user_data = 0x821e78008}, {pos = 568820744, events = 8, fd = 568821768, user_data = 0x821e78c08}, {pos = 568823816, events = 8, fd = 568824840, user_data = 0x821e79808}, {pos = 568826888, events = 8, fd = 568832008, user_data = 0x821e7b408}, {pos = 568834056, events = 8, fd = 568835080, user_data = 0x821e7e408}, {pos = 45574000, events = 0, fd = 568786952, user_data = 0x293a5c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821e7d038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 559726840, events = 8, fd = 559726240, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 568840248, user_data = 0x1}, {pos = 568786952, events = 8, fd = 313, user_data = 0x8215cc0e0}, {pos = -1384471057, events = 8764, fd = 2701916, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 568840248, user_data = 0x1}, {pos = 568816648, events = 8, fd = 901148672, user_data = 0x1}, {pos = 901149076, events = 8, fd = 0, user_data = 0x8215cc0b0}, {pos = 683033964, events = 8, fd = 1, user_data = 0x835b67000}, {pos = 559726816, events = 8, fd = 683030274, user_data = 0x8298ce170 }, {pos = 12306704, events = 0, fd = 697098608, user_data = 0x821e77408}, {pos = 559727040, events = 8, fd = -1384471586, user_data = 0x835b85800}, {pos = 1, events = 0, fd = -1384471970, user_data = 0x821e70008}, {pos = 559726824, events = 8, fd = 559727040, user_data = 0x1c20}, {pos = 901217312, events = 8, fd = -1384392304, user_data = 0x0}, {pos = 559678335, events = 8, fd = 8107511, user_data = 0x8215cc170}, {pos = 682992656, events = 8, fd = 697761840, user_data = 0x829972310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8215cc1a0}, {pos = 683035549, events = 8, fd = 901148672, user_data = 0x3698}, {pos = 559727104, events = 8, fd = 683002106, user_data = 0x0}, {pos = 0, events = 0, fd = 1414752743, user_data = 0x0}} [03:42:35.832] last_touch_time = 1727753921 [03:42:35.832] last_lockfile_recheck_time = 1727753921 [03:42:35.832] nevents = 1 [03:42:35.832] #22 0x000000000088d9f5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8215cc7e0) at ../src/backend/postmaster/postmaster.c:1351 [03:42:35.832] userDoption = [03:42:35.832] listen_addr_saved = [03:42:35.832] output_config_variable = [03:42:35.832] opt = [03:42:35.832] status = [03:42:35.832] #23 0x00000000007c82dc in main (argc=4, argv=0x8215cc7e0) at ../src/backend/main/main.c:197 [03:42:35.832] do_check_root =