Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #1001303: pt-table-checksum basic.t failures

Description

**Reported in Launchpad by Daniel Nichter last update 13-10-2012 17:02:40

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.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 6:38 PM

**Comment from Launchpad by: Daniel Nichter on: 13-10-2012 17:02:35

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

lpjirasync January 24, 2018 at 6:38 PM

**Comment from Launchpad by: Daniel Nichter on: 03-10-2012 15:56:59

not ok 10 - Detects infinite loop

  1. Failed test 'Detects infinite loop'

  2. at t/pt-table-checksum/basics.t line 222.

  3. '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.

  4. '

  5. 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)

  6. Failed test 'Skipped 1 chunk (bug 1011738)'

  7. at t/pt-table-checksum/basics.t line 272.

  8. got: '0'

  9. expected: '1'

  10. 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.

Done

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 6:38 PM
Updated January 24, 2018 at 6:38 PM
Resolved January 24, 2018 at 6:38 PM