Re: Can't repair table

Yes. I did it from web console.

It repeat from sql command line:

sql> select count(*) from email;

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

| count(*)              |

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

|                  6118 |

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

1 row in set (0,79 sec)

sql> delete from email;

Can't change size of file (Errcode: 5)

From command line SQL tool repair table finish with success, but it took long time:

sql> select count(*) from email;

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

| count(*)              |

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

|                  6090 |

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

1 row in set (0,67 sec)

sql> repair table email;

Number of rows changed from 6090 to 5755

gb_gbsupport.email | repair | status   | OK

2 rows in set (274,17 sec)

Than try delete from table second time:

sql> select count(*) from email;

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

| count(*)              |

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

|                  5757 |

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

1 row in set (0,53 sec)

sql> delete from email;

Can't change size of file (Errcode: 5)

sql> select count(*) from email;

Connection id no longer valid.

re-open sql command line tool

sql> select count(*) from email;

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

| count(*)              |

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

|                  5758 |

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

1 row in set (0,79 sec)