Got error -1 from storage engine
Posted by: Devrishi Shandilya
Date: December 28, 2015 12:46AM

Hi Guys,

I am trying to create table outside data directory like this, but i got error ;

mysql> create table tempo2 (id int (11)) DATA DIRECTORY='/storage/mysql';
ERROR 1030 (HY000): Got error -1 from storage engine

and in MySQL error logs :

Error: Write to file ./bigdata/tempo2.isl failed at offset 0.
InnoDB: 33 bytes should have been written, only 0 were written.
InnoDB: Operating system error number 22.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 22 means 'Invalid argument'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html



I have changed mysql tmp directory to different paths, also set variables innodb_use_native_aio=OFF, but error is same.

I am using Percona server 5.6.27-76.0 , i am also trying it on Oracle mysql 5.6.27 but i facing same error.

Could someone suggest on this ?

Devrishi Shandilya

Options: ReplyQuote


Subject
Written By
Posted
Got error -1 from storage engine
December 28, 2015 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.