Bug #74098 innodb_gis.kill_server missing its result file
Submitted: 26 Sep 2014 8:32 Modified: 9 Aug 2017 10:36
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.7.5, 5.7.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: mtr

[26 Sep 2014 8:32] Laurynas Biveinis
Description:
innodb_gis.kill_server only has a .test file present but not .result.

How to repeat:
mysql-test-run kill_server

Suggested fix:
Commit kill_server.result
[26 Sep 2014 9:57] MySQL Verification Team
Hello Laurynas,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[26 Sep 2014 9:58] MySQL Verification Team
// with 5.7.6

//

ushastry@cluster-repo mysql-test]$ find . -name "kill_server.*"
./suite/innodb_gis/r/kill_server.result
./suite/innodb_gis/t/kill_server.test
[ushastry@cluster-repo mysql-test]$
[ushastry@cluster-repo mysql-test]$ rm -rf ./suite/innodb_gis/r/kill_server.result
[ushastry@cluster-repo mysql-test]$ ./mtr --debug --big-test kill_server
Logging: ./mtr  --debug --big-test kill_server
MySQL Version 5.7.6
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/data/ushastry/server/mysql-advanced-5.7.6/mysql-test/var'...
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
create table t1 (c1 int, c2 geometry not null, spatial index (c2))engine=innodb;
create procedure insert_t1(IN total int)
begin
declare i int default 1;
while (i <= total) DO
insert into t1 values (i, Point(i, i));
set i = i + 1;
end while;
end|
CALL insert_t1(5000);
select count(*) from t1;
count(*)
5000
check table t1;
Table   Op      Msg_type        Msg_text
test.t1 check   status  OK
truncate table t1;
CALL insert_t1(10000);
select count(*) from t1;
count(*)
10000
drop index c2 on t1;
create spatial index idx on t1(c2);
show create table t1;
Table   Create Table
t1      CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` geometry NOT NULL,
  SPATIAL KEY `idx` (`c2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
check table t1;
Table   Op      Msg_type        Msg_text
test.t1 check   status  OK
truncate table t1;
call mtr.add_suppression("InnoDB: page [0-9]+ in the doublewrite buffer is not within space bounds.*");
START TRANSACTION;
CALL insert_t1(5000);
COMMIT;
# Kill and restart
drop procedure insert_t1;
drop table t1;
innodb_gis.kill_server                   [ pass ]  477403
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 477.403 of 500 seconds executing testcases

Completed: All 1 tests were successful.

[ushastry@cluster-repo mysql-test]$ find . -name "kill_server.*"
./suite/innodb_gis/t/kill_server.test
[16 Mar 2015 12:18] Laurynas Biveinis
Fixed in 5.7.6:

$ git show 9186f24 -s
commit 9186f24ceacfafbf5aac4e7080a7092de24b4897
Author: Tor Didriksen <tor.didriksen@oracle.com>
Date:   Fri Sep 5 09:58:08 2014 +0200

    Bug#19514950 CLEAN UP TESTS THAT KILL OR RESTART THE SERVER
    
    Add missing .result file