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-37015 Available File Handles of the GaussDB Process Are Insufficient

ALM-37015 Available File Handles of the GaussDB Process Are Insufficient

Description

This alarm is generated when the available file handles of the operating system are insufficient.

Attribute

Alarm ID

Alarm Severity

Auto Clear

37015

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.

Impact on the System

If available file handles are insufficient, some instances may fail to be started and the cluster cannot be started accordingly.

Possible Causes

The available file handles of the operating system are insufficient.

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. Log in to the node where the alarm is generated as the omm user.

    Default user: omm, default password: Bigdata123@.

  4. Run the following command to initialize the environment variables.

    source ${BIGDATA_HOME}/mppdb/.mppdbgs_profile

  5. Run the following command to connect to the database.

    gsql -d postgres -p 25308

  6. Run the following command to check whether the value of max_files_per_process is less than the default value 3000.

    SHOW max_files_per_process;

    The following information is displayed.

     max_files_per_process 
    -----------------------
     2000
    (1 row)
    • If yes, go to 7.
    • If no, go to 9.

  7. Run the following command to change the value of max_files_per_process to 3000.

    \q

    gs_guc set -Z coordinator -Z datanode -N all -I all -c 'max_files_per_process=3000'

  8. Run the following command to restart the cluster.

    gs_om -t stop

    gs_om -t start

  9. Check whether the available file handles of the operating system are sufficient. If the available file handles are insufficient, stop the processes that occupy many file handles but are not related to the database.

    NOTE:
    Run the following command to check the number of file handles configured for the operating system and the number of file handles that are opened by each process. In the following command output, the first column indicates the number of opened file handles and the second column indicates the process PID. You can stop some unnecessary processes that occupy many file handles.
    # cat /proc/sys/fs/file-max
    782799
    
    # lsof -n|awk '{print $2"\t"$1}'|sort|uniq -c|sort -nr|more
    
    131    24204    gaussdb
    
    57     24244    cleanup
    
    57     24231    cm_agent

  10. Wait for a while and check whether the alarm persists.

    • If yes, go to 11.
    • 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: 36725

Downloads: 31

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