[mythtv] database upgrade error in latest cvs?
Peter Lee
peteratcmu at gmail.com
Thu Feb 3 19:36:32 UTC 2005
Hi. I have been running cvs for several months on both a master
front/back end system and also a slave backend system. Late this
morning I did a cvs update on master. When this appeared to be
working ok, I then updated the slave. However, the slave backend
fails on startup, with this message in its log:
======
2005-02-03 14:23:33.402 Upgrading to schema version 1066
2005-02-03 14:23:33.404 DB Error (Performing database upgrade):
Query was: ALTER TABLE capturecard ADD COLUMN firewire_port INT
UNSIGNED NOT NULL DEFAULT 0;
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'firewire_port'
new version: 1066
2005-02-03 14:23:33.404 Couldn't upgrade database to new schema
======
Note that the slave's mysql.txt is pointing to the master's DB
appropriately. I checked on the master and there is indeed already a
"firewire_port" column. So is there a problem with the slave also
trying to add this column? Or perhaps I've forgotten something stupid
here...
Anyway, my slave is dead until this is figured out.
Peter
More information about the mythtv-dev
mailing list