Fixed hang during DROP of Kafka table engine

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