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

tikv report "Request range exceeds bound" when query partition table in 6.1 #43144

Closed
lcwangchao opened this issue Apr 18, 2023 · 2 comments
Closed
Labels

Comments

@lcwangchao
Copy link
Collaborator

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

> CREATE TABLE tp (id int, c varchar(128), key c(c)) partition by range (id) (partition p0 values less than (10), partition p1 values less than MAXVALUE);
> alter table tp truncate partition p0;
> insert into tp values(100, 'a');
> insert into tp select * from tp; -- do many times until regions split
> analyze table tp;
> select * from tp limit 1000000, 1;

2. What did you expect to see? (Required)

no error

3. What did you see instead (Required)

TiDB root@127.0.0.1:test> select * from tp limit 1000000, 1;
(1105, 'other error: Request range exceeds bound, request range:[7480000000000000FF865F720000000000FF0000000000000000FA, 7480000000000000FF865F72FFFFFFFFFFFFFFFFFF0000000000FB), physical bound:[7480000000000000FF865F728000000000FF0BAD150000000000FA, 748000FFFFFFFFFFFFF900000000000000F8)')

4. What is your TiDB version? (Required)

6.1.2

@lcwangchao lcwangchao added the type/bug This issue is a bug. label Apr 18, 2023
@ti-chi-bot ti-chi-bot added may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.5 labels Apr 19, 2023
@seiya-annie seiya-annie removed may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.5 labels Apr 19, 2023
@zanmato1984 zanmato1984 added sig/sql-infra SIG: SQL Infra and removed sig/execution SIG execution labels Apr 23, 2023
@bb7133
Copy link
Member

bb7133 commented Apr 23, 2023

@lcwangchao Can we close it now?

@lcwangchao
Copy link
Collaborator Author

@lcwangchao Can we close it now?

yes, I think so

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

No branches or pull requests

7 participants