[mythtv-users] mythbackend fails (dead but subsys locked)

[jack dean]

Hi,

I have not ever gotten myth to work, or rather
lirc to work. Every thing I've tried has gone
down in flames. I must admit, this is the most
cantankerous piece of sw I've yet used.
Currently I get:
 /sbin/service mythbackend status
mythbackend dead but subsys locked
[root at satrecon mysql]# mythbackend
2005-04-19 09:56:40.996 New DB connection, total: 1
2005-04-19 09:56:41.006 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-04-19 09:56:41.008 New DB connection, total: 2
2005-04-19 09:56:41.010 Upgrading to schema version
1072
2005-04-19 09:56:41.011 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-19 09:56:41.012 Database Schema upgrade
FAILED, unlocking.
2005-04-19 09:56:41.012 Couldn't upgrade database to
new schema
[root at satrecon mysql]#   

I've tried to rebuild my database, I've tried to drop
this column, I've started from schratch and rebuilt
kernel and all dependencies from source.
Upgrading to myth 0.18 broke this, previously I could
not get lirc going.
Any advice would be appreciated.

bd


		
__________________________________ 
Do you Yahoo!? 
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide