Bug #33159 mysqld down when create mysql.ndb_replication with addition PRIMARY KEY

Submitted: 12 Dec 2007 8:10 Modified: 7 Jan 2008 11:37
Reporter: li zhou Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S1 (Critical)
Version:5.1.22-ndb-6.3.6 OS:Any
Assigned to: Tomas Ulin CPU Architecture:Any

[12 Dec 2007 8:10] li zhou
Description:
If we add additional column and primary key when creating mysql.ndb_replication table, mysqld will crash. 

How to repeat:
Create table as following statement:
binlog_type is not required column.

CREATE TABLE mysql.ndb_replication
  (db VARBINARY(63),
   table_name VARBINARY(63),
   server_id INT UNSIGNED,
   binlog_type INT UNSIGNED,
   db_type INT UNSIGNED,
   conflict_fn VARBINARY(128),
   PRIMARY KEY USING HASH (db,table_name,server_id,db_type))
  ENGINE=NDB PARTITION BY KEY(db,table_name,db_type);

Suggested fix:
Limited required columns.
[12 Dec 2007 19:56] Valeriy Kravchuk
Thank you for a bug report. If you got a crash, why do you think it is a feature request (S4)? I'd call it a serious bug (S1). Do you agree?
[13 Dec 2007 13:29] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/39890

ChangeSet@1.2789, 2007-12-13 14:30:18+01:00, tomas@whalegate.ndb.mysql.com +1 -0
  Bug #33159  	mysqld down when create mysql.ndb_replication with addition PRIMARY KEY
[20 Dec 2007 17:06] Tomas Ulin
fixed in 6.3.7
[7 Jan 2008 11:37] Jon Stephens
Documented bugfix in 5.1.23-ndb-6.3.7 changelog. Closed.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.