今天在测试的时候,系统无法登入。报如下错误:

SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following:
UPDATE SEQUENCE_VALUE_ITEM SET SEQ_ID=SEQ_ID+100 WHERE SEQ_NAME='Visit'
Error was:Incorrect key file for table './ccbofbiz/sequence_value_item.MYI'; try to repair it
Exception: java.sql.SQLException
Message: Incorrect key file for table './ccbofbiz/sequence_value_item.MYI'; try to repair it

很少看到这样的错误,今天被我碰到了,哈哈
运行如下命令:
repair table SEQUENCE_VALUE_ITEM

成功了,非常行不错。