DBServer Instance Is Always in the Restoring State Because the Incorrect /tmp Directory Permission

Symptom

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

Cause Analysis

1. Check /var/log/Bigdata/dbservice/healthCheck/dbservice_processCheck.log. It is found that GaussDB is abnormal.
   Figure 1 GaussDB exception
   
2. The check result shows that the permission on the /tmp directory is incorrect.
   Figure 2 /tmp permission
   

Solution

1. Run the following command to modify the /tmp permission:

   chmod 1777 /tmp

2. Wait until the instance status recovers.