pt-onine-schema-change is pausing because {some_status_variable}=0
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Committed
|
Medium
|
Carlos Salguero |
Bug Description
Although 0 is normal value for global variable {some_status_
Doc for --max-load say that pt-online-
So, how use --max-load with variables that can take zero value in normal state of db?
I think that trouble in this line of code:
https:/
pt-online-
pt-online-
Console command:
pt-online-
Output:
No slaves found. See --recursion-method if host dcc369b9be1d 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_
Not updating foreign keys because --alter-
Altering `test`.`test`...
Creating new table...
Created new table test._test_new OK.
Altering new table...
Altered `test`.`_test_new` OK.
2016-08-31T17:09:45 Creating triggers...
2016-08-31T17:09:45 Created triggers OK.
2016-08-31T17:09:45 Copying approximately 1 rows...
Pausing because wsrep_flow_
^C# Exiting on SIGINT.
Not dropping triggers because the tool was interrupted. To drop the triggers, execute:
DROP TRIGGER IF EXISTS `test`.
DROP TRIGGER IF EXISTS `test`.
DROP TRIGGER IF EXISTS `test`.
Not dropping the new table `test`.`_test_new` because the tool was interrupted. To drop the new table, execute:
DROP TABLE IF EXISTS `test`.`_test_new`;
# Event Count
# ====== =====
# INSERT 1
`test`.`test` was not altered.
Debug output is attached.
no longer affects: | centos |
Changed in percona-toolkit: | |
status: | Confirmed → In Progress |
importance: | Undecided → Medium |
assignee: | nobody → Carlos Salguero (carlos-salguero) |
milestone: | none → 3.0.5 |
tags: | added: pt196 |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Thank you for the report.
Verified as described.
sveta@Thinkie: ~/build/ ps-5.7/ mysql-test$ mysqlmtr test -P13001
...
mysql> create table test(id int not null auto_increment primary key, test int);
Query OK, 0 rows affected (0.40 sec)
mysql> insert into test (test) values(1),(2),(3);
Query OK, 3 rows affected (0.12 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> \q
Bye
sveta@Thinkie: ~/build/ ps-5.7/ mysql-test$ ~/build/ percona- toolkit/ bin/pt- online- schema- change --alter 'drop column test' h=127.0. 0.1,P=13001, u=root, D=test, t=test --max-load THREADPOOL_ IDLE_THREADS= 1 --execute foreign_ keys, 10, 1 IDLE_THREADS= 0. IDLE_THREADS= 0.
No slaves found. See --recursion-method if host Thinkie 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_
Altering `test`.`test`...
Creating new table...
Created new table test._test_new OK.
Altering new table...
Altered `test`.`_test_new` OK.
2016-12-13T15:52:17 Creating triggers...
2016-12-13T15:52:17 Created triggers OK.
2016-12-13T15:52:17 Copying approximately 3 rows...
Pausing because THREADPOOL_
Pausing because THREADPOOL_