ALM-1510006 GaussdbHA_upload_to_remote_backup_server_failed
Description
This alarm is generated when the database backup fails to upload to the SFTP server.
Attribute
Alarm ID |
Alarm Severity |
Auto Clear |
---|---|---|
1510006 |
Major |
Yes |
Parameters
Parameter |
Description |
|
---|---|---|
Location Info |
Resource name |
Name of the device for which the alarm is generated |
Resource type |
MONITOR |
|
Monitor type |
Service monitoring |
|
Host IP address |
IP address of the host |
|
Details |
Monitoring data in recent periods |
|
Threshold |
Threshold for generating an alarm |
Impact on the System
If the backup of the database fails to upload to the SFTP server, the database is faulty. In this case, no backup is available to restore data.
Possible Causes
The remote storage is abnormal.
Procedure
- Log in to ManageOne Maintenance Portal using a browser.
- URL: https://Address for accessing the homepage of ManageOne Maintenance Portal:31943, for example, https://oc.type.com:31943
- Default username: admin; default password: Huawei12#$
- On the menu bar in the upper part of the page, choose Alarms > Current Alarms.
- In the alarm list, locate the alarm to be handled, and click
on the left of the alarm. The Details page is displayed.
- Choose Location Info, obtain the host IP address, that is, the IP address of the node where the alarm is generated.
- Use PuTTY to log in to the node for which the alarm is generated. Ensure that the IP address of the node obtained in 4 is used to establish the connection.
The default username is gaussdb. The default password is Huawei@123.
- Run the following command and enter the password of the root user as prompted to switch to the root user (the default password is Cloud12#$):
sudo su
- Run the following command to disable user logout upon system timeout:
TMOUT=0
- Run the following command to check the failure causes:
cat /home/zabbix/dbAlarmData/backup_zabbix_alarm
If the following information is displayed, the backup file fails to upload to the remote storage server.b0(backup success)u1(upload fail)
- Check whether remote storage server is configured in the /opt/gaussdb/ha/tools/backupAndRestore/Upload_Server.cfg configuration file.
- If command output similar to that shown in Figure 16-1 is displayed, that is, the value of FTP_SERVER_IP is 127.0.0.1, the remote storage server is not configured. For details about how to configure a remote storage device, see section "Backup and Recovery" > "Unified Backup" > "Performing Unified Backup" > "Managing Backup Information" in HUAWEI CLOUD Stack 6.5.0 Backup and Restoration Guide.
- If the value of FTP_SERVER_IP is not 127.0.0.1, the remote storage server is configured. Check whether the configuration is correct.
Alarm Clearance
This alarm will be automatically cleared after the fault is rectified.
Reference
None