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

pt-online-schema-change --alter="ENGINE=InnoDB" not working

    XMLWordPrintable

    Details

      Description

      I have recently intstalled PT in ubuntu my local system and run below command, it gived an error. please note that my table 'YYY' size is 20 GB.

      root@maulik-papps:/home/maulik# pt-online-schema-change D=XXX,t=YYY,h=localhost,u=root --alter="ENGINE=InnoDB" --alter-foreign-keys-method="auto" --ask-pass --execute
      Enter MySQL password:
      No slaves found. See --recursion-method if host maulik-papps 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
      No foreign keys reference `XXX`.`YYY`; ignoring --alter-foreign-keys-method.
      Altering `XXX`.`YYY`...
      Creating new table...
      Created new table XXX._YYY_new OK.
      Altering new table...
      Altered `XXX`.`_YYY_new` OK.
      2018-08-17T19:16:20 Creating triggers...
      2018-08-17T19:16:20 Created triggers OK.
      2018-08-17T19:16:20 Copying approximately 29641786 rows...
      2018-08-17T19:16:50 Dropping triggers...
      2018-08-17T19:16:50 Dropped triggers OK.
      2018-08-17T19:16:50 Dropping new table...
      2018-08-17T19:16:50 Dropped new table OK.
      `XXX`.`YYY` was not altered.
      2018-08-17T19:16:50 Error copying rows from `XXX`.`YYY` to `XXX`.`_YYY_new`: Redundant argument in printf at /usr/bin/pt-online-schema-change line 3595.

       

       

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            maulikpatelbtech Maulik Patel
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist