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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
