[16:12:09.929] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [16:12:10.213] dumping /tmp/cores/postgres.11093.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [16:12:10.337] [New LWP 101978] [16:12:10.415] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [16:12:10.415] Program terminated with signal SIGABRT, Aborted. [16:12:10.415] Sent by thr_kill() from pid 11093 and user 1003. [16:12:10.415] #0 0x000000082ca3941a in thr_kill () from /lib/libc.so.7 [16:12:10.475] [16:12:10.475] Thread 1 (LWP 101978): [16:12:10.475] #0 0x000000082ca3941a in thr_kill () from /lib/libc.so.7 [16:12:10.475] No symbol table info available. [16:12:10.475] #1 0x000000082c9b2e64 in raise () from /lib/libc.so.7 [16:12:10.475] No symbol table info available. [16:12:10.475] #2 0x000000082ca636f9 in abort () from /lib/libc.so.7 [16:12:10.475] No symbol table info available. [16:12:10.475] #3 0x0000000000aafe65 in ExceptionalCondition (conditionName=0x2eea18 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [16:12:10.475] No locals. [16:12:10.475] #4 0x0000000000770854 in standard_ExecutorStart (queryDesc=0x835c22bd0, eflags=0) at ../src/backend/executor/execMain.c:203 [16:12:10.475] estate = 0x837713100 [16:12:10.475] oldcontext = 0x835ce3c00 [16:12:10.475] #5 0x0000000000703fd1 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [16:12:10.475] copied_query = [16:12:10.475] rewritten = [16:12:10.475] plan = 0x835c22778 [16:12:10.475] queryDesc = 0x835c22bd0 [16:12:10.475] processed = [16:12:10.475] __error = [16:12:10.475] __error = [16:12:10.475] #6 RefreshMatViewByOid (matviewOid=28457, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [16:12:10.475] dest = [16:12:10.475] save_userid = 10 [16:12:10.475] save_sec_context = 0 [16:12:10.475] processed = 0 [16:12:10.475] matviewRel = 0x8376dea28 [16:12:10.475] relowner = 10 [16:12:10.475] save_nestlevel = 2 [16:12:10.475] rule = [16:12:10.475] actions = [16:12:10.475] dataQuery = [16:12:10.475] tableSpace = [16:12:10.475] relpersistence = [16:12:10.475] OIDNewHeap = 28472 [16:12:10.475] address = [16:12:10.475] #7 0x0000000000703ba6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [16:12:10.475] lockmode = [16:12:10.475] matviewOid = 0 [16:12:10.475] #8 0x00000000006da9fc in ExecCreateTableAs (pstate=pstate@entry=0x835ce3d00, stmt=stmt@entry=0x835c15fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820be2c10) at ../src/backend/commands/createas.c:351 [16:12:10.475] refresh = 0x0 [16:12:10.475] query = 0x835c351d8 [16:12:10.475] into = 0x835c35520 [16:12:10.475] jstate = 0x0 [16:12:10.475] do_refresh = false [16:12:10.475] address = [16:12:10.475] dest = [16:12:10.475] is_matview = [16:12:10.475] #9 0x0000000000956c1e in ProcessUtilitySlow (pstate=pstate@entry=0x835ce3d00, pstmt=pstmt@entry=0x835b5aa68, queryString=queryString@entry=0x835b59100 "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=0x820be2c10) at ../src/backend/tcop/utility.c:1678 [16:12:10.475] _local_sigjmp_buf = {{_sjb = {9790540, 0, 34909071400, 34909071776, 34909071408, 12647432, 0, 35262446848, 12518271, 1, 4294967295, 34359738368}}} [16:12:10.475] _save_exception_stack = 0x820be2b00 [16:12:10.475] _save_context_stack = 0x0 [16:12:10.475] _do_rethrow = false [16:12:10.475] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [16:12:10.475] parsetree = 0x835c15fd0 [16:12:10.475] commandCollected = false [16:12:10.475] needCleanup = false [16:12:10.475] address = [16:12:10.475] isTopLevel = [16:12:10.475] isCompleteQuery = [16:12:10.475] #10 0x000000000095559b in standard_ProcessUtility (pstmt=0x835b5aa68, queryString=0x835b59100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835c35a08, qc=0x820be2c10) at ../src/backend/tcop/utility.c:1033 [16:12:10.475] isAtomicContext = false [16:12:10.475] parsetree = 0x835c15fd0 [16:12:10.475] readonly_flags = [16:12:10.475] pstate = 0x835ce3d00 [16:12:10.475] isTopLevel = [16:12:10.475] #11 0x0000000000955028 in ProcessUtility (pstmt=0x18e5a, queryString=0x6 , readOnlyTree=, context=748917754, params=0x0, queryEnv=0x0, dest=0x835c35a08, qc=0x820be2c10) at ../src/backend/tcop/utility.c:523 [16:12:10.475] No locals. [16:12:10.475] #12 0x0000000000954ad3 in PortalRunUtility (portal=0x835c2d100, pstmt=0x835b5aa68, isTopLevel=, setHoldSnapshot=, dest=0x835c35a08, qc=0x820be2c10) at ../src/backend/tcop/pquery.c:1184 [16:12:10.475] No locals. [16:12:10.475] #13 0x0000000000954164 in PortalRunMulti (portal=portal@entry=0x835c2d100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835c35a08, altdest=altdest@entry=0x835c35a08, qc=qc@entry=0x820be2c10) at ../src/backend/tcop/pquery.c:1355 [16:12:10.475] pstmt = 0x835b5aa68 [16:12:10.475] stmtlist_item__state = {l = 0x835c359b8, i = 0} [16:12:10.475] active_snapshot_set = false [16:12:10.475] query_index = 0 [16:12:10.475] stmtlist_item = 0x835c359d0 [16:12:10.475] #14 0x0000000000953a21 in PortalRun (portal=portal@entry=0x835c2d100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x835c35a08, altdest=altdest@entry=0x835c35a08, qc=qc@entry=0x820be2c10) at ../src/backend/tcop/pquery.c:819 [16:12:10.475] _local_sigjmp_buf = {{_sjb = {9779608, 35261698304, 34909072120, 34909072368, 34909072128, 12647432, 34909072400, 12576392, 34909062015, 34909072335, 35261706496, 34359738368}}} [16:12:10.475] _save_exception_stack = 0x820be2ce0 [16:12:10.475] _save_context_stack = 0x0 [16:12:10.475] _do_rethrow = false [16:12:10.475] saveTopTransactionResourceOwner = 0x835c3bd88 [16:12:10.475] saveTopTransactionContext = 0x835c31000 [16:12:10.475] saveActivePortal = 0x0 [16:12:10.475] saveResourceOwner = 0x835c3bd88 [16:12:10.475] savePortalContext = 0x0 [16:12:10.475] saveMemoryContext = 0x835c31000 [16:12:10.475] result = [16:12:10.475] nprocessed = [16:12:10.475] #15 0x00000000009527f1 in exec_simple_query (query_string=query_string@entry=0x835b59100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [16:12:10.475] cmdtaglen = 24 [16:12:10.475] snapshot_set = [16:12:10.475] per_parsetree_context = 0x0 [16:12:10.475] plantree_list = [16:12:10.475] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:12:10.475] format = 0 [16:12:10.475] parsetree = 0x835b5a6a8 [16:12:10.475] commandTag = [16:12:10.475] cmdtagname = [16:12:10.475] querytree_list = [16:12:10.475] portal = 0x835c2d100 [16:12:10.475] receiver = 0x835c35a08 [16:12:10.475] parsetree_item__state = {l = 0x835b5aa18, i = 0} [16:12:10.475] msec_str = "\000\000\000\000\b", '\000' , "\377;\277g\000\000\000\000t+\230\320/d\250\371" [16:12:10.475] dest = DestRemote [16:12:10.475] was_logged = [16:12:10.475] oldcontext = 0x835c31000 [16:12:10.475] parsetree_list = 0x835b5aa18 [16:12:10.475] use_implicit_block = false [16:12:10.475] parsetree_item = 0x835b5aa30 [16:12:10.475] save_log_statement_stats = [16:12:10.475] #16 0x0000000000950463 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4689 [16:12:10.475] query_string = 0x835b59100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [16:12:10.475] input_message = {data = 0x835b59100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [16:12:10.475] firstchar = [16:12:10.475] local_sigjmp_buf = {{_sjb = {9763078, 34909072608, 34909072568, 34909073152, 12656184, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [16:12:10.475] send_ready_for_query = false [16:12:10.475] idle_in_transaction_timeout_enabled = false [16:12:10.475] idle_session_timeout_enabled = false [16:12:10.475] #17 0x000000000094adf9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [16:12:10.475] bsdata = [16:12:10.475] #18 0x00000000008a17c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x820be3a10, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820be3960) at ../src/backend/postmaster/launch_backend.c:274 [16:12:10.475] pid = [16:12:10.475] #19 0x00000000008a5b6b in BackendStartup (client_sock=0x820be3960) at ../src/backend/postmaster/postmaster.c:3519 [16:12:10.475] startup_data = {canAcceptConnections = CAC_OK} [16:12:10.475] bn = 0x835bf9068 [16:12:10.475] cac = CAC_OK [16:12:10.475] pid = [16:12:10.475] __error = [16:12:10.475] save_errno = [16:12:10.475] __error = [16:12:10.475] __error = [16:12:10.475] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [16:12:10.475] 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' , "\3009\276 \b\000\000\000hU\377*\b\000\000\000\372\000\000\000\000\000\000\000^\337\377*\b", '\000' , ":\276 \b\000\000\000T\025\212\000\000\000\000\000\020:\276 \b", '\000' }, salen = 16}} [16:12:10.475] i = 0 [16:12:10.475] now = [16:12:10.475] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 901457368, events = 8, fd = 549336992, user_data = 0x820be3500}, {pos = 8192, events = 0, fd = 8192, user_data = 0x835c25000}, {pos = 549336328, events = 8, fd = 0, user_data = 0x834153090}, {pos = 1, events = 0, fd = 549336128, user_data = 0x82caa89c9}, {pos = 747688840, events = 8, fd = 747781496, user_data = 0x820be3458}, {pos = 549336272, events = 8, fd = 549336320, user_data = 0x820be34f8}, {pos = 873803920, events = 8, fd = 885000576, user_data = 0x20}, {pos = 4096, events = 0, fd = 549336768, user_data = 0x82caa3a7c}, {pos = 549336312, events = 8, fd = 2058806026, user_data = 0x82c905858}, {pos = 747781496, events = 8, fd = 549336264, user_data = 0x820be3540}, {pos = 549336264, events = 8, fd = 747744524, user_data = 0x82194d408}, {pos = 747744524, events = 8, fd = 549336368, user_data = 0x1017ab6943a}, {pos = 873803968, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 885011000, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821952288}, {pos = 747657304, events = 8, fd = 563401736, user_data = 0x820be35c8}, {pos = 549336968, events = 8, fd = 549336496, user_data = 0x1017ab6dca2}, {pos = 2724624, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 563425336, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 549337224, user_data = 0x2194d408}, {pos = 549337040, events = 8, fd = 549336640, user_data = 0x1}, {pos = 549336968, events = 8, fd = 32, user_data = 0x820be3630}, {pos = 2058803827, events = 257, fd = 549336912, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821953038}, {pos = 1, events = 8, fd = 563401736, user_data = 0x82c905858}, {pos = 549337224, events = 8, fd = 549337040, user_data = 0x820be3640}, {pos = 0, events = 0, fd = 563372040, user_data = 0x20}, {pos = 549337024, events = 8, fd = 2058779367, user_data = 0x821946008}, {pos = 563373064, events = 8, fd = 563374088, user_data = 0x821946c08}, {pos = 563388424, events = 8, fd = 563389448, user_data = 0x82194a808}, {pos = 563391496, events = 8, fd = 563392520, user_data = 0x82194b408}, {pos = 563394568, events = 8, fd = 563395592, user_data = 0x82194c008}, {pos = 563397640, events = 8, fd = 563398664, user_data = 0x82194cc08}, {pos = 563400712, events = 8, fd = 563401736, user_data = 0x82194d808}, {pos = 563403784, events = 8, fd = 563404808, user_data = 0x82194e408}, {pos = 563406856, events = 8, fd = 563407880, user_data = 0x82194f008}, {pos = 563409928, events = 8, fd = 563410952, user_data = 0x82194fc08}, {pos = 563417096, events = 8, fd = 563418120, user_data = 0x821951808}, {pos = 563420168, events = 8, fd = 563372040, user_data = 0x299310}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821953038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 549337224, events = 8, fd = 549336640, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 563425336, user_data = 0x1}, {pos = 563372040, events = 8, fd = 298, user_data = 0x820be3870}, {pos = 2058778095, events = 257, fd = 2724624, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 563425336, user_data = 0x1}, {pos = 563401736, events = 8, fd = 901025792, user_data = 0x1}, {pos = 901026196, events = 8, fd = 0, user_data = 0x820be3840}, {pos = 721409388, events = 8, fd = 1, user_data = 0x835b49000}, {pos = 549337200, events = 8, fd = 721405698, user_data = 0x82ca37170 }, {pos = 12538656, events = 0, fd = 748908912, user_data = 0x82194d408}, {pos = 549337424, events = 8, fd = 2058777566, user_data = 0x835b67800}, {pos = 1, events = 8, fd = 2058777182, user_data = 0x821946008}, {pos = 549337208, events = 8, fd = 549337424, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 2058856848, user_data = 0x0}, {pos = 549323647, events = 8, fd = 8172343, user_data = 0x820be3900}, {pos = 721368080, events = 8, fd = 749572144, user_data = 0x82cadb310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820be3930}, {pos = 721410973, events = 8, fd = 901025792, user_data = 0x1ed8}, {pos = 549337488, events = 8, fd = 721377530, user_data = 0x0}, {pos = 0, events = 0, fd = 1204506916, user_data = 0x0}} [16:12:10.476] last_touch_time = 1740585962 [16:12:10.476] last_lockfile_recheck_time = 1740585962 [16:12:10.476] nevents = 1 [16:12:10.476] #21 0x00000000008a3fa4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820be3f80) at ../src/backend/postmaster/postmaster.c:1386 [16:12:10.476] userDoption = [16:12:10.476] listen_addr_saved = false [16:12:10.476] output_config_variable = [16:12:10.476] opt = [16:12:10.476] status = [16:12:10.476] #22 0x00000000007d84d0 in main (argc=8, argv=0x820be3f80) at ../src/backend/main/main.c:230 [16:12:10.476] do_check_root = [16:12:10.476] dispatch_option = DISPATCH_POSTMASTER [16:12:10.485] [16:12:10.485] [16:12:10.485] [16:12:10.544] dumping /tmp/cores/postgres.11542.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:12:10.662] [New LWP 101918] [16:12:10.723] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [16:12:10.723] Program terminated with signal SIGABRT, Aborted. [16:12:10.723] Sent by thr_kill() from pid 11542 and user 1003. [16:12:10.723] #0 0x000000082c6e941a in thr_kill () from /lib/libc.so.7 [16:12:10.755] [16:12:10.755] Thread 1 (LWP 101918): [16:12:10.755] #0 0x000000082c6e941a in thr_kill () from /lib/libc.so.7 [16:12:10.755] No symbol table info available. [16:12:10.755] #1 0x000000082c662e64 in raise () from /lib/libc.so.7 [16:12:10.755] No symbol table info available. [16:12:10.755] #2 0x000000082c7136f9 in abort () from /lib/libc.so.7 [16:12:10.755] No symbol table info available. [16:12:10.755] #3 0x0000000000aafe65 in ExceptionalCondition (conditionName=0x2eea18 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [16:12:10.755] No locals. [16:12:10.755] #4 0x0000000000770854 in standard_ExecutorStart (queryDesc=0x837affbd0, eflags=0) at ../src/backend/executor/execMain.c:203 [16:12:10.755] estate = 0x837c0a100 [16:12:10.755] oldcontext = 0x84338dc00 [16:12:10.755] #5 0x0000000000703fd1 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [16:12:10.755] copied_query = [16:12:10.755] rewritten = [16:12:10.755] plan = 0x837aff778 [16:12:10.755] queryDesc = 0x837affbd0 [16:12:10.755] processed = [16:12:10.755] __error = [16:12:10.755] __error = [16:12:10.755] #6 RefreshMatViewByOid (matviewOid=28296, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [16:12:10.755] dest = [16:12:10.755] save_userid = 10 [16:12:10.755] save_sec_context = 0 [16:12:10.755] processed = 0 [16:12:10.755] matviewRel = 0x84349ddf8 [16:12:10.755] relowner = 10 [16:12:10.755] save_nestlevel = 2 [16:12:10.755] rule = [16:12:10.755] actions = [16:12:10.755] dataQuery = [16:12:10.755] tableSpace = [16:12:10.755] relpersistence = [16:12:10.755] OIDNewHeap = 28303 [16:12:10.755] address = [16:12:10.755] #7 0x0000000000703ba6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [16:12:10.755] lockmode = [16:12:10.755] matviewOid = 0 [16:12:10.755] #8 0x00000000006da9fc in ExecCreateTableAs (pstate=pstate@entry=0x84338dd00, stmt=stmt@entry=0x837bd8fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82100c190) at ../src/backend/commands/createas.c:351 [16:12:10.755] refresh = 0x0 [16:12:10.755] query = 0x8433f5018 [16:12:10.755] into = 0x8433f5360 [16:12:10.755] jstate = 0x0 [16:12:10.755] do_refresh = false [16:12:10.755] address = [16:12:10.755] dest = [16:12:10.755] is_matview = [16:12:10.755] #9 0x0000000000956c1e in ProcessUtilitySlow (pstate=pstate@entry=0x84338dd00, pstmt=pstmt@entry=0x837a3ea68, queryString=queryString@entry=0x837a3d100 "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=0x82100c190) at ../src/backend/tcop/utility.c:1678 [16:12:10.755] _local_sigjmp_buf = {{_sjb = {9790540, 0, 34913435048, 34913435424, 34913435056, 12647432, 0, 35487538432, 12518271, 1, 4294967295, 34359738368}}} [16:12:10.755] _save_exception_stack = 0x82100c080 [16:12:10.755] _save_context_stack = 0x0 [16:12:10.755] _do_rethrow = false [16:12:10.755] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [16:12:10.755] parsetree = 0x837bd8fd0 [16:12:10.755] commandCollected = false [16:12:10.755] needCleanup = false [16:12:10.755] address = [16:12:10.755] isTopLevel = [16:12:10.755] isCompleteQuery = [16:12:10.755] #10 0x000000000095559b in standard_ProcessUtility (pstmt=0x837a3ea68, queryString=0x837a3d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8433f5848, qc=0x82100c190) at ../src/backend/tcop/utility.c:1033 [16:12:10.755] isAtomicContext = false [16:12:10.755] parsetree = 0x837bd8fd0 [16:12:10.755] readonly_flags = [16:12:10.755] pstate = 0x84338dd00 [16:12:10.755] isTopLevel = [16:12:10.755] #11 0x0000000000955028 in ProcessUtility (pstmt=0x18e1e, queryString=0x6 , readOnlyTree=, context=745444346, params=0x0, queryEnv=0x0, dest=0x8433f5848, qc=0x82100c190) at ../src/backend/tcop/utility.c:523 [16:12:10.755] No locals. [16:12:10.755] #12 0x0000000000954ad3 in PortalRunUtility (portal=0x837ae0100, pstmt=0x837a3ea68, isTopLevel=, setHoldSnapshot=, dest=0x8433f5848, qc=0x82100c190) at ../src/backend/tcop/pquery.c:1184 [16:12:10.755] No locals. [16:12:10.755] #13 0x0000000000954164 in PortalRunMulti (portal=portal@entry=0x837ae0100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8433f5848, altdest=altdest@entry=0x8433f5848, qc=qc@entry=0x82100c190) at ../src/backend/tcop/pquery.c:1355 [16:12:10.755] pstmt = 0x837a3ea68 [16:12:10.755] stmtlist_item__state = {l = 0x8433f57f8, i = 0} [16:12:10.755] active_snapshot_set = false [16:12:10.755] query_index = 0 [16:12:10.755] stmtlist_item = 0x8433f5810 [16:12:10.755] #14 0x0000000000953a21 in PortalRun (portal=portal@entry=0x837ae0100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8433f5848, altdest=altdest@entry=0x8433f5848, qc=qc@entry=0x82100c190) at ../src/backend/tcop/pquery.c:819 [16:12:10.755] _local_sigjmp_buf = {{_sjb = {9779608, 35293888768, 34913435768, 34913436016, 34913435776, 12647432, 34913436048, 12576392, 34913387391, 34913435983, 35293896960, 34359738368}}} [16:12:10.755] _save_exception_stack = 0x82100c260 [16:12:10.755] _save_context_stack = 0x0 [16:12:10.755] _do_rethrow = false [16:12:10.755] saveTopTransactionResourceOwner = 0x837b2ff98 [16:12:10.755] saveTopTransactionContext = 0x837ae4000 [16:12:10.755] saveActivePortal = 0x0 [16:12:10.755] saveResourceOwner = 0x837b2ff98 [16:12:10.755] savePortalContext = 0x0 [16:12:10.755] saveMemoryContext = 0x837ae4000 [16:12:10.755] result = [16:12:10.755] nprocessed = [16:12:10.755] #15 0x00000000009527f1 in exec_simple_query (query_string=query_string@entry=0x837a3d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [16:12:10.755] cmdtaglen = 24 [16:12:10.755] snapshot_set = [16:12:10.755] per_parsetree_context = 0x0 [16:12:10.755] plantree_list = [16:12:10.755] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:12:10.755] format = 0 [16:12:10.755] parsetree = 0x837a3e6a8 [16:12:10.755] commandTag = [16:12:10.755] cmdtagname = [16:12:10.755] querytree_list = [16:12:10.755] portal = 0x837ae0100 [16:12:10.755] receiver = 0x8433f5848 [16:12:10.755] parsetree_item__state = {l = 0x837a3ea18, i = 0} [16:12:10.755] msec_str = "\000\000\000\000\b", '\000' , "\003<\277g\000\000\000\000DE\232\027o\373\206," [16:12:10.755] dest = DestRemote [16:12:10.755] was_logged = [16:12:10.755] oldcontext = 0x837ae4000 [16:12:10.755] parsetree_list = 0x837a3ea18 [16:12:10.755] use_implicit_block = false [16:12:10.755] parsetree_item = 0x837a3ea30 [16:12:10.755] save_log_statement_stats = [16:12:10.755] #16 0x0000000000950463 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4689 [16:12:10.755] query_string = 0x837a3d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [16:12:10.755] input_message = {data = 0x837a3d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [16:12:10.755] firstchar = [16:12:10.755] local_sigjmp_buf = {{_sjb = {9763078, 34913436256, 34913436216, 34913436800, 12656184, 1, 8192, 8388608, 34913387391, 0, 0, 1}}} [16:12:10.755] send_ready_for_query = false [16:12:10.755] idle_in_transaction_timeout_enabled = false [16:12:10.755] idle_session_timeout_enabled = false [16:12:10.755] #17 0x000000000094adf9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [16:12:10.755] bsdata = [16:12:10.755] #18 0x00000000008a17c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=18, startup_data=startup_data@entry=0x82100cf90, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82100cee0) at ../src/backend/postmaster/launch_backend.c:274 [16:12:10.755] pid = [16:12:10.755] #19 0x00000000008a5b6b in BackendStartup (client_sock=0x82100cee0) at ../src/backend/postmaster/postmaster.c:3519 [16:12:10.755] startup_data = {canAcceptConnections = CAC_OK} [16:12:10.755] bn = 0x837afe368 [16:12:10.755] cac = CAC_OK [16:12:10.755] pid = [16:12:10.755] __error = [16:12:10.755] save_errno = [16:12:10.755] __error = [16:12:10.755] __error = [16:12:10.755] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [16:12:10.755] 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' , "@\317\000!\b\000\000\000h\225\202-\b\000\000\000\346\000\000\000\000\000\000\000^\037\203-\b", '\000' , "\200\317\000!\b\000\000\000T\025\212\000\000\000\000\000\220\317\000!\b", '\000' }, salen = 16}} [16:12:10.755] i = 0 [16:12:10.755] now = [16:12:10.755] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 553700640, user_data = 0x0}, {pos = 0, events = 0, fd = 1114998270, user_data = 0x2e069984230a}, {pos = 744236960, events = 8, fd = 744308088, user_data = 0x82100c9a8}, {pos = 553699872, events = 8, fd = 553699752, user_data = 0x2e069984230a}, {pos = 744215432, events = 8, fd = 744308088, user_data = 0x82100c9d8}, {pos = 553699920, events = 8, fd = 553699800, user_data = 0x82c5cc194}, {pos = 569377800, events = 8, fd = 744276372, user_data = 0x82100ca40}, {pos = -1719413702, events = 11782, fd = 746098736, user_data = 0x1}, {pos = 553699952, events = 8, fd = -1719393526, user_data = 0x82c5b5858}, {pos = 744308088, events = 8, fd = 553699912, user_data = 0x82100cac0}, {pos = 553699912, events = 8, fd = 744271116, user_data = 0x821f00408}, {pos = 744271116, events = 8, fd = 553700016, user_data = 0x2e069983d43a}, {pos = 553700056, events = 8, fd = 553700504, user_data = 0x82100cac0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1041377095, fd = 569401400, user_data = 0x800000001}, {pos = 569377800, events = 8, fd = 744215432, user_data = 0x821f05288}, {pos = 744183896, events = 8, fd = 569377800, user_data = 0x82100cb48}, {pos = 553700616, events = 8, fd = 553700144, user_data = 0x2e0699841ca2}, {pos = 2724624, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 569401400, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 553700872, user_data = 0x21f00408}, {pos = 553700688, events = 8, fd = 553700288, user_data = 0x1}, {pos = 553700616, events = 8, fd = 32, user_data = 0x82100cbb0}, {pos = -1719395725, events = 11782, fd = 553700560, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821f06038}, {pos = 1, events = 8, fd = 569377800, user_data = 0x82c5b5858}, {pos = 553700872, events = 8, fd = 553700688, user_data = 0x82100cbc0}, {pos = 0, events = 0, fd = 569348104, user_data = 0x20}, {pos = 553700672, events = 8, fd = -1719420185, user_data = 0x821ef9008}, {pos = 569349128, events = 8, fd = 569350152, user_data = 0x821ef9c08}, {pos = 569364488, events = 8, fd = 569365512, user_data = 0x821efd808}, {pos = 569367560, events = 8, fd = 569368584, user_data = 0x821efe408}, {pos = 569370632, events = 8, fd = 569371656, user_data = 0x821eff008}, {pos = 569373704, events = 8, fd = 569374728, user_data = 0x821effc08}, {pos = 569376776, events = 8, fd = 569377800, user_data = 0x821f00808}, {pos = 569379848, events = 8, fd = 569380872, user_data = 0x821f01408}, {pos = 569382920, events = 8, fd = 569383944, user_data = 0x821f02008}, {pos = 569385992, events = 8, fd = 569387016, user_data = 0x821f02c08}, {pos = 569393160, events = 8, fd = 569394184, user_data = 0x821f04808}, {pos = 569396232, events = 8, fd = 569348104, user_data = 0x299310}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821f06038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 553700872, events = 8, fd = 553700288, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 569401400, user_data = 0x1}, {pos = 569348104, events = 8, fd = 298, user_data = 0x82100cdf0}, {pos = -1719421457, events = 11782, fd = 2724624, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 569401400, user_data = 0x1}, {pos = 569377800, events = 8, fd = 933416960, user_data = 0x1}, {pos = 933417364, events = 8, fd = 0, user_data = 0x82100cdc0}, {pos = 763565420, events = 8, fd = 1, user_data = 0x837a2d000}, {pos = 553700848, events = 8, fd = 763561730, user_data = 0x82c6e7170 }, {pos = 12538656, events = 0, fd = 745435504, user_data = 0x821f00408}, {pos = 553701072, events = 8, fd = -1719421986, user_data = 0x837a4b800}, {pos = 1, events = 8, fd = -1719422370, user_data = 0x821ef9008}, {pos = 553700856, events = 8, fd = 553701072, user_data = 0x1ab8}, {pos = 11, events = 0, fd = -1719342704, user_data = 0x0}, {pos = 553649023, events = 8, fd = 8172343, user_data = 0x82100ce80}, {pos = 763524112, events = 8, fd = 746098736, user_data = 0x82c78b310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82100ceb0}, {pos = 763567005, events = 8, fd = 933416960, user_data = 0x1ef1}, {pos = 553701136, events = 8, fd = 763533562, user_data = 0x0}, {pos = 0, events = 0, fd = 1114998270, user_data = 0x0}} [16:12:10.755] last_touch_time = 1740585962 [16:12:10.755] last_lockfile_recheck_time = 1740585962 [16:12:10.755] nevents = 1 [16:12:10.755] #21 0x00000000008a3fa4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82100d500) at ../src/backend/postmaster/postmaster.c:1386 [16:12:10.755] userDoption = [16:12:10.755] listen_addr_saved = false [16:12:10.755] output_config_variable = [16:12:10.755] opt = [16:12:10.755] status = [16:12:10.755] #22 0x00000000007d84d0 in main (argc=4, argv=0x82100d500) at ../src/backend/main/main.c:230 [16:12:10.755] do_check_root = [16:12:10.755] dispatch_option = DISPATCH_POSTMASTER [16:12:10.764] [16:12:10.764] [16:12:10.764] [16:12:10.821] dumping /tmp/cores/postgres.18358.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:12:10.938] [New LWP 101906] [16:12:10.997] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [16:12:10.997] Program terminated with signal SIGABRT, Aborted. [16:12:10.997] Sent by thr_kill() from pid 18358 and user 1003. [16:12:10.997] #0 0x000000082aebb41a in thr_kill () from /lib/libc.so.7 [16:12:11.034] [16:12:11.034] Thread 1 (LWP 101906): [16:12:11.034] #0 0x000000082aebb41a in thr_kill () from /lib/libc.so.7 [16:12:11.034] No symbol table info available. [16:12:11.034] #1 0x000000082ae34e64 in raise () from /lib/libc.so.7 [16:12:11.034] No symbol table info available. [16:12:11.034] #2 0x000000082aee56f9 in abort () from /lib/libc.so.7 [16:12:11.034] No symbol table info available. [16:12:11.034] #3 0x0000000000aafe65 in ExceptionalCondition (conditionName=0x2eea18 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=203) at ../src/backend/utils/error/assert.c:66 [16:12:11.034] No locals. [16:12:11.034] #4 0x0000000000770854 in standard_ExecutorStart (queryDesc=0x83410ebd0, eflags=0) at ../src/backend/executor/execMain.c:203 [16:12:11.034] estate = 0x83726f100 [16:12:11.034] oldcontext = 0x8340bdc00 [16:12:11.034] #5 0x00000008363429c3 in pgss_ExecutorStart (queryDesc=0x83410ebd0, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:998 [16:12:11.034] plan_valid = [16:12:11.034] #6 0x0000000000703fd1 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [16:12:11.034] copied_query = [16:12:11.034] rewritten = [16:12:11.034] plan = 0x83410e778 [16:12:11.034] queryDesc = 0x83410ebd0 [16:12:11.034] processed = [16:12:11.034] __error = [16:12:11.034] __error = [16:12:11.034] #7 RefreshMatViewByOid (matviewOid=28658, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [16:12:11.034] dest = [16:12:11.034] save_userid = 10 [16:12:11.034] save_sec_context = 0 [16:12:11.034] processed = 0 [16:12:11.034] matviewRel = 0x8373045c8 [16:12:11.034] relowner = 10 [16:12:11.034] save_nestlevel = 2 [16:12:11.034] rule = [16:12:11.034] actions = [16:12:11.034] dataQuery = [16:12:11.034] tableSpace = [16:12:11.034] relpersistence = [16:12:11.034] OIDNewHeap = 28665 [16:12:11.034] address = [16:12:11.034] #8 0x0000000000703ba6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [16:12:11.034] lockmode = [16:12:11.034] matviewOid = 0 [16:12:11.034] #9 0x00000000006da9fc in ExecCreateTableAs (pstate=pstate@entry=0x8340bdd00, stmt=stmt@entry=0x834097fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821495110) at ../src/backend/commands/createas.c:351 [16:12:11.034] refresh = 0x0 [16:12:11.034] query = 0x8340220c8 [16:12:11.034] into = 0x834097f40 [16:12:11.034] jstate = 0x0 [16:12:11.034] do_refresh = false [16:12:11.034] address = [16:12:11.034] dest = [16:12:11.034] is_matview = [16:12:11.034] #10 0x0000000000956c1e in ProcessUtilitySlow (pstate=pstate@entry=0x8340bdd00, pstmt=pstmt@entry=0x834097e30, queryString=queryString@entry=0x833f3d100 "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=0x821495110) at ../src/backend/tcop/utility.c:1678 [16:12:11.034] _local_sigjmp_buf = {{_sjb = {9790540, 0, 34918189912, 34918190288, 34918189920, 12647432, 0, 35232931072, 4827918601126937471, 4, 123, 0}}} [16:12:11.034] _save_exception_stack = 0x821494e20 [16:12:11.034] _save_context_stack = 0x0 [16:12:11.034] _do_rethrow = false [16:12:11.034] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [16:12:11.034] parsetree = 0x834097fd0 [16:12:11.034] commandCollected = false [16:12:11.034] needCleanup = false [16:12:11.034] address = [16:12:11.034] isTopLevel = [16:12:11.034] isCompleteQuery = [16:12:11.034] #11 0x000000000095559b in standard_ProcessUtility (pstmt=0x834097e30, queryString=queryString@entry=0x833f3d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834022868, qc=0x821495110) at ../src/backend/tcop/utility.c:1033 [16:12:11.034] isAtomicContext = false [16:12:11.034] parsetree = 0x834097fd0 [16:12:11.034] readonly_flags = [16:12:11.034] pstate = 0x8340bdd00 [16:12:11.034] isTopLevel = [16:12:11.034] #12 0x0000000836342f71 in pgss_ProcessUtility (pstmt=0x834097e30, queryString=0x833f3d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834022868, qc=0x821495110) at ../contrib/pg_stat_statements/pg_stat_statements.c:1179 [16:12:11.034] _local_sigjmp_buf = {{_sjb = {35269127850, 34918190624, 34918190424, 34918190896, 35232775728, 0, 12647432, 34918191104, 34918171519, 9679272, 12572352, 0}}} [16:12:11.034] _save_exception_stack = 0x821495000 [16:12:11.034] _save_context_stack = 0x0 [16:12:11.034] _do_rethrow = false [16:12:11.034] bufusage = {shared_blks_hit = 35269127850, shared_blks_read = 34918190624, shared_blks_dirtied = 34918190424, shared_blks_written = 34918190896, local_blks_hit = 35232775728, local_blks_read = 0, local_blks_dirtied = 12647432, local_blks_written = 34918191104, temp_blks_read = 34918171519, temp_blks_written = 9679272, shared_blk_read_time = {ticks = 12572352}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 34918190880}, local_blk_write_time = {ticks = 9590554}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 549755813888}} [16:12:11.034] walusage_start = {wal_records = 9018, wal_fpi = 161, wal_bytes = 1440498, wal_buffers_full = 5} [16:12:11.034] duration = [16:12:11.034] bufusage_start = {shared_blks_hit = 155255, shared_blks_read = 9678, shared_blks_dirtied = 2730, shared_blks_written = 2250, 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}} [16:12:11.034] walusage = {wal_records = 34918190672, wal_fpi = 8279858, wal_bytes = 1, wal_buffers_full = 549767770967} [16:12:11.034] start = {ticks = -199900535435} [16:12:11.034] rows = [16:12:11.034] saved_queryId = 7566811930394970136 [16:12:11.034] parsetree = [16:12:11.034] saved_stmt_location = 0 [16:12:11.034] saved_stmt_len = 69 [16:12:11.034] enabled = [16:12:11.034] #13 0x0000000000954ad3 in PortalRunUtility (portal=0x833fe0100, pstmt=0x834097e30, isTopLevel=, setHoldSnapshot=, dest=0x834022868, qc=0x821495110) at ../src/backend/tcop/pquery.c:1184 [16:12:11.034] No locals. [16:12:11.034] #14 0x0000000000954164 in PortalRunMulti (portal=portal@entry=0x833fe0100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x834022868, altdest=altdest@entry=0x834022868, qc=qc@entry=0x821495110) at ../src/backend/tcop/pquery.c:1355 [16:12:11.034] pstmt = 0x834097e30 [16:12:11.034] stmtlist_item__state = {l = 0x834022818, i = 0} [16:12:11.034] active_snapshot_set = false [16:12:11.034] query_index = 0 [16:12:11.034] stmtlist_item = 0x834022830 [16:12:11.034] #15 0x0000000000953a21 in PortalRun (portal=portal@entry=0x833fe0100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x834022868, altdest=altdest@entry=0x834022868, qc=qc@entry=0x821495110) at ../src/backend/tcop/pquery.c:819 [16:12:11.034] _local_sigjmp_buf = {{_sjb = {9779608, 35232022784, 34918191096, 34918191344, 34918191104, 12647432, 34918191376, 12576392, 34918171519, 34918191311, 35232030976, 34359738368}}} [16:12:11.034] _save_exception_stack = 0x8214951e0 [16:12:11.034] _save_context_stack = 0x0 [16:12:11.034] _do_rethrow = false [16:12:11.034] saveTopTransactionResourceOwner = 0x834035f58 [16:12:11.034] saveTopTransactionContext = 0x833fe4000 [16:12:11.034] saveActivePortal = 0x0 [16:12:11.034] saveResourceOwner = 0x834035f58 [16:12:11.034] savePortalContext = 0x0 [16:12:11.034] saveMemoryContext = 0x833fe4000 [16:12:11.034] result = [16:12:11.034] nprocessed = [16:12:11.034] #16 0x00000000009527f1 in exec_simple_query (query_string=query_string@entry=0x833f3d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1272 [16:12:11.034] cmdtaglen = 24 [16:12:11.034] snapshot_set = [16:12:11.034] per_parsetree_context = 0x0 [16:12:11.034] plantree_list = [16:12:11.034] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:12:11.034] format = 0 [16:12:11.034] parsetree = 0x833f3e6a8 [16:12:11.034] commandTag = [16:12:11.034] cmdtagname = [16:12:11.034] querytree_list = [16:12:11.034] portal = 0x833fe0100 [16:12:11.034] receiver = 0x834022868 [16:12:11.034] parsetree_item__state = {l = 0x833f3ea18, i = 0} [16:12:11.034] msec_str = "\000\000\000\000\b", '\000' , ",<\277g\000\000\000\000\n\252:F\353E~\226" [16:12:11.034] dest = DestRemote [16:12:11.034] was_logged = [16:12:11.034] oldcontext = 0x833fe4000 [16:12:11.034] parsetree_list = 0x833f3ea18 [16:12:11.034] use_implicit_block = false [16:12:11.034] parsetree_item = 0x833f3ea30 [16:12:11.034] save_log_statement_stats = [16:12:11.034] #17 0x0000000000950463 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4689 [16:12:11.034] query_string = 0x833f3d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [16:12:11.034] input_message = {data = 0x833f3d100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [16:12:11.034] firstchar = [16:12:11.034] local_sigjmp_buf = {{_sjb = {9763078, 34918191584, 34918191544, 34918192128, 12656184, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [16:12:11.034] send_ready_for_query = false [16:12:11.034] idle_in_transaction_timeout_enabled = false [16:12:11.034] idle_session_timeout_enabled = false [16:12:11.034] #18 0x000000000094adf9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [16:12:11.034] bsdata = [16:12:11.034] #19 0x00000000008a17c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x821495f10, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821495e60) at ../src/backend/postmaster/launch_backend.c:274 [16:12:11.034] pid = [16:12:11.034] #20 0x00000000008a5b6b in BackendStartup (client_sock=0x821495e60) at ../src/backend/postmaster/postmaster.c:3519 [16:12:11.034] startup_data = {canAcceptConnections = CAC_OK} [16:12:11.034] bn = 0x8340211a8 [16:12:11.034] cac = CAC_OK [16:12:11.034] pid = [16:12:11.034] __error = [16:12:11.034] save_errno = [16:12:11.034] __error = [16:12:11.034] __error = [16:12:11.034] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [16:12:11.034] 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' , "\300^I!\b\000\000\000h%\304)\b\000\000\000W\000\000\000\000\000\000\000^\257\304)\b", '\000' , "_I!\b\000\000\000T\025\212\000\000\000\000\000\020_I!\b", '\000' }, salen = 16}} [16:12:11.034] i = 0 [16:12:11.034] now = [16:12:11.034] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 872011224, events = 8, fd = 558455968, user_data = 0x0}, {pos = 168907530, events = 11647, fd = 718882720, user_data = 0x82ada5d78}, {pos = 558455064, events = 8, fd = 558455184, user_data = 0x821495918}, {pos = 168907530, events = 11647, fd = 718861192, user_data = 0x82ada5d78}, {pos = 558455112, events = 8, fd = 558455232, user_data = 0x821495948}, {pos = 718922132, events = 8, fd = 559129608, user_data = 0x82ad9e194}, {pos = 558455216, events = 8, fd = 168887354, user_data = 0x821495950}, {pos = 700711952, events = 8, fd = 720744496, user_data = 0x2d7f0a11530a}, {pos = 718829656, events = 8, fd = 718953848, user_data = 0x8214959b8}, {pos = 558455344, events = 8, fd = 558455224, user_data = 0x82ad9cd0c}, {pos = 559129608, events = 8, fd = 718916876, user_data = 0x821495a20}, {pos = 168887354, events = 11647, fd = 558455368, user_data = 0x821495c18}, {pos = 558455344, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821540038}, {pos = 1, events = 1124087395, fd = 559129608, user_data = 0x82ad8f388}, {pos = 559151048, events = 8, fd = 0, user_data = 0x0}, {pos = 558455480, events = 8, fd = 558455944, user_data = 0x821495aa0}, {pos = 168905890, events = 11647, fd = 2724624, user_data = 0x6d68b}, {pos = 2090263927, events = 1124087395, fd = 559153208, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821495d88}, {pos = 559129608, events = 3, fd = 558456016, user_data = 0x82153f828}, {pos = 656, events = 0, fd = 558455944, user_data = 0x821495ab8}, {pos = 558455584, events = 8, fd = 168905499, user_data = 0x821495c50}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 559153208, events = 8, fd = 1, user_data = 0x82153a408}, {pos = 718829656, events = 8, fd = 558456200, user_data = 0x821495cd0}, {pos = 558455600, events = 8, fd = 0, user_data = 0x821533008}, {pos = 33, events = 0, fd = 558456000, user_data = 0x2d7f0a10eae7}, {pos = 559099912, events = 8, fd = 559100936, user_data = 0x821533808}, {pos = 559102984, events = 8, fd = 559116296, user_data = 0x821537408}, {pos = 559118344, events = 8, fd = 559119368, user_data = 0x821538008}, {pos = 559121416, events = 8, fd = 559122440, user_data = 0x821538c08}, {pos = 559124488, events = 8, fd = 559125512, user_data = 0x821539808}, {pos = 559127560, events = 8, fd = 559128584, user_data = 0x82153a408}, {pos = 559130632, events = 8, fd = 559131656, user_data = 0x82153b008}, {pos = 559133704, events = 8, fd = 559134728, user_data = 0x82153bc08}, {pos = 559136776, events = 8, fd = 559137800, user_data = 0x82153c808}, {pos = 559139848, events = 8, fd = 559144968, user_data = 0x82153e408}, {pos = 559147016, events = 8, fd = 559148040, user_data = 0x821541408}, {pos = 952283000, events = 0, fd = 559099912, user_data = 0x299310}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821540038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558456200, events = 8, fd = 558455600, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 559153208, user_data = 0x1}, {pos = 559099912, events = 8, fd = 298, user_data = 0x821495d70}, {pos = 168879599, events = 11647, fd = 2724624, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 559153208, user_data = 0x1}, {pos = 559129608, events = 8, fd = 871550976, user_data = 0x1}, {pos = 871551380, events = 8, fd = 0, user_data = 0x821495d40}, {pos = 700753260, events = 8, fd = 1, user_data = 0x833f2d000}, {pos = 558456176, events = 8, fd = 700749570, user_data = 0x82aeb9170 }, {pos = 12538656, events = 0, fd = 720081264, user_data = 0x82153a408}, {pos = 558456400, events = 8, fd = 168879070, user_data = 0x833f4b800}, {pos = 1, events = 8, fd = 168878686, user_data = 0x821533008}, {pos = 558456184, events = 8, fd = 558456400, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 168958352, user_data = 0x0}, {pos = 558433151, events = 8, fd = 8172343, user_data = 0x821495e00}, {pos = 700711952, events = 8, fd = 720744496, user_data = 0x82af5d310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821495e30}, {pos = 700754845, events = 8, fd = 871550976, user_data = 0x3918}, {pos = 558456464, events = 8, fd = 700721402, user_data = 0x0}, {pos = 0, events = 0, fd = 1756113485, user_data = 0x0}} [16:12:11.034] last_touch_time = 1740586000 [16:12:11.034] last_lockfile_recheck_time = 1740586000 [16:12:11.034] nevents = 1 [16:12:11.034] #22 0x00000000008a3fa4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821496488) at ../src/backend/postmaster/postmaster.c:1386 [16:12:11.034] userDoption = [16:12:11.034] listen_addr_saved = false [16:12:11.034] output_config_variable = [16:12:11.034] opt = [16:12:11.034] status = [16:12:11.034] #23 0x00000000007d84d0 in main (argc=4, argv=0x821496488) at ../src/backend/main/main.c:230 [16:12:11.034] do_check_root = [16:12:11.034] dispatch_option = DISPATCH_POSTMASTER