Ребят, привет! Начала падать такая ошибка. По тексту все понятно,

Question

Ребят, привет! Начала падать такая ошибка. По тексту все понятно,

кроме имени таблицы, в которой это происходит. В стектрейсе таблицы тоже нет

2021.02.17 15:51:28.789818 [ 34168 ] {} <Error> void DB::StorageKafka::threadFunc(size_t): Code: 55, e.displayText() = DB::Exception: Method write is not supported by storage Distributed with more than one shard and no sharding key provided, Stack trace (when copying this message, always include the lines below):
0. DB::StorageDistributed::write(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, DB::Context const&) @ 0xe01443f in /usr/bin/clickhouse
1. DB::PushingToViewsBlockOutputStream::PushingToViewsBlockOutputStream(std::__1::shared_ptr<DB::IStorage> const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, DB::Context const&, std::__1::shared_ptr<DB::IAST> const&, bool) @ 0xdb787d3 in /usr/bin/clickhouse
2. DB::InterpreterInsertQuery::execute() @ 0xdb691fb in /usr/bin/clickhouse
3. DB::PushingToViewsBlockOutputStream::PushingToViewsBlockOutputStream(std::__1::shared_ptr<DB::IStorage> const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, DB::Context const&, std::__1::shared_ptr<DB::IAST> const&, bool) @ 0xdb79a50 in /usr/bin/clickhouse
4. DB::InterpreterInsertQuery::execute() @ 0xdb691fb in /usr/bin/clickhouse
5. DB::PushingToViewsBlockOutputStream::PushingToViewsBlockOutputStream(std::__1::shared_ptr<DB::IStorage> const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, DB::Context const&, std::__1::shared_ptr<DB::IAST> const&, bool) @ 0xdb79a50 in /usr/bin/clickhouse
6. DB::InterpreterInsertQuery::execute() @ 0xdb691fb in /usr/bin/clickhouse
7. DB::StorageKafka::streamToViews() @ 0xe21500e in /usr/bin/clickhouse
8. DB::StorageKafka::threadFunc(unsigned long) @ 0xe2142be in /usr/bin/clickhouse
9. DB::BackgroundSchedulePoolTaskInfo::execute() @ 0xd8af5b2 in /usr/bin/clickhouse
10. DB::BackgroundSchedulePool::threadFunction() @ 0xd8b1a32 in /usr/bin/clickhouse
11. ? @ 0xd8b2ca3 in /usr/bin/clickhouse
12. ThreadPoolImpl<std::__1::thread>::worker(std::__1::__list_iterator<std::__1::thread, void*>) @ 0x7b8963d in /usr/bin/clickhouse
13. ? @ 0x7b8d153 in /usr/bin/clickhouse
14. start_thread @ 0x7fa3 in /usr/lib/x86_64-linux-gnu/libpthread-2.28.so
15. __clone @ 0xf94cf in /usr/lib/x86_64-linux-gnu/libc-2.28.so
(version 20.10.5.10 (official build))

#backend #clickhouse #database #devops #programming #russian

0

17.02.2021

1 ответов

8 просмотров

Slach [altinity] · Accepted Answer

Slach [altinity]

SELECT database, table, engine_full FROM system.tables WHERE engine='Distributed'; и там внимательно смотреть где у вас sharding key отсутствует

0

18.02.2021

184 похожих чатов

Ребят, привет! Начала падать такая ошибка. По тексту все понятно,

1 ответов

Похожие вопросы