Bug #78053 MySQL Enterprise Monitor agent report different sql_mode than expected
Submitted: 13 Aug 2015 8:10 Modified: 13 Aug 2015 9:19
Reporter: Gregory Steulet Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:3.0.23 OS:Linux (OEL 6.7)
Assigned to: CPU Architecture:Any
Tags: SQL_MODE

[13 Aug 2015 8:10] Gregory Steulet
Description:
Hi,

The agent is reporting every minutes an error regarding the sql_mode in $MySQLAGENT_HOME/logs/mysql-monitor-agent.log and mysql-monitor-agent-full.log:

 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.

The SQL_MODE is exactly the one expected excepting that the order does not match. This is quite annoying since both files size grows quickly. 

Thanks for your support

How to repeat:
This bug can be repeated by simply installing the agent 3.0.23 and monitoring any MySQL target. 

Targets characterset settings are:

mysql> SHOW VARIABLES LIKE  'char%';
+--------------------------+------------------------------------------------------------------------------------+
| Variable_name            | Value                                                                              |
+--------------------------+------------------------------------------------------------------------------------+
| character_set_client     | utf8                                                                               |
| character_set_connection | utf8                                                                               |
| character_set_database   | latin1                                                                             |
| character_set_filesystem | binary                                                                             |
| character_set_results    | utf8                                                                               |
| character_set_server     | latin1                                                                             |
| character_set_system     | utf8                                                                               |
| character_sets_dir       | /u00/app/mysql/product/mysql-advanced-5.6.26-linux-glibc2.5-x86_64/share/charsets/ |
+--------------------------+------------------------------------------------------------------------------------+
8 rows in set (0.00 sec)
[13 Aug 2015 9:19] MySQL Verification Team
Hello Gregory Steulet,

Thank you for the report.
Observed this with local installation(with bundled MySQL instance).

Thanks,
Umesh