Symptom
A message is displayed indicating that a system backup or restoration operation is in progress during patch installation. Patch installation or upgrade cannot be performed.
On the page, the status of a backup task is always in progress and is not displayed as Completed or Failed.
Impact on Services
Patches or upgrades cannot be performed.
Identification Method
On the page, the status of a backup task is always in progress and is not displayed as Completed or Failed.
Emergency Operations
Step 1 Log in to the CSP OM portal, choose Application Configuration > Services, find the GaussDB container whose status is M, and copy the value of podName.
Step 2 Choose Resource Management > Edge Site Management > Containers and find the node where the pod is located based on the value of podName.
Step 3 Use an SSH tool to log in to the external IP address of the node in step 2 as user cspexpert and switch to user root.
Step 4 Run the following command to access the backup service database of the GaussDB container:
cid=$(docker ps | grep cspgauss | grep -vgrep | awk -F " " '{print $1}') ;docker exec -it -u root ${cid} su - dbuser -c "gsql -d backupdb -U backupdbuser -p 22080 -WCspdbg@2017"
Step 5 Manually end the backup task.
update TBL_BACKUP_TASK SETBACKUPSTATUS='Failed'where TASKNAME='autobackup20191015142911';
Note: autobackup20191015142911 is the name of the backup task. Replace it with the name of the task that fails to be backed up.
Run the following command to exit the database:
\q
Step 6 Retry the patch or upgrade on the portal.
