[mythtv] Database schema problem

Mats Cedergren mythtv at cedinpro.com
Thu May 12 05:42:52 UTC 2005


Sometimes mythfrontend crashes on me with a segment fault error.  
There is nothing strange in this (since I use CVS version) but I get  
an strange error after the crash.

I get this message:
2005-05-11 23:30:12.550 New DB connection, total: 2
2005-05-11 23:30:12.559 Upgrading to schema version 1077
2005-05-11 23:30:12.617 New DB connection, total: 3
2005-05-11 23:30:12.630 Upgrading to schema version 1078
2005-05-11 23:30:12.648 Upgrading to schema version 1079
2005-05-11 23:30:12.649 DB Error (Performing database upgrade):
Query was: ALTER TABLE capturecard ADD COLUMN dvb_hw_decoder INT  
DEFAULT '0';
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'dvb_hw_decoder'

new version: 1079
2005-05-11 23:30:12.649 Database Schema upgrade FAILED, unlocking.


After I remove the the column dvb_hw_decoder and try to start again,  
I get another error on two more columns and after that the frontend  
starts without problem. If I shutdown the frontend via the menu, I  
don't get the error.

Does anybody have an suggestion/solution to this problem?

/Mats


More information about the mythtv-dev mailing list