MySQL Enterprise Monitor Agent Reports a Different sql_mode Than Expected (Doc ID 2053346.1)

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.

Symptoms

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.

 

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