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.

@Jdiaz-co said in Timeout to lock table systemsettings:

hello good,

I'm having a problem. I'm using Mango 3.7.7 and the application crashes every so often.

The error I'm getting is this:

ERROR 2025-10-27T08:26:50,187 (com.serotonin.m2m2.util.timeout.TimeoutTask.run:61) - Uncaught Task Exception
org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [select settingValue from systemSettings where settingName=?]; Tiempo vencido intentando trabar (lock) la tabla "SYSTEMSETTINGS"
Timeout trying to lock table "SYSTEMSETTINGS"; SQL statement:
select settingValue from systemSettings where settingName=? [50200-199]; nested exception is org.h2.jdbc.JdbcSQLTimeoutException: Tiempo vencido intentando trabar (lock) la tabla "SYSTEMSETTINGS"

I would appreciate any help.

thank you

Hello,

This error comes from the embedded H2 database: something is holding a lock on the SYSTEMSETTINGS table too long, so reads (like select settingValue from systemSettings…) time out and throw CannotAcquireLockException.

Common causes:

• Another process/tool (H2 console, external SQL client) connected to the same H2 DB while Mango is running.

• Long-running DB operations (backups, purges, heavy writes) that keep the table locked.

• Short default H2 LOCK_TIMEOUT (1s) causing normal contention to show up as errors.

Things to try:

• Make sure only Mango is connected to the H2 DB (no external tools while it’s running).

• Increase H2 lock timeout in env.properties/mango.properties, e.g.
  db.url=jdbc:h2:${ma.home}/databases/mah2;LOCK_TIMEOUT=10000

• Check logs around the crash time for other FATAL/DB errors that might be the real shutdown cause.

If this is a production system (not just a test setup), I strongly recommend:

• Migrating from H2 to MySQL (more robust under load and concurrency).

• Upgrading Mango to a more recent supported version if possible, to benefit from DB and stability fixes.

v5 Release Notes Overview

Mango 5.5.4 Release Notes (09/25/25)

access-control

• Live only cameras can now be accessed on-demand when motion detection is disabled.
• Added an option to limit the number of active camera readers simultaneously.
• Fixed reader and recorder timing, corrected camera view FPS, resolved reconnection issues, and improved livestream stability to prevent lag and frame loss.
• Live only camera readers prioritize UDP connections for better performance, automatically falling back to TCP if UDP is unavailable.
• Migrate to JavaCV-based video processing pipeline.
• VideoTransformer can be used with FFmpeg or JavaCV implementations.
• Bundles required native dependencies (OpenCV 4.9 / FFmpeg 6.1.1 via bytedeco) for simpler setup.

bacnet-ds

• The BACnet data source now uses the shared local device to emit an IAm message on initialization and listens for IAm messages from other devices to track certain properties.
• Previously, each data source performed these functions independently, resulting in unnecessary messaging.
• When a request for data to a device times out, only the polled points at that device are marked as unreliable.
• Previously, all polled points in the data source were marked unreliable, even if other devices were responsive.

radix-tsl

• Fixed an issue where Mango failed to start up when the TLS module was enabled.

@mihairosu - **Update ** Mango 5.5.3 has been released to the Mango Store yesterday on September 9, 2025.

v5.5.3 - Mango Store Download

v5.5.3 - Release Notes

@mihairosu said in Update core 5.4.1 core 5.5.2 failed:

mihairosu
2 days ago

I tried to update Core and all modules from 5.4.1 to 5.5.2 and now Mango won't start up. I don't have permissions

See link to ma.log file.

Hi @mihairosu,

Thanks for sharing the details and sorry to hear about the trouble after upgrading to 5.5.2.

This issue is related to a known bug that was introduced in Mango version 5.5.0 and will be resolved in the upcoming 5.5.3 release.

In the meantime, a workaround is available:

You can manually change the system setting for the alarm level of the system event MAX_ALARM_LEVEL_CHANGED directly in the database while Mango is offline. Here's the SQL command:

UPDATE PUBLIC.SYSTEMSETTINGS t
SET t.SETTINGVALUE = '0'
WHERE t.SETTINGNAME = 'systemEventAlarmLevel.MAX_ALARM_LEVEL_CHANGED';

This should help bypass the startup issue you're encountering. Once Mango is back online, you can verify the change and proceed with your upgrade path or if your not comfortable making this change wait for the Mango v5.5.3 release.

Let us know if you any further questions or if anything else comes up!

@SGAF Hello, you should be able to export the Meta Data Source and its points directly from the Data Source. Alternatively, you can use the Configuration Import/Export tool to export all data sources and/or data points and then make your edits. Please note that if you remove the XIDs from the Data Points and substitute the XID of the Data Source on the other system, new data points created during the import to the other system will be assigned new XIDs. As you mentioned, context points will need to be mapped. Thank you.

Hello @jcaballeroa, sorry for the delay on this topic but could you please open a support request at Radix IoT - Support? I would like to better assist on this topic but access to the files have expired. Also, have you tried to start a clean Mango v5 to see if you have any issue starting up Mango before upgrading?

@jcaballeroa You mentioned that you are testing Mango 5 in free mode. Could you please tell me how many data points you are using, and send the complete ma.log file again?

Additionally, assuming the server writes logs to /var/log/syslog, you might find more log entries related to Mango’s issues there. I often find the information I need in the syslog when Mango fails to start up correctly.

Thank you.

@jcaballeroa It appears the issue is related to this property:

pki.monitor.expiringSoonThreshold=25%

The problem may stem from unusual locale settings on your computer that do not properly recognize the percentage symbol (%). To address this, follow these steps in order:

Step 1: Modify the property

1. Edit the configuration file containing pki.monitor.expiringSoonThreshold=25%. Change this setting to the decimal format (0.25) instead of using a percentage, pki.monitor.expiringSoonThreshold=0.25.

2. Restart the Mango service to apply the new settings.

If the issue persists, proceed with Step 2:

Step 2: Check your locale settings

1. Ensure your system uses a standard locale, such as en_US, where the percentage symbol (%) is recognized correctly. Adjust your locale settings if necessary.

2. Restart the Mango service again to apply these changes.

Please implement these steps and let us know on the forum whether this resolves the issue. Your feedback is invaluable and can assist others experiencing similar issues.

Hello @jcaballeroa, I'm sorry to hear you're experiencing issues. To better understand the problem, I will need you to provide more details.

• Which Mango version are you using in v3, v3.7.12?
• Did this error start after upgrading to v5.2.1, or did you start with a clean install and your overrides added?
• Please share your SSL properties settings (those you feel comfortable sharing).
• Also, can you confirm that you are running Java 17 for the v5 Mango?

Sharing your ma.log file would greatly help in diagnosing the issue. Thank you.

BR,

Joe Miraglia
SAE/Radix IoT

Hello @vishalcapri,

Thanks for letting us know. We will have those updated.

Best regards,

Joe Miraglia
SAE
Radix IoT

Hello @hayden_AUS,

These are all default values, so it is intentional that they are all commented out. This allows users to see the current settings and make changes if necessary by removing the hashtag and adjusting the settings accordingly for their system.

Best regards,

Joe Miraglia
SAE Radix IoT

Hello,

Yes, the NoSQL license (General license not the Enterprise license) would be required to eliminate the restarts. In the ma.log file, when Mango starts, it mentions that it is running NoSQL in free mode and that it will restart in 8 hours. The documentation to convert an H2 database to MySQL is found here: Database Conversions. If you need further assistance, please let us know. Thanks!

Joe Miraglia
Service Application Engineer
Radix IoT

@ryanlo To answer your initial question, the default login is still admin : admin. The easiest way to do a reset would be to stop Mango, move the database (move it to root ~/) from the /opt/mango/databases/ directory (from directory use, mv mah2.200.* ~/ command), then restart Mango. Similar direction could be found on our document site, you will not need to do the restore since this is a new unit. Thank you!

@ryanlo This can happen if your browser has a cached version of the page. Try opening the page in incognito or private mode to see if that resolves the issue.

@tomatopi We are still working on documentation. I know it has been a very slow process but we are adding what we can to the doc sites (v4 and v5) as well as adding scripts to our script-examples in GitHub.

@tomatopi Would this work for you?

https://www.amcharts.com/demos-v3/bullet-chart-v3/

@mihairosu If you remove the password or change it you will no longer be able to use the auto login feature on the kiosks unless you match the password again.

@mihairosu I was able to duplicate the issue.

• I created a basic user (Guest) with no associated roles as user (Admin)
• In Administration > UI Settings > Set Auto login for all clients for user (Guest)
• Signed out of user (Admin)
• Now as user (Guest) could not sign out of user (Guest) or sign in as user (Admin) and see same 401 warning in logs as you have shown.

The work around was to change the user (Guest) password so auto login would not work. At this point I was able to sign in as whichever user I needed.

I will have to discuss with our development team about the issue. Thank you for finding this.

@mihairosu Could you get logs where this was occuring? It's hard to point out what the issue is without the ability to reproduce it.

@tungthanh500 That screen shot was from the Mango Store, if you login and look at your license it will either say unrestricted or standalone next to excelReports. If it's standalone you only could use 1 template which is what I think your issue is.