返回首页

MySQL报错: Got error 28 from storage engine

MySQL 05/06 阅读 27 views次 人气 0
摘要:

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

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.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)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at com.what21.core.authority.QAAuthorityFilter.doFilter(QAAuthorityFilter.java:31)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at com.what21.web.filter.AppAuthorityFilter.doFilter(AppAuthorityFilter.java:104)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at com.what21.samc.component.qaacl.QAAclFilter.doFilter(QAAclFilter.java:29)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at com.what21.web.filter.EncodingFilter.doFilter(EncodingFilter.java:46)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)


从存储引擎获取错误28——硬盘数据满了


show global variables like "%datadir%";

show global variables like "%tmpdir%";

查看后发现存储不满,临时存储空间不够了,调整好,恢复正常。


调整后的硬盘空间:

centos.mysql.png


评论

分享到:

返回首页