ERROR 1105 (HY000): other error for MPP stream

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: ERROR 1105 (HY000): other error for mpp stream

| username: magongyong

[TiDB Usage Environment] Production Environment
[TiDB Version] 5.4.0
[Encountered Problem]

Image
Image978×532 19.9 KB

[Reproduction Path] Operations performed that led to the problem
When there is no data within the date range queried by SQL, an error occurs. It works fine when there is data.

[Problem Phenomenon and Impact]
Error occurs when using TiFlash, no impact.

[Attachments]

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: Min_Chen | Original post link

Hello, will there be an error when querying with TiKV?

3
| username: Min_Chen | Original post link

Please provide the logs of TiDB and TiFlash during the reproduction period.

4
| username: alfred | Original post link

Has it been resolved? Please share.

5
| username: magongyong | Original post link

TiKV will not report an error.

6
| username: magongyong | Original post link

It hasn’t been resolved, it’s still there, version 5.4.0.

7
| username: magongyong | Original post link

The TiFlash log is as follows:
[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]
8
| username: magongyong | Original post link

[] ["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]
9
| username: magongyong | Original post link

Only TiFlash has error logs, TiDB does not have error logs.

10
| username: jansu-dev | Original post link

Upgrade to the latest minor version, known issue → update client-c to disable grpc client keepalive by windtalker · Pull Request #4655 · pingcap/tiflash · GitHub

11
| username: magongyong | Original post link

Okay, thank you.

12
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.