Unable to restart Cloud Mango
-
Hi there,
I recently inherited a Cloud Mango instance and caused a bit of an issue when installing some new updates (evening of August 17th). Long story short, I was able to restart the Mango but all of the previous data points and scripts were lost.
I attempted restoring the most recent H2 backup as described in https://forum.infiniteautomation.com/topic/2748/how-to-restore-a-database-backup/2
This only partially worked. Only the core module remained and none of the previous data points or sources could be seen. I may have been doing something wrong.I am now at a point where the Mango cannot restart through command line or the web interface. When restarting through the interface the following error pops up:
Server error: PreparedStatementCallback; bad SQL grammar [SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,dp.readPermission,dp.setPermission,dp.templateId,dp.rollup,dp.dataTypeId,dp.settable,ds.name,ds.xid,ds.dataSourceType,ds.editPermission,template.name,template.xid FROM dataPoints AS dp JOIN dataSources ds ON ds.id = dp.dataSourceId LEFT JOIN templates template ON template.id = dp.templateId ORDER BY dp.deviceName, dp.name OFFSET ? ROWS FETCH NEXT ? ROWS ONLY]; nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "DP.SETTABLE" not found; SQL statement: SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,dp.readPermission,dp.setPermission,dp.templateId,dp.rollup,dp.dataTypeId,dp.settable,ds.name,ds.xid,ds.dataSourceType,ds.editPermission,template.name,template.xid FROM dataPoints AS dp JOIN dataSources ds ON ds.id = dp.dataSourceId LEFT JOIN templates template ON template.id = dp.templateId ORDER BY dp.deviceName, dp.name OFFSET ? ROWS FETCH NEXT ? ROWS ONLY [42122-199]I guess my first question is the following:
How can I regain the ability to restart, stop and start the Cloud Mango? This way I can start from a blank database and login with admin/admin.Once I've got that resolved I'll want to get my backup restored :) One step at a time though.
Logs can be found here:
https://drive.google.com/open?id=1Y9h_iw6rC3LiG0nvCL8iWvDBXn049be5Thank you so much in advance!
-
Hi Envari,
Quite a few steps in the story. Working backwards, since it sounds like that's where you would be now,
I guess my first question is the following:
How can I regain the ability to restart, stop and start the Cloud Mango? This way I can start from a blank database and login with admin/admin.
Move your Mango/databases directory while Mango is off, then start Mango. In the future post relevant log info here, preferably in sections of three backtick ` marks so that it is well formatted.
The only thing you log files showed was that you didn't have any modules installed, which blew away the output from any startup attempts. Try to start Mango on the command line and share only that output should it fail to start.
Once I've got that resolved I'll want to get my backup restored :) One step at a time though.
The SQL error is because the database was probably restored through the UI instead of on the command line, and the backup comes from a prior version of Mango. For that upgrade, though, I would expect restarting Mango could have resolved that.
You can install modules from the modules page in the old UI still if the UI module is not installed. You could also download the API and UI modules directly from https://store.infiniteautomation.com , place them in the Mango/web/modules/ directory, and then you would be able to download the other modules you need from the new UI's modules page.
-
Hi @phildunlap
Thank you for your reply. I moved my databases directory and it regenerated, with only a file named "mah2.199.lock.db" being in the directory. Still no restart/start/stop from the command line (see log file below).
From the ma-script.log file. The very bottom lines of August 19th are when I've been playing around with it and the commands stopped working.
Wed Oct 4 21:35:17 UTC 2017 ma-start: starting MA Wed Oct 4 21:35:17 UTC 2017 ma-start: MA started with Process ID 18062 Wed Oct 18 14:57:14 UTC 2017 ma-start: MA removing pid file for dead pid: 18062 Wed Oct 18 14:57:14 UTC 2017 ma-start: starting MA Wed Oct 18 14:57:14 UTC 2017 ma-start: MA started with Process ID 18983 Fri Oct 20 17:00:50 UTC 2017 ma-restart: restart initiated... Fri Oct 20 17:00:54 UTC 2017 ma-start: starting MA Fri Oct 20 17:00:54 UTC 2017 ma-start: MA started with Process ID 14210 Fri Oct 20 18:51:29 UTC 2017 ma-start: upgrading core... Fri Oct 20 18:51:32 UTC 2017 ma-start: starting MA Fri Oct 20 18:51:32 UTC 2017 ma-start: MA started with Process ID 18952 Fri Oct 20 21:05:20 UTC 2017 ma-restart: restart initiated... Fri Oct 20 21:05:25 UTC 2017 ma-start: starting MA Fri Oct 20 21:05:25 UTC 2017 ma-start: MA started with Process ID 24734 Fri Oct 20 21:19:09 UTC 2017 ma-stop: stop initiated... Fri Oct 20 21:19:12 UTC 2017 ma-start: MA explicitly stopped. Exiting restart loop Fri Oct 20 21:19:12 UTC 2017 ma-start: MA done Fri Oct 20 21:20:26 UTC 2017 ma-start: starting MA Fri Oct 20 21:20:26 UTC 2017 ma-start: MA started with Process ID 1406 Sat Oct 21 04:52:44 UTC 2017 ma-stop: stop initiated... Sat Oct 21 04:52:47 UTC 2017 ma-start: MA explicitly stopped. Exiting restart loop Sat Oct 21 04:52:47 UTC 2017 ma-start: MA done Sat Oct 21 04:54:35 UTC 2017 ma-start: starting MA Sat Oct 21 04:54:35 UTC 2017 ma-start: MA started with Process ID 20640 Sat Oct 21 05:41:56 UTC 2017 ma-start: MA removing pid file for dead pid: 20640 Sat Oct 21 05:41:56 UTC 2017 ma-start: starting MA Sat Oct 21 05:41:56 UTC 2017 ma-start: MA started with Process ID 1400 Mon Oct 23 10:41:46 EDT 2017 ma-restart: restart initiated... Mon Oct 23 10:41:51 EDT 2017 ma-start: starting MA Mon Oct 23 10:41:51 EDT 2017 ma-start: MA started with Process ID 20281 Mon Oct 23 10:41:57 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:41:57 EDT 2017 ma-start: MA done Mon Oct 23 10:44:45 EDT 2017 ma-start: starting MA Mon Oct 23 10:44:45 EDT 2017 ma-start: MA started with Process ID 20343 Mon Oct 23 10:44:51 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:44:51 EDT 2017 ma-start: MA done Mon Oct 23 10:45:33 EDT 2017 ma.stop: No PID file found. Java process not stopped... Mon Oct 23 10:46:40 EDT 2017 ma-start: starting MA Mon Oct 23 10:46:40 EDT 2017 ma-start: MA started with Process ID 20402 Mon Oct 23 10:46:46 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:46:46 EDT 2017 ma-start: MA done Mon Oct 23 10:47:17 EDT 2017 ma-start: starting MA Mon Oct 23 10:47:17 EDT 2017 ma-start: MA started with Process ID 20450 Mon Oct 23 10:52:59 EDT 2017 ma-stop: stop initiated... Mon Oct 23 10:53:03 EDT 2017 ma-stop: stop initiated... Mon Oct 23 10:53:06 EDT 2017 ma-start: MA explicitly stopped. Exiting restart loop Mon Oct 23 10:53:06 EDT 2017 ma-start: MA done Mon Oct 23 10:53:50 EDT 2017 ma-start: starting MA Mon Oct 23 10:53:50 EDT 2017 ma-start: MA started with Process ID 20782 Mon Oct 23 10:53:53 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:53:53 EDT 2017 ma-start: MA done Mon Oct 23 10:54:49 EDT 2017 ma-start: starting MA Mon Oct 23 10:54:49 EDT 2017 ma-start: MA started with Process ID 20822 Mon Oct 23 10:54:52 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:54:52 EDT 2017 ma-start: MA done Mon Oct 23 10:56:42 EDT 2017 ma-start: starting MA Mon Oct 23 10:56:42 EDT 2017 ma-start: MA started with Process ID 20868 Mon Oct 23 10:56:45 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:56:45 EDT 2017 ma-start: MA done Mon Oct 23 10:58:01 EDT 2017 ma-start: starting MA Mon Oct 23 10:58:01 EDT 2017 ma-start: MA started with Process ID 20918 Mon Oct 23 10:58:04 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:58:04 EDT 2017 ma-start: MA done Mon Oct 23 10:58:18 EDT 2017 ma-start: starting MA Mon Oct 23 10:58:18 EDT 2017 ma-start: MA started with Process ID 20959 Mon Oct 23 10:58:21 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:58:21 EDT 2017 ma-start: MA done Mon Oct 23 10:59:27 EDT 2017 ma-start: starting MA Mon Oct 23 10:59:27 EDT 2017 ma-start: MA started with Process ID 21032 Mon Oct 23 10:59:30 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:59:30 EDT 2017 ma-start: MA done Mon Oct 23 10:59:53 EDT 2017 ma-start: starting MA Mon Oct 23 10:59:53 EDT 2017 ma-start: MA started with Process ID 21071 Mon Oct 23 10:59:56 EDT 2017 ma-start: no restart flag found, not restarting MA Mon Oct 23 10:59:56 EDT 2017 ma-start: MA done Mon Oct 23 11:00:37 EDT 2017 ma-start: starting MA Mon Oct 23 11:00:37 EDT 2017 ma-start: MA started with Process ID 21111 Mon Oct 23 11:03:44 EDT 2017 ma-start: MA already running with Process ID: 21111 Mon Oct 23 11:03:44 EDT 2017 ma-start: MA done Mon Oct 23 11:03:50 EDT 2017 ma-stop: stop initiated... Mon Oct 23 11:03:52 EDT 2017 ma-start: MA explicitly stopped. Exiting restart loop Mon Oct 23 11:03:52 EDT 2017 ma-start: MA done Mon Oct 23 11:03:58 EDT 2017 ma-start: starting MA Mon Oct 23 11:03:58 EDT 2017 ma-start: MA started with Process ID 21353 Wed Dec 6 13:18:55 EST 2017 ma-start: starting MA Wed Dec 6 13:18:55 EST 2017 ma-start: MA started with Process ID 22496 Sun Dec 10 10:47:49 EST 2017 ma-start: starting MA Sun Dec 10 10:47:49 EST 2017 ma-start: MA started with Process ID 3402 Mon Dec 11 16:23:49 EST 2017 ma-start: starting MA Mon Dec 11 16:23:49 EST 2017 ma-start: MA started with Process ID 13041 Mon Dec 11 17:53:39 EST 2017 ma-start: starting MA Mon Dec 11 17:53:39 EST 2017 ma-start: MA started with Process ID 16843 Tue Dec 19 11:57:55 EST 2017 ma-stop: stop initiated... Tue Dec 19 11:57:59 EST 2017 ma-stop: stop initiated... Tue Dec 19 11:58:00 EST 2017 ma-start: MA explicitly stopped. Exiting restart loop Tue Dec 19 11:58:00 EST 2017 ma-start: MA done Tue Dec 19 12:09:26 EST 2017 ma-start: starting MA Tue Dec 19 12:09:26 EST 2017 ma-start: MA started with Process ID 1449 Wed Jan 3 15:20:02 EST 2018 ma-start: starting MA Wed Jan 3 15:20:02 EST 2018 ma-start: MA started with Process ID 8781 Wed Jan 3 15:33:09 EST 2018 ma-start: starting MA Wed Jan 3 15:33:09 EST 2018 ma-start: MA started with Process ID 9477 Wed Jan 3 17:02:00 EST 2018 ma-stop: stop initiated... Wed Jan 3 17:02:04 EST 2018 ma-start: MA explicitly stopped. Exiting restart loop Wed Jan 3 17:02:04 EST 2018 ma-start: MA done Wed Jan 3 17:02:58 EST 2018 ma-start: starting MA Wed Jan 3 17:02:58 EST 2018 ma-start: MA started with Process ID 13394 Wed Jan 3 17:03:01 EST 2018 ma-start: no restart flag found, not restarting MA Wed Jan 3 17:03:01 EST 2018 ma-start: MA done Wed Jan 3 17:05:29 EST 2018 ma.stop: No PID file found. Java process not stopped... Wed Jan 3 17:07:01 EST 2018 ma.stop: No PID file found. Java process not stopped... Wed Jan 3 17:07:07 EST 2018 ma-start: starting MA Wed Jan 3 17:07:07 EST 2018 ma-start: MA started with Process ID 13619 Wed Jan 3 17:07:10 EST 2018 ma-start: no restart flag found, not restarting MA Wed Jan 3 17:07:10 EST 2018 ma-start: MA done Wed Jan 3 17:07:48 EST 2018 ma-start: starting MA Wed Jan 3 17:07:48 EST 2018 ma-start: MA started with Process ID 13654 Mon Jan 8 17:59:02 EST 2018 ma-start: MA already running with Process ID: 13654 Mon Jan 8 17:59:02 EST 2018 ma-start: MA done Mon Jan 8 17:59:55 EST 2018 ma-stop: stop initiated... Mon Jan 8 18:00:22 EST 2018 ma-start: MA already running with Process ID: 13654 Mon Jan 8 18:00:22 EST 2018 ma-start: MA done Mon Jan 8 18:04:14 EST 2018 ma-stop: stop initiated... Mon Jan 8 18:05:06 EST 2018 ma-start: MA already running with Process ID: 13654 Mon Jan 8 18:05:06 EST 2018 ma-start: MA done Mon Jan 8 18:05:46 EST 2018 ma-start: MA already running with Process ID: 13654 Mon Jan 8 18:05:46 EST 2018 ma-start: MA done Mon Jan 8 18:08:14 EST 2018 ma-stop: stop initiated... Mon Jan 8 18:09:01 EST 2018 ma-start: MA removing pid file for dead pid: 13654 Mon Jan 8 18:09:01 EST 2018 ma-start: starting MA Mon Jan 8 18:09:01 EST 2018 ma-start: MA started with Process ID 1192 Mon Jan 15 15:51:30 EST 2018 ma-stop: stop initiated... Mon Jan 15 15:51:30 EST 2018 ma-start: MA already running with Process ID: 1192 Mon Jan 15 15:51:30 EST 2018 ma-start: MA done Mon Jan 15 15:51:51 EST 2018 ma-stop: stop initiated... Mon Jan 15 15:52:10 EST 2018 ma-start: MA explicitly stopped. Exiting restart loop Mon Jan 15 15:52:10 EST 2018 ma-start: MA done Mon Jan 15 15:53:32 EST 2018 ma-start: starting MA Mon Jan 15 15:53:32 EST 2018 ma-start: MA started with Process ID 32571 Tue Jan 16 16:59:31 EST 2018 ma-stop: stop initiated... Tue Jan 16 17:03:14 EST 2018 ma-start: MA explicitly stopped. Exiting restart loop Tue Jan 16 17:03:14 EST 2018 ma-start: MA done Tue Jan 16 17:07:02 EST 2018 ma-start: running init extensions... Tue Jan 16 17:07:02 EST 2018 ma-start: running start extensions... Tue Jan 16 17:07:02 EST 2018 ma-start: starting MA Tue Jan 16 17:07:02 EST 2018 ma-start: MA started with Process ID 16077 Thu Jan 18 03:18:36 EST 2018 ma-start: no restart flag found, not restarting MA Thu Jan 18 03:18:36 EST 2018 ma-start: MA done Thu Jan 18 08:54:40 EST 2018 ma-start: running init extensions... Thu Jan 18 08:54:40 EST 2018 ma-start: running start extensions... Thu Jan 18 08:54:40 EST 2018 ma-start: starting MA Thu Jan 18 08:54:40 EST 2018 ma-start: MA started with Process ID 22974 Fri Jan 19 16:58:32 EST 2018 ma-start: running init extensions... Fri Jan 19 16:58:32 EST 2018 ma-start: running start extensions... Fri Jan 19 16:58:32 EST 2018 ma-start: MA removing pid file for dead pid: 22974 Fri Jan 19 16:58:32 EST 2018 ma-start: starting MA Fri Jan 19 16:58:32 EST 2018 ma-start: MA started with Process ID 1212 Fri Jan 19 16:59:31 EST 2018 ma-stop: stop initiated... Fri Jan 19 16:59:31 EST 2018 ma-start: MA already running with Process ID: 1212 Fri Jan 19 16:59:31 EST 2018 ma-start: MA done Fri Jan 19 16:59:36 EST 2018 ma-start: no restart flag found, not restarting MA Fri Jan 19 16:59:36 EST 2018 ma-start: MA done Fri Jan 19 17:12:05 EST 2018 ma.stop: No PID file found. Java process not stopped... Fri Jan 19 17:12:27 EST 2018 ma-start: starting MA Fri Jan 19 17:12:27 EST 2018 ma-start: MA started with Process ID 3048 Wed Jan 31 10:53:03 EST 2018 ma-stop: stop initiated... Wed Jan 31 10:53:03 EST 2018 ma-start: MA already running with Process ID: 3048 Wed Jan 31 10:53:03 EST 2018 ma-start: MA done Wed Jan 31 10:53:10 EST 2018 ma-start: no restart flag found, not restarting MA Wed Jan 31 10:53:10 EST 2018 ma-start: MA done Wed Jan 31 10:55:18 EST 2018 ma.stop: No PID file found. Java process not stopped... Wed Jan 31 10:56:02 EST 2018 ma-start: starting MA Wed Jan 31 10:56:02 EST 2018 ma-start: MA started with Process ID 15605 Wed Jan 31 10:56:20 EST 2018 ma-start: MA already running with Process ID: 15605 Wed Jan 31 10:56:20 EST 2018 ma-start: MA done Mon Feb 5 13:42:59 EST 2018 ma-start: running stop extensions... Mon Feb 5 13:42:59 EST 2018 ma-stop: stop initiated... Mon Feb 5 13:43:03 EST 2018 ma-start: MA explicitly stopped. Exiting restart loop Mon Feb 5 13:43:03 EST 2018 ma-start: MA done Mon Feb 5 13:43:34 EST 2018 ma-start: running init extensions... Mon Feb 5 13:43:34 EST 2018 ma-start: running start extensions... Mon Feb 5 13:43:34 EST 2018 ma-start: starting MA Mon Feb 5 13:43:34 EST 2018 ma-start: MA started with Process ID 10499 Mon Feb 5 15:29:28 EST 2018 ma-start: running restart extentions Mon Feb 5 15:29:28 EST 2018 ma-start: running start extensions... Mon Feb 5 15:29:28 EST 2018 ma-start: starting MA Mon Feb 5 15:29:28 EST 2018 ma-start: MA started with Process ID 15700 Mon Feb 5 15:42:57 EST 2018 ma-start: running restart extentions Mon Feb 5 15:42:57 EST 2018 ma-start: upgrading core... Mon Feb 5 15:43:02 EST 2018 ma-start: running init extensions... Mon Feb 5 15:43:02 EST 2018 ma-start: running start extensions... Mon Feb 5 15:43:02 EST 2018 ma-start: starting MA Mon Feb 5 15:43:02 EST 2018 ma-start: MA started with Process ID 16454 Tue Feb 6 08:49:06 EST 2018 ma-start: running restart extentions Tue Feb 6 08:49:06 EST 2018 ma-start: running start extensions... Tue Feb 6 08:49:06 EST 2018 ma-start: starting MA Tue Feb 6 08:49:06 EST 2018 ma-start: MA started with Process ID 2782 Tue Feb 6 09:53:58 EST 2018 ma-start: running stop extensions... Tue Feb 6 09:53:58 EST 2018 ma-stop: stop initiated... Tue Feb 6 09:54:00 EST 2018 ma-start: MA explicitly stopped. Exiting restart loop Tue Feb 6 09:54:00 EST 2018 ma-start: MA done Tue Feb 6 09:54:05 EST 2018 ma-start: running init extensions... Tue Feb 6 09:54:05 EST 2018 ma-start: running start extensions... Tue Feb 6 09:54:05 EST 2018 ma-start: starting MA Tue Feb 6 09:54:05 EST 2018 ma-start: MA started with Process ID 6094 Tue Feb 6 09:54:44 EST 2018 ma-start: no restart flag found, not restarting MA Tue Feb 6 09:54:44 EST 2018 ma-start: MA done Tue Feb 6 10:02:04 EST 2018 ma-start: running stop extensions... Tue Feb 6 10:02:04 EST 2018 ma.stop: No PID file found. Java process not stopped... Tue Feb 6 10:02:12 EST 2018 ma-start: running init extensions... Tue Feb 6 10:02:12 EST 2018 ma-start: running start extensions... Tue Feb 6 10:02:12 EST 2018 ma-start: starting MA Tue Feb 6 10:02:12 EST 2018 ma-start: MA started with Process ID 6315 Tue Feb 6 10:02:51 EST 2018 ma-start: no restart flag found, not restarting MA Tue Feb 6 10:02:51 EST 2018 ma-start: MA done Tue Feb 6 10:05:22 EST 2018 ma-start: running stop extensions... Tue Feb 6 10:05:22 EST 2018 ma.stop: No PID file found. Java process not stopped... Tue Feb 6 10:05:28 EST 2018 ma-start: running init extensions... Tue Feb 6 10:05:28 EST 2018 ma-start: running start extensions... Tue Feb 6 10:05:28 EST 2018 ma-start: starting MA Tue Feb 6 10:05:28 EST 2018 ma-start: MA started with Process ID 6522 Tue Feb 6 10:09:07 EST 2018 ma-start: running stop extensions... Tue Feb 6 10:09:07 EST 2018 ma-stop: stop initiated... Tue Feb 6 10:09:08 EST 2018 ma-start: MA explicitly stopped. Exiting restart loop Tue Feb 6 10:09:08 EST 2018 ma-start: MA done Tue Feb 6 10:09:40 EST 2018 ma-start: running init extensions... Tue Feb 6 10:09:40 EST 2018 ma-start: running start extensions... Tue Feb 6 10:09:40 EST 2018 ma-start: starting MA Tue Feb 6 10:09:40 EST 2018 ma-start: MA started with Process ID 6868 Tue Feb 6 10:17:53 EST 2018 ma-start: running restart extentions Tue Feb 6 10:17:53 EST 2018 ma-start: running start extensions... Tue Feb 6 10:17:53 EST 2018 ma-start: starting MA Tue Feb 6 10:17:53 EST 2018 ma-start: MA started with Process ID 7372 Tue Feb 6 14:25:18 EST 2018 ma-start: running restart extentions Tue Feb 6 14:25:18 EST 2018 ma-start: running start extensions... Tue Feb 6 14:25:18 EST 2018 ma-start: starting MA Tue Feb 6 14:25:18 EST 2018 ma-start: MA started with Process ID 20038 Tue Feb 6 14:28:21 EST 2018 ma-start: running restart extentions Tue Feb 6 14:28:21 EST 2018 ma-start: running start extensions... Tue Feb 6 14:28:21 EST 2018 ma-start: starting MA Tue Feb 6 14:28:21 EST 2018 ma-start: MA started with Process ID 20257 Mon Feb 12 11:38:55 EST 2018 ma-start: running restart extentions Mon Feb 12 11:38:55 EST 2018 ma-start: running start extensions... Mon Feb 12 11:38:55 EST 2018 ma-start: starting MA Mon Feb 12 11:38:55 EST 2018 ma-start: MA started with Process ID 19811 Tue Feb 20 21:15:54 EST 2018 ma-start: running stop extensions... Tue Feb 20 21:15:54 EST 2018 ma-stop: stop initiated... Tue Feb 20 21:16:37 EST 2018 ma-start: MA explicitly stopped. Exiting restart loop Tue Feb 20 21:16:37 EST 2018 ma-start: MA done Tue Feb 20 21:22:31 EST 2018 ma-start: running init extensions... Tue Feb 20 21:22:31 EST 2018 ma-start: running start extensions... Tue Feb 20 21:22:31 EST 2018 ma-start: starting MA Tue Feb 20 21:22:31 EST 2018 ma-start: MA started with Process ID 26488 Wed Feb 21 10:10:32 EST 2018 ma-start: running stop extensions... Wed Feb 21 10:10:32 EST 2018 ma-stop: stop initiated... Wed Feb 21 10:10:39 EST 2018 ma-start: MA explicitly stopped. Exiting restart loop Wed Feb 21 10:10:39 EST 2018 ma-start: MA done Wed Feb 21 10:11:06 EST 2018 ma-start: running init extensions... Wed Feb 21 10:11:06 EST 2018 ma-start: running start extensions... Wed Feb 21 10:11:06 EST 2018 ma-start: starting MA Wed Feb 21 10:11:06 EST 2018 ma-start: MA started with Process ID 27590 Tue Feb 27 15:23:55 EST 2018 ma-start: running restart extentions Tue Feb 27 15:23:55 EST 2018 ma-start: running start extensions... Tue Feb 27 15:23:55 EST 2018 ma-start: starting MA Tue Feb 27 15:23:55 EST 2018 ma-start: MA started with Process ID 29655 Mon Apr 9 12:20:27 EDT 2018 ma-start: running restart extentions Mon Apr 9 12:20:27 EDT 2018 ma-start: upgrading core... Mon Apr 9 12:20:30 EDT 2018 ma-start: running init extensions... Mon Apr 9 12:20:30 EDT 2018 ma-start: running start extensions... Mon Apr 9 12:20:30 EDT 2018 ma-start: starting MA Mon Apr 9 12:20:30 EDT 2018 ma-start: MA started with Process ID 26103 Mon Jun 11 16:26:20 EDT 2018 ma-start: running restart extentions Mon Jun 11 16:26:20 EDT 2018 ma-start: upgrading core... Mon Jun 11 16:26:23 EDT 2018 ma-start: running init extensions... Mon Jun 11 16:26:23 EDT 2018 ma-start: running start extensions... Mon Jun 11 16:26:23 EDT 2018 ma-start: starting MA Mon Jun 11 16:26:23 EDT 2018 ma-start: MA started with Process ID 8810 Tue Jun 26 09:16:51 EDT 2018 ma-start: running restart extentions Tue Jun 26 09:16:51 EDT 2018 ma-start: running start extensions... Tue Jun 26 09:16:51 EDT 2018 ma-start: starting MA Tue Jun 26 09:16:51 EDT 2018 ma-start: MA started with Process ID 13108 Wed Jun 27 14:22:41 EDT 2018 ma-start: running stop extensions... Wed Jun 27 14:22:41 EDT 2018 ma-stop: stop initiated... Wed Jun 27 14:22:41 EDT 2018 ma-start: running init extensions... Wed Jun 27 14:22:41 EDT 2018 ma-start: running start extensions... Wed Jun 27 14:22:41 EDT 2018 ma-start: MA already running with Process ID: 13108 Wed Jun 27 14:22:41 EDT 2018 ma-start: MA done Wed Jun 27 14:22:49 EDT 2018 ma-start: no restart flag found, not restarting MA Wed Jun 27 14:22:49 EDT 2018 ma-start: MA done Wed Jun 27 14:47:28 EDT 2018 ma-start: running stop extensions... Wed Jun 27 14:47:28 EDT 2018 ma.stop: No PID file found. Java process not stopped... Wed Jun 27 14:47:31 EDT 2018 ma-start: running init extensions... Wed Jun 27 14:47:31 EDT 2018 ma-start: running start extensions... Wed Jun 27 14:47:31 EDT 2018 ma-start: starting MA Wed Jun 27 14:47:31 EDT 2018 ma-start: MA started with Process ID 25173 Mon Aug 27 15:01:50 EDT 2018 ma-start: running restart extentions Mon Aug 27 15:01:50 EDT 2018 ma-start: upgrading core... Mon Aug 27 15:01:54 EDT 2018 ma-start: running init extensions... Mon Aug 27 15:01:54 EDT 2018 ma-start: running start extensions... Mon Aug 27 15:01:54 EDT 2018 ma-start: starting MA Mon Aug 27 15:01:54 EDT 2018 ma-start: MA started with Process ID 28516 Mon Oct 15 11:08:09 EDT 2018 ma-start: running restart extentions Mon Oct 15 11:08:09 EDT 2018 ma-start: upgrading core... Mon Oct 15 11:08:12 EDT 2018 ma-start: running init extensions... Mon Oct 15 11:08:12 EDT 2018 ma-start: running start extensions... Mon Oct 15 11:08:12 EDT 2018 ma-start: starting MA Mon Oct 15 11:08:12 EDT 2018 ma-start: MA started with Process ID 13251 Mon Oct 15 11:15:49 EDT 2018 ma-start: running restart extentions Mon Oct 15 11:15:49 EDT 2018 ma-start: running start extensions... Mon Oct 15 11:15:49 EDT 2018 ma-start: starting MA Mon Oct 15 11:15:49 EDT 2018 ma-start: MA started with Process ID 13792 Mon Oct 15 11:31:00 EDT 2018 ma-start: running restart extentions Mon Oct 15 11:31:00 EDT 2018 ma-start: running start extensions... Mon Oct 15 11:31:00 EDT 2018 ma-start: starting MA Mon Oct 15 11:31:00 EDT 2018 ma-start: MA started with Process ID 14702 Thu Dec 6 09:49:09 EST 2018 ma-start: running restart extentions Thu Dec 6 09:49:09 EST 2018 ma-start: upgrading core... Thu Dec 6 09:49:14 EST 2018 ma-start: running init extensions... Thu Dec 6 09:49:14 EST 2018 ma-start: running start extensions... Thu Dec 6 09:49:14 EST 2018 ma-start: starting MA Thu Dec 6 09:49:14 EST 2018 ma-start: MA started with Process ID 18535 Wed Jan 9 17:49:33 EST 2019 ma-start: running restart extentions Wed Jan 9 17:49:33 EST 2019 ma-start: running start extensions... Wed Jan 9 17:49:33 EST 2019 ma-start: starting MA Wed Jan 9 17:49:33 EST 2019 ma-start: MA started with Process ID 27130 Thu Jan 17 17:20:53 EST 2019 ma-start: running restart extentions Thu Jan 17 17:20:53 EST 2019 ma-start: running start extensions... Thu Jan 17 17:20:53 EST 2019 ma-start: starting MA Thu Jan 17 17:20:53 EST 2019 ma-start: MA started with Process ID 9711 Wed Jan 23 12:08:03 EST 2019 ma-start: running restart extentions Wed Jan 23 12:08:03 EST 2019 ma-start: running start extensions... Wed Jan 23 12:08:03 EST 2019 ma-start: starting MA Wed Jan 23 12:08:03 EST 2019 ma-start: MA started with Process ID 11469 Wed Jan 23 17:42:38 EST 2019 ma-start: running restart extentions Wed Jan 23 17:42:38 EST 2019 ma-start: running start extensions... Wed Jan 23 17:42:38 EST 2019 ma-start: starting MA Wed Jan 23 17:42:38 EST 2019 ma-start: MA started with Process ID 28564 Wed Jan 23 18:18:10 EST 2019 ma-start: running restart extentions Wed Jan 23 18:18:10 EST 2019 ma-start: running start extensions... Wed Jan 23 18:18:10 EST 2019 ma-start: starting MA Wed Jan 23 18:18:10 EST 2019 ma-start: MA started with Process ID 30620 Wed Jan 23 18:21:53 EST 2019 ma-start: running restart extentions Wed Jan 23 18:21:53 EST 2019 ma-start: running start extensions... Wed Jan 23 18:21:53 EST 2019 ma-start: starting MA Wed Jan 23 18:21:53 EST 2019 ma-start: MA started with Process ID 30896 Wed Jan 23 18:24:50 EST 2019 ma-start: running restart extentions Wed Jan 23 18:24:50 EST 2019 ma-start: running start extensions... Wed Jan 23 18:24:50 EST 2019 ma-start: starting MA Wed Jan 23 18:24:50 EST 2019 ma-start: MA started with Process ID 31138 Mon Feb 11 15:14:45 EST 2019 ma-start: running restart extentions Mon Feb 11 15:14:45 EST 2019 ma-start: running start extensions... Mon Feb 11 15:14:45 EST 2019 ma-start: starting MA Mon Feb 11 15:14:45 EST 2019 ma-start: MA started with Process ID 20258 Wed Feb 20 13:23:44 EST 2019 ma-restart: restart initiated... Wed Feb 20 13:23:47 EST 2019 ma-restart: restart initiated... Wed Feb 20 13:24:28 EST 2019 ma-start: running restart extentions Wed Feb 20 13:24:28 EST 2019 ma-start: running start extensions... Wed Feb 20 13:24:28 EST 2019 ma-start: starting MA Wed Feb 20 13:24:28 EST 2019 ma-start: MA started with Process ID 15204 Tue Mar 5 11:37:01 EST 2019 ma-start: running restart extentions Tue Mar 5 11:37:01 EST 2019 ma-start: running start extensions... Tue Mar 5 11:37:01 EST 2019 ma-start: starting MA Tue Mar 5 11:37:01 EST 2019 ma-start: MA started with Process ID 18000 Fri Mar 8 09:39:00 EST 2019 ma-start: running restart extentions Fri Mar 8 09:39:00 EST 2019 ma-start: running start extensions... Fri Mar 8 09:39:00 EST 2019 ma-start: starting MA Fri Mar 8 09:39:00 EST 2019 ma-start: MA started with Process ID 17263 Fri Mar 15 12:58:12 EDT 2019 ma-start: running restart extentions Fri Mar 15 12:58:12 EDT 2019 ma-start: running start extensions... Fri Mar 15 12:58:12 EDT 2019 ma-start: starting MA Fri Mar 15 12:58:12 EDT 2019 ma-start: MA started with Process ID 1075 Sun Mar 17 18:56:34 EDT 2019 ma-start: running restart extentions Sun Mar 17 18:56:34 EDT 2019 ma-start: running start extensions... Sun Mar 17 18:56:34 EDT 2019 ma-start: starting MA Sun Mar 17 18:56:34 EDT 2019 ma-start: MA started with Process ID 17809 Sun Mar 17 18:59:50 EDT 2019 ma-start: running restart extentions Sun Mar 17 18:59:50 EDT 2019 ma-start: running start extensions... Sun Mar 17 18:59:50 EDT 2019 ma-start: starting MA Sun Mar 17 18:59:50 EDT 2019 ma-start: MA started with Process ID 18066 Tue Apr 30 11:43:24 EDT 2019 ma-start: running restart extentions Tue Apr 30 11:43:24 EDT 2019 ma-start: running start extensions... Tue Apr 30 11:43:24 EDT 2019 ma-start: starting MA Tue Apr 30 11:43:24 EDT 2019 ma-start: MA started with Process ID 9427 Tue Apr 30 12:30:27 EDT 2019 ma-start: running restart extentions Tue Apr 30 12:30:27 EDT 2019 ma-start: running start extensions... Tue Apr 30 12:30:27 EDT 2019 ma-start: starting MA Tue Apr 30 12:30:27 EDT 2019 ma-start: MA started with Process ID 12151 Sun Jun 9 09:02:57 EDT 2019 ma-start: no restart flag found, not restarting MA Sun Jun 9 09:02:58 EDT 2019 ma-start: MA done Sun Jun 9 17:47:00 EDT 2019 ma-start: running stop extensions... Sun Jun 9 17:47:00 EDT 2019 ma.stop: No PID file found. Java process not stopped... Sun Jun 9 17:47:22 EDT 2019 ma-start: running init extensions... Sun Jun 9 17:47:22 EDT 2019 ma-start: running start extensions... Sun Jun 9 17:47:22 EDT 2019 ma-start: starting MA Sun Jun 9 17:47:22 EDT 2019 ma-start: MA started with Process ID 8262 Tue Jun 11 15:37:59 EDT 2019 ma-start: running stop extensions... Tue Jun 11 15:37:59 EDT 2019 ma-stop: stop initiated... Tue Jun 11 15:38:06 EDT 2019 ma-start: MA explicitly stopped. Exiting restart loop Tue Jun 11 15:38:06 EDT 2019 ma-start: MA done Tue Jun 11 15:40:48 EDT 2019 ma-start: running init extensions... Tue Jun 11 15:40:48 EDT 2019 ma-start: running start extensions... Tue Jun 11 15:40:48 EDT 2019 ma-start: starting MA Tue Jun 11 15:40:48 EDT 2019 ma-start: MA started with Process ID 1152 Mon Aug 19 10:25:36 EDT 2019 ma-start: running stop extensions... Mon Aug 19 10:25:36 EDT 2019 ma-stop: stop initiated... Mon Aug 19 10:33:00 EDT 2019 ma-start: running init extensions... Mon Aug 19 10:33:00 EDT 2019 ma-start: upgrading core... Mon Aug 19 10:33:21 EDT 2019 ma-start: running init extensions... Mon Aug 19 10:33:21 EDT 2019 ma-start: running start extensions... Mon Aug 19 10:33:21 EDT 2019 ma-start: MA removing pid file for dead pid: 1152 Mon Aug 19 10:33:21 EDT 2019 ma-start: starting MA Mon Aug 19 10:33:21 EDT 2019 ma-start: MA started with Process ID 1334 Mon Aug 19 10:40:16 EDT 2019 ma-start: running stop extensions... Mon Aug 19 10:40:16 EDT 2019 ma-stop: stop initiated... Mon Aug 19 10:40:20 EDT 2019 ma-start: MA explicitly stopped. Exiting restart loop Mon Aug 19 10:40:20 EDT 2019 ma-start: MA done Mon Aug 19 10:40:26 EDT 2019 ma-start: running init extensions... Mon Aug 19 10:40:26 EDT 2019 ma-start: running start extensions... Mon Aug 19 10:40:26 EDT 2019 ma-start: starting MA Mon Aug 19 10:40:26 EDT 2019 ma-start: MA started with Process ID 2085 Mon Aug 19 10:51:15 EDT 2019 ma-start: running stop extensions... Mon Aug 19 10:51:15 EDT 2019 ma-stop: stop initiated... Mon Aug 19 10:51:20 EDT 2019 ma-start: MA explicitly stopped. Exiting restart loop Mon Aug 19 10:51:20 EDT 2019 ma-start: MA done Mon Aug 19 10:51:48 EDT 2019 ma-start: running init extensions... Mon Aug 19 10:51:48 EDT 2019 ma-start: running start extensions... Mon Aug 19 10:51:48 EDT 2019 ma-start: starting MA Mon Aug 19 10:51:48 EDT 2019 ma-start: MA started with Process ID 2720 Mon Aug 19 10:59:30 EDT 2019 ma-start: running stop extensions... Mon Aug 19 10:59:30 EDT 2019 ma-stop: stop initiated... Mon Aug 19 10:59:31 EDT 2019 ma-start: running init extensions... Mon Aug 19 10:59:31 EDT 2019 ma-start: running start extensions... Mon Aug 19 10:59:32 EDT 2019 ma-start: MA removing pid file for dead pid: 2720 Mon Aug 19 10:59:32 EDT 2019 ma-start: starting MA Mon Aug 19 10:59:32 EDT 2019 ma-start: MA started with Process ID 3252 Mon Aug 19 10:59:32 EDT 2019 ma-start: no restart flag found, not restarting MA Mon Aug 19 10:59:32 EDT 2019 ma-start: MA done Mon Aug 19 11:05:55 EDT 2019 ma-start: running stop extensions... Mon Aug 19 11:05:55 EDT 2019 ma.stop: No PID file found. Java process not stopped... Mon Aug 19 11:05:55 EDT 2019 ma-start: running init extensions... Mon Aug 19 11:05:55 EDT 2019 ma-start: running start extensions... Mon Aug 19 11:05:55 EDT 2019 ma-start: starting MA Mon Aug 19 11:05:55 EDT 2019 ma-start: MA started with Process ID 3618 Mon Aug 19 11:06:23 EDT 2019 ma-start: no restart flag found, not restarting MA Mon Aug 19 11:06:23 EDT 2019 ma-start: MA done Mon Aug 19 11:06:57 EDT 2019 ma-start: running stop extensions... Mon Aug 19 11:06:57 EDT 2019 ma.stop: No PID file found. Java process not stopped... Mon Aug 19 11:06:57 EDT 2019 ma-start: running init extensions... Mon Aug 19 11:06:57 EDT 2019 ma-start: running start extensions... Mon Aug 19 11:06:57 EDT 2019 ma-start: starting MA Mon Aug 19 11:06:57 EDT 2019 ma-start: MA started with Process ID 3747 Mon Aug 19 11:07:35 EDT 2019 ma-start: no restart flag found, not restarting MA Mon Aug 19 11:07:35 EDT 2019 ma-start: MA done Mon Aug 19 11:49:11 EDT 2019 ma-start: running stop extensions... Mon Aug 19 11:49:11 EDT 2019 ma.stop: No PID file found. Java process not stopped... Mon Aug 19 11:57:43 EDT 2019 ma-start: running init extensions... Mon Aug 19 11:57:43 EDT 2019 ma-start: running start extensions... Mon Aug 19 11:57:43 EDT 2019 ma-start: starting MA Mon Aug 19 11:57:43 EDT 2019 ma-start: MA started with Process ID 6092 Mon Aug 19 11:57:46 EDT 2019 ma-start: no restart flag found, not restarting MA Mon Aug 19 11:57:47 EDT 2019 ma-start: MA done Mon Aug 19 11:58:10 EDT 2019 ma-start: running stop extensions... Mon Aug 19 11:58:10 EDT 2019 ma.stop: No PID file found. Java process not stopped... Mon Aug 19 12:00:03 EDT 2019 ma-start: running init extensions... Mon Aug 19 12:00:03 EDT 2019 ma-start: running start extensions... Mon Aug 19 12:00:03 EDT 2019 ma-start: starting MA Mon Aug 19 12:00:03 EDT 2019 ma-start: MA started with Process ID 6392 Mon Aug 19 12:00:06 EDT 2019 ma-start: no restart flag found, not restarting MA Mon Aug 19 12:00:06 EDT 2019 ma-start: MA done Mon Aug 19 12:02:03 EDT 2019 ma-start: running stop extensions... Mon Aug 19 12:02:03 EDT 2019 ma.stop: No PID file found. Java process not stopped... Mon Aug 19 12:02:03 EDT 2019 ma-start: running init extensions... Mon Aug 19 12:02:03 EDT 2019 ma-start: running start extensions... Mon Aug 19 12:02:03 EDT 2019 ma-start: starting MA Mon Aug 19 12:02:03 EDT 2019 ma-start: MA started with Process ID 6528 Mon Aug 19 12:02:06 EDT 2019 ma-start: no restart flag found, not restarting MA Mon Aug 19 12:02:06 EDT 2019 ma-start: MA done Mon Aug 19 12:04:38 EDT 2019 ma-start: running stop extensions... Mon Aug 19 12:04:38 EDT 2019 ma.stop: No PID file found. Java process not stopped... Mon Aug 19 12:04:38 EDT 2019 ma-start: running init extensions... Mon Aug 19 12:04:38 EDT 2019 ma-start: running start extensions... Mon Aug 19 12:04:38 EDT 2019 ma-start: starting MA Mon Aug 19 12:04:38 EDT 2019 ma-start: MA started with Process ID 6684 Mon Aug 19 12:04:41 EDT 2019 ma-start: no restart flag found, not restarting MA Mon Aug 19 12:04:41 EDT 2019 ma-start: MA done Mon Aug 19 12:04:41 EDT 2019 ma-start: running stop extensions... Mon Aug 19 12:04:41 EDT 2019 ma.stop: No PID file found. Java process not stopped... Mon Aug 19 17:22:38 EDT 2019 ma-start: running init extensions... Mon Aug 19 17:22:38 EDT 2019 ma-start: running start extensions... Mon Aug 19 17:22:38 EDT 2019 ma-start: starting MA Mon Aug 19 17:22:38 EDT 2019 ma-start: MA started with Process ID 20681 Mon Aug 19 17:22:41 EDT 2019 ma-start: no restart flag found, not restarting MA Mon Aug 19 17:22:41 EDT 2019 ma-start: MA done Mon Aug 19 17:23:55 EDT 2019 ma-start: running stop extensions... Mon Aug 19 17:23:55 EDT 2019 ma.stop: No PID file found. Java process not stopped... Mon Aug 19 17:23:55 EDT 2019 ma-start: running init extensions... Mon Aug 19 17:23:55 EDT 2019 ma-start: running start extensions... Mon Aug 19 17:23:55 EDT 2019 ma-start: starting MA Mon Aug 19 17:23:55 EDT 2019 ma-start: MA started with Process ID 20814 Mon Aug 19 17:23:58 EDT 2019 ma-start: no restart flag found, not restarting MA Mon Aug 19 17:23:58 EDT 2019 ma-start: MA doneThe ma.log file is too large but I have emailed it to support@infiniteautomation.com
Please advise. Looks like something may have been deleted?
-
Your logs are still just spammed full of messages about modules not being installed. You can download the enterprise bundle from
https://store.infiniteautomation.com/core,rename itm2m2-core-3.6.4.zip, and place it in your Mango/ directory, where it will get unpacked (including modules) at next startup attempt.I also saw the "settable" column error still occurred, so that didn't get sorted either.
Try to start Mango on the command line and share only that output should it fail to start.
You shouldn't get those module not installed messages had you moved the databases directory to start on a fresh database, as it is deserializing your old points. Also there is seemingly not a cause of the shutdown being reported, so maybe an error is making it to stderr and you would see this when you are running
/path/to/Mango/bin/ma.sh startat the command line. It'd probably be the last message to print... -
Hi Phil,
I've got my issue partially fixed..
I had forgotten the golden rule - when in doubt turn on and off again. I rebooted our instance in AWS and that did the trick! My restart/stop/start commands are now functioning as expected. Apologies for wasting your time with that.
I started from a fresh database. I then installed the enterprise bundle as you recommended. I then restored my core backup
(core-database-H2-Aug-17-2019_011649.zip)through the UI. All of my data sources are there, however none of my points have their previous values.Just wondering how I should go about doing a backup through the command line in case my backup is a different version than the current interface. I've tried following a previous forum post but I'm not quite understanding the command line sequence.
Are the configuration backups and incremental backups important for this task?
Thanks again!
-
Just wondering how I should go about doing a backup through the command line in case my backup is a different version than the current interface. I've tried following a previous forum post but I'm not quite understanding the command line sequence.
The post you linked to is about doing a restore on the command line. That command should be able to be run from your Mango directory, but you may need to change the path to the H2 JAR and the mah2 file, due to version numbers having changed. Do you have a more specific question?
All of my data sources are there, however none of my points have their previous values.
You can use the /ui/administration/no-sql page to "Merge Mango NoSQL data into Mango" by point it at the old_databases/mangoTSDB directory. Assuming you were using NoSQL, then your data would be in your old databases folder, presuming you moved it to be able to start fresh. The incremental backups are of the NoSQL data. You could possibly restore these to get your data back as well.
