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.
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 .`_orders_ status_ history_ new` _status\ _history\ _new' .`_orders_ status_ history_ new` _status\ _history\ _new' .`_orders_ status_ history_ new` _status\ _history\ _new' .`_orders_ status_ history_ new` _status\ _history\ _new
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `ereplace`
# TableParser:3283 13801 SHOW TABLES FROM `ereplace` LIKE '\_orders\
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `ereplace`
# TableParser:3283 13801 SHOW TABLES FROM `ereplace` LIKE '\_orders\
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `ereplace`
# TableParser:3283 13801 SHOW TABLES FROM `ereplace` LIKE '\_orders\
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `ereplace`
# TableParser:3283 13801 SHOW TABLES FROM `ereplace` LIKE '\_orders\
however the table does exist.
SHOW TABLES FROM `ereplace` LIKE '\_orders\ _status\ _history\ _new'; ------- ------- ------- ------- ------- ------- -----+ _status\ _history\ _new) | ------- ------- ------- ------- ------- ------- -----+ status_ history_ new | ------- ------- ------- ------- ------- ------- -----+
+------
| Tables_in_ereplace (\_orders\
+------
| _orders_
+------
1 row in set (0.01 sec)
see attached log file pt-osc.log for further details.