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

ALTER ONLINE TABLE reported as not supported for TokuDB table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.0
    • N/A
    • OTHER
    • None

    Description

      Hi,

      When I try to run an ALTER ONLINE TABLE my_table ADD KEY my_key (...) on a TokuDB table, it reports
      ERROR 1845 (0A000): LOCK=NONE is not supported for this operation. Try LOCK=SHARED.

      However, ONLINE is supported, and it's an online operation which is applied when the syntax
      CREATE INDEX my_key ON my_table (...) is used if tokudb_create_index_online is ON, as described here : https://www.percona.com/doc/percona-server/5.7/tokudb/using_tokudb.html.

      To repeat :

      CREATE TABLE test (a INT) ENGINE=TokuDB;
      ALTER ONLINE TABLE test ADD KEY my_index (a);
      ERROR 1845 (0A000): LOCK=NONE is not supported for this operation. Try LOCK=SHARED.
      

      It would be great to have a consistent behaviour in MariaDB.
      (but I agree it should be fixed upstream instead)

      Thanks and regards,
      Jocelyn Fournier

      Attachments

        Activity

          People

            serg Sergei Golubchik
            joce jocelyn fournier
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.