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.

@Bård-Lind you are binding to a specific IP, you won't receive broadcasts if you are running this on Linux. You need to bind to the local address of 0.0.0.0 to get the messages from the initial WhoIs during initialization. Hopefully this helps you out, it could be many things but this is a common one when getting started with BACnet over IP.

Hi @AllanBeahan @CraigWeb. Would you please share the advice on how to address this issue? I have the same problem with a Mango HTS mango hts-v1-nise-105. Thank you.

Yes they should. Every BACnetObject has the ability to support COV. You will need to enable the mixin though. I've not actually implemented a server but these classes should get you going on how to use it: com.serotonin.bacnet4j.obj.AnalogObjectTest com.serotonin.bacnet4j.obj.mixin.CovReportingMixin

I use Mango version 4.5

You might want to use a data file as a data source because it’s easy to manage, but if no data displays, there could be an issue with the file format or connection. For reliable data backup and recovery solutions, consider HostNoc to ensure your data stays safe and accessible. The keyword is data backup and recovery.

@joeamiraglia Is there a procedure or guidance on how to do this? I tried and it gave me an error when trying to upload the exported meta data source.

@LBryant are you using the H2 database or MySQL? One is harder than the other, if mysql, stop mango, make a fresh mango database setting then copy the password from the user generated in the new db and overwrite the password on your user in the original, that will set it to admin. Change back to your old db settings and log in. If H2, stop mango, rename database folder and restart, this will cause mango to generate a new h2 db. Stop mango and use the h2 web utility supplied in the mango/bin directory to access the new database, obtain the password from the admin user. Close then repeat with the old database and update the password. Rename database folder and restore the original folder back to database again. Log in with admin password Fox

@MattFox Thanks! Looks comprehensive. I will work thru the example. Greatly Appreciated!!!

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