Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
No pages will load: Timeout trying to lock table events
-
Every page I go to has this error:
Server error: PreparedStatementCallback; SQL [SELECT evt.id,evt.typeName,evt.subtypeName,evt.typeRef1,evt.typeRef2,evt.activeTs,evt.rtnApplicable,evt.rtnTs,evt.rtnCause,evt.alarmLevel,evt.message,evt.ackTs,evt.ackUserId,evt.alternateAckSource,u.username,(select count(1) from userComments where commentType=1 and typeKey=evt.id) as cnt ,ue.silenced FROM events AS evt left join users u on evt.ackUserId=u.id left join userEvents ue on evt.id=ue.eventId WHERE ackTs IS NULL AND evt.alarmLevel >= 1 AND ue.userId IN (?) ORDER BY activeTs DESC OFFSET ? ROWS FETCH NEXT ? ROWS ONLY]; Timeout trying to lock table "EVENTS"; SQL statement: SELECT evt.id,evt.typeName,evt.subtypeName,evt.typeRef1,evt.typeRef2,evt.activeTs,evt.rtnApplicable,evt.rtnTs,evt.rtnCause,evt.alarmLevel,evt.message,evt.ackTs,evt.ackUserId,evt.alternateAckSource,u.username,(select count(1) from userComments where commentType=1 and typeKey=evt.id) as cnt ,ue.silenced FROM events AS evt left join users u on evt.ackUserId=u.id left join userEvents ue on evt.id=ue.eventId WHERE ackTs IS NULL AND evt.alarmLevel >= 1 AND ue.userId IN (?) ORDER BY activeTs DESC OFFSET ? ROWS FETCH NEXT ? ROWS ONLY [50200-181]; nested exception is org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "EVENTS"; SQL statement: SELECT evt.id,evt.typeName,evt.subtypeName,evt.typeRef1,evt.typeRef2,evt.activeTs,evt.rtnApplicable,evt.rtnTs,evt.rtnCause,evt.alarmLevel,evt.message,evt.ackTs,evt.ackUserId,evt.alternateAckSource,u.username,(select count(1) from userComments where commentType=1 and typeKey=evt.id) as cnt ,ue.silenced FROM events AS evt left join users u on evt.ackUserId=u.id left join userEvents ue on evt.id=ue.eventId WHERE ackTs IS NULL AND evt.alarmLevel >= 1 AND ue.userId IN (?) ORDER BY activeTs DESC OFFSET ? ROWS FETCH NEXT ? ROWS ONLY [50200-181]in the log I see:
ERROR 2016-04-14 09:54:39,361 (com.serotonin.epoll.InputStreamEPoll.run:110) - Input stream callback exception org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into events (typeName, subtypeName, typeRef1, typeRef2, activeTs, rtnApplicable, rtnTs, rtnCause, alarmLevel, message, ackTs) values (?,?,?,?,?,?,?,?,?,?,?)]; SQL state [HYT00]; error code [50200]; Timeout trying to lock table "EVENTS"; SQL statement: insert into events (typeName, subtypeName, typeRef1, typeRef2, activeTs, rtnApplicable, rtnTs, rtnCause, alarmLevel, message, ackTs) values (?,?,?,?,?,?,?,?,?,?,?) [50200-181]; nested exception is org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "EVENTS"; SQL statement: insert into events (typeName, subtypeName, typeRef1, typeRef2, activeTs, rtnApplicable, rtnTs, rtnCause, alarmLevel, message, ackTs) values (?,?,?,?,?,?,?,?,?,?,?) [50200-181] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645) at com.serotonin.db.spring.ExtendedJdbcTemplate.update(ExtendedJdbcTemplate.java:112) at com.serotonin.db.spring.ExtendedJdbcTemplate.update(ExtendedJdbcTemplate.java:95) at com.serotonin.db.spring.ExtendedJdbcTemplate.update(ExtendedJdbcTemplate.java:91) at com.serotonin.db.DaoUtils.doInsert(DaoUtils.java:159) at com.serotonin.m2m2.db.dao.EventDao.insertEvent(EventDao.java:83) at com.serotonin.m2m2.db.dao.EventDao.saveEvent(EventDao.java:51) at com.serotonin.m2m2.rt.EventManager.raiseEvent(EventManager.java:111) at com.serotonin.m2m2.rt.dataSource.DataSourceRT.raiseEvent(DataSourceRT.java:150) at com.serotonin.m2m2.modbus.rt.ModbusDataSourceRT.receivedException(ModbusDataSourceRT.java:463) at com.serotonin.modbus4j.sero.messaging.MessageControl.data(MessageControl.java:201) at com.serotonin.modbus4j.sero.messaging.EpollStreamTransport$1.input(EpollStreamTransport.java:39) at com.serotonin.m2m2.modbus.rt.MangoInputStreamCallbackWrapper.input(MangoInputStreamCallbackWrapper.java:30) at com.serotonin.epoll.InputStreamEPoll.run(InputStreamEPoll.java:94) at com.serotonin.timer.NamedRunnable.run(NamedRunnable.java:25) 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) Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "EVENTS"; SQL statement: insert into events (typeName, subtypeName, typeRef1, typeRef2, activeTs, rtnApplicable, rtnTs, rtnCause, alarmLevel, message, ackTs) values (?,?,?,?,?,?,?,?,?,?,?) [50200-181] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.table.RegularTable.doLock1(RegularTable.java:504) at org.h2.table.RegularTable.lock(RegularTable.java:469) at org.h2.command.dml.Insert.insertRows(Insert.java:154) at org.h2.command.dml.Insert.update(Insert.java:114) at org.h2.command.CommandContainer.update(CommandContainer.java:78) at org.h2.command.Command.executeUpdate(Command.java:254) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:157) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:143) at com.serotonin.db.spring.ExtendedJdbcTemplate$1.doInPreparedStatement(ExtendedJdbcTemplate.java:119) at com.serotonin.db.spring.ExtendedJdbcTemplate$1.doInPreparedStatement(ExtendedJdbcTemplate.java:112) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629) ... 17 more WARN 2016-04-14 09:54:39,746 (com.serotonin.m2m2.rt.dataSource.PollingDataSource$2.execute:226) - PLC0: poll scheduled at 2016/04/14 09:54:39.744 aborted because Task Currently Running WARN 2016-04-14 09:54:39,746 (com.serotonin.m2m2.rt.dataSource.PollingDataSource$2.execute:226) - Unit 2: poll scheduled at 2016/04/14 09:54:39.744 aborted because Task Currently RunningAny advice as to how I should proceed to get mangoES working again?
Craig
-
i had run out of disk space again.
looks like a fix for the issue has been committed: https://github.com/infiniteautomation/ma-core-public/issues/687
What needs to happen for this fix to reach my mangoES via the check for upgrades function?
-
We need to release it. There is one other change that is trying to sneak in to the Reports module. I will try to get this module released for you on Monday next week.
-
I'm hopeful you can release this module this week, with or without additional changes. The operator from the power plant down the road has shown his scheduled e-mail reports to the operator from a power plant further down the road, I'd say you will have another mango ES sale coming down the pipe soon, but I probably won't have access to that one after the initial set up, so it would be helpful if the report disk space leak issue fix can be released. Thanks
-
Hi Craig,
I will push to get this out for you as soon as possible.
-
It is released.
