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

Impossible to optimize tables (TRANSACTIONAL option is handled inconsistently)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.1, 10.2, 10.3, 10.2.18, 10.0
    • Fix Version/s: 10.1, 10.2, 10.3, 10.4, 10.0
    • Component/s: Server
    • Labels:
      None
    • Environment:
      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

              Assignee:
              serg Sergei Golubchik
              Reporter:
              Soltis Kai
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: