Attachment 12986 Details for Bug 29649 – Running mysql_upgrade from command line without zmsetup script

Running mysql_upgrade from command line without zmsetup script

file_29649.txt (text/plain), 4.30 KB, created by Barry Jackson on 2021-11-12 16:03:02 CET

(hide)

Description:

Filename:

MIME Type:

Creator: Barry Jackson

Created: 2021-11-12 16:03:02 CET

Size: 4.30 KB

patch

obsolete

>[root@localhost bin]# mysql_upgrade -u root -pXXXXXX -vvvv 
>Looking for 'mysql' as: mysql
>'mysql' --no-defaults --help 2>&1 > /dev/null 
>Looking for 'mysqlcheck' as: mysqlcheck
>'mysqlcheck' --no-defaults --help 2>&1 > /dev/null 
>'mysql' --defaults-file=/tmp/mysql_upgrade-hNUHiV --database=mysql --batch --skip-force --silent < /tmp/sql2llOiZ 2>&1 
>'mysql' --defaults-file=/tmp/mysql_upgrade-hNUHiV --database=mysql --batch --skip-force --silent < /tmp/sql16hylh 2>&1 
>'mysql' --defaults-file=/tmp/mysql_upgrade-hNUHiV --database=mysql --batch --skip-force --silent < /tmp/sql8L3aY9 2>&1 
>Phase 1/7: Checking and upgrading mysql database
>Running 'mysqlcheck' with connection arguments: --port='3306' --socket='/var/lib/mysql/mysql.sock' 
>'mysqlcheck' --defaults-file=/tmp/mysql_upgrade-hNUHiV --check-upgrade --auto-repair --verbose --verbose --verbose  --skip-write-binlog --databases mysql 2>&1 
># Connecting to localhost...
># Disconnecting from localhost...
>Processing databases
>mysql
>CHECK TABLE `column_stats`  FOR UPGRADE
>mysql.column_stats                                 OK
>CHECK TABLE `columns_priv`  FOR UPGRADE
>mysql.columns_priv                                 OK
>CHECK TABLE `db`  FOR UPGRADE
>mysql.db                                           OK
>CHECK TABLE `event`  FOR UPGRADE
>mysql.event                                        OK
>CHECK TABLE `func`  FOR UPGRADE
>mysql.func                                         OK
>CHECK TABLE `global_priv`  FOR UPGRADE
>mysql.global_priv                                  OK
>CHECK TABLE `gtid_slave_pos`  FOR UPGRADE
>mysql.gtid_slave_pos                               OK
>CHECK TABLE `help_category`  FOR UPGRADE
>mysql.help_category                                OK
>CHECK TABLE `help_keyword`  FOR UPGRADE
>mysql.help_keyword                                 OK
>CHECK TABLE `help_relation`  FOR UPGRADE
>mysql.help_relation                                OK
>CHECK TABLE `help_topic`  FOR UPGRADE
>mysql.help_topic                                   OK
>CHECK TABLE `index_stats`  FOR UPGRADE
>mysql.index_stats                                  OK
>CHECK TABLE `innodb_index_stats`  FOR UPGRADE
>mysql.innodb_index_stats                           OK
>CHECK TABLE `innodb_table_stats`  FOR UPGRADE
>mysql.innodb_table_stats                           OK
>CHECK TABLE `plugin`  FOR UPGRADE
>mysql.plugin                                       OK
>CHECK TABLE `proc`  FOR UPGRADE
>mysql.proc                                         OK
>CHECK TABLE `procs_priv`  FOR UPGRADE
>mysql.procs_priv                                   OK
>CHECK TABLE `proxies_priv`  FOR UPGRADE
>mysql.proxies_priv                                 OK
>CHECK TABLE `roles_mapping`  FOR UPGRADE
>mysql.roles_mapping                                OK
>CHECK TABLE `servers`  FOR UPGRADE
>mysql.servers                                      OK
>CHECK TABLE `table_stats`  FOR UPGRADE
>mysql.table_stats                                  OK
>CHECK TABLE `tables_priv`  FOR UPGRADE
>mysql.tables_priv                                  OK
>CHECK TABLE `time_zone`  FOR UPGRADE
>mysql.time_zone                                    OK
>CHECK TABLE `time_zone_leap_second`  FOR UPGRADE
>mysql.time_zone_leap_second                        OK
>CHECK TABLE `time_zone_name`  FOR UPGRADE
>mysql.time_zone_name                               OK
>CHECK TABLE `time_zone_transition`  FOR UPGRADE
>mysql.time_zone_transition                         OK
>CHECK TABLE `time_zone_transition_type`  FOR UPGRADE
>mysql.time_zone_transition_type                    OK
>CHECK TABLE `transaction_registry`  FOR UPGRADE
>mysql.transaction_registry                         OK
>Phase 2/7: Installing used storage engines... Skipped
>'mysql' --defaults-file=/tmp/mysql_upgrade-hNUHiV --database=mysql --batch --force --silent < /tmp/sql9tP8sQ 2>&1 
>Phase 3/7: Fixing views
>Running 'mysqlcheck' with connection arguments: --port='3306' --socket='/var/lib/mysql/mysql.sock' 
>'mysqlcheck' --defaults-file=/tmp/mysql_upgrade-hNUHiV --all-databases --repair --process-views=YES --skip-process-tables --verbose  --skip-write-binlog 2>&1 
>Processing databases
>information_schema
>mysql
>mysqlcheck: Got error: 2013: Lost connection to server during query when executing 'REPAIR NO_WRITE_TO_BINLOG VIEW ... '
>FATAL ERROR: Upgrade failed
>[root@localhost bin]# echo $?
>1
>[root@localhost bin]#

[root@localhost bin]# mysql_upgrade -u root -pXXXXXX -vvvv 
Looking for 'mysql' as: mysql
'mysql' --no-defaults --help 2>&1 > /dev/null 
Looking for 'mysqlcheck' as: mysqlcheck
'mysqlcheck' --no-defaults --help 2>&1 > /dev/null 
'mysql' --defaults-file=/tmp/mysql_upgrade-hNUHiV --database=mysql --batch --skip-force --silent < /tmp/sql2llOiZ 2>&1 
'mysql' --defaults-file=/tmp/mysql_upgrade-hNUHiV --database=mysql --batch --skip-force --silent < /tmp/sql16hylh 2>&1 
'mysql' --defaults-file=/tmp/mysql_upgrade-hNUHiV --database=mysql --batch --skip-force --silent < /tmp/sql8L3aY9 2>&1 
Phase 1/7: Checking and upgrading mysql database
Running 'mysqlcheck' with connection arguments: --port='3306' --socket='/var/lib/mysql/mysql.sock' 
'mysqlcheck' --defaults-file=/tmp/mysql_upgrade-hNUHiV --check-upgrade --auto-repair --verbose --verbose --verbose  --skip-write-binlog --databases mysql 2>&1 
# Connecting to localhost...
# Disconnecting from localhost...
Processing databases
mysql
CHECK TABLE `column_stats`  FOR UPGRADE
mysql.column_stats                                 OK
CHECK TABLE `columns_priv`  FOR UPGRADE
mysql.columns_priv                                 OK
CHECK TABLE `db`  FOR UPGRADE
mysql.db                                           OK
CHECK TABLE `event`  FOR UPGRADE
mysql.event                                        OK
CHECK TABLE `func`  FOR UPGRADE
mysql.func                                         OK
CHECK TABLE `global_priv`  FOR UPGRADE
mysql.global_priv                                  OK
CHECK TABLE `gtid_slave_pos`  FOR UPGRADE
mysql.gtid_slave_pos                               OK
CHECK TABLE `help_category`  FOR UPGRADE
mysql.help_category                                OK
CHECK TABLE `help_keyword`  FOR UPGRADE
mysql.help_keyword                                 OK
CHECK TABLE `help_relation`  FOR UPGRADE
mysql.help_relation                                OK
CHECK TABLE `help_topic`  FOR UPGRADE
mysql.help_topic                                   OK
CHECK TABLE `index_stats`  FOR UPGRADE
mysql.index_stats                                  OK
CHECK TABLE `innodb_index_stats`  FOR UPGRADE
mysql.innodb_index_stats                           OK
CHECK TABLE `innodb_table_stats`  FOR UPGRADE
mysql.innodb_table_stats                           OK
CHECK TABLE `plugin`  FOR UPGRADE
mysql.plugin                                       OK
CHECK TABLE `proc`  FOR UPGRADE
mysql.proc                                         OK
CHECK TABLE `procs_priv`  FOR UPGRADE
mysql.procs_priv                                   OK
CHECK TABLE `proxies_priv`  FOR UPGRADE
mysql.proxies_priv                                 OK
CHECK TABLE `roles_mapping`  FOR UPGRADE
mysql.roles_mapping                                OK
CHECK TABLE `servers`  FOR UPGRADE
mysql.servers                                      OK
CHECK TABLE `table_stats`  FOR UPGRADE
mysql.table_stats                                  OK
CHECK TABLE `tables_priv`  FOR UPGRADE
mysql.tables_priv                                  OK
CHECK TABLE `time_zone`  FOR UPGRADE
mysql.time_zone                                    OK
CHECK TABLE `time_zone_leap_second`  FOR UPGRADE
mysql.time_zone_leap_second                        OK
CHECK TABLE `time_zone_name`  FOR UPGRADE
mysql.time_zone_name                               OK
CHECK TABLE `time_zone_transition`  FOR UPGRADE
mysql.time_zone_transition                         OK
CHECK TABLE `time_zone_transition_type`  FOR UPGRADE
mysql.time_zone_transition_type                    OK
CHECK TABLE `transaction_registry`  FOR UPGRADE
mysql.transaction_registry                         OK
Phase 2/7: Installing used storage engines... Skipped
'mysql' --defaults-file=/tmp/mysql_upgrade-hNUHiV --database=mysql --batch --force --silent < /tmp/sql9tP8sQ 2>&1 
Phase 3/7: Fixing views
Running 'mysqlcheck' with connection arguments: --port='3306' --socket='/var/lib/mysql/mysql.sock' 
'mysqlcheck' --defaults-file=/tmp/mysql_upgrade-hNUHiV --all-databases --repair --process-views=YES --skip-process-tables --verbose  --skip-write-binlog 2>&1 
Processing databases
information_schema
mysql
mysqlcheck: Got error: 2013: Lost connection to server during query when executing 'REPAIR NO_WRITE_TO_BINLOG VIEW ... '
FATAL ERROR: Upgrade failed
[root@localhost bin]# echo $?
1
[root@localhost bin]#

Actions: View

Attachments on bug 29649: 12983 | 12984 | 12986