LP #1009286: t/pt-table-checksum/basics.t fails on MySQL 5.5 and CentOS 5.5

Description

**Reported in Launchpad by Baron Schwartz last update 21-06-2012 19:50:18

This fails 100% reliably on MySQL 5.5 and CentOS 5.5.

[baron@localhost stabilize-test-suite]$ perl t/pt-table-checksum/basics.t
1..36

  1. 3c3

  2. < 0 0 0 0 mysql.db

  3. > 0 0 1 0 mysql.db

  4. 23,24c23

  5. < 0 0 2 0 mysql.user

  6. < 0 0 40 0 percona_test.checksums

  7. > 0 0 3 0 mysql.user
    not ok 1 - Default checksum

  8. Failed test 'Default checksum'

  9. in t/pt-table-checksum/basics.t at line 81.
    ok 2 - At least 37 checksums

  10. 3c3

  11. < 0 0 0 1 0 mysql.db

  12. > 0 0 1 1 0 mysql.db

  13. 23,24c23

  14. < 0 0 2 1 0 mysql.user

  15. < 0 0 40 1 0 percona_test.checksums

  16. > 0 0 3 1 0 mysql.user
    not ok 3 - Static chunk size (--chunk-time 0)

  17. Failed test 'Static chunk size (--chunk-time 0)'

  18. in t/pt-table-checksum/basics.t at line 106.
    ok 4 - 86 checksums on master
    ok 5 - 86 checksums on slave
    ok 6 - --replicate-check on by default, detects diff
    ok 7 - --no-replicate-check, no diff detected

  19. KILL 816 /* db: sakila */

  20. Error executing KILL 816 /* db: sakila */ in Sandbox::wipe_clean(): DBD::mysql::db do failed: Unknown thread id: 816 at /home/baron/stabilize-test-suite//lib/Sandbox.pm line 175.
    ok 8 - --emptry-replicate-table on by default
    ok 9 - --no-recheck (just --replicate-check)
    ok 10 - Detects infinite loop
    ok 11 - Upper boundary same as next lower boundary
    ok 12 - Skipped oversize chunks
    ok 13 - Oversize chunks are not errors
    ok 14 - Warns about skipping large slave table
    ok 15 - Does not checksum large slave table on master
    ok 16 - Does not checksum large slave table on slave
    ok 17 - Non-zero exit status
    ok 18 - 0 skipped
    ok 19 - 0 errors
    ok 20 - 52 rows checksummed
    ok 21 - No host in DSN, zero exit status
    ok 22 - No host in DSN, 0 errors
    ok 23 - --where in checksum chunk query
    ok 24 - --where in past lower chunk query
    ok 25 - --where in past upper chunk query
    ok 26 - --where in next chunk boundary query
    ok 27 - --where for first chunk
    ok 28 - --where for last chunk
    ok 29 - --where for lower oob chunk
    ok 30 - --where for upper oob chunk
    ok 31 - Bug 932442: 0 exit
    ok 32 - Bug 932442: 0 errors
    ok 33 - Bug 821675 (dot): queries
    ok 34 - Bug 821675 (dot): 0 exit
    ok 35 - Bug 821675 (dot): 0 errors
    ok 36 - Sandbox servers

  21. Looks like you failed 2 tests of 36.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 6:41 PM

**Comment from Launchpad by: Baron Schwartz on: 21-06-2012 19:50:13

This should be fixed now.

Done

Details

Assignee

Reporter

Priority

Smart Checklist

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