When monitoring a memSQL MySQL database in Foglight using the MySQL cartridge 5.9.3.20, many database collections are failing with a common error:
ERROR [Quartz[0]-50] com.sma.mysql.agent.GenericSimpleTask - ... Error while performing collection for CMP_Page
java.sql.SQLSyntaxErrorException: Table 'information_schema.INNODB_CMP' doesn't existERROR [Quartz[0]-50] com.sma.mysql.agent.GenericSimpleTask - ... Error while performing collection for CMP_Page
java.sql.SQLSyntaxErrorException: Table 'information_schema.INNODB_CMP' doesn't exist
ERROR [Quartz[0]-61] com.sma.mysql.agent.GenericSimpleTask - .... Error while performing collection for Blocked_TRX
java.sql.SQLSyntaxErrorException: Table 'information_schema.innodb_lock_waits' doesn't exist
ERROR [Quartz[0]-49] com.sma.mysql.agent.GenericSimpleTask - ... Error while performing collection for CMP_MemPage
java.sql.SQLSyntaxErrorException: Table 'information_schema.INNODB_CMPMEM' doesn't exist
ERROR [Quartz[0]-57] com.sma.mysql.agent.GenericSimpleTask - ...: Error while performing collection for Blocked_TRX
java.sql.SQLSyntaxErrorException: Table 'information_schema.innodb_lock_waits' doesn't exist