pt-table-checksum basic.t failures

Bug #1001303 reported by Daniel Nichter
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
Undecided
Daniel Nichter

Bug Description

3c3
< 0 0 0 0 mysql.db
---
> 0 0 3 0 mysql.db
6,9c6,9
< 0 0 38 0 mysql.help_category
< 0 0 453 0 mysql.help_keyword
< 0 0 992 0 mysql.help_relation
< 0 0 220 0 mysql.help_topic
---
> 0 0 37 0 mysql.help_category
> 0 0 310 0 mysql.help_keyword
> 0 0 988 0 mysql.help_relation
> 0 0 489 0 mysql.help_topic
15d14
< 0 0 2 0 mysql.proxies_priv
not ok 1 - Default checksum

This is due to row count differences in 5.1 vs. 5.5. Also, the 5.1 sandbox data has useless rows in mysql.db, maybe other tables, too. I need to rewrite pt-table-checksum basics.t to avoid these idiosyncrasies.

tags: added: pt-table-checksum
removed: pt-table-chekcsum
Changed in percona-toolkit:
assignee: nobody → Daniel Nichter (daniel-nichter)
Brian Fraser (fraserbn)
Changed in percona-toolkit:
status: Confirmed → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released
Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

not ok 10 - Detects infinite loop
# Failed test 'Detects infinite loop'
# at t/pt-table-checksum/basics.t line 222.
# '10-03T09:55:21 Skipping chunk 1 of osc.t because it is oversized. The current chunk size limit is 20 rows (chunk size=10 * chunk size limit=2.0), but MySQL estimates that there are 20 rows in the chunk.
# '
# doesn't match '(?-xism:infinite loop detected)'
ok 11 - Upper boundary same as next lower boundary
ok 12 - Skipped oversize chunks
ok 13 - Oversize chunks are not errors
ok 14 - Skipped chunk 2
not ok 15 - Skipped 1 chunk (bug 1011738)
# Failed test 'Skipped 1 chunk (bug 1011738)'
# at t/pt-table-checksum/basics.t line 272.
# got: '0'
# expected: '1'
# 10-03T09:55:21 Skipping chunk 2 of osc.t because it is oversized. The current chunk size limit is 6 rows (chunk size=6 * chunk size limit=1), but MySQL estimates that there are 14 rows in the chunk.

Changed in percona-toolkit:
status: Fix Released → In Progress
Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

Was fixed again. A rouge local $EVAL_ERROR was suppressing the warnings the tests were wanting.

Changed in percona-toolkit:
status: In Progress → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-976

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.