[06:20:01.510] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [06:20:01.869] dumping /tmp/cores/postgres.10472.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [06:20:01.998] [New LWP 101848] [06:20:02.082] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [06:20:02.082] Program terminated with signal SIGABRT, Aborted. [06:20:02.082] Sent by thr_kill() from pid 10472 and user 1003. [06:20:02.082] #0 0x000000082caa241a in thr_kill () from /lib/libc.so.7 [06:20:02.654] [06:20:02.654] Thread 1 (LWP 101848): [06:20:02.654] #0 0x000000082caa241a in thr_kill () from /lib/libc.so.7 [06:20:02.654] No symbol table info available. [06:20:02.654] #1 0x000000082ca1be64 in raise () from /lib/libc.so.7 [06:20:02.654] No symbol table info available. [06:20:02.654] #2 0x000000082cacc6f9 in abort () from /lib/libc.so.7 [06:20:02.654] No symbol table info available. [06:20:02.654] #3 0x0000000000a90005 in ExceptionalCondition (conditionName=0x2e7568 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:20:02.654] No locals. [06:20:02.654] #4 0x0000000000764639 in standard_ExecutorStart (queryDesc=0x835e8d088, eflags=0) at ../src/backend/executor/execMain.c:194 [06:20:02.654] estate = 0x835f45100 [06:20:02.654] oldcontext = 0x835f87800 [06:20:02.654] #5 0x00000000006fae45 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [06:20:02.654] copied_query = [06:20:02.654] rewritten = [06:20:02.654] plan = 0x835f7dbd8 [06:20:02.654] queryDesc = 0x835e8d088 [06:20:02.654] processed = [06:20:02.654] __error = [06:20:02.654] #6 RefreshMatViewByOid (matviewOid=27353, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [06:20:02.654] dest = [06:20:02.654] save_userid = 10 [06:20:02.654] save_sec_context = 0 [06:20:02.654] processed = 0 [06:20:02.654] matviewRel = 0x84459f468 [06:20:02.654] relowner = 10 [06:20:02.654] save_nestlevel = 2 [06:20:02.654] rule = [06:20:02.654] actions = [06:20:02.654] dataQuery = [06:20:02.654] tableSpace = [06:20:02.654] relpersistence = [06:20:02.654] OIDNewHeap = 27385 [06:20:02.654] address = [06:20:02.654] #7 0x00000000006faa26 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:20:02.654] lockmode = [06:20:02.654] matviewOid = 0 [06:20:02.654] #8 0x00000000006d232c in ExecCreateTableAs (pstate=pstate@entry=0x835f87900, stmt=stmt@entry=0x835ef3fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8215eda20) at ../src/backend/commands/createas.c:350 [06:20:02.654] refresh = 0x0 [06:20:02.654] query = 0x835eca918 [06:20:02.654] into = 0x835ecac60 [06:20:02.654] do_refresh = false [06:20:02.654] address = [06:20:02.654] dest = [06:20:02.654] is_matview = [06:20:02.654] #9 0x000000000093cb88 in ProcessUtilitySlow (pstate=pstate@entry=0x835f87900, pstmt=pstmt@entry=0x835deda68, queryString=queryString@entry=0x835dec100 "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=0x8215eda20) at ../src/backend/tcop/utility.c:1675 [06:20:02.654] _local_sigjmp_buf = {{_sjb = {9683897, 0, 34919601736, 34919602112, 34919601744, 12371896, 0, 35265214720, 4294902655, 34919601852, 34919601888, 0}}} [06:20:02.654] _save_exception_stack = 0x8215ed920 [06:20:02.654] _save_context_stack = 0x0 [06:20:02.654] _do_rethrow = false [06:20:02.654] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:20:02.654] parsetree = 0x835ef3fd0 [06:20:02.654] commandCollected = false [06:20:02.654] needCleanup = false [06:20:02.654] address = [06:20:02.654] isTopLevel = [06:20:02.654] isCompleteQuery = [06:20:02.654] #10 0x000000000093b508 in standard_ProcessUtility (pstmt=0x835deda68, queryString=0x835dec100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835ecb148, qc=0x8215eda20) at ../src/backend/tcop/utility.c:1030 [06:20:02.654] isAtomicContext = false [06:20:02.654] parsetree = 0x835ef3fd0 [06:20:02.654] readonly_flags = [06:20:02.654] pstate = 0x835f87900 [06:20:02.654] isTopLevel = [06:20:02.654] #11 0x000000000093af98 in ProcessUtility (pstmt=0x18dd8, queryString=0x6 , readOnlyTree=, context=749347834, params=0x0, queryEnv=0x0, dest=0x835ecb148, qc=0x8215eda20) at ../src/backend/tcop/utility.c:523 [06:20:02.654] No locals. [06:20:02.654] #12 0x000000000093aad3 in PortalRunUtility (portal=0x835ec3100, pstmt=0x835deda68, isTopLevel=, setHoldSnapshot=, dest=0x835ecb148, qc=0x8215eda20) at ../src/backend/tcop/pquery.c:1158 [06:20:02.654] No locals. [06:20:02.654] #13 0x000000000093a164 in PortalRunMulti (portal=portal@entry=0x835ec3100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835ecb148, altdest=altdest@entry=0x835ecb148, qc=0x8215eda20) at ../src/backend/tcop/pquery.c:1323 [06:20:02.654] pstmt = 0x835deda68 [06:20:02.654] stmtlist_item__state = {l = 0x835ecb0f8, i = 0} [06:20:02.654] active_snapshot_set = false [06:20:02.654] stmtlist_item = 0x835ecb110 [06:20:02.654] #14 0x0000000000939a33 in PortalRun (portal=portal@entry=0x835ec3100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835ecb148, altdest=altdest@entry=0x835ecb148, qc=0x8215eda20) at ../src/backend/tcop/pquery.c:791 [06:20:02.654] _local_sigjmp_buf = {{_sjb = {9673133, 35264409856, 34919602456, 34919602688, 34919602464, 35264425984, 12338568, 12371896, 35264398207, 35264603536, 4294967984, 0}}} [06:20:02.654] _save_exception_stack = 0x8215edaf0 [06:20:02.654] _save_context_stack = 0x0 [06:20:02.654] _do_rethrow = false [06:20:02.654] saveTopTransactionResourceOwner = 0x835ed4518 [06:20:02.654] saveTopTransactionContext = 0x835ec7000 [06:20:02.654] saveActivePortal = 0x0 [06:20:02.654] saveResourceOwner = 0x835ed4518 [06:20:02.654] savePortalContext = 0x0 [06:20:02.654] saveMemoryContext = 0x835ec7000 [06:20:02.654] result = [06:20:02.654] nprocessed = [06:20:02.654] #15 0x00000000009388d2 in exec_simple_query (query_string=query_string@entry=0x835dec100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [06:20:02.654] cmdtaglen = 24 [06:20:02.654] snapshot_set = [06:20:02.654] per_parsetree_context = 0x0 [06:20:02.654] plantree_list = [06:20:02.654] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:20:02.654] format = 0 [06:20:02.654] parsetree = 0x835ded6a8 [06:20:02.654] commandTag = [06:20:02.654] cmdtagname = [06:20:02.654] querytree_list = [06:20:02.654] portal = 0x835ec3100 [06:20:02.654] receiver = 0x835ecb148 [06:20:02.654] parsetree_item__state = {l = 0x835deda18, i = 0} [06:20:02.654] msec_str = "\000\000\000\000\b", '\000' , "\244\a\361f\000\000\000\000\224\354\357\375\246\222\207", [06:20:02.654] dest = DestRemote [06:20:02.654] was_logged = [06:20:02.654] oldcontext = 0x835ec7000 [06:20:02.654] parsetree_list = 0x835deda18 [06:20:02.654] use_implicit_block = false [06:20:02.654] parsetree_item = 0x835deda30 [06:20:02.654] save_log_statement_stats = [06:20:02.654] #16 0x0000000000936543 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [06:20:02.654] query_string = 0x835dec100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:20:02.654] input_message = {data = 0x835dec100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:20:02.654] firstchar = [06:20:02.654] local_sigjmp_buf = {{_sjb = {9656822, 34919602928, 34919602888, 34919603472, 12380632, 1, 8192, 8388608, 34919547775, 0, 0, 1}}} [06:20:02.654] send_ready_for_query = false [06:20:02.654] idle_in_transaction_timeout_enabled = false [06:20:02.654] idle_session_timeout_enabled = false [06:20:02.654] #17 0x0000000000930d29 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:20:02.654] bsdata = [06:20:02.654] #18 0x000000000088a8f7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8215ee834 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215ee770) at ../src/backend/postmaster/launch_backend.c:274 [06:20:02.654] pid = [06:20:02.654] #19 0x000000000088ecc8 in BackendStartup (client_sock=0x8215ee770) at ../src/backend/postmaster/postmaster.c:3420 [06:20:02.654] startup_data = {canAcceptConnections = CAC_OK} [06:20:02.654] bn = 0x835df82b8 [06:20:02.654] pid = [06:20:02.654] __error = [06:20:02.654] save_errno = [06:20:02.654] __error = [06:20:02.654] __error = [06:20:02.654] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [06:20:02.654] 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\337\3365\b", '\000' , "\320\347^!\b\000\000\000hՄ+\b\000\000\000\v\000\000\000\000\000\000\000^_\205+\b", '\000' , "\020\350^!\b\000\000\000\244\246\210\000\000\000\000\000 \350^!\b", '\000' }, salen = 16}} [06:20:02.654] i = 0 [06:20:02.654] now = [06:20:02.654] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 748973186, events = 8, fd = 0, user_data = 0x8215ee720}, {pos = 904168920, events = 8, fd = 559867312, user_data = 0x0}, {pos = 0, events = 0, fd = -1406302145, user_data = 0x1f69e783430a}, {pos = 748140448, events = 8, fd = 748211576, user_data = 0x8215ee238}, {pos = 559866544, events = 8, fd = 559866424, user_data = 0x1f69e783430a}, {pos = 748118920, events = 8, fd = 748211576, user_data = 0x8215ee268}, {pos = 559866592, events = 8, fd = 559866472, user_data = 0x82c985194}, {pos = 570942472, events = 8, fd = 748179860, user_data = 0x8215ee2d0}, {pos = -410848198, events = 8041, fd = 750002224, user_data = 0x1}, {pos = 559866624, events = 8, fd = -410828022, user_data = 0x82c96e858}, {pos = 748211576, events = 8, fd = 559866584, user_data = 0x8215ee350}, {pos = 559866584, events = 8, fd = 748174604, user_data = 0x82207e408}, {pos = 748174604, events = 8, fd = 559866688, user_data = 0x1f69e782f43a}, {pos = 559866728, events = 8, fd = 559867176, user_data = 0x8215ee350}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2640271619, fd = 570966072, user_data = 0x800000001}, {pos = 570942472, events = 8, fd = 748118920, user_data = 0x822083288}, {pos = 748087384, events = 8, fd = 570942472, user_data = 0x8215ee3d8}, {pos = 559867288, events = 8, fd = 559866816, user_data = 0x1f69e7833ca2}, {pos = 2701080, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 570966072, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 559867544, user_data = 0x2207e408}, {pos = 559867360, events = 8, fd = 559866960, user_data = 0x1}, {pos = 559867288, events = 8, fd = 32, user_data = 0x8215ee440}, {pos = -410830221, events = 8041, fd = 559867232, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822084038}, {pos = 1, events = 8, fd = 570942472, user_data = 0x82c96e858}, {pos = 559867544, events = 8, fd = 559867360, user_data = 0x8215ee450}, {pos = 0, events = 0, fd = 570912776, user_data = 0x20}, {pos = 559867344, events = 8, fd = -410854681, user_data = 0x822077008}, {pos = 570913800, events = 8, fd = 570914824, user_data = 0x822077c08}, {pos = 570929160, events = 8, fd = 570930184, user_data = 0x82207b808}, {pos = 570932232, events = 8, fd = 570933256, user_data = 0x82207c408}, {pos = 570935304, events = 8, fd = 570936328, user_data = 0x82207d008}, {pos = 570938376, events = 8, fd = 570939400, user_data = 0x82207dc08}, {pos = 570941448, events = 8, fd = 570942472, user_data = 0x82207e808}, {pos = 570944520, events = 8, fd = 570945544, user_data = 0x82207f408}, {pos = 570947592, events = 8, fd = 570948616, user_data = 0x822080008}, {pos = 570950664, events = 8, fd = 570951688, user_data = 0x822080c08}, {pos = 570957832, events = 8, fd = 570958856, user_data = 0x822082808}, {pos = 570960904, events = 8, fd = 570912776, user_data = 0x293718}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822084038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 559867544, events = 8, fd = 559866960, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 570966072, user_data = 0x1}, {pos = 570912776, events = 8, fd = 313, user_data = 0x8215ee680}, {pos = -410855953, events = 8041, fd = 2701080, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 570966072, user_data = 0x1}, {pos = 570942472, events = 8, fd = 903725056, user_data = 0x1}, {pos = 903725460, events = 8, fd = 0, user_data = 0x8215ee650}, {pos = 730158444, events = 8, fd = 1, user_data = 0x835ddc000}, {pos = 559867520, events = 8, fd = 730154754, user_data = 0x82caa0170 }, {pos = 12301568, events = 0, fd = 749338992, user_data = 0x82207e408}, {pos = 559867744, events = 8, fd = -410856482, user_data = 0x835dfa800}, {pos = 1, events = 0, fd = -410856866, user_data = 0x822077008}, {pos = 559867528, events = 8, fd = 559867744, user_data = 0x1c20}, {pos = 903798528, events = 8, fd = -410777200, user_data = 0x0}, {pos = 559809407, events = 8, fd = 8104983, user_data = 0x8215ee710}, {pos = 730117136, events = 8, fd = 750002224, user_data = 0x82cb44310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8215ee740}, {pos = 730160029, events = 8, fd = 903725056, user_data = 0x1d93}, {pos = 559867808, events = 8, fd = 730126586, user_data = 0x0}, {pos = 0, events = 0, fd = -1406302145, user_data = 0x0}} [06:20:02.654] last_touch_time = 1727072145 [06:20:02.654] last_lockfile_recheck_time = 1727072145 [06:20:02.654] nevents = 1 [06:20:02.654] #21 0x000000000088cae5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8215eed80) at ../src/backend/postmaster/postmaster.c:1351 [06:20:02.654] userDoption = [06:20:02.654] listen_addr_saved = [06:20:02.654] output_config_variable = [06:20:02.654] opt = [06:20:02.654] status = [06:20:02.654] #22 0x00000000007c78fc in main (argc=8, argv=0x8215eed80) at ../src/backend/main/main.c:197 [06:20:02.654] do_check_root = [06:20:02.666] [06:20:02.666] [06:20:02.666] [06:20:02.730] dumping /tmp/cores/postgres.11074.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:20:02.849] [New LWP 101827] [06:20:02.909] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [06:20:02.909] Program terminated with signal SIGABRT, Aborted. [06:20:02.909] Sent by thr_kill() from pid 11074 and user 1003. [06:20:02.909] #0 0x000000082ba7541a in thr_kill () from /lib/libc.so.7 [06:20:03.445] [06:20:03.445] Thread 1 (LWP 101827): [06:20:03.445] #0 0x000000082ba7541a in thr_kill () from /lib/libc.so.7 [06:20:03.445] No symbol table info available. [06:20:03.445] #1 0x000000082b9eee64 in raise () from /lib/libc.so.7 [06:20:03.445] No symbol table info available. [06:20:03.445] #2 0x000000082ba9f6f9 in abort () from /lib/libc.so.7 [06:20:03.445] No symbol table info available. [06:20:03.445] #3 0x0000000000a90005 in ExceptionalCondition (conditionName=0x2e7568 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:20:03.445] No locals. [06:20:03.445] #4 0x0000000000764639 in standard_ExecutorStart (queryDesc=0x836b2f088, eflags=0) at ../src/backend/executor/execMain.c:194 [06:20:03.445] estate = 0x836b8d100 [06:20:03.445] oldcontext = 0x836c86800 [06:20:03.445] #5 0x00000000006fae45 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [06:20:03.445] copied_query = [06:20:03.445] rewritten = [06:20:03.445] plan = 0x836c54bd8 [06:20:03.445] queryDesc = 0x836b2f088 [06:20:03.445] processed = [06:20:03.445] __error = [06:20:03.445] #6 RefreshMatViewByOid (matviewOid=27293, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [06:20:03.445] dest = [06:20:03.445] save_userid = 10 [06:20:03.445] save_sec_context = 0 [06:20:03.445] processed = 0 [06:20:03.445] matviewRel = 0x8437472a8 [06:20:03.445] relowner = 10 [06:20:03.445] save_nestlevel = 2 [06:20:03.445] rule = [06:20:03.445] actions = [06:20:03.445] dataQuery = [06:20:03.445] tableSpace = [06:20:03.445] relpersistence = [06:20:03.445] OIDNewHeap = 27305 [06:20:03.445] address = [06:20:03.445] #7 0x00000000006faa26 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:20:03.445] lockmode = [06:20:03.445] matviewOid = 0 [06:20:03.445] #8 0x00000000006d232c in ExecCreateTableAs (pstate=pstate@entry=0x836c86900, stmt=stmt@entry=0x836b7cfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8210f5340) at ../src/backend/commands/createas.c:350 [06:20:03.445] refresh = 0x0 [06:20:03.445] query = 0x836ba0118 [06:20:03.445] into = 0x836ba0460 [06:20:03.445] do_refresh = false [06:20:03.445] address = [06:20:03.445] dest = [06:20:03.445] is_matview = [06:20:03.445] #9 0x000000000093cb88 in ProcessUtilitySlow (pstate=pstate@entry=0x836c86900, pstmt=pstmt@entry=0x836ab8a68, queryString=queryString@entry=0x836ab7100 "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=0x8210f5340) at ../src/backend/tcop/utility.c:1675 [06:20:03.445] _local_sigjmp_buf = {{_sjb = {9683897, 0, 34914389864, 34914390240, 34914389872, 12371896, 0, 35278842112, 4294902655, 34914389980, 34914390016, 0}}} [06:20:03.445] _save_exception_stack = 0x8210f5240 [06:20:03.445] _save_context_stack = 0x0 [06:20:03.445] _do_rethrow = false [06:20:03.445] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:20:03.445] parsetree = 0x836b7cfd0 [06:20:03.445] commandCollected = false [06:20:03.445] needCleanup = false [06:20:03.445] address = [06:20:03.445] isTopLevel = [06:20:03.445] isCompleteQuery = [06:20:03.445] #10 0x000000000093b508 in standard_ProcessUtility (pstmt=0x836ab8a68, queryString=0x836ab7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836ba0948, qc=0x8210f5340) at ../src/backend/tcop/utility.c:1030 [06:20:03.445] isAtomicContext = false [06:20:03.445] parsetree = 0x836b7cfd0 [06:20:03.445] readonly_flags = [06:20:03.445] pstate = 0x836c86900 [06:20:03.445] isTopLevel = [06:20:03.445] #11 0x000000000093af98 in ProcessUtility (pstmt=0x18dc3, queryString=0x6 , readOnlyTree=, context=732386298, params=0x0, queryEnv=0x0, dest=0x836ba0948, qc=0x8210f5340) at ../src/backend/tcop/utility.c:523 [06:20:03.445] No locals. [06:20:03.445] #12 0x000000000093aad3 in PortalRunUtility (portal=0x836b5d100, pstmt=0x836ab8a68, isTopLevel=, setHoldSnapshot=, dest=0x836ba0948, qc=0x8210f5340) at ../src/backend/tcop/pquery.c:1158 [06:20:03.445] No locals. [06:20:03.445] #13 0x000000000093a164 in PortalRunMulti (portal=portal@entry=0x836b5d100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x836ba0948, altdest=altdest@entry=0x836ba0948, qc=0x8210f5340) at ../src/backend/tcop/pquery.c:1323 [06:20:03.445] pstmt = 0x836ab8a68 [06:20:03.445] stmtlist_item__state = {l = 0x836ba08f8, i = 0} [06:20:03.445] active_snapshot_set = false [06:20:03.445] stmtlist_item = 0x836ba0910 [06:20:03.445] #14 0x0000000000939a33 in PortalRun (portal=portal@entry=0x836b5d100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x836ba0948, altdest=altdest@entry=0x836ba0948, qc=0x8210f5340) at ../src/backend/tcop/pquery.c:791 [06:20:03.445] _local_sigjmp_buf = {{_sjb = {9673133, 35277623552, 34914390584, 34914390816, 34914390592, 35277639680, 12338568, 12371896, 35277570943, 35277747600, 4294967984, 0}}} [06:20:03.445] _save_exception_stack = 0x8210f5410 [06:20:03.445] _save_context_stack = 0x0 [06:20:03.445] _do_rethrow = false [06:20:03.445] saveTopTransactionResourceOwner = 0x836bacb18 [06:20:03.445] saveTopTransactionContext = 0x836b61000 [06:20:03.445] saveActivePortal = 0x0 [06:20:03.445] saveResourceOwner = 0x836bacb18 [06:20:03.445] savePortalContext = 0x0 [06:20:03.445] saveMemoryContext = 0x836b61000 [06:20:03.445] result = [06:20:03.445] nprocessed = [06:20:03.445] #15 0x00000000009388d2 in exec_simple_query (query_string=query_string@entry=0x836ab7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [06:20:03.445] cmdtaglen = 24 [06:20:03.445] snapshot_set = [06:20:03.445] per_parsetree_context = 0x0 [06:20:03.445] plantree_list = [06:20:03.445] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:20:03.445] format = 0 [06:20:03.445] parsetree = 0x836ab86a8 [06:20:03.445] commandTag = [06:20:03.445] cmdtagname = [06:20:03.445] querytree_list = [06:20:03.445] portal = 0x836b5d100 [06:20:03.445] receiver = 0x836ba0948 [06:20:03.445] parsetree_item__state = {l = 0x836ab8a18, i = 0} [06:20:03.445] msec_str = "\000\000\000\000\b", '\000' , "\247\a\361f\000\000\000\000\220G$Mz\340", [06:20:03.445] dest = DestRemote [06:20:03.445] was_logged = [06:20:03.445] oldcontext = 0x836b61000 [06:20:03.445] parsetree_list = 0x836ab8a18 [06:20:03.445] use_implicit_block = false [06:20:03.445] parsetree_item = 0x836ab8a30 [06:20:03.445] save_log_statement_stats = [06:20:03.445] #16 0x0000000000936543 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [06:20:03.445] query_string = 0x836ab7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:20:03.445] input_message = {data = 0x836ab7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:20:03.445] firstchar = [06:20:03.445] local_sigjmp_buf = {{_sjb = {9656822, 34914391056, 34914391016, 34914391600, 12380632, 1, 8192, 8388608, 34914370431, 0, 0, 1}}} [06:20:03.445] send_ready_for_query = false [06:20:03.445] idle_in_transaction_timeout_enabled = false [06:20:03.445] idle_session_timeout_enabled = false [06:20:03.445] #17 0x0000000000930d29 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:20:03.445] bsdata = [06:20:03.445] #18 0x000000000088a8f7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8210f6154 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8210f6090) at ../src/backend/postmaster/launch_backend.c:274 [06:20:03.445] pid = [06:20:03.445] #19 0x000000000088ecc8 in BackendStartup (client_sock=0x8210f6090) at ../src/backend/postmaster/postmaster.c:3420 [06:20:03.445] startup_data = {canAcceptConnections = CAC_OK} [06:20:03.445] bn = 0x836ac31c8 [06:20:03.445] pid = [06:20:03.445] __error = [06:20:03.445] save_errno = [06:20:03.445] __error = [06:20:03.445] __error = [06:20:03.445] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [06:20:03.445] 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\216\2536\b", '\000' , "\360`\017!\b\000\000\000h%\350)\b\000\000\000\v\000\000\000\000\000\000\000^\257\350)\b", '\000' , "0a\017!\b\000\000\000\244\246\210\000\000\000\000\000@a\017!\b", '\000' }, salen = 16}} [06:20:03.445] i = 0 [06:20:03.445] now = [06:20:03.445] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 732011650, events = 8, fd = 0, user_data = 0x8210f6040}, {pos = 917640664, events = 8, fd = 554655440, user_data = 0x0}, {pos = 0, events = 0, fd = 837262068, user_data = 0x20fb189f730a}, {pos = 731178912, events = 8, fd = 731250040, user_data = 0x8210f5b58}, {pos = 554654672, events = 8, fd = 554654552, user_data = 0x20fb189f730a}, {pos = 731157384, events = 8, fd = 731250040, user_data = 0x8210f5b88}, {pos = 554654720, events = 8, fd = 554654600, user_data = 0x82b958194}, {pos = 560972808, events = 8, fd = 731218324, user_data = 0x8210f5bf0}, {pos = 413082682, events = 8443, fd = 733040688, user_data = 0x1}, {pos = 554654752, events = 8, fd = 413102858, user_data = 0x82b941858}, {pos = 731250040, events = 8, fd = 554654712, user_data = 0x8210f5c70}, {pos = 554654712, events = 8, fd = 731213068, user_data = 0x8216fc408}, {pos = 731213068, events = 8, fd = 554654816, user_data = 0x20fb189f243a}, {pos = 554654856, events = 8, fd = 554655304, user_data = 0x8210f5c70}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1534821171, fd = 560996408, user_data = 0x800000001}, {pos = 560972808, events = 8, fd = 731157384, user_data = 0x821701288}, {pos = 731125848, events = 8, fd = 560972808, user_data = 0x8210f5cf8}, {pos = 554655416, events = 8, fd = 554654944, user_data = 0x20fb189f6ca2}, {pos = 2701080, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560996408, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554655672, user_data = 0x216fc408}, {pos = 554655488, events = 8, fd = 554655088, user_data = 0x1}, {pos = 554655416, events = 8, fd = 32, user_data = 0x8210f5d60}, {pos = 413100659, events = 8443, fd = 554655360, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821702038}, {pos = 1, events = 8, fd = 560972808, user_data = 0x82b941858}, {pos = 554655672, events = 8, fd = 554655488, user_data = 0x8210f5d70}, {pos = 0, events = 0, fd = 560943112, user_data = 0x20}, {pos = 554655472, events = 8, fd = 413076199, user_data = 0x8216f5008}, {pos = 560944136, events = 8, fd = 560945160, user_data = 0x8216f5c08}, {pos = 560959496, events = 8, fd = 560960520, user_data = 0x8216f9808}, {pos = 560962568, events = 8, fd = 560963592, user_data = 0x8216fa408}, {pos = 560965640, events = 8, fd = 560966664, user_data = 0x8216fb008}, {pos = 560968712, events = 8, fd = 560969736, user_data = 0x8216fbc08}, {pos = 560971784, events = 8, fd = 560972808, user_data = 0x8216fc808}, {pos = 560974856, events = 8, fd = 560975880, user_data = 0x8216fd408}, {pos = 560977928, events = 8, fd = 560978952, user_data = 0x8216fe008}, {pos = 560981000, events = 8, fd = 560982024, user_data = 0x8216fec08}, {pos = 560988168, events = 8, fd = 560989192, user_data = 0x821700808}, {pos = 560991240, events = 8, fd = 560943112, user_data = 0x293718}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821702038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554655672, events = 8, fd = 554655088, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560996408, user_data = 0x1}, {pos = 560943112, events = 8, fd = 313, user_data = 0x8210f5fa0}, {pos = 413074927, events = 8443, fd = 2701080, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560996408, user_data = 0x1}, {pos = 560972808, events = 8, fd = 917139456, user_data = 0x1}, {pos = 917139860, events = 8, fd = 0, user_data = 0x8210f5f70}, {pos = 703112556, events = 8, fd = 1, user_data = 0x836aa7000}, {pos = 554655648, events = 8, fd = 703108866, user_data = 0x82ba73170 }, {pos = 12301568, events = 0, fd = 732377456, user_data = 0x8216fc408}, {pos = 554655872, events = 8, fd = 413074398, user_data = 0x836ac5800}, {pos = 1, events = 0, fd = 413074014, user_data = 0x8216f5008}, {pos = 554655656, events = 8, fd = 554655872, user_data = 0x1c20}, {pos = 917212864, events = 8, fd = 413153680, user_data = 0x0}, {pos = 554632063, events = 8, fd = 8104983, user_data = 0x8210f6030}, {pos = 703071248, events = 8, fd = 733040688, user_data = 0x82bb17310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8210f6060}, {pos = 703114141, events = 8, fd = 917139456, user_data = 0x1ded}, {pos = 554655936, events = 8, fd = 703080698, user_data = 0x0}, {pos = 0, events = 0, fd = 837262068, user_data = 0x0}} [06:20:03.445] last_touch_time = 1727072146 [06:20:03.445] last_lockfile_recheck_time = 1727072146 [06:20:03.445] nevents = 1 [06:20:03.445] #21 0x000000000088cae5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8210f66a8) at ../src/backend/postmaster/postmaster.c:1351 [06:20:03.445] userDoption = [06:20:03.445] listen_addr_saved = [06:20:03.445] output_config_variable = [06:20:03.445] opt = [06:20:03.445] status = [06:20:03.445] #22 0x00000000007c78fc in main (argc=4, argv=0x8210f66a8) at ../src/backend/main/main.c:197 [06:20:03.445] do_check_root = [06:20:03.456] [06:20:03.456] [06:20:03.456] [06:20:03.518] dumping /tmp/cores/postgres.17351.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:20:03.636] [New LWP 100172] [06:20:03.701] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [06:20:03.701] Program terminated with signal SIGABRT, Aborted. [06:20:03.701] Sent by thr_kill() from pid 17351 and user 1003. [06:20:03.701] #0 0x000000082e53a41a in thr_kill () from /lib/libc.so.7 [06:20:04.256] [06:20:04.256] Thread 1 (LWP 100172): [06:20:04.256] #0 0x000000082e53a41a in thr_kill () from /lib/libc.so.7 [06:20:04.256] No symbol table info available. [06:20:04.256] #1 0x000000082e4b3e64 in raise () from /lib/libc.so.7 [06:20:04.256] No symbol table info available. [06:20:04.256] #2 0x000000082e5646f9 in abort () from /lib/libc.so.7 [06:20:04.256] No symbol table info available. [06:20:04.256] #3 0x0000000000a90005 in ExceptionalCondition (conditionName=0x2e7568 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:20:04.256] No locals. [06:20:04.256] #4 0x0000000000764639 in standard_ExecutorStart (queryDesc=0x837851088, eflags=0) at ../src/backend/executor/execMain.c:194 [06:20:04.256] estate = 0x83780c100 [06:20:04.256] oldcontext = 0x837850800 [06:20:04.256] #5 0x0000000839bb8862 in pgss_ExecutorStart (queryDesc=0x837851088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [06:20:04.256] No locals. [06:20:04.256] #6 0x00000000006fae45 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [06:20:04.256] copied_query = [06:20:04.256] rewritten = [06:20:04.256] plan = 0x837849bd8 [06:20:04.256] queryDesc = 0x837851088 [06:20:04.256] processed = [06:20:04.256] __error = [06:20:04.256] #7 RefreshMatViewByOid (matviewOid=27494, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [06:20:04.256] dest = [06:20:04.256] save_userid = 10 [06:20:04.256] save_sec_context = 0 [06:20:04.256] processed = 0 [06:20:04.256] matviewRel = 0x83d2dd068 [06:20:04.256] relowner = 10 [06:20:04.256] save_nestlevel = 2 [06:20:04.256] rule = [06:20:04.256] actions = [06:20:04.256] dataQuery = [06:20:04.256] tableSpace = [06:20:04.256] relpersistence = [06:20:04.256] OIDNewHeap = 27501 [06:20:04.256] address = [06:20:04.256] #8 0x00000000006faa26 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:20:04.256] lockmode = [06:20:04.256] matviewOid = 0 [06:20:04.256] #9 0x00000000006d232c in ExecCreateTableAs (pstate=pstate@entry=0x837850900, stmt=stmt@entry=0x837769fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821668960) at ../src/backend/commands/createas.c:350 [06:20:04.256] refresh = 0x0 [06:20:04.256] query = 0x8377b4b88 [06:20:04.256] into = 0x837769f40 [06:20:04.256] do_refresh = false [06:20:04.256] address = [06:20:04.256] dest = [06:20:04.256] is_matview = [06:20:04.256] #10 0x000000000093cb88 in ProcessUtilitySlow (pstate=pstate@entry=0x837850900, pstmt=pstmt@entry=0x837769e30, queryString=queryString@entry=0x8376cc100 "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=0x821668960) at ../src/backend/tcop/utility.c:1675 [06:20:04.256] _local_sigjmp_buf = {{_sjb = {9683897, 0, 34920104904, 34920105280, 34920104912, 12371896, 0, 35291203840, 34920072063, 7, 34920105056, 0}}} [06:20:04.256] _save_exception_stack = 0x821668650 [06:20:04.256] _save_context_stack = 0x0 [06:20:04.256] _do_rethrow = false [06:20:04.256] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:20:04.256] parsetree = 0x837769fd0 [06:20:04.256] commandCollected = false [06:20:04.256] needCleanup = false [06:20:04.256] address = [06:20:04.256] isTopLevel = [06:20:04.256] isCompleteQuery = [06:20:04.256] #11 0x000000000093b508 in standard_ProcessUtility (pstmt=0x837769e30, queryString=queryString@entry=0x8376cc100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8377b5328, qc=0x821668960) at ../src/backend/tcop/utility.c:1030 [06:20:04.256] isAtomicContext = false [06:20:04.256] parsetree = 0x837769fd0 [06:20:04.256] readonly_flags = [06:20:04.256] pstate = 0x837850900 [06:20:04.256] isTopLevel = [06:20:04.256] #12 0x0000000839bb8dee in pgss_ProcessUtility (pstmt=0x837769e30, queryString=0x8376cc100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8377b5328, qc=0x821668960) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [06:20:04.256] _local_sigjmp_buf = {{_sjb = {35328331047, 34920105552, 34920105416, 34920105872, 35290258992, 0, 12371896, 34920106080, 34920072063, 34920105652, 34920105680, 0}}} [06:20:04.256] _save_exception_stack = 0x821668860 [06:20:04.256] _save_context_stack = 0x0 [06:20:04.256] _do_rethrow = false [06:20:04.256] bufusage = {shared_blks_hit = 35328331047, shared_blks_read = 34920105552, shared_blks_dirtied = 34920105416, shared_blks_written = 34920105872, local_blks_hit = 35290258992, local_blks_read = 0, local_blks_dirtied = 12371896, local_blks_written = 34920106080, temp_blks_read = 34920072063, temp_blks_written = 34920105652, shared_blk_read_time = {ticks = 34920105680}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4219834373220788480}, local_blk_write_time = {ticks = 12380936}, temp_blk_read_time = {ticks = 35346430208}, temp_blk_write_time = {ticks = 12334512}} [06:20:04.256] walusage_start = {wal_records = 8928, wal_fpi = 124, wal_bytes = 1186651} [06:20:04.256] duration = [06:20:04.256] bufusage_start = {shared_blks_hit = 154216, shared_blks_read = 8464, shared_blks_dirtied = 2647, shared_blks_written = 2205, 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}} [06:20:04.256] walusage = {wal_records = 4475786511367426005, wal_fpi = 35290259408, wal_bytes = 123} [06:20:04.256] start = {ticks = -184857392165} [06:20:04.256] rows = [06:20:04.256] saved_queryId = 6041762721901209185 [06:20:04.256] parsetree = [06:20:04.256] saved_stmt_location = 0 [06:20:04.256] saved_stmt_len = 69 [06:20:04.256] enabled = [06:20:04.256] #13 0x000000000093aad3 in PortalRunUtility (portal=0x837774100, pstmt=0x837769e30, isTopLevel=, setHoldSnapshot=, dest=0x8377b5328, qc=0x821668960) at ../src/backend/tcop/pquery.c:1158 [06:20:04.256] No locals. [06:20:04.256] #14 0x000000000093a164 in PortalRunMulti (portal=portal@entry=0x837774100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8377b5328, altdest=altdest@entry=0x8377b5328, qc=0x821668960) at ../src/backend/tcop/pquery.c:1323 [06:20:04.256] pstmt = 0x837769e30 [06:20:04.256] stmtlist_item__state = {l = 0x8377b52d8, i = 0} [06:20:04.256] active_snapshot_set = false [06:20:04.256] stmtlist_item = 0x8377b52f0 [06:20:04.256] #15 0x0000000000939a33 in PortalRun (portal=portal@entry=0x837774100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8377b5328, altdest=altdest@entry=0x8377b5328, qc=0x821668960) at ../src/backend/tcop/pquery.c:791 [06:20:04.256] _local_sigjmp_buf = {{_sjb = {9673133, 35290300672, 34920106072, 34920106304, 34920106080, 35290394624, 12338568, 12371896, 35290284927, 35290252768, 4294967984, 0}}} [06:20:04.256] _save_exception_stack = 0x821668a30 [06:20:04.256] _save_context_stack = 0x0 [06:20:04.256] _do_rethrow = false [06:20:04.256] saveTopTransactionResourceOwner = 0x8377c2358 [06:20:04.256] saveTopTransactionContext = 0x83778b000 [06:20:04.256] saveActivePortal = 0x0 [06:20:04.256] saveResourceOwner = 0x8377c2358 [06:20:04.256] savePortalContext = 0x0 [06:20:04.256] saveMemoryContext = 0x83778b000 [06:20:04.256] result = [06:20:04.256] nprocessed = [06:20:04.256] #16 0x00000000009388d2 in exec_simple_query (query_string=query_string@entry=0x8376cc100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [06:20:04.256] cmdtaglen = 24 [06:20:04.256] snapshot_set = [06:20:04.256] per_parsetree_context = 0x0 [06:20:04.256] plantree_list = [06:20:04.256] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:20:04.256] format = 0 [06:20:04.256] parsetree = 0x8376cd6a8 [06:20:04.256] commandTag = [06:20:04.256] cmdtagname = [06:20:04.256] querytree_list = [06:20:04.256] portal = 0x837774100 [06:20:04.256] receiver = 0x8377b5328 [06:20:04.256] parsetree_item__state = {l = 0x8376cda18, i = 0} [06:20:04.256] msec_str = "\000\000\000\000\b", '\000' , "\312\a\361f\000\000\000\000\250\245\225?\257%Ȍ" [06:20:04.256] dest = DestRemote [06:20:04.256] was_logged = [06:20:04.256] oldcontext = 0x83778b000 [06:20:04.256] parsetree_list = 0x8376cda18 [06:20:04.256] use_implicit_block = false [06:20:04.256] parsetree_item = 0x8376cda30 [06:20:04.256] save_log_statement_stats = [06:20:04.256] #17 0x0000000000936543 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [06:20:04.256] query_string = 0x8376cc100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:20:04.256] input_message = {data = 0x8376cc100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:20:04.256] firstchar = [06:20:04.256] local_sigjmp_buf = {{_sjb = {9656822, 34920106544, 34920106504, 34920107088, 12380632, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [06:20:04.256] send_ready_for_query = false [06:20:04.256] idle_in_transaction_timeout_enabled = false [06:20:04.256] idle_session_timeout_enabled = false [06:20:04.256] #18 0x0000000000930d29 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:20:04.256] bsdata = [06:20:04.256] #19 0x000000000088a8f7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821669774 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8216696b0) at ../src/backend/postmaster/launch_backend.c:274 [06:20:04.256] pid = [06:20:04.256] #20 0x000000000088ecc8 in BackendStartup (client_sock=0x8216696b0) at ../src/backend/postmaster/postmaster.c:3420 [06:20:04.256] startup_data = {canAcceptConnections = CAC_OK} [06:20:04.256] bn = 0x8376d8358 [06:20:04.256] pid = [06:20:04.256] __error = [06:20:04.256] save_errno = [06:20:04.256] __error = [06:20:04.256] __error = [06:20:04.256] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [06:20:04.256] 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 = " \314l7\b", '\000' , "\020\227f!\b\000\000\000h\325',\b\000\000\000\v\000\000\000\000\000\000\000^_(,\b", '\000' , "P\227f!\b\000\000\000\244\246\210\000\000\000\000\000`\227f!\b", '\000' }, salen = 16}} [06:20:04.256] i = 0 [06:20:04.256] now = [06:20:04.256] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 776858754, events = 8, fd = 0, user_data = 0x821669660}, {pos = 930280920, events = 8, fd = 560370928, user_data = 0x0}, {pos = -696716534, events = 10071, fd = 776026016, user_data = 0x82e424d78}, {pos = 560370024, events = 8, fd = 560370144, user_data = 0x821669168}, {pos = -696716534, events = 10071, fd = 776004488, user_data = 0x82e424d78}, {pos = 560370072, events = 8, fd = 560370192, user_data = 0x821669198}, {pos = 776065428, events = 8, fd = 575525896, user_data = 0x82e41d194}, {pos = 560370176, events = 8, fd = -696736710, user_data = 0x8216691a0}, {pos = 740799504, events = 8, fd = 777887792, user_data = 0x2757d678f30a}, {pos = 775972952, events = 8, fd = 776097144, user_data = 0x821669208}, {pos = 560370304, events = 8, fd = 560370184, user_data = 0x82e41bd0c}, {pos = 575525896, events = 8, fd = 776060172, user_data = 0x821669270}, {pos = -696736710, events = 10071, fd = 560370328, user_data = 0x821669468}, {pos = 560370304, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8224e3038}, {pos = 1, events = 1042100254, fd = 575525896, user_data = 0x82e40e388}, {pos = 575547336, events = 8, fd = 0, user_data = 0x0}, {pos = 560370440, events = 8, fd = 560370904, user_data = 0x8216692f0}, {pos = -696718174, events = 10071, fd = 2701080, user_data = 0x6d68b}, {pos = 2090263927, events = 1042100254, fd = 575549496, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8216695d8}, {pos = 575525896, events = 3, fd = 560370976, user_data = 0x8224e2828}, {pos = 656, events = 0, fd = 560370904, user_data = 0x821669308}, {pos = 560370544, events = 8, fd = -696718565, user_data = 0x8216694a0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 575549496, events = 8, fd = 1, user_data = 0x8224dd408}, {pos = 775972952, events = 8, fd = 560371160, user_data = 0x821669520}, {pos = 560370560, events = 8, fd = 0, user_data = 0x8224d6008}, {pos = 33, events = 0, fd = 560370960, user_data = 0x2757d6788ae7}, {pos = 575496200, events = 8, fd = 575497224, user_data = 0x8224d6808}, {pos = 575499272, events = 8, fd = 575512584, user_data = 0x8224da408}, {pos = 575514632, events = 8, fd = 575515656, user_data = 0x8224db008}, {pos = 575517704, events = 8, fd = 575518728, user_data = 0x8224dbc08}, {pos = 575520776, events = 8, fd = 575521800, user_data = 0x8224dc808}, {pos = 575523848, events = 8, fd = 575524872, user_data = 0x8224dd408}, {pos = 575526920, events = 8, fd = 575527944, user_data = 0x8224de008}, {pos = 575529992, events = 8, fd = 575531016, user_data = 0x8224dec08}, {pos = 575533064, events = 8, fd = 575534088, user_data = 0x8224df808}, {pos = 575536136, events = 8, fd = 575541256, user_data = 0x8224e1408}, {pos = 575543304, events = 8, fd = 575544328, user_data = 0x8224e4408}, {pos = 385494000, events = 0, fd = 575496200, user_data = 0x293718}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8224e3038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 560371160, events = 8, fd = 560370560, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 575549496, user_data = 0x1}, {pos = 575496200, events = 8, fd = 313, user_data = 0x8216695c0}, {pos = -696744465, events = 10071, fd = 2701080, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 575549496, user_data = 0x1}, {pos = 575525896, events = 8, fd = 929808384, user_data = 0x1}, {pos = 929808788, events = 8, fd = 0, user_data = 0x821669590}, {pos = 740840812, events = 8, fd = 1, user_data = 0x8376bc000}, {pos = 560371136, events = 8, fd = 740837122, user_data = 0x82e538170 }, {pos = 12301568, events = 0, fd = 777224560, user_data = 0x8224dd408}, {pos = 560371360, events = 8, fd = -696744994, user_data = 0x8376da800}, {pos = 1, events = 0, fd = -696745378, user_data = 0x8224d6008}, {pos = 560371144, events = 8, fd = 560371360, user_data = 0x1c20}, {pos = 929877024, events = 8, fd = -696665712, user_data = 0x0}, {pos = 560333695, events = 8, fd = 8104983, user_data = 0x821669650}, {pos = 740799504, events = 8, fd = 777887792, user_data = 0x82e5dc310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821669680}, {pos = 740842397, events = 8, fd = 929808384, user_data = 0x3607}, {pos = 560371424, events = 8, fd = 740808954, user_data = 0x0}, {pos = 0, events = 0, fd = 1284132821, user_data = 0x0}} [06:20:04.257] last_touch_time = 1727072178 [06:20:04.257] last_lockfile_recheck_time = 1727072178 [06:20:04.257] nevents = 1 [06:20:04.257] #22 0x000000000088cae5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821669cc8) at ../src/backend/postmaster/postmaster.c:1351 [06:20:04.257] userDoption = [06:20:04.257] listen_addr_saved = [06:20:04.257] output_config_variable = [06:20:04.257] opt = [06:20:04.257] status = [06:20:04.257] #23 0x00000000007c78fc in main (argc=4, argv=0x821669cc8) at ../src/backend/main/main.c:197 [06:20:04.257] do_check_root =