Got error 22 from storage engine
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.