ViPR SRM:运行 mysql-database-check.sh 时出现错误

Summary: mysql-database-check-sh 显示操作失败

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.

Symptoms

运行 mysql-database-check.sh

后出现错误
Error : Table apg.recovery_group doesn't exist
Status : Operation failed

Cause

在数据库检查恢复期间使用 Table apg.recovery_group,它不是必需的表,因此不是在当前任务期间创建的。

Resolution

再次运行 mysql-database-check-sh。错误将清除,因为在任务期间将再次正确地创建表

Additional Information

如何运行数据库检查:

登录每个后端主机并运行以下命令:
 
printf "apg\n--password=watch4net --all-databases\n" | /opt/APG/bin/mysql-database-check.sh

或者,我们可以按照以下步骤执行检查:

登录到主后端:
 
srm:/opt/APG/bin # ./mysql-database-check.sh
输入用户名:[APG]
 
输入数据库:[APG]
 
输入密码: watch4net
 
在辅助后端上,以 root 用户身份登录,并逐个对其中 的每个 数据库执行,例如 apg1apg2apg3apg4
 
srm:/opt/APG/bin # ./mysql-database-check.sh
输入用户名:[APG]
 
输入数据库:[APG1]
 
输入密码: watch4net

Affected Products

SRM
Article Properties
Article Number: 000167710
Article Type: Solution
Last Modified: 20 Jun 2024
Version:  5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.