What is SQL Error: 5, SQLState: HY000? and what can cause this error?
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 situa开发者_如何学JAVAtion 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
HY000 means general error.
SQL Error 5 is Out of memory
.
Review your query, increase buffers in my.ini. Also make sure to repair all your tables and re-index them.
See: http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html
精彩评论