[mythtv-users] error during upgrade database from 1019

Scott Bickford bic1ster at gmail.com
Mon Oct 27 00:50:47 UTC 2014


I tried starting with empty db, then running mythtv-setup and sitll got the
weather error.  Not sure what was going wrong, but after some reading,  I
used the restore script

/usr/share/mythtv/mythconverg_restore.pl --drop_database --create_database
--filename mythconverg.sql --directory /root

and everything seems much better.


On Sun, Oct 26, 2014 at 5:05 PM, Scott Bickford <bic1ster at gmail.com> wrote:

> 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/03b1f62a/attachment.html>


More information about the mythtv-users mailing list