LinHES Forums
http://forum.linhes.org/

Database Crash
http://forum.linhes.org/viewtopic.php?f=21&t=22302		 Page 1 of 1
Author:  gatorback [ Sat Nov 05, 2011 5:59 pm ]
Post subject:  Database Crash
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.*,
Author:  tjc [ Sat Nov 05, 2011 9:15 pm ]
Post subject: 
Start with the optimize database scripts, if those don't do it searching for "database repair" should turn up some write ups.
Author:  gatorback [ Sun Nov 06, 2011 10:54 am ]
Post subject:  Update
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.
Author:  mattbatt [ Sun Nov 06, 2011 8:51 pm ]
Post subject: 
most of my database errors came after hard crashes or power outages.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/