If you get the following message:

Executing generated SQL.: java.sql.SQLException:
General error: Got error127 from table handler
State: S1000
Error Code: 1030

What might be causing this?

The error message you are receiving indicates a corrupt record in a table in the database. In order to correct the issue, you can run a simple MySQL repair utility. Before you do this, you will need to turn off the MySQL daemon. Failure to do so before running this command can result in more extensive corruption of the database. Shut down MySQL using the following command:

# /etc/rc.d/init.d/mysql stop

or

# /etc/rc.d/init.d/mysqld stop

You will also want to shutdown Tomcat and Apache so that your customers do not receive error messages from the servlet engine.

Change directory to the ProStores database structure directory. This is usually located at /home/mysql/prostores or /var/lib/mysql/prostores. Execute the following command to check and repair the tables:

# myisamchk -rq *.MYI

This utility will find and repair simple problems with records in the tables. If it cannot repair a problem in a table, it will report this and instruct you to use the -o option. If this occurs, run the following command on ONLY the table that has the problem:

# myisamchk -o tablename.MYI

where tablename is the name of the table with the error (i.e. LogSearch.MYI) When you are done, you can restart the MySQL engine.