Uploaded image for project: 'Percona Server'
  1. Percona Server
  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
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                laurynas.biveinis Laurynas Biveinis (Inactive)
                Reporter:
                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