[mythtv-users] error during upgrade database from 1019

[Scott Bickford]

I'm on .27-fixes.  This was a .25-fixes db:

2014-10-26 15:54:36.670293 I  Current MythTV Schema Version (DBSchemaVer):
1317

...
2014-10-26 15:54:36.894371 I  Current MythMusic Schema Version
(MusicDBSchemaVer): 1019
2014-10-26 15:54:36.901664 E  Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2014-10-26 15:54:37.069205 E  DBUtil: Error backing up database:
/usr/share/mythtv/mythconverg_backup.pl  /tmp/mythtv_db_backup_conf_rOWVav
(2)
2014-10-26 15:54:37.069218 C  Script-based database backup failed. Retrying
with internal backup.
2014-10-26 15:54:37.070650 C  Backing up database to file:
'/mnt/storage1/recordings/mythconverg-1317-20141026195437.sql'
2014-10-26 15:54:37.169586 E  DBUtil: Error backing up database: 'mysqldump
--defaults-extra-file='/tmp/mythtv_db_backup_conf_eXOc1O'
--host='localhost' --port='3306' --user='mythtv' --add-drop-table
--add-locks --allow-keywords --complete-insert --extended-insert
--lock-tables --no-create-db --quick 'mythconverg' >
'/mnt/storage1/recordings/mythconverg-1317-20141026195437.sql' 2>/dev/null'
(2)
2014-10-26 15:54:37.240926 I  Bonjour: Service registration complete: name
'Mythfrontend on localhost.localdomain' type '_mythfrontend._tcp.' domain:
'local.'
2014-10-26 15:54:37.589517 I  Bonjour: Service registration complete: name
'MythTV on localhost.localdomain' type '_airplay._tcp.' domain: 'local.'
2014-10-26 15:55:06.306648 N  Event socket closed.  No connection to the
backend.
2014-10-26 15:55:12.777763 N  Upgrading to MythMusic schema version 1020
2014-10-26 15:55:12.809399 E  DB Error (Performing database upgrade):
Query was: CREATE TABLE music_radios (    intid INT UNSIGNED AUTO_INCREMENT
NOT NULL PRIMARY KEY,    station VARCHAR(128) NOT NULL,    channel
VARCHAR(128) NOT NULL,    url VARCHAR(128) NOT NULL,    logourl
VARCHAR(128) NOT NULL,    genre VARCHAR(128) NOT NULL,    metaformat
VARCHAR(128) NOT NULL,    format VARCHAR(10) NOT NULL,    INDEX
(station),    INDEX (channel));
Error was: Driver error was [2/1050]:
QMYSQL: Unable to execute query
Database error was:
Table '`mythconverg`.`music_radios`' already exists

new version: 1020
2014-10-26 15:55:12.809415 E  Database schema upgrade failed.
2014-10-26 15:55:12.809834 E  Couldn't upgrade music database schema,
exiting.
2014-10-26 15:55:12.809854 E  Unable to initialize plugin 'mythmusic'.

Looking at phpmyadmin, I don't see music_radios.  I also ran a mysql in
case phpmyadmin was caching somehow.  I can do a select * From music_genres
ok.


I tried running this both as root and mythtv and it seems to give the same
with the backup portion.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141026/89430862/attachment.html>