MySQL Bugs: #114248: Incomplete query results when backward scan and concurrent page merge

Bug #114248	Incomplete query results when backward scan and concurrent page merge
Submitted:	6 Mar 2024 16:22	Modified:	7 Mar 2024 13:57
Reporter:	Dmitry Lenev (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	8.0.36, 5.7.44	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Contribution

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

Non-deterministic test case showing the problem.

Attachment: innodb_backward_scan_conc_merge.test (application/octet-stream, text), 3.13 KiB.

Result file for test case.

Attachment: innodb_backward_scan_conc_merge.result (application/octet-stream, text), 2.57 KiB.