如果在NSM数据库中添加了多个版本的自定义插件、则SnapCenter升级将失败
适用场景
- SnapCenter服务器[SC] 5.0、6.0
- SnapCenter 自定义插件
- MySQL [NSM][ SnapCenter NSM数据库]
问题描述
- 如果在SnapCenter NSM 数据库中添加了具有多个版本的自定义插件、则SnapCenter从5.0升级到6.0或更高版本将失败。
- SnapCenter升级失败、并显示以下错误：
2024-11-21 13:37:38.846 Executing SQL script C:\Users\administrator\AppData\Local\Temp\<user>\6.0\6.0.0.0008_Call_CustomPlugin_Procedures.sql
2024-11-21 13:37:38.878 Error: executing SQL script C:\Users\administrator\AppData\Local\Temp\<user>\6.0\6.0.0.0008_Call_CustomPlugin_Procedures.sql
2024-11-21 13:37:38.878 Error: Result consisted of more than one row
SQL script 6.0.0.0008_Call_CustomPlugin_Procedures.sql calls below stored procedures:
CALL `nsm`.`Update_nsm_PluginType`();
CALL `nsm`.`Update_nsm_sc_CustomPluginInfo`();
CALL `nsm`.`Update_nsm_sc_CustomPluginOsInfo`();
CALL `nsm`.`Update_nsm_sc_customresourcetype`();
Failure is happening while calling stored procedure `nsm`.`Update_nsm_sc_CustomPluginInfo`(); because there are multiple entries are there in nsm_sc_customplugininfo table for same CustomPluginName
Below is stored procedure `nsm`.`Update_nsm_sc_CustomPluginInfo`()