[01:15:26.081] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [01:15:26.449] dumping /tmp/cores/postgres.10623.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [01:15:26.583] [New LWP 101899] [01:15:26.674] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [01:15:26.674] Program terminated with signal SIGABRT, Aborted. [01:15:26.674] Sent by thr_kill() from pid 10623 and user 1003. [01:15:26.674] #0 0x000000082cde741a in thr_kill () from /lib/libc.so.7 [01:15:26.734] [01:15:26.734] Thread 1 (LWP 101899): [01:15:26.734] #0 0x000000082cde741a in thr_kill () from /lib/libc.so.7 [01:15:26.734] No symbol table info available. [01:15:26.734] #1 0x000000082cd60e64 in raise () from /lib/libc.so.7 [01:15:26.734] No symbol table info available. [01:15:26.734] #2 0x000000082ce116f9 in abort () from /lib/libc.so.7 [01:15:26.734] No symbol table info available. [01:15:26.734] #3 0x0000000000a95b95 in ExceptionalCondition (conditionName=0x2e7b97 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [01:15:26.734] No locals. [01:15:26.734] #4 0x00000000007665d9 in standard_ExecutorStart (queryDesc=0x842bd3088, eflags=0) at ../src/backend/executor/execMain.c:194 [01:15:26.734] estate = 0x83675f100 [01:15:26.734] oldcontext = 0x8367a1800 [01:15:26.734] #5 0x00000000006fd2c5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [01:15:26.734] copied_query = [01:15:26.734] rewritten = [01:15:26.734] plan = 0x836795bd8 [01:15:26.734] queryDesc = 0x842bd3088 [01:15:26.734] processed = [01:15:26.734] __error = [01:15:26.734] #6 RefreshMatViewByOid (matviewOid=27245, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [01:15:26.734] dest = [01:15:26.734] save_userid = 10 [01:15:26.734] save_sec_context = 0 [01:15:26.734] processed = 0 [01:15:26.734] matviewRel = 0x842adec38 [01:15:26.734] relowner = 10 [01:15:26.734] save_nestlevel = 2 [01:15:26.734] rule = [01:15:26.734] actions = [01:15:26.734] dataQuery = [01:15:26.734] tableSpace = [01:15:26.734] relpersistence = [01:15:26.734] OIDNewHeap = 27257 [01:15:26.734] address = [01:15:26.734] #7 0x00000000006fcea6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:15:26.734] lockmode = [01:15:26.734] matviewOid = 0 [01:15:26.734] #8 0x00000000006d3fbc in ExecCreateTableAs (pstate=pstate@entry=0x8367a1900, stmt=stmt@entry=0x8366c3fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8210ac4b0) at ../src/backend/commands/createas.c:351 [01:15:26.734] refresh = 0x0 [01:15:26.734] query = 0x842b25fd8 [01:15:26.734] into = 0x842b26320 [01:15:26.734] jstate = 0x0 [01:15:26.734] do_refresh = false [01:15:26.734] address = [01:15:26.734] dest = [01:15:26.734] is_matview = [01:15:26.734] #9 0x0000000000941868 in ProcessUtilitySlow (pstate=pstate@entry=0x8367a1900, pstmt=pstmt@entry=0x836605a68, queryString=queryString@entry=0x836604100 "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=0x8210ac4b0) at ../src/backend/tcop/utility.c:1675 [01:15:26.734] _local_sigjmp_buf = {{_sjb = {9703577, 0, 34914091224, 34914091600, 34914091232, 12390952, 0, 35273709824, 4294902655, 34914091340, 34914091376, 0}}} [01:15:26.734] _save_exception_stack = 0x8210ac3b0 [01:15:26.734] _save_context_stack = 0x0 [01:15:26.734] _do_rethrow = false [01:15:26.734] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:15:26.734] parsetree = 0x8366c3fd0 [01:15:26.734] commandCollected = false [01:15:26.734] needCleanup = false [01:15:26.734] address = [01:15:26.734] isTopLevel = [01:15:26.734] isCompleteQuery = [01:15:26.734] #10 0x00000000009401e8 in standard_ProcessUtility (pstmt=0x836605a68, queryString=0x836604100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x842b26808, qc=0x8210ac4b0) at ../src/backend/tcop/utility.c:1030 [01:15:26.734] isAtomicContext = false [01:15:26.734] parsetree = 0x8366c3fd0 [01:15:26.734] readonly_flags = [01:15:26.734] pstate = 0x8367a1900 [01:15:26.734] isTopLevel = [01:15:26.734] #11 0x000000000093fc78 in ProcessUtility (pstmt=0x18e0b, queryString=0x6 , readOnlyTree=, context=752776186, params=0x0, queryEnv=0x0, dest=0x842b26808, qc=0x8210ac4b0) at ../src/backend/tcop/utility.c:523 [01:15:26.734] No locals. [01:15:26.734] #12 0x000000000093f7b3 in PortalRunUtility (portal=0x8366db100, pstmt=0x836605a68, isTopLevel=, setHoldSnapshot=, dest=0x842b26808, qc=0x8210ac4b0) at ../src/backend/tcop/pquery.c:1158 [01:15:26.734] No locals. [01:15:26.734] #13 0x000000000093ee44 in PortalRunMulti (portal=portal@entry=0x8366db100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x842b26808, altdest=altdest@entry=0x842b26808, qc=0x8210ac4b0) at ../src/backend/tcop/pquery.c:1322 [01:15:26.734] pstmt = 0x836605a68 [01:15:26.734] stmtlist_item__state = {l = 0x842b267b8, i = 0} [01:15:26.734] active_snapshot_set = false [01:15:26.734] stmtlist_item = 0x842b267d0 [01:15:26.734] #14 0x000000000093e713 in PortalRun (portal=portal@entry=0x8366db100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x842b26808, altdest=altdest@entry=0x842b26808, qc=0x8210ac4b0) at ../src/backend/tcop/pquery.c:791 [01:15:26.734] _local_sigjmp_buf = {{_sjb = {9692813, 35272896768, 34914091944, 34914092176, 34914091952, 35272912896, 12357560, 12390952, 35272852351, 35272795536, 4294967984, 0}}} [01:15:26.734] _save_exception_stack = 0x8210ac580 [01:15:26.734] _save_context_stack = 0x0 [01:15:26.734] _do_rethrow = false [01:15:26.734] saveTopTransactionResourceOwner = 0x8366ecb58 [01:15:26.734] saveTopTransactionContext = 0x8366df000 [01:15:26.734] saveActivePortal = 0x0 [01:15:26.734] saveResourceOwner = 0x8366ecb58 [01:15:26.734] savePortalContext = 0x0 [01:15:26.734] saveMemoryContext = 0x8366df000 [01:15:26.734] result = [01:15:26.734] nprocessed = [01:15:26.734] #15 0x000000000093d5b2 in exec_simple_query (query_string=query_string@entry=0x836604100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [01:15:26.734] cmdtaglen = 24 [01:15:26.734] snapshot_set = [01:15:26.734] per_parsetree_context = 0x0 [01:15:26.734] plantree_list = [01:15:26.734] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:15:26.734] format = 0 [01:15:26.734] parsetree = 0x8366056a8 [01:15:26.734] commandTag = [01:15:26.734] cmdtagname = [01:15:26.734] querytree_list = [01:15:26.734] portal = 0x8366db100 [01:15:26.734] receiver = 0x842b26808 [01:15:26.734] parsetree_item__state = {l = 0x836605a18, i = 0} [01:15:26.734] msec_str = "\000\000\000\000\b", '\000' , "+\302*g\000\000\000\000\200Q\215_.\3328\026" [01:15:26.734] dest = DestRemote [01:15:26.734] was_logged = [01:15:26.734] oldcontext = 0x8366df000 [01:15:26.734] parsetree_list = 0x836605a18 [01:15:26.734] use_implicit_block = false [01:15:26.734] parsetree_item = 0x836605a30 [01:15:26.734] save_log_statement_stats = [01:15:26.734] #16 0x000000000093b223 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [01:15:26.734] query_string = 0x836604100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:15:26.734] input_message = {data = 0x836604100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:15:26.734] firstchar = [01:15:26.734] local_sigjmp_buf = {{_sjb = {9676502, 34914092416, 34914092376, 34914092960, 12399688, 1, 8192, 8388608, 34914042751, 0, 0, 1}}} [01:15:26.734] send_ready_for_query = false [01:15:26.734] idle_in_transaction_timeout_enabled = false [01:15:26.734] idle_session_timeout_enabled = false [01:15:26.734] #17 0x0000000000935a09 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [01:15:26.734] bsdata = [01:15:26.734] #18 0x000000000088d6c7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8210ad2c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8210ad200) at ../src/backend/postmaster/launch_backend.c:266 [01:15:26.734] pid = [01:15:26.734] #19 0x0000000000891a98 in BackendStartup (client_sock=0x8210ad200) at ../src/backend/postmaster/postmaster.c:3417 [01:15:26.734] startup_data = {canAcceptConnections = CAC_OK} [01:15:26.734] bn = 0x836610498 [01:15:26.734] pid = [01:15:26.734] __error = [01:15:26.734] save_errno = [01:15:26.734] __error = [01:15:26.734] __error = [01:15:26.734] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [01:15:26.734] 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_`6\b", '\000' , "`\322\n!\b\000\000\000h\225\330)\b\000\000\000\v\000\000\000\000\000\000\000^\037\331)\b", '\000' , "\240\322\n!\b\000\000\000tԈ\000\000\000\000\000\260\322\n!\b", '\000' }, salen = 16}} [01:15:26.734] i = 0 [01:15:26.734] now = [01:15:26.734] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 752401538, events = 8, fd = 0, user_data = 0x8210ad1b0}, {pos = 912655832, events = 8, fd = 554356800, user_data = 0x0}, {pos = 0, events = 0, fd = 1074295760, user_data = 0x23ba91de730a}, {pos = 751568800, events = 8, fd = 751639928, user_data = 0x8210accc8}, {pos = 554356032, events = 8, fd = 554355912, user_data = 0x23ba91de730a}, {pos = 751547272, events = 8, fd = 751639928, user_data = 0x8210accf8}, {pos = 554356080, events = 8, fd = 554355960, user_data = 0x82ccca194}, {pos = 564139016, events = 8, fd = 751608212, user_data = 0x8210acd60}, {pos = -1847712710, events = 9146, fd = 753430576, user_data = 0x1}, {pos = 554356112, events = 8, fd = -1847692534, user_data = 0x82ccb3858}, {pos = 751639928, events = 8, fd = 554356072, user_data = 0x8210acde0}, {pos = 554356072, events = 8, fd = 751602956, user_data = 0x821a01408}, {pos = 751602956, events = 8, fd = 554356176, user_data = 0x23ba91de243a}, {pos = 554356216, events = 8, fd = 554356664, user_data = 0x8210acde0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1447129168, fd = 564162616, user_data = 0x800000001}, {pos = 564139016, events = 8, fd = 751547272, user_data = 0x821a06288}, {pos = 751515736, events = 8, fd = 564139016, user_data = 0x8210ace68}, {pos = 554356776, events = 8, fd = 554356304, user_data = 0x23ba91de6ca2}, {pos = 2702250, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 564162616, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554357032, user_data = 0x21a01408}, {pos = 554356848, events = 8, fd = 554356448, user_data = 0x1}, {pos = 554356776, events = 8, fd = 32, user_data = 0x8210aced0}, {pos = -1847694733, events = 9146, fd = 554356720, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821a07038}, {pos = 1, events = 8, fd = 564139016, user_data = 0x82ccb3858}, {pos = 554357032, events = 8, fd = 554356848, user_data = 0x8210acee0}, {pos = 0, events = 0, fd = 564109320, user_data = 0x20}, {pos = 554356832, events = 8, fd = -1847719193, user_data = 0x8219fa008}, {pos = 564110344, events = 8, fd = 564111368, user_data = 0x8219fac08}, {pos = 564125704, events = 8, fd = 564126728, user_data = 0x8219fe808}, {pos = 564128776, events = 8, fd = 564129800, user_data = 0x8219ff408}, {pos = 564131848, events = 8, fd = 564132872, user_data = 0x821a00008}, {pos = 564134920, events = 8, fd = 564135944, user_data = 0x821a00c08}, {pos = 564137992, events = 8, fd = 564139016, user_data = 0x821a01808}, {pos = 564141064, events = 8, fd = 564142088, user_data = 0x821a02408}, {pos = 564144136, events = 8, fd = 564145160, user_data = 0x821a03008}, {pos = 564147208, events = 8, fd = 564148232, user_data = 0x821a03c08}, {pos = 564154376, events = 8, fd = 564155400, user_data = 0x821a05808}, {pos = 564157448, events = 8, fd = 564109320, user_data = 0x293baa}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821a07038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554357032, events = 8, fd = 554356448, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 564162616, user_data = 0x1}, {pos = 564109320, events = 8, fd = 298, user_data = 0x8210ad110}, {pos = -1847720465, events = 9146, fd = 2702250, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564162616, user_data = 0x1}, {pos = 564139016, events = 8, fd = 912211968, user_data = 0x1}, {pos = 912212372, events = 8, fd = 0, user_data = 0x8210ad0e0}, {pos = 702092652, events = 8, fd = 1, user_data = 0x8365f4000}, {pos = 554357008, events = 8, fd = 702088962, user_data = 0x82cde5170 }, {pos = 12320552, events = 0, fd = 752767344, user_data = 0x821a01408}, {pos = 554357232, events = 8, fd = -1847720994, user_data = 0x836612800}, {pos = 1, events = 0, fd = -1847721378, user_data = 0x8219fa008}, {pos = 554357016, events = 8, fd = 554357232, user_data = 0x1ab8}, {pos = 912285440, events = 8, fd = -1847641712, user_data = 0x0}, {pos = 554304383, events = 8, fd = 8113383, user_data = 0x8210ad1a0}, {pos = 702051344, events = 8, fd = 753430576, user_data = 0x82ce89310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8210ad1d0}, {pos = 702094237, events = 8, fd = 912211968, user_data = 0x1de9}, {pos = 554357296, events = 8, fd = 702060794, user_data = 0x0}, {pos = 0, events = 0, fd = 1074295760, user_data = 0x0}} [01:15:26.734] last_touch_time = 1730855448 [01:15:26.734] last_lockfile_recheck_time = 1730855448 [01:15:26.734] nevents = 1 [01:15:26.734] #21 0x000000000088f8b5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8210ad810) at ../src/backend/postmaster/postmaster.c:1348 [01:15:26.734] userDoption = [01:15:26.734] listen_addr_saved = [01:15:26.734] output_config_variable = [01:15:26.734] opt = [01:15:26.734] status = [01:15:26.734] #22 0x00000000007c996c in main (argc=8, argv=0x8210ad810) at ../src/backend/main/main.c:196 [01:15:26.734] do_check_root = [01:15:26.743] [01:15:26.743] [01:15:26.743] [01:15:26.811] dumping /tmp/cores/postgres.11251.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:15:26.934] [New LWP 101932] [01:15:26.999] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [01:15:26.999] Program terminated with signal SIGABRT, Aborted. [01:15:26.999] Sent by thr_kill() from pid 11251 and user 1003. [01:15:26.999] #0 0x000000082b25741a in thr_kill () from /lib/libc.so.7 [01:15:27.036] [01:15:27.036] Thread 1 (LWP 101932): [01:15:27.036] #0 0x000000082b25741a in thr_kill () from /lib/libc.so.7 [01:15:27.036] No symbol table info available. [01:15:27.036] #1 0x000000082b1d0e64 in raise () from /lib/libc.so.7 [01:15:27.036] No symbol table info available. [01:15:27.036] #2 0x000000082b2816f9 in abort () from /lib/libc.so.7 [01:15:27.036] No symbol table info available. [01:15:27.036] #3 0x0000000000a95b95 in ExceptionalCondition (conditionName=0x2e7b97 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [01:15:27.036] No locals. [01:15:27.036] #4 0x00000000007665d9 in standard_ExecutorStart (queryDesc=0x841578088, eflags=0) at ../src/backend/executor/execMain.c:194 [01:15:27.036] estate = 0x83338c100 [01:15:27.036] oldcontext = 0x833397800 [01:15:27.036] #5 0x00000000006fd2c5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [01:15:27.036] copied_query = [01:15:27.036] rewritten = [01:15:27.036] plan = 0x8332bdbc8 [01:15:27.036] queryDesc = 0x841578088 [01:15:27.036] processed = [01:15:27.036] __error = [01:15:27.036] #6 RefreshMatViewByOid (matviewOid=27457, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [01:15:27.036] dest = [01:15:27.036] save_userid = 10 [01:15:27.036] save_sec_context = 0 [01:15:27.036] processed = 0 [01:15:27.036] matviewRel = 0x8414a7e00 [01:15:27.036] relowner = 10 [01:15:27.036] save_nestlevel = 2 [01:15:27.036] rule = [01:15:27.036] actions = [01:15:27.036] dataQuery = [01:15:27.036] tableSpace = [01:15:27.036] relpersistence = [01:15:27.036] OIDNewHeap = 27464 [01:15:27.036] address = [01:15:27.036] #7 0x00000000006fcea6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:15:27.036] lockmode = [01:15:27.036] matviewOid = 0 [01:15:27.036] #8 0x00000000006d3fbc in ExecCreateTableAs (pstate=pstate@entry=0x833397900, stmt=stmt@entry=0x833392fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8214fb3a0) at ../src/backend/commands/createas.c:351 [01:15:27.036] refresh = 0x0 [01:15:27.036] query = 0x8332dda98 [01:15:27.036] into = 0x8332ddde0 [01:15:27.036] jstate = 0x0 [01:15:27.036] do_refresh = false [01:15:27.036] address = [01:15:27.036] dest = [01:15:27.036] is_matview = [01:15:27.036] #9 0x0000000000941868 in ProcessUtilitySlow (pstate=pstate@entry=0x833397900, pstmt=pstmt@entry=0x8331f6a68, queryString=queryString@entry=0x8331f5100 "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=0x8214fb3a0) at ../src/backend/tcop/utility.c:1675 [01:15:27.036] _local_sigjmp_buf = {{_sjb = {9703577, 0, 34918608840, 34918609216, 34918608848, 12390952, 0, 35219142912, 4294902655, 34918608956, 34918608992, 0}}} [01:15:27.036] _save_exception_stack = 0x8214fb2a0 [01:15:27.036] _save_context_stack = 0x0 [01:15:27.036] _do_rethrow = false [01:15:27.036] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:15:27.036] parsetree = 0x833392fd0 [01:15:27.036] commandCollected = false [01:15:27.036] needCleanup = false [01:15:27.036] address = [01:15:27.036] isTopLevel = [01:15:27.036] isCompleteQuery = [01:15:27.036] #10 0x00000000009401e8 in standard_ProcessUtility (pstmt=0x8331f6a68, queryString=0x8331f5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8332de2c8, qc=0x8214fb3a0) at ../src/backend/tcop/utility.c:1030 [01:15:27.036] isAtomicContext = false [01:15:27.036] parsetree = 0x833392fd0 [01:15:27.036] readonly_flags = [01:15:27.036] pstate = 0x833397900 [01:15:27.036] isTopLevel = [01:15:27.036] #11 0x000000000093fc78 in ProcessUtility (pstmt=0x18e2c, queryString=0x6 , readOnlyTree=, context=723874810, params=0x0, queryEnv=0x0, dest=0x8332de2c8, qc=0x8214fb3a0) at ../src/backend/tcop/utility.c:523 [01:15:27.036] No locals. [01:15:27.036] #12 0x000000000093f7b3 in PortalRunUtility (portal=0x83329b100, pstmt=0x8331f6a68, isTopLevel=, setHoldSnapshot=, dest=0x8332de2c8, qc=0x8214fb3a0) at ../src/backend/tcop/pquery.c:1158 [01:15:27.036] No locals. [01:15:27.036] #13 0x000000000093ee44 in PortalRunMulti (portal=portal@entry=0x83329b100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8332de2c8, altdest=altdest@entry=0x8332de2c8, qc=0x8214fb3a0) at ../src/backend/tcop/pquery.c:1322 [01:15:27.036] pstmt = 0x8331f6a68 [01:15:27.036] stmtlist_item__state = {l = 0x8332de278, i = 0} [01:15:27.036] active_snapshot_set = false [01:15:27.036] stmtlist_item = 0x8332de290 [01:15:27.036] #14 0x000000000093e713 in PortalRun (portal=portal@entry=0x83329b100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8332de2c8, altdest=altdest@entry=0x8332de2c8, qc=0x8214fb3a0) at ../src/backend/tcop/pquery.c:791 [01:15:27.036] _local_sigjmp_buf = {{_sjb = {9692813, 35218108672, 34918609560, 34918609792, 34918609568, 35218124800, 12357560, 12390952, 35218064255, 35219117456, 4294967984, 0}}} [01:15:27.036] _save_exception_stack = 0x8214fb470 [01:15:27.036] _save_context_stack = 0x0 [01:15:27.036] _do_rethrow = false [01:15:27.036] saveTopTransactionResourceOwner = 0x8332eaa18 [01:15:27.036] saveTopTransactionContext = 0x83329f000 [01:15:27.036] saveActivePortal = 0x0 [01:15:27.036] saveResourceOwner = 0x8332eaa18 [01:15:27.036] savePortalContext = 0x0 [01:15:27.036] saveMemoryContext = 0x83329f000 [01:15:27.036] result = [01:15:27.036] nprocessed = [01:15:27.036] #15 0x000000000093d5b2 in exec_simple_query (query_string=query_string@entry=0x8331f5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [01:15:27.036] cmdtaglen = 24 [01:15:27.036] snapshot_set = [01:15:27.036] per_parsetree_context = 0x0 [01:15:27.036] plantree_list = [01:15:27.036] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:15:27.036] format = 0 [01:15:27.036] parsetree = 0x8331f66a8 [01:15:27.036] commandTag = [01:15:27.036] cmdtagname = [01:15:27.036] querytree_list = [01:15:27.036] portal = 0x83329b100 [01:15:27.036] receiver = 0x8332de2c8 [01:15:27.036] parsetree_item__state = {l = 0x8331f6a18, i = 0} [01:15:27.036] msec_str = "\000\000\000\000\b", '\000' , "/\302*g\000\000\000\000\232E\314L\215\34690" [01:15:27.036] dest = DestRemote [01:15:27.036] was_logged = [01:15:27.036] oldcontext = 0x83329f000 [01:15:27.036] parsetree_list = 0x8331f6a18 [01:15:27.036] use_implicit_block = false [01:15:27.036] parsetree_item = 0x8331f6a30 [01:15:27.036] save_log_statement_stats = [01:15:27.036] #16 0x000000000093b223 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [01:15:27.036] query_string = 0x8331f5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:15:27.036] input_message = {data = 0x8331f5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:15:27.036] firstchar = [01:15:27.036] local_sigjmp_buf = {{_sjb = {9676502, 34918610032, 34918609992, 34918610576, 12399688, 1, 8192, 8388608, 34918564735, 0, 0, 1}}} [01:15:27.036] send_ready_for_query = false [01:15:27.036] idle_in_transaction_timeout_enabled = false [01:15:27.036] idle_session_timeout_enabled = false [01:15:27.036] #17 0x0000000000935a09 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [01:15:27.036] bsdata = [01:15:27.036] #18 0x000000000088d6c7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8214fc1b4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214fc0f0) at ../src/backend/postmaster/launch_backend.c:266 [01:15:27.036] pid = [01:15:27.036] #19 0x0000000000891a98 in BackendStartup (client_sock=0x8214fc0f0) at ../src/backend/postmaster/postmaster.c:3417 [01:15:27.036] startup_data = {canAcceptConnections = CAC_OK} [01:15:27.036] bn = 0x833202fb8 [01:15:27.036] pid = [01:15:27.036] __error = [01:15:27.036] save_errno = [01:15:27.036] __error = [01:15:27.036] __error = [01:15:27.036] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [01:15:27.036] 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 = "\300n\0373\b", '\000' , "P\301O!\b\000\000\000h\265\n*\b\000\000\000\v\000\000\000\000\000\000\000^?\v*\b", '\000' , "\220\301O!\b\000\000\000tԈ\000\000\000\000\000\240\301O!\b", '\000' }, salen = 16}} [01:15:27.036] i = 0 [01:15:27.036] now = [01:15:27.036] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 723500162, events = 8, fd = 0, user_data = 0x8214fc0a0}, {pos = 858125784, events = 8, fd = 558874416, user_data = 0x0}, {pos = 0, events = 0, fd = -707852229, user_data = 0xd04c336c30a}, {pos = 722667424, events = 8, fd = 722738552, user_data = 0x8214fbbb8}, {pos = 558873648, events = 8, fd = 558873528, user_data = 0xd04c336c30a}, {pos = 722645896, events = 8, fd = 722738552, user_data = 0x8214fbbe8}, {pos = 558873696, events = 8, fd = 558873576, user_data = 0x82b13a194}, {pos = 565986312, events = 8, fd = 722706836, user_data = 0x8214fbc50}, {pos = -1019841478, events = 3332, fd = 724529200, user_data = 0x1}, {pos = 558873728, events = 8, fd = -1019821302, user_data = 0x82b123858}, {pos = 722738552, events = 8, fd = 558873688, user_data = 0x8214fbcd0}, {pos = 558873688, events = 8, fd = 722701580, user_data = 0x821bc4408}, {pos = 722701580, events = 8, fd = 558873792, user_data = 0xd04c336743a}, {pos = 558873832, events = 8, fd = 558874280, user_data = 0x8214fbcd0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3758646847, fd = 566009912, user_data = 0x800000001}, {pos = 565986312, events = 8, fd = 722645896, user_data = 0x821bc9288}, {pos = 722614360, events = 8, fd = 565986312, user_data = 0x8214fbd58}, {pos = 558874392, events = 8, fd = 558873920, user_data = 0xd04c336bca2}, {pos = 2702250, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 566009912, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558874648, user_data = 0x21bc4408}, {pos = 558874464, events = 8, fd = 558874064, user_data = 0x1}, {pos = 558874392, events = 8, fd = 32, user_data = 0x8214fbdc0}, {pos = -1019823501, events = 3332, fd = 558874336, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821bca038}, {pos = 1, events = 8, fd = 565986312, user_data = 0x82b123858}, {pos = 558874648, events = 8, fd = 558874464, user_data = 0x8214fbdd0}, {pos = 0, events = 0, fd = 565956616, user_data = 0x20}, {pos = 558874448, events = 8, fd = -1019847961, user_data = 0x821bbd008}, {pos = 565957640, events = 8, fd = 565958664, user_data = 0x821bbdc08}, {pos = 565973000, events = 8, fd = 565974024, user_data = 0x821bc1808}, {pos = 565976072, events = 8, fd = 565977096, user_data = 0x821bc2408}, {pos = 565979144, events = 8, fd = 565980168, user_data = 0x821bc3008}, {pos = 565982216, events = 8, fd = 565983240, user_data = 0x821bc3c08}, {pos = 565985288, events = 8, fd = 565986312, user_data = 0x821bc4808}, {pos = 565988360, events = 8, fd = 565989384, user_data = 0x821bc5408}, {pos = 565991432, events = 8, fd = 565992456, user_data = 0x821bc6008}, {pos = 565994504, events = 8, fd = 565995528, user_data = 0x821bc6c08}, {pos = 566001672, events = 8, fd = 566002696, user_data = 0x821bc8808}, {pos = 566004744, events = 8, fd = 565956616, user_data = 0x293baa}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821bca038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558874648, events = 8, fd = 558874064, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 566009912, user_data = 0x1}, {pos = 565956616, events = 8, fd = 298, user_data = 0x8214fc000}, {pos = -1019849233, events = 3332, fd = 2702250, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 566009912, user_data = 0x1}, {pos = 565986312, events = 8, fd = 857624576, user_data = 0x1}, {pos = 857624980, events = 8, fd = 0, user_data = 0x8214fbfd0}, {pos = 705377644, events = 8, fd = 1, user_data = 0x8331e5000}, {pos = 558874624, events = 8, fd = 705373954, user_data = 0x82b255170 }, {pos = 12320552, events = 0, fd = 723865968, user_data = 0x821bc4408}, {pos = 558874848, events = 8, fd = -1019849762, user_data = 0x833203800}, {pos = 1, events = 0, fd = -1019850146, user_data = 0x821bbd008}, {pos = 558874632, events = 8, fd = 558874848, user_data = 0x1ab8}, {pos = 857697984, events = 8, fd = -1019770480, user_data = 0x0}, {pos = 558826367, events = 8, fd = 8113383, user_data = 0x8214fc090}, {pos = 705336336, events = 8, fd = 724529200, user_data = 0x82b2f9310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214fc0c0}, {pos = 705379229, events = 8, fd = 857624576, user_data = 0x1e23}, {pos = 558874912, events = 8, fd = 705345786, user_data = 0x0}, {pos = 0, events = 0, fd = -707852229, user_data = 0x0}} [01:15:27.036] last_touch_time = 1730855448 [01:15:27.036] last_lockfile_recheck_time = 1730855448 [01:15:27.036] nevents = 1 [01:15:27.036] #21 0x000000000088f8b5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8214fc700) at ../src/backend/postmaster/postmaster.c:1348 [01:15:27.036] userDoption = [01:15:27.036] listen_addr_saved = [01:15:27.036] output_config_variable = [01:15:27.036] opt = [01:15:27.036] status = [01:15:27.036] #22 0x00000000007c996c in main (argc=4, argv=0x8214fc700) at ../src/backend/main/main.c:196 [01:15:27.036] do_check_root = [01:15:27.046] [01:15:27.046] [01:15:27.046] [01:15:27.111] dumping /tmp/cores/postgres.17834.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:15:27.235] [New LWP 100100] [01:15:27.299] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [01:15:27.299] Program terminated with signal SIGABRT, Aborted. [01:15:27.299] Sent by thr_kill() from pid 17834 and user 1003. [01:15:27.299] #0 0x000000082bb6641a in thr_kill () from /lib/libc.so.7 [01:15:27.341] [01:15:27.341] Thread 1 (LWP 100100): [01:15:27.341] #0 0x000000082bb6641a in thr_kill () from /lib/libc.so.7 [01:15:27.341] No symbol table info available. [01:15:27.341] #1 0x000000082badfe64 in raise () from /lib/libc.so.7 [01:15:27.341] No symbol table info available. [01:15:27.341] #2 0x000000082bb906f9 in abort () from /lib/libc.so.7 [01:15:27.341] No symbol table info available. [01:15:27.341] #3 0x0000000000a95b95 in ExceptionalCondition (conditionName=0x2e7b97 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [01:15:27.341] No locals. [01:15:27.341] #4 0x00000000007665d9 in standard_ExecutorStart (queryDesc=0x83538e088, eflags=0) at ../src/backend/executor/execMain.c:194 [01:15:27.341] estate = 0x835349100 [01:15:27.341] oldcontext = 0x837412800 [01:15:27.341] #5 0x0000000836b7d9c2 in pgss_ExecutorStart (queryDesc=0x83538e088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [01:15:27.341] No locals. [01:15:27.341] #6 0x00000000006fd2c5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [01:15:27.341] copied_query = [01:15:27.341] rewritten = [01:15:27.341] plan = 0x8353ddbd8 [01:15:27.341] queryDesc = 0x83538e088 [01:15:27.341] processed = [01:15:27.341] __error = [01:15:27.341] #7 RefreshMatViewByOid (matviewOid=27448, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [01:15:27.341] dest = [01:15:27.341] save_userid = 10 [01:15:27.341] save_sec_context = 0 [01:15:27.341] processed = 0 [01:15:27.341] matviewRel = 0x837375df8 [01:15:27.341] relowner = 10 [01:15:27.341] save_nestlevel = 2 [01:15:27.341] rule = [01:15:27.341] actions = [01:15:27.341] dataQuery = [01:15:27.341] tableSpace = [01:15:27.341] relpersistence = [01:15:27.341] OIDNewHeap = 27455 [01:15:27.341] address = [01:15:27.341] #8 0x00000000006fcea6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:15:27.341] lockmode = [01:15:27.341] matviewOid = 0 [01:15:27.341] #9 0x00000000006d3fbc in ExecCreateTableAs (pstate=pstate@entry=0x837412900, stmt=stmt@entry=0x8352a6fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821900060) at ../src/backend/commands/createas.c:351 [01:15:27.341] refresh = 0x0 [01:15:27.341] query = 0x8352f1808 [01:15:27.341] into = 0x8352a6f40 [01:15:27.341] jstate = 0x0 [01:15:27.341] do_refresh = false [01:15:27.341] address = [01:15:27.341] dest = [01:15:27.341] is_matview = [01:15:27.341] #10 0x0000000000941868 in ProcessUtilitySlow (pstate=pstate@entry=0x837412900, pstmt=pstmt@entry=0x8352a6e30, queryString=queryString@entry=0x835209100 "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=0x821900060) at ../src/backend/tcop/utility.c:1675 [01:15:27.341] _local_sigjmp_buf = {{_sjb = {9703577, 0, 34922822344, 34922822720, 34922822352, 12390952, 0, 35286755584, 34922759039, 7, 34922822496, 0}}} [01:15:27.341] _save_exception_stack = 0x8218ffd50 [01:15:27.341] _save_context_stack = 0x0 [01:15:27.341] _do_rethrow = false [01:15:27.341] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:15:27.341] parsetree = 0x8352a6fd0 [01:15:27.341] commandCollected = false [01:15:27.341] needCleanup = false [01:15:27.341] address = [01:15:27.341] isTopLevel = [01:15:27.341] isCompleteQuery = [01:15:27.341] #11 0x00000000009401e8 in standard_ProcessUtility (pstmt=0x8352a6e30, queryString=queryString@entry=0x835209100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8352f1fa8, qc=0x821900060) at ../src/backend/tcop/utility.c:1030 [01:15:27.341] isAtomicContext = false [01:15:27.341] parsetree = 0x8352a6fd0 [01:15:27.341] readonly_flags = [01:15:27.341] pstate = 0x837412900 [01:15:27.341] isTopLevel = [01:15:27.341] #12 0x0000000836b7df7e in pgss_ProcessUtility (pstmt=0x8352a6e30, queryString=0x835209100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8352f1fa8, qc=0x821900060) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [01:15:27.341] _local_sigjmp_buf = {{_sjb = {35277758135, 34922822992, 34922822856, 34922823312, 35251711536, 0, 12390952, 34922823520, 34922759039, 34922823092, 34922823120, 0}}} [01:15:27.341] _save_exception_stack = 0x8218fff60 [01:15:27.341] _save_context_stack = 0x0 [01:15:27.341] _do_rethrow = false [01:15:27.341] bufusage = {shared_blks_hit = 35277758135, shared_blks_read = 34922822992, shared_blks_dirtied = 34922822856, shared_blks_written = 34922823312, local_blks_hit = 35251711536, local_blks_read = 0, local_blks_dirtied = 12390952, local_blks_written = 34922823520, temp_blks_read = 34922759039, temp_blks_written = 34922823092, shared_blk_read_time = {ticks = 34922823120}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4107895293394106496}, local_blk_write_time = {ticks = 12399992}, temp_blk_read_time = {ticks = 35320367104}, temp_blk_write_time = {ticks = 12353504}} [01:15:27.341] walusage_start = {wal_records = 8947, wal_fpi = 117, wal_bytes = 1234945} [01:15:27.341] duration = [01:15:27.341] bufusage_start = {shared_blks_hit = 151978, shared_blks_read = 8812, shared_blks_dirtied = 2774, shared_blks_written = 2114, 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}} [01:15:27.341] walusage = {wal_records = 5589249809640442991, wal_fpi = 35251711952, wal_bytes = 123} [01:15:27.341] start = {ticks = -187105298674} [01:15:27.341] rows = [01:15:27.341] saved_queryId = 6041762721901209185 [01:15:27.341] parsetree = [01:15:27.341] saved_stmt_location = 0 [01:15:27.341] saved_stmt_len = 69 [01:15:27.341] enabled = [01:15:27.341] #13 0x000000000093f7b3 in PortalRunUtility (portal=0x8352b1100, pstmt=0x8352a6e30, isTopLevel=, setHoldSnapshot=, dest=0x8352f1fa8, qc=0x821900060) at ../src/backend/tcop/pquery.c:1158 [01:15:27.341] No locals. [01:15:27.341] #14 0x000000000093ee44 in PortalRunMulti (portal=portal@entry=0x8352b1100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8352f1fa8, altdest=altdest@entry=0x8352f1fa8, qc=0x821900060) at ../src/backend/tcop/pquery.c:1322 [01:15:27.341] pstmt = 0x8352a6e30 [01:15:27.341] stmtlist_item__state = {l = 0x8352f1f58, i = 0} [01:15:27.341] active_snapshot_set = false [01:15:27.341] stmtlist_item = 0x8352f1f70 [01:15:27.341] #15 0x000000000093e713 in PortalRun (portal=portal@entry=0x8352b1100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8352f1fa8, altdest=altdest@entry=0x8352f1fa8, qc=0x821900060) at ../src/backend/tcop/pquery.c:791 [01:15:27.341] _local_sigjmp_buf = {{_sjb = {9692813, 35251753216, 34922823512, 34922823744, 34922823520, 35251847168, 12357560, 12390952, 35251749759, 35251705312, 4294967984, 0}}} [01:15:27.341] _save_exception_stack = 0x821900130 [01:15:27.341] _save_context_stack = 0x0 [01:15:27.341] _do_rethrow = false [01:15:27.341] saveTopTransactionResourceOwner = 0x8352ff158 [01:15:27.341] saveTopTransactionContext = 0x8352c8000 [01:15:27.341] saveActivePortal = 0x0 [01:15:27.341] saveResourceOwner = 0x8352ff158 [01:15:27.341] savePortalContext = 0x0 [01:15:27.341] saveMemoryContext = 0x8352c8000 [01:15:27.341] result = [01:15:27.341] nprocessed = [01:15:27.341] #16 0x000000000093d5b2 in exec_simple_query (query_string=query_string@entry=0x835209100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [01:15:27.341] cmdtaglen = 24 [01:15:27.341] snapshot_set = [01:15:27.341] per_parsetree_context = 0x0 [01:15:27.341] plantree_list = [01:15:27.341] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:15:27.341] format = 0 [01:15:27.341] parsetree = 0x83520a6a8 [01:15:27.341] commandTag = [01:15:27.341] cmdtagname = [01:15:27.341] querytree_list = [01:15:27.341] portal = 0x8352b1100 [01:15:27.341] receiver = 0x8352f1fa8 [01:15:27.341] parsetree_item__state = {l = 0x83520aa18, i = 0} [01:15:27.341] msec_str = "\000\000\000\000\b", '\000' , "S\302*g\000\000\000\000Z\335\004f\215y", [01:15:27.341] dest = DestRemote [01:15:27.341] was_logged = [01:15:27.341] oldcontext = 0x8352c8000 [01:15:27.341] parsetree_list = 0x83520aa18 [01:15:27.341] use_implicit_block = false [01:15:27.341] parsetree_item = 0x83520aa30 [01:15:27.341] save_log_statement_stats = [01:15:27.341] #17 0x000000000093b223 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [01:15:27.341] query_string = 0x835209100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:15:27.341] input_message = {data = 0x835209100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:15:27.341] firstchar = [01:15:27.341] local_sigjmp_buf = {{_sjb = {9676502, 34922823984, 34922823944, 34922824528, 12399688, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [01:15:27.341] send_ready_for_query = false [01:15:27.341] idle_in_transaction_timeout_enabled = false [01:15:27.341] idle_session_timeout_enabled = false [01:15:27.341] #18 0x0000000000935a09 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [01:15:27.341] bsdata = [01:15:27.341] #19 0x000000000088d6c7 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821900e74 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821900db0) at ../src/backend/postmaster/launch_backend.c:266 [01:15:27.341] pid = [01:15:27.341] #20 0x0000000000891a98 in BackendStartup (client_sock=0x821900db0) at ../src/backend/postmaster/postmaster.c:3417 [01:15:27.341] startup_data = {canAcceptConnections = CAC_OK} [01:15:27.341] bn = 0x8352153f8 [01:15:27.341] pid = [01:15:27.341] __error = [01:15:27.341] save_errno = [01:15:27.341] __error = [01:15:27.341] __error = [01:15:27.341] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [01:15:27.341] 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 = " \234 5\b", '\000' , "\020\016\220!\b\000\000\000h\005\343*\b\000\000\000\v\000\000\000\000\000\000\000^\217\343*\b", '\000' , "P\016\220!\b\000\000\000tԈ\000\000\000\000\000`\016\220!\b", '\000' }, salen = 16}} [01:15:27.341] i = 0 [01:15:27.341] now = [01:15:27.341] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 732998786, events = 8, fd = 0, user_data = 0x821900d60}, {pos = 891733464, events = 8, fd = 563088368, user_data = 0x0}, {pos = 1655350026, events = 11445, fd = 732166048, user_data = 0x82ba50d78}, {pos = 563087464, events = 8, fd = 563087584, user_data = 0x821900868}, {pos = 1655350026, events = 11445, fd = 732144520, user_data = 0x82ba50d78}, {pos = 563087512, events = 8, fd = 563087632, user_data = 0x821900898}, {pos = 732205460, events = 8, fd = 576529416, user_data = 0x82ba49194}, {pos = 563087616, events = 8, fd = 1655329850, user_data = 0x8219008a0}, {pos = 719512592, events = 8, fd = 734027824, user_data = 0x2cb562aaa30a}, {pos = 732112984, events = 8, fd = 732237176, user_data = 0x821900908}, {pos = 563087744, events = 8, fd = 563087624, user_data = 0x82ba47d0c}, {pos = 576529416, events = 8, fd = 732200204, user_data = 0x821900970}, {pos = 1655329850, events = 11445, fd = 563087768, user_data = 0x821900b68}, {pos = 563087744, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x8225d8038}, {pos = 1, events = 1301348630, fd = 576529416, user_data = 0x82ba3a388}, {pos = 576550856, events = 8, fd = 0, user_data = 0x0}, {pos = 563087880, events = 8, fd = 563088344, user_data = 0x8219009f0}, {pos = 1655348386, events = 11445, fd = 2702250, user_data = 0x6d68b}, {pos = 2090263927, events = 1301348630, fd = 576553016, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821900cd8}, {pos = 576529416, events = 3, fd = 563088416, user_data = 0x8225d7828}, {pos = 656, events = 0, fd = 563088344, user_data = 0x821900a08}, {pos = 563087984, events = 8, fd = 1655347995, user_data = 0x821900ba0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 576553016, events = 8, fd = 1, user_data = 0x8225d2408}, {pos = 732112984, events = 8, fd = 563088600, user_data = 0x821900c20}, {pos = 563088000, events = 8, fd = 0, user_data = 0x8225cb008}, {pos = 33, events = 0, fd = 563088400, user_data = 0x2cb562aa3ae7}, {pos = 576499720, events = 8, fd = 576500744, user_data = 0x8225cb808}, {pos = 576502792, events = 8, fd = 576516104, user_data = 0x8225cf408}, {pos = 576518152, events = 8, fd = 576519176, user_data = 0x8225d0008}, {pos = 576521224, events = 8, fd = 576522248, user_data = 0x8225d0c08}, {pos = 576524296, events = 8, fd = 576525320, user_data = 0x8225d1808}, {pos = 576527368, events = 8, fd = 576528392, user_data = 0x8225d2408}, {pos = 576530440, events = 8, fd = 576531464, user_data = 0x8225d3008}, {pos = 576533512, events = 8, fd = 576534536, user_data = 0x8225d3c08}, {pos = 576536584, events = 8, fd = 576537608, user_data = 0x8225d4808}, {pos = 576539656, events = 8, fd = 576544776, user_data = 0x8225d6408}, {pos = 576546824, events = 8, fd = 576547848, user_data = 0x8225d9408}, {pos = 153317000, events = 0, fd = 576499720, user_data = 0x293baa}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8225d8038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 563088600, events = 8, fd = 563088000, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 576553016, user_data = 0x1}, {pos = 576499720, events = 8, fd = 298, user_data = 0x821900cc0}, {pos = 1655322095, events = 11445, fd = 2702250, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 576553016, user_data = 0x1}, {pos = 576529416, events = 8, fd = 891260928, user_data = 0x1}, {pos = 891261332, events = 8, fd = 0, user_data = 0x821900c90}, {pos = 719553900, events = 8, fd = 1, user_data = 0x8351f9000}, {pos = 563088576, events = 8, fd = 719550210, user_data = 0x82bb64170 }, {pos = 12320552, events = 0, fd = 733364592, user_data = 0x8225d2408}, {pos = 563088800, events = 8, fd = 1655321566, user_data = 0x835217800}, {pos = 1, events = 0, fd = 1655321182, user_data = 0x8225cb008}, {pos = 563088584, events = 8, fd = 563088800, user_data = 0x1ab8}, {pos = 891329568, events = 8, fd = 1655400848, user_data = 0x0}, {pos = 563086207, events = 8, fd = 8113383, user_data = 0x821900d50}, {pos = 719512592, events = 8, fd = 734027824, user_data = 0x82bc08310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821900d80}, {pos = 719555485, events = 8, fd = 891260928, user_data = 0x3696}, {pos = 563088864, events = 8, fd = 719522042, user_data = 0x0}, {pos = 0, events = 0, fd = -1198928785, user_data = 0x0}} [01:15:27.341] last_touch_time = 1730855482 [01:15:27.341] last_lockfile_recheck_time = 1730855482 [01:15:27.341] nevents = 1 [01:15:27.341] #22 0x000000000088f8b5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8219013c8) at ../src/backend/postmaster/postmaster.c:1348 [01:15:27.341] userDoption = [01:15:27.341] listen_addr_saved = [01:15:27.341] output_config_variable = [01:15:27.341] opt = [01:15:27.341] status = [01:15:27.341] #23 0x00000000007c996c in main (argc=4, argv=0x8219013c8) at ../src/backend/main/main.c:196 [01:15:27.341] do_check_root =