java.lang.OutOfMemoryError: GC overhead limit exceeded

hsqldb | jerome-dx | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Mass inserts, backup & checkpoints, getFromFile out of mem

    hsqldb | 3 years ago | jerome-dx
    java.lang.OutOfMemoryError: GC overhead limit exceeded
  2. 0

    Inner Join is not working for two million rows tables

    hsqldb | 3 months ago | vishnucygnus
    java.sql.SQLException: java.lang.OutOfMemoryError: Java heap space

    Root Cause Analysis

    1. java.lang.OutOfMemoryError

      GC overhead limit exceeded

      at org.hsqldb.rowio.RowInputBase.readData()
    2. HSQLDB
      JDBCStatement.executeQuery
      1. org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
      2. org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
      3. org.hsqldb.rowio.RowInputBinaryDecode.readData(Unknown Source)
      4. org.hsqldb.RowAVLDisk.<init>(Unknown Source)
      5. org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
      6. org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)
      7. org.hsqldb.persist.DataFileCache.get(Unknown Source)
      8. org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
      9. org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)
      10. org.hsqldb.index.NodeAVLDisk.getLeft(Unknown Source)
      11. org.hsqldb.index.IndexAVL.next(Unknown Source)
      12. org.hsqldb.index.IndexAVL.next(Unknown Source)
      13. org.hsqldb.index.IndexAVL$IndexRowIterator.getNextRow(Unknown Source)
      14. org.hsqldb.RangeVariable$RangeIteratorMain.findNext(Unknown Source)
      15. org.hsqldb.RangeVariable$RangeIteratorMain.next(Unknown Source)
      16. org.hsqldb.QuerySpecification.buildResult(Unknown Source)
      17. org.hsqldb.QuerySpecification.getSingleResult(Unknown Source)
      18. org.hsqldb.QuerySpecification.getResult(Unknown Source)
      19. org.hsqldb.TableDerived.materialise(Unknown Source)
      20. org.hsqldb.StatementDMQL.materializeSubQueries(Unknown Source)
      21. org.hsqldb.StatementDMQL.execute(Unknown Source)
      22. org.hsqldb.Session.executeCompiledStatement(Unknown Source)
      23. org.hsqldb.Session.executeDirectStatement(Unknown Source)
      24. org.hsqldb.Session.execute(Unknown Source)
      25. org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
      26. org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
      26 frames
    3. Commons DBCP
      DelegatingStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
      2. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
      3. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
      3 frames
    4. Spring Framework
      JdbcTemplate.query
      1. org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:452)
      2. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:402)
      3. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:468)
      3 frames