Fix for Table Hang during DROP of Kafka Engine

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