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-37018 User Is Connected to Excessive Databases

ALM-37018 User Is Connected to Excessive Databases

Description

This alarm is generated when a user is connected to excessive databases on a Coordinator instance.

Attribute

Alarm ID

Alarm Severity

Auto Clear

37018

Major

Yes

Parameters

Name

Meaning

ServiceName

Identifies the service for which the alarm is generated.

RoleName

Identifies the role for which the alarm is generated.

HostName

Identifies the host for which the alarm is generated.

Instance

Identifies the instance for which the alarm is generated.

databaseName

Identifies the name of the database to connect to.

dbUserName

Identifies the name of users connected to a database.

Impact on the System

When the user is connected to excessive databases, the user cannot access the Coordinator instance.

Possible Causes

The user is connected to excessive databases on the Coordinator instance.

Procedure

  1. Log in to the FusionInsight Manager.

    1. Log in to the ManageOne OM plane using a browser, then choose Alarms.
      • Login address: https://URL for the homepage of the ManageOne OM plane:31943. Example: https://oc.type.com:31943.
      • Default username: admin, default password: Huawei12#$.
    2. In the alarm list, locate and click the target alarm name in the Name column. The Alarm Details and Handling Recommendations dialog box is displayed.
    3. Locate the value in the IP Address/URL/Domain Name column, which is the float IP address of the FusionInsight Manager.
    4. Log in to the FusionInsight Manager using a browser.
      • Login address: https://float IP address of the FusionInsight Manager:28443/web. Example: https://10.10.192.100:28443/web.
      • Default username: admin, default password: obtain it from the system administrator.

  2. On FusionInsight Manager, click Alarms. On the alarm list, locate the alarm and obtain the information about the node and instance for which the alarm is generated from Location in the Alarm Details area.
  3. Run the following command to access the Coordinator instance for which the alarm is reported as the database administrator (for example, user omm), who has the permission to create other database users. Default user: omm, default password: Bigdata123@.

    gsql -d postgres -p 25308

  4. Check the maximum number of databases a user can be connected to on the Coordinator instance. It can be seen that a maximum of three databases can be connected by user gaussdba on the Coordinator instance.

    select * from pg_authid;
    rolname   | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcatupdate | rolcanlogin | rolreplication | rolauditadmin | rolsystemadmin | rolconnlimit |                                                                          
                        rolpassword                                                                                               | rolvaliduntil 
    -------------+----------+------------+---------------+-------------+--------------+-------------+----------------+---------------+----------------+--------------+--------------------------------------------------------------------------
    ------------------------------------------------------------------------------------------------------------------------------+---------------
     gaussdba | t        | t          | t             | t           | t            | t           | t              | t             | t              |            3 | sha2567cee5d311c1e21e84671a2f2e1d8023f1990b4fa7c5656e44277acd3087e2c7fc74
    224dbb26375c88c91c9007af78fb1e5212656ec482957bf8fe8ce383b0f59d3ae6152aa0009ee46271d0446eb8cd0d0e461b09c17f93449c14d4c75238b3d | 
    (1 row)

  5. To clear the alarm, stop some databases or increase the number of databases that can be connected by a user. Perform the following operations to increase the number of databases.

    alter role gaussdba CONNECTION LIMIT 9;

    ALTER ROLE
    select * from pg_authid;
    rolname   | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcatupdate | rolcanlogin | rolreplication | rolauditadmin | rolsystemadmin | rolconnlimit |                                                                          
                        rolpassword                                                                                               | rolvaliduntil 
    -------------+----------+------------+---------------+-------------+--------------+-------------+----------------+---------------+----------------+--------------+--------------------------------------------------------------------------
    ------------------------------------------------------------------------------------------------------------------------------+---------------
     gaussdba | t        | t          | t             | t           | t            | t           | t              | t             | t              |            9 | sha2567cee5d311c1e21e84671a2f2e1d8023f1990b4fa7c5656e44277acd3087e2c7fc74
    224dbb26375c88c91c9007af78fb1e5212656ec482957bf8fe8ce383b0f59d3ae6152aa0009ee46271d0446eb8cd0d0e461b09c17f93449c14d4c75238b3d | 
    (1 row)

  6. Connect to the database as user gaussdba and check whether the alarm persists.

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

Collect fault information.

  1. On FusionInsight Manager, choose System > Log Download.
  2. Select MPPDB from the Services drop-down list box and click OK.
  3. Set Start Time for log collection to 1 hour ahead of the alarm generation time and End Time to 1 hour after the alarm generation time, and click Download.
  4. Contact Technical Support and send the collected logs.

Alarm Clearing

After the fault is rectified, the system automatically clears this alarm.

Related Information

None

Translation
Download
Updated: 2019-08-30

Document ID: EDOC1100062365

Views: 49429

Downloads: 33

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