@MattFox If I am not wrong, in Mango 5, you must access the web with 8443 (or SSL route) and there is no workaround. I'm using an Mango instance on Windows to try stuff and no way out :"<
Posts made by tungthanh500
-
RE: Docker and Mango v5.0.2
-
RE: Syntax for Read Permission = true in query
@Benoit You can post your devices structure here, we can give you some advise or suggestion.
About learning about script, you can see examples in people's posts -
RE: Syntax for Read Permission = true in query
@Benoit Totally agree with Matt. You should use tags more for easy filtering. It may takes some time but you can optimise your code
-
RE: Announcing the New Mango 5 Pre-Release: Download Now and Explore Exciting Features!
Congrat on new Version in few hours.
I found this "bug" (not sure if it is).
Below is my measurement of energy at my flat (latest 5.0.1). You can see that I clicked at 3 Jun, the values and timestamp appears on 4 Jun. This also happens on Mango 4.
-
RE: Announcing the New Mango 5 Pre-Release: Download Now and Explore Exciting Features!
@mumcs01 is there any place where we can give our feedback?
-
RE: Help with ideas for how to guide
@CraigWeb Do you mind making a tutorial regarding to SSL certify on Windows for Mango 5 (or Mango 4)? I know the system should be installed on Linux based for better configuration but Windows is preferred in my place and it is not easy for us to write an instruction on how to use everything on Ubuntu
-
RE: MySQL database restore
Hi @CraigWeb , actually I was trying to install a new Mango 5 instance. Everything is totally new. These are what I did:
1/ Install MySQL 8.0, create a database (scheme) named mango
2/ Install Mango 5 and paste a mango.properties file with MySQL info as above mentioned in mango_data folder.
3/ Start mango service and change admin password.
4/ Create a data source with some data point.
5/ Backup with Backup feature in System Setting -> SQL backup
6/ Delete data source and restore with System Setting -> SQL backup.
7/ See that orange warning pop up, but the deleted data source and data point is back, but I'm not sure if it normal or not. -
MySQL database restore
Hi, I just start to try using Mango 5 and MySQL. This is the first time I use MySQL at all. I can backup the sql with System -> SQL database backup but when I tried to restore, I got this warning
Even though, the deleted data source was restore but I don't know what may be wrong.
Below is my MySQL config in mango.properties. I doubt my db.mysql is not correct.
db.type=mysql db.url=jdbc:mysql://localhost/mango db.username=root db.password=mangotesting db.mysqldump=C:/Program Files/MySQL/MySQL Server 8.0/bin/mysqldump.exe db.mysql=C:/Program Files/MySQL/MySQL Server 8.0/bin/mysql.exe
-
RE: Mango instance cannot initialize
@CraigWeb thank you. I start fresh and restore with System settings -> SQL database backup -> select latest core-database-H2 zip file.
Is that enough? I check the Data point detail and found nothing in history :| Is there something I miss? I see also see MangoNoSQL-incremental-Mar-12-2023_063732.zip in backup folder but I have no idea how restore this file.Update: I restored from another backup file and found out that that latest is broken. All data is lost.
Thank you all for your help.
-
RE: Mango instance cannot initialize
@CraigWeb Is the mah2 DB at C:\mango_data\databases?
-
Mango instance cannot initialize
Hi guys,
My Mango face a strange error, it cannot start, there is something related to SQL stop it. I checked the logs folder and find thousand of compressed log file. The latest log is like this:
INFO 2023-05-23T07:07:56,681 (com.serotonin.m2m2.Main.createLifecycle:273) - Starting Mango 4.5.0 with Schema Version: 47 INFO 2023-05-23T07:07:56,690 (com.serotonin.m2m2.Main.createLifecycle:277) - Java VM: OpenJDK 64-Bit Server VM, version: 20.0.1+9, vendor: Eclipse Adoptium INFO 2023-05-23T07:07:56,690 (com.serotonin.m2m2.Main.createLifecycle:278) - Java spec: Java Virtual Machine Specification, version: 20, vendor: Oracle Corporation INFO 2023-05-23T07:07:56,690 (com.serotonin.m2m2.Main.createLifecycle:284) - Operating System: Windows 11, arch: amd64, version: 10.0 INFO 2023-05-23T07:07:56,690 (com.serotonin.m2m2.Main.createLifecycle:290) - Running as user account: DAXVIEWEMS$ INFO 2023-05-23T07:07:56,690 (com.serotonin.m2m2.Main.createLifecycle:293) - Installation directory: C:\mango INFO 2023-05-23T07:07:56,690 (com.serotonin.m2m2.Main.createLifecycle:294) - Data directory: C:\mango_data INFO 2023-05-23T07:07:56,690 (com.serotonin.m2m2.Main.createLifecycle:295) - Configuration file: C:\mango_data\mango.properties INFO 2023-05-23T07:07:56,800 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'advancedScheduler', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,800 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'asciiFile', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,800 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'BACnet', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'cloudConnect', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'controlcore', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'dashboardDesigner', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'dataFile', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'dnp3', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'egauge', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'envcands', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'excelReports', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'graaljs', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'groovy', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'Haystack', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'http', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'lang_en', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'ldapAuthentication', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'lineProtocolDataSource', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'log4jDS', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'log4JReset', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'maintenanceEvents', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'mangoApi', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'mangoNoSqlDatabase', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'mangoUI', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'meta', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'modbus', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'mqttClientDataSource', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'onewire', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,815 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'opcda', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'persistent', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'pop3', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'scripting', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'serial', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'slackPublisher', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'snmp', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'sqlConsole', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'sqlds', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'ssh', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'sstGlobalScripts', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'TCPIP', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'virtualDS', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'vmstat', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'watchlists', v4.5.0 by Radix IoT INFO 2023-05-23T07:07:56,831 (com.serotonin.m2m2.Main.loadModules:683) - Loading module 'internal', v4.5.0 by Radix IoT ERROR 2023-05-23T07:07:57,596 (com.serotonin.m2m2.Lifecycle.webServerInitialize:1052) - Couldn't open browser window, perhaps set web.openBrowserOnStartup to false? java.io.IOException: Failed to open http://localhost:8080. Error message: No application is associated with the specified file for this operation. at sun.awt.windows.WDesktopPeer.ShellExecute(WDesktopPeer.java:115) ~[?:?] at sun.awt.windows.WDesktopPeer.browse(WDesktopPeer.java:101) ~[?:?] at java.awt.Desktop.browse(Desktop.java:533) ~[?:?] at com.serotonin.m2m2.Lifecycle.webServerInitialize(Lifecycle.java:1046) ~[ma-priv-4.5.0.jar:?] at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:222) ~[ma-priv-4.5.0.jar:?] at com.serotonin.m2m2.Main.main(Main.java:246) ~[ma-priv-4.5.0.jar:?] at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:578) ~[?:?] at com.infiniteautomation.mango.bootstrap.MangoBootstrap.startMango(MangoBootstrap.java:131) ~[ma-bootstrap.jar:?] at com.infiniteautomation.mango.bootstrap.MangoBootstrap.main(MangoBootstrap.java:68) ~[ma-bootstrap.jar:?] INFO 2023-05-23T07:07:57,599 (com.serotonin.m2m2.Lifecycle.loadLic:546) - Checking license... INFO 2023-05-23T07:07:58,456 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:80) - Initializing H2 connection manager INFO 2023-05-23T07:07:59,037 (com.serotonin.m2m2.db.upgrade.DatabaseSchemaUpgrader.checkCoreUpgrade:39) - Starting instance with core version 4.5.0, schema v47 INFO 2023-05-23T07:07:59,492 (com.infiniteautomation.nosql.MangoNoSqlPointValueDaoDefinition.initialize:77) - Starting MangoNoSql Database INFO 2023-05-23T07:07:59,523 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:184) - Database at C:\mango_data\databases\mangoTSDB started INFO 2023-05-23T07:07:59,626 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:213) - Empty dir delete for database at C:\mango_data\databases\mangoTSDB took 63ms INFO 2023-05-23T07:07:59,672 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:184) - Database at C:\mango_data\databases\mangoTSDBAux started INFO 2023-05-23T07:07:59,705 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:213) - Empty dir delete for database at C:\mango_data\databases\mangoTSDBAux took 0ms INFO 2023-05-23T07:07:59,705 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.pointValueDao:376) - Time series database MangoNoSqlPointValueDaoDefinition initialized INFO 2023-05-23T07:08:00,319 (com.infiniteautomation.mango.spring.components.PurgeSettingsListener.configureRetentionPolicy:81) - Setting retention policy is not supported for MangoNoSqlPointValueDao INFO 2023-05-23T07:08:01,323 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:162) - Spring context 'runtimeContext' refreshed: org.springframework.context.annotation.AnnotationConfigApplicationContext@777d191f INFO 2023-05-23T07:08:01,323 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextStarted:176) - Spring context 'runtimeContext' started: org.springframework.context.annotation.AnnotationConfigApplicationContext@777d191f ERROR 2023-05-23T07:08:03,512 (com.serotonin.m2m2.Lifecycle.initialize:334) - Error during initialization org.jooq.exception.DataAccessException: SQL [select events.id, events.typeName, events.subTypeName, events.typeRef1, events.typeRef2, events.activeTs, events.rtnApplicable, events.rtnTs, events.rtnCause, events.alarmLevel, events.message, events.ackTs, events.ackUserId, events.alternateAckSource, events.readPermissionId, users.username, (select count(*) from userComments where (userComments.commentType = cast(? as int) and userComments.typeKey = events.id)) cnt from events left outer join users on users.id = events.ackUserId where (events.rtnApplicable = cast(? as char(1)) and events.rtnTs is null)]; Timeout trying to lock table {0}; SQL statement: select events.id, events.typeName, events.subTypeName, events.typeRef1, events.typeRef2, events.activeTs, events.rtnApplicable, events.rtnTs, events.rtnCause, events.alarmLevel, events.message, events.ackTs, events.ackUserId, events.alternateAckSource, events.readPermissionId, users.username, (select count(*) from userComments where (userComments.commentType = cast(? as int) and userComments.typeKey = events.id)) cnt from events left outer join users on users.id = events.ackUserId where (events.rtnApplicable = cast(? as char(1)) and events.rtnTs is null) [50200-214] at org.jooq_3.16.9.H2.debug(Unknown Source) ~[?:?] at org.jooq.impl.Tools.translate(Tools.java:3097) ~[jooq-3.16.9.jar:?] at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:670) ~[jooq-3.16.9.jar:?] at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:354) ~[jooq-3.16.9.jar:?] at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:284) ~[jooq-3.16.9.jar:?] at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2843) ~[jooq-3.16.9.jar:?] at com.serotonin.m2m2.db.dao.EventDao.getActiveEvents(EventDao.java:290) ~[mango-4.5.0.jar:?] at com.serotonin.m2m2.rt.EventManagerImpl.initialize(EventManagerImpl.java:800) ~[mango-4.5.0.jar:?] at com.serotonin.m2m2.Lifecycle.eventManagerInitialize(Lifecycle.java:738) ~[ma-priv-4.5.0.jar:?] at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:290) ~[ma-priv-4.5.0.jar:?] at com.serotonin.m2m2.Main.main(Main.java:246) ~[ma-priv-4.5.0.jar:?] at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:578) ~[?:?] at com.infiniteautomation.mango.bootstrap.MangoBootstrap.startMango(MangoBootstrap.java:131) ~[ma-bootstrap.jar:?] at com.infiniteautomation.mango.bootstrap.MangoBootstrap.main(MangoBootstrap.java:68) ~[ma-bootstrap.jar:?] Caused by: org.h2.jdbc.JdbcSQLTimeoutException: Timeout trying to lock table {0}; SQL statement: select events.id, events.typeName, events.subTypeName, events.typeRef1, events.typeRef2, events.activeTs, events.rtnApplicable, events.rtnTs, events.rtnCause, events.alarmLevel, events.message, events.ackTs, events.ackUserId, events.alternateAckSource, events.readPermissionId, users.username, (select count(*) from userComments where (userComments.commentType = cast(? as int) and userComments.typeKey = events.id)) cnt from events left outer join users on users.id = events.ackUserId where (events.rtnApplicable = cast(? as char(1)) and events.rtnTs is null) [50200-214] at org.h2.message.DbException.getJdbcSQLException(DbException.java:560) ~[h2-2.1.214.jar:2.1.214] at org.h2.message.DbException.getJdbcSQLException(DbException.java:477) ~[h2-2.1.214.jar:2.1.214] at org.h2.message.DbException.get(DbException.java:212) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.Command.filterConcurrentUpdate(Command.java:324) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.Command.executeQuery(Command.java:201) ~[h2-2.1.214.jar:2.1.214] at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:248) ~[h2-2.1.214.jar:2.1.214] at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:219) ~[jooq-3.16.9.jar:?] at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4356) ~[jooq-3.16.9.jar:?] at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:230) ~[jooq-3.16.9.jar:?] at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:340) ~[jooq-3.16.9.jar:?] ... 11 more Caused by: org.h2.message.DbException: Row "4949" not found in primary index "PUBLIC.EVENTS_DATA" [90143-214] at org.h2.message.DbException.get(DbException.java:223) ~[h2-2.1.214.jar:2.1.214] at org.h2.mvstore.db.MVPrimaryIndex.getRow(MVPrimaryIndex.java:265) ~[h2-2.1.214.jar:2.1.214] at org.h2.mvstore.db.MVTable.getRow(MVTable.java:331) ~[h2-2.1.214.jar:2.1.214] at org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.get(MVSecondaryIndex.java:421) ~[h2-2.1.214.jar:2.1.214] at org.h2.index.IndexCursor.get(IndexCursor.java:270) ~[h2-2.1.214.jar:2.1.214] at org.h2.table.TableFilter.getValue(TableFilter.java:1032) ~[h2-2.1.214.jar:2.1.214] at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:286) ~[h2-2.1.214.jar:2.1.214] at org.h2.index.IndexCondition.getCurrentValue(IndexCondition.java:139) ~[h2-2.1.214.jar:2.1.214] at org.h2.index.IndexCursor.prepare(IndexCursor.java:107) ~[h2-2.1.214.jar:2.1.214] at org.h2.index.IndexCursor.find(IndexCursor.java:153) ~[h2-2.1.214.jar:2.1.214] at org.h2.table.TableFilter.next(TableFilter.java:394) ~[h2-2.1.214.jar:2.1.214] at org.h2.table.TableFilter.next(TableFilter.java:464) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1832) ~[h2-2.1.214.jar:2.1.214] at org.h2.result.LazyResult.hasNext(LazyResult.java:78) ~[h2-2.1.214.jar:2.1.214] at org.h2.result.FetchedResult.next(FetchedResult.java:34) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Select.queryFlat(Select.java:728) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Select.queryWithoutCache(Select.java:833) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Query.queryWithoutCacheLazyCheck(Query.java:197) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Query.query(Query.java:512) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Query.query(Query.java:475) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.CommandContainer.query(CommandContainer.java:251) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.Command.executeQuery(Command.java:190) ~[h2-2.1.214.jar:2.1.214] at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:248) ~[h2-2.1.214.jar:2.1.214] at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:219) ~[jooq-3.16.9.jar:?] at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4356) ~[jooq-3.16.9.jar:?] at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:230) ~[jooq-3.16.9.jar:?] at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:340) ~[jooq-3.16.9.jar:?] ... 11 more Caused by: org.h2.jdbc.JdbcSQLTransientException: Row "4949" not found in primary index "PUBLIC.EVENTS_DATA" [90143-214] at org.h2.message.DbException.getJdbcSQLException(DbException.java:682) ~[h2-2.1.214.jar:2.1.214] at org.h2.message.DbException.getJdbcSQLException(DbException.java:477) ~[h2-2.1.214.jar:2.1.214] at org.h2.message.DbException.get(DbException.java:223) ~[h2-2.1.214.jar:2.1.214] at org.h2.mvstore.db.MVPrimaryIndex.getRow(MVPrimaryIndex.java:265) ~[h2-2.1.214.jar:2.1.214] at org.h2.mvstore.db.MVTable.getRow(MVTable.java:331) ~[h2-2.1.214.jar:2.1.214] at org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.get(MVSecondaryIndex.java:421) ~[h2-2.1.214.jar:2.1.214] at org.h2.index.IndexCursor.get(IndexCursor.java:270) ~[h2-2.1.214.jar:2.1.214] at org.h2.table.TableFilter.getValue(TableFilter.java:1032) ~[h2-2.1.214.jar:2.1.214] at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:286) ~[h2-2.1.214.jar:2.1.214] at org.h2.index.IndexCondition.getCurrentValue(IndexCondition.java:139) ~[h2-2.1.214.jar:2.1.214] at org.h2.index.IndexCursor.prepare(IndexCursor.java:107) ~[h2-2.1.214.jar:2.1.214] at org.h2.index.IndexCursor.find(IndexCursor.java:153) ~[h2-2.1.214.jar:2.1.214] at org.h2.table.TableFilter.next(TableFilter.java:394) ~[h2-2.1.214.jar:2.1.214] at org.h2.table.TableFilter.next(TableFilter.java:464) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1832) ~[h2-2.1.214.jar:2.1.214] at org.h2.result.LazyResult.hasNext(LazyResult.java:78) ~[h2-2.1.214.jar:2.1.214] at org.h2.result.FetchedResult.next(FetchedResult.java:34) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Select.queryFlat(Select.java:728) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Select.queryWithoutCache(Select.java:833) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Query.queryWithoutCacheLazyCheck(Query.java:197) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Query.query(Query.java:512) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.query.Query.query(Query.java:475) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.CommandContainer.query(CommandContainer.java:251) ~[h2-2.1.214.jar:2.1.214] at org.h2.command.Command.executeQuery(Command.java:190) ~[h2-2.1.214.jar:2.1.214] at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:248) ~[h2-2.1.214.jar:2.1.214] at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:219) ~[jooq-3.16.9.jar:?] at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4356) ~[jooq-3.16.9.jar:?] at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:230) ~[jooq-3.16.9.jar:?] at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:340) ~[jooq-3.16.9.jar:?] ... 11 more INFO 2023-05-23T07:08:03,512 (com.serotonin.m2m2.Lifecycle.terminate:366) - Mango Lifecycle terminating... INFO 2023-05-23T07:08:03,526 (com.infiniteautomation.nosql.MangoNoSqlPointValueDaoDefinition.postRuntimeManagerTerminate:117) - Terminating NoSQL Batch Write Manager. INFO 2023-05-23T07:08:03,526 (com.infiniteautomation.nosql.MangoNoSqlBatchWriteBehindManager.terminate:204) - Terminating NoSQL Point Value Mover. INFO 2023-05-23T07:08:03,526 (com.infiniteautomation.nosql.MangoNoSqlBatchWriteBehindManager.terminate:228) - Terminating NoSQL Stale Point Cleaner. INFO 2023-05-23T07:08:03,526 (com.infiniteautomation.nosql.MangoNoSqlBatchWriteBehindManager.terminate:231) - Terminating NoSQL Status Provider. INFO 2023-05-23T07:08:03,526 (com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl.joinTermination:452) - All low priority tasks exited gracefully. INFO 2023-05-23T07:08:03,526 (com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl.joinTermination:459) - All medium priority tasks exited gracefully. INFO 2023-05-23T07:08:03,526 (com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl.joinTermination:466) - All high priority tasks exited gracefully. INFO 2023-05-23T07:08:03,526 (com.infiniteautomation.nosql.MangoNoSqlPointValueDaoDefinition.shutdown:136) - Closing NoSQL Database: Point Values INFO 2023-05-23T07:08:03,526 (com.infiniteautomation.nosql.MangoNoSqlPointValueDaoDefinition.shutdown:144) - Closing NoSQL Database: Point Data INFO 2023-05-23T07:08:03,526 (com.infiniteautomation.mango.spring.components.executors.MangoExecutors.destroy:90) - Shutting down shared executor and scheduled executor INFO 2023-05-23T07:08:03,526 (com.infiniteautomation.mango.spring.components.executors.MangoExecutors.awaitTermination:147) - Executors shutdown successfully INFO 2023-05-23T07:08:03,526 (com.serotonin.m2m2.db.H2Proxy.terminateImpl:408) - Terminating database. INFO 2023-05-23T07:08:03,730 (com.serotonin.m2m2.Lifecycle.terminate:505) - Mango Lifecycle terminated: INITIALIZATION_ERROR
Any idea to fix?
-
RE: Java problem may crash my instance
@MattFox said in Java problem may crash my instance:
@tungthanh500 stick to adopt11, it's fast and works
Fox
Thank you for your advice. How are you doing?
@terrypacker said in Java problem may crash my instance:
I have seen situations where our monitoring library can't handle the hardware it is running on. You can disable this using the mango property:
# enables getting operating system, process, and hardware information via the OSHI native library internal.monitor.enableOperatingSystemInfo=true
Thank you, I will try to add that.
-
Java problem may crash my instance
Hi guys, I found these WARN in ma.log that increase size of ma.log up to 100 MB/file/day. I tried upgrade to AdoptOpenJDK 20 (latest) and the problem is still there. Any idea?
My mango instance is 4.5.0 (latest) on Windows 11WARN 2023-04-27T23:16:40,322 (com.infiniteautomation.mango.spring.components.ServerMonitoringService.doPoll:321) - Failed to poll monitor internal.monitor.LOAD_AVERAGE java.lang.IllegalStateException: Unmapped relationship: 7 at com.sun.jna.platform.win32.WinNT$SYSTEM_LOGICAL_PROCESSOR_INFORMATION_EX.fromPointer(WinNT.java:3033) ~[jna-platform-5.6.0.jar:5.6.0 (b0)] at com.sun.jna.platform.win32.Kernel32Util.getLogicalProcessorInformationEx(Kernel32Util.java:715) ~[jna-platform-5.6.0.jar:5.6.0 (b0)] at oshi.driver.windows.LogicalProcessorInformation.getLogicalProcessorInformationEx(LogicalProcessorInformation.java:61) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.platform.windows.WindowsCentralProcessor.initProcessorCounts(WindowsCentralProcessor.java:155) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.common.AbstractCentralProcessor.<init>(AbstractCentralProcessor.java:74) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.platform.windows.WindowsCentralProcessor.<init>(WindowsCentralProcessor.java:66) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.platform.windows.WindowsHardwareAbstractionLayer.createProcessor(WindowsHardwareAbstractionLayer.java:60) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.util.Memoizer$1.get(Memoizer.java:87) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.common.AbstractHardwareAbstractionLayer.getProcessor(AbstractHardwareAbstractionLayer.java:68) ~[oshi-core-5.4.1.jar:5.4.1] at com.infiniteautomation.mango.spring.service.ServerInformationService.getProcessor(ServerInformationService.java:96) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.service.ServerInformationService.systemLoadAverage(ServerInformationService.java:181) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.components.ServerMonitoringService.lambda$new$0(ServerMonitoringService.java:197) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.monitor.PollableMonitorImpl.poll(PollableMonitorImpl.java:56) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.components.ServerMonitoringService.doPoll(ServerMonitoringService.java:318) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.components.PollingService.tryPoll(PollingService.java:30) ~[mango-4.5.0.jar:?] at org.springframework.security.concurrent.DelegatingSecurityContextRunnable.run(DelegatingSecurityContextRunnable.java:82) ~[spring-security-core-5.4.2.jar:5.4.2] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?] at java.lang.Thread.run(Thread.java:1623) [?:?] WARN 2023-04-27T23:16:40,323 (com.infiniteautomation.mango.spring.components.ServerMonitoringService.doPoll:321) - Failed to poll monitor java.lang.Runtime.availableProcessors java.lang.IllegalStateException: Unmapped relationship: 7 at com.sun.jna.platform.win32.WinNT$SYSTEM_LOGICAL_PROCESSOR_INFORMATION_EX.fromPointer(WinNT.java:3033) ~[jna-platform-5.6.0.jar:5.6.0 (b0)] at com.sun.jna.platform.win32.Kernel32Util.getLogicalProcessorInformationEx(Kernel32Util.java:715) ~[jna-platform-5.6.0.jar:5.6.0 (b0)] at oshi.driver.windows.LogicalProcessorInformation.getLogicalProcessorInformationEx(LogicalProcessorInformation.java:61) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.platform.windows.WindowsCentralProcessor.initProcessorCounts(WindowsCentralProcessor.java:155) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.common.AbstractCentralProcessor.<init>(AbstractCentralProcessor.java:74) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.platform.windows.WindowsCentralProcessor.<init>(WindowsCentralProcessor.java:66) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.platform.windows.WindowsHardwareAbstractionLayer.createProcessor(WindowsHardwareAbstractionLayer.java:60) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.util.Memoizer$1.get(Memoizer.java:87) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.common.AbstractHardwareAbstractionLayer.getProcessor(AbstractHardwareAbstractionLayer.java:68) ~[oshi-core-5.4.1.jar:5.4.1] at com.infiniteautomation.mango.spring.service.ServerInformationService.getProcessor(ServerInformationService.java:96) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.service.ServerInformationService.availableProcessors(ServerInformationService.java:226) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.components.ServerMonitoringService.lambda$new$11(ServerMonitoringService.java:225) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.monitor.MonitoredValues$ValueMonitorBuilder.lambda$buildPollable$0(MonitoredValues.java:147) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.monitor.PollableMonitorImpl.poll(PollableMonitorImpl.java:56) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.components.ServerMonitoringService.doPoll(ServerMonitoringService.java:318) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.components.PollingService.tryPoll(PollingService.java:30) ~[mango-4.5.0.jar:?] at org.springframework.security.concurrent.DelegatingSecurityContextRunnable.run(DelegatingSecurityContextRunnable.java:82) ~[spring-security-core-5.4.2.jar:5.4.2] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?] at java.lang.Thread.run(Thread.java:1623) [?:?] WARN 2023-04-27T23:16:40,323 (com.infiniteautomation.mango.spring.components.ServerMonitoringService.doPoll:321) - Failed to poll monitor os.cpu_load.system java.lang.IllegalStateException: Unmapped relationship: 7 at com.sun.jna.platform.win32.WinNT$SYSTEM_LOGICAL_PROCESSOR_INFORMATION_EX.fromPointer(WinNT.java:3033) ~[jna-platform-5.6.0.jar:5.6.0 (b0)] at com.sun.jna.platform.win32.Kernel32Util.getLogicalProcessorInformationEx(Kernel32Util.java:715) ~[jna-platform-5.6.0.jar:5.6.0 (b0)] at oshi.driver.windows.LogicalProcessorInformation.getLogicalProcessorInformationEx(LogicalProcessorInformation.java:61) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.platform.windows.WindowsCentralProcessor.initProcessorCounts(WindowsCentralProcessor.java:155) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.common.AbstractCentralProcessor.<init>(AbstractCentralProcessor.java:74) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.platform.windows.WindowsCentralProcessor.<init>(WindowsCentralProcessor.java:66) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.platform.windows.WindowsHardwareAbstractionLayer.createProcessor(WindowsHardwareAbstractionLayer.java:60) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.util.Memoizer$1.get(Memoizer.java:87) ~[oshi-core-5.4.1.jar:5.4.1] at oshi.hardware.common.AbstractHardwareAbstractionLayer.getProcessor(AbstractHardwareAbstractionLayer.java:68) ~[oshi-core-5.4.1.jar:5.4.1] at com.infiniteautomation.mango.spring.service.ServerInformationService.getProcessor(ServerInformationService.java:96) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.service.ServerInformationService.systemCpuLoadPercent(ServerInformationService.java:202) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.monitor.PollableMonitorImpl.poll(PollableMonitorImpl.java:56) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.components.ServerMonitoringService.doPoll(ServerMonitoringService.java:318) ~[mango-4.5.0.jar:?] at com.infiniteautomation.mango.spring.components.PollingService.tryPoll(PollingService.java:30) ~[mango-4.5.0.jar:?] at org.springframework.security.concurrent.DelegatingSecurityContextRunnable.run(DelegatingSecurityContextRunnable.java:82) ~[spring-security-core-5.4.2.jar:5.4.2] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?] at java.lang.Thread.run(Thread.java:1623) [?:?]
-
RE: MQTT datapoint parsing help.
@rob987 Hi, have you find solution for you JSON timestamp?
-
RE: Help with ideas for how to guide
I also agree with @tomatopi . I also want to share my experience:
1/ Installation: the instruction for installation for windows and Linux are OK, but I think there are some updates should be added:
Document related to mango.properties to replace the old one from v3. This file in windows installation provide more information than the file in Linux. We should provide some instruction to change some usually changed setting.
Some warning about place to install. In the past, I installed mango in C:\Program File and Mango Service doesn't work at all. Take me a while to bring it to C:\ directory.
More detail on installation with MySQL. I'm sorry I still cannot install Mango using MySQL database on Linux or Windows (I only tried with free edition so I'm not sure if it is the reason). I know a step by step instruction outside of the software is not your scope of work but it is really helpful for beginner.
2/ Dashboard development:
More example on doing things with dashboard is welcomed. I tried to display many data points on a dashboard and it crashed MangoAPI. Thanks to @MattFox for instruct me the past using Javascript, watchlist to reduce workload of the dashboard. It helps my cousin past his study.
Provide some more detail example would be better. I test MQTT and want to use JSON with timestamp, when I was asked to input pointer for timestamp, it gets me to another website. An example should be a great help. I also remember people in forum take really some time to find out how to setup MQTT. -
RE: Mango Dashboard Transfer/Export To Another Server.
Hi @CraigWeb, as I pointed out earlier, the format for JSON doesn't support Vietnamese characters so my JSON configuration backup cannot be restore. Is there any way to format the JSON to UTF-8?
-
RE: Mango Dashboard Transfer/Export To Another Server.
@SkyeControls Have you tried backup and restore on new Server? I do not recommend backup the configuration only because you face some problem with the Configuration file encode (not UTF-8) if the data point/data source use language not supported by ANSI format.
-
RE: Using Serial Data Source as MBUS device
@Turbo you arr right, I bought a converter at $500 in my country just for 4 water meter
-
RE: Issues with Dashboard PointValue Colors
@mihairosu You can try copy the Markup content here