F
F
fso2014-03-06 18:08:07
Sphinx
fso, 2014-03-06 18:08:07

Error when creating and modifying a table with the SPHINX engine?

Greetings!
Installed sphinx 2.2 and mariadb 10 on debian 7.
plugin for SPHINX support enabled successfully

mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';

the plugin itself is present 16b936c5097eee9025f2e5e8f62c20f0.png
Created a regular sCompany index (the indexer worked fine and the index files are in the folder, no errors, the index is there).
But when trying to do
CREATE TABLE `test_sphinx`
(
    `id`          INTEGER NOT NULL,
    `weight`      INTEGER NOT NULL,
    `query`       VARCHAR(3072) NOT NULL,
    `group_id`    INTEGER,
    INDEX(`query`)
) ENGINE=SPHINX CONNECTION="sphinx://localhost:9312/sCompany";

gives an error
errno: 11 "Resource temporarily unavailable"
If you create a table, for example MyISAM, and try to change the engine to SPHINX, then it swears
ALTER TABLE  `test_sphinx` ENGINE = SPHINX

Ответ MySQL: 

#1005 - Can't create table `search`.`#sql-1d00_1bf` (errno: 13 "Permission denied")

Can someone tell me where to dig?
UPD: I noticed that the error number depends on the number of characters in the table name - if the table name consists of one character, then errno 1, of two - errno 2, etc.
#1005 - Can't create table `search`.`a` (errno: 1 "Operation not permitted")
#1005 - Can't create table `search`.`aa` (errno: 2 "No such file or directory")
#1005 - Can't create table `search`.`aaa` (errno: 3 "No such process")
#1005 - Can't create table `search`.`aaaa` (errno: 4 "Interrupted system call")
...

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
klirichek, 2014-04-22
@klirichek

The index was created, ok. Have you started the daemon? Which listens to localhost:9312 and serves the created index?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question