javax.resource.spi.ResourceAdapterInternalException: Unexpected error

GitHub | mincong-h | 7 months ago
  1. 0

    java.lang.OutOfMemoryError: GC overhead limit exceeded

    GitHub | 7 months ago | mincong-h
    javax.resource.spi.ResourceAdapterInternalException: Unexpected error
  2. 0

    db:: 4.23::Infinispan error as "org.infinispan.commons.CacheException" ka

    hivmr.com | 5 months ago
    infinispan.persistence.spi.PersistenceException: SQL error while fetching all StoredEntries
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    The execution of check() function halts while executing the inital query to find files to check: 2007-11-06 16:52:19,036 DEBUG -> (http-0.0.0.0-8080-3) [org.dcm4chex.archive.mbean.MD5CheckService] MD5 check started! 2007-11-06 16:52:19,060 DEBUG -> (http-0.0.0.0-8080-3) [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.FileSystem#findAll] Executing SQL: SELECT t0_fs.pk, t0_fs.dirpath, t0_fs.fs_group_id, t0_fs.retrieve_aet, t0_fs.availability, t0_fs.fs_status, t0_fs.user_info, t0_fs.next_fk FROM filesystem t0_fs 2007-11-06 16:52:19,071 DEBUG -> (http-0.0.0.0-8080-3) [org.dcm4chex.archive.ejb.session.FileSystemMgtBean] Querying for files to check md5 in /pole/dcm 2007-11-06 16:52:19,071 DEBUG -> (http-0.0.0.0-8080-3) [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.File#findToCheckMd5] Executing SQL: SELECT t0_f.pk, t0_f.created_time, t0_f.md5_check_time, t0_f.filepath, t0_f.file_tsuid, t0_f.file_md5, t0_f.file_status, t0_f.file_size, t0_f.filesystem_fk, t0_f.instance_fk FROM files t0_f, filesystem t1_f_fileSystem WHERE (t1_f_fileSystem.dirpath = ? AND t0_f.file_md5 IS NOT NULL AND (t0_f.md5_check_time IS NULL OR t0_f.md5_check_time < ?) AND t0_f.filesystem_fk=t1_f_fileSystem.pk) 2007-11-06 16:52:19,071 DEBUG -> (http-0.0.0.0-8080-3) [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.File#findToCheckMd5] Query offset=0, limit=1 2007-11-06 16:55:22,263 WARN -> (http-0.0.0.0-8080-3) [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@6fd3633c[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@11da1f99 handles=1 lastUse=1194364339069 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@7507ef7 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@35bf8de1 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@32fbca58 txSync=null] javax.resource.spi.ResourceAdapterInternalException: Unexpected error at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConnection.java:293) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.java:273) at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:553) at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:563) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:241) at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:243) at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:144) at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:54) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:613) at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:337) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:242) at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:662) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.invocation.Invocation.performCall(Invocation.java:359) at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1126) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:203) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:189) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:134) at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:76) at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:43) at org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallValidationInterceptor.java:56) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:125) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:378) at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:161) at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:145) at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:132) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:107) at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:521) at org.jboss.ejb.Container.invoke(Container.java:975) at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:359) at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:133) at $Proxy99.findToCheckMd5(Unknown Source) at org.dcm4chex.archive.ejb.session.FileSystemMgtBean.findFilesForMD5Check(FileSystemMgtBean.java:225) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.invocation.Invocation.performCall(Invocation.java:359) at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169) at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136) at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648) at org.jboss.ejb.Container.invoke(Container.java:954) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118) at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209) at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70) at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100) at $Proxy194.findFilesForMD5Check(Unknown Source) at org.dcm4chex.archive.mbean.MD5CheckService.check(MD5CheckService.java:192) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.jmx.adaptor.control.Server.invokeOpByName(Server.java:258) at org.jboss.jmx.adaptor.control.Server.invokeOp(Server.java:223) at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.invokeOp(HtmlAdaptorServlet.java:262) at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.processRequest(HtmlAdaptorServlet.java:100) at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.doPost(HtmlAdaptorServlet.java:82) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:619) Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded at com.mysql.jdbc.ByteArrayBuffer.getBytes(ByteArrayBuffer.java:128) at com.mysql.jdbc.MysqlIO.extractNativeEncodedColumn(MysqlIO.java:3802) at com.mysql.jdbc.MysqlIO.unpackBinaryResultSetRow(MysqlIO.java:3762) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1347) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2301) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:423) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1991) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1413) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1143) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:243) at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:144) at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:54) at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:613) at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:337) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:242) at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:662) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.invocation.Invocation.performCall(Invocation.java:359) at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1126) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:203) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:189) at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:134) at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:76) at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:43) 2007-11-06 16:55:22,747 ERROR -> (http-0.0.0.0-8080-3) [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.File#findToCheckMd5] Find failed so it's caused by heap overflow. Going deeper into this I found possible cause for this - under some circumstances the mysql jdbc driver is not able to fetch just part of the resultset as required by the limit defined in the query, but fetches the whole resultset instead (read http://lists.mysql.com/java/9125 for more). for very large archive this is impossible, because the resulset is too big for even very big java heap (e.g. 2G).. the archive stops working after this happens and needs to be restarted. the MD5 check service must be disabled in order for the archive to work

    JIRA | 9 years ago | Petr Kalina
    javax.resource.spi.ResourceAdapterInternalException: Unexpected error
  5. 0

    SQL Developer freezing with GC overhead limit exceeded error on MySQL database

    Oracle Community | 2 years ago | user12151084
    java.lang.OutOfMemoryError: GC overhead limit exceeded

    2 unregistered visitors
    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.lang.OutOfMemoryError

      GC overhead limit exceeded

      at com.mysql.jdbc.MysqlIO.nextRowFast()
    2. MySQL jdbc
      PreparedStatement.executeQuery
      1. com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2157)
      2. com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1964)
      3. com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3316)
      4. com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:463)
      5. com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3040)
      6. com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2288)
      7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2681)
      8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
      9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
      10. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
      10 frames
    3. IronJacamar
      WrappedPreparedStatement.executeQuery
      1. org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)
      1 frame
    4. Hibernate
      CriteriaImpl.uniqueResult
      1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:2116)
      3. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1899)
      4. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1875)
      5. org.hibernate.loader.Loader.doQuery(Loader.java:919)
      6. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
      7. org.hibernate.loader.Loader.doList(Loader.java:2611)
      8. org.hibernate.loader.Loader.doList(Loader.java:2594)
      9. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2423)
      10. org.hibernate.loader.Loader.list(Loader.java:2418)
      11. org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
      12. org.hibernate.internal.SessionImpl.list(SessionImpl.java:1774)
      13. org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:363)
      14. org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:385)
      14 frames
    5. io.github.mincongh
      IdProducerBatchlet.process
      1. io.github.mincongh.batch.IdProducerBatchlet.process(IdProducerBatchlet.java:50)
      1 frame
    6. org.jberet.runtime
      JobExecutionRunner.run
      1. org.jberet.runtime.runner.BatchletRunner.run(BatchletRunner.java:72)
      2. org.jberet.runtime.runner.StepExecutionRunner.runBatchletOrChunk(StepExecutionRunner.java:222)
      3. org.jberet.runtime.runner.StepExecutionRunner.run(StepExecutionRunner.java:140)
      4. org.jberet.runtime.runner.CompositeExecutionRunner.runStep(CompositeExecutionRunner.java:164)
      5. org.jberet.runtime.runner.CompositeExecutionRunner.runFromHeadOrRestartPoint(CompositeExecutionRunner.java:88)
      6. org.jberet.runtime.runner.JobExecutionRunner.run(JobExecutionRunner.java:59)
      6 frames