暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
首页 / OB -4013 报错 SqlExecutor内存占用高定位案例

OB -4013 报错 SqlExecutor内存占用高定位案例

原创 范计杰 2024-08-14
272

概述

通过该案例，演示当内存占用高或相关报错时，应该怎么获取定位信息，这里不讨论案例中具体导致内存占用高的原因。

示例

1、构造一行LOB数据时报错 -4013, No memory or reach tenant memory limit

DECLARE
c blob;
BEGIN
dbms_lob.createtemporary(lob_loc => c, cache => true, dur => dbms_lob.call);
    FOR i IN 1..10240 loop
    DBMS_LOB.WRITEAPPEND(c,1024,hextoraw(rpad('01',2048,'01')));
END LOOP;
INSERT INTO  tlob VALUES (2,c);
COMMIT;
END;
/


obclient [SYS]> DECLARE
    -> c blob;
    -> BEGIN
    -> dbms_lob.createtemporary(lob_loc => c, cache => FALSE, dur => dbms_lob.call);
    ->     FOR i IN 1..10240 loop
    ->     DBMS_LOB.WRITEAPPEND(c,1024,hextoraw(rpad('01',2048,'01')));
    -> END LOOP;
    -> INSERT INTO  tlob VALUES (2,c);
    -> COMMIT;
    -> END;
    -> /
ORA-00600: internal error code, arguments: -4013, No memory or reach tenant memory limit

2、 因能重现，在执行过程中查询TOP MOD占用，可以看到SQL_EXEC_CTX_ID CTX内存使用不断增长，增长到100G以上后释放（SQL执行报错后释放）

obclient [oceanbase]> select * from __all_virtual_tenant_ctx_memory_info where  tenant_id=1001 order by hold desc limit 30;
+-----------+---------------+----------+--------+----------------------+-------------+-------------+
| tenant_id | svr_ip        | svr_port | ctx_id | ctx_name             | hold        | used        |
+-----------+---------------+----------+--------+----------------------+-------------+-------------+
|      1001 | 192.168.56.36 |     2882 |      5 | SQL_EXEC_CTX_ID      | 25035800576 | 20710254976 |
|      1001 | 192.168.56.37 |     2882 |     31 | KVSTORE_CACHE_ID     |  1927282688 |  1927282688 |
|      1001 | 192.168.56.38 |     2882 |     31 | KVSTORE_CACHE_ID     |  1862270976 |  1862270976 |
|      1001 | 192.168.56.36 |     2882 |      0 | DEFAULT_CTX_ID       |  1698693120 |  1606241648 |
|      1001 | 192.168.56.36 |     2882 |      1 | MEMSTORE_CTX_ID      |  1075838976 |  1073507456 |
|      1001 | 192.168.56.38 |     2882 |      1 | MEMSTORE_CTX_ID      |   643825664 |   641602176 |
|      1001 | 192.168.56.37 |     2882 |      1 | MEMSTORE_CTX_ID      |   599785472 |   597572736 |
|      1001 | 192.168.56.38 |     2882 |      5 | SQL_EXEC_CTX_ID      |   528482304 |       27776 |
|      1001 | 192.168.56.37 |     2882 |      5 | SQL_EXEC_CTX_ID      |   463470592 |       27776 |
|      1001 | 192.168.56.37 |     2882 |      0 | DEFAULT_CTX_ID       |   318767104 |   253025472 |
|      1001 | 192.168.56.36 |     2882 |     32 | TX_CALLBACK_CTX_ID   |   304087040 |   122315648 |
|      1001 | 192.168.56.38 |     2882 |      0 | DEFAULT_CTX_ID       |   293601280 |   217898304 |
|      1001 | 192.168.56.37 |     2882 |     32 | TX_CALLBACK_CTX_ID   |   199229440 |    22649216 |
|      1001 | 192.168.56.38 |     2882 |     32 | TX_CALLBACK_CTX_ID   |   186646528 |    20742080 |
|      1001 | 192.168.56.36 |     2882 |     31 | KVSTORE_CACHE_ID     |    33554432 |    33554432 |
|      1001 | 192.168.56.36 |     2882 |     22 | PLAN_CACHE_CTX_ID    |    25165824 |    13518752 |
|      1001 | 192.168.56.37 |     2882 |      6 | TRANS_CTX_MGR_ID     |    16777216 |      848128 |
|      1001 | 192.168.56.36 |     2882 |      6 | TRANS_CTX_MGR_ID     |    16777216 |      848128 |
|      1001 | 192.168.56.37 |     2882 |     17 | REPLAY_STATUS_CTX_ID |    16777216 |     1165696 |
|      1001 | 192.168.56.36 |     2882 |     24 | WORK_AREA            |    16777216 |       27776 |
|      1001 | 192.168.56.36 |     2882 |      4 | EXECUTE_CTX_ID       |    16777216 |       36032 |
|      1001 | 192.168.56.36 |     2882 |     17 | REPLAY_STATUS_CTX_ID |    16777216 |     1165696 |
|      1001 | 192.168.56.38 |     2882 |      6 | TRANS_CTX_MGR_ID     |    14680064 |      844160 |
|      1001 | 192.168.56.36 |     2882 |     33 | PS_CACHE_CTX_ID      |    14680064 |       79136 |
|      1001 | 192.168.56.38 |     2882 |     17 | REPLAY_STATUS_CTX_ID |    14680064 |     1161728 |
|      1001 | 192.168.56.37 |     2882 |     22 | PLAN_CACHE_CTX_ID    |    10485760 |      674976 |
|      1001 | 192.168.56.38 |     2882 |     22 | PLAN_CACHE_CTX_ID    |    10485760 |       11904 |
|      1001 | 192.168.56.37 |     2882 |      4 | EXECUTE_CTX_ID       |     6291456 |        7936 |
|      1001 | 192.168.56.38 |     2882 |     24 | WORK_AREA            |     6291456 |       27776 |
|      1001 | 192.168.56.38 |     2882 |      4 | EXECUTE_CTX_ID       |     6291456 |        7936 |
+-----------+---------------+----------+--------+----------------------+-------------+-------------+
30 rows in set (0.030 sec)


obclient [oceanbase]> select * from __all_virtual_memory_info  where tenant_id=1001 order by used desc limit 10;
+-----------+---------------+----------+--------+-----------------+--------------------+----------+--------+-----------------+-------+-------------+-------------+-------+-------------+------------+
| tenant_id | svr_ip        | svr_port | ctx_id | label           | ctx_name           | mod_type | mod_id | mod_name        | zone  | hold        | used        | count | alloc_count | free_count |
+-----------+---------------+----------+--------+-----------------+--------------------+----------+--------+-----------------+-------+-------------+-------------+-------+-------------+------------+
|      1001 | 192.168.56.36 |     2882 |      5 | SqlExecutor     | SQL_EXEC_CTX_ID    | user     |      0 | SqlExecutor     | zone1 | 53738147328 | 43948083592 | 11489 |           0 |          0 |
|      1001 | 192.168.56.36 |     2882 |      0 | MysqlRequesReco | DEFAULT_CTX_ID     | user     |      0 | MysqlRequesReco | zone1 |  1444610048 |  1436936320 |   642 |           0 |          0 |
|      1001 | 192.168.56.36 |     2882 |      1 | OB_MEMSTORE     | MEMSTORE_CTX_ID    | user     |      0 | OB_MEMSTORE     | zone1 |  1073479680 |  1073254400 |   512 |           0 |          0 |
|      1001 | 192.168.56.38 |     2882 |      1 | OB_MEMSTORE     | MEMSTORE_CTX_ID    | user     |      0 | OB_MEMSTORE     | zone3 |   643671040 |   643052616 |   303 |           0 |          0 |
|      1001 | 192.168.56.37 |     2882 |      1 | OB_MEMSTORE     | MEMSTORE_CTX_ID    | user     |      0 | OB_MEMSTORE     | zone2 |   597544960 |   596936216 |   281 |           0 |          0 |
|      1001 | 192.168.56.37 |     2882 |      0 | MysqlRequesReco | DEFAULT_CTX_ID     | user     |      0 | MysqlRequesReco | zone2 |   132108288 |   130135040 |    25 |           0 |          0 |
|      1001 | 192.168.56.36 |     2882 |     32 | MemtableCallbac | TX_CALLBACK_CTX_ID | user     |      0 | MemtableCallbac | zone1 |   122287872 |   121339904 | 14812 |           0 |          0 |
|      1001 | 192.168.56.38 |     2882 |      0 | MysqlRequesReco | DEFAULT_CTX_ID     | user     |      0 | MysqlRequesReco | zone3 |   106948608 |   105067520 |    13 |           0 |          0 |
|      1001 | 192.168.56.37 |     2882 |      0 | LogAggreBuffer  | DEFAULT_CTX_ID     | user     |      0 | LogAggreBuffer  | zone2 |    44994560 |    44302336 |   676 |           0 |          0 |
|      1001 | 192.168.56.36 |     2882 |      0 | LogAggreBuffer  | DEFAULT_CTX_ID     | user     |      0 | LogAggreBuffer  | zone1 |    44994560 |    44302336 |   676 |           0 |          0 |
+-----------+---------------+----------+--------+-----------------+--------------------+----------+--------+-----------------+-------+-------------+-------------+-------+-------------+------------+
10 rows in set (0.050 sec)

3、造一行10M的LOB，竟然需要100多G的内存，尝试定位内存泄露，开启 mem_leak check

登录sys租户
上面我们已知知道MOD SqlExecutor点用内存高,下面针对SqlExecutor开启mem leak check,抓取分配内存多的堆栈
obclient [oceanbase]> alter system set leak_mod_to_check='SqlExecutor';
Query OK, 0 rows affected (0.060 sec)

4、执行SQL

obclient [SYS]> DECLARE
    -> c blob;
    -> BEGIN
    -> dbms_lob.createtemporary(lob_loc => c, cache => FALSE, dur => dbms_lob.call);
    ->     FOR i IN 1..10240 loop
    ->     DBMS_LOB.WRITEAPPEND(c,1024,hextoraw(rpad('01',2048,'01')));
    -> END LOOP;
    -> INSERT INTO  tlob VALUES (2,c);
    -> COMMIT;
    -> END;
    -> /

ORA-00600: internal error code, arguments: -4013, No memory or reach tenant memory limit

5、抓取分配内存多的堆栈

obclient [oceanbase]> SELECT * FROM oceanbase.__all_virtual_mem_leak_checker_info ORDER BY alloc_count DESC limit 10;
+---------------+----------+-------------+----------+-------------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| svr_ip        | svr_port | mod_name    | mod_type | alloc_count | alloc_size  | back_trace                                                                                                                                                                                                                                                                                                                                                                                 |
+---------------+----------+-------------+----------+-------------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 192.168.56.36 |     2882 | SqlExecutor | user     |        7109 | 40773641064 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4bd73 0x884f0f9 0x8857e92 0x8859508 0x885fd16 0xf9427a4 0x7fbc82bed031 0x8393031 0x839208d 0x8383e0a 0x83803ae 0x7fc293519839 0x8393079 0x839208d 0x8395290 0xfbe55df 0x5e9f00b 0x5d442ef 0x5ce4b27 0x5cd4291 0x5e8e44b 0x5cc1be2 0x5cbdf7c 0x5cbbf6e 0xcdc0ff1 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff      |
| 192.168.56.36 |     2882 | SqlExecutor | user     |        7109 | 40773356704 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4bd73 0x8857cfe 0x8859508 0x885fd16 0xf9427a4 0x7fbc82bed031 0x8393031 0x839208d 0x8383e0a 0x83803ae 0x7fc293519839 0x8393079 0x839208d 0x8395290 0xfbe55df 0x5e9f00b 0x5d442ef 0x5ce4b27 0x5cd4291 0x5e8e44b 0x5cc1be2 0x5cbdf7c 0x5cbbf6e 0xcdc0ff1 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff                |
| 192.168.56.36 |     2882 | SqlExecutor | user     |        1465 |  3070827520 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4be0c 0x8857cfe 0x8859508 0x885fd16 0xf9427a4 0x7fbc82bed031 0x8393031 0x839208d 0x8383e0a 0x83803ae 0x7fc293519839 0x8393079 0x839208d 0x8395290 0xfbe55df 0x5e9f00b 0x5d442ef 0x5ce4b27 0x5cd4291 0x5e8e44b 0x5cc1be2 0x5cbdf7c 0x5cbbf6e 0xcdc0ff1 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff                |
| 192.168.56.36 |     2882 | SqlExecutor | user     |        1170 |  2452469760 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4be0c 0x884f0f9 0x8857e92 0x8859508 0x885fd16 0xf9427a4 0x7fbc82bed031 0x8393031 0x839208d 0x8383e0a 0x83803ae 0x7fc293519839 0x8393079 0x839208d 0x8395290 0xfbe55df 0x5e9f00b 0x5d442ef 0x5ce4b27 0x5cd4291 0x5e8e44b 0x5cc1be2 0x5cbdf7c 0x5cbbf6e 0xcdc0ff1 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff      |
| 192.168.56.36 |     2882 | SqlExecutor | user     |          24 |    50307072 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4be0c 0x5de10ad 0x885fbdd 0xf9427a4 0x7fbc82bed031 0x8393031 0x839208d 0x8383e0a 0x83803ae 0x7fc293519839 0x8393079 0x839208d 0x8395290 0xfbe55df 0x5e9f00b 0x5d442ef 0x5ce4b27 0x5cd4291 0x5e8e44b 0x5cc1be2 0x5cbdf7c 0x5cbbf6e 0xcdc0ff1 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff                          |
| 192.168.56.36 |     2882 | SqlExecutor | user     |          18 |    37730304 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4be0c 0xdf65c76 0xdf677eb 0xdf6636e 0xdf6dff2 0x5edceb3 0x5edcb4e 0x5edc8ea 0x5edc59e 0xfd2dc25 0xf8f1cd7 0xf8f6e65 0x7fc2935197c6 0x8393079 0x839208d 0x8395290 0xfbe55df 0x5e9f00b 0x5d442ef 0x5ce4b27 0x5cd4291 0x5e8e44b 0x5cc1be2 0x5cbdf7c 0x5cbbf6e 0xcdc0ff1 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff |
| 192.168.56.36 |     2882 | SqlExecutor | user     |          16 |    33538048 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4be0c 0x76c445f 0x76c69da 0xd7c180b 0x5edcecb 0x5edcb4e 0x5edc59e 0xfd2dc25 0xf8f1cd7 0xf8f6e65 0x7fc2935197c6 0x8393079 0x839208d 0x8395290 0xfbe55df 0x5e9f00b 0x5d442ef 0x5ce4b27 0x5cd4291 0x5e8e44b 0x5cc1be2 0x5cbdf7c 0x5cbbf6e 0xcdc0ff1 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff                     |
| 192.168.56.36 |     2882 | SqlExecutor | user     |           2 |     4192256 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4bc8d 0x5d1bc66 0x5cbc61d 0x5cbbe9e 0xcdc0fb7 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff                                                                                                                                                                                                                        |
| 192.168.56.38 |     2882 | SqlExecutor | user     |           1 |     2096128 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4bc8d 0xd0cae01 0x5d3b881 0x5cbc672 0x5cbbe9e 0xcdc0fb7 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff                                                                                                                                                                                                              |
| 192.168.56.37 |     2882 | SqlExecutor | user     |           1 |     2096128 | 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4bc8d 0xd0cae01 0x5d3b881 0x5cbc672 0x5cbbe9e 0xcdc0fb7 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff                                                                                                                                                                                                              |
+---------------+----------+-------------+----------+-------------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
10 rows in set (0.046 sec)

6、将16进制地址转换实际函数名

[root@ob1 ~]# addr2line -pCfe /home/admin/oceanbase/bin/observer 0x1127126a 0x5d930dc 0x5ce1928 0x5d19f5c 0x5f4bd73 0x884f0f9 0x8857e92 0x8859508 0x885fd16 0xf9427a4 0x7fbc82bed031 0x8393031 0x839208d 0x8383e0a 0x83803ae 0x7fc293519839 0x8393079 0x839208d 0x8395290 0xfbe55df 0x5e9f00b 0x5d442ef 0x5ce4b27 0x5cd4291 0x5e8e44b 0x5cc1be2 0x5cbdf7c 0x5cbbf6e 0xcdc0ff1 0x5cbb097 0xcdbe75c 0x5cb6819 0xcdbed07 0x10bf22a3 0x10bf20ff 0x11bae3ff
oceanbase::common::lbt(char*, int) at ./build_rpm/deps/oblib/src/lib/./deps/oblib/src/lib/utility/ob_backtrace.cpp:136
oceanbase::common::ObMemLeakChecker::on_alloc(oceanbase::lib::AObject&) at ./build_rpm/deps/oblib/src/lib/./deps/oblib/src/lib/allocator/ob_mem_leak_checker.h:187
oceanbase::common::ObAllocator::alloc(long, oceanbase::lib::ObMemAttr const&) at ??:?
oceanbase::common::PageArena<char, oceanbase::common::ModulePageAllocator>::alloc_new_page(long) at ./build_rpm/deps/oblib/src/lib/./deps/oblib/src/lib/allocator/page_arena.h:328
oceanbase::common::PageArena<char, oceanbase::common::ModulePageAllocator>::alloc_big(long) at ./build_rpm/deps/oblib/src/lib/./deps/oblib/src/lib/allocator/page_arena.h:418
oceanbase::pl::ObDbmsLobBase::build_lob_locator(oceanbase::common::ObLobLocator*&, oceanbase::common::ObIAllocator&, unsigned long, unsigned long, long, unsigned short, oceanbase::common::ObString const&, oceanbase::common::ObString const&) at ./build_rpm/src/pl/./src/pl/sys_package/ob_dbms_lob.cpp:193
oceanbase::pl::ObDbmsLob::calc_write_result(oceanbase::sql::ObExecContext&, oceanbase::common::Ob2DArray<oceanbase::common::ObObjParam, 2096128, oceanbase::common::ObWrapperAllocator, false, oceanbase::common::ObSEArray<oceanbase::common::ObObjParam*, 1l, oceanbase::common::ObWrapperAllocator, false> >&, oceanbase::common::ObObj&) at ./build_rpm/src/pl/./src/pl/sys_package/ob_dbms_lob.cpp:719
oceanbase::pl::ObDbmsLob::write(oceanbase::sql::ObExecContext&, oceanbase::common::Ob2DArray<oceanbase::common::ObObjParam, 2096128, oceanbase::common::ObWrapperAllocator, false, oceanbase::common::ObSEArray<oceanbase::common::ObObjParam*, 1l, oceanbase::common::ObWrapperAllocator, false> >&, oceanbase::common::ObObj&) at ./build_rpm/src/pl/./src/pl/sys_package/ob_dbms_lob.cpp:783
oceanbase::pl::ObDbmsLob::writeappend(oceanbase::sql::ObExecContext&, oceanbase::common::Ob2DArray<oceanbase::common::ObObjParam, 2096128, oceanbase::common::ObWrapperAllocator, false, oceanbase::common::ObSEArray<oceanbase::common::ObObjParam*, 1l, oceanbase::common::ObWrapperAllocator, false> >&, oceanbase::common::ObObj&) at ./build_rpm/src/pl/./src/pl/sys_package/ob_dbms_lob.cpp:1079
oceanbase::sql::ObSPIService::spi_interface_impl(oceanbase::pl::ObPLExecCtx*, long) at ./build_rpm/src/sql/./src/sql/ob_spi.cpp:5395
?? ??:0
oceanbase::pl::ObPLExecState::execute() at ??:?
oceanbase::pl::ObPL::execute(oceanbase::sql::ObExecContext&, oceanbase::common::ObIAllocator&, oceanbase::pl::ObPLPackageGuard&, oceanbase::pl::ObPLFunction&, oceanbase::common::Ob2DArray<oceanbase::common::ObObjParam, 2096128, oceanbase::common::ObWrapperAllocator, false, oceanbase::common::ObSEArray<oceanbase::common::ObObjParam*, 1l, oceanbase::common::ObWrapperAllocator, false> >*, oceanbase::common::ObIArray<long> const*, oceanbase::common::ObObj*, int*, bool, bool, bool, bool, unsigned long, bool) at ./build_rpm/src/pl/./src/pl/ob_pl.cpp:1321
oceanbase::pl::ObPL::execute(oceanbase::sql::ObExecContext&, oceanbase::common::ObIAllocator&, unsigned long, unsigned long, oceanbase::common::ObIArray<long> const&, oceanbase::common::Ob2DArray<oceanbase::common::ObObjParam, 2096128, oceanbase::common::ObWrapperAllocator, false, oceanbase::common::ObSEArray<oceanbase::common::ObObjParam*, 1l, oceanbase::common::ObWrapperAllocator, false> >&, oceanbase::common::ObIArray<long> const&, oceanbase::common::ObObj&, int*, bool, bool, unsigned long, bool, bool) at ./build_rpm/src/pl/./src/pl/ob_pl.cpp:1607
oceanbase::pl::ObPL::execute_proc(oceanbase::pl::ObPLExecCtx&, unsigned long, unsigned long, long*, long, unsigned long, long, oceanbase::common::ObObjParam**, long*) at ./build_rpm/src/pl/./src/pl/ob_pl.cpp:295
?? ??:0
oceanbase::pl::ObPLExecState::execute() at ??:?
oceanbase::pl::ObPL::execute(oceanbase::sql::ObExecContext&, oceanbase::common::ObIAllocator&, oceanbase::pl::ObPLPackageGuard&, oceanbase::pl::ObPLFunction&, oceanbase::common::Ob2DArray<oceanbase::common::ObObjParam, 2096128, oceanbase::common::ObWrapperAllocator, false, oceanbase::common::ObSEArray<oceanbase::common::ObObjParam*, 1l, oceanbase::common::ObWrapperAllocator, false> >*, oceanbase::common::ObIArray<long> const*, oceanbase::common::ObObj*, int*, bool, bool, bool, bool, unsigned long, bool) at ./build_rpm/src/pl/./src/pl/ob_pl.cpp:1321
oceanbase::pl::ObPL::execute(oceanbase::sql::ObExecContext&, _ParseNode const*) at ./build_rpm/src/pl/./src/pl/ob_pl.cpp:1415
oceanbase::sql::ObAnonymousBlockExecutor::execute(oceanbase::sql::ObExecContext&, oceanbase::sql::ObAnonymousBlockStmt&) at ./build_rpm/src/sql/./src/sql/engine/cmd/ob_routine_executor.cpp:516
oceanbase::sql::ObCmdExecutor::execute(oceanbase::sql::ObExecContext&, oceanbase::sql::ObICmd&) at ??:?
oceanbase::sql::ObResultSet::open_cmd() at ./build_rpm/src/sql/./src/sql/ob_result_set.cpp:94
oceanbase::sql::ObResultSet::execute() at ??:?
oceanbase::sql::ObResultSet::sync_open() at ./build_rpm/src/sql/./src/sql/ob_result_set.cpp:153
oceanbase::observer::ObSyncCmdDriver::response_result(oceanbase::observer::ObMySQLResultSet&) at ./build_rpm/src/observer/./src/observer/mysql/ob_sync_cmd_driver.cpp:107
oceanbase::observer::ObMPQuery::response_result(oceanbase::sql::ObQueryExecCtx&, bool, bool&) at ./build_rpm/src/observer/./src/observer/mysql/obmp_query.cpp:1319
oceanbase::observer::ObMPQuery::process() at ./build_rpm/src/observer/./src/observer/mysql/obmp_query.cpp:315
oceanbase::rpc::frame::ObSqlProcessor::run() at ./build_rpm/deps/oblib/src/rpc/./deps/oblib/src/rpc/frame/ob_sql_processor.cpp:50
oceanbase::omt::ObWorkerProcessor::process_one(oceanbase::rpc::ObRequest&) at ./build_rpm/src/observer/./src/observer/omt/ob_worker_processor.cpp:76
oceanbase::omt::ObWorkerProcessor::process(oceanbase::rpc::ObRequest&) at ./build_rpm/src/observer/./src/observer/omt/ob_worker_processor.cpp:147
oceanbase::omt::ObThWorker::process_request(oceanbase::rpc::ObRequest&) at ./build_rpm/src/observer/./src/observer/omt/ob_th_worker.cpp:311
oceanbase::omt::ObThWorker::worker(long&, long&, int&) at ./build_rpm/src/observer/./src/observer/omt/ob_th_worker.cpp:476
non-virtual thunk to oceanbase::omt::ObThWorker::run(long) at ??:?
operator() at ./build_rpm/deps/oblib/src/lib/./deps/oblib/src/lib/coro/co_user_thread.cpp:234
eeentry(boost::context::detail::transfer_t) at ./build_rpm/deps/oblib/src/lib/./deps/oblib/src/lib/coro/co_user_thread.cpp:44
?? at /home/jenkins/agent/workspace/rpm-oceanbase-3.2.4.5-1.1.18/ob_source_code_dir/deps/oblib/src/lib/coro/context/asm/make_x86_64_sysv_elf_gas.S:75

7、关闭 mem_leak check

登录sys租户
obclient [oceanbase]> alter system set leak_mod_to_check='';
Query OK, 0 rows affected (0.058 sec)
墨力计划oceanbae
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论