pingcap / tispark

TiSpark is built for running Apache Spark on top of TiDB/TiKV
Apache License 2.0
880 stars 244 forks source link

[BUG] Request range exceeds bound #2719

Closed shiyuhang0 closed 11 months ago

shiyuhang0 commented 1 year ago

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: https://github.com/pingcap/tidb/pull/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[bot] commented 1 year ago

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

github-actions[bot] commented 11 months ago

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