FN19497
From TBwiki
(Difference between revisions)
Nicole Tan (Talk | contribs) |
Nicole Tan (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | {{DISPLAYTITLE:FN19497 - Procedure to Recover a Major Upgrade after Recovering | + | {{DISPLAYTITLE:FN19497 - Procedure to Recover a Major Upgrade after Recovering Database from Newer Version to Older Version }} |
= Affected Products = | = Affected Products = | ||
| − | * TMG800, TMG3200, TMG7800-CTRL | + | * TMG800, TMG3200, TMG7800-CTRL running Toolpack software older than rel2.7.176 |
| − | + | ||
| − | + | ||
= Problem Description = | = Problem Description = | ||
| − | * | + | * Import a database backup from a newer version to an older version. e.g. Imported a database backup from rel2.9 to a TMG which is running rel2.7.175 (or older) |
| − | + | * Validate/Recover the database | |
| − | + | * Do a major upgrade on the TMG | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
= Problem Symptoms = | = Problem Symptoms = | ||
| − | * | + | * Upgrade fails, always switch back to the old version |
| − | + | * tboamapp logs shows: | |
| − | + | database_upgrade: [FAIL] ERROR: data upgrade 26 failed: ERROR: data upgrade 26 | |
= Solution = | = Solution = | ||
| − | |||
| − | |||
| − | + | 1- ssh to the TMG host | |
| − | + | 2- stop toolpack by shell command: tbtoolpack stop | |
| − | + | [root@TB007036 ~]# tbtoolpack stop | |
| − | + | 0:tbtoolpack_12358 | |
| + | Stopping tbtoolpack_12358: [ OK ] | ||
| + | Toolpack current state: Disconnected | ||
| + | Ok | ||
| + | |||
| + | 2- Drop both databases: toolpack_0 and toolpack_2_x | ||
| + | [root@TB007036 ~]# mysql -u tbdb -ptbdbpw | ||
| + | Welcome to the MySQL monitor. Commands end with ; or \g. | ||
| + | Your MySQL connection id is 116 | ||
| + | Server version: 5.1.47-log Source distribution | ||
| + | |||
| + | Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. | ||
| + | This software comes with ABSOLUTELY NO WARRANTY. This is free software, | ||
| + | and you are welcome to modify and redistribute it under the GPL v2 license | ||
| + | |||
| + | Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. | ||
| + | |||
| + | mysql> drop database toolpack_0; | ||
| + | mysql> drop database toolpack_2_9; | ||
| + | |||
| + | 3- Check the config files to make sure it is pointing to the new release. | ||
| + | vi /lib/tb/toolpack/setup/12358/service/config.txt | ||
| − | + | application= /mnt/.0/tb/toolpack/setup/12358/2.9/apps/tboamapp/tboamapp_wd_cfg.ini | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | vi /mnt/.0/tb/toolpack/setup/12358/2.9/apps/tboamapp/tboamapp_wd_cfg.ini | |
| − | + | ||
| − | + | TB_PKG_PATH = /lib/tb/toolpack/pkg/2.9.41 | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | 4- Manually start toolpack on the newer release | |
| − | + | [root@TB007036 ~]# tbtoolpack start | |
| − | + | 0:tbtoolpack_12358 | |
| + | Starting tbtoolpack_12358: [ OK ] | ||
| + | Toolpack current state: Ready | ||
| + | Ok | ||
Revision as of 13:18, 15 June 2016
Contents |
Affected Products
- TMG800, TMG3200, TMG7800-CTRL running Toolpack software older than rel2.7.176
Problem Description
- Import a database backup from a newer version to an older version. e.g. Imported a database backup from rel2.9 to a TMG which is running rel2.7.175 (or older)
- Validate/Recover the database
- Do a major upgrade on the TMG
Problem Symptoms
- Upgrade fails, always switch back to the old version
- tboamapp logs shows:
database_upgrade: [FAIL] ERROR: data upgrade 26 failed: ERROR: data upgrade 26
Solution
1- ssh to the TMG host 2- stop toolpack by shell command: tbtoolpack stop [root@TB007036 ~]# tbtoolpack stop 0:tbtoolpack_12358 Stopping tbtoolpack_12358: [ OK ] Toolpack current state: Disconnected Ok
2- Drop both databases: toolpack_0 and toolpack_2_x [root@TB007036 ~]# mysql -u tbdb -ptbdbpw Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 116 Server version: 5.1.47-log Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> drop database toolpack_0; mysql> drop database toolpack_2_9;
3- Check the config files to make sure it is pointing to the new release. vi /lib/tb/toolpack/setup/12358/service/config.txt
application= /mnt/.0/tb/toolpack/setup/12358/2.9/apps/tboamapp/tboamapp_wd_cfg.ini
vi /mnt/.0/tb/toolpack/setup/12358/2.9/apps/tboamapp/tboamapp_wd_cfg.ini
TB_PKG_PATH = /lib/tb/toolpack/pkg/2.9.41
4- Manually start toolpack on the newer release [root@TB007036 ~]# tbtoolpack start 0:tbtoolpack_12358 Starting tbtoolpack_12358: [ OK ] Toolpack current state: Ready Ok
