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

[Monty Taylor]

Hi,

What version of MySQL were you using when you were using the binaries
from MySQL?

Does  ndb_show_tables show the table?

If it does, what does ndb_desc show for that table?

Monty

Benedikt Zorn wrote:
> 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
> 
> 
> 
> _______________________________________________
> pkg-mysql-maint mailing list
> pkg-mysql-maint at lists.alioth.debian.org
> http://lists.alioth.debian.org/mailman/listinfo/pkg-mysql-maint
>