[mythtv] Database schema problem
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
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?
More information about the mythtv-dev