"undef error - DBD::mysql::db selectrow_array failed: Table 'attach_data' is
marked as crashed and should be repaired [for Statement "SELECT LENGTH(thedata)
FROM attach_data WHERE id =?"] at Bugzilla/Attachment.pm line 344
Bugzilla::Attachment::datasize('Bugzilla::Attachment=HASH(0x9df119c)') called"
This is the error message which you get in Bugzilla database while generating bug repaort. If you are the user who gets such error then you are advised to follow procedure mentioned below.
Bugzilla is a web-based bug tracking and testing application. Many software development companies used this application in various database including MySQL for its backend support. Tool work fine with the database but whenever you get the issue of corruption in database, tool won't work efficiently. After this you get the error message and you are unable to perform any tasks.
You are getting this error message because 'attach_data' table is corrupt as it is appear in error message.
To resolve the error message you need to repair MySQL database. By using the the 'myisamchk' command with different parameters you can check corruption in the table and repair it.
You can use the 'myisamchk' command with different parameters to repair MySQL database. If it does not work, then you should use a professional MySQL recovery software to recover MySQL database.
Repair the table using the following command:
# myisamchk -r profiles.MYI
You should do a check and repair using the myisamchk command -
# myisamchk --silent --force --fast --update-state /var/lib/mysql/bugs/*.MYI
The 'myisamchk' tool used to check and repair the MyISAM table. But there are many instances where it has been proved that you are not able to repair table by doing this. Then you can use the professional third party software to repair corrupted MySQL database table. This is the most worthwhile solution. This tool is designed with the most advanced algorithm to repair table without any damage to existing files.
This is software is easy to use and compatible with Windows 7, Vista, Server 2003, XP, and 2000. It supports repair and recovery from MySQL 3.x, 4.x, 5.x, and 6.x.