[MDEV-9223] mysql_upgrade fails with "unknown variable 'process-views=UPGRADE_FROM_MYSQL'" Created: 2015-12-01  Updated: 2015-12-01  Resolved: 2015-12-01

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.0.22-galera
Fix Version/s: N/A

Type: Bug Priority: Trivial
Reporter: KRDS Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

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)



 Comments   
Comment by KRDS [ 2015-12-01 ]

Fixed

Conflicting mysqlcheck version on the sytem.

Comment by Elena Stepanova [ 2015-12-01 ]

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.

Generated at Thu Feb 08 07:33:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.