Hello, ever since the development of Mango 5, I realise that the Help menu is much more inconvenience. As a amateur and not frequent developer, I take a lot of time to use the Help menu and change from this Help to another (for example MaPointValue, MaGetPointValue...). But after Mango 5, I have to click on the Help -> API document -> choose another API. Can you provide a more convenient menu similar to V4?

More over, I realise the Example is no longer available for many APIs. I am using 5.2 right now in free edition.

@dovydasz said in Pi Portfolio creating:

I still can't get it working.. Could you please share some screenshots how you configured it? Do I need to you some specific values for datapoints tags keys?

Give me Direct message, your whatapps number. I will give you a hand in Monday. I have vacation tomorrow. But can you try this:
Provide your data points 3 important tags, which are deviceType, site, deviceID

This information is not emphasized in Radix instruction and you may miss this part.

Hello guys, I have a system and I want to control a data point with condition.
I have following data point, polled through modbus TCP every 15 seconds:

• Grid THDi L1, L2 and L3
• Compensation Ratio
• THDi setpoint (I set as 10)

I want to make a Meta Data Point with following code:

maxTHDI = Math.max(thdi_l1.value, thdi_l2.value, thdi_l3.value);

if (maxTHDI < (setpoint.value - 1)) {
    comp_ratio.set(comp_ratio.value - 0.01);
} else if (maxTHDI > setpoint.value) {
    if (comp_ratio >0.95) {
        comp_ratio.set(1)}
    else {
        comp_ratio.set (comp_ratio.value + 0.05);
}
}

RuntimeManager.sleep(15000);

My intention is:

• If the value of maxTHDi is lower than 9, then i lower the value of comp_ratio by 0.01.
• if the value of maxTHDi is above 10 then if comp_ratio > 0.95 then comp_ratio = 1 and if comp_ratio is lower 0.95, i will increase comp_ratio by 0.05.

I want to make this meta point run every 15 second, together with the polling of Modbus data point. However, every time I enable this meta point this kind of error appear in the logs and repeat lots of times:

INFO  2024-07-19T19:32:26,312 (com.serotonin.m2m2.rt.RuntimeManagerImpl.startDataSource:346) - Data source (name=Setpoint Controller, id=13, type=MetaDataSourceRT) took 12ms to start
WARN  2024-07-19T19:34:54,511 (com.infiniteautomation.mango.rest.latest.websocket.pointValue.PointValueWebSocketHandler$PointValueWebSocketListener.pointUpdated:253) - Error sending websocket message
com.infiniteautomation.mango.rest.latest.websocket.WebSocketClosedException: Websocket closed
	at com.infiniteautomation.mango.rest.latest.websocket.MangoWebSocketHandler.sendStringMessageAsync(MangoWebSocketHandler.java:121) ~[?:?]
	at com.infiniteautomation.mango.rest.latest.websocket.MangoWebSocketHandler.sendMessage(MangoWebSocketHandler.java:96) ~[?:?]
	at com.infiniteautomation.mango.rest.latest.websocket.pointValue.PointValueWebSocketHandler.sendMessage(PointValueWebSocketHandler.java:154) ~[?:?]
	at com.infiniteautomation.mango.rest.latest.websocket.pointValue.PointValueWebSocketHandler$PointValueWebSocketListener.sendNotification(PointValueWebSocketHandler.java:200) ~[?:?]
	at com.infiniteautomation.mango.rest.latest.websocket.pointValue.PointValueWebSocketHandler$PointValueWebSocketListener.pointUpdated(PointValueWebSocketHandler.java:250) ~[?:?]
	at com.serotonin.m2m2.rt.DataPointEventNotifyWorkItem.execute(DataPointEventNotifyWorkItem.java:64) ~[mango-5.1.4.jar:?]
	at com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl$RejectableWorkItemRunnable.run(BackgroundProcessingImpl.java:531) ~[mango-5.1.4.jar:?]
	at com.serotonin.timer.Task.runTask(Task.java:176) ~[mango-5.1.4.jar:?]
	at com.serotonin.timer.TaskWrapper.run(TaskWrapper.java:22) ~[mango-5.1.4.jar:?]
	at com.serotonin.timer.OrderedThreadPoolExecutor$OrderedTaskCollection.run(OrderedThreadPoolExecutor.java:268) ~[mango-5.1.4.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
	at java.lang.Thread.run(Thread.java:840) [?:?]
WARN  2024-07-19T19:34:54,511 (com.infiniteautomation.mango.rest.latest.websocket.pointValue.PointValueWebSocketHandler$PointValueWebSocketListener.pointUpdated:253) - Error sending websocket message
com.infiniteautomation.mango.rest.latest.websocket.WebSocketClosedException: Websocket closed
	at com.infiniteautomation.mango.rest.latest.websocket.MangoWebSocketHandler.sendStringMessageAsync(MangoWebSocketHandler.java:121) ~[?:?]
	at com.infiniteautomation.mango.rest.latest.websocket.MangoWebSocketHandler.sendMessage(MangoWebSocketHandler.java:96) ~[?:?]
	at com.infiniteautomation.mango.rest.latest.websocket.pointValue.PointValueWebSocketHandler.sendMessage(PointValueWebSocketHandler.java:154) ~[?:?]
	at com.infiniteautomation.mango.rest.latest.websocket.pointValue.PointValueWebSocketHandler$PointValueWebSocketListener.sendNotification(PointValueWebSocketHandler.java:200) ~[?:?]
	at com.infiniteautomation.mango.rest.latest.websocket.pointValue.PointValueWebSocketHandler$PointValueWebSocketListener.pointUpdated(PointValueWebSocketHandler.java:250) ~[?:?]
	at com.serotonin.m2m2.rt.DataPointEventNotifyWorkItem.execute(DataPointEventNotifyWorkItem.java:64) ~[mango-5.1.4.jar:?]
	at com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl$RejectableWorkItemRunnable.run(BackgroundProcessingImpl.java:531) ~[mango-5.1.4.jar:?]
	at com.serotonin.timer.Task.runTask(Task.java:176) ~[mango-5.1.4.jar:?]
	at com.serotonin.timer.TaskWrapper.run(TaskWrapper.java:22) ~[mango-5.1.4.jar:?]
	at com.serotonin.timer.OrderedThreadPoolExecutor$OrderedTaskCollection.run(OrderedThreadPoolExecutor.java:268) ~[mango-5.1.4.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
	at java.lang.Thread.run(Thread.java:840) [?:?]

Please suggest me some workaround.
Thank you

Update: I can do it. The most important content of the instruction is: "The data will be classified by Site, Device Type, and Device IDs which are the main tags that need to be configured in the data points to allow this module to show accurate data."

This should be highlighted, in bold because it is in the introduction and non-English speaker like me always miss it!

Hello, I'm trying to configure my system to use new Po Portfolio and to be honest it is not easy to follow the instruction.
I finished setting up the Device types but I am facing difficulty to connect the Device in Site configuration.
When I add a new Device in Devices Tab, how to make a connection between a Device name in Data Source with below configuration (Export ID, Device ID, Name)?
Please check these screenshots: https://imgur.com/a/RlZIJDr
1st is where I need to Add device to a site
2nd is my Data Source
3rd is my Device Name

@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 :"<

@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

@Benoit Totally agree with Matt. You should use tags more for easy filtering. It may takes some time but you can optimise your code

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.

@mumcs01 is there any place where we can give our feedback?

@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

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.

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

@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.

@CraigWeb Is the mah2 DB at C:\mango_data\databases?

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?

@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.

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 11

WARN  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) [?:?]

@rob987 Hi, have you find solution for you JSON timestamp?

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.