error during backup - "can't open" table .MYI

• Article Type: General
• Product: SFX
• Product Version: 3

Description:
We got the following error during backup:

/exlibris/sfx_ver/sfx_version_3/app/perl/bin/perl /exlibris/sfx_ver/sfx_version_
3/app/mysql/bin/mysqlhotcopy --user=root --password=xxxxxx--socket=/exlibris
/sfx_ver/sfx_version_3/app/mysql/socket/mysql.sock sfxlcl3 /exlibris/sfx_ver/sfx
_version_3/tmp/dumpdir
DBD::mysql::db do failed: Can't open file: 'STAT_TARGET_SERVICE.MYI' (errno: 145
) at /exlibris/sfx_ver/sfx_version_3/app/mysql/bin/mysqlhotcopy line 468.
ERROR when: /exlibris/sfx_ver/sfx_version_3/app/perl/bin/perl /exlibris/sfx_ver/
sfx_version_3/app/mysql/bin/mysqlhotcopy --user=root --password=xxxxxx--sock
et=/exlibris/sfx_ver/sfx_version_3/app/mysql/socket/mysql.sock sfxlcl3 /exlibris
/sfx_ver/sfx_version_3/tmp/dumpdir

Resolution:
This error indicates that a table index is corrupt in the database of an instance you are trying to back up.
This problem can be fixed in the following manner:

Log in as the sfxlcl3 user (or user of the instance during the backup of which the error occured).
Use the 'da' shortcut to go to the admin directory.
Run the server_admin_util program.
Choose option 4 (Database maintenance), then option 3 (REPAIR MySQL tables).
You will be asked to enter the name of the table to repair. Enter STAT_TARGET_SERVICE (or another table, depending on the table name in the error message).

Afterwards you might want to use option 2 (CHECK MySQL tables) to verify that the table has been completely repaired.