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

innodb.innodb-index-online failed in buildbot

    XMLWordPrintable

    Details

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/10654/steps/mtr_nm/logs/stdio

      innodb.innodb-index-online '16k,crypt,innodb' w1 [ fail ]
              Test ended at 2017-12-05 01:51:57
       
      CURRENT_TEST: innodb.innodb-index-online
      mysqltest: At line 135: query 'UPDATE mysql.innodb_index_stats SET stat_value = 5
      WHERE database_name = 'test' AND table_name= 't1' AND index_name = 'PRIMARY'
      AND stat_value = 6' failed: 1146: Table 'mysql.innodb_index_stats' doesn't exist
       
      The result from queries just before the failure was:
      < snip >
      SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
      name	count
      ddl_background_drop_indexes	0
      ddl_background_drop_tables	0
      ddl_online_create_index	0
      ddl_pending_alter_table	0
      ddl_sort_file_alter_table	0
      ddl_log_file_alter_table	0
      connection default;
      INSERT INTO t1 VALUES(6,3,1);
      ERROR 23000: Duplicate entry '3' for key 'c2'
      INSERT INTO t1 VALUES(7,4,2);
      ERROR 23000: Duplicate entry '4' for key 'c2'
      ALTER TABLE t1 STATS_PERSISTENT=1;
      ANALYZE TABLE t1;
      Table	Op	Msg_type	Msg_text
      test.t1	analyze	status	OK
      UPDATE mysql.innodb_index_stats SET stat_value = 5
      WHERE database_name = 'test' AND table_name= 't1' AND index_name = 'PRIMARY'
      AND stat_value = 6;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: