无法创建 MySQL 数据库

[quasimo]

无论是在 OSC 还是在 CNPaaS 后台。

[LiAh Sheep]

在哪一個帳戶發生？

[LiAh Sheep]

Log says:

Starting MySQL 5.5 cartridge
MySQL server failed to start:
150805 12:13:19 mysqld_safe Logging to '/var/lib/openshift/55c189649068dc61b1000457/mysql//stdout.err'.
150805 12:13:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/openshift/55c189649068dc61b1000457/mysql/data/
150805 12:13:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/openshift/55c189649068dc61b1000457/mysql/data/
150805 12:13:19 [Note] Plugin 'FEDERATED' is disabled.
150805 12:13:19 InnoDB: The InnoDB memory heap is disabled
150805 12:13:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150805 12:13:19 InnoDB: Compressed tables use zlib 1.2.3
150805 12:13:19 InnoDB: Using Linux native AIO
150805 12:13:19  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
150805 12:13:22  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
150805 12:13:22 InnoDB: Fatal error: cannot initialize AIO sub-system
150805 12:13:22 [ERROR] Plugin 'InnoDB' init function returned error.
150805 12:13:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150805 12:13:22 [ERROR] Unknown/unsupported storage engine: InnoDB
150805 12:13:22 [ERROR] Aborting
150805 12:13:22 [Note] /opt/rh/mysql55/root/usr/libexec/mysqld: Shutdown complete
chown: changing ownership of `/var/lib/openshift/55c189649068dc61b1000457/mysql//stdout.err': Operation not permitted
150805 12:13:22 mysqld_safe mysqld from pid file /var/lib/openshift/55c189649068dc61b1000457/mysql/pid/mysql.pid ended
150805 12:13:22 mysqld_safe mysqld from pid file /var/lib/openshift/55c189649068dc61b1000457/mysql/pid/mysql.pid ended

Should be mis-configuration of mysql. May need to update cartridge?

[quasimo]

这个账户： [e-mail]

[LiAh Sheep]

Workaround: added env OPENSHIFT_MYSQL_AIO=0 before service creation.
Drawback: may decrease database performance.

Reference:
https://bugzilla.redhat.com/show_bug.cgi?format=multiple&id=1085282

[LiAh Sheep]

Meaning of the variable fyi:
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_use_native_aio

[Jimmy Chu]

fix: mysql creation error, by disabling “Linux native AIO” (fixing #240)

→ <<cset fdad0a595a7b>>

[Jimmy Chu]

Merged in liahsheep/cnpaas-portal (pull request #211)

fix: mysql creation error, by disabling “Linux native AIO” (fixing #240)

→ <<cset 57a7c374cc14>>