cannot load database
-
/opt/mango/bin/ma.sh start
MA_HOME is /opt/mango
ma-start: MA started with Process ID: 28182
INFO 2019-08-22 23:28:07,482 (com.serotonin.m2m2.Main.main:82) - Starting Mango 2.8.8 with Schema Version: 13
WARN 2019-08-22 23:28:07,677 (com.serotonin.m2m2.Main.loadModules:356) - Module loggingConsole: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,679 (com.serotonin.m2m2.Main.loadModules:356) - Module openv4j: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,682 (com.serotonin.m2m2.Main.loadModules:356) - Module pointLinks: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,684 (com.serotonin.m2m2.Main.loadModules:356) - Module persistent: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,687 (com.serotonin.m2m2.Main.loadModules:356) - Module http: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,690 (com.serotonin.m2m2.Main.loadModules:356) - Module meta: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,692 (com.serotonin.m2m2.Main.loadModules:356) - Module templateConfig: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,693 (com.serotonin.m2m2.Main.loadModules:356) - Module virtualDS: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,694 (com.serotonin.m2m2.Main.loadModules:356) - Module onewire: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,696 (com.serotonin.m2m2.Main.loadModules:356) - Module scheduledEvents: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,697 (com.serotonin.m2m2.Main.loadModules:356) - Module dashboards: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,698 (com.serotonin.m2m2.Main.loadModules:356) - Module mangoNoSqlDatabase: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,700 (com.serotonin.m2m2.Main.loadModules:356) - Module scripting: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,701 (com.serotonin.m2m2.Main.loadModules:356) - Module sstTheme: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,703 (com.serotonin.m2m2.Main.loadModules:356) - Module twilio: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,712 (com.serotonin.m2m2.Main.loadModules:356) - Module log4JReset: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,714 (com.serotonin.m2m2.Main.loadModules:356) - Module mangoApi: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,715 (com.serotonin.m2m2.Main.loadModules:356) - Module mbus: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,716 (com.serotonin.m2m2.Main.loadModules:356) - Module jspViews: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,718 (com.serotonin.m2m2.Main.loadModules:356) - Module internal: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,719 (com.serotonin.m2m2.Main.loadModules:356) - Module jmxds: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,720 (com.serotonin.m2m2.Main.loadModules:356) - Module sqlds: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,723 (com.serotonin.m2m2.Main.loadModules:356) - Module pop3: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,724 (com.serotonin.m2m2.Main.loadModules:356) - Module sstGlobalScripts: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,726 (com.serotonin.m2m2.Main.loadModules:356) - Module bonjourBroadcaster: this module requires a core version of 2.4, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,728 (com.serotonin.m2m2.Main.loadModules:356) - Module modbus: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,729 (com.serotonin.m2m2.Main.loadModules:356) - Module serial: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,730 (com.serotonin.m2m2.Main.loadModules:356) - Module opcda: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,732 (com.serotonin.m2m2.Main.loadModules:356) - Module graphicalViews: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,733 (com.serotonin.m2m2.Main.loadModules:356) - Module dataFile: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,742 (com.serotonin.m2m2.Main.loadModules:356) - Module dglux: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,744 (com.serotonin.m2m2.Main.loadModules:356) - Module dataImport: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,745 (com.serotonin.m2m2.Main.loadModules:356) - Module sstGraphics: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,747 (com.serotonin.m2m2.Main.loadModules:356) - Module snmp: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,748 (com.serotonin.m2m2.Main.loadModules:356) - Module pid: this module requires a core version of 2.4, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,750 (com.serotonin.m2m2.Main.loadModules:356) - Module reports: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,751 (com.serotonin.m2m2.Main.loadModules:356) - Module maintenanceEvents: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,753 (com.serotonin.m2m2.Main.loadModules:356) - Module galil: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,754 (com.serotonin.m2m2.Main.loadModules:356) - Module watchlists: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,756 (com.serotonin.m2m2.Main.loadModules:356) - Module sqlConsole: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,757 (com.serotonin.m2m2.Main.loadModules:356) - Module log4jDS: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,758 (com.serotonin.m2m2.Main.loadModules:356) - Module controlcore: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,760 (com.serotonin.m2m2.Main.loadModules:356) - Module BACnet: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,761 (com.serotonin.m2m2.Main.loadModules:356) - Module vmstat: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,763 (com.serotonin.m2m2.Main.loadModules:356) - Module dnp3: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,764 (com.serotonin.m2m2.Main.loadModules:356) - Module pachube: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
WARN 2019-08-22 23:28:07,765 (com.serotonin.m2m2.Main.loadModules:356) - Module asciiFile: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
INFO 2019-08-22 23:28:08,011 (com.serotonin.m2m2.Main.loadModules:416) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2019-08-22 23:28:08,091 (com.serotonin.m2m2.Main.loadModules:416) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2019-08-22 23:28:08,103 (com.serotonin.m2m2.Main.loadModules:416) - Loading module 'SystemManager', v1.0.0 by (unknown vendor)
INFO 2019-08-22 23:28:08,110 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/SystemManager/web/dox/manifest.xml
INFO 2019-08-22 23:28:08,257 (com.serotonin.m2m2.Lifecycle.initialize:216) - Initializing Spring Object Mapper
ERROR 2019-08-22 23:28:09,218 (com.serotonin.m2m2.Main.main:119) - Error during initialization
java.lang.RuntimeException: java.net.BindException: Address already in use
at com.serotonin.m2m2.Lifecycle.webServerInitialize(Lifecycle.java:810)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:223)
at com.serotonin.m2m2.Main.main(Main.java:115)
Caused by: java.net.BindException: Address already in use
at sun.nio.ch.Net.bind0(Native Method)
at sun.nio.ch.Net.bind(Net.java:414)
at sun.nio.ch.Net.bind(Net.java:406)
at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:214)
at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
at org.eclipse.jetty.server.ServerConnector.open(ServerConnector.java:321)
at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnector.java:80)
at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:236)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.eclipse.jetty.server.Server.doStart(Server.java:366)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at com.serotonin.m2m2.Lifecycle.webServerInitialize(Lifecycle.java:807)
... 2 more
INFO 2019-08-22 23:28:09,224 (com.serotonin.m2m2.Lifecycle.terminate:353) - Mango Lifecycle terminating...
ERROR 2019-08-22 23:28:09,238 (com.serotonin.m2m2.Lifecycle.terminate:425) - com.serotonin.provider.InputStreamEPollProvider
ERROR 2019-08-22 23:28:09,240 (com.serotonin.m2m2.Lifecycle.terminate:433) - com.serotonin.provider.ProcessEPollProvider
INFO 2019-08-22 23:28:09,240 (com.serotonin.m2m2.Lifecycle.terminate:453) - Mango Lifecycle terminated.
ma-start: no restart flag found, not restarting MA
ma-start: MA doneUpdated to 2.8 version. but still can't open the Mango normally. its stuck in 40% loading
-
To the stack trace involving,
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-180]
I would advise restoring a database backup. See this these resources for ways of doing that:
https://help.infiniteautomation.com/how-to-restore-a-h2-database-backup
https://forum.infiniteautomation.com/topic/2748/how-to-restore-a-database-backupTo the stack trace involving,
Caused by: java.net.BindException: Address already in use
This usually means that Mango is already running on that port, but it could also mean that another application is running and has bound that port. The solution if Mango is already running is to access the Mango that is running, and if another application has bound it you can change the port Mango binds to in the Mango/overrides/properties/env.properties file.
-
My help is for MangoES hardware. I think you are talking about Mango software running on a System
-
To add to the problems, I had installed a module MySQL Database server and now the MangoES refusing to connect through IP. any alternatives to retrirvr back the last change? i can ping, but no connection can be established through Webmin or through browser
-
Do you have a copy of your env.properties on hand?
If so can you please paste it between some code tags???
Follow Phil's instructions as above, also run mango from the bash console.Secondly Phil also added that you may have an instance of mango already running in the background.
try
pas aux | grep mango > mangoinstances.txt
Something should be outputted into that file to show something is running.
I also suggest you stop making amendments and changes to your system, it's harder to follow and diagnose if you do that.
Fox
-
Thanks Fox for responding. But now I don't have any access to the MangoES. As I said before i can ping, but can't use Webmin to get into MangoES hardware. Any alternatives to access webmin again?
Connection refused through Network
-
You mean you're unable to use putty and SSH into the unit?
Just because webmin is out, SSH should still be running...
-
Yes even putty cant get in. Connection refused
-
Assuming you're running a windows box, let's see if it's even on the network.
Get yourself angry ip scanner or similar to scan the network.
If there's nothing, I wonder if your network card gave up the ghost... -
I have the advanced IP scanner, and the MangoES is available. Only it refuses to accept any connection. Also before i could access the network foler of Mango, But now its invisible and there is nothing showing up in the network.
-
Sounds like a power cycle is in order. Give it a good ol' hard reset. It's an old unit so I wouldn't rule out hardware failing. I've had a few V2's die on me, and one of the traits they shared before dying completely was the networking part of the system calling it a day.
-
Just switching off the power for long time and switch it back on?
-
@jay1089 Yep, count to 30 then fire it back up, perhaps monitor the LED's on the case - I assume here it's similar to a V2 with an aluminium cast case with 4 LEDs on the front.
-
Yes four LED up front. One green and other blinks when network connected. Other two doesn't lit up at all
-
Good, the blinking is the heartbeat for Mango, it should be starting then. Check your network again and let's see if the SSH is available.
https://help.infiniteautomation.com/mangoes-connections?rq=v2 -
Connection refused still after power cycle. In the LAN connection, The green LEd blinks whereas the orange stays lit all the time.
-
Sounds like something is causing an issue or error of some sort, I thought you meant 2 of the four leds, not the lan socket. .
Phil are the display ports on these old boards functioning? I know I had one on the old board, but never had a chance to check myself. It's just a last ditch idea I had.
Sorry that's all I've got... -
Display port works. But the problem is it cant complete the boot. It is booting for so long
-
Somehow managed to revert back. Now webmin is working and back to the old issue. Database stuck at 40%. And in command shell, i cant execute bin/ma.sh start. it says permission denied.
-
Nice!
trysudo /opt/mango/bin/ma.sh start
Let's see what you get!