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

MariaDB 10.2 cannot start on MySQL 5.7 datadir: Fatal error: mysql.user table is damaged or in unsupported 3.20 format

Details

    • 10.2.4-1, 10.2.4-1, 10.2.4-2

    Description

      An attempt to start MariaDB 10.2 (as of 39d2c7b18d, Oct 27) on a simple MySQL 5.7 datadir ends with the error:

      2016-10-29 12:45:31 140477392623488 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
      

      I tried to start the server with --skip-grant-tables and run mysql_upgrade to see if we can work around the problem this way if it comes to it; the server starts, but mysql_upgrade throws all kinds of errors. At this point I'm not sure whether it's because of skip-grant-tables (I doubt that), or it will be the next problem on the way of fixing MySQL 5.7 => MariaDB 10.2 upgrade.

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            elenst Elena Stepanova made changes -
            Description An attempt to start MariaDB 10.2 (as of 39d2c7b18d, Oct 27) on a simple MySQL 5.7 datadir ends with the error:
            {noformat}
            2016-10-29 12:45:31 140477392623488 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
            {noformat}
            An attempt to start MariaDB 10.2 (as of 39d2c7b18d, Oct 27) on a simple MySQL 5.7 datadir ends with the error:
            {noformat}
            2016-10-29 12:45:31 140477392623488 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
            {noformat}

            I tried to start the server with {{--skip-grant-tables}} and run {{mysql_upgrade}} to see if we can work around the problem this way if it comes to it; the server starts, but {{mysql_upgrade}} throws all kinds of errors. At this point I'm not sure whether it's because of {{skip-grant-tables}} (I doubt that), or it will be the next problem on the way of fixing MySQL 5.7 => MariaDB 10.2 upgrade.
            elenst Elena Stepanova made changes -
            Assignee Sergei Golubchik [ serg ] Sergey Vojtovich [ svoj ]
            elenst Elena Stepanova made changes -
            Assignee Sergey Vojtovich [ svoj ] Vicentiu Ciorbaru [ cvicentiu ]
            serg Sergei Golubchik made changes -
            Component/s Authentication and Privilege System [ 13101 ]
            Component/s OTHER [ 10125 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.4-1 [ 121 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            cvicentiu Vicențiu Ciorbaru made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Assignee Vicentiu Ciorbaru [ cvicentiu ] Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Vicentiu Ciorbaru [ cvicentiu ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.4-1 [ 121 ] 10.2.4-1, 10.2.4-1 [ 121, 132 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            elenst Elena Stepanova made changes -
            Labels 10.2-rc
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.4-1, 10.2.4-1 [ 121, 132 ] 10.2.4-1, 10.2.4-1, 10.2.4-2 [ 121, 132, 134 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Assignee Vicentiu Ciorbaru [ cvicentiu ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Vicentiu Ciorbaru [ cvicentiu ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Assignee Vicentiu Ciorbaru [ cvicentiu ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Vicentiu Ciorbaru [ cvicentiu ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            issue.field.resolutiondate 2017-02-14 05:49:34.0 2017-02-14 05:49:34.02
            cvicentiu Vicențiu Ciorbaru made changes -
            Fix Version/s 10.2.4 [ 22116 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            faust Faustin Lammler made changes -
            Attachment rollback_mysql5.7.sh [ 45132 ]
            otto Otto Kekäläinen made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 78130 ] MariaDB v4 [ 151143 ]

            People

              cvicentiu Vicențiu Ciorbaru
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              7 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.