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@rlxv648 ~]$ mariadbupgrade

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

MDEV16735 mysql_upgrade failed
 Closed
 relates to

MDEV21855 Document difference between DEFAULT and 'DEFAULT' when setting alter_algorithm or system_versioning_asof
 Closed