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

Database Schema and other troubles
http://forum.linhes.org/viewtopic.php?f=6&t=5382		 Page 1 of 2
Author:  Escher0 [ Sun Jul 17, 2005 11:34 am ]
Post subject:  Database Schema and other troubles
I'm running R4V5 (haven't gotten around to upgrading).
For several days, myth has been freezing when told to delete a recording. It would delete it, but it had to be hard shutdown in order to get anywhere. Then one time, on reboot, the machine stopped at the desktop. If I try to run mythbackend from xterm I get this error:
Quote:
Told to create a NEW database schema but the database already has 38 tables.
If you are sure this is a good myth database, verify that the settings table has the DBSchemaVer variable.


From here http://mysettopbox.tv/phpBB2/viewtopic.php?t=2860#15525 I tried to run
Code:
mysql mythconverg -e "select * from settings order by value;"
but that gave
Quote:
Error 1146 at Line 1: Table mythconverg.settings doesn't exist


I found this http://www.gossamer-threads.com/lists/m ... 023#110946 but now when I try to run mythtvsetup, I get a command not found.

I'm starting to think the hard drive has had corruption or something. How can I check for this or whatever else this might be. Thanks in advance.
Author:  Xsecrets [ Sun Jul 17, 2005 12:51 pm ]
Post subject: 
on knoppmyth it's mythtv-setup
Author:  cesman [ Sun Jul 17, 2005 8:53 pm ]
Post subject: 
You should check your db for errors.
Author:  Escher0 [ Mon Jul 18, 2005 12:23 am ]
Post subject: 
how can I do that?
Author:  Xsecrets [ Mon Jul 18, 2005 12:24 am ]
Post subject: 
there's a sticky post in howto section
Author:  Escher0 [ Mon Jul 18, 2005 8:36 am ]
Post subject: 
thanks
Author:  Escher0 [ Fri Jul 22, 2005 8:30 am ]
Post subject: 
I've gone through everything in the thread on repairing the tables but nothing has come up with errors yet I still get the "database schema" error when trying to run the backend.

I think I now have an idea what caused the error though. hda4 is 98% full so what I'm guessing happened is that when it froze while deleting, it deleted the database entry but not the file itself. Does this make sense? And if it does, will manually deleting some old recordings help fix this?
Author:  cesman [ Sun Jul 24, 2005 9:49 pm ]
Post subject: 
No, it doesn't make sense as I've filled /myth when I was away on business for longer that I was originally scheduled.
Author:  Escher0 [ Sun Jul 24, 2005 10:06 pm ]
Post subject: 
is there anything else I should check for or do you think its time to wipe the database/reinstall?
Author:  Xsecrets [ Sun Jul 24, 2005 10:34 pm ]
Post subject: 
generally the problem is that it deletes the file, but not the db entry. I've had this happen then I go into mythweb find out what it thinks the filename is and do a touch 2335664234352234(whatever filename is supopsed to be).nuv in the /myth/tv dir and delete it again and all was happy.
Author:  Escher0 [ Tue Jul 26, 2005 9:02 am ]
Post subject: 
my backend is not running however so will mythweb still function? I thought mythweb required the backend.
Author:  alewman [ Tue Jul 26, 2005 11:51 pm ]
Post subject: 
Xsecrets wrote:
I've had this happen then I go into mythweb find out what it thinks the filename is and do a touch 2335664234352234


Oh cool. I've had this happen to me before and didn't know how to delete the file. Thanks for the tip!!!

-Aubrey
Author:  Xsecrets [ Wed Jul 27, 2005 7:45 am ]
Post subject: 
if you can't make the backend run forget what I said as that is not your problem as file/db mismatch will not keep the backend from running.
Author:  Escher0 [ Wed Jul 27, 2005 6:57 pm ]
Post subject: 
so I take it its time to reinstall?
Author:  tjc [ Wed Jul 27, 2005 8:25 pm ]
Post subject: 
Possibly. You might want to try a back up and if what it dumps out of the DB looks OK, an upgrade.
Page 1 of 2 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/