Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.1.17
-
None
-
Debian 8.5
Sphinx 2.2.6-id64-release (r4843)
Description
MariaDB cannot create new table with Sphinx engine:
create table a (id integer unsigned not null, weight integer not null, query varchar(4096) not null, string text, index(query)) engine=sphinx connection="sphinx://127.0.0.1:9312/test";
|
Error in query (1005): Can't create table `grabien`.`a` (errno: 1 "Operation not permitted")
|
|
create table aa (id integer unsigned not null, weight integer not null, query varchar(4096) not null, string text, index(query)) engine=sphinx connection="sphinx://127.0.0.1:9312/test";
|
Error in query (1005): Can't create table `grabien`.`aa` (errno: 2 "No such file or directory")
|
|
create table aaa (id integer unsigned not null, weight integer not null, query varchar(4096) not null, string text, index(query)) engine=sphinx connection="sphinx://127.0.0.1:9312/test";
|
Error in query (1005): Can't create table `grabien`.`aaa` (errno: 3 "No such process")
|
Number of error corresponds to number of characters in name of table.
Sphinx plugin is installed:
select * from information_schema.all_plugins where plugin_name like '%sphinx%'
|
|
PLUGIN_NAME - SPHINX
|
PLUGIN_VERSION - 2.2
|
PLUGIN_STATUS - ACTIVE
|
PLUGIN_TYPE - STORAGE ENGINE
|
PLUGIN_TYPE_VERSION - 100117.0
|
PLUGIN_LIBRARY - ha_sphinx.so
|
PLUGIN_LIBRARY_VERSION - 1.11
|
PLUGIN_AUTHOR - Sphinx developers
|
PLUGIN_DESCRIPTION - Sphinx storage engine 2.2.6-release
|
PLUGIN_LICENSE - GPL
|
LOAD_OPTION - ON
|
PLUGIN_MATURITY - Gamma
|
PLUGIN_AUTH_VERSION - 2.2.6-release
|