[MDEV-30825] innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3.37, 10.4.28, 10.5.19, 10.6.12, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3
Component/s: Storage Engine - InnoDB
Labels:
- compression
- regression-10.7

Description

SET GLOBAL innodb_checksum_algorithm=1, innodb_compression_algorithm=0;

CREATE TABLE t (c INT) page_compressed=1 page_compression_level=4 ENGINE=InnoDB;

SHUTDOWN;

Leads to:

11.0.1 f2dc4d4c10ac36a73b5c1eb765352d3aee808d66 (Optimized)
2023-03-07 21:44:53 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-03-07 21:44:53 0 [Warning] InnoDB: Page compression errors: 3
2023-03-07 21:44:53 0 [Note] InnoDB: Shutdown completed; log sequence number 58233; transaction id 19

Bug confirmed present in:
MariaDB: 10.4.29 (dbg), 10.4.29 (opt), 10.7.8 (dbg), 10.7.8 (opt), 10.8.8 (dbg), 10.8.8 (opt), 10.9.6 (dbg), 10.9.6 (opt), 10.10.4 (dbg), 10.10.4 (opt), 10.11.2 (dbg), 10.11.2 (opt), 11.0.1 (dbg), 11.0.1 (opt)

Discussed with danblack who already developed a fix.

Attachments

Activity

People

Assignee:: Daniel Black

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2023-03-09 22:43

Updated:: 2023-10-18 08:19

Resolved:: 2023-10-18 08:19

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.