Table is not altered with pt-online-schema-change 2.2.10

[Nilnandan Joshi]

We don't able to alter the table with pt-osc 2.2.10 version while its working with 2.2.9. At the end it gives msg "Killed" but not error msg why, it was killed.

mysql> show create table test \G
*************************** 1. row ***************************
       Table: test
Create Table: CREATE TABLE `test` (
  `id` int(11) NOT NULL,
  `fd1` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql>

nilnandan@Dell-XPS:~$ pt-online-schema-change --version
pt-online-schema-change 2.2.10
nilnandan@Dell-XPS:~$
nilnandan@Dell-XPS:~$ pt-online-schema-change --alter "ADD fd2 CHAR(1) NOT NULL DEFAULT 'N'" h=127.0.0.1,u=root,p=root,D=test,t=test --execute
No slaves found. See --recursion-method if host Dell-XPS has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1
Altering `test`.`test`...
Creating new table...
Created new table test._test_new OK.
Altering new table...
2014-08-26T14:02:33 Dropping new table...
2014-08-26T14:02:33 Dropped new table OK.
`test`.`test` was not altered.
Killed
nilnandan@Dell-XPS:~$

nilnandan@Dell-XPS:~$ pt-online-schema-change --version
pt-online-schema-change 2.2.9
nilnandan@Dell-XPS:~$
nilnandan@Dell-XPS:~$ pt-online-schema-change --alter "ADD fd2 CHAR(1) NOT NULL DEFAULT 'N'" h=127.0.0.1,u=root,p=root,D=test,t=test --execute
No slaves found. See --recursion-method if host Dell-XPS has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1
Altering `test`.`test`...
Creating new table...
Created new table test._test_new OK.
Altering new table...
Altered `test`.`_test_new` OK.
2014-08-26T13:54:42 Creating triggers...
2014-08-26T13:54:42 Created triggers OK.
2014-08-26T13:54:42 Copying approximately 5 rows...
2014-08-26T13:54:42 Copied rows OK.
2014-08-26T13:54:42 Swapping tables...
2014-08-26T13:54:43 Swapped original and new tables OK.
2014-08-26T13:54:43 Dropping old table...
2014-08-26T13:54:43 Dropped old table `test`.`_test_old` OK.
2014-08-26T13:54:43 Dropping triggers...
2014-08-26T13:54:43 Dropped triggers OK.
Successfully altered `test`.`test`.
nilnandan@Dell-XPS:~$

[Frank Cizmich (frank-cizmich)]

Hi Joshi,

I'm unable to reproduce this. Works fine for me using 2.2.10

Could you please set PTDEBUG=1 and post the output ?

This was my run:

frank@santi:~/devel/percona/percona-toolkit/release-2.2.10/bin$ ./pt-online-schema-change --version
pt-online-schema-change 2.2.10
frank@santi:~/devel/percona/percona-toolkit/release-2.2.10/bin$ ./pt-online-schema-change --alter "ADD fd2 CHAR(1) NOT NULL DEFAULT 'N'" h=127.0.0.1,u=msandbox,p=msandbox,D=test,t=test --execute
No slaves found. See --recursion-method if host santi has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1
Altering `test`.`test`...
Creating new table...
Created new table test._test_new OK.
Altering new table...
Altered `test`.`_test_new` OK.
2014-08-26T11:34:44 Creating triggers...
2014-08-26T11:34:45 Created triggers OK.
2014-08-26T11:34:45 Copying approximately 5 rows...
2014-08-26T11:34:45 Copied rows OK.
2014-08-26T11:34:45 Swapping tables...
2014-08-26T11:34:45 Swapped original and new tables OK.
2014-08-26T11:34:45 Dropping old table...
2014-08-26T11:34:45 Dropped old table `test`.`_test_old` OK.
2014-08-26T11:34:45 Dropping triggers...
2014-08-26T11:34:45 Dropped triggers OK.
Successfully altered `test`.`test`.

[Nilnandan Joshi (nilnandan-joshi)]

Hi Frank, I couldn't reproduce this error again. I guess, after MySQL restart, it's gone. It doesn't seems bug.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1236