Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10745

Invalid SphinxSE table causes wrong error messages

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.1.17
    • 10.1
    • 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
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            MaximV Maxim Volobuev
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.