On OMV VM, i have install zfs plugin and i would install mysql.
Mysql don't want to start.
I take this error :
Code
Erreur #4000: exception 'OMVException' with message
'Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' start 2>&1': Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.' in /usr/share/php/openmediavault/initscript.inc:176
Stack trace:
#0 /usr/share/php/openmediavault/initscript.inc(141): OMVSysVInitScript->invoke('start')
#1 /usr/share/php/openmediavault/initscript.inc(61): OMVSysVInitScript->start()
#2 /usr/share/openmediavault/engined/module/mysql.inc(117): OMVSysVInitScript->exec()
#3 /usr/share/openmediavault/engined/rpc/config.inc(206): OMVModuleMySQL->startService()
#4 [internal function]: OMVRpcServiceConfig->applyChanges(Array, Array)
#5 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
#6 /usr/share/php/openmediavault/rpcservice.inc(158): OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array)
#7 /usr/share/openmediavault/engined/rpc/config.inc(224): OMVRpcServiceAbstract->callMethodBg('applyChanges', Array, Array)
#8 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array)
#9 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
#10 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array)
#11 /usr/sbin/omv-engined(500): OMVRpc::exec('Config', 'applyChangesBg', Array, Array, 1)
#12 {main}
Alles anzeigen
and in syslog
Code
Feb 26 10:17:21 openmediavault-test mysqld_safe: Starting mysqld daemon with databases from /zfsPool/mysql/
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 [Note] Plugin 'FEDERATED' is disabled.
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 InnoDB: The InnoDB memory heap is disabled
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 InnoDB: Compressed tables use zlib 1.2.7
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 InnoDB: Using Linux native AIO
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 InnoDB: Initializing buffer pool, size = 128.0M
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 InnoDB: Completed initialization of buffer pool
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 InnoDB: highest supported file format is Barracuda.
Feb 26 10:17:21 openmediavault-test mysqld: 150226 10:17:21 InnoDB: Operating system error number 22 in a file operation.
Feb 26 10:17:21 openmediavault-test mysqld: InnoDB: Error number 22 means 'Invalid argument'.
Feb 26 10:17:21 openmediavault-test mysqld: InnoDB: Some operating system error numbers are described at
Feb 26 10:17:21 openmediavault-test mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
Feb 26 10:17:21 openmediavault-test mysqld: InnoDB: File name ./ib_logfile0
Feb 26 10:17:21 openmediavault-test mysqld: InnoDB: File operation call: 'aio write'.
Feb 26 10:17:21 openmediavault-test mysqld: InnoDB: Cannot continue operation.
Feb 26 10:17:21 openmediavault-test mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Alles anzeigen
I go on google and found this : http://www.percona.com/forums/…ory-to-zfs-on-percona-5-5
It means that the ZFS implementation you are currently running on that host does not support AIO.
I add into extra option of mysql config :
innodb_use_native_aio=0
I save and mysql start !!!!!
This is for information.