为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:1-2-38-21.07.09-143359-10018-ENT Pack1
【操作系统】:Linux c-ce-hgsczx-dm04 3.10.0-1127.el7.x86_64 #1 SMP Tue Mar 31 23:36:51 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
【CPU】:Intel® Xeon® Gold 6130 CPU @ 2.10GHz
【问题描述】*:
DEM日志报错提示数据溢出,这种是什么情况下,会导致这个错误,如何处理
[ERROR - 2023-03-06 00:02:46] DatabaseRlogGather(192.168.xxx.xxx:xxxx) error!
dm.jdbc.driver.DMException: 数据溢出
at dm.jdbc.driver.DBError.throwException(DBError.java:703) ~[DmJdbcDriver.jar:- 8.1.2.162 - Production]
at dm.jdbc.b.b.o.G(MSG.java:591) ~[DmJdbcDriver.jar:- 8.1.2.162 - Production]
at dm.jdbc.b.b.o.L(MSG.java:526) ~[DmJdbcDriver.jar:- 8.1.2.162 - Production]
at dm.jdbc.b.b.o.K(MSG.java:507) ~[DmJdbcDriver.jar:- 8.1.2.162 - Production]
at dm.jdbc.b.a.a(DBAccess.java:243) ~[DmJdbcDriver.jar:- 8.1.2.162 - Production]
at dm.jdbc.b.a.a(DBAccess.java:726) ~[DmJdbcDriver.jar:- 8.1.2.162 - Production]
at dm.jdbc.driver.DmdbStatement.executeInner(DmdbStatement.java:715) ~[DmJdbcDriver.jar:- 8.1.2.162 - Production]
at dm.jdbc.driver.DmdbStatement.do_executeQuery(DmdbStatement.java:219) ~[DmJdbcDriver.jar:- 8.1.2.162 - Production]
at dm.jdbc.driver.DmdbStatement.executeQuery(DmdbStatement.java:1063) ~[DmJdbcDriver.jar:- 8.1.2.162 - Production]
at com.dameng.agent.plugin.gather.DatabaseRlogGather.getDatabaseRlogStat(DatabaseRlogGather.java:100) ~[agent-6.5.4.jar:?]
at com.dameng.agent.plugin.gather.DatabaseRlogGather.doGatherData(DatabaseRlogGather.java:63) ~[agent-6.5.4.jar:?]
at com.dameng.agent.plugin.gather.DatabaseRlogGather.doGatherData(DatabaseRlogGather.java:1) ~[agent-6.5.4.jar:?]
at com.dameng.agent.plugin.gather.AbstractGather.gatherData(AbstractGather.java:185) ~[agent-6.5.4.jar:?]
at com.dameng.agent.plugin.gather.AbstractGather.doRun(AbstractGather.java:139) ~[agent-6.5.4.jar:?]
at com.dameng.agent.plugin.gather.AbstractGather.run(AbstractGather.java:112) ~[agent-6.5.4.jar:?]
可以参考如下方式进行定位排查:
1.开启dem后台库的sql记录功能,参数为SVR_LOG
sp_set_para_value(1,'SVR_LOG',1);
具体可参考如下方式进行配置:
https://blog.csdn.net/qq_35273918/article/details/123602503
2.数据溢出一般为number类型精度问题,根据步骤1中sql日志定位具体的SQL,根据SQL定位到底是哪个字段精度的问题
使用的是 1-2-38-21.07.09-143359-10018-ENT Pack1 里面的dem包部署的吗