[MDEV-10348] mysql_upgrade mixing up table list Created: 2016-07-08  Updated: 2016-07-08  Resolved: 2016-07-08

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Update
Affects Version/s: 5.5.47
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Jakub Dorňák Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-9440 mysqlcheck -A --auto-repair selects w... Closed

 Description   

When ran over a mariadb server running from files copied from a previous versino of MySQL, mariadb first list the tables to repair, that works.
Then it tries to repair them, but looks for all tables in the last database it saw.

[root@hp-dl80gen9-01 ~]# mysql_upgrade
This installation of MySQL is already upgraded to 5.5.47-MariaDB, use --force if you still need to run mysql_upgrade
[root@hp-dl80gen9-01 ~]# mysql_upgrade --force
Phase 1/4: Fixing views
Phase 2/4: Fixing table and database names
Phase 3/4: Checking and upgrading tables
Processing databases
information_schema
a
a.x Needs upgrade
a.y Needs upgrade
b
b.z Needs upgrade
mysql
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers 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
performance_schema
test

Repairing tables
test.x
Error : Table 'test.x' doesn't exist
status : Operation failed
test.y
Error : Table 'test.y' doesn't exist
status : Operation failed
test.z
Error : Table 'test.z' doesn't exist
status : Operation failed
Phase 4/4: Running 'mysql_fix_privilege_tables'
OK



 Comments   
Comment by Elena Stepanova [ 2016-07-08 ]

Thanks for the report. We already have this problem filed as MDEV-9440 (and MDEV-10005). I'll raise the priority of MDEV-9440 since more users appear to be affected.

Comment by Elena Stepanova [ 2016-07-08 ]

Duplicate of MDEV-9440.

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