[20:30:27.806] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [20:30:28.109] dumping /tmp/cores/postgres.10830.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:30:28.238] [New LWP 101946] [20:30:28.320] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [20:30:28.320] Program terminated with signal SIGABRT, Aborted. [20:30:28.320] Sent by thr_kill() from pid 10830 and user 1003. [20:30:28.320] #0 0x000000082a88441a in thr_kill () from /lib/libc.so.7 [20:30:28.371] [20:30:28.371] Thread 1 (LWP 101946): [20:30:28.371] #0 0x000000082a88441a in thr_kill () from /lib/libc.so.7 [20:30:28.371] No symbol table info available. [20:30:28.371] #1 0x000000082a7fde64 in raise () from /lib/libc.so.7 [20:30:28.371] No symbol table info available. [20:30:28.371] #2 0x000000082a8ae6f9 in abort () from /lib/libc.so.7 [20:30:28.371] No symbol table info available. [20:30:28.371] #3 0x0000000000aaa5d5 in ExceptionalCondition (conditionName=0x2ed211 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [20:30:28.371] No locals. [20:30:28.371] #4 0x0000000000772bd9 in standard_ExecutorStart (queryDesc=0x835f9dbd0, eflags=0) at ../src/backend/executor/execMain.c:193 [20:30:28.371] estate = 0x838670100 [20:30:28.371] oldcontext = 0x835f83800 [20:30:28.371] #5 0x000000000070718f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [20:30:28.371] copied_query = [20:30:28.371] rewritten = [20:30:28.371] plan = 0x835f9d778 [20:30:28.371] queryDesc = 0x835f9dbd0 [20:30:28.371] processed = [20:30:28.371] __error = [20:30:28.371] #6 RefreshMatViewByOid (matviewOid=28513, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [20:30:28.371] dest = [20:30:28.371] save_userid = 10 [20:30:28.371] save_sec_context = 0 [20:30:28.371] processed = 0 [20:30:28.371] matviewRel = 0x8386e6758 [20:30:28.371] relowner = 10 [20:30:28.371] save_nestlevel = 2 [20:30:28.371] rule = [20:30:28.371] actions = [20:30:28.371] dataQuery = [20:30:28.371] tableSpace = [20:30:28.371] relpersistence = [20:30:28.371] OIDNewHeap = 28521 [20:30:28.371] address = [20:30:28.371] #7 0x0000000000706d66 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:30:28.371] lockmode = [20:30:28.371] matviewOid = 0 [20:30:28.371] #8 0x00000000006ddd5c in ExecCreateTableAs (pstate=pstate@entry=0x835f83900, stmt=stmt@entry=0x835f94fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82166a0f0) at ../src/backend/commands/createas.c:351 [20:30:28.371] refresh = 0x0 [20:30:28.371] query = 0x835fb4158 [20:30:28.371] into = 0x835fb44a0 [20:30:28.371] jstate = 0x0 [20:30:28.371] do_refresh = false [20:30:28.371] address = [20:30:28.371] dest = [20:30:28.371] is_matview = [20:30:28.371] #9 0x0000000000952dcb in ProcessUtilitySlow (pstate=pstate@entry=0x835f83900, pstmt=pstmt@entry=0x835ed6a68, queryString=queryString@entry=0x835ed5100 "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=0x82166a0f0) at ../src/backend/tcop/utility.c:1678 [20:30:28.371] _local_sigjmp_buf = {{_sjb = {9774585, 0, 34920111384, 34920111760, 34920111392, 12495608, 0, 35265198336, 12387199, 1, 4294967295, 34359738368}}} [20:30:28.371] _save_exception_stack = 0x821669ff0 [20:30:28.371] _save_context_stack = 0x0 [20:30:28.371] _do_rethrow = false [20:30:28.371] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:30:28.371] parsetree = 0x835f94fd0 [20:30:28.371] commandCollected = false [20:30:28.371] needCleanup = false [20:30:28.371] address = [20:30:28.371] isTopLevel = [20:30:28.371] isCompleteQuery = [20:30:28.371] #10 0x0000000000951748 in standard_ProcessUtility (pstmt=0x835ed6a68, queryString=0x835ed5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835fb4988, qc=0x82166a0f0) at ../src/backend/tcop/utility.c:1033 [20:30:28.371] isAtomicContext = false [20:30:28.371] parsetree = 0x835f94fd0 [20:30:28.371] readonly_flags = [20:30:28.371] pstate = 0x835f83900 [20:30:28.371] isTopLevel = [20:30:28.371] #11 0x00000000009511d8 in ProcessUtility (pstmt=0x18e3a, queryString=0x6 , readOnlyTree=, context=713573370, params=0x0, queryEnv=0x0, dest=0x835fb4988, qc=0x82166a0f0) at ../src/backend/tcop/utility.c:523 [20:30:28.371] No locals. [20:30:28.371] #12 0x0000000000950d13 in PortalRunUtility (portal=0x835fac100, pstmt=0x835ed6a68, isTopLevel=, setHoldSnapshot=, dest=0x835fb4988, qc=0x82166a0f0) at ../src/backend/tcop/pquery.c:1152 [20:30:28.371] No locals. [20:30:28.371] #13 0x00000000009503d4 in PortalRunMulti (portal=portal@entry=0x835fac100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835fb4988, altdest=altdest@entry=0x835fb4988, qc=qc@entry=0x82166a0f0) at ../src/backend/tcop/pquery.c:1316 [20:30:28.371] pstmt = 0x835ed6a68 [20:30:28.371] stmtlist_item__state = {l = 0x835fb4938, i = 0} [20:30:28.371] active_snapshot_set = false [20:30:28.371] stmtlist_item = 0x835fb4950 [20:30:28.371] #14 0x000000000094fcbb in PortalRun (portal=portal@entry=0x835fac100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x835fb4988, altdest=altdest@entry=0x835fb4988, qc=qc@entry=0x82166a0f0) at ../src/backend/tcop/pquery.c:787 [20:30:28.371] _local_sigjmp_buf = {{_sjb = {9763893, 35265364224, 34920112104, 34920112352, 34920112112, 12495608, 34920112368, 12451576, 12387199, 0, 35265315711, 34359738368}}} [20:30:28.371] _save_exception_stack = 0x82166a1a0 [20:30:28.371] _save_context_stack = 0x0 [20:30:28.371] _do_rethrow = false [20:30:28.371] saveTopTransactionResourceOwner = 0x835fbad08 [20:30:28.371] saveTopTransactionContext = 0x835fb0000 [20:30:28.371] saveActivePortal = 0x0 [20:30:28.371] saveResourceOwner = 0x835fbad08 [20:30:28.371] savePortalContext = 0x0 [20:30:28.371] saveMemoryContext = 0x835fb0000 [20:30:28.371] result = [20:30:28.371] nprocessed = [20:30:28.371] #15 0x000000000094eb49 in exec_simple_query (query_string=query_string@entry=0x835ed5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [20:30:28.371] cmdtaglen = 24 [20:30:28.371] snapshot_set = [20:30:28.371] per_parsetree_context = 0x0 [20:30:28.371] plantree_list = [20:30:28.371] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:30:28.371] format = 0 [20:30:28.371] parsetree = 0x835ed66a8 [20:30:28.371] commandTag = [20:30:28.371] cmdtagname = [20:30:28.371] querytree_list = [20:30:28.371] portal = 0x835fac100 [20:30:28.371] receiver = 0x835fb4988 [20:30:28.371] parsetree_item__state = {l = 0x835ed6a18, i = 0} [20:30:28.371] msec_str = "\000\000\000\000\b", '\000' , "\"k\211g\000\000\000\000\364\354\266\367\354", [20:30:28.371] dest = DestRemote [20:30:28.371] was_logged = [20:30:28.371] oldcontext = 0x835fb0000 [20:30:28.371] parsetree_list = 0x835ed6a18 [20:30:28.371] use_implicit_block = false [20:30:28.371] parsetree_item = 0x835ed6a30 [20:30:28.371] save_log_statement_stats = [20:30:28.371] #16 0x000000000094c7b3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [20:30:28.371] query_string = 0x835ed5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:30:28.371] input_message = {data = 0x835ed5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:30:28.371] firstchar = [20:30:28.371] local_sigjmp_buf = {{_sjb = {9747558, 34920112544, 34920112536, 34920113088, 12504360, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [20:30:28.371] send_ready_for_query = false [20:30:28.371] idle_in_transaction_timeout_enabled = false [20:30:28.371] idle_session_timeout_enabled = false [20:30:28.371] #17 0x0000000000947159 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:30:28.371] bsdata = [20:30:28.371] #18 0x000000000089e4c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x82166aed0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82166ae20) at ../src/backend/postmaster/launch_backend.c:274 [20:30:28.371] pid = [20:30:28.371] #19 0x00000000008a2a16 in BackendStartup (client_sock=0x82166ae20) at ../src/backend/postmaster/postmaster.c:3466 [20:30:28.371] startup_data = {canAcceptConnections = CAC_OK} [20:30:28.371] bn = 0x835f78098 [20:30:28.371] cac = CAC_OK [20:30:28.371] pid = [20:30:28.371] __error = [20:30:28.371] save_errno = [20:30:28.371] __error = [20:30:28.371] __error = [20:30:28.371] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [20:30:28.371] 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 = "\f", '\000' , "\200\256f!\b\000\000\000h%\320+\b\000\000\000\372\000\000\000\000\000\000\000^\257\320+\b", '\000' , "\300\256f!\b\000\000\000T\342\211\000\000\000\000\000Юf!\b", '\000' }, salen = 16}} [20:30:28.371] i = 0 [20:30:28.371] now = [20:30:28.371] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713198722, events = 8, fd = 0, user_data = 0x82166add0}, {pos = 905123288, events = 8, fd = 560376928, user_data = 0x82166a9c0}, {pos = 8192, events = 0, fd = 8192, user_data = 0x835fa4000}, {pos = 560376264, events = 8, fd = 0, user_data = 0x8349fd090}, {pos = 1, events = 0, fd = 560376064, user_data = 0x82a8f39c9}, {pos = 712344456, events = 8, fd = 712437112, user_data = 0x82166a918}, {pos = 560376208, events = 8, fd = 560376256, user_data = 0x82166a9b8}, {pos = 882888848, events = 8, fd = 887097728, user_data = 0x20}, {pos = 4096, events = 0, fd = 560376704, user_data = 0x82a8eea7c}, {pos = 560376248, events = 8, fd = -114253046, user_data = 0x82a750858}, {pos = 712437112, events = 8, fd = 560376200, user_data = 0x82166aa00}, {pos = 560376200, events = 8, fd = 712400140, user_data = 0x8221fa408}, {pos = 712400140, events = 8, fd = 560376304, user_data = 0x3b85f930543a}, {pos = 882888896, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 887108152, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8221ff288}, {pos = 712312920, events = 8, fd = 572498952, user_data = 0x82166aa88}, {pos = 560376904, events = 8, fd = 560376432, user_data = 0x3b85f9309ca2}, {pos = 2721811, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 572522552, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 560377160, user_data = 0x221fa408}, {pos = 560376976, events = 8, fd = 560376576, user_data = 0x1}, {pos = 560376904, events = 8, fd = 32, user_data = 0x82166aaf0}, {pos = -114255245, events = 15237, fd = 560376848, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822200038}, {pos = 1, events = 8, fd = 572498952, user_data = 0x82a750858}, {pos = 560377160, events = 8, fd = 560376976, user_data = 0x82166ab00}, {pos = 0, events = 0, fd = 572469256, user_data = 0x20}, {pos = 560376960, events = 8, fd = -114279705, user_data = 0x8221f3008}, {pos = 572470280, events = 8, fd = 572471304, user_data = 0x8221f3c08}, {pos = 572485640, events = 8, fd = 572486664, user_data = 0x8221f7808}, {pos = 572488712, events = 8, fd = 572489736, user_data = 0x8221f8408}, {pos = 572491784, events = 8, fd = 572492808, user_data = 0x8221f9008}, {pos = 572494856, events = 8, fd = 572495880, user_data = 0x8221f9c08}, {pos = 572497928, events = 8, fd = 572498952, user_data = 0x8221fa808}, {pos = 572501000, events = 8, fd = 572502024, user_data = 0x8221fb408}, {pos = 572504072, events = 8, fd = 572505096, user_data = 0x8221fc008}, {pos = 572507144, events = 8, fd = 572508168, user_data = 0x8221fcc08}, {pos = 572514312, events = 8, fd = 572515336, user_data = 0x8221fe808}, {pos = 572517384, events = 8, fd = 572469256, user_data = 0x298813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822200038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 560377160, events = 8, fd = 560376576, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 572522552, user_data = 0x1}, {pos = 572469256, events = 8, fd = 298, user_data = 0x82166ad30}, {pos = -114280977, events = 15237, fd = 2721811, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 572522552, user_data = 0x1}, {pos = 572498952, events = 8, fd = 904679424, user_data = 0x1}, {pos = 904679828, events = 8, fd = 0, user_data = 0x82166ad00}, {pos = 735094124, events = 8, fd = 1, user_data = 0x835ec5000}, {pos = 560377136, events = 8, fd = 735090434, user_data = 0x82a882170 }, {pos = 12413984, events = 0, fd = 713564528, user_data = 0x8221fa408}, {pos = 560377360, events = 8, fd = -114281506, user_data = 0x835ee3800}, {pos = 1, events = 8, fd = -114281890, user_data = 0x8221f3008}, {pos = 560377144, events = 8, fd = 560377360, user_data = 0x1ab8}, {pos = 11, events = 0, fd = -114202224, user_data = 0x0}, {pos = 560333695, events = 8, fd = 8170167, user_data = 0x82166adc0}, {pos = 735052816, events = 8, fd = 714227760, user_data = 0x82a926310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82166adf0}, {pos = 735095709, events = 8, fd = 904679424, user_data = 0x1dc4}, {pos = 560377424, events = 8, fd = 735062266, user_data = 0x0}, {pos = 0, events = 0, fd = 648195873, user_data = 0x0}} [20:30:28.371] last_touch_time = 1737059085 [20:30:28.371] last_lockfile_recheck_time = 1737059085 [20:30:28.371] nevents = 1 [20:30:28.371] #21 0x00000000008a0ca4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82166b440) at ../src/backend/postmaster/postmaster.c:1377 [20:30:28.371] userDoption = [20:30:28.371] listen_addr_saved = false [20:30:28.371] output_config_variable = [20:30:28.371] opt = [20:30:28.371] status = [20:30:28.371] #22 0x00000000007d7790 in main (argc=8, argv=0x82166b440) at ../src/backend/main/main.c:230 [20:30:28.371] do_check_root = [20:30:28.371] dispatch_option = DISPATCH_POSTMASTER [20:30:28.381] [20:30:28.381] [20:30:28.381] [20:30:28.442] dumping /tmp/cores/postgres.11111.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:30:28.571] [New LWP 101860] [20:30:28.634] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [20:30:28.634] Program terminated with signal SIGABRT, Aborted. [20:30:28.634] Sent by thr_kill() from pid 11111 and user 1003. [20:30:28.634] #0 0x000000082d7f741a in thr_kill () from /lib/libc.so.7 [20:30:28.665] [20:30:28.665] Thread 1 (LWP 101860): [20:30:28.665] #0 0x000000082d7f741a in thr_kill () from /lib/libc.so.7 [20:30:28.665] No symbol table info available. [20:30:28.665] #1 0x000000082d770e64 in raise () from /lib/libc.so.7 [20:30:28.665] No symbol table info available. [20:30:28.665] #2 0x000000082d8216f9 in abort () from /lib/libc.so.7 [20:30:28.665] No symbol table info available. [20:30:28.665] #3 0x0000000000aaa5d5 in ExceptionalCondition (conditionName=0x2ed211 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [20:30:28.665] No locals. [20:30:28.665] #4 0x0000000000772bd9 in standard_ExecutorStart (queryDesc=0x835fb4bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [20:30:28.665] estate = 0x8360ae100 [20:30:28.665] oldcontext = 0x835fa0800 [20:30:28.665] #5 0x000000000070718f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [20:30:28.665] copied_query = [20:30:28.665] rewritten = [20:30:28.665] plan = 0x835fb4778 [20:30:28.665] queryDesc = 0x835fb4bd0 [20:30:28.665] processed = [20:30:28.665] __error = [20:30:28.665] #6 RefreshMatViewByOid (matviewOid=28444, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [20:30:28.665] dest = [20:30:28.665] save_userid = 10 [20:30:28.665] save_sec_context = 0 [20:30:28.665] processed = 0 [20:30:28.665] matviewRel = 0x841b5bef8 [20:30:28.665] relowner = 10 [20:30:28.665] save_nestlevel = 2 [20:30:28.665] rule = [20:30:28.665] actions = [20:30:28.665] dataQuery = [20:30:28.665] tableSpace = [20:30:28.665] relpersistence = [20:30:28.665] OIDNewHeap = 28452 [20:30:28.665] address = [20:30:28.665] #7 0x0000000000706d66 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:30:28.665] lockmode = [20:30:28.665] matviewOid = 0 [20:30:28.665] #8 0x00000000006ddd5c in ExecCreateTableAs (pstate=pstate@entry=0x835fa0900, stmt=stmt@entry=0x835f4dfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821926870) at ../src/backend/commands/createas.c:351 [20:30:28.665] refresh = 0x0 [20:30:28.665] query = 0x835fbc558 [20:30:28.665] into = 0x835fbc8a0 [20:30:28.665] jstate = 0x0 [20:30:28.665] do_refresh = false [20:30:28.665] address = [20:30:28.665] dest = [20:30:28.665] is_matview = [20:30:28.665] #9 0x0000000000952dcb in ProcessUtilitySlow (pstate=pstate@entry=0x835fa0900, pstmt=pstmt@entry=0x835ed5a68, queryString=queryString@entry=0x835ed4100 "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=0x821926870) at ../src/backend/tcop/utility.c:1678 [20:30:28.665] _local_sigjmp_buf = {{_sjb = {9774585, 0, 34922980504, 34922980880, 34922980512, 12495608, 0, 35265317120, 12387199, 1, 4294967295, 34359738368}}} [20:30:28.665] _save_exception_stack = 0x821926770 [20:30:28.665] _save_context_stack = 0x0 [20:30:28.665] _do_rethrow = false [20:30:28.665] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:30:28.665] parsetree = 0x835f4dfd0 [20:30:28.665] commandCollected = false [20:30:28.665] needCleanup = false [20:30:28.665] address = [20:30:28.665] isTopLevel = [20:30:28.665] isCompleteQuery = [20:30:28.665] #10 0x0000000000951748 in standard_ProcessUtility (pstmt=0x835ed5a68, queryString=0x835ed4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835fbcd88, qc=0x821926870) at ../src/backend/tcop/utility.c:1033 [20:30:28.665] isAtomicContext = false [20:30:28.665] parsetree = 0x835f4dfd0 [20:30:28.665] readonly_flags = [20:30:28.665] pstate = 0x835fa0900 [20:30:28.665] isTopLevel = [20:30:28.665] #11 0x00000000009511d8 in ProcessUtility (pstmt=0x18de4, queryString=0x6 , readOnlyTree=, context=763327482, params=0x0, queryEnv=0x0, dest=0x835fbcd88, qc=0x821926870) at ../src/backend/tcop/utility.c:523 [20:30:28.665] No locals. [20:30:28.665] #12 0x0000000000950d13 in PortalRunUtility (portal=0x835f7a100, pstmt=0x835ed5a68, isTopLevel=, setHoldSnapshot=, dest=0x835fbcd88, qc=0x821926870) at ../src/backend/tcop/pquery.c:1152 [20:30:28.665] No locals. [20:30:28.665] #13 0x00000000009503d4 in PortalRunMulti (portal=portal@entry=0x835f7a100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835fbcd88, altdest=altdest@entry=0x835fbcd88, qc=qc@entry=0x821926870) at ../src/backend/tcop/pquery.c:1316 [20:30:28.665] pstmt = 0x835ed5a68 [20:30:28.665] stmtlist_item__state = {l = 0x835fbcd38, i = 0} [20:30:28.665] active_snapshot_set = false [20:30:28.665] stmtlist_item = 0x835fbcd50 [20:30:28.665] #14 0x000000000094fcbb in PortalRun (portal=portal@entry=0x835f7a100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x835fbcd88, altdest=altdest@entry=0x835fbcd88, qc=qc@entry=0x821926870) at ../src/backend/tcop/pquery.c:787 [20:30:28.665] _local_sigjmp_buf = {{_sjb = {9763893, 35265159424, 34922981224, 34922981472, 34922981232, 12495608, 34922981488, 12451576, 12387199, 0, 35265119103, 34359738368}}} [20:30:28.665] _save_exception_stack = 0x821926920 [20:30:28.665] _save_context_stack = 0x0 [20:30:28.665] _do_rethrow = false [20:30:28.665] saveTopTransactionResourceOwner = 0x835fc9618 [20:30:28.665] saveTopTransactionContext = 0x835f7e000 [20:30:28.665] saveActivePortal = 0x0 [20:30:28.665] saveResourceOwner = 0x835fc9618 [20:30:28.665] savePortalContext = 0x0 [20:30:28.665] saveMemoryContext = 0x835f7e000 [20:30:28.665] result = [20:30:28.665] nprocessed = [20:30:28.665] #15 0x000000000094eb49 in exec_simple_query (query_string=query_string@entry=0x835ed4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [20:30:28.665] cmdtaglen = 24 [20:30:28.665] snapshot_set = [20:30:28.665] per_parsetree_context = 0x0 [20:30:28.665] plantree_list = [20:30:28.665] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:30:28.665] format = 0 [20:30:28.665] parsetree = 0x835ed56a8 [20:30:28.665] commandTag = [20:30:28.665] cmdtagname = [20:30:28.665] querytree_list = [20:30:28.665] portal = 0x835f7a100 [20:30:28.665] receiver = 0x835fbcd88 [20:30:28.665] parsetree_item__state = {l = 0x835ed5a18, i = 0} [20:30:28.665] msec_str = "\000\000\000\000\b", '\000' , "$k\211g\000\000\000\000$L\224\246\242\353\276C" [20:30:28.665] dest = DestRemote [20:30:28.665] was_logged = [20:30:28.665] oldcontext = 0x835f7e000 [20:30:28.665] parsetree_list = 0x835ed5a18 [20:30:28.665] use_implicit_block = false [20:30:28.665] parsetree_item = 0x835ed5a30 [20:30:28.665] save_log_statement_stats = [20:30:28.665] #16 0x000000000094c7b3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [20:30:28.665] query_string = 0x835ed4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:30:28.665] input_message = {data = 0x835ed4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:30:28.665] firstchar = [20:30:28.665] local_sigjmp_buf = {{_sjb = {9747558, 34922981664, 34922981656, 34922982208, 12504360, 1, 8192, 8388608, 34922955647, 0, 0, 1}}} [20:30:28.665] send_ready_for_query = false [20:30:28.665] idle_in_transaction_timeout_enabled = false [20:30:28.665] idle_session_timeout_enabled = false [20:30:28.665] #17 0x0000000000947159 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:30:28.665] bsdata = [20:30:28.665] #18 0x000000000089e4c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x821927650 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8219275a0) at ../src/backend/postmaster/launch_backend.c:274 [20:30:28.665] pid = [20:30:28.665] #19 0x00000000008a2a16 in BackendStartup (client_sock=0x8219275a0) at ../src/backend/postmaster/postmaster.c:3466 [20:30:28.665] startup_data = {canAcceptConnections = CAC_OK} [20:30:28.665] bn = 0x835f98098 [20:30:28.665] cac = CAC_OK [20:30:28.665] pid = [20:30:28.665] __error = [20:30:28.665] save_errno = [20:30:28.665] __error = [20:30:28.665] __error = [20:30:28.665] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [20:30:28.665] 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 = "\f", '\000' , "v\222!\b\000\000\000hEC+\b\000\000\000\346\000\000\000\000\000\000\000^\317C+\b", '\000' , "@v\222!\b\000\000\000T\342\211\000\000\000\000\000Pv\222!\b", '\000' }, salen = 16}} [20:30:28.665] i = 0 [20:30:28.665] now = [20:30:28.665] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 762952834, events = 8, fd = 0, user_data = 0x821927550}, {pos = 905176536, events = 8, fd = 563246048, user_data = 0x0}, {pos = 0, events = 0, fd = 2093282844, user_data = 0x216c5207a30a}, {pos = 762120096, events = 8, fd = 762191224, user_data = 0x821927068}, {pos = 563245280, events = 8, fd = 563245160, user_data = 0x216c5207a30a}, {pos = 762098568, events = 8, fd = 762191224, user_data = 0x821927098}, {pos = 563245328, events = 8, fd = 563245208, user_data = 0x82d6da194}, {pos = 578954248, events = 8, fd = 762159508, user_data = 0x821927100}, {pos = 1376212026, events = 8556, fd = 763981872, user_data = 0x1}, {pos = 563245360, events = 8, fd = 1376232202, user_data = 0x82d6c3858}, {pos = 762191224, events = 8, fd = 563245320, user_data = 0x821927180}, {pos = 563245320, events = 8, fd = 762154252, user_data = 0x822822408}, {pos = 762154252, events = 8, fd = 563245424, user_data = 0x216c5207543a}, {pos = 563245464, events = 8, fd = 563245912, user_data = 0x821927180}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2456513514, fd = 578977848, user_data = 0x800000001}, {pos = 578954248, events = 8, fd = 762098568, user_data = 0x822827288}, {pos = 762067032, events = 8, fd = 578954248, user_data = 0x821927208}, {pos = 563246024, events = 8, fd = 563245552, user_data = 0x216c52079ca2}, {pos = 2721811, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 578977848, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 563246280, user_data = 0x22822408}, {pos = 563246096, events = 8, fd = 563245696, user_data = 0x1}, {pos = 563246024, events = 8, fd = 32, user_data = 0x821927270}, {pos = 1376230003, events = 8556, fd = 563245968, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822828038}, {pos = 1, events = 8, fd = 578954248, user_data = 0x82d6c3858}, {pos = 563246280, events = 8, fd = 563246096, user_data = 0x821927280}, {pos = 0, events = 0, fd = 578924552, user_data = 0x20}, {pos = 563246080, events = 8, fd = 1376205543, user_data = 0x82281b008}, {pos = 578925576, events = 8, fd = 578926600, user_data = 0x82281bc08}, {pos = 578940936, events = 8, fd = 578941960, user_data = 0x82281f808}, {pos = 578944008, events = 8, fd = 578945032, user_data = 0x822820408}, {pos = 578947080, events = 8, fd = 578948104, user_data = 0x822821008}, {pos = 578950152, events = 8, fd = 578951176, user_data = 0x822821c08}, {pos = 578953224, events = 8, fd = 578954248, user_data = 0x822822808}, {pos = 578956296, events = 8, fd = 578957320, user_data = 0x822823408}, {pos = 578959368, events = 8, fd = 578960392, user_data = 0x822824008}, {pos = 578962440, events = 8, fd = 578963464, user_data = 0x822824c08}, {pos = 578969608, events = 8, fd = 578970632, user_data = 0x822826808}, {pos = 578972680, events = 8, fd = 578924552, user_data = 0x298813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822828038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 563246280, events = 8, fd = 563245696, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 578977848, user_data = 0x1}, {pos = 578924552, events = 8, fd = 298, user_data = 0x8219274b0}, {pos = 1376204271, events = 8556, fd = 2721811, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 578977848, user_data = 0x1}, {pos = 578954248, events = 8, fd = 904675328, user_data = 0x1}, {pos = 904675732, events = 8, fd = 0, user_data = 0x821927480}, {pos = 725861740, events = 8, fd = 1, user_data = 0x835ec4000}, {pos = 563246256, events = 8, fd = 725858050, user_data = 0x82d7f5170 }, {pos = 12413984, events = 0, fd = 763318640, user_data = 0x822822408}, {pos = 563246480, events = 8, fd = 1376203742, user_data = 0x835ee2800}, {pos = 1, events = 8, fd = 1376203358, user_data = 0x82281b008}, {pos = 563246264, events = 8, fd = 563246480, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1376283024, user_data = 0x0}, {pos = 563217279, events = 8, fd = 8170167, user_data = 0x821927540}, {pos = 725820432, events = 8, fd = 763981872, user_data = 0x82d899310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821927570}, {pos = 725863325, events = 8, fd = 904675328, user_data = 0x1e22}, {pos = 563246544, events = 8, fd = 725829882, user_data = 0x0}, {pos = 0, events = 0, fd = 2093282844, user_data = 0x0}} [20:30:28.666] last_touch_time = 1737059085 [20:30:28.666] last_lockfile_recheck_time = 1737059085 [20:30:28.666] nevents = 1 [20:30:28.666] #21 0x00000000008a0ca4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821927bc8) at ../src/backend/postmaster/postmaster.c:1377 [20:30:28.666] userDoption = [20:30:28.666] listen_addr_saved = false [20:30:28.666] output_config_variable = [20:30:28.666] opt = [20:30:28.666] status = [20:30:28.666] #22 0x00000000007d7790 in main (argc=4, argv=0x821927bc8) at ../src/backend/main/main.c:230 [20:30:28.666] do_check_root = [20:30:28.666] dispatch_option = DISPATCH_POSTMASTER [20:30:28.675] [20:30:28.675] [20:30:28.675] [20:30:28.732] dumping /tmp/cores/postgres.17848.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:30:28.854] [New LWP 101908] [20:30:28.916] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [20:30:28.916] Program terminated with signal SIGABRT, Aborted. [20:30:28.916] Sent by thr_kill() from pid 17848 and user 1003. [20:30:28.916] #0 0x000000082c4db41a in thr_kill () from /lib/libc.so.7 [20:30:28.957] [20:30:28.957] Thread 1 (LWP 101908): [20:30:28.957] #0 0x000000082c4db41a in thr_kill () from /lib/libc.so.7 [20:30:28.957] No symbol table info available. [20:30:28.957] #1 0x000000082c454e64 in raise () from /lib/libc.so.7 [20:30:28.957] No symbol table info available. [20:30:28.957] #2 0x000000082c5056f9 in abort () from /lib/libc.so.7 [20:30:28.957] No symbol table info available. [20:30:28.957] #3 0x0000000000aaa5d5 in ExceptionalCondition (conditionName=0x2ed211 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [20:30:28.957] No locals. [20:30:28.957] #4 0x0000000000772bd9 in standard_ExecutorStart (queryDesc=0x8363dfbd0, eflags=0) at ../src/backend/executor/execMain.c:193 [20:30:28.957] estate = 0x83d410100 [20:30:28.957] oldcontext = 0x836423800 [20:30:28.957] #5 0x000000083943e9c2 in pgss_ExecutorStart (queryDesc=0x8363dfbd0, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [20:30:28.957] No locals. [20:30:28.957] #6 0x000000000070718f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [20:30:28.957] copied_query = [20:30:28.957] rewritten = [20:30:28.957] plan = 0x8363df778 [20:30:28.957] queryDesc = 0x8363dfbd0 [20:30:28.957] processed = [20:30:28.957] __error = [20:30:28.957] #7 RefreshMatViewByOid (matviewOid=28538, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [20:30:28.957] dest = [20:30:28.957] save_userid = 10 [20:30:28.957] save_sec_context = 0 [20:30:28.957] processed = 0 [20:30:28.957] matviewRel = 0x83d4a5bd8 [20:30:28.957] relowner = 10 [20:30:28.957] save_nestlevel = 2 [20:30:28.957] rule = [20:30:28.957] actions = [20:30:28.957] dataQuery = [20:30:28.957] tableSpace = [20:30:28.957] relpersistence = [20:30:28.957] OIDNewHeap = 28553 [20:30:28.957] address = [20:30:28.957] #8 0x0000000000706d66 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [20:30:28.957] lockmode = [20:30:28.957] matviewOid = 0 [20:30:28.957] #9 0x00000000006ddd5c in ExecCreateTableAs (pstate=pstate@entry=0x836423900, stmt=stmt@entry=0x8363a9fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820f5c180) at ../src/backend/commands/createas.c:351 [20:30:28.957] refresh = 0x0 [20:30:28.957] query = 0x836334b88 [20:30:28.957] into = 0x8363a9f40 [20:30:28.957] jstate = 0x0 [20:30:28.957] do_refresh = false [20:30:28.957] address = [20:30:28.957] dest = [20:30:28.957] is_matview = [20:30:28.957] #10 0x0000000000952dcb in ProcessUtilitySlow (pstate=pstate@entry=0x836423900, pstmt=pstmt@entry=0x8363a9e30, queryString=queryString@entry=0x83624c100 "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=0x820f5c180) at ../src/backend/tcop/utility.c:1678 [20:30:28.957] _local_sigjmp_buf = {{_sjb = {9774585, 0, 34912713704, 34912714080, 34912713712, 12495608, 0, 35270048000, 895, 1, 34912713836, 0}}} [20:30:28.957] _save_exception_stack = 0x820f5be70 [20:30:28.957] _save_context_stack = 0x0 [20:30:28.957] _do_rethrow = false [20:30:28.957] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [20:30:28.957] parsetree = 0x8363a9fd0 [20:30:28.957] commandCollected = false [20:30:28.957] needCleanup = false [20:30:28.957] address = [20:30:28.957] isTopLevel = [20:30:28.957] isCompleteQuery = [20:30:28.957] #11 0x0000000000951748 in standard_ProcessUtility (pstmt=0x8363a9e30, queryString=queryString@entry=0x83624c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836335328, qc=0x820f5c180) at ../src/backend/tcop/utility.c:1033 [20:30:28.957] isAtomicContext = false [20:30:28.957] parsetree = 0x8363a9fd0 [20:30:28.957] readonly_flags = [20:30:28.957] pstate = 0x836423900 [20:30:28.957] isTopLevel = [20:30:28.957] #12 0x000000083943ef6d in pgss_ProcessUtility (pstmt=0x8363a9e30, queryString=0x83624c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836335328, qc=0x820f5c180) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [20:30:28.957] _local_sigjmp_buf = {{_sjb = {35320491686, 34912714352, 34912714216, 34912714672, 35269549616, 0, 12495608, 34912714880, 895, 1, 34912714468, 34359738368}}} [20:30:28.957] _save_exception_stack = 0x820f5c080 [20:30:28.957] _save_context_stack = 0x0 [20:30:28.957] _do_rethrow = false [20:30:28.957] bufusage = {shared_blks_hit = 35320491686, shared_blks_read = 34912714352, shared_blks_dirtied = 34912714216, shared_blks_written = 34912714672, local_blks_hit = 35269549616, local_blks_read = 0, local_blks_dirtied = 12495608, local_blks_written = 34912714880, temp_blks_read = 895, temp_blks_written = 1, shared_blk_read_time = {ticks = 34912714468}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4183050211705006592}, local_blk_write_time = {ticks = 12504536}, temp_blk_read_time = {ticks = 35337895040}, temp_blk_write_time = {ticks = 12447536}} [20:30:28.957] walusage_start = {wal_records = 8965, wal_fpi = 135, wal_bytes = 1326041} [20:30:28.957] duration = [20:30:28.957] bufusage_start = {shared_blks_hit = 152730, shared_blks_read = 9825, shared_blks_dirtied = 2738, shared_blks_written = 2159, 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}} [20:30:28.957] walusage = {wal_records = 0, wal_fpi = 549755813888, wal_bytes = 2940867411194877962} [20:30:28.957] start = {ticks = -183555146202} [20:30:28.957] rows = [20:30:28.957] saved_queryId = 7267788456574341698 [20:30:28.957] parsetree = [20:30:28.957] saved_stmt_location = 0 [20:30:28.957] saved_stmt_len = 69 [20:30:28.957] enabled = [20:30:28.957] #13 0x0000000000950d13 in PortalRunUtility (portal=0x8362f2100, pstmt=0x8363a9e30, isTopLevel=, setHoldSnapshot=, dest=0x836335328, qc=0x820f5c180) at ../src/backend/tcop/pquery.c:1152 [20:30:28.957] No locals. [20:30:28.957] #14 0x00000000009503d4 in PortalRunMulti (portal=portal@entry=0x8362f2100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x836335328, altdest=altdest@entry=0x836335328, qc=qc@entry=0x820f5c180) at ../src/backend/tcop/pquery.c:1316 [20:30:28.957] pstmt = 0x8363a9e30 [20:30:28.957] stmtlist_item__state = {l = 0x8363352d8, i = 0} [20:30:28.957] active_snapshot_set = false [20:30:28.957] stmtlist_item = 0x8363352f0 [20:30:28.957] #15 0x000000000094fcbb in PortalRun (portal=portal@entry=0x8362f2100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x836335328, altdest=altdest@entry=0x836335328, qc=qc@entry=0x820f5c180) at ../src/backend/tcop/pquery.c:787 [20:30:28.957] _local_sigjmp_buf = {{_sjb = {9763893, 35268796672, 34912714872, 34912715120, 34912714880, 12495608, 34912715136, 12451576, 12387199, 0, 35268789119, 34359738368}}} [20:30:28.957] _save_exception_stack = 0x820f5c230 [20:30:28.957] _save_context_stack = 0x0 [20:30:28.957] _do_rethrow = false [20:30:28.957] saveTopTransactionResourceOwner = 0x8363479d8 [20:30:28.957] saveTopTransactionContext = 0x8362f6000 [20:30:28.957] saveActivePortal = 0x0 [20:30:28.957] saveResourceOwner = 0x8363479d8 [20:30:28.957] savePortalContext = 0x0 [20:30:28.957] saveMemoryContext = 0x8362f6000 [20:30:28.957] result = [20:30:28.957] nprocessed = [20:30:28.957] #16 0x000000000094eb49 in exec_simple_query (query_string=query_string@entry=0x83624c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [20:30:28.957] cmdtaglen = 24 [20:30:28.957] snapshot_set = [20:30:28.957] per_parsetree_context = 0x0 [20:30:28.957] plantree_list = [20:30:28.957] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:30:28.957] format = 0 [20:30:28.957] parsetree = 0x83624d6a8 [20:30:28.957] commandTag = [20:30:28.957] cmdtagname = [20:30:28.957] querytree_list = [20:30:28.957] portal = 0x8362f2100 [20:30:28.957] receiver = 0x836335328 [20:30:28.957] parsetree_item__state = {l = 0x83624da18, i = 0} [20:30:28.957] msec_str = "\000\000\000\000\b", '\000' , "Ik\211g\000\000\000\000\210\036\224/\234\017\2464" [20:30:28.957] dest = DestRemote [20:30:28.957] was_logged = [20:30:28.957] oldcontext = 0x8362f6000 [20:30:28.957] parsetree_list = 0x83624da18 [20:30:28.957] use_implicit_block = false [20:30:28.957] parsetree_item = 0x83624da30 [20:30:28.957] save_log_statement_stats = [20:30:28.957] #17 0x000000000094c7b3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [20:30:28.957] query_string = 0x83624c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [20:30:28.957] input_message = {data = 0x83624c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [20:30:28.957] firstchar = [20:30:28.957] local_sigjmp_buf = {{_sjb = {9747558, 34912715312, 34912715304, 34912715856, 12504360, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [20:30:28.957] send_ready_for_query = false [20:30:28.957] idle_in_transaction_timeout_enabled = false [20:30:28.957] idle_session_timeout_enabled = false [20:30:28.957] #18 0x0000000000947159 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [20:30:28.957] bsdata = [20:30:28.957] #19 0x000000000089e4c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=12, startup_data=startup_data@entry=0x820f5cf60 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f5ceb0) at ../src/backend/postmaster/launch_backend.c:274 [20:30:28.957] pid = [20:30:28.957] #20 0x00000000008a2a16 in BackendStartup (client_sock=0x820f5ceb0) at ../src/backend/postmaster/postmaster.c:3466 [20:30:28.957] startup_data = {canAcceptConnections = CAC_OK} [20:30:28.957] bn = 0x836333d88 [20:30:28.957] cac = CAC_OK [20:30:28.957] pid = [20:30:28.957] __error = [20:30:28.957] save_errno = [20:30:28.957] __error = [20:30:28.957] __error = [20:30:28.957] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [20:30:28.957] 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 = "\f", '\000' , "\020\317\365 \b\000\000\000h5\333*\b\000\000\000W\000\000\000\000\000\000\000^\277\333*\b", '\000' , "P\317\365 \b\000\000\000T\342\211\000\000\000\000\000`\317\365 \b", '\000' }, salen = 16}} [20:30:28.957] i = 0 [20:30:28.957] now = [20:30:28.957] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 742915202, events = 8, fd = 0, user_data = 0x820f5ce60}, {pos = 908785112, events = 8, fd = 552979696, user_data = 0x0}, {pos = -1268399350, events = 13203, fd = 742082464, user_data = 0x82c3c5d78}, {pos = 552978792, events = 8, fd = 552978912, user_data = 0x820f5c968}, {pos = -1268399350, events = 13203, fd = 742060936, user_data = 0x82c3c5d78}, {pos = 552978840, events = 8, fd = 552978960, user_data = 0x820f5c998}, {pos = 742121876, events = 8, fd = 557855752, user_data = 0x82c3be194}, {pos = 552978944, events = 8, fd = -1268419526, user_data = 0x820f5c9a0}, {pos = 719000592, events = 8, fd = 743944240, user_data = 0x3393b465c30a}, {pos = 742029400, events = 8, fd = 742153592, user_data = 0x820f5ca08}, {pos = 552979072, events = 8, fd = 552978952, user_data = 0x82c3bcd0c}, {pos = 557855752, events = 8, fd = 742116620, user_data = 0x820f5ca70}, {pos = -1268419526, events = 13203, fd = 552979096, user_data = 0x820f5cc68}, {pos = 552979072, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821409038}, {pos = 1, events = 684724052, fd = 557855752, user_data = 0x82c3af388}, {pos = 557877192, events = 8, fd = 0, user_data = 0x0}, {pos = 552979208, events = 8, fd = 552979672, user_data = 0x820f5caf0}, {pos = -1268400990, events = 13203, fd = 2721811, user_data = 0x6d68b}, {pos = 2090263927, events = 684724052, fd = 557879352, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820f5cdd8}, {pos = 557855752, events = 3, fd = 552979744, user_data = 0x821408828}, {pos = 656, events = 0, fd = 552979672, user_data = 0x820f5cb08}, {pos = 552979312, events = 8, fd = -1268401381, user_data = 0x820f5cca0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 557879352, events = 8, fd = 1, user_data = 0x821403408}, {pos = 742029400, events = 8, fd = 552979928, user_data = 0x820f5cd20}, {pos = 552979328, events = 8, fd = 0, user_data = 0x8213fc008}, {pos = 33, events = 0, fd = 552979728, user_data = 0x3393b4655ae7}, {pos = 557826056, events = 8, fd = 557827080, user_data = 0x8213fc808}, {pos = 557829128, events = 8, fd = 557842440, user_data = 0x821400408}, {pos = 557844488, events = 8, fd = 557845512, user_data = 0x821401008}, {pos = 557847560, events = 8, fd = 557848584, user_data = 0x821401c08}, {pos = 557850632, events = 8, fd = 557851656, user_data = 0x821402808}, {pos = 557853704, events = 8, fd = 557854728, user_data = 0x821403408}, {pos = 557856776, events = 8, fd = 557857800, user_data = 0x821404008}, {pos = 557859848, events = 8, fd = 557860872, user_data = 0x821404c08}, {pos = 557862920, events = 8, fd = 557863944, user_data = 0x821405808}, {pos = 557865992, events = 8, fd = 557871112, user_data = 0x821407408}, {pos = 557873160, events = 8, fd = 557874184, user_data = 0x82140a408}, {pos = 827124000, events = 0, fd = 557826056, user_data = 0x298813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821409038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552979928, events = 8, fd = 552979328, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 557879352, user_data = 0x1}, {pos = 557826056, events = 8, fd = 298, user_data = 0x820f5cdc0}, {pos = -1268427281, events = 13203, fd = 2721811, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 557879352, user_data = 0x1}, {pos = 557855752, events = 8, fd = 908312576, user_data = 0x1}, {pos = 908312980, events = 8, fd = 0, user_data = 0x820f5cd90}, {pos = 719041900, events = 8, fd = 1, user_data = 0x83623c000}, {pos = 552979904, events = 8, fd = 719038210, user_data = 0x82c4d9170 }, {pos = 12413984, events = 0, fd = 743281008, user_data = 0x821403408}, {pos = 552980128, events = 8, fd = -1268427810, user_data = 0x83625a800}, {pos = 1, events = 8, fd = -1268428194, user_data = 0x8213fc008}, {pos = 552979912, events = 8, fd = 552980128, user_data = 0x1ab8}, {pos = 11, events = 0, fd = -1268348528, user_data = 0x0}, {pos = 552928127, events = 8, fd = 8170167, user_data = 0x820f5ce50}, {pos = 719000592, events = 8, fd = 743944240, user_data = 0x82c57d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820f5ce80}, {pos = 719043485, events = 8, fd = 908312576, user_data = 0x36af}, {pos = 552980192, events = 8, fd = 719010042, user_data = 0x0}, {pos = 0, events = 0, fd = 1070274570, user_data = 0x0}} [20:30:28.957] last_touch_time = 1737059119 [20:30:28.957] last_lockfile_recheck_time = 1737059119 [20:30:28.957] nevents = 1 [20:30:28.957] #22 0x00000000008a0ca4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f5d4d0) at ../src/backend/postmaster/postmaster.c:1377 [20:30:28.957] userDoption = [20:30:28.957] listen_addr_saved = false [20:30:28.957] output_config_variable = [20:30:28.957] opt = [20:30:28.957] status = [20:30:28.957] #23 0x00000000007d7790 in main (argc=4, argv=0x820f5d4d0) at ../src/backend/main/main.c:230 [20:30:28.957] do_check_root = [20:30:28.957] dispatch_option = DISPATCH_POSTMASTER