[00:40:19.426] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [00:40:19.753] dumping /tmp/cores/postgres.10738.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:40:19.881] [New LWP 101945] [00:40:19.963] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [00:40:19.963] Program terminated with signal SIGABRT, Aborted. [00:40:19.963] Sent by thr_kill() from pid 10738 and user 1003. [00:40:19.963] #0 0x000000082bc2d41a in thr_kill () from /lib/libc.so.7 [00:40:20.017] [00:40:20.017] Thread 1 (LWP 101945): [00:40:20.017] #0 0x000000082bc2d41a in thr_kill () from /lib/libc.so.7 [00:40:20.017] No symbol table info available. [00:40:20.017] #1 0x000000082bba6e64 in raise () from /lib/libc.so.7 [00:40:20.017] No symbol table info available. [00:40:20.017] #2 0x000000082bc576f9 in abort () from /lib/libc.so.7 [00:40:20.017] No symbol table info available. [00:40:20.017] #3 0x0000000000a961d5 in ExceptionalCondition (conditionName=0x2e7bae "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [00:40:20.017] No locals. [00:40:20.017] #4 0x0000000000766f79 in standard_ExecutorStart (queryDesc=0x843c07088, eflags=0) at ../src/backend/executor/execMain.c:194 [00:40:20.017] estate = 0x835ff9100 [00:40:20.017] oldcontext = 0x843b50800 [00:40:20.017] #5 0x00000000006fdc95 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [00:40:20.017] copied_query = [00:40:20.017] rewritten = [00:40:20.017] plan = 0x83602fbd8 [00:40:20.017] queryDesc = 0x843c07088 [00:40:20.017] processed = [00:40:20.017] __error = [00:40:20.017] #6 RefreshMatViewByOid (matviewOid=27427, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [00:40:20.017] dest = [00:40:20.017] save_userid = 10 [00:40:20.017] save_sec_context = 0 [00:40:20.017] processed = 0 [00:40:20.017] matviewRel = 0x843b127c8 [00:40:20.017] relowner = 10 [00:40:20.017] save_nestlevel = 2 [00:40:20.017] rule = [00:40:20.017] actions = [00:40:20.017] dataQuery = [00:40:20.017] tableSpace = [00:40:20.017] relpersistence = [00:40:20.017] OIDNewHeap = 27439 [00:40:20.017] address = [00:40:20.017] #7 0x00000000006fd876 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:40:20.017] lockmode = [00:40:20.017] matviewOid = 0 [00:40:20.017] #8 0x00000000006d4a6c in ExecCreateTableAs (pstate=pstate@entry=0x843b50900, stmt=stmt@entry=0x835f5dfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821a475b0) at ../src/backend/commands/createas.c:351 [00:40:20.017] refresh = 0x0 [00:40:20.017] query = 0x835f7c2d8 [00:40:20.017] into = 0x835f7c620 [00:40:20.017] jstate = 0x0 [00:40:20.017] do_refresh = false [00:40:20.017] address = [00:40:20.017] dest = [00:40:20.017] is_matview = [00:40:20.017] #9 0x0000000000942258 in ProcessUtilitySlow (pstate=pstate@entry=0x843b50900, pstmt=pstmt@entry=0x835e9fa68, queryString=queryString@entry=0x835e9e100 "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=0x821a475b0) at ../src/backend/tcop/utility.c:1675 [00:40:20.017] _local_sigjmp_buf = {{_sjb = {9706121, 0, 34924163544, 34924163920, 34924163552, 12396264, 0, 35495676160, 4294902655, 34924163660, 34924163696, 0}}} [00:40:20.017] _save_exception_stack = 0x821a474b0 [00:40:20.017] _save_context_stack = 0x0 [00:40:20.017] _do_rethrow = false [00:40:20.017] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:40:20.017] parsetree = 0x835f5dfd0 [00:40:20.017] commandCollected = false [00:40:20.017] needCleanup = false [00:40:20.017] address = [00:40:20.017] isTopLevel = [00:40:20.017] isCompleteQuery = [00:40:20.017] #10 0x0000000000940bd8 in standard_ProcessUtility (pstmt=0x835e9fa68, queryString=0x835e9e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835f7cb08, qc=0x821a475b0) at ../src/backend/tcop/utility.c:1030 [00:40:20.017] isAtomicContext = false [00:40:20.017] parsetree = 0x835f5dfd0 [00:40:20.017] readonly_flags = [00:40:20.017] pstate = 0x843b50900 [00:40:20.017] isTopLevel = [00:40:20.017] #11 0x0000000000940668 in ProcessUtility (pstmt=0x18e39, queryString=0x6 , readOnlyTree=, context=734188538, params=0x0, queryEnv=0x0, dest=0x835f7cb08, qc=0x821a475b0) at ../src/backend/tcop/utility.c:523 [00:40:20.017] No locals. [00:40:20.017] #12 0x00000000009401a3 in PortalRunUtility (portal=0x835f75100, pstmt=0x835e9fa68, isTopLevel=, setHoldSnapshot=, dest=0x835f7cb08, qc=0x821a475b0) at ../src/backend/tcop/pquery.c:1158 [00:40:20.017] No locals. [00:40:20.017] #13 0x000000000093f834 in PortalRunMulti (portal=portal@entry=0x835f75100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835f7cb08, altdest=altdest@entry=0x835f7cb08, qc=0x821a475b0) at ../src/backend/tcop/pquery.c:1323 [00:40:20.017] pstmt = 0x835e9fa68 [00:40:20.017] stmtlist_item__state = {l = 0x835f7cab8, i = 0} [00:40:20.017] active_snapshot_set = false [00:40:20.017] stmtlist_item = 0x835f7cad0 [00:40:20.017] #14 0x000000000093f103 in PortalRun (portal=portal@entry=0x835f75100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835f7cb08, altdest=altdest@entry=0x835f7cb08, qc=0x821a475b0) at ../src/backend/tcop/pquery.c:791 [00:40:20.017] _local_sigjmp_buf = {{_sjb = {9695357, 35265138944, 34924164264, 34924164496, 34924164272, 35265155072, 12362872, 12396264, 35265119103, 35265037712, 4294967984, 0}}} [00:40:20.017] _save_exception_stack = 0x821a47680 [00:40:20.017] _save_context_stack = 0x0 [00:40:20.017] _do_rethrow = false [00:40:20.017] saveTopTransactionResourceOwner = 0x835f861d8 [00:40:20.017] saveTopTransactionContext = 0x835f79000 [00:40:20.017] saveActivePortal = 0x0 [00:40:20.017] saveResourceOwner = 0x835f861d8 [00:40:20.017] savePortalContext = 0x0 [00:40:20.017] saveMemoryContext = 0x835f79000 [00:40:20.017] result = [00:40:20.017] nprocessed = [00:40:20.017] #15 0x000000000093dfa2 in exec_simple_query (query_string=query_string@entry=0x835e9e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [00:40:20.017] cmdtaglen = 24 [00:40:20.017] snapshot_set = [00:40:20.017] per_parsetree_context = 0x0 [00:40:20.017] plantree_list = [00:40:20.017] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:40:20.017] format = 0 [00:40:20.017] parsetree = 0x835e9f6a8 [00:40:20.017] commandTag = [00:40:20.017] cmdtagname = [00:40:20.017] querytree_list = [00:40:20.017] portal = 0x835f75100 [00:40:20.017] receiver = 0x835f7cb08 [00:40:20.017] parsetree_item__state = {l = 0x835e9fa18, i = 0} [00:40:20.017] msec_str = "\000\000\000\000\b", '\000' , "\375\320\"g\000\000\000\000\272\200\202ZƎ\025`" [00:40:20.017] dest = DestRemote [00:40:20.017] was_logged = [00:40:20.017] oldcontext = 0x835f79000 [00:40:20.017] parsetree_list = 0x835e9fa18 [00:40:20.017] use_implicit_block = false [00:40:20.017] parsetree_item = 0x835e9fa30 [00:40:20.017] save_log_statement_stats = [00:40:20.017] #16 0x000000000093bc13 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [00:40:20.017] query_string = 0x835e9e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:40:20.017] input_message = {data = 0x835e9e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:40:20.017] firstchar = [00:40:20.017] local_sigjmp_buf = {{_sjb = {9679046, 34924164736, 34924164696, 34924165280, 12405000, 1, 8192, 8388608, 34924135295, 0, 0, 1}}} [00:40:20.017] send_ready_for_query = false [00:40:20.017] idle_in_transaction_timeout_enabled = false [00:40:20.017] idle_session_timeout_enabled = false [00:40:20.017] #17 0x00000000009363f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:40:20.017] bsdata = [00:40:20.017] #18 0x000000000088e0c7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a483c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a48300) at ../src/backend/postmaster/launch_backend.c:266 [00:40:20.017] pid = [00:40:20.017] #19 0x0000000000892498 in BackendStartup (client_sock=0x821a48300) at ../src/backend/postmaster/postmaster.c:3417 [00:40:20.017] startup_data = {canAcceptConnections = CAC_OK} [00:40:20.017] bn = 0x835eaa678 [00:40:20.017] pid = [00:40:20.017] __error = [00:40:20.017] save_errno = [00:40:20.017] __error = [00:40:20.017] __error = [00:40:20.017] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [00:40:20.017] 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\377\3515\b", '\000' , "`\203\244!\b\000\000\000he\"+\b\000\000\000\v\000\000\000\000\000\000\000^\357\"+\b", '\000' , "\240\203\244!\b\000\000\000tވ\000\000\000\000\000\260\203\244!\b", '\000' }, salen = 16}} [00:40:20.017] i = 0 [00:40:20.017] now = [00:40:20.017] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 733813890, events = 8, fd = 0, user_data = 0x821a482b0}, {pos = 904898008, events = 8, fd = 564429120, user_data = 0x0}, {pos = 0, events = 0, fd = 1949896778, user_data = 0x2f0eb2ca030a}, {pos = 732981152, events = 8, fd = 733052280, user_data = 0x821a47dc8}, {pos = 564428352, events = 8, fd = 564428232, user_data = 0x2f0eb2ca030a}, {pos = 732959624, events = 8, fd = 733052280, user_data = 0x821a47df8}, {pos = 564428400, events = 8, fd = 564428280, user_data = 0x82bb10194}, {pos = 576513032, events = 8, fd = 733020564, user_data = 0x821a47e60}, {pos = -1295403974, events = 12046, fd = 734842928, user_data = 0x1}, {pos = 564428432, events = 8, fd = -1295383798, user_data = 0x82baf9858}, {pos = 733052280, events = 8, fd = 564428392, user_data = 0x821a47ee0}, {pos = 564428392, events = 8, fd = 733015308, user_data = 0x8225ce408}, {pos = 733015308, events = 8, fd = 564428496, user_data = 0x2f0eb2c9b43a}, {pos = 564428536, events = 8, fd = 564428984, user_data = 0x821a47ee0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3765382164, fd = 576536632, user_data = 0x800000001}, {pos = 576513032, events = 8, fd = 732959624, user_data = 0x8225d3288}, {pos = 732928088, events = 8, fd = 576513032, user_data = 0x821a47f68}, {pos = 564429096, events = 8, fd = 564428624, user_data = 0x2f0eb2c9fca2}, {pos = 2702677, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 576536632, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564429352, user_data = 0x225ce408}, {pos = 564429168, events = 8, fd = 564428768, user_data = 0x1}, {pos = 564429096, events = 8, fd = 32, user_data = 0x821a47fd0}, {pos = -1295385997, events = 12046, fd = 564429040, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8225d4038}, {pos = 1, events = 8, fd = 576513032, user_data = 0x82baf9858}, {pos = 564429352, events = 8, fd = 564429168, user_data = 0x821a47fe0}, {pos = 0, events = 0, fd = 576483336, user_data = 0x20}, {pos = 564429152, events = 8, fd = -1295410457, user_data = 0x8225c7008}, {pos = 576484360, events = 8, fd = 576485384, user_data = 0x8225c7c08}, {pos = 576499720, events = 8, fd = 576500744, user_data = 0x8225cb808}, {pos = 576502792, events = 8, fd = 576503816, user_data = 0x8225cc408}, {pos = 576505864, events = 8, fd = 576506888, user_data = 0x8225cd008}, {pos = 576508936, events = 8, fd = 576509960, user_data = 0x8225cdc08}, {pos = 576512008, events = 8, fd = 576513032, user_data = 0x8225ce808}, {pos = 576515080, events = 8, fd = 576516104, user_data = 0x8225cf408}, {pos = 576518152, events = 8, fd = 576519176, user_data = 0x8225d0008}, {pos = 576521224, events = 8, fd = 576522248, user_data = 0x8225d0c08}, {pos = 576528392, events = 8, fd = 576529416, user_data = 0x8225d2808}, {pos = 576531464, events = 8, fd = 576483336, user_data = 0x293d55}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8225d4038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564429352, events = 8, fd = 564428768, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 576536632, user_data = 0x1}, {pos = 576483336, events = 8, fd = 298, user_data = 0x821a48210}, {pos = -1295411729, events = 12046, fd = 2702677, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 576536632, user_data = 0x1}, {pos = 576513032, events = 8, fd = 904454144, user_data = 0x1}, {pos = 904454548, events = 8, fd = 0, user_data = 0x821a481e0}, {pos = 723707244, events = 8, fd = 1, user_data = 0x835e8e000}, {pos = 564429328, events = 8, fd = 723703554, user_data = 0x82bc2b170 }, {pos = 12325848, events = 0, fd = 734179696, user_data = 0x8225ce408}, {pos = 564429552, events = 8, fd = -1295412258, user_data = 0x835eac800}, {pos = 1, events = 0, fd = -1295412642, user_data = 0x8225c7008}, {pos = 564429336, events = 8, fd = 564429552, user_data = 0x1ab8}, {pos = 904527616, events = 8, fd = -1295332976, user_data = 0x0}, {pos = 564396927, events = 8, fd = 8115943, user_data = 0x821a482a0}, {pos = 723665936, events = 8, fd = 734842928, user_data = 0x82bccf310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a482d0}, {pos = 723708829, events = 8, fd = 904454144, user_data = 0x1df4}, {pos = 564429616, events = 8, fd = 723675386, user_data = 0x0}, {pos = 0, events = 0, fd = 1949896778, user_data = 0x0}} [00:40:20.017] last_touch_time = 1730334954 [00:40:20.017] last_lockfile_recheck_time = 1730334954 [00:40:20.017] nevents = 1 [00:40:20.017] #21 0x00000000008902b5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821a48910) at ../src/backend/postmaster/postmaster.c:1348 [00:40:20.017] userDoption = [00:40:20.017] listen_addr_saved = [00:40:20.017] output_config_variable = [00:40:20.017] opt = [00:40:20.017] status = [00:40:20.017] #22 0x00000000007ca36c in main (argc=8, argv=0x821a48910) at ../src/backend/main/main.c:196 [00:40:20.017] do_check_root = [00:40:20.026] [00:40:20.026] [00:40:20.026] [00:40:20.086] dumping /tmp/cores/postgres.11009.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:40:20.205] [New LWP 101916] [00:40:20.265] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [00:40:20.265] Program terminated with signal SIGABRT, Aborted. [00:40:20.265] Sent by thr_kill() from pid 11009 and user 1003. [00:40:20.265] #0 0x000000082d28141a in thr_kill () from /lib/libc.so.7 [00:40:20.299] [00:40:20.299] Thread 1 (LWP 101916): [00:40:20.299] #0 0x000000082d28141a in thr_kill () from /lib/libc.so.7 [00:40:20.299] No symbol table info available. [00:40:20.299] #1 0x000000082d1fae64 in raise () from /lib/libc.so.7 [00:40:20.299] No symbol table info available. [00:40:20.299] #2 0x000000082d2ab6f9 in abort () from /lib/libc.so.7 [00:40:20.299] No symbol table info available. [00:40:20.299] #3 0x0000000000a961d5 in ExceptionalCondition (conditionName=0x2e7bae "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [00:40:20.299] No locals. [00:40:20.299] #4 0x0000000000766f79 in standard_ExecutorStart (queryDesc=0x836d38088, eflags=0) at ../src/backend/executor/execMain.c:194 [00:40:20.299] estate = 0x836e57100 [00:40:20.299] oldcontext = 0x836e93800 [00:40:20.299] #5 0x00000000006fdc95 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [00:40:20.299] copied_query = [00:40:20.299] rewritten = [00:40:20.299] plan = 0x836da0bd8 [00:40:20.299] queryDesc = 0x836d38088 [00:40:20.299] processed = [00:40:20.299] __error = [00:40:20.299] #6 RefreshMatViewByOid (matviewOid=27347, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [00:40:20.299] dest = [00:40:20.299] save_userid = 10 [00:40:20.299] save_sec_context = 0 [00:40:20.299] processed = 0 [00:40:20.299] matviewRel = 0x843dc3810 [00:40:20.299] relowner = 10 [00:40:20.299] save_nestlevel = 2 [00:40:20.299] rule = [00:40:20.299] actions = [00:40:20.299] dataQuery = [00:40:20.299] tableSpace = [00:40:20.299] relpersistence = [00:40:20.299] OIDNewHeap = 27370 [00:40:20.299] address = [00:40:20.299] #7 0x00000000006fd876 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:40:20.299] lockmode = [00:40:20.299] matviewOid = 0 [00:40:20.299] #8 0x00000000006d4a6c in ExecCreateTableAs (pstate=pstate@entry=0x836e93900, stmt=stmt@entry=0x836d9dfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821722e60) at ../src/backend/commands/createas.c:351 [00:40:20.299] refresh = 0x0 [00:40:20.299] query = 0x843ecac18 [00:40:20.299] into = 0x843ecaf60 [00:40:20.299] jstate = 0x0 [00:40:20.299] do_refresh = false [00:40:20.299] address = [00:40:20.299] dest = [00:40:20.299] is_matview = [00:40:20.299] #9 0x0000000000942258 in ProcessUtilitySlow (pstate=pstate@entry=0x836e93900, pstmt=pstmt@entry=0x836cc1a68, queryString=queryString@entry=0x836cc0100 "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=0x821722e60) at ../src/backend/tcop/utility.c:1675 [00:40:20.299] _local_sigjmp_buf = {{_sjb = {9706121, 0, 34920868488, 34920868864, 34920868496, 12396264, 0, 35280992512, 4294902655, 34920868604, 34920868640, 0}}} [00:40:20.299] _save_exception_stack = 0x821722d60 [00:40:20.299] _save_context_stack = 0x0 [00:40:20.299] _do_rethrow = false [00:40:20.299] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:40:20.299] parsetree = 0x836d9dfd0 [00:40:20.299] commandCollected = false [00:40:20.299] needCleanup = false [00:40:20.299] address = [00:40:20.299] isTopLevel = [00:40:20.299] isCompleteQuery = [00:40:20.299] #10 0x0000000000940bd8 in standard_ProcessUtility (pstmt=0x836cc1a68, queryString=0x836cc0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x843ecb448, qc=0x821722e60) at ../src/backend/tcop/utility.c:1030 [00:40:20.299] isAtomicContext = false [00:40:20.299] parsetree = 0x836d9dfd0 [00:40:20.299] readonly_flags = [00:40:20.299] pstate = 0x836e93900 [00:40:20.299] isTopLevel = [00:40:20.299] #11 0x0000000000940668 in ProcessUtility (pstmt=0x18e1c, queryString=0x6 , readOnlyTree=, context=757601274, params=0x0, queryEnv=0x0, dest=0x843ecb448, qc=0x821722e60) at ../src/backend/tcop/utility.c:523 [00:40:20.299] No locals. [00:40:20.299] #12 0x00000000009401a3 in PortalRunUtility (portal=0x836d66100, pstmt=0x836cc1a68, isTopLevel=, setHoldSnapshot=, dest=0x843ecb448, qc=0x821722e60) at ../src/backend/tcop/pquery.c:1158 [00:40:20.299] No locals. [00:40:20.299] #13 0x000000000093f834 in PortalRunMulti (portal=portal@entry=0x836d66100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x843ecb448, altdest=altdest@entry=0x843ecb448, qc=0x821722e60) at ../src/backend/tcop/pquery.c:1323 [00:40:20.299] pstmt = 0x836cc1a68 [00:40:20.299] stmtlist_item__state = {l = 0x843ecb3f8, i = 0} [00:40:20.299] active_snapshot_set = false [00:40:20.299] stmtlist_item = 0x843ecb410 [00:40:20.299] #14 0x000000000093f103 in PortalRun (portal=portal@entry=0x836d66100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x843ecb448, altdest=altdest@entry=0x843ecb448, qc=0x821722e60) at ../src/backend/tcop/pquery.c:791 [00:40:20.299] _local_sigjmp_buf = {{_sjb = {9695357, 35279757568, 34920869208, 34920869440, 34920869216, 35279773696, 12362872, 12396264, 35279733631, 35279979920, 4294967984, 0}}} [00:40:20.299] _save_exception_stack = 0x821722f30 [00:40:20.299] _save_context_stack = 0x0 [00:40:20.299] _do_rethrow = false [00:40:20.299] saveTopTransactionResourceOwner = 0x836db5558 [00:40:20.299] saveTopTransactionContext = 0x836d6a000 [00:40:20.299] saveActivePortal = 0x0 [00:40:20.299] saveResourceOwner = 0x836db5558 [00:40:20.299] savePortalContext = 0x0 [00:40:20.299] saveMemoryContext = 0x836d6a000 [00:40:20.299] result = [00:40:20.299] nprocessed = [00:40:20.299] #15 0x000000000093dfa2 in exec_simple_query (query_string=query_string@entry=0x836cc0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [00:40:20.299] cmdtaglen = 24 [00:40:20.299] snapshot_set = [00:40:20.299] per_parsetree_context = 0x0 [00:40:20.299] plantree_list = [00:40:20.299] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:40:20.299] format = 0 [00:40:20.299] parsetree = 0x836cc16a8 [00:40:20.299] commandTag = [00:40:20.299] cmdtagname = [00:40:20.299] querytree_list = [00:40:20.299] portal = 0x836d66100 [00:40:20.299] receiver = 0x843ecb448 [00:40:20.299] parsetree_item__state = {l = 0x836cc1a18, i = 0} [00:40:20.299] msec_str = "\000\000\000\000\b", '\000' , "\377\320\"g\000\000\000\0002s\022V\327=~Z" [00:40:20.299] dest = DestRemote [00:40:20.299] was_logged = [00:40:20.299] oldcontext = 0x836d6a000 [00:40:20.299] parsetree_list = 0x836cc1a18 [00:40:20.299] use_implicit_block = false [00:40:20.299] parsetree_item = 0x836cc1a30 [00:40:20.299] save_log_statement_stats = [00:40:20.299] #16 0x000000000093bc13 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [00:40:20.299] query_string = 0x836cc0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:40:20.299] input_message = {data = 0x836cc0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:40:20.299] firstchar = [00:40:20.299] local_sigjmp_buf = {{_sjb = {9679046, 34920869680, 34920869640, 34920870224, 12405000, 1, 8192, 8388608, 34920858495, 0, 0, 1}}} [00:40:20.299] send_ready_for_query = false [00:40:20.299] idle_in_transaction_timeout_enabled = false [00:40:20.299] idle_session_timeout_enabled = false [00:40:20.299] #17 0x00000000009363f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:40:20.299] bsdata = [00:40:20.299] #18 0x000000000088e0c7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821723c74 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821723bb0) at ../src/backend/postmaster/launch_backend.c:266 [00:40:20.299] pid = [00:40:20.299] #19 0x0000000000892498 in BackendStartup (client_sock=0x821723bb0) at ../src/backend/postmaster/postmaster.c:3417 [00:40:20.299] startup_data = {canAcceptConnections = CAC_OK} [00:40:20.299] bn = 0x836ccc218 [00:40:20.299] pid = [00:40:20.299] __error = [00:40:20.299] save_errno = [00:40:20.299] __error = [00:40:20.299] __error = [00:40:20.299] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [00:40:20.299] 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\036\3146\b", '\000' , "\020, "P}, salen = 16}} [00:40:20.299] i = 0 [00:40:20.299] now = [00:40:20.299] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 757226626, events = 8, fd = 0, user_data = 0x821723b60}, {pos = 919774680, events = 8, fd = 561134064, user_data = 0x0}, {pos = 0, events = 0, fd = -369257654, user_data = 0xfb57a45130a}, {pos = 756393888, events = 8, fd = 756465016, user_data = 0x821723678}, {pos = 561133296, events = 8, fd = 561133176, user_data = 0xfb57a45130a}, {pos = 756372360, events = 8, fd = 756465016, user_data = 0x8217236a8}, {pos = 561133344, events = 8, fd = 561133224, user_data = 0x82d164194}, {pos = 574301192, events = 8, fd = 756433300, user_data = 0x821723710}, {pos = 2051327034, events = 4021, fd = 758255664, user_data = 0x1}, {pos = 561133376, events = 8, fd = 2051347210, user_data = 0x82d14d858}, {pos = 756465016, events = 8, fd = 561133336, user_data = 0x821723790}, {pos = 561133336, events = 8, fd = 756428044, user_data = 0x8223b2408}, {pos = 756428044, events = 8, fd = 561133440, user_data = 0xfb57a44c43a}, {pos = 561133480, events = 8, fd = 561133928, user_data = 0x821723790}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1610994771, fd = 574324792, user_data = 0x800000001}, {pos = 574301192, events = 8, fd = 756372360, user_data = 0x8223b7288}, {pos = 756340824, events = 8, fd = 574301192, user_data = 0x821723818}, {pos = 561134040, events = 8, fd = 561133568, user_data = 0xfb57a450ca2}, {pos = 2702677, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 574324792, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 561134296, user_data = 0x223b2408}, {pos = 561134112, events = 8, fd = 561133712, user_data = 0x1}, {pos = 561134040, events = 8, fd = 32, user_data = 0x821723880}, {pos = 2051345011, events = 4021, fd = 561133984, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8223b8038}, {pos = 1, events = 8, fd = 574301192, user_data = 0x82d14d858}, {pos = 561134296, events = 8, fd = 561134112, user_data = 0x821723890}, {pos = 0, events = 0, fd = 574271496, user_data = 0x20}, {pos = 561134096, events = 8, fd = 2051320551, user_data = 0x8223ab008}, {pos = 574272520, events = 8, fd = 574273544, user_data = 0x8223abc08}, {pos = 574287880, events = 8, fd = 574288904, user_data = 0x8223af808}, {pos = 574290952, events = 8, fd = 574291976, user_data = 0x8223b0408}, {pos = 574294024, events = 8, fd = 574295048, user_data = 0x8223b1008}, {pos = 574297096, events = 8, fd = 574298120, user_data = 0x8223b1c08}, {pos = 574300168, events = 8, fd = 574301192, user_data = 0x8223b2808}, {pos = 574303240, events = 8, fd = 574304264, user_data = 0x8223b3408}, {pos = 574306312, events = 8, fd = 574307336, user_data = 0x8223b4008}, {pos = 574309384, events = 8, fd = 574310408, user_data = 0x8223b4c08}, {pos = 574316552, events = 8, fd = 574317576, user_data = 0x8223b6808}, {pos = 574319624, events = 8, fd = 574271496, user_data = 0x293d55}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8223b8038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 561134296, events = 8, fd = 561133712, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 574324792, user_data = 0x1}, {pos = 574271496, events = 8, fd = 298, user_data = 0x821723ac0}, {pos = 2051319279, events = 4021, fd = 2702677, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 574324792, user_data = 0x1}, {pos = 574301192, events = 8, fd = 919273472, user_data = 0x1}, {pos = 919273876, events = 8, fd = 0, user_data = 0x821723a90}, {pos = 747873644, events = 8, fd = 1, user_data = 0x836cb0000}, {pos = 561134272, events = 8, fd = 747869954, user_data = 0x82d27f170 }, {pos = 12325848, events = 0, fd = 757592432, user_data = 0x8223b2408}, {pos = 561134496, events = 8, fd = 2051318750, user_data = 0x836cce800}, {pos = 1, events = 0, fd = 2051318366, user_data = 0x8223ab008}, {pos = 561134280, events = 8, fd = 561134496, user_data = 0x1ab8}, {pos = 919346880, events = 8, fd = 2051398032, user_data = 0x0}, {pos = 561120127, events = 8, fd = 8115943, user_data = 0x821723b50}, {pos = 747832336, events = 8, fd = 758255664, user_data = 0x82d323310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821723b80}, {pos = 747875229, events = 8, fd = 919273472, user_data = 0x1e42}, {pos = 561134560, events = 8, fd = 747841786, user_data = 0x0}, {pos = 0, events = 0, fd = -369257654, user_data = 0x0}} [00:40:20.299] last_touch_time = 1730334954 [00:40:20.299] last_lockfile_recheck_time = 1730334954 [00:40:20.299] nevents = 1 [00:40:20.299] #21 0x00000000008902b5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8217241c0) at ../src/backend/postmaster/postmaster.c:1348 [00:40:20.299] userDoption = [00:40:20.299] listen_addr_saved = [00:40:20.299] output_config_variable = [00:40:20.299] opt = [00:40:20.299] status = [00:40:20.299] #22 0x00000000007ca36c in main (argc=4, argv=0x8217241c0) at ../src/backend/main/main.c:196 [00:40:20.299] do_check_root = [00:40:20.307] [00:40:20.307] [00:40:20.307] [00:40:20.366] dumping /tmp/cores/postgres.17138.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:40:20.486] [New LWP 101843] [00:40:20.548] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [00:40:20.548] Program terminated with signal SIGABRT, Aborted. [00:40:20.548] Sent by thr_kill() from pid 17138 and user 1003. [00:40:20.548] #0 0x000000082c6f441a in thr_kill () from /lib/libc.so.7 [00:40:20.589] [00:40:20.589] Thread 1 (LWP 101843): [00:40:20.589] #0 0x000000082c6f441a in thr_kill () from /lib/libc.so.7 [00:40:20.589] No symbol table info available. [00:40:20.589] #1 0x000000082c66de64 in raise () from /lib/libc.so.7 [00:40:20.589] No symbol table info available. [00:40:20.589] #2 0x000000082c71e6f9 in abort () from /lib/libc.so.7 [00:40:20.589] No symbol table info available. [00:40:20.589] #3 0x0000000000a961d5 in ExceptionalCondition (conditionName=0x2e7bae "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [00:40:20.589] No locals. [00:40:20.589] #4 0x0000000000766f79 in standard_ExecutorStart (queryDesc=0x8368fc088, eflags=0) at ../src/backend/executor/execMain.c:194 [00:40:20.589] estate = 0x83dbeb100 [00:40:20.589] oldcontext = 0x8368ff800 [00:40:20.589] #5 0x0000000839a839c2 in pgss_ExecutorStart (queryDesc=0x8368fc088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [00:40:20.589] No locals. [00:40:20.589] #6 0x00000000006fdc95 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [00:40:20.589] copied_query = [00:40:20.589] rewritten = [00:40:20.589] plan = 0x8368f4bd8 [00:40:20.589] queryDesc = 0x8368fc088 [00:40:20.589] processed = [00:40:20.589] __error = [00:40:20.589] #7 RefreshMatViewByOid (matviewOid=27387, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [00:40:20.589] dest = [00:40:20.589] save_userid = 10 [00:40:20.589] save_sec_context = 0 [00:40:20.589] processed = 0 [00:40:20.589] matviewRel = 0x83dc1e038 [00:40:20.589] relowner = 10 [00:40:20.589] save_nestlevel = 2 [00:40:20.589] rule = [00:40:20.589] actions = [00:40:20.589] dataQuery = [00:40:20.589] tableSpace = [00:40:20.589] relpersistence = [00:40:20.589] OIDNewHeap = 27444 [00:40:20.589] address = [00:40:20.589] #8 0x00000000006fd876 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:40:20.589] lockmode = [00:40:20.589] matviewOid = 0 [00:40:20.589] #9 0x00000000006d4a6c in ExecCreateTableAs (pstate=pstate@entry=0x8368ff900, stmt=stmt@entry=0x83680afd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8214adf00) at ../src/backend/commands/createas.c:351 [00:40:20.589] refresh = 0x0 [00:40:20.589] query = 0x836855988 [00:40:20.589] into = 0x83680af40 [00:40:20.589] jstate = 0x0 [00:40:20.589] do_refresh = false [00:40:20.589] address = [00:40:20.589] dest = [00:40:20.589] is_matview = [00:40:20.589] #10 0x0000000000942258 in ProcessUtilitySlow (pstate=pstate@entry=0x8368ff900, pstmt=pstmt@entry=0x83680ae30, queryString=queryString@entry=0x83676d100 "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=0x8214adf00) at ../src/backend/tcop/utility.c:1675 [00:40:20.589] _local_sigjmp_buf = {{_sjb = {9706121, 0, 34918291816, 34918292192, 34918291824, 12396264, 0, 35275143424, 34918237055, 7, 34918291968, 0}}} [00:40:20.589] _save_exception_stack = 0x8214adbf0 [00:40:20.589] _save_context_stack = 0x0 [00:40:20.589] _do_rethrow = false [00:40:20.589] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:40:20.589] parsetree = 0x83680afd0 [00:40:20.589] commandCollected = false [00:40:20.589] needCleanup = false [00:40:20.589] address = [00:40:20.589] isTopLevel = [00:40:20.589] isCompleteQuery = [00:40:20.589] #11 0x0000000000940bd8 in standard_ProcessUtility (pstmt=0x83680ae30, queryString=queryString@entry=0x83676d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836856128, qc=0x8214adf00) at ../src/backend/tcop/utility.c:1030 [00:40:20.589] isAtomicContext = false [00:40:20.589] parsetree = 0x83680afd0 [00:40:20.589] readonly_flags = [00:40:20.589] pstate = 0x8368ff900 [00:40:20.589] isTopLevel = [00:40:20.589] #12 0x0000000839a83f7e in pgss_ProcessUtility (pstmt=0x83680ae30, queryString=0x83676d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836856128, qc=0x8214adf00) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [00:40:20.589] _local_sigjmp_buf = {{_sjb = {35327065783, 34918292464, 34918292328, 34918292784, 35274141232, 0, 12396264, 34918292992, 34918237055, 34918292564, 34918292592, 0}}} [00:40:20.589] _save_exception_stack = 0x8214ade00 [00:40:20.589] _save_context_stack = 0x0 [00:40:20.589] _do_rethrow = false [00:40:20.589] bufusage = {shared_blks_hit = 35327065783, shared_blks_read = 34918292464, shared_blks_dirtied = 34918292328, shared_blks_written = 34918292784, local_blks_hit = 35274141232, local_blks_read = 0, local_blks_dirtied = 12396264, local_blks_written = 34918292992, temp_blks_read = 34918237055, temp_blks_written = 34918292564, shared_blk_read_time = {ticks = 34918292592}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4265996269412083968}, local_blk_write_time = {ticks = 12405304}, temp_blk_read_time = {ticks = 35357178112}, temp_blk_write_time = {ticks = 12358816}} [00:40:20.589] walusage_start = {wal_records = 8937, wal_fpi = 121, wal_bytes = 1197325} [00:40:20.589] duration = [00:40:20.589] bufusage_start = {shared_blks_hit = 151945, shared_blks_read = 8433, shared_blks_dirtied = 2569, shared_blks_written = 2355, 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}} [00:40:20.589] walusage = {wal_records = 676432828011297693, wal_fpi = 35274141648, wal_bytes = 123} [00:40:20.589] start = {ticks = -175933719180} [00:40:20.589] rows = [00:40:20.589] saved_queryId = 6041762721901209185 [00:40:20.589] parsetree = [00:40:20.589] saved_stmt_location = 0 [00:40:20.589] saved_stmt_len = 69 [00:40:20.589] enabled = [00:40:20.589] #13 0x00000000009401a3 in PortalRunUtility (portal=0x836815100, pstmt=0x83680ae30, isTopLevel=, setHoldSnapshot=, dest=0x836856128, qc=0x8214adf00) at ../src/backend/tcop/pquery.c:1158 [00:40:20.589] No locals. [00:40:20.589] #14 0x000000000093f834 in PortalRunMulti (portal=portal@entry=0x836815100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x836856128, altdest=altdest@entry=0x836856128, qc=0x8214adf00) at ../src/backend/tcop/pquery.c:1323 [00:40:20.589] pstmt = 0x83680ae30 [00:40:20.589] stmtlist_item__state = {l = 0x8368560d8, i = 0} [00:40:20.589] active_snapshot_set = false [00:40:20.589] stmtlist_item = 0x8368560f0 [00:40:20.589] #15 0x000000000093f103 in PortalRun (portal=portal@entry=0x836815100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x836856128, altdest=altdest@entry=0x836856128, qc=0x8214adf00) at ../src/backend/tcop/pquery.c:791 [00:40:20.589] _local_sigjmp_buf = {{_sjb = {9695357, 35274182912, 34918292984, 34918293216, 34918292992, 35274276864, 12362872, 12396264, 35274163071, 35274135008, 4294967984, 0}}} [00:40:20.589] _save_exception_stack = 0x8214adfd0 [00:40:20.589] _save_context_stack = 0x0 [00:40:20.589] _do_rethrow = false [00:40:20.589] saveTopTransactionResourceOwner = 0x836863918 [00:40:20.589] saveTopTransactionContext = 0x83682c000 [00:40:20.589] saveActivePortal = 0x0 [00:40:20.589] saveResourceOwner = 0x836863918 [00:40:20.589] savePortalContext = 0x0 [00:40:20.589] saveMemoryContext = 0x83682c000 [00:40:20.589] result = [00:40:20.589] nprocessed = [00:40:20.589] #16 0x000000000093dfa2 in exec_simple_query (query_string=query_string@entry=0x83676d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [00:40:20.589] cmdtaglen = 24 [00:40:20.589] snapshot_set = [00:40:20.589] per_parsetree_context = 0x0 [00:40:20.589] plantree_list = [00:40:20.589] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:40:20.589] format = 0 [00:40:20.589] parsetree = 0x83676e6a8 [00:40:20.589] commandTag = [00:40:20.589] cmdtagname = [00:40:20.589] querytree_list = [00:40:20.589] portal = 0x836815100 [00:40:20.589] receiver = 0x836856128 [00:40:20.589] parsetree_item__state = {l = 0x83676ea18, i = 0} [00:40:20.589] msec_str = "\000\000\000\000\b", '\000' , "!\321\"g\000\000\000\000\206?\234\277\342", [00:40:20.589] dest = DestRemote [00:40:20.589] was_logged = [00:40:20.589] oldcontext = 0x83682c000 [00:40:20.589] parsetree_list = 0x83676ea18 [00:40:20.589] use_implicit_block = false [00:40:20.589] parsetree_item = 0x83676ea30 [00:40:20.589] save_log_statement_stats = [00:40:20.589] #17 0x000000000093bc13 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [00:40:20.589] query_string = 0x83676d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:40:20.589] input_message = {data = 0x83676d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:40:20.589] firstchar = [00:40:20.589] local_sigjmp_buf = {{_sjb = {9679046, 34918293456, 34918293416, 34918294000, 12405000, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [00:40:20.589] send_ready_for_query = false [00:40:20.589] idle_in_transaction_timeout_enabled = false [00:40:20.589] idle_session_timeout_enabled = false [00:40:20.589] #18 0x00000000009363f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:40:20.589] bsdata = [00:40:20.589] #19 0x000000000088e0c7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8214aed14 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214aec50) at ../src/backend/postmaster/launch_backend.c:266 [00:40:20.589] pid = [00:40:20.589] #20 0x0000000000892498 in BackendStartup (client_sock=0x8214aec50) at ../src/backend/postmaster/postmaster.c:3417 [00:40:20.589] startup_data = {canAcceptConnections = CAC_OK} [00:40:20.589] bn = 0x836779628 [00:40:20.589] pid = [00:40:20.589] __error = [00:40:20.589] save_errno = [00:40:20.589] __error = [00:40:20.589] __error = [00:40:20.589] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [00:40:20.589] 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 = " \334v6\b", '\000' , "\260\354J!\b\000\000\000h5,,\b\000\000\000\v\000\000\000\000\000\000\000^\277,,\b", '\000' , "\360\354J!\b\000\000\000tވ\000\000\000\000\000\000\355J!\b", '\000' }, salen = 16}} [00:40:20.589] i = 0 [00:40:20.589] now = [00:40:20.589] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 745114754, events = 8, fd = 0, user_data = 0x8214aec00}, {pos = 914163160, events = 8, fd = 558557840, user_data = 0x0}, {pos = -1503579382, events = 1485, fd = 744282016, user_data = 0x82c5ded78}, {pos = 558556936, events = 8, fd = 558557056, user_data = 0x8214ae708}, {pos = -1503579382, events = 1485, fd = 744260488, user_data = 0x82c5ded78}, {pos = 558556984, events = 8, fd = 558557104, user_data = 0x8214ae738}, {pos = 744321428, events = 8, fd = 566395912, user_data = 0x82c5d7194}, {pos = 558557088, events = 8, fd = -1503599558, user_data = 0x8214ae740}, {pos = 741086224, events = 8, fd = 746143792, user_data = 0x5cda661330a}, {pos = 744228952, events = 8, fd = 744353144, user_data = 0x8214ae7a8}, {pos = 558557216, events = 8, fd = 558557096, user_data = 0x82c5d5d0c}, {pos = 566395912, events = 8, fd = 744316172, user_data = 0x8214ae810}, {pos = -1503599558, events = 1485, fd = 558557240, user_data = 0x8214aea08}, {pos = 558557216, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821c2e038}, {pos = 1, events = 157494290, fd = 566395912, user_data = 0x82c5c8388}, {pos = 566417352, events = 8, fd = 0, user_data = 0x0}, {pos = 558557352, events = 8, fd = 558557816, user_data = 0x8214ae890}, {pos = -1503581022, events = 1485, fd = 2702677, user_data = 0x6d68b}, {pos = 2090263927, events = 157494290, fd = 566419512, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8214aeb78}, {pos = 566395912, events = 3, fd = 558557888, user_data = 0x821c2d828}, {pos = 656, events = 0, fd = 558557816, user_data = 0x8214ae8a8}, {pos = 558557456, events = 8, fd = -1503581413, user_data = 0x8214aea40}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 566419512, events = 8, fd = 1, user_data = 0x821c28408}, {pos = 744228952, events = 8, fd = 558558072, user_data = 0x8214aeac0}, {pos = 558557472, events = 8, fd = 0, user_data = 0x821c21008}, {pos = 33, events = 0, fd = 558557872, user_data = 0x5cda660cae7}, {pos = 566366216, events = 8, fd = 566367240, user_data = 0x821c21808}, {pos = 566369288, events = 8, fd = 566382600, user_data = 0x821c25408}, {pos = 566384648, events = 8, fd = 566385672, user_data = 0x821c26008}, {pos = 566387720, events = 8, fd = 566388744, user_data = 0x821c26c08}, {pos = 566390792, events = 8, fd = 566391816, user_data = 0x821c27808}, {pos = 566393864, events = 8, fd = 566394888, user_data = 0x821c28408}, {pos = 566396936, events = 8, fd = 566397960, user_data = 0x821c29008}, {pos = 566400008, events = 8, fd = 566401032, user_data = 0x821c29c08}, {pos = 566403080, events = 8, fd = 566404104, user_data = 0x821c2a808}, {pos = 566406152, events = 8, fd = 566411272, user_data = 0x821c2c408}, {pos = 566413320, events = 8, fd = 566414344, user_data = 0x821c2f408}, {pos = 240821000, events = 0, fd = 566366216, user_data = 0x293d55}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821c2e038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558558072, events = 8, fd = 558557472, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 566419512, user_data = 0x1}, {pos = 566366216, events = 8, fd = 298, user_data = 0x8214aeb60}, {pos = -1503607313, events = 1485, fd = 2702677, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 566419512, user_data = 0x1}, {pos = 566395912, events = 8, fd = 913690624, user_data = 0x1}, {pos = 913691028, events = 8, fd = 0, user_data = 0x8214aeb30}, {pos = 741127532, events = 8, fd = 1, user_data = 0x83675d000}, {pos = 558558048, events = 8, fd = 741123842, user_data = 0x82c6f2170 }, {pos = 12325848, events = 0, fd = 745480560, user_data = 0x821c28408}, {pos = 558558272, events = 8, fd = -1503607842, user_data = 0x83677b800}, {pos = 1, events = 0, fd = -1503608226, user_data = 0x821c21008}, {pos = 558558056, events = 8, fd = 558558272, user_data = 0x1ab8}, {pos = 913759264, events = 8, fd = -1503528560, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8115943, user_data = 0x8214aebf0}, {pos = 741086224, events = 8, fd = 746143792, user_data = 0x82c796310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214aec20}, {pos = 741129117, events = 8, fd = 913690624, user_data = 0x3610}, {pos = 558558336, events = 8, fd = 741095674, user_data = 0x0}, {pos = 0, events = 0, fd = -1140409443, user_data = 0x0}} [00:40:20.589] last_touch_time = 1730334987 [00:40:20.589] last_lockfile_recheck_time = 1730334987 [00:40:20.589] nevents = 1 [00:40:20.589] #22 0x00000000008902b5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8214af260) at ../src/backend/postmaster/postmaster.c:1348 [00:40:20.589] userDoption = [00:40:20.589] listen_addr_saved = [00:40:20.589] output_config_variable = [00:40:20.589] opt = [00:40:20.589] status = [00:40:20.589] #23 0x00000000007ca36c in main (argc=4, argv=0x8214af260) at ../src/backend/main/main.c:196 [00:40:20.589] do_check_root =