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: | |
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
[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