1

More than 5 years have passed since last update.

@munaita_(鈴木省吾)

Table 'performance_schema.session_variables' doesn't exist エラー

Last updated at 2016-09-14Posted at 2016-07-08

エラー

railsでバルクインサートしようとしたらエラー出た

error.log

ActiveRecord::StatementInvalid:
       Mysql2::Error: Table 'performance_schema.session_variables' doesn't exist: SHOW VARIABLES like 'max_allowed_packet';

対応

mysql_updateをかけて再起動

$ mysql_upgrade -u root -p --force
$ mysql.server restart

参考

https://dev.mysql.com/doc/refman/5.6/ja/mysql-upgrade.html
http://stackoverflow.com/questions/31967527/table-performance-schema-session-variables-doesnt-exist
http://sweep3092.hatenablog.com/entry/2015/11/28/180103

1

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

1