Got error -1 from storage engine with non-existing DATA DIRECTORY = '/home/datadir'

[Shahriyar Rzayev]

Hi dear experts,
There is another cryptic error message while trying to create tablespace outside default data directory:

mysql> CREATE TABLE t2 (c1 INT PRIMARY KEY) DATA DIRECTORY = '/home/datadir';
ERROR 1030 (HY000): Got error -1 from storage engine

From error log:

2015-11-05 12:55:44 7f52c7b7e700 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.

In fact there is no such directory:

sh@percona-XPS-15:~$ ls /home/datadir
ls: cannot access /home/datadir: No such file or directory

[Laurynas Biveinis (laurynas-biveinis)]

Please report this bug to upstream, and add a link here.
In fact, if the bug is upstream, and there is no overriding reason to report it to PS separately (ie. accompanied by a fix request etc), there is no need to report it to PS at all.

[Shahriyar Rzayev (rzayev-sehriyar)]

Encountered first time with PS 5.6 while testing TokuBackup :)
Surely, I will check it with upstream and comment a link here as well.

[Roel Van de Paar (roel11)]

Hi Shako, yes, as per Laurynas, please always test upstream first. If found to be in upstream, simply log there. Thanks

[Roel Van de Paar (roel11)]

To mark a bug as upstream click "Also affects distribution/package" and add the upstream URL in the URL field there.

[Roel Van de Paar (roel11)]

Apologies, it's "Also affects project" -> "mysql-server" -> upstream bug link.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1667