MySQL Forums
Forum List  »  Memory Storage Engine

ERROR 1030 (HY000): Got error 12 from storage engine
Posted by: saravanan krishnarajan
Date: February 17, 2008 07:29AM


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


Options: ReplyQuote

Written By
ERROR 1030 (HY000): Got error 12 from storage engine
February 17, 2008 07:29AM

Sorry, you can't reply to this topic. It has been closed.

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.