我尝试在保存脚本后重新启动 MySQL。错误状态
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
运行时systemctl status mysql.service
我得到的结果如下:
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start-post) (Result: exit-code) since Isn 2016-09-26 17:15:28 MYT; 17s ago
Process: 17478 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 17474 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 17478 (code=exited, status=1/FAILURE); : 17479 (mysql-systemd-s)
CGroup: /system.slice/mysql.service
└─control
├─17479 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─17516 sleep 1
我不知道从哪里开始解决这个问题。
这是我在重新启动 mysql 之前保存的脚本:
[mysqld]
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
max_connections=350
log-bin=mysql-bin
binlog-format = 'ROW'
跑步journalctl -xe | tail -20
给了我这个:
Sep 26 17:46:29 guest mysqld[21937]: 2016-09-26T09:46:29.037709Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
Sep 26 17:46:29 guest mysqld[21937]: 2016-09-26T09:46:29.037798Z 0 [Warning] Changed limits: max_connections: 214 (requested 350)
Sep 26 17:46:29 guest mysqld[21937]: 2016-09-26T09:46:29.037809Z 0 [Warning] Changed limits: table_open_cache: 400 (requested 2000)
Sep 26 17:46:29 guest mysqld[21937]: 2016-09-26T09:46:29.187886Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
Sep 26 17:46:29 guest mysqld[21937]: 2016-09-26T09:46:29.189296Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.15-0ubuntu0.16.04.1-log) starting as process 21937 ...
Sep 26 17:46:29 guest mysqld[21937]: 2016-09-26T09:46:29.191216Z 0 [ERROR] You have enabled the binary log, but you haven't provided the mandatory server-id. Please refer to the proper server start-up parameters documentation
Sep 26 17:46:29 guest mysqld[21937]: 2016-09-26T09:46:29.191242Z 0 [ERROR] Aborting
Sep 26 17:46:29 guest mysqld[21937]: 2016-09-26T09:46:29.191255Z 0 [Note] Binlog end
Sep 26 17:46:29 guest mysqld[21937]: 2016-09-26T09:46:29.191300Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 26 17:46:29 guest systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Sep 26 17:46:32 guest NetworkManager[878]: <info> [1474883192.2910] device (eth0): Lowering IPv6 MTU (9000) to match device MTU (1500)
跑步ulimit && ulimit -Sa
让我:
unlimited
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 128071
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 128071
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
答案1
致命错误:
MYQL 无法启动,因为正如 Journalctl 输出所示,but you haven't provided the mandatory server-id.
添加强制 id,如下面的代码所示。
/etc/mysql/mysql.conf.d/mysqld.cnf
更改自:
log-bin=mysql-bin
binlog-format = 'ROW'
改成:
server-id=master-01
log-bin=mysql-bin
binlog-format = 'ROW'
当您处理所需日志的正确格式时,这将使您的服务器运行。
非致命警告:
对于错误的打开文件限制,您必须减少所编辑配置中的需求或增加系统的限制:
/etc/security/limits.conf
* soft nofile [new number]
* hard nofile [new number]
第一列描述了该限制适用于哪些人。'' 是通配符,表示所有用户。要提高 root 的限制,您必须明确输入“root”而不是““”。
答案2
出现了同样的错误,但就我的情况来说,只是磁盘已满。也请务必检查这一点。
df -h --total
答案3
通过以下方式解决问题:
- 添加交换文件
- 添加
innodb_buffer_pool_size = 20M
到配置文件中/etc/mysql/my.cnf
,确保它位于一个组中
答案4
我的问题是主机的IP被更改了。
因此请将其编辑bind-address
为/etc/mysql/my.cnf
正确的内容。