on our Watch4Net backend server we have issues when the server is restarted, eg: some of the services fail to restart, I believe this is caused because other services have not started yet, eg: MySQL database service, what is the order that services should be started in ? or should we not be seeing this issue at all ?
The follow command should be used to start all services in the correct order:
/opt/APG/bin/manage-modules.sh service start all
If the MySQL service is still not starting, then you may have other issues with the backend.
Please see the following KBs which may help to resolve the issue.
https://support.emc.com/kb/90980 - EMC M&R: Backend will not start and reports contain no new data. Error: Caused by: java.sql.SQLException: Table '.\apg\data_property' is marked as crashed and should be repaired
https://support.emc.com/kb/203978 - EMC M&R (Watch4net) : Unable to start Backend after server crash; Error: SEVERE -- Cache::start(): APG Backend startup failed!
Thanks for that Paul, some great information for other issues we see, but it did not answer my question, our servers are restarted automatically so there is no one there to watch and fix issues, in this instance I have setup a program that will restart the services but I need to know what the order of the restart should be, below is the current order I have the services restarting:
I have since moved the MySQL up to first in the list but it would be good to know if I need to move any of the others around.