[10:42:07.211] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [10:42:07.499] dumping /tmp/cores/postgres.10960.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [10:42:07.632] [New LWP 100119] [10:42:07.718] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [10:42:07.718] Program terminated with signal SIGABRT, Aborted. [10:42:07.718] Sent by thr_kill() from pid 10960 and user 1003. [10:42:07.718] #0 0x000000082b65a41a in thr_kill () from /lib/libc.so.7 [10:42:07.770] [10:42:07.770] Thread 1 (LWP 100119): [10:42:07.770] #0 0x000000082b65a41a in thr_kill () from /lib/libc.so.7 [10:42:07.770] No symbol table info available. [10:42:07.770] #1 0x000000082b5d3e64 in raise () from /lib/libc.so.7 [10:42:07.770] No symbol table info available. [10:42:07.770] #2 0x000000082b6846f9 in abort () from /lib/libc.so.7 [10:42:07.770] No symbol table info available. [10:42:07.770] #3 0x0000000000aa2835 in ExceptionalCondition (conditionName=0x2ed272 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [10:42:07.770] No locals. [10:42:07.770] #4 0x0000000000769949 in standard_ExecutorStart (queryDesc=0x836107bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [10:42:07.770] estate = 0x8434f4100 [10:42:07.770] oldcontext = 0x8360ee800 [10:42:07.770] #5 0x00000000006fdb8f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [10:42:07.770] copied_query = [10:42:07.770] rewritten = [10:42:07.770] plan = 0x836107778 [10:42:07.770] queryDesc = 0x836107bd0 [10:42:07.770] processed = [10:42:07.770] __error = [10:42:07.770] #6 RefreshMatViewByOid (matviewOid=28568, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [10:42:07.770] dest = [10:42:07.770] save_userid = 10 [10:42:07.770] save_sec_context = 0 [10:42:07.770] processed = 0 [10:42:07.770] matviewRel = 0x84358a048 [10:42:07.770] relowner = 10 [10:42:07.770] save_nestlevel = 2 [10:42:07.770] rule = [10:42:07.770] actions = [10:42:07.770] dataQuery = [10:42:07.770] tableSpace = [10:42:07.770] relpersistence = [10:42:07.770] OIDNewHeap = 28577 [10:42:07.770] address = [10:42:07.770] #7 0x00000000006fd766 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [10:42:07.770] lockmode = [10:42:07.770] matviewOid = 0 [10:42:07.770] #8 0x00000000006d475c in ExecCreateTableAs (pstate=pstate@entry=0x8360ee900, stmt=stmt@entry=0x8360fffd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8210eb120) at ../src/backend/commands/createas.c:351 [10:42:07.770] refresh = 0x0 [10:42:07.770] query = 0x83611ea18 [10:42:07.770] into = 0x83611ed60 [10:42:07.770] jstate = 0x0 [10:42:07.770] do_refresh = false [10:42:07.770] address = [10:42:07.770] dest = [10:42:07.770] is_matview = [10:42:07.770] #9 0x000000000094a0bb in ProcessUtilitySlow (pstate=pstate@entry=0x8360ee900, pstmt=pstmt@entry=0x836041a68, queryString=queryString@entry=0x836040100 "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=0x8210eb120) at ../src/backend/tcop/utility.c:1678 [10:42:07.770] _local_sigjmp_buf = {{_sjb = {9738473, 0, 34914348360, 34914348736, 34914348368, 12562776, 0, 35266685184, 12452735, 1, 4294967295, 34359738368}}} [10:42:07.770] _save_exception_stack = 0x8210eb020 [10:42:07.770] _save_context_stack = 0x0 [10:42:07.770] _do_rethrow = false [10:42:07.770] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [10:42:07.770] parsetree = 0x8360fffd0 [10:42:07.770] commandCollected = false [10:42:07.770] needCleanup = false [10:42:07.770] address = [10:42:07.770] isTopLevel = [10:42:07.770] isCompleteQuery = [10:42:07.770] #10 0x0000000000948a38 in standard_ProcessUtility (pstmt=0x836041a68, queryString=0x836040100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83611f248, qc=0x8210eb120) at ../src/backend/tcop/utility.c:1033 [10:42:07.770] isAtomicContext = false [10:42:07.770] parsetree = 0x8360fffd0 [10:42:07.770] readonly_flags = [10:42:07.770] pstate = 0x8360ee900 [10:42:07.770] isTopLevel = [10:42:07.770] #11 0x00000000009484c8 in ProcessUtility (pstmt=0x18717, queryString=0x6 , readOnlyTree=, context=728081402, params=0x0, queryEnv=0x0, dest=0x83611f248, qc=0x8210eb120) at ../src/backend/tcop/utility.c:523 [10:42:07.770] No locals. [10:42:07.770] #12 0x0000000000948003 in PortalRunUtility (portal=0x836117100, pstmt=0x836041a68, isTopLevel=, setHoldSnapshot=, dest=0x83611f248, qc=0x8210eb120) at ../src/backend/tcop/pquery.c:1152 [10:42:07.770] No locals. [10:42:07.770] #13 0x00000000009476c4 in PortalRunMulti (portal=portal@entry=0x836117100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83611f248, altdest=altdest@entry=0x83611f248, qc=qc@entry=0x8210eb120) at ../src/backend/tcop/pquery.c:1316 [10:42:07.770] pstmt = 0x836041a68 [10:42:07.770] stmtlist_item__state = {l = 0x83611f1f8, i = 0} [10:42:07.770] active_snapshot_set = false [10:42:07.770] stmtlist_item = 0x83611f210 [10:42:07.770] #14 0x0000000000946fab in PortalRun (portal=portal@entry=0x836117100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x83611f248, altdest=altdest@entry=0x83611f248, qc=qc@entry=0x8210eb120) at ../src/backend/tcop/pquery.c:787 [10:42:07.770] _local_sigjmp_buf = {{_sjb = {9727781, 35266851072, 34914349080, 34914349328, 34914349088, 12562776, 34914349344, 12517208, 12452735, 0, 35266823039, 34359738368}}} [10:42:07.770] _save_exception_stack = 0x8210eb1d0 [10:42:07.770] _save_context_stack = 0x0 [10:42:07.770] _do_rethrow = false [10:42:07.770] saveTopTransactionResourceOwner = 0x836126b08 [10:42:07.770] saveTopTransactionContext = 0x83611b000 [10:42:07.770] saveActivePortal = 0x0 [10:42:07.770] saveResourceOwner = 0x836126b08 [10:42:07.770] savePortalContext = 0x0 [10:42:07.770] saveMemoryContext = 0x83611b000 [10:42:07.770] result = [10:42:07.770] nprocessed = [10:42:07.770] #15 0x0000000000945e39 in exec_simple_query (query_string=query_string@entry=0x836040100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [10:42:07.770] cmdtaglen = 24 [10:42:07.770] snapshot_set = [10:42:07.770] per_parsetree_context = 0x0 [10:42:07.770] plantree_list = [10:42:07.770] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:42:07.770] format = 0 [10:42:07.770] parsetree = 0x8360416a8 [10:42:07.770] commandTag = [10:42:07.770] cmdtagname = [10:42:07.770] querytree_list = [10:42:07.770] portal = 0x836117100 [10:42:07.770] receiver = 0x83611f248 [10:42:07.770] parsetree_item__state = {l = 0x836041a18, i = 0} [10:42:07.770] msec_str = "\000\000\000\000\b", '\000' , ")\020\226g\000\000\000\000v۟\2722\3248\371" [10:42:07.770] dest = DestRemote [10:42:07.770] was_logged = [10:42:07.770] oldcontext = 0x83611b000 [10:42:07.770] parsetree_list = 0x836041a18 [10:42:07.770] use_implicit_block = false [10:42:07.770] parsetree_item = 0x836041a30 [10:42:07.770] save_log_statement_stats = [10:42:07.770] #16 0x0000000000943aa3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [10:42:07.770] query_string = 0x836040100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [10:42:07.770] input_message = {data = 0x836040100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [10:42:07.770] firstchar = [10:42:07.770] local_sigjmp_buf = {{_sjb = {9711446, 34914349520, 34914349512, 34914350064, 12571528, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [10:42:07.770] send_ready_for_query = false [10:42:07.770] idle_in_transaction_timeout_enabled = false [10:42:07.770] idle_session_timeout_enabled = false [10:42:07.770] #17 0x000000000093e449 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:42:07.770] bsdata = [10:42:07.770] #18 0x0000000000895c25 in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x8210ebf00 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8210ebe50) at ../src/backend/postmaster/launch_backend.c:274 [10:42:07.770] pid = [10:42:07.770] #19 0x0000000000899fcb in BackendStartup (client_sock=0x8210ebe50) at ../src/backend/postmaster/postmaster.c:3519 [10:42:07.770] startup_data = {canAcceptConnections = CAC_OK} [10:42:07.770] bn = 0x8360e30c8 [10:42:07.770] cac = CAC_OK [10:42:07.770] pid = [10:42:07.770] __error = [10:42:07.770] save_errno = [10:42:07.770] __error = [10:42:07.770] __error = [10:42:07.770] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [10:42:07.770] 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 = "\f", '\000' , "\260\276\016!\b\000\000\000h\025\241*\b\000\000\000\372\000\000\000\000\000\000\000^\237\241*\b", '\000' , "\360\276\016!\b\000\000\000\264Y\211\000\000\000\000\000\000\277\016!\b", '\000' }, salen = 16}} [10:42:07.770] i = 0 [10:42:07.770] now = [10:42:07.770] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 906610136, events = 8, fd = 554613904, user_data = 0x8210eb9f0}, {pos = 8192, events = 0, fd = 8192, user_data = 0x83610f000}, {pos = 554613240, events = 8, fd = 0, user_data = 0x8344da090}, {pos = 1, events = 0, fd = 554613040, user_data = 0x82b6c99c9}, {pos = 726852488, events = 8, fd = 726945144, user_data = 0x8210eb948}, {pos = 554613184, events = 8, fd = 554613232, user_data = 0x8210eb9e8}, {pos = 877502608, events = 8, fd = 899680640, user_data = 0x20}, {pos = 4096, events = 0, fd = 554613680, user_data = 0x82b6c4a7c}, {pos = 554613224, events = 8, fd = 2123305738, user_data = 0x82b526858}, {pos = 726945144, events = 8, fd = 554613176, user_data = 0x8210eba30}, {pos = 554613176, events = 8, fd = 726908172, user_data = 0x821375408}, {pos = 726908172, events = 8, fd = 554613280, user_data = 0xede7e8ec43a}, {pos = 877502656, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 899691064, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82137a288}, {pos = 726820952, events = 8, fd = 557274120, user_data = 0x8210ebab8}, {pos = 554613880, events = 8, fd = 554613408, user_data = 0xede7e8f0ca2}, {pos = 2722108, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 557297720, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554614136, user_data = 0x21375408}, {pos = 554613952, events = 8, fd = 554613552, user_data = 0x1}, {pos = 554613880, events = 8, fd = 32, user_data = 0x8210ebb20}, {pos = 2123303539, events = 3806, fd = 554613824, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82137b038}, {pos = 1, events = 8, fd = 557274120, user_data = 0x82b526858}, {pos = 554614136, events = 8, fd = 554613952, user_data = 0x8210ebb30}, {pos = 0, events = 0, fd = 557244424, user_data = 0x20}, {pos = 554613936, events = 8, fd = 2123279079, user_data = 0x82136e008}, {pos = 557245448, events = 8, fd = 557246472, user_data = 0x82136ec08}, {pos = 557260808, events = 8, fd = 557261832, user_data = 0x821372808}, {pos = 557263880, events = 8, fd = 557264904, user_data = 0x821373408}, {pos = 557266952, events = 8, fd = 557267976, user_data = 0x821374008}, {pos = 557270024, events = 8, fd = 557271048, user_data = 0x821374c08}, {pos = 557273096, events = 8, fd = 557274120, user_data = 0x821375808}, {pos = 557276168, events = 8, fd = 557277192, user_data = 0x821376408}, {pos = 557279240, events = 8, fd = 557280264, user_data = 0x821377008}, {pos = 557282312, events = 8, fd = 557283336, user_data = 0x821377c08}, {pos = 557289480, events = 8, fd = 557290504, user_data = 0x821379808}, {pos = 557292552, events = 8, fd = 557244424, user_data = 0x29893c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82137b038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554614136, events = 8, fd = 554613552, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 557297720, user_data = 0x1}, {pos = 557244424, events = 8, fd = 298, user_data = 0x8210ebd60}, {pos = 2123277807, events = 3806, fd = 2722108, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 557297720, user_data = 0x1}, {pos = 557274120, events = 8, fd = 906166272, user_data = 0x1}, {pos = 906166676, events = 8, fd = 0, user_data = 0x8210ebd30}, {pos = 715232620, events = 8, fd = 1, user_data = 0x836030000}, {pos = 554614112, events = 8, fd = 715228930, user_data = 0x82b658170 }, {pos = 12479616, events = 0, fd = 728072560, user_data = 0x821375408}, {pos = 554614336, events = 8, fd = 2123277278, user_data = 0x83604e800}, {pos = 1, events = 8, fd = 2123276894, user_data = 0x82136e008}, {pos = 554614120, events = 8, fd = 554614336, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 2123356560, user_data = 0x0}, {pos = 554566527, events = 8, fd = 8134455, user_data = 0x8210ebdf0}, {pos = 715191312, events = 8, fd = 728735792, user_data = 0x82b6fc310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8210ebe20}, {pos = 715234205, events = 8, fd = 906166272, user_data = 0x1d8e}, {pos = 554614400, events = 8, fd = 715200762, user_data = 0x0}, {pos = 0, events = 0, fd = -541753526, user_data = 0x0}} [10:42:07.770] last_touch_time = 1737887763 [10:42:07.770] last_lockfile_recheck_time = 1737887763 [10:42:07.770] nevents = 1 [10:42:07.770] #21 0x0000000000898404 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8210ec478) at ../src/backend/postmaster/postmaster.c:1386 [10:42:07.770] userDoption = [10:42:07.770] listen_addr_saved = false [10:42:07.770] output_config_variable = [10:42:07.770] opt = [10:42:07.770] status = [10:42:07.770] #22 0x00000000007cec10 in main (argc=8, argv=0x8210ec478) at ../src/backend/main/main.c:230 [10:42:07.770] do_check_root = [10:42:07.770] dispatch_option = DISPATCH_POSTMASTER [10:42:07.780] [10:42:07.780] [10:42:07.780] [10:42:07.839] dumping /tmp/cores/postgres.11302.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:42:07.963] [New LWP 101889] [10:42:08.030] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [10:42:08.030] Program terminated with signal SIGABRT, Aborted. [10:42:08.030] Sent by thr_kill() from pid 11302 and user 1003. [10:42:08.030] #0 0x000000082b5c341a in thr_kill () from /lib/libc.so.7 [10:42:08.066] [10:42:08.066] Thread 1 (LWP 101889): [10:42:08.066] #0 0x000000082b5c341a in thr_kill () from /lib/libc.so.7 [10:42:08.066] No symbol table info available. [10:42:08.066] #1 0x000000082b53ce64 in raise () from /lib/libc.so.7 [10:42:08.066] No symbol table info available. [10:42:08.066] #2 0x000000082b5ed6f9 in abort () from /lib/libc.so.7 [10:42:08.066] No symbol table info available. [10:42:08.066] #3 0x0000000000aa2835 in ExceptionalCondition (conditionName=0x2ed272 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [10:42:08.066] No locals. [10:42:08.066] #4 0x0000000000769949 in standard_ExecutorStart (queryDesc=0x834001bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [10:42:08.066] estate = 0x834040100 [10:42:08.066] oldcontext = 0x833ff4800 [10:42:08.066] #5 0x00000000006fdb8f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [10:42:08.066] copied_query = [10:42:08.066] rewritten = [10:42:08.066] plan = 0x834001778 [10:42:08.066] queryDesc = 0x834001bd0 [10:42:08.066] processed = [10:42:08.066] __error = [10:42:08.066] #6 RefreshMatViewByOid (matviewOid=28625, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [10:42:08.066] dest = [10:42:08.066] save_userid = 10 [10:42:08.066] save_sec_context = 0 [10:42:08.066] processed = 0 [10:42:08.066] matviewRel = 0x8412103c8 [10:42:08.066] relowner = 10 [10:42:08.066] save_nestlevel = 2 [10:42:08.066] rule = [10:42:08.066] actions = [10:42:08.066] dataQuery = [10:42:08.066] tableSpace = [10:42:08.066] relpersistence = [10:42:08.066] OIDNewHeap = 28646 [10:42:08.066] address = [10:42:08.066] #7 0x00000000006fd766 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [10:42:08.066] lockmode = [10:42:08.066] matviewOid = 0 [10:42:08.066] #8 0x00000000006d475c in ExecCreateTableAs (pstate=pstate@entry=0x833ff4900, stmt=stmt@entry=0x833f55fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820f24950) at ../src/backend/commands/createas.c:351 [10:42:08.066] refresh = 0x0 [10:42:08.066] query = 0x8410fbf18 [10:42:08.066] into = 0x8410fc260 [10:42:08.066] jstate = 0x0 [10:42:08.066] do_refresh = false [10:42:08.066] address = [10:42:08.066] dest = [10:42:08.066] is_matview = [10:42:08.066] #9 0x000000000094a0bb in ProcessUtilitySlow (pstate=pstate@entry=0x833ff4900, pstmt=pstmt@entry=0x833e76a68, queryString=queryString@entry=0x833e75100 "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=0x820f24950) at ../src/backend/tcop/utility.c:1678 [10:42:08.066] _local_sigjmp_buf = {{_sjb = {9738473, 0, 34912486776, 34912487152, 34912486784, 12562776, 0, 35232106752, 12452735, 1, 4294967295, 34359738368}}} [10:42:08.066] _save_exception_stack = 0x820f24850 [10:42:08.066] _save_context_stack = 0x0 [10:42:08.066] _do_rethrow = false [10:42:08.066] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [10:42:08.066] parsetree = 0x833f55fd0 [10:42:08.066] commandCollected = false [10:42:08.066] needCleanup = false [10:42:08.066] address = [10:42:08.066] isTopLevel = [10:42:08.066] isCompleteQuery = [10:42:08.066] #10 0x0000000000948a38 in standard_ProcessUtility (pstmt=0x833e76a68, queryString=0x833e75100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8410fc748, qc=0x820f24950) at ../src/backend/tcop/utility.c:1033 [10:42:08.066] isAtomicContext = false [10:42:08.066] parsetree = 0x833f55fd0 [10:42:08.066] readonly_flags = [10:42:08.066] pstate = 0x833ff4900 [10:42:08.066] isTopLevel = [10:42:08.066] #11 0x00000000009484c8 in ProcessUtility (pstmt=0x18e01, queryString=0x6 , readOnlyTree=, context=727462906, params=0x0, queryEnv=0x0, dest=0x8410fc748, qc=0x820f24950) at ../src/backend/tcop/utility.c:523 [10:42:08.066] No locals. [10:42:08.066] #12 0x0000000000948003 in PortalRunUtility (portal=0x833f1b100, pstmt=0x833e76a68, isTopLevel=, setHoldSnapshot=, dest=0x8410fc748, qc=0x820f24950) at ../src/backend/tcop/pquery.c:1152 [10:42:08.066] No locals. [10:42:08.066] #13 0x00000000009476c4 in PortalRunMulti (portal=portal@entry=0x833f1b100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8410fc748, altdest=altdest@entry=0x8410fc748, qc=qc@entry=0x820f24950) at ../src/backend/tcop/pquery.c:1316 [10:42:08.066] pstmt = 0x833e76a68 [10:42:08.066] stmtlist_item__state = {l = 0x8410fc6f8, i = 0} [10:42:08.066] active_snapshot_set = false [10:42:08.066] stmtlist_item = 0x8410fc710 [10:42:08.066] #14 0x0000000000946fab in PortalRun (portal=portal@entry=0x833f1b100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8410fc748, altdest=altdest@entry=0x8410fc748, qc=qc@entry=0x820f24950) at ../src/backend/tcop/pquery.c:787 [10:42:08.066] _local_sigjmp_buf = {{_sjb = {9727781, 35231215872, 34912487496, 34912487744, 34912487504, 12562776, 34912487760, 12517208, 12452735, 0, 35231171455, 34359738368}}} [10:42:08.066] _save_exception_stack = 0x820f24a00 [10:42:08.066] _save_context_stack = 0x0 [10:42:08.066] _do_rethrow = false [10:42:08.066] saveTopTransactionResourceOwner = 0x833f6a518 [10:42:08.066] saveTopTransactionContext = 0x833f1f000 [10:42:08.066] saveActivePortal = 0x0 [10:42:08.066] saveResourceOwner = 0x833f6a518 [10:42:08.066] savePortalContext = 0x0 [10:42:08.066] saveMemoryContext = 0x833f1f000 [10:42:08.066] result = [10:42:08.066] nprocessed = [10:42:08.066] #15 0x0000000000945e39 in exec_simple_query (query_string=query_string@entry=0x833e75100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [10:42:08.066] cmdtaglen = 24 [10:42:08.066] snapshot_set = [10:42:08.066] per_parsetree_context = 0x0 [10:42:08.066] plantree_list = [10:42:08.066] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:42:08.066] format = 0 [10:42:08.066] parsetree = 0x833e766a8 [10:42:08.066] commandTag = [10:42:08.066] cmdtagname = [10:42:08.066] querytree_list = [10:42:08.066] portal = 0x833f1b100 [10:42:08.066] receiver = 0x8410fc748 [10:42:08.066] parsetree_item__state = {l = 0x833e76a18, i = 0} [10:42:08.066] msec_str = "\000\000\000\000\b", '\000' , ",\020\226g\000\000\000\000ҾϝIy\225", [10:42:08.066] dest = DestRemote [10:42:08.066] was_logged = [10:42:08.066] oldcontext = 0x833f1f000 [10:42:08.066] parsetree_list = 0x833e76a18 [10:42:08.066] use_implicit_block = false [10:42:08.066] parsetree_item = 0x833e76a30 [10:42:08.066] save_log_statement_stats = [10:42:08.066] #16 0x0000000000943aa3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [10:42:08.066] query_string = 0x833e75100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [10:42:08.066] input_message = {data = 0x833e75100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [10:42:08.066] firstchar = [10:42:08.066] local_sigjmp_buf = {{_sjb = {9711446, 34912487936, 34912487928, 34912488480, 12571528, 1, 8192, 8388608, 34912469887, 0, 0, 1}}} [10:42:08.066] send_ready_for_query = false [10:42:08.066] idle_in_transaction_timeout_enabled = false [10:42:08.066] idle_session_timeout_enabled = false [10:42:08.066] #17 0x000000000093e449 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:42:08.066] bsdata = [10:42:08.066] #18 0x0000000000895c25 in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x820f25730 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f25680) at ../src/backend/postmaster/launch_backend.c:274 [10:42:08.066] pid = [10:42:08.066] #19 0x0000000000899fcb in BackendStartup (client_sock=0x820f25680) at ../src/backend/postmaster/postmaster.c:3519 [10:42:08.066] startup_data = {canAcceptConnections = CAC_OK} [10:42:08.066] bn = 0x833f39338 [10:42:08.066] cac = CAC_OK [10:42:08.066] pid = [10:42:08.066] __error = [10:42:08.066] save_errno = [10:42:08.066] __error = [10:42:08.066] __error = [10:42:08.066] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [10:42:08.066] 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 = "\f", '\000' , "\340V\362 \b\000\000\000h5\242+\b\000\000\000\346\000\000\000\000\000\000\000^\277\242+\b", '\000' , " W\362 \b\000\000\000\264Y\211\000\000\000\000\0000W\362 \b", '\000' }, salen = 16}} [10:42:08.066] i = 0 [10:42:08.066] now = [10:42:08.066] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 871232984, events = 8, fd = 552752320, user_data = 0x0}, {pos = 0, events = 0, fd = -839670744, user_data = 0xcf3f2e7830a}, {pos = 726255520, events = 8, fd = 726326648, user_data = 0x820f25148}, {pos = 552751552, events = 8, fd = 552751432, user_data = 0xcf3f2e7830a}, {pos = 726233992, events = 8, fd = 726326648, user_data = 0x820f25178}, {pos = 552751600, events = 8, fd = 552751480, user_data = 0x82b4a6194}, {pos = 566342664, events = 8, fd = 726294932, user_data = 0x820f251e0}, {pos = -219728838, events = 3315, fd = 728117296, user_data = 0x1}, {pos = 552751632, events = 8, fd = -219708662, user_data = 0x82b48f858}, {pos = 726326648, events = 8, fd = 552751592, user_data = 0x820f25260}, {pos = 552751592, events = 8, fd = 726289676, user_data = 0x821c1b408}, {pos = 726289676, events = 8, fd = 552751696, user_data = 0xcf3f2e7343a}, {pos = 552751736, events = 8, fd = 552752184, user_data = 0x820f25260}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 215598689, fd = 566366264, user_data = 0x800000001}, {pos = 566342664, events = 8, fd = 726233992, user_data = 0x821c20288}, {pos = 726202456, events = 8, fd = 566342664, user_data = 0x820f252e8}, {pos = 552752296, events = 8, fd = 552751824, user_data = 0xcf3f2e77ca2}, {pos = 2722108, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 566366264, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 552752552, user_data = 0x21c1b408}, {pos = 552752368, events = 8, fd = 552751968, user_data = 0x1}, {pos = 552752296, events = 8, fd = 32, user_data = 0x820f25350}, {pos = -219710861, events = 3315, fd = 552752240, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821c21038}, {pos = 1, events = 8, fd = 566342664, user_data = 0x82b48f858}, {pos = 552752552, events = 8, fd = 552752368, user_data = 0x820f25360}, {pos = 0, events = 0, fd = 566312968, user_data = 0x20}, {pos = 552752352, events = 8, fd = -219735321, user_data = 0x821c14008}, {pos = 566313992, events = 8, fd = 566315016, user_data = 0x821c14c08}, {pos = 566329352, events = 8, fd = 566330376, user_data = 0x821c18808}, {pos = 566332424, events = 8, fd = 566333448, user_data = 0x821c19408}, {pos = 566335496, events = 8, fd = 566336520, user_data = 0x821c1a008}, {pos = 566338568, events = 8, fd = 566339592, user_data = 0x821c1ac08}, {pos = 566341640, events = 8, fd = 566342664, user_data = 0x821c1b808}, {pos = 566344712, events = 8, fd = 566345736, user_data = 0x821c1c408}, {pos = 566347784, events = 8, fd = 566348808, user_data = 0x821c1d008}, {pos = 566350856, events = 8, fd = 566351880, user_data = 0x821c1dc08}, {pos = 566358024, events = 8, fd = 566359048, user_data = 0x821c1f808}, {pos = 566361096, events = 8, fd = 566312968, user_data = 0x29893c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821c21038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552752552, events = 8, fd = 552751968, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 566366264, user_data = 0x1}, {pos = 566312968, events = 8, fd = 298, user_data = 0x820f25590}, {pos = -219736593, events = 3315, fd = 2722108, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 566366264, user_data = 0x1}, {pos = 566342664, events = 8, fd = 870731776, user_data = 0x1}, {pos = 870732180, events = 8, fd = 0, user_data = 0x820f25560}, {pos = 732083564, events = 8, fd = 1, user_data = 0x833e65000}, {pos = 552752528, events = 8, fd = 732079874, user_data = 0x82b5c1170 }, {pos = 12479616, events = 0, fd = 727454064, user_data = 0x821c1b408}, {pos = 552752752, events = 8, fd = -219737122, user_data = 0x833e83800}, {pos = 1, events = 8, fd = -219737506, user_data = 0x821c14008}, {pos = 552752536, events = 8, fd = 552752752, user_data = 0x1ab8}, {pos = 11, events = 0, fd = -219657840, user_data = 0x0}, {pos = 552731519, events = 8, fd = 8134455, user_data = 0x820f25620}, {pos = 732042256, events = 8, fd = 728117296, user_data = 0x82b665310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820f25650}, {pos = 732085149, events = 8, fd = 870731776, user_data = 0x1dbc}, {pos = 552752816, events = 8, fd = 732051706, user_data = 0x0}, {pos = 0, events = 0, fd = -839670744, user_data = 0x0}} [10:42:08.066] last_touch_time = 1737887763 [10:42:08.066] last_lockfile_recheck_time = 1737887763 [10:42:08.066] nevents = 1 [10:42:08.066] #21 0x0000000000898404 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f25ca8) at ../src/backend/postmaster/postmaster.c:1386 [10:42:08.066] userDoption = [10:42:08.066] listen_addr_saved = false [10:42:08.066] output_config_variable = [10:42:08.066] opt = [10:42:08.066] status = [10:42:08.066] #22 0x00000000007cec10 in main (argc=4, argv=0x820f25ca8) at ../src/backend/main/main.c:230 [10:42:08.066] do_check_root = [10:42:08.066] dispatch_option = DISPATCH_POSTMASTER [10:42:08.076] [10:42:08.076] [10:42:08.076] [10:42:08.137] dumping /tmp/cores/postgres.17626.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [10:42:08.265] [New LWP 101903] [10:42:08.335] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [10:42:08.335] Program terminated with signal SIGABRT, Aborted. [10:42:08.335] Sent by thr_kill() from pid 17626 and user 1003. [10:42:08.335] #0 0x000000082c52641a in thr_kill () from /lib/libc.so.7 [10:42:08.377] [10:42:08.377] Thread 1 (LWP 101903): [10:42:08.377] #0 0x000000082c52641a in thr_kill () from /lib/libc.so.7 [10:42:08.377] No symbol table info available. [10:42:08.377] #1 0x000000082c49fe64 in raise () from /lib/libc.so.7 [10:42:08.377] No symbol table info available. [10:42:08.377] #2 0x000000082c5506f9 in abort () from /lib/libc.so.7 [10:42:08.377] No symbol table info available. [10:42:08.377] #3 0x0000000000aa2835 in ExceptionalCondition (conditionName=0x2ed272 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [10:42:08.377] No locals. [10:42:08.377] #4 0x0000000000769949 in standard_ExecutorStart (queryDesc=0x83873bbd0, eflags=0) at ../src/backend/executor/execMain.c:193 [10:42:08.377] estate = 0x83e0e4100 [10:42:08.377] oldcontext = 0x83e098800 [10:42:08.377] #5 0x000000083b5159c2 in pgss_ExecutorStart (queryDesc=0x83873bbd0, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [10:42:08.377] No locals. [10:42:08.377] #6 0x00000000006fdb8f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [10:42:08.377] copied_query = [10:42:08.377] rewritten = [10:42:08.377] plan = 0x83873b778 [10:42:08.377] queryDesc = 0x83873bbd0 [10:42:08.377] processed = [10:42:08.377] __error = [10:42:08.377] #7 RefreshMatViewByOid (matviewOid=28736, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [10:42:08.377] dest = [10:42:08.377] save_userid = 10 [10:42:08.377] save_sec_context = 0 [10:42:08.377] processed = 0 [10:42:08.377] matviewRel = 0x83e22c2e8 [10:42:08.377] relowner = 10 [10:42:08.377] save_nestlevel = 2 [10:42:08.377] rule = [10:42:08.377] actions = [10:42:08.377] dataQuery = [10:42:08.377] tableSpace = [10:42:08.377] relpersistence = [10:42:08.377] OIDNewHeap = 28755 [10:42:08.377] address = [10:42:08.377] #8 0x00000000006fd766 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [10:42:08.377] lockmode = [10:42:08.377] matviewOid = 0 [10:42:08.377] #9 0x00000000006d475c in ExecCreateTableAs (pstate=pstate@entry=0x83e098900, stmt=stmt@entry=0x8386c4fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8217af120) at ../src/backend/commands/createas.c:351 [10:42:08.377] refresh = 0x0 [10:42:08.377] query = 0x83864ffc8 [10:42:08.377] into = 0x8386c4f40 [10:42:08.377] jstate = 0x0 [10:42:08.377] do_refresh = false [10:42:08.377] address = [10:42:08.377] dest = [10:42:08.377] is_matview = [10:42:08.377] #10 0x000000000094a0bb in ProcessUtilitySlow (pstate=pstate@entry=0x83e098900, pstmt=pstmt@entry=0x8386c4e30, queryString=queryString@entry=0x838567100 "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=0x8217af120) at ../src/backend/tcop/utility.c:1678 [10:42:08.377] _local_sigjmp_buf = {{_sjb = {9738473, 0, 34921442184, 34921442560, 34921442192, 12562776, 0, 35400550656, 895, 1, 34921442316, 0}}} [10:42:08.377] _save_exception_stack = 0x8217aee10 [10:42:08.377] _save_context_stack = 0x0 [10:42:08.377] _do_rethrow = false [10:42:08.377] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [10:42:08.377] parsetree = 0x8386c4fd0 [10:42:08.377] commandCollected = false [10:42:08.377] needCleanup = false [10:42:08.377] address = [10:42:08.377] isTopLevel = [10:42:08.377] isCompleteQuery = [10:42:08.377] #11 0x0000000000948a38 in standard_ProcessUtility (pstmt=0x8386c4e30, queryString=queryString@entry=0x838567100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838650768, qc=0x8217af120) at ../src/backend/tcop/utility.c:1033 [10:42:08.377] isAtomicContext = false [10:42:08.377] parsetree = 0x8386c4fd0 [10:42:08.377] readonly_flags = [10:42:08.377] pstate = 0x83e098900 [10:42:08.377] isTopLevel = [10:42:08.377] #12 0x000000083b515f6d in pgss_ProcessUtility (pstmt=0x8386c4e30, queryString=0x838567100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838650768, qc=0x8217af120) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [10:42:08.377] _local_sigjmp_buf = {{_sjb = {35354926758, 34921442832, 34921442696, 34921443152, 35306360368, 0, 12562776, 34921443360, 895, 1, 34921442948, 34359738368}}} [10:42:08.377] _save_exception_stack = 0x8217af020 [10:42:08.377] _save_context_stack = 0x0 [10:42:08.377] _do_rethrow = false [10:42:08.377] bufusage = {shared_blks_hit = 35354926758, shared_blks_read = 34921442832, shared_blks_dirtied = 34921442696, shared_blks_written = 34921443152, local_blks_hit = 35306360368, local_blks_read = 0, local_blks_dirtied = 12562776, local_blks_written = 34921443360, temp_blks_read = 895, temp_blks_written = 1, shared_blk_read_time = {ticks = 34921442948}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4324227504744315392}, local_blk_write_time = {ticks = 12571704}, temp_blk_read_time = {ticks = 35370765440}, temp_blk_write_time = {ticks = 12513168}} [10:42:08.377] walusage_start = {wal_records = 9007, wal_fpi = 155, wal_bytes = 1421429} [10:42:08.377] duration = [10:42:08.377] bufusage_start = {shared_blks_hit = 153729, shared_blks_read = 10020, shared_blks_dirtied = 2827, shared_blks_written = 2245, 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}} [10:42:08.377] walusage = {wal_records = 0, wal_fpi = 549755813888, wal_bytes = 4796957084024864220} [10:42:08.377] start = {ticks = -194069052118} [10:42:08.377] rows = [10:42:08.377] saved_queryId = 7267788456574341698 [10:42:08.377] parsetree = [10:42:08.377] saved_stmt_location = 0 [10:42:08.377] saved_stmt_len = 69 [10:42:08.377] enabled = [10:42:08.377] #13 0x0000000000948003 in PortalRunUtility (portal=0x83860d100, pstmt=0x8386c4e30, isTopLevel=, setHoldSnapshot=, dest=0x838650768, qc=0x8217af120) at ../src/backend/tcop/pquery.c:1152 [10:42:08.377] No locals. [10:42:08.377] #14 0x00000000009476c4 in PortalRunMulti (portal=portal@entry=0x83860d100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x838650768, altdest=altdest@entry=0x838650768, qc=qc@entry=0x8217af120) at ../src/backend/tcop/pquery.c:1316 [10:42:08.377] pstmt = 0x8386c4e30 [10:42:08.377] stmtlist_item__state = {l = 0x838650718, i = 0} [10:42:08.377] active_snapshot_set = false [10:42:08.377] stmtlist_item = 0x838650730 [10:42:08.377] #15 0x0000000000946fab in PortalRun (portal=portal@entry=0x83860d100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x838650768, altdest=altdest@entry=0x838650768, qc=qc@entry=0x8217af120) at ../src/backend/tcop/pquery.c:787 [10:42:08.377] _local_sigjmp_buf = {{_sjb = {9727781, 35305607424, 34921443352, 34921443600, 34921443360, 12562776, 34921443616, 12517208, 12452735, 0, 35305554815, 34359738368}}} [10:42:08.377] _save_exception_stack = 0x8217af1d0 [10:42:08.377] _save_context_stack = 0x0 [10:42:08.377] _do_rethrow = false [10:42:08.377] saveTopTransactionResourceOwner = 0x838663058 [10:42:08.377] saveTopTransactionContext = 0x838611000 [10:42:08.377] saveActivePortal = 0x0 [10:42:08.377] saveResourceOwner = 0x838663058 [10:42:08.377] savePortalContext = 0x0 [10:42:08.377] saveMemoryContext = 0x838611000 [10:42:08.377] result = [10:42:08.377] nprocessed = [10:42:08.377] #16 0x0000000000945e39 in exec_simple_query (query_string=query_string@entry=0x838567100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [10:42:08.377] cmdtaglen = 24 [10:42:08.377] snapshot_set = [10:42:08.377] per_parsetree_context = 0x0 [10:42:08.377] plantree_list = [10:42:08.377] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [10:42:08.377] format = 0 [10:42:08.377] parsetree = 0x8385686a8 [10:42:08.377] commandTag = [10:42:08.377] cmdtagname = [10:42:08.377] querytree_list = [10:42:08.377] portal = 0x83860d100 [10:42:08.377] receiver = 0x838650768 [10:42:08.377] parsetree_item__state = {l = 0x838568a18, i = 0} [10:42:08.377] msec_str = "\000\000\000\000\b", '\000' , "R\020\226g\000\000\000\000b\216\307h\026\226", [10:42:08.377] dest = DestRemote [10:42:08.377] was_logged = [10:42:08.377] oldcontext = 0x838611000 [10:42:08.377] parsetree_list = 0x838568a18 [10:42:08.377] use_implicit_block = false [10:42:08.377] parsetree_item = 0x838568a30 [10:42:08.377] save_log_statement_stats = [10:42:08.377] #17 0x0000000000943aa3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [10:42:08.377] query_string = 0x838567100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [10:42:08.377] input_message = {data = 0x838567100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [10:42:08.377] firstchar = [10:42:08.377] local_sigjmp_buf = {{_sjb = {9711446, 34921443792, 34921443784, 34921444336, 12571528, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [10:42:08.377] send_ready_for_query = false [10:42:08.377] idle_in_transaction_timeout_enabled = false [10:42:08.377] idle_session_timeout_enabled = false [10:42:08.377] #18 0x000000000093e449 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [10:42:08.377] bsdata = [10:42:08.377] #19 0x0000000000895c25 in postmaster_child_launch (child_type=B_BACKEND, child_slot=12, startup_data=startup_data@entry=0x8217aff00 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8217afe50) at ../src/backend/postmaster/launch_backend.c:274 [10:42:08.377] pid = [10:42:08.377] #20 0x0000000000899fcb in BackendStartup (client_sock=0x8217afe50) at ../src/backend/postmaster/postmaster.c:3519 [10:42:08.377] startup_data = {canAcceptConnections = CAC_OK} [10:42:08.377] bn = 0x83864f1c8 [10:42:08.377] cac = CAC_OK [10:42:08.377] pid = [10:42:08.377] __error = [10:42:08.377] save_errno = [10:42:08.377] __error = [10:42:08.377] __error = [10:42:08.377] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [10:42:08.377] 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 = "\f", '\000' , "\260\376z!\b\000\000\000h\265Z+\b\000\000\000W\000\000\000\000\000\000\000^?[+\b", '\000' , "\360\376z!\b\000\000\000\264Y\211\000\000\000\000\000\000\377z!\b", '\000' }, salen = 16}} [10:42:08.377] i = 0 [10:42:08.377] now = [10:42:08.377] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 945595864, events = 8, fd = 561708176, user_data = 0x0}, {pos = 1299460874, events = 7128, fd = 742389664, user_data = 0x82c410d78}, {pos = 561707272, events = 8, fd = 561707392, user_data = 0x8217af908}, {pos = 1299460874, events = 7128, fd = 742368136, user_data = 0x82c410d78}, {pos = 561707320, events = 8, fd = 561707440, user_data = 0x8217af938}, {pos = 742429076, events = 8, fd = 562799624, user_data = 0x82c409194}, {pos = 561707424, events = 8, fd = 1299440698, user_data = 0x8217af940}, {pos = 727356432, events = 8, fd = 744251440, user_data = 0x1bd84d74330a}, {pos = 742336600, events = 8, fd = 742460792, user_data = 0x8217af9a8}, {pos = 561707552, events = 8, fd = 561707432, user_data = 0x82c407d0c}, {pos = 562799624, events = 8, fd = 742423820, user_data = 0x8217afa10}, {pos = 1299440698, events = 7128, fd = 561707576, user_data = 0x8217afc08}, {pos = 561707552, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8218c0038}, {pos = 1, events = 1116878605, fd = 562799624, user_data = 0x82c3fa388}, {pos = 562821064, events = 8, fd = 0, user_data = 0x0}, {pos = 561707688, events = 8, fd = 561708152, user_data = 0x8217afa90}, {pos = 1299459234, events = 7128, fd = 2722108, user_data = 0x6d68b}, {pos = 2090263927, events = 1116878605, fd = 562823224, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8217afd78}, {pos = 562799624, events = 3, fd = 561708224, user_data = 0x8218bf828}, {pos = 656, events = 0, fd = 561708152, user_data = 0x8217afaa8}, {pos = 561707792, events = 8, fd = 1299458843, user_data = 0x8217afc40}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 562823224, events = 8, fd = 1, user_data = 0x8218ba408}, {pos = 742336600, events = 8, fd = 561708408, user_data = 0x8217afcc0}, {pos = 561707808, events = 8, fd = 0, user_data = 0x8218b3008}, {pos = 33, events = 0, fd = 561708208, user_data = 0x1bd84d73cae7}, {pos = 562769928, events = 8, fd = 562770952, user_data = 0x8218b3808}, {pos = 562773000, events = 8, fd = 562786312, user_data = 0x8218b7408}, {pos = 562788360, events = 8, fd = 562789384, user_data = 0x8218b8008}, {pos = 562791432, events = 8, fd = 562792456, user_data = 0x8218b8c08}, {pos = 562794504, events = 8, fd = 562795528, user_data = 0x8218b9808}, {pos = 562797576, events = 8, fd = 562798600, user_data = 0x8218ba408}, {pos = 562800648, events = 8, fd = 562801672, user_data = 0x8218bb008}, {pos = 562803720, events = 8, fd = 562804744, user_data = 0x8218bbc08}, {pos = 562806792, events = 8, fd = 562807816, user_data = 0x8218bc808}, {pos = 562809864, events = 8, fd = 562814984, user_data = 0x8218be408}, {pos = 562817032, events = 8, fd = 562818056, user_data = 0x8218c1408}, {pos = 799676000, events = 0, fd = 562769928, user_data = 0x29893c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8218c0038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 561708408, events = 8, fd = 561707808, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 562823224, user_data = 0x1}, {pos = 562769928, events = 8, fd = 298, user_data = 0x8217afd60}, {pos = 1299432943, events = 7128, fd = 2722108, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 562823224, user_data = 0x1}, {pos = 562799624, events = 8, fd = 945123328, user_data = 0x1}, {pos = 945123732, events = 8, fd = 0, user_data = 0x8217afd30}, {pos = 727397740, events = 8, fd = 1, user_data = 0x838557000}, {pos = 561708384, events = 8, fd = 727394050, user_data = 0x82c524170 }, {pos = 12479616, events = 0, fd = 743588208, user_data = 0x8218ba408}, {pos = 561708608, events = 8, fd = 1299432414, user_data = 0x838575800}, {pos = 1, events = 8, fd = 1299432030, user_data = 0x8218b3008}, {pos = 561708392, events = 8, fd = 561708608, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1299511696, user_data = 0x0}, {pos = 561644415, events = 8, fd = 8134455, user_data = 0x8217afdf0}, {pos = 727356432, events = 8, fd = 744251440, user_data = 0x82c5c8310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8217afe20}, {pos = 727399325, events = 8, fd = 945123328, user_data = 0x353e}, {pos = 561708672, events = 8, fd = 727365882, user_data = 0x0}, {pos = 0, events = 0, fd = 1947762140, user_data = 0x0}} [10:42:08.378] last_touch_time = 1737887799 [10:42:08.378] last_lockfile_recheck_time = 1737887799 [10:42:08.378] nevents = 1 [10:42:08.378] #22 0x0000000000898404 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8217b0478) at ../src/backend/postmaster/postmaster.c:1386 [10:42:08.378] userDoption = [10:42:08.378] listen_addr_saved = false [10:42:08.378] output_config_variable = [10:42:08.378] opt = [10:42:08.378] status = [10:42:08.378] #23 0x00000000007cec10 in main (argc=4, argv=0x8217b0478) at ../src/backend/main/main.c:230 [10:42:08.378] do_check_root = [10:42:08.378] dispatch_option = DISPATCH_POSTMASTER