VPS侦探论坛

 找回密码
 注册
查看: 3093|回复: 1

升级了mysql 5.618 出现这个错误怎么办?

[复制链接]
发表于 2015-12-11 11:17:41 | 显示全部楼层 |阅读模式

lnmp1.2

151211 11:16:02 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
2015-12-11 11:16:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-11 11:16:02 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.28-log) starting as process 4584 ...
2015-12-11 11:16:02 4584 [Warning] ignore-builtin-innodb is ignored and will be removed in future releases.
2015-12-11 11:16:02 4584 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2015-12-11 11:16:02 4584 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2015-12-11 11:16:02 4584 [Warning] Using unique option prefix innodb-locks instead of innodb-locks-unsafe-for-binlog is deprecated and will be removed in a future release. Please use the full name instead.
2015-12-11 11:16:02 4584 [Warning] Using unique option prefix innodb-cmp instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2015-12-11 11:16:02 4584 [Warning] Using unique option prefix innodb-cmp-per-index instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2015-12-11 11:16:02 4584 [Note] Plugin 'InnoDB' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_TRX' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_CMPMEM' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_METRICS' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
2015-12-11 11:16:02 4584 [Note] Plugin 'FEDERATED' is disabled.
2015-12-11 11:16:02 4584 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose-innodb-ft-inserted=0'
/usr/local/mysql/bin/mysqld: File './mysql-bin.000006' not found (Errcode: 2 - No such file or directory)
2015-12-11 11:16:02 4584 [ERROR] Failed to open log (file './mysql-bin.000006', errno 2)
2015-12-11 11:16:02 4584 [ERROR] Could not open log file
2015-12-11 11:16:02 4584 [ERROR] Can't init tc log
2015-12-11 11:16:02 4584 [ERROR] Aborting

2015-12-11 11:16:02 4584 [Note] Binlog end
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'partition'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'BLACKHOLE'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'ARCHIVE'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'INNODB_CMP'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'MRG_MYISAM'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'CSV'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'MyISAM'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'MEMORY'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'sha256_password'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'mysql_old_password'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'mysql_native_password'
2015-12-11 11:16:02 4584 [Note] Shutting down plugin 'binlog'
2015-12-11 11:16:02 4584 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

151211 11:16:02 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY131013141355585524Z.pid ended
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2015-12-11 13:02:37 | 显示全部楼层


2015-12-11 11:16:02 4584 [ERROR] Failed to open log (file './mysql-bin.000006', errno 2)
2015-12-11 11:16:02 4584 [ERROR] Could not open log file
2015-12-11 11:16:02 4584 [ERROR] Can't init tc log
2015-12-11 11:16:02 4584 [ERROR] Aborting

ls -l /usr/local/mysql/var/
先查看一下数据库目录下mysql-bin.000之类的权限,属主和属组是否是mysql

如果不是 chown mysql:mysql -R /usr/local/mysql/var/

如果还不行可以清空mysql-bin.index文件,删除mysql-bin.000这些文件
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-11-17 12:43 , Processed in 0.025263 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表