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 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).
Abnormal Slave DatabaseInstances

Abnormal Slave DatabaseInstances

Symptom

The master database instance is normal and the slave database instance is abnormal. Gauss and Redis directories, as well as physical files of the slave database instance are lost.

Fault Locating
  1. Use PuTTY to Log in to the standby nodes where database instance resides.

    The default username is paas, and the default password is QAZ2wsx@123!.

  2. Run the following commands to check whether the instance file is lost:

    cd /opt/

    ll

  3. Check whether the Gauss or Redis directory exists.

Troubleshooting

Initial Installation of Database Software
Re-creating the Slave Database Instance
Procedure
  1. Use PuTTY to log in to the slave database node as the paas user.

    The default username is paas, and the default password is QAZ2wsx@123!.

  2. Run following commands to recreate the database:

    cd /opt/paas/oss/manager/apps/DBAgent/bin

    ./dbsvc_tool -cmd repair-db-node -type gauss

    Information similar to the following is displayed:

     success
    NOTE:
    • When recreating slave database, the database process whose slave instance has been lost must be stopped.
    • type indicates the database type to be restored. If the database is Redis, run the following command instead:

      ./dbsvc_tool -cmd repair-db-node -type redis

    • success indicates that the database instance is restored successfully.

  3. Check whether the status of the slave database node instance is normal.

    • If yes, no further operation is required.
    • If no, go to 4.

  4. For details, see Abnormal Replication State of Slave Database Instance.

    NOTE:

    If database instance is abnormal because the standby instance directories are lost, run the ./dbsvc_tool -cmd repair-db-node -type gauss command on the slave instance node, and then rectify based on the replication of the slave database instance.

Verification
  1. Use PuTTY to log in to the manage_db1_ip node.

    The default username is paas, and the default password is QAZ2wsx@123!.

  2. Run the following commands to check information about database:

    cd /opt/paas/oss/manager/apps/DBAgent/bin

    ./dbsvc_adm -cmd query-db-instance | grep gauss

    Information similar to the following is displayed:

    DBInstanceId                                  ClassId  InstNumber                    Tenant          IP             Port   State  DBType  Version            Role    Rpl Status  MasterID                      GuardMode  DataCheckSum  isSSL
    apmdbsvr-10_186_66_155-1@10_186_67_174-1      primary  apmdbsvr-10_186_66_155-1      fst-manage      10.186.66.155  32081  Up     gauss   V100R003C20SPC112  Master  Normal      --                            --         1520954391    off
    apmdbsvr-10_186_66_155-1@10_186_67_174-1      primary  apmdbsvr-10_186_67_174-1      fst-manage      10.186.67.174  32081  Up     gauss   V100R003C20SPC112  Slave   Normal      apmdbsvr-10_186_66_155-1      --         1520954391    off

    You only need to pay attention to the value of Rpl Status.

    If the statuses of Master and Slave are Normal, the database is running properly.

    If the statues are abnormal, contact technical support.

Translation
Download
Updated: 2019-06-01

Document ID: EDOC1100062375

Views: 1663

Downloads: 12

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