Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-244

pt-online-schema-change --data-dir option broken for partitioned table

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.0.4, 3.0.6
    • Fix Version/s: 3.0.7
    • Component/s: None
    • Labels:
      None

      Description

      5.7.20-18 Percona Server

      create table t (c int) engine=innodb PARTITION BY HASH(c) PARTITIONS 4;
      
      mkdir -p /data/db/data1; chown mysql:mysql -R /data/db ; ./pt-online-schema-change --data-dir="/data/db/data1" --execute  --alter "engine=innodb" D=test,t=t
      No slaves found.  See --recursion-method if host fd0b85b08720 has slaves.
      Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
      Operation, tries, wait:
        analyze_table, 10, 1
        copy_rows, 10, 0.25
        create_triggers, 10, 1
        drop_triggers, 10, 1
        swap_tables, 10, 1
        update_foreign_keys, 10, 1
      Altering `test`.`t`...
      Creating new table...
      `test`.`t` was not altered.
      Error creating new table: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATA DIRECTORY='/data/db/data1'' at line 5 [for Statement "CREATE TABLE `test`.`_t_new` (
        `c` int(11) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
      /*!50100 PARTITION BY HASH (c)
      PARTITIONS 4 */ DATA DIRECTORY='/data/db/data1' "] at ./pt-online-schema-change line 10342.
      

      correct create table statement:

      CREATE TABLE `test`.`_t_new` (   `c` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='/data/db/data1' /*!50100 PARTITION BY HASH (c) PARTITIONS 4 */;
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                carlos.salguero Carlos Salguero
                Reporter:
                nickolay.ihalainen Nickolay Ihalainen
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: