The following errors are seen in the logs:
2013-12-02 18:03:23.971 FATAL [main] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Fatal error creating instance id in database. Shutting down Foglight server...
java.sql.SQLException: Database instance id does not exist
2013-12-02 18:03:23.977 WARN [main] org.jboss.system.ServiceController - Problem starting service com.quest.nitro:service=DatabaseUpgrade
java.lang.RuntimeException: Incompatible database version
Debug Logs show the following:
2013-12-03 17:26:21.155 DEBUG [main] com.quest.nitro.upgrade.db.DatabaseVersionHelper - Somebody may have beaten us to insert one, try get again
java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
Please enable binlog_format=mixed on the External MySQL database configuration
Also noted in the installation Guide
Page 11
