[22:25:51.070] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [22:25:51.381] dumping /tmp/cores/postgres.10603.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:25:51.513] [New LWP 101913] [22:25:51.596] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [22:25:51.596] Program terminated with signal SIGABRT, Aborted. [22:25:51.596] Sent by thr_kill() from pid 10603 and user 1003. [22:25:51.596] #0 0x000000082deab41a in thr_kill () from /lib/libc.so.7 [22:25:51.650] [22:25:51.650] Thread 1 (LWP 101913): [22:25:51.650] #0 0x000000082deab41a in thr_kill () from /lib/libc.so.7 [22:25:51.650] No symbol table info available. [22:25:51.650] #1 0x000000082de24e64 in raise () from /lib/libc.so.7 [22:25:51.650] No symbol table info available. [22:25:51.650] #2 0x000000082ded56f9 in abort () from /lib/libc.so.7 [22:25:51.650] No symbol table info available. [22:25:51.650] #3 0x0000000000aa9db5 in ExceptionalCondition (conditionName=0x2ed1a4 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:25:51.650] No locals. [22:25:51.650] #4 0x0000000000773c69 in standard_ExecutorStart (queryDesc=0x839261bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [22:25:51.650] estate = 0x83c5dc100 [22:25:51.650] oldcontext = 0x83c533400 [22:25:51.650] #5 0x000000000070813f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [22:25:51.650] copied_query = [22:25:51.650] rewritten = [22:25:51.650] plan = 0x839261778 [22:25:51.650] queryDesc = 0x839261bd0 [22:25:51.650] processed = [22:25:51.650] __error = [22:25:51.650] #6 RefreshMatViewByOid (matviewOid=28465, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [22:25:51.650] dest = [22:25:51.650] save_userid = 10 [22:25:51.650] save_sec_context = 0 [22:25:51.650] processed = 0 [22:25:51.650] matviewRel = 0x83c6665b8 [22:25:51.650] relowner = 10 [22:25:51.650] save_nestlevel = 2 [22:25:51.650] rule = [22:25:51.650] actions = [22:25:51.650] dataQuery = [22:25:51.650] tableSpace = [22:25:51.650] relpersistence = [22:25:51.650] OIDNewHeap = 28472 [22:25:51.650] address = [22:25:51.650] #7 0x0000000000707d16 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:25:51.650] lockmode = [22:25:51.650] matviewOid = 0 [22:25:51.650] #8 0x00000000006decdc in ExecCreateTableAs (pstate=pstate@entry=0x83c533500, stmt=stmt@entry=0x83c53efd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82153fc10) at ../src/backend/commands/createas.c:351 [22:25:51.650] refresh = 0x0 [22:25:51.650] query = 0x839263858 [22:25:51.650] into = 0x839263ba0 [22:25:51.650] jstate = 0x0 [22:25:51.650] do_refresh = false [22:25:51.650] address = [22:25:51.650] dest = [22:25:51.650] is_matview = [22:25:51.650] #9 0x0000000000952efb in ProcessUtilitySlow (pstate=pstate@entry=0x83c533500, pstmt=pstmt@entry=0x8390e1a68, queryString=queryString@entry=0x8390e0100 "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=0x82153fc10) at ../src/backend/tcop/utility.c:1678 [22:25:51.650] _local_sigjmp_buf = {{_sjb = {9774889, 0, 34918889528, 34918889904, 34918889536, 12480584, 0, 35371824384, 12387199, 1, 4294967295, 34359738368}}} [22:25:51.650] _save_exception_stack = 0x82153fb10 [22:25:51.650] _save_context_stack = 0x0 [22:25:51.650] _do_rethrow = false [22:25:51.650] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:25:51.650] parsetree = 0x83c53efd0 [22:25:51.650] commandCollected = false [22:25:51.650] needCleanup = false [22:25:51.650] address = [22:25:51.650] isTopLevel = [22:25:51.650] isCompleteQuery = [22:25:51.650] #10 0x0000000000951878 in standard_ProcessUtility (pstmt=0x8390e1a68, queryString=0x8390e0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x839264088, qc=0x82153fc10) at ../src/backend/tcop/utility.c:1033 [22:25:51.650] isAtomicContext = false [22:25:51.650] parsetree = 0x83c53efd0 [22:25:51.650] readonly_flags = [22:25:51.650] pstate = 0x83c533500 [22:25:51.650] isTopLevel = [22:25:51.650] #11 0x0000000000951308 in ProcessUtility (pstmt=0x18e19, queryString=0x6 , readOnlyTree=, context=770356218, params=0x0, queryEnv=0x0, dest=0x839264088, qc=0x82153fc10) at ../src/backend/tcop/utility.c:523 [22:25:51.650] No locals. [22:25:51.650] #12 0x0000000000950e43 in PortalRunUtility (portal=0x8391b7100, pstmt=0x8390e1a68, isTopLevel=, setHoldSnapshot=, dest=0x839264088, qc=0x82153fc10) at ../src/backend/tcop/pquery.c:1152 [22:25:51.650] No locals. [22:25:51.650] #13 0x0000000000950504 in PortalRunMulti (portal=portal@entry=0x8391b7100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x839264088, altdest=altdest@entry=0x839264088, qc=qc@entry=0x82153fc10) at ../src/backend/tcop/pquery.c:1316 [22:25:51.650] pstmt = 0x8390e1a68 [22:25:51.650] stmtlist_item__state = {l = 0x839264038, i = 0} [22:25:51.650] active_snapshot_set = false [22:25:51.650] stmtlist_item = 0x839264050 [22:25:51.650] #14 0x000000000094fdeb in PortalRun (portal=portal@entry=0x8391b7100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x839264088, altdest=altdest@entry=0x839264088, qc=qc@entry=0x82153fc10) at ../src/backend/tcop/pquery.c:787 [22:25:51.650] _local_sigjmp_buf = {{_sjb = {9764197, 35317838080, 34918890248, 34918890496, 34918890256, 12480584, 34918890512, 12446184, 12387199, 0, 35317810047, 34359738368}}} [22:25:51.650] _save_exception_stack = 0x82153fcc0 [22:25:51.650] _save_context_stack = 0x0 [22:25:51.650] _do_rethrow = false [22:25:51.650] saveTopTransactionResourceOwner = 0x8391c6248 [22:25:51.650] saveTopTransactionContext = 0x8391bb000 [22:25:51.650] saveActivePortal = 0x0 [22:25:51.650] saveResourceOwner = 0x8391c6248 [22:25:51.650] savePortalContext = 0x0 [22:25:51.650] saveMemoryContext = 0x8391bb000 [22:25:51.650] result = [22:25:51.650] nprocessed = [22:25:51.650] #15 0x000000000094ec79 in exec_simple_query (query_string=query_string@entry=0x8390e0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:25:51.650] cmdtaglen = 24 [22:25:51.650] snapshot_set = [22:25:51.650] per_parsetree_context = 0x0 [22:25:51.650] plantree_list = [22:25:51.650] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:25:51.650] format = 0 [22:25:51.650] parsetree = 0x8390e16a8 [22:25:51.650] commandTag = [22:25:51.650] cmdtagname = [22:25:51.650] querytree_list = [22:25:51.650] portal = 0x8391b7100 [22:25:51.650] receiver = 0x839264088 [22:25:51.650] parsetree_item__state = {l = 0x8390e1a18, i = 0} [22:25:51.650] msec_str = "\000\000\000\000\b", '\000' , "\031@\204g\000\000\000\000\334\355\303MTɘ\020" [22:25:51.650] dest = DestRemote [22:25:51.650] was_logged = [22:25:51.650] oldcontext = 0x8391bb000 [22:25:51.650] parsetree_list = 0x8390e1a18 [22:25:51.650] use_implicit_block = false [22:25:51.650] parsetree_item = 0x8390e1a30 [22:25:51.650] save_log_statement_stats = [22:25:51.650] #16 0x000000000094c8e3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [22:25:51.650] query_string = 0x8390e0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:25:51.650] input_message = {data = 0x8390e0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:25:51.650] firstchar = [22:25:51.650] local_sigjmp_buf = {{_sjb = {9747862, 34918890688, 34918890680, 34918891232, 12489336, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [22:25:51.650] send_ready_for_query = false [22:25:51.650] idle_in_transaction_timeout_enabled = false [22:25:51.650] idle_session_timeout_enabled = false [22:25:51.650] #17 0x0000000000947289 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:25:51.650] bsdata = [22:25:51.650] #18 0x000000000089e875 in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x8215409f0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821540940) at ../src/backend/postmaster/launch_backend.c:274 [22:25:51.650] pid = [22:25:51.650] #19 0x00000000008a2dc6 in BackendStartup (client_sock=0x821540940) at ../src/backend/postmaster/postmaster.c:3466 [22:25:51.650] startup_data = {canAcceptConnections = CAC_OK} [22:25:51.650] bn = 0x839183068 [22:25:51.650] cac = CAC_OK [22:25:51.650] pid = [22:25:51.650] __error = [22:25:51.650] save_errno = [22:25:51.650] __error = [22:25:51.650] __error = [22:25:51.650] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:25:51.650] 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' , "\240\tT!\b\000\000\000he\262-\b\000\000\000\372\000\000\000\000\000\000\000^\357\262-\b", '\000' , "\340\tT!\b\000\000\000\004\346\211\000\000\000\000\000\360\tT!\b", '\000' }, salen = 16}} [22:25:51.650] i = 0 [22:25:51.650] now = [22:25:51.650] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 769981570, events = 8, fd = 0, user_data = 0x8215408f0}, {pos = 957597144, events = 8, fd = 559155072, user_data = 0x8215404e0}, {pos = 8192, events = 0, fd = 8192, user_data = 0x8391af000}, {pos = 559154408, events = 8, fd = 0, user_data = 0x837188090}, {pos = 1, events = 0, fd = 559154208, user_data = 0x82df1a9c9}, {pos = 769127304, events = 8, fd = 769219960, user_data = 0x821540438}, {pos = 559154352, events = 8, fd = 559154400, user_data = 0x8215404d8}, {pos = 924352656, events = 8, fd = 943720832, user_data = 0x20}, {pos = 4096, events = 0, fd = 559154848, user_data = 0x82df15a7c}, {pos = 559154392, events = 8, fd = 1761071882, user_data = 0x82dd77858}, {pos = 769219960, events = 8, fd = 559154344, user_data = 0x821540520}, {pos = 559154344, events = 8, fd = 769182988, user_data = 0x8223d4408}, {pos = 769182988, events = 8, fd = 559154448, user_data = 0x3de268f7843a}, {pos = 924352704, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 943731256, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8223d9288}, {pos = 769095768, events = 8, fd = 574440456, user_data = 0x8215405a8}, {pos = 559155048, events = 8, fd = 559154576, user_data = 0x3de268f7cca2}, {pos = 2721531, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 574464056, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 559155304, user_data = 0x223d4408}, {pos = 559155120, events = 8, fd = 559154720, user_data = 0x1}, {pos = 559155048, events = 8, fd = 32, user_data = 0x821540610}, {pos = 1761069683, events = 15842, fd = 559154992, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8223da038}, {pos = 1, events = 8, fd = 574440456, user_data = 0x82dd77858}, {pos = 559155304, events = 8, fd = 559155120, user_data = 0x821540620}, {pos = 0, events = 0, fd = 574410760, user_data = 0x20}, {pos = 559155104, events = 8, fd = 1761045223, user_data = 0x8223cd008}, {pos = 574411784, events = 8, fd = 574412808, user_data = 0x8223cdc08}, {pos = 574427144, events = 8, fd = 574428168, user_data = 0x8223d1808}, {pos = 574430216, events = 8, fd = 574431240, user_data = 0x8223d2408}, {pos = 574433288, events = 8, fd = 574434312, user_data = 0x8223d3008}, {pos = 574436360, events = 8, fd = 574437384, user_data = 0x8223d3c08}, {pos = 574439432, events = 8, fd = 574440456, user_data = 0x8223d4808}, {pos = 574442504, events = 8, fd = 574443528, user_data = 0x8223d5408}, {pos = 574445576, events = 8, fd = 574446600, user_data = 0x8223d6008}, {pos = 574448648, events = 8, fd = 574449672, user_data = 0x8223d6c08}, {pos = 574455816, events = 8, fd = 574456840, user_data = 0x8223d8808}, {pos = 574458888, events = 8, fd = 574410760, user_data = 0x2986fb}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8223da038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 559155304, events = 8, fd = 559154720, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 574464056, user_data = 0x1}, {pos = 574410760, events = 8, fd = 298, user_data = 0x821540850}, {pos = 1761043951, events = 15842, fd = 2721531, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 574464056, user_data = 0x1}, {pos = 574440456, events = 8, fd = 957153280, user_data = 0x1}, {pos = 957153684, events = 8, fd = 0, user_data = 0x821540820}, {pos = 766698860, events = 8, fd = 1, user_data = 0x8390d0000}, {pos = 559155280, events = 8, fd = 766695170, user_data = 0x82dea9170 }, {pos = 12408736, events = 0, fd = 770347376, user_data = 0x8223d4408}, {pos = 559155504, events = 8, fd = 1761043422, user_data = 0x8390ee800}, {pos = 1, events = 0, fd = 1761043038, user_data = 0x8223cd008}, {pos = 559155288, events = 8, fd = 559155504, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1761122704, user_data = 0x0}, {pos = 559154047, events = 8, fd = 8173367, user_data = 0x8215408e0}, {pos = 766657552, events = 8, fd = 771010608, user_data = 0x82df4d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821540910}, {pos = 766700445, events = 8, fd = 957153280, user_data = 0x1da3}, {pos = 559155568, events = 8, fd = 766667002, user_data = 0x0}, {pos = 0, events = 0, fd = -2116588186, user_data = 0x0}} [22:25:51.650] last_touch_time = 1736720386 [22:25:51.650] last_lockfile_recheck_time = 1736720386 [22:25:51.650] nevents = 1 [22:25:51.650] #21 0x00000000008a1054 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821540f68) at ../src/backend/postmaster/postmaster.c:1377 [22:25:51.650] userDoption = [22:25:51.650] listen_addr_saved = false [22:25:51.650] output_config_variable = [22:25:51.650] opt = [22:25:51.650] status = [22:25:51.650] #22 0x00000000007d8410 in main (argc=8, argv=0x821540f68) at ../src/backend/main/main.c:230 [22:25:51.650] do_check_root = [22:25:51.650] dispatch_option = DISPATCH_POSTMASTER [22:25:51.659] [22:25:51.659] [22:25:51.659] [22:25:51.718] dumping /tmp/cores/postgres.11043.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:25:51.838] [New LWP 101876] [22:25:51.897] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [22:25:51.897] Program terminated with signal SIGABRT, Aborted. [22:25:51.897] Sent by thr_kill() from pid 11043 and user 1003. [22:25:51.897] #0 0x000000082c2be41a in thr_kill () from /lib/libc.so.7 [22:25:51.932] [22:25:51.932] Thread 1 (LWP 101876): [22:25:51.932] #0 0x000000082c2be41a in thr_kill () from /lib/libc.so.7 [22:25:51.932] No symbol table info available. [22:25:51.932] #1 0x000000082c237e64 in raise () from /lib/libc.so.7 [22:25:51.932] No symbol table info available. [22:25:51.932] #2 0x000000082c2e86f9 in abort () from /lib/libc.so.7 [22:25:51.932] No symbol table info available. [22:25:51.932] #3 0x0000000000aa9db5 in ExceptionalCondition (conditionName=0x2ed1a4 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:25:51.932] No locals. [22:25:51.932] #4 0x0000000000773c69 in standard_ExecutorStart (queryDesc=0x8359fcbd0, eflags=0) at ../src/backend/executor/execMain.c:193 [22:25:51.932] estate = 0x835af5100 [22:25:51.932] oldcontext = 0x835a9f400 [22:25:51.932] #5 0x000000000070813f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [22:25:51.932] copied_query = [22:25:51.932] rewritten = [22:25:51.932] plan = 0x8359fc778 [22:25:51.932] queryDesc = 0x8359fcbd0 [22:25:51.932] processed = [22:25:51.932] __error = [22:25:51.932] #6 RefreshMatViewByOid (matviewOid=28504, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [22:25:51.932] dest = [22:25:51.932] save_userid = 10 [22:25:51.932] save_sec_context = 0 [22:25:51.932] processed = 0 [22:25:51.932] matviewRel = 0x8392ce5f8 [22:25:51.932] relowner = 10 [22:25:51.932] save_nestlevel = 2 [22:25:51.932] rule = [22:25:51.932] actions = [22:25:51.932] dataQuery = [22:25:51.932] tableSpace = [22:25:51.932] relpersistence = [22:25:51.932] OIDNewHeap = 28520 [22:25:51.932] address = [22:25:51.932] #7 0x0000000000707d16 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:25:51.932] lockmode = [22:25:51.932] matviewOid = 0 [22:25:51.932] #8 0x00000000006decdc in ExecCreateTableAs (pstate=pstate@entry=0x835a9f500, stmt=stmt@entry=0x8359f0fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82138bca0) at ../src/backend/commands/createas.c:351 [22:25:51.932] refresh = 0x0 [22:25:51.932] query = 0x839232998 [22:25:51.932] into = 0x839232ce0 [22:25:51.932] jstate = 0x0 [22:25:51.932] do_refresh = false [22:25:51.932] address = [22:25:51.932] dest = [22:25:51.932] is_matview = [22:25:51.932] #9 0x0000000000952efb in ProcessUtilitySlow (pstate=pstate@entry=0x835a9f500, pstmt=pstmt@entry=0x83591da68, queryString=queryString@entry=0x83591c100 "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=0x82138bca0) at ../src/backend/tcop/utility.c:1678 [22:25:51.932] _local_sigjmp_buf = {{_sjb = {9774889, 0, 34917103816, 34917104192, 34917103824, 12480584, 0, 35260069120, 12387199, 1, 4294967295, 34359738368}}} [22:25:51.932] _save_exception_stack = 0x82138bba0 [22:25:51.932] _save_context_stack = 0x0 [22:25:51.932] _do_rethrow = false [22:25:51.932] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:25:51.932] parsetree = 0x8359f0fd0 [22:25:51.932] commandCollected = false [22:25:51.932] needCleanup = false [22:25:51.932] address = [22:25:51.932] isTopLevel = [22:25:51.932] isCompleteQuery = [22:25:51.932] #10 0x0000000000951878 in standard_ProcessUtility (pstmt=0x83591da68, queryString=0x83591c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8392331c8, qc=0x82138bca0) at ../src/backend/tcop/utility.c:1033 [22:25:51.932] isAtomicContext = false [22:25:51.932] parsetree = 0x8359f0fd0 [22:25:51.932] readonly_flags = [22:25:51.932] pstate = 0x835a9f500 [22:25:51.932] isTopLevel = [22:25:51.932] #11 0x0000000000951308 in ProcessUtility (pstmt=0x18df4, queryString=0x6 , readOnlyTree=, context=741073914, params=0x0, queryEnv=0x0, dest=0x8392331c8, qc=0x82138bca0) at ../src/backend/tcop/utility.c:523 [22:25:51.932] No locals. [22:25:51.932] #12 0x0000000000950e43 in PortalRunUtility (portal=0x8359c2100, pstmt=0x83591da68, isTopLevel=, setHoldSnapshot=, dest=0x8392331c8, qc=0x82138bca0) at ../src/backend/tcop/pquery.c:1152 [22:25:51.932] No locals. [22:25:51.932] #13 0x0000000000950504 in PortalRunMulti (portal=portal@entry=0x8359c2100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8392331c8, altdest=altdest@entry=0x8392331c8, qc=qc@entry=0x82138bca0) at ../src/backend/tcop/pquery.c:1316 [22:25:51.932] pstmt = 0x83591da68 [22:25:51.932] stmtlist_item__state = {l = 0x839233178, i = 0} [22:25:51.932] active_snapshot_set = false [22:25:51.932] stmtlist_item = 0x839233190 [22:25:51.932] #14 0x000000000094fdeb in PortalRun (portal=portal@entry=0x8359c2100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8392331c8, altdest=altdest@entry=0x8392331c8, qc=qc@entry=0x82138bca0) at ../src/backend/tcop/pquery.c:787 [22:25:51.932] _local_sigjmp_buf = {{_sjb = {9764197, 35259162880, 34917104536, 34917104784, 34917104544, 12480584, 34917104800, 12446184, 12387199, 0, 35259155327, 34359738368}}} [22:25:51.932] _save_exception_stack = 0x82138bd50 [22:25:51.932] _save_context_stack = 0x0 [22:25:51.932] _do_rethrow = false [22:25:51.932] saveTopTransactionResourceOwner = 0x835a11958 [22:25:51.932] saveTopTransactionContext = 0x8359c6000 [22:25:51.932] saveActivePortal = 0x0 [22:25:51.932] saveResourceOwner = 0x835a11958 [22:25:51.932] savePortalContext = 0x0 [22:25:51.932] saveMemoryContext = 0x8359c6000 [22:25:51.932] result = [22:25:51.932] nprocessed = [22:25:51.932] #15 0x000000000094ec79 in exec_simple_query (query_string=query_string@entry=0x83591c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:25:51.932] cmdtaglen = 24 [22:25:51.932] snapshot_set = [22:25:51.932] per_parsetree_context = 0x0 [22:25:51.932] plantree_list = [22:25:51.932] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:25:51.932] format = 0 [22:25:51.932] parsetree = 0x83591d6a8 [22:25:51.932] commandTag = [22:25:51.932] cmdtagname = [22:25:51.932] querytree_list = [22:25:51.932] portal = 0x8359c2100 [22:25:51.932] receiver = 0x8392331c8 [22:25:51.932] parsetree_item__state = {l = 0x83591da18, i = 0} [22:25:51.932] msec_str = "\000\000\000\000\b", '\000' , "\034@\204g\000\000\000\000\364\212\266\363\345RE\a" [22:25:51.932] dest = DestRemote [22:25:51.932] was_logged = [22:25:51.932] oldcontext = 0x8359c6000 [22:25:51.932] parsetree_list = 0x83591da18 [22:25:51.932] use_implicit_block = false [22:25:51.932] parsetree_item = 0x83591da30 [22:25:51.932] save_log_statement_stats = [22:25:51.932] #16 0x000000000094c8e3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [22:25:51.932] query_string = 0x83591c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:25:51.932] input_message = {data = 0x83591c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:25:51.932] firstchar = [22:25:51.932] local_sigjmp_buf = {{_sjb = {9747862, 34917104976, 34917104968, 34917105520, 12489336, 1, 8192, 8388608, 34917057407, 0, 0, 1}}} [22:25:51.932] send_ready_for_query = false [22:25:51.932] idle_in_transaction_timeout_enabled = false [22:25:51.932] idle_session_timeout_enabled = false [22:25:51.932] #17 0x0000000000947289 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:25:51.932] bsdata = [22:25:51.932] #18 0x000000000089e875 in postmaster_child_launch (child_type=B_BACKEND, child_slot=18, startup_data=startup_data@entry=0x82138ca80 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82138c9d0) at ../src/backend/postmaster/launch_backend.c:274 [22:25:51.932] pid = [22:25:51.932] #19 0x00000000008a2dc6 in BackendStartup (client_sock=0x82138c9d0) at ../src/backend/postmaster/postmaster.c:3466 [22:25:51.932] startup_data = {canAcceptConnections = CAC_OK} [22:25:51.932] bn = 0x8359e0368 [22:25:51.932] cac = CAC_OK [22:25:51.932] pid = [22:25:51.932] __error = [22:25:51.932] save_errno = [22:25:51.932] __error = [22:25:51.932] __error = [22:25:51.932] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:25:51.932] 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' , "0\3128!\b\000\000\000h\265\034*\b\000\000\000\346\000\000\000\000\000\000\000^?\035*\b", '\000' , "p\3128!\b\000\000\000\004\346\211\000\000\000\000\000\200\3128!\b", '\000' }, salen = 16}} [22:25:51.932] i = 0 [22:25:51.932] now = [22:25:51.932] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 740699266, events = 8, fd = 0, user_data = 0x82138c980}, {pos = 899179992, events = 8, fd = 557369360, user_data = 0x0}, {pos = 0, events = 0, fd = -508156361, user_data = 0xee55eb9330a}, {pos = 739866528, events = 8, fd = 739937656, user_data = 0x82138c498}, {pos = 557368592, events = 8, fd = 557368472, user_data = 0xee55eb9330a}, {pos = 739845000, events = 8, fd = 739937656, user_data = 0x82138c4c8}, {pos = 557368640, events = 8, fd = 557368520, user_data = 0x82c1a1194}, {pos = 564950024, events = 8, fd = 739905940, user_data = 0x82138c530}, {pos = 1589175354, events = 3813, fd = 741728304, user_data = 0x1}, {pos = 557368672, events = 8, fd = 1589195530, user_data = 0x82c18a858}, {pos = 739937656, events = 8, fd = 557368632, user_data = 0x82138c5b0}, {pos = 557368632, events = 8, fd = 739900684, user_data = 0x821ac7408}, {pos = 739900684, events = 8, fd = 557368736, user_data = 0xee55eb8e43a}, {pos = 557368776, events = 8, fd = 557369224, user_data = 0x82138c5b0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2368770725, fd = 564973624, user_data = 0x800000001}, {pos = 564950024, events = 8, fd = 739845000, user_data = 0x821acc288}, {pos = 739813464, events = 8, fd = 564950024, user_data = 0x82138c638}, {pos = 557369336, events = 8, fd = 557368864, user_data = 0xee55eb92ca2}, {pos = 2721531, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 564973624, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 557369592, user_data = 0x21ac7408}, {pos = 557369408, events = 8, fd = 557369008, user_data = 0x1}, {pos = 557369336, events = 8, fd = 32, user_data = 0x82138c6a0}, {pos = 1589193331, events = 3813, fd = 557369280, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821acd038}, {pos = 1, events = 8, fd = 564950024, user_data = 0x82c18a858}, {pos = 557369592, events = 8, fd = 557369408, user_data = 0x82138c6b0}, {pos = 0, events = 0, fd = 564920328, user_data = 0x20}, {pos = 557369392, events = 8, fd = 1589168871, user_data = 0x821ac0008}, {pos = 564921352, events = 8, fd = 564922376, user_data = 0x821ac0c08}, {pos = 564936712, events = 8, fd = 564937736, user_data = 0x821ac4808}, {pos = 564939784, events = 8, fd = 564940808, user_data = 0x821ac5408}, {pos = 564942856, events = 8, fd = 564943880, user_data = 0x821ac6008}, {pos = 564945928, events = 8, fd = 564946952, user_data = 0x821ac6c08}, {pos = 564949000, events = 8, fd = 564950024, user_data = 0x821ac7808}, {pos = 564952072, events = 8, fd = 564953096, user_data = 0x821ac8408}, {pos = 564955144, events = 8, fd = 564956168, user_data = 0x821ac9008}, {pos = 564958216, events = 8, fd = 564959240, user_data = 0x821ac9c08}, {pos = 564965384, events = 8, fd = 564966408, user_data = 0x821acb808}, {pos = 564968456, events = 8, fd = 564920328, user_data = 0x2986fb}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821acd038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557369592, events = 8, fd = 557369008, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 564973624, user_data = 0x1}, {pos = 564920328, events = 8, fd = 298, user_data = 0x82138c8e0}, {pos = 1589167599, events = 3813, fd = 2721531, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564973624, user_data = 0x1}, {pos = 564950024, events = 8, fd = 898678784, user_data = 0x1}, {pos = 898679188, events = 8, fd = 0, user_data = 0x82138c8b0}, {pos = 706557292, events = 8, fd = 1, user_data = 0x83590c000}, {pos = 557369568, events = 8, fd = 706553602, user_data = 0x82c2bc170 }, {pos = 12408736, events = 0, fd = 741065072, user_data = 0x821ac7408}, {pos = 557369792, events = 8, fd = 1589167070, user_data = 0x83592a800}, {pos = 1, events = 0, fd = 1589166686, user_data = 0x821ac0008}, {pos = 557369576, events = 8, fd = 557369792, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1589246352, user_data = 0x0}, {pos = 557319039, events = 8, fd = 8173367, user_data = 0x82138c970}, {pos = 706515984, events = 8, fd = 741728304, user_data = 0x82c360310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82138c9a0}, {pos = 706558877, events = 8, fd = 898678784, user_data = 0x1e2c}, {pos = 557369856, events = 8, fd = 706525434, user_data = 0x0}, {pos = 0, events = 0, fd = -508156361, user_data = 0x0}} [22:25:51.932] last_touch_time = 1736720387 [22:25:51.932] last_lockfile_recheck_time = 1736720387 [22:25:51.932] nevents = 1 [22:25:51.932] #21 0x00000000008a1054 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82138cff8) at ../src/backend/postmaster/postmaster.c:1377 [22:25:51.932] userDoption = [22:25:51.932] listen_addr_saved = false [22:25:51.932] output_config_variable = [22:25:51.932] opt = [22:25:51.932] status = [22:25:51.932] #22 0x00000000007d8410 in main (argc=4, argv=0x82138cff8) at ../src/backend/main/main.c:230 [22:25:51.932] do_check_root = [22:25:51.932] dispatch_option = DISPATCH_POSTMASTER [22:25:51.940] [22:25:51.940] [22:25:51.940] [22:25:51.999] dumping /tmp/cores/postgres.17785.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:25:52.119] [New LWP 101903] [22:25:52.184] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [22:25:52.184] Program terminated with signal SIGABRT, Aborted. [22:25:52.184] Sent by thr_kill() from pid 17785 and user 1003. [22:25:52.184] #0 0x0000000829cfa41a in thr_kill () from /lib/libc.so.7 [22:25:52.225] [22:25:52.225] Thread 1 (LWP 101903): [22:25:52.225] #0 0x0000000829cfa41a in thr_kill () from /lib/libc.so.7 [22:25:52.225] No symbol table info available. [22:25:52.225] #1 0x0000000829c73e64 in raise () from /lib/libc.so.7 [22:25:52.225] No symbol table info available. [22:25:52.225] #2 0x0000000829d246f9 in abort () from /lib/libc.so.7 [22:25:52.225] No symbol table info available. [22:25:52.225] #3 0x0000000000aa9db5 in ExceptionalCondition (conditionName=0x2ed1a4 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [22:25:52.225] No locals. [22:25:52.225] #4 0x0000000000773c69 in standard_ExecutorStart (queryDesc=0x834dc5bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [22:25:52.225] estate = 0x83715a100 [22:25:52.225] oldcontext = 0x834e6b400 [22:25:52.225] #5 0x00000008365e09c2 in pgss_ExecutorStart (queryDesc=0x834dc5bd0, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [22:25:52.225] No locals. [22:25:52.225] #6 0x000000000070813f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [22:25:52.225] copied_query = [22:25:52.225] rewritten = [22:25:52.225] plan = 0x834dc5778 [22:25:52.225] queryDesc = 0x834dc5bd0 [22:25:52.225] processed = [22:25:52.225] __error = [22:25:52.225] #7 RefreshMatViewByOid (matviewOid=28407, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [22:25:52.225] dest = [22:25:52.225] save_userid = 10 [22:25:52.225] save_sec_context = 0 [22:25:52.225] processed = 0 [22:25:52.225] matviewRel = 0x8371eaf58 [22:25:52.225] relowner = 10 [22:25:52.225] save_nestlevel = 2 [22:25:52.225] rule = [22:25:52.225] actions = [22:25:52.225] dataQuery = [22:25:52.225] tableSpace = [22:25:52.225] relpersistence = [22:25:52.225] OIDNewHeap = 28416 [22:25:52.225] address = [22:25:52.225] #8 0x0000000000707d16 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [22:25:52.225] lockmode = [22:25:52.225] matviewOid = 0 [22:25:52.225] #9 0x00000000006decdc in ExecCreateTableAs (pstate=pstate@entry=0x834e6b500, stmt=stmt@entry=0x834e4bfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820d064f0) at ../src/backend/commands/createas.c:351 [22:25:52.225] refresh = 0x0 [22:25:52.225] query = 0x834e77e88 [22:25:52.225] into = 0x834e4bf40 [22:25:52.225] jstate = 0x0 [22:25:52.225] do_refresh = false [22:25:52.225] address = [22:25:52.225] dest = [22:25:52.225] is_matview = [22:25:52.225] #10 0x0000000000952efb in ProcessUtilitySlow (pstate=pstate@entry=0x834e6b500, pstmt=pstmt@entry=0x834e4be30, queryString=queryString@entry=0x834cee100 "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=0x820d064f0) at ../src/backend/tcop/utility.c:1678 [22:25:52.225] _local_sigjmp_buf = {{_sjb = {9774889, 0, 34910265176, 34910265552, 34910265184, 12480584, 0, 35247273216, 895, 1, 34910265308, 0}}} [22:25:52.225] _save_exception_stack = 0x820d061e0 [22:25:52.225] _save_context_stack = 0x0 [22:25:52.225] _do_rethrow = false [22:25:52.225] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:25:52.225] parsetree = 0x834e4bfd0 [22:25:52.225] commandCollected = false [22:25:52.225] needCleanup = false [22:25:52.225] address = [22:25:52.225] isTopLevel = [22:25:52.225] isCompleteQuery = [22:25:52.225] #11 0x0000000000951878 in standard_ProcessUtility (pstmt=0x834e4be30, queryString=queryString@entry=0x834cee100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834e78628, qc=0x820d064f0) at ../src/backend/tcop/utility.c:1033 [22:25:52.225] isAtomicContext = false [22:25:52.225] parsetree = 0x834e4bfd0 [22:25:52.225] readonly_flags = [22:25:52.225] pstate = 0x834e6b500 [22:25:52.225] isTopLevel = [22:25:52.225] #12 0x00000008365e0f6e in pgss_ProcessUtility (pstmt=0x834e4be30, queryString=0x834cee100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834e78628, qc=0x820d064f0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [22:25:52.225] _local_sigjmp_buf = {{_sjb = {35271872167, 34910265824, 34910265688, 34910266144, 35247144496, 0, 12480584, 34910266352, 895, 1, 34910265940, 34359738368}}} [22:25:52.225] _save_exception_stack = 0x820d063f0 [22:25:52.225] _save_context_stack = 0x0 [22:25:52.225] _do_rethrow = false [22:25:52.225] bufusage = {shared_blks_hit = 35271872167, shared_blks_read = 34910265824, shared_blks_dirtied = 34910265688, shared_blks_written = 34910266144, local_blks_hit = 35247144496, local_blks_read = 0, local_blks_dirtied = 12480584, local_blks_written = 34910266352, temp_blks_read = 895, temp_blks_written = 1, shared_blk_read_time = {ticks = 34910265940}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4043526584154257920}, local_blk_write_time = {ticks = 12489512}, temp_blk_read_time = {ticks = 35305409664}, temp_blk_write_time = {ticks = 12442144}} [22:25:52.225] walusage_start = {wal_records = 9004, wal_fpi = 161, wal_bytes = 1411375} [22:25:52.225] duration = [22:25:52.225] bufusage_start = {shared_blks_hit = 153151, shared_blks_read = 9300, shared_blks_dirtied = 2895, shared_blks_written = 2725, 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}} [22:25:52.225] walusage = {wal_records = 0, wal_fpi = 549755813888, wal_bytes = 9236118261658823773} [22:25:52.225] start = {ticks = -192650130052} [22:25:52.225] rows = [22:25:52.225] saved_queryId = 6041762721901209185 [22:25:52.225] parsetree = [22:25:52.225] saved_stmt_location = 0 [22:25:52.225] saved_stmt_len = 69 [22:25:52.225] enabled = [22:25:52.225] #13 0x0000000000950e43 in PortalRunUtility (portal=0x834d94100, pstmt=0x834e4be30, isTopLevel=, setHoldSnapshot=, dest=0x834e78628, qc=0x820d064f0) at ../src/backend/tcop/pquery.c:1152 [22:25:52.225] No locals. [22:25:52.225] #14 0x0000000000950504 in PortalRunMulti (portal=portal@entry=0x834d94100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x834e78628, altdest=altdest@entry=0x834e78628, qc=qc@entry=0x820d064f0) at ../src/backend/tcop/pquery.c:1316 [22:25:52.225] pstmt = 0x834e4be30 [22:25:52.225] stmtlist_item__state = {l = 0x834e785d8, i = 0} [22:25:52.225] active_snapshot_set = false [22:25:52.225] stmtlist_item = 0x834e785f0 [22:25:52.225] #15 0x000000000094fdeb in PortalRun (portal=portal@entry=0x834d94100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x834e78628, altdest=altdest@entry=0x834e78628, qc=qc@entry=0x820d064f0) at ../src/backend/tcop/pquery.c:787 [22:25:52.225] _local_sigjmp_buf = {{_sjb = {9764197, 35246391552, 34910266344, 34910266592, 34910266352, 12480584, 34910266608, 12446184, 12387199, 0, 35246375807, 34359738368}}} [22:25:52.225] _save_exception_stack = 0x820d065a0 [22:25:52.225] _save_context_stack = 0x0 [22:25:52.225] _do_rethrow = false [22:25:52.225] saveTopTransactionResourceOwner = 0x834dea098 [22:25:52.225] saveTopTransactionContext = 0x834d98000 [22:25:52.225] saveActivePortal = 0x0 [22:25:52.225] saveResourceOwner = 0x834dea098 [22:25:52.225] savePortalContext = 0x0 [22:25:52.225] saveMemoryContext = 0x834d98000 [22:25:52.225] result = [22:25:52.225] nprocessed = [22:25:52.225] #16 0x000000000094ec79 in exec_simple_query (query_string=query_string@entry=0x834cee100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [22:25:52.225] cmdtaglen = 24 [22:25:52.225] snapshot_set = [22:25:52.225] per_parsetree_context = 0x0 [22:25:52.225] plantree_list = [22:25:52.225] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:25:52.225] format = 0 [22:25:52.225] parsetree = 0x834cef6a8 [22:25:52.225] commandTag = [22:25:52.225] cmdtagname = [22:25:52.225] querytree_list = [22:25:52.225] portal = 0x834d94100 [22:25:52.225] receiver = 0x834e78628 [22:25:52.225] parsetree_item__state = {l = 0x834cefa18, i = 0} [22:25:52.225] msec_str = "\000\000\000\000\b", '\000' , "C@\204g\000\000\000\000̏\315\351d@\201n" [22:25:52.225] dest = DestRemote [22:25:52.225] was_logged = [22:25:52.225] oldcontext = 0x834d98000 [22:25:52.225] parsetree_list = 0x834cefa18 [22:25:52.225] use_implicit_block = false [22:25:52.225] parsetree_item = 0x834cefa30 [22:25:52.225] save_log_statement_stats = [22:25:52.225] #17 0x000000000094c8e3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [22:25:52.225] query_string = 0x834cee100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [22:25:52.225] input_message = {data = 0x834cee100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [22:25:52.225] firstchar = [22:25:52.225] local_sigjmp_buf = {{_sjb = {9747862, 34910266784, 34910266776, 34910267328, 12489336, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [22:25:52.225] send_ready_for_query = false [22:25:52.225] idle_in_transaction_timeout_enabled = false [22:25:52.225] idle_session_timeout_enabled = false [22:25:52.225] #18 0x0000000000947289 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:25:52.225] bsdata = [22:25:52.225] #19 0x000000000089e875 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x820d072d0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d07220) at ../src/backend/postmaster/launch_backend.c:274 [22:25:52.225] pid = [22:25:52.225] #20 0x00000000008a2dc6 in BackendStartup (client_sock=0x820d07220) at ../src/backend/postmaster/postmaster.c:3466 [22:25:52.225] startup_data = {canAcceptConnections = CAC_OK} [22:25:52.225] bn = 0x834dd5b88 [22:25:52.225] cac = CAC_OK [22:25:52.225] pid = [22:25:52.225] __error = [22:25:52.225] save_errno = [22:25:52.225] __error = [22:25:52.225] __error = [22:25:52.225] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:25:52.225] 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' , "\200r\320 \b\000\000\000h\025\342*\b\000\000\000W\000\000\000\000\000\000\000^\237\342*\b", '\000' , "\300r\320 \b\000\000\000\004\346\211\000\000\000\000\000\320r\320 \b", '\000' }, salen = 16}} [22:25:52.225] i = 0 [22:25:52.225] now = [22:25:52.225] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 886379992, events = 8, fd = 550531168, user_data = 0x0}, {pos = 1742017290, events = 7734, fd = 700266400, user_data = 0x829be4d78}, {pos = 550530264, events = 8, fd = 550530384, user_data = 0x820d06cd8}, {pos = 1742017290, events = 7734, fd = 700244872, user_data = 0x829be4d78}, {pos = 550530312, events = 8, fd = 550530432, user_data = 0x820d06d08}, {pos = 700305812, events = 8, fd = 552440840, user_data = 0x829bdd194}, {pos = 550530416, events = 8, fd = 1741997114, user_data = 0x820d06d10}, {pos = 719451152, events = 8, fd = 702128176, user_data = 0x1e3667d5130a}, {pos = 700213336, events = 8, fd = 700337528, user_data = 0x820d06d78}, {pos = 550530544, events = 8, fd = 550530424, user_data = 0x829bdbd0c}, {pos = 552440840, events = 8, fd = 700300556, user_data = 0x820d06de0}, {pos = 1741997114, events = 7734, fd = 550530568, user_data = 0x820d06fd8}, {pos = 550530544, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x820edf038}, {pos = 1, events = 2150451359, fd = 552440840, user_data = 0x829bce388}, {pos = 552462280, events = 8, fd = 0, user_data = 0x0}, {pos = 550530680, events = 8, fd = 550531144, user_data = 0x820d06e60}, {pos = 1742015650, events = 7734, fd = 2721531, user_data = 0x6d68b}, {pos = 2090263927, events = 2150451359, fd = 552464440, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820d07148}, {pos = 552440840, events = 3, fd = 550531216, user_data = 0x820ede828}, {pos = 656, events = 0, fd = 550531144, user_data = 0x820d06e78}, {pos = 550530784, events = 8, fd = 1742015259, user_data = 0x820d07010}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 552464440, events = 8, fd = 1, user_data = 0x820ed9408}, {pos = 700213336, events = 8, fd = 550531400, user_data = 0x820d07090}, {pos = 550530800, events = 8, fd = 0, user_data = 0x820ed2008}, {pos = 33, events = 0, fd = 550531200, user_data = 0x1e3667d4aae7}, {pos = 552411144, events = 8, fd = 552412168, user_data = 0x820ed2808}, {pos = 552414216, events = 8, fd = 552427528, user_data = 0x820ed6408}, {pos = 552429576, events = 8, fd = 552430600, user_data = 0x820ed7008}, {pos = 552432648, events = 8, fd = 552433672, user_data = 0x820ed7c08}, {pos = 552435720, events = 8, fd = 552436744, user_data = 0x820ed8808}, {pos = 552438792, events = 8, fd = 552439816, user_data = 0x820ed9408}, {pos = 552441864, events = 8, fd = 552442888, user_data = 0x820eda008}, {pos = 552444936, events = 8, fd = 552445960, user_data = 0x820edac08}, {pos = 552448008, events = 8, fd = 552449032, user_data = 0x820edb808}, {pos = 552451080, events = 8, fd = 552456200, user_data = 0x820edd408}, {pos = 552458248, events = 8, fd = 552459272, user_data = 0x820ee0408}, {pos = 660824000, events = 0, fd = 552411144, user_data = 0x2986fb}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x820edf038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550531400, events = 8, fd = 550530800, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 552464440, user_data = 0x1}, {pos = 552411144, events = 8, fd = 298, user_data = 0x820d07130}, {pos = 1741989359, events = 7734, fd = 2721531, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 552464440, user_data = 0x1}, {pos = 552440840, events = 8, fd = 885907456, user_data = 0x1}, {pos = 885907860, events = 8, fd = 0, user_data = 0x820d07100}, {pos = 719492460, events = 8, fd = 1, user_data = 0x834cde000}, {pos = 550531376, events = 8, fd = 719488770, user_data = 0x829cf8170 }, {pos = 12408736, events = 0, fd = 701464944, user_data = 0x820ed9408}, {pos = 550531600, events = 8, fd = 1741988830, user_data = 0x834cfc800}, {pos = 1, events = 0, fd = 1741988446, user_data = 0x820ed2008}, {pos = 550531384, events = 8, fd = 550531600, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1742068112, user_data = 0x0}, {pos = 550503295, events = 8, fd = 8173367, user_data = 0x820d071c0}, {pos = 719451152, events = 8, fd = 702128176, user_data = 0x829d9c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d071f0}, {pos = 719494045, events = 8, fd = 885907456, user_data = 0x3665}, {pos = 550531664, events = 8, fd = 719460602, user_data = 0x0}, {pos = 0, events = 0, fd = -1179898787, user_data = 0x0}} [22:25:52.226] last_touch_time = 1736720424 [22:25:52.226] last_lockfile_recheck_time = 1736720424 [22:25:52.226] nevents = 1 [22:25:52.226] #22 0x00000000008a1054 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820d07840) at ../src/backend/postmaster/postmaster.c:1377 [22:25:52.226] userDoption = [22:25:52.226] listen_addr_saved = false [22:25:52.226] output_config_variable = [22:25:52.226] opt = [22:25:52.226] status = [22:25:52.226] #23 0x00000000007d8410 in main (argc=4, argv=0x820d07840) at ../src/backend/main/main.c:230 [22:25:52.226] do_check_root = [22:25:52.226] dispatch_option = DISPATCH_POSTMASTER