21.4.6.55 в котором нормально создается бд с engine postgresql
CREATE DATABASE b2b ENGINE = PostgreSQL('10.10.17.2:6432', 'b2b', 'login', 'password', 1)
но на версии сервера 21.10.2.15 выдает ошибку (собственно такую ошибку словил при обновлении на эту версию) вот что в логах:
2022.03.17 15:57:50.538248 [ 2485308 ] {616fbfcc-dc7d-4bfc-9379-10661b8c7967} <Error> TCPHandler: Code: 170. DB::Exception: Bad get: has UInt64, requested String. (BAD_GET), Stack trace (when copying th
is 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) @ 0x944bdda in /usr/bin/clickhouse
1. auto& DB::Field::safeGet<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > >() @ 0x95458f6 in /usr/bin/clickhouse
2. ? @ 0x109e293c in /usr/bin/clickhouse
3. DB::DatabaseFactory::getImpl(DB::ASTCreateQuery const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::Context const>) @ 0x109e
1529 in /usr/bin/clickhouse
4. DB::DatabaseFactory::get(DB::ASTCreateQuery const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::Context const>) @ 0x109df118
in /usr/bin/clickhouse
5. DB::InterpreterCreateQuery::createDatabase(DB::ASTCreateQuery&) @ 0x109c60f9 in /usr/bin/clickhouse
6. DB::InterpreterCreateQuery::execute() @ 0x109da46c in /usr/bin/clickhouse
7. ? @ 0x110732e1 in /usr/bin/clickhouse
8. DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, bool) @ 0x11071
1a3 in /usr/bin/clickhouse
9. DB::TCPHandler::runImpl() @ 0x1195ea24 in /usr/bin/clickhouse
10. DB::TCPHandler::run() @ 0x11971b19 in /usr/bin/clickhouse
11. Poco::Net::TCPServerConnection::start() @ 0x1453bf2f in /usr/bin/clickhouse
12. Poco::Net::TCPServerDispatcher::run() @ 0x1453d9ba in /usr/bin/clickhouse
13. Poco::PooledThread::run() @ 0x1466fdf9 in /usr/bin/clickhouse
14. Poco::ThreadImpl::runnableEntry(void*) @ 0x1466c08a in /usr/bin/clickhouse
15. start_thread @ 0x817a in /usr/lib64/libpthread-2.28.so
16. __clone @ 0xfcdc3 in /usr/lib64/libc-2.28.so
может кто-то подскажет, пожалуйста, что с этим можно сделать или куда копать?
обновитесь еще, может уже починено
попробовал сейчас с версией 22.2.2, тоже самое( 2022.03.17 16:39:28.016678 [ 2576399 ] {6d63377f-22fc-4f9b-bb0b-a505bbdf46a7} <Error> executeQuery: Code: 170. DB::Exception: Bad get: has UInt64, requested String. (BAD_GET) (version 22.2.2.1) (from 12 7.0.0.1:61682) (in query: CREATE DATABASE b2b ENGINE = PostgreSQL('10.10.17.2:6432', 'b2b', 'login', 'password', 1)), 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) @ 0xaebed1a in /usr/bin/clickhouse 1. DB::Exception::Exception<std::__1::basic_string_view<char, std::__1::char_traits<char> >, DB::Field::Types::Which const&>(int, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allo cator<char> > const&, std::__1::basic_string_view<char, std::__1::char_traits<char> >&&, DB::Field::Types::Which const&) @ 0xafdf5a0 in /usr/bin/clickhouse 2. auto& DB::Field::safeGet<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > >() @ 0xba85663 in /usr/bin/clickhouse 3. ? @ 0x14bcd930 in /usr/bin/clickhouse 4. DB::DatabaseFactory::getImpl(DB::ASTCreateQuery const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::Context const>) @ 0x14bc b7eb in /usr/bin/clickhouse 5. DB::DatabaseFactory::get(DB::ASTCreateQuery const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::Context const>) @ 0x14bc8f47 in /usr/bin/clickhouse 6. DB::InterpreterCreateQuery::createDatabase(DB::ASTCreateQuery&) @ 0x14bb0237 in /usr/bin/clickhouse 7. DB::InterpreterCreateQuery::execute() @ 0x14bc5e1b in /usr/bin/clickhouse 8. ? @ 0x14ee8a79 in /usr/bin/clickhouse 9. DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x14ee65f5 in /usr/bin/clickhouse 10. DB::TCPHandler::runImpl() @ 0x159ef43a in /usr/bin/clickhouse 11. DB::TCPHandler::run() @ 0x15a03419 in /usr/bin/clickhouse 12. Poco::Net::TCPServerConnection::start() @ 0x18667a0f in /usr/bin/clickhouse 13. Poco::Net::TCPServerDispatcher::run() @ 0x18669e61 in /usr/bin/clickhouse 14. Poco::PooledThread::run() @ 0x1881a549 in /usr/bin/clickhouse 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x18817c40 in /usr/bin/clickhouse 16. start_thread @ 0x817a in /usr/lib64/libpthread-2.28.so 17. __clone @ 0xfcdc3 in /usr/lib64/libc-2.28.so
Обсуждают сегодня