search cancel

MySQL Infrastructure Agent Not Reporting MySQL Metrics

book

Article ID: 200844

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) CA Application Performance Management (APM / Wily / Introscope) INTROSCOPE DX Application Performance Management

Issue/Introduction

MySQL Infrastructure Agent not reporting MySQL metrics and throwing below exception:

9/29/20 10:01:59 AM CDT [ERROR] [IntroscopeAgent.DBMonitor] 
java.sql.SQLSyntaxErrorException: (conn=13762) Table 'performance_schema.global_variables' doesn't exist
 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:243)
 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:164)
 at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:258)
 at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:349)
 at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:595)
 at com.ca.agent.extensions.dbmon.commands.DBMonExecuteQueryCommand.fireAndUpdateMetric(DBMonExecuteQueryCommand.java:158)
 at com.ca.agent.extensions.dbmon.commands.DBMonExecuteQueryCommand.execute(DBMonExecuteQueryCommand.java:123)
 at com.ca.agent.extensions.dbmon.DBMonChain.run(DBMonChain.java:66)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Table 'performance_schema.global_variables' doesn't exist
 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1599)
 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1461)
 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1424)
 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:178)
 at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:343)
 ... 7 more

Environment

DX Application Performance Management MySql SaaS Agent.
MySQL 8.x release.

Resolution

This happens due to the incompatibility of MySql database, make sure that you are trying to monitor MySQL database 8.x which is supported by Broadcom.

Any other MySql that you try to monitor, you will see the exception reported in this knowledge article.

Additional Information

https://support.broadcom.com/external/content/release-announcements/CA-Application-Performance-Management-Compatibility-Guides/2146