org.glowroot.agent.shaded.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement: merge into gauge_value_rollup_2 (gauge_id, capture_time, value, weight) key (gauge_id, capture_time) select gauge_id, ceil(capture_time / 300000.0) * 300000 ceil_capture_time, sum(value * weight) / sum(weight), sum(weight) from gauge_value_rollup_1 gp where gp.capture_time > ? and gp.capture_time <= ? group by gp.gauge_id, ceil_capture_time [90108-176]

GitHub | nezda | 2 months ago
  1. 0

    GitHub comment 124#250979945

    GitHub | 2 months ago | nezda
    org.glowroot.agent.shaded.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement: merge into gauge_value_rollup_2 (gauge_id, capture_time, value, weight) key (gauge_id, capture_time) select gauge_id, ceil(capture_time / 300000.0) * 300000 ceil_capture_time, sum(value * weight) / sum(weight), sum(weight) from gauge_value_rollup_1 gp where gp.capture_time > ? and gp.capture_time <= ? group by gp.gauge_id, ceil_capture_time [90108-176]
  2. 0

    GitHub comment 124#250979945

    GitHub | 2 months ago | nezda
    org.glowroot.agent.shaded.h2.jdbc.JdbcSQLException: The database has been closed [90098-176]

    Root Cause Analysis

    1. org.glowroot.agent.shaded.h2.jdbc.JdbcSQLException

      Out of memory.; SQL statement: merge into gauge_value_rollup_2 (gauge_id, capture_time, value, weight) key (gauge_id, capture_time) select gauge_id, ceil(capture_time / 300000.0) * 300000 ceil_capture_time, sum(value * weight) / sum(weight), sum(weight) from gauge_value_rollup_1 gp where gp.capture_time > ? and gp.capture_time <= ? group by gp.gauge_id, ceil_capture_time [90108-176]

      at org.glowroot.agent.shaded.h2.message.DbException.getJdbcSQLException()
    2. org.glowroot.agent
      GaugeCollector$2.run
      1. org.glowroot.agent.shaded.h2.message.DbException.getJdbcSQLException(DbException.java:344)
      2. org.glowroot.agent.shaded.h2.message.DbException.get(DbException.java:167)
      3. org.glowroot.agent.shaded.h2.message.DbException.convert(DbException.java:288)
      4. org.glowroot.agent.shaded.h2.command.Command.executeUpdate(Command.java:260)
      5. org.glowroot.agent.shaded.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:158)
      6. org.glowroot.agent.shaded.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:144)
      7. org.glowroot.agent.fat.storage.util.DataSource.update(DataSource.java:308)
      8. org.glowroot.agent.fat.storage.util.DataSource.update(DataSource.java:278)
      9. org.glowroot.agent.fat.storage.GaugeValueDao.rollup(GaugeValueDao.java:183)
      10. org.glowroot.agent.fat.storage.GaugeValueDao.store(GaugeValueDao.java:143)
      11. org.glowroot.agent.fat.init.CollectorImpl.collectGaugeValues(CollectorImpl.java:78)
      12. org.glowroot.agent.init.CollectorProxy.collectGaugeValues(CollectorProxy.java:63)
      13. org.glowroot.agent.init.GaugeCollector$2.run(GaugeCollector.java:133)
      13 frames
    3. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      3. java.lang.Thread.run(Thread.java:745)
      3 frames