mysql get 28_MySQL报错： Got error 28 from storage engine

最新推荐文章于 2023-02-06 18:26:23 发布

weixin_39735288

最新推荐文章于 2023-02-06 18:26:23 发布

阅读量437

点赞数

文章标签： mysql get 28

本文链接：https://blog.csdn.net/weixin_39735288/article/details/113141625

版权

uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030];

Error: 1030 SQLSTATE: HY000 (ER_GET_ERRNO)

Message: Got error %d from storage engine

程序报错：org.springframework.jdbc.UncategorizedSQLException:

### Error querying database. Cause: java.sql.SQLException: Got error 28 from storage engine

### The error may exist in com/what21/uums/dao/mapper/operauthor-mapper.xml

### The error may involve com.what21.uums.service.author.model.OperAuthor.findAuthorResource-Inline

### The error occurred while setting parameters

### SQL: select distinct t.* from ( ( select r.* from uums_res_group rg inner join ref_res_group frg on rg.uuid=frg.guuid inner join uums_resource r on r.uuid=frg.ruuid inner join uums_oper_author oa on oa.authorUuid=rg.uuid where oa.type = '1' and oa.operUuid=? and r.uuid = ? ) union ( select r.* from uums_resource r inner join uums_oper_author oa on r.uuid = oa.authorUuid where oa.type = '2' and oa.operUuid=? and oa.authorUuid = ? ) union ( select r.* from uums_user u inner join ref_user_group rug on u.uuid=rug.uuuid join uums_user_group ug on ug.uuid=rug.guuid inner join uums_oper_author oa on oa.operUuid = ug.uuid inner join uums_resource r on r.uuid=oa.authorUuid where oa.type = '3' and ug.type='2' and u.uuid=? and oa.authorUuid = ? ) ) t

### Cause: java.sql.SQLException: Got error 28 from storage engine

; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error 28 from storage engine; nested exception is java.sql.SQLException: Got error 28 from storage engine

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)

at com.sun.proxy.$Proxy14.selectOne(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)

at com.what21.uums.dao.base.DaoSupport.queryOne(DaoSupport.java:87)

at com.what21.uums.service.author.impl.OperAuthorServiceImpl.findAuthorResource(OperAuthorServiceImpl.java:391)

at com.what21.uums.service.sso.controller.AuthorHelper.loadOperAuthor(AuthorHelper.java:74)

at com.what21.uums.service.sso.controller.AuthorHelper.getOperAuthor(AuthorHelper.java:125)

at com.what21.uums.service.sso.ldp.AuthServiceImpl.authority(AuthServiceImpl.java:470)

at com.what21.uums.service.sso.ldp.AuthServiceImpl.validator(AuthServiceImpl.java:435)

at com.what21.uums.service.sso.ldp.AuthServiceImpl.auth(AuthServiceImpl.java:70)

at com.what21.sso.service.auth.IDPServiceImpl.login(IDPServiceImpl.java:85)

at com.what21.uums.service.sso.inner.Sso2ServiceImpl.auth(Sso2ServiceImpl.java:35)

at com.what21.uums.action.ssoi.LoginAction.login(LoginAction.java:258)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.what21.web.servlet.ActionServlet.invoke(ActionServlet.java:113)

at com.what21.web.servlet.ActionServlet.service(ActionServlet.java:93)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)