CK报错:Not found a storage to insert user
CLICKHOUSE从版本20升级到V 21.2.3.15 后,使用create user 命令创建USER的时候报错:Not found a storage to insert user `xxx`:日志如下:CREATE USER wang_ro IDENTIFIED WITH sha256_hash BY '0A8CAA7314F45AA6BDC40230D1B434AB7B3F6D4421
·
CLICKHOUSE从版本20升级到V 21.2.3.15 后,使用create user 命令创建USER的时候报错:
Not found a storage to insert user `xxx`:
日志如下:
CREATE USER wang_ro IDENTIFIED WITH sha256_hash BY '0A8CAA7314F45AA6BDC40230D1B434AB7B3F6D442140FC33351F1045A0012785'
Query id: 866d3b9e-f602-4e4b-ab42-d396982b725c
[XXXXX] 2021.07.29 18:43:17.850786 [ 25476 ] {866d3b9e-f602-4e4b-ab42-d396982b725c} <Error> executeQuery: Code: 514, e.displayText() = DB::Exception: Not found a storage to insert user `wang_ro`: Couldn't insert user `wang_ro`. Successfully inserted: none (version 21.2.3.15 (official build)) (from 127.0.0.1:62122) (in query: create user wang_ro identified by 'xx';), Stack trace (when copying this message, always include the lines below):
0. DB::MultipleAccessStorage::insertImpl(std::__1::shared_ptr<DB::IAccessEntity const> const&, bool) @ 0xe49e7ec in /usr/bin/clickhouse
1. DB::IAccessStorage::insert(std::__1::vector<std::__1::shared_ptr<DB::IAccessEntity const>, std::__1::allocator<std::__1::shared_ptr<DB::IAccessEntity const> > > const&) @ 0xe47a446 in /usr/bin/clickhouse
2. DB::InterpreterCreateUserQuery::execute() @ 0xeb3e780 in /usr/bin/clickhouse
3. ? @ 0xeec1c62 in /usr/bin/clickhouse
4. DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool) @ 0xeec05bc in /usr/bin/clickhouse
5. DB::TCPHandler::runImpl() @ 0xf5baf25 in /usr/bin/clickhouse
6. DB::TCPHandler::run() @ 0xf5caba9 in /usr/bin/clickhouse
7. Poco::Net::TCPServerConnection::start() @ 0x11b6786f in /usr/bin/clickhouse
8. Poco::Net::TCPServerDispatcher::run() @ 0x11b69281 in /usr/bin/clickhouse
9. Poco::PooledThread::run() @ 0x11ca0329 in /usr/bin/clickhouse
10. Poco::ThreadImpl::runnableEntry(void*) @ 0x11c9c18a in /usr/bin/clickhouse
11. start_thread @ 0x7dd5 in /usr/lib64/libpthread-2.17.so
12. __clone @ 0xfdead in /usr/lib64/libc-2.17.so
0 rows in set. Elapsed: 0.002 sec.
Received exception from server (version 21.2.3):
Code: 514. DB::Exception: Received from 127.0.0.1:9000. DB::Exception: Not found a storage to insert user `wang_ro`: Couldn't insert user `wang_ro`. Successfully inserted: none.
但是直接安装的 V21.2.3.15(不是通过升级而来),是正常的,没问题的;
GG了一个类似问题,但未解决;
https://github.com/ClickHouse/ClickHouse/issues/13256
目前来看要么只能通过users.xml来管理,要么只能重装了;
更多推荐
所有评论(0)