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 > [EMAIL PROTECTED] > http://lists.alioth.debian.org/mailman/listinfo/pkg-mysql-maint > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
