Description:
main.analyze fails intermittently on Pushbuild with an error code indicating a crash, on a variety of platforms (Windows, Unix, Linux).
For example (2008-09-05, bzr_mysql-6.0-falcon-team):
main.analyze [ fail ]
ERROR: mysqltest returned unexpected code 3, it has probably crashed
Stopping All Servers
Restoring snapshot of databases
---
Example 2 (2008-09-03, bzr_mysql-6.0-opt-subqueries):
main.analyze [ fail ]
mysqltest: At line 61: query 'execute stmt1' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
insert into t1 values(0);
analyze table t1;
Table Op Msg_type Msg_text
test.t1 analyze status OK
check table t1;
Table Op Msg_type Msg_text
test.t1 check status OK
drop table t1;
create table t1 (a mediumtext, fulltext key key1(a)) charset utf8 collate utf8_general_ci engine myisam;
insert into t1 values ('hello');
analyze table t1;
Table Op Msg_type Msg_text
test.t1 analyze status OK
analyze table t1;
Table Op Msg_type Msg_text
test.t1 analyze status Table is already up to date
drop table t1;
CREATE TABLE t1 (a int);
prepare stmt1 from "SELECT * FROM t1 PROCEDURE ANALYSE()";
execute stmt1;
More results from queries before failure can be found in /dev/shm/var-n_mix-110/log/analyze.log
Stopping All Servers
Restoring snapshot of databases
Saving core.28913
How to repeat:
Repeatable in Pushbuild.
Suggested fix:
Fix code, fix test, or disable test.
Description: main.analyze fails intermittently on Pushbuild with an error code indicating a crash, on a variety of platforms (Windows, Unix, Linux). For example (2008-09-05, bzr_mysql-6.0-falcon-team): main.analyze [ fail ] ERROR: mysqltest returned unexpected code 3, it has probably crashed Stopping All Servers Restoring snapshot of databases --- Example 2 (2008-09-03, bzr_mysql-6.0-opt-subqueries): main.analyze [ fail ] mysqltest: At line 61: query 'execute stmt1' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > insert into t1 values(0); analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status OK check table t1; Table Op Msg_type Msg_text test.t1 check status OK drop table t1; create table t1 (a mediumtext, fulltext key key1(a)) charset utf8 collate utf8_general_ci engine myisam; insert into t1 values ('hello'); analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status OK analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status Table is already up to date drop table t1; CREATE TABLE t1 (a int); prepare stmt1 from "SELECT * FROM t1 PROCEDURE ANALYSE()"; execute stmt1; More results from queries before failure can be found in /dev/shm/var-n_mix-110/log/analyze.log Stopping All Servers Restoring snapshot of databases Saving core.28913 How to repeat: Repeatable in Pushbuild. Suggested fix: Fix code, fix test, or disable test.