• Recent
    • Tags
    • Popular
    • Register
    • Login

    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.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    No pages will load: Timeout trying to lock table events

    User help
    2
    6
    2.2k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      craig
      last edited by craig

      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 Running

      Any advice as to how I should proceed to get mangoES working again?

      Craig

      1 Reply Last reply Reply Quote 0
      • C
        craig
        last edited by

        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?

        1 Reply Last reply Reply Quote 0
        • phildunlapP
          phildunlap
          last edited by

          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.

          1 Reply Last reply Reply Quote 0
          • C
            craig
            last edited by

            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

            1 Reply Last reply Reply Quote 0
            • phildunlapP
              phildunlap
              last edited by

              Hi Craig,

              I will push to get this out for you as soon as possible.

              1 Reply Last reply Reply Quote 0
              • phildunlapP
                phildunlap
                last edited by

                It is released.

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post