Test case timeout

Bug #313176 reported by Amit Saha on 2009-01-02
2
Affects Status Importance Assigned to Milestone
PBXT
Undecided
Vladimir Kolesnikov

Bug Description

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.

Related branches

Amit Saha (amit-saha) wrote :
Amit Saha (amit-saha) wrote :
description: updated

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...

thanks for the report

Changed in pbxt:
assignee: nobody → vkolesnikov
status: New → Confirmed
Changed in pbxt:
status: Confirmed → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers