[06:36:26.606] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [06:36:27.045] dumping /tmp/cores/postgres.10912.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [06:36:27.202] [New LWP 101840] [06:36:27.316] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [06:36:27.316] Program terminated with signal SIGABRT, Aborted. [06:36:27.316] Sent by thr_kill() from pid 10912 and user 1003. [06:36:27.316] #0 0x000000082eb1441a in thr_kill () from /lib/libc.so.7 [06:36:27.392] [06:36:27.392] Thread 1 (LWP 101840): [06:36:27.392] #0 0x000000082eb1441a in thr_kill () from /lib/libc.so.7 [06:36:27.392] No symbol table info available. [06:36:27.392] #1 0x000000082ea8de64 in raise () from /lib/libc.so.7 [06:36:27.392] No symbol table info available. [06:36:27.392] #2 0x000000082eb3e6f9 in abort () from /lib/libc.so.7 [06:36:27.392] No symbol table info available. [06:36:27.392] #3 0x0000000000a95e95 in ExceptionalCondition (conditionName=0x2e7bc8 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:36:27.392] No locals. [06:36:27.392] #4 0x0000000000766869 in standard_ExecutorStart (queryDesc=0x838d65088, eflags=0) at ../src/backend/executor/execMain.c:194 [06:36:27.392] estate = 0x838e1f100 [06:36:27.392] oldcontext = 0x838e61800 [06:36:27.392] #5 0x00000000006fd4f5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [06:36:27.392] copied_query = [06:36:27.392] rewritten = [06:36:27.392] plan = 0x838dc9bd8 [06:36:27.392] queryDesc = 0x838d65088 [06:36:27.392] processed = [06:36:27.392] __error = [06:36:27.392] #6 RefreshMatViewByOid (matviewOid=27378, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [06:36:27.392] dest = [06:36:27.392] save_userid = 10 [06:36:27.392] save_sec_context = 0 [06:36:27.392] processed = 0 [06:36:27.392] matviewRel = 0x843eba438 [06:36:27.392] relowner = 10 [06:36:27.392] save_nestlevel = 2 [06:36:27.392] rule = [06:36:27.392] actions = [06:36:27.392] dataQuery = [06:36:27.392] tableSpace = [06:36:27.392] relpersistence = [06:36:27.392] OIDNewHeap = 27387 [06:36:27.392] address = [06:36:27.392] #7 0x00000000006fd0d6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:36:27.392] lockmode = [06:36:27.392] matviewOid = 0 [06:36:27.392] #8 0x00000000006d41ec in ExecCreateTableAs (pstate=pstate@entry=0x838e61900, stmt=stmt@entry=0x838d80fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8213313e0) at ../src/backend/commands/createas.c:351 [06:36:27.392] refresh = 0x0 [06:36:27.392] query = 0x843fe7d18 [06:36:27.392] into = 0x843fe8060 [06:36:27.392] jstate = 0x0 [06:36:27.392] do_refresh = false [06:36:27.392] address = [06:36:27.392] dest = [06:36:27.392] is_matview = [06:36:27.392] #9 0x0000000000941b68 in ProcessUtilitySlow (pstate=pstate@entry=0x838e61900, pstmt=pstmt@entry=0x838cc5a68, queryString=queryString@entry=0x838cc4100 "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=0x8213313e0) at ../src/backend/tcop/utility.c:1678 [06:36:27.392] _local_sigjmp_buf = {{_sjb = {9704345, 0, 34916732936, 34916733312, 34916732944, 12391752, 0, 35314342144, 4294902655, 34916733052, 34916733088, 0}}} [06:36:27.392] _save_exception_stack = 0x8213312e0 [06:36:27.392] _save_context_stack = 0x0 [06:36:27.392] _do_rethrow = false [06:36:27.392] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:36:27.392] parsetree = 0x838d80fd0 [06:36:27.392] commandCollected = false [06:36:27.392] needCleanup = false [06:36:27.392] address = [06:36:27.392] isTopLevel = [06:36:27.392] isCompleteQuery = [06:36:27.392] #10 0x00000000009404e8 in standard_ProcessUtility (pstmt=0x838cc5a68, queryString=0x838cc4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x843fe8548, qc=0x8213313e0) at ../src/backend/tcop/utility.c:1033 [06:36:27.392] isAtomicContext = false [06:36:27.392] parsetree = 0x838d80fd0 [06:36:27.392] readonly_flags = [06:36:27.392] pstate = 0x838e61900 [06:36:27.392] isTopLevel = [06:36:27.392] #11 0x000000000093ff78 in ProcessUtility (pstmt=0x18dd0, queryString=0x6 , readOnlyTree=, context=783369210, params=0x0, queryEnv=0x0, dest=0x843fe8548, qc=0x8213313e0) at ../src/backend/tcop/utility.c:523 [06:36:27.392] No locals. [06:36:27.392] #12 0x000000000093fab3 in PortalRunUtility (portal=0x838d9b100, pstmt=0x838cc5a68, isTopLevel=, setHoldSnapshot=, dest=0x843fe8548, qc=0x8213313e0) at ../src/backend/tcop/pquery.c:1158 [06:36:27.392] No locals. [06:36:27.392] #13 0x000000000093f144 in PortalRunMulti (portal=portal@entry=0x838d9b100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x843fe8548, altdest=altdest@entry=0x843fe8548, qc=0x8213313e0) at ../src/backend/tcop/pquery.c:1322 [06:36:27.392] pstmt = 0x838cc5a68 [06:36:27.392] stmtlist_item__state = {l = 0x843fe84f8, i = 0} [06:36:27.392] active_snapshot_set = false [06:36:27.392] stmtlist_item = 0x843fe8510 [06:36:27.392] #14 0x000000000093ea13 in PortalRun (portal=portal@entry=0x838d9b100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x843fe8548, altdest=altdest@entry=0x843fe8548, qc=0x8213313e0) at ../src/backend/tcop/pquery.c:791 [06:36:27.392] _local_sigjmp_buf = {{_sjb = {9693581, 35313529088, 34916733656, 34916733888, 34916733664, 35313545216, 12358360, 12391752, 35313484671, 35313415568, 4294967984, 0}}} [06:36:27.392] _save_exception_stack = 0x8213314b0 [06:36:27.392] _save_context_stack = 0x0 [06:36:27.392] _do_rethrow = false [06:36:27.392] saveTopTransactionResourceOwner = 0x838dac1d8 [06:36:27.392] saveTopTransactionContext = 0x838d9f000 [06:36:27.392] saveActivePortal = 0x0 [06:36:27.392] saveResourceOwner = 0x838dac1d8 [06:36:27.392] savePortalContext = 0x0 [06:36:27.392] saveMemoryContext = 0x838d9f000 [06:36:27.392] result = [06:36:27.392] nprocessed = [06:36:27.392] #15 0x000000000093d8b2 in exec_simple_query (query_string=query_string@entry=0x838cc4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [06:36:27.392] cmdtaglen = 24 [06:36:27.392] snapshot_set = [06:36:27.392] per_parsetree_context = 0x0 [06:36:27.392] plantree_list = [06:36:27.392] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:36:27.392] format = 0 [06:36:27.392] parsetree = 0x838cc56a8 [06:36:27.392] commandTag = [06:36:27.392] cmdtagname = [06:36:27.392] querytree_list = [06:36:27.392] portal = 0x838d9b100 [06:36:27.392] receiver = 0x843fe8548 [06:36:27.392] parsetree_item__state = {l = 0x838cc5a18, i = 0} [06:36:27.392] msec_str = "\000\000\000\000\b", '\000' , "9\260-g\000\000\000\000k\177:c\324{#\252" [06:36:27.392] dest = DestRemote [06:36:27.392] was_logged = [06:36:27.392] oldcontext = 0x838d9f000 [06:36:27.392] parsetree_list = 0x838cc5a18 [06:36:27.392] use_implicit_block = false [06:36:27.392] parsetree_item = 0x838cc5a30 [06:36:27.392] save_log_statement_stats = [06:36:27.392] #16 0x000000000093b523 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [06:36:27.392] query_string = 0x838cc4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:36:27.392] input_message = {data = 0x838cc4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:36:27.392] firstchar = [06:36:27.392] local_sigjmp_buf = {{_sjb = {9677270, 34916734128, 34916734088, 34916734672, 12400488, 1, 8192, 8388608, 34916729727, 0, 0, 1}}} [06:36:27.392] send_ready_for_query = false [06:36:27.392] idle_in_transaction_timeout_enabled = false [06:36:27.392] idle_session_timeout_enabled = false [06:36:27.392] #17 0x0000000000935d09 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:36:27.392] bsdata = [06:36:27.392] #18 0x000000000088d977 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8213321f4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821332130) at ../src/backend/postmaster/launch_backend.c:266 [06:36:27.392] pid = [06:36:27.392] #19 0x0000000000891d48 in BackendStartup (client_sock=0x821332130) at ../src/backend/postmaster/postmaster.c:3417 [06:36:27.392] startup_data = {canAcceptConnections = CAC_OK} [06:36:27.392] bn = 0x838cd0218 [06:36:27.392] pid = [06:36:27.392] __error = [06:36:27.392] save_errno = [06:36:27.392] __error = [06:36:27.392] __error = [06:36:27.392] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [06:36:27.392] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000_\3148\b", '\000' , "\220!3!\b\000\000\000h\305_-\b\000\000\000\v\000\000\000\000\000\000\000^O`-\b", '\000' , "\320!3!\b\000\000\000$\327\210\000\000\000\000\000\340!3!\b", '\000' }, salen = 16}} [06:36:27.392] i = 0 [06:36:27.392] now = [06:36:27.392] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 782994562, events = 8, fd = 0, user_data = 0x8213320e0}, {pos = 953288152, events = 8, fd = 556998512, user_data = 0x0}, {pos = 0, events = 0, fd = -1512767529, user_data = 0x367cdd24930a}, {pos = 782161824, events = 8, fd = 782232952, user_data = 0x821331bf8}, {pos = 556997744, events = 8, fd = 556997624, user_data = 0x367cdd24930a}, {pos = 782140296, events = 8, fd = 782232952, user_data = 0x821331c28}, {pos = 556997792, events = 8, fd = 556997672, user_data = 0x82e9f7194}, {pos = 563794952, events = 8, fd = 782201236, user_data = 0x821331c90}, {pos = -584825798, events = 13948, fd = 784023600, user_data = 0x1}, {pos = 556997824, events = 8, fd = -584805622, user_data = 0x82e9e0858}, {pos = 782232952, events = 8, fd = 556997784, user_data = 0x821331d10}, {pos = 556997784, events = 8, fd = 782195980, user_data = 0x8219ad408}, {pos = 782195980, events = 8, fd = 556997888, user_data = 0x367cdd24443a}, {pos = 556997928, events = 8, fd = 556998376, user_data = 0x821331d10}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2510644184, fd = 563818552, user_data = 0x800000001}, {pos = 563794952, events = 8, fd = 782140296, user_data = 0x8219b2288}, {pos = 782108760, events = 8, fd = 563794952, user_data = 0x821331d98}, {pos = 556998488, events = 8, fd = 556998016, user_data = 0x367cdd248ca2}, {pos = 2702380, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 563818552, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 556998744, user_data = 0x219ad408}, {pos = 556998560, events = 8, fd = 556998160, user_data = 0x1}, {pos = 556998488, events = 8, fd = 32, user_data = 0x821331e00}, {pos = -584807821, events = 13948, fd = 556998432, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8219b3038}, {pos = 1, events = 8, fd = 563794952, user_data = 0x82e9e0858}, {pos = 556998744, events = 8, fd = 556998560, user_data = 0x821331e10}, {pos = 0, events = 0, fd = 563765256, user_data = 0x20}, {pos = 556998544, events = 8, fd = -584832281, user_data = 0x8219a6008}, {pos = 563766280, events = 8, fd = 563767304, user_data = 0x8219a6c08}, {pos = 563781640, events = 8, fd = 563782664, user_data = 0x8219aa808}, {pos = 563784712, events = 8, fd = 563785736, user_data = 0x8219ab408}, {pos = 563787784, events = 8, fd = 563788808, user_data = 0x8219ac008}, {pos = 563790856, events = 8, fd = 563791880, user_data = 0x8219acc08}, {pos = 563793928, events = 8, fd = 563794952, user_data = 0x8219ad808}, {pos = 563797000, events = 8, fd = 563798024, user_data = 0x8219ae408}, {pos = 563800072, events = 8, fd = 563801096, user_data = 0x8219af008}, {pos = 563803144, events = 8, fd = 563804168, user_data = 0x8219afc08}, {pos = 563810312, events = 8, fd = 563811336, user_data = 0x8219b1808}, {pos = 563813384, events = 8, fd = 563765256, user_data = 0x293c2c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8219b3038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 556998744, events = 8, fd = 556998160, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 563818552, user_data = 0x1}, {pos = 563765256, events = 8, fd = 298, user_data = 0x821332040}, {pos = -584833553, events = 13948, fd = 2702380, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 563818552, user_data = 0x1}, {pos = 563794952, events = 8, fd = 952844288, user_data = 0x1}, {pos = 952844692, events = 8, fd = 0, user_data = 0x821332010}, {pos = 761283948, events = 8, fd = 1, user_data = 0x838cb4000}, {pos = 556998720, events = 8, fd = 761280258, user_data = 0x82eb12170 }, {pos = 12321352, events = 0, fd = 783360368, user_data = 0x8219ad408}, {pos = 556998944, events = 8, fd = -584834082, user_data = 0x838cd2800}, {pos = 1, events = 0, fd = -584834466, user_data = 0x8219a6008}, {pos = 556998728, events = 8, fd = 556998944, user_data = 0x1ab8}, {pos = 952917760, events = 8, fd = -584754800, user_data = 0x0}, {pos = 556991359, events = 8, fd = 8114039, user_data = 0x8213320d0}, {pos = 761242640, events = 8, fd = 784023600, user_data = 0x82ebb6310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821332100}, {pos = 761285533, events = 8, fd = 952844288, user_data = 0x1ddb}, {pos = 556999008, events = 8, fd = 761252090, user_data = 0x0}, {pos = 0, events = 0, fd = -1512767529, user_data = 0x0}} [06:36:27.393] last_touch_time = 1731047459 [06:36:27.393] last_lockfile_recheck_time = 1731047459 [06:36:27.393] nevents = 1 [06:36:27.393] #21 0x000000000088fb65 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821332748) at ../src/backend/postmaster/postmaster.c:1348 [06:36:27.393] userDoption = [06:36:27.393] listen_addr_saved = [06:36:27.393] output_config_variable = [06:36:27.393] opt = [06:36:27.393] status = [06:36:27.393] #22 0x00000000007c9bfc in main (argc=8, argv=0x821332748) at ../src/backend/main/main.c:196 [06:36:27.393] do_check_root = [06:36:27.405] [06:36:27.405] [06:36:27.405] [06:36:27.482] dumping /tmp/cores/postgres.11384.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:36:27.625] [New LWP 101825] [06:36:27.707] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [06:36:27.707] Program terminated with signal SIGABRT, Aborted. [06:36:27.707] Sent by thr_kill() from pid 11384 and user 1003. [06:36:27.707] #0 0x000000082c60d41a in thr_kill () from /lib/libc.so.7 [06:36:27.747] [06:36:27.747] Thread 1 (LWP 101825): [06:36:27.747] #0 0x000000082c60d41a in thr_kill () from /lib/libc.so.7 [06:36:27.747] No symbol table info available. [06:36:27.747] #1 0x000000082c586e64 in raise () from /lib/libc.so.7 [06:36:27.747] No symbol table info available. [06:36:27.747] #2 0x000000082c6376f9 in abort () from /lib/libc.so.7 [06:36:27.747] No symbol table info available. [06:36:27.747] #3 0x0000000000a95e95 in ExceptionalCondition (conditionName=0x2e7bc8 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:36:27.747] No locals. [06:36:27.747] #4 0x0000000000766869 in standard_ExecutorStart (queryDesc=0x843e4f088, eflags=0) at ../src/backend/executor/execMain.c:194 [06:36:27.747] estate = 0x837317100 [06:36:27.747] oldcontext = 0x837353800 [06:36:27.747] #5 0x00000000006fd4f5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [06:36:27.747] copied_query = [06:36:27.747] rewritten = [06:36:27.747] plan = 0x837320bd8 [06:36:27.747] queryDesc = 0x843e4f088 [06:36:27.747] processed = [06:36:27.747] __error = [06:36:27.747] #6 RefreshMatViewByOid (matviewOid=27313, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [06:36:27.747] dest = [06:36:27.747] save_userid = 10 [06:36:27.747] save_sec_context = 0 [06:36:27.747] processed = 0 [06:36:27.747] matviewRel = 0x843e0a600 [06:36:27.747] relowner = 10 [06:36:27.747] save_nestlevel = 2 [06:36:27.747] rule = [06:36:27.747] actions = [06:36:27.747] dataQuery = [06:36:27.747] tableSpace = [06:36:27.747] relpersistence = [06:36:27.747] OIDNewHeap = 27325 [06:36:27.747] address = [06:36:27.747] #7 0x00000000006fd0d6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:36:27.747] lockmode = [06:36:27.747] matviewOid = 0 [06:36:27.747] #8 0x00000000006d41ec in ExecCreateTableAs (pstate=pstate@entry=0x837353900, stmt=stmt@entry=0x83725efd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821866630) at ../src/backend/commands/createas.c:351 [06:36:27.747] refresh = 0x0 [06:36:27.747] query = 0x837311798 [06:36:27.747] into = 0x837311ae0 [06:36:27.747] jstate = 0x0 [06:36:27.747] do_refresh = false [06:36:27.747] address = [06:36:27.747] dest = [06:36:27.747] is_matview = [06:36:27.747] #9 0x0000000000941b68 in ProcessUtilitySlow (pstate=pstate@entry=0x837353900, pstmt=pstmt@entry=0x83717fa68, queryString=queryString@entry=0x83717e100 "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=0x821866630) at ../src/backend/tcop/utility.c:1678 [06:36:27.747] _local_sigjmp_buf = {{_sjb = {9704345, 0, 34922193496, 34922193872, 34922193504, 12391752, 0, 35285973248, 4294902655, 34922193612, 34922193648, 0}}} [06:36:27.747] _save_exception_stack = 0x821866530 [06:36:27.747] _save_context_stack = 0x0 [06:36:27.747] _do_rethrow = false [06:36:27.747] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:36:27.747] parsetree = 0x83725efd0 [06:36:27.747] commandCollected = false [06:36:27.747] needCleanup = false [06:36:27.747] address = [06:36:27.747] isTopLevel = [06:36:27.747] isCompleteQuery = [06:36:27.747] #10 0x00000000009404e8 in standard_ProcessUtility (pstmt=0x83717fa68, queryString=0x83717e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837311fc8, qc=0x821866630) at ../src/backend/tcop/utility.c:1033 [06:36:27.747] isAtomicContext = false [06:36:27.747] parsetree = 0x83725efd0 [06:36:27.747] readonly_flags = [06:36:27.747] pstate = 0x837353900 [06:36:27.747] isTopLevel = [06:36:27.747] #11 0x000000000093ff78 in ProcessUtility (pstmt=0x18dc1, queryString=0x6 , readOnlyTree=, context=744543226, params=0x0, queryEnv=0x0, dest=0x837311fc8, qc=0x821866630) at ../src/backend/tcop/utility.c:523 [06:36:27.747] No locals. [06:36:27.747] #12 0x000000000093fab3 in PortalRunUtility (portal=0x837224100, pstmt=0x83717fa68, isTopLevel=, setHoldSnapshot=, dest=0x837311fc8, qc=0x821866630) at ../src/backend/tcop/pquery.c:1158 [06:36:27.747] No locals. [06:36:27.747] #13 0x000000000093f144 in PortalRunMulti (portal=portal@entry=0x837224100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x837311fc8, altdest=altdest@entry=0x837311fc8, qc=0x821866630) at ../src/backend/tcop/pquery.c:1322 [06:36:27.747] pstmt = 0x83717fa68 [06:36:27.747] stmtlist_item__state = {l = 0x837311f78, i = 0} [06:36:27.747] active_snapshot_set = false [06:36:27.747] stmtlist_item = 0x837311f90 [06:36:27.747] #14 0x000000000093ea13 in PortalRun (portal=portal@entry=0x837224100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x837311fc8, altdest=altdest@entry=0x837311fc8, qc=0x821866630) at ../src/backend/tcop/pquery.c:791 [06:36:27.747] _local_sigjmp_buf = {{_sjb = {9693581, 35284730112, 34922194216, 34922194448, 34922194224, 35284746240, 12358360, 12391752, 35284714367, 35284964752, 4294967984, 0}}} [06:36:27.747] _save_exception_stack = 0x821866700 [06:36:27.747] _save_context_stack = 0x0 [06:36:27.747] _do_rethrow = false [06:36:27.747] saveTopTransactionResourceOwner = 0x837273418 [06:36:27.747] saveTopTransactionContext = 0x837228000 [06:36:27.747] saveActivePortal = 0x0 [06:36:27.747] saveResourceOwner = 0x837273418 [06:36:27.747] savePortalContext = 0x0 [06:36:27.747] saveMemoryContext = 0x837228000 [06:36:27.747] result = [06:36:27.747] nprocessed = [06:36:27.747] #15 0x000000000093d8b2 in exec_simple_query (query_string=query_string@entry=0x83717e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [06:36:27.747] cmdtaglen = 24 [06:36:27.747] snapshot_set = [06:36:27.747] per_parsetree_context = 0x0 [06:36:27.747] plantree_list = [06:36:27.747] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:36:27.747] format = 0 [06:36:27.747] parsetree = 0x83717f6a8 [06:36:27.747] commandTag = [06:36:27.747] cmdtagname = [06:36:27.747] querytree_list = [06:36:27.747] portal = 0x837224100 [06:36:27.747] receiver = 0x837311fc8 [06:36:27.747] parsetree_item__state = {l = 0x83717fa18, i = 0} [06:36:27.747] msec_str = "\000\000\000\000\b", '\000' , "<\260-g\000\000\000\000\313Q\256\373\275\b", [06:36:27.747] dest = DestRemote [06:36:27.747] was_logged = [06:36:27.747] oldcontext = 0x837228000 [06:36:27.747] parsetree_list = 0x83717fa18 [06:36:27.747] use_implicit_block = false [06:36:27.747] parsetree_item = 0x83717fa30 [06:36:27.747] save_log_statement_stats = [06:36:27.747] #16 0x000000000093b523 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [06:36:27.747] query_string = 0x83717e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:36:27.747] input_message = {data = 0x83717e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:36:27.747] firstchar = [06:36:27.747] local_sigjmp_buf = {{_sjb = {9677270, 34922194688, 34922194648, 34922195232, 12400488, 1, 8192, 8388608, 34922169215, 0, 0, 1}}} [06:36:27.747] send_ready_for_query = false [06:36:27.747] idle_in_transaction_timeout_enabled = false [06:36:27.747] idle_session_timeout_enabled = false [06:36:27.747] #17 0x0000000000935d09 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:36:27.747] bsdata = [06:36:27.747] #18 0x000000000088d977 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821867444 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821867380) at ../src/backend/postmaster/launch_backend.c:266 [06:36:27.747] pid = [06:36:27.747] #19 0x0000000000891d48 in BackendStartup (client_sock=0x821867380) at ../src/backend/postmaster/postmaster.c:3417 [06:36:27.747] startup_data = {canAcceptConnections = CAC_OK} [06:36:27.747] bn = 0x83718bfb8 [06:36:27.747] pid = [06:36:27.747] __error = [06:36:27.747] save_errno = [06:36:27.747] __error = [06:36:27.747] __error = [06:36:27.747] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [06:36:27.747] 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 = "\300\376\0277\b", '\000' , "\340s\206!\b\000\000\000hE\006,\b\000\000\000\v\000\000\000\000\000\000\000^\317\006,\b", '\000' , " t\206!\b\000\000\000$\327\210\000\000\000\000\0000t\206!\b", '\000' }, salen = 16}} [06:36:27.747] i = 0 [06:36:27.747] now = [06:36:27.747] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 744168578, events = 8, fd = 0, user_data = 0x821867330}, {pos = 924747224, events = 8, fd = 562459072, user_data = 0x0}, {pos = 0, events = 0, fd = 1680823393, user_data = 0x10e44321330a}, {pos = 743335840, events = 8, fd = 743406968, user_data = 0x821866e48}, {pos = 562458304, events = 8, fd = 562458184, user_data = 0x10e44321330a}, {pos = 743314312, events = 8, fd = 743406968, user_data = 0x821866e78}, {pos = 562458352, events = 8, fd = 562458232, user_data = 0x82c4f0194}, {pos = 571970568, events = 8, fd = 743375252, user_data = 0x821866ee0}, {pos = 1126229050, events = 4324, fd = 745197616, user_data = 0x1}, {pos = 562458384, events = 8, fd = 1126249226, user_data = 0x82c4d9858}, {pos = 743406968, events = 8, fd = 562458344, user_data = 0x821866f60}, {pos = 562458344, events = 8, fd = 743369996, user_data = 0x822179408}, {pos = 743369996, events = 8, fd = 562458448, user_data = 0x10e44320e43a}, {pos = 562458488, events = 8, fd = 562458936, user_data = 0x821866f60}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 254398798, fd = 571994168, user_data = 0x800000001}, {pos = 571970568, events = 8, fd = 743314312, user_data = 0x82217e288}, {pos = 743282776, events = 8, fd = 571970568, user_data = 0x821866fe8}, {pos = 562459048, events = 8, fd = 562458576, user_data = 0x10e443212ca2}, {pos = 2702380, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 571994168, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 562459304, user_data = 0x22179408}, {pos = 562459120, events = 8, fd = 562458720, user_data = 0x1}, {pos = 562459048, events = 8, fd = 32, user_data = 0x821867050}, {pos = 1126247027, events = 4324, fd = 562458992, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82217f038}, {pos = 1, events = 8, fd = 571970568, user_data = 0x82c4d9858}, {pos = 562459304, events = 8, fd = 562459120, user_data = 0x821867060}, {pos = 0, events = 0, fd = 571940872, user_data = 0x20}, {pos = 562459104, events = 8, fd = 1126222567, user_data = 0x822172008}, {pos = 571941896, events = 8, fd = 571942920, user_data = 0x822172c08}, {pos = 571957256, events = 8, fd = 571958280, user_data = 0x822176808}, {pos = 571960328, events = 8, fd = 571961352, user_data = 0x822177408}, {pos = 571963400, events = 8, fd = 571964424, user_data = 0x822178008}, {pos = 571966472, events = 8, fd = 571967496, user_data = 0x822178c08}, {pos = 571969544, events = 8, fd = 571970568, user_data = 0x822179808}, {pos = 571972616, events = 8, fd = 571973640, user_data = 0x82217a408}, {pos = 571975688, events = 8, fd = 571976712, user_data = 0x82217b008}, {pos = 571978760, events = 8, fd = 571979784, user_data = 0x82217bc08}, {pos = 571985928, events = 8, fd = 571986952, user_data = 0x82217d808}, {pos = 571989000, events = 8, fd = 571940872, user_data = 0x293c2c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82217f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 562459304, events = 8, fd = 562458720, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 571994168, user_data = 0x1}, {pos = 571940872, events = 8, fd = 298, user_data = 0x821867290}, {pos = 1126221295, events = 4324, fd = 2702380, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 571994168, user_data = 0x1}, {pos = 571970568, events = 8, fd = 924246016, user_data = 0x1}, {pos = 924246420, events = 8, fd = 0, user_data = 0x821867260}, {pos = 738641260, events = 8, fd = 1, user_data = 0x83716e000}, {pos = 562459280, events = 8, fd = 738637570, user_data = 0x82c60b170 }, {pos = 12321352, events = 0, fd = 744534384, user_data = 0x822179408}, {pos = 562459504, events = 8, fd = 1126220766, user_data = 0x83718c800}, {pos = 1, events = 0, fd = 1126220382, user_data = 0x822172008}, {pos = 562459288, events = 8, fd = 562459504, user_data = 0x1ab8}, {pos = 924319424, events = 8, fd = 1126300048, user_data = 0x0}, {pos = 562430847, events = 8, fd = 8114039, user_data = 0x821867320}, {pos = 738599952, events = 8, fd = 745197616, user_data = 0x82c6af310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821867350}, {pos = 738642845, events = 8, fd = 924246016, user_data = 0x1e44}, {pos = 562459568, events = 8, fd = 738609402, user_data = 0x0}, {pos = 0, events = 0, fd = 1680823393, user_data = 0x0}} [06:36:27.747] last_touch_time = 1731047460 [06:36:27.747] last_lockfile_recheck_time = 1731047460 [06:36:27.747] nevents = 1 [06:36:27.747] #21 0x000000000088fb65 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821867998) at ../src/backend/postmaster/postmaster.c:1348 [06:36:27.747] userDoption = [06:36:27.747] listen_addr_saved = [06:36:27.747] output_config_variable = [06:36:27.747] opt = [06:36:27.747] status = [06:36:27.747] #22 0x00000000007c9bfc in main (argc=4, argv=0x821867998) at ../src/backend/main/main.c:196 [06:36:27.747] do_check_root = [06:36:27.761] [06:36:27.761] [06:36:27.761] [06:36:27.820] dumping /tmp/cores/sh.13939.core for /bin/sh [06:36:27.867] [New LWP 101889] [06:36:27.867] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/'. [06:36:27.867] Program terminated with signal SIGQUIT, Quit. [06:36:27.867] Sent by kill() from pid 13866 and user 1003. [06:36:27.867] #0 0x00002ce543573ff0 in ?? () [06:36:27.867] [06:36:27.867] Thread 1 (LWP 101889): [06:36:27.867] #0 0x00002ce543573ff0 in ?? () [06:36:27.867] No symbol table info available. [06:36:27.867] #1 0x0000000000000003 in ?? () [06:36:27.867] No symbol table info available. [06:36:27.867] #2 0x000006de54fc6c78 in ?? () [06:36:27.867] No symbol table info available. [06:36:27.867] #3 0x000006de54fc6c7b in ?? () [06:36:27.867] No symbol table info available. [06:36:27.867] #4 0x000006de54fc6c7e in ?? () [06:36:27.867] No symbol table info available. [06:36:27.867] #5 0x0000000000000000 in ?? () [06:36:27.867] No symbol table info available. [06:36:27.875] [06:36:27.875] [06:36:27.875] [06:36:27.952] dumping /tmp/cores/postgres.17916.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:36:28.100] [New LWP 101893] [06:36:28.183] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [06:36:28.183] Program terminated with signal SIGABRT, Aborted. [06:36:28.183] Sent by thr_kill() from pid 17916 and user 1003. [06:36:28.183] #0 0x000000082b29a41a in thr_kill () from /lib/libc.so.7 [06:36:28.239] [06:36:28.239] Thread 1 (LWP 101893): [06:36:28.239] #0 0x000000082b29a41a in thr_kill () from /lib/libc.so.7 [06:36:28.239] No symbol table info available. [06:36:28.239] #1 0x000000082b213e64 in raise () from /lib/libc.so.7 [06:36:28.239] No symbol table info available. [06:36:28.239] #2 0x000000082b2c46f9 in abort () from /lib/libc.so.7 [06:36:28.239] No symbol table info available. [06:36:28.239] #3 0x0000000000a95e95 in ExceptionalCondition (conditionName=0x2e7bc8 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [06:36:28.239] No locals. [06:36:28.239] #4 0x0000000000766869 in standard_ExecutorStart (queryDesc=0x8396df088, eflags=0) at ../src/backend/executor/execMain.c:194 [06:36:28.239] estate = 0x83f1dc100 [06:36:28.239] oldcontext = 0x8396d8800 [06:36:28.239] #5 0x000000083c9c89c2 in pgss_ExecutorStart (queryDesc=0x8396df088, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [06:36:28.239] No locals. [06:36:28.239] #6 0x00000000006fd4f5 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [06:36:28.239] copied_query = [06:36:28.239] rewritten = [06:36:28.239] plan = 0x83f24bbd8 [06:36:28.239] queryDesc = 0x8396df088 [06:36:28.239] processed = [06:36:28.239] __error = [06:36:28.239] #7 RefreshMatViewByOid (matviewOid=27189, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [06:36:28.239] dest = [06:36:28.239] save_userid = 10 [06:36:28.239] save_sec_context = 0 [06:36:28.239] processed = 0 [06:36:28.239] matviewRel = 0x83f20e268 [06:36:28.239] relowner = 10 [06:36:28.239] save_nestlevel = 2 [06:36:28.239] rule = [06:36:28.239] actions = [06:36:28.239] dataQuery = [06:36:28.239] tableSpace = [06:36:28.239] relpersistence = [06:36:28.239] OIDNewHeap = 27204 [06:36:28.239] address = [06:36:28.239] #8 0x00000000006fd0d6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [06:36:28.239] lockmode = [06:36:28.239] matviewOid = 0 [06:36:28.239] #9 0x00000000006d41ec in ExecCreateTableAs (pstate=pstate@entry=0x8396d8900, stmt=stmt@entry=0x8395f9fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821a8b950) at ../src/backend/commands/createas.c:351 [06:36:28.239] refresh = 0x0 [06:36:28.239] query = 0x839644dc8 [06:36:28.239] into = 0x8395f9f40 [06:36:28.239] jstate = 0x0 [06:36:28.239] do_refresh = false [06:36:28.239] address = [06:36:28.239] dest = [06:36:28.239] is_matview = [06:36:28.239] #10 0x0000000000941b68 in ProcessUtilitySlow (pstate=pstate@entry=0x8396d8900, pstmt=pstmt@entry=0x8395f9e30, queryString=queryString@entry=0x83955c100 "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=0x821a8b950) at ../src/backend/tcop/utility.c:1678 [06:36:28.239] _local_sigjmp_buf = {{_sjb = {9704345, 0, 34924442552, 34924442928, 34924442560, 12391752, 0, 35323218176, 34924397439, 7, 34924442704, 0}}} [06:36:28.239] _save_exception_stack = 0x821a8b640 [06:36:28.239] _save_context_stack = 0x0 [06:36:28.239] _do_rethrow = false [06:36:28.239] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [06:36:28.239] parsetree = 0x8395f9fd0 [06:36:28.239] commandCollected = false [06:36:28.239] needCleanup = false [06:36:28.239] address = [06:36:28.239] isTopLevel = [06:36:28.239] isCompleteQuery = [06:36:28.239] #11 0x00000000009404e8 in standard_ProcessUtility (pstmt=0x8395f9e30, queryString=queryString@entry=0x83955c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x839645568, qc=0x821a8b950) at ../src/backend/tcop/utility.c:1033 [06:36:28.239] isAtomicContext = false [06:36:28.239] parsetree = 0x8395f9fd0 [06:36:28.239] readonly_flags = [06:36:28.239] pstate = 0x8396d8900 [06:36:28.239] isTopLevel = [06:36:28.239] #12 0x000000083c9c8f7e in pgss_ProcessUtility (pstmt=0x8395f9e30, queryString=0x83955c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x839645568, qc=0x821a8b950) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [06:36:28.239] _local_sigjmp_buf = {{_sjb = {35376631479, 34924443200, 34924443064, 34924443520, 35322306096, 0, 12391752, 34924443728, 34924397439, 34924443300, 34924443328, 0}}} [06:36:28.239] _save_exception_stack = 0x821a8b850 [06:36:28.239] _save_context_stack = 0x0 [06:36:28.239] _do_rethrow = false [06:36:28.239] bufusage = {shared_blks_hit = 35376631479, shared_blks_read = 34924443200, shared_blks_dirtied = 34924443064, shared_blks_written = 34924443520, local_blks_hit = 35322306096, local_blks_read = 0, local_blks_dirtied = 12391752, local_blks_written = 34924443728, temp_blks_read = 34924397439, temp_blks_written = 34924443300, shared_blk_read_time = {ticks = 34924443328}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4421775076871657600}, local_blk_write_time = {ticks = 12400792}, temp_blk_read_time = {ticks = 35393447936}, temp_blk_write_time = {ticks = 12354304}} [06:36:28.239] walusage_start = {wal_records = 8928, wal_fpi = 154, wal_bytes = 1329590} [06:36:28.239] duration = [06:36:28.239] bufusage_start = {shared_blks_hit = 151246, shared_blks_read = 8035, shared_blks_dirtied = 2678, shared_blks_written = 2425, 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}} [06:36:28.239] walusage = {wal_records = -907911229255893364, wal_fpi = 35322306512, wal_bytes = 123} [06:36:28.239] start = {ticks = -209646752203} [06:36:28.239] rows = [06:36:28.239] saved_queryId = 6041762721901209185 [06:36:28.239] parsetree = [06:36:28.239] saved_stmt_location = 0 [06:36:28.239] saved_stmt_len = 69 [06:36:28.239] enabled = [06:36:28.239] #13 0x000000000093fab3 in PortalRunUtility (portal=0x839604100, pstmt=0x8395f9e30, isTopLevel=, setHoldSnapshot=, dest=0x839645568, qc=0x821a8b950) at ../src/backend/tcop/pquery.c:1158 [06:36:28.239] No locals. [06:36:28.239] #14 0x000000000093f144 in PortalRunMulti (portal=portal@entry=0x839604100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x839645568, altdest=altdest@entry=0x839645568, qc=0x821a8b950) at ../src/backend/tcop/pquery.c:1322 [06:36:28.239] pstmt = 0x8395f9e30 [06:36:28.239] stmtlist_item__state = {l = 0x839645518, i = 0} [06:36:28.239] active_snapshot_set = false [06:36:28.239] stmtlist_item = 0x839645530 [06:36:28.239] #15 0x000000000093ea13 in PortalRun (portal=portal@entry=0x839604100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x839645568, altdest=altdest@entry=0x839645568, qc=0x821a8b950) at ../src/backend/tcop/pquery.c:791 [06:36:28.239] _local_sigjmp_buf = {{_sjb = {9693581, 35322347776, 34924443720, 34924443952, 34924443728, 35322441728, 12358360, 12391752, 35322332031, 35322299872, 4294967984, 0}}} [06:36:28.239] _save_exception_stack = 0x821a8ba20 [06:36:28.239] _save_context_stack = 0x0 [06:36:28.239] _do_rethrow = false [06:36:28.239] saveTopTransactionResourceOwner = 0x839652ed8 [06:36:28.239] saveTopTransactionContext = 0x83961b000 [06:36:28.239] saveActivePortal = 0x0 [06:36:28.239] saveResourceOwner = 0x839652ed8 [06:36:28.239] savePortalContext = 0x0 [06:36:28.239] saveMemoryContext = 0x83961b000 [06:36:28.239] result = [06:36:28.239] nprocessed = [06:36:28.239] #16 0x000000000093d8b2 in exec_simple_query (query_string=query_string@entry=0x83955c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [06:36:28.239] cmdtaglen = 24 [06:36:28.239] snapshot_set = [06:36:28.239] per_parsetree_context = 0x0 [06:36:28.239] plantree_list = [06:36:28.239] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:36:28.239] format = 0 [06:36:28.239] parsetree = 0x83955d6a8 [06:36:28.239] commandTag = [06:36:28.239] cmdtagname = [06:36:28.239] querytree_list = [06:36:28.239] portal = 0x839604100 [06:36:28.239] receiver = 0x839645568 [06:36:28.239] parsetree_item__state = {l = 0x83955da18, i = 0} [06:36:28.239] msec_str = "\000\000\000\000\b", '\000' , "h\260-g\000\000\000\000k\267<\315\304S\252\f" [06:36:28.239] dest = DestRemote [06:36:28.239] was_logged = [06:36:28.239] oldcontext = 0x83961b000 [06:36:28.239] parsetree_list = 0x83955da18 [06:36:28.239] use_implicit_block = false [06:36:28.239] parsetree_item = 0x83955da30 [06:36:28.239] save_log_statement_stats = [06:36:28.239] #17 0x000000000093b523 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4788 [06:36:28.239] query_string = 0x83955c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [06:36:28.239] input_message = {data = 0x83955c100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [06:36:28.239] firstchar = [06:36:28.239] local_sigjmp_buf = {{_sjb = {9677270, 34924444192, 34924444152, 34924444736, 12400488, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [06:36:28.239] send_ready_for_query = false [06:36:28.239] idle_in_transaction_timeout_enabled = false [06:36:28.239] idle_session_timeout_enabled = false [06:36:28.239] #18 0x0000000000935d09 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:36:28.239] bsdata = [06:36:28.239] #19 0x000000000088d977 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a8c764 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a8c6a0) at ../src/backend/postmaster/launch_backend.c:266 [06:36:28.239] pid = [06:36:28.239] #20 0x0000000000891d48 in BackendStartup (client_sock=0x821a8c6a0) at ../src/backend/postmaster/postmaster.c:3417 [06:36:28.239] startup_data = {canAcceptConnections = CAC_OK} [06:36:28.239] bn = 0x839568128 [06:36:28.239] pid = [06:36:28.239] __error = [06:36:28.239] save_errno = [06:36:28.239] __error = [06:36:28.239] __error = [06:36:28.239] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [06:36:28.239] 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 = " \314U9\b", '\000' , "Ǩ!\b\000\000\000hu\302)\b\000\000\000\v\000\000\000\000\000\000\000^\377\302)\b", '\000' , "@Ǩ!\b\000\000\000$\327\210\000\000\000\000\000PǨ!\b", '\000' }, salen = 16}} [06:36:28.239] i = 0 [06:36:28.239] now = [06:36:28.239] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 723774594, events = 8, fd = 0, user_data = 0x821a8c650}, {pos = 962328024, events = 8, fd = 564708576, user_data = 0x0}, {pos = 1333388042, events = 5349, fd = 722941856, user_data = 0x82b184d78}, {pos = 564707672, events = 8, fd = 564707792, user_data = 0x821a8c158}, {pos = 1333388042, events = 5349, fd = 722920328, user_data = 0x82b184d78}, {pos = 564707720, events = 8, fd = 564707840, user_data = 0x821a8c188}, {pos = 722981268, events = 8, fd = 571929608, user_data = 0x82b17d194}, {pos = 564707824, events = 8, fd = 1333367866, user_data = 0x821a8c190}, {pos = 700601360, events = 8, fd = 724803632, user_data = 0x14e54f79e30a}, {pos = 722888792, events = 8, fd = 723012984, user_data = 0x821a8c1f8}, {pos = 564707952, events = 8, fd = 564707832, user_data = 0x82b17bd0c}, {pos = 571929608, events = 8, fd = 722976012, user_data = 0x821a8c260}, {pos = 1333367866, events = 5349, fd = 564707976, user_data = 0x821a8c458}, {pos = 564707952, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x822175038}, {pos = 1, events = 4083577740, fd = 571929608, user_data = 0x82b16e388}, {pos = 571951048, events = 8, fd = 0, user_data = 0x0}, {pos = 564708088, events = 8, fd = 564708552, user_data = 0x821a8c2e0}, {pos = 1333386402, events = 5349, fd = 2702380, user_data = 0x6d68b}, {pos = 2090263927, events = 4083577740, fd = 571953208, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821a8c5c8}, {pos = 571929608, events = 3, fd = 564708624, user_data = 0x822174828}, {pos = 656, events = 0, fd = 564708552, user_data = 0x821a8c2f8}, {pos = 564708192, events = 8, fd = 1333386011, user_data = 0x821a8c490}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 571953208, events = 8, fd = 1, user_data = 0x82216f408}, {pos = 722888792, events = 8, fd = 564708808, user_data = 0x821a8c510}, {pos = 564708208, events = 8, fd = 0, user_data = 0x822168008}, {pos = 33, events = 0, fd = 564708608, user_data = 0x14e54f797ae7}, {pos = 571899912, events = 8, fd = 571900936, user_data = 0x822168808}, {pos = 571902984, events = 8, fd = 571916296, user_data = 0x82216c408}, {pos = 571918344, events = 8, fd = 571919368, user_data = 0x82216d008}, {pos = 571921416, events = 8, fd = 571922440, user_data = 0x82216dc08}, {pos = 571924488, events = 8, fd = 571925512, user_data = 0x82216e808}, {pos = 571927560, events = 8, fd = 571928584, user_data = 0x82216f408}, {pos = 571930632, events = 8, fd = 571931656, user_data = 0x822170008}, {pos = 571933704, events = 8, fd = 571934728, user_data = 0x822170c08}, {pos = 571936776, events = 8, fd = 571937800, user_data = 0x822171808}, {pos = 571939848, events = 8, fd = 571944968, user_data = 0x822173408}, {pos = 571947016, events = 8, fd = 571948040, user_data = 0x822176408}, {pos = 611826000, events = 0, fd = 571899912, user_data = 0x293c2c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822175038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564708808, events = 8, fd = 564708208, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 571953208, user_data = 0x1}, {pos = 571899912, events = 8, fd = 298, user_data = 0x821a8c5b0}, {pos = 1333360111, events = 5349, fd = 2702380, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 571953208, user_data = 0x1}, {pos = 571929608, events = 8, fd = 961855488, user_data = 0x1}, {pos = 961855892, events = 8, fd = 0, user_data = 0x821a8c580}, {pos = 700642668, events = 8, fd = 1, user_data = 0x83954c000}, {pos = 564708784, events = 8, fd = 700638978, user_data = 0x82b298170 }, {pos = 12321352, events = 0, fd = 724140400, user_data = 0x82216f408}, {pos = 564709008, events = 8, fd = 1333359582, user_data = 0x83956a800}, {pos = 1, events = 0, fd = 1333359198, user_data = 0x822168008}, {pos = 564708792, events = 8, fd = 564709008, user_data = 0x1ab8}, {pos = 961924128, events = 8, fd = 1333438864, user_data = 0x0}, {pos = 564659071, events = 8, fd = 8114039, user_data = 0x821a8c640}, {pos = 700601360, events = 8, fd = 724803632, user_data = 0x82b33c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a8c670}, {pos = 700644253, events = 8, fd = 961855488, user_data = 0x36c4}, {pos = 564709072, events = 8, fd = 700610810, user_data = 0x0}, {pos = 0, events = 0, fd = 480067212, user_data = 0x0}} [06:36:28.240] last_touch_time = 1731047497 [06:36:28.240] last_lockfile_recheck_time = 1731047497 [06:36:28.240] nevents = 1 [06:36:28.240] #22 0x000000000088fb65 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a8ccb0) at ../src/backend/postmaster/postmaster.c:1348 [06:36:28.240] userDoption = [06:36:28.240] listen_addr_saved = [06:36:28.240] output_config_variable = [06:36:28.240] opt = [06:36:28.240] status = [06:36:28.240] #23 0x00000000007c9bfc in main (argc=4, argv=0x821a8ccb0) at ../src/backend/main/main.c:196 [06:36:28.240] do_check_root =