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)