@joelhaggar Thank you for the information. I was able to look through the NTP and timesyncd config files, and things looked alright. However I discovered I was having problems with internet connectivity and DNS resolving on the device in question. I discovered that it didn't have a default IP routing path. Considering we didn't need an outwards internet connection for our projects, makes sense that I didn't pick up on it.

I looked at another MangoES device on the same network and discovered it had an internet connection, so my issue was isolated. I added a default IP route using "sudo ip route add default via XX.XX.XX.XX dev eth0", and borrowed the gateway info from a functioning device. I then overwrote the DNS resolve file found at "/etc/resolv.conf" with "nameserver 8.8.8.8".

Not sure how things go out of hand in the first place, but I used "sudo date +%T -s "hh:mm:ss" to bring the unsynced time within a few seconds of the local time. I then forced the NTP to restart using "sudo service ntp restart", checked the ntp status using "sudo service ntp status", and then it looked like my ntp hosts were being resolved correctly and the time had resynced.

Appreciate the help Joel!

@joelhaggar I ran "sudo service networking restart" and resolv.conf doesn't appear to have changed. I also ran "sudo service mango restart" and still no change. Although please advise if I should do another test.

Thanks for the tip Mr. Sysak! :) Definitely would have been a concern if it was being overwritten and the drift continued.

@joelhaggar Thank you for the information. I was able to look through the NTP and timesyncd config files, and things looked alright. However I discovered I was having problems with internet connectivity and DNS resolving on the device in question. I discovered that it didn't have a default IP routing path. Considering we didn't need an outwards internet connection for our projects, makes sense that I didn't pick up on it.

I looked at another MangoES device on the same network and discovered it had an internet connection, so my issue was isolated. I added a default IP route using "sudo ip route add default via XX.XX.XX.XX dev eth0", and borrowed the gateway info from a functioning device. I then overwrote the DNS resolve file found at "/etc/resolv.conf" with "nameserver 8.8.8.8".

Not sure how things go out of hand in the first place, but I used "sudo date +%T -s "hh:mm:ss" to bring the unsynced time within a few seconds of the local time. I then forced the NTP to restart using "sudo service ntp restart", checked the ntp status using "sudo service ntp status", and then it looked like my ntp hosts were being resolved correctly and the time had resynced.

Appreciate the help Joel!

@joelhaggar the previous screenshot was showing that the network time on the bottom right was 4:16pm (matched local time). And that the point logging history was showing a most recent update time of ~3:53pm with most recent point logged at ~3:52pm.

When a new data point is logged, its timestamp matches the system time. However the issue is that system time doesn't match the time zone time exactly - it's delayed by ~24 mins.

I confirmed through command line in PuTTY that the Mango's system time is behind by ~24 mins (10:12am) compared to the local time of 10:36am.

See photo:

Hi there,

I'm using a MangoES device with core v3.7.7.

I've set the time zone of the MangoES to America/Toronto (through the UI and confirmed it is correctly set in the FTP directory in /etc/timezone). I restarted the database, however it appears that there is a ~24 minute delay between the Mango server time and local time. It affects all Modbus point logging and script executions, which is not ideal. I confirmed using javascript (new Date()) that the time is in fact delayed by 24 mins.

Are there some steps I could follow to ensure the server time lines up with the time zone I've set?

It could also be an issue with the overarching network - not savvy enough to know what influences the Mango time. Any help would be appreciated.

See photo (I refreshed the datapt History before taking the sc)

HI there,
I can't seem to access one of our Mango instances through the UI on the web. However, I can still access through FTP and SSH. When I try restarting the instance through SSH it seems to get hung up on the last line in the log below. Any help would be appreciated.

What initially caused the web interface to be inaccessible ("This site can’t be reached" on Google Chrome) was me stopping and starting the instance through SSH in preparation for upgrading the core library and all modules. At one point, while refreshing the browser at hostname/ui/login, the following error came up: "Error bootstrapping Mango UI app: Failed to fetch pre-login bootstrap data." I only saw this error once and could not replicate it.

From the ma.log:

INFO  2020-10-02T18:42:55,097 (com.serotonin.m2m2.Main.main:121) - Starting Mango 3.7.7 with Schema Version: 29 
WARN  2020-10-02T18:42:55,817 (com.serotonin.m2m2.Main.loadModules:443) - Module mangoESConfiguration: this module requires a core version of 3.5, which does not match the current core version of 3.7.7. Module not loaded. 
INFO  2020-10-02T18:42:56,600 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sqlds', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,648 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mqttClientDataSource', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,658 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'acurite', v3.7.0 by Terry Packer 
INFO  2020-10-02T18:42:56,666 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/acurite/web/dox/manifest.xml 
INFO  2020-10-02T18:42:56,669 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'TCPIP', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,678 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'asciiFile', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,688 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sqlConsole', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,698 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'galil', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,707 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'lang_zh', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,709 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sstGlobalScripts', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,719 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mbus', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,733 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'log4jDS', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,744 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'persistent', v3.7.1 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,756 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'vmstat', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,766 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mangoApi', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,778 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'pointLinks', v3.7.1 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,789 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'log4JReset', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,792 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sstTheme', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,798 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'jmxds', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,807 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'twilio', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,820 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'meta', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,832 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'excelReports', v3.7.1 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,848 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'snmp', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,857 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'http', v3.7.1 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,871 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'controlcore', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,879 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'advancedComponents', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,883 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/advancedComponents/web/dox/manifest.xml 
INFO  2020-10-02T18:42:56,888 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'jsonFileImport', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,896 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'graphicalViews', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,919 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'scripting', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,928 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'watchlists', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,943 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dataPointDetailsView', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,951 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'modbus', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,962 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'slackPublisher', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,973 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'lang_es', v3.7.1 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,980 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'onewire', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,989 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'virtualDS', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:56,997 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'advancedScheduler', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,000 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dashboardDesigner', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,004 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/dashboardDesigner/web/dox/manifest.xml 
INFO  2020-10-02T18:42:57,007 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dataFile', v3.7.1 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,024 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mangoUI', v3.7.7 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,029 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/mangoUI/web/dox/manifest.xml 
INFO  2020-10-02T18:42:57,059 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'ssh', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,068 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dnp3', v3.7.3 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,077 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'dataImport', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,085 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'pop3', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,093 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'cloudConnect', v3.7.1 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,097 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/cloudConnect/web/dox/manifest.xml 
INFO  2020-10-02T18:42:57,099 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'lang_pt', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,113 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'deviceConfig', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,117 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/deviceConfig/web/dox/manifest.xml 
INFO  2020-10-02T18:42:57,120 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'templateConfig', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,128 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'Haystack', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,137 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'opcda', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,140 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'MangoIOTools', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,144 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/MangoIOTools/web/dox/manifest.xml 
INFO  2020-10-02T18:42:57,146 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'BACnet', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,156 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'pid', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,164 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'zwave', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,184 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'egauge', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,192 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'scheduledEvents', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,202 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'loggingConsole', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,210 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'sstGraphics', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,225 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'mangoNoSqlDatabase', v3.7.1 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,235 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'reports', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,245 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'maintenanceEvents', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,253 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'serial', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:42:57,261 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'internal', v3.7.0 by Infinite Automation Systems Inc. 
INFO  2020-10-02T18:43:07,533 (com.serotonin.m2m2.Lifecycle.loadLic:583) - Checking license... 
WARN  2020-10-02T18:43:07,811 (com.serotonin.m2m2.TimedLicenseRegistrar.checkLicenses:64) - Mango NoSQL database is running in free mode, Mango will shutdown at 2:43:07 3/10/2020. 
INFO  2020-10-02T18:43:08,132 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:64) - Initializing H2 connection manager 
INFO  2020-10-02T18:43:10,292 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:38) - Starting instance with core version 3.7.7, schema v29 
INFO  2020-10-02T18:43:10,292 (com.infiniteautomation.nosql.MangoNoSqlProxy.initialize:77) - Starting MangoNoSql Database 
INFO  2020-10-02T18:43:10,406 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:144) - Database at /opt/mango/databases/mangoTSDB started 
INFO  2020-10-02T18:43:10,515 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:173) - Empty dir delete for database at /opt/mango/databases/mangoTSDB took 69ms 
INFO  2020-10-02T18:43:10,532 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:144) - Database at /opt/mango/databases/mangoTSDBAux started 
INFO  2020-10-02T18:43:10,559 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:173) - Empty dir delete for database at /opt/mango/databases/mangoTSDBAux took 0ms 
INFO  2020-10-02T18:43:23,475 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:133) - Spring context 'runtimeContext' refreshed: org.springframework.context.annotation.AnnotationConfigApplicationContext@da6cbd 
INFO  2020-10-02T18:43:23,492 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextStarted:147) - Spring context 'runtimeContext' started: org.springframework.context.annotation.AnnotationConfigApplicationContext@da6cbd 
INFO  2020-10-02T18:43:24,008 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:77) - Initializing 5 NORMAL priority data sources in 8 threads. 
INFO  2020-10-02T18:43:24,705 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source Mango Internal took 691ms to start 
INFO  2020-10-02T18:43:24,711 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source MangoES System took 697ms to start 
INFO  2020-10-02T18:43:24,891 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source MangoES System took 877ms to start 
INFO  2020-10-02T18:43:25,213 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source 309_Legget took 1203ms to start 
INFO  2020-10-02T18:43:25,394 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source BACNET_IP took 1382ms to start 
INFO  2020-10-02T18:43:25,473 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:109) - Initialization of 5 NORMAL priority data sources took 1465ms 
INFO  2020-10-02T18:43:25,473 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:77) - Initializing 1 LAST priority data sources in 8 threads. 
INFO  2020-10-02T18:43:27,464 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initializeDataSourceStartup:408) - Data source KRP - 309 Legget - Data took 1989ms to start 
INFO  2020-10-02T18:43:27,477 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.initialize:109) - Initialization of 1 LAST priority data sources took 2004ms 
INFO  2020-10-02T18:43:27,707 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:176) - Starting 2 Publishers... 
INFO  2020-10-02T18:43:27,708 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:178) - Starting publisher: HTTP 
INFO  2020-10-02T18:43:27,747 (com.serotonin.m2m2.rt.RuntimeManagerImpl.startPublisher:949) - Publisher 'HTTP' took 38.809859ms to start 
INFO  2020-10-02T18:43:27,748 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:178) - Starting publisher: EO_PERSISTENT 
INFO  2020-10-02T18:43:27,748 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:188) - 2 Publisher's started in 124ms 
INFO  2020-10-02T18:43:36,255 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:133) - Spring context 'rootWebContext' refreshed: Root WebApplicationContext 
INFO  2020-10-02T18:43:46,076 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:133) - Spring context 'jspDispatcherContext' refreshed: WebApplicationContext for namespace 'JSP_DISPATCHER-servlet' 
INFO  2020-10-02T18:43:47,177 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:133) - Spring context 'restDispatcherContext' refreshed: WebApplicationContext for namespace 'REST_DISPATCHER-servlet' 
INFO  2020-10-02T18:43:50,699 (com.serotonin.m2m2.web.mvc.rest.v1.BacnetDiscoveryRestController.<init>:54) - Creating Discovery Rest Controller 
INFO  2020-10-02T18:43:56,855 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:133) - Spring context 'restV1Context' refreshed: WebApplicationContext for namespace 'restV1DispatcherServlet-servlet' 
INFO  2020-10-02T18:44:08,137 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:133) - Spring context 'restV2Context' refreshed: WebApplicationContext for namespace 'restV2DispatcherServlet-servlet' 

Thanks!

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!

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?

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!