[mythtv-users] trunk could not upgrade DB schema from 1215 with fixed corrupted DB encoding

mikp mikpolniak at roadrunner.com
Thu Jun 25 16:21:02 UTC 2009


On Thu, 25 Jun 2009 08:47:23 -0400
"Michael T. Dean" <mtdean at thirdcontact.com> wrote:

> On 06/25/2009 07:48 AM, mikp wrote:
> > Since my DB was originally created on gentoo (currently running Slackware)
> 
> Note that if you changed from Gentoo MySQL server to a Slackware MySQL 
> server (and assuming that Slack's server was set with latin1 encoding) 
> /before/ fixing the corruption from running with an unsupported MySQL 
> server configuration, you would have had partially corrupt data--which 
> the instructions in the wiki will not fix (it would basically invert the 
> corruption--what was corrupt (when running on Gentoo) becomes uncorrupt 
> and what wasn't corrupt (when running on Slackware) becomes corrupt).
> 
> >  i followed the sphery wiki: "Fixing_Corrupt_Database_Encoding" to set character set to 'latin1'
> > and restore the _un_corrupted database. But with trunk svn 20741 and starting mythbackend shows this error:
> >
> >
> > Warning: MythTV wants to upgrade your database,
> > for the TV schema, from 1215 to 1235.
> >   
> 
> Were you running an extremely old trunk version?  The current 0.21-fixes 
> schema version is 1214, so the 1215 may indicate a problem (using a 
> broken/unsupported patch on -fixes that changed your DB schema).  Then 
> again, it may just be that you attempted the upgrade already once before 
> and the 1215 upgrade succeeded and it failed on the 1216 upgrade (as below).
> 
> > Database Host: 192.168.15.5
> > Database Name: mythconverg
> >
> > If your system becomes unstable, a database backup is located in /mnt/store2/mythconverg-1215-20090625072803.sql.gz
> >
> >
> > Shall I upgrade this database? [yes]  yes
> >
> > A database backup might be a good idea
> > Are you sure you want to upgrade? [no]  u^Hyes^Hyes
> > 2009-06-25 07:29:48.110 Newest Schema Version : 1235
> > 2009-06-25 07:29:48.113 Upgrading to schema version 1216
> > 2009-06-25 07:29:57.043 DB Error (Performing database upgrade): 
> > Query was: ALTER TABLE recorded  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 hostname 
> > varbinary(64) NOT NULL default '',  MODIFY recgroup varbinary(32) NOT NULL default 'Default',  MODIFY seriesid varbinary(40) NOT NULL default '',  MODIFY programid varbinary(40) NOT NULL default '',  MODIFY basename varbinary(255) NOT NULL,  MODIFY playgroup varbinary(32) NOT NULL default 'Default',  MODIFY profile varbinary(32) NOT NULL default '',  MODIFY storagegroup varbinary(32) NOT NULL default 'Default'; 
> > Error was: Driver error was [2/1283]:
> > QMYSQL3: Unable to execute statement
> > Database error was:
> > Column 'subtitle' cannot be part of FULLTEXT index
> >   
> 
> Something is wrong with your DB schema.  The recorded.subtitle column is 
> /not/ part of any indices in 0.21-fixes or trunk.  Did you perform any 
> modifications to your DB "to enhance performance" or are you running 
> with any patches?  As a matter of fact, I'm pretty sure there are no 
> FULLTEXT indices anywhere in the MythTV database schema.
> 
> Mike

I redid fixing the DB according to your instructions for a partial restore. Then the schema was updated:

Shall I upgrade this database? [yes]  yes

A database backup might be a good idea
Are you sure you want to upgrade? [no]  yes
2009-06-25 09:13:04.843 Newest Schema Version : 1235
2009-06-25 09:13:04.845 Upgrading to schema version 1215
2009-06-25 09:13:04.846 New DB connection, total: 3
2009-06-25 09:13:04.846 Connected to database 'mythconverg' at host: 192.168.15.5
2009-06-25 09:13:04.847 Upgrading to schema version 1216
2009-06-25 09:13:06.883 Upgrading to schema version 1217
2009-06-25 09:16:02.928 Upgrading to schema version 1218
2009-06-25 09:16:02.929 Upgrading to schema version 1219
2009-06-25 09:16:03.300 Upgrading to schema version 1220
2009-06-25 09:16:04.340 Upgrading to schema version 1221
2009-06-25 09:16:04.341 Upgrading to schema version 1222
2009-06-25 09:16:04.341 New DB connection, total: 4
2009-06-25 09:16:04.342 Connected to database 'mythconverg' at host: 192.168.15.5
2009-06-25 09:16:04.343 Upgrading to schema version 1223
2009-06-25 09:16:04.345 Upgrading to schema version 1224
2009-06-25 09:16:05.173 Upgrading to schema version 1225
2009-06-25 09:16:07.230 Upgrading to schema version 1226
2009-06-25 09:16:09.959 Upgrading to schema version 1227
2009-06-25 09:16:10.030 Upgrading to schema version 1228
2009-06-25 09:16:10.031 Upgrading to schema version 1229
2009-06-25 09:16:10.148 Upgrading to schema version 1230
2009-06-25 09:16:10.215 Upgrading to schema version 1231
2009-06-25 09:16:10.459 Upgrading to schema version 1232
2009-06-25 09:16:10.582 Upgrading to schema version 1233
2009-06-25 09:16:11.005 Upgrading to schema version 1234
2009-06-25 09:16:11.182 Upgrading to schema version 1235
2009-06-25 09:16:11.258 Database Schema upgrade complete, unlocking.
No setting found for this machine's BackendServerIP.
Please run setup on this machine and modify the first page
of the general settings.

Now i have trunk svn 20741 running and the DB seems OK so far in playing recordings,etc.

Thank you for your help and your wiki http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding



More information about the mythtv-users mailing list