[MDEV-7168] innodb.innodb_stats_create_table and innodb.innodb_stats_drop_locked fail in buildbot on Windows Created: 2014-11-23  Updated: 2014-11-24  Resolved: 2014-11-24

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB, Tests
Affects Version/s: 10.0, 10.1
Fix Version/s: 10.0.16, 10.1.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: buildbot, tests

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled
blocks MDEV-7172 Fix buildbot failures in 10.1 tree Closed

 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



 Comments   
Comment by Jan Lindström (Inactive) [ 2014-11-24 ]

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.

Generated at Thu Feb 08 07:17:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.