Hello,
I am trying to configure clickhouse with zookeeper replication in kubernetes using Altinity's clickhouse operator and bitnami's zookeeper helm chart.
I am encountering an error when trying to create a ReplicatedMergeTree table.
2021.10.06 19:52:00.116825 [ 194 ] {} <Error> virtual bool DB::DDLWorker::initializeMainThread(): Code: 999, e.displayText() = Coordination::Exception: Not authenticated, path: /clickhouse, Stack trace (when copying this message, always include the lines below):
0. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ 0x8fa40fa in /usr/bin/clickhouse
1. Coordination::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, Coordination::Error, int) @ 0x113e3855 in /usr/bin/clickhouse
2. Coordination::Exception::Exception(Coordination::Error, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x113e3ece in /usr/bin/clickhouse
3. zkutil::ZooKeeper::createIfNotExists(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x113ebb52 in /usr/bin/clickhouse
4. zkutil::ZooKeeper::createAncestors(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x113ebcb4 in /usr/bin/clickhouse
5. DB::DDLWorker::initializeMainThread() @ 0x100280aa in /usr/bin/clickhouse
6. DB::DDLWorker::runMainThread() @ 0x100111d1 in /usr/bin/clickhouse
7. ThreadFromGlobalPool::ThreadFromGlobalPool<void (DB::DDLWorker::*)(), DB::DDLWorker*>(void (DB::DDLWorker::*&&)(), DB::DDLWorker*&&)::'lambda'()::operator()() @ 0x10028ed1 in /usr/bin/clickhouse
8. ThreadPoolImpl<std::__1::thread>::worker(std::__1::__list_iterator<std::__1::thread, void*>) @ 0x8fe4d7f in /usr/bin/clickhouse
9. ? @ 0x8fe8663 in /usr/bin/clickhouse
10. start_thread @ 0x9609 in /usr/lib/x86_64-linux-gnu/libpthread-2.31.so
11. __clone @ 0x122293 in /usr/lib/x86_64-linux-gnu/libc-2.31.so
(version 21.8.8.29 (official build))
My zookeeper config in clickhouse looks like this:
<yandex>
<zookeeper>
<node>
<host>zookeeper-0.zookeeper-headless</host>
<port>2181</port>
</node>
<node>
<host>zookeeper-1.zookeeper-headless</host>
<port>2181</port>
</node>
<node>
<host>zookeeper-2.zookeeper-headless</host>
<port>2181</port>
</node>
<identity>clickhouse:my-password</identity>
</zookeeper>
<distributed_ddl>
<path>/clickhouse/clickhouse-cluster/task_queue/ddl</path>
</distributed_ddl>
</yandex>
Any insight that you can provide would be greatly appreciated.
Thanks,
Luke