[13:24:41.035] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [13:24:41.397] dumping /tmp/cores/postgres.10917.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:24:41.534] [New LWP 101934] [13:24:41.625] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [13:24:41.625] Program terminated with signal SIGABRT, Aborted. [13:24:41.625] Sent by thr_kill() from pid 10917 and user 1003. [13:24:41.625] #0 0x000000082e3e041a in thr_kill () from /lib/libc.so.7 [13:24:41.689] [13:24:41.689] Thread 1 (LWP 101934): [13:24:41.689] #0 0x000000082e3e041a in thr_kill () from /lib/libc.so.7 [13:24:41.689] No symbol table info available. [13:24:41.689] #1 0x000000082e359e64 in raise () from /lib/libc.so.7 [13:24:41.689] No symbol table info available. [13:24:41.689] #2 0x000000082e40a6f9 in abort () from /lib/libc.so.7 [13:24:41.689] No symbol table info available. [13:24:41.689] #3 0x0000000000aa2d65 in ExceptionalCondition (conditionName=0x2ecfa9 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [13:24:41.689] No locals. [13:24:41.689] #4 0x00000000007700b9 in standard_ExecutorStart (queryDesc=0x835d7fb40, eflags=0) at ../src/backend/executor/execMain.c:193 [13:24:41.689] estate = 0x8432b1100 [13:24:41.689] oldcontext = 0x835dbc800 [13:24:41.689] #5 0x0000000000704f15 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [13:24:41.689] copied_query = [13:24:41.689] rewritten = [13:24:41.689] plan = 0x835d7f6e8 [13:24:41.689] queryDesc = 0x835d7fb40 [13:24:41.689] processed = [13:24:41.689] __error = [13:24:41.689] #6 RefreshMatViewByOid (matviewOid=28261, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [13:24:41.689] dest = [13:24:41.689] save_userid = 10 [13:24:41.689] save_sec_context = 0 [13:24:41.689] processed = 0 [13:24:41.689] matviewRel = 0x843335f18 [13:24:41.689] relowner = 10 [13:24:41.689] save_nestlevel = 2 [13:24:41.689] rule = [13:24:41.689] actions = [13:24:41.689] dataQuery = [13:24:41.689] tableSpace = [13:24:41.689] relpersistence = [13:24:41.689] OIDNewHeap = 28288 [13:24:41.689] address = [13:24:41.689] #7 0x0000000000704af6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:24:41.689] lockmode = [13:24:41.689] matviewOid = 0 [13:24:41.689] #8 0x00000000006dbbfc in ExecCreateTableAs (pstate=pstate@entry=0x835dbc900, stmt=stmt@entry=0x8432e8fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821660650) at ../src/backend/commands/createas.c:351 [13:24:41.689] refresh = 0x0 [13:24:41.689] query = 0x8432bd6d8 [13:24:41.689] into = 0x8432bda20 [13:24:41.689] jstate = 0x0 [13:24:41.689] do_refresh = false [13:24:41.689] address = [13:24:41.689] dest = [13:24:41.689] is_matview = [13:24:41.689] #9 0x000000000094d4a8 in ProcessUtilitySlow (pstate=pstate@entry=0x835dbc900, pstmt=pstmt@entry=0x835d12a68, queryString=queryString@entry=0x835d11100 "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=0x821660650) at ../src/backend/tcop/utility.c:1678 [13:24:41.689] _local_sigjmp_buf = {{_sjb = {9751769, 0, 34920071800, 34920072176, 34920071808, 12447640, 0, 35263334656, 12387199, 1, 4294967295, 34359738368}}} [13:24:41.689] _save_exception_stack = 0x821660550 [13:24:41.689] _save_context_stack = 0x0 [13:24:41.689] _do_rethrow = false [13:24:41.689] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:24:41.689] parsetree = 0x8432e8fd0 [13:24:41.689] commandCollected = false [13:24:41.689] needCleanup = false [13:24:41.689] address = [13:24:41.689] isTopLevel = [13:24:41.689] isCompleteQuery = [13:24:41.689] #10 0x000000000094be28 in standard_ProcessUtility (pstmt=0x835d12a68, queryString=0x835d11100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8432bdf08, qc=0x821660650) at ../src/backend/tcop/utility.c:1033 [13:24:41.689] isAtomicContext = false [13:24:41.689] parsetree = 0x8432e8fd0 [13:24:41.689] readonly_flags = [13:24:41.689] pstate = 0x835dbc900 [13:24:41.689] isTopLevel = [13:24:41.689] #11 0x000000000094b8b8 in ProcessUtility (pstmt=0x18e2e, queryString=0x6 , readOnlyTree=, context=775816186, params=0x0, queryEnv=0x0, dest=0x8432bdf08, qc=0x821660650) at ../src/backend/tcop/utility.c:523 [13:24:41.689] No locals. [13:24:41.689] #12 0x000000000094b3f3 in PortalRunUtility (portal=0x835de8100, pstmt=0x835d12a68, isTopLevel=, setHoldSnapshot=, dest=0x8432bdf08, qc=0x821660650) at ../src/backend/tcop/pquery.c:1152 [13:24:41.689] No locals. [13:24:41.689] #13 0x000000000094aab4 in PortalRunMulti (portal=portal@entry=0x835de8100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8432bdf08, altdest=altdest@entry=0x8432bdf08, qc=qc@entry=0x821660650) at ../src/backend/tcop/pquery.c:1316 [13:24:41.689] pstmt = 0x835d12a68 [13:24:41.689] stmtlist_item__state = {l = 0x8432bdeb8, i = 0} [13:24:41.689] active_snapshot_set = false [13:24:41.689] stmtlist_item = 0x8432bded0 [13:24:41.689] #14 0x000000000094a39b in PortalRun (portal=portal@entry=0x835de8100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8432bdf08, altdest=altdest@entry=0x8432bdf08, qc=qc@entry=0x821660650) at ../src/backend/tcop/pquery.c:787 [13:24:41.689] _local_sigjmp_buf = {{_sjb = {9741077, 35263512832, 34920072520, 34920072768, 34920072528, 12447640, 34920072784, 12413240, 12387199, 0, 35263480703, 34359738368}}} [13:24:41.689] _save_exception_stack = 0x821660700 [13:24:41.689] _save_context_stack = 0x0 [13:24:41.689] _do_rethrow = false [13:24:41.689] saveTopTransactionResourceOwner = 0x835df9a18 [13:24:41.689] saveTopTransactionContext = 0x835dec000 [13:24:41.689] saveActivePortal = 0x0 [13:24:41.689] saveResourceOwner = 0x835df9a18 [13:24:41.689] savePortalContext = 0x0 [13:24:41.689] saveMemoryContext = 0x835dec000 [13:24:41.689] result = [13:24:41.689] nprocessed = [13:24:41.689] #15 0x0000000000949229 in exec_simple_query (query_string=query_string@entry=0x835d11100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:24:41.689] cmdtaglen = 24 [13:24:41.689] snapshot_set = [13:24:41.689] per_parsetree_context = 0x0 [13:24:41.689] plantree_list = [13:24:41.689] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:24:41.689] format = 0 [13:24:41.689] parsetree = 0x835d126a8 [13:24:41.689] commandTag = [13:24:41.689] cmdtagname = [13:24:41.689] querytree_list = [13:24:41.689] portal = 0x835de8100 [13:24:41.689] receiver = 0x8432bdf08 [13:24:41.689] parsetree_item__state = {l = 0x835d12a18, i = 0} [13:24:41.689] msec_str = "\000\000\000\000\b", '\000' , "\2254\\g\000\000\000\000\234X\313.~" [13:24:41.689] dest = DestRemote [13:24:41.689] was_logged = [13:24:41.689] oldcontext = 0x835dec000 [13:24:41.689] parsetree_list = 0x835d12a18 [13:24:41.689] use_implicit_block = false [13:24:41.689] parsetree_item = 0x835d12a30 [13:24:41.689] save_log_statement_stats = [13:24:41.689] #16 0x0000000000946e93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4816 [13:24:41.689] query_string = 0x835d11100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:24:41.689] input_message = {data = 0x835d11100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:24:41.689] firstchar = [13:24:41.689] local_sigjmp_buf = {{_sjb = {9724742, 34920072960, 34920072952, 34920073504, 12456376, 1, 8192, 8388608, 34920072063, 0, 0, 1}}} [13:24:41.689] send_ready_for_query = false [13:24:41.689] idle_in_transaction_timeout_enabled = false [13:24:41.689] idle_session_timeout_enabled = false [13:24:41.689] #17 0x00000000009415e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:24:41.689] bsdata = [13:24:41.689] #18 0x0000000000899505 in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x821661438 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821661380) at ../src/backend/postmaster/launch_backend.c:274 [13:24:41.689] pid = [13:24:41.689] #19 0x000000000089d6d8 in BackendStartup (client_sock=0x821661380) at ../src/backend/postmaster/postmaster.c:3389 [13:24:41.689] startup_data = {canAcceptConnections = CAC_OK} [13:24:41.689] bn = 0x835db40f8 [13:24:41.689] cac = CAC_OK [13:24:41.689] pid = [13:24:41.689] __error = [13:24:41.689] save_errno = [13:24:41.689] __error = [13:24:41.689] __error = [13:24:41.689] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [13:24:41.689] 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' , "\340\023f!\b\000\000\000hu\212+\b\000\000\000\355\000\000\000\000\000\000\000^\377\212+\b", '\000' , " \024f!\b\000\000\000\224\222\211\000\000\000\000\0000\024f!\b", '\000' }, salen = 16}} [13:24:41.689] i = 0 [13:24:41.689] now = [13:24:41.689] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 774695619, events = 8, fd = 128686702, user_data = 0x1ce91c93dacf}, {pos = 574401080, events = 8, fd = 1, user_data = 0x8223c4408}, {pos = 774566248, events = 8, fd = 1658975461, user_data = 0x821660b48}, {pos = 560335680, events = 8, fd = 8192, user_data = 0x101000}, {pos = 903790592, events = 8, fd = 560335488, user_data = 0x82e44fa47}, {pos = 1, events = 0, fd = 1052672, user_data = 0xe8}, {pos = 0, events = 0, fd = 574361608, user_data = 0x8223c1408}, {pos = 574363656, events = 8, fd = 574364680, user_data = 0x821660b40}, {pos = 560335672, events = 8, fd = 887292048, user_data = 0x835200980}, {pos = 32, events = 0, fd = 4096, user_data = 0x821660d00}, {pos = 776252028, events = 8, fd = 560335552, user_data = 0x82e44fb22}, {pos = 560335672, events = 8, fd = 887292048, user_data = 0x20}, {pos = 4096, events = 0, fd = 560336128, user_data = 0x82e44b098}, {pos = 891289808, events = 8, fd = 887292048, user_data = 0x3000}, {pos = 8192, events = 0, fd = 887292096, user_data = 0x1000}, {pos = 4097, events = 0, fd = 8192, user_data = 0x835200980}, {pos = 560337264, events = 8, fd = 891312344, user_data = 0x0}, {pos = 0, events = 0, fd = 891340928, user_data = 0x0}, {pos = 891340800, events = 8, fd = 232, user_data = 0x1}, {pos = 891292032, events = 8, fd = 560337264, user_data = 0x20}, {pos = 8388608, events = 0, fd = 8192, user_data = 0x83520c580}, {pos = 918220760, events = 8, fd = 918220752, user_data = 0x836baefc8}, {pos = 918220736, events = 8, fd = 8417280, user_data = 0x835de0000}, {pos = 8193, events = 0, fd = 560335792, user_data = 0x821660bb0}, {pos = 1, events = 0, fd = 902828436, user_data = 0x0}, {pos = 560335888, events = 8, fd = 730527084, user_data = 0x1}, {pos = 902828032, events = 8, fd = 560335936, user_data = 0x82b8ae702}, {pos = 776403280, events = 8, fd = 776491384, user_data = 0x82e46f950 }, {pos = 574374920, events = 8, fd = 560336160, user_data = 0x1ce98f3a03de}, {pos = 574365704, events = 8, fd = 1, user_data = 0x1ce98f3a025e}, {pos = 574374920, events = 8, fd = 560335944, user_data = 0x821660d20}, {pos = 12264, events = 0, fd = 0, user_data = 0x1ce98f3b3990}, {pos = 560337552, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = 1658975461, events = 1501341624, fd = 0, user_data = 0x8223c4408}, {pos = 12264, events = 0, fd = 1658975461, user_data = 0x834e30090}, {pos = 1, events = 0, fd = 891312344, user_data = 0x835200980}, {pos = 0, events = 0, fd = 560336272, user_data = 0x82e36e915 }, {pos = 0, events = 0, fd = 560336208, user_data = 0x8216611c0}, {pos = 0, events = 0, fd = 560336272, user_data = 0x82e384b61}, {pos = 1, events = 0, fd = 560337344, user_data = 0x8216611c0}, {pos = 0, events = 16777216, fd = 1658975461, user_data = 0x82e4936a0 <__stack_chk_guard>}, {pos = 903271896, events = 8, fd = 0, user_data = 0x82e478e38}, {pos = 560337552, events = 8, fd = 560337408, user_data = 0x82e384c82}, {pos = 0, events = 0, fd = 560337712, user_data = 0x835d6d5d8}, {pos = 560337344, events = 8, fd = 560336672, user_data = 0x2000}, {pos = 8192, events = 0, fd = 903741440, user_data = 0x821660f28}, {pos = 0, events = 0, fd = 887292048, user_data = 0x1}, {pos = 560336480, events = 8, fd = 776272329, user_data = 0x82e2b4388}, {pos = 774679928, events = 8, fd = 560336504, user_data = 0x821660ef0}, {pos = 560336672, events = 8, fd = 560336664, user_data = 0x834e30090}, {pos = 891292032, events = 8, fd = 32, user_data = 0x1000}, {pos = 560337120, events = 8, fd = 776252028, user_data = 0x821660f18}, {pos = -1891994870, events = 7401, fd = 774555736, user_data = 0x82e2cad78}, {pos = 560336616, events = 8, fd = 560336736, user_data = 0x821660ee8}, {pos = 774642956, events = 8, fd = 574374920, user_data = 0x82e2c1d0c}, {pos = 560336720, events = 8, fd = -1892015046, user_data = 0x834e300c0}, {pos = 4096, events = 0, fd = 4097, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x835203238}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 574395016, user_data = 0x82e2ac858}, {pos = 574374920, events = 8, fd = 560336872, user_data = 0x8216611a8}, {pos = 560336848, events = 8, fd = -1891996510, user_data = 0x298280}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8223ca038}} [13:24:41.690] last_touch_time = 1734095999 [13:24:41.690] last_lockfile_recheck_time = 1734095999 [13:24:41.690] nevents = 1 [13:24:41.690] #21 0x000000000089bce9 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8216619a8) at ../src/backend/postmaster/postmaster.c:1374 [13:24:41.690] userDoption = [13:24:41.690] listen_addr_saved = false [13:24:41.690] output_config_variable = [13:24:41.690] opt = [13:24:41.690] status = [13:24:41.690] #22 0x00000000007d370b in main (argc=8, argv=0x8216619a8) at ../src/backend/main/main.c:224 [13:24:41.690] do_check_root = [13:24:41.690] dispatch_option = DISPATCH_POSTMASTER [13:24:41.699] [13:24:41.699] [13:24:41.699] [13:24:41.768] dumping /tmp/cores/postgres.11305.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:24:41.899] [New LWP 101933] [13:24:41.968] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [13:24:41.968] Program terminated with signal SIGABRT, Aborted. [13:24:41.968] Sent by thr_kill() from pid 11305 and user 1003. [13:24:41.968] #0 0x000000082c57541a in thr_kill () from /lib/libc.so.7 [13:24:42.004] [13:24:42.004] Thread 1 (LWP 101933): [13:24:42.004] #0 0x000000082c57541a in thr_kill () from /lib/libc.so.7 [13:24:42.004] No symbol table info available. [13:24:42.004] #1 0x000000082c4eee64 in raise () from /lib/libc.so.7 [13:24:42.004] No symbol table info available. [13:24:42.004] #2 0x000000082c59f6f9 in abort () from /lib/libc.so.7 [13:24:42.004] No symbol table info available. [13:24:42.004] #3 0x0000000000aa2d65 in ExceptionalCondition (conditionName=0x2ecfa9 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [13:24:42.004] No locals. [13:24:42.004] #4 0x00000000007700b9 in standard_ExecutorStart (queryDesc=0x83652cb40, eflags=0) at ../src/backend/executor/execMain.c:193 [13:24:42.004] estate = 0x836607100 [13:24:42.004] oldcontext = 0x83656f800 [13:24:42.004] #5 0x0000000000704f15 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [13:24:42.004] copied_query = [13:24:42.004] rewritten = [13:24:42.004] plan = 0x83652c6e8 [13:24:42.004] queryDesc = 0x83652cb40 [13:24:42.004] processed = [13:24:42.004] __error = [13:24:42.004] #6 RefreshMatViewByOid (matviewOid=28475, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [13:24:42.004] dest = [13:24:42.004] save_userid = 10 [13:24:42.004] save_sec_context = 0 [13:24:42.004] processed = 0 [13:24:42.004] matviewRel = 0x842465578 [13:24:42.004] relowner = 10 [13:24:42.004] save_nestlevel = 2 [13:24:42.004] rule = [13:24:42.004] actions = [13:24:42.004] dataQuery = [13:24:42.004] tableSpace = [13:24:42.004] relpersistence = [13:24:42.004] OIDNewHeap = 28484 [13:24:42.004] address = [13:24:42.004] #7 0x0000000000704af6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:24:42.004] lockmode = [13:24:42.004] matviewOid = 0 [13:24:42.004] #8 0x00000000006dbbfc in ExecCreateTableAs (pstate=pstate@entry=0x83656f900, stmt=stmt@entry=0x836538fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8211eb400) at ../src/backend/commands/createas.c:351 [13:24:42.004] refresh = 0x0 [13:24:42.004] query = 0x8423e7d58 [13:24:42.004] into = 0x8423e80a0 [13:24:42.004] jstate = 0x0 [13:24:42.004] do_refresh = false [13:24:42.004] address = [13:24:42.004] dest = [13:24:42.004] is_matview = [13:24:42.004] #9 0x000000000094d4a8 in ProcessUtilitySlow (pstate=pstate@entry=0x83656f900, pstmt=pstmt@entry=0x836459a68, queryString=queryString@entry=0x836458100 "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=0x8211eb400) at ../src/backend/tcop/utility.c:1678 [13:24:42.004] _local_sigjmp_buf = {{_sjb = {9751769, 0, 34915397672, 34915398048, 34915397680, 12447640, 0, 35271407872, 12387199, 1, 4294967295, 34359738368}}} [13:24:42.004] _save_exception_stack = 0x8211eb300 [13:24:42.004] _save_context_stack = 0x0 [13:24:42.004] _do_rethrow = false [13:24:42.004] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:24:42.004] parsetree = 0x836538fd0 [13:24:42.004] commandCollected = false [13:24:42.004] needCleanup = false [13:24:42.004] address = [13:24:42.004] isTopLevel = [13:24:42.004] isCompleteQuery = [13:24:42.004] #10 0x000000000094be28 in standard_ProcessUtility (pstmt=0x836459a68, queryString=0x836458100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8423e8588, qc=0x8211eb400) at ../src/backend/tcop/utility.c:1033 [13:24:42.004] isAtomicContext = false [13:24:42.004] parsetree = 0x836538fd0 [13:24:42.004] readonly_flags = [13:24:42.004] pstate = 0x83656f900 [13:24:42.004] isTopLevel = [13:24:42.004] #11 0x000000000094b8b8 in ProcessUtility (pstmt=0x18e2d, queryString=0x6 , readOnlyTree=, context=743920634, params=0x0, queryEnv=0x0, dest=0x8423e8588, qc=0x8211eb400) at ../src/backend/tcop/utility.c:523 [13:24:42.004] No locals. [13:24:42.004] #12 0x000000000094b3f3 in PortalRunUtility (portal=0x8364fe100, pstmt=0x836459a68, isTopLevel=, setHoldSnapshot=, dest=0x8423e8588, qc=0x8211eb400) at ../src/backend/tcop/pquery.c:1152 [13:24:42.004] No locals. [13:24:42.004] #13 0x000000000094aab4 in PortalRunMulti (portal=portal@entry=0x8364fe100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8423e8588, altdest=altdest@entry=0x8423e8588, qc=qc@entry=0x8211eb400) at ../src/backend/tcop/pquery.c:1316 [13:24:42.004] pstmt = 0x836459a68 [13:24:42.004] stmtlist_item__state = {l = 0x8423e8538, i = 0} [13:24:42.004] active_snapshot_set = false [13:24:42.004] stmtlist_item = 0x8423e8550 [13:24:42.004] #14 0x000000000094a39b in PortalRun (portal=portal@entry=0x8364fe100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8423e8588, altdest=altdest@entry=0x8423e8588, qc=qc@entry=0x8211eb400) at ../src/backend/tcop/pquery.c:787 [13:24:42.004] _local_sigjmp_buf = {{_sjb = {9741077, 35270942976, 34915398392, 34915398640, 34915398400, 12447640, 34915398656, 12413240, 12387199, 0, 35270951807, 34359738368}}} [13:24:42.004] _save_exception_stack = 0x8211eb4b0 [13:24:42.004] _save_context_stack = 0x0 [13:24:42.004] _do_rethrow = false [13:24:42.004] saveTopTransactionResourceOwner = 0x83654dd98 [13:24:42.004] saveTopTransactionContext = 0x836502000 [13:24:42.004] saveActivePortal = 0x0 [13:24:42.004] saveResourceOwner = 0x83654dd98 [13:24:42.004] savePortalContext = 0x0 [13:24:42.004] saveMemoryContext = 0x836502000 [13:24:42.004] result = [13:24:42.004] nprocessed = [13:24:42.004] #15 0x0000000000949229 in exec_simple_query (query_string=query_string@entry=0x836458100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:24:42.004] cmdtaglen = 24 [13:24:42.004] snapshot_set = [13:24:42.004] per_parsetree_context = 0x0 [13:24:42.004] plantree_list = [13:24:42.004] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:24:42.004] format = 0 [13:24:42.004] parsetree = 0x8364596a8 [13:24:42.004] commandTag = [13:24:42.004] cmdtagname = [13:24:42.004] querytree_list = [13:24:42.004] portal = 0x8364fe100 [13:24:42.004] receiver = 0x8423e8588 [13:24:42.004] parsetree_item__state = {l = 0x836459a18, i = 0} [13:24:42.004] msec_str = "\000\000\000\000\b", '\000' , "\2304\\g\000\000\000\000\234\371\177w\330\004G\216" [13:24:42.004] dest = DestRemote [13:24:42.004] was_logged = [13:24:42.004] oldcontext = 0x836502000 [13:24:42.004] parsetree_list = 0x836459a18 [13:24:42.004] use_implicit_block = false [13:24:42.004] parsetree_item = 0x836459a30 [13:24:42.004] save_log_statement_stats = [13:24:42.004] #16 0x0000000000946e93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4816 [13:24:42.004] query_string = 0x836458100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:24:42.004] input_message = {data = 0x836458100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:24:42.004] firstchar = [13:24:42.004] local_sigjmp_buf = {{_sjb = {9724742, 34915398832, 34915398824, 34915399376, 12456376, 1, 8192, 8388608, 34915353471, 0, 0, 1}}} [13:24:42.004] send_ready_for_query = false [13:24:42.004] idle_in_transaction_timeout_enabled = false [13:24:42.004] idle_session_timeout_enabled = false [13:24:42.004] #17 0x00000000009415e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:24:42.004] bsdata = [13:24:42.004] #18 0x0000000000899505 in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x8211ec1e8 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211ec130) at ../src/backend/postmaster/launch_backend.c:274 [13:24:42.004] pid = [13:24:42.004] #19 0x000000000089d6d8 in BackendStartup (client_sock=0x8211ec130) at ../src/backend/postmaster/postmaster.c:3389 [13:24:42.004] startup_data = {canAcceptConnections = CAC_OK} [13:24:42.004] bn = 0x83651c1e8 [13:24:42.004] cac = CAC_OK [13:24:42.004] pid = [13:24:42.004] __error = [13:24:42.004] save_errno = [13:24:42.004] __error = [13:24:42.004] __error = [13:24:42.004] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [13:24:42.004] 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\301\036!\b\000\000\000hE\231-\b\000\000\000\331\000\000\000\000\000\000\000^ϙ-\b", '\000' , "\320\301\036!\b\000\000\000\224\222\211\000\000\000\000\000\340\301\036!\b", '\000' }, salen = 16}} [13:24:42.004] i = 0 [13:24:42.004] now = [13:24:42.004] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 742800067, events = 8, fd = 128686702, user_data = 0x1c671c93dacf}, {pos = 569727544, events = 8, fd = 1, user_data = 0x821f4f408}, {pos = 742670696, events = 8, fd = 555661832, user_data = 0x8211eb950}, {pos = 555661248, events = 8, fd = 1, user_data = 0x821f4f408}, {pos = 32, events = 0, fd = 555661632, user_data = 0x1c673e128a1a}, {pos = 569671688, events = 8, fd = 569672712, user_data = 0x821f48808}, {pos = 569674760, events = 8, fd = 569688072, user_data = 0x821f4c408}, {pos = 569690120, events = 8, fd = 569691144, user_data = 0x821f4d008}, {pos = 569693192, events = 8, fd = 569694216, user_data = 0x821f4dc08}, {pos = 569696264, events = 8, fd = 569697288, user_data = 0x821f4e808}, {pos = 569699336, events = 8, fd = 569700360, user_data = 0x821f4f408}, {pos = -25761258, events = 8, fd = 569724984, user_data = 0x1}, {pos = 569701384, events = 8, fd = 742691960, user_data = 0x8211ebb88}, {pos = 2841949, events = 0, fd = 555662032, user_data = 0x8211eb940}, {pos = 1, events = 0, fd = 555661960, user_data = 0x20}, {pos = 555661616, events = 8, fd = 1041427059, user_data = 0x821f4f408}, {pos = 742800067, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 569727544, events = 8, fd = 1, user_data = 0x821f4f408}, {pos = 742670696, events = 8, fd = 555661832, user_data = 0x8211eb7c0}, {pos = 32, events = 18, fd = 0, user_data = 0x821f55a38}, {pos = 1, events = 0, fd = 569701384, user_data = 0x347}, {pos = 555661808, events = 8, fd = 1041401327, user_data = 0x82c463ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821f55a38}, {pos = 1, events = 0, fd = 569701384, user_data = 0x836448000}, {pos = 1, events = 0, fd = 910459284, user_data = 0x0}, {pos = 555661760, events = 8, fd = 765052268, user_data = 0x1}, {pos = 910458880, events = 8, fd = 555661808, user_data = 0x82d99b702}, {pos = 744507728, events = 8, fd = 744595832, user_data = 0x82c604950 }, {pos = 569701384, events = 8, fd = 555662032, user_data = 0x1c673e1283de}, {pos = 569692168, events = 8, fd = 1, user_data = 0x1c673e12825e}, {pos = 569701384, events = 8, fd = 555661816, user_data = 0x8211ebad0}, {pos = 12264, events = 0, fd = 0, user_data = 0x1c673e13b990}, {pos = 555663424, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = 411575922, events = 2743600691, fd = 0, user_data = 0x821f4f408}, {pos = 12264, events = 0, fd = 742649856, user_data = 0x1db178}, {pos = 744507728, events = 8, fd = 742784376, user_data = 0x3d4b}, {pos = 744654496, events = 8, fd = 555662144, user_data = 0x82c503915 }, {pos = 744545848, events = 8, fd = 555662080, user_data = 0x8211ebf70}, {pos = 0, events = 0, fd = 555662144, user_data = 0x82c519b61}, {pos = 1, events = 0, fd = 555663216, user_data = 0x8211ebf70}, {pos = 0, events = 16777216, fd = 411575922, user_data = 0x82c6286a0 <__stack_chk_guard>}, {pos = 910960088, events = 8, fd = 0, user_data = 0x82c60de38}, {pos = 555663424, events = 8, fd = 555663280, user_data = 0x82c519c82}, {pos = 0, events = 0, fd = 555663584, user_data = 0x8364c25d8}, {pos = 555663216, events = 8, fd = 0, user_data = 0x0}, {pos = 411575922, events = 2743600691, fd = 1041429258, user_data = 0x82c44e7a0}, {pos = 742784376, events = 8, fd = 555662328, user_data = 0x8211ebc70}, {pos = 555662328, events = 8, fd = 1041429258, user_data = 0x82c449388}, {pos = 742784376, events = 8, fd = 555662376, user_data = 0x8211ebca0}, {pos = 555662376, events = 8, fd = 742752660, user_data = 0x821f4f408}, {pos = 742752660, events = 8, fd = 555662480, user_data = 0x1c673e12a43a}, {pos = 744575024, events = 8, fd = 1, user_data = 0x8211ebcc0}, {pos = 1041429258, events = 7271, fd = 742660184, user_data = 0x82c45fd78}, {pos = 555662488, events = 8, fd = 555662608, user_data = 0x8211ebc98}, {pos = 742747404, events = 8, fd = 569701384, user_data = 0x82c456d0c}, {pos = 555662592, events = 8, fd = 1041409082, user_data = 0x8211ebd28}, {pos = 555663080, events = 8, fd = 555662608, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa3880633526629ce}, {pos = 569724984, events = 8, fd = 1, user_data = 0x821f4f408}, {pos = 742691720, events = 8, fd = 569721480, user_data = 0x82c441858}, {pos = 569701384, events = 8, fd = 555662744, user_data = 0x8211ebf58}, {pos = 555662720, events = 8, fd = 1041427618, user_data = 0x298280}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821f55038}} [13:24:42.005] last_touch_time = 1734095999 [13:24:42.005] last_lockfile_recheck_time = 1734095999 [13:24:42.005] nevents = 1 [13:24:42.005] #21 0x000000000089bce9 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8211ec750) at ../src/backend/postmaster/postmaster.c:1374 [13:24:42.005] userDoption = [13:24:42.005] listen_addr_saved = false [13:24:42.005] output_config_variable = [13:24:42.005] opt = [13:24:42.005] status = [13:24:42.005] #22 0x00000000007d370b in main (argc=4, argv=0x8211ec750) at ../src/backend/main/main.c:224 [13:24:42.005] do_check_root = [13:24:42.005] dispatch_option = DISPATCH_POSTMASTER [13:24:42.017] [13:24:42.017] [13:24:42.017] [13:24:42.088] dumping /tmp/cores/postgres.17703.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:24:42.218] [New LWP 101885] [13:24:42.292] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [13:24:42.292] Program terminated with signal SIGABRT, Aborted. [13:24:42.292] Sent by thr_kill() from pid 17703 and user 1003. [13:24:42.292] #0 0x000000082b49d41a in thr_kill () from /lib/libc.so.7 [13:24:42.337] [13:24:42.337] Thread 1 (LWP 101885): [13:24:42.337] #0 0x000000082b49d41a in thr_kill () from /lib/libc.so.7 [13:24:42.337] No symbol table info available. [13:24:42.337] #1 0x000000082b416e64 in raise () from /lib/libc.so.7 [13:24:42.337] No symbol table info available. [13:24:42.337] #2 0x000000082b4c76f9 in abort () from /lib/libc.so.7 [13:24:42.337] No symbol table info available. [13:24:42.337] #3 0x0000000000aa2d65 in ExceptionalCondition (conditionName=0x2ecfa9 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [13:24:42.337] No locals. [13:24:42.337] #4 0x00000000007700b9 in standard_ExecutorStart (queryDesc=0x8370feb40, eflags=0) at ../src/backend/executor/execMain.c:193 [13:24:42.337] estate = 0x83a1ca100 [13:24:42.337] oldcontext = 0x8371d1400 [13:24:42.337] #5 0x000000083945a9c2 in pgss_ExecutorStart (queryDesc=0x8370feb40, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [13:24:42.337] No locals. [13:24:42.337] #6 0x0000000000704f15 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [13:24:42.337] copied_query = [13:24:42.337] rewritten = [13:24:42.337] plan = 0x8370fe6e8 [13:24:42.337] queryDesc = 0x8370feb40 [13:24:42.337] processed = [13:24:42.337] __error = [13:24:42.337] #7 RefreshMatViewByOid (matviewOid=28487, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [13:24:42.337] dest = [13:24:42.337] save_userid = 10 [13:24:42.337] save_sec_context = 0 [13:24:42.337] processed = 0 [13:24:42.337] matviewRel = 0x83a2190b8 [13:24:42.337] relowner = 10 [13:24:42.337] save_nestlevel = 2 [13:24:42.337] rule = [13:24:42.337] actions = [13:24:42.337] dataQuery = [13:24:42.337] tableSpace = [13:24:42.337] relpersistence = [13:24:42.337] OIDNewHeap = 28497 [13:24:42.337] address = [13:24:42.337] #8 0x0000000000704af6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [13:24:42.337] lockmode = [13:24:42.337] matviewOid = 0 [13:24:42.337] #9 0x00000000006dbbfc in ExecCreateTableAs (pstate=pstate@entry=0x8371d1500, stmt=stmt@entry=0x83718dfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82183f120) at ../src/backend/commands/createas.c:351 [13:24:42.337] refresh = 0x0 [13:24:42.337] query = 0x83a116bc8 [13:24:42.337] into = 0x83718df40 [13:24:42.337] jstate = 0x0 [13:24:42.337] do_refresh = false [13:24:42.337] address = [13:24:42.337] dest = [13:24:42.337] is_matview = [13:24:42.337] #10 0x000000000094d4a8 in ProcessUtilitySlow (pstate=pstate@entry=0x8371d1500, pstmt=pstmt@entry=0x83718de30, queryString=queryString@entry=0x837027100 "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=0x82183f120) at ../src/backend/tcop/utility.c:1678 [13:24:42.337] _local_sigjmp_buf = {{_sjb = {9751769, 0, 34922032008, 34922032384, 34922032016, 12447640, 0, 35284391168, 895, 1, 34922032140, 0}}} [13:24:42.337] _save_exception_stack = 0x82183ee10 [13:24:42.337] _save_context_stack = 0x0 [13:24:42.337] _do_rethrow = false [13:24:42.337] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [13:24:42.337] parsetree = 0x83718dfd0 [13:24:42.337] commandCollected = false [13:24:42.337] needCleanup = false [13:24:42.337] address = [13:24:42.337] isTopLevel = [13:24:42.337] isCompleteQuery = [13:24:42.337] #11 0x000000000094be28 in standard_ProcessUtility (pstmt=0x83718de30, queryString=queryString@entry=0x837027100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83a117368, qc=0x82183f120) at ../src/backend/tcop/utility.c:1033 [13:24:42.337] isAtomicContext = false [13:24:42.337] parsetree = 0x83718dfd0 [13:24:42.337] readonly_flags = [13:24:42.337] pstate = 0x8371d1500 [13:24:42.337] isTopLevel = [13:24:42.337] #12 0x000000083945af6e in pgss_ProcessUtility (pstmt=0x83718de30, queryString=0x837027100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83a117368, qc=0x82183f120) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [13:24:42.337] _local_sigjmp_buf = {{_sjb = {35320606375, 34922032656, 34922032520, 34922032976, 35284114992, 0, 12447640, 34922033184, 895, 1, 34922032772, 34359738368}}} [13:24:42.337] _save_exception_stack = 0x82183f020 [13:24:42.337] _save_context_stack = 0x0 [13:24:42.337] _do_rethrow = false [13:24:42.337] bufusage = {shared_blks_hit = 35320606375, shared_blks_read = 34922032656, shared_blks_dirtied = 34922032520, shared_blks_written = 34922032976, local_blks_hit = 35284114992, local_blks_read = 0, local_blks_dirtied = 12447640, local_blks_written = 34922033184, temp_blks_read = 895, temp_blks_written = 1, shared_blk_read_time = {ticks = 34922032772}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4241103326153439360}, local_blk_write_time = {ticks = 12456664}, temp_blk_read_time = {ticks = 35351382016}, temp_blk_write_time = {ticks = 12409184}} [13:24:42.337] walusage_start = {wal_records = 8973, wal_fpi = 132, wal_bytes = 1297128} [13:24:42.337] duration = [13:24:42.337] bufusage_start = {shared_blks_hit = 155144, shared_blks_read = 9499, shared_blks_dirtied = 2709, shared_blks_written = 2338, 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:24:42.337] walusage = {wal_records = 0, wal_fpi = 549755813888, wal_bytes = 5214005574305165064} [13:24:42.337] start = {ticks = -186670985989} [13:24:42.337] rows = [13:24:42.337] saved_queryId = 6041762721901209185 [13:24:42.337] parsetree = [13:24:42.337] saved_stmt_location = 0 [13:24:42.337] saved_stmt_len = 69 [13:24:42.337] enabled = [13:24:42.337] #13 0x000000000094b3f3 in PortalRunUtility (portal=0x8370cd100, pstmt=0x83718de30, isTopLevel=, setHoldSnapshot=, dest=0x83a117368, qc=0x82183f120) at ../src/backend/tcop/pquery.c:1152 [13:24:42.337] No locals. [13:24:42.337] #14 0x000000000094aab4 in PortalRunMulti (portal=portal@entry=0x8370cd100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83a117368, altdest=altdest@entry=0x83a117368, qc=qc@entry=0x82183f120) at ../src/backend/tcop/pquery.c:1316 [13:24:42.337] pstmt = 0x83718de30 [13:24:42.337] stmtlist_item__state = {l = 0x83a117318, i = 0} [13:24:42.337] active_snapshot_set = false [13:24:42.337] stmtlist_item = 0x83a117330 [13:24:42.337] #15 0x000000000094a39b in PortalRun (portal=portal@entry=0x8370cd100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x83a117368, altdest=altdest@entry=0x83a117368, qc=qc@entry=0x82183f120) at ../src/backend/tcop/pquery.c:787 [13:24:42.337] _local_sigjmp_buf = {{_sjb = {9741077, 35283325184, 34922033176, 34922033424, 34922033184, 12447640, 34922033440, 12413240, 12387199, 0, 35283272575, 34359738368}}} [13:24:42.337] _save_exception_stack = 0x82183f1d0 [13:24:42.337] _save_context_stack = 0x0 [13:24:42.337] _do_rethrow = false [13:24:42.337] saveTopTransactionResourceOwner = 0x837122198 [13:24:42.337] saveTopTransactionContext = 0x8370e6000 [13:24:42.337] saveActivePortal = 0x0 [13:24:42.337] saveResourceOwner = 0x837122198 [13:24:42.337] savePortalContext = 0x0 [13:24:42.337] saveMemoryContext = 0x8370e6000 [13:24:42.337] result = [13:24:42.337] nprocessed = [13:24:42.337] #16 0x0000000000949229 in exec_simple_query (query_string=query_string@entry=0x837027100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [13:24:42.337] cmdtaglen = 24 [13:24:42.337] snapshot_set = [13:24:42.337] per_parsetree_context = 0x0 [13:24:42.337] plantree_list = [13:24:42.337] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:24:42.337] format = 0 [13:24:42.337] parsetree = 0x8370286a8 [13:24:42.337] commandTag = [13:24:42.337] cmdtagname = [13:24:42.337] querytree_list = [13:24:42.337] portal = 0x8370cd100 [13:24:42.337] receiver = 0x83a117368 [13:24:42.337] parsetree_item__state = {l = 0x837028a18, i = 0} [13:24:42.337] msec_str = "\000\000\000\000\b", '\000' , "\2754\\g\000\000\000\000\\\233b\207\265\202\210", [13:24:42.337] dest = DestRemote [13:24:42.337] was_logged = [13:24:42.337] oldcontext = 0x8370e6000 [13:24:42.337] parsetree_list = 0x837028a18 [13:24:42.337] use_implicit_block = false [13:24:42.337] parsetree_item = 0x837028a30 [13:24:42.337] save_log_statement_stats = [13:24:42.337] #17 0x0000000000946e93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4816 [13:24:42.337] query_string = 0x837027100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [13:24:42.337] input_message = {data = 0x837027100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [13:24:42.337] firstchar = [13:24:42.337] local_sigjmp_buf = {{_sjb = {9724742, 34922033616, 34922033608, 34922034160, 12456376, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [13:24:42.337] send_ready_for_query = false [13:24:42.337] idle_in_transaction_timeout_enabled = false [13:24:42.337] idle_session_timeout_enabled = false [13:24:42.337] #18 0x00000000009415e9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:24:42.337] bsdata = [13:24:42.337] #19 0x0000000000899505 in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x82183ff08 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82183fe50) at ../src/backend/postmaster/launch_backend.c:274 [13:24:42.337] pid = [13:24:42.337] #20 0x000000000089d6d8 in BackendStartup (client_sock=0x82183fe50) at ../src/backend/postmaster/postmaster.c:3389 [13:24:42.337] startup_data = {canAcceptConnections = CAC_OK} [13:24:42.337] bn = 0x83710e928 [13:24:42.337] cac = CAC_OK [13:24:42.337] pid = [13:24:42.337] __error = [13:24:42.337] save_errno = [13:24:42.337] __error = [13:24:42.337] __error = [13:24:42.337] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [13:24:42.337] 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\376\203!\b\000\000\000h\245\364*\b\000\000\000W\000\000\000\000\000\000\000^/\365*\b", '\000' , "\360\376\203!\b\000\000\000\224\222\211\000\000\000\000\000\000\377\203!\b", '\000' }, salen = 16}} [13:24:42.337] i = 0 [13:24:42.337] now = [13:24:42.337] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 479451855, events = 1076, fd = 578255416, user_data = 0x800000001}, {pos = 578229256, events = 8, fd = 725008744, user_data = 0x82183f728}, {pos = 562296432, events = 8, fd = 562296016, user_data = 0x1}, {pos = 578229256, events = 8, fd = 33, user_data = 0x82183f660}, {pos = -1264592358, events = 1076, fd = 578199560, user_data = 0x82276a408}, {pos = 578201608, events = 8, fd = 578202632, user_data = 0x82276e008}, {pos = 578216968, events = 8, fd = 578217992, user_data = 0x82276ec08}, {pos = 578220040, events = 8, fd = 578221064, user_data = 0x82276f808}, {pos = 578223112, events = 8, fd = 578224136, user_data = 0x822770408}, {pos = 578226184, events = 8, fd = 578227208, user_data = 0x822771008}, {pos = 578229256, events = 8, fd = -25761258, user_data = 0x822777038}, {pos = 1, events = 8, fd = 578229256, user_data = 0x82b371478}, {pos = 562297000, events = 8, fd = 15, user_data = 0x82183f7f0}, {pos = 562296400, events = 8, fd = 1, user_data = 0x82183f7a8}, {pos = 33, events = 0, fd = 562296384, user_data = 0x434b4a03a73}, {pos = 562296352, events = 8, fd = 2591958, user_data = 0x822771408}, {pos = 725138115, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 578255416, events = 8, fd = 1, user_data = 0x822771408}, {pos = 725008744, events = 8, fd = 562296616, user_data = 0x82183f4d0}, {pos = 33, events = 18, fd = 0, user_data = 0x822777a38}, {pos = 1, events = 0, fd = 578229256, user_data = 0x347}, {pos = 562296592, events = 8, fd = -1264593425, user_data = 0x82b38bac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822777a38}, {pos = 1, events = 0, fd = 578229256, user_data = 0x837017000}, {pos = 1, events = 0, fd = 922841492, user_data = 0x0}, {pos = 562296544, events = 8, fd = 720708972, user_data = 0x1}, {pos = 922841088, events = 8, fd = 562296592, user_data = 0x82af51702}, {pos = 726845776, events = 8, fd = 726933880, user_data = 0x82b52c950 }, {pos = 578229256, events = 8, fd = 562296816, user_data = 0x434b49fd3de}, {pos = 562297272, events = 8, fd = 1, user_data = 0x434b49fd25e}, {pos = 578229256, events = 8, fd = 562296600, user_data = 0x82183f7f0}, {pos = 12264, events = 0, fd = 0, user_data = 0x434b4a10990}, {pos = 562298208, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = -513954040, events = 1213980273, fd = 0, user_data = 0x822771408}, {pos = 12264, events = 0, fd = 724987904, user_data = 0x1db178}, {pos = 726845776, events = 8, fd = 725122424, user_data = 0x3d4b}, {pos = 726992544, events = 8, fd = 562296928, user_data = 0x82b42b915 }, {pos = 726883896, events = 8, fd = 562296864, user_data = 0x82183fc90}, {pos = 0, events = 0, fd = 562296928, user_data = 0x82b441b61}, {pos = 1, events = 0, fd = 562298000, user_data = 0x82183fc90}, {pos = 0, events = 16777216, fd = -513954040, user_data = 0x82b5506a0 <__stack_chk_guard>}, {pos = 923313624, events = 8, fd = 0, user_data = 0x82b535e38}, {pos = 562298208, events = 8, fd = 562298064, user_data = 0x82b441c82}, {pos = 0, events = 0, fd = 562298368, user_data = 0x83708a5d8}, {pos = 562298000, events = 8, fd = 0, user_data = 0x434b4a0430a}, {pos = 725051296, events = 8, fd = 725122424, user_data = 0x82183f908}, {pos = 562297216, events = 8, fd = 562297096, user_data = 0x434b4a0430a}, {pos = 725029768, events = 8, fd = 725122424, user_data = 0x82183f938}, {pos = 562297264, events = 8, fd = 562297144, user_data = 0x82b380194}, {pos = 578229256, events = 8, fd = 725090708, user_data = 0x82183f9a0}, {pos = -1264585670, events = 1076, fd = 562297152, user_data = 0x82af48410 <__pthread_cleanup_pop_imp+48>}, {pos = 726913072, events = 8, fd = -1264565494, user_data = 0x82b369858}, {pos = 725122424, events = 8, fd = 562297256, user_data = 0x82183fa20}, {pos = 562297256, events = 8, fd = 725085452, user_data = 0x822771408}, {pos = 725085452, events = 8, fd = 562297360, user_data = 0x434b49ff43a}, {pos = 562297400, events = 8, fd = 562297864, user_data = 0x82183fa20}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 578252856, user_data = 0x485bde7100000001}, {pos = 578229256, events = 8, fd = 725029768, user_data = 0x8227767c8}, {pos = 0, events = 0, fd = 0, user_data = 0x82183faa8}, {pos = 562297976, events = 8, fd = 562297488, user_data = 0x434b4a03ca2}, {pos = 2720384, events = 0, fd = 448139, user_data = 0x485bde717c96e577}, {pos = 578252856, events = 8, fd = 1, user_data = 0x0}} [13:24:42.337] last_touch_time = 1734096035 [13:24:42.337] last_lockfile_recheck_time = 1734096035 [13:24:42.337] nevents = 1 [13:24:42.337] #22 0x000000000089bce9 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821840478) at ../src/backend/postmaster/postmaster.c:1374 [13:24:42.337] userDoption = [13:24:42.337] listen_addr_saved = false [13:24:42.337] output_config_variable = [13:24:42.337] opt = [13:24:42.337] status = [13:24:42.337] #23 0x00000000007d370b in main (argc=4, argv=0x821840478) at ../src/backend/main/main.c:224 [13:24:42.337] do_check_root = [13:24:42.337] dispatch_option = DISPATCH_POSTMASTER