执行储存过程时报错 4013 - No memory or reach tenant memory limit

AntTech_V21M8F · 2025 年6 月 23 日 15:56

【使用环境】测试环境
【 OB or 其他组件】
【使用版本】5.7.25-OceanBase_CE-v4.3.5.1
【问题描述】执行储存过程时报错 4013 - No memory or reach tenant memory limit
，一直报内存问题，我通过百度修改了内存设置SET GLOBAL ob_sql_work_area_percentage = 90; 之后还是不行，问题已经困扰我一周了，希望得到社区的帮助

【附件及日志】
以下是存储过程片段

淇铭 · 2025 年6 月 23 日 16:10

目前按照下面的步骤来抓一下日志信息
alter system set enable_rich_error_msg=true;
obclient [test]> select count(*) from t2;
ERROR 1146 (42S02): Table ‘test.t2’ doesn’t exist
[xx.xx.xx.1:2882] [2024-04-13 20:10:20.292087] [YB420BA1CC68-000615A0A8EA5E38-0-0]
[root@x.x.x.1 ~]$ grep “YB420BA1CC68-000615A0A8EA5E38-0-0” rootservice.log
[root@x.x.x.1 ~]$ grep “YB420BA1CC68-000615A0A8EA5E38-0-0” observer.log
alter system set enable_rich_error_msg=false;

AntTech_V21M8F · 2025 年6 月 23 日 16:20

我在docker 容器中执行，grep “YB42AC110002-00063833334AB638-0-0” rootservice.log

后提示找不到这个文件

来轩 · 2025 年6 月 23 日 16:32

查询一下SQL_AUDIT看下那个SQL执行报4013了，ret_code=’-4013’

AntTech_V21M8F · 2025 年6 月 23 日 16:42

我执行了
SELECT SQL_ID, QUERY_SQL, ELAPSED_TIME, EXECUTE_TIME, EVENT
FROM GV$OB_SQL_AUDIT

ORDER BY ELAPSED_TIME DESC
LIMIT 100;

找到了可能导致出问题的SQL
INSERT INTO qdt_threelevelassessmentindicator_data12345678 (indicators_id, indicators_value, indicators_date, indicators_dept)
SELECT
16,
COUNT(1),
DATE_FORMAT(DischargeDatetime,’%Y%m’),
‘全院’
FROM qdt_adinfomation12345678
WHERE Encounter IN(
SELECT Encounter FROM qdt_procedure12345678 WHERE Encounter IN(
SELECT Encounter FROM qdt_diagnosis12345678 WHERE HospitalICDID IN(
SELECT HospitalICDID FROM qdt_hospitalicd12345678 WHERE HospitalICDCode IN (
SELECT HospitalICDCode FROM qdic_hospitalicd_standard WHERE CHospitalICDCode LIKE ‘O04.5%’ OR CHospitalICDCode LIKE ‘T81.1%’ OR CHospitalICDCode LIKE ‘T81.2%’ OR CHospitalICDCode LIKE ‘T81.3%’ OR CHospitalICDCode LIKE ‘T81.7%’ OR CHospitalICDCode LIKE ‘T81.8%’ OR CHospitalICDCode LIKE ‘I26.9%’ OR CHospitalICDCode LIKE ‘O04.2%’ OR CHospitalICDCode LIKE ‘O07.2%’ OR CHospitalICDCode LIKE ‘O88.2%’ OR CHospitalICDCode LIKE ‘I80.2%’ OR CHospitalICDCode LIKE ‘I82.8%’ OR CHospitalICDCode LIKE ‘O22.3%’ OR CHospitalICDCode LIKE ‘O87.1%’ OR CHospitalICDCode LIKE ‘T81.4%’ OR CHospitalICDCode LIKE ‘O04.1%’ OR CHospitalICDCode LIKE ‘O04.6%’ OR CHospitalICDCode LIKE ‘O04.8%’ OR CHospitalICDCode LIKE ‘O07.1%’ OR CHospitalICDCode LIKE ‘O07.6%’ OR CHospitalICDCode LIKE ‘T81.0%’ OR CHospitalICDCode LIKE ‘T81.3%’ OR CHospitalICDCode LIKE ‘R96.0%’ OR CHospitalICDCode LIKE ‘R96.1%’ OR CHospitalICDCode LIKE ‘J95%’ OR CHospitalICDCode LIKE ‘J96.0%’ OR CHospitalICDCode LIKE ‘J96.9%’ OR CHospitalICDCode LIKE ‘E86.x0%’ OR CHospitalICDCode LIKE ‘E87.0%’ OR CHospitalICDCode LIKE ‘E87.1%’ OR CHospitalICDCode LIKE ‘E87.2%’ OR CHospitalICDCode LIKE ‘E87.3%’ OR CHospitalICDCode LIKE ‘E87.4%’ OR CHospitalICDCode LIKE ‘E87.5%’ OR CHospitalICDCode LIKE ‘E87.6%’ OR CHospitalICDCode LIKE ‘E87.7%’ OR CHospitalICDCode LIKE ‘E87.8%’ OR CHospitalICDCode LIKE ‘E88.8%’ OR CHospitalICDCode LIKE ‘E88.9%’ OR CHospitalICDCode LIKE ‘E89%’ OR CHospitalICDCode LIKE ‘O04.0%’ OR CHospitalICDCode LIKE ‘O07.0%’ OR CHospitalICDCode LIKE ‘T81.4%’ OR CHospitalICDCode LIKE ‘T81.5%’ OR CHospitalICDCode LIKE ‘O70.0%’ OR CHospitalICDCode LIKE ‘O70.1%’ OR CHospitalICDCode LIKE ‘O70.2%’ OR CHospitalICDCode LIKE ‘O70.3%’ OR CHospitalICDCode LIKE ‘O70.9%’ OR CHospitalICDCode LIKE ‘O71%’ OR CHospitalICDCode LIKE ‘O72.0%’ OR CHospitalICDCode LIKE ‘O72.1%’ OR CHospitalICDCode LIKE ‘O72.2%’ OR CHospitalICDCode LIKE ‘O72.3%’ OR CHospitalICDCode LIKE ‘O73.0%’ OR CHospitalICDCode LIKE ‘O73.1%’ OR CHospitalICDCode LIKE ‘O74%’ OR CHospitalICDCode LIKE ‘O75%’ OR CHospitalICDCode LIKE ‘O86.0%’ OR CHospitalICDCode LIKE ‘O90.0%’ OR CHospitalICDCode LIKE ‘O90.1%’ OR CHospitalICDCode LIKE ‘O90.2%’ OR CHospitalICDCode LIKE ‘P11%’ OR CHospitalICDCode LIKE ‘P12%’ OR CHospitalICDCode LIKE ‘P13%’ OR CHospitalICDCode LIKE ‘P14%’ OR CHospitalICDCode LIKE ‘P15%’ OR CHospitalICDCode LIKE ‘T88.2%’ OR CHospitalICDCode LIKE ‘T88.3%’ OR CHospitalICDCode LIKE ‘T88.4%’ OR CHospitalICDCode LIKE ‘T88.5%’ OR CHospitalICDCode LIKE ‘T80%’ OR CHospitalICDCode LIKE ‘L89%’ OR CHospitalICDCode LIKE ‘K91%’ OR CHospitalICDCode LIKE ‘I97%’ OR CHospitalICDCode LIKE ‘G97%’ OR CHospitalICDCode LIKE ‘H59.0%’ OR CHospitalICDCode LIKE ‘H59.8%’ OR CHospitalICDCode LIKE ‘H59.9%’ OR CHospitalICDCode LIKE ‘H95.0%’ OR CHospitalICDCode LIKE ‘H95.1%’ OR CHospitalICDCode LIKE ‘H95.8%’ OR CHospitalICDCode LIKE ‘H95.9%’ OR CHospitalICDCode LIKE ‘M96%’ OR CHospitalICDCode LIKE ‘N99%’ OR CHospitalICDCode LIKE ‘T88.0%’ OR CHospitalICDCode LIKE ‘T88.1%’ OR CHospitalICDCode LIKE ‘T82%’ OR CHospitalICDCode LIKE ‘T83%’ OR CHospitalICDCode LIKE ‘T84%’ OR CHospitalICDCode LIKE ‘T85%’
)
)
)
)
GROUP BY DATE_FORMAT(DischargeDatetime,’%Y%m’)
UNION ALL
SELECT
16,
COUNT(1),
CONCAT(DATE_FORMAT(DischargeDatetime,’%Y’),‘00’),
‘全院’
FROM qdt_adinfomation12345678
WHERE Encounter IN(
SELECT Encounter FROM qdt_procedure12345678 WHERE Encounter IN(
SELECT Encounter FROM qdt_diagnosis12345678 WHERE HospitalICDID IN(
SELECT HospitalICDID FROM qdt_hospitalicd12345678 WHERE HospitalICDCode IN (
SELECT HospitalICDCode FROM qdic_hospitalicd_standard WHERE CHospitalICDCode LIKE ‘O04.5%’ OR CHospitalICDCode LIKE ‘T81.1%’ OR CHospitalICDCode LIKE ‘T81.2%’ OR CHospitalICDCode LIKE ‘T81.3%’ OR CHospitalICDCode LIKE ‘T81.7%’ OR CHospitalICDCode LIKE ‘T81.8%’ OR CHospitalICDCode LIKE ‘I26.9%’ OR CHospitalICDCode LIKE ‘O04.2%’ OR CHospitalICDCode LIKE ‘O07.2%’ OR CHospitalICDCode LIKE ‘O88.2%’ OR CHospitalICDCode LIKE ‘I80.2%’ OR CHospitalICDCode LIKE ‘I82.8%’ OR CHospitalICDCode LIKE ‘O22.3%’ OR CHospitalICDCode LIKE ‘O87.1%’ OR CHospitalICDCode LIKE ‘T81.4%’ OR CHospitalICDCode LIKE ‘O04.1%’ OR CHospitalICDCode LIKE ‘O04.6%’ OR CHospitalICDCode LIKE ‘O04.8%’ OR CHospitalICDCode LIKE ‘O07.1%’ OR CHospitalICDCode LIKE ‘O07.6%’ OR CHospitalICDCode LIKE ‘T81.0%’ OR CHospitalICDCode LIKE ‘T81.3%’ OR CHospitalICDCode LIKE ‘R96.0%’ OR CHospitalICDCode LIKE ‘R96.1%’ OR CHospitalICDCode LIKE ‘J95%’ OR CHospitalICDCode LIKE ‘J96.0%’ OR CHospitalICDCode LIKE ‘J96.9%’ OR CHospitalICDCode LIKE ‘E86.x0%’ OR CHospitalICDCode LIKE ‘E87.0%’ OR CHospitalICDCode LIKE ‘E87.1%’ OR CHospitalICDCode LIKE ‘E87.2%’ OR CHospitalICDCode LIKE ‘E87.3%’ OR CHospitalICDCode LIKE ‘E87.4%’ OR CHospitalICDCode LIKE ‘E87.5%’ OR CHospitalICDCode LIKE ‘E87.6%’ OR CHospitalICDCode LIKE ‘E87.7%’ OR CHospitalICDCode LIKE ‘E87.8%’ OR CHospitalICDCode LIKE ‘E88.8%’ OR CHospitalICDCode LIKE ‘E88.9%’ OR CHospitalICDCode LIKE ‘E89%’ OR CHospitalICDCode LIKE ‘O04.0%’ OR CHospitalICDCode LIKE ‘O07.0%’ OR CHospitalICDCode LIKE ‘T81.4%’ OR CHospitalICDCode LIKE ‘T81.5%’ OR CHospitalICDCode LIKE ‘O70.0%’ OR CHospitalICDCode LIKE ‘O70.1%’ OR CHospitalICDCode LIKE ‘O70.2%’ OR CHospitalICDCode LIKE ‘O70.3%’ OR CHospitalICDCode LIKE ‘O70.9%’ OR CHospitalICDCode LIKE ‘O71%’ OR CHospitalICDCode LIKE ‘O72.0%’ OR CHospitalICDCode LIKE ‘O72.1%’ OR CHospitalICDCode LIKE ‘O72.2%’ OR CHospitalICDCode LIKE ‘O72.3%’ OR CHospitalICDCode LIKE ‘O73.0%’ OR CHospitalICDCode LIKE ‘O73.1%’ OR CHospitalICDCode LIKE ‘O74%’ OR CHospitalICDCode LIKE ‘O75%’ OR CHospitalICDCode LIKE ‘O86.0%’ OR CHospitalICDCode LIKE ‘O90.0%’ OR CHospitalICDCode LIKE ‘O90.1%’ OR CHospitalICDCode LIKE ‘O90.2%’ OR CHospitalICDCode LIKE ‘P11%’ OR CHospitalICDCode LIKE ‘P12%’ OR CHospitalICDCode LIKE ‘P13%’ OR CHospitalICDCode LIKE ‘P14%’ OR CHospitalICDCode LIKE ‘P15%’ OR CHospitalICDCode LIKE ‘T88.2%’ OR CHospitalICDCode LIKE ‘T88.3%’ OR CHospitalICDCode LIKE ‘T88.4%’ OR CHospitalICDCode LIKE ‘T88.5%’ OR CHospitalICDCode LIKE ‘T80%’ OR CHospitalICDCode LIKE ‘L89%’ OR CHospitalICDCode LIKE ‘K91%’ OR CHospitalICDCode LIKE ‘I97%’ OR CHospitalICDCode LIKE ‘G97%’ OR CHospitalICDCode LIKE ‘H59.0%’ OR CHospitalICDCode LIKE ‘H59.8%’ OR CHospitalICDCode LIKE ‘H59.9%’ OR CHospitalICDCode LIKE ‘H95.0%’ OR CHospitalICDCode LIKE ‘H95.1%’ OR CHospitalICDCode LIKE ‘H95.8%’ OR CHospitalICDCode LIKE ‘H95.9%’ OR CHospitalICDCode LIKE ‘M96%’ OR CHospitalICDCode LIKE ‘N99%’ OR CHospitalICDCode LIKE ‘T88.0%’ OR CHospitalICDCode LIKE ‘T88.1%’ OR CHospitalICDCode LIKE ‘T82%’ OR CHospitalICDCode LIKE ‘T83%’ OR CHospitalICDCode LIKE ‘T84%’ OR CHospitalICDCode LIKE ‘T85%’
)
)
)
)
GROUP BY DATE_FORMAT(DischargeDatetime,’%Y’)

AntTech_V21M8F · 2025 年6 月 23 日 16:44

我司目前正在做mysql->oceanbase 的国产化替代迁移，原大多数业务都是通过存储过程计算的，希望在不修改存储过程的情况下解决内存不足问题，不然更改的东西太多了

AntTech_V21M8F · 2025 年6 月 23 日 16:45

这是SQL_AUDIT

AntTech_V21M8F · 2025 年6 月 23 日 16:46

其中可能报错的SQL
为
INSERT INTO qdt_threelevelassessmentindicator_data12345678 (indicators_id, indicators_value, indicators_date, indicators_dept)
SELECT
16,
COUNT(1),
DATE_FORMAT(DischargeDatetime,’%Y%m’),
‘全院’
FROM qdt_adinfomation12345678
WHERE Encounter IN(
SELECT Encounter FROM qdt_procedure12345678 WHERE Encounter IN(
SELECT Encounter FROM qdt_diagnosis12345678 WHERE HospitalICDID IN(
SELECT HospitalICDID FROM qdt_hospitalicd12345678 WHERE HospitalICDCode IN (
SELECT HospitalICDCode FROM qdic_hospitalicd_standard WHERE CHospitalICDCode LIKE ‘O04.5%’ OR CHospitalICDCode LIKE ‘T81.1%’ OR CHospitalICDCode LIKE ‘T81.2%’ OR CHospitalICDCode LIKE ‘T81.3%’ OR CHospitalICDCode LIKE ‘T81.7%’ OR CHospitalICDCode LIKE ‘T81.8%’ OR CHospitalICDCode LIKE ‘I26.9%’ OR CHospitalICDCode LIKE ‘O04.2%’ OR CHospitalICDCode LIKE ‘O07.2%’ OR CHospitalICDCode LIKE ‘O88.2%’ OR CHospitalICDCode LIKE ‘I80.2%’ OR CHospitalICDCode LIKE ‘I82.8%’ OR CHospitalICDCode LIKE ‘O22.3%’ OR CHospitalICDCode LIKE ‘O87.1%’ OR CHospitalICDCode LIKE ‘T81.4%’ OR CHospitalICDCode LIKE ‘O04.1%’ OR CHospitalICDCode LIKE ‘O04.6%’ OR CHospitalICDCode LIKE ‘O04.8%’ OR CHospitalICDCode LIKE ‘O07.1%’ OR CHospitalICDCode LIKE ‘O07.6%’ OR CHospitalICDCode LIKE ‘T81.0%’ OR CHospitalICDCode LIKE ‘T81.3%’ OR CHospitalICDCode LIKE ‘R96.0%’ OR CHospitalICDCode LIKE ‘R96.1%’ OR CHospitalICDCode LIKE ‘J95%’ OR CHospitalICDCode LIKE ‘J96.0%’ OR CHospitalICDCode LIKE ‘J96.9%’ OR CHospitalICDCode LIKE ‘E86.x0%’ OR CHospitalICDCode LIKE ‘E87.0%’ OR CHospitalICDCode LIKE ‘E87.1%’ OR CHospitalICDCode LIKE ‘E87.2%’ OR CHospitalICDCode LIKE ‘E87.3%’ OR CHospitalICDCode LIKE ‘E87.4%’ OR CHospitalICDCode LIKE ‘E87.5%’ OR CHospitalICDCode LIKE ‘E87.6%’ OR CHospitalICDCode LIKE ‘E87.7%’ OR CHospitalICDCode LIKE ‘E87.8%’ OR CHospitalICDCode LIKE ‘E88.8%’ OR CHospitalICDCode LIKE ‘E88.9%’ OR CHospitalICDCode LIKE ‘E89%’ OR CHospitalICDCode LIKE ‘O04.0%’ OR CHospitalICDCode LIKE ‘O07.0%’ OR CHospitalICDCode LIKE ‘T81.4%’ OR CHospitalICDCode LIKE ‘T81.5%’ OR CHospitalICDCode LIKE ‘O70.0%’ OR CHospitalICDCode LIKE ‘O70.1%’ OR CHospitalICDCode LIKE ‘O70.2%’ OR CHospitalICDCode LIKE ‘O70.3%’ OR CHospitalICDCode LIKE ‘O70.9%’ OR CHospitalICDCode LIKE ‘O71%’ OR CHospitalICDCode LIKE ‘O72.0%’ OR CHospitalICDCode LIKE ‘O72.1%’ OR CHospitalICDCode LIKE ‘O72.2%’ OR CHospitalICDCode LIKE ‘O72.3%’ OR CHospitalICDCode LIKE ‘O73.0%’ OR CHospitalICDCode LIKE ‘O73.1%’ OR CHospitalICDCode LIKE ‘O74%’ OR CHospitalICDCode LIKE ‘O75%’ OR CHospitalICDCode LIKE ‘O86.0%’ OR CHospitalICDCode LIKE ‘O90.0%’ OR CHospitalICDCode LIKE ‘O90.1%’ OR CHospitalICDCode LIKE ‘O90.2%’ OR CHospitalICDCode LIKE ‘P11%’ OR CHospitalICDCode LIKE ‘P12%’ OR CHospitalICDCode LIKE ‘P13%’ OR CHospitalICDCode LIKE ‘P14%’ OR CHospitalICDCode LIKE ‘P15%’ OR CHospitalICDCode LIKE ‘T88.2%’ OR CHospitalICDCode LIKE ‘T88.3%’ OR CHospitalICDCode LIKE ‘T88.4%’ OR CHospitalICDCode LIKE ‘T88.5%’ OR CHospitalICDCode LIKE ‘T80%’ OR CHospitalICDCode LIKE ‘L89%’ OR CHospitalICDCode LIKE ‘K91%’ OR CHospitalICDCode LIKE ‘I97%’ OR CHospitalICDCode LIKE ‘G97%’ OR CHospitalICDCode LIKE ‘H59.0%’ OR CHospitalICDCode LIKE ‘H59.8%’ OR CHospitalICDCode LIKE ‘H59.9%’ OR CHospitalICDCode LIKE ‘H95.0%’ OR CHospitalICDCode LIKE ‘H95.1%’ OR CHospitalICDCode LIKE ‘H95.8%’ OR CHospitalICDCode LIKE ‘H95.9%’ OR CHospitalICDCode LIKE ‘M96%’ OR CHospitalICDCode LIKE ‘N99%’ OR CHospitalICDCode LIKE ‘T88.0%’ OR CHospitalICDCode LIKE ‘T88.1%’ OR CHospitalICDCode LIKE ‘T82%’ OR CHospitalICDCode LIKE ‘T83%’ OR CHospitalICDCode LIKE ‘T84%’ OR CHospitalICDCode LIKE ‘T85%’
)
)
)
)
GROUP BY DATE_FORMAT(DischargeDatetime,’%Y%m’)
UNION ALL
SELECT
16,
COUNT(1),
CONCAT(DATE_FORMAT(DischargeDatetime,’%Y’),‘00’),
‘全院’
FROM qdt_adinfomation12345678
WHERE Encounter IN(
SELECT Encounter FROM qdt_procedure12345678 WHERE Encounter IN(
SELECT Encounter FROM qdt_diagnosis12345678 WHERE HospitalICDID IN(
SELECT HospitalICDID FROM qdt_hospitalicd12345678 WHERE HospitalICDCode IN (
SELECT HospitalICDCode FROM qdic_hospitalicd_standard WHERE CHospitalICDCode LIKE ‘O04.5%’ OR CHospitalICDCode LIKE ‘T81.1%’ OR CHospitalICDCode LIKE ‘T81.2%’ OR CHospitalICDCode LIKE ‘T81.3%’ OR CHospitalICDCode LIKE ‘T81.7%’ OR CHospitalICDCode LIKE ‘T81.8%’ OR CHospitalICDCode LIKE ‘I26.9%’ OR CHospitalICDCode LIKE ‘O04.2%’ OR CHospitalICDCode LIKE ‘O07.2%’ OR CHospitalICDCode LIKE ‘O88.2%’ OR CHospitalICDCode LIKE ‘I80.2%’ OR CHospitalICDCode LIKE ‘I82.8%’ OR CHospitalICDCode LIKE ‘O22.3%’ OR CHospitalICDCode LIKE ‘O87.1%’ OR CHospitalICDCode LIKE ‘T81.4%’ OR CHospitalICDCode LIKE ‘O04.1%’ OR CHospitalICDCode LIKE ‘O04.6%’ OR CHospitalICDCode LIKE ‘O04.8%’ OR CHospitalICDCode LIKE ‘O07.1%’ OR CHospitalICDCode LIKE ‘O07.6%’ OR CHospitalICDCode LIKE ‘T81.0%’ OR CHospitalICDCode LIKE ‘T81.3%’ OR CHospitalICDCode LIKE ‘R96.0%’ OR CHospitalICDCode LIKE ‘R96.1%’ OR CHospitalICDCode LIKE ‘J95%’ OR CHospitalICDCode LIKE ‘J96.0%’ OR CHospitalICDCode LIKE ‘J96.9%’ OR CHospitalICDCode LIKE ‘E86.x0%’ OR CHospitalICDCode LIKE ‘E87.0%’ OR CHospitalICDCode LIKE ‘E87.1%’ OR CHospitalICDCode LIKE ‘E87.2%’ OR CHospitalICDCode LIKE ‘E87.3%’ OR CHospitalICDCode LIKE ‘E87.4%’ OR CHospitalICDCode LIKE ‘E87.5%’ OR CHospitalICDCode LIKE ‘E87.6%’ OR CHospitalICDCode LIKE ‘E87.7%’ OR CHospitalICDCode LIKE ‘E87.8%’ OR CHospitalICDCode LIKE ‘E88.8%’ OR CHospitalICDCode LIKE ‘E88.9%’ OR CHospitalICDCode LIKE ‘E89%’ OR CHospitalICDCode LIKE ‘O04.0%’ OR CHospitalICDCode LIKE ‘O07.0%’ OR CHospitalICDCode LIKE ‘T81.4%’ OR CHospitalICDCode LIKE ‘T81.5%’ OR CHospitalICDCode LIKE ‘O70.0%’ OR CHospitalICDCode LIKE ‘O70.1%’ OR CHospitalICDCode LIKE ‘O70.2%’ OR CHospitalICDCode LIKE ‘O70.3%’ OR CHospitalICDCode LIKE ‘O70.9%’ OR CHospitalICDCode LIKE ‘O71%’ OR CHospitalICDCode LIKE ‘O72.0%’ OR CHospitalICDCode LIKE ‘O72.1%’ OR CHospitalICDCode LIKE ‘O72.2%’ OR CHospitalICDCode LIKE ‘O72.3%’ OR CHospitalICDCode LIKE ‘O73.0%’ OR CHospitalICDCode LIKE ‘O73.1%’ OR CHospitalICDCode LIKE ‘O74%’ OR CHospitalICDCode LIKE ‘O75%’ OR CHospitalICDCode LIKE ‘O86.0%’ OR CHospitalICDCode LIKE ‘O90.0%’ OR CHospitalICDCode LIKE ‘O90.1%’ OR CHospitalICDCode LIKE ‘O90.2%’ OR CHospitalICDCode LIKE ‘P11%’ OR CHospitalICDCode LIKE ‘P12%’ OR CHospitalICDCode LIKE ‘P13%’ OR CHospitalICDCode LIKE ‘P14%’ OR CHospitalICDCode LIKE ‘P15%’ OR CHospitalICDCode LIKE ‘T88.2%’ OR CHospitalICDCode LIKE ‘T88.3%’ OR CHospitalICDCode LIKE ‘T88.4%’ OR CHospitalICDCode LIKE ‘T88.5%’ OR CHospitalICDCode LIKE ‘T80%’ OR CHospitalICDCode LIKE ‘L89%’ OR CHospitalICDCode LIKE ‘K91%’ OR CHospitalICDCode LIKE ‘I97%’ OR CHospitalICDCode LIKE ‘G97%’ OR CHospitalICDCode LIKE ‘H59.0%’ OR CHospitalICDCode LIKE ‘H59.8%’ OR CHospitalICDCode LIKE ‘H59.9%’ OR CHospitalICDCode LIKE ‘H95.0%’ OR CHospitalICDCode LIKE ‘H95.1%’ OR CHospitalICDCode LIKE ‘H95.8%’ OR CHospitalICDCode LIKE ‘H95.9%’ OR CHospitalICDCode LIKE ‘M96%’ OR CHospitalICDCode LIKE ‘N99%’ OR CHospitalICDCode LIKE ‘T88.0%’ OR CHospitalICDCode LIKE ‘T88.1%’ OR CHospitalICDCode LIKE ‘T82%’ OR CHospitalICDCode LIKE ‘T83%’ OR CHospitalICDCode LIKE ‘T84%’ OR CHospitalICDCode LIKE ‘T85%’
)
)
)
)
GROUP BY DATE_FORMAT(DischargeDatetime,’%Y’)

来轩 · 2025 年6 月 23 日 18:33

查下SQL_AUDIT吧，不要猜那个SQL执行报错了

淇铭 · 2025 年6 月 23 日 19:02

看着楼上发的查一下sql_audit 可以看看具体报错的sql

shigp · 2025 年6 月 24 日 08:48

查下GV$OB_SQL_AUDIT了

Giant · 2025 年6 月 24 日 09:17

您把您的租户配置也发下吧。租户的创建信息和unit的信息。 leader的分布信息

AntTech_V21M8F · 2025 年6 月 24 日 09:22

就是那条sql，是我执行的存储过程里面的

AntTech_V21M8F · 2025 年6 月 24 日 09:24

通过docker创建的oceanbase测试服务

AntTech_IAIIBI · 2025 年6 月 24 日 09:25

报内存问题，有点难定位问题，解决了吗？

Giant · 2025 年6 月 24 日 09:27

您分析过涉及到的表的数据量不？？多少行呢，每个表？？
qdic_hospitalicd_standard
qdt_hospitalicd12345678
qdt_diagnosis12345678
qdt_procedure12345678
qdt_adinfomation12345678

来轩 · 2025 年6 月 24 日 09:27

根据那个SQL的trace_id,取下observer的日志，看下内存为什么爆了

AntTech_V21M8F · 2025 年6 月 24 日 09:27

没解决呢，这问题一周了，再解决不了我也要切换到其他国产数据库了。从mysql5.7 导过来的。以为兼容性好，结果还是一样，哎

AntTech_V21M8F · 2025 年6 月 24 日 09:29

我从mysql 5.7导过来的，没有做改动，这数据量也是生产环境的十分之一…

AntTech_V21M8F · 2025 年6 月 24 日 09:30

我想通过扩大内存实现兼容，不然改的东西太多了