Bug #44345 error 755 'Invalid tablespace' with a partitioned table in NDB
Submitted: 17 Apr 2009 17:47 Modified: 17 May 2009 12:16
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to: Jonas Oreland CPU Architecture:Any

[17 Apr 2009 17:47] Joerg Bruehe
Description:
In the build of cluster-7.0.5,
tests "partition_mgm_lc1_ndb" and "partition_mgm_lc2_ndb" fail whenever and wherever they are run.

=====
parts.partition_mgm_lc1_ndb              [ fail ]
        Test ended at YYYY-MM-DD HH:MM:SS

CURRENT_TEST: parts.partition_mgm_lc1_ndb
mysqltest: In included file "./suite/parts/inc/partition_mgm.inc": At line 54: query 'ALTER TABLE TableA COALESCE PARTITION 4' failed: 1025: Error on rename of './mysql_test_db/tablea' to './mysql_test_db/#sql2-d5-3' (errno: 140)

The result from queries just before the failure was:
< snip >
3
4
5
6
7
8
9
SHOW CREATE TABLE TableA;
Table   Create Table
TableA  CREATE TABLE `tablea` (
  `a` int(11) DEFAULT NULL
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
/*!50100 PARTITION BY KEY (a)
(PARTITION parta ENGINE = ndbcluster,
 PARTITION partB ENGINE = ndbcluster,
 PARTITION Partc ENGINE = ndbcluster,
 PARTITION PartD ENGINE = ndbcluster,
 PARTITION partE ENGINE = ndbcluster,
 PARTITION Partf ENGINE = ndbcluster,
 PARTITION PartG ENGINE = ndbcluster) */

More results from queries before failure can be found in /PATH/mysql-test/var/log/partition_mgm_lc1_ndb.log

Warnings from just before the error:
Error 1296 Got error 755 'Invalid tablespace' from NDB
=====

=====
parts.partition_mgm_lc2_ndb              [ fail ]
        Test ended at YYYY-MM-DD HH:MM:SS

CURRENT_TEST: parts.partition_mgm_lc2_ndb
mysqltest: In included file "./suite/parts/inc/partition_mgm.inc": At line 54: query 'ALTER TABLE TableA COALESCE PARTITION 4' failed: 1025: Error on rename of './mysql_test_db/tablea' to './mysql_test_db/#sql2-f7b-3' (errno: 140)

The result from queries just before the failure was:
< snip >
3
4
5
6
7
8
9
SHOW CREATE TABLE TableA;
Table   Create Table
TableA  CREATE TABLE `TableA` (
  `a` int(11) DEFAULT NULL
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
/*!50100 PARTITION BY KEY (a)
(PARTITION parta ENGINE = ndbcluster,
 PARTITION partB ENGINE = ndbcluster,
 PARTITION Partc ENGINE = ndbcluster,
 PARTITION PartD ENGINE = ndbcluster,
 PARTITION partE ENGINE = ndbcluster,
 PARTITION Partf ENGINE = ndbcluster,
 PARTITION PartG ENGINE = ndbcluster) */

More results from queries before failure can be found in /PATH/mysql-test/var/log/partition_mgm_lc2_ndb.log

Warnings from just before the error:
Error 1296 Got error 755 'Invalid tablespace' from NDB
=====

How to repeat:
Just run the tests.
[17 May 2009 12:16] Jonas Oreland
I have now reviewed the parts-suite, and found several testcases that tries
to utilize not supported features. For this I filed bug#44919.
Test cases referred in this bug report were among these.
So I close this.
No docs needed.