Skip to content

Instantly share code, notes, and snippets.

@azat

azat/use_compact_format_in_distributed_parts_names=0.error.sql

Created December 8, 2020 08:17
Show Gist options
  • Save azat/45f128f304ba95e1003b55dcac3232ec to your computer and use it in GitHub Desktop.
Save azat/45f128f304ba95e1003b55dcac3232ec to your computer and use it in GitHub Desktop.
Download ZIP
system.distribution_queue.sql
Raw
use_compact_format_in_distributed_parts_names=0.error.sql
SELECT *
FROM system.distribution_queue
FORMAT Vertical
Query id: bb17b27d-c681-4826-8eb6-607a960414f3
Row 1:
──────
database: default
table: dist
data_path: ./store/e08/e083c4a8-a7a7-40bc-9f12-1cd1232f9847/default:*@127%2E0%2E0%2E2:9000/
is_blocked: 0
error_count: 3
data_files: 1
data_compressed_bytes: 499
last_exception: Code: 516, e.displayText() = DB::Exception: Received from 127.0.0.2:9000. DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name. Stack trace:
0. /build/build_docker/../contrib/poco/Foundation/src/Exception.cpp:27: Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x10e63e60 in /src/ch/tmp/17665/clickhouse
1. /build/build_docker/../src/Common/Exception.cpp:39: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x793bda5 in /src/ch/tmp/17665/clickhouse
2. /build/build_docker/../contrib/libcxx/include/string:2134: DB::IAccessStorage::throwCannotAuthenticate(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0xd3ceac5 in /src/ch/tmp/17665/clickhouse
3. /build/build_docker/../src/Access/IAccessStorage.cpp:436: DB::IAccessStorage::login(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::alloca
tor<char> > const&, Poco::Net::IPAddress const&, DB::ExternalAuthenticators const&, bool) const (.cold) @ 0xd3ceb83 in /src/ch/tmp/17665/clickhouse
4. /build/build_docker/../src/Interpreters/Context.cpp:691: DB::Context::setUserImpl(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::optional<std::__1::basic_string<char, std::__1::char_traits<char>,
std::__1::allocator<char> > > const&, Poco::Net::SocketAddress const&) @ 0xd731d1f in /src/ch/tmp/17665/clickhouse
5. /build/build_docker/../contrib/libcxx/include/optional:224: DB::Context::setUser(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&, Poco::Net::SocketAddress const&) @ 0xd731f77 in /src/ch/tmp/17665/clickhouse
6. /build/build_docker/../src/Server/TCPHandler.cpp:779: DB::TCPHandler::receiveHello() @ 0xe521bfb in /src/ch/tmp/17665/clickhouse
7. /build/build_docker/../contrib/libcxx/include/string:1426: DB::TCPHandler::runImpl() @ 0xe528ea9 in /src/ch/tmp/17665/clickhouse
8. /build/build_docker/../src/Server/TCPHandler.cpp:1339: DB::TCPHandler::run() @ 0xe52a9ae in /src/ch/tmp/17665/clickhouse
9. /build/build_docker/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x10dabf1b in /src/ch/tmp/17665/clickhouse
10. /build/build_docker/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x10dac638 in /src/ch/tmp/17665/clickhouse
11. /build/build_docker/../contrib/poco/Foundation/include/Poco/Mutex_POSIX.h:59: Poco::PooledThread::run() @ 0x10ef06f6 in /src/ch/tmp/17665/clickhouse
12. /build/build_docker/../contrib/poco/Foundation/include/Poco/AutoPtr.h:215: Poco::ThreadImpl::runnableEntry(void*) @ 0x10eebe60 in /src/ch/tmp/17665/clickhouse
13. start_thread @ 0x93e9 in /usr/lib/libpthread-2.32.so
14. __GI___clone @ 0x100293 in /usr/lib/libc-2.32.so
(version 20.13.1.5343)
1 rows in set. Elapsed: 0.004 sec.
Raw
use_compact_format_in_distributed_parts_names=0.sql
SELECT *
FROM system.distribution_queue
FORMAT Vertical
Query id: 3ec6d2fd-0ad2-4658-9f62-621621c57e58
Row 1:
──────
database: default
table: dist
data_path: ./store/268/268bc070-3aad-4b1a-9cf2-4987580161af/default@127%2E0%2E0%2E2:9000/
is_blocked: 1
error_count: 0
data_files: 1
data_compressed_bytes: 499
last_exception:
Raw
use_compact_format_in_distributed_parts_names=1.error.sql
SELECT *
FROM system.distribution_queue
FORMAT Vertical
Query id: 1c4749b2-9146-47ee-b0fd-52265b11d37d
Row 1:
──────
database: default
table: dist
data_path: ./store/ac8/ac832b60-b82b-4567-b2d6-e57d4366e556/shard2_replica1/
is_blocked: 0
error_count: 7
data_files: 1
data_compressed_bytes: 450
last_exception: Code: 60, e.displayText() = DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Table default.null doesn't exist.. Stack trace:
0. /build/build_docker/../contrib/poco/Foundation/src/Exception.cpp:27: Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x10e63e60 in /src/ch/tmp/17665/clickhouse
1. /build/build_docker/../src/Common/Exception.cpp:39: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x793bda5 in /src/ch/tmp/17665/clickhouse
2. /build/build_docker/../contrib/libcxx/include/optional:324: DB::DatabaseCatalog::getTableImpl(DB::StorageID const&, DB::Context const&, std::__1::optional<DB::Exception>*) const @ 0xd7a550a in /src/ch/tmp/17665/clickhouse
3. /build/build_docker/../contrib/libcxx/include/memory:3821: DB::DatabaseCatalog::getTable(DB::StorageID const&, DB::Context const&) const @ 0xd7a5734 in /src/ch/tmp/17665/clickhouse
4. /build/build_docker/../src/Interpreters/InterpreterInsertQuery.cpp:76: DB::InterpreterInsertQuery::getTable(DB::ASTInsertQuery&) @ 0xd9ef940 in /src/ch/tmp/17665/clickhouse
5. /build/build_docker/../src/Interpreters/InterpreterInsertQuery.cpp:187: DB::InterpreterInsertQuery::execute() @ 0xd9f0c05 in /src/ch/tmp/17665/clickhouse
6. /build/build_docker/../src/Interpreters/executeQuery.cpp:507: DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*) @ 0xdd6cdbf in /src/ch/tmp/17665/clickhouse
7. /build/build_docker/../src/Interpreters/executeQuery.cpp:840: DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool) @ 0xdd6ed11 in /src/ch/tmp/17665/clickhouse
8. /build/build_docker/../src/Server/TCPHandler.cpp:255: DB::TCPHandler::runImpl() @ 0xe529809 in /src/ch/tmp/17665/clickhouse
9. /build/build_docker/../src/Server/TCPHandler.cpp:1339: DB::TCPHandler::run() @ 0xe52a9ae in /src/ch/tmp/17665/clickhouse
10. /build/build_docker/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x10dabf1b in /src/ch/tmp/17665/clickhouse
11. /build/build_docker/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x10dac638 in /src/ch/tmp/17665/clickhouse
12. /build/build_docker/../contrib/poco/Foundation/include/Poco/Mutex_POSIX.h:59: Poco::PooledThread::run() @ 0x10ef06f6 in /src/ch/tmp/17665/clickhouse
13. /build/build_docker/../contrib/poco/Foundation/include/Poco/AutoPtr.h:215: Poco::ThreadImpl::runnableEntry(void*) @ 0x10eebe60 in /src/ch/tmp/17665/clickhouse
14. start_thread @ 0x93e9 in /usr/lib/libpthread-2.32.so
15. __GI___clone @ 0x100293 in /usr/lib/libc-2.32.so
(version 20.13.1.5343)
1 rows in set. Elapsed: 0.002 sec.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment