1843  
查询码:00000028
mysql中报错:[Err] 1146 - Table 'performance_schema.session_status' doesn't exist解决
作者: wyasw 于 2020年03月29日 发布在分类 / Linux / mysql 下,并于 2020年03月29日 编辑
mysql

mysql中报错:[Err] 1146 - Table 'performance_schema.session_status' doesn't exist解决

1.1 场景

数据库由于物理关机,启动不了,试了好多方法,最后选择备份整个目录,重装数据库。重装以后,移动以前的数据库data目录到新安装的数据库下面。启动成功。交给测试后,测试说select报错。

mysql>  select * from qwe.merchant;

[Err] 1146 - Table 'performance_schema.session_status' doesn't exist

1.2 报错解决

[root@d-db classes]# mysql_upgrade -u root -p --force

Enter password:

Checking server version.

Running queries to upgrade MySQL server.

Checking system database.

mysql.columns_priv                                 OK

mysql.db                                           OK

mysql.engine_cost                                  OK

mysql.event                                        OK

mysql.func                                         OK

mysql.general_log                                  OK

mysql.gtid_executed                                OK

mysql.help_category                                OK

mysql.help_keyword                                 OK

mysql.help_relation                                OK

mysql.help_topic                                   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.server_cost                                  OK

mysql.servers                                      OK

mysql.slave_master_info                            OK

mysql.slave_relay_log_info                         OK

mysql.slave_worker_info                            OK

mysql.slow_log                                     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

The sys schema is already up to date (version 1.5.1).

Checking databases.

Error occurred: Error during call to mysql_check.

##注意:Error occurred: Error during call to mysql_check.报错。

之后重启数据库,等待测试测试新问题。



 推荐知识

 历史版本

修改日期 修改人 备注
2020-03-29 21:25:48[当前版本] wyasw 创建版本

  目录
    文艺知识分享平台 -V 4.9.5 -wcp
    京公网安备100012199188号 京ICP备2021030911号