[03:48:09.191] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [03:48:09.526] dumping /tmp/cores/postgres.10711.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:48:09.658] [New LWP 101914] [03:48:09.740] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:48:09.740] Program terminated with signal SIGABRT, Aborted. [03:48:09.740] Sent by thr_kill() from pid 10711 and user 1003. [03:48:09.740] #0 0x000000082e26541a in thr_kill () from /lib/libc.so.7 [03:48:09.794] [03:48:09.794] Thread 1 (LWP 101914): [03:48:09.794] #0 0x000000082e26541a in thr_kill () from /lib/libc.so.7 [03:48:09.794] No symbol table info available. [03:48:09.794] #1 0x000000082e1dee64 in raise () from /lib/libc.so.7 [03:48:09.794] No symbol table info available. [03:48:09.794] #2 0x000000082e28f6f9 in abort () from /lib/libc.so.7 [03:48:09.794] No symbol table info available. [03:48:09.794] #3 0x0000000000a965e5 in ExceptionalCondition (conditionName=0x2e7bd6 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:48:09.794] No locals. [03:48:09.794] #4 0x0000000000767059 in standard_ExecutorStart (queryDesc=0x8375f6088, eflags=0) at ../src/backend/executor/execMain.c:194 [03:48:09.794] estate = 0x83764b100 [03:48:09.794] oldcontext = 0x837688800 [03:48:09.794] #5 0x00000000006fdd75 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:48:09.794] copied_query = [03:48:09.794] rewritten = [03:48:09.794] plan = 0x83767cbd8 [03:48:09.794] queryDesc = 0x8375f6088 [03:48:09.794] processed = [03:48:09.794] __error = [03:48:09.794] #6 RefreshMatViewByOid (matviewOid=27475, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:48:09.794] dest = [03:48:09.794] save_userid = 10 [03:48:09.794] save_sec_context = 0 [03:48:09.794] processed = 0 [03:48:09.794] matviewRel = 0x83a4ddd48 [03:48:09.794] relowner = 10 [03:48:09.794] save_nestlevel = 2 [03:48:09.794] rule = [03:48:09.794] actions = [03:48:09.794] dataQuery = [03:48:09.794] tableSpace = [03:48:09.794] relpersistence = [03:48:09.794] OIDNewHeap = 27482 [03:48:09.794] address = [03:48:09.794] #7 0x00000000006fd956 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:48:09.794] lockmode = [03:48:09.794] matviewOid = 0 [03:48:09.794] #8 0x00000000006d4a6c in ExecCreateTableAs (pstate=pstate@entry=0x837688900, stmt=stmt@entry=0x837681fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821494380) at ../src/backend/commands/createas.c:351 [03:48:09.794] refresh = 0x0 [03:48:09.794] query = 0x83a6099d8 [03:48:09.794] into = 0x83a609d20 [03:48:09.794] jstate = 0x0 [03:48:09.794] do_refresh = false [03:48:09.794] address = [03:48:09.794] dest = [03:48:09.794] is_matview = [03:48:09.794] #9 0x0000000000942318 in ProcessUtilitySlow (pstate=pstate@entry=0x837688900, pstmt=pstmt@entry=0x8374f1a68, queryString=queryString@entry=0x8374f0100 "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=0x821494380) at ../src/backend/tcop/utility.c:1675 [03:48:09.794] _local_sigjmp_buf = {{_sjb = {9706313, 0, 34918186920, 34918187296, 34918186928, 12393720, 0, 35289336064, 4294902655, 34918187036, 34918187072, 0}}} [03:48:09.794] _save_exception_stack = 0x821494280 [03:48:09.794] _save_context_stack = 0x0 [03:48:09.794] _do_rethrow = false [03:48:09.794] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:48:09.794] parsetree = 0x837681fd0 [03:48:09.794] commandCollected = false [03:48:09.794] needCleanup = false [03:48:09.794] address = [03:48:09.794] isTopLevel = [03:48:09.794] isCompleteQuery = [03:48:09.794] #10 0x0000000000940c98 in standard_ProcessUtility (pstmt=0x8374f1a68, queryString=0x8374f0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83a60a208, qc=0x821494380) at ../src/backend/tcop/utility.c:1030 [03:48:09.794] isAtomicContext = false [03:48:09.794] parsetree = 0x837681fd0 [03:48:09.794] readonly_flags = [03:48:09.794] pstate = 0x837688900 [03:48:09.794] isTopLevel = [03:48:09.794] #11 0x0000000000940728 in ProcessUtility (pstmt=0x18e1a, queryString=0x6 , readOnlyTree=, context=774263802, params=0x0, queryEnv=0x0, dest=0x83a60a208, qc=0x821494380) at ../src/backend/tcop/utility.c:523 [03:48:09.794] No locals. [03:48:09.794] #12 0x0000000000940263 in PortalRunUtility (portal=0x8375c7100, pstmt=0x8374f1a68, isTopLevel=, setHoldSnapshot=, dest=0x83a60a208, qc=0x821494380) at ../src/backend/tcop/pquery.c:1158 [03:48:09.794] No locals. [03:48:09.794] #13 0x000000000093f8f4 in PortalRunMulti (portal=portal@entry=0x8375c7100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83a60a208, altdest=altdest@entry=0x83a60a208, qc=0x821494380) at ../src/backend/tcop/pquery.c:1323 [03:48:09.794] pstmt = 0x8374f1a68 [03:48:09.794] stmtlist_item__state = {l = 0x83a60a1b8, i = 0} [03:48:09.794] active_snapshot_set = false [03:48:09.794] stmtlist_item = 0x83a60a1d0 [03:48:09.794] #14 0x000000000093f1c3 in PortalRun (portal=portal@entry=0x8375c7100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83a60a208, altdest=altdest@entry=0x83a60a208, qc=0x821494380) at ../src/backend/tcop/pquery.c:791 [03:48:09.794] _local_sigjmp_buf = {{_sjb = {9695549, 35288543488, 34918187640, 34918187872, 34918187648, 35288559616, 12360328, 12393720, 35288515455, 35289302416, 4294967984, 0}}} [03:48:09.794] _save_exception_stack = 0x821494450 [03:48:09.794] _save_context_stack = 0x0 [03:48:09.794] _do_rethrow = false [03:48:09.794] saveTopTransactionResourceOwner = 0x8375d83d8 [03:48:09.794] saveTopTransactionContext = 0x8375cb000 [03:48:09.794] saveActivePortal = 0x0 [03:48:09.794] saveResourceOwner = 0x8375d83d8 [03:48:09.794] savePortalContext = 0x0 [03:48:09.794] saveMemoryContext = 0x8375cb000 [03:48:09.794] result = [03:48:09.794] nprocessed = [03:48:09.794] #15 0x000000000093e062 in exec_simple_query (query_string=query_string@entry=0x8374f0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [03:48:09.794] cmdtaglen = 24 [03:48:09.794] snapshot_set = [03:48:09.794] per_parsetree_context = 0x0 [03:48:09.794] plantree_list = [03:48:09.794] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:48:09.794] format = 0 [03:48:09.794] parsetree = 0x8374f16a8 [03:48:09.794] commandTag = [03:48:09.794] cmdtagname = [03:48:09.794] querytree_list = [03:48:09.794] portal = 0x8375c7100 [03:48:09.794] receiver = 0x83a60a208 [03:48:09.794] parsetree_item__state = {l = 0x8374f1a18, i = 0} [03:48:09.794] msec_str = "\000\000\000\000\b", '\000' , "\376\237%g\000\000\000\000\237\335\336Lr\036", [03:48:09.794] dest = DestRemote [03:48:09.794] was_logged = [03:48:09.794] oldcontext = 0x8375cb000 [03:48:09.794] parsetree_list = 0x8374f1a18 [03:48:09.794] use_implicit_block = false [03:48:09.794] parsetree_item = 0x8374f1a30 [03:48:09.794] save_log_statement_stats = [03:48:09.794] #16 0x000000000093bcd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [03:48:09.794] query_string = 0x8374f0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:48:09.794] input_message = {data = 0x8374f0100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:48:09.794] firstchar = [03:48:09.794] local_sigjmp_buf = {{_sjb = {9679238, 34918188112, 34918188072, 34918188656, 12402456, 1, 8192, 8388608, 34918171519, 0, 0, 1}}} [03:48:09.794] send_ready_for_query = false [03:48:09.794] idle_in_transaction_timeout_enabled = false [03:48:09.794] idle_session_timeout_enabled = false [03:48:09.794] #17 0x00000000009364b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:48:09.794] bsdata = [03:48:09.794] #18 0x000000000088e167 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821495194 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214950d0) at ../src/backend/postmaster/launch_backend.c:266 [03:48:09.794] pid = [03:48:09.794] #19 0x0000000000892538 in BackendStartup (client_sock=0x8214950d0) at ../src/backend/postmaster/postmaster.c:3417 [03:48:09.794] startup_data = {canAcceptConnections = CAC_OK} [03:48:09.794] bn = 0x8374fc218 [03:48:09.794] pid = [03:48:09.794] __error = [03:48:09.794] save_errno = [03:48:09.794] __error = [03:48:09.794] __error = [03:48:09.794] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [03:48:09.794] 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\037O7\b", '\000' , "0QI!\b\000\000\000h\305\325+\b\000\000\000\v\000\000\000\000\000\000\000^O\326+\b", '\000' , "pQI!\b\000\000\000\024߈\000\000\000\000\000\200QI!\b", '\000' }, salen = 16}} [03:48:09.794] i = 0 [03:48:09.794] now = [03:48:09.794] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 773889154, events = 8, fd = 0, user_data = 0x821495080}, {pos = 928302552, events = 8, fd = 558452496, user_data = 0x0}, {pos = 0, events = 0, fd = 385271292, user_data = 0x228ce7c7830a}, {pos = 773056416, events = 8, fd = 773127544, user_data = 0x821494b98}, {pos = 558451728, events = 8, fd = 558451608, user_data = 0x228ce7c7830a}, {pos = 773034888, events = 8, fd = 773127544, user_data = 0x821494bc8}, {pos = 558451776, events = 8, fd = 558451656, user_data = 0x82e148194}, {pos = 572806152, events = 8, fd = 773095828, user_data = 0x821494c30}, {pos = -406375366, events = 8844, fd = 774918192, user_data = 0x1}, {pos = 558451808, events = 8, fd = -406355190, user_data = 0x82e131858}, {pos = 773127544, events = 8, fd = 558451768, user_data = 0x821494cb0}, {pos = 558451768, events = 8, fd = 773090572, user_data = 0x822245408}, {pos = 773090572, events = 8, fd = 558451872, user_data = 0x228ce7c7343a}, {pos = 558451912, events = 8, fd = 558452360, user_data = 0x821494cb0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 304585955, fd = 572829752, user_data = 0x800000001}, {pos = 572806152, events = 8, fd = 773034888, user_data = 0x82224a288}, {pos = 773003352, events = 8, fd = 572806152, user_data = 0x821494d38}, {pos = 558452472, events = 8, fd = 558452000, user_data = 0x228ce7c77ca2}, {pos = 2702707, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 572829752, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558452728, user_data = 0x22245408}, {pos = 558452544, events = 8, fd = 558452144, user_data = 0x1}, {pos = 558452472, events = 8, fd = 32, user_data = 0x821494da0}, {pos = -406357389, events = 8844, fd = 558452416, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82224b038}, {pos = 1, events = 8, fd = 572806152, user_data = 0x82e131858}, {pos = 558452728, events = 8, fd = 558452544, user_data = 0x821494db0}, {pos = 0, events = 0, fd = 572776456, user_data = 0x20}, {pos = 558452528, events = 8, fd = -406381849, user_data = 0x82223e008}, {pos = 572777480, events = 8, fd = 572778504, user_data = 0x82223ec08}, {pos = 572792840, events = 8, fd = 572793864, user_data = 0x822242808}, {pos = 572795912, events = 8, fd = 572796936, user_data = 0x822243408}, {pos = 572798984, events = 8, fd = 572800008, user_data = 0x822244008}, {pos = 572802056, events = 8, fd = 572803080, user_data = 0x822244c08}, {pos = 572805128, events = 8, fd = 572806152, user_data = 0x822245808}, {pos = 572808200, events = 8, fd = 572809224, user_data = 0x822246408}, {pos = 572811272, events = 8, fd = 572812296, user_data = 0x822247008}, {pos = 572814344, events = 8, fd = 572815368, user_data = 0x822247c08}, {pos = 572821512, events = 8, fd = 572822536, user_data = 0x822249808}, {pos = 572824584, events = 8, fd = 572776456, user_data = 0x293d73}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82224b038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558452728, events = 8, fd = 558452144, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 572829752, user_data = 0x1}, {pos = 572776456, events = 8, fd = 298, user_data = 0x821494fe0}, {pos = -406383121, events = 8844, fd = 2702707, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 572829752, user_data = 0x1}, {pos = 572806152, events = 8, fd = 927858688, user_data = 0x1}, {pos = 927859092, events = 8, fd = 0, user_data = 0x821494fb0}, {pos = 735462764, events = 8, fd = 1, user_data = 0x8374e0000}, {pos = 558452704, events = 8, fd = 735459074, user_data = 0x82e263170 }, {pos = 12323304, events = 0, fd = 774254960, user_data = 0x822245408}, {pos = 558452928, events = 8, fd = -406383650, user_data = 0x8374fe800}, {pos = 1, events = 0, fd = -406384034, user_data = 0x82223e008}, {pos = 558452712, events = 8, fd = 558452928, user_data = 0x1ab8}, {pos = 927932160, events = 8, fd = -406304368, user_data = 0x0}, {pos = 558433151, events = 8, fd = 8116103, user_data = 0x821495070}, {pos = 735421456, events = 8, fd = 774918192, user_data = 0x82e307310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214950a0}, {pos = 735464349, events = 8, fd = 927858688, user_data = 0x1dae}, {pos = 558452992, events = 8, fd = 735430906, user_data = 0x0}, {pos = 0, events = 0, fd = 385271292, user_data = 0x0}} [03:48:09.794] last_touch_time = 1730519019 [03:48:09.794] last_lockfile_recheck_time = 1730519019 [03:48:09.794] nevents = 1 [03:48:09.794] #21 0x0000000000890355 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214956e0) at ../src/backend/postmaster/postmaster.c:1348 [03:48:09.794] userDoption = [03:48:09.794] listen_addr_saved = [03:48:09.794] output_config_variable = [03:48:09.794] opt = [03:48:09.794] status = [03:48:09.794] #22 0x00000000007ca40c in main (argc=8, argv=0x8214956e0) at ../src/backend/main/main.c:196 [03:48:09.794] do_check_root = [03:48:09.803] [03:48:09.803] [03:48:09.803] [03:48:09.865] dumping /tmp/cores/postgres.11053.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:48:09.990] [New LWP 101837] [03:48:10.050] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:48:10.050] Program terminated with signal SIGABRT, Aborted. [03:48:10.050] Sent by thr_kill() from pid 11053 and user 1003. [03:48:10.050] #0 0x000000082a57241a in thr_kill () from /lib/libc.so.7 [03:48:10.085] [03:48:10.085] Thread 1 (LWP 101837): [03:48:10.085] #0 0x000000082a57241a in thr_kill () from /lib/libc.so.7 [03:48:10.085] No symbol table info available. [03:48:10.085] #1 0x000000082a4ebe64 in raise () from /lib/libc.so.7 [03:48:10.085] No symbol table info available. [03:48:10.085] #2 0x000000082a59c6f9 in abort () from /lib/libc.so.7 [03:48:10.085] No symbol table info available. [03:48:10.085] #3 0x0000000000a965e5 in ExceptionalCondition (conditionName=0x2e7bd6 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:48:10.085] No locals. [03:48:10.085] #4 0x0000000000767059 in standard_ExecutorStart (queryDesc=0x8343c1088, eflags=0) at ../src/backend/executor/execMain.c:194 [03:48:10.085] estate = 0x8343bf100 [03:48:10.085] oldcontext = 0x8342fc800 [03:48:10.085] #5 0x00000000006fdd75 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:48:10.085] copied_query = [03:48:10.085] rewritten = [03:48:10.085] plan = 0x8343e6bd8 [03:48:10.085] queryDesc = 0x8343c1088 [03:48:10.085] processed = [03:48:10.085] __error = [03:48:10.085] #6 RefreshMatViewByOid (matviewOid=27287, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:48:10.085] dest = [03:48:10.085] save_userid = 10 [03:48:10.085] save_sec_context = 0 [03:48:10.085] processed = 0 [03:48:10.085] matviewRel = 0x837a4aad0 [03:48:10.085] relowner = 10 [03:48:10.085] save_nestlevel = 2 [03:48:10.085] rule = [03:48:10.085] actions = [03:48:10.085] dataQuery = [03:48:10.085] tableSpace = [03:48:10.085] relpersistence = [03:48:10.085] OIDNewHeap = 27294 [03:48:10.085] address = [03:48:10.085] #7 0x00000000006fd956 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:48:10.085] lockmode = [03:48:10.085] matviewOid = 0 [03:48:10.085] #8 0x00000000006d4a6c in ExecCreateTableAs (pstate=pstate@entry=0x8342fc900, stmt=stmt@entry=0x837a77fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8214ebaa0) at ../src/backend/commands/createas.c:351 [03:48:10.085] refresh = 0x0 [03:48:10.085] query = 0x837b0a218 [03:48:10.085] into = 0x837b0a560 [03:48:10.085] jstate = 0x0 [03:48:10.085] do_refresh = false [03:48:10.085] address = [03:48:10.085] dest = [03:48:10.085] is_matview = [03:48:10.085] #9 0x0000000000942318 in ProcessUtilitySlow (pstate=pstate@entry=0x8342fc900, pstmt=pstmt@entry=0x834229a68, queryString=queryString@entry=0x834228100 "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=0x8214ebaa0) at ../src/backend/tcop/utility.c:1675 [03:48:10.085] _local_sigjmp_buf = {{_sjb = {9706313, 0, 34918545096, 34918545472, 34918545104, 12393720, 0, 35235285248, 4294902655, 34918545212, 34918545248, 0}}} [03:48:10.085] _save_exception_stack = 0x8214eb9a0 [03:48:10.085] _save_context_stack = 0x0 [03:48:10.085] _do_rethrow = false [03:48:10.085] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:48:10.085] parsetree = 0x837a77fd0 [03:48:10.085] commandCollected = false [03:48:10.085] needCleanup = false [03:48:10.085] address = [03:48:10.085] isTopLevel = [03:48:10.085] isCompleteQuery = [03:48:10.085] #10 0x0000000000940c98 in standard_ProcessUtility (pstmt=0x834229a68, queryString=0x834228100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837b0aa48, qc=0x8214ebaa0) at ../src/backend/tcop/utility.c:1030 [03:48:10.085] isAtomicContext = false [03:48:10.085] parsetree = 0x837a77fd0 [03:48:10.085] readonly_flags = [03:48:10.085] pstate = 0x8342fc900 [03:48:10.085] isTopLevel = [03:48:10.085] #11 0x0000000000940728 in ProcessUtility (pstmt=0x18dcd, queryString=0x6 , readOnlyTree=, context=710353914, params=0x0, queryEnv=0x0, dest=0x837b0aa48, qc=0x8214ebaa0) at ../src/backend/tcop/utility.c:523 [03:48:10.085] No locals. [03:48:10.085] #12 0x0000000000940263 in PortalRunUtility (portal=0x8342ce100, pstmt=0x834229a68, isTopLevel=, setHoldSnapshot=, dest=0x837b0aa48, qc=0x8214ebaa0) at ../src/backend/tcop/pquery.c:1158 [03:48:10.085] No locals. [03:48:10.085] #13 0x000000000093f8f4 in PortalRunMulti (portal=portal@entry=0x8342ce100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x837b0aa48, altdest=altdest@entry=0x837b0aa48, qc=0x8214ebaa0) at ../src/backend/tcop/pquery.c:1323 [03:48:10.085] pstmt = 0x834229a68 [03:48:10.085] stmtlist_item__state = {l = 0x837b0a9f8, i = 0} [03:48:10.085] active_snapshot_set = false [03:48:10.085] stmtlist_item = 0x837b0aa10 [03:48:10.085] #14 0x000000000093f1c3 in PortalRun (portal=portal@entry=0x8342ce100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x837b0aa48, altdest=altdest@entry=0x837b0aa48, qc=0x8214ebaa0) at ../src/backend/tcop/pquery.c:791 [03:48:10.085] _local_sigjmp_buf = {{_sjb = {9695549, 35235094784, 34918545816, 34918546048, 34918545824, 35235110912, 12360328, 12393720, 35235103615, 35293455760, 4294967984, 0}}} [03:48:10.085] _save_exception_stack = 0x8214ebb70 [03:48:10.085] _save_context_stack = 0x0 [03:48:10.085] _do_rethrow = false [03:48:10.085] saveTopTransactionResourceOwner = 0x83431d7d8 [03:48:10.085] saveTopTransactionContext = 0x8342d2000 [03:48:10.085] saveActivePortal = 0x0 [03:48:10.085] saveResourceOwner = 0x83431d7d8 [03:48:10.085] savePortalContext = 0x0 [03:48:10.085] saveMemoryContext = 0x8342d2000 [03:48:10.085] result = [03:48:10.085] nprocessed = [03:48:10.085] #15 0x000000000093e062 in exec_simple_query (query_string=query_string@entry=0x834228100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [03:48:10.085] cmdtaglen = 24 [03:48:10.085] snapshot_set = [03:48:10.085] per_parsetree_context = 0x0 [03:48:10.085] plantree_list = [03:48:10.085] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:48:10.085] format = 0 [03:48:10.085] parsetree = 0x8342296a8 [03:48:10.085] commandTag = [03:48:10.085] cmdtagname = [03:48:10.085] querytree_list = [03:48:10.085] portal = 0x8342ce100 [03:48:10.085] receiver = 0x837b0aa48 [03:48:10.085] parsetree_item__state = {l = 0x834229a18, i = 0} [03:48:10.085] msec_str = "\000\000\000\000\b", '\000' , "\001\240%g\000\000\000\000\261\300\324\a\277g]<" [03:48:10.085] dest = DestRemote [03:48:10.085] was_logged = [03:48:10.085] oldcontext = 0x8342d2000 [03:48:10.085] parsetree_list = 0x834229a18 [03:48:10.085] use_implicit_block = false [03:48:10.085] parsetree_item = 0x834229a30 [03:48:10.085] save_log_statement_stats = [03:48:10.085] #16 0x000000000093bcd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [03:48:10.085] query_string = 0x834228100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:48:10.085] input_message = {data = 0x834228100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:48:10.085] firstchar = [03:48:10.085] local_sigjmp_buf = {{_sjb = {9679238, 34918546288, 34918546248, 34918546832, 12402456, 1, 8192, 8388608, 34918499199, 0, 0, 1}}} [03:48:10.085] send_ready_for_query = false [03:48:10.085] idle_in_transaction_timeout_enabled = false [03:48:10.085] idle_session_timeout_enabled = false [03:48:10.085] #17 0x00000000009364b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:48:10.085] bsdata = [03:48:10.085] #18 0x000000000088e167 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8214ec8b4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214ec7f0) at ../src/backend/postmaster/launch_backend.c:266 [03:48:10.085] pid = [03:48:10.085] #19 0x0000000000892538 in BackendStartup (client_sock=0x8214ec7f0) at ../src/backend/postmaster/postmaster.c:3417 [03:48:10.085] startup_data = {canAcceptConnections = CAC_OK} [03:48:10.085] bn = 0x834234628 [03:48:10.085] pid = [03:48:10.085] __error = [03:48:10.085] save_errno = [03:48:10.085] __error = [03:48:10.085] __error = [03:48:10.085] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [03:48:10.085] 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\236\"4\b", '\000' , "P\310N!\b\000\000\000h\005\266(\b\000\000\000\v\000\000\000\000\000\000\000^\217\266(\b", '\000' , "\220\310N!\b\000\000\000\024߈\000\000\000\000\000\240\310N!\b", '\000' }, salen = 16}} [03:48:10.085] i = 0 [03:48:10.085] now = [03:48:10.085] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 709979266, events = 8, fd = 0, user_data = 0x8214ec7a0}, {pos = 875111896, events = 8, fd = 558810672, user_data = 0x0}, {pos = 0, events = 0, fd = -553825428, user_data = 0x197107e6630a}, {pos = 709146528, events = 8, fd = 709217656, user_data = 0x8214ec2b8}, {pos = 558809904, events = 8, fd = 558809784, user_data = 0x197107e6630a}, {pos = 709125000, events = 8, fd = 709217656, user_data = 0x8214ec2e8}, {pos = 558809952, events = 8, fd = 558809832, user_data = 0x82a455194}, {pos = 564409352, events = 8, fd = 709185940, user_data = 0x8214ec350}, {pos = 132518970, events = 6513, fd = 711008304, user_data = 0x1}, {pos = 558809984, events = 8, fd = 132539146, user_data = 0x82a43e858}, {pos = 709217656, events = 8, fd = 558809944, user_data = 0x8214ec3d0}, {pos = 558809944, events = 8, fd = 709180684, user_data = 0x821a43408}, {pos = 709180684, events = 8, fd = 558810048, user_data = 0x197107e6143a}, {pos = 558810088, events = 8, fd = 558810536, user_data = 0x8214ec3d0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1434277611, fd = 564432952, user_data = 0x800000001}, {pos = 564409352, events = 8, fd = 709125000, user_data = 0x821a48288}, {pos = 709093464, events = 8, fd = 564409352, user_data = 0x8214ec458}, {pos = 558810648, events = 8, fd = 558810176, user_data = 0x197107e65ca2}, {pos = 2702707, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 564432952, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558810904, user_data = 0x21a43408}, {pos = 558810720, events = 8, fd = 558810320, user_data = 0x1}, {pos = 558810648, events = 8, fd = 32, user_data = 0x8214ec4c0}, {pos = 132536947, events = 6513, fd = 558810592, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821a49038}, {pos = 1, events = 8, fd = 564409352, user_data = 0x82a43e858}, {pos = 558810904, events = 8, fd = 558810720, user_data = 0x8214ec4d0}, {pos = 0, events = 0, fd = 564379656, user_data = 0x20}, {pos = 558810704, events = 8, fd = 132512487, user_data = 0x821a3c008}, {pos = 564380680, events = 8, fd = 564381704, user_data = 0x821a3cc08}, {pos = 564396040, events = 8, fd = 564397064, user_data = 0x821a40808}, {pos = 564399112, events = 8, fd = 564400136, user_data = 0x821a41408}, {pos = 564402184, events = 8, fd = 564403208, user_data = 0x821a42008}, {pos = 564405256, events = 8, fd = 564406280, user_data = 0x821a42c08}, {pos = 564408328, events = 8, fd = 564409352, user_data = 0x821a43808}, {pos = 564411400, events = 8, fd = 564412424, user_data = 0x821a44408}, {pos = 564414472, events = 8, fd = 564415496, user_data = 0x821a45008}, {pos = 564417544, events = 8, fd = 564418568, user_data = 0x821a45c08}, {pos = 564424712, events = 8, fd = 564425736, user_data = 0x821a47808}, {pos = 564427784, events = 8, fd = 564379656, user_data = 0x293d73}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821a49038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558810904, events = 8, fd = 558810320, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 564432952, user_data = 0x1}, {pos = 564379656, events = 8, fd = 298, user_data = 0x8214ec700}, {pos = 132511215, events = 6513, fd = 2702707, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564432952, user_data = 0x1}, {pos = 564409352, events = 8, fd = 874610688, user_data = 0x1}, {pos = 874611092, events = 8, fd = 0, user_data = 0x8214ec6d0}, {pos = 683050348, events = 8, fd = 1, user_data = 0x834218000}, {pos = 558810880, events = 8, fd = 683046658, user_data = 0x82a570170 }, {pos = 12323304, events = 0, fd = 710345072, user_data = 0x821a43408}, {pos = 558811104, events = 8, fd = 132510686, user_data = 0x834236800}, {pos = 1, events = 0, fd = 132510302, user_data = 0x821a3c008}, {pos = 558810888, events = 8, fd = 558811104, user_data = 0x1ab8}, {pos = 874684096, events = 8, fd = 132589968, user_data = 0x0}, {pos = 558760831, events = 8, fd = 8116103, user_data = 0x8214ec790}, {pos = 683009040, events = 8, fd = 711008304, user_data = 0x82a614310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214ec7c0}, {pos = 683051933, events = 8, fd = 874610688, user_data = 0x1e10}, {pos = 558811168, events = 8, fd = 683018490, user_data = 0x0}, {pos = 0, events = 0, fd = -553825428, user_data = 0x0}} [03:48:10.085] last_touch_time = 1730519019 [03:48:10.085] last_lockfile_recheck_time = 1730519019 [03:48:10.085] nevents = 1 [03:48:10.085] #21 0x0000000000890355 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8214ece00) at ../src/backend/postmaster/postmaster.c:1348 [03:48:10.085] userDoption = [03:48:10.085] listen_addr_saved = [03:48:10.085] output_config_variable = [03:48:10.085] opt = [03:48:10.085] status = [03:48:10.085] #22 0x00000000007ca40c in main (argc=4, argv=0x8214ece00) at ../src/backend/main/main.c:196 [03:48:10.085] do_check_root = [03:48:10.094] [03:48:10.094] [03:48:10.094] [03:48:10.157] dumping /tmp/cores/postgres.17592.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:48:10.282] [New LWP 101951] [03:48:10.344] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:48:10.344] Program terminated with signal SIGABRT, Aborted. [03:48:10.344] Sent by thr_kill() from pid 17592 and user 1003. [03:48:10.344] #0 0x000000082dd6641a in thr_kill () from /lib/libc.so.7 [03:48:10.387] [03:48:10.387] Thread 1 (LWP 101951): [03:48:10.387] #0 0x000000082dd6641a in thr_kill () from /lib/libc.so.7 [03:48:10.387] No symbol table info available. [03:48:10.387] #1 0x000000082dcdfe64 in raise () from /lib/libc.so.7 [03:48:10.387] No symbol table info available. [03:48:10.387] #2 0x000000082dd906f9 in abort () from /lib/libc.so.7 [03:48:10.387] No symbol table info available. [03:48:10.387] #3 0x0000000000a965e5 in ExceptionalCondition (conditionName=0x2e7bd6 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:48:10.387] No locals. [03:48:10.387] #4 0x0000000000767059 in standard_ExecutorStart (queryDesc=0x838adb088, eflags=0) at ../src/backend/executor/execMain.c:194 [03:48:10.387] estate = 0x838b17100 [03:48:10.387] oldcontext = 0x83c36b800 [03:48:10.387] #5 0x000000083bcc59c2 in pgss_ExecutorStart (queryDesc=0x838adb088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [03:48:10.387] No locals. [03:48:10.387] #6 0x00000000006fdd75 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:48:10.387] copied_query = [03:48:10.387] rewritten = [03:48:10.387] plan = 0x838ad2bd8 [03:48:10.387] queryDesc = 0x838adb088 [03:48:10.387] processed = [03:48:10.387] __error = [03:48:10.387] #7 RefreshMatViewByOid (matviewOid=27508, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:48:10.387] dest = [03:48:10.387] save_userid = 10 [03:48:10.387] save_sec_context = 0 [03:48:10.387] processed = 0 [03:48:10.387] matviewRel = 0x83c32c108 [03:48:10.387] relowner = 10 [03:48:10.387] save_nestlevel = 2 [03:48:10.387] rule = [03:48:10.387] actions = [03:48:10.387] dataQuery = [03:48:10.387] tableSpace = [03:48:10.387] relpersistence = [03:48:10.387] OIDNewHeap = 27521 [03:48:10.387] address = [03:48:10.387] #8 0x00000000006fd956 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:48:10.387] lockmode = [03:48:10.387] matviewOid = 0 [03:48:10.387] #9 0x00000000006d4a6c in ExecCreateTableAs (pstate=pstate@entry=0x83c36b900, stmt=stmt@entry=0x8389dafd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8213d01f0) at ../src/backend/commands/createas.c:351 [03:48:10.387] refresh = 0x0 [03:48:10.387] query = 0x838a25a08 [03:48:10.387] into = 0x8389daf40 [03:48:10.387] jstate = 0x0 [03:48:10.387] do_refresh = false [03:48:10.387] address = [03:48:10.387] dest = [03:48:10.387] is_matview = [03:48:10.387] #10 0x0000000000942318 in ProcessUtilitySlow (pstate=pstate@entry=0x83c36b900, pstmt=pstmt@entry=0x8389dae30, queryString=queryString@entry=0x83893d100 "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=0x8213d01f0) at ../src/backend/tcop/utility.c:1675 [03:48:10.387] _local_sigjmp_buf = {{_sjb = {9706313, 0, 34917383256, 34917383632, 34917383264, 12393720, 0, 35369957632, 34917319551, 7, 34917383408, 0}}} [03:48:10.387] _save_exception_stack = 0x8213cfee0 [03:48:10.387] _save_context_stack = 0x0 [03:48:10.387] _do_rethrow = false [03:48:10.387] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:48:10.387] parsetree = 0x8389dafd0 [03:48:10.387] commandCollected = false [03:48:10.387] needCleanup = false [03:48:10.387] address = [03:48:10.387] isTopLevel = [03:48:10.387] isCompleteQuery = [03:48:10.387] #11 0x0000000000940c98 in standard_ProcessUtility (pstmt=0x8389dae30, queryString=queryString@entry=0x83893d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838a261a8, qc=0x8213d01f0) at ../src/backend/tcop/utility.c:1030 [03:48:10.387] isAtomicContext = false [03:48:10.387] parsetree = 0x8389dafd0 [03:48:10.387] readonly_flags = [03:48:10.387] pstate = 0x83c36b900 [03:48:10.387] isTopLevel = [03:48:10.387] #12 0x000000083bcc5f7e in pgss_ProcessUtility (pstmt=0x8389dae30, queryString=0x83893d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838a261a8, qc=0x8213d01f0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [03:48:10.387] _local_sigjmp_buf = {{_sjb = {35362987703, 34917383904, 34917383768, 34917384224, 35309596208, 0, 12393720, 34917384432, 34917319551, 34917384004, 34917384032, 0}}} [03:48:10.387] _save_exception_stack = 0x8213d00f0 [03:48:10.387] _save_context_stack = 0x0 [03:48:10.387] _do_rethrow = false [03:48:10.387] bufusage = {shared_blks_hit = 35362987703, shared_blks_read = 34917383904, shared_blks_dirtied = 34917383768, shared_blks_written = 34917384224, local_blks_hit = 35309596208, local_blks_read = 0, local_blks_dirtied = 12393720, local_blks_written = 34917384432, temp_blks_read = 34917319551, temp_blks_written = 34917384004, shared_blk_read_time = {ticks = 34917384032}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4454003961712531712}, local_blk_write_time = {ticks = 12402760}, temp_blk_read_time = {ticks = 35400951936}, temp_blk_write_time = {ticks = 12356272}} [03:48:10.387] walusage_start = {wal_records = 8945, wal_fpi = 144, wal_bytes = 1258273} [03:48:10.387] duration = [03:48:10.387] bufusage_start = {shared_blks_hit = 152534, shared_blks_read = 8242, shared_blks_dirtied = 2763, shared_blks_written = 2210, 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}} [03:48:10.387] walusage = {wal_records = 1744307922935927527, wal_fpi = 35309596624, wal_bytes = 123} [03:48:10.387] start = {ticks = -183027855251} [03:48:10.387] rows = [03:48:10.387] saved_queryId = 6041762721901209185 [03:48:10.387] parsetree = [03:48:10.387] saved_stmt_location = 0 [03:48:10.387] saved_stmt_len = 69 [03:48:10.387] enabled = [03:48:10.387] #13 0x0000000000940263 in PortalRunUtility (portal=0x8389e5100, pstmt=0x8389dae30, isTopLevel=, setHoldSnapshot=, dest=0x838a261a8, qc=0x8213d01f0) at ../src/backend/tcop/pquery.c:1158 [03:48:10.387] No locals. [03:48:10.387] #14 0x000000000093f8f4 in PortalRunMulti (portal=portal@entry=0x8389e5100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x838a261a8, altdest=altdest@entry=0x838a261a8, qc=0x8213d01f0) at ../src/backend/tcop/pquery.c:1323 [03:48:10.387] pstmt = 0x8389dae30 [03:48:10.387] stmtlist_item__state = {l = 0x838a26158, i = 0} [03:48:10.387] active_snapshot_set = false [03:48:10.387] stmtlist_item = 0x838a26170 [03:48:10.387] #15 0x000000000093f1c3 in PortalRun (portal=portal@entry=0x8389e5100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x838a261a8, altdest=altdest@entry=0x838a261a8, qc=0x8213d01f0) at ../src/backend/tcop/pquery.c:791 [03:48:10.387] _local_sigjmp_buf = {{_sjb = {9695549, 35309637888, 34917384424, 34917384656, 34917384432, 35309731840, 12360328, 12393720, 35309618047, 35309589984, 4294967984, 0}}} [03:48:10.387] _save_exception_stack = 0x8213d02c0 [03:48:10.387] _save_context_stack = 0x0 [03:48:10.387] _do_rethrow = false [03:48:10.387] saveTopTransactionResourceOwner = 0x838a33598 [03:48:10.387] saveTopTransactionContext = 0x8389fc000 [03:48:10.387] saveActivePortal = 0x0 [03:48:10.387] saveResourceOwner = 0x838a33598 [03:48:10.387] savePortalContext = 0x0 [03:48:10.387] saveMemoryContext = 0x8389fc000 [03:48:10.387] result = [03:48:10.387] nprocessed = [03:48:10.387] #16 0x000000000093e062 in exec_simple_query (query_string=query_string@entry=0x83893d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [03:48:10.387] cmdtaglen = 24 [03:48:10.387] snapshot_set = [03:48:10.387] per_parsetree_context = 0x0 [03:48:10.387] plantree_list = [03:48:10.387] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:48:10.387] format = 0 [03:48:10.387] parsetree = 0x83893e6a8 [03:48:10.387] commandTag = [03:48:10.387] cmdtagname = [03:48:10.387] querytree_list = [03:48:10.387] portal = 0x8389e5100 [03:48:10.387] receiver = 0x838a261a8 [03:48:10.387] parsetree_item__state = {l = 0x83893ea18, i = 0} [03:48:10.387] msec_str = "\000\000\000\000\b", '\000' , "&\240%g\000\000\000\000\227:\247\360݈E)" [03:48:10.387] dest = DestRemote [03:48:10.387] was_logged = [03:48:10.387] oldcontext = 0x8389fc000 [03:48:10.387] parsetree_list = 0x83893ea18 [03:48:10.387] use_implicit_block = false [03:48:10.387] parsetree_item = 0x83893ea30 [03:48:10.387] save_log_statement_stats = [03:48:10.387] #17 0x000000000093bcd3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [03:48:10.387] query_string = 0x83893d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:48:10.387] input_message = {data = 0x83893d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:48:10.387] firstchar = [03:48:10.387] local_sigjmp_buf = {{_sjb = {9679238, 34917384896, 34917384856, 34917385440, 12402456, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [03:48:10.387] send_ready_for_query = false [03:48:10.387] idle_in_transaction_timeout_enabled = false [03:48:10.387] idle_session_timeout_enabled = false [03:48:10.387] #18 0x00000000009364b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:48:10.387] bsdata = [03:48:10.387] #19 0x000000000088e167 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8213d1004 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8213d0f40) at ../src/backend/postmaster/launch_backend.c:266 [03:48:10.387] pid = [03:48:10.387] #20 0x0000000000892538 in BackendStartup (client_sock=0x8213d0f40) at ../src/backend/postmaster/postmaster.c:3417 [03:48:10.387] startup_data = {canAcceptConnections = CAC_OK} [03:48:10.387] bn = 0x8389495d8 [03:48:10.387] pid = [03:48:10.387] __error = [03:48:10.387] save_errno = [03:48:10.387] __error = [03:48:10.387] __error = [03:48:10.387] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [03:48:10.387] 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 = " ܓ8\b", '\000' , "\240\017=!\b\000\000\000h\245\377+\b\000\000\000\v\000\000\000\000\000\000\000^/\000,\b", '\000' , "\340\017=!\b\000\000\000\024߈\000\000\000\000\000\360\017=!\b", '\000' }, salen = 16}} [03:48:10.387] i = 0 [03:48:10.387] now = [03:48:10.387] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 768650370, events = 8, fd = 0, user_data = 0x8213d0ef0}, {pos = 949618136, events = 8, fd = 557649280, user_data = 0x0}, {pos = -1558187254, events = 4544, fd = 767817632, user_data = 0x82dc50d78}, {pos = 557648376, events = 8, fd = 557648496, user_data = 0x8213d09f8}, {pos = -1558187254, events = 4544, fd = 767796104, user_data = 0x82dc50d78}, {pos = 557648424, events = 8, fd = 557648544, user_data = 0x8213d0a28}, {pos = 767857044, events = 8, fd = 573748232, user_data = 0x82dc49194}, {pos = 557648528, events = 8, fd = -1558207430, user_data = 0x8213d0a30}, {pos = 738165776, events = 8, fd = 769679408, user_data = 0x11c0a31ff30a}, {pos = 767764568, events = 8, fd = 767888760, user_data = 0x8213d0a98}, {pos = 557648656, events = 8, fd = 557648536, user_data = 0x82dc47d0c}, {pos = 573748232, events = 8, fd = 767851788, user_data = 0x8213d0b00}, {pos = -1558207430, events = 4544, fd = 557648680, user_data = 0x8213d0cf8}, {pos = 557648656, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x822331038}, {pos = 1, events = 406128336, fd = 573748232, user_data = 0x82dc3a388}, {pos = 573769672, events = 8, fd = 0, user_data = 0x0}, {pos = 557648792, events = 8, fd = 557649256, user_data = 0x8213d0b80}, {pos = -1558188894, events = 4544, fd = 2702707, user_data = 0x6d68b}, {pos = 2090263927, events = 406128336, fd = 573771832, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8213d0e68}, {pos = 573748232, events = 3, fd = 557649328, user_data = 0x822330828}, {pos = 656, events = 0, fd = 557649256, user_data = 0x8213d0b98}, {pos = 557648896, events = 8, fd = -1558189285, user_data = 0x8213d0d30}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 573771832, events = 8, fd = 1, user_data = 0x82232b408}, {pos = 767764568, events = 8, fd = 557649512, user_data = 0x8213d0db0}, {pos = 557648912, events = 8, fd = 0, user_data = 0x822324008}, {pos = 33, events = 0, fd = 557649312, user_data = 0x11c0a31f8ae7}, {pos = 573718536, events = 8, fd = 573719560, user_data = 0x822324808}, {pos = 573721608, events = 8, fd = 573734920, user_data = 0x822328408}, {pos = 573736968, events = 8, fd = 573737992, user_data = 0x822329008}, {pos = 573740040, events = 8, fd = 573741064, user_data = 0x822329c08}, {pos = 573743112, events = 8, fd = 573744136, user_data = 0x82232a808}, {pos = 573746184, events = 8, fd = 573747208, user_data = 0x82232b408}, {pos = 573749256, events = 8, fd = 573750280, user_data = 0x82232c008}, {pos = 573752328, events = 8, fd = 573753352, user_data = 0x82232cc08}, {pos = 573755400, events = 8, fd = 573756424, user_data = 0x82232d808}, {pos = 573758472, events = 8, fd = 573763592, user_data = 0x82232f408}, {pos = 573765640, events = 8, fd = 573766664, user_data = 0x822332408}, {pos = 62576000, events = 0, fd = 573718536, user_data = 0x293d73}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822331038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557649512, events = 8, fd = 557648912, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 573771832, user_data = 0x1}, {pos = 573718536, events = 8, fd = 298, user_data = 0x8213d0e50}, {pos = -1558215185, events = 4544, fd = 2702707, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 573771832, user_data = 0x1}, {pos = 573748232, events = 8, fd = 949145600, user_data = 0x1}, {pos = 949146004, events = 8, fd = 0, user_data = 0x8213d0e20}, {pos = 738207084, events = 8, fd = 1, user_data = 0x83892d000}, {pos = 557649488, events = 8, fd = 738203394, user_data = 0x82dd64170 }, {pos = 12323304, events = 0, fd = 769016176, user_data = 0x82232b408}, {pos = 557649712, events = 8, fd = -1558215714, user_data = 0x83894b800}, {pos = 1, events = 0, fd = -1558216098, user_data = 0x822324008}, {pos = 557649496, events = 8, fd = 557649712, user_data = 0x1ab8}, {pos = 949214240, events = 8, fd = -1558136432, user_data = 0x0}, {pos = 557646719, events = 8, fd = 8116103, user_data = 0x8213d0ee0}, {pos = 738165776, events = 8, fd = 769679408, user_data = 0x82de08310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8213d0f10}, {pos = 738208669, events = 8, fd = 949145600, user_data = 0x36b8}, {pos = 557649776, events = 8, fd = 738175226, user_data = 0x0}, {pos = 0, events = 0, fd = 1837028071, user_data = 0x0}} [03:48:10.387] last_touch_time = 1730519053 [03:48:10.387] last_lockfile_recheck_time = 1730519053 [03:48:10.387] nevents = 1 [03:48:10.387] #22 0x0000000000890355 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8213d1550) at ../src/backend/postmaster/postmaster.c:1348 [03:48:10.387] userDoption = [03:48:10.387] listen_addr_saved = [03:48:10.387] output_config_variable = [03:48:10.387] opt = [03:48:10.387] status = [03:48:10.387] #23 0x00000000007ca40c in main (argc=4, argv=0x8213d1550) at ../src/backend/main/main.c:196 [03:48:10.387] do_check_root =