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

Unable to migrate from MySQL due to incorrect definition of table mysql.proc and mysql.event

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 5.5.29, 5.5.28a-galera
    • None
    • None
    • Arch Linux i686/x86_64

    Description

      After installation MySQL and initialization its data directory using mysql_install_db, I removed MySQL packages and installed MariaDB counterparts. Then I ran MariaDB's mysql_install_db again, but scripts threw out that mysql.proc and mysql.event have incorrect definitions (full log in attachment).

      I'm aware that I should run mysql_upgrade first and do not run mysql_install_db second time, but I want to make migration straighforward for Arch users. As far as I know there is no safe and sure way to check if calling the script is required. MariaDB's mysql_install_db worked fine until 5.5.28 release, and now user have to intervene manually. (However clean MariaDB installs are working fine.)

      I wouldn't even report that, but you "advertise" that as long as MySQL and Maria have same base version, the migration should be flawless. If you won't fix this obvious regression, it will make Arch migration to MariaDB much slower.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            barthalion Bartłomiej Piotrowski (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.