什么是 SQL 错误：5、SQLState: HY000？什么可能导致此错误？

发布于 2024-12-05 03:20:41 字数 553 浏览 1 评论 0原文

我正在调试的应用程序在其日志中随机/偶尔写入此异常。

org.hibernate.util.JDBCExceptionReporter - SQL Error: 5, SQLState: HY000

以及与此相关的 SQL 内存不足错误。

虽然我在 mysql 文档中找到了 SQLState: HY000 是什么，但我在任何地方都找不到与此状态相关的 SQL Error 5 是什么。目前我只知道数据库连接由于内存不足错误而关闭，并且情况不遵循任何模式。

由于程序的性质，添加额外的日志消息不是一种选择。（我不能这样做，因为应用程序很大，而且从我所看到的情况来看，它是随机发生的 - 执行查询（在消息中）所需的不同内存大小从 3 MB 到 6 MB 不等）。

任何有关此异常的帮助/信息都值得赞赏。

附加信息：内存不足消息似乎以 6-50 多个请求的块形式出现，间隔为 100-150 毫秒。从大约 20-30 条错误消息的列表中，只有 3 条也出现在 mysql 日志中，其余仅出现在 tomcat 日志中（打印堆栈跟踪）。

谢谢

原文

The application I'm debugging writes randomly/occasionally this exception in its logs.

org.hibernate.util.JDBCExceptionReporter - SQL Error: 5, SQLState: HY000

and an SQL out of memory error associated to this.

While I found in mysql documentation what SQLState: HY000 is, I can't find anywhere what SQL Error 5 is, related to this state.
Currently I know only that the db connection closes due to this out of memory error, and that the situation doesn't follow any pattern.

Due to the nature of the program adding additional logging messages is not an option. (I can't do that as the application is huge and from what I've seen it happens randomly - different memory size needed for the queries to execute (in the messages) varying from 3 MB to 6 MB).

Any help/information about this exception is appreciated.

Additional information:
It seems that the out of memory messages come in blocks of 6-50+ requests in an interval of 100-150 milliseconds.
From a list of about 20-30 error messages, only 3 also appeared in mysql logs, the rest only in tomcat logs (printed the stacktrace).

Thanks

分享到QQ

分享到微博