# Replication troubleshooting with Slave\_SQL

**URL:** <https://forums.percona.com/t/replication-troubleshooting-with-slave-sql/4986>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [July 21, 2016, 9:15am UTC](https://forums.percona.com/t/replication-troubleshooting-with-slave-sql/4986 "2016-07-21T09:15:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pavel.hladik](https://avatars.discourse-cdn.com/v4/letter/p/a587f6/32.png) [@pavel.hladik](https://forums.percona.com/u/pavel.hladik)\
**Post date:** [July 21, 2016, 9:15am UTC](https://forums.percona.com/t/replication-troubleshooting-with-slave-sql/4986/1 "2016-07-21T09:15:08Z")

</div>

Hi,

I use Percona MySQL for a almost 5 years and I’m really satisfied, and I have a broken replication between master and slave. After troubleshooting steps I found out, that Slave\_IO is working well a Slave\_SQL is not working. My Percona MySQL server is latest 5.6.31.

I red Slave\_IO is taking care about grabbing master bin logs and delivering to slave relay log and Slave\_SQL is taking care about processing of SQLs to databases. I have to say that I see IO and SQL is working:

Slave\_IO\_Running: Yes  
Slave\_SQL\_Running: Yes

Anyway, when I start the completely new bin logs on master I do replication and I see all datas are transferred to relay logs on slave, the output from SHOW SLAVE STATUS\G seems to be ok. Zero seconds behind master, waiting for master to send data, slave has read all relay log; waiting for the slave I/O thread to update it, BUT the tables are not updated with a new data.

Can you please give me a hint how to get back with replication? Thank you.

---

<div class="post-metadata">

**Author:** ![sujitkumarjha](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@sujitkumarjha](https://forums.percona.com/u/sujitkumarjha)\
**Post date:** [July 4, 2019, 8:32am UTC](https://forums.percona.com/t/replication-troubleshooting-with-slave-sql/4986/2 "2019-07-04T08:32:11Z")

</div>

Hi Pavel,

I am also facing same issue. Did you found any solution?

Regards,  
Sujit
