My Oracle Support Banner

MySQL Enterprise Monitor (MEM) Displays Warnings For "set session sql_mode=?" On 5.7+ Servers From Its Own Statements (Doc ID 2370709.1)

Last updated on MARCH 12, 2021

Applies to:

MySQL Enterprise Monitor - Version 4.0 to 8.0 [Release 3.3 to 8.0]
Information in this document applies to any platform.

Symptoms

When viewing the Events page or Query Analayzer, MySQL Enterprise Manager (MEM) Agent is causing warnings from statements it is sending to the MySQL server.

The following query (or similar in early 3.x versions) will show a warning in Query Analyzer and MEM's 'SQL Statement Generates Warnings or Errors' advisor.

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 Workaround
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.