Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

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.

 

 

Environment

None

Smart Checklist

Activity

Show:

Lalit Choudhary September 20, 2018 at 11:49 AM

Hi Maulik,

Thank you for the update.

Maulik patel September 20, 2018 at 11:29 AM

Hi Lalit,

Thank you very much for reply. My pt-online-schema-change version was 2.x, just update it to 3.x and it work very well.

Thanks again

Lalit Choudhary September 20, 2018 at 10:47 AM

Hi Maulik,

Thank you for the report.

I did the test with pt-osc 3.0.11 version, I cannot reproduce the issue.

Please provide table definition for a problematic table. Also share pt-online-schema-change version that you are using.

if possible run pt-osc with PTDEBUG=1 and attached the output log.

 

Test:

 

 

Executed successfully, PTDEBUG  log attached.

 

 

 

Maulik patel August 23, 2018 at 4:43 AM

Hi Team,

Can you please update me on this issue?

Done

Details

Assignee

Reporter

Priority

Components

Fix versions

Labels

Smart Checklist

Created August 17, 2018 at 1:51 PM
Updated March 4, 2024 at 4:30 PM
Resolved September 20, 2018 at 11:50 AM