Symptoms
We try to upgrade MySQL in VPS from version 4 to version 5 using the guide http://download.pa.parallels.com/poa/5.4/doc/pdf/Installation/poa-service-upgrade-migration-guide-5.4.pdf
The following error is shown during upgrade:
# ./MySQL_ctl upgradeToMySQL5 upgradeVPS start 1464 /usr/local/pem/tmp | tee ~/mysql-1464-upgrade
DEBUG [upgradeToMySQL5_upgradeVPS] ===> ENTRY
DEBUG [AA::PEM_Current::context] ===> ENTRY
DEBUG [AA::PEM_Current::context] <=== EXIT [0.000034]
DEBUG [SDK::TPackage<unnamed>::getLastMySQL4Component] ===> ENTRY
DEBUG [SDK::TPackage<unnamed>::getLastMySQL4Component] <=== EXIT [0.022974]
DEBUG [void<unnamed>::MySQLUpdater::prepareUpgradeVPS] ===> ENTRY
DEBUG [void<unnamed>::MySQLUpdater::prepareUpgradeVPS] {module_id="MySQL"; code="105"} Required templates are not installed on VPS 1464: 'vzpem-mysql-client, vzpem-mysql-server'. You can try to upgrade this VPS using 'upgradeNode' command.
DEBUG [void<unnamed>::MySQLUpdater::prepareUpgradeVPS] <=== EXIT (by exception) [0.084162]
DEBUG [upgradeToMySQL5_upgradeVPS] <=== EXIT (by exception) [0.186299]
ERROR [main] ExSystem: module_id:'MySQL', ex_type_id:'105',Message:'Required templates are not installed on VPS 1464: 'vzpem-mysql-client, vzpem-mysql-server'. You can try to upgrade this VPS using 'upgradeNode' command.', deprecated_codes = (0, 0), properties = { vpsId: '1464',tmplList: 'vzpem-mysql-client, vzpem-mysql-server', }
Cause
The upgrade procedure described in the guide is applicable only to containers based on standard templates, but not on EZ templates, see note in http://download.pa.parallels.com/poa/5.4/doc/57775.htm
Resolution
For containers based on EZ templates the procedure Upgrading MySQL Database Server on Hardware Node should be used: http://download.pa.parallels.com/poa/5.4/doc/57855.htm