We are getting errors in Collection for a MYSQL database collector. The error reds below:-
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5'
Is anybody aware of this issue in the MySQL database type collector. If Yes what is the resolution ?
the version we are using is 6.9
Might be related to an outdated MySQL driver or deprecated usage.
Try using: SET SQL_SELECT_LIMIT=10;
Or try searching for a solution online
MySQL Bugs: #66659: mysql 5.6.6m9 fails on OPTION SQL_SELECT_LIMIT=DEFAULT
java - 'OPTION SQL_SELECT_LIMIT=DEFAULT' - Stack Overflow
java - Quartz JDBCJobStore problems with MySQL - Stack Overflow
I suggest you verify that your query is working as expected when using a SQL client (like SQL Developer or SQuirreL)
Upgraded the drivers. It works now.
Upgraded the drivers. It works now.