Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7558

analyze_stmt_slow_query_log fails sporadically in buildbot

Details

    Description

      It used to fail (MDEV-7229), then it was fixed, now it failed again.

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-x86/builds/1759/steps/test/logs/stdio

      main.analyze_stmt_slow_query_log         w4 [ fail ]
              Test ended at 2015-02-07 14:36:17
       
      CURRENT_TEST: main.analyze_stmt_slow_query_log
      --- /usr/local/mariadb-10.1.3-linux-i686/mysql-test/r/analyze_stmt_slow_query_log.result	2015-02-07 10:52:43.000000000 +0200
      +++ /usr/local/mariadb-10.1.3-linux-i686/mysql-test/r/analyze_stmt_slow_query_log.reject	2015-02-07 14:36:17.046996198 +0200
      @@ -11,5 +11,3 @@
       # explain: 1	INSERT	t1	ALL	NULL	NULL	NULL	NULL	NULL	NULL	100.00	100.00	NULL
       # explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
       # explain: 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	10	10	100.00	30.00	Using where
      -# explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
      -# explain: 1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
       

      Attachments

        Issue Links

          Activity

            Relatively fresh log (July 2016)
            http://buildbot.askmonty.org/buildbot/builders/p8-xenial-bintar/builds/38/steps/test/logs/stdio

            main.analyze_stmt_slow_query_log         w4 [ fail ]
                    Test ended at 2016-07-03 05:30:08
             
            CURRENT_TEST: main.analyze_stmt_slow_query_log
            --- /var/lib/buildbot/maria-slave/p8-xenial-bintar/build/mysql-test/r/analyze_stmt_slow_query_log.result	2016-06-30 18:39:27.560815885 -0400
            +++ /var/lib/buildbot/maria-slave/p8-xenial-bintar/build/mysql-test/r/analyze_stmt_slow_query_log.reject	2016-07-03 05:30:08.609194008 -0400
            @@ -11,5 +11,3 @@
             # explain: 1	INSERT	t1	ALL	NULL	NULL	NULL	NULL	NULL	NULL	100.00	100.00	NULL
             # explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
             # explain: 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	10	10.00	100.00	30.00	Using where
            -# explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
            -# explain: 1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
             
            mysqltest: Result length mismatch
            

            elenst Elena Stepanova added a comment - Relatively fresh log (July 2016) http://buildbot.askmonty.org/buildbot/builders/p8-xenial-bintar/builds/38/steps/test/logs/stdio main.analyze_stmt_slow_query_log w4 [ fail ] Test ended at 2016-07-03 05:30:08   CURRENT_TEST: main.analyze_stmt_slow_query_log --- /var/lib/buildbot/maria-slave/p8-xenial-bintar/build/mysql-test/r/analyze_stmt_slow_query_log.result 2016-06-30 18:39:27.560815885 -0400 +++ /var/lib/buildbot/maria-slave/p8-xenial-bintar/build/mysql-test/r/analyze_stmt_slow_query_log.reject 2016-07-03 05:30:08.609194008 -0400 @@ -11,5 +11,3 @@ # explain: 1 INSERT t1 ALL NULL NULL NULL NULL NULL NULL 100.00 100.00 NULL # explain: id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra # explain: 1 SIMPLE t1 ALL NULL NULL NULL NULL 10 10.00 100.00 30.00 Using where -# explain: id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra -# explain: 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL No tables used   mysqltest: Result length mismatch

            The reason was that the test was reusing the same log file without deleting it between tests.
            Fixed by creating a new log file as part of the test

            monty Michael Widenius added a comment - The reason was that the test was reusing the same log file without deleting it between tests. Fixed by creating a new log file as part of the test

            Pushed into 10.1

            monty Michael Widenius added a comment - Pushed into 10.1

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.