Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19813 Aria crash recovery failures
  3. MDEV-18203

Aria engine: Undo phase failed with "Got error 126 when executing undo undo_key_insert" upon startup on datadir restored from incremental backup

    XMLWordPrintable

    Details

      Description

      10.4 30da40bb8c

      2019-01-10 18:02:57 0 [Note] mysqld: Aria engine: starting recovery
      recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (13.3 seconds); transactions to roll back: 1
      Got error 126 when executing undo undo_key_insert
      2019-01-10 18:03:11 0 [ERROR] mysqld: Aria engine: Undo phase failed
      tables to flush: 9 8 7 6 5 4 3 2 1 0
      2019-01-10 18:03:11 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
      2019-01-10 18:03:11 0 [ERROR] Plugin 'Aria' init function returned error.
      2019-01-10 18:03:11 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
      

      The backup dirs are here:
      ftp://ftp.askmonty.org/public/mdev18203/

      backup_before_prepare_0 is the initial full backup
      backup_before_prepare_1 is the 1st incremental backup
      backup_before_prepare_2 is the 1st incremental backup
      backup_0 is the prepared backup after all prepare were executed on it.

      To reproduce the failure, restore backup_0 to the datadir and run the server on it. All server default options are sufficient.

      If you have doubts about the correctness of prepare, you can run it on non-prepared backups.

      mariabackup logs from all stages are attached with hopefully self-explanatory names (mbackup*.log).

      I have no information yet whether it affects previous versions.

        Attachments

        1. aria_recovery.trace
          276 kB
        2. mbackup_backup_0.log
          20 kB
        3. mbackup_backup_1.log
          21 kB
        4. mbackup_backup_2.log
          21 kB
        5. mbackup_prepare_0.log
          2 kB
        6. mbackup_prepare_1.log
          20 kB
        7. mbackup_prepare_2.log
          20 kB
        8. mbackup_restore.log
          18 kB
        9. mysql.err
          16 kB
        10. trial.log
          43 kB

          Issue Links

            Activity

              People

              Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: