Got it

Failed to Delete a VDC on the ServiceCenter

Latest reply: Feb 1, 2022 10:44:15 941 9 4 0 0

Hello, everyone!

This case describes how to solve the problem that a VDC cannot be deleted and a message is displayed indicating that resources are occupied.

Symptom

The VDC fails to be deleted on the SC page, and a message is displayed indicating that resources are occupied. Or the project fails to be deleted, and a message is displayed indicating that resources are occupied.

Applicable Version

FusionCloud 6.3.X version

Cause

The possible causes are as follows:
1. Cloud service problems
2. The cloud service resources are manually deleted from the background.
3. Resources are deleted from the OM.


Fault Locating

Check cloud service information.
1. Collect the total quota usage of the target cloud service under the project under the cloud service page. (In case 2, only resources that are not created in the cloud service page or recycle bin need to be confirmed.)
2. Query the project ID of the project in the VDC on the operation side. (You can select project ID in the upper right corner of the project list on the project management page.) VDCID (You can query the VDC name on the page and run select * from vdcs where name=''; In the VDCS table in the database.)
3. Log in to the deployment plane, relational database, and query the IP address of the tenant master database node.

4. Log in to the server using the IP address. The user name and password are as follows: dbuser /Y7xohbheY!
After the login is successful, run the following command:
/opt/mysql/bin/mysql -udbuser -p 'Admin@123' -S /opt/mysql/data/tenantdbsvr*/*sock
Run the following command:
use movdcservicedb;
The VDC service database has been deployed.
Run the following command:
1) select * from vdc_quota_usages where vdc_id =' 'and project_id ='' and service_id =''; (vdc_id and project_id are queried in step 2. The service_id cloud host is ecs, the EVS disk is evs.

And the VPC is vpc. You can also use select * from vdc_quota_usages where vdc_id ='' and project_id =' '.) obtain the service_id) of the cloud service in the VDC.
Obtain the query result and check whether the sum of the positive and negative values of the used field in the same resource (quota) field is the same as that on the VDC page. (This step is performed to check the resource usage of the problem VDC and problem project. In addition, obtain the resource (quota) field value from the query result for future use.)
2) update vdc_quota_usages set used = where vdc_id =' 'and project_id ='' and service_id =' 'and resource ='' and..... (The and conditions can be added as required to locate the record to be modified. Exercise caution when performing this operation. Otherwise, many records may be modified .).
In case 1, run the SQL2 command to change the used value of one or more records to ensure that the value of used is the same as the quota of the cloud service.
In case 2, run the SQL2 command to change the used value of one or more records to 0.
You are advised to back up data before running the update statement.
After the execution is complete, refresh the page on the operation side to check whether the target is reached.
That's all, thanks!

The post is synchronized to: Huawei Cloud Computing Case

  • x
  • convention:

VinceD
Created Oct 23, 2021 07:23:44

nice content.
View more
  • x
  • convention:

VinceD
VinceD Created Oct 23, 2021 07:23:53 (0) (0)
 
MahMush
Moderator Author Created Nov 26, 2021 11:30:16

thanks for sharing such a informative content
View more
  • x
  • convention:

MahMush
Moderator Author Created Nov 30, 2021 08:14:02

please more detailed must written on it..so helpful for all
View more
  • x
  • convention:

olive.zhao
olive.zhao Created Feb 16, 2022 00:39:13 (0) (0)
Yes, I will do it.  
Unicef
MVE Created Feb 1, 2022 03:00:33

COOL
View more
  • x
  • convention:

kita
Created Feb 1, 2022 10:35:48

Great share
View more
  • x
  • convention:

Saqibaz
Created Feb 1, 2022 10:44:15

Thanks for sharing
View more
  • x
  • convention:

olive.zhao
olive.zhao Created Feb 16, 2022 00:38:44 (0) (0)
 

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.