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

Test innodb.percona_log_slow_innodb is unstable

Details

    Description

      On 8.0, due to data dictoniary reads:

      190423  2:30:20 [ 98%] innodb.percona_log_slow_innodb           w5  [ fail ]
              Test ended at 2019-04-23 02:30:20
      
      CURRENT_TEST: innodb.percona_log_slow_innodb
      --- /tmp/results/PS/mysql-test/suite/innodb/r/percona_log_slow_innodb.result	2019-04-23 02:54:14.000000000 +0300
      +++ /tmp/results/PS/mysql-test/var/5/log/percona_log_slow_innodb.reject	2019-04-23 05:30:20.135805245 +0300
      @@ -106,9 +106,9 @@
       [log_grep.inc] file: percona.slow_extended.innodb_3 pattern: ^# Filesort: (Yes|No)  Filesort_on_disk: (Yes|No)  Merge_passes: \d+$
       [log_grep.inc] lines:   0
       [log_grep.inc] file: percona.slow_extended.innodb_3 pattern: ^#   InnoDB_IO_r_ops: 0  InnoDB_IO_r_bytes: 0  InnoDB_IO_r_wait: 0\.0*$
      -[log_grep.inc] lines:   1
      -[log_grep.inc] file: percona.slow_extended.innodb_3 pattern: ^#   InnoDB_IO_r_ops: [1-9]\d*  InnoDB_IO_r_bytes: [1-9]\d*  InnoDB_IO_r_wait: (0\.\d*[1-9]\d*|[1-9]\d*\.\d+)$
       [log_grep.inc] lines:   0
      +[log_grep.inc] file: percona.slow_extended.innodb_3 pattern: ^#   InnoDB_IO_r_ops: [1-9]\d*  InnoDB_IO_r_bytes: [1-9]\d*  InnoDB_IO_r_wait: (0\.\d*[1-9]\d*|[1-9]\d*\.\d+)$
      +[log_grep.inc] lines:   1
       [log_grep.inc] file: percona.slow_extended.innodb_3 pattern: ^#   InnoDB_rec_lock_wait: \d*\.\d*  InnoDB_queue_wait: \d*\.\d*$
       [log_grep.inc] lines:   1
       [log_grep.inc] file: percona.slow_extended.innodb_3 pattern: InnoDB_rec_lock_wait: 0\.0*
      
      mysqltest: Result content mismatch
      

      Attachments

        Activity

          People

            laurynas.biveinis Laurynas Biveinis (Inactive)
            laurynas.biveinis Laurynas Biveinis (Inactive)
            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, 8 minutes
                2h 8m

                Smart Checklist