pt-online-schema-change gets stuck looking for its own _new table
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Daniel Nichter |
Bug Description
running this command
PTDEBUG=1 pt-online-
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`.
# TableParser:3283 13801 SHOW TABLES FROM `xxxx` LIKE '\_orders\
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `xxxx`.
# TableParser:3283 13801 SHOW TABLES FROM `xxxx` LIKE '\_orders\
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `xxx`.`
# TableParser:3283 13801 SHOW TABLES FROM `xxxx` LIKE '\_orders\
# TableParser:3293 13801 Table does not exist
# TableParser:3279 13801 Checking `xxxx`.
# TableParser:3283 13801 SHOW TABLES FROM `xxxx` LIKE '\_orders\
however the table does exist.
SHOW TABLES FROM `xxxx` LIKE '\_orders\
+------
| Tables_in_xxxx (\_orders\
+------
| _orders_
+------
1 row in set (0.01 sec)
see attached log file pt-osc.log for further details.
Related branches
- Daniel Nichter: Approve
-
Diff: 151 lines (+63/-13)5 files modifiedbin/pt-online-schema-change (+55/-9)
t/pt-online-schema-change/ansi_quotes.t (+1/-1)
t/pt-online-schema-change/basics.t (+3/-1)
t/pt-online-schema-change/charset.t (+2/-2)
t/pt-online-schema-change/samples/stats-execute-5.5.txt (+2/-0)
Changed in percona-toolkit: | |
milestone: | none → 2.2.5 |
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 |
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 |
Changed in percona-toolkit: | |
importance: | Undecided → Medium |
Changed in percona-toolkit: | |
milestone: | 2.2.5 → none |
Changed in percona-toolkit: | |
milestone: | none → 2.2.6 |
Changed in percona-toolkit: | |
importance: | Medium → High |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
Interesting, thanks for the report and log. We'll look into it.