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

mysql_upgrade failed

    XMLWordPrintable

    Details

      Description

      Fedora 27, upgrade from 10.3.7 to 10.3.8 using rpm packages failed if alter_algorithm = INSTANT.

      # mysql_upgrade -h 127.0.0.1 -p
      Enter password: 
      Phase 1/7: Checking and upgrading mysql database
      Processing databases
      mysql
      mysql.column_stats                                 OK
      mysql.columns_priv                                 OK
      mysql.db                                           OK
      mysql.event                                        OK
      mysql.func                                         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.plugin                                       OK
      mysql.proc                                         OK
      mysql.procs_priv                                   OK
      mysql.proxies_priv                                 OK
      mysql.roles_mapping                                OK
      mysql.servers                                      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.transaction_registry                         OK
      mysql.user                                         OK
      Phase 2/7: Installing used storage engines... Skipped
      Phase 3/7: Fixing views
      Phase 4/7: Running 'mysql_fix_privilege_tables'
      ERROR 1845 (0A000) at line 174: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 177: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 196: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 235: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 265: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 283: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 300: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 335: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 384: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 398: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 445: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 446: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 513: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1068 (42000) at line 514: Multiple primary key defined
      FATAL ERROR: Upgrade failed
      

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            mxu Michael Xu
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration