[mythtv-users] DB Error (Performing database upgrade):

[A JM]

I'm getting the following error? Is this a lock file that didn't get
deleted? Any ideas on how to fix?


mythtv at mythtv2:~$ mythbackend
2007-01-28 21:58:23.387 Using runtime prefix = /usr/local
2007-01-28 21:58:23.425 New DB connection, total: 1
2007-01-28 21:58:23.431 Connected to database 'mythconverg' at host: localhost
2007-01-28 21:58:23.437 Current Schema Version: 1177
2007-01-28 21:58:23.438 Newest Schema Version : 1178
2007-01-28 21:58:23.439 New DB connection, total: 2
2007-01-28 21:58:23.440 Connected to database 'mythconverg' at host: localhost
2007-01-28 21:58:23.440 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.
2007-01-28 21:58:23.442 New DB connection, total: 3
2007-01-28 21:58:23.442 Connected to database 'mythconverg' at host: localhost
2007-01-28 21:58:23.444 Upgrading to schema version 1178
2007-01-28 21:58:23.444 DB Error (Performing database upgrade):
Query was: ALTER TABLE channel           DROP INDEX sourceid;
Error was: Driver error was [2/1091]:
QMYSQL3: Unable to execute query
Database error was:
Can't DROP 'sourceid'; check that column/key exists