OPERATIONAL DEFECT DATABASE
...
...
Unable to start Backend after server crash; Error: SEVERE -- Cache::start(): APG Backend startup failed! com.watch4net.apg.v2.common.config.InvalidConfigurationException: Can't initialize group The system will not be able to start the Backend until the error disappear from the log file: SEVERE -- SqlStorageConnector::recoverLastUpdates(): Unable to drop variable recovery temporary table!java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@4e42d390 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries....SEVERE -- Cache::start(): APG Backend startup failed!com.watch4net.apg.v2.common.config.InvalidConfigurationException: Can't initialize group group...Caused by: com.watch4net.apg.v2.common.io.InOutException: Unable to initialize variables!...Caused by: java.sql.SQLException: Got error 175 from storage engine
A Database table is corrupt due to a server crash and needs to be repaired.
User has to verify if at all any of the DB table is corrupted by executing the below command from the APG/bin directory: Linux:mysql-database-check.shWindows:mysql-database-check.cmdThis script will check the status of all the DB tables and try to repair if any of the table is corrupt; if any of the tables are not repaired with this particular command, it will throw an error with the information. (refer the below screenshot) The above screenshot shows that, few of the cache_group tables are corrupted and few table status are 'OK'. In the above example we are repairing the cache_group_0_1433376000 table which is corrupted. To repair any of the corrupted table; run the below command from the mysql> directory after logging into the database. mysql> repair table <table_name>or mysql> repair table <table_name> use_frm;In the above screenshot user can see that, the table "cache_group_0_1433376000" has been repaired. Once the table is repaired; start the Backend service.
Click on a version to see all relevant bugs
VMware Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.
