[mythtv-users] major db problem upgrading from 0.21-fixes to 0.22

Audio Phile da_audiophile at yahoo.com
Sat Mar 6 23:23:41 UTC 2010


I'm running a LinHES box (distro based on Arch) and have experienced a horrible problem while upgrading from 0.21-fixes to 0.22.  I have all the packages installed, but for some reason my database contains errors that prevent it from being upgraded to 0.22.

Here is a clip of my /var/log/mythtv/mythbackend.log

2010-03-06 18:08:58.534 Using runtime prefix = /usr
2010-03-06 18:08:58.633 Using configuration directory = /home/mythtv/.mythtv
2010-03-06 18:08:58.659 Empty LocalHostName.
2010-03-06 18:08:58.683 Using localhost value of mythtv
2010-03-06 18:08:58.714 New DB connection, total: 1
2010-03-06 18:08:58.737 Connected to database 'mythconverg' at host: localhost
2010-03-06 18:08:58.759 Closing DB connection named 'DBManager0'
2010-03-06 18:08:58.784 Connected to database 'mythconverg' at host: localhost
2010-03-06 18:08:58.811 Current MythTV Schema Version (DBSchemaVer): 1215
2010-03-06 18:08:58.834 MythTV database schema is old. Waiting to see if DB is being upgraded.
2010-03-06 18:08:59.859 New DB connection, total: 2
2010-03-06 18:08:59.908 Connected to database 'mythconverg' at host: localhost
2010-03-06 18:08:59.952 Current MythTV Schema Version (DBSchemaVer): 1215
2010-03-06 18:09:00.977 Current MythTV Schema Version (DBSchemaVer): 1215
2010-03-06 18:09:02.017 Current MythTV Schema Version (DBSchemaVer): 1215
2010-03-06 18:09:03.083 Current MythTV Schema Version (DBSchemaVer): 1215
2010-03-06 18:09:04.156 Current MythTV Schema Version (DBSchemaVer): 1215
2010-03-06 18:09:04.220 Timed out waiting.
2010-03-06 18:09:04.251 Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
2010-03-06 18:09:08.404 Database Backup complete.
2010-03-06 18:09:08.484 Backed up database to file: '/myth/tv/mythconverg-1215-20100306180904.sql.gz'
2010-03-06 18:09:08.516 Console is non-interactive, can't prompt user...
2010-03-06 18:09:08.548 Upgrading.
2010-03-06 18:09:08.649 Newest MythTV Schema Version : 1244
2010-03-06 18:09:10.425 New DB connection, total: 3
2010-03-06 18:09:10.483 Connected to database 'mythconverg' at host: localhost
2010-03-06 18:09:10.505 Upgrading to MythTV schema version 1216
2010-03-06 18:09:12.808 DB Error (Performing database upgrade):
Query was: ALTER TABLE program  MODIFY title varbinary(128) NOT NULL default '',  MODIFY subtitle varbinary(128) NOT NULL default '',  MODIFY description blob NOT NULL,  MODIFY category varbinary(64) NOT NULL default '',  MODIFY category_type varbinary(64) NOT NULL default '',  MODIFY title_pronounce varbinary(128) NOT NULL default '',  MODIFY seriesid varbinary(40) NOT NULL default '',  MODIFY showtype varbinary(30) NOT NULL default '',  MODIFY colorcode varbinary(20) NOT NULL default '',  MODIFY syndicatedepisodenumber varbinary(20) NOT NULL default '',  MODIFY programid varbinary(40) NOT NULL default '';
Error was: Driver error was [2/1054]:
QMYSQL3: Unable to execute statement
Database error was:
Unknown column 'title_pronounce' in 'program'
 
new version: 1216
2010-03-06 18:09:12.841 DB charset conversions update failed! Your database seems to be partially corrupted. Please move the backup to a safe place. Your database must be fixed before you can upgrade beyond 0.21-fixes. Please see http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding for information.
2010-03-06 18:09:12.866 Database Schema upgrade FAILED, unlocking.
2010-03-06 18:09:12.891 Couldn't upgrade database to new schema
2010-03-06 18:09:13.049 mythbackend version: branches/release-0-22-fixes [23566M] www.mythtv.org

I have no idea what these errors are nor how to resolve them.  Any advise is greatly appreciated.


      


More information about the mythtv-users mailing list