Bug #31934 mysqld lost connect with cluster after the second killing all ndbds
| Submitted: | 30 Oct 2007 6:55 | Modified: | 3 Mar 2008 14:45 |
|---|---|---|---|
| Reporter: | li zhou | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S3 (Non-critical) |
| Version: | mysql-5.1 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | 5.1.22 | ||
[30 Oct 2007 6:55]
li zhou
[17 Feb 2008 16:18]
Valeriy Kravchuk
Please, try to repeat with a newer version, 5.1.23-rc. In case of the same problem, please, upload .test file you had used.
[20 Feb 2008 6:53]
li zhou
Did test using mysql, 5.1.24-rc(bk from ndb tree). It still occur. I did two kinds of tests, all failed. 1: manually test with 4 data nodes 2: MTR test with 2 data nodes. The steps of manually test is: 1: build and make install 2: Install db in the install directory ./bin/mysql_install_db --user=mysql ./bin/mysql_install_db --user=mysql --datadir=var1 3: start cluster ./libexec/ndb_mgmd -f config.ini ./libexec/ndbd --initial ./libexec/ndbd --initial ./libexec/ndbd --initial ./libexec/ndbd --initial 4: start mysqld ./libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid=/usr/local/mysql/var/dev3-63.pid --log-error=/usr/local/mysql/var/dev3-63.err & ./libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var1 --user=mysql --pid=/usr/local/mysql/var1/dev3-63-2.pid --log-error=/usr/local/mysql/var/dev3-63-2.err --socket=/tmp/mysql1.sock --port=3307 & 5: create table t1 and insert data ./bin/mysql -u root test -S /tmp/mysql.sock sql>create table t1(a int, b int) engine ndb; sql>insert into t1 values(1,1); sql>insert into t1 values(1,2); 6: kill all the data nodes. killall ndbd 7: restat all the data nodes. ./libexec/ndbd ./libexec/ndbd ./libexec/ndbd ./libexec/ndbd 8: in mysql client do "select * from t1", "show create table". It works well. sql> select * from t1; 9: kill all the data nodes killall ndbd 10: restart all the data nodes again. ./libexec/ndbd ./libexec/ndbd ./libexec/ndbd ./libexec/ndbd 11: all the mysqlds lost connection with cluster. ./bin/ndb_mgm -e show sql> select * from t1;
[20 Feb 2008 6:58]
li zhou
Test file for the sencond time of data nodes restart.
Attachment: ndb_sys_restart.test (application/octet-stream, text), 1.62 KiB.
[20 Feb 2008 6:58]
li zhou
config file for manually test.
Attachment: config.ini (application/octet-stream, text), 894 bytes.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.