[01:17:44.689] src/tools/ci/cores_backtrace.sh linux /tmp/cores [01:17:44.919] dumping /tmp/cores/postgres-6-29986.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:17:45.169] [New LWP 29986] [01:17:45.169] [01:17:45.169] This GDB supports auto-downloading debuginfo from the following URLs: [01:17:45.169] [01:17:45.169] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:17:45.169] Debuginfod has been disabled. [01:17:45.169] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:17:45.304] [Thread debugging using libthread_db enabled] [01:17:45.304] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:17:45.304] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [01:17:45.304] Program terminated with signal SIGABRT, Aborted. [01:17:45.304] #0 0x00007fc0d6aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:46.223] [01:17:46.223] Thread 1 (Thread 0x7fc0d7232f00 (LWP 29986)): [01:17:46.223] #0 0x00007fc0d6aa9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:46.223] No symbol table info available. [01:17:46.223] #1 0x00007fc0d6a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:46.223] No symbol table info available. [01:17:46.223] #2 0x00007fc0d6a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:46.223] No symbol table info available. [01:17:46.223] #3 0x00005645d58b09fe in ExceptionalCondition (conditionName=conditionName@entry=0x5645d5b24e15 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5645d5b24330 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [01:17:46.223] No locals. [01:17:46.223] #4 0x00005645d5233f76 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5645ee341d60, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [01:17:46.223] estate = 0x5645ee2fd160 [01:17:46.223] oldcontext = 0x5645ee2d54f0 [01:17:46.223] __func__ = "standard_ExecutorStart" [01:17:46.223] #5 0x00005645d5234152 in ExecutorStart (queryDesc=queryDesc@entry=0x5645ee341d60, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [01:17:46.223] No locals. [01:17:46.223] #6 0x00005645d515a9b0 in refresh_matview_datafill (dest=0x5645ee2ca118, query=, query@entry=0x5645ee293890, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [01:17:46.223] rewritten = [01:17:46.223] plan = 0x5645ee341298 [01:17:46.223] queryDesc = 0x5645ee341d60 [01:17:46.223] copied_query = [01:17:46.223] processed = [01:17:46.223] __func__ = "refresh_matview_datafill" [01:17:46.223] #7 0x00005645d515cd17 in RefreshMatViewByOid (matviewOid=27532, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [01:17:46.223] dest = [01:17:46.223] matviewRel = 0x7fc0cb3c3bb8 [01:17:46.223] rule = [01:17:46.223] actions = [01:17:46.223] dataQuery = 0x5645ee293890 [01:17:46.223] tableSpace = [01:17:46.223] relowner = 10 [01:17:46.223] OIDNewHeap = 27541 [01:17:46.223] processed = 0 [01:17:46.223] relpersistence = 112 'p' [01:17:46.223] save_userid = 10 [01:17:46.223] save_sec_context = 0 [01:17:46.223] save_nestlevel = 2 [01:17:46.223] address = {classId = 0, objectId = 0, objectSubId = 0} [01:17:46.223] __func__ = "RefreshMatViewByOid" [01:17:46.223] #8 0x00005645d515ce56 in ExecRefreshMatView (stmt=0x5645ee34f9d0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:17:46.223] matviewOid = [01:17:46.223] lockmode = [01:17:46.223] #9 0x00005645d5112aa3 in ExecCreateTableAs (pstate=pstate@entry=0x5645ee2d55f0, stmt=stmt@entry=0x5645ee16a770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffcc4f632b0) at ../src/backend/commands/createas.c:351 [01:17:46.223] refresh = [01:17:46.223] query = 0x5645ee16a930 [01:17:46.223] into = 0x5645ee16a4c8 [01:17:46.223] jstate = 0x0 [01:17:46.223] is_matview = true [01:17:46.223] do_refresh = false [01:17:46.223] dest = [01:17:46.223] address = {classId = 1259, objectId = 27532, objectSubId = 0} [01:17:46.223] __func__ = "ExecCreateTableAs" [01:17:46.223] #10 0x00005645d5628fac in ProcessUtilitySlow (pstate=pstate@entry=0x5645ee2d55f0, pstmt=pstmt@entry=0x5645ee16a820, queryString=queryString@entry=0x5645ee169a30 "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=0x5645ee16b258, qc=0x7ffcc4f632b0) at ../src/backend/tcop/utility.c:1675 [01:17:46.223] _save_exception_stack = 0x7ffcc4f63170 [01:17:46.223] _save_context_stack = 0x0 [01:17:46.223] _local_sigjmp_buf = {{__jmpbuf = {0, -7842653539976908359, 94858347194224, 0, 94858347190832, 0, -4586043305431174727, -7842672671551163975}, __mask_was_saved = 0, __saved_mask = {__val = {140466025834816, 13790, 94857932163090, 1, 4294981086, 140466025834816, 94857935980665, 140466219855288, 94858347190832, 94857938305061, 94857948266114, 94857948266240, 140723612954548, 94857938499928, 94857948266129, 94857948266240}}}} [01:17:46.223] _do_rethrow = false [01:17:46.223] parsetree = 0x5645ee16a770 [01:17:46.223] isTopLevel = true [01:17:46.223] isCompleteQuery = true [01:17:46.223] needCleanup = false [01:17:46.223] commandCollected = false [01:17:46.223] address = {classId = 22085, objectId = 3994462064, objectSubId = 22085} [01:17:46.223] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:17:46.223] __func__ = "ProcessUtilitySlow" [01:17:46.223] #11 0x00005645d56275bd in standard_ProcessUtility (pstmt=0x5645ee16a820, queryString=0x5645ee169a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5645ee16b258, qc=0x7ffcc4f632b0) at ../src/backend/tcop/utility.c:1067 [01:17:46.223] parsetree = 0x5645ee16a770 [01:17:46.223] isTopLevel = true [01:17:46.223] isAtomicContext = false [01:17:46.223] pstate = 0x5645ee2d55f0 [01:17:46.223] readonly_flags = [01:17:46.223] __func__ = "standard_ProcessUtility" [01:17:46.223] #12 0x00005645d5627718 in ProcessUtility (pstmt=pstmt@entry=0x5645ee16a820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5645ee16b258, qc=0x7ffcc4f632b0) at ../src/backend/tcop/utility.c:523 [01:17:46.223] No locals. [01:17:46.223] #13 0x00005645d5622f84 in PortalRunUtility (portal=portal@entry=0x5645ee1ec680, pstmt=pstmt@entry=0x5645ee16a820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5645ee16b258, qc=qc@entry=0x7ffcc4f632b0) at ../src/backend/tcop/pquery.c:1158 [01:17:46.223] No locals. [01:17:46.223] #14 0x00005645d5623529 in PortalRunMulti (portal=portal@entry=0x5645ee1ec680, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5645ee16b258, altdest=altdest@entry=0x5645ee16b258, qc=qc@entry=0x7ffcc4f632b0) at ../src/backend/tcop/pquery.c:1315 [01:17:46.223] pstmt = 0x5645ee16a820 [01:17:46.223] stmtlist_item__state = [01:17:46.223] active_snapshot_set = false [01:17:46.223] stmtlist_item = 0x5645ee16b220 [01:17:46.223] #15 0x00005645d5623afc in PortalRun (portal=portal@entry=0x5645ee1ec680, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5645ee16b258, altdest=altdest@entry=0x5645ee16b258, qc=0x7ffcc4f632b0) at ../src/backend/tcop/pquery.c:791 [01:17:46.223] _save_exception_stack = 0x7ffcc4f63360 [01:17:46.223] _save_context_stack = 0x0 [01:17:46.223] _local_sigjmp_buf = {{__jmpbuf = {0, -7842653539766144583, 94858347726464, 94858347194344, 94858347726464, 94858347194272, -4586043305292762695, -7842672673587891783}, __mask_was_saved = 0, __saved_mask = {__val = {94857935665316, 94858347190576, 112, 4, 94857935669733, 3304469055, 4, 94858347194272, 112, 73, 94858347726464, 94858347194344, 94858347194320, 94858347194272, 94857935756936, 1}}}} [01:17:46.223] _do_rethrow = [01:17:46.223] result = [01:17:46.223] nprocessed = [01:17:46.223] saveTopTransactionResourceOwner = 0x5645ee1a9838 [01:17:46.223] saveTopTransactionContext = 0x5645ee1fd660 [01:17:46.223] saveActivePortal = 0x0 [01:17:46.223] saveResourceOwner = 0x5645ee1a9838 [01:17:46.223] savePortalContext = 0x0 [01:17:46.223] saveMemoryContext = 0x5645ee1fd660 [01:17:46.223] __func__ = "PortalRun" [01:17:46.223] #16 0x00005645d561cee8 in exec_simple_query (query_string=query_string@entry=0x5645ee169a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [01:17:46.223] cmdtaglen = 24 [01:17:46.223] snapshot_set = [01:17:46.223] per_parsetree_context = 0x0 [01:17:46.223] plantree_list = 0x5645ee16b208 [01:17:46.223] parsetree = 0x5645ee16a7a0 [01:17:46.223] commandTag = [01:17:46.223] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:17:46.223] querytree_list = [01:17:46.223] portal = 0x5645ee1ec680 [01:17:46.223] receiver = 0x5645ee16b258 [01:17:46.223] format = 0 [01:17:46.223] cmdtagname = [01:17:46.223] parsetree_item__state = [01:17:46.223] dest = DestRemote [01:17:46.223] oldcontext = 0x5645ee1fd660 [01:17:46.223] parsetree_list = 0x5645ee16a7d0 [01:17:46.223] parsetree_item = 0x5645ee16a7e8 [01:17:46.223] save_log_statement_stats = false [01:17:46.223] was_logged = true [01:17:46.223] use_implicit_block = false [01:17:46.223] msec_str = "\0205\366\304\374\177\000\000\254g\215\325EV\000\000@3\366\304\374\177\000\000G\000\000\000\000\000\000" [01:17:46.223] __func__ = "exec_simple_query" [01:17:46.223] #17 0x00005645d561fc6c in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [01:17:46.223] query_string = 0x5645ee169a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:17:46.223] firstchar = [01:17:46.223] input_message = {data = 0x5645ee169a30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:17:46.223] local_sigjmp_buf = {{__jmpbuf = {94857948274680, -7842670642800922183, 4, 140723612955920, 140723612956064, 140723612956068, -4586043305364065863, -7842672650020490823}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94858346921392, 14336, 94857948268768, 94858347448304, 140723612956064, 94857935669281, 0, 9, 2, 94857948274688, 94858346921392, 94857948268768, 140723612955920, 140723612956064, 140723612956068}}}} [01:17:46.223] send_ready_for_query = false [01:17:46.223] idle_in_transaction_timeout_enabled = false [01:17:46.223] idle_session_timeout_enabled = false [01:17:46.223] __func__ = "PostgresMain" [01:17:46.223] #18 0x00005645d5615ae2 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [01:17:46.223] bsdata = [01:17:46.223] #19 0x00005645d54c953c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffcc4f634bc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcc4f63510) at ../src/backend/postmaster/launch_backend.c:266 [01:17:46.223] pid = [01:17:46.223] #20 0x00005645d54ceff0 in BackendStartup (client_sock=client_sock@entry=0x7ffcc4f63510) at ../src/backend/postmaster/postmaster.c:3417 [01:17:46.223] bn = 0x5645ee19ea78 [01:17:46.223] pid = [01:17:46.223] startup_data = {canAcceptConnections = CAC_OK} [01:17:46.223] __func__ = "BackendStartup" [01:17:46.223] #21 0x00005645d54cf552 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [01:17:46.223] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\243\326\300\177\000\000\240\317\364\327\300\177\000\000\2705\366\304\374\177\000\000\2645\366\304\374\177", '\000' , "r`h\324EV\000\000\bGd\324EV\000\000\2006\366\304\374\177\000\000x6\366\304\374\177\000\000\225[\362\001\000\000\000\000\240\224#\327\300\177\000\000+", '\000' , "EV\000\000\200_h\324EV\000", __ss_align = 140466238514792}, salen = 2}} [01:17:46.223] i = 0 [01:17:46.223] now = [01:17:46.223] last_lockfile_recheck_time = 1730855612 [01:17:46.223] last_touch_time = 1730855612 [01:17:46.223] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x5645d4686072}, {pos = -666900888, events = 32704, fd = -685533648, user_data = 0x7fc0d83fe2e0}, {pos = 2090263927, events = 0, fd = -990497024, user_data = 0x7fc0d83d4a48}, {pos = 15, events = 0, fd = -685533648, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fc0d83fe2e0}, {pos = -990497160, events = 32764, fd = -990497152, user_data = 0x7fc0d83fe668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -300501008, events = 22085, fd = 1, user_data = 0x7ffcc4f63ba3}, {pos = -1, events = 0, fd = -693968864, user_data = 0x7fc0d7f4cfa0}, {pos = -300317848, events = 22085, fd = -300318136, user_data = 0x5645ee198021}, {pos = -667046210, events = 32704, fd = 1, user_data = 0x7fc0d83fe2e0}, {pos = 427, events = 0, fd = -706400936, user_data = 0x0}, {pos = 1, events = 0, fd = -300508600, user_data = 0x7fc0d83daebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fc0d6a2e020}, {pos = -693162560, events = 32704, fd = 16, user_data = 0x7ffcc4f63ae0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -667037254, events = 32704, fd = 0, user_data = 0x7fc0d6aaed24 }, {pos = 0, events = 0, fd = -699487904, user_data = 0x2}, {pos = 7, events = 0, fd = -300761520, user_data = 0x5645d55b3a6d }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -300508600, user_data = 0x7fc0d83daebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fc0d6a364c8}, {pos = -693408121, events = 32704, fd = -699433216, user_data = 0x7d0}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -692118432, events = 32704, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -300344768, user_data = 0x7fc0d6ab56eb}, {pos = -692135456, events = 32704, fd = -693497490, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x45a4276078900200}, {pos = -692132384, events = 32704, fd = -328, user_data = 0x0}, {pos = -300318456, events = 22085, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -300318656, events = 22085, fd = 3, user_data = 0x0}, {pos = 25908, events = 0, fd = -328, user_data = 0x0}, {pos = -300508600, events = 22085, fd = -693162029, user_data = 0x7ffcc4f63b98}, {pos = -711950824, events = 22085, fd = -699424848, user_data = 0x5645d58f68d5 }, {pos = -300318656, events = 22085, fd = -300508880, user_data = 0x5645ee198040}, {pos = -693414165, events = 32704, fd = 0, user_data = 0x5645d590853f }, {pos = -300318656, events = 1, fd = -711948664, user_data = 0x5645ee169930}, {pos = 2022703616, events = 1168385888, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -693491023, user_data = 0x7fc0d6aa14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2022703616, user_data = 0x5645ee141060}, {pos = 2022703616, events = 1168385888, fd = 11, user_data = 0x45a4276078900200}, {pos = 0, events = 0, fd = -693784007, user_data = 0x1}, {pos = -716402119, events = 22085, fd = 4194304, user_data = 0x5645d58f6769 }, {pos = -300674976, events = 22085, fd = -300508880, user_data = 0x5645ee141060}, {pos = 1, events = 0, fd = 0, user_data = 0x5645d590853f }, {pos = -300674976, events = 22085, fd = -711948664, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5645d52fdc0b }, {pos = 0, events = 0, fd = -718262453, user_data = 0xb}, {pos = -716380962, events = 22085, fd = -703046416, user_data = 0x5645ee16a2d8}} [01:17:46.224] nevents = 1 [01:17:46.224] __func__ = "ServerLoop" [01:17:46.224] #22 0x00005645d54d0cd5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5645ee127cc0) at ../src/backend/postmaster/postmaster.c:1348 [01:17:46.224] opt = [01:17:46.224] status = [01:17:46.224] userDoption = [01:17:46.224] listen_addr_saved = false [01:17:46.224] output_config_variable = [01:17:46.224] __func__ = "PostmasterMain" [01:17:46.224] #23 0x00005645d530df93 in main (argc=4, argv=0x5645ee127cc0) at ../src/backend/main/main.c:196 [01:17:46.224] do_check_root = [01:17:46.259] -e [01:17:46.259] [01:17:46.259] [01:17:46.325] dumping /tmp/cores/postgres-6-36055.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:17:46.586] [New LWP 36055] [01:17:46.586] [01:17:46.586] This GDB supports auto-downloading debuginfo from the following URLs: [01:17:46.586] [01:17:46.586] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:17:46.586] Debuginfod has been disabled. [01:17:46.586] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:17:46.700] [Thread debugging using libthread_db enabled] [01:17:46.700] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:17:46.700] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [01:17:46.700] Program terminated with signal SIGABRT, Aborted. [01:17:46.700] #0 0x00007f45166a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:47.615] [01:17:47.615] Thread 1 (Thread 0x7f45163e7f00 (LWP 36055)): [01:17:47.615] #0 0x00007f45166a9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:47.615] No symbol table info available. [01:17:47.615] #1 0x00007f451665afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:47.615] No symbol table info available. [01:17:47.615] #2 0x00007f4516645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:47.615] No symbol table info available. [01:17:47.615] #3 0x000055a5a68b79fe in ExceptionalCondition (conditionName=conditionName@entry=0x55a5a6b2be15 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55a5a6b2b330 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [01:17:47.615] No locals. [01:17:47.615] #4 0x000055a5a623af76 in standard_ExecutorStart (queryDesc=0x55a5b2e611a0, eflags=0) at ../src/backend/executor/execMain.c:194 [01:17:47.615] estate = 0x55a5b2dc8160 [01:17:47.615] oldcontext = 0x55a5b2ddd900 [01:17:47.615] __func__ = "standard_ExecutorStart" [01:17:47.615] #5 0x00007f45144276f7 in pgss_ExecutorStart (queryDesc=0x55a5b2e611a0, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [01:17:47.615] No locals. [01:17:47.615] #6 0x000055a5a623b10b in ExecutorStart (queryDesc=queryDesc@entry=0x55a5b2e611a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:133 [01:17:47.615] No locals. [01:17:47.615] #7 0x000055a5a61619b0 in refresh_matview_datafill (dest=0x55a5b2e5e1e8, query=, query@entry=0x55a5b2d41860, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [01:17:47.615] rewritten = [01:17:47.615] plan = 0x55a5b2e606a8 [01:17:47.615] queryDesc = 0x55a5b2e611a0 [01:17:47.615] copied_query = [01:17:47.615] processed = [01:17:47.615] __func__ = "refresh_matview_datafill" [01:17:47.615] #8 0x000055a5a6163d17 in RefreshMatViewByOid (matviewOid=27349, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [01:17:47.615] dest = [01:17:47.615] matviewRel = 0x7f4511f92858 [01:17:47.615] rule = [01:17:47.615] actions = [01:17:47.615] dataQuery = 0x55a5b2d41860 [01:17:47.615] tableSpace = [01:17:47.615] relowner = 10 [01:17:47.615] OIDNewHeap = 27362 [01:17:47.615] processed = 0 [01:17:47.615] relpersistence = 112 'p' [01:17:47.615] save_userid = 10 [01:17:47.615] save_sec_context = 0 [01:17:47.615] save_nestlevel = 2 [01:17:47.615] address = {classId = 0, objectId = 0, objectSubId = 0} [01:17:47.615] __func__ = "RefreshMatViewByOid" [01:17:47.615] #9 0x000055a5a6163e56 in ExecRefreshMatView (stmt=0x55a5b2e11b10, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:17:47.615] matviewOid = [01:17:47.615] lockmode = [01:17:47.615] #10 0x000055a5a6119aa3 in ExecCreateTableAs (pstate=pstate@entry=0x55a5b2ddda00, stmt=stmt@entry=0x55a5b2c35790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffc4ef9f210) at ../src/backend/commands/createas.c:351 [01:17:47.615] refresh = [01:17:47.615] query = 0x55a5b2c35950 [01:17:47.615] into = 0x55a5b2c354e8 [01:17:47.615] jstate = 0x0 [01:17:47.615] is_matview = true [01:17:47.615] do_refresh = false [01:17:47.615] dest = [01:17:47.615] address = {classId = 1259, objectId = 27349, objectSubId = 0} [01:17:47.615] __func__ = "ExecCreateTableAs" [01:17:47.615] #11 0x000055a5a662ffac in ProcessUtilitySlow (pstate=pstate@entry=0x55a5b2ddda00, pstmt=pstmt@entry=0x55a5b2c35840, queryString=queryString@entry=0x55a5b2c34a50 "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=0x55a5b2c367e8, qc=0x7ffc4ef9f210) at ../src/backend/tcop/utility.c:1675 [01:17:47.615] _save_exception_stack = 0x7ffc4ef9edc0 [01:17:47.615] _save_context_stack = 0x0 [01:17:47.615] _local_sigjmp_buf = {{__jmpbuf = {0, 2702717709956726036, 94170157111184, 0, 94170157107792, 0, 8156585196863405332, 2702672369919507732}, __mask_was_saved = 0, __saved_mask = {__val = {17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 94169948894207, 0, 5412384741217271808, 94169954967360, 94169949147044, 139934633629568, 1, 16777216, 0, 112, 94169948894479, 139934634500096}}}} [01:17:47.615] _do_rethrow = false [01:17:47.615] parsetree = 0x55a5b2c35790 [01:17:47.615] isTopLevel = true [01:17:47.615] isCompleteQuery = true [01:17:47.615] needCleanup = false [01:17:47.615] commandCollected = false [01:17:47.615] address = {classId = 21925, objectId = 2999146384, objectSubId = 21925} [01:17:47.615] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:17:47.615] __func__ = "ProcessUtilitySlow" [01:17:47.615] #12 0x000055a5a662e5bd in standard_ProcessUtility (pstmt=pstmt@entry=0x55a5b2c35840, queryString=queryString@entry=0x55a5b2c34a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=readOnlyTree@entry=false, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x55a5b2c367e8, qc=0x7ffc4ef9f210) at ../src/backend/tcop/utility.c:1067 [01:17:47.615] parsetree = 0x55a5b2c35790 [01:17:47.615] isTopLevel = true [01:17:47.615] isAtomicContext = false [01:17:47.615] pstate = 0x55a5b2ddda00 [01:17:47.615] readonly_flags = [01:17:47.615] __func__ = "standard_ProcessUtility" [01:17:47.615] #13 0x00007f451442ad9d in pgss_ProcessUtility (pstmt=0x55a5b2c35840, queryString=0x55a5b2c34a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55a5b2c367e8, qc=0x7ffc4ef9f210) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [01:17:47.615] _save_exception_stack = 0x7ffc4ef9f0d0 [01:17:47.615] _save_context_stack = 0x0 [01:17:47.615] _local_sigjmp_buf = {{__jmpbuf = {0, -8157532992565101292, 94170157111360, 94170157115368, 140721633489424, 0, 8156585196985040148, 8088665539765910804}, __mask_was_saved = 0, __saved_mask = {__val = {94169952719373, 140721633488694, 140721633488692, 0, 0, 139637976727552, 206158430232, 140721633488656, 94169952719590, 0, 206158430232, 94170157112160, 140721633488752, 0, 94169947538819, 94170157107536}}}} [01:17:47.615] _do_rethrow = false [01:17:47.615] duration = [01:17:47.615] bufusage = {shared_blks_hit = 94170158761368, shared_blks_read = 708669603840, shared_blks_dirtied = 0, shared_blks_written = 94170158760872, local_blks_hit = 94170158761368, local_blks_read = 94169945870232, local_blks_dirtied = 94170159372440, local_blks_written = 94169945870478, temp_blks_read = 94170158760872, temp_blks_written = 94170158760288, shared_blk_read_time = {ticks = 94169945869587}, shared_blk_write_time = {ticks = 94169952712825}, local_blk_read_time = {ticks = 139934702665144}, local_blk_write_time = {ticks = 94170157107792}, temp_blk_read_time = {ticks = 94169955037221}, temp_blk_write_time = {ticks = 94169964998274}} [01:17:47.615] walusage_start = {wal_records = 8933, wal_fpi = 135, wal_bytes = 1243004} [01:17:47.615] start = [01:17:47.615] rows = [01:17:47.615] bufusage_start = {shared_blks_hit = 35967, shared_blks_read = 3553, shared_blks_dirtied = 1585, shared_blks_written = 1022, 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}} [01:17:47.615] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 139934633629568} [01:17:47.615] parsetree = [01:17:47.615] saved_queryId = 6041762721901209185 [01:17:47.615] saved_stmt_location = 0 [01:17:47.615] saved_stmt_len = 69 [01:17:47.615] enabled = true [01:17:47.615] #14 0x000055a5a662e663 in ProcessUtility (pstmt=pstmt@entry=0x55a5b2c35840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55a5b2c367e8, qc=0x7ffc4ef9f210) at ../src/backend/tcop/utility.c:519 [01:17:47.615] No locals. [01:17:47.615] #15 0x000055a5a6629f84 in PortalRunUtility (portal=portal@entry=0x55a5b2cb5f90, pstmt=pstmt@entry=0x55a5b2c35840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55a5b2c367e8, qc=qc@entry=0x7ffc4ef9f210) at ../src/backend/tcop/pquery.c:1158 [01:17:47.615] No locals. [01:17:47.615] #16 0x000055a5a662a529 in PortalRunMulti (portal=portal@entry=0x55a5b2cb5f90, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55a5b2c367e8, altdest=altdest@entry=0x55a5b2c367e8, qc=qc@entry=0x7ffc4ef9f210) at ../src/backend/tcop/pquery.c:1315 [01:17:47.615] pstmt = 0x55a5b2c35840 [01:17:47.615] stmtlist_item__state = [01:17:47.615] active_snapshot_set = false [01:17:47.615] stmtlist_item = 0x55a5b2c367b0 [01:17:47.615] #17 0x000055a5a662aafc in PortalRun (portal=portal@entry=0x55a5b2cb5f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55a5b2c367e8, altdest=altdest@entry=0x55a5b2c367e8, qc=0x7ffc4ef9f210) at ../src/backend/tcop/pquery.c:791 [01:17:47.615] _save_exception_stack = 0x7ffc4ef9f2c0 [01:17:47.615] _save_context_stack = 0x0 [01:17:47.615] _local_sigjmp_buf = {{__jmpbuf = {0, 2702717711891348756, 94170157637520, 94170157111304, 94170157637520, 94170157111232, 8156585196580289812, 2702672371691994388}, __mask_was_saved = 0, __saved_mask = {__val = {94169952397476, 94170157107536, 112, 4, 94169952401893, 1325003167, 4, 94170157111232, 112, 73, 94170157637520, 94170157111304, 94170157111280, 94170157111232, 94169952489096, 1}}}} [01:17:47.615] _do_rethrow = [01:17:47.615] result = [01:17:47.615] nprocessed = [01:17:47.615] saveTopTransactionResourceOwner = 0x55a5b2c75468 [01:17:47.615] saveTopTransactionContext = 0x55a5b2cc3ed0 [01:17:47.615] saveActivePortal = 0x0 [01:17:47.615] saveResourceOwner = 0x55a5b2c75468 [01:17:47.615] savePortalContext = 0x0 [01:17:47.615] saveMemoryContext = 0x55a5b2cc3ed0 [01:17:47.615] __func__ = "PortalRun" [01:17:47.615] #18 0x000055a5a6623ee8 in exec_simple_query (query_string=query_string@entry=0x55a5b2c34a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [01:17:47.615] cmdtaglen = 24 [01:17:47.615] snapshot_set = [01:17:47.615] per_parsetree_context = 0x0 [01:17:47.615] plantree_list = 0x55a5b2c36798 [01:17:47.615] parsetree = 0x55a5b2c357c0 [01:17:47.615] commandTag = [01:17:47.615] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:17:47.615] querytree_list = [01:17:47.615] portal = 0x55a5b2cb5f90 [01:17:47.615] receiver = 0x55a5b2c367e8 [01:17:47.615] format = 0 [01:17:47.615] cmdtagname = [01:17:47.615] parsetree_item__state = [01:17:47.615] dest = DestRemote [01:17:47.615] oldcontext = 0x55a5b2cc3ed0 [01:17:47.615] parsetree_list = 0x55a5b2c357f0 [01:17:47.615] parsetree_item = 0x55a5b2c35808 [01:17:47.615] save_log_statement_stats = false [01:17:47.615] was_logged = true [01:17:47.615] use_implicit_block = false [01:17:47.615] msec_str = "p\364\371N\374\177\000\000\254\327\215\246\245U\000\000\240\362\371N\374\177\000\000G\000\000\000\000\000\000" [01:17:47.615] __func__ = "exec_simple_query" [01:17:47.615] #19 0x000055a5a6626c6c in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [01:17:47.615] query_string = 0x55a5b2c34a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:17:47.615] firstchar = [01:17:47.615] input_message = {data = 0x55a5b2c34a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:17:47.615] local_sigjmp_buf = {{__jmpbuf = {94169965006840, 2702670321711889684, 4, 140721633490032, 140721633490176, 140721633490180, 8156585196534152468, 2702672365703970068}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94170157357376, 0, 168, 94169952401995, 0, 10, 2, 94169965006848, 94170156838384, 94169965000928, 140721633490032, 140721633490176, 140721633490180}}}} [01:17:47.615] send_ready_for_query = false [01:17:47.615] idle_in_transaction_timeout_enabled = false [01:17:47.615] idle_session_timeout_enabled = false [01:17:47.615] __func__ = "PostgresMain" [01:17:47.615] #20 0x000055a5a661cae2 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [01:17:47.615] bsdata = [01:17:47.615] #21 0x000055a5a64d053c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc4ef9f41c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc4ef9f470) at ../src/backend/postmaster/launch_backend.c:266 [01:17:47.615] pid = [01:17:47.615] #22 0x000055a5a64d5ff0 in BackendStartup (client_sock=client_sock@entry=0x7ffc4ef9f470) at ../src/backend/postmaster/postmaster.c:3417 [01:17:47.615] bn = 0x55a5b2c61248 [01:17:47.615] pid = [01:17:47.615] startup_data = {canAcceptConnections = CAC_OK} [01:17:47.615] __func__ = "BackendStartup" [01:17:47.615] #23 0x000055a5a64d6552 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [01:17:47.615] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "b\026E\177\000\0004\365\371N\374\177\000\000\312`\347\027E\177\000\000>\004\000\000\000\000\000\000\260\227c\026E\177\000\000\240\357\262\027E\177\000\0008\365\371N\374\177\000\0004\365\371N\374\177\000\000\000\000\000\000\000\000\000\000\320\364\371N\374\177\000\000r\320h\245\245U\000\000\b\267d\245\245U\000\000\000\366\371N\374\177\000\000\370\365\371N\374\177\000\000\225[\362\001\000\000\000", __ss_align = 94170157279856}, salen = 2}} [01:17:47.615] i = 0 [01:17:47.615] now = [01:17:47.615] last_lockfile_recheck_time = 1730855647 [01:17:47.615] last_touch_time = 1730855647 [01:17:47.615] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f4517ea02e0}, {pos = 1325004152, events = 0, fd = 0, user_data = 0x7f4517ea0668}, {pos = -1519857550, events = 21925, fd = 401213032, user_data = 0x7f4516e3d630}, {pos = 401212128, events = 32581, fd = 2090263927, user_data = 0x7ffc4ef9f680}, {pos = 401041992, events = 32581, fd = 15, user_data = 0x7f4516e3d630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 401212128, events = 32581, fd = 1325004280, user_data = 0x7ffc4ef9f600}, {pos = 401213032, events = 32581, fd = 0, user_data = 0x55a5b2c60308}, {pos = -1295646232, events = 21925, fd = -1295628143, user_data = 0x7f4500000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7f451662e020}, {pos = 397602720, events = 32581, fd = -1295645944, user_data = 0x7ffc4ef9f9f0}, {pos = -1295627976, events = 21925, fd = -1295626048, user_data = 0x55a5b2c60308}, {pos = 401212128, events = 32581, fd = 427, user_data = 0x55a5a6e59d58 }, {pos = 0, events = 0, fd = 1, user_data = 0x55a5b2c36890}, {pos = 401067710, events = 32581, fd = 1, user_data = 0x0}, {pos = 375578656, events = 32581, fd = 376384960, user_data = 0x7ffc4ef9fa60}, {pos = 1325005376, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 401076666, user_data = 0x0}, {pos = 376106276, events = 32581, fd = 0, user_data = 0x55a5a74f1960 }, {pos = 2, events = 0, fd = 7, user_data = 0x55a5b2bf6e90}, {pos = 0, events = 0, fd = 375612616, user_data = 0x7f451669c880 }, {pos = 373194168, events = 32581, fd = 8096, user_data = 0x100007f00000002}, {pos = 376139757, events = 32581, fd = 2, user_data = 0x55a5b2c69900}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 377429088, events = 32581, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55a5b2bf6e90}, {pos = 376142346, events = 32581, fd = 1769300525, user_data = 0x55a5b2bf6e90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 384034112, user_data = 0x7f4516e3ea80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x53cf8c1c27fe8d00}, {pos = 377415136, events = 32581, fd = -328, user_data = 0x0}, {pos = -1295646552, events = 21925, fd = 1024, user_data = 0x55a5b2c600a8}, {pos = 1325005560, events = 32764, fd = 376143519, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 32404, events = 0, fd = -328, user_data = 0x0}, {pos = -1295816560, events = 21925, fd = 376385491, user_data = 0x7ffc4ef9faf8}, {pos = -1500451304, events = 21925, fd = -1487925328, user_data = 0x55a5a68fd8d5 }, {pos = -1295646752, events = 21925, fd = -1295824560, user_data = 0x55a5b2c5ffe0}, {pos = 376133694, events = 32581, fd = 0, user_data = 0x55a5a690f53f }, {pos = -1295646752, events = 1, fd = -1500449144, user_data = 0x55a5b2c34950}, {pos = 670993664, events = 1406110748, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 376056497, user_data = 0x7f45166a14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 670993664, user_data = 0x55a5b2c0c080}, {pos = 670993664, events = 1406110748, fd = 11, user_data = 0x53cf8c1c27fe8d00}, {pos = 0, events = 0, fd = 375763513, user_data = 0x1}, {pos = -1504902599, events = 21925, fd = 4194304, user_data = 0x55a5a68fd769 }, {pos = -1295990656, events = 21925, fd = -1295824560, user_data = 0x55a5b2c0c080}, {pos = 1, events = 0, fd = 0, user_data = 0x55a5a690f53f }, {pos = -1295990656, events = 21925, fd = -1500449144, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55a5a6304c0b }, {pos = 0, events = 0, fd = -1506762933, user_data = 0xb}, {pos = -1504881442, events = 21925, fd = -1491546896, user_data = 0x55a5b2c35308}} [01:17:47.615] nevents = 1 [01:17:47.615] __func__ = "ServerLoop" [01:17:47.615] #24 0x000055a5a64d7cd5 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a5b2bf2cf0) at ../src/backend/postmaster/postmaster.c:1348 [01:17:47.615] opt = [01:17:47.615] status = [01:17:47.615] userDoption = [01:17:47.615] listen_addr_saved = false [01:17:47.615] output_config_variable = [01:17:47.615] __func__ = "PostmasterMain" [01:17:47.615] #25 0x000055a5a6314f93 in main (argc=4, argv=0x55a5b2bf2cf0) at ../src/backend/main/main.c:196 [01:17:47.615] do_check_root = [01:17:47.652] -e [01:17:47.652] [01:17:47.652] [01:17:47.722] dumping /tmp/cores/postgres-6-29245.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [01:17:47.989] [New LWP 29245] [01:17:47.989] [01:17:47.989] This GDB supports auto-downloading debuginfo from the following URLs: [01:17:47.989] [01:17:47.989] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:17:47.989] Debuginfod has been disabled. [01:17:47.989] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:17:48.104] [Thread debugging using libthread_db enabled] [01:17:48.104] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:17:48.104] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [01:17:48.104] Program terminated with signal SIGABRT, Aborted. [01:17:48.104] #0 0x00007ff5afca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:48.998] [01:17:48.998] Thread 1 (Thread 0x7ff5af9e0f00 (LWP 29245)): [01:17:48.998] #0 0x00007ff5afca9e3c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:48.998] No symbol table info available. [01:17:48.998] #1 0x00007ff5afc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:48.998] No symbol table info available. [01:17:48.998] #2 0x00007ff5afc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:17:48.998] No symbol table info available. [01:17:48.998] #3 0x000055e42a2819fe in ExceptionalCondition (conditionName=conditionName@entry=0x55e42a4f5e15 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x55e42a4f5330 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [01:17:48.998] No locals. [01:17:48.998] #4 0x000055e429c04f76 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55e466957470, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:194 [01:17:48.998] estate = 0x55e466912780 [01:17:48.998] oldcontext = 0x55e4669a0c90 [01:17:48.998] __func__ = "standard_ExecutorStart" [01:17:48.998] #5 0x000055e429c05152 in ExecutorStart (queryDesc=queryDesc@entry=0x55e466957470, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:135 [01:17:48.998] No locals. [01:17:48.998] #6 0x000055e429b2b9b0 in refresh_matview_datafill (dest=0x55e4669544e8, query=, query@entry=0x55e466968180, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [01:17:48.998] rewritten = [01:17:48.998] plan = 0x55e4669569a8 [01:17:48.998] queryDesc = 0x55e466957470 [01:17:48.998] copied_query = [01:17:48.998] processed = [01:17:48.998] __func__ = "refresh_matview_datafill" [01:17:48.998] #7 0x000055e429b2dd17 in RefreshMatViewByOid (matviewOid=27407, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [01:17:48.998] dest = [01:17:48.998] matviewRel = 0x7ff5a411f678 [01:17:48.998] rule = [01:17:48.998] actions = [01:17:48.998] dataQuery = 0x55e466968180 [01:17:48.998] tableSpace = [01:17:48.998] relowner = 10 [01:17:48.998] OIDNewHeap = 27424 [01:17:48.998] processed = 0 [01:17:48.998] relpersistence = 112 'p' [01:17:48.998] save_userid = 10 [01:17:48.998] save_sec_context = 0 [01:17:48.998] save_nestlevel = 2 [01:17:48.998] address = {classId = 0, objectId = 0, objectSubId = 0} [01:17:48.998] __func__ = "RefreshMatViewByOid" [01:17:48.998] #8 0x000055e429b2de56 in ExecRefreshMatView (stmt=0x55e46699e9d0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [01:17:48.998] matviewOid = [01:17:48.998] lockmode = [01:17:48.998] #9 0x000055e429ae3aa3 in ExecCreateTableAs (pstate=pstate@entry=0x55e4669a0d90, stmt=stmt@entry=0x55e4667ed7f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7fff8c1bf650) at ../src/backend/commands/createas.c:351 [01:17:48.998] refresh = [01:17:48.998] query = 0x55e4667ed9b0 [01:17:48.998] into = 0x55e4667ed548 [01:17:48.998] jstate = 0x0 [01:17:48.998] is_matview = true [01:17:48.998] do_refresh = false [01:17:48.998] dest = [01:17:48.998] address = {classId = 1259, objectId = 27407, objectSubId = 0} [01:17:48.998] __func__ = "ExecCreateTableAs" [01:17:48.998] #10 0x000055e429ff9fac in ProcessUtilitySlow (pstate=pstate@entry=0x55e4669a0d90, pstmt=pstmt@entry=0x55e4667ed8a0, queryString=queryString@entry=0x55e4667ecab0 "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=0x55e4667ee2d8, qc=0x7fff8c1bf650) at ../src/backend/tcop/utility.c:1675 [01:17:48.998] _save_exception_stack = 0x7fff8c1bf510 [01:17:48.998] _save_context_stack = 0x0 [01:17:48.998] _local_sigjmp_buf = {{__jmpbuf = {0, -1767234920546862521, 94439460493296, 0, 94439460489904, 0, -5526389560048387513, -1767352579792864697}, __mask_was_saved = 0, __saved_mask = {__val = {140693004720768, 8863, 94438444947474, 1, 4294976159, 140693004720768, 94438444937792, 1, 38068015935800, 1, 8863, 140693004720768, 140693004720768, 1, 94438444947821, 94439461695800}}}} [01:17:48.998] _do_rethrow = false [01:17:48.998] parsetree = 0x55e4667ed7f0 [01:17:48.998] isTopLevel = true [01:17:48.998] isCompleteQuery = true [01:17:48.998] needCleanup = false [01:17:48.998] commandCollected = false [01:17:48.998] address = {classId = 21988, objectId = 1719588848, objectSubId = 21988} [01:17:48.998] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [01:17:48.998] __func__ = "ProcessUtilitySlow" [01:17:48.998] #11 0x000055e429ff85bd in standard_ProcessUtility (pstmt=0x55e4667ed8a0, queryString=0x55e4667ecab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55e4667ee2d8, qc=0x7fff8c1bf650) at ../src/backend/tcop/utility.c:1067 [01:17:48.998] parsetree = 0x55e4667ed7f0 [01:17:48.998] isTopLevel = true [01:17:48.998] isAtomicContext = false [01:17:48.998] pstate = 0x55e4669a0d90 [01:17:48.998] readonly_flags = [01:17:48.998] __func__ = "standard_ProcessUtility" [01:17:48.998] #12 0x000055e429ff8718 in ProcessUtility (pstmt=pstmt@entry=0x55e4667ed8a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55e4667ee2d8, qc=0x7fff8c1bf650) at ../src/backend/tcop/utility.c:523 [01:17:48.998] No locals. [01:17:48.998] #13 0x000055e429ff3f84 in PortalRunUtility (portal=portal@entry=0x55e46686f050, pstmt=pstmt@entry=0x55e4667ed8a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55e4667ee2d8, qc=qc@entry=0x7fff8c1bf650) at ../src/backend/tcop/pquery.c:1158 [01:17:48.998] No locals. [01:17:48.998] #14 0x000055e429ff4529 in PortalRunMulti (portal=portal@entry=0x55e46686f050, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55e4667ee2d8, altdest=altdest@entry=0x55e4667ee2d8, qc=qc@entry=0x7fff8c1bf650) at ../src/backend/tcop/pquery.c:1315 [01:17:48.998] pstmt = 0x55e4667ed8a0 [01:17:48.998] stmtlist_item__state = [01:17:48.998] active_snapshot_set = false [01:17:48.998] stmtlist_item = 0x55e4667ee2a0 [01:17:48.998] #15 0x000055e429ff4afc in PortalRun (portal=portal@entry=0x55e46686f050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55e4667ee2d8, altdest=altdest@entry=0x55e4667ee2d8, qc=0x7fff8c1bf650) at ../src/backend/tcop/pquery.c:791 [01:17:48.998] _save_exception_stack = 0x7fff8c1bf700 [01:17:48.998] _save_context_stack = 0x0 [01:17:48.998] _local_sigjmp_buf = {{__jmpbuf = {0, -1767234922481485241, 94439461023824, 94439460493416, 94439461023824, 94439460493344, -5526389559926752697, -1767352581761959353}, __mask_was_saved = 0, __saved_mask = {__val = {94438448449700, 94439460489648, 112, 4, 94438448454117, 2350642655, 4, 94439460493344, 112, 73, 94439461023824, 94439460493416, 94439460493392, 94439460493344, 94438448541320, 1}}}} [01:17:48.998] _do_rethrow = [01:17:48.998] result = [01:17:48.998] nprocessed = [01:17:48.998] saveTopTransactionResourceOwner = 0x55e46682bd08 [01:17:48.998] saveTopTransactionContext = 0x55e466880c60 [01:17:48.998] saveActivePortal = 0x0 [01:17:48.998] saveResourceOwner = 0x55e46682bd08 [01:17:48.998] savePortalContext = 0x0 [01:17:48.998] saveMemoryContext = 0x55e466880c60 [01:17:48.998] __func__ = "PortalRun" [01:17:48.998] #16 0x000055e429fedee8 in exec_simple_query (query_string=query_string@entry=0x55e4667ecab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [01:17:48.998] cmdtaglen = 24 [01:17:48.998] snapshot_set = [01:17:48.998] per_parsetree_context = 0x0 [01:17:48.998] plantree_list = 0x55e4667ee288 [01:17:48.998] parsetree = 0x55e4667ed820 [01:17:48.998] commandTag = [01:17:48.998] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:17:48.998] querytree_list = [01:17:48.998] portal = 0x55e46686f050 [01:17:48.998] receiver = 0x55e4667ee2d8 [01:17:48.998] format = 0 [01:17:48.998] cmdtagname = [01:17:48.998] parsetree_item__state = [01:17:48.998] dest = DestRemote [01:17:48.998] oldcontext = 0x55e466880c60 [01:17:48.998] parsetree_list = 0x55e4667ed850 [01:17:48.998] parsetree_item = 0x55e4667ed868 [01:17:48.998] save_log_statement_stats = false [01:17:48.998] was_logged = false [01:17:48.998] use_implicit_block = false [01:17:48.998] msec_str = "\260\370\033\214\377\177\000\000\254w**\344U\000\000\340\366\033\214\377\177\000\000G\000\000\000\000\000\000" [01:17:48.998] __func__ = "exec_simple_query" [01:17:48.998] #17 0x000055e429ff0c6c in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4792 [01:17:48.998] query_string = 0x55e4667ecab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [01:17:48.998] firstchar = [01:17:48.998] input_message = {data = 0x55e4667ecab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [01:17:48.998] local_sigjmp_buf = {{__jmpbuf = {94438461059064, -1767350492995552697, 4, 140735544031408, 140735544031552, 140735544031556, -5526389559981278649, -1767352583966459321}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94439460220368, 15616, 94438461053152, 94439460744384, 140735544031552, 94438448453665, 0, 9, 2, 94438461059072, 94439460220368, 94438461053152, 140735544031408, 140735544031552, 140735544031556}}}} [01:17:48.998] send_ready_for_query = false [01:17:48.998] idle_in_transaction_timeout_enabled = false [01:17:48.998] idle_session_timeout_enabled = false [01:17:48.998] __func__ = "PostgresMain" [01:17:48.998] #18 0x000055e429fe6ae2 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [01:17:48.998] bsdata = [01:17:48.998] #19 0x000055e429e9a53c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff8c1bf85c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff8c1bf8b0) at ../src/backend/postmaster/launch_backend.c:266 [01:17:48.998] pid = [01:17:48.998] #20 0x000055e429e9fff0 in BackendStartup (client_sock=client_sock@entry=0x7fff8c1bf8b0) at ../src/backend/postmaster/postmaster.c:3417 [01:17:48.998] bn = 0x55e466815438 [01:17:48.998] pid = [01:17:48.998] startup_data = {canAcceptConnections = CAC_OK} [01:17:48.998] __func__ = "BackendStartup" [01:17:48.998] #21 0x000055e429ea0552 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [01:17:48.998] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "¯\365\177\000\000t\371\033\214\377\177\000\000ʐI\261\365\177\000\000>\004\000\000\000\000\000\000\260\227ï\365\177\000\000\240\277\022\261\365\177\000\000x\371\033\214\377\177\000\000t\371\033\214\377\177\000\000\000\000\000\000\000\000\000\000\020\371\033\214\377\177\000\000rp\005)\344U\000\000\bW\001)\344U\000\000@\372\033\214\377\177\000\0008\372\033\214\377\177\000\000\225[\362\001\000\000\000", __ss_align = 140693190358176}, salen = 2}} [01:17:48.998] i = 0 [01:17:48.998] now = [01:17:48.998] last_lockfile_recheck_time = 1730855610 [01:17:48.998] last_touch_time = 1730855610 [01:17:48.998] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7ff5b14c32e0}, {pos = -1944323656, events = 0, fd = 0, user_data = 0x7ff5b14c3668}, {pos = 688222322, events = 21988, fd = -1320405400, user_data = 0x7ff5afa23630}, {pos = -1320406304, events = 32757, fd = 2090263927, user_data = 0x7fff8c1bfac0}, {pos = -1320576440, events = 32757, fd = 15, user_data = 0x7ff5afa23630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1320406304, events = 32757, fd = -1944323528, user_data = 0x7fff8c1bfa40}, {pos = -1320405400, events = 32757, fd = 0, user_data = 0x55e466819748}, {pos = 1719768616, events = 21988, fd = 1719777345, user_data = 0x7ff500000001}, {pos = 1, events = 0, fd = -1, user_data = 0x7ff5afc2e020}, {pos = -1324171360, events = 32757, fd = 1719768904, user_data = 0x7fff8c1bfe30}, {pos = 1719769272, events = 21988, fd = 1719739056, user_data = 0x55e466819748}, {pos = -1320406304, events = 32757, fd = 427, user_data = 0x55e42a823d58 }, {pos = 0, events = 0, fd = 1, user_data = 0x55e4667ecb70}, {pos = -1320550722, events = 32757, fd = 1, user_data = 0x0}, {pos = -1346183136, events = 32757, fd = -1345376832, user_data = 0x7fff8c1bfea0}, {pos = -1944322432, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1320541766, user_data = 0x0}, {pos = -1345655516, events = 32757, fd = 0, user_data = 0x55e42aebb960 }, {pos = 2, events = 0, fd = 7, user_data = 0x55e4667aee70}, {pos = 0, events = 0, fd = -1346149176, user_data = 0x7ff5afc9c880 }, {pos = -1348596296, events = 32757, fd = 8096, user_data = 0x100007f00000002}, {pos = -1345622035, events = 32757, fd = 2, user_data = 0x55e466818410}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1344332704, events = 32757, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55e4667aee70}, {pos = -1345619446, events = 32757, fd = 1549556828, user_data = 0x55e4667aee70}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294901760, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x514a53702d737365}, {pos = 168448088, events = 840966176, fd = 822763892, user_data = 0x30340a3031363535}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x7f0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x90d392ef54f46000}, {pos = -1344346656, events = 32757, fd = -328, user_data = 0x0}, {pos = 1719768296, events = 21988, fd = 1024, user_data = 0x55e4668194e8}, {pos = -1944322248, events = 32767, fd = -1345618273, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 25386, events = 0, fd = -328, user_data = 0x0}, {pos = 1719585648, events = 21988, fd = -1345376301, user_data = 0x7fff8c1bff38}, {pos = 707628568, events = 21988, fd = 720154544, user_data = 0x55e42a2c78d5 }, {pos = 1719768096, events = 21988, fd = 1719585200, user_data = 0x55e466819420}, {pos = -1345628098, events = 32757, fd = 0, user_data = 0x55e42a2d953f }, {pos = 1719768096, events = 1, fd = 707630728, user_data = 0x55e4667ec9b0}, {pos = 1425301504, events = 2429784815, fd = 0, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1345705295, user_data = 0x7ff5afca14f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1425301504, user_data = 0x55e4667c40e0}, {pos = 1425301504, events = 2429784815, fd = 11, user_data = 0x90d392ef54f46000}, {pos = 0, events = 0, fd = -1345998279, user_data = 0x1}, {pos = 703177273, events = 21988, fd = 4194304, user_data = 0x55e42a2c7769 }, {pos = 1719419104, events = 21988, fd = 1719585200, user_data = 0x55e4667c40e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55e42a2d953f }, {pos = 1719419104, events = 21988, fd = 707630728, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55e429ccec0b }, {pos = 0, events = 0, fd = 701316939, user_data = 0xb}, {pos = 703198430, events = 21988, fd = 716532976, user_data = 0x55e4667ed388}} [01:17:48.999] nevents = 1 [01:17:48.999] __func__ = "ServerLoop" [01:17:48.999] #22 0x000055e429ea1cd5 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55e4667aad30) at ../src/backend/postmaster/postmaster.c:1348 [01:17:48.999] opt = [01:17:48.999] status = [01:17:48.999] userDoption = [01:17:48.999] listen_addr_saved = false [01:17:48.999] output_config_variable = [01:17:48.999] __func__ = "PostmasterMain" [01:17:48.999] #23 0x000055e429cdef93 in main (argc=8, argv=0x55e4667aad30) at ../src/backend/main/main.c:196 [01:17:48.999] do_check_root =