Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30825

innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error

Details

    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 Roel Van de Paar created issue -
          Roel Roel Van de Paar made changes -
          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 Roel Van de Paar made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          danblack Daniel Black made changes -
          Summary InnoDB: Page compression errors: 3 innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error
          danblack Daniel Black made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          danblack Daniel Black added a comment -

          https://github.com/MariaDB/server/pull/2538

          note two questions in PR on getting the test case cleaner/right.

          danblack Daniel Black added a comment - https://github.com/MariaDB/server/pull/2538 note two questions in PR on getting the test case cleaner/right.
          danblack Daniel Black made changes -
          Assignee Daniel Black [ danblack ] Marko Mäkelä [ marko ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          danblack Daniel Black made changes -
          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 ]
          danblack Daniel Black made changes -
          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 ]
          danblack Daniel Black made changes -
          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 Roel Van de Paar made changes -
          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 Roel Van de Paar added a comment - - edited

          Interestingly, with this testcase:

          SET GLOBAL innodb_checksum_algorithm=1, innodb_compression_algorithm=0;
          		 
          CREATE TABLE t (c INT) page_compressed=1 page_compression_level=4 ENGINE=InnoDB;
          		 
          FLUSH TABLES;
          		 
          SELECT SLEEP(2);
          		 
          SHOW GLOBAL STATUS LIKE 'Innodb_num_pages_page_compression_error';

          I can repeat the issue in 10.4 dbg/opt (Innodb_num_pages_page_compression_error console output only, no error log warning) rev cacea31687c098c0348deb1e433f4baddd817419. However, not in any other version (tested 10.5 to 10.7). And in 10.7+ we have the error log warning.
          It seems there is a difference between versions (10.4, 10.5/6, 10.7+)

          Roel Roel Van de Paar added a comment - - edited Interestingly, with this testcase: SET GLOBAL innodb_checksum_algorithm=1, innodb_compression_algorithm=0; CREATE TABLE t (c INT ) page_compressed=1 page_compression_level=4 ENGINE=InnoDB; FLUSH TABLES; SELECT SLEEP(2); SHOW GLOBAL STATUS LIKE 'Innodb_num_pages_page_compression_error' ; I can repeat the issue in 10.4 dbg/opt ( Innodb_num_pages_page_compression_error console output only, no error log warning) rev cacea31687c098c0348deb1e433f4baddd817419. However, not in any other version (tested 10.5 to 10.7). And in 10.7+ we have the error log warning. It seems there is a difference between versions (10.4, 10.5/6, 10.7+)
          Roel Roel Van de Paar made changes -
          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.
          Roel Roel Van de Paar added a comment -

          Also interesting is that using --log-bin or not may make a difference in the issue reproducing or not.

          Roel Roel Van de Paar added a comment - Also interesting is that using --log-bin or not may make a difference in the issue reproducing or not.
          marko Marko Mäkelä added a comment -

          Thank you. Was this caused by MDEV-12026?

          marko Marko Mäkelä added a comment - Thank you. Was this caused by MDEV-12026 ?
          marko Marko Mäkelä made changes -
          Assignee Marko Mäkelä [ marko ] Daniel Black [ danblack ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          Roel Roel Van de Paar added a comment -

          Possibly. It already existed in an early 10.9 build from 14/2/2022 (verified). Bisecting would be hard given odd timing/sporadic behaviors across earlier versions.

          Roel Roel Van de Paar added a comment - Possibly. It already existed in an early 10.9 build from 14/2/2022 (verified). Bisecting would be hard given odd timing/sporadic behaviors across earlier versions.
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.8 [ 26121 ]
          danblack Daniel Black added a comment -

          updated PR 2538 (finally) with test case fixes.

          danblack Daniel Black added a comment - updated PR 2538 (finally) with test case fixes.
          danblack Daniel Black made changes -
          Assignee Daniel Black [ danblack ] Marko Mäkelä [ marko ]
          Status Stalled [ 10000 ] In Review [ 10002 ]
          marko Marko Mäkelä added a comment -

          OK to push after simplifying the test case.

          marko Marko Mäkelä added a comment - OK to push after simplifying the test case.
          marko Marko Mäkelä made changes -
          Assignee Marko Mäkelä [ marko ] Daniel Black [ danblack ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          danblack Daniel Black made changes -
          issue.field.resolutiondate 2023-10-18 08:19:43.0 2023-10-18 08:19:42.524
          danblack Daniel Black made changes -
          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 JiraAutomate made changes -
          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

            danblack Daniel Black
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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