other error: Request range exceeds bound, request range

[wjhuang2016]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Can't reproduce it.

2. What did you expect to see? (Required)

No error.

3. What did you see instead (Required)

select /*+ use_index_merge( 58b03ac6-008b-49e5-9cfb-b606b4ba6d53 ) */ char( 58b03ac6-008b-49e5-9cfb-b606b4ba6d53.bb9919e5-a660-418e-95ba-b05ea0008398 , 58b03ac6-008b-49e5-9cfb-b606b4ba6d53.bb9919e5-a660-418e-95ba-b05ea0008398 using utf8 ) as r0 , 58b03ac6-008b-49e5-9cfb-b606b4ba6d53.054e9e13-fa17-421b-8584-3888c5b5d2e0 as r1 from 58b03ac6-008b-49e5-9cfb-b606b4ba6d53 where not( 58b03ac6-008b-49e5-9cfb-b606b4ba6d53.e9269562-fe0e-4e98-839a-933e13a95b23 in ( '63m' ,'mj' ,'fdyjr' ,'mj' ) ) or 58b03ac6-008b-49e5-9cfb-b606b4ba6d53.054e9e13-fa17-421b-8584-3888c5b5d2e0 between '8i' and 'twgb' for update

[fatal] [error] [instance 4] ERROR: Error 1105: other error: Request range exceeds bound, request range:[7480000000000007FF8E5F698000000000FF0000020400000000FF0000001100000000FB, 7480000000000007FF8E5F698000000000FF0000020400000000FF0000020000000000FB), physical bound:[7480000000000007FF8E5F698000000000FF0000020400000000FF0000004003800000FF00000001BB000000FD, 7480000000000007FF8E5F698000000000FF0000040003863647FF83FB48B4A4000000FC)

4. What is your TiDB version? (Required)

master

[tiancaiamao]

Take a close look at the range:

Request range:
[7480000000000007FF8E5F698000000000FF0000020400000000FF0000001100000000FB, 
7480000000000007FF8E5F698000000000FF0000020400000000FF0000020000000000FB),

TiKV region boundary:
[7480000000000007FF8E5F698000000000FF0000020400000000FF0000001100000000FB,
 7480000000000007FF8E5F698000000000FF0000020400000000FF0000020000000000FB),

They intersect.

[a      ................       b)
               [c        .................     d)

Maybe the request is build with staled region cache information, and tidb send wrong request to tikv (with wrong range), and tikv throw OtherError back to tidb.
TiDB does not handle that OtherError and throw it to the user.

[tiancaiamao]

It's hard to debug because there is no way to stable reproduce it.