Got it

Frequent FusionCompute Login Failures

Latest reply: Feb 24, 2022 07:39:53 370 5 3 0 0

Hello everyone!


This post describes how to frequently log in to the FusionCompute portal due to HA exceptions caused by large operation logs.


ISSUE DESCRIPTION


We have a FusionAccess Desktop Cloud Solution 6.5.1. The FusionCompute portal cannot be opened frequently, affecting VM management. There are 4000 user VMs in total.


ISSUE ANALYSIS


1. Check whether port 8443 of FusionCompute is enabled.


2. Check whether the firewall is enabled between the local PC and the physical host.


Note

If you cannot log in to FusionCompute, check whether port 8443 is connected to the firewall. In this case, you can log in to FusionCompute sometimes, but sometimes you cannot log in to FusionCompute, so you don't need to perform steps 1 and 2.


3.  Log in to the active VRM node and run the service had query command to query the service status. The HA service is abnormal.


4. Run the below command to start the HA service:


service had start


5.  Check the HA logs. The below error information is found:


HA log


Based on the error information, it is suspected that the database is faulty. The possible causes are as follows:


  • the GaussDB partition is full;


  • the GaussDB table is too large and logs cannot be written.


6. Query the usage of each partition.


GaussDB


The command output shows that the space of the GaussDB partition is used up.


7.  Log in to /opt/gaussdb/data/base/* and check which file is large. The data in the following table indicates the specific tables in the database.


gaussdb


8. Log in to the database (psql –U galax –d vrm) and query the data tables in the database:


select * from pg_class where relfilenode=XXX;


select * from pg_class where relfilenode=XXX


In the same way, query other tables that occupy a large amount of space as operation log tables.


8. View the operation logs and historical logs.


8. View operation logs and historical logs.

The log file contains 813,000 records. The operation log file is deleted to release the GaussDB sector space.


SOLUTION


Clear the history before a certain date:


delete from tbl_history_task where CREATE_TIME < '20xx-xx-xx';


This is my solution, how about yours? Go ahead and share it with us!

  • x
  • convention:

MahMush
Moderator Author Created Feb 24, 2022 05:31:11

informative post
View more
  • x
  • convention:

olive.zhao
olive.zhao Created Feb 24, 2022 07:29:14 (0) (0)
Thanks!  
wissal
MVE Created Feb 24, 2022 06:40:31

Very well explained case!
View more
  • x
  • convention:

olive.zhao
olive.zhao Created Feb 24, 2022 07:29:24 (0) (0)
Learning together!  
little_fish
Admin Created Feb 24, 2022 07:39:53

Good case dear.
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.