EX SSL-VPN: Upgrade to 10.6.4 or 10.7.x failing with database errors.
Upgrade of firware version to 10.6.4 or 10.7.0 or later failing with database errors. It has been observed that stale database records do not get cleared in turn fails to complete upgrade process.
Snippet of upgrade.log Pruning mysql-10.0.1-080 .. Pruning large tables Unable to start MySQL daemon pointed at /var/log/mysql-10.0.1-080 /tmp/mysql.14630 [ 2:48] ERROR: An install-time configuration step failed. ERROR: An install-time configuration step failed. [ 2:48] ERROR. Failed to initialize next appliance image. Exiting. [ 2:48] Restoring existing appliance databases...
Resolution or Workaround:
SonicWall Engineering have identified that the issue is more likely to be reported on customer devices which were initially running on 10.0.x code or 10.5.x code before migrating to 10.6.x. The newer code fix has the capability to clear / purge database of version 10.5.x, 10.6.x or later. For any stale databases on the appliance with 10.0.x have to be manually deleted.
SSH to the appliance.
# rm -rf /var/log/mysql-10.0.x
1) It is recommended to contact SonicWall Technical Support team to assure that the upgrade failure noticed is smilar to the identfied issue. 2) Deleting or modifying any script is recommended to be done with help of SonicWall Technical Support team. 3) Deleting of files / database might cause the device failing or lead to Unresponsive state.
On post deletion of such stale database logs / entries help in succeeding the upgrading of firmware.