[13:52:23.757] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [13:52:24.124] dumping /tmp/cores/postgres.10707.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:52:24.260] [New LWP 101925] [13:52:24.353] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [13:52:24.353] Program terminated with signal SIGABRT, Aborted. [13:52:24.353] Sent by thr_kill() from pid 10707 and user 1003. [13:52:24.353] #0 0x000000082c35041a in thr_kill () from /lib/libc.so.7 [13:52:24.413] [13:52:24.413] Thread 1 (LWP 101925): [13:52:24.413] #0 0x000000082c35041a in thr_kill () from /lib/libc.so.7 [13:52:24.413] No symbol table info available. [13:52:24.413] #1 0x000000082c2c9e64 in raise () from /lib/libc.so.7 [13:52:24.413] No symbol table info available. [13:52:24.413] #2 0x000000082c37a6f9 in abort () from /lib/libc.so.7 [13:52:24.413] No symbol table info available. [13:52:24.413] #3 0x0000000000a990b5 in ExceptionalCondition (conditionName=0x2e7eee "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [13:52:24.413] No locals. [13:52:24.413] #4 0x0000000000769009 in standard_ExecutorStart (queryDesc=0x838088088, eflags=0) at ../src/backend/executor/execMain.c:195 [13:52:24.413] estate = 0x838144100 [13:52:24.413] oldcontext = 0x83817d800 [13:52:24.413] #5 0x00000000006fedc5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [13:52:24.413] copied_query = [13:52:24.413] rewritten = [13:52:24.413] plan = 0x83817abd8 [13:52:24.413] queryDesc = 0x838088088 [13:52:24.413] processed = [13:52:24.413] __error = [13:52:24.413] #6 RefreshMatViewByOid (matviewOid=28290, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [13:52:24.413] dest = [13:52:24.413] save_userid = 10 [13:52:24.413] save_sec_context = 0 [13:52:24.413] processed = 0 [13:52:24.413] matviewRel = 0x845abaa48 [13:52:24.413] relowner = 10 [13:52:24.413] save_nestlevel = 2 [13:52:24.413] rule = [13:52:24.413] actions = [13:52:24.413] dataQuery = [13:52:24.413] tableSpace = [13:52:24.413] relpersistence = [13:52:24.413] OIDNewHeap = 28317 [13:52:24.413] address = [13:52:24.413] #7 0x00000000006fe9a6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:52:24.413] lockmode = [13:52:24.413] matviewOid = 0 [13:52:24.413] #8 0x00000000006d5aac in ExecCreateTableAs (pstate=pstate@entry=0x83817d900, stmt=stmt@entry=0x8380eafd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821692a30) at ../src/backend/commands/createas.c:351 [13:52:24.413] refresh = 0x0 [13:52:24.413] query = 0x8380c5ed8 [13:52:24.413] into = 0x8380c6220 [13:52:24.413] jstate = 0x0 [13:52:24.413] do_refresh = false [13:52:24.413] address = [13:52:24.413] dest = [13:52:24.413] is_matview = [13:52:24.413] #9 0x0000000000944c58 in ProcessUtilitySlow (pstate=pstate@entry=0x83817d900, pstmt=pstmt@entry=0x837fe8a68, queryString=queryString@entry=0x837fe7100 "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=0x821692a30) at ../src/backend/tcop/utility.c:1678 [13:52:24.413] _local_sigjmp_buf = {{_sjb = {9716873, 0, 34920277592, 34920277968, 34920277600, 12405448, 0, 35300825344, 4294902655, 34920277708, 34920277744, 0}}} [13:52:24.413] _save_exception_stack = 0x821692930 [13:52:24.413] _save_context_stack = 0x0 [13:52:24.413] _do_rethrow = false [13:52:24.413] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:52:24.413] parsetree = 0x8380eafd0 [13:52:24.413] commandCollected = false [13:52:24.413] needCleanup = false [13:52:24.413] address = [13:52:24.413] isTopLevel = [13:52:24.413] isCompleteQuery = [13:52:24.413] #10 0x00000000009435d8 in standard_ProcessUtility (pstmt=0x837fe8a68, queryString=0x837fe7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8380c6708, qc=0x821692a30) at ../src/backend/tcop/utility.c:1033 [13:52:24.413] isAtomicContext = false [13:52:24.413] parsetree = 0x8380eafd0 [13:52:24.413] readonly_flags = [13:52:24.413] pstate = 0x83817d900 [13:52:24.413] isTopLevel = [13:52:24.413] #11 0x0000000000943068 in ProcessUtility (pstmt=0x18e25, queryString=0x6 , readOnlyTree=, context=741671930, params=0x0, queryEnv=0x0, dest=0x8380c6708, qc=0x821692a30) at ../src/backend/tcop/utility.c:523 [13:52:24.413] No locals. [13:52:24.413] #12 0x0000000000942ba3 in PortalRunUtility (portal=0x8380be100, pstmt=0x837fe8a68, isTopLevel=, setHoldSnapshot=, dest=0x8380c6708, qc=0x821692a30) at ../src/backend/tcop/pquery.c:1158 [13:52:24.413] No locals. [13:52:24.413] #13 0x0000000000942234 in PortalRunMulti (portal=portal@entry=0x8380be100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8380c6708, altdest=altdest@entry=0x8380c6708, qc=0x821692a30) at ../src/backend/tcop/pquery.c:1322 [13:52:24.413] pstmt = 0x837fe8a68 [13:52:24.413] stmtlist_item__state = {l = 0x8380c66b8, i = 0} [13:52:24.413] active_snapshot_set = false [13:52:24.413] stmtlist_item = 0x8380c66d0 [13:52:24.413] #14 0x0000000000941b03 in PortalRun (portal=portal@entry=0x8380be100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8380c6708, altdest=altdest@entry=0x8380c6708, qc=0x821692a30) at ../src/backend/tcop/pquery.c:791 [13:52:24.413] _local_sigjmp_buf = {{_sjb = {9706109, 35300040960, 34920278312, 34920278544, 34920278320, 35300057088, 12372056, 12405448, 35300049791, 35300218256, 4294967984, 0}}} [13:52:24.413] _save_exception_stack = 0x821692b00 [13:52:24.413] _save_context_stack = 0x0 [13:52:24.413] _do_rethrow = false [13:52:24.413] saveTopTransactionResourceOwner = 0x8380cf818 [13:52:24.413] saveTopTransactionContext = 0x8380c2000 [13:52:24.413] saveActivePortal = 0x0 [13:52:24.413] saveResourceOwner = 0x8380cf818 [13:52:24.413] savePortalContext = 0x0 [13:52:24.413] saveMemoryContext = 0x8380c2000 [13:52:24.413] result = [13:52:24.413] nprocessed = [13:52:24.413] #15 0x00000000009409a2 in exec_simple_query (query_string=query_string@entry=0x837fe7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:52:24.413] cmdtaglen = 24 [13:52:24.413] snapshot_set = [13:52:24.413] per_parsetree_context = 0x0 [13:52:24.413] plantree_list = [13:52:24.413] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:52:24.413] format = 0 [13:52:24.413] parsetree = 0x837fe86a8 [13:52:24.413] commandTag = [13:52:24.413] cmdtagname = [13:52:24.413] querytree_list = [13:52:24.413] portal = 0x8380be100 [13:52:24.413] receiver = 0x8380c6708 [13:52:24.413] parsetree_item__state = {l = 0x837fe8a18, i = 0} [13:52:24.413] msec_str = "\000\000\000\000\b", '\000' , "\224\3775g\000\000\000\000/\326\n\315", [13:52:24.413] dest = DestRemote [13:52:24.413] was_logged = [13:52:24.413] oldcontext = 0x8380c2000 [13:52:24.413] parsetree_list = 0x837fe8a18 [13:52:24.413] use_implicit_block = false [13:52:24.413] parsetree_item = 0x837fe8a30 [13:52:24.413] save_log_statement_stats = [13:52:24.413] #16 0x000000000093e613 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [13:52:24.413] query_string = 0x837fe7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:52:24.413] input_message = {data = 0x837fe7100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:52:24.413] firstchar = [13:52:24.413] local_sigjmp_buf = {{_sjb = {9689798, 34920278784, 34920278744, 34920279328, 12414184, 1, 8192, 8388608, 34920268671, 0, 0, 1}}} [13:52:24.413] send_ready_for_query = false [13:52:24.413] idle_in_transaction_timeout_enabled = false [13:52:24.413] idle_session_timeout_enabled = false [13:52:24.413] #17 0x0000000000938df9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:52:24.413] bsdata = [13:52:24.413] #18 0x00000000008909b7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821693844 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821693780) at ../src/backend/postmaster/launch_backend.c:266 [13:52:24.413] pid = [13:52:24.413] #19 0x0000000000894d88 in BackendStartup (client_sock=0x821693780) at ../src/backend/postmaster/postmaster.c:3417 [13:52:24.413] startup_data = {canAcceptConnections = CAC_OK} [13:52:24.413] bn = 0x837ff3268 [13:52:24.413] pid = [13:52:24.413] __error = [13:52:24.413] save_errno = [13:52:24.413] __error = [13:52:24.413] __error = [13:52:24.413] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [13:52:24.413] 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\217\3767\b", '\000' , "\3407i!\b\000\000\000h\205\315,\b\000\000\000\v\000\000\000\000\000\000\000^\017\316,\b", '\000' , " 8i!\b\000\000\000d\a\211\000\000\000\000\00008i!\b", '\000' }, salen = 16}} [13:52:24.413] i = 0 [13:52:24.413] now = [13:52:24.413] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 741297282, events = 8, fd = 0, user_data = 0x821693730}, {pos = 939800024, events = 8, fd = 560543168, user_data = 0x0}, {pos = 0, events = 0, fd = 1564969150, user_data = 0x3b9e5b2d230a}, {pos = 740464544, events = 8, fd = 740535672, user_data = 0x821693248}, {pos = 560542400, events = 8, fd = 560542280, user_data = 0x3b9e5b2d230a}, {pos = 740443016, events = 8, fd = 740535672, user_data = 0x821693278}, {pos = 560542448, events = 8, fd = 560542328, user_data = 0x82c233194}, {pos = 569566216, events = 8, fd = 740503956, user_data = 0x8216932e0}, {pos = 1529664570, events = 15262, fd = 742326320, user_data = 0x1}, {pos = 560542480, events = 8, fd = 1529684746, user_data = 0x82c21c858}, {pos = 740535672, events = 8, fd = 560542440, user_data = 0x821693360}, {pos = 560542440, events = 8, fd = 740498700, user_data = 0x821f2e408}, {pos = 740498700, events = 8, fd = 560542544, user_data = 0x3b9e5b2cd43a}, {pos = 560542584, events = 8, fd = 560543032, user_data = 0x821693360}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3696185726, fd = 569589816, user_data = 0x800000001}, {pos = 569566216, events = 8, fd = 740443016, user_data = 0x821f33288}, {pos = 740411480, events = 8, fd = 569566216, user_data = 0x8216933e8}, {pos = 560543144, events = 8, fd = 560542672, user_data = 0x3b9e5b2d1ca2}, {pos = 2703130, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 569589816, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 560543400, user_data = 0x21f2e408}, {pos = 560543216, events = 8, fd = 560542816, user_data = 0x1}, {pos = 560543144, events = 8, fd = 32, user_data = 0x821693450}, {pos = 1529682547, events = 15262, fd = 560543088, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821f34038}, {pos = 1, events = 8, fd = 569566216, user_data = 0x82c21c858}, {pos = 560543400, events = 8, fd = 560543216, user_data = 0x821693460}, {pos = 0, events = 0, fd = 569536520, user_data = 0x20}, {pos = 560543200, events = 8, fd = 1529658087, user_data = 0x821f27008}, {pos = 569537544, events = 8, fd = 569538568, user_data = 0x821f27c08}, {pos = 569552904, events = 8, fd = 569553928, user_data = 0x821f2b808}, {pos = 569555976, events = 8, fd = 569557000, user_data = 0x821f2c408}, {pos = 569559048, events = 8, fd = 569560072, user_data = 0x821f2d008}, {pos = 569562120, events = 8, fd = 569563144, user_data = 0x821f2dc08}, {pos = 569565192, events = 8, fd = 569566216, user_data = 0x821f2e808}, {pos = 569568264, events = 8, fd = 569569288, user_data = 0x821f2f408}, {pos = 569571336, events = 8, fd = 569572360, user_data = 0x821f30008}, {pos = 569574408, events = 8, fd = 569575432, user_data = 0x821f30c08}, {pos = 569581576, events = 8, fd = 569582600, user_data = 0x821f32808}, {pos = 569584648, events = 8, fd = 569536520, user_data = 0x293f1a}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821f34038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 560543400, events = 8, fd = 560542816, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 569589816, user_data = 0x1}, {pos = 569536520, events = 8, fd = 298, user_data = 0x821693690}, {pos = 1529656815, events = 15262, fd = 2703130, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 569589816, user_data = 0x1}, {pos = 569566216, events = 8, fd = 939356160, user_data = 0x1}, {pos = 939356564, events = 8, fd = 0, user_data = 0x821693660}, {pos = 751699308, events = 8, fd = 1, user_data = 0x837fd7000}, {pos = 560543376, events = 8, fd = 751695618, user_data = 0x82c34e170 }, {pos = 12335048, events = 0, fd = 741663088, user_data = 0x821f2e408}, {pos = 560543600, events = 8, fd = 1529656286, user_data = 0x837ff5800}, {pos = 1, events = 0, fd = 1529655902, user_data = 0x821f27008}, {pos = 560543384, events = 8, fd = 560543600, user_data = 0x1ab8}, {pos = 939429632, events = 8, fd = 1529735568, user_data = 0x0}, {pos = 560530303, events = 8, fd = 8124231, user_data = 0x821693720}, {pos = 751658000, events = 8, fd = 742326320, user_data = 0x82c3f2310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821693750}, {pos = 751700893, events = 8, fd = 939356160, user_data = 0x1d96}, {pos = 560543664, events = 8, fd = 751667450, user_data = 0x0}, {pos = 0, events = 0, fd = 1564969150, user_data = 0x0}} [13:52:24.413] last_touch_time = 1731592062 [13:52:24.413] last_lockfile_recheck_time = 1731592062 [13:52:24.413] nevents = 1 [13:52:24.413] #21 0x0000000000892ba5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821693d98) at ../src/backend/postmaster/postmaster.c:1348 [13:52:24.413] userDoption = [13:52:24.413] listen_addr_saved = [13:52:24.413] output_config_variable = [13:52:24.413] opt = [13:52:24.413] status = [13:52:24.413] #22 0x00000000007cc3cc in main (argc=8, argv=0x821693d98) at ../src/backend/main/main.c:196 [13:52:24.413] do_check_root = [13:52:24.422] [13:52:24.422] [13:52:24.422] [13:52:24.488] dumping /tmp/cores/postgres.10977.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:52:24.614] [New LWP 101934] [13:52:24.681] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [13:52:24.681] Program terminated with signal SIGABRT, Aborted. [13:52:24.681] Sent by thr_kill() from pid 10977 and user 1003. [13:52:24.681] #0 0x000000082c18241a in thr_kill () from /lib/libc.so.7 [13:52:24.716] [13:52:24.716] Thread 1 (LWP 101934): [13:52:24.716] #0 0x000000082c18241a in thr_kill () from /lib/libc.so.7 [13:52:24.716] No symbol table info available. [13:52:24.716] #1 0x000000082c0fbe64 in raise () from /lib/libc.so.7 [13:52:24.716] No symbol table info available. [13:52:24.716] #2 0x000000082c1ac6f9 in abort () from /lib/libc.so.7 [13:52:24.716] No symbol table info available. [13:52:24.716] #3 0x0000000000a990b5 in ExceptionalCondition (conditionName=0x2e7eee "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [13:52:24.716] No locals. [13:52:24.716] #4 0x0000000000769009 in standard_ExecutorStart (queryDesc=0x835e87088, eflags=0) at ../src/backend/executor/execMain.c:195 [13:52:24.716] estate = 0x835e60100 [13:52:24.716] oldcontext = 0x841eb6800 [13:52:24.716] #5 0x00000000006fedc5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [13:52:24.716] copied_query = [13:52:24.716] rewritten = [13:52:24.716] plan = 0x835fb1bd8 [13:52:24.716] queryDesc = 0x835e87088 [13:52:24.716] processed = [13:52:24.716] __error = [13:52:24.716] #6 RefreshMatViewByOid (matviewOid=28332, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [13:52:24.716] dest = [13:52:24.716] save_userid = 10 [13:52:24.716] save_sec_context = 0 [13:52:24.716] processed = 0 [13:52:24.716] matviewRel = 0x84205fd38 [13:52:24.716] relowner = 10 [13:52:24.716] save_nestlevel = 2 [13:52:24.716] rule = [13:52:24.716] actions = [13:52:24.716] dataQuery = [13:52:24.716] tableSpace = [13:52:24.716] relpersistence = [13:52:24.716] OIDNewHeap = 28339 [13:52:24.716] address = [13:52:24.716] #7 0x00000000006fe9a6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:52:24.716] lockmode = [13:52:24.716] matviewOid = 0 [13:52:24.716] #8 0x00000000006d5aac in ExecCreateTableAs (pstate=pstate@entry=0x841eb6900, stmt=stmt@entry=0x835faefd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821b604c0) at ../src/backend/commands/createas.c:351 [13:52:24.716] refresh = 0x0 [13:52:24.716] query = 0x835ef7fd8 [13:52:24.716] into = 0x835ef8320 [13:52:24.716] jstate = 0x0 [13:52:24.716] do_refresh = false [13:52:24.716] address = [13:52:24.716] dest = [13:52:24.716] is_matview = [13:52:24.716] #9 0x0000000000944c58 in ProcessUtilitySlow (pstate=pstate@entry=0x841eb6900, pstmt=pstmt@entry=0x835e10a68, queryString=queryString@entry=0x835e0f100 "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=0x821b604c0) at ../src/backend/tcop/utility.c:1678 [13:52:24.716] _local_sigjmp_buf = {{_sjb = {9716873, 0, 34925314280, 34925314656, 34925314288, 12405448, 0, 35465685248, 4294902655, 34925314396, 34925314432, 0}}} [13:52:24.716] _save_exception_stack = 0x821b603c0 [13:52:24.716] _save_context_stack = 0x0 [13:52:24.716] _do_rethrow = false [13:52:24.716] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:52:24.716] parsetree = 0x835faefd0 [13:52:24.716] commandCollected = false [13:52:24.716] needCleanup = false [13:52:24.716] address = [13:52:24.716] isTopLevel = [13:52:24.716] isCompleteQuery = [13:52:24.716] #10 0x00000000009435d8 in standard_ProcessUtility (pstmt=0x835e10a68, queryString=0x835e0f100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835ef8808, qc=0x821b604c0) at ../src/backend/tcop/utility.c:1033 [13:52:24.716] isAtomicContext = false [13:52:24.716] parsetree = 0x835faefd0 [13:52:24.716] readonly_flags = [13:52:24.716] pstate = 0x841eb6900 [13:52:24.716] isTopLevel = [13:52:24.716] #11 0x0000000000943068 in ProcessUtility (pstmt=0x18e2e, queryString=0x6 , readOnlyTree=, context=739779578, params=0x0, queryEnv=0x0, dest=0x835ef8808, qc=0x821b604c0) at ../src/backend/tcop/utility.c:523 [13:52:24.716] No locals. [13:52:24.716] #12 0x0000000000942ba3 in PortalRunUtility (portal=0x835eb5100, pstmt=0x835e10a68, isTopLevel=, setHoldSnapshot=, dest=0x835ef8808, qc=0x821b604c0) at ../src/backend/tcop/pquery.c:1158 [13:52:24.716] No locals. [13:52:24.716] #13 0x0000000000942234 in PortalRunMulti (portal=portal@entry=0x835eb5100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835ef8808, altdest=altdest@entry=0x835ef8808, qc=0x821b604c0) at ../src/backend/tcop/pquery.c:1322 [13:52:24.716] pstmt = 0x835e10a68 [13:52:24.716] stmtlist_item__state = {l = 0x835ef87b8, i = 0} [13:52:24.716] active_snapshot_set = false [13:52:24.716] stmtlist_item = 0x835ef87d0 [13:52:24.716] #14 0x0000000000941b03 in PortalRun (portal=portal@entry=0x835eb5100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835ef8808, altdest=altdest@entry=0x835ef8808, qc=0x821b604c0) at ../src/backend/tcop/pquery.c:791 [13:52:24.716] _local_sigjmp_buf = {{_sjb = {9706109, 35264352512, 34925315000, 34925315232, 34925315008, 35264368640, 12372056, 12405448, 35264332671, 35265369488, 4294967984, 0}}} [13:52:24.716] _save_exception_stack = 0x821b60590 [13:52:24.716] _save_context_stack = 0x0 [13:52:24.716] _do_rethrow = false [13:52:24.716] saveTopTransactionResourceOwner = 0x835f04958 [13:52:24.716] saveTopTransactionContext = 0x835eb9000 [13:52:24.716] saveActivePortal = 0x0 [13:52:24.716] saveResourceOwner = 0x835f04958 [13:52:24.716] savePortalContext = 0x0 [13:52:24.716] saveMemoryContext = 0x835eb9000 [13:52:24.716] result = [13:52:24.716] nprocessed = [13:52:24.716] #15 0x00000000009409a2 in exec_simple_query (query_string=query_string@entry=0x835e0f100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:52:24.716] cmdtaglen = 24 [13:52:24.716] snapshot_set = [13:52:24.716] per_parsetree_context = 0x0 [13:52:24.716] plantree_list = [13:52:24.716] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:52:24.716] format = 0 [13:52:24.716] parsetree = 0x835e106a8 [13:52:24.716] commandTag = [13:52:24.716] cmdtagname = [13:52:24.716] querytree_list = [13:52:24.716] portal = 0x835eb5100 [13:52:24.716] receiver = 0x835ef8808 [13:52:24.716] parsetree_item__state = {l = 0x835e10a18, i = 0} [13:52:24.716] msec_str = "\000\000\000\000\b", '\000' , "\226\3775g\000\000\000\000\023Z\376\345W8UJ" [13:52:24.716] dest = DestRemote [13:52:24.716] was_logged = [13:52:24.716] oldcontext = 0x835eb9000 [13:52:24.716] parsetree_list = 0x835e10a18 [13:52:24.716] use_implicit_block = false [13:52:24.716] parsetree_item = 0x835e10a30 [13:52:24.716] save_log_statement_stats = [13:52:24.716] #16 0x000000000093e613 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [13:52:24.716] query_string = 0x835e0f100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:52:24.716] input_message = {data = 0x835e0f100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:52:24.716] firstchar = [13:52:24.716] local_sigjmp_buf = {{_sjb = {9689798, 34925315472, 34925315432, 34925316016, 12414184, 1, 8192, 8388608, 34925314943, 0, 0, 1}}} [13:52:24.716] send_ready_for_query = false [13:52:24.716] idle_in_transaction_timeout_enabled = false [13:52:24.716] idle_session_timeout_enabled = false [13:52:24.716] #17 0x0000000000938df9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:52:24.716] bsdata = [13:52:24.716] #18 0x00000000008909b7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821b612d4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821b61210) at ../src/backend/postmaster/launch_backend.c:266 [13:52:24.716] pid = [13:52:24.716] #19 0x0000000000894d88 in BackendStartup (client_sock=0x821b61210) at ../src/backend/postmaster/postmaster.c:3417 [13:52:24.716] startup_data = {canAcceptConnections = CAC_OK} [13:52:24.716] bn = 0x835e1b128 [13:52:24.716] pid = [13:52:24.716] __error = [13:52:24.716] save_errno = [13:52:24.716] __error = [13:52:24.716] __error = [13:52:24.716] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [13:52:24.716] 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\016\3415\b", '\000' , "p\022\266!\b\000\000\000h5\037+\b\000\000\000\v\000\000\000\000\000\000\000^\277\037+\b", '\000' , "\260\022\266!\b\000\000\000d\a\211\000\000\000\000\000\300\022\266!\b", '\000' }, salen = 16}} [13:52:24.716] i = 0 [13:52:24.716] now = [13:52:24.716] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 739404930, events = 8, fd = 0, user_data = 0x821b611c0}, {pos = 904369624, events = 8, fd = 565579856, user_data = 0x0}, {pos = 0, events = 0, fd = 486688995, user_data = 0x605b4e2830a}, {pos = 738572192, events = 8, fd = 738643320, user_data = 0x821b60cd8}, {pos = 565579088, events = 8, fd = 565578968, user_data = 0x605b4e2830a}, {pos = 738550664, events = 8, fd = 738643320, user_data = 0x821b60d08}, {pos = 565579136, events = 8, fd = 565579016, user_data = 0x82c065194}, {pos = 573375496, events = 8, fd = 738611604, user_data = 0x821b60d70}, {pos = -1260243910, events = 1541, fd = 740433968, user_data = 0x1}, {pos = 565579168, events = 8, fd = -1260223734, user_data = 0x82c04e858}, {pos = 738643320, events = 8, fd = 565579128, user_data = 0x821b60df0}, {pos = 565579128, events = 8, fd = 738606348, user_data = 0x8222d0408}, {pos = 738606348, events = 8, fd = 565579232, user_data = 0x605b4e2343a}, {pos = 565579272, events = 8, fd = 565579720, user_data = 0x821b60df0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3286460371, fd = 573399096, user_data = 0x800000001}, {pos = 573375496, events = 8, fd = 738550664, user_data = 0x8222d5288}, {pos = 738519128, events = 8, fd = 573375496, user_data = 0x821b60e78}, {pos = 565579832, events = 8, fd = 565579360, user_data = 0x605b4e27ca2}, {pos = 2703130, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 573399096, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 565580088, user_data = 0x222d0408}, {pos = 565579904, events = 8, fd = 565579504, user_data = 0x1}, {pos = 565579832, events = 8, fd = 32, user_data = 0x821b60ee0}, {pos = -1260225933, events = 1541, fd = 565579776, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8222d6038}, {pos = 1, events = 8, fd = 573375496, user_data = 0x82c04e858}, {pos = 565580088, events = 8, fd = 565579904, user_data = 0x821b60ef0}, {pos = 0, events = 0, fd = 573345800, user_data = 0x20}, {pos = 565579888, events = 8, fd = -1260250393, user_data = 0x8222c9008}, {pos = 573346824, events = 8, fd = 573347848, user_data = 0x8222c9c08}, {pos = 573362184, events = 8, fd = 573363208, user_data = 0x8222cd808}, {pos = 573365256, events = 8, fd = 573366280, user_data = 0x8222ce408}, {pos = 573368328, events = 8, fd = 573369352, user_data = 0x8222cf008}, {pos = 573371400, events = 8, fd = 573372424, user_data = 0x8222cfc08}, {pos = 573374472, events = 8, fd = 573375496, user_data = 0x8222d0808}, {pos = 573377544, events = 8, fd = 573378568, user_data = 0x8222d1408}, {pos = 573380616, events = 8, fd = 573381640, user_data = 0x8222d2008}, {pos = 573383688, events = 8, fd = 573384712, user_data = 0x8222d2c08}, {pos = 573390856, events = 8, fd = 573391880, user_data = 0x8222d4808}, {pos = 573393928, events = 8, fd = 573345800, user_data = 0x293f1a}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8222d6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 565580088, events = 8, fd = 565579504, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 573399096, user_data = 0x1}, {pos = 573345800, events = 8, fd = 298, user_data = 0x821b61120}, {pos = -1260251665, events = 1541, fd = 2703130, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 573399096, user_data = 0x1}, {pos = 573375496, events = 8, fd = 903868416, user_data = 0x1}, {pos = 903868820, events = 8, fd = 0, user_data = 0x821b610f0}, {pos = 723498348, events = 8, fd = 1, user_data = 0x835dff000}, {pos = 565580064, events = 8, fd = 723494658, user_data = 0x82c180170 }, {pos = 12335048, events = 0, fd = 739770736, user_data = 0x8222d0408}, {pos = 565580288, events = 8, fd = -1260252194, user_data = 0x835e1d800}, {pos = 1, events = 0, fd = -1260252578, user_data = 0x8222c9008}, {pos = 565580072, events = 8, fd = 565580288, user_data = 0x1ab8}, {pos = 903941824, events = 8, fd = -1260172912, user_data = 0x0}, {pos = 565576575, events = 8, fd = 8124231, user_data = 0x821b611b0}, {pos = 723457040, events = 8, fd = 740433968, user_data = 0x82c224310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821b611e0}, {pos = 723499933, events = 8, fd = 903868416, user_data = 0x1da1}, {pos = 565580352, events = 8, fd = 723466490, user_data = 0x0}, {pos = 0, events = 0, fd = 486688995, user_data = 0x0}} [13:52:24.716] last_touch_time = 1731592062 [13:52:24.716] last_lockfile_recheck_time = 1731592062 [13:52:24.716] nevents = 1 [13:52:24.716] #21 0x0000000000892ba5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821b61828) at ../src/backend/postmaster/postmaster.c:1348 [13:52:24.716] userDoption = [13:52:24.716] listen_addr_saved = [13:52:24.716] output_config_variable = [13:52:24.716] opt = [13:52:24.716] status = [13:52:24.716] #22 0x00000000007cc3cc in main (argc=4, argv=0x821b61828) at ../src/backend/main/main.c:196 [13:52:24.716] do_check_root = [13:52:24.725] [13:52:24.725] [13:52:24.725] [13:52:24.788] dumping /tmp/cores/postgres.17676.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:52:24.911] [New LWP 101837] [13:52:24.979] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [13:52:24.979] Program terminated with signal SIGABRT, Aborted. [13:52:24.979] Sent by thr_kill() from pid 17676 and user 1003. [13:52:24.979] #0 0x000000082bb8341a in thr_kill () from /lib/libc.so.7 [13:52:25.022] [13:52:25.022] Thread 1 (LWP 101837): [13:52:25.022] #0 0x000000082bb8341a in thr_kill () from /lib/libc.so.7 [13:52:25.022] No symbol table info available. [13:52:25.022] #1 0x000000082bafce64 in raise () from /lib/libc.so.7 [13:52:25.022] No symbol table info available. [13:52:25.022] #2 0x000000082bbad6f9 in abort () from /lib/libc.so.7 [13:52:25.022] No symbol table info available. [13:52:25.022] #3 0x0000000000a990b5 in ExceptionalCondition (conditionName=0x2e7eee "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [13:52:25.022] No locals. [13:52:25.022] #4 0x0000000000769009 in standard_ExecutorStart (queryDesc=0x83f8f4088, eflags=0) at ../src/backend/executor/execMain.c:195 [13:52:25.022] estate = 0x83f90a100 [13:52:25.022] oldcontext = 0x837ef3800 [13:52:25.022] #5 0x000000083a0259c2 in pgss_ExecutorStart (queryDesc=0x83f8f4088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [13:52:25.022] No locals. [13:52:25.022] #6 0x00000000006fedc5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [13:52:25.022] copied_query = [13:52:25.022] rewritten = [13:52:25.022] plan = 0x83f96cbd8 [13:52:25.022] queryDesc = 0x83f8f4088 [13:52:25.022] processed = [13:52:25.022] __error = [13:52:25.022] #7 RefreshMatViewByOid (matviewOid=28059, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [13:52:25.022] dest = [13:52:25.022] save_userid = 10 [13:52:25.022] save_sec_context = 0 [13:52:25.022] processed = 0 [13:52:25.022] matviewRel = 0x83faf3518 [13:52:25.022] relowner = 10 [13:52:25.022] save_nestlevel = 2 [13:52:25.022] rule = [13:52:25.022] actions = [13:52:25.022] dataQuery = [13:52:25.022] tableSpace = [13:52:25.022] relpersistence = [13:52:25.022] OIDNewHeap = 28096 [13:52:25.022] address = [13:52:25.022] #8 0x00000000006fe9a6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:52:25.022] lockmode = [13:52:25.022] matviewOid = 0 [13:52:25.022] #9 0x00000000006d5aac in ExecCreateTableAs (pstate=pstate@entry=0x837ef3900, stmt=stmt@entry=0x837e00fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8219621f0) at ../src/backend/commands/createas.c:351 [13:52:25.022] refresh = 0x0 [13:52:25.022] query = 0x837e4b2c8 [13:52:25.022] into = 0x837e00f40 [13:52:25.022] jstate = 0x0 [13:52:25.022] do_refresh = false [13:52:25.022] address = [13:52:25.022] dest = [13:52:25.022] is_matview = [13:52:25.022] #10 0x0000000000944c58 in ProcessUtilitySlow (pstate=pstate@entry=0x837ef3900, pstmt=pstmt@entry=0x837e00e30, queryString=queryString@entry=0x837d63100 "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=0x8219621f0) at ../src/backend/tcop/utility.c:1678 [13:52:25.022] _local_sigjmp_buf = {{_sjb = {9716873, 0, 34923224152, 34923224528, 34923224160, 12405448, 0, 35298162944, 34923217791, 7, 34923224304, 0}}} [13:52:25.022] _save_exception_stack = 0x821961ee0 [13:52:25.022] _save_context_stack = 0x0 [13:52:25.022] _do_rethrow = false [13:52:25.022] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:52:25.022] parsetree = 0x837e00fd0 [13:52:25.022] commandCollected = false [13:52:25.022] needCleanup = false [13:52:25.022] address = [13:52:25.022] isTopLevel = [13:52:25.022] isCompleteQuery = [13:52:25.022] #11 0x00000000009435d8 in standard_ProcessUtility (pstmt=0x837e00e30, queryString=queryString@entry=0x837d63100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837e4ba68, qc=0x8219621f0) at ../src/backend/tcop/utility.c:1033 [13:52:25.022] isAtomicContext = false [13:52:25.022] parsetree = 0x837e00fd0 [13:52:25.022] readonly_flags = [13:52:25.022] pstate = 0x837ef3900 [13:52:25.022] isTopLevel = [13:52:25.022] #12 0x000000083a025f7e in pgss_ProcessUtility (pstmt=0x837e00e30, queryString=0x837d63100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837e4ba68, qc=0x8219621f0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [13:52:25.022] _local_sigjmp_buf = {{_sjb = {35332972215, 34923224800, 34923224664, 34923225120, 35297168944, 0, 12405448, 34923225328, 34923217791, 34923224900, 34923224928, 0}}} [13:52:25.022] _save_exception_stack = 0x8219620f0 [13:52:25.022] _save_context_stack = 0x0 [13:52:25.022] _do_rethrow = false [13:52:25.022] bufusage = {shared_blks_hit = 35332972215, shared_blks_read = 34923224800, shared_blks_dirtied = 34923224664, shared_blks_written = 34923225120, local_blks_hit = 35297168944, local_blks_read = 0, local_blks_dirtied = 12405448, local_blks_written = 34923225328, temp_blks_read = 34923217791, temp_blks_written = 34923224900, shared_blk_read_time = {ticks = 34923224928}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4266981431830800512}, local_blk_write_time = {ticks = 12414488}, temp_blk_read_time = {ticks = 35357407232}, temp_blk_write_time = {ticks = 12368000}} [13:52:25.022] walusage_start = {wal_records = 8960, wal_fpi = 95, wal_bytes = 1084699} [13:52:25.022] duration = [13:52:25.022] bufusage_start = {shared_blks_hit = 154120, shared_blks_read = 7905, shared_blks_dirtied = 2639, shared_blks_written = 2430, 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}} [13:52:25.022] walusage = {wal_records = -887201298454221235, wal_fpi = 35297169360, wal_bytes = 123} [13:52:25.022] start = {ticks = -186649329218} [13:52:25.022] rows = [13:52:25.022] saved_queryId = 6041762721901209185 [13:52:25.022] parsetree = [13:52:25.022] saved_stmt_location = 0 [13:52:25.022] saved_stmt_len = 69 [13:52:25.022] enabled = [13:52:25.022] #13 0x0000000000942ba3 in PortalRunUtility (portal=0x837e0b100, pstmt=0x837e00e30, isTopLevel=, setHoldSnapshot=, dest=0x837e4ba68, qc=0x8219621f0) at ../src/backend/tcop/pquery.c:1158 [13:52:25.022] No locals. [13:52:25.022] #14 0x0000000000942234 in PortalRunMulti (portal=portal@entry=0x837e0b100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x837e4ba68, altdest=altdest@entry=0x837e4ba68, qc=0x8219621f0) at ../src/backend/tcop/pquery.c:1322 [13:52:25.022] pstmt = 0x837e00e30 [13:52:25.022] stmtlist_item__state = {l = 0x837e4ba18, i = 0} [13:52:25.022] active_snapshot_set = false [13:52:25.022] stmtlist_item = 0x837e4ba30 [13:52:25.022] #15 0x0000000000941b03 in PortalRun (portal=portal@entry=0x837e0b100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x837e4ba68, altdest=altdest@entry=0x837e4ba68, qc=0x8219621f0) at ../src/backend/tcop/pquery.c:791 [13:52:25.022] _local_sigjmp_buf = {{_sjb = {9706109, 35297210624, 34923225320, 34923225552, 34923225328, 35297304576, 12372056, 12405448, 35297166207, 35297162720, 4294967984, 0}}} [13:52:25.022] _save_exception_stack = 0x8219622c0 [13:52:25.022] _save_context_stack = 0x0 [13:52:25.022] _do_rethrow = false [13:52:25.022] saveTopTransactionResourceOwner = 0x837e59718 [13:52:25.022] saveTopTransactionContext = 0x837e22000 [13:52:25.022] saveActivePortal = 0x0 [13:52:25.022] saveResourceOwner = 0x837e59718 [13:52:25.022] savePortalContext = 0x0 [13:52:25.022] saveMemoryContext = 0x837e22000 [13:52:25.022] result = [13:52:25.022] nprocessed = [13:52:25.022] #16 0x00000000009409a2 in exec_simple_query (query_string=query_string@entry=0x837d63100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:52:25.022] cmdtaglen = 24 [13:52:25.022] snapshot_set = [13:52:25.022] per_parsetree_context = 0x0 [13:52:25.022] plantree_list = [13:52:25.022] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:52:25.022] format = 0 [13:52:25.022] parsetree = 0x837d646a8 [13:52:25.022] commandTag = [13:52:25.022] cmdtagname = [13:52:25.022] querytree_list = [13:52:25.022] portal = 0x837e0b100 [13:52:25.022] receiver = 0x837e4ba68 [13:52:25.022] parsetree_item__state = {l = 0x837d64a18, i = 0} [13:52:25.022] msec_str = "\000\000\000\000\b", '\000' , "\273\3775g\000\000\000\000WD\003\210\262", [13:52:25.022] dest = DestRemote [13:52:25.022] was_logged = [13:52:25.022] oldcontext = 0x837e22000 [13:52:25.022] parsetree_list = 0x837d64a18 [13:52:25.022] use_implicit_block = false [13:52:25.022] parsetree_item = 0x837d64a30 [13:52:25.022] save_log_statement_stats = [13:52:25.022] #17 0x000000000093e613 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [13:52:25.022] query_string = 0x837d63100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:52:25.022] input_message = {data = 0x837d63100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:52:25.022] firstchar = [13:52:25.022] local_sigjmp_buf = {{_sjb = {9689798, 34923225792, 34923225752, 34923226336, 12414184, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [13:52:25.022] send_ready_for_query = false [13:52:25.022] idle_in_transaction_timeout_enabled = false [13:52:25.022] idle_session_timeout_enabled = false [13:52:25.022] #18 0x0000000000938df9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:52:25.022] bsdata = [13:52:25.022] #19 0x00000000008909b7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821963004 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821962f40) at ../src/backend/postmaster/launch_backend.c:266 [13:52:25.022] pid = [13:52:25.022] #20 0x0000000000894d88 in BackendStartup (client_sock=0x821962f40) at ../src/backend/postmaster/postmaster.c:3417 [13:52:25.022] startup_data = {canAcceptConnections = CAC_OK} [13:52:25.022] bn = 0x837d6f3a8 [13:52:25.022] pid = [13:52:25.022] __error = [13:52:25.022] save_errno = [13:52:25.022] __error = [13:52:25.022] __error = [13:52:25.022] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [13:52:25.022] 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 = " <\3267\b", '\000' , "\240/\226!\b\000\000\000h\345\244*\b\000\000\000\v\000\000\000\000\000\000\000^o\245*\b", '\000' , "\340/\226!\b\000\000\000d\a\211\000\000\000\000\000\360/\226!\b", '\000' }, salen = 16}} [13:52:25.022] i = 0 [13:52:25.022] now = [13:52:25.022] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 937190872, events = 8, fd = 563490176, user_data = 0x0}, {pos = -1178737910, events = 7040, fd = 732284832, user_data = 0x82ba6dd78}, {pos = 563489272, events = 8, fd = 563489392, user_data = 0x8219629f8}, {pos = -1178737910, events = 7040, fd = 732263304, user_data = 0x82ba6dd78}, {pos = 563489320, events = 8, fd = 563489440, user_data = 0x821962a28}, {pos = 732324244, events = 8, fd = 573400072, user_data = 0x82ba66194}, {pos = 563489424, events = 8, fd = -1178758086, user_data = 0x821962a30}, {pos = 715441168, events = 8, fd = 734146608, user_data = 0x1b80b9bde30a}, {pos = 732231768, events = 8, fd = 732355960, user_data = 0x821962a98}, {pos = 563489552, events = 8, fd = 563489432, user_data = 0x82ba64d0c}, {pos = 573400072, events = 8, fd = 732318988, user_data = 0x821962b00}, {pos = -1178758086, events = 7040, fd = 563489576, user_data = 0x821962cf8}, {pos = 563489552, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8222dc038}, {pos = 1, events = 4088399646, fd = 573400072, user_data = 0x82ba57388}, {pos = 573421512, events = 8, fd = 0, user_data = 0x0}, {pos = 563489688, events = 8, fd = 563490152, user_data = 0x821962b80}, {pos = -1178739550, events = 7040, fd = 2703130, user_data = 0x6d68b}, {pos = 2090263927, events = 4088399646, fd = 573423672, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821962e68}, {pos = 573400072, events = 3, fd = 563490224, user_data = 0x8222db828}, {pos = 656, events = 0, fd = 563490152, user_data = 0x821962b98}, {pos = 563489792, events = 8, fd = -1178739941, user_data = 0x821962d30}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 573423672, events = 8, fd = 1, user_data = 0x8222d6408}, {pos = 732231768, events = 8, fd = 563490408, user_data = 0x821962db0}, {pos = 563489808, events = 8, fd = 0, user_data = 0x8222cf008}, {pos = 33, events = 0, fd = 563490208, user_data = 0x1b80b9bd7ae7}, {pos = 573370376, events = 8, fd = 573371400, user_data = 0x8222cf808}, {pos = 573373448, events = 8, fd = 573386760, user_data = 0x8222d3408}, {pos = 573388808, events = 8, fd = 573389832, user_data = 0x8222d4008}, {pos = 573391880, events = 8, fd = 573392904, user_data = 0x8222d4c08}, {pos = 573394952, events = 8, fd = 573395976, user_data = 0x8222d5808}, {pos = 573398024, events = 8, fd = 573399048, user_data = 0x8222d6408}, {pos = 573401096, events = 8, fd = 573402120, user_data = 0x8222d7008}, {pos = 573404168, events = 8, fd = 573405192, user_data = 0x8222d7c08}, {pos = 573407240, events = 8, fd = 573408264, user_data = 0x8222d8808}, {pos = 573410312, events = 8, fd = 573415432, user_data = 0x8222da408}, {pos = 573417480, events = 8, fd = 573418504, user_data = 0x8222dd408}, {pos = 842150000, events = 0, fd = 573370376, user_data = 0x293f1a}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8222dc038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 563490408, events = 8, fd = 563489808, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 573423672, user_data = 0x1}, {pos = 573370376, events = 8, fd = 298, user_data = 0x821962e50}, {pos = -1178765841, events = 7040, fd = 2703130, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 573423672, user_data = 0x1}, {pos = 573400072, events = 8, fd = 936718336, user_data = 0x1}, {pos = 936718740, events = 8, fd = 0, user_data = 0x821962e20}, {pos = 715482476, events = 8, fd = 1, user_data = 0x837d53000}, {pos = 563490384, events = 8, fd = 715478786, user_data = 0x82bb81170 }, {pos = 12335048, events = 0, fd = 733483376, user_data = 0x8222d6408}, {pos = 563490608, events = 8, fd = -1178766370, user_data = 0x837d71800}, {pos = 1, events = 0, fd = -1178766754, user_data = 0x8222cf008}, {pos = 563490392, events = 8, fd = 563490608, user_data = 0x1ab8}, {pos = 936786976, events = 8, fd = -1178687088, user_data = 0x0}, {pos = 563479423, events = 8, fd = 8124231, user_data = 0x821962ee0}, {pos = 715441168, events = 8, fd = 734146608, user_data = 0x82bc25310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821962f10}, {pos = 715484061, events = 8, fd = 936718336, user_data = 0x3653}, {pos = 563490672, events = 8, fd = 715450618, user_data = 0x0}, {pos = 0, events = 0, fd = -1587614131, user_data = 0x0}} [13:52:25.022] last_touch_time = 1731592098 [13:52:25.022] last_lockfile_recheck_time = 1731592098 [13:52:25.022] nevents = 1 [13:52:25.022] #22 0x0000000000892ba5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821963550) at ../src/backend/postmaster/postmaster.c:1348 [13:52:25.022] userDoption = [13:52:25.022] listen_addr_saved = [13:52:25.022] output_config_variable = [13:52:25.022] opt = [13:52:25.022] status = [13:52:25.022] #23 0x00000000007cc3cc in main (argc=4, argv=0x821963550) at ../src/backend/main/main.c:196 [13:52:25.022] do_check_root =