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

mysql_upgrade / mariadb-upgrade error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 10.4.10
    • N/A
    • Scripts & Clients
    • None

    Description

      to protect our galera cluster (some developers are trying to do nasty things), we set the parameter alter_algorithm=INPLACE
      but now when executing the upgrade script we are getting some errors - obviously the tool is trying to modify some system tables in a way that is not compatible with our "alter_algorithm" parameter.
      is it possible to make the tool adjust the session before modifying the tables?

      set session alter_algorithm=copy;
      

      error codes:

      [mysql@rlx-v648 ~]$ mariadb-upgrade 
      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.global_priv                                  OK
      mysql.gtid_slave_pos                               OK
      mysql.help_category                                OK
      mysql.help_keyword                                 OK
      mysql.help_relation                                OK
      mysql.help_topic                                   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.server_audit_filters                         OK
      mysql.server_audit_users                           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.wsrep_cluster                                OK
      mysql.wsrep_cluster_members                        OK
      mysql.wsrep_streaming_log                          OK
      Phase 2/7: Installing used storage engines... Skipped
      Phase 3/7: Fixing views
      mysql.user                                         OK
      Phase 4/7: Running 'mysql_fix_privilege_tables'
      ERROR 1845 (0A000) at line 26: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 45: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 110: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 128: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 163: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 201: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 215: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 263: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 328: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 464: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 465: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 466: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 467: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 468: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 469: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 470: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 471: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 472: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 473: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 474: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 475: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 476: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 477: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 478: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 479: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 480: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 481: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 482: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 483: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 484: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 485: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      ERROR 1845 (0A000) at line 486: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              kurschies Benjamin Kurschies
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.