Unable to restart Cloud Mango

Envari

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_iw6rC3LiG0nvCL8iWvDBXn049be5

Thank you so much in advance!

phildunlap

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.

Envari

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 done

The ma.log file is too large but I have emailed it to support@infiniteautomation.com

Please advise. Looks like something may have been deleted?

phildunlap

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 it m2m2-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 start at the command line. It'd probably be the last message to print...

Envari

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!

phildunlap

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.