服务器 Gind.cn
  1. 服务器 Gind.cn
  3. MariaDB崩溃，现在不会启动
Intereting Posts
电子邮件回复块标准 仅允许通过密钥和UsePAM设置login时的安全隐患是“是”？ LINUX中的内存使用情况 OpenVPN – 客户端无法从命令行连接到服务器 更改shell脚本的bash shell 木偶企业节点安装 – 安全风险？ WebDAV在现实中有多受欢迎？ 是否有可能使用IIS7的256位SSLencryption？ 如何在本地主机上创build多个子域？ 在IIS中添加虚拟目录，指向没有AD的另一台计算机上的共享path 在等于操作中无法解决“SQL_Latin1_General_CP437_CI_AI”和“SQL_Latin1_General_CP1_CI_AS”之间的sorting规则冲突 /etc/profile.d和“ssh -t” 关于Vlan的问题 如何镜像数据库并实现故障转移解决scheme 我怎样才能安装video监控

MariaDB崩溃，现在不会启动

当激活一个wordpress插件MariaDB在我身上坠毁，它不会重新启动。 我正在使用Centos 7.1。

systemctl状态： 

systemctl status mariadb.service mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled) Active: failed (Result: exit-code) since Tue 2015-10-27 20:22:02 EDT; 2min 29s ago Process: 3587 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE) Process: 3586 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS) Process: 3559 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS) Main PID: 3586 (code=exited, status=0/SUCCESS) Oct 27 20:22:01 s1.pavelow.net mysqld_safe[3586]: 151027 20:22:01 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. Oct 27 20:22:01 s1.pavelow.net mysqld_safe[3586]: 151027 20:22:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Oct 27 20:22:01 s1.pavelow.net mysqld_safe[3586]: 151027 20:22:01 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended Oct 27 20:22:02 s1.pavelow.net systemd[1]: mariadb.service: control process exited, code=exited status=1 Oct 27 20:22:02 s1.pavelow.net systemd[1]: Failed to start MariaDB database server. Oct 27 20:22:02 s1.pavelow.net systemd[1]: Unit mariadb.service entered failed state.

journalctl -xn 

 -- Logs begin at Tue 2015-10-27 20:05:31 EDT, end at Tue 2015-10-27 20:24:34 EDT. -- Oct 27 20:24:34 s1.pavelow.net NetworkManager[533]: <info> (eth1): DHCPv4 state changed timeout -> done Oct 27 20:24:34 s1.pavelow.net NetworkManager[533]: <info> (eth1): Activation: Stage 4 of 5 (IPv4 Configure Timeout) scheduled... Oct 27 20:24:34 s1.pavelow.net NetworkManager[533]: <info> (eth1): Activation: Stage 4 of 5 (IPv4 Configure Timeout) started... Oct 27 20:24:34 s1.pavelow.net NetworkManager[533]: <info> (eth1): device state change: ip-config -> failed (reason 'ip-config-unavailable') Oct 27 20:24:34 s1.pavelow.net NetworkManager[533]: <info> Disabling autoconnect for connection 'Wired connection 1'. Oct 27 20:24:34 s1.pavelow.net NetworkManager[533]: <warn> (eth1): Activation: failed for connection 'Wired connection 1' Oct 27 20:24:34 s1.pavelow.net NetworkManager[533]: <info> (eth1): Activation: Stage 4 of 5 (IPv4 Configure Timeout) complete. Oct 27 20:24:34 s1.pavelow.net NetworkManager[533]: <info> (eth1): device state change: failed -> disconnected (reason 'none') [120 30 0] Oct 27 20:24:34 s1.pavelow.net NetworkManager[533]: <info> (eth1): deactivating device (reason 'none') [0] Oct 27 20:24:34 s1.pavelow.net avahi-daemon[506]: Withdrawing address record for fe80::601:7cff:fef5:3c02 on eth1.

MariaDB.log（超级完整文件： http ：//pastebin.com/dgDDVgLv）： 

 151027 19:58:18 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended 151027 19:58:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 151027 19:58:50 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 14311 ... 151027 19:58:50 InnoDB: The InnoDB memory heap is disabled 151027 19:58:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins 151027 19:58:50 InnoDB: Compressed tables use zlib 1.2.7 151027 19:58:50 InnoDB: Using Linux native AIO 151027 19:58:50 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137756672 bytes) failed; errno 12 151027 19:58:50 InnoDB: Completed initialization of buffer pool 151027 19:58:50 InnoDB: Fatal error: cannot allocate memory for the buffer pool 151027 19:58:50 [ERROR] Plugin 'InnoDB' init function returned error. 151027 19:58:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 151027 19:58:50 [ERROR] mysqld: Out of memory (Needed 128917504 bytes) 151027 19:58:51 [Note] Plugin 'FEEDBACK' is disabled. 151027 19:58:51 [ERROR] Unknown/unsupported storage engine: InnoDB 151027 19:58:51 [ERROR] Aborting 151027 19:58:51 [Note] /usr/libexec/mysqld: Shutdown complete 151027 19:58:51 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended

感谢您的帮助。

根据你的错误日志，你没有足够的内存来启动当前configuration的MariaDB。 有一些解决scheme：如果可能，添加额外的RAM; 根据该指令添加额外的交换; 更改MariaDBconfiguration以防止高内存使用率，例如根据此博客文章 ，将innodb_buffer_pool_size减less到内存的80％。