ALM-27005 Database Connections Usage Exceeds the Threshold

1. On FusionInsight Manager, click DBService in the service list on the left navigation pane. The DBService monitoring page is displayed.
2. Observe the number of connections used by the database user, as shown in Figure 1. Based on the service scenario, reduce the number of database user connections.
   Figure 1 Number of connections used by database users
   

3. Wait for 2 minutes and check whether the alarm is automatically cleared.
   • If it is, no further action is required.
   • If it is not, go to 4.

Checking whether the maximum number of database connections is properly configured

4. Log in to FusionInsight Manager, choose Cluster > Name of the desired cluster > Services > DBService > Configurations. On the displayed page, select the All Configurations tab, and increase the maximum number of database connections based on service requirements, as shown in Figure 2. Click Save. In the displayed Save configuration dialog box, click OK.
   Figure 2 Setting the maximum number of database connections
   

5. After the maximum number of database connections is changed, restart DBService (do not restart the upper-layer services).

   Procedure: Log in to FusionInsight Manager and choose Cluster > Name of the desired cluster > Services > DBService. On the displayed page, choose More > Restart Service. Enter the password of the current login user and click OK. Do not select Restart upper-layer services., click OK.

6. After the service is restarted, wait for 2 minutes and check whether the alarm is cleared.
   • If it is, no further action is required.
   • If it is not, go to 7.

Checking whether the alarm threshold or trigger count is properly configured

7. Log in to FusionInsight Manager and change the alarm threshold and alarm trigger count based on the actual database connection usage.

   Choose O&M> Alarm > Thresholds > Name of the desired cluster > DBService > Database > Database Connections Usage (DBServer). In the Database Connections Usage (DBServer) area, click the pencil icon next to Trigger Count. In the displayed dialog box, change the trigger count, as shown in Figure 3.

   

   Trigger Count: If the usage of the number of database connections exceeds the threshold consecutively for more than the value of this parameter, an alarm is generated.

   Figure 3 Setting alarm trigger count
   

   Based on the actual database connection usage, choose O&M >Alarm > Thresholds > Name of the desired cluster > DBService > Database > Database Connections Usage (DBServer). In the Database Connections Usage (DBServer) area, click Modify in the Operation column. In the Modify Rule dialog box, modify the required parameters and click OK as shown in Figure 4.

   Figure 4 Set alarm threshold
   

8. Wait for 2 minutes and check whether the alarm is automatically cleared.
   • If it is, no further action is required.
   • If it is not, go to 9.

Collect fault information

9. On FusionInsight Manager, choose O&M > Log > Download.
10. Select DBService in the required cluster from the Service.
11. Specify the host for collecting logs by setting the Host parameter that is optional. By default, all hosts are selected.
12. Click in the upper right corner, and set Start Date and End Date for log collection to 10 minutes ahead of and after the alarm generation time, respectively. Then, click Download.
13. Contact the O&M personnel and send the collected fault logs.