ALM-12039 Active/Standby OMS Databases Not Synchronized

Alarm Description

The system checks the data synchronization status between the active and standby OMS Databases every 10 seconds. This alarm is generated when the synchronization status cannot be queried for 30 consecutive times or when the synchronization status is abnormal.

This alarm is cleared when the data synchronization status becomes normal.

Alarm Attributes

Alarm ID	Alarm Severity	Alarm Type	Service Type	Auto Cleared
12039	Major	Quality of service	FusionInsight Manager	Yes

Alarm Parameters

Type	Parameter	Description
Location Information	Source	Specifies the cluster or system for which the alarm is generated.
	ServiceName	Specifies the service for which the alarm is generated.
	RoleName	Specifies the role for which the alarm is generated.
	HostName	Specifies the host for which the alarm is generated.
Additional Information	Local GaussDB HA IP	Specifies the HA IP address of the local GaussDB.
	Peer GaussDB HA IP	Specifies the HA IP address of the peer GaussDB.
	SYNC_PERCENT	Specifies the synchronization percentage.

Impact on the System

If the active/standby of the OMS database is not synchronized, data in the active database cannot be synchronized to the standby database. If the active instance is abnormal during the alarm reporting period, service data may be lost or data on the FusionInsight Manager may be abnormal.

Possible Causes

The network between the active and standby nodes is unstable.
The standby OMS Database is abnormal.
The standby node disk space is full.

Handling Procedure

Check whether the network between the active and standby nodes is normal.

Log in to FusionInsight Manager, click O&M > Alarm > Alarms, click in the row where the alarm is located, and query the standby OMS Database IP address.
Log in to the active OMS Database node as user root.
Run the ping Standby OMS Database heartbeat IP address command to check whether the standby OMS Database node is reachable.
- If yes, go to 6.
- If no, go to 4.
Contact the network administrator to check whether the network is faulty.
- If yes, go to 5.
- If no, go to 6.
Rectify the network fault and check whether the alarm is cleared.
- If yes, no further action is required.
- If no, go to 6.

Check whether the standby OMS Database is normal.

Log in to the standby OMS Database node as user root.
Run the su - omm command to switch to user omm.
Go to the ${BIGDATA_HOME}/om-server/om/sbin/ directory and run the ./status-oms.sh command to check whether the OMS Database resource status of the standby DBService is normal. In the command output, check whether the following information is displayed in the row where ResName is gaussDB:

For example:
```
10_10_10_231 gaussDB Standby_normal Normal Active_standby
```
- If yes, go to 9.
- If no, go to 16.

Check whether the standby node disk space is full.

Log in to the standby OMS Database node as user root.
Run the su - omm command to switch to user omm.
Run the echo ${BIGDATA_DATA_HOME}/dbdata_om command to obtain the OMS Database data directory.
Run the df -h command to view the system disk partition usage information.
Check whether the disk where the OMS Database data directory is mounted is full.
- If yes, go to 14.
- If no, go to 16.
Expand the disk capacity.
After the disk capacity is expanded, wait 2 minutes and check whether the alarm is cleared.
- If yes, no further action is required.
- If no, go to 16.

Collect fault information.

On the FusionInsight Manager portal, choose O&M > Log > Download.
Select OMMServer from the Service and click OK.
Click in the upper right corner, and set Start Date and End Date for log collection to 10 minutes ahead of and after the alarm generation time, respectively. Then, click Download.
Contact the O&M engineers and send the collected log information.