[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