MySQL5.6启动报错The server quit without updating PID file

时间:2022-09-27 16:22:00

Mysql启动报错如下:

[root@db01 opt]# service mysqld start

Starting MySQL.... ERROR! The server quit without updating PID file (/opt/mysql-5.6.24/data/mysql.pid).

查看错误日志,发现问题根源在于下面红色部分:

2017-08-26 01:45:44 8525 [Note] InnoDB: Initializing buffer pool, size = 256.0M

2017-08-26 01:45:44 8525 [Note] InnoDB: Completed initialization of buffer pool

2017-08-26 01:45:44 8525 [Note] InnoDB: Highest supported file format is Barracuda.

2017-08-26 01:45:44 8525 [Note] InnoDB: 128 rollback segment(s) are active.

2017-08-26 01:45:44 8525 [Note] InnoDB: Waiting for purge to start

2017-08-26 01:45:44 8525 [Note] InnoDB: 5.6.24 started; log sequence number 1626194

2017-08-26 01:45:44 8525 [ERROR] --gtid-mode=ON or UPGRADE_STEP_1 requires --enforce-gtid-consistency

2017-08-26 01:45:44 8525 [ERROR] Aborting

2017-08-26 01:45:44 8525 [Note] Binlog end

2017-08-26 01:45:44 8525 [Note] Shutting down plugin 'rpl_semi_sync_slave'

2017-08-26 01:45:44 8525 [Note] Shutting down plugin 'rpl_semi_sync_master'

2017-08-26 01:45:44 8525 [Note] unregister_replicator OK

2017-08-26 01:45:44 8525 [Note] Shutting down plugin 'partition'

2017-08-26 01:45:44 8525 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2017-08-26 01:45:44 8525 [Note] Shutting down plugin 'BLACKHOLE'

2017-08-26 01:45:44 8525 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

解决办法:将/etc/my.cnf文件参数注释掉:

#gtid-mode = ON

#enforce-gtid-consistency = 1

重新启动mysql,成功。