successfully and try to delete again, however this time we got
the error
Got error 127 from storage engine and the table become corrupted -
need to repair it
When deleting few records there is no problem
However there is no trace to the error in the log file
Any Help ?
Amir
Server parameters
that there is a problem in
the table and we need to do a repair. Then we run the repair table which
finished successfully and try to delete again, however this time we got
the error
Got error 127 from storage engine and the table become corrupted -
need to repair it
When deleting few records
with transferring a big table (with 11
million record). The table in A works but seems to be corrupted after
transferrring to B. When querying on the table at B, I got Got error 127
from storage engine.
I tried myisamchk -r tablename but I still got the same msg. Any idea?
Thanks in advance
the
transferring, the table on B works well.
However, I am encountering a problem with transferring a big table
(with 11 million record). The table in A works but seems to be
corrupted after transferrring to B. When querying on the table at B, I
got Got error 127 from storage engine.
I tried myisamchk
). The table in A works but seems to be corrupted after
transferrring to B. When querying on the table at B, I got Got error 127
from storage engine.
I tried myisamchk -r tablename but I still got the same msg. Any idea?
Thanks in advance!
Qunfeng
--
MySQL General Mailing List
For list
to B. When querying on the table at B,
I got Got error 127 from storage engine.
I tried myisamchk -r tablename but I still got the same msg. Any
idea? Thanks in advance!
Qunfeng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
transferrring to B. When querying on the table at B, I
got Got error 127 from storage engine.
I tried myisamchk -r tablename but I still got the same msg. Any idea?
Thanks in advance!
Qunfeng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Haitao Jiang [EMAIL PROTECTED] wrote:
I have done following on a 8 million row table (4GB):
repair table
optimize table
drop one of the fulltext index
optimize table again
Now fulltext search stop working and I am getting:
ERROR 1030 (HY000): Got error 127 from storage engine
What
Hi,
I have done following on a 8 million row table (4GB):
repair table
optimize table
drop one of the fulltext index
optimize table again
Now fulltext search stop working and I am getting:
ERROR 1030 (HY000): Got error 127 from storage engine
What does this mean? Index corrupted? How
(HY000): Got error 127 from storage engine
Hi,
I have done following on a 8 million row table (4GB):
repair table
optimize table
drop one of the fulltext index
optimize table again
Now fulltext search stop working and I am getting:
ERROR 1030 (HY000): Got error 127 from storage
10 matches
Mail list logo