MySQL Forums
Forum List  »  Newbie

Got error 22 from storage engine
Posted by: Ian Cummings
Date: February 06, 2009 04:54PM

I got this message during script execution:

"Got error 22 from storage engine"

and can't find any documentation on it. What does it mean and how do I fix it? There was also a

"ErrNr 1030"

indicator.

As a quick summary of where it occurred, I created a fairly large (1.3M lines) table with range partitions and hash subpartitions using the MyISAM engine. The purpose is to be able to use the table for fast full text index queries by taking advantage of partition pruning. Everything appears to be fine with the table when using Explain and Show Table Status, but when I try to index the table with

"create index TileXIndex on Yellow (TileX);"

I get the above error.

Another peculiarity is that when I try to create a fulltext index with

"create fulltext index BusinessNameIndex on Yellow (BusinessName);"

I get the error

"The used table type doesn't support FULLTEXT indexes"

even though

"show table status;"

gives

" 'yellow', 'MyISAM', 10, 'Dynamic', 1315785, 2189, 2881159164, 0, 691200, 1991574552, , '2009-02-06 16:45:37', '2009-02-06 17:24:08', '', 'latin1_swedish_ci', , 'partitioned', '' "

showing that the table type is indeed MyIsam

I can post more complete code if it would be helpful

Thanks in advance for your help.

Options: ReplyQuote


Subject
Written By
Posted
Got error 22 from storage engine
February 06, 2009 04:54PM


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.