• B
    Brad_GMI

    I use an event detector on the last update of a data point that i know changes on a regular basis. So far, so good.

    posted in Mango Automation general Discussion read more
  • B
    Brad_GMI

    This is a enterprise install with NoSQL.

    There are currently ~35 Persistent TCP datasources in this install.

    I did notice today that the datasource page will not load the datasources, but the dashboard and datapoints pages appear to be displaying the data properly.

    I'm going to check an older database and see if that helps.

    posted in Mango Automation general Discussion read more
  • B
    Brad_GMI

    It appears as though I am back in business. This has apparently been going on since July 5.

    I restored the backup from July 4 and all appears to be functioning.

    The database is sitting at 3 GB now. Any idea what would cause such a dramatic increase?

    Thank you for the assistance!

    posted in Mango Automation general Discussion read more
  • B
    Brad_GMI

    Thanks for the information. I suspect that will get me going in the right direction.

    The lastest piece of the puzzle is the service will not shutdown.

    The server stops listening on 8080, but a portion of the persistent connections still remain connected according to netstat.

    If I kill the PID, I suspect the lock will not be released?

    posted in Mango Automation general Discussion read more
  • B
    Brad_GMI

    This is version 2.8.

    The systems resides in an AWS EC2 instance. Currently the mah2.h2.db file is 12 GB.

    I don't have any additional event handling that I am aware of.

    Currently, there is a lock file that is hindering the web console.

    I'm not familiar with the H2 database, so I don't want to get to far away from home. If i move this lock file, I should be able to clean the event table?

    posted in Mango Automation general Discussion read more
  • B
    Brad_GMI

    Our central server is having an issue where, when a user attempts to login, CPU utilization grows until it reaches 100%.

    Occasionally, a user will be authorized, but nothing will load.

    This is one entry from a recent log that seems related:

    ERROR 2018-07-30 10:37:48,116 (com.serotonin.m2m2.rt.RuntimeManager.stopDataSourceShutdown:413) - Data source 'Zirkle Facility D' failed proper termination.
    org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLog$
    SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purg$
    SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purg$
            at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:259)
            at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
            at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645)
            at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680)
            at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
            at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
            at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39)
            at com.serotonin.db.DaoUtils.queryForObject(DaoUtils.java:332)
            at com.serotonin.m2m2.db.dao.AbstractBasicDao.get(AbstractBasicDao.java:549)
            at com.serotonin.m2m2.vo.permission.Permissions.hasEventTypePermission(Permissions.java:248)
            at com.serotonin.m2m2.rt.EventManager.deactivateEvents(EventManager.java:316)
            at com.serotonin.m2m2.rt.EventManager.cancelEventsForDataPoint(EventManager.java:529)
            at com.serotonin.m2m2.rt.dataImage.DataPointRT.terminate(DataPointRT.java:699)
            at com.serotonin.m2m2.rt.RuntimeManager.stopDataPointShutdown(RuntimeManager.java:561)
            at com.serotonin.m2m2.rt.RuntimeManager.stopDataSourceShutdown(RuntimeManager.java:402)
            at com.serotonin.m2m2.rt.DataSourceGroupTerminator$DataSourceSubGroupTerminator.run(DataSourceGroupTerminator.java:141)
            at com.serotonin.timer.TimerTask.runTask(TimerTask.java:148)
            at com.serotonin.timer.TimerTask.run(TimerTask.java:119)
            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 "DATAPOINTS"; SQL statement:
    SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purg$
            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.table.TableFilter.lock(TableFilter.java:146)
            at org.h2.command.dml.Select.queryWithoutCache(Select.java:630)
            at org.h2.command.dml.Query.query(Query.java:322)
            at org.h2.command.dml.Query.query(Query.java:290)
            at org.h2.command.dml.Query.query(Query.java:36)
            at org.h2.command.CommandContainer.query(CommandContainer.java:90)
            at org.h2.command.Command.executeQuery(Command.java:197)
            at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:108)
            at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:688)
            at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)
            ... 18 more
    
    

    Any ideas?

    posted in Mango Automation general Discussion read more
  • B
    Brad_GMI

    Is there a way to address the point hierarchy of a point in a report template?

    Based on what I can find in the code, I don't see any record of that information being based to the report module.

    posted in Mango Automation general Discussion read more
  • B
    Brad_GMI

    We have been testing and refining our dashboard setup for around three months now and have resolved most of the user feedback.

    The biggest and final complaint we have left to resolve is the chart complexity.

    All of the users would prefer to have less options in the date range drop down, and no roll up data.

    From what I can tell, a good bit of this work is done in the dateBar and dateRangePicker components.

    To achieve the goal above, is the best path forward to override the components of the mdAdmin template, or is there a simpler path?

    posted in Mango Automation general Discussion read more
  • B
    Brad_GMI

    The updated system exports with no errors. I'll try a different system on 2.7.1 and see what it does.

    posted in Mango Automation general Discussion read more
  • B
    Brad_GMI

    So I bit the bullet and updated the install to 2.8.6.

    As of now, the system is syncing every 5 minutes without issue.

    posted in Mango Automation general Discussion read more