clickhouse Mutations删除操作报错及解决方案

最新推荐文章于 2024-07-09 15:28:33 发布

王者丶丿风范

最新推荐文章于 2024-07-09 15:28:33 发布

阅读量5.8k

点赞数

分类专栏：大数据 java 文章标签： clickhouse

本文链接：https://blog.csdn.net/w4187402/article/details/115617531

版权

当在ClickHouse执行删除语句后，数据未能清除并出现错误，通过查询system.Mutations表及日志发现问题。根据官方文档，利用KILL MUTATION语法成功终止并解决突变操作问题。

摘要由CSDN通过智能技术生成

1. clickhouse 执行删除语句后查询数据仍旧存在，等待数分钟后依然存在

2. 查询 system.Mutations 表

sql select * from system.mutations whereis_done = 0;发现任务在突变表中状态一直是未执行

3. 查阅 /var/log/clickhouse-server/clickhouse-server.err.log 日志发现如下报错

2021.04.09 10:59:12.971073 [ 6363 ] {
   } <Error> void DB::BackgroundProcessingPool::workLoopFunc(): Code: 393, e.displayText() = DB::Exception: There is no query, Stack trace (when copying this message, always include the lines below):

0. DB::Context::getQueryContext() const @ 0xd87f6ae in /usr/bin/clickhouse
1. DB::InterpreterSelectWithUnionQuery::getSampleBlock(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&) @ 0xdd71271 in /usr/bin/clickhouse
2. ? @ 0xded66ce in /usr/bin/clickhouse
3. DB::getDatabaseAndTablesWithColumns(std::__1::vector<DB::ASTTableExpression const*, std::__1::allocator<DB::ASTTableExpression const*> > const&, DB::Context const&) @ 0xded77c0 in /usr/bin/clickhouse
4. DB::JoinedTables::resolveTables() @ 0xdda3ad4 in /usr/bin/clickhouse
5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, std::__1::shared_ptr<DB::IBlockInputStream> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > >