проблема?
2021.05.20 00:57:00.189909 [ 32609 ] {17735816-2a71-49b2-ada0-ef99d81db1fa} <Error> executeQuery: Code: 159, e.displayText() = DB::Exception: Watching task /clickhouse/task_queue/ddl/query-0000000486 is executing longer than distributed_ddl_task_timeout (=180) seconds. There are 3 unfinished hosts (0 of them are currently active), they are going to execute the query in background (version 20.3.2.1 (official build)) (from 127.0.0.1:50670) (in query: CREATE TABLE db.as_local111 ON CLUSTER cluster (`uid` String, `attributes` Array(UInt64), `created_at` DateTime DEFAULT now()) ENGINE = ReplicatedMergeTree('/clickhouse/db/tables/{shard}/as_local111', '{replica}') PARTITION BY toYYYYMM(created_at) ORDER BY created_at SETTINGS index_granularity = 8192), Stack trace (when copying this message, always include the lines below):
0. Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x10278d1c in /usr/bin/clickhouse
1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x8f02989 in /usr/bin/clickhouse
2. DB::DDLQueryStatusInputStream::readImpl() @ 0xce40b23 in /usr/bin/clickhouse
3. DB::IBlockInputStream::read() @ 0xcc7addf in /usr/bin/clickhouse
4. DB::AsynchronousBlockInputStream::calculate() @ 0xcc71ec4 in /usr/bin/clickhouse
5. ? @ 0xcc73684 in /usr/bin/clickhouse
6. ThreadPoolImpl<ThreadFromGlobalPool>::worker(std::__1::__list_iterator<ThreadFromGlobalPool, void*>) @ 0x8f265e7 in /usr/bin/clickhouse
7. ThreadFromGlobalPool::ThreadFromGlobalPool<void ThreadPoolImpl<ThreadFromGlobalPool>::scheduleImpl<void>(std::__1::function<void ()>, int, std::__1::optional<unsigned long>)::'lambda1'()>(void&&, void ThreadPoolImpl<ThreadFromGlobalPool>::scheduleImpl<void>(std::__1::function<void ()>, int, std::__1::optional<unsigned long>)::'lambda1'()&&...)::'lambda'()::operator()() const @ 0x8f26c34 in /usr/bin/clickhouse
8. ThreadPoolImpl<std::__1::thread>::worker(std::__1::__list_iterator<std::__1::thread, void*>) @ 0x8f25b07 in /usr/bin/clickhouse
9. ? @ 0x8f2400f in /usr/bin/clickhouse
10. start_thread @ 0x76db in /lib/x86_64-linux-gnu/libpthread-2.27.so
11. clone @ 0x12188f in /lib/x86_64-linux-gnu/libc-2.27.so
С /etc/hosts на серверах все в порядке, zk установлен на тех же серверах что и ch
контейнеры? У вас похоже все ноды КХ думают что их ip 127.0.0.1
нет, системные сервисы, уже нашел в чем дело... нужно из зк удалять данные о выведенных серверах
Обсуждают сегодня