| Bug #31333 | I can't create logfile group in MySQL 5.1.22 of SunOS. | ||
|---|---|---|---|
| Submitted: | 2 Oct 2007 9:43 | Modified: | 19 May 2008 6:25 |
| Reporter: | ws lee | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Cluster: Disk Data | Severity: | S2 (Serious) |
| Version: | 5.1.22 RC | OS: | Solaris (SunOS 5.11 snv_40) |
| Assigned to: | CPU Architecture: | Any | |
[17 Feb 2008 15:33]
Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.1.23-rc, and inform about the results.
[18 Feb 2008 23:01]
ws lee
To my regret, SunOS(5.11 snv_40) was hanged in New version 5.1.23rc, too. I could not create to UNDOFILE 'undo_1.dat'like before version 5.1.22rc. I want to check and repair this bug quickly.
[24 Apr 2008 9:35]
ws lee
It maybe not solaris's problem(or mysql's problem) but Server's problem. 「Fanatic Solution Server6014L-T1」 was crashed during making logfile group. In Other serer was not crashed in mysql 5.1.23 and solaris 10.
[13 May 2008 13:08]
Valeriy Kravchuk
So, is this a result of server's failure or you still think it is a bug in MySQL?
[15 May 2008 11:01]
ws lee
To. Valeriy Kravchuk i have test new machine sun fire x2200(64bit). no problem in this machine. It seems to crash only [mysql + solaris 10 + supermicro 6014T server]
[16 May 2008 14:19]
Valeriy Kravchuk
So, this looks like hardware/OS combination problem, not MySQL's bug. Do you agree?
[19 May 2008 6:25]
ws lee
yes, i agree!
Description: I want use disk storage in MySQL Cluster. so, I ran "CREATE LOGFILE GROUP ~ " to create undofile firstly. but data node was down, When I ran this command. I can't at all test disk storage of MySQL cluster 5.1 because of this error in first step. sql node is no problem. I suspect data crash fo between mysql 5.1 and SunOS 5.11. How to repeat: 1. OS: SunOS 5.11 snv_40 2. MySQL: 5.1.22 RC 3. Config.ini [NDBD DEFAULT] NoOfReplicas=2 DataMemory=1000M IndexMemory=100M [NDB_MGMD] hostname=192.168.1.5 datadir=/var/lib/mysql-cluster [NDB_MGMD] hostname=192.168.1.6 datadir=/var/lib/mysql-cluster [NDBD] hostname=192.168.15.15 datadir=/usr/local/mysql/data [NDBD] hostname=192.168.15.16 datadir=/usr/local/mysql/data [MYSQLD] hostname=192.168.1.5 [MYSQLD] hostname=192.168.1.6 4. Test ①I saw document this. http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data-objects.html ② Firstly, I executed commnad of below in sql node(192.168.1.5). ---------------------------------- mysql> CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.dat' INITIAL_SIZE 1000000000 ENGINE NDB; ------------------------------------ ③but, occured error of below ERROR 1525 (HY000): Failed to create UNDOFILE ④All Data node(192.168.15.15 and 192.168.15.16) was down