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

Error 1210 description needs expanded

    XMLWordPrintable

Details

    Description

      The current documentation implies by omission that

      CREATE TABLE tname ( cols descr ) DATA DIRECTORY='absolute path'

      is sufficiently specific. My tables on my dev machine are in /Local/tables. I want to add an ssd so that table creation and population takes less than geologic time (they're of multi-GB size, and my discs are mechanical). So naturally I created the mount point /Local/tables/SSD, and fixed up permits (0700) and ownership (mysql:mysql).

      But attempting to

      CREATE TABLE foo2 (bar INT) DATA DIRECTORY='/Local/tables/SSD' ENGINE=ARIA

      failed with a 1210 (HY000) Incorrect arguments to DATA DIRECTORY.

      It made no sense. After some search and experiment I discovered that one cannot have the alternative subtree as a child of the datadir subtree. Putting it at root level (/SSD) works, and even /Local/SSD is okay. But /Local/tables/SSD does not work and the error message is not helpful.

      This is not documented very well at all, but should be, both in CREATE TABLE and in ERROR 1210. because it's a counter-intuitive limitation and is very productive of baffling errors.

      I'd make the edits myself, but can't discover how to get at the docs in edit mode.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            MMacD M MacDonald
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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