# [KB]关于Tispark-查询报错-Caused-by--com.pingcap.tikv.exception.GrpcException--Request-range-exceeds-bound,-request-range

## Issue

通过 Tispark 对 TiDB 进行查询，执行返回报错：

```golang
Error running query: org.apache.spark.SparkException: Job aborted due to stage failure: Task 33 in stage 1686.0 failed 3 times, most recent failure: Lost task 33.2 in stage 1686.0 (TID 140510, gdc-dn31-redpoll.i.nease.net, executor 373): com.pingcap.tikv.exception.TiClientInternalException: Error reading region:
 at com.pingcap.tikv.operation.iterator.DAGIterator.doReadNextRegionChunks(DAGIterator.java:189)
 at com.pingcap.tikv.operation.iterator.DAGIterator.readNextRegionChunks(DAGIterator.java:166)
...
Caused by: java.util.concurrent.ExecutionException: com.pingcap.tikv.exception.RegionTaskException: Handle region task failed:
 at java.util.concurrent.FutureTask.report(FutureTask.java:122)
 at java.util.concurrent.FutureTask.get(FutureTask.java:192)
 at com.pingcap.tikv.operation.iterator.DAGIterator.doReadNextRegionChunks(DAGIterator.java:184)
 ... 22 more
Caused by: com.pingcap.tikv.exception.RegionTaskException: Handle region task failed:
 at com.pingcap.tikv.operation.iterator.DAGIterator.process(DAGIterator.java:233)
 at com.pingcap.tikv.operation.iterator.DAGIterator.lambda$submitTasks$1(DAGIterator.java:90)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 ... 3 more
Caused by: com.pingcap.tikv.exception.GrpcException: Request range exceeds bound, request range:[7480000000000001FF895F728000000009FF68B32D0000000000FA, 7480000000000001FF895F728000000009FF8AB1F10000000000FA), physical bound:[7480000000000001FF895F728000000009FF774A470000000000FA, 7480000000000001FF895F728000000009FF8AB1F10000000000FA)
 at com.pingcap.tikv.region.RegionStoreClient.handleCopResponse(RegionStoreClient.java:713)
 at com.pingcap.tikv.region.RegionStoreClient.coprocess(RegionStoreClient.java:660)
 at com.pingcap.tikv.operation.iterator.DAGIterator.process(DAGIterator.java:219)
 ... 7 moreDriver stacktrace:
2021-10-12 22:29:01,567 ERROR: [__main__.py:63] - GDC SQL Query fa
```

## Root Cause

Tispark 关于 region cache 的 Bug 引起的问题。

PR：[https://github.com/pingcap/tispark/pull/1987](https://github.com/pingcap/tispark/pull/1987)

## Diagnostic Steps

* Tispark 不是所有的 SQL 执行失败，只是执行特定的 SQL 失败。
* Tispark 的返回类似的错误：

```golang
Request range exceeds bound, request range:[xxxxxxx, xxxxxxx), physical bound:[xxxxxxx, xxxxxxx)
```

* 版本在 2.1 - 2.4 之间

## Resolution

升级 Tispark 版本: 2.4.2 、2.3.17

## Workaround

重启 spark