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

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

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1030 (HY000): Got error 12 from storage engine
14043
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.