[mythtv-users] DB Error (Performing database upgrade from .19 to .20)

Sdkovacs sdkovacs at gmail.com
Wed Sep 13 03:46:01 UTC 2006


I am upgrading from .19 to .20 using ATRPMS on FC3. After using smart
to upgrade the packages I rebooted the machine and this came up in
mythbackend.log:

006-09-12 23:32:10.508 MainServer::HandleAnnounce Monitor
2006-09-12 23:32:10.511 adding: localhost.localdomain as a client (events: 0)
2006-09-12 23:32:10.515 MainServer::HandleAnnounce Monitor
2006-09-12 23:32:10.517 adding: localhost.localdomain as a client (events: 1)
2006-09-12 23:33:23.155 MainServer::HandleAnnounce Monitor
2006-09-12 23:33:23.160 adding: localhost.localdomain as a client (events: 0)
2006-09-12 23:33:31.270 MainServer::HandleAnnounce Monitor
2006-09-12 23:33:31.274 adding: localhost.localdomain as a client (events: 0)
2006-09-12 23:36:59.912 Using runtime prefix = /usr
2006-09-12 23:37:00.848 New DB connection, total: 1
2006-09-12 23:37:00.950 Connected to database 'mythconverg' at host: localhost
2006-09-12 23:37:01.126 Current Schema Version: 1153
2006-09-12 23:37:01.171 Newest Schema Version : 1160
2006-09-12 23:37:01.243 New DB connection, total: 2
2006-09-12 23:37:01.316 Connected to database 'mythconverg' at host: localhost
2006-09-12 23:37:01.318 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.
2006-09-12 23:37:01.345 New DB connection, total: 3
2006-09-12 23:37:01.357 Connected to database 'mythconverg' at host: localhost
2006-09-12 23:37:01.361 Upgrading to schema version 1154
2006-09-12 23:37:01.455 DB Error (Performing database upgrade):
Query was: ALTER TABLE capturecard ADD diseqcid INT(10) UNSIGNED default NULL;
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'diseqcid'

new version: 1154
2006-09-12 23:37:01.469 Database Schema upgrade FAILED, unlocking.
2006-09-12 23:37:01.471 Couldn't upgrade database to new schema


More information about the mythtv-users mailing list