[MDEV-10745] Invalid SphinxSE table causes wrong error messages Created: 2016-09-05  Updated: 2017-01-18

Status: Confirmed
Project: MariaDB Server
Component/s: Storage Engine - SphinxSE
Affects Version/s: 10.1.17
Fix Version/s: 10.1

Type: Bug Priority: Minor
Reporter: Maxim Volobuev Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

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



 Comments   
Comment by Elena Stepanova [ 2016-09-05 ]

The culprit here is the column string text. SphinxSE does not support TEXT data type for additional columns, see documentation:

Additional columns must be either INTEGER, TIMESTAMP, BIGINT, VARCHAR, or FLOAT.

But the error messages are awful, hopefully they can be fixed.

Generated at Thu Feb 08 07:44:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.