解决MySQL数据库SQL Error:1030, SQLState: HY000,Got error 28 from storage engine
MySQL数据库报以下错误:
ERROR 22-05 08:51:31,142 - Got error 28 from storage engine
ERROR 22-05 08:51:31,142 - org.hibernate.exception.GenericJDBCException: Got error 28 from storage engine
org.hibernate.exception.GenericJDBCException: Got error 28 from storage engine
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at $Proxy152.executeQuery(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
问题原因:MySQL数据库的存储数据文件的磁盘空间不够,或者MySQL使用的临时目录文件的磁盘空间不够。
问题解决办法:在windows下,MySQL存储临时文件是查找 TMPDIR, TEMP, and TMP这三个环境变量的。增加临时文件的磁盘空间大小。
MySQL存储临时文件官方说明文档:这里