ViPR SRM: Error seen while running mysql-database-check.sh
Summary: mysql-database-check-sh shows Operation failed
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
Error seen after running mysql-database-check.sh
Error seen:
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.
Resolution
Run mysql-database-check-sh again. The error will clear as the table will be created again properly during the task
Additional Information
How to run database check:
Log into each Backend host and run the following command:
Alternatively, we can perform the checks by following the steps below:
Log into Primary BackEnd:
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:
Enter database: [apg1]
Enter password: watch4net
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.shEnter 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.shEnter username: [apg]
Enter database: [apg1]
Enter password: watch4net
Affected Products
SRMArticle 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.