2013-06-28 08:31:56 |
Elton M. Labajo |
bug |
|
|
added bug |
2013-06-28 08:31:56 |
Elton M. Labajo |
attachment added |
|
pt-osc.log https://bugs.launchpad.net/bugs/1195628/+attachment/3716767/+files/pt-osc.log |
|
2013-06-28 08:32:47 |
Elton M. Labajo |
description |
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. |
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=xxxx,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. |
|
2013-06-28 08:35:53 |
Elton M. Labajo |
description |
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=xxxx,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. |
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=xxxx,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 `xxxx`.`_orders_status_history_new`
# TableParser:3283 13801 SHOW TABLES FROM `xxxx` LIKE '\_orders\_status\_history\_new'
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `xxxx`.`_orders_status_history_new`
# TableParser:3283 13801 SHOW TABLES FROM `xxxx` LIKE '\_orders\_status\_history\_new'
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `xxx`.`_orders_status_history_new`
# TableParser:3283 13801 SHOW TABLES FROM `xxxx` LIKE '\_orders\_status\_history\_new'
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `xxxx`.`_orders_status_history_new`
# TableParser:3283 13801 SHOW TABLES FROM `xxxx` LIKE '\_orders\_status\_history\_new
however the table does exist.
SHOW TABLES FROM `xxxx` LIKE '\_orders\_status\_history\_new';
+-----------------------------------------------------+
| Tables_in_xxxx (\_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. |
|
2013-08-02 18:40:07 |
Daniel Nichter |
tags |
|
pt-online-schema-change |
|
2013-08-02 18:40:29 |
Daniel Nichter |
percona-toolkit: status |
New |
Confirmed |
|
2013-08-02 22:20:25 |
Daniel Nichter |
percona-toolkit: milestone |
|
2.2.5 |
|
2013-08-02 22:28:56 |
Daniel Nichter |
summary |
running pt-online-schema-change gets stuck and the temp file created _table_name_new the size doesn't grow |
pt-online-schema-change gets stuck looking for its own _table_new table |
|
2013-08-02 22:29:05 |
Daniel Nichter |
summary |
pt-online-schema-change gets stuck looking for its own _table_new table |
pt-online-schema-change gets stuck looking for its own _new table |
|
2013-08-02 22:30:42 |
Daniel Nichter |
percona-toolkit: importance |
Undecided |
Medium |
|
2013-09-17 17:43:48 |
Daniel Nichter |
percona-toolkit: milestone |
2.2.5 |
|
|
2013-10-02 04:58:04 |
Jacky Leung |
bug |
|
|
added subscriber Jacky Leung |
2013-10-30 23:57:50 |
Daniel Nichter |
percona-toolkit: milestone |
|
2.2.6 |
|
2013-11-15 17:03:11 |
Daniel Nichter |
percona-toolkit: importance |
Medium |
High |
|
2013-11-26 23:01:34 |
Daniel Nichter |
tags |
pt-online-schema-change |
percona-37252 pt-online-schema-change |
|
2013-11-27 00:21:47 |
Daniel Nichter |
percona-toolkit: assignee |
|
Daniel Nichter (daniel-nichter) |
|
2013-11-27 00:21:50 |
Daniel Nichter |
percona-toolkit: status |
Confirmed |
In Progress |
|
2013-11-27 00:24:25 |
Launchpad Janitor |
branch linked |
|
lp:~percona-toolkit-dev/percona-toolkit/fix-pt-osc-find-new-table-bug-1195628 |
|
2013-12-11 04:48:05 |
Daniel Nichter |
percona-toolkit: status |
In Progress |
Fix Committed |
|
2013-12-20 03:54:18 |
Daniel Nichter |
percona-toolkit: status |
Fix Committed |
Fix Released |
|