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

Symptom

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.