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

LP #1677190: Test main.percona_log_slow_verbosity is unstable

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 29-03-2017 10:16:59

      On 5.6 trunk:

      main.percona_log_slow_verbosity w3 [ fail ]
      Test ended at 2017-03-28 13:51:12

      CURRENT_TEST: main.percona_log_slow_verbosity
      — /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/ubuntu-yakkety-64bit/mysql-test/r/percona_log_slow_verbosity.result 2017-03-28 15:10:16.498034605 +0300
      +++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/ubuntu-yakkety-64bit/build/mysql-test/var/3/log/percona_log_slow_verbosity.reject 2017-03-28 16:51:12.679707065 +0300
      @@ -40,19 +40,19 @@
      [log_stop.inc] percona.slow_extended.log_slow_verbosity_1
      log_slow_verbosity='microtime,innodb,query_plan':
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Schema: .+ Last_errno: \d+ Killed: \d+$
      -[log_grep.inc] lines: 2
      +[log_grep.inc] lines: 1
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^#.*Rows_affected: \d+$
      -[log_grep.inc] lines: 2
      +[log_grep.inc] lines: 1
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Bytes_sent: \d+.*$
      -[log_grep.inc] lines: 2
      +[log_grep.inc] lines: 1
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# InnoDB_trx_id: \w+$
      [log_grep.inc] lines: 0
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Bytes_sent: \d+ Tmp_tables: \d+ Tmp_disk_tables: \d+ Tmp_table_sizes: \d+$
      -[log_grep.inc] lines: 2
      +[log_grep.inc] lines: 1
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# QC_Hit: (Yes|No) Full_scan: (Yes|No) Full_join: (Yes|No) Tmp_table: (Yes|No) Tmp_table_on_disk: (Yes|No)$
      -[log_grep.inc] lines: 2
      +[log_grep.inc] lines: 1
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Filesort: (Yes|No) Filesort_on_disk: (Yes|No) Merge_passes: \d+$
      -[log_grep.inc] lines: 2
      +[log_grep.inc] lines: 1
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# InnoDB_IO_r_ops: \d+ InnoDB_IO_r_bytes: \d+ InnoDB_IO_r_wait: \d*\.\d*$
      [log_grep.inc] lines: 0
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# InnoDB_rec_lock_wait: \d*\.\d* InnoDB_queue_wait: \d*\.\d*$
      @@ -60,7 +60,7 @@
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# InnoDB_pages_distinct: \d+$
      [log_grep.inc] lines: 0
      [log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# No InnoDB statistics available for this query$
      -[log_grep.inc] lines: 2
      +[log_grep.inc] lines: 1
      SET log_slow_verbosity='microtime';
      [log_start.inc] percona.slow_extended.log_slow_verbosity_2
      INSERT INTO t1 VALUE(1);

      mysqltest: Result content mismatch

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                laurynas.biveinis Laurynas Biveinis
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: