> For the complete documentation index, see [llms.txt](https://prosbcdocs.telcobridges.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://prosbcdocs.telcobridges.com/telecom-references/apis-and-integration/fn19497-major-release-upgrade-fail-if-the-database-have-data-upgraded-from-a-newer-major-release.md). # FN19497 - Major release upgrade fail if the database have data upgraded from a newer major release ## Affected Products * TMG800, TMG3200, TMG7800-CTRL running Toolpack software older than rel2.7.176 ## Problem Description Importing a database from a system running a newer major release to a older major release is not supported (e.g. import a database from a system running 2.9 to 2.7). Previous to release 2.7.176, there was no mechanism in the web portal to prevent such action. From 2.7.176 onward, the validation and recover now block such action. However, upgrading a system to a newer version which have a database imported from a newer major release system, will result in a failure of the upgrade. ### How to get into the issue * Import a database backup from a newer major release to an older release previous to 2.7.176. e.g. Import a database backup from rel2.9 to a TMG which is running rel2.7.175 (or older) * Validate/Recover the database backup (validation and recover would be performed) ### System database backup recover Each time a database backup is recovered, the system proceed to the following actions: * perform an automatic backup of the actual database (under Backups->Automatic database backups) * erase the actual database and replace it by the new database (recovered) * proceed to the database data upgrade to match the actual system's version ### How to validate your system database | Release | Database Name | Unique data upgrade number | | ----------- | -------------- | -------------------------- | | Release 2.6 | toolpack\_0 | 3 | | Release 2.7 | toolpack\_0 | 15 | | Release 2.8 | toolpack\_2\_8 | 44 | | Release 2.9 | toolpack\_2\_9 | 57 | 1. mysql -u tbdb -ptbdbpw -e "select \* from database\_name.current\_data\_upgrades order by CAST(id as SIGNED INTEGER) asc;" To make sure your system does not run with a newer version database, you can look at the database data upgrades table and make sure that is does not include upgrades from newer releases. Note that some upgrade number are common to more than one release, for example the upgrade number '61', '63', '73', etc.. are common to both 2.8 and 2.9 releases. The table above provides unique data upgrade for a particular major release. For example, the data upgrade '57' can only be found if the database data have been upgraded from a 2.9 system. For, example, if your system runs release 2.8, in the command above replace *database\_name* by "toolpack\_2\_8" to get the list of upgrades performed on your database: 1. mysql -u tbdb -ptbdbpw -e "select \* from toolpack\_2\_8.current\_data\_upgrades order by CAST(id as SIGNED INTEGER) asc;" \[root\@TB013496 \~]# mysql -u tbdb -ptbdbpw -e "select \* from toolpack\_2\_8.current\_data\_upgrades order by CAST(id as SIGNED INTEGER) asc;" +----+-----------------------------------------------------------------------------------------------------------------------+ | id | description | +----+-----------------------------------------------------------------------------------------------------------------------+ | 0 | Move fax behavior enable to profiles and fix default passthrough detection type. | | 1 | Remove unique constraint on gateway configurations for RADIUS server configurations. | | 2 | Remove the USING BTREE attribute from the RADIUS server configurations table. | | 3 | Change the RADIUS dictionary for attributes 1-29. | | 4 | Re-use the value from field nat\_traversal as the new remote\_nat\_traversal\_method\_id on table nap\_sip\_cfgs | | 5 | Update the RADIUS dictionary to add attributes (30-33). | ... | 44 | Create the default tone definition profiles. | | 45 | Create custom tone definition profiles with current data. | | 46 | Update the RADIUS dictionary to modify attributes (changed RemoteIp/RemotePort). | | 48 | Re-generate some unique ids that were previously improperly generated. | | 49 | Clear old relation between ip\_interfaces and virtual\_adapters | | 55 | Update the default tone definition profiles (No change. Needed to fix tone definitions truncated at 256 characters ). | | 61 | Fill reason cause action in profile cause maps | | 63 | Update the default tone definition profiles (re-apply default values) | | 73 | Update the RADIUS dictionary to add attribute (CollectedDigits). | | 77 | Fixed radius associated\_server column which could point to another configuration after copy | | 78 | Generate UniqueID for host configurations | | 79 | Update the cause maps for SIP redirect (release 2.8 only) | | 80 | Update the default tone definition profiles (fixed some profiles). | | 84 | Fix leaked timeslots pointing to mtp2 links but wrong line service | | 86 | Fix leaked NAP columns and custom Route Columns | +----+-----------------------------------------------------------------------------------------------------------------------+ In the example above, you can find the data upgrade number '44' in the list, which indicate that the data of this database have been upgraded by a 2.8 system. However, the data upgrade number '57' is not present, which meant that it was not upgrade by a 2.9 system. therefore, this is a valid database for a 2.8 system. If you find out data upgrades from a newer releases, you should: 1. Recover from a valid database backup of a previous or similar release. The backup could also be imported from another system. 2. Since there is no conversion tools to migrate the data from a newer release database to an older release, you might have to manually reconfigure some items in your system (missing parts that was configured on your newer release database or that you have configured since you imported the newer release database on your system) ### Problem Symptoms If your database data have been previously upgraded by a newer release, performing a major upgrade on your system would lead to a failure of the software release upgrade. * Software release upgrade fails, always switch back to the old version * tboamapp logs would shows database\_upgrade: \[FAIL] ERROR: data upgrade 26 failed: ERROR: data upgrade 26 and your system would not switch to the latest ## Solution If your database was previously upgraded from a newer release (as described above) and you inadvertently upgraded your system to a newer software release which ended by a failure, you must recover your database with one from the release your were running previous to the upgrade. You can look for an automatic backup in Backups (web portal) and recover from it. For example, lets say your database was recovered from a 2.9 system on a 2.7 system and you upgraded to the software release 2.8. After you activated the package 2.8, the system would report a failure and fall back on 2.7 (if running 2.7.148 onward). Here is the steps you should follow: 1. Recover from a valid 2.7 database backup or a previous release backup. Skip to steps 4a or 4b. If for some reason you can't recover a valid database, erase the databases to force the system to create new ones: 2. ssh to your TMG host 3. Drop the 2.7 database (toolpack\_0) and the 2.8 database (toolpack\_2\_8): 4. tbtoolpack stop 5. mysql -u tbdb -ptbdbpw -e "drop database toolpack\_0;" 6. mysql -u tbdb -ptbdbpw -e "drop database toolpack\_2\_8;" 4a. If you **upgrade from a release previous to 2.7.148**, you must follow the instruction below: 1. tbtoolpack stop Edit the following file with "vi": ``` vi /lib/tb/toolpack/setup/12358/service/config.txt ``` Make sure that the 'application=' line contain '2.8'. ``` application= /lib/tb/toolpack/setup/12358/2.8/apps/tboamapp/tboamapp_wd_cfg.ini ``` Restart toolpack 1. tbtoolpack start 4b. If you upgrade from a release supporting major release upgrade from the web (**2.7.148 and above**), you must follow the instruction below: Restart toolpack 1. tbtoolpack start From the Web portal, **activate package 2.8.** --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://prosbcdocs.telcobridges.com/telecom-references/apis-and-integration/fn19497-major-release-upgrade-fail-if-the-database-have-data-upgraded-from-a-newer-major-release.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.