Solo the human
27-03-2011, 21:56
ОС FreeBSD 8.2 x86, MySQL 5.5 вываливается с ошибкой
110327 17:29:42 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
110327 17:29:42 InnoDB: The InnoDB memory heap is disabled
110327 17:29:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110327 17:29:42 InnoDB: Compressed tables use zlib 1.2.3
110327 17:29:42 InnoDB: Initializing buffer pool, size = 128.0M
110327 17:29:42 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 45
110327 17:29:42 InnoDB: Operating system error number 45 in a file operation.
InnoDB: Error number 45 means 'Operation not supported'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-sys…-error-codes.html
InnoDB: Error in creating or opening ./ibdata1
110327 17:29:42 InnoDB: Could not open or create data files.
110327 17:29:42 InnoDB: If you tried to add new data files, and it failed here,
110327 17:29:42 InnoDB: you should now edit innodb_data_file_path in my.cnf back
110327 17:29:42 InnoDB: to what it was, and remove the new ibdata files InnoDB created
110327 17:29:42 InnoDB: in this failed attempt. InnoDB only wrote those files full of
110327 17:29:42 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
110327 17:29:42 InnoDB: remove old data files which contain your precious data!
110327 17:29:42 [ERROR] Plugin 'InnoDB' init function returned error.
110327 17:29:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110327 17:29:42 [ERROR] Unknown/unsupported storage engine: InnoDB
110327 17:29:42 [ERROR] Aborting
110327 17:29:42 [Note] /usr/local/libexec/mysqld: Shutdown complete
110327 17:29:42 mysqld_safe mysqld from pid file /var/db/mysql/ns01.pid ended
Сделал
rpc_lockd_enable="NO" # Run NFS rpc.lockd needed for client/server.
rpc_statd_enable="NO" # Run NFS rpc.statd needed for client/server.
как написано тут http://bugs.mysql.com/bug.php?id=47769
Не помогло
110327 17:29:42 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
110327 17:29:42 InnoDB: The InnoDB memory heap is disabled
110327 17:29:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110327 17:29:42 InnoDB: Compressed tables use zlib 1.2.3
110327 17:29:42 InnoDB: Initializing buffer pool, size = 128.0M
110327 17:29:42 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 45
110327 17:29:42 InnoDB: Operating system error number 45 in a file operation.
InnoDB: Error number 45 means 'Operation not supported'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-sys…-error-codes.html
InnoDB: Error in creating or opening ./ibdata1
110327 17:29:42 InnoDB: Could not open or create data files.
110327 17:29:42 InnoDB: If you tried to add new data files, and it failed here,
110327 17:29:42 InnoDB: you should now edit innodb_data_file_path in my.cnf back
110327 17:29:42 InnoDB: to what it was, and remove the new ibdata files InnoDB created
110327 17:29:42 InnoDB: in this failed attempt. InnoDB only wrote those files full of
110327 17:29:42 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
110327 17:29:42 InnoDB: remove old data files which contain your precious data!
110327 17:29:42 [ERROR] Plugin 'InnoDB' init function returned error.
110327 17:29:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110327 17:29:42 [ERROR] Unknown/unsupported storage engine: InnoDB
110327 17:29:42 [ERROR] Aborting
110327 17:29:42 [Note] /usr/local/libexec/mysqld: Shutdown complete
110327 17:29:42 mysqld_safe mysqld from pid file /var/db/mysql/ns01.pid ended
Сделал
rpc_lockd_enable="NO" # Run NFS rpc.lockd needed for client/server.
rpc_statd_enable="NO" # Run NFS rpc.statd needed for client/server.
как написано тут http://bugs.mysql.com/bug.php?id=47769
Не помогло