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-73405 Number of GaussDB Connections Exceeds the Threshold

ALM-73405 Number of GaussDB Connections Exceeds the Threshold

Description

The number of connections to the GaussDB server is limited. This alarm is generated when the number of GaussDB connections for a component exceeds 90% of the upper limit. This alarm is automatically cleared when the number of connections reduces to 85% of the upper limit.

Attribute

Alarm ID

Alarm Severity

Auto Clear

73405

Major

Yes

Parameters

Name

Meaning

Fault Location Info

component: specifies the name of the component for which the alarm is generated.

Additional Info

  • detail_info: provides detailed information about the alarm.
  • host_id: specifies the ID of the host for which the alarm is generated.
  • hostname: specifies the name of the host for which the alarm is generated.

Impact on the System

When this alarm is generated, the number of GaussDB connections is close to the upper limit, but no adverse impact is exerted on the system. If the number of connections keeps increasing, users will fail to set up new connections to the GaussDB database.

Possible Causes

  • Excessive service requests are being issued.
  • The configured number of connections does not meet service requirements.

Procedure

  1. Check whether a large number of service operations are being performed.

    • If yes, go to 2.
    • If no, go to 3.

  2. Reduce the number of service operations. After 1 to 3 minutes, check whether this alarm is cleared.

    • If yes, go to 3.
    • If no, go to 9.

  3. If the service requests keep increasing, check whether this alarm is frequently generated.

    • If yes, increase the maximum number of connections allowed to meet service requirements. Go to 4.
    • If no, no further action is required.

  4. Use PuTTY to log in to the first FusionSphere OpenStack node through the IP address of the External OM plane.

    The default user name is fsp. The default password is Huawei@CLOUD8.

    The system supports both password and public-private key pair for identity authentication. If the public-private key pair is used for login authentication, see detailed operations in Using PuTTY to Log In to a Node in Key Pair Authentication Mode.

    NOTE:
    To obtain the IP address of the External OM plane, search for the required parameter on the Tool-generated IP Parameters sheet of the xxx_export_all.xlsm file exported from HUAWEI CLOUD Stack Deploy during software installation. The parameter names in different scenarios are as follows:
    • Region Type I scenario:

      Cascading system: Cascading-ExternalOM-Reverse-Proxy

      Cascaded system: Cascaded-ExternalOM-Reverse-Proxy

    • Region Type II and Region Type III scenarios: ExternalOM-Reverse-Proxy

  5. Run the following command and enter the password of user root to switch to user root:

    su - root

    The default password of user root is Huawei@CLOUD8!.

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

    TMOUT=0

  7. Import environment variables. For details, see Importing Environment Variables.
  8. Modify the database configuration item.

    Run the following commands:

    cps template-params-update --service gaussdb gaussdb --parameter database_max_connections=$number;

    cps commit

    NOTE:

    number specifies the number of allowed connections. The default value is 800. You need to set this parameter to a larger value.

    Check whether the configuration item is successfully modified.

    • If yes, no further action is required.
    • If no, go to 9.

  9. Contact technical support for assistance.

Related Information

None

Translation
Download
Updated: 2019-08-30

Document ID: EDOC1100062365

Views: 47399

Downloads: 33

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