ERROR 1105 (HY000): other error for mpp stream

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

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

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

【附件】

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

您好,请问使用 tikv 查询是否会报错?

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

有解决吗?分享下

tikv不会报错

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

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]\n1. bin/tiflash/tiflash(DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, int)+0x26) [0x36b5ba6]\n2. bin/tiflash/tiflash(DB::SharedQueryBlockInputStream::readImpl()+0x410) [0x3703700]\n3. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\n4. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\n5. bin/tiflash/tiflash(DB::ExchangeSender::readImpl()+0x1b) [0x7cebbab]\n6. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\n7. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\n8. bin/tiflash/tiflash(DB::ParallelInputsProcessor<DB::UnionBlockInputStream<(DB::StreamUnionMode)0, true>::Handler, (DB::StreamUnionMode)0>::loop(unsigned long)+0x143) [0x7c51043]\n9. bin/tiflash/tiflash(DB::ParallelInputsProcessor<DB::UnionBlockInputStream<(DB::StreamUnionMode)0, true>::Handler, (DB::StreamUnionMode)0>::thread(unsigned long)+0x1cc) [0x7c5166c]\n10. bin/tiflash/tiflash(_ZNSt6thread11_State_implINS_8_InvokerISt5tupleIJZN2DB13ThreadFactory9newThreadISt8functionIFvvEEJEEES_bNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEEOT_DpOT0_EUlDpOT_E_EEEEE6_M_runEv+0x63) [0x7daf993]\n11. bin/tiflash/tiflash() [0x8abcbef]\n12. /lib64/libpthread.so.0(+0x7e25) [0x7f0b9cea1e25]\n13. /lib64/libc.so.6(clone+0x6d) [0x7f0b9c8c9bad]\n”] [thread_id=31266451]

[] [“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: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception: \nCode: 0, e.displayText() = DB::Exception: keepalive watchdog timeout, e.what() = DB::Exception, e.what() = DB::Exception, Stack trace:\n\n0. bin/tiflash/tiflash(StackTrace::StackTrace()+0x16) [0x36c1d76]\n1. bin/tiflash/tiflash(DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, int)+0x26) [0x36b5ba6]\n2. bin/tiflash/tiflash(DB::SharedQueryBlockInputStream::readImpl()+0x410) [0x3703700]\n3. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\n4. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\n5. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\n6. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\n7. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\n8. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\n9. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\n10. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\n11. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\n12. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\n13. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\n14. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\n15. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x278) [0x6d81858]\n16. bin/tiflash/tiflash(DB::FilterBlockInputStream::readImpl()+0xe9) [0x7abb489]\n17. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\n18. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\n19. bin/tiflash/tiflash(DB::ExpressionBlockInputStream::readImpl()+0x1b) [0x7ab68cb]\n20. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\n21. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\n22. bin/tiflash/tiflash(DB::PartialSortingBlockInputStream::readImpl()+0x1b) [0x7ae5feb]\n23. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator, 15ul, 16ul>&, bool)+0x3bd) [0x6d8199d]\n24. bin/tiflash/tiflash(DB::IProfilingBlockInputStream::read()+0x17) [0x6d81b87]\n25. bin/tiflash/tiflash(DB::ParallelInputsProcessor<DB::UnionBlockInputStream<(DB::StreamUnionMode)0, false>::Handler, (DB::StreamUnionMode)0>::loop(unsigned long)+0x101) [0x74d9591]\n26. bin/tiflash/tiflash(DB::ParallelInputsProcessor<DB::UnionBlockInputStream<(DB::StreamUnionMode)0, false>::Handler, (DB::StreamUnionMode)0>::thread(unsigned long)+0x1f0) [0x74d9e60]\n27. bin/tiflash/tiflash(_ZNSt6thread11_State_implINS_8_InvokerISt5tupleIJZN2DB13ThreadFactory9newThreadISt8functionIFvvEEJEEES_bNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEEOT_DpOT0_EUlDpOT_E_EEEEE6_M_runEv+0x63) [0x7daf993]\n28. bin/tiflash/tiflash() [0x8abcbef]\n29. /lib64/libpthread.so.0(+0x7e25) [0x7f0b9cea1e25]\n30. /lib64/libc.so.6(clone+0x6d) [0x7f0b9c8c9bad]\n”] [thread_id=31266451]

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

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

好的,谢谢