Not the answer you need?
Register and ask your own question!

Problems after direct upgrade 5.5. to 5.7

aleksey.filippovaleksey.filippov ContributorCurrent User Role Beginner
Hi again. My second post for today, and again with problem :)
My coworkers made upgrade percona mysql server directly from 5.5 to 5.7. Server works, but we have to add some plugins.
And when we try to "install plugin query_response_time soname 'query_response_time.so';", we receive error:

ERROR 1146 (42S02): Table 'mysql.plugin' doesn't exist

So, now it start to be my problem. First of all, i understand, that direct upgrade 5.5. to 5.7 was unacceptable. But we have what we have.
I find out, that it is not only one unaccessible mysql db table:

mysql> use mysql
mysql> select count(*) from engine_cost ;
ERROR 1146 (42S02): Table 'mysql.engine_cost' doesn't exist
mysql> select count(*) from gtid_executed ;
ERROR 1146 (42S02): Table 'mysql.gtid_executed' doesn't exist
mysql> select count(*) from help_category ;
ERROR 1146 (42S02): Table 'mysql.help_category' doesn't exist
mysql> select count(*) from help_keyword ;
ERROR 1146 (42S02): Table 'mysql.help_keyword' doesn't exist
mysql> select count(*) from help_relation ;
ERROR 1146 (42S02): Table 'mysql.help_relation' doesn't exist
mysql> select count(*) from help_topic ;
ERROR 1146 (42S02): Table 'mysql.help_topic' doesn't exist
mysql> select count(*) from innodb_index_stats ;
ERROR 1146 (42S02): Table 'mysql.innodb_index_stats' doesn't exist
mysql> select count(*) from innodb_table_stats ;
ERROR 1146 (42S02): Table 'mysql.innodb_table_stats' doesn't exist
mysql> select count(*) from plugin ;
ERROR 1146 (42S02): Table 'mysql.plugin' doesn't exist
mysql> select count(*) from server_cost ;
ERROR 1146 (42S02): Table 'mysql.server_cost' doesn't exist
mysql> select count(*) from servers ;
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
mysql> select count(*) from slave_master_info ;
ERROR 1146 (42S02): Table 'mysql.slave_master_info' doesn't exist
mysql> select count(*) from slave_relay_log_info ;
ERROR 1146 (42S02): Table 'mysql.slave_relay_log_info' doesn't exist
mysql> select count(*) from slave_worker_info ;
ERROR 1146 (42S02): Table 'mysql.slave_worker_info' doesn't exist
mysql> select count(*) from time_zone ;
ERROR 1146 (42S02): Table 'mysql.time_zone' doesn't exist
mysql> select count(*) from time_zone_leap_second ;
ERROR 1146 (42S02): Table 'mysql.time_zone_leap_second' doesn't exist
mysql> select count(*) from time_zone_name ;
ERROR 1146 (42S02): Table 'mysql.time_zone_name' doesn't exist
mysql> select count(*) from time_zone_transition ;
ERROR 1146 (42S02): Table 'mysql.time_zone_transition' doesn't exist
mysql> select count(*) from time_zone_transition_type;
ERROR 1146 (42S02): Table 'mysql.time_zone_transition_type' doesn't exist

Others work fine.
Is there some ability to fix problem without revolutionary method(reinstalling and restoring from backup)?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.