Comments - Knowledge Base Search Operators

10 years, 10 months ago Harikrishna Ravipati

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

 
10 years, 10 months ago Elena Stepanova

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.

 
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.