View unanswered posts    View active topics

All times are UTC - 6 hours

Post new topic Reply to topic  [ 1 post ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Fri Aug 24, 2007 9:38 am 
Joined: Tue Apr 11, 2006 6:31 pm
Posts: 31
Location: Austin, TX
I had a hard lock on my mythbox requiring a reboot. On reboot I got a message like this...
dave@mythtv:~$ mythfrontend
2007-08-24 10:10:52.012 Using runtime prefix = /usr
2007-08-24 10:10:52.019 DPMS is not supported.
2007-08-24 10:10:52.064 New DB connection, total: 1
2007-08-24 10:10:52.071 Connected to database 'mythconverg' at host: localhost
2007-08-24 10:10:52.074 Total desktop dim: 1024x768, with 1 screen[s].
2007-08-24 10:10:52.088 Using screen 0, 1024x768 at 0,0
2007-08-24 10:10:52.126 Current Schema Version:
2007-08-24 10:10:52.127 Newest Schema Version : 1160
2007-08-24 10:10:52.128 New DB connection, total: 2
2007-08-24 10:10:52.129 Connected to database 'mythconverg' at host: localhost
2007-08-24 10:10:52.130 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
2007-08-24 10:10:52.131 New DB connection, total: 3
2007-08-24 10:10:52.132 Connected to database 'mythconverg' at host: localhost
2007-08-24 10:10:52.135 Told to create a NEW database schema, but the database
already has 75 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.

2007-08-24 10:16:02.979 Database Schema upgrade FAILED, unlocking.
2007-08-24 10:16:02.980 Couldn't upgrade database to new schema, exiting.

So I did
cd /var/lib/mysql/mythconverg
root@mythtv:/home/dave# mysql mythconverg -e "select * from settings order by value;"
ERROR 145 (HY000) at line 1: Table './mythconverg/settings' is marked as crashed and should be repaired

I guess I have to repair something

 /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.

root@mythtv:/var/lib/mysql/mythconverg# myisamchk *.MYI >> mythconverg_check.log
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Record at pos: 17044 is not remove-marked
myisamchk: error: record delete-link-chain corrupted
myisamchk: error: Found 456 keys of 455
myisamchk: error: Record-count is not ok; is 456          Should be: 455
myisamchk: warning: Found 80 deleted space.   Should be 128
myisamchk: warning: Found          3 deleted blocks       Should be: 4
MyISAM-table 'settings.MYI' is corrupted
Fix it using switch "-r" or "-o"

Corruption? Strange. Guess I better fix it...

 myisamchk -r *.MYI >> mythconverg_check.log

Next restarted sql

root@mythtv:/var/lib/mysql/mythconverg# /etc/init.d/mysql start                 Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..

and mythbackend

root@mythtv:/var/lib/mysql/mythconverg# /etc/init.d/mythtv-backend start        Starting MythTV server: mythbackend.

My only real question right now is did I just screw up something that I won't notice until later?

R5F27, asus K8V, athlon64 3000+, Air2pc HD5000, nvidia 6200 agp 8x


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

All times are UTC - 6 hours

Who is online

Users browsing this forum: No registered users and 2 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