Fix for Table Engine=Kafka DROP Hang Issue

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