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.
Server Time out
-
Hello Phil I tried all the things except the sql backup and restore thing because when I logged in mysql there was no sql database.So what can I do in this situation?
-
Did you get Mango restarted? It's all from the memory error. With SQL the database expansion can be managed just by keeping the tables mentioned in check (which you could do at the command line). It's not necessary to do a dump/restore - I assumed you were using the H2 database.
-
Yes I restarted the mango but it is same issue.I think there is something wrong with database. Beacuse when I removed the database file and started mango again it was working fine and it also created new h2database file.
-
It would not switch database types....
Do you have a Mango/databases/mah2.h2.db file and how big is it?
If you are using H2 then the MySQL command line program won't be of use to us.
-
It's size is 1.58Gb
-
You can use the /system_settings.shtm page to create a SQL backup (SQL Backup section), then stop Mango, move the existing database so that Mango starts on a new database, start Mango, and then restore the SQL backup in the same section on the /system_settings.shtm page. There's other information here: https://forum.infiniteautomation.com/topic/2748/how-to-restore-a-database-backup Having a smaller H2 database may help some, generally.
Yes I restarted the mango but it is same issue.
Which issue? The memory is instantly running out or there is a bind exception because something is already running on the port you are trying to launch Mango on?
-
memory is running out .
org.h2.jdbc.JdbcSQLException: Out of memory. [90108-181] -
You can
- Use Mango/bin/h2-web-console script (bat or sh) to connect to the H2 database without running Mango. This would allow you to delete from the events, userEvents, audit, or pointValues tables. I would guess you need to purge events and userEvents at the very least, like
DELETE FROM events; DELETE FROM userEvents;Mango needs to be stopped. - Start in SAFE mode. This will start will all data sources disabled, if for some reason they're the source of the memory loss.
- Start on a clean database and restore an existing backup using the SQL backup configuration section of the /system_settings.shtm page.
- Ensure a proper amount of memory has been allocated to Mango in a Mango/bin/ext-enabled script.
- Use Mango/bin/h2-web-console script (bat or sh) to connect to the H2 database without running Mango. This would allow you to delete from the events, userEvents, audit, or pointValues tables. I would guess you need to purge events and userEvents at the very least, like
-
I tried connecting to h2 databse via console after stopping mango.i got this error.
"IO Exception: "C:/Users/DCU/test outside C:/Mango" [90028-181] 90028/90028 (Help)
org.h2.jdbc.JdbcSQLException: IO Exception: "C:/Users/DCU/test outside C:/Mango" [90028-181]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.engine.ConnectionInfo.setBaseDir(ConnectionInfo.java:182)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:104)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at org.h2.server.web.WebServer.getConnection(WebServer.java:750)
at org.h2.server.web.WebApp.login(WebApp.java:957)
at org.h2.server.web.WebApp.process(WebApp.java:211)
at org.h2.server.web.WebApp.processRequest(WebApp.java:170)
at org.h2.server.web.WebThread.process(WebThread.java:137)
at org.h2.server.web.WebThread.run(WebThread.java:93)
at java.lang.Thread.run(Unknown Source) " -
C:/Users/DCU/test outside C:/MangoThe webserver cannot try to open a database URL outside its Mango directory. You're probably looking for a URL of
jdbc:h2:C:/Mango/databases/mah2
