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

GTID looses all binlog state after crash if InnoDB is disabled

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 10.0.7
    • None

    Description

      If InnoDB is disabled (and no other XA-capable engine is enabled), then the
      server does not do any binlog crash recovery during restart after a crash.

      This is not sufficient for GTID, as we need to recover the last GTID logged
      into the binlog (so that we can know the next seq_no to assign to new GTIDs
      and how to reply to connecting slaves etc.).

      Thus, even in non-XA case we still need to scan the binlog and do crash
      recovery, though the XA part of it can be ignored.

      Same when using using_heuristic_recover().

      (MyISAM of course is not crash safe, but it is still better to loose a few
      seconds of state or whatever compared to all state since prior server start).

      Attachments

        Activity

          People

            knielsen Kristian Nielsen
            knielsen Kristian Nielsen
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.