Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7359

Stabilize innodb.check_ibd_filesize_16k MTR test

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.21-12
    • Fix Version/s: 8.0.21-12
    • Component/s: None
    • Labels:
      None
    • Needs Review:
      Yes

      Description

      innodb.check_ibd_filesize_16k MTR test is unstable. When ran multiple times it fails with

       The size of file 'test/t3.ibd' is 7168 bytes.
       Rows inserted: 8
      -The size of file 'test/t3.ibd' is 14336 bytes.
      +The size of file 'test/t3.ibd' is 15360 bytes.
       Rows inserted: 16
      -The size of file 'test/t3.ibd' is 22528 bytes.
      +The size of file 'test/t3.ibd' is 23552 bytes.
       Rows inserted: 24
      -The size of file 'test/t3.ibd' is 30720 bytes.
      +The size of file 'test/t3.ibd' is 31744 bytes.
       Rows inserted: 32
       The size of file 'test/t3.ibd' is 5242880 bytes.
       Rows inserted: 40mysqltest: Result content mismatch
       

      The easiest way to reproduce is to run several instances of the test in parallel like 

      ./mysql-test/mtr --mem innodb.check_ibd_filesize_16k{,,,,} --parallel=4 --repeat=20 

      However single thread execution fails as well if ran long enough.

       

        Attachments

          Activity

            People

            Assignee:
            kamil.holubicki Kamil Holubicki
            Reporter:
            kamil.holubicki Kamil Holubicki
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 6 hours, 38 minutes Original Estimate - 6 hours, 38 minutes
                6h 38m
                Remaining:
                Time Spent - 2 days, 1 hour, 19 minutes Remaining Estimate - 44 minutes
                44m
                Logged:
                Time Spent - 2 days, 1 hour, 19 minutes Remaining Estimate - 44 minutes
                2d 1h 19m

                  Smart Checklist