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

innodb_init() returned 11 (Generic error) upon incremental backup

    XMLWordPrintable

Details

    Description

      Note: This report is about non-debug 10.4 build. 10.4 debug fails with MDEV-18589 instead, and 10.5 non-debug fails with MDEV-22913.

      10.4 non-debug 49ac606a

      2020-06-17  1:55:47 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2020-06-17  1:55:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=516541629
       
      <cut: 11685 lines Ignoring data file '...' with space ID 140296, since the redo log references test/t1.ibd with space ID ...>
       
      2020-06-17  1:55:48 0 [Note] InnoDB: Starting a batch to recover 3973 pages from redo log.
      2020-06-17  1:55:49 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
      [00] FATAL ERROR: 2020-06-17 01:55:49 mariabackup: innodb_init() returned 11 (Generic error).
      

      To reproduce (same test as in MDEV-22913):
      To reproduce:

      git clone https://github.com/MariaDB/randgen --branch mdev22913 rqg-mdev22913
      rqg-mdev22913
      perl ./runall-trials.pl --basedir=<basedir> --trials=10 --skip-gendata --duration=150 --threads=4 --scenario=MariaBackupIncremental --grammar=mdev22913.yy --vardir=/dev/shm/var_mdev22918 --output="returned 11"
      

      Remember to set the basedir on the command line.
      For reproducing, use a 10.4 non-debug build.

      The grammar in the test above only contains single query:

      query:
        CREATE OR REPLACE TABLE { 't'.$prng->int(1,9) } (b BIT) ENGINE=InnoDB ROW_FORMAT COMPRESSED;
      

      The command line above runs the test 10 times, until it fails with "returned 11" output. It may take a while, because it can fail with different problems, particularly MDEV-18589 (the non-debug variation "innodb_init() returned 39 (Data structure corruption)").

      Other versions/builds fail with different problems, see MDEV-22913 for more details.

      Attachments

        1. mbackup_backup_0.log
          3.23 MB
          Elena Stepanova
        2. mbackup_backup_1.log
          2.56 MB
          Elena Stepanova
        3. mbackup_backup_2.log
          1.93 MB
          Elena Stepanova
        4. mbackup_backup_3.log
          5.19 MB
          Elena Stepanova
        5. mbackup_prepare_0.log
          2.20 MB
          Elena Stepanova
        6. mbackup_prepare_1.log
          1.75 MB
          Elena Stepanova

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              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.