欢迎来到尧图网

客户服务 关于我们

您的位置:首页 > 健康 > 养生 > YashanDB JDBC查询时抛出YAS-02094 current session has been killed or canceled异常

YashanDB JDBC查询时抛出YAS-02094 current session has been killed or canceled异常

2025/6/14 7:40:55 来源:https://blog.csdn.net/cod0410/article/details/144991148  浏览:    关键词:YashanDB JDBC查询时抛出YAS-02094 current session has been killed or canceled异常

本文内容来自YashanDB官网,原文内容请见:https://yashandb.com/newsinfo/7849025.html?templateId=1718516
业务在执行SQL语句时抛出了YAS-02094 current session has been killed or canceled异常,堆栈如下:
Caused by: java.sql.SQLTimeoutException: [line: 0 column: 0] YAS-02094 current session has been killed or canceled
at com.yashandb.jdbc.exception.SQLExceptionType$9.a(Unknown Source)
at com.yashandb.jdbc.exception.SQLExceptionType.newSQLException(Unknown Source)
at com.yashandb.jdbc.exception.SQLError.createSQLException(Unknown Source)
at com.yashandb.jdbc.exception.SQLError.createSQLException(Unknown Source)
at com.yashandb.protocol.NativeProtocol.checkServerError(Unknown Source)
at com.yashandb.protocol.NativeProtocol.receivePacket(Unknown Source)
at com.yashandb.protocol.NativeProtocol.sendCommand(Unknown Source)
at com.yashandb.SessionImpl.a(Unknown Source)
at com.yashandb.SessionImpl.a(Unknown Source)
at com.yashandb.SessionImpl.a(Unknown Source)
at com.yashandb.SessionImpl.b(Unknown Source)
at com.yashandb.SessionImpl.a(Unknown Source)
at com.yashandb.SessionImpl.a(Unknown Source)
at com.yashandb.SessionImpl.execute(Unknown Source)
at com.yashandb.jdbc.PreparedStatementImpl.b(Unknown Source)
at com.yashandb.jdbc.PreparedStatementImpl.executeQuery(Unknown Source)

问题原因:SQL语句的执行时间超过了PreparedStatement对象setQueryTimeout指定的时间(单位:秒),或者中间件类似参数(例如druid的query-timeout,单位:秒)指定的时间
解决办法:优化SQL语句减少执行时间或者调大对应的参数设置

版权声明:

本网仅为发布的内容提供存储空间,不对发表、转载的内容提供任何形式的保证。凡本网注明“来源:XXX网络”的作品,均转载自其它媒体,著作权归作者所有,商业转载请联系作者获得授权,非商业转载请注明出处。

我们尊重并感谢每一位作者,均已注明文章来源和作者。如因作品内容、版权或其它问题,请及时与我们联系,联系邮箱:809451989@qq.com,投稿邮箱:809451989@qq.com

热搜词