pingcap/tispark

[BUG] Request range exceeds bound

shiyuhang0 opened this issue · 2 comments

Describe the bug

error

Caused by: com.pingcap.tikv.exception.GrpcException: Request range exceeds bound, request range:[74800000000000F0FF8E5F720130303343FF4F423233FF303532FF3530303030FF3335FF323131000000FC00FE, 74800000000000F0FF8E5F720130303343FF4F423233FF303532FF3530303030FF3335FF323131000000FD00FE), physical bound:[74800000000000F0FF8E5F720130303343FF4F423233FF303532FF3430303030FF3038FF393131000000FC00FE, 74800000000000F0FF8E5F720130303343FF4F423233FF303532FF3530303030FF3335FF323131000000FC00FF0000000000000000F7)

SQL

SQL:
SELECT `cst_daily`.`cusno`,
`cst_daily`.`cus_tp`,
`cst_daily`.`rgn_code`,
`cst_daily`.`blg_org_refno`,
`ca`.`temp_cusno`,
`ca`.`txn_reqno`,
`ca`.`case_refno`,
`msg_cst_inf`.`cus_rsk_lvl_fnl`,
`msg_cst_inf`.`rv_exp_dt` `afchg_rv_exp_dt`,
`msg_cst_inf`.`poli_flag` `new_poli`,
`msg_cst_inf`.`fst_kyc_dt` `new_fst_kyc_dt`,
`msg_cst_inf`.`sdd_cus_tp` `new_sdd`,
`msg_cst_inf`.`ext_sanct_nmlst_flag` `new_black`,
`msg_cst_inf`.`poli_flag_dttm` `new_poli_flag_dttm`,
`msg_cst_inf`.`ext_sanct_nmlst_flag_dttm` `new_ext_sanct_nmlst_flag_dttm`,
`cst`.`aml_rsk_lvl`,
`cst`.`rv_exp_dt` `bfchg_rv_exp_dt`,
`cst`.`poli_flag` `old_poli`,
`cst`.`sdd_cus_tp` `old_sdd`,
`cst`.`ext_sanct_nmlst_flag` `old_black`
FROM `tidb_catalog`.`SZ_ONLINE_KYC`.`CASE_ACCESS` `ca`
INNER JOIN `tidb_catalog`.`SZ_ONLINE_KYC`.`MSG_CST_INFO` `msg_cst_inf`
ON `msg_cst_inf`.`txn_reqno` = `ca`.`txn_reqno` AND `msg_cst_inf`.`cusno` = `ca`.`temp_cusno`
INNER JOIN `tidb_catalog`.`SZ_ONLINE_KYC`.`KYC_CIF_CST_DAILY` `cst_daily`
ON `cst_daily`.`cus_name` = `ca`.`cus_name` AND `cst_daily`.`crdt_tp` = `ca`.`crdt_tp` AND
`cst_daily`.`crad` = `ca`.`crad`
INNER JOIN `tidb_catalog`.`SZ_ONLINE_KYC`.`KYC_CIF_CST` `cst` ON `cst`.`cusno` = `cst_daily`.`cusno`
WHERE `ca`.`cusno` = `ca`.`temp_cusno`
AND `ca`.`temp_cusno` LIKE 'T%' ESCAPE '

DDL: unknown

Root cause

not find yet

Maybe it has something to do with this pr: pingcap/tidb#43146

Spark and TiSpark version info

Spark:v3.1_2.12-3.1.2rc4 (a version for our customer, I think it is similar to 3.1_2.12-3.1.3)
TiSpark: v3.1.3
TiDB: v6.5.2

This issue is stale because it has been open for 30 days with no activity.

This issue was closed because it has been inactive for 14 days since being marked as stale.