search

housepower / ckman

This is a tool which used to manage and monitor ClickHouse database
Apache License 2.0
433 stars 108 forks source link

增加节点报错 #261

Closed 7vqinqiwei closed 8 months ago

7vqinqiwei commented 1 year ago

2022-09-18T07:54:43.778Z INFO deploy/ck.go:478 config done 2022-09-18T07:54:43.782Z INFO deploy/task.go:100 [replica-all_hosts] clickhouse.addnode current step: ConfigExt 2022-09-18T07:54:43.786Z INFO business/ck_schema.go:18 Run query: SELECT DISTINCT database AS name, concat('CREATE DATABASE IF NOT EXISTS "', name, '"') AS create_db_query FROM remote('192.168.33.11', system, tables, 'default', 'default_admin') WHERE database NOT IN ('system', 'information_schema', 'INFORMATION_SCHEMA') SETTINGS skip_unavailable_shards = 1 2022-09-18T07:54:43.808Z INFO deploy/task.go:100 [replica-all_hosts] clickhouse.addnode current step: Failed 2022-09-18T07:54:43.809Z ERROR runner/runner.go:59 clickhouse.addnode failed:[ConfigExt]: : code: 516, message: Received from 192.168.33.11:9000. DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name. Stack trace:

  1. DB::Exception::Exception(std::1::basic_string<char, std::__1::char_traits, std::1::allocator > const&, int, bool) @ 0x8fd4c9a in /usr/bin/clickhouse
  2. DB::IAccessStorage::throwCannotAuthenticate(std::1::basic_string<char, std::__1::char_traits, std::1::allocator > const&) @ 0xfb8625f in /usr/bin/clickhouse
  3. DB::IAccessStorage::login(DB::Credentials const&, Poco::Net::IPAddress const&, DB::ExternalAuthenticators const&, bool) const @ 0xfb860a2 in /usr/bin/clickhouse
  4. DB::Context::setUser(DB::Credentials const&, Poco::Net::SocketAddress const&) @ 0xfff7479 in /usr/bin/clickhouse
  5. DB::TCPHandler::receiveHello() @ 0x1102dfcc in /usr/bin/clickhouse
  6. DB::TCPHandler::runImpl() @ 0x11027338 in /usr/bin/clickhouse
  7. DB::TCPHandler::run() @ 0x1103ad99 in /usr/bin/clickhouse
  8. Poco::Net::TCPServerConnection::start() @ 0x13bb206f in /usr/bin/clickhouse
  9. Poco::Net::TCPServerDispatcher::run() @ 0x13bb3afa in /usr/bin/clickhouse
  10. Poco::PooledThread::run() @ 0x13ce5d79 in /usr/bin/clickhouse
  11. Poco::ThreadImpl::runnableEntry(void*) @ 0x13ce200a in /usr/bin/clickhouse
  12. start_thread @ 0x7dd5 in /usr/lib64/libpthread-2.17.so
  13. __clone @ 0xfdead in /usr/lib64/libc-2.17.so github.com/housepower/ckman/service/runner.(RunnerService).CheckTaskEvent.func1 /root/go/src/github.com/housepower/ckman/service/runner/runner.go:59 github.com/housepower/ckman/common.runFunc /root/go/src/github.com/housepower/ckman/common/workerpool.go:91 github.com/housepower/ckman/common.(WorkerPool).wokerFunc /root/go/src/github.com/housepower/ckman/common/workerpool.go:68
YenchangChan commented 1 year ago

请提供下ckman版本和clickhouse版本，看报错信息是密码不正确： 2022-09-18T07:54:43.809Z ERROR runner/runner.go:59 clickhouse.addnode failed:[ConfigExt]: : code: 516, message: Received from 192.168.33.11:9000. DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name

YenchangChan commented 8 months ago

fixed by #287