Fix intermitent hang during DROP of table engine=Kafka

Fix for the hang which was happening sometimes during DROP of table engine=Kafka (or during server restarts). #11145 (filimonov).