Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] Request range exceeds bound #2719

Closed
shiyuhang0 opened this issue Jun 13, 2023 · 2 comments
Closed

[BUG] Request range exceeds bound #2719

shiyuhang0 opened this issue Jun 13, 2023 · 2 comments

Comments

@shiyuhang0
Copy link
Member

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
Copy link

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

@github-actions github-actions bot added the stale label Jul 14, 2023
@github-actions
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant