mariadb 无法启动

i1zhuxian

[Bash shell] 纯文本查看 复制代码

[iyunv@openstack1 mariadb]# cat mariadb.log 
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Memory barrier is not used
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Using Linux native AIO
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Using SSE crc32 instructions
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Completed initialization of buffer pool
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-04  2:21:51 139817963714688 [Note] InnoDB: Waiting for purge to start
2016-05-04  2:21:51 139817963714688 [Note] InnoDB:  Percona XtraDB ([url=http://www.percona.com]http://www.percona.com[/url]) 5.6.28-76.1 started; log sequence number 1616839
2016-05-04  2:21:51 139817081890560 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-05-04  2:21:51 139817963714688 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-04  2:21:51 139817963714688 [Warning] GSSAPI plugin : default principal 'mariadb/openstack1@' not found in keytab
2016-05-04  2:21:51 139817963714688 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure.  Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty. 
2016-05-04  2:21:51 139817963714688 [ERROR] Plugin 'gssapi' init function returned error.
2016-05-04  2:21:51 139817963714688 [ERROR] Unknown/unsupported storage engine: innodb     .
2016-05-04  2:21:51 139817963714688 [ERROR] Aborting

试着去安装openstack，在启动mariadb时报错，无法启动，mariadb日志如上。
配置文件如下：

[Bash shell] 纯文本查看 复制代码

[iyunv@openstack1 mariadb]# cat /etc/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# This group is read by the server
#
[mysqld]
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[Bash shell] 纯文本查看 复制代码

[iyunv@openstack1 mariadb]# cat /etc/my.cnf.d/openstack.cnf
#绑定IP
[mysqld]
bind-address = 10.0.0.11
#设置字符集等
default-storage-engine = innodb     .
innodb_file_per_table
collation-server = utf8_general_ci  
character-set-server = utf8

1307077801

Unknown/unsupported storage engine: innodb  

i1zhuxian

1307077801 发表于 2016-5-4 14:43
Unknown/unsupported storage engine: innodb

thankyou！
解决过程如下：

[Bash shell] 纯文本查看 复制代码

[iyunv@openstack1 my.cnf.d]# vim /etc/my.cnf.d/mariadb-server.cnf 


[mysqld]

default-storage-engine=INNODB

一开始将default-storage-engine=INNODB 直接配置在/etc/my.cnf中不知道为什么没生效。
写到/etc/my.cnf.d/mariadb-server.cnf 中就OK了……