[mythtv-users] Re: DB schema upgrade failing for .18
Henrik Bentel
hbentel at gmail.com
Sun Apr 24 01:55:52 UTC 2005
Tried running mythtv-setup first, no change. The setup prints the same
error message to stdout(see below).
starting mythbackend afterwards still gives same error message.
help!
-Henrik
[root at mythtvbox mythtv]# mythtv-setup
2005-04-23 20:49:15.571 New DB connection, total: 1
Total desktop width=1024, height=768, numscreens=1
2005-04-23 20:49:15.576 Using screen 0, 1024x768 at 0,0
2005-04-23 20:49:15.579 Setting Lock for Database Schema upgrade. If
you see a long pause here it means t
he Schema is already locked and is being upgraded by another Myth process.
2005-04-23 20:49:15.580 New DB connection, total: 2
2005-04-23 20:49:15.581 Upgrading to schema version 1072
2005-04-23 20:49:15.582 DB Error (Performing database upgrade):
Query was: ALTER TABLE program ADD COLUMN manualid INT UNSIGNED NOT
NULL DEFAULT 0;
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'manualid'
new version: 1072
2005-04-23 20:49:15.582 Database Schema upgrade FAILED, unlocking.
2005-04-23 20:49:15.621 Switching to square mode (G.A.N.T.)
mythtv: could not open config file /root/.mythtv/lircrc
mythtv: No such file or directory
Failed to read lirc config /root/.mythtv/lircrc for mythtv
2005-04-23 20:49:16.078 Joystick disabled.
On 4/23/05, Henrik Bentel <hbentel at gmail.com> wrote:
> Hi
>
> I'm having trouble upgrading to .18. Rather I upgrade (from .17 to .18
> , using atrpms ) and mythtvbackend process keeps dying.
> It attempts to upgrade the DB schema but this fails and the
> process dies. Log below.
>
> Hope someone can help
>
> -Henrik
>
> 2005-04-23 15:05:21.396 New DB connection, total: 1
> 2005-04-23 15:05:21.437 Setting Lock for Database Schema upgrade. If
> you see a long pause here it means the Schema is already locked and is
> being up
> graded by another Myth process.
> 2005-04-23 15:05:21.439 New DB connection, total: 2
> 2005-04-23 15:05:21.441 Upgrading to schema version 1072
> 2005-04-23 15:05:21.443 DB Error (Performing database upgrade):
> Query was: ALTER TABLE program ADD COLUMN manualid INT UNSIGNED NOT
> NULL DEFAULT 0;
> Error was: Driver error was [2/1060]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate column name 'manualid'
>
> new version: 1072
> 2005-04-23 15:05:21.445 Database Schema upgrade FAILED, unlocking.
> 2005-04-23 15:05:21.446 Couldn't upgrade database to new schema
>
More information about the mythtv-users
mailing list