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
Upgraded the drivers. It works now.