架构图链接:
https://img-blog.csdnimg.cn/20210621142616301.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTMyMDY2MA==,size_16,color_FFFFFF,t_70
显示的错误日志:
--------------------------------------------------------------------------------------------------------------------------------------------------
2021.05.27 11:49:01.454202 [ 26332 ] {ddd3fdd8-fae9-4eaa-baad-880153624cfc} <Error> executeQuery: Code: 210, e.displayText() = DB::NetException: I/O error: Broken pipe, while writing to socket (10.3.126.241:39868) (version 20.4.9.110 (official build)) (from 10.3.126.241:39868) (in query: SELECT 1), Stack trace (when copying this message, always include the lines below):
0. /build/obj-x86_64-linux-gnu/../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) @ 0x110e3bb0 in /usr/lib/debug/usr/bin/clickhouse
1. /build/obj-x86_64-linux-gnu/../src/Common/Exception.cpp:32: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x998493d in /usr/lib/debug/usr/bin/clickhouse
2. /build/obj-x86_64-linux-gnu/../src/Common/NetException.h:12: DB::WriteBufferFromPocoSocket::nextImpl() (.cold) @ 0x9a9a5b4 in /usr/lib/debug/usr/bin/clickhouse
3. /build/obj-x86_64-linux-gnu/../src/IO/WriteBuffer.h:44: DB::WriteBuffer::next() @ 0x99bf4dd in /usr/lib/debug/usr/bin/clickhouse
4. /build/obj-x86_64-linux-gnu/../programs/server/TCPHandler.cpp:1202: DB::TCPHandler::sendProgress() @ 0x9a8429a in /usr/lib/debug/usr/bin/clickhouse
5. /build/obj-x86_64-linux-gnu/../contrib/libcxx/include/memory:4206: DB::TCPHandler::processOrdinaryQueryWithProcessors() @ 0x9a8704e in /usr/lib/debug/usr/bin/clickhouse
6. /build/obj-x86_64-linux-gnu/../programs/server/TCPHandler.cpp:276: DB::TCPHandler::runImpl() @ 0x9a8ae4a in /usr/lib/debug/usr/bin/clickhouse
7. /build/obj-x86_64-linux-gnu/../programs/server/TCPHandler.cpp:1242: DB::TCPHandler::run() @ 0x9a8bd70 in /usr/lib/debug/usr/bin/clickhouse
8. /build/obj-x86_64-linux-gnu/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x10fcf92b in /usr/lib/debug/usr/bin/clickhouse
9. /build/obj-x86_64-linux-gnu/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x10fcfdbb in /usr/lib/debug/usr/bin/clickhouse
10. /build/obj-x86_64-linux-gnu/../contrib/poco/Foundation/include/Poco/Mutex_POSIX.h:59: Poco::PooledThread::run() @ 0x1117d986 in /usr/lib/debug/usr/bin/clickhouse
11. /build/obj-x86_64-linux-gnu/../contrib/poco/Foundation/include/Poco/AutoPtr.h:223: Poco::ThreadImpl::runnableEntry(void*) @ 0x11178c40 in /usr/lib/debug/usr/bin/clickhouse
12. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
13. clone @ 0xfe8cd in /usr/lib64/libc-2.17.so
--------------------------------------------------------------------------------------------------------------------------------------------------
<max_connections>4096</max_connections>
<keep_alive_timeout>3</keep_alive_timeout>
<max_concurrent_queries>100</max_concurrent_queries>
数据库自身排查过程(复制链接查看图片):
https://img-blog.csdnimg.cn/20210621113101923.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTMyMDY2MA==,size_16,color_FFFFFF,t_70
https://img-blog.csdnimg.cn/20210621111947149.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTMyMDY2MA==,size_16,color_FFFFFF,t_70
https://img-blog.csdnimg.cn/20210621113155776.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTMyMDY2MA==,size_16,color_FFFFFF,t_70
相似问题