MASTER STATUS and SLAVE STATUS are no longer used in MySQL 8.4.2 and higher (4377388)

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.