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>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

Saudi Arabia --- Jeddah Municipality --- IT --- FusionAccess --- Database Table Size Exceeds the Threshold!!!

Publication Date:  2017-11-03 Views:  27 Downloads:  0
Issue Description
The customer found that there are some constant alarms on his FusionAccess. the alarm prompted :,Database Table Size Exceeds the Threshold.
and he reflect that refreshing page on FusionAccess portal and action which users log into VMS from WI are slow.
Alarm Information

Database Table Size Exceeds the Threshold.

Handling Process

 

1Log in to the database, view the database table monitoring log /var/FusionAccess/GaussDB/tableSpaceMonitor.log



2Found that there are two tables tbl_userconnection and tbl_instances very large


3Query the database where the two tables are HDCDB, use the command gsql-d hdcdb-u fauser login database.

4Execute the command: vacuum full tbl_instances; vacuum full tbl_userconnection; clean and shrink the data table.


Root Cause

there is a lot of garbage in database, and the database garbage collection process is not started.

Solution

According to the alarm handling manual, manually clean up the garbage and release the database space.
this is guide: http://support.huawei.com/hedex/hdx.do?docid=EDOC1000094520&lang=en&tocURL=resources/04_desk_r6c00/alarm/alarm/cn_59_42_000204.html

END