mysql 无法启动
时间：2007-09-04 来源：ptg0808
optimize table tbl_name;
在执行上面语句后，因为记录数多，用kill掉进程后，就出现下面的错误
Incorrect key file for table: 'records'. Try to repair it
070904 13:27:28 Slave: Error 'Incorrect key file for table: 'records'. Try to repair it' on query. Default database: 'pdns'. Query: 'update records set content='58.49.58.98',ttl=3600 where id=9462183 and domain_id=1059723', Error_code: 1034
070904 13:27:28 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'updatelog.189' position 10092892
070904 13:27:28 Slave I/O thread: connected to master 'replicate@*.*.*:3306', replication started in log 'updatelog.189' at position 11909658 myisamchk -of records.myi 修复后故障消除
070904 13:27:28 Slave: Error 'Incorrect key file for table: 'records'. Try to repair it' on query. Default database: 'pdns'. Query: 'update records set content='58.49.58.98',ttl=3600 where id=9462183 and domain_id=1059723', Error_code: 1034
070904 13:27:28 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'updatelog.189' position 10092892
070904 13:27:28 Slave I/O thread: connected to master 'replicate@*.*.*:3306', replication started in log 'updatelog.189' at position 11909658 myisamchk -of records.myi 修复后故障消除
相关阅读 更多 +
