The MySQL database is producing the following error:
INFO [STDIN/mysqld] com.quest.nitro.db.EmbeddedDatabaseManager - STDIN/mysqld:130219 11:08:13 InnoDB: Warning: purge reached the head of the history list,
INFO [STDIN/mysqld] com.quest.nitro.db.EmbeddedDatabaseManager - STDIN/mysqld:InnoDB: but its length is still reported as 99688! Make a detailed bug
INFO [STDIN/mysqld] com.quest.nitro.db.EmbeddedDatabaseManager - STDIN/mysqld:InnoDB: report, and submit it to http://bugs.mysql.com
Corrupt MySQL database and/or software installation:
http://bugs.mysql.com/bug.php?id=31123
http://www.mysqlab.net/knowledge/kb/detail/topic/innodb/id/7240
To solve it, follow the step below:
1. Make a backup of the MySQL database using mysqldump:
mysqldump --host=localhost --port=13306 --user=foglight --password=foglight --databases foglight --routines > dumpfile.sql
(adjust the parameters as needed)
2. Copy the mysql directory from another working Foglight installation
3. Start this new database copy with "FMS_HOME/bin/runDB.sh"
4. Drop the Foglight database from the other installation
drop database foglight;
5. Create a new empty Foglight database:
create database foglight;
6. Import Foglight database from the dump file:
use foglight;
source dumpfile.sql;
7. Recreate the needed procedures:
Go to "FMS_HOME/scripts/sql" and open the mysql_create_schema.sql file. Extract all the CREATE PROCEDURE statements and save it as a file, e.g. proc.sql. You would go to the top of the file and search for CREATE PROCEDURE, this will be your start point and copy the rest of the block till the end of the file (except the alter statement at the end).
Now run the created proc.sql:
use foglight;
source proc.sql;
8. Shutdown MySQL database using "FMS_HOME/bin/shutdownDb.sh" and start the FMS normally.
