DBServer Instance Remains in the Restoring State

Symptom

A DBServer instance remains in the Restoring state. The status cannot be recovered even after a restart.

Cause Analysis

1. DBService monitors the ${BIGDATA_HOME}/MRS_XXX/install/dbservice/ha/module/harm/plugin/script/gsDB/.startGS.fail file. XXX indicates the product version.
2. If the value in the file is greater than 3, the startup fails. The NodeAgent keeps trying to restart the instance. In this case, the startup still fails and the value is incremented by 1 each time the startup fails.

Solution

1. Log in to MRS Manager.
2. Stop the DBServer instance.
3. Log in to the node where the DBServer instance is abnormal as user omm.
4. Change the value of in the ${BIGDATA_HOME}/MRS_XXX/install/dbservice/ha/module/harm/plugin/script/gsDB/.startGS.fail file to 0. XXX indicates the product version.
5. Start the DBServer instance.