[03:51:12.982] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [03:51:13.367] dumping /tmp/cores/postgres.10761.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:51:13.498] [New LWP 101816] [03:51:13.586] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:51:13.586] Program terminated with signal SIGABRT, Aborted. [03:51:13.586] Sent by thr_kill() from pid 10761 and user 1003. [03:51:13.586] #0 0x000000082c7cb41a in thr_kill () from /lib/libc.so.7 [03:51:14.232] [03:51:14.232] Thread 1 (LWP 101816): [03:51:14.232] #0 0x000000082c7cb41a in thr_kill () from /lib/libc.so.7 [03:51:14.232] No symbol table info available. [03:51:14.232] #1 0x000000082c744e64 in raise () from /lib/libc.so.7 [03:51:14.232] No symbol table info available. [03:51:14.232] #2 0x000000082c7f56f9 in abort () from /lib/libc.so.7 [03:51:14.232] No symbol table info available. [03:51:14.232] #3 0x0000000000a8fa55 in ExceptionalCondition (conditionName=0x2e74cb "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:51:14.232] No locals. [03:51:14.232] #4 0x0000000000764619 in standard_ExecutorStart (queryDesc=0x835aa2088, eflags=0) at ../src/backend/executor/execMain.c:194 [03:51:14.232] estate = 0x835b63100 [03:51:14.232] oldcontext = 0x843bb6400 [03:51:14.232] #5 0x00000000006fae25 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:51:14.232] copied_query = [03:51:14.232] rewritten = [03:51:14.232] plan = 0x835b8dbd8 [03:51:14.232] queryDesc = 0x835aa2088 [03:51:14.232] processed = [03:51:14.232] __error = [03:51:14.232] #6 RefreshMatViewByOid (matviewOid=27318, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:51:14.232] dest = [03:51:14.232] save_userid = 10 [03:51:14.232] save_sec_context = 0 [03:51:14.232] processed = 0 [03:51:14.232] matviewRel = 0x843d027b8 [03:51:14.232] relowner = 10 [03:51:14.232] save_nestlevel = 2 [03:51:14.232] rule = [03:51:14.232] actions = [03:51:14.232] dataQuery = [03:51:14.232] tableSpace = [03:51:14.232] relpersistence = [03:51:14.232] OIDNewHeap = 27331 [03:51:14.232] address = [03:51:14.232] #7 0x00000000006faa06 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:51:14.232] lockmode = [03:51:14.232] matviewOid = 0 [03:51:14.232] #8 0x00000000006d230c in ExecCreateTableAs (pstate=pstate@entry=0x843bb6500, stmt=stmt@entry=0x843be9fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821415970) at ../src/backend/commands/createas.c:350 [03:51:14.232] refresh = 0x0 [03:51:14.232] query = 0x835adfd58 [03:51:14.232] into = 0x835ae00a0 [03:51:14.232] do_refresh = false [03:51:14.232] address = [03:51:14.232] dest = [03:51:14.232] is_matview = [03:51:14.232] #9 0x000000000093c5d8 in ProcessUtilitySlow (pstate=pstate@entry=0x843bb6500, pstmt=pstmt@entry=0x835a02a68, queryString=queryString@entry=0x835a01100 "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=0x821415970) at ../src/backend/tcop/utility.c:1675 [03:51:14.232] _local_sigjmp_buf = {{_sjb = {9682441, 0, 34917668248, 34917668624, 34917668256, 12366232, 0, 35496092928, 4294902655, 34917668364, 34917668400, 0}}} [03:51:14.232] _save_exception_stack = 0x821415870 [03:51:14.232] _save_context_stack = 0x0 [03:51:14.232] _do_rethrow = false [03:51:14.232] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:51:14.232] parsetree = 0x843be9fd0 [03:51:14.232] commandCollected = false [03:51:14.232] needCleanup = false [03:51:14.232] address = [03:51:14.232] isTopLevel = [03:51:14.232] isCompleteQuery = [03:51:14.232] #10 0x000000000093af58 in standard_ProcessUtility (pstmt=0x835a02a68, queryString=0x835a01100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835ae0588, qc=0x821415970) at ../src/backend/tcop/utility.c:1030 [03:51:14.232] isAtomicContext = false [03:51:14.232] parsetree = 0x843be9fd0 [03:51:14.232] readonly_flags = [03:51:14.232] pstate = 0x843bb6500 [03:51:14.232] isTopLevel = [03:51:14.232] #11 0x000000000093a9e8 in ProcessUtility (pstmt=0x18db8, queryString=0x6 , readOnlyTree=, context=746370042, params=0x0, queryEnv=0x0, dest=0x835ae0588, qc=0x821415970) at ../src/backend/tcop/utility.c:523 [03:51:14.232] No locals. [03:51:14.232] #12 0x000000000093a523 in PortalRunUtility (portal=0x835ad8100, pstmt=0x835a02a68, isTopLevel=, setHoldSnapshot=, dest=0x835ae0588, qc=0x821415970) at ../src/backend/tcop/pquery.c:1158 [03:51:14.232] No locals. [03:51:14.232] #13 0x0000000000939bb4 in PortalRunMulti (portal=portal@entry=0x835ad8100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835ae0588, altdest=altdest@entry=0x835ae0588, qc=0x821415970) at ../src/backend/tcop/pquery.c:1323 [03:51:14.232] pstmt = 0x835a02a68 [03:51:14.232] stmtlist_item__state = {l = 0x835ae0538, i = 0} [03:51:14.232] active_snapshot_set = false [03:51:14.232] stmtlist_item = 0x835ae0550 [03:51:14.232] #14 0x0000000000939483 in PortalRun (portal=portal@entry=0x835ad8100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835ae0588, altdest=altdest@entry=0x835ae0588, qc=0x821415970) at ../src/backend/tcop/pquery.c:791 [03:51:14.232] _local_sigjmp_buf = {{_sjb = {9671677, 35260301568, 34917668968, 34917669200, 34917668976, 35260813312, 12332904, 12366232, 35260269439, 35496297872, 4294967984, 0}}} [03:51:14.232] _save_exception_stack = 0x821415a40 [03:51:14.232] _save_context_stack = 0x0 [03:51:14.232] _do_rethrow = false [03:51:14.232] saveTopTransactionResourceOwner = 0x835ae9658 [03:51:14.232] saveTopTransactionContext = 0x835b55000 [03:51:14.232] saveActivePortal = 0x0 [03:51:14.232] saveResourceOwner = 0x835ae9658 [03:51:14.232] savePortalContext = 0x0 [03:51:14.232] saveMemoryContext = 0x835b55000 [03:51:14.232] result = [03:51:14.232] nprocessed = [03:51:14.232] #15 0x0000000000938322 in exec_simple_query (query_string=query_string@entry=0x835a01100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:51:14.232] cmdtaglen = 24 [03:51:14.232] snapshot_set = [03:51:14.232] per_parsetree_context = 0x0 [03:51:14.232] plantree_list = [03:51:14.232] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:51:14.232] format = 0 [03:51:14.232] parsetree = 0x835a026a8 [03:51:14.232] commandTag = [03:51:14.232] cmdtagname = [03:51:14.232] querytree_list = [03:51:14.232] portal = 0x835ad8100 [03:51:14.232] receiver = 0x835ae0588 [03:51:14.232] parsetree_item__state = {l = 0x835a02a18, i = 0} [03:51:14.232] msec_str = "\000\000\000\000\b", '\000' , "\273A\356f\000\000\000\000\267\255 ;~`\326K" [03:51:14.232] dest = DestRemote [03:51:14.232] was_logged = [03:51:14.232] oldcontext = 0x835b55000 [03:51:14.232] parsetree_list = 0x835a02a18 [03:51:14.232] use_implicit_block = false [03:51:14.232] parsetree_item = 0x835a02a30 [03:51:14.232] save_log_statement_stats = [03:51:14.232] #16 0x0000000000935f93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [03:51:14.232] query_string = 0x835a01100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:51:14.232] input_message = {data = 0x835a01100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:51:14.232] firstchar = [03:51:14.232] local_sigjmp_buf = {{_sjb = {9655366, 34917669440, 34917669400, 34917669984, 12374968, 1, 8192, 8388608, 34917647231, 0, 0, 1}}} [03:51:14.232] send_ready_for_query = false [03:51:14.232] idle_in_transaction_timeout_enabled = false [03:51:14.232] idle_session_timeout_enabled = false [03:51:14.232] #17 0x0000000000930789 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:51:14.232] bsdata = [03:51:14.232] #18 0x000000000088a8d7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821416784 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214166c0) at ../src/backend/postmaster/launch_backend.c:274 [03:51:14.232] pid = [03:51:14.232] #19 0x000000000088ec98 in BackendStartup (client_sock=0x8214166c0) at ../src/backend/postmaster/postmaster.c:3415 [03:51:14.232] startup_data = {canAcceptConnections = CAC_OK} [03:51:14.232] bn = 0x835a0d448 [03:51:14.232] pid = [03:51:14.232] __error = [03:51:14.232] save_errno = [03:51:14.232] __error = [03:51:14.232] __error = [03:51:14.232] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [03:51:14.232] 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/\2405\b", '\000' , " gA!\b\000\000\000hU\231*\b\000\000\000\v\000\000\000\000\000\000\000^ߙ*\b", '\000' , "`gA!\b\000\000\000\204\246\210\000\000\000\000\000pgA!\b", '\000' }, salen = 16}} [03:51:14.232] i = 0 [03:51:14.232] now = [03:51:14.232] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 745995394, events = 8, fd = 0, user_data = 0x821416670}, {pos = 900060632, events = 8, fd = 557933824, user_data = 0x0}, {pos = 0, events = 0, fd = 468696427, user_data = 0x36a3c89ac30a}, {pos = 745162656, events = 8, fd = 745233784, user_data = 0x821416188}, {pos = 557933056, events = 8, fd = 557932936, user_data = 0x36a3c89ac30a}, {pos = 745141128, events = 8, fd = 745233784, user_data = 0x8214161b8}, {pos = 557933104, events = 8, fd = 557932984, user_data = 0x82c6ae194}, {pos = 562045960, events = 8, fd = 745202068, user_data = 0x821416220}, {pos = -929401798, events = 13987, fd = 747024432, user_data = 0x1}, {pos = 557933136, events = 8, fd = -929381622, user_data = 0x82c697858}, {pos = 745233784, events = 8, fd = 557933096, user_data = 0x8214162a0}, {pos = 557933096, events = 8, fd = 745196812, user_data = 0x821802408}, {pos = 745196812, events = 8, fd = 557933200, user_data = 0x36a3c89a743a}, {pos = 557933240, events = 8, fd = 557933688, user_data = 0x8214162a0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3484416340, fd = 562069560, user_data = 0x800000001}, {pos = 562045960, events = 8, fd = 745141128, user_data = 0x821807288}, {pos = 745109592, events = 8, fd = 562045960, user_data = 0x821416328}, {pos = 557933800, events = 8, fd = 557933328, user_data = 0x36a3c89abca2}, {pos = 2700976, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 562069560, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 557934056, user_data = 0x21802408}, {pos = 557933872, events = 8, fd = 557933472, user_data = 0x1}, {pos = 557933800, events = 8, fd = 32, user_data = 0x821416390}, {pos = -929383821, events = 13987, fd = 557933744, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821808038}, {pos = 1, events = 8, fd = 562045960, user_data = 0x82c697858}, {pos = 557934056, events = 8, fd = 557933872, user_data = 0x8214163a0}, {pos = 0, events = 0, fd = 562016264, user_data = 0x20}, {pos = 557933856, events = 8, fd = -929408281, user_data = 0x8217fb008}, {pos = 562017288, events = 8, fd = 562018312, user_data = 0x8217fbc08}, {pos = 562032648, events = 8, fd = 562033672, user_data = 0x8217ff808}, {pos = 562035720, events = 8, fd = 562036744, user_data = 0x821800408}, {pos = 562038792, events = 8, fd = 562039816, user_data = 0x821801008}, {pos = 562041864, events = 8, fd = 562042888, user_data = 0x821801c08}, {pos = 562044936, events = 8, fd = 562045960, user_data = 0x821802808}, {pos = 562048008, events = 8, fd = 562049032, user_data = 0x821803408}, {pos = 562051080, events = 8, fd = 562052104, user_data = 0x821804008}, {pos = 562054152, events = 8, fd = 562055176, user_data = 0x821804c08}, {pos = 562061320, events = 8, fd = 562062344, user_data = 0x821806808}, {pos = 562064392, events = 8, fd = 562016264, user_data = 0x2936b0}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821808038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557934056, events = 8, fd = 557933472, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 562069560, user_data = 0x1}, {pos = 562016264, events = 8, fd = 313, user_data = 0x8214165d0}, {pos = -929409553, events = 13987, fd = 2700976, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 562069560, user_data = 0x1}, {pos = 562045960, events = 8, fd = 899616768, user_data = 0x1}, {pos = 899617172, events = 8, fd = 0, user_data = 0x8214165a0}, {pos = 714724716, events = 8, fd = 1, user_data = 0x8359f1000}, {pos = 557934032, events = 8, fd = 714721026, user_data = 0x82c7c9170 }, {pos = 12300000, events = 0, fd = 746361200, user_data = 0x821802408}, {pos = 557934256, events = 8, fd = -929410082, user_data = 0x835a0f800}, {pos = 1, events = 0, fd = -929410466, user_data = 0x8217fb008}, {pos = 557934040, events = 8, fd = 557934256, user_data = 0x1c20}, {pos = 899690240, events = 8, fd = -929330800, user_data = 0x0}, {pos = 557908863, events = 8, fd = 8104951, user_data = 0x821416660}, {pos = 714683408, events = 8, fd = 747024432, user_data = 0x82c86d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821416690}, {pos = 714726301, events = 8, fd = 899616768, user_data = 0x1d94}, {pos = 557934320, events = 8, fd = 714692858, user_data = 0x0}, {pos = 0, events = 0, fd = 468696427, user_data = 0x0}} [03:51:14.232] last_touch_time = 1726890406 [03:51:14.232] last_lockfile_recheck_time = 1726890406 [03:51:14.232] nevents = 1 [03:51:14.232] #21 0x000000000088cab5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821416cd8) at ../src/backend/postmaster/postmaster.c:1346 [03:51:14.232] userDoption = [03:51:14.232] listen_addr_saved = [03:51:14.232] output_config_variable = [03:51:14.232] opt = [03:51:14.232] status = [03:51:14.232] #22 0x00000000007c78dc in main (argc=8, argv=0x821416cd8) at ../src/backend/main/main.c:197 [03:51:14.232] do_check_root = [03:51:14.244] [03:51:14.244] [03:51:14.244] [03:51:14.307] dumping /tmp/cores/postgres.11388.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:51:14.430] [New LWP 101804] [03:51:14.498] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:51:14.498] Program terminated with signal SIGABRT, Aborted. [03:51:14.498] Sent by thr_kill() from pid 11388 and user 1003. [03:51:14.498] #0 0x000000082b03441a in thr_kill () from /lib/libc.so.7 [03:51:15.144] [03:51:15.144] Thread 1 (LWP 101804): [03:51:15.144] #0 0x000000082b03441a in thr_kill () from /lib/libc.so.7 [03:51:15.144] No symbol table info available. [03:51:15.144] #1 0x000000082afade64 in raise () from /lib/libc.so.7 [03:51:15.144] No symbol table info available. [03:51:15.144] #2 0x000000082b05e6f9 in abort () from /lib/libc.so.7 [03:51:15.144] No symbol table info available. [03:51:15.144] #3 0x0000000000a8fa55 in ExceptionalCondition (conditionName=0x2e74cb "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:51:15.144] No locals. [03:51:15.144] #4 0x0000000000764619 in standard_ExecutorStart (queryDesc=0x8430af088, eflags=0) at ../src/backend/executor/execMain.c:194 [03:51:15.144] estate = 0x84301b100 [03:51:15.144] oldcontext = 0x83551d800 [03:51:15.144] #5 0x00000000006fae25 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:51:15.144] copied_query = [03:51:15.144] rewritten = [03:51:15.144] plan = 0x835519bd8 [03:51:15.144] queryDesc = 0x8430af088 [03:51:15.144] processed = [03:51:15.144] __error = [03:51:15.144] #6 RefreshMatViewByOid (matviewOid=27324, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:51:15.144] dest = [03:51:15.144] save_userid = 10 [03:51:15.144] save_sec_context = 0 [03:51:15.144] processed = 0 [03:51:15.144] matviewRel = 0x842fcb700 [03:51:15.144] relowner = 10 [03:51:15.144] save_nestlevel = 2 [03:51:15.144] rule = [03:51:15.144] actions = [03:51:15.144] dataQuery = [03:51:15.144] tableSpace = [03:51:15.144] relpersistence = [03:51:15.144] OIDNewHeap = 27331 [03:51:15.144] address = [03:51:15.144] #7 0x00000000006faa06 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:51:15.144] lockmode = [03:51:15.144] matviewOid = 0 [03:51:15.144] #8 0x00000000006d230c in ExecCreateTableAs (pstate=pstate@entry=0x83551d900, stmt=stmt@entry=0x83551bfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820d8d5c0) at ../src/backend/commands/createas.c:350 [03:51:15.144] refresh = 0x0 [03:51:15.144] query = 0x835464818 [03:51:15.144] into = 0x835464b60 [03:51:15.144] do_refresh = false [03:51:15.144] address = [03:51:15.144] dest = [03:51:15.144] is_matview = [03:51:15.144] #9 0x000000000093c5d8 in ProcessUtilitySlow (pstate=pstate@entry=0x83551d900, pstmt=pstmt@entry=0x83537da68, queryString=queryString@entry=0x83537c100 "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=0x820d8d5c0) at ../src/backend/tcop/utility.c:1675 [03:51:15.144] _local_sigjmp_buf = {{_sjb = {9682441, 0, 34910818792, 34910819168, 34910818800, 12366232, 0, 35254294784, 4294902655, 34910818908, 34910818944, 0}}} [03:51:15.144] _save_exception_stack = 0x820d8d4c0 [03:51:15.144] _save_context_stack = 0x0 [03:51:15.144] _do_rethrow = false [03:51:15.144] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:51:15.144] parsetree = 0x83551bfd0 [03:51:15.144] commandCollected = false [03:51:15.144] needCleanup = false [03:51:15.144] address = [03:51:15.144] isTopLevel = [03:51:15.144] isCompleteQuery = [03:51:15.144] #10 0x000000000093af58 in standard_ProcessUtility (pstmt=0x83537da68, queryString=0x83537c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835465048, qc=0x820d8d5c0) at ../src/backend/tcop/utility.c:1030 [03:51:15.144] isAtomicContext = false [03:51:15.144] parsetree = 0x83551bfd0 [03:51:15.144] readonly_flags = [03:51:15.144] pstate = 0x83551d900 [03:51:15.144] isTopLevel = [03:51:15.144] #11 0x000000000093a9e8 in ProcessUtility (pstmt=0x18dac, queryString=0x6 , readOnlyTree=, context=721634298, params=0x0, queryEnv=0x0, dest=0x835465048, qc=0x820d8d5c0) at ../src/backend/tcop/utility.c:523 [03:51:15.144] No locals. [03:51:15.144] #12 0x000000000093a523 in PortalRunUtility (portal=0x835422100, pstmt=0x83537da68, isTopLevel=, setHoldSnapshot=, dest=0x835465048, qc=0x820d8d5c0) at ../src/backend/tcop/pquery.c:1158 [03:51:15.144] No locals. [03:51:15.144] #13 0x0000000000939bb4 in PortalRunMulti (portal=portal@entry=0x835422100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835465048, altdest=altdest@entry=0x835465048, qc=0x820d8d5c0) at ../src/backend/tcop/pquery.c:1323 [03:51:15.144] pstmt = 0x83537da68 [03:51:15.144] stmtlist_item__state = {l = 0x835464ff8, i = 0} [03:51:15.144] active_snapshot_set = false [03:51:15.144] stmtlist_item = 0x835465010 [03:51:15.144] #14 0x0000000000939483 in PortalRun (portal=portal@entry=0x835422100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835465048, altdest=altdest@entry=0x835465048, qc=0x820d8d5c0) at ../src/backend/tcop/pquery.c:791 [03:51:15.144] _local_sigjmp_buf = {{_sjb = {9671677, 35253264640, 34910819512, 34910819744, 34910819520, 35253280768, 12332904, 12366232, 35253257087, 35254281616, 4294967984, 0}}} [03:51:15.144] _save_exception_stack = 0x820d8d690 [03:51:15.144] _save_context_stack = 0x0 [03:51:15.144] _do_rethrow = false [03:51:15.144] saveTopTransactionResourceOwner = 0x835471758 [03:51:15.144] saveTopTransactionContext = 0x835426000 [03:51:15.144] saveActivePortal = 0x0 [03:51:15.144] saveResourceOwner = 0x835471758 [03:51:15.144] savePortalContext = 0x0 [03:51:15.144] saveMemoryContext = 0x835426000 [03:51:15.144] result = [03:51:15.144] nprocessed = [03:51:15.144] #15 0x0000000000938322 in exec_simple_query (query_string=query_string@entry=0x83537c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:51:15.144] cmdtaglen = 24 [03:51:15.144] snapshot_set = [03:51:15.144] per_parsetree_context = 0x0 [03:51:15.144] plantree_list = [03:51:15.144] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:51:15.144] format = 0 [03:51:15.144] parsetree = 0x83537d6a8 [03:51:15.144] commandTag = [03:51:15.144] cmdtagname = [03:51:15.144] querytree_list = [03:51:15.144] portal = 0x835422100 [03:51:15.144] receiver = 0x835465048 [03:51:15.144] parsetree_item__state = {l = 0x83537da18, i = 0} [03:51:15.144] msec_str = "\000\000\000\000\b", '\000' , "\276A\356f\000\000\000\000\275\351\374\371\3020\256", [03:51:15.144] dest = DestRemote [03:51:15.144] was_logged = [03:51:15.144] oldcontext = 0x835426000 [03:51:15.144] parsetree_list = 0x83537da18 [03:51:15.144] use_implicit_block = false [03:51:15.144] parsetree_item = 0x83537da30 [03:51:15.144] save_log_statement_stats = [03:51:15.144] #16 0x0000000000935f93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [03:51:15.144] query_string = 0x83537c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:51:15.144] input_message = {data = 0x83537c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:51:15.144] firstchar = [03:51:15.144] local_sigjmp_buf = {{_sjb = {9655366, 34910819984, 34910819944, 34910820528, 12374968, 1, 8192, 8388608, 34910765951, 0, 0, 1}}} [03:51:15.144] send_ready_for_query = false [03:51:15.144] idle_in_transaction_timeout_enabled = false [03:51:15.144] idle_session_timeout_enabled = false [03:51:15.144] #17 0x0000000000930789 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:51:15.144] bsdata = [03:51:15.144] #18 0x000000000088a8d7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d8e3d4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d8e310) at ../src/backend/postmaster/launch_backend.c:274 [03:51:15.144] pid = [03:51:15.144] #19 0x000000000088ec98 in BackendStartup (client_sock=0x820d8e310) at ../src/backend/postmaster/postmaster.c:3415 [03:51:15.144] startup_data = {canAcceptConnections = CAC_OK} [03:51:15.144] bn = 0x835388538 [03:51:15.144] pid = [03:51:15.144] __error = [03:51:15.144] save_errno = [03:51:15.144] __error = [03:51:15.144] __error = [03:51:15.144] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [03:51:15.144] 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\33675\b", '\000' , "p\343\330 \b\000\000\000h\205\226*\b\000\000\000\v\000\000\000\000\000\000\000^\017\227*\b", '\000' , "\260\343\330 \b\000\000\000\204\246\210\000\000\000\000\000\300\343\330 \b", '\000' }, salen = 16}} [03:51:15.144] i = 0 [03:51:15.144] now = [03:51:15.144] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 721259650, events = 8, fd = 0, user_data = 0x820d8e2c0}, {pos = 893281752, events = 8, fd = 551084368, user_data = 0x0}, {pos = 0, events = 0, fd = -954953130, user_data = 0x1069ab82730a}, {pos = 720426912, events = 8, fd = 720498040, user_data = 0x820d8ddd8}, {pos = 551083600, events = 8, fd = 551083480, user_data = 0x1069ab82730a}, {pos = 720405384, events = 8, fd = 720498040, user_data = 0x820d8de08}, {pos = 551083648, events = 8, fd = 551083528, user_data = 0x82af17194}, {pos = 560624648, events = 8, fd = 720466324, user_data = 0x820d8de70}, {pos = -1417534406, events = 4201, fd = 722288688, user_data = 0x1}, {pos = 551083680, events = 8, fd = -1417514230, user_data = 0x82af00858}, {pos = 720498040, events = 8, fd = 551083640, user_data = 0x820d8def0}, {pos = 551083640, events = 8, fd = 720461068, user_data = 0x8216a7408}, {pos = 720461068, events = 8, fd = 551083744, user_data = 0x1069ab82243a}, {pos = 551083784, events = 8, fd = 551084232, user_data = 0x820d8def0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3774832185, fd = 560648248, user_data = 0x800000001}, {pos = 560624648, events = 8, fd = 720405384, user_data = 0x8216ac288}, {pos = 720373848, events = 8, fd = 560624648, user_data = 0x820d8df78}, {pos = 551084344, events = 8, fd = 551083872, user_data = 0x1069ab826ca2}, {pos = 2700976, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560648248, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 551084600, user_data = 0x216a7408}, {pos = 551084416, events = 8, fd = 551084016, user_data = 0x1}, {pos = 551084344, events = 8, fd = 32, user_data = 0x820d8dfe0}, {pos = -1417516429, events = 4201, fd = 551084288, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8216ad038}, {pos = 1, events = 8, fd = 560624648, user_data = 0x82af00858}, {pos = 551084600, events = 8, fd = 551084416, user_data = 0x820d8dff0}, {pos = 0, events = 0, fd = 560594952, user_data = 0x20}, {pos = 551084400, events = 8, fd = -1417540889, user_data = 0x8216a0008}, {pos = 560595976, events = 8, fd = 560597000, user_data = 0x8216a0c08}, {pos = 560611336, events = 8, fd = 560612360, user_data = 0x8216a4808}, {pos = 560614408, events = 8, fd = 560615432, user_data = 0x8216a5408}, {pos = 560617480, events = 8, fd = 560618504, user_data = 0x8216a6008}, {pos = 560620552, events = 8, fd = 560621576, user_data = 0x8216a6c08}, {pos = 560623624, events = 8, fd = 560624648, user_data = 0x8216a7808}, {pos = 560626696, events = 8, fd = 560627720, user_data = 0x8216a8408}, {pos = 560629768, events = 8, fd = 560630792, user_data = 0x8216a9008}, {pos = 560632840, events = 8, fd = 560633864, user_data = 0x8216a9c08}, {pos = 560640008, events = 8, fd = 560641032, user_data = 0x8216ab808}, {pos = 560643080, events = 8, fd = 560594952, user_data = 0x2936b0}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8216ad038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 551084600, events = 8, fd = 551084016, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560648248, user_data = 0x1}, {pos = 560594952, events = 8, fd = 313, user_data = 0x820d8e220}, {pos = -1417542161, events = 4201, fd = 2700976, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560648248, user_data = 0x1}, {pos = 560624648, events = 8, fd = 892780544, user_data = 0x1}, {pos = 892780948, events = 8, fd = 0, user_data = 0x820d8e1f0}, {pos = 714540396, events = 8, fd = 1, user_data = 0x83536c000}, {pos = 551084576, events = 8, fd = 714536706, user_data = 0x82b032170 }, {pos = 12300000, events = 0, fd = 721625456, user_data = 0x8216a7408}, {pos = 551084800, events = 8, fd = -1417542690, user_data = 0x83538a800}, {pos = 1, events = 0, fd = -1417543074, user_data = 0x8216a0008}, {pos = 551084584, events = 8, fd = 551084800, user_data = 0x1c20}, {pos = 892853952, events = 8, fd = -1417463408, user_data = 0x0}, {pos = 551027583, events = 8, fd = 8104951, user_data = 0x820d8e2b0}, {pos = 714499088, events = 8, fd = 722288688, user_data = 0x82b0d6310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d8e2e0}, {pos = 714541981, events = 8, fd = 892780544, user_data = 0x1de5}, {pos = 551084864, events = 8, fd = 714508538, user_data = 0x0}, {pos = 0, events = 0, fd = -954953130, user_data = 0x0}} [03:51:15.144] last_touch_time = 1726890406 [03:51:15.144] last_lockfile_recheck_time = 1726890406 [03:51:15.144] nevents = 1 [03:51:15.144] #21 0x000000000088cab5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820d8e928) at ../src/backend/postmaster/postmaster.c:1346 [03:51:15.144] userDoption = [03:51:15.144] listen_addr_saved = [03:51:15.144] output_config_variable = [03:51:15.144] opt = [03:51:15.144] status = [03:51:15.144] #22 0x00000000007c78dc in main (argc=4, argv=0x820d8e928) at ../src/backend/main/main.c:197 [03:51:15.144] do_check_root = [03:51:15.157] [03:51:15.157] [03:51:15.157] [03:51:15.224] dumping /tmp/cores/postgres.17624.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:51:15.350] [New LWP 100098] [03:51:15.415] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:51:15.415] Program terminated with signal SIGABRT, Aborted. [03:51:15.415] Sent by thr_kill() from pid 17624 and user 1003. [03:51:15.415] #0 0x000000082b09741a in thr_kill () from /lib/libc.so.7 [03:51:16.085] [03:51:16.085] Thread 1 (LWP 100098): [03:51:16.085] #0 0x000000082b09741a in thr_kill () from /lib/libc.so.7 [03:51:16.085] No symbol table info available. [03:51:16.085] #1 0x000000082b010e64 in raise () from /lib/libc.so.7 [03:51:16.085] No symbol table info available. [03:51:16.085] #2 0x000000082b0c16f9 in abort () from /lib/libc.so.7 [03:51:16.085] No symbol table info available. [03:51:16.085] #3 0x0000000000a8fa55 in ExceptionalCondition (conditionName=0x2e74cb "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:51:16.085] No locals. [03:51:16.085] #4 0x0000000000764619 in standard_ExecutorStart (queryDesc=0x836a6b088, eflags=0) at ../src/backend/executor/execMain.c:194 [03:51:16.085] estate = 0x836abc100 [03:51:16.085] oldcontext = 0x8369c1800 [03:51:16.085] #5 0x000000083936d862 in pgss_ExecutorStart (queryDesc=0x836a6b088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [03:51:16.085] No locals. [03:51:16.085] #6 0x00000000006fae25 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:51:16.085] copied_query = [03:51:16.085] rewritten = [03:51:16.085] plan = 0x83cfd6bd0 [03:51:16.085] queryDesc = 0x836a6b088 [03:51:16.085] processed = [03:51:16.085] __error = [03:51:16.085] #7 RefreshMatViewByOid (matviewOid=27290, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:51:16.085] dest = [03:51:16.085] save_userid = 10 [03:51:16.085] save_sec_context = 0 [03:51:16.085] processed = 0 [03:51:16.085] matviewRel = 0x83cf1ace8 [03:51:16.085] relowner = 10 [03:51:16.085] save_nestlevel = 2 [03:51:16.085] rule = [03:51:16.085] actions = [03:51:16.085] dataQuery = [03:51:16.085] tableSpace = [03:51:16.085] relpersistence = [03:51:16.085] OIDNewHeap = 27311 [03:51:16.085] address = [03:51:16.085] #8 0x00000000006faa06 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:51:16.085] lockmode = [03:51:16.085] matviewOid = 0 [03:51:16.085] #9 0x00000000006d230c in ExecCreateTableAs (pstate=pstate@entry=0x8369c1900, stmt=stmt@entry=0x836983fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8218125c0) at ../src/backend/commands/createas.c:350 [03:51:16.085] refresh = 0x0 [03:51:16.085] query = 0x8369ce148 [03:51:16.085] into = 0x836983f40 [03:51:16.085] do_refresh = false [03:51:16.085] address = [03:51:16.085] dest = [03:51:16.085] is_matview = [03:51:16.085] #10 0x000000000093c5d8 in ProcessUtilitySlow (pstate=pstate@entry=0x8369c1900, pstmt=pstmt@entry=0x836983e30, queryString=queryString@entry=0x8368e6100 "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=0x8218125c0) at ../src/backend/tcop/utility.c:1675 [03:51:16.085] _local_sigjmp_buf = {{_sjb = {9682441, 0, 34921848872, 34921849248, 34921848880, 12366232, 0, 35275938048, 34921841535, 7, 34921849024, 0}}} [03:51:16.085] _save_exception_stack = 0x8218122b0 [03:51:16.085] _save_context_stack = 0x0 [03:51:16.085] _do_rethrow = false [03:51:16.085] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:51:16.085] parsetree = 0x836983fd0 [03:51:16.085] commandCollected = false [03:51:16.085] needCleanup = false [03:51:16.085] address = [03:51:16.085] isTopLevel = [03:51:16.085] isCompleteQuery = [03:51:16.085] #11 0x000000000093af58 in standard_ProcessUtility (pstmt=0x836983e30, queryString=queryString@entry=0x8368e6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8369ce8e8, qc=0x8218125c0) at ../src/backend/tcop/utility.c:1030 [03:51:16.085] isAtomicContext = false [03:51:16.085] parsetree = 0x836983fd0 [03:51:16.085] readonly_flags = [03:51:16.085] pstate = 0x8369c1900 [03:51:16.085] isTopLevel = [03:51:16.085] #12 0x000000083936ddee in pgss_ProcessUtility (pstmt=0x836983e30, queryString=0x8368e6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8369ce8e8, qc=0x8218125c0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [03:51:16.085] _local_sigjmp_buf = {{_sjb = {35319635239, 34921849520, 34921849384, 34921849840, 35275685424, 0, 12366232, 34921850048, 34921841535, 34921849620, 34921849648, 0}}} [03:51:16.085] _save_exception_stack = 0x8218124c0 [03:51:16.085] _save_context_stack = 0x0 [03:51:16.085] _do_rethrow = false [03:51:16.085] bufusage = {shared_blks_hit = 35319635239, shared_blks_read = 34921849520, shared_blks_dirtied = 34921849384, shared_blks_written = 34921849840, local_blks_hit = 35275685424, local_blks_read = 0, local_blks_dirtied = 12366232, local_blks_written = 34921850048, temp_blks_read = 34921841535, temp_blks_written = 34921849620, shared_blk_read_time = {ticks = 34921849648}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4185934230705305856}, local_blk_write_time = {ticks = 12375272}, temp_blk_read_time = {ticks = 35338540672}, temp_blk_write_time = {ticks = 12328848}} [03:51:16.085] walusage_start = {wal_records = 8934, wal_fpi = 124, wal_bytes = 1215705} [03:51:16.085] duration = [03:51:16.085] bufusage_start = {shared_blks_hit = 150095, shared_blks_read = 8408, shared_blks_dirtied = 2685, shared_blks_written = 2173, 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:51:16.085] walusage = {wal_records = 7441088250097167375, wal_fpi = 35275685840, wal_bytes = 123} [03:51:16.085] start = {ticks = -192187629969} [03:51:16.085] rows = [03:51:16.085] saved_queryId = 6041762721901209185 [03:51:16.085] parsetree = [03:51:16.085] saved_stmt_location = 0 [03:51:16.085] saved_stmt_len = 69 [03:51:16.085] enabled = [03:51:16.085] #13 0x000000000093a523 in PortalRunUtility (portal=0x83698e100, pstmt=0x836983e30, isTopLevel=, setHoldSnapshot=, dest=0x8369ce8e8, qc=0x8218125c0) at ../src/backend/tcop/pquery.c:1158 [03:51:16.085] No locals. [03:51:16.085] #14 0x0000000000939bb4 in PortalRunMulti (portal=portal@entry=0x83698e100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8369ce8e8, altdest=altdest@entry=0x8369ce8e8, qc=0x8218125c0) at ../src/backend/tcop/pquery.c:1323 [03:51:16.085] pstmt = 0x836983e30 [03:51:16.085] stmtlist_item__state = {l = 0x8369ce898, i = 0} [03:51:16.085] active_snapshot_set = false [03:51:16.085] stmtlist_item = 0x8369ce8b0 [03:51:16.085] #15 0x0000000000939483 in PortalRun (portal=portal@entry=0x83698e100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8369ce8e8, altdest=altdest@entry=0x8369ce8e8, qc=0x8218125c0) at ../src/backend/tcop/pquery.c:791 [03:51:16.085] _local_sigjmp_buf = {{_sjb = {9671677, 35275727104, 34921850040, 34921850272, 34921850048, 35275821056, 12332904, 12366232, 35275735935, 35275679200, 4294967984, 0}}} [03:51:16.085] _save_exception_stack = 0x821812690 [03:51:16.085] _save_context_stack = 0x0 [03:51:16.085] _do_rethrow = false [03:51:16.085] saveTopTransactionResourceOwner = 0x8369dced8 [03:51:16.085] saveTopTransactionContext = 0x8369a5000 [03:51:16.085] saveActivePortal = 0x0 [03:51:16.085] saveResourceOwner = 0x8369dced8 [03:51:16.085] savePortalContext = 0x0 [03:51:16.085] saveMemoryContext = 0x8369a5000 [03:51:16.085] result = [03:51:16.085] nprocessed = [03:51:16.085] #16 0x0000000000938322 in exec_simple_query (query_string=query_string@entry=0x8368e6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [03:51:16.085] cmdtaglen = 24 [03:51:16.085] snapshot_set = [03:51:16.085] per_parsetree_context = 0x0 [03:51:16.085] plantree_list = [03:51:16.085] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:51:16.085] format = 0 [03:51:16.085] parsetree = 0x8368e76a8 [03:51:16.085] commandTag = [03:51:16.085] cmdtagname = [03:51:16.085] querytree_list = [03:51:16.085] portal = 0x83698e100 [03:51:16.085] receiver = 0x8369ce8e8 [03:51:16.085] parsetree_item__state = {l = 0x8368e7a18, i = 0} [03:51:16.085] msec_str = "\000\000\000\000\b", '\000' , "\343A\356f\000\000\000\000\313#\221\356'I'=" [03:51:16.085] dest = DestRemote [03:51:16.085] was_logged = [03:51:16.085] oldcontext = 0x8369a5000 [03:51:16.085] parsetree_list = 0x8368e7a18 [03:51:16.085] use_implicit_block = false [03:51:16.085] parsetree_item = 0x8368e7a30 [03:51:16.085] save_log_statement_stats = [03:51:16.085] #17 0x0000000000935f93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [03:51:16.085] query_string = 0x8368e6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:51:16.085] input_message = {data = 0x8368e6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:51:16.085] firstchar = [03:51:16.085] local_sigjmp_buf = {{_sjb = {9655366, 34921850512, 34921850472, 34921851056, 12374968, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [03:51:16.085] send_ready_for_query = false [03:51:16.085] idle_in_transaction_timeout_enabled = false [03:51:16.085] idle_session_timeout_enabled = false [03:51:16.085] #18 0x0000000000930789 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:51:16.085] bsdata = [03:51:16.085] #19 0x000000000088a8d7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8218133d4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821813310) at ../src/backend/postmaster/launch_backend.c:274 [03:51:16.085] pid = [03:51:16.085] #20 0x000000000088ec98 in BackendStartup (client_sock=0x821813310) at ../src/backend/postmaster/postmaster.c:3415 [03:51:16.085] startup_data = {canAcceptConnections = CAC_OK} [03:51:16.085] bn = 0x8368f2498 [03:51:16.085] pid = [03:51:16.085] __error = [03:51:16.085] save_errno = [03:51:16.085] __error = [03:51:16.085] __error = [03:51:16.085] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [03:51:16.085] 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 = " l\2166\b", '\000' , "p3\201!\b\000\000\000h\265\266*\b\000\000\000\v\000\000\000\000\000\000\000^?\267*\b", '\000' , "\2603\201!\b\000\000\000\204\246\210\000\000\000\000\000\3003\201!\b", '\000' }, salen = 16}} [03:51:16.085] i = 0 [03:51:16.085] now = [03:51:16.085] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 721665154, events = 8, fd = 0, user_data = 0x8218132c0}, {pos = 915707352, events = 8, fd = 562114896, user_data = 0x0}, {pos = 904188682, events = 14862, fd = 720832416, user_data = 0x82af81d78}, {pos = 562113992, events = 8, fd = 562114112, user_data = 0x821812dc8}, {pos = 904188682, events = 14862, fd = 720810888, user_data = 0x82af81d78}, {pos = 562114040, events = 8, fd = 562114160, user_data = 0x821812df8}, {pos = 720871828, events = 8, fd = 571343880, user_data = 0x82af7a194}, {pos = 562114144, events = 8, fd = 904168506, user_data = 0x821812e00}, {pos = 716608528, events = 8, fd = 722694192, user_data = 0x3a0e35e4d30a}, {pos = 720779352, events = 8, fd = 720903544, user_data = 0x821812e68}, {pos = 562114272, events = 8, fd = 562114152, user_data = 0x82af78d0c}, {pos = 571343880, events = 8, fd = 720866572, user_data = 0x821812ed0}, {pos = 904168506, events = 14862, fd = 562114296, user_data = 0x8218130c8}, {pos = 562114272, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8220e6038}, {pos = 1, events = 1732513366, fd = 571343880, user_data = 0x82af6b388}, {pos = 571365320, events = 8, fd = 0, user_data = 0x0}, {pos = 562114408, events = 8, fd = 562114872, user_data = 0x821812f50}, {pos = 904187042, events = 14862, fd = 2700976, user_data = 0x6d68b}, {pos = 2090263927, events = 1732513366, fd = 571367480, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821813238}, {pos = 571343880, events = 3, fd = 562114944, user_data = 0x8220e5828}, {pos = 656, events = 0, fd = 562114872, user_data = 0x821812f68}, {pos = 562114512, events = 8, fd = 904186651, user_data = 0x821813100}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 571367480, events = 8, fd = 1, user_data = 0x8220e0408}, {pos = 720779352, events = 8, fd = 562115128, user_data = 0x821813180}, {pos = 562114528, events = 8, fd = 0, user_data = 0x8220d9008}, {pos = 33, events = 0, fd = 562114928, user_data = 0x3a0e35e46ae7}, {pos = 571314184, events = 8, fd = 571315208, user_data = 0x8220d9808}, {pos = 571317256, events = 8, fd = 571330568, user_data = 0x8220dd408}, {pos = 571332616, events = 8, fd = 571333640, user_data = 0x8220de008}, {pos = 571335688, events = 8, fd = 571336712, user_data = 0x8220dec08}, {pos = 571338760, events = 8, fd = 571339784, user_data = 0x8220df808}, {pos = 571341832, events = 8, fd = 571342856, user_data = 0x8220e0408}, {pos = 571344904, events = 8, fd = 571345928, user_data = 0x8220e1008}, {pos = 571347976, events = 8, fd = 571349000, user_data = 0x8220e1c08}, {pos = 571351048, events = 8, fd = 571352072, user_data = 0x8220e2808}, {pos = 571354120, events = 8, fd = 571359240, user_data = 0x8220e4408}, {pos = 571361288, events = 8, fd = 571362312, user_data = 0x8220e7408}, {pos = 528810000, events = 0, fd = 571314184, user_data = 0x2936b0}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8220e6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 562115128, events = 8, fd = 562114528, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 571367480, user_data = 0x1}, {pos = 571314184, events = 8, fd = 313, user_data = 0x821813220}, {pos = 904160751, events = 14862, fd = 2700976, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 571367480, user_data = 0x1}, {pos = 571343880, events = 8, fd = 915234816, user_data = 0x1}, {pos = 915235220, events = 8, fd = 0, user_data = 0x8218131f0}, {pos = 716649836, events = 8, fd = 1, user_data = 0x8368d6000}, {pos = 562115104, events = 8, fd = 716646146, user_data = 0x82b095170 }, {pos = 12300000, events = 0, fd = 722030960, user_data = 0x8220e0408}, {pos = 562115328, events = 8, fd = 904160222, user_data = 0x8368f4800}, {pos = 1, events = 0, fd = 904159838, user_data = 0x8220d9008}, {pos = 562115112, events = 8, fd = 562115328, user_data = 0x1c20}, {pos = 915303456, events = 8, fd = 904239504, user_data = 0x0}, {pos = 562103167, events = 8, fd = 8104951, user_data = 0x8218132b0}, {pos = 716608528, events = 8, fd = 722694192, user_data = 0x82b139310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8218132e0}, {pos = 716651421, events = 8, fd = 915234816, user_data = 0x366f}, {pos = 562115392, events = 8, fd = 716617978, user_data = 0x0}, {pos = 0, events = 0, fd = -1050678257, user_data = 0x0}} [03:51:16.085] last_touch_time = 1726890441 [03:51:16.085] last_lockfile_recheck_time = 1726890441 [03:51:16.085] nevents = 1 [03:51:16.085] #22 0x000000000088cab5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821813920) at ../src/backend/postmaster/postmaster.c:1346 [03:51:16.085] userDoption = [03:51:16.085] listen_addr_saved = [03:51:16.085] output_config_variable = [03:51:16.085] opt = [03:51:16.085] status = [03:51:16.085] #23 0x00000000007c78dc in main (argc=4, argv=0x821813920) at ../src/backend/main/main.c:197 [03:51:16.085] do_check_root =