Bug #7898 mysqld crash with ndb
Submitted: 14 Jan 2005 9:03 Modified: 20 Jan 2005 11:16
Reporter: Tomas Ulin
Status: Closed
Category:Server: Cluster Severity:S3 (Non-critical)
Version:4.1.8-max, 4.1.9-max OS:Sun Solaris (solaris 2.9)
Assigned to: Jonas Oreland Target Version:

[14 Jan 2005 9:03] Tomas Ulin 
Description:
create database t...
create table t.q
use t

crash...

How to repeat:
  1. Setup very basic cluster environment as described in:
http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_quick.html
  2. Connect to mysql as root (no db selected)
  3. CREATE DATABASE TEST;
  4. CREATE TABLE `TEST`.`Subscriber` (
     `SubscriberNo` INTEGER UNSIGNED NOT NULL PRIMARY KEY,                   
     `SubscriberName` VARCHAR(32) NOT NULL,
     `GroupId` INTEGER UNSIGNED NOT NULL,
     `Location` INT UNSIGNED NOT NULL,
     `ChangedBy` VARCHAR(32) NOT NULL,
     `ChangedTime` DATETIME NOT NULL
     )
     TYPE = NDB                                                              
     ;
  5. USE TEST;

Note: my.cnf used

[mysqld]
core-file
socket=/export/home/mysqldev/lachlan/mysql/data/mysql.sock
port=13306
pid-file=/export/home/mysqldev/lachlan/mysql/data/mysql.pid
basedir=/export/home/mysqldev/lachlan/mysql
datadir=/export/home/mysqldev/lachlan/mysql/data
ndbcluster

[client]
port=13306
socket=/export/home/mysqldev/lachlan/mysql/data/mysql.sock
[14 Jan 2005 10:21] Martin Skold 
Cannot reproduce on 5.0, will check 4.1.9
Could have been fixed for bug#7480
[14 Jan 2005 16:51] Martin Skold 
Tested example with mysql-max-4.1.9-sun-solaris2.9-sparc-64bit binary
on sunfire100b and could not reproduce the problem.
I would say this bug has already been fixed.
Please ask the customer to try the new binaries.
[19 Jan 2005 4:17] Lachlan Mulcahy 
On the contrary to Martin I have been able to reproduce this using
mysql-max-4.1.9-sun-solaris2.9-sparc-64bit binary. See internal info.