pt-osc unclean abort on critical load
Bug #1298348 reported by
Rares Mirica
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
Running pt-osc with --critical-load triggers an unclean exit upon hitting the critical condition, output attached.
Note: pt-osc does the right thing and leaves the DB in a consistent state (dropping triggers and the new table) BUT it confuses any tool that tries to parse it's output, even human eyes...
tags: | added: pt-online-schema-change |
To post a comment you must log in.
Have tried to verify with latest version but getting different result. Can you provide the exact version of pt-osc and MySQL /Percona server ?
nilnandan@ nilnandan- Dell-XPS: ~$ pt-online- schema- change --version schema- change 2.2.10 nilnandan- Dell-XPS: ~$ pt-online- schema- change --alter "add column name2 varchar(16)" h=127.0. 0.1,u=root, p=root, D=nil,t= test --critical-load Threads_running=1 --execute foreign_ keys, 10, 1 nilnandan- Dell-XPS: ~$
pt-online-
nilnandan@
No slaves found. See --recursion-method if host nilnandan-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_
Altering `nil`.`test`...
Creating new table...
Created new table nil._test_new OK.
Altering new table...
Altered `nil`.`_test_new` OK.
2014-08-26T10:58:15 Dropping new table...
2014-08-26T10:58:15 Dropped new table OK.
`nil`.`test` was not altered.
Killed
nilnandan@