cannot lock table parts blahblah after hdd crash

[Reab4]

Got a hdd crash. urddb_svn is actually not on the crashed hdd but probably due to the IDE (yes IDE) controller things got messy.

Could not execute SQL query "LOCK TABLE parts_18318 write" mysql error: [144: Table './urddb_svn/parts_18318' is marked as crashed and last (automatic?) repair failed] in EXECUTE("LOCK TABLE parts_18318 write")

What to do?
Due to this, urd is cycling activating/failing/pausing the boneless update.

Edit: svn 1628

[spearhead]

run mysqlcheck
see man mysqlcheck
or myisamchk

if nothing works, you're probably  out of luck and probably have to truncate the table or delete the entire db.

[thorwak]

I've seen this when I killed mysqld (yeah I know, bright move) when I figured "optimize database"  took too long from within URD (so I was new, gimme a break  )

Anyway, you should not loose the entire DB, at worst the parts_18318. Quickest fix, if you can live with it, is to purge that group (or purge the table manually) and rebuild it. Probably it's just not considered "consistent" since mysqld died when your IDE problem happened, and you will not loose any data (my guess).

I was able to fix my table (fairly big one btw) by using myisamchk as suggested by spearhead. (mysql should be stopped when doing this)

Here's some fairly straightforward info
http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html

[Reab4]

Thanks for the info. I decided to take the quick route to get it over with and delete the whole db.