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

Impossible to optimize tables (TRANSACTIONAL option is handled inconsistently)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0, 10.1, 10.2.18, 10.2, 10.3
    • 10.2.37, 10.3.28, 10.4.18, 10.5.9
    • Server
    • None
    • Ubuntu 14.04

    Description

      Attempting to optimize a table (existing or new) fails immediately.

       
      MariaDB [my_db]> CREATE TABLE toku_bug ( 
        toku_bug_key int(10) unsigned not null auto_increment,
        primary key (toku_bug_key)
      ) ENGINE=TokuDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 `compression`=TOKUDB_LZMA;
      Query OK, 0 rows affected, 1 warning (0.03 sec)
       
      MariaDB [my_db]> optimize table toku_bug;
      +------------------+----------+----------+------------------------------------------------------------------------------------+
      | Table            | Op       | Msg_type | Msg_text                                                                           |
      +------------------+----------+----------+------------------------------------------------------------------------------------+
      | zija_db.toku_bug | optimize | note     | Table does not support optimize, doing recreate + analyze instead                  |
      | zija_db.toku_bug | optimize | error    | Table storage engine 'TokuDB' does not support the create option 'TRANSACTIONAL=1' |
      | zija_db.toku_bug | optimize | status   | Operation failed                                                                   |
      +------------------+----------+----------+------------------------------------------------------------------------------------+
      
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              Soltis Kai
              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.