AnsweredAssumed Answered

MySQL Account Collectors Colection error

Question asked by shakti nayak on Jul 8, 2017
Latest reply on Jul 19, 2017 by shakti nayak

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

Outcomes