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

Fix rocksdb_read_free_rpl test to properly count rows corresponding to broken index entries

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: 8.0.x
    • Fix Version/s: 8.0.20-11
    • Component/s: None
    • Labels:
      None

      Description

      The rocksdb.rocksdb_read_free_rpl test checks scenarios when secondary key may loose some records or have extra records due to inconsistencies between table on primary and secondary servers when read free replication is used. Currently "select count(column_name) from table_name force index(column_name)" is used for this purpose. In MySQL 8.0 there were changes to count() behavior and now it doesn't take into account rows corresponding to broken index entries. Simple "select column_name from table_name" can be used instead to reveal the issue with broken index entries.

        Attachments

          Activity

            People

            Assignee:
            oleksandr.kachan Oleksandr Kachan
            Reporter:
            oleksandr.kachan Oleksandr Kachan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 2 hours
                2h

                  Smart Checklist