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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.