mysql problem on website

timl · 08-27-2016, 10:48 PM

Hi, I use a file sharing website which crashes every few months. The owner has a maintenance person who normally fixes these crashes but this time that person has gone AWOL. The error you see when accessing the site is mysql related (in fact this error pops up sporadically but normally rights itself - this time it is more serious and the site has been out of action for several days)

My own mysql knowledge is limited but I asked whether I could help (the owner is not tech savvy) and this is the log which was passed:

Quote:

MySQL Error: Table 'torrents' is marked as crashed and should be repaired {Error No: 1194 - File: /rss.php}.. The query was: SELECT torrents.seeders, torrents.leechers, torrents.filename, torrents.name, torrents.owner, torrents.descr, torrents.size, torrents.added, torrents.times_completed, torrents.id, torrents.anonymous, categories.name AS cat_name, u.username FROM torrents LEFT JOIN categories ON torrents.category = categories.id LEFT JOIN users u ON (torrents.owner=u.id) WHERE category IN (99, 7, 43, 11, 12, 16, 100, 121, 23, 111, 49, 123, 50, 19, 114, 8, 20, 18, 21, 101) AND visible='yes' AND banned='no' AND (INSTR(CONCAT(',',categories.canview,',',',[ALL],' > 0 OR INSTR(CONCAT(',',categories.canview,',',',1,' > 0) ORDER BY added DESC LIMIT 5

MySQL Error: Can't find record in 'torrents' {Error No: 1032 - File: /rss.php}.. The query was: SELECT torrents.seeders, torrents.leechers, torrents.filename, torrents.name, torrents.owner, torrents.descr, torrents.size, torrents.added, torrents.times_completed, torrents.id, torrents.anonymous, categories.name AS cat_name, u.username FROM torrents LEFT JOIN categories ON torrents.category = categories.id LEFT JOIN users u ON (torrents.owner=u.id) WHERE category IN (124, 25) AND visible='yes' AND banned='no' AND (INSTR(CONCAT(',',categories.canview,',',',[ALL],' > 0 OR INSTR(CONCAT(',',categories.canview,',',',1,' > 0) ORDER BY added DESC LIMIT 50

I have taken a lead from the first line "marked as crashed". I guess this is the first issue to be addressed. A trawl around the net suggests

Quote:

REPAIR TABLE torrents;

As I can't see any other relevant information, is this a sensible course of action? Is a mysqldump recommended first?

Regards

j-ray · 08-28-2016, 05:10 AM

I would definetely not call mysqldump first. As this seem to be a recurring problem the admin should probably change the disk the mysql uses for data storage.