Matt Vollmar wrote:
Hi all,
I've searched the archives and found some related content, but never an answer other than "Blow away the DB and reload it". Anyway, I've had some recent stability problems with both my box and specifically mythbackend. I upgraded to the latest version of Mandrake Cooker and that seemed to clear up the box stability issues, but mythbackend still crashes randomly.
However, the real problem for me is that yesterday I had some mythbackend/mysql connectivity issues, so I rebooted the backend. I wanted to watch a show after that, so I tried to connect my laptop at which time I got the following error:
Told to create a NEW database schema, but the database already has 61 tables. If you are sure this is a good mythtv database, verify that the settings table has the *DBSchemaVer* variable.
I checked and that variable exists and is set to "1057". My backend also runs the frontend and connects just fine. So I tried changing the hostname on my laptop (in mysql.txt and the actual hostname), but it still gives the same error. I do not want to blow away my DB unless absolutely necessary. I'm sure I could set it up again just fine, but that seems overkill to me. What sorts of things can I look for in the DB? Why does mythfrontend want to create a new DB? I thought only mythtvsetup did that.
Thanks for any insight.
Matt
Just thought I would share my fix for this, since no one else seemed to have insight. I found ran mythtvsetup on my backend in order to do some reconfiguring and when I tried to connect with my remote frontend, it connected. I put it together immediately. Next, I found that my frontend would stop connecting whenever the backend happens to crash. Starts spewing the same error as above. So, for some reason, when the backend crashes (probably the bug having something to do with the 2.6.10 kernel), it leaves the DB in a funky state. Running mythtvsetup fixes the issue. Now I just need the 2.6.10 issue solved, which may come with Myth .17 (I hope). Just waiting on Thac.
Matt _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
