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

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

Ascending order - Click to sort in descending order

Roel Van de Paar created issue - 2023-03-09 22:43

Roel Van de Paar made changes - 2023-03-09 22:44

Field	Original Value	New Value
Description	{code:sql} 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; {code} Leads to: {noformat:title=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 {noformat} Discussed with [~danblack] who already developed a fix.	{code:sql} 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; {code} Leads to: {noformat:title=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 {noformat} Bug confirmed present in: MariaDB: 10.3.38 (dbg), 10.3.38 (opt), 10.4.29 (dbg), 10.4.29 (opt), 10.5.20 (dbg), 10.5.20 (opt), 10.6.13 (dbg), 10.6.13 (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.

Roel Van de Paar made changes - 2023-03-09 22:44

Status

Open [ 1 ]

Confirmed [ 10101 ]

Daniel Black made changes - 2023-03-10 02:44

Summary

InnoDB: Page compression errors: 3

innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error

Daniel Black made changes - 2023-03-10 02:55

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Daniel Black made changes - 2023-03-10 02:56

Assignee	Daniel Black [ danblack ]	Marko Mäkelä [ marko ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Daniel Black made changes - 2023-03-10 02:56

Fix Version/s		10.5.20 [ 28512 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s	10.7 [ 24805 ]
Fix Version/s	10.8 [ 26121 ]
Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]
Fix Version/s	10.11 [ 27614 ]

Daniel Black made changes - 2023-03-10 02:57

Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.0 [ 28320 ]
Fix Version/s	10.5.20 [ 28512 ]

Daniel Black made changes - 2023-03-10 02:58

Affects Version/s		10.6.12 [ 28513 ]
Affects Version/s		10.5.19 [ 28511 ]
Affects Version/s		10.4.28 [ 28509 ]
Affects Version/s		10.3.37 [ 28404 ]

Roel Van de Paar made changes - 2023-03-10 03:09

Description

{code:sql}
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;
{code}
Leads to:
{noformat:title=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
{noformat}

Bug confirmed present in:
MariaDB: 10.3.38 (dbg), 10.3.38 (opt), 10.4.29 (dbg), 10.4.29 (opt), 10.5.20 (dbg), 10.5.20 (opt), 10.6.13 (dbg), 10.6.13 (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.

{code:sql}
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;
{code}
Leads to:
{noformat:title=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
{noformat}

Bug confirmed present in:
MariaDB: 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.

Roel Van de Paar made changes - 2023-03-10 03:22

Description

{code:sql}
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;
{code}
Leads to:
{noformat:title=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
{noformat}

Bug confirmed present in:
MariaDB: 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.

{code:sql}
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;
{code}
Leads to:
{noformat:title=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
{noformat}

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.

Marko Mäkelä made changes - 2023-03-10 06:47

Assignee	Marko Mäkelä [ marko ]	Daniel Black [ danblack ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Julien Fritsch made changes - 2023-04-27 14:57

Fix Version/s

10.8 [ 26121 ]

Daniel Black made changes - 2023-10-17 04:06

Assignee	Daniel Black [ danblack ]	Marko Mäkelä [ marko ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2023-10-17 12:46

Assignee	Marko Mäkelä [ marko ]	Daniel Black [ danblack ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Daniel Black made changes - 2023-10-18 08:19

issue.field.resolutiondate

2023-10-18 08:19:43.0

2023-10-18 08:19:42.524

Daniel Black made changes - 2023-10-18 08:19

Fix Version/s		10.4.32 [ 29300 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]
Fix Version/s	10.11 [ 27614 ]
Fix Version/s	11.0 [ 28320 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

JiraAutomate made changes - 2023-10-18 08:19

Fix Version/s		10.5.23 [ 29012 ]
Fix Version/s		10.6.16 [ 29014 ]
Fix Version/s		10.10.7 [ 29018 ]
Fix Version/s		10.11.6 [ 29020 ]
Fix Version/s		11.0.4 [ 29021 ]
Fix Version/s		11.1.3 [ 29023 ]

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.

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration