[08:33:17.849] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [08:33:18.274] dumping /tmp/cores/postgres.10647.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:33:18.408] [New LWP 101856] [08:33:18.497] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [08:33:18.497] Program terminated with signal SIGABRT, Aborted. [08:33:18.497] Sent by thr_kill() from pid 10647 and user 1003. [08:33:18.497] #0 0x000000082a6c941a in thr_kill () from /lib/libc.so.7 [08:33:19.093] [08:33:19.093] Thread 1 (LWP 101856): [08:33:19.093] #0 0x000000082a6c941a in thr_kill () from /lib/libc.so.7 [08:33:19.093] No symbol table info available. [08:33:19.093] #1 0x000000082a642e64 in raise () from /lib/libc.so.7 [08:33:19.093] No symbol table info available. [08:33:19.093] #2 0x000000082a6f36f9 in abort () from /lib/libc.so.7 [08:33:19.093] No symbol table info available. [08:33:19.093] #3 0x0000000000a90c25 in ExceptionalCondition (conditionName=0x2e76b3 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [08:33:19.093] No locals. [08:33:19.093] #4 0x0000000000764d69 in standard_ExecutorStart (queryDesc=0x83834a088, eflags=0) at ../src/backend/executor/execMain.c:194 [08:33:19.093] estate = 0x835dcf100 [08:33:19.093] oldcontext = 0x83822e800 [08:33:19.093] #5 0x00000000006fb435 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [08:33:19.093] copied_query = [08:33:19.093] rewritten = [08:33:19.093] plan = 0x835e07bd8 [08:33:19.093] queryDesc = 0x83834a088 [08:33:19.093] processed = [08:33:19.093] __error = [08:33:19.093] #6 RefreshMatViewByOid (matviewOid=27389, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [08:33:19.093] dest = [08:33:19.093] save_userid = 10 [08:33:19.093] save_sec_context = 0 [08:33:19.093] processed = 0 [08:33:19.093] matviewRel = 0x838255da8 [08:33:19.093] relowner = 10 [08:33:19.093] save_nestlevel = 2 [08:33:19.093] rule = [08:33:19.093] actions = [08:33:19.093] dataQuery = [08:33:19.093] tableSpace = [08:33:19.093] relpersistence = [08:33:19.093] OIDNewHeap = 27408 [08:33:19.093] address = [08:33:19.093] #7 0x00000000006fb016 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [08:33:19.093] lockmode = [08:33:19.093] matviewOid = 0 [08:33:19.093] #8 0x00000000006d25fc in ExecCreateTableAs (pstate=pstate@entry=0x83822e900, stmt=stmt@entry=0x835d3dfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820f9b030) at ../src/backend/commands/createas.c:350 [08:33:19.093] refresh = 0x0 [08:33:19.093] query = 0x838389598 [08:33:19.093] into = 0x8383898e0 [08:33:19.093] do_refresh = false [08:33:19.093] address = [08:33:19.093] dest = [08:33:19.093] is_matview = [08:33:19.093] #9 0x000000000093d518 in ProcessUtilitySlow (pstate=pstate@entry=0x83822e900, pstmt=pstmt@entry=0x835c77a68, queryString=queryString@entry=0x835c76100 "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=0x820f9b030) at ../src/backend/tcop/utility.c:1675 [08:33:19.093] _local_sigjmp_buf = {{_sjb = {9686345, 0, 34912971864, 34912972240, 34912971872, 12375000, 0, 35301550336, 4294902655, 34912971980, 34912972016, 0}}} [08:33:19.093] _save_exception_stack = 0x820f9af30 [08:33:19.093] _save_context_stack = 0x0 [08:33:19.093] _do_rethrow = false [08:33:19.093] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:33:19.093] parsetree = 0x835d3dfd0 [08:33:19.093] commandCollected = false [08:33:19.093] needCleanup = false [08:33:19.093] address = [08:33:19.093] isTopLevel = [08:33:19.093] isCompleteQuery = [08:33:19.093] #10 0x000000000093be98 in standard_ProcessUtility (pstmt=0x835c77a68, queryString=0x835c76100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838389dc8, qc=0x820f9b030) at ../src/backend/tcop/utility.c:1030 [08:33:19.093] isAtomicContext = false [08:33:19.093] parsetree = 0x835d3dfd0 [08:33:19.093] readonly_flags = [08:33:19.093] pstate = 0x83822e900 [08:33:19.093] isTopLevel = [08:33:19.093] #11 0x000000000093b928 in ProcessUtility (pstmt=0x18de0, queryString=0x6 , readOnlyTree=, context=711758842, params=0x0, queryEnv=0x0, dest=0x838389dc8, qc=0x820f9b030) at ../src/backend/tcop/utility.c:523 [08:33:19.093] No locals. [08:33:19.093] #12 0x000000000093b463 in PortalRunUtility (portal=0x835d4d100, pstmt=0x835c77a68, isTopLevel=, setHoldSnapshot=, dest=0x838389dc8, qc=0x820f9b030) at ../src/backend/tcop/pquery.c:1158 [08:33:19.093] No locals. [08:33:19.093] #13 0x000000000093aaf4 in PortalRunMulti (portal=portal@entry=0x835d4d100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x838389dc8, altdest=altdest@entry=0x838389dc8, qc=0x820f9b030) at ../src/backend/tcop/pquery.c:1323 [08:33:19.093] pstmt = 0x835c77a68 [08:33:19.093] stmtlist_item__state = {l = 0x838389d78, i = 0} [08:33:19.093] active_snapshot_set = false [08:33:19.093] stmtlist_item = 0x838389d90 [08:33:19.093] #14 0x000000000093a3c3 in PortalRun (portal=portal@entry=0x835d4d100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x838389dc8, altdest=altdest@entry=0x838389dc8, qc=0x820f9b030) at ../src/backend/tcop/pquery.c:791 [08:33:19.093] _local_sigjmp_buf = {{_sjb = {9675581, 35262877952, 34912972584, 34912972816, 34912972592, 35262894080, 12341672, 12375000, 35262825343, 35262809488, 4294967984, 0}}} [08:33:19.093] _save_exception_stack = 0x820f9b100 [08:33:19.093] _save_context_stack = 0x0 [08:33:19.093] _do_rethrow = false [08:33:19.093] saveTopTransactionResourceOwner = 0x835d5e358 [08:33:19.093] saveTopTransactionContext = 0x835d51000 [08:33:19.093] saveActivePortal = 0x0 [08:33:19.093] saveResourceOwner = 0x835d5e358 [08:33:19.093] savePortalContext = 0x0 [08:33:19.093] saveMemoryContext = 0x835d51000 [08:33:19.093] result = [08:33:19.093] nprocessed = [08:33:19.093] #15 0x0000000000939262 in exec_simple_query (query_string=query_string@entry=0x835c76100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [08:33:19.093] cmdtaglen = 24 [08:33:19.093] snapshot_set = [08:33:19.093] per_parsetree_context = 0x0 [08:33:19.093] plantree_list = [08:33:19.093] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:33:19.093] format = 0 [08:33:19.093] parsetree = 0x835c776a8 [08:33:19.093] commandTag = [08:33:19.093] cmdtagname = [08:33:19.093] querytree_list = [08:33:19.093] portal = 0x835d4d100 [08:33:19.093] receiver = 0x838389dc8 [08:33:19.093] parsetree_item__state = {l = 0x835c77a18, i = 0} [08:33:19.093] msec_str = "\000\000\000\000\b", '\000' , "\325\311\363f\000\000\000\000\266\357zh\230<\000~" [08:33:19.093] dest = DestRemote [08:33:19.093] was_logged = [08:33:19.093] oldcontext = 0x835d51000 [08:33:19.093] parsetree_list = 0x835c77a18 [08:33:19.093] use_implicit_block = false [08:33:19.093] parsetree_item = 0x835c77a30 [08:33:19.093] save_log_statement_stats = [08:33:19.093] #16 0x0000000000936ed3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [08:33:19.093] query_string = 0x835c76100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [08:33:19.093] input_message = {data = 0x835c76100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [08:33:19.093] firstchar = [08:33:19.093] local_sigjmp_buf = {{_sjb = {9659270, 34912973056, 34912973016, 34912973600, 12383736, 1, 8192, 8388608, 34912928639, 0, 0, 1}}} [08:33:19.093] send_ready_for_query = false [08:33:19.093] idle_in_transaction_timeout_enabled = false [08:33:19.093] idle_session_timeout_enabled = false [08:33:19.093] #17 0x00000000009316b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:33:19.093] bsdata = [08:33:19.093] #18 0x000000000088b247 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820f9be44 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f9bd80) at ../src/backend/postmaster/launch_backend.c:274 [08:33:19.093] pid = [08:33:19.093] #19 0x000000000088f618 in BackendStartup (client_sock=0x820f9bd80) at ../src/backend/postmaster/postmaster.c:3420 [08:33:19.093] startup_data = {canAcceptConnections = CAC_OK} [08:33:19.093] bn = 0x835c82308 [08:33:19.093] pid = [08:33:19.093] __error = [08:33:19.093] save_errno = [08:33:19.093] __error = [08:33:19.093] __error = [08:33:19.093] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [08:33:19.093] 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\177\3075\b", '\000' , "\340\275\371 \b\000\000\000hř(\b\000\000\000\v\000\000\000\000\000\000\000^O\232(\b", '\000' , " \276\371 \b\000\000\000\364\257\210\000\000\000\000\0000\276\371 \b", '\000' }, salen = 16}} [08:33:19.093] i = 0 [08:33:19.093] now = [08:33:19.093] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 711384194, events = 8, fd = 0, user_data = 0x820f9bd30}, {pos = 902637016, events = 8, fd = 553237440, user_data = 0x0}, {pos = 0, events = 0, fd = 1666957010, user_data = 0x3f72eb3b930a}, {pos = 710551456, events = 8, fd = 710622584, user_data = 0x820f9b848}, {pos = 553236672, events = 8, fd = 553236552, user_data = 0x3f72eb3b930a}, {pos = 710529928, events = 8, fd = 710622584, user_data = 0x820f9b878}, {pos = 553236720, events = 8, fd = 553236600, user_data = 0x82a5ac194}, {pos = 561103880, events = 8, fd = 710590868, user_data = 0x820f9b8e0}, {pos = -348437446, events = 16242, fd = 712413232, user_data = 0x1}, {pos = 553236752, events = 8, fd = -348417270, user_data = 0x82a595858}, {pos = 710622584, events = 8, fd = 553236712, user_data = 0x820f9b960}, {pos = 553236712, events = 8, fd = 710585612, user_data = 0x82171c408}, {pos = 710585612, events = 8, fd = 553236816, user_data = 0x3f72eb3b443a}, {pos = 553236856, events = 8, fd = 553237304, user_data = 0x820f9b960}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1077713228, fd = 561127480, user_data = 0x800000001}, {pos = 561103880, events = 8, fd = 710529928, user_data = 0x821721288}, {pos = 710498392, events = 8, fd = 561103880, user_data = 0x820f9b9e8}, {pos = 553237416, events = 8, fd = 553236944, user_data = 0x3f72eb3b8ca2}, {pos = 2701514, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 561127480, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 553237672, user_data = 0x2171c408}, {pos = 553237488, events = 8, fd = 553237088, user_data = 0x1}, {pos = 553237416, events = 8, fd = 32, user_data = 0x820f9ba50}, {pos = -348419469, events = 16242, fd = 553237360, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821722038}, {pos = 1, events = 8, fd = 561103880, user_data = 0x82a595858}, {pos = 553237672, events = 8, fd = 553237488, user_data = 0x820f9ba60}, {pos = 0, events = 0, fd = 561074184, user_data = 0x20}, {pos = 553237472, events = 8, fd = -348443929, user_data = 0x821715008}, {pos = 561075208, events = 8, fd = 561076232, user_data = 0x821715c08}, {pos = 561090568, events = 8, fd = 561091592, user_data = 0x821719808}, {pos = 561093640, events = 8, fd = 561094664, user_data = 0x82171a408}, {pos = 561096712, events = 8, fd = 561097736, user_data = 0x82171b008}, {pos = 561099784, events = 8, fd = 561100808, user_data = 0x82171bc08}, {pos = 561102856, events = 8, fd = 561103880, user_data = 0x82171c808}, {pos = 561105928, events = 8, fd = 561106952, user_data = 0x82171d408}, {pos = 561109000, events = 8, fd = 561110024, user_data = 0x82171e008}, {pos = 561112072, events = 8, fd = 561113096, user_data = 0x82171ec08}, {pos = 561119240, events = 8, fd = 561120264, user_data = 0x821720808}, {pos = 561122312, events = 8, fd = 561074184, user_data = 0x2938ca}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821722038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 553237672, events = 8, fd = 553237088, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 561127480, user_data = 0x1}, {pos = 561074184, events = 8, fd = 313, user_data = 0x820f9bc90}, {pos = -348445201, events = 16242, fd = 2701514, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 561127480, user_data = 0x1}, {pos = 561103880, events = 8, fd = 902193152, user_data = 0x1}, {pos = 902193556, events = 8, fd = 0, user_data = 0x820f9bc60}, {pos = 681198956, events = 8, fd = 1, user_data = 0x835c66000}, {pos = 553237648, events = 8, fd = 681195266, user_data = 0x82a6c7170 }, {pos = 12304672, events = 0, fd = 711750000, user_data = 0x82171c408}, {pos = 553237872, events = 8, fd = -348445730, user_data = 0x835c84800}, {pos = 1, events = 0, fd = -348446114, user_data = 0x821715008}, {pos = 553237656, events = 8, fd = 553237872, user_data = 0x1c20}, {pos = 902266624, events = 8, fd = -348366448, user_data = 0x0}, {pos = 553190271, events = 8, fd = 8107367, user_data = 0x820f9bd20}, {pos = 681157648, events = 8, fd = 712413232, user_data = 0x82a76b310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820f9bd50}, {pos = 681200541, events = 8, fd = 902193152, user_data = 0x1da2}, {pos = 553237936, events = 8, fd = 681167098, user_data = 0x0}, {pos = 0, events = 0, fd = 1666957010, user_data = 0x0}} [08:33:19.093] last_touch_time = 1727252928 [08:33:19.093] last_lockfile_recheck_time = 1727252928 [08:33:19.093] nevents = 1 [08:33:19.093] #21 0x000000000088d435 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820f9c390) at ../src/backend/postmaster/postmaster.c:1351 [08:33:19.093] userDoption = [08:33:19.093] listen_addr_saved = [08:33:19.093] output_config_variable = [08:33:19.093] opt = [08:33:19.093] status = [08:33:19.093] #22 0x00000000007c824c in main (argc=8, argv=0x820f9c390) at ../src/backend/main/main.c:197 [08:33:19.093] do_check_root = [08:33:19.104] [08:33:19.104] [08:33:19.104] [08:33:19.171] dumping /tmp/cores/postgres.11140.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:33:19.302] [New LWP 101844] [08:33:19.368] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [08:33:19.368] Program terminated with signal SIGABRT, Aborted. [08:33:19.368] Sent by thr_kill() from pid 11140 and user 1003. [08:33:19.368] #0 0x000000082b53741a in thr_kill () from /lib/libc.so.7 [08:33:19.944] [08:33:19.944] Thread 1 (LWP 101844): [08:33:19.944] #0 0x000000082b53741a in thr_kill () from /lib/libc.so.7 [08:33:19.944] No symbol table info available. [08:33:19.944] #1 0x000000082b4b0e64 in raise () from /lib/libc.so.7 [08:33:19.944] No symbol table info available. [08:33:19.944] #2 0x000000082b5616f9 in abort () from /lib/libc.so.7 [08:33:19.944] No symbol table info available. [08:33:19.944] #3 0x0000000000a90c25 in ExceptionalCondition (conditionName=0x2e76b3 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [08:33:19.944] No locals. [08:33:19.944] #4 0x0000000000764d69 in standard_ExecutorStart (queryDesc=0x841d8e088, eflags=0) at ../src/backend/executor/execMain.c:194 [08:33:19.944] estate = 0x841cf2100 [08:33:19.944] oldcontext = 0x834f7a800 [08:33:19.944] #5 0x00000000006fb435 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [08:33:19.944] copied_query = [08:33:19.944] rewritten = [08:33:19.944] plan = 0x834ea1bd8 [08:33:19.944] queryDesc = 0x841d8e088 [08:33:19.944] processed = [08:33:19.944] __error = [08:33:19.944] #6 RefreshMatViewByOid (matviewOid=27417, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [08:33:19.944] dest = [08:33:19.944] save_userid = 10 [08:33:19.944] save_sec_context = 0 [08:33:19.944] processed = 0 [08:33:19.944] matviewRel = 0x841ca3650 [08:33:19.944] relowner = 10 [08:33:19.944] save_nestlevel = 2 [08:33:19.944] rule = [08:33:19.944] actions = [08:33:19.944] dataQuery = [08:33:19.944] tableSpace = [08:33:19.944] relpersistence = [08:33:19.944] OIDNewHeap = 27424 [08:33:19.944] address = [08:33:19.944] #7 0x00000000006fb016 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [08:33:19.944] lockmode = [08:33:19.944] matviewOid = 0 [08:33:19.944] #8 0x00000000006d25fc in ExecCreateTableAs (pstate=pstate@entry=0x834f7a900, stmt=stmt@entry=0x834f76fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8213f4300) at ../src/backend/commands/createas.c:350 [08:33:19.944] refresh = 0x0 [08:33:19.944] query = 0x834ec14d8 [08:33:19.944] into = 0x834ec1820 [08:33:19.944] do_refresh = false [08:33:19.944] address = [08:33:19.944] dest = [08:33:19.944] is_matview = [08:33:19.944] #9 0x000000000093d518 in ProcessUtilitySlow (pstate=pstate@entry=0x834f7a900, pstmt=pstmt@entry=0x834ddaa68, queryString=queryString@entry=0x834dd9100 "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=0x8213f4300) at ../src/backend/tcop/utility.c:1675 [08:33:19.944] _local_sigjmp_buf = {{_sjb = {9686345, 0, 34917531432, 34917531808, 34917531440, 12375000, 0, 35248384256, 4294902655, 34917531548, 34917531584, 0}}} [08:33:19.944] _save_exception_stack = 0x8213f4200 [08:33:19.944] _save_context_stack = 0x0 [08:33:19.944] _do_rethrow = false [08:33:19.944] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:33:19.944] parsetree = 0x834f76fd0 [08:33:19.944] commandCollected = false [08:33:19.944] needCleanup = false [08:33:19.944] address = [08:33:19.944] isTopLevel = [08:33:19.944] isCompleteQuery = [08:33:19.944] #10 0x000000000093be98 in standard_ProcessUtility (pstmt=0x834ddaa68, queryString=0x834dd9100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834ec1d08, qc=0x8213f4300) at ../src/backend/tcop/utility.c:1030 [08:33:19.944] isAtomicContext = false [08:33:19.944] parsetree = 0x834f76fd0 [08:33:19.944] readonly_flags = [08:33:19.944] pstate = 0x834f7a900 [08:33:19.944] isTopLevel = [08:33:19.944] #11 0x000000000093b928 in ProcessUtility (pstmt=0x18dd4, queryString=0x6 , readOnlyTree=, context=726889466, params=0x0, queryEnv=0x0, dest=0x834ec1d08, qc=0x8213f4300) at ../src/backend/tcop/utility.c:523 [08:33:19.944] No locals. [08:33:19.944] #12 0x000000000093b463 in PortalRunUtility (portal=0x834e7f100, pstmt=0x834ddaa68, isTopLevel=, setHoldSnapshot=, dest=0x834ec1d08, qc=0x8213f4300) at ../src/backend/tcop/pquery.c:1158 [08:33:19.944] No locals. [08:33:19.944] #13 0x000000000093aaf4 in PortalRunMulti (portal=portal@entry=0x834e7f100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x834ec1d08, altdest=altdest@entry=0x834ec1d08, qc=0x8213f4300) at ../src/backend/tcop/pquery.c:1323 [08:33:19.944] pstmt = 0x834ddaa68 [08:33:19.944] stmtlist_item__state = {l = 0x834ec1cb8, i = 0} [08:33:19.944] active_snapshot_set = false [08:33:19.944] stmtlist_item = 0x834ec1cd0 [08:33:19.944] #14 0x000000000093a3c3 in PortalRun (portal=portal@entry=0x834e7f100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x834ec1d08, altdest=altdest@entry=0x834ec1d08, qc=0x8213f4300) at ../src/backend/tcop/pquery.c:791 [08:33:19.944] _local_sigjmp_buf = {{_sjb = {9675581, 35247354112, 34917532152, 34917532384, 34917532160, 35247370240, 12341672, 12375000, 35247358847, 35248362896, 4294967984, 0}}} [08:33:19.944] _save_exception_stack = 0x8213f43d0 [08:33:19.944] _save_context_stack = 0x0 [08:33:19.944] _do_rethrow = false [08:33:19.944] saveTopTransactionResourceOwner = 0x834ece858 [08:33:19.944] saveTopTransactionContext = 0x834e83000 [08:33:19.944] saveActivePortal = 0x0 [08:33:19.944] saveResourceOwner = 0x834ece858 [08:33:19.944] savePortalContext = 0x0 [08:33:19.944] saveMemoryContext = 0x834e83000 [08:33:19.944] result = [08:33:19.944] nprocessed = [08:33:19.944] #15 0x0000000000939262 in exec_simple_query (query_string=query_string@entry=0x834dd9100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [08:33:19.944] cmdtaglen = 24 [08:33:19.944] snapshot_set = [08:33:19.944] per_parsetree_context = 0x0 [08:33:19.944] plantree_list = [08:33:19.944] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:33:19.944] format = 0 [08:33:19.944] parsetree = 0x834dda6a8 [08:33:19.944] commandTag = [08:33:19.944] cmdtagname = [08:33:19.944] querytree_list = [08:33:19.944] portal = 0x834e7f100 [08:33:19.944] receiver = 0x834ec1d08 [08:33:19.944] parsetree_item__state = {l = 0x834ddaa18, i = 0} [08:33:19.944] msec_str = "\000\000\000\000\b", '\000' , "\330\311\363f\000\000\000\000\326a>\v\314h\262a" [08:33:19.944] dest = DestRemote [08:33:19.944] was_logged = [08:33:19.944] oldcontext = 0x834e83000 [08:33:19.944] parsetree_list = 0x834ddaa18 [08:33:19.944] use_implicit_block = false [08:33:19.944] parsetree_item = 0x834ddaa30 [08:33:19.944] save_log_statement_stats = [08:33:19.944] #16 0x0000000000936ed3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [08:33:19.944] query_string = 0x834dd9100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [08:33:19.944] input_message = {data = 0x834dd9100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [08:33:19.944] firstchar = [08:33:19.944] local_sigjmp_buf = {{_sjb = {9659270, 34917532624, 34917532584, 34917533168, 12383736, 1, 8192, 8388608, 34917516159, 0, 0, 1}}} [08:33:19.944] send_ready_for_query = false [08:33:19.944] idle_in_transaction_timeout_enabled = false [08:33:19.944] idle_session_timeout_enabled = false [08:33:19.944] #17 0x00000000009316b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:33:19.944] bsdata = [08:33:19.944] #18 0x000000000088b247 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8213f5114 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8213f5050) at ../src/backend/postmaster/launch_backend.c:274 [08:33:19.944] pid = [08:33:19.944] #19 0x000000000088f618 in BackendStartup (client_sock=0x8213f5050) at ../src/backend/postmaster/postmaster.c:3420 [08:33:19.944] startup_data = {canAcceptConnections = CAC_OK} [08:33:19.944] bn = 0x834de5538 [08:33:19.944] pid = [08:33:19.944] __error = [08:33:19.944] save_errno = [08:33:19.944] __error = [08:33:19.944] __error = [08:33:19.944] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [08:33:19.944] 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\3354\b", '\000' , "\260P?!\b\000\000\000h\245\a*\b\000\000\000\v\000\000\000\000\000\000\000^/\b*\b", '\000' , "\360P?!\b\000\000\000\364\257\210\000\000\000\000\000\000Q?!\b", '\000' }, salen = 16}} [08:33:19.944] i = 0 [08:33:19.944] now = [08:33:19.944] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 726514818, events = 8, fd = 0, user_data = 0x8213f5000}, {pos = 887371224, events = 8, fd = 557797008, user_data = 0x0}, {pos = 0, events = 0, fd = 2125757678, user_data = 0x5093685030a}, {pos = 725682080, events = 8, fd = 725753208, user_data = 0x8213f4b18}, {pos = 557796240, events = 8, fd = 557796120, user_data = 0x5093685030a}, {pos = 725660552, events = 8, fd = 725753208, user_data = 0x8213f4b48}, {pos = 557796288, events = 8, fd = 557796168, user_data = 0x82b41a194}, {pos = 560333832, events = 8, fd = 725721492, user_data = 0x8213f4bb0}, {pos = 914666554, events = 1289, fd = 727543856, user_data = 0x1}, {pos = 557796320, events = 8, fd = 914686730, user_data = 0x82b403858}, {pos = 725753208, events = 8, fd = 557796280, user_data = 0x8213f4c30}, {pos = 557796280, events = 8, fd = 725716236, user_data = 0x821660408}, {pos = 725716236, events = 8, fd = 557796384, user_data = 0x5093684b43a}, {pos = 557796424, events = 8, fd = 557796872, user_data = 0x8213f4c30}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1749342766, fd = 560357432, user_data = 0x800000001}, {pos = 560333832, events = 8, fd = 725660552, user_data = 0x821665288}, {pos = 725629016, events = 8, fd = 560333832, user_data = 0x8213f4cb8}, {pos = 557796984, events = 8, fd = 557796512, user_data = 0x5093684fca2}, {pos = 2701514, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560357432, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 557797240, user_data = 0x21660408}, {pos = 557797056, events = 8, fd = 557796656, user_data = 0x1}, {pos = 557796984, events = 8, fd = 32, user_data = 0x8213f4d20}, {pos = 914684531, events = 1289, fd = 557796928, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821666038}, {pos = 1, events = 8, fd = 560333832, user_data = 0x82b403858}, {pos = 557797240, events = 8, fd = 557797056, user_data = 0x8213f4d30}, {pos = 0, events = 0, fd = 560304136, user_data = 0x20}, {pos = 557797040, events = 8, fd = 914660071, user_data = 0x821659008}, {pos = 560305160, events = 8, fd = 560306184, user_data = 0x821659c08}, {pos = 560320520, events = 8, fd = 560321544, user_data = 0x82165d808}, {pos = 560323592, events = 8, fd = 560324616, user_data = 0x82165e408}, {pos = 560326664, events = 8, fd = 560327688, user_data = 0x82165f008}, {pos = 560329736, events = 8, fd = 560330760, user_data = 0x82165fc08}, {pos = 560332808, events = 8, fd = 560333832, user_data = 0x821660808}, {pos = 560335880, events = 8, fd = 560336904, user_data = 0x821661408}, {pos = 560338952, events = 8, fd = 560339976, user_data = 0x821662008}, {pos = 560342024, events = 8, fd = 560343048, user_data = 0x821662c08}, {pos = 560349192, events = 8, fd = 560350216, user_data = 0x821664808}, {pos = 560352264, events = 8, fd = 560304136, user_data = 0x2938ca}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821666038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557797240, events = 8, fd = 557796656, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560357432, user_data = 0x1}, {pos = 560304136, events = 8, fd = 313, user_data = 0x8213f4f60}, {pos = 914658799, events = 1289, fd = 2701514, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560357432, user_data = 0x1}, {pos = 560333832, events = 8, fd = 886870016, user_data = 0x1}, {pos = 886870420, events = 8, fd = 0, user_data = 0x8213f4f30}, {pos = 705176940, events = 8, fd = 1, user_data = 0x834dc9000}, {pos = 557797216, events = 8, fd = 705173250, user_data = 0x82b535170 }, {pos = 12304672, events = 0, fd = 726880624, user_data = 0x821660408}, {pos = 557797440, events = 8, fd = 914658270, user_data = 0x834de7800}, {pos = 1, events = 0, fd = 914657886, user_data = 0x821659008}, {pos = 557797224, events = 8, fd = 557797440, user_data = 0x1c20}, {pos = 886943424, events = 8, fd = 914737552, user_data = 0x0}, {pos = 557777791, events = 8, fd = 8107367, user_data = 0x8213f4ff0}, {pos = 705135632, events = 8, fd = 727543856, user_data = 0x82b5d9310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8213f5020}, {pos = 705178525, events = 8, fd = 886870016, user_data = 0x1dd0}, {pos = 557797504, events = 8, fd = 705145082, user_data = 0x0}, {pos = 0, events = 0, fd = 2125757678, user_data = 0x0}} [08:33:19.944] last_touch_time = 1727252929 [08:33:19.944] last_lockfile_recheck_time = 1727252929 [08:33:19.944] nevents = 1 [08:33:19.944] #21 0x000000000088d435 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8213f5660) at ../src/backend/postmaster/postmaster.c:1351 [08:33:19.944] userDoption = [08:33:19.944] listen_addr_saved = [08:33:19.944] output_config_variable = [08:33:19.944] opt = [08:33:19.944] status = [08:33:19.944] #22 0x00000000007c824c in main (argc=4, argv=0x8213f5660) at ../src/backend/main/main.c:197 [08:33:19.944] do_check_root = [08:33:19.956] [08:33:19.956] [08:33:19.956] [08:33:20.022] dumping /tmp/cores/postgres.17939.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:33:20.142] [New LWP 101861] [08:33:20.205] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [08:33:20.205] Program terminated with signal SIGABRT, Aborted. [08:33:20.205] Sent by thr_kill() from pid 17939 and user 1003. [08:33:20.205] #0 0x000000082bf8f41a in thr_kill () from /lib/libc.so.7 [08:33:20.797] [08:33:20.797] Thread 1 (LWP 101861): [08:33:20.797] #0 0x000000082bf8f41a in thr_kill () from /lib/libc.so.7 [08:33:20.797] No symbol table info available. [08:33:20.797] #1 0x000000082bf08e64 in raise () from /lib/libc.so.7 [08:33:20.797] No symbol table info available. [08:33:20.797] #2 0x000000082bfb96f9 in abort () from /lib/libc.so.7 [08:33:20.797] No symbol table info available. [08:33:20.797] #3 0x0000000000a90c25 in ExceptionalCondition (conditionName=0x2e76b3 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [08:33:20.797] No locals. [08:33:20.797] #4 0x0000000000764d69 in standard_ExecutorStart (queryDesc=0x83791d088, eflags=0) at ../src/backend/executor/execMain.c:194 [08:33:20.797] estate = 0x837970100 [08:33:20.797] oldcontext = 0x837872800 [08:33:20.797] #5 0x0000000839bc4862 in pgss_ExecutorStart (queryDesc=0x83791d088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [08:33:20.797] No locals. [08:33:20.797] #6 0x00000000006fb435 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [08:33:20.797] copied_query = [08:33:20.797] rewritten = [08:33:20.797] plan = 0x83cf23bd8 [08:33:20.797] queryDesc = 0x83791d088 [08:33:20.797] processed = [08:33:20.797] __error = [08:33:20.797] #7 RefreshMatViewByOid (matviewOid=27216, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [08:33:20.797] dest = [08:33:20.797] save_userid = 10 [08:33:20.797] save_sec_context = 0 [08:33:20.797] processed = 0 [08:33:20.797] matviewRel = 0x83ced05e8 [08:33:20.797] relowner = 10 [08:33:20.797] save_nestlevel = 2 [08:33:20.797] rule = [08:33:20.797] actions = [08:33:20.797] dataQuery = [08:33:20.797] tableSpace = [08:33:20.797] relpersistence = [08:33:20.797] OIDNewHeap = 27232 [08:33:20.797] address = [08:33:20.797] #8 0x00000000006fb016 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [08:33:20.797] lockmode = [08:33:20.797] matviewOid = 0 [08:33:20.797] #9 0x00000000006d25fc in ExecCreateTableAs (pstate=pstate@entry=0x837872900, stmt=stmt@entry=0x837837fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820e8b050) at ../src/backend/commands/createas.c:350 [08:33:20.797] refresh = 0x0 [08:33:20.797] query = 0x837882408 [08:33:20.797] into = 0x837837f40 [08:33:20.797] do_refresh = false [08:33:20.797] address = [08:33:20.797] dest = [08:33:20.797] is_matview = [08:33:20.797] #10 0x000000000093d518 in ProcessUtilitySlow (pstate=pstate@entry=0x837872900, pstmt=pstmt@entry=0x837837e30, queryString=queryString@entry=0x83779a100 "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=0x820e8b050) at ../src/backend/tcop/utility.c:1675 [08:33:20.797] _local_sigjmp_buf = {{_sjb = {9686345, 0, 34911857336, 34911857712, 34911857344, 12375000, 0, 35291343104, 34911814527, 7, 34911857488, 0}}} [08:33:20.797] _save_exception_stack = 0x820e8ad40 [08:33:20.797] _save_context_stack = 0x0 [08:33:20.797] _do_rethrow = false [08:33:20.797] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:33:20.797] parsetree = 0x837837fd0 [08:33:20.797] commandCollected = false [08:33:20.797] needCleanup = false [08:33:20.797] address = [08:33:20.797] isTopLevel = [08:33:20.797] isCompleteQuery = [08:33:20.797] #11 0x000000000093be98 in standard_ProcessUtility (pstmt=0x837837e30, queryString=queryString@entry=0x83779a100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837882ba8, qc=0x820e8b050) at ../src/backend/tcop/utility.c:1030 [08:33:20.797] isAtomicContext = false [08:33:20.797] parsetree = 0x837837fd0 [08:33:20.797] readonly_flags = [08:33:20.797] pstate = 0x837872900 [08:33:20.797] isTopLevel = [08:33:20.797] #12 0x0000000839bc4dee in pgss_ProcessUtility (pstmt=0x837837e30, queryString=0x83779a100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837882ba8, qc=0x820e8b050) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [08:33:20.797] _local_sigjmp_buf = {{_sjb = {35328380199, 34911857984, 34911857848, 34911858304, 35291102768, 0, 12375000, 34911858512, 34911814527, 34911858084, 34911858112, 0}}} [08:33:20.797] _save_exception_stack = 0x820e8af50 [08:33:20.797] _save_context_stack = 0x0 [08:33:20.797] _do_rethrow = false [08:33:20.797] bufusage = {shared_blks_hit = 35328380199, shared_blks_read = 34911857984, shared_blks_dirtied = 34911857848, shared_blks_written = 34911858304, local_blks_hit = 35291102768, local_blks_read = 0, local_blks_dirtied = 12375000, local_blks_written = 34911858512, temp_blks_read = 34911814527, temp_blks_written = 34911858084, shared_blk_read_time = {ticks = 34911858112}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4193956267543427328}, local_blk_write_time = {ticks = 12384040}, temp_blk_read_time = {ticks = 35340404992}, temp_blk_write_time = {ticks = 12337616}} [08:33:20.797] walusage_start = {wal_records = 8935, wal_fpi = 145, wal_bytes = 1318951} [08:33:20.797] duration = [08:33:20.797] bufusage_start = {shared_blks_hit = 151371, shared_blks_read = 8094, shared_blks_dirtied = 2622, shared_blks_written = 2209, 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}} [08:33:20.797] walusage = {wal_records = -3904593372973306903, wal_fpi = 35291103184, wal_bytes = 123} [08:33:20.797] start = {ticks = -188097600270} [08:33:20.797] rows = [08:33:20.797] saved_queryId = 6041762721901209185 [08:33:20.797] parsetree = [08:33:20.797] saved_stmt_location = 0 [08:33:20.797] saved_stmt_len = 69 [08:33:20.797] enabled = [08:33:20.797] #13 0x000000000093b463 in PortalRunUtility (portal=0x837842100, pstmt=0x837837e30, isTopLevel=, setHoldSnapshot=, dest=0x837882ba8, qc=0x820e8b050) at ../src/backend/tcop/pquery.c:1158 [08:33:20.797] No locals. [08:33:20.797] #14 0x000000000093aaf4 in PortalRunMulti (portal=portal@entry=0x837842100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x837882ba8, altdest=altdest@entry=0x837882ba8, qc=0x820e8b050) at ../src/backend/tcop/pquery.c:1323 [08:33:20.797] pstmt = 0x837837e30 [08:33:20.797] stmtlist_item__state = {l = 0x837882b58, i = 0} [08:33:20.797] active_snapshot_set = false [08:33:20.797] stmtlist_item = 0x837882b70 [08:33:20.797] #15 0x000000000093a3c3 in PortalRun (portal=portal@entry=0x837842100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x837882ba8, altdest=altdest@entry=0x837882ba8, qc=0x820e8b050) at ../src/backend/tcop/pquery.c:791 [08:33:20.797] _local_sigjmp_buf = {{_sjb = {9675581, 35291144448, 34911858504, 34911858736, 34911858512, 35291238400, 12341672, 12375000, 35291136895, 35291096544, 4294967984, 0}}} [08:33:20.797] _save_exception_stack = 0x820e8b120 [08:33:20.797] _save_context_stack = 0x0 [08:33:20.797] _do_rethrow = false [08:33:20.797] saveTopTransactionResourceOwner = 0x8378903d8 [08:33:20.797] saveTopTransactionContext = 0x837859000 [08:33:20.797] saveActivePortal = 0x0 [08:33:20.797] saveResourceOwner = 0x8378903d8 [08:33:20.797] savePortalContext = 0x0 [08:33:20.797] saveMemoryContext = 0x837859000 [08:33:20.797] result = [08:33:20.797] nprocessed = [08:33:20.797] #16 0x0000000000939262 in exec_simple_query (query_string=query_string@entry=0x83779a100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [08:33:20.797] cmdtaglen = 24 [08:33:20.797] snapshot_set = [08:33:20.797] per_parsetree_context = 0x0 [08:33:20.797] plantree_list = [08:33:20.797] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:33:20.797] format = 0 [08:33:20.797] parsetree = 0x83779b6a8 [08:33:20.797] commandTag = [08:33:20.797] cmdtagname = [08:33:20.797] querytree_list = [08:33:20.797] portal = 0x837842100 [08:33:20.797] receiver = 0x837882ba8 [08:33:20.797] parsetree_item__state = {l = 0x83779ba18, i = 0} [08:33:20.797] msec_str = "\000\000\000\000\b", '\000' , "\375\311\363f\000\000\000\000F\232\020\342wp\261", [08:33:20.797] dest = DestRemote [08:33:20.797] was_logged = [08:33:20.797] oldcontext = 0x837859000 [08:33:20.797] parsetree_list = 0x83779ba18 [08:33:20.797] use_implicit_block = false [08:33:20.797] parsetree_item = 0x83779ba30 [08:33:20.797] save_log_statement_stats = [08:33:20.797] #17 0x0000000000936ed3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [08:33:20.797] query_string = 0x83779a100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [08:33:20.797] input_message = {data = 0x83779a100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [08:33:20.797] firstchar = [08:33:20.797] local_sigjmp_buf = {{_sjb = {9659270, 34911858976, 34911858936, 34911859520, 12383736, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [08:33:20.797] send_ready_for_query = false [08:33:20.797] idle_in_transaction_timeout_enabled = false [08:33:20.797] idle_session_timeout_enabled = false [08:33:20.797] #18 0x00000000009316b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:33:20.797] bsdata = [08:33:20.797] #19 0x000000000088b247 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820e8be64 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820e8bda0) at ../src/backend/postmaster/launch_backend.c:274 [08:33:20.797] pid = [08:33:20.797] #20 0x000000000088f618 in BackendStartup (client_sock=0x820e8bda0) at ../src/backend/postmaster/postmaster.c:3420 [08:33:20.797] startup_data = {canAcceptConnections = CAC_OK} [08:33:20.797] bn = 0x8377a60d8 [08:33:20.797] pid = [08:33:20.797] __error = [08:33:20.797] save_errno = [08:33:20.797] __error = [08:33:20.797] __error = [08:33:20.797] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [08:33:20.797] 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 = " \254y7\b", '\000' , "\276\350 \b\000\000\000hE\363*\b\000\000\000\v\000\000\000\000\000\000\000^\317\363*\b", '\000' , "@\276\350 \b\000\000\000\364\257\210\000\000\000\000\000P\276\350 \b", '\000' }, salen = 16}} [08:33:20.797] i = 0 [08:33:20.797] now = [08:33:20.797] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 737361026, events = 8, fd = 0, user_data = 0x820e8bd50}, {pos = 931124696, events = 8, fd = 552123360, user_data = 0x0}, {pos = -1549827318, events = 13387, fd = 736528288, user_data = 0x82be79d78}, {pos = 552122456, events = 8, fd = 552122576, user_data = 0x820e8b858}, {pos = -1549827318, events = 13387, fd = 736506760, user_data = 0x82be79d78}, {pos = 552122504, events = 8, fd = 552122624, user_data = 0x820e8b888}, {pos = 736567700, events = 8, fd = 561001480, user_data = 0x82be72194}, {pos = 552122608, events = 8, fd = -1549847494, user_data = 0x820e8b890}, {pos = 720577552, events = 8, fd = 738390064, user_data = 0x344ba39f830a}, {pos = 736475224, events = 8, fd = 736599416, user_data = 0x820e8b8f8}, {pos = 552122736, events = 8, fd = 552122616, user_data = 0x82be70d0c}, {pos = 561001480, events = 8, fd = 736562444, user_data = 0x820e8b960}, {pos = -1549847494, events = 13387, fd = 552122760, user_data = 0x820e8bb58}, {pos = 552122736, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821709038}, {pos = 1, events = 3385858307, fd = 561001480, user_data = 0x82be63388}, {pos = 561022920, events = 8, fd = 0, user_data = 0x0}, {pos = 552122872, events = 8, fd = 552123336, user_data = 0x820e8b9e0}, {pos = -1549828958, events = 13387, fd = 2701514, user_data = 0x6d68b}, {pos = 2090263927, events = 3385858307, fd = 561025080, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820e8bcc8}, {pos = 561001480, events = 3, fd = 552123408, user_data = 0x821708828}, {pos = 656, events = 0, fd = 552123336, user_data = 0x820e8b9f8}, {pos = 552122976, events = 8, fd = -1549829349, user_data = 0x820e8bb90}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 561025080, events = 8, fd = 1, user_data = 0x821703408}, {pos = 736475224, events = 8, fd = 552123592, user_data = 0x820e8bc10}, {pos = 552122992, events = 8, fd = 0, user_data = 0x8216fc008}, {pos = 33, events = 0, fd = 552123392, user_data = 0x344ba39f1ae7}, {pos = 560971784, events = 8, fd = 560972808, user_data = 0x8216fc808}, {pos = 560974856, events = 8, fd = 560988168, user_data = 0x821700408}, {pos = 560990216, events = 8, fd = 560991240, user_data = 0x821701008}, {pos = 560993288, events = 8, fd = 560994312, user_data = 0x821701c08}, {pos = 560996360, events = 8, fd = 560997384, user_data = 0x821702808}, {pos = 560999432, events = 8, fd = 561000456, user_data = 0x821703408}, {pos = 561002504, events = 8, fd = 561003528, user_data = 0x821704008}, {pos = 561005576, events = 8, fd = 561006600, user_data = 0x821704c08}, {pos = 561008648, events = 8, fd = 561009672, user_data = 0x821705808}, {pos = 561011720, events = 8, fd = 561016840, user_data = 0x821707408}, {pos = 561018888, events = 8, fd = 561019912, user_data = 0x82170a408}, {pos = 298556000, events = 0, fd = 560971784, user_data = 0x2938ca}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821709038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552123592, events = 8, fd = 552122992, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 561025080, user_data = 0x1}, {pos = 560971784, events = 8, fd = 313, user_data = 0x820e8bcb0}, {pos = -1549855249, events = 13387, fd = 2701514, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 561025080, user_data = 0x1}, {pos = 561001480, events = 8, fd = 930652160, user_data = 0x1}, {pos = 930652564, events = 8, fd = 0, user_data = 0x820e8bc80}, {pos = 720618860, events = 8, fd = 1, user_data = 0x83778a000}, {pos = 552123568, events = 8, fd = 720615170, user_data = 0x82bf8d170 }, {pos = 12304672, events = 0, fd = 737726832, user_data = 0x821703408}, {pos = 552123792, events = 8, fd = -1549855778, user_data = 0x8377a8800}, {pos = 1, events = 0, fd = -1549856162, user_data = 0x8216fc008}, {pos = 552123576, events = 8, fd = 552123792, user_data = 0x1c20}, {pos = 930720800, events = 8, fd = -1549776496, user_data = 0x0}, {pos = 552076159, events = 8, fd = 8107367, user_data = 0x820e8bd40}, {pos = 720577552, events = 8, fd = 738390064, user_data = 0x82c031310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820e8bd70}, {pos = 720620445, events = 8, fd = 930652160, user_data = 0x36ac}, {pos = 552123856, events = 8, fd = 720587002, user_data = 0x0}, {pos = 0, events = 0, fd = -1013650455, user_data = 0x0}} [08:33:20.797] last_touch_time = 1727252964 [08:33:20.797] last_lockfile_recheck_time = 1727252964 [08:33:20.797] nevents = 1 [08:33:20.797] #22 0x000000000088d435 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820e8c3b8) at ../src/backend/postmaster/postmaster.c:1351 [08:33:20.797] userDoption = [08:33:20.797] listen_addr_saved = [08:33:20.797] output_config_variable = [08:33:20.797] opt = [08:33:20.797] status = [08:33:20.797] #23 0x00000000007c824c in main (argc=4, argv=0x820e8c3b8) at ../src/backend/main/main.c:197 [08:33:20.797] do_check_root =