ERROR 1030 (HY000): Got error 12 from storage engine

[saravanan krishnarajan]

Hi,

My server has 2 Intel(R) Xeon(R) CPUs. Running with mysql 5.0.22-log. I have a memory table without any index as following

mysql> show table status like 'Bounce1'\G
*************************** 1. row ***************************
Name: Bounce1
Engine: MEMORY
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 131
Data_length: 0
Max_data_length: 532802676
Index_length: 0
Data_free: 0

when I try to insert rows nearly 3 million. I get the following error even it has enough memory.

mysql> insert into Bounce1 SELECT Email FROM bouncelog where type=24;
ERROR 1030 (HY000): Got error 12 from storage engine

Saravanan