Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
10.4.10
-
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
- duplicates
-
MDEV-16735 mysql_upgrade failed
- Closed
- relates to
-
MDEV-21855 Document difference between DEFAULT and 'DEFAULT' when setting alter_algorithm or system_versioning_asof
- Closed