MASTER STATUS and SLAVE STATUS are no longer used in MySQL 8.4.2 and higher
The following errors appear in the agent log files
2024-09-11 12:25:41.702 ERROR [Quartz[0]-6] com.sma.mysql.agent.GenericSimpleTask - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again: Error while performing collection for Master_Status
java.sql.SQLSyntaxErrorException: 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 'MASTER STATUS' at line 1
2024-09-11 12:25:42.186 ERROR [Quartz[0]-5] com.sma.mysql.agent.GenericSimpleTask - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again: Error while performing collection for Slave_Status
java.sql.SQLSyntaxErrorException: 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 'SLAVE STATUS' at line 1
The terms MASTER STATUS and SLAVE STATUS has been deprecated beginning in MySQL 8.4.2 and higher
Ref: https://dev.mysql.com/doc/refman/8.4/en/show-master-status.html
and https://dev.mysql.com/doc/refman/8.0/en/show-slave-status.html
WORKAROUND
None
STATUS
This issue have been fixed in the 7.3.0.13 and higher releases of the MySQL cartridge. A copy of the 7.3.0.13 cartridge has been attached to the Knowledgebase article. Users should be logged into Supportlink to download the cartridge.
© ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center