[debian-mysql] Bug#459543: mysql-server-5.0: ndb-cluster is broken

[Benedikt Zorn]

Package: mysql-server-5.0
Version: 5.0.45-5
Severity: normal

When doing a "CREATE TABLE tbl_1 (id INT(11) AUTO_INCREMENT PRIMARY KEY, test VARCHAR(25)) ENGINE=ndbcluster;", 
I get the error message "ERROR 1005 (HY000): Can't create table './test_db/tbl_1.frm' (errno: 879)". Despite that 
message there is a table tbl_1 in my database. 
On the node where I created the table I get the following message when doing a "DESCRIBE tbl_1":

mysql> describe tbl_1;
ERROR 1296 (HY000): Got error 4243 'Index not found' from ndbcluster

On my other node I get the following:

mysql> describe tbl_1;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     | NO   | PRI | NULL    | auto_increment | 
| test  | varchar(25) | YES  |     | NULL    |                | 
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)

When trying to insert some data into this table I get th following error:

mysql> INSERT INTO tbl_1 VALUES (0, "test1");
ERROR 1296 (HY000): Got error 4243 'Index not found' from ndbcluster


When doing a "CREATE TABLE tbl_2 (id INT(11) PRIMARY KEY, test VARCHAR(25)) ENGINE= ndbcluster;" instead of the above command,
I get no error message and the table can be described on all nodes.

mysql> describe tbl_2;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | NO   | PRI |         |       | 
| test  | varchar(25) | YES  |     | NULL    |       | 
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

When trying to insert into this table with the following command:

mysql> INSERT INTO tbl_2 VALUES (1, "test");

I get the following error message:
ERROR 1296 (HY000): Got error 879 '879' from ndbcluster


When doing the same with the original mysql binaries I get no errors at all.
 
My ndb-Cluster consists of 3 physical nodes. One of these serves as management node, the other two are both data- and mysql-nodes.
I am working with 2 replicas.


-- System Information:
Debian Release: lenny/sid
  APT prefers old-stable
  APT policy: (500, 'old-stable'), (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.23.9 (SMP w/4 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                 3.105            add and remove users and groups
ii  debconf [debconf-2.0]   1.5.17           Debian configuration management sy
ii  libc6                   2.7-5            GNU C Library: Shared libraries
ii  libdbi-perl             1.601-1          Perl5 database interface by Tim Bu
ii  libgcc1                 1:4.2.2-4        GCC support library
ii  libmysqlclient15off     5.0.45-5         MySQL database client library
ii  libncurses5             5.6+20071124-1   Shared libraries for terminal hand
ii  libreadline5            5.2-3            GNU readline and history libraries
ii  libstdc++6              4.2.2-4          The GNU Standard C++ Library v3
ii  libwrap0                7.6.dbs-14       Wietse Venema's TCP wrappers libra
ii  lsb-base                3.1-24           Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0        5.0.45-5         MySQL database client binaries
ii  mysql-common            5.0.45-5         MySQL database common files
ii  passwd                  1:4.0.18.1-11    change and administer password and
ii  perl                    5.8.8-12         Larry Wall's Practical Extraction 
ii  psmisc                  22.5-1           Utilities that use the proc filesy
ii  zlib1g                  1:1.2.3.3.dfsg-8 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  mailx            1:8.1.2-0.20071017cvs-2 A simple mail user agent

-- debconf information:
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/need_sarge_compat: false
  mysql-server-5.0/start_on_boot: true
  mysql-server/error_setting_password:
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/need_sarge_compat_done: true