java.sql.SQLException: Can't reopen table: 't'

  1. 0

    dbname in the jdbc url not reconginized

    GitHub | 2 years ago | hepin1989
    java.sql.SQLException: No database selected
  2. 0

    Operations timeout in Hibernate

    Stack Overflow | 2 years ago | NoobEditor
    org.hibernate.exception.LockTimeoutException: could not execute statement
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    What is wrong with these Tomcat database connection pooling configuration

    Stack Overflow | 2 years ago | Abhi
    java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  5. 0

    GitHub comment 25#139480199

    GitHub | 1 year ago | Nabellaleen
    net.appjet.bodylock.JSRuntimeException: Error while executing: Incorrect key file for table 'pro_accounts_auto_signin'; try to repair it
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Can't reopen table: 't'

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
    7. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
    8. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
    9. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077)
    10. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062)
    10 frames
  3. Apache Commons DBCP
    DelegatingPreparedStatement.executeUpdate
    1. org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
    2. org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
    2 frames
  4. Hibernate
    SQLQueryImpl.executeUpdate
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
    2. org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211)
    3. org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1346)
    4. org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389)
    4 frames
  5. org.hibernate.jpa
    AbstractQueryImpl.executeUpdate
    1. org.hibernate.jpa.internal.QueryImpl.internalExecuteUpdate(QueryImpl.java:371)
    2. org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:78)
    2 frames
  6. com.leafletcorp.dao
    DataMigrationDaoImpl.savePackageDependencies
    1. com.leafletcorp.dao.impl.DataMigrationDaoImpl.savePackageDependencies(DataMigrationDaoImpl.java:516)
    1 frame
  7. com.leafletcorp.service
    AssembleServiceImpl.savePackageDependencies
    1. com.leafletcorp.service.impl.AssembleServiceImpl.savePackageDependencies(AssembleServiceImpl.java:114)
    1 frame
  8. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor446.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:497)
    3 frames
  9. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    3 frames
  10. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    3 frames
  11. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    2. org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    4. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
    4 frames
  12. com.sun.proxy
    $Proxy113.savePackageDependencies
    1. com.sun.proxy.$Proxy113.savePackageDependencies(Unknown Source)
    1 frame
  13. com.leafletcorp.service
    DocumentServiceImpl.saveAssemblePackage
    1. com.leafletcorp.service.impl.DocumentServiceImpl.saveAssemblePackage(DocumentServiceImpl.java:886)
    1 frame
  14. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor271.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:497)
    3 frames
  15. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    3 frames
  16. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    3 frames
  17. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    2. org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    4. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
    4 frames
  18. com.sun.proxy
    $Proxy115.saveAssemblePackage
    1. com.sun.proxy.$Proxy115.saveAssemblePackage(Unknown Source)
    1 frame
  19. com.leafletcorp.web
    PakageController.assemblePakages
    1. com.leafletcorp.web.PakageController.assemblePakages(PakageController.java:362)
    1 frame
  20. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:497)
    3 frames
  21. Spring
    InvocableHandlerMethod.invokeForRequest
    1. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
    2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
    2 frames
  22. Spring MVC
    FrameworkServlet.doPost
    1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
    2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:776)
    3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)
    4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
    6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
    7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
    8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
    8 frames
  23. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
    1 frame
  24. Spring MVC
    FrameworkServlet.service
    1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
    1 frame
  25. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
    1 frame
  26. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  27. Tomcat WS
    WsFilter.doFilter
    1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    1 frame
  28. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  29. com.leafletcorp.sso
    ServiceProviderSSOFilter.doFilter
    1. com.leafletcorp.sso.ServiceProviderSSOFilter.doFilter(ServiceProviderSSOFilter.java:220)
    1 frame
  30. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  31. com.leafletcorp.interceptors
    LogSessionServletFilter.doFilter
    1. com.leafletcorp.interceptors.LogSessionServletFilter.doFilter(LogSessionServletFilter.java:35)
    1 frame
  32. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  33. Spring ORM
    OpenEntityManagerInViewFilter.doFilterInternal
    1. org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178)
    1 frame
  34. Spring
    OncePerRequestFilter.doFilter
    1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    1 frame
  35. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
    8. org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
    10 frames
  36. Grizzly HTTP
    NioEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
    3. org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
    4. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1556)
    5. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1513)
    5 frames
  37. Java RT
    ThreadPoolExecutor$Worker.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    2 frames
  38. Tomcat Util
    TaskThread$WrappingRunnable.run
    1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    1 frame
  39. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame