Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #1195628
  2. Comment #0

Comment 0 for bug 1195628

Revision history for this message
Elton M. Labajo (elton-labajo) wrote : running pt-online-schema-change gets stuck and the temp file created _table_name_new the size doesn't grow

running this command

PTDEBUG=1 pt-online-schema-change --max-load Threads_running=100 --critical-load Threads_running=450 --nocheck-replication-filters --execute --alter 'engine=innodb' t=orders_status_history,D=ereplace,h=x.x.x.x > pt-osc.log 2>&1

get's stuck and checking the debug file shows these logs.

 tail -f pt-osc.log
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `ereplace`.`_orders_status_history_new`
# TableParser:3283 13801 SHOW TABLES FROM `ereplace` LIKE '\_orders\_status\_history\_new'
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `ereplace`.`_orders_status_history_new`
# TableParser:3283 13801 SHOW TABLES FROM `ereplace` LIKE '\_orders\_status\_history\_new'
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `ereplace`.`_orders_status_history_new`
# TableParser:3283 13801 SHOW TABLES FROM `ereplace` LIKE '\_orders\_status\_history\_new'
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `ereplace`.`_orders_status_history_new`
# TableParser:3283 13801 SHOW TABLES FROM `ereplace` LIKE '\_orders\_status\_history\_new

however the table does exist.

 SHOW TABLES FROM `ereplace` LIKE '\_orders\_status\_history\_new';
+-----------------------------------------------------+
| Tables_in_ereplace (\_orders\_status\_history\_new) |
 +-----------------------------------------------------+
| _orders_status_history_new |
 +-----------------------------------------------------+
1 row in set (0.01 sec)

see attached log file pt-osc.log for further details.