[Bug] Deep paging problem;

[zzj1234-cmd]

Search before asking

• I had searched in the issues and found no similar issues.

Version

apache-doris-2.1.8.1-bin-x64

What's Wrong?

SELECT * from account_voucher_list order by id limit 23000000,10;
The following exception was reported when performing deep paging query:
FullGC release wg overcommit mem, wg id:1, name:normal, used:5.12 GB,limit:4.18 GB,backend:127.0.0.1. cancel top memory used tracker consumption 5.12 GB. details:process memory used 6.44 GB exceed soft limit 12.53 GB or sys available memory 546.90 MB less than warning water mark 1.55 GB.
When I changed it to the following according to the official website's suggestions, I still got an error
SELECT * from account_voucher_list
where account_voucher_list.id > (select id from account_voucher_list order by id limit 1 offset 22999999)
order by id limit 10;

What You Expected?

Doris can support deep paging without memory overflow.

How to Reproduce?

Check the last few pages in the table of 23 million data.

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[kwonder0926]

I’m encountering the same issue. Have you found a good solution?

[github-actions]

We're closing this issue because it hasn't been updated in a while.
If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!