MySQL Enterprise Monitor Agent Reports a Different sql_mode Than Expected
Last updated on MARCH 01, 2017
Applies to:MySQL Enterprise Monitor - Version 3.0 to 3.0 [Release 3.0]
Information in this document applies to any platform.
The mysql-monitor-agent-full.log is filling up with the following message:
2015-08-26 16:03:16,030 WARN [mysql-availability-ping-/var/run/mysqld/mysqld.sock-thread-0:com.mysql.etools.agent.collection.JdbcConnector] Current agent connection sql_mode is different from the expected "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER". Current sql_mode is "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION". This can result in connection failures.
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