[13:40:24.974] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [13:40:25.300] dumping /tmp/cores/postgres.10734.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:40:25.430] [New LWP 101863] [13:40:25.511] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [13:40:25.511] Program terminated with signal SIGABRT, Aborted. [13:40:25.511] Sent by thr_kill() from pid 10734 and user 1003. [13:40:25.511] #0 0x000000082c51141a in thr_kill () from /lib/libc.so.7 [13:40:25.565] [13:40:25.565] Thread 1 (LWP 101863): [13:40:25.565] #0 0x000000082c51141a in thr_kill () from /lib/libc.so.7 [13:40:25.565] No symbol table info available. [13:40:25.565] #1 0x000000082c48ae64 in raise () from /lib/libc.so.7 [13:40:25.565] No symbol table info available. [13:40:25.565] #2 0x000000082c53b6f9 in abort () from /lib/libc.so.7 [13:40:25.565] No symbol table info available. [13:40:25.565] #3 0x0000000000a9f635 in ExceptionalCondition (conditionName=0x2ec00f "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [13:40:25.565] No locals. [13:40:25.565] #4 0x000000000076e1d9 in standard_ExecutorStart (queryDesc=0x83404a088, eflags=0) at ../src/backend/executor/execMain.c:195 [13:40:25.565] estate = 0x83629d100 [13:40:25.565] oldcontext = 0x83407f800 [13:40:25.565] #5 0x0000000000703b95 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [13:40:25.565] copied_query = [13:40:25.565] rewritten = [13:40:25.565] plan = 0x8362b6bd8 [13:40:25.565] queryDesc = 0x83404a088 [13:40:25.565] processed = [13:40:25.565] __error = [13:40:25.565] #6 RefreshMatViewByOid (matviewOid=28412, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [13:40:25.565] dest = [13:40:25.565] save_userid = 10 [13:40:25.565] save_sec_context = 0 [13:40:25.565] processed = 0 [13:40:25.565] matviewRel = 0x83644a688 [13:40:25.565] relowner = 10 [13:40:25.565] save_nestlevel = 2 [13:40:25.565] rule = [13:40:25.565] actions = [13:40:25.565] dataQuery = [13:40:25.565] tableSpace = [13:40:25.565] relpersistence = [13:40:25.565] OIDNewHeap = 28424 [13:40:25.565] address = [13:40:25.565] #7 0x0000000000703776 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:40:25.565] lockmode = [13:40:25.565] matviewOid = 0 [13:40:25.565] #8 0x00000000006da86c in ExecCreateTableAs (pstate=pstate@entry=0x83407f900, stmt=stmt@entry=0x8362c2fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821ae8270) at ../src/backend/commands/createas.c:351 [13:40:25.565] refresh = 0x0 [13:40:25.565] query = 0x83405dd58 [13:40:25.565] into = 0x83405e0a0 [13:40:25.565] jstate = 0x0 [13:40:25.565] do_refresh = false [13:40:25.565] address = [13:40:25.565] dest = [13:40:25.565] is_matview = [13:40:25.565] #9 0x000000000094a9a8 in ProcessUtilitySlow (pstate=pstate@entry=0x83407f900, pstmt=pstmt@entry=0x833f80a68, queryString=queryString@entry=0x833f7f100 "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=0x821ae8270) at ../src/backend/tcop/utility.c:1678 [13:40:25.565] _local_sigjmp_buf = {{_sjb = {9740761, 0, 34924822168, 34924822544, 34924822176, 12433272, 0, 35232676096, 4294902655, 34924822284, 34924822320, 0}}} [13:40:25.565] _save_exception_stack = 0x821ae8170 [13:40:25.565] _save_context_stack = 0x0 [13:40:25.565] _do_rethrow = false [13:40:25.565] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:40:25.565] parsetree = 0x8362c2fd0 [13:40:25.565] commandCollected = false [13:40:25.565] needCleanup = false [13:40:25.565] address = [13:40:25.565] isTopLevel = [13:40:25.565] isCompleteQuery = [13:40:25.565] #10 0x0000000000949328 in standard_ProcessUtility (pstmt=0x833f80a68, queryString=0x833f7f100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83405e588, qc=0x821ae8270) at ../src/backend/tcop/utility.c:1033 [13:40:25.565] isAtomicContext = false [13:40:25.565] parsetree = 0x8362c2fd0 [13:40:25.565] readonly_flags = [13:40:25.565] pstate = 0x83407f900 [13:40:25.565] isTopLevel = [13:40:25.565] #11 0x0000000000948db8 in ProcessUtility (pstmt=0x18de7, queryString=0x6 , readOnlyTree=, context=743511034, params=0x0, queryEnv=0x0, dest=0x83405e588, qc=0x821ae8270) at ../src/backend/tcop/utility.c:523 [13:40:25.565] No locals. [13:40:25.565] #12 0x00000000009488f3 in PortalRunUtility (portal=0x834056100, pstmt=0x833f80a68, isTopLevel=, setHoldSnapshot=, dest=0x83405e588, qc=0x821ae8270) at ../src/backend/tcop/pquery.c:1158 [13:40:25.565] No locals. [13:40:25.565] #13 0x0000000000947f84 in PortalRunMulti (portal=portal@entry=0x834056100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83405e588, altdest=altdest@entry=0x83405e588, qc=0x821ae8270) at ../src/backend/tcop/pquery.c:1322 [13:40:25.565] pstmt = 0x833f80a68 [13:40:25.565] stmtlist_item__state = {l = 0x83405e538, i = 0} [13:40:25.565] active_snapshot_set = false [13:40:25.565] stmtlist_item = 0x83405e550 [13:40:25.565] #14 0x0000000000947853 in PortalRun (portal=portal@entry=0x834056100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83405e588, altdest=altdest@entry=0x83405e588, qc=0x821ae8270) at ../src/backend/tcop/pquery.c:791 [13:40:25.565] _local_sigjmp_buf = {{_sjb = {9729997, 35232506112, 34924822888, 34924823120, 34924822896, 35232522240, 12398856, 12433272, 35232482175, 35268597136, 4294967984, 0}}} [13:40:25.565] _save_exception_stack = 0x821ae8340 [13:40:25.565] _save_context_stack = 0x0 [13:40:25.565] _do_rethrow = false [13:40:25.565] saveTopTransactionResourceOwner = 0x834067298 [13:40:25.565] saveTopTransactionContext = 0x83405a000 [13:40:25.565] saveActivePortal = 0x0 [13:40:25.565] saveResourceOwner = 0x834067298 [13:40:25.565] savePortalContext = 0x0 [13:40:25.565] saveMemoryContext = 0x83405a000 [13:40:25.565] result = [13:40:25.565] nprocessed = [13:40:25.565] #15 0x00000000009466d2 in exec_simple_query (query_string=query_string@entry=0x833f7f100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:40:25.565] cmdtaglen = 24 [13:40:25.565] snapshot_set = [13:40:25.565] per_parsetree_context = 0x0 [13:40:25.565] plantree_list = [13:40:25.565] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:40:25.565] format = 0 [13:40:25.565] parsetree = 0x833f806a8 [13:40:25.565] commandTag = [13:40:25.565] cmdtagname = [13:40:25.565] querytree_list = [13:40:25.565] portal = 0x834056100 [13:40:25.565] receiver = 0x83405e588 [13:40:25.565] parsetree_item__state = {l = 0x833f80a18, i = 0} [13:40:25.565] msec_str = "\000\000\000\000\b", '\000' , "\316\024Kg\000\000\000\000}\312\351\311\363\262\301", [13:40:25.565] dest = DestRemote [13:40:25.565] was_logged = [13:40:25.565] oldcontext = 0x83405a000 [13:40:25.565] parsetree_list = 0x833f80a18 [13:40:25.565] use_implicit_block = false [13:40:25.565] parsetree_item = 0x833f80a30 [13:40:25.565] save_log_statement_stats = [13:40:25.565] #16 0x0000000000944343 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4805 [13:40:25.565] query_string = 0x833f7f100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:40:25.565] input_message = {data = 0x833f7f100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:40:25.565] firstchar = [13:40:25.565] local_sigjmp_buf = {{_sjb = {9713654, 34924823360, 34924823320, 34924823904, 12442008, 1, 8192, 8388608, 34924790655, 0, 0, 1}}} [13:40:25.565] send_ready_for_query = false [13:40:25.565] idle_in_transaction_timeout_enabled = false [13:40:25.565] idle_session_timeout_enabled = false [13:40:25.565] #17 0x000000000093eb39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:40:25.565] bsdata = [13:40:25.565] #18 0x0000000000896d15 in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x821ae9078 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821ae8fc0) at ../src/backend/postmaster/launch_backend.c:274 [13:40:25.565] pid = [13:40:25.565] #19 0x000000000089ae88 in BackendStartup (client_sock=0x821ae8fc0) at ../src/backend/postmaster/postmaster.c:3377 [13:40:25.565] startup_data = {canAcceptConnections = CAC_OK} [13:40:25.565] bn = 0x834022128 [13:40:25.565] cac = CAC_OK [13:40:25.565] pid = [13:40:25.565] __error = [13:40:25.565] save_errno = [13:40:25.565] __error = [13:40:25.565] __error = [13:40:25.565] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [13:40:25.565] 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' , " \220\256!\b\000\000\000h57+\b\000\000\000\355\000\000\000\000\000\000\000^\2777+\b", '\000' , "`\220\256!\b\000\000\000\264j\211\000\000\000\000\000p\220\256!\b", '\000' }, salen = 16}} [13:40:25.565] i = 0 [13:40:25.565] now = [13:40:25.565] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 742390467, events = 8, fd = 128686702, user_data = 0x21511c93dacf}, {pos = 575134264, events = 8, fd = 1, user_data = 0x822477408}, {pos = 742261096, events = 8, fd = -617993552, user_data = 0x821ae8788}, {pos = 565086080, events = 8, fd = 8192, user_data = 0x101000}, {pos = 872783872, events = 8, fd = 565085888, user_data = 0x82c580a47}, {pos = 1, events = 0, fd = 1052672, user_data = 0xe8}, {pos = 0, events = 0, fd = 575094792, user_data = 0x822474408}, {pos = 575096840, events = 8, fd = 575097864, user_data = 0x821ae8780}, {pos = 565086072, events = 8, fd = 835043472, user_data = 0x833a00980}, {pos = 32, events = 0, fd = 4096, user_data = 0x821ae8940}, {pos = 743946876, events = 8, fd = 565085952, user_data = 0x82c580b22}, {pos = 565086072, events = 8, fd = 835043472, user_data = 0x20}, {pos = 4096, events = 0, fd = 565086528, user_data = 0x82c57c098}, {pos = 866123984, events = 8, fd = 835043472, user_data = 0x3000}, {pos = 8192, events = 0, fd = 835043520, user_data = 0x1000}, {pos = 4097, events = 0, fd = 8192, user_data = 0x833a00980}, {pos = 565087664, events = 8, fd = 866146520, user_data = 0x0}, {pos = 0, events = 0, fd = 866175104, user_data = 0x0}, {pos = 866174976, events = 8, fd = 232, user_data = 0x1}, {pos = 866126208, events = 8, fd = 565087664, user_data = 0x20}, {pos = 8388608, events = 0, fd = 8192, user_data = 0x833a0c580}, {pos = 888800072, events = 8, fd = 888800064, user_data = 0x834fa0338}, {pos = 888800048, events = 8, fd = 8417280, user_data = 0x83404e000}, {pos = 8193, events = 0, fd = 565086192, user_data = 0x821ae87f0}, {pos = 1, events = 0, fd = 871821716, user_data = 0x0}, {pos = 565086288, events = 8, fd = 725071212, user_data = 0x1}, {pos = 871821312, events = 8, fd = 565086336, user_data = 0x82b37a702}, {pos = 744098128, events = 8, fd = 744186232, user_data = 0x82c5a0950 }, {pos = 575108104, events = 8, fd = 565086560, user_data = 0x2151096853de}, {pos = 575098888, events = 8, fd = 1, user_data = 0x21510968525e}, {pos = 575108104, events = 8, fd = 565086344, user_data = 0x821ae8960}, {pos = 12264, events = 0, fd = 0, user_data = 0x215109698990}, {pos = 565087952, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = -617993552, events = 1482486076, fd = 0, user_data = 0x822477408}, {pos = 12264, events = 0, fd = -617993552, user_data = 0x831c5c090}, {pos = 1, events = 0, fd = 866146520, user_data = 0x833a00980}, {pos = 0, events = 0, fd = 565086672, user_data = 0x82c49f915 }, {pos = 0, events = 0, fd = 565086608, user_data = 0x821ae8e00}, {pos = 0, events = 0, fd = 565086672, user_data = 0x82c4b5b61}, {pos = 1, events = 0, fd = 565087744, user_data = 0x821ae8e00}, {pos = 0, events = 16777216, fd = -617993552, user_data = 0x82c5c46a0 <__stack_chk_guard>}, {pos = 872265176, events = 8, fd = 0, user_data = 0x82c5a9e38}, {pos = 565087952, events = 8, fd = 565087808, user_data = 0x82c4b5c82}, {pos = 0, events = 0, fd = 565088112, user_data = 0x833fdb5d8}, {pos = 565087744, events = 8, fd = 565087072, user_data = 0x2000}, {pos = 8192, events = 0, fd = 872734720, user_data = 0x821ae8b68}, {pos = 0, events = 0, fd = 835043472, user_data = 0x1}, {pos = 565086880, events = 8, fd = 743967177, user_data = 0x82c3e5388}, {pos = 742374776, events = 8, fd = 565086904, user_data = 0x821ae8b30}, {pos = 565087072, events = 8, fd = 565087064, user_data = 0x831c5c090}, {pos = 866126208, events = 8, fd = 32, user_data = 0x1000}, {pos = 565087520, events = 8, fd = 743946876, user_data = 0x821ae8b58}, {pos = 157860618, events = 8529, fd = 742250584, user_data = 0x82c3fbd78}, {pos = 565087016, events = 8, fd = 565087136, user_data = 0x821ae8b28}, {pos = 742337804, events = 8, fd = 575108104, user_data = 0x82c3f2d0c}, {pos = 565087120, events = 8, fd = 157840442, user_data = 0x831c5c0c0}, {pos = 4096, events = 0, fd = 4097, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x833a03238}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 575128200, user_data = 0x82c3dd858}, {pos = 575108104, events = 8, fd = 565087272, user_data = 0x821ae8de8}, {pos = 565087248, events = 8, fd = 157858978, user_data = 0x2980f4}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82247d038}} [13:40:25.565] last_touch_time = 1732973753 [13:40:25.565] last_lockfile_recheck_time = 1732973753 [13:40:25.565] nevents = 1 [13:40:25.565] #21 0x0000000000899490 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821ae95d0) at ../src/backend/postmaster/postmaster.c:1361 [13:40:25.565] userDoption = [13:40:25.565] listen_addr_saved = false [13:40:25.565] output_config_variable = [13:40:25.565] opt = [13:40:25.565] status = [13:40:25.565] #22 0x00000000007d159c in main (argc=8, argv=0x821ae95d0) at ../src/backend/main/main.c:196 [13:40:25.565] do_check_root = [13:40:25.574] [13:40:25.574] [13:40:25.574] [13:40:25.631] dumping /tmp/cores/postgres.10953.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:40:25.751] [New LWP 101907] [13:40:25.813] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [13:40:25.813] Program terminated with signal SIGABRT, Aborted. [13:40:25.813] Sent by thr_kill() from pid 10953 and user 1003. [13:40:25.813] #0 0x000000082a0cb41a in thr_kill () from /lib/libc.so.7 [13:40:25.846] [13:40:25.846] Thread 1 (LWP 101907): [13:40:25.846] #0 0x000000082a0cb41a in thr_kill () from /lib/libc.so.7 [13:40:25.846] No symbol table info available. [13:40:25.846] #1 0x000000082a044e64 in raise () from /lib/libc.so.7 [13:40:25.846] No symbol table info available. [13:40:25.846] #2 0x000000082a0f56f9 in abort () from /lib/libc.so.7 [13:40:25.846] No symbol table info available. [13:40:25.846] #3 0x0000000000a9f635 in ExceptionalCondition (conditionName=0x2ec00f "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [13:40:25.846] No locals. [13:40:25.846] #4 0x000000000076e1d9 in standard_ExecutorStart (queryDesc=0x841857088, eflags=0) at ../src/backend/executor/execMain.c:195 [13:40:25.846] estate = 0x8340ab100 [13:40:25.846] oldcontext = 0x83408c800 [13:40:25.846] #5 0x0000000000703b95 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [13:40:25.846] copied_query = [13:40:25.846] rewritten = [13:40:25.846] plan = 0x83409abd8 [13:40:25.846] queryDesc = 0x841857088 [13:40:25.846] processed = [13:40:25.846] __error = [13:40:25.846] #6 RefreshMatViewByOid (matviewOid=28388, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [13:40:25.846] dest = [13:40:25.846] save_userid = 10 [13:40:25.846] save_sec_context = 0 [13:40:25.846] processed = 0 [13:40:25.846] matviewRel = 0x8419a7238 [13:40:25.846] relowner = 10 [13:40:25.846] save_nestlevel = 2 [13:40:25.846] rule = [13:40:25.846] actions = [13:40:25.846] dataQuery = [13:40:25.846] tableSpace = [13:40:25.846] relpersistence = [13:40:25.846] OIDNewHeap = 28395 [13:40:25.846] address = [13:40:25.846] #7 0x0000000000703776 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:40:25.846] lockmode = [13:40:25.846] matviewOid = 0 [13:40:25.846] #8 0x00000000006da86c in ExecCreateTableAs (pstate=pstate@entry=0x83408c900, stmt=stmt@entry=0x8340bdfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8219d2900) at ../src/backend/commands/createas.c:351 [13:40:25.846] refresh = 0x0 [13:40:25.846] query = 0x833feaa98 [13:40:25.846] into = 0x833feade0 [13:40:25.846] jstate = 0x0 [13:40:25.846] do_refresh = false [13:40:25.846] address = [13:40:25.846] dest = [13:40:25.846] is_matview = [13:40:25.846] #9 0x000000000094a9a8 in ProcessUtilitySlow (pstate=pstate@entry=0x83408c900, pstmt=pstmt@entry=0x833f03a68, queryString=queryString@entry=0x833f02100 "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=0x8219d2900) at ../src/backend/tcop/utility.c:1678 [13:40:25.846] _local_sigjmp_buf = {{_sjb = {9740761, 0, 34923685160, 34923685536, 34923685168, 12433272, 0, 35232729344, 4294902655, 34923685276, 34923685312, 0}}} [13:40:25.846] _save_exception_stack = 0x8219d2800 [13:40:25.846] _save_context_stack = 0x0 [13:40:25.846] _do_rethrow = false [13:40:25.846] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:40:25.846] parsetree = 0x8340bdfd0 [13:40:25.846] commandCollected = false [13:40:25.846] needCleanup = false [13:40:25.846] address = [13:40:25.846] isTopLevel = [13:40:25.846] isCompleteQuery = [13:40:25.846] #10 0x0000000000949328 in standard_ProcessUtility (pstmt=0x833f03a68, queryString=0x833f02100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x833feb2c8, qc=0x8219d2900) at ../src/backend/tcop/utility.c:1033 [13:40:25.846] isAtomicContext = false [13:40:25.846] parsetree = 0x8340bdfd0 [13:40:25.846] readonly_flags = [13:40:25.846] pstate = 0x83408c900 [13:40:25.846] isTopLevel = [13:40:25.846] #11 0x0000000000948db8 in ProcessUtility (pstmt=0x18e13, queryString=0x6 , readOnlyTree=, context=705475578, params=0x0, queryEnv=0x0, dest=0x833feb2c8, qc=0x8219d2900) at ../src/backend/tcop/utility.c:523 [13:40:25.846] No locals. [13:40:25.846] #12 0x00000000009488f3 in PortalRunUtility (portal=0x833fa8100, pstmt=0x833f03a68, isTopLevel=, setHoldSnapshot=, dest=0x833feb2c8, qc=0x8219d2900) at ../src/backend/tcop/pquery.c:1158 [13:40:25.846] No locals. [13:40:25.846] #13 0x0000000000947f84 in PortalRunMulti (portal=portal@entry=0x833fa8100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x833feb2c8, altdest=altdest@entry=0x833feb2c8, qc=0x8219d2900) at ../src/backend/tcop/pquery.c:1322 [13:40:25.846] pstmt = 0x833f03a68 [13:40:25.846] stmtlist_item__state = {l = 0x833feb278, i = 0} [13:40:25.846] active_snapshot_set = false [13:40:25.846] stmtlist_item = 0x833feb290 [13:40:25.846] #14 0x0000000000947853 in PortalRun (portal=portal@entry=0x833fa8100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x833feb2c8, altdest=altdest@entry=0x833feb2c8, qc=0x8219d2900) at ../src/backend/tcop/pquery.c:791 [13:40:25.846] _local_sigjmp_buf = {{_sjb = {9729997, 35231793408, 34923685880, 34923686112, 34923685888, 35231809536, 12398856, 12433272, 35231761279, 35232925072, 4294967984, 0}}} [13:40:25.846] _save_exception_stack = 0x8219d29d0 [13:40:25.846] _save_context_stack = 0x0 [13:40:25.846] _do_rethrow = false [13:40:25.846] saveTopTransactionResourceOwner = 0x833ff78d8 [13:40:25.846] saveTopTransactionContext = 0x833fac000 [13:40:25.846] saveActivePortal = 0x0 [13:40:25.846] saveResourceOwner = 0x833ff78d8 [13:40:25.846] savePortalContext = 0x0 [13:40:25.846] saveMemoryContext = 0x833fac000 [13:40:25.846] result = [13:40:25.846] nprocessed = [13:40:25.846] #15 0x00000000009466d2 in exec_simple_query (query_string=query_string@entry=0x833f02100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:40:25.846] cmdtaglen = 24 [13:40:25.846] snapshot_set = [13:40:25.846] per_parsetree_context = 0x0 [13:40:25.846] plantree_list = [13:40:25.846] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:40:25.846] format = 0 [13:40:25.846] parsetree = 0x833f036a8 [13:40:25.846] commandTag = [13:40:25.846] cmdtagname = [13:40:25.846] querytree_list = [13:40:25.846] portal = 0x833fa8100 [13:40:25.846] receiver = 0x833feb2c8 [13:40:25.846] parsetree_item__state = {l = 0x833f03a18, i = 0} [13:40:25.846] msec_str = "\000\000\000\000\b", '\000' , "\317\024Kg\000\000\000\000}\206\v7v\205ʆ" [13:40:25.846] dest = DestRemote [13:40:25.846] was_logged = [13:40:25.846] oldcontext = 0x833fac000 [13:40:25.846] parsetree_list = 0x833f03a18 [13:40:25.846] use_implicit_block = false [13:40:25.846] parsetree_item = 0x833f03a30 [13:40:25.846] save_log_statement_stats = [13:40:25.846] #16 0x0000000000944343 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4805 [13:40:25.846] query_string = 0x833f02100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:40:25.846] input_message = {data = 0x833f02100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:40:25.846] firstchar = [13:40:25.846] local_sigjmp_buf = {{_sjb = {9713654, 34923686352, 34923686312, 34923686896, 12442008, 1, 8192, 8388608, 34923676543, 0, 0, 1}}} [13:40:25.846] send_ready_for_query = false [13:40:25.846] idle_in_transaction_timeout_enabled = false [13:40:25.846] idle_session_timeout_enabled = false [13:40:25.846] #17 0x000000000093eb39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:40:25.846] bsdata = [13:40:25.846] #18 0x0000000000896d15 in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x8219d3708 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8219d3650) at ../src/backend/postmaster/launch_backend.c:274 [13:40:25.846] pid = [13:40:25.846] #19 0x000000000089ae88 in BackendStartup (client_sock=0x8219d3650) at ../src/backend/postmaster/postmaster.c:3377 [13:40:25.846] startup_data = {canAcceptConnections = CAC_OK} [13:40:25.846] bn = 0x833fc60c8 [13:40:25.846] cac = CAC_OK [13:40:25.846] pid = [13:40:25.846] __error = [13:40:25.846] save_errno = [13:40:25.846] __error = [13:40:25.846] __error = [13:40:25.846] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [13:40:25.846] 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' , "\2606\235!\b\000\000\000h\245\240)\b\000\000\000\331\000\000\000\000\000\000\000^/\241)\b", '\000' , "\3606\235!\b\000\000\000\264j\211\000\000\000\000\000\0007\235!\b", '\000' }, salen = 16}} [13:40:25.846] i = 0 [13:40:25.846] now = [13:40:25.846] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 704355011, events = 8, fd = 128686702, user_data = 0x1d941c93dacf}, {pos = 574396984, events = 8, fd = 1, user_data = 0x8223c3408}, {pos = 704225640, events = 8, fd = 563949352, user_data = 0x8219d2e70}, {pos = 563948768, events = 8, fd = 1, user_data = 0x8223c3408}, {pos = 32, events = 0, fd = 563949152, user_data = 0x1d94c8ab4a1a}, {pos = 574341128, events = 8, fd = 574342152, user_data = 0x8223bc808}, {pos = 574344200, events = 8, fd = 574357512, user_data = 0x8223c0408}, {pos = 574359560, events = 8, fd = 574360584, user_data = 0x8223c1008}, {pos = 574362632, events = 8, fd = 574363656, user_data = 0x8223c1c08}, {pos = 574365704, events = 8, fd = 574366728, user_data = 0x8223c2808}, {pos = 574368776, events = 8, fd = 574369800, user_data = 0x8223c3408}, {pos = -25761258, events = 8, fd = 574394424, user_data = 0x1}, {pos = 574370824, events = 8, fd = 704246904, user_data = 0x8219d30a8}, {pos = 2837853, events = 0, fd = 563949552, user_data = 0x8219d2e60}, {pos = 1, events = 0, fd = 563949480, user_data = 0x20}, {pos = 563949136, events = 8, fd = -928273805, user_data = 0x8223c3408}, {pos = 704355011, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 574396984, events = 8, fd = 1, user_data = 0x8223c3408}, {pos = 704225640, events = 8, fd = 563949352, user_data = 0x8219d2ce0}, {pos = 32, events = 18, fd = 0, user_data = 0x8223c9a38}, {pos = 1, events = 0, fd = 574370824, user_data = 0x347}, {pos = 563949328, events = 8, fd = -928299537, user_data = 0x829fb9ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x8223c9a38}, {pos = 1, events = 0, fd = 574370824, user_data = 0x833ef2000}, {pos = 1, events = 0, fd = 871309716, user_data = 0x0}, {pos = 563949280, events = 8, fd = 698426732, user_data = 0x1}, {pos = 871309312, events = 8, fd = 563949328, user_data = 0x829a11702}, {pos = 706062672, events = 8, fd = 706150776, user_data = 0x82a15a950 }, {pos = 574370824, events = 8, fd = 563949552, user_data = 0x1d94c8ab43de}, {pos = 574361608, events = 8, fd = 1, user_data = 0x1d94c8ab425e}, {pos = 574370824, events = 8, fd = 563949336, user_data = 0x8219d2ff0}, {pos = 12264, events = 0, fd = 0, user_data = 0x1d94c8ac7990}, {pos = 563950944, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = -512201758, events = 2425905372, fd = 0, user_data = 0x8223c3408}, {pos = 12264, events = 0, fd = 704204800, user_data = 0x1db178}, {pos = 706062672, events = 8, fd = 704339320, user_data = 0x3d4b}, {pos = 706209440, events = 8, fd = 563949664, user_data = 0x82a059915 }, {pos = 706100792, events = 8, fd = 563949600, user_data = 0x8219d3490}, {pos = 0, events = 0, fd = 563949664, user_data = 0x82a06fb61}, {pos = 1, events = 0, fd = 563950736, user_data = 0x8219d3490}, {pos = 0, events = 16777216, fd = -512201758, user_data = 0x82a17e6a0 <__stack_chk_guard>}, {pos = 871810520, events = 8, fd = 0, user_data = 0x82a163e38}, {pos = 563950944, events = 8, fd = 563950800, user_data = 0x82a06fc82}, {pos = 0, events = 0, fd = 563951104, user_data = 0x833f6c5d8}, {pos = 563950736, events = 8, fd = 0, user_data = 0x0}, {pos = -512201758, events = 2425905372, fd = -928271606, user_data = 0x829fa47a0}, {pos = 704339320, events = 8, fd = 563949848, user_data = 0x8219d3190}, {pos = 563949848, events = 8, fd = -928271606, user_data = 0x829f9f388}, {pos = 704339320, events = 8, fd = 563949896, user_data = 0x8219d31c0}, {pos = 563949896, events = 8, fd = 704307604, user_data = 0x8223c3408}, {pos = 704307604, events = 8, fd = 563950000, user_data = 0x1d94c8ab643a}, {pos = 706129968, events = 8, fd = 1, user_data = 0x8219d31e0}, {pos = -928271606, events = 7572, fd = 704215128, user_data = 0x829fb5d78}, {pos = 563950008, events = 8, fd = 563950128, user_data = 0x8219d31b8}, {pos = 704302348, events = 8, fd = 574370824, user_data = 0x829facd0c}, {pos = 563950112, events = 8, fd = -928291782, user_data = 0x8219d3248}, {pos = 563950600, events = 8, fd = 563950128, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x909860dc526629ce}, {pos = 574394424, events = 8, fd = 1, user_data = 0x8223c3408}, {pos = 704246664, events = 8, fd = 574390920, user_data = 0x829f97858}, {pos = 574370824, events = 8, fd = 563950264, user_data = 0x8219d3478}, {pos = 563950240, events = 8, fd = -928273246, user_data = 0x2980f4}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8223c9038}} [13:40:25.846] last_touch_time = 1732973753 [13:40:25.846] last_lockfile_recheck_time = 1732973753 [13:40:25.846] nevents = 1 [13:40:25.846] #21 0x0000000000899490 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8219d3c68) at ../src/backend/postmaster/postmaster.c:1361 [13:40:25.846] userDoption = [13:40:25.846] listen_addr_saved = false [13:40:25.846] output_config_variable = [13:40:25.846] opt = [13:40:25.846] status = [13:40:25.846] #22 0x00000000007d159c in main (argc=4, argv=0x8219d3c68) at ../src/backend/main/main.c:196 [13:40:25.846] do_check_root = [13:40:25.855] [13:40:25.855] [13:40:25.855] [13:40:25.914] dumping /tmp/cores/postgres.17975.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:40:26.035] [New LWP 100184] [13:40:26.096] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [13:40:26.096] Program terminated with signal SIGABRT, Aborted. [13:40:26.096] Sent by thr_kill() from pid 17975 and user 1003. [13:40:26.096] #0 0x000000082bb6d41a in thr_kill () from /lib/libc.so.7 [13:40:26.137] [13:40:26.137] Thread 1 (LWP 100184): [13:40:26.137] #0 0x000000082bb6d41a in thr_kill () from /lib/libc.so.7 [13:40:26.137] No symbol table info available. [13:40:26.137] #1 0x000000082bae6e64 in raise () from /lib/libc.so.7 [13:40:26.137] No symbol table info available. [13:40:26.137] #2 0x000000082bb976f9 in abort () from /lib/libc.so.7 [13:40:26.137] No symbol table info available. [13:40:26.137] #3 0x0000000000a9f635 in ExceptionalCondition (conditionName=0x2ec00f "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [13:40:26.137] No locals. [13:40:26.137] #4 0x000000000076e1d9 in standard_ExecutorStart (queryDesc=0x838f4b088, eflags=0) at ../src/backend/executor/execMain.c:195 [13:40:26.137] estate = 0x836ac5100 [13:40:26.137] oldcontext = 0x838f5d800 [13:40:26.137] #5 0x0000000839e099c2 in pgss_ExecutorStart (queryDesc=0x838f4b088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [13:40:26.137] No locals. [13:40:26.137] #6 0x0000000000703b95 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [13:40:26.137] copied_query = [13:40:26.137] rewritten = [13:40:26.137] plan = 0x838f4abd8 [13:40:26.137] queryDesc = 0x838f4b088 [13:40:26.137] processed = [13:40:26.137] __error = [13:40:26.137] #7 RefreshMatViewByOid (matviewOid=28251, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [13:40:26.137] dest = [13:40:26.137] save_userid = 10 [13:40:26.137] save_sec_context = 0 [13:40:26.137] processed = 0 [13:40:26.137] matviewRel = 0x83912d258 [13:40:26.137] relowner = 10 [13:40:26.137] save_nestlevel = 2 [13:40:26.137] rule = [13:40:26.137] actions = [13:40:26.137] dataQuery = [13:40:26.137] tableSpace = [13:40:26.137] relpersistence = [13:40:26.137] OIDNewHeap = 28263 [13:40:26.137] address = [13:40:26.137] #8 0x0000000000703776 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:40:26.137] lockmode = [13:40:26.137] matviewOid = 0 [13:40:26.137] #9 0x00000000006da86c in ExecCreateTableAs (pstate=pstate@entry=0x838f5d900, stmt=stmt@entry=0x836b10fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820cb7600) at ../src/backend/commands/createas.c:351 [13:40:26.137] refresh = 0x0 [13:40:26.137] query = 0x836a9d248 [13:40:26.137] into = 0x836b10f40 [13:40:26.137] jstate = 0x0 [13:40:26.137] do_refresh = false [13:40:26.137] address = [13:40:26.137] dest = [13:40:26.137] is_matview = [13:40:26.137] #10 0x000000000094a9a8 in ProcessUtilitySlow (pstate=pstate@entry=0x838f5d900, pstmt=pstmt@entry=0x836b10e30, queryString=queryString@entry=0x8369b5100 "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=0x820cb7600) at ../src/backend/tcop/utility.c:1678 [13:40:26.137] _local_sigjmp_buf = {{_sjb = {9740761, 0, 34909941864, 34909942240, 34909941872, 12433272, 0, 35315374336, 34909913983, 7, 34909942016, 0}}} [13:40:26.137] _save_exception_stack = 0x820cb72f0 [13:40:26.137] _save_context_stack = 0x0 [13:40:26.137] _do_rethrow = false [13:40:26.137] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:40:26.137] parsetree = 0x836b10fd0 [13:40:26.137] commandCollected = false [13:40:26.137] needCleanup = false [13:40:26.137] address = [13:40:26.137] isTopLevel = [13:40:26.137] isCompleteQuery = [13:40:26.137] #11 0x0000000000949328 in standard_ProcessUtility (pstmt=0x836b10e30, queryString=queryString@entry=0x8369b5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836a9d9e8, qc=0x820cb7600) at ../src/backend/tcop/utility.c:1033 [13:40:26.137] isAtomicContext = false [13:40:26.137] parsetree = 0x836b10fd0 [13:40:26.137] readonly_flags = [13:40:26.137] pstate = 0x838f5d900 [13:40:26.137] isTopLevel = [13:40:26.137] #12 0x0000000839e09f7e in pgss_ProcessUtility (pstmt=0x836b10e30, queryString=0x8369b5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836a9d9e8, qc=0x820cb7600) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [13:40:26.137] _local_sigjmp_buf = {{_sjb = {35330760375, 34909942512, 34909942376, 34909942832, 35277311536, 0, 12433272, 34909943040, 34909913983, 34909942612, 34909942640, 0}}} [13:40:26.137] _save_exception_stack = 0x820cb7500 [13:40:26.137] _save_context_stack = 0x0 [13:40:26.137] _do_rethrow = false [13:40:26.137] bufusage = {shared_blks_hit = 35330760375, shared_blks_read = 34909942512, shared_blks_dirtied = 34909942376, shared_blks_written = 34909942832, local_blks_hit = 35277311536, local_blks_read = 0, local_blks_dirtied = 12433272, local_blks_written = 34909943040, temp_blks_read = 34909913983, temp_blks_written = 34909942612, shared_blk_read_time = {ticks = 34909942640}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4201573684102432896}, local_blk_write_time = {ticks = 12442312}, temp_blk_read_time = {ticks = 35342178304}, temp_blk_write_time = {ticks = 12394800}} [13:40:26.137] walusage_start = {wal_records = 8974, wal_fpi = 142, wal_bytes = 1302468} [13:40:26.137] duration = [13:40:26.137] bufusage_start = {shared_blks_hit = 153105, shared_blks_read = 9396, shared_blks_dirtied = 2748, shared_blks_written = 2570, 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}} [13:40:26.137] walusage = {wal_records = -2707740038349024872, wal_fpi = 35277311952, wal_bytes = 123} [13:40:26.137] start = {ticks = -179763032698} [13:40:26.137] rows = [13:40:26.137] saved_queryId = 6041762721901209185 [13:40:26.137] parsetree = [13:40:26.137] saved_stmt_location = 0 [13:40:26.137] saved_stmt_len = 69 [13:40:26.137] enabled = [13:40:26.137] #13 0x00000000009488f3 in PortalRunUtility (portal=0x836a5b100, pstmt=0x836b10e30, isTopLevel=, setHoldSnapshot=, dest=0x836a9d9e8, qc=0x820cb7600) at ../src/backend/tcop/pquery.c:1158 [13:40:26.137] No locals. [13:40:26.137] #14 0x0000000000947f84 in PortalRunMulti (portal=portal@entry=0x836a5b100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x836a9d9e8, altdest=altdest@entry=0x836a9d9e8, qc=0x820cb7600) at ../src/backend/tcop/pquery.c:1322 [13:40:26.137] pstmt = 0x836b10e30 [13:40:26.137] stmtlist_item__state = {l = 0x836a9d998, i = 0} [13:40:26.137] active_snapshot_set = false [13:40:26.137] stmtlist_item = 0x836a9d9b0 [13:40:26.137] #15 0x0000000000947853 in PortalRun (portal=portal@entry=0x836a5b100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x836a9d9e8, altdest=altdest@entry=0x836a9d9e8, qc=0x820cb7600) at ../src/backend/tcop/pquery.c:791 [13:40:26.137] _local_sigjmp_buf = {{_sjb = {9729997, 35276566784, 34909943032, 34909943264, 34909943040, 35276582912, 12398856, 12433272, 35276522367, 35277305312, 4294967984, 0}}} [13:40:26.137] _save_exception_stack = 0x820cb76d0 [13:40:26.137] _save_context_stack = 0x0 [13:40:26.137] _do_rethrow = false [13:40:26.137] saveTopTransactionResourceOwner = 0x836ab0cd8 [13:40:26.137] saveTopTransactionContext = 0x836a5f000 [13:40:26.137] saveActivePortal = 0x0 [13:40:26.137] saveResourceOwner = 0x836ab0cd8 [13:40:26.137] savePortalContext = 0x0 [13:40:26.137] saveMemoryContext = 0x836a5f000 [13:40:26.137] result = [13:40:26.137] nprocessed = [13:40:26.137] #16 0x00000000009466d2 in exec_simple_query (query_string=query_string@entry=0x8369b5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:40:26.137] cmdtaglen = 24 [13:40:26.137] snapshot_set = [13:40:26.137] per_parsetree_context = 0x0 [13:40:26.137] plantree_list = [13:40:26.137] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:40:26.137] format = 0 [13:40:26.137] parsetree = 0x8369b66a8 [13:40:26.137] commandTag = [13:40:26.137] cmdtagname = [13:40:26.137] querytree_list = [13:40:26.137] portal = 0x836a5b100 [13:40:26.137] receiver = 0x836a9d9e8 [13:40:26.137] parsetree_item__state = {l = 0x8369b6a18, i = 0} [13:40:26.137] msec_str = "\000\000\000\000\b", '\000' , "\363\024Kg\000\000\000\000}'e9\353\300X9" [13:40:26.137] dest = DestRemote [13:40:26.137] was_logged = [13:40:26.137] oldcontext = 0x836a5f000 [13:40:26.137] parsetree_list = 0x8369b6a18 [13:40:26.137] use_implicit_block = false [13:40:26.137] parsetree_item = 0x8369b6a30 [13:40:26.137] save_log_statement_stats = [13:40:26.137] #17 0x0000000000944343 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4805 [13:40:26.137] query_string = 0x8369b5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:40:26.137] input_message = {data = 0x8369b5100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:40:26.137] firstchar = [13:40:26.137] local_sigjmp_buf = {{_sjb = {9713654, 34909943504, 34909943464, 34909944048, 12442008, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [13:40:26.137] send_ready_for_query = false [13:40:26.137] idle_in_transaction_timeout_enabled = false [13:40:26.137] idle_session_timeout_enabled = false [13:40:26.137] #18 0x000000000093eb39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:40:26.137] bsdata = [13:40:26.137] #19 0x0000000000896d15 in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x820cb8408 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820cb8350) at ../src/backend/postmaster/launch_backend.c:274 [13:40:26.137] pid = [13:40:26.137] #20 0x000000000089ae88 in BackendStartup (client_sock=0x820cb8350) at ../src/backend/postmaster/postmaster.c:3377 [13:40:26.137] startup_data = {canAcceptConnections = CAC_OK} [13:40:26.137] bn = 0x836a9c4a8 [13:40:26.137] cac = CAC_OK [13:40:26.137] pid = [13:40:26.137] __error = [13:40:26.137] save_errno = [13:40:26.137] __error = [13:40:26.137] __error = [13:40:26.137] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [13:40:26.137] 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' , "\260\203\313 \b\000\000\000hu\233)\b\000\000\000W\000\000\000\000\000\000\000^\377\233)\b", '\000' , "\360\203\313 \b\000\000\000\264j\211\000\000\000\000\000\000\204\313 \b", '\000' }, salen = 16}} [13:40:26.137] i = 0 [13:40:26.137] now = [13:40:26.137] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 479451855, events = 5091, fd = 561273400, user_data = 0x800000001}, {pos = 561247240, events = 8, fd = 732152168, user_data = 0x820cb7c28}, {pos = 550206320, events = 8, fd = 550205904, user_data = 0x1}, {pos = 561247240, events = 8, fd = 33, user_data = 0x820cb7b60}, {pos = 1092069914, events = 5091, fd = 561217544, user_data = 0x821738408}, {pos = 561219592, events = 8, fd = 561220616, user_data = 0x82173c008}, {pos = 561234952, events = 8, fd = 561235976, user_data = 0x82173cc08}, {pos = 561238024, events = 8, fd = 561239048, user_data = 0x82173d808}, {pos = 561241096, events = 8, fd = 561242120, user_data = 0x82173e408}, {pos = 561244168, events = 8, fd = 561245192, user_data = 0x82173f008}, {pos = 561247240, events = 8, fd = -25761258, user_data = 0x821745038}, {pos = 1, events = 8, fd = 561247240, user_data = 0x82ba41478}, {pos = 550206888, events = 8, fd = 15, user_data = 0x820cb7cf0}, {pos = 550206288, events = 8, fd = 1, user_data = 0x820cb7ca8}, {pos = 33, events = 0, fd = 550206272, user_data = 0x13e341180a73}, {pos = 550206240, events = 8, fd = 2591646, user_data = 0x82173f408}, {pos = 732281539, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 561273400, events = 8, fd = 1, user_data = 0x82173f408}, {pos = 732152168, events = 8, fd = 550206504, user_data = 0x820cb79d0}, {pos = 33, events = 18, fd = 0, user_data = 0x821745a38}, {pos = 1, events = 0, fd = 561247240, user_data = 0x347}, {pos = 550206480, events = 8, fd = 1092068847, user_data = 0x82ba5bac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821745a38}, {pos = 1, events = 0, fd = 561247240, user_data = 0x8369a5000}, {pos = 1, events = 0, fd = 916083092, user_data = 0x0}, {pos = 550206432, events = 8, fd = 698086764, user_data = 0x1}, {pos = 916082688, events = 8, fd = 550206480, user_data = 0x8299be702}, {pos = 733989200, events = 8, fd = 734077304, user_data = 0x82bbfc950 }, {pos = 561247240, events = 8, fd = 550206704, user_data = 0x13e34117a3de}, {pos = 550207160, events = 8, fd = 1, user_data = 0x13e34117a25e}, {pos = 561247240, events = 8, fd = 550206488, user_data = 0x820cb7cf0}, {pos = 12264, events = 0, fd = 0, user_data = 0x13e34118d990}, {pos = 550208096, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = 102404504, events = 3664522440, fd = 0, user_data = 0x82173f408}, {pos = 12264, events = 0, fd = 732131328, user_data = 0x1db178}, {pos = 733989200, events = 8, fd = 732265848, user_data = 0x3d4b}, {pos = 734135968, events = 8, fd = 550206816, user_data = 0x82bafb915 }, {pos = 734027320, events = 8, fd = 550206752, user_data = 0x820cb8190}, {pos = 0, events = 0, fd = 550206816, user_data = 0x82bb11b61}, {pos = 1, events = 0, fd = 550207888, user_data = 0x820cb8190}, {pos = 0, events = 16777216, fd = 102404504, user_data = 0x82bc206a0 <__stack_chk_guard>}, {pos = 916555224, events = 8, fd = 0, user_data = 0x82bc05e38}, {pos = 550208096, events = 8, fd = 550207952, user_data = 0x82bb11c82}, {pos = 0, events = 0, fd = 550208256, user_data = 0x836a185d8}, {pos = 550207888, events = 8, fd = 0, user_data = 0x13e34118130a}, {pos = 732194720, events = 8, fd = 732265848, user_data = 0x820cb7e08}, {pos = 550207104, events = 8, fd = 550206984, user_data = 0x13e34118130a}, {pos = 732173192, events = 8, fd = 732265848, user_data = 0x820cb7e38}, {pos = 550207152, events = 8, fd = 550207032, user_data = 0x82ba50194}, {pos = 561247240, events = 8, fd = 732234132, user_data = 0x820cb7ea0}, {pos = 1092076602, events = 5091, fd = 550207040, user_data = 0x8299b5410 <__pthread_cleanup_pop_imp+48>}, {pos = 734056496, events = 8, fd = 1092096778, user_data = 0x82ba39858}, {pos = 732265848, events = 8, fd = 550207144, user_data = 0x820cb7f20}, {pos = 550207144, events = 8, fd = 732228876, user_data = 0x82173f408}, {pos = 732228876, events = 8, fd = 550207248, user_data = 0x13e34117c43a}, {pos = 550207288, events = 8, fd = 550207752, user_data = 0x820cb7f20}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 561270840, user_data = 0xda6c2cc800000001}, {pos = 561247240, events = 8, fd = 732173192, user_data = 0x8217447c8}, {pos = 0, events = 0, fd = 0, user_data = 0x820cb7fa8}, {pos = 550207864, events = 8, fd = 550207376, user_data = 0x13e341180ca2}, {pos = 2719988, events = 0, fd = 448139, user_data = 0xda6c2cc87c96e577}, {pos = 561270840, events = 8, fd = 1, user_data = 0x0}} [13:40:26.137] last_touch_time = 1732973788 [13:40:26.137] last_lockfile_recheck_time = 1732973788 [13:40:26.137] nevents = 1 [13:40:26.137] #22 0x0000000000899490 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820cb8968) at ../src/backend/postmaster/postmaster.c:1361 [13:40:26.137] userDoption = [13:40:26.137] listen_addr_saved = false [13:40:26.137] output_config_variable = [13:40:26.137] opt = [13:40:26.137] status = [13:40:26.137] #23 0x00000000007d159c in main (argc=4, argv=0x820cb8968) at ../src/backend/main/main.c:196 [13:40:26.137] do_check_root =