[mythtv-users] Database upgrade fails from 0.18.1 to 0.19

Ramon Redondo malinon at gmail.com
Mon Feb 13 23:34:04 UTC 2006


On 2/13/06, Neil M. <nabber00 at hotmail.com> wrote:
>
> When trying to run mythbackend I get the following error:
>
> 2006-02-13 12:47:31.049 Using runtime prefix = /usr/local
> 2006-02-13 12:47:31.070 New DB connection, total: 1
> 2006-02-13 12:47:31.073 Connected to database 'mythconverg' at host:
> localhost
> 2006-02-13 12:47:31.078 Current Schema Version:
> 2006-02-13 12:47:31.080 Newest Schema Version : 1123
> 2006-02-13 12:47:31.081 New DB connection, total: 2
> 2006-02-13 12:47:31.083 Connected to database 'mythconverg' at host:
> localhost
> 2006-02-13 12:47:31.084 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.
> 2006-02-13 12:47:31.086 New DB connection, total: 3
> 2006-02-13 12:47:31.087 Connected to database 'mythconverg' at host:
> localhost
> 2006-02-13 12:47:31.090 Told to create a NEW database schema, but the
> database
> already has 36 tables.
> If you are sure this is a good mythtv database, verify
> that the settings table has the DBSchemaVer variable.
>
> 2006-02-13 12:47:31.091 Database Schema upgrade FAILED, unlocking.
> 2006-02-13 12:47:31.092 Couldn't upgrade database to new schema
>
> Running mythtv-setup doesn't help either, I get a bunch of errors about
> 'mythconverg.settings' not existing, I assume since the database isn't
> properly upgraded.  Does anyone have any ideas?  I'd really like to keep
> my
> old data if at all possible.  Thanks.
>
> Neil



I'd suggest restoring your database from the backup you made according to
1.3 of the docs:
http://www.mythtv.org/docs/mythtv-HOWTO-1.html#ss1.3
http://www.mythtv.org/docs/mythtv-HOWTO-23.html#backupdb
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060213/5f17c02e/attachment.htm


More information about the mythtv-users mailing list