Comments - Knowledge Base Search Operators
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hi All,
I tried to run mysql database server like below,i am getting pid ended.
[mysql@TEST-LSM-R app]$ ./bin/mysqld_safe&
[1] 6724 [mysql@TEST-LSM-R app] $ 130503 09:07:32 mysqld_safe logging to '/db/mysql/data/TEST-LSM-R.err'. 130503 09:07:33 mysqld_safe Starting mysqld daemon with database from /db/mysql/data 130503 09:07:33 mysqld_safe mysqld from pid file /db/mysql/data/TEST-LSM-R.pid ended
[mysql@TEST-LSM-R app] $ /bin/mysqld_safe --console --user=mysql
130503 12:44:29 mysqld_safe Logging to '/db/mysql/data/TEST-LSM-R.log'. 130503 12:44:29 mysqld_safe Starting mysqld daemon with databases from /db/mysql/data 130503 12:44:29 mysqld_safe mysqld from pid file /db/mysql/data/TEST-LSM-R.pid ended
plz can any one let me know why this issue coming.
Regards, Hari
The error only indicates that the server failed to start, it could be on whatever reason. For details of the failure, check your server error log or syslog if that's what you are using. For more information, see the troubleshooting section of MySQL manual.
I check error log. log files located in the data directory, ifound the below errors,
[root@TEST-R data]# tail -f TEST-R.err /db/mysql/app/bin/mysqld: Can't create/write to file '/db/mysql/tmp/ib3xHqRO' (Errcode: 2)
130503 12:38:17 InnoDB: Error: unable to create temporary file; errno: 2
130503 12:38:17 [ERROR] Plugin 'InnoDB' init function returned error.
130503 12:38:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130503 12:38:17 [ERROR] Unknown/unsupported storage engine: InnoDB
130503 12:38:17 [ERROR] Aborting
130503 12:38:17 [Note] /db/mysql/app/bin/mysqld: Shutdown complete
130503 12:38:17 mysqld_safe mysqld from pid /db/mysql/data/TEST-LSM-R.pid ended
Can any one give me the solution how to fix this issue.
Regards, Hari
The error you quoted clearly indicates the problem, InnoDB cannot create file /db/mysql/tmp/ib3xHqRO because there is no such file or directory (errcode 2). The solution is up to you, either create the folder beforehand, or point your server to already existing location.