[07:59:32.885] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [07:59:33.230] dumping /tmp/cores/postgres.10784.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:59:33.366] [New LWP 101901] [07:59:33.460] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [07:59:33.460] Program terminated with signal SIGABRT, Aborted. [07:59:33.460] Sent by thr_kill() from pid 10784 and user 1003. [07:59:33.460] #0 0x000000082b56441a in thr_kill () from /lib/libc.so.7 [07:59:33.518] [07:59:33.518] Thread 1 (LWP 101901): [07:59:33.518] #0 0x000000082b56441a in thr_kill () from /lib/libc.so.7 [07:59:33.518] No symbol table info available. [07:59:33.518] #1 0x000000082b4dde64 in raise () from /lib/libc.so.7 [07:59:33.518] No symbol table info available. [07:59:33.518] #2 0x000000082b58e6f9 in abort () from /lib/libc.so.7 [07:59:33.518] No symbol table info available. [07:59:33.518] #3 0x0000000000a98e55 in ExceptionalCondition (conditionName=0x2e7ee6 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [07:59:33.518] No locals. [07:59:33.518] #4 0x0000000000768eb9 in standard_ExecutorStart (queryDesc=0x836cdc088, eflags=0) at ../src/backend/executor/execMain.c:194 [07:59:33.518] estate = 0x836d9f100 [07:59:33.518] oldcontext = 0x843040400 [07:59:33.518] #5 0x00000000006fecb5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [07:59:33.518] copied_query = [07:59:33.518] rewritten = [07:59:33.518] plan = 0x836d42bd8 [07:59:33.518] queryDesc = 0x836cdc088 [07:59:33.518] processed = [07:59:33.518] __error = [07:59:33.518] #6 RefreshMatViewByOid (matviewOid=28191, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [07:59:33.518] dest = [07:59:33.518] save_userid = 10 [07:59:33.518] save_sec_context = 0 [07:59:33.518] processed = 0 [07:59:33.518] matviewRel = 0x843186258 [07:59:33.518] relowner = 10 [07:59:33.518] save_nestlevel = 2 [07:59:33.518] rule = [07:59:33.518] actions = [07:59:33.518] dataQuery = [07:59:33.518] tableSpace = [07:59:33.518] relpersistence = [07:59:33.518] OIDNewHeap = 28198 [07:59:33.518] address = [07:59:33.518] #7 0x00000000006fe896 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [07:59:33.518] lockmode = [07:59:33.518] matviewOid = 0 [07:59:33.518] #8 0x00000000006d59ac in ExecCreateTableAs (pstate=pstate@entry=0x843040500, stmt=stmt@entry=0x836cfafd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821b8e250) at ../src/backend/commands/createas.c:351 [07:59:33.518] refresh = 0x0 [07:59:33.518] query = 0x843078e58 [07:59:33.518] into = 0x8430791a0 [07:59:33.518] jstate = 0x0 [07:59:33.518] do_refresh = false [07:59:33.518] address = [07:59:33.518] dest = [07:59:33.518] is_matview = [07:59:33.518] #9 0x0000000000944a38 in ProcessUtilitySlow (pstate=pstate@entry=0x843040500, pstmt=pstmt@entry=0x836c3ca68, queryString=queryString@entry=0x836c3b100 "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=0x821b8e250) at ../src/backend/tcop/utility.c:1678 [07:59:33.518] _local_sigjmp_buf = {{_sjb = {9716329, 0, 34925502072, 34925502448, 34925502080, 12404328, 0, 35484075264, 4294902655, 34925502188, 34925502224, 0}}} [07:59:33.518] _save_exception_stack = 0x821b8e150 [07:59:33.518] _save_context_stack = 0x0 [07:59:33.518] _do_rethrow = false [07:59:33.518] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [07:59:33.518] parsetree = 0x836cfafd0 [07:59:33.518] commandCollected = false [07:59:33.518] needCleanup = false [07:59:33.518] address = [07:59:33.518] isTopLevel = [07:59:33.518] isCompleteQuery = [07:59:33.518] #10 0x00000000009433b8 in standard_ProcessUtility (pstmt=0x836c3ca68, queryString=0x836c3b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x843079688, qc=0x821b8e250) at ../src/backend/tcop/utility.c:1033 [07:59:33.518] isAtomicContext = false [07:59:33.518] parsetree = 0x836cfafd0 [07:59:33.518] readonly_flags = [07:59:33.518] pstate = 0x843040500 [07:59:33.518] isTopLevel = [07:59:33.518] #11 0x0000000000942e48 in ProcessUtility (pstmt=0x18e0d, queryString=0x6 , readOnlyTree=, context=727073786, params=0x0, queryEnv=0x0, dest=0x843079688, qc=0x821b8e250) at ../src/backend/tcop/utility.c:523 [07:59:33.518] No locals. [07:59:33.518] #12 0x0000000000942983 in PortalRunUtility (portal=0x836d12100, pstmt=0x836c3ca68, isTopLevel=, setHoldSnapshot=, dest=0x843079688, qc=0x821b8e250) at ../src/backend/tcop/pquery.c:1158 [07:59:33.518] No locals. [07:59:33.518] #13 0x0000000000942014 in PortalRunMulti (portal=portal@entry=0x836d12100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x843079688, altdest=altdest@entry=0x843079688, qc=0x821b8e250) at ../src/backend/tcop/pquery.c:1322 [07:59:33.518] pstmt = 0x836c3ca68 [07:59:33.518] stmtlist_item__state = {l = 0x843079638, i = 0} [07:59:33.518] active_snapshot_set = false [07:59:33.518] stmtlist_item = 0x843079650 [07:59:33.518] #14 0x00000000009418e3 in PortalRun (portal=portal@entry=0x836d12100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x843079688, altdest=altdest@entry=0x843079688, qc=0x821b8e250) at ../src/backend/tcop/pquery.c:791 [07:59:33.518] _local_sigjmp_buf = {{_sjb = {9705565, 35279413504, 34925502792, 34925503024, 34925502800, 35279925248, 12370936, 12404328, 35279405951, 35279312272, 4294967984, 0}}} [07:59:33.518] _save_exception_stack = 0x821b8e320 [07:59:33.518] _save_context_stack = 0x0 [07:59:33.518] _do_rethrow = false [07:59:33.518] saveTopTransactionResourceOwner = 0x836d23a58 [07:59:33.518] saveTopTransactionContext = 0x836d8f000 [07:59:33.518] saveActivePortal = 0x0 [07:59:33.518] saveResourceOwner = 0x836d23a58 [07:59:33.518] savePortalContext = 0x0 [07:59:33.518] saveMemoryContext = 0x836d8f000 [07:59:33.518] result = [07:59:33.518] nprocessed = [07:59:33.518] #15 0x0000000000940782 in exec_simple_query (query_string=query_string@entry=0x836c3b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [07:59:33.518] cmdtaglen = 24 [07:59:33.518] snapshot_set = [07:59:33.518] per_parsetree_context = 0x0 [07:59:33.518] plantree_list = [07:59:33.518] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:59:33.518] format = 0 [07:59:33.518] parsetree = 0x836c3c6a8 [07:59:33.518] commandTag = [07:59:33.518] cmdtagname = [07:59:33.518] querytree_list = [07:59:33.518] portal = 0x836d12100 [07:59:33.518] receiver = 0x843079688 [07:59:33.518] parsetree_item__state = {l = 0x836c3ca18, i = 0} [07:59:33.518] msec_str = "\000\000\000\000\b", '\000' , "\340f0g\000\000\000\000=孊t,{#" [07:59:33.518] dest = DestRemote [07:59:33.518] was_logged = [07:59:33.518] oldcontext = 0x836d8f000 [07:59:33.518] parsetree_list = 0x836c3ca18 [07:59:33.518] use_implicit_block = false [07:59:33.518] parsetree_item = 0x836c3ca30 [07:59:33.518] save_log_statement_stats = [07:59:33.518] #16 0x000000000093e3f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [07:59:33.518] query_string = 0x836c3b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [07:59:33.518] input_message = {data = 0x836c3b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [07:59:33.518] firstchar = [07:59:33.518] local_sigjmp_buf = {{_sjb = {9689254, 34925503264, 34925503224, 34925503808, 12413064, 1, 8192, 8388608, 34925446015, 0, 0, 1}}} [07:59:33.518] send_ready_for_query = false [07:59:33.518] idle_in_transaction_timeout_enabled = false [07:59:33.518] idle_session_timeout_enabled = false [07:59:33.518] #17 0x0000000000938bd9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:59:33.518] bsdata = [07:59:33.518] #18 0x0000000000890847 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821b8f064 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821b8efa0) at ../src/backend/postmaster/launch_backend.c:266 [07:59:33.518] pid = [07:59:33.518] #19 0x0000000000894c18 in BackendStartup (client_sock=0x821b8efa0) at ../src/backend/postmaster/postmaster.c:3417 [07:59:33.518] startup_data = {canAcceptConnections = CAC_OK} [07:59:33.518] bn = 0x836c47128 [07:59:33.518] pid = [07:59:33.518] __error = [07:59:33.518] save_errno = [07:59:33.518] __error = [07:59:33.518] __error = [07:59:33.518] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [07:59:33.518] 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\317\3036\b", '\000' , "\360\270!\b\000\000\000h5\016*\b\000\000\000\v\000\000\000\000\000\000\000^\277\016*\b", '\000' , "@\360\270!\b\000\000\000\364\005\211\000\000\000\000\000P\360\270!\b", '\000' }, salen = 16}} [07:59:33.518] i = 0 [07:59:33.518] now = [07:59:33.518] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 726699138, events = 8, fd = 0, user_data = 0x821b8ef50}, {pos = 919172568, events = 8, fd = 565767648, user_data = 0x0}, {pos = 0, events = 0, fd = 52213038, user_data = 0x373356a9530a}, {pos = 725866400, events = 8, fd = 725937528, user_data = 0x821b8ea68}, {pos = 565766880, events = 8, fd = 565766760, user_data = 0x373356a9530a}, {pos = 725844872, events = 8, fd = 725937528, user_data = 0x821b8ea98}, {pos = 565766928, events = 8, fd = 565766808, user_data = 0x82b447194}, {pos = 570098696, events = 8, fd = 725905812, user_data = 0x821b8eb00}, {pos = 1453917242, events = 14131, fd = 727728176, user_data = 0x1}, {pos = 565766960, events = 8, fd = 1453937418, user_data = 0x82b430858}, {pos = 725937528, events = 8, fd = 565766920, user_data = 0x821b8eb80}, {pos = 565766920, events = 8, fd = 725900556, user_data = 0x821fb0408}, {pos = 725900556, events = 8, fd = 565767024, user_data = 0x373356a9043a}, {pos = 565767064, events = 8, fd = 565767512, user_data = 0x821b8eb80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3693501658, fd = 570122296, user_data = 0x800000001}, {pos = 570098696, events = 8, fd = 725844872, user_data = 0x821fb5288}, {pos = 725813336, events = 8, fd = 570098696, user_data = 0x821b8ec08}, {pos = 565767624, events = 8, fd = 565767152, user_data = 0x373356a94ca2}, {pos = 2702861, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 570122296, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 565767880, user_data = 0x21fb0408}, {pos = 565767696, events = 8, fd = 565767296, user_data = 0x1}, {pos = 565767624, events = 8, fd = 32, user_data = 0x821b8ec70}, {pos = 1453935219, events = 14131, fd = 565767568, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821fb6038}, {pos = 1, events = 8, fd = 570098696, user_data = 0x82b430858}, {pos = 565767880, events = 8, fd = 565767696, user_data = 0x821b8ec80}, {pos = 0, events = 0, fd = 570069000, user_data = 0x20}, {pos = 565767680, events = 8, fd = 1453910759, user_data = 0x821fa9008}, {pos = 570070024, events = 8, fd = 570071048, user_data = 0x821fa9c08}, {pos = 570085384, events = 8, fd = 570086408, user_data = 0x821fad808}, {pos = 570088456, events = 8, fd = 570089480, user_data = 0x821fae408}, {pos = 570091528, events = 8, fd = 570092552, user_data = 0x821faf008}, {pos = 570094600, events = 8, fd = 570095624, user_data = 0x821fafc08}, {pos = 570097672, events = 8, fd = 570098696, user_data = 0x821fb0808}, {pos = 570100744, events = 8, fd = 570101768, user_data = 0x821fb1408}, {pos = 570103816, events = 8, fd = 570104840, user_data = 0x821fb2008}, {pos = 570106888, events = 8, fd = 570107912, user_data = 0x821fb2c08}, {pos = 570114056, events = 8, fd = 570115080, user_data = 0x821fb4808}, {pos = 570117128, events = 8, fd = 570069000, user_data = 0x293e0d}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821fb6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 565767880, events = 8, fd = 565767296, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 570122296, user_data = 0x1}, {pos = 570069000, events = 8, fd = 298, user_data = 0x821b8eeb0}, {pos = 1453909487, events = 14131, fd = 2702861, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 570122296, user_data = 0x1}, {pos = 570098696, events = 8, fd = 918728704, user_data = 0x1}, {pos = 918729108, events = 8, fd = 0, user_data = 0x821b8ee80}, {pos = 705607020, events = 8, fd = 1, user_data = 0x836c2b000}, {pos = 565767856, events = 8, fd = 705603330, user_data = 0x82b562170 }, {pos = 12333928, events = 0, fd = 727064944, user_data = 0x821fb0408}, {pos = 565768080, events = 8, fd = 1453908958, user_data = 0x836c49800}, {pos = 1, events = 0, fd = 1453908574, user_data = 0x821fa9008}, {pos = 565767864, events = 8, fd = 565768080, user_data = 0x1ab8}, {pos = 918802176, events = 8, fd = 1453988240, user_data = 0x0}, {pos = 565707647, events = 8, fd = 8123863, user_data = 0x821b8ef40}, {pos = 705565712, events = 8, fd = 727728176, user_data = 0x82b606310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821b8ef70}, {pos = 705608605, events = 8, fd = 918728704, user_data = 0x1da7}, {pos = 565768144, events = 8, fd = 705575162, user_data = 0x0}, {pos = 0, events = 0, fd = 52213038, user_data = 0x0}} [07:59:33.518] last_touch_time = 1731225290 [07:59:33.518] last_lockfile_recheck_time = 1731225290 [07:59:33.518] nevents = 1 [07:59:33.518] #21 0x0000000000892a35 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821b8f5b0) at ../src/backend/postmaster/postmaster.c:1348 [07:59:33.518] userDoption = [07:59:33.518] listen_addr_saved = [07:59:33.518] output_config_variable = [07:59:33.518] opt = [07:59:33.518] status = [07:59:33.518] #22 0x00000000007cc25c in main (argc=8, argv=0x821b8f5b0) at ../src/backend/main/main.c:196 [07:59:33.518] do_check_root = [07:59:33.528] [07:59:33.528] [07:59:33.528] [07:59:33.591] dumping /tmp/cores/postgres.11175.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:59:33.718] [New LWP 101857] [07:59:33.783] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [07:59:33.783] Program terminated with signal SIGABRT, Aborted. [07:59:33.783] Sent by thr_kill() from pid 11175 and user 1003. [07:59:33.783] #0 0x000000082bb5541a in thr_kill () from /lib/libc.so.7 [07:59:33.819] [07:59:33.819] Thread 1 (LWP 101857): [07:59:33.819] #0 0x000000082bb5541a in thr_kill () from /lib/libc.so.7 [07:59:33.819] No symbol table info available. [07:59:33.819] #1 0x000000082bacee64 in raise () from /lib/libc.so.7 [07:59:33.819] No symbol table info available. [07:59:33.819] #2 0x000000082bb7f6f9 in abort () from /lib/libc.so.7 [07:59:33.819] No symbol table info available. [07:59:33.819] #3 0x0000000000a98e55 in ExceptionalCondition (conditionName=0x2e7ee6 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [07:59:33.819] No locals. [07:59:33.819] #4 0x0000000000768eb9 in standard_ExecutorStart (queryDesc=0x834de1088, eflags=0) at ../src/backend/executor/execMain.c:194 [07:59:33.819] estate = 0x832eb8100 [07:59:33.819] oldcontext = 0x834dd7800 [07:59:33.819] #5 0x00000000006fecb5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [07:59:33.819] copied_query = [07:59:33.819] rewritten = [07:59:33.819] plan = 0x83300fbd8 [07:59:33.819] queryDesc = 0x834de1088 [07:59:33.819] processed = [07:59:33.819] __error = [07:59:33.819] #6 RefreshMatViewByOid (matviewOid=28316, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [07:59:33.819] dest = [07:59:33.819] save_userid = 10 [07:59:33.819] save_sec_context = 0 [07:59:33.819] processed = 0 [07:59:33.819] matviewRel = 0x834f82ba8 [07:59:33.819] relowner = 10 [07:59:33.819] save_nestlevel = 2 [07:59:33.819] rule = [07:59:33.819] actions = [07:59:33.819] dataQuery = [07:59:33.819] tableSpace = [07:59:33.819] relpersistence = [07:59:33.819] OIDNewHeap = 28337 [07:59:33.819] address = [07:59:33.819] #7 0x00000000006fe896 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [07:59:33.819] lockmode = [07:59:33.819] matviewOid = 0 [07:59:33.819] #8 0x00000000006d59ac in ExecCreateTableAs (pstate=pstate@entry=0x834dd7900, stmt=stmt@entry=0x832f81fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82117a000) at ../src/backend/commands/createas.c:351 [07:59:33.819] refresh = 0x0 [07:59:33.819] query = 0x834e7e498 [07:59:33.819] into = 0x834e7e7e0 [07:59:33.819] jstate = 0x0 [07:59:33.819] do_refresh = false [07:59:33.819] address = [07:59:33.819] dest = [07:59:33.819] is_matview = [07:59:33.819] #9 0x0000000000944a38 in ProcessUtilitySlow (pstate=pstate@entry=0x834dd7900, pstmt=pstmt@entry=0x832e6ca68, queryString=queryString@entry=0x832e6b100 "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=0x82117a000) at ../src/backend/tcop/utility.c:1678 [07:59:33.819] _local_sigjmp_buf = {{_sjb = {9716329, 0, 34914933800, 34914934176, 34914933808, 12404328, 0, 35246668032, 4294902655, 34914933916, 34914933952, 0}}} [07:59:33.819] _save_exception_stack = 0x821179f00 [07:59:33.819] _save_context_stack = 0x0 [07:59:33.819] _do_rethrow = false [07:59:33.819] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [07:59:33.819] parsetree = 0x832f81fd0 [07:59:33.819] commandCollected = false [07:59:33.819] needCleanup = false [07:59:33.819] address = [07:59:33.819] isTopLevel = [07:59:33.819] isCompleteQuery = [07:59:33.819] #10 0x00000000009433b8 in standard_ProcessUtility (pstmt=0x832e6ca68, queryString=0x832e6b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834e7ecc8, qc=0x82117a000) at ../src/backend/tcop/utility.c:1033 [07:59:33.819] isAtomicContext = false [07:59:33.819] parsetree = 0x832f81fd0 [07:59:33.819] readonly_flags = [07:59:33.819] pstate = 0x834dd7900 [07:59:33.819] isTopLevel = [07:59:33.819] #11 0x0000000000942e48 in ProcessUtility (pstmt=0x18de1, queryString=0x6 , readOnlyTree=, context=733303802, params=0x0, queryEnv=0x0, dest=0x834e7ecc8, qc=0x82117a000) at ../src/backend/tcop/utility.c:523 [07:59:33.819] No locals. [07:59:33.819] #12 0x0000000000942983 in PortalRunUtility (portal=0x832f11100, pstmt=0x832e6ca68, isTopLevel=, setHoldSnapshot=, dest=0x834e7ecc8, qc=0x82117a000) at ../src/backend/tcop/pquery.c:1158 [07:59:33.819] No locals. [07:59:33.819] #13 0x0000000000942014 in PortalRunMulti (portal=portal@entry=0x832f11100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x834e7ecc8, altdest=altdest@entry=0x834e7ecc8, qc=0x82117a000) at ../src/backend/tcop/pquery.c:1322 [07:59:33.819] pstmt = 0x832e6ca68 [07:59:33.819] stmtlist_item__state = {l = 0x834e7ec78, i = 0} [07:59:33.819] active_snapshot_set = false [07:59:33.819] stmtlist_item = 0x834e7ec90 [07:59:33.819] #14 0x00000000009418e3 in PortalRun (portal=portal@entry=0x832f11100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x834e7ecc8, altdest=altdest@entry=0x834e7ecc8, qc=0x82117a000) at ../src/backend/tcop/pquery.c:791 [07:59:33.819] _local_sigjmp_buf = {{_sjb = {9705565, 35214397696, 34914934520, 34914934752, 34914934528, 35214413824, 12370936, 12404328, 35214394239, 35214853520, 4294967984, 0}}} [07:59:33.819] _save_exception_stack = 0x82117a0d0 [07:59:33.819] _save_context_stack = 0x0 [07:59:33.819] _do_rethrow = false [07:59:33.819] saveTopTransactionResourceOwner = 0x832f60cd8 [07:59:33.819] saveTopTransactionContext = 0x832f15000 [07:59:33.819] saveActivePortal = 0x0 [07:59:33.819] saveResourceOwner = 0x832f60cd8 [07:59:33.819] savePortalContext = 0x0 [07:59:33.819] saveMemoryContext = 0x832f15000 [07:59:33.819] result = [07:59:33.819] nprocessed = [07:59:33.819] #15 0x0000000000940782 in exec_simple_query (query_string=query_string@entry=0x832e6b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [07:59:33.819] cmdtaglen = 24 [07:59:33.819] snapshot_set = [07:59:33.819] per_parsetree_context = 0x0 [07:59:33.819] plantree_list = [07:59:33.819] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:59:33.819] format = 0 [07:59:33.819] parsetree = 0x832e6c6a8 [07:59:33.819] commandTag = [07:59:33.819] cmdtagname = [07:59:33.819] querytree_list = [07:59:33.819] portal = 0x832f11100 [07:59:33.819] receiver = 0x834e7ecc8 [07:59:33.819] parsetree_item__state = {l = 0x832e6ca18, i = 0} [07:59:33.819] msec_str = "\000\000\000\000\b", '\000' , "\342f0g\000\000\000\000kj\002\263N\005", [07:59:33.819] dest = DestRemote [07:59:33.819] was_logged = [07:59:33.819] oldcontext = 0x832f15000 [07:59:33.819] parsetree_list = 0x832e6ca18 [07:59:33.819] use_implicit_block = false [07:59:33.819] parsetree_item = 0x832e6ca30 [07:59:33.819] save_log_statement_stats = [07:59:33.819] #16 0x000000000093e3f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [07:59:33.819] query_string = 0x832e6b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [07:59:33.819] input_message = {data = 0x832e6b100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [07:59:33.819] firstchar = [07:59:33.819] local_sigjmp_buf = {{_sjb = {9689254, 34914934992, 34914934952, 34914935536, 12413064, 1, 8192, 8388608, 34914894719, 0, 0, 1}}} [07:59:33.819] send_ready_for_query = false [07:59:33.819] idle_in_transaction_timeout_enabled = false [07:59:33.819] idle_session_timeout_enabled = false [07:59:33.819] #17 0x0000000000938bd9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:59:33.819] bsdata = [07:59:33.819] #18 0x0000000000890847 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82117ae14 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82117ad50) at ../src/backend/postmaster/launch_backend.c:266 [07:59:33.819] pid = [07:59:33.819] #19 0x0000000000894c18 in BackendStartup (client_sock=0x82117ad50) at ../src/backend/postmaster/postmaster.c:3417 [07:59:33.819] startup_data = {canAcceptConnections = CAC_OK} [07:59:33.819] bn = 0x832e77448 [07:59:33.819] pid = [07:59:33.819] __error = [07:59:33.819] save_errno = [07:59:33.819] __error = [07:59:33.819] __error = [07:59:33.819] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [07:59:33.819] 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\316\3462\b", '\000' , "\260\255\027!\b\000\000\000h\305x)\b\000\000\000\v\000\000\000\000\000\000\000^Oy)\b", '\000' , "\360\255\027!\b\000\000\000\364\005\211\000\000\000\000\000\000\256\027!\b", '\000' }, salen = 16}} [07:59:33.819] i = 0 [07:59:33.819] now = [07:59:33.819] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 732929154, events = 8, fd = 0, user_data = 0x82117ad00}, {pos = 854414808, events = 8, fd = 555199376, user_data = 0x0}, {pos = 0, events = 0, fd = 1020428757, user_data = 0x1f8ca1d9330a}, {pos = 732096416, events = 8, fd = 732167544, user_data = 0x82117a818}, {pos = 555198608, events = 8, fd = 555198488, user_data = 0x1f8ca1d9330a}, {pos = 732074888, events = 8, fd = 732167544, user_data = 0x82117a848}, {pos = 555198656, events = 8, fd = 555198536, user_data = 0x82ba38194}, {pos = 557032456, events = 8, fd = 732135828, user_data = 0x82117a8b0}, {pos = -1579621318, events = 8076, fd = 733958192, user_data = 0x1}, {pos = 555198688, events = 8, fd = -1579601142, user_data = 0x82ba21858}, {pos = 732167544, events = 8, fd = 555198648, user_data = 0x82117a930}, {pos = 555198648, events = 8, fd = 732130572, user_data = 0x82133a408}, {pos = 732130572, events = 8, fd = 555198752, user_data = 0x1f8ca1d8e43a}, {pos = 555198792, events = 8, fd = 555199240, user_data = 0x82117a930}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3523626866, fd = 557056056, user_data = 0x800000001}, {pos = 557032456, events = 8, fd = 732074888, user_data = 0x82133f288}, {pos = 732043352, events = 8, fd = 557032456, user_data = 0x82117a9b8}, {pos = 555199352, events = 8, fd = 555198880, user_data = 0x1f8ca1d92ca2}, {pos = 2702861, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 557056056, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 555199608, user_data = 0x2133a408}, {pos = 555199424, events = 8, fd = 555199024, user_data = 0x1}, {pos = 555199352, events = 8, fd = 32, user_data = 0x82117aa20}, {pos = -1579603341, events = 8076, fd = 555199296, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821340038}, {pos = 1, events = 8, fd = 557032456, user_data = 0x82ba21858}, {pos = 555199608, events = 8, fd = 555199424, user_data = 0x82117aa30}, {pos = 0, events = 0, fd = 557002760, user_data = 0x20}, {pos = 555199408, events = 8, fd = -1579627801, user_data = 0x821333008}, {pos = 557003784, events = 8, fd = 557004808, user_data = 0x821333c08}, {pos = 557019144, events = 8, fd = 557020168, user_data = 0x821337808}, {pos = 557022216, events = 8, fd = 557023240, user_data = 0x821338408}, {pos = 557025288, events = 8, fd = 557026312, user_data = 0x821339008}, {pos = 557028360, events = 8, fd = 557029384, user_data = 0x821339c08}, {pos = 557031432, events = 8, fd = 557032456, user_data = 0x82133a808}, {pos = 557034504, events = 8, fd = 557035528, user_data = 0x82133b408}, {pos = 557037576, events = 8, fd = 557038600, user_data = 0x82133c008}, {pos = 557040648, events = 8, fd = 557041672, user_data = 0x82133cc08}, {pos = 557047816, events = 8, fd = 557048840, user_data = 0x82133e808}, {pos = 557050888, events = 8, fd = 557002760, user_data = 0x293e0d}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821340038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555199608, events = 8, fd = 555199024, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 557056056, user_data = 0x1}, {pos = 557002760, events = 8, fd = 298, user_data = 0x82117ac60}, {pos = -1579629073, events = 8076, fd = 2702861, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 557056056, user_data = 0x1}, {pos = 557032456, events = 8, fd = 853913600, user_data = 0x1}, {pos = 853914004, events = 8, fd = 0, user_data = 0x82117ac30}, {pos = 695813484, events = 8, fd = 1, user_data = 0x832e5b000}, {pos = 555199584, events = 8, fd = 695809794, user_data = 0x82bb53170 }, {pos = 12333928, events = 0, fd = 733294960, user_data = 0x82133a408}, {pos = 555199808, events = 8, fd = -1579629602, user_data = 0x832e79800}, {pos = 1, events = 0, fd = -1579629986, user_data = 0x821333008}, {pos = 555199592, events = 8, fd = 555199808, user_data = 0x1ab8}, {pos = 853987008, events = 8, fd = -1579550320, user_data = 0x0}, {pos = 555156351, events = 8, fd = 8123863, user_data = 0x82117acf0}, {pos = 695772176, events = 8, fd = 733958192, user_data = 0x82bbf7310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82117ad20}, {pos = 695815069, events = 8, fd = 853913600, user_data = 0x1dce}, {pos = 555199872, events = 8, fd = 695781626, user_data = 0x0}, {pos = 0, events = 0, fd = 1020428757, user_data = 0x0}} [07:59:33.819] last_touch_time = 1731225290 [07:59:33.819] last_lockfile_recheck_time = 1731225290 [07:59:33.819] nevents = 1 [07:59:33.819] #21 0x0000000000892a35 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82117b368) at ../src/backend/postmaster/postmaster.c:1348 [07:59:33.819] userDoption = [07:59:33.819] listen_addr_saved = [07:59:33.819] output_config_variable = [07:59:33.819] opt = [07:59:33.819] status = [07:59:33.819] #22 0x00000000007cc25c in main (argc=4, argv=0x82117b368) at ../src/backend/main/main.c:196 [07:59:33.819] do_check_root = [07:59:33.829] [07:59:33.829] [07:59:33.829] [07:59:33.893] dumping /tmp/cores/postgres.18115.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:59:34.019] [New LWP 100137] [07:59:34.085] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [07:59:34.085] Program terminated with signal SIGABRT, Aborted. [07:59:34.085] Sent by thr_kill() from pid 18115 and user 1003. [07:59:34.085] #0 0x000000082cddb41a in thr_kill () from /lib/libc.so.7 [07:59:34.129] [07:59:34.129] Thread 1 (LWP 100137): [07:59:34.129] #0 0x000000082cddb41a in thr_kill () from /lib/libc.so.7 [07:59:34.129] No symbol table info available. [07:59:34.129] #1 0x000000082cd54e64 in raise () from /lib/libc.so.7 [07:59:34.129] No symbol table info available. [07:59:34.129] #2 0x000000082ce056f9 in abort () from /lib/libc.so.7 [07:59:34.129] No symbol table info available. [07:59:34.129] #3 0x0000000000a98e55 in ExceptionalCondition (conditionName=0x2e7ee6 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [07:59:34.129] No locals. [07:59:34.129] #4 0x0000000000768eb9 in standard_ExecutorStart (queryDesc=0x837fd6088, eflags=0) at ../src/backend/executor/execMain.c:194 [07:59:34.129] estate = 0x838052100 [07:59:34.129] oldcontext = 0x838095800 [07:59:34.129] #5 0x000000083b4949c2 in pgss_ExecutorStart (queryDesc=0x837fd6088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [07:59:34.129] No locals. [07:59:34.129] #6 0x00000000006fecb5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [07:59:34.129] copied_query = [07:59:34.129] rewritten = [07:59:34.129] plan = 0x84068fbd8 [07:59:34.129] queryDesc = 0x837fd6088 [07:59:34.129] processed = [07:59:34.129] __error = [07:59:34.129] #7 RefreshMatViewByOid (matviewOid=28274, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [07:59:34.129] dest = [07:59:34.129] save_userid = 10 [07:59:34.129] save_sec_context = 0 [07:59:34.129] processed = 0 [07:59:34.129] matviewRel = 0x84087d858 [07:59:34.129] relowner = 10 [07:59:34.129] save_nestlevel = 2 [07:59:34.129] rule = [07:59:34.129] actions = [07:59:34.129] dataQuery = [07:59:34.129] tableSpace = [07:59:34.129] relpersistence = [07:59:34.129] OIDNewHeap = 28281 [07:59:34.129] address = [07:59:34.129] #8 0x00000000006fe896 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [07:59:34.129] lockmode = [07:59:34.129] matviewOid = 0 [07:59:34.129] #9 0x00000000006d59ac in ExecCreateTableAs (pstate=pstate@entry=0x838095900, stmt=stmt@entry=0x837faffd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8218c1c60) at ../src/backend/commands/createas.c:351 [07:59:34.129] refresh = 0x0 [07:59:34.129] query = 0x837ffa148 [07:59:34.129] into = 0x837faff40 [07:59:34.129] jstate = 0x0 [07:59:34.129] do_refresh = false [07:59:34.129] address = [07:59:34.129] dest = [07:59:34.129] is_matview = [07:59:34.129] #10 0x0000000000944a38 in ProcessUtilitySlow (pstate=pstate@entry=0x838095900, pstmt=pstmt@entry=0x837fafe30, queryString=queryString@entry=0x837f12100 "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=0x8218c1c60) at ../src/backend/tcop/utility.c:1678 [07:59:34.129] _local_sigjmp_buf = {{_sjb = {9716329, 0, 34922567368, 34922567744, 34922567376, 12404328, 0, 35299875072, 34922562431, 7, 34922567520, 0}}} [07:59:34.129] _save_exception_stack = 0x8218c1950 [07:59:34.129] _save_context_stack = 0x0 [07:59:34.129] _do_rethrow = false [07:59:34.129] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [07:59:34.129] parsetree = 0x837faffd0 [07:59:34.129] commandCollected = false [07:59:34.129] needCleanup = false [07:59:34.129] address = [07:59:34.129] isTopLevel = [07:59:34.129] isCompleteQuery = [07:59:34.129] #11 0x00000000009433b8 in standard_ProcessUtility (pstmt=0x837fafe30, queryString=queryString@entry=0x837f12100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837ffa8e8, qc=0x8218c1c60) at ../src/backend/tcop/utility.c:1033 [07:59:34.129] isAtomicContext = false [07:59:34.129] parsetree = 0x837faffd0 [07:59:34.129] readonly_flags = [07:59:34.129] pstate = 0x838095900 [07:59:34.129] isTopLevel = [07:59:34.129] #12 0x000000083b494f7e in pgss_ProcessUtility (pstmt=0x837fafe30, queryString=0x837f12100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837ffa8e8, qc=0x8218c1c60) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [07:59:34.129] _local_sigjmp_buf = {{_sjb = {35354398391, 34922568016, 34922567880, 34922568336, 35298934320, 0, 12404328, 34922568544, 34922562431, 34922568116, 34922568144, 0}}} [07:59:34.129] _save_exception_stack = 0x8218c1b60 [07:59:34.129] _save_context_stack = 0x0 [07:59:34.129] _do_rethrow = false [07:59:34.129] bufusage = {shared_blks_hit = 35354398391, shared_blks_read = 34922568016, shared_blks_dirtied = 34922567880, shared_blks_written = 34922568336, local_blks_hit = 35298934320, local_blks_read = 0, local_blks_dirtied = 12404328, local_blks_written = 34922568544, temp_blks_read = 34922562431, temp_blks_written = 34922568116, shared_blk_read_time = {ticks = 34922568144}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4375824286912944256}, local_blk_write_time = {ticks = 12413368}, temp_blk_read_time = {ticks = 35382749184}, temp_blk_write_time = {ticks = 12366880}} [07:59:34.129] walusage_start = {wal_records = 8993, wal_fpi = 143, wal_bytes = 1345747} [07:59:34.129] duration = [07:59:34.129] bufusage_start = {shared_blks_hit = 153284, shared_blks_read = 8859, shared_blks_dirtied = 2728, shared_blks_written = 2389, 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}} [07:59:34.129] walusage = {wal_records = 5347357595499067208, wal_fpi = 35298934736, wal_bytes = 123} [07:59:34.129] start = {ticks = -192083493567} [07:59:34.129] rows = [07:59:34.129] saved_queryId = 6041762721901209185 [07:59:34.129] parsetree = [07:59:34.129] saved_stmt_location = 0 [07:59:34.129] saved_stmt_len = 69 [07:59:34.129] enabled = [07:59:34.129] #13 0x0000000000942983 in PortalRunUtility (portal=0x837fba100, pstmt=0x837fafe30, isTopLevel=, setHoldSnapshot=, dest=0x837ffa8e8, qc=0x8218c1c60) at ../src/backend/tcop/pquery.c:1158 [07:59:34.129] No locals. [07:59:34.129] #14 0x0000000000942014 in PortalRunMulti (portal=portal@entry=0x837fba100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x837ffa8e8, altdest=altdest@entry=0x837ffa8e8, qc=0x8218c1c60) at ../src/backend/tcop/pquery.c:1322 [07:59:34.129] pstmt = 0x837fafe30 [07:59:34.129] stmtlist_item__state = {l = 0x837ffa898, i = 0} [07:59:34.129] active_snapshot_set = false [07:59:34.129] stmtlist_item = 0x837ffa8b0 [07:59:34.129] #15 0x00000000009418e3 in PortalRun (portal=portal@entry=0x837fba100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x837ffa8e8, altdest=altdest@entry=0x837ffa8e8, qc=0x8218c1c60) at ../src/backend/tcop/pquery.c:791 [07:59:34.129] _local_sigjmp_buf = {{_sjb = {9705565, 35298976000, 34922568536, 34922568768, 34922568544, 35299069952, 12370936, 12404328, 35298935679, 35298928096, 4294967984, 0}}} [07:59:34.129] _save_exception_stack = 0x8218c1d30 [07:59:34.129] _save_context_stack = 0x0 [07:59:34.129] _do_rethrow = false [07:59:34.129] saveTopTransactionResourceOwner = 0x838008c18 [07:59:34.129] saveTopTransactionContext = 0x837fd1000 [07:59:34.129] saveActivePortal = 0x0 [07:59:34.129] saveResourceOwner = 0x838008c18 [07:59:34.129] savePortalContext = 0x0 [07:59:34.129] saveMemoryContext = 0x837fd1000 [07:59:34.129] result = [07:59:34.129] nprocessed = [07:59:34.129] #16 0x0000000000940782 in exec_simple_query (query_string=query_string@entry=0x837f12100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [07:59:34.129] cmdtaglen = 24 [07:59:34.129] snapshot_set = [07:59:34.129] per_parsetree_context = 0x0 [07:59:34.129] plantree_list = [07:59:34.129] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:59:34.129] format = 0 [07:59:34.129] parsetree = 0x837f136a8 [07:59:34.129] commandTag = [07:59:34.129] cmdtagname = [07:59:34.129] querytree_list = [07:59:34.129] portal = 0x837fba100 [07:59:34.129] receiver = 0x837ffa8e8 [07:59:34.129] parsetree_item__state = {l = 0x837f13a18, i = 0} [07:59:34.129] msec_str = "\000\000\000\000\b", '\000' , "\ng0g\000\000\000\000\241\031\021\001\204\017W\260" [07:59:34.129] dest = DestRemote [07:59:34.129] was_logged = [07:59:34.129] oldcontext = 0x837fd1000 [07:59:34.129] parsetree_list = 0x837f13a18 [07:59:34.129] use_implicit_block = false [07:59:34.129] parsetree_item = 0x837f13a30 [07:59:34.129] save_log_statement_stats = [07:59:34.129] #17 0x000000000093e3f3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [07:59:34.129] query_string = 0x837f12100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [07:59:34.129] input_message = {data = 0x837f12100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [07:59:34.129] firstchar = [07:59:34.129] local_sigjmp_buf = {{_sjb = {9689254, 34922569008, 34922568968, 34922569552, 12413064, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [07:59:34.129] send_ready_for_query = false [07:59:34.129] idle_in_transaction_timeout_enabled = false [07:59:34.129] idle_session_timeout_enabled = false [07:59:34.129] #18 0x0000000000938bd9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:59:34.129] bsdata = [07:59:34.129] #19 0x0000000000890847 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8218c2a74 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8218c29b0) at ../src/backend/postmaster/launch_backend.c:266 [07:59:34.129] pid = [07:59:34.129] #20 0x0000000000894c18 in BackendStartup (client_sock=0x8218c29b0) at ../src/backend/postmaster/postmaster.c:3417 [07:59:34.129] startup_data = {canAcceptConnections = CAC_OK} [07:59:34.129] bn = 0x837f1e628 [07:59:34.129] pid = [07:59:34.129] __error = [07:59:34.129] save_errno = [07:59:34.129] __error = [07:59:34.129] __error = [07:59:34.129] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [07:59:34.129] 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 = " ,\3617\b", '\000' , "\020*\214!\b\000\000\000hu\027+\b\000\000\000\v\000\000\000\000\000\000\000^\377\027+\b", '\000' , "P*\214!\b\000\000\000\364\005\211\000\000\000\000\000`*\214!\b", '\000' }, salen = 16}} [07:59:34.129] i = 0 [07:59:34.129] now = [07:59:34.129] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 752352386, events = 8, fd = 0, user_data = 0x8218c2960}, {pos = 938956248, events = 8, fd = 562833392, user_data = 0x0}, {pos = 1902994186, events = 14187, fd = 751519648, user_data = 0x82ccc5d78}, {pos = 562832488, events = 8, fd = 562832608, user_data = 0x8218c2468}, {pos = 1902994186, events = 14187, fd = 751498120, user_data = 0x82ccc5d78}, {pos = 562832536, events = 8, fd = 562832656, user_data = 0x8218c2498}, {pos = 751559060, events = 8, fd = 576656392, user_data = 0x82ccbe194}, {pos = 562832640, events = 8, fd = 1902974010, user_data = 0x8218c24a0}, {pos = 722949136, events = 8, fd = 753381424, user_data = 0x376b716d630a}, {pos = 751466584, events = 8, fd = 751590776, user_data = 0x8218c2508}, {pos = 562832768, events = 8, fd = 562832648, user_data = 0x82ccbcd0c}, {pos = 576656392, events = 8, fd = 751553804, user_data = 0x8218c2570}, {pos = 1902974010, events = 14187, fd = 562832792, user_data = 0x8218c2768}, {pos = 562832768, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8225f7038}, {pos = 1, events = 1245028710, fd = 576656392, user_data = 0x82ccaf388}, {pos = 576677832, events = 8, fd = 0, user_data = 0x0}, {pos = 562832904, events = 8, fd = 562833368, user_data = 0x8218c25f0}, {pos = 1902992546, events = 14187, fd = 2702861, user_data = 0x6d68b}, {pos = 2090263927, events = 1245028710, fd = 576679992, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8218c28d8}, {pos = 576656392, events = 3, fd = 562833440, user_data = 0x8225f6828}, {pos = 656, events = 0, fd = 562833368, user_data = 0x8218c2608}, {pos = 562833008, events = 8, fd = 1902992155, user_data = 0x8218c27a0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 576679992, events = 8, fd = 1, user_data = 0x8225f1408}, {pos = 751466584, events = 8, fd = 562833624, user_data = 0x8218c2820}, {pos = 562833024, events = 8, fd = 0, user_data = 0x8225ea008}, {pos = 33, events = 0, fd = 562833424, user_data = 0x376b716cfae7}, {pos = 576626696, events = 8, fd = 576627720, user_data = 0x8225ea808}, {pos = 576629768, events = 8, fd = 576643080, user_data = 0x8225ee408}, {pos = 576645128, events = 8, fd = 576646152, user_data = 0x8225ef008}, {pos = 576648200, events = 8, fd = 576649224, user_data = 0x8225efc08}, {pos = 576651272, events = 8, fd = 576652296, user_data = 0x8225f0808}, {pos = 576654344, events = 8, fd = 576655368, user_data = 0x8225f1408}, {pos = 576657416, events = 8, fd = 576658440, user_data = 0x8225f2008}, {pos = 576660488, events = 8, fd = 576661512, user_data = 0x8225f2c08}, {pos = 576663560, events = 8, fd = 576664584, user_data = 0x8225f3808}, {pos = 576666632, events = 8, fd = 576671752, user_data = 0x8225f5408}, {pos = 576673800, events = 8, fd = 576674824, user_data = 0x8225f8408}, {pos = 861050000, events = 0, fd = 576626696, user_data = 0x293e0d}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8225f7038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 562833624, events = 8, fd = 562833024, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 576679992, user_data = 0x1}, {pos = 576626696, events = 8, fd = 298, user_data = 0x8218c28c0}, {pos = 1902966255, events = 14187, fd = 2702861, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 576679992, user_data = 0x1}, {pos = 576656392, events = 8, fd = 938483712, user_data = 0x1}, {pos = 938484116, events = 8, fd = 0, user_data = 0x8218c2890}, {pos = 722990444, events = 8, fd = 1, user_data = 0x837f02000}, {pos = 562833600, events = 8, fd = 722986754, user_data = 0x82cdd9170 }, {pos = 12333928, events = 0, fd = 752718192, user_data = 0x8225f1408}, {pos = 562833824, events = 8, fd = 1902965726, user_data = 0x837f20800}, {pos = 1, events = 0, fd = 1902965342, user_data = 0x8225ea008}, {pos = 562833608, events = 8, fd = 562833824, user_data = 0x1ab8}, {pos = 938552352, events = 8, fd = 1903045008, user_data = 0x0}, {pos = 562824063, events = 8, fd = 8123863, user_data = 0x8218c2950}, {pos = 722949136, events = 8, fd = 753381424, user_data = 0x82ce7d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8218c2980}, {pos = 722992029, events = 8, fd = 938483712, user_data = 0x36aa}, {pos = 562833888, events = 8, fd = 722958586, user_data = 0x0}, {pos = 0, events = 0, fd = -826968248, user_data = 0x0}} [07:59:34.129] last_touch_time = 1731225327 [07:59:34.129] last_lockfile_recheck_time = 1731225327 [07:59:34.129] nevents = 1 [07:59:34.129] #22 0x0000000000892a35 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8218c2fc0) at ../src/backend/postmaster/postmaster.c:1348 [07:59:34.129] userDoption = [07:59:34.129] listen_addr_saved = [07:59:34.129] output_config_variable = [07:59:34.129] opt = [07:59:34.129] status = [07:59:34.129] #23 0x00000000007cc25c in main (argc=4, argv=0x8218c2fc0) at ../src/backend/main/main.c:196 [07:59:34.129] do_check_root =