Test case timeout

[Amit Saha]

Please find attached the test case under consideration: se_join_natural_left_outer.test. A timeout occurs on this test when a particular suite of test cases: se_join* (all attached) is run.

To reproduce:

Run the se_join* tests i.e. --do-test=se_join*

Note that, time out doesn;t occur when only the individual test case is run. I am using MySQL 6.0.6+ and PBXT built from the repository.

PS: Maria, Falcon and InnoDB run the above tests in acceptable time limit.

[Vladimir Kolesnikov (vkolesnikov)]

There's a performance problem:

mysql> show processlist;
+----+------+-----------------+------+---------+------+--------+-------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------------+------+---------+------+--------+-------------------------------------------------------------------+
| 7 | root | localhost | test | Query | 5 | update | INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9) |
| 8 | root | localhost:37669 | test | Query | 0 | NULL | show processlist |
+----+------+-----------------+------+---------+------+--------+-------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show create table t1;
+-------+-------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
  `c1` bigint(20) NOT NULL
) ENGINE=PBXT DEFAULT CHARSET=latin1 |
+-------+-------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

A very simple INSERT w/o references takes > 5 seconds to execute...

[Vladimir Kolesnikov (vkolesnikov)]

thanks for the report