Bug #34583 Crash in ALTER TABLE t1 CHANGE c4 c3 BLOB;
Submitted: 15 Feb 2008 10:35 Modified: 28 Oct 2009 17:10
Reporter: Martin Skold Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql-5.1-telco-6.2 OS:Linux (debx86-b 2.6.8-3-686-smp)
Assigned to: Frazer Clement CPU Architecture:Any

[15 Feb 2008 10:35] Martin Skold
Description:
ndb_team.rpl_ndb_dd_advance    [ fail ]

mysqltest: At line 157: query 'ALTER TABLE t1 CHANGE c4 c3 BLOB' failed: 2013: L
ost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
**** Show second set of ALTERs on SLAVE ****
SHOW CREATE TABLE t1;
Table   Create Table
t1      CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` int(11) NOT NULL,
  `c3` int(11) NOT NULL,
  `c4` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `c5` double DEFAULT NULL,
  PRIMARY KEY (`c1`),
  UNIQUE KEY `t1_i2` (`c2`),
  KEY `t1_i` (`c2`,`c3`)
) /*!50100 TABLESPACE ts1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=lati
n1
**** Third and last set of alters for test1  ****
ALTER TABLE t1 CHANGE c1 c1 DOUBLE;
ALTER TABLE t1 CHANGE c2 c2 DECIMAL(10,2);
ALTER TABLE t1 DROP COLUMN c3;
ALTER TABLE t1 CHANGE c4 c4 TEXT CHARACTER SET utf8;
ALTER TABLE t1 CHANGE c4 c4 BLOB;
ALTER TABLE t1 CHANGE c4 c3 BLOB;

How to repeat:
uname -a
Linux debx86-b 2.6.8-3-686-smp #1 SMP Tue Dec 5 23:17:50 UTC 2006 i686 GNU/Linux
./mysql-test-run.pl --debug --mysqld=--binlog-format=mixed -suite=ndb_team

Suggested fix:
Handle transaction aborts properly in BLOB code.
[12 Oct 2009 16:14] Frazer Clement
Following appear to be duplicates : 
  Bug#45768
  Bug#41674
  Bug#34583
[27 Oct 2009 10:43] Frazer Clement
Duplicate of bug#45768
[28 Oct 2009 10:11] Jon Stephens
Duplicate according to developer comments; set status to match.

(See BUG#45768)
[28 Oct 2009 17:05] Jon Stephens
BUG#41674 and BUG#45768 are duplicates of this bug.

Set status = Documenting.
[28 Oct 2009 17:10] Jon Stephens
Documented bugfix in the NDB-6.2.19, 6.3.28, and 7.0.9 changelogs.

See BUG#45768 for changelog info.