Bug #101553 Unable to start slave sql running in MySql 8.0.20

• Submitted: 11 Nov 2020 6:25
• Modified: 16 Nov 2020 14:10
• Reporter: Kailasam Nagaraju
• Status: Not a Bug
• Category: Tests: Replication
• Severity: S3 (Non-critical)
• Version: 8.0.20
• OS: Red Hat (7)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[11 Nov 2020 6:25] Kailasam Nagaraju

Description:
Hello Team,

We are using master master replication with 2 nodes (MySql 8.0.20). This was working fine till a few days back. We now see that the replication is not working. On checking the slave status using SHOW SLAVE STATUS \G we observed that slave sql running is set to NO. See below:

Slave_IO_Running: Yes
Slave_SQL_Running: No

We then tried to start this using the commands START SLAVE SQL_THREAD; and START SLAVE; but no luck. We even tried restarting the mysql service but it did not help. 

Kindly assist on how to set the slave sql running to YES.

Regards,
Kailasam.

How to repeat:
N/A

[16 Nov 2020 14:10] MySQL Verification Team

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.