Bug #16821 ALTER TABLE test.t1 REPAIR PARTITION p0 hangs mysql-test

• Submitted: 26 Jan 2006 21:03
• Modified: 21 Mar 2006 16:32
• Reporter: Jonathan Miller
• Status: Duplicate
• Category: MySQL Server: Partitions
• Severity: S2 (Serious)
• Version: 5.1.6-alpha
• OS: Linux (Linux)
• Assigned to: Assigned Account
• CPU Architecture: Any

[26 Jan 2006 21:03] Jonathan Miller

Description:
The following test never returns. Should not take long to repair 11 rows.

How to repeat:
CREATE TABLE test.t1 (
  c1 MEDIUMINT NOT NULL AUTO_INCREMENT,
  c2 TEXT NOT NULL,
  c3 INT NOT NULL,
  c4 BIT NOT NULL,
  c5 FLOAT,
  c6 VARCHAR(255),
  c7 TIMESTAMP,
  PRIMARY KEY(c1,c3))
  ENGINE=NDB
  PARTITION BY KEY(c3) PARTITIONS 5;

let $j= 11;
--disable_query_log
while ($j)
{
  eval INSERT INTO test.t1 VALUES (NULL, "Tested Remotely from Texas, USA", $j, b'0',
                                   $j.00,"By JBM $j","2006-01-26");
  dec $j;
}
--enable_query_log

ALTER TABLE test.t1
 ADD INDEX (c5);

ALTER TABLE test.t1 RENAME test.t3;

ALTER TABLE test.t3 RENAME test.t1;

ALTER TABLE test.t1 CHANGE c2 c2 BLOB;

ALTER TABLE test.t1 CHANGE c2 c2 TEXT;

ALTER TABLE test.t1 MODIFY c1 BIGINT NOT NULL;

SHOW CREATE TABLE test.t1;

ALTER TABLE test.t1 REPAIR PARTITION p0;

DROP TABLE test.t1;

[26 Jan 2006 21:48] Jorge del Conde

Reproduced under FC4 with a recent 5.1 clone

[21 Mar 2006 16:32] Mikael Ronström

See bug #16819, this is the same. 16819 needs feedback