# xtradb cluster 5.7.19-29.22-1.trusty query hangs on node **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [January 9, 2018, 6:04am UTC](https://forums.percona.com/t/xtradb-cluster-5-7-19-29-22-1-trusty-query-hangs-on-node/6111 "2018-01-09T06:04:04Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Antonio\_Falzarano](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/antonio_falzarano/32/1177_2.png) [@Antonio\_Falzarano](https://forums.percona.com/u/Antonio_Falzarano)\ **Post date:** [January 9, 2018, 6:04am UTC](https://forums.percona.com/t/xtradb-cluster-5-7-19-29-22-1-trusty-query-hangs-on-node/6111/1 "2018-01-09T06:04:04Z")
Hi, i recently migrate one cluster from galera codership 5.6 to xtradb cluster 5.7.19-29.22-1.trusty Sometimes one node of my cluster (5 nodes) hangs on select and doesn’t receive query anymore. show processlist and show innodb status works instead. All select are stuck on sending data or statistics (query that usually duration was 5ms), if i kill them they stuck on killed status. The only option is to stop and start mysql inside node. i didn’t find any lock on TRANSACTION section of innodb status Maybe there is a bug with this version that generate an internal deadlock? I attach my innodb status Thank you for everyone that can help me to troubleshooting this problem [innodb\_status\_20180109.txt](https://forums.percona.com/uploads/short-url/nfp7mQbFtjjn9WdhgbJg8uISC9F.txt) (144 KB) ---
**Author:** ![Antonio\_Falzarano](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/antonio_falzarano/32/1177_2.png) [@Antonio\_Falzarano](https://forums.percona.com/u/Antonio_Falzarano)\ **Post date:** [January 18, 2018, 11:15am UTC](https://forums.percona.com/t/xtradb-cluster-5-7-19-29-22-1-trusty-query-hangs-on-node/6111/2 "2018-01-18T11:15:54Z")
Nobody has had experience of my same problem ? ---
**Author:** ![Antonio\_Falzarano](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/antonio_falzarano/32/1177_2.png) [@Antonio\_Falzarano](https://forums.percona.com/u/Antonio_Falzarano)\ **Post date:** [January 22, 2018, 5:48am UTC](https://forums.percona.com/t/xtradb-cluster-5-7-19-29-22-1-trusty-query-hangs-on-node/6111/3 "2018-01-22T05:48:59Z")
Hi guys, problem was appened again, anyone of Percona can help me to troubleshoot inside this problem? ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [January 22, 2018, 6:15am UTC](https://forums.percona.com/t/xtradb-cluster-5-7-19-29-22-1-trusty-query-hangs-on-node/6111/4 "2018-01-22T06:15:16Z")
Hi Antonio, you mention that you were attaching innodb status but can’t see anything here? Just to confirm, you were running this application successfully in the past, but the problem has developed only since the migration? If you have any logs or messages you can share, that might help inform the tech team. Thanks! ---
**Author:** ![Antonio\_Falzarano](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/antonio_falzarano/32/1177_2.png) [@Antonio\_Falzarano](https://forums.percona.com/u/Antonio_Falzarano)\ **Post date:** [January 22, 2018, 7:14am UTC](https://forums.percona.com/t/xtradb-cluster-5-7-19-29-22-1-trusty-query-hangs-on-node/6111/5 "2018-01-22T07:14:49Z")
Hi lorraine, yes my application running well on mysql 5.6 codership and issue of hanging not happening (we have multiple galera clusters where application calls), We have migrate our first cluster from 5.6 codership to Xtradb 5.7, and it works well except this randomly hanging of one node, and i need to restart the node to became online again. I link new innodb status log (exceed max size) and i have this node in maintenance status without restarting them, so it’s a good opportunity to troubleshoot this randomly problem. [url][https://pastebin.com/he84ZiPZ[/url]](https://pastebin.com/he84ZiPZ%5B/url%5D) Regards Antonio ---
**Author:** ![Kenn\_Takara](https://avatars.discourse-cdn.com/v4/letter/k/b2d939/32.png) [@Kenn\_Takara](https://forums.percona.com/u/Kenn_Takara)\ **Post date:** [January 22, 2018, 9:32pm UTC](https://forums.percona.com/t/xtradb-cluster-5-7-19-29-22-1-trusty-query-hangs-on-node/6111/6 "2018-01-22T21:32:03Z")
Hi Antonio, There have been several bugs fixed in the upcoming PXC 5.7.20 release that look similar to what you’re seeing. [url][[PXC-877] PXC hangs on what looks like an internal deadlock - Percona JIRA](https://jira.percona.com/browse/PXC-877%5B/url%5D) [url][[PXC-878] Threads stuck in permanent statistics state with innodb\_thread\_concurrency\>0 - Percona JIRA](https://jira.percona.com/browse/PXC-878%5B/url%5D) Does this look similar to what you’re seeing? Thanks, ---
**Author:** ![Antonio\_Falzarano](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/antonio_falzarano/32/1177_2.png) [@Antonio\_Falzarano](https://forums.percona.com/u/Antonio_Falzarano)\ **Post date:** [January 23, 2018, 4:58am UTC](https://forums.percona.com/t/xtradb-cluster-5-7-19-29-22-1-trusty-query-hangs-on-node/6111/7 "2018-01-23T04:58:35Z")
Hi [Kenn Takara](https://percona.vanillacommunities.com/profile/x/x/27244) , i can view only PXC-877 and not have access to PXC-878, so about PXC-877 yes it is a similar problem except that i can execute show engine innodb status and global status. When will be released 5.7.20 version? Regards ---
**Author:** ![Kenn\_Takara](https://avatars.discourse-cdn.com/v4/letter/k/b2d939/32.png) [@Kenn\_Takara](https://forums.percona.com/u/Kenn_Takara)\ **Post date:** [January 23, 2018, 6:28pm UTC](https://forums.percona.com/t/xtradb-cluster-5-7-19-29-22-1-trusty-query-hangs-on-node/6111/8 "2018-01-23T18:28:48Z")
PXC-878 has the threads hanging and they show up as being in the “statistics” state in SHOW PROCESSLIST. Here is the launchpad bug: [url][https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1722560[/url]](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1722560%5B/url%5D) PXC 5.7.20 is due to be released soon, unfortunately I can’t give an exact date.