今天在測(cè)試的時(shí)候,系統(tǒng)無(wú)法登入。報(bào)如下錯(cuò)誤:
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
很少看到這樣的錯(cuò)誤,今天被我碰到了,哈哈
運(yùn)行如下命令:
repair table SEQUENCE_VALUE_ITEM
成功了,非常行不錯(cuò)。