No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

HUAWEI CLOUD Stack 6.5.0 Alarm and Event Reference 04

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
ALM-2000461 GaussdbHA_role_changed

ALM-2000461 GaussdbHA_role_changed

Description

This alarm is generated when an active/standby switchover occurs on the database nodes.

Attributes

Alarm ID

Alarm Severity

Auto Clear

2000461

Minor

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

Data in recent periods

Threshold

Threshold for generating an alarm

Impact on the System

Usually, an active/standby switchover does not adversely affect the database system. However, if the switchover occurs because the active database node is faulty, you must restore the node as soon as possible to avoid any database reliability downgrade.

Possible Causes

A database exception is caused by network or disk faults, or software defects.

Procedure

  1. 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#$

  2. On the menu bar in the upper part of the page, choose Alarms > Current Alarms.
  3. In the alarm list, locate the alarm to be handled, and click on the left of the alarm. The Details page is displayed.
  4. Choose Location Info, obtain the host IP address, that is, the IP address of the node where the alarm is generated.
  5. 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 hermes. The default password is Hermes@123.

  6. 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 - root

  7. Run the following command to disable user logout upon system timeout:

    TMOUT=0

  8. Run the following commands to check the database status:

    source /etc/profile

    service gaussdb query

    If information similar to the following is displayed, ignore it.

     Ha state:           
    	LOCAL_ROLE                     : Primary
    	STATIC_CONNECTIONS             : 1
    	DB_STATE                       : Normal
    	DETAIL_INFORMATION             : Normal
     Senders info:       
    	SENDER_PID                     : 22772
    	LOCAL_ROLE                     : Primary
    	PEER_ROLE                      : Standby
    	PEER_STATE                     : Normal
    	STATE                          : streaming
    	SENDER_SENT_LOCATION           : 0/B71326C8
    	SENDER_WRITE_LOCATION          : 0/B71326C8
    	SENDER_FLUSH_LOCATION          : 0/B71326C8
    	SENDER_REPLAY_LOCATION         : 0/B71326C8
    	RECEIVER_RECEIVED_LOCATION     : 0/B71326C8
    	RECEIVER_WRITE_LOCATION        : 0/B71326C8
    	RECEIVER_FLUSH_LOCATION        : 0/B71326C8
    	RECEIVER_REPLAY_LOCATION       : 0/B712D138
    	SYNC_PERCENT                   : 99%
    	SYNC_STATE                     : async
    	SYNC_PRIORITY                  : 0
            CHANNEL                        : 192.168.0.0-->192.168.1.0
     Receiver info:      
    	No information 

  9. Run the following command to view database logs and contact technical support to analyze the cause of the active/standby switchover:

    vim /var/log/postgresql/gs_ctl-current.log

Alarm Clearance

The system automatically clears the alarm after the fault is rectified.

Reference

None

Translation
Download
Updated: 2019-08-30

Document ID: EDOC1100062365

Views: 35960

Downloads: 31

Average rating:
This Document Applies to these Products
Related Version
Related Documents
Share
Previous Next