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

innodb.innodb-index failed in buildbot

    XMLWordPrintable

Details

    Description

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

      innodb.innodb-index 'innodb'             w2 [ fail ]
              Test ended at 2017-09-18 16:17:20
       
      CURRENT_TEST: innodb.innodb-index
      --- /usr/local/mariadb-10.3.2-linux-i686/mysql-test/suite/innodb/r/innodb-index.result	2017-09-18 14:09:46.000000000 +0200
      +++ /usr/local/mariadb-10.3.2-linux-i686/mysql-test/suite/innodb/r/innodb-index.reject	2017-09-18 16:17:19.000000000 +0200
      @@ -1198,6 +1198,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       drop table t1;
       create table t1(f1 int not null, f2 int not null,
      @@ -1211,6 +1213,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       drop table t1;
       create table t480(a serial)engine=innodb;
      @@ -1241,6 +1245,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Change PK from (f1,f2,f3,f4) to (f1,f2,added_columns)
      @@ -1251,6 +1257,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Change PK from (f1,f2,f5,f6) to (f1,f2,f5)
      @@ -1262,6 +1270,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Reusing the same PK
      @@ -1271,6 +1281,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Reusing the same pk
      @@ -1280,6 +1292,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Must sort
       # Change PK from (f1,f2,f5) to (f1,f5)
      @@ -1291,6 +1305,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       ddl_sort_file_alter_table	2
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
      @@ -1302,6 +1318,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Reusing the same pk
      @@ -1312,6 +1330,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Change PK from (f1,f4,f2n) to (f1,f4,added_column,f2n)
      @@ -1322,6 +1342,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       ddl_sort_file_alter_table	2
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
      @@ -1332,6 +1354,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Reusing the same pk
      @@ -1341,6 +1365,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Reusing the same pk
      @@ -1350,6 +1376,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Optimize table
      @@ -1361,6 +1389,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Sort files used for adding secondary index
       alter table t1 drop primary key, add primary key(f1,f5,f7), add index
      @@ -1370,6 +1400,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # No sort files used for dropping secondary index
       alter table t1 drop primary key, add primary key(f1,f5),drop index i;
      @@ -1378,6 +1410,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
       # Change PK(f1,f5) to (f1,added_columns) and drop f5
      @@ -1388,6 +1422,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Must sort
       # Change PK(f1,f12) to (f1,existing_columns)
      @@ -1397,6 +1433,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       ddl_sort_file_alter_table	2
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort
      @@ -1408,6 +1446,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Adding Secondary index alone.
       alter table t1 add key(f1);
      @@ -1416,6 +1456,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Must sort
       # Change PK(f1,f3) to (existing_column,f1)
      @@ -1425,6 +1467,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       ddl_sort_file_alter_table	3
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort for PK.
      @@ -1437,6 +1481,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       # Skip sort for PK.
       # Change PK(f5n,f6n,f4,f1) to
      @@ -1449,6 +1495,8 @@
       SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE
       subsystem = 'ddl' and count_reset > 0;
       name	count_reset
      +ddl_online_create_index	4294967296
      +ddl_pending_alter_table	4294967296
       SET GLOBAL innodb_monitor_reset = module_ddl;
       SET GLOBAL innodb_monitor_disable = module_ddl;
       select count(*) from t1;
       
      mysqltest: Result length mismatch
      

      Attachments

        1. 10.3.txt
          2 kB
        2. 10.2.txt
          2 kB

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.