# “wati for commit lock" occur in mysql5.6.19 slave

**URL:** <https://forums.percona.com/t/wati-for-commit-lock-occur-in-mysql5-6-19-slave/3833>\
**Category:** Percona XtraBackup\
**Created:** [October 19, 2014, 8:27pm UTC](https://forums.percona.com/t/wati-for-commit-lock-occur-in-mysql5-6-19-slave/3833 "2014-10-19T20:27:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![giantmangu888](https://avatars.discourse-cdn.com/v4/letter/g/4491bb/32.png) [@giantmangu888](https://forums.percona.com/u/giantmangu888)\
**Post date:** [October 19, 2014, 8:27pm UTC](https://forums.percona.com/t/wati-for-commit-lock-occur-in-mysql5-6-19-slave/3833/1 "2014-10-19T20:27:02Z")

</div>

When full backup with percona-xtrabackup 2.2.4 in mysql 5.6.19 slave,I found that:  
mysql\> show processlist;  
±--------±-------------±---------------------±-------------±--------±-------±---------------------------------------±------------------+  
| Id | User | Host | db | Command | Time | State | Info |  
±--------±-------------±---------------------±-------------±--------±-------±---------------------------------------±------------------+  
| 716140 | system user | | NULL | Connect | 830477 | Queueing master event to the relay log | NULL |  
| 944563 | system user | | NULL | Connect | 911 | Waiting for commit lock | NULL |  
| 1019137 | px224db | 10.19.83.19:57272 | px224db | Sleep | 6 | | NULL |  
| 1019214 | root | localhost | mysql | Query | 904 | init | SHOW SLAVE STATUS |  
| 1019228 | monit11 | 10.18.67.10:49936 | NULL | Query | 872 | init | SHOW SLAVE STATUS |  
| 1019229 | monit11 | 10.18.67.10:49962 | NULL | Query | 872 | init | SHOW SLAVE STATUS |  
| 1019233 | monit11 | 10.18.67.10:50025 | NULL | Query | 872 | init | SHOW SLAVE STATUS |

I know it’s a bug in mysql5.6.10,and has been resolved in mysql 5.6.13; why occured in mysql 5.6.19 and how to solved the problem?  
Thank you.

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [November 2, 2014, 11:54pm UTC](https://forums.percona.com/t/wati-for-commit-lock-occur-in-mysql5-6-19-slave/3833/2 "2014-11-02T23:54:48Z")

</div>

Hi,

It seems, that bug still exists. Please check and keep monitor below bugs for further progress.  
[url][MySQL Bugs: #70307: Another deadlock on FLUSH TABLES WITH READ LOCK + SHOW SLAVE STATUS](http://bugs.mysql.com/bug.php?id=70307%5B/url%5D)  
[url][https://bugs.launchpad.net/percona-server/+bug/1295820[/url]](https://bugs.launchpad.net/percona-server/+bug/1295820%5B/url%5D)  
[url][https://bugs.launchpad.net/percona-server/+bug/1386363[/url]](https://bugs.launchpad.net/percona-server/+bug/1386363%5B/url%5D)