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 (144 KB)