[BUG] Request range exceeds bound
shiyuhang0 opened this issue · 2 comments
shiyuhang0 commented
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
github-actions commented
This issue is stale because it has been open for 30 days with no activity.
github-actions commented
This issue was closed because it has been inactive for 14 days since being marked as stale.