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

Corrupted page breaks recovery in innodb_gis.types

    XMLWordPrintable

Details

    Description

      The following failure of the test innodb_gis.types occurred on kvm-deb-sid-x86:

      10.5 ee61c8c0b762840ab5badaa9d6b3a24b1c2ee8c7

      2020-08-21 18:06:15 0 [Note] InnoDB: VALID: space:5163 page_no:1 page_size:16384
      2020-08-21 18:06:15 0 [Note] InnoDB: Page size: 16384. Possible space_id count:1
      2020-08-21 18:06:15 0 [Note] InnoDB: space_id:5163, Number of pages matched: 1/1 (16384)
      2020-08-21 18:06:15 0 [Note] InnoDB: Chosen space:5163
      2020-08-21 18:06:15 0 [ERROR] InnoDB: Corrupted page [page id: space=5163, page number=0] of datafile './test/t_wl6455.ibd' could not be found in the doublewrite buffer.
      2020-08-21 18:06:15 0 [ERROR] InnoDB: Tablespace 5163 was not found at ./test/t_wl6455.ibd.
      2020-08-21 18:06:15 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
      2020-08-21 18:06:15 0 [ERROR] InnoDB: Plugin initialization aborted with error Tablespace not found
      

      This caused the test failure as follows:

      10.5 ee61c8c0b762840ab5badaa9d6b3a24b1c2ee8c7

      innodb_gis.types 'innodb'                w4 [ fail ]
              Test ended at 2020-08-21 18:06:16
       
      CURRENT_TEST: innodb_gis.types
      mysqltest: At line 76: query 'SELECT ST_AsText(g) FROM t_wl6455' failed: 1286: Unknown storage engine 'InnoDB'
      

      Note: This differs from MDEV-22512 in that we no longer run out of the buffer pool during recovery, probably thanks to MDEV-21351. Before 10.5, we would be much more likely to hit MDEV-22512. So, this bug may in fact affect earlier versions than 10.5.

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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