I know but we had no long running queries. All queries were showing that they are waiting for metadata lock, including the optimize queries. (Our longest runs for 0.3 seconds)
Total deadlock situation.
Two nodes hanging like that with the optimized table nearly finished in a #sql file and two cores fully loaded… One node operating normaly.
Maybe I should mention that we are writing to all nodes.
This would never have finished. I also checked disk io on the dead nodes. Nothing going on at all.
Regards