Bug #7898 mysqld crash with ndb

• Submitted: 14 Jan 2005 8:03
• Modified: 20 Jan 2005 10:16
• Reporter: Tomas Ulin
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 4.1.8-max, 4.1.9-max
• OS: Solaris (solaris 2.9)
• Assigned to: Jonas Oreland
• CPU Architecture: Any

[14 Jan 2005 8: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 9:21] Martin Skold

Cannot reproduce on 5.0, will check 4.1.9
Could have been fixed for bug#7480

[14 Jan 2005 15: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 3: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.