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

mysql_upgrade fails with "unknown variable 'process-views=UPGRADE_FROM_MYSQL'"

Details

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Not a Bug
    • 10.0.22-galera
    • N/A
    • Scripts & Clients
    • None
    • Linux Slackware 14.1 x64

    Description

      Fixed: Conflicting mysqlcheck version on the system.

      Was:
      mysqlcheck Ver 2.5.1 Distrib 5.6.27, for Linux (x86_64)

      Correct:
      mysqlcheck Ver 2.7.4-MariaDB Distrib 10.0.22-MariaDB, for Linux (x86_64)


      Ugraded MariaDB 10.0.7 to 10.0.22.

      Server upgrade OK.

      But unable to run mysql_upgrade:

      # mysql_upgrade -p --verbose
      Enter password:
      Looking for 'mysql' as: mysql
      Looking for 'mysqlcheck' as: mysqlcheck
      MySQL upgrade detected
      Phase 1/6: Checking and upgrading mysql database
      Warning: Using a password on the command line interface can be insecure.
      # Connecting to localhost...
      # Disconnecting from localhost...
      mysql.column_stats                                 OK
      mysql.columns_priv                                 OK
      mysql.db                                           OK
      mysql.event                                        OK
      mysql.func                                         OK
      mysql.general_log                                  OK
      mysql.gtid_slave_pos                               OK
      mysql.help_category                                OK
      mysql.help_keyword                                 OK
      mysql.help_relation                                OK
      mysql.help_topic                                   OK
      mysql.host                                         OK
      mysql.index_stats                                  OK
      mysql.innodb_index_stats                           OK
      mysql.innodb_table_stats                           OK
      mysql.ndb_binlog_index                             OK
      mysql.plugin                                       OK
      mysql.proc                                         OK
      mysql.procs_priv                                   OK
      mysql.proxies_priv                                 OK
      mysql.roles_mapping                                OK
      mysql.servers                                      OK
      mysql.slow_log                                     OK
      mysql.table_stats                                  OK
      mysql.tables_priv                                  OK
      mysql.time_zone                                    OK
      mysql.time_zone_leap_second                        OK
      mysql.time_zone_name                               OK
      mysql.time_zone_transition                         OK
      mysql.time_zone_transition_type                    OK
      mysql.user                                         OK
      Phase 2/6: Fixing views from mysql
      Warning: Using a password on the command line interface can be insecure.
      mysqlcheck: unknown variable 'process-views=UPGRADE_FROM_MYSQL'
      FATAL ERROR: Upgrade failed

      Software info:

      # mysql_upgrade  --version
      mysql_upgrade  Ver 1.4 Distrib 10.0.22-MariaDB, for Linux (x86_64)

      #mysqlcheck  --version
      mysqlcheck  Ver 2.5.1 Distrib 5.6.27, for Linux (x86_64)

      Attachments

        Activity

          KRDS KRDS added a comment - - edited

          Fixed

          Conflicting mysqlcheck version on the sytem.

          KRDS KRDS added a comment - - edited Fixed Conflicting mysqlcheck version on the sytem.
          elenst Elena Stepanova added a comment - - edited

          As you can see, your mysqlcheck is of MySQL 5.6 (not MariaDB). You need to upgrade/crossgrade it to MariaDB 10.0 as well. Possibly there are some other elements, better to check them all.

          UPD: okay, I see you've already figured it out.

          elenst Elena Stepanova added a comment - - edited As you can see, your mysqlcheck is of MySQL 5.6 ( not MariaDB). You need to upgrade/crossgrade it to MariaDB 10.0 as well. Possibly there are some other elements, better to check them all. UPD: okay, I see you've already figured it out.

          People

            Unassigned Unassigned
            KRDS KRDS
            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.