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

innodb.innodb_stats_create_table and innodb.innodb_stats_drop_locked fail in buildbot on Windows

    Details

      Description

      http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6563/steps/test/logs/stdio

      innodb.innodb_stats_create_table 'innodb_plugin' [ fail ]  Found warnings/errors in server log file!
              Test ended at 2014-11-22 12:50:55
      line
      2014-11-22 12:50:54 52090 InnoDB: Error: Table "mysql"."innodb_index_stats" not found.
      
      2014-11-22 12:50:54 52090 InnoDB: Error: Fetch of persistent statistics requested for table "test"."test_ps_create_on_corrupted" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
      
      ^ Found warnings in C:/bzr/bb-win32/win32-debug2/build/mysql-test/var/log/mysqld.1.err
      ok
      

      http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6568/steps/test/logs/stdio

      innodb.innodb_stats_drop_locked 'innodb_plugin' [ fail ]  Found warnings/errors in server log file!
              Test ended at 2014-11-24 03:28:46
      line
      2014-11-24 03:28:42 d98c InnoDB: Error: Table "mysql"."innodb_index_stats" not found.
      
      2014-11-24 03:28:42 d98c InnoDB: Error: Fetch of persistent statistics requested for table "test"."test_ps_create_on_corrupted" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
      
      ^ Found warnings in C:/bzr/bb-win32/win32-debug2/build/mysql-test/var/log/mysqld.1.err
      ok
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              jplindst Jan Lindström added a comment -

              commit 8ba3585b47ee678de16dd7d4ec063e76fe7b7b1d
              Author: Jan Lindström <jan.lindstrom@skysql.com>
              Date: Mon Nov 24 19:42:39 2014 +0200

              MDEV-7168: Tests innodb.innodb_stats_create_table
              innodb.innodb_stats_drop_locked fail and
              innodb.innodb_stats_fetch_nonexistent fails in buildbot on Windows

              Analysis: Problem is that innodb_stats_create_on_corrupted
              test renames mysql.innodb.index_stats and all the rest
              are dependend on this table.

              Fix: After rename back to original, restart mysqld to
              make sure that table is correct.

              Show
              jplindst Jan Lindström added a comment - commit 8ba3585b47ee678de16dd7d4ec063e76fe7b7b1d Author: Jan Lindström <jan.lindstrom@skysql.com> Date: Mon Nov 24 19:42:39 2014 +0200 MDEV-7168 : Tests innodb.innodb_stats_create_table innodb.innodb_stats_drop_locked fail and innodb.innodb_stats_fetch_nonexistent fails in buildbot on Windows Analysis: Problem is that innodb_stats_create_on_corrupted test renames mysql.innodb.index_stats and all the rest are dependend on this table. Fix: After rename back to original, restart mysqld to make sure that table is correct.

                People

                • Assignee:
                  jplindst Jan Lindström
                  Reporter:
                  elenst Elena Stepanova
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: