DevblocksORMHelper(56):Incorrect key file for table './helpdesk/ticket.MYI'; try to r

[pyrocam]

DevblocksORMHelper(56):Incorrect key file for table './helpdesk/ticket.MYI'; try to repair it

trying to send a message on one ticket

seems to still send (or at least shows it does in the ticket)

I have slightly customized code in some area's so just let me know if you want a particular file uploaded to check. afaik I havent altered any of the mail sending functions

[dsugita]

The .myi items are the indexes of the db (they can be rebuilt in case of a crash etc). Likely it sounds like there's some corruption there so you may want to run a myisamchk on that.

[pyrocam]

Thanks we did that but the root cause seemed to be something else
fyi:

mysqldump: Got error: 145: Table './helpdesk/ticket_audit_log' is marked as crashed and should be repaired when using LOCK TABLES
[root@support backups]# cd /var/lib/mysql/helpdesk/
[root@support helpdesk]# /etc/init.d/mysqld stop
Stopping MySQL: [ OK ]
[root@support helpdesk]# myisamchk ticket_audit_log
Checking MyISAM file: ticket_audit_log
Data records: 62477 Deleted blocks: 450
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 11 clients are using or haven't closed the table properly
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found 62472 keys of 62477
- check record links
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table 'ticket_audit_log' is corrupted
Fix it using switch "-r" or "-o"
[root@support helpdesk]# myisamchk -r ticket_audit_log
- recovering (with sort) MyISAM-table 'ticket_audit_log'
Data records: 62477
- Fixing index 1
- Fixing index 2
- Fixing index 3
[root@support helpdesk]#