pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Daniel Nichter | ||
2.1 |
Fix Released
|
High
|
Daniel Nichter | ||
2.2 |
Fix Released
|
High
|
Daniel Nichter |
Bug Description
Seems related to https:/
# pt-table-checksum --version
pt-table-checksum 2.1.9
# PTDEBUG=1 pt-table-checksum --tables nwmls.propertie
<snip output>
# SchemaIterator:6888 7610 Next database: ftmyers_far
# SchemaIterator:6894 7610 SHOW /*!50002 FULL*/ TABLES FROM `ftmyers_far`
# SchemaIterator:7014 7610 Table city_codes is not in --tables list, ignoring
# SchemaIterator:6905 7610 Found 0 tables in database ftmyers_far
# SchemaIterator:6933 7610 No more tables in database ftmyers_far
# SchemaIterator:6872 7610 Getting next schema object from dbh DBI::db=
# SchemaIterator:6888 7610 Next database: fwamls
# SchemaIterator:6894 7610 SHOW /*!50002 FULL*/ TABLES FROM `fwamls`
# SchemaIterator:7014 7610 Table sold_property_mult is not in --tables list, ignoring
# SchemaIterator:7014 7610 Table sold_property_parr is not in --tables list, ignoring
# SchemaIterator:7014 7610 Table sold_property_resi is not in --tables list, ignoring
# SchemaIterator:7014 7610 Table sold_property_resr is not in --tables list, ignoring
# SchemaIterator:7014 7610 Table virtual_media is not in --tables list, ignoring
# SchemaIterator:6905 7610 Found 0 tables in database fwamls
# SchemaIterator:6933 7610 No more tables in database fwamls
Deep recursion on subroutine "SchemaIterator
# Cxn:3349 7610 Disconnecting dbh DBI::db=
# Cxn:3349 7610 Disconnecting dbh DBI::db=
# Cxn:3349 7610 Disconnecting dbh DBI::db=
Related branches
- Daniel Nichter: Approve
-
Diff: 854 lines (+510/-268)8 files modifiedbin/pt-duplicate-key-checker (+57/-52)
bin/pt-index-usage (+57/-52)
bin/pt-table-checksum (+57/-52)
bin/pt-table-sync (+57/-52)
lib/SchemaIterator.pm (+61/-58)
t/lib/SchemaIterator.t (+16/-2)
t/lib/samples/100-dbs-drop.sql (+100/-0)
t/lib/samples/100-dbs.sql (+105/-0)
- Daniel Nichter: Approve
-
Diff: 854 lines (+510/-268)8 files modifiedbin/pt-duplicate-key-checker (+57/-52)
bin/pt-index-usage (+57/-52)
bin/pt-table-checksum (+57/-52)
bin/pt-table-sync (+57/-52)
lib/SchemaIterator.pm (+61/-58)
t/lib/SchemaIterator.t (+16/-2)
t/lib/samples/100-dbs-drop.sql (+100/-0)
t/lib/samples/100-dbs.sql (+105/-0)
Changed in percona-toolkit: | |
status: | Incomplete → Confirmed |
Changed in percona-toolkit: | |
assignee: | nobody → Brian Fraser (fraserbn) |
Changed in percona-toolkit: | |
status: | Confirmed → In Progress |
Changed in percona-toolkit: | |
assignee: | Brian Fraser (fraserbn) → nobody |
Changed in percona-toolkit: | |
status: | In Progress → Triaged |
Changed in percona-toolkit: | |
importance: | Undecided → High |
Steven, can you create a test case to reproduce this? I.e., dump some dbs and tables that would cause this to happen on any system? As in bug 1003323, we'll need some way to reproduce this issue because it seems pretty rare and it has never happened in testing.