今天在测试的时候,系统无法登入。报如下错误:
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
成功了,非常行不错。
2014-07-13 16:24:00