ERROR 1105 (HY000): other error for mpp stream

magongyong · 2022 年9 月 8 日 11:42

【 TiDB 使用环境】生产环境
【 TiDB 版本】5.4.0
【遇到的问题】

【复现路径】做过哪些操作出现的问题
sql查询的日期范围内没有数据，就会报错，有数据是正常的

【问题现象及影响】
使用tiflash报错，无影响

【附件】

请提供各个组件的 version 信息，如 cdc/tikv，可通过执行 cdc version/tikv-server --version 获取。

Min_Chen · 2022 年9 月 14 日 03:12

您好，请问使用 tikv 查询是否会报错？

Min_Chen · 2022 年9 月 14 日 03:16

麻烦提供一下复现期间 tidb 和 tiflash 的日志。

alfred · 2022 年9 月 14 日 06:08

有解决吗？分享下

magongyong · 2022 年9 月 20 日 11:44

tikv不会报错

magongyong · 2022 年9 月 20 日 11:45

还没解决，一直有，5.4.0版本

magongyong · 2022 年9 月 20 日 11:56

TiFlash日志如下：
[MPPTask.cpp:334] [“MPPTask:query:436122339549642851:10,task task running meets error: DB::Exception: keepalive watchdog timeout Stack Trace : 0. bin/tiflash/tiflash(StackTrace::StackTrace()+0x16) [0x36c1d76]\ 1. bin/tiflash/tiflash(DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, int)+0x26) [0x36b5ba6]\ 2. bin/tiflash/tiflash(DB::SharedQueryBlockInputStream::readImpl()+0x410) [0x3703700]\ 3. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\ 4. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\ 5. bin/tiflash/tiflash(DB::ExchangeSender::readImpl()+0x1b) [0x7cebbab]\ 6. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\ 7. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\ 8. bin/tiflash/tiflash(DB::ParallelInputsProcessor<DB::UnionBlockInputStream<(DB::StreamUnionMode)0, true>::Handler, (DB::StreamUnionMode)0>::loop(unsigned long)+0x143) [0x7c51043]\ 9. bin/tiflash/tiflash(DB::ParallelInputsProcessor<DB::UnionBlockInputStream<(DB::StreamUnionMode)0, true>::Handler, (DB::StreamUnionMode)0>::thread(unsigned long)+0x1cc) [0x7c5166c]\ 10. bin/tiflash/tiflash(_ZNSt6thread11_State_implINS_8_InvokerISt5tupleIJZN2DB13ThreadFactory9newThreadISt8functionIFvvEEJEEES_bNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEEOT_DpOT0_EUlDpOT_E_EEEEE6_M_runEv+0x63) [0x7daf993]\ 11. bin/tiflash/tiflash() [0x8abcbef]\ 12. /lib64/libpthread.so.0(+0x7e25) [0x7f0b9cea1e25]\ 13. /lib64/libc.so.6(clone+0x6d) [0x7f0b9c8c9bad]\ ”] [thread_id=31266451]

magongyong · 2022 年9 月 20 日 11:58

[] [“DB::UnionBlockInputStream<mode, ignore_block>::~UnionBlockInputStream() [with DB::StreamUnionMode mode = (DB::StreamUnionMode)0; bool ignore_block = false]:Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \ Code: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception, e.what() = DB::Exception, Stack trace:\ \ 0. bin/tiflash/tiflash(StackTrace::StackTrace()+0x16) [0x36c1d76]\ 1. bin/tiflash/tiflash(DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, int)+0x26) [0x36b5ba6]\ 2. bin/tiflash/tiflash(DB::SharedQueryBlockInputStream::readImpl()+0x410) [0x3703700]\ 3. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\ 4. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\ 5. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\ 6. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\ 7. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\ 8. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\ 9. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\ 10. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\ 11. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\ 12. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\ 13. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\ 14. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\ 15. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x278) [0x6d81858]\ 16. bin/tiflash/tiflash(DB::FilterBlockInputStream::readImpl()+0xe9) [0x7abb489]\ 17. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\ 18. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\ 19. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\ 20. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\ 21. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\ 22. bin/tiflash/tiflash(DB::PartialSortingBlockInputStream::readImpl()+0x1b) [0x7ae5feb]\ 23. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\ 24. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\ 25. bin/tiflash/tiflash(DB::ParallelInputsProcessor<DB::UnionBlockInputStream<(DB::StreamUnionMode)0, false>::Handler, (DB::StreamUnionMode)0>::loop(unsigned long)+0x101) [0x74d9591]\ 26. bin/tiflash/tiflash(DB::ParallelInputsProcessor<DB::UnionBlockInputStream<(DB::StreamUnionMode)0, false>::Handler, (DB::StreamUnionMode)0>::thread(unsigned long)+0x1f0) [0x74d9e60]\ 27. bin/tiflash/tiflash(_ZNSt6thread11_State_implINS_8_InvokerISt5tupleIJZN2DB13ThreadFactory9newThreadISt8functionIFvvEEJEEES_bNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEEOT_DpOT0_EUlDpOT_E_EEEEE6_M_runEv+0x63) [0x7daf993]\ 28. bin/tiflash/tiflash() [0x8abcbef]\ 29. /lib64/libpthread.so.0(+0x7e25) [0x7f0b9cea1e25]\ 30. /lib64/libc.so.6(clone+0x6d) [0x7f0b9c8c9bad]\ ”] [thread_id=31266451]

magongyong · 2022 年9 月 20 日 12:00

只有tiflash报错日志，tidb没有报错日志

Aric · 2022 年9 月 21 日 05:46

升级到小版本号最新吧，已知问题 --> https://github.com/pingcap/tiflash/pull/4655

magongyong · 2022 年9 月 23 日 09:30

好的，谢谢

system · 2022 年11 月 22 日 09:31

此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。