No Query Details Found in the Query Analyzer When Using the Connector/J Plugin (Doc ID 1335583.1)

Last updated on MARCH 08, 2017

Applies to:

MySQL Enterprise Monitor - Version 2.3 and later
Information in this document applies to any platform.

Symptoms

On : 2.3 version using the Connector/J plugin for data gathering, Query Analyzer is not showing query details as the application user was not granted privileges to the mysql.inventory table on the monitored server.

ACTUAL BEHAVIOR
---------------
No query analysis details were coming through in the MySQL Enterprise Monitor (MEM) dashboard.

EXPECTED BEHAVIOR
-----------------------
Expected to see queries which were being executed via the server show up with analysis in the dashboard.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set up query analysis using the Connector/J plugin.
2. Set application or test client with connection url that defines the Connector/J plugin details as required in the manual.
3. Remove, or don't grant, privileges for the mysql.inventory table from the application user. Note, this is not the service manager user defined for the plugin.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot determine the query details that are being executed or even if the queries are being executed at all.

Changes

Change from the default agent proxy module for query analysis to using the plugin for Connector/J or similar analyzing connector plugins.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms