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

5.7 - Few replication MTR tests fail while running with MTS and GTIDS enabled

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.7.x
    • Fix Version/s: None
    • Component/s: None

      Description

      Running the whole `rpl` MTR test suite with MTS and GTID enabled will result in the the below tests to fail.

      The servers were restarted 326 times
      Spent 1493.335 of 397 seconds executing testcases
      
      Too many failed: Failed 8/436 tests, 98.17% were successful.
      
      Failing test(s): rpl.rpl_stm_ignore rpl.rpl_gtids_table rpl.bug58546 
      
      rpl.rpl_foreign_key_innodb rpl.rpl_ssl1 rpl.rpl_init_slave
      
      The log files in var/log may give you some hint of what went wrong.
      
      If you want to report this error, please read first the documentation
      at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
      

      How to reproduce:

      $ ./mtr --suite=rpl --parallel=12 --mem --force --mysqld=--gtid-mode=on --mysqld=--enforce-gtid-consistency=on --mysqld=--log-slave-updates --mysqld=--master-info-repository=TABLE --mysqld=--relay-log-info-repository=TABLE --mysqld=--slave-parallel-workers=4

       

      I checked only on 5.7. But some of these may even fail on 8.0. We need to investigate.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            venkatesh.prasad Venkatesh Prasad
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Smart Checklist