drop table with engine kafka is hung

385 views
Skip to first unread message

Adil Saleem

unread,
Aug 29, 2018, 11:19:45 AM8/29/18
to ClickHouse
I deleted a table with kafka engine and the query has been running for 2 hours even after the client has been disconnected.

If I try to drop table again, I get the message "...is dropping or detaching right now"

I have tried running "kill query where query_id=" with no effect.

I have dropped and recreated this table many times before, I would prefer to resolve this without restarting clickhouse server

Thanks,
-Adil

Andrei Terentev

unread,
Feb 18, 2019, 1:20:38 AM2/18/19
to ClickHouse
Just run into the same issue :(

DROP TABLE costsKafka

just hangs. 

Don't see any error logs, when I try to kill the query I am getting 
kill_status: waiting

Any luck with this?
Message has been deleted

Dale Dude

unread,
Feb 24, 2019, 3:43:05 PM2/24/19
to ClickHouse
See github issue 4308
Reply all
Reply to author
Forward
0 new messages