Bug #54024 mysqlslap fails sporadically starting from Dahlia

• Submitted: 27 May 2010 10:00
• Modified: 22 Dec 2017 8:43
• Reporter: Alexander Nozdrin
• Status: Can't repeat
• Category: Tools: Pushbuild
• Severity: S3 (Non-critical)
• Version: Dahlia (M4)
• OS: Windows
• CPU Architecture: Any
• Tags: experimental, pb2, sporadic, test failure

[27 May 2010 10:00] Alexander Nozdrin

Description:
--- H:/pb2/test/sb_2-1823158-1274195441.19/mysql-5.6.99-m4-win-x86_64-test/mysql-test/r/mysqlslap.result	2010-05-18 13:14:37.000000000 +0300
+++ H:\pb2\test\sb_2-1823158-1274195441.19\mysql-5.6.99-m4-win-x86_64-test\mysql-test\r\mysqlslap.reject	2010-05-18 18:28:06.988319500 +0300
@@ -149,32 +149,6 @@
 create table t2(foo1 varchar(32), foo2 varchar(32));
 INSERT INTO t1 VALUES (1, 'This is a test');
 insert into t2 values ('test', 'test2');
-SHOW TABLES;
-select * from t1;
-select * from t2;
-SHOW TABLES;
-DROP SCHEMA IF EXISTS `mysqlslap`;
-DROP SCHEMA IF EXISTS `mysqlslap`;
-CREATE SCHEMA `mysqlslap`;
-use mysqlslap;
-set storage_engine=`myisam`;
-CREATE TABLE t1 (id int, name varchar(64));
-create table t2(foo1 varchar(32), foo2 varchar(32));
-INSERT INTO t1 VALUES (1, 'This is a test');
-insert into t2 values ('test', 'test2');
-SHOW TABLES;
-select * from t1;
-select * from t2;
-SHOW TABLES;
-DROP SCHEMA IF EXISTS `mysqlslap`;
-DROP SCHEMA IF EXISTS `mysqlslap`;
-CREATE SCHEMA `mysqlslap`;
-use mysqlslap;
-set storage_engine=`heap`;
-CREATE TABLE t1 (id int, name varchar(64));
-create table t2(foo1 varchar(32), foo2 varchar(32));
-INSERT INTO t1 VALUES (1, 'This is a test');
-insert into t2 values ('test', 'test2');
 SET AUTOCOMMIT=0;
 SHOW TABLES;
 SET AUTOCOMMIT=0;

mysqltest: Result content mismatch

How to repeat:
http://tinyurl.com/33acwhb

[1 Jun 2010 5:46] Sveta Smirnova

Thank you for the report.

Verified using PB link.

main.mysqlslap                           [ fail ]
        Test ended at 2010-04-03 14:32:55

CURRENT_TEST: main.mysqlslap
'diff' is not recognized as an internal or external command,
operable program or batch file.
--- H:/pb2/test/sb_2-1627707-1270296764.04/mysql-5.6.99-m4-win-x86_64-test/mysql-test/r/mysqlslap.result	2010-03-29 15:04:02.000000000 +0300
+++ H:\pb2\test\sb_2-1627707-1270296764.04\mysql-5.6.99-m4-win-x86_64-test\mysql-test\r\mysqlslap.reject	2010-04-03 15:32:54.729668300 +0300
@@ -167,58 +167,6 @@
 select * from t2;
 SHOW TABLES;
 DROP SCHEMA IF EXISTS `mysqlsla
...

[10 Aug 2010 9:02] Alexander Nozdrin

Making the test case experimental due to this bug.