# Problems after direct upgrade 5.5. to 5.7

**URL:** <https://forums.percona.com/t/problems-after-direct-upgrade-5-5-to-5-7/5374>\
**Category:** Other MySQL® Questions\
**Created:** [January 26, 2017, 7:17am UTC](https://forums.percona.com/t/problems-after-direct-upgrade-5-5-to-5-7/5374 "2017-01-26T07:17:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\
**Post date:** [January 26, 2017, 7:17am UTC](https://forums.percona.com/t/problems-after-direct-upgrade-5-5-to-5-7/5374/1 "2017-01-26T07:17:21Z")

</div>

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)?