MASTER STATUS and SLAVE STATUS are no longer used in MySQL 8.4.0 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.0 and higher and replaced.
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
SHOW MASTER STATUS has been changed in MySQL to SHOW BINARY LOG STATUS
SHOW SLAVE STATUS has been changed in MySQL to SHOW REPLICA STATUS
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.
