前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >general_log 问题处理2

general_log 问题处理2

作者头像
franket
发布2022-03-21 18:21:47
3560
发布2022-03-21 18:21:47
举报
文章被收录于专栏:技术杂记技术杂记

报错

在5.1->5.6升级过程中,执行upgrade之后产生如下报错

代码语言:javascript
复制
[root@upgrade-slave ~]# time mysql_upgrade -u root -p 
Enter password: 
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' 
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' 
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : Can't get stat of './mysql/general_log.CSV' (Errcode: 2 - No such file or directory)
Error    : Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
error    : Corrupt
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         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.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

Repairing tables
mysql.general_log
Error    : Can't get stat of './mysql/general_log.CSV' (Errcode: 2 - No such file or directory)
Error    : Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
error    : Corrupt
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
ERROR 13 (HY000) at line 25: Can't get stat of './mysql/general_log.CSV' (Errcode: 2 - No such file or directory)
ERROR 1243 (HY000) at line 26: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 27: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 13 (HY000) at line 1591: Can't get stat of './mysql/general_log.CSV' (Errcode: 2 - No such file or directory)
ERROR 13 (HY000) at line 1598: Can't get stat of './mysql/general_log.CSV' (Errcode: 2 - No such file or directory)
FATAL ERROR: Upgrade failed

real	0m5.161s
user	0m0.051s
sys	0m0.049s
[root@upgrade-slave ~]# 

本文系转载,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文系转载前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 报错
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档