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

main.information_schema_stats fails sporadically in buildbot

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0, 10.1
    • Fix Version/s: 10.1.17, 10.0.27
    • Component/s: Tests
    • Labels:
      None

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/5589/steps/test_7/logs/stdio

      CURRENT_TEST: main.information_schema_stats
      --- /mnt/buildbot/build/mariadb-10.0.27/mysql-test/r/information_schema_stats.result	2016-07-18 11:08:49.000000000 +0300
      +++ /mnt/buildbot/build/mariadb-10.0.27/mysql-test/r/information_schema_stats.reject	2016-07-18 18:46:56.000000000 +0300
      @@ -16,8 +16,8 @@
       2
       select * from information_schema.index_statistics where table_schema='test' and table_name='just_a_test';
       TABLE_SCHEMA	TABLE_NAME	INDEX_NAME	ROWS_READ
      -test	just_a_test	IND_just_a_test_state	2
       test	just_a_test	IND_just_a_test_first_name_last_name	1
      +test	just_a_test	IND_just_a_test_state	2
       select * from information_schema.table_statistics where table_schema='test' and table_name='just_a_test';
       TABLE_SCHEMA	TABLE_NAME	ROWS_READ	ROWS_CHANGED	ROWS_CHANGED_X_INDEXES
       test	just_a_test	18	5	5
      @@ -57,8 +57,8 @@
       select * from information_schema.index_statistics where table_schema='test' and table_name='just_a_test';
       TABLE_SCHEMA	TABLE_NAME	INDEX_NAME	ROWS_READ
       test	just_a_test	first_name	1
      -test	just_a_test	state	2
       test	just_a_test	PRIMARY	5
      +test	just_a_test	state	2
       select * from information_schema.table_statistics where table_schema='test' and table_name='just_a_test';
       TABLE_SCHEMA	TABLE_NAME	ROWS_READ	ROWS_CHANGED	ROWS_CHANGED_X_INDEXES
       test	just_a_test	8	5	15
      

      Result sets need to be sorted

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                elenst Elena Stepanova
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: