[06:18:01.826] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [06:18:02.185] dumping /tmp/cores/postgres.10831.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [06:18:02.312] [New LWP 101815] [06:18:02.398] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [06:18:02.398] Program terminated with signal SIGABRT, Aborted. [06:18:02.398] Sent by thr_kill() from pid 10831 and user 1003. [06:18:02.398] #0 0x000000082a79a41a in thr_kill () from /lib/libc.so.7 [06:18:03.028] [06:18:03.028] Thread 1 (LWP 101815): [06:18:03.028] #0 0x000000082a79a41a in thr_kill () from /lib/libc.so.7 [06:18:03.028] No symbol table info available. [06:18:03.028] #1 0x000000082a713e64 in raise () from /lib/libc.so.7 [06:18:03.028] No symbol table info available. [06:18:03.028] #2 0x000000082a7c46f9 in abort () from /lib/libc.so.7 [06:18:03.028] No symbol table info available. [06:18:03.028] #3 0x0000000000a8f945 in ExceptionalCondition (conditionName=0x2e748e "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:18:03.028] No locals. [06:18:03.028] #4 0x0000000000764509 in standard_ExecutorStart (queryDesc=0x8344b1088, eflags=0) at ../src/backend/executor/execMain.c:194 [06:18:03.028] estate = 0x83454f100 [06:18:03.028] oldcontext = 0x834577800 [06:18:03.028] #5 0x00000000006fac35 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [06:18:03.028] copied_query = [06:18:03.028] rewritten = [06:18:03.028] plan = 0x834579bd8 [06:18:03.028] queryDesc = 0x8344b1088 [06:18:03.028] processed = [06:18:03.028] __error = [06:18:03.028] #6 RefreshMatViewByOid (matviewOid=27135, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [06:18:03.028] dest = [06:18:03.028] save_userid = 10 [06:18:03.028] save_sec_context = 0 [06:18:03.028] processed = 0 [06:18:03.028] matviewRel = 0x837107198 [06:18:03.028] relowner = 10 [06:18:03.028] save_nestlevel = 2 [06:18:03.028] rule = [06:18:03.028] actions = [06:18:03.028] dataQuery = [06:18:03.028] tableSpace = [06:18:03.028] relpersistence = [06:18:03.028] OIDNewHeap = 27142 [06:18:03.028] address = [06:18:03.028] #7 0x00000000006fa816 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:18:03.028] lockmode = [06:18:03.028] matviewOid = 0 [06:18:03.028] #8 0x00000000006d211c in ExecCreateTableAs (pstate=pstate@entry=0x834577900, stmt=stmt@entry=0x834498fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8215c2560) at ../src/backend/commands/createas.c:350 [06:18:03.028] refresh = 0x0 [06:18:03.028] query = 0x83723ec18 [06:18:03.028] into = 0x83723ef60 [06:18:03.028] do_refresh = false [06:18:03.028] address = [06:18:03.028] dest = [06:18:03.028] is_matview = [06:18:03.028] #9 0x000000000093c4c8 in ProcessUtilitySlow (pstate=pstate@entry=0x834577900, pstmt=pstmt@entry=0x8343f7a68, queryString=queryString@entry=0x8343f6100 "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=0x8215c2560) at ../src/backend/tcop/utility.c:1675 [06:18:03.028] _local_sigjmp_buf = {{_sjb = {9682169, 0, 34919424392, 34919424768, 34919424400, 12365960, 0, 35237886208, 4294902655, 34919424508, 34919424544, 0}}} [06:18:03.028] _save_exception_stack = 0x8215c2460 [06:18:03.028] _save_context_stack = 0x0 [06:18:03.028] _do_rethrow = false [06:18:03.028] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:18:03.028] parsetree = 0x834498fd0 [06:18:03.028] commandCollected = false [06:18:03.028] needCleanup = false [06:18:03.028] address = [06:18:03.028] isTopLevel = [06:18:03.028] isCompleteQuery = [06:18:03.028] #10 0x000000000093ae48 in standard_ProcessUtility (pstmt=0x8343f7a68, queryString=0x8343f6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83723f448, qc=0x8215c2560) at ../src/backend/tcop/utility.c:1030 [06:18:03.028] isAtomicContext = false [06:18:03.028] parsetree = 0x834498fd0 [06:18:03.028] readonly_flags = [06:18:03.028] pstate = 0x834577900 [06:18:03.028] isTopLevel = [06:18:03.028] #11 0x000000000093a8d8 in ProcessUtility (pstmt=0x18db7, queryString=0x6 , readOnlyTree=, context=712614906, params=0x0, queryEnv=0x0, dest=0x83723f448, qc=0x8215c2560) at ../src/backend/tcop/utility.c:523 [06:18:03.028] No locals. [06:18:03.028] #12 0x000000000093a413 in PortalRunUtility (portal=0x8344cd100, pstmt=0x8343f7a68, isTopLevel=, setHoldSnapshot=, dest=0x83723f448, qc=0x8215c2560) at ../src/backend/tcop/pquery.c:1158 [06:18:03.028] No locals. [06:18:03.028] #13 0x0000000000939aa4 in PortalRunMulti (portal=portal@entry=0x8344cd100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83723f448, altdest=altdest@entry=0x83723f448, qc=0x8215c2560) at ../src/backend/tcop/pquery.c:1323 [06:18:03.028] pstmt = 0x8343f7a68 [06:18:03.028] stmtlist_item__state = {l = 0x83723f3f8, i = 0} [06:18:03.028] active_snapshot_set = false [06:18:03.028] stmtlist_item = 0x83723f410 [06:18:03.028] #14 0x0000000000939373 in PortalRun (portal=portal@entry=0x8344cd100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83723f448, altdest=altdest@entry=0x83723f448, qc=0x8215c2560) at ../src/backend/tcop/pquery.c:791 [06:18:03.028] _local_sigjmp_buf = {{_sjb = {9671405, 35237187840, 34919425112, 34919425344, 34919425120, 35237203968, 12332632, 12365960, 35237135231, 35236967824, 4294967984, 0}}} [06:18:03.028] _save_exception_stack = 0x8215c2630 [06:18:03.028] _save_context_stack = 0x0 [06:18:03.028] _do_rethrow = false [06:18:03.028] saveTopTransactionResourceOwner = 0x8344de118 [06:18:03.028] saveTopTransactionContext = 0x8344d1000 [06:18:03.028] saveActivePortal = 0x0 [06:18:03.028] saveResourceOwner = 0x8344de118 [06:18:03.028] savePortalContext = 0x0 [06:18:03.028] saveMemoryContext = 0x8344d1000 [06:18:03.028] result = [06:18:03.028] nprocessed = [06:18:03.028] #15 0x0000000000938212 in exec_simple_query (query_string=query_string@entry=0x8343f6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [06:18:03.028] cmdtaglen = 24 [06:18:03.028] snapshot_set = [06:18:03.028] per_parsetree_context = 0x0 [06:18:03.028] plantree_list = [06:18:03.028] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:18:03.028] format = 0 [06:18:03.028] parsetree = 0x8343f76a8 [06:18:03.028] commandTag = [06:18:03.028] cmdtagname = [06:18:03.028] querytree_list = [06:18:03.028] portal = 0x8344cd100 [06:18:03.028] receiver = 0x83723f448 [06:18:03.028] parsetree_item__state = {l = 0x8343f7a18, i = 0} [06:18:03.028] msec_str = "\000\000\000\000\b", '\000' , "'\301\353f\000\000\000\000<\304-\260\232s\267\271" [06:18:03.028] dest = DestRemote [06:18:03.028] was_logged = [06:18:03.028] oldcontext = 0x8344d1000 [06:18:03.028] parsetree_list = 0x8343f7a18 [06:18:03.028] use_implicit_block = false [06:18:03.028] parsetree_item = 0x8343f7a30 [06:18:03.028] save_log_statement_stats = [06:18:03.028] #16 0x0000000000935e83 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [06:18:03.028] query_string = 0x8343f6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:18:03.028] input_message = {data = 0x8343f6100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:18:03.028] firstchar = [06:18:03.028] local_sigjmp_buf = {{_sjb = {9655094, 34919425584, 34919425544, 34919426128, 12374696, 1, 8192, 8388608, 34919416703, 0, 0, 1}}} [06:18:03.028] send_ready_for_query = false [06:18:03.028] idle_in_transaction_timeout_enabled = false [06:18:03.028] idle_session_timeout_enabled = false [06:18:03.028] #17 0x0000000000930679 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:18:03.028] bsdata = [06:18:03.028] #18 0x000000000088a7c7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8215c3374 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215c32b0) at ../src/backend/postmaster/launch_backend.c:274 [06:18:03.028] pid = [06:18:03.028] #19 0x000000000088eb88 in BackendStartup (client_sock=0x8215c32b0) at ../src/backend/postmaster/postmaster.c:3415 [06:18:03.028] startup_data = {canAcceptConnections = CAC_OK} [06:18:03.028] bn = 0x834402498 [06:18:03.028] pid = [06:18:03.028] __error = [06:18:03.028] save_errno = [06:18:03.028] __error = [06:18:03.028] __error = [06:18:03.028] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [06:18:03.028] 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\177?4\b", '\000' , "\0203\\!\b\000\000\000h\005\316)\b\000\000\000\v\000\000\000\000\000\000\000^\217\316)\b", '\000' , "P3\\!\b\000\000\000t\245\210\000\000\000\000\000`3\\!\b", '\000' }, salen = 16}} [06:18:03.028] i = 0 [06:18:03.028] now = [06:18:03.028] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 712240258, events = 8, fd = 0, user_data = 0x8215c3260}, {pos = 876946904, events = 8, fd = 559689968, user_data = 0x0}, {pos = 0, events = 0, fd = -1475696501, user_data = 0x32cc38ec230a}, {pos = 711407520, events = 8, fd = 711478648, user_data = 0x8215c2d78}, {pos = 559689200, events = 8, fd = 559689080, user_data = 0x32cc38ec230a}, {pos = 711385992, events = 8, fd = 711478648, user_data = 0x8215c2da8}, {pos = 559689248, events = 8, fd = 559689128, user_data = 0x82a67d194}, {pos = 561083400, events = 8, fd = 711446932, user_data = 0x8215c2e10}, {pos = 954979386, events = 13004, fd = 713269296, user_data = 0x1}, {pos = 559689280, events = 8, fd = 954999562, user_data = 0x82a666858}, {pos = 711478648, events = 8, fd = 559689240, user_data = 0x8215c2e90}, {pos = 559689240, events = 8, fd = 711441676, user_data = 0x821717408}, {pos = 711441676, events = 8, fd = 559689344, user_data = 0x32cc38ebd43a}, {pos = 559689384, events = 8, fd = 559689832, user_data = 0x8215c2e90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2385451816, fd = 561107000, user_data = 0x800000001}, {pos = 561083400, events = 8, fd = 711385992, user_data = 0x82171c288}, {pos = 711354456, events = 8, fd = 561083400, user_data = 0x8215c2f18}, {pos = 559689944, events = 8, fd = 559689472, user_data = 0x32cc38ec1ca2}, {pos = 2700919, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 561107000, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 559690200, user_data = 0x21717408}, {pos = 559690016, events = 8, fd = 559689616, user_data = 0x1}, {pos = 559689944, events = 8, fd = 32, user_data = 0x8215c2f80}, {pos = 954997363, events = 13004, fd = 559689888, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82171d038}, {pos = 1, events = 8, fd = 561083400, user_data = 0x82a666858}, {pos = 559690200, events = 8, fd = 559690016, user_data = 0x8215c2f90}, {pos = 0, events = 0, fd = 561053704, user_data = 0x20}, {pos = 559690000, events = 8, fd = 954972903, user_data = 0x821710008}, {pos = 561054728, events = 8, fd = 561055752, user_data = 0x821710c08}, {pos = 561070088, events = 8, fd = 561071112, user_data = 0x821714808}, {pos = 561073160, events = 8, fd = 561074184, user_data = 0x821715408}, {pos = 561076232, events = 8, fd = 561077256, user_data = 0x821716008}, {pos = 561079304, events = 8, fd = 561080328, user_data = 0x821716c08}, {pos = 561082376, events = 8, fd = 561083400, user_data = 0x821717808}, {pos = 561085448, events = 8, fd = 561086472, user_data = 0x821718408}, {pos = 561088520, events = 8, fd = 561089544, user_data = 0x821719008}, {pos = 561091592, events = 8, fd = 561092616, user_data = 0x821719c08}, {pos = 561098760, events = 8, fd = 561099784, user_data = 0x82171b808}, {pos = 561101832, events = 8, fd = 561053704, user_data = 0x293677}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82171d038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 559690200, events = 8, fd = 559689616, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 561107000, user_data = 0x1}, {pos = 561053704, events = 8, fd = 313, user_data = 0x8215c31c0}, {pos = 954971631, events = 13004, fd = 2700919, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 561107000, user_data = 0x1}, {pos = 561083400, events = 8, fd = 876503040, user_data = 0x1}, {pos = 876503444, events = 8, fd = 0, user_data = 0x8215c3190}, {pos = 701400428, events = 8, fd = 1, user_data = 0x8343e6000}, {pos = 559690176, events = 8, fd = 701396738, user_data = 0x82a798170 }, {pos = 12299728, events = 0, fd = 712606064, user_data = 0x821717408}, {pos = 559690400, events = 8, fd = 954971102, user_data = 0x834404800}, {pos = 1, events = 0, fd = 954970718, user_data = 0x821710008}, {pos = 559690184, events = 8, fd = 559690400, user_data = 0x1c20}, {pos = 876576512, events = 8, fd = 955050384, user_data = 0x0}, {pos = 559678335, events = 8, fd = 8104679, user_data = 0x8215c3250}, {pos = 701359120, events = 8, fd = 713269296, user_data = 0x82a83c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8215c3280}, {pos = 701402013, events = 8, fd = 876503040, user_data = 0x1dac}, {pos = 559690464, events = 8, fd = 701368570, user_data = 0x0}, {pos = 0, events = 0, fd = -1475696501, user_data = 0x0}} [06:18:03.028] last_touch_time = 1726726418 [06:18:03.028] last_lockfile_recheck_time = 1726726418 [06:18:03.028] nevents = 1 [06:18:03.028] #21 0x000000000088c9a5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8215c38c8) at ../src/backend/postmaster/postmaster.c:1346 [06:18:03.028] userDoption = [06:18:03.028] listen_addr_saved = [06:18:03.028] output_config_variable = [06:18:03.028] opt = [06:18:03.028] status = [06:18:03.028] #22 0x00000000007c77cc in main (argc=8, argv=0x8215c38c8) at ../src/backend/main/main.c:197 [06:18:03.028] do_check_root = [06:18:03.040] [06:18:03.040] [06:18:03.040] [06:18:03.098] dumping /tmp/cores/postgres.10967.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:18:03.217] [New LWP 101839] [06:18:03.281] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [06:18:03.281] Program terminated with signal SIGABRT, Aborted. [06:18:03.281] Sent by thr_kill() from pid 10967 and user 1003. [06:18:03.281] #0 0x000000082bdf741a in thr_kill () from /lib/libc.so.7 [06:18:03.900] [06:18:03.900] Thread 1 (LWP 101839): [06:18:03.900] #0 0x000000082bdf741a in thr_kill () from /lib/libc.so.7 [06:18:03.900] No symbol table info available. [06:18:03.900] #1 0x000000082bd70e64 in raise () from /lib/libc.so.7 [06:18:03.900] No symbol table info available. [06:18:03.900] #2 0x000000082be216f9 in abort () from /lib/libc.so.7 [06:18:03.900] No symbol table info available. [06:18:03.900] #3 0x0000000000a8f945 in ExceptionalCondition (conditionName=0x2e748e "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:18:03.900] No locals. [06:18:03.900] #4 0x0000000000764509 in standard_ExecutorStart (queryDesc=0x83437d088, eflags=0) at ../src/backend/executor/execMain.c:194 [06:18:03.900] estate = 0x83f75a100 [06:18:03.900] oldcontext = 0x8344a7800 [06:18:03.900] #5 0x00000000006fac35 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [06:18:03.900] copied_query = [06:18:03.900] rewritten = [06:18:03.900] plan = 0x8343e5bd8 [06:18:03.900] queryDesc = 0x83437d088 [06:18:03.900] processed = [06:18:03.900] __error = [06:18:03.900] #6 RefreshMatViewByOid (matviewOid=27294, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [06:18:03.900] dest = [06:18:03.900] save_userid = 10 [06:18:03.900] save_sec_context = 0 [06:18:03.900] processed = 0 [06:18:03.900] matviewRel = 0x83f706f40 [06:18:03.900] relowner = 10 [06:18:03.900] save_nestlevel = 2 [06:18:03.900] rule = [06:18:03.900] actions = [06:18:03.900] dataQuery = [06:18:03.900] tableSpace = [06:18:03.900] relpersistence = [06:18:03.900] OIDNewHeap = 27313 [06:18:03.900] address = [06:18:03.900] #7 0x00000000006fa816 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:18:03.900] lockmode = [06:18:03.900] matviewOid = 0 [06:18:03.900] #8 0x00000000006d211c in ExecCreateTableAs (pstate=pstate@entry=0x8344a7900, stmt=stmt@entry=0x8344a2fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82198e080) at ../src/backend/commands/createas.c:350 [06:18:03.900] refresh = 0x0 [06:18:03.900] query = 0x8343ed598 [06:18:03.900] into = 0x8343ed8e0 [06:18:03.900] do_refresh = false [06:18:03.900] address = [06:18:03.900] dest = [06:18:03.900] is_matview = [06:18:03.900] #9 0x000000000093c4c8 in ProcessUtilitySlow (pstate=pstate@entry=0x8344a7900, pstmt=pstmt@entry=0x834306a68, queryString=queryString@entry=0x834305100 "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=0x82198e080) at ../src/backend/tcop/utility.c:1675 [06:18:03.900] _local_sigjmp_buf = {{_sjb = {9682169, 0, 34923404456, 34923404832, 34923404464, 12365960, 0, 35237034240, 4294902655, 34923404572, 34923404608, 0}}} [06:18:03.900] _save_exception_stack = 0x82198df80 [06:18:03.900] _save_context_stack = 0x0 [06:18:03.900] _do_rethrow = false [06:18:03.900] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:18:03.900] parsetree = 0x8344a2fd0 [06:18:03.900] commandCollected = false [06:18:03.900] needCleanup = false [06:18:03.900] address = [06:18:03.900] isTopLevel = [06:18:03.900] isCompleteQuery = [06:18:03.900] #10 0x000000000093ae48 in standard_ProcessUtility (pstmt=0x834306a68, queryString=0x834305100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8343eddc8, qc=0x82198e080) at ../src/backend/tcop/utility.c:1030 [06:18:03.900] isAtomicContext = false [06:18:03.900] parsetree = 0x8344a2fd0 [06:18:03.900] readonly_flags = [06:18:03.900] pstate = 0x8344a7900 [06:18:03.900] isTopLevel = [06:18:03.900] #11 0x000000000093a8d8 in ProcessUtility (pstmt=0x18dcf, queryString=0x6 , readOnlyTree=, context=736064506, params=0x0, queryEnv=0x0, dest=0x8343eddc8, qc=0x82198e080) at ../src/backend/tcop/utility.c:523 [06:18:03.900] No locals. [06:18:03.900] #12 0x000000000093a413 in PortalRunUtility (portal=0x8343ab100, pstmt=0x834306a68, isTopLevel=, setHoldSnapshot=, dest=0x8343eddc8, qc=0x82198e080) at ../src/backend/tcop/pquery.c:1158 [06:18:03.900] No locals. [06:18:03.900] #13 0x0000000000939aa4 in PortalRunMulti (portal=portal@entry=0x8343ab100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8343eddc8, altdest=altdest@entry=0x8343eddc8, qc=0x82198e080) at ../src/backend/tcop/pquery.c:1323 [06:18:03.900] pstmt = 0x834306a68 [06:18:03.900] stmtlist_item__state = {l = 0x8343edd78, i = 0} [06:18:03.900] active_snapshot_set = false [06:18:03.900] stmtlist_item = 0x8343edd90 [06:18:03.900] #14 0x0000000000939373 in PortalRun (portal=portal@entry=0x8343ab100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8343eddc8, altdest=altdest@entry=0x8343eddc8, qc=0x82198e080) at ../src/backend/tcop/pquery.c:791 [06:18:03.900] _local_sigjmp_buf = {{_sjb = {9671405, 35236000000, 34923405176, 34923405408, 34923405184, 35236016128, 12332632, 12365960, 35235955583, 35237008784, 4294967984, 0}}} [06:18:03.900] _save_exception_stack = 0x82198e150 [06:18:03.900] _save_context_stack = 0x0 [06:18:03.900] _do_rethrow = false [06:18:03.900] saveTopTransactionResourceOwner = 0x8343fa398 [06:18:03.900] saveTopTransactionContext = 0x8343af000 [06:18:03.900] saveActivePortal = 0x0 [06:18:03.900] saveResourceOwner = 0x8343fa398 [06:18:03.900] savePortalContext = 0x0 [06:18:03.900] saveMemoryContext = 0x8343af000 [06:18:03.900] result = [06:18:03.900] nprocessed = [06:18:03.900] #15 0x0000000000938212 in exec_simple_query (query_string=query_string@entry=0x834305100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [06:18:03.900] cmdtaglen = 24 [06:18:03.900] snapshot_set = [06:18:03.900] per_parsetree_context = 0x0 [06:18:03.900] plantree_list = [06:18:03.900] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:18:03.900] format = 0 [06:18:03.900] parsetree = 0x8343066a8 [06:18:03.900] commandTag = [06:18:03.900] cmdtagname = [06:18:03.900] querytree_list = [06:18:03.900] portal = 0x8343ab100 [06:18:03.900] receiver = 0x8343eddc8 [06:18:03.900] parsetree_item__state = {l = 0x834306a18, i = 0} [06:18:03.900] msec_str = "\000\000\000\000\b", '\000' , ")\301\353f\000\000\000\000\334\315\271\215\204\357\301=" [06:18:03.900] dest = DestRemote [06:18:03.900] was_logged = [06:18:03.900] oldcontext = 0x8343af000 [06:18:03.900] parsetree_list = 0x834306a18 [06:18:03.900] use_implicit_block = false [06:18:03.900] parsetree_item = 0x834306a30 [06:18:03.900] save_log_statement_stats = [06:18:03.900] #16 0x0000000000935e83 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [06:18:03.900] query_string = 0x834305100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:18:03.900] input_message = {data = 0x834305100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:18:03.900] firstchar = [06:18:03.900] local_sigjmp_buf = {{_sjb = {9655094, 34923405648, 34923405608, 34923406192, 12374696, 1, 8192, 8388608, 34923348863, 0, 0, 1}}} [06:18:03.900] send_ready_for_query = false [06:18:03.900] idle_in_transaction_timeout_enabled = false [06:18:03.900] idle_session_timeout_enabled = false [06:18:03.900] #17 0x0000000000930679 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:18:03.900] bsdata = [06:18:03.900] #18 0x000000000088a7c7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82198ee94 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82198edd0) at ../src/backend/postmaster/launch_backend.c:274 [06:18:03.900] pid = [06:18:03.900] #19 0x000000000088eb88 in BackendStartup (client_sock=0x82198edd0) at ../src/backend/postmaster/postmaster.c:3415 [06:18:03.900] startup_data = {canAcceptConnections = CAC_OK} [06:18:03.900] bn = 0x834311088 [06:18:03.900] pid = [06:18:03.900] __error = [06:18:03.900] save_errno = [06:18:03.900] __error = [06:18:03.900] __error = [06:18:03.900] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [06:18:03.900] 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 = "\300n04\b", '\000' , "0\356\230!\b\000\000\000h\225\241*\b\000\000\000\v\000\000\000\000\000\000\000^\037\242*\b", '\000' , "p\356\230!\b\000\000\000t\245\210\000\000\000\000\000\200\356\230!\b", '\000' }, salen = 16}} [06:18:03.900] i = 0 [06:18:03.900] now = [06:18:03.900] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 876017112, events = 8, fd = 563670032, user_data = 0x0}, {pos = 0, events = 0, fd = -238539508, user_data = 0x30870c1e30a}, {pos = 734857120, events = 8, fd = 734928248, user_data = 0x82198e898}, {pos = 563669264, events = 8, fd = 563669144, user_data = 0x30870c1e30a}, {pos = 734835592, events = 8, fd = 734928248, user_data = 0x82198e8c8}, {pos = 563669312, events = 8, fd = 563669192, user_data = 0x82bcda194}, {pos = 567104520, events = 8, fd = 734896532, user_data = 0x82198e930}, {pos = 1891734586, events = 776, fd = 736718896, user_data = 0x1}, {pos = 563669344, events = 8, fd = 1891754762, user_data = 0x82bcc3858}, {pos = 734928248, events = 8, fd = 563669304, user_data = 0x82198e9b0}, {pos = 563669304, events = 8, fd = 734891276, user_data = 0x821cd5408}, {pos = 734891276, events = 8, fd = 563669408, user_data = 0x30870c1943a}, {pos = 563669448, events = 8, fd = 563669896, user_data = 0x82198e9b0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 526794533, fd = 567128120, user_data = 0x800000001}, {pos = 567104520, events = 8, fd = 734835592, user_data = 0x821cda288}, {pos = 734804056, events = 8, fd = 567104520, user_data = 0x82198ea38}, {pos = 563670008, events = 8, fd = 563669536, user_data = 0x30870c1dca2}, {pos = 2700919, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 567128120, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 563670264, user_data = 0x21cd5408}, {pos = 563670080, events = 8, fd = 563669680, user_data = 0x1}, {pos = 563670008, events = 8, fd = 32, user_data = 0x82198eaa0}, {pos = 1891752563, events = 776, fd = 563669952, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821cdb038}, {pos = 1, events = 8, fd = 567104520, user_data = 0x82bcc3858}, {pos = 563670264, events = 8, fd = 563670080, user_data = 0x82198eab0}, {pos = 0, events = 0, fd = 567074824, user_data = 0x20}, {pos = 563670064, events = 8, fd = 1891728103, user_data = 0x821cce008}, {pos = 567075848, events = 8, fd = 567076872, user_data = 0x821ccec08}, {pos = 567091208, events = 8, fd = 567092232, user_data = 0x821cd2808}, {pos = 567094280, events = 8, fd = 567095304, user_data = 0x821cd3408}, {pos = 567097352, events = 8, fd = 567098376, user_data = 0x821cd4008}, {pos = 567100424, events = 8, fd = 567101448, user_data = 0x821cd4c08}, {pos = 567103496, events = 8, fd = 567104520, user_data = 0x821cd5808}, {pos = 567106568, events = 8, fd = 567107592, user_data = 0x821cd6408}, {pos = 567109640, events = 8, fd = 567110664, user_data = 0x821cd7008}, {pos = 567112712, events = 8, fd = 567113736, user_data = 0x821cd7c08}, {pos = 567119880, events = 8, fd = 567120904, user_data = 0x821cd9808}, {pos = 567122952, events = 8, fd = 567074824, user_data = 0x293677}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821cdb038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 563670264, events = 8, fd = 563669680, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 567128120, user_data = 0x1}, {pos = 567074824, events = 8, fd = 313, user_data = 0x82198ece0}, {pos = 1891726831, events = 776, fd = 2700919, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 567128120, user_data = 0x1}, {pos = 567104520, events = 8, fd = 875515904, user_data = 0x1}, {pos = 875516308, events = 8, fd = 0, user_data = 0x82198ecb0}, {pos = 715265388, events = 8, fd = 1, user_data = 0x8342f5000}, {pos = 563670240, events = 8, fd = 715261698, user_data = 0x82bdf5170 }, {pos = 12299728, events = 0, fd = 736055664, user_data = 0x821cd5408}, {pos = 563670464, events = 8, fd = 1891726302, user_data = 0x834313800}, {pos = 1, events = 0, fd = 1891725918, user_data = 0x821cce008}, {pos = 563670248, events = 8, fd = 563670464, user_data = 0x1c20}, {pos = 875589312, events = 8, fd = 1891805584, user_data = 0x0}, {pos = 563610495, events = 8, fd = 8104679, user_data = 0x82198ed70}, {pos = 715224080, events = 8, fd = 736718896, user_data = 0x82be99310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82198eda0}, {pos = 715266973, events = 8, fd = 875515904, user_data = 0x1dd9}, {pos = 563670528, events = 8, fd = 715233530, user_data = 0x0}, {pos = 0, events = 0, fd = -238539508, user_data = 0x0}} [06:18:03.900] last_touch_time = 1726726419 [06:18:03.900] last_lockfile_recheck_time = 1726726419 [06:18:03.900] nevents = 1 [06:18:03.900] #21 0x000000000088c9a5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82198f3e8) at ../src/backend/postmaster/postmaster.c:1346 [06:18:03.900] userDoption = [06:18:03.900] listen_addr_saved = [06:18:03.900] output_config_variable = [06:18:03.900] opt = [06:18:03.900] status = [06:18:03.900] #22 0x00000000007c77cc in main (argc=4, argv=0x82198f3e8) at ../src/backend/main/main.c:197 [06:18:03.900] do_check_root = [06:18:03.913] [06:18:03.913] [06:18:03.913] [06:18:03.976] dumping /tmp/cores/postgres.17376.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:18:04.098] [New LWP 101898] [06:18:04.165] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [06:18:04.165] Program terminated with signal SIGABRT, Aborted. [06:18:04.165] Sent by thr_kill() from pid 17376 and user 1003. [06:18:04.165] #0 0x000000082bd7441a in thr_kill () from /lib/libc.so.7 [06:18:04.798] [06:18:04.798] Thread 1 (LWP 101898): [06:18:04.798] #0 0x000000082bd7441a in thr_kill () from /lib/libc.so.7 [06:18:04.798] No symbol table info available. [06:18:04.798] #1 0x000000082bcede64 in raise () from /lib/libc.so.7 [06:18:04.798] No symbol table info available. [06:18:04.798] #2 0x000000082bd9e6f9 in abort () from /lib/libc.so.7 [06:18:04.798] No symbol table info available. [06:18:04.798] #3 0x0000000000a8f945 in ExceptionalCondition (conditionName=0x2e748e "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:18:04.798] No locals. [06:18:04.798] #4 0x0000000000764509 in standard_ExecutorStart (queryDesc=0x837e41088, eflags=0) at ../src/backend/executor/execMain.c:194 [06:18:04.798] estate = 0x837e83100 [06:18:04.798] oldcontext = 0x837d85800 [06:18:04.798] #5 0x000000083a116862 in pgss_ExecutorStart (queryDesc=0x837e41088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:986 [06:18:04.798] No locals. [06:18:04.798] #6 0x00000000006fac35 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [06:18:04.798] copied_query = [06:18:04.798] rewritten = [06:18:04.798] plan = 0x83cf68bd8 [06:18:04.798] queryDesc = 0x837e41088 [06:18:04.798] processed = [06:18:04.798] __error = [06:18:04.798] #7 RefreshMatViewByOid (matviewOid=27388, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [06:18:04.798] dest = [06:18:04.798] save_userid = 10 [06:18:04.798] save_sec_context = 0 [06:18:04.798] processed = 0 [06:18:04.798] matviewRel = 0x83cf346b8 [06:18:04.798] relowner = 10 [06:18:04.798] save_nestlevel = 2 [06:18:04.798] rule = [06:18:04.798] actions = [06:18:04.798] dataQuery = [06:18:04.798] tableSpace = [06:18:04.798] relpersistence = [06:18:04.798] OIDNewHeap = 27395 [06:18:04.798] address = [06:18:04.798] #8 0x00000000006fa816 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:18:04.798] lockmode = [06:18:04.798] matviewOid = 0 [06:18:04.798] #9 0x00000000006d211c in ExecCreateTableAs (pstate=pstate@entry=0x837d85900, stmt=stmt@entry=0x837d4afd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820ce2d00) at ../src/backend/commands/createas.c:350 [06:18:04.798] refresh = 0x0 [06:18:04.798] query = 0x837d959c8 [06:18:04.798] into = 0x837d4af40 [06:18:04.798] do_refresh = false [06:18:04.798] address = [06:18:04.798] dest = [06:18:04.798] is_matview = [06:18:04.798] #10 0x000000000093c4c8 in ProcessUtilitySlow (pstate=pstate@entry=0x837d85900, pstmt=pstmt@entry=0x837d4ae30, queryString=queryString@entry=0x837cad100 "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=0x820ce2d00) at ../src/backend/tcop/utility.c:1675 [06:18:04.798] _local_sigjmp_buf = {{_sjb = {9682169, 0, 34910119784, 34910120160, 34910119792, 12365960, 0, 35296663808, 34910110591, 7, 34910119936, 0}}} [06:18:04.798] _save_exception_stack = 0x820ce29f0 [06:18:04.798] _save_context_stack = 0x0 [06:18:04.798] _do_rethrow = false [06:18:04.798] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:18:04.798] parsetree = 0x837d4afd0 [06:18:04.798] commandCollected = false [06:18:04.798] needCleanup = false [06:18:04.798] address = [06:18:04.798] isTopLevel = [06:18:04.798] isCompleteQuery = [06:18:04.798] #11 0x000000000093ae48 in standard_ProcessUtility (pstmt=0x837d4ae30, queryString=queryString@entry=0x837cad100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837d96168, qc=0x820ce2d00) at ../src/backend/tcop/utility.c:1030 [06:18:04.798] isAtomicContext = false [06:18:04.798] parsetree = 0x837d4afd0 [06:18:04.798] readonly_flags = [06:18:04.798] pstate = 0x837d85900 [06:18:04.798] isTopLevel = [06:18:04.798] #12 0x000000083a116dee in pgss_ProcessUtility (pstmt=0x837d4ae30, queryString=0x837cad100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837d96168, qc=0x820ce2d00) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [06:18:04.798] _local_sigjmp_buf = {{_sjb = {35333958951, 34910120432, 34910120296, 34910120752, 35296423472, 0, 12365960, 34910120960, 34910110591, 34910120532, 34910120560, 0}}} [06:18:04.798] _save_exception_stack = 0x820ce2c00 [06:18:04.798] _save_context_stack = 0x0 [06:18:04.798] _do_rethrow = false [06:18:04.798] bufusage = {shared_blks_hit = 35333958951, shared_blks_read = 34910120432, shared_blks_dirtied = 34910120296, shared_blks_written = 34910120752, local_blks_hit = 35296423472, local_blks_read = 0, local_blks_dirtied = 12365960, local_blks_written = 34910120960, temp_blks_read = 34910110591, temp_blks_written = 34910120532, shared_blk_read_time = {ticks = 34910120560}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4268388806714681600}, local_blk_write_time = {ticks = 12375000}, temp_blk_read_time = {ticks = 35357738624}, temp_blk_write_time = {ticks = 12328576}} [06:18:04.798] walusage_start = {wal_records = 8921, wal_fpi = 146, wal_bytes = 1275110} [06:18:04.798] duration = [06:18:04.798] bufusage_start = {shared_blks_hit = 150331, shared_blks_read = 8418, shared_blks_dirtied = 2630, shared_blks_written = 2247, 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}} [06:18:04.798] walusage = {wal_records = 8175389491383455228, wal_fpi = 35296423888, wal_bytes = 123} [06:18:04.798] start = {ticks = -183687423272} [06:18:04.798] rows = [06:18:04.798] saved_queryId = 6041762721901209185 [06:18:04.798] parsetree = [06:18:04.798] saved_stmt_location = 0 [06:18:04.798] saved_stmt_len = 69 [06:18:04.798] enabled = [06:18:04.798] #13 0x000000000093a413 in PortalRunUtility (portal=0x837d55100, pstmt=0x837d4ae30, isTopLevel=, setHoldSnapshot=, dest=0x837d96168, qc=0x820ce2d00) at ../src/backend/tcop/pquery.c:1158 [06:18:04.798] No locals. [06:18:04.798] #14 0x0000000000939aa4 in PortalRunMulti (portal=portal@entry=0x837d55100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x837d96168, altdest=altdest@entry=0x837d96168, qc=0x820ce2d00) at ../src/backend/tcop/pquery.c:1323 [06:18:04.798] pstmt = 0x837d4ae30 [06:18:04.798] stmtlist_item__state = {l = 0x837d96118, i = 0} [06:18:04.798] active_snapshot_set = false [06:18:04.798] stmtlist_item = 0x837d96130 [06:18:04.798] #15 0x0000000000939373 in PortalRun (portal=portal@entry=0x837d55100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x837d96168, altdest=altdest@entry=0x837d96168, qc=0x820ce2d00) at ../src/backend/tcop/pquery.c:791 [06:18:04.798] _local_sigjmp_buf = {{_sjb = {9671405, 35296465152, 34910120952, 34910121184, 34910120960, 35296559104, 12332632, 12365960, 35296445311, 35296417248, 4294967984, 0}}} [06:18:04.798] _save_exception_stack = 0x820ce2dd0 [06:18:04.798] _save_context_stack = 0x0 [06:18:04.798] _do_rethrow = false [06:18:04.798] saveTopTransactionResourceOwner = 0x837da3858 [06:18:04.798] saveTopTransactionContext = 0x837d6c000 [06:18:04.798] saveActivePortal = 0x0 [06:18:04.798] saveResourceOwner = 0x837da3858 [06:18:04.798] savePortalContext = 0x0 [06:18:04.798] saveMemoryContext = 0x837d6c000 [06:18:04.798] result = [06:18:04.798] nprocessed = [06:18:04.798] #16 0x0000000000938212 in exec_simple_query (query_string=query_string@entry=0x837cad100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [06:18:04.798] cmdtaglen = 24 [06:18:04.798] snapshot_set = [06:18:04.798] per_parsetree_context = 0x0 [06:18:04.798] plantree_list = [06:18:04.798] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:18:04.798] format = 0 [06:18:04.798] parsetree = 0x837cae6a8 [06:18:04.798] commandTag = [06:18:04.798] cmdtagname = [06:18:04.798] querytree_list = [06:18:04.798] portal = 0x837d55100 [06:18:04.798] receiver = 0x837d96168 [06:18:04.798] parsetree_item__state = {l = 0x837caea18, i = 0} [06:18:04.798] msec_str = "\000\000\000\000\b", '\000' , "M\301\353f\000\000\000\000|\231\3327\006\332v\243" [06:18:04.798] dest = DestRemote [06:18:04.798] was_logged = [06:18:04.798] oldcontext = 0x837d6c000 [06:18:04.798] parsetree_list = 0x837caea18 [06:18:04.798] use_implicit_block = false [06:18:04.798] parsetree_item = 0x837caea30 [06:18:04.798] save_log_statement_stats = [06:18:04.798] #17 0x0000000000935e83 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4786 [06:18:04.798] query_string = 0x837cad100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:18:04.798] input_message = {data = 0x837cad100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:18:04.798] firstchar = [06:18:04.798] local_sigjmp_buf = {{_sjb = {9655094, 34910121424, 34910121384, 34910121968, 12374696, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [06:18:04.798] send_ready_for_query = false [06:18:04.798] idle_in_transaction_timeout_enabled = false [06:18:04.798] idle_session_timeout_enabled = false [06:18:04.798] #18 0x0000000000930679 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:18:04.798] bsdata = [06:18:04.798] #19 0x000000000088a7c7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820ce3b14 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820ce3a50) at ../src/backend/postmaster/launch_backend.c:274 [06:18:04.798] pid = [06:18:04.798] #20 0x000000000088eb88 in BackendStartup (client_sock=0x820ce3a50) at ../src/backend/postmaster/postmaster.c:3415 [06:18:04.798] startup_data = {canAcceptConnections = CAC_OK} [06:18:04.798] bn = 0x837cb95d8 [06:18:04.798] pid = [06:18:04.798] __error = [06:18:04.798] save_errno = [06:18:04.798] __error = [06:18:04.798] __error = [06:18:04.798] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [06:18:04.798] 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 = " \334\3127\b", '\000' , "\260:\316 \b\000\000\000hUs+\b\000\000\000\v\000\000\000\000\000\000\000^\337s+\b", '\000' , "\360:\316 \b\000\000\000t\245\210\000\000\000\000\000\000;\316 \b", '\000' }, salen = 16}} [06:18:04.798] i = 0 [06:18:04.798] now = [06:18:04.798] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 735153282, events = 8, fd = 0, user_data = 0x820ce3a00}, {pos = 936445400, events = 8, fd = 550385808, user_data = 0x0}, {pos = 77837066, events = 10041, fd = 734320544, user_data = 0x82bc5ed78}, {pos = 550384904, events = 8, fd = 550385024, user_data = 0x820ce3508}, {pos = 77837066, events = 10041, fd = 734299016, user_data = 0x82bc5ed78}, {pos = 550384952, events = 8, fd = 550385072, user_data = 0x820ce3538}, {pos = 734359956, events = 8, fd = 559744008, user_data = 0x82bc57194}, {pos = 550385056, events = 8, fd = 77816890, user_data = 0x820ce3540}, {pos = 728970256, events = 8, fd = 736182320, user_data = 0x273904a3b30a}, {pos = 734267480, events = 8, fd = 734391672, user_data = 0x820ce35a8}, {pos = 550385184, events = 8, fd = 550385064, user_data = 0x82bc55d0c}, {pos = 559744008, events = 8, fd = 734354700, user_data = 0x820ce3610}, {pos = 77816890, events = 10041, fd = 550385208, user_data = 0x820ce3808}, {pos = 550385184, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8215d6038}, {pos = 1, events = 1903481197, fd = 559744008, user_data = 0x82bc48388}, {pos = 559765448, events = 8, fd = 0, user_data = 0x0}, {pos = 550385320, events = 8, fd = 550385784, user_data = 0x820ce3690}, {pos = 77835426, events = 10041, fd = 2700919, user_data = 0x6d68b}, {pos = 2090263927, events = 1903481197, fd = 559767608, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820ce3978}, {pos = 559744008, events = 3, fd = 550385856, user_data = 0x8215d5828}, {pos = 656, events = 0, fd = 550385784, user_data = 0x820ce36a8}, {pos = 550385424, events = 8, fd = 77835035, user_data = 0x820ce3840}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 559767608, events = 8, fd = 1, user_data = 0x8215d0408}, {pos = 734267480, events = 8, fd = 550386040, user_data = 0x820ce38c0}, {pos = 550385440, events = 8, fd = 0, user_data = 0x8215c9008}, {pos = 33, events = 0, fd = 550385840, user_data = 0x273904a34ae7}, {pos = 559714312, events = 8, fd = 559715336, user_data = 0x8215c9808}, {pos = 559717384, events = 8, fd = 559730696, user_data = 0x8215cd408}, {pos = 559732744, events = 8, fd = 559733768, user_data = 0x8215ce008}, {pos = 559735816, events = 8, fd = 559736840, user_data = 0x8215cec08}, {pos = 559738888, events = 8, fd = 559739912, user_data = 0x8215cf808}, {pos = 559741960, events = 8, fd = 559742984, user_data = 0x8215d0408}, {pos = 559745032, events = 8, fd = 559746056, user_data = 0x8215d1008}, {pos = 559748104, events = 8, fd = 559749128, user_data = 0x8215d1c08}, {pos = 559751176, events = 8, fd = 559752200, user_data = 0x8215d2808}, {pos = 559754248, events = 8, fd = 559759368, user_data = 0x8215d4408}, {pos = 559761416, events = 8, fd = 559762440, user_data = 0x8215d7408}, {pos = 688251000, events = 0, fd = 559714312, user_data = 0x293677}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8215d6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550386040, events = 8, fd = 550385440, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 559767608, user_data = 0x1}, {pos = 559714312, events = 8, fd = 313, user_data = 0x820ce3960}, {pos = 77809135, events = 10041, fd = 2700919, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 559767608, user_data = 0x1}, {pos = 559744008, events = 8, fd = 935972864, user_data = 0x1}, {pos = 935973268, events = 8, fd = 0, user_data = 0x820ce3930}, {pos = 729011564, events = 8, fd = 1, user_data = 0x837c9d000}, {pos = 550386016, events = 8, fd = 729007874, user_data = 0x82bd72170 }, {pos = 12299728, events = 0, fd = 735519088, user_data = 0x8215d0408}, {pos = 550386240, events = 8, fd = 77808606, user_data = 0x837cbb800}, {pos = 1, events = 0, fd = 77808222, user_data = 0x8215c9008}, {pos = 550386024, events = 8, fd = 550386240, user_data = 0x1c20}, {pos = 936041504, events = 8, fd = 77887888, user_data = 0x0}, {pos = 550372223, events = 8, fd = 8104679, user_data = 0x820ce39f0}, {pos = 728970256, events = 8, fd = 736182320, user_data = 0x82be16310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820ce3a20}, {pos = 729013149, events = 8, fd = 935972864, user_data = 0x35cf}, {pos = 550386304, events = 8, fd = 728979706, user_data = 0x0}, {pos = 0, events = 0, fd = 1717521916, user_data = 0x0}} [06:18:04.799] last_touch_time = 1726726453 [06:18:04.799] last_lockfile_recheck_time = 1726726453 [06:18:04.799] nevents = 1 [06:18:04.799] #22 0x000000000088c9a5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820ce4068) at ../src/backend/postmaster/postmaster.c:1346 [06:18:04.799] userDoption = [06:18:04.799] listen_addr_saved = [06:18:04.799] output_config_variable = [06:18:04.799] opt = [06:18:04.799] status = [06:18:04.799] #23 0x00000000007c77cc in main (argc=4, argv=0x820ce4068) at ../src/backend/main/main.c:197 [06:18:04.799] do_check_root =