Got it

Failed to upgrade ITA

Latest reply: Aug 5, 2022 17:22:51 108 6 4 0 0

Hello, everyone!

I want to share with you a case about the ITA failing to be upgraded, and the error message 'error code: 5149, database backup failed'.

Problem description

When the ITA is upgraded from 6.5.0 to 6.5.1, the error message "5149, Database backup failed" is displayed.

Problem analysis and Solution

1. Check the ITA upgrade log file /var/FusionAccess/ITA/patch.log. The error message "backup ITA database failed" is displayed.

ITA upgrade log

2. Check line 387 of upgradeobj.py. The DB_BACKUP.sh script is invoked (the path is /opt/ITA/patch/FusionAccess-ITA-Patch-651/FusionAccess-ITA-Patch/ita-patch/scripts/DB_BACKUP.sh).

DB_BACKUP.sh

3. Check the DB_BACKUP.sh script. The log is stored in /var/FusionAccess/ITA/Upgrade_ITA_DB.log. The error is that the SQL backup fails.

DB_BACKUP.sh

4. When the DB_BACKUP.sh script is manually executed, an error message is displayed indicating that the TBL_OUNAMEINFO_201909171514 table permission is denied.

The table name with a date is not the default name of the platform database. It is confirmed that the table name is manually created by users and can be deleted.

delete table

5. Log in to the master database, switch to the FusionAccess database, run the drop table command to delete the table created by the user, and click Upgrade again.

drop table TBL_OUNAMEINFO_XXX

delete table

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

The post is synchronized to: Huawei Cloud Computing Case

  • x
  • convention:

Helen.F
Created 5 days ago

Thanks for your sharing!
View more
  • x
  • convention:

olive.zhao
olive.zhao Created 5 days ago (0) (0)
 
hanhcao
Created 5 days ago

Good share
View more
  • x
  • convention:

olive.zhao
olive.zhao Created 5 days ago (0) (0)
Thanks!  
VinceD
Created 5 days ago

interesting content.
View more
  • x
  • convention:

Jackson.F
Jackson.F Created 2 days 01:08 (0) (0)
Thanks!  

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.