On May 5, 2010, at 9:55 AM, Mark Phillips wrote:
Craig,
I saw that particular article, and it is not the cause of my problem. My tables were setup with the "autoextend" parameter, so they grow as then need to, at least according to the mysql docs. Thanks for looking for that.
I have even tried to repair the tables, but with no success:
mysql> repair table mailserver.virtual_aliases, mailserver.virtual_users, mailserver.virtual_domains;
+----------------------------+--------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------------+--------+----------+-------------------------------------------------------------------+
| mailserver.virtual_aliases | repair | Error | Incorrect information in file: './mailserver/virtual_aliases.frm' |
| mailserver.virtual_aliases | repair | error | Corrupt |
| mailserver.virtual_users | repair | Error | Incorrect information in file: './mailserver/virtual_users.frm' |
| mailserver.virtual_users | repair | error | Corrupt |
| mailserver.virtual_domains | repair | Error | Incorrect information in file: './mailserver/virtual_domains.frm' |
| mailserver.virtual_domains | repair | error | Corrupt |
+----------------------------+--------+----------+-------------------------------------------------------------------+
6 rows in set (0.00 sec)
It seems the tables are corrupt, so i will have to drop them and then rebuild them.
Thanks for the reference!
Mark