LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-27-2016, 10:48 PM   #1
timl
Member
 
Registered: Jan 2009
Location: Sydney, Australia
Distribution: Fedora,CentOS
Posts: 722

Rep: Reputation: 152Reputation: 152
mysql problem on website


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
 
Old 08-28-2016, 05:10 AM   #2
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,591

Rep: Reputation: 145Reputation: 145
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.

Last edited by j-ray; 08-28-2016 at 05:14 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Kiss your MySQL website goodbye? LXer Syndicated Linux News 0 03-23-2010 07:30 AM
[SOLVED] website not doing anything Using Ubuntu, mysql, apache2, php and firefox as browser drk2009 Linux - Newbie 4 07-30-2009 06:01 AM
Website won't collect data from mysql db Malcome_thompson Programming 1 05-26-2008 11:03 PM
Slow to browse MySQL database driven website on home server Broady Linux - Newbie 2 11-04-2007 06:47 PM
Website CMS without running Web Server, mySQL, PHP etc. derddera Linux - Software 1 08-15-2004 01:45 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:12 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration