[19:29:53.338] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [19:29:53.713] dumping /tmp/cores/postgres.10659.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [19:29:53.838] [New LWP 100115] [19:29:53.927] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [19:29:53.927] Program terminated with signal SIGABRT, Aborted. [19:29:53.927] Sent by thr_kill() from pid 10659 and user 1003. [19:29:53.927] #0 0x000000082a81741a in thr_kill () from /lib/libc.so.7 [19:29:54.495] [19:29:54.495] Thread 1 (LWP 100115): [19:29:54.495] #0 0x000000082a81741a in thr_kill () from /lib/libc.so.7 [19:29:54.495] No symbol table info available. [19:29:54.495] #1 0x000000082a790e64 in raise () from /lib/libc.so.7 [19:29:54.495] No symbol table info available. [19:29:54.495] #2 0x000000082a8416f9 in abort () from /lib/libc.so.7 [19:29:54.495] No symbol table info available. [19:29:54.495] #3 0x0000000000a896e5 in ExceptionalCondition (conditionName=0x2e61a0 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [19:29:54.495] No locals. [19:29:54.495] #4 0x000000000075fb39 in standard_ExecutorStart (queryDesc=0x83724c380, eflags=0) at ../src/backend/executor/execMain.c:191 [19:29:54.495] estate = 0x83728b100 [19:29:54.495] oldcontext = 0x845fa6800 [19:29:54.495] #5 0x00000000006f6945 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [19:29:54.495] copied_query = [19:29:54.495] rewritten = [19:29:54.495] plan = 0x837235f00 [19:29:54.495] queryDesc = 0x83724c380 [19:29:54.495] processed = [19:29:54.495] __error = [19:29:54.495] #6 RefreshMatViewByOid (matviewOid=27306, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [19:29:54.495] dest = [19:29:54.495] save_userid = 10 [19:29:54.495] save_sec_context = 0 [19:29:54.495] processed = 0 [19:29:54.495] matviewRel = 0x8460a39b8 [19:29:54.495] relowner = 10 [19:29:54.495] save_nestlevel = 2 [19:29:54.495] rule = [19:29:54.495] actions = [19:29:54.495] dataQuery = [19:29:54.495] tableSpace = [19:29:54.495] relpersistence = [19:29:54.495] OIDNewHeap = 27313 [19:29:54.495] address = [19:29:54.495] #7 0x00000000006f6526 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:29:54.495] lockmode = [19:29:54.495] matviewOid = 0 [19:29:54.495] #8 0x00000000006ce32c in ExecCreateTableAs (pstate=pstate@entry=0x845fa6900, stmt=stmt@entry=0x837241fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82117e560) at ../src/backend/commands/createas.c:350 [19:29:54.495] refresh = 0x0 [19:29:54.495] query = 0x837317e58 [19:29:54.495] into = 0x8373181a0 [19:29:54.495] do_refresh = false [19:29:54.495] address = [19:29:54.495] dest = [19:29:54.495] is_matview = [19:29:54.495] #9 0x0000000000936b58 in ProcessUtilitySlow (pstate=pstate@entry=0x845fa6900, pstmt=pstmt@entry=0x837183a68, queryString=queryString@entry=0x837182100 "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=0x82117e560) at ../src/backend/tcop/utility.c:1675 [19:29:54.495] _local_sigjmp_buf = {{_sjb = {9659273, 0, 34914951560, 34914951936, 34914951568, 12338344, 0, 35533777152, 4294902655, 34914951676, 34914951712, 0}}} [19:29:54.495] _save_exception_stack = 0x82117e460 [19:29:54.495] _save_context_stack = 0x0 [19:29:54.495] _do_rethrow = false [19:29:54.495] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:29:54.495] parsetree = 0x837241fd0 [19:29:54.495] commandCollected = false [19:29:54.495] needCleanup = false [19:29:54.495] address = [19:29:54.495] isTopLevel = [19:29:54.495] isCompleteQuery = [19:29:54.495] #10 0x00000000009354d8 in standard_ProcessUtility (pstmt=0x837183a68, queryString=0x837182100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837318688, qc=0x82117e560) at ../src/backend/tcop/utility.c:1030 [19:29:54.495] isAtomicContext = false [19:29:54.495] parsetree = 0x837241fd0 [19:29:54.495] readonly_flags = [19:29:54.495] pstate = 0x845fa6900 [19:29:54.495] isTopLevel = [19:29:54.495] #11 0x0000000000934f68 in ProcessUtility (pstmt=0x18713, queryString=0x6 , readOnlyTree=, context=713126906, params=0x0, queryEnv=0x0, dest=0x837318688, qc=0x82117e560) at ../src/backend/tcop/utility.c:523 [19:29:54.495] No locals. [19:29:54.495] #12 0x0000000000934aa3 in PortalRunUtility (portal=0x837259100, pstmt=0x837183a68, isTopLevel=, setHoldSnapshot=, dest=0x837318688, qc=0x82117e560) at ../src/backend/tcop/pquery.c:1158 [19:29:54.495] No locals. [19:29:54.495] #13 0x0000000000934134 in PortalRunMulti (portal=portal@entry=0x837259100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x837318688, altdest=altdest@entry=0x837318688, qc=0x82117e560) at ../src/backend/tcop/pquery.c:1323 [19:29:54.495] pstmt = 0x837183a68 [19:29:54.495] stmtlist_item__state = {l = 0x837318638, i = 0} [19:29:54.495] active_snapshot_set = false [19:29:54.495] stmtlist_item = 0x837318650 [19:29:54.495] #14 0x0000000000933a03 in PortalRun (portal=portal@entry=0x837259100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x837318688, altdest=altdest@entry=0x837318688, qc=0x82117e560) at ../src/backend/tcop/pquery.c:791 [19:29:54.495] _local_sigjmp_buf = {{_sjb = {9648509, 35284947200, 34914952280, 34914952512, 34914952288, 35284963328, 12305016, 12338344, 35284910975, 35284845968, 4294967984, 0}}} [19:29:54.495] _save_exception_stack = 0x82117e630 [19:29:54.495] _save_context_stack = 0x0 [19:29:54.495] _do_rethrow = false [19:29:54.495] saveTopTransactionResourceOwner = 0x83726a818 [19:29:54.495] saveTopTransactionContext = 0x83725d000 [19:29:54.495] saveActivePortal = 0x0 [19:29:54.495] saveResourceOwner = 0x83726a818 [19:29:54.495] savePortalContext = 0x0 [19:29:54.495] saveMemoryContext = 0x83725d000 [19:29:54.495] result = [19:29:54.495] nprocessed = [19:29:54.495] #15 0x00000000009328a2 in exec_simple_query (query_string=query_string@entry=0x837182100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [19:29:54.495] cmdtaglen = 24 [19:29:54.495] snapshot_set = [19:29:54.495] per_parsetree_context = 0x0 [19:29:54.495] plantree_list = [19:29:54.495] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:29:54.495] format = 0 [19:29:54.495] parsetree = 0x8371836a8 [19:29:54.495] commandTag = [19:29:54.495] cmdtagname = [19:29:54.495] querytree_list = [19:29:54.495] portal = 0x837259100 [19:29:54.495] receiver = 0x837318688 [19:29:54.495] parsetree_item__state = {l = 0x837183a18, i = 0} [19:29:54.495] msec_str = "\000\000\000\000\b", '\000' , "\305K\337f\000\000\000\000k\336D\306\327y\225\261" [19:29:54.495] dest = DestRemote [19:29:54.495] was_logged = [19:29:54.495] oldcontext = 0x83725d000 [19:29:54.495] parsetree_list = 0x837183a18 [19:29:54.495] use_implicit_block = false [19:29:54.495] parsetree_item = 0x837183a30 [19:29:54.495] save_log_statement_stats = [19:29:54.495] #16 0x0000000000930610 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [19:29:54.495] query_string = 0x837182100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:29:54.495] input_message = {data = 0x837182100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:29:54.495] firstchar = [19:29:54.495] local_sigjmp_buf = {{_sjb = {9632422, 34914952752, 34914952712, 34914953296, 12347080, 1, 8192, 8388608, 34914894719, 0, 0, 1}}} [19:29:54.495] send_ready_for_query = false [19:29:54.495] idle_in_transaction_timeout_enabled = false [19:29:54.495] idle_session_timeout_enabled = false [19:29:54.495] #17 0x000000000092ade9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:29:54.495] bsdata = [19:29:54.495] #18 0x0000000000884f87 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82117f374 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82117f2b0) at ../src/backend/postmaster/launch_backend.c:274 [19:29:54.495] pid = [19:29:54.495] #19 0x0000000000889348 in BackendStartup (client_sock=0x82117f2b0) at ../src/backend/postmaster/postmaster.c:3415 [19:29:54.495] startup_data = {canAcceptConnections = CAC_OK} [19:29:54.495] bn = 0x83718e678 [19:29:54.495] pid = [19:29:54.495] __error = [19:29:54.495] save_errno = [19:29:54.495] __error = [19:29:54.495] __error = [19:29:54.495] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:29:54.495] 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?\0307\b", '\000' , "\020\363\027!\b\000\000\000h\365\216+\b\000\000\000\v\000\000\000\000\000\000\000^\177\217+\b", '\000' , "P\363\027!\b\000\000\0004M\210\000\000\000\000\000`\363\027!\b", '\000' }, salen = 16}} [19:29:54.495] i = 0 [19:29:54.495] now = [19:29:54.495] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 712752258, events = 8, fd = 0, user_data = 0x82117f260}, {pos = 924706264, events = 8, fd = 555217136, user_data = 0x0}, {pos = 0, events = 0, fd = 888376807, user_data = 0x316fd60e830a}, {pos = 711919520, events = 8, fd = 711990648, user_data = 0x82117ed78}, {pos = 555216368, events = 8, fd = 555216248, user_data = 0x316fd60e830a}, {pos = 711897992, events = 8, fd = 711990648, user_data = 0x82117eda8}, {pos = 555216416, events = 8, fd = 555216296, user_data = 0x82a6fa194}, {pos = 568710152, events = 8, fd = 711958932, user_data = 0x82117ee10}, {pos = -703712198, events = 12655, fd = 713781296, user_data = 0x1}, {pos = 555216448, events = 8, fd = -703692022, user_data = 0x82a6e3858}, {pos = 711990648, events = 8, fd = 555216408, user_data = 0x82117ee90}, {pos = 555216408, events = 8, fd = 711953676, user_data = 0x821e5d408}, {pos = 711953676, events = 8, fd = 555216512, user_data = 0x316fd60e343a}, {pos = 555216552, events = 8, fd = 555217000, user_data = 0x82117ee90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 918359258, fd = 568733752, user_data = 0x800000001}, {pos = 568710152, events = 8, fd = 711897992, user_data = 0x821e62288}, {pos = 711866456, events = 8, fd = 568710152, user_data = 0x82117ef18}, {pos = 555217112, events = 8, fd = 555216640, user_data = 0x316fd60e7ca2}, {pos = 2699788, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 568733752, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 555217368, user_data = 0x21e5d408}, {pos = 555217184, events = 8, fd = 555216784, user_data = 0x1}, {pos = 555217112, events = 8, fd = 32, user_data = 0x82117ef80}, {pos = -703694221, events = 12655, fd = 555217056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821e63038}, {pos = 1, events = 8, fd = 568710152, user_data = 0x82a6e3858}, {pos = 555217368, events = 8, fd = 555217184, user_data = 0x82117ef90}, {pos = 0, events = 0, fd = 568680456, user_data = 0x20}, {pos = 555217168, events = 8, fd = -703718681, user_data = 0x821e56008}, {pos = 568681480, events = 8, fd = 568682504, user_data = 0x821e56c08}, {pos = 568696840, events = 8, fd = 568697864, user_data = 0x821e5a808}, {pos = 568699912, events = 8, fd = 568700936, user_data = 0x821e5b408}, {pos = 568702984, events = 8, fd = 568704008, user_data = 0x821e5c008}, {pos = 568706056, events = 8, fd = 568707080, user_data = 0x821e5cc08}, {pos = 568709128, events = 8, fd = 568710152, user_data = 0x821e5d808}, {pos = 568712200, events = 8, fd = 568713224, user_data = 0x821e5e408}, {pos = 568715272, events = 8, fd = 568716296, user_data = 0x821e5f008}, {pos = 568718344, events = 8, fd = 568719368, user_data = 0x821e5fc08}, {pos = 568725512, events = 8, fd = 568726536, user_data = 0x821e61808}, {pos = 568728584, events = 8, fd = 568680456, user_data = 0x29320c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821e63038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555217368, events = 8, fd = 555216784, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 568733752, user_data = 0x1}, {pos = 568680456, events = 8, fd = 313, user_data = 0x82117f1c0}, {pos = -703719953, events = 12655, fd = 2699788, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 568733752, user_data = 0x1}, {pos = 568710152, events = 8, fd = 924262400, user_data = 0x1}, {pos = 924262804, events = 8, fd = 0, user_data = 0x82117f190}, {pos = 730821996, events = 8, fd = 1, user_data = 0x837172000}, {pos = 555217344, events = 8, fd = 730818306, user_data = 0x82a815170 }, {pos = 12272112, events = 0, fd = 713118064, user_data = 0x821e5d408}, {pos = 555217568, events = 8, fd = -703720482, user_data = 0x837190800}, {pos = 1, events = 0, fd = -703720866, user_data = 0x821e56008}, {pos = 555217352, events = 8, fd = 555217568, user_data = 0x1c20}, {pos = 924335872, events = 8, fd = -703641200, user_data = 0x0}, {pos = 555156351, events = 8, fd = 8085527, user_data = 0x82117f250}, {pos = 730780688, events = 8, fd = 713781296, user_data = 0x82a8b9310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82117f280}, {pos = 730823581, events = 8, fd = 924262400, user_data = 0x1da7}, {pos = 555217632, events = 8, fd = 730790138, user_data = 0x0}, {pos = 0, events = 0, fd = 888376807, user_data = 0x0}} [19:29:54.496] last_touch_time = 1725909938 [19:29:54.496] last_lockfile_recheck_time = 1725909938 [19:29:54.496] nevents = 1 [19:29:54.496] #21 0x0000000000887165 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82117f8c8) at ../src/backend/postmaster/postmaster.c:1346 [19:29:54.496] userDoption = [19:29:54.496] listen_addr_saved = [19:29:54.496] output_config_variable = [19:29:54.496] opt = [19:29:54.496] status = [19:29:54.496] #22 0x00000000007c2cfc in main (argc=8, argv=0x82117f8c8) at ../src/backend/main/main.c:197 [19:29:54.496] do_check_root = [19:29:54.509] [19:29:54.509] [19:29:54.509] [19:29:54.576] dumping /tmp/cores/postgres.11304.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:29:54.698] [New LWP 101853] [19:29:54.769] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [19:29:54.769] Program terminated with signal SIGABRT, Aborted. [19:29:54.769] Sent by thr_kill() from pid 11304 and user 1003. [19:29:54.769] #0 0x000000082bfb241a in thr_kill () from /lib/libc.so.7 [19:29:55.336] [19:29:55.336] Thread 1 (LWP 101853): [19:29:55.336] #0 0x000000082bfb241a in thr_kill () from /lib/libc.so.7 [19:29:55.336] No symbol table info available. [19:29:55.336] #1 0x000000082bf2be64 in raise () from /lib/libc.so.7 [19:29:55.336] No symbol table info available. [19:29:55.336] #2 0x000000082bfdc6f9 in abort () from /lib/libc.so.7 [19:29:55.336] No symbol table info available. [19:29:55.336] #3 0x0000000000a896e5 in ExceptionalCondition (conditionName=0x2e61a0 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [19:29:55.336] No locals. [19:29:55.336] #4 0x000000000075fb39 in standard_ExecutorStart (queryDesc=0x838a55390, eflags=0) at ../src/backend/executor/execMain.c:191 [19:29:55.336] estate = 0x848040100 [19:29:55.336] oldcontext = 0x838a70800 [19:29:55.336] #5 0x00000000006f6945 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [19:29:55.336] copied_query = [19:29:55.336] rewritten = [19:29:55.336] plan = 0x838a55038 [19:29:55.336] queryDesc = 0x838a55390 [19:29:55.336] processed = [19:29:55.336] __error = [19:29:55.336] #6 RefreshMatViewByOid (matviewOid=27057, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [19:29:55.336] dest = [19:29:55.336] save_userid = 10 [19:29:55.336] save_sec_context = 0 [19:29:55.336] processed = 0 [19:29:55.336] matviewRel = 0x847f67400 [19:29:55.336] relowner = 10 [19:29:55.336] save_nestlevel = 2 [19:29:55.336] rule = [19:29:55.336] actions = [19:29:55.336] dataQuery = [19:29:55.336] tableSpace = [19:29:55.336] relpersistence = [19:29:55.336] OIDNewHeap = 27075 [19:29:55.336] address = [19:29:55.336] #7 0x00000000006f6526 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:29:55.336] lockmode = [19:29:55.336] matviewOid = 0 [19:29:55.336] #8 0x00000000006ce32c in ExecCreateTableAs (pstate=pstate@entry=0x838a70900, stmt=stmt@entry=0x838982fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8216ab170) at ../src/backend/commands/createas.c:350 [19:29:55.336] refresh = 0x0 [19:29:55.336] query = 0x838a3ef58 [19:29:55.336] into = 0x838a3f2a0 [19:29:55.336] do_refresh = false [19:29:55.336] address = [19:29:55.336] dest = [19:29:55.336] is_matview = [19:29:55.336] #9 0x0000000000936b58 in ProcessUtilitySlow (pstate=pstate@entry=0x838a70900, pstmt=pstmt@entry=0x8388bba68, queryString=queryString@entry=0x8388ba100 "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=0x8216ab170) at ../src/backend/tcop/utility.c:1675 [19:29:55.336] _local_sigjmp_buf = {{_sjb = {9659273, 0, 34920377752, 34920378128, 34920377760, 12338344, 0, 35310209280, 4294902655, 34920377868, 34920377904, 0}}} [19:29:55.336] _save_exception_stack = 0x8216ab070 [19:29:55.336] _save_context_stack = 0x0 [19:29:55.336] _do_rethrow = false [19:29:55.336] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:29:55.336] parsetree = 0x838982fd0 [19:29:55.336] commandCollected = false [19:29:55.336] needCleanup = false [19:29:55.336] address = [19:29:55.336] isTopLevel = [19:29:55.336] isCompleteQuery = [19:29:55.336] #10 0x00000000009354d8 in standard_ProcessUtility (pstmt=0x8388bba68, queryString=0x8388ba100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838a3f788, qc=0x8216ab170) at ../src/backend/tcop/utility.c:1030 [19:29:55.336] isAtomicContext = false [19:29:55.336] parsetree = 0x838982fd0 [19:29:55.336] readonly_flags = [19:29:55.336] pstate = 0x838a70900 [19:29:55.336] isTopLevel = [19:29:55.336] #11 0x0000000000934f68 in ProcessUtility (pstmt=0x18ddd, queryString=0x6 , readOnlyTree=, context=737879034, params=0x0, queryEnv=0x0, dest=0x838a3f788, qc=0x8216ab170) at ../src/backend/tcop/utility.c:523 [19:29:55.336] No locals. [19:29:55.336] #12 0x0000000000934aa3 in PortalRunUtility (portal=0x838960100, pstmt=0x8388bba68, isTopLevel=, setHoldSnapshot=, dest=0x838a3f788, qc=0x8216ab170) at ../src/backend/tcop/pquery.c:1158 [19:29:55.336] No locals. [19:29:55.336] #13 0x0000000000934134 in PortalRunMulti (portal=portal@entry=0x838960100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x838a3f788, altdest=altdest@entry=0x838a3f788, qc=0x8216ab170) at ../src/backend/tcop/pquery.c:1323 [19:29:55.336] pstmt = 0x8388bba68 [19:29:55.336] stmtlist_item__state = {l = 0x838a3f738, i = 0} [19:29:55.336] active_snapshot_set = false [19:29:55.336] stmtlist_item = 0x838a3f750 [19:29:55.336] #14 0x0000000000933a03 in PortalRun (portal=portal@entry=0x838960100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x838a3f788, altdest=altdest@entry=0x838a3f788, qc=0x8216ab170) at ../src/backend/tcop/pquery.c:791 [19:29:55.336] _local_sigjmp_buf = {{_sjb = {9648509, 35309093120, 34920378472, 34920378704, 34920378480, 35309109248, 12305016, 12338344, 35309093759, 35309229456, 4294967984, 0}}} [19:29:55.336] _save_exception_stack = 0x8216ab240 [19:29:55.336] _save_context_stack = 0x0 [19:29:55.336] _do_rethrow = false [19:29:55.336] saveTopTransactionResourceOwner = 0x8389af758 [19:29:55.336] saveTopTransactionContext = 0x838964000 [19:29:55.336] saveActivePortal = 0x0 [19:29:55.336] saveResourceOwner = 0x8389af758 [19:29:55.336] savePortalContext = 0x0 [19:29:55.336] saveMemoryContext = 0x838964000 [19:29:55.336] result = [19:29:55.336] nprocessed = [19:29:55.336] #15 0x00000000009328a2 in exec_simple_query (query_string=query_string@entry=0x8388ba100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [19:29:55.336] cmdtaglen = 24 [19:29:55.336] snapshot_set = [19:29:55.336] per_parsetree_context = 0x0 [19:29:55.336] plantree_list = [19:29:55.336] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:29:55.336] format = 0 [19:29:55.336] parsetree = 0x8388bb6a8 [19:29:55.336] commandTag = [19:29:55.336] cmdtagname = [19:29:55.336] querytree_list = [19:29:55.336] portal = 0x838960100 [19:29:55.336] receiver = 0x838a3f788 [19:29:55.336] parsetree_item__state = {l = 0x8388bba18, i = 0} [19:29:55.336] msec_str = "\000\000\000\000\b", '\000' , "\310K\337f\000\000\000\0001\0248\363\212Xes" [19:29:55.336] dest = DestRemote [19:29:55.336] was_logged = [19:29:55.336] oldcontext = 0x838964000 [19:29:55.336] parsetree_list = 0x8388bba18 [19:29:55.336] use_implicit_block = false [19:29:55.336] parsetree_item = 0x8388bba30 [19:29:55.336] save_log_statement_stats = [19:29:55.336] #16 0x0000000000930610 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [19:29:55.336] query_string = 0x8388ba100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:29:55.336] input_message = {data = 0x8388ba100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:29:55.336] firstchar = [19:29:55.336] local_sigjmp_buf = {{_sjb = {9632422, 34920378944, 34920378904, 34920379488, 12347080, 1, 8192, 8388608, 34920334207, 0, 0, 1}}} [19:29:55.336] send_ready_for_query = false [19:29:55.336] idle_in_transaction_timeout_enabled = false [19:29:55.336] idle_session_timeout_enabled = false [19:29:55.336] #17 0x000000000092ade9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:29:55.336] bsdata = [19:29:55.336] #18 0x0000000000884f87 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8216abf84 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8216abec0) at ../src/backend/postmaster/launch_backend.c:274 [19:29:55.336] pid = [19:29:55.336] #19 0x0000000000889348 in BackendStartup (client_sock=0x8216abec0) at ../src/backend/postmaster/postmaster.c:3415 [19:29:55.336] startup_data = {canAcceptConnections = CAC_OK} [19:29:55.336] bn = 0x8388c64e8 [19:29:55.336] pid = [19:29:55.336] __error = [19:29:55.336] save_errno = [19:29:55.336] __error = [19:29:55.336] __error = [19:29:55.336] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:29:55.336] 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\276\2138\b", '\000' , " \277j!\b\000\000\000h\025<+\b\000\000\000\v\000\000\000\000\000\000\000^\237<+\b", '\000' , "`\277j!\b\000\000\0004M\210\000\000\000\000\000p\277j!\b", '\000' }, salen = 16}} [19:29:55.336] i = 0 [19:29:55.336] now = [19:29:55.336] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 737504386, events = 8, fd = 0, user_data = 0x8216abe70}, {pos = 949110232, events = 8, fd = 560643328, user_data = 0x0}, {pos = 0, events = 0, fd = 459036852, user_data = 0x37425ee6f30a}, {pos = 736671648, events = 8, fd = 736742776, user_data = 0x8216ab988}, {pos = 560642560, events = 8, fd = 560642440, user_data = 0x37425ee6f30a}, {pos = 736650120, events = 8, fd = 736742776, user_data = 0x8216ab9b8}, {pos = 560642608, events = 8, fd = 560642488, user_data = 0x82be95194}, {pos = 567092232, events = 8, fd = 736711060, user_data = 0x8216aba20}, {pos = 1592173626, events = 14146, fd = 738533424, user_data = 0x1}, {pos = 560642640, events = 8, fd = 1592193802, user_data = 0x82be7e858}, {pos = 736742776, events = 8, fd = 560642600, user_data = 0x8216abaa0}, {pos = 560642600, events = 8, fd = 736705804, user_data = 0x821cd2408}, {pos = 736705804, events = 8, fd = 560642704, user_data = 0x37425ee6a43a}, {pos = 560642744, events = 8, fd = 560643192, user_data = 0x8216abaa0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2946641095, fd = 567115832, user_data = 0x800000001}, {pos = 567092232, events = 8, fd = 736650120, user_data = 0x821cd7288}, {pos = 736618584, events = 8, fd = 567092232, user_data = 0x8216abb28}, {pos = 560643304, events = 8, fd = 560642832, user_data = 0x37425ee6eca2}, {pos = 2699788, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 567115832, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 560643560, user_data = 0x21cd2408}, {pos = 560643376, events = 8, fd = 560642976, user_data = 0x1}, {pos = 560643304, events = 8, fd = 32, user_data = 0x8216abb90}, {pos = 1592191603, events = 14146, fd = 560643248, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821cd8038}, {pos = 1, events = 8, fd = 567092232, user_data = 0x82be7e858}, {pos = 560643560, events = 8, fd = 560643376, user_data = 0x8216abba0}, {pos = 0, events = 0, fd = 567062536, user_data = 0x20}, {pos = 560643360, events = 8, fd = 1592167143, user_data = 0x821ccb008}, {pos = 567063560, events = 8, fd = 567064584, user_data = 0x821ccbc08}, {pos = 567078920, events = 8, fd = 567079944, user_data = 0x821ccf808}, {pos = 567081992, events = 8, fd = 567083016, user_data = 0x821cd0408}, {pos = 567085064, events = 8, fd = 567086088, user_data = 0x821cd1008}, {pos = 567088136, events = 8, fd = 567089160, user_data = 0x821cd1c08}, {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 = 567107592, events = 8, fd = 567108616, user_data = 0x821cd6808}, {pos = 567110664, events = 8, fd = 567062536, user_data = 0x29320c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821cd8038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 560643560, events = 8, fd = 560642976, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 567115832, user_data = 0x1}, {pos = 567062536, events = 8, fd = 313, user_data = 0x8216abdd0}, {pos = 1592165871, events = 14146, fd = 2699788, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 567115832, user_data = 0x1}, {pos = 567092232, events = 8, fd = 948609024, user_data = 0x1}, {pos = 948609428, events = 8, fd = 0, user_data = 0x8216abda0}, {pos = 725390700, events = 8, fd = 1, user_data = 0x8388aa000}, {pos = 560643536, events = 8, fd = 725387010, user_data = 0x82bfb0170 }, {pos = 12272112, events = 0, fd = 737870192, user_data = 0x821cd2408}, {pos = 560643760, events = 8, fd = 1592165342, user_data = 0x8388c8800}, {pos = 1, events = 0, fd = 1592164958, user_data = 0x821ccb008}, {pos = 560643544, events = 8, fd = 560643760, user_data = 0x1c20}, {pos = 948682432, events = 8, fd = 1592244624, user_data = 0x0}, {pos = 560595839, events = 8, fd = 8085527, user_data = 0x8216abe60}, {pos = 725349392, events = 8, fd = 738533424, user_data = 0x82c054310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8216abe90}, {pos = 725392285, events = 8, fd = 948609024, user_data = 0x1e1d}, {pos = 560643824, events = 8, fd = 725358842, user_data = 0x0}, {pos = 0, events = 0, fd = 459036852, user_data = 0x0}} [19:29:55.337] last_touch_time = 1725909939 [19:29:55.337] last_lockfile_recheck_time = 1725909939 [19:29:55.337] nevents = 1 [19:29:55.337] #21 0x0000000000887165 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8216ac4d8) at ../src/backend/postmaster/postmaster.c:1346 [19:29:55.337] userDoption = [19:29:55.337] listen_addr_saved = [19:29:55.337] output_config_variable = [19:29:55.337] opt = [19:29:55.337] status = [19:29:55.337] #22 0x00000000007c2cfc in main (argc=4, argv=0x8216ac4d8) at ../src/backend/main/main.c:197 [19:29:55.337] do_check_root = [19:29:55.350] [19:29:55.350] [19:29:55.350] [19:29:55.413] dumping /tmp/cores/postgres.16770.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [19:29:55.535] [New LWP 101824] [19:29:55.604] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [19:29:55.604] Program terminated with signal SIGABRT, Aborted. [19:29:55.604] Sent by thr_kill() from pid 16770 and user 1003. [19:29:55.604] #0 0x000000082a27841a in thr_kill () from /lib/libc.so.7 [19:29:56.165] [19:29:56.165] Thread 1 (LWP 101824): [19:29:56.165] #0 0x000000082a27841a in thr_kill () from /lib/libc.so.7 [19:29:56.165] No symbol table info available. [19:29:56.165] #1 0x000000082a1f1e64 in raise () from /lib/libc.so.7 [19:29:56.165] No symbol table info available. [19:29:56.165] #2 0x000000082a2a26f9 in abort () from /lib/libc.so.7 [19:29:56.165] No symbol table info available. [19:29:56.165] #3 0x0000000000a896e5 in ExceptionalCondition (conditionName=0x2e61a0 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=191) at ../src/backend/utils/error/assert.c:66 [19:29:56.165] No locals. [19:29:56.165] #4 0x000000000075fb39 in standard_ExecutorStart (queryDesc=0x838f25380, eflags=0) at ../src/backend/executor/execMain.c:191 [19:29:56.165] estate = 0x8335ad100 [19:29:56.165] oldcontext = 0x83356b800 [19:29:56.165] #5 0x000000083594c862 in pgss_ExecutorStart (queryDesc=0x838f25380, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:993 [19:29:56.165] No locals. [19:29:56.165] #6 0x00000000006f6945 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [19:29:56.165] copied_query = [19:29:56.165] rewritten = [19:29:56.165] plan = 0x833627f00 [19:29:56.165] queryDesc = 0x838f25380 [19:29:56.165] processed = [19:29:56.165] __error = [19:29:56.165] #7 RefreshMatViewByOid (matviewOid=27244, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [19:29:56.165] dest = [19:29:56.165] save_userid = 10 [19:29:56.165] save_sec_context = 0 [19:29:56.165] processed = 0 [19:29:56.165] matviewRel = 0x838eccc58 [19:29:56.165] relowner = 10 [19:29:56.165] save_nestlevel = 2 [19:29:56.165] rule = [19:29:56.165] actions = [19:29:56.165] dataQuery = [19:29:56.165] tableSpace = [19:29:56.165] relpersistence = [19:29:56.165] OIDNewHeap = 27251 [19:29:56.165] address = [19:29:56.165] #8 0x00000000006f6526 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [19:29:56.165] lockmode = [19:29:56.165] matviewOid = 0 [19:29:56.165] #9 0x00000000006ce32c in ExecCreateTableAs (pstate=pstate@entry=0x83356b900, stmt=stmt@entry=0x833539fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82181f2d0) at ../src/backend/commands/createas.c:350 [19:29:56.165] refresh = 0x0 [19:29:56.165] query = 0x8336290c8 [19:29:56.165] into = 0x833539f40 [19:29:56.165] do_refresh = false [19:29:56.165] address = [19:29:56.165] dest = [19:29:56.165] is_matview = [19:29:56.165] #10 0x0000000000936b58 in ProcessUtilitySlow (pstate=pstate@entry=0x83356b900, pstmt=pstmt@entry=0x833539e30, queryString=queryString@entry=0x83349c100 "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=0x82181f2d0) at ../src/backend/tcop/utility.c:1675 [19:29:56.165] _local_sigjmp_buf = {{_sjb = {9659273, 0, 34921901368, 34921901744, 34921901376, 12338344, 0, 35221059840, 34921841535, 7, 34921901520, 0}}} [19:29:56.165] _save_exception_stack = 0x82181efc0 [19:29:56.165] _save_context_stack = 0x0 [19:29:56.165] _do_rethrow = false [19:29:56.165] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [19:29:56.165] parsetree = 0x833539fd0 [19:29:56.165] commandCollected = false [19:29:56.165] needCleanup = false [19:29:56.165] address = [19:29:56.165] isTopLevel = [19:29:56.165] isCompleteQuery = [19:29:56.165] #11 0x00000000009354d8 in standard_ProcessUtility (pstmt=0x833539e30, queryString=queryString@entry=0x83349c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x833629868, qc=0x82181f2d0) at ../src/backend/tcop/utility.c:1030 [19:29:56.165] isAtomicContext = false [19:29:56.165] parsetree = 0x833539fd0 [19:29:56.165] readonly_flags = [19:29:56.165] pstate = 0x83356b900 [19:29:56.165] isTopLevel = [19:29:56.165] #12 0x000000083594cdee in pgss_ProcessUtility (pstmt=0x833539e30, queryString=0x83349c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x833629868, qc=0x82181f2d0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1167 [19:29:56.165] _local_sigjmp_buf = {{_sjb = {35258682663, 34921902016, 34921901880, 34921902336, 35220856368, 0, 12338344, 34921902544, 34921841535, 34921902116, 34921902144, 0}}} [19:29:56.165] _save_exception_stack = 0x82181f1d0 [19:29:56.165] _save_context_stack = 0x0 [19:29:56.165] _do_rethrow = false [19:29:56.165] bufusage = {shared_blks_hit = 35258682663, shared_blks_read = 34921902016, shared_blks_dirtied = 34921901880, shared_blks_written = 34921902336, local_blks_hit = 35220856368, local_blks_read = 0, local_blks_dirtied = 12338344, local_blks_written = 34921902544, temp_blks_read = 34921841535, temp_blks_written = 34921902116, shared_blk_read_time = {ticks = 34921902144}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 3975637238681393408}, local_blk_write_time = {ticks = 12347384}, temp_blk_read_time = {ticks = 35289577088}, temp_blk_write_time = {ticks = 12300960}} [19:29:56.165] walusage_start = {wal_records = 8934, wal_fpi = 121, wal_bytes = 1213540} [19:29:56.165] duration = [19:29:56.165] bufusage_start = {shared_blks_hit = 150979, shared_blks_read = 8166, shared_blks_dirtied = 2537, shared_blks_written = 2370, 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}} [19:29:56.165] walusage = {wal_records = 6874657567478049477, wal_fpi = 35220856784, wal_bytes = 123} [19:29:56.165] start = {ticks = -178613906235} [19:29:56.165] rows = [19:29:56.165] saved_queryId = 6041762721901209185 [19:29:56.165] parsetree = [19:29:56.165] saved_stmt_location = 0 [19:29:56.165] saved_stmt_len = 69 [19:29:56.165] enabled = [19:29:56.165] #13 0x0000000000934aa3 in PortalRunUtility (portal=0x833544100, pstmt=0x833539e30, isTopLevel=, setHoldSnapshot=, dest=0x833629868, qc=0x82181f2d0) at ../src/backend/tcop/pquery.c:1158 [19:29:56.165] No locals. [19:29:56.165] #14 0x0000000000934134 in PortalRunMulti (portal=portal@entry=0x833544100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x833629868, altdest=altdest@entry=0x833629868, qc=0x82181f2d0) at ../src/backend/tcop/pquery.c:1323 [19:29:56.165] pstmt = 0x833539e30 [19:29:56.165] stmtlist_item__state = {l = 0x833629818, i = 0} [19:29:56.165] active_snapshot_set = false [19:29:56.165] stmtlist_item = 0x833629830 [19:29:56.165] #15 0x0000000000933a03 in PortalRun (portal=portal@entry=0x833544100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x833629868, altdest=altdest@entry=0x833629868, qc=0x82181f2d0) at ../src/backend/tcop/pquery.c:791 [19:29:56.165] _local_sigjmp_buf = {{_sjb = {9648509, 35220898048, 34921902536, 34921902768, 34921902544, 35220992000, 12305016, 12338344, 35220882303, 35220850144, 4294967984, 0}}} [19:29:56.165] _save_exception_stack = 0x82181f3a0 [19:29:56.165] _save_context_stack = 0x0 [19:29:56.165] _do_rethrow = false [19:29:56.165] saveTopTransactionResourceOwner = 0x833592658 [19:29:56.165] saveTopTransactionContext = 0x83355b000 [19:29:56.165] saveActivePortal = 0x0 [19:29:56.165] saveResourceOwner = 0x833592658 [19:29:56.165] savePortalContext = 0x0 [19:29:56.165] saveMemoryContext = 0x83355b000 [19:29:56.165] result = [19:29:56.165] nprocessed = [19:29:56.165] #16 0x00000000009328a2 in exec_simple_query (query_string=query_string@entry=0x83349c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1284 [19:29:56.165] cmdtaglen = 24 [19:29:56.165] snapshot_set = [19:29:56.165] per_parsetree_context = 0x0 [19:29:56.165] plantree_list = [19:29:56.165] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [19:29:56.165] format = 0 [19:29:56.165] parsetree = 0x83349d6a8 [19:29:56.165] commandTag = [19:29:56.165] cmdtagname = [19:29:56.165] querytree_list = [19:29:56.165] portal = 0x833544100 [19:29:56.165] receiver = 0x833629868 [19:29:56.165] parsetree_item__state = {l = 0x83349da18, i = 0} [19:29:56.165] msec_str = "\000\000\000\000\b", '\000' , "\346K\337f\000\000\000\000\245\020\235\223\313\030", [19:29:56.165] dest = DestRemote [19:29:56.165] was_logged = [19:29:56.165] oldcontext = 0x83355b000 [19:29:56.165] parsetree_list = 0x83349da18 [19:29:56.165] use_implicit_block = false [19:29:56.165] parsetree_item = 0x83349da30 [19:29:56.165] save_log_statement_stats = [19:29:56.165] #17 0x0000000000930610 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [19:29:56.165] query_string = 0x83349c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [19:29:56.165] input_message = {data = 0x83349c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [19:29:56.165] firstchar = [19:29:56.165] local_sigjmp_buf = {{_sjb = {9632422, 34921903008, 34921902968, 34921903552, 12347080, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [19:29:56.165] send_ready_for_query = false [19:29:56.165] idle_in_transaction_timeout_enabled = false [19:29:56.165] idle_session_timeout_enabled = false [19:29:56.165] #18 0x000000000092ade9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [19:29:56.165] bsdata = [19:29:56.165] #19 0x0000000000884f87 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8218200e4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821820020) at ../src/backend/postmaster/launch_backend.c:274 [19:29:56.165] pid = [19:29:56.165] #20 0x0000000000889348 in BackendStartup (client_sock=0x821820020) at ../src/backend/postmaster/postmaster.c:3415 [19:29:56.165] startup_data = {canAcceptConnections = CAC_OK} [19:29:56.165] bn = 0x8334a82b8 [19:29:56.165] pid = [19:29:56.165] __error = [19:29:56.165] save_errno = [19:29:56.165] __error = [19:29:56.165] __error = [19:29:56.165] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [19:29:56.165] 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 = " \314I3\b", '\000' , "\200\000\202!\b\000\000\000hƠ­)\b\000\000\000\v\000\000\000\000\000\000\000^_\256)\b", '\000' , "\300\000\202!\b\000\000\0004M\210\000\000\000\000\000\320\000\202!\b", '\000' }, salen = 16}} [19:29:56.165] i = 0 [19:29:56.165] now = [19:29:56.165] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 706858114, events = 8, fd = 0, user_data = 0x82181ffd0}, {pos = 860878296, events = 8, fd = 562167392, user_data = 0x0}, {pos = -1241316598, events = 4042, fd = 706025376, user_data = 0x82a162d78}, {pos = 562166488, events = 8, fd = 562166608, user_data = 0x82181fad8}, {pos = -1241316598, events = 4042, fd = 706003848, user_data = 0x82a162d78}, {pos = 562166536, events = 8, fd = 562166656, user_data = 0x82181fb08}, {pos = 706064788, events = 8, fd = 567452680, user_data = 0x82a15b194}, {pos = 562166640, events = 8, fd = -1241336774, user_data = 0x82181fb10}, {pos = 699249680, events = 8, fd = 707887152, user_data = 0xfcab603030a}, {pos = 705972312, events = 8, fd = 706096504, user_data = 0x82181fb78}, {pos = 562166768, events = 8, fd = 562166648, user_data = 0x82a159d0c}, {pos = 567452680, events = 8, fd = 706059532, user_data = 0x82181fbe0}, {pos = -1241336774, events = 4042, fd = 562166792, user_data = 0x82181fdd8}, {pos = 562166768, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821d30038}, {pos = 1, events = 1600630946, fd = 567452680, user_data = 0x82a14c388}, {pos = 567474120, events = 8, fd = 0, user_data = 0x0}, {pos = 562166904, events = 8, fd = 562167368, user_data = 0x82181fc60}, {pos = -1241318238, events = 4042, fd = 2699788, user_data = 0x6d68b}, {pos = 2090263927, events = 1600630946, fd = 567476280, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82181ff48}, {pos = 567452680, events = 3, fd = 562167440, user_data = 0x821d2f828}, {pos = 656, events = 0, fd = 562167368, user_data = 0x82181fc78}, {pos = 562167008, events = 8, fd = -1241318629, user_data = 0x82181fe10}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567476280, events = 8, fd = 1, user_data = 0x821d2a408}, {pos = 705972312, events = 8, fd = 562167624, user_data = 0x82181fe90}, {pos = 562167024, events = 8, fd = 0, user_data = 0x821d23008}, {pos = 33, events = 0, fd = 562167424, user_data = 0xfcab6029ae7}, {pos = 567422984, events = 8, fd = 567424008, user_data = 0x821d23808}, {pos = 567426056, events = 8, fd = 567439368, user_data = 0x821d27408}, {pos = 567441416, events = 8, fd = 567442440, user_data = 0x821d28008}, {pos = 567444488, events = 8, fd = 567445512, user_data = 0x821d28c08}, {pos = 567447560, events = 8, fd = 567448584, user_data = 0x821d29808}, {pos = 567450632, events = 8, fd = 567451656, user_data = 0x821d2a408}, {pos = 567453704, events = 8, fd = 567454728, user_data = 0x821d2b008}, {pos = 567456776, events = 8, fd = 567457800, user_data = 0x821d2bc08}, {pos = 567459848, events = 8, fd = 567460872, user_data = 0x821d2c808}, {pos = 567462920, events = 8, fd = 567468040, user_data = 0x821d2e408}, {pos = 567470088, events = 8, fd = 567471112, user_data = 0x821d31408}, {pos = 741765000, events = 0, fd = 567422984, user_data = 0x29320c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821d30038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 562167624, events = 8, fd = 562167024, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 567476280, user_data = 0x1}, {pos = 567422984, events = 8, fd = 313, user_data = 0x82181ff30}, {pos = -1241344529, events = 4042, fd = 2699788, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 567476280, user_data = 0x1}, {pos = 567452680, events = 8, fd = 860405760, user_data = 0x1}, {pos = 860406164, events = 8, fd = 0, user_data = 0x82181ff00}, {pos = 699290988, events = 8, fd = 1, user_data = 0x83348c000}, {pos = 562167600, events = 8, fd = 699287298, user_data = 0x82a276170 }, {pos = 12272112, events = 0, fd = 707223920, user_data = 0x821d2a408}, {pos = 562167824, events = 8, fd = -1241345058, user_data = 0x8334aa800}, {pos = 1, events = 0, fd = -1241345442, user_data = 0x821d23008}, {pos = 562167608, events = 8, fd = 562167824, user_data = 0x1c20}, {pos = 860474400, events = 8, fd = -1241265776, user_data = 0x0}, {pos = 562168703, events = 8, fd = 8085527, user_data = 0x82181ffc0}, {pos = 699249680, events = 8, fd = 707887152, user_data = 0x82a31a310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82181fff0}, {pos = 699292573, events = 8, fd = 860405760, user_data = 0x35d4}, {pos = 562167888, events = 8, fd = 699259130, user_data = 0x0}, {pos = 0, events = 0, fd = 1442507461, user_data = 0x0}} [19:29:56.165] last_touch_time = 1725909970 [19:29:56.165] last_lockfile_recheck_time = 1725909970 [19:29:56.165] nevents = 1 [19:29:56.165] #22 0x0000000000887165 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821820630) at ../src/backend/postmaster/postmaster.c:1346 [19:29:56.165] userDoption = [19:29:56.165] listen_addr_saved = [19:29:56.165] output_config_variable = [19:29:56.165] opt = [19:29:56.165] status = [19:29:56.165] #23 0x00000000007c2cfc in main (argc=4, argv=0x821820630) at ../src/backend/main/main.c:197 [19:29:56.165] do_check_root =