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

Parameters

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