Answer the question
In order to leave comments, you need to log in
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';
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";
errno: 11 "Resource temporarily unavailable"
ALTER TABLE `test_sphinx` ENGINE = SPHINX
Ответ MySQL:
#1005 - Can't create table `search`.`#sql-1d00_1bf` (errno: 13 "Permission denied")
#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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question