[mythtv-users] mythbackend fails on initial config
Bruce Markey
bjm at lvcm.com
Fri Dec 2 01:34:31 EST 2005
Scott Fones wrote:
> I can't seem to start mythbackend. I have mysql version 4.1.15 and
> the mc.sql database inserted. I have qt version 3.3.4 and mythtv
> version .18.1. Heres what I get when I try to run mythbackend
>
> mythbackend
> 2005-12-01 19:25:38.261 New DB connection, total: 1
> 2005-12-01 19:25:38.267 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.
> 2005-12-01 19:25:38.268 New DB connection, total: 2
> 2005-12-01 19:25:38.269 Told to create a NEW database schema, but the database
> already has 16 tables.
> If you are sure this is a good mythtv database, verify
> that the settings table has the DBSchemaVer variable.
>
> 2005-12-01 19:25:38.269 Database Schema upgrade FAILED, unlocking.
> 2005-12-01 19:25:38.269 Couldn't upgrade database to new schema
Well, it can't find a database schema version number which it
writes at the end of any update including the initial update.
There should be about 40 tables but you only have 16. Without
a DBSchemaVer it thinks it should install a fresh database but
you already have about 1/3 of the stuff there. There's the rub.
Whether or not you remember (or would admit to it ;-) the process
died or was killed the first time you ran a myth process.
$ mysql -u mythtv -pmythtv mythconverg
mysql> drop database mythconverg;
mysql> create database mythconverg;
mysql> quit
This will give you a clean, empty DB. Start mythtv-setup by itself
before running any other myth programs. Wait for it to finish
loading the database, uninterrupted, even if this takes a minute
or two.
-- bjm
More information about the mythtv-users
mailing list