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]

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • GitHub comment 124#250979945
    via GitHub by nezda
    ,
  • GitHub comment 181#284346166
    via GitHub by MaikJaek
    ,
  • GitHub comment 181#284352768
    via GitHub by trask
    ,
  • GitHub comment 181#284352279
    via GitHub by trask
    ,
    • 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(DbException.java:344) at org.glowroot.agent.shaded.h2.message.DbException.get(DbException.java:167) at org.glowroot.agent.shaded.h2.message.DbException.convert(DbException.java:288) at org.glowroot.agent.shaded.h2.command.Command.executeUpdate(Command.java:260) at org.glowroot.agent.shaded.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:158) at org.glowroot.agent.shaded.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:144) at org.glowroot.agent.fat.storage.util.DataSource.update(DataSource.java:308) at org.glowroot.agent.fat.storage.util.DataSource.update(DataSource.java:278) at org.glowroot.agent.fat.storage.GaugeValueDao.rollup(GaugeValueDao.java:183) at org.glowroot.agent.fat.storage.GaugeValueDao.store(GaugeValueDao.java:143) at org.glowroot.agent.fat.init.CollectorImpl.collectGaugeValues(CollectorImpl.java:78) at org.glowroot.agent.init.CollectorProxy.collectGaugeValues(CollectorProxy.java:63) at org.glowroot.agent.init.GaugeCollector$2.run(GaugeCollector.java:133) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)
    No Bugmate found.