[11:14:18.877] src/tools/ci/cores_backtrace.sh linux /tmp/cores [11:14:19.086] dumping /tmp/cores/postgres-3-32737.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [11:14:19.342] [New LWP 32737] [11:14:19.342] [11:14:19.342] This GDB supports auto-downloading debuginfo from the following URLs: [11:14:19.342] [11:14:19.342] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [11:14:19.342] Debuginfod has been disabled. [11:14:19.342] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [11:14:19.465] [New LWP 31709] [11:14:19.465] [Thread debugging using libthread_db enabled] [11:14:19.465] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [11:14:19.465] Core was generated by `postgres: standby: startup waiting for 000000010000000000000005 '. [11:14:19.465] Program terminated with signal SIGQUIT, Quit. [11:14:19.465] #0 0x00007f4bf4eaeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:19.499] [Current thread is 1 (LWP 32737)] [11:14:19.507] [11:14:19.507] Thread 2 (Thread 0x7f4bf4dd2f00 (LWP 31709)): [11:14:19.507] warning: Couldn't find general-purpose registers in core file. [11:14:19.507] #0 in ?? () [11:14:19.507] PC unavailable, cannot determine locals. [11:14:19.507] Backtrace stopped: not enough registers or memory available to unwind further [11:14:19.507] [11:14:19.507] Thread 1 (LWP 32737): [11:14:19.507] #0 0x00007f4bf4eaeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:19.507] No symbol table info available. [11:14:19.507] #1 0x00007f4bf4e5b239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:19.507] No symbol table info available. [11:14:19.507] #2 0x00007f4bf4f16204 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:19.507] No symbol table info available. [11:14:19.507] #3 0x00007f4bf4f2885c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:19.507] No symbol table info available. [11:14:19.525] -e [11:14:19.525] [11:14:19.525] [11:14:19.590] dumping /tmp/cores/postgres-6-30056.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [11:14:19.846] [New LWP 30056] [11:14:19.846] [11:14:19.846] This GDB supports auto-downloading debuginfo from the following URLs: [11:14:19.846] [11:14:19.846] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [11:14:19.846] Debuginfod has been disabled. [11:14:19.846] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [11:14:19.949] [Thread debugging using libthread_db enabled] [11:14:19.949] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [11:14:19.949] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW '. [11:14:19.949] Program terminated with signal SIGABRT, Aborted. [11:14:19.949] #0 0x00007f6b836a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:20.879] [11:14:20.879] Thread 1 (Thread 0x7f6b833d2f00 (LWP 30056)): [11:14:20.879] #0 0x00007f6b836a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:20.879] No symbol table info available. [11:14:20.879] #1 0x00007f6b8365afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:20.879] No symbol table info available. [11:14:20.879] #2 0x00007f6b83645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:20.879] No symbol table info available. [11:14:20.879] #3 0x0000564261f2793b in ExceptionalCondition (conditionName=conditionName@entry=0x56426219d4d5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x56426219c9f0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [11:14:20.879] No locals. [11:14:20.879] #4 0x00005642618a801b in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5642a053f6a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [11:14:20.879] estate = 0x5642a04acf30 [11:14:20.879] oldcontext = 0x5642a0467260 [11:14:20.879] __func__ = "standard_ExecutorStart" [11:14:20.879] #5 0x00005642618a81f7 in ExecutorStart (queryDesc=queryDesc@entry=0x5642a053f6a0, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [11:14:20.879] No locals. [11:14:20.879] #6 0x00005642617cc5ae in refresh_matview_datafill (dest=0x5642a04cf608, query=, query@entry=0x5642a04c9af0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [11:14:20.879] rewritten = [11:14:20.879] plan = 0x5642a053ebd8 [11:14:20.879] queryDesc = 0x5642a053f6a0 [11:14:20.879] copied_query = [11:14:20.879] processed = [11:14:20.879] __func__ = "refresh_matview_datafill" [11:14:20.879] #7 0x00005642617ce915 in RefreshMatViewByOid (matviewOid=28383, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [11:14:20.879] dest = [11:14:20.879] matviewRel = 0x7f6b77e9ec18 [11:14:20.879] rule = [11:14:20.879] actions = [11:14:20.879] dataQuery = 0x5642a04c9af0 [11:14:20.879] tableSpace = [11:14:20.879] relowner = 10 [11:14:20.879] OIDNewHeap = 28396 [11:14:20.879] processed = 0 [11:14:20.879] relpersistence = 112 'p' [11:14:20.879] save_userid = 10 [11:14:20.879] save_sec_context = 0 [11:14:20.879] save_nestlevel = 2 [11:14:20.879] address = {classId = 0, objectId = 0, objectSubId = 0} [11:14:20.879] __func__ = "RefreshMatViewByOid" [11:14:20.879] #8 0x00005642617cea54 in ExecRefreshMatView (stmt=0x5642a046c140, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [11:14:20.879] matviewOid = [11:14:20.879] lockmode = [11:14:20.879] #9 0x0000564261784683 in ExecCreateTableAs (pstate=pstate@entry=0x5642a0467360, stmt=stmt@entry=0x5642a031d770, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffd704bcef0) at ../src/backend/commands/createas.c:351 [11:14:20.879] refresh = [11:14:20.879] query = 0x5642a031d930 [11:14:20.879] into = 0x5642a031d4c8 [11:14:20.879] jstate = 0x0 [11:14:20.879] is_matview = true [11:14:20.879] do_refresh = false [11:14:20.879] dest = [11:14:20.879] address = {classId = 1259, objectId = 28383, objectSubId = 0} [11:14:20.879] __func__ = "ExecCreateTableAs" [11:14:20.879] #10 0x0000564261c9fcf6 in ProcessUtilitySlow (pstate=pstate@entry=0x5642a0467360, pstmt=pstmt@entry=0x5642a031d820, queryString=queryString@entry=0x5642a031ca30 "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=0x5642a031e258, qc=0x7ffd704bcef0) at ../src/backend/tcop/utility.c:1678 [11:14:20.879] _save_exception_stack = 0x7ffd704bcdb0 [11:14:20.879] _save_context_stack = 0x0 [11:14:20.879] _local_sigjmp_buf = {{__jmpbuf = {0, -2379373283749629, 94844155451248, 0, 94844155447856, 0, -6014509968086904573, -2805917059493629}, __mask_was_saved = 0, __saved_mask = {__val = {140099555262336, 15223, 94843107882535, 1, 4294982519, 140099555262336, 94843111701871, 140099740052920, 94844155447856, 94843114033189, 94843124016482, 94843124016608, 140726487469044, 94843114228088, 94843124016497, 94843124016608}}}} [11:14:20.879] _do_rethrow = false [11:14:20.879] parsetree = 0x5642a031d770 [11:14:20.879] isTopLevel = true [11:14:20.879] isCompleteQuery = true [11:14:20.879] needCleanup = false [11:14:20.879] commandCollected = false [11:14:20.879] address = {classId = 22082, objectId = 2687620976, objectSubId = 22082} [11:14:20.879] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [11:14:20.879] __func__ = "ProcessUtilitySlow" [11:14:20.879] #11 0x0000564261c9e307 in standard_ProcessUtility (pstmt=0x5642a031d820, queryString=0x5642a031ca30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5642a031e258, qc=0x7ffd704bcef0) at ../src/backend/tcop/utility.c:1070 [11:14:20.879] parsetree = 0x5642a031d770 [11:14:20.879] isTopLevel = true [11:14:20.879] isAtomicContext = false [11:14:20.879] pstate = 0x5642a0467360 [11:14:20.879] readonly_flags = [11:14:20.879] __func__ = "standard_ProcessUtility" [11:14:20.879] #12 0x0000564261c9e462 in ProcessUtility (pstmt=pstmt@entry=0x5642a031d820, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5642a031e258, qc=0x7ffd704bcef0) at ../src/backend/tcop/utility.c:523 [11:14:20.879] No locals. [11:14:20.879] #13 0x0000564261c99cce in PortalRunUtility (portal=portal@entry=0x5642a039e7a0, pstmt=pstmt@entry=0x5642a031d820, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5642a031e258, qc=qc@entry=0x7ffd704bcef0) at ../src/backend/tcop/pquery.c:1158 [11:14:20.879] No locals. [11:14:20.879] #14 0x0000564261c9a273 in PortalRunMulti (portal=portal@entry=0x5642a039e7a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5642a031e258, altdest=altdest@entry=0x5642a031e258, qc=qc@entry=0x7ffd704bcef0) at ../src/backend/tcop/pquery.c:1315 [11:14:20.879] pstmt = 0x5642a031d820 [11:14:20.879] stmtlist_item__state = [11:14:20.879] active_snapshot_set = false [11:14:20.879] stmtlist_item = 0x5642a031e220 [11:14:20.879] #15 0x0000564261c9a846 in PortalRun (portal=portal@entry=0x5642a039e7a0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5642a031e258, altdest=altdest@entry=0x5642a031e258, qc=0x7ffd704bcef0) at ../src/backend/tcop/pquery.c:791 [11:14:20.879] _save_exception_stack = 0x7ffd704bcfa0 [11:14:20.879] _save_context_stack = 0x0 [11:14:20.879] _local_sigjmp_buf = {{__jmpbuf = {0, -2379375235149565, 94844155979680, 94844155451368, 94844155979680, 94844155451296, -6014509968216927997, -2805919280246525}, __mask_was_saved = 0, __saved_mask = {__val = {94843111385571, 94844155447600, 112, 4, 94843111389988, 1884016255, 4, 94844155451296, 112, 73, 94844155979680, 94844155451368, 94844155451344, 94844155451296, 94843111477191, 1}}}} [11:14:20.879] _do_rethrow = [11:14:20.879] result = [11:14:20.879] nprocessed = [11:14:20.879] saveTopTransactionResourceOwner = 0x5642a035b958 [11:14:20.879] saveTopTransactionContext = 0x5642a03b2c10 [11:14:20.879] saveActivePortal = 0x0 [11:14:20.879] saveResourceOwner = 0x5642a035b958 [11:14:20.879] savePortalContext = 0x0 [11:14:20.879] saveMemoryContext = 0x5642a03b2c10 [11:14:20.879] __func__ = "PortalRun" [11:14:20.879] #16 0x0000564261c93c2d in exec_simple_query (query_string=query_string@entry=0x5642a031ca30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [11:14:20.879] cmdtaglen = 24 [11:14:20.879] snapshot_set = [11:14:20.879] per_parsetree_context = 0x0 [11:14:20.879] plantree_list = 0x5642a031e208 [11:14:20.879] parsetree = 0x5642a031d7a0 [11:14:20.879] commandTag = [11:14:20.879] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:14:20.879] querytree_list = [11:14:20.879] portal = 0x5642a039e7a0 [11:14:20.879] receiver = 0x5642a031e258 [11:14:20.879] format = 0 [11:14:20.879] cmdtagname = [11:14:20.879] parsetree_item__state = [11:14:20.879] dest = DestRemote [11:14:20.879] oldcontext = 0x5642a03b2c10 [11:14:20.879] parsetree_list = 0x5642a031d7d0 [11:14:20.879] parsetree_item = 0x5642a031d7e8 [11:14:20.879] save_log_statement_stats = false [11:14:20.879] was_logged = true [11:14:20.879] use_implicit_block = false [11:14:20.879] msec_str = "\004\000\000\000\000\000\000\000\262\327\364aBV\000\000\200\317Kp\375\177\000\000G\000\000\000\000\000\000" [11:14:20.879] __func__ = "exec_simple_query" [11:14:20.879] #17 0x0000564261c969b1 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [11:14:20.879] query_string = 0x5642a031ca30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [11:14:20.879] firstchar = [11:14:20.879] input_message = {data = 0x5642a031ca30 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [11:14:20.879] local_sigjmp_buf = {{__jmpbuf = {94843124025048, -2798307539529469, 140726487470332, 4, 5, 140726487470564, -6014509968288231165, -2805912606322429}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94844155178416, 14336, 94843124019136, 94844155701520, 5, 94843111389536, 0, 9, 2, 94843124025056, 94844155178416, 94843124019136, 4, 5, 140726487470564}}}} [11:14:20.879] send_ready_for_query = false [11:14:20.879] idle_in_transaction_timeout_enabled = false [11:14:20.879] idle_session_timeout_enabled = false [11:14:20.879] __func__ = "PostgresMain" [11:14:20.879] #18 0x0000564261c8c827 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [11:14:20.879] bsdata = [11:14:20.879] #19 0x0000564261b3ec32 in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7ffd704bd0fc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd704bd150) at ../src/backend/postmaster/launch_backend.c:274 [11:14:20.879] pid = [11:14:20.879] #20 0x0000564261b43c2d in BackendStartup (client_sock=client_sock@entry=0x7ffd704bd150) at ../src/backend/postmaster/postmaster.c:3377 [11:14:20.879] bn = 0x5642a0344338 [11:14:20.879] pid = [11:14:20.879] startup_data = {canAcceptConnections = CAC_OK} [11:14:20.879] cac = [11:14:20.879] __func__ = "BackendStartup" [11:14:20.879] #21 0x0000564261b45b06 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [11:14:20.879] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "c\203k\177\000\000\240o\263\204k\177\000\000\370\321Kp\375\177\000\000\364\321Kp\375\177", '\000' , "\242\022\317`BV\000\000X\367\312`BV\000\000\300\322Kp\375\177\000\000\270\322Kp\375\177\000\000\225[\362\001\000\000\000\000\240tH\204k\177\000\000+", '\000' , "BV\000\000\260\021\317`BV\000", __ss_align = 140099768190568}, salen = 2}} [11:14:20.879] i = 0 [11:14:20.879] now = [11:14:20.879] last_lockfile_recheck_time = 1731841818 [11:14:20.879] last_touch_time = 1731841818 [11:14:20.879] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x564260cf12a2}, {pos = -2065004952, events = 32619, fd = -2075625936, user_data = 0x7f6b84ea82e0}, {pos = 2090263927, events = 0, fd = 1884017472, user_data = 0x7f6b84e7ea48}, {pos = 15, events = 0, fd = -2075625936, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f6b84ea82e0}, {pos = 1884017336, events = 32765, fd = 1884017344, user_data = 0x7f6b84ea8668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -1607342368, events = 22082, fd = 1, user_data = 0x7ffd704bd7e3}, {pos = -1, events = 0, fd = -2090672096, user_data = 0x7f6b84b36fa0}, {pos = -1607172088, events = 22082, fd = -1607172376, user_data = 0x5642a03474b1}, {pos = -2065150274, events = 32619, fd = 1, user_data = 0x7f6b84ea82e0}, {pos = 427, events = 0, fd = 1649200472, user_data = 0x0}, {pos = 216, events = 0, fd = -1607349688, user_data = 0x7f6b84e84ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f6b8362e020}, {pos = -2089865664, events = 32619, fd = 16, user_data = 0x7ffd704bd710}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -2065141318, events = 32619, fd = 0, user_data = 0x7f6b836aeda4 }, {pos = 0, events = 0, fd = 1656130176, user_data = 0x2}, {pos = 0, events = 0, fd = -1607602608, user_data = 0x564261c2a882 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -1607349688, user_data = 0x7f6b84e84ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f6b836364c8}, {pos = -2090111225, events = 32619, fd = 1656186336, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -2088821664, events = 32619, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffff0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, 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 = -1607159952, user_data = 0x7f6b836b58be}, {pos = -2088838688, events = 32619, fd = -2090200722, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x134f7393c2a52b00}, {pos = -2088835616, events = 32619, fd = -328, user_data = 0x0}, {pos = -1607172696, events = 22082, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 26096, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1607349688, user_data = 0x7f6b836f3053 }, {pos = -1607172696, events = 22082, fd = 1024, user_data = 0x7ffd704bd7d8}, {pos = 1643638615, events = 22082, fd = 1656194704, user_data = 0x564261f6da14 }, {pos = -1607172896, events = 22082, fd = -1607349968, user_data = 0x5642a0347ce0}, {pos = -2090117269, events = 32619, fd = 0, user_data = 0x564261f7f67e }, {pos = -1607172896, events = 1, fd = 1643640775, user_data = 0x5642a031c930}, {pos = -1029362944, events = 323974035, fd = 0, user_data = 0x7f6b836a2ab1}, {pos = -2090199824, events = 32619, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1607602608, user_data = 0x134f7393c2a52b00}, {pos = 0, events = 0, fd = -1029362944, user_data = 0xc}, {pos = -1029362944, events = 323974035, fd = 0, user_data = 0x7f6b8365b239 }, {pos = 217, events = 0, fd = 1639180591, user_data = 0x400000}, {pos = 0, events = 0, fd = -1607602608, user_data = 0x564261f6d8a8 }, {pos = -1607516064, events = 22082, fd = -1607349968, user_data = 0x5642a02f4060}, {pos = 1, events = 0, fd = 0, user_data = 0x564261f2c2a5 }, {pos = 12, events = 0, fd = -1607177448, user_data = 0x5642a0346af8}, {pos = 1656131584, events = 22082, fd = 296, user_data = 0x564261b41149 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1639197062, events = 22082, fd = 1652566704, user_data = 0x5642a031d2d8}} [11:14:20.880] nevents = 1 [11:14:20.880] __func__ = "ServerLoop" [11:14:20.880] #22 0x0000564261b47397 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5642a02dacc0) at ../src/backend/postmaster/postmaster.c:1361 [11:14:20.880] opt = [11:14:20.880] status = [11:14:20.880] userDoption = [11:14:20.880] listen_addr_saved = false [11:14:20.880] output_config_variable = [11:14:20.880] __func__ = "PostmasterMain" [11:14:20.880] #23 0x00005642619820a3 in main (argc=4, argv=0x5642a02dacc0) at ../src/backend/main/main.c:196 [11:14:20.880] do_check_root = [11:14:20.915] -e [11:14:20.915] [11:14:20.915] [11:14:20.978] dumping /tmp/cores/postgres-6-36803.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [11:14:21.223] [New LWP 36803] [11:14:21.223] [11:14:21.223] This GDB supports auto-downloading debuginfo from the following URLs: [11:14:21.223] [11:14:21.223] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [11:14:21.223] Debuginfod has been disabled. [11:14:21.223] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [11:14:21.325] [Thread debugging using libthread_db enabled] [11:14:21.325] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [11:14:21.325] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW '. [11:14:21.325] Program terminated with signal SIGABRT, Aborted. [11:14:21.325] #0 0x00007fe4176a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:22.286] [11:14:22.286] Thread 1 (Thread 0x7fe4173e6f00 (LWP 36803)): [11:14:22.286] #0 0x00007fe4176a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:22.286] No symbol table info available. [11:14:22.286] #1 0x00007fe41765afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:22.286] No symbol table info available. [11:14:22.286] #2 0x00007fe417645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:22.286] No symbol table info available. [11:14:22.286] #3 0x00005591e382c93b in ExceptionalCondition (conditionName=conditionName@entry=0x5591e3aa24d5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5591e3aa19f0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [11:14:22.286] No locals. [11:14:22.286] #4 0x00005591e31ad01b in standard_ExecutorStart (queryDesc=0x5591f7cc1690, eflags=0) at ../src/backend/executor/execMain.c:195 [11:14:22.286] estate = 0x5591f7bfca40 [11:14:22.286] oldcontext = 0x5591f7bb17f0 [11:14:22.286] __func__ = "standard_ExecutorStart" [11:14:22.286] #5 0x00007fe4154276f7 in pgss_ExecutorStart (queryDesc=0x5591f7cc1690, eflags=) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [11:14:22.286] No locals. [11:14:22.286] #6 0x00005591e31ad1b0 in ExecutorStart (queryDesc=queryDesc@entry=0x5591f7cc1690, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:134 [11:14:22.286] No locals. [11:14:22.286] #7 0x00005591e30d15ae in refresh_matview_datafill (dest=0x5591f7bad578, query=, query@entry=0x5591f7bdd6b0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [11:14:22.286] rewritten = [11:14:22.286] plan = 0x5591f7cc0bc8 [11:14:22.286] queryDesc = 0x5591f7cc1690 [11:14:22.286] copied_query = [11:14:22.286] processed = [11:14:22.286] __func__ = "refresh_matview_datafill" [11:14:22.286] #8 0x00005591e30d3915 in RefreshMatViewByOid (matviewOid=28369, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [11:14:22.286] dest = [11:14:22.286] matviewRel = 0x7fe412f79728 [11:14:22.286] rule = [11:14:22.286] actions = [11:14:22.286] dataQuery = 0x5591f7bdd6b0 [11:14:22.286] tableSpace = [11:14:22.286] relowner = 10 [11:14:22.286] OIDNewHeap = 28376 [11:14:22.286] processed = 0 [11:14:22.286] relpersistence = 112 'p' [11:14:22.286] save_userid = 10 [11:14:22.286] save_sec_context = 0 [11:14:22.286] save_nestlevel = 2 [11:14:22.286] address = {classId = 0, objectId = 0, objectSubId = 0} [11:14:22.286] __func__ = "RefreshMatViewByOid" [11:14:22.286] #9 0x00005591e30d3a54 in ExecRefreshMatView (stmt=0x5591f7baade0, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [11:14:22.286] matviewOid = [11:14:22.286] lockmode = [11:14:22.286] #10 0x00005591e3089683 in ExecCreateTableAs (pstate=pstate@entry=0x5591f7bb18f0, stmt=stmt@entry=0x5591f7a6a790, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffdf9c4de80) at ../src/backend/commands/createas.c:351 [11:14:22.286] refresh = [11:14:22.286] query = 0x5591f7a6a950 [11:14:22.286] into = 0x5591f7a6a4e8 [11:14:22.286] jstate = 0x0 [11:14:22.286] is_matview = true [11:14:22.286] do_refresh = false [11:14:22.286] dest = [11:14:22.286] address = {classId = 1259, objectId = 28369, objectSubId = 0} [11:14:22.286] __func__ = "ExecCreateTableAs" [11:14:22.286] #11 0x00005591e35a4cf6 in ProcessUtilitySlow (pstate=pstate@entry=0x5591f7bb18f0, pstmt=pstmt@entry=0x5591f7a6a840, queryString=queryString@entry=0x5591f7a69a50 "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=0x5591f7a6b7e8, qc=0x7ffdf9c4de80) at ../src/backend/tcop/utility.c:1678 [11:14:22.286] _save_exception_stack = 0x7ffdf9c4da30 [11:14:22.286] _save_context_stack = 0x0 [11:14:22.286] _local_sigjmp_buf = {{__jmpbuf = {0, -9078688604708176896, 94085413513104, 0, 94085413509712, 0, -2965030928952624128, -9078644242091377664}, __mask_was_saved = 0, __saved_mask = {__val = {17353920415758785028, 3038567684446317545, 11102307609396555763, 3672368693164710999, 94085072388628, 0, 5412384741217271808, 94085078469120, 94085072641221, 140617550204224, 1, 16777216, 0, 112, 94085072388900, 140617550741504}}}} [11:14:22.286] _do_rethrow = false [11:14:22.286] parsetree = 0x5591f7a6a790 [11:14:22.286] isTopLevel = true [11:14:22.286] isCompleteQuery = true [11:14:22.286] needCleanup = false [11:14:22.286] commandCollected = false [11:14:22.286] address = {classId = 21905, objectId = 4154894224, objectSubId = 21905} [11:14:22.286] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [11:14:22.286] __func__ = "ProcessUtilitySlow" [11:14:22.286] #12 0x00005591e35a3307 in standard_ProcessUtility (pstmt=pstmt@entry=0x5591f7a6a840, queryString=queryString@entry=0x5591f7a69a50 "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=0x5591f7a6b7e8, qc=0x7ffdf9c4de80) at ../src/backend/tcop/utility.c:1070 [11:14:22.286] parsetree = 0x5591f7a6a790 [11:14:22.286] isTopLevel = true [11:14:22.286] isAtomicContext = false [11:14:22.286] pstate = 0x5591f7bb18f0 [11:14:22.286] readonly_flags = [11:14:22.286] __func__ = "standard_ProcessUtility" [11:14:22.286] #13 0x00007fe41542ad9d in pgss_ProcessUtility (pstmt=0x5591f7a6a840, queryString=0x5591f7a69a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5591f7a6b7e8, qc=0x7ffdf9c4de80) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [11:14:22.286] _save_exception_stack = 0x7ffdf9c4dd40 [11:14:22.286] _save_context_stack = 0x0 [11:14:22.286] _local_sigjmp_buf = {{__jmpbuf = {0, 2963909093380291584, 94085413513280, 94085413517288, 140728793882240, 0, -2965030929409803264, -2960622968320066560}, __mask_was_saved = 0, __saved_mask = {__val = {94085076215555, 140728793881510, 140728793881508, 0, 0, 139637976727552, 206158430232, 140728793881472, 94085076215772, 0, 206158430232, 94085413514080, 140728793881568, 0, 94085071023186, 94085413509456}}}} [11:14:22.286] _do_rethrow = false [11:14:22.286] duration = [11:14:22.286] bufusage = {shared_blks_hit = 94085415161464, shared_blks_read = 622770257920, shared_blks_dirtied = 0, shared_blks_written = 94085415160968, local_blks_hit = 94085415161464, local_blks_read = 94085069353128, local_blks_dirtied = 94085415960008, local_blks_written = 94085069353374, temp_blks_read = 94085415160968, temp_blks_written = 94085415160384, shared_blk_read_time = {ticks = 94085069352483}, shared_blk_write_time = {ticks = 94085076209007}, local_blk_read_time = {ticks = 140617619238328}, local_blk_write_time = {ticks = 94085413509712}, temp_blk_read_time = {ticks = 94085078540325}, temp_blk_write_time = {ticks = 94085088523618}} [11:14:22.286] walusage_start = {wal_records = 8962, wal_fpi = 112, wal_bytes = 1152223} [11:14:22.286] start = [11:14:22.286] rows = [11:14:22.286] bufusage_start = {shared_blks_hit = 34380, shared_blks_read = 3666, shared_blks_dirtied = 1530, shared_blks_written = 1044, 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}} [11:14:22.286] walusage = {wal_records = 0, wal_fpi = 0, wal_bytes = 140617550204224} [11:14:22.286] parsetree = [11:14:22.286] saved_queryId = 6041762721901209185 [11:14:22.286] saved_stmt_location = 0 [11:14:22.286] saved_stmt_len = 69 [11:14:22.286] enabled = true [11:14:22.286] #14 0x00005591e35a33ad in ProcessUtility (pstmt=pstmt@entry=0x5591f7a6a840, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5591f7a6b7e8, qc=0x7ffdf9c4de80) at ../src/backend/tcop/utility.c:519 [11:14:22.286] No locals. [11:14:22.286] #15 0x00005591e359ecce in PortalRunUtility (portal=portal@entry=0x5591f7aecfc0, pstmt=pstmt@entry=0x5591f7a6a840, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5591f7a6b7e8, qc=qc@entry=0x7ffdf9c4de80) at ../src/backend/tcop/pquery.c:1158 [11:14:22.286] No locals. [11:14:22.286] #16 0x00005591e359f273 in PortalRunMulti (portal=portal@entry=0x5591f7aecfc0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5591f7a6b7e8, altdest=altdest@entry=0x5591f7a6b7e8, qc=qc@entry=0x7ffdf9c4de80) at ../src/backend/tcop/pquery.c:1315 [11:14:22.286] pstmt = 0x5591f7a6a840 [11:14:22.286] stmtlist_item__state = [11:14:22.286] active_snapshot_set = false [11:14:22.286] stmtlist_item = 0x5591f7a6b7b0 [11:14:22.286] #17 0x00005591e359f846 in PortalRun (portal=portal@entry=0x5591f7aecfc0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5591f7a6b7e8, altdest=altdest@entry=0x5591f7a6b7e8, qc=0x7ffdf9c4de80) at ../src/backend/tcop/pquery.c:791 [11:14:22.286] _save_exception_stack = 0x7ffdf9c4df30 [11:14:22.286] _save_context_stack = 0x0 [11:14:22.286] _local_sigjmp_buf = {{__jmpbuf = {0, -9078688604763751424, 94085414047680, 94085413513224, 94085414047680, 94085413513152, -2965030929269294080, -9078644222704124928}, __mask_was_saved = 0, __saved_mask = {__val = {94085075892707, 94085413509456, 112, 4, 94085075897124, 4190428687, 4, 94085413513152, 112, 73, 94085414047680, 94085413513224, 94085413513200, 94085413513152, 94085075984327, 1}}}} [11:14:22.286] _do_rethrow = [11:14:22.286] result = [11:14:22.286] nprocessed = [11:14:22.286] saveTopTransactionResourceOwner = 0x5591f7aac498 [11:14:22.286] saveTopTransactionContext = 0x5591f7afefe0 [11:14:22.286] saveActivePortal = 0x0 [11:14:22.286] saveResourceOwner = 0x5591f7aac498 [11:14:22.286] savePortalContext = 0x0 [11:14:22.286] saveMemoryContext = 0x5591f7afefe0 [11:14:22.286] __func__ = "PortalRun" [11:14:22.286] #18 0x00005591e3598c2d in exec_simple_query (query_string=query_string@entry=0x5591f7a69a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [11:14:22.286] cmdtaglen = 24 [11:14:22.286] snapshot_set = [11:14:22.286] per_parsetree_context = 0x0 [11:14:22.286] plantree_list = 0x5591f7a6b798 [11:14:22.286] parsetree = 0x5591f7a6a7c0 [11:14:22.286] commandTag = [11:14:22.286] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:14:22.286] querytree_list = [11:14:22.286] portal = 0x5591f7aecfc0 [11:14:22.286] receiver = 0x5591f7a6b7e8 [11:14:22.286] format = 0 [11:14:22.286] cmdtagname = [11:14:22.286] parsetree_item__state = [11:14:22.286] dest = DestRemote [11:14:22.286] oldcontext = 0x5591f7afefe0 [11:14:22.286] parsetree_list = 0x5591f7a6a7f0 [11:14:22.286] parsetree_item = 0x5591f7a6a808 [11:14:22.286] save_log_statement_stats = false [11:14:22.286] was_logged = true [11:14:22.286] use_implicit_block = false [11:14:22.286] msec_str = "\004\000\000\000\000\000\000\000\262'\205\343\221U\000\000\020\337\304\371\375\177\000\000G\000\000\000\000\000\000" [11:14:22.286] __func__ = "exec_simple_query" [11:14:22.286] #19 0x00005591e359b9b1 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [11:14:22.286] query_string = 0x5591f7a69a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [11:14:22.286] firstchar = [11:14:22.286] input_message = {data = 0x5591f7a69a50 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [11:14:22.286] local_sigjmp_buf = {{__jmpbuf = {94085088532184, -9078655337053324288, 140728793882764, 4, 5, 140728793882996, -2965030929206379520, -9078644220779201536}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94085413767536, 0, 168, 94085075897226, 0, 10, 2, 94085088532192, 94085413240304, 94085088526272, 4, 5, 140728793882996}}}} [11:14:22.286] send_ready_for_query = false [11:14:22.286] idle_in_transaction_timeout_enabled = false [11:14:22.286] idle_session_timeout_enabled = false [11:14:22.286] __func__ = "PostgresMain" [11:14:22.286] #20 0x00005591e3591827 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [11:14:22.286] bsdata = [11:14:22.286] #21 0x00005591e3443c32 in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7ffdf9c4e08c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdf9c4e0e0) at ../src/backend/postmaster/launch_backend.c:274 [11:14:22.286] pid = [11:14:22.286] #22 0x00005591e3448c2d in BackendStartup (client_sock=client_sock@entry=0x7ffdf9c4e0e0) at ../src/backend/postmaster/postmaster.c:3377 [11:14:22.286] bn = 0x5591f7a96178 [11:14:22.286] pid = [11:14:22.286] startup_data = {canAcceptConnections = CAC_OK} [11:14:22.286] cac = [11:14:22.286] __func__ = "BackendStartup" [11:14:22.286] #23 0x00005591e344ab06 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [11:14:22.286] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\304\371\375\177\000\000t\341\304\371\375\177", '\000' , "\242b_\342\221U\000\000XG[\342\221U\000\000@\342\304\371\375\177\000\0008\342\304\371\375\177\000\000\225[\362\001\000\000\000\000p:\251\367\221U\000\000,", '\000' , "\260a_\342\221U\000\000h\206\354\030\344\177\000\0000f\343\027\344\177\000", __ss_align = 140617647424224}, salen = 2}} [11:14:22.286] i = 0 [11:14:22.286] now = [11:14:22.286] last_lockfile_recheck_time = 1731841852 [11:14:22.286] last_touch_time = 1731841852 [11:14:22.286] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -497065310, events = 21905, fd = 418154088, user_data = 0x7fe417e36630}, {pos = 418153184, events = 32740, fd = 2090263927, user_data = 0x7ffdf9c4e2c0}, {pos = 417983048, events = 32740, fd = 15, user_data = 0x7fe417e36630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 418153184, events = 32740, fd = -104537544, user_data = 0x7ffdf9c4e240}, {pos = 418154088, events = 32740, fd = 0, user_data = 0x5591f7a980c8}, {pos = -477370895, events = 21905, fd = 32768, user_data = 0x1}, {pos = -140073616, events = 21905, fd = -1, user_data = 0x7fe41762e020}, {pos = 414388128, events = 32740, fd = -139876776, user_data = 0x5591f7a9a538}, {pos = -139853567, events = 21905, fd = 418008766, user_data = 0x1}, {pos = 418153184, events = 32740, fd = 427, user_data = 0x5591e3dd1d58 }, {pos = 0, events = 0, fd = 86, user_data = 0x5591f7a980c8}, {pos = 418008766, events = 32740, fd = 1, user_data = 0x0}, {pos = 392355872, events = 32740, fd = 393162304, user_data = 0x10}, {pos = -104536416, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 418017722, user_data = 0x0}, {pos = 392883620, events = 32740, fd = 0, user_data = 0x5591e446da80 }, {pos = 2, events = 0, fd = 0, user_data = 0x5591f7a2be90}, {pos = -481117111, events = 21905, fd = -139859621, user_data = 0x5591e352f882 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5591f7a980c8}, {pos = 418008766, events = 32740, fd = 1, user_data = 0x0}, {pos = 392389832, events = 32740, fd = 392808576, user_data = 0x42d}, {pos = 392916743, events = 32740, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 394206304, events = 32740, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {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 = 400782656, user_data = 0x7fe417e37a80}, {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 = 0xa}, {pos = -477693469, events = 21905, fd = -139847376, user_data = 0x7fe4176b576b}, {pos = 394189280, events = 32740, fd = 392827246, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x9f43b0d528af6e00}, {pos = 394192352, events = 32740, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -139877384, user_data = 0x3}, {pos = 0, events = 0, fd = 32728, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -139886392, user_data = 0x7fe4176f3053 }, {pos = -139877384, events = 21905, fd = 1024, user_data = 0x7ffdf9c4e768}, {pos = -477610153, events = 21905, fd = -465054064, user_data = 0x5591e3872a14 }, {pos = -139877584, events = 21905, fd = -140076720, user_data = 0x5591f7a9a330}, {pos = 392910699, events = 32740, fd = 0, user_data = 0x5591e388467e }, {pos = -139877584, events = 1, fd = -477607993, user_data = 0x5591f7a69950}, {pos = 682585600, events = 2672013525, fd = 0, user_data = 0x7fe4176a2ab1}, {pos = 392828144, events = 32740, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -140329328, user_data = 0x9f43b0d528af6e00}, {pos = 0, events = 0, fd = 682585600, user_data = 0xc}, {pos = 682585600, events = 2672013525, fd = 0, user_data = 0x7fe41765b239 }, {pos = 87, events = 0, fd = -482068177, user_data = 0x400000}, {pos = 0, events = 0, fd = -140329328, user_data = 0x5591e38728a8 }, {pos = -140242816, events = 21905, fd = -140076720, user_data = 0x5591f7a41080}, {pos = 1, events = 0, fd = 0, user_data = 0x5591e38312a5 }, {pos = 12, events = 0, fd = -139890440, user_data = 0x5591f7a970d8}, {pos = -465117184, events = 21905, fd = 296, user_data = 0x5591e3446149 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -482051706, events = 21905, fd = -468682064, user_data = 0x5591f7a6a308}} [11:14:22.287] nevents = 1 [11:14:22.287] __func__ = "ServerLoop" [11:14:22.287] #24 0x00005591e344c397 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5591f7a27cf0) at ../src/backend/postmaster/postmaster.c:1361 [11:14:22.287] opt = [11:14:22.287] status = [11:14:22.287] userDoption = [11:14:22.287] listen_addr_saved = false [11:14:22.287] output_config_variable = [11:14:22.287] __func__ = "PostmasterMain" [11:14:22.287] #25 0x00005591e32870a3 in main (argc=4, argv=0x5591f7a27cf0) at ../src/backend/main/main.c:196 [11:14:22.287] do_check_root = [11:14:22.320] -e [11:14:22.320] [11:14:22.320] [11:14:22.383] dumping /tmp/cores/postgres-6-29083.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [11:14:22.642] [New LWP 29083] [11:14:22.642] [11:14:22.642] This GDB supports auto-downloading debuginfo from the following URLs: [11:14:22.642] [11:14:22.642] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [11:14:22.642] Debuginfod has been disabled. [11:14:22.642] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [11:14:22.745] [Thread debugging using libthread_db enabled] [11:14:22.745] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [11:14:22.745] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW '. [11:14:22.745] Program terminated with signal SIGABRT, Aborted. [11:14:22.745] #0 0x00007f7e9cca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:23.679] [11:14:23.679] Thread 1 (Thread 0x7f7e9aa34f00 (LWP 29083)): [11:14:23.679] #0 0x00007f7e9cca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:23.679] No symbol table info available. [11:14:23.679] #1 0x00007f7e9cc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:23.679] No symbol table info available. [11:14:23.679] #2 0x00007f7e9cc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [11:14:23.679] No symbol table info available. [11:14:23.679] #3 0x00005617d3f2693b in ExceptionalCondition (conditionName=conditionName@entry=0x5617d419c4d5 "queryDesc->sourceText != NULL", fileName=fileName@entry=0x5617d419b9f0 "../src/backend/executor/execMain.c", lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [11:14:23.679] No locals. [11:14:23.679] #4 0x00005617d38a701b in standard_ExecutorStart (queryDesc=queryDesc@entry=0x5618085eea00, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:195 [11:14:23.679] estate = 0x5618085020d0 [11:14:23.679] oldcontext = 0x561808544480 [11:14:23.679] __func__ = "standard_ExecutorStart" [11:14:23.679] #5 0x00005617d38a71f7 in ExecutorStart (queryDesc=queryDesc@entry=0x5618085eea00, eflags=eflags@entry=0) at ../src/backend/executor/execMain.c:136 [11:14:23.679] No locals. [11:14:23.679] #6 0x00005617d37cb5ae in refresh_matview_datafill (dest=0x56180851cce8, query=, query@entry=0x56180853f5a0, queryString=queryString@entry=0x0, is_create=is_create@entry=false) at ../src/backend/commands/matview.c:446 [11:14:23.679] rewritten = [11:14:23.679] plan = 0x5618085edf38 [11:14:23.679] queryDesc = 0x5618085eea00 [11:14:23.679] copied_query = [11:14:23.679] processed = [11:14:23.679] __func__ = "refresh_matview_datafill" [11:14:23.679] #7 0x00005617d37cd915 in RefreshMatViewByOid (matviewOid=28380, is_create=is_create@entry=false, skipData=, concurrent=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:330 [11:14:23.679] dest = [11:14:23.679] matviewRel = 0x7f7e911830b8 [11:14:23.679] rule = [11:14:23.679] actions = [11:14:23.679] dataQuery = 0x56180853f5a0 [11:14:23.679] tableSpace = [11:14:23.679] relowner = 10 [11:14:23.679] OIDNewHeap = 28398 [11:14:23.679] processed = 0 [11:14:23.679] relpersistence = 112 'p' [11:14:23.679] save_userid = 10 [11:14:23.679] save_sec_context = 0 [11:14:23.679] save_nestlevel = 2 [11:14:23.679] address = {classId = 0, objectId = 0, objectSubId = 0} [11:14:23.679] __func__ = "RefreshMatViewByOid" [11:14:23.679] #8 0x00005617d37cda54 in ExecRefreshMatView (stmt=0x561808534e40, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [11:14:23.679] matviewOid = [11:14:23.679] lockmode = [11:14:23.679] #9 0x00005617d3783683 in ExecCreateTableAs (pstate=pstate@entry=0x561808544580, stmt=stmt@entry=0x5618083d47f0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x7ffec38b0c00) at ../src/backend/commands/createas.c:351 [11:14:23.679] refresh = [11:14:23.679] query = 0x5618083d49b0 [11:14:23.679] into = 0x5618083d4548 [11:14:23.679] jstate = 0x0 [11:14:23.679] is_matview = true [11:14:23.679] do_refresh = false [11:14:23.679] dest = [11:14:23.679] address = {classId = 1259, objectId = 28380, objectSubId = 0} [11:14:23.679] __func__ = "ExecCreateTableAs" [11:14:23.679] #10 0x00005617d3c9ecf6 in ProcessUtilitySlow (pstate=pstate@entry=0x561808544580, pstmt=pstmt@entry=0x5618083d48a0, queryString=queryString@entry=0x5618083d3ab0 "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=0x5618083d52d8, qc=0x7ffec38b0c00) at ../src/backend/tcop/utility.c:1678 [11:14:23.679] _save_exception_stack = 0x7ffec38b0ac0 [11:14:23.679] _save_context_stack = 0x0 [11:14:23.679] _local_sigjmp_buf = {{__jmpbuf = {0, 3227392506410675726, 94661217437680, 0, 94661217434288, 0, 9153450854223556110, 3230690118232288782}, __mask_was_saved = 0, __saved_mask = {__val = {140181584953984, 10559, 94660336887335, 1, 4294977855, 140181584953984, 94660336877653, 1, 45350699149960, 1, 10559, 140181584953984, 140181584953984, 1, 94660336887682, 94661218675336}}}} [11:14:23.679] _do_rethrow = false [11:14:23.679] parsetree = 0x5618083d47f0 [11:14:23.679] isTopLevel = true [11:14:23.679] isCompleteQuery = true [11:14:23.679] needCleanup = false [11:14:23.679] commandCollected = false [11:14:23.679] address = {classId = 22040, objectId = 138233840, objectSubId = 22040} [11:14:23.679] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [11:14:23.679] __func__ = "ProcessUtilitySlow" [11:14:23.679] #11 0x00005617d3c9d307 in standard_ProcessUtility (pstmt=0x5618083d48a0, queryString=0x5618083d3ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5618083d52d8, qc=0x7ffec38b0c00) at ../src/backend/tcop/utility.c:1070 [11:14:23.679] parsetree = 0x5618083d47f0 [11:14:23.679] isTopLevel = true [11:14:23.679] isAtomicContext = false [11:14:23.679] pstate = 0x561808544580 [11:14:23.679] readonly_flags = [11:14:23.679] __func__ = "standard_ProcessUtility" [11:14:23.679] #12 0x00005617d3c9d462 in ProcessUtility (pstmt=pstmt@entry=0x5618083d48a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5618083d52d8, qc=0x7ffec38b0c00) at ../src/backend/tcop/utility.c:523 [11:14:23.679] No locals. [11:14:23.679] #13 0x00005617d3c98cce in PortalRunUtility (portal=portal@entry=0x5618084580c0, pstmt=pstmt@entry=0x5618083d48a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5618083d52d8, qc=qc@entry=0x7ffec38b0c00) at ../src/backend/tcop/pquery.c:1158 [11:14:23.679] No locals. [11:14:23.679] #14 0x00005617d3c99273 in PortalRunMulti (portal=portal@entry=0x5618084580c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x5618083d52d8, altdest=altdest@entry=0x5618083d52d8, qc=qc@entry=0x7ffec38b0c00) at ../src/backend/tcop/pquery.c:1315 [11:14:23.679] pstmt = 0x5618083d48a0 [11:14:23.679] stmtlist_item__state = [11:14:23.679] active_snapshot_set = false [11:14:23.679] stmtlist_item = 0x5618083d52a0 [11:14:23.679] #15 0x00005617d3c99846 in PortalRun (portal=portal@entry=0x5618084580c0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5618083d52d8, altdest=altdest@entry=0x5618083d52d8, qc=0x7ffec38b0c00) at ../src/backend/tcop/pquery.c:791 [11:14:23.679] _save_exception_stack = 0x7ffec38b0cb0 [11:14:23.679] _save_context_stack = 0x0 [11:14:23.679] _local_sigjmp_buf = {{__jmpbuf = {0, 3227392506617245198, 94661217976512, 94661217437800, 94661217976512, 94661217437728, 9153450854353579534, 3230690116023856654}, __mask_was_saved = 0, __saved_mask = {__val = {94660340390371, 94661217434032, 112, 4, 94660340394788, 3280669583, 4, 94661217437728, 112, 73, 94661217976512, 94661217437800, 94661217437776, 94661217437728, 94660340481991, 1}}}} [11:14:23.679] _do_rethrow = [11:14:23.679] result = [11:14:23.679] nprocessed = [11:14:23.679] saveTopTransactionResourceOwner = 0x561808414d78 [11:14:23.679] saveTopTransactionContext = 0x56180846a4f0 [11:14:23.679] saveActivePortal = 0x0 [11:14:23.679] saveResourceOwner = 0x561808414d78 [11:14:23.679] savePortalContext = 0x0 [11:14:23.679] saveMemoryContext = 0x56180846a4f0 [11:14:23.679] __func__ = "PortalRun" [11:14:23.679] #16 0x00005617d3c92c2d in exec_simple_query (query_string=query_string@entry=0x5618083d3ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [11:14:23.679] cmdtaglen = 24 [11:14:23.679] snapshot_set = [11:14:23.679] per_parsetree_context = 0x0 [11:14:23.679] plantree_list = 0x5618083d5288 [11:14:23.679] parsetree = 0x5618083d4820 [11:14:23.679] commandTag = [11:14:23.679] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [11:14:23.679] querytree_list = [11:14:23.679] portal = 0x5618084580c0 [11:14:23.679] receiver = 0x5618083d52d8 [11:14:23.679] format = 0 [11:14:23.679] cmdtagname = [11:14:23.679] parsetree_item__state = [11:14:23.679] dest = DestRemote [11:14:23.679] oldcontext = 0x56180846a4f0 [11:14:23.679] parsetree_list = 0x5618083d4850 [11:14:23.679] parsetree_item = 0x5618083d4868 [11:14:23.679] save_log_statement_stats = false [11:14:23.679] was_logged = false [11:14:23.679] use_implicit_block = false [11:14:23.679] msec_str = "\004\000\000\000\000\000\000\000\262\307\364\323\027V\000\000\220\f\213\303\376\177\000\000G\000\000\000\000\000\000" [11:14:23.679] __func__ = "exec_simple_query" [11:14:23.679] #17 0x00005617d3c959b1 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [11:14:23.679] query_string = 0x5618083d3ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [11:14:23.679] firstchar = [11:14:23.679] input_message = {data = 0x5618083d3ab0 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [11:14:23.679] local_sigjmp_buf = {{__jmpbuf = {94660353029848, 3230692228122652174, 140732179090956, 4, 10, 140732179091188, 9153450854559100430, 3230690113812672014}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94661217164752, 15616, 94660353023936, 94661217697072, 10, 94660340394336, 0, 9, 2, 94660353029856, 94661217164752, 94660353023936, 4, 10, 140732179091188}}}} [11:14:23.679] send_ready_for_query = false [11:14:23.679] idle_in_transaction_timeout_enabled = false [11:14:23.679] idle_session_timeout_enabled = false [11:14:23.679] __func__ = "PostgresMain" [11:14:23.679] #18 0x00005617d3c8b827 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [11:14:23.679] bsdata = [11:14:23.679] #19 0x00005617d3b3dc32 in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x7ffec38b0e0c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffec38b0e60) at ../src/backend/postmaster/launch_backend.c:274 [11:14:23.679] pid = [11:14:23.679] #20 0x00005617d3b42c2d in BackendStartup (client_sock=client_sock@entry=0x7ffec38b0e60) at ../src/backend/postmaster/postmaster.c:3377 [11:14:23.679] bn = 0x5618083fc1d8 [11:14:23.679] pid = [11:14:23.679] startup_data = {canAcceptConnections = CAC_OK} [11:14:23.679] cac = [11:14:23.679] __func__ = "BackendStartup" [11:14:23.679] #21 0x00005617d3b44b06 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [11:14:23.679] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\213\303\376\177\000\000\364\016\213\303\376\177", '\000' , "\242\002\317\322\027V\000\000X\347\312\322\027V\000\000\300\017\213\303\376\177\000\000\270\017\213\303\376\177\000\000\225[\362\001\000\000\000\000\240\304C\235~\177\000\000+", '\000' , "\260\001\317\322\027V\000\000h\026K\236~\177\000\0000\306C\235~\177\000", __ss_align = 140181798327008}, salen = 2}} [11:14:23.679] i = 0 [11:14:23.679] now = [11:14:23.679] last_lockfile_recheck_time = 1731841815 [11:14:23.679] last_touch_time = 1731841815 [11:14:23.679] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -758185310, events = 22039, fd = -1639246232, user_data = 0x7f7e9d43c630}, {pos = -1639247136, events = 32638, fd = 2090263927, user_data = 0x7ffec38b1040}, {pos = -1639417272, events = 32638, fd = 15, user_data = 0x7f7e9d43c630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1639247136, events = 32638, fd = -1014296648, user_data = 0x7ffec38b0fc0}, {pos = -1639246232, events = 32638, fd = 0, user_data = 0x5618083d3b70}, {pos = -738490895, events = 22039, fd = 32768, user_data = 0x1}, {pos = 138237856, events = 22040, fd = -1, user_data = 0x7f7e9cc2e020}, {pos = -1642930272, events = 32638, fd = 138408280, user_data = 0x5618083ff038}, {pos = 138417185, events = 22040, fd = -1639391554, user_data = 0x1}, {pos = -1639247136, events = 32638, fd = 427, user_data = 0x5617d44cbd58 }, {pos = 0, events = 0, fd = 236, user_data = 0x5618083d3b70}, {pos = -1639391554, events = 32638, fd = 1, user_data = 0x0}, {pos = -1664950240, events = 32638, fd = -1664143808, user_data = 0x10}, {pos = -1014295520, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1639382598, user_data = 0x0}, {pos = -1664422492, events = 32638, fd = 0, user_data = 0x5617d4b67a80 }, {pos = 2, events = 0, fd = 0, user_data = 0x561808395e70}, {pos = -742237111, events = 22039, fd = 138439899, user_data = 0x5617d3c29882 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5618083d3b70}, {pos = -1639391554, events = 32638, fd = 1, user_data = 0x0}, {pos = -1664916280, events = 32638, fd = -1664497536, user_data = 0x42d}, {pos = -1664389369, events = 32638, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -1663099808, events = 32638, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x61504a532d737365}, {pos = 168457077, events = 874520608, fd = 822763892, user_data = 0x30340a3531383134}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, 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 = 0, user_data = 0xa}, {pos = -738813469, events = 22039, fd = 138423376, user_data = 0x7f7e9ccb576b}, {pos = -1663116832, events = 32638, fd = -1664478866, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xf55602b7b5dbf200}, {pos = -1663113760, events = 32638, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 138407672, user_data = 0x3}, {pos = 0, events = 0, fd = 25487, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 138230640, user_data = 0x7f7e9ccf3053 }, {pos = 138407672, events = 22040, fd = 1024, user_data = 0x7ffec38b14e8}, {pos = -738730153, events = 22039, fd = -726174064, user_data = 0x5617d3f6ca14 }, {pos = 138407472, events = 22040, fd = 138230192, user_data = 0x5618083fee30}, {pos = -1664395413, events = 32638, fd = 0, user_data = 0x5617d3f7e67e }, {pos = 138407472, events = 1, fd = -738727993, user_data = 0x5618083d39b0}, {pos = -1243876864, events = 4116054711, fd = 0, user_data = 0x7f7e9cca2ab1}, {pos = -1664477968, events = 32638, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 137977456, user_data = 0xf55602b7b5dbf200}, {pos = 0, events = 0, fd = -1243876864, user_data = 0xc}, {pos = -1243876864, events = 4116054711, fd = 0, user_data = 0x7f7e9cc5b239 }, {pos = 237, events = 0, fd = -743188177, user_data = 0x400000}, {pos = 0, events = 0, fd = 137977456, user_data = 0x5617d3f6c8a8 }, {pos = 138064096, events = 22040, fd = 138230192, user_data = 0x5618083ab0e0}, {pos = 1, events = 0, fd = 0, user_data = 0x5617d3f2b2a5 }, {pos = 12, events = 0, fd = 138407048, user_data = 0x5618083fec68}, {pos = -726237184, events = 22039, fd = 296, user_data = 0x5617d3b40149 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -743171706, events = 22039, fd = -729802064, user_data = 0x5618083d4388}} [11:14:23.680] nevents = 1 [11:14:23.680] __func__ = "ServerLoop" [11:14:23.680] #22 0x00005617d3b46397 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x561808391d30) at ../src/backend/postmaster/postmaster.c:1361 [11:14:23.680] opt = [11:14:23.680] status = [11:14:23.680] userDoption = [11:14:23.680] listen_addr_saved = false [11:14:23.680] output_config_variable = [11:14:23.680] __func__ = "PostmasterMain" [11:14:23.680] #23 0x00005617d39810a3 in main (argc=8, argv=0x561808391d30) at ../src/backend/main/main.c:196 [11:14:23.680] do_check_root =