[07:39:34.091] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [07:39:34.463] dumping /tmp/cores/postgres.10831.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:39:34.631] [New LWP 101892] [07:39:34.724] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [07:39:34.724] Program terminated with signal SIGABRT, Aborted. [07:39:34.724] Sent by thr_kill() from pid 10831 and user 1003. [07:39:34.724] #0 0x0000000829df041a in thr_kill () from /lib/libc.so.7 [07:39:35.343] [07:39:35.343] Thread 1 (LWP 101892): [07:39:35.343] #0 0x0000000829df041a in thr_kill () from /lib/libc.so.7 [07:39:35.343] No symbol table info available. [07:39:35.343] #1 0x0000000829d69e64 in raise () from /lib/libc.so.7 [07:39:35.343] No symbol table info available. [07:39:35.343] #2 0x0000000829e1a6f9 in abort () from /lib/libc.so.7 [07:39:35.343] No symbol table info available. [07:39:35.343] #3 0x0000000000a90d65 in ExceptionalCondition (conditionName=0x2e76d7 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [07:39:35.343] No locals. [07:39:35.343] #4 0x0000000000764e69 in standard_ExecutorStart (queryDesc=0x83f3c3088, eflags=0) at ../src/backend/executor/execMain.c:194 [07:39:35.343] estate = 0x83399b100 [07:39:35.343] oldcontext = 0x83f2a4800 [07:39:35.343] #5 0x00000000006fb515 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [07:39:35.343] copied_query = [07:39:35.343] rewritten = [07:39:35.343] plan = 0x8338e9bd8 [07:39:35.343] queryDesc = 0x83f3c3088 [07:39:35.343] processed = [07:39:35.343] __error = [07:39:35.343] #6 RefreshMatViewByOid (matviewOid=27417, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [07:39:35.343] dest = [07:39:35.343] save_userid = 10 [07:39:35.343] save_sec_context = 0 [07:39:35.343] processed = 0 [07:39:35.343] matviewRel = 0x83f2ccc68 [07:39:35.343] relowner = 10 [07:39:35.343] save_nestlevel = 2 [07:39:35.343] rule = [07:39:35.343] actions = [07:39:35.343] dataQuery = [07:39:35.343] tableSpace = [07:39:35.343] relpersistence = [07:39:35.343] OIDNewHeap = 27424 [07:39:35.343] address = [07:39:35.343] #7 0x00000000006fb0f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [07:39:35.343] lockmode = [07:39:35.343] matviewOid = 0 [07:39:35.343] #8 0x00000000006d26bc in ExecCreateTableAs (pstate=pstate@entry=0x83f2a4900, stmt=stmt@entry=0x8339d3fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820e78a60) at ../src/backend/commands/createas.c:350 [07:39:35.343] refresh = 0x0 [07:39:35.343] query = 0x833920718 [07:39:35.343] into = 0x833920a60 [07:39:35.343] do_refresh = false [07:39:35.343] address = [07:39:35.343] dest = [07:39:35.343] is_matview = [07:39:35.343] #9 0x000000000093d618 in ProcessUtilitySlow (pstate=pstate@entry=0x83f2a4900, pstmt=pstmt@entry=0x833843a68, queryString=queryString@entry=0x833842100 "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=0x820e78a60) at ../src/backend/tcop/utility.c:1675 [07:39:35.343] _local_sigjmp_buf = {{_sjb = {9686601, 0, 34911782536, 34911782912, 34911782544, 12375320, 0, 35419474176, 4294902655, 34911782652, 34911782688, 0}}} [07:39:35.343] _save_exception_stack = 0x820e78960 [07:39:35.343] _save_context_stack = 0x0 [07:39:35.343] _do_rethrow = false [07:39:35.343] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [07:39:35.343] parsetree = 0x8339d3fd0 [07:39:35.343] commandCollected = false [07:39:35.343] needCleanup = false [07:39:35.343] address = [07:39:35.343] isTopLevel = [07:39:35.343] isCompleteQuery = [07:39:35.343] #10 0x000000000093bf98 in standard_ProcessUtility (pstmt=0x833843a68, queryString=0x833842100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x833920f48, qc=0x820e78a60) at ../src/backend/tcop/utility.c:1030 [07:39:35.343] isAtomicContext = false [07:39:35.343] parsetree = 0x8339d3fd0 [07:39:35.343] readonly_flags = [07:39:35.343] pstate = 0x83f2a4900 [07:39:35.343] isTopLevel = [07:39:35.343] #11 0x000000000093ba28 in ProcessUtility (pstmt=0x18e04, queryString=0x6 , readOnlyTree=, context=702481402, params=0x0, queryEnv=0x0, dest=0x833920f48, qc=0x820e78a60) at ../src/backend/tcop/utility.c:523 [07:39:35.343] No locals. [07:39:35.343] #12 0x000000000093b563 in PortalRunUtility (portal=0x833919100, pstmt=0x833843a68, isTopLevel=, setHoldSnapshot=, dest=0x833920f48, qc=0x820e78a60) at ../src/backend/tcop/pquery.c:1158 [07:39:35.343] No locals. [07:39:35.343] #13 0x000000000093abf4 in PortalRunMulti (portal=portal@entry=0x833919100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x833920f48, altdest=altdest@entry=0x833920f48, qc=0x820e78a60) at ../src/backend/tcop/pquery.c:1323 [07:39:35.343] pstmt = 0x833843a68 [07:39:35.343] stmtlist_item__state = {l = 0x833920ef8, i = 0} [07:39:35.343] active_snapshot_set = false [07:39:35.343] stmtlist_item = 0x833920f10 [07:39:35.343] #14 0x000000000093a4c3 in PortalRun (portal=portal@entry=0x833919100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x833920f48, altdest=altdest@entry=0x833920f48, qc=0x820e78a60) at ../src/backend/tcop/pquery.c:791 [07:39:35.343] _local_sigjmp_buf = {{_sjb = {9675837, 35224916224, 34911783256, 34911783488, 34911783264, 35224932352, 12341992, 12375320, 35224879999, 35225675152, 4294967984, 0}}} [07:39:35.343] _save_exception_stack = 0x820e78b30 [07:39:35.343] _save_context_stack = 0x0 [07:39:35.343] _do_rethrow = false [07:39:35.343] saveTopTransactionResourceOwner = 0x83392ad98 [07:39:35.343] saveTopTransactionContext = 0x83391d000 [07:39:35.343] saveActivePortal = 0x0 [07:39:35.343] saveResourceOwner = 0x83392ad98 [07:39:35.343] savePortalContext = 0x0 [07:39:35.343] saveMemoryContext = 0x83391d000 [07:39:35.343] result = [07:39:35.343] nprocessed = [07:39:35.343] #15 0x0000000000939362 in exec_simple_query (query_string=query_string@entry=0x833842100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [07:39:35.343] cmdtaglen = 24 [07:39:35.343] snapshot_set = [07:39:35.343] per_parsetree_context = 0x0 [07:39:35.343] plantree_list = [07:39:35.343] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:39:35.343] format = 0 [07:39:35.343] parsetree = 0x8338436a8 [07:39:35.343] commandTag = [07:39:35.343] cmdtagname = [07:39:35.343] querytree_list = [07:39:35.343] portal = 0x833919100 [07:39:35.343] receiver = 0x833920f48 [07:39:35.343] parsetree_item__state = {l = 0x833843a18, i = 0} [07:39:35.343] msec_str = "\000\000\000\000\b", '\000' , ";`\366f\000\000\000\000\251a}\202\215", [07:39:35.343] dest = DestRemote [07:39:35.343] was_logged = [07:39:35.343] oldcontext = 0x83391d000 [07:39:35.343] parsetree_list = 0x833843a18 [07:39:35.343] use_implicit_block = false [07:39:35.343] parsetree_item = 0x833843a30 [07:39:35.343] save_log_statement_stats = [07:39:35.343] #16 0x0000000000936fd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [07:39:35.343] query_string = 0x833842100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [07:39:35.343] input_message = {data = 0x833842100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [07:39:35.343] firstchar = [07:39:35.343] local_sigjmp_buf = {{_sjb = {9659526, 34911783728, 34911783688, 34911784272, 12384056, 1, 8192, 8388608, 34911748991, 0, 0, 1}}} [07:39:35.343] send_ready_for_query = false [07:39:35.343] idle_in_transaction_timeout_enabled = false [07:39:35.343] idle_session_timeout_enabled = false [07:39:35.343] #17 0x00000000009317b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:39:35.343] bsdata = [07:39:35.343] #18 0x000000000088b347 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820e79874 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820e797b0) at ../src/backend/postmaster/launch_backend.c:274 [07:39:35.343] pid = [07:39:35.343] #19 0x000000000088f718 in BackendStartup (client_sock=0x820e797b0) at ../src/backend/postmaster/postmaster.c:3420 [07:39:35.343] startup_data = {canAcceptConnections = CAC_OK} [07:39:35.343] bn = 0x83384e178 [07:39:35.343] pid = [07:39:35.343] __error = [07:39:35.343] save_errno = [07:39:35.343] __error = [07:39:35.343] __error = [07:39:35.343] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [07:39:35.343] 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?\2043\b", '\000' , "\020\230\347 \b\000\000\000h\245Z)\b\000\000\000\v\000\000\000\000\000\000\000^/[)\b", '\000' , "P\230\347 \b\000\000\000\364\260\210\000\000\000\000\000`\230\347 \b", '\000' }, salen = 16}} [07:39:35.343] i = 0 [07:39:35.343] now = [07:39:35.343] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 864675288, events = 8, fd = 552048112, user_data = 0x0}, {pos = 0, events = 0, fd = -1821769892, user_data = 0x10704f85430a}, {pos = 701274016, events = 8, fd = 701345144, user_data = 0x820e79278}, {pos = 552047344, events = 8, fd = 552047224, user_data = 0x10704f85430a}, {pos = 701252488, events = 8, fd = 701345144, user_data = 0x820e792a8}, {pos = 552047392, events = 8, fd = 552047272, user_data = 0x829cd3194}, {pos = 557933576, events = 8, fd = 701313428, user_data = 0x820e79310}, {pos = 1334113338, events = 4208, fd = 703135792, user_data = 0x1}, {pos = 552047424, events = 8, fd = 1334133514, user_data = 0x829cbc858}, {pos = 701345144, events = 8, fd = 552047384, user_data = 0x820e79390}, {pos = 552047384, events = 8, fd = 701308172, user_data = 0x821416408}, {pos = 701308172, events = 8, fd = 552047488, user_data = 0x10704f84f43a}, {pos = 552047528, events = 8, fd = 552047976, user_data = 0x820e79390}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1766070422, fd = 557957176, user_data = 0x800000001}, {pos = 557933576, events = 8, fd = 701252488, user_data = 0x82141b288}, {pos = 701220952, events = 8, fd = 557933576, user_data = 0x820e79418}, {pos = 552048088, events = 8, fd = 552047616, user_data = 0x10704f853ca2}, {pos = 2701514, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 557957176, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 552048344, user_data = 0x21416408}, {pos = 552048160, events = 8, fd = 552047760, user_data = 0x1}, {pos = 552048088, events = 8, fd = 32, user_data = 0x820e79480}, {pos = 1334131315, events = 4208, fd = 552048032, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82141c038}, {pos = 1, events = 8, fd = 557933576, user_data = 0x829cbc858}, {pos = 552048344, events = 8, fd = 552048160, user_data = 0x820e79490}, {pos = 0, events = 0, fd = 557903880, user_data = 0x20}, {pos = 552048144, events = 8, fd = 1334106855, user_data = 0x82140f008}, {pos = 557904904, events = 8, fd = 557905928, user_data = 0x82140fc08}, {pos = 557920264, events = 8, fd = 557921288, user_data = 0x821413808}, {pos = 557923336, events = 8, fd = 557924360, user_data = 0x821414408}, {pos = 557926408, events = 8, fd = 557927432, user_data = 0x821415008}, {pos = 557929480, events = 8, fd = 557930504, user_data = 0x821415c08}, {pos = 557932552, events = 8, fd = 557933576, user_data = 0x821416808}, {pos = 557935624, events = 8, fd = 557936648, user_data = 0x821417408}, {pos = 557938696, events = 8, fd = 557939720, user_data = 0x821418008}, {pos = 557941768, events = 8, fd = 557942792, user_data = 0x821418c08}, {pos = 557948936, events = 8, fd = 557949960, user_data = 0x82141a808}, {pos = 557952008, events = 8, fd = 557903880, user_data = 0x2938ca}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82141c038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552048344, events = 8, fd = 552047760, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 557957176, user_data = 0x1}, {pos = 557903880, events = 8, fd = 313, user_data = 0x820e796c0}, {pos = 1334105583, events = 4208, fd = 2701514, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 557957176, user_data = 0x1}, {pos = 557933576, events = 8, fd = 864231424, user_data = 0x1}, {pos = 864231828, events = 8, fd = 0, user_data = 0x820e79690}, {pos = 693839212, events = 8, fd = 1, user_data = 0x833832000}, {pos = 552048320, events = 8, fd = 693835522, user_data = 0x829dee170 }, {pos = 12304992, events = 0, fd = 702472560, user_data = 0x821416408}, {pos = 552048544, events = 8, fd = 1334105054, user_data = 0x833850800}, {pos = 1, events = 0, fd = 1334104670, user_data = 0x82140f008}, {pos = 552048328, events = 8, fd = 552048544, user_data = 0x1c20}, {pos = 864304896, events = 8, fd = 1334184336, user_data = 0x0}, {pos = 552010623, events = 8, fd = 8107623, user_data = 0x820e79750}, {pos = 693797904, events = 8, fd = 703135792, user_data = 0x829e92310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820e79780}, {pos = 693840797, events = 8, fd = 864231424, user_data = 0x1db6}, {pos = 552048608, events = 8, fd = 693807354, user_data = 0x0}, {pos = 0, events = 0, fd = -1821769892, user_data = 0x0}} [07:39:35.344] last_touch_time = 1727422502 [07:39:35.344] last_lockfile_recheck_time = 1727422502 [07:39:35.344] nevents = 1 [07:39:35.344] #21 0x000000000088d535 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820e79dc8) at ../src/backend/postmaster/postmaster.c:1351 [07:39:35.344] userDoption = [07:39:35.344] listen_addr_saved = [07:39:35.344] output_config_variable = [07:39:35.344] opt = [07:39:35.344] status = [07:39:35.344] #22 0x00000000007c834c in main (argc=8, argv=0x820e79dc8) at ../src/backend/main/main.c:197 [07:39:35.344] do_check_root = [07:39:35.358] [07:39:35.358] [07:39:35.358] [07:39:35.424] dumping /tmp/cores/postgres.11065.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:39:35.545] [New LWP 101894] [07:39:35.613] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [07:39:35.613] Program terminated with signal SIGABRT, Aborted. [07:39:35.613] Sent by thr_kill() from pid 11065 and user 1003. [07:39:35.613] #0 0x000000082bf3041a in thr_kill () from /lib/libc.so.7 [07:39:36.204] [07:39:36.204] Thread 1 (LWP 101894): [07:39:36.204] #0 0x000000082bf3041a in thr_kill () from /lib/libc.so.7 [07:39:36.204] No symbol table info available. [07:39:36.204] #1 0x000000082bea9e64 in raise () from /lib/libc.so.7 [07:39:36.204] No symbol table info available. [07:39:36.204] #2 0x000000082bf5a6f9 in abort () from /lib/libc.so.7 [07:39:36.204] No symbol table info available. [07:39:36.204] #3 0x0000000000a90d65 in ExceptionalCondition (conditionName=0x2e76d7 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [07:39:36.204] No locals. [07:39:36.204] #4 0x0000000000764e69 in standard_ExecutorStart (queryDesc=0x835e78088, eflags=0) at ../src/backend/executor/execMain.c:194 [07:39:36.204] estate = 0x8416c9100 [07:39:36.204] oldcontext = 0x835f96800 [07:39:36.204] #5 0x00000000006fb515 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [07:39:36.204] copied_query = [07:39:36.204] rewritten = [07:39:36.204] plan = 0x835eddbd8 [07:39:36.204] queryDesc = 0x835e78088 [07:39:36.204] processed = [07:39:36.204] __error = [07:39:36.204] #6 RefreshMatViewByOid (matviewOid=27254, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [07:39:36.204] dest = [07:39:36.204] save_userid = 10 [07:39:36.204] save_sec_context = 0 [07:39:36.204] processed = 0 [07:39:36.204] matviewRel = 0x84167af60 [07:39:36.204] relowner = 10 [07:39:36.204] save_nestlevel = 2 [07:39:36.204] rule = [07:39:36.204] actions = [07:39:36.204] dataQuery = [07:39:36.204] tableSpace = [07:39:36.204] relpersistence = [07:39:36.204] OIDNewHeap = 27261 [07:39:36.204] address = [07:39:36.204] #7 0x00000000006fb0f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [07:39:36.204] lockmode = [07:39:36.204] matviewOid = 0 [07:39:36.204] #8 0x00000000006d26bc in ExecCreateTableAs (pstate=pstate@entry=0x835f96900, stmt=stmt@entry=0x835ee0fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820c8e2d0) at ../src/backend/commands/createas.c:350 [07:39:36.204] refresh = 0x0 [07:39:36.204] query = 0x835ee9158 [07:39:36.204] into = 0x835ee94a0 [07:39:36.204] do_refresh = false [07:39:36.204] address = [07:39:36.204] dest = [07:39:36.204] is_matview = [07:39:36.204] #9 0x000000000093d618 in ProcessUtilitySlow (pstate=pstate@entry=0x835f96900, pstmt=pstmt@entry=0x835e01a68, queryString=queryString@entry=0x835e00100 "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=0x820c8e2d0) at ../src/backend/tcop/utility.c:1675 [07:39:36.204] _local_sigjmp_buf = {{_sjb = {9686601, 0, 34909773560, 34909773936, 34909773568, 12375320, 0, 35265276160, 4294902655, 34909773676, 34909773712, 0}}} [07:39:36.204] _save_exception_stack = 0x820c8e1d0 [07:39:36.204] _save_context_stack = 0x0 [07:39:36.204] _do_rethrow = false [07:39:36.204] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [07:39:36.204] parsetree = 0x835ee0fd0 [07:39:36.204] commandCollected = false [07:39:36.204] needCleanup = false [07:39:36.204] address = [07:39:36.204] isTopLevel = [07:39:36.204] isCompleteQuery = [07:39:36.204] #10 0x000000000093bf98 in standard_ProcessUtility (pstmt=0x835e01a68, queryString=0x835e00100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835ee9988, qc=0x820c8e2d0) at ../src/backend/tcop/utility.c:1030 [07:39:36.204] isAtomicContext = false [07:39:36.204] parsetree = 0x835ee0fd0 [07:39:36.204] readonly_flags = [07:39:36.204] pstate = 0x835f96900 [07:39:36.204] isTopLevel = [07:39:36.204] #11 0x000000000093ba28 in ProcessUtility (pstmt=0x18e06, queryString=0x6 , readOnlyTree=, context=737346554, params=0x0, queryEnv=0x0, dest=0x835ee9988, qc=0x820c8e2d0) at ../src/backend/tcop/utility.c:523 [07:39:36.204] No locals. [07:39:36.204] #12 0x000000000093b563 in PortalRunUtility (portal=0x835ea6100, pstmt=0x835e01a68, isTopLevel=, setHoldSnapshot=, dest=0x835ee9988, qc=0x820c8e2d0) at ../src/backend/tcop/pquery.c:1158 [07:39:36.204] No locals. [07:39:36.204] #13 0x000000000093abf4 in PortalRunMulti (portal=portal@entry=0x835ea6100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835ee9988, altdest=altdest@entry=0x835ee9988, qc=0x820c8e2d0) at ../src/backend/tcop/pquery.c:1323 [07:39:36.204] pstmt = 0x835e01a68 [07:39:36.204] stmtlist_item__state = {l = 0x835ee9938, i = 0} [07:39:36.204] active_snapshot_set = false [07:39:36.204] stmtlist_item = 0x835ee9950 [07:39:36.204] #14 0x000000000093a4c3 in PortalRun (portal=portal@entry=0x835ea6100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835ee9988, altdest=altdest@entry=0x835ee9988, qc=0x820c8e2d0) at ../src/backend/tcop/pquery.c:791 [07:39:36.204] _local_sigjmp_buf = {{_sjb = {9675837, 35264291072, 34909774280, 34909774512, 34909774288, 35264307200, 12341992, 12375320, 35264267135, 35264525712, 4294967984, 0}}} [07:39:36.204] _save_exception_stack = 0x820c8e3a0 [07:39:36.204] _save_context_stack = 0x0 [07:39:36.204] _do_rethrow = false [07:39:36.204] saveTopTransactionResourceOwner = 0x835ef5d18 [07:39:36.204] saveTopTransactionContext = 0x835eaa000 [07:39:36.204] saveActivePortal = 0x0 [07:39:36.204] saveResourceOwner = 0x835ef5d18 [07:39:36.204] savePortalContext = 0x0 [07:39:36.204] saveMemoryContext = 0x835eaa000 [07:39:36.204] result = [07:39:36.204] nprocessed = [07:39:36.204] #15 0x0000000000939362 in exec_simple_query (query_string=query_string@entry=0x835e00100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [07:39:36.204] cmdtaglen = 24 [07:39:36.204] snapshot_set = [07:39:36.204] per_parsetree_context = 0x0 [07:39:36.204] plantree_list = [07:39:36.204] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:39:36.204] format = 0 [07:39:36.204] parsetree = 0x835e016a8 [07:39:36.204] commandTag = [07:39:36.204] cmdtagname = [07:39:36.204] querytree_list = [07:39:36.204] portal = 0x835ea6100 [07:39:36.204] receiver = 0x835ee9988 [07:39:36.204] parsetree_item__state = {l = 0x835e01a18, i = 0} [07:39:36.204] msec_str = "\000\000\000\000\b", '\000' , ">`\366f\000\000\000\0005J^\023\230\323~\a" [07:39:36.204] dest = DestRemote [07:39:36.204] was_logged = [07:39:36.204] oldcontext = 0x835eaa000 [07:39:36.204] parsetree_list = 0x835e01a18 [07:39:36.204] use_implicit_block = false [07:39:36.204] parsetree_item = 0x835e01a30 [07:39:36.204] save_log_statement_stats = [07:39:36.204] #16 0x0000000000936fd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [07:39:36.204] query_string = 0x835e00100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [07:39:36.204] input_message = {data = 0x835e00100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [07:39:36.204] firstchar = [07:39:36.204] local_sigjmp_buf = {{_sjb = {9659526, 34909774752, 34909774712, 34909775296, 12384056, 1, 8192, 8388608, 34909717375, 0, 0, 1}}} [07:39:36.204] send_ready_for_query = false [07:39:36.204] idle_in_transaction_timeout_enabled = false [07:39:36.204] idle_session_timeout_enabled = false [07:39:36.204] #17 0x00000000009317b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:39:36.204] bsdata = [07:39:36.204] #18 0x000000000088b347 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820c8f0e4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820c8f020) at ../src/backend/postmaster/launch_backend.c:274 [07:39:36.204] pid = [07:39:36.204] #19 0x000000000088f718 in BackendStartup (client_sock=0x820c8f020) at ../src/backend/postmaster/postmaster.c:3420 [07:39:36.204] startup_data = {canAcceptConnections = CAC_OK} [07:39:36.204] bn = 0x835e0c268 [07:39:36.204] pid = [07:39:36.204] __error = [07:39:36.204] save_errno = [07:39:36.204] __error = [07:39:36.204] __error = [07:39:36.204] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [07:39:36.204] 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\3405\b", '\000' , "\200\360\310 \b\000\000\000hup*\b\000\000\000\v\000\000\000\000\000\000\000^\377p*\b", '\000' , "\300\360\310 \b\000\000\000\364\260\210\000\000\000\000\000\320\360\310 \b", '\000' }, salen = 16}} [07:39:36.204] i = 0 [07:39:36.204] now = [07:39:36.204] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 736971906, events = 8, fd = 0, user_data = 0x820c8efd0}, {pos = 904308184, events = 8, fd = 550039136, user_data = 0x0}, {pos = 0, events = 0, fd = 1654453446, user_data = 0x18864be2930a}, {pos = 736139168, events = 8, fd = 736210296, user_data = 0x820c8eae8}, {pos = 550038368, events = 8, fd = 550038248, user_data = 0x18864be2930a}, {pos = 736117640, events = 8, fd = 736210296, user_data = 0x820c8eb18}, {pos = 550038416, events = 8, fd = 550038296, user_data = 0x82be13194}, {pos = 559145992, events = 8, fd = 736178580, user_data = 0x820c8eb80}, {pos = 1273119802, events = 6278, fd = 738000944, user_data = 0x1}, {pos = 550038448, events = 8, fd = 1273139978, user_data = 0x82bdfc858}, {pos = 736210296, events = 8, fd = 550038408, user_data = 0x820c8ec00}, {pos = 550038408, events = 8, fd = 736173324, user_data = 0x82153e408}, {pos = 736173324, events = 8, fd = 550038512, user_data = 0x18864be2443a}, {pos = 550038552, events = 8, fd = 550039000, user_data = 0x820c8ec00}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3423178892, fd = 559169592, user_data = 0x800000001}, {pos = 559145992, events = 8, fd = 736117640, user_data = 0x821543288}, {pos = 736086104, events = 8, fd = 559145992, user_data = 0x820c8ec88}, {pos = 550039112, events = 8, fd = 550038640, user_data = 0x18864be28ca2}, {pos = 2701514, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 559169592, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550039368, user_data = 0x2153e408}, {pos = 550039184, events = 8, fd = 550038784, user_data = 0x1}, {pos = 550039112, events = 8, fd = 32, user_data = 0x820c8ecf0}, {pos = 1273137779, events = 6278, fd = 550039056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821544038}, {pos = 1, events = 8, fd = 559145992, user_data = 0x82bdfc858}, {pos = 550039368, events = 8, fd = 550039184, user_data = 0x820c8ed00}, {pos = 0, events = 0, fd = 559116296, user_data = 0x20}, {pos = 550039168, events = 8, fd = 1273113319, user_data = 0x821537008}, {pos = 559117320, events = 8, fd = 559118344, user_data = 0x821537c08}, {pos = 559132680, events = 8, fd = 559133704, user_data = 0x82153b808}, {pos = 559135752, events = 8, fd = 559136776, user_data = 0x82153c408}, {pos = 559138824, events = 8, fd = 559139848, user_data = 0x82153d008}, {pos = 559141896, events = 8, fd = 559142920, user_data = 0x82153dc08}, {pos = 559144968, events = 8, fd = 559145992, user_data = 0x82153e808}, {pos = 559148040, events = 8, fd = 559149064, user_data = 0x82153f408}, {pos = 559151112, events = 8, fd = 559152136, user_data = 0x821540008}, {pos = 559154184, events = 8, fd = 559155208, user_data = 0x821540c08}, {pos = 559161352, events = 8, fd = 559162376, user_data = 0x821542808}, {pos = 559164424, events = 8, fd = 559116296, user_data = 0x2938ca}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821544038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550039368, events = 8, fd = 550038784, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 559169592, user_data = 0x1}, {pos = 559116296, events = 8, fd = 313, user_data = 0x820c8ef30}, {pos = 1273112047, events = 6278, fd = 2701514, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 559169592, user_data = 0x1}, {pos = 559145992, events = 8, fd = 903806976, user_data = 0x1}, {pos = 903807380, events = 8, fd = 0, user_data = 0x820c8ef00}, {pos = 712045932, events = 8, fd = 1, user_data = 0x835df0000}, {pos = 550039344, events = 8, fd = 712042242, user_data = 0x82bf2e170 }, {pos = 12304992, events = 0, fd = 737337712, user_data = 0x82153e408}, {pos = 550039568, events = 8, fd = 1273111518, user_data = 0x835e0e800}, {pos = 1, events = 0, fd = 1273111134, user_data = 0x821537008}, {pos = 550039352, events = 8, fd = 550039568, user_data = 0x1c20}, {pos = 903880384, events = 8, fd = 1273190800, user_data = 0x0}, {pos = 549979007, events = 8, fd = 8107623, user_data = 0x820c8efc0}, {pos = 712004624, events = 8, fd = 738000944, user_data = 0x82bfd2310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820c8eff0}, {pos = 712047517, events = 8, fd = 903806976, user_data = 0x1e13}, {pos = 550039632, events = 8, fd = 712014074, user_data = 0x0}, {pos = 0, events = 0, fd = 1654453446, user_data = 0x0}} [07:39:36.204] last_touch_time = 1727422503 [07:39:36.204] last_lockfile_recheck_time = 1727422503 [07:39:36.204] nevents = 1 [07:39:36.204] #21 0x000000000088d535 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820c8f630) at ../src/backend/postmaster/postmaster.c:1351 [07:39:36.204] userDoption = [07:39:36.204] listen_addr_saved = [07:39:36.204] output_config_variable = [07:39:36.204] opt = [07:39:36.204] status = [07:39:36.204] #22 0x00000000007c834c in main (argc=4, argv=0x820c8f630) at ../src/backend/main/main.c:197 [07:39:36.204] do_check_root = [07:39:36.217] [07:39:36.217] [07:39:36.217] [07:39:36.282] dumping /tmp/cores/postgres.17694.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:39:36.404] [New LWP 101806] [07:39:36.472] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [07:39:36.472] Program terminated with signal SIGABRT, Aborted. [07:39:36.472] Sent by thr_kill() from pid 17694 and user 1003. [07:39:36.472] #0 0x000000082d53b41a in thr_kill () from /lib/libc.so.7 [07:39:37.076] [07:39:37.076] Thread 1 (LWP 101806): [07:39:37.076] #0 0x000000082d53b41a in thr_kill () from /lib/libc.so.7 [07:39:37.076] No symbol table info available. [07:39:37.076] #1 0x000000082d4b4e64 in raise () from /lib/libc.so.7 [07:39:37.076] No symbol table info available. [07:39:37.076] #2 0x000000082d5656f9 in abort () from /lib/libc.so.7 [07:39:37.076] No symbol table info available. [07:39:37.076] #3 0x0000000000a90d65 in ExceptionalCondition (conditionName=0x2e76d7 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [07:39:37.076] No locals. [07:39:37.076] #4 0x0000000000764e69 in standard_ExecutorStart (queryDesc=0x8372c0088, eflags=0) at ../src/backend/executor/execMain.c:194 [07:39:37.076] estate = 0x83726a100 [07:39:37.076] oldcontext = 0x83d048800 [07:39:37.076] #5 0x00000008394c2862 in pgss_ExecutorStart (queryDesc=0x8372c0088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [07:39:37.076] No locals. [07:39:37.076] #6 0x00000000006fb515 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [07:39:37.076] copied_query = [07:39:37.076] rewritten = [07:39:37.076] plan = 0x8372b0bd8 [07:39:37.076] queryDesc = 0x8372c0088 [07:39:37.076] processed = [07:39:37.076] __error = [07:39:37.076] #7 RefreshMatViewByOid (matviewOid=27246, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [07:39:37.076] dest = [07:39:37.076] save_userid = 10 [07:39:37.076] save_sec_context = 0 [07:39:37.076] processed = 0 [07:39:37.076] matviewRel = 0x83d005f88 [07:39:37.076] relowner = 10 [07:39:37.076] save_nestlevel = 2 [07:39:37.076] rule = [07:39:37.076] actions = [07:39:37.076] dataQuery = [07:39:37.076] tableSpace = [07:39:37.076] relpersistence = [07:39:37.076] OIDNewHeap = 27253 [07:39:37.076] address = [07:39:37.076] #8 0x00000000006fb0f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [07:39:37.076] lockmode = [07:39:37.076] matviewOid = 0 [07:39:37.076] #9 0x00000000006d26bc in ExecCreateTableAs (pstate=pstate@entry=0x83d048900, stmt=stmt@entry=0x8371c9fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8219ffc40) at ../src/backend/commands/createas.c:350 [07:39:37.076] refresh = 0x0 [07:39:37.076] query = 0x837214a08 [07:39:37.076] into = 0x8371c9f40 [07:39:37.076] do_refresh = false [07:39:37.076] address = [07:39:37.076] dest = [07:39:37.076] is_matview = [07:39:37.076] #10 0x000000000093d618 in ProcessUtilitySlow (pstate=pstate@entry=0x83d048900, pstmt=pstmt@entry=0x8371c9e30, queryString=queryString@entry=0x83712c100 "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=0x8219ffc40) at ../src/backend/tcop/utility.c:1675 [07:39:37.076] _local_sigjmp_buf = {{_sjb = {9686601, 0, 34923869864, 34923870240, 34923869872, 12375320, 0, 35383445760, 34923807615, 7, 34923870016, 0}}} [07:39:37.076] _save_exception_stack = 0x8219ff930 [07:39:37.076] _save_context_stack = 0x0 [07:39:37.076] _do_rethrow = false [07:39:37.076] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [07:39:37.076] parsetree = 0x8371c9fd0 [07:39:37.076] commandCollected = false [07:39:37.076] needCleanup = false [07:39:37.076] address = [07:39:37.076] isTopLevel = [07:39:37.076] isCompleteQuery = [07:39:37.076] #11 0x000000000093bf98 in standard_ProcessUtility (pstmt=0x8371c9e30, queryString=queryString@entry=0x83712c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8372151a8, qc=0x8219ffc40) at ../src/backend/tcop/utility.c:1030 [07:39:37.076] isAtomicContext = false [07:39:37.076] parsetree = 0x8371c9fd0 [07:39:37.076] readonly_flags = [07:39:37.076] pstate = 0x83d048900 [07:39:37.076] isTopLevel = [07:39:37.076] #12 0x00000008394c2dee in pgss_ProcessUtility (pstmt=0x8371c9e30, queryString=0x83712c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8372151a8, qc=0x8219ffc40) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [07:39:37.076] _local_sigjmp_buf = {{_sjb = {35321031975, 34923870512, 34923870376, 34923870832, 35284360752, 0, 12375320, 34923871040, 34923807615, 34923870612, 34923870640, 0}}} [07:39:37.076] _save_exception_stack = 0x8219ffb40 [07:39:37.076] _save_context_stack = 0x0 [07:39:37.076] _do_rethrow = false [07:39:37.076] bufusage = {shared_blks_hit = 35321031975, shared_blks_read = 34923870512, shared_blks_dirtied = 34923870376, shared_blks_written = 34923870832, local_blks_hit = 35284360752, local_blks_read = 0, local_blks_dirtied = 12375320, local_blks_written = 34923871040, temp_blks_read = 34923807615, temp_blks_written = 34923870612, shared_blk_read_time = {ticks = 34923870640}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4259205685597358336}, local_blk_write_time = {ticks = 12384360}, temp_blk_read_time = {ticks = 35355597056}, temp_blk_write_time = {ticks = 12337936}} [07:39:37.076] walusage_start = {wal_records = 8943, wal_fpi = 133, wal_bytes = 1209510} [07:39:37.076] duration = [07:39:37.076] bufusage_start = {shared_blks_hit = 151490, shared_blks_read = 8751, shared_blks_dirtied = 2773, shared_blks_written = 2291, local_blks_hit = 45, local_blks_read = 0, local_blks_dirtied = 10, local_blks_written = 17, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [07:39:37.076] walusage = {wal_records = -7153181702722003377, wal_fpi = 35284361168, wal_bytes = 123} [07:39:37.076] start = {ticks = -188919926516} [07:39:37.076] rows = [07:39:37.076] saved_queryId = 6041762721901209185 [07:39:37.076] parsetree = [07:39:37.076] saved_stmt_location = 0 [07:39:37.076] saved_stmt_len = 69 [07:39:37.076] enabled = [07:39:37.076] #13 0x000000000093b563 in PortalRunUtility (portal=0x8371d4100, pstmt=0x8371c9e30, isTopLevel=, setHoldSnapshot=, dest=0x8372151a8, qc=0x8219ffc40) at ../src/backend/tcop/pquery.c:1158 [07:39:37.076] No locals. [07:39:37.076] #14 0x000000000093abf4 in PortalRunMulti (portal=portal@entry=0x8371d4100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8372151a8, altdest=altdest@entry=0x8372151a8, qc=0x8219ffc40) at ../src/backend/tcop/pquery.c:1323 [07:39:37.076] pstmt = 0x8371c9e30 [07:39:37.076] stmtlist_item__state = {l = 0x837215158, i = 0} [07:39:37.076] active_snapshot_set = false [07:39:37.076] stmtlist_item = 0x837215170 [07:39:37.076] #15 0x000000000093a4c3 in PortalRun (portal=portal@entry=0x8371d4100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8372151a8, altdest=altdest@entry=0x8372151a8, qc=0x8219ffc40) at ../src/backend/tcop/pquery.c:791 [07:39:37.076] _local_sigjmp_buf = {{_sjb = {9675837, 35284402432, 34923871032, 34923871264, 34923871040, 35284496384, 12341992, 12375320, 35284386687, 35284354528, 4294967984, 0}}} [07:39:37.076] _save_exception_stack = 0x8219ffd10 [07:39:37.076] _save_context_stack = 0x0 [07:39:37.076] _do_rethrow = false [07:39:37.076] saveTopTransactionResourceOwner = 0x837222a98 [07:39:37.076] saveTopTransactionContext = 0x8371eb000 [07:39:37.076] saveActivePortal = 0x0 [07:39:37.076] saveResourceOwner = 0x837222a98 [07:39:37.076] savePortalContext = 0x0 [07:39:37.076] saveMemoryContext = 0x8371eb000 [07:39:37.076] result = [07:39:37.076] nprocessed = [07:39:37.076] #16 0x0000000000939362 in exec_simple_query (query_string=query_string@entry=0x83712c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [07:39:37.076] cmdtaglen = 24 [07:39:37.076] snapshot_set = [07:39:37.076] per_parsetree_context = 0x0 [07:39:37.076] plantree_list = [07:39:37.076] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:39:37.076] format = 0 [07:39:37.076] parsetree = 0x83712d6a8 [07:39:37.076] commandTag = [07:39:37.076] cmdtagname = [07:39:37.076] querytree_list = [07:39:37.076] portal = 0x8371d4100 [07:39:37.076] receiver = 0x8372151a8 [07:39:37.076] parsetree_item__state = {l = 0x83712da18, i = 0} [07:39:37.076] msec_str = "\000\000\000\000\b", '\000' , "b`\366f\000\000\000\000\253\"\000\214\235\271\034(" [07:39:37.076] dest = DestRemote [07:39:37.076] was_logged = [07:39:37.076] oldcontext = 0x8371eb000 [07:39:37.076] parsetree_list = 0x83712da18 [07:39:37.076] use_implicit_block = false [07:39:37.076] parsetree_item = 0x83712da30 [07:39:37.076] save_log_statement_stats = [07:39:37.076] #17 0x0000000000936fd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [07:39:37.076] query_string = 0x83712c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [07:39:37.076] input_message = {data = 0x83712c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [07:39:37.076] firstchar = [07:39:37.076] local_sigjmp_buf = {{_sjb = {9659526, 34923871504, 34923871464, 34923872048, 12384056, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [07:39:37.076] send_ready_for_query = false [07:39:37.076] idle_in_transaction_timeout_enabled = false [07:39:37.076] idle_session_timeout_enabled = false [07:39:37.076] #18 0x00000000009317b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:39:37.076] bsdata = [07:39:37.076] #19 0x000000000088b347 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a00a54 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a00990) at ../src/backend/postmaster/launch_backend.c:274 [07:39:37.076] pid = [07:39:37.076] #20 0x000000000088f718 in BackendStartup (client_sock=0x821a00990) at ../src/backend/postmaster/postmaster.c:3420 [07:39:37.076] startup_data = {canAcceptConnections = CAC_OK} [07:39:37.076] bn = 0x837138128 [07:39:37.076] pid = [07:39:37.076] __error = [07:39:37.076] save_errno = [07:39:37.076] __error = [07:39:37.076] __error = [07:39:37.076] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [07:39:37.076] 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 = " \314\0227\b", '\000' , "\360\t\240!\b\000\000\000h\025\356+\b\000\000\000\v\000\000\000\000\000\000\000^\237\356+\b", '\000' , "0\n\240!\b\000\000\000\364\260\210\000\000\000\000\000@\n\240!\b", '\000' }, salen = 16}} [07:39:37.076] i = 0 [07:39:37.076] now = [07:39:37.076] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 760085634, events = 8, fd = 0, user_data = 0x821a00940}, {pos = 924382680, events = 8, fd = 564135888, user_data = 0x0}, {pos = 79954698, events = 16149, fd = 759252896, user_data = 0x82d425d78}, {pos = 564134984, events = 8, fd = 564135104, user_data = 0x821a00448}, {pos = 79954698, events = 16149, fd = 759231368, user_data = 0x82d425d78}, {pos = 564135032, events = 8, fd = 564135152, user_data = 0x821a00478}, {pos = 759292308, events = 8, fd = 569164808, user_data = 0x82d41e194}, {pos = 564135136, events = 8, fd = 79934522, user_data = 0x821a00480}, {pos = 737014800, events = 8, fd = 761114672, user_data = 0x3f1504c4030a}, {pos = 759199832, events = 8, fd = 759324024, user_data = 0x821a004e8}, {pos = 564135264, events = 8, fd = 564135144, user_data = 0x82d41cd0c}, {pos = 569164808, events = 8, fd = 759287052, user_data = 0x821a00550}, {pos = 79934522, events = 16149, fd = 564135288, user_data = 0x821a00748}, {pos = 564135264, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821ed2038}, {pos = 1, events = 2629487395, fd = 569164808, user_data = 0x82d40f388}, {pos = 569186248, events = 8, fd = 0, user_data = 0x0}, {pos = 564135400, events = 8, fd = 564135864, user_data = 0x821a005d0}, {pos = 79953058, events = 16149, fd = 2701514, user_data = 0x6d68b}, {pos = 2090263927, events = 2629487395, fd = 569188408, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821a008b8}, {pos = 569164808, events = 3, fd = 564135936, user_data = 0x821ed1828}, {pos = 656, events = 0, fd = 564135864, user_data = 0x821a005e8}, {pos = 564135504, events = 8, fd = 79952667, user_data = 0x821a00780}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 569188408, events = 8, fd = 1, user_data = 0x821ecc408}, {pos = 759199832, events = 8, fd = 564136120, user_data = 0x821a00800}, {pos = 564135520, events = 8, fd = 0, user_data = 0x821ec5008}, {pos = 33, events = 0, fd = 564135920, user_data = 0x3f1504c39ae7}, {pos = 569135112, events = 8, fd = 569136136, user_data = 0x821ec5808}, {pos = 569138184, events = 8, fd = 569151496, user_data = 0x821ec9408}, {pos = 569153544, events = 8, fd = 569154568, user_data = 0x821eca008}, {pos = 569156616, events = 8, fd = 569157640, user_data = 0x821ecac08}, {pos = 569159688, events = 8, fd = 569160712, user_data = 0x821ecb808}, {pos = 569162760, events = 8, fd = 569163784, user_data = 0x821ecc408}, {pos = 569165832, events = 8, fd = 569166856, user_data = 0x821ecd008}, {pos = 569168904, events = 8, fd = 569169928, user_data = 0x821ecdc08}, {pos = 569171976, events = 8, fd = 569173000, user_data = 0x821ece808}, {pos = 569175048, events = 8, fd = 569180168, user_data = 0x821ed0408}, {pos = 569182216, events = 8, fd = 569183240, user_data = 0x821ed3408}, {pos = 848231000, events = 0, fd = 569135112, user_data = 0x2938ca}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821ed2038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564136120, events = 8, fd = 564135520, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 569188408, user_data = 0x1}, {pos = 569135112, events = 8, fd = 313, user_data = 0x821a008a0}, {pos = 79926767, events = 16149, fd = 2701514, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 569188408, user_data = 0x1}, {pos = 569164808, events = 8, fd = 923910144, user_data = 0x1}, {pos = 923910548, events = 8, fd = 0, user_data = 0x821a00870}, {pos = 737056108, events = 8, fd = 1, user_data = 0x83711c000}, {pos = 564136096, events = 8, fd = 737052418, user_data = 0x82d539170 }, {pos = 12304992, events = 0, fd = 760451440, user_data = 0x821ecc408}, {pos = 564136320, events = 8, fd = 79926238, user_data = 0x83713a800}, {pos = 1, events = 0, fd = 79925854, user_data = 0x821ec5008}, {pos = 564136104, events = 8, fd = 564136320, user_data = 0x1c20}, {pos = 923978784, events = 8, fd = 80005520, user_data = 0x0}, {pos = 564134783, events = 8, fd = 8107623, user_data = 0x821a00930}, {pos = 737014800, events = 8, fd = 761114672, user_data = 0x82d5dd310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a00960}, {pos = 737057693, events = 8, fd = 923910144, user_data = 0x3676}, {pos = 564136384, events = 8, fd = 737024250, user_data = 0x0}, {pos = 0, events = 0, fd = -76652977, user_data = 0x0}} [07:39:37.076] last_touch_time = 1727422537 [07:39:37.076] last_lockfile_recheck_time = 1727422537 [07:39:37.076] nevents = 1 [07:39:37.076] #22 0x000000000088d535 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a00fa8) at ../src/backend/postmaster/postmaster.c:1351 [07:39:37.076] userDoption = [07:39:37.076] listen_addr_saved = [07:39:37.076] output_config_variable = [07:39:37.076] opt = [07:39:37.076] status = [07:39:37.076] #23 0x00000000007c834c in main (argc=4, argv=0x821a00fa8) at ../src/backend/main/main.c:197 [07:39:37.076] do_check_root =