• E
    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!

    posted in User help read more
  • E
    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?

    posted in User help read more
  • E
    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!

    posted in User help read more