为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:Linux
【CPU】:
【问题描述】*:
datasource:
type: com.zaxxer.hikari.HikariDataSource
driver-class-name: dm.jdbc.driver.DmDriver
username: SYSDBA
password: SYSDBA
url: jdbc:dm://XXX:5236?clobAsString=1&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&schema=test
# 连接池
hikari:
minimum-idle: 10
idle-timeout: 180000
maximum-pool-size: 50
auto-commit: true
max-lifetime: 1800000
connection-timeout: 60000
connection-test-query: SELECT 1
连接达梦数据库做了以上配置,可以连接但后台一直有连接超时日志
Exception in thread "HikariPool-1 network timeout executor" java.lang.RuntimeException: Set network timeout error
at dm.jdbc.driver.DBError.throwRuntimeException(DBError.java:626)
at dm.jdbc.c.a.setSoTimeout(DBAccess.java:1077)
at dm.jdbc.driver.DmdbConnection$5.run(DmdbConnection.java:1322)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Socket is closed
at java.net.Socket.setSoTimeout(Socket.java:1137)
at dm.jdbc.c.a.setSoTimeout(DBAccess.java:1072)
这个问题要怎样去解决
可以从几个方面排查一下
1.应用驱动是否和数据库的版本一致
2.网络连接是否正常,是否存在无法连接的问题
3.如果是某些功能报这个错的话看是否是存在慢sql影响