IDO老徐,在深圳,某上市公司质量部负责人,干了十二年软件测试,公号"简尚" ,博客isTester.com ,关注「软件测试从业者综合能力提升」,微信957863300

mysql报错Table is marked as crashed and should be repaired 的解决办法

上一篇 / 下一篇  2020-11-14 13:41:34 / 个人分类:linux

前几天,老徐的istester博客突然挂了;收到了用户的反馈才知道 ;51Testing软件测试网+`!mv8gd,J9@-@,v

折腾了几次没发现原因;51Testing软件测试网(o6gk[iI4?xd5u

后面查了下数据库,才发现,是库出问题了;

#]*Pu NvM^ w0


Vf$X eBNh+B0

如下是报错内容 和解决思路 ;51Testing软件测试网E;w~Ah/|/RQ6@


1J(TgN1U8_0

COD,P/a7X\0

mysql> select * from isTeter.com ;51Testing软件测试网:a;Y0z{E

ERROR 145 (HY000): Table './isTeter_Idoxu/isTeter.com' is marked as crashed and should be repaired

wB.WA4q*tEU0


51Testing软件测试网Z P)_\3W5Y

mysql> check table isTeter.com ;

E7P7M(^(z0`0

+-----------------------------+-------+----------+------------------------------------------------------------+51Testing软件测试网o@v%ul:c

| Table                       | Op    | Msg_type | Msg_text                                                   |

6r*N$z,~%\5r5^9m9IE@0

+-----------------------------+-------+----------+------------------------------------------------------------+

!R&p?"o p*hk5t0

| isTeter_Idoxu.isTeter.com | check | warning  | Table is marked as crashed                                 |

%gZ/z8X:y)J"B0

| isTeter_Idoxu.isTeter.com | check | warning  | 102 clients are using or haven't closed the table properly |51Testing软件测试网+w?#CRR

| isTeter_Idoxu.isTeter.com | check | error    | Checksum for key:  4 doesn't match checksum for records    |

Tx5GW*Y0

| isTeter_Idoxu.isTeter.com | check | error    | Corrupt                                                    |51Testing软件测试网 `,P.n }(f`j1O"J]

+-----------------------------+-------+----------+------------------------------------------------------------+51Testing软件测试网|O5R*{!yi

4 rows in set (0.31 sec)51Testing软件测试网"YBb4XI4Y%a!c


51Testing软件测试网v5DY&D!J

mysql> repair table isTeter.com;51Testing软件测试网!n&wW2KF`i4`

+-----------------------------+--------+----------+----------+51Testing软件测试网}r0n`Q_wE

| Table                       | Op     | Msg_type | Msg_text |51Testing软件测试网NF$g%d{$V;J^

+-----------------------------+--------+----------+----------+51Testing软件测试网Wg te@@

| isTeter_Idoxu.isTeter.com | repair | status   | OK       |

YRs7YAF'c#j1vA0

+-----------------------------+--------+----------+----------+

CPL:Z+l*{-PXtU+Q0

1 row in set (0.15 sec)51Testing软件测试网My?6g{m"e


Tr_ uV0

mysql> check table isTeter.com;

1?SkZDG0

+-----------------------------+-------+----------+----------+

r"}4B X{ b{0

| Table                       | Op    | Msg_type | Msg_text |51Testing软件测试网b.As$_h$xf^

+-----------------------------+-------+----------+----------+

v|Hw1r8XC6{0

| isTeter_Idoxu.isTeter.com | check | status   | OK       |51Testing软件测试网%e.j8ujt

+-----------------------------+-------+----------+----------+

je5~zu0

1 row in set (0.01 sec)51Testing软件测试网(a9nJ'Q3c)W


51Testing软件测试网 S2c|L bb


51Testing软件测试网v6qSQ{9^6l~!jS.S

搞定 

rxB)J ypd0

TAG:

 

评分:0

我来说两句

xuquan

xuquan

IDO老徐,坐标深圳,测试经理,干了十年测试,公号"简尚" ,个人博客isTester.com ,关注「软件测试从业者综合能力提升」,微信957863300

日历

« 2022-11-24  
  12345
6789101112
13141516171819
20212223242526
27282930   

数据统计

  • 访问量: 838436
  • 日志数: 427
  • 建立时间: 2012-06-04
  • 更新时间: 2022-02-23

RSS订阅

Open Toolbar