【 使用环境 】测试环境
【 OB or 其他组件 】OMS
【 使用版本 】4.2.6
【问题描述】
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：
无法进入oms控制台了，检查服务状态是正常运行的，在cm-web.log发现有错误==》
2024-11-05 08:33:28 INFO com.alibaba.drc.api.service.DrcAPIServiceImpl.supervisorHostStatusReport(DrcAPIServiceImpl.java:594) - [c995d4df-7cfd-495d-88fb-6bed3fde6267] HostStatusUsageInfo, ip 192.168.1.209, hostStatusStr {“containerStatus”:{“containerCpuCount”:8,“containerCpuUsedPercent”:0.0020391832,“containerDataDiskSizeInGB”:0,“containerDataDiskUsedPercent”:0.0,“containerDiskSizeInGB”:10238.008,“containerDiskUsedPercent”:0.002078747,“containerMemSizeInGB”:31.26136,“containerMemUsedPercent”:0.15878627,“containerNetworkRXInKB”:4.819694E7,“containerNetworkWXInKB”:434482.6,“containerSysDiskSizeInGB”:0,“containerSysDiskUsedPercent”:0.0},“cpuCount”:8,“cpuUsedPercent”:0.0020391832,“diskSizeInGB”:10238.008,“diskUsedPercent”:0.002078747,“imageVersion”:"",“load1”:0.04,“load5”:0.26,“memSizeInGB”:31.26136,“memUsedPercent”:0.15878627,“moduleVersionMap”:{“full_trans”:“oboms-connector-v2-ce-3.0.29-20241008164738.noarch”,“store”:“oboms-xlog-store-ce-5.7.10-20241009154317.alios7.x86_64”,“checker”:“oboms-verifier-ce-2.0.13-20240828172210.noarch”,“incr_trans”:“oboms-connector-v2-ce-3.0.29-20241008164738.noarch”},“supervisorVersion”:“oboms-supervisor-ce-2.1.10-20240814112239.noarch”}
2024-11-05 08:33:31 WARN com.alibaba.drc.interceptor.DataAccessInterceptor.invoke(DataAccessInterceptor.java:44) - [48546258-1caa-4519-9cad-6a135992516b] data access CrawlerDao.updateSuperviorCrawler exception
Error updating database. Cause: java.sql.SQLException: Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement
The error may exist in file [/u01/ds/cm/package/deployapp/work/jetty-0.0.0.0-8088-cm.war-_-any-/webapp/WEB-INF/classes/mapping/crawlerMapper.xml]
The error may involve com.alibaba.drc.dao.CrawlerDao.updateSuperviorCrawler-Inline
The error occurred while setting parameters
SQL: update crawler SET err_msg = ?, gmt_modified = ?, name = ?, gmt_modified=now() where name = ?
Cause: java.sql.SQLException: Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement
; uncategorized SQLException for SQL []; SQL state [25000]; error code [4012]; Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement; nested exception is java.sql.SQLException: Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement
2024-11-05 08:33:31 ERROR com.alibaba.drc.api.action.DrcAPIAction.apiEntry(DrcAPIAction.java:117) - [48546258-1caa-4519-9cad-6a135992516b] drc api action error–>supervisorHeartbeatReport
java.lang.reflect.InvocationTargetException: null
at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_262]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_262]
at com.alibaba.drc.api.action.DrcAPIAction.invokeMethod(DrcAPIAction.java:169) ~[classes/:?]
at com.alibaba.drc.api.action.DrcAPIAction.apiEntry(DrcAPIAction.java:110) [classes/:?]
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_262]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_262]
cm-web.log