Hello,
I am just doing my first testing on a mysql-cluster system. Curently, I habe 1
management node running and 2 Data-Nodes that also run a mysqld each.
The servers are Dual-Opterons with 6GB of RAM each.
I did a dump of a database of one of our production systems (about 1.5GB
mysqldump-file) and piped that into the first of the new servers.
I then startet doing "alter table abc type=ndb"-queries and everything looked
fine at the beginning. After having moved 70-80% of the tables into the NDB-Engine (they
all show up correctly on the other mysql-server and everything seems to work) I suddenly
got the following error:
ERROR 1025 (HY000): Error on rename of './master/#sql-e80_1' to
'./master/status_system_hist' (errno: 708)
I could not find any information on how to fix this and what the reason could be.
When I manually create a new table with the same definition in the NDB-Engine and then do a insert into .. select from... I have no trouble. I should not be hitting the memory-limit yet, ndbd only uses 56% of the RAM so far.
I attached some SQL-Output, part of the config.ini and the "top"-output.
Can anybody help me with this?
thanks
Jan
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=4200M
IndexMemory=1000M
NoOfFragmentLogFiles=100
MaxNoOfConcurrentOperations=500000
mysql> show table status;
+-----------------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+-----------------------+
| Name | Engine | Version | Row_format | Rows |
Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_time | Update_time | Check_time
| Collation | Checksum | Create_options | Comment |
+-----------------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+-----------------------+
[...]
| status_system_hist | MyISAM | 10 | Dynamic | 270413 |
91 | 24721832 | 281474976710655 | 4409344 | 0 |
NULL | 2006-01-27 15:03:48 | 2006-01-27 15:04:12 | NULL |
latin1_swedish_ci | NULL | | |
[...]
mysql> alter table status_system_hist type=ndb;
ERROR 1025 (HY000): Error on rename of './master/#sql-e80_1' to
'./master/status_system_hist' (errno: 708)
mysql> show create table status_system_hist;
+--------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+--------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| status_system_hist | CREATE TABLE `status_system_hist` (
`hostname` varchar(30) NOT NULL default '',
`statuszeit` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
`cpu_idle` double(16,4) default NULL,
`cpu_sys` double(16,4) default NULL,
`cpu_user` double(16,4) default NULL,
`cpu_wait` double(16,4) default NULL,
`load1` double(16,4) default NULL,
`load5` double(16,4) default NULL,
`load15` double(16,4) default NULL,
`mem_buffers` int(11) default NULL,
`mem_cached` int(11) default NULL,
`mem_free` int(11) default NULL,
`mem_shared` int(11) default NULL,
`mem_total` int(11) default NULL,
`proc_running` int(11) default NULL,
`proc_total` int(11) default NULL,
`swap_free` int(11) default NULL,
`swap_total` int(11) default NULL,
`mysql_open_tables` int(11) default NULL,
`mysql_queries_per_second_avg` double(16,4) default NULL,
`mysql_threads` int(11) default NULL,
PRIMARY KEY (`hostname`,`statuszeit`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+--------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.17 sec)
mysql> CREATE TABLE `status_system_hist2` (
-> `hostname` varchar(30) NOT NULL default '',
-> `statuszeit` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
-> `cpu_idle` double(16,4) default NULL,
-> `cpu_sys` double(16,4) default NULL,
-> `cpu_user` double(16,4) default NULL,
-> `cpu_wait` double(16,4) default NULL,
-> `load1` double(16,4) default NULL,
-> `load5` double(16,4) default NULL,
-> `load15` double(16,4) default NULL,
-> `mem_buffers` int(11) default NULL,
-> `mem_cached` int(11) default NULL,
-> `mem_free` int(11) default NULL,
-> `mem_shared` int(11) default NULL,
-> `mem_total` int(11) default NULL,
-> `proc_running` int(11) default NULL,
-> `proc_total` int(11) default NULL,
-> `swap_free` int(11) default NULL,
-> `swap_total` int(11) default NULL,
-> `mysql_open_tables` int(11) default NULL,
-> `mysql_queries_per_second_avg` double(16,4) default NULL,
-> `mysql_threads` int(11) default NULL,
-> PRIMARY KEY (`hostname`,`statuszeit`)
-> ) ENGINE=ndb DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.66 sec)
mysql> insert into status_system_hist2 select *from status_system_hist;
Query OK, 270413 rows affected (24.44 sec)
Records: 270413 Duplicates: 0 Warnings: 0
mysql> drop table status_system_hist;
Query OK, 0 rows affected (0.06 sec)
mysql> rename table status_system_hist2 to status_system_hist;
ERROR 1025 (HY000): Error on rename of './master/status_system_hist2' to
'./master/status_system_hist' (errno: 708)
mysql>
top - 16:54:11 up 3:48, 3 users, load average: 0.00, 0.02, 0.08
Tasks: 67 total, 1 running, 66 sleeping, 0 stopped, 0 zombie
Cpu(s): 12.6% us, 1.5% sy, 0.0% ni, 83.6% id, 1.8% wa, 0.0% hi, 0.5% si
Mem: 6169480k total, 6138132k used, 31348k free, 36k buffers
Swap: 1052216k total, 136804k used, 915412k free, 2463208k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1 root 16 0 2656 540 456 S 0.0 0.0 0:00.28 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
7 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1
8 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 khelper
9 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kblockd/0
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.25 kblockd/1
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
146 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
186 root 20 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
187 root 15 0 0 0 0 S 0.0 0.0 0:00.73 pdflush
188 root 15 0 0 0 0 S 0.0 0.0 0:06.65 kswapd1
190 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
189 root 15 0 0 0 0 S 0.0 0.0 0:05.32 kswapd0
191 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
775 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
851 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
852 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 ata/1
857 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
858 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
861 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_2
862 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_3
870 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_4
938 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khpsbpkt
945 root 15 0 0 0 0 S 0.0 0.0 0:00.00 knodemgrd_0
1217 root 10 -5 0 0 0 S 0.0 0.0 0:00.02 xfslogd/0
1218 root 10 -5 0 0 0 S 0.0 0.0 0:00.61 xfslogd/1
1219 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 xfsdatad/0
1220 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 xfsdatad/1
1221 root 10 -5 0 0 0 S 0.0 0.0 0:00.93 xfsbufd
1222 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 xfssyncd
1473 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 xfssyncd
1474 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
1475 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 xfssyncd
1476 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 xfssyncd
2593 daemon 16 0 4808 372 264 S 0.0 0.0 0:00.00 portmap
2937 root 16 0 6528 812 660 S 0.0 0.0 0:00.00 syslogd
2940 root 16 0 3792 1692 372 S 0.0 0.0 0:00.05 klogd
2975 Debian-e 15 0 23868 1108 736 S 0.0 0.0 0:00.00 exim4
2980 root 20 0 6520 716 604 S 0.0 0.0 0:00.00 inetd
2985 lp 19 0 9820 540 376 S 0.0 0.0 0:00.00 lpd
2993 root 16 0 18284 1088 704 S 0.0 0.0 0:00.00 sshd
3017 root 16 0 8708 912 764 S 0.0 0.0 0:00.00 rpc.statd
3025 daemon 16 0 6932 400 276 S 0.0 0.0 0:00.00 atd
3028 root 16 0 9052 840 640 S 0.0 0.0 0:00.00 cron
3153 root 17 0 2652 504 424 S 0.0 0.0 0:00.01 getty
3155 root 17 0 2648 500 424 S 0.0 0.0 0:00.00 getty
3156 root 16 0 2652 504 424 S 0.0 0.0 0:00.00 getty
3157 root 16 0 2648 500 424 S 0.0 0.0 0:00.00 getty
3165 root 16 0 2652 504 424 S 0.0 0.0 0:00.00 getty
3166 root 16 0 2652 500 424 S 0.0 0.0 0:00.00 getty
3225 root 15 0 39656 2116 1552 S 0.0 0.0 0:00.23 sshd
3228 root 15 0 11680 1992 1336 S 0.0 0.0 0:00.05 bash
3232 root 15 0 39660 2104 1552 S 0.0 0.0 0:00.31 sshd
3235 root 15 0 11676 1976 1328 S 0.0 0.0 0:00.09 bash
3676 root 17 0 7236 1512 1080 S 0.0 0.0 0:00.00 mysqld_safe
3712 mysql 16 0 807m 271m 4312 S 0.0 4.5 0:25.51 mysqld
3752 root 18 0 12504 1984 544 S 0.0 0.0 0:00.00 ndbd
3753 root 15 0 5328m 3.3g 138m S 0.0 55.3 13:06.28 ndbd
3784 root 15 0 16068 2168 1472 S 0.0 0.0 0:00.04 mysql
3801 root 16 0 39504 2088 1548 S 0.0 0.0 0:00.02 sshd
3804 root 15 0 12844 2088 1388 S 0.0 0.0 0:00.01 bash
3832 root 15 0 9464 1132 836 R 0.0 0.0 0:00.00 top
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
