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

FusionCloud 6.3.1.1 Troubleshooting Guide 02

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).
Database Faults

Database Faults

This chapter describes causes of database abnormalities and how to handle the abnormalities.

The Active/Standby States of GaussDB Nodes Are Abnormal

Symptom

The backup service is unavailable.

Possible Causes
  • The user waits for more than 10 minutes after the user stops services on all nodes or GaussDB nodes are powered off unexpectedly. Then, services on the active GaussDB node cannot be restarted properly.
  • The time difference is greater than 10 minutes after the system time is changed. Services on the active GaussDB node cannot be restarted properly.
Procedure
  1. Use PuTTY to log in to any Service-CSBS node through the IP address corresponding to the CSBS_Service field.

    The default account and password are djmanager and CloudService@123!, respectively.

  2. Run the following command and enter the root account's password to switch to the root account.

    su root

    The default password of the root account is Cloud12#$.

  3. Run the following command, and determine the two nodes where omm-ha is running according to the command output.

    show_service --service omm-ha

    The command output is as follows:

    [root@localhost ~]# show_service --service omm-ha 
    +--------------+---------+---------+------------+ 
    |  instanceid  | service | status  | runsonhost | 
    +--------------+---------+---------+------------+ 
    |karbor2_omm-ha| omm-ha  | active  |  karbor1   | 
    |karbor1_omm-ha| omm-ha  | standby |  karbor2   | 
    +--------------+---------+---------+------------+ 

  4. Log in to the two nodes where omm-ha is running. Run the following command to check the last online time of GaussDB.

    bash /usr/local/bin/ha/ha/config_script/sync_monitor.sh get_status

    The command output is as follows:

    [root@localhost ~]# bash /usr/local/bin/ha/ha/config_script/sync_monitor.sh get_status 
    DB last online role : Standby 
    DB last online time : 2018-04-21 19:14:252.      

  5. Compare the last online time of GaussDB on each node obtained in 4 with the current time.

    • If the time differences are not greater than 10 minutes=>go to 7.
    • If the time differences are greater than 10 minutes=>go to 6.

  6. Determine the active GaussDB node according to the command output in 4.

    • If the roles of the two nodes are Primary and Standby, the node with the role Primary is the active GaussDB node.
    • If the roles of both nodes are Primary, calculate the time difference between the last online time of GaussDB on each node and the current time. The node with a shorter time difference is the active GaussDB node.

  7. Run the following command on the active GaussDB node to perform an active/standby switchover for omm-ha.

    bash /usr/local/bin/ha/ha/config_script/sync_monitor.sh reset_status

  8. Wait 2 minutes and run the following command on the active and standby GaussDB nodes, respectively. View the logs and check whether Karbor services are normal.

    cat /var/log/huawei/dj/services/system/gaussdb/gs_ctl-current.log

    If the command output is as shown in Figure 17-2 and Figure Figure 17-3, no further action is required. Otherwise, contact technical support engineers.

    Figure 17-2 Active GaussDB service log
    Figure 17-3 Standby GaussDB service log

Translation
Download
Updated: 2019-06-10

Document ID: EDOC1100063248

Views: 22583

Downloads: 37

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