[23:43:15.348] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [23:43:15.734] dumping /tmp/cores/postgres.10832.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:43:15.880] [New LWP 101903] [23:43:15.978] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [23:43:15.978] Program terminated with signal SIGABRT, Aborted. [23:43:15.978] Sent by thr_kill() from pid 10832 and user 1003. [23:43:15.978] #0 0x000000082b8ca41a in thr_kill () from /lib/libc.so.7 [23:43:16.034] [23:43:16.034] Thread 1 (LWP 101903): [23:43:16.034] #0 0x000000082b8ca41a in thr_kill () from /lib/libc.so.7 [23:43:16.034] No symbol table info available. [23:43:16.034] #1 0x000000082b843e64 in raise () from /lib/libc.so.7 [23:43:16.034] No symbol table info available. [23:43:16.034] #2 0x000000082b8f46f9 in abort () from /lib/libc.so.7 [23:43:16.034] No symbol table info available. [23:43:16.034] #3 0x0000000000a96615 in ExceptionalCondition (conditionName=0x2e7bd6 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [23:43:16.034] No locals. [23:43:16.034] #4 0x0000000000767069 in standard_ExecutorStart (queryDesc=0x83577b088, eflags=0) at ../src/backend/executor/execMain.c:194 [23:43:16.034] estate = 0x835835100 [23:43:16.034] oldcontext = 0x835877800 [23:43:16.034] #5 0x00000000006fdd85 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [23:43:16.034] copied_query = [23:43:16.034] rewritten = [23:43:16.034] plan = 0x835799bd8 [23:43:16.034] queryDesc = 0x83577b088 [23:43:16.034] processed = [23:43:16.034] __error = [23:43:16.034] #6 RefreshMatViewByOid (matviewOid=27525, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [23:43:16.034] dest = [23:43:16.034] save_userid = 10 [23:43:16.034] save_sec_context = 0 [23:43:16.034] processed = 0 [23:43:16.034] matviewRel = 0x844306ac8 [23:43:16.034] relowner = 10 [23:43:16.034] save_nestlevel = 2 [23:43:16.034] rule = [23:43:16.034] actions = [23:43:16.034] dataQuery = [23:43:16.034] tableSpace = [23:43:16.034] relpersistence = [23:43:16.034] OIDNewHeap = 27532 [23:43:16.034] address = [23:43:16.034] #7 0x00000000006fd966 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [23:43:16.034] lockmode = [23:43:16.034] matviewOid = 0 [23:43:16.034] #8 0x00000000006d4a7c in ExecCreateTableAs (pstate=pstate@entry=0x835877900, stmt=stmt@entry=0x835796fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8212fed10) at ../src/backend/commands/createas.c:351 [23:43:16.034] refresh = 0x0 [23:43:16.034] query = 0x8357b9198 [23:43:16.034] into = 0x8357b94e0 [23:43:16.034] jstate = 0x0 [23:43:16.034] do_refresh = false [23:43:16.034] address = [23:43:16.034] dest = [23:43:16.034] is_matview = [23:43:16.034] #9 0x0000000000942328 in ProcessUtilitySlow (pstate=pstate@entry=0x835877900, pstmt=pstmt@entry=0x8356dba68, queryString=queryString@entry=0x8356da100 "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=0x8212fed10) at ../src/backend/tcop/utility.c:1675 [23:43:16.034] _local_sigjmp_buf = {{_sjb = {9706329, 0, 34916526392, 34916526768, 34916526400, 12393768, 0, 35257809152, 4294902655, 34916526508, 34916526544, 0}}} [23:43:16.034] _save_exception_stack = 0x8212fec10 [23:43:16.034] _save_context_stack = 0x0 [23:43:16.034] _do_rethrow = false [23:43:16.034] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [23:43:16.034] parsetree = 0x835796fd0 [23:43:16.034] commandCollected = false [23:43:16.034] needCleanup = false [23:43:16.034] address = [23:43:16.034] isTopLevel = [23:43:16.034] isCompleteQuery = [23:43:16.034] #10 0x0000000000940ca8 in standard_ProcessUtility (pstmt=0x8356dba68, queryString=0x8356da100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8357b99c8, qc=0x8212fed10) at ../src/backend/tcop/utility.c:1030 [23:43:16.034] isAtomicContext = false [23:43:16.034] parsetree = 0x835796fd0 [23:43:16.034] readonly_flags = [23:43:16.034] pstate = 0x835877900 [23:43:16.034] isTopLevel = [23:43:16.034] #11 0x0000000000940738 in ProcessUtility (pstmt=0x18e0f, queryString=0x6 , readOnlyTree=, context=730637306, params=0x0, queryEnv=0x0, dest=0x8357b99c8, qc=0x8212fed10) at ../src/backend/tcop/utility.c:523 [23:43:16.034] No locals. [23:43:16.034] #12 0x0000000000940273 in PortalRunUtility (portal=0x8357b1100, pstmt=0x8356dba68, isTopLevel=, setHoldSnapshot=, dest=0x8357b99c8, qc=0x8212fed10) at ../src/backend/tcop/pquery.c:1158 [23:43:16.034] No locals. [23:43:16.034] #13 0x000000000093f904 in PortalRunMulti (portal=portal@entry=0x8357b1100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8357b99c8, altdest=altdest@entry=0x8357b99c8, qc=0x8212fed10) at ../src/backend/tcop/pquery.c:1323 [23:43:16.034] pstmt = 0x8356dba68 [23:43:16.034] stmtlist_item__state = {l = 0x8357b9978, i = 0} [23:43:16.034] active_snapshot_set = false [23:43:16.034] stmtlist_item = 0x8357b9990 [23:43:16.034] #14 0x000000000093f1d3 in PortalRun (portal=portal@entry=0x8357b1100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8357b99c8, altdest=altdest@entry=0x8357b99c8, qc=0x8212fed10) at ../src/backend/tcop/pquery.c:791 [23:43:16.034] _local_sigjmp_buf = {{_sjb = {9695565, 35256996096, 34916527112, 34916527344, 34916527120, 35257012224, 12360376, 12393768, 35256992639, 35256882576, 4294967984, 0}}} [23:43:16.034] _save_exception_stack = 0x8212fede0 [23:43:16.034] _save_context_stack = 0x0 [23:43:16.034] _do_rethrow = false [23:43:16.034] saveTopTransactionResourceOwner = 0x8357c2718 [23:43:16.034] saveTopTransactionContext = 0x8357b5000 [23:43:16.034] saveActivePortal = 0x0 [23:43:16.034] saveResourceOwner = 0x8357c2718 [23:43:16.034] savePortalContext = 0x0 [23:43:16.034] saveMemoryContext = 0x8357b5000 [23:43:16.034] result = [23:43:16.034] nprocessed = [23:43:16.034] #15 0x000000000093e072 in exec_simple_query (query_string=query_string@entry=0x8356da100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [23:43:16.034] cmdtaglen = 24 [23:43:16.034] snapshot_set = [23:43:16.034] per_parsetree_context = 0x0 [23:43:16.034] plantree_list = [23:43:16.034] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:43:16.034] format = 0 [23:43:16.034] parsetree = 0x8356db6a8 [23:43:16.034] commandTag = [23:43:16.034] cmdtagname = [23:43:16.034] querytree_list = [23:43:16.034] portal = 0x8357b1100 [23:43:16.034] receiver = 0x8357b99c8 [23:43:16.034] parsetree_item__state = {l = 0x8356dba18, i = 0} [23:43:16.034] msec_str = "\000\000\000\000\b", '\000' , "\225\t(g\000\000\000\000\262\034 \006a[\202\247" [23:43:16.034] dest = DestRemote [23:43:16.034] was_logged = [23:43:16.034] oldcontext = 0x8357b5000 [23:43:16.034] parsetree_list = 0x8356dba18 [23:43:16.034] use_implicit_block = false [23:43:16.034] parsetree_item = 0x8356dba30 [23:43:16.034] save_log_statement_stats = [23:43:16.034] #16 0x000000000093bce3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [23:43:16.034] query_string = 0x8356da100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [23:43:16.034] input_message = {data = 0x8356da100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [23:43:16.034] firstchar = [23:43:16.034] local_sigjmp_buf = {{_sjb = {9679254, 34916527584, 34916527544, 34916528128, 12402504, 1, 8192, 8388608, 34916467583, 0, 0, 1}}} [23:43:16.034] send_ready_for_query = false [23:43:16.034] idle_in_transaction_timeout_enabled = false [23:43:16.034] idle_session_timeout_enabled = false [23:43:16.034] #17 0x00000000009364c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [23:43:16.034] bsdata = [23:43:16.034] #18 0x000000000088e177 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8212ffb24 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8212ffa60) at ../src/backend/postmaster/launch_backend.c:266 [23:43:16.034] pid = [23:43:16.034] #19 0x0000000000892548 in BackendStartup (client_sock=0x8212ffa60) at ../src/backend/postmaster/postmaster.c:3417 [23:43:16.034] startup_data = {canAcceptConnections = CAC_OK} [23:43:16.034] bn = 0x8356e6088 [23:43:16.034] pid = [23:43:16.034] __error = [23:43:16.034] save_errno = [23:43:16.034] __error = [23:43:16.034] __error = [23:43:16.034] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [23:43:16.034] 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\277m5\b", '\000' , "\300\372/!\b\000\000\000h\345j+\b\000\000\000\v\000\000\000\000\000\000\000^ok+\b", '\000' , "\373/!\b\000\000\000$߈\000\000\000\000\000\020\373/!\b", '\000' }, salen = 16}} [23:43:16.034] i = 0 [23:43:16.034] now = [23:43:16.034] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 730262658, events = 8, fd = 0, user_data = 0x8212ffa10}, {pos = 896755160, events = 8, fd = 556791968, user_data = 0x0}, {pos = 0, events = 0, fd = -876821950, user_data = 0x2abd664de30a}, {pos = 729429920, events = 8, fd = 729501048, user_data = 0x8212ff528}, {pos = 556791200, events = 8, fd = 556791080, user_data = 0x2abd664de30a}, {pos = 729408392, events = 8, fd = 729501048, user_data = 0x8212ff558}, {pos = 556791248, events = 8, fd = 556791128, user_data = 0x82b7ad194}, {pos = 558113800, events = 8, fd = 729469332, user_data = 0x8212ff5c0}, {pos = 1716360250, events = 10941, fd = 731291696, user_data = 0x1}, {pos = 556791280, events = 8, fd = 1716380426, user_data = 0x82b796858}, {pos = 729501048, events = 8, fd = 556791240, user_data = 0x8212ff640}, {pos = 556791240, events = 8, fd = 729464076, user_data = 0x821442408}, {pos = 729464076, events = 8, fd = 556791344, user_data = 0x2abd664d943a}, {pos = 556791384, events = 8, fd = 556791832, user_data = 0x8212ff640}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 943159631, fd = 558137400, user_data = 0x800000001}, {pos = 558113800, events = 8, fd = 729408392, user_data = 0x821447288}, {pos = 729376856, events = 8, fd = 558113800, user_data = 0x8212ff6c8}, {pos = 556791944, events = 8, fd = 556791472, user_data = 0x2abd664ddca2}, {pos = 2702763, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 558137400, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 556792200, user_data = 0x21442408}, {pos = 556792016, events = 8, fd = 556791616, user_data = 0x1}, {pos = 556791944, events = 8, fd = 32, user_data = 0x8212ff730}, {pos = 1716378227, events = 10941, fd = 556791888, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821448038}, {pos = 1, events = 8, fd = 558113800, user_data = 0x82b796858}, {pos = 556792200, events = 8, fd = 556792016, user_data = 0x8212ff740}, {pos = 0, events = 0, fd = 558084104, user_data = 0x20}, {pos = 556792000, events = 8, fd = 1716353767, user_data = 0x82143b008}, {pos = 558085128, events = 8, fd = 558086152, user_data = 0x82143bc08}, {pos = 558100488, events = 8, fd = 558101512, user_data = 0x82143f808}, {pos = 558103560, events = 8, fd = 558104584, user_data = 0x821440408}, {pos = 558106632, events = 8, fd = 558107656, user_data = 0x821441008}, {pos = 558109704, events = 8, fd = 558110728, user_data = 0x821441c08}, {pos = 558112776, events = 8, fd = 558113800, user_data = 0x821442808}, {pos = 558115848, events = 8, fd = 558116872, user_data = 0x821443408}, {pos = 558118920, events = 8, fd = 558119944, user_data = 0x821444008}, {pos = 558121992, events = 8, fd = 558123016, user_data = 0x821444c08}, {pos = 558129160, events = 8, fd = 558130184, user_data = 0x821446808}, {pos = 558132232, events = 8, fd = 558084104, user_data = 0x293dab}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821448038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556792200, events = 8, fd = 556791616, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 558137400, user_data = 0x1}, {pos = 558084104, events = 8, fd = 298, user_data = 0x8212ff970}, {pos = 1716352495, events = 10941, fd = 2702763, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 558137400, user_data = 0x1}, {pos = 558113800, events = 8, fd = 896311296, user_data = 0x1}, {pos = 896311700, events = 8, fd = 0, user_data = 0x8212ff940}, {pos = 728458604, events = 8, fd = 1, user_data = 0x8356ca000}, {pos = 556792176, events = 8, fd = 728454914, user_data = 0x82b8c8170 }, {pos = 12323352, events = 0, fd = 730628464, user_data = 0x821442408}, {pos = 556792400, events = 8, fd = 1716351966, user_data = 0x8356e8800}, {pos = 1, events = 0, fd = 1716351582, user_data = 0x82143b008}, {pos = 556792184, events = 8, fd = 556792400, user_data = 0x1ab8}, {pos = 896384768, events = 8, fd = 1716431248, user_data = 0x0}, {pos = 556729215, events = 8, fd = 8116119, user_data = 0x8212ffa00}, {pos = 728417296, events = 8, fd = 731291696, user_data = 0x82b96c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8212ffa30}, {pos = 728460189, events = 8, fd = 896311296, user_data = 0x1dc7}, {pos = 556792464, events = 8, fd = 728426746, user_data = 0x0}, {pos = 0, events = 0, fd = -876821950, user_data = 0x0}} [23:43:16.035] last_touch_time = 1730677121 [23:43:16.035] last_lockfile_recheck_time = 1730677121 [23:43:16.035] nevents = 1 [23:43:16.035] #21 0x0000000000890365 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821300078) at ../src/backend/postmaster/postmaster.c:1348 [23:43:16.035] userDoption = [23:43:16.035] listen_addr_saved = [23:43:16.035] output_config_variable = [23:43:16.035] opt = [23:43:16.035] status = [23:43:16.035] #22 0x00000000007ca41c in main (argc=8, argv=0x821300078) at ../src/backend/main/main.c:196 [23:43:16.035] do_check_root = [23:43:16.044] [23:43:16.044] [23:43:16.044] [23:43:16.108] dumping /tmp/cores/postgres.11204.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:43:16.233] [New LWP 100135] [23:43:16.300] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [23:43:16.300] Program terminated with signal SIGABRT, Aborted. [23:43:16.300] Sent by thr_kill() from pid 11204 and user 1003. [23:43:16.300] #0 0x000000082d0c341a in thr_kill () from /lib/libc.so.7 [23:43:16.336] [23:43:16.336] Thread 1 (LWP 100135): [23:43:16.336] #0 0x000000082d0c341a in thr_kill () from /lib/libc.so.7 [23:43:16.336] No symbol table info available. [23:43:16.336] #1 0x000000082d03ce64 in raise () from /lib/libc.so.7 [23:43:16.336] No symbol table info available. [23:43:16.336] #2 0x000000082d0ed6f9 in abort () from /lib/libc.so.7 [23:43:16.336] No symbol table info available. [23:43:16.336] #3 0x0000000000a96615 in ExceptionalCondition (conditionName=0x2e7bd6 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [23:43:16.336] No locals. [23:43:16.336] #4 0x0000000000767069 in standard_ExecutorStart (queryDesc=0x8365e0088, eflags=0) at ../src/backend/executor/execMain.c:194 [23:43:16.336] estate = 0x8366ff100 [23:43:16.336] oldcontext = 0x83673b800 [23:43:16.336] #5 0x00000000006fdd85 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [23:43:16.336] copied_query = [23:43:16.336] rewritten = [23:43:16.336] plan = 0x836645bd8 [23:43:16.336] queryDesc = 0x8365e0088 [23:43:16.336] processed = [23:43:16.336] __error = [23:43:16.336] #6 RefreshMatViewByOid (matviewOid=27422, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [23:43:16.336] dest = [23:43:16.336] save_userid = 10 [23:43:16.336] save_sec_context = 0 [23:43:16.336] processed = 0 [23:43:16.336] matviewRel = 0x8395057c0 [23:43:16.336] relowner = 10 [23:43:16.336] save_nestlevel = 2 [23:43:16.336] rule = [23:43:16.336] actions = [23:43:16.336] dataQuery = [23:43:16.336] tableSpace = [23:43:16.336] relpersistence = [23:43:16.336] OIDNewHeap = 27429 [23:43:16.336] address = [23:43:16.336] #7 0x00000000006fd966 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [23:43:16.336] lockmode = [23:43:16.336] matviewOid = 0 [23:43:16.336] #8 0x00000000006d4a7c in ExecCreateTableAs (pstate=pstate@entry=0x83673b900, stmt=stmt@entry=0x836648fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82120b760) at ../src/backend/commands/createas.c:351 [23:43:16.336] refresh = 0x0 [23:43:16.336] query = 0x836651158 [23:43:16.336] into = 0x8366514a0 [23:43:16.336] jstate = 0x0 [23:43:16.336] do_refresh = false [23:43:16.336] address = [23:43:16.336] dest = [23:43:16.336] is_matview = [23:43:16.336] #9 0x0000000000942328 in ProcessUtilitySlow (pstate=pstate@entry=0x83673b900, pstmt=pstmt@entry=0x836569a68, queryString=queryString@entry=0x836568100 "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=0x82120b760) at ../src/backend/tcop/utility.c:1675 [23:43:16.336] _local_sigjmp_buf = {{_sjb = {9706329, 0, 34915529608, 34915529984, 34915529616, 12393768, 0, 35273292032, 4294902655, 34915529724, 34915529760, 0}}} [23:43:16.336] _save_exception_stack = 0x82120b660 [23:43:16.336] _save_context_stack = 0x0 [23:43:16.336] _do_rethrow = false [23:43:16.336] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [23:43:16.336] parsetree = 0x836648fd0 [23:43:16.336] commandCollected = false [23:43:16.336] needCleanup = false [23:43:16.336] address = [23:43:16.336] isTopLevel = [23:43:16.336] isCompleteQuery = [23:43:16.336] #10 0x0000000000940ca8 in standard_ProcessUtility (pstmt=0x836569a68, queryString=0x836568100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836651988, qc=0x82120b760) at ../src/backend/tcop/utility.c:1030 [23:43:16.336] isAtomicContext = false [23:43:16.336] parsetree = 0x836648fd0 [23:43:16.336] readonly_flags = [23:43:16.336] pstate = 0x83673b900 [23:43:16.336] isTopLevel = [23:43:16.336] #11 0x0000000000940738 in ProcessUtility (pstmt=0x18727, queryString=0x6 , readOnlyTree=, context=755774458, params=0x0, queryEnv=0x0, dest=0x836651988, qc=0x82120b760) at ../src/backend/tcop/utility.c:523 [23:43:16.336] No locals. [23:43:16.336] #12 0x0000000000940273 in PortalRunUtility (portal=0x83660e100, pstmt=0x836569a68, isTopLevel=, setHoldSnapshot=, dest=0x836651988, qc=0x82120b760) at ../src/backend/tcop/pquery.c:1158 [23:43:16.336] No locals. [23:43:16.336] #13 0x000000000093f904 in PortalRunMulti (portal=portal@entry=0x83660e100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x836651988, altdest=altdest@entry=0x836651988, qc=0x82120b760) at ../src/backend/tcop/pquery.c:1323 [23:43:16.336] pstmt = 0x836569a68 [23:43:16.336] stmtlist_item__state = {l = 0x836651938, i = 0} [23:43:16.336] active_snapshot_set = false [23:43:16.336] stmtlist_item = 0x836651950 [23:43:16.336] #14 0x000000000093f1d3 in PortalRun (portal=portal@entry=0x83660e100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x836651988, altdest=altdest@entry=0x836651988, qc=0x82120b760) at ../src/backend/tcop/pquery.c:791 [23:43:16.336] _local_sigjmp_buf = {{_sjb = {9695565, 35272057088, 34915530328, 34915530560, 34915530336, 35272073216, 12360376, 12393768, 35272065919, 35272291728, 4294967984, 0}}} [23:43:16.336] _save_exception_stack = 0x82120b830 [23:43:16.336] _save_context_stack = 0x0 [23:43:16.336] _do_rethrow = false [23:43:16.336] saveTopTransactionResourceOwner = 0x83665d498 [23:43:16.336] saveTopTransactionContext = 0x836612000 [23:43:16.336] saveActivePortal = 0x0 [23:43:16.336] saveResourceOwner = 0x83665d498 [23:43:16.336] savePortalContext = 0x0 [23:43:16.336] saveMemoryContext = 0x836612000 [23:43:16.336] result = [23:43:16.336] nprocessed = [23:43:16.336] #15 0x000000000093e072 in exec_simple_query (query_string=query_string@entry=0x836568100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [23:43:16.336] cmdtaglen = 24 [23:43:16.336] snapshot_set = [23:43:16.336] per_parsetree_context = 0x0 [23:43:16.336] plantree_list = [23:43:16.336] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:43:16.336] format = 0 [23:43:16.336] parsetree = 0x8365696a8 [23:43:16.336] commandTag = [23:43:16.336] cmdtagname = [23:43:16.336] querytree_list = [23:43:16.336] portal = 0x83660e100 [23:43:16.336] receiver = 0x836651988 [23:43:16.336] parsetree_item__state = {l = 0x836569a18, i = 0} [23:43:16.336] msec_str = "\000\000\000\000\b", '\000' , "\230\t(g\000\000\000\000\374d8\275\254\021\315\027" [23:43:16.336] dest = DestRemote [23:43:16.336] was_logged = [23:43:16.336] oldcontext = 0x836612000 [23:43:16.336] parsetree_list = 0x836569a18 [23:43:16.336] use_implicit_block = false [23:43:16.336] parsetree_item = 0x836569a30 [23:43:16.336] save_log_statement_stats = [23:43:16.336] #16 0x000000000093bce3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [23:43:16.336] query_string = 0x836568100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [23:43:16.336] input_message = {data = 0x836568100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [23:43:16.336] firstchar = [23:43:16.336] local_sigjmp_buf = {{_sjb = {9679254, 34915530800, 34915530760, 34915531344, 12402504, 1, 8192, 8388608, 34915484543, 0, 0, 1}}} [23:43:16.336] send_ready_for_query = false [23:43:16.336] idle_in_transaction_timeout_enabled = false [23:43:16.336] idle_session_timeout_enabled = false [23:43:16.336] #17 0x00000000009364c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [23:43:16.336] bsdata = [23:43:16.336] #18 0x000000000088e177 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82120c574 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82120c4b0) at ../src/backend/postmaster/launch_backend.c:266 [23:43:16.336] pid = [23:43:16.336] #19 0x0000000000892548 in BackendStartup (client_sock=0x82120c4b0) at ../src/backend/postmaster/postmaster.c:3417 [23:43:16.336] startup_data = {canAcceptConnections = CAC_OK} [23:43:16.336] bn = 0x836574218 [23:43:16.336] pid = [23:43:16.336] __error = [23:43:16.336] save_errno = [23:43:16.336] __error = [23:43:16.336] __error = [23:43:16.336] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [23:43:16.336] 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\236V6\b", '\000' , "\020\305 !\b\000\000\000h\005~,\b\000\000\000\v\000\000\000\000\000\000\000^\217~,\b", '\000' , "P\305 !\b\000\000\000$߈\000\000\000\000\000`\305 !\b", '\000' }, salen = 16}} [23:43:16.336] i = 0 [23:43:16.336] now = [23:43:16.336] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 755399810, events = 8, fd = 0, user_data = 0x82120c460}, {pos = 912074200, events = 8, fd = 555795184, user_data = 0x0}, {pos = 0, events = 0, fd = -1453516194, user_data = 0x31a9c5b6630a}, {pos = 754567072, events = 8, fd = 754638200, user_data = 0x82120bf78}, {pos = 555794416, events = 8, fd = 555794296, user_data = 0x31a9c5b6630a}, {pos = 754545544, events = 8, fd = 754638200, user_data = 0x82120bfa8}, {pos = 555794464, events = 8, fd = 555794344, user_data = 0x82cfa6194}, {pos = 557417480, events = 8, fd = 754606484, user_data = 0x82120c010}, {pos = -977923014, events = 12713, fd = 756428848, user_data = 0x1}, {pos = 555794496, events = 8, fd = -977902838, user_data = 0x82cf8f858}, {pos = 754638200, events = 8, fd = 555794456, user_data = 0x82120c090}, {pos = 555794456, events = 8, fd = 754601228, user_data = 0x821398408}, {pos = 754601228, events = 8, fd = 555794560, user_data = 0x31a9c5b6143a}, {pos = 555794600, events = 8, fd = 555795048, user_data = 0x82120c090}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 436914921, fd = 557441080, user_data = 0x800000001}, {pos = 557417480, events = 8, fd = 754545544, user_data = 0x82139d288}, {pos = 754514008, events = 8, fd = 557417480, user_data = 0x82120c118}, {pos = 555795160, events = 8, fd = 555794688, user_data = 0x31a9c5b65ca2}, {pos = 2702763, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 557441080, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 555795416, user_data = 0x21398408}, {pos = 555795232, events = 8, fd = 555794832, user_data = 0x1}, {pos = 555795160, events = 8, fd = 32, user_data = 0x82120c180}, {pos = -977905037, events = 12713, fd = 555795104, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82139e038}, {pos = 1, events = 8, fd = 557417480, user_data = 0x82cf8f858}, {pos = 555795416, events = 8, fd = 555795232, user_data = 0x82120c190}, {pos = 0, events = 0, fd = 557387784, user_data = 0x20}, {pos = 555795216, events = 8, fd = -977929497, user_data = 0x821391008}, {pos = 557388808, events = 8, fd = 557389832, user_data = 0x821391c08}, {pos = 557404168, events = 8, fd = 557405192, user_data = 0x821395808}, {pos = 557407240, events = 8, fd = 557408264, user_data = 0x821396408}, {pos = 557410312, events = 8, fd = 557411336, user_data = 0x821397008}, {pos = 557413384, events = 8, fd = 557414408, user_data = 0x821397c08}, {pos = 557416456, events = 8, fd = 557417480, user_data = 0x821398808}, {pos = 557419528, events = 8, fd = 557420552, user_data = 0x821399408}, {pos = 557422600, events = 8, fd = 557423624, user_data = 0x82139a008}, {pos = 557425672, events = 8, fd = 557426696, user_data = 0x82139ac08}, {pos = 557432840, events = 8, fd = 557433864, user_data = 0x82139c808}, {pos = 557435912, events = 8, fd = 557387784, user_data = 0x293dab}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82139e038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555795416, events = 8, fd = 555794832, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 557441080, user_data = 0x1}, {pos = 557387784, events = 8, fd = 298, user_data = 0x82120c3c0}, {pos = -977930769, events = 12713, fd = 2702763, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 557441080, user_data = 0x1}, {pos = 557417480, events = 8, fd = 911572992, user_data = 0x1}, {pos = 911573396, events = 8, fd = 0, user_data = 0x82120c390}, {pos = 746489196, events = 8, fd = 1, user_data = 0x836558000}, {pos = 555795392, events = 8, fd = 746485506, user_data = 0x82d0c1170 }, {pos = 12323352, events = 0, fd = 755765616, user_data = 0x821398408}, {pos = 555795616, events = 8, fd = -977931298, user_data = 0x836576800}, {pos = 1, events = 0, fd = -977931682, user_data = 0x821391008}, {pos = 555795400, events = 8, fd = 555795616, user_data = 0x1ab8}, {pos = 911646400, events = 8, fd = -977852016, user_data = 0x0}, {pos = 555746175, events = 8, fd = 8116119, user_data = 0x82120c450}, {pos = 746447888, events = 8, fd = 756428848, user_data = 0x82d165310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82120c480}, {pos = 746490781, events = 8, fd = 911572992, user_data = 0x1e31}, {pos = 555795680, events = 8, fd = 746457338, user_data = 0x0}, {pos = 0, events = 0, fd = -1453516194, user_data = 0x0}} [23:43:16.336] last_touch_time = 1730677121 [23:43:16.336] last_lockfile_recheck_time = 1730677121 [23:43:16.336] nevents = 1 [23:43:16.336] #21 0x0000000000890365 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82120cac0) at ../src/backend/postmaster/postmaster.c:1348 [23:43:16.336] userDoption = [23:43:16.336] listen_addr_saved = [23:43:16.336] output_config_variable = [23:43:16.336] opt = [23:43:16.336] status = [23:43:16.336] #22 0x00000000007ca41c in main (argc=4, argv=0x82120cac0) at ../src/backend/main/main.c:196 [23:43:16.336] do_check_root = [23:43:16.346] [23:43:16.346] [23:43:16.346] [23:43:16.411] dumping /tmp/cores/postgres.17675.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:43:16.539] [New LWP 100095] [23:43:16.614] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [23:43:16.614] Program terminated with signal SIGABRT, Aborted. [23:43:16.614] Sent by thr_kill() from pid 17675 and user 1003. [23:43:16.614] #0 0x00000008294ab41a in thr_kill () from /lib/libc.so.7 [23:43:16.658] [23:43:16.658] Thread 1 (LWP 100095): [23:43:16.658] #0 0x00000008294ab41a in thr_kill () from /lib/libc.so.7 [23:43:16.658] No symbol table info available. [23:43:16.658] #1 0x0000000829424e64 in raise () from /lib/libc.so.7 [23:43:16.658] No symbol table info available. [23:43:16.658] #2 0x00000008294d56f9 in abort () from /lib/libc.so.7 [23:43:16.658] No symbol table info available. [23:43:16.658] #3 0x0000000000a96615 in ExceptionalCondition (conditionName=0x2e7bd6 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [23:43:16.658] No locals. [23:43:16.658] #4 0x0000000000767069 in standard_ExecutorStart (queryDesc=0x833e7a088, eflags=0) at ../src/backend/executor/execMain.c:194 [23:43:16.658] estate = 0x833e2b100 [23:43:16.658] oldcontext = 0x833e8c800 [23:43:16.658] #5 0x00000008377139c2 in pgss_ExecutorStart (queryDesc=0x833e7a088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [23:43:16.658] No locals. [23:43:16.658] #6 0x00000000006fdd85 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [23:43:16.658] copied_query = [23:43:16.658] rewritten = [23:43:16.658] plan = 0x833e71bd8 [23:43:16.658] queryDesc = 0x833e7a088 [23:43:16.658] processed = [23:43:16.658] __error = [23:43:16.658] #7 RefreshMatViewByOid (matviewOid=27398, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [23:43:16.658] dest = [23:43:16.658] save_userid = 10 [23:43:16.658] save_sec_context = 0 [23:43:16.658] processed = 0 [23:43:16.658] matviewRel = 0x83b0d6048 [23:43:16.658] relowner = 10 [23:43:16.658] save_nestlevel = 2 [23:43:16.658] rule = [23:43:16.658] actions = [23:43:16.658] dataQuery = [23:43:16.658] tableSpace = [23:43:16.658] relpersistence = [23:43:16.658] OIDNewHeap = 27405 [23:43:16.658] address = [23:43:16.658] #8 0x00000000006fd966 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [23:43:16.658] lockmode = [23:43:16.658] matviewOid = 0 [23:43:16.658] #9 0x00000000006d4a7c in ExecCreateTableAs (pstate=pstate@entry=0x833e8c900, stmt=stmt@entry=0x833d88fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8210e4cb0) at ../src/backend/commands/createas.c:351 [23:43:16.658] refresh = 0x0 [23:43:16.658] query = 0x833dd3ac8 [23:43:16.658] into = 0x833d88f40 [23:43:16.658] jstate = 0x0 [23:43:16.658] do_refresh = false [23:43:16.658] address = [23:43:16.658] dest = [23:43:16.658] is_matview = [23:43:16.658] #10 0x0000000000942328 in ProcessUtilitySlow (pstate=pstate@entry=0x833e8c900, pstmt=pstmt@entry=0x833d88e30, queryString=queryString@entry=0x833ceb100 "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=0x8210e4cb0) at ../src/backend/tcop/utility.c:1675 [23:43:16.658] _local_sigjmp_buf = {{_sjb = {9706329, 0, 34914322200, 34914322576, 34914322208, 12393768, 0, 35230632192, 34914304895, 7, 34914322352, 0}}} [23:43:16.658] _save_exception_stack = 0x8210e49a0 [23:43:16.658] _save_context_stack = 0x0 [23:43:16.658] _do_rethrow = false [23:43:16.658] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [23:43:16.658] parsetree = 0x833d88fd0 [23:43:16.658] commandCollected = false [23:43:16.658] needCleanup = false [23:43:16.658] address = [23:43:16.658] isTopLevel = [23:43:16.658] isCompleteQuery = [23:43:16.658] #11 0x0000000000940ca8 in standard_ProcessUtility (pstmt=0x833d88e30, queryString=queryString@entry=0x833ceb100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x833dd4268, qc=0x8210e4cb0) at ../src/backend/tcop/utility.c:1030 [23:43:16.658] isAtomicContext = false [23:43:16.658] parsetree = 0x833d88fd0 [23:43:16.658] readonly_flags = [23:43:16.658] pstate = 0x833e8c900 [23:43:16.658] isTopLevel = [23:43:16.658] #12 0x0000000837713f7e in pgss_ProcessUtility (pstmt=0x833d88e30, queryString=0x833ceb100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x833dd4268, qc=0x8210e4cb0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [23:43:16.658] _local_sigjmp_buf = {{_sjb = {35289906871, 34914322848, 34914322712, 34914323168, 35229568560, 0, 12393768, 34914323376, 34914304895, 34914322948, 34914322976, 0}}} [23:43:16.658] _save_exception_stack = 0x8210e4bb0 [23:43:16.658] _save_context_stack = 0x0 [23:43:16.658] _do_rethrow = false [23:43:16.658] bufusage = {shared_blks_hit = 35289906871, shared_blks_read = 34914322848, shared_blks_dirtied = 34914322712, shared_blks_written = 34914323168, local_blks_hit = 35229568560, local_blks_read = 0, local_blks_dirtied = 12393768, local_blks_written = 34914323376, temp_blks_read = 34914304895, temp_blks_written = 34914322948, shared_blk_read_time = {ticks = 34914322976}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4061152855063210240}, local_blk_write_time = {ticks = 12402808}, temp_blk_read_time = {ticks = 35309484160}, temp_blk_write_time = {ticks = 12356320}} [23:43:16.658] walusage_start = {wal_records = 8939, wal_fpi = 147, wal_bytes = 1362342} [23:43:16.658] duration = [23:43:16.658] bufusage_start = {shared_blks_hit = 152378, shared_blks_read = 8934, shared_blks_dirtied = 2746, shared_blks_written = 2514, 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}} [23:43:16.658] walusage = {wal_records = -7802903288808089094, wal_fpi = 35229568976, wal_bytes = 123} [23:43:16.658] start = {ticks = -185566763684} [23:43:16.658] rows = [23:43:16.658] saved_queryId = 6041762721901209185 [23:43:16.658] parsetree = [23:43:16.658] saved_stmt_location = 0 [23:43:16.658] saved_stmt_len = 69 [23:43:16.658] enabled = [23:43:16.658] #13 0x0000000000940273 in PortalRunUtility (portal=0x833d93100, pstmt=0x833d88e30, isTopLevel=, setHoldSnapshot=, dest=0x833dd4268, qc=0x8210e4cb0) at ../src/backend/tcop/pquery.c:1158 [23:43:16.658] No locals. [23:43:16.658] #14 0x000000000093f904 in PortalRunMulti (portal=portal@entry=0x833d93100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x833dd4268, altdest=altdest@entry=0x833dd4268, qc=0x8210e4cb0) at ../src/backend/tcop/pquery.c:1323 [23:43:16.658] pstmt = 0x833d88e30 [23:43:16.658] stmtlist_item__state = {l = 0x833dd4218, i = 0} [23:43:16.658] active_snapshot_set = false [23:43:16.658] stmtlist_item = 0x833dd4230 [23:43:16.658] #15 0x000000000093f1d3 in PortalRun (portal=portal@entry=0x833d93100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x833dd4268, altdest=altdest@entry=0x833dd4268, qc=0x8210e4cb0) at ../src/backend/tcop/pquery.c:791 [23:43:16.658] _local_sigjmp_buf = {{_sjb = {9695565, 35229610240, 34914323368, 34914323600, 34914323376, 35229704192, 12360376, 12393768, 35229598591, 35229562336, 4294967984, 0}}} [23:43:16.658] _save_exception_stack = 0x8210e4d80 [23:43:16.658] _save_context_stack = 0x0 [23:43:16.658] _do_rethrow = false [23:43:16.658] saveTopTransactionResourceOwner = 0x833de1418 [23:43:16.658] saveTopTransactionContext = 0x833daa000 [23:43:16.658] saveActivePortal = 0x0 [23:43:16.658] saveResourceOwner = 0x833de1418 [23:43:16.658] savePortalContext = 0x0 [23:43:16.658] saveMemoryContext = 0x833daa000 [23:43:16.658] result = [23:43:16.658] nprocessed = [23:43:16.658] #16 0x000000000093e072 in exec_simple_query (query_string=query_string@entry=0x833ceb100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [23:43:16.658] cmdtaglen = 24 [23:43:16.658] snapshot_set = [23:43:16.658] per_parsetree_context = 0x0 [23:43:16.658] plantree_list = [23:43:16.658] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:43:16.658] format = 0 [23:43:16.658] parsetree = 0x833cec6a8 [23:43:16.658] commandTag = [23:43:16.658] cmdtagname = [23:43:16.658] querytree_list = [23:43:16.658] portal = 0x833d93100 [23:43:16.658] receiver = 0x833dd4268 [23:43:16.658] parsetree_item__state = {l = 0x833ceca18, i = 0} [23:43:16.658] msec_str = "\000\000\000\000\b", '\000' , "\275\t(g\000\000\000\000,\315\316\3274L\242;" [23:43:16.658] dest = DestRemote [23:43:16.658] was_logged = [23:43:16.658] oldcontext = 0x833daa000 [23:43:16.658] parsetree_list = 0x833ceca18 [23:43:16.658] use_implicit_block = false [23:43:16.658] parsetree_item = 0x833ceca30 [23:43:16.658] save_log_statement_stats = [23:43:16.658] #17 0x000000000093bce3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [23:43:16.658] query_string = 0x833ceb100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [23:43:16.658] input_message = {data = 0x833ceb100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [23:43:16.658] firstchar = [23:43:16.658] local_sigjmp_buf = {{_sjb = {9679254, 34914323840, 34914323800, 34914324384, 12402504, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [23:43:16.658] send_ready_for_query = false [23:43:16.658] idle_in_transaction_timeout_enabled = false [23:43:16.658] idle_session_timeout_enabled = false [23:43:16.658] #18 0x00000000009364c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [23:43:16.658] bsdata = [23:43:16.658] #19 0x000000000088e177 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8210e5ac4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8210e5a00) at ../src/backend/postmaster/launch_backend.c:266 [23:43:16.658] pid = [23:43:16.658] #20 0x0000000000892548 in BackendStartup (client_sock=0x8210e5a00) at ../src/backend/postmaster/postmaster.c:3417 [23:43:16.658] startup_data = {canAcceptConnections = CAC_OK} [23:43:16.658] bn = 0x833cf7628 [23:43:16.658] pid = [23:43:16.658] __error = [23:43:16.658] save_errno = [23:43:16.658] __error = [23:43:16.658] __error = [23:43:16.658] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [23:43:16.658] 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 = " \274\3163\b", '\000' , "`Z\016!\b\000\000\000h\265\036)\b\000\000\000\v\000\000\000\000\000\000\000^?\037)\b", '\000' , "\240Z\016!\b\000\000\000$߈\000\000\000\000\000\260Z\016!\b", '\000' }, salen = 16}} [23:43:16.658] i = 0 [23:43:16.658] now = [23:43:16.658] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 692386946, events = 8, fd = 0, user_data = 0x8210e59b0}, {pos = 869590488, events = 8, fd = 554588224, user_data = 0x0}, {pos = 1281303306, events = 1569, fd = 691554208, user_data = 0x829395d78}, {pos = 554587320, events = 8, fd = 554587440, user_data = 0x8210e54b8}, {pos = 1281303306, events = 1569, fd = 691532680, user_data = 0x829395d78}, {pos = 554587368, events = 8, fd = 554587488, user_data = 0x8210e54e8}, {pos = 691593620, events = 8, fd = 558097416, user_data = 0x82938e194}, {pos = 554587472, events = 8, fd = 1281283130, user_data = 0x8210e54f0}, {pos = 689869840, events = 8, fd = 693415984, user_data = 0x6214c5f230a}, {pos = 691501144, events = 8, fd = 691625336, user_data = 0x8210e5558}, {pos = 554587600, events = 8, fd = 554587480, user_data = 0x82938cd0c}, {pos = 558097416, events = 8, fd = 691588364, user_data = 0x8210e55c0}, {pos = 1281283130, events = 1569, fd = 554587624, user_data = 0x8210e57b8}, {pos = 554587600, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821444038}, {pos = 1, events = 2478212300, fd = 558097416, user_data = 0x82937f388}, {pos = 558118856, events = 8, fd = 0, user_data = 0x0}, {pos = 554587736, events = 8, fd = 554588200, user_data = 0x8210e5640}, {pos = 1281301666, events = 1569, fd = 2702763, user_data = 0x6d68b}, {pos = 2090263927, events = 2478212300, fd = 558121016, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8210e5928}, {pos = 558097416, events = 3, fd = 554588272, user_data = 0x821443828}, {pos = 656, events = 0, fd = 554588200, user_data = 0x8210e5658}, {pos = 554587840, events = 8, fd = 1281301275, user_data = 0x8210e57f0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 558121016, events = 8, fd = 1, user_data = 0x82143e408}, {pos = 691501144, events = 8, fd = 554588456, user_data = 0x8210e5870}, {pos = 554587856, events = 8, fd = 0, user_data = 0x821437008}, {pos = 33, events = 0, fd = 554588256, user_data = 0x6214c5ebae7}, {pos = 558067720, events = 8, fd = 558068744, user_data = 0x821437808}, {pos = 558070792, events = 8, fd = 558084104, user_data = 0x82143b408}, {pos = 558086152, events = 8, fd = 558087176, user_data = 0x82143c008}, {pos = 558089224, events = 8, fd = 558090248, user_data = 0x82143cc08}, {pos = 558092296, events = 8, fd = 558093320, user_data = 0x82143d808}, {pos = 558095368, events = 8, fd = 558096392, user_data = 0x82143e408}, {pos = 558098440, events = 8, fd = 558099464, user_data = 0x82143f008}, {pos = 558101512, events = 8, fd = 558102536, user_data = 0x82143fc08}, {pos = 558104584, events = 8, fd = 558105608, user_data = 0x821440808}, {pos = 558107656, events = 8, fd = 558112776, user_data = 0x821442408}, {pos = 558114824, events = 8, fd = 558115848, user_data = 0x821445408}, {pos = 2980000, events = 0, fd = 558067720, user_data = 0x293dab}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821444038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554588456, events = 8, fd = 554587856, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 558121016, user_data = 0x1}, {pos = 558067720, events = 8, fd = 298, user_data = 0x8210e5910}, {pos = 1281275375, events = 1569, fd = 2702763, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 558121016, user_data = 0x1}, {pos = 558097416, events = 8, fd = 869117952, user_data = 0x1}, {pos = 869118356, events = 8, fd = 0, user_data = 0x8210e58e0}, {pos = 689911148, events = 8, fd = 1, user_data = 0x833cdb000}, {pos = 554588432, events = 8, fd = 689907458, user_data = 0x8294a9170 }, {pos = 12323352, events = 0, fd = 692752752, user_data = 0x82143e408}, {pos = 554588656, events = 8, fd = 1281274846, user_data = 0x833cf9800}, {pos = 1, events = 0, fd = 1281274462, user_data = 0x821437008}, {pos = 554588440, events = 8, fd = 554588656, user_data = 0x1ab8}, {pos = 869186592, events = 8, fd = 1281354128, user_data = 0x0}, {pos = 554566527, events = 8, fd = 8116119, user_data = 0x8210e59a0}, {pos = 689869840, events = 8, fd = 693415984, user_data = 0x82954d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8210e59d0}, {pos = 689912733, events = 8, fd = 869117952, user_data = 0x3660}, {pos = 554588720, events = 8, fd = 689879290, user_data = 0x0}, {pos = 0, events = 0, fd = -438445574, user_data = 0x0}} [23:43:16.658] last_touch_time = 1730677156 [23:43:16.658] last_lockfile_recheck_time = 1730677156 [23:43:16.658] nevents = 1 [23:43:16.658] #22 0x0000000000890365 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8210e6010) at ../src/backend/postmaster/postmaster.c:1348 [23:43:16.658] userDoption = [23:43:16.658] listen_addr_saved = [23:43:16.658] output_config_variable = [23:43:16.658] opt = [23:43:16.658] status = [23:43:16.658] #23 0x00000000007ca41c in main (argc=4, argv=0x8210e6010) at ../src/backend/main/main.c:196 [23:43:16.658] do_check_root =