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

LP:944422 - mysql_upgrade destroys Maria tables?

    XMLWordPrintable

Details

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

    Description

      Upgrading tables from 5.2 to 5.3.5 with mysql_upgrade seems to cause MySQL to zerofill tables...

      [Note] Zerofilling moved table: '.\database\technikervermerke'

      which then seems to destroy some tables. At least when you run a check, it states:

      Found row with transaction id 808 when max transaction id according to maria_control_file is 84

      —

      This issue might be linked to:
      http://askmonty.org/worklog/Maria-BackLog/?tid=126
      http://bugs.mysql.com/bug.php?id=42379 (status: "not supported")

      Attached is an archive with the 5.2-state as well as 5.3-state table `technikervermerke`.

      If the upgrade causes corrupt tables, this bug should be fixed. If it is an erroneus message, it should be disabled.

      Attachments

        Activity

          People

            monty Michael Widenius
            nbrnhardt nbrnhardt (Inactive)
            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.