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

Race condition in ANALYZE TABLE / statistics collection, main.stat_tables_par failed in buildbot with wrong result

    XMLWordPrintable

Details

    • 10.2.12

    Description

      http://buildbot.askmonty.org/buildbot/builders/p8-rhel71-bintar-debug/builds/2017/steps/test/logs/stdio

      Also reproducible locally by running the test with --repeat=N with a big enough N.

      main.stat_tables_par                     w1 [ fail ]
              Test ended at 2017-07-05 14:50:31
       
      CURRENT_TEST: main.stat_tables_par
      --- /home/buildbot/maria-slave/power8-vlp06-bintar-debug/build/mysql-test/r/stat_tables_par.result	2017-07-05 11:32:08.057165801 -0400
      +++ /home/buildbot/maria-slave/power8-vlp06-bintar-debug/build/mysql-test/r/stat_tables_par.reject	2017-07-05 14:50:30.258223458 -0400
      @@ -176,7 +176,6 @@
       dbt3_s001	lineitem	i_l_orderkey_quantity	2	1.0404
       dbt3_s001	lineitem	i_l_partkey	1	30.0250
       dbt3_s001	lineitem	i_l_receiptdate	1	2.6477
      -dbt3_s001	lineitem	i_l_shipdate	1	2.6500
       dbt3_s001	lineitem	i_l_suppkey	1	600.5000
       dbt3_s001	lineitem	i_l_suppkey_partkey	1	30.0250
       dbt3_s001	lineitem	i_l_suppkey_partkey	2	8.5786
      @@ -191,7 +190,6 @@
       dbt3_s001	lineitem	i_l_orderkey_quantity	2	1.0404
       dbt3_s001	lineitem	i_l_partkey	1	30.0250
       dbt3_s001	lineitem	i_l_receiptdate	1	2.6477
      -dbt3_s001	lineitem	i_l_shipdate	1	2.6500
       dbt3_s001	lineitem	i_l_suppkey	1	600.5000
       dbt3_s001	lineitem	i_l_suppkey_partkey	1	30.0250
       dbt3_s001	lineitem	i_l_suppkey_partkey	2	8.5786
       
      mysqltest: Result length mismatch
      

      First recorded occurrences in buildbot are of August 2016.

      Not reproducible on 10.1.

      Attachments

        1. mdev13266.result
          1 kB
          Elena Stepanova
        2. mdev13266.test
          1 kB
          Elena Stepanova

        Issue Links

          Activity

            People

              varun Varun Gupta (Inactive)
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.