[03:43:09.172] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [03:43:09.493] dumping /tmp/cores/postgres.30780.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:43:09.623] [New LWP 100111] [03:43:09.710] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:43:09.710] Program terminated with signal SIGABRT, Aborted. [03:43:09.710] Sent by thr_kill() from pid 30780 and user 1002. [03:43:09.710] #0 0x000000082aa381ba in thr_kill () from /lib/libc.so.7 [03:43:09.761] [03:43:09.761] Thread 1 (LWP 100111): [03:43:09.761] #0 0x000000082aa381ba in thr_kill () from /lib/libc.so.7 [03:43:09.761] No symbol table info available. [03:43:09.761] #1 0x000000082a9b15d4 in raise () from /lib/libc.so.7 [03:43:09.761] No symbol table info available. [03:43:09.761] #2 0x000000082aa64b59 in abort () from /lib/libc.so.7 [03:43:09.761] No symbol table info available. [03:43:09.761] #3 0x0000000000aae355 in ExceptionalCondition (conditionName=0x2ee916 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [03:43:09.761] No locals. [03:43:09.761] #4 0x00000000007714e4 in standard_ExecutorStart (queryDesc=0xb882c6880a8, eflags=0) at ../src/backend/executor/execMain.c:203 [03:43:09.761] estate = 0xb882c661100 [03:43:09.761] oldcontext = 0xb882bfe1400 [03:43:09.761] #5 0x0000000000704c61 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:43:09.761] copied_query = [03:43:09.761] rewritten = [03:43:09.761] plan = 0xb882bf17a90 [03:43:09.761] queryDesc = 0xb882c6880a8 [03:43:09.761] processed = [03:43:09.761] __error = [03:43:09.761] __error = [03:43:09.761] #6 RefreshMatViewByOid (matviewOid=28472, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:43:09.761] dest = [03:43:09.761] save_userid = 10 [03:43:09.761] save_sec_context = 0 [03:43:09.761] processed = 0 [03:43:09.761] matviewRel = 0xb882c7c67f8 [03:43:09.761] relowner = 10 [03:43:09.761] save_nestlevel = 2 [03:43:09.761] rule = [03:43:09.761] actions = [03:43:09.761] dataQuery = [03:43:09.761] tableSpace = [03:43:09.761] relpersistence = [03:43:09.761] OIDNewHeap = 28479 [03:43:09.761] address = [03:43:09.761] #7 0x0000000000704846 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:43:09.761] lockmode = [03:43:09.761] matviewOid = 0 [03:43:09.761] #8 0x00000000006dc880 in ExecCreateTableAs (pstate=pstate@entry=0xb882bfe1500, stmt=stmt@entry=0xb882bf29fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8214e30e0) at ../src/backend/commands/createas.c:351 [03:43:09.761] refresh = 0x0 [03:43:09.761] query = 0xb882bfe38d8 [03:43:09.761] into = 0xb882bfe3c20 [03:43:09.761] jstate = 0x0 [03:43:09.761] do_refresh = false [03:43:09.761] address = [03:43:09.761] dest = [03:43:09.761] is_matview = [03:43:09.761] #9 0x00000000009567f2 in ProcessUtilitySlow (pstate=pstate@entry=0xb882bfe1500, pstmt=pstmt@entry=0xb882be25a68, queryString=queryString@entry=0xb882be24100 "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=0x8214e30e0) at ../src/backend/tcop/utility.c:1678 [03:43:09.761] _local_sigjmp_buf = {{_sjb = {9789369, 12679480778704, 34918509832, 34918510192, 34918509840, 12642792, 0, 12679481529600, 983935, 123, 34918509968, 0}}} [03:43:09.761] _save_exception_stack = 0x8214e2fd0 [03:43:09.761] _save_context_stack = 0x0 [03:43:09.761] _do_rethrow = false [03:43:09.761] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:43:09.761] parsetree = 0xb882bf29fd0 [03:43:09.761] commandCollected = false [03:43:09.761] needCleanup = false [03:43:09.761] address = [03:43:09.761] isTopLevel = [03:43:09.761] isCompleteQuery = [03:43:09.761] #10 0x000000000095538e in standard_ProcessUtility (pstmt=0xb882be25a68, queryString=0xb882be24100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0xb882bfe4108, qc=0x8214e30e0) at ../src/backend/tcop/utility.c:1033 [03:43:09.761] isAtomicContext = false [03:43:09.761] parsetree = 0xb882bf29fd0 [03:43:09.761] readonly_flags = [03:43:09.761] pstate = 0xb882bfe1500 [03:43:09.761] isTopLevel = [03:43:09.761] #11 0x0000000000954c18 in ProcessUtility (pstmt=0x1870f, queryString=0x6 , readOnlyTree=, context=715358618, params=0x0, queryEnv=0x0, dest=0xb882bfe4108, qc=0x8214e30e0) at ../src/backend/tcop/utility.c:523 [03:43:09.761] No locals. [03:43:09.761] #12 0x00000000009546bc in PortalRunUtility (portal=0xb882bf08100, pstmt=0xb882be25a68, isTopLevel=, setHoldSnapshot=false, dest=0xb882bfe4108, qc=0x8214e30e0) at ../src/backend/tcop/pquery.c:1184 [03:43:09.761] No locals. [03:43:09.761] #13 0x0000000000953d24 in PortalRunMulti (portal=portal@entry=0xb882bf08100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0xb882bfe4108, altdest=altdest@entry=0xb882bfe4108, qc=qc@entry=0x8214e30e0) at ../src/backend/tcop/pquery.c:1355 [03:43:09.761] pstmt = 0xb882be25a68 [03:43:09.761] stmtlist_item__state = {l = 0xb882bfe40b8, i = 0} [03:43:09.761] active_snapshot_set = false [03:43:09.761] query_index = 0 [03:43:09.761] stmtlist_item = 0xb882bfe40d0 [03:43:09.761] #14 0x00000000009535e1 in PortalRun (portal=portal@entry=0xb882bf08100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0xb882bfe4108, altdest=altdest@entry=0xb882bfe4108, qc=qc@entry=0x8214e30e0) at ../src/backend/tcop/pquery.c:819 [03:43:09.761] _local_sigjmp_buf = {{_sjb = {9778520, 12679480639744, 34918510536, 34918510784, 34918510544, 12642792, 34918510816, 12571752, 34918499199, 34918510751, 12679480893696, 12678743457792}}} [03:43:09.761] _save_exception_stack = 0x8214e31b0 [03:43:09.761] _save_context_stack = 0x0 [03:43:09.761] _do_rethrow = false [03:43:09.761] saveTopTransactionResourceOwner = 0xb882bf4a658 [03:43:09.761] saveTopTransactionContext = 0xb882bf85000 [03:43:09.761] saveActivePortal = 0x0 [03:43:09.761] saveResourceOwner = 0xb882bf4a658 [03:43:09.761] savePortalContext = 0x0 [03:43:09.761] saveMemoryContext = 0xb882bf85000 [03:43:09.761] result = [03:43:09.761] nprocessed = [03:43:09.761] #15 0x0000000000952371 in exec_simple_query (query_string=query_string@entry=0xb882be24100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [03:43:09.761] cmdtaglen = 24 [03:43:09.761] snapshot_set = [03:43:09.761] per_parsetree_context = 0x0 [03:43:09.761] plantree_list = [03:43:09.761] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:43:09.761] format = 0 [03:43:09.761] parsetree = 0xb882be256a8 [03:43:09.761] commandTag = [03:43:09.761] cmdtagname = [03:43:09.761] querytree_list = [03:43:09.761] portal = 0xb882bf08100 [03:43:09.761] receiver = 0xb882bfe4108 [03:43:09.761] parsetree_item__state = {l = 0xb882be25a18, i = 0} [03:43:09.761] msec_str = "\000\000\000\000\b", '\000' , "01N!\b\000\000\000UJ\243*\b\000\000" [03:43:09.761] dest = DestRemote [03:43:09.761] was_logged = [03:43:09.761] oldcontext = 0xb882bf85000 [03:43:09.761] parsetree_list = 0xb882be25a18 [03:43:09.761] use_implicit_block = false [03:43:09.761] parsetree_item = 0xb882be25a30 [03:43:09.761] save_log_statement_stats = [03:43:09.761] #16 0x000000000094ff49 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4689 [03:43:09.761] query_string = 0xb882be24100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:43:09.761] input_message = {data = 0xb882be24100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:43:09.761] firstchar = [03:43:09.761] local_sigjmp_buf = {{_sjb = {9761789, 34918511024, 34918510984, 34918511568, 12448452, 1, 12651544, 12645508, 895, 0, 0, 34359738369}}} [03:43:09.761] send_ready_for_query = false [03:43:09.761] idle_in_transaction_timeout_enabled = false [03:43:09.761] idle_session_timeout_enabled = false [03:43:09.761] #17 0x000000000094a959 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:43:09.761] bsdata = [03:43:09.761] #18 0x00000000008a1845 in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x8214e3ee0, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214e3e30) at ../src/backend/postmaster/launch_backend.c:274 [03:43:09.761] pid = [03:43:09.761] #19 0x00000000008a5ed6 in BackendStartup (client_sock=0x8214e3e30) at ../src/backend/postmaster/postmaster.c:3519 [03:43:09.761] startup_data = {canAcceptConnections = CAC_OK} [03:43:09.761] bn = 0xb882bf19278 [03:43:09.761] cac = CAC_OK [03:43:09.761] pid = [03:43:09.761] __error = [03:43:09.761] save_errno = [03:43:09.761] __error = [03:43:09.761] __error = [03:43:09.761] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:43:09.761] 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' , "\220>N!\b\000\000\000XF\025(\b\000\000\000\346\000\000\000\000\000\000\000\276\316\025(\b", '\000' , "\320>N!\b\000\000\000\324\025\212\000\000\000\000\000 ?N!\b", '\000' }, salen = 16}} [03:43:09.761] i = 0 [03:43:09.761] now = [03:43:09.761] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 558775408, user_data = 0x0}, {pos = 0, events = 0, fd = 1193318360, user_data = 0x82aaebdc0}, {pos = 558774496, events = 8, fd = 690102989, user_data = 0x82a90ebb8}, {pos = 714215580, events = 8, fd = 558774520, user_data = 0x8214e3970}, {pos = 558774544, events = 8, fd = 690102989, user_data = 0x82a90df70}, {pos = 714215580, events = 8, fd = 558774568, user_data = 0x8214e39a0}, {pos = 714186180, events = 8, fd = 714186180, user_data = 0xb882ba0a408}, {pos = 3, events = 0, fd = 558774672, user_data = 0x3de72921d4fb}, {pos = 558774720, events = 8, fd = 714137456, user_data = 0x8214e3980}, {pos = 690102989, events = 15847, fd = 714155024, user_data = 0x82a92109c}, {pos = 558774680, events = 8, fd = 558774800, user_data = 0x82a91a934}, {pos = 714189108, events = 8, fd = 731948040, user_data = 0x3}, {pos = 558774784, events = 8, fd = 690083067, user_data = 0x8214e3a10}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3137242969, fd = 731971664, user_data = 0x800000001}, {pos = 731948040, events = 2952, fd = 714137456, user_data = 0xb882ba0f2a8}, {pos = 714155024, events = 8, fd = 731948040, user_data = 0x8214e3a98}, {pos = 558775384, events = 8, fd = 558774912, user_data = 0x3de729221c52}, {pos = 2725907, events = 0, fd = 448139, user_data = 0xb887c96e577}, {pos = 731971664, events = 2952, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558775640, user_data = 0x32ba0a408}, {pos = 558775464, events = 8, fd = 731970280, user_data = 0x290}, {pos = 558775384, events = 8, fd = 558774936, user_data = 0x8214e3b00}, {pos = 690100939, events = 15847, fd = 558775328, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xb882ba10050}, {pos = 1, events = 2952, fd = 731948040, user_data = 0x82a912410}, {pos = 558775640, events = 8, fd = 558775464, user_data = 0x8214e3b10}, {pos = 0, events = 0, fd = 731918344, user_data = 0x20}, {pos = 558775440, events = 8, fd = 690076791, user_data = 0xb882ba03008}, {pos = 731919368, events = 2952, fd = 731920392, user_data = 0xb882ba03c08}, {pos = 731934728, events = 2952, fd = 731935752, user_data = 0xb882ba07808}, {pos = 731937800, events = 2952, fd = 731938824, user_data = 0xb882ba08408}, {pos = 731940872, events = 2952, fd = 731941896, user_data = 0xb882ba09008}, {pos = 731943944, events = 2952, fd = 731944968, user_data = 0xb882ba09c08}, {pos = 731947016, events = 2952, fd = 731948040, user_data = 0xb882ba0a808}, {pos = 731950088, events = 2952, fd = 731951112, user_data = 0xb882ba0b408}, {pos = 731953160, events = 2952, fd = 731954184, user_data = 0xb882ba0c008}, {pos = 731956232, events = 2952, fd = 731957256, user_data = 0xb882ba0cc08}, {pos = 731963400, events = 2952, fd = 731964424, user_data = 0xb882ba0e808}, {pos = 731966472, events = 2952, fd = 731918344, user_data = 0x299813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0xb882ba10050}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558775640, events = 8, fd = 558775056, user_data = 0x2000000020}, {pos = 731918344, events = 2952, fd = 891, user_data = 0x204038}, {pos = 297, events = 0, fd = 731971664, user_data = 0x8214e3d40}, {pos = 690075521, events = 15847, fd = 12651504, user_data = 0x299813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0xb882ba10050}, {pos = 1, events = 0, fd = 731948040, user_data = 0xbf40f8 }, {pos = 715349776, events = 8, fd = 731918344, user_data = 0x2b2410}, {pos = 672515257, events = 8, fd = 1, user_data = 0xb882be12000}, {pos = 558775616, events = 8, fd = 672511554, user_data = 0x82aa35f10 }, {pos = 12534008, events = 0, fd = 715349776, user_data = 0xb882ba0a408}, {pos = 558775840, events = 8, fd = 690074996, user_data = 0xb882be31000}, {pos = 1, events = 2952, fd = 690074606, user_data = 0xb882ba03008}, {pos = 558775624, events = 8, fd = 558775840, user_data = 0x1aa0}, {pos = 11, events = 0, fd = 690156448, user_data = 0x0}, {pos = 558760831, events = 8, fd = 8174503, user_data = 0x8214e3dd0}, {pos = 672474464, events = 8, fd = 716022880, user_data = 0x82aadc750}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214e3e00}, {pos = 672516861, events = 8, fd = 736174080, user_data = 0x1df0}, {pos = 558775904, events = 8, fd = 672483818, user_data = 0x0}, {pos = 0, events = 0, fd = 1193318360, user_data = 0x0}} [03:43:09.761] last_touch_time = 1741318563 [03:43:09.761] last_lockfile_recheck_time = 1741318563 [03:43:09.761] nevents = 1 [03:43:09.761] #21 0x00000000008a4025 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8214e4478) at ../src/backend/postmaster/postmaster.c:1386 [03:43:09.761] userDoption = [03:43:09.761] listen_addr_saved = false [03:43:09.761] output_config_variable = [03:43:09.761] opt = [03:43:09.761] status = [03:43:09.761] #22 0x00000000007d8e60 in main (argc=4, argv=0x8214e4478) at ../src/backend/main/main.c:230 [03:43:09.761] do_check_root = [03:43:09.761] dispatch_option = DISPATCH_POSTMASTER [03:43:09.768] [03:43:09.768] [03:43:09.768] [03:43:09.827] dumping /tmp/cores/postgres.31229.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:43:09.951] [New LWP 101911] [03:43:10.018] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:43:10.018] Program terminated with signal SIGABRT, Aborted. [03:43:10.018] Sent by thr_kill() from pid 31229 and user 1002. [03:43:10.018] #0 0x000000082b6ba1ba in thr_kill () from /lib/libc.so.7 [03:43:10.052] [03:43:10.052] Thread 1 (LWP 101911): [03:43:10.052] #0 0x000000082b6ba1ba in thr_kill () from /lib/libc.so.7 [03:43:10.052] No symbol table info available. [03:43:10.052] #1 0x000000082b6335d4 in raise () from /lib/libc.so.7 [03:43:10.052] No symbol table info available. [03:43:10.052] #2 0x000000082b6e6b59 in abort () from /lib/libc.so.7 [03:43:10.052] No symbol table info available. [03:43:10.052] #3 0x0000000000aae355 in ExceptionalCondition (conditionName=0x2ee916 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [03:43:10.052] No locals. [03:43:10.052] #4 0x00000000007714e4 in standard_ExecutorStart (queryDesc=0x1f39ee5050a8, eflags=0) at ../src/backend/executor/execMain.c:203 [03:43:10.052] estate = 0x1f39eec81100 [03:43:10.052] oldcontext = 0x1f39eec8d400 [03:43:10.052] #5 0x0000000000704c61 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:43:10.052] copied_query = [03:43:10.052] rewritten = [03:43:10.052] plan = 0x1f39ee515a90 [03:43:10.052] queryDesc = 0x1f39ee5050a8 [03:43:10.052] processed = [03:43:10.052] __error = [03:43:10.052] __error = [03:43:10.052] #6 RefreshMatViewByOid (matviewOid=28525, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:43:10.052] dest = [03:43:10.052] save_userid = 10 [03:43:10.052] save_sec_context = 0 [03:43:10.052] processed = 0 [03:43:10.052] matviewRel = 0x1f39eee16588 [03:43:10.052] relowner = 10 [03:43:10.052] save_nestlevel = 2 [03:43:10.052] rule = [03:43:10.052] actions = [03:43:10.052] dataQuery = [03:43:10.052] tableSpace = [03:43:10.052] relpersistence = [03:43:10.052] OIDNewHeap = 28588 [03:43:10.052] address = [03:43:10.052] #7 0x0000000000704846 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:43:10.052] lockmode = [03:43:10.052] matviewOid = 0 [03:43:10.052] #8 0x00000000006dc880 in ExecCreateTableAs (pstate=pstate@entry=0x1f39eec8d500, stmt=stmt@entry=0x1f39eec8cfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820f882f0) at ../src/backend/commands/createas.c:351 [03:43:10.052] refresh = 0x0 [03:43:10.052] query = 0x1f39eecc3818 [03:43:10.052] into = 0x1f39eecc3b60 [03:43:10.052] jstate = 0x0 [03:43:10.052] do_refresh = false [03:43:10.052] address = [03:43:10.052] dest = [03:43:10.052] is_matview = [03:43:10.052] #9 0x00000000009567f2 in ProcessUtilitySlow (pstate=pstate@entry=0x1f39eec8d500, pstmt=pstmt@entry=0x1f39ee425a68, queryString=queryString@entry=0x1f39ee424100 "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=0x820f882f0) at ../src/backend/tcop/utility.c:1678 [03:43:10.052] _local_sigjmp_buf = {{_sjb = {9789369, 34333679734736, 34912894744, 34912895104, 34912894752, 12642792, 0, 34333679736064, 983935, 123, 34912894880, 0}}} [03:43:10.052] _save_exception_stack = 0x820f881e0 [03:43:10.052] _save_context_stack = 0x0 [03:43:10.052] _do_rethrow = false [03:43:10.052] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:43:10.052] parsetree = 0x1f39eec8cfd0 [03:43:10.052] commandCollected = false [03:43:10.052] needCleanup = false [03:43:10.052] address = [03:43:10.052] isTopLevel = [03:43:10.052] isCompleteQuery = [03:43:10.052] #10 0x000000000095538e in standard_ProcessUtility (pstmt=0x1f39ee425a68, queryString=0x1f39ee424100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x1f39eecc4048, qc=0x820f882f0) at ../src/backend/tcop/utility.c:1033 [03:43:10.052] isAtomicContext = false [03:43:10.052] parsetree = 0x1f39eec8cfd0 [03:43:10.052] readonly_flags = [03:43:10.052] pstate = 0x1f39eec8d500 [03:43:10.052] isTopLevel = [03:43:10.052] #11 0x0000000000954c18 in ProcessUtility (pstmt=0x18e17, queryString=0x6 , readOnlyTree=, context=728474010, params=0x0, queryEnv=0x0, dest=0x1f39eecc4048, qc=0x820f882f0) at ../src/backend/tcop/utility.c:523 [03:43:10.052] No locals. [03:43:10.052] #12 0x00000000009546bc in PortalRunUtility (portal=0x1f39ee539100, pstmt=0x1f39ee425a68, isTopLevel=, setHoldSnapshot=false, dest=0x1f39eecc4048, qc=0x820f882f0) at ../src/backend/tcop/pquery.c:1184 [03:43:10.052] No locals. [03:43:10.052] #13 0x0000000000953d24 in PortalRunMulti (portal=portal@entry=0x1f39ee539100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x1f39eecc4048, altdest=altdest@entry=0x1f39eecc4048, qc=qc@entry=0x820f882f0) at ../src/backend/tcop/pquery.c:1355 [03:43:10.052] pstmt = 0x1f39ee425a68 [03:43:10.052] stmtlist_item__state = {l = 0x1f39eecc3ff8, i = 0} [03:43:10.052] active_snapshot_set = false [03:43:10.052] query_index = 0 [03:43:10.052] stmtlist_item = 0x1f39eecc4010 [03:43:10.052] #14 0x00000000009535e1 in PortalRun (portal=portal@entry=0x1f39ee539100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x1f39eecc4048, altdest=altdest@entry=0x1f39eecc4048, qc=qc@entry=0x820f882f0) at ../src/backend/tcop/pquery.c:819 [03:43:10.052] _local_sigjmp_buf = {{_sjb = {9778520, 34333672050944, 34912895448, 34912895696, 34912895456, 12642792, 34912895728, 12571752, 34912863103, 34912895663, 34333672059136, 34329673596928}}} [03:43:10.052] _save_exception_stack = 0x820f883c0 [03:43:10.052] _save_context_stack = 0x0 [03:43:10.052] _do_rethrow = false [03:43:10.052] saveTopTransactionResourceOwner = 0x1f39ee5468c8 [03:43:10.052] saveTopTransactionContext = 0x1f39ee59f000 [03:43:10.052] saveActivePortal = 0x0 [03:43:10.052] saveResourceOwner = 0x1f39ee5468c8 [03:43:10.052] savePortalContext = 0x0 [03:43:10.052] saveMemoryContext = 0x1f39ee59f000 [03:43:10.052] result = [03:43:10.052] nprocessed = [03:43:10.052] #15 0x0000000000952371 in exec_simple_query (query_string=query_string@entry=0x1f39ee424100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [03:43:10.052] cmdtaglen = 24 [03:43:10.052] snapshot_set = [03:43:10.052] per_parsetree_context = 0x0 [03:43:10.052] plantree_list = [03:43:10.052] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:43:10.052] format = 0 [03:43:10.052] parsetree = 0x1f39ee4256a8 [03:43:10.052] commandTag = [03:43:10.052] cmdtagname = [03:43:10.052] querytree_list = [03:43:10.052] portal = 0x1f39ee539100 [03:43:10.052] receiver = 0x1f39eecc4048 [03:43:10.052] parsetree_item__state = {l = 0x1f39ee425a18, i = 0} [03:43:10.052] msec_str = "\000\000\000\000\b", '\000' , "@\203\370 \b\000\000\000Ujk+\b\000\000" [03:43:10.052] dest = DestRemote [03:43:10.052] was_logged = [03:43:10.052] oldcontext = 0x1f39ee59f000 [03:43:10.052] parsetree_list = 0x1f39ee425a18 [03:43:10.052] use_implicit_block = false [03:43:10.052] parsetree_item = 0x1f39ee425a30 [03:43:10.052] save_log_statement_stats = [03:43:10.052] #16 0x000000000094ff49 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4689 [03:43:10.052] query_string = 0x1f39ee424100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:43:10.052] input_message = {data = 0x1f39ee424100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:43:10.052] firstchar = [03:43:10.052] local_sigjmp_buf = {{_sjb = {9761789, 34912895936, 34912895896, 34912896480, 12448452, 1, 12651544, 12645508, 895, 0, 0, 34359738369}}} [03:43:10.052] send_ready_for_query = false [03:43:10.052] idle_in_transaction_timeout_enabled = false [03:43:10.052] idle_session_timeout_enabled = false [03:43:10.052] #17 0x000000000094a959 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:43:10.052] bsdata = [03:43:10.052] #18 0x00000000008a1845 in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x820f890f0, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f89040) at ../src/backend/postmaster/launch_backend.c:274 [03:43:10.052] pid = [03:43:10.052] #19 0x00000000008a5ed6 in BackendStartup (client_sock=0x820f89040) at ../src/backend/postmaster/postmaster.c:3519 [03:43:10.052] startup_data = {canAcceptConnections = CAC_OK} [03:43:10.052] bn = 0x1f39ee5053c8 [03:43:10.052] cac = CAC_OK [03:43:10.052] pid = [03:43:10.052] __error = [03:43:10.052] save_errno = [03:43:10.052] __error = [03:43:10.052] __error = [03:43:10.052] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:43:10.052] 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' , "\240\220\370 \b\000\000\000XF\323+\b\000\000\000\372\000\000\000\000\000\000\000\276\316\323+\b", '\000' , "\340\220\370 \b\000\000\000\324\025\212\000\000\000\000\0000\221\370 \b", '\000' }, salen = 16}} [03:43:10.052] i = 0 [03:43:10.052] now = [03:43:10.052] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 553160320, user_data = 0x0}, {pos = -296542208, events = 7993, fd = 8192, user_data = 0x1000}, {pos = 553159648, events = 8, fd = 1, user_data = 0x820f88b20}, {pos = 728943872, events = 8, fd = 1, user_data = 0x1000}, {pos = 232, events = 0, fd = 0, user_data = 0x82b58ff70}, {pos = 727330972, events = 8, fd = 553159656, user_data = 0x820f88bd8}, {pos = 32, events = 0, fd = -299890304, user_data = 0x1f39ee203238}, {pos = 4096, events = 0, fd = 553160096, user_data = 0x82b7278d5}, {pos = 553159520, events = 8, fd = 728944098, user_data = 0x820f88b90}, {pos = 1895039693, events = 6075, fd = 727270416, user_data = 0x82b5a309c}, {pos = 553159592, events = 8, fd = 553159712, user_data = 0x82b59c934}, {pos = 727304500, events = 8, fd = -301947896, user_data = 0x3}, {pos = 553159696, events = 8, fd = 1895019771, user_data = 0x2000}, {pos = 0, events = 0, fd = 0, user_data = 0x1f3900000000}, {pos = -299879880, events = 7993, fd = 0, user_data = 0x0}, {pos = -298787712, events = 7993, fd = 0, user_data = 0x1f39ee00f2a8}, {pos = 727270416, events = 8, fd = -301947896, user_data = 0x820f88ca8}, {pos = 553160296, events = 8, fd = 553159824, user_data = 0x17bb70f3fc52}, {pos = 2725907, events = 0, fd = 448139, user_data = 0x1f397c96e577}, {pos = -301924272, events = 7993, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 553160552, user_data = 0x3ee00a408}, {pos = 553160376, events = 8, fd = -301925656, user_data = 0x290}, {pos = 553160296, events = 8, fd = 553159848, user_data = 0x820f88d10}, {pos = 1895037643, events = 6075, fd = 553160240, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1f39ee010050}, {pos = 1, events = 7993, fd = -301947896, user_data = 0x82b594410}, {pos = 553160552, events = 8, fd = 553160376, user_data = 0x820f88d20}, {pos = 0, events = 0, fd = -301977592, user_data = 0x20}, {pos = 553160352, events = 8, fd = 1895013495, user_data = 0x1f39ee003008}, {pos = -301976568, events = 7993, fd = -301975544, user_data = 0x1f39ee003c08}, {pos = -301961208, events = 7993, fd = -301960184, user_data = 0x1f39ee007808}, {pos = -301958136, events = 7993, fd = -301957112, user_data = 0x1f39ee008408}, {pos = -301955064, events = 7993, fd = -301954040, user_data = 0x1f39ee009008}, {pos = -301951992, events = 7993, fd = -301950968, user_data = 0x1f39ee009c08}, {pos = -301948920, events = 7993, fd = -301947896, user_data = 0x1f39ee00a808}, {pos = -301945848, events = 7993, fd = -301944824, user_data = 0x1f39ee00b408}, {pos = -301942776, events = 7993, fd = -301941752, user_data = 0x1f39ee00c008}, {pos = -301939704, events = 7993, fd = -301938680, user_data = 0x1f39ee00cc08}, {pos = -301932536, events = 7993, fd = -301931512, user_data = 0x1f39ee00e808}, {pos = -301929464, events = 7993, fd = -301977592, user_data = 0x299813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x1f39ee010050}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 553160552, events = 8, fd = 553159968, user_data = 0x2000000020}, {pos = -301977592, events = 7993, fd = 891, user_data = 0x204038}, {pos = 297, events = 0, fd = -301924272, user_data = 0x820f88f50}, {pos = 1895012225, events = 6075, fd = 12651504, user_data = 0x299813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x1f39ee010050}, {pos = 1, events = 0, fd = -301947896, user_data = 0xbf40f8 }, {pos = 728465168, events = 8, fd = -301977592, user_data = 0x2b2410}, {pos = 735298745, events = 8, fd = 1, user_data = 0x1f39ee412000}, {pos = 553160528, events = 8, fd = 735295042, user_data = 0x82b6b7f10 }, {pos = 12534008, events = 0, fd = 728465168, user_data = 0x1f39ee00a408}, {pos = 553160752, events = 8, fd = 1895011700, user_data = 0x1f39ee431000}, {pos = 1, events = 7993, fd = 1895011310, user_data = 0x1f39ee003008}, {pos = 553160536, events = 8, fd = 553160752, user_data = 0x1aa0}, {pos = 11, events = 0, fd = 1895093152, user_data = 0x0}, {pos = 553124735, events = 8, fd = 8174503, user_data = 0x820f88fe0}, {pos = 735257952, events = 8, fd = 729138272, user_data = 0x82b75e750}, {pos = 0, events = 0, fd = 8128, user_data = 0x820f89010}, {pos = 735300349, events = 8, fd = -297721856, user_data = 0x1dc2}, {pos = 553160816, events = 8, fd = 735267306, user_data = 0x0}, {pos = 0, events = 0, fd = -833144296, user_data = 0x0}} [03:43:10.052] last_touch_time = 1741318562 [03:43:10.052] last_lockfile_recheck_time = 1741318562 [03:43:10.052] nevents = 1 [03:43:10.052] #21 0x00000000008a4025 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820f89688) at ../src/backend/postmaster/postmaster.c:1386 [03:43:10.052] userDoption = [03:43:10.052] listen_addr_saved = false [03:43:10.052] output_config_variable = [03:43:10.052] opt = [03:43:10.052] status = [03:43:10.052] #22 0x00000000007d8e60 in main (argc=8, argv=0x820f89688) at ../src/backend/main/main.c:230 [03:43:10.052] do_check_root = [03:43:10.052] dispatch_option = DISPATCH_POSTMASTER [03:43:10.059] [03:43:10.059] [03:43:10.059] [03:43:10.147] dumping /tmp/cores/postgres.50579.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:43:10.265] [New LWP 102028] [03:43:10.331] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:43:10.331] Program terminated with signal SIGABRT, Aborted. [03:43:10.331] Sent by thr_kill() from pid 50579 and user 1002. [03:43:10.331] #0 0x000000082b4f11ba in thr_kill () from /lib/libc.so.7 [03:43:10.372] [03:43:10.372] Thread 1 (LWP 102028): [03:43:10.372] #0 0x000000082b4f11ba in thr_kill () from /lib/libc.so.7 [03:43:10.372] No symbol table info available. [03:43:10.372] #1 0x000000082b46a5d4 in raise () from /lib/libc.so.7 [03:43:10.372] No symbol table info available. [03:43:10.372] #2 0x000000082b51db59 in abort () from /lib/libc.so.7 [03:43:10.372] No symbol table info available. [03:43:10.372] #3 0x0000000000aae355 in ExceptionalCondition (conditionName=0x2ee916 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [03:43:10.372] No locals. [03:43:10.372] #4 0x00000000007714e4 in standard_ExecutorStart (queryDesc=0x16c6a93190a8, eflags=0) at ../src/backend/executor/execMain.c:203 [03:43:10.372] estate = 0x16c6a93fc100 [03:43:10.372] oldcontext = 0x16c6a931b400 [03:43:10.372] #5 0x00000008347caa47 in pgss_ExecutorStart (queryDesc=0x16c6a93190a8, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:998 [03:43:10.372] plan_valid = [03:43:10.372] #6 0x0000000000704c61 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:43:10.372] copied_query = [03:43:10.372] rewritten = [03:43:10.372] plan = 0x16c6a923ca90 [03:43:10.372] queryDesc = 0x16c6a93190a8 [03:43:10.372] processed = [03:43:10.372] __error = [03:43:10.372] __error = [03:43:10.372] #7 RefreshMatViewByOid (matviewOid=28728, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:43:10.372] dest = [03:43:10.372] save_userid = 10 [03:43:10.372] save_sec_context = 0 [03:43:10.372] processed = 0 [03:43:10.372] matviewRel = 0x16c6a9bfbef8 [03:43:10.372] relowner = 10 [03:43:10.372] save_nestlevel = 2 [03:43:10.372] rule = [03:43:10.372] actions = [03:43:10.372] dataQuery = [03:43:10.372] tableSpace = [03:43:10.372] relpersistence = [03:43:10.372] OIDNewHeap = 28781 [03:43:10.372] address = [03:43:10.372] #8 0x0000000000704846 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:43:10.372] lockmode = [03:43:10.372] matviewOid = 0 [03:43:10.372] #9 0x00000000006dc880 in ExecCreateTableAs (pstate=pstate@entry=0x16c6a931b500, stmt=stmt@entry=0x16c6a93adfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821124780) at ../src/backend/commands/createas.c:351 [03:43:10.372] refresh = 0x0 [03:43:10.372] query = 0x16c6a9b38948 [03:43:10.372] into = 0x16c6a93adf40 [03:43:10.372] jstate = 0x0 [03:43:10.372] do_refresh = false [03:43:10.372] address = [03:43:10.372] dest = [03:43:10.372] is_matview = [03:43:10.372] #10 0x00000000009567f2 in ProcessUtilitySlow (pstate=pstate@entry=0x16c6a931b500, pstmt=pstmt@entry=0x16c6a93ade30, queryString=queryString@entry=0x16c6a9224100 "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=0x821124780) at ../src/backend/tcop/utility.c:1678 [03:43:10.372] _local_sigjmp_buf = {{_sjb = {9789369, 25042498543568, 34914583000, 34914583360, 34914583008, 12642792, 0, 25042497942784, 47244641151, 25042506449040, 1000003, 0}}} [03:43:10.372] _save_exception_stack = 0x821124490 [03:43:10.372] _save_context_stack = 0x0 [03:43:10.372] _do_rethrow = false [03:43:10.372] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:43:10.372] parsetree = 0x16c6a93adfd0 [03:43:10.372] commandCollected = false [03:43:10.372] needCleanup = false [03:43:10.372] address = [03:43:10.372] isTopLevel = [03:43:10.372] isCompleteQuery = [03:43:10.372] #11 0x000000000095538e in standard_ProcessUtility (pstmt=pstmt@entry=0x16c6a93ade30, queryString=queryString@entry=0x16c6a9224100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x16c6a9b390e8, qc=0x821124780) at ../src/backend/tcop/utility.c:1033 [03:43:10.372] isAtomicContext = false [03:43:10.372] parsetree = 0x16c6a93adfd0 [03:43:10.372] readonly_flags = [03:43:10.372] pstate = 0x16c6a931b500 [03:43:10.372] isTopLevel = [03:43:10.372] #12 0x00000008347cb00c in pgss_ProcessUtility (pstmt=0x16c6a93ade30, queryString=0x16c6a9224100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x16c6a9b390e8, qc=0x821124780) at ../contrib/pg_stat_statements/pg_stat_statements.c:1179 [03:43:10.372] _local_sigjmp_buf = {{_sjb = {35240324918, 34914583696, 34914583496, 34914583968, 25042498543152, 0, 12642792, 34914584176, 34914567039, 9678120, 12567712, 0}}} [03:43:10.372] _save_exception_stack = 0x821124670 [03:43:10.372] _save_context_stack = 0x0 [03:43:10.372] _do_rethrow = false [03:43:10.372] bufusage = {shared_blks_hit = 35240324918, shared_blks_read = 34914583696, shared_blks_dirtied = 34914583496, shared_blks_written = 34914583968, local_blks_hit = 25042498543152, local_blks_read = 0, local_blks_dirtied = 12642792, local_blks_written = 34914584176, temp_blks_read = 34914567039, temp_blks_written = 9678120, shared_blk_read_time = {ticks = 12567712}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 34914583952}, local_blk_write_time = {ticks = 9586042}, temp_blk_read_time = {ticks = 1}, temp_blk_write_time = {ticks = 123}} [03:43:10.372] walusage_start = {wal_records = 8973, wal_fpi = 147, wal_bytes = 1378354, wal_buffers_full = 3} [03:43:10.372] duration = [03:43:10.372] bufusage_start = {shared_blks_hit = 159222, shared_blks_read = 7194, shared_blks_dirtied = 2293, shared_blks_written = 1767, 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:43:10.372] walusage = {wal_records = 1, wal_fpi = 123, wal_bytes = 34914583716, wal_buffers_full = 34914583716} [03:43:10.372] start = {ticks = -229361534041} [03:43:10.372] rows = [03:43:10.372] saved_queryId = 7566811930394970136 [03:43:10.372] parsetree = [03:43:10.372] saved_stmt_location = 0 [03:43:10.372] saved_stmt_len = 69 [03:43:10.372] enabled = [03:43:10.372] #13 0x00000000009546bc in PortalRunUtility (portal=0x16c6a9306100, pstmt=0x16c6a93ade30, isTopLevel=, setHoldSnapshot=false, dest=0x16c6a9b390e8, qc=0x821124780) at ../src/backend/tcop/pquery.c:1184 [03:43:10.372] No locals. [03:43:10.372] #14 0x0000000000953d24 in PortalRunMulti (portal=portal@entry=0x16c6a9306100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x16c6a9b390e8, altdest=altdest@entry=0x16c6a9b390e8, qc=qc@entry=0x821124780) at ../src/backend/tcop/pquery.c:1355 [03:43:10.372] pstmt = 0x16c6a93ade30 [03:43:10.372] stmtlist_item__state = {l = 0x16c6a9b39098, i = 0} [03:43:10.372] active_snapshot_set = false [03:43:10.372] query_index = 0 [03:43:10.372] stmtlist_item = 0x16c6a9b390b0 [03:43:10.372] #15 0x00000000009535e1 in PortalRun (portal=portal@entry=0x16c6a9306100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x16c6a9b390e8, altdest=altdest@entry=0x16c6a9b390e8, qc=qc@entry=0x821124780) at ../src/backend/tcop/pquery.c:819 [03:43:10.372] _local_sigjmp_buf = {{_sjb = {9778520, 25042497855744, 34914584168, 34914584416, 34914584176, 12642792, 34914584448, 12571752, 34914567039, 34914584383, 25042497863936, 25039659335680}}} [03:43:10.372] _save_exception_stack = 0x821124850 [03:43:10.372] _save_context_stack = 0x0 [03:43:10.372] _do_rethrow = false [03:43:10.372] saveTopTransactionResourceOwner = 0x16c6a9350ed8 [03:43:10.372] saveTopTransactionContext = 0x16c6a93a4000 [03:43:10.372] saveActivePortal = 0x0 [03:43:10.372] saveResourceOwner = 0x16c6a9350ed8 [03:43:10.372] savePortalContext = 0x0 [03:43:10.372] saveMemoryContext = 0x16c6a93a4000 [03:43:10.372] result = [03:43:10.372] nprocessed = [03:43:10.372] #16 0x0000000000952371 in exec_simple_query (query_string=query_string@entry=0x16c6a9224100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [03:43:10.372] cmdtaglen = 24 [03:43:10.372] snapshot_set = [03:43:10.372] per_parsetree_context = 0x0 [03:43:10.372] plantree_list = [03:43:10.372] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:43:10.372] format = 0 [03:43:10.372] parsetree = 0x16c6a92256a8 [03:43:10.372] commandTag = [03:43:10.372] cmdtagname = [03:43:10.372] querytree_list = [03:43:10.372] portal = 0x16c6a9306100 [03:43:10.372] receiver = 0x16c6a9b390e8 [03:43:10.372] parsetree_item__state = {l = 0x16c6a9225a18, i = 0} [03:43:10.372] msec_str = "\000\000\000\000\b", '\000' , "\320G\022!\b\000\000\000U\332N+\b\000\000" [03:43:10.372] dest = DestRemote [03:43:10.372] was_logged = [03:43:10.372] oldcontext = 0x16c6a93a4000 [03:43:10.372] parsetree_list = 0x16c6a9225a18 [03:43:10.372] use_implicit_block = false [03:43:10.372] parsetree_item = 0x16c6a9225a30 [03:43:10.372] save_log_statement_stats = [03:43:10.372] #17 0x000000000094ff49 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4689 [03:43:10.372] query_string = 0x16c6a9224100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:43:10.372] input_message = {data = 0x16c6a9224100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:43:10.372] firstchar = [03:43:10.372] local_sigjmp_buf = {{_sjb = {9761789, 34914584656, 34914584616, 34914585200, 12448452, 1, 12651544, 12645508, 895, 0, 0, 34359738369}}} [03:43:10.372] send_ready_for_query = false [03:43:10.372] idle_in_transaction_timeout_enabled = false [03:43:10.372] idle_session_timeout_enabled = false [03:43:10.372] #18 0x000000000094a959 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:43:10.372] bsdata = [03:43:10.372] #19 0x00000000008a1845 in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x821125580, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211254d0) at ../src/backend/postmaster/launch_backend.c:274 [03:43:10.372] pid = [03:43:10.372] #20 0x00000000008a5ed6 in BackendStartup (client_sock=0x8211254d0) at ../src/backend/postmaster/postmaster.c:3519 [03:43:10.372] startup_data = {canAcceptConnections = CAC_OK} [03:43:10.372] bn = 0x16c6a933cf28 [03:43:10.372] cac = CAC_OK [03:43:10.372] pid = [03:43:10.372] __error = [03:43:10.372] save_errno = [03:43:10.372] __error = [03:43:10.372] __error = [03:43:10.372] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:43:10.372] 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' , "0U\022!\b\000\000\000Xv\270*\b\000\000\000W\000\000\000\000\000\000\000\276\376\270*\b", '\000' , "pU\022!\b\000\000\000\324\025\212\000\000\000\000\000\300U\022!\b", '\000' }, salen = 16}} [03:43:10.372] i = 0 [03:43:10.372] now = [03:43:10.372] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 554849040, user_data = 0x0}, {pos = 0, events = 0, fd = 554848112, user_data = 0x150d0a49d2cd}, {pos = 725384120, events = 8, fd = 725459100, user_data = 0x821124f88}, {pos = 554848256, events = 8, fd = 554848160, user_data = 0x150d0a49d2cd}, {pos = 725380976, events = 8, fd = 725459100, user_data = 0x821124fb8}, {pos = 554848304, events = 8, fd = 725429700, user_data = 0x82b3d2dc4}, {pos = -1461672952, events = 5830, fd = 3, user_data = 0x821125020}, {pos = 172590331, events = 5389, fd = 727266400, user_data = 0x82b3c6f70}, {pos = 554848272, events = 8, fd = 172610253, user_data = 0x82b3cb410}, {pos = 725459100, events = 8, fd = 554848296, user_data = 0x8211250a0}, {pos = 725432628, events = 8, fd = 725432628, user_data = 0x16c6a8e0a408}, {pos = 3, events = 0, fd = 554848400, user_data = 0x150d0a4984fb}, {pos = 554848416, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x16c6a8e10050}, {pos = 1, events = 941693470, fd = -1461672952, user_data = 0x82b3c6f70}, {pos = -1461651480, events = 5830, fd = 0, user_data = 0x0}, {pos = 554848552, events = 8, fd = 554849016, user_data = 0x821125110}, {pos = 172608594, events = 5389, fd = 2725907, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = -1461649328, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8211253f8}, {pos = -1461672952, events = 3, fd = 554849096, user_data = 0x16c6a8e0f848}, {pos = 656, events = 0, fd = 554849016, user_data = 0x821125128}, {pos = 554848656, events = 8, fd = 172608203, user_data = 0x8211252c0}, {pos = 0, events = 0, fd = 0, user_data = 0x16c600000000}, {pos = -1461649328, events = 5830, fd = 1, user_data = 0x16c6a8e0a408}, {pos = 725398544, events = 8, fd = 554849272, user_data = 0x821125348}, {pos = 554848672, events = 8, fd = 0, user_data = 0x16c6a8e03008}, {pos = 33, events = 0, fd = 554849072, user_data = 0x150d0a496c77}, {pos = -1461702648, events = 5830, fd = -1461701624, user_data = 0x16c6a8e03808}, {pos = -1461699576, events = 5830, fd = -1461686264, user_data = 0x16c6a8e07408}, {pos = -1461684216, events = 5830, fd = -1461683192, user_data = 0x16c6a8e08008}, {pos = -1461681144, events = 5830, fd = -1461680120, user_data = 0x16c6a8e08c08}, {pos = -1461678072, events = 5830, fd = -1461677048, user_data = 0x16c6a8e09808}, {pos = -1461675000, events = 5830, fd = -1461673976, user_data = 0x16c6a8e0a408}, {pos = -1461671928, events = 5830, fd = -1461670904, user_data = 0x16c6a8e0b008}, {pos = -1461668856, events = 5830, fd = -1461667832, user_data = 0x16c6a8e0bc08}, {pos = -1461665784, events = 5830, fd = -1461664760, user_data = 0x16c6a8e0c808}, {pos = -1461662712, events = 5830, fd = -1461657592, user_data = 0x16c6a8e0e408}, {pos = -1461655544, events = 5830, fd = -1461654520, user_data = 0x16c6a8e10808}, {pos = 585856000, events = 0, fd = -1461702648, user_data = 0x299813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x16c6a8e10050}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554849272, events = 8, fd = 554848672, user_data = 0x2100000021}, {pos = -1461702648, events = 5830, fd = 891, user_data = 0x204038}, {pos = 297, events = 0, fd = -1461649328, user_data = 0x8211253e0}, {pos = 172582785, events = 5389, fd = 12651504, user_data = 0x299813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x16c6a8e10050}, {pos = 1, events = 0, fd = -1461672952, user_data = 0xbf40f8 }, {pos = 726593296, events = 8, fd = -1461702648, user_data = 0x2b2410}, {pos = 716764345, events = 8, fd = 1, user_data = 0x16c6a9212000}, {pos = 554849248, events = 8, fd = 716760642, user_data = 0x82b4eef10 }, {pos = 12534008, events = 0, fd = 726593296, user_data = 0x16c6a8e0a408}, {pos = 554849472, events = 8, fd = 172582260, user_data = 0x16c6a9231000}, {pos = 1, events = 5830, fd = 172581870, user_data = 0x16c6a8e03008}, {pos = 554849256, events = 8, fd = 554849472, user_data = 0x1aa0}, {pos = 11, events = 0, fd = 172663712, user_data = 0x0}, {pos = 554828671, events = 8, fd = 8174503, user_data = 0x821125470}, {pos = 716723552, events = 8, fd = 727266400, user_data = 0x82b595750}, {pos = 0, events = 0, fd = 8128, user_data = 0x8211254a0}, {pos = 716765949, events = 8, fd = -1457446912, user_data = 0x5cd5}, {pos = 554849536, events = 8, fd = 716732906, user_data = 0x0}, {pos = 0, events = 0, fd = 714452293, user_data = 0x0}} [03:43:10.372] last_touch_time = 1741318597 [03:43:10.372] last_lockfile_recheck_time = 1741318657 [03:43:10.372] nevents = 1 [03:43:10.372] #22 0x00000000008a4025 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821125b10) at ../src/backend/postmaster/postmaster.c:1386 [03:43:10.372] userDoption = [03:43:10.372] listen_addr_saved = false [03:43:10.372] output_config_variable = [03:43:10.372] opt = [03:43:10.372] status = [03:43:10.372] #23 0x00000000007d8e60 in main (argc=4, argv=0x821125b10) at ../src/backend/main/main.c:230 [03:43:10.372] do_check_root = [03:43:10.372] dispatch_option = DISPATCH_POSTMASTER [03:43:10.381] [03:43:10.381] [03:43:10.381] [03:43:10.436] dumping /tmp/cores/postgres.60732.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:43:10.556] [New LWP 101954] [03:43:10.619] Core was generated by `postgres: primary: archiver archiving 000000010000000000000003.00000028.backup'. [03:43:10.619] Program terminated with signal SIGQUIT, Quit. [03:43:10.619] Sent by thr_kill() from pid 60732 and user 1002. [03:43:10.619] #0 0x000000082adb475a in _sigprocmask () from /lib/libc.so.7 [03:43:10.631] [03:43:10.631] Thread 1 (LWP 101954): [03:43:10.631] #0 0x000000082adb475a in _sigprocmask () from /lib/libc.so.7 [03:43:10.631] No symbol table info available. [03:43:10.631] #1 0x000000082adf1a2f in _system () from /lib/libc.so.7 [03:43:10.631] No symbol table info available. [03:43:10.631] #2 0x000000082a05f8a3 in ?? () from /lib/libthr.so.3 [03:43:10.631] No symbol table info available. [03:43:10.631] #3 0x000000000067ff7b in shell_archive_file (state=, file=0x820dc25f0 "00000001", '0' , "3.00000028.backup", path=) at ../src/backend/archive/shell_archive.c:80 [03:43:10.631] nativePath = [03:43:10.631] xlogarchcmd = 0x36173dcfe150 "cp \"pg_wal/00000001", '0' , "3.00000028.backup\" \"/tmp/cirrus-ci-build/build/testrun/pg_combinebackup/009_no_full_file/data/t_009_no_full_file_primary_data/archives/00000001", '0' , "3.000000"... [03:43:10.631] rc = [03:43:10.631] #4 0x00000000008a27b7 in pgarch_archiveXlog (xlog=xlog@entry=0x820dc25f0 "00000001", '0' , "3.00000028.backup") at ../src/backend/postmaster/pgarch.c:600 [03:43:10.631] local_sigjmp_buf = {{_sjb = {9053952, 34911036912, 34911032344, 34911033600, 59473448255488, 34911036912, 34911033376, 12651536, 59473448207231, 0, 0, 1}}} [03:43:10.631] pathname = "pg_wal/00000001", '0' , "3.00000028.backup\000\220\212\310*\b\000\000\000\b\244\200=\0276\000\000\b\025\334 \b\000\000\000\310\026\334 \b\000\000\000\360\024\334 \b\000\000\000R|\270U\004\033\000\000\245\231)\000\000\000\000\0005H\214\a\000\000\000\000\035\304,\031\b\000\000\000P\000\201=\0276\000\000\001\000\000\000\b", '\000' , "\310\027\334 \b\000\000\000\276\222\253\a\003\000\000\000\030\027\334 \b\000\000\000\350\372\200=\0276\000\000\220\002\000\000\000\000\000\000\310\026\334 \b\000\000\000"... [03:43:10.631] activitymsg = "archiving 00000001", '0' , "3.00000028.backup\000\0000\000\000\000\020\031\334 \b\000\000\000\000\030\334 \b\000\000\000\000\000\000\000\000\000\000" [03:43:10.631] oldcontext = 0x36173dc1c000 [03:43:10.631] ret = [03:43:10.631] #5 0x00000000008a2214 in pgarch_ArchiverCopyLoop () at ../src/backend/postmaster/pgarch.c:474 [03:43:10.631] stat_buf = {st_dev = 18446744071679573761, st_ino = 479330, st_nlink = 1, st_mode = 33152, st_padding0 = 0, st_uid = 1002, st_gid = 1003, st_padding1 = 0, st_rdev = 18446744073709551615, st_atim = {tv_sec = 1741318708, tv_nsec = 412820000}, st_mtim = {tv_sec = 1741318708, tv_nsec = 412820000}, st_ctim = {tv_sec = 1741318708, tv_nsec = 412820000}, st_birthtim = {tv_sec = 1741318708, tv_nsec = 412812000}, st_size = 394, st_blocks = 8, st_blksize = 4096, st_flags = 0, st_gen = 0, st_spare = {0, 0, 0, 0, 0, 0, 0, 0, 0, 0}} [03:43:10.631] pathname = "pg_wal/00000001", '0' , "3.00000028.backup\000x \334 \b\000\000\000\376\377\377\377\000\000\000\000\004\032\334 \b\000\000\000\377\377\377\377\000\000\000\000\310 \334 \b", '\000' , "\260\031\334 \b\000\000\000\326\343\257", '\000' , "\225\340\257\000\000\000\000\000\310 \334 \b\000\000\000\376\377\377\377\000\000\000\000\002", '\000' , "\225\340\257\000\000\000\000\000h#\334 \b\000\000\000\330\031\334 \b", '\000' ... [03:43:10.631] failures = 0 [03:43:10.631] failures_orphan = 0 [03:43:10.631] xlog = "00000001", '0' , "3.00000028.backup" [03:43:10.631] failures = [03:43:10.631] failures_orphan = [03:43:10.631] stat_buf = [03:43:10.631] pathname = [03:43:10.631] __error = [03:43:10.631] xlogready = [03:43:10.631] __error = [03:43:10.631] __error = [03:43:10.631] __error = [03:43:10.631] #6 pgarch_MainLoop () at ../src/backend/postmaster/pgarch.c:348 [03:43:10.631] time_to_stop = false [03:43:10.631] #7 0x00000000008a1aed in PgArchiverMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/pgarch.c:271 [03:43:10.631] No locals. [03:43:10.631] #8 0x00000000008a1845 in postmaster_child_launch (child_type=child_type@entry=B_ARCHIVER, child_slot=54, startup_data=startup_data@entry=0x0, startup_data_len=startup_data_len@entry=0, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:274 [03:43:10.631] pid = [03:43:10.631] #9 0x00000000008a4447 in StartChildProcess (type=type@entry=B_ARCHIVER) at ../src/backend/postmaster/postmaster.c:3905 [03:43:10.631] pmchild = 0x0 [03:43:10.631] pid = [03:43:10.631] #10 0x00000000008a63e8 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3286 [03:43:10.631] No locals. [03:43:10.631] #11 ServerLoop () at ../src/backend/postmaster/postmaster.c:1703 [03:43:10.631] now = [03:43:10.631] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1036494296, events = 13847, fd = 551300896, user_data = 0x0}, {pos = 0, events = 0, fd = 718873608, user_data = 0x82ae66dc0}, {pos = 551299984, events = 8, fd = 1438155469, user_data = 0x82ac89bb8}, {pos = 717865116, events = 8, fd = 551300008, user_data = 0x820dc2c20}, {pos = 551300032, events = 8, fd = 1438155469, user_data = 0x82ac88f70}, {pos = 717865116, events = 8, fd = 551300056, user_data = 0x820dc2c50}, {pos = 717835716, events = 8, fd = 717835716, user_data = 0x36173d80a408}, {pos = 3, events = 0, fd = 551300160, user_data = 0x1b0455b834fb}, {pos = 551300208, events = 8, fd = 717786992, user_data = 0x820dc2c30}, {pos = 1438155469, events = 6916, fd = 717804560, user_data = 0x82ac9c09c}, {pos = 551300168, events = 8, fd = 551300288, user_data = 0x82ac95934}, {pos = 717838644, events = 8, fd = 1031840776, user_data = 0x3}, {pos = 551300272, events = 8, fd = 1438135547, user_data = 0x820dc2cc0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1138043776, fd = 1031864400, user_data = 0x800000001}, {pos = 1031840776, events = 13847, fd = 717786992, user_data = 0x36173d80f2a8}, {pos = 717804560, events = 8, fd = 1031840776, user_data = 0x820dc2d48}, {pos = 551300872, events = 8, fd = 551300400, user_data = 0x1b0455b87c52}, {pos = 2725907, events = 0, fd = 448139, user_data = 0x36177c96e577}, {pos = 1031864400, events = 13847, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 551301128, user_data = 0x33d80a408}, {pos = 551300952, events = 8, fd = 1031863016, user_data = 0x290}, {pos = 551300872, events = 8, fd = 551300424, user_data = 0x820dc2db0}, {pos = 1438153419, events = 6916, fd = 551300816, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x36173d810050}, {pos = 1, events = 13847, fd = 1031840776, user_data = 0x82ac8d410}, {pos = 551301128, events = 8, fd = 551300952, user_data = 0x820dc2dc0}, {pos = 0, events = 0, fd = 1031811080, user_data = 0x20}, {pos = 551300928, events = 8, fd = 1438129271, user_data = 0x36173d803008}, {pos = 1031812104, events = 13847, fd = 1031813128, user_data = 0x36173d803c08}, {pos = 1031827464, events = 13847, fd = 1031828488, user_data = 0x36173d807808}, {pos = 1031830536, events = 13847, fd = 1031831560, user_data = 0x36173d808408}, {pos = 1031833608, events = 13847, fd = 1031834632, user_data = 0x36173d809008}, {pos = 1031836680, events = 13847, fd = 1031837704, user_data = 0x36173d809c08}, {pos = 1031839752, events = 13847, fd = 1031840776, user_data = 0x36173d80a808}, {pos = 1031842824, events = 13847, fd = 1031843848, user_data = 0x36173d80b408}, {pos = 1031845896, events = 13847, fd = 1031846920, user_data = 0x36173d80c008}, {pos = 1031848968, events = 13847, fd = 1031849992, user_data = 0x36173d80cc08}, {pos = 1031856136, events = 13847, fd = 1031857160, user_data = 0x36173d80e808}, {pos = 1031859208, events = 13847, fd = 1031811080, user_data = 0x299813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x36173d810050}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 551301128, events = 8, fd = 551300544, user_data = 0x2000000020}, {pos = 1031811080, events = 13847, fd = 891, user_data = 0x204038}, {pos = 297, events = 0, fd = 1031864400, user_data = 0x820dc2ff0}, {pos = 1438128001, events = 6916, fd = 12651504, user_data = 0x299813}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x36173d810050}, {pos = 1, events = 0, fd = 1031840776, user_data = 0xbf40f8 }, {pos = 718999312, events = 8, fd = 1031811080, user_data = 0x2b2410}, {pos = 705021113, events = 8, fd = 1, user_data = 0x36173dc12000}, {pos = 551301104, events = 8, fd = 705017410, user_data = 0x82adb0f10 }, {pos = 12534008, events = 0, fd = 718999312, user_data = 0x36173d80a408}, {pos = 551301328, events = 8, fd = 1438127476, user_data = 0x36173dc31000}, {pos = 1, events = 13847, fd = 1438127086, user_data = 0x36173d803008}, {pos = 551301112, events = 8, fd = 551301328, user_data = 0x1aa0}, {pos = 11, events = 0, fd = 1438208928, user_data = 0x0}, {pos = 551289727, events = 8, fd = 8174503, user_data = 0x820dc3080}, {pos = 704980320, events = 8, fd = 719672416, user_data = 0x82ae57750}, {pos = 0, events = 0, fd = 8128, user_data = 0x820dc30b0}, {pos = 705022717, events = 8, fd = 1036066816, user_data = 0xed07}, {pos = 551301392, events = 8, fd = 704989674, user_data = 0x0}, {pos = 0, events = 0, fd = 718873608, user_data = 0x0}} [03:43:10.631] last_touch_time = 1741318708 [03:43:10.631] last_lockfile_recheck_time = 1741318708 [03:43:10.631] nevents = [03:43:10.631] #12 0x00000000008a4025 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820dc3728) at ../src/backend/postmaster/postmaster.c:1386 [03:43:10.631] userDoption = [03:43:10.631] listen_addr_saved = false [03:43:10.631] output_config_variable = [03:43:10.631] opt = [03:43:10.631] status = [03:43:10.631] #13 0x00000000007d8e60 in main (argc=4, argv=0x820dc3728) at ../src/backend/main/main.c:230 [03:43:10.631] do_check_root = [03:43:10.631] dispatch_option = DISPATCH_POSTMASTER