View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 4 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: Database Crash
PostPosted: Sat Nov 05, 2011 5:59 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
I observed the following when using the web access for the listings:

Not sure what needs to be done. Is there a procedure documented out there for this problem?

Complete message is here: http://pastebin.com/BBaq9L0G

Quote:
datetime: 2011-11-05 19:58:14 (EDT)
errornum: 256
error type: User Error
error string: SQL Error: Table './mythconverg/credits' is marked as crashed and should be repaired [#145]
filename: /data/srv/httpd/htdocs/mythweb/classes/Database/Query/mysql.php
error line: 83

==========================================================================

Backtrace:

file: /data/srv/httpd/htdocs/mythweb/classes/Database/Query/mysql.php
line: 83
class:
function: trigger_error
type:
args: Array
(
[0] => SQL Error: Table './mythconverg/credits' is marked as crashed and should be repaired [#145]
[1] => 256
)

file: /data/srv/httpd/htdocs/mythweb/classes/Database.php
line: 263
class: Database_Query_mysql
function: execute
type: ->
args: Array
(
[0] => Array ( )
)

file: /data/srv/httpd/htdocs/mythweb/modules/tv/includes/programs.php
line: 166
class: Database
function: query
type: ->
args: Array
(
[0] => SELECT program.*,

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Sat Nov 05, 2011 9:15 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Start with the optimize database scripts, if those don't do it searching for "database repair" should turn up some write ups.


Top
 Profile  
 
 Post subject: Update
PostPosted: Sun Nov 06, 2011 10:54 am 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
UPDATE
======
This database is repaired, however, I am not sure what caused this, and as a result, concerned that this could happen again. I am not sure that I can pin this to this Fuppes problem, which immediately preceded the database symptoms.

This is really more of a log, of what I did: in case anyone else experiences this problem or I (heaven forbid) have to revisit this problem in the future.

I was given the instructions (thanks: marc.aronson):

Quote:
• Make a database backup using mythbackup.
1 sv stop mythbackend
2 sv stop mysql
3 cd /data/srv/mysql/mythconverg
4 myisamchk –r *.MYI
5 myisamchk –a *.MYI
6 sv start mysql
7 sv start mythbackend



I ran the database backup procedure:

Code:
[root@mythtv ~]# /usr/share/mythtv/mythconverg_backup.pl --verbose


I posted the results in pastebin. I observed the script response:

Quote:
mysqldump: Got error: 145: Table './mythconverg/credits' is marked as crashed and should be repaired when using LOCK TABLES


I ran steps 2-7 (detailed responses in pastebin) and rebooted the system. Checked the TV listings and found database errors instead.

SECOND ATTEMPT
============
Executed:
Code:
/usr/LH/bin/mythbackup -verbose

and "Backup passes all checks."

I ran steps 2-7 and checked the TV listings: listings and scheduled recordings successfully restored.

I noticed that cut and paste of the command

Code:
myisamchk -r *.MYI


was copied (miscopied) as : myisamchk .r *.MYI

This explains the ill-fated first attempt to repair the database.

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Sun Nov 06, 2011 8:51 pm 
Offline
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1343
Location: Orlando FL
most of my database errors came after hard crashes or power outages.

_________________
My System


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu