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

Error seen after running mysql-database-check.sh

Error seen:

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

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.

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

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