The MassTransit Engine may inadvertently shut down, and will not properly restart. Within the Application Log of the Windows Event Viewer, the following error message may be displayed:
SA_Exception[xxxx]: DB_Files_Edit: Incorrect key file for table 'tablename'; try to repair it.
Commonly, tablename may be referenced as 'dfiles'
This error indicates that the table listed within the error message has become corrupt, and must be repaired. In most cases, the table can easily be fixed with through the MySQL command line. Follow this procedure to repair failed tables:
- Open a Windows command prompt
- Navigate to the MySQL monitor command-line utility, which may be found at this location: C:\Program Files\MySQL\MySQL Server X.X\bin
- Invoke the MySQL monitor utility with the following command: mysql -uroot -p
- Enter your root password as specified during the initial installation of MySQL server.
- After successfully logging in, you should see a 'mysql>' prompt.
- At the 'mysql>' prompt, type the command: repair table tablename quick;
NOTE: tablename should be the name of the table listed in the Event Viewer error message, such as dfiles. Note also that the semi-colon character (;) at the end of the statement is required.
- When the repair process is completed, the results of the process will be displayed within the terminal.
- You may now close your terminal window.
The status message should indicate that the repair status was successful by indicating "OK." If any further errors result, it is important to contact Group Logic technical support for additional troubleshooting and repair instructions. After a successful repair has been completed, you may now be able to restart your MySQL Service, followed by the MassTransit Engine Service.