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

innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error

    XMLWordPrintable

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

          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.