ViPR SRM: Error seen while running mysql-database-check.sh

Sommaire: mysql-database-check-sh shows Operation failed

Cet article s’applique à Cet article ne s’applique pas à Cet article n’est lié à aucun produit spécifique. Toutes les versions de produits ne sont pas identifiées dans cet article.

Symptômes

Error seen after running mysql-database-check.sh

Error seen:
Error : Table apg.recovery_group doesn't exist
Status : Operation failed

Cause

The Table apg.recovery_group is used during the database check for recovery, it is not a necessary table and was not created during the task at this time.

Résolution

Run mysql-database-check-sh again. The error will clear as the table will be created again properly during the task

Renseignements supplémentaires

How to run database check:

Log into each Backend host and run the following command:
 
printf "apg\n--password=watch4net --all-databases\n" | /opt/APG/bin/mysql-database-check.sh

Alternatively, we can perform the checks by following the steps below:

Log into Primary BackEnd:
 
srm:/opt/APG/bin # ./mysql-database-check.sh
Enter username: [apg]
 
Enter database: [apg]
 
Enter password: watch4net
 
On Secondary backends, login as root and perform on each of the databases there one at a time,  such as apg1, apg2, apg3 and apg4:
 
srm:/opt/APG/bin # ./mysql-database-check.sh
Enter username: [apg]
 
Enter database: [apg1]
 
Enter password: watch4net

Produits touchés

SRM
Propriétés de l’article
Numéro d’article: 000167710
Type d’article: Solution
Dernière modification: 20 juin 2024
Version:  5
Obtenez des réponses à vos questions auprès d’autre utilisateurs de Dell
Services de soutien
Vérifiez si votre appareil est couvert par les services de soutien.