Actions

FN19497: Difference between revisions

No edit summary
No edit summary
Line 18: Line 18:
2- stop toolpack by shell command: tbtoolpack stop
2- stop toolpack by shell command: tbtoolpack stop
   [root@TB007036 ~]# tbtoolpack stop
   [root@TB007036 ~]# tbtoolpack stop
  0:tbtoolpack_12358
  0:tbtoolpack_12358
  Stopping tbtoolpack_12358:                                [  OK  ]
  Stopping tbtoolpack_12358:                                [  OK  ]
  Toolpack current state: Disconnected
  Toolpack current state: Disconnected
  Ok
  Ok


2- Drop both databases: toolpack_0 and toolpack_2_x
2- Drop both databases: toolpack_0 and toolpack_2_x
[root@TB007036 ~]# mysql -u tbdb -ptbdbpw
  [root@TB007036 ~]# mysql -u tbdb -ptbdbpw
Welcome to the MySQL monitor.  Commands end with ; or \g.
  Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 116
  Your MySQL connection id is 116
Server version: 5.1.47-log Source distribution
  Server version: 5.1.47-log Source distribution


Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
  Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
  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
  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.
  Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> drop database toolpack_0;
  mysql> drop database toolpack_0;
mysql> drop database toolpack_2_9;
  mysql> drop database toolpack_2_9;


3- Check the config files to make sure it is pointing to the new release.
3- Check the config files to make sure it is pointing to the new release.

Revision as of 14:20, 15 June 2016


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